Re: [OSM-dev] osm2pgsql: support for local route names
RainerU-2 wrote
Hello Kai,
Am 14.04.2013 21:47, schrieb Kai Krueger:
Perhaps I don't quite understand what you need, but does osm2pgsql not
already do this?
osm2psql creates a way entry in the planet_osm_line table for each member
of a
route relation. The name tag of the relation is copied as route_name from
planet_osm_rels to each of these ways, along with some other tags specific
for
hiking and cycling routes. This allows to render routes with simple query
statements.
If I am not mistaken, it tries to create one entry per relation. However, as
in its default mode, osm2pgsql does not create multi-geometries, there will
be one entry per contiguous geometry in the planet_osm_lines table. It is
not per member way. If you have hstore enabled, these entries obtain all of
the tags, including e.g. name:fr from the relation they represent. For route
relations, they do not contain any information other than the geometry from
the member ways.
In addition the individual member ways are also in the planet_osm_line
table, but those do not contain any tags from the relation.
One problem you might be facing is that osm2pgsql does not handle relations
of relations, or relations of relations of relations... It seem many of e.g.
the Swiss cycle network is constructed of relations of relations and the
international names seem to be on the outer most relations. Therefore the
correct taging is only applied to the geometry sections of ways that are
directly a member of the parent relation.
RainerU-2 wrote
With the hstore option (which I was not aware of before Shaun mentioned
it) all
the tags of the relation are stored in planet_osm_rels but not in the
derived
ways in planet_osm_line.
No, the hstore option does not have an effect on the planet_osm_rels table.
The planet_osm_rels tables has all of the tags of the relations, wether you
select hstore or not. However, those do not contain any postgis geometries
and are therefore not easily used directly in rendering. The hstore option
influences the rendering tables, i.e. planet_osm_{point|line|roads|polygons}
and can be used directly in rendering with the apropriate options in mapnik.
RainerU-2 wrote
To access these tags one had to build a query that goes
through the member column values of the relations and gets the associated
ways.
This is a bit too complex for non-database geeks like me.
One solution would be to add the osm_id of the relation to the derived
ways.
This would provide a not too complex way to query these ways along with
data
from the associated relation. This is easy to implement, in the same way I
did
for the name:xx tags.
All of the entries in the rendering tables are linked back to a osm feature
with the osm_id. If they were derived from a relation, then the osm_id is
negative.
Kai
--
View this message in context:
http://gis.19327.n5.nabble.com/osm2pgsql-support-for-local-route-names-tp5756704p5757124.html
Sent from the Developer Discussion mailing list archive at Nabble.com.
___
dev mailing list
dev@openstreetmap.org
http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Show Me The Way - Yet Another Live Edit Viewer
Is it real time like http://live.openstreetmap.fr/, or does it cheat (like googles pulse)? Simon Am 15.04.2013 05:23, schrieb Ian Dees: Inspired by Google Map Maker's Pulse, I put together a quick app that uses Overpass augmented diffs to show up to 30 way creations/modifications every minute. Check it out here: http://osmlab.github.io/show-me-the-way/ Feel free to make pull requests or file issues against the code here: https://github.com/osmlab/show-me-the-way -Ian ___ 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] osm2pgsql: support for local route names
Kai Krueger kakrue...@gmail.com wrote: So name:de and name:fr are already available in the standard osm2pgsql db. Also all other tags of the route relation are in the db. Why osm2pgsql translates the name tag into route_name, I don't know. Also I wonder why there is so much special casing of various ncn, rcn, lcn cycle relations? All this stuff predates hstore support. Sven -- Dynamische IP-Nummern sind Security-Homöopathie. (Kristian Köhntopp) /me is giggls@ircnet, http://sven.gegg.us/ on the Web ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] osm2pgsql: support for local route names
Am 15.04.2013 09:04, schrieb Kai Krueger: If I am not mistaken, it tries to create one entry per relation. However, as in its default mode, osm2pgsql does not create multi-geometries, there will be one entry per contiguous geometry in the planet_osm_lines table. It is not per member way. If you have hstore enabled, these entries obtain all of the tags, including e.g. name:fr from the relation they represent. For route relations, they do not contain any information other than the geometry from the member ways. That is how it works. As I said, I just discovered hstore support. Consider the proposal from the OP as obsolete. Rainer ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] tirex: Can't locate mapscript.pm
Hello, where can I find the mapscript.pm? Greetings, Marcus ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Show Me The Way - Yet Another Live Edit Viewer
It's as live as the Overpass minutely diffs. On Mon, Apr 15, 2013 at 3:02 AM, Simon Poole si...@poole.ch wrote: Is it real time like http://live.openstreetmap.fr/, or does it cheat (like googles pulse)? Simon Am 15.04.2013 05:23, schrieb Ian Dees: Inspired by Google Map Maker's Pulse, I put together a quick app that uses Overpass augmented diffs to show up to 30 way creations/modifications every minute. Check it out here: http://osmlab.github.io/show-me-the-way/ Feel free to make pull requests or file issues against the code here: https://github.com/osmlab/show-me-the-way -Ian ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] A location sharing application written in python for raspberry pi port
Hello everyone Hope you all are doing well. I am Ashutosh Chaudhary and I am freelance web developer and python programmer. I want to participate into Gsoc 2013 threw OSM. I am new to this software, so I am taking a deep look into it. But Since my idea might be good to develop on OSM, So I am asking If any mentor wants to have a look and guide me. The idea is to develop an app which will run on cross-operating system(windows and linux). I am also keen in developing and android app for it. But the idea is limited to desktop app for now. I am good in python and web-frameworks, so I am making app using these languages- 1. Python 2. PHP 3. Js The app will run on user laptop/device(raspberry pi for instance) in his vehicle which will be listening to a port to get regular GPS data and will make a JSON object containing various key information about the running system like- 1. User identity information(his login credentials for this on servers) 2. Vehicle current cordinates(Latitudes and Longitudes) 3. Vehicle stats(License number etc.) 4. Other basic info(if required) This JSON data will be sent to cloud via TCP protocol/HTTP GET/POST method(currently developing under POST method). A parallel operation running behind will fetch the previous data of this user and his mates to make a realtime map over second webpage rendering all the information available for this route. This will be localised via python webkit. The idea is to develop a socially interactive tool for simultaneous interactivity of many users who know mutually each other, and plot a visual data out of it. This will be a next gen location mapping tool if some implementations could be done Thanking you -- Ashutosh Chaudhary Mob.- +91-843-750-6886 Website- www.ashurocks.in http://about.me/ashutoshchaudhary ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Show Me The Way - Yet Another Live Edit Viewer
This is awesome. On Mon, Apr 15, 2013 at 7:52 AM, Ian Dees ian.d...@gmail.com wrote: It's as live as the Overpass minutely diffs. On Mon, Apr 15, 2013 at 3:02 AM, Simon Poole si...@poole.ch wrote: Is it real time like http://live.openstreetmap.fr/, or does it cheat (like googles pulse)? Simon Am 15.04.2013 05:23, schrieb Ian Dees: Inspired by Google Map Maker's Pulse, I put together a quick app that uses Overpass augmented diffs to show up to 30 way creations/modifications every minute. Check it out here: http://osmlab.github.io/show-me-the-way/ Feel free to make pull requests or file issues against the code here: https://github.com/osmlab/show-me-the-way -Ian ___ 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] Show Me The Way - Yet Another Live Edit Viewer
On 15 April 2013 04:23, Ian Dees ian.d...@gmail.com wrote: Inspired by Google Map Maker's Pulse, I put together a quick app that uses Overpass augmented diffs to show up to 30 way creations/modifications every minute. Check it out here: http://osmlab.github.io/show-me-the-way/ Watching this is way too addictive :] Kevin ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] tirex: Can't locate mapscript.pm
Marcus Kruse kr...@vivai.de wrote: where can I find the mapscript.pm? Hm, are you trying to manually build tirex? You should really build a package instead using dpkg-buildpackage (at least on Debian and Ubuntu). The required perl dependencies can be found in debian/control back to your question. mapscript.pm is the mapserver perl Interface thus this is only necessary for the mapserver backend. On Debian/Ubuntu the package which contains mapscript.pm is called libmapscript-perl Regards Sven -- If you can spend five minutes on the Internet and do not run Linux, you're a genius. (Dirk Hohndel) /me is giggls@ircnet, http://sven.gegg.us/ on the Web ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Coastline, lakes, rivers
I would like to suggest a bit more focus on the OSM source data related documentation and data quality. The many loose/fuzzy definitions (if they are definitions at all) allow wide freedom of interpretations. In turn, these interpretations are causing many (but really many) logical errors. As a rule these errors are constantly present in most of the OSM data based mapping systems. Of course in the reference Slippymap too. Let me illustrate the former notes with just a few examples. -The natural=water tag related Wiki description opens for many various interpretations (definitions by examples, as we know, present serious methodological errors). Even an area fragment of a larger water area might have this assigned. This is extensively used by editors to refine coastline sections, as well as lake and river banks. They create virtual natural=water objects, areas that slightly overlap for example a coastline section and have only a few long edges inside the larger water area. The logic is simple: to change a long coastline section is dangerous, so doing changes by smaller lakes is much less risky and the result is almost the same. But this is very wrong. As a result, the correction is just partly performed, many islands disappear (or if the borders are rendered, mystical/strange lines appear on top of the water) and a huge amount of data redundancy is added. To see this, anyone can perform the following experiment: render/display the lakes area object layer using for example light blue for fill and black for the border lines. Render/display over this the planet_land area object layer (the land bodies created from the coastline data) using for example a yellow color fill and no borders. Now, if you pan along the coastline in an approprite scale, you will see lots of strange black-blue spots. When these are rendered in the opposite order, these will slightly and on certain places overwrite the coastline. In a way I could say that the coastline data based land-borders are actually never complete. -The waterway=riverbank tag is used for presenting river section areas. Most of the rivers are still tagged and uploaded using this key/value pair. Though, in the New tagging section is a note that .riverbanks aren't treated as areas any more. Here, it is quite legal to interpret the tag as a poly-line/way that represents a water/land border section. And this is used by editors very often. The consequences are, again, lots of logical errors. For example, look at the extract from the Slippymap, permalink: http://www.openstreetmap.org/?lat=38.0542 http://www.openstreetmap.org/?lat=38.0542lon=-121.5038zoom=12layers=M lon=-121.5038zoom=12layers=M As you can see, only on this little extract there are many, many errors caused by the described misunderstanding (water as land, islands as water). There are many open polygonal line sections here, though connected properly to other area sections. And so on. Of course a robust data-preparation process could coop with these kind of logical errors (I estimate that around 90% of all logical errors is resolvable programmatically). But this requires lot of unnecessary work. To refine the documentation should be much more pragmatic and effective. Regards, Sandor. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[josm-dev] zip style using MapCSS
Hi! I'm working (with HOT) to create a new style for JOSM (which goal is to fit the Humanitarian Data Model [1] ). One of the needs is to provide more icons for POI regarding humanitarian situations. For this style, I'm using the MapCSS option, because I feel more confident with this syntax. Given that we will have many custom icons, and given that this style will mainly be used in humanitarian context with very poor Internet connection, the ideal should be to be able to provide a final ZIP, with the style and icons, that can be shared with USB key (as well as with an URL of course), and easy to install. The documentation [2] says that this can be done with a XML based style only. I've made a quick test of a zip with my style and icons, and in fact the style is read, but the icons are not found. Maybe I've done something bad, but given this quick failed attempt and given the actual documentation, I prefer to ask before going ahead. So: - is it possible to use a zip for a MapCSS style including icones? - if not, is it something that has a chance to be added in a future release of JOSM? Thanks for reading! Thanks for the good work on JOSM! Yohan [1] http://wiki.openstreetmap.org/wiki/Humanitarian_OSM_Tags [2] https://josm.openstreetmap.de/wiki/Styles#Iconhandling ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
Re: [josm-dev] zip style using MapCSS
On Mon, 15 Apr 2013, Yohan Boniface wrote: The documentation [2] says that this can be done with a XML based style only. Where does it say so? I've made a quick test of a zip with my style and icons, and in fact the style is read, but the icons are not found. Wrong path? Icon names and path are relative to the topmost zip directory. One example from Wiki including icons: http://josm.openstreetmap.de/josmfile?page=Styles/Landcoverzip 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] zip style using MapCSS
Thanks, PierZen has also pointed me to a working example! Yohan On 04/15/2013 10:09 AM, Dirk Stöcker wrote: On Mon, 15 Apr 2013, Yohan Boniface wrote: The documentation [2] says that this can be done with a XML based style only. Where does it say so? Since JOSM revision 2289 zip files are supported. The zip file must contain at least one file with extension *xml*. Icon names and path are relative to the topmost zip directory. If there are multiple XML files, a file with style in the name is preferred (to allow packaging styles and presets in one archive). I've made a quick test of a zip with my style and icons, and in fact the style is read, but the icons are not found. Wrong path? Icon names and path are relative to the topmost zip directory. One example from Wiki including icons: http://josm.openstreetmap.de/josmfile?page=Styles/Landcoverzip Ciao ___ josm-dev mailing list josm-dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/josm-dev
