3

I have a remote PostGIS DB and tables with permissions and users, containing data that is being published on GeoServer; and in the office locally, we have an ESRI corporative GDB that is being updated constantly, so now I have to "update" the features on Postgres DB using the updated shape that I export from ESRI GDB.

In ArcCatalog we just erase/delete all the features inside a featureClass and then use the "load" (right click) tool to load all the features from other layers(shape, personal/file/corporative gdb) inside the featureClass. I need to know:

If there's a way to do something similar with QGIS to "load" features from a layer/table inside another layer/table?

Or do the same directly on Postgres tables using PGAdmin?

I shouldn't delete the PostGIS table and use the shape loader since the table is being published and has its own permissions and I think its a mess to "delete and use shapeloader" every time we need to update it.

One option is to open both layers on QGIS and erase all the features in the PostGIS layer and then select and "copy/paste" features from the updated shape but its impossible since QGIS collapsed if you try it with more than (for example) 8.000 features at a time and the layers have ~80.000 features. So doing copy/paste in "small bites" is time consuming, like spending a half-day selecting/copy/paste and saving...

  • There are many possible solutions that don't involve the awkward procedures you are currently using. I would suggest that you focus the question on one solution (ArcGIS, SQL, QGIS) since the answers are very different. – Vince Sep 9 '14 at 13:28
1

Not sure about all your deleting, and copy/pasting. But in QGIS you have the DBManager plugin for uploading shapefile (and other) layers to PostGIS. And there's the standalone shp2pgsql-gui application (comes with pgAdmin3)

  • You can also try OpenGeo Explorer plugin for qGIS. You can import, delete, rename tables, edit fields with that plugin. – Roman Sep 10 '14 at 5:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.