Parent Layer: Water Quality

Name: Water Quality Streams

Display Field: stream_lake_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This feature contains a spatial representation of streams and stream segments with water quality information from Oregon’s 2012 Integrated Report Assessment Database and 303(d) List. This feature should be used in conjunction with the feature OR_Lakes_WaterQuality_2012. A water body may have assessment information for multiple pollutants or conditions, and may have multiple data records associated with the spatial representation of the water body or segment of the water body. Oregon’s 2012 Integrated Report Assessment Database and 303(d) List are available on-line at http://www.deq.state.or.us/wq/assessment/rpt2012/search.asp. The on-line searchable database should be used in conjunction with these features, and is the reference source to verify all attribute information about water quality and to obtain assessment information about water bodies that do not have georeferenced locations. Users may contact DEQ for information about Oregon’s water quality assessment process, additional updates to the 2012 IR, and the schedule for future water quality integrated reports. http://www.deq.state.or.us/wq/assessment/assessment.htm.Note: Duplicate RecordIDs exist in the dataset due to an EPA listing error. This includes Record #s 6550, 8025, 20340, 20847, and 21121 in the data. A ReadMe file accompanies the geodatabase and users are encouraged to see the document for additional details.

Service Item Id: 6d60a8543502499b95d4f5a176734697

Copyright Text: This data set was assembled by the Oregon Department of Environmental Quality, Water Quality Division, Standards and Assessments Section.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.38641678955E7
YMin: 5159371.261100002
XMax: -1.2964642124400001E7
YMax: 5823970.013899997
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: status_id
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 17
  Label: Cat 5: Water quality limited, TMDL needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: 3
  Label: Cat 5: Water quality limited, TMDL needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: 7
  Label: Cat 4: Water quality limited, TMDL not needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 20
  Label: Cat 4: Water quality limited, TMDL not needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 14
  Label: Cat 4A: Water quality limited, TMDL approved
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 4
  Label: Cat 4A: Water quality limited, TMDL approved
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 15
  Label: Cat 4B:Water quality limited, other pollution control requirements are expected to address all pollutants
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 16
  Label: Cat 4C: Water quality limited, impairment not caused by a pollutant
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 1
• Value: 6
  Label: Cat 3: Insufficient data
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 13
  Label: Cat 3: Insufficient data
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [104, 104, 104, 255]
  Width: 1
• Value: 2
  Label: Cat 3B: Insufficient data, potential concern
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: 19
  Label: Cat 3B: Insufficient data, potential concern
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: 22
  Label: Cat 3C: Impairing pollutant unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 112, 0, 255]
  Width: 1
• Value: 1
  Label: Cat 2: Attaining, specific water quality standards are met
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: 12
  Label: Cat 2: Attaining, specific water quality standards are met
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: 10
  Label: Criteria change or use clarification
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 255]
  Width: 1
• Value: 21
  Label: Inactive
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [197, 0, 255, 255]
  Width: 1
• Value: 18
  Label: No Criteria
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [132, 0, 168, 255]
  Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• assessment_id ( type: esriFieldTypeDouble, alias: ASSESSMENT_ID )
• record_id ( type: esriFieldTypeDouble, alias: RECORD_ID )
• stream_lake_name ( type: esriFieldTypeString, alias: STREAM_LAKE_NAME, length: 255 )
• stream_name ( type: esriFieldTypeString, alias: STREAM_NAME, length: 255 )
• lake_name ( type: esriFieldTypeString, alias: LAKE_NAME, length: 255 )
• beach_name ( type: esriFieldTypeString, alias: BEACH_NAME, length: 255 )
• llid_stream_lake ( type: esriFieldTypeDouble, alias: LLID_STREAM_LAKE )
• llid_stream ( type: esriFieldTypeDouble, alias: LLID_STREAM )
• llid_lake ( type: esriFieldTypeDouble, alias: LLID_LAKE )
• epa_beach_id ( type: esriFieldTypeString, alias: EPA_BEACH_ID, length: 255 )
• segment_id ( type: esriFieldTypeDouble, alias: SEGMENT_ID )
• huc_4th_code ( type: esriFieldTypeString, alias: HUC_4TH_CODE, length: 255 )
• huc_4th_name ( type: esriFieldTypeString, alias: HUC_4TH_NAME, length: 255 )
• huc_3rd_name ( type: esriFieldTypeString, alias: HUC_3RD_NAME, length: 255 )
• miles ( type: esriFieldTypeString, alias: MILES, length: 255 )
• rm1 ( type: esriFieldTypeDouble, alias: RM1 )
• rm2 ( type: esriFieldTypeDouble, alias: RM2 )
• segment_miles ( type: esriFieldTypeDouble, alias: SEGMENT_MILES )
• pollutant ( type: esriFieldTypeString, alias: POLLUTANT, length: 255 )
• pollutant_id ( type: esriFieldTypeDouble, alias: POLLUTANT_ID )
• season ( type: esriFieldTypeString, alias: SEASON, length: 255 )
• season_id ( type: esriFieldTypeDouble, alias: SEASON_ID )
• assessment_year ( type: esriFieldTypeDouble, alias: ASSESSMENT_YEAR )
• assessment_date ( type: esriFieldTypeDate, alias: ASSESSMENT_DATE, length: 8 )
• action ( type: esriFieldTypeString, alias: ACTION, length: 255 )
• action_id ( type: esriFieldTypeDouble, alias: ACTION_ID )
• numeric_criteria_id ( type: esriFieldTypeDouble, alias: NUMERIC_CRITERIA_ID )
• affected_uses ( type: esriFieldTypeString, alias: AFFECTED_USES, length: 255 )
• listing_status ( type: esriFieldTypeString, alias: LISTING_STATUS, length: 255 )
• status_id ( type: esriFieldTypeDouble, alias: STATUS_ID )
• previous_status ( type: esriFieldTypeString, alias: PREVIOUS_STATUS, length: 255 )
• previous_action ( type: esriFieldTypeString, alias: PREVIOUS_ACTION, length: 255 )
• listing_year ( type: esriFieldTypeString, alias: LISTING_YEAR, length: 255 )
• tmdl_info ( type: esriFieldTypeString, alias: TMDL_INFO, length: 280 )
• criteria ( type: esriFieldTypeString, alias: CRITERIA, length: 254 )
• comments ( type: esriFieldTypeString, alias: COMMENTS, length: 674 )
• summary ( type: esriFieldTypeString, alias: SUMMARY, length: 5987 )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• st_length(shape) ( type: esriFieldTypeDouble, alias: st_length(shape) )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata