[OSM-dev] PostGIS query "Crossing ways"

Mike N niceman at att.net
Mon Sep 12 16:56:31 UTC 2016


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 the two share
> nodes. If you want that you need either the osm2pgsql slim tables,
> pgsnapshot, or some other schema with node information or topology.

I did use the --slim option when importing, and see the node table, but 
I don't see topology in a direct table view.

   If I use something like the extension  postgis_topology , would I 
still need to write a tool to populate from OSM data?




More information about the dev mailing list