Layers:

Layer: wHydrant (0)

Name: wHydrant

Display Field: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2500

Supported Query Formats: JSON, geoJSON

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: 1455309.5980499983
YMin: 726082.1505499929
XMax: 1500641.5835749954
YMax: 763196.8640999943
Spatial Reference: 102723  (3735)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label:
Description:
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:
• AssetManagement.GIS_OWNER.wHydrant.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetManagement.GIS_OWNER.wHydrant.AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• AssetManagement.GIS_OWNER.wHydrant.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• AssetManagement.GIS_OWNER.wHydrant.AdministrativeArea ( type: esriFieldTypeString, alias: AdministrativeArea, length: 20 , Coded Values: [Unknown: Unknown] , [Other: Other] , [City of Troy: City of Troy] , ...3 more... )
• AssetManagement.GIS_OWNER.wHydrant.FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• AssetManagement.GIS_OWNER.wHydrant.LocationDescription ( type: esriFieldTypeString, alias: LocationDescription, length: 200 )
• AssetManagement.GIS_OWNER.wHydrant.OperationalArea ( type: esriFieldTypeString, alias: OperationalArea, length: 20 , Coded Values: [Unk: Unknown] , [Oth: Other] , [LS: Low Service] , ...2 more... )
• AssetManagement.GIS_OWNER.wHydrant.Rotation ( type: esriFieldTypeDouble, alias: Rotation )
• AssetManagement.GIS_OWNER.wHydrant.LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, length: 20 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...2 more... )
• AssetManagement.GIS_OWNER.wHydrant.Subtype ( type: esriFieldTypeInteger, alias: Subtype )
• AssetManagement.GIS_OWNER.wHydrant.WorkorderID ( type: esriFieldTypeString, alias: WorkorderID, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.Elevation ( type: esriFieldTypeDouble, alias: Elevation )
• AssetManagement.GIS_OWNER.wHydrant.WaterType ( type: esriFieldTypeString, alias: WaterType, length: 255 , Coded Values: [Treated: Treated Water] , [Potable: Potable Water] , [Raw: Raw Water] )
• AssetManagement.GIS_OWNER.wHydrant.BarrelDiameter ( type: esriFieldTypeDouble, alias: BarrelDiameter , Coded Values: [2.5: 2.5 Inch] , [4: 4 Inch] , [5.5: 5.5 Inch] , ...1 more... )
• AssetManagement.GIS_OWNER.wHydrant.MainValveType ( type: esriFieldTypeString, alias: MainValveType, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter1 ( type: esriFieldTypeDouble, alias: NozzleDiameter1 , Coded Values: [2.5: 2.5 Inch] , [4: 4 Inch] , [5.5: 5.5 Inch] , ...1 more... )
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter2 ( type: esriFieldTypeDouble, alias: NozzleDiameter2 , Coded Values: [2.5: 2.5 Inch] , [4: 4 Inch] , [5.5: 5.5 Inch] , ...1 more... )
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter3 ( type: esriFieldTypeDouble, alias: NozzleDiameter3 , Coded Values: [2.5: 2.5 Inch] , [4: 4 Inch] , [5.5: 5.5 Inch] , ...1 more... )
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter4 ( type: esriFieldTypeDouble, alias: NozzleDiameter4 , Coded Values: [2.5: 2.5 Inch] , [4: 4 Inch] , [5.5: 5.5 Inch] , ...1 more... )
• AssetManagement.GIS_OWNER.wHydrant.OutletConfiguration ( type: esriFieldTypeString, alias: OutletConfiguration, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.SeatDiameter ( type: esriFieldTypeInteger, alias: SeatDiameter , Range: [0, 72] )
• AssetManagement.GIS_OWNER.wHydrant.GPS ( type: esriFieldTypeString, alias: GPS, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• AssetManagement.GIS_OWNER.wHydrant.TroyHydrants ( type: esriFieldTypeInteger, alias: TroyHydrants )
• AssetManagement.GIS_OWNER.wHydrant.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• AssetManagement.GIS_OWNER.wHydrant.LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 30 )
• AssetManagement.GIS_OWNER.wHydrant.WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• AssetManagement.GIS_OWNER.wHydrant.Location ( type: esriFieldTypeString, alias: Location, length: 50 )
• AssetManagement.GIS_OWNER.wHydrant.Hydrant_NUM ( type: esriFieldTypeString, alias: Hydrant_NUM, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.Valve_NUM ( type: esriFieldTypeString, alias: Valve_NUM, length: 20 )
• AssetManagement.GIS_OWNER.wHydrant.Hydrant_Location ( type: esriFieldTypeString, alias: Hydrant_Location, length: 100 )
• AssetManagement.GIS_OWNER.wHydrant.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• AssetManagement.GIS_OWNER.wHydrant.Year ( type: esriFieldTypeSmallInteger, alias: Year )
• AssetManagement.GIS_OWNER.wHydrant.created_user ( type: esriFieldTypeString, alias: AssetManagement.GIS_OWNER.wHydrant.created_user, length: 255 )
• AssetManagement.GIS_OWNER.wHydrant.created_date ( type: esriFieldTypeDate, alias: AssetManagement.GIS_OWNER.wHydrant.created_date, length: 8 )
• AssetManagement.GIS_OWNER.wHydrant.last_edited_user ( type: esriFieldTypeString, alias: AssetManagement.GIS_OWNER.wHydrant.last_edited_user, length: 255 )
• AssetManagement.GIS_OWNER.wHydrant.last_edited_date ( type: esriFieldTypeDate, alias: AssetManagement.GIS_OWNER.wHydrant.last_edited_date, length: 8 )
• AssetManagement.GIS_OWNER.wHydrant.Static ( type: esriFieldTypeSmallInteger, alias: Static (in psi) )
• AssetManagement.GIS_OWNER.wHydrant.Residual ( type: esriFieldTypeSmallInteger, alias: Residual (in psi) )
• AssetManagement.GIS_OWNER.wHydrant.Pitot ( type: esriFieldTypeSmallInteger, alias: Pitot (gauge reading) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.TroyHydrantNumber ( type: esriFieldTypeInteger, alias: TroyHydrantNumber )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.HouseNum ( type: esriFieldTypeSmallInteger, alias: HouseNum )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.StreetName ( type: esriFieldTypeString, alias: StreetName, length: 50 , Coded Values: [1st: 1st St] , [2nd: 2nd St] , [3rd: 3rd St] , ...610 more... )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.InspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Operable ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [1: Yes] , [2: No] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Mueller Company: Mueller Company] , ...2 more... )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Static ( type: esriFieldTypeSmallInteger, alias: Static (in psi) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Residual ( type: esriFieldTypeSmallInteger, alias: Residual (in psi) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Pitot ( type: esriFieldTypeSmallInteger, alias: Pitot (gauge reading) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Diameter ( type: esriFieldTypeDouble, alias: Diameter (in inches) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.HydGPM ( type: esriFieldTypeDouble, alias: HydGPM (calculated) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.HydGPM_20 ( type: esriFieldTypeDouble, alias: HydGPM_20 (calculated) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.HydGPM_10 ( type: esriFieldTypeDouble, alias: HydGPM_10 (calculated) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.HydGPM_0 ( type: esriFieldTypeDouble, alias: HydGPM_0 (calculated) )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Capacity_Class ( type: esriFieldTypeString, alias: Capacity_Class, length: 25 , Coded Values: [CLASS AA: CLASS AA] , [CLASS A: CLASS A] , [CLASS B: CLASS B] , ...1 more... )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.OperatesHard ( type: esriFieldTypeSmallInteger, alias: Operates Hard? , Coded Values: [1: Yes] , [2: No] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Zerk ( type: esriFieldTypeString, alias: Zerk, length: 25 , Coded Values: [New: New] , [Ok: Ok] , [Needs Replaced: Needs Replaced] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Housing ( type: esriFieldTypeString, alias: Housing, length: 25 , Coded Values: [Ok: Ok] , [Loose: Loose] , [Damaged: Damaged] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Cap ( type: esriFieldTypeString, alias: Cap, length: 25 , Coded Values: [Tight: Tight] , [Ok: Ok] , [Loose: Loose] , ...1 more... )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Greased ( type: esriFieldTypeSmallInteger, alias: Hydrant Greased? , Coded Values: [1: Yes] , [2: No] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Paint ( type: esriFieldTypeSmallInteger, alias: Needs Paint? , Coded Values: [1: Yes] , [2: No] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.OverallCondition ( type: esriFieldTypeString, alias: OverallCondition, length: 25 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Status ( type: esriFieldTypeString, alias: Hydrant Status, length: 25 , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.YearPainted ( type: esriFieldTypeSmallInteger, alias: YearPainted )
• AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
Types:
ID: 1
Name: Fire Hydrant
Domains:
• AssetManagement.GIS_OWNER.wHydrant.AncillaryRole:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.Enabled:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.AdministrativeArea:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.OperationalArea:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.LifecycleStatus:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.WaterType:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.BarrelDiameter:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter1:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter2:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter3:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter4:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.SeatDiameter:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.GPS:
  Inherited

---

ID: 2
Name: Yard Hydrant
Domains:
• AssetManagement.GIS_OWNER.wHydrant.AncillaryRole:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.Enabled:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.AdministrativeArea:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.OperationalArea:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.LifecycleStatus:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.WaterType:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.BarrelDiameter:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter1:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter2:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter3:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.NozzleDiameter4:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.SeatDiameter:
  Inherited
• AssetManagement.GIS_OWNER.wHydrant.GPS:
  Inherited

---

Relationships:

• TroyHydrantInspections2019 (0) -- Related To: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository (1)
• TroyHydrantInspections_Repo (1) -- Related To: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository (1)

Tables:

Table: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository (1)

Name: AssetManagement.GIS_OWNER.TroyHydrantInspections_Repository

Display Field: StreetName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2500

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• TroyHydrantNumber ( type: esriFieldTypeInteger, alias: TroyHydrantNumber )
• HouseNum ( type: esriFieldTypeSmallInteger, alias: HouseNum )
• StreetName ( type: esriFieldTypeString, alias: StreetName, length: 50 , Coded Values: [1st: 1st St] , [2nd: 2nd St] , [3rd: 3rd St] , ...610 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: Date of Inspection, length: 8 )
• Operable ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [1: Yes] , [2: No] )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 25 , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Mueller Company: Mueller Company] , ...2 more... )
• Static ( type: esriFieldTypeSmallInteger, alias: Static (in psi) )
• Residual ( type: esriFieldTypeSmallInteger, alias: Residual (in psi) )
• Pitot ( type: esriFieldTypeSmallInteger, alias: Pitot (gauge reading) )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter (in inches) )
• HydGPM ( type: esriFieldTypeDouble, alias: HydGPM (calculated) )
• HydGPM_20 ( type: esriFieldTypeDouble, alias: HydGPM_20 (calculated) )
• HydGPM_10 ( type: esriFieldTypeDouble, alias: HydGPM_10 (calculated) )
• HydGPM_0 ( type: esriFieldTypeDouble, alias: HydGPM_0 (calculated) )
• Capacity_Class ( type: esriFieldTypeString, alias: Capacity_Class, length: 25 , Coded Values: [CLASS AA: CLASS AA] , [CLASS A: CLASS A] , [CLASS B: CLASS B] , ...1 more... )
• OperatesHard ( type: esriFieldTypeSmallInteger, alias: Operates Hard? , Coded Values: [1: Yes] , [2: No] )
• Zerk ( type: esriFieldTypeString, alias: Zerk, length: 25 , Coded Values: [New: New] , [Ok: Ok] , [Needs Replaced: Needs Replaced] )
• Housing ( type: esriFieldTypeString, alias: Housing, length: 25 , Coded Values: [Ok: Ok] , [Loose: Loose] , [Damaged: Damaged] )
• Cap ( type: esriFieldTypeString, alias: Cap, length: 25 , Coded Values: [Tight: Tight] , [Ok: Ok] , [Loose: Loose] , ...1 more... )
• Greased ( type: esriFieldTypeSmallInteger, alias: Hydrant Greased? , Coded Values: [1: Yes] , [2: No] )
• Paint ( type: esriFieldTypeSmallInteger, alias: Needs Paint? , Coded Values: [1: Yes] , [2: No] )
• OverallCondition ( type: esriFieldTypeString, alias: OverallCondition, length: 25 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• Status ( type: esriFieldTypeString, alias: Hydrant Status, length: 25 , Coded Values: [Complete: Complete] , [Incomplete: Incomplete] )
• Notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• YearPainted ( type: esriFieldTypeSmallInteger, alias: YearPainted )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• wHydrant (0) -- Related To: wHydrant (0)
• wHydrant (1) -- Related To: wHydrant (0)