<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>As I found it out myself, I'll answer in case someone wants to work with that in the future!</span></div><div><br><span></span></div><div><span>The Postgis connection plugin in QGIS cannot add raster data, only shapefiles. In order to load, view and edit rasters in QGIS you have to add wtkraster plugin: http://plugins.qgis.org/plugins/wktraster/version/0.5.3/ and then works fine and easy.<br></span></div><div><br><span></span></div><div><span><br></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Giannis Giakoumidakis <ggiakoumidakis@yahoo.com><br> <b><span
style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@postgis.refractions.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, May 15, 2012 11:05 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Correct or wrong raster image loading<br> </font> </div> <br>
<div id="yiv310429092"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:12pt;"><div><span>All right, I got that, thank you. <br></span></div><div><span><br></span></div><div><span>So is there anyone who uses QGIS plugin to Postgis and managed to display raster data, because I can't and I don't know what's the problem? Which part of the database I have to Add in order to display my rasters in QGIS platform?<br></span></div><div><br><span></span></div><div><br><span></span></div><div><span><br></span></div><div><br></div> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Bborie Park <bkpark@ucdavis.edu><br> <b><span style="font-weight:bold;">To:</span></b>
postgis-users@postgis.refractions.net <br> <b><span style="font-weight:bold;">Sent:</span></b> Monday, May 14, 2012 10:45 PM<br> <b><span style="font-weight:bold;">Subject:</span></b> Re: [postgis-users] Correct or wrong raster image loading<br> </font> </div> <br>
Giannis,<br><br>If your tile size is the same as the raster size, you're only going to<br>get one tile (and one row). Now if you were specify a tile size smaller<br>than the raster size (such as 30x31), you would have 117 tiles (and rows).<br><br>I wouldn't be concerned about not seeing the whole blob in pgAdmin.<br>pgAdmin usually does that for data that is particularly large.<br><br>-bborie<br><br>On 05/14/2012 12:07 PM, Giannis Giakoumidakis wrote:<br>> Thanks for the anwser.<br>> <br>> My raster is 390x279, so I use -t 390x279. I get no errors. I didn't understand from your asnwer, the rows in the table should have been more than 1 that it is now or it is correct like that?<br>> <br>> The .sql I get before I use psql is this, in Notepad++:<br>> <br>> BEGIN;<br>> CREATE TABLE "public"."cc00h00m15s" ("rid" serial PRIMARY KEY,"rast" raster);<br>> INSERT INTO "public"."cc00h00m15s" ("rast") VALUES
('0100000400DDC80B44AA83173FF2C80B44AA8317BF1986D9154421394032D1D677B4AE414000000000000000000000000000000000E6100000860117010400828282828282828282828282.......')::raster;<br>> ANALYZE "public"."cc00h00m15s";<br>> SELECT AddRasterConstraints('public','cc00h00m15s','rast',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE);<br>> END;<br>> <br>> I don't know why in the sql editor of pgAdmin, the: VALUES ('0100000400DDC80B44AA83173FF2C80B44AA8317BF1986D9154421394032D1D677B4AE41400....') are missing.<br>> <br>> <br>> <br>> <br>> <br>> <br>> <br>> ________________________________<br>> From: Bborie Park <<a rel="nofollow" ymailto="mailto:bkpark@ucdavis.edu" target="_blank" href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a>><br>> To: <a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a> <br>> Sent: Monday, May 14, 2012
8:07 PM<br>> Subject: Re: [postgis-users] Correct or wrong raster image loading<br>> <br>> What are the dimensions (width/height) of your raster? I just tested<br>> your raster2pgsql command string...<br>> <br>> raster2pgsql -s 4236 -I -C -M *.tif -F -t 100x100 testtable<br>> <br>> And it has no issues. The generated table will only have 2 or 3 columns<br>> (3 since you specified -F). Each raster column will have one entry in<br>> the raster_columns view.<br>> <br>> You may wan to check the SQL generated from raster2pgsql instead of<br>> piping directly to psql. I'm guessing something went wrong in the<br>> raster loading process. Without additional information (error messages,<br>> if any), we really can't say what is wrong.<br>> <br>> -bborie<br>> <br>> <br>> On 05/14/2012 09:01 AM, Giannis Giakoumidakis wrote:<br>>> I'm not sure if my loading of
raster images is correct. <br>>><br>>> I use "raster2pgsql -s 4236 -I -C -M *.tif -F -t 100x100 public.demelevation | psql -d gisdb" from the manual. What I get is a table that has only 3 columns (rid, rast, filename) and 1 row only (I thought -t would create many rows). Also, 12 constraints. Finally, 1 row in the "raster_columns" view, which contains all the details of the loaded raster. <br>>><br>>><br>>> The difference with a loaded shapefile is that this table has 55.000 rows that contains all the vector data details.<br>>><br>>><br>>> So I have a major problem when I connect to the database through QGIS. There I can load and display normally a shapefile from the database (it appeas with "MULTIPOLYGON" type), but all the tables which contains rasters appear with "no geometry" type and can't be displayed in QGIS. <br>>><br>>><br>>> Can anyone tell me where is my fault, in the QGIS or
in the first loading of the raster images in the database? Thanks.<br>>><br>>><br>>><br>>><br>>> _______________________________________________<br>>> postgis-users mailing list<br>>> <a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> <br>> <br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> <a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a rel="nofollow" target="_blank"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>-- <br>Bborie Park<br>Programmer<br>Center for Vectorborne
Diseases<br>UC Davis<br>530-752-8380<br><a rel="nofollow" ymailto="mailto:bkpark@ucdavis.edu" target="_blank" href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><br>_______________________________________________<br>postgis-users mailing list<br><a rel="nofollow" ymailto="mailto:postgis-users@postgis.refractions.net" target="_blank" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a rel="nofollow" target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br> </div> </div> </div></div></div><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br><br> </div> </div> </div></body></html>