GeoPackage and the Related Tables Extension

on YouTube ↗19m

" summary

GeoPackage becomes a single-file container for vector, raster and metadata with an OGC-backed spec, Spatialite/SQLite implementations and executable conformance tests. The related tables extension adds a many-to-many relationship table that can carry attributes so photos, PDFs or procedures link to features without duplication. A proof-of-concept interoperability experiment shows workable cross-implementation exchange; QGIS 3 adoption demonstrates practical uptake. Caveats include optional indexing, 2GB-ish filesystem limits and no rich semantic vocab yet for relationship meaning.

AI-written summary · about

" chapters (6)

1. 0:00Origins of GeoPackage
2. 2:58Data structure and features
3. 5:34Development and collaboration
4. 8:46Related tables and extensions
5. 12:36Graph and media integration
6. 15:01Future and implementation

" related talks

• 54mGeoDjangoJustin Bronn · DjangoCon US 2008
• 21mThe Open Source Geospatial Community, PostGIS, & PostgresRegina Obe · POSETTE: An Event for Postgres 2024
• 19mThe Power of GeoDjangoAnna Kiefer · DjangoCon US 2018
• 53mThis Is PostGISPaul Ramsey · Postgres Open 2012
• 46mGetting Down To Earth: Geospatial Analysis With RailsDaniel Azuma · RailsConf 2012
• 02h 44mBuilding Geographical APIs with Open Data, PostgreSQL & PostGISG. Soldera, S.Prunier · Devoxx France 2022
• 45mBreakout SessionPaul Ramsey · PGConf Silicon Valley 2015
• 24mGeo+Django: Geo beyond the DjangoJoe Jasinski · DjangoCon US 2014