View In:   ArcGIS Online Map Viewer

Name: WS.SYSTEM_VALVE_PNT

Display Field: COMPUTERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: WATER SYSTEM VALVES

Copyright Text: PREMIUM CONTENT

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.351474006540767E7
YMin: 3876936.501960828
XMax: -1.214731774542032E7
YMax: 4241865.414109106
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: COC] , [PRIVATE: PRIVATE] , [COM: COM] , ...4 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLE STATUS, editable: true, nullable: true, length: 20, defaultValue: ACTIVE, modelName: LIFECYCLESTATUS , Coded Values: [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , [INACTIVE: INACTIVE] , ...3 more... )
• SPATIALSOURCE ( type: esriFieldTypeString, alias: SPATIAL SOURCE, editable: true, nullable: true, length: 20, defaultValue: GPS, modelName: SPATIALSOURCE , Coded Values: [GPS: GPS] , [ORTHOPHOTO: ORTHOPHOTO] , [ASBUILT: ASBUILT] , ...5 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TYPE , Coded Values: [STANDARD: STANDARD] , [BLOWOFF: BLOWOFF] , [ARV: ARV] , ...1 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVE TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VALVETYPE , Coded Values: [GATE: GATE] , [BUTTERFLY: BUTTERFLY] , [BALL: BALL] , ...4 more... )
• FUNCTION ( type: esriFieldTypeString, alias: FUNCTION, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FUNCTION , Coded Values: [INLINE: INLINE] , [HYDRANT: HYDRANT] , [STUBOUT: STUBOUT] , ...12 more... )
• SIZE_ ( type: esriFieldTypeDouble, alias: SIZE, editable: true, nullable: true, defaultValue: null, modelName: SIZE_ )
• 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] )
• SPACE ( type: esriFieldTypeString, alias: space, editable: true, nullable: true, length: 50, defaultValue: null, modelName: space )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DIAMETER , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...12 more... )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: Clockwise To Close ?, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOCKWISETOCLOSE )
• CURRENTLYOPEN ( type: esriFieldTypeString, alias: Currently Open ?, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CURRENTLYOPEN , Coded Values: [YES: YES] , [NO: NO] , [MAYBE: MAYBE] )
• NORMALLYOPEN ( type: esriFieldTypeString, alias: Normally Open ?, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NORMALLYOPEN )
• PRESSURESETTING ( type: esriFieldTypeString, alias: Pressure Setting, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PRESSURESETTING )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: Regulation Type, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REGULATIONTYPE )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• MOTORIZED ( type: esriFieldTypeString, alias: Motorized, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOTORIZED )
• PERCENTOPEN ( type: esriFieldTypeInteger, alias: Percent Open, editable: true, nullable: true, defaultValue: null, modelName: PERCENTOPEN )
• SPACE2 ( type: esriFieldTypeString, alias: space2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: space2 )
• 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 )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• 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_INSTALL ( type: esriFieldTypeDate, alias: VALVE DATE INSTALLED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INSTALL )
• 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 )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACTIVITYID )
• 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... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATESTAMP )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, editable: true, nullable: true, length: 5, defaultValue: null, modelName: OPTIME )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COMPUTERNAME )
• 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... )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LINKEDDOCUMENTS )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, editable: true, nullable: true, defaultValue: null, modelName: HIGHTORQUE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• LASTEXERCISEDDATE ( type: esriFieldTypeDate, alias: LASTEXERCISEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTEXERCISEDDATE )
• 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 )
• 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] , ...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 )
• NON_POP_LID ( type: esriFieldTypeSmallInteger, alias: NON_POP_LID, editable: true, nullable: true, defaultValue: null, modelName: NON_POP_LID , Coded Values: [0: 0] , [1: 1] )
• 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: WS.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
  SIZE_: null
  WATERTYPE: POTABLE
  LOCATIONDESCRIPTION: null
  FEATUREID: null
  ZONE_SPLIT_VALVE: 0
  SPACE: null
  DIAMETER: null
  CLOCKWISETOCLOSE: null
  CURRENTLYOPEN: null
  NORMALLYOPEN: null
  PRESSURESETTING: null
  REGULATIONTYPE: null
  TURNSTOCLOSE: null
  MOTORIZED: null
  PERCENTOPEN: null
  SPACE2: null
  FMA_QGRID: null
  QS_NUMBER: null
  NOTES: 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
  DATE_INSTALL: null
  NON_POP_LID: null
  ESRIGNSS_H_STDDEV: null
  ACTIVITYID: null
  LASTACTIVITY: null
  DATESTAMP: null
  OPTIME: null
  COMPUTERNAME: null
  OPERATEDBY: null
  OPERATIONALSTATUS: null
  LINKEDDOCUMENTS: null
  HIGHTORQUE: null
  DEPTH: null
  LASTEXERCISEDDATE: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  FILE_NO: 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
  ESRIGNSS_AVG_H_RMS: 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