Add Sample Location

add_sample_location() adds a new sample location to the sample location lookup table

Usage

add_sample_location(con, sample_location)

Arguments

con

A DBI connection object obtained from DBI::dbConnect()

sample_location

A valid sample location dataframe with the following:

1. code character A short code for the location

2. location_name character The location name

3. stream_name character The stream name (e.g., "American River")

4. description character

5. managing_agency_id integer see get_agencies

6. latitude numeric

7. longitude numeric

See also

Other sample location functions: delete_sample_location(), get_sample_locations(), update_sample_location(), update_sample_location_status()

Examples

# example database connection
cfg <- config::get()
con <- DBI::dbConnect(RPostgres::Postgres(),
                      dbname = cfg$dbname,
                      host = cfg$host,
                      port = cfg$port,
                      user = cfg$username,
                      password = cfg$password)
#> Error: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061)
#> 	Is the server running on that host and accepting TCP/IP connections?
#> connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061)
#> 	Is the server running on that host and accepting TCP/IP connections?

new_sample_location <- data.frame(code = "",
                                  location_name = "",
                                  stream_name = "",
                                  description = "",
                                  managing_agency_id = 1,
                                  latitude = 0,
                                  longitude = 0)
add_sample_location(con, new_sample_location)
#> Error in h(simpleError(msg, call)): error in evaluating the argument 'dbObj' in selecting a method for function 'dbIsValid': object 'con' not found