dbWriteTable_site: Insert data into 'site' table

Description Usage Arguments Value See Also Examples

View source: R/db_write.R

Description

Insert data into site table

Usage

1
2
3
4
5
6
7
8
dbWriteTable_site(
  conn,
  site_name,
  site_lat = NULL,
  site_lon = NULL,
  site_altitude = NULL,
  site_comment = NULL
)

Arguments

conn

Database connection.

site_name

String vector of name of site or name of campaign.

site_lat

Numeric vector of geographical latitude WGS84.

site_lon

Numeric vector of geographical longitude WGS84.

site_altitude

Numeric vector of height above sea level of surface in m.

site_comment

String vector of additional comments.

Value

Data frame of newly added rows.

See Also

Other custom dbWriteTable functions: dbAddCorrection_station_adlershof(), dbAddCorrection_station_patagonia(), dbAdd_calibration_state(), dbAdd_device_model(), dbAdd_device(), dbAdd_integration(), dbAdd_measurand(), dbAdd_physical_quantity(), dbAdd_station_adlershof(), dbAdd_station_patagonia(), dbWriteTable_device_manufacturer(), dbWriteTable_device_type(), dbWriteTable_integration_type(), dbWriteTable_person(), dbWriteTable_quality_flag()

Examples

1
2
3
4
5
6
## Not run: 
con <- dbConnect_klimageo()
dbWriteTable_site(con, "Adlershof", site_lon = 14., site_lat = 53.)
dbDisconnect(con)

## End(Not run)

sebschub/klimageodb documentation built on Sept. 25, 2021, 4:16 p.m.