View In:   ArcGIS Online Map Viewer

Name: Hydrants

Display Field: Hydrant_Nu

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Hydrants mapped on 3/27/2020

Copyright Text:

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON, geoJSON, PBF

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: true

Supports Datum Transformation: true

Extent:

XMin: 637608.984299913
YMin: 980665.9606240764
XMax: 768273.3535480797
YMax: 1056925.0466226563
Spatial Reference: 102659  (2237)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: District
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: City
  Label: City
  Description: N/A
  Symbol:
  
• Value: County
  Label: County
  Description: N/A
  Symbol:
  
• Value: N/A
  Label: Unknown
  Description: N/A
  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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: District

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Hydrant_Nu ( type: esriFieldTypeString, alias: Hydrant #, editable: true, nullable: false, length: 5, defaultValue: null, modelName: Hydrant_Nu )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: false, length: 255, defaultValue: null, modelName: Notes )
• ddlong ( type: esriFieldTypeDouble, alias: DD Longitude, editable: true, nullable: false, defaultValue: null, modelName: ddlong )
• ddlat ( type: esriFieldTypeDouble, alias: DD Latitude, editable: true, nullable: false, defaultValue: null, modelName: ddlat )
• dmslong ( type: esriFieldTypeString, alias: DMS Longitude, editable: true, nullable: false, length: 30, defaultValue: null, modelName: dmslong )
• dmslat ( type: esriFieldTypeString, alias: DMS Latitude, editable: true, nullable: false, length: 30, defaultValue: null, modelName: dmslat )
• FID_1 ( type: esriFieldTypeInteger, alias: FID_1, editable: true, nullable: false, defaultValue: null, modelName: FID_1 )
• ID ( type: esriFieldTypeSmallInteger, alias: ID, editable: true, nullable: false, defaultValue: null, modelName: ID )
• System_ID ( type: esriFieldTypeSmallInteger, alias: System_ID, editable: true, nullable: false, defaultValue: null, modelName: System_ID )
• Level_ID ( type: esriFieldTypeSmallInteger, alias: Level_ID, editable: true, nullable: false, defaultValue: null, modelName: Level_ID )
• Title ( type: esriFieldTypeString, alias: Title, editable: true, nullable: false, length: 24, defaultValue: null, modelName: Title )
• Hydrant_ID ( type: esriFieldTypeString, alias: Hydrant_ID, editable: true, nullable: false, length: 8, defaultValue: null, modelName: Hydrant_ID )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: false, length: 22, defaultValue: null, modelName: STATUS , Coded Values: [Assessed-Not Exercised: Assessed - Not Exercised] , [Inoperable: Inoperable] , [Not Found: Not Found] , ...1 more... )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, editable: true, nullable: false, length: 13, defaultValue: null, modelName: INSPECTOR )
• INSPECTION ( type: esriFieldTypeDate, alias: INSPECTION, editable: true, nullable: false, length: 8, defaultValue: null, modelName: INSPECTION )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: false, length: 64, defaultValue: null, modelName: ADDRESS )
• CROSS_STRE ( type: esriFieldTypeString, alias: CROSS_STRE, editable: true, nullable: false, length: 37, defaultValue: null, modelName: CROSS_STRE )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: false, length: 26, defaultValue: null, modelName: LOCATION )
• MANUFACTOR ( type: esriFieldTypeString, alias: MANUFACTOR, editable: true, nullable: false, length: 16, defaultValue: null, modelName: MANUFACTOR , Coded Values: [American Darling: American Darling] , [Clow: Clow] , [Kennedy: Kennedy] , ...5 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: false, length: 9, defaultValue: null, modelName: MODEL , Coded Values: [129: 129] , [5CD: 5CD] , [929: 929] , ...6 more... )
• HYDRANT_YE ( type: esriFieldTypeString, alias: HYDRANT_YE, editable: true, nullable: false, length: 5, defaultValue: null, modelName: HYDRANT_YE )
• MAIN_VALVE ( type: esriFieldTypeSmallInteger, alias: MAIN_VALVE, editable: true, nullable: false, defaultValue: null, modelName: MAIN_VALVE )
• PUMPER_HEI ( type: esriFieldTypeSmallInteger, alias: PUMPER_HEI, editable: true, nullable: false, defaultValue: null, modelName: PUMPER_HEI )
• STATIC ( type: esriFieldTypeSmallInteger, alias: STATIC, editable: true, nullable: false, defaultValue: null, modelName: STATIC )
• RESIDUAL ( type: esriFieldTypeSmallInteger, alias: RESIDUAL, editable: true, nullable: false, defaultValue: null, modelName: RESIDUAL )
• FLOW_PSI ( type: esriFieldTypeSmallInteger, alias: FLOW_PSI, editable: true, nullable: false, defaultValue: null, modelName: FLOW_PSI )
• FLOW_GPM ( type: esriFieldTypeSmallInteger, alias: FLOW_GPM, editable: true, nullable: false, defaultValue: null, modelName: FLOW_GPM )
• RESIDUAL_H ( type: esriFieldTypeString, alias: RESIDUAL_H, editable: true, nullable: false, length: 7, defaultValue: null, modelName: RESIDUAL_H )
• FLOW_MINUT ( type: esriFieldTypeSmallInteger, alias: FLOW_MINUT, editable: true, nullable: false, defaultValue: null, modelName: FLOW_MINUT )
• NOZZEL_OPE ( type: esriFieldTypeString, alias: NOZZEL_OPE, editable: true, nullable: false, length: 3, defaultValue: null, modelName: NOZZEL_OPE , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• OUT_OF_SER ( type: esriFieldTypeString, alias: OUT_OF_SER, editable: true, nullable: false, length: 3, defaultValue: null, modelName: OUT_OF_SER , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• NEEDS_EXTE ( type: esriFieldTypeString, alias: NEEDS_EXTE, editable: true, nullable: false, length: 3, defaultValue: null, modelName: NEEDS_EXTE , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• TAG_PRESEN ( type: esriFieldTypeString, alias: TAG_PRESEN, editable: true, nullable: false, length: 3, defaultValue: null, modelName: TAG_PRESEN , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• RPM_PRESEN ( type: esriFieldTypeString, alias: RPM_PRESEN, editable: true, nullable: false, length: 3, defaultValue: null, modelName: RPM_PRESEN , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• PAINTED ( type: esriFieldTypeString, alias: PAINTED, editable: true, nullable: false, length: 3, defaultValue: null, modelName: PAINTED , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• BONNET_COL ( type: esriFieldTypeString, alias: BONNET_COL, editable: true, nullable: false, length: 6, defaultValue: null, modelName: BONNET_COL , Coded Values: [Green: Green] , [Orange: Orange] , [N/A: N/A] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: false, length: 79, defaultValue: null, modelName: COMMENTS )
• QC_BY ( type: esriFieldTypeString, alias: QC_BY, editable: true, nullable: false, length: 1, defaultValue: null, modelName: QC_BY )
• QC_DATE ( type: esriFieldTypeDate, alias: QC_DATE, editable: true, nullable: false, length: 8, defaultValue: null, modelName: QC_DATE )
• QC_STATUS ( type: esriFieldTypeString, alias: QC_STATUS, editable: true, nullable: false, length: 1, defaultValue: null, modelName: QC_STATUS )
• QC_COMMENT ( type: esriFieldTypeString, alias: QC_COMMENT, editable: true, nullable: false, length: 1, defaultValue: null, modelName: QC_COMMENT )
• GIS_POINT ( type: esriFieldTypeString, alias: GIS_POINT, editable: true, nullable: false, length: 1, defaultValue: null, modelName: GIS_POINT )
• FID_2 ( type: esriFieldTypeInteger, alias: FID_2, editable: true, nullable: false, defaultValue: null, modelName: FID_2 )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Average: Average] , ...1 more... )
• NOTES_1 ( type: esriFieldTypeString, alias: NOTES_1, editable: true, nullable: false, length: 255, defaultValue: null, modelName: NOTES_1 )
• Distance ( type: esriFieldTypeDouble, alias: Distance, editable: true, nullable: false, defaultValue: null, modelName: Distance )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 255, defaultValue: null, modelName: District , Coded Values: [County: County] , [City: City] , [N/A: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: City
Name: City
Domains:
• STATUS:
  Inherited
• MANUFACTOR:
  Inherited
• MODEL:
  Inherited
• NOZZEL_OPE:
  Inherited
• OUT_OF_SER:
  Inherited
• NEEDS_EXTE:
  Inherited
• TAG_PRESEN:
  Inherited
• RPM_PRESEN:
  Inherited
• PAINTED:
  Inherited
• BONNET_COL:
  Inherited
• Condition:
  Inherited
• District:
  Inherited
Templates:
• Name: City
  Description:
  Prototype:
  District: City
  Distance: 0
  Hydrant_Nu:
  Notes:
  ddlong: 0
  ddlat: 0
  dmslong:
  dmslat:
  FID_1: 0
  ID: 0
  System_ID: 0
  Level_ID: 0
  Title:
  Hydrant_ID:
  STATUS:
  INSPECTOR:
  INSPECTION: -2209161600000
  ADDRESS:
  CROSS_STRE:
  LOCATION:
  MANUFACTOR:
  MODEL:
  HYDRANT_YE:
  MAIN_VALVE: 0
  PUMPER_HEI: 0
  STATIC: 0
  RESIDUAL: 0
  FLOW_PSI: 0
  FLOW_GPM: 0
  RESIDUAL_H:
  FLOW_MINUT: 0
  NOZZEL_OPE:
  OUT_OF_SER:
  NEEDS_EXTE:
  TAG_PRESEN:
  RPM_PRESEN:
  PAINTED:
  BONNET_COL:
  COMMENTS:
  QC_BY:
  QC_DATE: -2209161600000
  QC_STATUS:
  QC_COMMENT:
  GIS_POINT:
  FID_2: 0
  Condition:
  NOTES_1:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: County
Name: County
Domains:
• STATUS:
  Inherited
• MANUFACTOR:
  Inherited
• MODEL:
  Inherited
• NOZZEL_OPE:
  Inherited
• OUT_OF_SER:
  Inherited
• NEEDS_EXTE:
  Inherited
• TAG_PRESEN:
  Inherited
• RPM_PRESEN:
  Inherited
• PAINTED:
  Inherited
• BONNET_COL:
  Inherited
• Condition:
  Inherited
• District:
  Inherited
Templates:
• Name: County
  Description:
  Prototype:
  District: County
  Distance: 0
  Hydrant_Nu:
  Notes:
  ddlong: 0
  ddlat: 0
  dmslong:
  dmslat:
  FID_1: 0
  ID: 0
  System_ID: 0
  Level_ID: 0
  Title:
  Hydrant_ID:
  STATUS:
  INSPECTOR:
  INSPECTION: -2209161600000
  ADDRESS:
  CROSS_STRE:
  LOCATION:
  MANUFACTOR:
  MODEL:
  HYDRANT_YE:
  MAIN_VALVE: 0
  PUMPER_HEI: 0
  STATIC: 0
  RESIDUAL: 0
  FLOW_PSI: 0
  FLOW_GPM: 0
  RESIDUAL_H:
  FLOW_MINUT: 0
  NOZZEL_OPE:
  OUT_OF_SER:
  NEEDS_EXTE:
  TAG_PRESEN:
  RPM_PRESEN:
  PAINTED:
  BONNET_COL:
  COMMENTS:
  QC_BY:
  QC_DATE: -2209161600000
  QC_STATUS:
  QC_COMMENT:
  GIS_POINT:
  FID_2: 0
  Condition:
  NOTES_1:
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: N/A
Name: Unknown
Domains:
• STATUS:
  Inherited
• MANUFACTOR:
  Inherited
• MODEL:
  Inherited
• NOZZEL_OPE:
  Inherited
• OUT_OF_SER:
  Inherited
• NEEDS_EXTE:
  Inherited
• TAG_PRESEN:
  Inherited
• RPM_PRESEN:
  Inherited
• PAINTED:
  Inherited
• BONNET_COL:
  Inherited
• Condition:
  Inherited
• District:
  Inherited
Templates:
• Name: N/A
  Description:
  Prototype:
  District: N/A
  Distance: 0
  Hydrant_Nu:
  Notes:
  ddlong: 0
  ddlat: 0
  dmslong:
  dmslat:
  FID_1: 0
  ID: 0
  System_ID: 0
  Level_ID: 0
  Title:
  Hydrant_ID:
  STATUS:
  INSPECTOR:
  INSPECTION: -2209161600000
  ADDRESS:
  CROSS_STRE:
  LOCATION:
  MANUFACTOR:
  MODEL:
  HYDRANT_YE:
  MAIN_VALVE: 0
  PUMPER_HEI: 0
  STATIC: 0
  RESIDUAL: 0
  FLOW_PSI: 0
  FLOW_GPM: 0
  RESIDUAL_H:
  FLOW_MINUT: 0
  NOZZEL_OPE:
  OUT_OF_SER:
  NEEDS_EXTE:
  TAG_PRESEN:
  RPM_PRESEN:
  PAINTED:
  BONNET_COL:
  COMMENTS:
  QC_BY:
  QC_DATE: -2209161600000
  QC_STATUS:
  QC_COMMENT:
  GIS_POINT:
  FID_2: 0
  Condition:
  NOTES_1:
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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: false

Supports Coordinates Quantization: true

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