Name: Fire Hydrants Out of Service

Display Field: FHNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000.0

Max Scale: 0.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: -1.078767784168708E7
YMin: 5900442.209794915
XMax: -1.0771386372177038E7
YMax: 5936976.552801367
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ProjectNumber ( type: esriFieldTypeString, alias: ProjectNumber, length: 16 )
• FHNumber ( type: esriFieldTypeString, alias: FHNumber, length: 16 )
• Elevation ( type: esriFieldTypeString, alias: Elevation(TOB), length: 16 )
• Datum ( type: esriFieldTypeString, alias: Datum, length: 50 , Coded Values: [1988: U.S.G.S. Vertical Datum of 1988] , [Fargo: City of Fargo Datum] , [1927: U.S.G.S. Vertical Datum of 1927] )
• Manufacturer ( type: esriFieldTypeString, alias: MFG, length: 50 , Coded Values: [American Darling: American Darling] , [Pacer: Pacer] , [5" Waterous: 5" Waterous] , ...4 more... )
• Diameter ( type: esriFieldTypeString, alias: Diameter, length: 25 )
• Unit ( type: esriFieldTypeString, alias: Unit, length: 50 , Coded Values: [801: 801] , [802: 802] , [803: 803] , ...8 more... )
• Shift ( type: esriFieldTypeString, alias: Shift, length: 50 , Coded Values: [A: A] , [B: B] , [C: C] , ...1 more... )
• Type ( type: esriFieldTypeString, alias: Type, length: 25 , Coded Values: [Red: Red] , [Yellow: Yellow] , [Private: Private] )
• Occupant ( type: esriFieldTypeString, alias: Occupant, length: 255 )
• HydrantLocation ( type: esriFieldTypeString, alias: HydrantLocation, length: 255 )
• PrivateHydrant ( type: esriFieldTypeString, alias: PrivateHydrant, length: 50 , Coded Values: [Y: Yes] , [YPF: Yes Permission Notify First] , [YPC: Yes Permission Owner Will Flush] , ...2 more... )
• OutOfService ( type: esriFieldTypeSmallInteger, alias: OutOfService , Coded Values: [1: Yes] , [0: No] )
• DateFlushed ( type: esriFieldTypeDate, alias: DateFlushed, length: 8 )
• MarkerMissing ( type: esriFieldTypeSmallInteger, alias: MarkerMissing , Coded Values: [0: No] , [1: Yes] , [2: NA] )
• CapsMissing ( type: esriFieldTypeSmallInteger, alias: CapsMissing , Coded Values: [1: Yes] , [0: No] )
• IDTagMissing ( type: esriFieldTypeSmallInteger, alias: IDTagMissing , Coded Values: [1: Yes] , [0: No] )
• Leaks ( type: esriFieldTypeSmallInteger, alias: Leaks , Coded Values: [1: Yes] , [0: No] )
• DrainOK ( type: esriFieldTypeSmallInteger, alias: DrainOK , Coded Values: [1: Yes] , [0: No] )
• Pumped ( type: esriFieldTypeSmallInteger, alias: Pumped , Coded Values: [1: Yes] , [0: No] )
• HydrantGuardAdded ( type: esriFieldTypeSmallInteger, alias: HydrantGuardAdded , Coded Values: [1: Yes] , [0: No] )
• FireRemarks ( type: esriFieldTypeString, alias: FireRemarks, length: 255 )
• LAYER ( type: esriFieldTypeString, alias: Layer, length: 254 )
• CADTYPE ( type: esriFieldTypeString, alias: CADTYPE, length: 25 )
• REFNAME ( type: esriFieldTypeString, alias: REFNAME, length: 25 )
• ID ( type: esriFieldTypeString, alias: ID, length: 16 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• JOINFIELD ( type: esriFieldTypeInteger, alias: JOINFIELD )
• SYMBOL_ROTATION ( type: esriFieldTypeDouble, alias: SYMBOL_ROTATION )
• WaterJurisdiction ( type: esriFieldTypeString, alias: WaterJurisdiction, length: 50 )
• ConsequenceOfFailure ( type: esriFieldTypeDouble, alias: ConsequenceOfFailure )
• ProbabilityOfFailure ( type: esriFieldTypeDouble, alias: ProbabilityOfFailure )
• Mitigation ( type: esriFieldTypeDouble, alias: Mitigation )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• EstimatedLife ( type: esriFieldTypeSmallInteger, alias: EstimatedLife )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• Material ( type: esriFieldTypeString, alias: Material, length: 100 )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• CostingDate ( type: esriFieldTypeDate, alias: CostingDate, length: 8 )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, length: 20 )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Planned: Planned] , [Active: Active] , [Abandoned: Abandoned] , ...3 more... )
• ProjectRetired ( type: esriFieldTypeString, alias: ProjectRetired, length: 50 )
• YearRetired ( type: esriFieldTypeString, alias: YearRetired, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, length: 25 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• PrivateOwnerInformation ( type: esriFieldTypeString, alias: PrivateOwnerInformation, length: 100 )
• Coefficient ( type: esriFieldTypeDouble, alias: Coefficient )
• NeedsRepair ( type: esriFieldTypeSmallInteger, alias: NeedsRepair , Coded Values: [1: Yes] , [0: No] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• StaticPSI ( type: esriFieldTypeString, alias: Static PSI, length: 50 )
• ResidualPSI ( type: esriFieldTypeString, alias: Residual PSI, length: 50 )
• TotalFlow ( type: esriFieldTypeString, alias: Total Flow, length: 50 )
• DateOfFlowTest ( type: esriFieldTypeDate, alias: Date of Flow Test, length: 8 )
• FlowTestBy ( type: esriFieldTypeString, alias: Flow Test By, length: 100 )
• FlowTestWitnessedBy ( type: esriFieldTypeString, alias: Flow Test Witnessed By, length: 100 )
• LastChecked ( type: esriFieldTypeDate, alias: Last Checked, length: 8 )
• LastPumped ( type: esriFieldTypeDate, alias: Last Pumped, length: 8 )
• Winterized ( type: esriFieldTypeDate, alias: Winterized, length: 8 )
• FrozenHydrant ( type: esriFieldTypeString, alias: FrozenHydrant, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy, length: 255 )
• DatePainted ( type: esriFieldTypeDate, alias: DatePainted, length: 8 )
• PrepHydrant ( type: esriFieldTypeSmallInteger, alias: PrepHydrant , Coded Values: [1: Yes] , [0: No] )

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

  Iteminfo   Thumbnail   Metadata