Name: SW_OpenChannel

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Has Views: true

Source Schema Changes Allowed: true

Views

Description: SW_OpenChannel

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: 2387228.05447705
YMin: 346070.422986805
XMax: 2405444.64599656
YMax: 359432.601642981
Spatial Reference: 102750 (26853)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[170,170,170,255],"width":3},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[167,198,54,255],"width":3},"value":"1","label":"Vegetated"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[20,158,206,255],"width":3},"value":"3","label":"Concrete"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[127,127,127,255],"width":3},"value":"4","label":"Paved"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[60,175,153,255],"width":3},"value":"2","label":"Riprap"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[247,137,216,255],"width":3},"value":"100","label":"Unknown"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

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

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Vegetated], [2: Riprap], [3: Concrete], ... 2 more ...)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 27 more ...)
• upelev (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• downelev (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• pipeshape (type: esriFieldTypeSmallInteger, alias: Shape, SQL Type: sqlTypeOther, nullable: true, editable: true)
• type (type: esriFieldTypeSmallInteger, alias: Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [3: Wet], [4: Dry])
• lined (type: esriFieldTypeSmallInteger, alias: Lined?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lineryear (type: esriFieldTypeSmallInteger, alias: Liner Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• linermethod (type: esriFieldTypeSmallInteger, alias: Liner Method, SQL Type: sqlTypeOther, nullable: true, editable: true)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Proposed - Approved], ... 4 more ...)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length_2 (type: esriFieldTypeDouble, alias: Shape__Length_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Condition (type: esriFieldTypeInteger, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Excellent], [2: Good], [3: Fair], ... 2 more ...)
• Problems (type: esriFieldTypeInteger, alias: Problems, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Overgrown], [3: Brush], ... 2 more ...)
• Erosion (type: esriFieldTypeInteger, alias: Erosion, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No], [2: Yes])
• StandingWater (type: esriFieldTypeInteger, alias: Standing Water, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No], [2: Yes])
• TrashLevel (type: esriFieldTypeInteger, alias: Trash Level, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Low], [2: Medium], [3: High])
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Photo (type: esriFieldTypeString, alias: Photo, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Shape__Length_3 (type: esriFieldTypeDouble, alias: Shape__Length_3, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: Vegetated
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: type
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: Condition
  Inherited
  
• Field Name: Problems
  Inherited
  
• Field Name: Erosion
  Inherited
  
• Field Name: StandingWater
  Inherited
  
• Field Name: TrashLevel
  Inherited
  
Templates:

Name: 1
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 1
• Condition: 100
• Problems: 1
• Erosion: 2
• StandingWater: 2

---

ID: 3
Name: Concrete
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: type
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: Condition
  Inherited
  
• Field Name: Problems
  Inherited
  
• Field Name: Erosion
  Inherited
  
• Field Name: StandingWater
  Inherited
  
• Field Name: TrashLevel
  Inherited
  
Templates:

Name: 3
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 3
• Condition: 100
• Problems: 1
• Erosion: 2
• StandingWater: 2

---

ID: 4
Name: Paved
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: type
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: Condition
  Inherited
  
• Field Name: Problems
  Inherited
  
• Field Name: Erosion
  Inherited
  
• Field Name: StandingWater
  Inherited
  
• Field Name: TrashLevel
  Inherited
  
Templates:

Name: 4
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 4
• Condition: 100
• Problems: 1
• Erosion: 2
• StandingWater: 2

---

ID: 2
Name: Riprap
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: type
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: Condition
  Inherited
  
• Field Name: Problems
  Inherited
  
• Field Name: Erosion
  Inherited
  
• Field Name: StandingWater
  Inherited
  
• Field Name: TrashLevel
  Inherited
  
Templates:

Name: 2
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 2
• Condition: 100
• Problems: 1
• Erosion: 2
• StandingWater: 2

---

ID: 100
Name: Unknown
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: type
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: Condition
  Inherited
  
• Field Name: Problems
  Inherited
  
• Field Name: Erosion
  Inherited
  
• Field Name: StandingWater
  Inherited
  
• Field Name: TrashLevel
  Inherited
  
Templates:

Name: 100
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 100
• Condition: 100
• Problems: 1
• Erosion: 2
• StandingWater: 2

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/6/2022 8:25:07 PM

Schema Last Edit Date: 12/6/2022 8:25:07 PM

Data Last Edit Date: 12/6/2022 8:25:07 PM

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