Import CSV and Export as Shapefile in PostGIS

This tutorial focuses on postgis importing a CSV to shapefile and exporting, importing and exporting shapefiles. First of all we will initiate your PostGIS database and de-identify your csv record. Here, you will understand how to filter data with SQL commands and prepare your CSV data successfully in a right format for your spatial needs with using PostGIS functions.

After you will have imported your data, you will be led through the process of exporting the data in to a shapefile format. This one entails the process of exporting of PostGIS data in a format that can easily be used in GIS applications. At the end of this tutorial you will know how to finish the export process with `pgsql2shp` and other PostGIS tools. At the end of this tutorial you shall have understood the proper legitimate spatial database management system within PostGIS and be well equipped on the sharing of the said spatial data in a shapefile format.