View In:   ArcGIS Online Map Viewer

Name: Hydrants

Display Field: locdesc

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 4d92ac199fad49d0942f6a5173be0d86

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2256.994353

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

Extent:

XMin: 6618290.683163255
YMin: 1956992.2195733488
XMax: 6654251.654220194
YMax: 1976573.4586260319
Spatial Reference: 102642  (2226)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• hyg_type_cd ( modelName: HYG_TYPE_CD, nullable: true, editable: true, defaultValue: null, alias: Hydrant Type, type: esriFieldTypeSmallInteger , Coded Values: [4: Dry Barrel] , [3: Wet Barrel] , [2: Standard] , ...1 more... )
• hyg_colr_cd ( modelName: HYG_COLR_CD, nullable: true, editable: true, defaultValue: null, alias: Color Code, type: esriFieldTypeSmallInteger , Coded Values: [1: Red (0-500gpm)] , [2: Yellow (500-1000gpm)] , [3: Green (1000-1500gpm)] , ...1 more... )
• hyg_gps_flg ( modelName: HYG_GPS_FLG, nullable: true, editable: true, defaultValue: null, alias: GPS Located, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• lastmodby ( modelName: LastModBy, nullable: true, editable: true, defaultValue: null, length: 40, alias: Last Modified By, type: esriFieldTypeString )
• lastmoddate ( modelName: LastModDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Modified date, type: esriFieldTypeDate )
• lastsyndate ( modelName: LastSynDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Synchronized Date, type: esriFieldTypeDate )
• rotation ( modelName: ROTATION, nullable: true, editable: true, defaultValue: null, alias: ROTATION, type: esriFieldTypeDouble )
• hyg_turns ( modelName: HYG_TURNS, nullable: true, editable: true, defaultValue: null, alias: HYG_TURNS, type: esriFieldTypeDouble )
• lucityautoid ( modelName: LucityAutoID, nullable: true, editable: true, defaultValue: null, alias: Link to Lucity, type: esriFieldTypeInteger )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INSTALLDATE, type: esriFieldTypeDate )
• locdesc ( modelName: LOCDESC, nullable: true, editable: true, defaultValue: null, length: 200, alias: LOCDESC, type: esriFieldTypeString )
• operable ( modelName: OPERABLE, nullable: true, editable: true, defaultValue: 1, alias: OPERABLE, type: esriFieldTypeSmallInteger , Coded Values: [2: Abandoned] , [1: Active] , [0: Inactive] )
• lastservice ( modelName: LASTSERVICE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LASTSERVICE, type: esriFieldTypeDate )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: ENABLED, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: ACTIVEFLAG, type: esriFieldTypeSmallInteger , Coded Values: [2: Abandoned] , [1: Active] , [0: Inactive] )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: OWNEDBY, type: esriFieldTypeSmallInteger , Coded Values: [2: Private] , [1: City-Owned] )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 2, alias: MAINTBY, type: esriFieldTypeSmallInteger , Coded Values: [2: Water Division] , [1: WWTP] )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LASTUPDATE, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: LASTEDITOR, type: esriFieldTypeString )
• flow ( modelName: FLOW, nullable: true, editable: true, defaultValue: null, alias: FLOW, type: esriFieldTypeDouble )
• inlucity ( modelName: InLucity, nullable: true, editable: true, defaultValue: null, alias: InLucity, type: esriFieldTypeSmallInteger )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 30, alias: FACILITYID, type: esriFieldTypeString )
• id ( modelName: ID, nullable: true, editable: true, defaultValue: null, alias: ID, type: esriFieldTypeInteger )
• hy_cond_cd ( modelName: HY_COND_CD, nullable: true, editable: true, defaultValue: null, alias: HY_COND_CD, type: esriFieldTypeSmallInteger , Coded Values: [2: Good] , [3: Fair] , [4: Poor] , ...2 more... )
• hyg_mdl_no ( modelName: HYG_MDL_NO, nullable: true, editable: true, defaultValue: null, length: 25, alias: HYG_MDL_NO, type: esriFieldTypeString )
• hyg_conn_cd ( modelName: HYG_CONN_CD, nullable: true, editable: true, defaultValue: null, alias: HYG_CONN_CD, type: esriFieldTypeSmallInteger , Coded Values: [2: Mechanical Joint] , [1: Flange Joint] )
• hyg_noz_sz1 ( modelName: HYG_NOZ_SZ1, nullable: true, editable: true, defaultValue: 2.5, alias: HYG_NOZ_SZ1, type: esriFieldTypeDouble )
• hyg_noz_sz2 ( modelName: HYG_NOZ_SZ2, nullable: true, editable: true, defaultValue: 4.5, alias: HYG_NOZ_SZ2, type: esriFieldTypeDouble )
• hyg_mfg_cd ( modelName: HYG_MFG_CD, nullable: true, editable: true, defaultValue: null, alias: HYG_MFG_CD, type: esriFieldTypeSmallInteger , Coded Values: [9: MUELLER] , [8: MH] , [7: KENNEDY] , ...10 more... )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• asbuilt_status ( modelName: AsBuilt_Status, nullable: true, editable: true, defaultValue: null, alias: AsBuilt_Status, type: esriFieldTypeSmallInteger , Coded Values: [2: Under Review] , [3: Accepted] , [4: Planned] , ...1 more... )
• hyg_elev1 ( modelName: HYG_ELEV1, nullable: true, editable: true, defaultValue: null, alias: HYG_ELEV1, type: esriFieldTypeDouble )
• hyg_ext ( modelName: HYG_EXT, nullable: true, editable: true, defaultValue: null, length: 30, alias: HYG_EXT, type: esriFieldTypeString )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• esrignss_positionsourcetype ( modelName: ESRIGNSS_POSITIONSOURCETYPE, nullable: true, editable: true, defaultValue: null, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• esrignss_receiver ( modelName: ESRIGNSS_RECEIVER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• esrignss_latitude ( modelName: ESRIGNSS_LATITUDE, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• esrignss_longitude ( modelName: ESRIGNSS_LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• esrignss_altitude ( modelName: ESRIGNSS_ALTITUDE, nullable: true, editable: true, defaultValue: null, alias: Altitude, type: esriFieldTypeDouble )
• esrignss_h_rms ( modelName: ESRIGNSS_H_RMS, nullable: true, editable: true, defaultValue: null, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_v_rms ( modelName: ESRIGNSS_V_RMS, nullable: true, editable: true, defaultValue: null, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_fixdatetime ( modelName: ESRIGNSS_FIXDATETIME, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fix Time, type: esriFieldTypeDate )
• esrignss_fixtype ( modelName: ESRIGNSS_FIXTYPE, nullable: true, editable: true, defaultValue: null, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• esrignss_correctionage ( modelName: ESRIGNSS_CORRECTIONAGE, nullable: true, editable: true, defaultValue: null, alias: Correction Age, type: esriFieldTypeDouble )
• esrignss_stationid ( modelName: ESRIGNSS_STATIONID, nullable: true, editable: true, defaultValue: null, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
• esrignss_numsats ( modelName: ESRIGNSS_NUMSATS, nullable: true, editable: true, defaultValue: null, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
• esrignss_pdop ( modelName: ESRIGNSS_PDOP, nullable: true, editable: true, defaultValue: null, alias: PDOP, type: esriFieldTypeDouble )
• esrignss_hdop ( modelName: ESRIGNSS_HDOP, nullable: true, editable: true, defaultValue: null, alias: HDOP, type: esriFieldTypeDouble )
• esrignss_vdop ( modelName: ESRIGNSS_VDOP, nullable: true, editable: true, defaultValue: null, alias: VDOP, type: esriFieldTypeDouble )
• esrignss_direction ( modelName: ESRIGNSS_DIRECTION, nullable: true, editable: true, defaultValue: null, alias: Direction of travel (°), type: esriFieldTypeDouble )
• esrignss_speed ( modelName: ESRIGNSS_SPEED, nullable: true, editable: true, defaultValue: null, alias: Speed (km/h), type: esriFieldTypeDouble )
• esrisnsr_azimuth ( modelName: ESRISNSR_AZIMUTH, nullable: true, editable: true, defaultValue: null, alias: Compass reading (°), type: esriFieldTypeDouble )
• esrignss_avg_h_rms ( modelName: ESRIGNSS_AVG_H_RMS, nullable: true, editable: true, defaultValue: null, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_v_rms ( modelName: ESRIGNSS_AVG_V_RMS, nullable: true, editable: true, defaultValue: null, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_positions ( modelName: ESRIGNSS_AVG_POSITIONS, nullable: true, editable: true, defaultValue: null, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• esrignss_h_stddev ( modelName: ESRIGNSS_H_STDDEV, nullable: true, editable: true, defaultValue: null, alias: Standard Deviation (m), type: esriFieldTypeDouble )
• address_geolocated ( modelName: address_geolocated, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address_geolocated, type: esriFieldTypeString )
• creationdate ( modelName: creationdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CreationDate, type: esriFieldTypeDate )
• creator ( modelName: creator, nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• editdate ( modelName: editdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: EditDate, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: false, defaultValue: null, length: 255, alias: Editor, type: esriFieldTypeString )

Templates:

• Name: Hydrants
  Description:
  Prototype:
  esrignss_avg_h_rms: null
  operable: 1
  hyg_ext: null
  installdate: null
  facilityid: null
  notes: null
  esrignss_hdop: null
  lastservice: null
  lucityautoid: null
  hyg_noz_sz1: 2.5
  hyg_noz_sz2: 4.5
  esrignss_pdop: null
  esrisnsr_azimuth: null
  lastsyndate: null
  esrignss_fixdatetime: null
  id: null
  ownedby: 1
  hy_cond_cd: null
  hyg_turns: null
  flow: null
  esrignss_fixtype: null
  hyg_mdl_no: null
  esrignss_h_stddev: null
  created_user: null
  esrignss_avg_positions: null
  esrignss_stationid: null
  esrignss_v_rms: null
  hyg_elev1: null
  activeflag: 1
  esrignss_direction: null
  asbuilt_status: null
  address_geolocated: null
  lastupdate: null
  hyg_mfg_cd: null
  lastmodby: null
  esrignss_speed: null
  esrignss_avg_v_rms: null
  enabled: 1
  esrignss_longitude: null
  esrignss_latitude: null
  esrignss_receiver: null
  esrignss_altitude: null
  hyg_colr_cd: null
  esrignss_positionsourcetype: null
  esrignss_vdop: null
  last_edited_date: null
  hyg_conn_cd: null
  hyg_type_cd: null
  rotation: null
  inlucity: null
  lastmoddate: null
  lasteditor: null
  esrignss_correctionage: null
  last_edited_user: null
  esrignss_numsats: null
  hyg_gps_flg: 0
  maintby: 2
  created_date: null
  locdesc: null
  esrignss_h_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: editdate
• Editor Field: editor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata