View In:   ArcGIS Online Map Viewer

Name: wHydrant

Display Field: HYDRANT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.1812955654040538E7
YMin: 4795417.251038511
XMax: -1.1805689292464431E7
YMax: 4808984.113743617
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Exercised
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: NO
  Label: NO
  Description: N/A
  Symbol:
  
• Value: YES
  Label: YES
  Description: N/A
  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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Exercised

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• HYDRANT_ID ( type: esriFieldTypeString, alias: HYDRANT_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HYDRANT_ID )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE , Coded Values: [Mueller: Mueller] , [Waterous: Waterous] )
• MAKE ( type: esriFieldTypeString, alias: MAKE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAKE , Coded Values: [Pacer: Pacer] , [Centurion: Centurion] )
• DATE_INST ( type: esriFieldTypeDate, alias: DATE_INST, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INST )
• STATIC_PSI ( type: esriFieldTypeDouble, alias: STATIC_PSI, editable: true, nullable: true, defaultValue: null, modelName: STATIC_PSI )
• FIRE_FLOW ( type: esriFieldTypeDouble, alias: FIRE_FLOW, editable: true, nullable: true, defaultValue: null, modelName: FIRE_FLOW )
• MNT_DATE ( type: esriFieldTypeDate, alias: MNT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MNT_DATE )
• MNT_CMNTS ( type: esriFieldTypeString, alias: MNT_CMNTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MNT_CMNTS )
• CAPS_CHNS ( type: esriFieldTypeString, alias: CAPS_CHNS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CAPS_CHNS , Coded Values: [YES: YES] , [NO: NO] )
• PAINT ( type: esriFieldTypeString, alias: PAINT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PAINT , Coded Values: [YES: YES] , [NO: NO] )
• FLAG ( type: esriFieldTypeString, alias: FLAG, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FLAG , Coded Values: [YES: YES] , [NO: NO] )
• GASKETS ( type: esriFieldTypeString, alias: GASKETS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: GASKETS , Coded Values: [YES: YES] , [NO: NO] )
• OIL_NOZ ( type: esriFieldTypeString, alias: OIL_NOZ, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OIL_NOZ , Coded Values: [YES: YES] , [NO: NO] )
• OIL_RES ( type: esriFieldTypeString, alias: OIL_RES, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OIL_RES , Coded Values: [YES: YES] , [NO: NO] )
• SERV_VLV ( type: esriFieldTypeString, alias: SERV_VLV, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SERV_VLV , Coded Values: [YES: YES] , [NO: NO] )
• DRAIN ( type: esriFieldTypeString, alias: DRAIN, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DRAIN , Coded Values: [YES: YES] , [NO: NO] )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE , Coded Values: [AS-BUILTS: AS-BUILTS] , [GPS: GPS] , [FIELD KNOWLEDGE: FIELD KNOWLEDGE] , ...1 more... )
• MOD_DATE ( type: esriFieldTypeDate, alias: MOD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• OPERATOR ( type: esriFieldTypeString, alias: OPERATOR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATOR , Coded Values: [JA: JA] , [TT: TT] , [NLG: NLG] , ...4 more... )
• ENG ( type: esriFieldTypeString, alias: ENGINEERING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ENG )
• ENG_NO ( type: esriFieldTypeString, alias: ENG_NO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ENG_NO )
• ROTATE ( type: esriFieldTypeDouble, alias: ROTATE, editable: true, nullable: true, defaultValue: null, modelName: ROTATE )
• RESD_PSI ( type: esriFieldTypeDouble, alias: RESD_PSI, editable: true, nullable: true, defaultValue: null, modelName: RESD_PSI )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOTES )
• FLOW_RATING ( type: esriFieldTypeDouble, alias: FLOW_RATING, editable: true, nullable: true, defaultValue: null, modelName: FLOW_RATING )
• PRIVATE ( type: esriFieldTypeString, alias: PRIVATE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PRIVATE , Coded Values: [YES: YES] , [NO: NO] )
• Turns_to_Open ( type: esriFieldTypeDouble, alias: Turns_to_Open, editable: true, nullable: true, defaultValue: null, modelName: Turns_to_Open )
• Route ( type: esriFieldTypeString, alias: Route, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Route )
• Route_Ahead ( type: esriFieldTypeString, alias: Route_Ahead, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Route_Ahead )
• Route_Back ( type: esriFieldTypeString, alias: Route_Back, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Route_Back )
• Year_ ( type: esriFieldTypeString, alias: Year_, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Year_ )
• IMAGE ( type: esriFieldTypeString, alias: Image, editable: true, nullable: true, length: 200, defaultValue: null, modelName: IMAGE )
• ROAD ( type: esriFieldTypeString, alias: ROAD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROAD )
• 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 )
• Exercised ( type: esriFieldTypeString, alias: Exercised, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Exercised , Coded Values: [YES: YES] , [NO: NO] )
• Exercised_Date ( type: esriFieldTypeDate, alias: Exercised_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Exercised_Date )
• 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] , ...3 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, 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 )

Types:

ID: NO
Name: NO
Domains:
• TYPE:
  Inherited
• MAKE:
  Inherited
• CAPS_CHNS:
  Inherited
• PAINT:
  Inherited
• FLAG:
  Inherited
• GASKETS:
  Inherited
• OIL_NOZ:
  Inherited
• OIL_RES:
  Inherited
• SERV_VLV:
  Inherited
• DRAIN:
  Inherited
• SOURCE:
  Inherited
• OPERATOR:
  Inherited
• PRIVATE:
  Inherited
• Exercised:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
Templates:
• Name: NO
  Description:
  Prototype:
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_POSITIONS: null
  HYDRANT_ID: null
  ELEVATION: null
  TYPE: null
  MAKE: null
  DATE_INST: null
  STATIC_PSI: null
  FIRE_FLOW: null
  MNT_DATE: null
  MNT_CMNTS: null
  CAPS_CHNS: null
  PAINT: null
  FLAG: null
  GASKETS: null
  OIL_NOZ: null
  OIL_RES: null
  SERV_VLV: null
  DRAIN: null
  SOURCE: null
  MOD_DATE: null
  OPERATOR: null
  ENG: null
  ENG_NO: null
  ROTATE: null
  RESD_PSI: null
  NOTES: null
  FLOW_RATING: null
  PRIVATE: null
  Turns_to_Open: null
  Route: null
  Route_Ahead: null
  Route_Back: null
  Year_: null
  IMAGE: null
  ROAD: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  Exercised: NO
  Exercised_Date: 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
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: YES
Name: YES
Domains:
• TYPE:
  Inherited
• MAKE:
  Inherited
• CAPS_CHNS:
  Inherited
• PAINT:
  Inherited
• FLAG:
  Inherited
• GASKETS:
  Inherited
• OIL_NOZ:
  Inherited
• OIL_RES:
  Inherited
• SERV_VLV:
  Inherited
• DRAIN:
  Inherited
• SOURCE:
  Inherited
• OPERATOR:
  Inherited
• PRIVATE:
  Inherited
• Exercised:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
Templates:
• Name: YES
  Description:
  Prototype:
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_POSITIONS: null
  HYDRANT_ID: null
  ELEVATION: null
  TYPE: null
  MAKE: null
  DATE_INST: null
  STATIC_PSI: null
  FIRE_FLOW: null
  MNT_DATE: null
  MNT_CMNTS: null
  CAPS_CHNS: null
  PAINT: null
  FLAG: null
  GASKETS: null
  OIL_NOZ: null
  OIL_RES: null
  SERV_VLV: null
  DRAIN: null
  SOURCE: null
  MOD_DATE: null
  OPERATOR: null
  ENG: null
  ENG_NO: null
  ROTATE: null
  RESD_PSI: null
  NOTES: null
  FLOW_RATING: null
  PRIVATE: null
  Turns_to_Open: null
  Route: null
  Route_Ahead: null
  Route_Back: null
  Year_: null
  IMAGE: null
  ROAD: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  Exercised: YES
  Exercised_Date: 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
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SDE.DBO.wHydrant_Inspections (0) -- Related To: SDE.DBO.wHydrant_Inspections (19)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

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

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata