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-Sheet
On 7/28/23 15:14, Michael Smith wrote:
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<string, list<array_element: map<string,
string ('array_element')>> ('names')> ignored
Warning 1: Field sources of unhandled type list<array_element: map<string, string
('array_element')>> ignored
INFO: Open of
`/vsis3/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=admins/'
using driver `Parquet' successful.
Layer name: theme=admins
Geometry: Unknown (any)
Feature Count: 96455
Extent: (-180.000000, -89.999900) - (180.000000, 89.999900)
Layer SRS WKT:
(unknown)
Geometry Column = geometry
id: String (0.0)
updatetime: String (0.0)
version: Integer (0.0)
adminlevel: Integer (0.0)
maritime: String (0.0)
subtype: String (0.0)
localitytype: String (0.0)
context: String (0.0)
isocountrycodealpha2: String (0.0)
isosubcountrycode: String (0.0)
defaultlanugage: String (0.0)
drivingside: String (0.0)
bbox.minx: Real (0.0)
bbox.maxx: Real (0.0)
bbox.miny: Real (0.0)
bbox.maxy: Real (0.0)
type: String (0.0)
OGRFeature(theme=admins):1
id (String) = 85186a93fffffff1100000000000007
updatetime (String) = 2023-05-28T00:18:08.062Z
version (Integer) = 0
adminlevel (Integer) = 4
maritime (String) = (null)
subtype (String) = (null)
localitytype (String) = (null)
context (String) = (null)
isocountrycodealpha2 (String) = (null)
isosubcountrycode (String) = (null)
defaultlanugage (String) = (null)
drivingside (String) = (null)
bbox.minx (Real) = -0.6814001
bbox.maxx (Real) = -0.6561592
bbox.miny (Real) = 46.686869
bbox.maxy (Real) = 46.7005651
type (String) = administrativeBoundary
LINESTRING (-0.6561592 46.7005651,-0.6576952 46.7001611,-0.6596517
46.6992552,-0.6607547 46.6986231,-0.661421 46.6981174,-0.6642916
46.6959388,-0.6664351 46.6949608,-0.6700295 46.6934809,-0.670524
46.6932773,-0.6719283 46.6922006,-0.6738641 46.6916239,-0.6749166
46.6910205,-0.6764343 46.6894853,-0.6767317 46.6893071,-0.6784728
46.688264,-0.6797574 46.6881753,-0.6807998 46.6873219,-0.6811768
46.6870573,-0.6814001 46.686869)
Mike
On 7/28/23, 6:05 PM, "Michael Smith" <michael.smith.e...@gmail.com
<mailto:michael.smith.e...@gmail.com>> wrote:
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<string, list<array_element: map<string,
string ('array_element')>> ('names')> ignored
Warning 1: Field sources of unhandled type list<array_element: map<string, string
('array_element')>> ignored
INFO: Open of
`/vsis3/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=admins'
using driver `Parquet' successful.
Layer name: theme=admins
Geometry: Unknown (any)
Feature Count: 99403
Extent: (-180.000000, -89.999900) - (180.000000, 89.999900)
Layer SRS WKT:
(unknown)
Geometry Column = geometry
id: String (0.0)
updatetime: String (0.0)
version: Integer (0.0)
adminlevel: Integer (0.0)
maritime: String (0.0)
subtype: String (0.0)
localitytype: String (0.0)
context: String (0.0)
isocountrycodealpha2: String (0.0)
isosubcountrycode: String (0.0)
defaultlanugage: String (0.0)
drivingside: String (0.0)
bbox.minx: Real (0.0)
bbox.maxx: Real (0.0)
bbox.miny: Real (0.0)
bbox.maxy: Real (0.0)
type: String (0.0)
Mike
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
