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.