<h1>Quick How-To Guide for the Planet Earth sample</h1>

<table width="100%" border="1" bgcolor="ffffe8" cellpadding="8" cellspacing="4">
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #1 - General
<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig_ex_dem">

<tr><td>
<h3>Step #1.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig_ex_tm">

<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig_ex_pol">

<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig_ex_topo">

<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #2 - Creating, populating and styling the Raster
<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig1">

<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig2">

<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig3">

<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig33">

<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #3 - Creating, populating and styling a Vector Coverage based on a Spatial
<tr><td>
<h3>Step #3.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig31">

<tr><td>
<h3>Step #3.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig32">

<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #4 - Creating, populating and styling a Vector Coverage based on a Spatial
<tr><td>
<h3>Step #4.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<verbatim>
CREATE VIEW countries_vw AS
SELECT pk_uid AS rowid, name AS name,
    CASE mapcolor7
        WHEN 1 THEN '#FF0000'
        WHEN 2 THEN '#00FF00'
        WHEN 3 THEN '#0000FF'
        WHEN 4 THEN '#FFFF00'
        WHEN 5 THEN '#FF00FF'
        WHEN 6 THEN '#00FFFF'
        ELSE '#808080'
    END color, geometry AS geom
FROM countries;

INSERT INTO views_geometry_columns VALUES
    ('countries_vw', 'geom', 'rowid', 'countries', 'geometry', 1);
</verbatim>

<tr><td>
<h3>Step #4.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig4">

<tr><td>
<h3>Step #4.3 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<pre>
<?xml version="1.0" encoding="UTF-8"?>
<PolygonSymbolizer version="1.1.0"


    <Name><font color="red"
    <Description>
        &lt;Title><font color="red" size="+2"><b>Countries - Political
        <Abstract><font color="red" size="+2"><b>A Style setting its Fill color from a Column
    </Description>
    <Fill>
        <SvgParameter name="fill"><font color="red"
        <SvgParameter name="fill-opacity">1.00</SvgParameter>
    </Fill>
    <Stroke>
        <SvgParameter name="stroke">#000000</SvgParameter>
        <SvgParameter name="stroke-opacity">1.00</SvgParameter>
        <SvgParameter name="stroke-width">1.00</SvgParameter>
        <SvgParameter name="stroke-linejoin">round</SvgParameter>
        <SvgParameter name="stroke-linecap">round</SvgParameter>
    </Stroke>
</PolygonSymbolizer>
</pre>


<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #5 - Creating, populating and styling a Vector Coverage based on a
<tr><td>
<h3>Step #5.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig5">

<tr><td>
<h3>Step #5.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig6">

<tr><td>
<h3>Step #5.3 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<verbatim>
SELECT TopoGeo_FromGeoTableNoFaceExt('topo_states', NULL, 'countries', NULL, 'dustbin', 'dustbin_view', 512);

SELECT TopoGeo_Polygonize('topo_states');

SELECT TopoGeo_UpdateSeeds('topo_states');
</verbatim>

<tr><td>
<h3>Step #5.4 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig7">

<tr><td>
<h3>Step #5.5 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig8">

<tr><td>
<h3>Step #5.6 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img alt="fig9">

</table>