Ross ROSS = Recommend OSS · open-source software intelligence for agents

kakuilan/china_area_mysql resource

中国5级行政区域mysql库 observed · 2026-08-28

github.com/kakuilan/china_area_mysql observed · 2026-08-28

Health v2 · maintenance only

32/100

  • Activity 0
  • Release rhythm 35
  • Longevity 100

Flags: no_releases no_license

How is this computed?

round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.

  • gap_med: n/a
  • age_days: 3835
  • days_rel: n/a
  • days_push: 766
  • n_releases_24m: 0

Full methodology

Adoption not part of the score

5349 stars · 1232 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

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

dataset · maturity active

database geospatial data-science databases self-hosted china-area-codes administrative-divisions mysql-dump zip-codes geocoding maps china mysql

1 source

Member repositories

RepositoryRoleHealth v2
kakuilan/china_area_mysqlmain32

For agents

markdown · JSON · MCP: product_card(name="kakuilan/china_area_mysql")

Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem