We've been tracking our e-vehicles for 15 days every 20 minutes and we would like you to let us know some insights from the data gathered:
- What's the battery average of the e-vehicles during the night?
- What's the battery average of the e-vehicles during the day?
- If e-vehicles must be picked-up to charge their battery when the level is lower than 40, what's the time range when most e-vehicles need to be recharged?
- If e-vehicles must be picked-up to charge their battery when the level is lower than 40, what's the geozone with greater density of e-vehicles to be charged?
- Could you display on a heat map the density of e-vehicles in a timeline? Basically, we should be able to see how the density varies on the map as we change the timestamp.
NOTE: We appreciate more if you explain the process you followed to find out the answer than the answer itself.
In order to get a database up, running and populated with the info of the e-vehicles you just need docker and docker-compose installed in your computer. Then, just run:
./run.sh
A PostgreSQL DB will be listening on port 5432
in your localhost
with:
- user: test
- password: test
- database: test
- table with the data: message_store