search

NYCPlanning / db-acs

American Community Survey data processing for Population Fact Finder
4 stars 1 forks source link

New total lookup function #18

Closed SPTKL closed 4 years ago

SPTKL commented 4 years ago

the majority of the mismatches are caused by differences in P and Z. we need a look up table so that for each variable, we can find the correct total to calculate the percentages against. ideally for every variable. proposed structure: 

"variable_1":{ "type": "total", "total_variable":"N/A"}, 
"variable_2":{"type": "not total", "total_variable":"variable_1"}

then we will calculate all the total variables first, then the non total variables to get the correct P and Z, it's also convenient because it would give us more accurate P=100

SPTKL commented 4 years ago

can be generated by the base colume in factfinder metadata