Parent Layer: Water Quality

Name: Water Quality Lakes

Display Field: stream_lake_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This feature contains a spatial representation of lakes, ponds, and reservoirs with water quality information from Oregon’s 2012 Integrated Report Assessment Database and 303(d). Water bodies in this feature are represented as polygons and the attribute table contains the assessment data associated with that water body. 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 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 2012 IR, and the schedule for future water quality integrated reports. http://www.deq.state.or.us/wq/assessment/assessment.htm. 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.38608541294E7
YMin: 5161015.474399999
XMax: -1.3029561508299999E7
YMax: 5808954.799000002
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: listing_status
Field 2: N/A
Field 3: N/A
Field Delimiter: ;
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Cat 5: Water quality limited, 303(d) list, TMDL needed
  Label: Cat 5: Water quality limited, 303(d) list, TMDL needed
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 255]
  Outline:
  N/A
• Value: Cat 4C: Water quality limited, not a pollutant
  Label: Cat 4C: Water quality limited, not a pollutant
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Cat 4B: Water quality limited, other control measures
  Label: Cat 4B: Water quality limited, other control measures
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Cat 4A: Water quality limited, TMDL approved
  Label: Cat 4A: Water quality limited, TMDL approved
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Cat 4: Water quality limited, TMDL not needed
  Label: Cat 4: Water quality limited, TMDL not needed
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 170, 0, 255]
  Outline:
  N/A
• Value: Cat 3: Insufficient data
  Label: Cat 3: Insufficient data
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [102, 153, 205, 255]
  Outline:
  N/A
• Value: Cat 3B: Insufficient data, potential concern
  Label: Cat 3B: Insufficient data, potential concern
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 190, 255]
  Outline:
  N/A
• Value: Cat 2: Attaining some criteria/uses
  Label: Cat 2: Attaining some criteria/uses
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [56, 168, 0, 255]
  Outline:
  N/A
• Value: Criteria change or use clarification
  Label: Criteria change or use clarification
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [245, 122, 182, 255]
  Outline:
  N/A
• Value: Inactive
  Label: Inactive
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [170, 102, 205, 255]
  Outline:
  N/A
• Value: No criteria
  Label: No criteria
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [215, 215, 158, 255]
  Outline:
  N/A
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_1 )
• 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_area(shape) ( type: esriFieldTypeDouble, alias: st_area(shape) )
• st_perimeter(shape) ( type: esriFieldTypeDouble, alias: st_perimeter(shape) )

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

  Iteminfo   Thumbnail   Metadata