National provincial and municipal database, with pinyin, abbreviation, Administrative Code, ZIP code, etc.

Preface

Just now on the internet to inquire about the national provinces and Cities database, compared to the pit is a relatively comprehensive data, a comprehensive fee, the heart is very uncomfortable.

But in the end, I got it. A slightly better national provincial and municipal database, and with left, simple spell, abbreviation, pinyin, Administrative Code, ZIP code, city three loadline data.

Here I share with you, hope to give some students need to help.

picture Effect Show

Data Sharing

Create a database script

CREATE TABLE [dbo].[ Region](    [Id] [int] NULL,    [Name] [nvarchar]( +)NULL,    [ParentID] [int] NULL,    [ShortName] [nvarchar]( +)NULL,    [LevelType] [int] NULL,    [Citycode] [varchar]( -)NULL,    [ZipCode] [varchar]( -)NULL,    [Mergername] [nvarchar]( -)NULL,    [Lng] [float] NULL,    [Lat] [float] NULL,    [Pinyin] [varchar]( -)NULL)  on [PRIMARY]GO

Populating data

Database Attachments

Link: http://pan.baidu.com/s/1pLREvZt Password: oyv6

Summary

Finally nothing to say, hope to help you.

National provincial and municipal database, with pinyin, abbreviation, Administrative Code, ZIP code, etc.