# kakuilan/china_area_mysql

中国5级行政区域mysql库

Repository: https://github.com/kakuilan/china_area_mysql
Canonical: https://ross.abutalabs.com/products/china_area_mysql
License Family: other
Last push: 2024-07-29T01:38:13+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 3835, "days_push": 766, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5349, forks 1232 (observed 2026-08-28T04:09:15.914603+00:00)

## What it is
A MySQL dataset of China's five-level administrative divisions (province, city, county, town, village) scraped from the National Bureau of Statistics, including zip codes and latitude/longitude for mainland areas. It ships as SQL dump files (e.g., cnarea_2023) with over 750,000 records.

## Use cases
- populate a dropdown of Chinese provinces, cities, and districts in a form
- look up zip codes and coordinates for Chinese addresses
- build a cascading region selector for a shipping address form
- map Chinese administrative area codes to names and parent regions
- analyze regional data by county or township in China

## When to choose
- you need a complete, hierarchical Chinese administrative division dataset in MySQL
- you want zip codes and lat/lng included for mainland regions
- you need village/community-level granularity, not just provinces and cities

## When to avoid
- you use a database other than MySQL and don't want to convert the dump
- you need frequently updated or officially licensed boundary polygons rather than tabular divisions
- you need worldwide or non-China administrative data

## Facets
- artifact type: dataset
- maturity: active
- function: database, geospatial, data-science
- domain: databases
- platform: self-hosted
- tags: china-area-codes, administrative-divisions, mysql-dump, zip-codes, geocoding, maps, china, mysql

## Member repositories
- kakuilan/china_area_mysql (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:15.914603+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:58:48.030656+00:00, confidence not recorded.
  - readme: https://github.com/kakuilan/china_area_mysql (fetched 2026-08-28T04:09:15.914603+00:00, sha 787c21258bce)
- Data as of 2026-08-30T08:39:29.467469+00:00.