Ingo,<br><br>Use the -select option with an empty string in ogr2ogr [1].<br>ogr2ogr -select "" dest.shp src.shp<br><br>[1]: <a href="http://www.gdal.org/ogr2ogr.html">http://www.gdal.org/ogr2ogr.html</a><br><br><div class="gmail_quote">
On Thu, Aug 18, 2011 at 3:53 PM, Ingo Weinzierl <span dir="ltr"><<a href="mailto:ingo.weinzierl@intevation.de">ingo.weinzierl@intevation.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello GDAL community,<br>
<br>
I have already used GDAL to get information about shapefiles or to<br>
insert a shapefile into a database. So, many thanks to all of you!<br>
<br>
Now, I've just tried to dump a shapefile into an existing table of a<br>
spatial database (PostGIS / Oracle) using ogr2ogr. Therefore, I need<br>
some help:<br>
<br>
The only thing of the shapefile I need is the geometry column, but<br>
the database schema requires a further Integer column (NOT NULL<br>
constraint). In my use-case, I would like to define this Integer<br>
value manually while calling ogr2ogr. Therefore, I've already<br>
searched for some VRT examples, with no success.<br>
<br>
In simple words: I want to insert the geometry column (shapefile)<br>
and an Integer value (manually defined) into a pre-defined spatial<br>
database (PostGIS / Oracle).<br>
<br>
I would be glad if someone could give me some hints how to realize<br>
such a ogr2ogr call.<br>
<br>
Regards, Ingo<br>
<font color="#888888">--<br>
Ingo Weinzierl | <a href="tel:%2B%2B49-541-335083-0" value="+495413350830">++49-541-335083-0</a> | OpenPGP key: 0x2D2E2573<br>
Intevation GmbH, Neuer Graben 17, 49074 Osnabrück | AG Osnabrück, HR B 18998<br>
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br><br>+91-9494447584<br>17.2416N 80.1426E<br>