Name: OWRI
Display Field: activity_type
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description: The Oregon Watershed Restoration Inventory database (OWRI) contains information about completed restoration projects that were implemented in Oregon beginning in 1995. The complete dataset consists of point, line, and polygon features. Data for projects not funded by the Oregon Watershed Enhancement Board (OWEB) are acquired through a voluntary "Annual Call for Data"; while reporting is required for projects funded by OWEB and Oregon Department of Fish and Wildlife R & E grant programs. Restoration practitioners submit a standardized reporting form and attach project location maps. Once acquired, data sheets and maps are each assigned a unique project identification number. This number links spatial project data with tabular project data that are stored in a relational database using Microsoft SQL software.
Copyright Text: Oregon Watershed Enhancement Board
Min. Scale: 299999
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -13866388.7758912
YMin: 5160446.5883
XMax: -12965632.6195
YMax: 5825640.65395012
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"activity_type","uniqueValueGroups":[{"heading":"activity_type","classes":[{"label":"Combined","description":"Combined","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,117,225,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":1}},"values":[["Combined"]]},{"label":"Estuarine","description":"Estuarine","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[116,161,50,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[117,163,49,255],"width":1}},"values":[["Estuarine"]]},{"label":"Fish Passage","description":"Fish Passage","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,0,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1}},"values":[["Fish Passage"]]},{"label":"Fish Screening","description":"Fish Screening","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,172,230,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,169,230,255],"width":1}},"values":[["Fish Screening"]]},{"label":"Instream","description":"Instream","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,0,166,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[132,0,168,255],"width":1}},"values":[["Instream"]]},{"label":"Instream Flow","description":"Instream Flow","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[195,0,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":1}},"values":[["Instream Flow"]]},{"label":"Riparian","description":"Riparian","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,115,75,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,115,75,255],"width":1}},"values":[["Riparian"]]},{"label":"Road","description":"Road","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[204,104,104,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[205,103,103,255],"width":1}},"values":[["Road"]]},{"label":"Upland","description":"Upland","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,170,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,170,0,255],"width":1}},"values":[["Upland"]]},{"label":"Urban","description":"Urban","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[176,176,176,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":1}},"values":[["Urban"]]},{"label":"Wetland","description":"Wetland","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[165,255,117,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[163,255,115,255],"width":1}},"values":[["Wetland"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,117,225,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":1}},"value":"Combined","label":"Combined"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[116,161,50,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[117,163,49,255],"width":1}},"value":"Estuarine","label":"Estuarine"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,0,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1}},"value":"Fish Passage","label":"Fish Passage"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,172,230,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,169,230,255],"width":1}},"value":"Fish Screening","label":"Fish Screening"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[130,0,166,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[132,0,168,255],"width":1}},"value":"Instream","label":"Instream"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[195,0,255,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":1}},"value":"Instream Flow","label":"Instream Flow"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[0,115,75,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[0,115,75,255],"width":1}},"value":"Riparian","label":"Riparian"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[204,104,104,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[205,103,103,255],"width":1}},"value":"Road","label":"Road"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[255,170,0,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[255,170,0,255],"width":1}},"value":"Upland","label":"Upland"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[176,176,176,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":1}},"value":"Urban","label":"Urban"},{"symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[165,255,117,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[163,255,115,255],"width":1}},"value":"Wetland","label":"Wetland"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[68,157,171,255],"toColor":[68,157,171,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[196,41,46,255],"toColor":[196,41,46,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[82,42,201,255],"toColor":[82,42,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[48,201,42,255],"toColor":[48,201,42,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,168,48,255],"toColor":[201,168,48,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[166,53,128,255],"toColor":[166,53,128,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[48,100,191,255],"toColor":[48,100,191,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[49,153,89,255],"toColor":[49,153,89,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[156,97,58,255],"toColor":[156,97,58,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[136,176,62,255],"toColor":[136,176,62,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[163,81,201,255],"toColor":[163,81,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,66,90,255],"toColor":[184,66,90,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[52,74,199,255],"toColor":[52,74,199,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: true
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: activity_type
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- project_nbr (type: esriFieldTypeInteger, alias: project_nbr, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ri_project_id (type: esriFieldTypeInteger, alias: ri_project_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- activity_type (type: esriFieldTypeString, alias: activity_type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Estuarine: Estuarine], [Combined: Combined], [Instream: Instream], ... 8 more ...)
- ORIG_FID (type: esriFieldTypeInteger, alias: ORIG_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- region (type: esriFieldTypeString, alias: region, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- watershed (type: esriFieldTypeString, alias: watershed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- subwatershed (type: esriFieldTypeString, alias: subwatershed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- report_basin (type: esriFieldTypeString, alias: report_basin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county (type: esriFieldTypeString, alias: county, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_nbr_1 (type: esriFieldTypeInteger, alias: project_nbr_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
- project_name (type: esriFieldTypeString, alias: project_name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- basin_actual (type: esriFieldTypeString, alias: basin_actual, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- tributary_of (type: esriFieldTypeString, alias: tributary_of, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- subbasin_actual (type: esriFieldTypeString, alias: subbasin_actual, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- township (type: esriFieldTypeString, alias: township, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- range (type: esriFieldTypeString, alias: range, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- section (type: esriFieldTypeString, alias: section, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- start_year (type: esriFieldTypeInteger, alias: start_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- complete_year (type: esriFieldTypeInteger, alias: complete_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- stream_name (type: esriFieldTypeString, alias: stream_name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- drvd_oweb_num (type: esriFieldTypeString, alias: drvd_oweb_num, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- drvd_project_description (type: esriFieldTypeString, alias: drvd_project_description, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
- total_cash (type: esriFieldTypeDouble, alias: total_cash, SQL Type: sqlTypeOther, nullable: true, editable: true)
- total_inkind (type: esriFieldTypeDouble, alias: total_inkind, SQL Type: sqlTypeOther, nullable: true, editable: true)
- project_site_selection (type: esriFieldTypeString, alias: project_site_selection, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- project_id (type: esriFieldTypeInteger, alias: project_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LINK (type: esriFieldTypeString, alias: LINK, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- project_nbr_12 (type: esriFieldTypeInteger, alias: project_nbr_12, SQL Type: sqlTypeOther, nullable: true, editable: true)
- watershed_councils (type: esriFieldTypeString, alias: watershed_councils, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
- Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Types:
ID: Combined
Name: Combined
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Combined
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Estuarine
Name: Estuarine
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Estuarine
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Fish Passage
Name: Fish Passage
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Fish Passage
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- activity_type: Fish Passage
ID: Fish Screening
Name: Fish Screening
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Fish Screening
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- activity_type: Fish Screening
ID: Instream
Name: Instream
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Instream
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Instream Flow
Name: Instream Flow
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Instream Flow
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Attributes:
- activity_type: Instream Flow
ID: Riparian
Name: Riparian
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Riparian
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Road
Name: Road
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Road
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Upland
Name: Upland
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Upland
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Urban
Name: Urban
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Urban
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
ID: Wetland
Name: Wetland
Domains:
- Field Name: activity_type
Inherited
Templates:
Name: Wetland
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/22/2024 10:08:30 PM
Schema Last Edit Date: 10/22/2024 10:08:30 PM
Data Last Edit Date: 9/4/2024 8:33:58 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat