Oh, I see. That's great. But what if the Database does not have ST_Transform support? Could we still achieve a similar approach by means of ogr2ogr?
(I should have mentioned this in my first email). Thanks again! Hector On Tue, 1 Dec 2020 at 20:14, jratike80 <[email protected]> wrote: > 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 > > > [email protected] > > > https://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > > > -- > Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html > _______________________________________________ > gdal-dev mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/gdal-dev >
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
