Geomermaids parquetry — S3-compatible read-only API Bucket: parquetry Endpoint: https://s3.geomermaids.com Setup (DuckDB): INSTALL httpfs; LOAD httpfs; SET s3_endpoint='s3.geomermaids.com'; SET s3_url_style='path'; SET s3_use_ssl=true; SET s3_access_key_id=''; SET s3_secret_access_key=''; Datasets, one prefix each (browse them at https://parquetry.geomermaids.com/): osm/ OpenStreetMap, North America, nightly. Partitioned; glob it: SELECT count(*) FROM read_parquet( 's3://parquetry/osm/latest/country=*/state=*/aeroways.parquet'); gaul/ FAO GAUL 2024, global admin units. Per level, one whole-world file (L2.parquet, 490 MB) and one file per country to glob: SELECT country, count(*) FROM read_parquet( 's3://parquetry/gaul/2024/country=*/L2.parquet', hive_partitioning = true) GROUP BY 1; clc/ Corine Land Cover 2018, Europe. One Europe file (clc_2018.parquet) and one file per country to glob: SELECT country, count(*) FROM read_parquet( 's3://parquetry/clc/2018/country=*/clc_2018.parquet') GROUP BY 1; nfhl/ FEMA National Flood Hazard Layer, flood hazard areas, updated daily. One file per county delivery, indexed by counties.parquet: SELECT state, risk, count(*) FROM read_parquet( 's3://parquetry/nfhl/latest/state=*/*.parquet') GROUP BY ALL; Every https://parquetry.geomermaids.com/ is s3://parquetry/ here. Fast browser-friendly downloads: https://parquetry.geomermaids.com/