Exporting CNMP data to MMP

From Wikiagro.com

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:

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:

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:

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)

Click on the Export to Tool, select the XML option
Save to your local disk
The xml is saved to a directory 'SessionExportData'

Import into MMP

Open MMP
If you haven't created an MMP Plan, use the 'New' option to create a new plan. Let's create a Plan in Iowa.
Go to the Tools -> Import -> Import Toolkit Customer File option to import the plan.
Select the XML file that you have previously generated. Make sure that you look for the file inside theSessionExportData directory
You can Select which Conservation Plan would you like to import (you can select more than one by holding the SHIFT key)
The Plan is imported into MMP

Exercise 02 - Export from GeoAgro GIS

Review soils information

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.

Click on the “Soils” layer in the References Panel to make it active.
Select soil map units by clicking on the Rectangle Selection tool on the left of the Navigation Toolbar, and drawing a window to include them.
Click on the Information tool icon.
Once the information table is shown, click on Export, save it to your local disk, and the excel spreadsheet will be created.

You can delete there the unwanted columns.

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.

Make sure that the Layer 'Spreadable Acreage' is active by clicking on it
Select the two spreadable acreage areas, using available Selection tools.
Click on the Info tool in the Navigation toolbar and the spreadable acreage for both fields will be shown.

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

Make sure that the Layer 'Fields_NRCS' is active by clicking on it
Select the three Fields where we will enter information, using available Selection tools.
Click on the Info tool . When you click on each record, the corresponding field is highlighted in red.
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

Export data (dbf format)

Select the “Fields_NRCS” layer.
Select the two Fields that we will export by using the Select by Rectangle tool or other selection options.
Click on the Export Data tool from the Edition panel, then on Export selected objects
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

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).
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

Go to Start menu, and open MMP
Click on “New”, Create a new project in Iowa.

During plan creation, make sure that you set the County in the General tab, so the soils list will be available later on.
To import the fields into mmp:
Go to Tools → Import tab → Import dbase Field data file.
Look for the “Fields.dbf” file recently created.
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.
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.