[postgis-users] Questions about the right uploading of raster data

[Jorge Arévalo]

On Mon, Oct 17, 2011 at 4:08 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca> wrote:
>> What i get in my database is a new table with the name of my image with no
>> data inside (only "1" in rid serial) and a row at the raster_columns with all data
>> of the uploaded image except the nodata_values.
>
> You should have one "rid" column and one "rast" column. And since you loaded using the -k option you should have many rows in the "katrina" table.
>
> If this is not what you get I would suggest to replace the raster2pgsql.py  -o option with a pipe like this:
>
> raster2pgsql.py -r /path/to/katrina.tif -t katrina -l 1 -k 64x64 -s 4326 -I -M > Katrina.sql
>
> to see more error message.
>
>> I tried to import them with -n but it doesn't work with raster2pgsql.py. I connect to my database with QGIS
>> 1.7.1 through WTKRaster plugin and what i get is no geometry and no data at all
>> in the raster table (as expected) and the raster_columns appears as a polygon
>> with the right coordinates but with no texture inside (only one color polygon).
>
> Before trying to display in QGIS make sure the raster was loaded properly...
>

Which GDAL version are you using? You must use 1.8.x


> Pierre
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Jorge Arévalo
Internet & Mobility Division, DEIMOS
jorge.arevalo at deimos-space.com
http://es.linkedin.com/in/jorgearevalo80
http://mobility.grupodeimos.com/
http://gis4free.wordpress.com
http://geohash.org/ezjqgrgzz0g