Paul Ramsey is a Solutions Engineer at Carto. He has been working with geospatial software for over 15 years: consulting to government and industry; building a geospatial software company; and programming on open source software. He co-founded the PostGIS spatial database project in 2001, and is currently an active developer and member of the project steering committee. In 2008, Paul received the Sol Katz Award for achievement in open source geospatial software. Paul speaks and teaches regularly at conferences around the world.
No video of the event yet, sorry!
PostGIS adds spatial types to the database, so they can be used “just like any other type”. But unfortunately, spatial types aren’t quite like other types: they’re bigger, they require a lot of complicated algorithms to reason with, and they are built against an implicit model of the world that is generally understood by GIS people but can be a foreign world to database people. This can lead to Gotchas: things that we think should, in a rational world, work fine, but for some reason don’t. This talk will cover the things that make PostGIS different from other database extensions, and the gotchas that arise from those things, so you can use PostGIS without being Got.
- 2018 April 18 11:30
- 50 min
- PostgresConf US 2018
- Postgres Internals