<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Piotr,<br>
Well, i'm glad to see that you are able to use the plugin. The GDAL
driver has some performance issues. The solution is use the
overviews and tiling scheme to improved raster display.<br>
<br>
I've just read in the GDAL site that the mosaic inside a table is
not allowed yet. But another workaround is to create a virtual
mosaic using VRT and then import it to the database. This way the
loader treats every file as a single raster and will tile everything
together.<br>
<br>
I hope these solutions help you achieve your goals.<br>
All the best,<br>
Ps.: I'm copying to qgis user since these solutions might be of
interest for other users.<br>
<pre class="moz-signature" cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
<br>
On 04/09/2012 07:41 PM, Piotr Pachół wrote:
<blockquote cite="mid:4F8365AA.3030906@gmail.com" type="cite">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
Hello,<br>
Yes, I would like to load many rasters.<br>
It's for me important because rasters should cover the area of
region or district.<br>
<br>
But I made 2 tests loading to PostGIS one raster and two rasters.<br>
<br>
With one raster your plugin works OK. <br>
Both options 'read one row as a raster' and 'read one table as
raster' <br>
are working good although displaying raster is very time
consuming.<br>
<br>
With two rasters only option 'read one row as a raster' work OK.<br>
I can display each tile from first and second raster.<br>
But option 'read one table as raster' doesn't work.<br>
The message appear: ' could not load PG ...'<br>
<br>
Best,<br>
Piotr<br>
<br>
W dniu 2012-04-07 00:16, Mauricio de Paulo pisze:
<blockquote cite="mid:4F7F6B41.5000405@gmail.com" type="cite">
<meta content="text/html; charset=UTF-8"
http-equiv="Content-Type">
Hi,<br>
You used *.tif on your loading command. Are there more than 1
raster file in that path?<br>
I don't know if GDAL's driver is able to read properly more than
one raster file in a table. The last time i checked it was not
possible, but I still have to catch up with their development.<br>
You could try loading a single raster and check if it works.
That might be the problem.<br>
All the best<br>
<br>
<pre class="moz-signature" cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
<br>
On 04/06/2012 05:54 PM, Piotr Pachół wrote:
<blockquote cite="mid:4F7F5807.9060906@gmail.com" type="cite">
<meta content="text/html; charset=UTF-8"
http-equiv="Content-Type">
Hello,<br>
I loaded raster to PostGIS executing following commands: <br>
<br>
raster2pgsql -s 2180 -I -C -M "my path/*.tif" -F -t 128x128
public.raster128na128 > file1.sql<br>
psql -d raster -f file1.sql<br>
<br>
where:<br>
raster - name of my database<br>
raster128na128 - table in database raster<br>
<br>
loading was OK but as I wrote before I can display only tile
of raster but not all raster extent<br>
Regards,<br>
Piotr<br>
<br>
W dniu 2012-04-06 19:39, Mauricio de Paulo pisze:
<blockquote cite="mid:4F7F2A3F.3030405@gmail.com" type="cite">
<meta content="text/html; charset=UTF-8"
http-equiv="Content-Type">
Hi Piotr,<br>
Could you please give me any information on what parameters
you set while loading the raster file to postgis?<br>
I had to disable the loader for a while since the python
loader was discontinued by postgis. I'm still researching on
how to reactivate it as it is a desired feature.<br>
All the best,<br>
<pre class="moz-signature" cols="72">Mauricio C. M. de Paulo
Engenheiro Cartógrafo
Mestrando em Sensoriamento Remoto (INPE)</pre>
<br>
On 04/06/2012 10:08 AM, Piotr Pachół wrote:
<blockquote cite="mid:4F7EEAD0.6090306@gmail.com"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=UTF-8">
Hello,<br>
Could you please help me with below described problem ?<br>
<br>
Question was sent to qgis-user forum : <a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://lists.osgeo.org/pipermail/qgis-user/2012-April/016499.html">http://lists.osgeo.org/pipermail/qgis-user/2012-April/016499.html</a><br>
but I don't know if you check it so I am mailing directly
to you.<br>
<br>
Regards,<br>
Piotr <br>
<br>
------ Wiadomość oryginalna ------
<table class="moz-email-headers-table" border="0"
cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Temat:
</th>
<td>Load PostGIS Raster Plugin</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Data:
</th>
<td>Wed, 04 Apr 2012 22:32:29 +0200</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Nadawca:
</th>
<td>Piotr Pachół <a moz-do-not-send="true"
class="moz-txt-link-rfc2396E"
href="mailto:piotrpachol@gmail.com"><piotrpachol@gmail.com></a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Adresat:
</th>
<td><a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</a></td>
</tr>
</tbody>
</table>
<br>
<pre>Hello,
I have problems with Load PostGIS Raster Plugin ver. 0.5.3:
1. Icon/function 'Load Raster to PostGIS' is not active. What should I
do to make it active ?
2. In icon/function 'Add a PostGIS Raster' Layer I can't load/view
raster (in full extent) when I use option 'read one table as raster'
The message appear: ' could not load PG ...'
Option 'read one row as a raster' works OK but I can view only one
tile of raster.
May be I used bad options during loading raster files with
raster2pgsql command ?
I loaded raster to PostGIS with following options:
raster2pgsql -s 2180 -I -C -M "my path/*.tif" -F -t 128x128
My configuration:
Windows XP, Qgis 1.9.90-107, PostGIS 2.0
Any ideas?
Piotr
</pre>
</blockquote>
</blockquote>
<br>
</blockquote>
</blockquote>
<br>
</blockquote>
</body>
</html>