Skip to content

USF-IMARS/WIN_data_ingest

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

44 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Data

Data for this repo is staged in /data. Details on data sources are below.

Data from WIN is pulled manually for each program and put into data/. This data is staged at this box.com link.

Additional data is provided in custom formats by some providers:

Older historical data has been collected into this box.com folder.

Additional historical data is provided in unique format from some providers:

tests

Rscript -e "testthat::test_dir(here::here('tests/testthat'))"

or

testthat::test_dir(here::here('tests/testthat'))


# plans & TODO items
* re-pull WIN data. it has updated
  * 6 + AOML. Miami Beach coming
  * new one called DEP

* older data also available:
  * https://usf.box.com/s/m40d8rsugrp9t4joieh6ce0vo4i1vvkc
  * check alignment & merge with newer data
  * 3 there now, 1 more coming

* new FIU dataset with custom import method (excel files)
  * 2 excel files merged, report should be separate from WIN data (for now)
  * many columns, some will be dropped, Dan will give list of columns to keep
  * FIU data also comes from WIN so there will be some overlap

## DEP WIN ingest
* new WIN ingest files from Dan. 1 from each program:
https://usf.box.com/s/6j6ipvgh1ncu8qcmgw9o0ygxogcg8371
   * TODO: need to update files here; files in box updated
   * expect 7 or 8
     * 6 + AOML. Miami Beach coming.
     * new one called DEP
   * palm beach lat/lon is string in deg,min,sec. need to convert to decimal

* AOML.SFER file is additional. (all years, even pre-2015)

* TODO: new FIU dataset with custom import method (excel files)
  * 2 excel files merged, report should be separate from WIN data (for now)
  * many columns, some will be dropped, Dan will give list of columns to keep
  * FIU data also comes from WIN so there will be some overlap

* include links to download each .csv

* provide merged file csv download

* older data also available:
  * https://usf.box.com/s/m40d8rsugrp9t4joieh6ce0vo4i1vvkc
  * check alignment & merge with newer data
  * 3 there now, 1 more coming

## Trend
.csv export a trend for each station.
R code from Dan to calculate trend.

About

data ingestion and initial analysis from FL WIN water quality database

Resources

Stars

Watchers

Forks

Languages