PostGIS (Geo-Spacial Data in Postgres)

[nelsonic]

We need to write a mini-example of using Geo Data in Postgres ideally calculating the distance between two pairs of coordinates.

• http://postgis.net/install/
• http://postgis.net/documentation/

[jackcarlisle]

@nelsonic I'll take a look into this 👍

[jackcarlisle]

@nelsonic I've written instructions on how to use PostGIS within the Postgres command prompt to return the distance between two sets of coordinates --> https://github.com/dwyl/learn-postgresql/pull/17

Is this what you had in mind for the example mentioned above?

[jackcarlisle]

Estimated at 4 hours but only took 1. The estimation was 4 hours because I hadn't used PostGIS before but it turned out that it was easily installed and the documentation was very accessible.

[nelsonic]

@jackcarlisle #result ! 😉