* Need help making a query

[bubbalicious]

Things with FH have been going swimmingly since I last posted for help! Yay!

But here's my conundrum: I've noticed when putting in death certificate info (still playing catch-up with that) that when info was brought over from RM7 to FH6, the place/address fields for burial are inverted in FH6 because I also put in burial info when inputting death cert info (most of the time).

Here's an example of burial I've run across:
Place: Philadelphia, Philadelphia, Pennsylvania, United States
Address: Greenmount Cemetery

Here's what I've changed it to when I've run across it:
Place: Greenmount Cemetery
Address: Philadelphia, Philadelphia, Pennsylvania, United States

Granted, the above example is just an example, as there are many place/addresses people were buried, most of the time. But there are also many family members that were buried in the same cemetery, so once I've changed those fields it starts filling in the field automatically on others when I go to change them.

Is there a query that can be run to find this inversion issue? I have no clue on queries or how to write them, but I'm thinking that I need to find an "address" field that has the word "Cemetery" in it and go from there and make a "where used" report with that plug-in.

Thank you all for your excellent help! I appreciate your expertise.

Nikki Heffner

[ColeValleyGirl]

Two comments.

1. Can you clarify how you use Place and Address? The way I use them,

Place: Philadelphia, Philadelphia, Pennsylvania, United States
Address: Greenmount Cemetery

is correct.

From glossary:places#gedcom_definition|> GEDCOM Definition:

GEDCOM Field Name PLAC

PLACE_VALUE = "The jurisdictional name of the place where the event took place…"

GEDCOM Field Name ADDR

ADDRESS_STRUCTURE = "The address structure should be formed as it would appear on a mailing label…"

However, you may have standardised on a different approach.

2. You may find you don't need a query -- I would try the Edit > Find menu action first.

[bubbalicious]

Thank you, CVG, for your quick reply!

I think you've got it backwards, though, on how I'm inputting the place/address. But no matter because according to the Gedcom definition you included for both, I think I'm doing it correctly. To me, it makes sense that the place=the name of the cemetery and the address=the actual city the cemetery is located.

I'll try your suggestion of Edit>Find and see how it goes. Will post again if need be.

Nikki

[bubbalicious]

CVG--

I just did your Edit>Find and it worked!!!!!!!!! I put in just the word "Cemetery" to find, unchecked all the boxes except "Address" and did the report. I created the csv, brought it up and saved it as an Excel-->Libre Office file, checked the first name on the list and by golly, it's gotta be changed!! So that means all the other 689 names in the report will have to be changed also but at least now I know who I've gotta change. Sweet!

I can't thank you enough! I knew there were a lot to change, I just didn't know how to find them unless I just happened to run across them when inputting other information.
Nikki

[ColeValleyGirl]

Nikki,

No, I understood how you're using them -- it just isn't a common way of using them. However, we've had many discussions on this forum about the topic and there are loads of different ways of doing things.

For example, I put everything in Place and ignore Address.

[ColeValleyGirl]

Have a look at the Rearrange Place and Address Parts Plugin -- you can select specific entries for it to operate on, and do the thing en masse. As always BACKUP first just in case things go wrong!

[bubbalicious]

Thank you for that "Rearrange Place...." suggestion. Chances are, I won't be doing that because there's more info to put in on these names, so it's yet another list of things to look at when in FH , but at least I know about going that route . The list created is in record ID order but that could be changed if I wanted to a sort order by name. Whatever, and may be unnecessary because I can always do a "find" in the spreadsheet.

Thank you again!
Nikki

P.S. In case anybody here might be wondering about reports I'm talking about -- I created reports from my dual-pane browser (xplorer2 Pro) which is very easily done by selecting a file name (or names), doing a Ctrl+P and then pasting the resulting file name/date created/date modified info into a Libre Office spreadsheet. It's the only possible way to keep track of the death certificates (or anything else) I need to put into the program without tearing my hair out and going "did I put that in yet?" Logically, it's the only way to keep track, and the same method will be used for the "place/address" cemetery report. Then in the "Put in FH column" I can put in an "x" and know it's been done.

[LornaCraig]

Nikki,

As Helen has said, there are many ways of doing things and if your method works for you that's fine, as long as you are consistent in your approach.

But before you go too far down the route of using the Place field purely for a cemetery name (or perhaps a building name), you might want to consider the implications for geocoding of Places. If you look at the Places tab of the Records window you will find that you have a lot of Places which are just cemetery names, or perhaps Church names. It's unlikely that many of these can be geocoded automatically, particularly as many cemeteries and churches around the world have the same name but are in different 'places'. And while a unique cemetery name could be geocoded manually what will you do if you later discover a burial in a different cemetery which happens to have the same name?

Have you used the Map window in FH at all yet? If you don't think you will ever want to, that's not a problem.

[tatewise]

If I can throw in my pennyworth along similar lines...
The reason why the data came over from RootsMagic7 the way it did is that is the usual convention.
i.e. The same way that CVG has suggested.

The Place is usually the town, county, country where-about the event happened.
The Address is usually a precise building, cemetery, house, street, zip code needed to complete the location.
Both Place and Address auto-complete in the same way.
(BTW: If there is more than one Greenmount Cemetery then there is a workaround to differentiate them.)

Bear in mind that if you wish to automatically geolocate the latitude/longitude then in FH that only works on the Place field.

See glossary:places|> Places and Addresses for more detailed advice.

However, we all may have different ways of working as long as it is consistent.

[bubbalicious]

Thank you, Lorna and Tatewise! You are fountains of information, as are the other previous posters with replies.

At this point, I have no plans to do the geocoding. And I suppose if I ever did, I could do yet another handy-dandy Edit>Find and change these two fields again (and that would be if I don't have anything else in the world to do!!).

I am going to take a screenshot of this whole posting, though, just in case I need to refer to it in the future.

Thanks for all your help, everybody!

Nikki