View In:
ArcGIS Online Map Viewer
Name: Hydrant Valves
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: cb4fb9fa0dc34d758dc904c0d18b0a9d
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: 1629025.1581053361
YMin: 612570.5777133405
XMax: 1667772.6337598376
YMax: 661860.7019019276
Spatial Reference: 102722
(3734)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Feature Draw Order:
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: 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: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID
)
-
FACILITYID
(
modelName: FACILITYID, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: Facility Identifier, type: esriFieldTypeString
)
-
INSTALLDATE
(
modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Install Date, type: esriFieldTypeDate
)
-
LOCDESC
(
modelName: LOCDESC, nullable: true, editable: true, defaultValue: N/A, length: 200, alias: Location Description, type: esriFieldTypeString
)
-
ROTATION
(
modelName: ROTATION, nullable: true, editable: true, defaultValue: N/A, alias: Rotation, type: esriFieldTypeDouble
)
-
DIAMETER
(
modelName: DIAMETER, nullable: true, editable: true, defaultValue: N/A, alias: Diameter, type: esriFieldTypeDouble
, Coded Values:
[0.75: 3/4"]
, [1: 1"]
, [1.25: 1 1/4"]
, ...27 more...
)
-
VALVETYPE
(
modelName: VALVETYPE, nullable: true, editable: true, defaultValue: Unknown, length: 30, alias: Valve Type, type: esriFieldTypeString
, Coded Values:
[Ball: Ball]
, [Butterfly: Butterfly]
, [Cone: Cone]
, ...9 more...
)
-
BYPASSVALVE
(
modelName: BYPASSVALVE, nullable: true, editable: true, defaultValue: N/A, alias: Bypass Valve, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
CLOCKTOCLOSE
(
modelName: CLOCKTOCLOSE, nullable: true, editable: true, defaultValue: N/A, alias: Clockwise To Close, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
NORMALLYOPEN
(
modelName: NORMALLYOPEN, nullable: true, editable: true, defaultValue: N/A, alias: Normally Open, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
TURNSTOCLOSE
(
modelName: TURNSTOCLOSE, nullable: true, editable: true, defaultValue: N/A, alias: Turns To Close, type: esriFieldTypeInteger
)
-
OPERABLE
(
modelName: OPERABLE, nullable: true, editable: true, defaultValue: N/A, alias: Operable, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
HYDRFLAG
(
modelName: HYDRFLAG, nullable: true, editable: true, defaultValue: N/A, alias: Hydrant Valve, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
CURROPEN
(
modelName: CURROPEN, nullable: true, editable: true, defaultValue: N/A, alias: Currently Open, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
, [3: Closed due to Project]
, ...2 more...
)
-
Enabled
(
modelName: Enabled, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger, required: true
, Coded Values:
[0: False]
, [1: True]
)
-
ACTIVEFLAG
(
modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger
, Coded Values:
[0: FALSE]
, [1: TRUE]
, [2: ABANDONDED]
, ...1 more...
)
-
OWNEDBY
(
modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: City]
, ...8 more...
)
-
MAINTBY
(
modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: City]
, ...6 more...
)
-
LASTUPDATE
(
modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Last Update Date, type: esriFieldTypeDate
)
-
LASTEDITOR
(
modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: Last Editor, type: esriFieldTypeString
, Coded Values:
[BG: BG]
, [Landmark: Landmark]
)
-
NOTES
(
modelName: NOTES, nullable: true, editable: true, defaultValue: N/A, length: 100, alias: NOTES, type: esriFieldTypeString
)
-
DEPTH
(
modelName: DEPTH, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: DEPTH, type: esriFieldTypeString
)
-
NEEDS_COLLECTED
(
modelName: NEEDS_COLLECTED, nullable: true, editable: true, defaultValue: N/A, length: 3, alias: NEEDS_COLLECTED, type: esriFieldTypeString
, Coded Values:
[YES: YES]
, [NO: NO]
)
-
OLD_VALVE_ID
(
modelName: OLD_VALVE_ID, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: OLD_VALVE_ID, type: esriFieldTypeString
)
-
GlobalID
(
modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID
)
-
CollectionType
(
modelName: CollectionType, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: CollectionType, type: esriFieldTypeString
, Coded Values:
[GPS: GPS]
, [FieldBook: FieldBook]
, [AsBuiltCAD: AsBuiltCAD]
, ...5 more...
)
-
created_user
(
modelName: created_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString
)
-
created_date
(
modelName: created_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate
)
-
last_edited_user
(
modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString
)
-
last_edited_date
(
modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate
)
-
actual_pos_stat
(
modelName: actual_pos_stat, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: actual_pos_stat, type: esriFieldTypeString
, Coded Values:
[OPEN: OPEN]
, [CLOSED: CLOSED]
, [TEMP_OFF: TEMP_OFF]
, ...11 more...
)
-
exercised
(
modelName: exercised, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: exercised, type: esriFieldTypeString
, Coded Values:
[YES: YES]
, [NO: NO]
)
-
exercised_date
(
modelName: exercised_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: exercised_date, type: esriFieldTypeDate
)
-
WVTURNSIZE
(
modelName: WVTURNSIZE, nullable: true, editable: true, defaultValue: N/A, alias: WVTURNSIZE, type: esriFieldTypeSmallInteger
, Coded Values:
[3: 3]
, [4: 4]
, [6: 6]
, ...7 more...
)
-
WVTURNTYPE
(
modelName: WVTURNTYPE, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: WVTURNTYPE, type: esriFieldTypeString
, Coded Values:
[BUTTERFLY: BUTTERFLY]
, [GATE: GATE]
, [BYPASS: BYPASS]
)
-
WVDEPTH
(
modelName: WVDEPTH, nullable: true, editable: true, defaultValue: N/A, alias: WVDEPTH, type: esriFieldTypeSmallInteger
)
-
WVDATE
(
modelName: WVDATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: WVDATE, type: esriFieldTypeDate
)
-
WVREPAIR
(
modelName: WVREPAIR, nullable: true, editable: true, defaultValue: NO, length: 8, alias: WVREPAIR, type: esriFieldTypeString
, Coded Values:
[YES: YES]
, [NO: NO]
)
-
WVNOTES
(
modelName: WVNOTES, nullable: true, editable: true, defaultValue: N/A, length: 300, alias: EB, type: esriFieldTypeString
)
-
WVDIRECTION
(
modelName: WVDIRECTION, nullable: true, editable: true, defaultValue: LEFT-HAND OPEN, length: 50, alias: WVDIRECTION, type: esriFieldTypeString
, Coded Values:
[LEFT-HAND OPEN: LEFT-HAND OPEN]
, [RIGHT-HAND OPEN: RIGHT-HAND OPEN]
)
-
WVTURNS
(
modelName: WVTURNS, nullable: true, editable: true, defaultValue: N/A, length: 10, alias: WVTURNS, type: esriFieldTypeString
)
-
as_built_link
(
modelName: as_built_link, nullable: true, editable: true, defaultValue: N/A, length: 250, alias: as_built_link, type: esriFieldTypeString
)
-
LOCKED
(
modelName: LOCKED, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: LOCKED, type: esriFieldTypeString
, Coded Values:
[Locked By BG: Locked By BG]
, [Locked By Landmark: Locked By Landmark]
)
-
elementsGUID
(
modelName: elementsGUID, nullable: true, editable: true, defaultValue: N/A, length: 38, alias: elementsGUID, type: esriFieldTypeGUID
)
Templates:
-
Name: GIS.DBO.HydrantValve
Description:
Prototype:
ROTATION: null
NEEDS_COLLECTED: null
exercised: null
HYDRFLAG: null
MAINTBY: 1
OLD_VALVE_ID: null
LOCDESC: null
CURROPEN: null
WVNOTES: null
TURNSTOCLOSE: null
NOTES: null
WVREPAIR: NO
LASTUPDATE: null
CLOCKTOCLOSE: null
CollectionType: null
FACILITYID: null
as_built_link: null
LASTEDITOR: null
elementsGUID: null
WVDATE: null
VALVETYPE: Unknown
exercised_date: null
LOCKED: null
BYPASSVALVE: null
OPERABLE: null
Enabled: 1
NORMALLYOPEN: null
OWNEDBY: 1
WVTURNS: null
WVTURNTYPE: null
DIAMETER: null
ACTIVEFLAG: 1
actual_pos_stat: null
INSTALLDATE: null
WVDEPTH: null
WVTURNSIZE: null
WVDIRECTION: LEFT-HAND OPEN
DEPTH: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Update,Uploads,Editing
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
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 Analytic
Apply Edits
Update Features
Calculate
Append
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata