Re: [Talk-transit] OSM / OPNV-Karte to Excel/SVG
On Thu, Jan 21, 2010 at 20:11, Roland Olbricht roland.olbri...@gmx.dewrote: Do you want something like these? http://78.46.81.38/api/nodes-csv?380861all http://78.46.81.38/api/nodes-csv?380861forward http://78.46.81.38/api/nodes-csv?380861backward The first parameter is the id of the relation. I tried with importing the XML into Excel but it's not really usable (at least, I couldn't find a way to list the nodes of a certain relation), so Roland, thanks for your links, it's what I needed :) I wonder if it's possible to query for multiple routes at once and not just for one at a time... Well, it depends on your exact needs. A simple SVG can be created straightforward because it is just Markup. Feel free to ask for sample code. On the Italian OSM ML one guy wrote a little program in C# which does exactly that, putting all stops on a straight line, showing which stops have connection with other lines in different colours [and I'm sure it is also possible to show the numers of the lines passing by]... My knowledge of programming is absolutely limited, but maybe we could check that script together.. I'm interested in a more advanced tool to produce full blowd grid maps in this style but this will take a lot of work. If you can spend some days or hourls on programming, I'd like to do this in joint work. I'd love to, but as I told I know basically nothing...but I can support with testing and other stuff. I'm currently writing a JOSM plugin to make this easier. But it may take some more weeks until it gets completed. I'll post a intermediate version as soon as possible. Sounds cool! It would be also nice to see in OPNVKarte some option to select which bus routes to show on the map. I saw some stuff is in German, I could help with the translation in English, French, Italian. Tiziano ___ Talk-transit mailing list Talk-transit@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-transit
Re: [Talk-transit] OSM / OPNV-Karte to Excel/SVG
Am Mittwoch, 20. Januar 2010 00:16:18 schrieb Tiziano D'Angelo: Hello to everyone! As another bonus to the work done, I'd love to export the data of each route relation first to some excel/text/CSV file or database where I can see lat/long + name of the stop in the correct forward/backward order for each line (so I can send the updated data to the author of Metro ( http://nanika.net/Metro) Do you want something like these? http://78.46.81.38/api/nodes-csv?380861all http://78.46.81.38/api/nodes-csv?380861forward http://78.46.81.38/api/nodes-csv?380861backward The first parameter is the id of the relation. then, I'd like to export the data to SVG files to do graphs for each route of the network (both as topological maps http://en.wikipedia.org/wiki/File:Bakerloo_line_Topological_map.svg and as this graph: http://en.wikipedia.org/wiki/File:Bakerloo_Line.svg) and also of the entire network, just leaving on it the lines and names of the stops, and as a further development, create a map similar to the Paris/London metro network. Could anybody explain me how to do any of these things? Well, it depends on your exact needs. A simple SVG can be created straightforward because it is just Markup. Feel free to ask for sample code. I'm interested in a more advanced tool to produce full blowd grid maps in this style but this will take a lot of work. If you can spend some days or hourls on programming, I'd like to do this in joint work. I'm currently ordering the stops so they show up in OPNVKarte in the proper order. I'm currently writing a JOSM plugin to make this easier. But it may take some more weeks until it gets completed. I'll post a intermediate version as soon as possible. Cheers, Roland ___ Talk-transit mailing list Talk-transit@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-transit
Re: [Talk-transit] OSM / OPNV-Karte to Excel/SVG
Hi Tiziano, I am not aware of any tools which can do what you want out of the box. but here are some ideas which might be helpful for you: I use Xapi [1] a lot to retrieve only a specific portion of the OSM data for a large area (e.g. all relations with a route=bus tag). Once I have osm file with all the data I need, I find it quite convenient to use xslt to convert the xml data into other formats. I have some scripts that might be helpful to get the grip of xslt. If you are interested I can sent them to you. I use these scripts for example to convert nodes or ways from osm into sql insert statements, but you can easily create a csv files as well. Topological maps can be created with mapnik which supports outputting svg files. If you use version 0.6.0 or newer you can directly use an osm file as data source. I do not know of any tool to create a straight line graph of a way. I thought a while ago about writing a tool to draw such graphs but never got round to actually do it. My idea was to reproject the input data way segment by way segment so that it was on a straight line and then feed this into mapnik. You could, of course, also write an xslt script which converts the osm data directly to mapnik. Cheers, Christoph [1] http://wiki.openstreetmap.org/wiki/Xapi On 19/01/2010 23:16, Tiziano D'Angelo wrote: Hello to everyone! I am currently building the Padova bus tram network. Almost all the routes are there, and most of the stops in the city center. I'm doing then line by line surveys about the missing stops. The current result is visible here: http://www.öpnvkarte.de/?zoom=12lat=45.40287lon=11.8559layers=BThttp://www.xn--pnvkarte-m4a.de/?zoom=12lat=45.40287lon=11.8559layers=BTand http://www.openstreetmap.org/browse/relation/382350 as a network relation. I'm currently ordering the stops so they show up in OPNVKarte in the proper order. As another bonus to the work done, I'd love to export the data of each route relation first to some excel/text/CSV file or database where I can see lat/long + name of the stop in the correct forward/backward order for each line (so I can send the updated data to the author of Metro ( http://nanika.net/Metro), and then, I'd like to export the data to SVG files to do graphs for each route of the network (both as topological maps http://en.wikipedia.org/wiki/File:Bakerloo_line_Topological_map.svg and as this graph: http://en.wikipedia.org/wiki/File:Bakerloo_Line.svg) and also of the entire network, just leaving on it the lines and names of the stops, and as a further development, create a map similar to the Paris/London metro network. Could anybody explain me how to do any of these things? Thanks Tiziano ___ Talk-transit mailing list Talk-transit@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-transit ___ Talk-transit mailing list Talk-transit@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-transit
