Farshid/Ashouri

geospatial

4 posts tagged “geospatial”.

  1. 2025

  2. Creating a minimal SpatiaLite database with Python

    When writing a test for datasette-leaflet-freedraw I realized I didn't have a simple tiny recipe for creating an in-memory SpatiaLite database in Python.

    spatialite sqlite python gis database
    1 min read

  3. Closest locations to a point

    Here's a PostgreSQL SQL query that returns the closest locations to a point, based on a brute-force approach where the database calculates the distance (in miles) to every single row and then sorts by…

    postgresql sql gis django orm
    1 min read
  4. 2024

  5. GUnion to combine geometries in SpatiaLite

    I was playing around with datanews/amtrak-geojson, which provides GeoJSON for Amtrak stations and track segments.

    spatialite sqlite gis geojson datasette
    1 min read
  6. 2023

  7. Converting no-decimal-point latitudes and longitudes using jq

    I had some data with weird co-ordinates in it: Note the and in there. I know that this data refers to somewhere in Houston, and a few people on Twitter pointed out that it's actually really simple…

    jq json data-transformation cli geospatial
    1 min read