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.