get_value_table_names_from_ssdb: Extract table names containing values

In ecor/SuSnowDB: SuSnowDB: Geospatial Database for Climate Data

Extract table names containing values

Description

Extract table names containing values

Usage

get_value_table_names_from_ssdb(
  ssdb,
  meta_table_names = c("locations", "measurement_types"),
  value_table_names = NULL
)

Arguments

ssdb	spatio-temporal dataset or a connection (IMPLEMENTED)
meta_table_names	names of the meta tables. Default is c("locations","measurement_types").
value_table_names	names of the meta table. Default is NULL. Ignored if it is NULL.

Examples

## Not run: 
library(RPostgreSQL) 
dbname <- "hydroclimatedb_testing00"
conn = dbConnect(PostgreSQL(), dbname = dbname)


### Add weather data from stations from MeteoTrentino network, Trentino, Italy 
val_smet <- meteotrentino_smet_dataset(smet_files=c("T0175","T0179"))
add_locations_into_ssdb(conn,val_smet$locations,new=TRUE)
add_measurement_types_into_ssdb(conn,val_smet$measurement_type)
add_measurements_into_ssdb(conn,val_smet$measurements)

dbDisconnect(conn)

conn = dbConnect(PostgreSQL(), dbname = dbname)
out <- get_measurements_from_ssdb(conn)
out <- get_measurements_from_ssdb(conn,locations_code0="IT-TN_T0179")
out <- get_measurements_from_ssdb(conn,locations_code0="IT-TN_T0179",
variables_code0=c("SMET_TA","SMET_PINT"))
out <- get_measurements_from_ssdb(conn,variables_code0=c("SMET_TA","SMET_PINT"))

time_interval <- as.Date(c("2021-03-01","2021-03-31"))
out <- get_measurements_from_ssdb(conn,variables_code0=c("SMET_TA","SMET_PINT"),
start_time=time_interval[1],end_time=time_interval[2])

tnames <- get_value_table_names_from_ssdb(conn)
dbDisconnect(conn)


sumava <- sumava_snow_dataset()
tnames_sumava <- get_value_table_names_from_ssdb(sumava)

## End(Not run)

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