<div dir="ltr"><br><div>Hello Denis and All.</div><div><br></div><div>Thank you very much for your reply.</div><div>For instance with an entry like shown below, we will be using NL as the country.</div><div>As you rightly said, that is for the organisation.</div><div>So, we are working on moving to something more accurate on the city level.</div><div><br></div><div>Thank you very much.</div><div><br></div><div>With best regards</div><div><br></div><div>Arcadius</div><div><br></div><div><p style="margin:0px;white-space:pre-wrap">% Tags relating to '156.150.0.0 - 156.150.255.255'</p>
<p style="margin:0px;white-space:pre-wrap">% RIPE-REGISTRY-RESOURCE</p>
<p style="margin:0px;white-space:pre-wrap"><br></p>
<p style="margin:0px;white-space:pre-wrap">inetnum: 192.68.230.0 - 192.68.230.255</p>
<p style="margin:0px;white-space:pre-wrap">netname: Atos-MEV</p>
<p style="margin:0px;white-space:pre-wrap"><b>country: NL</b></p>
<p style="margin:0px;white-space:pre-wrap">org: ORG-OB2-RIPE</p>
<p style="margin:0px;white-space:pre-wrap">admin-c: DUMY-RIPE</p>
<p style="margin:0px;white-space:pre-wrap">tech-c: DUMY-RIPE</p>
<p style="margin:0px;white-space:pre-wrap">status: LEGACY</p>
<p style="margin:0px;white-space:pre-wrap">notify: <a href="mailto:Global-IPcoordinator@atos.net">Global-IPcoordinator@atos.net</a></p>
<p style="margin:0px;white-space:pre-wrap">mnt-by: RIPE-NCC-LEGACY-MNT</p>
<p style="margin:0px;white-space:pre-wrap">mnt-routes: MNT-VALUESOLUTIONS</p>
<p style="margin:0px;white-space:pre-wrap">mnt-by: GIPC-ORIGIN-MNT</p>
<p style="margin:0px;white-space:pre-wrap">created: 1970-01-01T00:00:00Z</p>
<p style="margin:0px;white-space:pre-wrap">last-modified: 2017-08-24T08:32:00Z</p>
<p style="margin:0px;white-space:pre-wrap">source: RIPE</p>
<p style="margin:0px;white-space:pre-wrap">remarks: ****************************</p>
<p style="margin:0px;white-space:pre-wrap">remarks: * THIS OBJECT IS MODIFIED</p>
<p style="margin:0px;white-space:pre-wrap">remarks: * Please note that all data that is generally regarded as personal</p>
<p style="margin:0px;white-space:pre-wrap">remarks: * data has been removed from this object.</p>
<p style="margin:0px;white-space:pre-wrap">remarks: * To view the original object, please query the RIPE Database at:</p>
<p style="margin:0px;white-space:pre-wrap">remarks: * <a href="http://www.ripe.net/whois">http://www.ripe.net/whois</a></p>
<p style="margin:0px;white-space:pre-wrap">remarks: ****************************</p>
<p style="margin:0px;white-space:pre-wrap"><br></p></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, 12 Apr 2022 at 20:12, denis walker <<a href="mailto:ripedenis@gmail.com">ripedenis@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Arcadius<br>
<br>
If you download the inetnum split file from the RIPE ftp site you will<br>
see there are already some "geofeed:" attributes in there as well as<br>
some still using the earlier "remarks: geofeed" option.<br>
<br>
denis$ zgrep "^geofeed:" ~/Desktop/ripe.db.inetnum.gz | wc -l<br>
289<br>
denis$ zgrep "^remarks:\s*geofeed" ~/Desktop/ripe.db.inetnum.gz | wc -l<br>
13<br>
<br>
Although from the 289 there are only 161 unique organisations.<br>
<br>
There are still a lot of people using the (old) "geoloc:" attribute.<br>
denis$ zgrep "^geoloc:" ~/Desktop/ripe.db.inetnum.gz | wc -l<br>
35453<br>
<br>
You mentioned getting country level geo-ip, are you using the<br>
"country:" attribute? If so which one? The ones in the INET(6)NUM<br>
objects are undefined to anyone other than the resource holder. The<br>
only one that is defined is the "country:" attribute in the referenced<br>
ORGANISATION object for allocations and PI assignments. This is the<br>
country the resource holder is legally based in.<br>
<br>
cheers<br>
denis<br>
co-chair DB-WG<br>
<br>
On Tue, 12 Apr 2022 at 19:09, Arcadius Ahouansou via db-wg<br>
<<a href="mailto:db-wg@ripe.net" target="_blank">db-wg@ripe.net</a>> wrote:<br>
><br>
><br>
> Hello Jori, Edward and All.<br>
><br>
> I apologise for resurrecting this very old thread.<br>
><br>
> We are using the files in the ripe DB for creating our own geo-location DB.<br>
> It's straightforward to get country level geo-ip classification.<br>
> We are now looking into a city level geo-ip information and I have just come across this old thread about "geofeed"<br>
><br>
> It would be great to know whether this geofeed is already being implemented in the ripe FTP.<br>
><br>
> Thank you very much.<br>
><br>
> With kind regards.<br>
><br>
> Arcadius,<br>
><br>
> On Thu, 8 Apr 2021 at 15:18, Jori Vanneste via db-wg <<a href="mailto:db-wg@ripe.net" target="_blank">db-wg@ripe.net</a>> wrote:<br>
>><br>
>> Hi Ed,<br>
>><br>
>> On 4/8/2021 3:36 PM, Edward Shryane via db-wg wrote:<br>
>> > Hi Jori,<br>
>> ><br>
>> >> On 8 Apr 2021, at 14:42, Tyrasuki <<a href="mailto:tyrasuki@pm.me" target="_blank">tyrasuki@pm.me</a>> wrote:<br>
>> >><br>
>> >> Hi Ed,<br>
>> >><br>
>> >> This seems like a good implementation to me.<br>
>> >><br>
>> >> However, I don't think it's a good idea to limit the values on the "remarks" attribute in this way, as this could cause unwanted side effects with for ex. messages left on objects for other network operators.<br>
>> > Given the draft states:<br>
>> ><br>
>> > " Any particular inetnum: object MAY have, at most, one geofeed<br>
>> > reference, whether a remarks: or a proper geofeed: attribute when one<br>
>> > is defined."<br>
>> ><br>
>> > Do we enforce this by validating that there is only one "remarks: Geofeed" value (or "geofeed:") in the object?<br>
>> My apologies, I think I missed this section in the draft, thanks for<br>
>> clarifying the reason to me.<br>
>> >> Also:<br>
>> >>> "Do not support non-ASCII values in URL domain names or path (these must be converted beforehand)"<br>
>> >> Do you by this mean not supporting non-ASCII entirely? Or to have for ex. the web-interface convert IDNs to punycode, and have this listed on the object?<br>
>> >><br>
>> > The RIPE database uses the Latin-1 character set, so IDN domain names or non-ASCII values in the URL path will be substituted with a '?' character, by default.<br>
>> ><br>
>> > We could support non-ASCII values by automatically converting them (like we do with non-ASCII domains in email addresses).<br>
>><br>
>> That sounds like a good approach to me, thanks for clarifying. :)<br>
>><br>
>> I think this is indeed a good starting ground for a minimal NWI, and<br>
>> would like to see where this goes.<br>
>><br>
>> >> If the latter, and remarks can remain free-form, I'd say let's implement.<br>
>> >><br>
>> >><br>
>> >> Cheers,<br>
>> >> Jori Vanneste<br>
>> >> FOD11-RIPE<br>
>> >><br>
>> > Regards<br>
>> > Ed<br>
>><br>
>><br>
>> Best regards,<br>
>> Jori Vanneste<br>
>> FOD11-RIPE<br>
><br>
><br>
><br>
> --<br>
> Arcadius Ahouansou<br>
> Menelic Ltd | Applied Knowledge Is Power<br>
> Office : +441444702101<br>
> Mobile: +447908761999<br>
> Menelic Ltd: <a href="http://menelic.com" rel="noreferrer" target="_blank">menelic.com</a><br>
> SmartLobby: SmartLobby.co<br>
> Hosted Apache Solr Services: <a href="http://solrfarm.com" rel="noreferrer" target="_blank">solrfarm.com</a><br>
><br>
> ---<br>
> --<br>
><br>
> To unsubscribe from this mailing list, get a password reminder, or change your subscription options, please visit: <a href="https://lists.ripe.net/mailman/listinfo/db-wg" rel="noreferrer" target="_blank">https://lists.ripe.net/mailman/listinfo/db-wg</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Arcadius Ahouansou<br>Menelic Ltd | Applied Knowledge Is Power<br>Office : +441444702101</div><div>Mobile: +447908761999</div><div><span style="font-size:12.8px">Menelic Ltd: </span><a href="https://menelic.com/" style="font-size:12.8px" target="_blank">menelic.com</a><br></div><div><div><div>SmartLobby: <a href="https://smartlobby.co/" target="_blank">SmartLobby.co</a></div><span style="font-size:12.8px">Hosted Apache Solr Services: <a href="http://solrfarm.com/" target="_blank">solrfarm.com</a></span><br></div></div><div><br></div><div>---<br></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>