About this Query
This query will help you find CAFOs in each county. The querying results will show the following information about those CAFOs: name, number of milking cows, address, city and county where they are located.
Be sure to enter the correct county name. It can be either upper case or lower case as long as the spelling is correct. If you are don't know or not sure about the exact spelling of a county that you are interested, you can search it in the " Further Information " section where a complete list of all counties in New York State is presented.
Example
In this example, suppose we want to find all of those CAFOs that are located in Tompkins County. 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 "Tompkins" in the text box in front of the "Query" button. Be sure to spell the CAFO name correctly. For help, check the " Futher Information ".
Step 3: After entering the county name, press the "Query" button to run it.
The map will be updated so that all CAFOs located in Tompkins County 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.
List of Counties in NYS
There are 62 counties in New York State and here is the list:
| Albany |
Delaware |
Lewis |
Orleans |
Schuyler |
Wyoming |
| Allegany |
Dutchess |
Livingston |
Oswego |
Seneca |
Yates |
| Bronx |
Erie |
Madison |
Otsego |
Steuben |
|
| Broome |
Essex |
Monroe |
Putnam |
Suffolk |
|
| Cattaraugus |
Franklin |
Montgomery |
Queens |
Sullivan |
|
| Cayuga |
Fulton |
Nassau |
Rensselaer |
Tioga |
|
| Chatauqua |
Genesee |
New York |
Richmond |
Tompkins |
|
| Chemung |
Greene |
Niagara |
Rockland |
Ulster |
|
| Chenango |
Hamilton |
Oneida |
St. Lawrence |
Warren |
|
| Clinton |
Herkimer |
Onondaga |
Saratoga |
Washington |
|
| Columbia |
Jefferson |
Ontario |
Schenectady |
Wayne |
|
| Cortland |
Kings |
Orange |
Schoharie |
Westchester |
|
|