Hello, I am looking to create a static tile layer from shapefiles on top of google maps. I found a useful tool called shp2mysql, which is the mysql port of shp2pgsql.
I'm able to import the shapefile data into mysql without a problem. In theory, what I would like to do is select this data based on certain criteria and then use PHP with the GD library to create image tiles from it. The shp2mysql utility inserts the polygon data from the shapefile as geomeetry-> multipolygon datatype, with the series of points. I was hoping I could just return the information from MySQL using something like 'SELECT zipcode, AsText(ogc_geom) FROM mytable' and then use the GD polygon stuff to draw images, but it seems the ogc_geom field (I haven't used MySQL's spatial extensions before) returns something like MULTIPOLYGON(((-79.052694018881311 39.722853080850818 ,-79.053004999999999 39.720934000000000 ))) - I'm thinking I can probably get that info to an array and then perhaps use GDs polygon stuff to draw image tiles Has anyone done anything like this using these tools? I've seen the maps.huge.info stuff using Perl and PostgreSQL, but I am not too familiar with those toolsets at this point. Basically I want to know if I'm going down the right path here - and perhaps get some help if anyone has done something along these lines. I know this isn't really an API question, but the data will be used with the google maps api, just having some issues --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en -~----------~----~----~----~------~----~------~--~---
