SE_ReloadRasterStyle

Replacing an existing Raster-Style in the Database

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

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

---

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

• SE_ReloadRasterStyle(Integer style_id, BLOB BLOB style)
• SE_ReloadRasterStyle(Text style_name, BLOB style)

---

Parameters [optional parameters : none]:

• style_id: the style_id found in SE_raster_styles or
• style_name: the style_name found in SE_raster_styles
• style: a BLOB created using XB_Create()

SELECT style_id,style_name FROM SE_raster_styles

---

• Sample
  • The registered Style will be identified either by
    • its unique Style ID or
    • by its Style Name
  • automatically retrieved from SLD/SE XML

SELECT SE_RegisterRasterStyledLayer
(
 -- chosen name of raster_coverage
 '2010.berlin_k5_schmettau',
 -- the style-name to use
 'rl2se.monochrome_red'
);

Afterwhich the following should show:

SELECT coverage_name, style_id FROM SE_raster_styled_layers
'2010.berlin_k5_schmettau' 1

or

SELECT 
 coverage_name, style_id,
 name,
 title,abstract 
FROM SE_raster_styled_layers_view
'2010.berlin_k5_schmettau' 1 
'rl2se.monochrome_red' 
'Monochrome CTR Red' 'Monochrome CTR: red instead of black'

---

2015-09-02: Mark Johnson, Berlin Germany

---