Name: Hydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1006379.634
YMin: 1822530.4
XMax: 1051023.018
YMax: 1875235.474
Spatial Reference: PROJCS["NAD_1983_HARN_StatePlane_Illinois_East_FIPS_1201",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-88.33333333333333],PARAMETER["Scale_Factor",0.999975],PARAMETER["Latitude_Of_Origin",36.66666666666666],UNIT["Foot_US",0.3048006096012192]]

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,0,113,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PRESSURESYSTEM (type: esriFieldTypeString, alias: PRESSURESYSTEM, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [HIGH: High Pressure], [NORMAL: Normal Pressure])
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LIFECYCLESTATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [AB: Abandoned], [UNC: Under Construction], ... 3 more ...)
• SUBTYPE (type: esriFieldTypeInteger, alias: SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: WaterType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [POTABLE: POTABLE], [RAW: NON POTABLE])
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [MU: Mueller], [CL: Clow], ... 4 more ...)
• NOZZLEDIAMETER1 (type: esriFieldTypeDouble, alias: NOZZLEDIAMETER1, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [2 - 4.5])
• NOZZLEDIAMETER2 (type: esriFieldTypeDouble, alias: NOZZLEDIAMETER2, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [2 - 4.5])
• NOZZLEDIAMETER3 (type: esriFieldTypeDouble, alias: NOZZLEDIAMETER3, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [2 - 4.5])
• OUTLETCONFIGURATION (type: esriFieldTypeString, alias: OUTLETCONFIGURATION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [OTH: Other], [TWO: Two Nozzle], ... 2 more ...)
• SEATDIAMETER (type: esriFieldTypeDouble, alias: SEATDIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [4 - 6.5])
• MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: Unknown], [2: WB77-Waterous 4.75], [3: WB67-Waterous 5.25], ... 14 more ...)
• HYDLINEDIAMETER (type: esriFieldTypeDouble, alias: HYDLINEDIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [3: 3"], [4: 4"], [6: 6"], ... 2 more ...)
• HYDLINELENGTH (type: esriFieldTypeDouble, alias: HYDLINELENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HYDLINEMATERIAL (type: esriFieldTypeString, alias: HYDLINEMATERIAL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [CIP: Cast Iron Pipe], [CP: Copper], [PVC: Polyvinylchloride], ... 2 more ...)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [DPUW: Department of Utilities - Water/Wastewater], [UNK: Unknown], [PRI: Private], ... 4 more ...)
• DATASOURCE (type: esriFieldTypeString, alias: DATASOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ASBDWG: As-built Drawing], [ENGDWG: Engineering Drawing], [EXFHCV: Existing Fire Hydrant Coverage], ... 12 more ...)
• TIFFNUMBER (type: esriFieldTypeString, alias: TIFFNUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BASIN (type: esriFieldTypeString, alias: BASIN, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HYDRANTID (type: esriFieldTypeString, alias: HYDRANTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GPS_CREW_COMMENT (type: esriFieldTypeString, alias: GPS_CREW_COMMENT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YEAR_INSTALLED (type: esriFieldTypeSmallInteger, alias: YEAR_INSTALLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATIC_PRESSURE (type: esriFieldTypeSmallInteger, alias: STATIC_PRESSURE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATIC_TESTDATE (type: esriFieldTypeDate, alias: STATIC_TESTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YEAR_MANUFACTURED (type: esriFieldTypeSmallInteger, alias: YEAR_MANUFACTURED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EDITDATE (type: esriFieldTypeDate, alias: EDITDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HYDRANT_FLAG (type: esriFieldTypeString, alias: hydrant flag, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [U: Unk])
• LUBE_PORT (type: esriFieldTypeString, alias: lube port, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes], [U: Unk])
• INSPECTOR (type: esriFieldTypeString, alias: inspector, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: )
• STATUS (type: esriFieldTypeString, alias: status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: )
• MODELLED_FLOW (type: esriFieldTypeString, alias: MODELLED_FLOW, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ANCILLARYROLE: 0
• ENABLED: 1
• PRESSURESYSTEM: NORMAL
• LIFECYCLESTATUS: IS
• SUBTYPE: 0
• WATERTYPE: POTABLE
• MANUFACTURER: UNK
• NOZZLEDIAMETER1: 2.5
• NOZZLEDIAMETER2: 2.5
• NOZZLEDIAMETER3: 4.5
• OUTLETCONFIGURATION: THREE
• MODEL: UNK
• HYDLINEDIAMETER: 6
• HYDLINELENGTH: 5
• HYDLINEMATERIAL: DIP
• OWNER: DPUW
• STATIC_PRESSURE: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/24/2020 8:05:47 PM

Schema Last Edit Date: 7/24/2020 8:05:47 PM

Data Last Edit Date: 7/24/2020 8:05:47 PM

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