From: Michael Tremer <michael.tremer@ipfire.org>
To: location@lists.ipfire.org
Subject: Re: List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?)
Date: Fri, 07 May 2021 11:48:39 +0100 [thread overview]
Message-ID: <885A4C79-EB22-4D14-92F9-A7A5688C451A@ipfire.org> (raw)
In-Reply-To: <eb6d6bba-070f-9be9-6d13-35c7a2a25d23@ipfire.org>
[-- Attachment #1: Type: text/plain, Size: 31349 bytes --]
Hello,
> On 6 May 2021, at 22:06, Peter Müller <peter.mueller(a)ipfire.org> wrote:
>
> Hello Michael,
> hello *,
>
> after fiddling a bit on location02 - patch is to be followed shortly -, I thought it might be interesting
> to have a complete list of IP networks having more than one country assigned to.
>
> This is it:
>
>> location=# SELECT network, country, original_country FROM networks WHERE array_length(original_country, 1) > 1;
I would recommend to name any field with an array in its plural name. In this case “original_countries”. That makes it easier to understand what the content is and writing loops where you could simply have “for original_country in original_countries: …"
>> network | country | original_country
>> ---------------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>> 194.122.0.0/15 | DE | {DE,NL}
>> 37.246.0.0/16 | TR | {TR,US,NL,DE,GB}
>> 46.108.0.0/16 | DE | {DE,IE,GB}
>> 62.132.0.0/16 | DE | {DE,NL}
>> 81.85.0.0/16 | US | {US,NL}
>> 85.205.0.0/16 | DE | {DE,IE,GB}
>> 95.209.0.0/16 | DK | {DK,SE}
>> 129.73.0.0/16 | CR | {CR,DO,GT,HN,MX,NI,SV,US}
>> 129.214.0.0/16 | AR | {AR,BR,CL,CO,PE,UY,VE,US,DE}
>> 131.176.0.0/16 | EU | {EU,AU,CA,KE,RU,US}
>> 132.186.0.0/16 | AE | {AE,BH,DZ,EG,IN,KW,MA,QA,TN,ZA}
>> 137.223.0.0/16 | GB | {GB,IE}
>> 139.10.0.0/16 | BE | {BE,FR,NL}
>> 141.11.0.0/16 | FR | {FR,GB}
>> 141.29.0.0/16 | BA | {BA,GR,HR,IT,PT,SI}
>> 146.253.0.0/16 | DE | {DE,SE}
>> 146.254.0.0/16 | DE | {DE,SE}
>> 155.190.0.0/16 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 165.218.0.0/16 | DE | {DE,US}
>> 193.220.0.0/16 | NO | {NO,US,FR}
>> 195.73.0.0/16 | DE | {DE,NL}
>> 37.25.128.0/17 | DE | {DE,IE,GB}
>> 46.190.128.0/17 | DE | {DE,IE,GB}
>> 77.67.0.0/17 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
>> 77.70.128.0/17 | NO | {NO,US,FR}
>> 85.131.128.0/17 | DE | {DE,NL}
>> 87.98.0.0/17 | EE | {EE,EU}
>> 131.228.0.0/17 | FI | {FI,US,DE,IN}
>> 31.6.0.0/18 | GB | {GB,NL,DE,FR,IT,AE}
>> 78.137.128.0/18 | IE | {IE,GB}
>> 78.143.0.0/18 | DE | {DE,NL}
>> 89.149.128.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
>> 93.183.0.0/18 | US | {US,BR,FI,DE,CN,IN,SG}
>> 159.180.128.0/18 | US | {US,DE,SG,CN,JP,BR,IE,IT,PR}
>> 178.79.192.0/18 | EU | {EU,SE,DE,NL,GB,ES,FR,IT}
>> 193.219.192.0/18 | NO | {NO,US,FR}
>> 194.93.192.0/18 | DE | {DE,IT}
>> 212.111.128.0/18 | GB | {GB,FR}
>> 213.200.64.0/18 | AT | {AT,BE,CA,CH,CZ,DE,DK,ES,FR,GB,GR,HK,IE,IT,NL,NO,PL,SE,SG,SK,US,RO}
>> 213.254.192.0/18 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,SK,ES,FR,GB,RO,HK,SG,IE}
>> 37.18.192.0/19 | SE | {SE,US,DE,DK}
>> 46.33.64.0/19 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
>> 62.32.32.0/19 | US | {US,NL}
>> 62.128.96.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 82.150.224.0/19 | DE | {DE,FR}
>> 82.198.128.0/19 | IE | {IE,GB}
>> 83.216.32.0/19 | AT | {AT,IT}
>> 83.221.160.0/19 | RU | {RU,UZ}
>> 87.248.192.0/19 | GB | {GB,NL,DE,FR,SE,ES,IT}
>> 88.84.128.0/19 | DE | {DE,NL,GB}
>> 89.21.160.0/19 | NL | {NL,US}
>> 146.247.96.0/19 | AT | {AT,DE,CH,US,BR,RU,FR,IT}
>> 158.255.96.0/19 | FR | {FR,DE,GB,NL,AT}
>> 159.180.192.0/19 | FR | {FR,GB,ES,DE,US}
>> 176.56.160.0/19 | GB | {GB,US,CY,NL}
>> 193.17.96.0/19 | DE | {DE,US,SG}
>> 193.202.128.0/19 | DE | {DE,US,SG}
>> 193.202.160.0/19 | DE | {DE,US,SG}
>> 194.34.64.0/19 | GB | {GB,US,JP,AU}
>> 194.121.96.0/19 | DE | {DE,NL}
>> 194.121.128.0/19 | DE | {DE,NL}
>> 194.121.192.0/19 | DE | {DE,NL}
>> 195.90.32.0/19 | EU | {EU,US}
>> 195.222.0.0/19 | EE | {EE,EU}
>> 212.27.224.0/19 | EE | {EE,EU}
>> 212.47.192.0/19 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 212.49.0.0/19 | EE | {EE,EU}
>> 212.126.32.0/19 | IE | {IE,GB}
>> 213.179.32.0/19 | NO | {NO,NL,ZA,DE,ES,IT,SE,DK,IS,FI,FR,GB}
>> 217.76.128.0/19 | ES | {ES,FR,PT}
>> 31.209.96.0/20 | CY | {CY,TR}
>> 46.20.240.0/20 | CH | {CH,FR,GB,RU,DE}
>> 77.70.144.0/20 | FR | {FR,LU,DE,NO}
>> 80.75.208.0/20 | GB | {GB,DE,NO,IE,FR,IN}
>> 80.83.176.0/20 | NL | {NL,DE}
>> 80.95.144.0/20 | DE | {DE,NL}
>> 81.92.224.0/20 | LU | {LU,DE,FR}
>> 83.216.192.0/20 | AT | {AT,DE}
>> 92.39.48.0/20 | RU | {RU,MD}
>> 95.140.224.0/20 | GB | {GB,NL,DE,FR,SE,ES,IT}
>> 109.236.192.0/20 | FR | {FR,GB,DE,IT,CH,ES}
>> 141.136.96.0/20 | IE | {IE,NL,GB,HK,BE,AT,NO,DK,CA,DE,GR,SE,RO,SG,CH,IT,PL,CZ,US,ES,SK,FR}
>> 153.92.48.0/20 | LU | {LU,NL,BE,DE,FR}
>> 193.141.32.0/20 | DE | {DE,NL}
>> 193.141.144.0/20 | DE | {DE,NL}
>> 193.141.160.0/20 | DE | {DE,NL}
>> 193.141.240.0/20 | DE | {DE,NL}
>> 193.220.144.0/20 | FR | {FR,LU,DE,NO}
>> 193.220.192.0/20 | FR | {FR,NL}
>> 194.45.240.0/20 | DE | {DE,NL}
>> 194.120.0.0/20 | DE | {DE,NL}
>> 194.120.64.0/20 | DE | {DE,NL}
>> 194.121.176.0/20 | DE | {DE,NL}
>> 194.121.224.0/20 | DE | {DE,NL}
>> 212.59.80.0/20 | US | {US,AU}
>> 217.28.240.0/20 | DE | {DE,EE,FI,GB,GE,LT,LV,NL,PL,RU,SE,UA,EU}
>> 217.68.192.0/20 | DE | {DE,FR,GB}
>> 5.149.112.0/21 | LU | {LU,FR,NL,DE,BE}
>> 5.149.248.0/21 | GB | {GB,NL}
>> 5.150.144.0/21 | IE | {IE,GB}
>> 5.187.0.0/21 | RU | {RU,ES,DE}
>> 31.25.208.0/21 | ES | {ES,GB}
>> 46.255.176.0/21 | FR | {FR,DE,GB,NL,AT}
>> 77.73.192.0/21 | SA | {SA,KW,AE}
>> 78.24.200.0/21 | CH | {CH,DE,FR,AR,AT,AU,BE,BG,BO,BR,CA,CL,CN,CO,CR,CZ,DK,ES,FI,GB,GR,HK,HU,ID,IE,IL,IN,IT,JP,LT,LU,LV,MA,MX,MY,NL,NO,NZ,PA,PE,PH,PL,PT,RO,RU,SE,SG,SK,TR,TW,UA,US,UY,VE,ZA}
>> 78.40.72.0/21 | CH | {CH,FR}
>> 85.119.16.0/21 | GB | {GB,NL}
>> 87.237.144.0/21 | DE | {DE,FR,GB}
>> 87.238.120.0/21 | DE | {DE,CH}
>> 87.238.136.0/21 | CH | {CH,AT,DE}
>> 87.239.184.0/21 | DE | {DE,FR,GB,NL}
>> 89.31.128.0/21 | AT | {AT,DE,RU,EU}
>> 89.219.136.0/21 | EE | {EE,EU}
>> 89.219.144.0/21 | EE | {EE,EU}
>> 93.94.112.0/21 | IE | {IE,GB}
>> 94.142.200.0/21 | ES | {ES,PT,AD}
>> 94.199.224.0/21 | IE | {IE,GB}
>> 95.128.192.0/21 | IE | {IE,DE,NO,GB,FR,IN}
>> 109.70.208.0/21 | IE | {IE,GB}
>> 134.0.72.0/21 | EU | {EU,US}
>> 145.255.128.0/21 | NL | {NL,GB,DE,CN,RO}
>> 146.185.48.0/21 | BE | {BE,NL}
>> 171.33.144.0/21 | GB | {GB,IE}
>> 176.241.248.0/21 | FR | {FR,BE,DE,LU,NL,CH,GB}
>> 178.22.8.0/21 | GB | {GB,US}
>> 178.248.48.0/21 | US | {US,EU,NL,IT}
>> 178.251.160.0/21 | LU | {LU,FR,DE,NL,BE}
>> 193.110.48.0/21 | GB | {GB,NL}
>> 193.141.8.0/21 | DE | {DE,NL}
>> 193.141.72.0/21 | DE | {DE,NL}
>> 193.141.80.0/21 | DE | {DE,NL}
>> 193.141.112.0/21 | DE | {DE,NL}
>> 193.141.128.0/21 | DE | {DE,NL}
>> 193.141.232.0/21 | DE | {DE,NL}
>> 193.220.80.0/21 | FR | {FR,LU,DE,NO}
>> 193.220.88.0/21 | FR | {FR,GF}
>> 194.45.8.0/21 | DE | {DE,NL}
>> 194.45.80.0/21 | DE | {DE,NL}
>> 194.45.112.0/21 | DE | {DE,NL}
>> 194.120.32.0/21 | DE | {DE,NL}
>> 194.120.56.0/21 | DE | {DE,NL}
>> 194.120.136.0/21 | DE | {DE,NL}
>> 194.120.152.0/21 | DE | {DE,NL}
>> 194.120.240.0/21 | DE | {DE,NL}
>> 194.121.16.0/21 | DE | {DE,NL}
>> 194.121.32.0/21 | DE | {DE,NL}
>> 194.121.72.0/21 | DE | {DE,NL}
>> 194.121.80.0/21 | DE | {DE,NL}
>> 194.121.160.0/21 | DE | {DE,NL}
>> 194.121.240.0/21 | DE | {DE,NL}
>> 2.59.52.0/22 | JO | {JO,SA}
>> 5.57.16.0/22 | GB | {GB,NL}
>> 45.84.144.0/22 | AT | {AT,DE}
>> 45.140.4.0/22 | CN | {CN,AU}
>> 45.152.136.0/22 | GB | {GB,AU}
>> 62.80.92.0/22 | CZ | {CZ,HU,PL,SK}
>> 77.70.160.0/22 | FR | {FR,LU}
>> 77.70.168.0/22 | FR | {FR,LU}
>> 82.116.132.0/22 | KW | {KW,EG,GB}
>> 85.217.172.0/22 | CH | {CH,DE,AT,BG}
>> 85.217.184.0/22 | CH | {CH,DE,AT,BG}
>> 88.218.80.0/22 | DE | {DE,AU}
>> 89.219.0.0/22 | EE | {EE,EU}
>> 89.219.128.0/22 | EE | {EE,EU}
>> 91.192.16.0/22 | DE | {DE,GB}
>> 91.196.116.0/22 | DE | {DE,GB}
>> 93.177.92.0/22 | RU | {RU,AU}
>> 95.214.80.0/22 | DE | {DE,AU}
>> 176.118.176.0/22 | BH | {BH,NL}
>> 185.4.124.0/22 | LU | {LU,NL,BE,DE,FR}
>> 185.5.184.0/22 | DE | {DE,CH}
>> 185.7.100.0/22 | GB | {GB,FR}
>> 185.13.128.0/22 | AM | {AM,HR,CZ,DK,FI,GE,DE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
>> 185.16.216.0/22 | EU | {EU,US}
>> 185.18.220.0/22 | IE | {IE,DE,NO,GB,FR,IN}
>> 185.21.212.0/22 | FR | {FR,MQ,GF,GP}
>> 185.23.240.0/22 | GB | {GB,AE,IQ,DE}
>> 185.26.0.0/22 | BG | {BG,FR}
>> 185.27.116.0/22 | JO | {JO,IQ}
>> 185.29.164.0/22 | GB | {GB,NL,DE,FR,IT}
>> 185.31.180.0/22 | CH | {CH,DE}
>> 185.32.192.0/22 | EU | {EU,US}
>> 185.33.168.0/22 | PS | {PS,FR,GB,DE,US}
>> 185.34.188.0/22 | GB | {GB,NL}
>> 185.34.196.0/22 | AT | {AT,DE}
>> 185.37.184.0/22 | CY | {CY,TR}
>> 185.38.240.0/22 | GB | {GB,US,DE}
>> 185.47.72.0/22 | IE | {IE,GB}
>> 185.47.100.0/22 | US | {US,NL}
>> 185.56.64.0/22 | NL | {NL,GB}
>> 185.60.84.0/22 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 185.64.8.0/22 | IL | {IL,US}
>> 185.65.172.0/22 | ES | {ES,IT,BH,AE}
>> 185.71.92.0/22 | GB | {GB,FR,DE}
>> 185.74.32.0/22 | FR | {FR,CH}
>> 185.75.240.0/22 | AT | {AT,GB}
>> 185.80.52.0/22 | GB | {GB,NL}
>> 185.81.112.0/22 | GB | {GB,NL}
>> 185.91.8.0/22 | US | {US,SE,GB,NL}
>> 185.94.64.0/22 | RU | {RU,EU}
>> 185.96.40.0/22 | GB | {GB,NO}
>> 185.97.244.0/22 | LU | {LU,NL,FR,DE,BE}
>> 185.99.220.0/22 | LB | {LB,TR}
>> 185.100.84.0/22 | IS | {IS,FI,RO}
>> 185.110.152.0/22 | CH | {CH,DE}
>> 185.114.16.0/22 | DE | {DE,IE}
>> 185.124.160.0/22 | GB | {GB,US}
>> 185.130.104.0/22 | NL | {NL,RU,US}
>> 185.132.128.0/22 | CH | {CH,AT,DE}
>> 185.136.44.0/22 | CH | {CH,IT,FR,SE,FI,NO,IL,DK,US}
>> 185.138.192.0/22 | GB | {GB,NL}
>> 185.142.28.0/22 | GB | {GB,IE}
>> 185.145.252.0/22 | NL | {NL,IL}
>> 185.149.68.0/22 | GB | {GB,US}
>> 185.159.80.0/22 | NL | {NL,RU,US}
>> 185.162.128.0/22 | NL | {NL,RU,US}
>> 185.167.164.0/22 | US | {US,DK}
>> 185.188.52.0/22 | AT | {AT,CH,DE}
>> 185.194.184.0/22 | FR | {FR,BE,DE,LU,NL,CH,GB,ES,DK,FI,PT,SE,IT,AT,HR,IE}
>> 185.206.28.0/22 | SA | {SA,GB}
>> 185.228.92.0/22 | PK | {PK,BH}
>> 185.239.76.0/22 | IE | {IE,GB}
>> 185.250.12.0/22 | SK | {SK,CZ}
>> 193.9.148.0/22 | GB | {GB,GR}
>> 193.36.92.0/22 | IE | {IE,US}
>> 193.37.36.0/22 | GB | {GB,IE,DE}
>> 193.109.168.0/22 | GB | {GB,US}
>> 193.141.4.0/22 | DE | {DE,NL}
>> 193.141.16.0/22 | DE | {DE,NL}
>> 193.141.28.0/22 | DE | {DE,NL}
>> 193.141.48.0/22 | DE | {DE,NL}
>> 193.141.68.0/22 | DE | {DE,NL}
>> 193.141.184.0/22 | DE | {DE,NL}
>> 193.219.228.0/22 | FR | {FR,LU,DE,NO}
>> 194.45.16.0/22 | DE | {DE,NL}
>> 194.45.28.0/22 | DE | {DE,NL}
>> 194.45.40.0/22 | DE | {DE,NL}
>> 194.45.60.0/22 | DE | {DE,NL}
>> 194.45.64.0/22 | DE | {DE,NL}
>> 194.45.72.0/22 | DE | {DE,NL}
>> 194.45.88.0/22 | DE | {DE,NL}
>> 194.45.108.0/22 | DE | {DE,NL}
>> 194.45.120.0/22 | DE | {DE,NL}
>> 194.45.128.0/22 | DE | {DE,NL}
>> 194.45.136.0/22 | DE | {DE,NL}
>> 194.45.156.0/22 | DE | {DE,NL}
>> 194.45.160.0/22 | DE | {DE,NL}
>> 194.45.172.0/22 | DE | {DE,NL}
>> 194.45.176.0/22 | DE | {DE,NL}
>> 194.45.188.0/22 | DE | {DE,NL}
>> 194.45.192.0/22 | DE | {DE,NL}
>> 194.45.204.0/22 | DE | {DE,NL}
>> 194.45.220.0/22 | DE | {DE,NL}
>> 194.45.228.0/22 | DE | {DE,NL}
>> 194.61.32.0/22 | BG | {BG,DE}
>> 194.120.28.0/22 | DE | {DE,NL}
>> 194.120.44.0/22 | DE | {DE,NL}
>> 194.120.48.0/22 | DE | {DE,NL}
>> 194.120.112.0/22 | DE | {DE,NL}
>> 194.120.120.0/22 | DE | {DE,NL}
>> 194.120.128.0/22 | DE | {DE,NL}
>> 194.120.160.0/22 | DE | {DE,NL}
>> 194.120.176.0/22 | DE | {DE,NL}
>> 194.120.224.0/22 | DE | {DE,NL}
>> 194.120.236.0/22 | DE | {DE,NL}
>> 194.120.252.0/22 | DE | {DE,NL}
>> 194.121.4.0/22 | DE | {DE,NL}
>> 194.121.12.0/22 | DE | {DE,NL}
>> 194.121.28.0/22 | DE | {DE,NL}
>> 194.121.40.0/22 | DE | {DE,NL}
>> 194.121.52.0/22 | DE | {DE,NL}
>> 194.121.68.0/22 | DE | {DE,NL}
>> 194.121.92.0/22 | DE | {DE,NL}
>> 194.121.168.0/22 | DE | {DE,NL}
>> 194.121.248.0/22 | DE | {DE,NL}
>> 194.147.36.0/22 | GB | {GB,NL}
>> 212.104.212.0/22 | IL | {IL,DE}
>> 213.232.72.0/22 | DK | {DK,MT}
>> 5.57.20.0/23 | GB | {GB,NL}
>> 45.11.172.0/23 | GB | {GB,EU}
>> 45.11.174.0/23 | GB | {GB,EU}
>> 46.183.104.0/23 | GB | {GB,IE}
>> 87.254.206.0/23 | CN | {CN,IN}
>> 89.219.134.0/23 | EE | {EE,EU}
>> 89.219.152.0/23 | EE | {EE,EU}
>> 91.201.212.0/23 | CH | {CH,AT,DE}
>> 91.226.144.0/23 | SE | {SE,PT,ES,DK}
>> 93.183.12.0/23 | DE | {DE,FI}
>> 185.129.122.0/23 | US | {US,DE,SG}
>> 185.175.206.0/23 | AE | {AE,BE}
>> 193.103.236.0/23 | EU | {EU,US,CA}
>> 193.141.62.0/23 | DE | {DE,NL}
>> 193.141.88.0/23 | DE | {DE,NL}
>> 193.141.102.0/23 | DE | {DE,NL}
>> 193.141.122.0/23 | DE | {DE,NL}
>> 193.141.124.0/23 | DE | {DE,NL}
>> 193.141.136.0/23 | DE | {DE,NL}
>> 193.141.178.0/23 | DE | {DE,NL}
>> 193.141.190.0/23 | DE | {DE,NL}
>> 193.141.228.0/23 | DE | {DE,NL}
>> 193.219.218.0/23 | FR | {FR,LU}
>> 193.219.236.0/23 | FR | {FR,LU}
>> 193.220.126.0/23 | FR | {FR,LU,DE,NO}
>> 194.45.4.0/23 | DE | {DE,NL}
>> 194.45.24.0/23 | DE | {DE,NL}
>> 194.45.38.0/23 | DE | {DE,NL}
>> 194.45.50.0/23 | DE | {DE,NL}
>> 194.45.58.0/23 | DE | {DE,NL}
>> 194.45.68.0/23 | DE | {DE,NL}
>> 194.45.92.0/23 | DE | {DE,NL}
>> 194.45.98.0/23 | DE | {DE,NL}
>> 194.45.124.0/23 | DE | {DE,NL}
>> 194.45.132.0/23 | DE | {DE,NL}
>> 194.45.140.0/23 | DE | {DE,NL}
>> 194.45.170.0/23 | DE | {DE,NL}
>> 194.45.182.0/23 | DE | {DE,NL}
>> 194.45.186.0/23 | DE | {DE,NL}
>> 194.45.198.0/23 | DE | {DE,NL}
>> 194.45.202.0/23 | DE | {DE,NL}
>> 194.45.218.0/23 | DE | {DE,NL}
>> 194.45.224.0/23 | DE | {DE,NL}
>> 194.45.234.0/23 | DE | {DE,NL}
>> 194.45.238.0/23 | DE | {DE,NL}
>> 194.88.142.0/23 | IE | {IE,EE}
>> 194.93.76.0/23 | AT | {AT,DE}
>> 194.120.18.0/23 | DE | {DE,NL}
>> 194.120.20.0/23 | DE | {DE,NL}
>> 194.120.26.0/23 | DE | {DE,NL}
>> 194.120.42.0/23 | DE | {DE,NL}
>> 194.120.52.0/23 | DE | {DE,NL}
>> 194.120.106.0/23 | DE | {DE,NL}
>> 194.120.124.0/23 | DE | {DE,NL}
>> 194.120.134.0/23 | DE | {DE,NL}
>> 194.120.146.0/23 | DE | {DE,NL}
>> 194.120.148.0/23 | DE | {DE,NL}
>> 194.120.166.0/23 | DE | {DE,NL}
>> 194.120.168.0/23 | DE | {DE,NL}
>> 194.120.174.0/23 | DE | {DE,NL}
>> 194.120.180.0/23 | DE | {DE,NL}
>> 194.120.186.0/23 | DE | {DE,NL}
>> 194.120.190.0/23 | DE | {DE,NL}
>> 194.120.228.0/23 | DE | {DE,NL}
>> 194.120.232.0/23 | DE | {DE,NL}
>> 194.120.250.0/23 | DE | {DE,NL}
>> 194.121.8.0/23 | DE | {DE,NL}
>> 194.121.24.0/23 | DE | {DE,NL}
>> 194.121.44.0/23 | DE | {DE,NL}
>> 194.121.60.0/23 | DE | {DE,NL}
>> 194.121.64.0/23 | DE | {DE,NL}
>> 194.121.88.0/23 | DE | {DE,NL}
>> 194.121.252.0/23 | DE | {DE,NL}
>> 194.150.168.0/23 | DE | {DE,IL,NL,BE,GB,CH,FR,CZ,SE,EU}
>> 195.39.208.0/23 | AT | {AT,CZ,DE,HU,PL,SK,RO}
>> 195.158.230.0/23 | CH | {CH,LI}
>> 195.189.220.0/23 | GB | {GB,IE,FR}
>> 31.133.47.0/24 | UA | {UA,RU}
>> 37.10.7.0/24 | HK | {HK,SG}
>> 45.91.19.0/24 | US | {US,GB}
>> 46.102.239.0/24 | US | {US,NL}
>> 46.255.120.0/24 | US | {US,GB}
>> 77.70.163.0/24 | SK | {SK,FR}
>> 78.41.187.0/24 | SG | {SG,CH}
>> 78.41.188.0/24 | US | {US,CA}
>> 79.143.48.0/24 | US | {US,GB,FR,NL,DE,SG,JP,AU}
>> 84.33.33.0/24 | DE | {DE,IT,US,GB,NL,FR,SG,JP,AU,AT,BR}
>> 86.106.23.0/24 | US | {US,NL}
>> 89.39.147.0/24 | US | {US,NL}
>> 89.185.155.0/24 | GB | {GB,IE}
>> 89.219.154.0/24 | EE | {EE,EU}
>> 89.219.161.0/24 | EE | {EE,EU}
>> 89.219.162.0/24 | EE | {EE,EU}
>> 89.219.168.0/24 | EE | {EE,EU}
>> 91.198.188.0/24 | IL | {IL,DE}
>> 91.205.43.0/24 | BE | {BE,FR}
>> 91.232.229.0/24 | AT | {AT,CH,LI}
>> 93.174.255.0/24 | SG | {SG,US,GB}
>> 185.21.134.0/24 | BE | {BE,NL}
>> 185.24.255.0/24 | EU | {EU,US,SG,BR,IR}
>> 185.38.240.0/24 | US | {US,GB,DE}
>> 185.42.188.0/24 | GB | {GB,FR}
>> 185.65.142.0/24 | GB | {GB,EU}
>> 185.73.223.0/24 | EU | {EU,US}
>> 185.91.9.0/24 | NL | {NL,GB,US}
>> 185.94.65.0/24 | LV | {LV,NL,RU}
>> 185.94.67.0/24 | LV | {LV,NL,RU}
>> 185.130.46.0/24 | NL | {NL,CA,US,DE,AU,JP}
>> 185.143.232.0/24 | DE | {DE,NL,JP,IR,GB,US}
>> 185.143.233.0/24 | NL | {NL,DE,JP,IR,GB,US}
>> 185.143.234.0/24 | JP | {JP,NL,DE,IR,GB,US}
>> 185.143.235.0/24 | GB | {GB,NL,DE,JP,IR,US}
>> 185.144.91.0/24 | DE | {DE,US}
>> 185.151.204.0/24 | NL | {NL,DE,US}
>> 185.168.0.0/24 | SE | {SE,DK,DE,GB}
>> 185.168.1.0/24 | SE | {SE,DK,DE,GB}
>> 185.190.82.0/24 | US | {US,GB}
>> 185.190.124.0/24 | CH | {CH,DE}
>> 188.210.93.0/24 | US | {US,NL}
>> 188.213.243.0/24 | US | {US,NL}
>> 188.241.193.0/24 | US | {US,NL}
>> 193.16.213.0/24 | GB | {GB,NL}
>> 193.32.101.0/24 | GB | {GB,IE}
>> 193.39.115.0/24 | DE | {DE,NL,GB,ES,FR,US}
>> 193.41.248.0/24 | US | {US,DE,HK}
>> 193.103.162.0/24 | EU | {EU,US,CA}
>> 193.103.163.0/24 | EU | {EU,US,CA}
>> 193.104.217.0/24 | SE | {SE,FI}
>> 193.111.228.0/24 | NL | {NL,GE,BE}
>> 193.141.21.0/24 | DE | {DE,NL}
>> 193.141.22.0/24 | DE | {DE,NL}
>> 193.141.25.0/24 | DE | {DE,NL}
>> 193.141.26.0/24 | DE | {DE,NL}
>> 193.141.52.0/24 | DE | {DE,NL}
>> 193.141.54.0/24 | DE | {DE,NL}
>> 193.141.56.0/24 | DE | {DE,NL}
>> 193.141.59.0/24 | DE | {DE,NL}
>> 193.141.66.0/24 | DE | {DE,NL}
>> 193.141.90.0/24 | DE | {DE,NL}
>> 193.141.93.0/24 | DE | {DE,NL}
>> 193.141.100.0/24 | DE | {DE,NL}
>> 193.141.105.0/24 | DE | {DE,NL}
>> 193.141.106.0/24 | DE | {DE,NL}
>> 193.141.108.0/24 | DE | {DE,NL}
>> 193.141.111.0/24 | DE | {DE,NL}
>> 193.141.120.0/24 | DE | {DE,NL}
>> 193.141.138.0/24 | DE | {DE,NL}
>> 193.141.142.0/24 | DE | {DE,NL}
>> 193.141.189.0/24 | DE | {DE,NL}
>> 193.218.114.0/24 | GP | {GP,MQ}
>> 193.219.212.0/24 | GB | {GB,DE}
>> 193.219.235.0/24 | FR | {FR,LU}
>> 193.219.239.0/24 | FR | {FR,LU}
>> 193.219.240.0/24 | FR | {FR,LU}
>> 193.220.123.0/24 | FR | {FR,LU,DE,NO}
>> 194.33.109.0/24 | GB | {GB,UA}
>> 194.34.161.0/24 | DE | {DE,NL}
>> 194.45.21.0/24 | DE | {DE,NL}
>> 194.45.23.0/24 | DE | {DE,NL}
>> 194.45.32.0/24 | DE | {DE,NL}
>> 194.45.35.0/24 | DE | {DE,NL}
>> 194.45.44.0/24 | DE | {DE,NL}
>> 194.45.47.0/24 | DE | {DE,NL}
>> 194.45.49.0/24 | DE | {DE,NL}
>> 194.45.57.0/24 | DE | {DE,NL}
>> 194.45.70.0/24 | DE | {DE,NL}
>> 194.45.95.0/24 | DE | {DE,NL}
>> 194.45.96.0/24 | DE | {DE,NL}
>> 194.45.102.0/24 | DE | {DE,NL}
>> 194.45.107.0/24 | DE | {DE,NL}
>> 194.45.134.0/24 | DE | {DE,NL}
>> 194.45.155.0/24 | DE | {DE,NL}
>> 194.45.164.0/24 | DE | {DE,NL}
>> 194.45.166.0/24 | DE | {DE,NL}
>> 194.45.168.0/24 | DE | {DE,NL}
>> 194.45.180.0/24 | DE | {DE,NL}
>> 194.45.185.0/24 | DE | {DE,NL}
>> 194.45.201.0/24 | DE | {DE,NL}
>> 194.45.216.0/24 | DE | {DE,NL}
>> 194.45.226.0/24 | DE | {DE,NL}
>> 194.120.25.0/24 | DE | {DE,NL}
>> 194.120.41.0/24 | DE | {DE,NL}
>> 194.120.54.0/24 | DE | {DE,NL}
>> 194.120.108.0/24 | DE | {DE,NL}
>> 194.120.117.0/24 | DE | {DE,NL}
>> 194.120.118.0/24 | DE | {DE,NL}
>> 194.120.127.0/24 | DE | {DE,NL}
>> 194.120.132.0/24 | DE | {DE,NL}
>> 194.120.145.0/24 | DE | {DE,NL}
>> 194.120.151.0/24 | DE | {DE,NL}
>> 194.120.165.0/24 | DE | {DE,NL}
>> 194.120.172.0/24 | DE | {DE,NL}
>> 194.120.185.0/24 | DE | {DE,NL}
>> 194.120.188.0/24 | DE | {DE,NL}
>> 194.120.235.0/24 | DE | {DE,NL}
>> 194.120.248.0/24 | DE | {DE,NL}
>> 194.121.1.0/24 | DE | {DE,NL}
>> 194.121.3.0/24 | DE | {DE,NL}
>> 194.121.10.0/24 | DE | {DE,NL}
>> 194.121.27.0/24 | DE | {DE,NL}
>> 194.121.47.0/24 | DE | {DE,NL}
>> 194.121.57.0/24 | DE | {DE,NL}
>> 194.121.58.0/24 | DE | {DE,NL}
>> 194.121.67.0/24 | DE | {DE,NL}
>> 194.121.91.0/24 | DE | {DE,NL}
>> 194.121.255.0/24 | DE | {DE,NL}
>> 194.153.74.0/24 | NL | {NL,IE,SE,DK,DE,AT,CH,BE,FR,ES,GB}
>> 195.14.23.0/24 | CH | {CH,GB}
>> 195.22.222.0/24 | PE | {PE,US}
>> 195.46.39.0/24 | DE | {DE,GB,NL,NZ,US}
>> 195.85.254.0/24 | IL | {IL,IM,GG}
>> 195.95.150.0/24 | NL | {NL,GB}
>> 2a01:800::/24 | DE | {DE,NL}
>> 2a01:ce80::/26 | NL | {NL,BE,LU,ZA,ZW,MG,MZ,NA,AU,BI,BW,AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY,GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM,CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT,DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ,IS,DK,NO,FI,SE,EE,LT,LV,RU,CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX,NZ,NC,TO,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2001:668::/29 | DE | {DE,SE,GR,NL,BE,AT,PL,IT,CH,NO,DK,CZ,US,CA,SK,ES,FR,GB,RO,HK,SG,IE}
>> 2001:730::/29 | NL | {NL,AT,CH,IE,HU,DE,PL,CZ,SK,RO}
>> 2001:4ce8::/29 | NL | {NL,DE}
>> 2a00:8a00::/29 | FI | {FI,DE,IN,SG,CN,US,BR}
>> 2a00:95c0::/29 | NL | {NL,DE}
>> 2a00:cee0::/29 | PS | {PS,FR,GB,DE,US}
>> 2a00:d120::/29 | NL | {NL,DE}
>> 2a01:ce90::/29 | CO | {CO,VE,EC,GY,PE,CL,AR,UY,PY,BO,BR,GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
>> 2a01:ce98::/29 | NZ | {NZ,NC,TO,AU,PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2a02:aa0::/29 | SE | {SE,DK}
>> 2a02:f180::/29 | FR | {FR,GB,RO,DE}
>> 2a02:fe00::/29 | NL | {NL,BE}
>> 2a03:f80::/29 | DE | {DE,CH,IT,GB,FR,US,HK,PL,CL,ES,IS,AT}
>> 2a04:a80::/29 | AE | {AE,AR,AT,AU,BE,BF,BG,BH,BR,BS,CA,CH,CI,CN,CO,CZ,DE,DK,DZ,EG,ES,GA,GB,GF,GN,GP,GR,HK,HU,ID,IE,IL,IN,IT,JP,KM,KR,KW,LU,LY,MA,ML,MQ,MX,MY,NC,NL,NO,PH,PL,PT,QA,RE,RO,RU,SA,SE,SG,SN,TH,TN,TR,TW,UA,US,VN,ZA,PE,PA,VE,CL,FR}
>> 2a04:11c0::/29 | FR | {FR,MQ,GP,GF}
>> 2a04:2980::/29 | GB | {GB,AE,IQ,DE}
>> 2a04:2ec0::/29 | JO | {JO,IQ,EG,BH,AE}
>> 2a04:4800::/29 | NL | {NL,GB}
>> 2a04:6e80::/29 | DK | {DK,SE,FI,NO,IR,NL,GB,US,CA,MX,BR,FR}
>> 2a04:7f00::/29 | BE | {BE,NL,LU}
>> 2a04:9200::/29 | US | {US,EU}
>> 2a04:ac80::/29 | NL | {NL,US}
>> 2a04:d200::/29 | AT | {AT,DE}
>> 2a04:db00::/29 | DE | {DE,GB,NL,BE}
>> 2a04:e4c0::/29 | NL | {NL,GB,DE,FR,DK,CZ,PL,RO}
>> 2a05:e580::/29 | SE | {SE,US,GB}
>> 2a06:1700::/29 | IS | {IS,RO,FI}
>> 2a07:4dc0::/29 | NL | {NL,RU,US}
>> 2a07:fcc0::/29 | IE | {IE,US}
>> 2a0b:39c0::/29 | IE | {IE,DE}
>> 2a0b:7e00::/29 | US | {US,DK}
>> 2a0e:fa00::/29 | NL | {NL,CH}
>> 2a01:ce84::/30 | GR | {GR,GB,IE,KE,ET,ER,UG,NG,GH,SL,GM}
>> 2a0f:7780::/30 | DK | {DK,DE,RO}
>> 2a0f:7784::/30 | DK | {DK,DE,RO}
>> 2a01:ce88::/31 | CI | {CI,BJ,SN,GA,TD,MA,DZ,TN,LY,ES,PT,FR,CH,IT,MT}
>> 2a01:ce8c::/31 | DE | {DE,PL,CZ,AT,SK,HU,RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
>> 2a01:ce8e::/31 | IS | {IS,DK,NO,FI,SE,EE,LT,LV,RU}
>> 2a01:ce94::/31 | GT | {GT,CR,SV,NI,HN,PA,BZ,PR,DO,TT,CU,CA,US,MX}
>> 2a01:ce9c::/31 | PK | {PK,AF,IN,BD,LK,SG,MY,TH,ID,KH,VN,PH,HK,TW,CN,KR,KP,JP}
>> 2a03:9d40::/31 | GB | {GB,NL,FR,DE,US,RU,CH}
>> 2001:680::/32 | DE | {DE,NL}
>> 2001:730::/32 | AT | {AT,CH,CZ,DE,HU,IE,NL,PL,RO,SK}
>> 2001:ad0::/32 | EE | {EE,DE,SE,RU,LT,LV,PL}
>> 2001:1ad0::/32 | AT | {AT,DE,NL}
>> 2a00:1888::/32 | FR | {FR,GB,DE,IT,CH,ES}
>> 2a00:80a0::/32 | AU | {AU,AT,BE,BR,CA,CL,CN,CZ,DK,FI,FR,DE,HK,HU,IN,IT,JP,MX,NL,NO,PL,SG,ZA,ES,SZ,SE,CH,TR,GB,AE,US}
>> 2a00:96c0::/32 | SE | {SE,DE,NO,DK,FR,GB}
>> 2a00:a2e0::/32 | DE | {DE,NL}
>> 2a00:bf60::/32 | CH | {CH,DE}
>> 2a00:e8a0::/32 | DE | {DE,US,IE,IN,IT,JP,PR,SG}
>> 2a01:20::/32 | FR | {FR,BE,DE}
>> 2a01:258::/32 | IE | {IE,GB}
>> 2a01:6dc0::/32 | RU | {RU,MD}
>> 2a01:8200::/32 | FR | {FR,GB}
>> 2a01:a0a0::/32 | DE | {DE,US,RU}
>> 2a01:ce82::/32 | ZA | {ZA,ZW,MG,MZ,NA,AU,BI,BW}
>> 2a01:ce83::/32 | AE | {AE,BH,EG,SA,KW,JO,YE,TR,IL,CY,LB,SY}
>> 2a01:ce85::/32 | GB | {GB,IE}
>> 2a01:ce87::/32 | KE | {KE,ET,ER,UG,NG,GH,SL,GM}
>> 2a01:ce89::/32 | ES | {ES,PT,FR,CH,IT,MT}
>> 2a01:ce8d::/32 | RS | {RS,SI,HR,BA,ME,MK,BG,RO,UA,GE,AZ,BY,KG,KZ,UZ}
>> 2a01:ce8f::/32 | EE | {EE,LT,LV,RU}
>> 2a01:ce95::/32 | CA | {CA,US,MX}
>> 2a01:ce9d::/32 | SG | {SG,MY,TH,ID,KH,VN,PH}
>> 2a01:ce9e::/32 | HK | {HK,TW,CN}
>> 2a01:ce9f::/32 | KR | {KR,KP,JP}
>> 2a02:3d0::/32 | GB | {GB,IE,CH,NL,DE,SE,FR,IT,ES,AT}
>> 2a02:9f8::/32 | GB | {GB,DE,FR}
>> 2a02:1340::/32 | GB | {GB,IE}
>> 2a02:23e0::/32 | FR | {FR,ES}
>> 2a02:48c0::/32 | AM | {AM,HR,CZ,DE,GE,GR,GL,IE,IT,JO,NL,PL,PT,RO,ES,SE,CH,GB,IL,FR}
>> 2a02:51e0::/32 | NL | {NL,GB}
>> 2a02:70c0::/32 | LU | {LU,FR,BE,DE,NL}
>> 2a02:7200::/32 | RU | {RU,LV,LT,ES,IR,LB,KZ,TJ,TM}
>> 2a02:7c40::/32 | DE | {DE,CH}
>> 2a03:35c0::/32 | DE | {DE,CN,GB,SG,BE,US}
>> 2a03:a7a0::/32 | RU | {RU,US}
>> 2a03:ae00::/32 | GB | {GB,NL}
>> 2a03:bdc0::/32 | FR | {FR,DE,SE,GB,NL,AT,BE,CH,IT,DK,NO,IL,US,ES}
>> 2a03:da80::/32 | AT | {AT,DE}
>> 2a03:eec0::/32 | GB | {GB,NL,DE,CH,FR}
>> 2a07:e00::/32 | BZ | {BZ,SE}
>> 2a07:68c0::/32 | US | {US,EU}
>> 2a0a:3980::/32 | US | {US,DE,HK,JP}
>> 2a0c:8fc1::/32 | SG | {SG,JP}
>> 2a0d:1a45::/32 | EU | {EU,SE,AQ,US}
>> 2a0e:e42::/32 | US | {US,GB}
>> 2a02:6600:2000::/36 | FR | {FR,NL,NO}
>> 2a07:e02:1000::/36 | NL | {NL,CA,US,DE,JP,AU}
>> 2a03:d5c0:1b00::/40 | GB | {GB,NL}
>> 2a07:1c44:1400::/40 | NL | {NL,CA,US}
>> 2a06:7a07::/43 | US | {US,GB,FR,NL,DE,SG,JP,AU}
>> 2001:67c:1020::/47 | AT | {AT,RU}
>> 2001:67c:268::/48 | CH | {CH,US}
>> 2001:67c:3fc::/48 | CH | {CH,AT,DE}
>> 2001:67c:2778::/48 | DE | {DE,GB,NL,NZ,US}
>> 2001:7f8:66::/48 | AT | {AT,CH,LI}
>> 2a00:fd80:aaaa::/48 | AU | {AU,GB}
>> 2a02:6604:3::/48 | NL | {NL,FR}
>> 2a06:7245::/48 | US | {US,DE}
>> 2a07:e00:b::/48 | US | {US,CA,AU,JP,NL,DE}
>> 2a09:be40:1170::/48 | EU | {EU,US}
>> 2a0f:4400::/48 | IE | {IE,FR,GB}
>> (596 rows)
>
> I'll reply more detailled to your answer within the next days, Deo volente. :-)
>
> Thanks, and best regards,
> Peter Müller
next prev parent reply other threads:[~2021-05-07 10:48 UTC|newest]
Thread overview: 5+ messages / expand[flat|nested] mbox.gz Atom feed top
2021-05-03 20:56 How should location-importer.in deal with RIR objects having multiple distinct "country" fields? Peter Müller
2021-05-04 8:07 ` Michael Tremer
2021-05-06 21:06 ` List of IP networks having more than one country assigned to (was: Re: How should location-importer.in deal with RIR objects having multiple distinct "country" fields?) Peter Müller
2021-05-07 10:48 ` Michael Tremer [this message]
2021-05-14 15:59 ` List of IP networks having more than one country assigned to Peter Müller
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=885A4C79-EB22-4D14-92F9-A7A5688C451A@ipfire.org \
--to=michael.tremer@ipfire.org \
--cc=location@lists.ipfire.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox