Manassas Bluff Flora.accdb ReadMe This is a Microsoft Access Database created in 2015 using Microsoft Access 2010. It requires Microsoft Access 2007 or newer to open. The database is available at: http://www.cerc.usgs.gov/HostedDatabases.aspx This database accompanies the following report: Stroh, E.D., Struckhoff, M.A., and Grabner, K.W., 2015, A floral survey of cliff habitats along Bull Run at Manassas National Battlefield Park, Virginia: U.S. Geological Survey Data Series 940, 19 p., http://dx.doi.org/10.3133/ds940. For questions regarding the database, contact: Matthew Struckhoff Email: mstruckhoff@usgs.gov Phone: 573-441-2971 June 15, 2015 Available by direct download as: * Manassas Bluff Flora.accdb (Microsoft Access 2010 file; 4MB) * Manassas_Bluff_Flora_ReadMe.txt (ASCII file with database explanation and description; 5KB) * Geospatial data: Manassas Bluffs ArcGIS shapefile Manassas Bluffs.dbf (4 KB) Manassas Bluffs.prj (1 KB) Manassas Bluffs.sbn (1 KB) Manassas Bluffs.sbx (1 KB) Manassas Bluffs.shp (3 KB) Manassas Bluffs.shp.xml (13 KB) Manassas Bluffs.shx (1 KB) * Photos folder: 383 pictures (892MB; In order for hyperlinks within the database to correctly link to photos, this folder and contents should be downloaded to the folder containing "Manassas Bluff Flora.accdb") Description The Manassas Bluff Flora database is a Microsoft Access 2010 database containing floral survey data collected in 2014 in Manassas National Battlefield Park, Virginia by the authors listed in the citation above. The floral survey of 11 cliffs along Bull Run in the park resulted in observations of 282 species from 194 genera and 83 families. Sampling design, sampling methods, technical definitions, results, and a complete species list are given in the report cited above. How to use the database When you open the file (Manassas Bluff Flora.accdb) using Microsoft Access, you will see a “Welcome” message with a brief description of the available data, forms, reports and photographs. Click “Enter” to close the welcome message and use the database. After closing the welcome message, you will be given a choice of tasks (Database Actions) from which to select you choice. These include viewing various types of reports, managing plot data, or exiting the database. You must select one to proceed. Making a selection will generate a report; some reports require you to indicate a location (a number for a bluff and/or a sampling block) before the report is generated. Selecting “Manage Plot Data” will close the dialog box and allow you to explore existing Tables, Queries, Forms, and Reports. For explanations of terms used in the database fields, tables, queries, and forms, refer to the report listed in the citation above. All fields in all tables include a description of the field contents and units. Tables included in the database Available Plant List Block Bluff Cover Values Groundflora Photos Trees Queries included in the database Block groundflora species list Block headers Bluff groundflora species list Bluff groundflora species list by block Bluff trees by block Forms included in the database Database Actions Get block groundflora data Get block trees Get bluff groundflora species list Get bluff groundflora species list by block Get bluff trees by block Welcome Reports included in the database Block groundflora species list Block headers Block trees Bluff groundflora species list Bluff groundflora species list by block Bluff trees by block Project groundflora & shrub species list Project tree species list Uses of the Data Species lists for individual bluffs or sampling blocks can be generated using the database. In addition to the final identification for each species, the database retains the original field identification and a justification for modifications to the species identification where appropriate, which allows users to identify locations where specimens belonging to problematic species groups were recorded if further field verification is desired. The database can be used to locate large patches of groundflora species, and individual or large specimens of tree species. The database can also be used to locate and monitor the occurrence of individual examples of species that are uncommon for the region, such as Tsuga canadensis (eastern hemlock), Pinus strobus (white pine), and Kalmia latifolia (mountain laurel). Additionally, the database can be used to identify locations of exotic species, including the frequently encountered Lonicera japonica (Japanese honeysuckle), Microstegium vimineum (Nepalese browntop), and Alliaria petiolata (garlic mustard), and the newly documented Paulownia tomentosa (princess tree). Accompanying photographs Photographs in the “Photos” folder are named using the “Bluff” name, followed by the “Block,” then a two digit sequential number in the following format: * Bluff-Block-##.jpg Photographs taken near bluffs but not actually of the bluff features are appended with a description of the photograph content, for example: * Bluff-Block-##-turtle.jpg The “Photos” table in the Manassas Bluff Flora database includes a hyperlink field called “Relative Photo link”. Clicking on field contents will open the relevant file within your default photo viewing program, if you have copied the “Photos” folder and its contents to the same location where you copied the Manassas Bluff Flora database.