Layer: Sewer Mains (ID:1)

View In: Map Viewer

Name: Sewer Mains

Display Field: S_MAIN_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This feature represents sewer mains for customer residential or commercial. Based on the ESRI Local Government Information Model, modified as seen fit to meet our needs and the needs of our clients in order to store, manage, and display geographic data. Data is 1.) Collected (through line markers) using mapping-grade GPS receivers using SBAS corrections, and/or 2.) Digitized based on best available references.

Copyright Text: RCAP Solutions, 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":"uniqueValue","field1":"TYPE","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2.5},"value":"Gravity","label":"Gravity"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[132,0,168,255],"width":2.5},"value":"Pressurized","label":"Pressurized"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,201,255],"toColor":[192,252,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[237,182,252,255],"toColor":[237,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,179,255],"toColor":[252,199,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,224,252,255],"toColor":[187,224,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,244,179,255],"toColor":[252,244,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,239,255],"toColor":[252,215,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,188,252,255],"toColor":[179,188,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,237,255],"toColor":[199,252,237,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,235,215,255],"toColor":[252,235,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,217,255],"toColor":[252,179,217,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[235,252,210,255],"toColor":[235,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,202,252,255],"toColor":[223,202,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[221,252,182,255],"toColor":[221,252,182,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"(DomainName($feature, 'SIZE')) + '-' + $feature.MATERIAL","title":"Water_Main_Label_UPDATED2"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[76,230,0,255],"haloSize":0.75,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: TYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
S_MAIN_ID (type: esriFieldTypeString, alias: Sewer Main ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TYPE (type: esriFieldTypeString, alias: Pressurized or Gravity?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Gravity: Gravity], [Pressurized: Pressurized])
INSTALLYEAR (type: esriFieldTypeDate, alias: Install Date (Year), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [BR: Brick], ... 21 more ...)
TRACERWIRE (type: esriFieldTypeString, alias: Tracer Wire?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SIZE (type: esriFieldTypeDouble, alias: Size - Diameter of Pipe (inches), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1.5: 1.5"], [3: 3"], [4: 4"], ... 6 more ...)
FROMMH (type: esriFieldTypeString, alias: From Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
TOMH (type: esriFieldTypeString, alias: To Manhole, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
SURFTYP (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 ...)
SURFLOC (type: esriFieldTypeString, alias: Surface Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Alley: Alley], [Driveway: Driveway], [Easement / Right of Way: Easement / Right of Way], ... 10 more ...)
BREAKS_ON_MAIN (type: esriFieldTypeSmallInteger, alias: Number of Breaks, SQL Type: sqlTypeOther, nullable: true, editable: true)
LINEDYEAR (type: esriFieldTypeSmallInteger, alias: Year Lined, SQL Type: sqlTypeOther, nullable: true, editable: true)
LINERTYPE (type: esriFieldTypeString, alias: Liner Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [CP: Cured in Place], [FF: Fold and Form or Deform/Reform], [SN: Segmented Panel], ... 4 more ...)
SUMFLOW (type: esriFieldTypeDouble, alias: Flow Summary, SQL Type: sqlTypeOther, nullable: true, editable: true)
INSPECTED (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
MAINTEN_REQ (type: esriFieldTypeString, alias: Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
DOWNELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
UPELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
LAST_JETTING_DATE (type: esriFieldTypeDate, alias: Last Jetting Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
JETTING (type: esriFieldTypeString, alias: Reason for Jetting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Pre Cleaning / Video: Pre Cleaning / Video], [Maintenance: Maintenance], [General Service / Annual Cleaning: General Service / Annual Cleaning], ... 2 more ...)
JETTING_NOTES (type: esriFieldTypeString, alias: Jetting Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TELEVISED (type: esriFieldTypeString, alias: Televised, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
SL_RAT_RATING (type: esriFieldTypeString, alias: SL-RAT Rating, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: 0], [1: 1], [2: 2], ... 8 more ...)
RAT_SEG_ID (type: esriFieldTypeString, alias: SL-RAT Segment Pipe Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
RAT_INSPECT_DATE (type: esriFieldTypeDate, alias: SL-RAT Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DATE_ASSESSED (type: esriFieldTypeDate, alias: Date Assessed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LENGTH (type: esriFieldTypeSingle, alias: Engineer Recorded Length, SQL Type: sqlTypeOther, 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)
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: [1: Less than 4" = 1], [2: 4" = 2], [3: 6" = 3], ... 4 more ...)
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_PIPE_LOCATION (type: esriFieldTypeString, alias: CF Pipe Location, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure (Calculated Score), 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_MAINTENANCE_HISTORY (type: esriFieldTypeString, alias: PF Maintenance History, SQL Type: sqlTypeOther, length: 50, 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_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 Related Comments, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
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 ...)
SW_SHED_ID (type: esriFieldTypeString, alias: SW Shed ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SW_SUB_SHED_ID (type: esriFieldTypeString, alias: SW Sub Shed ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
SW_MICRO_SHED_ID (type: esriFieldTypeString, alias: SW Micro Shed ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
AGE_RANGE (type: esriFieldTypeString, alias: Age Range, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 2010-Present], [2: 2009-1980], [3: 1979-1950], ... 2 more ...)
CREATOR (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
CREATEDATE (type: esriFieldTypeDate, alias: Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
MODIFYUSER (type: esriFieldTypeString, alias: Modify User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
MODIFYDATE (type: esriFieldTypeDate, alias: Modify Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water], ... 4 more ...)
INSTALLDATE_YEAR_INTEGER (type: esriFieldTypeSmallInteger, alias: Install Date Year Integer, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: TYPE
Inherited
Field Name: MATERIAL
Inherited
Field Name: SIZE
Inherited
Field Name: SURFTYP
Inherited
Field Name: SURFLOC
Inherited
Field Name: LINERTYPE
Inherited
Field Name: INSPECTED
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: JETTING
Inherited
Field Name: TELEVISED
Inherited
Field Name: SL_RAT_RATING
Inherited
Field Name: CF_ASSET_SIZE
Inherited
Field Name: CF_OVERALL_CUST_IMPACT
Inherited
Field Name: CF_SIGNIF_IMPORTANT_CUST
Inherited
Field Name: CF_MAINTENANCE_ACCESSIBILITY
Inherited
Field Name: PF_ASSET_STATUS
Inherited
Field Name: PF_MAINTENANCE_HISTORY
Inherited
Field Name: PF_CONDITION
Inherited
Field Name: PF_CAPACITY
Inherited
Field Name: AGE_RANGE
Inherited
Field Name: WATERTYPE
Inherited

SURFTYP: Asphalt
INSPECTED: No
PF_ASSET_STATUS: 1
PF_MAINTENANCE_HISTORY: 0
TYPE: Gravity
MATERIAL: PVC
SIZE: 8
SURFLOC: Street / Road
LINERTYPE: NONE
MAINTEN_REQ: No
TELEVISED: No
PF_CONDITION: 0
PF_CAPACITY: 2

Field Name: TYPE
Inherited
Field Name: MATERIAL
Inherited
Field Name: SIZE
Inherited
Field Name: SURFTYP
Inherited
Field Name: SURFLOC
Inherited
Field Name: LINERTYPE
Inherited
Field Name: INSPECTED
Inherited
Field Name: MAINTEN_REQ
Inherited
Field Name: JETTING
Inherited
Field Name: TELEVISED
Inherited
Field Name: SL_RAT_RATING
Inherited
Field Name: CF_ASSET_SIZE
Inherited
Field Name: CF_OVERALL_CUST_IMPACT
Inherited
Field Name: CF_SIGNIF_IMPORTANT_CUST
Inherited
Field Name: CF_MAINTENANCE_ACCESSIBILITY
Inherited
Field Name: PF_ASSET_STATUS
Inherited
Field Name: PF_MAINTENANCE_HISTORY
Inherited
Field Name: PF_CONDITION
Inherited
Field Name: PF_CAPACITY
Inherited
Field Name: AGE_RANGE
Inherited
Field Name: WATERTYPE
Inherited

SURFTYP: Asphalt
INSPECTED: No
PF_ASSET_STATUS: 1
PF_MAINTENANCE_HISTORY: 0
TYPE: Pressurized
MATERIAL: PVC
SIZE: 8
SURFLOC: Street / Road
LINERTYPE: NONE
MAINTEN_REQ: No
TELEVISED: No
PF_CONDITION: 0
PF_CAPACITY: 2

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/28/2023 3:18:20 PM

Schema Last Edit Date: 8/22/2023 12:43:50 PM

Data Last Edit Date: 8/28/2023 3:18:20 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