Statistiky waze

Moderators: Unholy, guri211, Zirland, GinBook

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 12:00 pm

Foxo: Ta 30-minutova metrika by mohla davat zmysel! Spravim to do druheho grafu :)
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 6:37 pm

V tomto momente ti pribudli na koniec kazdeho riadku 2 stlpce - logged_30 a driving_30, co vyjadruje pocet unikatnych wazerov (prihlasenych a jazdiacich) za poslednych 30 minut. Napady na farbu: driving_30 asi modra, logged_30 zeby oranzova? Alebo vymyslite vhodnejsiu :)

Uvidime ci tie grafy nebudu uz moc neprehladne ked tam bude 5 (resp. mozno 6) ciar.

Funguje to zatial iba pre Bratislavu a Brno, pre Prahu to zatial nezapisujem, musim tam trochu poriesit vyuzitie systemovych zdrojov.
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 7:31 pm

Prahu som zapol, ale upozornujem ze este to budem najblizsie dni doladovat a moze byt docasne opat vypnuta.

Fotrik: Vedel by si prosim este prehodit farby pre vacsiu prehladnost? Tu svetlozelenu by som dal radsej pre "V pohybu30" (aby to korespondovalo s tmavozelenou "V pohybu").
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 7:40 pm

Perfektne, dakujem za vybornu spolupracu :)
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 8:09 pm

fotrik wrote:Pokud to uz neni, tak bych jeste toho, kdo se behem 30 minut pohne, pocital v pohybu celych 30 minut. Aby se jako nehybni pocitali opravdu jen ti, co to maji zapnute doma nebo treba v nakupaku. Co ty na to?


Myslim ze ak spravne rozumiem, tak to uz je. Selectuju sa vsetci ti, ktori sa za poslednych 30 minut aspon raz pohli.

foxitrot wrote:Este jeden navrh na tie 30-ky: Predpokladam, ze su fazovo posunute prave o tu pol hodinu a grafy asi budu vyzerat rozhasene. Navrhujem kreslit ich posunute o ... 15? (ci 30? :? fotrik, skus, rychlo uvidime, ale asi 15) ... minut posunute vlavo, kedze predstavuju historicke data. Skor sa budu zhodovat ich vlnovky s aktualnymi datami.


Ja osobne by som to takto neriesil. Tato krivka (V pohybu30) ti krasne vyjadruje, kolko wazerov zbieralo aktualne stale platne relevantne data o premavke a manualne zadane eventy (platnost dosiahnutych rychlosti v zapche je do 30 minut, platnost eventov je 2,5 hodiny).
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 8:13 pm

fotrik wrote:guri mi dava data kazdou minutu a podle jejich hodnot to vypada, ze kazdou minutu zpracovava poslednich 30 minut. Cili narust bude temer aktualni, jen pokles bude pomalejsi. Uvazuji spravne? Posuv bych tedy nedelal.


Uvazujes spravne :) Robil som teraz este jeden workaround, lebo data boli minutu stare, ale uz su naozaj aktualne. T.j. ak by nastal taky extrem, ze za poslednych 29 minut nebol prihlaseny nikto a v 30. minutu sa prihlasi naraz 40 wazerov, bude ich aj na tejto krivke (Prihlaseno30) okamzite 40.
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 9:03 pm

Foxo: Nie, je to pocet UNIKATNYCH wazerov za poslednych 30 minut. T.j. ak od 1. do 15. minuty boli pritomni wazeri A, B, C, a od 15. do 30. minuty wazeri C, D, E, bude tam zapocitanych 5 wazerov (A, B, C, D, E).
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Sun Nov 27, 2011 10:31 pm

Osobne by som v grafe nechal aj pocet sucasne prihlasenych, aj tie _30 tak ako su. Ak treba graf ocistit, vyhodil by som neaktivnych wazerov (aktualnych, aj _30).

Spicka tej "V pohybu30" krivky by mala vyjadrovat cas, kedy je k dispozicii najviac aktualnych dopravnych info, nie kedy jazdi najviac wazerov.
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Mon Nov 28, 2011 6:15 am

Foxo:

logged_30=(SELECT COUNT(*) FROM (SELECT DISTINCT user FROM waze_stats_users WHERE waze_stats_users.region_id=$REGION AND logged_dtc>UNIX_TIMESTAMP()-1800) AS t1)

driving_30=(SELECT COUNT(*) FROM (SELECT DISTINCT user FROM waze_stats_users WHERE region_id=$REGION AND driving_dtc>UNIX_TIMESTAMP()-1800) AS t2)

logged_dtc je cas posledneho refreshu klienta daneho uzivatela.
driving_dtc je cas posledneho refreshu pri ktorom mal rychlost>0.
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

Re: Statistiky waze

Postby guri211 » Mon Nov 28, 2011 9:01 am

foxitrot wrote:neviem prist na to, preco maju take ostre spicky.


Foxo: Pozri sa na Prahu, tam to kresli ukazkovych slonikov :) Tie spicky su podla mna sposobene malym poctom pouzivatelov.
Waze 2.4 @ Ericsson GA628 (landscape mode preffered)
Škoda 100 MB 1977 (grey)
Pressburg, Slovakia
guri211
Waze Global Champs
Waze Global Champs
 
Posts: 1689
Joined: Fri Dec 31, 2010 6:13 pm
Location: Bratislava, Slovakia
Has thanked: 627 times
Been thanked: 430 times

PreviousNext

Return to Czech Republic and Slovakia

Who is online

Users browsing this forum: No registered users