Nutrient Management Data Collection and Verification - PowerPoint Presentation

1. Nutrient Management Data Collection and Verification

2. Nutrient Management OverviewVerificationN/P RateN/P TimingN/P PlacementCB wide study determines verification rate for the year. Applied to all core CB acres.Adds additional N and P reduction credits to core acres.EnhancementsCore Acres (NM Plans)

3. Data Sources and BMP WarehouseNutMan 3 Database (Legacy)Nutrient Management Module Database (Current)Private Planner TablesVerification TablesActivity Report Verifications (Private)VerificationForms (DCR)Cost Share Data Entry:WFA1NM4 NM-5NNM-5P NM-3CBMP WarehouseCore SourcesVerification Sources* All data stored in SQL Server relational databaseEnhancement SourcesVerification TablesCoreEnhanced

4. VerificationsGoal is to verify 10% of all core acres reported in the Chesapeake Bay watershedPlans are verified upon plan renewal, revision, or modificationThird party validations are completed for 10% of the originally verified acres to ensure data integrityCompliance rate is calculated from all verified plansVerified acres are reported and the compliance rate is applied to all plans not verified and the resulting acres are then reported

5. Verifications and Acreage ReportedExample Scenario of Acreage Calculations for ReportingThere are 566,667 acres included in All NM plans66,667 total acres are included in verifications with 60,000 acres reported as “Yes” acres (11.8 % of total acres verified)This results in a 90% compliance rateThe 60,000 “Yes” acres from verifications are reported500,000 acres are included plans that were not verifiedThe 90% compliance rate is applied to the acres in those plans resulting in 450,000 acres to reportTotal acres reported is 510,000 (60,000 verified acres + 450,000 acres from non-verified plans)

6. Verification Data Collection ProcessVerification Table (SQL Server)VerificationForms / Activity ReportsData EntryQAQCData Collection ProcessDCR Planners and Third Party ValidatorsVerification form filled out with plan identifier added. Form scanned and sent to DSWC data servicesForms reviewed, QA/QC’d and data entry conducted to get all data into a centralized database.Private PlannersData entered on Verification Tab of Activity Report (Excel Spreadsheet)Data in Verification Tab reviewed by DSWC Data Services and entered into centralized databaseReporting RequirementsVerification must have been conducted during the current reporting period.Verification must have a corresponding active NM plan.Corresponding plan must be in the Chesapeake Bay watershed. * All data on verifications forms compared to original NM plans for accuracy

7. Verification Forms and Data EntryVerification Form Certification/Signature SectionVerification Database Example

8. Private Planner Activity ReportsVerificationsExcel Spreadsheet that contains tabs for:InstructionsPlanner InformationNutrient Management PracticesAcreageNitrate TestVerificationInformation is entered into Verification tab in spreadsheet from completed verification form

9. Enhanced NM Data – BMP TrackingBMP WarehouseBMP Tracking Data Entry:WFA1NM4 NM-5NNM-5P NM-3CETLData Collection ProcessData entered into BMP Tracking as part of a cost share BMP contract.DCR DSWC Data Services retrieves the data and processes it for submittal. * Procedures are run to prevent double counting.Data inserted into DEQ BMP Warehouse upload worksheet.Reporting RequirementsMust be in the Chesapeake BayMust have the same program year as current reporting yearAnnual practice so 100% verified as part of typical VACS process

10. Enhanced NM Data Source – NM-3CName of Practice: SIDEDRESS APPLICATION OF NITROGEN ON CORN AT THE 6-LEAF STAGE OR AT LEAST 15" IN HEIGHT DCR Specification for No. NM-3C A. Description and Purpose This practice will encourage the sidedress application of nitrogen (organic OR inorganic) on corn. For fields receiving only nitrogen fertilizer; sidedress applications will be based upon soil sample results and the Nutrient Management Plan (NMP). All secondary or sidedress applications will be applied at a growth stage (15" to 24" tall) when the plant is entering the highest demand for nitrogen.

11. Enhanced NM Data Source – NM-4Name of Practice: LATE WINTER SPLIT APPLICATION OF NITROGEN ON SMALL GRAINS DCR Specifications for No. NM-4 A. Description and Purpose Late winter split application of nitrogen on small grain consists of applying nitrogen during the late winter in two increments based on the progression of growth of the small grain crop.

12. Enhanced NM Data Source – NM-5NName of Practice: PRECISION NUTRIENT MANAGEMENT ON CROPLAND – NITROGEN APPLICATION DCR Specification for No. NM-5N A. Description and Purpose This practice will encourage the use of precision nutrient management practice components that support a higher intensity of nitrogen management in the field than existing standard nutrient management practices. This practice is limited to row crops, small grains and highly managed hayland (see glossary for definition) production systems.

13. Enhanced NM Data Source – NM-5PName of Practice: PRECISION NUTRIENT MANAGEMENT ON CROPLAND – PHOSPHORUS APPLICATION DCR Specification for No. NM-5P A. Description and Purpose This practice will encourage the use of precision nutrient management practice components that support a higher intensity of phosphorous management in the field than existing standard nutrient management practices.

14. Enhanced NM Data Source – WFA-1A. Description and Purpose The development of a practice to collect data, assure that implemented nutrient management plans are accurate and up to date, to minimize the impact of nutrients used in crop and highly managed hay production, and to provide for the establishment of vegetative cover on agricultural land for protection from erosion and the reduction of nutrient losses to groundwater. The Chesapeake Bay Program Watershed Model Phase 6.0 separates nutrient management into independent sets of practice elements for Nitrogen and Phosphorus, which stack onto a required core (Core Requirements) set of management elements; this practice is intended to enable reporting for each of these practice elements.In addition, the practice is also intended to offer financial assistance to agricultural producers to ensure implementation of core nutrient management requirements, support multiple enhanced nutrient management components such as precision nutrient management on cropland, and provide an incentive to keep a cover on agricultural land. Participants are provided an incentive to annually revise plans to accurately reflect field conditions so that farmers can maintain eligibility for other cost-share practices.

15. Enhanced NM Data Source – WFA-1A. Description and Purpose (continued)This practice bundles components of the following best management practices: NM-3C Split Application on Corn Using Pre-Sidedress Nitrate Test; NM-4 Late Winter Split Application of Nitrogen on Small Grains; NM-5N Precision Nutrient Management on Cropland – Nitrogen Application; NM-5P Precision Nutrient Management on Cropland – Phosphorus Application; SL-8 Protective Cover for Specialty Crops; SL-8B Small Grain and Mixed Cover Crop for Nutrient and Residue Management; SL-8H Harvestable Cover Crop; and WQ-4 Legume Based Cover Crop

16. Enhanced NM Data – Verification FormsData Collection ProcessVerification Forms filled out, scanned and sent to DSWC Data Services.Data entered into SQL Server DB.Data QA/QC’s and processed for BMP Warehouse submittal.Reporting RequirementsVerification must be conducted during reporting period.Corresponding plan must be active at least one day during reporting period.BMP WarehouseVerification FormETL

17. Enhanced NM Data – Verification Forms

18. Private Planner Activity Reports - VerificationsVerificationsInformation can be entered for enhanced nutrient management practices as entered on the full verification form

19. Enhanced Nitrogen SourcesN RateNM-3C + NM-4 + NM-5N + WFA-1 + Verifications N TimingNM-3C + NM-4 + WFA-1 + VerificationsN Placement =NM-5N + WFA-1 + Verifications

20. Enhanced Phosphorus SourcesP RateNM-5P + WFA-1 + Verifications P Timing VerificationsP Placement =NM-5P + WFA-1 + Verifications

21. DEQ BMP Warehouse SubmittalData is entered into agreed upon template for submittal to BMP WHDEQ and DCR staff coordinate on QA/QC of the submitted data in a test enviroment before official submittal through the NEIENKey DEQ staff were closely involved with reporting of NM reporting data and have the knowledge and expertise to QA/QC the submitted dataDEQ and DCR staff have monthly data coordination meetings in preparation for the yearly submittal