Wednesday, September 15, 2010

Google Maps V3

I have spent the last few days gathering and modifying javascript code to work within Google Maps. The current version is V3 which is an improvement on V2 but is lacking in some needed areas.

Monday, September 13, 2010

storing the polygons (areas) in the db

In a previous post, I referred to a mysql procedure that allowed a "contains" result to be obtained, that is, 'does a point lie within a polygon?'

Storing the polygons as spatial data is the only way to make this function work, AFAIK, but this data format presents another problem for me.

Saturday, September 11, 2010

mysql function, well, procedure

Well this is fantastic. I have been looking for a routine that determines whether a point is in a polygon and i stumbled upon this at: http://forums.mysql.com/read.php?23,201913,201913

In the beginning...

I have just been commissioned to create a large interface revolving around mysql and google maps so I thought it would be a good idea to blog my progress (or lack of it :P ) to share what I learn and to get your feedback.

I am quite an advanced mysql programmer and I have had a lot of experience with Google Maps but I think the challenge here is bringing both systems together in one interface that is both adequate and intuitive.

Please comment on anything that is of interest to you so that I can tell that I'm getting visitors :)