Re: [OSM-dev] 'missing column in osmosis pgsql dump' - revisited from June 2009
On Fri, May 14, 2010 at 6:25 PM, Sarah Hoffmann wrote: > > > Hi Steve, > > > > Is there any reason you're still using 0.31? 0.35 has been released and > > will include these fixes so you shouldn't need to compile your own from > SVN. > > I recently had a version problem because there was an outdated link on the > page > http://wiki.openstreetmap.org/wiki/Osmosis/Installation > > It pointed to an old version on your own server. I've taken the liberty to > fix the wiki page now. > Great, thanks. I didn't realise that page existed. > > BTW I noticed that in the release tarballs bin/osmosis is not executable. > Not a big problem but a bit inconvenient. > Thanks for the report. It's fixed in SVN now. It looks like I introduced a few issues when I updated the tar tasks recently. Brett ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] 'missing column in osmosis pgsql dump' - revisited from June 2009
On Fri, May 14, 2010 at 09:58:14AM +1000, Brett Henderson wrote: > On Fri, May 14, 2010 at 9:27 AM, Middle Fork GIS > wrote: > > > >> The 0.31 release will be fine, but the latest subversion code should > > >>also be stable. > > > > I seem to have rediscovered this problem, and it seems to exist in the with > > the 0.31 version but be fixed in the svn snapshot from 5/11/2010: > > > > Hi Steve, > > Is there any reason you're still using 0.31? 0.35 has been released and > will include these fixes so you shouldn't need to compile your own from SVN. I recently had a version problem because there was an outdated link on the page http://wiki.openstreetmap.org/wiki/Osmosis/Installation It pointed to an old version on your own server. I've taken the liberty to fix the wiki page now. BTW I noticed that in the release tarballs bin/osmosis is not executable. Not a big problem but a bit inconvenient. Sarah ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] 'missing column in osmosis pgsql dump' - revisited from June 2009
On Fri, May 14, 2010 at 9:27 AM, Middle Fork GIS wrote: > >> The 0.31 release will be fine, but the latest subversion code should > >>also be stable. > > I seem to have rediscovered this problem, and it seems to exist in the with > the 0.31 version but be fixed in the svn snapshot from 5/11/2010: > Hi Steve, Is there any reason you're still using 0.31? 0.35 has been released and will include these fixes so you shouldn't need to compile your own from SVN. However, I just checked in a new feature into SVN last night that you may be interested in. I've created a (--fast-write-pgsql) --fwp task. It generates and loads COPY files into the database for you. I can't remember the arguments off the top of my head, although just specifying database parameters should be sufficient. I think the only other option is a nodeLocationStoreType argument which defaults to TempFile. It generates all the COPY files as temp files first, then loads them in, so the overall steps are the same but it's much more convenient. It will auto-detect the bbox and linestring columns on the way table so you don't need to explicitly specify those. Brett ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] 'missing column in osmosis pgsql dump' - revisited from June 2009
Well, I don't know how I missed the fact that you were already on version 0.35, thus making the below totally irrelevant. I must have found a stale link somewhere to 0.31. I think this is one of those 'NeverMind!' moments. -s > > >> The 0.31 release will be fine, but the latest subversion code should > >>also be stable. > > I seem to have rediscovered this problem, and it seems to exist in the with > the 0.31 version but be fixed in the svn snapshot from 5/11/2010: > > Note the execution of both versions on the same planet file and their > resultant nodes.txt output: > > *Version 0.31: No changeset_id data:* > bzcat /data/world/osm/planet/planet-100505.osm.bz2 | * > ./osmosis/osmosis-0.31/bin/osmosis* --rx file=- outPipe.0="mypipe" --wpd > directory=/data/world/osm/pgimport enableBboxBuilder=yes > enableLinestringBuilder=yes nodeLocationStoreType="TempFile" > inPipe.0="mypipe" > > $ head nodes.txt > 2 13 67792 2010-05-02 10:42:09-0400 > 010120E610E3587270449A2040840948A066114940 > 3 3 5164 2009-04-14 11:42:58-0400 > 010120E61037F7FCD58805C3BF4DA9A67FA4C34940 > 4 5 57932 2009-11-19 14:33:41-0500 > 010120E610D6FC9D9218A9C2BF7C8D6ECED2C24940 > 5 3 5164 2009-04-14 11:42:59-0400 > 010120E610E3FC4D2844C0C2BF28BC5F60B1C34940 > 6 3 5164 2009-04-14 11:42:59-0400 > 010120E610C04989134EC1C2BF6F0C01C0B1C34940 > 7 3 5164 2009-04-14 11:43:00-0400 > 010120E6105177AFA4260BC3BFA7BBA1DFADC34940 > 8 3 5164 2009-04-14 11:43:00-0400 > 010120E610F66E3D5464BEC2BF149337C0CCC34940 > 9 3 5164 2009-04-14 11:43:01-0400 > 010120E610B8E45D9AC706C3BF8879A05FA5C34940 > 11 5 24748 2010-04-02 15:47:35-0400 > 010120E610227E0FA8C860524006ED7A0ED1551040 > 14 3 5164 2009-04-14 11:43:03-0400 > 010120E610182312859615F0BF59445E2052804940 > > *SVN: changeset_id data is present:* > bzcat /data/world/osm/planet/planet-100505.osm.bz2 | * > ./osmosis/svn/osmosis/bin/osmosis* --rx file=- outPipe.0="mypipe" --wpd > directory=/data/world/osm/pgimport2 enableBboxBuilder=yes > enableLinestringBuilder=yes nodeLocationStoreType="TempFile" > inPipe.0="mypipe" > > $head nodes.txt > 2 13 67792 2010-05-02 10:42:09-0400 4585831 > 010120E610E3587270449A2040840948A066114940 > 3 3 5164 2009-04-14 11:42:58-0400 524633 > 010120E61037F7FCD58805C3BF4DA9A67FA4C34940 > 4 5 57932 2009-11-19 14:33:41-0500 3163136 > 010120E610D6FC9D9218A9C2BF7C8D6ECED2C24940 > 5 3 5164 2009-04-14 11:42:59-0400 524633 > 010120E610E3FC4D2844C0C2BF28BC5F60B1C34940 > 6 3 5164 2009-04-14 11:42:59-0400 524633 > 010120E610C04989134EC1C2BF6F0C01C0B1C34940 > 7 3 5164 2009-04-14 11:43:00-0400 524633 > 010120E6105177AFA4260BC3BFA7BBA1DFADC34940 > 8 3 5164 2009-04-14 11:43:00-0400 524633 > 010120E610F66E3D5464BEC2BF149337C0CCC34940 > 9 3 5164 2009-04-14 11:43:01-0400 524633 > 010120E610B8E45D9AC706C3BF8879A05FA5C34940 > 11 5 24748 2010-04-02 15:47:35-0400 4307385 > 010120E610227E0FA8C860524006ED7A0ED1551040 > 14 3 5164 2009-04-14 11:43:03-0400 524633 > 010120E610182312859615F0BF59445E2052804940 > > > -Steve > > ps Thanks for the great tool! > -- next part -- > An HTML attachment was scrubbed... > URL: > http://lists.openstreetmap.org/pipermail/dev/attachments/20100513/4678db28/attachment.htm > > -- > > ___ > dev mailing list > dev@openstreetmap.org > http://lists.openstreetmap.org/listinfo/dev > > > End of dev Digest, Vol 62, Issue 15 > *** > ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] 'missing column in osmosis pgsql dump' - revisited from June 2009
>> The 0.31 release will be fine, but the latest subversion code should >>also be stable. I seem to have rediscovered this problem, and it seems to exist in the with the 0.31 version but be fixed in the svn snapshot from 5/11/2010: Note the execution of both versions on the same planet file and their resultant nodes.txt output: *Version 0.31: No changeset_id data:* bzcat /data/world/osm/planet/planet-100505.osm.bz2 | * ./osmosis/osmosis-0.31/bin/osmosis* --rx file=- outPipe.0="mypipe" --wpd directory=/data/world/osm/pgimport enableBboxBuilder=yes enableLinestringBuilder=yes nodeLocationStoreType="TempFile" inPipe.0="mypipe" $ head nodes.txt 2 13 67792 2010-05-02 10:42:09-0400 010120E610E3587270449A2040840948A066114940 3 3 5164 2009-04-14 11:42:58-0400 010120E61037F7FCD58805C3BF4DA9A67FA4C34940 4 5 57932 2009-11-19 14:33:41-0500 010120E610D6FC9D9218A9C2BF7C8D6ECED2C24940 5 3 5164 2009-04-14 11:42:59-0400 010120E610E3FC4D2844C0C2BF28BC5F60B1C34940 6 3 5164 2009-04-14 11:42:59-0400 010120E610C04989134EC1C2BF6F0C01C0B1C34940 7 3 5164 2009-04-14 11:43:00-0400 010120E6105177AFA4260BC3BFA7BBA1DFADC34940 8 3 5164 2009-04-14 11:43:00-0400 010120E610F66E3D5464BEC2BF149337C0CCC34940 9 3 5164 2009-04-14 11:43:01-0400 010120E610B8E45D9AC706C3BF8879A05FA5C34940 11 5 24748 2010-04-02 15:47:35-0400 010120E610227E0FA8C860524006ED7A0ED1551040 14 3 5164 2009-04-14 11:43:03-0400 010120E610182312859615F0BF59445E2052804940 *SVN: changeset_id data is present:* bzcat /data/world/osm/planet/planet-100505.osm.bz2 | * ./osmosis/svn/osmosis/bin/osmosis* --rx file=- outPipe.0="mypipe" --wpd directory=/data/world/osm/pgimport2 enableBboxBuilder=yes enableLinestringBuilder=yes nodeLocationStoreType="TempFile" inPipe.0="mypipe" $head nodes.txt 2 13 67792 2010-05-02 10:42:09-0400 4585831 010120E610E3587270449A2040840948A066114940 3 3 5164 2009-04-14 11:42:58-0400 524633 010120E61037F7FCD58805C3BF4DA9A67FA4C34940 4 5 57932 2009-11-19 14:33:41-0500 3163136 010120E610D6FC9D9218A9C2BF7C8D6ECED2C24940 5 3 5164 2009-04-14 11:42:59-0400 524633 010120E610E3FC4D2844C0C2BF28BC5F60B1C34940 6 3 5164 2009-04-14 11:42:59-0400 524633 010120E610C04989134EC1C2BF6F0C01C0B1C34940 7 3 5164 2009-04-14 11:43:00-0400 524633 010120E6105177AFA4260BC3BFA7BBA1DFADC34940 8 3 5164 2009-04-14 11:43:00-0400 524633 010120E610F66E3D5464BEC2BF149337C0CCC34940 9 3 5164 2009-04-14 11:43:01-0400 524633 010120E610B8E45D9AC706C3BF8879A05FA5C34940 11 5 24748 2010-04-02 15:47:35-0400 4307385 010120E610227E0FA8C860524006ED7A0ED1551040 14 3 5164 2009-04-14 11:43:03-0400 524633 010120E610182312859615F0BF59445E2052804940 -Steve ps Thanks for the great tool! ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
