asked on

Create KML file from FIPS data

Hi..
I have spreadsheets of FIPS codes and lat.lng.
How can I create a KML file from this. That shows the border regaion of these points?

ASKER CERTIFIED SOLUTION

Ray Paseur

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JElster

ASKER

Can find the data... any other ideas?

Ray Paseur

Have you tried anything yet? Is there any SSCCE to show what you have tried?

Can you please post an example of the information you have?

JElster

ASKER

I have a spreadsheet of FIPS codes and .. need to create polygons

State      County      Climate Zone      Regime      Warm-Humid      State      FIPS      Latitude      Longitude
AL      Autauga County      3      Moist      Yes      AL      01001      32.536382      -86.644490
AL      Baldwin County      2      Moist      Yes      AL      01003      30.659218      -87.746067
AL      Barbour County      3      Moist      Yes      AL      01005      31.870670      -85.405456
AL      Bibb County      3      Moist      No      AL      01007      33.015893      -87.127148
AL      Blount County      3      Moist      No      AL      01009      33.977448      -86.567246
AL      Bullock County      3      Moist      Yes      AL      01011      32.101759      -85.717261
AL      Butler County      3      Moist      Yes      AL      01013      31.751667      -86.681969

Ray Paseur

What would your preferred polygon look like, given the Alabama counties listed here?

JElster

ASKER

I need shape files.. for each of the climate zones.. thx

Ray Paseur

Is there anything useful here?
http://planthardiness.ars.usda.gov/PHZMWeb/
http://www.climatesource.com/cgi-bin/csshop/index.html

JElster

ASKER

no.. thx anyway

Ray Paseur

Yeah, I've looked in all the expected places. Suggest you delete this question and save your points. And call your congressman's office. This information should exist, and almost certainly does exist. Getting it from the Government would be hard for you or me, but most government offices respond well to congressional requests.