MAmaxxen·Sep 9, 2024
I still need to update the docs and there's probably going to be a blog post on it in the future, but for now there are some more details in the PR https://github.com/duckdb/duckdb_spatial/pull/383
In DuckDB 1.1.0 Releasedduckdb
duckdb-spatial
C2024–2024
duckdb / duckdb-spatial
duckdb-spatial
Discover this repository through its Hacker News conversations.
2Distinct people
2Mentions
0Explicit recommenders
723GitHub stars
What to know before exploring
What it is
A public description has not been verified.
Where it is used
No documented product use has been verified yet.
What people are saying
No recommendation phrase was found in the indexed comments.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
No other repository is repeatedly linked in the same discussions.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:03:16 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by week2 dated mentions
Observed mentions: 2024-07-06 16:59:20 UTC to 2024-09-09 19:42:49 UTC. Weeks start Monday, UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| Jul 1 | 2024-07-01 00:00:00 UTC | 2024-07-08 00:00:00 UTC | 1 | 0 | 1 |
| Jul 8 | 2024-07-08 00:00:00 UTC | 2024-07-15 00:00:00 UTC | 0 | 0 | 0 |
| Jul 15 | 2024-07-15 00:00:00 UTC | 2024-07-22 00:00:00 UTC | 0 | 0 | 0 |
| Jul 22 | 2024-07-22 00:00:00 UTC | 2024-07-29 00:00:00 UTC | 0 | 0 | 0 |
| Jul 29 | 2024-07-29 00:00:00 UTC | 2024-08-05 00:00:00 UTC | 0 | 0 | 0 |
| Aug 5 | 2024-08-05 00:00:00 UTC | 2024-08-12 00:00:00 UTC | 0 | 0 | 0 |
| Aug 12 | 2024-08-12 00:00:00 UTC | 2024-08-19 00:00:00 UTC | 0 | 0 | 0 |
| Aug 19 | 2024-08-19 00:00:00 UTC | 2024-08-26 00:00:00 UTC | 0 | 0 | 0 |
| Aug 26 | 2024-08-26 00:00:00 UTC | 2024-09-02 00:00:00 UTC | 0 | 0 | 0 |
| Sep 2 | 2024-09-02 00:00:00 UTC | 2024-09-09 00:00:00 UTC | 0 | 0 | 0 |
| Sep 9 | 2024-09-09 00:00:00 UTC | 2024-09-16 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
2 sourcesI recently discovered DuckDB's Read_OSM() function [1], which lets you query OSM PBF files directly.
For example, it's simple to count the cafes in North America in under 30s:
SELECT COUNT(*) FROM st_readOSM('/home/wcedmisten/Downloads/north-america-latest.osm.pbf') WHERE tags['amenity'] = ['cafe'];
┌──────────────┐
│ count_star() │
│ int64 │
├──────────────┤
│ 57150 │
└──────────────┘
Run Time (s): real 24.643 user 379.067204 sys 3.696217
Unfortunately, I discovered there are still some bugs [2] that need to be ironed out, but it seems very promising for doing high performance queries with minimal effort.
[1]: https://duckdb.org/docs/extensions/spatial.html#st_readosm--...
[2]: https://github.com/duckdb/duckdb_spatial/issues/349
In Optimizing Large-Scale OpenStreetMap Data with SQLite