Cataloging Diversity

1
Cataloging Diversity
PLEC Database
2
Why Use Access?
VS.
3
Access
Excel
VS.
Yes
Yes
Spread Sheets
Yes
No
Link Tables/Relationships
Yes
Limited
Query and Sort Data
Yes
No
Create Reports and Forms
4
UtilityData
Linking Tables With Relationships
SpeciesData
SampleAreas
PlotDescriptions
TreeData
Database Structure From Zarin et al, 1999, PLEC
NV No. 14
5
Access
Sample Area Table
Contains General Data Describing Each Sample Area
including
Land Use Stage
Researcher
Location
Sample Area Number
6
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
7
Access
Plot Description Table
Contains a description of each plot within each
sample area number including
Plot Size
Elevation
Soil Type
Plot Number
8
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
9
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
10
Access
Excel
Species List
In order to avoid problems with misspellings and
inconsistency with names, a species list can be
created. A species list can contain
Common Name
Scientific Name
Family
Species ID Number
11
PLEC/Amazonia Sample Database
12
Kevin coffey
New York Botanical Garden
E-mail Kcoffey_at_NYBG.Org