The Ancestry_Locations table is a place lookup: each row is one location with its name and coordinates. It is shared by the birth-location features, which reference a place by its Id rather than repeating the name and coordinates on every row.
| Column | Type | Source | Description |
|---|---|---|---|
| Id | int (PK) | Auto | Auto-incrementing primary key — referenced by Ancestry_SharedBirthLocations.locationId |
| locationName | string | Match Compare | Place name (unique) |
| coords | string | Match Compare | Coordinates for the location |
| loginUsername | string | App | DNAGedcom username who gathered this data |
locationName keeps the table deduplicated. When a location is encountered during gathering, the app looks it up by name and reuses the existing row, only inserting a new one if the name is not already present.locationId.