Compare CEJST list of disadvantaged census tracts to DOT's lists and identify overlapping and non-overlapping census tracts

[BethMattern]

The DOT has developed its own formula for identifying disadvantaged communities. We would like to compare their list of census tracts to the list of census tracts identified by the CEJST to identify:

1. Which census tracts are in both lists
2. How many and % census tracts are in both lists
3. Which census tracts are not in the CEJST list but are in the DOT list
4. How many and % census tracts are not in the CEJST list but are in the DOT list
5. Which census tracts are in the CEJST list but are not in the DOT list
6. How many and % census tracts are in the CEJST list but are not in the DOT list

This analysis should be done for 2 DOT lists: SumIndicators3 - this is a list of prioritized census tracts that meet 3 thresholds identified by DOT SumIndicators4 - this is a list of prioritized census tracts that meet 4 thresholds identified by DOT

Ideally, the output will be in excel so further analysis can be done.

[BethMattern]

https://app.zenhub.com/files/358242767/126416ca-eb3a-45c0-acd5-70e37e595224/download

[BethMattern]

https://app.zenhub.com/files/358242767/fb79164d-2f89-44c5-bff2-a43bc9337b48/download

[saran-ahluwalia]

Answers to these questions can be found here and the artifacts. Please see the repository for additional details.