About this Query
This query will help you find a list of CAFOs that have, at least, a certain number of milking cows that you
specify. The result will show the following information: CAFO name, number of milking cows, city and county where these CAFOs are located, and other information (e.g. number of heifers and calves). This query is useful to some potential users because normally those large-scale CAFOs have better economic feasibility and thus, it will be interesting to find them out.
Example
In this example, suppose we want to find all of those CAFOs that have 1200 or more milking cows on farm. The general procedures are as following:
Step 1: Check on or off the boxes in front of the layers so that only "CAFO Dairy", "CAFO Lables", and "County" are selected. You can select more layers if you want. However, the map will be cleaner and easier to read by checking off those unnecessary layers. Be sure to press "Apply" afterward to make the changes effective.
Step 2: Enter "1200" in the text box in front of the "Query" button. Be sure to enter a reasonable number. The number should be an integer. To get a sense of the herd size range of CAFOs in New York State, check the " Futher Information ".
Step 3: After entering the number, press the "Query" button to run it. The map will be updated so that all CAFOs that have at least 1200 milking cows will be shown at the center of the map. All of these selected CAFOs will be highlighted in red color (compared to those unselected in blue color). A table of these CAFOs will also be generated and displayed under the map.
Step 4: Right click anwhere in the area that displays the querying results and then select "Export to Microsoft Excel". Then a Excel windows will pop up and the querying results will be retrieved and displayed as a Excel sheet (See the following two images).
This only applies to Windows XP users. If you are using different operating system, you might just hilight the table and then copy-paste to Excel or Word.
Further Information
The number of milking cows on CAFO dairies in New York State:
|