PHP and MySQL: Calculating Distance

This month I’ve been programming quite a bit in PHP and MySQL with respect to GIS. Snooping around the net, I actually had a hard time finding some of the Geographic calculations to find the distance between two locations so I wanted to share them here. If you remember ‘the old days’ of calculating a distance between two points, it was simply the hypotenuse of a triangle (A² + B² = C²). That’s an interesting start but it doesn’t apply … Continue reading

Post Links from Del.icio.us to your Blog Automatically

Back in December, I wrote about subscribing to my post via RSS or Email and the additional benefit of getting my daily links. Utilizing the Del.icio.us plugin for Firefox, I save and comment on links during the day and then Feedburner would tie those links into my RSS feed. Al Pasternak was kind enough to comment with some advice on how to utilize a little known feature of Del.icio.us to post my links into my blog every day. You may … Continue reading