Name: Fire Hydrant

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b6f0580f5bc5478487450e9b6b2d6c2e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 1639277.9093034714
YMin: 670107.6627807319
XMax: 1671589.0973056406
YMax: 696257.4087094814
Spatial Reference: 103129  (6549)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ownedby
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Perrysburg
  Description: Perrysburg
  Symbol:
  
• Value: 2
  Label: Private
  Description: Private
  Symbol:
  
• Value: 3
  Label: NWWSD
  Description: NWWSD
  Symbol:
  
• Value: 100
  Label: Other
  Description: Other
  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: 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: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: Object ID )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 64 )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset Type , Coded Values: [0: Unknown] , [321: Fire Hydrant] )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Unknown] , [4: 4"] , [4.5: 4 1/2"] , ...4 more... )
• secondarydiameter ( type: esriFieldTypeDouble, alias: Nozzle Diameter , Coded Values: [0: Unknown] , [2.5: 2 1/2"] , [4.5: 4 1/2"] , ...4 more... )
• manufacturer ( type: esriFieldTypeSmallInteger, alias: Manufacturer , Coded Values: [0: Unknown] , [60: American Darling] , [61: Clow Corporation] , ...12 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8, precision: 1 )
• status ( type: esriFieldTypeSmallInteger, alias: Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more... )
• hroute ( type: esriFieldTypeString, alias: Hydrant Route, length: 255 )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, length: 8, precision: 1 )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, length: 8, precision: 1 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• lastmaint ( type: esriFieldTypeDate, alias: Last Maintenance, length: 8, precision: 1 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [2: Private] , [100: Other] , [1: Perrysburg] , ...1 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [2: Private] , [100: Other] , [1: Perrysburg] , ...1 more... )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• mark_deletion ( type: esriFieldTypeSmallInteger, alias: Mark for Deletion , Coded Values: [1: Yes] , [2: No] )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation , Range: [0, 359] )
• created_user ( type: esriFieldTypeString, alias: Creator, length: 255 )
• last_edited_user ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• esrignss_positionsourcetype ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• esrignss_receiver ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• esrignss_latitude ( type: esriFieldTypeDouble, alias: Latitude )
• esrignss_longitude ( type: esriFieldTypeDouble, alias: Longitude )
• esrignss_altitude ( type: esriFieldTypeDouble, alias: Altitude )
• esrignss_h_rms ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• esrignss_v_rms ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• esrignss_fixdatetime ( type: esriFieldTypeDate, alias: Fix Time, length: 8, precision: 1 )
• esrignss_fixtype ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• esrignss_correctionage ( type: esriFieldTypeDouble, alias: Correction Age )
• esrignss_stationid ( type: esriFieldTypeSmallInteger, alias: Station ID , Range: [0, 1023] )
• esrignss_numsats ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• esrignss_pdop ( type: esriFieldTypeDouble, alias: PDOP )
• esrignss_hdop ( type: esriFieldTypeDouble, alias: HDOP )
• esrignss_vdop ( type: esriFieldTypeDouble, alias: VDOP )
• esrignss_direction ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• esrignss_speed ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• esrisnsr_azimuth ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• esrignss_avg_h_rms ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• esrignss_avg_v_rms ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• esrignss_avg_positions ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• esrignss_h_stddev ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• color ( type: esriFieldTypeSmallInteger, alias: Color )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• year_manu ( type: esriFieldTypeInteger, alias: Year Manufacture )
• model_num ( type: esriFieldTypeString, alias: Model Number, length: 256 , Coded Values: [K81: K81] , [K81-A: K81-A] , [K81-D: K81-D] , ...12 more... )
• color_base ( type: esriFieldTypeString, alias: Color Base, length: 24 , Coded Values: [Red: Red] , [Yellow: Yellow] , [Green: Green] , ...4 more... )
• steamer_fit ( type: esriFieldTypeString, alias: Steamer Fitting, length: 20 , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• steamer_fit_size ( type: esriFieldTypeString, alias: Steamer Fitting Size, length: 20 )
• hose_outlets ( type: esriFieldTypeString, alias: Hose Outlets, length: 20 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...3 more... )
• address ( type: esriFieldTypeString, alias: Address, length: 60 )
• location ( type: esriFieldTypeString, alias: Location, length: 20 , Coded Values: [Yard: Yard] , [Cal-de-Sac: Cal-de-Sac] , [Other: Other (please fill in)] )
• loc_other ( type: esriFieldTypeString, alias: loc_other, length: 32 )
• repair ( type: esriFieldTypeString, alias: Repair, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• condition ( type: esriFieldTypeString, alias: Condition, length: 20 , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] )
• storz ( type: esriFieldTypeString, alias: Storz, length: 50 , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• barrel_size ( type: esriFieldTypeString, alias: Barrel Size, length: 20 , Coded Values: [4: 4"] , [4 1/2: 4 1/2"] , [5: 5"] , ...4 more... )
• verified ( type: esriFieldTypeDate, alias: Verified, length: 8, precision: 1 )
• leg_id ( type: esriFieldTypeString, alias: Legacy ID, length: 64 )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_inspected_date ( type: esriFieldTypeDateOnly, alias: last_inspected_date )
• nearest_address ( type: esriFieldTypeString, alias: Nearest Address, length: 255 )

Relationships:

• water.postgres.Hydrant_Maintenance_Inspection (15) -- Related To: Hydrant_Maintenance_Inspection (37)
• water.postgres.Hydrant_Flushing_Inspection (16) -- Related To: Hydrant Flushing Inspection (35)

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

  Iteminfo   Thumbnail   Metadata