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
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Reply via email to