Konzipiert für die Auswertung mit Grafana
pip install -r requirements.txt
id |
name |
brand |
street |
place |
lat |
lng |
dist |
houseNumber |
postCode |
ID |
Unique Name |
Shell/ARAL/... |
Str. |
Stadt |
0.0 |
0.0 |
km / lat lng in config |
1 |
12345 |
stationId |
isOpen |
Station ID |
Is it open |
stationId |
timestamp |
price |
Station ID |
1234567890 |
how much at timestamp? |
Günstigste Tankstelle im Umkreis unter Betrachtung der Fahrtkosten zur Tankstelle:
SELECT MAX(timestamp) as timestamp, name, price, price*60 + (price*2*dist*8)/100 as total FROM prices
INNER JOIN stations
ON stations.id == prices.stationId
GROUP BY name
ORDER BY total