Datasets and Data Processing

I gathered the datasets from WPRDC in terms of fast food restaurants, convenience stores, farmers market, and school district boundaries.

https://data.wprdc.org/dataset/allegheny-county-fast-food
(Links to an external site.)Links to an external site.https://data.wprdc.org/dataset/allegheny-county-supermarkets-convenience-stores
(Links to an external site.)Links to an external site.https://data.wprdc.org/dataset/allegheny-county-farmers-markets-locations-2017
(Links to an external site.)Links to an external site.https://data.wprdc.org/dataset/allegheny-county-school-district-boundaries (Links to an external site.)Links to an external site.

By doing the data processing in Carto, I integrate the datasets and overlayed them together. It is interesting to find that In Woodland Hills School District, the food resources are located more even than Pittsburgh, where the restaurants and convenience stores are aggregated at business districts and streets.

https://carnegiemellon.carto.com/u/yidan-g/builder/f6a29f75-4d25-44fd-8ae8-4ad722284c38/embed