News for hackers. Stuff that matters.

A comment on QGIS is the mapping software you didn't know you needed. Parent comment

Re:QGIS is the mapping software you didn't know you needed by geenew on Friday February 10, 2023 @07:47PM (#34748228)
You'd probably be well-served by exporting to some format with a spatial index. GeoJson is just a textfile, not much better than reading in a CSV. The current recommended format is Geopackage (gpkg), which is based on SQLite.

Edit: agreed on the slowness of DB connections, I've found that too, including for relatively small locally-hosted DBs.

[ Parent | on HN ]
Re:QGIS is the mapping software you didn't know you needed by mastax on Friday February 10, 2023 @09:52PM (#34749113)
Yeah, converting it to gpkg sped it up a lot, thanks!

I assumed that since geojson is completely unsuitable for querying directly, it would load the whole thing into a native in-memory format, but perhaps not.

[ Parent | on HN ]