Get Minimum and Maximum Metric Values for a Selected Region — data_get_min_max

This function retrieves the minimum and maximum values of a selected metric for a specified region

Usage

data_get_min_max_metric(selected_region_id, selected_metric, con)

Arguments

selected_region_id: The ID of the selected region.
selected_metric: The name of the selected metric.
con: PqConnection to Postgresql database.

Value

A data frame containing two columns: 'min' and 'max', representing the minimum and maximum values of the selected metric for the specified region.

Examples

con <- db_con()
#> Error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
#> 	Is the server running locally and accepting connections on that socket?
data <- data_get_min_max_metric(selected_region_id = 11,
                                selected_metric = "active_channel_width",
                                con = con)
#> Error in h(simpleError(msg, call)): error in evaluating the argument 'conn' in selecting a method for function 'sqlInterpolate': object 'con' not found
DBI::dbDisconnect(con)
#> Error in h(simpleError(msg, call)): error in evaluating the argument 'conn' in selecting a method for function 'dbDisconnect': object 'con' not found