SpatiaLite: Library extending SQLite to support Spatial SQL capabilities

1. timezones-api

   1 3 29 0.0 Python

   A Datasette-powered API for finding the time zone for a latitude/longitude point

   

   I wrote a tutorial on SpatiaLite here: 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

   Here's a demo: https://timezones.datasette.io/timezones/by_point?longitude=... - add ".json" to the URL for the JSON output.

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. timezone-boundary-builder

   2 8 1,089 7.4 JavaScript

   A tool to extract data from Open Street Map (OSM) to build the boundaries of the world's timezones.

   

   I wrote a tutorial on SpatiaLite here: 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

   Here's a demo: https://timezones.datasette.io/timezones/by_point?longitude=... - add ".json" to the URL for the JSON output.

4. bstokml

   3 1 - -

   I 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

Suggest a related project