Name: Water Main
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 288896
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13030964.2555165
YMin: 5838576.27948885
XMax: -13018019.9897864
YMax: 5850941.93591725
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,83,183,255],"width":1}},"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeNone
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)
- CartegraphID (type: esriFieldTypeString, alias: Cartegraph ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- JointType (type: esriFieldTypeString, alias: Joint Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Coupling: Coupling], [Flange: Flange], [Harness: Harness], ... 2 more ...)
- LiningType (type: esriFieldTypeString, alias: Lining Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Cement: Cement], [Coal Tar: Coal Tar], [Epoxy: Epoxy], ... 6 more ...)
- Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PVC C900: PVC C900], [Cast Iron: Cast Iron], [Transite: Transite], ... 15 more ...)
- PressureZone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- WaterType (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Greywater: Greywater], [Potable: Potable], [Hydrant Feed: Hydrant Feed], ... 9 more ...)
- Diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DiameterUnit (type: esriFieldTypeString, alias: Diameter Unit, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- Length (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LengthUnit (type: esriFieldTypeString, alias: Length Unit, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CheckedBy (type: esriFieldTypeString, alias: Checked By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- MainWater (type: esriFieldTypeString, alias: Main Water, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ATK: ATK], [City Domestic: City Domestic], [Hatwai: Hatwai], ... 7 more ...)
- Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Active (type: esriFieldTypeString, alias: Active, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Retired (type: esriFieldTypeDate, alias: Retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Replaced (type: esriFieldTypeDate, alias: Replaced, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Installed (type: esriFieldTypeDate, alias: Installed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- TotalCost (type: esriFieldTypeDouble, alias: Total Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ConditionGroup (type: esriFieldTypeString, alias: Condition Group, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- Jurisdiction (type: esriFieldTypeString, alias: Jurisdiction, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- EstimatedOCI (type: esriFieldTypeDouble, alias: EstimatedOCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PredictionGroup (type: esriFieldTypeString, alias: Prediction Group, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- EstimatedOCR (type: esriFieldTypeString, alias: EstimatedOCR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- EstimatedCCR (type: esriFieldTypeString, alias: EstimatedCCR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CriticalityFactor (type: esriFieldTypeDouble, alias: CriticalityFactor, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CurrentInspectionID (type: esriFieldTypeString, alias: Current Inspection ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- EstimatedCCI (type: esriFieldTypeDouble, alias: Estimated CCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ActBefore (type: esriFieldTypeDate, alias: ActBefore, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
- Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- StateValue (type: esriFieldTypeString, alias: State Value, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CurrentInspectionDate (type: esriFieldTypeDate, alias: Current Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CurrentInspectionOCI (type: esriFieldTypeDouble, alias: Current Inspection OCI, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CurrentInspectionOCR (type: esriFieldTypeString, alias: CurrentInspectionOCR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CurrentInspectionNotes (type: esriFieldTypeString, alias: Current Inspection Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, 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_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- MainService (type: esriFieldTypeString, alias: Main Service, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ATK: ATK], [City Domestic: City Domestic], [Hatwai: Hatwai], ... 7 more ...)
- MaintenanceArea (type: esriFieldTypeString, alias: Maintenance Area, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Owner (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Maintainer (type: esriFieldTypeString, alias: Maintainer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DWG: DWG], [Plat: Plat], [Import: Import], ... 8 more ...)
- DataSourceNote (type: esriFieldTypeString, alias: Data Source Note, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- DataCreationMethod (type: esriFieldTypeString, alias: Data Creation Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Collected With Arrow: Collected With Arrow], [Digitized From Field GPS: Digitized From Field GPS], [Digitized From DWG: Digitized From DWG], ... 4 more ...)
- DataCreationMethodNote (type: esriFieldTypeString, alias: Data Creation Method Note, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- DataCreationRank (type: esriFieldTypeString, alias: Data Creation Rank, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Very Poor: Very Poor], [Poor: Poor], [Fair: Fair], ... 2 more ...)
- ExpectedLife (type: esriFieldTypeDouble, alias: Expected Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RemainingLife (type: esriFieldTypeDouble, alias: Remaining Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ConstructionDrawing (type: esriFieldTypeString, alias: Construction Drawing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Preconstruction: Preconstruction], [Live Low Accuracy: Live Low Accuracy], [Live High Accuracy: Live High Accuracy])
- DevelopmentProject (type: esriFieldTypeString, alias: Development Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Project (type: esriFieldTypeString, alias: Capital Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NumberOfLaterals (type: esriFieldTypeSmallInteger, alias: Number Of Laterals, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NumberOfGalvanizedLaterals (type: esriFieldTypeSmallInteger, alias: Number Of Galvanized Laterals, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NumberOfRepairs (type: esriFieldTypeSmallInteger, alias: Number Of Repairs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PlanYear (type: esriFieldTypeSmallInteger, alias: Plan Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OriginalPlanYear (type: esriFieldTypeSmallInteger, alias: Original Plan Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MainLink (type: esriFieldTypeString, alias: Main Link, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/27/2026 1:43:31 PM
Schema Last Edit Date: 9/27/2026 1:43:31 PM
Data Last Edit Date: 9/27/2026 1:43:31 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat