Is there a way to easily see DNA matches who are connected to my tree?

Question

It would be nice if there was a button / tab where I could see all of my DNA matches. People who have connected to my tree and also who have taken a DNA test.

I know I can scroll through all of my ancestors in "DNA Ancestor Confirmation Aid" to see if anyone else matches my ancestors besides myself. But, can I request a future upgrade that would show all of my DNA matches on one page?

Thanks!

Answer 1

On your profile WikiTree automatically displays all of the people connected to your tree who have taken a DNA test. Right now Dewey Neves and Dixie McBride show up on your profile. It's a good idea to change the privacy level of profiles where DNA is involved to 'private with a public family tree' to make sure those links work correctly. I see that the profiles for those two people are both private.

Comments

No, All of the people connected to my tree who have taken DNA tests do not show up on my profile. My two parent whom I have tested show up however there are several people who have taken DNA test and are connected to my tree who only show up if I scroll through the "DNA Ancestor Confirmation Aid" or go directly to the profile of the ancestor with the DNA match.  

I am simply asking for a list of all these people in one simple to access list.

---

You're right! I thought all of them were displayed on our profiles. In checking mine, it looks like 3rd cousins are displayed, but not further back than that. Your two that don't show up on your profile are your 4th and 5th cousins.

---

Kay, you're right, it's up to third cousins for autosomal tests. We aim to include anyone who almost certainly would match. With Y and mtDNA the connections are infinite, but with autosomal it's eight steps. There are, of course, many others with which you might match.

We would like to do a report like this, Darin. I think we could also proactively send you an e-mail when someone new adds a test.

---

I really like the idea of receiving an e-mail when someone new adds a test!

Answer 2

+1 for Darin's idea for improvement. Please correct me if I understood you wrong but I think you're asking for a single page that is listing all relatives that have done a DNA test, correct? That means all side-lines, x-times removed whatever.

I think right now we don't have the possibility to see sidelines which are very important in DNA genealogy as our cousins help us identify on which branch other DNA cousins belong.

Having said that I think we still need to make restrictions as to how far the algorithm is searching to find those with DNA tests, just imagine if one person is connected to the World tree (I' m still not) it would otherwise go through all x million profiles and the list can become quite extensive. Also, many might be too far away from you as to still see ancestral segments that survived.

Comments

yes, but the algorithm only needs to search back the number of generations that the DNA tests show on profiles.

---

Darin, I think you misunderstand how the data is being connected. Every person (in WikiTree) is a new document that is related to other person through a relationship (meaning an unique id to another document).

So you could be doc #001 and your father could be #002, your mother #003, etc. In order now to find someone in your tree with a DNA test you have to go document by document through the whole tree.

Even if there is a special table that has just the document number for people on WT who did a dna test that will only give the document no, eg #452353. It's not clear to which other person on WT with a DNA test this document is connected unless the algorithm searches one document to the next (going along the connections for each document it looks at).

So every document needs to be retrieved from a hard disk (unless a NoSQL or similar database is used that keeps the most recent documents in memory), making each retrieval a read operation which is costly, especially when you take into account that WT has more than 11 million profiles now. I'm not even counting the number of connections between them, must probably in the range of almost 100 million connections.

Hope you have a better understanding now that such a task / report isn't a small feature to do. Plus, the data at WT is changed every second, new data is added, relationships are added, changed or deleted (through merges).

Don't get me wrong, I'm all in for such a feature and would find it highly helpful, it's just an explanation of what needs to be done. Hope I made it easy enough in laymen's terms.

---

Right, Andreas, this is costly. We're already doing lots of processes offline.

But ... if all you'd want to see is the same connections you see on the DNA Ancestor Confirmation Aid, just without all the extra stuff, it's feasible to do it on the fly because we're already doing the connections offline.

http://www.wikitree.com/wiki/DNA_Ancestor_Confirmation_Aid

Darin, is that all you're asking for?

Andreas, are those all the cousins you'd want to see?

We could look at doing an alternative to the DNA Ancestor Confirmation Aid that lists the same people in a different format.

---

Thanks Chris for joining the discussion. I wasn't aware that the ACA covers this. Seems like a working solution, how far is the ACA going back (it shows until 3g-grandparents right now)?

What a pity that after been here for quite some time I still haven't found a single connection to another tree. So for me it won't work but some who is connected to the world tree can report on it. @Peter Roberts, what's your view on it?

---

Hello Andreas, I'm not fully understanding the discussion. I am connected  to the Global Family Tree here in WikiTree.  I have a huge interest in knowing when Y-DNA and mtDNA tested cousins reveal the Y-DNA or mtDNA (haplotype/mitotype and haplogroup) of one of our shared ancestors.  Right now I hunt for them manually.   The key is to get one of their most distant direct paternal line or direct maternal line couins to take a Y-DNA or mtDNA test and if they match sufficiently then confirm some ancestral lines.

Unlike auDNA, X chromosome matching (easiest wth just males) can confirm lines more generations back.

Answer 3

Have you checked Family Tree DNA Family Finder Test Details & Connections

• Your Special:DNATests&u=6068427&id=1 = 20 living
• My Special:DNATests&u=7340000&id=6 = 37 living
• Andreas Special:DNATests&u=7365919&id=1 12 living

Then you get an indication if people are living... which is a good start for testing.... looks like you have 20 living people connected...

 

• This includes all blood relatives within eight degrees of separation — up to sixth great-grandparents and out to third cousins.

Comments

This suggestion is something similar to the one I have made in the past. There are three improvements to this report which I think would be beneficial.

1. Only list the living. This smaller list makes it easier to identify new profiles added to the list as they appear.

2. Add the DNA icons to those who have added their DNA test.  This identification makes it easier to find and compare to those who have taken a DNA test.

3. Expand the list to those who might potentially be matches on any of the DNA Services.  Even though the DNA service might miss some relatives beyond 3rd cousins, those they do find are most likely cousins within the genealogical time frame. This would be especially true in this case as wikitree has them related.

Most people who subscribe to a DNA have 100's of Relatives beyond 4rd cousins. There is a significant benefit to identifying those who have a tree that we know to be connected to ourselves.

---

I did a cut/paste of the above Wikitree list to Google Calc and used function 
=SORT( UNIQUE( FILTER( B2:B ; COUNTIF( UPPER(A2:A) ; UPPER(B2:B) )> 0 ) ) )

To compare two Wikitree users to see what they have in common.... think it worked

See Google calc tab 2 

---

Version 2 ==> just point on the webpage from Calc and say import the list from the page ===> when the list is changed in Wikitree the calc will have the latest....

Video https://youtu.be/3m26iz-adiE

Google Calc =IMPORTHTML("http://www.wikitree.com/index.php?title=Special:DNATests&u=6063394&id=6";"list";3)

This will import the third list from  page 
http://www.wikitree.com/index.php?title=Special:DNATests&u=6063394&id=6

==> When Wikitree is updated the Google calc will retrieve the latest relation and check....

---

Version 3

1. Only list the living. This smaller list makes it easier to identify new profiles added to the list as they appear.
 

Use =IMPORTHTML and then filter the column on if values contain Living....

Video  https://youtu.be/jUYtj5MskVU

Access to data
I am doing a training called the semantic WEB and I start realising its not webpages we would like its access to data,,,
 

See video with the father of the WEB Tim Berners Lee who the last 15 years has been speaking about give us access to data over the web
http://minancestry.blogspot.se/2016/04/semantic-web.html

Good free training starting this week about semantic web

Introduction to Linked data and the Semantic WEB delivered by Southampton University

https://www.futurelearn.com/courses/linked-data/1/welcome

---

Best would be if we get a more intelligent data format like XML or Json....

<Wikitree>
  <user id="Roberts-12876”>
    <FFDetails>
       <user id=“Albury-152”>
          <PFirstname>Ada Ann</PFirstname>                       <LastNameAtBirth>Albury</LastNameAtBirth>
          <CurrentName>Albury</CurrentLastName>                  <BirthDate></BirthDate>

                                    …..

        </user>
        <user id=“Albury-574”>
           <PFirstname>Ada Ann</PFirstname
           <LastNameAtBirth>Albury</LastNameAtBirth>

            <CurrentName>Albury</CurrentLastName>

            <BirthDate>1953</BirthDate>

            <DeathDate>2015</DeathDate>                        ….

        </user>        

    </FFDetails>

    </user>

</Wikitree>

See Wikipedia article about Einstein
 

{
    "batchcomplete": "",
    "query": {
        "pages": {
            "736": {
                "pageid": 736,
                "ns": 0,
                "title": "Albert Einstein",
                "contentmodel": "wikitext",
                "pagelanguage": "en",
                "pagelanguagehtmlcode": "en",
                "pagelanguagedir": "ltr",
                "touched": "2016-04-14T10:38:10Z",
                "lastrevid": 714814514,
                "length": 133216
            }
        }
    }
}

Same article in XML

https://www.mediawiki.org/wiki/API:Data_formats

---

I wouldn't say JSON is more intelligent, it's just a different way of saving data ;-)

To me the intelligence is still sitting in front of the screen, not in the computer itself LOL

---

Re Andreas 

More intelligent because its structured...

Have a look on the next Web its a bigger step than WWW

If we in the Json data also could get location info and time period then displaying on a Google map and filter on time/surnames would be great...

If we could get result from gedmatch FTDNA in an intelligent format instead of just text .....

---

Magnus, I'm working with JSON every day and it's basically a flexible array of different types. Like I said not more intelligent than any other form you save data in. It's mostly used in document oriented databases like the NoSQL ones and in modern programming languages like Javascript (both which I use for my project).

I'm pretty sure that both FTDNA and GEDmatch are saving their data in a relational database, at least for GEDmatch I know when I had a discussion with the founders more than a year ago.

Ancestry would give you a better chance, they use MapR and a special graph-oriented NoSQL database.