I'm converting my the_geom into lat/long coordinates but I only want a single coordinate since I'm gonna use the coordinates to draw a polyline in google maps. Attached is the picture of the result of my query.

enter image description here


Your result is the line strings needed to draw the actual route. This is probably what you want, but if needed you could break them down in to individual points by hand.

  • thanks for the answer, that cleared things up. but is there a way to convert them into a point(lat,long) rather than in a linestring? I'd appreciate any suggestions. – AbdulMalik Mustapha Oct 6 '18 at 20:17
  • 2
    Please read the manual page about postgis.net/docs/ST_DumpPoints.html. – user30184 Oct 8 '18 at 7:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.