Presented by:

02cb47d9205a64cc8e52e91ab6831f4d

Lloyd Albin

from Fred Hutchinson Cancer Research Center

I have been a PostgreSQL administrator since 2002 and have worked for Fred Hutchinson Cancer Research Center for the last 10+ years. Within Fred Hutch, I work for the largest group called SCHARP, Statistical Center for HIV/AIDS Research and Prevention.

I host the Seattle Postgres Users Group where I give many of the presentations. I have many of the presentations posted at Lloyd's Presentations

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

Date:
Duration:
45 min
Room:
HC-103 Postgres
Conference:
LinuxFest Northwest 2019
Language:
Track:
Postgres Track
Difficulty:
Easy

Happening at the same time:

  1. Using GIS in Postgres – Real World Examples of PostGIS
  2. Start Time:
    2019 April 27 13:00

    Room:
    HC-103 Postgres

  3. Open Source is Not Just GitHub
  4. Start Time:
    2019 April 27 13:00

    Room:
    CC-236

  5. Common sense career transitions
  6. Start Time:
    2019 April 27 13:00

    Room:
    CC-235

  7. Where is netstat? It's gone!
  8. Start Time:
    2019 April 27 13:00

    Room:
    CC-114

  9. Linux Sucks. IN SPACE.
  10. Start Time:
    2019 April 27 13:00

    Room:
    HC-108

  11. The Current State of Free and Open Source Software in Public Education
  12. Start Time:
    2019 April 27 13:00

    Room:
    CC-200

  13. Freedom, Security and Privacy
  14. Start Time:
    2019 April 27 13:00

    Room:
    G-103

  15. From Sysadmin to DevOps Engineer -- The Easy Way!
  16. Start Time:
    2019 April 27 13:00

    Room:
    CC-115

  17. Defending Out-of-Band Management Attacks
  18. Start Time:
    2019 April 27 13:00

    Room:
    CC-208