|
osdir.com mailing list archive |
|
Subject: Re: doubled trackpoints - msg#00020List: gis.openstreetmap.devel> fixed > > needed a 'distinct' clause in the sql... Make it a 'distinctrow' and it should perform 20% - 50% faster. ;) BTW: I closed bug 28 (old bugzilla) with Revision 661, but my changes got reverted by Revision 672. Bug 28 was something about that the correct namespace declaration of GPX is "http://www.topografix.com/GPX/1/0"; while the server wrongly returns "http://www.topografix.com/GPX/1/0/gpx.xsd";. Why was the change reverted? Maybe someone edited the live ruby files on the server and copied them back without doing a merge, and that overwrote my changes? If the live ruby files on the server are edited for any reason (which is IMHO not a good idea), then please, edit them as subversion repository and do proper merging. Ciao, Imi. Thread at a glance:
Previous Message by Date: click to view message previewRe: doubled trackpointsfixed needed a 'distinct' clause in the sql... * @ 01/12/05 07:13:10 PM immanuel.scholz@xxxxxx wrote: > I got this as trackpoints: > > <gpx version='1.0' xmlns='http://www.topografix.com/GPX/1/0/gpx.xsd'> > <trk> > <trkseg> > <trkpt lon='11.502753333' lat='48.131303333'/> > <trkpt lon='11.502725' lat='48.131726667'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > ... (about 40 times) > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > ... (again, about 100 times) > > > and so on.. Maybe the script that imports the trackpoints should skip > already uploaded ones? If doubled trackpoints are the intention, then at > least the select statement in trackpoints.rb should include a > "distinct". > > Or is there a reason to transfer the same point over and over again? > (Maybe the applet draw this extra bold, burned into the monitor ;-) > > Ciao, Imi. > > > > _______________________________________________ > Openstreetmap-dev mailing list > Openstreetmap-dev@xxxxxxxxxxxx > http://bat.vr.ucl.ac.uk/cgi-bin/mailman/listinfo/openstreetmap-dev have fun, SteveC steve@xxxxxxxxxxxx http://www.asklater.com/steve/ Next Message by Date: click to view message previewRe: doubled trackpoints* @ 03/12/05 10:40:47 AM immanuel.scholz@xxxxxx wrote: > Am Samstag, den 03.12.2005, 03:33 +0000 schrieb SteveC: > > fixed > > > > needed a 'distinct' clause in the sql... > > Make it a 'distinctrow' and it should perform 20% - 50% faster. ;) fixed > BTW: I closed bug 28 (old bugzilla) with Revision 661, but my changes > got reverted by Revision 672. > > Bug 28 was something about that the correct namespace declaration of GPX > is "http://www.topografix.com/GPX/1/0" while the server wrongly returns > "http://www.topografix.com/GPX/1/0/gpx.xsd". fixed > Why was the change reverted? > > Maybe someone edited the live ruby files on the server and copied them > back without doing a merge, and that overwrote my changes? that someone would be me > If the live ruby files on the server are edited for any reason (which is > IMHO not a good idea), then please, edit them as subversion repository > and do proper merging. That'd take ages, hence the development server... have fun, SteveC steve@xxxxxxxxxxxx http://www.asklater.com/steve/ Previous Message by Thread: click to view message previewRe: doubled trackpointsfixed needed a 'distinct' clause in the sql... * @ 01/12/05 07:13:10 PM immanuel.scholz@xxxxxx wrote: > I got this as trackpoints: > > <gpx version='1.0' xmlns='http://www.topografix.com/GPX/1/0/gpx.xsd'> > <trk> > <trkseg> > <trkpt lon='11.502753333' lat='48.131303333'/> > <trkpt lon='11.502725' lat='48.131726667'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > ... (about 40 times) > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.502736667' lat='48.131738333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > <trkpt lon='11.50249' lat='48.131528333'/> > ... (again, about 100 times) > > > and so on.. Maybe the script that imports the trackpoints should skip > already uploaded ones? If doubled trackpoints are the intention, then at > least the select statement in trackpoints.rb should include a > "distinct". > > Or is there a reason to transfer the same point over and over again? > (Maybe the applet draw this extra bold, burned into the monitor ;-) > > Ciao, Imi. > > > > _______________________________________________ > Openstreetmap-dev mailing list > Openstreetmap-dev@xxxxxxxxxxxx > http://bat.vr.ucl.ac.uk/cgi-bin/mailman/listinfo/openstreetmap-dev have fun, SteveC steve@xxxxxxxxxxxx http://www.asklater.com/steve/ Next Message by Thread: click to view message previewRe: doubled trackpoints* @ 03/12/05 10:40:47 AM immanuel.scholz@xxxxxx wrote: > Am Samstag, den 03.12.2005, 03:33 +0000 schrieb SteveC: > > fixed > > > > needed a 'distinct' clause in the sql... > > Make it a 'distinctrow' and it should perform 20% - 50% faster. ;) fixed > BTW: I closed bug 28 (old bugzilla) with Revision 661, but my changes > got reverted by Revision 672. > > Bug 28 was something about that the correct namespace declaration of GPX > is "http://www.topografix.com/GPX/1/0" while the server wrongly returns > "http://www.topografix.com/GPX/1/0/gpx.xsd". fixed > Why was the change reverted? > > Maybe someone edited the live ruby files on the server and copied them > back without doing a merge, and that overwrote my changes? that someone would be me > If the live ruby files on the server are edited for any reason (which is > IMHO not a good idea), then please, edit them as subversion repository > and do proper merging. That'd take ages, hence the development server... have fun, SteveC steve@xxxxxxxxxxxx http://www.asklater.com/steve/ Loading Comments...
|
|
