Parent Layer: Water Quality

Name: Water Quality Lakes (2010)

Display Field: stream_lake_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature contains a spatial representation of lakes, ponds, and reservoirswith water quality information from Oregon’s 2010 Integrated Report Assessment Database and 303(d) List as approved by EPA on March 15, 2012. Water bodies in this feature are represented as points at the centroid of a polygon and the attribute table contains the assessment data associated with that water body. Spatial information for the water bodies as polygons is provided in the feature ORLakesAssessed_2010. These features should be used in conjunction with the feature ORStreamsWaterQuality_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 this geodatabase, 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. This layer 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/waterqualitylakes.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.39483687764E7
YMin: 5107914.853799999
XMax: -1.3049574238E7
YMax: 5807873.126699999
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 limited, TMDL needed
  Description: N/A
  Symbol:
  
• Value: 17
  Label: Cat 5: Water quality limited, TMDL needed
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Cat 4: Water quality limited, TMDL not needed
  Description: N/A
  Symbol:
  
• Value: 14
  Label: Cat 4A: Water quality limited, TMDL approved
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Cat 4A: Water quality limited, TMDL approved
  Description: N/A
  Symbol:
  
• Value: 15
  Label: Cat 4B: Water quality limited, other pollution control requirements are expected to address all pollutants
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Cat 3: Insufficient data
  Description: N/A
  Symbol:
  
• Value: 13
  Label: Cat 3: Insufficient data
  Description: N/A
  Symbol:
  
• Value: 19
  Label: Cat 3B: Insufficient data, potential concern
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Cat 3B: Insufficient data, potential concern
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Cat 2: Attaining, specific water quality standards are met
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Cat 2: Attaining, specific water quality standards are met
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Unknown status ID (10, 21)
  Description: N/A
  Symbol:
  
• Value: 21
  Label: Unknown status ID (10, 21)
  Description: N/A
  Symbol:
  
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: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• record_id ( type: esriFieldTypeInteger, alias: Record_ID )
• stream_lake_name ( type: esriFieldTypeString, alias: Stream_Lak, length: 254 )
• stream_name ( type: esriFieldTypeString, alias: Stream_Nam, length: 254 )
• lake_name ( type: esriFieldTypeString, alias: Lake_Name, length: 254 )
• llid_stream_lake ( type: esriFieldTypeString, alias: LLID_Strea, length: 100 )
• llid_stream ( type: esriFieldTypeString, alias: LLID_Str_1, length: 254 )
• llid_lake ( type: esriFieldTypeString, alias: LLID_Lake, length: 15 )
• segment_id ( type: esriFieldTypeInteger, alias: Segment_ID )
• huc_4th_code ( type: esriFieldTypeString, alias: HUC_4th_Co, length: 254 )
• huc_4th_name ( type: esriFieldTypeString, alias: HUC_4th_Na, length: 254 )
• huc_3rd_name ( type: esriFieldTypeString, alias: HUC_3rd_Na, length: 254 )
• miles ( type: esriFieldTypeString, alias: Miles, length: 24 )
• rm1 ( type: esriFieldTypeDouble, alias: RM1 )
• rm2 ( type: esriFieldTypeDouble, alias: RM2 )
• segmentmiles ( type: esriFieldTypeDouble, alias: SegmentMil )
• pollutant ( type: esriFieldTypeString, alias: Pollutant, length: 50 )
• pollutant_id ( type: esriFieldTypeInteger, alias: Pollutant_ )
• season ( type: esriFieldTypeString, alias: Season, length: 50 )
• season_id ( type: esriFieldTypeInteger, alias: Season_ID )
• summary ( type: esriFieldTypeString, alias: Summary, length: 254 )
• assessment_id ( type: esriFieldTypeInteger, alias: Assessment )
• assessmentyear ( type: esriFieldTypeInteger, alias: Assessme_1 )
• assessmentdate ( type: esriFieldTypeDate, alias: Assessme_2, length: 8 )
• action ( type: esriFieldTypeString, alias: Action, length: 100 )
• action_id ( type: esriFieldTypeInteger, alias: Action_ID )
• criteria ( type: esriFieldTypeString, alias: Criteria, length: 254 )
• criteria_id ( type: esriFieldTypeInteger, alias: Criteria_I )
• affecteduse ( type: esriFieldTypeString, alias: AffectedUs, length: 254 )
• status ( type: esriFieldTypeString, alias: Status, length: 100 )
• status_id ( type: esriFieldTypeInteger, alias: Status_ID )
• previousstatus ( type: esriFieldTypeString, alias: PreviousSt, length: 100 )
• previousaction ( type: esriFieldTypeString, alias: PreviousAc, length: 100 )
• prevassessyear ( type: esriFieldTypeString, alias: PrevAssess, length: 100 )
• tmdlinfo ( type: esriFieldTypeString, alias: TMDLInfo, length: 254 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 254 )
• lakeacres ( type: esriFieldTypeDouble, alias: LakeAcres )
• shorelinemiles ( type: esriFieldTypeDouble, alias: ShorelineM )
• source ( type: esriFieldTypeString, alias: Source, length: 20 )
• huc_3rd_code ( type: esriFieldTypeString, alias: HUC_3rd_Co, length: 6 )
• shoreline_ft ( type: esriFieldTypeDouble, alias: Shoreline_ )
• sqmiles ( type: esriFieldTypeDouble, alias: SQMiles )
• longitude_dms ( type: esriFieldTypeString, alias: Long_DMS, length: 20 )
• latitude_dms ( type: esriFieldTypeString, alias: Lat_DMS, length: 20 )
• longitude_dd ( type: esriFieldTypeDouble, alias: Long_DD )
• latitude_dd ( type: esriFieldTypeDouble, alias: Lat_DD )
• shape ( type: esriFieldTypeGeometry, alias: shape )

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

  Iteminfo   Thumbnail   Metadata