add pins_master foreign key to all datasets with address info

maschinenmensch / edifice

A database of the built environment in Chicago

5 stars 1 forks source link

add pins_master foreign key to all datasets with address info #22

Closed derekeder closed 11 years ago

derekeder commented 11 years ago

After datasets are loaded in to Edifice, we need to identify and associate all tables with address info to the pins_master. This involves several steps:

identify tables with address data
look up and match address across tables
create foreign key linking tables together