<h1>Quick How-To Guide for the Planet Earth sample</h1>
In this tutorial we'll assume that you've already studied and understood the tutorials about the <b>Giglio sample</b><br>
Now we'll examine the <b>Planet Earth sample</b> which will allow us to delve further into new details that we previously ignored.
<br><br>
The following table summarizes for quick reference all Coverages contained into the <b>Planet Earth</b> sample database:<br><br>
<table border="1" bgcolor="f0fff0" cellpadding="8" cellspacing="4">
<tr><th bgcolor="#d0d0d0">Coverage name</td><td bgcolor="#d0d0d0">Type</th><th
<tr><td>etopo1</td><td bgcolor="#f0c0a0">Raster</td><td>Global DEM - Digital Elevation
<tr><td>true_marble</td><td bgcolor="#f0c0a0">Raster</td><td>Natural colors - RGB low-resolution mosaic of Landsat
<tr><td>countries</td><td bgcolor="#a0c0f0">Vector</td><td>2D Polygons - National
<tr><td>countries_vw</td><td bgcolor="#a0c0f0">Vector</td><td>Spatial View derived from
<tr><td>topo_states</td><td bgcolor="#a0c0f0">Vector</td><td>Topology derived from
</table>
<br><br>
All datasets are based on <b><i>open available at the following URLs:
<ul>
<li><b>ETOPO1</b>: <a
<li><b>True Marble</b>: <a
<li><b>Countries</b>: <a
</ul>
<br><br><hr><br><br>
<table width="100%" border="1" bgcolor="ffffe8" cellpadding="8" cellspacing="4">
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #1 - General
<tr><td>
<table bgcolor="#80ffd0" cellpadding="14"><tr><td>
In this first contact with <b>Planet Earth</b> we'll simply test the basic rendering capabilities of the Map.<br><br>
You are simply expected to test the <b>pan</b> and <b>zoom</b> tools while switching on and off the various map layers.

<br><hr>
<h3>Step #1.1 - Testing the ETOPO1 background</h3>
The side figure shows how the Map will be when applying the following layers selection:
<ul>
<li><b>ETOPO1</b> background</li>
<li><b>Countries</b> (<i>National Boundaries - red lines</i>) with labels corresponding to each Nation.
<ul>
<li><b>Note</b>: labels will be printed only if they fit inside the <b>MBR</b> of the corresponding

</ul>
</td><td>
<img alt="fig_ex_dem">

<tr><td>
<h3>Step #1.2 - Testing the True Marble background</h3>
The side figure shows how the Map will be when applying the following layers selection:
<ul>
<li><b>True Marble</b> background</li>
<li><b>Countries</b> (same as above).
</ul>
</td><td>
<img alt="fig_ex_tm">

<tr><td>
<h3>Step #1.3 - Testing the Political Map</h3>
The side figure shows how the Map will be when applying the following layers selection:
<ul>
<li><b>Countries (view)</b> background
<ul>
<li><b>Note</b>: Each Country is internally filled with a different color, in such a way that confining Nations will never share the same color.</li>

<li><b>Countries</b> (same as above).
</ul>
</td><td>
<img alt="fig_ex_pol">

<tr><td>
<h3>Step #1.4 - Testing Topology</h3>
The side figure shows how the Map will be when applying the following layers selection:
<ul>
<li><b>topo_states (Topology)</b> alone. All Topology Primitives are represented as follows:
<ul>
<li><b>Nodes</b>: red circles.</li>
<li><b>Edges</b>: blue lines.</li>
<li><b>Faces</b>: pale yellow polygons.</li>
<li><b>Face Seeds</b>: yellow stars.</li>
<li><b>Edge Seeds</b>: yellow diamonds.</li>

</ul>
</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>