Re: [gdal-dev] Issue reprojecting geo tiff

2013-08-14 Thread Rahkonen Jukka
taanottaja: Rahkonen Jukka Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Issue reprojecting geo tiff For PA, it gives: Driver: PDF/Geospatial PDF Files: PA_Tionesta_20130621_TM_geo.pdf Size is 13652, 17403 Coordinate System is: PROJCS["UTM Zone 17, Northern Hemisphere", GEOGCS[&quo

Re: [gdal-dev] Gdalinfo does not print into file on Windows

2013-09-17 Thread Rahkonen Jukka
Hi, Yes, it is the same issue. After removing the plugin "gdal_ECW_JP2ECW" the output can be directed into file. Setting GDAL_SKIP=ECW did not help. -Jukka- Even Rouault wrote: > Hi Jukka, > This reminds me a lot the following ticket : > http://trac.osg

Re: [gdal-dev] [EXTERNAL] Minimum user rights needed for Oracle driver

2013-10-01 Thread Rahkonen Jukka
Hi, What about if GDAL and Oracle can't find common understandment about SRID? I have seen that GDAL tries then to insert something into MDSYS.CS_SRS and with our user rights that fails always. I have not studied that further because that comes always from my error and adding -lco SRID helps w

Re: [gdal-dev] Skipping PHOTOMETRIC=YCBCR when not reasonable

2013-11-01 Thread Rahkonen Jukka
Hi, Yes, it is understandable because there are so many parameters which may be wrong. I still don't write any other scripts than Windows batch files and testing the return codes is not my business. I will continue by sorting the source files as well as I can and running the batch a second time

[gdal-dev] Re: Re: Strange things with gdalwarp ...

2009-08-17 Thread Rahkonen Jukka
From: Hermann Peifer gmx.eu> > A promising approach seemed to be to warp/resample the ASTER files one by one > and create 1500 separate tiles > in LAEA projection, as an intermediate step. Then I created a vrt file with > gdalbuildvrt and > gdal_translated it into tiff format. The result did h

Re: [gdal-dev] Re: Strange things with gdalwarp ...

2009-08-20 Thread Rahkonen Jukka
Even Rouault wrote: > Quoting Jukka Rahkonen : > > > Hermann Peifer gmx.eu> writes: > > > > > > > > Jukka wrote > > > > > > > > > > Did you try to use gdalwarp also for the second step with > > > > -srcnodata > > value > > [value...]? I believe you did set > > > some NODATA value in step 1 fo

Re: [gdal-dev] Spatialite oddness

2009-09-21 Thread Rahkonen Jukka
wrote > Selon Jukka Rahkonen : > > Jukka, > > yes, I can also reproduce the issue, but the solution is > quite easy. You'll have to convince Frank to update FWTools' > sqlite3.dll to a newer one as it appears that the sqlite lib > used by spatialite-gu

[gdal-dev] Re: Fastest vector format for combining shapefiles

2009-10-06 Thread Rahkonen Jukka
Jukka Rahkonen writes: > > Hi, > > I am combining some GIS data where each layer is divided to around thousand > separare shapefiles by mapsheets. Now I would like to store all the 35000 > shapefiles to something that is more easy to handle. At first pushing each layer > to own Spatialite databa

VS: [gdal-dev] Re: Fastest vector format for combining shapefiles

2009-10-07 Thread Rahkonen Jukka
ex.html). It will > be much easier to handle with such a global file pointing to > your various files. > You can even index that one with shptree too. > But it can be hard to manage when your data gets updated... > > My 2 cents, > > Guillaume > >

Re: [gdal-dev] OCI driver and -lco OVERWRITE=yes

2009-10-13 Thread Rahkonen Jukka
Hi, Peter J Halls wrote: > > Jukka, > > several things here and, I think, they may stem from the > Oracle OCI API, rather than the OGR OCI Driver. > > Firstly, drop table does not remove the index(es): these > have to be dropped explicitly. Really? I made some experiments with SQL*Pl

Re: [gdal-dev] OCI driver and -lco OVERWRITE=yes

2009-10-13 Thread Rahkonen Jukka
Hi, Peter J Halls wrote: > Jukka, > > > Whilst on the topic, are you specifying the SRS/SRID? This > is an area that apparently changed between Oracle 8 & 9 and I > have currently given up on this in OGR because only the > SDO_GEOM_METADATA entry seems to get set and not the table > and ob

Re: [gdal-dev] Is epsg text file read at all when re-projecting with FWTools?

2009-11-18 Thread Rahkonen Jukka
eve I must edit pcs.override.csv. -Jukka- -Alkuperäinen viesti- Lähettäjä: Frank Warmerdam [mailto:warmer...@pobox.com] Lähetetty: ke 18.11.2009 17:15 Vastaanottaja: Rahkonen Jukka Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Is epsg text file read at all when re-projecting wit

Re: [gdal-dev] Why does OCI driver fail with SRID?

2009-11-30 Thread Rahkonen Jukka
Hi Mike, Oh, naturally. I had forgotten that even I seem to have -lco SRID parameter included in all the scripts I have written myself. But how about appendind the data? Using -a_srs does not work and using "-lco SRID=2393" together with "-append" gives a message "WARNING: Layer creation optio

[gdal-dev] Re: CUDA PyCUDA and GDAL

2009-12-07 Thread Rahkonen Jukka
> fws.gov> writes: > > Hi Folks,Here's the gdal command (gdal 1.6.2) I used to merge ~3500 1 meter NAIP > quarter quads (uncompressed geotiff TIFF) in 3 UTM projections into one Bigtiff Image > in the USGS Albers projection. It took about 15 hours ( on a 3 year old Intel Core2 > Duo 64 bit Cent

Re: [gdal-dev] Re: Obtain more information with Ogrinfo

2010-05-10 Thread Rahkonen Jukka
Hi, But -al (without -so, "summary only") is listing all the features of all the layers. It just happens to be that shapefile always has only one layer. Have a try with Mapinfo tab file or some database with lots of tables and you will notice that -al option does go through all the layers.

Re: [gdal-dev] Re: srs definition for wgs84

2010-05-13 Thread Rahkonen Jukka
command. -Jukka- -Alkuperäinen viesti- Lähettäjä: Imran Rajjad [mailto:raj...@gmail.com] Lähetetty: to 13.5.2010 15:44 Vastaanottaja: Rahkonen Jukka Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Re: srs definition for wgs84 Hi, I tried the following command , i guess I`m not

Re: [gdal-dev] Re: srs definition for wgs84

2010-05-13 Thread Rahkonen Jukka
Vastaanottaja: Rahkonen Jukka Kopio: gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] Re: srs definition for wgs84 Jukka, Jukka Rahkonen wrote: > Peter J Halls york.ac.uk> writes: > >> Imran, >> >> the Oracle SRID value of 8192 *is* WGS84. Oracle does not store the >

Re: [gdal-dev] Re: ogr2ogr OCI: problem loading shapes

2010-07-26 Thread Rahkonen Jukka
Hi, http://gdal.org/ogr/drv_oci.html says: Layer Creation Options DIM: This may be set to 2 or 3 to force the dimension of the created layer. If not set 3 is used by default. Have you tried that? -Jukka- Sebastian E. Ovide wrote: On Fri, Jul 23, 2010 at 7:38 PM, Jukka Rahkonen wrote: > Val

[gdal-dev] Re: combine shapefiles?

2010-10-13 Thread Rahkonen Jukka
Hermann Peifer wrote: > On 13/10/2010 09:10, Jukka Rahkonen wrote: > >> However, the .shp part of shapefile can not grow bigger than 4 gigabytes. > Did you ever succeed in creating a, say: 3.9G .shp file? > I do remember that some time ago, I was running into problems around 2G, > which wasn't t

Re: [gdal-dev] WFS and -where with non-ASCII characters

2012-01-03 Thread Rahkonen Jukka
Even Rouault mines-paris.org> writes: > On Windows, there might perhaps be a problem with the shell passing strings in > the local code page (CP1252 or whatever variant of it that is used in > Finland), whereas the WFS server perhaps expect it to be UTF-8. I'm not sure > which encoding we are su

Re: [gdal-dev] Re: WFS and -where with non-ASCII characters

2012-01-03 Thread Rahkonen Jukka
Mateusz Łoskot wrote: > Jukka Rahkonen wrote: > > I took the successful query sent by Ari from the TinyOWS > log and copied it > > literally into Windows and this way it works: > > > > -where name='Hämeenkylä' > > Windows Command Prompt can work with UTF-8 characters if you change > codepage

Re: [gdal-dev] Re: WFS and -where with non-ASCII characters

2012-01-03 Thread Rahkonen Jukka
012 16:44 > Vastaanottaja: Rahkonen Jukka > Kopio: 'gdal-dev@lists.osgeo.org' > Aihe: Re: [gdal-dev] Re: WFS and -where with non-ASCII characters > > Selon Rahkonen Jukka : > > > > > Mateusz Łoskot wrote: > > > > > Jukka Rahkonen wrote: > > >

Re: [gdal-dev] Re: Ogr2ogr, WFS 1.1.0, -spat and gml:Box

2012-01-09 Thread Rahkonen Jukka
Even Rouault wrote: Selon Jukka Rahkonen : > Jukka, > I'm just curious : is there an reason for you to look at what exact requests > the > OGR WFS driver sends to the server ? Does it cause practical problems with a > server I would not have tested against ? If so,

Re: [gdal-dev] Are these WFS issues worth filing tickets?

2012-01-09 Thread Rahkonen Jukka
Even Rouault mines-paris.org> writes: > > Selon Jukka Rahkonen mmmtike.fi>: > > > Hi, > > > > Should I file tickets about these findings: > > > > - It seems to be difficult to send valid attribute queries with GDAL WFS > > driver > > from Windows computers if attribute values contain non-ASCII

Re: [gdal-dev] Are these WFS issues worth filing tickets?

2012-01-09 Thread Rahkonen Jukka
Even Rouault wrote: >> I am speaking as one who is running a WFS server. It does not make me >> happy that users can use MAXFEATURES if the default is that it is not used. >> I have more than 50 featureTypes, several of them containing a few hundred >> thousand features and the biggest one has 1.

Re: [gdal-dev] Re: Are these WFS issues worth filing tickets?

2012-01-10 Thread Rahkonen Jukka
Even Rouault wrote: > Selon Jukka Rahkonen : > > > Even Rouault mines-paris.org> writes: > > > > > > How about having an option -TRUST_GETCAPABILITIES=TRUE > and use it as > > > > a default value? So number of feature could be examined with > > > > resulttype=hits and extents could be taken as

Re: [gdal-dev] Re: Unreliable names for temporary files

2012-02-13 Thread Rahkonen Jukka
Even Rouault wrote: Le lundi 13 février 2012 06:22:31, Jukka Rahkonen a écrit : >> Even Rouault mines-paris.org> writes: >> > Le dimanche 12 février 2012 14:25:07, Jukka Rahkonen a écrit : >> > > Hi, >> > > >> > > I noticed a ticket http://trac.osgeo.org

[gdal-dev] Trouble with georeferenced PDF

2012-03-01 Thread Rahkonen Jukka
53.279989699) ] /Description \ /Neatline Images are available here http://latuviitta.org/documents/GDAL_OGC_32635.pdf http://latuviitta.org/documents/GDAL_OGC_3067.pdf -Jukka Rahkonen- -Jukka Rahkonen-___ gdal-dev mailing list gdal-dev@lists.os

Re: [gdal-dev] Trouble with georeferenced PDF

2012-03-01 Thread Rahkonen Jukka
ar does not find the coordinates. With EPSG:32635 GeoPDF file properties does not show any document tree structure. It is just "Document". With EPSG:3067 it is Document - Page 1 - Map Frame 1. Perhaps there is something that truncates the metadata? -Jukka Rahkonen- Een Rouault wrote: > &

Re: [gdal-dev] Trouble with georeferenced PDF

2012-03-01 Thread Rahkonen Jukka
[even.roua...@mines-paris.org] Lähetetty: 1. maaliskuuta 2012 21:46 Vastaanottaja: Rahkonen Jukka Kopio: 'gdal-dev@lists.osgeo.org' Aihe: Re: [gdal-dev] Trouble with georeferenced PDF Le jeudi 01 mars 2012 11:43:59, Rahkonen Jukka a écrit : > Hi, > > EPSG:3067 works for me too. I mea

Re: [gdal-dev] Re: PDF selective layer sample wanted

2012-03-05 Thread Rahkonen Jukka
Hi, I did mean that with "contains vector graphics" and "zoom in and enjoy". -Jukka- Brent Fraser wrote: > > Cool. Now if we could get it writing vectors... > > Best Regards, > Brent Fraser > > > On 3/5/2012 8:10 AM, Jukka Rahkonen wrote: > > Brent Fraser geoanalytic.com> writes: > > > >>

Re: [gdal-dev] Slow writing into Spatialite with -skipfailures

2012-04-04 Thread Rahkonen Jukka
Even Rouault wrote: >Selon Jukka Rahkonen : >> Hi, >> >> I had to write a million polygon shapefile into Spatialite with -skipfailures >> and I noticed that it was very many times slower that without -skipfailures. >> Is >> there some logical reason for that or could it be due to a bug or someth

Re: [gdal-dev] Adding GMLJP2 metadata into existing JPEG2000 file

2012-04-12 Thread Rahkonen Jukka
Even Rouault wrote: > Le mercredi 11 avril 2012 14:21:09, Jukka Rahkonen a écrit : >> Hi, >> >> Do we have anything that could be used for injecting GMLJP2 georeferencing >> metadata from a text file into an existing JPEG2000 image? I found a tool >> called "JP2 Meta Editor" by a company j2k-codec

Re: [gdal-dev] Performance of reading large polygons with holes

2012-04-21 Thread Rahkonen Jukka
Even Rouault wrote: > Le samedi 21 avril 2012 12:41:49, Jukka Rahkonen a écrit : >> Hi, >> >> Martin Davis started this thread on OpenJUMP-dev list >> http://thread.gmane.org/gmane.comp.gis.jump.devel/9 >> Perhaps someone would like to test how OGR performs with such data? >> Link to dataset i

Re: [gdal-dev] Gdaltindex fails

2012-04-23 Thread Rahkonen Jukka
Even Rouault > Selon Jukka Rahkonen : > > > Hi, > > > > We moved orthophotos to a new file system and after that > gdaltindex became > > very > > unreliable, actually unusable. It may be a coincidence but > old file system > > does > > not exist any more and I cannot verify if problem is reall

Re: [gdal-dev] Re: TiffAppendToStrip errors with uncompressed output [SOLVED]

2012-05-13 Thread Rahkonen Jukka
Even Rouault wrote: >> - In case of uncompressed tiff output, make driver to test beforehand if >> there is enough disk space for the target image > I'm not aware of a portable way of doing that (I haven't searched a lot > though). For the record, I've tried the following trick : seek to the offs

Re: [gdal-dev] How to make VRT offsite areas white?

2012-05-28 Thread Rahkonen Jukka
Even Rouault wrote: > > Selon Jukka Rahkonen : > > > Hi, > > > > I thought this would be easy but it was not. > > > > I have a mosaic of images which do not fill the whole > bounding box of the > > area. > > I made a .VRT file the images and converted the virtual > raster into geotiff. > > No

Re: [gdal-dev] Geospatial PDF with OGR_DATASOURCE

2012-06-04 Thread Rahkonen Jukka
Even Rouault wrote: > > Le samedi 02 juin 2012 12:36:39, Jukka Rahkonen a écrit : > > Hi, > > > > I was reading about a possibility of adding OGR vector > layers on top of > > raster layer in geospatial pdf from http://gdal.org/frmt_pdf.html > > > > Are there any example commands available? I g

Re: [gdal-dev] Geospatial PDF with OGR_DATASOURCE

2012-06-05 Thread Rahkonen Jukka
Even Rouault wrote: > > > > I made some quick trials by combining some raster base maps and > > shapefiles and I am sure that this will be an amusing toy. But > > with the default settings the vector features are almost invisible > > on the map because of the drawing styles. I made a blind > >

Re: [gdal-dev] Geospatial PDF with OGR_DATASOURCE

2012-06-06 Thread Rahkonen Jukka
Even Rouault wrote: > > However, I could not make SYMBOL settings to work with my >> points. They appear as grey circles even if I attached some > > OGR_STYLE strings to them, like >> SYMBOL(c:#00FF00,id:"ogr-sym-7") >> > > I was able to set the colours of the points by using PEN but > > altering

Re: [gdal-dev] Geospatial PDF with OGR_DATASOURCE

2012-06-06 Thread Rahkonen Jukka
Even Rouault wrote: > >> My styled test points are available at >> http://latuviitta.org/documents/styled_pdf_points.gml > The link does not work (the domain name has expired apparently), but I've > successfully tested it with the following GML file : I got the domain name back so the link should

Re: [gdal-dev] Geospatial PDF with OGR_DATASOURCE

2012-06-06 Thread Rahkonen Jukka
Even Rouault wrote: >> >> Data was as shapefile first and I converted it into GML with ogr2ogr. May >> have some little troubles with character encoding (shapefile must have >> been iso-8859-1) but ogrinfo does not look bad for me. > I've downloaded > http://www.gisinternals.com/sdk/Download.aspx

Re: [gdal-dev] Gdaladdo feels slow with Rasterlite

2012-07-05 Thread Rahkonen Jukka
Even Rouault wrote: > Le mercredi 04 juillet 2012 19:27:40, Jukka Rahkonen a écrit : >> Hi, >> >> I feel that gdaladdo is not working optimally with any bigger rasterlite >> tables. For example for my 153600x249600 pixel sized test image the >> initial write into rasterlite took 3 hours and 10 min

Re: [gdal-dev] Gdaladdo feels slow with Rasterlite

2012-07-06 Thread Rahkonen Jukka
Even Rouault wrote: >> One issue there is still. My original was a highly compressed (deflate) >> tiff with a file size of 550 MB. Initial transform into Rasterlite with >> png tiles yielded a 1.2 GB Rasterlite db. Condiderably bigger but still >> understandable. However, gdaladdo has no option

Re: [gdal-dev] Basic OpenStreetMap driver with ReadOSM?

2012-07-07 Thread Rahkonen Jukka
Even Rouault wrote: > Last but not least, is there really an interest for such a driver given all > the existing advanced tools that do similar things : osm2pgsql, osmosis, > etc... ? Osm2pgsql outputs only to PostGIS and even PostGIS is super fine I consider that the threshold in installing and

Re: [gdal-dev] Basic OpenStreetMap driver with ReadOSM?

2012-07-07 Thread Rahkonen Jukka
Even Rouault wrote: >> Parsing relations must be pretty >> difficult, at least with polygons and therefore I was thinking that by >> using the ReadOSM library the responsibility about doing it right could be >> left to ReadOSM developer. > My understanding of the ReadOSM API is that it is "just"

Re: [gdal-dev] Gdaladdo feels slow with Rasterlite

2012-07-07 Thread Rahkonen Jukka
Even Rouault wrote: >> >> Feels pretty good but I have an odd problem with a multitable database. I >> can only create overviews for the table that was written first into the >> database. > Good point. There was indeed an issue with multitable database and overviews. > Fixed in http://trac.osgeo.

Re: [gdal-dev] Rasterlite and external overviews

2012-07-09 Thread Rahkonen Jukka
Even Rouault wrote: >> While trying external overviews I found two troubles. First one is that >> it isimpossible to build external overviews if there has been internal >> overviews in the table. Removing them with "gdaladdo -clean" does not >> help, the message is still: >> ERROR 6: Cannot add ex

Re: [gdal-dev] ogr2ogr and reserved words

2012-07-15 Thread Rahkonen Jukka
Even Rouault wrote: Selon Jukka Rahkonen : >> Ivan Lucena princeton-ma.us> writes: >> >> > >> > Hi there, >> > >> > Is there any trick to avoid creating field names with reserved words? For >> example, a DBF from a shapefile can >> > have field names like "long" and other formats may not like it.

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-19 Thread Rahkonen Jukka
Even Rouault wrote: >> Amenity is included in my osmconf.ini and it can be used inside -sql. >> However, your example gives me this >> >> ERROR 1: 'amenity' not recognised as an available field. >> FAILURE: SetAttributeFilter(amenity='toilets') failed. > Hum, I think I know what's wrong. I see th

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-19 Thread Rahkonen Jukka
Even Rouault wrote: >> Windows 7, 64-bit, SATA disk and 2x3 GHz is converting Finland.osm.pbf in >> about >> 8 minutes for me. But execution time does not increase at all linearly. >> Germany.osm.pbf is about 10 times larger in filesize but ogr2ogr had to work >> about 8 hours with it, thus rough

Re: [gdal-dev] New OGR driver to read OpenStreetMap .osm / .pbf files

2012-07-23 Thread Rahkonen Jukka
Even Rouault wrote: 23. heinäkuuta 2012 13:27 > Le lundi 23 juillet 2012 00:09:05, Jukka Rahkonen a écrit : >> Even Rouault mines-paris.org> writes: >> > > > However, select with SQL feels sub-optimal. >> > > >> > > Yes, when you use ogr2ogr with explicit layer names, there are >> > > optimizatio

Re: [gdal-dev] How to concatenate with newlines by using OGR SQL?

2012-07-31 Thread Rahkonen Jukka
Hi, Sorry, I forgot to tell that I am on Windows. “$’\n’” looks so gurutic that I feel jealous. I hope I will never need to teach anybody to use it at work, though ☺ -Jukka- Chaitanya kumar wrote: Jukka, You can try to pass the newline character directly from the command line. With bash, y

Re: [gdal-dev] How to concatenate with newlines by using OGR SQL?

2012-07-31 Thread Rahkonen Jukka
te that the "More? " part is given by DOS. By giving ^ at the end of line you are saying that there is more stuff to come. If you simply press 'return' when it prompts for more, it will treat it as a newline char and ask for more one more time. DOS treats ^ as a

Re: [gdal-dev] OSM Driver and World Planet file (pbf format)

2012-08-01 Thread Rahkonen Jukka
Even Rouault wrote: > > > > Another set of tests with a brand new and quite powerful laptop. > > Specs for the > > computer: > > Intel i7-2760QM @2.4 GHz processor (8 threads) Hitachi Travelstar > > Z7K320 7200 rpm SATA disk > > 8 GB of memory > > Windows 7, 64-bit > > > > GDAL-version r24717, W

Re: [gdal-dev] OSM Driver and World Planet file (pbf format)

2012-08-01 Thread Rahkonen Jukka
laptop. Who will make a try? -Jukka- Even Rouault wrote: > Selon Rahkonen Jukka : > > Interesting results. I'll wait a bit for your tests with SSD to turn > OSM_COMPRESS_NODES to YES. Even if doesn't bring clear advantages, I > don't think it would hurt a l

Re: [gdal-dev] OSM Driver and World Planet file (pbf format)

2012-08-01 Thread Rahkonen Jukka
Even Rouault wrote: > >> I made a rough parallelizing test by making 4 copies of finland.osm.pbf and >> running ogr2ogr in four separate windows. This way the total CPU load of the >> 8 cores was staying around 50%. >> Result: All four conversions were ready after 3 minutes (45 seconds per >> con

Re: [gdal-dev] 'Polygons as multipolygons' option for OSM driver

2012-08-02 Thread Rahkonen Jukka
Hi, Your plan is very reasonable. It should give correct results in most cases and I think that total solution is not possible before OSM project is able to develop 'the simplest approach that could possibly generate useful polygons' (adapted from http://wiki.openstreetmap.org/wiki/FAQ#Why_are

Re: [gdal-dev] 'Polygons as multipolygons' option for OSM driver

2012-08-13 Thread Rahkonen Jukka
Even Rouault wrote: > > The behaviour of the driver would be that no simple polygons (polygons > > that are described as ways) would be reported until the file has been > > completely processed. > > > > The algorithm would be something like that : > > - store ways in the temporary way DB as curr

Re: [gdal-dev] WFS driver does not do URL-encoding right

2012-08-15 Thread Rahkonen Jukka
Even Rouault wrote: Le mercredi 15 août 2012 21:28:22, Jukka Rahkonen a écrit : >> GvSIG is also sending GetFeatures with http GET and filters and it had same >> kind of problems with special characters. Now the developers say that they >> have fixed URL encoding. I hope that the solution is som

Re: [gdal-dev] WFS driver does not do URL-encoding right

2012-08-15 Thread Rahkonen Jukka
Even Rouault wrote: > Looks a bit complicated. Actually, I'm thinking you could avoid those encoding > problems with using : > ogrinfo "WFS:http://188.64.1.61/cgi-bin/tinyows"; -sql --optfile sql.txt > where sql.txt contains (with a UTF-8 text editor, such as Notepad++ correctly > configured) :

Re: [gdal-dev] WFS driver does not do URL-encoding right

2012-08-16 Thread Rahkonen Jukka
Even Rouault wrote: > Note: yesterday after your emails, I've revised substantially how escaping > was done in the WFS driver, because there were cases where URL-escaping > would have been needed (for example if you passed '&' or '%'), so now for > 'ä', you should see 25-43-33-25-41-34 (but that

Re: [gdal-dev] Gdalinfo slow with big Rasterlite tables

2012-08-19 Thread Rahkonen Jukka
Even Rouault wrote: > Jukka, >> >> Is gdalinfo perhaps walking through every single tile in the >> rasterlite table for gathering the image layer info? Could >> there be any other way to do it in more effective way on the >> GDAL side? > The Rasterlite driver needs to fetch the extent of the "XX

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

2012-08-22 Thread Rahkonen Jukka
Stefano Iacovella wrote: >> I guess that meaning is to check all the metadata rows from the >> ALL_SDO_GEOM_METADATA view which are referring to the queried table. >> There can be several rows created be different Oracle users. Next the >> maximum BBOX is constructed and that is updated into >> U

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

2012-08-22 Thread Rahkonen Jukka
ADATA. There were a > couple of tickets about 2 years ago that implemented thee changes. I'll look > them up and post the tickets. > > Mike > > -- > Michael Smith > > US Army Corps > Remote Sensing GIS/Center > > > > On 8/22/12 7:36 AM, "Rahkon

Re: [gdal-dev] When and why ogrinfo sends update for Oracle?

2012-08-22 Thread Rahkonen Jukka
the tickets. > > Mike > > -- > Michael Smith > > US Army Corps > Remote Sensing GIS/Center > > > > On 8/22/12 7:36 AM, "Rahkonen Jukka" > wrote: > > >Stefano Iacovella wrote: > > > > > >>> I guess that meani

[gdal-dev] About sqlite tileindex and Mapserver

2012-08-24 Thread Rahkonen Jukka
Hi, There is a trick with using Spatialite tileindex with Mapserver. I have no idea anymore how I came to this solution but most probably I was reading something about it from the internet. Try odd trick is that you cannot user Spatialite directly as tileindex but you must first create a LAYER

Re: [gdal-dev] About sqlite tileindex and Mapserver

2012-08-24 Thread Rahkonen Jukka
e for Oracle > (https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes- > with-Dat > abase-RASTERS) > > Mike > > -- > Michael Smith > > US Army Corps > Remote Sensing GIS/Center > > > > On 8/24/12 7:12 AM, "Rahkonen Jukka" > wr

[gdal-dev] Large raster (ecw) identify very long

2012-08-24 Thread Rahkonen Jukka
Hi, Even was missing a proper sample image in ECW format. This one comes originally from the geotorrent.org site which obviously disappeared at the same time than ER Mapper. Anyway, I have been trying to keep the image available. Image is a mosaic made from Landsat landcover scenes (bands 7-4-

Re: [gdal-dev] How to write many raster layers into PDF?

2012-08-30 Thread Rahkonen Jukka
Even Rouault wrote: > There would be some difficulties in implementing a EXTRA_DATASETS option. > Mainly to deal with possible different projections and/or different > georeferenced extents. For example, when inputs are in different > projections and/or have different extent, should they be > re

Re: [gdal-dev] Does -where read always the whole WFS layer?

2012-09-17 Thread Rahkonen Jukka
Even Rouault wrote: >Le lundi 17 septembre 2012 09:44:36, Jukka Rahkonen a écrit : >> Hi, >> >> I compared a few WFS requests with ogr2ogr by filtering either with -where >> or with -sql doing the same select. The -where option was reading the >> whole feature type and filtering the result on the

Re: [gdal-dev] Wanted: -lco DIM for OGR/SQLite driver

2012-09-22 Thread Rahkonen Jukka
Even Rouault wrote: > Le vendredi 21 septembre 2012 17:01:12, Jukka Rahkonen a écrit : >> Hi, > >> OCI and PostgreSQL drivers both have layer creation option for setting >> layer dimensions and it would be nice to have DIM option also in >> Spatialite driver. What I was missing today was a possibi

Re: [gdal-dev] Row count limit in OGR SQL with -dialect=SQLITE

2012-09-24 Thread Rahkonen Jukka
Even Rouault wrote: > Selon Jukka Rahkonen : >> Hi, >> >> The following SQL works fine when using Spatialite as source >> >> osm_data>ogrinfo osm.sqlite -dialect SQLITE -sql "select * from lines >> where highway is not null limit 20" > Note that for a SQLite datasource, -dialect SQLite is useless

Re: [gdal-dev] Gdaltindex with -t_srs and Mapserver

2012-09-27 Thread Rahkonen Jukka
ähettäjä: Etienne Tourigny [mailto:etourigny@gmail.com] > Lähetetty: 27. syyskuuta 2012 15:27 > Vastaanottaja: Rahkonen Jukka > Kopio: gdal-dev@lists.osgeo.org > Aihe: Re: [gdal-dev] Gdaltindex with -t_srs and Mapserver > > Jukka, > > nice that you noticed this new

Re: [gdal-dev] OGR SQL: Excecuting select where column name contains "."

2012-10-05 Thread Rahkonen Jukka
Even Rouault wrote: Selon Jukka Rahkonen : >> > This should definitely work too, but it does not >> > >ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows -sql "select code_reg from >> tows: >> > france" >> > INFO: Open of `WFS:http://188.64.1.61/cgi-bin/tinyows' >> > using driver `WFS' success

Re: [gdal-dev] OGR SQL: Excecuting select where column name contains "."

2012-10-08 Thread Rahkonen Jukka
Even Rouault wrote: >> I can confirm that it is not illegal per se because the following works. I >> hope that the backslashes and everything go through properly. > >> ogrinfo WFS:http://188.64.1.61/cgi-bin/tinyows >> -sql "select \"nom.dept\" from \"tows:dot.test\"" > >> It is an open WFS server

Re: [gdal-dev] Hide OGR_STYLE from PDF attributes

2012-11-12 Thread Rahkonen Jukka
Even Rouault wrote: > Le lundi 12 novembre 2012 11:51:10, Jukka Rahkonen a écrit : >> Hi, >> >> If I write some vector data from OGR_DATASOURCE into geospatial PDF and I >> would like to style symbols with OGR_STYLE, then ORG_STYLE string will >> also be written ínto the model tree of the resultin

Re: [gdal-dev] Space in PDF option OGR_DISPLAY_LAYER_NAMES

2012-11-28 Thread Rahkonen Jukka
Even Rouault wrote: > > Le mardi 27 novembre 2012 09:28:06, Jukka Rahkonen a écrit : > > Even Rouault mines-paris.org> writes: > > > There was indeed something wrong in the way the layer name was > > > written for the model tree, which caused invalid PDF structure to be > > > generated when there

Re: [gdal-dev] Is using geometry in SQL inside VRT supported?

2013-05-24 Thread Rahkonen Jukka
Hi Frank, Great, and I guess that this syntax example about how to select the dialect will be added to the driver manual page http://www.gdal.org/ogr/drv_vrt.html in your documentation sprint of FOSS4G NA. -Jukka- Frank Warmerdam wrote: Jukka, It turns out

Re: [gdal-dev] Ogr2ogr with -dialect and VRT

2013-05-26 Thread Rahkonen Jukka
Even Rouault wrote: > Le vendredi 24 mai 2013 23:52:43, Jukka Rahkonen a écrit : >> Hi, >> >> The -dialect parameter in ogr2ogr does not have an effect when using VRT as >> datasource but could it be made to inject the selected dialect into SrcSQL >> element of the VRT? Thus >> ogr2ogr -dialect SQ

Re: [gdal-dev] Slow convertion from OSM to PG with -skipfailures

2013-05-27 Thread Rahkonen Jukka
Even Rouault wrote: > Selon Jukka Rahkonen : >> Hi, >> >> I have measured a huge speed difference by running the same conversion from >> OSM data file into PostGIS either with or without using the -skipfailures >> parameter. >> >> Without -skipfailures conversion takes about two minutes but if I

Re: [gdal-dev] Slow convertion from OSM to PG with -skipfailures

2013-05-27 Thread Rahkonen Jukka
Even Rouault wrote: > >> Don't you feel that the price is rather high? In this example like 120 >> minutes vs. 2 minutes. Could you imagine a Speedy Sanitizer (TM) option >> which would use a small super fast in-memory container for collecting >> something like one thousand valid features before f

Re: [gdal-dev] Source SRS not honoured if shapefile .prj file exists

2013-06-07 Thread Rahkonen Jukka
Even Rouault wrote: > Selon Jukka Rahkonen : > > > Hi, > > > > I received a shapefile with a non-perfect .prj file which does not > > advertise that the coordinate system is Finnish KKJ (EPSG:2393) which > > needs +towgs84 parameters. I knew that GDAL 1.10 finally comes with > > correct parameter

Re: [gdal-dev] Motion: adopt GDAL 3.5.0RC4 as final 3.5.0 release

2022-05-11 Thread Rahkonen Jukka
+1 -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: gdal-dev Puolesta Even Rouault Lähetetty: keskiviikko 11. toukokuuta 2022 12.36 Vastaanottaja: gdal-dev@lists.osgeo.org Aihe: [gdal-dev] Motion: adopt GDAL 3.5.0RC4 as final 3.5.0 release Hi, Things should be good enough with RC4. M

Re: [gdal-dev] OSM extract: Too many different keys in file

2022-05-13 Thread Rahkonen Jukka
Hi, The error comes from https://github.com/OSGeo/gdal/blob/master/ogr/ogrsf_frmts/osm/ogrosmdatasource.cpp#L2067 and it happens before your SQL, when GDAL is reading the data in from the huge planet.pbf file. if( nNextKeyIndex >= 32768 ) /* somewhat arbitrary */ The error means that there ar

Re: [gdal-dev] OSM extract: Too many different keys in file

2022-05-13 Thread Rahkonen Jukka
request. Any opinions? Tobias Schmetzer Von: Rahkonen Jukka [mailto:jukka.rahko...@maanmittauslaitos.fi] Gesendet: Freitag, 13. Mai 2022 10:58 An: Schmetzer, Tobias mailto:tobias.schmet...@zae-bayern.de>>; gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> Betreff: Re:

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-27 Thread Rahkonen Jukka
Hi, If the problem is that PG_USE_COPY is applied only to the first layer of the multi-table GeoPackage then I would make a test by writing a separate ogr2ogr command for each layer. -Jukka Rahkonen- Lähettäjä: gdal-dev Puolesta Alexandre Gacon Lähetetty: maanantai 23. toukokuuta 2022 17.39 V

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
Hi, Do not use "-dialect sqlite" if you play with PostgreSQL but let GDAL to use the native PG SQL dialect. -Jukka Rahkonen- Lähettäjä: gdal-dev Puolesta Andreas Oxenstierna Lähetetty: torstai 9. kesäkuuta 2022 9.50 Vastaanottaja: gdal-dev@lists.osgeo.org Aihe: [gdal-dev] ogrinfo UPDATE perfo

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
Hi again, It might be good to know how the SQLite dialect works. When it is used for other datasources than natively SQLite based ones then GDAL creates a virtual table into a SQLite database with a VirtualOGR system. There is some information about that in https://www.gaia-gis.it/fossil/libsp

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
ialect for you? Have you tested the SQL with psql? -Jukka Rahkonen- Lähettäjä: Jan Heckman Lähetetty: torstai 9. kesäkuuta 2022 11.17 Vastaanottaja: Rahkonen Jukka Kopio: Andreas Oxenstierna ; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogrinfo UPDATE performance request Afaik as I know, sl

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
ai 9. kesäkuuta 2022 12.02 Vastaanottaja: gdal-dev@lists.osgeo.org; Rahkonen Jukka Aihe: Re: ogrinfo UPDATE performance request Hi AFAIK, UPDATE only works with ogrinfo and the sqlite dialect. We have not tested the native PG SQL dialect extensively though, it took some time to find the correct s

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
. -Jukka Rahkonen- Lähettäjä: Andreas Oxenstierna Lähetetty: torstai 9. kesäkuuta 2022 12.48 Vastaanottaja: gdal-dev@lists.osgeo.org; Rahkonen Jukka Aihe: Re: ogrinfo UPDATE performance request Hi Thanks a lot and sorry for the noise. UPDATE do work as expected using the OGR SQL, i.e. one atomi

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
kesäkuuta 2022 13.02 Vastaanottaja: Rahkonen Jukka Kopio: Andreas Oxenstierna ; gdal-dev@lists.osgeo.org Aihe: Re: [gdal-dev] ogrinfo UPDATE performance request Hi Jukka, Not entirely sure what you mean by 'have you tested the sql with psql', since this is an ogr2ogr process which works. I

Re: [gdal-dev] ogrinfo UPDATE performance request

2022-06-09 Thread Rahkonen Jukka
Analysis-Polygon overlay-(use the same layer as input A and input B). I guess that OpenJUMP will fail with millions of polygons because it runs the processes totally in memory. -Jukka Rahkonen- Lähettäjä: Jan Heckman Lähetetty: torstai 9. kesäkuuta 2022 14.03 Vastaanottaja: Rahkonen Jukka Kopio

Re: [gdal-dev] Motion: adopt RFC 86 Column-oriented read API for vector layers

2022-06-10 Thread Rahkonen Jukka
+1 -Jukka Rahkonen- -Alkuperäinen viesti- Lähettäjä: gdal-dev Puolesta Even Rouault Lähetetty: perjantai 10. kesäkuuta 2022 12.24 Vastaanottaja: gdal-dev@lists.osgeo.org Aihe: [gdal-dev] Motion: adopt RFC 86 Column-oriented read API for vector layers Hi, As the discussion seems to have

Re: [gdal-dev] Possibility to use config options in VRT-files

2022-06-13 Thread Rahkonen Jukka
Hi, Do you need to use just the OGR virtual format https://gdal.org/drivers/vector/vrt.html? The simple WFS service description file https://gdal.org/drivers/vector/wfs.html seems to support an additional PagingAllowed element as immediate children of the OGRWFSDataSource for that purpose. -J

Re: [gdal-dev] Possibility to use config options in VRT-files

2022-06-14 Thread Rahkonen Jukka
ile. If it works then it would be possible to set also GML_ATTRIBUTES_TO_OGR_FIELDS. -Jukka Rahkonen- Lähettäjä: Pekka Sarkola Lähetetty: tiistai 14. kesäkuuta 2022 16.20 Vastaanottaja: Even Rouault Kopio: Pekka Sarkola ; Rahkonen Jukka ; 'gdal-dev@lists.osgeo.org' (gdal-dev@lis

Re: [gdal-dev] gdalwarp Resampling Input Raster Nodata Setting

2022-06-26 Thread Rahkonen Jukka
Hi, The right syntax is average -srcnodata 32767 but you should not need to use it at all because GDAL recognizes nodata from your input automatically as you can see from the gdalinfo report. Could you clip and share a small sample from your source data so that some nodata is included? You can

Re: [gdal-dev] gdalwarp Resampling Input Raster Nodata Setting

2022-06-27 Thread Rahkonen Jukka
2022 10.50 Vastaanottaja: Rahkonen Jukka Aihe: Re: [gdal-dev] gdalwarp Resampling Input Raster Nodata Setting Dear Ms./Mr. Jukka Thank you for your reply. I try to delete the -srcnodata 32767, but it still doesn't work. I have attach a part of raster, in this email. Thanks for your hel

Re: [gdal-dev] gdalwarp Resampling Input Raster Nodata Setting

2022-06-27 Thread Rahkonen Jukka
be that at some moment the image has been compressed with JPEG or some other lossy method? -Jukka Rahkonen- Lähettäjä: Chao Li Lähetetty: maanantai 27. kesäkuuta 2022 11.29 Vastaanottaja: Rahkonen Jukka Aihe: Re: [gdal-dev] gdalwarp Resampling Input Raster Nodata Setting Hi, Now, seemingly, it

  1   2   3   4   5   6   7   8   >