ropensci-archive / dbhydror

R interface to the South Florida Water Management District's DBHYDRO Database :sweat_drops: :palm_tree:

dbhydroR

This package has been archived. The former README is now in README-old.

dbhydror's Issues

License

What license is this code under?

function get_hydro() broken

Returns error apparently for any and all dbkey and date range inputs. In the example below, data for the given dbkey can be successfully retrieved from DBHydro through the web interface.

get_hydro(dbkey = "HC940", date_min = "2018-05-01", date_max = "2018-05-02")
Error in get_hydro(dbkey = "HC940", date_min = "2018-05-01", date_max = "2018-05-02") :
No data found

dbkeys with leading zeros

a=get_hydro(dbkey="00910",date_min="1939-01-01",date_max="2017-01-01")

Error in dim(ordered) <- ns :
dims [product 1] do not match the length of object [0]

station lat/lng

is there any way to get station lat/lng?

add ability to perform reverse dbkey lookups

add ability to query all wq stations under a particular project code

error on passing multiple stationids to get_hydro

get_hydro is returning a data.frame with only a single column in these cases

This works as expected:

get_hydro(dbkey = c("15081", "15069"), date_min = "2013-01-01",
    date_max = "2013-02-02")

This does not:

get_hydro(stationid = c("C-54", "M-1083", "G-561"), category = "GW", 
            freq = "DA", date_min = "1990-01-01", date_max = "2017-04-10", longest = TRUE))

minor LaTeX parsing issue in pkgdown vignette

Some raw latex (\begin{itemize}) is not being rendered in the pkgdown vignette.

Use GitHub release after each CRAN update?

So that the rOpenSci newsletter might pick up the update. :-) (the next one, the one for today couldn't ropensci.org/blog/2021/03/16/ropensci-news)

function get_hydro() broken (again)

get_hydro returns error for any and all dbkey and date range inputs. An example taken from the documentation (but updated to an active dbkey value):

> get_hydro(dbkey = "HC940",
           date_min = "2013-01-01", date_max = "2013-02-02")

Error in get_hydro(dbkey = "HC940", date_min = "2013-01-01", date_max = "2013-02-02") :
No data found
In addition: Warning message:
In min(which(apply(raw[, 10:16], 1, function(x) all(is.na(x))))) :
no non-missing arguments to min; returning Inf

Data, including from this example, are accessible from the DBHydro web interface.

get_dbkey() and get_wq() appear to be functioning correctly.

make cleanhydro consistent with cleanwq

cleanhydro should operate on data.frame(s) not httr responses

transfer to ropensci

👋 @jsta we no longer transfer onboarded packages to ropenscilabs but instead directly to ropensci so we should move this repo. Are you ok with my doing it? If so when would you have the time to update all links? I wouldn't transfer before you have time to do that, and it's not urgent to transfer anyway.

If possible could you please add this badge to the README of rnaturalearth when updating CI links?
[![Project Status: Active – The project has reached a stable, usable state and is being actively developed.](http://www.repostatus.org/badges/latest/active.svg)](http://www.repostatus.org/#active)

Thanks for your patience! 🙏

add a date argument to get_dbkey

handle timeouts gracefully on very large queries

update URLs in description file

https://github.com/ropenscilabs/dbhydroR/blob/master/DESCRIPTION#L11-L12 those urls should be https and no www

thanks 😄

Too Many Requests (RFC 6585) (HTTP 429)

Looping through multiple stations to download data for each station (dbkey). It keeps brining up this error "Error in dbh_GET(servfull, query = qy) Too Many Requests (RFC 6585) (HTTP 429)". It appears that the server is overwhelmed by the request and stops writing the data to either a dataframe or csv.

What endpoints are you using?

What endpoints are you using to get your data? Are you scraping the dbhydro browser directly or are there some specific endpoints you're calling?

Thanks

add ability to search for wq station ids

wrap the interface at http://my.sfwmd.gov/dbhydroplsql/water_quality_data.show_group_station_characters

links to the dbhydro browser need to be updated to the stable version