中国城市经纬度数据

  前言暂时空缺... ...

–
– 表的结构 `citylocation`
–
CREATE TABLE IF NOT EXISTS `citylocation` (
`proname` varchar(20) NOT NULL,
`propinyin` varchar(20) NOT NULL,
`cityname` varchar(20) NOT NULL,
`citypin` varchar(20) NOT NULL,
`lon` double NOT NULL,
`lat` double NOT NULL,
`tag` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into CityLocation(proname,propinyin,cityname,citypin,lon,lat)
values(‘安徽省’,'AnHuiSheng’,'合肥’,'HeFei’,117.17,31.52);
insert into CityLocation(proname,propinyin,cityname,citypin,lon,lat)
values(‘安徽省’,'AnHuiSheng’,'安庆’,'AnQing’,117.02,30.31);