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

2011-08-22 Thread Hermann Peifer
On 22/08/2011 14:08, Ingo Weinzierl wrote: It says "GDAL 1.6.3, released 2009/11/19". This version comes along with Debian Squeeze. You have to upgrade to GDAL/OGR >= 1.8.0 in order to make use of the new OGR SQL functionality, http://www.gdal.org/ogr/ogr_sql.html Hermann

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

2011-08-22 Thread Ingo Weinzierl
Hi Hermann, On Mon, Aug 22, 2011 at 01:30:00PM +0200, Hermann Peifer wrote: > On 22/08/2011 13:13, Ingo Weinzierl wrote: > >Hi *, > > > >I already tried the approach below - without success. The result of > >my operation is: > > > >The command: > > > > ogr2ogr -f "ESRI Shapefile" -

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

2011-08-22 Thread Hermann Peifer
On 22/08/2011 13:13, Ingo Weinzierl wrote: 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

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

2011-08-22 Thread 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: - ER

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

2011-08-19 Thread Chaitanya kumar CH
That should work just fine. On Fri, Aug 19, 2011 at 9:23 PM, Hermann Peifer 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 ex

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

2011-08-19 Thread Hermann Peifer
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