Layers:

Layer: BC_Hydrant (0)


Name: BC_Hydrant

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:

XMin: 12863913.1761834
YMin: 272021.869753987
XMax: 12932900.4767052
YMax: 318035.103354439
Spatial Reference: 2253 (2253)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[124,68,140,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"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:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

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)
• STATIC_PSI_text (type: esriFieldTypeString, alias: Static PSI_text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RESIDUAL_PSI_text (type: esriFieldTypeString, alias: Residual PSI_text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FLOW_GPM_text (type: esriFieldTypeString, alias: Flow GPM_text, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FLOWTEST_ID (type: esriFieldTypeString, alias: Flow Test ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flushtest (type: esriFieldTypeString, alias: Flushtest, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FF_Test (type: esriFieldTypeInteger, alias: FF_Test, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSI_stat (type: esriFieldTypeInteger, alias: PSI_stat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSI_res (type: esriFieldTypeInteger, alias: PSI_res, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_Painted (type: esriFieldTypeDate, alias: Date_Painted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Delete_Me (type: esriFieldTypeDate, alias: Delete_Me, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Name: BC_Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/25/2024 9:31:44 PM

Schema Last Edit Date: 1/25/2024 9:31:44 PM

Data Last Edit Date: 1/25/2024 9:31:44 PM