IP2Location™ LITE IP-ASN Database

Introduktion Funktioner Databasefelter Databaseopsætning Eksempeldatabase

Introduktion

ASN Database

Denne database giver en reference til bestemmelse af det autonome system og nummer (ASN). Et autonomt system (AS) er en samling af tilsluttede IP-routing-præfikser (IP), der styres af en eller flere netværksoperatører som en enkelt administrativ enhed i routingpolitik.

Det er gratis til personlig eller kommerciel brug med tilskrivning krævet ved at nævne brugen af ​​disse data som følger,

Lad os udforske denne database, som nu giver en værdifuld ressource af geolokaliseringsdata gratis!

Tilmeld dig gratis

Funktioner

Oversætter IP-adresse til autonomt system (AS) og autonomt systemnummer (ASN).

Nuværende version July 2025
IPv4 Databasestørrelse BIN: 132.34 MB
CSV: 103.1 MB (1,358,173 Rækker)
MMDB: 10.21 MB
IPv6 Databasestørrelse BIN: 221.2 MB
CSV: 97.78 MB (825,458 Rækker)
Array Binær (BIN)
ASCII-tekstfil (CSV)
MMDB

Databasefelter

Navn Type Beskrivelse
ip_from INT (10)† / DECIMAL (39,0)†† Første IP-adresse viser netblock.
ip_to INT (10)† / DECIMAL (39,0)†† Sidste IP-adresse viser netblock.
cidr VARCHAR(43) IP-adresseinterval i CIDR.
asn INT(10) Autonomt systemnummer (ASN).
as VARCHAR(256) Navn på autonomt system (AS).

† IPv4
†† IPv6

Databaseopsætning

Nedenfor er trinene til opsætning af databasen til både IPv4- og IPv6-data.

Opret database
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_asn`(
	`ip_from` INT(10) UNSIGNED,
	`ip_to` INT(10) UNSIGNED,
	`cidr` VARCHAR(43),
	`asn` VARCHAR(10),
	`as` VARCHAR(256),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Importér database
LOAD DATA LOCAL
	INFILE 'IP2LOCATION-LITE-ASN.CSV'
INTO TABLE
	`ip2location_asn`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;
Opret database
CREATE DATABASE ip2location
GO

USE ip2location
GO

CREATE TABLE [ip2location].[dbo].[ip2location_asn](
	[ip_from] bigint NOT NULL,
	[ip_to] bigint NOT NULL,
	[cidr] nvarchar(43) NOT NULL,
	[asn] nvarchar(10) NOT NULL,
	[as] nvarchar(256) NOT NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_asn]([ip_to]) ON [PRIMARY]
GO
Importér database
BULK INSERT [ip2location].[dbo].[ip2location_asn]
FROM '{PATH TO IP2LOCATION-LITE-ASN.CSV}'
WITH
(
	FORMATFILE = '{PATH TO ASN.FMT}'
)
GO

BEMÆRK: Du bliver nødt til at kopiere FMT-koden nedenfor og gemme den som en fil med navnetASN.FMT på din computer. 

12.0
6
1 SQLCHAR 0 1 "\"" 0 first_double_quote  Latin1_General_CI_AI
2 SQLCHAR 0 20 "\",\"" 1 ip_from "",
3 SQLCHAR 0 20 "\",\"" 2 ip_to "",
4 SQLCHAR 0 43 "\",\"" 3 cidr Latin1_General_CI_AI,
5 SQLCHAR 0 10 "\",\"" 4 asn Latin1_General_CI_AI,
6 SQLCHAR 0 256 "\",\"" 5 as Latin1_General_CI_AI
Opret database
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_asn(
	ip_from bigint NOT NULL,
	ip_to bigint NOT NULL,
	cidr character varying(43) NOT NULL,
	asn character varying(10) NOT NULL,
	as character varying(256) NOT NULL,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
Importér database
COPY ip2location_asn FROM 'IP2LOCATION-LITE-ASN.CSV' WITH CSV QUOTE AS '"';
Opret database
CREATE DATABASE ip2location;
USE ip2location;
CREATE TABLE `ip2location_asn_ipv6`(
	`ip_from` DECIMAL(39,0) UNSIGNED,
	`ip_to` DECIMAL(39,0) UNSIGNED,
	`cidr` VARCHAR(43),
	`asn` VARCHAR(10),
	`as` VARCHAR(256),
	PRIMARY KEY (`ip_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Importér database
LOAD DATA LOCAL
	INFILE 'IP2LOCATION-LITE-ASN.IPV6.CSV'
INTO TABLE
	`ip2location_asn_ipv6`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;
Opret database
CREATE DATABASE ip2location
GO

USE ip2location
GO

CREATE TABLE [ip2location].[dbo].[ip2location_asn_ipv6](
	[ip_from] char(39) NOT NULL,
	[ip_to] char(39) NOT NULL,
	[cidr] nvarchar(43) NOT NULL,
	[asn] nvarchar(10) NOT NULL,
	[as] nvarchar(256) NOT NULL
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_asn_ipv6]([ip_to]) ON [PRIMARY]
GO
Importér database
BULK INSERT [ip2location].[dbo].[ip2location_asn_ipv6]
FROM '{PATH TO IP2LOCATION-LITE-ASN.IPV6.CSV}'
WITH
(
	FORMATFILE = '{PATH TO ASN.FMT}'
)
GO

BEMÆRK: Du bliver nødt til at kopiere FMT-koden nedenfor og gemme den som en fil med navnetASN.FMT på din computer. Den første linje i FMT-koden angiver versionen af ​​bcp. Skift versionen i henhold til din MS-SQL installeret. 

12.0
6
1 SQLCHAR 0 1 "\"" 0 first_double_quote  Latin1_General_CI_AI
2 SQLCHAR 0 39 "\",\"" 1 ip_from "",
3 SQLCHAR 0 39 "\",\"" 2 ip_to "",
4 SQLCHAR 0 43 "\",\"" 3 cidr Latin1_General_CI_AI,
5 SQLCHAR 0 10 "\",\"" 4 asn Latin1_General_CI_AI,
6 SQLCHAR 0 256 "\",\"" 5 as Latin1_General_CI_AI
Opret database
CREATE DATABASE ip2location WITH ENCODING 'UTF8';
\c ip2location
CREATE TABLE ip2location_asn_ipv6(
	ip_from decimal(39,0) NOT NULL,
	ip_to decimal(39,0) NOT NULL,
	cidr character varying(43) NOT NULL,
	asn character varying(10) NOT NULL,
	as character varying(256) NOT NULL,
	CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)
);
Importér database
COPY ip2location_asn_ipv6 FROM 'IP2LOCATION-LITE-ASN.IPV6.CSV' WITH CSV QUOTE AS '"';

Eksempeldatabase

Nedenfor er prøvedatabasen til dine referencer. 


"ip_from","ip_to","cidr","asn","as"
"0","16777215","0.0.0.0/8","-","-"
"16777216","16777471","1.0.0.0/24","13335","CloudFlare Inc."
"16777472","16777727","1.0.1.0/24","-","-"
"16777728","16778239","1.0.2.0/23","-","-"
"16778240","16779263","1.0.4.0/22","38803","GTelecom Pty Ltd"
"16779264","16781311","1.0.8.0/21","-","-"
"16781312","16781567","1.0.16.0/24","2519","Arteria Networks Corporation"
"16781568","16781823","1.0.17.0/24","-","-"
"16781824","16782335","1.0.18.0/23","-","-"
"16782336","16783359","1.0.20.0/22","-","-"
"16783360","16785407","1.0.24.0/21","-","-"
"16785408","16793599","1.0.32.0/19","-","-"
"16793600","16809983","1.0.64.0/18","18144","Enecom Inc."
"16809984","16826367","1.0.128.0/18","23969","TOT Public Company Limited"
"16826368","16827391","1.0.192.0/22","23969","TOT Public Company Limited"
"16827392","16827903","1.0.196.0/23","23974","Ministry of Education - EMISC"
"16827904","16828415","1.0.198.0/23","23969","TOT Public Company Limited"
"16828416","16830463","1.0.200.0/21","23969","TOT Public Company Limited"
"16830464","16834559","1.0.208.0/20","23969","TOT Public Company Limited"
"16834560","16842751","1.0.224.0/19","23969","TOT Public Company Limited"
"16842752","16843007","1.1.0.0/24","-","-"
"16843008","16843263","1.1.1.0/24","13335","CloudFlare Inc."
"16843264","16843775","1.1.2.0/23","-","-"
"16843776","16844799","1.1.4.0/22","-","-"
"16844800","16845055","1.1.8.0/24","149511","Yamu Technologies Co. Ltd."
"16845056","16845311","1.1.9.0/24","-","-"
"16845312","16845823","1.1.10.0/23","-","-"
"16845824","16846847","1.1.12.0/22","-","-"
"16846848","16850943","1.1.16.0/20","-","-"
"16850944","16859135","1.1.32.0/19","-","-"
"16859136","16867327","1.1.64.0/19","2519","Arteria Networks Corporation"
"16867328","16871423","1.1.96.0/20","2519","Arteria Networks Corporation"
"16871424","16873471","1.1.112.0/21","2519","Arteria Networks Corporation"
"16873472","16874495","1.1.120.0/22","2519","Arteria Networks Corporation"
"16874496","16875007","1.1.124.0/23","2519","Arteria Networks Corporation"
"16875008","16875263","1.1.126.0/24","2519","Arteria Networks Corporation"
"16875264","16875519","1.1.127.0/24","-","-"
"16875520","16908287","1.1.128.0/17","23969","TOT Public Company Limited"
"16908288","16909311","1.2.0.0/22","-","-"
"16909312","16909567","1.2.4.0/24","24151","China Internet Network Infomation Center"
"16909568","16909823","1.2.5.0/24","-","-"
"16909824","16910335","1.2.6.0/23","-","-"
"16910336","16912383","1.2.8.0/21","-","-"
"16912384","16916479","1.2.16.0/20","-","-"
"16916480","16924671","1.2.32.0/19","-","-"
"16924672","16941055","1.2.64.0/18","-","-"
"16941056","16973823","1.2.128.0/17","23969","TOT Public Company Limited"
"16973824","17039359","1.3.0.0/16","-","-"
"17039360","17072127","1.4.0.0/17","-","-"
"17072128","17104895","1.4.128.0/17","23969","TOT Public Company Limited"
"17104896","17170431","1.5.0.0/16","4725","SOFTBANK Corp. Open Data Network."
"17170432","17203199","1.6.0.0/17","9583","Sify Limited"
"17203200","17205247","1.6.128.0/21","9583","Sify Limited"
"17205248","17205503","1.6.136.0/24","132215","Powergrid Teleservices Limited"
"17205504","17205759","1.6.137.0/24","9583","Sify Limited"
"17205760","17206271","1.6.138.0/23","9583","Sify Limited"
"17206272","17207295","1.6.140.0/22","9583","Sify Limited"
"17207296","17211391","1.6.144.0/20","9583","Sify Limited"
"17211392","17219583","1.6.160.0/19","9583","Sify Limited"
"17219584","17223679","1.6.192.0/20","9583","Sify Limited"
"17223680","17225727","1.6.208.0/21","9583","Sify Limited"
"17225728","17226239","1.6.216.0/23","9583","Sify Limited"
"17226240","17226495","1.6.218.0/24","9583","Sify Limited"
"17226496","17226751","1.6.219.0/24","137130","Punjab National Bank"
"17226752","17227775","1.6.220.0/22","9583","Sify Limited"
"17227776","17228287","1.6.224.0/23","9583","Sify Limited"
"17228288","17228799","1.6.226.0/23","132215","Powergrid Teleservices Limited"
"17228800","17229055","1.6.228.0/24","132215","Powergrid Teleservices Limited"
"17229056","17229311","1.6.229.0/24","4755","Tata Communications Formerly VSNL is Leading ISP"
"17229312","17229567","1.6.230.0/24","4755","Tata Communications Formerly VSNL is Leading ISP"
"17229568","17229823","1.6.231.0/24","9583","Sify Limited"
"17229824","17231871","1.6.232.0/21","9583","Sify Limited"
"17231872","17235967","1.6.240.0/20","9583","Sify Limited"
"17235968","17236223","1.7.0.0/24","9583","Sify Limited"
"17236224","17236479","1.7.1.0/24","-","-"
"17236480","17236735","1.7.2.0/24","-","-"
"17236736","17236991","1.7.3.0/24","9583","Sify Limited"
"17236992","17238015","1.7.4.0/22","9583","Sify Limited"
"17238016","17240063","1.7.8.0/21","9583","Sify Limited"
"17240064","17244159","1.7.16.0/20","9583","Sify Limited"
"17244160","17246207","1.7.32.0/21","9583","Sify Limited"
"17246208","17246463","1.7.40.0/24","9583","Sify Limited"
"17246464","17246719","1.7.41.0/24","-","-"
"17246720","17247231","1.7.42.0/23","-","-"
"17247232","17248255","1.7.44.0/22","-","-"
"17248256","17252351","1.7.48.0/20","-","-"
"17252352","17268735","1.7.64.0/18","-","-"
"17268736","17270783","1.7.128.0/21","9583","Sify Limited"
"17270784","17271807","1.7.136.0/22","9583","Sify Limited"
"17271808","17272319","1.7.140.0/23","9583","Sify Limited"
"17272320","17272575","1.7.142.0/24","132215","Powergrid Teleservices Limited"
"17272576","17272831","1.7.143.0/24","9583","Sify Limited"
"17272832","17273855","1.7.144.0/22","9583","Sify Limited"
"17273856","17274367","1.7.148.0/23","9583","Sify Limited"
"17274368","17274623","1.7.150.0/24","9583","Sify Limited"
"17274624","17274879","1.7.151.0/24","132215","Powergrid Teleservices Limited"
"17274880","17276927","1.7.152.0/21","9583","Sify Limited"
"17276928","17277183","1.7.160.0/24","9583","Sify Limited"
"17277184","17277439","1.7.161.0/24","132215","Powergrid Teleservices Limited"
"17277440","17277695","1.7.162.0/24","132215","Powergrid Teleservices Limited"
"17277696","17277951","1.7.163.0/24","9583","Sify Limited"

Licens

Gennemse generelle vilkår og betingelser for databaselicenser.

IP2Location IP-adresse Geolocation Database

I Commercial Edition får du meget mere end bare IP-adresseopslag:

  • Bedre datanøjagtighed
  • Adgang til opdateret database
  • Yderligere supportniveau via e-mail
Opgrader nu
Lær mere
Product Upgrade
Sign Up Pop Out

Geolokalisér Dine Besøgendes Lokation

Forbedr dine applikationer med essentielle geolokaliseringsdata ved at bruge vores GRATIS databaser.

Get Started For Free Now