# 中国行政区域geo sqlite数据库

**Repository Path**: hsq168/China_Area_Geo

## Basic Information

- **Project Name**: 中国行政区域geo sqlite数据库
- **Description**: 中国行政区域geo sqlite数据库
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-07-13
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 中国geo sqlite数据库

#### 介绍
Database目录下载,生成最新可以clone代码执行
 


##### 数据验证方法
 ```sql
SELECT 
       *, 
       (WITH RECURSIVE
         [split]([content], [last], [rest]) AS(
           VALUES ('', '', [center])
           UNION ALL
           SELECT 
                  CASE WHEN [last] = ',' THEN SUBSTR ([rest], 1, 1) ELSE [content] || SUBSTR ([rest], 1, 1) END, 
                  SUBSTR ([rest], 1, 1), 
                  SUBSTR ([rest], 2)
           FROM   [split]
           WHERE  [rest] <> ''
         )
       SELECT REPLACE ([content], ',', '') AS 'ValueSplit'
       FROM   [split]
       WHERE  [last] = ',' OR [rest] = ''
       limit 1
       offset 1) AS [_lat], 
 
       (WITH RECURSIVE
         [split]([content], [last], [rest]) AS(
           VALUES ('', '', [center])
           UNION ALL
           SELECT 
                  CASE WHEN [last] = ',' THEN SUBSTR ([rest], 1, 1) ELSE [content] || SUBSTR ([rest], 1, 1) END, 
                  SUBSTR ([rest], 1, 1), 
                  SUBSTR ([rest], 2)
           FROM   [split]
           WHERE  [rest] <> ''
         )
       SELECT REPLACE ([content], ',', '') AS 'ValueSplit'
       FROM   [split]
       WHERE  [last] = ',' OR [rest] = ''
       limit 1
       offset 0) AS [_long]
FROM   (SELECT 
               *, 
                (([longitude] || ',' || [latitude]) ) as [_center],
               (([longitude] || ',' || [latitude]) = [center]) AS [has]
        FROM   [china_area]) AS t
WHERE  [has] = 0;
```