[addresses] Querying US addresses by state

[Robert Martin (rmx90210)]

Category Feedback

Hello Overture friends!

I'm trying to query for US addresses in a particular state — say California. (Using DuckDB.) Based on the address schema I was expecting this to work:

select *
from read_parquet('s3://overturemaps-us-west-2/release/2025-02-19.0/theme=addresses/type=address/*')
where
  country = 'US' and
  address_levels[0].value = 'CA'

However I get no results. Am I doing this wrong?

Dependency with other categories, if any.

No response

[Robert Martin (rmx90210)]

I think I figured this out — they are 1-indexed! So my query should have been:

select *
from read_parquet('s3://overturemaps-us-west-2/release/2025-02-19.0/theme=addresses/type=address/*')
where
  country = 'US' and
  address_levels[1].value = 'CA'

As a side note, if anyone can point me to where the 1-indexing is documented, that would be super helpful. I'd like to understand what I'm doing a bit better 😄