Exploring a possible utility to standardize place names
For the most part, I have adopted the FamilySearch standard names in my work. I find they work well for international place names, and in multiple languages, both of which are important to me.
I'm thinking of creating a utility that will use the place names in RM to search for their FS standard names and place ID specifying a language and time period.
I don't think that it can be fully automatic as a search often returns multiple names.
I would probably use a "sidecar" pattern, so that the utility would create and update an auxiliary places table and leave the RM PlaesTable alone, until a command is given to swap the existing place names in the RM PlaceTable with the AuxPlaceTable names, or some such mechanism.
I just found out about the FS API to its place database and it worked well in some tests in Python.
Any interest or comment?
Richard Otter
Just noticed that the PlacesTable already has a column named fsID.
Personally, I am not comfortable with python. I have intermediate skills with Power Query, Excel, and Power BI, also SQLITE.
Yes I would be interested.
Kevin\