{"@type": "dcat:Dataset", "accessLevel": "public", "contactPoint": {"@type": "vcard:Contact", "fn": "Bob Gradeck", "hasEmail": "mailto:wprdc@pitt.edu"}, "description": "We\u2019ve been asked to create measures of communities that are \u201cwalkable\u201d for several projects. While there is no standard definition of what makes a community \u201cwalkable\u201d, and the definition of \u201cwalkability\u201d can differ from person to person, we thought an indicator that explores the total length of available sidewalks relative to the total length of streets in a community could be a good place to start. In this blog post, we describe how we used open data from SPC and Allegheny County to create a new measure for how \u201cwalkable\u201d a community is. We wanted to create a ratio of the length of a community\u2019s sidewalks to the length of a community\u2019s streets as a measure of pedestrian infrastructure. A ratio of 1 would mean that a community has an equal number of linear feet of sidewalks and streets. A ratio of about 2 would mean that a community has two linear feet of sidewalk for every linear foot of street. In other words, every street has a sidewalk on either side of it. \r\nIn creating a measure of the ratio of streets to sidewalks, we had to do a little bit of data cleanup. Much of this was by trial and error, ground-truthing the data based on our personal  experiences walking in different neighborhoods. Since street data was not shared as open data by many counties in our region either on PASDA or through the SPC open data portal, we limited our analysis of \u201cwalkability\u201d to Allegheny County.\r\n\r\nIn looking at the sidewalk data table and map, we noticed that  trails were included. While nice to have in the data, we wanted to exclude these two features from the ratio. We did this to avoid a situation where a community that had few sidewalks but was in the same blockgroup as a park with trails would get \u201ccredit\u201d for being more \u201cwalkable\u201d than it actually is according to our definition. We did this by removing all segments where \u201cTrail\u201d was in the \u201cType_Name\u201d field.\r\n\r\nWe also used a similar tabular selection method to remove crosswalks from the sidewalk data \u201cType_Name\u201d=\u201dCrosswalk.\u201d We kept the steps in the dataset along with the sidewalks. \r\n\r\n In the street data obtained from Allegheny County\u2019s GIS department, we felt like we should try to exclude limited-access highway segments from the analysis, since pedestrians are prohibited from using them, and their presence would have reduced the sidewalk/street ratio in communities where they are located. We did this by excluding street segments whose values in the \u201cFCC\u201d field (designating type of street) equaled \u201cA11\u201d or \u201cA63.\u201d We also removed trails from this dataset by excluding those classified as \u201cH10.\u201d Since documentation was sparse, we looked to see how these features were classified in the data to determine which codes to exclude.\r\n\r\nAfter running the data initially, we also realized that excluding alleyways from the calculations also could improve the accuracy of our results. Some of the communities with substantial pedestrian infrastructure have alleyways, and including them would make them appear to be less-\u201dwalkable\u201d in our indicator. We removed these from the dataset by removing records with a value of \u201cAly\u201d or \u201cWay\u201d in the \u201cSt_Type\u201d field. We also excluded streets where the word \u201cAlley\u201d appeared in the street name, or \u201cSt_Name\u201d field.\r\n\r\nThe full methodology used for this dataset is captured in our [blog post](https://www.wprdc.org/news/measuring-walkability/), and we have also included the sidewalk and street data used to create the ratio here as well.", "distribution": [{"@type": "dcat:Distribution", "downloadURL": "https://data.wprdc.org/dataset/853a077d-0a31-4292-8a1d-5d60b530169b/resource/b90ccee1-c0aa-43b9-93e2-8a25e690c393/download/sidewalkstreetratioupload.csv", "format": "CSV", "mediaType": "text/csv", "title": "Sidewalk Street Ratio 2021/12/01 Blockgroup"}, {"@type": "dcat:Distribution", "downloadURL": "https://data.wprdc.org/dataset/853a077d-0a31-4292-8a1d-5d60b530169b/resource/ab8db07e-09ef-45c4-bad2-f7d32bfc5f26/download/sidewalkstreetratiotract.csv", "format": "CSV", "mediaType": "text/csv", "title": "Sidewalk Street Ratio 2021/12/01 Tract"}, {"@type": "dcat:Distribution", "description": "Obtained November 2021", "downloadURL": "https://data.wprdc.org/dataset/853a077d-0a31-4292-8a1d-5d60b530169b/resource/8b7f8dbf-3c31-4873-9953-533e4bf88f52/download/sidewalksstepsblockgroup.zip", "format": "SHP", "mediaType": "application/zip", "title": "Sidewalks and Steps"}, {"@type": "dcat:Distribution", "description": "Obtained November, 2021", "downloadURL": "https://data.wprdc.org/dataset/853a077d-0a31-4292-8a1d-5d60b530169b/resource/3754d493-625d-41ff-ba0f-1acead07b0e5/download/streetblockgroupwithexclusions.zip", "format": "SHP", "mediaType": "application/zip", "title": "Streets used in this  analysis"}, {"@type": "dcat:Distribution", "description": "Extracted from crash data", "downloadURL": "https://data.wprdc.org/dataset/853a077d-0a31-4292-8a1d-5d60b530169b/resource/00715f59-c979-438f-81d8-0a338ddb21b3/download/crashesped.zip", "format": "SHP", "mediaType": "application/zip", "title": "Pedestrian Crashes 2004-2020"}], "identifier": "853a077d-0a31-4292-8a1d-5d60b530169b", "keyword": ["pedestrian", "sidewalk", "walkability", "walkable"], "modified": "2022-03-09T20:10:05.289996", "publisher": {"@type": "org:Organization", "name": "Western Pennsylvania Regional Data Center"}, "theme": ["Transportation"], "title": "Sidewalk to Street \"Walkability\" Ratio"}