Re: [Qgis-user] Re: Rasterlite layer is just a black box
Hi. Thank you jratike80. jratike80 make new ticket at osgeo4w. http://trac.osgeo.org/osgeo4w/ticket/275 (2012/03/09 17:19), Zirneklitis wrote: Something wrong with Windows binaries. On Windows XP the latest QGIS (OSGeo4Win 1.7.4/1.9.90) do not recognize the given example as (raster) map :( No Problems on Linux (Fedora 14 x 64 / QGis Master). K. ASAHI Kosuke wrote: .. How about use Layer→Add Raster Layer on qgis main menu? (2012/03/09 16:36), Ramon Andiñach wrote: Jukka's file is not working in 1.7.4 or 1.9.90 (osgeo) on my win7 box, even with the updated dll. .. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite -- ASAHI Kosuke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Rasterlite layer is just a black box
ASAHI Kosuke writes: > > Hi Jukka. > > My QGIS in WinXP work fine with rasterlite., but i need update sqlite3.dll. > Please try download latest dll, and copy to OSGeo4w\bin. > http://www.sqlite.org/download.html Thank you, that helped. I changed the original sqlite3.dll (372 kilobytes, 2008-02-06) with the one I had in GDAL directory created with the gisinternals installer (465 kB, 2010-10-24) and that was used for creating the rasterlite db. I will make OSGeo4W ticket is I have rights for that. Before the update I tried to create overviews with QGIs for another rasterlite test 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
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Il 08/03/2012 20:49, Jukka Rahkonen ha scritto: > You mean my test database? As I wrote, it is here > http://latuviitta.org/documents/herttoniemi.sqlite Confirmed, on Debian it loads fast and shows fine. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Big black box. I take it that's how I was supposed to open it? -ramon. On 09/03/2012, at 15:48, ASAHI Kosuke wrote: > Hi ramon. > > How about use Layer→Add Raster Layer on qgis main menu? > > (2012/03/09 16:36), Ramon Andiñach wrote: >> Jukka's file is not working in 1.7.4 or 1.9.90 (osgeo) on my win7 box, even >> with the updated dll. >> >> I've loaded it through the DB manager. Using Layer->Add Spatialite Layer not >> working for me as it doesn't think there's any spatial layers (This could be >> driver error, I don't usually use SQL sources), but dragging the raster >> layer in I can see that there *is* information in the layer, but not in the >> raster field. >> >> -ramon. >> >> P.S. What's a BLOB. >> >> On 09/03/2012, at 9:09, ASAHI Kosuke wrote: >> >>> Hi Jukka. >>> >>> My QGIS in WinXP work fine with rasterlite., but i need update sqlite3.dll. >>> Please try download latest dll, and copy to OSGeo4w\bin. >>> http://www.sqlite.org/download.html >>> >>> (2012/03/09 4:49), Jukka Rahkonen wrote: Paolo 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 it shows just fine. I'm using qgis-master on Ubuntu 11.10 64 bit. > > Just tested loading it from the browser, it works well. > Perhaps you can share a sample so we can test? > All the best. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool reports pixel values (0,0,0) all over the image area. QGis version is QGIS version 1.9.90-Alpha QGIS code revision f61988e Compiled against Qt 4.7.1 Running against Qt 4.7.1 GDAL/OGR Version 1.8.1 GEOS Version 3.2.2 PostgreSQL Client Version 8.3.10 SpatiaLite Version 2.4.0 QWT Version 5.2.1 This copy of QGIS writes debugging output. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user >>> >>> -- >>> ASAHI Kosuke >>> >>> ___ >>> Qgis-user mailing list >>> Qgis-user@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/qgis-user >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > > -- > ASAHI Kosuke > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
BLOB - binary large object Ramon Andiñach wrote: .. P.S. What's a BLOB. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Something wrong with Windows binaries. On Windows XP the latest QGIS (OSGeo4Win 1.7.4/1.9.90) do not recognize the given example as (raster) map :( No Problems on Linux (Fedora 14 x 64 / QGis Master). K. ASAHI Kosuke wrote: .. How about use Layer→Add Raster Layer on qgis main menu? (2012/03/09 16:36), Ramon Andiñach wrote: Jukka's file is not working in 1.7.4 or 1.9.90 (osgeo) on my win7 box, even with the updated dll. .. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite .. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Hi ramon. How about use Layer→Add Raster Layer on qgis main menu? (2012/03/09 16:36), Ramon Andiñach wrote: Jukka's file is not working in 1.7.4 or 1.9.90 (osgeo) on my win7 box, even with the updated dll. I've loaded it through the DB manager. Using Layer->Add Spatialite Layer not working for me as it doesn't think there's any spatial layers (This could be driver error, I don't usually use SQL sources), but dragging the raster layer in I can see that there *is* information in the layer, but not in the raster field. -ramon. P.S. What's a BLOB. On 09/03/2012, at 9:09, ASAHI Kosuke wrote: Hi Jukka. My QGIS in WinXP work fine with rasterlite., but i need update sqlite3.dll. Please try download latest dll, and copy to OSGeo4w\bin. http://www.sqlite.org/download.html (2012/03/09 4:49), Jukka Rahkonen wrote: Paolo 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 it shows just fine. I'm using qgis-master on Ubuntu 11.10 64 bit. Just tested loading it from the browser, it works well. Perhaps you can share a sample so we can test? All the best. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool reports pixel values (0,0,0) all over the image area. QGis version is QGIS version 1.9.90-Alpha QGIS code revision f61988e Compiled against Qt 4.7.1 Running against Qt 4.7.1 GDAL/OGR Version 1.8.1 GEOS Version 3.2.2 PostgreSQL Client Version 8.3.10 SpatiaLite Version 2.4.0 QWT Version 5.2.1 This copy of QGIS writes debugging output. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- ASAHI Kosuke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- ASAHI Kosuke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Jukka's file is not working in 1.7.4 or 1.9.90 (osgeo) on my win7 box, even with the updated dll. I've loaded it through the DB manager. Using Layer->Add Spatialite Layer not working for me as it doesn't think there's any spatial layers (This could be driver error, I don't usually use SQL sources), but dragging the raster layer in I can see that there *is* information in the layer, but not in the raster field. -ramon. P.S. What's a BLOB. On 09/03/2012, at 9:09, ASAHI Kosuke wrote: > Hi Jukka. > > My QGIS in WinXP work fine with rasterlite., but i need update sqlite3.dll. > Please try download latest dll, and copy to OSGeo4w\bin. > http://www.sqlite.org/download.html > > (2012/03/09 4:49), Jukka Rahkonen wrote: >> Paolo 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 it shows just fine. I'm using qgis-master on Ubuntu 11.10 64 bit. >>> >>> Just tested loading it from the browser, it works well. >>> Perhaps you can share a sample so we can test? >>> All the best. >> >> You mean my test database? As I wrote, it is here >> http://latuviitta.org/documents/herttoniemi.sqlite >> >> I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool >> reports pixel values (0,0,0) all over the image area. QGis version is >> >> >> QGIS version >> 1.9.90-Alpha >> QGIS code revision >> f61988e >> Compiled against Qt >> 4.7.1 >> Running against Qt >> 4.7.1 >> GDAL/OGR Version >> 1.8.1 >> GEOS Version >> 3.2.2 >> PostgreSQL Client Version >> 8.3.10 >> SpatiaLite Version >> 2.4.0 >> QWT Version >> 5.2.1 >> This copy of QGIS writes debugging output. >> >> -Jukka Rahkonen- >> >> >> >> ___ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-user >> > > -- > ASAHI Kosuke > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Works as expected. Pixel values are shown. (Fedora 14 x 64 QGIS version 1.9.90-Alpha 927dcbd Qt 4.7.4 GDAL/OGR Version 1.7.3 GEOS Version 3.2.1 SpatiaLite Version 2.4.0 QWT Version 5.2.1) K. Jukka Rahkonen wrote: .. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool reports pixel values (0,0,0) all over the image area. QGis version is .. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Re: Rasterlite layer is just a black box
Hi Jukka. My QGIS in WinXP work fine with rasterlite., but i need update sqlite3.dll. Please try download latest dll, and copy to OSGeo4w\bin. http://www.sqlite.org/download.html (2012/03/09 4:49), Jukka Rahkonen wrote: Paolo 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 it shows just fine. I'm using qgis-master on Ubuntu 11.10 64 bit. Just tested loading it from the browser, it works well. Perhaps you can share a sample so we can test? All the best. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool reports pixel values (0,0,0) all over the image area. QGis version is QGIS version 1.9.90-Alpha QGIS code revision f61988e Compiled against Qt 4.7.1 Running against Qt 4.7.1 GDAL/OGR Version 1.8.1 GEOS Version 3.2.2 PostgreSQL Client Version 8.3.10 SpatiaLite Version 2.4.0 QWT Version 5.2.1 This copy of QGIS writes debugging output. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- ASAHI Kosuke ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Re: Rasterlite layer is just a black box
Paolo 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 it shows just fine. I'm using qgis-master on Ubuntu 11.10 64 bit. > > Just tested loading it from the browser, it works well. > Perhaps you can share a sample so we can test? > All the best. You mean my test database? As I wrote, it is here http://latuviitta.org/documents/herttoniemi.sqlite I am on Windows Vista (32-bit), and QGis is from OSGeo4W. And the info tool reports pixel values (0,0,0) all over the image area. QGis version is QGIS version 1.9.90-Alpha QGIS code revision f61988e Compiled against Qt 4.7.1 Running against Qt 4.7.1 GDAL/OGR Version 1.8.1 GEOS Version 3.2.2 PostgreSQL Client Version 8.3.10 SpatiaLite Version 2.4.0 QWT Version 5.2.1 This copy of QGIS writes debugging output. -Jukka Rahkonen- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user