Solved

what is the correct way to get the latitude or longitude from a mysql column which has a spatial index

Posted on 2012-03-29
1
294 Views
Last Modified: 2012-03-29
The column i have is latlong, which stores lat and longitude as point spatial data type.

I am currently getting the latitude and longitude value like this...

latitude - x(GeomFromText(astext( latlong )))
longitude - y(GeomFromText(astext( latlong )))

I was just wondering if this is the correct and fastest way to select the latitude or longitude value?
0
Comment
Question by:Rakz0r
1 Comment
 

Accepted Solution

by:
Rakz0r earned 0 total points
ID: 37783659
simply x(latlong) is good enough and fastest way (as far as i know)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question