View In:   ArcGIS Online Map Viewer

Name: Water Device

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a6808dfc404d4486bd8e431798cbb30c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 3001.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2507051.9733914956
YMin: 789732.2952868193
XMax: 2548928.498890247
YMax: 860758.8999524862
Spatial Reference: 3444  (3444)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [120, 120, 120, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset Group, editable: true, nullable: false, defaultValue: 0, modelName: ASSETGROUP, required: true )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, nullable: false, defaultValue: 0, modelName: ASSETTYPE, required: true )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association Status, editable: false, nullable: false, defaultValue: 0, modelName: ASSOCIATIONSTATUS, required: true , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISSUBNETWORKCONTROLLER ( type: esriFieldTypeSmallInteger, alias: Is Subnetwork Controller, editable: false, nullable: false, defaultValue: 0, modelName: ISSUBNETWORKCONTROLLER, required: true , Coded Values: [0: False] , [1: True] )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is Connected, editable: false, nullable: false, defaultValue: 2, modelName: ISCONNECTED, required: true , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• SUBNETWORKCONTROLLERNAME ( type: esriFieldTypeString, alias: Subnetwork Controller Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUBNETWORKCONTROLLERNAME, required: true )
• TIERNAME ( type: esriFieldTypeSmallInteger, alias: Tier Name, editable: false, nullable: false, defaultValue: 0, modelName: TIERNAME, required: true , Coded Values: [0: Unknown] , [1: Water System] , [2: Water Pressure] )
• TIERRANK ( type: esriFieldTypeInteger, alias: Tier Rank, editable: false, nullable: false, defaultValue: 0, modelName: TIERRANK, required: true )
• TERMINALCONFIGURATION ( type: esriFieldTypeString, alias: Terminal Path, editable: true, nullable: false, length: 128, defaultValue: Default, modelName: TERMINALCONFIGURATION, required: true )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SystemSubnetworkName, required: true )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTEDSUBNETWORKNAME, required: true )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTINGSUBNETWORKNAME, required: true )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: PressureSubnetworkName, required: true )
• diameter ( type: esriFieldTypeDouble, alias: Diameter - Imperial, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• pressure ( type: esriFieldTypeDouble, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: pressure )
• designtype ( type: esriFieldTypeSmallInteger, alias: Design Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• normalstatus ( type: esriFieldTypeSmallInteger, alias: Normal Status, editable: true, nullable: true, defaultValue: null, modelName: normalstatus , Coded Values: [0: Closed] , [1: Open] )
• operable ( type: esriFieldTypeSmallInteger, alias: Closeable, editable: true, nullable: true, defaultValue: 1, modelName: operable , Coded Values: [0: No] , [1: Yes] )
• name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: name )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 2, modelName: lifecyclestatus , Coded Values: [0: Out of Service] , [1: Proposed] , [2: In Service] , ...3 more... )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: Creation Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: Edit Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• constructionstatus ( type: esriFieldTypeSmallInteger, alias: Construction Status, editable: true, nullable: true, defaultValue: 6, modelName: constructionstatus , Coded Values: [0: Warehouse] , [1: Abandoned] , [2: Removed] , ...5 more... )
• symbolrotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation )
• diameter_metric ( type: esriFieldTypeDouble, alias: Diameter - Metric, editable: true, nullable: true, defaultValue: null, modelName: diameter_metric )
• facilityid ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: facilityid )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• locdesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: locdesc )
• valvetype ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: valvetype , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...5 more... )
• bypassvalve ( type: esriFieldTypeSmallInteger, alias: Bypass Valve, editable: true, nullable: true, defaultValue: 0, modelName: bypassvalve , Coded Values: [0: False] , [1: True] )
• clocktoclose ( type: esriFieldTypeSmallInteger, alias: Clockwise To Close, editable: true, nullable: true, defaultValue: 1, modelName: clocktoclose , Coded Values: [0: False] , [1: True] )
• normallyopen ( type: esriFieldTypeSmallInteger, alias: Normally Open, editable: true, nullable: true, defaultValue: 1, modelName: normallyopen , Coded Values: [0: False] , [1: True] )
• hydrflag ( type: esriFieldTypeSmallInteger, alias: Hydrant Valve, editable: true, nullable: true, defaultValue: 0, modelName: hydrflag , Coded Values: [0: False] , [1: True] )
• curropen ( type: esriFieldTypeSmallInteger, alias: Currently Open, editable: true, nullable: true, defaultValue: 1, modelName: curropen , Coded Values: [0: False] , [1: True] )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: enabled , Coded Values: [0: False] , [1: True] )
• activeflag ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: activeflag , Coded Values: [0: False] , [1: True] )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• lastupdate ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastupdate )
• lasteditor ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: lasteditor )
• x ( type: esriFieldTypeDouble, alias: X, editable: true, nullable: true, defaultValue: null, modelName: x )
• gps_date ( type: esriFieldTypeString, alias: GPS_DATE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: gps_date )
• y ( type: esriFieldTypeDouble, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: y )
• z ( type: esriFieldTypeDouble, alias: Z, editable: true, nullable: true, defaultValue: null, modelName: z )
• rotation ( type: esriFieldTypeString, alias: Rotation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: rotation )
• turns_to_close ( type: esriFieldTypeDouble, alias: Turns to Close, editable: true, nullable: true, defaultValue: null, modelName: turns_to_close )
• hydrant_id ( type: esriFieldTypeString, alias: Hydrant ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: hydrant_id )
• manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: manufacturer , Coded Values: [Corey: Corey] , [Kennedy Valve: Kennedy Valve] , [M&H Valve: M&H Valve] , ...14 more... )
• notes1 ( type: esriFieldTypeString, alias: notes1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes1 )
• notes2 ( type: esriFieldTypeString, alias: notes2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes2 )
• exercise_date ( type: esriFieldTypeDate, alias: EXERCISE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: exercise_date )
• exercise_operator ( type: esriFieldTypeString, alias: EXERCISE_OPERATOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: exercise_operator )
• exercise_turns ( type: esriFieldTypeDouble, alias: EXERCISE_TURNS, editable: true, nullable: true, defaultValue: null, modelName: exercise_turns )
• exercise_position ( type: esriFieldTypeString, alias: EXERCISE_POSITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: exercise_position )
• exercise_high_torque ( type: esriFieldTypeSmallInteger, alias: EXERCISE_HIGH_TORQUE, editable: true, nullable: true, defaultValue: null, modelName: exercise_high_torque )
• exercise_remarks ( type: esriFieldTypeString, alias: EXERCISE_REMARKS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: exercise_remarks )
• exercise_remarks_description ( type: esriFieldTypeString, alias: EXERCISE_REMARKS_DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: exercise_remarks_description )
• flow ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: flow )
• facility_id ( type: esriFieldTypeDouble, alias: Facility_ID, editable: true, nullable: true, defaultValue: null, modelName: facility_id )
• location_desc ( type: esriFieldTypeString, alias: Location_Desc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: location_desc )
• color ( type: esriFieldTypeString, alias: Color, editable: true, nullable: true, length: 255, defaultValue: null, modelName: color )
• size ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: size )
• main_diameter ( type: esriFieldTypeSmallInteger, alias: Main_Diameter, editable: true, nullable: true, defaultValue: null, modelName: main_diameter )
• main_material ( type: esriFieldTypeString, alias: Main_Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: main_material )
• last_service ( type: esriFieldTypeDate, alias: Last_Service, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_service )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• install_date ( type: esriFieldTypeString, alias: Install_Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: install_date )
• static ( type: esriFieldTypeSmallInteger, alias: Static Pressure (PSI), editable: true, nullable: true, defaultValue: null, modelName: static )
• residual ( type: esriFieldTypeSmallInteger, alias: Residual Pressure (PSI), editable: true, nullable: true, defaultValue: null, modelName: residual )
• manufacture_year ( type: esriFieldTypeString, alias: Manufacture Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: manufacture_year )
• last_inspection ( type: esriFieldTypeDate, alias: Last_Inspeciton_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_inspection )
• book_id ( type: esriFieldTypeString, alias: Book ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: book_id )
• facility_id2 ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: facility_id2 )
• avaliable_flow ( type: esriFieldTypeDouble, alias: Avaliable_Flow, editable: true, nullable: true, defaultValue: null, modelName: avaliable_flow )
• note1 ( type: esriFieldTypeString, alias: NOTE1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: note1 )
• note2 ( type: esriFieldTypeString, alias: NOTE2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: note2 )
• location_no ( type: esriFieldTypeInteger, alias: Location No, editable: true, nullable: true, defaultValue: null, modelName: location_no )
• book ( type: esriFieldTypeInteger, alias: Book, editable: true, nullable: true, defaultValue: null, modelName: book )
• customer_number ( type: esriFieldTypeString, alias: Customer Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: customer_number )
• service_address ( type: esriFieldTypeString, alias: Service Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: service_address )
• emr_id ( type: esriFieldTypeDouble, alias: EMR ID, editable: true, nullable: true, defaultValue: null, modelName: emr_id )
• read_type ( type: esriFieldTypeString, alias: READ TYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: read_type )
• mxu_manufacturer ( type: esriFieldTypeString, alias: MXU MANUFACTURER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: mxu_manufacturer )
• mxu_install_date ( type: esriFieldTypeDate, alias: MXU INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: mxu_install_date )
• mxu_id ( type: esriFieldTypeInteger, alias: MXU ID, editable: true, nullable: true, defaultValue: null, modelName: mxu_id )
• meter_set_date ( type: esriFieldTypeDate, alias: Meter Set Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: meter_set_date )
• meter_id ( type: esriFieldTypeString, alias: Meter Id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: meter_id )
• meter_location ( type: esriFieldTypeString, alias: Meter Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: meter_location )
• emr_manufacturer ( type: esriFieldTypeString, alias: EMR MANUFACTURER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: emr_manufacturer )
• original_installation_date ( type: esriFieldTypeDate, alias: Original Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: original_installation_date )
• emr_install_date ( type: esriFieldTypeDate, alias: EMR INSTALL DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: emr_install_date )
• additional_information ( type: esriFieldTypeString, alias: ADDITIONAL INFORMATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: additional_information )
• loc_no_join ( type: esriFieldTypeString, alias: LOC_NO_JOIN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: loc_no_join )
• last_update ( type: esriFieldTypeDate, alias: Last Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_update )
• parcel_id ( type: esriFieldTypeString, alias: Parcel_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: parcel_id )
• account_type ( type: esriFieldTypeString, alias: Account_type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: account_type )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status )
• cust_phone_1 ( type: esriFieldTypeString, alias: Cust_Phone_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cust_phone_1 )
• cust_phone_2 ( type: esriFieldTypeString, alias: Cust_Phone_2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cust_phone_2 )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: false, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS, required: true , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )

Templates:

• Name: Water Device
  Description:
  Prototype:
  cust_phone_2: null
  cust_phone_1: null
  ASSETGROUP: 0
  ASSETTYPE: 0
  status: null
  account_type: null
  parcel_id: null
  last_update: null
  loc_no_join: null
  additional_information: null
  TERMINALCONFIGURATION: Default
  mxu_manufacturer: null
  emr_install_date: null
  original_installation_date: null
  emr_manufacturer: null
  meter_location: null
  diameter: null
  pressure: null
  designtype: null
  normalstatus: null
  operable: 1
  name: null
  assetid: null
  lifecyclestatus: 2
  meter_id: null
  meter_set_date: null
  mxu_id: null
  mxu_install_date: null
  constructionstatus: 6
  symbolrotation: null
  diameter_metric: null
  facilityid: null
  installdate: null
  locdesc: null
  valvetype: null
  bypassvalve: 0
  clocktoclose: 1
  normallyopen: 1
  hydrflag: 0
  curropen: 1
  enabled: 1
  activeflag: 1
  ownedby: 1
  maintby: 1
  lastupdate: null
  lasteditor: null
  x: null
  gps_date: null
  y: null
  z: null
  rotation: null
  turns_to_close: null
  hydrant_id: null
  manufacturer: null
  notes1: null
  notes2: null
  exercise_date: null
  exercise_operator: null
  exercise_turns: null
  exercise_position: null
  exercise_high_torque: null
  exercise_remarks: null
  exercise_remarks_description: null
  flow: null
  facility_id: null
  location_desc: null
  color: null
  size: null
  main_diameter: null
  main_material: null
  last_service: null
  notes: null
  install_date: null
  static: null
  residual: null
  manufacture_year: null
  last_inspection: null
  book_id: null
  facility_id2: null
  avaliable_flow: null
  note1: null
  note2: null
  location_no: null
  book: null
  customer_number: null
  service_address: null
  emr_id: null
  read_type: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata