From 92074a66bd97b867aae8955dee31702c98cdbf7d Mon Sep 17 00:00:00 2001 From: Bborie Park Date: Tue, 3 Jul 2012 22:30:36 +0000 Subject: [PATCH] Added docs for ST_PixelAsPoints and ST_PixelAsCentroids and update NEWS git-svn-id: http://svn.osgeo.org/postgis/trunk@10027 b70326c6-7e19-0410-871a-916f4a2858ee --- NEWS | 2 + doc/reference_raster.xml | 198 +++++++++++++++++++++++++++++++++++++-- 2 files changed, 192 insertions(+), 8 deletions(-) diff --git a/NEWS b/NEWS index 8704a81e2..bd6ec7cfc 100644 --- a/NEWS +++ b/NEWS @@ -5,6 +5,8 @@ PostGIS 2.1.0 - ST_DelaunayTriangles (Sandro Santilli / Vizzuality) - ST_NearestValue, ST_Neighborhood (Bborie Park / UC Davis) + - ST_PixelAsPoint, ST_PixelAsPoints (Bborie Park / UC Davis) + - ST_PixelAsCentroid, ST_PixelAsCentroids (Bborie Park / UC Davis) - ST_Raster2WorldCoord, ST_World2RasterCoord (Bborie Park / UC Davis) - #1643, Tiger Geocoder - Tiger 2011 loader (Regina Obe / Paragon Corporation) Funded by Hunter Systems Group diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index 2df1517aa..a31e71287 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -2981,7 +2981,7 @@ rid | hb1 | hb2 | hb4 | numbands ST_PixelAsPolygon - Returns the geometry that bounds the pixel for a particular row and column. + Returns the polygon geometry that bounds the pixel for a particular row and column. @@ -2998,7 +2998,7 @@ rid | hb1 | hb2 | hb4 | numbands Description - Returns the geometry that bounds the pixel for a particular row and column. + Returns the polygon geometry that bounds the pixel for a particular row and column. @@ -3030,7 +3030,7 @@ WHERE rid=2; ST_PixelAsPolygons - Returns the geometry that bounds every pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. + Returns the polygon geometry that bounds every pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. @@ -3046,12 +3046,12 @@ WHERE rid=2; Description - - Returns the geometry that bounds every pixel of a raster band along with the value (double precision), the X and the Y raster coordinates (integers) of each pixel. + + Returns the polygon geometry that bounds every pixel of a raster band along with the value (double precision), the X and the Y raster coordinates (integers) of each pixel. - ST_PixelAsPolygons returns one geometry for every pixel. This is different than ST_DumpAsPolygons where each geometry represents one or more pixels with the same pixel value. + ST_PixelAsPolygons returns one polygon geometry for every pixel. This is different than ST_DumpAsPolygons where each geometry represents one or more pixels with the same pixel value. @@ -3081,10 +3081,192 @@ FROM (SELECT ST_PixelAsPolygons( See Also - , , - + + , + , + + + + + + + + ST_PixelAsPoint + + Returns a point geometry of the pixel's upper-left corner. + + + + + + geometry ST_PixelAsPoint + raster rast + integer columnx + integer rowy + + + + + + Description + Returns a point geometry of the pixel's upper-left corner. + + + + Examples + +-- needs an example + + + + + See Also + + , + , + , + , + , + + + + + + + + + ST_PixelAsPoints + + Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixel's upper-left corner. + + + + + + geometry ST_PixelAsPoints + raster rast + integer band=1 + boolean exclude_nodata_value=TRUE + + + + + + Description + + Returns a point geometry for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The coordinates of the point geometry are of the pixel's upper-left corner. + + + + + Examples + +-- needs an example + + + + + See Also + + , + , + , + , + , + + + + + + + + + ST_PixelAsCentroid + + Returns the centroid (point geometry) of the area represented by a pixel. + + + + + + geometry ST_PixelAsCentroid + raster rast + integer columnx + integer rowy + + + + + + Description + Returns the centroid (point geometry) of the area represented by a pixel. + + + + Examples + +-- needs an example + + + + + See Also + + , + , + , + , + , + + + + + + + ST_PixelAsCentroids + + Returns the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel. + + + + + + geometry ST_PixelAsCentroids + raster rast + integer band=1 + boolean exclude_nodata_value=TRUE + + + + + + Description + + Returns the centroid (point geometry) for each pixel of a raster band along with the value, the X and the Y raster coordinates of each pixel. The point geometry is the centroid of the area represented by a pixel. + + + + + Examples + +-- needs an example + + + + + See Also + + , + , + , + , + , + + + + -- 2.40.0