What did we discuss during the Covid19 Community Response Call #1 & What will we do next?

From Monday on Sunday the government closed of a region after a case of the virus was discovered in a late stage. The problem is that it’s a Azeri minority village and that a lot of people do not speak Georgian - and can’t follow the updates. Many woke up in a quarantined of zone without knowing what was going on. Yesterday and today, people still went along their usual routines, but I found out that one person is setting up a volunteer campaign going door to door in all the villages in order to inform people of the situation in Azerbaijani.

1 Like

OK, i will set that up with our community account on zoom. doe you mean 17:00 CEST?

1 Like

yes CEST

1 Like

Yes we can do that and see what solutions can we bring together, or improve existing ones.

2 Likes

How about tomorrow 11:00?

1 Like

11am same as Tunisian time?

Does someone know Marco’s handel on the platform?

It’s mtsn

1 Like

Not in Georgia, but in the North Caucasus:
Screenshot_20200327-201441

1 Like

hey guys, how did this go? @mstn how are things going - is the app ready to test?

Hello @MariaEuler - the German version of the Soap Maker Corona Fairy Tale is public. I like to thank family-members & friends in Germany for their help. I turn now (again) to the English version. best regards, Martin

2 Likes

Amazing!

Here theEN-Version of the Soap Boiler Fairy-Tale. - regards, Martin

2 Likes

That’s great! If I would format it for you for the platform, would you post it? On here people could nicely react to it :slight_smile:

Hello @MariaEuler - go ahead as you like. This is freeware! For other language versions; I have a MS Office licence and can produce machine-translated versions in a simple manner that I could share. The text needs corrections but cuts time by an order of magnitude. - best regards, Martin

1 Like

Ping @alessandro_mambelli & @jasen_lakic - if you need to talk to Marco.

1 Like

Quick update. Code is 99% ready, but I am stuck because Google cannot validate my credit card (which should be fine). They are not working at full capacity because of Covid! At least, this is what the red popup told me.

Do I need Google? Yes, for searching by address. The free tier has too strict limits, so I have to enable a premium account. Then I was going to use Google for hosting, because it is cheap, no devops, easy and scales well.

Lesson learned. Advanced technologies are fragile.

2 Likes

Ok, got an idea. Let’s go low tech like in the '90s.

I can generate some html, which could work also offline, from the current website.

I can easily implement search by location offline if I have all the data on the client. Of course it works if data are not big, but it should handle 10k places (even more).

If we have more than 10k places, we can split the app into N apps by municipality/area/neighborhood. If I am in Milan, I do not buy bread in Rome.

The main problem is: how can I collect data? It must be done in a separate form or a part of the app that works online. I think that it is important if data collection can be done in the same app. Any (not-too-Google-dependent) ideas?

1 Like

this could be a challenge for next week’s call on surveillance and pandemic response @alberto and @matthias: A surveillance pandemic? A community listening session on emergent post-COVID trends, from contact tracking to special powers - #3 by krozruch

Maybe you should go @mstn

1 Like

Some people told me about at least two other apps doing the same thing in my province. So I really do not know if it makes sense to add noise with another app.

What I could do is to release the code as it is. From a csv/json of companies is possible to create an app that works offline. In this way, if anyone needs it, they can clone the project, run a script and deploy the app somewhere. This is basically what the other apps do. At least people from other regions/countries can have a starting point which requires zero coding skills.

In the long (hopefully short) term (when the epidemic is over), I can think about an integration with more services with the goal of promoting local shopping. One of the two apps I mentioned above is “institutional”, made by the local government with associations of retailers and local farmers. I am going to ask them if they want to release that data as opendata.

So, in conclusion, I’ll tidy up what I have and I’ll make it available as a boilerplate. That’s it.

2 Likes