Re: [gdal-dev] "Regular" SQLite DB Format

2024-10-25 Thread Patrick Young via gdal-dev
Ah thanks, yeah I see now with a '-dsco METADATA=NO' option ogrinfo doesn't recognize the output geometry column as geometry. On Fri, Oct 25, 2024 at 3:46 PM Even Rouault wrote: > > Le 25/10/2024 à 23:40, Patrick Young via gdal-dev a écrit : > > Hello, > > > > I noticed in the docs > > > https:/

Re: [gdal-dev] "Regular" SQLite DB Format

2024-10-25 Thread Even Rouault via gdal-dev
Le 25/10/2024 à 23:40, Patrick Young via gdal-dev a écrit : Hello, I noticed in the docs https://gdal.org/en/latest/drivers/vector/sqlite.html#regular-sqlite-databases that there is some support for treating a plain sqlite db as a vector format. I've been dumping some vector data into a ta

[gdal-dev] "Regular" SQLite DB Format

2024-10-25 Thread Patrick Young via gdal-dev
Hello, I noticed in the docs https://gdal.org/en/latest/drivers/vector/sqlite.html#regular-sqlite-databases that there is some support for treating a plain sqlite db as a vector format. I've been dumping some vector data into a table with a geometry column full of WKB plus some properties, but I

Re: [gdal-dev] ogr2ogr for downloading extracts from overturemaps

2024-10-25 Thread Rahkonen Jukka via gdal-dev
Hi, Your command took 110 seconds to run from Finland with "GDAL 3.10.0dev-b6edb5191e, released 2024/10/07". There are 827 features in the "type=water" table. -Jukka Rahkonen- Lähettäjä: gdal-dev Puolesta Even Rouault via gdal-dev Lähetetty: torstai 24. lokakuuta 2024 23.39 Vastaanottaja: Va

Re: [gdal-dev] How to use JPEGXL in TIFF right?

2024-10-25 Thread Rahkonen Jukka via gdal-dev
Thanks Thomas, I will suggest an edit to the GeoTIFF driver page for adding that information. If single row blocks are needed for some reason, it seems to be better to use the JPEGXL driver directly. It is fast and creates small output. gdal_translate -of jpegxl -co lossless=yes p4433h.tif p4433

Re: [gdal-dev] How to use JPEGXL in TIFF right?

2024-10-25 Thread thomas bonfort via gdal-dev
Hi Jukka, Yes, you should definitely be using tiled tiff with jxl. The actual tile size (256,512 or 1024) did not seem to make much difference in file size from what I have experienced, so you can choose that value depending on how you plan to use the tifs later on. In production use here, we use "

Re: [gdal-dev] ogr2ogr for downloading extracts from overturemaps

2024-10-25 Thread Varun Sharma via gdal-dev
Thanks Even for your suggestion and Jukka for timings from Finland. 1. I tried Even's suggestion: gdal-master channel on conda : https://gdal.org/en/latest/download.html#gdal-master-conda-builds : Result: *works very well :)* Timing: AWS_NO_SIGN_REQUEST=true CPL_VERBOSE=ON CPL_DEBUG=ON ogr2ogr -