Layers:

Layer: CRR Fire Hydrants (0)

Name: CRR Fire Hydrants

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: e3a23a35a39b44b1b1dd1baf50c99bdb

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

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

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: false
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: true
Supports Query With LOD Spatial Reference: true
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: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ownedby

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

---

ID: 2
Name: Private
Domains:
• repair:
  Inherited
• mark_deletion:
  Inherited
• steamer_fit:
  Inherited
• spatialsource:
  Inherited
• esrignss_stationid:
  Inherited
• barrel_size:
  Inherited
• manufacturer:
  Inherited
• hose_outlets:
  Inherited
• esrignss_numsats:
  Inherited
• condition:
  Inherited
• diameter:
  Inherited
• spatialconfidence:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• symbolrotation:
  Inherited
• maintby:
  Inherited
• location:
  Inherited
• color_base:
  Inherited
• storz:
  Inherited
• ownedby:
  Inherited
• model_num:
  Inherited
• assettype:
  Inherited
• secondarydiameter:
  Inherited
• esrignss_fixtype:
  Inherited
• status:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  esrignss_avg_h_rms: null
  installdate: null
  notes: null
  esrignss_hdop: null
  spatialsource: null
  esrignss_pdop: null
  hose_outlets: null
  esrisnsr_azimuth: null
  hroute: null
  diameter: null
  symbolrotation: null
  esrignss_fixdatetime: null
  ownedby: 2
  esrignss_fixtype: null
  esrignss_h_stddev: null
  created_user: null
  esrignss_avg_positions: null
  esrignss_stationid: null
  loc_other: null
  esrignss_v_rms: null
  esrignss_direction: null
  condition: null
  spatialconfidence: null
  inservicedate: null
  lastmaint: null
  status: 8
  repair: null
  color: null
  esrignss_speed: null
  esrignss_avg_v_rms: null
  barrel_size: null
  manufacturer: null
  esrignss_longitude: null
  esrignss_latitude: null
  esrignss_receiver: null
  esrignss_altitude: null
  esrignss_positionsourcetype: null
  esrignss_vdop: null
  last_edited_date: null
  model_num: null
  assettype: 321
  secondarydiameter: null
  address: null
  mark_deletion: 2
  leg_id: null
  steamer_fit: null
  verified: null
  steamer_fit_size: null
  retireddate: null
  esrignss_correctionage: null
  last_edited_user: null
  esrignss_numsats: null
  assetid: null
  maintby: 1
  location: null
  created_date: null
  color_base: null
  year_manu: null
  storz: null
  esrignss_h_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: NWWSD
Domains:
• repair:
  Inherited
• mark_deletion:
  Inherited
• steamer_fit:
  Inherited
• spatialsource:
  Inherited
• esrignss_stationid:
  Inherited
• barrel_size:
  Inherited
• manufacturer:
  Inherited
• hose_outlets:
  Inherited
• esrignss_numsats:
  Inherited
• condition:
  Inherited
• diameter:
  Inherited
• spatialconfidence:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• symbolrotation:
  Inherited
• maintby:
  Inherited
• location:
  Inherited
• color_base:
  Inherited
• storz:
  Inherited
• ownedby:
  Inherited
• model_num:
  Inherited
• assettype:
  Inherited
• secondarydiameter:
  Inherited
• esrignss_fixtype:
  Inherited
• status:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  esrignss_avg_h_rms: null
  installdate: null
  notes: null
  esrignss_hdop: null
  spatialsource: null
  esrignss_pdop: null
  hose_outlets: null
  esrisnsr_azimuth: null
  hroute: null
  diameter: null
  symbolrotation: null
  esrignss_fixdatetime: null
  ownedby: 3
  esrignss_fixtype: null
  esrignss_h_stddev: null
  created_user: null
  esrignss_avg_positions: null
  esrignss_stationid: null
  loc_other: null
  esrignss_v_rms: null
  esrignss_direction: null
  condition: null
  spatialconfidence: null
  inservicedate: null
  lastmaint: null
  status: 8
  repair: null
  color: null
  esrignss_speed: null
  esrignss_avg_v_rms: null
  barrel_size: null
  manufacturer: null
  esrignss_longitude: null
  esrignss_latitude: null
  esrignss_receiver: null
  esrignss_altitude: null
  esrignss_positionsourcetype: null
  esrignss_vdop: null
  last_edited_date: null
  model_num: null
  assettype: 321
  secondarydiameter: null
  address: null
  mark_deletion: 2
  leg_id: null
  steamer_fit: null
  verified: null
  steamer_fit_size: null
  retireddate: null
  esrignss_correctionage: null
  last_edited_user: null
  esrignss_numsats: null
  assetid: null
  maintby: 1
  location: null
  created_date: null
  color_base: null
  year_manu: null
  storz: null
  esrignss_h_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 100
Name: Other
Domains:
• repair:
  Inherited
• mark_deletion:
  Inherited
• steamer_fit:
  Inherited
• spatialsource:
  Inherited
• esrignss_stationid:
  Inherited
• barrel_size:
  Inherited
• manufacturer:
  Inherited
• hose_outlets:
  Inherited
• esrignss_numsats:
  Inherited
• condition:
  Inherited
• diameter:
  Inherited
• spatialconfidence:
  Inherited
• esrignss_positionsourcetype:
  Inherited
• symbolrotation:
  Inherited
• maintby:
  Inherited
• location:
  Inherited
• color_base:
  Inherited
• storz:
  Inherited
• ownedby:
  Inherited
• model_num:
  Inherited
• assettype:
  Inherited
• secondarydiameter:
  Inherited
• esrignss_fixtype:
  Inherited
• status:
  Inherited
Templates:
• Name: 100
  Description:
  Prototype:
  esrignss_avg_h_rms: null
  installdate: null
  notes: null
  esrignss_hdop: null
  spatialsource: null
  esrignss_pdop: null
  hose_outlets: null
  esrisnsr_azimuth: null
  hroute: null
  diameter: null
  symbolrotation: null
  esrignss_fixdatetime: null
  ownedby: 100
  esrignss_fixtype: null
  esrignss_h_stddev: null
  created_user: null
  esrignss_avg_positions: null
  esrignss_stationid: null
  loc_other: null
  esrignss_v_rms: null
  esrignss_direction: null
  condition: null
  spatialconfidence: null
  inservicedate: null
  lastmaint: null
  status: 8
  repair: null
  color: null
  esrignss_speed: null
  esrignss_avg_v_rms: null
  barrel_size: null
  manufacturer: null
  esrignss_longitude: null
  esrignss_latitude: null
  esrignss_receiver: null
  esrignss_altitude: null
  esrignss_positionsourcetype: null
  esrignss_vdop: null
  last_edited_date: null
  model_num: null
  assettype: 321
  secondarydiameter: null
  address: null
  mark_deletion: 2
  leg_id: null
  steamer_fit: null
  verified: null
  steamer_fit_size: null
  retireddate: null
  esrignss_correctionage: null
  last_edited_user: null
  esrignss_numsats: null
  assetid: null
  maintby: 1
  location: null
  created_date: null
  color_base: null
  year_manu: null
  storz: null
  esrignss_h_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

---