Re: [gdal-dev] Affine parameters in the gdal datamodel doc

2015-01-09 Thread Rahkonen Jukka (MML)
Even Rouault wrote: >> Hi, >> >> I am trying to understand the geotransform parameters by reading >> http://www.gdal.org/gdal_datamodel.html but I am confused. In the >> Affine GeoTransform section there are formulas >> >> Xgeo = GT(0) + Xpixel*GT(1) + Yline*GT(2) >> Ygeo = GT(3) + Xpi

Re: [gdal-dev] Ogrtindex: schema consistency check too strict?

2015-03-17 Thread Rahkonen Jukka (MML)
- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 17. maaliskuuta 2015 17:52 Vastaanottaja: Rahkonen Jukka (MML) Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Ogrtindex: schema consistency check too strict? Jukka, Accepting both Integer and Integer64 as the same could

Re: [gdal-dev] Shapefile driver and support for Boolean attributes

2015-03-18 Thread Rahkonen Jukka (MML)
Hi, I am testing new Boolean data type in OpenJUMP which is saved as Logical when data are exported into shapefiles. Kosmo GIS supports Logical already and Geotools and gvSIG as well. I said Logical is well defined but that is not totally true. Some implementations seem to use space to mean not

Re: [gdal-dev] New error messages when writing Spatialite

2015-03-24 Thread Rahkonen Jukka (MML)
Even Rouault wrote: > Le mardi 24 mars 2015 14:14:25, Jukka Rahkonen a écrit : >> Hi, >> >> I noticed that ogr2ogr from GDAL 2.0-dev is nowadays printing error >> messages which I have not seen before: >> >> "CreateSpatialIndex() error: either "points"."GEOMETRY" isn't a >> Geometry column or

Re: [gdal-dev] Relating to GeoLocation tool of Geospatial PDF Document

2015-04-08 Thread Rahkonen Jukka (MML)
Hi, The OGC_BP option is actually created by TerraGo and I am surprised that it does not work for you with the TerraGo Toolbar because that is the native way for adding georeferencing info into GeoPDF (tm) files. In some of my early tests I found problems with interoperability: Only ISO: OK f

Re: [gdal-dev] Gdal_translate considers --config means -co

2015-06-18 Thread Rahkonen Jukka (MML)
Even Rouault wrote > Le jeudi 18 juin 2015 16:35:37, Jukka Rahkonen a écrit : >> Hi, >> >> Spotted this from gis.stackexchange >> http://gis.stackexchange.com/questions/151153/is-gdal-translate-ignori >> ng-th >> e-cpl-tmpdir-switch >> >> I repeated the test on Windows with GDAL 2.0 and it seems

Re: [gdal-dev] Question

2015-08-26 Thread Rahkonen Jukka (MML)
Hi, I made my test with GDAL 2.0 binaries from gisinternals by placing your osmconf.ini into \bin\gdal-data. Any change you do for the selected tags in osmconf.ini will have on effect on " ogrinfo hamburg-latest.osm.pbf points -so ". Don't do anything before you see that your osmconf.ini is use

Re: [gdal-dev] SRS of the Elastic Search geometries?

2015-09-01 Thread Rahkonen Jukka (MML)
Even Rouault wrote: >> >> Probably that's it, the explicit SRS. I started with data that have native >> SRS epsg:3067 and OpenJUMP JML format which has no means for holding SRS. >> Conversion into ES gives always an empty layer, just the schema gets >> inserted but no geometries, even is I use -s_

Re: [gdal-dev] Gdaltransform hangs sometimes after being idle

2015-09-05 Thread Rahkonen Jukka (MML)
Hi, I can reproduce now. GDAL is 64-bit 2.1-dev from http://download.gisinternals.com/sdk/downloads/release-1600-x64-gdal-mapserver.zip 1. gdaltransform -s_srs epsg:4326 -t_srs epsg:3067 30 65 641428.429705435 7211811.30748109 0 --wait 5 minutes 31 70 652590.036387019 7770880.82231984 0 --now Ct

Re: [gdal-dev] Bad design in -clipsrs?

2015-10-25 Thread Rahkonen Jukka (MML)
bbox of a feature - no cross - for sure no need to clip. -Jukka- Lähettäjä: Even Rouault<mailto:even.roua...@spatialys.com> Lähetetty: ‎25.‎10.‎2015 12:02 Vastaanottaja: gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Kopio: Rahkone

Re: [gdal-dev] Motion: Adopt RFC 60: Improved round-tripping in OGR

2015-11-05 Thread Rahkonen Jukka (MML)
+1 -Jukka Rahkonen- >Hi, >Since no remarks have been done on the latest proposal, I move to adopt RFC >60 : Improved round-tripping in OGR >https://trac.osgeo.org/gdal/wiki/rfc60_improved_roundtripping_in_ogr >Starting with my +1, >Even __

Re: [gdal-dev] Proposed Block iterator API

2015-11-25 Thread Rahkonen Jukka (MML)
Hi, I was wondering if this idea could resolve also this old ticket https://trac.osgeo.org/gdal/ticket/1233 -Jukka Rahkonen- Even Rouault wrote: Hi, I was wondering if there wasn't a need for a block iterator API for code that wants to process raster efficiently and iterates over blocks f

Re: [gdal-dev] strange grid pattern when reprojecting

2015-11-27 Thread Rahkonen Jukka (MML)
Hi, Gdalwarp is the tool to use and usually it works well but your case is not the most common one "lunar south polar DEMs in stereographic projection to gnomonic projection." Best if you could put a sample image available somewhere but perhaps but there are some documents about advanced trick

Re: [gdal-dev] strange grid pattern when reprojecting

2015-11-30 Thread Rahkonen Jukka (MML)
Hi, Sorry for being unclear, I meant a sample of source data that could be used for reproducing the issue, not a sample of output with a grid artifact. -Jukka Rahkonen- > Hi, > I've tried adding -et 0 and the grid feature is still there. Here is an > example: https://www.dropbox.com/s/teywuev

Re: [gdal-dev] Question: Creating overviews

2015-12-01 Thread Rahkonen Jukka (MML)
Hi, That is normal. Overviews are kind of support files for the main image and geotransform can be stolen from there. With internal overviews in TIFF that's also the only possibility. If you need standalone downsampled images create them with gdal_translate or gdalwarp. -Jukka Rahkonen- Gane

Re: [gdal-dev] Motion: Commit access to David Adler

2015-12-03 Thread Rahkonen Jukka (MML)
+1 -Jukka Rahkonen- Mateusz Loskot wrote: Motion: Committer Status for David Adler --- ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] GeoPDF content inverted as GeoTIF

2015-12-14 Thread Rahkonen Jukka (MML)
Hi, There is something odd in the PDF. It is without coordinate system and perhaps because of that the top-left coordinates are (0,0) and north coordinate is increasing from top to bottom. Probably the "Invalid length for GPTS object" error does not have any effect on this. gdalinfo loopmap.

Re: [gdal-dev] How to append to all layers with ogr2ogr?

2016-02-01 Thread Rahkonen Jukka (MML)
Hi, Did you try to add another GML file into existing GeoPackege? First run OK: ogr2ogr -f gpkg -update -append mtk.gpkg /vsizip/K2344R_mtk.zip Secong run gives an error: ogr2ogr -f gpkg -update -append mtk.gpkg /vsizip/K2433L_mtk.zip ERROR 1: Layer Kunta already exists, and -append not specifie

Re: [gdal-dev] How to append to all layers with ogr2ogr?

2016-02-01 Thread Rahkonen Jukka (MML)
More intormation: Reason may be that GML files do not have same layers but the second one has one layer more: ogrinfo /vsizip/K2344R_mtk.zip ERROR 1: Random access not supported for /vsizip Had to open data source read-only. INFO: Open of `/vsizip/K2344R_mtk.zip' using driver `GML' success

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

2016-05-01 Thread Rahkonen Jukka (MML)
Andrea Borruso wrote: >thank you very much. I had read that page, but stupidly I did not think >that "ALTER TABLE tablename ADD [COLUMN] columnname columntype" meant >strictly that I could only use it in this way. >My wrong intepretion was that I could use "alter table add" SQL command >and its v

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

2016-05-02 Thread Rahkonen Jukka (MML)
Andrea wrote: >Hi Jukka, >Rahkonen Jukka (MML) wrote >> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN >> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is >> not mentioned in a bunch of docum

Re: [gdal-dev] GDAL 2.0.2 & gpkg woes

2016-05-02 Thread Rahkonen Jukka (MML)
Alan Stewart wrote: >Unfortunately, makes no difference, with my application code or ogr2ogr. I >also tested the new libspatialite-4.2.0a DLL >against my old GDAL build. Works >fine. Hi, Perhaps you should try to GPKG driver with GDAL that is built without Spatialite. As far as I know GPKG d

Re: [gdal-dev] Motions: Promote 1.11.5 RC 1, 2.0.3 RC2 and and 2.1.1 RC2 for release

2016-07-12 Thread Rahkonen Jukka (MML)
+1 for all three. -Jukka Rahkonen- Lähettäjä: Even Rouault<mailto:even.roua...@spatialys.com> Lähetetty: ‎12.‎7.‎2016 12:15 Vastaanottaja: Rahkonen Jukka (MML)<mailto:jukka.rahko...@maanmittauslaitos.fi> Aihe: Fwd: [gdal-dev] Motions: Promote 1.11.5

Re: [gdal-dev] Issues with MapInfo Conversion to GeoJson using ogr2ogr

2016-08-16 Thread Rahkonen Jukka (MML)
Suman Humagain wrote: > Hi folks, > I am converting the Mapinfo files to GeoJson format using the ogr2ogr tool. > The things are working great and its converting fine but i am getting > different polylines than i have drawn in the mapinfo. Some extra polylines > are created in the intersections.

Re: [gdal-dev] Preserve Source Raster Resolution When Merging

2016-08-25 Thread Rahkonen Jukka (MML)
Sam Wilson wrote: > Hi, > I'm attempting to merge (or maybe the proper term is mosaic) overlapping > raster datasets of varying resolutions. I'd like to have the higher > resolution datasets override the lower resolution datasets where available. > I've been able to get close using various me

[gdal-dev] GPKG: Drop table but how to drop the rest?

2016-09-29 Thread Rahkonen Jukka (MML)
Hi, I wonder if it could be possible to do something like "DROP CASCADING" in GeoPackage and delete the spatial index by the same. It will for sure be unusable once the table is dropped. I feel that SQLite does not support that because cascading drop seems to require that parent and child table

[gdal-dev] Gdal_grid with a mask layer?

2016-10-06 Thread Rahkonen Jukka (MML)
Hi, I have depth data from a lake as scattered points and I would like to convert them into raster DEM. Unfortunately this lake is not a rectangular, north oriented one but it has a curvy shoreline and lots of islands. In my first trials the resulting DEM leaks away from the water to the dry g

[gdal-dev] RFC 64 wiki page is empty

2016-10-27 Thread Rahkonen Jukka (MML)
Hi, There is no contents in https://trac.osgeo.org/gdal/wiki/rfc64_triangle_polyhedralsurface_tin but it would be nice to have something. I suppose that RFC was defined and implemented in https://github.com/avyavkumar/gdal/wiki -Jukka Rahkonen- ___ g

[gdal-dev] Ogr and long list of errors due to missing SQLite module

2016-10-28 Thread Rahkonen Jukka (MML)
Hi, If a GeoPackage file is touched with recent Spatialite-gui it creates automatically a virtual GPKG table for each native spatial GPKG table. If I now use ogrinfo or ogr2ogr with such database it will print an error for each virtual layer like ERROR 1: no such module: VirtualGPKG Warning 1:

[gdal-dev] Should GDAL handle this KML superoverlay?

2016-11-01 Thread Rahkonen Jukka (MML)
Hi, I have some images which are georeferenced with a KML file and they show fine with Google Earth. However, GDAL does not know what to do with them. I put some test data here: http://latuviitta.org/downloads/shaded.kmz http://latuviitta.org/downloads/shaded.kml http://latuviitta.org/downloads/

[gdal-dev] Attach database and GeoPackage

2016-11-03 Thread Rahkonen Jukka (MML)
Hi, I have been thinking that it could be nice to be able to open GeoPackage with attached database https://www.sqlite.org/lang_attach.html. Attaching database that contains spatial tables would probably give too much troubles because reading the spatial metadata of the attached db through the

[gdal-dev] Make gdal_polygonize to support the mask band

2016-11-04 Thread Rahkonen Jukka (MML)
Hi, Once again someone wants to get the footprints of valid data in images http://gis.stackexchange.com/questions/216624/creating-a-shapefile-for-footprint-of-tasters-valid-data-areas-with-gdal. A year ago, in here https://lists.osgeo.org/pipermail/gdal-dev/2015-October/042859.html Even suggest

Re: [gdal-dev] How to replace an osm key?

2016-11-11 Thread Rahkonen Jukka (MML)
Hi, Ogrinfo and ogr2ogr usually accept the same syntax and therefore I gave the ogrinfo example. I apologize, it can’t be self-evident for all GDAL users. You can do the whole thing with one command like this: ogr2ogr.exe --config OSM_USE_CUSTOM_INDEXING NO -skipfailures -f "ESRI Shapefile" -d

Re: [gdal-dev] How to replace an osm key?

2016-11-11 Thread Rahkonen Jukka (MML)
on points and relations (other_relations for GDAL). I also aimed at a general answer that could be useful for all tags and layers in OSM data. -Jukka Rahkonen- Lähettäjä: Djordje Spasic [mailto:issworld2...@yahoo.com] Lähetetty: 11. marraskuuta 2016 16:38 Vastaanottaja: Rahkonen Jukka (MML

Re: [gdal-dev] How to replace an osm key?

2016-11-11 Thread Rahkonen Jukka (MML)
_ Lähettäjä: Djordje Spasic<mailto:issworld2...@yahoo.com> Lähetetty: ‎11.‎11.‎2016 19:10 Vastaanottaja: Rahkonen Jukka (MML)<mailto:jukka.rahko...@maanmittauslaitos.fi>; gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Aihe: Re: [gdal-dev] How to replace an osm key? Thank

Re: [gdal-dev] How to replace an osm key?

2016-11-12 Thread Rahkonen Jukka (MML)
y is the upper "no such column: height" error message raised? Is something wrong with the SQL syntax? Thank you for the reply. Kind regards, Djordje On Friday, November 11, 2016 6:46 PM, Rahkonen Jukka (MML) wrote: Hi, If you select geometry and attri

Re: [gdal-dev] How to replace an osm key?

2016-11-14 Thread Rahkonen Jukka (MML)
hp_files" And they both work. The problem is that: once the .shp file is created, and I open it, all shapes have the "building:level" value for the "bldg_level" field. Here is a screenshot: https://www.dropbox.com/s/nmlkkzr85w225qb/sql_choosing_keys.jpg?dl=0 Why is this hap

Re: [gdal-dev] How to replace an osm key?

2016-11-14 Thread Rahkonen Jukka (MML)
web while I am not. SQL is so close to English and that you can think that you are making a (comma separated) shopping list “SELECT milk,bread,juice FROM Wal-Mart”. -Jukka- Lähettäjä: Djordje Spasic [mailto:issworld2...@yahoo.com] Lähetetty: 14. marraskuuta 2016 17:21 Vastaanottaja: Rahk

[gdal-dev] Ogr2ogr -dim and Oracle

2016-11-17 Thread Rahkonen Jukka (MML)
Hi, I noticed that Even was editing the ogr2ogr help about the -dim parameter and remembered that I think that it does not have an effect on the OCI driver. For forcing a new Oracle table into 2D you must use the OCI drivers own layer creation option "DIM" instead http://www.gdal.org/drv_oci.h

Re: [gdal-dev] Ogr2ogr -dim and Oracle

2016-11-17 Thread Rahkonen Jukka (MML)
Hi, I would also check how ogr2ogr options –a_srs and –t_srs behave or if the OCI driver option –lco SRID is still needed. -Jukka- Lähettäjä: Michael Smith [mailto:michael.smith.e...@gmail.com] Lähetetty: 17. marraskuuta 2016 13:49 Vastaanottaja: Rahkonen Jukka (MML) Kopio: 'gda

Re: [gdal-dev] Ogr2ogr -dim and Oracle

2016-11-17 Thread Rahkonen Jukka (MML)
Hi, Probably SDO_COORD_REF_SYS is what to use nowadays even I guess that it points to MDSYS tables. Looks like something has changed with Oracle 10.2 and I believe that it is very hard to use so old Oracle version without paying much extra. https://docs.oracle.com/database/121/SPATL/GUID-7DEF5C

Re: [gdal-dev] Why are fields required in osmconf.ini file?

2016-11-18 Thread Rahkonen Jukka (MML)
You need to have both: include all_tags in osmconf.ini and define with the ogr2ogr command that field “all_tags” in PostGIS should be initialized as hstore. If you do not define column type all_tags will probably become text type column. Make a test and you will see it. -Jukka Rahkonen- Djordj

[gdal-dev] GDAL and ElasticSearch 5.0

2016-11-21 Thread Rahkonen Jukka (MML)
Hi, I tried to test new ElasticSearch version with no success and I wonder what is wrong. My command and debug data follows. ogr2ogr -f "ElasticSearch" http://localhost:9200 -s_srs epsg:3067 -t_srs epsg:4326 test_es50.shp --debug on GDAL: GDALOpen(test_es50.shp, this=02454920) succeeds

[gdal-dev] Question about how GDAL makes an ElasticSearch index

2016-11-23 Thread Rahkonen Jukka (MML)
Hi, It seems that all examples about how to query ElasticSearch with GDAL in http://www.gdal.org/drv_elasticsearch.html are failing with ElasticSearch versions 2.x. Reason is the breaking change "A field can no longer be referenced using its short name. Instead, the full path to the field is re

[gdal-dev] ElasticSearch and native geometry

2016-11-23 Thread Rahkonen Jukka (MML)
Hi, What if somebody would like to use ElasticSearch for queries but still somehow get the native geometries included in the output? The geometry must be re-projected into EPSG:4326 for creating either geo_point or geo_shape, but can anybody suggest a clever way for saving the native geometry?

[gdal-dev] How does WMTS driver detect DataWindow?

2016-11-28 Thread Rahkonen Jukka (MML)
Hi, While playing with gdal_translate and WMST my colleague found that GDAL was picking a wrong DataWindow with gdal_translate "WMTS:http://xx.yy.fi/foo/service?REQUEST=GetCapabilities&SERVICE=WMTS,layer=bar"; bar.xml -of WMTS After some thinking we started to believe that the reason may b

Re: [gdal-dev] How does WMTS driver detect DataWindow?

2016-11-29 Thread Rahkonen Jukka (MML)
l-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev] How does WMTS driver detect DataWindow? On lundi 28 novembre 2016 15:33:31 CET Rahkonen Jukka (MML) wrote: > Hi, > > While playing with gdal_translate and WMST my colleague found that GDAL was > picking a wron

Re: [gdal-dev] How does WMTS driver detect DataWindow?

2016-11-30 Thread Rahkonen Jukka (MML)
Hi, I got to understand why WMTS service has so large WGS84 bounding box in GetCapabilities. It is because the native EPSG:3067 bounding box is first converted into WGS84 by using a densified polygon geometry. The WGS84BoundingBox is then the envelope of this warped polygon. Because of warpi

[gdal-dev] Append new data to GeoPackege raster table as overview

2016-12-01 Thread Rahkonen Jukka (MML)
Hi, Let's say that I have these raster maps with 2048 m and 1024 m pixel sizes http://kartat.kapsi.fi/files/taustakarttasarja_jhs180/taustakartta_8m/2048m/etrs89/png/Taustakartta_8milj.png http://kartat.kapsi.fi/files/taustakarttasarja_jhs180/taustakartta_8m/2048m/etrs89/png/Taustakartta_8milj.pgw

Re: [gdal-dev] osm_id vs osm_way_id?

2016-12-02 Thread Rahkonen Jukka (MML)
Hi, ogr2ogr creates these ids: - for point data node_id becomes ”osm_id” - for linestrings way_id becomes “osm_id” - for multilinestrings relation_id becomes “osm_id” - for other relations relation_id becomes “osm_id” - for polygons which come fro

Re: [gdal-dev] How does GDAL OSM driver deal with closed ways?

2016-12-05 Thread Rahkonen Jukka (MML)
Djordje Spasic wrote: I will definitively read through the links you gave me Jukka. Thank you. Until then, do you mind if I ask just for a tiny clarification? > The default rendering style file has such a list https://github.com/openstreetmap/osm2pgsql/blob/master/default.style Is this the

Re: [gdal-dev] Call for discussion on RFC 64: Triangle, Polyhedral surface and TIN

2016-12-07 Thread Rahkonen Jukka (MML)
Hi, Perhaps some problem with markup, the WKT dows show in Nabble http://osgeo-org.1560.x6.nabble.com/gdal-dev-Call-for-discussion-on-RFC-64-Triangle-Polyhedral-surface-and-TIN-tc5298840.html MULTIPOLYGON ((( 553 352, 327 363, 442 486, 553 352 )), (( 327 363, 553 352, 422 186, 327 363 ))) -Juk

[gdal-dev] Creating JPEG compressed external overviews fails

2016-12-13 Thread Rahkonen Jukka (MML)
Hi, This has worked for me and still works with GDAL version GDAL 2.0dev, released 2011/12/29 gdaladdo -r average -ro --config COMPRESS_OVERVIEW JPEG --config PHOTOMETRIC_OVERVIEW YCBCR --config INTERLEAVE_OVERVIEW PIXEL input.tif 2 4 8 16 32 64 However, GDAL 2.2.0dev, released 2016/99/99 fai

Re: [gdal-dev] Wrong interpretation of DIMENSION features in GDAL DXF driver

2017-01-16 Thread Rahkonen Jukka (MML)
Sorry, Nabble did not include my ogr2ogr command to the mailing list mail, reposting. You can do the join as suggested in http://www.geopackage.org/modeling_guidelines.html by converting the first geometry with all the attributes into GeoPackage as you have done, and then adding another layer

[gdal-dev] GMLAS does not resolve schema from WFS data

2017-01-18 Thread Rahkonen Jukka (MML)
Hi, I downloaded one CadastralParcel from an INSPIRE service with curl curl -k -o inspire-cp.gml "https://inspire-wfs.maanmittauslaitos.fi/inspire-wfs/cp?service=WFS&version=2.0.0&request=GetFeature&TypeNames=cp:CadastralParcel&count=1"; Then I tried to check what I have with ogrinfo but it fai

Re: [gdal-dev] GMLAS does not resolve schema from WFS data

2017-01-18 Thread Rahkonen Jukka (MML)
lt wrote: Re: [gdal-dev] GMLAS does not resolve schema from WFS data On mercredi 18 janvier 2017 10:52:28 CET Rahkonen Jukka (MML) wrote: > Hi, > > I downloaded one CadastralParcel from an INSPIRE service with curl > > curl -k -o inspire-cp.gml > "https:

[gdal-dev] MBTiles from gdal2tiles vs. from gdal_translate

2017-01-22 Thread Rahkonen Jukka (MML)
Hi, In the "Participating on gdal2tiles" thread Mark Johnson wrote: "You might also consider incorporating the mbtiles implementation of a fork of gdal2tiles that can be found here: https://github.com/mj10777/gdal2mbtiles Here the goal was to also offer mbtiles as the output-format - instead of a

[gdal-dev] Precision of classification in gdal_sieve.py

2017-02-10 Thread Rahkonen Jukka (MML)
Hi, See this gis.stackexchange question about gdal_sieve http://gis.stackexchange.com/questions/227709/why-is-all-0-after-using-gdal-sieve-on-a-raster-layer. By the documentation http://www.gdal.org/gdal_sieve.html it is not clear with which precision the pixels are classified to have the same v

[gdal-dev] Don't we have any ideas for GSoC 2017?

2017-02-28 Thread Rahkonen Jukka (MML)
Hi, OSGeo is accepted as an organization for the Google Summer of Code 2017 but there are no GDAL related ideas on https://wiki.osgeo.org/wiki/Google_Summer_of_Code_2017_Ideas. Could we raise some of the old ideas or discover some brand new ones? -Jukka Rahkonen- __

[gdal-dev] Vintage issue #1778 FIXED!

2017-02-28 Thread Rahkonen Jukka (MML)
Hi, I love these cases, a ten year old issue which got really fixed, not just closed as too old or something https://trac.osgeo.org/gdal/ticket/1778 Hooray Taylor Alexander Brown and Even! -Jukka Rahkonen- ___ gdal-dev mailing list gdal-dev@lists.osgeo

[gdal-dev] FW: Don't we have any ideas for GSoC 2017?

2017-03-01 Thread Rahkonen Jukka (MML)
roid<https://aka.ms/ghei36> From: gdal-dev mailto:gdal-dev-boun...@lists.osgeo.org>> on behalf of Casper Børgesen (CABO) mailto:c...@niras.dk>> Sent: Tuesday, February 28, 2017 5:16:19 AM To: Rahkonen Jukka (MML); 'gdal-dev@lists.osge

Re: [gdal-dev] Testing of OGR generated GeoPackage datasets with other implementations

2017-03-02 Thread Rahkonen Jukka (MML)
Hi Right, ne_10m_admin_0_countries_france_no_ogr_feature_count.gpkg opens with MapInfo 15.2. -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 2. maaliskuuta 2017 15:49 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) Aihe: Re: [gdal-dev

[gdal-dev] Reading SQLite in WAL mode as read-only

2017-03-04 Thread Rahkonen Jukka (MML)
Hi, I saw this changeset https://trac.osgeo.org/gdal/changeset/37594 and started to think that how GDAL is reading SQLite db that is in WAL journal mode from zip, tar, vsicurl or from non-writeble directory if it is documented to be generally not possible http://www.sqlite.org/draft/wal.html?

[gdal-dev] WFS driver and GML application schema

2017-03-07 Thread Rahkonen Jukka (MML)
Hi, What if a WFS server is returning GML that has complex schema, does GDAL know to open the response as GML application schema data automatically or with some open option? I ask because I can see "succeeds as GML" in the debug log: HTTP: Fetch(https://opaskartta.turku.fi/TeklaOGCWeb/WFS.as

Re: [gdal-dev] sqlite -> spatialite (rowid)

2017-03-07 Thread Rahkonen Jukka (MML)
test also cases where ROWID differs from OID and _ROWID_? -Jukka- Lähettäjä: Even Rouault [mailto:even.roua...@spatialys.com] Lähetetty: 7. maaliskuuta 2017 16:51 Vastaanottaja: gdal-dev@lists.osgeo.org Kopio: Rahkonen Jukka (MML) ; a.furi...@lqt.it Aihe: Re: [gdal-dev] sqlite -> spatialite (row

Re: [gdal-dev] sqlite -> spatialite (rowid)

2017-03-07 Thread Rahkonen Jukka (MML)
taanottaja: Rahkonen Jukka (MML) Kopio: Even Rouault; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] sqlite -> spatialite (rowid) On Tue, 7 Mar 2017 15:07:04 +0000, Rahkonen Jukka (MML) wrote: > Hi, > > I have a slight feeling that there may be some trouble if attribute > "ROWID"

[gdal-dev] GeoPackege, views and spatial index

2017-03-16 Thread Rahkonen Jukka (MML)
Hi, I can create a spatial view into GeoPackage database by following the document http://www.geopackage.org/modeling_guidelines.html and I can open such a view with QGIS. But have I understood right that there is no way in GeoPackage to link the R-Tree spatial index of the main table with the

[gdal-dev] Ogrinfo does not open any more raster-only geopackage

2017-03-24 Thread Rahkonen Jukka (MML)
Hi, Recent GDAL 2.2-dev versions can't open geopackage that contains only raster data. ogrinfo -ro -sql "PRAGMA journal_mode" raster.gpkg I found a 2.2-dev version from 2016-12-09 and that does run my PRAGMA query. Could it be possible to get this possibility back? -Jukka Rahkonen- __

[gdal-dev] Can't edit alpha in palette through VRT

2017-03-24 Thread Rahkonen Jukka (MML)
Hi, I am following the FAQ "How to create or modify an image color table?" from https://trac.osgeo.org/gdal/wiki/FAQRaster I took out the palette from existing tiff file into VRT and I would like to change alpha value of the first input from 255 into 0. I had originally this: Palette

Re: [gdal-dev] Ogrinfo does not open any more raster-only geopackage

2017-03-26 Thread Rahkonen Jukka (MML)
Even Rouault wrote: Re: [gdal-dev] Ogrinfo does not open any more raster-only geopackage > Hi Jukka, > I could only reproduce with a .gpkg that didn't have a gpkg_geometry_columns > table. Which is valid, but not what GDAL creates, so I guess this comes from > another software ? That GeoPack

[gdal-dev] GML lat-lon coverages and interoperability

2017-04-03 Thread Rahkonen Jukka (MML)
Cross posting intentionally. TL;DR I wonder if all projects under the OSGeo umbrella, starting from GDAL and Geoserver, could make a common agreement on not to use GridFunctions in GML coverages if they are not strictly needed. The other alternative would be to make all projects to support GML

Re: [gdal-dev] GML lat-lon coverages and interoperability

2017-04-03 Thread Rahkonen Jukka (MML)
ta Andrea Aime Lähetetty: 3. huhtikuuta 2017 15:58 Vastaanottaja: Rahkonen Jukka (MML) Kopio: 'gdal-dev@lists.osgeo.org' (gdal-dev@lists.osgeo.org) ; geoserver-de...@lists.sourceforge.net Aihe: Re: [gdal-dev] GML lat-lon coverages and interoperability On Mon, Apr 3, 2017 at 2:32 PM, Ra

Re: [gdal-dev] GML lat-lon coverages and interoperability

2017-04-03 Thread Rahkonen Jukka (MML)
N) Lower Right ( 24.8422669, 61.7282236) ( 24d50'32.16"E, 61d43'41.61"N) -Jukka- Lähettäjä: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Puolesta Andrea Aime Lähetetty: 3. huhtikuuta 2017 16:31 Vastaanottaja: Rahkonen Jukka (MML) Kopio: 'gdal-dev@lists.

Re: [gdal-dev] GML lat-lon coverages and interoperability

2017-04-03 Thread Rahkonen Jukka (MML)
@lists.osgeo.org Kopio: Rahkonen Jukka (MML); Andrea Aime; geoserver-de...@lists.sourceforge.net Aihe: Re: [gdal-dev] GML lat-lon coverages and interoperability On lundi 3 avril 2017 13:19:18 CEST Rahkonen Jukka (MML) wrote: > Great, first hit from Andrea. I am awaiting if Even strikes back.

Re: [gdal-dev] [Geoserver-devel] GML lat-lon coverages and interoperability

2017-04-10 Thread Rahkonen Jukka (MML)
Hi, Even wrote: However I'm not sure in which way GDAL is involved in this discussion :-) I am preparing for the future when GDAL will have a support for WCS 2.0.1 and it will try to read EPSG:4326 coverage data from GeoServers witch describe coverage like this: http://demo.geo-solutions.it/g

[gdal-dev] SQLite-SQL problem with some layer names

2017-04-12 Thread Rahkonen Jukka (MML)
Hi, I have problems in using the SQLite dialect if layer names contains numbers or underscores. I am on Windows. ogrinfo -dialect sqlite 3d.shp -sql "select * from 3d" INFO: Open of `3d.shp' using driver `ESRI Shapefile' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select * from

Re: [gdal-dev] SQLite-SQL problem with some layer names

2017-04-12 Thread Rahkonen Jukka (MML)
Hi, Hi, I had a try with editing the .dox file that is used for generating http://www.gdal.org/ogr_sql_sqlite.html with changeset #37971. Could you check if the text makes sense and appears right? -Jukka- _

[gdal-dev] Wrong namespaces in GML 3.2 written by GDAL

2017-04-27 Thread Rahkonen Jukka (MML)
Hi, With GML 3.2 output GDAL 2.2-dev writes into the schema xmlns:gml="http://www.opengis.net/gml/3.2"; xmlns:gmlsf="http://www.opengis.net/gmlsf/2.0"; The first one redirects to http://schemas.opengis.net/gml/3.2.1/gml.xsd. The latter one gives "Not found". I guess that the schema is nowadays i

Re: [gdal-dev] Wrong namespaces in GML 3.2 written by GDAL

2017-04-27 Thread Rahkonen Jukka (MML)
Sorry for the noise. -Jukka- Even Rouault wrote: Re: [gdal-dev] Wrong namespaces in GML 3.2 written by GDAL On jeudi 27 avril 2017 17:01:27 CEST Rahkonen Jukka (MML) wrote: > Hi, > > With GML 3.2 output GDAL 2.2-dev writes into the schema > > xmlns:gml="http://www.open

[gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

2017-05-19 Thread Rahkonen Jukka (MML)
Hi, See this gis.stackexchange question https://gis.stackexchange.com/questions/240900/shp2pgsql-segmentation-fault. I have confirmed that Europe_coastline.shp from this zip https://www.eea.europa.eu/data-and-maps/data/eea-coastline-for-analysis-1/gis-data/europe-coastline-shapefile/at_download

Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

2017-05-19 Thread Rahkonen Jukka (MML)
Hi, That's it. I think I should have known to read carefully the PG driver manual http://www.gdal.org/drv_pg.html. -Jukka- Even Rouault wrote: Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile On vendredi 19 mai 2017 15:15:02 CEST Rahkonen Jukka (MML) wrote:

Re: [gdal-dev] Ogr2ogr, PostGIS and numeric field overflow with a shapefile

2017-05-19 Thread Rahkonen Jukka (MML)
Hmm, but how about other formats? Is there some general workaround? For example conversion into shapefiles fails because of this error while geopackage seems to be OK. -Jukka- Lähettäjä: Rahkonen Jukka (MML) Lähetetty: 19. toukokuuta 2017 18:32 Vastaanottaja: 'Even Rouault' ;

[gdal-dev] Interesting issue with ogr2ogr and -tps

2017-06-27 Thread Rahkonen Jukka (MML)
Hi, There is a well written question in gis.stackexchange about how the -tps option in ogr2ogr behaves https://gis.stackexchange.com/questions/245391/ogr2org-tps-spline-method-creates-progressive-error Does anybody have a clue about what happens? -Jukka Rahkonen- __

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

[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 https://gis.stackexchange.com/questions/369014/mapinfo-tab-files-with-largeint-cant-be-

[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 Mercato

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

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 but I trust th

[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] I have a problem getting higher resolution in a VRT file

2020-08-20 Thread Rahkonen Jukka (MML)
https://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] 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

[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 com

[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 th

[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 th

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 w

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

2020-11-10 Thread Rahkonen Jukka (MML)
a-karttakuva.maanmittauslaitos.fi/wcs/service/ows?version=2.0.1&coverage=ortokuva__ortokuva"; scaled.tiff gdalinfo works as well gdalinfo "WCS:https://beta-karttakuva.maanmittauslaitos.fi/wcs/service/ows?version=2.0.1&coverage=ortokuva__ortokuva"; -Jukka Rahkonen- Lähettäjä: 1520 gis L

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] 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] Oracle Spatial Driver: Is it possible to append features to a table?

2020-11-12 Thread Rahkonen Jukka (MML)
ll end) maxx, min(case when r=2 then sdo_ub else null end) maxy from (SELECT d.sdo_dimname, 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

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

2020-11-14 Thread Rahkonen Jukka (MML)
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 Dri

  1   2   3   4   >