[HN Gopher] Pbf2sqlite: Reading OpenStreetMap into a SQLite Data...
       ___________________________________________________________________
        
       Pbf2sqlite: Reading OpenStreetMap into a SQLite Database
        
       Author : amadeuspagel
       Score  : 23 points
       Date   : 2025-07-01 09:17 UTC (13 hours ago)
        
 (HTM) web link (github.com)
 (TXT) w3m dump (github.com)
        
       | milliams wrote:
       | Does SQLite have GIS capabilities (like PostGIS provides for
       | Postgres), or is this storing the data as traditional database
       | primitives?
        
         | fros1y wrote:
         | Check out Spatialite. https://www.gaia-
         | gis.it/fossil/libspatialite/index
        
         | 0cf8612b2e1e wrote:
         | DuckDB has put some effort into GIS, so if SQLite does not
         | immediately fit the bill, I would go there.
         | 
         | https://motherduck.com/blog/getting-started-gis-duckdb/
        
         | Scaevolus wrote:
         | SQLite can be built with the R*tree module, which supports
         | efficiently looking up all bounding boxes that contain a point:
         | https://www.sqlite.org/rtree.html
         | 
         | PostGIS similarly provides an R*Tree index mode, as well as a
         | heap of functions for doing GIS calculations directly. To do
         | that in SQLite, you'd implement and inject custom functions as
         | appropriate.
        
       ___________________________________________________________________
       (page generated 2025-07-01 23:02 UTC)