Wednesday, 4 July 2018

Bulk load multiple shapefiles into PostGIS


I've got over a hundred data layers in shapefile format that I want to upload into a PostGIS database. They are all in the same projection, but represent different data layers so they do not have the same schema.


What is the most time-effective way to bulk convert all of these files into my PostGIS database (on windows 7 OS)?


UPDATE: Bulk importing in the pgAdmin3 "PostGIS shapefile uploader" (as noted below) is now available by default with PostGIS 2.0.




Answer



If want to stick to a GUI then the newer version of pgAdmin has Shapefile Loader that can be used as a bulk load


enter image description here


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...