I would like to create a heatmap of events vs locations, and have it overlaid on a real global geographical map.
Has anyone ever attempted something like that, or know of another app where I could load the appropraite data to get the same result?
I did something along these lines a few years ago that might still work.
1 Like
And this Discourse platform’s AI assisted Related Topics pops out this response from @KimberlyGreen who is deep into using maps to assist her research.
1 Like
GEDMINER will give info on “Migration” (such as England to New York). THis can be interesting to look at especially for patterns – but not what you are looking for.
You can display info on places using Power BI using the map functions.
1 Like
Ahhhh the AI monster’s found me 
Thanks for the mention @TomH .
A quick note: Google Earth Pro desktop app downloads are being shuttered after June 2027. They are shifting users to their web-based product. The desk app will purportedly still work after that. But knowing Google’s habit of discontinuing products, I don’t trust that it’ll work much longer afterwards. And the web-based version is less feature-rich.
For that reason I’m shifting my workflow over to ESRI ArcGIS Earth.
My existing Google Maps “Places” KML file imported just fine. Now I’m just getting used to the different interface.
2 Likes
Thank you everyone. You got me to thinkin’ (likely a bad thing), and I discovered a thing I haven’t really dug into yet. Supposedly it is Free, but apparently stays online… It’s called https://mapline.com/… If any of you have experience with that, I’d love feedback on working with RM data
Power Bi is free but would require a dataconnector to RM database to read places data
1 Like
There is a feature in Excel to plot data on a map. I’ve had a dabble with it and got some results but the solutions offered by some other replies might be more eloquent. One hurdle is to get the data out of RM in the first place. I don’t do this sort of thing every day so it needed me to do a bit of learning to get there.
Some of the initial results I got are on my One-Name study at Kerfoot - Stats & Maps
I’ll be looking at the other tools mentioned in this thread so thanks for asking the question.
3 Likes
Adam, I absolutely love the maps & charts you’ve done. That is exactlythe goal I was looking tio solve…
Excel you say? Getting the proper data out of RM11 in the first place is no issue for me; I use SQL. I’d love, however, to know how you were able to get from Excel to the mapped presentations…
I’ve now got Power BI Desktop on my PC, and it’s SQLite ODBC driver. Thank you. I’ll be working my way through that for the next while…
1 Like
Thank you. Just downloaded ArcGIS… Looks robust.
1 Like
In the insert ribbon, there is a section called Tour. It’s right at the far end of the ribbon for me and there’s just one button in there called 3D Map. Don’t confuse it with the charts section, where there is a Maps option, but that’s not it.
When you click on 3D Map it opens a new window where you can select the data to use and the type of map and other display options. The data in your sheet has to contain Latitude and Longitude data but Excel seems to find that of its own accord if it’s there, present in the sheet.
The Microsoft help page is at Get started with 3D Maps | Microsoft Support
They explain it all better than I can.
Good luck and I hope it produces what you want.
1 Like