Lots of people ask me how to get data into Postgis. This video is a quick 8 minute demonstration of 6 ways to get data into Postgres – 4 free (PGAdmin III, shp2pgsql, ogr2ogr, QGIS Database Manager) and two commercial. (Manifold 8, Manifold 9).
Now, in this case I’m only working with a shapefile and Postgres. I will do another post that works with other data (geodatabases, Autocad, etc.), and other databases (SQL Server, Oracle, etc.). I hope you enjoy it. Also, if you have other ways you like getting data into Postgis, leave a comment below….
want to learn how to use PostGIS, QGIS, Manifold, or other advanced GIS tools. Check out my courses here. Some of the catchy titles are Big Data Analytics with GIS, Manage Spatial Data with Microsoft SQL Server, Enterprise GIS with Open Source Software, Spatial SQL With PostGIS , and Python for Geospatial.