GNN Plot Database

Plot Database

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)

Data dictionary for tables included in plot database

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