RL2_GetRasterCoverageDefaults

Retrieving of RasterDefaults

[--> 'List of Sql-Commands'] (Home#commands)

[<-- 'Index Page for RasterLite2 - Commands'] (RasterLite2-Index#commands)

[<-- 'Cutline / RasterDefaults Index'] (Cutline-Index#rasterdefaults)

---

Original Documentation [[RasterLite2 SQL functions - reference list)|https://www.gaia-gis.it/fossil/librasterlite2/wiki?name=sql_reference_list]]

• RL2_GetRasterCoverageDefaults(text coverage, int parm_type)

---

Parameters [optional parameters]:

• coverage: chosen name of raster_coverage
• [parm_type]: 0,1,2,3,4,5,13,14,15 [return type of result]
  • 0 : [default] - Text representation of all parms, divided by
    • ';' : between the center-point values and the zoom-level values
    • ',' : between the single values of the center-point or zoom-level
      • center_x,center_y,coverage_srid;zoom_min,zoom_default.zoom_max
  • 1 : center point as blob / geometry
  • 2 : center point as ewkt
  • 3 : zoom_min as integer
  • 4 : zoom_default as integer
  • 5 : zoom_max as integer
  • 13 : scale of zoom_min as double
  • 14 : scale of zoom_default as double
  • 15 : scale of zoom_max as double
  • 23 : resolution of zoom_min as double
  • 24 : resolution of zoom_default as double
  • 25 : resolution of zoom_max as double

---

• Sample of default usage with
  • together with the raster_coverage name

SELECT 
 coverage_name,
 RL2_GetRasterCoverageDefaults(coverage_name) AS csv_text
FROM raster_coverages;

The result of the command would then look like this:

1861.world_mercators	           -1982.3723119,-1224.5405843,3395;3,5,7
1868.rote_rathausturm_panorama	   4987.5000000,502.0000000,-1;15,17,19
1927.436b_43668	                   6400.0000000,28000.0000000,3068;16,18,20
dritte_landesaufnahme_toscana	   28.5000000,43.0000000,4805;10,13,16
dritte_landesaufnahme_toscana_dir  28.5000000,43.0000000,4805;6,13,20

---

• Sample to retrieve the Zoom_Levels of min/default/max as integer
  • together with the raster_coverage name

SELECT 
 coverage_name,
 RL2_GetRasterCoverageDefaults(coverage_name,3) AS zoom_min, 
 RL2_GetRasterCoverageDefaults(coverage_name,4) AS zoom_default, 
 RL2_GetRasterCoverageDefaults(coverage_name,5) AS zoom_max
FROM raster_coverages;

The result of the command would then look like this:

1861.world_mercators	                3	5	7
1868.rote_rathausturm_panorama	       15	17	19
1927.436b_43668	                       16	18	20
dritte_landesaufnahme_toscana	       10	13	16
dritte_landesaufnahme_toscana_dir	6	13	20

---

• Sample to retrieve the Scale of min/default/max Zoom-Levels as double
  • together with the raster_coverage name

SELECT 
 coverage_name,
 RL2_GetRasterCoverageDefaults(coverage_name,13) AS scale_min,
 RL2_GetRasterCoverageDefaults(coverage_name,14) AS scale_double,
 RL2_GetRasterCoverageDefaults(coverage_name,15) AS scale_max
FROM raster_coverages;

The result of the command would then look like this:

---

• Sample to retrieve the Resolution of min/default/max Zoom-Levels as double
  • together with the raster_coverage name

SELECT 
 coverage_name,
 RL2_GetRasterCoverageDefaults(coverage_name,23) AS resolution_min,
 RL2_GetRasterCoverageDefaults(coverage_name,24) AS resolution_default,
 RL2_GetRasterCoverageDefaults(coverage_name,25) AS resolution_max
FROM raster_coverages;

---

2015-11-11: Mark Johnson, Berlin Germany

---