* How to list all place details for a selected city

[E Wilcock]

This is not a new question but the former thread is locked and the replies provided there by Jane and Mike are baffling to me as a new user.

I need to print out a list of all the addresses in e.g. Adelaide, including grave references in cemeteries there. It would be useful to have by each one the name of the individual linked to that address and name of event too. But I can go through jotting in the names - It is a filtered list of places I want.

Jane's solution on the previous closed thread answering someone who wanted a list of places in Bristol, was to run a query which contains text - I went to the view menu. Standard query. I chose Contains text Adelaide and got a list of people, but I have no idea how to deal with the column and row options to produce a report that shows me all place fields. (That method will have duplicate entries for some addresses and also collected any women with the name Adelaide. No matter.)

Mike's instructions could be followed only if I left the standard query and created a named custom query. Having done that and named it, I cant locate it again to edit the columns and rows following his instructions. A search of the help file seemed to yield no clue where custom queries might be stored.

The problem for me with Family Historian is that one can do things - but it is very hard to find out how - I can find nothing on the Help or on line about how to make a list of selected places. And often the techniques involve unfamiliar symbols like % signs.

I should be very grateful for some simple help - starting at the beginning. I didnt know how to run a query? And if a query is in the view menu, it is hardly surprising that I cant print out the results.

Or is it that there is now a report on places which I cant find? Surely when one visits a strange town, going round to see any houses with family connections is one of the things that most family historians will want to do.

Evelyn

[PeterR]

I have a Custom Fact Query called Place Contains Text which you might find useful; you can click on the Place column heading to sort by Place.

[E Wilcock]

Peter - Thank you so much. It is perfect.

I downloaded your file and didnt know what to do with it!

However, the letters .fhq on your file, gave me a clue. I made a Windows 7 search to discover where the rest of the FH queries xxx.fhq files including my own might be stored. So I found all of them.

I moved your file into the correct folder of custom queries, then once it was there, I twigged that there was a separate custom queries option on the drop down list under view.

I guess when there were no custom queries at all, (my being a new user) that might not have shown up.

Anyway, I ran your query and it worked a treat. It is just what I need.

I have given the details here in case anyone as ignorant and frustrated as me, has the same question. But I am really glad to have it. Thank you so much.

Evelyn

[LornaCraig]

Evelyn,

There is also a standard query that you might find useful, called Events Near Place. This enables you to select a place from the list of those used in your file, and specifiy a distance in miles. The result set includes all events at places within that radius. You could save this as a custom query and add another column for address. I assume it relies on your having accurate geocoding for all the Places in your file, so unless you have checked the automatic geocoding done by FH the query results may not be very reliable.

By the way, to see a full list of all queries (standard and custom integrated in one list), open the Query window by clicking on the icon in the toolbar just left of the red map-pin icon. The field at the top labelled Query has a drop-down list of all queries. You will need to scroll down to see them all.

[E Wilcock]

Lorna - Thank you. This is a follow up query about vocabulary. Place versus Address?

I was under the impression that in a GEDCOM or genealogy software, Address is a term used for a Fact or Event containing the information about current contact address, e-mail etc for living people and other researchers. I dont use it except to provide the address of archives in source records.

In my family data I use Residence to show where people lived. Residence with dates will have information in Place fields but no "address".

In FH the terminology may be different?

I am a TMG user learning how to do things in FH and I have not mapped out my places. Some months ago I failed when a Yorkshire town where one family lived showed up on the map at a location miles away from where it should be. I will eventually try again - but that would be another thread.

[tatewise]

Evelyn, here are a few tips and clarifications.

The View > Custom Queries command definitely exists even when no Custom Queries, but it just shows <empty> greyed-out.

When you clicked on PeterR's ATTACHMENT it should have offered to Open the file in Family Historian to install the Custom Query.
Alternatively, if you Saved the file, to install that Query into FH just Open the .fhq file, or double-click it, or use File > Import/Export > Import > Query... and browse to the saved .fhq file.

In FH use Help > Search Help... enter "Custom Query" including the quotes in the search box and click List Topics to obtain a handful of related topics that mention most of the above options.

"Getting the Most From Family Historain 5" devotes Chapters 13 & 14 to Queries.

In the FHUG [kb]|[/kb] enter Custom Query in the Search box and follow the links.

BTW: View > Standard/Custom Diagram Types and Publish > Custom Reports are similar.

[tatewise]

There is an explanation in how_to:key_features_for_newcomers|> Key Features for Newcomers about how GEDCOM defines glossary:places|> Places and Addresses.

In Facts they refer to the Place & Address of the event, but in Source Repositories the Address provides contact details.

There are many, many discussions about how to use Place & Address fields in the Forums (some are listed in the KB page above), but the overriding advice is to be consistent throughout your database having decided how you wish to use them. Many users like to format those fields into organised columns so that they can be listed and sorted by column part in Tools > Work with Data > Places and Addresses.

[LornaCraig]

Sorry Evelyn, in your first post you said "I need to print out a list of all the addresses in e.g. Adelaide", so I assumed you meant that each Place (e.g. Adelaide) had several Addresses associated with it. That's why I suggested adding a column for Address to the Events near Place query. If the full address is entered in the Place field each counts as a separate Place.

As Mike says, the main thing is to be consistent in the way you use the fields. As you have brought an existing database over from TMG it is probably easier to leave things as they are but it is worth looking at the links Mike referred to so that you are aware of the options.

[tatewise]

I have just reviewed the Help for TMG, and I think I see where the confusion may exist.

TMG has Event tag types that record Place details (but not Address details), so GEDCOM Event Addresses in FH will be a new concept.

TMG also has "The Address tag type used to record an individual's mailing address. This is distinct from a Residence tag type, which is used to record information about where a person lived in the past. There may be many Residence tags for any person, but there will ordinarily be only one Address tag for a living person." So the Address tag is a custom extension to GEDCOM quite distinct from the standard Residence tag, and the standard Event Address field.