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?

  • 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. – alphabetasoup Jan 19 '16 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. – Hasan Mustafa Jan 19 '16 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? – barrycarter Jan 19 '16 at 16:17
  • 1
    I shifted over to PostgresSQL and it was fairly simple there, just had to use ST_MakeLine(geom) . – Hasan Mustafa Jan 20 '16 at 4:35
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, privacy policy and cookie policy

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