Add location types reference

[fretchen]

The initial commits of this PR were done by Co-Pilot. They failed.

[fretchen]

I had a look through the situation and now think that I have a working proposition on how to have a good and flexible reference for the location types:

• In the references folder we have an excel file called kfw_location_types.xlsx
• This file has the columns subsector, character, code, name, name_de, geometry, category, description, description_fr.
• It hence contains all the necessary information to create and validate the Location Types IATI and New worksheet in the french and english version of the template.
• Both templates (french) and (english) are automatically validated to contain all the necessary location types based on the code. More refined validation could happen later.

Some things where this solution helps:

• The information concerning the location type is collected in one place. Adding more content languages etc happens all in one place and does not need manual cross-validation.
• The french and the english template could remove redudant columns in the future. The english template could the remove the column with all the french translations and the german. The french template could get rid of the english description column etc...
• In later iterations we can directly generate the entries in the templates from the reference such that it is automatically ensured that the templates contain exactly the information from the reference xlsx file.

Some open points if we like this solution:

• I think that it would be really helpful to have some documentation of the process. I would propose to have documentation of the location type in a similar fashion as in the table of the technical notes. Just not for for the model (which mainly describes the fill-me), but for the columns described above.

@Maja4Dev and @Jo-Schie I would be curious about your comments and would only finish this up if you guys give a green light.

P.S.: FWIW. The whole process is also working nicely with the kfw_location_types.json file, whose content is identical to the content of the xlsx. But the xlsx is nicer to manipulate for translations in the future, which is why I would like to keep both as the json is easier machine readable. I would most likely add a simple script which automatically converts the xlsx to json...

[fretchen]

Dear @Maja4Dev and @Jo-Schie the PR is now ready for review. Main points are:

• kfw_location_types.xlsxwhich contains the location_types
• location_types.md which contains the documentation for the location types and how the reference is connected to the templates
• test_location_types.py which contains units tests to ensure that the french and the english template contain all the necessary location types.

All other changes are IMHO minor.

[fretchen]

reviewed and discussed with @Jo-Schie and @Maja4Dev