[postgis-users] problem with raster2pgsql

[Bborie Park]

Cheryl,

I took a look at your adjusted images and they fine by me.  I loaded
the PNG files into PostGIS Raster and ran an ST_Histogram on the
aspect image to see if the data is there.

I called raster2pgsql with the following...

raster2pgsql -t 50x50 -I -C -Y Aspect.png aspect > aspect.sql

My bet is that there is something wrong with QGIS, which uses GDAL to
access PostGIS raster.  There is another email thread related to
PostGIS raster access using GDAL and problems arising from that.

-bborie

On Thu, Mar 8, 2012 at 3:07 AM, cheryl buckley <cheryl.bckl at gmail.com> wrote:
> Hi bborie and Pierre,
>
> I am not too sure if what I did was a hundred percent correct. I was
> thinking perhaps I am suppose to make a setting in QGIS to obtain a
> corrected image, and not alter the "-t 100x100" in the raster2pgsql
> command line, i'm not too sure. But, non-the-less find attached zip
> folders (screenshots) of my images I generated. The first set is the
> faulty images with the "-t 100x100" and the second set is the images
> generated with a "-t 300x300".  Please note that the hillshade image
> in this case also came out faulty. I also made screenshots of the
> histograms of the images. Perhaps this will now shed some light.
> Please do confirm if you were able to unzip the images and view them.
>
> Regards
>
>
>
>
>
> On Thu, Mar 8, 2012 at 10:14 AM, Pierre Racine
> <Pierre.Racine at sbf.ulaval.ca> wrote:
>>> Yes.  All tiles of a raster will have the same dimensions.  So an edge tile would
>>> have the same dimensions as every other tile, just that some of the tiles have no
>>> data.
>>
>> Probably no link with the bug being discussed but I'm curious. What happen when the raster do not have a nodata value defined and you have to pad some tiles?
>>
>> Pierre
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> --
> Greetings
> Cheryl
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu