全国各地的车牌【阳山吧】_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：41,909贴子：
全国各地的车牌收藏
其实我是来水贴的全国各省市地区车牌广东省（粤）粤A广州
粤C珠海粤D汕头
粤F韶关粤G湛江
粤J江门粤K茂名
粤M梅州粤N汕尾
粤Q阳江粤R清远
粤T中山粤U潮州
粤W云浮粤X顺德
粤Y南海粤Z港澳进入内地车辆
河北省（冀）冀A石家庄
冀C秦皇岛 冀D邯郸
冀F保定冀G张家口
冀J沧州冀R廊坊
河南省（豫）豫A郑州
豫C洛阳豫D平顶山
豫F鹤壁豫G新乡
豫J濮阳豫K许昌
豫M三门峡豫N商丘
豫Q驻马店豫R南阳
浙江省（浙）浙A杭州
浙C温州浙D绍兴
浙F嘉兴浙G金华
浙J台州浙K丽水
江苏省（苏）苏A南京
苏C徐州苏D常州
苏F南通苏G连云港
苏J盐城苏K扬州
苏M泰州苏N宿迁
山东省（鲁）鲁A济南
鲁C淄博鲁D枣庄
鲁F烟台鲁G潍坊
鲁J泰安鲁K威海
鲁M莱芜鲁N德州
鲁Q临沂鲁R菏泽
鲁U青岛开发区
安徽省（皖）皖A合肥
皖C蚌埠皖D淮南
皖F淮北皖G铜陵
皖J黄山皖K阜阳
皖M滁州皖N六安
皖Q巢湖皖R池州
福建省（闽）闽A福州
闽C泉州闽D厦门
闽F龙岩闽G三明
闽J宁德闽K省直机关
湖北省（鄂）鄂A武汉
鄂C十堰鄂D沙市
鄂F襄樊鄂G鄂州
鄂J黄岗鄂K孝感
鄂M荆州鄂N郧阳
广西壮族（桂）桂A南宁
桂C桂林桂D梧州
桂F南宁桂G来宾
桂K玉林桂J贺州(属梧州)
桂L百色桂M河池
甘肃省（甘）甘A兰州
甘C金昌甘D白银
甘F酒泉甘G张掖
甘J定西甘K陇南
甘M庆阳甘N临夏回族
甘P甘南藏族
山西省（晋）晋A太原
晋C阳泉晋D长治
晋F朔州晋H忻州
晋K晋中晋L临汾
内蒙古（蒙）蒙A呼和浩特
蒙C乌海蒙D赤峰 蒙E呼伦贝尔盟 蒙F兴安盟蒙G锡林郭勒盟
蒙H乌兰察布盟蒙J伊克昭盟
蒙K巴彦淖尔盟蒙L阿拉善盟
陕西省（陕）陕A西安
陕C宝鸡陕D威阳
陕F汉中陕G安康
陕J延安陕K榆林
陕U省直机关
吉林省（吉）吉A长春
吉C四平吉D辽源
吉F白山吉G白城
吉H延边朝鲜族
黑龙江（黑）黑A哈尔滨 黑B齐齐哈尔 黑C牡丹江黑D佳木斯 黑E大庆
黑F伊春市黑G鸡西
黑J双鸭山黑K七台河 黑L松花江区
黑M绥化黑N黑河
黑P大兴安岭 黑R农垦系统
贵州省（贵）贵A贵阳
贵C遵义贵D铜仁
贵E黔西南州
贵F毕节贵G安顺
贵H黔东南州
青海省（青）青A西宁
青C海北青D黄南
青F果洛州青G玉树州
西藏（藏）藏A拉萨
藏C山南藏D******
藏F阿里藏G林芝
四川省（川）川A成都
川C自贡川D攀枝花
川F德阳川H广元
川K内江川L乐山
川R南充川S达县
川U阿坝藏族川V****藏族 川W凉山彝族 川Z眉山
宁夏回族（宁）宁A银川
宁C银南宁D固原
海南省（琼）琼A海口
军总部（二级部用，一级部按照上方的京V排列）军A——总参谋部军B——总政治部军C——总后勤部军D——总装备部军E——军事科学院军F——国防大学军G——国防科技大学军R——陆军军事院校军T——总参三部（类似中央情报局）军V——第二炮兵司令部军K——总后直属单位军M——总部所属的联勤部门军O——总部军车监理
南京军区南A——南京军区司令部南B——南京军区政治部南C——南京军区联勤部南D——南京军区装备部南K1****——上海警备区南K2****——江苏省军区南K3****——浙江省军区南K4****——安徽省军区南K5****——福建省军区南K6****——江西省军区南M——南京军区联勤分部南N——总装备部驻南京军区单位南O——南京军区军车监理南R——南京军区所属军事院校 如：南R10***——南京陆军指挥学院 南R30***——第二军医大学南V——二炮驻南京军区单位南Y——南京军区所属集团军（1军、12军、31军） 如：南Y7****——31军
京V牌照 101 京V·0****——****总参机关的 京V·1****——****总政 京V·2****——****总后 京V·3****——****总装 京V026——****委员京V02*** 中央警卫局中央首长家号码京V01*** 中央警卫局警卫局办公用车 京V-025、026、027、028、029都是****和总参领导专车020、021、022、023、024都是中央政治局领导专车京V021XX 如果是黑V应该是政治局常委的车京V牌照的使用权在四总部直属机关手里，所提及的军A、B、C、D分别为参、政、装、后的二级部，一级部使用的也都是京V的牌照。进口车型在北京跑的能挂京V牌的基本都是京V019至京V028这个号段之内的，是大首长的车。另外就是挂军T的，三部的车也有一些进口车型，也有少部分在京V019至京V 028号段。 京V02就是以前的甲A02，02的牌子不够用，018，019都是中央领导的随行车 家属车基本上是06或05的，06打头的多. 五位号码，首位代表武警序列，首位为数字的为内务部队，&消&为消防部队，&边&为边防部队，&通&为交通部队，&森&为森林部队，&金&为黄金部队，&警&为警卫部队，&电&为水电部队 1、甲A026/027/028是最牛的，通天级人物阿……如果甲A026/7/8再挂个警备、安个警灯（车里，中控台上方），那么在中国这片大地上就没有车能超过他们比他们更牛了…… 京ET也很牛，都是和国务院老干部沾边的…… 京AG6也是牛B的 挂警备又有安警灯的也不要惹…… 只挂警备没警灯的，就是假的了，当然也不排除靠关系搞的牌子，但肯定是有水分的。 &023&、&323&，塑封的置于前挡风左下角的，北京市委的车 &安全&置于前挡风左下角的，北京市政府最高级别车辆 &国A&，置于前挡风下端，国务院的 &901&金融通行证，以前叫&免检通行证& &京安&这个正是用来代替&警备&的，带原来的警备谁也不撤，没辙，只好一起用了…… 还有就是京A80开头的，国管局等的车…… &使&字牌子前5号的，有外交豁免权…… 2、京A81、82、83开头的也牛，京A88：钓鱼台。 庚A，军区司令部，庚G，北京警备区。甲 A：总参、甲B：总政、甲C：总后、甲D：总装、未A：海军司令部、午A：空军司令部、甲F：军事院校、甲N：二炮司令部、WJ01： 武警总部、WJ31：武警北京总队。 京OB，北京市公安局及下属各分局。 京OD，北京市公安交通管理局及下属各支队。 京OE，北京市铁路公安局。 京A-****警，北京市公安局及下属各分局各总队，警务车如治安防暴巡查等。京A-A***警，法院警务车。京A-B***警，检察院警务车。 　　 3、025、026、027、028、029都是****和总参领导专车，更牛的是020、021、022、023、024，都是中央政治局领导专车。 黄色字体&警备&牌是一级警备，发行量不多，多数用于国家、中央政治局、****专用开道车，白色的是普通警备牌，数量多些。 4、京A81是中直国管局，京A83是北京市政府。京AG6XXX是全国人大副委员长、全国政协副主席专车。有BUICK、A6、S320 5、中国最NB的车是：甲A02156，是黑色德国特制AUDI A8 4.2 6、补充说：白字&警备&好像是公安部发的，&警备&加&京安&的车证组合可算是一级车证了。还有&特别通行&、&禁毒&也比较牛，铁的，红的，有备案号。粤A 广州 粤B 深圳 粤C 珠海 粤D 汕头 粤E 佛山 粤F 韶关 粤G 湛江 粤H 肇庆 粤J 江门 粤K 茂名 粤L 惠州 粤M 梅州 粤N 汕尾 粤P 河源 粤Q 阳江 粤R 清远 粤S 东莞 粤T 中山 粤U 潮州 粤V 揭阳 粤W 云浮 粤X 顺德 粤Y 南海 粤Z 粤港双牌车 红白车牌：军车 黑红车牌：外国领事馆车 黑牌：外资车（入户人为外资机构或外国人）黄牌：摩托车、大货车或以上 蓝牌：小车
&奇幻小东江&郴州集合,韶关解散!徒步飞天山-万华岩探洞-阳山古村-南岗瑶寨-乳源大峡谷全程不走回头路;让心灵在风景中旅行,一趟玩尽丹霞地.
网络笑话一辽B是最大的13
这个车牌表地方牌部分是正确的，但是军牌部分就不正确了。那是上一代的军牌，现在都挂新牌了。
好细致哦佩服
最明目张胆的就是赣B。。。哈
水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水水
登录百度帐号鹿邑一大批车辆被曝光 车牌号看得清清楚楚
在生活中，小小的交通陋习常常造成惨痛的交通意外，夺走鲜活的生命，破坏美满的家庭。闯红灯便属于这一类交通陋习。一些人为了一时之快，心存侥幸，高速闯红灯，结果车毁人伤，甚至葬送性命，令人扼腕叹息。闯红灯的车辆，如果刚好是抢红灯跳转前的最后几秒，危险性更高，因为此时横向车道上的车辆，有可能也在抢绿灯跳转前的最后几秒，双方车速同时达到最大值，碰撞的几率增加，车毁人亡的悲剧就有可能上演。违章停车的危害：(一)违章乱停放车辆会使得城市的形象受到影响，乱停放车辆就会使得城市的秩序出现混乱的现象，还会导致城市的品味以及形象都受到影响，这就使得城市道路的交通环境无法得到提升。随意的停放车辆将停车位置占据掉，那么就会使得其他车辆的正常通行都会受到影响，甚至连行人的通行效率会受到一定的影响，当道路的交通运行速度下降的时候就会损坏大家的通行权利。(二)机动车如果在行驶中随意的停放，那么就会导致交通事故也会增加，机动车突然的停车也会使得其他的驾驶员无法做好准备，因此就会将碰撞事故以及追尾意外的发生增加，对于城市道路的交通安全都会因此而受到影响，对于群众的生命以及财产来说也是一种损坏。(三)机动车随意的乱停放就会导致路段不畅通，而我们违章乱停放车辆的地方大部分都是学校，或者是银行以及饭店的附近，因此如果长时间将道路占据住就会形成堵塞点，直接导致道路上出现不必要的堵塞现象。违章停车的处罚：机动车驾驶人不在现场或者虽在现场但拒绝立即驶离，妨碍其他车辆、行人通行的，处二百元罚款，并可以将该机动车拖移。原标题：闯红灯车辆曝光 违停车辆曝光转载自:河南鹿邑交警
根据您访问的内容，您可能还对以下内容感兴趣，希望对您有帮助：答：鹿邑现在是省管县，不过，车牌现在还是豫P，不知道以后会不会变。答：因为车辆的车主信息属于个人隐私，而且法律规定不允许私自查询透露给公民,所以我们无法通过网络查询车辆主的个人信息。不过可以试试以下渠道: 1、如果是该车牌的主人侵犯了你的合法权益，建议你先给110报警，然后由110出面到车管所查询车主信息...答：当然,炸弹号最好,但所需价格十分昂贵,且容易带来不必要的麻烦,如经常遭遇套牌等问题.一般选车号如同选手机号一般,按照我们传统规矩不带4或7的号较好,当然,号码要好记.或者你可以选择个性车牌,在牌照号码中间加英文字母,可以自定义号码牌,只要牌...答：鹿邑，原隶属周口地区，现在是河南省直管县，但在区域上仍属于周口地区，所以车牌电话区号等统一同周口一样。答：你好 建议发到鹿邑当地贴吧上问问 贴吧当地人多的多 了解的更多 你在这里大海捞针没人知道 望采纳答：车牌由车管所发放，当然是到车管所咨询了。答：要找车牌号的车主有两种方法 第一种，去车管所，如果你有熟人的话，应该 很方便就可以查到，一般情况下是不让查的 第二种，下载跑丁车APP查询，跑丁车是一款专门的车牌号查询软件，里面有很多的车主，记得你一定要认证自己的车牌号答：是的。答：你查询的是 豫P·54476 类型：民用车辆号牌 省份：河南 城市：周口市 车辆信息属于私人隐私信息，需要到车管所查询，答题不易，望采纳！答：一、在网上普通人不能根据车牌号查车主信息，因为这是隐私，无权查看。交警，警察，可以根据车牌号查出车主。 二、车主信息是机密，不是谁都可以查的，这个信息是非公开的。 三、需要查询的人，持有效证件到保险公司，按对方车牌号报建方式，可...声明：以上内容由用户提供，并不代表本网赞同其观点。如有任何不妥，请与不良与违法信息举报中心联系：1/2页点击展开全文滑县一大批车辆被曝光 有人认识的吗
滑县交警大队
西环路以东，北环路以南，创业大道以西，长虹大道以北。（不含上述四条道路）
对进入限行区域的所有机动车，实行每日限制两个车牌尾号的车辆通行。“尾号”即为机动车号牌末尾的数字（号牌末位为英文字母的，以字母前的最后一个数字为准）。
星期一：限行机动车车牌尾号为1和6；
星期二：限行机动车车牌尾号为2和7；
星期三：限行机动车车牌尾号为3和8；
星期四：限行机动车车牌尾号为4和9；
星期五：限行机动车车牌尾号为5和0。
限行时间：每日早8时至20时。
以下车牌号为违反限行规定的车辆
豫EHK852 豫P153Y2 沪C8CE02
豫ELJ282 豫J52U62 豫E7K772
豫GE7E22 豫EHN262 豫F61062
豫E2212V 豫E1112V 豫E7252X
豫E4882Z 豫AP772L 豫AJ662L
豫A9157J 豫A1S37H 豫GA587H
陕D0017F 豫JFP777 豫EUV597
豫E09E77 豫A69CH7 豫EA2L87
豫AQ5V57 豫HHA617 苏CJ357G
晋BEG357 豫A0R662 苏MS1967
豫E60P02 豫F2P322 豫G0H187
豫F61062 津MFW202 豫A9D57G
豫E0952X 豫E2582Z 沪C473F7
豫P7602K 豫A5L32K 豫A1Y087
【闯红灯的这些后果，是你不能承受的！】
有统计数据显示，90%的重特大交通事故都发生在交叉路口，闯红灯的后果有多严重!别嫌 蜀黍唠叨啊！红灯停，绿灯行。宁等三分，不抢一秒，既是保障自己生命安全，也是对别人负责！！！
大型汽车 豫ETD631 滑县通达公交有限公司
07:00:07 长虹大道与东环路交叉口实施闯红灯违法行为
大型汽车 豫EGJ579 滑县公交公司
17:28:49 文明路与林苑路交叉口实施闯红灯违法行为
大型汽车 豫EE9618 河南省安阳安运交通运输有限公司六分公司
13:10:23 滑台路与欧阳路交叉口实施闯红灯违法行为
大型汽车 豫E81666 河南中州集团滑县通达运输有限公司
15:50:03 滑台路与滑州路交叉口实施闯红灯违法行为
点击展开全文我们的终点都一样，所以成为那个不变初心的自己！
车牌归属地数据信息sql
(注：知识浩瀚，本人能力有限，定有不足，望各位多多指点，不足之处请指出，俺好随时改进，小的无以为报，在此鞠躬致谢…)
对于车牌归属地信息所建数据表，其中行政区域代码信息从国家统计局官网获取()
；车牌归属地对应信息从百度文库获取。数据可能与当前情况有所出入，请自行修改即可。（postgresql为本次sql载体）
省份信息表：
truncate table province_manage_tb
drop table province_manage_tb
-- 省份信息表 --
CREATE TABLE province_manage_tb
province_id character varying(6) NOT NULL,
province_name character varying(50),
--省份名称
provincial_capital_id character varying(6),
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,
province_id character varying(6),
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 ,
code character varying(6),
--车牌对应归属地文字
city_id character varying(6),
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
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
中国车牌号与城市的对应关系
全国各地车牌代码整理出数据库表，直接生成表
【分享】车牌图片数据库（小，500张图片，2010年-2011年间的数据）
没有更多推荐了，}