Layer: WaterMain (ID:510022)

View In: Map Viewer

Name: WaterMain

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: These are the lines which deliver your utility resource. Lines can be connected to other lines, junctions, and devices. Lines can be contained within assemblies. Types include Transmission Main, Distribution Main, Production Main, Drain Line and Overflow 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:

Drawing Info:

","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Unknown","description":"Unknown","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"values":[["0"]]},{"label":"Transmission Main","description":"Transmission Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"values":[["1"]]},{"label":"Distribution Main","description":"Distribution Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"values":[["2"]]},{"label":"Production Main","description":"Production Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2},"values":[["3"]]},{"label":"Drain Line","description":"Drain Line","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":2},"values":[["4"]]},{"label":"Overflow Main","description":"Overflow Main","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":2},"values":[["5"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"value":"1","label":"Transmission Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"value":"2","label":"Distribution Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2},"value":"3","label":"Production Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":2},"value":"4","label":"Drain Line"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":2},"value":"5","label":"Overflow Main"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[134,141,207,255],"toColor":[134,141,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[59,56,242,255],"toColor":[59,56,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[51,80,196,255],"toColor":[51,80,196,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[191,202,242,255],"toColor":[191,202,242,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[129,140,247,255],"toColor":[129,140,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[70,84,240,255],"toColor":[70,84,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[105,117,250,255],"toColor":[105,117,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[181,181,247,255],"toColor":[181,181,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[91,108,194,255],"toColor":[91,108,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[155,160,194,255],"toColor":[155,160,194,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[152,162,250,255],"toColor":[152,162,250,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[50,47,204,255],"toColor":[50,47,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[101,103,214,255],"toColor":[101,103,214,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"var wlm = $feature.material;\nvar wlmlbl = When(wlm == 0, 'Unknown', wlm == 79, 'Non-Lead Unknown', wlm == 80, 'ABS Plastic', wlm == 81, 'Asbestos Cement', wlm == 83, 'Cast Iron', wlm == 84, 'Copper', wlm == 88, 'Ductile Iron', wlm == 89, 'Galvanized Pipe', wlm == 92, 'Polyethylene', wlm == 93, 'Polypropylene', wlm == 94, 'Polyvinyl Chloride', wlm == 102, 'High Density Polyethylene', wlm == 109, 'Lead', wlm == 110, 'Cross-linked Polyethylene', wlm);\n\nvar wld = $feature.diameter;\nvar wldlbl = When(wld == '0', 'Unknown', wld == 0.375, '3/8\"', wld == 0.5, '1/2\"', wld == 0.625, '5/8\"', wld == 0.75, '3/4\"', wld == 1, '1\"', wld == 1.25, '1 1/4\"', wld == 1.5, '1 1/2\"', wld == 2, '2\"', wld == 2.25, '2 1/4\"', wld == 2.5, '2 1/2\"', wld == 3, '3\"', wld == 4, '4\"', wld == 4.5, '4 1/2\"', wld == 5.25, '5 1/4\"\"', wld == 6, '6\"', wld == 8, '8\"', wld == 10, '10\"', wld == 12, '12\"', wld == 16, '16\"', wld == 24, '24\"', wld);\n\nvar retlbl = wldlbl + ' - ' + wlmlbl;\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,"useCodedValues":true,"maxScale":0,"minScale":1128.497176,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,76,115,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"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:

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], [1: Transmission Main], [2: Distribution Main], ... 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], ... 18 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], ... 18 more ...)
cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, 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 Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: true)
DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, 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])
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 ...)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: 1"], [1.25: 1 1/4"], ... 25 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 ...)
measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
adddetails (type: esriFieldTypeSmallInteger, alias: adddetails: Color Code, Tracer Wire, 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 ...)
bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [80: ABS Plastic - ABS], [81: Asbestos Cement - AC], [82: Brick - BR], ... 28 more ...)
cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
designtype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Potable], [2: Irrigation], ... 7 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 ...)
referencedoc (type: esriFieldTypeString, alias: Reference Document, SQL Type: sqlTypeOther, length: 255, 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)
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:

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 0
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 1
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 2
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 3
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 4
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

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: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: diameter
Inherited
Field Name: pipelocation
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: bondedinsulated
Inherited
Field Name: cptraceability
Inherited
Field Name: material
Inherited
Field Name: cpoverride
Inherited
Field Name: designtype
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: VALIDATIONSTATUS
Inherited

ASSETGROUP: 0
ASSETTYPE: 5
ASSOCIATIONSTATUS: 0
ISCONNECTED: 0
FROMDEVICETERMINAL: 0
TODEVICETERMINAL: 0
cpsubnetworkname:
SUPPORTEDSUBNETWORKNAME:
SUPPORTINGSUBNETWORKNAME:
SystemSubnetworkName:
PressureSubnetworkName:
IsolationSubnetworkName:
DMASubnetworkName:
lifecyclestatus: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/24/2026 10:11:38 PM

Schema Last Edit Date: 1/24/2026 10:11:38 PM

Data Last Edit Date: 1/24/2026 10:10:25 PM

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