Name: Exercised Valves

Display Field: COMPUTERNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: WATER SYSTEM VALVES

Service Item Id: 69f9831d9b5641ab94f005655a8325c8

Copyright Text: PREMIUM CONTENT

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9027.977411

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -2138992.024
YMin: 801876.960000001
XMax: 1531737.12725
YMax: 1663420.7175
Spatial Reference: 0  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [115, 178, 255, 255]
Size: 13.0
Angle: 0.0
XOffset: 0
YOffset: 0
Label: N/A
Description: N/A
Transparency: 50
Labeling Info:

Feature Draw Order:

N/A

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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• EID ( type: esriFieldTypeInteger, alias: EID )
• LOCATION_EID ( type: esriFieldTypeInteger, alias: LOCATION_EID )
• SYSTEMVALVE_OID ( type: esriFieldTypeInteger, alias: SYSTEMVALVE_OID )
• FEATUREOWNER ( type: esriFieldTypeString, alias: FEATURE OWNER, length: 20 , Coded Values: [COC: COC] , [PRIVATE: PRIVATE] , [COM: COM] , ...4 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LIFECYCLE STATUS, length: 20 , Coded Values: [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , [INACTIVE: INACTIVE] , ...3 more... )
• SPATIALSOURCE ( type: esriFieldTypeString, alias: SPATIAL SOURCE, length: 20 , Coded Values: [GPS: GPS] , [ORTHOPHOTO: ORTHOPHOTO] , [ASBUILT: ASBUILT] , ...5 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 25 , Coded Values: [STANDARD: STANDARD] , [BLOWOFF: BLOWOFF] , [ARV: ARV] , ...1 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVE TYPE, length: 10 , Coded Values: [GATE: GATE] , [BUTTERFLY: BUTTERFLY] , [BALL: BALL] , ...4 more... )
• FUNCTION ( type: esriFieldTypeString, alias: FUNCTION, length: 25 , Coded Values: [INLINE: INLINE] , [HYDRANT: HYDRANT] , [STUBOUT: STUBOUT] , ...12 more... )
• SIZE_ ( type: esriFieldTypeDouble, alias: SIZE )
• GROUNDTYPE ( type: esriFieldTypeString, alias: GROUNDTYPE, length: 25 , Coded Values: [LANDSCAPE: LANDSCAPE] , [ASPHALT: ASPHALT] , [CONCRETE: CONCRETE] , ...1 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: WATERTYPE, length: 25 )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATION, length: 100 )
• FEATUREID ( type: esriFieldTypeString, alias: FEATURE ID, length: 20 )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PRESSURE ZONE, length: 20 )
• ZONE_SPLIT_VALVE ( type: esriFieldTypeSmallInteger, alias: ZONE SPLIT VALVE , Coded Values: [1: True] , [0: False] )
• SPACE ( type: esriFieldTypeString, alias: space, length: 50 )
• DIAMETER ( type: esriFieldTypeString, alias: Diameter, length: 8 , Coded Values: [2: 2] , [3: 3] , [4: 4] , ...12 more... )
• CLOCKWISETOCLOSE ( type: esriFieldTypeString, alias: Clockwise To Close ?, length: 8 )
• CURRENTLYOPEN ( type: esriFieldTypeString, alias: Currently Open ?, length: 8 , Coded Values: [YES: YES] , [NO: NO] , [MAYBE: MAYBE] )
• NORMALLYOPEN ( type: esriFieldTypeString, alias: Normally Open ?, length: 8 )
• PRESSURESETTING ( type: esriFieldTypeString, alias: Pressure Setting, length: 8 )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: Regulation Type, length: 8 )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: Turns To Close )
• MOTORIZED ( type: esriFieldTypeString, alias: Motorized, length: 8 )
• PERCENTOPEN ( type: esriFieldTypeInteger, alias: Percent Open )
• SPACE2 ( type: esriFieldTypeString, alias: space2, length: 8 )
• FMA_QGRID ( type: esriFieldTypeString, alias: FMA QGRID, length: 7 )
• QS_NUMBER ( type: esriFieldTypeString, alias: QS NUMBER, length: 5 )
• NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
• ROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• GPSOID ( type: esriFieldTypeInteger, alias: GPS OBJECTID )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS DATE, length: 8 )
• GPS_TIME ( type: esriFieldTypeString, alias: GPS TIME, length: 10 )
• GPS_HEIGHT ( type: esriFieldTypeDouble, alias: GPS HEIGHT )
• HORZ_PREC ( type: esriFieldTypeDouble, alias: HORZ PREC )
• VERT_PREC ( type: esriFieldTypeDouble, alias: VERT PREC )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING )
• DATAFILE ( type: esriFieldTypeString, alias: DATAFILE, length: 20 )
• GPS_COMMENT ( type: esriFieldTypeString, alias: GPS COMMENT, length: 30 )
• ADDR_NUM ( type: esriFieldTypeInteger, alias: ADDR_NUM )
• SNG_ST_DIR ( type: esriFieldTypeString, alias: SNG_ST_DIR, length: 2 )
• SNG_ST_STR ( type: esriFieldTypeString, alias: SNG_ST_STR, length: 50 )
• SNG_ST_TY ( type: esriFieldTypeString, alias: SNG_ST_TY, length: 4 )
• SNG_ST_SFX ( type: esriFieldTypeString, alias: SNG_ST_SFX, length: 5 )
• WO_CAT_CODE ( type: esriFieldTypeString, alias: WO CAT CODE, length: 10 )
• WO_CAT ( type: esriFieldTypeString, alias: WO CAT, length: 25 )
• WO_ZONE ( type: esriFieldTypeDouble, alias: WO ZONE )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity? )
• LUCITYLINK ( type: esriFieldTypeInteger, alias: Link to Lucity )
• DATE_INSTALL ( type: esriFieldTypeDate, alias: VALVE DATE INSTALLED, length: 8 )
• DATE_ADDED ( type: esriFieldTypeDate, alias: DATE_ADDED, length: 8 )
• DATE_MODIFIED ( type: esriFieldTypeDate, alias: DATE_MODIFIED, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• ACTIVITYID ( type: esriFieldTypeString, alias: ACTIVITYID, length: 20 )
• LASTACTIVITY ( type: esriFieldTypeString, alias: LASTACTIVITY, length: 4 , Coded Values: [EXE: Exercise Valve] , [UPDT: Update Info] , [ABAN: Remove/Abandon] , ...4 more... )
• DATESTAMP ( type: esriFieldTypeDate, alias: DATESTAMP, length: 8 )
• OPTIME ( type: esriFieldTypeString, alias: OPTIME, length: 5 )
• COMPUTERNAME ( type: esriFieldTypeString, alias: COMPUTERNAME, length: 30 )
• OPERATEDBY ( type: esriFieldTypeString, alias: OPERATEDBY, length: 30 )
• OPERATIONALSTATUS ( type: esriFieldTypeString, alias: OPERATIONALSTATUS, length: 5 , Coded Values: [INOP: Inoperable] , [ABAN: Remove/Abandon] , [NOAC: No Access] , ...9 more... )
• LINKEDDOCUMENTS ( type: esriFieldTypeString, alias: LINKEDDOCUMENTS, length: 500 )
• HIGHTORQUE ( type: esriFieldTypeSmallInteger, alias: HIGHTORQUE )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH )
• LASTEXERCISEDDATE ( type: esriFieldTypeDate, alias: LASTEXERCISEDDATE, length: 8 )
• USER_ADDED ( type: esriFieldTypeString, alias: USER_ADDED, length: 255 )
• USER_MODIFIED ( type: esriFieldTypeString, alias: USER_MODIFIED, length: 255 )
• FILE_NO ( type: esriFieldTypeString, alias: FILE_NO, length: 10 )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, length: 8 )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°) )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h) )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°) )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• NON_POP_LID ( type: esriFieldTypeSmallInteger, alias: NON_POP_LID , Coded Values: [0: 0] , [1: 1] )
• LUCITY_SYNC_DATE ( type: esriFieldTypeDate, alias: LUCITY_SYNC_DATE, length: 8 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata