sledilnik/zdravniki-data

Data of doctors' availability

zdravniki-data's Issues

Incorrect doctors address

Some doctors fall under ZDRAVSTVENI DOM DR. ADOLFA DROLCA MARIBOR, however they actually work at different locations.

For example: https://www.zd-mb.si/Storitve/Zdravniki?id=13093#doctorAnchor
His location on the map: ULICA TALCEV 9
Actual location: Zagrebška cesta 84a

Any way to get that additional information, since it's not in xlsx?

Fix doctor duplication when same institutions in different places

It happens when csv/dict-institutions.csv contains multiple entries with same institution
See eg SŽ - ŽELEZNIŠKI ZDRAVSTVENI DOM LJUBLJANA, possibly there are others

Switch to persitent ID for institutions (ZZZS ID)

We should switch to using persistent ID for institutions instead of generated one.
We need it to present doctor in multiple institutions uniquely - see also
sledilnik/zdravniki#154

Currently we have some institutions that do not have ZZZS ID:

305,,"MDENT, ZOBOZDRAVSTVENE STORITVE, MIHAJLO FRANGOV S.P.",IZPOSTAVA SLOVENJ GRADEC,Trg svobode 18A,2390 Ravne na Koroškem,Ravne na Koroškem,TRG,Ravne na Koroškem,46.54428,14.96559,,
373,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM BLED, ZDRAVSTVENI DOM BOHINJ",IZPOSTAVA RADOVLJICA,Mladinska cesta 1,4260 Bled,Bled,Bled,Bled,46.3714,14.10909,,
374,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM JESENICE",IZPOSTAVA JESENICE,Cesta maršala Tita 78,4270 Jesenice,Jesenice,Plavž,Jesenice,46.44,14.04461,,
375,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM KRANJ",OE KRANJ,Gosposvetska ulica 10,4000 Kranj,Kranj,Zlato polje,Kranj,46.2489,14.35325,,
376,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM RADOVLJICA",IZPOSTAVA RADOVLJICA,Kopališka cesta 7,4240 Radovljica,Radovljica,Radovljica,Radovljica,46.34702,14.17201,,
377,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM TRŽIČ",IZPOSTAVA TRŽIČ,Blejska cesta 10,4290 Tržič,Tržič,Tržič - mesto,Tržič,46.36361,14.30654,,
378,,"OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM ŠKOFJA LOKA",IZPOSTAVA ŠKOFJA LOKA,Stara cesta 10,4220 Škofja Loka,Škofja Loka,Kamnitnik,Škofja Loka,46.16618,14.31281,,
678,,ZD LJUBLJANA - BEŽIGRAD,OE LJUBLJANA,Kržičeva ulica 10,1000 Ljubljana,Ljubljana,Četrtna skupnost Bežigrad,Ljubljana,46.06465,14.51105,,
679,,ZD LJUBLJANA - CENTER,OE LJUBLJANA,Metelkova ulica 9,1000 Ljubljana,Ljubljana,Četrtna skupnost Center,Ljubljana,46.05658,14.51516,,
680,,ZD LJUBLJANA - MOSTE - POLJE,OE LJUBLJANA,Prvomajska ulica 5,1000 Ljubljana,Ljubljana,Četrtna skupnost Moste,Ljubljana,46.05588,14.53132,,
681,,ZD LJUBLJANA - VIČ - RUDNIK,OE LJUBLJANA,Šestova ulica 10,1000 Ljubljana,Ljubljana,Četrtna skupnost Vič,Ljubljana,46.04631,14.48719,,
682,,ZD LJUBLJANA - ŠENTVID,OE LJUBLJANA,Ob zdravstvenem domu 1,1210 Ljubljana - Šentvid,Ljubljana,Četrtna skupnost Šentvid,Ljubljana,46.09856,14.4649,,
683,,ZD LJUBLJANA - ŠIŠKA,OE LJUBLJANA,Derčeva ulica 5,1000 Ljubljana,Ljubljana,Četrtna skupnost Šiška,Ljubljana,46.06846,14.488,,

Suggestion is that we hardcode temporary IDs for these institiutions:

MDENT
OZGBL
OZGJE
OZGKR
OZGRA
OZGTR
OZGSL
ZDLBE
ZDLCE
ZDLMO
ZDLVI
ZDLSI
ZDLSE

Implement overrides for doctors.csv

• download GSheet Overrides sheet to overrides.csv
• join doctors.csv with overrides.csv using doctor and type as key
• for entries with override_address and override_post add geocoded coordinates in override_lat and override_lon

Match all institutions in xlsx to entities from ZZZS API, getting a zzzsSt ID

So that every record in csv/dict-institutions.csv gets a zzzsSt and all available data (website, phone....) from zzzs/institutions-by-category.csv.

Missing matches for:

• ZD LJUBLJANA - BEŽIGRAD ... ZD LJUBLJANA - ŠIŠKA
• OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM BLED ... OSNOVNO ZDRAVSTVO GORENJSKE, OE ZDRAVSTVENI DOM ŠKOFJA LOKA
• MDENT, ZOBOZDRAVSTVENE STORITVE, MIHAJLO FRANGOV S.P.

Regex for finding them in csv: ^[0-9]*,,

Extract historical data

Parse also older Excel files in zzzs/ and extract time series of some meaningful data per doctor type, per region, per municipality eg

• number of doctors
• number of doctors accepting / not accepting (as in excels)
• availability (sum, avg, min, max....)
• load (sum, avg, min, max....)
  ...

Persist a timestamp of last change

Somewhere in
https://github.com/sledilnik/zdravniki-data/tree/main/csv

Either timestamp of last change of each .csv or one for all.