Getting Started with PostGIS – Import Shapefiles (SHP Files)

You will need a PostgreSQL server with PostGIS extensions enabled on a database.

Find some data you want to plot. A good free resource is https://hub.arcgis.com/

In this tutorial, we will use Internet Towers in Parkland County, Alberta, Canada. https://hub.arcgis.com/datasets/tempegov::accessible-service-providers

Read more Getting Started with PostGIS – Import Shapefiles (SHP Files)

Getting Started with PostGIS – Mapping US States

You will need a PostgreSQL server with PostGIS extensions enabled on a database.

Download some sample data. This tutorial uses the US States.

https://www.kaggle.com/washimahmed/usa-latlong-for-state-abbreviations

As the postgres user, connect to the GIS database

$ psql -d gisdb

Create the states table

Read more Getting Started with PostGIS – Mapping US States