Design and Development of an Access Database for Tracking MODIS Lake Ice Data for SWAN

Project ID: J8W07080006

Federal Agency: National Park Service

Partner Institution: Saint Mary’s University of Minnesota

Fiscal Year: 2008

Initial Funding: $12,193

Total Funding: $16,531

Project Type: Technical Assistance

Project Disciplines: Physical

National Park: Southwest Alaska Network Inventory & Monitoring

Principal Investigator: Robertson, Andy

Agreement Technical Representative: Spencer, Page

Abstract: The National Park Service Southwest Alaska Network, headquartered in Anchorage, is interested in developing a Microsoft Access-based, single-user database to track lake ice data interpreted from MODIS satellite imagery. Currently, these data are tracked in an Excel spreadsheet with a separate worksheet for each year and separate worksheets for some lakes. The vision for the Access application is to consolidate all the MODIS data in a database application that has a user interface for simplified data entry, and built-in query tools for data mining, report development and data export. The application also needs to be portable in the sense that, even though it is single-user, it can be transferred from a networked office computing environment to a laptop and back for permit updating and querying in multiple locations.