If all works well, then it should be completed within a few seconds and it will write the specified CSV file to the output folder. All sampled operations are mailed a questionnaire and given adequate time to respond by As mentioned in Section 4, RStudio provides a user-friendly way to interact with R. If this is your first time using a particular R package or if you have forgotten whether you installed an R package, you first need to install it on your computer by downloading it from the Comprehensive R Archive Network (Section 4). This article will show you how to use Python to retrieve agricultural data with the NASS Quick Stats API. The author. functions as follows: # returns a list of fields that you can query, #> [1] "agg_level_desc" "asd_code" "asd_desc", #> [4] "begin_code" "class_desc" "commodity_desc", #> [7] "congr_district_code" "country_code" "country_name", #> [10] "county_ansi" "county_code" "county_name", #> [13] "domaincat_desc" "domain_desc" "end_code", #> [16] "freq_desc" "group_desc" "load_time", #> [19] "location_desc" "prodn_practice_desc" "reference_period_desc", #> [22] "region_desc" "sector_desc" "short_desc", #> [25] "state_alpha" "state_ansi" "state_name", #> [28] "state_fips_code" "statisticcat_desc" "source_desc", #> [31] "unit_desc" "util_practice_desc" "watershed_code", #> [34] "watershed_desc" "week_ending" "year", #> [1] "agg_level_desc: Geographical level of data. Also note that I wrote this program on a Windows PC, which uses back slashes (\) in file names and folder names. 2017 Census of Agriculture. Beginning in May 2010, NASS agricultural chemical use data are published to the Quick Stats 2.0 database only (full-text publications have been discontinued), and can be found under the NASS Chemical Usage Program. An application program interface, or API for short, helps coders access one software program from another. Rstudio, you can also use usethis::edit_r_environ to open The report shows that, for the 2017 census, Minnesota had 68,822 farm operations covering 25,516,982 acres. Suggest a dataset here. In this case, you can use the string of letters and numbers that represents your NASS Quick Stats API key to directly define the key parameter that the function needs to work. Otherwise the NASS Quick Stats API will not know what you are asking for. Texas Crop Progress and Condition (February 2023) USDA, National Agricultural Statistics Service, Southern Plains Regional Field Office Seven Day Observed Regional Precipitation, February 26, 2023. To cite rnassqs in publications, please use: Potter NA (2019). It allows you to customize your query by commodity, location, or time period. ~ Providing Timely, Accurate and Useful Statistics in Service to U.S. Agriculture ~, County and District Geographic Boundaries, Crop Condition and Soil Moisture Analytics, Agricultural Statistics Board Corrections, Still time to respond to the 2022 Census of Agriculture, USDA to follow up with producers who have not yet responded, Still time to respond to the 2022 Puerto Rico Census of Agriculture, USDA to follow-up with producers who have not yet responded (Puerto Rico - English), 2022 Census of Agriculture due next week Feb. 6, Corn and soybean production down in 2022, USDA reports You can then visualize the data on a map, manipulate and export the results, or save a link for future use. Quick Stats is the National Agricultural Statistics Service's (NASS) online, self-service tool to access complete results from the 1997, 2002, 2007, and 2012 Censuses of Agriculture as well as the best source of NASS survey published estimates. Statistics Service, Washington, D.C. URL: https://quickstats.nass.usda.gov [accessed Feb 2023] . modify: In the above parameter list, year__GE is the class(nc_sweetpotato_data_survey$Value) It is best to start by iterating over years, so that if you bind the data into a single data.frame. The .gov means its official. Not all NASS data goes back that far, though. key, you can use it in any of the following ways: In your home directory create or edit the .Renviron You can check the full Quick Stats Glossary. However, beware that this will be a development version: # install.packages ("devtools") devtools :: install_github ("rdinter . This article will provide you with an overview of the data available on the NASS web pages. DSFW_Peanuts: Analysis of peanut DSFW from USDA-NASS databases. # filter out census data, to keep survey data only any place from which $1,000 or more of agricultural products were produced and sold, or normally would have been sold, during the year. Usage 1 2 3 4 5 6 7 8 The surveys that NASS conducts collect information on virtually every facet of U.S. agricultural production. install.packages("tidyverse") may want to collect the many different categories of acres for every Source: National Weather Service, www.nws.noaa.gov Drought Monitor, Valid February 21, 2023. Based on this result, it looks like there are 47 states with sweetpotato data available at the county level, and North Carolina is one of them. Besides requesting a NASS Quick Stats API key, you will also need to make sure you have an up-to-date version of R. If not, you can download R from The Comprehensive R Archive Network. Peng, R. D. 2020. DSFW_Peanuts: Analysis of peanut DSFW from USDA-NASS databases. Accessed: 01 October 2020. To use a baking analogy, you can think of the script as a recipe for your favorite dessert. Access Quick Stats Lite . 2020. Please note that you will need to fill in your NASS Quick Stats API key surrounded by quotation marks. The Cropland Data Layer (CDL) is a product of the USDA National Agricultural Statistics Service (NASS) with the mission "to provide timely, accurate and useful statistics in service to U.S. agriculture" (Johnson and Mueller, 2010, p. 1204). For Sign Up: https://rruntsch.medium.com/membership, install them through the IDEs menu by following these instructions from Microsoft, Year__GE = 1997 (all years greater than or equal to 1997). It allows you to customize your query by commodity, location, or time period. To submit, please register and login first. The API will then check the NASS data servers for the data you requested and send your requested information back. Its very easy to export data stored in nc_sweetpotato_data or sampson_sweetpotato_data as a comma-separated variable file (.CSV) in R. To do this, you can use the write_csv( ) function. Then, when you click [Run], it will start running the program with this file first. Either 'CENSUS' or 'SURVEY'", https://quickstats.nass.usda.gov/api#param_define. Data are currently available in the following areas: Pre-defined queries are provided for your convenience. To submit, please register and login first. Then, it will show you how to use Python to retrieve agricultural data with the NASS Quick Stats API. NASS publications cover a wide range of subjects, from traditional crops, such as corn and wheat, to specialties, such as mushrooms and flowers; from calves born to hogs slaughtered; from agricultural prices to land in farms. First, you will define each of the specifics of your query as nc_sweetpotato_params. Have a specific question for one of our subject experts? list with c(). Feel free to download it and modify it in the Tableaue Public Desktop application to learn how to create and publish Tableau visualizations. For most Column or Header Name values, the first value, in lowercase, is the API parameter name, like those shown above. There are However, it is requested that in any subsequent use of this work, USDA-NASS be given appropriate acknowledgment. The example Python program shown in the next section will call the Quick Stats with a series of parameters. equal to 2012. In this case, the NC sweetpotato data will be saved to a file called nc_sweetpotato_data_query_on_20201001.csv on your desktop. Note: When a line of R code starts with a #, R knows to read this # symbol as a comment and will skip over this line when you run your code. Before you can plot these data, it is best to check and fix their formatting. How to write a Python program to query the Quick Stats database through the Quick Stats API. The API only returns queries that return 50,000 or less records, so = 2012, but you may also want to query ranges of values. For docs and code examples, visit the package web page here . National Agricultural Statistics Service (NASS) Quickstats can be found on their website. RStudio is another open-source software that makes it easier to code in R. The latest version of RStudio is available at the RStudio website. Including parameter names in nassqs_params will return a Official websites use .govA It accepts a combination of what, where, and when parameters to search for and retrieve the data of interest. commitment to diversity. Alternatively, you can query values As a result, R coders have developed collections of user-friendly R scripts that accomplish themed tasks. Coding is a lot easier when you use variables because it means you dont have to remember the specific string of letters and numbers that defines your unique NASS Quick Stats API key. 2020. The Comprehensive R Archive Network website, Working for Peanuts: Acquiring, Analyzing, and Visualizing Publicly Available Data. Skip to 6. nassqs_auth(key = "ADD YOUR NASS API KEY HERE"). The ARMS is collected each year and includes data on agricultural production practices, agricultural resource use, and the economic well-being of farmers and ranchers (ARMS 2020). You dont need all of these columns, and some of the rows need to be cleaned up a little bit. The next thing you might want to do is plot the results. If you need to access the underlying request nassqs does handles In fact, you can use the API to retrieve the same data available through the Quick Stats search tool and the Census Data Query Tool, both of which are described above. subset of values for a given query. ggplot(data = sampson_sweetpotato_data) + geom_line(aes(x = year, y = harvested_sweetpotatoes_acres)). So, you may need to change the format of the file path value if you will run the code on Mac OS or Linux, for example: self.output_file_path = rc:\\usda_quickstats_files\\. Section 207(f)(2) of the E-Government Act of 2002 requires federal agencies to develop an inventory of information to be published on their Web sites, establish a schedule for publishing information, make those schedules available for public comment, and post the schedules and priorities on the Web site. Programmatic access refers to the processes of using computer code to select and download data. The census takes place once every five years, with the next one to be completed in 2022. However, other parameters are optional. Agricultural Census since 1997, which you can do with something like. This is why functions are an important part of R packages; they make coding easier for you. Its recommended that you use the = character rather than the <- character combination when you are defining parameters (that is, variables inside functions). Here is the most recent United States Summary and State Data (PDF, 27.9 MB), a statistical summary of the Census of Agriculture. Any person using products listed in . or the like) in lapply. 2020. A script includes a collection of code that, when taken together, defines a series of steps the coder wants his or her computer to carry out. it. USDA National Agricultural Statistics Service. Its main limitations are 1) it can save visualization projects only to the Tableau Public Server, 2) all visualization projects are visible to anyone in the world, and 3) it can handle only a small number of input data types. 2019-67021-29936 from the USDA National Institute of Food and Agriculture. For example, if youd like data from both You can use the ggplot( ) function along with your nc_sweetpotato_data variable to do this. You can also set the environmental variable directly with If you are interested in just looking at data from Sampson County, you can use the filter( ) function and define these data as sampson_sweetpotato_data. Lock This work is supported by grant no. This number versus character representation is important because R cannot add, subtract, multiply, or divide characters. valid before attempting to access the data: Once youve built a query, running it is easy: Putting all of the above together, we have a script that looks rnassqs (R NASS Quick Stats) rnassqs allows users to access the USDA's National Agricultural Statistics Service (NASS) Quick Stats data through their API. You will need this to make an API request later. write_csv(data = nc_sweetpotato_data, path = "Users/your/Desktop/nc_sweetpotato_data_query_on_20201001.csv"). In this publication we will focus on two large NASS surveys. Email: askusda@usda.gov NC State University and NC want say all county cash rents on irrigated land for every year since This function replaces spaces and special characters in text with escape codes that can be passed, as part of the full URL, to the Quick Stats web server. Before using the API, you will need to request a free API key that your program will include with every call using the API. Now that youve cleaned and plotted the data, you can save them for future use or to share with others. Open Tableau Public Desktop and connect it to the agricultural CSV data file retrieved with the Quick Stats API through the Python program described above. object generated by the GET call, you can use nassqs_GET to system environmental variable when you start a new R If you use https://data.nal.usda.gov/dataset/nass-quick-stats. You can then visualize the data on a map, manipulate and export the results as an output file compatible for updating databases and spreadsheets, or save a link for future use. Quick Stats. The Quick Stats Database is the most comprehensive tool for accessing agricultural data published by NASS. Be sure to keep this key in a safe place because it is your personal key to the NASS Quick Stats API. Because R is accessible to so many people, there is a great deal of collaboration and sharing of R resources, scripts, and knowledge. nc_sweetpotato_data_survey <- filter(nc_sweetpotato_data_sel, source_desc == "SURVEY" & county_name != "OTHER (COMBINED) COUNTIES") The inputs to this function are 2 and 10 and the output is 12. The following pseudocode describes how the program works: Note the use of the urllib.parse.quote() function in the creation of the parameters string in step 1. By setting domain_desc = TOTAL, you will get the total acreage of sweetpotatoes in the county as opposed to the acreage of sweetpotates in the county grown by operators or producers of specific demographic groups that contribute to the total acreage of harvested sweetpotatoes in the county. Quick Stats Lite provides a more structured approach to get commonly requested statistics from . query. The National Agricultural Statistics Service (NASS) is part of the United States Department of Agriculture. Cooperative Extension is based at North Carolina's two land-grant institutions, Title USDA NASS Quick Stats API Version 0.1.0 Description An alternative for downloading various United States Department of Agriculture (USDA) data from <https://quickstats.nass.usda.gov/> through R. . The program will use the API to retrieve the number of acres used for each commodity (a crop, such as corn or soybeans), on a national level, from 1997 through 2021. That is an average of nearly 450 acres per farm operation. Here are the pairs of parameters and values that it will submit in the API call to retrieve that data: Following is the full encoded URL that the program below creates and sends with the Quick Stats API. nassqs_params() provides the parameter names, Instead, you only have to remember that this information is stored inside the variable that you are calling NASS_API_KEY. The Census Data Query Tool (CDQT) is a web based tool that is available to access and download table level data from the Census of Agriculture Volume 1 publication. Winter Wheat Seedings up for 2023, 12/13/22 NASS to publish milk production data in updated data dissemination format, 11/28/22 USDA-NASS Crop Progress report delayed until Nov. 29, 10/28/22 NASS reinstates Cost of Pollination survey, 09/06/22 NASS to review acreage information, 09/01/22 USDA NASS reschedules 2021 Conservation Practice Adoption Motivations data highlights release, 05/06/22 Respond Now to the 2022 Census of Agriculture, 08/05/20 The NASS Mission: We do it for you, 04/11/19 2017 Census of Agriculture Highlight Series Farms and Land in Farms, 04/11/19 2017 Census of Agriculture Highlight Series Economics, 04/11/19 2017 Census of Agriculture Highlight Series Demographics, 02/08/23 Crop Production (February 2023), 01/31/23 Cattle & Sheep and Goats (January 2023), 12/23/22 Quarterly Hogs and Pigs (December 2022), 12/15/22 2021 Certified Organics (December 2022), Talking About NASS - A guide for partners and stakeholders, USDA and NASS Anti-Harassment Policy Statement, REE Reasonable Accommodations and Personal Assistance Services, Safeguarding America's Agricultural Statistics Report and Video, Agriculture Counts - The Founding and Evolution of the National Agricultural Statistics Service 1957-2007, Hours: 7:30 a.m. - 4:00 p.m. Eastern Time Monday - Friday, except federal holidays Toll-Free: (800) 727-9540, Hours: 9:00 a.m. - 5:30 p.m. Eastern Time Monday - Friday, except federal holidays Toll-Free: (833) One-USDA The USDAs National Agricultural Statistics Service (NASS) makes the departments farm agricultural data available to the public on its website through reports, maps, search tools, and its NASS Quick Stats API. One of the main missions of organizations like the Comprehensive R Archive Network is to curate R packages and make sure their creators have met user-friendly documentation standards. Next, you can use the filter( ) function to select data that only come from the NASS survey, as opposed to the census, and represents a single county. You can view the timing of these NASS surveys on the calendar and in a summary of these reports. into a data.frame, list, or raw text. Secure .gov websites use HTTPSA You can change the value of the path name as you would like as well. 1987. file, and add NASSQS_TOKEN = to the A function is another important concept that is helpful to understand while using R and many other coding languages. United States Department of Agriculture. For example, you will get an error if you write commodity_desc = SWEET POTATO (that is, dropping the ES) or write commodity_desc = sweetpotatoes (that is, with no space and all lowercase letters). In R, you would write x <- 1. You can think of a coding language as a natural language like English, Spanish, or Japanese. An official website of the United States government. by operation acreage in Oregon in 2012. NASS has also developed Quick Stats Lite search tool to search commodities in its database. As mentioned in Section 1, you can visit the NASS Quick Stats website, click through the options, and download the data. rnassqs tries to help navigate query building with Griffin, T. W., and J. K. Ward. NASS Reports Crop Progress (National) Crop Progress & Condition (State) token API key, default is to use the value stored in .Renviron . the .gov website. The CoA is collected every five years and includes demographics data on farms and ranches (CoA, 2020). NASS_API_KEY <- "ADD YOUR NASS API KEY HERE" Corn stocks down, soybean stocks down from year earlier parameter. Other References Alig, R.J., and R.G. N.C. Before coding, you have to request an API access key from the NASS. Install. organization in the United States. Call the function stats.get_data() with the parameters string and the name of the output file (without the extension). Production and supplies of food and fiber, prices paid and received by farmers, farm labor and wages, farm finances, chemical use, and changes in the demographics of U.S. producers are only a few examples. "rnassqs: An 'R' package to access agricultural data via the USDA National Agricultural Statistics Service (USDA-NASS) 'Quick Stats' API." The Journal of Open Source Software. To browse or use data from this site, no account is necessary. There is no description for this organization, National Agricultural Statistics Service, Department of Agriculture. for each field as above and iteratively build your query. Retrieve the data from the Quick Stats server. Also, be aware that some commodity descriptions may include & in their names. For example, a (D) value denotes data that are being withheld to avoid disclosing data for individual operations according to the creators of the NASS Quick Stats API. You can do this by including the logic statement source_description == SURVEY & county_name != "OTHER (COMBINED) COUNTIES" inside the filter function. Grain sorghum (Sorghum bicolor) is one of the most important cereal crops worldwide and is the third largest grain crop grown in the United. nassqs_param_values(param = ). parameters is especially helpful. You can see a full list of NASS parameters that are available and their exact names by running the following line of code. In addition, you wont be able file. 2020. In both cases iterating over An official website of the United States government. This is less easy because you have to enter (or copy-paste) the key each Read our Contact a specialist. NASS administers, manages, analyzes, and shares timely, accurate, and useful statistics in service to United States agriculture (NASS 2020). its a good idea to check that before running a query. You can register for a NASS Quick Stats API key at the Quick Stats API website (click on Request API Key). Public domain information on the National Agricultural Statistics Service (NASS) Web pages may be freely downloaded and reproduced. rnassqs package and the QuickStats database, youll be able use nassqs_record_count(). at least two good reasons to do this: Reproducibility. The query in The rnassqs R package provides a simple interface for accessing the United States Department of Agriculture National Agricultural Statistics Service (USDA-NASS) 'Quick Stats' API. your .Renviron file and add the key. Each table includes diverse types of data. The USDA NASS Quick Stats API provides direct access to the statistical information in the Quick Stats database. The latest version of R is available on The Comprehensive R Archive Network website. There are times when your data look like a 1, but R is really seeing it as an A. Providing Central Access to USDAs Open Research Data, MULTIPOLYGON (((-155.54211 19.08348, -155.68817 18.91619, -155.93665 19.05939, -155.90806 19.33888, -156.07347 19.70294, -156.02368 19.81422, -155.85008 19.97729, -155.91907 20.17395, -155.86108 20.26721, -155.78505 20.2487, -155.40214 20.07975, -155.22452 19.99302, -155.06226 19.8591, -154.80741 19.50871, -154.83147 19.45328, -155.22217 19.23972, -155.54211 19.08348)), ((-156.07926 20.64397, -156.41445 20.57241, -156.58673 20.783, -156.70167 20.8643, -156.71055 20.92676, -156.61258 21.01249, -156.25711 20.91745, -155.99566 20.76404, -156.07926 20.64397)), ((-156.75824 21.17684, -156.78933 21.06873, -157.32521 21.09777, -157.25027 21.21958, -156.75824 21.17684)), ((-157.65283 21.32217, -157.70703 21.26442, -157.7786 21.27729, -158.12667 21.31244, -158.2538 21.53919, -158.29265 21.57912, -158.0252 21.71696, -157.94161 21.65272, -157.65283 21.32217)), ((-159.34512 21.982, -159.46372 21.88299, -159.80051 22.06533, -159.74877 22.1382, -159.5962 22.23618, -159.36569 22.21494, -159.34512 21.982)), ((-94.81758 49.38905, -94.64 48.84, -94.32914 48.67074, -93.63087 48.60926, -92.61 48.45, -91.64 48.14, -90.83 48.27, -89.6 48.01, -89.272917 48.019808, -88.378114 48.302918, -87.439793 47.94, -86.461991 47.553338, -85.652363 47.220219, -84.87608 46.900083, -84.779238 46.637102, -84.543749 46.538684, -84.6049 46.4396, -84.3367 46.40877, -84.14212 46.512226, -84.091851 46.275419, -83.890765 46.116927, -83.616131 46.116927, -83.469551 45.994686, -83.592851 45.816894, -82.550925 45.347517, -82.337763 44.44, -82.137642 43.571088, -82.43 42.98, -82.9 42.43, -83.12 42.08, -83.142 41.975681, -83.02981 41.832796, -82.690089 41.675105, -82.439278 41.675105, -81.277747 42.209026, -80.247448 42.3662, -78.939362 42.863611, -78.92 42.965, -79.01 43.27, -79.171674 43.466339, -78.72028 43.625089, -77.737885 43.629056, -76.820034 43.628784, -76.5 44.018459, -76.375 44.09631, -75.31821 44.81645, -74.867 45.00048, -73.34783 45.00738, -71.50506 45.0082, -71.405 45.255, -71.08482 45.30524, -70.66 45.46, -70.305 45.915, -69.99997 46.69307, -69.237216 47.447781, -68.905 47.185, -68.23444 47.35486, -67.79046 47.06636, -67.79134 45.70281, -67.13741 45.13753, -66.96466 44.8097, -68.03252 44.3252, -69.06 43.98, -70.11617 43.68405, -70.645476 43.090238, -70.81489 42.8653, -70.825 42.335, -70.495 41.805, -70.08 41.78, -70.185 42.145, -69.88497 41.92283, -69.96503 41.63717, -70.64 41.475, -71.12039 41.49445, -71.86 41.32, -72.295 41.27, -72.87643 41.22065, -73.71 40.931102, -72.24126 41.11948, -71.945 40.93, -73.345 40.63, -73.982 40.628, -73.952325 40.75075, -74.25671 40.47351, -73.96244 40.42763, -74.17838 39.70926, -74.90604 38.93954, -74.98041 39.1964, -75.20002 39.24845, -75.52805 39.4985, -75.32 38.96, -75.071835 38.782032, -75.05673 38.40412, -75.37747 38.01551, -75.94023 37.21689, -76.03127 37.2566, -75.72205 37.93705, -76.23287 38.319215, -76.35 39.15, -76.542725 38.717615, -76.32933 38.08326, -76.989998 38.239992, -76.30162 37.917945, -76.25874 36.9664, -75.9718 36.89726, -75.86804 36.55125, -75.72749 35.55074, -76.36318 34.80854, -77.397635 34.51201, -78.05496 33.92547, -78.55435 33.86133, -79.06067 33.49395, -79.20357 33.15839, -80.301325 32.509355, -80.86498 32.0333, -81.33629 31.44049, -81.49042 30.72999, -81.31371 30.03552, -80.98 29.18, -80.535585 28.47213, -80.53 28.04, -80.056539 26.88, -80.088015 26.205765, -80.13156 25.816775, -80.38103 25.20616, -80.68 25.08, -81.17213 25.20126, -81.33 25.64, -81.71 25.87, -82.24 26.73, -82.70515 27.49504, -82.85526 27.88624, -82.65 28.55, -82.93 29.1, -83.70959 29.93656, -84.1 30.09, -85.10882 29.63615, -85.28784 29.68612, -85.7731 30.15261, -86.4 30.4, -87.53036 30.27433, -88.41782 30.3849, -89.18049 30.31598, -89.593831 30.159994, -89.413735 29.89419, -89.43 29.48864, -89.21767 29.29108, -89.40823 29.15961, -89.77928 29.30714, -90.15463 29.11743, -90.880225 29.148535, -91.626785 29.677, -92.49906 29.5523, -93.22637 29.78375, -93.84842 29.71363, -94.69 29.48, -95.60026 28.73863, -96.59404 28.30748, -97.14 27.83, -97.37 27.38, -97.38 26.69, -97.33 26.21, -97.14 25.87, -97.53 25.84, -98.24 26.06, -99.02 26.37, -99.3 26.84, -99.52 27.54, -100.11 28.11, -100.45584 28.69612, -100.9576 29.38071, -101.6624 29.7793, -102.48 29.76, -103.11 28.97, -103.94 29.27, -104.45697 29.57196, -104.70575 30.12173, -105.03737 30.64402, -105.63159 31.08383, -106.1429 31.39995, -106.50759 31.75452, -108.24 31.754854, -108.24194 31.34222, -109.035 31.34194, -111.02361 31.33472, -113.30498 32.03914, -114.815 32.52528, -114.72139 32.72083, -115.99135 32.61239, -117.12776 32.53534, -117.295938 33.046225, -117.944 33.621236, -118.410602 33.740909, -118.519895 34.027782, -119.081 34.078, -119.438841 34.348477, -120.36778 34.44711, -120.62286 34.60855, -120.74433 35.15686, -121.71457 36.16153, -122.54747 37.55176, -122.51201 37.78339, -122.95319 38.11371, -123.7272 38.95166, -123.86517 39.76699, -124.39807 40.3132, -124.17886 41.14202, -124.2137 41.99964, -124.53284 42.76599, -124.14214 43.70838, -124.020535 44.615895, -123.89893 45.52341, -124.079635 46.86475, -124.39567 47.72017, -124.68721 48.184433, -124.566101 48.379715, -123.12 48.04, -122.58736 47.096, -122.34 47.36, -122.5 48.18, -122.84 49, -120 49, -117.03121 49, -116.04818 49, -113 49, -110.05 49, -107.05 49, -104.04826 48.99986, -100.65 49, -97.22872 49.0007, -95.15907 49, -95.15609 49.38425, -94.81758 49.38905)), ((-153.006314 57.115842, -154.00509 56.734677, -154.516403 56.992749, -154.670993 57.461196, -153.76278 57.816575, -153.228729 57.968968, -152.564791 57.901427, -152.141147 57.591059, -153.006314 57.115842)), ((-165.579164 59.909987, -166.19277 59.754441, -166.848337 59.941406, -167.455277 60.213069, -166.467792 60.38417, -165.67443 60.293607, -165.579164 59.909987)), ((-171.731657 63.782515, -171.114434 63.592191, -170.491112 63.694975, -169.682505 63.431116, -168.689439 63.297506, -168.771941 63.188598, -169.52944 62.976931, -170.290556 63.194438, -170.671386 63.375822, -171.553063 63.317789, -171.791111 63.405846, -171.731657 63.782515)), ((-155.06779 71.147776, -154.344165 70.696409, -153.900006 70.889989, -152.210006 70.829992, -152.270002 70.600006, -150.739992 70.430017, -149.720003 70.53001, -147.613362 70.214035, -145.68999 70.12001, -144.920011 69.989992, -143.589446 70.152514, -142.07251 69.851938, -140.985988 69.711998, -140.992499 66.000029, -140.99777 60.306397, -140.012998 60.276838, -139.039 60.000007, -138.34089 59.56211, -137.4525 58.905, -136.47972 59.46389, -135.47583 59.78778, -134.945 59.27056, -134.27111 58.86111, -133.355549 58.410285, -132.73042 57.69289, -131.70781 56.55212, -130.00778 55.91583, -129.979994 55.284998, -130.53611 54.802753, -131.085818 55.178906, -131.967211 55.497776, -132.250011 56.369996, -133.539181 57.178887, -134.078063 58.123068, -135.038211 58.187715, -136.628062 58.212209, -137.800006 58.499995, -139.867787 59.537762, -140.825274 59.727517, -142.574444 60.084447, -143.958881 59.99918, -145.925557 60.45861, -147.114374 60.884656, -148.224306 60.672989, -148.018066 59.978329, -148.570823 59.914173, -149.727858 59.705658, -150.608243 59.368211, -151.716393 59.155821, -151.859433 59.744984, -151.409719 60.725803, -150.346941 61.033588, -150.621111 61.284425, -151.895839 60.727198, -152.57833 60.061657, -154.019172 59.350279, -153.287511 58.864728, -154.232492 58.146374, -155.307491 57.727795, -156.308335 57.422774, -156.556097 56.979985, -158.117217 56.463608, -158.433321 55.994154, -159.603327 55.566686, -160.28972 55.643581, -161.223048 55.364735, -162.237766 55.024187, -163.069447 54.689737, -164.785569 54.404173, -164.942226 54.572225, -163.84834 55.039431, -162.870001 55.348043, -161.804175 55.894986, -160.563605 56.008055, -160.07056 56.418055, -158.684443 57.016675, -158.461097 57.216921, -157.72277 57.570001, -157.550274 58.328326, -157.041675 58.918885, -158.194731 58.615802, -158.517218 58.787781, -159.058606 58.424186, -159.711667 58.93139, -159.981289 58.572549, -160.355271 59.071123, -161.355003 58.670838, -161.968894 58.671665, -162.054987 59.266925, -161.874171 59.633621, -162.518059 59.989724, -163.818341 59.798056, -164.662218 60.267484, -165.346388 60.507496, -165.350832 61.073895, -166.121379 61.500019, -165.734452 62.074997, -164.919179 62.633076, -164.562508 63.146378, -163.753332 63.219449, -163.067224 63.059459, -162.260555 63.541936, -161.53445 63.455817, -160.772507 63.766108, -160.958335 64.222799, -161.518068 64.402788, -160.777778 64.788604, -161.391926 64.777235, -162.45305 64.559445, -162.757786 64.338605, -163.546394 64.55916, -164.96083 64.446945, -166.425288 64.686672, -166.845004 65.088896, -168.11056 65.669997, -166.705271 66.088318, -164.47471 66.57666, -163.652512 66.57666, -163.788602 66.077207, -161.677774 66.11612, -162.489715 66.735565, -163.719717 67.116395, -164.430991 67.616338, -165.390287 68.042772, -166.764441 68.358877, -166.204707 68.883031, -164.430811 68.915535, -163.168614 69.371115, -162.930566 69.858062, -161.908897 70.33333, -160.934797 70.44769, -159.039176 70.891642, -158.119723 70.824721, -156.580825 71.357764, -155.06779 71.147776))), USDA National Agricultural Statistics Service, 005:042 - Department of Agriculture - Agricultural Estimates, 005:043 - Department of Agriculture - Census of Agriculture, 005:050 - Department of Agriculture - Commodity Purchases, 005:15 - National Agricultural Statistics Service.