Changes between Version 104 and Version 105 of WKTRasterTutorial01

Timestamp:

Jan 17, 2011, 12:05:33 PM (13 years ago)

Author:

pracine

Comment:

—

WKTRasterTutorial01

@@ -179 +179 @@
         (ST_DumpAsPolygons(rast)).val
  FROM srtm_tiled
- WHERE rid=3278;
+ WHERE rid=1869;
 }}}
 
@@ -207 +207 @@
          (ST_DumpAsPolygons(ST_SetBandHasNodataValue(rast, FALSE))).val
  FROM srtm_tiled
- WHERE rid=3278;
+ WHERE rid=1869;
+}}}
+
+NOTE: In PostGIS 2.0 the "ST_BandNodataValue(rast)" and "ST_SetBandNodataValue(rast, nodatavalue)" support the NULL value so that the "ST_BandHasNodataValue(rast)" and the "ST_SetBandHasNodataValue(rast, bool)" functions are now respectively replaced by "NOT ST_BandNodataValue(rast) IS NULL" and "ST_SetBandNodataValue(rast, NULL)". The two previous queries in PostGIS 2.0 would be:
+
+{{{
+ SELECT NOT ST_BandNodataValue(rast) IS NULL, ST_BandNodataValue(rast)
+ FROM srtm_tiled
+ LIMIT 1;
+}}}
+
+and
+
+{{{
+SELECT ST_AsBinary(
+         (ST_DumpAsPolygons(ST_SetBandNodataValue(rast, NULL))).geom), 
+         (ST_DumpAsPolygons(ST_SetBandNodataValue(rast, NULL))).val
+ FROM srtm_tiled
+ WHERE rid=1869;
 }}}