Name: ssPumpStation

Display Field: PSNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description: Pump Station is valid for all system types, but will be primarily used in sanitary systems. Pump station: A machine operated by hand or by a prime mover to raise or impel liquids through a pipe.

Copyright Text: As-Builts, Work Orders, Perpetual

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: -10093517.112289
YMin: 4637956.5358686
XMax: -10038812.6617304
YMax: 4700388.34503616
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPE","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"defaultLabel":"","uniqueValueGroups":[{"heading":"SUBTYPE","classes":[{"label":"Force","description":"Force","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,194,219,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["0"]]},{"label":"Low Pressure","description":"Low Pressure","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,189,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["1"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,194,219,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"0","label":"Force"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[179,252,189,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"1","label":"Low Pressure"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,252,189,255],"toColor":[224,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,179,252,255],"toColor":[233,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,233,252,255],"toColor":[197,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,190,184,255],"toColor":[252,190,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,215,255],"toColor":[252,238,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,194,252,255],"toColor":[179,194,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,225,255],"toColor":[187,252,225,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,251,255],"toColor":[252,215,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,210,255],"toColor":[252,179,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,235,182,255],"toColor":[252,235,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,216,252,255],"toColor":[212,216,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,196,255],"toColor":[187,252,196,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,251,255],"toColor":[179,252,251,255]}]}}},"scaleSymbols":true,"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: SUBTYPE

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: SYSTEM, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [S: Sanitary sewer], [D: Storm sewer], [C: Combined sewer])
• SUBTYPE (type: esriFieldTypeSmallInteger, alias: SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PSID (type: esriFieldTypeString, alias: PSID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PSNAME (type: esriFieldTypeString, alias: PSNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TOPELEVATION (type: esriFieldTypeDouble, alias: TOPELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INVERTELEVATION (type: esriFieldTypeDouble, alias: INVERELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERIORDROP1 (type: esriFieldTypeDouble, alias: INTERIORDROP1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERIORDROP2 (type: esriFieldTypeDouble, alias: INTERIORDROP2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERIORDROP3 (type: esriFieldTypeDouble, alias: INTERIORDROP3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERIORDROP4 (type: esriFieldTypeDouble, alias: INTERIORDROP4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPID (type: esriFieldTypeString, alias: OPID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAPDATE (type: esriFieldTypeDate, alias: MAPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSERVICEDATE (type: esriFieldTypeDate, alias: INSERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PJOBID (type: esriFieldTypeString, alias: PJOBID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OWNERSHIP (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: MSD], [2: Private], [3: County], ... 8 more ...)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MXASSETLOC (type: esriFieldTypeString, alias: MXASSETLOC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• STATUS (type: esriFieldTypeSmallInteger, alias: STATUS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Active], [2: Abandoned], [3: Removed], ... 5 more ...)
• ROWSTAMP (type: esriFieldTypeString, alias: ROWSTAMP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAST_MODIFIED_BY (type: esriFieldTypeString, alias: LAST_MODIFIED_BY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAST_MODIFIED_DATE (type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Survey: Survey grade < 1 ft], [Mapping: Mapping grade < 3 ft], [Aerial: Relative to aerial photo], ... 1 more ...)
• GPS_X (type: esriFieldTypeDouble, alias: GPS_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_Y (type: esriFieldTypeDouble, alias: GPS_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_Z (type: esriFieldTypeDouble, alias: GPS_Z, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_JOBID (type: esriFieldTypeString, alias: LAST_JOBID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PUMPFUNCTION (type: esriFieldTypeString, alias: PUMPFUNCTION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: Sanitary], [2: Storm], [3: ORS], ... 1 more ...)
• HAZARDTYPE (type: esriFieldTypeString, alias: HAZARDTYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: NONE], [5: Explosive], [6: Radioactive], ... 8 more ...)
• HAZARD_ENTRY (type: esriFieldTypeString, alias: HAZARD_ENTRY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [0: None], [1: Caution], [2: Do Not Enter], ... 1 more ...)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeString, alias: LATITUDE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeString, alias: LONGITUDE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BYPASSPORTAL (type: esriFieldTypeString, alias: BYPASSPORTAL, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• SYMBOLOGY (type: esriFieldTypeString, alias: SYMBOLOGY, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [BYPASSPORTAL: BYPASSPORTAL], [COMB: COMB], [ORS: ORS], ... 4 more ...)

Types:

ID: 0
Name: Force
Domains:

• Field Name: SYSTEM
  Inherited
  
• Field Name: OWNERSHIP
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: PUMPFUNCTION
  Inherited
  
• Field Name: HAZARDTYPE
  Inherited
  
• Field Name: HAZARD_ENTRY
  Inherited
  
• Field Name: BYPASSPORTAL
  Inherited
  
• Field Name: SYMBOLOGY
  Inherited
  
Templates:

Name: Force
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• BYPASSPORTAL: N
• SYSTEM: S
• SUBTYPE: 0
• OWNERSHIP: 1
• MXCREATIONSTATE: 0
• STATUS: 1
• ROWSTAMP: 0
• PUMPFUNCTION: 1
• HAZARDTYPE: 1

---

ID: 1
Name: Low Pressure
Domains:

• Field Name: SYSTEM
  Inherited
  
• Field Name: OWNERSHIP
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: SOURCE
  Inherited
  
• Field Name: PUMPFUNCTION
  Inherited
  
• Field Name: HAZARDTYPE
  Inherited
  
• Field Name: HAZARD_ENTRY
  Inherited
  
• Field Name: BYPASSPORTAL
  Inherited
  
• Field Name: SYMBOLOGY
  Inherited
  
Templates:

Name: Low Pressure
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• BYPASSPORTAL: N
• SYSTEM: S
• SUBTYPE: 1
• OWNERSHIP: 1
• MXCREATIONSTATE: 0
• STATUS: 1
• ROWSTAMP: 0
• PUMPFUNCTION: 1
• HAZARDTYPE: 1

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/10/2025 9:49:42 PM

Schema Last Edit Date: 3/10/2025 9:49:42 PM

Data Last Edit Date: 3/10/2025 9:49:42 PM

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