Name: Water_Mains
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -7913864.17051389
YMin: 5365818.7071362
XMax: -7906809.31719365
YMax: 5372917.32849179
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.DIAMETER + '-' + $feature.MATERIAL","title":"Custom"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":5000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[0,197,255,255],"haloSize":1,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false
HasM: true
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, 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: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 33 more ...)
- DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 27 more ...)
- WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Potable: Potable Water], [Raw: Raw Water], [Reclaimed: Reclaimed Water], ... 3 more ...)
- TRANSMISS (type: esriFieldTypeString, alias: Transmission System, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other])
- MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [-1: Private], [-2: Other])
- ID (type: esriFieldTypeString, alias: ID, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- DESCRIPT (type: esriFieldTypeString, alias: DESCRIPT, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- YR_INST (type: esriFieldTypeSmallInteger, alias: YR_INST, SQL Type: sqlTypeOther, nullable: true, editable: true)
- YR_RETIRE (type: esriFieldTypeSmallInteger, alias: YR_RETIRE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ZONE (type: esriFieldTypeString, alias: ZONE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- MATERIAL_1 (type: esriFieldTypeString, alias: MATERIAL_1, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- LINING (type: esriFieldTypeString, alias: LINING, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- COST_ID (type: esriFieldTypeString, alias: COST_ID, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- PHASE (type: esriFieldTypeSmallInteger, alias: PHASE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIAMETER_1 (type: esriFieldTypeDouble, alias: DIAMETER_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ROUGHNESS (type: esriFieldTypeDouble, alias: ROUGHNESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MINORLOSS (type: esriFieldTypeDouble, alias: MINORLOSS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTALIZER (type: esriFieldTypeSmallInteger, alias: TOTALIZER, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CHK_VALVE (type: esriFieldTypeSmallInteger, alias: CHK_VALVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FROM_ (type: esriFieldTypeString, alias: FROM_, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- TO_ (type: esriFieldTypeString, alias: TO, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- SELECTED (type: esriFieldTypeSmallInteger, alias: SELECTED, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CAL_LENGTH (type: esriFieldTypeDouble, alias: CAL_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WIDTH (type: esriFieldTypeDouble, alias: WIDTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SYMBOL (type: esriFieldTypeSmallInteger, alias: SYMBOL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SYMSIZE (type: esriFieldTypeDouble, alias: SYMSIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HANDLE (type: esriFieldTypeString, alias: HANDLE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- SYMHNDL (type: esriFieldTypeString, alias: SYMHNDL, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- ANNOHNDL (type: esriFieldTypeString, alias: ANNOHNDL, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- LBLHNDL (type: esriFieldTypeString, alias: LBLHNDL, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- INACTIVE (type: esriFieldTypeSmallInteger, alias: INACTIVE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DOMAIN (type: esriFieldTypeSmallInteger, alias: DOMAIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
- QRYSET (type: esriFieldTypeSmallInteger, alias: QRYSET, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COLOR (type: esriFieldTypeInteger, alias: COLOR, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIRECTION (type: esriFieldTypeDouble, alias: DIRECTION, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RUN_DIAM (type: esriFieldTypeDouble, alias: RUN_DIAM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RUN_LENGTH (type: esriFieldTypeDouble, alias: RUN_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RUN_ROUGH (type: esriFieldTypeDouble, alias: RUN_ROUGH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FLOW (type: esriFieldTypeDouble, alias: FLOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VELOCITY (type: esriFieldTypeDouble, alias: VELOCITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HEADLOSS (type: esriFieldTypeDouble, alias: HEADLOSS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HL1000 (type: esriFieldTypeDouble, alias: HL1000, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STATUS (type: esriFieldTypeDouble, alias: STATUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAX_FLOW (type: esriFieldTypeDouble, alias: MAX_FLOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MIN_FLOW (type: esriFieldTypeDouble, alias: MIN_FLOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVE_FLOW (type: esriFieldTypeDouble, alias: AVE_FLOW, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAX_VELOC (type: esriFieldTypeDouble, alias: MAX_VELOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MIN_VELOC (type: esriFieldTypeDouble, alias: MIN_VELOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVE_VELOC (type: esriFieldTypeDouble, alias: AVE_VELOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAX_HDLOSS (type: esriFieldTypeDouble, alias: MAX_HDLOSS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MIN_HDLOSS (type: esriFieldTypeDouble, alias: MIN_HDLOSS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AVE_HDLOSS (type: esriFieldTypeDouble, alias: AVE_HDLOSS, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WP_Traffic_Class (type: esriFieldTypeString, alias: WP_Traffic_Class, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Project (type: esriFieldTypeSmallInteger, alias: Project, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RiskID (type: esriFieldTypeSmallInteger, alias: RiskID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SYS_NAME (type: esriFieldTypeString, alias: SYS_NAME, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
- PWSID (type: esriFieldTypeString, alias: PWSID, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
- Material_Label (type: esriFieldTypeString, alias: Material_Label, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ABS: ABS Plastic], [AC: Asbestos Cement], [ASP: Asphalt], ... 33 more ...)
- LENGTH2 (type: esriFieldTypeString, alias: Water Main Length, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: Water Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/8/2026 3:23:35 PM
Schema Last Edit Date: 9/8/2026 3:23:35 PM
Data Last Edit Date: 9/8/2026 3:23:35 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat