Pedestrian Network Sidewalk Gap Ratio

This analysis identified the sidewalk coverage of each OSM street centerline across the region. For each street centerline, a PostGIS query applied the following logic: 1. Select all non-crosswalk segments from the sidewalk layer that intersect a 25-meter (82’) buffer around the centerline 2. Refine the selection to include sidewalks that either: a. have an intersection length greater than 25 meters,4 or b. are less than or equal to 25 meters in total length 5 3. Sum the lengths of the intersections of the remaining selected sidewalks 4. Divide the result of Step 3 by the length of the centerline The result of Step 4 is a ratio where: • 1 = full sidewalks on both sides of the street • 0.5 = sidewalk on one side of the street • 0 = no sidewalks on either side of the street For more details of the analysis, please visit https://dvrpc.github.io/network-routing

View map in GIS Catalog
objectid
hwy_tag
sw_ratio

Data Dictionary

Column Type Label Description
objectid OID objectid Internal feature number.
hwy_tag String hwy_tag
sw_ratio Double sw_ratio
shape Geometry shape Feature geometry.
st_length(shape) Double st_length(shape)