Name: Water System Well Pumps

Display Field: description

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2356579.40387881
YMin: 576061.838157728
XMax: 2368514.31012705
YMax: 580764.085971057
Spatial Reference: 103180 (6597)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SubtypeCode","field2":null,"field3":null,"defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,168,45,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,45,143,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"value":"0","label":"Well Pump","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: SubtypeCode

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SubtypeCode (type: esriFieldTypeInteger, alias: Subtype Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• pumpID (type: esriFieldTypeString, alias: Pump ID, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• operationalStatus (type: esriFieldTypeString, alias: Operational Status, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• pumpCapacity (type: esriFieldTypeSmallInteger, alias: Pump Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• groundElevation (type: esriFieldTypeDouble, alias: Ground Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• projectPriorityCode (type: esriFieldTypeSmallInteger, alias: Project Priority Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• yearInstalled (type: esriFieldTypeSmallInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lastRepairDate (type: esriFieldTypeDate, alias: Last Repair Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• symbolRotationAngle (type: esriFieldTypeSmallInteger, alias: Symbol Rotation Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• criticalAnnotation (type: esriFieldTypeString, alias: Critical Annotation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• verifiedGPS (type: esriFieldTypeString, alias: Verified GPS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• servicePressureZone (type: esriFieldTypeString, alias: Service Pressure Zone, SQL Type: sqlTypeOther, length: 4, nullable: false, editable: true)
• dateExported (type: esriFieldTypeDate, alias: dateExported, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• firstIntervalDepth (type: esriFieldTypeSmallInteger, alias: First Interval Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• depth (type: esriFieldTypeSmallInteger, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRS (type: esriFieldTypeString, alias: Township Range Section, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• QQSec (type: esriFieldTypeString, alias: QQ Section, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• metered (type: esriFieldTypeString, alias: Metered, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• use_ (type: esriFieldTypeString, alias: Use, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• chlorinated (type: esriFieldTypeString, alias: Chlorinated, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])

Types:

ID: 0
Name: Well Pump
Domains:

• Field Name: ownership
  Coded Values:[COC: City of Colville], [PVT: Private]
  
• Field Name: operationalStatus
  Coded Values:[INSVC: In Service], [NOSVC: Not in Service], [ABND: Abandoned]
  
• Field Name: projectPriorityCode
  Coded Values:[0, 100]
  
• Field Name: symbolRotationAngle
  Coded Values:[0, 360]
  
• Field Name: verifiedGPS
  Coded Values:[Y: Yes], [N: No]
  
• Field Name: servicePressureZone
  Coded Values:[HAW: Hawthorne-PRV], [LOW: Lower], [MAD: Madison-PRV], More
  
Templates:

Name: Well Pump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• SubtypeCode: 0
• description: Well Pump
• ownership: COC
• operationalStatus: INSVC
• projectPriorityCode: 0
• yearInstalled: 0
• symbolRotationAngle: 0
• verifiedGPS: N
• servicePressureZone:

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/2/2021 3:26:47 PM

Schema Last Edit Date: 12/2/2021 3:26:47 PM

Data Last Edit Date: 12/2/2021 3:26:47 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat