Skip

Pedon PC - Data Entry

If you encounter problems with the file provided on this page, please contact Soil Survey at 406-587-6818.

The information on this page is also available in Microsoft PowerPoint format. Once you have saved the file to a local drive, open Microsoft PowerPoint then open the saved file on your local drive.

Data Entry (PPT; 750 KB)

Pedon PC - Data Entry

Import GPS waypoints
  1. Automatically creates a new transect, site, and pedon record, linking the transect to the pedon.
  2. Populates LatLongs, UTMs, Elevation, Observation Date, Describer Name, and Area Overlap.
  3. Requirements:
    1. Garmin GPS .txt file created from DNR Garmin.
    2. Standard Site/Transect naming convention.
      1. ALASKA: 2digitYear-2characterDescriberInitials-3digitTransectID-2digitStop#
      2. Examples:
        • User Transect ID:06DG111
        • User Site ID: 06DG11101
Or manually create a new Transect and Site.

Pedon PC - GPS Import

Use the Minnesota Department of Natural Resources (MN DNR) Garmin stand alone application to upload waypoints and save them as a .txt file.
  1. Download the newest version of the Minnesota Department of Natural Resources Garmin application.
  2. Plug GPS into the serial port of computer.
  3. Turn GPS on.
  4. Open MN DNR Garmin application.
  5. Navigate to Waypoint then Waypoint Properties
    1. On the projection tab, set projection using the drop-down list (Example: NAD_1983_UTM_Zone_6N)
    2. On the waypoint tab, REMOVE the checkmarks from all BUT the following fields: type, ident, lat, long, y_proj, x_proj, comment, altitude.
  6. Navigate to Waypoint then Download
    1. Records from GPS should appear in the dialog window.
      1. Once records are as you want them to appear (you can remove unwanted records, rename records, etc.) navigate to File then Save To then File and save as .txt file using the following name pattern: 2 digit year, 2-character describer initials (Example: 06FG.txt)
  7. Navigate to c:\pedon and open the pedon_pc.mdb file.
  8. From the Main Menu, click: Setup then Import Data then Import Waypoints.
  9. To download your GPS waypoints as a .txt file, click the blue DNR Garmin button to open DNR Garmin.
  10. Click the Browse button, navigate to where your gps.txt file is located, then click OK.
  11. Select the desired import options and click OK
  12. .
    1. Alaska Uses the “Date, Describer, Garmin Ident Field” Format.
      • Example: 06MC00501 - Be sure to enter values for the Describer and Year fields.
      • If you intend to create transect records with the sites and pedons, pick “Yes” from the Build Transect drop-down menu.
      • Enter the number of unique digits for the sites and transects. (Alaska uses a 5-digit number (00501) where the first 3 digits are for the transect# and the last 2 digits are for the stop#.)
  13. Click OK to import the GPS waypoints.

Transect Form

IMPORTANT: A transect is NOT required for a site (or pedon) to exist. A pedon MAY be linked to a transect. So a pedon must exist prior to adding it to a transect. Manually adding a NEW site/pedon is covered in the Site Data Entry Form section of this tutorial.

  1. Navigate to Forms then Transect Data Entry.
  2. Select the transect of interest by typing it in the uppermost User Transect ID box (or selecting it using the drop-down menu).
    1. To add a new Transect manually, click the Add New button, type the Transect Name where it says “Type TsectID Here” then click the Add New button again.
  3. To add an EXISTING Pedon to the current Transect manually, select it from the User Pedon ID box then click the ADD button.
  4. To remove a Pedon from the current Transect, select the Pedon in the table below and click the Remove button.
  5. Double click the User Pedon ID to proceed to the Site Data Entry Form.
If you have used the GPS Import function
  1. A transect, site, and pedon could have been added automatically with several fields already populated.
  2. Choose one of the Transects you just added and check to see that the correct Pedons were added.
  3. If you want to attribute a MUSYM to the entire Transect, enter it here.
    1. NOTE: To attribute composition estimates to a transect, you MUST have a MUSYM populated (pick Null if nothing else).
  4. Enter Polygon Composition Estimates here.
  5. Double click the User Pedon ID to proceed to the Site Data Entry Form.

NASIS Legend Builder

If you need to add mapunits or components to your workspace legend
  1. Navigate to Forms then NASIS Legend Builder.
    1. Click the AreaSymbol Dropdown and make sure you add the mapunit or component to the correct area. The area with the most components and mapunits is listed toward the top.
    2. To change what areas appear in this list, go to Setup then Customize Choice Lists then Edit Choice List and either show or hide the area of interest. The list is defaulted to Alaska’s MLRA and Non-MLRA Soil Survey Areas
The list summarizes the legend data for each area.
  1. Mu_c - Number of Mapunits (as Correlated)
  2. Mu_s - Number of Mapunits (as Sampled)
  3. Comp_c - Number of Components (as Correlated)
  4. Comp_s - Number of Components (as Sampled)
  • Make sure the Mapunit and Component Legends each have a “Null” record.
    • This allows you to catalog any records in your dataset that have null entries for either mapunit or component.
  • To add a new mapunit to the legend, type the mapunit symbol here.
    • Note: Access does not actually create a record until you leave the new row.
  • When entering new data, if you need to add components referenced on the fieldsheet, do so on the component tab.

Site Form

Basic Navigation Controls

IMPORTANT:

  1. Use the record selectors view a different site on the site form.
    1. If you linked to the form from the Transect form, only the sites from that transect will appear.
    2. To go back to the Transect form, double click the Transect ID.
  2. The Component field uses the Component Legend as a domain.
    1. Double clicking this field will open up the OSD if it is an established series.
  3. The Sub Group field automatically populates the higher taxonomic fields.
    1. Double clicking this field will open up the OSD Taxonomic Query.
  4. Place a check mark next to this option to display the hyperlinked photos for each site.
    1. This option will slow down the form according to each jpg’s file size.
    • When editing horizon data, make sure to place a checkmark next to the Edit First option.
      • This allows editing of color, texture, fragments, structure, and roots at the horizon level.
      • Turn the option off when navigating from site to site.
        • The code that this feature runs is VERY slow when pulling data across the shared drive.
        1. Use this toggle switch to turn on/off additional tabs.
        2. Select the Show all tabs Option and notice the tabs that were added.
          1. Alaska collects a streamlined dataset.
          2. Many other fields and tabs are hidden on the form.
Commands Tab
  1. Select the Show all tabs Option, then view the Commands tab.
  2. Use this button to add a new site manually.
    • Click the button and enter the User Site ID at the prompt.
  3. Jump to the Choice List Form.
  4. This button limits the Geomorphic Feature and Parent Material Kind choice lists by the show/hide.
    • (defaulted to Alaska Technical Note choices)
  5. Jump to the Workspace Legend
Stock Access Form Features
Working with columns on datasheet subforms
  1. Columns can be moved around using the stock “drag and drop” feature.
    1. Click on the column header (it will turn black).
    2. Hold down the left mouse key and drag the column to another spot.
  2. Hide/Unhide Columns
    1. Place your mouse in the MicroKnd box.
    2. This is actually only one field from the site observation table.
    3. Navigate to Format then Unhide Columns (Menu bar).
    4. Place a checkmark next to one of the hidden columns to unhide it.
      • Notice how many columns are hidden.
Using Record Selectors
  1. The gray box at the left of each record (row) is a record selector. The current record has a black arrow.
  2. To delete a record, click the record selector for that row and either press the delete button on your keyboard or the delete record button on the toolbar.
    1. IMPORTANT: To delete an entire site, you must first delete any corresponding pedon.