[postgis-users] NoDataValue

[Pierre Racine]

You have to load with -C if you want the table to be listed properly in raster_columns.

http://postgis.refractions.net/documentation/manual-svn/using_raster.xml.html#RT_Loading_Rasters

Pierre

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Paolo Cavallini
> Sent: Wednesday, May 30, 2012 6:32 AM
> To: PostGIS Users Discussion
> Subject: [postgis-users] NoDataValue
> 
> Hi all.
> If I
> SELECT nodata_values
> from raster_columns
> where r_table_name='basin_toscana';
> 
>  nodata_values
> ---------------
> 
> (1 riga)
> 
> then
> 
> UPDATE basin_toscana
> SET rast = ST_SetBandNoDataValue(rast,1, 65535);
> 
> why I still get:
> 
> SELECT nodata_values
> from raster_columns
> where r_table_name='basin_toscana';
> 
>  nodata_values
> ---------------
> 
> (1 riga)
> ?
> 
> Also, I get:
> 
> SELECT srid from raster_columns where r_table_name='basin_toscana';
>  srid
> ------
>     0
> (1 riga)
> 
> in spite of having imported with
> 
> raster2pgsql -s 3003 -I -M basin_toscana.tif > basin.sql
> 
> Thanks for any hint.
> All the best.
> --
> Paolo Cavallini - Faunalia
> www.faunalia.eu
> Full contact details at www.faunalia.eu/pc
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users