Getting Started with PostGIS – Import Shapefiles (SHP Files)

Posted on August 30, 2020 by asarver — No Comments ↓

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

Getting Started with PostGIS – Mapping US States

Posted on August 30, 2020 by asarver — No Comments ↓

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

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

As the postgres user, connect to the GIS database

$ psql -d gisdb

Create the states table

Posted on August 30, 2020 by asarver — No Comments ↓

Install and enable EPEL and PowerTools repositories if not already enabled.

Install PostGIS for PostgreSQL 12:

# dnf -y install postgis30_12