Name: SLSPUMP
Display Field: PUMPNO
Type: Table
Description:
Copyright Text:
Max Record Count: 10000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- LIFTSTATION (type: esriFieldTypeSmallInteger, alias: LIFTSTATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PUMPNO (type: esriFieldTypeSmallInteger, alias: PUMPNO, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 3 more ...)
- TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FLOOD SUC: FLOODED SUCTION], [FLOODSUCSUB: FLOODED SUCTION (SUBMERSIBLE)], [NO INFO: NO INFO], ... 3 more ...)
- PUMPINSTALLDATE (type: esriFieldTypeDate, alias: PUMPINSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MFG (type: esriFieldTypeString, alias: MFG, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- MFGYEAR (type: esriFieldTypeSmallInteger, alias: MFGYEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SERIALNO (type: esriFieldTypeString, alias: SERIALNO, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- MODEL (type: esriFieldTypeString, alias: MODEL, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- PUMPSIZE (type: esriFieldTypeString, alias: SIZE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [1.25: 1.25"], [2: 2"], [3: 3"], ... 8 more ...)
- CAPACITY (type: esriFieldTypeString, alias: GPM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- TDH (type: esriFieldTypeString, alias: TDH, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- RPM (type: esriFieldTypeString, alias: RPM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SHEAVESIZE (type: esriFieldTypeString, alias: SHEAVESIZE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [3: 3"], [4.5: 4-1/2"], [4: 4"], ... 8 more ...)
- IMPELLERSIZE (type: esriFieldTypeString, alias: IMPELLERSIZE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [.4: .4"], [1.4: 1.4"], [3: 3"], ... 118 more ...)
- IMPELERTYPE (type: esriFieldTypeString, alias: IMPELLERTYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [2-VANE CHANNEL: 2-VANE CHANNEL], [CLOSED VANE 1: CLOSED VANE-1], [CLOSED VANE 2: CLOSED VANE-2], ... 20 more ...)
- MOTORINSTALLDATE (type: esriFieldTypeDate, alias: MOTORINSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MOTORMFG (type: esriFieldTypeString, alias: MOTORMFG, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- MOTORMFGYEAR (type: esriFieldTypeSmallInteger, alias: MOTORMFGYEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MOTORMODEL (type: esriFieldTypeString, alias: MOTORMODEL, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MOTORHP (type: esriFieldTypeString, alias: MOTORHP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MOTORRPM (type: esriFieldTypeString, alias: MOTORRPM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MOTORSHEAVESIZE (type: esriFieldTypeString, alias: MOTORSHEAVESIZE, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [3: 3"], [4.5: 4-1/2"], [4: 4"], ... 8 more ...)
- MOTORPHASEINVERTER (type: esriFieldTypeString, alias: MOTORPHASEINVERTER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MOTORPHASE (type: esriFieldTypeString, alias: MOTORPHASE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: SINGLE], [3: THREE])
- MOTORVOLTAGE (type: esriFieldTypeString, alias: MOTORVOLTAGE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [110: 110], [208: 208], [230: 230], ... 3 more ...)
- MOTORFLA (type: esriFieldTypeString, alias: MOTORFLA, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- MOTORRA (type: esriFieldTypeString, alias: MOTOR RUNNING AMP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- COMMENTS (type: esriFieldTypeString, alias: GENERAL COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- DATAMODDATE (type: esriFieldTypeDate, alias: DATAMODDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DATE_GIS_IP (type: esriFieldTypeDate, alias: DATE_GIS_IP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MOD_COMMENTS (type: esriFieldTypeString, alias: MOD_COMMENTS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- MOTORRPMTYPE (type: esriFieldTypeString, alias: MOTORRPMTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CONSTANT: CONSTANT], [VARIABLE: VARIABLE])
- PUMPRPMTYPE (type: esriFieldTypeString, alias: PUMPRPMTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CONSTANT: CONSTANT], [VARIABLE: VARIABLE])
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: SLSPUMP
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/11/2026 6:13:41 PM
Schema Last Edit Date: 3/11/2026 6:13:41 PM
Data Last Edit Date: 3/11/2026 6:13:41 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat