Location table is orphaned

[katy-sadowski]

It doesn't connect to any other tables right now, but it should actually have FKs in PERSON and PROVIDER. We should figure out how to link back each person/provider to their location in this table. As part of this, locations should also be de-duped.

[lawrenceadams]

Scoping

Effects the care_site and person table: at present all locations data comes from seeds/synthea/patients.csv and trickles into location from stg_synthea__patients. An interesting oversight from the original SyntheaOMOP project as this violates the CDM and doesn't even bother to dedup. Nice catch @katy-sadowski !

Given Synthea doesn't normalise locations at all I'd imagine we will have to hoover up all locations synthea generates for patients and care sites and then use the various aspects of the address as a natural key to join onto