Changes between Version 41 and Version 42 of WKTRaster/SpecificationFinal01

Timestamp:

Sep 3, 2010, 10:27:01 AM (14 years ago)

Author:

pracine

Comment:

—

WKTRaster/SpecificationFinal01

@@ -340 +340 @@
 
 ----
-== '''Objective 0.1.6i - Being able to quickly get metadata for raster and band.''' ==
+== '''Objective 0.1.6h - Being able to quickly get metadata for raster and band.''' ==
 
 '''ST_Metadata(raster) -> record'''[[BR]]
@@ -351 +351 @@
 
 It should be used like this: "SELECT (bmd).* FROM (SELECT ST_BandMetadata(rast) AS bmd FROM myrastertable) foo"
+
+----
+== '''Objective 0.1.6i - Being able to easily convert world coordinates to raster coordinates.''' ==
+
+'''ST_World2RasterCoordX(rast raster, xw float8, yw float8)'''[[BR]]
+Returns the column number of the pixel covering the provided X and Y world coordinates. 
+This function works even if the world coordinates are outside the raster extent. 
+
+'''ST_World2RasteCoordX(rast raster, xw float8)'''[[BR]]
+Returns the column number of the pixels covering the provided world X coordinate for a non-rotated raster. 
+This function works even if the world coordinate is outside the raster extent. 
+This function returns an error if the raster is rotated. In this case you must also provide a Y.
+
+'''ST_World2RasterCoordX(rast raster, pt geometry)'''[[BR]]
+Returns the column number of the pixel covering the provided point geometry.
+This function works even if the point is outside the raster extent.
+
+'''ST_World2RasterCoordY(rast raster, xw float8, yw float8)'''[[BR]]
+Returns the row number of the pixel covering the provided X and Y world coordinates. 
+This function works even if the world coordinates are outside the raster extent.
+
+'''ST_World2RasterCoordY(rast raster, yw float8)'''[[BR]]
+Returns the row number of the pixels covering the provided world Y coordinate for a non-rotated raster. 
+This function works even if the world coordinate is outside the raster extent. 
+This function returns an error if the raster is rotated. In this case you must also provide an X.
+
+'''ST_World2RasterCoordY(rast raster, pt geometry)'''[[BR]]
+Returns the row number of the pixel covering the provided point geometry.
+This function works even if the point is outside the raster extent.
+
+'''ST_Raster2WorldCoordX(rast raster, xr int, yr int)'''[[BR]]
+Returns the X world coordinate of the upper left corner of the pixel located at the provided column and row numbers.
+This function works even if the provided raster column and row are beyond or below the raster width and height.
+
+
+'''ST_Raster2WorldCoordX(rast raster, xr int)'''[[BR]]
+Returns the X world coordinate of the upper left corner of the pixel located at the provided column number for a non-rotated raster.
+This function works even if the provided raster column is beyond or below the raster width.
+This function returns an error if the raster is rotated. In this case you must also provide a Y.
+
+'''ST_Raster2WorldCoordY(rast raster, xr int, yr int)'''[[BR]]
+Returns the Y world coordinate of the upper left corner of the pixel located at 
+the provided column and row numbers.
+This function works even if the provided raster column and row are beyond or below the raster width and height.
+
+'''ST_Raster2WorldCoordY(rast raster, yr int)'''[[BR]]
+Returns the Y world coordinate of the upper left corner of the pixel located at the provided row number for a non-rotated raster.
+This function works even if the provided raster row is beyond or below the raster height.
+This function returns an error if the raster is rotated. In this case you must 
+also provide an X.
 
 ----