120 likes | 246 Vues
Explore the PLEC database designed for cataloging biodiversity in Amazonian sample areas. This database offers features that far surpass traditional spreadsheets, such as linking tables with relationships, enabling detailed analyses and reporting. Record specific data on sample areas, plots, and species, ensuring data integrity through unique identifiers. Create structured queries to sort and analyze expansive datasets, while generating comprehensive reports for scientific use. Ideal for researchers focused on ecological studies, the database enhances data management and improves accuracy in biodiversity research.
E N D
Cataloging Diversity PLEC Database
Why Use Access? VS.
Access Excel VS. Yes Yes Spread Sheets Yes No Link Tables/Relationships Yes Limited Query and Sort Data Yes No Create Reports and Forms
UtilityData Linking Tables With Relationships SpeciesData SampleAreas PlotDescriptions TreeData Database Structure From Zarin et al, 1999, PLEC N&V No. 14
Access Sample Area Table Contains General Data Describing Each Sample Area including: • Land Use Stage • Researcher • Location • Sample Area Number*
The plots within each sample area are linked to the sample area table by a unique number assigned to each entry in the sample area table. Access
Access Plot Description Table Contains a description of each plot within each sample area number including: • Plot Size • Elevation • Soil Type • Plot Number*
Access Plot Number • Data are linked by a unique plot number designated to each plot entry • Within each plot, tables can be created to hold more specific data
Access Species Data Data can be recorded on individuals and species within each plot, including: • Abundance of Species • DBH and Height of Trees • Species Utility • Species ID Number*
Excel Access Species List In order to avoid problems with misspellings and inconsistency with names, a species list can be created. A species list can contain: • Species ID Number* • Common Name • Scientific Name • Family
PLEC/Amazonia Sample Database
Kevin coffey New York Botanical Garden E-mail: Kcoffey@NYBG.Org