linking County with City?

Apr 24, 2011 at 3:38 AM
Edited Apr 24, 2011 at 3:56 AM

I'm not sure what the LSAD column stands for but when you query City and County they both have stateid but do NOT have a link to eachother.  I was hoping to link City to County. Is there a way to do so?


** Also just loaded zipcode and same problem! No way to link zip to city or zip to county or zip to state for that matter. :(  Am I missing something??


Thanks!  Great job otherwise!

Apr 26, 2011 at 1:50 PM

What do you mean by link? A foregin key? You're more than happy to create it manually. The idea was to give a very plain DB with data so you can use it with your own data and reference it however you like.

Aug 22, 2013 at 8:36 PM
There's no way to link the two tables together. So I will have to manually find the county for each city and then modify the tables?