1 / 69

Analysis PC

Analysis PC. Analysis PC. Provide an analysis tool for point data. Easy to perform QA/QC on point data. Step One – Retrieving Pedon Data from NASIS. The training materials contain a txt file for use in this exercise. The following is for future use. Load pedon data into NASIS selected set.

greg
Download Presentation

Analysis PC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Analysis PC

  2. Analysis PC Provide an analysis tool for point data. Easy to perform QA/QC on point data

  3. Step One – Retrieving Pedon Data from NASIS The training materials contain a txt file for use in this exercise. The following is for future use.

  4. Load pedon data into NASIS selected set Load pedon, site and transect

  5. Run the AnalysisPC report to export Pedon data from NASIS • Selected Set includes: • Pedons, Sites and Transects • Run “AnalysisPC” report under Pangaea

  6. Analysis PC and Users guide AnalysisPC and associated files are found on the NASIS downloads site – however in this exercise all files are provided

  7. Training materials The analysis.zip contains a populated AnalysisPC database, personal geodatabase and all associated files necessary to learn how to use these tools. Unzip this into a c:\analysis folder. Use this dataset with this presentation.

  8. Files with Analysis PC Analysis_pc_2.1.mdb (Apc access file) Arcmap_link.mdb (Apc to arclink file) Templatedb.mdb (SSURGO 02template) ssl_MO?.mdb (NSSL database) Analysis_PC.tbx (Arc toolbox) ?.txt (NASIS pedon text file)

  9. Initial Directory Setup • Create C:\analysis folder • Unzip the analysis file into folder • Read the users guide and/or use the job aid on setup of Analysis PC http://soils.usda.gov/education/training/job_aids.html#correlation

  10. Step Two – Using AnalysisPC The following steps will use the training materials supplied in the analysis.zip file.

  11. Locate the Access file • Open AnalysisPC by navigating to the c:\analysis directory • Open the “analysis_pc.mdb” file

  12. AnalysisPC Home Screen Setup Menu

  13. Import data file from NASIS

  14. Locate the NASIS download Browse to find the “*.txt” file Import the txt file

  15. Select the Analysis Form

  16. Running Preloaded Queries

  17. Preloaded Queries Run some of the available queries and review their results Use filtering, sorting and hiding of columns

  18. Sand, Silt And Clay Analysis form can be modified by using the “hide columns”, moving columns, filtering data, and sorting columns

  19. Pedon Analysis Only 1 TP and that should be the OSD 7 pedons described as the typical pedon for “Clifford”

  20. Pedon Analysis Filtering and sorting can be used to narrow the review of data to include only those pedons with locations, with a correlated name and are Full Pedon Descriptions

  21. Filtering data Left click on the down arrow and left click select all and left click box for “Clifford”

  22. Filtering data Dataset contains only “Clifford” records

  23. Filtering data Removes blank rows

  24. Filtering data All the null rows have been removed The data still exists it just not in the filtered set

  25. Filtering data “Text filter” Allows use of wildcards to select all the Bt horizons

  26. Filtering data All the Clifford Bt horizons were selected

  27. Filtering data “Clear filter from hzname” removes all filters. The original dataset from the query is returned.

  28. Using Filtered Data

  29. Sending AnalysisPC data to Excel Send data to Excel deciding between the entire selected set or the filtered selected set

  30. Save Filtered Data Run the query and filter the data as needed Click on Save filtered/Sorted Set

  31. Filtering data Name your file after the underscore Save Filtered/Sorted Set allows the sorted set to be exported to the database as a table

  32. Filtering data Filtered table is saved for import/export to the statistics form, texture plot or Arc export

  33. Statistics Form

  34. Running Statistics Click “Load Table” to load a filtered dataset

  35. Results Table columns can be moved or hidden – statistics are only as good as the selected set Choose fields for statistics You can send your data to excel

  36. Plotting Texture

  37. Plotting Texture Select Plot Points from User Defined Table

  38. Plotting Texture Click “Load Table” to load a filtered dataset

  39. Plotting Texture Use choice lists to identify the fields

  40. Plotting in AnalysisPC Click plot and review data

  41. Customizing Queries

  42. Creating a Query • Customized queries can be written for AnalysisPC. The first step is to open the Queries object and find a query similar to your needs. Copy, paste and rename the query.

  43. Creating a Query Open and modify the query. Then save the query following the naming nomenclature.

  44. Add a Query(Scroll all the way to bottom)

  45. Adding the Query Insert a suitable sequence number, the choice list label, query name and a description so you remember what results your query will return.

  46. Check the Query Choice List The new query appears on the choice list.

  47. Sharing a query Open query and change to SQL View

  48. Copy SQL In the “SQL” window, highlight and copy the query

  49. Paste into email Paste the query into an email send. The recipient can then copy the query and paste into their AnalysisPC

  50. Linking Other Access Databases

More Related