(注：知识浩瀚，本人能力有限，定有不足，望各位多多指点，不足之处请指出，俺好随时改进，小的无以为报，在此鞠躬致谢…)
对于车牌归属地信息所建数据表，其中行政区域代码信息从国家统计局官网获取(http://www.stats.gov.cn/tjsj/tjbz/xzqhdm/) ；车牌归属地对应信息从百度文库获取。数据可能与当前情况有所出入，请自行修改即可。（postgresql为本次sql载体）
省份信息表：
truncate table province_manage_tb
drop table province_manage_tb
-- 省份信息表 --
CREATE TABLE province_manage_tb
(
province_id character varying(6) NOT NULL, --省份id
province_name character varying(50), --省份名称
provincial_capital_id character varying(6), --省会id
create_time bigint, --创建时间
update_time bigint, --更新时间
CONSTRAINT province_manage_tb_pkey PRIMARY KEY (province_id)
)
select * from province_manage_tb
-- 插入中国34个省份 --
insert into province_manage_tb(province_id,province_name,provincial_capital_id)
select '110000','北京市','110100' union all
select '120000','天津市','120100' union all
select '130000','河北省','130100' union all
select '140000','山西省','140100' union all
select '150000','内蒙古自治区','150100' union all
select '210000','辽宁省','210100' union all
select '220000','吉林省','220100' union all
select '230000','黑龙江省','230100' union all
select '310000','上海市','310100' union all
select '320000','江苏省','320100' union all
select '330000','浙江省','330100' union all
select '340000','安徽省','340100' union all
select '350000','福建省','350100' union all
select '360000','江西省','360100' union all
select '370000','山东省','370100' union all
select '410000','河南省','410100' union all
select '420000','湖北省','420100' union all
select '430000','湖南省','430100' union all
select '440000','广东省','440100' union all
select '450000','广西壮族自治区','450100' union all
select '460000','海南省','460100' union all
select '500000','重庆市','500100' union all
select '510000','四川省','510100' union all
select '520000','贵州省','520100' union all
select '530000','云南省','530100' union all
select '540000','西藏自治区','540100' union all
select '610000','陕西省','610100' union all
select '620000','甘肃省','620100' union all
select '630000','青海省','630100' union all
select '640000','宁夏回族自治区','640100' union all
select '650000','新疆维吾尔自治区','650100' union all
select '710000','台湾省','710100' union all
select '810000','香港特别行政区','810100' union all
select '820000','澳门特别行政区','820100'
城市信息表：
truncate table city_manage_tb
drop table city_manage_tb
-- 城市信息表 --
CREATE TABLE city_manage_tb
(
city_id character varying(6) NOT NULL, --城市id
province_id character varying(6), --省份id
city_name character varying(50), --城市名称
city_lon numeric(10,6), --经度
city_lat numeric(10,6), --纬度
create_time bigint, --创建时间
update_time bigint, --更新时间
CONSTRAINT city_manage_tb_pkey PRIMARY KEY (city_id)
)
select * from city_manage_tb
insert into city_manage_tb(city_id,province_id,city_name,city_lon,city_lat)
-- 河北省 --
select '130100','130000','石家庄',114.4995,38.1006 union all
select '130200','130000','唐山',118.4766,39.6826 union all
select '130300','130000','秦皇岛',119.2126,40.0232 union all
select '130400','130000','邯郸',114.4775,36.535 union all
select '130500','130000','邢台',114.8071,37.2821 union all
select '130600','130000','保定',115.0488,39.0948 union all
select '130700','130000','张家口',115.1477,40.8527 union all
select '130800','130000','承德',117.5757,41.4075 union all
select '130900','130000','沧州',116.8286,38.2104 union all
select '131000','130000','廊坊',116.521,39.0509 union all
select '131100','130000','衡水',115.8838,37.7161 union all
-- 辽宁省 --
select '210100','210000','沈阳',123.1238,42.1216 union all
select '210200','210000','大连',122.2229,39.4409 union all
select '210300','210000','鞍山',122.85,41.12 union all
select '210400','210000','抚顺',123.97,41.97 union all
select '210500','210000','本溪',123.73,41.30 union all
select '210600','210000','丹东',124.37,40.13 union all
select '210700','210000','锦州',121.15,41.13 union all
select '210800','210000','营口',122.18,40.65 union all
select '210900','210000','阜新',121.65,42.00 union all
select '211000','210000','辽阳',123.17,41.28 union all
select '211100','210000','盘锦',122.03,41.07 union all
select '211200','210000','铁岭',123.85,42.32 union all
select '211300','210000','朝阳',120.42,41.58 union all
select '211400','210000','葫芦岛',120.58,40.44 union all
-- 安徽 --
select '340100','340000','合肥',117.29,32.0581 union all
select '340200','340000','芜湖',118.38,31.33 union all
select '340300','340000','蚌埠',117.34,32.93 union all
select '340400','340000','淮南',116.98,32.62 union all
select '340500','340000','马鞍山',118.48,31.56 union all
select '340600','340000','淮北',116.77,33.97 union all
select '340700','340000','铜陵',117.82,30.93 union all
select '340800','340000','安庆',117.03,30.52 union all
select '341000','340000','黄山',118.33,29.71 union all
select '341100','340000','滁州',118.31,32.33 union all
select '341200','340000','阜阳',115.81,32.89 union all
select '341300','340000','宿州',116.97,33.63 union all
select '341500','340000','六安',116.49,31.73 union all
select '341600','340000','亳州',115.78,33.84 union all
select '341700','340000','池州',117.49,30.66 union all
select '341800','340000','宣城',118.76,30.94 union all
select '340181','340000','巢湖',117.87,31.62 union all
-- 江苏 --
select '320100','320000','南京',118.78,32.04 union all
select '320200','320000','无锡',120.3442,31.5527 union all
select '320300','320000','徐州',117.5208,34.3268 union all
select '320400','320000','常州',119.4543,31.5582 union all
select '320500','320000','苏州',120.6519,31.3989 union all
select '320600','320000','南通',121.1023,32.1625 union all
select '320700','320000','连云港',119.1248,34.552 union all
select '320800','320000','淮安',118.927,33.4039 union all
select '320900','320000','盐城',120.2234,33.5577 union all
select '321000','320000','扬州',119.4653,32.8162 union all
select '321100','320000','镇江',119.4763,31.9702 union all
select '321200','320000','泰州',120.0586,32.5525 union all
select '321300','320000','宿迁',118.5535,33.7775 union all
-- 湖北 --
select '420100','420000','武汉',114.3896,30.6628 union all
select '420200','420000','黄石',115.03,30.20 union all
select '420300','420000','十堰',110.78,32.65 union all
select '420500','420000','宜昌',111.28,30.70 union all
select '420600','420000','襄阳',112.20,32.08 union all
select '420700','420000','鄂州',114.88,30.40 union all
select '420800','420000','荆门',112.20,31.03 union all
select '420900','420000','孝感',113.92,30.93 union all
select '421000','420000','荆州',112.23,30.33 union all
select '421100','420000','黄冈',114.87,30.45 union all
select '421200','420000','咸宁',114.32,29.85 union all
select '421300','420000','随州',113.37,31.72 union all
select '422800','420000','恩施土家族苗族自治州',109.47,30.3 union all
select '429004','420000','仙桃',113.45,30.37 union all
select '429005','420000','潜江',112.88,30.42 union all
select '429021','420000','神农架林区',110.67,31.75 union all
select '429006','420000','天门',113.17,30.67 union all
-- 山西 --
select '140100','140000','太原',112.55,37.87 union all
select '140200','140000','大同',113.30,40.08 union all
select '140300','140000','阳泉',113.57,37.85 union all
select '140400','140000','长治',113.12,36.20 union all
select '140500','140000','晋城',112.83,35.50 union all
select '140600','140000','朔州',112.43,39.33 union all
select '140700','140000','晋中',112.75,37.68 union all
select '140800','140000','运城',110.98,35.02 union all
select '140900','140000','忻州',112.73,38.42 union all
select '141000','140000','临汾',111.52,36.08 union all
select '141100','140000','吕梁',111.13,37.52 union all
-- 吉林 --
select '220100','220000','长春',125.19,43.54 union all
select '220200','220000','吉林',126.33,43.52 union all
select '220300','220000','四平',124.22,43.10 union all
select '220400','220000','辽源',125.09,42.54 union all
select '220500','220000','通化',125.56,41.43 union all
select '220600','220000','白山',126.26,41.56 union all
select '220700','220000','松原',124.49,45.11 union all
select '220800','220000','白城',122.50,45.38 union all
select '220900','220000','长白山',128.17,41.43 union all
select '222400','220000','延边朝鲜族自治州',129.30,42.54 union all
-- 广东 --
select '440100','440000','广州',113.23,23.16 union all
select '440200','440000','韶关',113.62,24.84 union all
select '440300','440000','深圳',114.07,22.62 union all
select '440400','440000','珠海',113.52,22.30 union all
select '440500','440000','汕头',116.69,23.39 union all
select '440600','440000','佛山',113.11,23.05 union all
select '440700','440000','江门',113.06,22.61 union all
select '440800','440000','湛江',110.30,21.20 union all
select '440900','440000','茂名',110.88,21.68 union all
select '441200','440000','肇庆',112.44,23.05 union all
select '441300','440000','惠州',114.40,23.09 union all
select '441400','440000','梅州',116.10,24.55 union all
select '441500','440000','汕尾',115.36,22.78 union all
select '441600','440000','河源',114.68,23.73 union all
select '441700','440000','阳江',111.95,21.85 union all
select '441800','440000','清远',113.01,23.70 union all
select '441900','440000','东莞',113.75,23.04 union all
select '442000','440000','中山',113.38,22.52 union all
select '445100','440000','潮州',116.63,23.68 union all
select '445200','440000','揭阳',116.35,23.55 union all
select '445300','440000','云浮',112.02,22.93 union all
select '440606','440000','顺德区',113.24,22.84 union all
select '440605','440000','南海区',113.11,23.05 union all
-- 宁夏 --
select '640100','640000','银川',106.27,38.47 union all
select '640200','640000','石嘴山',106.39,39.04 union all
select '640300','640000','吴忠',106.21,37.99 union all
select '640400','640000','固原',106.28,36.01 union all
select '640500','640000','中卫',105.18,37.51 union all
-- 北京 --
select '110100','110000','北京',116.30,39.90 union all
-- 河南 --
select '410100','410000','郑州',113.65,34.76 union all
select '410200','410000','开封',114.35,34.79 union all
select '410300','410000','洛阳',112.44,34.70 union all
select '410400','410000','平顶山',113.29,33.75 union all
select '410500','410000','安阳',114.35,36.10 union all
select '410600','410000','鹤壁',114.17,35.90 union all
select '410700','410000','新乡',113.85,35.31 union all
select '410800','410000','焦作',113.21,35.24 union all
select '410900','410000','濮阳',114.98,35.71 union all
select '411000','410000','许昌',113.81,34.02 union all
select '411100','410000','漯河',114.02,33.56 union all
select '411200','410000','三门峡',111.19,34.76 union all
select '411300','410000','南阳',112.53,33.01 union all
select '411400','410000','商丘',115.65,34.44 union all
select '411500','410000','信阳',114.08,32.13 union all
select '411600','410000','周口',114.63,33.63 union all
select '411700','410000','驻马店',114.02,32.98 union all
select '419001','410000','济源',112.57,35.08 union all
-- 黑龙江 --
select '230100','230000','哈尔滨',126.63,45.75 union all
select '230200','230000','齐齐哈尔',123.97,47.33 union all
select '230300','230000','鸡西',130.97,45.3 union all
select '230400','230000','鹤岗',130.30,47.33 union all
select '230500','230000','双鸭山',131.17,46.65 union all
select '230600','230000','大庆',125.03,46.58 union all
select '230700','230000','伊春',128.92,47.73 union all
select '230800','230000','佳木斯',130.22,46.18 union all
select '230900','230000','七台河',130.8333,45.8166 union all
select '231000','230000','牡丹江',129.60,44.585 union all
select '231100','230000','黑河',127.53,50.22 union all
select '231200','230000','绥化',127,46.63 union all
-- 山东 --
select '370100','370000','济南',117,36.65 union all
select '370200','370000','青岛',120.33,36.07 union all
select '370300','370000','淄博',118.05,36.78 union all
select '370400','370000','枣庄',117.57,34.86 union all
select '370500','370000','东营',118.49,37.46 union all
select '370600','370000','烟台',121.39,37.52 union all
select '370700','370000','潍坊',119.10,36.62 union all
select '370800','370000','济宁',116.59,35.38 union all
select '370900','370000','泰安',117.13,36.18 union all
select '371000','370000','威海',122.1,37.5 union all
select '371100','370000','日照',119.46,35.42 union all
select '371200','370000','莱芜',117.67,36.19 union all
select '371300','370000','临沂',118.35,35.05 union all
select '371400','370000','德州',116.29,37.45 union all
select '371500','370000','聊城',115.97,36.45 union all
select '371600','370000','滨州',118.03,37.36 union all
select '371700','370000','菏泽',115.26,35.14 union all
-- 浙江 --
select '330100','330000','杭州',120.19,30.26 union all
select '330200','330000','宁波',121.56,29.86 union all
select '330300','330000','温州',120.65,28.01 union all
select '330400','330000','嘉兴',120.76,30.77 union all
select '330500','330000','湖州',120.1,30.86 union all
select '330600','330000','绍兴',120.58,30.01 union all
select '330700','330000','金华',119.64,29.12 union all
select '330800','330000','衢州',118.88,28.97 union all
select '330900','330000','舟山',122.20,30.00 union all
select '331000','330000','台州',121.4207,28.6564 union all
select '331100','330000','丽水',119.92,28.45 union all
-- 广西 --
select '450100','450000','南宁',108.33,22.84 union all
select '450200','450000','柳州',109.40,24.33 union all
select '450300','450000','桂林',110.28,25.29 union all
select '450400','450000','梧州',111.34,23.51 union all
select '450500','450000','北海',109.12,21.49 union all
select '450600','450000','防城港',108.20,21.37 union all
select '450700','450000','钦州',108.61,21.96 union all
select '450800','450000','贵港',109.60 ,23.10 union all
select '450900','450000','玉林',110.14,22.64 union all
select '451000','450000','百色',106.62,23.91 union all
select '451100','450000','贺州',111.6580,24.6051 union all
select '451200','450000','河池',108.06,24.7 union all
select '451300','450000','来宾',109.24,23.76 union all
select '451400','450000','崇左',107.37,22.42 union all
-- 内蒙古 --
select '150100','150000','呼和浩特',111.65,40.82 union all
select '150200','150000','包头',110.00,40.58 union all
select '150300','150000','乌海',106.82,39.67 union all
select '150400','150000','赤峰',118.87,42.28 union all
select '150500','150000','通辽',122.28,43.63 union all
select '150600','150000','鄂尔多斯',109.46,39.36 union all
select '150700','150000','呼伦贝尔',119.77,49.22 union all
select '150800','150000','巴彦淖尔',107.23,40.45 union all
select '150900','150000','乌兰察布',113.08,41.09 union all
select '152200','150000','兴安盟',122.05,46.08 union all
select '152500','150000','锡林郭勒',116.07,43.93 union all
select '152900','150000','阿拉善盟',105.67,38.83 union all
-- 福建 --
select '350100','350000','福州',119.30,26.08 union all
select '350200','350000','厦门',118.10,24.46 union all
select '350300','350000','莆田',119.00,25.44 union all
select '350400','350000','三明',117.61,26.23 union all
select '350500','350000','泉州',118.58,24.93 union all
select '350600','350000','漳州',117.35,24.52 union all
select '350700','350000','南平',118.16,26.65 union all
select '350800','350000','龙岩',117.01,25.12 union all
select '350900','350000','宁德',119.52,26.65 union all
-- 四川 --
select '510100','510000','成都',104.06,30.67 union all
select '510300','510000','自贡',104.77,29.35 union all
select '510400','510000','攀枝花',101.43,26.35 union all
select '510500','510000','泸州',105.39,28.91 union all
select '510600','510000','德阳',104.37,31.13 union all
select '510700','510000','绵阳',104.73,31.48 union all
select '510800','510000','广元',105.51,32.30 union all
select '510900','510000','遂宁',105.58,30.52 union all
select '511000','510000','内江',105.04,29.59 union all
select '511100','510000','乐山',106.76,29.60 union all
select '511300','510000','南充',106.06,30.80 union all
select '511400','510000','眉山',103.86,30.07 union all
select '511500','510000','宜宾',104.56,29.77 union all
select '511600','510000','广安',106.61,30.48 union all
select '511700','510000','达州',107.48,31.24 union all
select '511800','510000','雅安',102.97,29.97 union all
select '511900','510000','巴中',106.73,31.86 union all
select '512000','510000','资阳',104.60,30.19 union all
select '513200','510000','阿坝藏族羌族自治州',107.51,31.23 union all
select '513300','510000','甘孜藏族自治州',101.96,30.08 union all
select '513400','510000','凉山彝族自治州',102.29,27.89 union all
-- 重庆 --
select '500100','500000','重庆市辖区',106.33,29.35 union all
select '500105','500000','重庆江北区',106.34,29.36 union all
select '500118','500000','重庆永川区',105.53,29.23 union all
select '500101','500000','重庆万州区',108.44,30.80 union all
select '500102','500000','重庆涪陵区',107.36,29.70 union all
select '500114','500000','重庆黔江区',108.81,29.53 union all
-- 天津 --
select '120100','120000','天津',117.20,39.13 union all
-- 云南 --
select '530100','530000','昆明',102.73,25.04 union all
select '530300','530000','曲靖',103.79,25.51 union all
select '530400','530000','玉溪',102.52,24.35 union all
select '530500','530000','保山',98.50,25.03 union all
select '530600','530000','昭通',103.70,29.32 union all
select '530700','530000','丽江',100.25,26.86 union all
select '530800','530000','普洱市',101.03,23.07 union all
select '530900','530000','临沧',100.08,23.88 union all
select '532300','530000','楚雄彝族自治州',101.54,25.01 union all
select '532500','530000','红河哈尼族彝族自治州',102.42,23.35 union all
select '532600','530000','文山壮族苗族自治州',104.24,23.37 union all
select '532800','530000','西双版纳傣族自治州',100.80,22.02 union all
select '532900','530000','大理白族自治州',100.19,25.69 union all
select '533100','530000','德宏傣族景颇族自治州',98.58,24.43 union all
select '533300','530000','怒江傈僳族自治州',98.85,25.85 union all
select '533400','530000','迪庆藏族自治州',99.70,27.83 union all
select '530113','530000','东川区',103.18,26.08 union all
-- 湖南 --
select '430100','430000','长沙',113.00,28.21 union all
select '430200','430000','株洲',113.16,27.83 union all
select '430300','430000','湘潭',112.91,27.87 union all
select '430400','430000','衡阳',112.61,26.89 union all
select '430500','430000','邵阳',111.50,27.22 union all
select '430600','430000','岳阳',113.09,29.37 union all
select '430700','430000','常德',111.69,29.05 union all
select '430800','430000','张家界',110.47,29.13 union all
select '430900','430000','益阳',112.33,28.60 union all
select '431000','430000','郴州',113.00,25.79 union all
select '431100','430000','永州',111.63,26.22 union all
select '431200','430000','怀化',109.95,27.52 union all
select '431300','430000','娄底',111.96,27.71 union all
select '433100','430000','湘西土家族苗族自治州',109.7397,28.3142 union all
-- 新疆 --
select '650100','650000','乌鲁木齐',87.68,43.77 union all
select '650200','650000','克拉玛依',84.77,45.59 union all
select '650400','650000','吐鲁番',89.19,42.91 union all
select '650500','650000','哈密',93.44,42.78 union all
select '652300','650000','昌吉回族自治州',87.31,44.05 union all
select '652700','650000','博尔塔拉蒙古自治州',81.03,44.97 union all
select '652800','650000','巴音郭愣蒙古自治州',86.06,41.68 union all
select '654000','650000','伊犁哈萨克自治州',81.32,43.92 union all
select '654200','650000','塔城',82.96,46.74 union all
select '654300','650000','阿勒泰',88.14,47.86 union all
select '659001','650000','石河子',85.94,44.27 union all
select '654003','650000','奎屯',84.89,44.45 union all
select '652900','650000','阿克苏',80.29,41.15 union all
select '653000','650000','克孜勒苏柯尔克孜自治州',76.1684,39.71616 union all
select '653100','650000','喀什',75.98,39.47 union all
select '653200','650000','和田',79.94,37.12 union all
-- 江西 --
select '360100','360000','南昌',115.85,28.68 union all
select '360200','360000','景德镇',117.17,29.27 union all
select '360300','360000','萍乡',113.85,27.63 union all
select '360400','360000','九江',116.00,29.70 union all
select '360500','360000','新余',114.92,27.82 union all
select '360600','360000','鹰潭',117.07,28.27 union all
select '360700','360000','赣州',114.93,25.83 union all
select '360800','360000','吉安',114.98,27.12 union all
select '360900','360000','宜春',114.38,27.80 union all
select '361000','360000','抚州',116.35,28.00 union all
select '361100','360000','上饶',117.97,28.45 union all
-- 甘肃 --
select '620100','620000','兰州',103.73,36.03 union all
select '620200','620000','嘉峪关',98.17,39.47 union all
select '620300','620000','金昌',102.18,38.50 union all
select '620400','620000','白银',104.18,36.55 union all
select '620500','620000','天水',105.69,34.60 union all
select '620600','620000','武威',102.61,37.94 union all
select '620700','620000','张掖',100.46,38.93 union all
select '620800','620000','平凉',106.68,35.51 union all
select '620900','620000','酒泉',98.50,39.71 union all
select '621000','620000','庆阳',107.88,36.03 union all
select '621100','620000','定西',104.57,35.57 union all
select '621200','620000','陇南',104.92,33.40 union all
select '622900','620000','临夏回族自治州',103.22,35.62 union all
select '623000','620000','甘南藏族自治州',102.92,34.98 union all
-- 陕西 --
select '610100','610000','西安',108.95,34.27 union all
select '610200','610000','铜川',109.11,35.09 union all
select '610300','610000','宝鸡',107.15,34.38 union all
select '610400','610000','咸阳',108.72,34.36 union all
select '610500','610000','渭南',109.50,34.52 union all
select '610600','610000','延安',109.47,36.60 union all
select '610700','610000','汉中',108.04,33.07 union all
select '610800','610000','榆林',109.77,38.30 union all
select '610900','610000','安康',109.02,32.7 union all
select '611000','610000','商洛',109.93,33.87 union all
select '610403','610000','杨陵高新农业示范区',108.40,34.16 union all
-- 贵州 --
select '520100','520000','贵阳',106.71,26.57 union all
select '520200','520000','六盘水',104.82,26.58 union all
select '520300','520000','遵义',106.90,27.70 union all
select '520400','520000','安顺',105.92,26.25 union all
select '520500','520000','毕节',105.29,27.32 union all
select '520600','520000','铜仁',109.21,27.73 union all
select '522300','520000','黔西南布依族苗族自治州',104.53,25.05 union all
select '522600','520000','黔东南苗族侗族自治州',107.97,26.58 union all
select '522700','520000','黔南布依族苗族自治州',107.52,26.27 union all
-- 青海 --
select '630100','630000','西宁',101.74,36.56 union all
select '630200','630000','海东',102.12,36.50 union all
select '632200','630000','海北藏族自治州',100.9010,36.9594 union all
select '632300','630000','黄南藏族自治州',102.0199,35.5177 union all
select '632500','630000','海南藏族自治州',101.43,36.05 union all
select '632600','630000','果洛藏族自治州',100.23,34.48 union all
select '632700','630000','玉树藏族自治州',97.02,33.00 union all
select '632800','630000','海西蒙古族藏族自治州',97.37,37.37 union all
-- 西藏 --
select '540100','540000','拉萨',91.11,29.97 union all
select '540200','540000','日喀则',88.82,29.28 union all
select '540300','540000','昌都',97.18,31.13 union all
select '540400','540000','林芝',94.25,29.59 union all
select '540500','540000','山南',91.77,29.23 union all
select '542400','540000','那曲地区',92.10,31.47 union all
select '542500','540000','阿里地区',80.10,32.50 union all
-- 海南 --
select '460100','460000','海口',110.32,20.03 union all
select '460200','460000','三亚',109.50,18.25 union all
select '469002','460000','琼海',110.47,19.25 union all
select '469001','460000','五指山',109.52,18.78 union all
-- 台湾 --
select '710100','710000','台北',121.50,25.05 union all
-- 香港 --
select '810100','810000','香港',114.15,22.15 union all
-- 澳门 --
select '820100','820000','澳门',113.50,22.20 union all
-- 上海 --
select '310100','310000','上海',121.47,31.23车牌对应归属地信息表：
truncate table platenum_addr_tb
select * from platenum_addr_tb
-- 车牌对应归属地信息表 --
CREATE TABLE platenum_addr_tb
(
id bigint NOT NULL , --主键id
code character varying(6), --车牌对应归属地文字
city_id character varying(6), --城市id
create_time bigint, --创建时间
update_time bigint, --更新时间
CONSTRAINT platenum_addr_tb_pkey PRIMARY KEY (id)
)
CREATE SEQUENCE platenum_addr_tb_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
alter table platenum_addr_tb alter column id set default nextval('platenum_addr_tb_id_seq');
-- 数据插入 --
insert into platenum_addr_tb(city_id,code)
-- 河北省 --
select '130100','冀A' union all
select '130200','冀B' union all
select '130300','冀C' union all
select '130400','冀D' union all
select '130500','冀E' union all
select '130600','冀F' union all
select '130700','冀G' union all
select '130800','冀H' union all
select '130900','冀J' union all
select '130900','冀S' union all
select '131000','冀R' union all
select '131100','冀T' union all
-- 辽宁省 --
select '210100','辽A' union all -- '沈阳',123.1238,42.1216
select '210200','辽B' union all -- '大连',122.2229,39.4409
select '210300','辽C' union all -- '鞍山',122.85,41.12
select '210400','辽D' union all -- '抚顺',123.97,41.97
select '210500','辽E' union all -- '本溪',123.73,41.30
select '210600','辽F' union all -- '丹东',124.37,40.13
select '210700','辽G' union all -- '锦州',121.15,41.13
select '210800','辽H' union all -- '营口',122.18,40.65
select '210900','辽J' union all -- '阜新',121.65,42.00
select '211000','辽K' union all -- '辽阳',123.17,41.28
select '211100','辽L' union all -- '盘锦',122.03,41.07
select '211200','辽M' union all -- '铁岭',123.85,42.32
select '211300','辽N' union all -- '朝阳',120.42,41.58
select '211400','辽P' union all -- '葫芦岛',120.58,40.44 union all
-- 安徽 --
select '340100','皖A' union all -- '合肥',117.29,32.0581
select '340200','皖B' union all -- '芜湖',118.38,31.33
select '340300','皖C' union all -- '蚌埠',117.34,32.93
select '340400','皖D' union all -- '淮南',116.98,32.62
select '340500','皖E' union all -- '马鞍山',118.48,31.56
select '340600','皖F' union all -- '淮北',116.77,33.97
select '340700','皖G' union all -- '铜陵',117.82,30.93
select '340800','皖H' union all -- '安庆',117.03,30.52
select '341000','皖J' union all -- '黄山',118.33,29.71
select '341100','皖M' union all -- '滁州',118.31,32.33
select '341200','皖K' union all -- '阜阳',115.81,32.89
select '341300','皖L' union all -- '宿州',116.97,33.63
select '341500','皖N' union all -- '六安',116.49,31.73
select '341600','皖S' union all -- '亳州',115.78,33.84
select '341700','皖R' union all -- '池州',117.49,30.66
select '341800','皖P' union all -- '宣城',118.76,30.94
select '340181','皖Q' union all -- '巢湖',117.87,31.62
-- 江苏 --
select '320100','苏A' union all -- '南京',118.78,32.04
select '320200','苏B' union all -- '无锡',120.3442,31.5527
select '320300','苏C' union all -- '徐州',117.5208,34.3268
select '320400','苏D' union all -- '常州',119.4543,31.5582
select '320500','苏E' union all -- '苏州',120.6519,31.3989
select '320600','苏F' union all -- '南通',121.1023,32.1625
select '320700','苏G' union all -- '连云港',119.1248,34.552
select '320800','苏H' union all -- '淮安',118.927,33.4039
select '320900','苏J' union all -- '盐城',120.2234,33.5577
select '321000','苏K' union all -- '扬州',119.4653,32.8162
select '321100','苏L' union all -- '镇江',119.4763,31.9702
select '321200','苏M' union all -- '泰州',120.0586,32.5525
select '321300','苏N' union all -- '宿迁',118.5535,33.7775
-- 湖北 --
select '420100','鄂A' union all -- '武汉',114.3896,30.6628
select '420200','鄂B' union all -- '黄石',115.03,30.20
select '420300','鄂C' union all -- '十堰',110.78,32.65
select '420500','鄂E' union all -- '宜昌',111.28,30.70
select '420600','鄂F' union all -- '襄阳',112.20,32.08
select '420700','鄂G' union all -- '鄂州',114.88,30.40
select '420800','鄂H' union all -- '荆门',112.20,31.03
select '420900','鄂K' union all -- '孝感',113.92,30.93
select '421000','鄂D' union all -- '荆州',112.23,30.33
select '421100','鄂J' union all -- '黄冈',114.87,30.45
select '421200','鄂L' union all -- '咸宁',114.32,29.85
select '421300','鄂S' union all -- '随州',113.37,31.72
select '422800','鄂Q' union all -- '恩施土家族苗族自治州',109.47,30.30
select '429004','鄂M' union all -- '仙桃',113.45,30.37
select '429005','鄂N' union all -- '潜江',112.88,30.42
select '429021','鄂P' union all -- '神农架林区',110.67,31.75
select '429006','鄂R' union all -- '天门',113.17,30.67
-- 山西 --
select '140100','晋A' union all -- '太原',112.55,37.87
select '140200','晋B' union all -- '大同',113.30,40.08
select '140300','晋C' union all -- '阳泉',113.57,37.85
select '140400','晋D' union all -- '长治',113.12,36.20
select '140500','晋E' union all -- '晋城',112.83,35.50
select '140600','晋F' union all -- '朔州',112.43,39.33
select '140700','晋K' union all -- '晋中',112.75,37.68
select '140800','晋M' union all -- '运城',110.98,35.02
select '140900','晋H' union all -- '忻州',112.73,38.42
select '141000','晋L' union all -- '临汾',111.52,36.08
select '141100','晋J' union all -- '吕梁',111.13,37.52
-- 吉林 --
select '220100','吉A' union all -- '长春',125.19,43.54
select '220200','吉B' union all -- '吉林',126.33,43.52
select '220300','吉C' union all -- '四平',124.22,43.10
select '220400','吉D' union all -- '辽源',125.09,42.54
select '220500','吉E' union all -- '通化',125.56,41.43
select '220600','吉F' union all -- '白山',126.26,41.56
select '220700','吉J' union all -- '松原',124.49,45.11
select '220800','吉G' union all -- '白城',122.50,45.38
select '220900','吉K' union all -- '长白山',128.17,41.43
select '222400','吉H' union all -- '延边朝鲜族自治州',129.30,42.54
-- 广东 --
select '440100','粤A' union all -- '广州',113.23,23.16
select '440200','粤F' union all -- '韶关',113.62,24.84
select '440300','粤B' union all -- '深圳',114.07,22.62
select '440400','粤C' union all -- '珠海',113.52,22.30
select '440500','粤D' union all -- '汕头',116.69,23.39
select '440600','粤E' union all -- '佛山',113.11,23.05
select '440700','粤J' union all -- '江门',113.06,22.61
select '440800','粤G' union all -- '湛江',110.30,21.20
select '440900','粤K' union all -- '茂名',110.88,21.68
select '441200','粤H' union all -- '肇庆',112.44,23.05
select '441300','粤L' union all -- '惠州',114.40,23.09
select '441400','粤M' union all -- '梅州',116.10,24.55
select '441500','粤N' union all -- '汕尾',115.36,22.78
select '441600','粤P' union all -- '河源',114.68,23.73
select '441700','粤Q' union all -- '阳江',111.95,21.85
select '441800','粤R' union all -- '清远',113.01,23.70
select '441900','粤S' union all -- '东莞',113.75,23.04
select '442000','粤T' union all -- '中山',113.38,22.52
select '445100','粤U' union all -- '潮州',116.63,23.68
select '445200','粤V' union all -- '揭阳',116.35,23.55
select '445300','粤W' union all -- '云浮',112.02,22.93
select '440606','粤X' union all -- '顺德区',113.24,22.84
select '440605','粤Y' union all -- '南海区',113.11,23.05
-- 宁夏 --
select '640100','宁A' union all -- '银川',106.27,38.47
select '640200','宁B' union all -- '石嘴山',106.39,39.04
select '640300','宁C' union all -- '吴忠',106.21,37.99
select '640400','宁D' union all -- '固原',106.28,36.01
select '640500','宁E' union all -- '中卫',105.18,37.51
-- 北京 --
select '110100','京A' union all -- '北京',116.30,39.90
select '110100','京B' union all -- '北京',116.30,39.90
select '110100','京C' union all -- '北京',116.30,39.90
select '110100','京D' union all -- '北京',116.30,39.90
select '110100','京E' union all -- '北京',116.30,39.90
select '110100','京F' union all -- '北京',116.30,39.90
select '110100','京G' union all -- '北京',116.30,39.90
select '110100','京H' union all -- '北京',116.30,39.90
select '110100','京J' union all -- '北京',116.30,39.90
select '110100','京K' union all -- '北京',116.30,39.90
select '110100','京L' union all -- '北京',116.30,39.90
select '110100','京M' union all -- '北京',116.30,39.90
select '110100','京Y' union all -- '北京',116.30,39.90
-- 河南 --
select '410100','豫A' union all -- '郑州',113.65,34.76
select '410200','豫B' union all -- '开封',114.35,34.79
select '410300','豫C' union all -- '洛阳',112.44,34.70
select '410400','豫D' union all -- '平顶山',113.29,33.75
select '410500','豫E' union all -- '安阳',114.35,36.10
select '410600','豫F' union all -- '鹤壁',114.17,35.90
select '410700','豫G' union all -- '新乡',113.85,35.31
select '410800','豫H' union all -- '焦作',113.21,35.24
select '410900','豫J' union all -- '濮阳',114.98,35.71
select '411000','豫K' union all -- '许昌',113.81,34.02
select '411100','豫L' union all -- '漯河',114.02,33.56
select '411200','豫M' union all -- '三门峡',111.19,34.76
select '411300','豫R' union all -- '南阳',112.53,33.01
select '411400','豫N' union all -- '商丘',115.65,34.44
select '411500','豫S' union all -- '信阳',114.08,32.13
select '411600','豫P' union all -- '周口',114.63,33.63
select '411700','豫Q' union all -- '驻马店',114.02,32.98
select '419001','豫U' union all -- '济源',112.57,35.08
-- 黑龙江 --
select '230100','黑A' union all -- '哈尔滨',126.63,45.75
select '230100','黑L' union all -- '哈尔滨',126.63,45.75
select '230200','黑B' union all -- '齐齐哈尔',123.97,47.33
select '230300','黑G' union all -- '鸡西',130.97,45.30
select '230400','黑H' union all -- '鹤岗',130.30,47.33
select '230500','黑J' union all -- '双鸭山',131.17,46.65
select '230600','黑E' union all -- '大庆',125.03,46.58
select '230700','黑F' union all -- '伊春',128.92,47.73
select '230800','黑D' union all -- '佳木斯',130.22,46.18
select '230900','黑K' union all -- '七台河',130.8333,45.8166
select '231000','黑C' union all -- '牡丹江',129.60,44.585
select '231100','黑N' union all -- '黑河',127.53,50.22
select '231200','黑M' union all -- '绥化',127,46.63
-- 山东 --
select '370100','鲁A' union all -- '济南',117,36.65
select '370200','鲁B' union all -- '青岛',120.33,36.07
select '370200','鲁U' union all -- '青岛',120.33,36.07
select '370300','鲁C' union all -- '淄博',118.05,36.78
select '370400','鲁D' union all -- '枣庄',117.57,34.86
select '370500','鲁E' union all -- '东营',118.49,37.46
select '370600','鲁F' union all -- '烟台',121.39,37.52
select '370600','鲁Y' union all -- '烟台',121.39,37.52
select '370700','鲁G' union all -- '潍坊',119.10,36.62
select '370700','鲁V' union all -- '潍坊',119.10,36.62
select '370800','鲁H' union all -- '济宁',116.59,35.38
select '370900','鲁J' union all -- '泰安',117.13,36.18
select '371000','鲁K' union all -- '威海',122.1,37.5
select '371100','鲁L' union all -- '日照',119.46,35.42
select '371200','鲁S' union all -- '莱芜',117.67,36.19
select '371300','鲁Q' union all -- '临沂',118.35,35.05
select '371400','鲁N' union all -- '德州',116.29,37.45
select '371500','鲁P' union all -- '聊城',115.97,36.45
select '371600','鲁M' union all -- '滨州',118.03,37.36
select '371700','鲁R' union all -- '菏泽',115.26,35.14
-- 浙江 --
select '330100','浙A' union all -- '杭州',120.19,30.26
select '330200','浙B' union all -- '宁波',121.56,29.86
select '330300','浙C' union all -- '温州',120.65,28.01
select '330400','浙F' union all -- '嘉兴',120.76,30.77
select '330500','浙E' union all -- '湖州',120.10,30.86
select '330600','浙D' union all -- '绍兴',120.58,30.01
select '330700','浙G' union all -- '金华',119.64,29.12
select '330800','浙H' union all -- '衢州',118.88,28.97
select '330900','浙L' union all -- '舟山',122.20,30.00
select '331000','浙J' union all -- '台州',121.4207,28.6564
select '331100','浙K' union all -- '丽水',119.92,28.45
-- 广西 --
select '450100','桂A' union all -- '南宁',108.33,22.84
select '450200','桂B' union all -- '柳州',109.40,24.33
select '450300','桂C' union all -- '桂林',110.28,25.29
select '450300','桂H' union all -- '桂林',110.28,25.29
select '450400','桂D' union all -- '梧州',111.34,23.51
select '450500','桂E' union all -- '北海',109.12,21.49
select '450600','桂P' union all -- '防城港',108.20,21.37
select '450700','桂N' union all -- '钦州',108.61,21.96
select '450800','桂R' union all -- '贵港',109.60,23.10
select '450900','桂K' union all -- '玉林',110.14,22.64
select '451000','桂L' union all -- '百色',106.62,23.91
select '451100','桂J' union all -- '贺州',111.6580,24.6051
select '451200','桂M' union all -- '河池',108.06,24.70
select '451300','桂G' union all -- '来宾',109.24,23.76
select '451400','桂F' union all -- '崇左',107.37,22.42
-- 内蒙古 --
select '150100','蒙A' union all -- '呼和浩特',111.65,40.82
select '150200','蒙B' union all -- '包头',110.00,40.58
select '150300','蒙C' union all -- '乌海',106.82,39.67
select '150400','蒙D' union all -- '赤峰',118.87,42.28
select '150500','蒙G' union all -- '通辽',122.28,43.63
select '150600','蒙K' union all -- '鄂尔多斯',109.46,39.36
select '150700','蒙E' union all -- '呼伦贝尔',119.77,49.22
select '150800','蒙L' union all -- '巴彦淖尔',107.23,40.45
select '150900','蒙J' union all -- '乌兰察布',113.08,41.09
select '152200','蒙F' union all -- '兴安盟',122.05,46.08
select '152500','蒙H' union all -- '锡林郭勒',116.07,43.93
select '152900','蒙M' union all -- '阿拉善盟',105.67,38.83
-- 福建 --
select '350100','闽A' union all -- '福州',119.30,26.08
select '350200','闽D' union all -- '厦门',118.10,24.46
select '350300','闽B' union all -- '莆田',119.00,25.44
select '350400','闽G' union all -- '三明',117.61,26.23
select '350500','闽C' union all -- '泉州',118.58,24.93
select '350600','闽E' union all -- '漳州',117.35,24.52
select '350700','闽H' union all -- '南平',118.16,26.65
select '350800','闽F' union all -- '龙岩',117.01,25.12
select '350900','闽J' union all -- '宁德',119.52,26.65
-- 四川 --
select '510100','川A' union all -- '成都',104.06,30.67
select '510300','川C' union all -- '自贡',104.77,29.35
select '510400','川D' union all -- '攀枝花',101.43,26.35
select '510500','川E' union all -- '泸州',105.39,28.91
select '510600','川F' union all -- '德阳',104.37,31.13
select '510700','川B' union all -- '绵阳',104.73,31.48
select '510800','川H' union all -- '广元',105.51,32.30
select '510900','川J' union all -- '遂宁',105.58,30.52
select '511000','川K' union all -- '内江',105.04,29.59
select '511100','川L' union all -- '乐山',106.76,29.60
select '511300','川R' union all -- '南充',106.06,30.80
select '511400','川Z' union all -- '眉山',103.86,30.07
select '511500','川Q' union all -- '宜宾',104.56,29.77
select '511600','川X' union all -- '广安',106.61,30.48
select '511700','川S' union all -- '达州',107.48,31.24
select '511800','川T' union all -- '雅安',102.97,29.97
select '511900','川Y' union all -- '巴中',106.73,31.86
select '512000','川M' union all -- '资阳',104.60,30.19
select '513200','川U' union all -- '阿坝藏族羌族自治州',107.51,31.23
select '513300','川V' union all -- '甘孜藏族自治州',101.96,30.08
select '513400','川W' union all -- '凉山彝族自治州',102.29,27.89
-- 重庆 --
select '500100','渝A' union all -- '市辖区',106.33,29.35
select '500105','渝B' union all -- '江北区',106.34,29.36
select '500118','渝C' union all -- '永川区',105.53,29.23
select '500101','渝F' union all -- '万州区',108.44,30.80
select '500102','渝G' union all -- '涪陵区',107.36,29.70
select '500114','渝H' union all -- '黔江区',108.81,29.53
-- 天津 --
select '120100','津A' union all -- '天津',117.20,39.13
select '120100','津B' union all -- '天津',117.20,39.13
select '120100','津C' union all -- '天津',117.20,39.13
select '120100','津D' union all -- '天津',117.20,39.13
select '120100','津E' union all -- '天津',117.20,39.13
select '120100','津F' union all -- '天津',117.20,39.13
select '120100','津G' union all -- '天津',117.20,39.13
select '120100','津H' union all -- '天津',117.20,39.13
-- 云南 --
select '530100','云A' union all -- '昆明',102.73,25.04
select '530300','云D' union all -- '曲靖',103.79,25.51
select '530400','云F' union all -- '玉溪',102.52,24.35
select '530500','云M' union all -- '保山',98.50,25.03
select '530600','云C' union all -- '昭通',103.70,29.32
select '530700','云P' union all -- '丽江',100.25,26.86
select '530800','云J' union all -- '普洱市',101.03,23.07
select '530900','云S' union all -- '临沧',100.08,23.88
select '532300','云E' union all -- '楚雄彝族自治州',101.54,25.01
select '532500','云G' union all -- '红河哈尼族彝族自治州',102.42,23.35
select '532600','云H' union all -- '文山壮族苗族自治州',104.24,23.37
select '532800','云K' union all -- '西双版纳傣族自治州',100.80,22.02
select '532900','云L' union all -- '大理白族自治州',100.19,25.69
select '533100','云N' union all -- '德宏傣族景颇族自治州',98.58,24.43
select '533300','云Q' union all -- '怒江傈僳族自治州',98.85,25.85
select '533400','云R' union all -- '迪庆藏族自治州',99.70,27.83
select '530113','云A-V' union all -- '东川区',103.18,26.08
-- 湖南 --
select '430100','湘A' union all -- '长沙',113.00,28.21
select '430200','湘B' union all -- '株洲',113.16,27.83
select '430300','湘C' union all -- '湘潭',112.91,27.87
select '430400','湘D' union all -- '衡阳',112.61,26.89
select '430500','湘E' union all -- '邵阳',111.50,27.22
select '430600','湘F' union all -- '岳阳',113.09,29.37
select '430700','湘J' union all -- '常德',111.69,29.05
select '430800','湘G' union all -- '张家界',110.47,29.13
select '430900','湘H' union all -- '益阳',112.33,28.60
select '431000','湘L' union all -- '郴州',113.00,25.79
select '431100','湘M' union all -- '永州',111.63,26.22
select '431200','湘N' union all -- '怀化',109.95,27.52
select '431300','湘K' union all -- '娄底',111.96,27.71
select '433100','湘U' union all -- '湘西土家族苗族自治州',109.7397,28.3142
-- 新疆 --
select '650100','新A' union all -- '乌鲁木齐',87.68,43.77
select '650200','新J' union all -- '克拉玛依',84.77,45.59
select '650400','新K' union all -- '吐鲁番',89.19,42.91
select '650500','新L' union all -- '哈密',93.44,42.78
select '652300','新B' union all -- '昌吉回族自治州',87.31,44.05
select '652700','新E' union all -- '博尔塔拉蒙古自治州',81.03,44.97
select '652800','新M' union all -- '巴音郭愣蒙古自治州',86.06,41.68
select '654000','新F' union all -- '伊犁哈萨克自治州',81.32,43.92
select '654200','新G' union all -- '塔城',82.96,46.74
select '654300','新H' union all -- '阿勒泰',88.14,47.86
select '659001','新C' union all -- '石河子',85.94,44.27
select '654003','新D' union all -- '奎屯',84.89,44.45
select '652900','新N' union all -- '阿克苏',80.29,41.15
select '653000','新P' union all -- '克孜勒苏柯尔克孜自治州',76.1684,39.71616
select '653100','新Q' union all -- '喀什',75.98,39.47
select '653200','新R' union all -- '和田',79.94,37.12
-- 江西 --
select '360100','赣A' union all -- '南昌',115.85,28.68
select '360100','赣M' union all -- '南昌',115.85,28.68
select '360200','赣H' union all -- '景德镇',117.17,29.27
select '360300','赣J' union all -- '萍乡',113.85,27.63
select '360400','赣G' union all -- '九江',116.00,29.70
select '360500','赣K' union all -- '新余',114.92,27.82
select '360600','赣L' union all -- '鹰潭',117.07,28.27
select '360700','赣B' union all -- '赣州',114.93,25.83
select '360800','赣D' union all -- '吉安',114.98,27.12
select '360900','赣C' union all -- '宜春',114.38,27.80
select '361000','赣F' union all -- '抚州',116.35,28.00
select '361100','赣E' union all -- '上饶',117.97,28.45
-- 甘肃 --
select '620100','甘A' union all -- '兰州',103.73,36.03
select '620200','甘B' union all -- '嘉峪关',98.17,39.47
select '620300','甘C' union all -- '金昌',102.18,38.50
select '620400','甘D' union all -- '白银',104.18,36.55
select '620500','甘E' union all -- '天水',105.69,34.60
select '620600','甘H' union all -- '武威',102.61,37.94
select '620700','甘G' union all -- '张掖',100.46,38.93
select '620800','甘L' union all -- '平凉',106.68,35.51
select '620900','甘F' union all -- '酒泉',98.50,39.71
select '621000','甘M' union all -- '庆阳',107.88,36.03
select '621100','甘J' union all -- '定西',104.57,35.57
select '621200','甘K' union all -- '陇南',104.92,33.40
select '622900','甘N' union all -- '临夏回族自治州',103.22,35.62
select '623000','甘P' union all -- '甘南藏族自治州',102.92,34.98
-- 陕西 --
select '610100','陕A' union all -- '西安',108.95,34.27
select '610200','陕B' union all -- '铜川',109.11,35.09
select '610300','陕C' union all -- '宝鸡',107.15,34.38
select '610400','陕D' union all -- '咸阳',108.72,34.36
select '610500','陕E' union all -- '渭南',109.50,34.52
select '610600','陕J' union all -- '延安',109.47,36.60
select '610700','陕F' union all -- '汉中',108.04,33.07
select '610800','陕K' union all -- '榆林',109.77,38.30
select '610900','陕G' union all -- '安康',109.02,32.70
select '611000','陕H' union all -- '商洛',109.93,33.87
select '610403','陕V' union all -- '杨陵高新农业示范区',108.40,34.16
-- 贵州 --
select '520100','贵A' union all -- '贵阳',106.71,26.57
select '520200','贵B' union all -- '六盘水',104.82,26.58
select '520300','贵C' union all -- '遵义',106.90,27.70
select '520400','贵G' union all -- '安顺',105.92,26.25
select '520500','贵F' union all -- '毕节',105.29,27.32
select '520600','贵D' union all -- '铜仁',109.21,27.73
select '522300','贵E' union all -- '黔西南布依族苗族自治州',104.53,25.05
select '522600','贵H' union all -- '黔东南苗族侗族自治州',107.97,26.58
select '522700','贵J' union all -- '黔南布依族苗族自治州',107.52,26.27
-- 青海 --
select '630100','青A' union all -- '西宁',101.74,36.56
select '630200','青B' union all -- '海东',102.12,36.50
select '632200','青C' union all -- '海北藏族自治州',100.9010,36.9594
select '632300','青D' union all -- '黄南藏族自治州',102.0199,35.5177
select '632500','青E' union all -- '海南藏族自治州',101.43,36.05
select '632600','青F' union all -- '果洛藏族自治州',100.23,34.48
select '632700','青G' union all -- '玉树藏族自治州',97.02,33.00
select '632800','青H' union all -- '海西蒙古族藏族自治州',97.37,37.37
-- 西藏 --
select '540100','藏A' union all -- '拉萨',91.11,29.97
select '540200','藏D' union all -- '日喀则',88.82,29.28
select '540300','藏B' union all -- '昌都',97.18,31.13
select '540400','藏G' union all -- '林芝',94.25,29.59
select '540500','藏C' union all -- '山南',91.77,29.23
select '542400','藏E' union all -- '那曲地区',92.10,31.47
select '542500','藏F' union all -- '阿里地区',80.10,32.50
-- 海南 --
select '460100','琼A' union all -- '海口',110.32,20.03
select '460200','琼B' union all -- '三亚',109.50,18.25
select '469002','琼C' union all -- '琼海',110.47,19.25
select '469001','琼D' union all -- '五指山',109.52,18.78
-- 上海 --
select '310100','沪A' union all -- '市辖区',121.47,31.23
select '310100','沪B' union all -- '市辖区',121.47,31.23
select '310100','沪C' union all -- '市辖区',121.47,31.23
select '310100','沪D' union all -- '市辖区',121.47,31.23
select '310100','沪R' -- '市辖区',121.47,31.23
扫一扫
16万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
