The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
How to create a heat map from Lattitude and Longitude data?
Contributor I
Dear all,
I have a data collection with DateTime, ObjectId, Lat, Long, Amount, Speed. I want to create a dashboard that a user can input Date1 until Date2, then the heat map shows where objects are mostly located in that period of time.
My second question: how to query my Amount data grouped by month (Year-over-year or you) then make a prediction. For example: April 2010, April 2011, April 2012..2020, then how much is the total Amount for April 2021.
Thank you very much in advance.
Warmest Regards,
Suryadi
I have a data collection with DateTime, ObjectId, Lat, Long, Amount, Speed. I want to create a dashboard that a user can input Date1 until Date2, then the heat map shows where objects are mostly located in that period of time.
My second question: how to query my Amount data grouped by month (Year-over-year or you) then make a prediction. For example: April 2010, April 2011, April 2012..2020, then how much is the total Amount for April 2021.
Thank you very much in advance.
Warmest Regards,
Suryadi
0
Best Answer
-
BalazsBarany
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Dear Suryadi,
do you have access to AI Hub, or just RapidMiner Studio?
Here's an older blog entry for visualizing geodata in AI Hub (RM Server) web apps. It involves some HTML and JavaScript.
In Studio there's no support for this kind of visualisation if you want to overlay an actual map.
If you just want to display the coordinates on a scatterplot without the map, that's possible. For the heatmap I would aggregate by rounding the coordinates and determining the number of values in that cell. You could also experiment with bubble plots where you can control the size of the circles and also their color.
The second question is a forecasting problem. You could experiment with the Auto Forecasting operator. You just put the montly sums into it and get a prediction for the next few months. If you want to have more control over the process, see the Time Series Analytics course in the Academy.
Regards,
Balázs2
