Name: Hydrants
Display Field: FULL_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This is the City of Norfolk's Fire Hydrant layer. It is updated from physical record drawings (Water Intersection drawings, Asbuilts, Plan drawings, field sketches) Surveyed data form GPS or conventional survey. This data is Synchonized with Hansen (Work Order Management System).
Copyright Text: 1999 the original Utilities water infrastucture data was created.
2006 Database Schema updated by City Staff and Michael Baker Corporation.
2006 through 2013 Data collected and compiled by the Department of Utilities and Michael Baker Corporation.
2018 database was updated with the necessary fields to accept coordinate data (Latitude and Longitude in decimal degree format) from GPS or conventional survey.
2014 through current data is updated weekly or daily primarily by Utilities GIS and consultant(s) as necessary.
Default Visibility: true
MaxRecordCount: 1000
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: 1.211730000003311E7
YMin: 3466411.321076438
XMax: 1.2162274260331005E7
YMax: 3519574.645285949
Spatial Reference: 102747
(2284)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [0, 98, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
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: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
ANCILLARYROLE
(
type: esriFieldTypeSmallInteger, alias: AncillaryRole
, Coded Values:
[0: None]
, [1: Source]
, [2: Sink]
)
-
ENABLED
(
type: esriFieldTypeSmallInteger, alias: Enabled
, Coded Values:
[0: False]
, [1: True]
)
-
UNITID
(
type: esriFieldTypeString, alias: UNITID, length: 16
)
-
UNITTYPE
(
type: esriFieldTypeString, alias: UNITTYPE, length: 6
, Coded Values:
[H: HYDRANT]
)
-
COMPKEY
(
type: esriFieldTypeInteger, alias: COMPKEY
)
-
COMPTYPE
(
type: esriFieldTypeInteger, alias: COMPTYPE
, Coded Values:
[4: FAC]
, [12: HY]
, [35: SV]
, ...12 more...
)
-
DATE_INSTALLED
(
type: esriFieldTypeDate, alias: DATE_INSTALLED, length: 8
)
-
SOURCE
(
type: esriFieldTypeString, alias: SOURCE, length: 80
)
-
COMMENTS
(
type: esriFieldTypeString, alias: COMMENTS, length: 80
)
-
UPDATED_BY
(
type: esriFieldTypeString, alias: UPDATED_BY, length: 80
)
-
LAST_UPDATED
(
type: esriFieldTypeDate, alias: LAST_UPDATED, length: 8
)
-
OWNERSHIP
(
type: esriFieldTypeString, alias: OWNERSHIP, length: 10
, Coded Values:
[AIR: AIRPORT]
, [CON: CITY OF NORFOLK]
, [CONT: CONTRACTOR]
, ...7 more...
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 4
, Coded Values:
[A: ABANDONED]
, [CRIT: CRITICAL EQUIPMENT]
, [I: IN SERVICE]
, ...3 more...
)
-
ABANDONED_DATE
(
type: esriFieldTypeDate, alias: ABANDONED_DATE, length: 8
)
-
HYDSIZE
(
type: esriFieldTypeDouble, alias: HYDSIZE
, Coded Values:
[4.5: 4 1/2"]
, [5: 5"]
, [5.25: 5 1/4"]
, ...1 more...
)
-
COLOR
(
type: esriFieldTypeString, alias: COLOR, length: 20
, Coded Values:
[GREEN: GREEN]
, [GREY: GREY]
, [ORANGE: ORANGE]
, ...3 more...
)
-
CONV_NOTE
(
type: esriFieldTypeString, alias: CONV_NOTE, length: 80
)
-
REFRESH
(
type: esriFieldTypeSmallInteger, alias: REFRESH
, Coded Values:
[0: NO]
, [1: YES]
)
-
COND_DESC
(
type: esriFieldTypeString, alias: COND_DESC, length: 48
)
-
CONDITION
(
type: esriFieldTypeString, alias: CONDITION, length: 20
)
-
FULL_NAME
(
type: esriFieldTypeString, alias: FULL_NAME, length: 60
)
-
HOUSE_NUMB
(
type: esriFieldTypeString, alias: HOUSE_NUMB, length: 6
)
-
MFG_YEAR
(
type: esriFieldTypeDouble, alias: MFG_YEAR
)
-
OBSTRUCTIO
(
type: esriFieldTypeString, alias: OBSTRUCTIO, length: 20
)
-
PRE_STREET
(
type: esriFieldTypeString, alias: PRE_STREET, length: 20
)
-
STA
(
type: esriFieldTypeString, alias: STA, length: 2
)
-
STREET_NAM
(
type: esriFieldTypeString, alias: STREET_NAM, length: 20
)
-
STREET_SUF
(
type: esriFieldTypeString, alias: STREET_SUF, length: 20
)
-
STATIONING1
(
type: esriFieldTypeString, alias: STATIONING1, length: 50
)
-
MFG
(
type: esriFieldTypeInteger, alias: MFG
, Coded Values:
[1056: AMERICAN DARLING]
, [1104: MUELLER]
, [1698: CLOW]
, ...10 more...
)
-
ADDRESS
(
type: esriFieldTypeString, alias: ADDRESS, length: 50
)
-
ADDRKEY
(
type: esriFieldTypeInteger, alias: ADDRKEY
)
-
IN_MODEL
(
type: esriFieldTypeString, alias: IN_MODEL, length: 50
, Coded Values:
[0: No]
, [1: Yes]
)
-
FLOW_GPM
(
type: esriFieldTypeInteger, alias: Flow_GPM
)
-
STATIC_PSI
(
type: esriFieldTypeInteger, alias: STATIC_PSI
)
-
RESIDUAL_PSI
(
type: esriFieldTypeInteger, alias: RESIDUAL_PSI
)
-
PITOT_PSI
(
type: esriFieldTypeInteger, alias: PITOT_PSI
)
-
FLTESTDATE
(
type: esriFieldTypeDate, alias: FLTESTDATE, length: 8
)
-
FLTIME
(
type: esriFieldTypeInteger, alias: FLTIME
)
-
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
)
-
HORIZ_CONFIDENCE
(
type: esriFieldTypeString, alias: HORIZ_CONFIDENCE, length: 15
, Coded Values:
[1: High – Visible Sub-foot]
, [2: Medium – Visible Sub-meter]
, [3: Low – Greater than a meter and/or based on source documents or utility markings]
, ...1 more...
)
-
VERT_CONFIDENCE
(
type: esriFieldTypeString, alias: VERT_CONFIDENCE, length: 10
, Coded Values:
[1: High – .01 Foot]
, [2: Low – Data collection technique is unknown]
, [3: None – Used as a place holder]
)
-
ESRIGNSS_LATITUDE
(
type: esriFieldTypeDouble, alias: Latitude
)
-
ESRIGNSS_LONGITUDE
(
type: esriFieldTypeDouble, alias: Longitude
)
-
SHAPE
(
type: esriFieldTypeGeometry, alias: Shape
)
-
LUCITYAUTOID
(
type: esriFieldTypeInteger, alias: LINK TO LUCITY
)
-
INLUCITY
(
type: esriFieldTypeSmallInteger, alias: IN LUCITY?
)
-
LASTSYNDATE
(
type: esriFieldTypeDate, alias: LAST SYNCHRONIZED DATE, length: 8
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata