[gdal-dev] Dump Shapefile into DB using ogr2ogr
ingo.weinzierl at intevation.de
Thu Aug 18 06:23:06 EDT 2011
Hello GDAL community,
I have already used GDAL to get information about shapefiles or to
insert a shapefile into a database. So, many thanks to all of you!
Now, I've just tried to dump a shapefile into an existing table of a
spatial database (PostGIS / Oracle) using ogr2ogr. Therefore, I need
The only thing of the shapefile I need is the geometry column, but
the database schema requires a further Integer column (NOT NULL
constraint). In my use-case, I would like to define this Integer
value manually while calling ogr2ogr. Therefore, I've already
searched for some VRT examples, with no success.
In simple words: I want to insert the geometry column (shapefile)
and an Integer value (manually defined) into a pre-defined spatial
database (PostGIS / Oracle).
I would be glad if someone could give me some hints how to realize
such a ogr2ogr call.
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
More information about the gdal-dev