Exporting CNMP data to MMP

From Wikiagro.com
Jump to: navigation, search

{{#customtitle: Exporting CNMP data to MMP}}

This exercise is included in the tutorial: GeoAgro for CNMP Development

In this learning guide you will learn how to export data from either GeoAgro CPlanner or GeoAgro GIS into MMP.
Note Note: To run through this learning guide, you need first to download sample data from this link and open the project 'Sample CNMP' as indicated there

Note Note: You will also need to have previously completed this learning guide to calculate the Spreadable Acreage . If you have not completed it, you may download the Spreadable Acreage from this link and import it into your project using the Restore tool

Note Note: this learning guide assumes that the user has working knowledge of Manure Management Planner, developed by Purdue University. For more information, please visit http://www.agry.purdue.edu/mmp/.

Exercises

Throgh these exercises you'll learn how to select, review and export data to use it in Manure Management Planner from Purdue University.

Exercise 01 - Export from GeoAgro CPlanner

Review your Customer Folder information

To access your customer folder you need to follow this learning guide: Download your customer folders


Export Plan data (XML format)

  1. Click on the Export to Tool, Image:Cplanner_Reference_29.jpgselect the XML option

  2. Save to your local disk
    Image:Export_to_MMP_01.jpg

  3. The xml  is saved to a directory 'SessionExportData'
    Image:Export_to_MMP_02.jpg


Import into MMP

  1. Open MMP
    Image:Export_to_MMP_03.jpg

  2. If you haven't created an MMP Plan, use the 'New' option to create a new plan. Let's create a Plan in Iowa.
    Image:Export_to_MMP_04.jpg

  3. Go to the Tools -> Import -> Import Toolkit Customer File option to import the plan.
    Image:Export_to_MMP_05.jpg

  4. Select the XML file that you have previously generated. Make sure that you look for the file inside theSessionExportData directory
    Image:Export_to_MMP_06.jpg

  5. You can Select which Conservation Plan would you like to import (you can select more than one by holding the SHIFT key)
    Image:Export_to_MMP_07.jpg

  6. The Plan is imported into MMP
    Image:Export_to_MMP_08.jpg



Exercise 02 - Export from GeoAgro GIS

Review soils information

GIS gis Init 03 01.jpg

Start GeoAgro GIS by double clicking on its icon at your desktop;
You may also run it by using the Windows® Start menu.
The Project Selection window will pop up. Select the "Sample CNMP" project that you restored from Sample Data CNMP


First, let's review soils in our sample farm.

  1. Click on the “Soils” layer in the References Panel to make it active.
    Image:LG_cnmp_gis2mmp_01.png

  2. Select soil map units by clicking on the Rectangle Selection Image:GIS_gis_Navi_01c_01.jpg tool on the left of the Navigation Toolbar, and drawing a window to include them.
    Image:LG_cnmp_gis2mmp_06.png

    click here to see full size

  3. Click on the Information Image:GIS_gis_Navi_07_01.jpg tool icon.

    Image:LG_cnmp_gis2mmp_07.png

  4. Once the information table is shown, click on Export, save it to your local disk, and the excel spreadsheet will be created.

    Image:GIS_gis_Navi_07c_01.jpg
    You can delete there the unwanted columns.

    Image:LG_cnmp_gis2mmp_08.png


According to the soils map, we’ll choose the following as predominant soil map units for each field, for use in MMP:

Field Name

MUSYM

MUNAME

T19-3

638C2

Clarion-Storden loams, 5 to 9 percent slopes, moderately eroded

T19-4

138B

Clarion loam, 2 to 5 percent slopes

T19-5

507

Canisteo silty clay loam, 0 to 2 percent slopes



Review spreadable acreage area and update Fields information

Now let's review the spreadable acreage that we defined in this learning guide to calculate the Spreadable Acreage. If you have not completed it, you may download the Spreadable Acreage from this link and import it into your project using the Restore tool

 

Let’s see what the spreadable acreage area for each of our fields is.

  1. Make sure that the Layer 'Spreadable Acreage' is active by clicking on it
    Image:Layer_Spreadable_Acreage.png

  2. Select the two spreadable acreage areas, using available Selection tools.

  3. Click on the Info tool Image:GIS_gis_Navi_07_01.jpg in the Navigation toolbar and the spreadable acreage for both fields will be shown.

    click here to see full size 

 

Now we are going to update required values in the 'Fields_NRCS' layer to export to MMP

  1. Make sure that the Layer 'Fields_NRCS' is active by clicking on it
    Image:Layer_Fields_NRCS.jpg

  2. Select the three Fields where we will enter information, using available Selection tools.

  3. Click on the Info tool Image:GIS_gis_Navi_07_01.jpg. When you click on each record, the corresponding field is highlighted in red.

  4. Update fields 'FLD_NAME', SPRD_ACRE' with the information shown in the table and screen below:
FIELD_NAME SPRD_ACRE
19-3 120.30
19-4 2.13
click here to see full size

 

Export data (dbf format)

  1. Select the “Fields_NRCS” layer.
    Image:LG_cnmp_bs_13.png

  2. Select the two Fields that we will export by using the Select by Rectangle Image:GIS_gis_Navi_01c_01.jpg tool or other selection options.Image:LG_cnmp_gis2mmp_11.png

  3. Click on the Export Data Image:GIS_gis_Edit_08_01.jpg tool from the Edition panel, then on Export selected objects
    Image:LG_cnmp_gis2mmp_12.png

  4. The Export window is shown; optionally you can check only the attributes that you want to export. If you export more attributes than those needed by MMP is fine; it will import only the compatible attributes: FIELD_NAME, SUBFLD_NAM, SPRD_ACRE, and ACRES
    Image:LG_cnmp_gis2mmp_13.png
    Please Note:it’s very important to uncheck the attribute “Area (ac.)” as shown in figure below, otherwise MMP may confuse this attribute (as-drawn fields area) with ‘ACRES’ (NRCS defined fields area).

  5. Click on Accept, choose the saving location, and the fields will be exported to a “Fields” shape file in your local disk. Please note that as part of the shape file, a “Fields.dbf” file is generated, which will be used by MMP to import the information.

Import into MMP and enter remaining data

  1. Go to Start menu, and open MMP

    Image:LG_cnmp_gis2mmp_14.png

  2. Click on “New”, Create a new project in Iowa.

    LG cnmp gis2mmp 15.png

    During plan creation, make sure that you set the County in the General tab, so the soils list will be available later on.
  3. To import the fields into mmp:
    Go to ToolsImport tab → Import dbase Field data file.

    LG cnmp gis2mmp 16.png

  4. Look for the “Fields.dbf” file recently created.

    LG cnmp gis2mmp 17.png

  5. The file is imported, and the field data is shown in MMP. Please note that there may be warning errors if Fields.dbf contains more attributes than what MMP needs, but it does not affect the import of the relevant attributes.

    Image:LG_cnmp_gis2mmp_18.png

  6. Enter remaining data in MMP, and work on the conservation plan.
    As mentioned in the introduction, this learning guide assumes that the user has working knowledge of Manure Management Planner, developed by Purdue University. For more information, please visit http://www.agry.purdue.edu/mmp/.
    Enter the operation's production data in MMP. This includes field, soils, soil tests, crop, storage, animal, equipment and other data provided by the producer.
    As part of the plan development you will verify erosion conditions running RUSLE2, and any state-specific phosphorus index or other risk assessment tools.
    After your field assessment and running MMP, you will identify which conservation practices are needed to meet, for instance State requirements, NRCS soil loss “T” Limits or program requirements.

In this learning guide we will draw these conservation practices and upload them to the NRCS Conservation Planning database.