<html style="direction: ltr;">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"><style>body
p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
text="#000000">
<p>Sandro, developer of Spatialite has offered an alternate, better
organized and smaller sample spatialite database. The data are
released under CC-0 by the Provence of Trento, so freely
re-distributable.</p>
<p>His version, hosted on gaia-gis.it ( see [4] below ) is designed
and indexed with the newest version of spatialite. Since the
Ubuntu binaries are a version behind, a small change to his DB is
required to avoid it throwing an error when loading the data in
Spatialite-GUI.</p>
<p>Here [5] is my altered version. I've included a short readme.txt
. If this tar.gz could be placed in a stable download location on
OSGeo, I'll make the necessary changes to the
install-spatialite.sh and to the quickstart guide.</p>
<p>Regards,</p>
<p>Micha<br>
</p>
<br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Subject: </th>
<td>[SpatiaLite-Users] Re: Spatialite database on OSGeo Live
DVD</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Date: </th>
<td>Sun, 19 Feb 2012 05:39:01 -0800 (PST)</td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">From: </th>
<td>Micha <a class="moz-txt-link-rfc2396E" href="mailto:tsvibar@gmail.com"><tsvibar@gmail.com></a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">Reply-To:
</th>
<td><a class="moz-txt-link-abbreviated" href="mailto:spatialite-users@googlegroups.com">spatialite-users@googlegroups.com</a></td>
</tr>
<tr>
<th align="RIGHT" nowrap="nowrap" valign="BASELINE">To: </th>
<td>SpatiaLite Users <a class="moz-txt-link-rfc2396E" href="mailto:spatialite-users@googlegroups.com"><spatialite-users@googlegroups.com></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<pre>Hi Sandor:
Thanks for putting this together. I'll check with OSGeo if there's
time to switch to this DB.
As you might know, Ubuntu (and thus the OSGeo Live DVD) are still
using the 1.4.0 version of the spatialite-gui. So when I load the
trento DB I get this error:
SQLite Error: No such Module: VirtualSpatialIndex
Loading with the CLI spatialite (version 3.0.0 beta on Ubuntu) no such
error appears.
Shall I remove SpatialIndex table to avoid this?
Thanks, Micha
On Feb 19, 2:03 pm, "a.furieri" <a class="moz-txt-link-rfc2396E" href="mailto:a.furi...@lqt.it"><a.furi...@lqt.it></a> wrote:
> Hi Micha,
>
> the Autonomous Province of Trento [1] has released just last week
> several
> interesting geographic Open Data [2] under the CC0 license terms.
> This one is an absolutely free data license (Public Domain) [3]: so
> we
> can safely rearrange and redistribute these datasets in a full legal
> way
> with no restrictions at all.
> Attributing the datasets origin will be surely polite and kind, but
> isn't
> strictly required under the very liberal CC0 clauses.
>
> So I've prepared a sample SpatiaLite DB [3] containing the following
> tables:
> - Administrative Boundaries (Local Councils) [MultiPolygon]
> - Populated Places (footprints) [MultiPolygon]
> - Municipal Halls [Point]
> - Highways [Linestring]
> - Railways [Linestring]
>
> * I've added several Spatial Views based on the above tables
> * the DB was created using the latest splite v.3.0.2 (devel version)
> * it works nicely (both tables and views) even using old QGIS
> versions
> (tested on 1.7.0-Wroklav rev.13815)
> * it's reasonably compact: just 11.6 MB uncompressed (4 MB 7zipped).
>
> bye Sandro
>
> [1]<a class="moz-txt-link-freetext" href="http://en.wikipedia.org/wiki/Trentino">http://en.wikipedia.org/wiki/Trentino</a>
> [2]<a class="moz-txt-link-freetext" href="http://www.territorio.provincia.tn.it/portal/server.pt?open=512&objID">http://www.territorio.provincia.tn.it/portal/server.pt?open=512&objID</a>...
> [3]<a class="moz-txt-link-freetext" href="http://creativecommons.org/publicdomain/zero/1.0/">http://creativecommons.org/publicdomain/zero/1.0/</a>
> [4]<a class="moz-txt-link-freetext" href="http://www.gaia-gis.it/trento-CC0-OSGeo-live.7z">http://www.gaia-gis.it/trento-CC0-OSGeo-live.7z</a>
[5] <a class="moz-txt-link-freetext" href="http://www.surfaces.co.il/dl/trento.sqlite.tar.gz">http://www.surfaces.co.il/dl/trento.sqlite.tar.gz</a>
--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To post to this group, send email to <a class="moz-txt-link-abbreviated" href="mailto:spatialite-users@googlegroups.com">spatialite-users@googlegroups.com</a>.
To unsubscribe from this group, send email to <a class="moz-txt-link-abbreviated" href="mailto:spatialite-users+unsubscribe@googlegroups.com">spatialite-users+unsubscribe@googlegroups.com</a>.
For more options, visit this group at <a class="moz-txt-link-freetext" href="http://groups.google.com/group/spatialite-users?hl=en">http://groups.google.com/group/spatialite-users?hl=en</a>.
This mail was received via Mail-SeCure System.
</pre>
</body>
</html>