Sign in or Join FriendFeed
FriendFeed is the easiest way to share online. Learn more »
Blake Matheny
MySQL GIS Extensions Quick Start - http://markmaunder.com/2009...
Most websites don’t need to do complicated things like store polygon data. They just need to store points on a map and then retrieve those points. They also need to be able to ask the database for all points within a rectangle. So I’m going to run you through schema creation, inserting data, getting your lat/lon data out of the database again, and querying the database for all points within a rectangle. We’re also going to deal with the nasty little issue of asking the database for points in a rectangle that crosses the 180 degree boundary (or the International Date Line). - Blake Matheny