Layer: Hydrants (ID:24)

View In: Map Viewer

Name: Hydrants

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

One of the most accessible parts of a water distribution system, they are often used for attaching pressure gauges or loggers or monitor system water pressure. Point where people are able to tap into a water supply (e.g. for firefighters' use).

Copyright Text: Originally created by Woolpert Inc. in 1997. Edited by Battle Creek DPW Records Division.

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"f31ffb9e61b7bb51164bc754ea88eadb","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA6UlEQVQoka3QL0uDURQH4CcMF4SB4EDQsGIYiFFEw2ZSNJgMzo+hRTAoFtkHGCh+gBWLMHAGZRZNrmkScWgwGISt+AcNu8KY78uGeODC7557H87lJvyxEv8N8xgL+QKNfuHGIEtveGelL7hLNsXMZBups/7ASYlmHMwhPcreAkM/zQmmDzhGCVd47IY7KXKzYbOPDOYxzpz2WkX511M/MRDyHb5C/oj4hE542aJ1xFSB4WLHQY173OApCm7COdkmZ8uMvOKUapU1vMRNBBVuK1xvsxhah90oEoaqIxnyc9SFOLgV0+8Je9Y3tzww4qgkwAwAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Private","label":"Private"},{"symbol":{"type":"esriPMS","url":"e007af7672a7f9a6262cd6a837107b25","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQoka3Qr2uCQRzH8XcQDRoUFIasmZ4oiMiKP+IWtAwcVv8CXREM2paepiAsGmyHBtlTFlY2DLM5TIJsoEEMPiuHouF5RNHnQRG/6XOfuxd3nIMLx3FtmABuzfwBjM+Fzx4PD1KClDyeBWs1FLebu0gEpIRej+Jkwlulgm4H40AgGOQlk8G3LcNhYqpKB6gDX8DvIax6vcRTKWOhqhAKQToNikISSAJPQOvoqcslOJ1GHg5hvTbyanX8CfvwU9f5bzaJ5vP4G43dhqYxAgbAnxUsAXS7KIsF79ksN/M5tNtoQpADZnY3AiAEP0LwXShwb1avh8gSmtMHXGaeWh2wg2Wb/iQ8ORveH0ar4aEpsgAAAABJRU5ErkJggg==","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Public","label":"Public"},{"symbol":{"type":"esriPMS","url":"c4fe28b1acab96c5a66032e632d62419","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABFElEQVQoka3PsUrDUBiG4XdICWQoCBoMSOiYbukQEYfWrjo7iCQ3oYvg4uYVOHkBhmxOmsHBJQ7hSKDoaJAKdXDTJIU0OBgFa2KL+E0/3/kfzjkSf4z033ADWCnna+BxXrgvy/LWZDIhz/PtuaBt2+1Go7HearXI85w4jvfSNL3wPO+1DvaApWazedzpdBY+S13X13zfPwdOgBtgOA2PFEXpGYYBgO/7qKqKaZpomtYH+sAOcPbjqUVRIEkf1Wg0+tb/9scgy7K3IAhWu93uouM4XweDweABuAOequBBudQej8dXlmUtJ0lCFEWXYRjuAi91NwIghLgXQgjXdTfL6nQaVcIyt4Bczs9VC3XwsKafCWfmHfiJWtKeFBo9AAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Unknown","label":"Unknown"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[216,207,252,255],"toColor":[216,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,179,255],"toColor":[210,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,198,184,255],"toColor":[252,198,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,246,252,255],"toColor":[179,246,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,207,255],"toColor":[252,246,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,250,255],"toColor":[252,179,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,217,255],"toColor":[197,252,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,227,255],"toColor":[252,197,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[196,179,252,255],"toColor":[196,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,230,252,255],"toColor":[204,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,251,182,255],"toColor":[252,251,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,192,255],"toColor":[252,182,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,210,255],"toColor":[252,227,210,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: PUBLIC_PVT

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
HYDRANT_ID (type: esriFieldTypeString, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
MUNICIPALITY (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [Unknown: Unknown])
MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [American Darling: American Darling], [Clow: Clow], [EJIW: EJIW], ... 9 more ...)
CONTRACTOR (type: esriFieldTypeString, alias: Contractor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, 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, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [5BR: 5BR], [6BR: 6BR], [B62B-5: B62B-5])
HYD_VOB (type: esriFieldTypeString, alias: Valve on Branch, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
DEPTHOBURY (type: esriFieldTypeDouble, alias: Depth of Bury, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4 ft], [5: 5 ft], [5.5: 5.5 ft], ... 11 more ...)
CAST_DATE (type: esriFieldTypeSmallInteger, alias: Cast Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
INSTALL_YR (type: esriFieldTypeSmallInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
INSTALLMTH (type: esriFieldTypeSmallInteger, alias: Month Installed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: January], [2: February], [3: March], ... 9 more ...)
VERT_EXT (type: esriFieldTypeDouble, alias: Verticle Extension, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRAIN_HOLE (type: esriFieldTypeSmallInteger, alias: Drain Holes, SQL Type: sqlTypeOther, nullable: true, editable: true)
PLUGS_REMO (type: esriFieldTypeString, alias: Plugs Removed, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
ELEVATION (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
GPS_Date (type: esriFieldTypeDate, alias: GPS Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
VERIFIED (type: esriFieldTypeString, alias: Verified, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
PRESSURE (type: esriFieldTypeString, alias: Pressure, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [H: High], [L: Low])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
STATIC_PSI (type: esriFieldTypeSmallInteger, alias: Static PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
RESIDUAL_PSI (type: esriFieldTypeSmallInteger, alias: Residual PSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
FLOW_GPM (type: esriFieldTypeSmallInteger, alias: Flow GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
TEST_TAKER (type: esriFieldTypeString, alias: Test Taker, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
TEST_DATE (type: esriFieldTypeDate, alias: Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
IDNO (type: esriFieldTypeString, alias: IDNO, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
T1COMMENT (type: esriFieldTypeString, alias: T1 Comments, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
SHEET__S (type: esriFieldTypeInteger, alias: Ortho Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
Duplicate (type: esriFieldTypeSmallInteger, alias: Duplicate, SQL Type: sqlTypeOther, nullable: true, editable: true)
Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
WINTERCHECK (type: esriFieldTypeString, alias: Winter Check, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Private: Private])
GROUNDWATER (type: esriFieldTypeString, alias: Ground Water, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
WINTERCHECK_COMMENTS (type: esriFieldTypeString, alias: Winter Check Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
WINTERCHECK_DATE (type: esriFieldTypeString, alias: Winter Check Date, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [9/12/2019: 9/12/2019], [9/13/2019: 9/13/2019], [9/16/2019: 9/16/2019], ... 79 more ...)
NO_DRAINER (type: esriFieldTypeString, alias: No Drainer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
PROBLEM_CODE (type: esriFieldTypeString, alias: Problem Code, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [No Problems: No Problems], [Broken Flange: Broken Flange], [Needs Raised: Needs Raised], ... 10 more ...)
GIS_CHANGE (type: esriFieldTypeString, alias: GIS Change, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Complete: Complete])
WINTERCHECKED_BY (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
REPLACE_HYDRANT (type: esriFieldTypeString, alias: Replce Hydrant, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
NEEDS_LETTER (type: esriFieldTypeString, alias: Needs Letter, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
PUMPOUT_LIST (type: esriFieldTypeString, alias: Pumpout List, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [N/A: N/A])
Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
CreatedBy (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: false)
CreatedByDate (type: esriFieldTypeDate, alias: Created By Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
EditedBy (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: false)
EditedByDate (type: esriFieldTypeDate, alias: Edited By Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Flushed (type: esriFieldTypeString, alias: Flushed, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Date_Flushed (type: esriFieldTypeDate, alias: Date Flushed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Types:

Field Name: MUNICIPALITY
Inherited
Field Name: OWNER
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: MODEL
Inherited
Field Name: HYD_VOB
Inherited
Field Name: DEPTHOBURY
Inherited
Field Name: INSTALLMTH
Inherited
Field Name: PLUGS_REMO
Inherited
Field Name: VERIFIED
Inherited
Field Name: PRESSURE
Inherited
Field Name: Enabled
Inherited
Field Name: WINTERCHECK
Inherited
Field Name: GROUNDWATER
Inherited
Field Name: WINTERCHECK_DATE
Inherited
Field Name: NO_DRAINER
Inherited
Field Name: PROBLEM_CODE
Inherited
Field Name: GIS_CHANGE
Inherited
Field Name: REPLACE_HYDRANT
Inherited
Field Name: NEEDS_LETTER
Inherited
Field Name: PUMPOUT_LIST
Inherited

PUBLIC_PVT: Private
Enabled: 1
Flushed: No

Field Name: MUNICIPALITY
Inherited
Field Name: OWNER
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: MODEL
Inherited
Field Name: HYD_VOB
Inherited
Field Name: DEPTHOBURY
Inherited
Field Name: INSTALLMTH
Inherited
Field Name: PLUGS_REMO
Inherited
Field Name: VERIFIED
Inherited
Field Name: PRESSURE
Inherited
Field Name: Enabled
Inherited
Field Name: WINTERCHECK
Inherited
Field Name: GROUNDWATER
Inherited
Field Name: WINTERCHECK_DATE
Inherited
Field Name: NO_DRAINER
Inherited
Field Name: PROBLEM_CODE
Inherited
Field Name: GIS_CHANGE
Inherited
Field Name: REPLACE_HYDRANT
Inherited
Field Name: NEEDS_LETTER
Inherited
Field Name: PUMPOUT_LIST
Inherited

PUBLIC_PVT: Public
Enabled: 1
Flushed: No

Field Name: MUNICIPALITY
Inherited
Field Name: OWNER
Inherited
Field Name: PUBLIC_PVT
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: CONTRACTOR
Inherited
Field Name: MODEL
Inherited
Field Name: HYD_VOB
Inherited
Field Name: DEPTHOBURY
Inherited
Field Name: INSTALLMTH
Inherited
Field Name: PLUGS_REMO
Inherited
Field Name: VERIFIED
Inherited
Field Name: PRESSURE
Inherited
Field Name: Enabled
Inherited
Field Name: WINTERCHECK
Inherited
Field Name: GROUNDWATER
Inherited
Field Name: WINTERCHECK_DATE
Inherited
Field Name: NO_DRAINER
Inherited
Field Name: PROBLEM_CODE
Inherited
Field Name: GIS_CHANGE
Inherited
Field Name: REPLACE_HYDRANT
Inherited
Field Name: NEEDS_LETTER
Inherited
Field Name: PUMPOUT_LIST
Inherited

PUBLIC_PVT: Unknown
Enabled: 1
Flushed: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/12/2023 2:21:13 PM

Schema Last Edit Date: 4/12/2023 2:21:08 PM

Data Last Edit Date: 4/12/2023 2:03:32 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Update Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat