GM_CommonLocation Table

The GM_CommonLocation table records locations shared between tree people from different DNA matches. When several matches have tree people born in the same place, it suggests a geographic connection in their family history. Each row is one location cluster for one match — a place, how many of the match’s tree people connect to it, and who those people are.

Data Source

Rows are parsed from the surname / location cluster data on GEDmatch’s ClusterDisplay.php page. The location text and match name are cleaned of HTML markup, the match’s shared cM is extracted from the linked-tree label, and the list of tree people is flattened with line breaks preserved.

kita

kita is your (primary) kit — the base kit being gathered. This table does not store a kitb; the match is identified by match_name rather than a kit number.

Column Reference

Column	Type	Description
Id	int (PK)	Auto-incrementing primary key
kita	string	Your (primary) kit number — the base kit being gathered. References GM_Kit.kit_num.
match_name	string	Display name of the match this location cluster belongs to.
match_cM	decimal	Total shared DNA between your kit and the match, in centimorgans (parsed from the linked-tree label).
location	string	The shared location (place name), with HTML stripped.
person_count	int	Number of the match’s tree people linked to this location.
tree_persons	string	The tree people at this location, as a line-break-separated list (HTML stripped, line breaks preserved).

Related Tables

• GM_CommonAncestor — shared common ancestors across matches, from the same ClusterDisplay source.
• GM_Match — the match summary; match_cM corresponds to the pair’s shared cM.
• GM_Kit — resolves kita to the base kit.