[db-wg] country field in ORG objects

HI Ronald

The process and timelines are explained here
https://labs.ripe.net/author/stefania_fokaeos/our-plan-to-fix-country-codes/

cheers
denis
co-chair DB-WG

On Wed, 12 May 2021 at 22:21, Ronald F. Guilmette via db-wg
<db-wg at ripe.net> wrote:
>
> 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
>