| 18 | | ---- |
| 19 | | == '''Objective B03a - Being able to set all the properties of a raster.''' == |
| 20 | | |
| 21 | | |
| 22 | | '''ST_SetSRID(raster|geometry, integer)''' |
| 23 | | Set the spatial reference on the specified raster. This corresponds with the ST_SetSRID method in regular PostGIS. |
| 24 | | |
| 25 | | '''ST_SetPixelSize(raster, pixelsize)''' |
| 26 | | Variant 1: ST_SetPixelSize(raster, xsize, ysize) |
| 27 | | |
| 28 | | ~~Variant 2: ST_SetPixelSize(raster, raster)~~ |
| 29 | | |
| 30 | | Set the pixel size (cell size) on the specified raster. The base method sets the X and Y pixel size to the same value. The first variant sets the pixel sizes to the individually specified x and y sizes. ~~The second variant sets the pixel size to the pixel size of the 2nd raster parameter.~~ |
| 31 | | |
| 32 | | '''Open Question:''' |
| 33 | | DZ: Should there be corresponding methods for X/Y sizes? ST_SetXPixelSize(...) and ST_SetYPixelSize(...) |
| 34 | | PR: In addition to ST_SetPixelSize(raster, xsize, ysize) or in replacement of? |
| 35 | | DZ: In addition to?[[BR]] |
| 36 | | PR: Maybe we are fine with ST_SetPixelSize(raster, xsize, ysize)... |
| 37 | | |
| 38 | | PR: Could you provide a full SQL example of ST_SetPixelSize(raster, raster)? And in general of a function getting arguments for the first raster from another raster (like the below ST_Resample(raster, method, raster)) |
| 39 | | DZ: A SQL example for this is in the regression tests in patch #431: test/regress/rt_set_properties.sql, line 52. I can come up with some more examples, if needed. |
| 40 | | DZ: After discussion, will drop the variant that copies the pixel size from a raster parameter. |
| 41 | | |
| 42 | | '''ST_SetNoDataValue(raster, band, value)''' |
| 43 | | Set the data value that corresponds to NODATA in the given raster and band. |
| 44 | | |
| 45 | | '''ST_HasNoDataValue(raster, band)''' |
| 46 | | Return true if the value stored as a NODATA value must be interpreted as a real NODATA value. |
| 47 | | |
| 48 | | '''ST_SetGeoReference(raster, georef)''' |
| 49 | | Variant 1: ST_SetGeoReference(raster, georef, format) |
| 50 | | |
| 51 | | Set the georeference fields of the raster (pixel size, rotation, upper left location) all in one pass. The 'format' parameter is optional, and defaults to 'GDAL' georeference format if it is not specified. |
| 52 | | |
| 53 | | If this method does not recieve a georeference string with 6 parameters (or if one of the parameters is not numeric), it raises an exception "st_setgeoreference requires a string with 6 floating point values". If this method recieves a null raster, it does nothing, and returns a null raster. |
| 54 | | |
| 55 | | '''ST_SetRotation(raster, rotation)''' |
| 56 | | Variant 1: ST_SetRotation(raster, rotationx, rotation y) |
| 57 | | |
| 58 | | ~~Variant 2: ST_SetRotation(raster, raster)~~ |
| 59 | | |
| 60 | | Set the rotation of the raster. The base method sets the X and Y rotation to the same value. The first variant sets the rotation to the individually specified x and y rotations. ~~The second variant sets the rotation to the rotation taken from the 2nd raster parameter.~~ |
| 61 | | |
| 62 | | '''Open Question:''' |
| 63 | | DZ: Should there be corresponding methods for X/Y rotations in addition to this general method? ST_SetXRotation(...) and ST_SetYRotation(...)? |
| 64 | | DZ: No, follow the pattern for ST_SetPixelSize |
| 65 | | |
| 66 | | '''ST_SetUpperLeft(raster, left, top)''' |
| 67 | | ~~Variant 1: ST_SetUpperLeft(raster, raster)~~ |
| 68 | | |
| 69 | | Set the location of the upper left pixel (cell). The base method sets the X and Y coordinates to the individually specified left and top coordinates. ~~The first variant sets the upper left coordinate to the upper left coordinate taken from the 2nd raster parameter.~~ |
| 70 | | |
| 71 | | '''Open Question:''' |
| 72 | | DZ: Should there be corresponding methods for X/Y rotations in addition to this general method? ST_SetUpperLeftX(...) and ST_SetUpperLeftY()? |
| 73 | | DZ: No, follow the pattern for ST_SetPixelSize |
