[Talk-ca] [OSM-talk] OSM, SpatiaLite and OpenJUMP

[Sam Vekemans]

Hi,
Im just forwarding this to the talk-ca discussion list, as i know there are
a number of folks across the country who are currently working with OpenJUMP
so they might be interested in seeing the progress.

I dont pretend to understand how it all works, but im sure that as the
Canada OSM Dataset becomes more richer with data, having the tools available
the the broader GIS industry will become more essential as time goes by.

Cheers,
Sam

On Tue, Feb 9, 2010 at 3:51 AM, Jukka Rahkonen <jukka.rahkonen at mmmtike.fi>wrote:

> Hi,
>
> I was testing two new SpatiaLite reader plugins for OpenJUMP and wrote a
> short
> tutorial into OpenJUMP wiki. Because I used, naturally, OpenStreetMap data
> as
> test data I was thinking that perhaps somebody here might be interested as
> well.
> The tutorial is at
> https://sourceforge.net/apps/mediawiki/jump-
> pilot/index.php?title=OpenJUMP_with_SpatialLite<https://sourceforge.net/apps/mediawiki/jump-%0Apilot/index.php?title=OpenJUMP_with_SpatialLite>
>
> SpatiaLite offers full SQL querying capabilities and quite a nice selection
> of
> spatial functions but the threshold to start using it is much lower than
> with
> PostGIS. There is no need to install and run any database program on a
> computer,
> no need to create user accounts or grant rights to the database etc.
>
> I consider that Spatialite does not offer especially much for OSM work at
> the
> moment. The only proper way to get OSM data into SpatiaLite format is to
> import
> data first into PostGIS with osm2pgsql, and need to use both PostGIS and
> SpatiaLite does not really make the threshold lower. But who knows, perhaps
> one
> day somebody begins to build ready made SpatiaLite excerpts.
>
> The tutorial is based on importing data from Geofabrik shapefiles which are
> giving just a faint idea about the richness (and mess) of OSM data. The
> same
> instructions will work with Cloudmade shapefiles as well. Good thing is
> that
> I am pretty sure that the system works as described for anybody, with one
> condition: Everything is tested only with Windows XP and Vista.
>
>
> _______________________________________________
> talk mailing list
> talk at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ca/attachments/20100209/c84aff0c/attachment.html>