Name: Pump Stations
Display Field: PSTAT_ID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: The location of water pump stations in public water systems in the Commonwealth of Kentucky. A pump station is a vault or building feature on a waterline of a distribution system at which at least one water pump is located for the purpose of boosting water pressure in order to move water through the system or to fill water storage tanks.
Copyright Text: Water Resource Information System (WRIS)
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -20037507.8427882
YMin: -30240971.4583861
XMax: 20037507.8427882
YMax: 30240971.4583861
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"5ceada2b8bab852300f8da53051a30db","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB8AAAAXCAYAAADz/ZRUAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABgUlEQVRIic2TSytEYRiAH+brDKIzqDOUTEnGys4lIkqK/ABblzUrP8FGyaUUZUHZ2FlYCAulkWzURIlYiHI3LDgzzKHP10S5nukc5qlz6e30Pe95L4J/RKSWvG6iGy3bcNz0/PjAaufId/IStoeGid3lOC+3LHkHRr+S52Jeegl2geZzThyLwMGcFBe+D3/ec6MKCuodlN9KeaoP3E9/cLysnll+KG6H6zBE9sCohOwA7smvw7A1AHET4lEV252C+zPweKFpxlYCArt4MqBuDPZnlVgm0jAJ632qIjYQJENCkumH802VSOO07Q0R9sUR2OhXoppB0MtUBWRLWhddlms+KO9RAyZLLmlbhJUOOF2ztaKCZChqVoN1tKBK7guCV4ersItyTVeSBFKUE4BQL+RXQKDd1nHC1td5FVA9+LZOMpmWedVv+e7qnicS+E3sFwj+EfEhYj2mszPO6+Uk8WjaT/JDjNorLNPvrBnQS58wL0LfyW84WSrgjxB/JUo5+Qu2G22LbaoOdwAAAABJRU5ErkJggg==","contentType":"image/png","width":23,"height":17,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- PSTAT_ID (type: esriFieldTypeString, alias: Pump Station ID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AUXPWR (type: esriFieldTypeString, alias: Auxillary Power, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- AUXPWRTYPE (type: esriFieldTypeString, alias: Auxillary Power Type, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- CAPACITY (type: esriFieldTypeSmallInteger, alias: Pump Station Capacity in GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NO_PUMPS (type: esriFieldTypeInteger, alias: Total Number of Pumps, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GEN_SIZE (type: esriFieldTypeInteger, alias: Generator Size (Watts), SQL Type: sqlTypeOther, nullable: true, editable: true)
- TELEMETRY (type: esriFieldTypeString, alias: Telemetry Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [DIGITAL: Digital], [DIRECT WIRING: Direct Wiring], [RADIO: Radio], ... 3 more ...)
- OTHTELMETR (type: esriFieldTypeString, alias: Telemetry Type (Other), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- TELEFUNC (type: esriFieldTypeString, alias: Telemetry Functional, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- PRESCTRL (type: esriFieldTypeString, alias: Pressure Control, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- CHLORTN (type: esriFieldTypeString, alias: Chlorination, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- CONTINUOUS (type: esriFieldTypeString, alias: Operates Continuously, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- MODIFYUSER (type: esriFieldTypeString, alias: MODIFYUSER, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: false)
- MODIFYDATE (type: esriFieldTypeDate, alias: MODIFYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- CREATEDATE (type: esriFieldTypeDate, alias: GPS Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: false)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
- ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
- ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
- ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
- ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: Positional dilution of precision (3D), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: Horizontal Ground Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: Vertical (Elevation) Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Ground Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading of Phone / Tablet (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_X (type: esriFieldTypeDouble, alias: Calculated Point X (Longitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Y (type: esriFieldTypeDouble, alias: Calculated Point Y (Latitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
- POINT_Z (type: esriFieldTypeDouble, alias: Calculated Point Z (Elevation Height), SQL Type: sqlTypeOther, nullable: true, editable: true)
- CALC_XYZ_SOURCE (type: esriFieldTypeString, alias: Calculated Coordinate Source Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to assist with Asset ID., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: Pump Stations
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/25/2023 5:31:19 PM
Schema Last Edit Date: 8/22/2023 12:34:27 PM
Data Last Edit Date: 8/25/2023 5:31:19 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat