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.
MySql Spatial Project
My blog of learning, trying and earning money from mysql spatial data
Wednesday, September 15, 2010
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.
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 :)
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 :)
Subscribe to:
Posts (Atom)