* Places and Addresses - best practice
Places and Addresses - best practice
I know there are some general guidelines on the uses of Places and Addresses in the Knowledge Base. So here is a test, what is the recommendation for an address as follows? i.e. which parts are stored as the Place and which as the Address?
1 High Street <- address
Little Hamlet <- address or place?
Village <- place
County <- place
St Mary's <- address
Village <- place
County <- place
The Jolly Sailor (PH) <- address
Hight Street <- address
Village <- place
County <- place
Specifically, should the address only include those parts of the location that are not included in the Place, i.e. with no duplication.
It might be partially personal preference, but what are the implications here, in reports , queries and screens?
Is a church name for example "St Mary's" stored separately or is it linked somewhere to the "place"or only on account of it being used in a Fact record?
Thanks,
Graham
1 High Street <- address
Little Hamlet <- address or place?
Village <- place
County <- place
St Mary's <- address
Village <- place
County <- place
The Jolly Sailor (PH) <- address
Hight Street <- address
Village <- place
County <- place
Specifically, should the address only include those parts of the location that are not included in the Place, i.e. with no duplication.
It might be partially personal preference, but what are the implications here, in reports , queries and screens?
Is a church name for example "St Mary's" stored separately or is it linked somewhere to the "place"or only on account of it being used in a Fact record?
Thanks,
Graham
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Places and Addresses - best practice
Graham, firstly a little housekeeping:
To save you telling us each time, could you please set your FH Version so it appears in the right-hand panel.
At the very top of this FHUG page click User Control Panel, then on the Profile tab select Family Historian Version at the bottom and click Submit.
As you say, these decisions are largely personal preference.
Have you reviewed the Forum Posts on Places and Addresses at the bottom of the glossary:places|> Places and Addresses page?
If you have chosen to use a Place fixed 3 column regime of say Village, County, Country then that dictates Little Hamlet must go in Address.
Whether there is any duplication in Place and Address is your choice and depends on how you use them, but database gurus say there should be no duplication.
Place and Address fields in this context are ONLY linked to their particular associated Fact.
The appearance of any 'database' suggested by the Tools > Work with Data is purely a temporary collated list composed by FH from all those separate fields.
There are relatively few implications on Reports, Queries, Diagrams, etc.
Addresses often have to be enabled in Reports as they are excluded by default.
FH V6 includes separate Place Records and Mapping of Places which changes some of the above perspective, but includes better support for comma separated columns in Place & Address fields, and for Narrative Sentence construction involving Place & Address fields.
To save you telling us each time, could you please set your FH Version so it appears in the right-hand panel.
At the very top of this FHUG page click User Control Panel, then on the Profile tab select Family Historian Version at the bottom and click Submit.
As you say, these decisions are largely personal preference.
Have you reviewed the Forum Posts on Places and Addresses at the bottom of the glossary:places|> Places and Addresses page?
If you have chosen to use a Place fixed 3 column regime of say Village, County, Country then that dictates Little Hamlet must go in Address.
Whether there is any duplication in Place and Address is your choice and depends on how you use them, but database gurus say there should be no duplication.
Place and Address fields in this context are ONLY linked to their particular associated Fact.
The appearance of any 'database' suggested by the Tools > Work with Data is purely a temporary collated list composed by FH from all those separate fields.
There are relatively few implications on Reports, Queries, Diagrams, etc.
Addresses often have to be enabled in Reports as they are excluded by default.
FH V6 includes separate Place Records and Mapping of Places which changes some of the above perspective, but includes better support for comma separated columns in Place & Address fields, and for Narrative Sentence construction involving Place & Address fields.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Places and Addresses - best practice
Thanks, a helpful reply. Graham 
- rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Re: Places and Addresses - best practice
Graham
I have asked a similar question previously and now use 4 columns for Address and 2 for Place.
Address is thus Suburb,Town/Village/Hamlet,County,Country. If there is no suburb, only a Town/Village/Hamlet, it is recorded as ,Town/Village/etc. and appears in Work with Data/Places as <blank>,Town/Village/etc.
Places is 2 columns - Street number,Street/Road. Again if the number is unknown it is ,Street/Road. This shows as <blank>,Street/Road in Work with Places.
Under this method, your examples would thus be:-
1,High Street
Little Hamlet,Village,County,Country
St. Mary's,
,Village,County,Country
The Jolly Sailor,High Street
,Village,County,Country
Individual Summary Report and Family Group Report do show the leading comma if the address is ,Village,County,Country, but the Narrative Report does not.
I find that this system works for me, and, hopefully, should work with FH6 Mapping (it does with FT Analyser Maps).
It is just a case of remembering when to include the commas when inputting Places and Addresses (especially with AS).
Good Luck
Roger
I have asked a similar question previously and now use 4 columns for Address and 2 for Place.
Address is thus Suburb,Town/Village/Hamlet,County,Country. If there is no suburb, only a Town/Village/Hamlet, it is recorded as ,Town/Village/etc. and appears in Work with Data/Places as <blank>,Town/Village/etc.
Places is 2 columns - Street number,Street/Road. Again if the number is unknown it is ,Street/Road. This shows as <blank>,Street/Road in Work with Places.
Under this method, your examples would thus be:-
1,High Street
Little Hamlet,Village,County,Country
St. Mary's,
,Village,County,Country
The Jolly Sailor,High Street
,Village,County,Country
Individual Summary Report and Family Group Report do show the leading comma if the address is ,Village,County,Country, but the Narrative Report does not.
I find that this system works for me, and, hopefully, should work with FH6 Mapping (it does with FT Analyser Maps).
It is just a case of remembering when to include the commas when inputting Places and Addresses (especially with AS).
Good Luck
Roger
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Places and Addresses - best practice
Roger, maybe it is my misunderstanding, but you appear to have your Address and Place descriptions back to front?
i.e.
Did you mean to say: "4 columns for Place and 2 for Address" with appropriate changes for the Work with Data commands as you mention Places twice?
Note tha FH V6 only maps Place records, not Addresses.
i.e.
Did you mean to say: "4 columns for Place and 2 for Address" with appropriate changes for the Work with Data commands as you mention Places twice?
Note tha FH V6 only maps Place records, not Addresses.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- rodit
- Famous
- Posts: 228
- Joined: 02 Feb 2008 02:39
- Family Historian: V7
- Location: Wollongong, New South Wales, Australia
Re: Places and Addresses - best practice
Thanks Mike
My booboo. Yes as you suggest I have 4 column Places and 2 column Addresses.
Roger
My booboo. Yes as you suggest I have 4 column Places and 2 column Addresses.
Roger
Re: Places and Addresses - best practice
Thanks for the info; I have been tidying up my database after installing Ft analyser and finding a few problems. I have changed 900+ Individuals address/place details to the method recommended by rodit. The only good thing about doing it was it kept me busy over the Christmas break - about 3 days solid!
The maps are a lot better in the Ft analyser timeline etc. now.
The maps are a lot better in the Ft analyser timeline etc. now.
Re: Places and Addresses - best practice
I have just upgraded to v6 and am also trying to sort out all of my addresses could anyone please suggest best practice for the following please.
I have a person who is very easy to plot on the map in terms of baptism and census etc and can plot him to specific streets, I have his burial in the local cemetery but I don't have his death certificate so I only have the registration district of where he died and so have the registration district as his death address/place. As the registration districts cover wide areas with no definable central point could anyone please suggest where I could plot his death. If I assume that this particular person died near the local cemetery and move his death marker to the cemetery I think it would mean all other deaths in that registration district would also be plotted there - other people may have lived /died 20 miles away. Can anyone please suggest a solution other that actually getting the death certificate.
Many thanks
Jenny
I have a person who is very easy to plot on the map in terms of baptism and census etc and can plot him to specific streets, I have his burial in the local cemetery but I don't have his death certificate so I only have the registration district of where he died and so have the registration district as his death address/place. As the registration districts cover wide areas with no definable central point could anyone please suggest where I could plot his death. If I assume that this particular person died near the local cemetery and move his death marker to the cemetery I think it would mean all other deaths in that registration district would also be plotted there - other people may have lived /died 20 miles away. Can anyone please suggest a solution other that actually getting the death certificate.
Many thanks
Jenny
- tatewise
- Megastar
- Posts: 27078
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Places and Addresses - best practice
You have to use a different Place name for that specific Death Event.
For example, add the Cemetery address and perhaps prefix it with ~ to indicate it is approximate.
You will have to adopt a similar scheme for every single Place name for which you want to similarly adjust their plot marker.
For example, add the Cemetery address and perhaps prefix it with ~ to indicate it is approximate.
You will have to adopt a similar scheme for every single Place name for which you want to similarly adjust their plot marker.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Places and Addresses - best practice
many thanks i'll give it a try.
Jenny
Jenny