Layer: Sewer Clean Out (ID:1)

View In: Map Viewer

Name: Sewer Clean Out

Display Field: CLEAN_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

The CleanOut layer contains GIS information cleanouts for sanitary sewers within the service area of the City of Puyallup.

Copyright Text: CoP Public Works, CoP GIS

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:

","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,197,255,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[78,78,78,255],"width":0.7}},"value":"12","label":"Lateral"},{"symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[0,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}},"value":"13","label":"Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,241,252,255],"toColor":[192,241,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,245,255],"toColor":[252,179,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,245,182,255],"toColor":[252,245,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,188,179,255],"toColor":[252,188,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,189,252,255],"toColor":[182,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,192,255],"toColor":[182,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,239,255],"toColor":[252,212,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,229,202,255],"toColor":[252,229,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,252,226,255],"toColor":[215,252,226,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,216,252,255],"toColor":[210,216,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,203,255],"toColor":[252,182,203,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,252,184,255],"toColor":[223,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[235,197,252,255],"toColor":[235,197,252,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:

Global ID Field: GlobalID

Type ID Field: CLEAN_TYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CLEAN_ID (type: esriFieldTypeString, alias: Puyallup_ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
CLEAN_DIAMETER (type: esriFieldTypeSmallInteger, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEAN_ADD_STR (type: esriFieldTypeString, alias: Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CLEAN_SUBDIVISION (type: esriFieldTypeString, alias: Subdivision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CLEAN_NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CLEAN_BASIN (type: esriFieldTypeInteger, alias: Sewer_Basin, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEAN_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEAN_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEAN_TYPE (type: esriFieldTypeSmallInteger, alias: Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: Lateral], [13: Main])
CLEAN_MAT (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: Asbestos Concrete], [13: Cast Iron], [15: Concrete], ... 4 more ...)
CLEAN_JURISDICTION (type: esriFieldTypeSmallInteger, alias: Jurisdiction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Commercial], [10: CoP Parks], [15: CoP PW], ... 2 more ...)
CLEAN_SURF (type: esriFieldTypeSmallInteger, alias: Surface Cover, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: Asphalt], [10: Concrete], [15: Dense Vegetation], ... 8 more ...)
CLEAN_YEAR (type: esriFieldTypeSmallInteger, alias: YEAR_INSTALLED, SQL Type: sqlTypeOther, nullable: true, editable: true)
CLEAN_PLACEMENT (type: esriFieldTypeSmallInteger, alias: Flushing Structure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6: Flushing Structure], [99: Other], [9: In Line], ... 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)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
CLEAN_ADD_NUM (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

Field Name: CLEAN_TYPE
Inherited
Field Name: CLEAN_MAT
Inherited
Field Name: CLEAN_JURISDICTION
Inherited
Field Name: CLEAN_SURF
Inherited
Field Name: CLEAN_PLACEMENT
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited

CLEAN_TYPE: 12

Field Name: CLEAN_TYPE
Inherited
Field Name: CLEAN_MAT
Inherited
Field Name: CLEAN_JURISDICTION
Inherited
Field Name: CLEAN_SURF
Inherited
Field Name: CLEAN_PLACEMENT
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited

CLEAN_TYPE: 13

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/22/2025 4:41:41 PM

Schema Last Edit Date: 5/22/2025 4:41:41 PM

Data Last Edit Date: 5/22/2025 4:41:41 PM

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