Re: [gdal-dev] Using field name as variable in a "dialect sqlite" query

2017-11-23 Thread aborruso
Hi Jukka, jratike80 wrote > You can have only one SRID on a layer so you must either split your data > by > the epsg field or transform each record to same SRID. Otherwise your > request > was almost complete. I know, but my problem was the source! jratike80 wrote > ogrinfo -dialect sqlite -sq

Re: [gdal-dev] Using field name as variable in a "dialect sqlite" query

2017-11-22 Thread jratike80
aborruso wrote > Hi, > I have this kind of CSV > > ID,x,y,epsg > 1,50,400,32633 > 1,50,400,32632 > > Is it possible to use ogrinfo and a "dialect sqlite" query in this way, > and > set the EPSG by reading the value from the `epsg` field? > > ogrinfo -dialect sqlite -sql "select S

[gdal-dev] Using field name as variable in a "dialect sqlite" query

2017-11-22 Thread aborruso
Hi, I have this kind of CSV ID,x,y,epsg 1,50,400,32633 1,50,400,32632 Is it possible to use ogrinfo and a "dialect sqlite" query in this way, and set the EPSG by reading the value from the `epsg` field? ogrinfo -dialect sqlite -sql "select ST_GeomFromText('POINT(' || x || ' ' ||