I have two shapefiles -
test7 has about 600,000 records with over one hundred attributes (about ~2GB) , so performing spatial joins in QGIS is very inefficient. I would like to find out the equivalent SQL command of QGIS
Join attributes by location in PostGIS. My aim is to add the columns of
test7 and to keep both matching and non-matching records.
This would be a polygons in polygons operation. (So a polygon in
test7 would have to be fully within a polygon in
MD_Overlay in order to be joined)
I have done much research but cannot find a solution. Any advice?