## Using GIS in PostgreSQL

### Presented by:

####
Lloyd Albin
(lloyd@thealbins.com)

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

Previous Presentation, to be reworked into a 1 hour presentation

- Date:
- 2017 August 12 14:20
- Duration:
- 50 min
- Room:
- Willow
- Conference:
- PGConf Local: Seattle
- Language:
- Track:
- dev
- Difficulty:
- Easy