[Geocoding] geocoding of intersection with two road names given

[Florian Lohoff]

On Wed, Mar 18, 2015 at 06:58:06PM -0400, Stefan Steiniger wrote:
> Dear GeoCoders,
> 
> I am having a database of traffic accidents. All accidents that
> happened at an intersections are described by giving the two street
> names. Is there an option to send such a request to Nominatim?
> I tried it with "Street A, and, Street B, City", without success.
> 
> Or: Would I have to fetch the geometry of either road and do then
> some processing with my client a la JTS: geom.intersect(geom2)?
> Assuming a small area -> planar 2D should be fine.
> If I need to do it this way: Does "polygon_geojson=1" give me the
> complete LineString as in the DB?
> 
> thanks and cheers from Santiago de Chile,
> Stefan
> 
> PS: Btw. I am using iPython Notebook, so I guess shapely helps me
> here to do the JTS stuff, in case someone knows?
> PPS: no worries, I got my own instance of Nominatim sucessfully
> installed: thank you for that guide and work!

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. 

Flo
-- 
Florian Lohoff                                                 f at zz.de
     We need to self-defense - GnuPG/PGP enable your email today!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 828 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/geocoding/attachments/20150323/2cd4f797/attachment.sig>