View source: R/table_updateColumn.R
table_updateColumn | R Documentation |
Updates records in a location table. Records are identified
by locationID
and the data found in locationData
is used to
replace any existing value in the columnName
column.
locationID
and locationData
must be of the same length.
Any NA
values in locationID
will be ignored.
If columnName
is not a named column within locationTbl
, a new
column will be created.
table_updateColumn(
locationTbl = NULL,
columnName = NULL,
locationID = NULL,
locationData = NULL,
verbose = TRUE
)
locationTbl |
Tibble of known locations. |
columnName |
Name of an existing/new column in |
locationID |
Vector of |
locationData |
Vector of data to be inserted at records identified by
|
verbose |
Logical controlling the generation of progress messages. |
Updated tibble of known locations.
table_addColumn
table_removeColumn
library(MazamaLocationUtils)
locationTbl <- get(data("wa_monitors_500"))
wa <- get(data("wa_airfire_meta"))
# We will merge some metadata from wa into locationTbl
# Record indices for wa
wa_indices <- seq(5,65,5)
wa_sub <- wa[wa_indices,]
locationID <-
table_getLocationID(
locationTbl,
wa_sub$longitude,
wa_sub$latitude,
distanceThreshold = 500
)
locationData <- wa_sub$AQSID
locationTbl <-
table_updateColumn(locationTbl, "AQSID", locationID, locationData)
# Look at the data we attempted to merge
wa$AQSID[wa_indices]
# And two columns from the updated locationTbl
locationTbl_indices <- table_getRecordIndex(locationTbl, locationID)
locationTbl[locationTbl_indices, c("city", "AQSID")]
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.