D 2021-02-05T18:49:49.802
L sql_reference_list
P 52251b621db28cd27f9a51cc6061f512e37013ce
U sandro
W 159786
Back to <a href="https://www.gaia-gis.it/fossil/librasterlite2/wiki?name=rasterlite2-doc">RasterLite2 doc index</a><hr><br>

<h1>Work in progress</h1>

<h1>RasterLite2 SQL functions - reference list</h1>
<hr>
<h2>SQL functions supporting Version and Architecture</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_Version</b> () : <i>String</i></td>
<td>Will return the version of RasterLite2 currently in use.</td>
</tr>
<tr>
<td><b>RL2_Target_CPU</b> () : <i>String</i></td>
<td>Will return the name of the CPU architecture currently in use.</td>
</tr>
<tr>
<td><b>RL2_Cairo_Version</b> () : <i>String</i></td>
<td>Will return the version of libcairo currently in use.</td>
</tr>
<tr>
<td><b>RL2_Curl_Version</b> () : <i>String</i></td>
<td>Will return the version of libcurl currently in use.</td>
</tr>
<tr>
<td><b>RL2_Zlib_Version</b> () : <i>String</i></td>
<td>Will return the version of zlib (<i>DEFLATE</i>) currently in use.</td>
</tr>
<tr>
<td><b>RL2_LZMA_Version</b> () : <i>String</i></td>
<td>Will return the version of liblzma currently in use.</td>
</tr>
<tr>
<td><b>RL2_LZ4_Version</b> () : <i>String</i></td>
<td>Will return the version of liblz4 currently in use.</td>
</tr>
<tr>
<td><b>RL2_ZSTD_Version</b> () : <i>String</i></td>
<td>Will return the version of libzstd currently in use.</td>
</tr>
<tr>
<td><b>RL2_PNG_Version</b> () : <i>String</i></td>
<td>Will return the version of libpng currently in use.</td>
</tr>
<tr>
<td><b>RL2_JPEG_Version</b> () : <i>String</i></td>
<td>Will return the version of libjpeg (or libjpeg-turbo) currently in use.</td>
</tr>
<tr>
<td><b>RL2_TIFF_Version</b> () : <i>String</i></td>
<td>Will return the version of libtiff currently in use.</td>
</tr>
<tr>
<td><b>RL2_GeoTIFF_Version</b> () : <i>String</i></td>
<td>Will return the version of libgeotiff currently in use.</td>
</tr>
<tr>
<td><b>RL2_WEBP_Version</b> () : <i>String</i></td>
<td>Will return the version of libwebp currently in use.</td>
</tr>
<tr>
<td><b>RL2_OpenJPEG_Version</b> () : <i>String</i></td>
<td>Will return the version of libopenjp2 (<i>Jpeg2000</i>) currently in use.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions testing which codecs are actually supported by the library</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_has_codec_none</b> () : <i>Boolean</i></td>
<td>Tests if the NONE codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_deflate</b> () : <i>Boolean</i></td>
<td>Tests if the DEFLATE (zip: with Delta Filter) codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_deflate_no</b> () : <i>Boolean</i></td>
<td>Tests if the DEFLATE_NO (zip: without Delta Filter) codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_lzma</b> () : <i>Boolean</i></td>
<td>Tests if the LZMA (7-zip: with Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_lzma_no</b> () : <i>Boolean</i></td>
<td>Tests if the LZMA_NO (7-zip: without Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_lz4</b> () : <i>Boolean</i></td>
<td>Tests if the LZ4 (fast lossless: with Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_lz4_no</b> () : <i>Boolean</i></td>
<td>Tests if the LZ4_NO (fast loseless: without Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_zstd</b> () : <i>Boolean</i></td>
<td>Tests if the ZSTD (Zstandard: with Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_zstd_no</b> () : <i>Boolean</i></td>
<td>Tests if the ZSTD_NO (Zstandard: without Delta Filter) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_png</b> () : <i>Boolean</i></td>
<td>Tests if the PNG codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_jpeg</b> () : <i>Boolean</i></td>
<td>Tests if the JPEG codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_fax4</b> () : <i>Boolean</i></td>
<td>Tests if the FAX4 codec is currently supported.
<br>Will costantly return 1 (TRUE).</td>
</tr>
<tr>
<td><b>RL2_has_codec_webp</b> () : <i>Boolean</i></td>
<td>Tests if the WebP (lossy) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_ll_webp</b> () : <i>Boolean</i></td>
<td>Tests if the WebP (lossless) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_jp2</b> () : <i>Boolean</i></td>
<td>Tests if the OpenJpeg (Jpeg2000 lossy) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
<tr>
<td><b>RL2_has_codec_ll_jp2</b> () : <i>Boolean</i></td>
<td>Tests if the OpenJpeg (Jpeg2000 lossless) codec is currently supported.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions controlling parallel execution</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_GetMaxThreads</b> () : <i>Integer</i></td>
<td>Will return the currently set MAX number of concurrent threads allowed for parallel execution.</td>
</tr>
<tr>
<td><b>RL2_SetMaxThreads</b> ( <b>max</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will set the MAX number of concurrent threads allowed for parallel execution.<br>
Will return the MAX number of concurrent threads after this call.</td>
</tr>
<tr><td bgcolor="d0ffd0" colspan="2">
<h2>Note</h2>
The MAX number of concurrent threads is a <b>global option</b> set at the <b>DB connection</b> level.<br>
Once set, it will influence any subsequent call to any SQL function supporting parallel execution.<br>
The initial value for any new <b>connection</b> is always <b>0</b>, that is no parallel execution at all.
</td></tr>
</table><br>
<hr>
<h2>SQL functions controlling WMS requests</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_GetMaxWmsRetries</b> () : <i>Integer</i></td>
<td>Will return the currently set MAX number of retries allowed for for each failing WMS request.</td>
</tr>
<tr>
<td><b>RL2_SetMaxWmsRetries</b> ( <b>max</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will set the MAX number of retries allowed for each failing WMS request.<br>
Will return the MAX number of WMS retries after this call.</td>
</tr>
<tr>
<td><b>RL2_GetWmsPause</b> () : <i>Integer</i></td>
<td>Will return the currently set pause time (expressed in milliseconds) between a failing WMS request and the next retry.</td>
</tr>
<tr>
<td><b>RL2_SetWmsPause</b> ( <b>millis</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will set the pause time (expressed in milliseconds) between a failing WMS request and the next retry.<br>
Will return the pause time after this call.</td>
</tr>
<tr><td bgcolor="d0ffd0" colspan="2">
<h2>Note</h2>
The WMS options are <b>global optiosn</b> set at the <b>DB connection</b> level.<br>
Once set, they will influence any subsequent call to any SQL function performing WMS requests either directly or indirectly.<br>
The initial default values for any new <b>connection</b> are:
<ul>
<li>Max retries: <b>5</b></li>
<li>Pause: <b>5</b> <i>milliseconds</i></li>
</ul>
</td></tr>
</table><br>
<hr>
<h2>SQL functions controlling the standard PDF page format</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_GetPdfMarginUOM</b> () : <i>String</i></td>
<td>Will return the currently set <b>U</b>nit <b>O</b>f <b>Measure</b> for PDF page dimensions. Valid values are:
<ul>
<li><b>mm</b> <i>millimeters</i></li>
<li><b>in</b> <i>inches</i></li>
</ul></td>
</tr>
<tr>
<td><b>RL2_SetPdfMarginUOM</b> ( <b>uom</b> <i>String</i> ) : <i>Integer</i></td>
<td>Will set the <b>U</b>nit <b>O</b>f <b>Measure</b> for PDF page dimensions. Valid values are:
<ul>
<li><b>mm</b> <i>millimeters</i></li>
<li><b>in</b> <i>inches</i></li>
</ul>.<br>
Will return the PDF page UOM after this call.</td>
</tr>
<tr>
<td><b>RL2_GetPdfMarginsHorz</b> () : <i>Integer</i></td>
<td>Will return the currently set <b>horizontal margin</b> (both left and right) measured in the currently set UOM.</td>
</tr>
<tr>
<td><b>RL2_SetPdfMarginHorz</b> ( <b>size</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will set the <b>horizontal margin</b> (both left and right) measured in the currently set UOM.<br>
Will return the vertical margin size after this call.</td>
</tr>
<tr>
<td><b>RL2_GetPdfMarginsVert</b> () : <i>Integer</i></td>
<td>Will return the currently set <b>vertical margin</b> (both upper and lower) measured in the currently set UOM.</td>
</tr>
<tr>
<td><b>RL2_SetPdfMarginVert</b> ( <b>size</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will set the <b>vertical margin</b> (both upper and lower) measured in the currently set UOM.<br>
Will return the vertical margin size after this call.</td>
</tr>
<tr>
<td><b>RL2_GetPdfPaperFormat</b> () : <i>String</i></td>
<td>Will return the currently set PDF page format. Valid values are <b>A0</b>, <b>A1</b>, <b>A2</b>, <b>A3</b>, <b>A4</b> and <b>A5</b></td>
</tr>
<tr>
<td><b>RL2_SetPdfPaperFormat</b> ( <b>format</b> <i>String</i> ) : <i>Integer</i></td>
<td>Will set the PDF page format. Valid values areare <b>A0</b>, <b>A1</b>, <b>A2</b>, <b>A3</b>, <b>A4</b> and <b>A5</b>.<br>
Will return the PDF page format after this call.</td>
</tr>
<tr>
<tr><td bgcolor="d0ffd0" colspan="2">
<h2>Note</h2>
The MAX number of concurrent threads is a <b>global option</b> set at the <b>DB connection</b> level.<br>
Once set, it will influence any subsequent call to any SQL function supporting parallel execution.<br>
The initial value for any new <b>connection</b> is always <b>0</b>, that is no parallel execution at all.
</td></tr>
</table><br>
<hr>


<h2>SQL functions controlling Text Symbolizers (Map Labels)</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_IsAntiLabelCollisionEnabled</b> () : <i>Boolean</i></td>
<td>Tests if the AntiLabelCollision global option is currently activated or not.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.</td></td>
</tr>
<tr>
<td><b>RL2_EnableAntiLabelCollision</b> () : <i>Boolean</i></td>
<td>Activates the AntiLabelCollision global option.
<br>Same return value as in RL2_IsAntiLabelCollisionEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_DisableAntiLabelCollision</b> () : <i>Boolean</i></td>
<td>Deactivates the AntiLabelCollision global option.
<br>Same return value as in RL2_IsAntiLabelCollisionEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_IsLabelWrapTextEnabled</b> () : <i>Boolean</i></td>
<td>Tests if the LabelWrapText global option is currently activated or not.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.</td></td>
</tr>
<tr>
<td><b>RL2_EnableLabelWrapText</b> () : <i>Boolean</i></td>
<td>Activates the LabelWrapText global option.
<br>Same return value as in RL2_IsLabelWrapTextEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_DisableLabelWrapText</b> () : <i>Boolean</i></td>
<td>Deactivates the LabelWrapText global option.
<br>Same return value as in RL2_IsLabelWrapTextEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_IsLabelAutorotateEnabled</b> () : <i>Boolean</i></td>
<td>Tests if the LabelAutorotate global option is currently activated or not.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.</td></td>
</tr>
<tr>
<td><b>RL2_EnableLabelAutorotate</b> () : <i>Boolean</i></td>
<td>Activates the LabelAutorotate global option.
<br>Same return value as in RL2_IsLabelAutorotateEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_DisableLabelAutorotate</b> () : <i>Boolean</i></td>
<td>Deactivates the LabelAutorotate global option.
<br>Same return value as in RL2_IsLabelAutorotateEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_IsLabelShifPositionEnabled</b> () : <i>Boolean</i></td>
<td>Tests if the LabelShifPosition global option is currently activated or not.
<br>Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.</td></td>
</tr>
<tr>
<td><b>RL2_EnableLabelShifPosition</b> () : <i>Boolean</i></td>
<td>Activates the LabelShifPosition global option.
<br>Same return value as in RL2_IsLabelShifPositionEnabled()</td></td>
</tr>
<tr>
<td><b>RL2_DisableLabelShifPosition</b> () : <i>Boolean</i></td>
<td>Deactivates the LabelShifPosition global option.
<br>Same return value as in RL2_IsLabelShifPositionEnabled()</td></td>
</tr>
<tr><td bgcolor="d0ffd0" colspan="2">
<h2>Note</h2>
All the above <b>global options</b> are set at the <b>DB connection</b> level.<br>
Once set, each one of them will influence any subsequent call to any SQL function supporting Text Symbolizers.<br>
The initial value for any new <b>connection</b> is always <b>0</b> for all them, that is no special Text/Label options at all.
</td></tr>
</table><br>
<hr>
<h2>SQL functions supporting BLOB serialized Pixel objects</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_IsValidPixel</b> ( <b>pixel</b> <i>BLOB</i> , <b>sampleType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>pixel</i></b> object for validity.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_CreatePixel</b> ( <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will return a BLOB corresponding to a Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.<br>
All Pixel components will be initially set to <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetPixelType</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>String</i></td>
<td>Will return the mnemonic PixelType from a Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPixelSampleType</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>String</i></td>
<td>Will return the mnemonic SampleType from a Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPixelNumBands</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will return the number of Bands from a Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPixelValue</b> ( <b>pixel</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_GetPixelValue</b> ( <b>pixel</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the current sampleValue (data-type will match the Pixel's sampleType) from a Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_SetPixelValue</b> ( <b>pixel</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> , <b>sampleValue</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_SetPixelValue</b> ( <b>pixel</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> , <b>sampleValue</b> <i>Double</i> ) : <i>BLOB</i></td>
<td>Will return a new BLOB corresponding to a Pixel serialized object supporting the requested sampleValue (which is expected to respect the precision declared by the sampleType): <b>NULL</b> will be returned on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_IsTransparentPixel</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>pixel</i></b> object for transparency.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_IsOpaquePixel</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>pixel</i></b> object for opacity.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_SetTransparentPixel</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>BLOB</i></td>
<td>Will return a new BLOB corresponding to a transparent Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_SetOpaquePixel</b> ( <b>pixel</b> <i>BLOB</i> ) : <i>BLOB</i></td>
<td>Will return a new BLOB corresponding to an opaque Pixel serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_PixelEquals</b> ( <b>pixel_1</b> <i>BLOB</i> , <b>pixel_2</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will compare two BLOB serialized <b><i>pixel</i></b> objects for identity.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPixelFromRasterByPoint</b> ( <b>db_prefix</b> <i>Text</i> , <b>coverage</b> <i>Text</i> , <b>point</b> <i>BLOB-Geom</i> , <b>pyramyd_level</b> <i>Integer</i> ) : <i>BLOB-Pixel</i><br><br>
<b>RL2_GetPixelFromRasterByPoint</b> ( <b>db_prefix</b> <i>Text</i> , <b>coverage</b> <i>Text</i> , <b>point</b> <i>BLOB-Geom</i> , <b>horz_res</b> <i>Double/i> , <b>vert_res</b> <i>Double</i> ) : <i>BLOB-Pixel</i></td>
<td>Will extract from the Raster Coverage identified by <b>db_prefix</b> and <b>coverage</b> the pixel matching the map coordinates specified by <b>point</b>:
<ul>
<li>a <b>NULL db_prefix</b> will be automatically interpreted as <b>'MAIN'</b>.</li>
<li>the <b>point</b> Geometry must identify a single POINT.<br>
If the SRID declared by <b>point</b> isn't the same declared by the Raster Coverage then <b>point</b> will be automatically reprojected into the Raster Coverage own SRID.</li>
</ul><br>
Will return a BLOB serialized <b><i>pixel</i></b> object or <b>NULL</b> on invalid arguments or if any error occurred.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions supporting BLOB serialized Palette objects</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_IsValidRasterPalette</b> ( <b>palette</b> <i>BLOB</i> , <b>sampleType</b> <i>String</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>palette</i></b> object for validity.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPaletteNumEntries</b> ( <b>palette</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will return the number of color entries from a Palette serialized object: <b>NULL</b> will be returned on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetPaletteColorEntry</b> ( <b>palette</b> <i>BLOB</i> , <b>entryIndex</b> <i>Integer</i> ) : <i>String</i></td>
<td>Will return the current color (HEX-RGB format) from a serialized Palette object Entry: <b>NULL</b> will be returned on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Palette Entry always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_SetPaletteColorEntry</b> ( <b>palette</b> <i>BLOB</i> , <b>entryIndex</b> <i>Integer</i> , <b>hexRgbColor</b> <i>String</i> ) : <i>BLOB</i></td>
<td>Will return a new BLOB corresponding to a Palette serialized object supporting the changed color Entry.
The color is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b>.<br>
<b>NULL</b> will be returned on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Palette Entry always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_PaletteEquals</b> ( <b>palette_1</b> <i>BLOB</i> , <b>palette_2</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will compare two BLOB serialized <b><i>palette</i></b> objects for identity.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions supporting BLOB serialized Raster/Band Statistics objects</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_IsValidRasterStatistics</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>rasterStatistics</b> <i>BLOB</i> ) : <i>Integer</i><br><br>
<b>RL2_IsValidRasterStatistics</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>sampleType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>rasterStatistics</i></b> object for validity.<br>
The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetRasterStatistics_NoDataPixelsCount</b> ( <b>rasterStatistics</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will return the total count of NoData pixels from a BLOB serialized <b><i>rasterStatistics</i></b> object: <b>NULL</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetRasterStatistics_ValidPixelsCount</b> ( <b>rasterStatistics</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will return the total count of valid pixels (excluding NoData pixels) from a BLOB serialized <b><i>rasterStatistics</i></b> object: <b>NULL</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetRasterStatistics_SampleType</b> ( <b>rasterStatistics</b> <i>BLOB</i> ) : <i>String</i></td>
<td>Will return the mnemonic SampleType from a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetRasterStatistics_BandsCount</b> ( <b>rasterStatistics</b> <i>BLOB</i> ) : <i>String</i></td>
<td>Will return the total number of supported Bands from a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_Min</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the Minimum value from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_Max</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the Maximum value from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_Avg</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the Average/Mean value from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_Var</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the estimated Variance value from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_StdDev</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>Double</i></td>
<td>Will return the estimated Standard Deviation value from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
<tr>
<td><b>RL2_GetBandStatistics_Histogram</b> ( <b>rasterStatistics</b> <i>BLOB</i> , <b>bandIndex</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will return a BLOB corresponding to a PNG image representing the estimated distribution Histogram from a specific Band of a <b><i>rasterStatistics</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b>.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions supporting BLOB serialized rasterTile objects</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_IsValidRasterTile</b> ( <b>dbPrefix</b> <i>String</i> ,  <b>coverageName</b> <i>String</i> , <b>pyramidLevel</b> <i>Integer</i>, <b>tileOdd</b> <i>BLOB</i> , <b>tileEven</b> <i>BLOB</i> ) : <i>Integer</i></td>
<td>Will test a BLOB serialized <b><i>rasterTile</i></b> object for validity.<br>
The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.<br>
Will return <b>1</b> (TRUE) or <b>0</b> (FALSE): or <b>-1</b> on invalid arguments or if any error occurred.</td>
</tr>
<tr>
<td><b>RL2_GetTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will return a BLOB corresponding to a PNG image (visual preview) from a <b><i>rasterTile</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br>
The mandatory <b><i>dbPrefix</i></b> argument could eventually be <b>NULL</b> and in this case the <b>MAIN DB</b> will implicitly be assumed.<br>
<u>Please note</u>: for pixelTypes lacking any implicit photometric interpretation (i.e. DATAGRID) a default Grayscale interpretation will be silently assumed.
For Raster Tiles of the MULTIBAND type a default Grayscale interpretation of the <b>first band only</b> will be silently assumed.</td>
</tr>
<tr>
<td><b>RL2_GetTripleBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetTripleBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetTripleBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will return a BLOB corresponding to a PNG image (visual preview) from a <b><i>rasterTile</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br>
The mandatory <b><i>dbPrefix</i></b> argument could eventually be <b>NULL</b> and in this case the <b>MAIN DB</b> will implicitly be assumed.<br>
The <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB PNG starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b><br><br>
The optional <b><i>bgColor</i></b> argument is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b> (default is '#ffffff' i.e. full white).<br>
The second optional <b><i>transparent</i></b> argument is expected to be expressed as a Boolean value (default is <b>0</b> FALSE).<br>
<u>Please note very well</u>: this SQL function will only accept Raster Tiles of the MULTIBAND or RGB type.</td>
</tr>
<tr>
<td><b>RL2_GetMonoBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMonoBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMonoBandTileImage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>tileID</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will return a BLOB corresponding to a PNG image (visual preview) from a <b><i>rasterTile</i></b> serialized object: <b>NULL</b> on invalid arguments or if any error occurred.<br>
The mandatory <b><i>dbPrefix</i></b> argument could eventually be <b>NULL</b> and in this case the <b>MAIN DB</b> will implicitly be assumed.<br>
The <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale PNG starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b><br><br>
The optional <b><i>bgColor</i></b> argument is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b> (default is '#ffffff' i.e. full white).<br>
The second optional <b><i>transparent</i></b> argument is expected to be expressed as a Boolean value (default is <b>0</b> FALSE).<br>
<u>Please note</u>: for pixelTypes lacking any implicit photometric interpretation (i.e. DATAGRID) a default Grayscale interpretation will be silently assumed.<br>
<u>Please note very well</u>: this SQL function will only accept Raster Tiles of the MULTIBAND or RGB type.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions supporting Coverage and Section management</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr>
<td><b>RL2_CreateRasterCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> , <b>compressionType</b> <i>String</i> ,
<b>quality</b> <i>Integer</i> , <b>tileWidth</b> <i>Integer</i> ,
<b>tileHeight</b> <i>Integer</i> , <b>SRID</b> <i>Integer</i> , 
<b>pixelResolution</b> </i>Double</i> ) : <i>Integer</i><br><br><b>RL2_CreateRasterCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> , <b>compressionType</b> <i>String</i> ,
<b>quality</b> <i>Integer</i> , <b>tileWidth</b> <i>Integer</i> ,
<b>tileHeight</b> <i>Integer</i> , <b>SRID</b> <i>Integer</i> , 
<b>horzPixelResolution</b> </i>Double</i> , 
<b>vertPixelResolution</b> </i>Double</i> ) : <i>Integer</i><br><br><b>RL2_CreateRasterCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> , <b>compressionType</b> <i>String</i> ,
<b>quality</b> <i>Integer</i> , <b>tileWidth</b> <i>Integer</i> ,
<b>tileHeight</b> <i>Integer</i> , <b>SRID</b> <i>Integer</i> , 
<b>horzPixelResolution</b> </i>Double</i> , 
<b>vertPixelResolution</b> </i>Double</i> ,
<b>noDataPixel</b> <i>BLOB</i> ) : <i>Integer</i><br><br><b>RL2_CreateRasterCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> , <b>compressionType</b> <i>String</i> ,
<b>quality</b> <i>Integer</i> , <b>tileWidth</b> <i>Integer</i> ,
<b>tileHeight</b> <i>Integer</i> , <b>SRID</b> <i>Integer</i> , 
<b>horzPixelResolution</b> </i>Double</i> , 
<b>vertPixelResolution</b> </i>Double</i> ,
<b>noDataPixel</b> <i>BLOB</i> , <b>strictResolution</b> <i>Integer</i> , <b>mixedResolutions</b> <i>Integer</i> , <b>sectionPaths</b> <i>Integer</i> , <b>sectionMD5</b> <i>Integer</i> , <b>sectionSummary</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_CreateRasterCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>sampleType</b> <i>String</i> , <b>pixelType</b> <i>String</i> , <b>numBands</b> <i>Integer</i> , <b>compressionType</b> <i>String</i> ,
<b>quality</b> <i>Integer</i> , <b>tileWidth</b> <i>Integer</i> ,
<b>tileHeight</b> <i>Integer</i> , <b>SRID</b> <i>Integer</i> , 
<b>horzPixelResolution</b> </i>Double</i> , 
<b>vertPixelResolution</b> </i>Double</i> ,
<b>noDataPixel</b> <i>BLOB</i> , <b>strictResolution</b> <i>Integer</i> , <b>mixedResolutions</b> <i>Integer</i> , <b>sectionPaths</b> <i>Integer</i> , <b>sectionMD5</b> <i>Integer</i> , <b>sectionSummary</b> <i>Integer</i> , <b>is_queryable</b> <i>Integer</i> ) : <i>Integer</i>
</td>
<td>Will attempt to create a new Raster Coverage within the currently connected DB-file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: you can use the second form to create a Raster Coverage requiring <b><i>rectangular</i></b> pixels.<br><br>
The third form allows to explicitly declare a NoData value; in this case the last argument is expected to correspond to a Pixel serialized object exactly matching the Coverage's pixel model.<br><br>
The fourth form allows to explicitly set <b><i>Policies Options</i></b> (always disabled by default). Each single Option corresponds to a <i><b>boolean</b></i> value (FALSE=disabled / TRUE=enabled).<br><br>
The fifth and final form allows to explicitly state if the Coverage is <b>queryable</b> or not (always set to <b>FALSE</b> by default).
</td>
</tr>
<tr>
<td><b>RL2_SetCoverageInfos</b> ( <b>coverageName</b> <i>String</i> , <b>title</b> <i>String</i> , <b>abstract</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_SetCoverageInfos</b> ( <b>coverageName</b> <i>String</i> , <b>title</b> <i>String</i> , <b>abstract</b> <i>String</i> , <b>is_queryable</b> <i>Integer</i> ) : <i>Integer</i>
</td>
<td>Inserts (or updates) the descriptive infos associated to a Coverage.
<ul>
<li><b>coverage_name</b> must identify an existing Coverage.</li>
<li><b>title</b> and <b>abstract</b> represent the descriptive infos to be set.</li>
<li>the optional argument <b>is_queryable</b> (expected to be of the Boolean type) determines if the Coverage is queryable or not; if omitted the Coverage will preserve the already defined value.</li>
</ul><hr>
the return type is Integer, with a return value of 1 for TRUE (success) or 0 for FALSE (failure): -1 will be returned on invalid argumentes.</td>
</tr>
<tr>
<td><b>RL2_SetRasterCoverageCopyright</b> ( <b>coverageName</b> <i>String</i> , <b>copyright</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_SetRasterCoverageCopyright</b> ( <b>coverageName</b> <i>String</i> , <b>copyright</b> <i>String</i> , <b>license</b> <i>String</i> ) : <i>Integer</i>
</td>
<td>Inserts (or updates) Copyright and License infos associated to a Coverage.
<ul>
<li><b>coverage_name</b> must identify an existing Coverage.</li>
<li><b>copyright</b> identifies the Copyright holder; if <b>NULL</b> the current value will be preserved.</li>
<li>the optional argument <b>license</b> must reference one the Data Licenses registered into the <b>data_licenses</b> table, as e.g. <i>CC0 1.0</i> or <i>CC BY 4.0</i>.</li>
</ul><hr>
the return type is Integer, with a return value of 1 for TRUE (success) or 0 for FALSE (failure): -1 will be returned on invalid argumentes.</td>
</tr>
<tr>
<td><b>RL2_DropCoverage</b> ( <b>coverageName</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_DropCoverage</b> ( <b>coverageName</b> <i>String</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt do completely remove a Raster Coverage (including all related Sections, Pyramids and Tiles) from the currently connected DB-file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: if the second optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</td>
</tr>
<tr>
<td>
<b>RL2_CopyRasterCoverage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> ) : <i>Integer</i>
<br><br>
<b>RL2_CopyRasterCoverage</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>transaction</b> <i>boolean</i> ) : <i>Integer</i>
</td>
<td>
Will copy a complete Raster Coverage from an <b>attached DB</b> to the currently connected (<b>MAIN</b>) DB.
<ul>
<li>a valid Raster Coverage matching <b>coverageName</b> must exists within the Attached DB identified by <b>dbPrefix</b>.</li>
<li>no Raster Coverage matching <b>coverageName</b> must exists within the MAIN DB.<br>
It will be automatically created and populated as appropriate.</li>
</ul>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: if the third optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
</td>
</tr>
<tr>
<td><b>RL2_DeleteSection</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_DeleteSection</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt do completely remove a Raster Section (including a directly related Pyramid if present and all related Tiles) from the currently connected DB-file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: if the third optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</td>
</tr>
</table><br>
<hr>
<h2>SQL functions supporting Pyramid management</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr><td><b>RL2_Pyramidize</b> ( <b>coverageName</b> <i>String</i> ) : <i>Integer</i><br><br><b>RL2_Pyramidize</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> ) : <i>Integer</i><br><br><b>RL2_Pyramidize</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>forceRebuild</b> <i>Integer</i> ) : <i>Integer</i><br><br><b>RL2_Pyramidize</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>forceRebuild</b> <i>Integer</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt do (re)build <b><i>Section-based</i></b> Pyramid levels.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>if a single <b><i>sectionID</i></b> is specified, then only the Pyramid levels directly belonging to that Section will be considered.<br>
A <b>NULL</b> sectionID always implies processing the whole Coverage.</li>
<li>if the optional argument <b><i>forceRebuild</i></b> (expected to be of the Boolean type) any already existing Pyramid level will be immediately destroyed and then rebuild.
If not, all existing Pyramid levels will be left untouched and only eventually missing levels will be built.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul></td>
</tr>
<tr><td><b>RL2_PyramidizeMonolithic</b> ( <b>coverageName</b> <i>String</i> ) : <i>Integer</i><br><br><b>RL2_PyramidizeMonolithic</b> ( <b>coverageName</b> <i>String</i> , <b>virtualLevels</b> <i>Integer</i> ) : <i>Integer</i><br><br><b>RL2_PyramidizeMonolithic</b> ( <b>coverageName</b> <i>String</i> , <b>virtualLevels</b> <i>Integer</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt do (re)build Pyramid levels of the <b>Monolithic</b> type.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul><li>the whole Coverage will be always processed, and any eventually preexisting <b><i>Section-based</i></b> or <b><i>Monolithic</i></b> Pyramid will be destroyed in order to rebuild a new Pyramid from scratch.</li>
<li>the second optional argument <b><i>virtualLevels</i></b> allows to choose the preferred interleave factor between <i><u>physical</u></i> and <i><u>virtual</u></u> Levels. Acceptable values are <b>1</b>, <b>2</b> or <b>3</b>. The default setting is <b>3</b>, with the notable exception of <b>MONOCHROME 1-BIT</b> Coverages, in which case will be <b>1</b>.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul>
<u>Important Notice</u>: a Monolithic Pyramid is not compatible with any Coverage declared by enabling the <b>mixedResolution</b> Policy.</td>
</tr>
<tr><td><b>RL2_DePyramidize</b> ( <b>coverageName</b> <i>String</i> ) : <i>Integer</i><br><br><b>RL2_DePyramidize</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> ) : <i>Integer</i><br><br><b>RL2_DePyramidize</b> ( <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt do destroy Pyramid levels.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>if a single <b><i>sectionID</i></b> is specified, then only the Pyramid levels directly belonging to that Section will be considered (<i>only supported for <b>Section-based</b> Pyramids</i>).<br>
A <b>NULL</b> sectionID always implies processing the whole Coverage.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul></td>
</tr>
</table><br>
<hr>
<h2>SQL functions returning styled Maps</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr><td><b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> , <b>reaspect</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a Styled Map from a Coverage of the Raster type.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the Styled Map; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>styleName</i></b> could be eventually <b>'default'</b>, this corresponding to the implicit style supported for all Pixel Types except MULTIBAND (which always require some explicit style to be applied).</li>
<li>the BoundingBox is expected to exactly match the image's <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.<br>
Except when the optional argument <b><i>reaspect</i></b> is set to TRUE; in this later case each single axis could be independently rescaled.</li>
<li>the optional argument <b><i>mimeType</i></b> could be one of <b>'image/pdf'</b>, <b>'image/jpeg'</b>, <b>'image/tiff'</b> or <b>'application/x-pdf'</b>; default is <b>'image/png'</b>.</li>
<li>the optional <b><i>bgColor</i></b> argument is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b> (default is '#ffffff' i.e. full white).</li>
<li>the optional <b><i>transparent</i></b> argument is expected to be expressed as a Boolean value (default is <b>0</b> FALSE).<br>
<u>Please note</u>: transparency is supported uniquely by PNG images.</li>
<li>the optional argument <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>; default <b>80</b>) is meaningful only in the case of JPEG images.</li>
</ul>
</td></tr>
<tr><td><b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromRaster</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> , <b>reaspect</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a Styled Map from a Coverage of the Raster type.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br><br>
<u>Please note</u>: 
<ul>
<li>Almost all the arguments are the same as in <b>RL2_GetMapImageFromRaster()</b> and have identical interpretation.</li>
<li>The only exception being <b><i>xml_style</i></b> that is expected to contain a valid <b>SLD/SE XML Raster Symbolizer</b>.</li>
</ul><br>
<table cellspacing="8" cellpadding="8" bgcolor="#d0ffd0"><tr><td>
In other words:
<ul>
<li>Both <b>RL2_GetMapImageFromRaster()</b> and <b>RL2_GetStyledMapImageFromRaster()</b> are very similar in their general behavior. The main difference between them is:
<ul>
<li><b>RL2_GetMapImageFromRaster()</b> accepts the <b>name</b> of a registered Style.</li>
<li><b>RL2_GetStyledMapImageFromRaster()</b> directly accepts an <b>XML Style</b> definition.</li>
</ul></li>
</ul>
</td></tr></table>
</td></tr>
<tr><td><b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> , <b>reaspect</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a Styled Map from a Coverage of the Vector type.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the Styled Map; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>styleName</i></b> could be eventually <b>'default'</b>, this corresponding to the implicit style supported for all Pixel Types except MULTIBAND (which always require some explicit style to be applied).</li>
<li>the BoundingBox is expected to exactly match the image's <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.<br>
Except when the optional argument <b><i>reaspect</i></b> is set to TRUE; in this later case each single axis could be independently rescaled.</li>
<li>the optional argument <b><i>mimeType</i></b> could be one of <b>'image/pdf'</b>, <b>'image/jpeg'</b>, <b>'image/tiff'</b> or <b>'application/x-pdf'</b>; default is <b>'image/png'</b>.</li>
<li>the optional <b><i>bgColor</i></b> argument is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b> (default is '#ffffff' i.e. full white).</li>
<li>the optional <b><i>transparent</i></b> argument is expected to be expressed as a Boolean value (default is <b>0</b> FALSE).<br>
<u>Please note</u>: transparency is supported uniquely by PNG images.</li>
<li>the optional argument <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>; default <b>80</b>) is meaningful only in the case of JPEG images.</li>
</ul>
</td></tr>



<tr><td><b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetStyledMapImageFromVector</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>xml_style</b> <i>Text</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> , <b>quality</b> <i>Integer</i> , <b>reaspect</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a Styled Map from a Coverage of the Vector type.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br><br>
<u>Please note</u>: 
<ul>
<li>Almost all the arguments are the same as in <b>RL2_GetMapImageFromVector()</b> and have identical interpretation.</li>
<li>The only exception being <b><i>xml_style</i></b> that is expected to contain a valid <b>SLD/SE XML Vector Symbolizer</b>.</li>
</ul><br>
<table cellspacing="8" cellpadding="8" bgcolor="#d0ffd0"><tr><td>
In other words:
<ul>
<li>Both <b>RL2_GetMapImageFromVector()</b> and <b>RL2_GetStyledMapImageFromVector()</b> are very similar in their general behavior. The main difference between them is:
<ul>
<li><b>RL2_GetMapImageFromVector()</b> accepts the <b>name</b> of a registered Style.</li>
<li><b>RL2_GetStyledMapImageFromVector()</b> directly accepts an <b>XML Style</b> definition.</li>
</ul></li>
</ul>
</td></tr></table>
</td></tr>
<tr><td><b>RL2_GetMapImageFromWMS</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetMapImageFromWMS</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>version</b> <i>String</i> , <b>styleName</b> <i>String</i> , <b>mimeType</b> <i>String</i> , <b>bgColor</b> <i>String</i> , <b>transparent</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a Styled Map from a Coverage of the WMS type.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the Styled Map; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>version</i></b> argument determinws which version of the WMS protocol should be used.<br>
Valid values are: <b>1.0.0</b>, <b>1.1.0</b>, <b>1.1.1</b> and <b>1.3.0</b></li>
<li>the <b><i>styleName</i></b> could be eventually <b>'default'</b> (it depends on the specific capabilites declared from the remote server).</li>
<li>the BoundingBox is expected to exactly match the image's <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution..</li>
<li>the argument <b><i>mimeType</i></b> could usually be one of <b>'image/pdf'</b>, <b>'image/jpeg'</b> or <b>'image/tiff'</b> (it depends on the specific capabilites declared from the remote server).</li>
<li>the optional <b><i>bgColor</i></b> argument is expected to be expressed in the canonical WEB HEX-RGB form, as in <b>'#ff8080'</b> (default is '#ffffff' i.e. full white).</li>
<li>the optional <b><i>transparent</i></b> argument is expected to be expressed as a Boolean value (default is <b>0</b> FALSE).<br>
<u>Please note</u>: transparency is supported uniquely by PNG images.</li>
</ul>
</td></tr>
<tr><td><b>RL2_GetImageFromMapConfiguration</b> ( <b>configName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetImageFromMapConfiguration</b> ( <b>configName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>mimeType</b> <i>String</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetImageFromMapConfiguration</b> ( <b>configName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>mimeType</b> <i>String</i> , <b>quality</b> <i>Integer</i> ) : <i>BLOB</i><br><br>
<b>RL2_GetImageFromMapConfiguration</b> ( <b>configName</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>mimeType</b> <i>String</i> , <b>quality</b> <i>Integer</i> , <b>reaspect</b> <i>Integer</i> ) : <i>BLOB</i></td>
<td>Will attempt to create a digital image representing a complex, multi-layered Styled Map from a registered MapConfiguration.<br>
Will return a BLOB containing the Styled Map: or <b>NULL</b> on invalid arguments or if any error occurs.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>configName</i></b> argument is intended to specify which of the registered MapConfigurations should be used.<br>
<b>Note</b>: the required MapConfiguration must be registered into the <b>MAIN DB</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the Styled Map; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the BoundingBox is expected to exactly match the image's <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.<br>
Except when the optional argument <b><i>reaspect</i></b> is set to TRUE; in this later case each single axis could be independently rescaled.</li>
<li>the optional argument <b><i>mimeType</i></b> could be one of <b>'image/pdf'</b>, <b>'image/jpeg'</b>, <b>'image/tiff'</b> or <b>'application/x-pdf'</b>; default is <b>'image/png'</b>.</li>
<li>the optional argument <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>; default <b>80</b>) is meaningful only in the case of JPEG images.</li>
</ul>
</td></tr>
</table><br>
<hr>
<h2>SQL functions importing raster data from external datasources</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr><td><b>RL2_LoadRaster</b> ( <b>coverageName</b> <i>String</i> , <b>sourcePath</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRaster</b> ( <b>coverageName</b> <i>String</i> , <b>sourcePath</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRaster</b> ( <b>coverageName</b> <i>String</i> , <b>sourcePath</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRaster</b> ( <b>coverageName</b> <i>String</i> , <b>sourcePath</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> , <b>pyramidize</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRaster</b> ( <b>coverageName</b> <i>String</i> , <b>sourcePath</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> , <b>pyramidize</b> <i>Integer</i>, <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to create and populate a new Section within a Coverage by importing an external file-based raster datasource (of the JPEG, TIFF, GeoTiff or ASCII Grid type).<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>if the optional argument <b><i>withWorldFile</i></b> (expected to be of the Boolean type) is set to TRUE, then a corresponding WorldFile is expected to be found and will be used to goerefence the raster.</li>
<li>if the optional argument <b><i>forceSRID</i></b> is explicit set, than its value will be assumed to represent the SRID declared by the external datasource.<br>
<u>Please note</u>: declaring some forceSRID value is absolutely required for any JPEG, TIFF and ASCII Grid file, because only GeoTIFF could eventually declare some SRID.</li>
<li>if the optional argument <b><i>pyramidize</i></b> (expected to be of the Boolean type) is set to TRUE, then any Pyramid level directly supporting the current Section will be immediately built; otherwise Pyramid levels will be ignored.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table>
</td>
</tr>
<tr><td><b>RL2_LoadRastersFromDir</b> ( <b>coverageName</b> <i>String</i> , <b>dirPath</b> <i>String</i> , <b>extension</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRastersFromDir</b> ( <b>coverageName</b> <i>String</i> , <b>dirPath</b> <i>String</i> , <b>extension</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRastersFromDir</b> ( <b>coverageName</b> <i>String</i> , <b>dirPath</b> <i>String</i> , <b>extension</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRastersFromDir</b> ( <b>coverageName</b> <i>String</i> , <b>dirPath</b> <i>String</i> , <b>extension</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> , <b>pyramidize</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRastersFromDir</b> ( <b>coverageName</b> <i>String</i> , <b>dirPath</b> <i>String</i> , <b>extension</b> <i>String</i> , <b>withWorldFile</b> <i>Integer</i> , <b>forceSRID</b> <i>Integer</i> , <b>pyramidize</b> <i>Integer</i>, <b>transaction</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to import all external file-based raster datasources (of the JPEG, TIFF, GeoTiff or ASCII Grid type) found within an external directory.<br>
For each datasource being imported a corresponding Section will be created and populated.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>the mandatory <b><i>extension</i></b> argument is expected to specify the <u><i>filename extension</i></u> identifying the files to be imported (e.g. <b>.tif</b>, <b>.jpg</b> or <b>.asc</b>).</li>
<li>if the optional argument <b><i>withWorldFile</i></b> (expected to be of the Boolean type) is set to TRUE, then a corresponding WorldFile is expected to be found and will be used to goerefence the raster.</li>
<li>if the optional argument <b><i>forceSRID</i></b> is explicit set, than its value will be assumed to represent the SRID declared by the external datasource.<br>
<u>Please note</u>: declaring some forceSRID value is absolutely required for any JPEG, TIFF and ASCII Grid file, because only GeoTIFF could eventually declare some SRID.</li>
<li>if the optional argument <b><i>pyramidize</i></b> (expected to be of the Boolean type) is set to TRUE, then any Pyramid level directly supporting the current Section will be immediately built; otherwise Pyramid levels will be ignored.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table>
</td>
</tr>
<tr><td><b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsHorzPixelResolution</b> <i>Double</i> , <b>wmsVertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br><b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsHorzPixelResolution</b> <i>Double</i> , <b>wmsVertPixelResolution</b> <i>Double</i> , <b>opaque</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsHorzPixelResolution</b> <i>Double</i> , <b>wmsVertPixelResolution</b> <i>Double</i> , <b>opaque</b> <i>Integer</i> , <b>swapXY</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsHorzPixelResolution</b> <i>Double</i> , <b>wmsVertPixelResolution</b> <i>Double</i> , <b>opaque</b> <i>Integer</i> , <b>swapXY</b> <i>Integer</i> , <b>proxy</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_LoadRasterFromWMS</b> ( <b>coverageName</b> <i>String</i> , <b>sectionName</b> <i>String</i> , <b>getMapUrl</b> <i>String</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>wmsVersion</b> <i>String</i> , <b>wmsLayerName</b> <i>String</i> , <b>wmsLayerStyle</b> <i>String</i> , <b>wmsImageFormat</b> <i>String</i> , <b>wmsHorzPixelResolution</b> <i>Double</i> , <b>wmsVertPixelResolution</b> <i>Double</i> , <b>opaque</b> <i>Integer</i> , <b>swapXY</b> <i>Integer</i> , <b>proxy</b> <i>String</i> , <b>transaction</b> <i>Integer</i> ) : <i>Integer</i>
</td>
<td>Will attempt to create and populate a new Section within a Coverage by importing raster data from an external WMS datasource.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>the <b><i>getMapURL</i></b> is expected to represent the base-URL for all tiled WMS GetMap requests.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the Section; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>wmsVersion</i></b>, <b><i>wmsLayerName</i></b>, <b><i>wmsLayerStyle</i></b>, <b><i>wmsImageFormat</i></b> and <b><i>opaque</i></b> arguments corresponds to the equivalent elements required in order to dynamically compose all WMS GetMap requests.</li>
<li>a single WMS GetMap request will be issued for each tile required by the Section; the BoundingBox of each individual tile will be automatically determined from the overall Section's BoundingBox and the <b><i>wmsHorzPixelResolution</i></b> and <b><i>wmsVertPixelResolution</i></b> arguments.</li>
<li>the optional argument <b><i>swapXY</i></b> could be necessary sometimes in order to invert the default WMS axes order.</li>
<li>the optional argument <b><i>proxy</i></b> could be necessary sometimes when accessing the WEB from behind a firewalled network.</li>
<li>if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table>
</td>
</tr>
</table><br>
<hr>
<h2>SQL functions exporting raw raster data to external files (Coverage oriented)</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr><td><b>RL2_WriteGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external GeoTIFF file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external  plain TIFF file supported by an auxiliary WorldFile.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external  plain TIFF file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the RGB type.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the RGB type supported by an auxiliary WorldFile.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the RGB type.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the Grayscale type.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the Grayscale type supported by an auxiliary WorldFile.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the Grayscale type.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> , <b>isPixelCentered</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> , <b>isPixelCentered</b> <i>Integer</i> ,
<b>decimalDigits</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a DATAGRID Coverage into an external ASCII Grid file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported ASCII Grid; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>pixelResolution</i></b>  must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels; rectangular pixels aren't supported by ASCII Grids.</li>
<li>and the BoundingBox must exactly match the ASCII Grid <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>isPixelCentered</i></b> (expected to be of the Boolean type) determines if the ASCII Grid will declare <b>xllcenter</b> and <b>yllcenter</b> instead of <b>xllcorner</b> and <b>yllconer</b> (default is TRUE).</li>
<li>the last optional argument can be used so to specify how many decimal digits have to be exported into the ASCII Grid; default is <b>4</b> decimal digits.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
</tr>
<tr><td><b>RL2_WriteJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br><b>RL2_WriteJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>quality</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a GRAYSCALE UINT8 or RGB UINT8 Coverage into an external JPEG file supported by an auxiliary WorldFile.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported JPEG; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the JPEG <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the last optional argument can be used so to specify the preferred JPEG <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>); default is <b>80</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br><b>RL2_WriteJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>quality</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a GRAYSCALE UINT8 or RGB UINT8 Coverage into an external JPEG file.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported JPEG; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the JPEG <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the last optional argument can be used so to specify the preferred JPEG <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>); default is <b>80</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
</table><br>
<hr>
<h2>SQL functions exporting raw raster data to external files (Section oriented)</h2> 
<table width="100%" border="1" bgcolor="#ffffe0" cellespacing="4" cellpadding="6">
<tr><th bgcolor="#e0e0e0" width="50%">Syntax</th><th bgcolor="#e0e0e0" width="50%">Summary</th></tr>
<tr><td><b>RL2_WriteSectionGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external GeoTIFF file; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external  plain TIFF file supported by an auxiliary WorldFile; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a Coverage into an external  plain TIFF file; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the RGB type; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the RGB type supported by an auxiliary WorldFile; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionTripleBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexRed</b> <i>Integer</i> , <b>bandIndexGreen</b> <i>Integer</i> , <b>bandIndexBlue</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the RGB type; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexRed</b></i>, <b><i>bandIndexGreen</i></b> and <b><i>bandIndexBlue</i></b> arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandGeoTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>withWoldFile</b> <i>Integer</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the Grayscale type; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported GeoTIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>if the optional argument <b><i>withWorldFile</i></b> is set to TRUE then an auxiliary WorldFile will be exported as well.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiffTFW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the Grayscale type supported by an auxiliary WorldFile; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionMonoBandTiff</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i> , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>bandIndexGray</b> <i>Integer</i>  , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>tiffCompression</b> <i>String</i> , <b>tiffTileSize</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the Grayscale type; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>bandIndexGray</i></b> argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
<br><u>Please note</u>: the first Band always corresponds to index <b>ZERO</b></li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported TIFF; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the TIFF <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>tiffCompression</i></b> could be one of <b>'NONE'</b>, <b>'DEFLATE'</b>, <b>'LZW'</b>, <b>'JPEG'</b>, <b>'FAX3'</b> or <b>'FAX4'</b>; default is <b>'NONE'</b>.</li>
<li>the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is <b>256</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> , <b>isPixelCentered</b> <i>Integer</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionAsciiGrid</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> , <b>isPixelCentered</b> <i>Integer</i> ,
<b>decimalDigits</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a DATAGRID Coverage into an external ASCII Grid file; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported ASCII Grid; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>pixelResolution</i></b>  must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels; rectangular pixels aren't supported by ASCII Grids.</li>
<li>and the BoundingBox must exactly match the ASCII Grid <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the optional argument <b><i>isPixelCentered</i></b> (expected to be of the Boolean type) determines if the ASCII Grid will declare <b>xllcenter</b> and <b>yllcenter</b> instead of <b>xllcorner</b> and <b>yllconer</b> (default is TRUE).</li>
<li>the last optional argument can be used so to specify how many decimal digits have to be exported into the ASCII Grid; default is <b>4</b> decimal digits.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
</tr>
<tr><td><b>RL2_WriteSectionJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br><b>RL2_WriteSectionJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionJpegJGW</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>quality</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a GRAYSCALE UINT8 or RGB UINT8 Coverage into an external JPEG file supported by an auxiliary WorldFile; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported JPEG; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the JPEG <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the last optional argument can be used so to specify the preferred JPEG <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>); default is <b>80</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
<tr><td><b>RL2_WriteSectionJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>pixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br><b>RL2_WriteSectionJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> ) : <i>Integer</i><br><br>
<b>RL2_WriteSectionJpeg</b> ( <b>dbPrefix</b> <i>String</i> , <b>coverageName</b> <i>String</i> , <b>sectionID</b> <i>Integer</i>  , <b>filePath</b> <i>String</i> , <b>width</b> <i>Integer</i> , <b>height</b> <i>Integer</i> , <b>boundingBox</b> <i>BLOB-Geometry</i> , <b>horzPixelResolution</b> <i>Double</i> , <b>vertPixelResolution</b> <i>Double</i> , <b>quality</b> <i>Integer</i> ) : <i>Integer</i></td>
<td>Will attempt to export raw raster data from a GRAYSCALE UINT8 or RGB UINT8 Coverage into an external JPEG file; only the Tiles directly belonging to the selected Section will be considered.<br>
Will return <b>1</b> (TRUE/SUCCESS) or <b>0</b> (FALSE/FAILURE): or <b>-1</b> on invalid arguments.<br>
<u>Please note</u>: 
<ul>
<li>The <b><i>dbPrefix</i></b> argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually <b>NULL</b>, and in this case the <b>MAIN DB</b> will implicitly be assumed.</li>
<li>the <b><i>boundingBox</i></b> is expected to represent the overall extent of the exported JPEG; you could eventually pass any arbitrary kind of Geometry, and the Bounding Box aka MBR will be automatically determined.</li>
<li>the <b><i>horzPixelResolution</i></b> and <b><i>vertPixelResolution</i></b> must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.</li>
<li>and the BoundingBox must exactly match the JPEG <b><i>width</i></b> and <b><i>height</i></b> dimensions at that resolution.</li>
<li>the last optional argument can be used so to specify the preferred JPEG <b><i>quality</i></b> (in the range <b>0</b> - <b>100</b>); default is <b>80</b>.</li>
</ul>
<table width="100%" bgcolor="#ffd080" cellpadding="6"><tr><td>
<u>Please note very well</u>: this SQL function is only available when the environment variable <b>SPATIALITE_SECURITY=relaxed</b> is set.</td></tr></table></td>
</tr>
</table>
<br><br><hr>
Back to <a href="https://www.gaia-gis.it/fossil/librasterlite2/wiki?name=rasterlite2-doc">RasterLite2 doc index</a>
Z 132633a39c160f685a3f6af622013e0f