CX3 Tier 1 – NF2 Indicator Instructions
Markets Around Schools
NF2 – Small neighborhood food stores, including convenience stores, offer
affordable, quality fruits, vegetables, and other healthy foods.
Key Program Planning Questions:
Are qualify fruits, vegetables, and other healthy food options available to children and
adolescents around schools located in the neighborhood?
Assessment of this indicator will be conducted first through mapping smalls markets and
convenience stores around schools in the neighborhood in Tier 1. Field surveys will then be
conducted for all or a neighborhood sample if there are more than fifteen stores in Tier 2. To
begin assessment of Indicator NF-1 and for mapping indicators, log on to the Network for a
Healthy California Geographic Information System (GIS) at http://www.cnngis.org. Click on
“Launch Map Viewer” to access the program. Some instructions may vary for different operating
systems, browsers, and versions of software. If you have specific questions about using the
GIS, you can ask them by clicking “Contact Us” on the bar at the top of the screen. You will be
using similar mapping procedures for all Tier 1 indicators and some activities may overlap using
the same data lists, so saving and organizing maps and lists is important.
Map NF2 - 1
To assess proximity of small stores and convenience stores to schools, return to the map of
your study neighborhood on the http://www.cnngis.org website. Begin with a base map similar
to the map obtained from Indicator NF1 Supermarket Access showing the low income
neighborhood(s). Go to the layer called “Health, Nutrition and Education”, scroll down to “Other
Nutrition Programs/Education” and click on “Public Schools”. To see the schools on your map,
click on “Refresh the Map”.
Data List NF2 - 1
Look at the legend to determine the types of schools that are located in your study
neighborhood then go to box “Summarize Data” and choose “Public Schools” from the drop
down menu then click on “Go”. You will receive a listing of all public schools on the mapped
area with their location, contact information, and data about the schools. Download the list into
Excel and manipulate or print the list as needed. Using the information the list, identify the
elementary schools, middle schools, high schools and continuation high schools that are located
in the study neighborhood and list all of them on the Markets Around Schools Worksheet.
Map NF2 - 2
Identify all the schools with retail grocery stores ("Retail", "General Grocery") and convenience
stores ("Convenience Group") within ½ mile of them through several steps. Turn on both layers
and click "Refresh Map". To draw a ½ mile radius or buffer around a school, pull up the layer
list and click on the “i” in a blue circle next to “Public Schools” under “Health, Nutrition and
Education”. The circle should turn yellow. Click on the “Select” bar or on the arrow next to
“Select” on the left side of the screen. The circle around the arrow should turn yellow. Then
click on the school icon on the map - the icon should turn light blue. Click on the “Advanced”
tab on the right section of the screen, and then click the “Buffer” tab. Change “300” to “.5” in the
left box. Select “miles” from the pull down menu on the right box. Click the “Draw Buffer” box. A
red ring will appear around the school on the map.
Map NF2 – 3, Map NF2 - 4
To draw more than one buffer on the map at the same time, use the "Select", "Add To" button
on the left side of the screen. Once the first location has been selected and the blue box is
drawn around the selected point, mouse over "Select" and then "Add To" and "Remove From"
will appear. Click on "Add To" once the plus sign has turned yellow. Then click on the next
location to buffer. Continue this for as many locations to include in the buffer group as needed.
Once all locations have been selected, go back to the buffer tab on the right and click "Draw
Buffer". The red rings will appear around all the locations selected.
To print each map, right click on the map and select “Save as…”. Choose where to save it and
enter a name for the file in the box, e.g., the school name. Choose file type as a bitmap (.bmp)
from the drop down menu at the bottom of the dialogue box. Open up a new Word document
select “Insert”, “Picture”, “From File” and then choose the file just saved. The map should
appear in the document. Save the legend by right clicking on it and pasting it into the same
document with the saved map image.
Data List NF2 - 2
Pop ups will need to be accepted or hold down the "Ctrl" key to obtain the list. Choose “General
Grocery” from the drop down menu under “Summarize Data” and click on “Go”. You will receive
a listing of all the stores on the mapped area with their location, contact information, and data
about the stores. Use this list to select the small markets for inclusion in the Markets around
Schools Worksheet. The retail category, type and SIC description will help you to learn more
about the stores. Use the "No. Employees Range" to find the supermarkets from the map. In
the data list, identify the stores with 20 or less employees (i.e. 1-5 or 6-20). Also download the
list for the "Convenience Group". If you download the data lists to an Excel file, you can
combine, sort and manipulate the data as you would like. When a file is downloaded,
everything that is included in the map view is received, so double check the census tracts to be
sure that the markets you identify are in the selected census tracts for the neighborhood. Enter
the small markets with 20 or less employees and convenience stores in the census tracts of the
neighborhood from this list onto the CX3 Markets around Schools Worksheet.
Based on local knowledge, if there are other stores you believe should be included as a small
market or convenience store, only include grocery stores with less than four registers. It is
important to describe the rationale for adding them when completing the worksheet where the
markets are listed to keep track of selection criteria for stores. Mark on any printed maps with a
marker or on any electronic versions by inserting a point with in a small text box to include the
stores added. Additionally, if you believe a market is not categorized appropriately and should
not be considered a small market or convenience store, include it on the list in the worksheet,
but strike through the market name and make a notation that describes why it was removed.
Documentation of store selection and inclusion is a good practice. The “street view” on Google
maps can also help with a store type designation. If “street view” is available in the area of the
neighborhood, a visual of what the storefront looks like can greatly inform the decision of the
size and type of store.
Next Steps and Things to Keep in Mind
When you finish gathering information about supermarket access in your first study
neighborhood, repeat the procedure described in this section for all of your study neighborhoods
then summarize your findings on the Markets around Schools Worksheet. Keep in mind you
can also choose to map by neighborhood, preceding with each indicator for a neighborhood.
Also, similar mapping procedures will be used for other indicators and some activities may
overlap using the same data lists, so keeping maps and lists saved and organized is important.
As mentioned in the mapping section, local knowledge can greatly augment the mapping
process although it is not necessary. After Tier 1 mapping, it will be recommend that a drive
through of the neighborhoods is conducted prior to actually getting out into the field and
surveying. Again, if available, “street view” on Google maps can provide a first view of the
location before getting into the field. The Tier 1 mapping process should inform the Tier 2 field
survey process. The GIS will be a source of store and outlet lists to guide the field surveying
process. As you work with the GIS and use it along with other potential sources for retail outlet
data, the "Locate" function may be helpful. If there is a location found or known about, but not
seen on the map displayed through the GIS, use the "Locate" tab to enter an address that you
would like to search to see if it is part of the GIS database, but for some reason may not have
displayed on the map. Some other data sources that may be used in Tier 2 (and possibly in
Tier 1) include Google Maps and Health Department Environmental Health Lists.
For CalFresh information, call 1-877-847-3663. Funded by USDA SNAP, an equal opportunity provider and employer. Visit
www.cachampionsforchange.net for healthy tips. •California Department of Public Health