View In:   ArcGIS Online Map Viewer

Name: RWS.REC_SYSTEM_VALVE_PNT

Display Field: COMPUTERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 2000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: -1.2455902996395096E7
YMin: 3922506.334777317
XMax: -1.243811128022408E7
YMax: 3942623.2655749316
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• EID ( type: esriFieldTypeInteger, alias: EID, editable: true, nullable: true, defaultValue: null, modelName: EID )
• LOCATION_EID ( type: esriFieldTypeInteger, alias: LOCATION_EID, editable: true, nullable: true, defaultValue: null, modelName: LOCATION_EID )
• SYSTEMVALVE_OID ( type: esriFieldTypeInteger, alias: SYSTEMVALVE_OID, editable: true, nullable: true, defaultValue: null, modelName: SYSTEMVALVE_OID )
• FEATUREOWNER ( type: esriFieldTypeString, alias: FEATURE OWNER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FEATUREOWNER , Coded Values: [COC: CHANDLER] , [COM: MESA] , [INTEL: INTEL] , ...6 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLE STATUS, editable: true, nullable: true, length: 20, defaultValue: ACTIVE, modelName: LIFECYCLESTATUS , Coded Values: [ABANDONED: ABANDONED] , [ACTIVE: ACTIVE] , [INACTIVE: INACTIVE] , ...2 more... )
• SPATIALSOURCE ( type: esriFieldTypeString, alias: SPATIAL SOURCE, editable: true, nullable: true, length: 20, defaultValue: GPS, modelName: SPATIALSOURCE , Coded Values: [ASBUILT: ASBUILT] , [FIELD: FIELD] , [GPS: GPS] , ...2 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TYPE , Coded Values: [STANDARD: STANDARD] , [BLOWOFF: BLOWOFF] , [ARV: ARV] )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVE TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VALVETYPE , Coded Values: [BALL: BALL] , [BUTTERFLY: BUTTERFLY] , [GATE: GATE] , ...2 more... )
• FUNCTION ( type: esriFieldTypeString, alias: FUNCTION, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FUNCTION , Coded Values: [INLINE: INLINE] , [STUBOUT: STUBOUT] , [UNKNOWN: UNKNOWN] , ...5 more... )
• DATE_INSTALL ( type: esriFieldTypeDate, alias: VALVE DATE INSTALLED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INSTALL )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• GROUNDTYPE ( type: esriFieldTypeString, alias: GROUNDTYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GROUNDTYPE , Coded Values: [LANDSCAPE: LANDSCAPE] , [ASPHALT: ASPHALT] , [CONCRETE: CONCRETE] , ...1 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: WATERTYPE, editable: true, nullable: true, length: 25, defaultValue: POTABLE, modelName: WATERTYPE )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• FEATUREID ( type: esriFieldTypeString, alias: FEATURE ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FEATUREID )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PRESSURE ZONE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSUREZONE )
• ZONE_SPLIT_VALVE ( type: esriFieldTypeSmallInteger, alias: ZONE SPLIT VALVE, editable: true, nullable: true, defaultValue: 0, modelName: ZONE_SPLIT_VALVE , Coded Values: [1: True] , [0: False] )
• FMA_QGRID ( type: esriFieldTypeString, alias: FMA QGRID, editable: true, nullable: true, length: 7, defaultValue: null, modelName: FMA_QGRID )
• QS_NUMBER ( type: esriFieldTypeString, alias: QS NUMBER, editable: true, nullable: true, length: 5, defaultValue: null, modelName: QS_NUMBER )
• ROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• GPSOID ( type: esriFieldTypeInteger, alias: GPS OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: GPSOID )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_TIME ( type: esriFieldTypeString, alias: GPS TIME, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPS_TIME )
• GPS_HEIGHT ( type: esriFieldTypeDouble, alias: GPS HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: GPS_HEIGHT )
• HORZ_PREC ( type: esriFieldTypeDouble, alias: HORZ PREC, editable: true, nullable: true, defaultValue: null, modelName: HORZ_PREC )
• VERT_PREC ( type: esriFieldTypeDouble, alias: VERT PREC, editable: true, nullable: true, defaultValue: null, modelName: VERT_PREC )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• DATAFILE ( type: esriFieldTypeString, alias: DATAFILE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DATAFILE )
• GPS_COMMENT ( type: esriFieldTypeString, alias: GPS COMMENT, editable: true, nullable: true, length: 30, defaultValue: null, modelName: GPS_COMMENT )
• ADDR_NUM ( type: esriFieldTypeInteger, alias: ADDR_NUM, editable: true, nullable: true, defaultValue: null, modelName: ADDR_NUM )
• SNG_ST_DIR ( type: esriFieldTypeString, alias: SNG_ST_DIR, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SNG_ST_DIR )
• SNG_ST_STR ( type: esriFieldTypeString, alias: SNG_ST_STR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SNG_ST_STR )
• SNG_ST_TY ( type: esriFieldTypeString, alias: SNG_ST_TY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SNG_ST_TY )
• SNG_ST_SFX ( type: esriFieldTypeString, alias: SNG_ST_SFX, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SNG_ST_SFX )
• WO_CAT_CODE ( type: esriFieldTypeString, alias: WO CAT CODE, editable: true, nullable: true, length: 10, defaultValue: 1310A06, modelName: WO_CAT_CODE )
• WO_CAT ( type: esriFieldTypeString, alias: WO CAT, editable: true, nullable: true, length: 25, defaultValue: System Valves, modelName: WO_CAT )
• WO_ZONE ( type: esriFieldTypeDouble, alias: WO ZONE, editable: true, nullable: true, defaultValue: null, modelName: WO_ZONE )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity?, editable: true, nullable: true, defaultValue: 0, modelName: INLUCITY )
• LUCITYLINK ( type: esriFieldTypeInteger, alias: Link to Lucity, editable: true, nullable: true, defaultValue: null, modelName: LUCITYLINK )
• DATE_ADDED ( type: esriFieldTypeDate, alias: DATE_ADDED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATE_ADDED )
• DATE_MODIFIED ( type: esriFieldTypeDate, alias: DATE_MODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATE_MODIFIED )
• USER_ADDED ( type: esriFieldTypeString, alias: USER_ADDED, editable: false, nullable: true, length: 255, defaultValue: null, modelName: USER_ADDED )
• USER_MODIFIED ( type: esriFieldTypeString, alias: USER_MODIFIED, editable: false, nullable: true, length: 255, defaultValue: null, modelName: USER_MODIFIED )
• FILE_NO ( type: esriFieldTypeString, alias: FILE_NO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FILE_NO )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LASTACTIVITY , Coded Values: [EXE: Exercise Valve] , [UPDT: Update Info] , [ABAN: Remove/Abandon] , ...4 more... )
• LASTEXERCISEDDATE ( type: esriFieldTypeDate, alias: LASTEXERCISEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISEDDATE )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LINKEDDOCUMENTS )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATEDBY )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OPERATIONALSTATUS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPERATIONALSTATUS , Coded Values: [INOP: Inoperable] , [ABAN: Remove/Abandon] , [NOAC: No Access] , ...9 more... )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• REBAR_PRESENT ( type: esriFieldTypeSmallInteger, alias: REBAR_PRESENT, editable: true, nullable: true, defaultValue: null, modelName: REBAR_PRESENT , Coded Values: [1: True] , [0: False] )
• CURRENTLYOPEN ( type: esriFieldTypeString, alias: CURRENTLYOPEN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CURRENTLYOPEN , Coded Values: [YES: YES] , [NO: NO] , [MAYBE: MAYBE] )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, editable: true, nullable: true, defaultValue: null, modelName: HIGHTORQUE )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: CLOCKWISETOCLOSE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOCKWISETOCLOSE )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [1.5: 1.5] , [2: 2] , [3: 3] , ...13 more... )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeInteger, alias: ESRIGNSS_POSITIONSOURCETYPE, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 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 )
• 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 )
• LUCITY_SYNC_DATE ( type: esriFieldTypeDate, alias: LUCITY_SYNC_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LUCITY_SYNC_DATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: RWS.REC_SYSTEM_VALVE_PNT
  Description:
  Prototype:
  GROUNDTYPE: null
  PRESSUREZONE: null
  SNG_ST_SFX: null
  WO_CAT_CODE: 1310A06
  WO_ZONE: null
  LUCITY_SYNC_DATE: null
  EID: null
  LOCATION_EID: null
  SYSTEMVALVE_OID: null
  FEATUREOWNER: null
  LIFECYCLESTATUS: null
  SPATIALSOURCE: null
  TYPE: null
  VALVETYPE: null
  FUNCTION: null
  DATE_INSTALL: null
  NOTES: null
  WATERTYPE: POTABLE
  LOCATIONDESCRIPTION: null
  FEATUREID: null
  ZONE_SPLIT_VALVE: 0
  FMA_QGRID: null
  QS_NUMBER: null
  ROTATION: null
  GPSOID: null
  GPS_DATE: null
  GPS_TIME: null
  GPS_HEIGHT: null
  HORZ_PREC: null
  VERT_PREC: null
  NORTHING: null
  EASTING: null
  DATAFILE: null
  GPS_COMMENT: null
  ADDR_NUM: null
  SNG_ST_DIR: null
  SNG_ST_STR: null
  SNG_ST_TY: null
  WO_CAT: System Valves
  INLUCITY: 0
  LUCITYLINK: null
  ESRIGNSS_H_STDDEV: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  FILE_NO: null
  ACTIVITYID: null
  COMPUTERNAME: null
  DATESTAMP: null
  LASTACTIVITY: null
  LASTEXERCISEDDATE: null
  LINKEDDOCUMENTS: null
  OPERATEDBY: null
  OPERATIONALSTATUS: null
  OPTIME: null
  REBAR_PRESENT: null
  CURRENTLYOPEN: null
  TURNSTOCLOSE: null
  DEPTH: null
  HIGHTORQUE: null
  CLOCKWISETOCLOSE: null
  DIAMETER: 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
  ESRIGNSS_SPEED: null
  ESRISNSR_AZIMUTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,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: DATE_ADDED
• Creator Field: USER_ADDED
• Edit Date Field: DATE_MODIFIED
• Editor Field: USER_MODIFIED

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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