[OSM-dev-fr] question debutant sql + postgis

2012-03-01 Thread didier2020
bonjour a tous, j'ai fait la requete suivante SELECT a.osm_id, a.name, count(*) FROM planet_osm_polygon AS a, planet_osm_polygon AS b WHERE a.admin_level='8' AND b.building = 'yes' AND ST_Contains(a.way, b.way)=True GROUP BY a.osm_id, a.name cela me

Re: [OSM-dev-fr] [OSM-talk-fr] Carte Gramin

2012-03-01 Thread yvecai
Le 01/03/2012 19:05, sly (sylvain letuffe) a écrit : On jeudi 1 mars 2012, Yves wrote: Merci! J'ai d'ailleurs relance la generation, elled sont dispo directement dans Osmand (progressivement). Je m'associe aux autres bravos pour te remercier également de cette génération qui donne à osmand un

Re: [Potlatch-dev] More UX testing

2012-03-01 Thread Richard Fairhurst
On 01/03/2012 17:41, Andy Allan wrote: I'm especially coming to the conclusion that defining the icons in map_features.xml is the wrong place to do it - the icons in the panel should always match the icons shown in the stylesheet. No idea how to fix that though :-) That's pretty easy in theory

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread Sven Geggus
Darafei Praliaskouski m...@komzpa.net wrote: I am not using route= relations in osm2pgsql. Is there a way to skip their processing, to get more speed than 4 relations/sec? You could just skip the code following if( strcmp(type, route) == 0 ) in output-pgsql.c, but I doubt that this will

Re: [OSM-dev] Using custom renderer with mod_tile

2012-03-01 Thread Sven Geggus
Skye Book skye.b...@gmail.com wrote: Thanks for the clear explanation.. That meshes well with what I understood from reading the wiki and cursory looks at source code http://wiki.openstreetmap.org/wiki/Tirex/Overview has a nice diagram about how the different modules communicate. It is

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread sly (sylvain letuffe)
Le jeudi 1 mars 2012 11:30:03, Sven Geggus a écrit : You could just skip the code following if( strcmp(type, route) == 0 ) in output-pgsql.c, but I doubt that this will increase your processing speed significantly because most of the hard processing work is for multipolygons relations anyway.

Re: [OSM-dev] Nested relations and generic implementation of geometry constructs - Was :osm2pgsql patch for nested relations

2012-03-01 Thread sly (sylvain letuffe)
I know that there are precedents, but I am highly averse to coding specific relation types into osm2pgsql. So do I, as you mentionned below, the problem is not osm2pgsql specific, but will need work in every tool to maintain support for ever changing relation's way of tagging, and every new

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread Sven Geggus
sly (sylvain letuffe) li...@letuffe.org wrote: Reading that thread, I remembered that I don't need type=route either, I've commented that part of osm2pgsql but the speed gain is hardly noticeable (if at all) Quite in contrast to multipolygon relations, there is almost no computation in

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread sly (sylvain letuffe)
their member ways are just added to the planet_osm_lines table, they are not even concatenated. Sven Are you sure ? I might be mistaken, but thought they were concatenated and then split again if in exces of 1°x1° (line ~1080 in output-pgsql.c ) I haven't fully checked what does the

[OSM-dev] release of full-history extracts

2012-03-01 Thread Peter Körner
Hi I generated a new charge of history extracts, based on the 120213 full history dump. They have been created from the latest full-experimental-dump [1] using my history splitter [2], based on Jochen Topfs really great osmium framework [3]. They contain multiple versions of an object. If

Re: [josm-dev] Soliciting feedback on conflation plugin

2012-03-01 Thread Josh Doe
On Thu, Mar 1, 2012 at 9:13 AM, Josh Doe j...@joshdoe.com wrote: On Thu, Mar 1, 2012 at 9:00 AM, Mike N nice...@att.net wrote: On 3/1/2012 6:59 AM, Josh Doe wrote: Last night I checked in a minimally-functional (and definitely experimental) conflation plugin, appropriately called conflation.

Re: [OSM-dev] osm2pgsql patch for nested relations

2012-03-01 Thread Lennard
On 1-3-2012 15:28, Sven Geggus wrote: Quite in contrast to multipolygon relations, there is almost no computation in route relations, their member ways are just added to the planet_osm_lines table, they are not even concatenated. They are concatenated, up to a maximum length. Still, that's

[OSM-dev] Toronto Hack Weekend - Countdown

2012-03-01 Thread Richard Weait
The Toronto Hack Weekend is coming up in two weeks. It's going to be pretty darn good. We've got a super venue, with tons of space and rock solid wifi; The Ryerson University Geography department is hosting us. Should you join us in Toronto? Absolutely. Sign up on the wiki now.

[OSM-dev] Re-importing the Planet

2012-03-01 Thread Lynn W. Deffenbaugh (Mr)
I've got an OSM tile server based on the Ubuntu instructions that I've been running and updating with Minutely Mapnik for over a month now. I just noticed that southern Australia has issues like incomplete roads, lack of large rivers, no green spaces, and no city labels. I have no idea how

[josm-dev] Soliciting feedback on conflation plugin

2012-03-01 Thread Josh Doe
Last night I checked in a minimally-functional (and definitely experimental) conflation plugin, appropriately called conflation. You can read more about it here: http://wiki.openstreetmap.org/wiki/JOSM/Plugins/Conflation There's certainly a lot of work to do, but it's actually functional enough

Re: [josm-dev] Soliciting feedback on conflation plugin

2012-03-01 Thread Josh Doe
On Thu, Mar 1, 2012 at 9:00 AM, Mike N nice...@att.net wrote: On 3/1/2012 6:59 AM, Josh Doe wrote: Last night I checked in a minimally-functional (and definitely experimental) conflation plugin, appropriately called conflation.  I re-downloaded the list of plugins in JOSM, but it doesn't

Re: [josm-dev] Soliciting feedback on conflation plugin

2012-03-01 Thread Dirk Stöcker
On Thu, 1 Mar 2012, Josh Doe wrote:  I re-downloaded the list of plugins in JOSM, but it doesn't show up there.   Is the Jar file available somewhere? Yes, I mentioned this in the wiki; I think the plugin list isn't being updated during the current stabilization phase. You can download the