[gdal-dev] Dump Shapefile into DB using ogr2ogr

Chaitanya kumar CH chaitanya.ch at gmail.com
Thu Aug 18 07:30:58 EDT 2011


Ingo,

Use the -select option with an empty string in ogr2ogr [1].
ogr2ogr -select "" dest.shp src.shp

[1]: http://www.gdal.org/ogr2ogr.html

On Thu, Aug 18, 2011 at 3:53 PM, Ingo Weinzierl <
ingo.weinzierl at intevation.de> wrote:

> 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
> some help:
>
> 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.
>
> 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
Best regards,
Chaitanya kumar CH.

+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20110818/2640ed8c/attachment.html


More information about the gdal-dev mailing list