Public-Environmental-Data-Partners/EJAM
FIPS missing/problems (mostly in Connecticut)
オープン
#19 opened on 2025/08/02
BUGPRIORITY MEDIUMdatasets-relatedhelp wantedmaps-relatedrank:B-high-value-high-cost
Repository metrics
- Stars
- (2 個のスター)
- PR merge metrics
- (PR metrics pending)
説明
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) ])