Layer: OR_Streams_WaterQualityLimited

View In: Map Viewer

Name: OR_Streams_WaterQualityLimited_2012

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.

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

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,85,0,255],"width":1.5}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ASSESSMENT_ID (type: esriFieldTypeDouble, alias: ASSESSMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
RECORD_ID (type: esriFieldTypeDouble, alias: RECORD_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREAM_LAKE_NAME (type: esriFieldTypeString, alias: STREAM_LAKE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREAM_NAME (type: esriFieldTypeString, alias: STREAM_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
POLLUTANT (type: esriFieldTypeString, alias: POLLUTANT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SEASON (type: esriFieldTypeString, alias: SEASON, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SUMMARY (type: esriFieldTypeString, alias: SUMMARY, SQL Type: sqlTypeOther, length: 5987, nullable: true, editable: true)
LAKE_NAME (type: esriFieldTypeString, alias: LAKE_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BEACH_NAME (type: esriFieldTypeString, alias: BEACH_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LLID_STREAM_LAKE (type: esriFieldTypeString, alias: LLID_STREAM_LAKE, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
LLID_STREAM (type: esriFieldTypeString, alias: LLID_STREAM, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
LLID_LAKE (type: esriFieldTypeString, alias: LLID_LAKE, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
EPA_BEACH_ID (type: esriFieldTypeString, alias: EPA_BEACH_ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SEGMENT_ID (type: esriFieldTypeDouble, alias: SEGMENT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
HUC_4TH_CODE (type: esriFieldTypeString, alias: HUC_4TH_CODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HUC_4TH_NAME (type: esriFieldTypeString, alias: HUC_4TH_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HUC_3RD_NAME (type: esriFieldTypeString, alias: HUC_3RD_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MILES (type: esriFieldTypeString, alias: MILES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
RM1 (type: esriFieldTypeDouble, alias: RM1, SQL Type: sqlTypeOther, nullable: true, editable: true)
RM2 (type: esriFieldTypeDouble, alias: RM2, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEGMENT_MILES (type: esriFieldTypeDouble, alias: SEGMENT_MILES, SQL Type: sqlTypeOther, nullable: true, editable: true)
POLLUTANT_ID (type: esriFieldTypeDouble, alias: POLLUTANT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
SEASON_ID (type: esriFieldTypeDouble, alias: SEASON_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ASSESSMENT_YEAR (type: esriFieldTypeDouble, alias: ASSESSMENT_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
ASSESSMENT_DATE (type: esriFieldTypeDate, alias: ASSESSMENT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ACTION (type: esriFieldTypeString, alias: ACTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ACTION_ID (type: esriFieldTypeDouble, alias: ACTION_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
NUMERIC_CRITERIA_ID (type: esriFieldTypeDouble, alias: NUMERIC_CRITERIA_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
AFFECTED_USES (type: esriFieldTypeString, alias: AFFECTED_USES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LISTING_STATUS (type: esriFieldTypeString, alias: LISTING_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STATUS_ID (type: esriFieldTypeDouble, alias: STATUS_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PREVIOUS_STATUS (type: esriFieldTypeString, alias: PREVIOUS_STATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PREVIOUS_ACTION (type: esriFieldTypeString, alias: PREVIOUS_ACTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LISTING_YEAR (type: esriFieldTypeString, alias: LISTING_YEAR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TMDL_INFO (type: esriFieldTypeString, alias: TMDL_INFO, SQL Type: sqlTypeOther, length: 280, nullable: true, editable: true)
CRITERIA (type: esriFieldTypeString, alias: CRITERIA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 674, nullable: true, editable: true)
Shape__Length0 (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/4/2023 7:33:25 PM

Schema Last Edit Date: 10/4/2023 7:33:25 PM

Data Last Edit Date: 10/4/2023 7:33:25 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: OR_Streams_WaterQualityLimited_2012 (ID:0)