Changes between Version 93 and Version 94 of WKTRaster/SpecificationWorking03


Ignore:
Timestamp:
May 30, 2011, 8:06:47 AM (13 years ago)
Author:
Bborie Park
Comment:

rename function parameter "hasnodata" to "exclude_nodata_value"

Legend:

Unmodified
Added
Removed
Modified
  • WKTRaster/SpecificationWorking03

    v93 v94  
    855855 
    856856
    857 '''ST_Union(raster|geometry, raster|geometry, ‘raster’|’geometry’) -> raster/geometry'''[[BR]]
    858 '''ST_Accum(raster set|geometry set, ‘raster’|’geometry’) -> raster/geometry'''
     857'''ST_Union(raster|geometry, raster|geometry, ¿raster¿|¿geometry¿) -> raster/geometry'''[[BR]]
     858'''ST_Accum(raster set|geometry set, ¿raster¿|¿geometry¿) -> raster/geometry'''
    859859
    860860
     
    881881''If NULL is passed for "searchvalues" to any of the ST_ValueCount variations with "searchvalues", the function returns the counts for all unique values''
    882882
    883 1. ST_ValueCount(rast raster, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
     8831. ST_ValueCount(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    884884
    885885    returns the number of times that each value in searchvalues is present in the raster
    886886
    887     hasnodata: if FALSE, nodata values in band are considered in the count. if TRUE, nodata values are not considered
     887    exclude_nodata_value: if FALSE, nodata values in band are considered in the count. if TRUE, nodata values are not considered
    888888
    889889    searchvalues: the set of values to count in the raster
     
    9259252. ST_ValueCount(rast raster, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    926926
    927     hasnodata is assumed to be TRUE
     927    exclude_nodata_value is assumed to be TRUE
    928928
    929929{{{
     
    9359353. ST_ValueCount(rast raster, nband integer, searchvalues double precision[]) -> setof record (searchvalue, count)
    936936
    937     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     937    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    938938
    939939{{{
     
    9459454. ST_ValueCount(rast raster, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    946946
    947     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     947    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    948948
    9499495. ST_ValueCount(rast raster, searchvalues double precision[]) -> setof record (searchvalue, count)
    950950
    951     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     951    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    952952
    953953A set of functions for a single search value:
    954954
    955 1. ST_ValueCount(rast raster, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> integer
     9551. ST_ValueCount(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) -> integer
    956956
    957957    returns the number of times that searchvalue is present in the raster
     
    9719712. ST_ValueCount(rast raster, nband integer, searchvalue double precision, roundto double precision) -> integer
    972972
    973     hasnodata is assumed to be TRUE
     973    exclude_nodata_value is assumed to be TRUE
    974974
    975975{{{
     
    9819813. ST_ValueCount(rast raster, nband integer, searchvalue double precision) -> integer
    982982
    983     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     983    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    984984
    985985{{{
     
    9899894. ST_ValueCount(rast raster, searchvalue double precision, roundto double precision) -> integer
    990990
    991     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     991    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    992992
    9939935. ST_ValueCount(rast raster, searchvalue double precision) -> integer
    994994
    995     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     995    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    996996
    997997The set of functions for processing coverages return "bigint" instead of "integer".
     
    999999A set of functions for one or more search values:
    10001000
    1001 1. ST_ValueCount(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
     10011. ST_ValueCount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    10021002
    10031003    rastertable: name of the table with a raster column
     
    101910192. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    10201020
    1021     hasnodata is assumed to be TRUE
     1021    exclude_nodata_value is assumed to be TRUE
    10221022
    10231023{{{
     
    102910293. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[]) -> setof record (searchvalue, count)
    10301030
    1031     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1031    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    10321032
    10331033{{{
     
    103910394. ST_ValueCount(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, count)
    10401040
    1041     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1041    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    10421042
    104310435. ST_ValueCount(rastertable text, rastercolumn text, searchvalues double precision[]) -> setof record (searchvalue, count)
    10441044
    1045     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1045    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    10461046
    10471047A set of functions for a single search value:
    10481048
    1049 1. ST_ValueCount(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> bigint
     10491. ST_ValueCount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) -> bigint
    10501050
    10511051    searchvalue: the value to count in the raster
     
    106310632. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision) -> bigint
    10641064
    1065     hasnodata is assumed to be TRUE
     1065    exclude_nodata_value is assumed to be TRUE
    10661066
    10671067{{{
     
    107310733. ST_ValueCount(rastertable text, rastercolumn text, nband integer, searchvalue double precision) -> bigint
    10741074
    1075     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1075    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    10761076
    10771077{{{
     
    108110814. ST_ValueCount(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision) -> bigint
    10821082
    1083     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1083    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    10841084
    108510855. ST_ValueCount(rastertable text, rastercolumn text, searchvalue double precision) -> bigint
    10861086
    1087     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1087    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    10881088
    10891089----
     
    10971097''If NULL is passed for "searchvalues" to any of the ST_ValuePercent variations with "searchvalues", the function returns the percents for all unique values''
    10981098
    1099 1. ST_ValuePercent(rast raster, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
     10991. ST_ValuePercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    11001100
    11011101    returns the percentage of a raster's band that each value in searchvalues is found
    11021102
    1103     hasnodata: if FALSE, nodata values in band are considered in the percents. if TRUE, nodata values are not considered
     1103    exclude_nodata_value: if FALSE, nodata values in band are considered in the percents. if TRUE, nodata values are not considered
    11041104
    11051105    searchvalues: the set of values to get percents for in the raster
     
    114111412. ST_ValuePercent(rast raster, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    11421142
    1143     hasnodata is assumed to be TRUE
     1143    exclude_nodata_value is assumed to be TRUE
    11441144
    11451145{{{
     
    115111513. ST_ValuePercent(rast raster, nband integer, searchvalues double precision[]) -> setof record (searchvalue, percent)
    11521152
    1153     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1153    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    11541154
    11551155{{{
     
    116111614. ST_ValuePercent(rast raster, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    11621162
    1163     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1163    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    11641164
    116511655. ST_ValuePercent(rast raster, searchvalues double precision[]) -> setof record (searchvalue, percent)
    11661166
    1167     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1167    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    11681168
    11691169A set of functions for a single search value:
    11701170
    1171 1. ST_ValuePercent(rast raster, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> integer
     11711. ST_ValuePercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) -> integer
    11721172
    11731173    searchvalue: the value to get a percent for in the raster
     
    118511852. ST_ValuePercent(rast raster, nband integer, searchvalue double precision, roundto double precision) -> integer
    11861186
    1187     hasnodata is assumed to be TRUE
     1187    exclude_nodata_value is assumed to be TRUE
    11881188
    11891189{{{
     
    119511953. ST_ValuePercent(rast raster, nband integer, searchvalue double precision) -> integer
    11961196
    1197     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1197    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    11981198
    11991199{{{
     
    120312034. ST_ValuePercent(rast raster, searchvalue double precision, roundto double precision) -> integer
    12041204
    1205     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1205    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    12061206
    120712075. ST_ValuePercent(rast raster, searchvalue double precision) -> integer
    12081208
    1209     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1209    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    12101210
    12111211The set of functions for processing coverages return "bigint" instead of "integer".
     
    12131213A set of functions for one or more search values:
    12141214
    1215 1. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
     12151. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    12161216
    12171217    rastertable: name of the table with a raster column
     
    123312332. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    12341234
    1235     hasnodata is assumed to be TRUE
     1235    exclude_nodata_value is assumed to be TRUE
    12361236
    12371237{{{
     
    124312433. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, searchvalues double precision[]) -> setof record (searchvalue, percent)
    12441244
    1245     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1245    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    12461246
    12471247{{{
     
    125312534. ST_ValuePercent(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision) -> setof record (searchvalue, percent)
    12541254
    1255     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1255    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    12561256
    125712575. ST_ValuePercent(rastertable text, rastercolumn text, searchvalues double precision[]) -> setof record (searchvalue, percent)
    12581258
    1259     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1259    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    12601260
    12611261A set of functions for a single search value:
    12621262
    1263 1. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, hasnodata boolean, searchvalue double precision, roundto double precision) -> bigint
     12631. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision) -> bigint
    12641264
    12651265    searchvalue: the value to get a percent for in the raster
     
    127712772. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision) -> bigint
    12781278
    1279     hasnodata is assumed to be TRUE
     1279    exclude_nodata_value is assumed to be TRUE
    12801280
    12811281{{{
     
    128712873. ST_ValuePercent(rastertable text, rastercolumn text, nband integer, searchvalue double precision) -> bigint
    12881288
    1289     roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE
     1289    roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE
    12901290
    12911291{{{
     
    129512954. ST_ValuePercent(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision) -> bigint
    12961296
    1297     nband is assumed to be 1. hasnodata is assumed to be TRUE.
     1297    nband is assumed to be 1. exclude_nodata_value is assumed to be TRUE.
    12981298
    129912995. ST_ValuePercent(rastertable text, rastercolumn text, searchvalue double precision) -> bigint
    13001300
    1301     nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. hasnodata is assumed to be TRUE.
     1301    nband is assumed to be 1. roundto is assumed to be 0, so no rounding takes place. exclude_nodata_value is assumed to be TRUE.
    13021302
    13031303----
     
    13181318 The 3rd or 3rd-6th parameters define the pixel size of the resampling operation. For the 3rd parameter variant, the pixel size is taken from the pixel size of the raster parameter. For the 3rd-6th parameter variant, the pixel origin and dimensions are explicitly defined.
    13191319
    1320 '''ST_SelectByValue(raster|geometry, ‘expression’) -> same type as first argument'''[[BR]]
     1320'''ST_SelectByValue(raster|geometry, ¿expression¿) -> same type as first argument'''[[BR]]
    13211321~~'''ST_Reclass(raster|geometry,string) -> same type as first argument'''[[BR]]~~
    13221322
    13231323~~Bborie: Implementation has been moved to FV.01 above.~~
    13241324
    1325 '''ST_MapAlgebra(raster|geometry, [raster|geometry,…] ‘mathematical expression’, ‘raster’ |’geometry’) -> raster/geometry'''
    1326 
    1327  Variant 1: ST_MapAlgebra(raster|geometry, [raster|geometry,…] ‘mathematical expression’, ‘raster’ |’geometry’, originx, originy, pixelsizex, pixelsizey) -> raster/geometry
    1328 
    1329  Variant 2: ST_MapAlgebra(raster|geometry, [raster|geometry,] 'mathematical expression', 'raster' |'geometry', integer) ->raster/geometry
    1330 
    1331  Variant 3: ST_MapAlgebra(raster|geometry, [raster|geometry,] 'mathematical expression', 'raster' |'geometry', raster) ->raster/geometry
     1325'''ST_MapAlgebra(raster|geometry, [raster|geometry,¿] ¿mathematical expression¿, ¿raster¿ |¿geometry¿) -> raster/geometry'''
     1326
     1327 Variant 1: ST_MapAlgebra(raster|geometry, [raster|geometry,¿] ¿mathematical expression¿, ¿raster¿ |¿geometry¿, originx, originy, pixelsizex, pixelsizey) -> raster/geometry
     1328
     1329 Variant 2: ST_MapAlgebra(raster|geometry, [raster|geometry,¿] 'mathematical expression', 'raster' |'geometry', integer) ->raster/geometry
     1330
     1331 Variant 3: ST_MapAlgebra(raster|geometry, [raster|geometry,¿] 'mathematical expression', 'raster' |'geometry', raster) ->raster/geometry
    13321332
    13331333 ST_MapAlgebra performs the specified mathematical expression on the input rasters, returning a raster or geometry.  Both rasters must have the same SRID.  If both rasters do not have the same SRID, ST_MapAlgebra will return an error:
     
    13391339  4 additional parameters are passed specifying the origin, cell size, and raster rotation.
    13401340
    1341  This function implicitly calls ST_Intersects(raster|geometry, [raster|geometry,]) to detect if the rasters are overlapping before performing any computation. Additionally, the resulting raster will have the same extent as the result of ST_Intersection(raster, integer, geometry).
     1341 This function implicitly calls ST_Intersects(raster|geometry, [raster|geometry,¿]) to detect if the rasters are overlapping before performing any computation. Additionally, the resulting raster will have the same extent as the result of ST_Intersection(raster, integer, geometry).
    13421342
    13431343 One of the implications of the ST_Intersects inclusion is that:
     
    13481348 '''Open Question:'''
    13491349      DZ: Should ST_MapAlgebra resample rasters internally, or produce a raster that can be processed by ST_Resample? If so, variant 1 and variant 3 can be removed, and all ST_MapAlgebra results can be processed through ST_Resample, like:
    1350   ST_Resample(ST_MapAlgebra(raster, [raster,] 'mathematical expression', integer), originx, originy, pixelsizex, pixelsizey)[[BR]]
    1351   ST_Resample(ST_MapAlgebra(raster, [raster,] 'mathematical expression', integer), rastergrid)
     1350  ST_Resample(ST_MapAlgebra(raster, [raster,¿] 'mathematical expression', integer), originx, originy, pixelsizex, pixelsizey)[[BR]]
     1351  ST_Resample(ST_MapAlgebra(raster, [raster,¿] 'mathematical expression', integer), rastergrid)
    13521352        PR: I think this would greatly contribute to simplify the API.
    13531353
    13541354'''ST_Clip(raster|geometry,geometry) -> same type as first argument'''[[BR]]
    1355 '''ST_Flip(raster|geometry, ’vertical’|’horizontal’) -> same type as first argument'''
     1355'''ST_Flip(raster|geometry, ¿vertical¿|¿horizontal¿) -> same type as first argument'''
    13561356
    13571357----
     
    13921392'''ST_Buffer(raster|geometry, double) -> same type as first arg.'''[[BR]]
    13931393'''ST_Difference(raster|geometry A, raster|geometry B) -> same type as first argument'''[[BR]]
    1394 '''ST_SymDifference(raster|geometry,raster|geometry,‘raster’|’geometry’) -> raster/geometry'''
     1394'''ST_SymDifference(raster|geometry,raster|geometry,¿raster¿|¿geometry¿) -> raster/geometry'''
    13951395 
    13961396----
     
    14091409== '''Objective FV.13 - Being able to edit a raster''' ==
    14101410 
    1411 '''ST_Affine(raster|geometry,) -> same type as input'''[[BR]]
    1412 '''ST_Translate(raster|geometry,) -> same type as input'''[[BR]]
    1413 '''ST_Scale(raster|geometry,) -> same type as input'''[[BR]]
    1414 '''ST_TransScale(raster|geometry,) -> same type as input'''[[BR]]
     1411'''ST_Affine(raster|geometry,¿) -> same type as input'''[[BR]]
     1412'''ST_Translate(raster|geometry,¿) -> same type as input'''[[BR]]
     1413'''ST_Scale(raster|geometry,¿) -> same type as input'''[[BR]]
     1414'''ST_TransScale(raster|geometry,¿) -> same type as input'''[[BR]]
    14151415'''ST_RotateZ,Y,Z(raster|geometry, float8) -> same type as input'''
    14161416
     
    14601460This is the core function that gets the summary statistics (# of values, mean, standard deviation, minimum value, maximum value) of a specified raster's band.  It is this function that ST_Mean, ST_StdDev and ST_MinMax calls for their appropriate values.
    14611461
    1462 1. ST_SummaryStats(rast raster, nband int, hasnodata boolean) -> record
     14621. ST_SummaryStats(rast raster, nband int, exclude_nodata_value boolean) -> record
    14631463
    14641464  returns one record of five columns (count, mean, stddev, min, max)
     
    14661466  nband: index of band
    14671467
    1468   hasnodata: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
     1468  exclude_nodata_value: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
    14691469
    14701470{{{
     
    147414742. ST_SummaryStats(rast raster, nband int) -> record
    14751475
    1476   assumes hasnodata = TRUE
     1476  assumes exclude_nodata_value = TRUE
    14771477
    14781478{{{
     
    14801480}}}
    14811481
    1482 3. ST_SummaryStats(rast raster, hasnodata boolean) -> record
     14823. ST_SummaryStats(rast raster, exclude_nodata_value boolean) -> record
    14831483
    14841484  assumes nband = 1
     
    149014904. ST_SummaryStats(rast raster) -> record
    14911491
    1492   assumes nband = 1 and hasnodata = TRUE
     1492  assumes nband = 1 and exclude_nodata_value = TRUE
    14931493
    14941494{{{
     
    15041504The set of ST_ApproxSummaryStats functions are:
    15051505
    1506 1. ST_ApproxSummaryStats(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> record
     15061. ST_ApproxSummaryStats(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> record
    15071507
    15081508  sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    15241524}}}
    15251525
    1526 3. ST_ApproxSummaryStats(rast raster, hasnodata boolean, sample_percent double precision) -> record
     15263. ST_ApproxSummaryStats(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> record
    15271527
    15281528  assumes that nband = 1
     
    153615364. ST_ApproxSummaryStats(rast raster, sample_percent double precision) -> record
    15371537
    1538   assumes that nband = 1 and hasnodata = TRUE
     1538  assumes that nband = 1 and exclude_nodata_value = TRUE
    15391539
    15401540{{{
     
    154415445. ST_ApproxSummaryStats(rast raster) -> record
    15451545
    1546   assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1546  assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    15471547
    15481548{{{
     
    15521552The situation arises where the summary statistics of a coverage table is required.  As the coverage may be large (tens of gigabytes of memory or larger), the following functions are provided to permit an incremental computation of the summary statistics.
    15531553
    1554 1. ST_SummaryStats(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> record
     15541. ST_SummaryStats(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> record
    15551555
    15561556  rastertable: name of table with raster column
     
    156615662. ST_SummaryStats(rastertable text, rastercolumn text, nband int) -> record
    15671567
    1568     hasnodata = TRUE
     1568    exclude_nodata_value = TRUE
    15691569
    15701570{{{
     
    15721572}}}
    15731573
    1574 3. ST_SummaryStats(rastertable text, rastercolumn text, hasnodata boolean) -> record
     15743. ST_SummaryStats(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> record
    15751575
    15761576    nband = 1
     
    158215824. ST_SummaryStats(rastertable text, rastercolumn text) -> record
    15831583
    1584     nband = 1 and hasnodata = TRUE
     1584    nband = 1 and exclude_nodata_value = TRUE
    15851585
    15861586{{{
     
    15901590Variations for ST_ApproxSummaryStats are:
    15911591
    1592 1. ST_ApproxSummaryStats(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> record
     15921. ST_ApproxSummaryStats(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> record
    15931593
    15941594{{{
     
    160016002. ST_ApproxSummaryStats(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> record
    16011601
    1602     hasnodata = TRUE
     1602    exclude_nodata_value = TRUE
    16031603
    16041604{{{
     
    16081608}}}
    16091609
    1610 3. ST_ApproxSummaryStats(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> record
     16103. ST_ApproxSummaryStats(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> record
    16111611
    16121612    nband = 1
     
    162016204. ST_ApproxSummaryStats(rastertable text, rastercolumn text, sample_percent double precision) -> record
    16211621
    1622     nband = 1 and hasnodata = TRUE
     1622    nband = 1 and exclude_nodata_value = TRUE
    16231623
    16241624{{{
     
    163016305. ST_ApproxSummaryStats(rastertable text, rastercolumn text) -> record
    16311631
    1632     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1632    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    16331633
    16341634{{{
     
    16461646This function calls ST_SummaryStats and only returns the count from that function.
    16471647
    1648 1. ST_Count(rast raster, nband int, hasnodata boolean) -> bigint
     16481. ST_Count(rast raster, nband int, exclude_nodata_value boolean) -> bigint
    16491649
    16501650    returns the count as an integer
     
    16521652    nband: index of band
    16531653
    1654     hasnodata: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
     1654    exclude_nodata_value: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
    16551655
    16561656{{{
     
    166016602. ST_Count(rast raster, nband int) -> bigint
    16611661
    1662     assumes hasnodata = TRUE
     1662    assumes exclude_nodata_value = TRUE
    16631663
    16641664{{{
     
    16661666}}}
    16671667
    1668 3. ST_Count(rast raster, hasnodata boolean) -> bigint
     16683. ST_Count(rast raster, exclude_nodata_value boolean) -> bigint
    16691669
    16701670    assumes nband = 1
     
    167616764. ST_Count(rast raster) -> bigint
    16771677
    1678     assumes nband = 1 and hasnodata = TRUE
     1678    assumes nband = 1 and exclude_nodata_value = TRUE
    16791679
    16801680{{{
     
    16841684The set of ST_ApproxCount functions are:
    16851685
    1686 1. ST_ApproxCount(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> bigint
     16861. ST_ApproxCount(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> bigint
    16871687
    16881688    sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    17041704}}}
    17051705
    1706 3. ST_ApproxCount(rast raster, hasnodata boolean, sample_percent double precision) -> bigint
     17063. ST_ApproxCount(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> bigint
    17071707
    17081708    assumes that nband = 1
     
    171617164. ST_ApproxCount(rast raster, sample_percent double precision) -> bigint
    17171717
    1718     assumes that nband = 1 and hasnodata = TRUE
     1718    assumes that nband = 1 and exclude_nodata_value = TRUE
    17191719
    17201720{{{
     
    172417245. ST_ApproxCount(rast raster) -> bigint
    17251725
    1726     assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1726    assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    17271727
    17281728{{{
     
    17321732The following functions are provided for coverage tables.
    17331733
    1734 1. ST_Count(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> bigint
     17341. ST_Count(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> bigint
    17351735
    17361736    rastertable: name of table with raster column
     
    174617462. ST_Count(rastertable text, rastercolumn text, nband int) -> bigint
    17471747
    1748     hasnodata = TRUE
     1748    exclude_nodata_value = TRUE
    17491749
    17501750{{{
     
    17521752}}}
    17531753
    1754 3. ST_Count(rastertable text, rastercolumn text, hasnodata boolean) -> bigint
     17543. ST_Count(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> bigint
    17551755
    17561756    nband = 1
     
    176217624. ST_Count(rastertable text, rastercolumn text) -> bigint
    17631763
    1764     nband = 1 and hasnodata = TRUE
     1764    nband = 1 and exclude_nodata_value = TRUE
    17651765
    17661766{{{
     
    17701770Variations for ST_ApproxCount are:
    17711771
    1772 1. ST_ApproxCount(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> bigint
     17721. ST_ApproxCount(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> bigint
    17731773
    17741774{{{
     
    178017802. ST_ApproxCount(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> bigint
    17811781
    1782     hasnodata = TRUE
     1782    exclude_nodata_value = TRUE
    17831783
    17841784{{{
     
    17881788}}}
    17891789
    1790 3. ST_ApproxCount(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> bigint
     17903. ST_ApproxCount(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> bigint
    17911791
    17921792    nband = 1
     
    180018004. ST_ApproxCount(rastertable text, rastercolumn text, sample_percent double precision) -> bigint
    18011801
    1802     nband = 1 and hasnodata = TRUE
     1802    nband = 1 and exclude_nodata_value = TRUE
    18031803
    18041804{{{
     
    181018105. ST_ApproxCount(rastertable text, rastercolumn text) -> bigint
    18111811
    1812     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1812    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    18131813
    18141814{{{
     
    18241824This function calls ST_SummaryStats and only returns the sum from that function.
    18251825
    1826 1. ST_Sum(rast raster, nband int, hasnodata boolean) -> double precision
     18261. ST_Sum(rast raster, nband int, exclude_nodata_value boolean) -> double precision
    18271827
    18281828    returns the sum as an integer
     
    18301830    nband: index of band
    18311831
    1832     hasnodata: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
     1832    exclude_nodata_value: if FALSE, nodata values in band are included in the stats. if TRUE, nodata values are not included
    18331833
    18341834{{{
     
    183818382. ST_Sum(rast raster, nband int) -> double precision
    18391839
    1840     assumes hasnodata = TRUE
     1840    assumes exclude_nodata_value = TRUE
    18411841
    18421842{{{
     
    18441844}}}
    18451845
    1846 3. ST_Sum(rast raster, hasnodata boolean) -> double precision
     18463. ST_Sum(rast raster, exclude_nodata_value boolean) -> double precision
    18471847
    18481848    assumes nband = 1
     
    185418544. ST_Sum(rast raster) -> double precision
    18551855
    1856     assumes nband = 1 and hasnodata = TRUE
     1856    assumes nband = 1 and exclude_nodata_value = TRUE
    18571857
    18581858{{{
     
    18621862The set of ST_ApproxSum functions are:
    18631863
    1864 1. ST_ApproxSum(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     18641. ST_ApproxSum(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    18651865
    18661866    sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    18821882}}}
    18831883
    1884 3. ST_ApproxSum(rast raster, hasnodata boolean, sample_percent double precision) -> double precision
     18843. ST_ApproxSum(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    18851885
    18861886    assumes that nband = 1
     
    189418944. ST_ApproxSum(rast raster, sample_percent double precision) -> double precision
    18951895
    1896     assumes that nband = 1 and hasnodata = TRUE
     1896    assumes that nband = 1 and exclude_nodata_value = TRUE
    18971897
    18981898{{{
     
    190219025. ST_ApproxSum(rast raster) -> double precision
    19031903
    1904     assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1904    assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    19051905
    19061906{{{
     
    19101910The following functions are provided for coverage tables.
    19111911
    1912 1. ST_Sum(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> double precision
     19121. ST_Sum(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> double precision
    19131913
    19141914    rastertable: name of table with raster column
     
    192419242. ST_Sum(rastertable text, rastercolumn text, nband int) -> double precision
    19251925
    1926     hasnodata = TRUE
     1926    exclude_nodata_value = TRUE
    19271927
    19281928{{{
     
    19301930}}}
    19311931
    1932 3. ST_Sum(rastertable text, rastercolumn text, hasnodata boolean) -> double precision
     19323. ST_Sum(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> double precision
    19331933
    19341934    nband = 1
     
    194019404. ST_Sum(rastertable text, rastercolumn text) -> double precision
    19411941
    1942     nband = 1 and hasnodata = TRUE
     1942    nband = 1 and exclude_nodata_value = TRUE
    19431943
    19441944{{{
     
    19481948Variations for ST_ApproxSum are:
    19491949
    1950 1. ST_ApproxSum(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     19501. ST_ApproxSum(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    19511951
    19521952{{{
     
    195819582. ST_ApproxSum(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> double precision
    19591959
    1960     hasnodata = TRUE
     1960    exclude_nodata_value = TRUE
    19611961
    19621962{{{
     
    19661966}}}
    19671967
    1968 3. ST_ApproxSum(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> double precision
     19683. ST_ApproxSum(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    19691969
    19701970    nband = 1
     
    197819784. ST_ApproxSum(rastertable text, rastercolumn text, sample_percent double precision) -> double precision
    19791979
    1980     nband = 1 and hasnodata = TRUE
     1980    nband = 1 and exclude_nodata_value = TRUE
    19811981
    19821982{{{
     
    198819885. ST_ApproxSum(rastertable text, rastercolumn text) -> double precision
    19891989
    1990     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     1990    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    19911991
    19921992{{{
     
    20012001This function calls ST_SummaryStats and only returns the mean from that function.
    20022002
    2003 1. ST_Mean(rast raster, nband int, hasnodata boolean) -> double precision
     20031. ST_Mean(rast raster, nband int, exclude_nodata_value boolean) -> double precision
    20042004
    20052005  returns the mean as a double precision
     
    20072007  nband: index of band
    20082008
    2009   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2009  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    20102010
    20112011{{{
     
    201520152. ST_Mean(rast raster, nband int) -> double precision
    20162016
    2017   assumes hasnodata = TRUE
     2017  assumes exclude_nodata_value = TRUE
    20182018
    20192019{{{
     
    20212021}}}
    20222022
    2023 3. ST_Mean(rast raster, hasnodata boolean) -> double precision
     20233. ST_Mean(rast raster, exclude_nodata_value boolean) -> double precision
    20242024
    20252025  assumes nband = 1
     
    203120314. ST_Mean(rast raster) -> double precision
    20322032
    2033   assumes nband = 1 and hasnodata = TRUE
     2033  assumes nband = 1 and exclude_nodata_value = TRUE
    20342034
    20352035{{{
     
    20392039The set of ST_ApproxMean functions are:
    20402040
    2041 1. ST_ApproxMean(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     20411. ST_ApproxMean(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    20422042
    20432043  sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    20592059}}}
    20602060
    2061 3. ST_ApproxMean(rast raster, hasnodata boolean, sample_percent double precision) -> double precision
     20613. ST_ApproxMean(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    20622062
    20632063  assumes that nband = 1
     
    207120714. ST_ApproxMean(rast raster, sample_percent double precision) -> double precision
    20722072
    2073   assumes that nband = 1 and hasnodata = TRUE
     2073  assumes that nband = 1 and exclude_nodata_value = TRUE
    20742074
    20752075{{{
     
    207920795. ST_ApproxMean(rast raster) -> double precision
    20802080
    2081   assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2081  assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    20822082
    20832083{{{
     
    20872087The following functions are provided for coverage tables.
    20882088
    2089 1. ST_Mean(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> double precision
     20891. ST_Mean(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> double precision
    20902090
    20912091  rastertable: name of table with raster column
     
    210121012. ST_Mean(rastertable text, rastercolumn text, nband int) -> double precision
    21022102
    2103     hasnodata = TRUE
     2103    exclude_nodata_value = TRUE
    21042104
    21052105{{{
     
    21072107}}}
    21082108
    2109 3. ST_Mean(rastertable text, rastercolumn text, hasnodata boolean) -> double precision
     21093. ST_Mean(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> double precision
    21102110
    21112111    nband = 1
     
    211721174. ST_Mean(rastertable text, rastercolumn text) -> double precision
    21182118
    2119     nband = 1 and hasnodata = TRUE
     2119    nband = 1 and exclude_nodata_value = TRUE
    21202120
    21212121{{{
     
    21252125Variations for ST_ApproxMean are:
    21262126
    2127 1. ST_ApproxMean(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     21271. ST_ApproxMean(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    21282128
    21292129{{{
     
    213521352. ST_ApproxMean(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> double precision
    21362136
    2137     hasnodata = TRUE
     2137    exclude_nodata_value = TRUE
    21382138
    21392139{{{
     
    21432143}}}
    21442144
    2145 3. ST_ApproxMean(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> double precision
     21453. ST_ApproxMean(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    21462146
    21472147    nband = 1
     
    215521554. ST_ApproxMean(rastertable text, rastercolumn text, sample_percent double precision) -> double precision
    21562156
    2157     nband = 1 and hasnodata = TRUE
     2157    nband = 1 and exclude_nodata_value = TRUE
    21582158
    21592159{{{
     
    216521655. ST_ApproxMean(rastertable text, rastercolumn text) -> double precision
    21662166
    2167     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2167    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    21682168
    21692169{{{
     
    21802180This function calls ST_SummaryStats and only returns the standard deviation from that function.
    21812181
    2182 1. ST_StdDev(rast raster, nband int, hasnodata boolean) -> double precision
     21821. ST_StdDev(rast raster, nband int, exclude_nodata_value boolean) -> double precision
    21832183
    21842184  returns the standard deviation as a double precision
     
    21862186  nband: index of band
    21872187
    2188   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2188  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    21892189
    21902190{{{
     
    219421942. ST_StdDev(rast raster, nband int) -> double precision
    21952195
    2196   assumes hasnodata = TRUE
     2196  assumes exclude_nodata_value = TRUE
    21972197
    21982198{{{
     
    22002200}}}
    22012201
    2202 3. ST_StdDev(rast raster, hasnodata boolean) -> double precision
     22023. ST_StdDev(rast raster, exclude_nodata_value boolean) -> double precision
    22032203
    22042204  assumes nband = 1
     
    221022104. ST_StdDev(rast raster) -> double precision
    22112211
    2212   assumes nband = 1 and hasnodata = TRUE
     2212  assumes nband = 1 and exclude_nodata_value = TRUE
    22132213
    22142214{{{
     
    22182218The set of ST_ApproxStdDev functions are:
    22192219
    2220 1. ST_ApproxStdDev(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     22201. ST_ApproxStdDev(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    22212221
    22222222  sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    22382238}}}
    22392239
    2240 3. ST_ApproxStdDev(rast raster, hasnodata boolean, sample_percent double precision) -> double precision
     22403. ST_ApproxStdDev(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    22412241
    22422242  assumes that nband = 1
     
    225022504. ST_ApproxStdDev(rast raster, sample_percent double precision) -> double precision
    22512251
    2252   assumes that nband = 1 and hasnodata = TRUE
     2252  assumes that nband = 1 and exclude_nodata_value = TRUE
    22532253
    22542254{{{
     
    225822585. ST_ApproxStdDev(rast raster) -> double precision
    22592259
    2260   assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2260  assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    22612261
    22622262{{{
     
    22662266The following functions are provided for coverage tables.
    22672267
    2268 1. ST_StdDev(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> double precision
     22681. ST_StdDev(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> double precision
    22692269
    22702270  rastertable: name of table with raster column
     
    228022802. ST_StdDev(rastertable text, rastercolumn text, nband int) -> double precision
    22812281
    2282     hasnodata = TRUE
     2282    exclude_nodata_value = TRUE
    22832283
    22842284{{{
     
    22862286}}}
    22872287
    2288 3. ST_StdDev(rastertable text, rastercolumn text, hasnodata boolean) -> double precision
     22883. ST_StdDev(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> double precision
    22892289
    22902290    nband = 1
     
    229622964. ST_StdDev(rastertable text, rastercolumn text) -> double precision
    22972297
    2298     nband = 1 and hasnodata = TRUE
     2298    nband = 1 and exclude_nodata_value = TRUE
    22992299
    23002300{{{
     
    23042304Variations for ST_ApproxStdDev are:
    23052305
    2306 1. ST_ApproxStdDev(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> double precision
     23061. ST_ApproxStdDev(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    23072307
    23082308{{{
     
    231423142. ST_ApproxStdDev(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> double precision
    23152315
    2316     hasnodata = TRUE
     2316    exclude_nodata_value = TRUE
    23172317
    23182318{{{
     
    23222322}}}
    23232323
    2324 3. ST_ApproxStdDev(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> double precision
     23243. ST_ApproxStdDev(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> double precision
    23252325
    23262326    nband = 1
     
    233423344. ST_ApproxStdDev(rastertable text, rastercolumn text, sample_percent double precision) -> double precision
    23352335
    2336     nband = 1 and hasnodata = TRUE
     2336    nband = 1 and exclude_nodata_value = TRUE
    23372337
    23382338{{{
     
    234423445. ST_ApproxStdDev(rastertable text, rastercolumn text) -> double precision
    23452345
    2346     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2346    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    23472347
    23482348{{{
     
    23592359This function calls ST_SummaryStats and only returns the min and max values from that function.
    23602360
    2361 1. ST_MinMax(rast raster, nband int, hasnodata boolean) -> record
     23611. ST_MinMax(rast raster, nband int, exclude_nodata_value boolean) -> record
    23622362
    23632363  returns the record (min double precision, max double precision)
     
    23652365  nband: index of band
    23662366
    2367   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2367  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    23682368
    23692369{{{
     
    237323732. ST_MinMax(rast raster, nband int) -> record
    23742374
    2375   assumes hasnodata = TRUE
     2375  assumes exclude_nodata_value = TRUE
    23762376
    23772377{{{
     
    23792379}}}
    23802380
    2381 3. ST_MinMax(rast raster, hasnodata boolean) -> record
     23813. ST_MinMax(rast raster, exclude_nodata_value boolean) -> record
    23822382
    23832383  assumes nband = 1
     
    238923894. ST_MinMax(rast raster) -> record
    23902390
    2391   assumes nband = 1 and hasnodata = TRUE
     2391  assumes nband = 1 and exclude_nodata_value = TRUE
    23922392
    23932393{{{
     
    23972397The set of ST_ApproxMinMax functions are:
    23982398
    2399 1. ST_ApproxMinMax(rast raster, nband int, hasnodata boolean, sample_percent record) -> record
     23991. ST_ApproxMinMax(rast raster, nband int, exclude_nodata_value boolean, sample_percent record) -> record
    24002400
    24012401  sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider
     
    24172417}}}
    24182418
    2419 3. ST_ApproxMinMax(rast raster, hasnodata boolean, sample_percent double precision) -> record
     24193. ST_ApproxMinMax(rast raster, exclude_nodata_value boolean, sample_percent double precision) -> record
    24202420
    24212421  assumes that nband = 1
     
    242924294. ST_ApproxMinMax(rast raster, sample_percent double precision) -> record
    24302430
    2431   assumes that nband = 1 and hasnodata = TRUE
     2431  assumes that nband = 1 and exclude_nodata_value = TRUE
    24322432
    24332433{{{
     
    243724375. ST_ApproxMinMax(rast raster) -> record
    24382438
    2439   assumes that nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2439  assumes that nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    24402440
    24412441{{{
     
    24452445The following functions are provided for coverage tables.
    24462446
    2447 1. ST_MinMax(rastertable text, rastercolumn text, nband int, hasnodata boolean) -> record
     24471. ST_MinMax(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean) -> record
    24482448
    24492449  rastertable: name of table with raster column
     
    245924592. ST_MinMax(rastertable text, rastercolumn text, nband int) -> record
    24602460
    2461     hasnodata = TRUE
     2461    exclude_nodata_value = TRUE
    24622462
    24632463{{{
     
    24652465}}}
    24662466
    2467 3. ST_MinMax(rastertable text, rastercolumn text, hasnodata boolean) -> record
     24673. ST_MinMax(rastertable text, rastercolumn text, exclude_nodata_value boolean) -> record
    24682468
    24692469    nband = 1
     
    247524754. ST_MinMax(rastertable text, rastercolumn text) -> record
    24762476
    2477     nband = 1 and hasnodata = TRUE
     2477    nband = 1 and exclude_nodata_value = TRUE
    24782478
    24792479{{{
     
    24832483Variations for ST_ApproxMinMax are:
    24842484
    2485 1. ST_ApproxMinMax(rastertable text, rastercolumn text, nband int, hasnodata boolean, sample_percent double precision) -> record
     24851. ST_ApproxMinMax(rastertable text, rastercolumn text, nband int, exclude_nodata_value boolean, sample_percent double precision) -> record
    24862486
    24872487{{{
     
    249324932. ST_ApproxMinMax(rastertable text, rastercolumn text, nband int, sample_percent double precision) -> record
    24942494
    2495     hasnodata = TRUE
     2495    exclude_nodata_value = TRUE
    24962496
    24972497{{{
     
    25012501}}}
    25022502
    2503 3. ST_ApproxMinMax(rastertable text, rastercolumn text, hasnodata boolean, sample_percent double precision) -> record
     25033. ST_ApproxMinMax(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision) -> record
    25042504
    25052505    nband = 1
     
    251325134. ST_ApproxMinMax(rastertable text, rastercolumn text, sample_percent double precision) -> record
    25142514
    2515     nband = 1 and hasnodata = TRUE
     2515    nband = 1 and exclude_nodata_value = TRUE
    25162516
    25172517{{{
     
    252325235. ST_ApproxMinMax(rastertable text, rastercolumn text) -> record
    25242524
    2525     nband = 1, hasnodata = TRUE and sample_percent = 0.1
     2525    nband = 1, exclude_nodata_value = TRUE and sample_percent = 0.1
    25262526
    25272527{{{
     
    25402540ST_Histogram has the following variations.
    25412541
    2542 1. ST_Histogram(rast raster, nband int, hasnodata boolean, bins int, width double precision[], right boolean) -> set of records
     25421. ST_Histogram(rast raster, nband int, exclude_nodata_value boolean, bins int, width double precision[], right boolean) -> set of records
    25432543
    25442544  returns set of records of four columns (min, max, count, percent)
     
    25462546  nband: index of band to process on
    25472547
    2548   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2548  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    25492549
    25502550  bins: the number of categories/bins to have in the histogram. If NULL or value less than one, the number of categories will be auto-computed using Sturges' formula if the number of values >= 30 or Square-root choice if number of values < 30.
     
    25682568}}}
    25692569
    2570 2. ST_Histogram(rast raster, nband int, hasnodata boolean, bins int, right boolean) -> set of records
     25702. ST_Histogram(rast raster, nband int, exclude_nodata_value boolean, bins int, right boolean) -> set of records
    25712571
    25722572  parameter "width" is not specified thus resulting in all bins having the same widths
     
    25762576}}}
    25772577
    2578 3. ST_Histogram(rast raster, nband int, hasnodata boolean, bins int) -> set of records
     25783. ST_Histogram(rast raster, nband int, exclude_nodata_value boolean, bins int) -> set of records
    25792579
    25802580  the parameter "right" is removed and assumed to be FALSE
     
    25842584}}}
    25852585
    2586 4. ST_Histogram(rast raster, nband int, hasnodata boolean) -> set of records
     25864. ST_Histogram(rast raster, nband int, exclude_nodata_value boolean) -> set of records
    25872587
    25882588  the parameter "bins" is removed and set to NULL.  The function will compute the number of bins to use
     
    259025905. ST_Histogram(rast raster, nband int) -> set of records
    25912591
    2592   hasnodata is assumed to be TRUE
     2592  exclude_nodata_value is assumed to be TRUE
    25932593
    259425946. ST_Histogram(rast raster) -> set of records
     
    259825987. ST_Histogram(rast raster, nband int, bins int, width double precision[], right boolean) -> set of records
    25992599
    2600   hasnodata is assumed to be TRUE
     2600  exclude_nodata_value is assumed to be TRUE
    26012601
    260226028. ST_Histogram(rast raster, nband int, bins int, right boolean) -> set of records
     
    26102610ST_ApproxHistogram should have the following variations.
    26112611
    2612 1. ST_ApproxHistogram(rast raster, nband int, hasnodata boolean, sample_percent double precision, bins int, width double precision[], right boolean) -> set of record
     26121. ST_ApproxHistogram(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision, bins int, width double precision[], right boolean) -> set of record
    26132613
    26142614    sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider when generating the histogram.
     
    26262626}}}
    26272627
    2628 2. ST_ApproxHistogram(rast raster, nband int, hasnodata boolean, sample_percent double precision, bins int, right boolean) -> set of records
     26282. ST_ApproxHistogram(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision, bins int, right boolean) -> set of records
    26292629
    26302630  parameter "width" is not specified thus resulting in all bins having the same widths
    26312631
    2632 3. ST_ApproxHistogram(rast raster, nband int, hasnodata boolean, sample_percent double precision, bins int) -> set of records
     26323. ST_ApproxHistogram(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision, bins int) -> set of records
    26332633
    26342634  the parameter "right" is removed and assumed to be FALSE
     
    26382638}}}
    26392639
    2640 4. ST_ApproxHistogram(rast raster, nband int, hasnodata boolean, sample_percent double precision) -> set of records
     26404. ST_ApproxHistogram(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision) -> set of records
    26412641
    26422642  the parameter "bins" is removed and set to NULL so that function can compute the number of bins to use
     
    264426445. ST_ApproxHistogram(rast raster, nband int, sample_percent double precision) -> set of records
    26452645
    2646   hasnodata is assumed to be TRUE
     2646  exclude_nodata_value is assumed to be TRUE
    26472647
    264826486. ST_ApproxHistogram(rast raster, nband int) -> set of records
     
    266026609. ST_ApproxHistogram(rast raster, nband int, sample_percent double precision, bins int, width double precision[], right boolean) -> set of records
    26612661
    2662   hasnodata is assumed to be TRUE
     2662  exclude_nodata_value is assumed to be TRUE
    26632663
    2664266410. ST_ApproxHistogram(rast raster, nband int, sample_percent double precision, bins int, right boolean) -> set of records
     
    26782678ST_Quantile variations:
    26792679
    2680 1. ST_Quantile(rast raster, nband int, hasnodata boolean, quantiles double precision[]) -> set of records
     26801. ST_Quantile(rast raster, nband int, exclude_nodata_value boolean, quantiles double precision[]) -> set of records
    26812681
    26822682  each row returned is of (quantile double precision, value double precision)
     
    26842684  nband: index of band to process on
    26852685
    2686   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2686  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    26872687
    26882688  quantiles: array of percentages to compute values for
     
    269826982. ST_Quantile(rast raster, nband int, quantiles double precision[]) -> set of records
    26992699
    2700   "hasnodata" is assumed to be TRUE
     2700  "exclude_nodata_value" is assumed to be TRUE
    27012701
    27022702{{{
     
    27042704}}}
    27052705
    2706 3. ST_Quantile(rast raster, nband int, hasnodata boolean) -> set of records
     27063. ST_Quantile(rast raster, nband int, exclude_nodata_value boolean) -> set of records
    27072707
    27082708  "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
     
    271027104. ST_Quantile(rast raster, nband int) -> set of records
    27112711
    2712   "hasnodata" is assumed to be TRUE and "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
     2712  "exclude_nodata_value" is assumed to be TRUE and "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
    27132713
    271427145. ST_Quantile(rast raster, quantiles double precision[]) -> set of records
    27152715
    2716   "nband" is assumed to be 1 and "hasnodata" is TRUE
     2716  "nband" is assumed to be 1 and "exclude_nodata_value" is TRUE
    27172717
    271827186. ST_Quantile(rast raster) -> set of records
     
    27202720  "nband" is assumed to be 1 and "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
    27212721
    2722 7. ST_Quantile(rast raster, nband int, hasnodata boolean, quantile double precision) -> record
     27227. ST_Quantile(rast raster, nband int, exclude_nodata_value boolean, quantile double precision) -> record
    27232723
    27242724  quantile: the single percentile to compute
     
    272627268. ST_Quantile(rast raster, nband int, quantile double precision) -> record
    27272727
    2728   "hasnodata" is assumed to be TRUE
    2729 
    2730 9. ST_Quantile(rast raster, hasnodata boolean, quantile double precision) -> record
     2728  "exclude_nodata_value" is assumed to be TRUE
     2729
     27309. ST_Quantile(rast raster, exclude_nodata_value boolean, quantile double precision) -> record
    27312731
    27322732  "nband" is assumed to be 1
     
    2734273410. ST_Quantile(rast raster, quantile double precision) -> record
    27352735
    2736   "nband" is assumed to be 1  and "hasnodata" is assumed to be TRUE
     2736  "nband" is assumed to be 1  and "exclude_nodata_value" is assumed to be TRUE
    27372737
    27382738ST_ApproxQuantile adds a "sample_percent" indicating the percentage of the raster to sample
    27392739
    2740 1. ST_ApproxQuantile(rast raster, nband int, hasnodata boolean, sample_percent double precision, quantiles double precision[]) -> set of records
     27401. ST_ApproxQuantile(rast raster, nband int, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]) -> set of records
    27412741
    27422742  nband: index of band to process on
    27432743
    2744   hasnodata: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
     2744  exclude_nodata_value: if FALSE, nodata values in band are included. if TRUE, nodata values are not included.
    27452745
    27462746  sample_percent: a value between 0 and 1 indicating the percentage of the raster band's pixels to consider when computing the quantiles
     
    275827582. ST_ApproxQuantile(rast raster, nband int, sample_percent double precision, quantiles double precision[]) -> set of records
    27592759
    2760   "hasnodata" is assumed to be TRUE
     2760  "exclude_nodata_value" is assumed to be TRUE
    27612761
    27622762{{{
     
    276627663. ST_ApproxQuantile(rast raster, nband int, sample_percent double precision) -> set of records
    27672767
    2768   "hasnodata" is assumed to be TRUE and "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
     2768  "exclude_nodata_value" is assumed to be TRUE and "quantiles" assumed to be ARRAY[0, 0.25, 0.5, 0.75, 1]
    27692769
    277027704. ST_ApproxQuantile(rast raster, sample_percent double precision, quantiles double precision[]) -> set of records
     
    28312831'''ST_RasterFromText(string, [<srid>])'''[[BR]]
    28322832'''ST_AsText(raster)'''
    2833 
    2834