Latitude and longitude data are included in the SQL TMS database in the table TermMasterGeo, though they are not accessible within TMS GeographyXrefs or the TMSThesaurus Manager for TGN entries. Why that is, I do not know. The following query will show you this data: SELECT T.TermID, T.Term, TMG.Latitude, TMG.Longitude, LatitudeDirection, LongitudeDirection, LatitudeNumber, LongitudeNumber SELECT FROM Terms T INNER JOIN TermMasterGeo TMG ON T.TermMasterID = TMG.TermMasterID WHERE T.Term LIKE 'Cambodia' To get: TermID Term Latitude Longitude LatitudeDirection LongitudeDirection LatitudeNumber LongitudeNumber 1887010 Cambodia 13 00 105 00 N E 13.0000 105.0000 But to use it you will must choose either the decimal version (Latitude.Number, Longitude.Number), or concatenate the Latitude and Longitude fields with the Lat/Long direction field: SELECT T.TermID, T.Term, TMG.Latitude + ' ' + LatitudeDirection AS Latitude, TMG.Longitude + ' ' + TMG.LongitudeDirection AS Longitude FROM Terms T INNER JOIN TermMasterGeo TMG ON T.TermMasterID = TMG.TermMasterID WHERE T.Term LIKE 'Cambodia' To get: TermID Term Latitude Longitude 1887010 Cambodia 13 00 N 105 00 E You'll see the SQL degrees/minutes format doesn't completely match what the TGN displays online: Coordinates: Lat: 13 00 00 N degrees minutes Lat: 13.0000 decimal degrees Long: 105 00 00 E degrees minutes Long: 105.0000 decimal degrees Be careful with Lat/Long - a miss is as good as a mile, or more! Jeffrey Smith Assistant Registrar for Collections Information Collections Department Freer Gallery of Art and Arthur M. Sackler Gallery Smithsonian Institution -----Original Message----- From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Sally Fletcher Sent: Sunday, September 26, 2021 11:29 PM To: ListServ tmsusers <[log in to unmask]> Subject: Adding latitude and longitude data to Thes of Geographic Names Hello TMS users I have added a new concept place name to the Thesaurus of Geographic Names but I can’t see how to add latitude and longitude and related data to this concept. Can anyone tell me how to do this through the thesaurus manager? If not possible through the thesaurus manager, does anyone have a script to add this data through SQL? We are currently using TMS2018 (version 9.70). Thank you for any help, Sally To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.