Public-Environmental-Data-Partners/EJAM
FIPS missing/problems (mostly in Connecticut)
Aperta
#19 aperta il 2 ago 2025
BUGPRIORITY MEDIUMdatasets-relatedhelp wantedmaps-relatedrank:B-high-value-high-cost
Metriche repository
- Star
- (2 stelle)
- Metriche merge PR
- (Metriche PR in attesa)
Descrizione
Missing some 19 bgfips in blockgroupstats (almost 1% of CT) and some County FIPS in censusplaces table (1% of USA) - Some FIPS for the State of CT in particular had problems or were missing in some tables:
dataload_dynamic("bgid2fips")
bgfips_via_blockgroupstats = blockgroupstats[ , unique( bgfips )]
bgfips_via_bgid2fips = bgid2fips[, unique(substr(bgfips, 1, 12))]
length(bgfips_via_bgid2fips)
length(bgfips_via_blockgroupstats)
fips2state_abbrev(setdiff(bgfips_via_bgid2fips,bgfips_via_blockgroupstats)) # all are in CT
And possibly related issues in this dataset mostly in CT but also in AK and a few others:
table(censusplaces$ST[is.na( fips_lead_zero( censusplaces$countyfips) )])
# in countyfips column, but 370 (1% of them) are NA values -- 85% of the problems are in CT
table(is.na(censusplaces$countyfips))
table(censusplaces$ST[ is.na(censusplaces$countyfips) ])