LinuxFest Northwest 2019: Using GIS in Postgres – Real World Examples of PostGIS
Presented by Lloyd Albin
In this presentation we will go over basics of how to install and use PostGIS.
Install Local Postgis / Cloud Solutions
How to calculate distance between two Airports/Points/Locations using
The old school math using the "Spherical Law of Cosines" and "Haversine" formulas.
The new school PostGIS method of doing the same math for calculating the distance
How to calculate flight time and cost between Airports/Points/Locations.
Tiger Datasets (FREE)
World Administrative Datasets (FREE)
Natural Earth Hypsometric Tints (FREE)
Google - Visual Representation of GIS data - Sample
QGIS - Visual Representation of GIS data - Samples