Query global buildings using DuckDB, GeoParquet, and Source Cooperative

Join us and learn how to query billions of buildings from data hosted on Source Cooperative (an open data platform for modern geospatial data formats) with data hosted in GeoParquet, all queried on your computer using DuckDB!

[@getuabdissa1314]

Hey @Matt, just wanted to share my experience after attending your tutorial last Friday. It was a blast! Over the weekend, I had a great time exploring DuckDB, Source Cooperative, and Geoparquet, Mother Duck. Thanks to your guidance, I even set up a custom keyboard shortcut in my vscode, which is super cool.
One highlight was querying a massive dataset of building features covering the entirety of Madagascar - a whopping 10.8 million entries! It's incredible what can be achieved with tools like Cloud Native, Geoparquet, DuckDB, and Source Cooperative. Thanks again for such an enlightening session!👍

[@MattForrest]

So so glad to hear that!!

[@wyk3982]

Is there a way to improve the video quality? The highest resolution I can get for this video is 720p. The text is hard to read at that resolution.

[@MattForrest]

Yes I didn’t have the right setting for this one sorry!

[@ricardomartinez9895]

Thank you for this demonstration. I am using ST_intestects to spatially query buildings within an area. It retrieves all the polygons but most of them have empty geometries. Is there a maximum number of geometries that I can retrieve?

[@MattForrest]

No limit but not sure why it returns empty geoms. Make sure they are created correctly too.

[@adilmajeed8439]

Basically from Pakistan but living in UAE - Dubai

[@MattForrest]

Welcome!