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?
_______________________________________________ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev