Farshid/Ashouri

spatialite

4 posts tagged “spatialite”.

  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. 2024

  4. 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

  5. KNN queries with SpatiaLite

    The latest version of SpatiaLite adds KNN support, which makes it easy to efficiently answer the question "what are the X closest records to this point".

    TIL spatialite
    1 min read

  6. Finding duplicate records by matching name and nearby distance

    I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters of each other.

    sql gis database duplicates spatialite
    1 min read