Mapping Tools and Outputs

NASS Data

These files were created by downloading National Agricultural statistics service (NASS) data for a 10-year period from 1999-2008. The variables for annual yield information are in bushels and the average acres harvested within the county were also included, this was completed for all counties (where available), for the entire USA, for the crops of Wheat, Barley, Oats, Sorghum, and Rice. The data were imported into Microsoft Excel spreadsheets so that average production across multiple years could be calculated; a county had to have at least 9 out of 10 years of production to be included as a 10-year average. An estimate of straw production was calculated by using the average production for each county and applying a standard harvest index value for each crop of interest. Once 10-year average representative values for each county were calculated the data were linked to a national map of counties using the county and state FIPS code as the unique identifier. The spatial map is stored in the form of a “shape file” and can be displayed by most GIS packages. This method allows for the spatial visualization of tabular data by county for multiple variables which are stored in the related database. The original spreadsheets are also available for those that wish to view that data.

STRAW (ALL CROPS)

Straw

1999-2008 DATA

Barley

Average Grain Yield by County (lbs/acre)

5 Year Averge Grain Yield (lbs/acre)

10 Year Average Grain Yield (lbs/acre)

5 Year Average Straw Yield (lbs/acre)

10 Year Average Straw Yield (lbs/acre)

PDF document of all maps

Oats

Average Grain Yield by County (lbs/acre)

5 Year Averge Grain Yield (lbs/acre)

10 Year Average Grain Yield (lbs/acre)

5 Year Average Straw Yield (lbs/acre)

10 Year Average Straw Yield (lbs/acre)

PDF document of all maps

Rice

Average Grain Yield by County (lbs/acre)

5 Year Averge Grain Yield (lbs/acre)

10 Year Average Grain Yield (lbs/acre)

5 Year Average Straw Yield (lbs/acre)

10 Year Average Straw Yield (lbs/acre)

PDF document of all maps

Sorghum

Average Grain Yield by County (lbs/acre)

5 Year Averge Grain Yield (lbs/acre)

10 Year Average Grain Yield (lbs/acre)

5 Year Average Straw Yield (lbs/acre)

10 Year Average Straw Yield (lbs/acre)

PDF document of all maps

Wheat

Average Grain Yield by County (lbs/acre)

5 Year Averge Grain Yield (lbs/acre)

10 Year Average Grain Yield (lbs/acre)

5 Year Average Straw Yield H40 (lbs/acre)

10 Year Average Straw Yield H40 (lbs/acre)

5 Year Average Straw Yield H44 (lbs/acre)

10 Year Average Straw Yield H44 (lbs/acre)

PDF document of all maps