Kelpler.gl is a Geospatial data analysis by Uber !!!, in this short blog we show how to build a map with a time attribute and then showing a time playback slider, it is very and straightforward process, all you need is to format the data as a list.
This data was randomized, as an example I show the main step to build a solar farm, piling, tracker, module then Electrical works, but obviously you can try it with road , pipeline projects, any project really that have geographic data
Please note the data is rendered using your local computer, so it is totally safe
The map is here, keep reading if you want to understand how it was built
I attached a sample dataset here; the field are self-explanatory.
Just be careful with Excel for some reason, when you open the csv file, it changes the date format, make sure the format is like this
And because in a medium sized solar farm, the total pile will be around 50,000 Piles, if you want just to show 4 main stages, the total number of rows will be 50,000 * 4 = 200,000 row, PowerBI will not support that ( Tableau shine in this scenario),
The documentation is very clear, please read it to experiment with your own data
- Add data
If your dataset has this fields names X_lat, X_lng, Kepler.gl will automatically recognised it as a point layer
2-Define the legend
We select colour based on the field status ( select the palette of colour)
3- Select time field
The filed should be recognized as time otherwise, it will not work.
4- Add satellite as new map Style
For some reason, it is not there by default, but it is trivial to add
mapbox://styles/mapbox/satellite-streets-v9
5-And voila
You can play with the slider, either moving the end date or a window, up to you
6-Now you have multiple options for sharing
You need to have a mapbox account, it is virtual free to medium usage !!!
For this example, I will share it using Dropbox, but you can export to HTML and securely share it either per email or hosted in sharepoint
This is one of the best piece of software that I had the privilege to use, nothing to install, free , simple and straight to the point !!
Project Controls blog 