For what it's worth, this is as far as I've gotten and it works:
ogr2ogr -dialect sqlite -sql @admins.sql -nln over -overwrite
admins.gpkg /vsis3/overturemaps-us-west-2/release/2023-07-26-alpha.0
I've got a cheat sheet set up with the sql at:
https://www.postholer.com/articles/Overature-Cheat-
Here's fetching the first admin boundary:
docker run --rm -it ghcr.io/osgeo/gdal:ubuntu-full-latest ogrinfo
/vsis3/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=admins/ -where
"type='administrativeBoundary'" -al -fid 1
Warning 1: Field names of unhandled type map> ('names')> ignored
Paul,
I had to use 3.7.1 to have it read the geometry properly, 3.7.0 would read the
directories.
docker run --rm -it ghcr.io/osgeo/gdal:ubuntu-full-latest ogrinfo
/vsis3/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=admins -al -so
Warning 1: Field names of unhandled type map> ('nam
I am playing with accessing the Overture data dump, which is multiple
files in each S3 bucket. The doco says that as of 3.6 (check!), with
the libarrow_dataset build (check) I should be able to read directory
collections as layers, but no luck thus far:
AWS_REGION=us-west-2 AWS_NO_SIGN_REQUEST=YES
