Link Districts to Locations

jonmgeiger commented 2 years ago

Our data has a list of school districts, but we're given no information about what counties/states/areas those school districts are in. Some of them might even span multiple states. We need to find a good data set that we can join with our main data to be able to work with maps, but we're not given any off the bat.

Some ideas:

Check out Department of Education to see if they have any data on school districts
Check out the Urban Institute report to see how they got location from the district data.
At the Urban Institute, try searching for data based on the tags of the original dataset to see if there's anything useful there.

joppaa commented 2 years ago

District Boundaries Data: https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries

joppaa commented 2 years ago

District Boundaries Data uses TIGER line shapefiles - need to use this r-package to download files from the above site. https://www.rdocumentation.org/packages/tigris/versions/1.6

jonmgeiger commented 2 years ago

@joppaa Can we aim to have this done by Friday? I think that using the tidycensus package will be very useful for this. I'd recommend making a pull request and linking this issue to it.

joppaa commented 2 years ago

Yes! I will aim to get it done by Friday night! I work mornings so it will be the afternoon's focus

jonmgeiger commented 2 years ago

@joppaa Check out this link for using Spatial Data in the tidycensus package.

jonmgeiger / household-conditions

Link Districts to Locations #6