Shapefile Importer GUI for PGAdmin3 (for mac)
I had been struggling to add the Shapefile importer tool to PGAdmin3 for a PostGIS database we’re working on in my class but I figured out an alternative! As an aside, the shp2pgsql command line is totally great & amazing, but I wanted to have a GUI for when I want to be extra careful.
I downloaded the OpenGeoSuite from Boundless Geo and if you have the postgres.app and pgAdmin3 installed (which is the setup I definitely recommend for Mac), when you open the geosuite, you can click on the utilities:
Which shows this:
The pgShapeLoader should be pulled in your applications folder and ta da! it’s installed.
Now How Do I Use This Thing?! Open the ShapeLoader to set up your connection details, which if you’re unsure about, can be copied almost word for word from PGAdmin3.
Then click add files…
After adding the file you can edit the SRID, the Geo Column, etc.
I’ve had no problem with this at all, but if it doesn’t work I recommend just using the command line.
QGIS has an option for this of course built in through their SPIT tool (and has a bunch of great data management tools in general that I’ll explain in the future)← back to blog