Stand Search
Stand Search is an application that has been developed in Microsoft Access to facilitate the exploration and analysis of forest inventory databases. The Stand Search interface allows simple to complex filters and searches of the data to be developed without expertise in using database software. In addition, the Stand Search application includes interfaces to stand visualization software (SVS; McGaughey 1997) to allow graphical exploration and comparison of selected stands. Filter criteria can be used to limit selected stands/plots based on text or numeric fields. For example, filter criteria could specify stands/plots above 1,000 meters elevation, dominated by Mountain Hemlock, and having a dominant average height greater than 30 meters. Search criteria can be used to rank the stands/plots based on how closely they match user targets for numeric fields. For example, search criteria could rank which 10 stands are closest to having a dominant height of 30 meters, an elevation of 200 meters, and 2 distinct tree canopy layers. Search and filter criteria can also be used simultaneously.
Figure 1: Main window in Stand Search depicting filtering
(1 and 2) and search (3-6) criteria for the Western Washington FIA database.
1 2 3 4 5
Figure 2: The 5 highest-ranking subplots from a search
for lower elevation plots dominated by Douglas-fir with an average dominant
height of 80 feet, a stand density index of 500, 1 canopy layer, and an average
canopy depth of 30 percent.
Contact: Jeremy_Wilson@umenfa.maine.edu