Everything beta

I have been thinking to write about this subject a while back when project Spincloud was still under development. I was even thinking about making this the first post on my blog. The idea is simple: you have location-based data (POIs for instance) stored in some database (preferably a spatial DB) and now you want to perform a select statement that will indicate the area that should include the points we want. In case of Spincloud's … read on »

In Part 1 we imported world political borders into a database table. In this second part we'll use the table and generate a script that will be used to add the borders overlay to Google Maps. We'll use the cool Ruby and some fancy GIS words along the way. We left-off with a database table containing all borders. The goal today is to produce a Javascript file that will be used for overlaying polygons representing countries, over … read on »

One thing I needed when designing the Meteoalarm mashup for Spincloud were the political boundaries for all European countries. With them at hand, I would use the polygon overlay from the Coogle API and fill the country polygons with the respective weather warning colors. This first part is a tutorial on how to import world political borders into a MySQL database table. The second part in these series will use this table to create a script that … read on »