# city_pull

**Repository Path**: Mr_shuai/city_pull

## Basic Information

- **Project Name**: city_pull
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-09-24
- **Last Updated**: 2024-09-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### jdk8 下通过 [国家统计局官网最新行政区数据](http://https://www.stats.gov.cn/sj/tjbz/tjyqhdmhcxhfdm/2023/) 获取5级行政区数据
![数据库图](https://foruda.gitee.com/images/1727172443600342133/e81f3d9c_1715162.png "iShot_2024-09-24_18.07.06.png")
并可存入如下表结构中：

```
CREATE TABLE area
(
    code   BIGINT UNSIGNED AUTO_INCREMENT COMMENT '区划代码'
        PRIMARY KEY,
    name   VARCHAR(32) DEFAULT '' NOT NULL COMMENT '名称',
    level  TINYINT(1)             NOT NULL COMMENT '级别1-5,省市县镇村',
    pcode  BIGINT                 NULL COMMENT '父级区划代码',
    pinyin VARCHAR(128)           NULL
)
    CHARSET = utf8mb4
    ROW_FORMAT = DYNAMIC;
```