Canadian Forest Service Publications

Base de données sur les placettes d'échantillonnage permanentes du Nouveau-Brunswick (PSPDB v1.0). “Landscape Management Network” 2001. Porter, K.B.; MacLean, D.A.; Beaton, K.P.; Upshall, J. Ressources naturelles Canada, Service canadien des forêts, Centre de foresterie de l’Atlantique, Fredericton (Nouveau-Brunswick). Rapport d’information M-X-209F. 69 p.

Year: 2001

Issued by: Atlantic Forestry Centre

Catalog ID: 20264

Language: French

Series: Information Report (AFC - Fredericton)

Availability: PDF (download)

Mark record


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.