GenoPro Home
GenoPro Home  |  Get Started With My Genealogy Tree  |  Buy  |  Login  |  Privacy  |  Search  |  Site Map
 

GenoPro Support Forum




Is there a way to make a graph of a village's population?

Click to view RSS...
Author
Posted Monday, March 16, 2015 - Post #34778
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
I'm doing a one-place study for two small villages, and will hopefully have all the residents from 1828 until now, at some point.

Is there a way to create a graph (x= year, y =population) of the residents in each village?

Thanks in advance
Posted Monday, March 16, 2015 - Post #34781
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 11:44 AM
Posts: 3,337, Visits: 25,587
Easiest way would be to write a small Report skin template to create a csv file with year and calculated population fields and run this skin against each village genomap (or each village .gno if held in separate files).  
You can then use your favourite spreadsheet software to produce the graphs from the csv files.

Happy to help with this further if required.  You would of course need to know when each person lived the village e.g. born in village? died in village? moved into village? moved away from village? Essentially you would need occupancy data for each person. 


'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
Posted Tuesday, March 17, 2015 - Post #34785
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
Ok, great :-)

I have one large file with about 3,000 people in it (alive and dead).  There are about 70 genomaps in that file, one for each major family.  Some people were born, lived, and died in the village.  Some moved to a larger city, and others emigrated to another country.

Would there be a way to show where the emigrants lived, and their descendants? While ignoring the non-village spouses and their ancestors?  Or would this be too complicated?

For example, girl X was born in the village and lived there till she was 18 .. moved to a larger city .. met a man from another village, married, and emigrated to the US, or Canada, where they had say 3 kids.  The man and his parents are also in the tree, but I'd prefer not to count them.

Sample CSV output?
Year ... Village ...  City...  US/Canada
Up till she's 18 ... 1 .. 0 .. 0 .. in village
18 ... 0 ... 1 ..0 ... in city
Marries .. 0 .. 1... 0
Emigrates .. 0 .. 0 .. 1
Has kid 1 .. 0 .. 0 .. 2
Has kid 2 .. 0 .. 0 .. 3
Has kid 3 .. 0 .. 0   4

Would this be possible? or too cumbersome/complicated?
Posted Tuesday, March 17, 2015 - Post #34791
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 11:44 AM
Posts: 3,337, Visits: 25,587
Tracking descendants in that way could get complicated. I was asuming that the skin would calculate the yearly totals for nominated places (e.g. the two villages) 

the CSV would be simply

Place, Year, Count

e.g.

Place, Year, Count
village1, 1828,20
village1, 1829,22
..
..
village1, 2014,301
village2,1828,54
village2,1829,54
..
,,
village2,2014,967

thus providing a solution to your original requirement.

Even for this approach the data would need to be complete for all individuals, e.g. birth date present in nominated place and still alive,birth and death dates present for same nominated place, birth in nominated place and contact/occupancy record indicating emigration, contact/occupancy for nominated place and death in same place or still alive indicating immigration.





'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
Posted Tuesday, March 17, 2015 - Post #34793
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
Ok cool. Would it be possible to change the output to be:

Year, village 1 count, village 2 count
1810,  50,  40
1811,  51,  41
Etc

I could create a chart in Excel in no time with that format, but it would be a pain rearranging all the data, unless there's some elegant intermediate step I'm not aware of.

I imagine it's easier to generate the csv file with a year by year pass?

If it's too difficult to create the above format, I'd love a report that generates the population for one village, and then just re-run it for the second, and copy/paste the results together in Excel.
Posted Tuesday, March 31, 2015 - Post #34854
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 11:44 AM
Posts: 3,337, Visits: 25,587
As usual, nothing is ever as simple as it first seems, however have now got a Report skin together (see updated attachment in later post) that produces population counts for nominated places. Counts of births, deaths, immigrations and emigrations also included.

CSV file Header (called 'population.csv') is:

Year,Place0,Population0,Births0,Deaths0,Incoming0,Outgoing0,Place1,Population1,Births1,Deaths1,Incoming1,Outgoing1 ...etc...

Done some testing and seems to work OK but no guarantees so do your own tests!

Of course data needs to be complete to produce anything useful, e.g. date and place of birth and death, date and place of all 'occupancies/residencies' in the lives of the individuals concerned.

Might be useful to adapt this skin to track counts of people in particular families in all the places they crop up in.


'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"


Edited: Saturday, April 4, 2015 by genome
Posted Thursday, April 2, 2015 - Post #34866
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
Wow .. you are awesome .. I will try it out and let you know how it works :-) .. Thank you so much!!
Posted Friday, April 3, 2015 - Post #34869
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
Wow, that works great ... Thank you so much!  Thank you for making it so easy to include multiple locations :-)

Would there be any way to include a list of names of which people are included in the population counts?  Or do you have another suggestion on how I can keep track of who's location history has been input?  I tend to start and stop my genealogy research, so it would be nice to easily check who I've completely input, and who I haven't.

I assume the count is of the first of each year?

Thank you in advance!
Posted Friday, April 3, 2015 - Post #34870
Legendary Master

Legendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary MasterLegendary Master

Administrators
Customers
Important Contributors
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 11:44 AM
Posts: 3,337, Visits: 25,587
I assume the count is of the first of each year?

A counter is incremented when an event occurs within that year, so e.g. if born on 31st Dec 1903, 1 is added to population and birth count for 1903, even though only one day left in year.

As to checking who has contributed to the data, I suggest you add an Individual Custom Tag and use it as a marker to manually keep check.  The script could easily be amended to output say ID, dates,name and place to Report Log for cross checking your markers. 

e.g. after line 15 in stats.js put the line

Report.LogComment(obj.ID + ' ' + start + '-' + end + ' ' + obj.Name + ' @ ' + places[place]);


p.s. if you open the output file population.csv with MS Excel non ASCII place names will look strange as it stupidly does not recognise it as being UTF-8 encoded as GenoPro does not put a BOM (byte order mark) at the start of the file. Just open the file with Notepad and save it again to add the BOM and Excel will be happy Smile


'lego audio video erro ergo disco' or "I read, I listen, I watch, I make mistakes, therefore I learn"
Posted Saturday, April 4, 2015 - Post #34871
Famous Writer

Famous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous WriterFamous Writer

Customers
FamilyTrees.GenoPro.com
GenoPro version: 3.1.0.1

Last Login: Yesterday @ 10:29 AM
Posts: 251, Visits: 1,670
Thank you for the added explanations :-)

I'm editing stats.js with Notepad, and it doesn't provide the line count.  I entered the line you provided after what I thought the 15th line was, but the output did not change.  Can you provide a bit more context as to where that line should go?

Thank you also for the suggestion to include an Individual Custom Tag.


Similar Topics

Click to view RSS...
Expand / Collapse

Reading This Topic

Expand / Collapse