search

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

p65plbwpv, and pu18bwpv, pbwpv e, m, p match, but z not matching #72

Closed SPTKL closed 3 years ago

SPTKL commented 3 years ago

maybe these two shouldn't be part of profile only variable exception?

69

23

56

mgraber commented 3 years ago

Also true for pbwpv

SPTKL commented 3 years ago

I did some spot checks and don't see obvious errors

mgraber commented 3 years ago

For these variables, P and Z come from a different table than E and M.

  • [x] PBwPv -- percent: S1701_C03_001E -- percent MOE: S1701_C03_001M
  • [x] PU18BwPv -- percent: S1701_C03_002E -- percent MOE: S1701_C03_002M
  • [x] P65plBwPv -- percent: S1701_C03_010E -- percent MOE: S1701_C03_010M

Originally posted by @EricaMaurer in https://github.com/NYCPlanning/db-acs/issues/28#issuecomment-584768066

We would need logic to run calculate_e_m against these variables, then rename them as P and Z.

SPTKL commented 3 years ago

maybe we should create them as variables in the metadata? pbwpvp, pbwpvz & etc, then somehow merge them somewhere?