The default location for the Arcmap Link database (arcmap_link.mdb file) should be C:\pedon\arcmap_link.mdb.
It could be located anywhere, but it is recommended that it be stored at the above path.
Open an existing ArcMap project file (.mxd) for your survey area. If needed, rename your soils polygon layer to “soilpolygons”. This is the default name used by the models listed below.
If you have not already added the Analysis_PC toolbox, then unzip the Analysis_PC.tbx toolbox file to the folder where your toolboxes reside. (Normally C:\Documents and Settings\your.name\Application Data\ESRI\ArcToolbox\My Toolboxes or C:\arcgis\arcexe9x\toolboxes\)
Click on the ArcToolbox button to open ArcToolbox.
Right click the ArcToolbox folder and select Add Toolbox.
Browse to the Analysis_PC toolbox in the folder where your toolboxes reside.
Click on the Add Data button in ArcMap and add the table named tAnalyzeSpatial from the arcmap_link.mdb file. Browse to the database and then browse to this specific table to add it to your project.
Open up the 1_Setup Toolset and open the Setup for Point Layer model by double clicking on it.
This model will create an XY displayed point layer of the tAnalyzeSpatial table called tAnalyzeSpatial Events layer.
If you are displaying points across more than one UTM zone, then display the points using a geographic coordinate system and the settings shown.
Keep in mind that you need to have the lat/long data populated in the site table or have the values calculated by the Drill Down form and populated in the SiteNAD83 table in order for the records to be displayed.
You may also use utmeastings (X field) and utmnorthings (Y field) for your UTM zone, if you are displaying all of your points within one UTM zone.
Notice after running the model that the tAnalyzeSpatial Events layer was added to your project.
Now open Pedon PC Plus; click on the Analysis Tools Menu then on Drill Down Analysis to open the Drill Down form.
Clean out any existing coordinate data from your Arcmap_Link database.
Click on the Empty SiteNad83 button then click OK in the dialogue box that appears.
Close the Drill Down Form and then reopen it or click the Spatial Refresh button and then click the Filter button.
The dialogue box that appears will ask if you want to let Access calculate decimal degree information. Click YES. The Drill Down form will now open.
Click the Spatial Refresh button; this will enable the refresh of tAnalyzeSpatial with the currently filtered records each time the filter button is clicked.
Now click on the Filter button to show all of the records (all your points should now be in your ArcMap project in the tAnalyzeSpatial Events layer).
Now go back over to your ArcMap project and click the Refresh button to update the display. Your points should appear once ArcMap refreshes the view.
Now go back to the Drill Down form in Pedon PC Plus and make a selection from values in the list of soil name as sampled.
Notice that the value selected goes up into the filter box.
Click the Filter button again to limit to the selection.
Now go back to your ArcMap project and click the Refresh button.
Notice that the display of points tracks the records that are currently filtered in the Drill Down form.
To label the points to reflect the currently selected field:
Right click the tAnalyzeSpatial Events layer and go to Properties and then click on the labels tab.
Select Field1 as the Label Field and click OK.
Field1 is a generic field that is passed to the tAnalyzeSpatial table from the currently selected field on the Drill Down form each time the filter button is pressed.
Labels will track the currently selected field in the Drill Down form.
If you want to show both the currently selected field (Field1) and the user site ID in a concatenated string, you can enter the following script as the text string expression for the Label Field on the Label tab: [Field1] & vbcrlf & [usiteid]
Now for the polygon side of things
Click the Add Data button and add the polygon_selected_PPC table from the arcmap_link.mdb file on your system.
The Workspace Legend form can be linked to the soil polygons layer through the polygon_selected_PPC table.
By joining the Workspace Legend form with the soil polygon layer you can take advantage of the powerful selection process built into the form.
Before we get into setting up the join from this table to the soil polygon layer, we need to create some reference layers from your existing soil polygon layer
These layers exist only in the ArcMap project, not in the geodatabase, and are named with a standard convention that is referenced by the models in the Analysis_PC toolbox.
To create a soil_a and soil_a_selected layers within your ArcMap project.
Check to make sure your soil polygon layer has been added to your project.
Right click and copy the soil polygon layer and paste it to the Layers in the table of contents of your project.
Rename the layer you just pasted as soil_a.
Repeat the same steps and copy the soil polygons layer to your project layers again, only this time name the layer soil_a_selected.
Creating the join between the polygon_selected_PPC table and the soil_a_selected layer
Right click the soil_a_selected layer and go to Joins and Relates then Join.
Select the OBJECTID field from your soil_a_selected, select the polygon_selected_PPC table as the table to join to the layer, and then choose the OBJECTID field as the join field. Click OK.
Right click the soil_a_selected layer and go to Properties and then click on the Definition Query tab.
Enter the following statement as shown: polygon_selected_PPC.OBJECTID is not null
The definition query will restrict the display of only the polygons participating in the join between the polygon_selected_PPC table and the soil_a_selected polygon layer. You may also accomplish this by making the join exclusive by clicking on Keep Matching Records Only in the advanced join options.
In order to use the spatial linkage between the Workspace Legend form and ArcMap, we need to intersect the documentation points with the soil_a polygon map unit symbols in which they occur.
The form joins the point documentation with the polygon map unit symbols through an intersect table that is generated from ArcMap.
To create this intersect table, we will make a selection of points and run a model from the 4_Point & Polygon Analysis toolset in the Analysis_PC toolbox called Export Polygons And Points.
The Workspace Legend form depends on their being a MUSYM field and a Shape_Acres field in your soil polygon layer. If these fields are not present in your soil polygon layer, add them by adding these fields and calculating them based on your existing fields or simply renaming the corresponding fields in your soil polygon layer.
Set your selectable layers to the tAnalyzeSpatial Events layer.
Make a selection of the points for the whole survey area.
Open the Export Polygons And Points model by double clicking on it.
Select your soil polygons layer (soil_a or other _a layer in your project)
Browse to the location of your arcmap_link.mdb file and the specified table if necessary. The default location for the arcmap_link.mdb is in the following location on your system: C:\analysis\arcmap_link.mdb. Click OK.
The model will take a minute or two to run and will export an intersect table to the Arcmap Link database
You now have the spatial components set up for the display of point data through the tAnalyzeSpatial Events layer and the Drill Down form and for the display of polygons through the Workspace Legend form.
Nothing will be displayed spatially from the Workspace Legend form until you have imported the polygon-point intersect table into Pedon PC Plus and have built the data for the form.
Completing the Point/Polygon Intersection in Pedon PC Plus
In Pedon PC Plus, open the Analysis Tools Menu then open the Analyze Polygons form.
The Intersect Points and Polygons window will open. Review the information and click the Open Form button.
The Analyze Polygons window will open. Review your data on each of the five tabs in this window.
NOTE: Carefully review “MinDelinSize” (minimum delineation size) field on the MU Acres-All tab. If the minimum delineation size is smaller than what is allowed for your scale of mapping you may want to make edits to your line work. The Export Polygons And Points model creates a series of tables that are a static snapshot of your spatial data. If you make edits to your line work, you will need to repeat the process and run the Export Polygons And Points model. Import the new set of tables generated from the model that will reflect your edits by opening the Analyze Polygons again before proceeding.
Creating Area and map Unit Overlaps in Pedon PC Plus
Open the Utilities Menu, then click on Quality Assurance/Quality Control.
Open the Overlap Status tab and follow the directions on the form.
When completed, the number of site records should be the same as the number of map unit overlap records.
If these two numbers are not the same, the most likely reasons are that you either:
Have points that fall outside the spatial extent of your polygons or
Have polygons that are not attributed (null values)
Correct your data then repeat the process above
For further instruction on the set up and building of the data for the Workspace Legend form, refer to Pedon_PC--Workspace_Legend.