Hi Arcadius

If you download the inetnum split file from the RIPE ftp site you will
see there are already some "geofeed:" attributes in there as well as
some still using the earlier "remarks: geofeed" option.

denis$ zgrep "^geofeed:" ~/Desktop/ripe.db.inetnum.gz  | wc -l
     289
denis$ zgrep "^remarks:\s*geofeed" ~/Desktop/ripe.db.inetnum.gz  | wc -l
      13

Although from the 289 there are only 161 unique organisations.

There are still a lot of people using the (old) "geoloc:" attribute.
denis$ zgrep "^geoloc:" ~/Desktop/ripe.db.inetnum.gz  | wc -l
   35453

You mentioned getting country level geo-ip, are you using the
"country:" attribute? If so which one? The ones in the INET(6)NUM
objects are undefined to anyone other than the resource holder. The
only one that is defined is the "country:" attribute in the referenced
ORGANISATION object for allocations and PI assignments. This is the
country the resource holder is legally based in.

cheers
denis
co-chair DB-WG

On Tue, 12 Apr 2022 at 19:09, Arcadius Ahouansou via db-wg
<db-wg@ripe.net> wrote:
>
>
> Hello Jori, Edward and All.
>
> I apologise for resurrecting this very old thread.
>
> We are using the files in the ripe DB for creating our own geo-location DB.
> It's straightforward to get country level geo-ip classification.
> We are now looking into a city level geo-ip information and I have just come across this old thread about "geofeed"
>
> It would be great to know whether this geofeed is already being implemented in the ripe FTP.
>
> Thank you very much.
>
> With kind regards.
>
> Arcadius,
>
> On Thu, 8 Apr 2021 at 15:18, Jori Vanneste via db-wg <db-wg@ripe.net> wrote:
>>
>> Hi Ed,
>>
>> On 4/8/2021 3:36 PM, Edward Shryane via db-wg wrote:
>> > Hi Jori,
>> >
>> >> On 8 Apr 2021, at 14:42, Tyrasuki <tyrasuki@pm.me> wrote:
>> >>
>> >> Hi Ed,
>> >>
>> >> This seems like a good implementation to me.
>> >>
>> >> 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.
>> > Given the draft states:
>> >
>> > " Any particular inetnum: object MAY have, at most, one geofeed
>> >     reference, whether a remarks: or a proper geofeed: attribute when one
>> >     is defined."
>> >
>> > Do we enforce this by validating that there is only one "remarks: Geofeed" value (or "geofeed:") in the object?
>> My apologies, I think I missed this section in the draft, thanks for
>> clarifying the reason to me.
>> >> Also:
>> >>> "Do not support non-ASCII values in URL domain names or path (these must be converted beforehand)"
>> >> 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?
>> >>
>> > 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.
>> >
>> > We could support non-ASCII values by automatically converting them (like we do with non-ASCII domains in email addresses).
>>
>> That sounds like a good approach to me, thanks for clarifying. :)
>>
>> I think this is indeed a good starting ground for a minimal NWI, and
>> would like to see where this goes.
>>
>> >> If the latter, and remarks can remain free-form, I'd say let's implement.
>> >>
>> >>
>> >> Cheers,
>> >> Jori Vanneste
>> >> FOD11-RIPE
>> >>
>> > Regards
>> > Ed
>>
>>
>> Best regards,
>> Jori Vanneste
>> FOD11-RIPE
>
>
>
> --
> Arcadius Ahouansou
> Menelic Ltd | Applied Knowledge Is Power
> Office : +441444702101
> Mobile: +447908761999
> Menelic Ltd: menelic.com
> SmartLobby: SmartLobby.co
> Hosted Apache Solr Services: solrfarm.com
>
> ---
> --
>
> To unsubscribe from this mailing list, get a password reminder, or change your subscription options, please visit: https://lists.ripe.net/mailman/listinfo/db-wg