2020 Census changes

[AmandaDoyle]

Changes that will need to happen to PLUTO as a result of the 2020 Census release

• [ ] Add the following fields:
• CT2020
• CB2020
• [ ] Remove the following fields:
• Tract 2010
• [ ] Update the format following fields to match the format of these values as reported in DevDB where it's text, 6 characters, with leading zeros and no decimals for tract (e.g., 010300, 010301) and 4 characters for block (e.g., 0001, 4010):
• CT2020
• CB2020
• CT2010
• CB2010

[github-actions[bot]]

Stale issue message

[lseirup]

I don't think we can delete Tract2010 or change the format for CT2010 and CB2010. Agencies may have processes in place that expect that data.

[AmandaDoyle]

Add 2 new 2020 fields with proposed formatting Keep 2010 fields as is and phase out 2010 fields eventually

[AmandaDoyle]

Edited to add BCT2010 and BCTCB2010 fields per BC's comment

@SPTKL more detail on census fields Leave the following fields unchanged:

• CT2010
• CB2010
• Tract2010

Add the following fields after the CD field (between CD and CT2010). The formatting of these fields will be the same as the formatting of the fields in DevDB, and they'll be created the same way.

• BCT2020
• BCTCB2020
• ~~BCT2010~~
• ~~BCTCB2010~~

@lseirup Can you sign off on the above? ^ Final and confirmed by @lseirup. Only add in the two new 2020 CT and CB fields.

Given that we're not changing the 2010 fields and not formatting the 2020 fields to match the 2010 fields in PLUTO the addition of the 2020 fields does not have to follow the 2010 workflow. I think that we can do the following:

• add call to get 2020 data to geocode.py
• add 2020 fields in create_rpad_geo
• add 2020 fields in geocodes.sql
• add 2020 fields to geocode_nones.sql
• Add 2020 fields and boundaries to spatialjoins.sql and spatialjoins_centroid.sql
• Add 2020 fields to create and export scripts
• Add 2020 fields to QAQC scripts

Yes, this is overly complicated.

[SPTKL]

we should also add BCT2010 and BCTCB2010 so that agencies can have something to switch to if they no longer want CT2010, CB2010, Tract2010, and we should warn them about deprecation

[SPTKL]

@AmandaDoyle what about NTA and CDTA

[SPTKL]

@AmandaDoyle what about NTA and CDTA

Confirmed with Lynn that NTA and CDTA will not be part of pluto