[gdal-dev] Problems with ArcGIS image server and WMS minidriver

2021-02-05 Thread Rahkonen Jukka (MML)
Hi, I almost managed to read data from this URL but not quite https://image.discomap.eea.europa.eu/arcgis/rest/services/GioLand/HRIM_HR_TrueColour_2018/ImageServer/exportImage?f=image=-3493783.68885884%2C3191895.64564654%2C5001886.25692533%2C11496874.31511627=512%2C512=3857=3857=png8==false= The

Re: [gdal-dev] Fwd: ogr2ogr crash attempting to drop table in filegdb

2021-02-05 Thread Rahkonen Jukka (MML)
. -Jukka Rahkonen- Lähettäjä: Jan Heckman Lähetetty: perjantai 5. helmikuuta 2021 16.10 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal Aihe: Re: [gdal-dev] Fwd: ogr2ogr crash attempting to drop table in filegdb However, ogrinfo does no better. It refuses to rename a table (filegdb) and crashes

[gdal-dev] Driver maintenance - long-term solution ?

2021-01-13 Thread Rahkonen Jukka (MML)
Hi, The thread "Considering drivers removal ?" made me think about what is the real issue. Is there something fundamentally wrong with the current GDAL? If having >100 and >100 drivers prevent developers from doing modernization in GDAL internals I do not believe that having 90 and 90 really

[gdal-dev] Gdalwarp fails with Stereographic_North_Pole

2021-01-11 Thread Rahkonen Jukka (MML)
Hi, Have a look at this question https://gis.stackexchange.com/questions/383825/difference-between-qgis-export-and-gdalwarp? The original poster managed to get good output with gdalwarp by warping first into EPSG:9040 and then into EPSG:4326 but that feels like a workaround and not a

Re: [gdal-dev] [EXTERNAL] Re: How to read multi-band xyz files?

2021-01-07 Thread Rahkonen Jukka (MML)
need. -Jukka Rahkonen- Lähettäjä: Hare, Trent M Lähetetty: keskiviikko 6. tammikuuta 2021 17.52 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: [EXTERNAL] Re: [gdal-dev] How to read multi-band xyz files? Jukka, I'm not sure I understand exactly what you want but I have this old script which might

[gdal-dev] How to read multi-band xyz files?

2021-01-05 Thread Rahkonen Jukka (MML)
Hi, It is possible to create multi-band xyz files with the gdal2xyz.py script. The usage and result is like this: gdal2xyz -band 1 -band 2 -band 3 test.tif test.xyz more test.xyz 0.500 0.500 255 255 255 1.500 0.500 255 255 255 2.500 0.500 255 255 255 3.500 0.500 255 255 255 . . . However, in

[gdal-dev] Issue with gdalcompare.py and Proj 8

2020-12-18 Thread Rahkonen Jukka (MML)
Hi, The proj.db in Proj version 8 (installed with OSGeo4W) is a bit different than it used to be and therefore gdalcompare.py fails with this error: ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, coordinate_system_auth_name, coordinate_system_code,

Re: [gdal-dev] gdal_translate -scale

2020-12-14 Thread Rahkonen Jukka (MML)
Hi, Please remember to use reply-to-all for sending a copy to the list as well. -Jukka- -Alkuperäinen viesti- Lähettäjä: jesus.mo...@solute.es Lähetetty: maanantai 14. joulukuuta 2020 14.27 Vastaanottaja: Rahkonen Jukka (MML) Aihe: RE: [gdal-dev] gdal_translate -scale Hi, Thank you

Re: [gdal-dev] How to kill gdal2tiles?

2020-12-14 Thread Rahkonen Jukka (MML)
kills a single process friendly. -Jukka Rahkonen- Lähettäjä: Sean Gillies Lähetetty: maanantai 14. joulukuuta 2020 1.14 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] How to kill gdal2tiles? Hi Jukka, Didn't gdal2tiles get a multiprocessing implementation recently? If that's the case

[gdal-dev] How to kill gdal2tiles?

2020-12-13 Thread Rahkonen Jukka (MML)
Hi, Is there some clean way to kill gdal2tiles script? Ctrl-C at least does not work but leaves the script to some odd state. -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/gdal-dev

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

2020-12-02 Thread Rahkonen Jukka (MML)
How did you install it? -Jukka Lähettäjä: Hector muro Lähetetty: keskiviikko 2. joulukuuta 2020 13.46 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogr2ogr project/transform CRS in the same database table Hi again, Okey, I think I got it. And you were r

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

2020-12-02 Thread Rahkonen Jukka (MML)
: keskiviikko 2. joulukuuta 2020 13.02 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogr2ogr project/transform CRS in the same database table Hi, Sorry, no, I meant that, using the flag dialect returns an error of "Table not found", but using the

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

2020-12-02 Thread Rahkonen Jukka (MML)
mit 1" "$connect_string" Try also with “-dialect ogrsql” even that dialect does not have those ST_ functions that you need. -Jukka- Lähettäjä: Hector muro Lähetetty: keskiviikko 2. joulukuuta 2020 12.37 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org

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

2020-12-02 Thread Rahkonen Jukka (MML)
unquoted table name is to run ogrinfo with -sql "select * from table_name limit 1". -Jukka- Lähettäjä: Hector muro Lähetetty: keskiviikko 2. joulukuuta 2020 12.13 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogr2ogr project/transform

[gdal-dev] gdal_create: input file option

2020-12-01 Thread Rahkonen Jukka (MML)
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

[gdal-dev] New STACTA driver and gdal2tiles

2020-11-30 Thread Rahkonen Jukka (MML)
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-f1b9f20b0e955285ddcebb0153367a254d3d0126a784e52b9ae36dba0eab023c and then the

Re: [gdal-dev] gdal-dev Digest, Vol 198, Issue 45

2020-11-23 Thread Rahkonen Jukka (MML)
ttaja: gdal-dev@lists.osgeo.org; Rahkonen Jukka (MML) Aihe: Re: gdal-dev Digest, Vol 198, Issue 45 Dear Rahkonen Jukka, I will consider your warnings about using GDAL_WCS with GeoServer. It seems that what I am trying to do is not possible, but it will be something interesting to achieve through GD

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-14 Thread Rahkonen Jukka (MML)
to get your original error by playing with upper/lower case in various places of the command. -Jukka- Lähettäjä: Kreß, Marius Lähetetty: perjantai 13. marraskuuta 2020 19.58 Vastaanottaja: Rahkonen Jukka (MML) Kopio: 'gdal-dev@lists.osgeo.org' Aihe: AW: [gdal-dev] Oracle Spatial Driver

Re: [gdal-dev] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-12 Thread Rahkonen Jukka (MML)
e, d.sdo_lb, sdo_ub, sdo_tolerance, rownum r FROM ALL_SDO_GEOM_METADATA m, table(m.diminfo) d where m.table_name = UPPER('TIME_TEST') and m.COLUMN_NAME = UPPER('ORA_GEOMETRY') ) ) -Jukka Rahkonen- -Alkuperäinen viesti----- Lähettäjä: Kreß, Marius Lähetetty: torstai 12. marraskuuta 2020 18.40 Vasta

Re: [gdal-dev] Location change on gdalwarp reprojection

2020-11-12 Thread Rahkonen Jukka (MML)
12. marraskuuta 2020 10.00 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Location change on gdalwarp reprojection Hi Thanks for your response Jukka! Your first explanation about the bounds make sense, but shouldn’t they still be in the same area (overlapping)? When specifying the so

Re: [gdal-dev] gdal-dev Digest, Vol 198, Issue 14

2020-11-11 Thread Rahkonen Jukka (MML)
- Lähettäjä: 1520 gis Lähetetty: keskiviikko 11. marraskuuta 2020 16.55 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: gdal-dev Digest, Vol 198, Issue 14 Dear Jukka Rahkonen, Thank you very much for your patience, time, and detailed information given to my questions. I appreciated it all. In your

Re: [gdal-dev] Selecting just the geometry column with OGR SQL

2020-11-09 Thread Rahkonen Jukka (MML)
Even Rouault wrote: maanantai 9. marraskuuta 2020 17.10 > Jukka, >> I believe that OGR SQL dialect adds the geometry column into SQL >> selection by default. Am I right with this? I volunteer to edit the >> documentation https://gdal.org/user/ogr_sql_dialect.html if this is >> the case. But

[gdal-dev] Selecting just the geometry column with OGR SQL

2020-11-09 Thread Rahkonen Jukka (MML)
Hi, I believe that OGR SQL dialect adds the geometry column into SQL selection by default. Am I right with this? I volunteer to edit the documentation https://gdal.org/user/ogr_sql_dialect.html if this is the case. But what I can't understand is another side of the story, how to select just

[gdal-dev] What is the purpose of -nosrcalpha in gdalwarp?

2020-11-08 Thread Rahkonen Jukka (MML)
Hi, I noticed this question from gis.stackexchange https://gis.stackexchange.com/questions/378557/gdalwarp-does-not-use-lanczos-resampling-on-image-with-alpha-channel/378569?noredirect=1#comment618912_378569 It seems that alpha band has some bad effect on the result of lanczos resampling and

[gdal-dev] How to override WGS84 obligation with IETF GeoJSON?

2020-10-21 Thread Rahkonen Jukka (MML)
Hi, We want to use GeoJSON with national coordinate systems like EPSG:3067, EPSG:3046 etc. We can write such GeoJSON with GDAL by using the default GeoJSON 2008 mode. However, in the RFC 7946 specification the rules about the winding order of polygons were clarified and some GeoJSON parsers

[gdal-dev] Wrong sliding when AREA_OR_POINT metadata is edited?

2020-08-26 Thread Rahkonen Jukka (MML)
Hi, See this and find test data and example commands https://github.com/opengeospatial/OGC-API-Sprint-August-2020/issues/18. If PixelIsPoint image has these GeoTIFF tags Geotiff_Information: Version: 1 Key_Revision: 1.0 Tagged_Information: ModelTiepointTag (8,3): 0

Re: [gdal-dev] I have a problem getting higher resolution in a VRT file

2020-08-20 Thread Rahkonen Jukka (MML)
://gis.stackexchange.com/questions/30627/smoothing-reinterpolating-raster-with-gdal. -Jukka- -Alkuperäinen viesti- Lähettäjä: Stephen Woodbridge Lähetetty: torstai 20. elokuuta 2020 16.58 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] I have a problem getting higher resolution

[gdal-dev] SQLite attach database as open option

2020-08-19 Thread Rahkonen Jukka (MML)
Hi, I wonder if it a) might work and b) could have some practical use to implement an open option for attaching other SQLite databases to SQLite based datasources https://www.sqlite.org/lang_attach.html. The usage could be something like -oo ATTACH=path/to/other.gpkg:alias, where "alias" part

Re: [gdal-dev] Rotation not found from ENVI header

2020-08-17 Thread Rahkonen Jukka (MML)
2020 23.53 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Rotation not found from ENVI header On lundi 17 août 2020 20:44:35 CEST Rahkonen Jukka (MML) wrote: > Hi, > > In the question at gis.stackexchange the rotation was 90 bu

Re: [gdal-dev] Rotation not found from ENVI header

2020-08-17 Thread Rahkonen Jukka (MML)
Hi, In the question at gis.stackexchange the rotation was 90 but I trust that the issue is the same. -Jukka- Lähettäjä: Even Rouault Lähetetty: maanantai 17. elokuuta 2020 14.36 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Rotation not found from

[gdal-dev] Rotation not found from ENVI header

2020-08-17 Thread Rahkonen Jukka (MML)
Hi, See https://gis.stackexchange.com/questions/371579/geotiff-to-envi-gdal-translation-causes-rotation I verified that GDAL 3.2.0dev gives an error for the test image "Warning 1: Geotransform matrix has non rotational terms". However, the ENVI header has a line map info = {Transverse

[gdal-dev] Making MITAB to recognize Extented MapInfo TAB

2020-08-03 Thread Rahkonen Jukka (MML)
Hi, Might be good if the MITAB driver could recognize if TAB file is of the new Extented TAB format and show a meaningful error for the users. It could save troubles similar to this one in gis.stackexchange

Re: [gdal-dev] MSSQLSpatial not using BCP to load

2020-06-29 Thread Rahkonen Jukka (MML)
: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] MSSQLSpatial not using BCP to load Hi, Thanks for that. I removed the argument but the process still loads one-by-one and does not seem to use BCP... Regards Hector On Mon, 29 Jun 2020 at 15:10, jratike80 mailto:jukka.rahko...@maanmittauslaitos.fi

Re: [gdal-dev] Finnish KKJ and MapInfo MIF with GDAL 3.1

2020-05-18 Thread Rahkonen Jukka (MML)
quot;false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH]]' It is in the test and I don't know if it can make trouble for users. -Jukka- Lähettäjä: Even Rouault Lähetetty: maanantai 18.

[gdal-dev] Finnish KKJ and MapInfo MIF with GDAL 3.1

2020-05-18 Thread Rahkonen Jukka (MML)
Hi, This command ogr2ogr -f "MapInfo file" -s_srs epsg:3067 -t_srs epsg:2393 2393.mif tm35.jml writes into MIF CoordSys Earth Projection 8, 104, "m", 27, 0, 1, 350, 0 ogrinfo shows ogrinfo 2393.mif -al -so INFO: Open of `2393.mif' using driver `MapInfo File' successful. Layer name:

Re: [gdal-dev] OAPIF and apikey

2020-05-13 Thread Rahkonen Jukka (MML)
Even Rouault wrote: > On mardi 12 mai 2020 21:21:30 CEST Rahkonen Jukka (MML) wrote: >> Hi, >> >> I wonder how I could deal with an OGC API Features service that requires to >> use apikey as an extra parameter in each request. First step is easy >> because I

[gdal-dev] OAPIF and apikey

2020-05-12 Thread Rahkonen Jukka (MML)
Hi, I wonder how I could deal with an OGC API Features service that requires to use apikey as an extra parameter in each request. First step is easy because I can just add the apikey parameter to the URL of the landing page (?api-key=xxxyyyzzzkkk) but the link to collections in the document

[gdal-dev] gdal_viewshed

2020-05-08 Thread Rahkonen Jukka (MML)
Hi Pedro, You wrote that you used this command in your test gdal_viewshed -b 1 -md 28000.0 -ox -41597.922 -oy 71254.049 -oz 21.6 -tz 10.0 -vv 1 -cc 0.85714 -f GTiff path_to_mdt.tif path_to_output.tif Could you also give a link to "path_to_mdt.tif" or repeat the test with some other DEM that

Re: [gdal-dev] How to get a file list from a Sentinel zip?

2020-04-08 Thread Rahkonen Jukka (MML)
-use-gdal-vsizip-to-access-gml-files-from-sentinel-2-zip-package/357589. -Jukka- >I hope it helps, >Ivan ____ From: gdal-dev <mailto:gdal-dev-boun...@lists.osgeo.org> on behalf of Rahkonen Jukka (MML) <mailto:jukka.rahko...@maanmittauslaitos.fi>

[gdal-dev] How to get a file list from a Sentinel zip?

2020-04-08 Thread Rahkonen Jukka (MML)
Hi, I am investigating this dataset https://scihub.copernicus.eu/dhus/odata/v1/Products('456d05ea-835f-4e6c-b957-751c155252a1')/%24value download with test/test (890 MB) There seems to be some automagic logic that recognizes that the zip is a Sentinel zip gdalinfo

[gdal-dev] GPKG validation error from Teamengine

2020-03-31 Thread Rahkonen Jukka (MML)
Hi, I have tested some GDAL made GeoPackages with Teamengine and it finds some errors where validate_gpkg.py does not. I am using the ets-gpkg12 test and its source code is at

[gdal-dev] How far can we resolve complex GeoJSON?

2020-02-13 Thread Rahkonen Jukka (MML)
Hi, Have a look at data returned by request https://beta-paikkatieto.maanmittauslaitos.fi/geographic-names/wfs3/v1/collections/placenames/items?municipality=837=100 There exists couple of features with "parallelName" and GDAL converts that part into a string type attribute parallelName

Re: [gdal-dev] ogr2ogr ignoring tracks, only converting paths

2020-02-08 Thread Rahkonen Jukka (MML)
. If you have both KML and LIBKML in that order, you must skip the KML driver with config option --config GDAL_SKIP KML. -Jukka Rahkonen- Lähettäjä: Manuel H. Lähetetty: lauantai 8. helmikuuta 2020 14.50 Vastaanottaja: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] ogr2ogr ignoring tracks, only

Re: [gdal-dev] mosaicking is very slow

2020-01-27 Thread Rahkonen Jukka (MML)
rce images and compare the results. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: Simon Lähetetty: maanantai 27. tammikuuta 2020 15.21 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] mosaicking is very slow Hi, Okay, thank you. By the way, wh

Re: [gdal-dev] mosaicking is very slow

2020-01-27 Thread Rahkonen Jukka (MML)
to be optimal for you because of different source data and hardware. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: elmir Lähetetty: maanantai 27. tammikuuta 2020 15.12 Vastaanottaja: Rahkonen Jukka (MML) Kopio: Simon ; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] mosaicking is very slow

[gdal-dev] Why GTModelTypeGeoKey in EPSG:3857 GeoTIFF is User-Defined?

2020-01-27 Thread Rahkonen Jukka (MML)
Hi, See more details from this Geoserver issue https://osgeo-org.atlassian.net/browse/GEOS-9475. The core is that when GDAL writes a GeoTIFF in EPSG:3857 is sets this tag: GTModelTypeGeoKey (Short,1): User-Defined Geoserver is awaiting GTModelTypeGeoKey (Short,1): ModelTypeProjected Is there

Re: [gdal-dev] mosaicking is very slow

2020-01-27 Thread Rahkonen Jukka (MML)
not remove -co tiled=yes from the gdalwarp command or you'll demand GDAL to write at least 40 pixels wide stripes. -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: Simon Lähetetty: maanantai 27. tammikuuta 2020 13.18 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev

[gdal-dev] Why COG does not support predictor=3?

2020-01-10 Thread Rahkonen Jukka (MML)
Hi, The cloud optimized GeoTIFF generator has a creation option PREDICTOR=YES that is Boolean. Tiffinfo reveals that it means that predictor=2 is used "Predictor: horizontal differencing 2 (0x2)". However, for floating point images predictor=3 could give much better compression. In a quick

Re: [gdal-dev] Faster gdalinfo from COG

2020-01-08 Thread Rahkonen Jukka (MML)
the statistics with gdal_edit. -Jukka- -Alkuperäinen viesti- Lähettäjä: Even Rouault Lähetetty: keskiviikko 8. tammikuuta 2020 19.44 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Vincent Sarago ; Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] Faster gdalinfo from COG On mercredi 8 janvier 2020

[gdal-dev] Faster gdalinfo from COG

2020-01-08 Thread Rahkonen Jukka (MML)
Hi, Cloud optimized GeoTIFF is rather fast for almost anything else but not for checking what it is with gdalinfo. I wonder if we could have some "summary only" mode in gdalinfo that reads just what is known to be fast to read from the image metadata. What gdalinfo is actually doing when it

Re: [gdal-dev] How to change wrong PixelIsArea into correct PixelIsPoint?

2019-12-17 Thread Rahkonen Jukka (MML)
. -Jukka- -Alkuperäinen viesti- Lähettäjä: Even Rouault Lähetetty: tiistai 17. joulukuuta 2019 19.01 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] How to change wrong PixelIsArea into correct PixelIsPoint? Jukka, > I was thinking that I

[gdal-dev] How to change wrong PixelIsArea into correct PixelIsPoint?

2019-12-17 Thread Rahkonen Jukka (MML)
Hi, I have some images with wrong metadata. They are tagged as pixel-is-area images and listgeo shows the tag GTRasterTypeGeoKey (Short,1): RasterPixelIsArea Actually geotiffs are measurements and they should use RasterPixelIsPoint and images should be shifted be half a pixel on a map. I was

[gdal-dev] OAPIF endpoint and trailing slash

2019-12-16 Thread Rahkonen Jukka (MML)
Hi, GDAL OAPIF driver, according to the documentation https://gdal.org/drivers/vector/oapif.html, takes the service landing page as URL "Dataset name syntax The syntax to open a OGC API - Features datasource is : OAPIF:http://path/to/OAPIF/endpoint where endpoint is the landing page or a the

[gdal-dev] Why MultiLinestring in GeometryCollection is unexpected for SQLite dialect?

2019-12-11 Thread Rahkonen Jukka (MML)
Hi, This command fails with SQLite dialect ogrinfo -dialect sqlite -sql "select geometry from jump_gc as geom" jump_gc.jml Had to open data source read-only. INFO: Open of `jump_gc.jml' using driver `JML' successful. ERROR 1: Unexpected geometry type MULTILINESTRING as part of

Re: [gdal-dev] Error in Derived Band in Virtual raster (re-post)

2019-12-02 Thread Rahkonen Jukka (MML)
Hi, Re-posting because the code section that Nabble wrote as html formatted was dropped out. Did the same thing happen for you with your original mail? It seems that you have defined a Python function "add2" that does nothing because it has no code add2 Python

[gdal-dev] Spatialite functions missing when reading GeoPackage

2019-12-01 Thread Rahkonen Jukka (MML)
Hi, This works with GDAL from OSGeo4W, GDAL 3.0.2, released 2019/10/28 ogrinfo any.gpkg -dialect sqlite -sql "select spatialite_version()" INFO: Open of `any.gpkg' using driver `GPKG' successful. Layer name: SELECT Geometry: None Feature Count: 1 Layer SRS WKT: (unknown)

Re: [gdal-dev] ERROR: Too many connections: max 64

2019-11-29 Thread Rahkonen Jukka (MML)
Hi, The changes that are pending in the wal and shm files are written into the database automatically when the last connection to the database is closed https://sqlite.org/wal.html. There are other ways to invoke checkpoint, but if you have for example opened some layer from the database into

Re: [gdal-dev] Gdal_grid and lake bathymetry

2019-11-21 Thread Rahkonen Jukka (MML)
forum. I will be there next week. -Jukka- -Alkuperäinen viesti- Lähettäjä: Joaquim Manuel Freire Luís Lähetetty: torstai 21. marraskuuta 2019 21.42 Vastaanottaja: Rahkonen Jukka (MML) ; gdal-dev@lists.osgeo.org Aihe: RE: [gdal-dev] Gdal_grid and lake bathymetry Jukka, GMT will have

Re: [gdal-dev] Gdal_grid and lake bathymetry

2019-11-21 Thread Rahkonen Jukka (MML)
. marraskuuta 2019 0.30 Vastaanottaja: Even Rouault ; gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: RE: [gdal-dev] Gdal_grid and lake bathymetry The GMT surface program has two (well 3) options that are of interest to this. -One, the -Lu that serves to limit the upper value

Re: [gdal-dev] gdalwarp overhead on linux but not on windows

2019-11-20 Thread Rahkonen Jukka (MML)
UTC 2019 x86_64 x86_64 x86_64 GNU/Linux real 0m0.399s user 0m0.032s sys 0m0.023s -Jukka Rahkonen- Lähettäjä: Brent Wood Lähetetty: keskiviikko 20. marraskuuta 2019 1.12 Vastaanottaja: gdal-dev@lists.osgeo.org; Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] gdalwarp overhead on linux

[gdal-dev] Gdal_grid and lake bathymetry

2019-11-19 Thread Rahkonen Jukka (MML)
Hi, I would like to get some hints about using gdal_grid or some other utility for lake bathymetry. What I have is typically rather sparse point data of depths and the shoreline that includes the islands as in the attached image. The shoreline and all the area that is not lake basin should

Re: [gdal-dev] How to know which formats allow editing with ogrinfo?

2019-11-15 Thread Rahkonen Jukka (MML)
ful. -Jukka- -Alkuperäinen viesti- Lähettäjä: Even Rouault Lähetetty: perjantai 15. marraskuuta 2019 19.55 Vastaanottaja: ea...@co.lincoln.or.us Kopio: gdal-dev@lists.osgeo.org; Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] How to know which formats allow editing with ogrinfo? > Ca

[gdal-dev] How to know which formats allow editing with ogrinfo?

2019-11-15 Thread Rahkonen Jukka (MML)
Hi, Shapefile can be edited with ogrinfo ogrinfo -dialect SQLite -sql "update foo set bar='14'" foo.shp GML opens always as read-only with -sql option ogrinfo -sql "select * from foo" foo.gml Had to open data source read-only. INFO: Open of `foo.gml' using driver `GML' successful. How can

[gdal-dev] Schema support in OAPIF and GeoJSON

2019-11-13 Thread Rahkonen Jukka (MML)
Hi, GeoJSON from OGC API Features service may contain schema or reference to schema and OAPIF driver resolves it. Does the plain GeoJSON driver have the same support? If not, how about to add the support, possibly with an open option to read the schema from a local file? Otherwise it can

[gdal-dev] GDAL and monster multipolygons

2019-10-25 Thread Rahkonen Jukka (MML)
Hi, This shapefile from the Inspire dataportal https://geospatial.jrc.ec.europa.eu/geoserver/wad/ows?service=WFS=1.0.0=GetFeature=wad%3Alpd_int2=SHAPE-ZIP contains 226 (multi)polygons, one of them with 516716 ring. It seems that ogr2ogr can't explode the geometries in a reasonable time.

Re: [gdal-dev] ogr2ogr for windows

2019-10-25 Thread Rahkonen Jukka (MML)
kuuta 2019 8.47 Vastaanottaja: Rahkonen Jukka (MML) ; stephenkno...@gmail.com Kopio: gdal-dev@lists.osgeo.org Aihe: SV: [gdal-dev] ogr2ogr for windows Hi! It seems so easy for you guys, installing a new driver in ogr2ogr. But I haven’t found any information about how to do that in Windows. I can

[gdal-dev] Open option for vectors in the cloud

2019-10-24 Thread Rahkonen Jukka (MML)
Hi, I was experimenting with accessing some vector files through http (same data as FlatGeoBuffers, GeoPackage, and shapefile). The file size in each format was about 850 MB and the amount of data was about 24 linestrings. I made ogrinfo request with spatial filter that selects one feature

Re: [gdal-dev] ogr2ogr for windows

2019-10-18 Thread Rahkonen Jukka (MML)
: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogr2ogr for windows I think you can install the ESRI FileGDB from OSGeo4W: http://download.osgeo.org/osgeo4w/x86/versions.html - see gdal-filegdb On Fri, Oct 18, 2019 at 11:49 AM jratike80 mailto:j

[gdal-dev] Is it generally possible to write multipart result into zip with ogr2ogr?

2019-10-04 Thread Rahkonen Jukka (MML)
Hi, The shapefile documentation declares "Starting with GDAL 3.1, the driver can also support reading, creating and editing .shz files (ZIP files containing the .shp, .shx, .dbf and other side-car files of a single layer) and .shp.zip files (ZIP files contains one or several layers)" but is it

Re: [gdal-dev] ogr2ogr openstreetmap

2019-09-04 Thread Rahkonen Jukka (MML)
: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogr2ogr openstreetmap Sorry for asking, but how did you use the inifile? Kind regards, Paul > 4 sep. 2019 kl. 16:22 skrev jratike80 : > > I can't tell what goes wrong but your command works for me and new >

[gdal-dev] Coordinate system not found from NetCDF file

2019-08-22 Thread Rahkonen Jukka (MML)
Hi, See this problem https://gis.stackexchange.com/questions/332656/reproject-netcdf-file-using-gdalwarp Could some NetCDF specialist tell is there something wrong in the NetCDF file or in GDAL, or does that subdataset just come without CRS? -Jukka Rahkonen-

[gdal-dev] Gdal_translate and -scale with non-Byte output

2019-06-28 Thread Rahkonen Jukka (MML)
Hi, I was reading https://gis.stackexchange.com/questions/247767/performing-histogram-streching-using-gdal-translate and made some tests and now I feel that gdal_translate with -scale does not handle well some use cases with non-Byte output. The syntax is -scale [src_min src_max [dst_min

[gdal-dev] Help user when /vsicurl/ reads GetFileSize=0

2019-06-25 Thread Rahkonen Jukka (MML)
Hi, Have a look at https://gis.stackexchange.com/questions/326773/importing-shapefile-from-website-if-download-link-is-compressed-file/326778 I tried what happens with command ogrinfo /vsizip/vsicurl/https://www2.census.gov/geo/tiger/GENZ2010/gz_2010_36_620_l2_500k.zip --debug on HTTP:

Re: [gdal-dev] GMLAS tries to read spatialreference.org through http

2019-06-04 Thread Rahkonen Jukka (MML)
quot;degree",0.0174532925199433]], CS[ellipsoidal,2], AXIS["geodetic latitude (Lat)",north, ORDER[1], ANGLEUNIT["degree",0.0174532925199433]], AXIS["geodetic longitude (Lon)",east, ORDER[2], ANG

[gdal-dev] GMLAS tries to read spatialreference.org through http

2019-06-04 Thread Rahkonen Jukka (MML)
Hi, I am getting lots of warning like this from the GMLAS driver: HTTP: Fetch(http://spatialreference.org/ref/epsg/28992/) HTTP: These HTTP headers were set: Accept: application/x-ogcwkt ERROR 1: Connection timed out after 10563 milliseconds Warning 1: Reprojection fom

[gdal-dev] Document typo fix suggestion

2019-05-27 Thread Rahkonen Jukka (MML)
Hi, There are 7 occasions of "persitant" in the GDAL documentation but I do not know how to fix them into "persistent" simply with one pull request. Advice about how to do that appreciated but I won't get angry if someone just makes the fix.

Re: [gdal-dev] Is there a reference documentation for GDALMetadata structure?

2019-05-27 Thread Rahkonen Jukka (MML)
- Lähettäjä: Andrea Aime Lähetetty: maanantai 27. toukokuuta 2019 18.59 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Is there a reference documentation for GDALMetadata structure? Hi Jukka, thank you for following up. I believe that provides

[gdal-dev] Something wrong with redirect?

2019-05-27 Thread Rahkonen Jukka (MML)
Hi, I am getting Not found errors by clicking the links from the web search results because browser seems to be directed to addresses like https://gdal.orgdrivers/raster/gtiff.html Notice the missing "/" after gdal.org -Jukka Rahkonen- ___ gdal-dev

[gdal-dev] Possible issue with alpha band and VRT

2019-04-06 Thread Rahkonen Jukka (MML)
Hi, I repeated the steps which are described in this question https://gis.stackexchange.com/questions/317916/gdalbuiltvrt-output-is-different-than-the-source-images-when-using-dstalpha and it indeed seems that transparency that is defined with an alpha band in original images is lost if I read

[gdal-dev] AsGeoJSON with SQLite dialect returns an empty string

2019-03-28 Thread Rahkonen Jukka (MML)
Hi, I noticed this question https://gis.stackexchange.com/questions/316776/ogr2ogr-fails-with-no-such-table and tried to study that odd shapefile by repeating the test with GDAL 2.4.0 from OSGeo4W and there happens something with ST_AsGeoJSON that I do not understand. This command indeed

[gdal-dev] Ogr2ogr manual and -skipfailures

2019-03-10 Thread Rahkonen Jukka (MML)
Hi, On page https://www.gdal.org/ogr2ogr.html I can read from the Performance hints: "For example, for SQLite, explicitly defining -gt 65536 ensures optimal performance while populating some table containing many hundredth thousand or million rows. However, note that if there are failed

[gdal-dev] Documentation of

2019-03-06 Thread Rahkonen Jukka (MML)
Hi, In the documentation of GDAL config options I noticed this: GDAL_SWATH_SIZE Defaults to 1000 (10 MB). Used by gcore/rasterio.cpp Size of the swath when copying raster data from one dataset to another one (in bytes). Should not be smaller than GDAL_CACHEMAX Should it be "...not be bigger

[gdal-dev] Genaral option for saving fids as attributes

2019-02-13 Thread Rahkonen Jukka (MML)
Hi, Every now and then people would like to keep the fids of original data as attributes like in this question https://gis.stackexchange.com/questions/312088/os-translator-plugin-replaces-the-unique-feature-references-toids-with-ogc-fid. Well, perhaps in this case the user wants to use the

[gdal-dev] SQLite dialect does not support ADD COLUMN

2019-02-06 Thread Rahkonen Jukka (MML)
Hi, I was awaiting that the following ogrinfo command woud add a new column but it didn't ogrinfo -dialect sqlite -sql "alter table fidtest add column foo" fidtest.shp INFO: Open of `fidtest.shp' using driver `ESRI Shapefile' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(alter

[gdal-dev] Two questions about gdal_contour

2018-12-13 Thread Rahkonen Jukka (MML)
Hi, I noticed this question in gis.stackexchange https://gis.stackexchange.com/questions/305641/gdal-doesnt-create-contours-for-the-whole-raster?noredirect=1#comment493737_305641 and now I wonder 1) If gdalinfo reports NoData Value=3.4028234663852886e+38, why gdal_contour does not

Re: [gdal-dev] Issue with validate_gpkg.py

2018-11-29 Thread Rahkonen Jukka (MML)
Thanks Brad, works after those edits and gives me an occasion to have a try with a pull request! -Jukka- Lähettäjä: br...@frogmouth.net [mailto:br...@frogmouth.net] Lähetetty: 29. marraskuuta 2018 11:43 Vastaanottaja: Rahkonen Jukka (MML) ; gdal-dev@lists.osgeo.org Aihe: RE: [gdal-dev] Issue

[gdal-dev] Issue with validate_gpkg.py

2018-11-29 Thread Rahkonen Jukka (MML)
Hi, I try to run validate_gpkg.py that I downloaded today from GitHub. I run it under OSGeo4W installation on Windows, GDAL version GDAL 2.3.2, released 2018/09/21, and Python version Python 2.7.14. Validation stops at this error message: Traceback (most recent call last): File

[gdal-dev] How to edit GeoTIFF band names with gdal_edit?

2018-10-04 Thread Rahkonen Jukka (MML)
Hi, The names of the raster bands seem to be stored into GeoTIFF with GDAL tag 42112 Tag 42112: SomeBandName 001 SomeBandName 002 The description can be set with Python by doing something like RasterBand.SetDescription(BandName) I guess that those metadata items can be added also with

Re: [gdal-dev] Warping into gpkg PseudoTMS_GlobalMercator fails

2018-09-19 Thread Rahkonen Jukka (MML)
Even Rouault wrote > On mercredi 19 septembre 2018 05:06:59 CEST Rahkonen Jukka (MML) wrote: >> A workaround is to warp into TIFF and run gdal_translate afterwards >> gdal_translate -of gpkg -co tiling_scheme=PseudoTMS_GlobalMercator 3857.tif >> 3857.gpkg > That's defin

[gdal-dev] Warping into gpkg PseudoTMS_GlobalMercator fails

2018-09-18 Thread Rahkonen Jukka (MML)
Hi, I wonder if there is some issue in gdalwarp and how it is using the GPKG raster driver with a predefined tiling scheme. Feels like gdalwarp does not use any ZOOM_LEVEL_STRATEGY, if not one called "strict". gdalwarp -of gpkg -t_srs epsg:3857 -co tiling_scheme=PseudoTMS_GlobalMercator -co

Re: [gdal-dev] Meaning of First pass in reading GeoJSON

2018-09-13 Thread Rahkonen Jukka (MML)
Even Rouault wrote: On jeudi 13 septembre 2018 08:00:00 CEST Rahkonen Jukka (MML) wrote: >> Hi, >> >> What does GDAL do when it reads the whole GeoJSON file as "GeoJSON: >> First pass"? Could it make the total process faster if user could give >&g

[gdal-dev] Meaning of First pass in reading GeoJSON

2018-09-13 Thread Rahkonen Jukka (MML)
Hi, What does GDAL do when it reads the whole GeoJSON file as "GeoJSON: First pass"? Could it make the total process faster if user could give the same information that is gathered with the First pass somehow directly, or is that step needed in any case? Microsoft has an excellent GeoJSON

[gdal-dev] Adding subdataset into GeoPackage raster with -a_srs requires also RASTER_TABLE

2018-08-07 Thread Rahkonen Jukka (MML)
Hi, I was doing some tests with GeoPackage rasters and found that if I define -a_srs then also -co RASTER_TABLE is required which feels unnecessary. Steps to reproduce: Create initial gpkg gdal_translate -of GPKG global_mosaic_0.png raster.gpkg -a_srs epsg:4326 Try to add a subdataset and

[gdal-dev] Problem with CSV when using both SQLite dialect and -oo GEOM_POSSIBLE_NAMES

2018-08-02 Thread Rahkonen Jukka (MML)
Hi, I can reproduce this https://gis.stackexchange.com/questions/287767/ogrinfo-unable-to-use-sqlite-dialect-with-oo-geom-possible-names-open-option with GDAL 2.4.0dev but I do not undesrtand what happens. -Jukka Rahkonen- ___ gdal-dev mailing list

[gdal-dev] How to copy the EXIF metadata?

2018-08-02 Thread Rahkonen Jukka (MML)
Hi, Referring to this question on gis.stackexchange https://gis.stackexchange.com/questions/291554/how-to-retrieve-exif-tags-from-a-geotiff-with-gdal. The GTiff driver manual https://www.gdal.org/frmt_gtiff.html informs me that "Starting with GDAL 1.10, EXIF metadata can be extracted from the

[gdal-dev] Using GeoPackage as vector tile container?

2018-05-31 Thread Rahkonen Jukka (MML)
Hi, I wonder what would it need to store vector tiles into GeoPackage instead of MBTiles. Officially probably a new extension like the Tiled Gridded Coverage Data extension, but wouln't it technically be rather simple to write vector tiles as BLOBs into the tile_data column instead of png or

Re: [gdal-dev] Example about how to save Tiled Gridded Coverage Data into GeoPackage

2018-05-15 Thread Rahkonen Jukka (MML)
Even Rouault wrote: > On mardi 15 mai 2018 07:58:27 CEST Rahkonen Jukka (MML) wrote: >> Hi, >> >> Are there any examples available about how to convert some DEM data into >> GeoPackage according to the Tiled Gridded Coverage Data extension that GDAL >>

[gdal-dev] Example about how to save Tiled Gridded Coverage Data into GeoPackage

2018-05-15 Thread Rahkonen Jukka (MML)
Hi, Are there any examples available about how to convert some DEM data into GeoPackage according to the Tiled Gridded Coverage Data extension that GDAL 2.3 supports? -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org

Re: [gdal-dev] How to debug the shape open option "encoding"?

2018-05-11 Thread Rahkonen Jukka (MML)
dr_linkki_k.shp -oo encoding="ISO_8859-1" Result: "not a valid UTF-8 string" warnings -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 11. toukokuuta 2018 19:41 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) <jukka

[gdal-dev] How to debug the shape open option "encoding"?

2018-05-11 Thread Rahkonen Jukka (MML)
Hi, I need to run a certain job that requires open option "-oo encoding="ISO_8859-1" and while it runs fine on Windows with the OSGeo4W installation with version GDAL 2.2.4, released 2018/03/19 it leads to loads of warnings "Warning 1: Value of field 'name_field' is not a valid UTF-8 string."

<    1   2   3   4   >