Changes between Version 96 and Version 97 of WKTRaster/SpecificationWorking03

Timestamp:

Jun 8, 2011, 4:15:57 PM (13 years ago)

Author:

Bborie Park

Comment:

ST_Histogram for coverage tables

WKTRaster/SpecificationWorking03

@@ -2670 +2670 @@
   right is assumed to be FALSE
 
+The following set of function are for coverages.
+
+1. ST_Histogram(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, bins int default 0, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE) -> set of records
+
+  rastertable: name of table with raster column
+
+  rastercolumn: name of column of data type raster
+
+{{{
+ST_Histogram('tmax_2010', 'rast')
+
+ST_Histogram('precip_2011', 'rast', 1)
+
+ST_Histogram('precip_2011', 'rast', 1, FALSE)
+
+ST_Histogram('precip_2011', 'rast', 1, FALSE, 5)
+
+ST_Histogram('precip_2011', 'rast', 1, FALSE, 10, NULL)
+
+ST_Histogram('precip_2011', 'rast', 1, FALSE, 10, NULL, TRUE)
+}}}
+
+2. ST_Histogram(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, bins int, right boolean) -> set of records
+
+{{{
+ST_Histogram('tmin_2010', 'rast', 2, FALSE, 5, FALSE)
+}}}
+
+3. ST_Histogram(rastertable text, rastercolumn text, nband int, bins int, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE) -> set of records
+
+{{{
+ST_Histogram('ndvi_2010', 'rast', 1, 5)
+
+ST_Histogram('ndvi_2010', 'rast', 1, 0, ARRAY[0.5]::double precision[])
+
+ST_Histogram('ndvi_2010', 'rast', 1, 5, NULL, TRUE)
+}}}
+
+4. ST_Histogram(rastertable text, rastercolumn text, nband int, bins int, right boolean) -> set of records
+
+{{{
+ST_Histogram('veg_2009', 'rast', 2, 3, FALSE)
+
+ST_Histogram('veg_2009', 'rast', 2, 3, TRUE)
+}}}
+
+A set of functions of ST_ApproxHistogram for coverage tables:
+
+1. ST_ApproxHistogram(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, sample_percent double precision DEFAULT 0.1, bins int DEFAULT 0, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE) -> set of records
+
+{{{
+ST_ApproxHistogram('precip_2010', 'rast')
+
+ST_ApproxHistogram('precip_2010', 'rast', 1)
+
+ST_ApproxHistogram('precip_2010', 'rast', 2, FALSE)
+
+ST_ApproxHistogram('precip_2010', 'rast', 1, TRUE, 0.25)
+
+ST_ApproxHistogram('precip_2010', 'rast', 3, FALSE, 0.2, 10)
+
+ST_ApproxHistogram('precip_2010', 'rast', 1, TRUE, 0.1, 0, ARRAY[1]::double precision[])
+
+ST_ApproxHistogram('precip_2010', 'rast', 1, TRUE, 0.1, 0, ARRAY[1]::double precision[], FALSE)
+}}}
+
+2. ST_ApproxHistogram(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision, bins int, right boolean)
+
+3. ST_ApproxHistogram(rastertable text, rastercolumn text, nband int, sample_percent double precision)
+
+4. ST_ApproxHistogram(rastertable text, rastercolumn text, sample_percent double precision)
+
+5. ST_ApproxHistogram(rastertable text, rastercolumn text, nband int, sample_percent double precision, bins int, width double precision[] DEFAULT NULL, right boolean DEFAULT FALSE)
+
+6. ST_ApproxHistogram(rastertable text, rastercolumn text, nband int, sample_percent double precision, bins int, right boolean)
+
 ----
 '''ST_Quantile(raster, nband) -> set of records'''[[BR]]