timezones-api
bstokml
| timezones-api | bstokml | |
|---|---|---|
| 2 | 1 | |
| 27 | - | |
| - | - | |
| 0.0 | - | |
| over 1 year ago | - | |
| Python | ||
| - | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
timezones-api
-
SpatiaLite: Library extending SQLite to support Spatial SQL capabilities
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.
-
SpatiaLite: A Spatial Extension to SQLite
It had been quite a while since a major release, but then SpatiaLite 5.0 came out a couple of months ago with some very significant new features - the K-Nearest-Neighbor stuff is particularly interesting. https://www.gaia-gis.it/fossil/libspatialite/wiki?name=5.0.0...
I've built a few fun demos using SpatiaLite and Datasette. Here's an API that tells you the timezone for a latitude longitude point:
https://timezones-api.datasette.io/timezones/by_point?longit... - implementation here: https://github.com/simonw/timezones-api
And here's the same thing for which US county a point is within: https://us-counties.datasette.io/counties/county_for_latitud... - implementation here: https://github.com/simonw/us-counties-datasette
I've also built an experimental Datasette plugin that lets you draw a shape on a Leaflet map to generate a GeoJSON polygon, then uses SpatiaLite to show you geometries that are contained by that drawn polygon. I wrote about that here: https://simonwillison.net/2021/Jan/24/drawing-shapes-spatial...
bstokml
-
SpatiaLite: Library extending SQLite to support Spatial SQL capabilities
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
What are some alternatives?
us-counties-datasette - A Datasette instance exposing names, FIPS codes and polygons of US counties
sqlite-utils - Python CLI utility and library for manipulating SQLite databases