[gdal-dev] -sql switch in gdal_rasterize

[Even Rouault]

Implemented in https://github.com/OSGeo/gdal/pull/7235

Le 12/02/2023 à 17:16, Scott a écrit :
> The hope was to have the gdal_rasterize -sql switch work like it does 
> in the other gdal utilities, ie, -sql @/path/to/source.sql. That 
> consistency would be really nice.
>
> All my .sql files live in a single directory and things are structured 
> around the @ syntax. Further, these .sql quieries can be used 
> independently of gdal.
>
> Having an optfile bloated with sql is a hack, not really a solution.
>
>
> On 2/12/23 03:34, Rahkonen Jukka wrote:
>> Hi,
>>
>> Optfile will work if you use it right. Optfile is flexible and it can 
>> be used for anything, not only for saving a SQL query into a file. 
>> Therefore optfile must have the same literal content that user would 
>> write by hand to the command. With optfile
>>
>> optfile.txt
>> ========
>> -sql "select * from rakennus"
>>
>> this command works fine for me
>>
>> gdal_rasterize --optfile optfile.txt helsinki_city_region.gpkg 
>> test.tif -burn 10 -tr 10 10
>>
>> -Jukka Rahkonen-
>>
>>
>>
>> -----Alkuperäinen viesti-----
>> Lähettäjä: gdal-dev <gdal-dev-bounces at lists.osgeo.org> Puolesta Scott
>> Lähetetty: lauantai 11. helmikuuta 2023 23.15
>> Vastaanottaja: gdal-dev at lists.osgeo.org
>> Aihe: [gdal-dev] -sql switch in gdal_rasterize
>>
>> Other gdal utilities that use the -sql switch allow you to specify a 
>> path to an sql file preceded with the @ symbol, such as:
>>
>> -sql @/path/to/source.sql
>>
>> Is there a way to do this with gdal_rasterize? Adding the above to an 
>> --optfile returns the same error as doing it on the command line.
>>
>> TIA
>>
>> -- 
>> https://eur06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.postholer.com%2F&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C914b668d0a674f638f6f08db0c7cddb2%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C1%7C638117502675505065%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dRgnBYMNwxd109bxxKlNEoda9BcBz6p8r1%2FSkgB8zSw%3D&reserved=0 
>>
>> _______________________________________________
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
>> https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fgdal-dev&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C914b668d0a674f638f6f08db0c7cddb2%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C1%7C638117502675505065%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=iwBy%2F9rMMB67K969yfqpz9YowN7mfxIm21I4VMjOkUQ%3D&reserved=0 
>>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.