Location codes

City weather, AQI, and life-index APIs locate a city via city_uid, city_code (GB2260), city_name, or lat+lon.

Downloads

Excel (recommended): china_cities.xlsx
- Sheet cities: city master data
- Sheet weather_codes: weather phenomenon codes
CSV: weather_codes.csv

About 3228 active cities (see the attachment for the authoritative list).

Field	Description
`city_uid`	Internal city ID (request param `city_uid`)
`city_code`	GB2260 code (request param `city_code`)
`city_name_cn`	Chinese name (request may use `city_name`)
`city_name_en`	English name
`longitude` / `latitude`	Representative coordinates
`parent_city_name_cn`	Parent city
`parent_province_name_cn`	Province
`timezone`	Timezone

cd ../sunnymeteo_web
../weather_etl/.venv/bin/python scripts/export-docs-assets.py
cp mintlify/assets/china_cities.xlsx ../docs/files/