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
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
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
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
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
Right click the soil_a_selected layer and go to Joins and Relates then
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
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
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
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.