Derek Dohler has presented the following presentations
Attaching flexible metadata to geometries: marrying PostGIS and JSONB
at
PGConf Local: Philly 2017 [PgConf.US]
presented by Derek Dohler
We were asked to design a system for storing and analyzing information about traffic accidents in the Philippines. The solution needed to support flexible metadata attached to each record, as well as allow geospatial analysis of records. We also needed to be able to make guarantees about data integrity.
To satisfy these requirements, we adopted a database architecture that is a hybrid of do...
more PostgreSQL