[OSM-dev] PostGIS query "Crossing ways"

[Ian Dees]

On Sun, Sep 11, 2016 at 3:54 PM Paul Norman <penorman at mac.com> wrote:

> On 9/11/2016 8:20 AM, Mike N wrote:
> > Given a PostGIS database populated from OSM data by osm2pgsql, and 2
> > sets of lines  (such as the selection of all footways and the
> > selection of all roads)   what function or series of functions will
> > result in a list of locations where footways cross roads without any
> > OSM connecting node?  (the equivalent of JOSM's "Crossing Ways" warning)
>

This isn't really an answer to your exact question, but I recently used
Mapbox's OSM QA Tiles + Tile Reduce to find all intersections between
residential/tertiary/primary/trunk/etc. roads. The code is here and can
probably be adapted to what you're looking for pretty easily:

https://github.com/iandees/on-every-corner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20160911/48556786/attachment.html>