Parent Layer: Water Quality

Name: Water Quality Streams (2010)

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 2010 Integrated Report Assessment Database and 303(d) List as approved by EPA on March 15, 2012. This feature should be used in conjunction with the feature ORLakesWaterQuality_2010. 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 2010 Integrated Report Assessment Database and 303(d) List are available on-line at www.deq.state.or.us/wq/assessment/rpt2010/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 2010 IR, and the schedule for future water quality integrated reports. www.deq.state.or.us/wq/assessment/assessment.htm. This feature does not include additions to the 303(d) list that were proposed by EPA in March 2012.A ReadMe file accompanies the geodatabase and users are encouraged to see the document for additional details. Metadata: http://oe.oregonexplorer.info/ExternalContent/metadata/waterqualitystreams.xml Download: http://navigator.state.or.us/sdl/data/mdb/k100/WQ_2010_Report.zip

Service Item Id: ddc345cb31a744b980fb5c1a9da6221e

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

Default Visibility: false

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.3864166308899999E7
YMin: 5143695.772699997
XMax: -1.2964640629099999E7
YMax: 5848554.038099997
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: 3
  Label: Cat 5: Water quality limted, TMDL needed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: 17
  Label: Cat 5: Water quality limted, 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: 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: 8
  Label: Unknown status ID (8, 10, 21)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 255]
  Width: 1
• Value: 10
  Label: Unknown status ID (8, 10, 21)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 255]
  Width: 1
• Value: 21
  Label: Unknown status ID (8, 10, 21)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 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: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• record_id ( type: esriFieldTypeSmallInteger, alias: record_id )
• stream_lake_name ( type: esriFieldTypeString, alias: Stream_Lake_Name, length: 120 )
• stream_name ( type: esriFieldTypeString, alias: Stream_Name, length: 60 )
• lake_name ( type: esriFieldTypeString, alias: Lake_Name, length: 60 )
• beach_name ( type: esriFieldTypeString, alias: Beach_Name, length: 80 )
• llid_stream_lake ( type: esriFieldTypeString, alias: LLID_Stream_Lake, length: 30 )
• llid_stream ( type: esriFieldTypeString, alias: LLID_Stream, length: 13 )
• llid_lake ( type: esriFieldTypeString, alias: LLID_Lake, length: 13 )
• epa_beach_id ( type: esriFieldTypeString, alias: EPA_Beach_ID, length: 8 )
• segment_id ( type: esriFieldTypeSmallInteger, alias: Segment_ID )
• huc_4th_code ( type: esriFieldTypeString, alias: HUC_4th_Code, length: 8 )
• 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: 20 )
• rm1 ( type: esriFieldTypeDouble, alias: RM1 )
• rm2 ( type: esriFieldTypeDouble, alias: RM2 )
• segmentmiles ( type: esriFieldTypeDouble, alias: SegmentMiles )
• pollutant ( type: esriFieldTypeString, alias: Pollutant, length: 50 )
• pollutant_id ( type: esriFieldTypeSmallInteger, alias: Pollutant_ID )
• season ( type: esriFieldTypeString, alias: Season, length: 50 )
• season_id ( type: esriFieldTypeSmallInteger, alias: Season_ID )
• summary ( type: esriFieldTypeString, alias: Summary, length: 2400 )
• assessment_id ( type: esriFieldTypeSmallInteger, alias: Assessment_ID )
• assessmentyear ( type: esriFieldTypeSmallInteger, alias: AssessmentYear )
• assessmentdate ( type: esriFieldTypeDate, alias: AssessmentDate, length: 8 )
• action ( type: esriFieldTypeString, alias: Action, length: 100 )
• action_id ( type: esriFieldTypeSmallInteger, alias: Action_ID )
• criteria ( type: esriFieldTypeString, alias: Criteria, length: 255 )
• affecteduses ( type: esriFieldTypeString, alias: AffectedUses, length: 255 )
• status_id ( type: esriFieldTypeSmallInteger, alias: Status_ID )
• previousstatus ( type: esriFieldTypeString, alias: PreviousStatus, length: 100 )
• previousaction ( type: esriFieldTypeString, alias: PreviousAction, length: 100 )
• tmdlinfo ( type: esriFieldTypeString, alias: TMDLInfo, length: 255 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 2400 )
• rf1 ( type: esriFieldTypeDouble, alias: RF1 )
• rf2 ( type: esriFieldTypeDouble, alias: RF2 )
• status ( type: esriFieldTypeString, alias: Status, length: 100 )
• criteria_id ( type: esriFieldTypeSmallInteger, alias: Criteria_ID )
• prevassessyear ( type: esriFieldTypeString, alias: PrevAssessYear, length: 100 )
• 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