Projects
I am a project steering committee member or BDFL for the following projects.
- PostGIS was started under my direction at Refractions Research in 2001, but I didn’t start actively working on it as a developer until 2008. Since then, I’ve re-written the on-disk format, the statistics gathering system, the WKT and WKB parsers, and many other core components.
- The GEOS project is the computational geometry engine for multiple pieces of software, including PostGIS, QGIS, GDAL, MapServer and others. I arranged the financial backing that brought the GEOS port of JTS into existence in 2003. I have been an active community member since.
- This PostgreSQL extension allows point cloud data (often collected with LIDAR, but not restricted to it) to be stored and filtered inside the database. The core concept is a compressed “patch” of points, which provide 3x compression using simple techniques, and SQL access to the points within via accessor functions.
- This PostgreSQL foreign data wrapper extension allows OGR data sources (and OGR supports access to dozens of formats) to be accessed directly within the database as a table. This makes integration of data from Oracle, SQL Server, FGDB files, WFS servers, and many more possible directly within the database.
- This PostgreSQL extension allows direct access to HTTP web services using a simple SQL functional interface. Just call
http_get() or http_post() in your SQL query, and data can be pushed and pulled from web services.
Other Projects
I am also a contributor to a number of other open source projects.
- Over the years, I have worked on the PostGIS drivers and on the GDAL format driver for MapServer, as well as specialty projects like supporting XMP metadata embedding.
- I have contributed some small patches to the project (notably FDW support for extension operator pushdown, and TOAST performance tweaks) and try to stay up-to-date on the project and community.
