make_spatial_db_table: Add right and left tables to PostGIS and prepare for spatial...

In livelihoods-and-landscapes/maplandscape: Shiny application to explore and visualise GeoPackage data

Add right and left tables to PostGIS and prepare for spatial join

Description

Add right and left tables to PostGIS, convert to geography type, and create spatial indexes.

Usage

make_spatial_db_table(
  con,
  left_table,
  left_table_name,
  right_table,
  right_table_name
)

Arguments

con	connection object to PostGIS database
left_table	sf spatial data frame of left table in spatial join. Geometries for this object will be retained.
left_table_name	name of left table created in PostGIS
right_table	sf spatial data frame of right table in spatial join. Geometries for this object are dropped and column names are added to 'left_table' based on the largest intersection.
right_table_name	name of right table created in PostGIS

livelihoods-and-landscapes/maplandscape documentation built on March 20, 2023, 5:43 a.m.