SE_ReloadRasterStyle

Replacing/Updating an existing Raster-Style in the Database

--> 'List of Sql-Commands'

<-- 'Index Page for RasterLite2 - Commands'

---

Original Documentation RasterLite2 SQL functions - reference list)

• SE_ReloadRasterStyle(Integer style_id, BLOB BLOB style)

or

• 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

and

• 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_ReloadRasterStyle
( 
 -- the style-name to use
 'rl2se.monochrome_red',
 --create the BLOB
 XB_Create
 ( -- load the external xml file
  XB_LoadXML
  ( -- the value of 'Name' will be used as the style_name 'rl2se.monochrome_red'
   '../../common/source_styles/raster/rl2se.monochrome_red.xml'
  ),
  -- compression
  1, 
  -- with validation
  1  
 )
);

---

2015-09-02: Mark Johnson, Berlin Germany

---