DPGs location data is not standardized

[edil-it-them]

Location data in digitalpublicgoods folder is not standardized. So it's harder to analyze and visualize data because we need to clean it up every time we load data.
For example, in the DPG map visualization we need to edit a loader script every time there is a new DPG.
I found that in a submission form there is a country list which solve the problem with new submissions.

Work to do:

1. Clean up all existing data in digitalpublicgoods folder
2. Sync country names in DPG map visualization with country names in the submission form

You can find an object with current implementation of data cleaning in loader script in DPG map project.

[edil-it-them]

@lacabra kindly confirm that this schema points to country names used in submission form.

[lacabra]

@Rolikasi: Yes I confirm that the above schema is the one used in the submission form, which will be used to create new entries.

I hear your frustration with the lack of standardization of country names in existing entries, so I would very much welcome a script to standardize existing entries. Or you can use the output of the script you are currently running to submit changes to any of the existing entries in the candidates repo

[edil-it-them]

Great, I can work on it 🚀

[lacabra]

Just for context, the discrepancies may come from the earliest submissions that were manually coded, and were not part of the form. Or now that I think of it, there is a glitch with that part of the form that results in some instances of people sending us their own list that is thus not standardized; so if you want to isolate a script that normalizes country names, I can team up with you to work on embedding it on the CI (or of course, you can tackle it all 💪)

Cc: @nathanbaleeta