Layers:

Layer: SewerGravityMain (315001)


Name: SewerGravityMain

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Sewer Gravity Mains are pipes that use gravity to collect and transport wastewater. Types include Collector Gravity Main and Interceptor Gravity Main.

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:

XMin: 471417.130332578
YMin: 977040.387166575
XMax: 558044.601762328
YMax: 1110897.47148599
Spatial Reference: 2882 (2882)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"Other","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"values":[["0"]]},{"label":"Collector Gravity Main","description":"Collector Gravity Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2},"values":[["1"]]},{"label":"Interceptor Gravity Main","description":"Interceptor Gravity Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[38,115,0,255],"width":2},"values":[["2"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2},"value":"1","label":"Collector Gravity Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[38,115,0,255],"width":2},"value":"2","label":"Interceptor Gravity Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,182,255],"toColor":[252,182,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,197,255],"toColor":[252,197,197,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]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,194,255],"toColor":[252,194,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,210,255],"toColor":[252,210,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,199,255],"toColor":[252,199,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,204,255],"toColor":[252,204,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,192,255],"toColor":[252,192,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,179,255],"toColor":[252,179,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,184,255],"toColor":[252,184,184,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;\n"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"ASSETTYPE = 1","useCodedValues":false,"maxScale":0,"minScale":2256.994353,"name":"Collector","priority":-1,"symbol":{"type":"esriTS","color":[76,230,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":9,"style":"normal","weight":"bold","decoration":"none"}}},{"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;\n","title":"Custom"},"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,"where":"ASSETTYPE = 2","useCodedValues":true,"maxScale":0,"minScale":2400,"name":"Interceptor","priority":-1,"symbol":{"type":"esriTS","color":[76,115,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:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GLOBALID

Type ID Field: ASSETTYPE

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], [1: Collector Gravity Main], [2: Interceptor Gravity 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)
• 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, Coded Values: [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], [3: Formed-In-Place Liner - FP], ... 11 more ...)
• 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)
• 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)
• 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)
• FLOWDIRECTION (type: esriFieldTypeSmallInteger, alias: Flow direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With digitized], [2: Against digitized], [3: Indeterminate])
• 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:

ID: 0
Name: Unknown
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 1
• FLOWDIRECTION: 1
• FROMDEVICETERMINAL: 0
• material: 0
• designtype: 0
• lifecyclestatus: 8
• ownedby: 1
• maintby: 1
• spatialsource: 0
• TODEVICETERMINAL: 0
• tracerwire: 0
• ASSETTYPE: 0
• diameter: 0
• linertype: 0
• spatialconfidence: 0

---

ID: 1
Name: Collector Gravity Main
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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
  
Templates:

Name: Collector Gravity Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 1
• FLOWDIRECTION: 1
• FROMDEVICETERMINAL: 0
• material: 0
• designtype: 0
• lifecyclestatus: 8
• ownedby: 1
• maintby: 1
• spatialsource: 0
• TODEVICETERMINAL: 0
• tracerwire: 0
• ASSETTYPE: 1
• diameter: 0
• linertype: 0
• spatialconfidence: 0

---

ID: 2
Name: Interceptor Gravity Main
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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
  
Templates:

Name: Interceptor Gravity Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 1
• FLOWDIRECTION: 1
• FROMDEVICETERMINAL: 0
• material: 0
• designtype: 0
• lifecyclestatus: 8
• ownedby: 1
• maintby: 1
• spatialsource: 0
• TODEVICETERMINAL: 0
• tracerwire: 0
• ASSETTYPE: 2
• diameter: 0
• linertype: 0
• spatialconfidence: 0

---


Relationships:
• Get As Built (0) -- Related To: UtilityAsBuiltTable (315004)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/25/2026 8:14:40 PM

Schema Last Edit Date: 4/25/2026 8:14:40 PM

Data Last Edit Date: 4/25/2026 8:13:11 PM

Layer: SewerForceMain (315002)


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:

XMin: 472576.36456266
YMin: 977609.371264823
XMax: 575064.276056245
YMax: 1110905.91044549
Spatial Reference: 2882 (2882)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"forcemainpressuretype","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"","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,182,182,255],"toColor":[252,182,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,197,197,255],"toColor":[252,197,197,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]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,194,255],"toColor":[252,194,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,210,210,255],"toColor":[252,210,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,215,255],"toColor":[252,215,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,199,255],"toColor":[252,199,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,204,255],"toColor":[252,204,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,192,255],"toColor":[252,192,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,179,255],"toColor":[252,179,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,184,255],"toColor":[252,184,184,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:

Name : OBJECTID

IsSystemMaintained : True


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)
• 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:

ID: 0
Name: Unknown
Domains:

• 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
  
Templates:

Name: 0
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 1
Name: High Pressure
Domains:

• 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
  
Templates:

Name: 1
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 2
Name: Low Pressure
Domains:

• 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
  
Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 3
Name: Vacuum
Domains:

• 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
  
Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---


Relationships:
• Get As Built (1) -- Related To: UtilityAsBuiltTable (315004)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/25/2026 8:14:40 PM

Schema Last Edit Date: 4/25/2026 8:14:40 PM

Data Last Edit Date: 4/25/2026 8:13:22 PM

Layer: SewerLateral (315003)


Name: SewerLateral

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The Lateral asset group layer in the Sewer Line feature class represents service lines that move wastewater from the customer to the main, or add and relieve pressure through air lines. Types include Commercial, Industrial, Residential, Air Intake, and Air Release.

Copyright Text:

Min. Scale: 9027.977411

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 471414.275351413
YMin: 977045.892732993
XMax: 558352.842287578
YMax: 1110890.0577869
Spatial Reference: 2882 (2882)


Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1},"defaultLabel":"","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"values":[["0"]]},{"label":"Commercial","description":"Commercial","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"values":[["121"]]},{"label":"Industrial","description":"Industrial","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"values":[["122"]]},{"label":"Residential","description":"Residential","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"values":[["123"]]},{"label":"Air Release","description":"Air Release","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"values":[["124"]]},{"label":"Air Intake","description":"Air Intake","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[78,78,78,255],"width":1},"values":[["125"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"value":"121","label":"Commercial"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"value":"122","label":"Industrial"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":1},"value":"123","label":"Residential"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"value":"124","label":"Air Release"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[78,78,78,255],"width":1},"value":"125","label":"Air Intake"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,242,255],"toColor":[252,182,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[200,252,189,255],"toColor":[200,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,232,252,255],"toColor":[184,232,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,199,179,255],"toColor":[252,199,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,183,252,255],"toColor":[179,183,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,248,199,255],"toColor":[252,248,199,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[228,215,252,255],"toColor":[228,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,252,232,255],"toColor":[199,252,232,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,207,255],"toColor":[252,184,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,232,212,255],"toColor":[252,232,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,221,255],"toColor":[252,215,221,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,240,255],"toColor":[252,207,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,202,252,255],"toColor":[179,202,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var slm = $feature.material;\nvar slmlbl = When(slm == 0, 'Unknown', slm == 7, 'ABS Plastic - ABS', slm == 8, 'Cast Iron - CAS', slm == 9, 'Copper - COP', slm == 10, 'Concrete - CP', slm == 11, 'Ductile Iron Pipe - DIP', slm == 12, 'Galvanized Pipe - GP', slm == 13, 'Polyethylene - PE', slm == 14, 'Polypropylene - PP', slm == 15, 'Polyvinyle Chloride - PVC', slm == 16, 'Steel - SP', slm == 17, 'Vitrified Clay Pipe - VCP', slm == 18, 'High Density Polyethylene - HDPE', slm == 19, 'Clay Tile - CT', slm == 20, '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 == 24, '24\"', sld);\n\nvar retlbl = sldlbl + ' ' + slmlbl;\nreturn retlbl;","title":"Custom"},"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":282.124294,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[56,168,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":1,"font":{"family":"Tahoma","size":8,"style":"normal","weight":"normal","decoration":"none"}}}]}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GLOBALID

Type ID Field: ASSETTYPE

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
• 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], [121: Commercial], [122: Industrial], ... 3 more ...)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: true, 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 ...)
• cpsubnetworkname (type: esriFieldTypeString, alias: cpsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• systemsubnetworkname (type: esriFieldTypeString, alias: systemsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• regionsubnetworkname (type: esriFieldTypeString, alias: regionsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• sewershedsubnetworkname (type: esriFieldTypeString, alias: sewershedsubnetworkname, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• FLOWDIRECTION (type: esriFieldTypeSmallInteger, alias: Flow direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With digitized], [2: Against digitized], [3: Indeterminate])
• diameter (type: esriFieldTypeDouble, alias: Size/Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 19 more ...)
• linertype (type: esriFieldTypeSmallInteger, alias: Liner Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Cured-In-Place Pipe - CIP], [2: Fold and Form or Deform/Reform - FF], ... 11 more ...)
• 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)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 15 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• 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 ...)
• tracerwire (type: esriFieldTypeSmallInteger, alias: Tracer Wire, SQL Type: sqlTypeOther, nullable: true, editable: true)
• measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• 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 ...)
• 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])
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [7: ABS Plastic - ABS], [8: Cast Iron - CAS], [19: Clay Tile - CT], ... 12 more ...)
• bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
• mainshape (type: esriFieldTypeSmallInteger, alias: Main Shape, SQL Type: sqlTypeOther, nullable: true, editable: true)
• watertype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Sewage], [2: Reclaimed], ... 3 more ...)
• 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)
• inspectiondate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• yearrehabilitated (type: esriFieldTypeDate, alias: Year Rehabilitated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• 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)
• 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 ...)
• referencedoc (type: esriFieldTypeString, alias: Reference Document, SQL Type: sqlTypeOther, length: 255, 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)
• height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• width (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true, 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: true)
• 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:

ID: 0
Name: Unknown
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 0
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---

ID: 121
Name: Commercial
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Commercial
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 121
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---

ID: 122
Name: Industrial
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Industrial
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 122
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---

ID: 123
Name: Residential
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Residential
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 123
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---

ID: 124
Name: Air Release
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Air Release
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 124
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---

ID: 125
Name: Air Intake
Domains:

• Field Name: ASSETTYPE
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: FLOWDIRECTION
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: linertype
  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: material
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: watertype
  Inherited
  
• Field Name: pipelocation
  Inherited
  
• Field Name: usetype
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: Air Intake
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ASSETGROUP: 3
• ASSETTYPE: 125
• ASSOCIATIONSTATUS: 0
• ISCONNECTED: 2
• FROMDEVICETERMINAL: 0
• TODEVICETERMINAL: 0
• cpsubnetworkname: Unknown
• SUPPORTEDSUBNETWORKNAME: Unknown
• SUPPORTINGSUBNETWORKNAME: Unknown
• systemsubnetworkname: Unknown
• regionsubnetworkname: Unknown
• sewershedsubnetworkname: Unknown
• FLOWDIRECTION: 1
• lifecyclestatus: 8
• VALIDATIONSTATUS: 6

---


Relationships:
• Get As Built (2) -- Related To: UtilityAsBuiltTable (315004)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/25/2026 8:14:40 PM

Schema Last Edit Date: 4/25/2026 8:14:40 PM

Data Last Edit Date: 4/25/2026 8:14:00 PM

Tables:

UtilityAsBuiltTable (315004)


Name: UtilityAsBuiltTable

Display Field: ProjectName

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• ABIS_ID (type: esriFieldTypeInteger, alias: ABIS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ABIS_NUMBER (type: esriFieldTypeString, alias: ABIS_NUMBER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ProjectName (type: esriFieldTypeString, alias: ProjectName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LowestHalf (type: esriFieldTypeString, alias: LowestHalf, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AllHalf (type: esriFieldTypeString, alias: AllHalf, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HalfTownships (type: esriFieldTypeString, alias: HalfTownships, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PermitNumber (type: esriFieldTypeString, alias: PermitNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ABISDate (type: esriFieldTypeDate, alias: ABIS Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WaterSupplierID (type: esriFieldTypeInteger, alias: WaterSupplierID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SewerSupplierID (type: esriFieldTypeInteger, alias: SewerSupplierID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SubdivisionBusiness (type: esriFieldTypeString, alias: SubdivisionBusiness, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SectionTownship (type: esriFieldTypeString, alias: SectionTownship, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EOR (type: esriFieldTypeString, alias: EOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Pages (type: esriFieldTypeString, alias: Pages, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• FranchiseID (type: esriFieldTypeInteger, alias: FranchiseID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Created (type: esriFieldTypeDate, alias: Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMPLETED (type: esriFieldTypeString, alias: COMPLETED, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: NO], [1: YES], [2: HOLD], ... 1 more ...)

Templates:

Name: UtilityAsBuiltTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• COMPLETED: 0

Relationships:
• Get Sewer Gravity Main (0) -- Related To: SewerGravityMain (315001)
• Get Sewer Lateral (2) -- Related To: SewerLateral (315003)
• Get Sewer Force Main (1) -- Related To: SewerForceMain (315002)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/25/2026 8:14:40 PM

Schema Last Edit Date: 4/25/2026 8:14:40 PM

Data Last Edit Date: 4/25/2026 8:14:01 PM