Stack Overflow
Stack Overflow

Questions tagged [genealogy]

Genealogy is the study of families and the tracing of their lineages and history.

Use of oral traditions, historical records, genetic analysis, and other records to obtain information about a family and to demonstrate kinship and pedigrees of its members. The results are often displayed in charts or written as narratives. (From Wikipedia)

Questions about programming genealogy software should be asked in Stack Overflow. But questions about genealogy in general should be asked in the Genealogy and Family History Stack Exchange.

61 questions
1
vote
2 answers

Approach for storing circa and actual dates in genealogy data model

I am developing a geneology application, and I have a need to store dates for events. However I need to be able to support circa dates and actual dates, so I am thinking of having evendate and ceventdate (for the circa) columns so that I can index…
Stephen Senkomago Musoke
  • 3,528
  • 2
  • 29
  • 27
1
vote
2 answers

Does any one knows about Family Tree using AJAX?

Does any one know about any script that will work like http://www.genoom.com family tree? Or can you guys give me any ideas about the database table structure they used to make the tree like this? And how are they displaying family member boxes…
Deb
  • 19
  • 2
1
vote
2 answers

Relative dates in Semantic Mediawiki?

Is there a way in Semantic Mediawiki to store and use relative dates? I would like to store genealogical data in Semantic Mediawiki and there is sometimes information like: »On January 10th 2021 John, son of the deceased Jack, married Mary.« Now I…
felleb
  • 23
  • 4
1
vote
0 answers

How to convert text in ANSEL to UTF-8 in php

I have a php script working with GEDCOM files, which are often using ANSEL encoding. I did not found any solution to convert them properly to UTF-8 charset. Is there a way using for example iconv or I have to make my own solution as suggested here…
Jan Potužník
  • 112
  • 8
1
vote
1 answer

Prolog "Not Enough Stack" Error

I'm writing a genealogy program in Prolog. Here are my rules: father(X,Y):-male(X),parent(X,Y). mother(X,Y):-female(X),parent(X,Y). parent(X, Y) :- father(X, Y). parent(X, Y) :- mother(X,…
small502
  • 43
  • 1
  • 5
1
vote
1 answer

Neo4J/Cypher : variable length of path pattern

I model a genealogy on a graph in Neo4J inspired by GEDCOM file. My nodes and relations are : Individual <-[CHILD]- Family Family -[HUSBAND]-> Individual Family -[WIFE]-> Individual I don't model the family as a relation because i can have multiple…
Cedric Lecocq
  • 83
  • 7
1
vote
1 answer

binary tree implementation in php and mysql(genealogy)

I am trying to do an MLM project in PHP. Now I'm stuck on the binary tree representation of MLM. Please help me to implement the tree.sample tree structre. Please help me to build a tree-like on the attached image. Sample tree structre
Jibin Prabhakar
  • 11
  • 4
1
vote
1 answer

Neo4j cypher query with differing relationship based on gender

In genealogy we use DNA to find matches. Y-DNA finds patrilineal matches. A neo4j query (where RN is a unique identifier for a person) that does this is: MATCH (n{RN:1}) match p=n-[r:father*..22]->m return m.RN as RN,m.fullname as FullName,m.sex as…
David A Stumpf
  • 753
  • 5
  • 13
1
vote
2 answers

child-parent geneology - table of the other parent

I have a table called "child_parent" which lists ID's of children and their parents, referring to, say, a table called "person". The child-parent pair are unique, and a child can have no more than two parents. child parent 3 1 3 2 4 …
Paul R.
  • 111
  • 2
1
vote
3 answers

How would one create a Drupal-based Genealogy Application?

I want to use Drupal for building a Genealogy application. The difficulty, I see, is in allowing users to upload a gedcom file and for it to be parsed and then from that data, various Drupal nodes would be created. Nodes in Drupal are content…
Bruce Whealton
  • 1,051
  • 2
  • 14
  • 25
1
vote
3 answers

Select all genealogy of a father in SQL without WITH or WHILE

Is it possibile to select all childs of a parent without recursive system as WITH or WHILE? The structure is: Father Child NULL 1 1 2 1 3 2 4 3 5 4 6 6 7 I want the "childs" (all genealogy, childs of childs,…
Laurianti
  • 903
  • 1
  • 5
  • 19
1
vote
1 answer

Family Tree in Silverlight

Hello Currently I am working on a project in which I have to create family tree. It will have almostn number of hierarchy. Whole tree should be displayed to user as well as zoom in zoom out facility should also be there . Scrolling is required.At a…
Radhi
  • 6,289
  • 15
  • 47
  • 68
0
votes
0 answers

How to add text on the branch of a pedigree tree in R? Or what other software?

I am trying to obtain a pedigree tree to visualise the relationships between Wolf individuals. I tried with the pedigree function of the kinship2 package. Here is my data and what I obtained from it: > fakefam sexID packOrigin Mother Father sex…
Inès Moreno
  • 53
  • 4
0
votes
0 answers

Family tree relationship calculation

This is the structure of my family graph I tried solving this with the commonly used Least Common Ancestor algorithm and was successful to some extent. The algorithm can find relationships having common ancestors like 3 and 8 and 1 and 8 However…
Anchovy
  • 103
  • 3
0
votes
0 answers

MySQL | How do I find the relationship (genealogy) between multiple IDs in the same column

Hello and thank you for taking time to assist me. I am trying to calculate a new column for my table using MySQL and could really use some help. I have a genealogy table with a column for a parent id and its associated child id. A component_id can…
YeetCode
  • 11
  • 1
1 2
3
4 5