# district

**Repository Path**: netwenk/district

## Basic Information

- **Project Name**: district
- **Description**: scrapy爬取国家统计局行政区划，仅供学习
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-05-14
- **Last Updated**: 2021-05-14

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# district

#### 介绍
scrapy爬取国家统计局行政区划，仅供学习

数据库


```
CREATE TABLE `district` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '名称',
  `father_id` int(10) NOT NULL DEFAULT '0' COMMENT '上级',
  `initials` varchar(10) NOT NULL DEFAULT '' COMMENT '首字母',
  `level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '层级',
  `lat` float(10,6) NOT NULL DEFAULT '0.000000' COMMENT '纬度',
  `lng` float(10,6) NOT NULL DEFAULT '0.000000' COMMENT '经度',
  `create_at` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_at` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
```


scrapy crawl region