D 2020-10-02T10:06:47.164 L sql_reference_list P 9737172852508e8f0b3f72a7e97005bac0ed6ce0 U sandro W 156877 Back to RasterLite2 doc index

Work in progress

RasterLite2 SQL functions - reference list


SQL functions supporting Version and Architecture

SyntaxSummary
RL2_Version () : String Will return the version of RasterLite2 currently in use.
RL2_Target_CPU () : String Will return the name of the CPU architecture currently in use.
RL2_Cairo_Version () : String Will return the version of libcairo currently in use.
RL2_Curl_Version () : String Will return the version of libcurl currently in use.
RL2_Zlib_Version () : String Will return the version of zlib (DEFLATE) currently in use.
RL2_LZMA_Version () : String Will return the version of liblzma currently in use.
RL2_LZ4_Version () : String Will return the version of liblz4 currently in use.
RL2_ZSTD_Version () : String Will return the version of libzstd currently in use.
RL2_PNG_Version () : String Will return the version of libpng currently in use.
RL2_JPEG_Version () : String Will return the version of libjpeg (or libjpeg-turbo) currently in use.
RL2_TIFF_Version () : String Will return the version of libtiff currently in use.
RL2_GeoTIFF_Version () : String Will return the version of libgeotiff currently in use.
RL2_WEBP_Version () : String Will return the version of libwebp currently in use.
RL2_OpenJPEG_Version () : String Will return the version of libopenjp2 (Jpeg2000) currently in use.


SQL functions testing which codecs are actually supported by the library

SyntaxSummary
RL2_has_codec_none () : Boolean Tests if the NONE codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_deflate () : Boolean Tests if the DEFLATE (zip: with Delta Filter) codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_deflate_no () : Boolean Tests if the DEFLATE_NO (zip: without Delta Filter) codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_lzma () : Boolean Tests if the LZMA (7-zip: with Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_lzma_no () : Boolean Tests if the LZMA_NO (7-zip: without Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_lz4 () : Boolean Tests if the LZ4 (fast lossless: with Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_lz4_no () : Boolean Tests if the LZ4_NO (fast loseless: without Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_zstd () : Boolean Tests if the ZSTD (Zstandard: with Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_zstd_no () : Boolean Tests if the ZSTD_NO (Zstandard: without Delta Filter) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_png () : Boolean Tests if the PNG codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_jpeg () : Boolean Tests if the JPEG codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_fax4 () : Boolean Tests if the FAX4 codec is currently supported.
Will costantly return 1 (TRUE).
RL2_has_codec_webp () : Boolean Tests if the WebP (lossy) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_ll_webp () : Boolean Tests if the WebP (lossless) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_openjpeg () : Boolean Tests if the OpenJpeg (Jpeg2000 lossy) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.
RL2_has_codec_ll_opejpeg () : Boolean Tests if the OpenJpeg (Jpeg2000 lossless) codec is currently supported.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual configuration.


SQL functions controlling parallel execution

SyntaxSummary
RL2_GetMaxThreads () : Integer Will return the currently set MAX number of concurrent threads allowed for parallel execution.
RL2_SetMaxThreads ( max Integer ) : Integer Will set the MAX number of concurrent threads allowed for parallel execution.
Will return the MAX number of concurrent threads after this call.

Note

The MAX number of concurrent threads is a global option set at the DB connection level.
Once set, it will influence any subsequent call to any SQL function supporting parallel execution.
The initial value for any new connection is always 0, that is no parallel execution at all.


SQL functions controlling Text Symbolizers (Map Labels)

SyntaxSummary
RL2_IsAntiLabelCollisionEnabled () : Boolean Tests if the AntiLabelCollision global option is currently activated or not.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.
RL2_EnableAntiLabelCollision () : Boolean Activates the AntiLabelCollision global option.
Same return value as in RL2_IsAntiLabelCollisionEnabled()
RL2_DisableAntiLabelCollision () : Boolean Deactivates the AntiLabelCollision global option.
Same return value as in RL2_IsAntiLabelCollisionEnabled()
RL2_IsLabelWrapTextEnabled () : Boolean Tests if the LabelWrapText global option is currently activated or not.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.
RL2_EnableLabelWrapText () : Boolean Activates the LabelWrapText global option.
Same return value as in RL2_IsLabelWrapTextEnabled()
RL2_DisableLabelWrapText () : Boolean Deactivates the LabelWrapText global option.
Same return value as in RL2_IsLabelWrapTextEnabled()
RL2_IsLabelAutorotateEnabled () : Boolean Tests if the LabelAutorotate global option is currently activated or not.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.
RL2_EnableLabelAutorotate () : Boolean Activates the LabelAutorotate global option.
Same return value as in RL2_IsLabelAutorotateEnabled()
RL2_DisableLabelAutorotate () : Boolean Deactivates the LabelAutorotate global option.
Same return value as in RL2_IsLabelAutorotateEnabled()
RL2_IsLabelShifPositionEnabled () : Boolean Tests if the LabelShifPosition global option is currently activated or not.
Will return 1 (TRUE) or 0 (FALSE) accordingly to actual setting.
RL2_EnableLabelShifPosition () : Boolean Activates the LabelShifPosition global option.
Same return value as in RL2_IsLabelShifPositionEnabled()
RL2_DisableLabelShifPosition () : Boolean Deactivates the LabelShifPosition global option.
Same return value as in RL2_IsLabelShifPositionEnabled()

Note

All the above global options are set at the DB connection level.
Once set, each one of them will influence any subsequent call to any SQL function supporting Text Symbolizers.
The initial value for any new connection is always 0 for all them, that is no special Text/Label options at all.


SQL functions supporting BLOB serialized Pixel objects

SyntaxSummary
RL2_IsValidPixel ( pixel BLOB , sampleType String , numBands Integer ) : Integer Will test a BLOB serialized pixel object for validity.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_CreatePixel ( sampleType String , pixelType String , numBands Integer ) : BLOB Will return a BLOB corresponding to a Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
All Pixel components will be initially set to ZERO.
RL2_GetPixelType ( pixel BLOB ) : String Will return the mnemonic PixelType from a Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_GetPixelSampleType ( pixel BLOB ) : String Will return the mnemonic SampleType from a Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_GetPixelNumBands ( pixel BLOB ) : Integer Will return the number of Bands from a Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_GetPixelValue ( pixel BLOB , bandIndex Integer ) : Integer

RL2_GetPixelValue ( pixel BLOB , bandIndex Integer ) : Double
Will return the current sampleValue (data-type will match the Pixel's sampleType) from a Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_SetPixelValue ( pixel BLOB , bandIndex Integer , sampleValue Integer ) : BLOB

RL2_SetPixelValue ( pixel BLOB , bandIndex Integer , sampleValue Double ) : BLOB
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): NULL will be returned on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_IsTransparentPixel ( pixel BLOB ) : Integer Will test a BLOB serialized pixel object for transparency.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_IsOpaquePixel ( pixel BLOB ) : Integer Will test a BLOB serialized pixel object for opacity.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_SetTransparentPixel ( pixel BLOB ) : BLOB Will return a new BLOB corresponding to a transparent Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_SetOpaquePixel ( pixel BLOB ) : BLOB Will return a new BLOB corresponding to an opaque Pixel serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_PixelEquals ( pixel_1 BLOB , pixel_2 BLOB ) : Integer Will compare two BLOB serialized pixel objects for identity.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_GetPixelFromRasterByPoint ( db_prefix Text , coverage Text , point BLOB-Geom , pyramyd_level Integer ) : BLOB-Pixel

RL2_GetPixelFromRasterByPoint ( db_prefix Text , coverage Text , point BLOB-Geom , horz_res Double/i> , vert_res Double ) : BLOB-Pixel
Will extract from the Raster Coverage identified by db_prefix and coverage the pixel matching the map coordinates specified by point:
  • a NULL db_prefix will be automatically interpreted as 'MAIN'.
  • the point Geometry must identify a single POINT.
    If the SRID declared by point isn't the same declared by the Raster Coverage then point will be automatically reprojected into the Raster Coverage own SRID.

Will return a BLOB serialized pixel object or NULL on invalid arguments or if any error occurred.


SQL functions supporting BLOB serialized Palette objects

SyntaxSummary
RL2_IsValidRasterPalette ( palette BLOB , sampleType String ) : Integer Will test a BLOB serialized palette object for validity.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_GetPaletteNumEntries ( palette BLOB ) : Integer Will return the number of color entries from a Palette serialized object: NULL will be returned on invalid arguments or if any error occurred.
RL2_GetPaletteColorEntry ( palette BLOB , entryIndex Integer ) : String Will return the current color (HEX-RGB format) from a serialized Palette object Entry: NULL will be returned on invalid arguments or if any error occurred.
Please note: the first Palette Entry always corresponds to index ZERO.
RL2_SetPaletteColorEntry ( palette BLOB , entryIndex Integer , hexRgbColor String ) : BLOB 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 '#ff8080'.
NULL will be returned on invalid arguments or if any error occurred.
Please note: the first Palette Entry always corresponds to index ZERO.
RL2_PaletteEquals ( palette_1 BLOB , palette_2 BLOB ) : Integer Will compare two BLOB serialized palette objects for identity.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.


SQL functions supporting BLOB serialized Raster/Band Statistics objects

SyntaxSummary
RL2_IsValidRasterStatistics ( dbPrefix String , coverageName String , rasterStatistics BLOB ) : Integer

RL2_IsValidRasterStatistics ( rasterStatistics BLOB , sampleType String , numBands Integer ) : Integer
Will test a BLOB serialized rasterStatistics object for validity.
The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_GetRasterStatistics_NoDataPixelsCount ( rasterStatistics BLOB ) : Integer Will return the total count of NoData pixels from a BLOB serialized rasterStatistics object: NULL on invalid arguments or if any error occurred.
RL2_GetRasterStatistics_ValidPixelsCount ( rasterStatistics BLOB ) : Integer Will return the total count of valid pixels (excluding NoData pixels) from a BLOB serialized rasterStatistics object: NULL on invalid arguments or if any error occurred.
RL2_GetRasterStatistics_SampleType ( rasterStatistics BLOB ) : String Will return the mnemonic SampleType from a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
RL2_GetRasterStatistics_BandsCount ( rasterStatistics BLOB ) : String Will return the total number of supported Bands from a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
RL2_GetBandStatistics_Min ( rasterStatistics BLOB , bandIndex Integer ) : Double Will return the Minimum value from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_GetBandStatistics_Max ( rasterStatistics BLOB , bandIndex Integer ) : Double Will return the Maximum value from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_GetBandStatistics_Avg ( rasterStatistics BLOB , bandIndex Integer ) : Double Will return the Average/Mean value from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_GetBandStatistics_Var ( rasterStatistics BLOB , bandIndex Integer ) : Double Will return the estimated Variance value from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_GetBandStatistics_StdDev ( rasterStatistics BLOB , bandIndex Integer ) : Double Will return the estimated Standard Deviation value from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.
RL2_GetBandStatistics_Histogram ( rasterStatistics BLOB , bandIndex Integer ) : BLOB Will return a BLOB corresponding to a PNG image representing the estimated distribution Histogram from a specific Band of a rasterStatistics serialized object: NULL on invalid arguments or if any error occurred.
Please note: the first Band always corresponds to index ZERO.


SQL functions supporting BLOB serialized rasterTile objects

SyntaxSummary
RL2_IsValidRasterTile ( dbPrefix String , coverageName String , pyramidLevel Integer, tileOdd BLOB , tileEven BLOB ) : Integer Will test a BLOB serialized rasterTile object for validity.
The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
Will return 1 (TRUE) or 0 (FALSE): or -1 on invalid arguments or if any error occurred.
RL2_GetTileImage ( dbPrefix String , coverageName String , tileID Integer ) : BLOB Will return a BLOB corresponding to a PNG image (visual preview) from a rasterTile serialized object: NULL on invalid arguments or if any error occurred.
The mandatory dbPrefix argument could eventually be NULL and in this case the MAIN DB will implicitly be assumed.
Please note: 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 first band only will be silently assumed.
RL2_GetTripleBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer ) : BLOB

RL2_GetTripleBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , bgColor String ) : BLOB

RL2_GetTripleBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , bgColor String , transparent Integer ) : BLOB
Will return a BLOB corresponding to a PNG image (visual preview) from a rasterTile serialized object: NULL on invalid arguments or if any error occurred.
The mandatory dbPrefix argument could eventually be NULL and in this case the MAIN DB will implicitly be assumed.
The bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB PNG starting from the Bands supported by the Coverage.
Please note: the first Band always corresponds to index ZERO

The optional bgColor argument is expected to be expressed in the canonical WEB HEX-RGB form, as in '#ff8080' (default is '#ffffff' i.e. full white).
The second optional transparent argument is expected to be expressed as a Boolean value (default is 0 FALSE).
Please note very well: this SQL function will only accept Raster Tiles of the MULTIBAND or RGB type.
RL2_GetMonoBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexGray Integer ) : BLOB

RL2_GetMonoBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexGray Integer , bgColor String ) : BLOB

RL2_GetMonoBandTileImage ( dbPrefix String , coverageName String , tileID Integer , bandIndexGray Integer , bgColor String , transparent Integer ) : BLOB
Will return a BLOB corresponding to a PNG image (visual preview) from a rasterTile serialized object: NULL on invalid arguments or if any error occurred.
The mandatory dbPrefix argument could eventually be NULL and in this case the MAIN DB will implicitly be assumed.
The bandIndexGray argument is intended to arbitrarily compose the Grayscale PNG starting from the Bands supported by the Coverage.
Please note: the first Band always corresponds to index ZERO

The optional bgColor argument is expected to be expressed in the canonical WEB HEX-RGB form, as in '#ff8080' (default is '#ffffff' i.e. full white).
The second optional transparent argument is expected to be expressed as a Boolean value (default is 0 FALSE).
Please note: for pixelTypes lacking any implicit photometric interpretation (i.e. DATAGRID) a default Grayscale interpretation will be silently assumed.
Please note very well: this SQL function will only accept Raster Tiles of the MULTIBAND or RGB type.


SQL functions supporting Coverage and Section management

SyntaxSummary
RL2_CreateRasterCoverage ( coverageName String , sampleType String , pixelType String , numBands Integer , compressionType String , quality Integer , tileWidth Integer , tileHeight Integer , SRID Integer , pixelResolution Double ) : Integer

RL2_CreateRasterCoverage ( coverageName String , sampleType String , pixelType String , numBands Integer , compressionType String , quality Integer , tileWidth Integer , tileHeight Integer , SRID Integer , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_CreateRasterCoverage ( coverageName String , sampleType String , pixelType String , numBands Integer , compressionType String , quality Integer , tileWidth Integer , tileHeight Integer , SRID Integer , horzPixelResolution Double , vertPixelResolution Double , noDataPixel BLOB ) : Integer

RL2_CreateRasterCoverage ( coverageName String , sampleType String , pixelType String , numBands Integer , compressionType String , quality Integer , tileWidth Integer , tileHeight Integer , SRID Integer , horzPixelResolution Double , vertPixelResolution Double , noDataPixel BLOB , strictResolution Integer , mixedResolutions Integer , sectionPaths Integer , sectionMD5 Integer , sectionSummary Integer ) : Integer

RL2_CreateRasterCoverage ( coverageName String , sampleType String , pixelType String , numBands Integer , compressionType String , quality Integer , tileWidth Integer , tileHeight Integer , SRID Integer , horzPixelResolution Double , vertPixelResolution Double , noDataPixel BLOB , strictResolution Integer , mixedResolutions Integer , sectionPaths Integer , sectionMD5 Integer , sectionSummary Integer , is_queryable Integer ) : Integer
Will attempt to create a new Raster Coverage within the currently connected DB-file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note: you can use the second form to create a Raster Coverage requiring rectangular pixels.

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.

The fourth form allows to explicitly set Policies Options (always disabled by default). Each single Option corresponds to a boolean value (FALSE=disabled / TRUE=enabled).

The fifth and final form allows to explicitly state if the Coverage is queryable or not (always set to FALSE by default).
RL2_SetCoverageInfos ( coverageName String , title String , abstract String ) : Integer

RL2_SetCoverageInfos ( coverageName String , title String , abstract String , is_queryable Integer ) : Integer
Inserts (or updates) the descriptive infos associated to a Coverage.
  • coverage_name must identify an existing Coverage.
  • title and abstract represent the descriptive infos to be set.
  • the optional argument is_queryable (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.

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.
RL2_SetRasterCoverageCopyright ( coverageName String , copyright String ) : Integer

RL2_SetRasterCoverageCopyright ( coverageName String , copyright String , license String ) : Integer
Inserts (or updates) Copyright and License infos associated to a Coverage.
  • coverage_name must identify an existing Coverage.
  • copyright identifies the Copyright holder; if NULL the current value will be preserved.
  • the optional argument license must reference one the Data Licenses registered into the data_licenses table, as e.g. CC0 1.0 or CC BY 4.0.

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.
RL2_DropCoverage ( coverageName String ) : Integer

RL2_DropCoverage ( coverageName String , transaction Integer ) : Integer
Will attempt do completely remove a Raster Coverage (including all related Sections, Pyramids and Tiles) from the currently connected DB-file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note: if the second optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
RL2_CopyRasterCoverage ( dbPrefix String , coverageName String ) : Integer

RL2_CopyRasterCoverage ( dbPrefix String , coverageName String , transaction boolean ) : Integer
Will copy a complete Raster Coverage from an attached DB to the currently connected (MAIN) DB.
  • a valid Raster Coverage matching coverageName must exists within the Attached DB identified by dbPrefix.
  • no Raster Coverage matching coverageName must exists within the MAIN DB.
    It will be automatically created and populated as appropriate.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note: if the third optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
RL2_DeleteSection ( coverageName String , sectionID Integer ) : Integer

RL2_DeleteSection ( coverageName String , sectionID Integer , transaction Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note: if the third optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.


SQL functions supporting Pyramid management

SyntaxSummary
RL2_Pyramidize ( coverageName String ) : Integer

RL2_Pyramidize ( coverageName String , sectionID Integer ) : Integer

RL2_Pyramidize ( coverageName String , sectionID Integer , forceRebuild Integer ) : Integer

RL2_Pyramidize ( coverageName String , sectionID Integer , forceRebuild Integer , transaction Integer ) : Integer
Will attempt do (re)build Section-based Pyramid levels.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • if a single sectionID is specified, then only the Pyramid levels directly belonging to that Section will be considered.
    A NULL sectionID always implies processing the whole Coverage.
  • if the optional argument forceRebuild (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.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
RL2_PyramidizeMonolithic ( coverageName String ) : Integer

RL2_PyramidizeMonolithic ( coverageName String , virtualLevels Integer ) : Integer

RL2_PyramidizeMonolithic ( coverageName String , virtualLevels Integer , transaction Integer ) : Integer
Will attempt do (re)build Pyramid levels of the Monolithic type.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • the whole Coverage will be always processed, and any eventually preexisting Section-based or Monolithic Pyramid will be destroyed in order to rebuild a new Pyramid from scratch.
  • the second optional argument virtualLevels allows to choose the preferred interleave factor between physical and virtual Levels. Acceptable values are 1, 2 or 3. The default setting is 3, with the notable exception of MONOCHROME 1-BIT Coverages, in which case will be 1.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
Important Notice: a Monolithic Pyramid is not compatible with any Coverage declared by enabling the mixedResolution Policy.
RL2_DePyramidize ( coverageName String ) : Integer

RL2_DePyramidize ( coverageName String , sectionID Integer ) : Integer

RL2_DePyramidize ( coverageName String , sectionID Integer , transaction Integer ) : Integer
Will attempt do destroy Pyramid levels.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • if a single sectionID is specified, then only the Pyramid levels directly belonging to that Section will be considered (only supported for Section-based Pyramids).
    A NULL sectionID always implies processing the whole Coverage.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.


SQL functions returning styled Maps

SyntaxSummary
RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer , quality Integer ) : BLOB

RL2_GetMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer , quality Integer , reaspect Integer ) : BLOB
Will attempt to create a digital image representing a Styled Map from a Coverage of the Raster type.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the styleName could be eventually 'default', this corresponding to the implicit style supported for all Pixel Types except MULTIBAND (which always require some explicit style to be applied).
  • the BoundingBox is expected to exactly match the image's width and height dimensions at that resolution.
    Except when the optional argument reaspect is set to TRUE; in this later case each single axis could be independently rescaled.
  • the optional argument mimeType could be one of 'image/pdf', 'image/jpeg', 'image/tiff' or 'application/x-pdf'; default is 'image/png'.
  • the optional bgColor argument is expected to be expressed in the canonical WEB HEX-RGB form, as in '#ff8080' (default is '#ffffff' i.e. full white).
  • the optional transparent argument is expected to be expressed as a Boolean value (default is 0 FALSE).
    Please note: transparency is supported uniquely by PNG images.
  • the optional argument quality (in the range 0 - 100; default 80) is meaningful only in the case of JPEG images.
RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text ) : BLOB

RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String ) : BLOB

RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String ) : BLOB

RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer ) : BLOB

RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer , quality Integer ) : BLOB

RL2_GetStyledMapImageFromRaster ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer , quality Integer , reaspect Integer ) : BLOB
Will attempt to create a digital image representing a Styled Map from a Coverage of the Raster type.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.

Please note:
  • Almost all the arguments are the same as in RL2_GetMapImageFromRaster() and have identical interpretation.
  • The only exception being xml_style that is expected to contain a valid SLD/SE XML Raster Symbolizer.

In other words:
  • Both RL2_GetMapImageFromRaster() and RL2_GetStyledMapImageFromRaster() are very similar in their general behavior. The main difference between them is:
    • RL2_GetMapImageFromRaster() accepts the name of a registered Style.
    • RL2_GetStyledMapImageFromRaster() directly accepts an XML Style definition.
RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer , quality Integer ) : BLOB

RL2_GetMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , styleName String , mimeType String , bgColor String , transparent Integer , quality Integer , reaspect Integer ) : BLOB
Will attempt to create a digital image representing a Styled Map from a Coverage of the Vector type.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the styleName could be eventually 'default', this corresponding to the implicit style supported for all Pixel Types except MULTIBAND (which always require some explicit style to be applied).
  • the BoundingBox is expected to exactly match the image's width and height dimensions at that resolution.
    Except when the optional argument reaspect is set to TRUE; in this later case each single axis could be independently rescaled.
  • the optional argument mimeType could be one of 'image/pdf', 'image/jpeg', 'image/tiff' or 'application/x-pdf'; default is 'image/png'.
  • the optional bgColor argument is expected to be expressed in the canonical WEB HEX-RGB form, as in '#ff8080' (default is '#ffffff' i.e. full white).
  • the optional transparent argument is expected to be expressed as a Boolean value (default is 0 FALSE).
    Please note: transparency is supported uniquely by PNG images.
  • the optional argument quality (in the range 0 - 100; default 80) is meaningful only in the case of JPEG images.
RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer , quality Integer ) : BLOB

RL2_GetStyledMapImageFromVector ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , xml_style Text , mimeType String , bgColor String , transparent Integer , quality Integer , reaspect Integer ) : BLOB
Will attempt to create a digital image representing a Styled Map from a Coverage of the Vector type.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.

Please note:
  • Almost all the arguments are the same as in RL2_GetMapImageFromVector() and have identical interpretation.
  • The only exception being xml_style that is expected to contain a valid SLD/SE XML Vector Symbolizer.

In other words:
  • Both RL2_GetMapImageFromVector() and RL2_GetStyledMapImageFromVector() are very similar in their general behavior. The main difference between them is:
    • RL2_GetMapImageFromVector() accepts the name of a registered Style.
    • RL2_GetStyledMapImageFromVector() directly accepts an XML Style definition.
RL2_GetMapImageFromWMS ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer ) : BLOB

RL2_GetMapImageFromWMS ( dbPrefix String , coverageName String , boundingBox BLOB-Geometry , width Integer , height Integer , version String , styleName String , mimeType String , bgColor String , transparent Integer ) : BLOB
Will attempt to create a digital image representing a Styled Map from a Coverage of the WMS type.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the version argument determinws which version of the WMS protocol should be used.
    Valid values are: 1.0.0, 1.1.0, 1.1.1 and 1.3.0
  • the styleName could be eventually 'default' (it depends on the specific capabilites declared from the remote server).
  • the BoundingBox is expected to exactly match the image's width and height dimensions at that resolution..
  • the argument mimeType could usually be one of 'image/pdf', 'image/jpeg' or 'image/tiff' (it depends on the specific capabilites declared from the remote server).
  • the optional bgColor argument is expected to be expressed in the canonical WEB HEX-RGB form, as in '#ff8080' (default is '#ffffff' i.e. full white).
  • the optional transparent argument is expected to be expressed as a Boolean value (default is 0 FALSE).
    Please note: transparency is supported uniquely by PNG images.
RL2_GetImageFromMapConfiguration ( configName String , boundingBox BLOB-Geometry , width Integer , height Integer ) : BLOB

RL2_GetImageFromMapConfiguration ( configName String , boundingBox BLOB-Geometry , width Integer , height Integer , mimeType String ) : BLOB

RL2_GetImageFromMapConfiguration ( configName String , boundingBox BLOB-Geometry , width Integer , height Integer , mimeType String , quality Integer ) : BLOB

RL2_GetImageFromMapConfiguration ( configName String , boundingBox BLOB-Geometry , width Integer , height Integer , mimeType String , quality Integer , reaspect Integer ) : BLOB
Will attempt to create a digital image representing a complex, multi-layered Styled Map from a registered MapConfiguration.
Will return a BLOB containing the Styled Map: or NULL on invalid arguments or if any error occurs.
Please note:
  • The configName argument is intended to specify which of the registered MapConfigurations should be used.
    Note: the required MapConfiguration must be registered into the MAIN DB
  • the boundingBox 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.
  • the BoundingBox is expected to exactly match the image's width and height dimensions at that resolution.
    Except when the optional argument reaspect is set to TRUE; in this later case each single axis could be independently rescaled.
  • the optional argument mimeType could be one of 'image/pdf', 'image/jpeg', 'image/tiff' or 'application/x-pdf'; default is 'image/png'.
  • the optional argument quality (in the range 0 - 100; default 80) is meaningful only in the case of JPEG images.


SQL functions importing raster data from external datasources

SyntaxSummary
RL2_LoadRaster ( coverageName String , sourcePath String ) : Integer

RL2_LoadRaster ( coverageName String , sourcePath String , withWorldFile Integer ) : Integer

RL2_LoadRaster ( coverageName String , sourcePath String , withWorldFile Integer , forceSRID Integer ) : Integer

RL2_LoadRaster ( coverageName String , sourcePath String , withWorldFile Integer , forceSRID Integer , pyramidize Integer ) : Integer

RL2_LoadRaster ( coverageName String , sourcePath String , withWorldFile Integer , forceSRID Integer , pyramidize Integer, transaction Integer ) : Integer
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).
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • if the optional argument withWorldFile (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.
  • if the optional argument forceSRID is explicit set, than its value will be assumed to represent the SRID declared by the external datasource.
    Please note: declaring some forceSRID value is absolutely required for any JPEG, TIFF and ASCII Grid file, because only GeoTIFF could eventually declare some SRID.
  • if the optional argument pyramidize (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.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_LoadRastersFromDir ( coverageName String , dirPath String , extension String ) : Integer

RL2_LoadRastersFromDir ( coverageName String , dirPath String , extension String , withWorldFile Integer ) : Integer

RL2_LoadRastersFromDir ( coverageName String , dirPath String , extension String , withWorldFile Integer , forceSRID Integer ) : Integer

RL2_LoadRastersFromDir ( coverageName String , dirPath String , extension String , withWorldFile Integer , forceSRID Integer , pyramidize Integer ) : Integer

RL2_LoadRastersFromDir ( coverageName String , dirPath String , extension String , withWorldFile Integer , forceSRID Integer , pyramidize Integer, transaction Integer ) : Integer
Will attempt to import all external file-based raster datasources (of the JPEG, TIFF, GeoTiff or ASCII Grid type) found within an external directory.
For each datasource being imported a corresponding Section will be created and populated.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • the mandatory extension argument is expected to specify the filename extension identifying the files to be imported (e.g. .tif, .jpg or .asc).
  • if the optional argument withWorldFile (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.
  • if the optional argument forceSRID is explicit set, than its value will be assumed to represent the SRID declared by the external datasource.
    Please note: declaring some forceSRID value is absolutely required for any JPEG, TIFF and ASCII Grid file, because only GeoTIFF could eventually declare some SRID.
  • if the optional argument pyramidize (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.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsPixelResolution Double ) : Integer

RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsHorzPixelResolution Double , wmsVertPixelResolution Double ) : Integer

RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsHorzPixelResolution Double , wmsVertPixelResolution Double , opaque Integer ) : Integer

RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsHorzPixelResolution Double , wmsVertPixelResolution Double , opaque Integer , swapXY Integer ) : Integer

RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsHorzPixelResolution Double , wmsVertPixelResolution Double , opaque Integer , swapXY Integer , proxy String ) : Integer

RL2_LoadRasterFromWMS ( coverageName String , sectionName String , getMapUrl String , boundingBox BLOB-Geometry , wmsVersion String , wmsLayerName String , wmsLayerStyle String , wmsImageFormat String , wmsHorzPixelResolution Double , wmsVertPixelResolution Double , opaque Integer , swapXY Integer , proxy String , transaction Integer ) : Integer
Will attempt to create and populate a new Section within a Coverage by importing raster data from an external WMS datasource.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • the getMapURL is expected to represent the base-URL for all tiled WMS GetMap requests.
  • the boundingBox 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.
  • the wmsVersion, wmsLayerName, wmsLayerStyle, wmsImageFormat and opaque arguments corresponds to the equivalent elements required in order to dynamically compose all WMS GetMap requests.
  • 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 wmsHorzPixelResolution and wmsVertPixelResolution arguments.
  • the optional argument swapXY could be necessary sometimes in order to invert the default WMS axes order.
  • the optional argument proxy could be necessary sometimes when accessing the WEB from behind a firewalled network.
  • if the last optional argument (expected to be of the Boolean type) isn't declared an internal SQL Transaction will be implicitly handled.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.


SQL functions exporting raw raster data to external files (Coverage oriented)

SyntaxSummary
RL2_WriteGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a Coverage into an external GeoTIFF file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a Coverage into an external plain TIFF file supported by an auxiliary WorldFile.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a Coverage into an external plain TIFF file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteTripleBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteTripleBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteTripleBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteTripleBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteTripleBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the RGB type.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteTripleBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteTripleBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteTripleBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteTripleBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteTripleBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteTripleBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteTripleBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteTripleBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the RGB type.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteMonoBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteMonoBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteMonoBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteMonoBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteMonoBandGeoTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external GeoTIFF file of the Grayscale type.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteMonoBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteMonoBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteMonoBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteMonoBandTiffTFW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteMonoBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteMonoBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteMonoBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteMonoBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
Will attempt to export raw raster data from a MULTIBAND or RGB Coverage into an external plain TIFF file of the Grayscale type.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteAsciiGrid ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteAsciiGrid ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double , isPixelCentered Integer ) : Integer

RL2_WriteAsciiGrid ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double , isPixelCentered Integer , decimalDigits Integer ) : Integer
Will attempt to export raw raster data from a DATAGRID Coverage into an external ASCII Grid file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the pixelResolution 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.
  • and the BoundingBox must exactly match the ASCII Grid width and height dimensions at that resolution.
  • the optional argument isPixelCentered (expected to be of the Boolean type) determines if the ASCII Grid will declare xllcenter and yllcenter instead of xllcorner and yllconer (default is TRUE).
  • the last optional argument can be used so to specify how many decimal digits have to be exported into the ASCII Grid; default is 4 decimal digits.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteJpegJGW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteJpegJGW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteJpegJGW ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , quality Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the JPEG width and height dimensions at that resolution.
  • the last optional argument can be used so to specify the preferred JPEG quality (in the range 0 - 100); default is 80.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteJpeg ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteJpeg ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteJpeg ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , quality Integer ) : Integer
Will attempt to export raw raster data from a GRAYSCALE UINT8 or RGB UINT8 Coverage into an external JPEG file.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the JPEG width and height dimensions at that resolution.
  • the last optional argument can be used so to specify the preferred JPEG quality (in the range 0 - 100); default is 80.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.


SQL functions exporting raw raster data to external files (Section oriented)

SyntaxSummary
RL2_WriteSectionGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteSectionGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteSectionGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionTripleBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionTripleBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionTripleBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteSectionTripleBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteSectionTripleBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionTripleBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionTripleBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionTripleBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionTripleBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionTripleBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionTripleBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionTripleBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionTripleBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexRed Integer , bandIndexGreen Integer , bandIndexBlue Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexRed, bandIndexGreen and bandIndexBlue arguments are intended to arbitrarily compose the RGB TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionMonoBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionMonoBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionMonoBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer ) : Integer

RL2_WriteSectionMonoBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String ) : Integer

RL2_WriteSectionMonoBandGeoTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , withWoldFile Integer , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • if the optional argument withWorldFile is set to TRUE then an auxiliary WorldFile will be exported as well.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionMonoBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionMonoBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionMonoBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionMonoBandTiffTFW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionMonoBandTiff ( dbPrefix String , coverageName String , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionMonoBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionMonoBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String ) : Integer

RL2_WriteSectionMonoBandTiff ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , bandIndexGray Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , tiffCompression String , tiffTileSize Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the bandIndexGray argument is intended to arbitrarily compose the Grayscale TIFF starting from the Bands supported by the Coverage.
    Please note: the first Band always corresponds to index ZERO
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the TIFF width and height dimensions at that resolution.
  • the optional argument tiffCompression could be one of 'NONE', 'DEFLATE', 'LZW', 'JPEG', 'FAX3' or 'FAX4'; default is 'NONE'.
  • the last optional argument can be used so to specify the preferred TIFF tile size (only square tiles are supported); default is 256.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionAsciiGrid ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionAsciiGrid ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double , isPixelCentered Integer ) : Integer

RL2_WriteSectionAsciiGrid ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double , isPixelCentered Integer , decimalDigits Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the pixelResolution 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.
  • and the BoundingBox must exactly match the ASCII Grid width and height dimensions at that resolution.
  • the optional argument isPixelCentered (expected to be of the Boolean type) determines if the ASCII Grid will declare xllcenter and yllcenter instead of xllcorner and yllconer (default is TRUE).
  • the last optional argument can be used so to specify how many decimal digits have to be exported into the ASCII Grid; default is 4 decimal digits.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionJpegJGW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionJpegJGW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionJpegJGW ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , quality Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the JPEG width and height dimensions at that resolution.
  • the last optional argument can be used so to specify the preferred JPEG quality (in the range 0 - 100); default is 80.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.
RL2_WriteSectionJpeg ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , pixelResolution Double ) : Integer

RL2_WriteSectionJpeg ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double ) : Integer

RL2_WriteSectionJpeg ( dbPrefix String , coverageName String , sectionID Integer , filePath String , width Integer , height Integer , boundingBox BLOB-Geometry , horzPixelResolution Double , vertPixelResolution Double , quality Integer ) : Integer
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.
Will return 1 (TRUE/SUCCESS) or 0 (FALSE/FAILURE): or -1 on invalid arguments.
Please note:
  • The dbPrefix argument is intended to specify the ATTACHED-DB where the Coverage is expected to be found; it could be eventually NULL, and in this case the MAIN DB will implicitly be assumed.
  • the boundingBox 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.
  • the horzPixelResolution and vertPixelResolution must exactly match the Coverage's base resolution or one of the resolutions made available by the corresponding Pyramid levels.
  • and the BoundingBox must exactly match the JPEG width and height dimensions at that resolution.
  • the last optional argument can be used so to specify the preferred JPEG quality (in the range 0 - 100); default is 80.
Please note very well: this SQL function is only available when the environment variable SPATIALITE_SECURITY=relaxed is set.



Back to RasterLite2 doc index Z 9233f94d575e6a37b8e9d66caae31e76