[gdal-dev] Re: Dump Shapefile into DB using ogr2ogr

[Ingo Weinzierl]

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 <peifer at 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