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
297 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

728 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