Archive for the 'SQL' Category



Shapefile Tiles with PHP and GD

Last week, I demonstrated some tools for importing Shapefile data into an SQL database. It’s time to put that stuff to work.
If you’re in a rush, here’s the final demo: translucent state overlays on a Google Map. It’s not the quickest thing in the world, nor is it entirely quirk-free; it exists as an initial […]

Importing Shapefiles

There’s a lot of interesting data out there that isn’t points, but regions. In Chapter 10 of the book, we showed you how to calculate an area inside a polygon (see this demo). Unfortunately there just wasn’t the space to cover more region-centric topics. Time to get started on a remedy for that.