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

  • Message #1248

    Sorry, maybe I missed it, but I can't find your question?

    • 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 --