Re: [Qgis-user] QGIS problem with GeoPackage database views

2016-06-27 Thread Jukka Rahkonen
spatialite-gui SELECT * FROM "sa1_b01_map_v" order by SA1_MAINCODE_2011 limit 100; Looks good with no duplicates. select * from "sa1_b01_map_v" where SA1_7DIGITCODE_2011=1135752; One row returned. You should give more detailed examples about what you do, what you get,

Re: [Qgis-user] Is QGIS showing the records with geometry NULL

2016-05-26 Thread Jukka Rahkonen
be showed on the map and spatial queries can't find them but they should be found from attribute view and be editable there. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-u

Re: [Qgis-user] CenterLines fom a Polygon?

2015-03-19 Thread Jukka Rahkonen
-in-postgis-python/114623#114623 -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Add WMS in QGIS gives an error with Map request failed [error:Host http not found url:http://http//

2014-11-30 Thread Jukka Rahkonen
. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Add WMS in QGIS gives an error with Map request failed [error:Host http not found url:http://http//

2014-11-30 Thread Jukka Rahkonen
that the most probable reason is a wrong GetMap URL that the service is announcing but unchecking the cross as you already did should help in such case. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman

Re: [Qgis-user] Check geometry validity tools

2014-09-05 Thread Jukka Rahkonen
that should yield A-B-A polygon leads to NULL in Spatialite and to an error with PostGIS. select geomfromtext('POLYGON ((0 0,1 1,0 0))'); -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis

Re: [Qgis-user] zoomtopoint.py

2014-09-02 Thread Jukka Rahkonen
in the question. -Jukka Rahkonen- Best regards, Vincent. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Help with Ordnance Survey SLD's for OS Mastermap

2014-09-01 Thread Jukka Rahkonen
://gist.github.com/tjmgis/6184358. Links in this mail from Geoserver-users may also be useful http://osgeo-org.1560.x6.nabble.com/Release-SLD-s-for-Ordnance-Survey-data-td5157642.html -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http

Re: [Qgis-user] ogr2ogr, osm, and spatialite

2014-08-31 Thread Jukka Rahkonen
. If that does not work try to do import layer by layer and add -sql select * from multipolygons where IsValid(geometry)=1. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] ogr2ogr, osm, and spatialite

2014-08-31 Thread Jukka Rahkonen
Even Rouault even.rouault@... writes: Le dimanche 31 août 2014 21:50:31, Jukka Rahkonen a écrit : Thomas Endres endres.thomas at ... writes: Actually, this warning is just a warning, and not a critical error that will stop conversion. When this occurs, the way/relation will be skipped

Re: [Qgis-user] OpenStreetMap Error

2014-08-31 Thread Jukka Rahkonen
: Add vector layer - Open an OGR supported Vector Layer - path to OpenStreetMap .xml or .pbf file. OSM does not seem to be listed as a supported file format at least in QGIS 2.2 but it works still. The manual page of OSM driver is http://www.gdal.org/drv_osm.html. -Jukka Rahkonen

Re: [Qgis-user] QGIS: Reduction of resolution via pyramids only for defined scale range

2014-06-12 Thread Jukka Rahkonen
Julian Schall j.schall@... writes: Hello members of the mailing list,   I would appreciate help on the following problem: I would like to improve the performance of a raster layer. Of course I can build pyramids for that purpose. But in the scale ranges from 1:1 to 1:25.000 I need

Re: [Qgis-user] cannot save my layer data...???

2014-03-22 Thread Jukka Rahkonen
that at least part of inserts and edits have been actually saved also. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Is there way to print out a layered PDF-document?

2014-03-21 Thread Jukka Rahkonen
plug-incom.isa.jump.plugin.PrintPlugIn/plug-in into FILE menu section SkyPrinter does not have advanced features but it prints the layers as they are in the OpenJUMP into PDF so that it is possible to control the layer visibility in Acrobat reader. SkyPrinter does not make geospatial PDF. -Jukka

Re: [Qgis-user] Symbology Export

2014-03-11 Thread Jukka Rahkonen
/Geospatial_PDF_maps_from_OSM_with_GDAL.pdf There I show how it is possible to use OGR_STYLES with shapefiles and convert the result into a geospatial PDF map. I would rather say that only a few software support styling vector data with OGR_STYLES. -Jukka Rahkonen- ___ Qgis-user mailing list

Re: [Qgis-user] Can some one help me to convert a .bil file in a shape file?

2014-02-19 Thread Jukka Rahkonen
/frmt_gtiff.html -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Spatialite VIEW in QGIS question

2014-02-19 Thread Jukka Rahkonen
contact there. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Wrong scale in .jpegw world file

2014-02-12 Thread Jukka Rahkonen
position but with wrong scale(bigger than supposed). Any suggestions? Thanks You in advance! We need more information. Can you show us - the WMS GetMap request that you have used for capturing the image - corresponding jpegw file - what gdalinfo reports about the image -Jukka Rahkonen- Stipe

Re: [Qgis-user] Saving GPX as SHP looses the time part of the (date)time field

2014-02-05 Thread Jukka Rahkonen
be to make it selectable. For some use cases it could be nice to write the date part into date column and only time part into a separate string column. But if you do not necessarily need just shapefiles a better alternative would be to convert data into Spatialite. -Jukka Rahkonen

Re: [Qgis-user] Transformation using NTv2 grids

2014-02-05 Thread Jukka Rahkonen
accurate_conversion_to_epsg_3067.shp original_epsg_2393.shp Took 2 minutes with a laptop to convert 1.2 million simple polygons. -Jukka Rahkonen-   Greetings,   Stefan Burgstaller   ___ Qgis-user mailing list Qgis-user@... http

Re: [Qgis-user] import osm-file to qgis

2014-02-05 Thread Jukka Rahkonen
. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to buffer a line with different distances for left/right sides

2014-01-29 Thread Jukka Rahkonen
buffer widths and combining those tho with union function could give a desired end result. -Jukka Rahkonen- Goyo ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WFS caching behaviour

2014-01-28 Thread Jukka Rahkonen
Jonathan Moules jonathanmoules@... writes: Hi Jukka,  You do seem to like Fiddler! No, the name of the software is not important but I like to know what really happens and with OGC services it means that one must see the messages which client and server are sending. I was using my web-server

Re: [Qgis-user] WFS caching behaviour

2014-01-27 Thread Jukka Rahkonen
with BBOX filter gets fired. I can't say why QGIS does not send new features for you. But you a the one who should absolutely install Fiddler or some other logging proxy and you can do loads of wonderful bug reports in the future. -Jukka Rahkonen- Thanks,Jonathan This transmission

Re: [Qgis-user] QGIS Georeferencer and Transparency

2014-01-13 Thread Jukka Rahkonen
-dstnodata to some value that does not exist in your data, for example 0 0 255 for total blue. Or then you can add alpha channel with -dstalpha. Unfortunately you can't edit the command and run it as edited directly from the georeferencer but you must run it in a separete GDAL command window. -Jukka

Re: [Qgis-user] Using qcl filter with WMS

2013-12-20 Thread Jukka Rahkonen
that the GetMap that is advertised by the server will not be used. I think that some easy way to add and edit vendor parameters for each WMS layer would be nice to have. It could be used for CQL filter, SLD, SLD_BODY etc. -Jukka Rahkonen- ___ Qgis-user mailing

Re: [Qgis-user] Weekly builds and JP2 files

2013-12-17 Thread Jukka Rahkonen
for JPEG2000 GDAL is using the first on the list. You can skip a driver by setting GDAL_SKIP environment. Thus, if I would like to have a try with JP2OpenJPEG I should run SET GDAL_SKIP=JP2ECW first. No idea really how and where I should do it so that QGIS starts with that setting. -Jukka Rahkonen

[Qgis-user] Georeferencer to create temp file as .VRT

2013-12-15 Thread Jukka Rahkonen
line afterwards but average users probably do not know that. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Four band raster displaying funny

2013-12-02 Thread Jukka Rahkonen
compression and annex for example a screenshot about the settings you have been using for selecting the bands and adjusting histogram stretching etc. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo

Re: [Qgis-user] Four band raster displaying funny

2013-12-02 Thread Jukka Rahkonen
. gdal_merge.py -separate -of GTiff -co photometric=rgb -co compress=jpeg -o fourband_rgb_jpeg.tif 1.tif 2.tif 3.tif 4.tif -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] filter on SELECT DISTINCT

2013-12-01 Thread Jukka Rahkonen
be popolated for example with update labeltest set label_this='true' where rowid in (select max(rowid) as rowid from labeltest group by key) -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Error in Georeferencer

2013-10-25 Thread Jukka Rahkonen
and expected result that you get from envi so someone can repeat. And for comparison everything that is needed to repeat what you did with envi too if someone happens to have that software available. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user

Re: [Qgis-user] Problem with WMS 1.1.1 data providers in QGIS 2.0.1

2013-10-22 Thread Jukka Rahkonen
) or switch off QGIS and use another WMS client like OpenJUMP. For my mind it should be possible to configure QGIS WMS to run in a safe mode and use only those parameters which belong to WMS standard. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user

Re: [Qgis-user] reprojection troubles

2013-10-22 Thread Jukka Rahkonen
) Is there anything I can do about this tolerance condition error? A guess: perhaps those Natural Earth layers contain vertices close to the poles? EPSG:3857 is valid only between -85 - 85 degrees. If that is the case it might to help to cut your vectors a bit at high and low latitudes. -Jukka

Re: [Qgis-user] QGIS 2 and interlis format

2013-10-21 Thread Jukka Rahkonen
/ogr/ogr_formats.html -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS 2.0 and reading OSM through GDAL

2013-09-26 Thread Jukka Rahkonen
with GDAL 1.10 I can myself do this kind of things by writing GDAL .vrt files which would take care of the SQL part but I guess many other users would appreciate to have a wizard. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http

Re: [Qgis-user] QGIS 2.0.1 does not start on 32-bit Vista

2013-09-24 Thread Jukka Rahkonen
been using QGIS 1.9 (QGIS-dev from OSGeo4W installer) successfully on both these computers. Any advice where I could try to find the reason for the failure? -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org

Re: [Qgis-user] QGIS 2.0.1 does not start on 32-bit Vista SOLVED

2013-09-24 Thread Jukka Rahkonen
Jukka Rahkonen jukka.rahkonen@... writes: I removed all Python plugins and all dll plugins and copied them back one be one and I found that the beast is this one: delimitedtextplugin.dll date 2013-07-30 If is in the plugin directoty the result is always a crash but if I remove is then program

[Qgis-user] Rasterlite datasource gets always absolute path

2012-09-04 Thread Jukka Rahkonen
: datasourceRASTERLITE:./rasters.sqlite,table=rastertest/datasource Regards, -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Centre of the roads from polygons to lines

2012-06-04 Thread Jukka Rahkonen
with PostGIS http://ageoguy.blogspot.fi/2010/12/squelettisation.html -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: Qgis first startup is slow

2012-05-24 Thread Jukka Rahkonen
startups - total startup time between 5 and 15 seconds (10 repeats). -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: Add delimited text layer doesn't import all records from CSV file

2012-05-02 Thread Jukka Rahkonen
character is used in field values. You can also have a try with GDAL csv driver http://gdal.org/ogr/drv_csv.html -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: Qgis nightly-build has problems with WMS 1.30

2012-04-18 Thread Jukka Rahkonen
version the server will advertise the highest version that it supports and there can be troubles with the axis order if the version is 1.3. For the WMS users 1.1.1 is just as good as 1.3. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user

[Qgis-user] Re: QGIS + Inkscape

2012-03-19 Thread Jukka Rahkonen
functionalities into QGIS. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Rasterlite db with many raster tables

2012-03-12 Thread Jukka Rahkonen
that. Could it be that QGis does not check the multi-raster table DB as described in http://gdal.org/frmt_rasterlite.html, that is, by doing something similar to gdalinfo RASTERLITE:multirasterdb.sqlite,table=raster1 I tried with GQis 1.9.0 from OS4Geo installation on Windows Vista (32-bit). -Jukka

[Qgis-user] Re: Rasterlite db with many raster tables

2012-03-12 Thread Jukka Rahkonen
Paolo Cavallini cavallini@... writes: Il 12/03/2012 17:43, Jukka Rahkonen ha scritto: Hi, Is QGis supposed to find rasters from rasterlite database which contains several raster tables? I have managed to open all my test maps if I convert them to it should, and it did some times

[Qgis-user] Re: Rasterlite db with many raster tables

2012-03-12 Thread Jukka Rahkonen
. QGis 1.6.0 shows a dialogue for table selection and shows also images once the sqlite3.dll is updated. QGis 1.9.0. from OSGeo4W installer fails immediately after selecting the rasterlite DB. Does anybody have an idea about what to update this time? Sqlite3.dll is already up to date. -Jukka Rahkonen

[Qgis-user] Re: Rasterlite layer is just a black box

2012-03-09 Thread Jukka Rahkonen
file. It failed and made the database unusable also for Spatialite-gui and Spatialite-gis. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Rasterlite layer is just a black box

2012-03-08 Thread Jukka Rahkonen
gdaladdo -r nearest rasterlite:herttoniemi.sqlite,table=herttoniemi 2 4 8 16 32 64 128 File is available for testing from http://latuviitta.org/documents/herttoniemi.sqlite -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http

[Qgis-user] Re: Rasterlite layer is just a black box

2012-03-08 Thread Jukka Rahkonen
Paolo Cavallini cavallini@... writes: Il 08/03/2012 19:45, Giovanni Manghi ha scritto: On Thu, 2012-03-08 at 18:27 +, Jukka Rahkonen wrote: Hi, Somebody had similar issue in January. QGis 1.9.0 opens rasterlite database fine but the image does not show. Hi, here

[Qgis-user] Re: PostGIS database creation wizzard

2012-03-04 Thread Jukka Rahkonen
more data than necessary with the initial import. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: how to georeferenced an autocad .dxf file?

2012-02-29 Thread Jukka Rahkonen
it myself. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: performance comparisons between qgis-mapserver and UMN mapserver?

2012-02-26 Thread Jukka Rahkonen
G. Allegri giohappy@... writes: Has anybody had the occasion to do benchmarks, or informal performance comparisons, between Qgis Mapserver and UMN Mapserver? http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout-2011 -Jukka Rahkonen

[Qgis-user] Re: PyQgis MapServer Export with Mapserver 6.0.1

2012-01-31 Thread Jukka Rahkonen
for correcting it. I do not believe it has worked well since Mapserver 5.2. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: PyQgis MapServer Export with Mapserver 6.0.1

2012-01-31 Thread Jukka Rahkonen
=-369151.98300283286,6597900.0,1511076.628895184,8057331.444759207SRS=EPSG:3067STYLES= Make your service work with the basic setting and only after you have seen it works continue to more challenging use. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user

[Qgis-user] Re: Resetting the extent of a shapefile

2012-01-31 Thread Jukka Rahkonen
= 1.9.0. Thus RECOMPUTE EXTENT ON should help, or then saving the modified data into new shapefile and renaming that back afterwards. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: KML from WFS

2012-01-09 Thread Jukka Rahkonen
wget or curl. - Install for example Fiddler2 proxy between QGis and WFS server so you can see what really happens in the discussion. GDAL 1.9 supports WFS directly as source format and you can use ogr2ogr for converting data from WFS into other vector formats. -Jukka Rahkonen

[Qgis-user] Re: WFS Transactions to GeoServer freeze QGIS

2011-12-12 Thread Jukka Rahkonen
Rahkonen Jukka Jukka.Rahkonen@... writes: Gis Mage gismage at ... writes:   Hi list! I would like to know if anyone has any luck editing wfs layers published with geoserver? Problems are probably caused by this https://jira.codehaus.org/browse/GEOS-4854 -Jukka Rahkonen

[Qgis-user] Re: connecting to GPS

2011-12-08 Thread Jukka Rahkonen
).  Could this be used in QGIS? I have been using QGis and OpenJUMP with a gratis (not open source) GPSGate client http://gpsgate.com/ with Garmin eTrex Vista through USB port on Windows and it has been very reliable. -Jukka Rahkonen- ___ Qgis-user mailing

[Qgis-user] Re: ecw problems

2011-12-08 Thread Jukka Rahkonen
is that JPEG2000 is very complicated format and open source libraries are not yet as good as the best commercial ones. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Re: File-based Mastermap

2011-09-28 Thread Jukka Rahkonen
Andreas Neumann a.neumann@... writes: Perhaps you could also look into SpatiaLite. It comes without the limitations of Shapefiles (column names, file sizes) and is fast and a database without installation (file based). Also you need to copy only one file instead of multiple ones.

[Qgis-user] Re: Trouble with classifying a Spatialite layer

2011-08-31 Thread Jukka Rahkonen
trials. If I read the whole Spatialite table into QGIS the automatic classification works but if the layer is created by using SQL query filter then it does not. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org

[Qgis-user] Re: QGIS WMS GetMap request wtih SLD?

2010-05-24 Thread Jukka Rahkonen
http://sourceforge.net/tracker/?func=detailaid=3005187group_id=118054atid=679909 -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] WMS through https and basic auth

2010-05-09 Thread Jukka Rahkonen
has been usuful for me even with WMS services which are advertising wrong GetMap URL because very often in these cases the GetCapabilities URL works also for GetMap. What do QGis developers think, would this be a useful feature to have also in QGis? -Jukka Rahkonen