View In:   ArcGIS Online Map Viewer

Name: wSystemValve

Display Field: TYPE

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.1812954081097027E7
YMin: 4801864.224787561
XMax: -1.1807778610475468E7
YMax: 4808957.866931699
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 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE , Coded Values: [GATE: GATE] , [CURB-STOP: CURB-STOP] , [SHUT-OFF: SHUT-OFF] , ...3 more... )
• SIZE ( type: esriFieldTypeDouble, alias: SIZE, editable: true, nullable: true, defaultValue: null, modelName: SIZE , Coded Values: [10: 10] , [12: 12] , [14: 14] , ...10 more... )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• SRVC_VLV ( type: esriFieldTypeString, alias: SRVC_VLV, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SRVC_VLV , Coded Values: [YES: YES] , [NO: NO] )
• OPERABLE ( type: esriFieldTypeString, alias: OPERABLE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPERABLE , Coded Values: [YES: YES] , [NO: NO] )
• VALVE_BOX ( type: esriFieldTypeString, alias: VALVE_BOX, editable: true, nullable: true, length: 5, defaultValue: null, modelName: VALVE_BOX , Coded Values: [YES: YES] , [NO: NO] )
• EXT_ROD ( type: esriFieldTypeString, alias: EXT_ROD, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EXT_ROD , Coded Values: [YES: YES] , [NO: NO] )
• TURNS_OPN ( type: esriFieldTypeDouble, alias: TURNS_OPN, editable: true, nullable: true, defaultValue: null, modelName: TURNS_OPN )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONDITION )
• DATE_INST ( type: esriFieldTypeDate, alias: DATE_INST, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INST )
• ACCNT_NO ( type: esriFieldTypeString, alias: ACCNT_NO, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ACCNT_NO )
• MOD_DATE ( type: esriFieldTypeDate, alias: MOD_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• 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... )
• OPERATOR ( type: esriFieldTypeString, alias: OPERATOR, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OPERATOR )
• 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: esriFieldTypeInteger, alias: ROTATE, editable: true, nullable: true, defaultValue: null, modelName: ROTATE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOTES )
• WTR_TIGHT ( type: esriFieldTypeString, alias: WTR_TIGHT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WTR_TIGHT , Coded Values: [YES: YES] , [NO: NO] )
• PRIVATE ( type: esriFieldTypeString, alias: PRIVATE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PRIVATE , Coded Values: [YES: YES] , [NO: NO] )
• IMAGE ( type: esriFieldTypeString, alias: Image, editable: true, nullable: true, length: 200, defaultValue: null, modelName: IMAGE )
• VALVE_ID ( type: esriFieldTypeString, alias: VALVE_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VALVE_ID )
• 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 )
• VALVE_NUMBER ( type: esriFieldTypeString, alias: VALVE NUMBER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VALVE_NUMBER )
• LOCATION_IN_CLUSTER ( type: esriFieldTypeString, alias: LOCATION IN CLUSTER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LOCATION_IN_CLUSTER )
• MAIN_SIZE ( type: esriFieldTypeDouble, alias: MAIN SIZE, editable: true, nullable: true, defaultValue: null, modelName: MAIN_SIZE , Coded Values: [10: 10] , [12: 12] , [16: 16] , ...12 more... )
• NUMBER_OF_TURNS ( type: esriFieldTypeSmallInteger, alias: NUMBER OF TURNS, editable: true, nullable: true, defaultValue: null, modelName: NUMBER_OF_TURNS )
• VALVE_DEPTH ( type: esriFieldTypeDouble, alias: VALVE DEPTH, editable: true, nullable: true, defaultValue: null, modelName: VALVE_DEPTH )
• EXERCISED ( type: esriFieldTypeString, alias: EXERCISED, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EXERCISED , Coded Values: [YES: YES] , [NO: NO] )
• EXERCISED_WITH ( type: esriFieldTypeString, alias: EXERCISED WITH, editable: true, nullable: true, length: 15, defaultValue: null, modelName: EXERCISED_WITH , Coded Values: [TRAILER: TRAILER] , [MANUALLY: MANUALLY] )
• MAX_TORQUE ( type: esriFieldTypeDouble, alias: MAX TORQUE, editable: true, nullable: true, defaultValue: null, modelName: MAX_TORQUE )
• RETURNED_TO_OPEN ( type: esriFieldTypeString, alias: RETURNED TO OPEN, editable: true, nullable: true, length: 3, defaultValue: null, modelName: RETURNED_TO_OPEN , Coded Values: [YES: YES] , [NO: NO] )
• EXTENSION_ROD ( type: esriFieldTypeString, alias: EXTENSION ROD, editable: true, nullable: true, length: 3, defaultValue: null, modelName: EXTENSION_ROD , Coded Values: [YES: YES] , [NO: NO] )
• VALVE_BOX_CONDITION ( type: esriFieldTypeString, alias: VALVE BOX CONDITION, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_BOX_CONDITION , Coded Values: [GOOD: GOOD] , [POOR: POOR] , [UNABLE TO KEY: UNABLE TO KEY] )
• GROUNDWATER ( type: esriFieldTypeString, alias: GROUNDWATER, editable: true, nullable: true, length: 3, defaultValue: null, modelName: GROUNDWATER , Coded Values: [YES: YES] , [NO: NO] )
• GRADE_RING_AND_LID_CONDITION ( type: esriFieldTypeString, alias: GRADE RING AND LID CONDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GRADE_RING_AND_LID_CONDITION )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: COMMENTS )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• VALVE_OPERATOR ( type: esriFieldTypeString, alias: VALVE OPERATOR, editable: true, nullable: true, length: 3, defaultValue: null, modelName: VALVE_OPERATOR , Coded Values: [JA: JA] , [DK: DK] , [KS: KS] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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
• SIZE:
  Inherited
• SRVC_VLV:
  Inherited
• OPERABLE:
  Inherited
• VALVE_BOX:
  Inherited
• EXT_ROD:
  Inherited
• SOURCE:
  Inherited
• WTR_TIGHT:
  Inherited
• PRIVATE:
  Inherited
• MAIN_SIZE:
  Inherited
• EXERCISED:
  Inherited
• EXERCISED_WITH:
  Inherited
• RETURNED_TO_OPEN:
  Inherited
• EXTENSION_ROD:
  Inherited
• VALVE_BOX_CONDITION:
  Inherited
• GROUNDWATER:
  Inherited
• VALVE_OPERATOR:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
Templates:
• Name: NO
  Description:
  Prototype:
  VALVE_DEPTH: null
  ESRIGNSS_AVG_POSITIONS: null
  TYPE: null
  SIZE: null
  DEPTH: null
  ELEVATION: null
  SRVC_VLV: null
  OPERABLE: null
  VALVE_BOX: null
  EXT_ROD: null
  TURNS_OPN: null
  CONDITION: null
  DATE_INST: null
  ACCNT_NO: null
  MOD_DATE: null
  SOURCE: null
  OPERATOR: null
  ENG: null
  ENG_NO: null
  ROTATE: null
  NOTES: null
  WTR_TIGHT: null
  PRIVATE: null
  IMAGE: null
  VALVE_ID: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  VALVE_NUMBER: null
  LOCATION_IN_CLUSTER: null
  MAIN_SIZE: null
  NUMBER_OF_TURNS: null
  EXERCISED: NO
  EXERCISED_WITH: null
  MAX_TORQUE: null
  RETURNED_TO_OPEN: null
  EXTENSION_ROD: null
  VALVE_BOX_CONDITION: null
  GROUNDWATER: null
  GRADE_RING_AND_LID_CONDITION: null
  COMMENTS: null
  GPS_DATE: null
  VALVE_OPERATOR: null
  ESRIGNSS_H_STDDEV: null
  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
• SIZE:
  Inherited
• SRVC_VLV:
  Inherited
• OPERABLE:
  Inherited
• VALVE_BOX:
  Inherited
• EXT_ROD:
  Inherited
• SOURCE:
  Inherited
• WTR_TIGHT:
  Inherited
• PRIVATE:
  Inherited
• MAIN_SIZE:
  Inherited
• EXERCISED:
  Inherited
• EXERCISED_WITH:
  Inherited
• RETURNED_TO_OPEN:
  Inherited
• EXTENSION_ROD:
  Inherited
• VALVE_BOX_CONDITION:
  Inherited
• GROUNDWATER:
  Inherited
• VALVE_OPERATOR:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
Templates:
• Name: YES
  Description:
  Prototype:
  VALVE_DEPTH: null
  ESRIGNSS_AVG_POSITIONS: null
  TYPE: null
  SIZE: null
  DEPTH: null
  ELEVATION: null
  SRVC_VLV: null
  OPERABLE: null
  VALVE_BOX: null
  EXT_ROD: null
  TURNS_OPN: null
  CONDITION: null
  DATE_INST: null
  ACCNT_NO: null
  MOD_DATE: null
  SOURCE: null
  OPERATOR: null
  ENG: null
  ENG_NO: null
  ROTATE: null
  NOTES: null
  WTR_TIGHT: null
  PRIVATE: null
  IMAGE: null
  VALVE_ID: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  VALVE_NUMBER: null
  LOCATION_IN_CLUSTER: null
  MAIN_SIZE: null
  NUMBER_OF_TURNS: null
  EXERCISED: YES
  EXERCISED_WITH: null
  MAX_TORQUE: null
  RETURNED_TO_OPEN: null
  EXTENSION_ROD: null
  VALVE_BOX_CONDITION: null
  GROUNDWATER: null
  GRADE_RING_AND_LID_CONDITION: null
  COMMENTS: null
  GPS_DATE: null
  VALVE_OPERATOR: null
  ESRIGNSS_H_STDDEV: null
  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.wValve_Inspections (1) -- Related To: SDE.DBO.wValve_Inspections (18)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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