Name: Open_Channel

Display Field: SYSTEMNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text: This feature class was created February 2018 per IID Water Department's requirements.

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: -12895178.6536
YMin: 3849355.8963
XMax: -12742682.6853
YMax: 3952218.9085
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[98,155,32,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• LOCATIONID (type: esriFieldTypeString, alias: Functional Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSETGROUP (type: esriFieldTypeInteger, alias: Channel Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Drain], [2: Interceptor], ... 4 more ...)
• FUNCTION_ (type: esriFieldTypeString, alias: Function, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DRAIN: Drain], [CANAL: Canal])
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true, Coded Values: [UNK: Unknown], [PROPSD: Proposed], [INSERV: In service], ... 4 more ...)
• WATERSHED (type: esriFieldTypeString, alias: Watershed, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• SYSTEMNAME (type: esriFieldTypeString, alias: System Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SYSTEMABV (type: esriFieldTypeString, alias: System Abbreviation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CONSTRUCTIONTYPE (type: esriFieldTypeString, alias: Construction Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [UNK: Unknown], [CLAYLNR: Clay Liner], [CONC: Concrete], ... 7 more ...)
• DIVISION (type: esriFieldTypeString, alias: Division, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [SOUTHEND: Southend], [NORTHEND: Northend], [WESTERN: Western], ... 1 more ...)
• SYSCONSERVATION (type: esriFieldTypeString, alias: System Conservation, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: No], [YES: Yes])
• PUPFISH (type: esriFieldTypeString, alias: Pupfish, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: No], [YES: Yes])
• HEIGHT (type: esriFieldTypeDouble, alias: Height or Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH (type: esriFieldTypeDouble, alias: Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DESIGNCAPACITY (type: esriFieldTypeDouble, alias: Design Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERCAPACITY (type: esriFieldTypeDouble, alias: Operational Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UPELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Side Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LININGWIDTHBOTTOM (type: esriFieldTypeDouble, alias: Lining Bottom Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LININGWIDTHTOP (type: esriFieldTypeDouble, alias: Lining Width of Top, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LININGDEPTH (type: esriFieldTypeDouble, alias: Depth of Lining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LININGSIDESLOPE (type: esriFieldTypeDouble, alias: Side Slope of Lining, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LININGTHICKNESS (type: esriFieldTypeDouble, alias: Lining Thickness, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZANRUN (type: esriFieldTypeString, alias: Zanjero Run, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [A15: A15], [ACA: ACA], [ALD: ALD], ... 48 more ...)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ABANDONEDDATE (type: esriFieldTypeDate, alias: Abandoned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SCADASITE (type: esriFieldTypeString, alias: SCADA Site, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: No], [YES: Yes])
• SCADALOCATIONID (type: esriFieldTypeInteger, alias: SCADA Location ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: Network/Work Order Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUPERIORORDERNUM (type: esriFieldTypeString, alias: Superior Order Num, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DWG (type: esriFieldTypeString, alias: DWG, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSUE (type: esriFieldTypeSmallInteger, alias: Issue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true, Coded Values: [CBL: Cable], [CTY: City], [COMM: Communication], ... 9 more ...)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: 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)

Templates:

Name: Open_Channel
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ENABLED: 1
• ASSETGROUP: 0
• LIFECYCLESTATUS: INSERV

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/11/2024 4:30:46 PM

Schema Last Edit Date: 4/11/2024 4:30:46 PM

Data Last Edit Date: 4/11/2024 4:30:42 PM

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