[Live-demo] Fwd: [SpatiaLite-Users] Re: Spatialite database on OSGeo Live DVD

[Cameron Shorter]

Micha, Sandor,
Our strong preference is to use datasets already installed on 
OSGeo-Live. I've already mentioned that it reduces size, but the other 
reason is that uses can test 2 different databases with the same data 
and see how they do or do not differ.

For instance, the QGIS quickstart may say:
Connect to the Natural Earth dataset, which is available in either 
PostGIS or Spatialite, then select the ...

So before we add another dataset, could you please answer whether we can 
make use of the natural earth dataset already included, linked from 
here: http://live.osgeo.org/en/overview/overview.html

Micha, again, could you please forward this email on.

On 20/02/12 06:28, Micha Silver wrote:
>
> 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.
>
> 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.
>
> 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.
>
> Regards,
>
> Micha
>
>
> -------- Original Message --------
> Subject: 	[SpatiaLite-Users] Re: Spatialite database on OSGeo Live DVD
> Date: 	Sun, 19 Feb 2012 05:39:01 -0800 (PST)
> From: 	Micha <tsvibar at gmail.com>
> Reply-To: 	spatialite-users at googlegroups.com
> To: 	SpatiaLite Users <spatialite-users at googlegroups.com>
>
>
>
> 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.furi... at lqt.it>  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]http://en.wikipedia.org/wiki/Trentino
> >  [2]http://www.territorio.provincia.tn.it/portal/server.pt?open=512&objID...
> >  [3]http://creativecommons.org/publicdomain/zero/1.0/
> >  [4]http://www.gaia-gis.it/trento-CC0-OSGeo-live.7z
>
> [5]http://www.surfaces.co.il/dl/trento.sqlite.tar.gz
>
> -- 
> You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
> To post to this group, send email tospatialite-users at googlegroups.com.
> To unsubscribe from this group, send email tospatialite-users+unsubscribe at googlegroups.com.
> For more options, visit this group athttp://groups.google.com/group/spatialite-users?hl=en.
>
>
> This mail was received via Mail-SeCure System.
>
>
>
>
> _______________________________________________
> Live-demo mailing list
> Live-demo at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/live-demo
> http://live.osgeo.org
> http://wiki.osgeo.org/wiki/Live_GIS_Disc


-- 
Cameron Shorter
Geospatial Solutions Manager
Tel: +61 (0)2 8570 5050
Mob: +61 (0)419 142 254

Think Globally, Fix Locally
Geospatial Solutions enhanced with Open Standards and Open Source
http://www.lisasoft.com


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/osgeolive/attachments/20120220/5e8dcdee/attachment.html>