Re: [OSM-dev-fr] Osmose
Le 18 février 2011 16:57, Marc SIBERT m...@sibert.fr a écrit : Juste un truc pour diviser par 2 la complexité de ta requête : and osm1.osm_id* ** *osm2.osm_id Il suffit de faire la comparaison une seule fois puisque c'est la même table que tu parcours (deux fois) et si osm_id est ta clé primaire... Pour plus de clarté, préfère les JOINs pour lier les tables, ça permet de séparer les conditions de jointure des conditions de sélection (mais le résultat doit être strictement identique après l'optimiseur de requête). Bien vu, merci. Pour les JOIN tu les appliques sur les conditions donc ? Autre question en passant: ma machine n'est pas un foudre de guerre, je n'utilise pas les hourly diff, la base n'est donc utilisée qu'en consultation. Y-a-t-il des optimisations recommandées au niveau de postgis ou osm2pgsql ? BrunoC ___ dev-fr mailing list dev-fr@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev-fr
Re: [OSM-dev-fr] Osmose
Marc SIBERT wrote: Pour plus de clarté, préfère les JOINs pour lier les tables, ça permet de séparer les conditions de jointure des conditions de sélection (mais le résultat doit être strictement identique après l'optimiseur de requête). Le résultat n'est pas strictement identique après l'optimiseur de requête car, justement, la syntaxe JOIN impose un ordre de jointure : http://www.postgresql.org/docs/8.4/interactive/explicit-joins.html Cet ordre de jointure peut avoir un impact positif ou négatif sur le temps d'exécution. Ce n'est pas forcément mauvais mais l'important est d'utiliser JOIN en connaissance de cause. Pour ce qui est de la lisibilité, c'est vraiment une affaire de sensibilité. J'ai vu des gens qui ne comprennent plus les requêtes quand elles sont écrites avec JOIN, d'autres qui ne peuvent pas s'en passer... Cordialement -- Gilles Bassière - Web/GIS software engineer http://gbassiere.free.fr/ ___ dev-fr mailing list dev-fr@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev-fr
[OSM-dev] Nominatim Query issues
Hi I wondered about odd results in my map and found them being caused by wired Nominatim results. I have Places with Street, PLZ and City and I try to find a Coordinate for it. A sample would be Kirchgasse, 65185 Wiesbaden When querying Nominatim with it, I'll get the correct result back but not as the first item but as the third one. The first item is a street in another city around 50km away: http://open.mapquestapi.com/nominatim/v1/search.php?q=Kirchgasse,+65185 +Wiesbaden How can this result be explained and how can I more accurate results? Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] OSM XML fileformat flavours
Hi, I like to put some informations about our XML files at http://wiki.openstreetmap.org/wiki/XML (removing the redirect) concerning ordering of data blocks etc. Currently there is this list of XML subtypes: http://wiki.openstreetmap.org/wiki/Change_File_Formats Are there any further formats basing upon original OSM API XML? Can anybody please contribute informations about the history planet? http://wiki.openstreetmap.org/wiki/Planet.osm/full cu Matthias ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
Hi developers, Osmosis is command line based application. However, I want to integrate the data processing into my codes. Therefore, is there any other java programmable library for osm file processing except Osmosis? Or can I use some of Osmosis jars to integrate into my codes? BTW, I cannot find the class document of Osmosis. Regards, Zhijie -- Zhijie Shen School of Computing National University of Singapore http://www.comp.nus.edu.sg/%7Ez-shen/ ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
You might have a look at http://wiki.openstreetmap.org/wiki/Develop/Frameworks What kind of data prrocessing are you looking for? For an opensource tool? cya Matthias ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
You can also check GeotoolKit.org which is not in the list. I made some work for OSM support in it but didn't have time to finish it properly yet., It's LGPL license. The good part is geotoolkit is a general use gis toolkit, so there is a rendering engine, filters, styling, projection support, swing widgets ... and so on. The less good part is that integration with osm is not as developed as in osmosis. johann sorel Geomatys Le 21/02/2011 17:46, Matthias Meißer a écrit : You might have a look at http://wiki.openstreetmap.org/wiki/Develop/Frameworks What kind of data prrocessing are you looking for? For an opensource tool? cya Matthias ___ 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] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
Am 21.02.2011 17:41, schrieb Zhijie Shen: Hi developers, Osmosis is command line based application. However, I want to integrate the data processing into my codes. Therefore, is there any other java programmable library for osm file processing except Osmosis? Or can I use some of Osmosis jars to integrate into my codes? BTW, I cannot find the class document of Osmosis. It's common to take parts of the osmosis source or bundle the osmosis jar and just use it's functionality. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] A problem with the XAPI redirector?
On Mon, Feb 21, 2011 at 3:30 PM, Manuel Reimer manuel.s...@nurfuerspam.dewrote: 80n wrote: There was a typo in the load balancer config file. Fixed now. Thanks for picking this up. Does this mean, that the informationfreeway.org-redirector may be used again, now? Is it stable? Information Freeway has always been the recommended way to use XAPI as it will redirect to the best available service. Sometimes there is only a choice of one, but the available servers can and do change over time so it's always better to go via Information Freeway. How many XAPI servers are left, a load balancer can select from? AFAIR only one server really worked at all and this server temporarily disappeared some weeks ago. Offers of hardware resource would really help with this. With enough smallish servers available it would make sense to deploy it as a distributed service. 80n ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [josm-dev] single session authenticatoin
Mikel Maron wrote: Hi In Kenya, we have people often sharing computers. With JOSM, this causes an issue, because people forget to change the saved authentication credential to their own. You can choose to not save credentials, but this then leads JOSM to ask for them on every single API call, which is basically unusable. JOSM remembers the credentials for one session, even if you choose not to save it permanently. Please report a bug (including used version) if this is not the case. Is there a solution to this? Ideally, login/password would only be stored for a single session. So you like to have an (advanced) option to not show the save user and password checkbox in the credentials dialog? Would be a great help to us in Kenya! There is another option: * Create links on the desktop, on for each user. * Change the link from java -jar .../josm-tested.jar to java -Djosm.home=.../josm-user1 -jar .../josm-tested.jar (Replace ... by the path to the preference folder for user1 and the path to josm-tested.jar respectively.) This will keep the preferences for each user in a separate folder. Sebastian ___ josm-dev mailing list josm-...@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [OSM-dev] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
On 21.02.2011 17:41, Zhijie Shen wrote: Osmosis is command line based application. However, I want to integrate the data processing into my codes. Therefore, is there any other java programmable library for osm file processing except Osmosis? Or can I use some of Osmosis jars to integrate into my codes? It's possible to use Osmosis jars as a library in other Java programs. I'm using the --read-xml task in this manner myself, and I assume that it should be possible to do something similar with the other tasks. It works well for me. And the fact that Osmosis itself has even been placed in to the public domain makes it even more attractive. Tobias Knerr ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Is There Any Other Java Toolkit for OSM File Processing except Osmosis?
By the way, if your work is in context of science, please add it at http://wiki.openstreetmap.org/wiki/Research regards Matthias ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [josm-dev] projection Mercator, set EPSG 3785 instead of EPSG 3857
2011/2/21 Josh Doe j...@joshdoe.com: I've been meaning to submit a bug, but the Mercator projection in JOSM is NOT EPSG:3857 as it claims, I'm not sure what EPSG or ESRI code it corresponds to. I guess it is the google projection, as this would IMHO be the intended one. The definitions of EPSG:3785 and EPSG:3875 are different, but they should be equivalent. 3785 is using the parameters OSM-mapnik is using (Sphere as Ellipsoid, no inverse flattening) while 3857 is using an Ellipsoid with inverse flattening of 298.257223563. Cheers, Martin ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] projection Mercator, set EPSG 3785 instead of EPSG 3857
On Sun, 20 Feb 2011, Josh Doe wrote: What timing. I just created a wiki page on this very subject. [1] I've been meaning to submit a bug, but the Mercator projection in JOSM is NOT EPSG:3857 as it claims, I'm not sure what EPSG or ESRI code it corresponds to. Well, we can fix JOSM's internal Mercartor without side effects, as currently it is never exposed outside (for WMS it is silently [and slightly false] converted to EPSG:4326). It should be as simply as multiplying with 6378137.0. I did so in Revision 3922. Ciao -- http://www.dstoecker.eu/ (PGP key available) ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] projection Mercator, set EPSG 3785 instead of EPSG 3857
Dirk Stöcker wrote: On Sun, 20 Feb 2011, Josh Doe wrote: What timing. I just created a wiki page on this very subject. [1] I've been meaning to submit a bug, but the Mercator projection in JOSM is NOT EPSG:3857 as it claims, I'm not sure what EPSG or ESRI code it corresponds to. Well, we can fix JOSM's internal Mercartor without side effects, as currently it is never exposed outside (for WMS it is silently [and slightly false] converted to EPSG:4326). It should be as simply as multiplying with 6378137.0. I did so in Revision 3922. It breaks imagery offsets. (But on the plus side fixes #5789 :) ) Sebastian ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] projection Mercator, set EPSG 3785 instead of EPSG 3857
On Mon, 21 Feb 2011, Sebastian Klein wrote: What timing. I just created a wiki page on this very subject. [1] I've been meaning to submit a bug, but the Mercator projection in JOSM is NOT EPSG:3857 as it claims, I'm not sure what EPSG or ESRI code it corresponds to. Well, we can fix JOSM's internal Mercartor without side effects, as currently it is never exposed outside (for WMS it is silently [and slightly false] converted to EPSG:4326). It should be as simply as multiplying with 6378137.0. I did so in Revision 3922. It breaks imagery offsets. (But on the plus side fixes #5789 :) ) The storage of these is a relatively new and hard to use feature, so I assume we can live with that. Ciao -- http://www.dstoecker.eu/ (PGP key available) ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
[josm-dev] single session authenticatoin
Hi In Kenya, we have people often sharing computers. With JOSM, this causes an issue, because people forget to change the saved authentication credential to their own. You can choose to not save credentials, but this then leads JOSM to ask for them on every single API call, which is basically unusable. Is there a solution to this? Ideally, login/password would only be stored for a single session. Would be a great help to us in Kenya! Mikel == Mikel Maron == +254(0)724899738 @mikel s:mikelmaron http://mapkibera.org/ http://wiki.openstreetmap.org/index.php/Haiti ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] Remove 'Export to GPX...' from File menu
On Mon, 21 Feb 2011, Sebastian Klein wrote: I'd like to remove the menu entry 'File Export to GPX...'. It is always disabled, unless a gpx layer is the *active* layer. Hmm, shouldn't it be enabled for OSM and GPX? This is a little strange, since 'export' implies some change of format. Instead, the commands in the right click menu of the corresponding layer should be used. There, you can really export an osm data layer to gpx and also run 'save' and 'save as...' for a gpx layer. I think the idea was to offer another place, as many people overlook the right-click-menu. But I don't remember really... Ciao -- http://www.dstoecker.eu/ (PGP key available) ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
