Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Jon Burgess wrote: The version I provided was cross-compiled from Fedora using the mingw32 tools. The osm2pgsql code itself should be fairly simple to compile, you are more likely to run into difficulties getting the dependencies compiled or installed. a 32 bit version is not that difficult. I tried to get 64 bit and had to give up because the dependencies could not be build. pgsql-lib was the biggest problem. Later patched the available binary to enable it accessing 4GB of RAM. (Large Adress Aware) That is double the amount that is usually available. Would be great if someone could review the code whether it's doing nasty pointer arithmetic. If not that linker flag should be enabled by default. Stephan ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Hey Peter, I got your Centos Binary, changemod it, got it to run, but when i run it, i get an error: $ ./osm2pgsql-r19130-centos5 ./osm2pgsql-r19130-centos5: error while loading shared libraries: libgeos-3.1.0.so: cannot open shared object file: No such file or directory complaning about libgeos and cannot open the shared object file, I tried doing yum install geos any good step by step instructions for centos out there on how to configure osm2pgsql to work and it said I got the latest version, any help would be much appreciated, thank you! From: jburgess...@googlemail.com To: osm-li...@mazdermind.de Date: Thu, 17 Dec 2009 22:05:44 + CC: dev@openstreetmap.org Subject: Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset On Thu, 2009-12-17 at 11:44 +0100, Peter Körner wrote: Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. How is osm2pgsql compiled on windows? What Software do I need? Will VC++ Express do it? The version I provided was cross-compiled from Fedora using the mingw32 tools. The osm2pgsql code itself should be fairly simple to compile, you are more likely to run into difficulties getting the dependencies compiled or installed. Jon ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev _ Hotmail: Free, trusted and rich email service. http://clk.atdmt.com/GBL/go/171222984/direct/01/___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Hi Quy phan, I'm not using osm2pgsql under centos, I just had a spare machine around where I compiled the binaries. To do this i installed (despite others) geos and geos-devel -- maybe you also need the latter? Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Hmm interesting, thank you for your response, any way I can get the most-up-to-date osm2pgsql? I been trying to search the internet to find it... No luck. The windows binary version would be great. Looking for the udpated osm2pgsql As per http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows http://tile.openstreetmap.org/osm2pgsql.zip Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. Regards, Marc -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/chbrowser ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Marc Schütz wrote: Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. Since the API 0.6 switchover. If you let the older osm2pgsql continue until it parses the planet past the changeset tags, it will still work correctly. Newer versions just ignore the tags. -- Lennard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. How is osm2pgsql compiled on windows? What Software do I need? Will VC++ Express do it? Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Marc Schütz schuetzm at gmx.net writes: Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. Hi, Both osm2pgsql Windows binaries that exist are populating my PostGIS tables OK. I am importing Finland.osm.bz2 excerpt from Geofabrik with the one made by Artem every day. It does not complain about changesets. I do not know if they are included in Geofabrik .osm files. -Jukka Rahkonen- ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Hey guys, thanks for all the input, much much much appreciated! Peter you are right; my osm2pgsql was out of date, it was not able to handle the changeset element. Jon, thank you for the updated osm2pgsql, much appreciated! I got the map to start reading; now the long long wait =) Another quick question; any of you guys got the binary or source for osm2pgsql on linux systems(centos, redhat). I got some some source files, but was unable to make it. I had some errors. If anyone can show me to the source files or objects for osm2pgsql on linux systems, that would be awesome. A guide on linux would be great too =) Thank you, Much appreciated help!!! Subject: Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset From: jburgess...@googlemail.com To: quyminhp...@hotmail.com CC: osm-li...@mazdermind.de; dev@openstreetmap.org Date: Wed, 16 Dec 2009 20:45:02 + On Wed, 2009-12-16 at 11:46 -0800, Quy phan wrote: Hmm interesting, thank you for your response, any way I can get the most-up-to-date osm2pgsql? I been trying to search the internet to find it... No luck. The windows binary version would be great. Looking for the udpated osm2pgsql As per http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows http://tile.openstreetmap.org/osm2pgsql.zip Jon _ Hotmail: Free, trusted and rich email service. http://clk.atdmt.com/GBL/go/171222984/direct/01/___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
On Thu, 2009-12-17 at 10:56 +0100, Marc Schütz wrote: Hmm interesting, thank you for your response, any way I can get the most-up-to-date osm2pgsql? I been trying to search the internet to find it... No luck. The windows binary version would be great. Looking for the udpated osm2pgsql As per http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows http://tile.openstreetmap.org/osm2pgsql.zip Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. The osm2pgsql code to ignore the changeset tag was put in a long time ago: r15131 | jonb | 2009-05-20 19:54:53 +0100 (Wed, 20 May 2009) | 1 line Update osm2pgsql to ignore changeset elements I did test a small osm file with some changeset tags to verify this before I posted the link. Does it not work for you? Jon ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
If anyone can show me to the source files or objects for osm2pgsql on linux systems, that would be awesome. I made a build on CentOS5 and one on Ubuntu9.10 http://toolserver.org/~mazder/temp/osm2pgsql/osm2pgsql-r19130-centos5 http://toolserver.org/~mazder/temp/osm2pgsql/osm2pgsql-r19130-ubuntu9.10 I won't provide updates but I'll leave the files there. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
On Thu, 2009-12-17 at 09:31 -0800, Quy phan wrote: Hey guys, thanks for all the input, much much much appreciated! Peter you are right; my osm2pgsql was out of date, it was not able to handle the changeset element. Jon, thank you for the updated osm2pgsql, much appreciated! I got the map to start reading; now the long long wait =) Another quick question; any of you guys got the binary or source for osm2pgsql on linux systems(centos, redhat). I got some some source files, but was unable to make it. I had some errors. If anyone can show me to the source files or objects for osm2pgsql on linux systems, that would be awesome. A guide on linux would be great too =) It should be fairly easy to build on a recent CentOS or RHEL. The dependencies are listed in the README.txt. The Fedora instructions will probably work: http://wiki.openstreetmap.org/wiki/Osm2pgsql#Fedora If you still run into problems then you should include the error messages in your email. Jon ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
On Thu, 2009-12-17 at 11:44 +0100, Peter Körner wrote: Changesets are only included in planet.osm since a few weeks, right? As the file linked in the wiki is from July, it will not help him. How is osm2pgsql compiled on windows? What Software do I need? Will VC++ Express do it? The version I provided was cross-compiled from Fedora using the mingw32 tools. The osm2pgsql code itself should be fairly simple to compile, you are more likely to run into difficulties getting the dependencies compiled or installed. Jon ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Note: Other OSM data such as, california.osm or asia.osm works, osm2pgsql is able to read the data... I believe the planet.osm is corrupted while unzipping/downloading? I beleive your osm2pgsql is outdated. california.osm co. does not contain changeset ..-elements while the planet.osm does. It seems your osm2pgsql is unable to handle this. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name :changeset
Drive space is a likely problem - the planet may require an additional 60-70 GB to populate the Postgres DB. You may be able to make it work by first compressing the planet as a .bz2 file; that will free up about 110 GB of space. osm2pgsql can read from this compressed file. From: Quy phan Sent: Wednesday, December 16, 2009 2:18 PM To: dev@openstreetmap.org Subject: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name :changeset Hey guys, I really need some help, I been trying to debug this problem for days but still no luck, I am sure there are people on this forum who have the knowledge to help out. My setup: Window xp, P4, 3.0Gigs, 4 gigs of ram. Only 12 gigs of hard drive space available - Is hard drive space a problem because the planet.osm is 120gigs when I unzipped it. - I also turned off autovaccum for postgres, I am on postgres 8.3 - Postgis is on 1.3.6 - My osm2pgsql might be old, any links to the latest windows binary version? Here is the problem: When I did osm2pgsql --slim -C 1536 -d geoserver planet.osm It sets up table correctly (no errors) It fails when it tries to read in planet.osm A series of StartElement: Unknown element name: changeset EndElement: Unknown element name: changeset StartElement: Unknown element name: changeset EndElement: Unknown element name: changeset StartElement: Unknown element name: changeset EndElement: Unknown element name: changeset and so on repeatedly forever pops out, then i Control C to cancel. Note: Other OSM data such as, california.osm or asia.osm works, osm2pgsql is able to read the data... I believe the planet.osm is corrupted while unzipping/downloading? Any suggestions or ideas? Thank you! Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up now. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
Hmm interesting, thank you for your response, any way I can get the most-up-to-date osm2pgsql? I been trying to search the internet to find it... No luck. The windows binary version would be great. Looking for the udpated osm2pgsql Date: Wed, 16 Dec 2009 20:36:55 +0100 From: osm-li...@mazdermind.de To: quyminhp...@hotmail.com CC: dev@openstreetmap.org Subject: Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset Note: Other OSM data such as, california.osm or asia.osm works, osm2pgsql is able to read the data... I believe the planet.osm is corrupted while unzipping/downloading? I beleive your osm2pgsql is outdated. california.osm co. does not contain changeset ..-elements while the planet.osm does. It seems your osm2pgsql is unable to handle this. Peter _ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/177141665/direct/01/___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Osm2pgsql - Planet.osm fail - Unknown Element name : changeset
On Wed, 2009-12-16 at 11:46 -0800, Quy phan wrote: Hmm interesting, thank you for your response, any way I can get the most-up-to-date osm2pgsql? I been trying to search the internet to find it... No luck. The windows binary version would be great. Looking for the udpated osm2pgsql As per http://wiki.openstreetmap.org/wiki/Osm2pgsql#Windows http://tile.openstreetmap.org/osm2pgsql.zip Jon ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
