search

DataUSA / datausa-tracker

0 stars 0 forks source link

county & state IDs missing from tracts shape table #110

Closed jspeis closed 6 years ago

jspeis commented 6 years ago

UPDATE shapes2017.tracts SET county_name = (select c.name_unique from shapes2017.counties c where tracts.county_id= c.geoid) UPDATE shapes2017.tracts SET state_name = (select c.state_name from shapes2017.counties c where tracts.county_id=c.geoid)

hwchen commented 6 years ago

This has been fixed in the census-geography sql. I was already using the basic strategy of above comment, but I had mistakenly done some preprocessing of an id col which messed up the join. The latest deployed version of census geographies on monetdb has the fix.

On Wed, Aug 1, 2018 at 1:49 PM, Jonathan Speiser notifications@github.com wrote:

UPDATE shapes2017.tracts SET county_name = (select c.name_unique from shapes2017.counties c where tracts.county_id= c.geoid) UPDATE shapes2017.tracts SET state_name = (select c.state_name from shapes2017.counties c where tracts.county_id=c.geoid)

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/Datawheel/datausa-tracker/issues/110#issuecomment-409662624, or mute the thread https://github.com/notifications/unsubscribe-auth/ADm0i2y2YP3Wnx9MkWtsbbaHIhlPBB8Yks5uMepHgaJpZM4Vq8sk .