[Geocoding] geocoding of intersection with two road names given

Paul Norman penorman at mac.com
Wed Apr 1 18:39:52 UTC 2015


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.



More information about the Geocoding mailing list