search

americanpanorama / panorama-foreignborn

Foreign-Born Population 1850-2010
8 stars 2 forks source link

Archaic spelling of Fresno #2

Closed almccon closed 8 years ago

almccon commented 8 years ago

Frezno is wrong. screen_shot_2016-01-14_at_4 33 28_pm

almccon commented 8 years ago

Hmm. Actually, this appears to be the correct original spelling.

screen shot 2016-01-14 at 4 58 04 pm screen shot 2016-01-14 at 4 57 52 pm screen shot 2016-01-14 at 4 56 20 pm

almccon commented 8 years ago

I don't particularly want to adapt the code to change the names of counties over time... but now I wonder how widespread this might be. How many other counties might have changed names in their history?

Quickest (but wrongest) solution is to change the names in the database.

Second quickest (but less wrong) is to make sure we choose the most recent name of a county, instead of the first name. This name must be coming from a lookup someplace where we join the nhgis_join ID with a table that contains county names. This would mean that all counties would show their present-day name, even if you scrub back into the past to a point where the county might have had a different name.

Least quick solution is for the code to know what each county's name is for each year, which adds complexity and would involve a (small?) performance hit.

almccon commented 8 years ago

I did the quickest solution.