Quote:

---

I / we appreciate anything you are willing to do for us. I will be sending you the file this afternoon.

I would still like to come up with a way I could generalize this so I could do the same thing for a variety of different sets of data. For example, should I use the current year data or several years? Should I use clients or sessions with clients?

Thanks for your help!!!

---

You would probably need to invest in some software to do this easily on your own. Here is quick and dirty of what I will do

1) Open the zip code data from US Census with GlobalMapper ($300 program and worth every penny) and export as SHP file.
2) Convert the DBF that contains data for SHP file to Excel Spreadsheet (which I sent to you)
3) Convert the Excel file back to DBF
4) Open the SHP/DBF file with MapWindow (Free) using Shape2Earth Plugin ($30 program)
5) Export to KML

If you can find a free way to convert from e00 (format from Census) to SHP, then you can skip step 1.

Matt

--------------------
Matt
Google Earth Library

Post Extras