Using GIS in Postgres
Schedule

Presented by:

02cb47d9205a64cc8e52e91ab6831f4d

Lloyd Albin

from Fred Hutchinson Cancer Research Center

I have been a PostgreSQL Administrator since 2002 and have worked for the Fred Hutchinson Cancer Research Center since 2008. Within Fred Hutch, I am the Principal Database Administrator for 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 I am an organizer of PostgresConf.org the largest PostgreSQL conference in the US.

In this presentation we will go over basics of how to install and use PostGIS.

  • Installing PostGIS
    • Cloud Solutions
    • From Source
  • Aviation Math
    • Airplane Performance
    • Great Circle Math
  • PostGIS Math
    • Updating your tables to make GIS faster
    • Oh how easy it is to read and write GIS
  • Taxes
    • Adding per Passenger Taxes
    • Adding Airport Taxes
  • References

Using GIS in PostgreSQL

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

Happening at the same time:

  1. Harness the power of Kubernetes and Istio
    2. Start Time:
    2018 April 28 02:30

    Room:
    CC-202 TUT2

  2. Video & Audio Production on Linux
    3. Start Time:
    2018 April 28 02:30

    Room:
    HC-108

  3. Writing your own VM - Programming Language
    4. Start Time:
    2018 April 28 02:30

    Room:
    CC-201 TUT1

  4. Introducing DistroTweaks… A New Way to Share Linux
    5. Start Time:
    2018 April 28 02:30

    Room:
    CC-235

  5. JavaScript in a Bottle
    6. Start Time:
    2018 April 28 02:30

    Room:
    CC-236

  6. Watch out for that tree!
    7. Start Time:
    2018 April 28 02:30

    Room:
    CC-208

  7. Security Theatre
    8. Start Time:
    2018 April 28 02:30

    Room:
    CC-200

  8. Incompossibilities: Limitations and Trade-offs in Technology Design
    9. Start Time:
    2018 April 28 02:30

    Room:
    G-103

  9. Bellingham Publicly Owned Fiber Optic Network
    10. Start Time:
    2018 April 28 02:30

    Room:
    CC-114

  10. Introduction to Git (even for non-developers)
    11. Start Time:
    2018 April 28 02:30

    Room:
    CC-115

  11. Using GIS in Postgres
    12. Start Time:
    2018 April 28 02:30

    Room:
    HC-103 Postgres

  12. Build and Program Your First NXT Robot
    13. Start Time:
    2018 April 28 02:30

    Room:
    CC-234 BAIRS