[gdal-dev] GDAL 3.11 vector utility

[Richard Greenwood]

I'm playing with the (very cool) new gdal command line tool. I started with
a simple task of copying a shapefile into postgres. I only want two columns
from the shapefile and I need to cast it to a MultiLineString. My old
ogr2ogr command:
*ogr2ogr PG:"$PGCONN" shapefiles -sql "select STREET_NAM, TYPE from Roads"
-nlt MultiLineString -append*

It seems like there's some overlap between vector convert, sql and geom and
I've gotten furthest with sql:
*gdal vector sql --sql "select STREET_NAM, TYPE from Roads" --append
shapefiles PG:"$PGCONN"*
But I haven't figured out how to cast to --multi.

Should I be using convert or geom instead of sql? Or do I need a pipeline?
Is there documentation that I'm missing?

Thanks,
Rich





-- 
Richard W. Greenwood
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20250425/fde8cab8/attachment.htm>