Layer: Sewer Cleanouts (ID:7)

View In: Map Viewer

Name: Sewer Cleanouts

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The location of grinder pumps in public wastewater systems. A grinder pump is a mechanical device that is used for the pressurized conveyance of wastewater from a residential, commercial, industrial, or property to a wastewater collection system. Grinder pumps are used when the source is not sufficient for gravity flow. These data specifically include, but are not limited to, “small systems” or systems with a directly serviceable population of 10,000 or less as collected by RCAP Solutions.

Copyright Text: RCAP Solutions, Geographic Information Services, ESRI Local Government Information Model

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"dcef9ae900f953793ad683ab7cafca04","imageData":"iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAA7EAAAOxAGVKw4bAAACz0lEQVRIic1VMWhTURQ9r0k6FLSNrdgGQSGQIZgKpkMy2tBOdSvWTXCoHcVBUIckghU66Fo7CN1U3NIpmqxxaAI2UiHYEkGSwcSoAYcY8uS8/PeTn5+WRBG88PPJ57177rv3nPOc+Mfh/C8AcjLpccARFBAzAtLDbxIiMSvms38FsCfTQQEZA8RS56vQv9G8TPO91UAzfkksloYCyMtUDEBUJ9zdz6D2o6oeRtAfhvesDxJYdcG5mpepeEBEYgMB5GUqoat+/XZHPQefC5Y1L5LbcJ+cxMridSyEuFRE38v0zAUxf/NYgHblYokJXya3VeXi5wk4SgH1xq9RwNWAHKvjm6eIzVePVQEbtzbVafIyVe4+ibO35+22wEw+VQvjlPM8cMZ+0sMPk2hNlXCAAh49u4+7Nx6qk+zJtEkAC4AxUFURkzs+BuD1B3Bn/VrfOa1cfoCRiiIVdpFR+9guATwFMGcBIBW7+852iO+TGCQIIk+X1Vza80DQ1iLyXFWyn1EDZc+HiZFPPtTGsmov2fVOpq5cFJGECUAR8a1pqAY6ROj1hwaAztcFQIUKE0Cx5Q/CLNBQ/NFKdjWGAnFPj+JLn+8mAL2F8qdCOSzynEPOZgpYW36i1pBNuUwBbxI5W6Jqs6je3K/zWQDIW3oL+0eFUkQOg0W1ar3Tgkrd8l/HhLcB97RP7Wc00SxbABg0LqqR8qdCKSLN8+OC6742i7gaum3m0eZnAaAr0rjIZeU/aPuPBtm499xWPZO3zhUw5w9rDaAFbNlmwCAqXZFyp7dQ/lQoRaR4Xu0QoDVegZyoQo5XVfK15Xb1gIzPioh5T9hYRKOiK7JV9BaehEOniHqD/V4IaTdVyXd6LbsvTWm5dEWehJv5UKEUUe990Ak5+H2gT0JXNIwryGTWhO3gQNnz7rYMBMAwLFe5Ir2l904mFY+6KgcC6A4a16Bru+M3OFFRJg/nw1AAAAAASUVORK5CYII=","contentType":"image/png","width":18,"height":18,"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:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FACILITYID (type: esriFieldTypeString, alias: Cleanout ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TYPE (type: esriFieldTypeString, alias: Cleanout Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Double Clean Out: Double Clean Out], [Single Clean Out: Single Clean Out], [Test Tee: Test Tee], ... 2 more ...)
ACTIVE (type: esriFieldTypeString, alias: Active or Inactive?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive])
STREET_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREET_NO (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Center_Front Yard: Near Center of Front Yard], [Right_Front Yard: Right Side of Front Yard], [Left_Front Yard: Left Side of Front Yard], ... 7 more ...)
SURFACE_TYPE (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Concrete: Concrete], [Grass/Dirt: Grass/Dirt], ... 6 more ...)
INSTALLYEAR (type: esriFieldTypeSmallInteger, alias: Install, SQL Type: sqlTypeOther, nullable: true, editable: true)
CUSTOMER_TYPE (type: esriFieldTypeString, alias: Customer Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Residential: Residential], [Commercial: Commercial], [Industrial: Industrial], ... 1 more ...)
CUSTOMER (type: esriFieldTypeString, alias: Customer Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ACCESSIBILITY (type: esriFieldTypeString, alias: Accessibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Buried: Buried], [Exposed: Exposed], [Unknown: Unknown])
ACCESSTYPE (type: esriFieldTypeString, alias: Access Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Door: Door], [Grate: Grate], [Cover: Cover], ... 8 more ...)
ACCESSMAT (type: esriFieldTypeString, alias: Access Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [BR: Brick], ... 21 more ...)
SIZE (type: esriFieldTypeDouble, alias: Access Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1.5: 1 1/2"], [2: 2"], [2.5: 2.5"], ... 3 more ...)
FLOWDIR (type: esriFieldTypeString, alias: Flow Direction, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [E: East], [N: North], [S: South], ... 6 more ...)
INTDEPTH (type: esriFieldTypeDouble, alias: Interior Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [BR: Brick], ... 21 more ...)
INSPECTED (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
MAINTEN_REQ (type: esriFieldTypeString, alias: Maintenance Request, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DATE_ASSESSED (type: esriFieldTypeDate, alias: Date Assessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
EXPECTED_USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Expected Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REMAINING_USEFUL_LIFE (type: esriFieldTypeSingle, alias: Remaining Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENT_COST (type: esriFieldTypeSingle, alias: Replacement Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNIT_COST (type: esriFieldTypeSingle, alias: Unit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
COF (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
CF_ASSET_SIZE (type: esriFieldTypeString, alias: CF Asset Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: )
CF_OVERALL_CUST_IMPACT (type: esriFieldTypeString, alias: CF Overall Customer Impact, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 10% = 1], [2: 10-30% = 2], [3: 30-50% = 3], ... 4 more ...)
CF_SIGNIF_IMPORTANT_CUST (type: esriFieldTypeString, alias: CF Critical Customers, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Residential Only = 1], [2: School / Church = 2], [3: Downtown Businesses = 3], ... 4 more ...)
CF_MAINTENANCE_ACCESSIBILITY (type: esriFieldTypeString, alias: CF Maintenance Accessibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Right of Way - no traffic control = 1], [2: Right of Way - with traffic control = 2], [3: Public lands with vehicle access = 3], ... 4 more ...)
CF_DEPTH (type: esriFieldTypeString, alias: CF Depth, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Less than 6ft = 1], [2: 6 to 10ft = 2], [3: 10 to 14ft = 3], ... 4 more ...)
CF_PROX_ENVIRO_SENS (type: esriFieldTypeString, alias: CF Proximity to Sensitive Environment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 150 LF or more = 1], [2: 100-150 LF = 2], [3: 75-100 LF = 3], ... 4 more ...)
POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
PF_ASSET_STATUS (type: esriFieldTypeString, alias: PF Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Fully Functional = 1], [2: Operates with difficulty = 2], [3: Operates but unreliable = 3], ... 4 more ...)
PF_CONDITION (type: esriFieldTypeString, alias: PF Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excellent / Very good = 1], [2: Good = 2], [3: Fair / Operable = 3], ... 4 more ...)
CONDITION_COMMENTS (type: esriFieldTypeString, alias: Condition Comments, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
PF_MAINTENANCE_HISTORY (type: esriFieldTypeString, alias: PF Maintenance History, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [1: Recommended best practices regularly followed = 1], [2: Assets are adequately maintained = 2], [3: No maintenance history = 3], ... 4 more ...)
PF_CAPACITY (type: esriFieldTypeString, alias: PF Capacity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excess capacity = 1], [2: Limited capacity concerns = 2], [3: Moderate concerns / Limited Fire Flow / Sewer Surcharges = 3], ... 4 more ...)
AGE_RANGE (type: esriFieldTypeString, alias: Age Range (how old), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 2010-Present], [2: 2009-1980], [3: 1979-1950], ... 2 more ...)
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_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_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
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_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: PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: VDOP, 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: Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading (°), 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)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CREATEDATE (type: esriFieldTypeDate, alias: CREATEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
MODIFYUSER (type: esriFieldTypeString, alias: MODIFYUSER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
MODIFYDATE (type: esriFieldTypeDate, alias: MODIFYDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

TYPE: Double Clean Out
ACTIVE: Active
CUSTOMER_TYPE: Residential
ACCESSIBILITY: Exposed
ACCESSTYPE: Cover
INSPECTED: No
MAINTEN_REQ: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/22/2023 12:41:26 PM

Schema Last Edit Date: 8/22/2023 12:41:26 PM

Data Last Edit Date: 8/22/2023 12:41:26 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