Layer: SewerForceMain (ID:315002)

View In: Map Viewer

Name: SewerForceMain

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Sewer Force Mains are pipes with a primary role lifting wastewater to a higher elevation. Types include Force Main and Unknown.

Copyright Text:

Min. Scale: 2311162.217155

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

","uniqueValueGroups":[{"heading":"Force Main Pressure Type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"values":[["0"]]},{"label":"High Pressure","description":"High Pressure","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"values":[["1"]]},{"label":"Low Pressure","description":"Low Pressure","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,230,0,255],"width":1},"values":[["2"]]},{"label":"Vacuum","description":"Vacuum","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,0,0,255],"width":1},"values":[["3"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,152,0,255],"width":1},"value":"1","label":"High Pressure"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,230,0,255],"width":1},"value":"2","label":"Low Pressure"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,0,0,255],"width":1},"value":"3","label":"Vacuum"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,212,255],"toColor":[252,212,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,179,255],"toColor":[252,179,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,194,255],"toColor":[252,194,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,187,255],"toColor":[252,187,187,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,202,202,255],"toColor":[252,202,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,204,255],"toColor":[252,204,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,182,255],"toColor":[252,182,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,197,255],"toColor":[252,197,197,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,192,255],"toColor":[252,192,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,204,255],"toColor":[252,204,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,189,255],"toColor":[252,189,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,207,255],"toColor":[252,207,207,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var slm = $feature.material;\nvar slmlbl = When(slm == 0, 'Unknown', slm == 1, 'Acrylonitrile Butadiene Styrene - ABS', slm == 2, 'Asbestos Cement - AC', slm == 3, 'Asphalt - ASP', slm == 4, 'Brick - BR', slm == 5, 'Cast Iron - CAS', slm == 6, 'Clay Tile - CT', slm == 7, 'Concrete Pipe (Non-Reinforced) - CP', slm == 8, 'Concrete Segments (Bolted) - CSB', slm == 9, 'Concrete Segments (Unbolted) - CSU', slm == 10, 'Cured in Place Pipe - CIPP', slm == 11, 'Ductile Iron Pipe - DIP', slm == 12, 'Fiberglass Reinforced Pipe - FRP', slm == 13, 'Galvanized Pipe - GP', slm == 14, 'Glass Reinforced Cement - GRC', slm == 15, 'High Density Polyethylene - HDPE', slm == 16, 'Other - OTH', slm == 17, 'Plastic/Steel Composite - PSC', slm == 18, 'Polyethylene - PE', slm == 19, 'Polypropylene - PP', slm == 20, 'Polyvinyle Chloride - PVC', slm == 21, 'Pre-Stressed Concrete Cylinder Pipe - PCCP', slm == 22, 'Reinforced Concrete Pipe - RCP', slm == 23, 'Reinforced Plastic Pipe (Truss Pipe) - RPM', slm == 24, 'Segmented Block - SB', slm == 25, 'Steel Pipe - SP', slm == 26, 'Vitrified Clay Pipe - VCP', slm == 27, 'Non-Lead Unknown', slm);\n\nvar sld = $feature.diameter;\nvar sldlbl = When(sld == '0', 'Unknown', sld == 0.5, '1/2\"', sld == 0.75, '3/4\"', sld == 1, '1\"', sld == 1.25, '1 1/4\"', sld == 1.5, '1 1/2\"', sld == 1.75, '1 3/4\"', sld == 2, '2\"', sld == 2.5, '2 1/2\"', sld == 3, '3\"', sld == 4, '4\"', sld == 5, '5\"', sld == 6, '6\"', sld == 8, '8\"', sld == 10, '10\"', sld == 12, '12\"', sld == 14, '14\"', sld == 15, '15\"', sld == 16, '16\"', sld == 18, '18\"', sld == 20, '20\"', sld == 21, '21\"', sld == 24, '24\"', sld == 27, '27\"', sld == 30, '30\"', sld == 36, '36\"', sld == 40, '40\"', sld == 42, '42\"', sld == 48, '48\"', sld == 54, '54\"', sld == 60, '60\"', sld == 66, '66\"', sld == 72, '72\"', sld == 75, '75\"', sld);\n\nvar retlbl = sldlbl + ' ' + slmlbl;\nreturn retlbl;"},"lineOrientation":"unconstrained","labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":2256.994353,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[255,170,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":2,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GLOBALID

Type ID Field: forcemainpressuretype

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [41: Force Main])
watertype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sewage], [2: Reclaimed], ... 3 more ...)
usetype (type: esriFieldTypeSmallInteger, alias: Use Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Force Main], [2: Gravity], ... 2 more ...)
forcemainpressuretype (type: esriFieldTypeSmallInteger, alias: Force Main Pressure Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High Pressure], [2: Low Pressure], ... 1 more ...)
pipelocation (type: esriFieldTypeSmallInteger, alias: Pipe Location, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Below Ground Buried], [2: Below Ground Vault], ... 6 more ...)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
inspectiondate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Acrylonitrile Butadiene Styrene - ABS], [2: Asbestos Cement - AC], [3: Asphalt - ASP], ... 25 more ...)
diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 31 more ...)
upelev (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
downelev (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
frommh (type: esriFieldTypeString, alias: From Manhole, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
tomh (type: esriFieldTypeString, alias: To Manhole, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
yearrehabilitated (type: esriFieldTypeDate, alias: Year Rehabilitated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
linertype (type: esriFieldTypeSmallInteger, alias: Liner Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
oqr (type: esriFieldTypeString, alias: PACP Overall Quick Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
opr (type: esriFieldTypeDouble, alias: PACP Overall Pipe Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
opri (type: esriFieldTypeDouble, alias: PACP Overall Pipe Rating Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
sqr (type: esriFieldTypeString, alias: PACP Structural Quick Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
spr (type: esriFieldTypeDouble, alias: PACP Structural Pipe Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
spri (type: esriFieldTypeDouble, alias: PACP Structural Pipe Rating Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
omqr (type: esriFieldTypeString, alias: PACP Operation Maintenance Quick Rating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ompr (type: esriFieldTypeDouble, alias: PACP Operation Maintenance Pipe Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
ompri (type: esriFieldTypeDouble, alias: PACP Operation Maintenance Pipe Rating Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
mainshape (type: esriFieldTypeSmallInteger, alias: Main Shape, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Circular], [2: Horseshoe], ... 4 more ...)
height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
width (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 15 more ...)
ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Sarasota County], [2: Private], [7: Bee Ridge Utility], ... 11 more ...)
maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Utilities], [2: Private], [3: Facilities], ... 15 more ...)
spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 10 more ...)
spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Survey-Grade], [2: Sub-Foot], ... 1 more ...)
recordnumber (type: esriFieldTypeString, alias: Record Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
recordsheetnumber (type: esriFieldTypeString, alias: Record Sheet Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
hyperlink (type: esriFieldTypeString, alias: Hyperlink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
referencedoc (type: esriFieldTypeString, alias: Reference Document, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tracerwire (type: esriFieldTypeSmallInteger, alias: Tracer Wire, SQL Type: sqlTypeOther, nullable: true, editable: true)
cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True], [2: Unknown])
FROMDEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: From device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 23 more ...)
TODEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: To device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 23 more ...)
SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
FLOWDIRECTION (type: esriFieldTypeSmallInteger, alias: Flow direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With digitized], [2: Against digitized], [3: Indeterminate])
systemsubnetworkname (type: esriFieldTypeString, alias: System Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
regionsubnetworkname (type: esriFieldTypeString, alias: Region Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
sewershedsubnetworkname (type: esriFieldTypeString, alias: Sewershed Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
cpsubnetworkname (type: esriFieldTypeString, alias: cpsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: false, Coded Values: [0: No calculation required, no validation required, no error], [1: No calculation required, no validation required, has error(s)], [2: No calculation required, validation required, no error], ... 5 more ...)
lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: ASSETTYPE
Inherited
Field Name: watertype
Inherited
Field Name: usetype
Inherited
Field Name: forcemainpressuretype
Inherited
Field Name: pipelocation
Inherited
Field Name: material
Inherited
Field Name: diameter
Inherited
Field Name: mainshape
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited
Field Name: bondedinsulated
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: FLOWDIRECTION
Inherited
Field Name: VALIDATIONSTATUS
Inherited

FROMDEVICETERMINAL: 0
FLOWDIRECTION: 1
ASSETGROUP: 2
ASSETTYPE: 0
forcemainpressuretype: 0
lifecyclestatus: 0
TODEVICETERMINAL: 0

Field Name: ASSETTYPE
Inherited
Field Name: watertype
Inherited
Field Name: usetype
Inherited
Field Name: forcemainpressuretype
Inherited
Field Name: pipelocation
Inherited
Field Name: material
Inherited
Field Name: diameter
Inherited
Field Name: mainshape
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited
Field Name: bondedinsulated
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: FLOWDIRECTION
Inherited
Field Name: VALIDATIONSTATUS
Inherited

FROMDEVICETERMINAL: 0
FLOWDIRECTION: 1
ASSETGROUP: 2
ASSETTYPE: 0
forcemainpressuretype: 1
lifecyclestatus: 0
TODEVICETERMINAL: 0

Field Name: ASSETTYPE
Inherited
Field Name: watertype
Inherited
Field Name: usetype
Inherited
Field Name: forcemainpressuretype
Inherited
Field Name: pipelocation
Inherited
Field Name: material
Inherited
Field Name: diameter
Inherited
Field Name: mainshape
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited
Field Name: bondedinsulated
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: FLOWDIRECTION
Inherited
Field Name: VALIDATIONSTATUS
Inherited

FROMDEVICETERMINAL: 0
FLOWDIRECTION: 1
ASSETGROUP: 2
ASSETTYPE: 0
forcemainpressuretype: 2
lifecyclestatus: 0
TODEVICETERMINAL: 0

Field Name: ASSETTYPE
Inherited
Field Name: watertype
Inherited
Field Name: usetype
Inherited
Field Name: forcemainpressuretype
Inherited
Field Name: pipelocation
Inherited
Field Name: material
Inherited
Field Name: diameter
Inherited
Field Name: mainshape
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: cptraceability
Inherited
Field Name: cpoverride
Inherited
Field Name: bondedinsulated
Inherited
Field Name: ASSOCIATIONSTATUS
Inherited
Field Name: ISCONNECTED
Inherited
Field Name: FROMDEVICETERMINAL
Inherited
Field Name: TODEVICETERMINAL
Inherited
Field Name: FLOWDIRECTION
Inherited
Field Name: VALIDATIONSTATUS
Inherited

FROMDEVICETERMINAL: 0
FLOWDIRECTION: 1
ASSETGROUP: 2
ASSETTYPE: 0
forcemainpressuretype: 3
lifecyclestatus: 0
TODEVICETERMINAL: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/17/2026 10:02:18 PM

Schema Last Edit Date: 1/17/2026 10:02:18 PM

Data Last Edit Date: 1/17/2026 10:01:03 PM

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