Name: open_channels

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: 17740

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8684822.2195
YMin: 4784881.3655
XMax: -8676726.02012964
YMax: 4791775.4474
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[241,152,60,255],"width":1}},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• asset_id (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• structure_id (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• open_channel_type (type: esriFieldTypeString, alias: Open Channel Type, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [canal: Canal], [ditch: Ditch], [natural: Natural], ... 4 more ...)
• service_type (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [combined: Combined Sewer-Storm], [other: Other], [recycled: Recycled Water], ... 4 more ...)
• flow_type (type: esriFieldTypeString, alias: Flow Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [303d: 303(d) Impaired Waterbody], [other: Other], [receiving-water: Receiving Water])
• asset_material (type: esriFieldTypeString, alias: Asset Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [aluminum: Aluminum], [amended-soil: Amended Soil], [asphalt: Asphalt], ... 30 more ...)
• asset_shape (type: esriFieldTypeString, alias: Asset Shape, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [circular: Circular], [horseshoe: Horseshoe], [irregular: Irregular], ... 6 more ...)
• confined_space (type: esriFieldTypeString, alias: Confined Space, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [yes: Yes])
• height (type: esriFieldTypeDouble, alias: Height (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• width (type: esriFieldTypeDouble, alias: Width (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• linear_length (type: esriFieldTypeDouble, alias: Linear Length (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• area (type: esriFieldTypeDouble, alias: Area (square-feet), SQL Type: sqlTypeOther, nullable: true, editable: true)
• slope (type: esriFieldTypeDouble, alias: Slope (degrees), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• upstream_elevation (type: esriFieldTypeDouble, alias: Upstream Elevation (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-100000 - 100000])
• downstream_elevation (type: esriFieldTypeDouble, alias: Downstream Elevation (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [-100000 - 100000])
• datum (type: esriFieldTypeString, alias: Elevation Datum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [egm2008: EGM 2008], [egm96: EGM 96], [other: Other], ... 4 more ...)
• flow_direction (type: esriFieldTypeString, alias: Flow Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [indeterminate: Indeterminate Direction], [with-digitized: With Digitized Direction], [against-digitized: Against Digitized Direction])
• depth (type: esriFieldTypeDouble, alias: Design Depth (feet), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 999999])
• property (type: esriFieldTypeString, alias: Land Ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dot: DOT], [local-agency: Local Agency], [ms4: MS4], ... 5 more ...)
• responsible_party_delivery (type: esriFieldTypeString, alias: Delivered By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dot: DOT], [local-agency: Local Agency], [ms4: MS4], ... 5 more ...)
• responsible_party_maintenance (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [dot: DOT], [local-agency: Local Agency], [ms4: MS4], ... 5 more ...)
• install_date (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• phase (type: esriFieldTypeString, alias: Phase, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [abandoned: Abandoned], [certified: Certified], [completed: Completed], ... 7 more ...)
• consequence_of_failure (type: esriFieldTypeString, alias: Consequence of Failure, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [very-high: Very High], [high: High], [moderate: Moderate], ... 3 more ...)
• lined (type: esriFieldTypeString, alias: Lined, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [yes: Yes])
• lining_method (type: esriFieldTypeString, alias: Lining Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cured-in-place: Cured in Place], [deform-reform: Deform/Reform], [fold-and-form: Fold and Form], ... 8 more ...)
• lining_year (type: esriFieldTypeInteger, alias: Lining Year (yyyy), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1000 - 9999])
• accessible (type: esriFieldTypeString, alias: Accessible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [yes: Yes])
• dry_weather_monitoring_location (type: esriFieldTypeString, alias: Dry Weather Monitoring Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [yes: Yes])
• city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [alabama: Alabama], [alaska: Alaska], [arizona: Arizona], ... 50 more ...)
• zip (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• deleted_at (type: esriFieldTypeDate, alias: deleted_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_sync (type: esriFieldTypeDate, alias: last_sync, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_inspection_result (type: esriFieldTypeString, alias: last_inspection_result, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [maintenance-needed: Maintenance Needed], [optimal: Optimal])
• last_inspection_date (type: esriFieldTypeDate, alias: Last Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• upstream_node (type: esriFieldTypeGUID, alias: Upstream Node, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• downstream_node (type: esriFieldTypeGUID, alias: Downstream Node, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• unique_id (type: esriFieldTypeGUID, alias: Unique ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_by (type: esriFieldTypeString, alias: created_by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_at (type: esriFieldTypeDate, alias: created_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updated_by (type: esriFieldTypeString, alias: updated_by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• updated_at (type: esriFieldTypeDate, alias: updated_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)

Templates:

Name: Open Channel
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• open_channel_type: unknown
• responsible_party_maintenance: our-agency
• phase: completed

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/3/2026 7:18:43 PM

Schema Last Edit Date: 9/2/2026 6:41:03 PM

Data Last Edit Date: 9/15/2026 5:44:48 PM

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