|
About this Query
Using this query, you can identify and locate all food processors that located within a specified distance from any point you define. A map of those identified food processors will be generated as well as a table will be presented under the map. The table will provide the following information about those facilities: name, waste type, address, city and county where they are located, zip code, contact information (phone # and FAX #), # of employees, and URL if available.
The coordinates (X, Y) are in decimal degree and the radius is in mile.
Example
In this example, suppose we want to find all of those CAFOs that are located within 25 miles of a given point (X=-76.54; Y=42.97). The general procedures are as following:
Step 1: Check on or off the boxes in front of the layers so that "Food Processors ", "FP Lables", "Supermarkets", "Fast Food Franchises", 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 "-76.54" in the text box after "X:" and "42.97" in the text box after "Y:). Then enter "25" in the text box after "Radius:".
Step 3: After entering the county name, press the "Query" button to run it. The map will be updated so that all CAFOs located within 25 miles of that given point are 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.
In this example, there are six food processors that located within 25 miles of that given point. Also there are dozens of supermarkets and fast food restaurants are located in that area. To find more about these food waste sources, you might go back (use  ) to the original map and zoom in (use  ) to this area. Then you can use "Info" tool -  to identify each one of them. For instructions, check out the "Mapping: Help Info & Examples".
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.
|