About
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.
Paul Ramsey has presented the following presentations
PostGIS Gotchas
at
PostgresConf US 2018
The things you didn’t know that lead to confusion and dismay
presented by Paul Ramsey
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...
more Wed 18 2018 Postgres Internals