**What it does:**
Reads parquet KV metadata from [Overture Maps Foundation](https://www.linkedin.com/company/overture-maps-foundation/) or any GeoParquet dataset and extracts geometry-related metadata such as bbox, geometry types, encoding, and version.
[DuckDB](https://www.linkedin.com/company/duckdb/) lets you inspect a significant amount of remote data directly in your browser ... including metadata for datasets hundreds of gigabytes in size without downloading the full 200+ GB.
![[Pasted image 20251111043028.png]]
---
## **SQL**
```sql
WITH kv AS (
SELECT
file_name,
decode(key) AS key_str, -- BLOB → VARCHAR
decode(value)::JSON AS geo_json -- BLOB → VARCHAR → JSON
FROM parquet_kv_metadata(
's3://overturemaps-us-west-2/release/2025-10-22.0/theme=addresses/type=address/*'
)
)
SELECT
file_name,
geo_json->'$.columns.geometry.bbox' AS bbox,
geo_json->'$.columns.geometry.geometry_types' AS geom_types,
geo_json->>'$.columns.geometry.encoding' AS encoding,
geo_json->>'$.primary_column' AS primary_column,
geo_json->>'$.version' AS geo_version,
geo_json AS full_metadata
FROM kv
WHERE key_str = 'geo';
```
## DuckDB-WASM Shell - **Try it live:**
🔗 [https://cutt.ly/DuckDB-Snippet-1](https://cutt.ly/DuckDB-Snippet-1)
<iframe src="https://shell.duckdb.org/#queries=v0,INSTALL-httpfs~%0ALOAD-httpfs~%0A%0AWITH-kv-AS-(%0A--SELECT%0A----file_name%2C%0A----decode(key)--------------AS-key_str%2C--------%20%20-BLOB-%20%3E-VARCHAR%0A----decode(value)%3A%3AJSON------AS-geo_json--------%20%20-BLOB-%20%3E-VARCHAR-%20%3E-JSON%0A--FROM-parquet_kv_metadata(%0A----'s3%3A%2F%2Foverturemaps%20us%20west%202%2Frelease%2F2025%2010%2022.0%2Ftheme%3Daddresses%2Ftype%3Daddress%2F*'%0A--)%0A)%0ASELECT%0A--file_name%2C%0A--geo_json%20%3E'%24.columns.geometry.bbox'-----------------AS-bbox%2C%0A--geo_json%20%3E'%24.columns.geometry.geometry_types'-------AS-geom_types%2C%0A--geo_json%20%3E%3E'%24.columns.geometry.encoding'------------AS-encoding%2C%0A--geo_json%20%3E%3E'%24.primary_column'-----------------------AS-primary_column%2C%0A--geo_json%20%3E%3E'%24.version'------------------------------AS-geo_version%2C%0A--geo_json--------------------------------------------AS-full_metadata%0AFROM-kv%0AWHERE-key_str-%3D-'geo'~" width="100%" height="740" style="border: 1px solid black;"> </iframe>
___
#Linkedin : https://www.linkedin.com/posts/yharby_duckdb-activity-7393839157791436800-GZHd