[OSM-dev] hammering the changesets API
hi all I want to display recent changesets as Vectorgraphics on the map. There are some problems and I need help. To get some real results I have to request 100 changesets. All the robot changesets I have to filter client side. The hole thing is slow as hell and I'm not sure if the db is happy with that. Is there a faster way to get the changesets of a map area? Here a preview of that: http://www.khtml.org/iphonemap/extended.html zoom in to the area you are interested in click to load changesets. click to the usernames. Bernhard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql hstore support
Very cool. Now we just need to find a way to use it. I thought about it earlier but I didn't see a way to make mapnik use it so left it. Have a nice day, On Sun, Mar 14, 2010 at 4:47 PM, Sven Geggus li...@fuchsschwanzdomain.de wrote: Hello, I just commited a patch for osm2pgsl for optional generation of a hstore column (hstore new). For those of you who don't know about hstore colums yet: Hstore is for sets of key/value pairs. As associative array datatype, just like a hash in perl or dictionary in python. This should come in handy especialy for rarely used tags. Using hstore one can use any tag in sql queries like this: gis= select count(*) FROM planet_osm_point where ((tags-'man_made') = 'tower'); count --- 447 (1 Zeile) Indexes can be added to hstores as well. Currently the patch has not been tested in conjunction with incemental database updates. Regards Sven -- Those who do not understand Unix are condemned to reinvent it, poorly (Henry Spencer) /me is gig...@ircnet, http://sven.gegg.us/ on the Web ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- Martijn van Oosterhout klep...@gmail.com http://svana.org/kleptog/ ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql hstore support
Sven Geggus wrote: Now we would just need something like this: select way,(tags-'man_made') as man_made FROM planet_osm_point where ((tags-'man_made') is not NULL); What am I getting wrong here? Nothing. This will work. Mapnik just expects the name used in a filter to correspond with a column name in the resultset, nothing fancy about that. The 'as man_made' takes care of this. Very cool this. What's the speed to access the hstore column, compared to the generic columns we now have? On the one hand, this has the potential to greatly increase the size of the db, as you will now get all kinds of tags you're never interested in. On the other hand, one can now quickly use keys one never used before, without the need to reimport the whole db. -- Lennard ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql hstore support
Lennard l...@xs4all.nl wrote: Very cool this. What's the speed to access the hstore column, compared to the generic columns we now have? I did not yet try to measure this. On the one hand, this has the potential to greatly increase the size of the db, as you will now get all kinds of tags you're never interested in. Shure, but unwanted tags can already get removed using the delete flag in the stylefile. While testing I already removed note and source tags while importing data. On the other hand, one can now quickly use keys one never used before, without the need to reimport the whole db. Thats the thing I was up to: Enabling the generation of special interest maps with tags somebody invented just recently. Sven -- Um Kontrolle Ihres Kontos wiederzugewinnen, klicken Sie bitte auf das Verbindungsgebrüll. (aus einer Ebay fishing Mail) /me is gig...@ircnet, http://sven.gegg.us/ on the Web ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OSM home page and IE
This seems to be fixed, thanks, tom! http://trac.openstreetmap.org/changeset/20472 Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] GSoC 2010. OpenStreetMap Mashup Generator Project
Sajjad, This sounds like an interesting idea - effectively an extension to embedding a simple OSM map on a web page to include data from another source. While I think this is possible with existing javascript libraries such as OpenLayers, I think the main aim of this project is to make that easy for a more casual user, who does not speak much JavaScript. It think this would be a useful contribution. It is also very nice to see suggestions coming from prospective students, thank you! Does anyone else have any thoughts on this? Thanks Graham. On 14 March 2010 17:22, Sajjad Anwar sajja...@gmail.com wrote: Hi, I have put forward an idea into the GSoC 2010 wiki page. The link is here http://wiki.openstreetmap.org/wiki/GSoC_Project_Ideas_2010#OpenStreetMap_Mashup_generator It is basically to create an easy to use mashup generator based on OpenLayers API, to enable people to use OpenStreetMap data in various ways including presenting on a web page and taking print outs. I would personally love to take this project forward, if everyone thinks this is worth developing and feasible. Waiting for comments and suggestions. Regards. -- Sajjad Anwar | http://geohackers.in | Blog: http://sajjad.in ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev -- Dr. Graham Jones Hartlepool, UK email: grahamjones...@gmail.com ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] GSoC 2010. OpenStreetMap Mashup Generator Project
Am 14.03.2010 21:08, schrieb Graham Jones: Sajjad, This sounds like an interesting idea - effectively an extension to embedding a simple OSM map on a web page to include data from another source. Please also take the possibility into account to draw your yown points, lines and shapes onto the map and export them (link to them) into various formats. I could think of some public platform like github, where one can draw points on to the map and another one lines and a third person can then aggregate the feeds of those two maps into their own map, linking to the original sources and receiving updates from them. Peter ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [josm-dev] Function to select or download a sequence of ways?
Hi Karl, To the best of my knowlege there is no such function yet ... Now there is: http://wiki.openstreetmap.org/wiki/JOSM/Plugins/WaySelectorPlugin Thanks to your reply and the availability of WayDownloaderPlugin source code, I got an easy start. I posted some ideas for further development to the above wiki page, but the plugin already scratches my itch (selecting the mainland coastline in a large natural=coastline map extract). (3) you can listen to the current selection. See org.openstreetmap.josm.data.osm.event.SelectionEventManager I might look at this later, to update the enabled/disabled state of the plugin based on the current selection. Best regards, Marko ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] Function to select or download a sequence of ways?
2010/3/9 Marko Mäkelä marko.mak...@iki.fi: Before I start reinventing the wheel in JOSM, I would like to know if there is a function or plugin that allows to select a non-branching sequence of ways. It would be nice if the selection function could optionally be restricted to the current selection, just like the search dialog, and if some predicates could be assigned to the ways, say, highway=tertiary or natural=coastline, so that any branches where the predicate does not hold would be ignored. another selection-feature I'm missing quite often (maybe it is already there and I don't know how to use it) is the use of the selection-rectangle to select ways but not nodes. Currently if you select by rectangle you will only select nodes, and ways completely surrounded. The selection I am talking about would select all ways intersected or completely within the selection rectangle, but not the contained nodes. cheers, Martin ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] Function to select or download a sequence of ways?
Hello Martin, Martin Koppenhoefer wrote: another selection-feature I'm missing quite often (maybe it is already there and I don't know how to use it) is the use of the selection-rectangle to select ways but not nodes. Currently if you select by rectangle you will only select nodes, and ways completely surrounded. The selection I am talking about would select all ways intersected or completely within the selection rectangle, but not the contained nodes. I also don't know whether thnere is a more direct way or not. In case I need to select a bunch of ways I do like this: 1) Use rectangle to select area containing all desired ways (including all nodes. Hold alt-key to select ways that have nodes inside selection) 2) use search feature to search for type:node and remove from selection 3) in case selection contains relations, repeat step 2 with relations Now you have a selection containing only the ways Stephan ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev