View In:
ArcGIS Online Map Viewer
Name: Fire Hydrant
Display Field: assetid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: 682cc88ce3e2449194fdbaf51210e982
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
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:
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: true
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: 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
(
type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, defaultValue: null, modelName: objectid
)
-
assetid
(
type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: assetid
)
-
assettype
(
type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, nullable: false, defaultValue: 321, modelName: assettype
, Coded Values:
[0: Unknown]
, [321: Fire Hydrant]
)
-
diameter
(
type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter
, Coded Values:
[0: Unknown]
, [4: 4"]
, [4.5: 4 1/2"]
, ...4 more...
)
-
secondarydiameter
(
type: esriFieldTypeDouble, alias: Nozzle Diameter, editable: true, nullable: true, defaultValue: null, modelName: secondarydiameter
, Coded Values:
[0: Unknown]
, [2.5: 2 1/2"]
, [4.5: 4 1/2"]
, ...4 more...
)
-
manufacturer
(
type: esriFieldTypeSmallInteger, alias: Manufacturer, editable: true, nullable: true, defaultValue: null, modelName: manufacturer
, Coded Values:
[0: Unknown]
, [60: American Darling]
, [61: Clow Corporation]
, ...12 more...
)
-
installdate
(
type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: installdate
)
-
status
(
type: esriFieldTypeSmallInteger, alias: Status, editable: true, nullable: false, defaultValue: 8, modelName: status
, Coded Values:
[0: Unknown]
, [1: Proposed]
, [2: Approved]
, ...7 more...
)
-
hroute
(
type: esriFieldTypeString, alias: Hydrant Route, editable: true, nullable: true, length: 255, defaultValue: null, modelName: hroute
)
-
inservicedate
(
type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: inservicedate
)
-
retireddate
(
type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: retireddate
)
-
notes
(
type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes
)
-
lastmaint
(
type: esriFieldTypeDate, alias: Last Maintenance, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: lastmaint
)
-
ownedby
(
type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby
, Coded Values:
[2: Private]
, [100: Other]
, [1: Perrysburg]
, ...1 more...
)
-
maintby
(
type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby
, Coded Values:
[2: Private]
, [100: Other]
, [1: Perrysburg]
, ...1 more...
)
-
spatialsource
(
type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource
, Coded Values:
[0: Unknown]
, [1: As-Built]
, [2: CAD]
, ...3 more...
)
-
spatialconfidence
(
type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence
, Coded Values:
[0: Unknown]
, [1: High]
, [2: Medium]
, ...1 more...
)
-
mark_deletion
(
type: esriFieldTypeSmallInteger, alias: Mark for Deletion, editable: true, nullable: true, defaultValue: 2, modelName: mark_deletion
, Coded Values:
[1: Yes]
, [2: No]
)
-
symbolrotation
(
type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation
, Range: [0, 359]
)
-
created_user
(
type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user
)
-
last_edited_user
(
type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user
)
-
esrignss_positionsourcetype
(
type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: esrignss_positionsourcetype
, Coded Values:
[0: Unknown]
, [1: User defined]
, [2: Integrated (System) Location Provider]
, ...2 more...
)
-
esrignss_receiver
(
type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: esrignss_receiver
)
-
esrignss_latitude
(
type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_latitude
)
-
esrignss_longitude
(
type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_longitude
)
-
esrignss_altitude
(
type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: esrignss_altitude
)
-
esrignss_h_rms
(
type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_h_rms
)
-
esrignss_v_rms
(
type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_v_rms
)
-
esrignss_fixdatetime
(
type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: esrignss_fixdatetime
)
-
esrignss_fixtype
(
type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: esrignss_fixtype
, Coded Values:
[0: Fix not valid]
, [1: GPS]
, [2: Differential GPS]
, ...2 more...
)
-
esrignss_correctionage
(
type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: esrignss_correctionage
)
-
esrignss_stationid
(
type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: esrignss_stationid
, Range: [0, 1023]
)
-
esrignss_numsats
(
type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: esrignss_numsats
, Range: [0, 99]
)
-
esrignss_pdop
(
type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_pdop
)
-
esrignss_hdop
(
type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_hdop
)
-
esrignss_vdop
(
type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: esrignss_vdop
)
-
esrignss_direction
(
type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: esrignss_direction
)
-
esrignss_speed
(
type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: esrignss_speed
)
-
esrisnsr_azimuth
(
type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: esrisnsr_azimuth
)
-
esrignss_avg_h_rms
(
type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_h_rms
)
-
esrignss_avg_v_rms
(
type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_v_rms
)
-
esrignss_avg_positions
(
type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: esrignss_avg_positions
)
-
esrignss_h_stddev
(
type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: esrignss_h_stddev
)
-
color
(
type: esriFieldTypeSmallInteger, alias: Color, editable: true, nullable: true, defaultValue: null, modelName: color
)
-
globalid
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid
)
-
year_manu
(
type: esriFieldTypeInteger, alias: Year Manufacture, editable: true, nullable: true, defaultValue: null, modelName: year_manu
)
-
model_num
(
type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 256, defaultValue: null, modelName: model_num
, Coded Values:
[K81: K81]
, [K81-A: K81-A]
, [K81-D: K81-D]
, ...12 more...
)
-
color_base
(
type: esriFieldTypeString, alias: Color Base, editable: true, nullable: true, length: 24, defaultValue: null, modelName: color_base
, Coded Values:
[Red: Red]
, [Yellow: Yellow]
, [Green: Green]
, ...4 more...
)
-
steamer_fit
(
type: esriFieldTypeString, alias: Steamer Fitting, editable: true, nullable: true, length: 20, defaultValue: null, modelName: steamer_fit
, Coded Values:
[YES: Yes]
, [NO: No]
, [UNK: Unknown]
)
-
steamer_fit_size
(
type: esriFieldTypeString, alias: Steamer Fitting Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: steamer_fit_size
)
-
hose_outlets
(
type: esriFieldTypeString, alias: Hose Outlets, editable: true, nullable: true, length: 20, defaultValue: null, modelName: hose_outlets
, Coded Values:
[1: 1]
, [2: 2]
, [3: 3]
, ...3 more...
)
-
address
(
type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 60, defaultValue: null, modelName: address
)
-
location
(
type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 20, defaultValue: null, modelName: location
, Coded Values:
[Yard: Yard]
, [Cal-de-Sac: Cal-de-Sac]
, [Other: Other (please fill in)]
)
-
loc_other
(
type: esriFieldTypeString, alias: loc_other, editable: true, nullable: true, length: 32, defaultValue: null, modelName: loc_other
)
-
repair
(
type: esriFieldTypeString, alias: Repair, editable: true, nullable: true, length: 3, defaultValue: null, modelName: repair
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
condition
(
type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: condition
, Coded Values:
[Good: Good]
, [Fair: Fair]
, [Poor: Poor]
)
-
storz
(
type: esriFieldTypeString, alias: Storz, editable: true, nullable: true, length: 50, defaultValue: null, modelName: storz
, Coded Values:
[YES: Yes]
, [NO: No]
, [UNK: Unknown]
)
-
barrel_size
(
type: esriFieldTypeString, alias: Barrel Size, editable: true, nullable: true, length: 20, defaultValue: null, modelName: barrel_size
, Coded Values:
[4: 4"]
, [4 1/2: 4 1/2"]
, [5: 5"]
, ...4 more...
)
-
verified
(
type: esriFieldTypeDate, alias: Verified, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: verified
)
-
leg_id
(
type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 64, defaultValue: null, modelName: leg_id
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
last_inspected_date
(
type: esriFieldTypeDateOnly, alias: last_inspected_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_inspected_date
)
-
nearest_address
(
type: esriFieldTypeString, alias: Nearest Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nearest_address
)
Types:
ID: 1
Name: Perrysburg
Domains:
-
assettype:
Inherited
-
diameter:
Inherited
-
secondarydiameter:
Inherited
-
manufacturer:
Inherited
-
status:
Inherited
-
ownedby:
Inherited
-
maintby:
Inherited
-
spatialsource:
Inherited
-
spatialconfidence:
Inherited
-
mark_deletion:
Inherited
-
symbolrotation:
Inherited
-
esrignss_positionsourcetype:
Inherited
-
esrignss_fixtype:
Inherited
-
esrignss_stationid:
Inherited
-
esrignss_numsats:
Inherited
-
model_num:
Inherited
-
color_base:
Inherited
-
steamer_fit:
Inherited
-
hose_outlets:
Inherited
-
location:
Inherited
-
repair:
Inherited
-
condition:
Inherited
-
storz:
Inherited
-
barrel_size:
Inherited
Templates:
-
Name: Perrysburg
Description:
Prototype:
lastmaint: null
last_inspected_date: null
assetid: null
assettype: 321
diameter: null
secondarydiameter: null
manufacturer: null
installdate: null
status: 8
hroute: null
inservicedate: null
retireddate: null
notes: null
ownedby: 1
maintby: 1
spatialsource: null
spatialconfidence: null
mark_deletion: 2
symbolrotation: null
verified: null
leg_id: null
esrignss_positionsourcetype: null
esrignss_receiver: null
esrignss_latitude: null
esrignss_longitude: null
esrignss_altitude: null
esrignss_h_rms: null
esrignss_v_rms: null
esrignss_fixdatetime: null
esrignss_fixtype: null
esrignss_correctionage: null
esrignss_stationid: null
esrignss_numsats: null
esrignss_pdop: null
esrignss_hdop: null
esrignss_vdop: null
esrignss_direction: null
esrignss_speed: null
esrisnsr_azimuth: null
esrignss_avg_h_rms: null
esrignss_avg_v_rms: null
esrignss_avg_positions: null
esrignss_h_stddev: null
color: null
nearest_address: null
year_manu: null
model_num: null
color_base: null
steamer_fit: null
steamer_fit_size: null
hose_outlets: null
address: null
location: null
loc_other: null
repair: null
condition: null
storz: null
barrel_size: null
Drawing Tool: esriFeatureEditToolPoint
ID: 2
Name: Private
Domains:
-
assettype:
Inherited
-
diameter:
Inherited
-
secondarydiameter:
Inherited
-
manufacturer:
Inherited
-
status:
Inherited
-
ownedby:
Inherited
-
maintby:
Inherited
-
spatialsource:
Inherited
-
spatialconfidence:
Inherited
-
mark_deletion:
Inherited
-
symbolrotation:
Inherited
-
esrignss_positionsourcetype:
Inherited
-
esrignss_fixtype:
Inherited
-
esrignss_stationid:
Inherited
-
esrignss_numsats:
Inherited
-
model_num:
Inherited
-
color_base:
Inherited
-
steamer_fit:
Inherited
-
hose_outlets:
Inherited
-
location:
Inherited
-
repair:
Inherited
-
condition:
Inherited
-
storz:
Inherited
-
barrel_size:
Inherited
Templates:
-
Name: Private
Description:
Prototype:
lastmaint: null
last_inspected_date: null
assetid: null
assettype: 321
diameter: null
secondarydiameter: null
manufacturer: null
installdate: null
status: 8
hroute: null
inservicedate: null
retireddate: null
notes: null
ownedby: 2
maintby: 1
spatialsource: null
spatialconfidence: null
mark_deletion: 2
symbolrotation: null
verified: null
leg_id: null
esrignss_positionsourcetype: null
esrignss_receiver: null
esrignss_latitude: null
esrignss_longitude: null
esrignss_altitude: null
esrignss_h_rms: null
esrignss_v_rms: null
esrignss_fixdatetime: null
esrignss_fixtype: null
esrignss_correctionage: null
esrignss_stationid: null
esrignss_numsats: null
esrignss_pdop: null
esrignss_hdop: null
esrignss_vdop: null
esrignss_direction: null
esrignss_speed: null
esrisnsr_azimuth: null
esrignss_avg_h_rms: null
esrignss_avg_v_rms: null
esrignss_avg_positions: null
esrignss_h_stddev: null
color: null
nearest_address: null
year_manu: null
model_num: null
color_base: null
steamer_fit: null
steamer_fit_size: null
hose_outlets: null
address: null
location: null
loc_other: null
repair: null
condition: null
storz: null
barrel_size: null
Drawing Tool: esriFeatureEditToolPoint
ID: 3
Name: NWWSD
Domains:
-
assettype:
Inherited
-
diameter:
Inherited
-
secondarydiameter:
Inherited
-
manufacturer:
Inherited
-
status:
Inherited
-
ownedby:
Inherited
-
maintby:
Inherited
-
spatialsource:
Inherited
-
spatialconfidence:
Inherited
-
mark_deletion:
Inherited
-
symbolrotation:
Inherited
-
esrignss_positionsourcetype:
Inherited
-
esrignss_fixtype:
Inherited
-
esrignss_stationid:
Inherited
-
esrignss_numsats:
Inherited
-
model_num:
Inherited
-
color_base:
Inherited
-
steamer_fit:
Inherited
-
hose_outlets:
Inherited
-
location:
Inherited
-
repair:
Inherited
-
condition:
Inherited
-
storz:
Inherited
-
barrel_size:
Inherited
Templates:
-
Name: NWWSD
Description:
Prototype:
lastmaint: null
last_inspected_date: null
assetid: null
assettype: 321
diameter: null
secondarydiameter: null
manufacturer: null
installdate: null
status: 8
hroute: null
inservicedate: null
retireddate: null
notes: null
ownedby: 3
maintby: 1
spatialsource: null
spatialconfidence: null
mark_deletion: 2
symbolrotation: null
verified: null
leg_id: null
esrignss_positionsourcetype: null
esrignss_receiver: null
esrignss_latitude: null
esrignss_longitude: null
esrignss_altitude: null
esrignss_h_rms: null
esrignss_v_rms: null
esrignss_fixdatetime: null
esrignss_fixtype: null
esrignss_correctionage: null
esrignss_stationid: null
esrignss_numsats: null
esrignss_pdop: null
esrignss_hdop: null
esrignss_vdop: null
esrignss_direction: null
esrignss_speed: null
esrisnsr_azimuth: null
esrignss_avg_h_rms: null
esrignss_avg_v_rms: null
esrignss_avg_positions: null
esrignss_h_stddev: null
color: null
nearest_address: null
year_manu: null
model_num: null
color_base: null
steamer_fit: null
steamer_fit_size: null
hose_outlets: null
address: null
location: null
loc_other: null
repair: null
condition: null
storz: null
barrel_size: null
Drawing Tool: esriFeatureEditToolPoint
ID: 100
Name: Other
Domains:
-
assettype:
Inherited
-
diameter:
Inherited
-
secondarydiameter:
Inherited
-
manufacturer:
Inherited
-
status:
Inherited
-
ownedby:
Inherited
-
maintby:
Inherited
-
spatialsource:
Inherited
-
spatialconfidence:
Inherited
-
mark_deletion:
Inherited
-
symbolrotation:
Inherited
-
esrignss_positionsourcetype:
Inherited
-
esrignss_fixtype:
Inherited
-
esrignss_stationid:
Inherited
-
esrignss_numsats:
Inherited
-
model_num:
Inherited
-
color_base:
Inherited
-
steamer_fit:
Inherited
-
hose_outlets:
Inherited
-
location:
Inherited
-
repair:
Inherited
-
condition:
Inherited
-
storz:
Inherited
-
barrel_size:
Inherited
Templates:
-
Name: Other
Description:
Prototype:
lastmaint: null
last_inspected_date: null
assetid: null
assettype: 321
diameter: null
secondarydiameter: null
manufacturer: null
installdate: null
status: 8
hroute: null
inservicedate: null
retireddate: null
notes: null
ownedby: 100
maintby: 1
spatialsource: null
spatialconfidence: null
mark_deletion: 2
symbolrotation: null
verified: null
leg_id: null
esrignss_positionsourcetype: null
esrignss_receiver: null
esrignss_latitude: null
esrignss_longitude: null
esrignss_altitude: null
esrignss_h_rms: null
esrignss_v_rms: null
esrignss_fixdatetime: null
esrignss_fixtype: null
esrignss_correctionage: null
esrignss_stationid: null
esrignss_numsats: null
esrignss_pdop: null
esrignss_hdop: null
esrignss_vdop: null
esrignss_direction: null
esrignss_speed: null
esrisnsr_azimuth: null
esrignss_avg_h_rms: null
esrignss_avg_v_rms: null
esrignss_avg_positions: null
esrignss_h_stddev: null
color: null
nearest_address: null
year_manu: null
model_num: null
color_base: null
steamer_fit: null
steamer_fit_size: null
hose_outlets: null
address: null
location: null
loc_other: null
repair: null
condition: null
storz: null
barrel_size: null
Drawing Tool: esriFeatureEditToolPoint
Relationships:
Capabilities: Query
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata