Ah, easy 😊 From: Even Rouault <even.roua...@spatialys.com> Sent: Monday, July 22, 2024 8:30 PM To: Joaquim Manuel Freire Luís <jl...@ualg.pt>; gdal-dev@lists.osgeo.org Subject: Re: [gdal-dev] Extracting data from a parquet file
Le 22/07/2024 à 21:10, Joaquim Manuel Freire Luís a écrit : Even, Thanks for the explanation. But how did you find the name of the geometries (geo_point_2D and geo_shape)? Loading the “world-administrative-boundaries.parquet” in a binary editor I can see them there, but that’s certainly not the way to find these things. $ ogrinfo world-administrative-boundaries.parquet -al -so | grep "Geometry Column" Geometry Column 1 = geo_point_2d Geometry Column 2 = geo_shape Joaquim From: Even Rouault <even.roua...@spatialys.com><mailto:even.roua...@spatialys.com> Sent: Monday, July 22, 2024 2:29 PM To: Joaquim Manuel Freire Luís <jl...@ualg.pt><mailto:jl...@ualg.pt>; gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Subject: Re: [gdal-dev] Extracting data from a parquet file Joaquim, The GeoPackage format only supports one geometry field per layer. and the QGIS OGR provider doesn't know currently how to handle several geometry fields per layer too To do what you want, you need to explictly select the desired geometry field name with: ogr2ogr out.gpkg world-administrative-boundaries.parquet -sql "select geo_shape, * from \"world-administrative-boundaries\"" Actually if you outputted to a format that supports several geometry fields per layer (let's say PostGIS), the above wouldn't work. You would need to exclude the geometry fields from the wildcard * selection with: ogr2ogr out.gpkg world-administrative-boundaries.parquet -sql "select geo_shape, * exclude (geo_point_2D, geo_shape) from \"world-administrative-boundaries\"" Even Le 19/07/2024 à 16:58, Joaquim Manuel Freire Luís via gdal-dev a écrit : Hi, I finally managed to build a working GDAL with the arrow/parquet driver and I’m now trying to convert this file (https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/world-administrative-boundaries/exports/parquet?lang=en&timezone=Europe%2FLondon) but can only extract the “Point”, not the “Multi polygon” ogrinfo world-administrative-boundaries.parquet INFO: Open of `world-administrative-boundaries.parquet' using driver `Parquet' successful. 1: world-administrative-boundaries (Point, Multi Polygon) This gets only the points ogr2ogr lixo.gpkg world-administrative-boundaries.parquet The same happens if I open the file in QGis. Points only, no polygons. But if I do an ogrinfo -al, it prints all data in file. ogrinfo -al world-administrative-boundaries.parquet …. OGRFeature(world-administrative-boundaries):255 iso3 (String) = GIB status (String) = UK Non-Self-Governing Territory color_code (String) = GBR name (String) = Gibraltar … So, how can we select in ogr2ogr to extract the polygons? _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/gdal-dev -- http://www.spatialys.com My software is free, but my time generally not. -- http://www.spatialys.com My software is free, but my time generally not.
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev
