View In:   ArcGIS Online Map Viewer

Name: Fire Hydrants

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1.1860988765000135E7
YMin: 6987884.236325815
XMax: 1.1897504419987053E7
YMax: 7025864.967122734
Spatial Reference: 102746  (2283)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: BonnetColor
Field 2: Jurisdiction
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other or Missing Data
UniqueValueInfos:
• Value: Blue,DEPT OF ENVIRONMENTAL SERVICES
  Label: Blue, DES
  Description: N/A
  Symbol:
  
• Value: Blue,Dept of Environmental Services
  Label: Blue, DES
  Description: N/A
  Symbol:
  
• Value: Green,DEPT OF ENVIRONMENTAL SERVICES
  Label: Green, DES
  Description: N/A
  Symbol:
  
• Value: Green,Dept of Environmental Services
  Label: Green, DES
  Description: N/A
  Symbol:
  
• Value: Orange,DEPT OF ENVIRONMENTAL SERVICES
  Label: Orange, DES
  Description: N/A
  Symbol:
  
• Value: Orange,Dept of Environmental Services
  Label: Orange, DES
  Description: N/A
  Symbol:
  
• Value: Red,DEPT OF ENVIRONMENTAL SERVICES
  Label: Red, DES
  Description: N/A
  Symbol:
  
• Value: Red,Dept of Environmental Services
  Label: Red, DES
  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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: BonnetColor

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ID )
• StructureID ( type: esriFieldTypeString, alias: StructureID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StructureID )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• Jurisdiction ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Jurisdiction )
• BonnetColor ( type: esriFieldTypeString, alias: BonnetColor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BonnetColor )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• ManufactureDate ( type: esriFieldTypeDate, alias: ManufactureDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ManufactureDate )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Notes )
• Retired ( type: esriFieldTypeDate, alias: Retired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Retired )
• Replaced ( type: esriFieldTypeDate, alias: Replaced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Replaced )
• Installed ( type: esriFieldTypeDate, alias: Installed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Installed )
• cgGeoSyncDate ( type: esriFieldTypeDate, alias: cgGeoSyncDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cgGeoSyncDate )
• MapQuadRefID ( type: esriFieldTypeString, alias: MapQuadRefID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MapQuadRefID )
• IntersectionDrawing ( type: esriFieldTypeString, alias: IntersectionDrawing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IntersectionDrawing )
• PermitNumber ( type: esriFieldTypeString, alias: PermitNumber, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PermitNumber )
• PermitStartDate ( type: esriFieldTypeDate, alias: PermitStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PermitStartDate )
• PermitExpireDate ( type: esriFieldTypeDate, alias: PermitExpireDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PermitExpireDate )
• AsBuiltDrawingNumber ( type: esriFieldTypeString, alias: AsBuiltDrawingNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AsBuiltDrawingNumber )
• MonthyFlushing ( type: esriFieldTypeSmallInteger, alias: MonthyFlushing, editable: true, nullable: true, defaultValue: null, modelName: MonthyFlushing )
• HydrantDepth ( type: esriFieldTypeDouble, alias: HydrantDepth, editable: true, nullable: true, defaultValue: null, modelName: HydrantDepth )
• HydrantDepth_unit ( type: esriFieldTypeString, alias: HydrantDepth_unit, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HydrantDepth_unit )
• BodyColor ( type: esriFieldTypeString, alias: BodyColor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BodyColor )
• DirectiontoTurn ( type: esriFieldTypeString, alias: DirectiontoTurn, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DirectiontoTurn )
• FireDistrict ( type: esriFieldTypeString, alias: FireDistrict, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FireDistrict )
• PressureZone ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureZone )
• NumberOfTurnsToOpen ( type: esriFieldTypeDouble, alias: NumberOfTurnsToOpen, editable: true, nullable: true, defaultValue: null, modelName: NumberOfTurnsToOpen )
• OperatingNutSize ( type: esriFieldTypeString, alias: OperatingNutSize, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OperatingNutSize )
• SerialNumber ( type: esriFieldTypeString, alias: SerialNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SerialNumber )
• EntryDate ( type: esriFieldTypeDate, alias: EntryDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EntryDate )
• cgLastModified ( type: esriFieldTypeDate, alias: cgLastModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cgLastModified )
• Main ( type: esriFieldTypeString, alias: Main, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Main )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost, editable: true, nullable: true, defaultValue: null, modelName: TotalCost )
• LocatorCity ( type: esriFieldTypeString, alias: LocatorCity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocatorCity )
• LocatorStreet ( type: esriFieldTypeString, alias: LocatorStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocatorStreet )
• LocatorAddressNumber ( type: esriFieldTypeString, alias: LocatorAddressNumber, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LocatorAddressNumber )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 32, defaultValue: null, modelName: County )
• AddressNumber ( type: esriFieldTypeDouble, alias: AddressNumber, editable: true, nullable: true, defaultValue: null, modelName: AddressNumber )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Street )
• StateValue ( type: esriFieldTypeString, alias: StateValue, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StateValue )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• EstimatedOCI ( type: esriFieldTypeDouble, alias: EstimatedOCI, editable: true, nullable: true, defaultValue: null, modelName: EstimatedOCI )
• LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LocationDescription )
• TopColorField ( type: esriFieldTypeString, alias: TopColorField, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TopColorField )
• wtHydrantMainGeneralOID ( type: esriFieldTypeInteger, alias: wtHydrantMainGeneralOID, editable: true, nullable: true, defaultValue: null, modelName: wtHydrantMainGeneralOID )
• DeadEnd ( type: esriFieldTypeString, alias: DeadEnd, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DeadEnd )
• TheoreticalHGLFt ( type: esriFieldTypeDouble, alias: TheoreticalHGLFt, editable: true, nullable: true, defaultValue: null, modelName: TheoreticalHGLFt )
• TheoreticalStaticPressurePSI ( type: esriFieldTypeDouble, alias: TheoreticalStaticPressurePSI, editable: true, nullable: true, defaultValue: null, modelName: TheoreticalStaticPressurePSI )
• ElevationFt ( type: esriFieldTypeDouble, alias: ElevationFt, editable: true, nullable: true, defaultValue: null, modelName: ElevationFt )
• OutOfServiceReason ( type: esriFieldTypeString, alias: OutOfServiceReason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OutOfServiceReason )
• FirstDueStatus ( type: esriFieldTypeString, alias: FirstDueStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FirstDueStatus )
• geoSyncDate ( type: esriFieldTypeDate, alias: GeoSyncDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: geoSyncDate )
• FirstDueGPM ( type: esriFieldTypeSmallInteger, alias: FirstDueGPM, editable: true, nullable: true, defaultValue: null, modelName: FirstDueGPM )
• FlowRateGPM ( type: esriFieldTypeDouble, alias: FlowRateGPM, editable: true, nullable: true, defaultValue: null, modelName: FlowRateGPM )

Types:

ID: Blue
Name: Blue, DES
Domains:
Templates:
• Name: Blue, DES
  Description:
  Prototype:
  Jurisdiction: DEPT OF ENVIRONMENTAL SERVICES
  Status: null
  FirstDueGPM: null
  ID: null
  StructureID: null
  BonnetColor: Blue
  Manufacturer: null
  Model: null
  ManufactureDate: null
  Notes: null
  Retired: null
  Replaced: null
  Installed: null
  cgGeoSyncDate: null
  MapQuadRefID: null
  IntersectionDrawing: null
  PermitNumber: null
  PermitStartDate: null
  PermitExpireDate: null
  AsBuiltDrawingNumber: null
  MonthyFlushing: null
  HydrantDepth: null
  HydrantDepth_unit: null
  BodyColor: null
  DirectiontoTurn: null
  FireDistrict: null
  PressureZone: null
  NumberOfTurnsToOpen: null
  OperatingNutSize: null
  SerialNumber: null
  EntryDate: null
  cgLastModified: null
  Main: null
  TotalCost: null
  LocatorCity: null
  LocatorStreet: null
  LocatorAddressNumber: null
  County: null
  AddressNumber: null
  Street: null
  StateValue: null
  City: null
  EstimatedOCI: null
  LocationDescription: null
  TopColorField: null
  wtHydrantMainGeneralOID: null
  DeadEnd: null
  TheoreticalHGLFt: null
  TheoreticalStaticPressurePSI: null
  ElevationFt: null
  OutOfServiceReason: null
  FirstDueStatus: null
  geoSyncDate: null
  FlowRateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Green
Name: Green, DES
Domains:
Templates:
• Name: Green, DES
  Description:
  Prototype:
  Jurisdiction: DEPT OF ENVIRONMENTAL SERVICES
  Status: null
  FirstDueGPM: null
  ID: null
  StructureID: null
  BonnetColor: Green
  Manufacturer: null
  Model: null
  ManufactureDate: null
  Notes: null
  Retired: null
  Replaced: null
  Installed: null
  cgGeoSyncDate: null
  MapQuadRefID: null
  IntersectionDrawing: null
  PermitNumber: null
  PermitStartDate: null
  PermitExpireDate: null
  AsBuiltDrawingNumber: null
  MonthyFlushing: null
  HydrantDepth: null
  HydrantDepth_unit: null
  BodyColor: null
  DirectiontoTurn: null
  FireDistrict: null
  PressureZone: null
  NumberOfTurnsToOpen: null
  OperatingNutSize: null
  SerialNumber: null
  EntryDate: null
  cgLastModified: null
  Main: null
  TotalCost: null
  LocatorCity: null
  LocatorStreet: null
  LocatorAddressNumber: null
  County: null
  AddressNumber: null
  Street: null
  StateValue: null
  City: null
  EstimatedOCI: null
  LocationDescription: null
  TopColorField: null
  wtHydrantMainGeneralOID: null
  DeadEnd: null
  TheoreticalHGLFt: null
  TheoreticalStaticPressurePSI: null
  ElevationFt: null
  OutOfServiceReason: null
  FirstDueStatus: null
  geoSyncDate: null
  FlowRateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Orange
Name: Orange, DES
Domains:
Templates:
• Name: Orange, DES
  Description:
  Prototype:
  Jurisdiction: DEPT OF ENVIRONMENTAL SERVICES
  Status: null
  FirstDueGPM: null
  ID: null
  StructureID: null
  BonnetColor: Orange
  Manufacturer: null
  Model: null
  ManufactureDate: null
  Notes: null
  Retired: null
  Replaced: null
  Installed: null
  cgGeoSyncDate: null
  MapQuadRefID: null
  IntersectionDrawing: null
  PermitNumber: null
  PermitStartDate: null
  PermitExpireDate: null
  AsBuiltDrawingNumber: null
  MonthyFlushing: null
  HydrantDepth: null
  HydrantDepth_unit: null
  BodyColor: null
  DirectiontoTurn: null
  FireDistrict: null
  PressureZone: null
  NumberOfTurnsToOpen: null
  OperatingNutSize: null
  SerialNumber: null
  EntryDate: null
  cgLastModified: null
  Main: null
  TotalCost: null
  LocatorCity: null
  LocatorStreet: null
  LocatorAddressNumber: null
  County: null
  AddressNumber: null
  Street: null
  StateValue: null
  City: null
  EstimatedOCI: null
  LocationDescription: null
  TopColorField: null
  wtHydrantMainGeneralOID: null
  DeadEnd: null
  TheoreticalHGLFt: null
  TheoreticalStaticPressurePSI: null
  ElevationFt: null
  OutOfServiceReason: null
  FirstDueStatus: null
  geoSyncDate: null
  FlowRateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Red
Name: Red, DES
Domains:
Templates:
• Name: Red, DES
  Description:
  Prototype:
  Jurisdiction: DEPT OF ENVIRONMENTAL SERVICES
  Status: null
  FirstDueGPM: null
  ID: null
  StructureID: null
  BonnetColor: Red
  Manufacturer: null
  Model: null
  ManufactureDate: null
  Notes: null
  Retired: null
  Replaced: null
  Installed: null
  cgGeoSyncDate: null
  MapQuadRefID: null
  IntersectionDrawing: null
  PermitNumber: null
  PermitStartDate: null
  PermitExpireDate: null
  AsBuiltDrawingNumber: null
  MonthyFlushing: null
  HydrantDepth: null
  HydrantDepth_unit: null
  BodyColor: null
  DirectiontoTurn: null
  FireDistrict: null
  PressureZone: null
  NumberOfTurnsToOpen: null
  OperatingNutSize: null
  SerialNumber: null
  EntryDate: null
  cgLastModified: null
  Main: null
  TotalCost: null
  LocatorCity: null
  LocatorStreet: null
  LocatorAddressNumber: null
  County: null
  AddressNumber: null
  Street: null
  StateValue: null
  City: null
  EstimatedOCI: null
  LocationDescription: null
  TopColorField: null
  wtHydrantMainGeneralOID: null
  DeadEnd: null
  TheoreticalHGLFt: null
  TheoreticalStaticPressurePSI: null
  ElevationFt: null
  OutOfServiceReason: null
  FirstDueStatus: null
  geoSyncDate: null
  FlowRateGPM: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata