New in version: 2.0.0
Reason for deprecation:
Example:
SELECT * INTO vertices
FROM pgr_extractVertices('SELECT id, geom FROM edges ORDER BY id');
Finally using the data stored on the vertices tables the source and target are filled up.
/* -- set the source information */
UPDATE edges AS e
SET source = v.id
-- , x1 = x, y1 = y <-- any additional changes if needed
FROM vertices AS v
WHERE ST_StartPoint(e.geom) = v.geom;
/* -- set the target information */
UPDATE edges AS e
SET target = v.id
-- , x2 = x, y2 = y <-- any additional changes if needed
FROM vertices AS v
WHERE ST_EndPoint(e.geom) = v.geom;
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4