Canadian Forest Service Publications
New Brunswick Permanent Sample Plot Database (PSPDB v1.0): User’s guide and analysis. 2001. Porter, K.B.; MacLean, D.A.; Beaton, K.P.; Upshall, J. Natural Resources Canada, Canadian Forest Service, Atlantic Forestry Centre, Fredericton, New Brunswick. Information Report M-X-209E. 65 p.
Available from: Atlantic Forestry Centre
Catalog ID: 18332
The Canadian Forest Service and the New Brunswick Department of Natural Resources and Energy (NBDNRE) have cooperated to develop an interactive database system in support of the N.B. Cooperative Permanent Sample Plot (PSP) program. The program, initiated in 1987, includes approximately 2500 PSPs located throughout the province. These plots are representative of the entire provincial forest. Data from the PSPs can be used to define stand structures at specific points in time, calibrate stand growth models, and validate/invalidate projections made with stand models. These growth projections or yield curves represent the volume expectations that form the basis for forest management plans.
The Permanent Sample Plot Database (PSPDB) was created as a data management and reporting system. Microsoft Access® is used to facilitate access and transform the raw data into information using meaningful, built-in calculations and a flexible graphical user interface (GUI). PSPDB is updated annually with new measurement data from NBDNRE and can be downloaded via the Internet.
This report presents an overview of the N.B. Cooperative PSP program, the database structure and functions of PSPDB, installation instructions, and a tutorial. Selected calculated outputs from the system are also presented, including volume, periodic annual increment, and periodic mortality, by geographic area (Crown license and marketing board area), and by species class.