Loads a geometry from a registered source into PostGIS as geom_X

Loads a geometry from a registered source into PostGIS as geom_X

Usage

loadGeometry(connectionDetails, dataSourceUuid)

Arguments

connectionDetails

(list) An object of class connectionDetails as created by the createConnectionDetails function

dataSourceUuid

(UUID) The UUID for the data source that is registered in the backbone.data_source table

Value

A table (geom_X) in PostGIS

Examples

if (FALSE) {

variableSourceId <- 157

variableTable <- DatabaseConnector::dbGetQuery(conn, paste0("SELECT * FROM backbone.variable_source WHERE variable_source_id = ", variableSourceId))

dataSourceRecord <- getDataSourceRecord(conn, variableTable$data_source_uuid)

geomIndex <- getGeomIndexByDataSourceUuid(conn, dataSourceRecord$geom_dependency_uuid)

if (!DatabaseConnector::existsTable(conn, geomIndex$database_schema, paste0("geom_",geomIndex$table_name))) {
  message("Loading geom table dependency")
  loadGeomTable(conn, connectionDetails, dataSourceRecord$geom_dependency_uuid)
}
}