On 3/23/2015 12:30 AM, Florian Lohoff wrote:
I had the same problem - accident stats from local police. I uses
postgis loaded with the osmosis simple schema.
Then you select all ways with name A and make a collection and
all ways with name B and then create the nodes with their junction
e.g. ST_Intersect. You then end up with one or a few intersection nodes.
I interpolated them to a single node if they were less than 60m apart.
Otherwise you might have a U shaped street having 2 junctions with the
same street.
Two ways to do this are
- import with osm2pgsql and a custom .style file and use and postgis
intersection queries
- import with pgsnapshot and no linestrings and find nodes in common
The two differ in the case of a bridge where the roads cross but are not
connected
Doing something with Nominatim has the advantage that it already has
logic for handling inexact matches.
_______________________________________________
Geocoding mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/geocoding
