<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Thanks for the anwser.</span></div><div><span><br></span></div><div><span>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?</span></div><div><br><span></span></div><div><span>The .sql I get before I use psql is this, in Notepad++:</span></div><div><br><span></span></div><div><font size="2"><font face="Arial">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;</font></font></div><div><br></div><div>I don't know why in the sql editor of pgAdmin, the: VALUES <font size="2"><font face="Arial">('0100000400DDC80B44AA83173FF2C80B44AA8317BF1986D9154421394032D1D677B4AE41400....') are missing.<br></font></font></div><div><br><span></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 8:07 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Correct or wrong raster image loading<br> </font> </div> <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
ymailto="mailto:postgis-users@postgis.refractions.net" 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>Bborie Park<br>Programmer<br>Center for Vectorborne Diseases<br>UC Davis<br>530-752-8380<br><a ymailto="mailto:bkpark@ucdavis.edu" href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><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>