Layer: Water Main (ID:7)

View In: Map Viewer

Name: Water Main

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 500000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"DomainName($feature, 'DIAMETER') + '\" PVT'","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"where":"(OWNEDBY = 0 AND DEPTMAINT IS NULL) OR (OWNEDBY = 0 AND DEPTMAINT = 'PRIV')","useCodedValues":true,"maxScale":0,"minScale":3000,"name":"Private","priority":-1,"symbol":{"type":"esriTS","color":[223,115,255,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":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"'(RCW) ' + DomainName($feature, 'DIAMETER') + '\" ' + DomainName($feature, 'MATERIAL')","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":false,"removeDuplicates":"none","where":"OWNEDBY = 1 AND DEPTMAINT = 'WTR'","useCodedValues":true,"maxScale":0,"minScale":3000,"name":"St. Petersburg,WRD","priority":-1,"symbol":{"type":"esriTS","color":[158,85,156,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":10,"style":"normal","weight":"normal","decoration":"none"}}},{"labelExpressionInfo":{"expression":"'(RCW) ' + DomainName($feature, 'DIAMETER') + '\" County'","title":"Custom"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","useClippedGeometry":true,"stackLabel":false,"removeDuplicates":"none","where":"OWNEDBY = -3 AND DEPTMAINT IS NULL","useCodedValues":true,"maxScale":0,"minScale":3000,"name":"County","priority":-1,"symbol":{"type":"esriTS","color":[223,115,255,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":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: false

HasM: true

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:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FACILITYID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PVC: Polyvinyl Chloride], [DIP: Ductile Iron], [HDPE: High Density Polyethylene], ... 8 more ...)
DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: 2], [4: 4], [6: 6], ... 22 more ...)
WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true, Coded Values: [Potable: Potable Water], [Reclaimed: Reclaimed Water])
TRANSMISS (type: esriFieldTypeString, alias: Transmission System, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
PROJECTNUM (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Private], [-3: County], [-4: State], ... 1 more ...)
MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [-2: Other], [-3: County], ... 3 more ...)
PIPETYPE (type: esriFieldTypeString, alias: Pipe Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Distribution: Distribution], [Dryline: Dryline], [Plant: Plant], ... 3 more ...)
NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
JURISDICTION (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [St. Petersburg: St. Petersburg], [Clearwater: Clearwater], [Lealman: Lealman], ... 8 more ...)
STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true, Coded Values: [C: Current], [P: Proposed], [A: Abandoned])
WATERCROSSING (type: esriFieldTypeString, alias: Water Crossing, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [S: Subaqueous], [B: Bridge], [N: None])
WAMID (type: esriFieldTypeString, alias: WAM ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
CRITICALITY (type: esriFieldTypeSmallInteger, alias: Criticality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [4: 4], [7: 7])
CREATED_USER (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
CREATED_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
LAST_EDITED_USER (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
LAST_EDITED_DATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
WACSID (type: esriFieldTypeString, alias: WACS ID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
SYNCDATE (type: esriFieldTypeDate, alias: Sync Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WACSDESCRIPTION (type: esriFieldTypeString, alias: WACS Description, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
IN_MODEL (type: esriFieldTypeSmallInteger, alias: IN_MODEL, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
DEPTMAINT (type: esriFieldTypeString, alias: DEPTMAINT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ARP: Airport], [ENTSERV: Enterprise Services], [GOLF: Golf Courses], ... 4 more ...)
CFACTOR (type: esriFieldTypeDouble, alias: C-Factor, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

DEPTMAINT: WTR
WATERTYPE: Potable
TRANSMISS: No
ENABLED: 1
OWNEDBY: 1
MAINTBY: 1
JURISDICTION: St. Petersburg
STATUS: C
WATERCROSSING: N
CRITICALITY: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/1/2026 12:21:53 PM

Schema Last Edit Date: 9/1/2026 12:21:53 PM

Data Last Edit Date: 9/1/2026 12:21:20 PM

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