Name: Sewer Pump Stations

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 2083319.92104505
YMin: 721079.140381811
XMax: 2141207.1409023
YMax: 819723.16848813
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"54f58680f5db45bfae5b01413919f2f2","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABMklEQVQ4jZ3SsVHrQBSF4Y83Cl2ATKwCNCOHLsCBROQCiOQaiFDmBl5iRa8AR0DgAgitGRVAjFSAchOAFhv7BeZEO7N7/3v2nhvB+iDzCz3caKL1QTZX7eMrGb3G+lDNIohlEvlvTIjGw87KoAsXqTJAW7VWbdBJleYezwG9RqIwMQVbhXv7AJirQqNjtwEwdh0BvUavAYkiFC1stGqJ4hxwrIlbg04it3UX4IlcIvfm5RzQa0xMDTqt2tKTWCaW+etWojD36DixE8DO6qv7VKoMD5eewpf+mVl6vgy4tw8zGPXmRSIPTmKZnVUY6n9n8A14NniXKk/mc9HBJaVKW3ehsFWfuAyAMZafimUWNl5VIZWFzXkKx9v1U2N0lxQhLMw1Grx/Ah5uNOtDNbuagD90Hxk8W+wbtSWdAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":12,"angle":0,"xoffset":0,"yoffset":0}},"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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STRUCTTYPE (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [PUMPSTATION: Pump Station], [LIFTSTATION: Lift Station], [ODORCONTROL: Odor Control Facility], ... 4 more ...)
• NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• OPDATE (type: esriFieldTypeDate, alias: Operational Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PUMPFIRMCAPACITY (type: esriFieldTypeDouble, alias: Pump Firm Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAPACITYUNITS (type: esriFieldTypeString, alias: Capacity Units, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [GPM: Gallons Per Million], [MGD: Millions of Gallons per Day])
• NUMBEROFPUMPS (type: esriFieldTypeSmallInteger, alias: Number Of Pumps, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PUMPTYPE (type: esriFieldTypeString, alias: Pump Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• AUTOMATION (type: esriFieldTypeSmallInteger, alias: Automation, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• EMERGENCYPOWER (type: esriFieldTypeSmallInteger, alias: Emergency Power, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• ELEVATEDFLOORSLAB (type: esriFieldTypeSmallInteger, alias: Elevated Floor Slab, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• PROJECTNAME (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PERMITNUMBER (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• POWERCOMPANY (type: esriFieldTypeString, alias: Power Company, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Active], [2: Inactive], [3: Abandoned], ... 2 more ...)
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: COR], [1: Private], [2: Other])
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: COR], [1: Private], [2: Other])
• SOURCE (type: esriFieldTypeString, alias: Source Data, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true, Coded Values: [ASBUILT: Asbuilt Plan], [CIPPLAN: CIP Asbuilt], [CONSTRUCTIONPLAN: Construction Plan], ... 16 more ...)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EDITEDBY (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• EDITEDON (type: esriFieldTypeDate, alias: Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATEDBY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CREATEDON (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BASIN (type: esriFieldTypeString, alias: Drainage Basin, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [BEAVER EAST: BEAVER EAST], [BEAVER-SW: BEAVER-SW], [BEAVERDAM-KN: BEAVERDAM-KN], ... 67 more ...)
• GRID (type: esriFieldTypeString, alias: Map Grid, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROTATION (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• PS_ID (type: esriFieldTypeString, alias: PS ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSTALLDATE_1 (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STRUCTURE_TYPE (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PHYSICAL_ADDRESS (type: esriFieldTypeString, alias: Physical Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OPERATIONAL_DATE (type: esriFieldTypeDate, alias: Operational Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ELECTRICAL_BILLING_ADDRESS (type: esriFieldTypeString, alias: Electrical Billing Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATER_SERVICE_ADDRESS (type: esriFieldTypeString, alias: Water Service Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DRAINAGE_BASIN (type: esriFieldTypeString, alias: Drainage Basin, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PUMP_MANUF (type: esriFieldTypeString, alias: Pump Manufacture, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PUMP_TYPE (type: esriFieldTypeString, alias: Pump Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• NO_OF_PUMPS (type: esriFieldTypeString, alias: No# of Pumps, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CAPACITY (type: esriFieldTypeString, alias: Capacity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HP (type: esriFieldTypeString, alias: HP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROTATION_1 (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SCREENINGS (type: esriFieldTypeString, alias: Screenings, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GENSET (type: esriFieldTypeString, alias: Genset, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• KW (type: esriFieldTypeDouble, alias: KW, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VOLT (type: esriFieldTypeString, alias: Volt, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FUEL (type: esriFieldTypeString, alias: Fuel, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TANK_SIZE_GAL (type: esriFieldTypeDouble, alias: Tank Size gal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TANK_SIZE_LBS (type: esriFieldTypeDouble, alias: Tank Size lbs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMPS (type: esriFieldTypeDouble, alias: AMPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ODOR_CONTROL (type: esriFieldTypeString, alias: Odor Control, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CHEMICALS (type: esriFieldTypeString, alias: Chemicals, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TANK_Q (type: esriFieldTypeDouble, alias: Tank Q (#), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TANKS (type: esriFieldTypeDouble, alias: Tanks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FM (type: esriFieldTypeString, alias: FM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DIA (type: esriFieldTypeString, alias: DIA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PERMITNUMBER_1 (type: esriFieldTypeString, alias: PERMITNUMBER111, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• POWER_CO (type: esriFieldTypeString, alias: Power Company, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ELEC_METER (type: esriFieldTypeString, alias: Electrical Meter, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ELEC_ACCT (type: esriFieldTypeString, alias: Electrical Account, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATER_METER_NO_1 (type: esriFieldTypeDouble, alias: Water Meter No# #1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATER_METER_NO_2 (type: esriFieldTypeDouble, alias: Water Meter No# #2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATER_METER_SIZE_1 (type: esriFieldTypeString, alias: Water Meter Size #1, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATER_METER_SIZE_2 (type: esriFieldTypeString, alias: Water Meter Size #2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BF_CONT_SERIAL (type: esriFieldTypeDouble, alias: BF Control Serial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PUMPOUT_FREQ (type: esriFieldTypeString, alias: Pumpout Frequency, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CCHAZARD (type: esriFieldTypeSmallInteger, alias: CCHAZARD, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: pump_stations_falls_lake
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ACTIVEFLAG: 1
• OWNEDBY: 0
• ANCILLARYROLE: 0
• ROTATION: 0
• MAINTBY: 0
• AUTOMATION: 1
• EMERGENCYPOWER: 1
• STRUCTTYPE:
• ELEVATEDFLOORSLAB: 0
• SOURCE:
• ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/1/2024 8:40:11 PM

Schema Last Edit Date: 3/1/2024 8:40:11 PM

Data Last Edit Date: 3/19/2019 7:38:26 PM

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