I think your best solution is to import your KML data into MySQL - combine it with the existing income/race date.
If you have PHP5 support then use simpleXML functions to parse the KML into a format that is suitable for your MySQL: http://www.php.net/manual/en/intro.simplexml.php Martin. On 8 June, 01:31, Aaron Kreider <[email protected]> wrote: > I've got kml files for all of the US zip codes (from the Census > Bureau, converted into kml at the geocommons website). > > Now I've also got mysql tables that have race and income data (also > from the Census Bureau) that I want to add to the kml files. > > Is there a tool that will help me do this? (Preferably a free one). > > Also, I really want to shade the polygons based on the income values - > so the color varies from say yellow to blue. Is there anything to > help me do this? > > Otherwise, I could write a script that will do this - but I'd rather > not. > > Is it possible to convert kml files into mysql - and then merge in my > income/race data? > > I'm very familiar with mysql, but I haven't tried geo db formats. > > Aaron -- 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.
