[GIS] How to find a county fips given a yahoo woeid

county

I've used the Yahoo API to pull some woeids for counties. I need to map those woeids back to fips codes in order to associate them back to other data in my database, but I can't seems to figure out how to get a fips given a woeid.

Yahoo's concordance API handles the other direction. With that, I can get a woeid for a given fips code, but how do I go the other direction?

Thanks!

Best Answer

You can use the YQL console to find all kinds of concordance for a given WOEID, eg. for Austria the query is 'select * from geo.concordance where namespace="woeid" and text="23424750"', try the following link and click the 'TEST' button.

http://developer.yahoo.com/yql/console/#h=select%20*%20from%20geo.concordance%20where%20namespace%3D%22woeid%22%20and%20text%3D%2223424750%22

Related Solutions

[GIS] get (USA) county neighbour relationship data

You could find a topological representation of county boundaries, such as the CTA boundary files (another source would be the OpenStreetMap, but that's not as complete) and then pick out all distinct pairs of county IDs on opposing sides of boundary lines - e.g. in the CTA files, there's these two fields in the link entity (as described in the documentation):

 (10)  county FIPS left    I6      48-53   
 (11)  county FIPS right   I6      54-59

EDIT: After request, here's the details on how to get the data:

To get all county codes, go to the page linked above, click on the 'List of county codes'.
To read the adjacent IDs, there's two options:
- download the shapefile ("GO" button next to Download SCUL), open the zip and read the .dbf file (there's loads of programs that open it, e.g. Excel, and the file is basically fixed-width-row ASCII table, so you should be able to extract the last two columns easily)
- or download the native format (i'd first try to see if the state boundaries contains the counties as well) open the .llr file, split it by lines (line ends with CR+LF = 0D 0A) and extract the ids from each line: left FIPS is in chars 48-53; right FIPS is in chars 54-59 (index of the first character in a line is 1)

[GIS] download all 3,141 County US Polygons clipped with high resolution shoreline data

I am not sure how you are going to know or check the shoreline clipped aspect of your question.
Esri has some datasets that are described as detailed (dtl).
However you would need to aquire the Data Distribution Application (DDA) [see page 8 of the pdf] to get them into shapefile as they originate as *.sdc format.

Data is provided in Esri’s compressed, direct-read, high-performance Smart Data Compression (SDC) format

dtl_wat, dtl_riv, dtl_cnty_ln, etc.

As you don't describe the use I would perhaps suggest using the esri services available online.
The esri data-and-maps is also described here and in pdf along with redistribution rights.
The download search begins here.
Also just found the high resolution shoreline data, and a great blog on how it can be used.

Best Answer

Related Solutions

[GIS] get (USA) county neighbour relationship data

[GIS] download all 3,141 County US Polygons clipped with high resolution shoreline data

Related Question