You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Ultimately this is caused by the CSV column being interpreted as an integer. In this case, the field is COUNTYFP so it should actually be 3 digits 001, but it's been shortened to 1. A county "GEOID" would be 5, as it is a concatenation of STATEFP + COUNTYFP.
Because all of this in the HEROP_ID, I'm thinking it may be best to calculate these derivative identifiers from that ID. For example, county GEOID would be the first 5 digits after US, so something like substr(x, 5, 10) (I may have the index positions wrong) would pull the id right out. This is something we could even wrap into the load_oeps function if that would be desirable.
County GEOID should be a 4-digit number (ex 1001), not a 1-digit number as is currently shown in the tracts file downloaded.
The text was updated successfully, but these errors were encountered: