improve docs on indexing in data structures

[danabauer]

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 Robert Martin (@rmx90210) in #342 (comment)