Presented by:

02cb47d9205a64cc8e52e91ab6831f4d

Lloyd Albin

Fred Hutchinson Cancer Research Center

I have been a PostgreSQL administrator since 2002 and have worked for Fred Hutch for the last 9 years. I host the Seattle Postgres Users Group and give many of the presentations. I have many of the presentations posted at Lloyd's Presentations

No video of the event yet, sorry!

In this presentation we will go over the old school math and the new school PostGIS method of doing the same math for calculating the distance and cost of an aircraft flight. You will notice how much easier it is to 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:
2017 November 14 16:40
Duration:
50 min
Room:
Ravenna
Conference:
PGConf Local: Seattle
Language:
Track:
dev
Difficulty:
Easy