wecatch / china_regions Goto Github PK

http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2018/14/1404.html

屯留区，
在项目中是：
140414000000
在统计局是：
140405000000

json.zip

几个sql文件，全部是insert语句，怎么不见了create table的语句？
无法使用啊

如题，这个china-region.json有英文版的吗

统计局网站地址已更新，按年目录：http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/

是否考虑同步更新？😊

你好，很感谢你提供的数据，我发现county.sql文件中，天津市数据重复，town.sql文件中，天津市数据重复，望修改。

示例DEMO 当选择香港澳门时 区县地址未联动

能支持日本的嘛

广东东莞，广东中山，海南三沙，等地的区县数据不存在

失效了，兄嘚！~

你那个demo有bug 选了 第一次选市后面区有数据,第二次选了东莞,中山等 后面区的数据还是之前第一个选的市的区数据

库里面写的是country，郡，县 应该是county

山东省，济南市，市辖区：这个数据不对吧？济南市下面应该直接就是历下区、槐荫区等等。怎么会多了一个市辖区呢？

而且第三级的这个市辖区，下面没有第四级的数据。

请作者去掉这个数据，是否可行？

在 city.json 1102 行，海南省包含海南省

"460000": [
        {
            "province": "海南省", 
            "name": "海南省", 
            "id": "460000"
        }, 
        {
            "province": "海南省", 
            "name": "海口市", 
            "id": "460100"
        }, 
        {
            "province": "海南省", 
            "name": "三亚市", 
            "id": "460200"
        }, 
        {
            "province": "海南省", 
            "name": "三沙市", 
            "id": "460300"
        }, 
        {
            "province": "海南省", 
            "name": "儋州市", 
            "id": "460400"
        }, 
        {
            "province": "海南省", 
            "name": "省直辖县级行政区划", 
            "id": "469000"
        }
    ], 

在 area.json 中 11319 行可能存在错误

 "460000": [], 

四个直辖市没有

删除json文件之后提示文件不存在

PS F:\china_regions-3.3> node main.js
2020-09-09T11:07:58+0800 main.js:51 (newRequestPromise) request == > http://219.235.129.117:80/tjsj/tjbz/tjyqhdmhcxhfdm/2018/
undefined:1

SyntaxError: Unexpected end of JSON input
at JSON.parse ()
at pullVillageDataSync (F:\china_regions-3.3\main.js:391:25)
at Object. (F:\china_regions-3.3\main.js:422:1)
at Module._compile (internal/modules/cjs/loader.js:1133:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
at Module.load (internal/modules/cjs/loader.js:977:32)
at Function.Module._load (internal/modules/cjs/loader.js:877:14)
at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)
at internal/main/run_main_module.js:18:47
PS F:\china_regions-3.3> node main.js
2020-09-09T11:08:42+0800 main.js:51 (newRequestPromise) request == > http://219.235.129.117:80/tjsj/tjbz/tjyqhdmhcxhfdm/2018/

然后我在文件夹里加上了town.json

F:\china_regions-3.3\main.js:393
jsonData.slice(offset).forEach(function(element, index) {
^

TypeError: jsonData.slice is not a function
at pullVillageDataSync (F:\china_regions-3.3\main.js:393:14)
at Object. (F:\china_regions-3.3\main.js:422:1)
at Module._compile (internal/modules/cjs/loader.js:1133:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1153:10)
at Module.load (internal/modules/cjs/loader.js:977:32)
at Function.Module._load (internal/modules/cjs/loader.js:877:14)
at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:74:12)
at internal/main/run_main_module.js:18:47
PS F:\china_regions-3.3>

没有香港澳门**钓鱼岛，差评

INSERT INTO Table ( Column1, Column2 ) VALUES
( Value1, Value2 ),
( Value1, Value2 );

浙江省 宁波市 江东区 没有

现在完全获取不了数据了

http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2019/

当前 master（ ef733aa） 分支下，json 目录中，city.json 中可以找到 451200000000（广西河池市），但是在 country.json 中，却找不到 4512 开头的数据，http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2018/45.html 上面是有数据的。

select * from town group by town_id having count(*) > 1
有900多条重复的

香港澳门也没有，差点直接用到生产上，那就犯zz错误了

INSERT INTO country VALUES ('3283', '东城街道办事处', '441900003000', '441900000000');
INSERT INTO country VALUES ('3284', '南城街道办事处', '441900004000', '441900000000');
INSERT INTO country VALUES ('3285', '万江街道办事处', '441900005000', '441900000000');
INSERT INTO country VALUES ('3286', '莞城街道办事处', '441900006000', '441900000000');
INSERT INTO country VALUES ('3287', '石碣镇', '441900101000', '441900000000');
INSERT INTO country VALUES ('3288', '石龙镇', '441900102000', '441900000000');
INSERT INTO country VALUES ('3289', '茶山镇', '441900103000', '441900000000');
INSERT INTO country VALUES ('3290', '石排镇', '441900104000', '441900000000');
INSERT INTO country VALUES ('3291', '企石镇', '441900105000', '441900000000');
INSERT INTO country VALUES ('3292', '横沥镇', '441900106000', '441900000000');
INSERT INTO country VALUES ('3293', '桥头镇', '441900107000', '441900000000');
INSERT INTO country VALUES ('3294', '谢岗镇', '441900108000', '441900000000');
INSERT INTO country VALUES ('3295', '东坑镇', '441900109000', '441900000000');
INSERT INTO country VALUES ('3296', '常平镇', '441900110000', '441900000000');
INSERT INTO country VALUES ('3297', '寮步镇', '441900111000', '441900000000');
INSERT INTO country VALUES ('3298', '樟木头镇', '441900112000', '441900000000');
INSERT INTO country VALUES ('3299', '大朗镇', '441900113000', '441900000000');
INSERT INTO country VALUES ('3300', '黄江镇', '441900114000', '441900000000');
INSERT INTO country VALUES ('3301', '清溪镇', '441900115000', '441900000000');
INSERT INTO country VALUES ('3302', '塘厦镇', '441900116000', '441900000000');
INSERT INTO country VALUES ('3303', '凤岗镇', '441900117000', '441900000000');
INSERT INTO country VALUES ('3304', '大岭山镇', '441900118000', '441900000000');
INSERT INTO country VALUES ('3305', '长安镇', '441900119000', '441900000000');
INSERT INTO country VALUES ('3306', '虎门镇', '441900121000', '441900000000');
INSERT INTO country VALUES ('3307', '厚街镇', '441900122000', '441900000000');
INSERT INTO country VALUES ('3308', '沙田镇', '441900123000', '441900000000');
INSERT INTO country VALUES ('3309', '道滘镇', '441900124000', '441900000000');
INSERT INTO country VALUES ('3310', '洪梅镇', '441900125000', '441900000000');
INSERT INTO country VALUES ('3311', '麻涌镇', '441900126000', '441900000000');
INSERT INTO country VALUES ('3312', '望牛墩镇', '441900127000', '441900000000');
INSERT INTO country VALUES ('3313', '中堂镇', '441900128000', '441900000000');
INSERT INTO country VALUES ('3314', '高埗镇', '441900129000', '441900000000');
INSERT INTO country VALUES ('3315', '松山湖管委会', '441900401000', '441900000000');
INSERT INTO country VALUES ('3316', '东莞港', '441900402000', '441900000000');
INSERT INTO country VALUES ('3317', '东莞生态园', '441900403000', '441900000000');
INSERT INTO country VALUES ('3318', '石岐区街道办事处', '442000001000', '442000000000');
INSERT INTO country VALUES ('3319', '东区街道办事处', '442000002000', '442000000000');
INSERT INTO country VALUES ('3320', '火炬开发区街道办事处', '442000003000', '442000000000');
INSERT INTO country VALUES ('3321', '西区街道办事处', '442000004000', '442000000000');
INSERT INTO country VALUES ('3322', '南区街道办事处', '442000005000', '442000000000');
INSERT INTO country VALUES ('3323', '五桂山街道办事处', '442000006000', '442000000000');
INSERT INTO country VALUES ('3324', '小榄镇', '442000100000', '442000000000');
INSERT INTO country VALUES ('3325', '黄圃镇', '442000101000', '442000000000');
INSERT INTO country VALUES ('3326', '民众镇', '442000102000', '442000000000');
INSERT INTO country VALUES ('3327', '东凤镇', '442000103000', '442000000000');
INSERT INTO country VALUES ('3328', '东升镇', '442000104000', '442000000000');
INSERT INTO country VALUES ('3329', '古镇镇', '442000105000', '442000000000');
INSERT INTO country VALUES ('3330', '沙溪镇', '442000106000', '442000000000');
INSERT INTO country VALUES ('3331', '坦洲镇', '442000107000', '442000000000');
INSERT INTO country VALUES ('3332', '港口镇', '442000108000', '442000000000');
INSERT INTO country VALUES ('3333', '三角镇', '442000109000', '442000000000');
INSERT INTO country VALUES ('3334', '横栏镇', '442000110000', '442000000000');
INSERT INTO country VALUES ('3335', '南头镇', '442000111000', '442000000000');
INSERT INTO country VALUES ('3336', '阜沙镇', '442000112000', '442000000000');
INSERT INTO country VALUES ('3337', '南朗镇', '442000113000', '442000000000');
INSERT INTO country VALUES ('3338', '三乡镇', '442000114000', '442000000000');
INSERT INTO country VALUES ('3339', '板芙镇', '442000115000', '442000000000');
INSERT INTO country VALUES ('3340', '大涌镇', '442000116000', '442000000000');
INSERT INTO country VALUES ('3341', '神湾镇', '442000117000', '442000000000');
INSERT INTO country VALUES ('3342', '那大镇', '460400100000', '460400000000');
INSERT INTO country VALUES ('3343', '和庆镇', '460400101000', '460400000000');
INSERT INTO country VALUES ('3344', '南丰镇', '460400102000', '460400000000');
INSERT INTO country VALUES ('3345', '大成镇', '460400103000', '460400000000');
INSERT INTO country VALUES ('3346', '雅星镇', '460400104000', '460400000000');
INSERT INTO country VALUES ('3347', '兰洋镇', '460400105000', '460400000000');
INSERT INTO country VALUES ('3348', '光村镇', '460400106000', '460400000000');
INSERT INTO country VALUES ('3349', '木棠镇', '460400107000', '460400000000');
INSERT INTO country VALUES ('3350', '海头镇', '460400108000', '460400000000');
INSERT INTO country VALUES ('3351', '峨蔓镇', '460400109000', '460400000000');
INSERT INTO country VALUES ('3352', '王五镇', '460400111000', '460400000000');
INSERT INTO country VALUES ('3353', '白马井镇', '460400112000', '460400000000');
INSERT INTO country VALUES ('3354', '中和镇', '460400113000', '460400000000');
INSERT INTO country VALUES ('3355', '排浦镇', '460400114000', '460400000000');
INSERT INTO country VALUES ('3356', '东成镇', '460400115000', '460400000000');
INSERT INTO country VALUES ('3357', '新州镇', '460400116000', '460400000000');
INSERT INTO country VALUES ('3358', '洋浦经济开发区', '460400499000', '460400000000');
INSERT INTO country VALUES ('3359', '华南热作学院', '460400500000', '460400000000');

如题

这个应该有吧～

安徽省芜湖市弋江区是
{"id":"340203000000","name":"弋江区","url":"http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2020/34/02/340203.html"}
最新的是
[340209000000](http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2021/34/02/340209.html)

省、市、区，用children的方式进行嵌套的。不知道有没？

county里没有county_id=441900000000的数据 （东莞市），但是在town表里存在county_id=441900000000 的数据。

原因是东莞市没有county，从第二级（city）直接到第四级（town）了

方案：是否需要插入一条数据在county？

INSERT county VALUES(1,'东莞市','441900000000','441900000000')

信息：

SELECT * FROM town a
left JOIN county b ON  a.county_id = b.county_id
WHERE b.NAME IS null

SELECT * FROM city
WHERE city_id ='441900000000'