On 9/12/2016 9:56 AM, Mike N wrote:
I did use the --slim option when importing, and see the node table,
but I don't see topology in a direct table view.
The ways table has node membership information. Joining the table on
w1.nodes && w2.nodes and differing way IDs will find ways that share
no
On 9/11/2016 3:52 PM, Paul Norman wrote:
PostGIS databases do not have topology so there is no notion of
connected linestrings. You can tell if two ways cross each other with
ST_Intersects, and you can tell if two share points by turning the
linestrings into points, but this doesn't tell you if t
2016-09-11 18:20 GMT+03:00 Mike N :
> 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
On Sun, Sep 11, 2016 at 3:54 PM Paul Norman 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 wi
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 wit
Mike,
See below a solution which runs standalone in a PostGIS db. This SQL
looks little bit scary - but I'm open for simplifications :-). It
would have been much easier to calculate in a topological structure
like OSM given nodes and list of nodes (=ways)).
The main query comes after the remark.
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
7 matches
Mail list logo
