View In:   ArcGIS Online Map Viewer

Parent Layer: Fire Hydrant

Name: Fire Hydrant Inspections 2018

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 000c4b82c94f47299165513763a240a9

Copyright Text:

Default Visibility: false

MaxRecordCount: 100000

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: 1465585.3975499868
YMin: 733865.7539249957
XMax: 1499829.2663999945
YMax: 760603.4438749999
Spatial Reference: 102723  (3735)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: HydGPM
Min. Value: 0.0
ClassBreakInfos:
• Class Maximum Value: 500
  Label: 0 - 500 GPM
  Description: N/A
  Symbol:
  
• Class Maximum Value: 1000
  Label: 500 - 1000 GPM
  Description: N/A
  Symbol:
  
• Class Maximum Value: 1500
  Label: 1000 - 1500 GPM
  Description: N/A
  Symbol:
  
• Class Maximum Value: 2000
  Label: Greater Than 1500 GPM
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [TroyHydrantNumber]
Use Coded Values: true
Symbol:
Color: [255, 85, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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:

Fields:

• TroyHydrantNumber ( type: esriFieldTypeSmallInteger, alias: Troy Hydrant Number, editable: true, nullable: true, defaultValue: null, modelName: TroyHydrantNumber_ )
• HouseNum ( type: esriFieldTypeSmallInteger, alias: House Number, editable: true, nullable: true, defaultValue: null, modelName: HouseNum_ )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName_ , Coded Values: [1st: 1st St] , [2nd: 2nd St] , [3rd: 3rd St] , ...610 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate_ )
• HydManufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydManufacturer_ , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Mueller Company: Mueller Company] , ...2 more... )
• Stat ( type: esriFieldTypeSmallInteger, alias: Static, editable: true, nullable: true, defaultValue: null, modelName: Stat_ )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient, editable: true, nullable: true, defaultValue: null, modelName: Coefficient_ )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter_ )
• HydGPM ( type: esriFieldTypeDouble, alias: Gallons Per Minute, editable: true, nullable: true, defaultValue: null, modelName: HydGPM_ )
• HydGPM_20 ( type: esriFieldTypeDouble, alias: GPM at 20 PSI, editable: true, nullable: true, defaultValue: null, modelName: HydGPM_20_ )
• HydGPM_10 ( type: esriFieldTypeDouble, alias: GPM at 10 PSI, editable: true, nullable: true, defaultValue: null, modelName: HydGPM_10_ )
• HydGPM_0 ( type: esriFieldTypeDouble, alias: GPM at 0 PSI, editable: true, nullable: true, defaultValue: null, modelName: HydGPM_0_ )
• CapacityClass ( type: esriFieldTypeString, alias: Capacity Class, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CapacityClass_ , Coded Values: [CLASS AA: CLASS AA] , [CLASS A: CLASS A] , [CLASS B: CLASS B] , ...1 more... )
• OperatesHard ( type: esriFieldTypeSmallInteger, alias: Operates Hard, editable: true, nullable: true, defaultValue: null, modelName: OperatesHard_ , Coded Values: [1: Yes] , [2: No] )
• Greased ( type: esriFieldTypeSmallInteger, alias: Hydrant Greased, editable: true, nullable: true, defaultValue: null, modelName: Greased_ , Coded Values: [1: Yes] , [2: No] )
• Paint ( type: esriFieldTypeSmallInteger, alias: Needs Paint, editable: true, nullable: true, defaultValue: null, modelName: Paint_ , Coded Values: [1: Yes] , [2: No] )
• OverallCondition ( type: esriFieldTypeString, alias: Overall Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OverallCondition_ , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Status ( type: esriFieldTypeString, alias: Inspection Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Status_ , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• YearPainted ( type: esriFieldTypeString, alias: Year Painted, editable: true, nullable: true, length: 25, defaultValue: null, modelName: YearPainted_ )
• OBJECTID_12 ( type: esriFieldTypeDouble, alias: OBJECTID_12, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_12 )
• TroyHydrantNumber_1 ( type: esriFieldTypeDouble, alias: TroyHydrantNumber_1, editable: true, nullable: true, defaultValue: null, modelName: TroyHydrantNumber_1 )
• HouseNum_1 ( type: esriFieldTypeDouble, alias: HouseNum_1, editable: true, nullable: true, defaultValue: null, modelName: HouseNum_1 )
• Static__in_psi_ ( type: esriFieldTypeDouble, alias: Static__in_psi_, editable: true, nullable: true, defaultValue: null, modelName: Static__in_psi_ )
• Residual__in_psi_ ( type: esriFieldTypeDouble, alias: Residual__in_psi_, editable: true, nullable: true, defaultValue: null, modelName: Residual__in_psi_ )
• Pitot__gauge_reading_ ( type: esriFieldTypeDouble, alias: Pitot__gauge_reading_, editable: true, nullable: true, defaultValue: null, modelName: Pitot__gauge_reading_ )
• Coefficient_1 ( type: esriFieldTypeDouble, alias: Coefficient_1, editable: true, nullable: true, defaultValue: null, modelName: Coefficient_1 )
• Diameter__in_inches_ ( type: esriFieldTypeDouble, alias: Diameter__in_inches_, editable: true, nullable: true, defaultValue: null, modelName: Diameter__in_inches_ )
• HydGPM__calculated_ ( type: esriFieldTypeDouble, alias: HydGPM__calculated_, editable: true, nullable: true, defaultValue: null, modelName: HydGPM__calculated_ )
• x ( type: esriFieldTypeDouble, alias: x, editable: true, nullable: true, defaultValue: null, modelName: x )
• y ( type: esriFieldTypeDouble, alias: y, editable: true, nullable: true, defaultValue: null, modelName: y )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Operable ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: true, defaultValue: null, modelName: Operable_ , Coded Values: [1: Yes] , [2: No] )
• Residual ( type: esriFieldTypeSmallInteger, alias: Residual, editable: true, nullable: true, defaultValue: null, modelName: Residual_ )
• Pitot ( type: esriFieldTypeSmallInteger, alias: Pitot, editable: true, nullable: true, defaultValue: null, modelName: Pitot_ )
• Zerk ( type: esriFieldTypeString, alias: Zerk, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Zerk_ , Coded Values: [New: New] , [Ok: Ok] , [Needs Replaced: Needs Replaced] )
• Housing ( type: esriFieldTypeString, alias: Housing, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Housing_ , Coded Values: [Ok: Ok] , [Loose: Loose] , [Damaged: Damaged] )
• Cap ( type: esriFieldTypeString, alias: Cap, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Cap_ , Coded Values: [Tight: Tight] , [Ok: Ok] , [Loose: Loose] , ...1 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments_ )
• OBJECTID_1 ( type: esriFieldTypeInteger, alias: OBJECTID_1, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_1 )
• StreetName_1 ( type: esriFieldTypeString, alias: StreetName_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetName_1 )
• Date_of_Inspection ( type: esriFieldTypeString, alias: Date_of_Inspection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Date_of_Inspection )
• Operable_1 ( type: esriFieldTypeString, alias: Operable_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operable_1 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Manufacturer )
• HydGPM_20__calculated_ ( type: esriFieldTypeString, alias: HydGPM_20__calculated_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydGPM_20__calculated_ )
• HydGPM_10__calculated_ ( type: esriFieldTypeString, alias: HydGPM_10__calculated_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydGPM_10__calculated_ )
• HydGPM_0__calculated_ ( type: esriFieldTypeString, alias: HydGPM_0__calculated_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HydGPM_0__calculated_ )
• Capacity_Class ( type: esriFieldTypeString, alias: Capacity_Class, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Capacity_Class )
• Operates_Hard_ ( type: esriFieldTypeString, alias: Operates_Hard_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operates_Hard_ )
• Zerk_1 ( type: esriFieldTypeString, alias: Zerk_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Zerk_1 )
• Housing_1 ( type: esriFieldTypeString, alias: Housing_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Housing_1 )
• Cap_1 ( type: esriFieldTypeString, alias: Cap_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cap_1 )
• Hydrant_Greased_ ( type: esriFieldTypeString, alias: Hydrant_Greased_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hydrant_Greased_ )
• Needs_Paint_ ( type: esriFieldTypeString, alias: Needs_Paint_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Needs_Paint_ )
• OverallCondition_1 ( type: esriFieldTypeString, alias: OverallCondition_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OverallCondition_1 )
• Hydrant_Status ( type: esriFieldTypeString, alias: Hydrant_Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hydrant_Status )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• YearPainted_1 ( type: esriFieldTypeString, alias: YearPainted_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: YearPainted_1 )
• Date ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date )
• Station ( type: esriFieldTypeString, alias: Station, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Station )
• Zone ( type: esriFieldTypeString, alias: Zone, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Zone )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: <Null>
  Description:
  Prototype:
  Diameter: null
  Zone: null
  TroyHydrantNumber: null
  HouseNum: null
  StreetName: null
  InspectionDate: null
  HydManufacturer: null
  Stat: null
  Coefficient: null
  HydGPM: null
  HydGPM_20: null
  HydGPM_10: null
  HydGPM_0: null
  CapacityClass: null
  OperatesHard: null
  Greased: null
  Paint: null
  OverallCondition: null
  Status: null
  YearPainted: null
  OBJECTID_12: null
  TroyHydrantNumber_1: null
  HouseNum_1: null
  Static__in_psi_: null
  Residual__in_psi_: null
  Pitot__gauge_reading_: null
  Coefficient_1: null
  Diameter__in_inches_: null
  HydGPM__calculated_: null
  x: null
  y: null
  Station: null
  Operable: null
  Residual: null
  Pitot: null
  Zerk: null
  Housing: null
  Cap: null
  Comments: null
  OBJECTID_1: null
  StreetName_1: null
  Date_of_Inspection: null
  Operable_1: null
  Manufacturer: null
  HydGPM_20__calculated_: null
  HydGPM_10__calculated_: null
  HydGPM_0__calculated_: null
  Capacity_Class: null
  Operates_Hard_: null
  Zerk_1: null
  Housing_1: null
  Cap_1: null
  Hydrant_Greased_: null
  Needs_Paint_: null
  OverallCondition_1: null
  Hydrant_Status: null
  Notes: null
  YearPainted_1: null
  Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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