* Pools

[JKC]

My one-name Coldwell study comprises several unconnected large sized trees, some medium sized trees ... down to couples and individuals. Total 17,000 persons. Groups of connected individuals are identified using Pool numbers (about 1600). I plan to do more study to associate some if not all Pools/Trees.
Please advise if there is a way to automatically identify the particular individual in a Pool for whom others in the Pool are descendants (i.e. the one at the top of the tree) to study if that person can be linked to another Pool (I may have to acquire some marriage certificates or similar to find out fathers names etc)
Alternately is there a way of doing such a study in a different way?

[DavidNewton]

I'm not familiar with the restrictions a one-name study places on a file, but in general I would say that a given relation pool is likely to have more than one tree top. A simple query should find them.

I am defining a tree-top as an individual with no parents in the file. So define a custom individual query 'TreeTops'
with columns: Individual, %INDI%; Pool Number, =RelationPool()
with rows: Add if %INDI.~FATH>% is null; Exclude unless %INDI.~MOTH>% is null

The result set will give you a list of tree tops alongside their pool number.

David

Added in Edit.
It occurs to me that you would probably want those with at least one child. If so then add an extra row.
exclude if %INDI.~CHIL[1]>% is null

[JKC]

Many thanks David
In my one-name study I do not record the parents of spouses who do not have the one-name. So such spouses appear in the result list for the TreeTops query. I tried removing the exclude clause from the row but the spouses remained in the list. Can you please suggest other clauses which would overcome this?
Incidentally most of the trees have usually only one tree top although it is a good idea to trap any with more than one.
The query ran without a problem but the second time it froze and I had to crash out my Windows 7. The third time was again OK.

[TimTreeby]

Depending on how many variants of the One Name you have the following should work fine, done with my Treeby/Treby ONS. Would just need to adjust for your ONS.

Top of Tree.PNG (5.13 KiB) Viewed 6506 times

So only adds if surname matches and then excludes if Father and Mother are both Null

[JKC]

Many Thanks

The filter works as expected, except:

Couples both with the one-name and one with no parents recorded show as tree-tops. These are small in number and can be dealt with manually.

There are several examples where the "Pool" function does not appear to have worked correctly. These are isolated individuals, couples and families with no connections to others in the same Pool. In this case I was expecting that these isolated cases would get their own unique Pool number. But they come out as tree-tops within the Pool. I am not sure how the Pool function works and if there is a way to refresh it to remove these anomalies.

[tatewise]

The Pool numbers are allocated automatically by FH and each related group with no connection to any other group will get a unique Pool number.

If you have doubts about the relationships of any Individual listed by this Query, then select that person and produce an All Relatives Diagram. That will display most if not all the Pool members with their relationships. I suspect you will discover some possibly 'rogue' connection that you were unaware of that has perhaps been created in error.

[JKC]

Please advise me. The “All Relatives Diagram” does what the name suggests and displays only the relatives of the individual shown at the top of the record box and the spouses shown in the lower part. So if for example the individual is a male with no recorded parents, one wife but no children there will be just two boxes in this diagram. However if the same wife remarries and you select her new husbands record you will see his parents, wife(s) and children although you will not see the first husband or any of his relatives. So there can be a range of the number of individuals shown in the diagram and it does not necessarily reflect the membership of a Pool.

I have run the Query to find the Tree Tops in a Pool. In Pool 1 of my one-name database I see 6 tree tops. Three of these are couples with the same one-name which I know are not excluded by the filter and have to be dealt with manually. The other three as seen in the “All Relatives Diagram” appear to be large independent trees all with the same Pool number (although I can only see relatives and not Pool members). I realise that these might be genuine tree tops within the same Pool but I suspect that may not be the case. Can you suggest a way to view all the individuals in a Pool to check if that is the case?

[tatewise]

Regarding the All Relatives diagram, where multiple marriages are involved, it may omit some members of the Pool, depending on who is chosen as the Root for the diagram. So you are correct that it may not display the entire Pool, but once you understand how it works, then it is feasible to discover all the members.

In the example you gave, if you select the wife who married twice, then the All Relatives diagram will show both husbands and any children. They all belong to the same Pool, because they are all related, albeit via marriage.

It is also often advantageous to select a family couple (whether married or not) as the Root for the diagram. So in your example, if you select the wife and 2nd husband, then both husbands, all parents, and all children are shown. See how_to:key_features_for_newcomers|> Key Features for Newcomers under Diagram Root Couples. I expect the 1st husband (with no parents) and any ancestors of 2nd husband (with no parents) will be listed as Tree Tops for the same Pool.

The general rule is that the All Relatives diagram includes all direct blood relatives of the Root individual/couple, and the spouses of those direct blood relatives, but NOT the parents or spouses of those spouses, because they are NOT blood relatives of the Root. There is Wish List Ref 501 Entire Pool Diagram that request that the entire Pool is included in a Diagram.

To discover which Individuals belong to which Pool, use the unfortunately named Search for Orphans standard Query that actually just lists everyone grouped into their Pool numbers.

[LornaCraig]

As an alternative to using the Search for Orphans query you can add a column for Pool Number in the Records window, if you have not already done so.

To do this, in the Records window (Individuals tab) right-click on any column heading and select Configure Columns. Scroll down to the bottom of the list on the left hand side and select <Other>. Then click the > arrow in the centre. Enter the heading 'Pool ' and the Exprssion =RelationPool()

The Pool numbers will then always be displayed and you can sort on the Pool column to group individuals by Pool number.

In your quest to link pools together, have you tried using Mike's Find Duplicate Individuals plugin? It may throw up a lot of false positives as you are doing a one-name study where many people have similar names, but it may be useful.