Name: Mains

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 220000

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","valueExpression":"var ag = $feature.ASSETGROUP\nvar at = $feature.ASSETTYPE\nvar ow = $feature.ownedby\nWhen((ag == 1) && ow != 1, \"Gravity Main Not OwnedBy Sarasota County\", ag == 1 && at == 1, \"Collector Gravity Main\", ag == 1 && at == 2, \"Interceptor Gravity Main\", null)","valueExpressionTitle":"Custom","uniqueValueGroups":[{"heading":"","classes":[{"label":"Collector Gravity Main","description":"Collector Gravity Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2},"values":[["Collector Gravity Main"]]},{"label":"Interceptor Gravity Main","description":"Interceptor Gravity Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,115,0,255],"width":2},"values":[["Interceptor Gravity Main"]]},{"label":"Private Gravity Main","description":"Private Gravity Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":2},"values":[["Gravity Main Not OwnedBy Sarasota County"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,230,0,255],"width":2},"value":"Collector Gravity Main","label":"Collector Gravity Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[76,115,0,255],"width":2},"value":"Interceptor Gravity Main","label":"Interceptor Gravity Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":2},"value":"Gravity Main Not OwnedBy Sarasota County","label":"Private Gravity Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,230,210,255],"toColor":[252,230,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[185,179,252,255],"toColor":[185,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,252,179,255],"toColor":[188,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,252,255],"toColor":[182,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,218,255],"toColor":[252,184,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,217,252,255],"toColor":[192,217,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,182,255],"toColor":[252,249,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,182,252,255],"toColor":[249,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[217,252,212,255],"toColor":[217,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,189,182,255],"toColor":[252,189,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[242,212,252,255],"toColor":[242,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,243,252,255],"toColor":[215,243,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,216,255],"toColor":[252,215,216,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Time Info:

Start Time Field: null
End Time Field: null
Track ID Field: null
Time Extent: null

Time Reference: UTC
Time Interval: 0
Time Interval Units:
Has Live Data: false
Export Options:

Use Time: false
Time Data Cumulative: false
Time Offset: 0
Time Offset Units: esriTimeUnitsCenturies

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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: Object ID, 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)
• 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: System Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• regionsubnetworkname (type: esriFieldTypeString, alias: Region Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• sewershedsubnetworkname (type: esriFieldTypeString, alias: Basin Subnetwork, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: Size/Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• linertype (type: esriFieldTypeSmallInteger, alias: Liner Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• 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)
• hyperlink (type: esriFieldTypeString, alias: Hyperlink, 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)
• FLOWDIRECTION (type: esriFieldTypeSmallInteger, alias: Flow direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: With digitized], [2: Against digitized], [3: Indeterminate])
• 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)
• nassco_mat (type: esriFieldTypeString, alias: nassco_mat, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• nassco_liner (type: esriFieldTypeString, alias: nassco_liner, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• nassco_shp (type: esriFieldTypeString, alias: nassco_shp, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• nassco_use (type: esriFieldTypeString, alias: nassco_use, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• bgn_assetid (type: esriFieldTypeString, alias: bgn_assetid, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• end_assetid (type: esriFieldTypeString, alias: end_assetid, SQL Type: sqlTypeOther, length: 64, 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 ...)
• 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: true)

Templates:

Name: GravityMains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/2/2026 4:42:54 PM

Schema Last Edit Date: 6/1/2026 3:25:42 PM

Data Last Edit Date: 6/1/2026 3:25:29 PM

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