[db-wg] country field in ORG objects

It is my understanding that it was decided that country: fields would be
added into any & all org objects that did not already contain them.

I would just like to inquire about the current status and expected timeline
for this project.  Is there an expected completion date?  Is RIPE NCC doing
all of the work?  Or is RIPE NCC instead just trying to cajole & browbeat
the organizations themselves into adding the country fields themselves?
(If the latter, than I have every faith & confidence that the project
will be completed no later than Spring of 2173.)

Because I have a tool that tries to summarize the name & country of each
org that has IP allocations, and because many org records in the RIPE
data base still do not have the country information, I find that I still
am needing to implement exceptions/workarounds in my code.

In any/most/all of these cases, inferring the proper country based on
the snail-mail address of the org is what we here on this side of the
pond would call a "no brainer".  Here are a few examples of that:

    'ORG-AA193-RIPE' => [ 'FR', 'GIE AUCHAN INTERNATIONAL TECHNOLOGY' ],
    'ORG-LUC7-RIPE' => [ 'DE', 'ZF Active Safety GmbH' ],
    'ORG-NNS5-RIPE' => [ 'CH', 'Nestle Nespresso S.A.' ],
    'ORG-RSS4-RIPE' => [ 'ES', 'REALE SEGUROS GENERALES, S.A' ],
    'ORG-SS244-RIPE' => [ 'FR', 'SOPRA HR Software SA' ],
    'ORG-XISG1-RIPE' => [ 'DE', 'Atos IT Services GmbH' ],

A quick look at the WHOIS record for any of the above orgs shows that there
is no real mystery about which country each one is in.  (If there is any
doubt, then simply googling the mailing address in the WHOIS clears that
right up.)

The apparent fact that the country codes for the orgs listed above are
altogether easy to reliably infer is only really relevant in the case
where RIPE NCC itself (rather than the orgs) is doing the work to add
the country fields into the org records that don't already have them.

Obviously, doing this on a large scale will be REALLY tedious work, but
from a technical perspective, at least, it doesn't seem to be either a
particularly hard task or a task which is particularly fraught with
difficult-to-resolve ambiguities.  (So I guess that's the "good news"
part of the story.  If RIPE NCC is doing the work, then they just have
to find someone to sit and do this, 8 hours a day, until it is either
finished or until that person goes blind or commits suicide due to the
excessive tedium of the task.)


Regards,
rfg