3 ms·
SpatiaLite: Library extending SQLite to support Spatial SQL capabilities
- philips 3y agoI am just learning about the GIS space and the ubiquity of PostGIS being built in to postgres is very helpful! On most cloud or local postgres installs you are one “create extension” away from having the features available. This sqlite library looks great but having to install these extensions separate from sqlite seems like a hurdle. For example see the Django docs. https://docs.djangoproject.com/en/5.0/ref/contrib/gis/install/spatialite/ https://docs.djangoproject.com/en/5.0/ref/contrib/gis/instal...
- simonw 3y agoI have some notes on installing SpatiaLite in the Datasette documentation here: https://docs.datasette.io/en/stable/spatialite.html https://docs.datasette.io/en/stable/spatialite.html It's not too bad - you can get it from Homebrew on macOS and apt-get has it on Ubuntu and Debian.
- simonw 3y agoI wrote a tutorial on SpatiaLite here: https://datasette.io/tutorials/spatialite https://datasette.io/tutorials/spatialite - "Building a location to time zone API with SpatiaLite" It shows how to use SpatiaLite + Datasette to build an API that can tell you what timezone a latitude/longitude point is in, using data derived from OpenStreetMap via https://github.com/evansiroky/timezone-boundary-builder https://github.com/evansiroky/timezone-boundary-builder Here's a demo: https://timezones.datasette.io/timezones/by_point?longitude=-73.9855&latitude=40.7580 https://timezones.datasette.io/timezones/by_point?longitude=... - add ".json" to the URL for the JSON output.
- deleted 3y ago[deleted]
- btreecat 3y agoI used this wonderful library when I need to answer how close the airplanes were over my head for safe UAS operations on the ground. This was near an uncontrolled airport (no tower) so the airspace and general legal limit was 400 ft AGL but I recorded aircraft as low as 175 ft AGL on their down wind leg of the landing approach. The tool gathered ads-b data from the aircraft using an rtlsdr, then let me plot it on Google Earth for analysis. Was really useful to me at the time and a fun way to learn a little about GIS. https://gitlab.com/btreecat/bstokml https://gitlab.com/btreecat/bstokml