Development of method
A detailed step-by-step description of the newly developed protocol for measuring sidewalk distances is provided below. An example from one of the testing sites has been included within the step-by-step description to provide an illustration of how the new method works.
Stage 1 - exporting road network file from ArcGIS
Step 1: Adding GIS layers
• Open ArcMap software.
• Selecting "Add data".
• Open up the map of the area where you will be measuring the sidewalks. In the example we opened up a map of Canada.
• Add the road network layer for the area where you will be measuring sidewalks. In the example the road network layer for the specific testing site was obtained from CanMap RouteLogistics and was located in the DMTI Spatial Data folder.
• Add a layer that contains the water bodies. This layer is not required and this step is optional.
• Add the layer for the point of the specific location where you want to measure sidewalk distances. In the example we selected a point shapefile for the street address of one of the school testing sites. This file was called "School_Address".
Step 2: Create the area or buffer around the specific point (from Step 1) where you want to measure the distance of sidewalks
• Select the "ArcToolbox" icon, navigate to "Analysis Tools", then to "Proximity", then to "Buffer".
• On the "Input Features" of the pop-up-box, type in the file name (or select the point layer from the option box) for the point shapefile that was selected in Step 1. This file was called "School_Address" in the example.
• In the "Output Features Class" select the directory where you want to export the shapefile layer for the buffer, and give the shapefile a name. This shapefile was called "School_Buffer" in the example.
• In this example, which was based on a 1 km shapefile buffer, under "Distance [value or field]" we selected "Linear unit", we typed in "1" in the text box below "Linear unit", and we selected "kilometers" in the menu beside "Linear unit". These specifications can be modified depending on the type, size, and distance units of the buffer being used.
• Select "OK" at the bottom of the pop-up-box.
• An illustration of what the computer screen looked like at the end of Step 2 for the example testing site is shown in Figure .
Step 3 (optional): Change the colour, symbol type and/or width of layers
• Click the left mouse button while the cursor is located on the layer symbols if you want to change the visual features of these symbols.
Step 4: Extract road network geospatial data
• Select the "ArcToolbox" icon, navigate to "Analysis Tools", then to "Overlay" then to "Intersect".
• In the pop-up-box select the buffer that was created in Step 2. This was called "School_Buffer" in the example.
• Select the road network layer that was added in Step 1.
• Under "Output Feature Class" select the directory where you want to save the new file, and then give this file a name. In the example, we called this file "Extracted_Roads".
• Select "OK" on the bottom of the pop-up-box.
Step 5: Save the extracted road network and the buffer layer as a KML file.
• Remove (by checking-off) the point shape file layer, which was called "School_Address" in our example, and the original road network layer.
• Double click on the road network symbol (under Layers table of contents) and change the color and width of the road segment lines. We suggest you select a bright green color and a width value of 3, which were used in our illustrative example (Figure ).
• Double click on the buffer layer symbol (under the Layer table of contents) and select a bright colour that is different than the road network color. We suggest red, which was used in our example.
• Select the "ArcToolbox" icon and navigate to "Conversion Tools", then to "To KML", then to "Layer To KML".
• In the pop-up box, under "Layer" type in the file name for the extracted road network from Step 4 ("Extracted_Roads" in the example)
• Under "Output File" select the directory where you want to save the KML file.
• Under "Layout Output Scale" type in "1", which is the scale.
• Select "OK" on the pop-up-box.
• Select the "ArcToolbox" icon and navigate to "Conversion Tools", then to "To KML", then to "Layer To KML".
• In the pop-up box, under "Layer" type in the file name for the newly created buffer layer from Step 2 ("School_Buffer" in the example).
• Under "Output File" select the directory where you want to save the KML file.
• Under "Layout Output Scale" type in "1".
• Select "OK" on the pop-up-box.
Stage 2 - deleting road segments without sidewalks in Google earth
Step 1: Open up the road network and buffer layers in Google Earth.
• In the main table of contents select "File", navigate to the folder where the KML files were saved in Step 5 of Stage 1, and double click with the left mouse button on both files. These files were called "Extracted_Roads" and "School_Buffer" in the example.
• The road network and buffer layers should now appear in Google Earth. An illustration of these two layers for the example test site is shown in the top left panel of Figure .
Step 2: Deleting road segments without sidewalks
• On the "Places" table of contents click on the "+" button beside the name of the road network layer that was opened in Step 1 ("Extracted_Roads" in the example). This will open a list of the road segments that are located within the road shapefile buffer.
• Double click with the left mouse button on the first road segment that appears in the list. This will take Google Earth to the location of the selected road, which will appear on the image in the main part of the screen. An image of what this may look on a computer screen is shown in Figure .
• Visually inspect the segment to see if that road contains sidewalks on either or both sides. This process can be facilitated by zooming, panning or by using the street view option.
• If the road segment does not have a sidewalk on at least one side, delete that road segment by clicking on that road segment and selecting "delete". If the road segment has a sidewalk on one or both sides, do nothing.
• Repeat Step 2 for all the road segments in the shapefile buffer and delete all road segments that do not contain sidewalks. The top right panel in Figure displays the road network pattern in the example buffer after all road segments without sidewalks have been deleted. Notice the differences between the green road network pattern in the top left and top right panels. These differences reflect the roads without sidewalks. See Figure for an illustration of these differences.
Step 3: Save the modified road network (i.e., road segments with sidewalks) as a Google Earth file.
• Select the road network layer in the "Places" table of contents (called "Extracted_Roads" in the example) and select "Save Place As". In the example we called this new file "Roads_with_Sidewalks".
Stage 3 - calculating the length of sidewalks along roads
Step 1
• Open ArcMap
• Select the "ET Geowizards Tool" icon (
Note: you may need to install ET Geowizards. This program can be downloaded at
http://www.ian-ko.com/.
• In the pop-up-box select the "Import/Export" option from the left menu, and then the "Import from Google Earth" option.
• Select "Go" on the pop-up-box.
• In the new pop-up-box, in the "Select Google Earth file" text box, type in or select the Google Earth road network file that was saved in Step 5 of Stage 2. This file was called "Roads_with_Sidewalks" in the example.
• In the "Specific output PDGB or folder" text box, specify the output folder.
• Select "Add layers to the Map" and then "Finish".
• Close the two pop-up-boxes.
Step 2: Provide the data frame with the proper map projection in order to accurately calculate the length of the roads with sidewalks.
• Select the data frame name (Layers) and choose "Properties".
• In the pop-up-box select the "Predefined" folder, and within this folder select "Projected Coordinate Systems" then the "UTM" folder then the "NAD 1983" folder and then the appropriate Universal Transverse Mercator (UTM) geographic zone. Note that if you are calculating sidewalk distances outside of North America you should select "WGS 84" instead of "NAD 83". In the example, "UTM NAD83 Zone 17 N" was selected as the sidewalks were being measured for a testing site that was located within this UTM zone. Sixteen different UTM zones were used in our national study of 315 Canadian schools.
• Select "Apply" and then "OK".
Step 3:
• In the "Layer" table of contents, select the imported road layer (this was called "Roads_with_Sidewalks" in the example) and then "Attribute Table".
• In the pop-up-box select "Options" and then "Add field".
• In the new pop-up-box type in a name for the new field. This new filed was called "Sidewalk_Length" in the example.
• Under "Type" select the "Double" option. For the "Field Properties" leave "Precision" as 0 and "Scale" as 0.
• Select "OK".
Step 4: Calculate the distance of each road segment that has a sidewalk.
• In the pop-up-box select the new field that was created in Step 3 (this field was called "Sidewalk_Length" in the example) and then the "Calculate Geometry" option.
• Under "Property" select "Length".
• Under "Coordinate System" select the "Use coordinate system of the data frame" option.
• Under "Units" select the unit of measure (e.g., kilometers, meters) you want the sidewalk distance to be measured in.
• Select "OK".
Step 5: Calculate the distance of road segments containing sidewalks for the entire buffer.
• In the pop-up-box select the new field that was created in Step 3 (this field was called "Sidewalk_Length" in the example) and select "Statistics".
• Within the new pop-up-box the following statistics will be provided in a summary table: count (which is the number of road segments with a sidewalk in buffer), minimum (which is the length of the shortest road segment in the buffer that has a sidewalk), maximum (which is length of the longest road segment in the buffer that has a sidewalk), sum (which is total length of road segments in the buffer that have a sidewalk), mean (which is the average length of road segments in the buffer that have a sidewalk), and standard deviation (which is standard deviation of the mean).
• An illustration of what the computer screen looked like at the end of Step 5 for the example testing site is shown in Figure .
Step 6: Record sidewalk distance information
• Either manually record the data from the summary table or copy-and-paste it into another file type such as Excel.