View In:   ArcGIS Online Map Viewer

Name: Stormwater Line by Type

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1e75f222852b4e659bc99357932bb3cf

Copyright Text:

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 8000

Tile Max Record Count: 4000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 9027.977411

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 4268957.034812763
YMin: 237092.68905887008
XMax: 4305589.837409079
YMax: 290404.2904327363
Spatial Reference: 2270  (2270)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: symbol
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 10
Default Label: Other Value
UniqueValueInfos:
• Value: ABANDONED
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: IRRIGATION PIPE
  Label: Irrigation Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: PRIVATE PIPE
  Label: Private Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: SD PIPE
  Label: Storm Drain Pipe
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: CANAL
  Label: Canal
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: DITCH
  Label: Ditch
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: BOX CULVERT
  Label: Box Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
• Value: UNKNOWN
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 10
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2256.0
Max. Scale: 565.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2256.994353
Max. Scale: 565.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 564.0
Max. Scale: 0.0
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [38, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 564.0
Max. Scale: 0.0

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: true

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: symbol

Fields:

• OBJECTID ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• ASSETGROUP ( modelName: ASSETGROUP, nullable: true, editable: true, defaultValue: 4, alias: Asset Group, type: esriFieldTypeInteger )
• ASSETTYPE ( modelName: ASSETTYPE, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: Asset Type, type: esriFieldTypeString , Coded Values: [Box Culvert: Box Culvert] , [Driveway Culvert: Driveway Culvert] , [Pipe: Pipe] , ...11 more... )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Asset ID, type: esriFieldTypeString )
• basin ( modelName: basin, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Basin, type: esriFieldTypeString , Coded Values: [BE: Bear Creek East - BE] , [BS: Bear Creek South - BS] , [BW: Bear Creek West - BW] , ...12 more... )
• constructionstatus ( modelName: constructionstatus, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Construction Status, type: esriFieldTypeString , Coded Values: [Abandoned: Abandoned] , [Under Construction: Under Construction] , [Construction Complete: Construction Complete] )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Owned By, type: esriFieldTypeString , Coded Values: [Unknown: Unknown] , [Private: Private] , [ODOT: ODOT] , ...4 more... )
• maintby ( modelName: maintby, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Maintained By, type: esriFieldTypeString , Coded Values: [Jackson County: Jackson County] , [ODOT: ODOT] , [Private: Private] , ...4 more... )
• symbol ( modelName: symbol, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Feature Symbol, type: esriFieldTypeString )
• material ( modelName: material, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Material, type: esriFieldTypeString , Coded Values: [STECH: Stormtech] , [ABS: ABS Plastic - ABS] , [CIP: Cast Iron - CIP] , ...15 more... )
• height ( modelName: height, nullable: true, editable: true, defaultValue: N/A, alias: height, type: esriFieldTypeDouble )
• width ( modelName: width, nullable: true, editable: true, defaultValue: N/A, alias: width, type: esriFieldTypeDouble )
• lined ( modelName: lined, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Lined, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• pipeshape ( modelName: pipeshape, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Pipe Shape, type: esriFieldTypeString , Coded Values: [Bottomless Arch: Bottomless Arch] , [Arch Pipe: Arch Pipe] , [Circular: Circular] , ...5 more... )
• upnode ( modelName: upnode, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Upstream Node, type: esriFieldTypeString )
• downnode ( modelName: downnode, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Downstream Node, type: esriFieldTypeString )
• upcovelev ( modelName: upcovelev, nullable: true, editable: true, defaultValue: N/A, alias: Upstream Cover Elevation, type: esriFieldTypeDouble )
• downcoverelev ( modelName: downcoverelev, nullable: true, editable: true, defaultValue: N/A, alias: Downstream Cover Elevation, type: esriFieldTypeDouble )
• upinvelev ( modelName: upinvelev, nullable: true, editable: true, defaultValue: N/A, alias: Upstream Invert Elevation, type: esriFieldTypeDouble )
• downinvelev ( modelName: downinvelev, nullable: true, editable: true, defaultValue: N/A, alias: Downstream Invert Elevation, type: esriFieldTypeDouble )
• pipelength ( modelName: pipelength, nullable: true, editable: true, defaultValue: N/A, alias: Pipe Length, type: esriFieldTypeDouble )
• slope ( modelName: slope, nullable: true, editable: true, defaultValue: N/A, alias: Slope, type: esriFieldTypeDouble )
• swfID ( modelName: swfID, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Storm Water Feature ID, type: esriFieldTypeString )
• plannumber ( modelName: plannumber, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Plan Number, type: esriFieldTypeString )
• datasource ( modelName: datasource, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Data Source, type: esriFieldTypeString , Coded Values: [Unknown: Unknown] , [As-Built: As-Built] , [CAD: CAD] , ...7 more... )
• elevationsource ( modelName: elevationsource, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: Elevation Source, type: esriFieldTypeString , Coded Values: [Unknown: Unknown] , [As-Built: As-Built] , [CAD: CAD] , ...4 more... )
• formerpipeID ( modelName: formerpipeID, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Former Pipe ID, type: esriFieldTypeString )
• pipechanges ( modelName: pipechanges, nullable: true, editable: true, defaultValue: N/A, length: 150, alias: Pipe Changes, type: esriFieldTypeString )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Notes, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• Shape__Length ( modelName: Shape.STLength(), nullable: true, editable: false, defaultValue: N/A, alias: Shape.STLength(), type: esriFieldTypeDouble, required: true )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: installdate, type: esriFieldTypeDate )
• lineddate ( modelName: lineddate, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: lineddate, type: esriFieldTypeDate )
• linertype ( modelName: linertype, nullable: true, editable: true, defaultValue: N/A, length: 30, alias: linertype, type: esriFieldTypeString )

Types:

ID: ABANDONED
Name: Abandoned
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  symbol: ABANDONED
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: IRRIGATION PIPE
Name: Irrigation Pipe
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Irrigation Pipe
  Description:
  Prototype:
  symbol: IRRIGATION PIPE
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PRIVATE PIPE
Name: Private Pipe
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Private Pipe
  Description:
  Prototype:
  symbol: PRIVATE PIPE
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: SD PIPE
Name: Storm Drain Pipe
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Storm Drain Pipe
  Description:
  Prototype:
  symbol: SD PIPE
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: CANAL
Name: Canal
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Canal
  Description:
  Prototype:
  symbol: CANAL
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: DITCH
Name: Ditch
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Ditch
  Description:
  Prototype:
  symbol: DITCH
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: BOX CULVERT
Name: Box Culvert
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Box Culvert
  Description:
  Prototype:
  symbol: BOX CULVERT
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: UNKNOWN
Name: Unknown
Domains:
• constructionstatus:
  Inherited
• lined:
  Inherited
• material:
  Inherited
• ASSETTYPE:
  Inherited
• datasource:
  Inherited
• pipeshape:
  Inherited
• maintby:
  Inherited
• basin:
  Inherited
• ownedby:
  Inherited
• elevationsource:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  symbol: UNKNOWN
  constructionstatus: null
  notes: null
  installdate: null
  ASSETGROUP: 4
  linertype: null
  ASSETTYPE: null
  upcovelev: null
  pipelength: null
  swfID: null
  upinvelev: null
  lined: null
  pipechanges: null
  pipeshape: null
  upnode: null
  last_edited_date: null
  ownedby: null
  height: null
  created_user: null
  plannumber: null
  basin: null
  slope: null
  elevationsource: null
  lineddate: null
  last_edited_user: null
  material: null
  assetid: null
  downcoverelev: null
  datasource: null
  downinvelev: null
  width: null
  maintby: null
  formerpipeID: null
  created_date: null
  downnode: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata