Fastest Way to Find Distance Between Two Lat/Long Points
I currently have just under a million locations in a mysql database all with longitude and latitude information.
Geo-Search (Distance) in PHP/MySQL (Performance)
I have a MySQL-table (MyISAM) containing about 200k entries of lat/long pairs that I select from, based on the pairs distance (great circle formula) from another lat/long pair. (e.g. all entries that are within a 10km radius around 50.281852, 2.504883)
GIS: PostGIS/PostgreSQL vs. MySql vs. SQL Server?
EDIT: I have been using Postgres with PostGIS for a few months now, and I am satisfied. I need to analyze a few million geocoded records, each of which will have latitude and longitude. These records include data of at least three different types, and I will be trying to see if each set influences … Read more
Finding Cities within ‘X’ Kilometers (or Miles)
This may or may not be clear, leave me a comment if I am off base, or you need more information. Perhaps there is a solution out there already for what I want in PHP.
Determine timezone from latitude/longitude without using web services like Geonames.org
is there any possibility to determine the timezone of point (lat/lon) without using webservices? Geonames.org is not stable enough for me to use 🙁 I need this to work in PHP.
Get lat/long given current point, distance and bearing
Given an existing point in lat/long, distance in (in KM) and bearing (in degrees converted to radians), I would like to calculate the new lat/long. This site crops up over and over again, but I just can’t get the formula to work for me.