Changes between Version 89 and Version 90 of WKTRaster/SpecificationWorking03

Timestamp:

May 26, 2011, 12:11:37 PM (13 years ago)

Author:

Bborie Park

Comment:

ST_ValueCount

WKTRaster/SpecificationWorking03

@@ -870 +870 @@
 
 '''ST_Area(raster|geometry) -> double'''[[BR]]
-'''ST_Count(raster, value) -> integer'''[[BR]]
+
+----
+
+'''ST_ValueCount(raster, value) -> integer'''[[BR]]
+
+ST_ValueCount provides the ability to count the number of times that a user-provided value is present in a raster. To handle floating point values, a rounding argument is provided.
+
+A set of functions for one or more search values:
+
+''If NULL is passed for "searchvalues" to any of the ST_ValueCount variations with "searchvalues", the function returns the counts for all unique values''
+
+1. ST_ValueCount(rast raster, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    returns the number of times that each value in searchvalues is present in the raster
+
+    hasnodata: if FALSE, nodata values in band are considered in the count. if TRUE, nodata values are not considered
+
+    searchvalues: the set of values to count in the raster
+
+    roundto: the decimal position to round a pixel value to. Originally intended for use with 32BF and 64BF pixel types, it can also be used with integers when round to the tens, hundreds or higher place.
+
+        examples are...
+
+{{{
+        roundto < 0: no rounding
+
+        0: no rounding
+
+        0.1: round to the tenths place
+
+        0.01: round to the hundredths place
+
+        0.001: round to the thousandths place
+
+        1: round to the ones place
+
+        10: round to the tens place
+
+        100: round to the hundreds place
+}}}
+
+{{{
+ST_ValueCount(rast, 1, TRUE, ARRAY[23], 0)
+
+ST_ValueCount(rast, 5, FALSE, ARRAY[3.14], 0.01)
+
+ST_ValueCount(rast, 2, TRUE, ARRAY[100], 100)
+
+ST_ValueCount(rast, 1, FALSE, ARRAY[-9999, 0], 1)
+
+ST_ValueCount(rast, 1, FALSE, NULL::double precision[], 1)
+}}}
+
+2. ST_ValueCount(rast raster, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount(rast, 5, ARRAY[3.14], 0.01)
+
+ST_ValueCount(rast, 2, NULL::double precision[], 100)
+}}}
+
+3. ST_ValueCount(rast raster, nband integer, searchvalues double precision[]) -> setof record (searchvalue, count)
+
+    roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount(rast, 1, ARRAY[-9999])
+
+ST_ValueCount(rast, 1, NULL::double precision[])
+}}}
+
+4. ST_ValueCount(rast raster, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    nband is assumed to be 1. hasnodata is assumed to be TRUE.
+
+5. ST_ValueCount(rast raster, searchvalues double precision[]) -> setof record (searchvalue, count)
+
+    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
+
+A set of functions for a single search value:
+
+1. ST_ValueCount(rast raster, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> integer
+
+    returns the number of times that searchvalue is present in the raster
+
+    searchvalue: the value to count in the raster
+
+{{{
+ST_ValueCount(rast, 1, TRUE, 23, 0)
+
+ST_ValueCount(rast, 5, FALSE, 3.14, 0.01)
+
+ST_ValueCount(rast, 2, TRUE, 100, 100)
+
+ST_ValueCount(rast, 1, FALSE, -9999, 1)
+}}}
+
+2. ST_ValueCount(rast raster, nband integer, searchvalue double precision, roundto double precision) -> integer
+
+    hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount(rast, 5, 3.14, 0.01)
+
+ST_ValueCount(rast, 2, 100, 100)
+}}}
+
+3. ST_ValueCount(rast raster, nband integer, searchvalue double precision) -> integer
+
+    roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount(rast, 1, -9999)
+}}}
+
+4. ST_ValueCount(rast raster, searchvalue double precision, roundto double precision) -> integer
+
+    nband is assumed to be 1. hasnodata is assumed to be TRUE.
+
+5. ST_ValueCount(rast raster, searchvalue double precision) -> integer
+
+    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
+
+The set of functions for processing coverages return "bigint" instead of "integer".
+
+A set of functions for one or more search values:
+
+1. ST_ValueCount(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    rastertable: name of the table with a raster column
+
+    rastercolumn: name of the raster column
+
+{{{
+ST_ValueCount('test', 'rast', 1, TRUE, ARRAY[23], 0)
+
+ST_ValueCount('test', 'rast', 5, FALSE, ARRAY[3.14], 0.01)
+
+ST_ValueCount('test', 'rast', 2, TRUE, ARRAY[100], 100)
+
+ST_ValueCount('test', 'rast', 1, FALSE, ARRAY[-9999, 0], 1)
+
+ST_ValueCount('test', 'rast', 1, FALSE, NULL::double precision[], 1)
+}}}
+
+2. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount('test', 'rast', 5, ARRAY[3.14], 0.01)
+
+ST_ValueCount('test', 'rast', 2, NULL::double precision[], 100)
+}}}
+
+3. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[]) -> setof record (searchvalue, count)
+
+    roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount('test', 'rast', 1, ARRAY[-9999])
+
+ST_ValueCount('test', 'rast', 1, NULL::double precision[])
+}}}
+
+4. ST_ValueCount(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
+
+    nband is assumed to be 1. hasnodata is assumed to be TRUE.
+
+5. ST_ValueCount(rastertable text, rastercolumn text, searchvalues double precision[]) -> setof record (searchvalue, count)
+
+    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
+
+A set of functions for a single search value:
+
+1. ST_ValueCount(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> bigint
+
+    returns the number of times that searchvalue is present in the raster
+
+    searchvalue: the value to count in the raster
+
+{{{
+ST_ValueCount('test', 'rast', 1, TRUE, 23, 0)
+
+ST_ValueCount('test', 'rast', 5, FALSE, 3.14, 0.01)
+
+ST_ValueCount('test', 'rast', 2, TRUE, 100, 100)
+
+ST_ValueCount('test', 'rast', 1, FALSE, -9999, 1)
+}}}
+
+2. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision) -> bigint
+
+    hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount('test', 'rast', 5, 3.14, 0.01)
+
+ST_ValueCount('test', 'rast', 2, 100, 100)
+}}}
+
+3. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalue double precision) -> bigint
+
+    roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
+
+{{{
+ST_ValueCount('test', 'rast', 1, -9999)
+}}}
+
+4. ST_ValueCount(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision) -> bigint
+
+    nband is assumed to be 1. hasnodata is assumed to be TRUE.
+
+5. ST_ValueCount(rastertable text, rastercolumn text, searchvalue double precision) -> bigint
+
+    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
+
+----
 
 '''ST_Resample(raster, method, originx, originy, pixelsizex, pixelsizey) -> raster'''