1 / 19

NPS I&M South Florida/Caribbean Network Miami, FL

Continuous Data Collection In Florida and the U.S. Virgin Islands. Judd Patterson Brian Witcher. NPS I&M South Florida/Caribbean Network Miami, FL. Overview. What we collect water temperature weather station Access database import wizard data validation Workarounds

giulio
Download Presentation

NPS I&M South Florida/Caribbean Network Miami, FL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Continuous Data Collection In Florida and the U.S. Virgin Islands Judd Patterson Brian Witcher NPS I&M South Florida/Caribbean Network Miami, FL

  2. Overview • What we collect • water temperature • weather station • Access database • import wizard • data validation • Workarounds • Excel graphing (VB) • Problems • size of dataset • graphing improvements

  3. Where We Work 1 weather station 4 reef temperature 40 reef temperature 10 reef temperature 2 weather stations 4 reef temperature

  4. Water Temperature • HOBO water temperature loggers on coral reefs • located at 47 reef sites in BISC, BUIS, DRTO, and VIIS • several sites have paired sensors • data point every 2 hours • Yawzi Reef 1988-present • one of the longest water temperature datasets in the Caribbean

  5. Why we do this… Historically HOTseawater temps Source: adapted from Miller et al. 2009

  6. Why we do this… 2005 resulted in massive coral bleaching and disease… …and ultimately 60% decline in coral cover in the U.S. Virgin Islands

  7. Weather Stations • land-based weather data collection in the USVI and Florida • full weather station • storing 9 sensor values • logging every 10 minutes • independent rain gauge • storing 2 sensor values • logging every 10 minutes

  8. Weather Stations 1. Download data with a HOBO shuttle

  9. Weather Stations 2. Open hobo/dtf and convert to csv

  10. Data Validation Workflow 3. Access database – Import

  11. Weather Stations 3. Access database – Import

  12. Weather Stations 4. Access database – Manual Validation Spike Flatline • Check suspicious readings with local airport weather • http://www.wunderground.com/history/airport/TISX/2010/4/14/DailyHistory.html

  13. Export/Graphing • Pick a station, pick a date range, select the export location... • VB creates appropriate query • VB creates Excel document from template and loads with query data

  14. Workarounds

  15. Workarounds

  16. Workarounds

  17. Data ForEVER

  18. Remaining Issues • Size of dataset • With each new import a performance hit is noticeable • …inevitable switch to SQL Server on the horizon • Graphing • Excel is also at its limit when dealing with large datasets; particularly graphing

  19. Thanks!Questions?

More Related