Geographic Information Sciences Commons^™

Microsoft Access To Sqlite Database Migration For Existing Forest Management Software: Methods And Considerations, Drue Kathryn Lindstrom

Masters in GIS Practicum Reports

Bioregional Inventory Originated Simulation Under Management (BioSum) is software from the US Forest Service’s Forest Inventory and Analysis (FIA) program. It is a complex analysis framework that models and evaluates forest management treatments across multi-decade timeframes. Originally written to work with Microsoft Access databases, BioSum is migrating to the use of SQLite as its database engine. The final module of BioSum, Treatment Optimizer, is the first one to be converted so the changes can be implemented incrementally. This practicum report outlines a workflow for converting the database engine of an existing program from Microsoft Access to SQLite with the example …