Layer: SOW_Draft0 (ID:0)

View In: Map Viewer

Name: SOW_Draft0

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"SOW_Draft0","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
form_type (type: esriFieldTypeString, alias: Form Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [SIA: SIA], [FAAP: FAAP], [SOW: SOW], ... 1 more ...)
grantee (type: esriFieldTypeString, alias: Grantee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
grant_number (type: esriFieldTypeString, alias: Grant Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
reporting_period (type: esriFieldTypeString, alias: Reporting Period, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [R0: Report 0: Prior to July 2025], [R1: Report 1: July 1, 2025 - December 31, 2025], [R2: Report 2: January 1, 2026 - June 30, 2026], ... 2 more ...)
fund_amount (type: esriFieldTypeDouble, alias: Capacity Grant Amount, SQL Type: sqlTypeOther, nullable: true, editable: true)
grant_type (type: esriFieldTypeString, alias: Grant Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
reporting_period_from (type: esriFieldTypeDateOnly, alias: From:, SQL Type: sqlTypeOther, nullable: true, editable: true)
reporting_period_to (type: esriFieldTypeDateOnly, alias: To:, SQL Type: sqlTypeOther, nullable: true, editable: true)
intro_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
need1 (type: esriFieldTypeString, alias: Need a Trade/Table for this, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
partner_coordination_desc (type: esriFieldTypeString, alias: Describe the partner coordination activities that have occurred during the reporting period, including work with local, state and federal partners. List the partners that you actively collaborated with in the SIA., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
partner_coordination_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
task1_pct (type: esriFieldTypeInteger, alias: Estimated percent of budget for this task, SQL Type: sqlTypeOther, nullable: true, editable: true)
task1_budget (type: esriFieldTypeDouble, alias: Estimated budget for this task, SQL Type: sqlTypeOther, nullable: true, editable: true)
landowner_engage_events_sum (type: esriFieldTypeInteger, alias: # of events that actively engage ag landowners total, SQL Type: sqlTypeOther, nullable: true, editable: true)
landowner_participate_events_sum (type: esriFieldTypeInteger, alias: # of ag landowners participating in active events total, SQL Type: sqlTypeOther, nullable: true, editable: true)
landowner_provided_docs_sum (type: esriFieldTypeInteger, alias: # of ag landowners provided with brochures / fact sheets / mailings, etc total, SQL Type: sqlTypeOther, nullable: true, editable: true)
landowner_engagement_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ta_desc (type: esriFieldTypeString, alias: Describe the technical assistance activities that have occurred during the reporting period. Include activities directly related to the specific strategies and activities in the SIA technical assistance grant and in the AgWQM Area Plan and Area Rules., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
number_trades2 (type: esriFieldTypeSmallInteger, alias: Number of Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_ag_count (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_visits_count (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_submit_count (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_awards_count (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_conservation_plan_count (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_acre_count (type: esriFieldTypeInteger, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
ta_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
implementation_desc (type: esriFieldTypeString, alias: Describe the implementation activities that have occurred during the reporting period as a result of landowner engagement and technical assistance. Include activities directly related to the specific strategies and activities in the SIA technical assistance grant and in the AgWQM Area Plan and Area Rules. If no implementation activities have yet to occur in the SIA, please put N/A in the box below, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
implementation_date_count_calc (type: esriFieldTypeSmallInteger, alias: Number of Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
number_implemented_sum_calc (type: esriFieldTypeDouble, alias: Total Amount for All Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
implementation_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
monitor_first_meeting_date (type: esriFieldTypeDateOnly, alias: The Monitoring Lead convened its first Local Monitoring Team (LMT) meeting:, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_submit_mag_date (type: esriFieldTypeDateOnly, alias: Submitted, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_approved_mag_date (type: esriFieldTypeDateOnly, alias: Approved, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_submit_deq_date (type: esriFieldTypeDateOnly, alias: Submitted, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_approved_deq_date (type: esriFieldTypeDateOnly, alias: Approved, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_last_meeting_date (type: esriFieldTypeDateOnly, alias: The LMT has convened, most recent meeting:, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_deq_submit_date (type: esriFieldTypeDateOnly, alias: The Monitoring Lead submitted WQ monitoring data to DEQ following OWEB guidance and grant requirements, if applicable. Note: data can be submitted to DEQ annually or as it is collected throughout the project., SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_final_submission (type: esriFieldTypeDateOnly, alias: The Monitoring Lead submitted the final monitoring report to ODA:, SQL Type: sqlTypeOther, nullable: true, editable: true)
monitor_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
monitoring_report_desc (type: esriFieldTypeString, alias: If monitoring is in progress, please provide a brief description of activities for the year, or attach a monitoring report here. If monitoring has not started, or is finished, state N/A., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
monitoring_report_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ecological_goals_desc (type: esriFieldTypeString, alias: For the reporting period, describe how the work completed in the SIA will support future conservation actions to address impacts on Oregon's water quality standards and/or to address goals identified in salmonid conservation and recovery plans., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
ecological_goals_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
other_activities_desc (type: esriFieldTypeString, alias: Describe any workgroup participation, technical assistance, or other activities completed during the reporting period not directly related to agricultural water quality or implementation of the Area Plan. Must meet the purpose and requirements of Measure 76 (restore and protect natural resources, including fish and wildlife habitat and watersheds) and the SIA., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
other_activities_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
climate_change_desc (type: esriFieldTypeString, alias: ODA and OWEB are collecting information on grantee climate change efforts, as part of the state's response to the Governor's 2020 Climate Change Executive Order (EO 20-04, www.oregon.gov/gov/Pages/carbonpolicy_climatechange.aspx). Identify any activities during the reporting period that were intended to help landowners or communities adapt to climate change or mitigate climate change impacts, or to incorporate climate considerations into conservation planning., SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
climate_change_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
adaptive_effectiveness (type: esriFieldTypeString, alias: Were you able to effectively address the water quality parameters of concern(s) identified in the beginning of the SIA?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_methods (type: esriFieldTypeString, alias: What methods and messages were the most effective at engaging landowners?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_changes (type: esriFieldTypeString, alias: What would you change about the landowner engagement approach for the next SIA?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_area_plan (type: esriFieldTypeString, alias: Did you include information from the Area Plan or Area Rules in your landowner engagement efforts? Why or why not?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_tmdl (type: esriFieldTypeString, alias: Did you include information from TMDLs in your landowner engagement efforts? Why or why not?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_other_parameters (type: esriFieldTypeString, alias: Is there anything else you would like ODA to know about your experience addressing ag water quality parameters of concern with SIA funds?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptive_efforts (type: esriFieldTypeString, alias: Anything else to note about this year's efforts and projects?, SQL Type: sqlTypeOther, length: 2500, nullable: true, editable: true)
adaptivemanagement_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
signature_name (type: esriFieldTypeString, alias: Grantee Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
signed_date (type: esriFieldTypeDateOnly, alias: Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
signature_qc (type: esriFieldTypeString, alias: Reviewer Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
status (type: esriFieldTypeString, alias: What is the status of your SIA form?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ready for Review: Ready for Review], [In-Progress: In-Progress])
reviewer_status (type: esriFieldTypeString, alias: Status marked by reviewer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Complete: Complete], [Ready for Review: Ready for Review], [Needs Re-Review: Needs Re-Review])
uniqueidentifier (type: esriFieldTypeString, alias: SIA Form Reference ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Relationships:

SOW_Draft0_primary_focus (1) -- Related To: primary_focus (1)
SOW_Draft0_task1_narrative (2) -- Related To: task1_narrative (2)
SOW_Draft0_events_and_materials (3) -- Related To: events_and_materials (3)
SOW_Draft0_technical_assistance_repeat (4) -- Related To: technical_assistance_repeat (4)
SOW_Draft0_implementation_repeat (5) -- Related To: implementation_repeat (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/29/2025 10:36:11 PM

Schema Last Edit Date: 1/29/2025 10:36:11 PM

Data Last Edit Date: 12/27/2024 12:50:46 AM

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