View In:   ArcGIS Online Map Viewer

Name: Hydrants

Display Field: AUTHORITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature cntains the required fields and data for field editing of the County's fire hydrants. With the appropriate scripting function the maintenance individuals, in the field, can produce the final "Actual Flow" of each hydrant derived from the rquired fields and values.

Service Item Id: 9de3fc3b23b84685bb546e65f3dbb9d5

Copyright Text: Roanoke County; Western Virginia Water Authority

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 1.0980192267113298E7
YMin: 3570143.0835192204
XMax: 1.10928038391338E7
YMax: 3674619.6947755665
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AUTHORITYID ( type: esriFieldTypeString, alias: AuthorityID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AUTHORITYID )
• GROUND_ELEVATION ( type: esriFieldTypeDouble, alias: Ground Elevation, editable: true, nullable: true, defaultValue: null, modelName: GROUND_ELEVATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MANUFACTURER )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MODEL )
• STATIC_PRESSURE ( type: esriFieldTypeInteger, alias: Static Pressure, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PRESSURE )
• FLUSHING ( type: esriFieldTypeInteger, alias: Flushing?, editable: true, nullable: true, defaultValue: null, modelName: Flushing )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled )
• CASTDATE ( type: esriFieldTypeString, alias: CASTDATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CASTDATE )
• DATEGPSED ( type: esriFieldTypeDate, alias: DATEGPSED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEGPSED )
• JONESCOUPLING ( type: esriFieldTypeInteger, alias: Jones Coupling, editable: true, nullable: true, defaultValue: null, modelName: JONESCOUPLING )
• JURISDICTIONOWNER ( type: esriFieldTypeString, alias: JURISDICTIONOWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JURISDICTIONOWNER , Coded Values: [Roanoke County: Roanoke County] , [Town of Vinton: Town of Vinton] )
• INFONETID ( type: esriFieldTypeString, alias: INFONETID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: INFONETID )
• OPERATIONAL_STATUS ( type: esriFieldTypeString, alias: Operational Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OPERATIONAL_STATUS )
• WVWA_LATITUDE ( type: esriFieldTypeDouble, alias: WVWA_LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: WVWA_LATITUDE )
• WVWA_LONGITUDE ( type: esriFieldTypeDouble, alias: WVWA_LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: WVWA_LONGITUDE )
• ID ( type: esriFieldTypeDouble, alias: ID, editable: true, nullable: true, defaultValue: null, modelName: ID )
• NWS_ADDRESS_ID ( type: esriFieldTypeDouble, alias: NWS_ADDRESS_ID, editable: true, nullable: true, defaultValue: null, modelName: NWS_ADDRESS_ID )
• NWS_HYDRANT_ID ( type: esriFieldTypeDouble, alias: NWS_HYDRANT_ID, editable: true, nullable: true, defaultValue: null, modelName: NWS_HYDRANT_ID )
• NWS_HYDRANT_NUMBER ( type: esriFieldTypeString, alias: NWS_HYDRANT_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NWS_HYDRANT_NUMBER )
• NWS_HYDRANT_LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: NWS_HYDRANT_LOCATIONDESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NWS_HYDRANT_LOCATIONDESCRIPTION )
• NWS_HYDRANT_SERIAL_NUMBER ( type: esriFieldTypeString, alias: NWS_HYDRANT_SERIAL_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NWS_HYDRANT_SERIAL_NUMBER )
• NWS_HYDRANT_IN_SERVICE ( type: esriFieldTypeString, alias: NWS_HYDRANT_IN_SERVICE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: NWS_HYDRANT_IN_SERVICE )
• NWS_HYDRANT_COLOR ( type: esriFieldTypeString, alias: NWS_HYDRANT_COLOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NWS_HYDRANT_COLOR )
• NWS_LATITUDE ( type: esriFieldTypeDouble, alias: NWS_LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: NWS_LATITUDE )
• NWS_LONGITUDE ( type: esriFieldTypeDouble, alias: NWS_LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: NWS_LONGITUDE )
• FEATURE_CREATOR ( type: esriFieldTypeString, alias: FEATURE_CREATOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FEATURE_CREATOR )
• DRY ( type: esriFieldTypeString, alias: DRY, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DRY , Coded Values: [Yes: Yes] , [No: No] )
• RESIDUAL ( type: esriFieldTypeDouble, alias: RESIDUAL, editable: true, nullable: true, defaultValue: null, modelName: RESIDUAL )
• OBSERVED_FLOW ( type: esriFieldTypeDouble, alias: OBSERVED_FLOW, editable: true, nullable: true, defaultValue: null, modelName: OBSERVED_FLOW )
• PITOT_PRESSURE ( type: esriFieldTypeDouble, alias: PITOT_PRESSURE, editable: true, nullable: true, defaultValue: null, modelName: PITOT_PRESSURE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 300, defaultValue: null, modelName: NOTES )
• HYDRANT_CONDITION ( type: esriFieldTypeString, alias: HYDRANT_CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HYDRANT_CONDITION , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
• HARD_OPERATE ( type: esriFieldTypeString, alias: HARD_OPERATE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HARD_OPERATE , Coded Values: [Yes: Yes] , [No: No] )
• OPERABLE ( type: esriFieldTypeString, alias: OPERABLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERABLE , Coded Values: [Yes: Yes] , [No: No] )
• CORRODED ( type: esriFieldTypeString, alias: CORRODED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CORRODED , Coded Values: [Yes: Yes] , [No: No] )
• MAINTENANCE_REQD ( type: esriFieldTypeString, alias: MAINTENANCE_REQD, editable: true, nullable: true, length: 200, defaultValue: null, modelName: MAINTENANCE_REQD )
• START_DATETIME ( type: esriFieldTypeDate, alias: START_DATETIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATETIME )
• END_DATETIME ( type: esriFieldTypeDate, alias: END_DATETIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: END_DATETIME )
• WORKORDER_ID ( type: esriFieldTypeString, alias: WORKORDER_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKORDER_ID )
• INSPECTION_STATUS ( type: esriFieldTypeString, alias: INSPECTION_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTION_STATUS , Coded Values: [Unassigned: Unassigned] , [Assigned: Assigned] , [In Progress: In Progress] , ...1 more... )
• Remove ( type: esriFieldTypeString, alias: Remove, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Remove )
• ToV_HYDRANTS ( type: esriFieldTypeString, alias: ToV_HYDRANTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ToV_HYDRANTS )
• AVAILABLE_FLOW ( type: esriFieldTypeInteger, alias: AVAILABLE_FLOW, editable: true, nullable: true, defaultValue: 0, modelName: AVAILABLE_FLOW )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Hydrants
  Description:
  Prototype:
  AVAILABLE_FLOW: 0
  AUTHORITYID: null
  GROUND_ELEVATION: null
  MANUFACTURER: null
  MODEL: null
  STATIC_PRESSURE: null
  FLUSHING: null
  INSTALLDATE: null
  COMMENTS: null
  ENABLED: 1
  CASTDATE: null
  DATEGPSED: null
  JONESCOUPLING: null
  JURISDICTIONOWNER: null
  INFONETID: null
  OPERATIONAL_STATUS: null
  WVWA_LATITUDE: null
  WVWA_LONGITUDE: null
  ID: null
  NWS_ADDRESS_ID: null
  NWS_HYDRANT_ID: null
  NWS_HYDRANT_NUMBER: null
  NWS_HYDRANT_LOCATIONDESCRIPTION: null
  NWS_HYDRANT_SERIAL_NUMBER: null
  NWS_HYDRANT_IN_SERVICE: null
  NWS_HYDRANT_COLOR: null
  NWS_LATITUDE: null
  NWS_LONGITUDE: null
  FEATURE_CREATOR: null
  DRY: null
  RESIDUAL: null
  OBSERVED_FLOW: null
  PITOT_PRESSURE: null
  NOTES: null
  HYDRANT_CONDITION: null
  HARD_OPERATE: null
  OPERABLE: null
  CORRODED: null
  MAINTENANCE_REQD: null
  START_DATETIME: null
  END_DATETIME: null
  WORKORDER_ID: null
  INSPECTION_STATUS: null
  Remove: null
  ToV_HYDRANTS: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata