I have a few thousand LINESTRING features in a MySQL database. I'm trying to figure out the cumulative length of all the lines -- in miles. Using the GLength function I can retrieve the length in (what I assume to be) degrees, but I'm not sure how to get this to miles.
I also have QGIS and ArcMap, which both return the same degree values for the lines.
From what I've read the data needs to be projected, but I'm unsure what to project it to.
I'd like to perform the calculation within MySQL, if possible.
No comments:
Post a Comment