Layer: BC_Hydrant (ID:0)

View In: Map Viewer

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:

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:

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:

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

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