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 😄
Originally posted by @rmx90210 in #342 (comment)