NYCPlanning / db-factfinder

data ETL for population fact finder (decennial + acs)
https://nycplanning.github.io/db-factfinder/factfinder/
MIT License
2 stars 3 forks source link

Add initial 2010 to 2020 implementation #106

Closed mgraber closed 3 years ago

mgraber commented 3 years ago

Tract to tract test case expected results:

BoroCT2020 BoroCT2010 Ratio10CTpartTo20CT ACSEst2010Geog ACSMOE2010Geog SampleEstimate SampleMOE
005001600 005001600 1.00 5,825 398 5,825 398
005001901 005001900 0.25 3,141 341 772 341
005001902 005001900 0.75 3,141 341 2,369 341
005001903 005001900 0.00 3,141 341 -  
005001904 005001900 0.00 3,141 341 -  

Note, I had to manually correct the rounding errors introduced by excel for the MOE calculation to work.