Name: Rockford_Hydrant

Display Field: Rockford.DBO.Rockford_Hydrant.LocationDescription

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0a390f606647408ea62d9d20abce91a3

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: -9927035.996189017
YMin: 5184999.266349112
XMax: -9901282.03291158
YMax: 5211669.311226708
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Rockford.DBO.Rockford_Hydrant.Subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Distribution
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [189, 215, 252, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: Pump to Waste
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [193, 252, 179, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: Dead End
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 187, 179, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Subtype

Fields:

• Rockford.DBO.Rockford_Hydrant.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Rockford.DBO.Rockford_Hydrant.LocationDescription ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• Rockford.DBO.Rockford_Hydrant.HydrantID ( type: esriFieldTypeString, alias: HydrantID, length: 50 )
• Rockford.DBO.Rockford_Hydrant.ConstrJobNo ( type: esriFieldTypeString, alias: ConstrJobNo, length: 10 )
• Rockford.DBO.Rockford_Hydrant.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 20 , Coded Values: [AM: American] , [CL: Clow] , [CO: Corey] , ...25 more... )
• Rockford.DBO.Rockford_Hydrant.FIREDEPTNO ( type: esriFieldTypeString, alias: FireDeptNo, length: 50 )
• Rockford.DBO.Rockford_Hydrant.EPA ( type: esriFieldTypeString, alias: EPA, length: 25 )
• Rockford.DBO.Rockford_Hydrant.ModifiedBy ( type: esriFieldTypeString, alias: Modified By, length: 50 )
• Rockford.DBO.Rockford_Hydrant.ModifiedDate ( type: esriFieldTypeDate, alias: ModifiedDate, length: 8 )
• Rockford.DBO.Rockford_Hydrant.Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Rockford.DBO.Rockford_Hydrant.Ownership ( type: esriFieldTypeString, alias: Ownership, length: 20 , Coded Values: [Private: Private] , [Rockford: Rockford] , [LP: Loves Park] , ...9 more... )
• Rockford.DBO.Rockford_Hydrant.SharePointLink ( type: esriFieldTypeString, alias: SharePointLink, length: 255 )
• Rockford.DBO.Rockford_Hydrant.HydrantLock ( type: esriFieldTypeSmallInteger, alias: Hydrant Lock , Coded Values: [1: Yes] , [0: No] )
• Rockford.DBO.Rockford_Hydrant.Zone ( type: esriFieldTypeString, alias: Zone, length: 50 , Coded Values: [East High Zone: East High Zone] , [Central Zone: Central Zone] , [East Zone: East Zone] , ...1 more... )
• Rockford.DBO.Rockford_Hydrant.Status ( type: esriFieldTypeString, alias: Service Status, length: 50 , Coded Values: [IN: In Service] , [OUT: Out of Service] )
• Rockford.DBO.Rockford_Hydrant.StorzType ( type: esriFieldTypeSmallInteger, alias: Storz Type , Coded Values: [1: Adaptor] , [2: Integral] , [3: None] )
• Rockford.DBO.Rockford_Hydrant.StorzNozzle ( type: esriFieldTypeSmallInteger, alias: Storz Nozzle , Coded Values: [1: Yes] , [0: No] )
• Rockford.DBO.Rockford_Hydrant.BarrelDiameter ( type: esriFieldTypeDouble, alias: Barrel Diameter , Coded Values: [-1: Other] , [0: Unknown] , [0.5: 0.5 in.] , ...29 more... )
• Rockford.DBO.Rockford_Hydrant.UnitID ( type: esriFieldTypeString, alias: UnitID, length: 20 )
• Rockford.DBO.Rockford_Hydrant.CompType ( type: esriFieldTypeSmallInteger, alias: CompType )
• Rockford.DBO.Rockford_Hydrant.CompKey ( type: esriFieldTypeInteger, alias: CompKey )
• Rockford.DBO.Rockford_Hydrant.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• Rockford.DBO.Rockford_Hydrant.Documents ( type: esriFieldTypeString, alias: Documents, length: 50 )
• Rockford.DBO.Rockford_Hydrant.Photo ( type: esriFieldTypeString, alias: Photo, length: 200 )
• Rockford.DBO.Rockford_Hydrant.Smallway1 ( type: esriFieldTypeDouble, alias: Smallway1 , Coded Values: [-1: Other] , [0: Unknown] , [0.5: 0.5 in.] , ...29 more... )
• Rockford.DBO.Rockford_Hydrant.Smallway2 ( type: esriFieldTypeDouble, alias: Smallway2 , Coded Values: [-1: Other] , [0: Unknown] , [0.5: 0.5 in.] , ...29 more... )
• Rockford.DBO.Rockford_Hydrant.Bigway ( type: esriFieldTypeDouble, alias: Bigway , Coded Values: [-1: Other] , [0: Unknown] , [0.5: 0.5 in.] , ...29 more... )
• Rockford.DBO.Rockford_Hydrant.Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype , Coded Values: [1: Distribution] , [2: Pump to Waste] , [3: Dead End] )
• Rockford.DBO.Rockford_Hydrant.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• Rockford.DBO.Rockford_Hydrant.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Rockford.DBO.Rockford_Hydrant.SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Rockford.DBO.Rockford_Hydrant.MODEL_ID ( type: esriFieldTypeString, alias: MODEL ID, length: 10 )
• Rockford.DBO.Rockford_Hydrant.MODEL_NOTES ( type: esriFieldTypeString, alias: MODEL NOTES, length: 100 )
• Rockford.DBO.Rockford_Hydrant.ZONING ( type: esriFieldTypeString, alias: Zoning, length: 100 )
• Rockford.DBO.Rockford_Hydrant.REQUIRED_FIREFLOW ( type: esriFieldTypeSmallInteger, alias: Required Fire Flow )
• Rockford.DBO.Rockford_HydrantFlow.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• Rockford.DBO.Rockford_HydrantFlow.Fire_Department_Number ( type: esriFieldTypeString, alias: Fire_Department_Number, length: 15 )
• Rockford.DBO.Rockford_HydrantFlow.Reference_Hydrant ( type: esriFieldTypeString, alias: Reference_Hydrant, length: 15 )
• Rockford.DBO.Rockford_HydrantFlow.Year ( type: esriFieldTypeInteger, alias: Year )
• Rockford.DBO.Rockford_HydrantFlow.Date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• Rockford.DBO.Rockford_HydrantFlow.Start_Time ( type: esriFieldTypeString, alias: Start_Time, length: 25 )
• Rockford.DBO.Rockford_HydrantFlow.End_Time ( type: esriFieldTypeString, alias: End_Time, length: 25 )
• Rockford.DBO.Rockford_HydrantFlow.Flushing_Hours ( type: esriFieldTypeDouble, alias: Flushing_Hours )
• Rockford.DBO.Rockford_HydrantFlow.Flushing_Minutes ( type: esriFieldTypeInteger, alias: Flushing_Minutes )
• Rockford.DBO.Rockford_HydrantFlow.Static ( type: esriFieldTypeDouble, alias: Static )
• Rockford.DBO.Rockford_HydrantFlow.Residual ( type: esriFieldTypeDouble, alias: Residual )
• Rockford.DBO.Rockford_HydrantFlow.Pitot_Pressure ( type: esriFieldTypeDouble, alias: Pitot_Pressure )
• Rockford.DBO.Rockford_HydrantFlow.Pitot_Pressure_2 ( type: esriFieldTypeDouble, alias: Pitot_Pressure_2 )
• Rockford.DBO.Rockford_HydrantFlow.Discharge_Coefficient ( type: esriFieldTypeDouble, alias: Discharge_Coefficient )
• Rockford.DBO.Rockford_HydrantFlow.Outlet_Diameter ( type: esriFieldTypeDouble, alias: Outlet_Diameter )
• Rockford.DBO.Rockford_HydrantFlow.Hydrant_Flow ( type: esriFieldTypeDouble, alias: Hydrant_Flow )
• Rockford.DBO.Rockford_HydrantFlow.Flow_at_20_PSI ( type: esriFieldTypeDouble, alias: Flow_at_20_PSI )
• Rockford.DBO.Rockford_HydrantFlow.Flow_at_10_PSI ( type: esriFieldTypeDouble, alias: Flow_at_10_PSI )
• Rockford.DBO.Rockford_HydrantFlow.Flow_at_0_PSI ( type: esriFieldTypeDouble, alias: Flow_at_0_PSI )
• Rockford.DBO.Rockford_HydrantFlow.Flow_Test ( type: esriFieldTypeSmallInteger, alias: Flow_Test )
• Rockford.DBO.Rockford_HydrantFlow.Model ( type: esriFieldTypeString, alias: Model, length: 25 )
• Rockford.DBO.Rockford_HydrantFlow.Make ( type: esriFieldTypeString, alias: Make, length: 25 )
• Rockford.DBO.Rockford_HydrantFlow.Flushed ( type: esriFieldTypeSmallInteger, alias: Flushed )
• Rockford.DBO.Rockford_HydrantFlow.Serviced ( type: esriFieldTypeSmallInteger, alias: Serviced )
• Rockford.DBO.Rockford_HydrantFlow.Painted ( type: esriFieldTypeSmallInteger, alias: Painted )
• Rockford.DBO.Rockford_HydrantFlow.Inspected ( type: esriFieldTypeSmallInteger, alias: Inspected )
• Rockford.DBO.Rockford_HydrantFlow.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )

Types:

ID: 1
Name: Distribution
Domains:
• Rockford.DBO.Rockford_Hydrant.Manufacturer:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Ownership:
  Inherited
• Rockford.DBO.Rockford_Hydrant.HydrantLock:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Zone:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Status:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzType:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzNozzle:
  Inherited
• Rockford.DBO.Rockford_Hydrant.BarrelDiameter:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway1:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway2:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Bigway:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Enabled:
  Inherited

---

ID: 2
Name: Pump to Waste
Domains:
• Rockford.DBO.Rockford_Hydrant.Manufacturer:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Ownership:
  Inherited
• Rockford.DBO.Rockford_Hydrant.HydrantLock:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Zone:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Status:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzType:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzNozzle:
  Inherited
• Rockford.DBO.Rockford_Hydrant.BarrelDiameter:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway1:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway2:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Bigway:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Enabled:
  Inherited

---

ID: 3
Name: Dead End
Domains:
• Rockford.DBO.Rockford_Hydrant.Manufacturer:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Ownership:
  Inherited
• Rockford.DBO.Rockford_Hydrant.HydrantLock:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Zone:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Status:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzType:
  Inherited
• Rockford.DBO.Rockford_Hydrant.StorzNozzle:
  Inherited
• Rockford.DBO.Rockford_Hydrant.BarrelDiameter:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway1:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Smallway2:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Bigway:
  Inherited
• Rockford.DBO.Rockford_Hydrant.Enabled:
  Inherited

---

Relationships:

• Rockford_HydrantFlow (0) -- Related To: Rockford_HydrantFlow (24)

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

  Iteminfo   Thumbnail   Metadata