News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

PHPImpact Blog:
Geo Proximity Search with PHP, Python and SQL
February 09, 2009 @ 10:28:29

On the PHP::Impact blog, Federico takes a look at finding geo-proximity to a find a location on a map and plot it and find the distance to another point - all with the help of PHP, Python and SQL.

Basically, what I'm doing is plotting a radius around a point on a map, which is defined by the distance between two points on the map given their latitudes and longitudes. To achieve this I'm using the Haversine formula (spherical trigonometry). This equation is important in navigation, it gives great-circle distances between two points on a sphere from their longitudes and latitudes.

Included in the post is the code for three different implementations - PHP, Python and SQL, all using that same formula.

0 comments voice your opinion now!
geoproximity search python sql haversine radius latitude longitude


blog comments powered by Disqus

Similar Posts

Brian Swan's Blog: Do Stored Procedures Protect Against SQL Injection?

Sameer Borate's Blog: Grabbing the referrer search engine keywords for a site

PHPit.net: Taking a first look at the AutoCRUD for PHP library

Zend Developer Zone: The ZendCon Sessions Episode 17: SQL Query Tuning: The Legend of Drunken Query

Paul Jones' Blog: Solar 1.0.0 alpha1 Released


Community Events

Don't see your event here?
Let us know!


framework voicesoftheelephpant extension release community wordpress unittest library api podcast laravel5 series version laravel php7 list introduction opinion language interview

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework