Skip to content

Instantly share code, notes, and snippets.

View marklit's full-sized avatar

Mark Litwintschik marklit

175 followers · 37 following
View GitHub Profile
@marklit
marklit / troubleshooting.md
Created March 10, 2025 07:44
Wyvern STAC unavilable 
$ curl -A'curl' -L ipinfo.io
{
  "ip": "40.177.26.232",
  "hostname": "ec2-40-177-26-232.ca-west-1.compute.amazonaws.com",
  "city": "Calgary",
  "region": "Alberta",
@marklit
marklit / L0s.txt
Created March 5, 2025 15:56
Satellogic Samples
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039074787Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039088932Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039201597Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039215742Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039328461Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-newsat43-20240601T064039342606Z-micro-L0-v0.1.8_analytic.tiff"
"Baotou/0392e349-af81-4b9f-90ca-283070dc4dbb/SL-newsat43-20240601T064039074787Z-micro-L0/SL-ne
@marklit
marklit / README.md
Last active March 13, 2025 03:21
Satellogic's Open Satellite Feed
@marklit
marklit / runbook.md
Last active February 25, 2025 10:54
Planet Labs TLE Feed 
$ python3 -m venv ~/.sats
$ source ~/.sats/bin/activate
$ python3 -m pip install astropy

$ wget https://ephemerides.planet-labs.com/planet_mc.tle
from   datetime import datetime
@marklit
marklit / results.txt
Created November 21, 2024 13:39
Overture 2024-09-18.0 buildings vs 2024-11-13.0
┌─────────────────────────────────────────────┬────────┐
│ osm │ delta │
│ varchar │ int128 │
├─────────────────────────────────────────────┼────────┤
│ asia │ 550678 │
│ gcc-states │ 152516 │
│ europe │ 144383 │
│ myanmar │ 94939 │
│ china │ 75607 │
│ india │ 69950 │
@marklit
marklit / umbra.india.md
Created November 14, 2024 17:32
Umbra's India SAR Imagery 
select s3_key from umbra where osm_region like '%zone%' and s3_key like '%GEC.tif' ORDER BY 1;
┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│                                                                               s3_key                                                                                │
│                                                                               varchar                                                                               │
├─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ sar-data/tasks/ad hoc/0ce837c5-e3a8-4b30-b5a4-5420c5fedfba/2024-06-06-15-20-13_UMBRA-04/2024-06-06-15-20-13_UMBRA-04_GEC.tif                                        │
@marklit
marklit / roads.md
Created October 7, 2024 10:01
MS Roads Detection in Parquet 
$ wget https://usaminedroads.blob.core.windows.net/road-detections/MiddleEast-Full.zip
$ unzip MiddleEast-Full.zip
$ ~/duckdb roads.duckdb
CREATE OR REPLACE TABLE roads AS
    SELECT column0 as iso2,
 ST_GEOMFROMGeoJSON(column1::JSON->'$.geometry') geom
@marklit
marklit / japan.gis.parquet.md
Last active August 22, 2024 16:58
Pacific Spatial Solutions: Japanese GIS Data
@marklit
marklit / airport_amenities_osm.md
Last active August 20, 2024 08:12
Airport Amenities

Airport Shops on OSM

Tallinn Airport is said to be the 'cosiest' airport in the world. If you search for that on Google they come up first. I noticed none of the shops or other amenities around the gates are marked in OSM.

I wrote some code to see if this was an issue at airports of a similar size or larger nearby in other EU countries. I got a lot of false-positives but this code might help anyone else looking to enrich the Airport metadata in OSM.

TLL is surrounded by dense urban areas and a major shopping mall so I built a polygon mask around the airport gates and counted the shops within it.

Airports that came back with no shops within their gate area mask where:

@marklit
marklit / partition.md
Last active August 7, 2024 11:40
Partition Denmark by Address 
$ aws s3 --no-sign-request sync \
    s3://overturemaps-us-west-2/release/2024-07-22.0/theme=addresses/type=address/ \
    ~/addresses
$ cd ~/addresses
$ ~/duckdb
INSTALL spatial;