IP2Location™ ZIP Code to Metro

For customer only

IP2Location™ ZIP Code to Metro is a free data offered for our valued customer. This data enables you to map the ZIP code information to metro information. The data is provided in CSV format, so that you can easily import into any database of your choice.

 

Product Features
Last Update 02/06/2014
Database Format CSV Text File (Comma Delimited)

 

Database Fields
Name Type Description
zip_code VARCHAR(5) ZIP Code
metro_code VARCHAR(3) Metro code
metro_desc VARCHAR(64) Metro description

 

MySQL Statement

CREATE TABLE `ip2location_zipcode_metro`(
	`zip_code` VARCHAR(5),
	`metro_code` VARCHAR(3),
	`metro_desc` VARCHAR(64),
	INDEX `idx_zip_code` (`zip_code`),
	INDEX `idx_metro_code` (`metro_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-ZIPCODE-METRO.CSV' INTO TABLE `ip2location_zipcode_metro`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;

 

MSSQL Statement

CREATE TABLE [ip2location].[dbo].[ip2location_zipcode_metro](
   [zip_code] nvarchar(5),
   [metro_code] nvarchar(3) NOT NULL,
   [metro_desc] nvarchar(64) NOT NULL,
) ON [PRIMARY]
GO

CREATE INDEX [idx_zip_code] ON [ip2location].[dbo].[ip2location_zipcode_metro]([zip_code]) ON [PRIMARY]
GO

CREATE INDEX [idx_metro_code] ON [ip2location].[dbo].[ip2location_zipcode_metro]([metro_code]) ON [PRIMARY]
GO
			

 

License Information

IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.

 

Thank you for downloading

Sharing this great stuff to your friends!

Or share it on your blog or web page:

Free IP2Location geolocation resources available at <a href="http://www.ip2location.com">http://www.ip2location.com</a>
Copy & paste this text as HTML.