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

Oh that's a great idea. I have to use SQL Server (not by personal choice) and had given it a go with sqlite as dialect, bur was probably too focused on ogr2ogr. I also didn't know about the "indirect_SQLite" dialect. I will give a try at what you suggest. Thanks for the help :) Hector On Tue,

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

I would say that it is best to still use ogrinfo. You did not tell what is your database so I can't tell the exact recipe for you but you will learn it. You need to know that there are different SQL dialects for GDAL: OGR SQL, SQLite, indirect_SQLite, and the native SQL for your database. They are

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

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 wrote: > Hi, > > No, unfortunately

Re: [gdal-dev] Converting OBJ to Geojson files with ogr2ogr

On Tue, 1 Dec 2020, Brandon Biggs wrote: Hello, I am wondering how to convert an obj file to a geojson file? I am using ogr2ogr with the command: Ogr2ogr -f geojson output.geojson input.obj But get the error that ogr2ogr does not have an OBJ driver. I looked on: the vector drivers page

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

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

[gdal-dev] Converting OBJ to Geojson files with ogr2ogr

Hello, I am wondering how to convert an obj file to a geojson file? I am using ogr2ogr with the command: Ogr2ogr -f geojson output.geojson input.obj But get the error that ogr2ogr does not have an OBJ driver. I looked on: the vector drivers page but am u

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

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.

Re: [gdal-dev] Fwd: Grep gdalinfo subdataset

On Tue, Dec 1, 2020 at 3:08 PM 1520 gis wrote: > From: 1520 gis > Date: Fri, Nov 27, 2020 at 3:14 PM > Subject: Grep gdalinfo subdataset > To: > > > Hi all, > > I am trying to grep the SUBDATASET_X_NAME in gdalinfo. > I only need the WCS:url > > If I grep the subdataset [1], the string slice "SU

Re: [gdal-dev] New STACTA driver and gdal2tiles

On mardi 1 décembre 2020 07:44:06 CET Rahkonen Jukka (MML) wrote: > Hi, > > I noticed that a new STACTA driver appeared with > https://github.com/OSGeo/gdal/pull/3227. Probably gdal2tiles could be made > to create a catalog json file like > https://github.com/OSGeo/gdal/pull/3227/files#diff-f1b9f2

[gdal-dev] Fwd: Grep gdalinfo subdataset

-- Forwarded message - From: 1520 gis Date: Fri, Nov 27, 2020 at 3:14 PM Subject: Grep gdalinfo subdataset To: Hi all, I am trying to grep the SUBDATASET_X_NAME in gdalinfo. I only need the WCS:url If I grep the subdataset [1], the string slice "SUBDATASET_5_NAME" comes togeth

[gdal-dev] gdal_create: input file option

Hi, Every now and then people would like to rasterize vectors into raster that matches exactly with some existing raster. There are a few possible ways for creating an empty copy from a raster with GDAL tools https://gis.stackexchange.com/questions/220753/how-do-i-create-blank-geotiff-with-same