Skip to content

Instantly share code, notes, and snippets.

@do-me

do-me/query.sql

Created January 30, 2026 15:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save do-me/a55d36a094aae548e9d9f1902cc27a37 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save do-me/a55d36a094aae548e9d9f1902cc27a37 to your computer and use it in GitHub Desktop.
Download ZIP
Query AlphaEarth Embeddings Tiles, which ones to download for your AOI? Just use https://demo.duckui.com/
Raw
query.sql
INSTALL spatial;
LOAD spatial;
-- query for Milan, Italy
SELECT *
FROM 'https://data.source.coop/tge-labs/aef/v1/annual/aef_index.parquet'
WHERE wgs84_west <= 9.25
AND wgs84_east >= 9.10
AND wgs84_south <= 45.55
AND wgs84_north >= 45.40
-- ST_Intersects(geom, ST_Point(9.1900, 45.4642)); -- or use a point query
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment