I have a postgis table created by importing a shapefile containing land parcels. The county releases a new shapefile containing updated data monthly and I want to incorporate that into my database.
The original data was uploaded using QGIS' database manager plugin. I'm fairly new to postgis.
I have views based on the data, so dropping the table and re-uploading isn't a great option. What I did last time was to use a DELETE command to completely empty the table then uploading the shapefile into a temporary table and using a INSERT * INTO ... command to copy all the data over.
This seems like a cumbersome process to go through monthly, especially since only a small percent of the data changes. Is there a better way to go about this?