get_locations_from_ssdb: Get locations ("locations" table) from a SumavaDB-like...

get_locations_from_ssdbR Documentation

Get locations ("locations" table) from a SumavaDB-like spatiotemporal database

Description

Get locations ("locations" table) from a SumavaDB-like spatiotemporal database

Usage

get_locations_from_ssdb(conn, ...)

Arguments

conn

database (preferrably PodtgresSQL) connection. See ouput of dbConnect.

...

further arguments for st_read

Examples

## Not run: 
library(RPostgreSQL) 
dbname <- "hydroclimatedb_testing00"
val <- sumava_snow_dataset()
conn = dbConnect(PostgreSQL(), dbname = dbname)
add_locations_into_ssdb(conn,val$locations,new=TRUE)
### Add weather station from MeteoTrentino network, Trentino, Italy 
val_smet <- meteotrentino_smet_dataset(smet_files=c("T0175","T0179"))
add_locations_into_ssdb(conn,val_smet$locations,append=TRUE)

dbDisconnect(conn)

conn = dbConnect(PostgreSQL(), dbname = dbname)
out <- get_locations_from_ssdb(conn)
dbDisconnect(conn)


## End(Not run)

ecor/SuSnowDB documentation built on Jan. 2, 2023, midnight