LEMMA offers a number of data tables associated with GNN products. The tables can be downloaded by clicking on the plot database link below. The database contains plot data for all modeling regions within a project. Documentation for these tables is embedded in the Data Dictionary section below.
|Product Description||Status||Imagery year||Date posted||Download|
|Plot database (MS Access format) and associated documentation||FINAL||N/A||04/21/2014||(36.3 MB)|
The data dictionary below lists all tables that have been attached to the above plot database. Click on the plus symbol in the first column to see fields for that table. In the resulting list, if a field has coded entries, clicking on the plus symbol in the first column ('C') will show all codes. For information on how a field is calculated, click on the plus symbol in the second column ('F') for details. The fields for a table can be fully expanded or collapsed with 'expand all' and 'collapse all' links.
|Table Schema||Table Name||Table Description|
|dist||SPPSZ_ATTR_LIVE||All live summary variables (and plot information) that can be attached to GNN species-size models|
|dist||SPPSZ_ATTR_DEAD||All dead summary variables that can be attached to GNN species-size models|
|dist||TREE_BA_CROSSTAB||Plot by tree species basal area cross-tabulation table|
|dist||TREE_BIO_CROSSTAB||Plot by tree species biomass (Component Ratio Method) cross-tabulation table|
|dist||TREE_COV_CROSSTAB||Plot by tree species percent cover cross-tabulation table|
|dist||TREE_VOL_CROSSTAB||Plot by tree species volume cross-tabulation table|
|dbo||SPECIES_CLASS||Classifications of all overstory and understory species|