Mark Litwintschik marklit

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                                        │

$ 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-&gt;'$.geometry') geom

https://beta.source.coop/repositories/pacificspatial/flateau/description/

https://github.com/pacificspatial/flateau/

$ aws s3 --no-sign-request \
         sync \
         --exclude="*" \
         --include="*building_lod0.parquet" \
 s3://flateau/data/plateau \

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:

$ 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;

SELECT ADOB_ID,
       ADS_OID,
       ADOB_LIIK,
       ORIG_TUNNUS,
       ADS_KEHTIV,
       VIITEPUNKT_X,
       VIITEPUNKT_Y,

DuckDB v1.0.0 1f98600c2c

$ cd '/mnt/j/gis/Global/overture/2024_07/theme=addresses/type=address'
$ COUNTRY=CA
$ echo "COPY (
              SELECT h3_cell_to_boundary_wkt(
                          h3_latlng_to_cell(bbox.ymax, bbox.xmax, 5))::geometry geom,
                      COUNT(*)
 FROM read_parquet('*.parquet')

Signature version complaint via awscli

$ virtualenv ~/.aws
$ source ~/.aws/bin/activate
$ pip install awscli

$ aws --version

	┌─────────────────────────────────────────────┬────────┐
	│ osm │ delta │
	│ varchar │ int128 │
	├─────────────────────────────────────────────┼────────┤
	│ asia │ 550678 │
	│ gcc-states │ 152516 │
	│ europe │ 144383 │
	│ myanmar │ 94939 │
	│ china │ 75607 │
	│ india │ 69950 │

	COPY (
	SELECT * EXCLUDE (geometry,
	bbox,
	names,
	sources),
	ST_GEOMFROMWKB(geometry) geom,
	JSON(bbox) AS bbox,
	JSON(names) AS names,
	JSON(sources) AS sources
	FROM read_parquet('s3://overturemaps-us-west-2/release/2024-06-13-beta.0/theme=buildings/type=building/00208',