[gdal-dev] ogr2ogr project/transform CRS in the same database table

[jratike80]

Hi,

No, unfortunately it is not possible with one ogr2ogr command.

You need two commands and you must use ogrinfo. Here an example about adding
another geometry column and populating it with EPSG:3857 version of original
EPSG:4326 geometries.

ogrinfo PG:"host=localhost port=5432 dbname=test user=user
password=password" -sql "alter table states add column geom2 geometry"

ogrinfo PG:"host=localhost port=5432 dbname=test user=user
password=password" -sql "update states set
geom2=ST_Transform(wkb_geometry,3857)"

You can do all that is possible with SQL also with ogrinfo.


-Jukka Rahkonen-



hectormauer wrote
> Hi all,
> 
> I was wondering if someone knew if it's possible to project or transform
> within the same table in a database, using ogr2ogr.
> 
> What I mean is, I have a table with fields: id, id2, geom_wkt_27700 and I
> would like, using a single command to create an extra column
> "geom_wkt_4326" for instance. It does not have to be of type geometry, but
> could be text for instance.
> 
> I guess the other plausible solution would be to create a temporary table
> with that transformation on it and reference it to the first one by id for
> instance.
> 
> Any help is appreciated!
> 
> Thanks,
> Hector
> 
> _______________________________________________
> gdal-dev mailing list

> gdal-dev at .osgeo

> https://lists.osgeo.org/mailman/listinfo/gdal-dev





--
Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html