Validate location references (Database Version)
validate_location_reference_db.RdThis function checks if the location reference provided in the dataset exists in the database. Note: This function assumes that the data is already present in the database.
Usage
validate_location_reference_db(
con,
table_name,
row_number_col,
name_col,
level_I_col,
level_II_col
)Arguments
- con
A database connection object.
- table_name
The name of the formatted CSV table in the database.
- row_number_col
The name of the row number column.
- name_col
The name of the name column for locations.
- level_I_col
The name of the Level I column for locations.
- level_II_col
The name of the Level II column for locations.