Wednesday, November 25, 2009

Geography Extras

Aggregate Data: PUMA to County conversion

The ACS provides annual data, but the geographic scope of these data is limited because of the 65,000+ population requirement. Less than 900 counties meet this cutpoint. One solution to this is to produce a PUMA-based query and then use a crosswalk to map PUMAs to counties.
PUMA to County Widget [PDQ-Explore output]
This widget takes output from PDQ-Explore and converts PUMA-based characteristics to county-based characteristics
PUMA to County Widget [American FactFinder output]
This widget takes output from American FactFinder and converts PUMA-based characteristics to county-based characteristics
Posted by lisan at 05:16 PM | Comments (0) | TrackBack

November 24, 2009

Creating County Level Statistics from Microdata Files

Normally one would use tabular data to produce county-level statistics. However, sometimes the measure one wants is not available in tabular data and/or the county is not populous enough for county-based measures, e.g., ACS population limits.
The following document describes how one can produce county level data from PUMAs:
Here are the links to the executable program, the crosswalk, and instructions:
Program [p2c.exe]
Crosswalk [p2c.equ]
Guide to p2c [p2c.pdf]