SpatiaLite: Library extending SQLite to support Spatial SQL capabilities

• timezones-api

  2 27 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.

• timezone-boundary-builder

  7 818 8.0 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.

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• bstokml

  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