Hi *, I already tried the approach below - without success. The result of my operation is:
The command: ------------ ogr2ogr -f "ESRI Shapefile" -sql "SELECT cast(999 as integer(3)) as river_id from SRCShape" DESTShape.shp SRCShape.shp The command's result: --------------------- ERROR 1: SQL: Unrecognised field name 999 On Fri, Aug 19, 2011 at 09:29:23PM +0530, Chaitanya kumar CH wrote: > That should work just fine. > > On Fri, Aug 19, 2011 at 9:23 PM, Hermann Peifer <pei...@gmx.eu> wrote: > > > On 19/08/2011 15:05, Ingo Weinzierl wrote: > > > >> Thanks for the quick reply, but the "-select" option only solves one > >> of the two parts of my problem. I still need to append a further > >> column that does not exist in the shapefile and which should be > >> defined manually. > >> > > > > I am not sure if I fully understood the issue, but... what about: > > > > ... -sql "select cast(999 as integer(3)) as field from ..." > > > > (If you want an additional integer column with name `field', where all > > values are defined to be 999) > > > > Hermann Regards, Ingo -- Ingo Weinzierl | ++49-541-335083-0 | OpenPGP key: 0x2D2E2573 Intevation GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev