Tag Info

New answers tagged

0

Your idea of comparing start, end and mid points of separate linestrings is a good one, and could be written as: CREATE TABLE C AS WITH diffs (aid, bid) AS (SELECT a.id, b.id FROM roads_a a, roads_b b WHERE ST_Distance(ST_StartPoint(a.geom), ST_StartPoint(b.geom)) > 20 AND ST_Distance(ST_EndPoint(a.geom), ST_EndPoint(b.geom)) > 20 ...


0

You can not magically create islands out of the points you have. Any algorithm will struggle, as even if you can work out a way to automatically separate the points into distinct islands, you wont know what order to join the points in. Unfortunately, I suggest that you manually create the islands. You can do this in QGIS with snapping to your points, so ...


0

You can identify lines with gaps between endpoints using arcpy Geometry objects (v10.1+). The following returns the distance between endpoints: with arcpy.da.SearchCursor("LINES_FC", "SHAPE@") as cursor: for row in cursor: print arcpy.PointGeometry(row[0].firstPoint).distanceTo(arcpy.PointGeometry(row[0].lastPoint)) Of course, additional code ...



Top 50 recent answers are included