5

I am extracting the lat/long information from Geo-tagged images and storing them in MySQL. I want to get a line-string from the points, I looked into the GROUP_CONCAT() function but I am not able to get it to work with the linestring. Is there a way to store the concatenated geometries of the individual points as a linestring?

Improve this question
4
  • 1
    What do you mean by "not able to get it to work properly"? Please edit your question with more information, such as an error message. Commented Jan 19, 2016 at 5:55
  • I want to store the concatenated geometries as a linestring, I got the GROUP_CONCAT() to work but that doesn't really help me. Commented Jan 19, 2016 at 6:09
  • 2
    Have you considered using PostgreSQL which has better support for geometry types? If MySQL is a requirement, could you post sample rows and code? Commented Jan 19, 2016 at 16:17
  • 1
    I shifted over to PostgresSQL and it was fairly simple there, just had to use ST_MakeLine(geom) . Commented Jan 20, 2016 at 4:35

1 Answer 1

Reset to default
3

I shifted over to PostgresSQL and it was fairly simple there, just had to use ST_MakeLine(geom)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.