Re: [OSM-talk] Osm2SpatiaLite ?
On 25/11/09 15:16, Jukka Rahkonen wrote: > Hi, > > Has anybody written a tool like osm2pgsql for importing OSM data directly into > SpatiaLite database? Alternatively, are there plans to make an OSM driver for > ogr2ogr? > > -Jukka Rahkonen- For my own needs I created a script to convert from OSM files to a sqlite database. It's no good if you want to use a GIS programme, but it's fine if you want to play around and analyse some openstreetmap data. The code is here: http://repo.or.cz/w/osm2sqlite.git Blog post explaining it: http://blog.technomancy.org/2009/11/29/osm2sqlite-a-programme-to-convert-from-osm-files-to-sqlite Rory signature.asc Description: PGP signature signature.asc Description: OpenPGP digital signature ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Osm2SpatiaLite ?
Hi, That's great news. I am sure that you will make an easy-to-use configuration system for selecting which features and tags will be imported into database. I am awaiting the next release. -Jukka- Lähettäjä: Igor Brejc [mailto:igor.br...@gmail.com] Lähetetty: 26. marraskuuta 2009 8:27 Vastaanottaja: Rahkonen Jukka Kopio: talk@openstreetmap.org Aihe: Re: [OSM-talk] Osm2SpatiaLite ? Hi, I've implemented importing of OSM data into SpatiaLite DB and integrated it successfully with Kosmos map rendering code. SpatiaLite OSM database can be quite fast, but I had to learn a trick or two to reach good performance. I even managed to import the latest UK data into it and it didn't complain too much. I'm planning to release this in Kosmos v3, hopefully sometimes in the spring of 2010. Igor On Wed, Nov 25, 2009 at 4:16 PM, Jukka Rahkonen wrote: Hi, Has anybody written a tool like osm2pgsql for importing OSM data directly into SpatiaLite database? Alternatively, are there plans to make an OSM driver for ogr2ogr? -Jukka Rahkonen- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Osm2SpatiaLite ?
Hi, I've implemented importing of OSM data into SpatiaLite DB and integrated it successfully with Kosmos map rendering code. SpatiaLite OSM database can be quite fast, but I had to learn a trick or two to reach good performance. I even managed to import the latest UK data into it and it didn't complain too much. I'm planning to release this in Kosmos v3, hopefully sometimes in the spring of 2010. Igor On Wed, Nov 25, 2009 at 4:16 PM, Jukka Rahkonen wrote: > Hi, > > Has anybody written a tool like osm2pgsql for importing OSM data directly > into > SpatiaLite database? Alternatively, are there plans to make an OSM driver > for > ogr2ogr? > > -Jukka Rahkonen- > > > ___ > talk mailing list > talk@openstreetmap.org > http://lists.openstreetmap.org/listinfo/talk > ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Osm2SpatiaLite ?
Jon Burgess googlemail.com> writes: > > Alternatively, are there plans to make an OSM driver for > > ogr2ogr? > > Not that I know of. I'm sure you could fallback to some path like: > > osm -> postgres -> shapefile -> spatialite I am doing it as osm -> postgres -> spatialite by using osm2pgsql for the first conversion and ogr2ogr for the second. I was just thinking that I would rather use only one tool. But I can live this way untill perhaps somebody starts delivering OSM excerpts directly as SpatiaLite database files one day. -Jukka- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
Re: [OSM-talk] Osm2SpatiaLite ?
On Wed, 2009-11-25 at 15:16 +, Jukka Rahkonen wrote: > Hi, > > Has anybody written a tool like osm2pgsql for importing OSM data directly into > SpatiaLite database? If you want to have a go yourself you could look at: http://trac.openstreetmap.org/ticket/1371 This copied the postgres code and changed it to use sqlite, but did not use SpatiaLite. The patch did not get applied as-is because I was unhappy at the code duplication, but it might get you started. > Alternatively, are there plans to make an OSM driver for > ogr2ogr? Not that I know of. I'm sure you could fallback to some path like: osm -> postgres -> shapefile -> spatialite Jon ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
[OSM-talk] Osm2SpatiaLite ?
Hi, Has anybody written a tool like osm2pgsql for importing OSM data directly into SpatiaLite database? Alternatively, are there plans to make an OSM driver for ogr2ogr? -Jukka Rahkonen- ___ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk