4 ms·
Interesting and very relevant to the discussion! Hmm... Does SQLite have some geo data or 2d coordinate lookup capabilities as well?
by asmosoinio 9y ago
Interesting and very relevant to the discussion!
Hmm... Does SQLite have some geo data or 2d coordinate lookup capabilities as well?
- i_feel_great 9y agoThere is some mention of that here: https://www.sqlite.org/rtree.html https://www.sqlite.org/rtree.html
- mynewtb 9y agoGeoPackage is a great geodata format on sqlite. Also check out spatialite.
- shawn-butler 9y agoTry SpatialLite[0] if you need advanced geometry capabilities. Has R-Tree spatial indexes if you use SQLite 3.6+, and rudimentary MBR index for prior versions. Has rudimentary support for curves as well. [0]: https://www.gaia-gis.it/fossil/libspatialite/index https://www.gaia-gis.it/fossil/libspatialite/index
- justinclift 9y agoAs a data point, one of our users figured out how to load the SpatiaLite extension for DB Browser for SQLite (on Windows), then wrote up step by step instructions: https://github.com/sqlitebrowser/sqlitebrowser/wiki/SpatiaLite-on-Windows https://github.com/sqlitebrowser/sqlitebrowser/wiki/SpatiaLi... (people had been asking previously, but we had no idea. ^\o/^)