shootingstar (#18) - Source and Target Coordinates (#316) - Message List
Source and Target Coordinates
I need to populate my database table (edges) with x1, x2, y1, y2 coordinates so I can make use of Shooting Stat. I have my geometry in place, I just need to find the coordinates(lat/lng) of my source and target vertices.
Thanks in advance Brian
Briolab
12/01/09 02:09:30 (12 months ago)
-
Message #1248
Sorry, maybe I missed it, but I can't find your question?
daniel12/11/09 23:32:19 (11 months ago)-
Message #1360
Hej Daniel :)
My question should have been: How do I find the coordinates of my source and target vertices? I figured it out though;
-- INSERT INTO edges (x1,y1) (SELECT ST_X(the_geom), ST_Y(the_geom) FROM vertices_tmp) where edges.source = vertices_tmp.id --
Briolab01/12/10 20:50:29 (10 months ago)
-