62 | | '''ST_SRID(raster|geometry) -> integer'''[[BR]] |
63 | | |
64 | | Return the SRID associated with the raster. |
65 | | |
66 | | '''ST_Width(raster) -> integer'''[[BR]] |
67 | | Return the width of the raster. |
68 | | |
69 | | '''ST_Height(raster) -> integer'''[[BR]] |
70 | | Return the height of the raster. |
71 | | |
72 | | '''ST_PixelSizeX(raster) -> float64'''[[BR]] |
73 | | Return the georeference's X pixel size of the raster. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
74 | | |
75 | | '''ST_PixelSizeY(raster) -> float64'''[[BR]] |
76 | | Return the georeference's Y pixel size of the raster. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
77 | | |
78 | | '''ST_RotationX(raster) -> float64'''[[BR]] |
79 | | Return the georeference's X rotation. |
80 | | |
81 | | '''ST_RotationY(raster) -> float64'''[[BR]] |
82 | | Return the georeference's Y rotation. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
83 | | |
84 | | '''ST_UpperLeftX(raster) -> float64'''[[BR]] |
85 | | Return the georeference's X-coordinate of the upper left corner of the upper left pixel. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
86 | | |
87 | | '''ST_UpperLeftY(raster) -> float64'''[[BR]] |
88 | | Return the georeference's Y-coordinate of the upper left corner of the upper left pixel. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
89 | | |
90 | | '''ST_Georeference(raster, text) -> string'''[[BR]] |
91 | | Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. For ESRI, [http://en.wikipedia.org/wiki/World_file see] for GDAL, [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 see]. |
92 | | |
93 | | |
94 | | '''ST_NumBands(raster) -> integer'''[[BR]] |
95 | | Return the number of band included in the raster. |
96 | | |
97 | | '''ST_BandPixelType(raster, integer) -> string'''[[BR]] |
98 | | Return the pixel type of the specified 1-based Nth band of raster. Band index is 1-based. The function returns one of the following values: |
| 62 | '''ST_SRID(raster|geometry) -> integer''' |
| 63 | |
| 64 | Returns the SRID associated with the raster. |
| 65 | |
| 66 | '''ST_Width(raster) -> integer''' |
| 67 | |
| 68 | Returns the width of the raster. |
| 69 | |
| 70 | '''ST_Height(raster) -> integer''' |
| 71 | |
| 72 | Returns the height of the raster. |
| 73 | |
| 74 | '''ST_PixelSizeX(raster) -> float64''' |
| 75 | |
| 76 | Returns the georeference's X pixel size of the raster. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
| 77 | |
| 78 | '''ST_PixelSizeY(raster) -> float64''' |
| 79 | |
| 80 | Returns the georeference's Y pixel size of the raster. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
| 81 | |
| 82 | '''ST_RotationX(raster) -> float64''' |
| 83 | |
| 84 | Returns the georeference's X rotation. |
| 85 | |
| 86 | '''ST_RotationY(raster) -> float64''' |
| 87 | |
| 88 | Returns the georeference's Y rotation. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
| 89 | |
| 90 | '''ST_UpperLeftX(raster) -> float64''' |
| 91 | |
| 92 | Returns the georeference's X-coordinate of the upper left corner of the upper left pixel. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
| 93 | |
| 94 | '''ST_UpperLeftY(raster) -> float64''' |
| 95 | |
| 96 | Returns the georeference's Y-coordinate of the upper left corner of the upper left pixel. [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 See]. |
| 97 | |
| 98 | '''ST_Georeference(raster, text) -> string''' |
| 99 | |
| 100 | Returns the georeference meta data in GDAL or ESRI format as commonly seen in a world file. For ESRI, [http://en.wikipedia.org/wiki/World_file see] for GDAL, [http://www.gdal.org/classGDALDataset.html#f9593cc241e7d140f5f3c4798a43a668 see]. |
| 101 | |
| 102 | |
| 103 | '''ST_NumBands(raster) -> integer''' |
| 104 | |
| 105 | Returns the number of band included in the raster. |
| 106 | |
| 107 | '''ST_BandPixelType(raster, integer) -> string''' |
| 108 | |
| 109 | Returns the pixel type of the specified 1-based Nth band of raster. Band index is 1-based. The function returns one of the following values: |
337 | | '''ST_Metadata(raster) -> record'''[[BR]] |
338 | | Returns all the metadata associated with a raster (upper left x, upper left y, width, height, pixelsize x, pixelsize y, skew x, skew y, srid, numbands in this order). Does not include any band metadata. If you want band metadata, add ST_BandMetadata(raster, integer) to your query. |
339 | | |
340 | | It should be used like this: "SELECT (md).* FROM (SELECT ST_Metadata(rast) AS md FROM myrastertable) foo" |
341 | | |
342 | | '''ST_BandMetadata(raster, integer) -> record'''[[BR]] |
343 | | Returns all the metadata associated with a raster band (pixeltype, has nodata value, nodata value, is stored out-db, path, in this order). Does not include embedding raster metadata. If you want embedding raster metadata, add ST_Metadata(raster) to your query. |
344 | | |
345 | | It should be used like this: "SELECT (bmd).* FROM (SELECT ST_BandMetadata(rast) AS bmd FROM myrastertable) foo" |
| 368 | '''ST_Metadata(raster) -> record''' |
| 369 | |
| 370 | Returns all the metadata associated with a raster (upper left x, upper left y, width, height, pixelsize x, pixelsize y, skew x, skew y, srid, numbands in this order). Does not include any band metadata. If you want band metadata, add ST_BandMetadata(raster, integer) to your query. |
| 371 | |
| 372 | It should be used like this: "SELECT (md).* FROM (SELECT ST_Metadata(rast) AS md FROM myrastertable) foo" |
| 373 | |
| 374 | '''ST_BandMetadata(raster, integer) -> record''' |
| 375 | |
| 376 | Returns all the metadata associated with a raster band (pixeltype, has nodata value, nodata value, is stored out-db, path, in this order). Does not include embedding raster metadata. If you want embedding raster metadata, add ST_Metadata(raster) to your query. |
| 377 | |
| 378 | It should be used like this: "SELECT (bmd).* FROM (SELECT ST_BandMetadata(rast) AS bmd FROM myrastertable) foo" |
350 | | '''ST_World2RasterCoordX(rast raster, xw float8, yw float8)'''[[BR]] |
351 | | Returns the column number of the pixel covering the provided X and Y world coordinates. |
352 | | This function works even if the world coordinates are outside the raster extent. |
353 | | |
354 | | '''ST_World2RasteCoordX(rast raster, xw float8)'''[[BR]] |
355 | | Returns the column number of the pixels covering the provided world X coordinate for a non-rotated raster. |
356 | | This function works even if the world coordinate is outside the raster extent. |
357 | | This function returns an error if the raster is rotated. In this case you must also provide a Y. |
358 | | |
359 | | '''ST_World2RasterCoordX(rast raster, pt geometry)'''[[BR]] |
360 | | Returns the column number of the pixel covering the provided point geometry. |
361 | | This function works even if the point is outside the raster extent. |
362 | | |
363 | | '''ST_World2RasterCoordY(rast raster, xw float8, yw float8)'''[[BR]] |
364 | | Returns the row number of the pixel covering the provided X and Y world coordinates. |
365 | | This function works even if the world coordinates are outside the raster extent. |
366 | | |
367 | | '''ST_World2RasterCoordY(rast raster, yw float8)'''[[BR]] |
368 | | Returns the row number of the pixels covering the provided world Y coordinate for a non-rotated raster. |
369 | | This function works even if the world coordinate is outside the raster extent. |
370 | | This function returns an error if the raster is rotated. In this case you must also provide an X. |
371 | | |
372 | | '''ST_World2RasterCoordY(rast raster, pt geometry)'''[[BR]] |
373 | | Returns the row number of the pixel covering the provided point geometry. |
374 | | This function works even if the point is outside the raster extent. |
375 | | |
376 | | '''ST_Raster2WorldCoordX(rast raster, xr int, yr int)'''[[BR]] |
377 | | Returns the X world coordinate of the upper left corner of the pixel located at the provided column and row numbers. |
378 | | This function works even if the provided raster column and row are beyond or below the raster width and height. |
379 | | |
380 | | |
381 | | '''ST_Raster2WorldCoordX(rast raster, xr int)'''[[BR]] |
382 | | Returns the X world coordinate of the upper left corner of the pixel located at the provided column number for a non-rotated raster. |
383 | | This function works even if the provided raster column is beyond or below the raster width. |
384 | | This function returns an error if the raster is rotated. In this case you must also provide a Y. |
385 | | |
386 | | '''ST_Raster2WorldCoordY(rast raster, xr int, yr int)'''[[BR]] |
387 | | Returns the Y world coordinate of the upper left corner of the pixel located at |
388 | | the provided column and row numbers. |
389 | | This function works even if the provided raster column and row are beyond or below the raster width and height. |
390 | | |
391 | | '''ST_Raster2WorldCoordY(rast raster, yr int)'''[[BR]] |
392 | | Returns the Y world coordinate of the upper left corner of the pixel located at the provided row number for a non-rotated raster. |
393 | | This function works even if the provided raster row is beyond or below the raster height. |
394 | | This function returns an error if the raster is rotated. In this case you must |
395 | | also provide an X. |
| 383 | '''ST_World2RasterCoordX(rast raster, xw float8, yw float8)''' |
| 384 | |
| 385 | Returns the column number of the pixel covering the provided X and Y world coordinates. |
| 386 | |
| 387 | This function works even if the world coordinates are outside the raster extent. |
| 388 | |
| 389 | '''ST_World2RasteCoordX(rast raster, xw float8)''' |
| 390 | |
| 391 | Returns the column number of the pixels covering the provided world X coordinate for a non-rotated raster. |
| 392 | |
| 393 | This function works even if the world coordinate is outside the raster extent. It returns an error if the raster is rotated. In this case you must also provide a Y. |
| 394 | |
| 395 | '''ST_World2RasterCoordX(rast raster, pt geometry)''' |
| 396 | |
| 397 | Returns the column number of the pixel covering the provided point geometry. |
| 398 | |
| 399 | This function works even if the point is outside the raster extent. |
| 400 | |
| 401 | '''ST_World2RasterCoordY(rast raster, xw float8, yw float8)''' |
| 402 | |
| 403 | Returns the row number of the pixel covering the provided X and Y world coordinates. |
| 404 | |
| 405 | This function works even if the world coordinates are outside the raster extent. |
| 406 | |
| 407 | '''ST_World2RasterCoordY(rast raster, yw float8)''' |
| 408 | |
| 409 | Returns the row number of the pixels covering the provided world Y coordinate for a non-rotated raster. |
| 410 | |
| 411 | This function works even if the world coordinate is outside the raster extent. It returns an error if the raster is rotated. In this case you must also provide an X. |
| 412 | |
| 413 | '''ST_World2RasterCoordY(rast raster, pt geometry)''' |
| 414 | |
| 415 | Returns the row number of the pixel covering the provided point geometry. |
| 416 | |
| 417 | This function works even if the point is outside the raster extent. |
| 418 | |
| 419 | '''ST_Raster2WorldCoordX(rast raster, xr int, yr int)''' |
| 420 | |
| 421 | Returns the X world coordinate of the upper left corner of the pixel located at the provided column and row numbers. |
| 422 | |
| 423 | This function works even if the provided raster column and row are beyond or below the raster width and height. |
| 424 | |
| 425 | |
| 426 | '''ST_Raster2WorldCoordX(rast raster, xr int)''' |
| 427 | |
| 428 | Returns the X world coordinate of the upper left corner of the pixel located at the provided column number for a non-rotated raster. |
| 429 | |
| 430 | This function works even if the provided raster column is beyond or below the raster width. It returns an error if the raster is rotated. In this case you must also provide a Y. |
| 431 | |
| 432 | '''ST_Raster2WorldCoordY(rast raster, xr int, yr int)''' |
| 433 | |
| 434 | Returns the Y world coordinate of the upper left corner of the pixel located at the provided column and row numbers. |
| 435 | |
| 436 | This function works even if the provided raster column and row are beyond or below the raster width and height. |
| 437 | |
| 438 | '''ST_Raster2WorldCoordY(rast raster, yr int)''' |
| 439 | |
| 440 | Returns the Y world coordinate of the upper left corner of the pixel located at the provided row number for a non-rotated raster. |
| 441 | |
| 442 | This function works even if the provided raster row is beyond or below the raster height. It returns an error if the raster is rotated. In this case you must also provide an X. |