View In:   ArcGIS Online Map Viewer

Name: Hydrants for meters

Display Field: ST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Dataset includes city and privately maintained hydrants.Symbology based on the field "OWNER" which is populated by either Private or City designations.The Water department divided the city into zones in order to more easily schedule routine maintenance. Fire hydrants are identified based on these water zones.

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 826913.2178549953
YMin: 2.662552339603032E7
XMax: 892885.1197035797
YMax: 2.670641118044866E7
Spatial Reference: 102707  (3421)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNER
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value:
  Label: UK
  Description:
  Symbol:
  
• Value: City
  Label: City
  Description:
  Symbol:
  
• Value: Private
  Label: Private
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNER

Fields:

• install_dt ( type: esriFieldTypeString, alias: install_dt, editable: true, nullable: true, length: 10, defaultValue: null, modelName: install_dt )
• brand ( type: esriFieldTypeString, alias: brand, editable: true, nullable: true, length: 15, defaultValue: null, modelName: brand , Coded Values: [CLO: CLOW] , [DRS: DRESSER] , [KEN: KENNEDY] , ...4 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNER )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: COMMENTS )
• Hydrant_No ( type: esriFieldTypeSmallInteger, alias: Hydrant_No, editable: true, nullable: true, defaultValue: null, modelName: Hydrant_No )
• REV_Street ( type: esriFieldTypeString, alias: Street or Intersection, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REV_Street )
• REV_ZIP ( type: esriFieldTypeString, alias: ZIP Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REV_ZIP )
• PSI ( type: esriFieldTypeSmallInteger, alias: PSI, editable: true, nullable: true, defaultValue: null, modelName: PSI )
• FIELD_CHECK_DATE ( type: esriFieldTypeDate, alias: FIELD_CHECK_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIELD_CHECK_DATE )
• FIELD_CHECK_WORKER ( type: esriFieldTypeString, alias: FIELD_CHECK_WORKER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: FIELD_CHECK_WORKER )
• BARREL_DRAINS ( type: esriFieldTypeString, alias: BARREL_DRAINS, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BARREL_DRAINS , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• HydMaint_No ( type: esriFieldTypeString, alias: HydMaint_No, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HydMaint_No )
• WATER_ZONE ( type: esriFieldTypeString, alias: WATER_ZONE, editable: true, nullable: true, length: 4, defaultValue: null, modelName: WATER_ZONE )
• LAST_UPDATE ( type: esriFieldTypeDate, alias: LAST_UPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATE )
• UPDATED_BY ( type: esriFieldTypeString, alias: UPDATED_BY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UPDATED_BY , Coded Values: [JS: Jennifer Switzer] , [JW: Jennifer Woodward] , [MM: Mauricio Morteo] )
• CHLORINE ( type: esriFieldTypeDouble, alias: CHLORINE, editable: true, nullable: true, defaultValue: null, modelName: CHLORINE )
• LEAK_DETECTED ( type: esriFieldTypeString, alias: LEAK_DETECTED, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LEAK_DETECTED , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MODEL , Coded Values: [MEDALLION: MEDALLION (CLOW)] , [SUPER CENTURION: CENTURION (MULLER)] , [B-84: B-84 (AMERICAN)] , ...4 more... )
• YEAR_MANF ( type: esriFieldTypeSmallInteger, alias: YEAR_MANF, editable: true, nullable: true, defaultValue: null, modelName: YEAR_MANF )
• BLUE_DOT ( type: esriFieldTypeString, alias: BLUE_DOT, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BLUE_DOT , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• THREADS_CL_LU ( type: esriFieldTypeString, alias: THREADS_CL_LU, editable: true, nullable: true, length: 3, defaultValue: null, modelName: THREADS_CL_LU , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• NUM_TURNS ( type: esriFieldTypeSmallInteger, alias: NUM_TURNS, editable: true, nullable: true, defaultValue: null, modelName: NUM_TURNS )
• METER_NUM ( type: esriFieldTypeInteger, alias: METER_NUM, editable: true, nullable: true, defaultValue: null, modelName: METER_NUM )
• DEAD_END ( type: esriFieldTypeString, alias: DEAD_END, editable: true, nullable: true, length: 3, defaultValue: null, modelName: DEAD_END , Coded Values: [YES: YES] , [NO: NO] , [N/A: N/A] )
• METER_INSTALL ( type: esriFieldTypeDate, alias: METER_INSTALL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: METER_INSTALL )
• METER_REMOVED ( type: esriFieldTypeDate, alias: METER_REMOVED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: METER_REMOVED )
• Rotation ( type: esriFieldTypeInteger, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• DATE_PAINTED ( type: esriFieldTypeDate, alias: DATE_PAINTED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_PAINTED )
• PAINTED_BY ( type: esriFieldTypeString, alias: PAINTED_BY, editable: true, nullable: true, length: 35, defaultValue: null, modelName: PAINTED_BY )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ST_NUM ( type: esriFieldTypeString, alias: ST_NUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ST_NUM )
• ST_NAME ( type: esriFieldTypeString, alias: ST_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ST_NAME )
• ARCGIS.SDE.Hydrants_Master.FID ( type: esriFieldTypeString, alias: FID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ARCGIS.SDE.Hydrants_Master.FID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: null
Name:
Domains:
• brand:
  Inherited
• BARREL_DRAINS:
  Inherited
• UPDATED_BY:
  Inherited
• LEAK_DETECTED:
  Inherited
• MODEL:
  Inherited
• BLUE_DOT:
  Inherited
• THREADS_CL_LU:
  Inherited
• DEAD_END:
  Inherited
Templates:
• Name:
  Description:
  Prototype:
  ST_NAME: null
  install_dt: null
  brand: null
  OWNER: null
  COMMENTS: null
  Hydrant_No: null
  REV_Street: null
  REV_ZIP: null
  PSI: null
  FIELD_CHECK_DATE: null
  FIELD_CHECK_WORKER: null
  BARREL_DRAINS: null
  HydMaint_No: null
  WATER_ZONE: null
  LAST_UPDATE: null
  UPDATED_BY: null
  CHLORINE: null
  LEAK_DETECTED: null
  MODEL: null
  YEAR_MANF: null
  BLUE_DOT: null
  THREADS_CL_LU: null
  NUM_TURNS: null
  METER_NUM: null
  DEAD_END: null
  METER_INSTALL: null
  METER_REMOVED: null
  Rotation: null
  DATE_PAINTED: null
  PAINTED_BY: null
  ST_NUM: null
  ARCGIS.SDE.Hydrants_Master.FID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: City
Name: City
Domains:
• brand:
  Inherited
• BARREL_DRAINS:
  Inherited
• UPDATED_BY:
  Inherited
• LEAK_DETECTED:
  Inherited
• MODEL:
  Inherited
• BLUE_DOT:
  Inherited
• THREADS_CL_LU:
  Inherited
• DEAD_END:
  Inherited
Templates:
• Name: City
  Description:
  Prototype:
  ST_NAME: null
  install_dt: null
  brand: null
  OWNER: City
  COMMENTS: null
  Hydrant_No: null
  REV_Street: null
  REV_ZIP: null
  PSI: null
  FIELD_CHECK_DATE: null
  FIELD_CHECK_WORKER: null
  BARREL_DRAINS: null
  HydMaint_No: null
  WATER_ZONE: null
  LAST_UPDATE: null
  UPDATED_BY: null
  CHLORINE: null
  LEAK_DETECTED: null
  MODEL: null
  YEAR_MANF: null
  BLUE_DOT: null
  THREADS_CL_LU: null
  NUM_TURNS: null
  METER_NUM: null
  DEAD_END: null
  METER_INSTALL: null
  METER_REMOVED: null
  Rotation: null
  DATE_PAINTED: null
  PAINTED_BY: null
  ST_NUM: null
  ARCGIS.SDE.Hydrants_Master.FID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Private
Name: Private
Domains:
• brand:
  Inherited
• BARREL_DRAINS:
  Inherited
• UPDATED_BY:
  Inherited
• LEAK_DETECTED:
  Inherited
• MODEL:
  Inherited
• BLUE_DOT:
  Inherited
• THREADS_CL_LU:
  Inherited
• DEAD_END:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  ST_NAME: null
  install_dt: null
  brand: null
  OWNER: Private
  COMMENTS: null
  Hydrant_No: null
  REV_Street: null
  REV_ZIP: null
  PSI: null
  FIELD_CHECK_DATE: null
  FIELD_CHECK_WORKER: null
  BARREL_DRAINS: null
  HydMaint_No: null
  WATER_ZONE: null
  LAST_UPDATE: null
  UPDATED_BY: null
  CHLORINE: null
  LEAK_DETECTED: null
  MODEL: null
  YEAR_MANF: null
  BLUE_DOT: null
  THREADS_CL_LU: null
  NUM_TURNS: null
  METER_NUM: null
  DEAD_END: null
  METER_INSTALL: null
  METER_REMOVED: null
  Rotation: null
  DATE_PAINTED: null
  PAINTED_BY: null
  ST_NUM: null
  ARCGIS.SDE.Hydrants_Master.FID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Hyd_Mtr_records (0) -- Related To: ARCGIS.SDE.Hyd_Mtr_records (1)

Capabilities: Query,Create,Update,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: 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

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata