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 <[email protected]> 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 >
