Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread nagyrobi_r--- via gdal-dev
Thanks for the tips Laurențiu.  O zi faină, Robert Nagy  Sent from Yahoo Mail on Android On Wed, Jan 17, 2024 at 3:34 PM, Laurențiu Nicola wrote: A pipe might prevent you from creating a spatial index, right? I didn't test it, but another method would be to use a join (you can query mult

Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread Laurențiu Nicola via gdal-dev
A pipe might prevent you from creating a spatial index, right? I didn't test it, but another method would be to use a join (you can query multiple data sources in the same ogr2ogr invocation, https://gdal.org/user/ogr_sql_dialect.html#joins), but they are pretty limited and you might lose the s

Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread nagyrobi_r--- via gdal-dev
Technically in want to save time by not saving to disk. That is one of the main reasons that i want to save in memory. I tried chaning them using pipes but didnt work.  Cu respect, Robert Nagy Sent from Yahoo Mail on Android On Wed, Jan 17, 2024 at 1:35 PM, Laurențiu Nicola wrote: Hei :-

Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread Laurențiu Nicola via gdal-dev
Hei :-), Nope, I think those are the only options: • save the output into a (real) file • keep using vsimem, but chain the operations while the app is still running Do you have any particular reason to use vsimem? Laurentiu On Wed, Jan 17, 2024, at 14:00, nagyrob...@yahoo.com wrote: > Hei Laur

Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread nagyrobi_r--- via gdal-dev
Hei Laurențiu! Thank you for yor email! Is there a way to pipe these operations or do anything fancy to be able to sit outside of a programming environment?  Cu respect,Robert Nagy Sent from Yahoo Mail on Android On Wed, Jan 17, 2024 at 11:59 AM, Laurențiu Nicola via gdal-dev wrote:

Re: [gdal-dev] Using VSIMEM properly

2024-01-17 Thread Laurențiu Nicola via gdal-dev
Hi Robert, The contents of /vsimem/ is only stored in memory and goes away when your application quits. You should use a real file instead, or something like a Python script that calls gdal.VectorTranslate. Laurentiu On Wed, Jan 17, 2024, at 12:52, nagyrobi_r--- via gdal-dev wrote: > > Hi all

[gdal-dev] Using VSIMEM properly

2024-01-17 Thread nagyrobi_r--- via gdal-dev
Hi all! Maybe i am not using this tool properly. I am want to read the contents of a WFS service into an in memory sqlite database. Then i want to add a second table to it name it filter from a geojson, do an SQL query on the two tables, and write the result into a Postgresql database, this o