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