wecatch / china_regions Goto Github PK

View Code? Open in Web Editor NEW

3.0K 3.0K 922.0 49.51 MB

最全最新**省，市，地区json及sql数据

Home Page: http://wecatch.me/china_regions/

License: Apache License 2.0

JavaScript 99.91% HTML 0.02% Shell 0.01% Python 0.05% Makefile 0.01% Handlebars 0.01%

china china-city china-location china-regions

china_regions's Introduction

wecatch

china_regions's People

Contributors

Stargazers

Watchers

Forkers

xieisabug lumint duckywang1 daienhua lingmissing hellojvm wuyinxing yuxhuang frank-young langthron aiephoenix bopo sdbruli hjkl0001 ousay reyboo hailengc oneyx yunyi1895 sergisoing zation alvin1992 leadnt jaychang9 polokobe toby1024 liuganghao ibmsoft maskletter aurora813 pocketdigi yangzilong1986 hpf911 hwedwin rukai0712 zhangyaohai carltony tinyvampirepudge itmuse thisisjiezhang li5t minionsdave jet2007 astroshot zeus911 dllen yyxx9988 phoebeliu cndubian liuqixing shangxinbo hc1213 likeadogandcat zzl81cn nojiang raymondmars 994866755 lllyin bingtel santong bai-yuhong ghgithub qq397709884 zhaoshiling1017 thomposer ehoolei pixiuyan likeshan168 zengyishan fairyly sunhongfeiraven zxjava lizhangwei barrywu12 java-components hicode dusong0717 dylanwooo mengdianyun cjshinning tangxunhu geneseeq odinman yljphp supersn melantha soldier9527 jingleo squirrelschen whu404 jevonk coullin hailong4wish chaunceyhuo yunyaolong edisonhexuan cuitymiko cement roottan zhongkebairong

china_regions's Issues

市辖区在第三级是不是多余的？

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

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

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

缺失数据

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'

删除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>

这个项目用不了了么

现在完全获取不了数据了

city.json 中可能存在错误数据

在 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": [],

为什么在 city.json 里面会有 name 为 “省直辖县级行政区划” 的 object，是否要去掉？

表命名错了："country"是国家的意思，"county"才是县的意思。差了一个字母'r'。

数据缺失

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

sql文件中天津市数据重复

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

统计局数据地址更新了现在是 http://www.stats.gov.cn/sj/tjbz/qhdm/

失效了，兄嘚！~

这个库已经不更新了吗？杭州市2021年底撤换了两个市，并没有更新数据

**，香港，澳门都没有？？？？

省市区全部整合到一张就好了。这样太麻烦。。。

数据缺失

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

inset SQL语句里面的列名带有单引号，所以无法正常的执行。希望作者改进下

如题

广东省东莞市为不设区的地级市数据缺失

js数据不全

浙江省宁波市江东区没有

没有**省

这个应该有吧～

数据未更新，这个项目还在维护么

安徽省芜湖市弋江区是
{"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)

市辖区三个字能不能去掉？

demo bug

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

有没有含港澳台的版本

sqlite生成的市的表有问题

四个直辖市没有

为什么Json里市级别的内容里总是有个name为县的json？

建议sql以这种格式插入

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

增加东莞中山儋州

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');