Name: Hydrants

Display Field: GEODBID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: OBJECTID: System-generated unique identifier for each record within the feature classShape: System-generated geometry type of the feature GEODBID: Three-digit code that assigns editing responsibility to a community in the GIS ConsortiumFEATUREID: GIS-Consortium-generated unique identifier for each record within the feature class. All FEATUREIDs start with the GEODBID of the community that owns the record.DATECREATED: Date/time stamp from the moment the GIS record was createdDATEMODIFIED: Date/time stamp from the last moment the GIS record was changedSOURCE: Organization that provided the data. The GIS Consortium standard is to preface the source with the three-letter municipal code of the community providing the data, followed by a dash. Example: VGV-Public WorksSOURCETYPE: Accuracy context for the recordAncillaryRole: Attribute that indicates whether the junction pushes (source) or pulls (sink) flow in a geometric network. Default setting for the GIS Consortium is none.Enabled: Boolean field to indicate whether water is allowed to flow through this featureADMINISTRATIVEAREA: Owner of the area in which the feature is locatedINSTALLDATE: Date of installation for the real-world feature represented in the feature classLOCATIONDESCRIPTION: Statement illustrating the whereabouts of a featureOPERATIONALAREA: Retired field used to store a description for an operational area designated by a community ROTATION: Retired GIS tracking field used to turn the symbol that represents the feature on the map so that it matched how it would look in the real worldLIFECYCLESTATUS: Current state of the real-world featureSUBTYPE: Field's purpose is unknownWORKORDERID: Unique work order identifierELEVATION: Ground level height of real-world feature; measured in feet above sea levelWATERTYPE: Designation of water distribution or collection system to which the feature appliesBARRELDIAMETER: width of the barrel of the real-world feature; measured in inchesMAINVALVETYPE: Type of valve used for the hydrantNOZZLEDIAMETER1: The width measurement of one out of four possible nozzles on the hydrant; measured in inchesNOZZLEDIAMETER2: The width measurement of one out of four possible nozzles on the hydrant; measured in inchesNOZZLEDIAMETER3: The width measurement of one out of four possible nozzles on the hydrant; measured in inchesNOZZLEDIAMETER4: The width measurement of one out of four possible nozzles on the hydrant; measured in inchesOUTLETCONFIGURATION: The configuration of the hydrant outletsSEATDIAMETER: The width measurement of the hydrant seat; measured in inchesMANUFACTURER: company/organization that produces the real-world featureMODEL: Specific version of the manufactured real-world featureLEGACYTYPE: Retired GIS tracking code for the featureDEVICEID: Unique identifying code for the mechanical part, such as a serial number or model numberCOMMUNITYID: Unique identifying code selected by the communityOWNERSHIP: Organization with jurisdiction over the real-world feature represented in the feature classMAINTAINED: Organization responsible for the care of the real-world feature represented in the feature classDESCRIPTION: Statement illustrating the featureFID_SSJUNCTIONANNO_LINE: Unique identifier that can be joined to the FEATUREID field of the ssJunctionAnno_LINE feature class to provide a link between the feature and its label.CATEGORY: Retired field required for ArcGIS coverage modelsBREAKAWAYFLANGE: The description of the breakaway flange used within the fire hydrantDELINEATED: Field's purpose is unknownREPLICAFILTER: Code used to filter data for the creation of custom geodatabases PRODUCTIONNOTES: Technical notes from GIS personnelWEBLINK: URL for a website related to the recordDRAINER: Boolean field to indicate the presence of a drainerPURPOSE: Text field to describe how the hydrant is used, e.g. fire suppression, irrigationGlobalID: System-generated unique identifier for each record that is required in replicated geodatabasesDATEPAINTED: The date of when the hydrant was last paintedHASFLAG: Indicates whether a hydrant has a flag or notCOLORSCHEME: Indicates the color of the asset

Copyright Text: Created by the GIS Consortium's members with ongoing updates.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 12000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -17463800
YMin: -46132600
XMax: 1255927.1675000004
YMax: 2103339.5247500017
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: VAH
  Label: Village of Arlington Heights
  Description: N/A
  Symbol:
  
• Value: PRIVATE
  Label: Private
  Description: N/A
  Symbol:
  
• Value: CRM
  Label: City of Rolling Meadows
  Description: N/A
  Symbol:
  
• Value: VBG
  Label: Village of Buffalo Grove
  Description: N/A
  Symbol:
  
• Value: VMP
  Label: Village of Mount Prospect
  Description: N/A
  Symbol:
  
• Value: UNK
  Label: Village of Palatine
  Description: N/A
  Symbol:
  
• Value: VWH
  Label: Village of Wheeling
  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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GEODBID ( type: esriFieldTypeString, alias: GEODBID, length: 3 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATUREID, length: 15 )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, length: 8 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, length: 8 )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, length: 20 )
• SOURCETYPE ( type: esriFieldTypeString, alias: SOURCETYPE, length: 20 )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled )
• INSTALLDATE ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LocationDescription, length: 200 )
• OPERATIONALAREA ( type: esriFieldTypeString, alias: OperationalArea, length: 20 )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 )
• SUBTYPE ( type: esriFieldTypeInteger, alias: Subtype )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, length: 255 )
• BARRELDIAMETER ( type: esriFieldTypeDouble, alias: BarrelDiameter )
• MAINVALVETYPE ( type: esriFieldTypeString, alias: MainValveType, length: 20 )
• NOZZLEDIAMETER1 ( type: esriFieldTypeDouble, alias: NozzleDiameter1 )
• NOZZLEDIAMETER2 ( type: esriFieldTypeDouble, alias: NozzleDiameter2 )
• NOZZLEDIAMETER3 ( type: esriFieldTypeDouble, alias: NozzleDiameter3 )
• NOZZLEDIAMETER4 ( type: esriFieldTypeDouble, alias: NozzleDiameter4 )
• OUTLETCONFIGURATION ( type: esriFieldTypeString, alias: OutletConfiguration, length: 20 )
• SEATDIAMETER ( type: esriFieldTypeInteger, alias: SeatDiameter )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 20 )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 30 )
• DEVICEID ( type: esriFieldTypeInteger, alias: DeviceID )
• COMMUNITYID ( type: esriFieldTypeString, alias: CommunityID, length: 20 )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, length: 9 )
• MAINTAINED ( type: esriFieldTypeString, alias: Maintained, length: 9 )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, length: 255 )
• FID_WSJUNCTIONANNO_LINE ( type: esriFieldTypeString, alias: FID_WSJUNCTIONANNO_LINE, length: 15 )
• BREAKAWAYFLANGE ( type: esriFieldTypeString, alias: BREAKAWAYFLANGE, length: 20 )
• DELINEATED ( type: esriFieldTypeString, alias: DELINEATED, length: 30 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• REPLICAFILTER ( type: esriFieldTypeString, alias: REPLICAFILTER, length: 255 )
• PRODUCTIONNOTES ( type: esriFieldTypeString, alias: PRODUCTIONNOTES, length: 100 )
• WEBLINK ( type: esriFieldTypeString, alias: WEBLINK, length: 255 )
• DRAINER ( type: esriFieldTypeSmallInteger, alias: DRAINER )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, length: 255 )
• HASFLAG ( type: esriFieldTypeSmallInteger, alias: HASFLAG )
• CREATEDBY ( type: esriFieldTypeString, alias: CREATEDBY, length: 100 )
• MODIFIEDBY ( type: esriFieldTypeString, alias: MODIFIEDBY, length: 100 )
• DATEABANDONED ( type: esriFieldTypeDate, alias: DATEABANDONED, length: 8 )
• OWNERSHIPDESCRIPTION ( type: esriFieldTypeString, alias: OWNERSHIPDESCRIPTION, length: 50 )
• MAINTAINEDDESCRIPTION ( type: esriFieldTypeString, alias: MAINTAINEDDESCRIPTION, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• QANOTES ( type: esriFieldTypeString, alias: QA Notes, length: 255 )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• FIELDVERIFICATIONSTATUS ( type: esriFieldTypeString, alias: Field Verification Status, length: 10 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• QASTATUS ( type: esriFieldTypeString, alias: QA Status, length: 10 )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• FIELDVERIFICATIONNOTES ( type: esriFieldTypeString, alias: Field Verification Notes, length: 255 )
• DATESTAMPED ( type: esriFieldTypeDate, alias: DATESTAMPED, length: 8 )
• HASSECURITYDEVICE ( type: esriFieldTypeString, alias: HASSECURITYDEVICE, length: 10 )
• ISDEADEND ( type: esriFieldTypeString, alias: ISDEADEND, length: 10 )
• SYS_RELATEDRECORDJSON ( type: esriFieldTypeString, alias: SYS_RELATEDRECORDJSON, length: 1000 )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• ERP_CW_LastInspected ( type: esriFieldTypeDate, alias: CityWorks - Last Inspected Date, length: 8 )
• ERP_CW_LastRepaired ( type: esriFieldTypeDate, alias: CityWorks - Last Repaired Date, length: 8 )
• ERP_CW_Score ( type: esriFieldTypeDouble, alias: CityWorks - Score )
• ERP_CW_NearestAddress ( type: esriFieldTypeString, alias: CityWorks - Nearest Address, length: 50 )
• ERP_CW_Cycle ( type: esriFieldTypeString, alias: CityWorks - Maintenance Cycle, length: 50 )
• ERP_CW_POF ( type: esriFieldTypeDouble, alias: CityWorks - Probability of Failure )
• ERP_CW_COF ( type: esriFieldTypeDouble, alias: CityWorks - Consequence of Failure )
• ERP_CW_BRE ( type: esriFieldTypeDouble, alias: CityWorks - Business Risk Exposure )
• ERP_CW_MSPU ( type: esriFieldTypeDouble, alias: CityWorks - Under-maintained Proactive Maintenance Score )
• ERP_CW_MSPO ( type: esriFieldTypeDouble, alias: CityWorks - Over-maintained Proactive Maintenance Score )
• ERP_CW_MSR ( type: esriFieldTypeDouble, alias: CityWorks - Reactive Maintenance Score )
• ERP_CW_AVERAGEENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Average End Year )
• ERP_CW_FASTENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Fast End Year )
• ERP_CW_SLOWENDYEAR ( type: esriFieldTypeSmallInteger, alias: CityWorks - Slow End Year )
• ERP_CW_CALCULATIONNAME ( type: esriFieldTypeString, alias: CityWorks - Calculation Name, length: 50 )
• ERP_CW_DATECALCULATED ( type: esriFieldTypeDate, alias: CityWorks - Date Calculated, length: 8 )
• ERP_CW_MAINTZONE ( type: esriFieldTypeString, alias: CityWorks - Maintenance Zone, length: 50 )
• ERP_CW_LastFlush ( type: esriFieldTypeDate, alias: CityWorks - Last Flushed, length: 8 )
• ERP_CW_Color ( type: esriFieldTypeString, alias: CityWorks - Hydrant Color, length: 50 )
• ERP_CW_AvailFlow20PSI ( type: esriFieldTypeDouble, alias: CityWorks - Available Flow )
• ERP_CW_FlowRate ( type: esriFieldTypeDouble, alias: CityWorks - Flow Rate )
• ERP_CW_LastFlowTested ( type: esriFieldTypeDate, alias: CityWorks - Last Flow Test, length: 8 )
• ERP_CW_INITIALVALUE ( type: esriFieldTypeDouble, alias: CityWorks - Initial Value )
• ERP_CW_GallonsPerMin ( type: esriFieldTypeDouble, alias: ERP_CW_GallonsPerMin )
• ERP_CW_StaticPressure ( type: esriFieldTypeDouble, alias: ERP_CW_StaticPressure )
• ERP_CW_ResidualPressure ( type: esriFieldTypeDouble, alias: ERP_CW_ResidualPressure )
• ERP_CW_PitotTestResult ( type: esriFieldTypeDouble, alias: ERP_CW_PitotTestResult )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata