<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style></style> </head> <body lang="en-DE" link="#0563C1" vlink="#954F72"> <div class="WordSection1"> <p class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">A RIPE hosted geolocation feed may indeed provide some advantages, however in my opinion this should instead be based on data supplied by the LIR (or end user for PI assignments), as it would be using an external geolocation feed, instead of automatically via Atlas. There are various reasons for why a measurement approach may return bad data (i.e. routing inconsistencies).<o:p></o:p></span></p> <p class="MsoNormal"><span lang="en-DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <div> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" style="background:white"> <tbody> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><b><span style="font-size:13.5pt;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">Matthias Merkel</span></b><b><span style="font-size:13.5pt;color:#0C0C35"><o:p></o:p></span></b></p> <p class="MsoNormal" style="line-height:16.5pt"><span style="font-size:10.5pt;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">Executive Vice President</span><span style="font-size:10.5pt;color:#0C0C35"><o:p></o:p></span></p> <p class="MsoNormal" style="line-height:16.5pt"><span style="font-size:10.5pt;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">Staclar, Inc.</span><span style="font-size:10.5pt;color:#0C0C35"><o:p></o:p></span></p> </td> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt"></td> <td width="1" style="width:.75pt;border:none;border-left:solid #37ABC8 1.0pt;padding:.75pt .75pt .75pt .75pt"> </td> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt"></td> <td style="padding:.75pt .75pt .75pt .75pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr style="height:12.5pt"> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td valign="bottom" style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><span style="color:black;border:none windowtext 1.0pt;padding:0cm;background:#37ABC8"><img width="13" height="13" style="width:.1333in;height:.1333in" id="Picture_x0020_1" src="cid:image001.png@01D69CED.A2E46E70"></span><o:p></o:p></p> </td> </tr> </tbody> </table> </td> <td style="padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm;background:white">+1-628-213-1141</span><span style="font-size:9.0pt;font-family:"inherit",serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm"> </span><span style="color:#0C0C35">|<span style="border:none windowtext 1.0pt;padding:0cm"> </span></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm;background:white">+49 15678 585608</span><span style="color:#0C0C35"><o:p></o:p></span></p> </td> </tr> <tr style="height:12.5pt"> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td valign="bottom" style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><span style="color:black;border:none windowtext 1.0pt;padding:0cm;background:#37ABC8"><img width="13" height="13" style="width:.1333in;height:.1333in" id="Picture_x0020_2" src="cid:image002.png@01D69CED.A2E46E70"></span><o:p></o:p></p> </td> </tr> </tbody> </table> </td> <td style="padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <p class="MsoNormal"><a href="mailto:matthias.merkel@staclar.com"><span style="font-size:9.0pt;font-family:"inherit",serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">matthias.merkel@staclar.com</span></a><o:p></o:p></p> </td> </tr> <tr style="height:12.5pt"> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td valign="bottom" style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><span style="color:black;border:none windowtext 1.0pt;padding:0cm;background:#37ABC8"><img border="0" width="13" height="13" style="width:.1333in;height:.1333in" id="Picture_x0020_3" src="cid:image007.png@01D69CED.A2F7F670"></span><o:p></o:p></p> </td> </tr> </tbody> </table> </td> <td style="padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <p class="MsoNormal"><a href="https://staclar.com/"><span style="font-size:9.0pt;font-family:"inherit",serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">staclar.com</span></a><o:p></o:p></p> </td> </tr> <tr style="height:12.5pt"> <td width="30" style="width:22.5pt;padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td valign="bottom" style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><span style="color:black;border:none windowtext 1.0pt;padding:0cm;background:#37ABC8"><img border="0" width="13" height="13" style="width:.1333in;height:.1333in" id="Picture_x0020_4" src="cid:image008.png@01D69CED.A2F7F670"></span><o:p></o:p></p> </td> </tr> </tbody> </table> </td> <td style="padding:.75pt .75pt .75pt .75pt;height:12.5pt"> <p class="MsoNormal"><span style="font-size:9.0pt;font-family:"inherit",serif;color:#0C0C35;border:none windowtext 1.0pt;padding:0cm">Munich, Germany</span><o:p></o:p></p> </td> </tr> </tbody> </table> </td> </tr> </tbody> </table> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="434" style="width:325.5pt"> <tbody> <tr style="height:15.0pt"> <td style="padding:.75pt .75pt .75pt .75pt;height:15.0pt"></td> </tr> <tr style="height:.5pt"> <td width="434" style="width:325.5pt;border:none;border-bottom:solid #37ABC8 1.0pt;padding:.75pt .75pt .75pt .75pt;height:.5pt"> </td> </tr> <tr style="height:15.0pt"> <td style="padding:.75pt .75pt .75pt .75pt;height:15.0pt"></td> </tr> </tbody> </table> </td> </tr> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0" width="434" style="width:325.5pt"> <tbody> <tr> <td valign="top" style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><img border="0" width="130" height="19" style="width:1.3583in;height:.2in" id="Picture_x0020_5" src="cid:image009.png@01D69CED.A2F7F670"><o:p></o:p></p> </td> <td valign="top" style="padding:.75pt .75pt .75pt .75pt"> <div align="right"> <table class="MsoNormalTable" border="0" cellspacing="3" cellpadding="0"> <tbody> <tr> <td style="padding:.75pt .75pt .75pt .75pt"> <p class="MsoNormal"><a href="https://www.linkedin.com/in/matthias-merkel/"><span style="color:blue;border:none windowtext 1.0pt;padding:0cm;background:#37ABC8;text-decoration:none"><img border="0" width="24" height="24" style="width:.25in;height:.25in" id="Picture_x0020_6" src="cid:image006.png@01D69CED.A2E46E70" alt="linkedin"></span></a><o:p></o:p></p> </td> <td width="5" style="width:3.75pt;padding:.75pt .75pt .75pt .75pt"></td> </tr> </tbody> </table> </div> </td> </tr> </tbody> </table> </td> </tr> <tr style="height:15.0pt"> <td style="padding:.75pt .75pt .75pt .75pt;height:15.0pt"></td> </tr> </tbody> </table> <p class="MsoNormal"><span lang="en-DE"><o:p> </o:p></span></p> </div> <p class="MsoNormal"><span lang="en-DE" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <div> <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"> <p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> db-wg <db-wg-bounces@ripe.net> <b>On Behalf Of </b>Elad Cohen via db-wg<br> <b>Sent:</b> Wednesday, 7 October 2020 17:01<br> <b>To:</b> Horváth Ágoston János <horvath.agoston@gmail.com>; Job Snijders <job@instituut.net><br> <b>Cc:</b> db-wg@ripe.net >> Database WG <db-wg@ripe.net><br> <b>Subject:</b> Re: [db-wg] proposal: new attribute 'geofeed:'<o:p></o:p></span></p> </div> </div> <p class="MsoNormal"><o:p> </o:p></p> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">+1<o:p></o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">and I would like to suggest an adjustment:<o:p></o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">Not everyone will add the "geofeed" value and the geolocations in the csv will not validated by a 3rd party and may also be not up to date.<o:p></o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">I suggest to make the csv creation (of each INETNUM object) automatic and hosted by RIPE NCC, RIPE NCC can use all the current ATLAS Probes in order to check the physical location of each ip (using latencies from many probes to each ip, and using latencies from many probes to each router in the routing path to each ip, other ICMP queries can be used as well to query the routers in the routing path for physical information such as timezone as additional measures, etc). Algorithem will be efficient meaning at first only small number of probes will check each ip and then more probes physically near the first probe with the smallest latency.<o:p></o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">Kind Regards,<o:p></o:p></span></p> </div> <div> <p class="MsoNormal"><span style="font-size:12.0pt;color:black">Elad<o:p></o:p></span></p> </div> <div class="MsoNormal" align="center" style="text-align:center"> <hr size="2" width="98%" align="center"> </div> <div id="divRplyFwdMsg"> <p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> db-wg <<a href="mailto:db-wg-bounces@ripe.net">db-wg-bounces@ripe.net</a>> on behalf of Job Snijders via db-wg <<a href="mailto:db-wg@ripe.net">db-wg@ripe.net</a>><br> <b>Sent:</b> Wednesday, October 7, 2020 5:19 PM<br> <b>To:</b> Horváth Ágoston János <<a href="mailto:horvath.agoston@gmail.com">horvath.agoston@gmail.com</a>><br> <b>Cc:</b> <a href="mailto:db-wg@ripe.net">db-wg@ripe.net</a> >> Database WG <<a href="mailto:db-wg@ripe.net">db-wg@ripe.net</a>><br> <b>Subject:</b> Re: [db-wg] proposal: new attribute 'geofeed:'</span> <o:p></o:p></p> <div> <p class="MsoNormal"> <o:p></o:p></p> </div> </div> <div> <div> <p class="MsoNormal" style="margin-bottom:12.0pt">On Wed, Oct 07, 2020 at 03:43:33PM +0200, Horváth Ágoston János wrote:<br> > An interesting proposal, but merging an external data set with RIPE<br> > Database arises some questions:<br> > <br> > - RIPE Database is set up to contain hierarchical data already. With this<br> > proposal, we would take some of this data outside the database in a manner<br> > that does not guarantee consistency with the database itself. <br> <br> I don't think that is what is happening, this is more analogous to<br> "abuse-mailbox:". The value contains an email address (which is an<br> entrypoint outside the database, and interacting with the entrypoint is<br> outside the scope of this working group).<br> <br> The "geofeed:" attribute is a pointer to elsewhere, and what a data<br> consumer wants to do with that information is up to them.<br> <br> Kind regards,<br> <br> Job<o:p></o:p></p> </div> </div> </div> </body> </html>