The last CFFR (FY2010)
In the fall of 2011, the IDN analyzed the
FY2010 Consolidated Federal Funds
Report by Congressional District and Party.
summary of federal spending by
lets you see with your very own eyeballs
who's raiding the Treasury!
This district-level summary of the FY2010 CFFR ranks all 435 Congressional districts by total FY2010 federal spending per capita. Some of the highlights (or lowlights) are presented in this nifty "Party On!" poster featuring the 50 biggest budget hogs in Congress:
To provide a different perspective, the Nerd combined
CFFR and IRS tax data in a
state-level analysis of the 2010 federal deficit.
In case you want to wallow in the numbers yourself, here is the entire FY2010 Consolidated Federal Funds Report (39MB) including my summaries by Congressional District and State, and gross federal tax collections and tax refunds by state obtained from Tables 5 and 8 of the 2010 IRS Data Book.
Federal Taxes and Expenditures by Congressional District, 2008
To get a Congressonal district-level analysis of the federal deficit, the IDN compared federal spending by district from the FY2008 CFFR versus 2008 tax payments by district as summarized from the IRS's individual income tax data by Adjusted Gross Income and zip code for tax year 2008--the most recent year for which IRS data by zip code are available.
First, I extracted the totals by zip code from the IRS's 51 state files. Next, to match zip codes to Congressional Districts, I created a composite GIS shapefile of Zip Code Tabulation Area polygons in the US from 51 shapefiles obtained from the Census Bureau.
A derived point shapefile of zip code centroids was then matched to a polygon shapefile of 110th Congressional districts using ArcGIS's spatial join utility. The names, centroids and Congressional districts of 42,961 US zip codes are distributed here as an Excel file.
In order to account for other federal taxes at the zipcode level, I apportioned each state's corporate, estate, gift and excise taxes (from IRS 2008 Data Book Tables 5 [gross revenues] and 8 [refunds]) evenly between the Congressional districts in each state. Net revenues from these other sources are mostly dwarfed by individual income tax revenues.
District-level deficits are calculated as net revenues minus CFFR expenditures as calculated from a district-level summary of the FY2008 Consolidated Federal Funds Report (28MB). The final results, with Congressional districts ranked by per-capita deficit spending are distributed here as an Excel spreadsheet.
Congressional districts are ranked by per-capita (deficit)/surplus. The top 50 districts accounted for just over $1 trillion, or 35% of the total FY2008 federal deficit. 28 of these were represented by Republicans.
GIS data files:
Prior CFFR Analyses
Summaries of the FY2009 Consolidated Federal
Taxation and Spending by State, 2006, 2007, 2008 and 2009
2010 US Counties shapefile with Census data libraries
The IDN has created an updated shapefile of 3,143 US counties including population and housing profile data from the 2010 Census. While the Census's 2010 TIGER files include territorial waters and fine detail (making for flabby-looking coastal counties and very large file sizes), this shapefile represents land areas only, and its polygons have been generalized for file compactness.
I tried to create intelligible field names. Here are the field definitions.
I also compiled a series of spreadsheets from recent US Census Bureau data releases, including the Census's USA Counties Data File Downloads website. These tables are readily joined to the GIS counties shapefile via the "FIPS" field. Except where the field names are self-explanatory, each spreadsheet includes two worksheets: a data sheet and a listing of variable definitions.
Converting Appalachian Trail GPS data to GIS layers
I downloaded discontinuous trail segments (lines), shelters (points) and parking areas (points) recorded by GPS from the AT Conservancy. After deleting extraneous trail segments less than 10 meters in length, I snapped the end nodes of the remaining segments together and eliminated any remaining dangles. I also snapped vertices within a 1-meter tolerance. I then dissolved the segments by trail maintenance club, and then split them by shelter.
In order to create a correct sequence of trail segments between shelters, I selected and flipped all the southbound segments, so that all segments were oriented northbound. I then calculated starting and ending X-Y coordinates for each segment, exported these coordinates to Excel, and used Excel's VLOOKUP utility to match the starting and ending nodes of adjacent segments. I then numbered the segments sequentially.
I recombined the trail segments by club, and combined the club segments into a single composite trail feature covering 2,120 miles. Using a 1-Km resolution DEM (see below), I created a quick-and-dirty 3D version of the composite trail layer in order to create an elevation profile graph of it, as shown here:
initial geodatabase (29GB)
contains the AT Conservancy's
shelters and parking areas, as well as trail segments between
shelters, segments composited by club, and the complete
AT as 2D and 3D feature layers.
The 3D length of the Appalachian Trail, derived from the 30M-resolution DEM, is calculated to be 2,141.6 miles. I also calculated average slopes for each of the 288 trail segments between active shelters.
1-Km resolution Digital Elevation Data for the continental US
I downloaded 30-arc-second DEM data from the USGS National Map Viewer, added it to a projected Arc dataframe (US National Atlas Equal Area coordinate system), used a polygon of the Lower 48 states as a raster mask, and exported a DEM of the continental US with a cellsize (nominal resolution) of 1 Km.
This map package includes the DEM, a derived hillshade map, and state boundaries.
2010 Census: Delaware Population and
Housing Units by Census Block.