View In:   ArcGIS.com Map

Name: Hydrants

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: 1.2863913176183373E7
YMin: 272021.8697539866
XMax: 1.2932900476705179E7
YMax: 318035.10335443914
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PUBLIC_PVT
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 148, 15, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  
• Value: Public
  Label: Public
  Description: N/A
  Symbol:
  
• Value: Unknown
  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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: PUBLIC_PVT

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• HYDRANT_ID ( type: esriFieldTypeString, alias: HYDRANT_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: HYDRANT_ID )
• MUNICIPALITY ( type: esriFieldTypeString, alias: MUNICIPALITY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MUNICIPALITY , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OWNER , Coded Values: [City of Battle Creek: City of Battle Creek] , [Brownstone Apartments: Brownstone Apartments] , [Keystone Lake Apartments: Keystone Lake Apartments] , ...5 more... )
• PUBLIC_PVT ( type: esriFieldTypeString, alias: PUBLIC or PRIVATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PUBLIC_PVT , Coded Values: [Public: Public] , [Private: Private] , [Unknown: Unknown] )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow: Clow] , [EJIW: EJIW] , ...9 more... )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR , Coded Values: [City of Battle Creek: City of Battle Creek] , [Crest Construction: Crest Construction] , [Hoffman Brothers: Hoffman Brothers] , ...10 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MODEL , Coded Values: [5BR: 5BR] , [6BR: 6BR] , [B62B-5: B62B-5] )
• HYD_VOB ( type: esriFieldTypeString, alias: VALVE ON BRANCH, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HYD_VOB , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• DEPTHOBURY ( type: esriFieldTypeDouble, alias: DEPTH OF BURY, editable: true, nullable: true, defaultValue: null, modelName: DEPTHOBURY , Coded Values: [4: 4 ft] , [5: 5 ft] , [5.5: 5.5 ft] , ...11 more... )
• CAST_DATE ( type: esriFieldTypeSmallInteger, alias: CAST DATE, editable: true, nullable: true, defaultValue: null, modelName: CAST_DATE )
• INSTALL_YR ( type: esriFieldTypeSmallInteger, alias: YEAR INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_YR )
• INSTALLMTH ( type: esriFieldTypeSmallInteger, alias: MONTH INSTALLED, editable: true, nullable: true, defaultValue: null, modelName: INSTALLMTH , Coded Values: [1: January] , [2: February] , [3: March] , ...9 more... )
• VERT_EXT ( type: esriFieldTypeDouble, alias: VERTICAL EXTENSION, editable: true, nullable: true, defaultValue: null, modelName: VERT_EXT )
• DRAIN_HOLE ( type: esriFieldTypeSmallInteger, alias: DRAIN_HOLE, editable: true, nullable: true, defaultValue: null, modelName: DRAIN_HOLE )
• PLUGS_REMO ( type: esriFieldTypeString, alias: PLUGS REMOVED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PLUGS_REMO , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• GPS_Date ( type: esriFieldTypeDate, alias: GPS_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_Date )
• VERIFIED ( type: esriFieldTypeString, alias: VERIFIED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VERIFIED , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PRESSURE ( type: esriFieldTypeString, alias: PRESSURE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRESSURE , Coded Values: [H: High] , [L: Low] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• STATIC_PSI ( type: esriFieldTypeSmallInteger, alias: STATIC_PSI, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PSI )
• RESIDUAL_PSI ( type: esriFieldTypeSmallInteger, alias: RESIDUAL_PSI, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL_PSI )
• FLOW_GPM ( type: esriFieldTypeSmallInteger, alias: FLOW_GPM, editable: true, nullable: true, defaultValue: null, modelName: FLOW_GPM )
• TEST_TAKER ( type: esriFieldTypeString, alias: TEST_TAKER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TEST_TAKER )
• TEST_DATE ( type: esriFieldTypeDate, alias: TEST_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TEST_DATE )
• IDNO ( type: esriFieldTypeString, alias: IDNO, editable: true, nullable: true, length: 14, defaultValue: null, modelName: IDNO )
• T1COMMENT ( type: esriFieldTypeString, alias: T1COMMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: T1COMMENT )
• SHEET__S ( type: esriFieldTypeInteger, alias: ORTHO INDEX, editable: true, nullable: true, defaultValue: null, modelName: SHEET__S )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate, editable: true, nullable: true, defaultValue: null, modelName: Duplicate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• WINTERCHECK ( type: esriFieldTypeString, alias: WINTER CHECK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WINTERCHECK , Coded Values: [Yes: Yes] , [No: No] , [Private: Private] )
• GROUNDWATER ( type: esriFieldTypeString, alias: GROUND WATER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GROUNDWATER , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• WINTERCHECK_COMMENTS ( type: esriFieldTypeString, alias: WINTER CHECK COMMENTS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: WINTERCHECK_COMMENTS )
• NO_DRAINER ( type: esriFieldTypeString, alias: NO_DRAINER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NO_DRAINER , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PROBLEM_CODE ( type: esriFieldTypeString, alias: PROBLEM_CODE, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PROBLEM_CODE , Coded Values: [No Problems: No Problems] , [Broken Flange: Broken Flange] , [Needs Raised: Needs Raised] , ...10 more... )
• GIS_CHANGE ( type: esriFieldTypeString, alias: GIS_CHANGE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GIS_CHANGE , Coded Values: [Yes: Yes] , [No: No] , [Complete: Complete] )
• WINTERCHECKED_BY ( type: esriFieldTypeString, alias: WINTERCHECKED_BY, editable: false, nullable: true, length: 100, defaultValue: null, modelName: WINTERCHECKED_BY )
• REPLACE_HYDRANT ( type: esriFieldTypeString, alias: REPLACE_HYDRANT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REPLACE_HYDRANT , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• NEEDS_LETTER ( type: esriFieldTypeString, alias: NEEDS_LETTER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEEDS_LETTER , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• PUMPOUT_LIST ( type: esriFieldTypeString, alias: PUMPOUT_LIST, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PUMPOUT_LIST , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 75, defaultValue: null, modelName: CreatedBy )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedByDate )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 75, defaultValue: null, modelName: EditedBy )
• EditedByDate ( type: esriFieldTypeDate, alias: Edited By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedByDate )
• STATIC_PSI_text ( type: esriFieldTypeString, alias: Static PSI_text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STATIC_PSI_text )
• RESIDUAL_PSI_text ( type: esriFieldTypeString, alias: Residual PSI_text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RESIDUAL_PSI_text )
• FLOW_GPM_text ( type: esriFieldTypeString, alias: Flow GPM_text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOW_GPM_text )
• FLOWTEST_ID ( type: esriFieldTypeString, alias: Flow Test ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOWTEST_ID )
• Flushtest ( type: esriFieldTypeString, alias: Flushtest, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Flushtest )
• FF_Test ( type: esriFieldTypeInteger, alias: FF_Test, editable: true, nullable: true, defaultValue: null, modelName: FF_Test )
• PSI_stat ( type: esriFieldTypeInteger, alias: PSI_stat, editable: true, nullable: true, defaultValue: null, modelName: PSI_stat )
• PSI_res ( type: esriFieldTypeInteger, alias: PSI_res, editable: true, nullable: true, defaultValue: null, modelName: PSI_res )
• Date_Painted ( type: esriFieldTypeDate, alias: Date_Painted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date_Painted )
• Delete_Me ( type: esriFieldTypeDate, alias: Delete_Me, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Delete_Me )
• WINTERCHECKDATE ( type: esriFieldTypeDate, alias: Winter Check Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WINTERCHECKDATE )

Types:

ID: Private
Name: Private
Domains:
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• PUBLIC_PVT:
  Inherited
• MANUFACTURER:
  Inherited
• CONTRACTOR:
  Inherited
• MODEL:
  Inherited
• HYD_VOB:
  Inherited
• DEPTHOBURY:
  Inherited
• INSTALLMTH:
  Inherited
• PLUGS_REMO:
  Inherited
• VERIFIED:
  Inherited
• PRESSURE:
  Inherited
• Enabled:
  Inherited
• WINTERCHECK:
  Inherited
• GROUNDWATER:
  Inherited
• NO_DRAINER:
  Inherited
• PROBLEM_CODE:
  Inherited
• GIS_CHANGE:
  Inherited
• REPLACE_HYDRANT:
  Inherited
• NEEDS_LETTER:
  Inherited
• PUMPOUT_LIST:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  OWNER: null
  Duplicate: null
  Delete_Me: null
  FACILITYID: null
  HYDRANT_ID: null
  MUNICIPALITY: null
  PUBLIC_PVT: Private
  MANUFACTURER: null
  CONTRACTOR: null
  MODEL: null
  HYD_VOB: null
  DEPTHOBURY: null
  CAST_DATE: null
  INSTALL_YR: null
  INSTALLMTH: null
  VERT_EXT: null
  DRAIN_HOLE: null
  PLUGS_REMO: null
  ELEVATION: null
  GPS_Date: null
  VERIFIED: null
  PRESSURE: null
  COMMENTS: null
  STATIC_PSI: null
  RESIDUAL_PSI: null
  FLOW_GPM: null
  TEST_TAKER: null
  TEST_DATE: null
  IDNO: null
  T1COMMENT: null
  SHEET__S: null
  Enabled: 1
  WINTERCHECK: null
  GROUNDWATER: null
  WINTERCHECK_COMMENTS: null
  NO_DRAINER: null
  PROBLEM_CODE: null
  GIS_CHANGE: null
  Date_Painted: null
  REPLACE_HYDRANT: null
  NEEDS_LETTER: null
  PUMPOUT_LIST: null
  WINTERCHECKDATE: null
  Latitude: null
  Longitude: null
  PSI_res: null
  PSI_stat: null
  FF_Test: null
  Flushtest: null
  STATIC_PSI_text: null
  RESIDUAL_PSI_text: null
  FLOW_GPM_text: null
  FLOWTEST_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Public
Name: Public
Domains:
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• PUBLIC_PVT:
  Inherited
• MANUFACTURER:
  Inherited
• CONTRACTOR:
  Inherited
• MODEL:
  Inherited
• HYD_VOB:
  Inherited
• DEPTHOBURY:
  Inherited
• INSTALLMTH:
  Inherited
• PLUGS_REMO:
  Inherited
• VERIFIED:
  Inherited
• PRESSURE:
  Inherited
• Enabled:
  Inherited
• WINTERCHECK:
  Inherited
• GROUNDWATER:
  Inherited
• NO_DRAINER:
  Inherited
• PROBLEM_CODE:
  Inherited
• GIS_CHANGE:
  Inherited
• REPLACE_HYDRANT:
  Inherited
• NEEDS_LETTER:
  Inherited
• PUMPOUT_LIST:
  Inherited
Templates:
• Name: Public
  Description:
  Prototype:
  OWNER: null
  Duplicate: null
  Delete_Me: null
  FACILITYID: null
  HYDRANT_ID: null
  MUNICIPALITY: null
  PUBLIC_PVT: Public
  MANUFACTURER: null
  CONTRACTOR: null
  MODEL: null
  HYD_VOB: null
  DEPTHOBURY: null
  CAST_DATE: null
  INSTALL_YR: null
  INSTALLMTH: null
  VERT_EXT: null
  DRAIN_HOLE: null
  PLUGS_REMO: null
  ELEVATION: null
  GPS_Date: null
  VERIFIED: null
  PRESSURE: null
  COMMENTS: null
  STATIC_PSI: null
  RESIDUAL_PSI: null
  FLOW_GPM: null
  TEST_TAKER: null
  TEST_DATE: null
  IDNO: null
  T1COMMENT: null
  SHEET__S: null
  Enabled: 1
  WINTERCHECK: null
  GROUNDWATER: null
  WINTERCHECK_COMMENTS: null
  NO_DRAINER: null
  PROBLEM_CODE: null
  GIS_CHANGE: null
  Date_Painted: null
  REPLACE_HYDRANT: null
  NEEDS_LETTER: null
  PUMPOUT_LIST: null
  WINTERCHECKDATE: null
  Latitude: null
  Longitude: null
  PSI_res: null
  PSI_stat: null
  FF_Test: null
  Flushtest: null
  STATIC_PSI_text: null
  RESIDUAL_PSI_text: null
  FLOW_GPM_text: null
  FLOWTEST_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unknown
Name: Unknown
Domains:
• MUNICIPALITY:
  Inherited
• OWNER:
  Inherited
• PUBLIC_PVT:
  Inherited
• MANUFACTURER:
  Inherited
• CONTRACTOR:
  Inherited
• MODEL:
  Inherited
• HYD_VOB:
  Inherited
• DEPTHOBURY:
  Inherited
• INSTALLMTH:
  Inherited
• PLUGS_REMO:
  Inherited
• VERIFIED:
  Inherited
• PRESSURE:
  Inherited
• Enabled:
  Inherited
• WINTERCHECK:
  Inherited
• GROUNDWATER:
  Inherited
• NO_DRAINER:
  Inherited
• PROBLEM_CODE:
  Inherited
• GIS_CHANGE:
  Inherited
• REPLACE_HYDRANT:
  Inherited
• NEEDS_LETTER:
  Inherited
• PUMPOUT_LIST:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  OWNER: null
  Duplicate: null
  Delete_Me: null
  FACILITYID: null
  HYDRANT_ID: null
  MUNICIPALITY: null
  PUBLIC_PVT: Unknown
  MANUFACTURER: null
  CONTRACTOR: null
  MODEL: null
  HYD_VOB: null
  DEPTHOBURY: null
  CAST_DATE: null
  INSTALL_YR: null
  INSTALLMTH: null
  VERT_EXT: null
  DRAIN_HOLE: null
  PLUGS_REMO: null
  ELEVATION: null
  GPS_Date: null
  VERIFIED: null
  PRESSURE: null
  COMMENTS: null
  STATIC_PSI: null
  RESIDUAL_PSI: null
  FLOW_GPM: null
  TEST_TAKER: null
  TEST_DATE: null
  IDNO: null
  T1COMMENT: null
  SHEET__S: null
  Enabled: 1
  WINTERCHECK: null
  GROUNDWATER: null
  WINTERCHECK_COMMENTS: null
  NO_DRAINER: null
  PROBLEM_CODE: null
  GIS_CHANGE: null
  Date_Painted: null
  REPLACE_HYDRANT: null
  NEEDS_LETTER: null
  PUMPOUT_LIST: null
  WINTERCHECKDATE: null
  Latitude: null
  Longitude: null
  PSI_res: null
  PSI_stat: null
  FF_Test: null
  Flushtest: null
  STATIC_PSI_text: null
  RESIDUAL_PSI_text: null
  FLOW_GPM_text: null
  FLOWTEST_ID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedByDate
• Creator Field: CreatedBy
• Edit Date Field: EditedByDate
• Editor Field: EditedBy

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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