D 2020-09-12T09:49:08.376
L Sample\sPlanet\sEarth
U sandro
W 6249
<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 Introduction</h1></th></tr>
<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig_ex_dem.png" alt="fig_ex_dem">
</td></tr>
<tr><td>
<h3>Step #1.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig_ex_tm.png" alt="fig_ex_tm">
</td></tr>
<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig_ex_pol.png" alt="fig_ex_pol">
</td></tr>
<tr><td>
<h3>Step #1.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig_ex_topo.png" alt="fig_ex_topo">
</td></tr>
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #2 - Creating, populating and styling the Raster Coverages</h1></th></tr>
<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig1.png" alt="fig1">
</td></tr>
<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig2.png" alt="fig2">
</td></tr>
<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig3.png" alt="fig3">
</td></tr>
<tr><td>
<h3>Step #2.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig33.png" alt="fig33">
</td></tr>
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #3 - Creating, populating and styling a Vector Coverage based on a Spatial Table</h1></th></tr>
<tr><td>
<h3>Step #3.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig31.png" alt="fig31">
</td></tr>
<tr><td>
<h3>Step #3.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig32.png" alt="fig32">
</td></tr>
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #4 - Creating, populating and styling a Vector Coverage based on a Spatial View</h1></th></tr>
<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>
</td></tr>
<tr><td>
<h3>Step #4.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig4.png" alt="fig4">
</td></tr>
<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"
xsi:schemaLocation="http://www.opengis.net/se http://schemas.opengis.net/se/1.1.0/Symbolizer.xsd"
xmlns="http://www.opengis.net/se" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
uom="http://www.opengeospatial.org/se/units/pixel">
<Name><font color="red" size="+2"><b>countries_col</b></font></Name>
<Description>
<Title><font color="red" size="+2"><b>Countries - Political Map</b></font></Title>
<Abstract><font color="red" size="+2"><b>A Style setting its Fill color from a Column Value</b></font></Abstract>
</Description>
<Fill>
<SvgParameter name="fill"><font color="red" size="+2"><b>@color@</b></font></SvgParameter>
<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>
</td></tr>
</td></tr>
<tr><th bgcolor="#c0ffc0" colspan="2"><h1>Step #5 - Creating, populating and styling a Vector Coverage based on a Topology</h1></th></tr>
<tr><td>
<h3>Step #5.1 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig5.png" alt="fig5">
</td></tr>
<tr><td>
<h3>Step #5.2 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig6.png" alt="fig6">
</td></tr>
<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>
</td></tr>
<tr><td>
<h3>Step #5.4 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig7.png" alt="fig7">
</td></tr>
<tr><td>
<h3>Step #5.5 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig8.png" alt="fig8">
</td></tr>
<tr><td>
<h3>Step #5.6 - Preparing to load the Coverages in MapPanel</h3>
</td><td>
<img src="https://www.gaia-gis.it/gaia-sins/MapPanelPics/PlanetEarth/fig9.png" alt="fig9">
</td></tr>
</table>
Z d75c87adb0cdbc5c417bb0f1c34d2a67