Name: China Geocode Database
Creator: Oddity Software
License: https://www.odditysoftware.com/page-TOS.htm#terms-licenses

China Geocode Database v.2.0.0

2,149,695 Database Records

Explore 2,149,695 distinct geographic names across 2,149,695 source rows for China. Includes feature identifiers, coordinates, designations and current source codes.

The package includes 33 current NGA fields in CSV, JSON and SQLite, plus schemas, samples and field statistics. Names and coordinates should be verified for operational use.

2,149,695 Records

SAMPLE DATA TABLE STRUCTURE RECORD INFO

Table Schema Database Field Statistics

Release structure

China Geocode Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database: #623
Version: 2.0.0
Format: XML schema

Data dictionary

Tables and fields

Release-defined structure

Table	Records	Fields
geographic_names	2149695	rk, ufi, uni, full_name, nt, lat_dd, long_dd, efctv_dt, term_dt_f, term_dt_n, desig_cd, fc, cc_ft, adm1, ft_link, name_rank, lang_cd, transl_cd, script_cd, name_link, cc_nm, generic, full_nm_nd, sort_gen, sort_name, lat_dms, long_dms, mgrs, mod_dt_ft, mod_dt_nm, dialect_cd, display, gis_notes

Release at a glance

What is inside this database

2,149,695 distinct names in 2,149,695 source rows.

2,149,695Geographic Names

Feature Class

P1,871,682
A195,126
L27,128
H26,648
T19,104
S9,778
R181
V48

Table and column statistics

Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

geographic names2,149,695 records · 33 fields

Distinct: 5
Missing: 0 (0.0%)

ufi

Distinct: 923,691
Missing: 0 (0.0%)

uni

Distinct: 2,149,695
Missing: 0 (0.0%)

full_name

Distinct: 1,027,240
Missing: 0 (0.0%)

Distinct: 7
Missing: 0 (0.0%)

lat_dd

Distinct: 790,739
Missing: 0 (0.0%)

long_dd

Distinct: 726,317
Missing: 0 (0.0%)

efctv_dt

Distinct: 9
Missing: 2,149,659 (100.0%)

term_dt_f

Distinct: 1,029
Missing: 2,128,513 (99.0%)

term_dt_n

Distinct: 26
Missing: 2,149,626 (100.0%)

desig_cd

Distinct: 261
Missing: 0 (0.0%)

Distinct: 8
Missing: 0 (0.0%)

cc_ft

Distinct: 27
Missing: 0 (0.0%)

adm1

Distinct: 43
Missing: 0 (0.0%)

ft_link

Distinct: 1
Missing: 2,149,693 (100.0%)

name_rank

Distinct: 6
Missing: 1,181,587 (55.0%)

lang_cd

Distinct: 16
Missing: 98,355 (4.6%)

transl_cd

Distinct: 20
Missing: 1,395,852 (64.9%)

script_cd

Distinct: 7
Missing: 1,524,998 (70.9%)

name_link

Distinct: 2,021,654
Missing: 125,765 (5.9%)

cc_nm

Distinct: 26
Missing: 2,148,373 (99.9%)

generic

Distinct: 740
Missing: 2,034,923 (94.7%)

full_nm_nd

Distinct: 1,025,938
Missing: 0 (0.0%)

sort_gen

Distinct: 730
Missing: 2,034,923 (94.7%)

sort_name

Distinct: 1,011,423
Missing: 0 (0.0%)

lat_dms

Distinct: 104,582
Missing: 0 (0.0%)

long_dms

Distinct: 144,546
Missing: 0 (0.0%)

mgrs

Distinct: 923,330
Missing: 0 (0.0%)

mod_dt_ft

Distinct: 30,072
Missing: 0 (0.0%)

mod_dt_nm

Distinct: 29,353
Missing: 0 (0.0%)

dialect_cd

Distinct: 2
Missing: 2,143,144 (99.7%)

display

Distinct: 9
Missing: 0 (0.0%)

gis_notes

Distinct: 0
Missing: 2,149,695 (100.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

geographic namesDownload this sample CSV

rk	ufi	uni	full_name	nt	lat_dd	long_dd	term_dt_f	desig_cd	fc	cc_ft	adm1	name_rank	lang_cd	transl_cd	script_cd	name_link	generic	full_nm_nd	sort_gen	sort_name	lat_dms	long_dms	mgrs	mod_dt_ft	mod_dt_nm	display
5	6066859	6073603	Chengdong	N	27.755929	118.034567	2002-11-01T00:00:00.000Z	ADM4	A	CHN	CN-000	1	zho	zho_Hani2Latn_GCH_1979		14446770		Chengdong		CHENGDONG	27:45:21	118:02:04	50RPR0195370595	2025-04-29T13:40:15.000Z	2019-05-09T00:00:00.000Z	1,2,3,4,5
5	13483968	19334676	Checuo Shequ	N	24.832512	118.532021		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19334677		Checuo Shequ		CHECUOSHEQU	24:49:57	118:31:55	50RPN5481747272	2019-09-18T00:00:00.000Z	2019-07-08T00:00:00.000Z	1,2
5	6258836	19335040	Dabulin Shequ	N	24.729104	118.524034		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19335039		Dabulin Shequ		DABULINSHEQU	24:43:45	118:31:27	50RPN5413735810	2019-09-18T00:00:00.000Z	2019-06-07T00:00:00.000Z	1,2
5	11853883	14446362	禾山镇	NS	24.498527	118.126491	2004-07-08T00:00:00.000Z	ADM4	A	CHN	CN-000		zho		Hans	14446206	镇	禾山镇	镇	禾山镇	24:29:55	118:07:35	50RPN1413609888	2025-04-29T13:40:15.000Z	2019-03-13T00:00:00.000Z	1,2,3,4,5
5	10140715	19333651	Donghai Jiedao	N	24.88136	118.619137		ADM4	A	CHN	CN-FJ	2	zho	zho_Hani2Latn_GCH_1979		19333650	Jiedao	Donghai Jiedao	JIEDAO	DONGHAIJIEDAO	24:52:53	118:37:09	50RPN6355752784	2019-06-05T00:00:00.000Z	2019-06-04T00:00:00.000Z	1,2,3,4,5
5	6258845	19335361	Yingtang Shequ	N	24.738896	118.54435		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19335362		Yingtang Shequ		YINGTANGSHEQU	24:44:20	118:32:40	50RPN5618036918	2019-09-18T00:00:00.000Z	2019-06-10T00:00:00.000Z	1,2
5	-1902626	13963445	Datong Jiedao	N	24.736538	118.141975		ADM4	A	CHN	CN-FJ	2	zho	zho_Hani2Latn_GCH_1979		13963446	Jiedao	Datong Jiedao	JIEDAO	DATONGJIEDAO	24:44:12	118:08:31	50RPN1548636257	2019-06-11T00:00:00.000Z	2015-11-13T00:00:00.000Z	1,2,3,4,5
5	13483940	19337955	Dongpu Shequ	N	24.896983	118.564738		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19337956		Dongpu Shequ		DONGPUSHEQU	24:53:49	118:33:53	50RPN5804154450	2019-09-18T00:00:00.000Z	2019-07-08T00:00:00.000Z	1,2
5	9164099	19327823	Dalonggecun	N	24.997121	117.887968		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19327824		Dalonggecun		DALONGGECUN	24:59:50	117:53:17	50RNN8960964922	2020-08-07T00:00:00.000Z	2019-05-30T00:00:00.000Z	1,2
5	11853883	14446361	禾山	NS	24.498527	118.126491	2004-07-08T00:00:00.000Z	ADM4	A	CHN	CN-000		zho		Hans	14446344		禾山		禾山	24:29:55	118:07:35	50RPN1413609888	2025-04-29T13:40:15.000Z	2019-03-13T00:00:00.000Z	1,2,3,4,5
5	14779756	19335868	地质社区	NS	24.927638	118.624599		PPL	P	CHN	CN-FJ		zho		Hans	19335867		地质社区		地质社区	24:55:39	118:37:29	50RPN6404857916	2019-09-18T00:00:00.000Z	2019-06-11T00:00:00.000Z	1,2
5	13483952	19334378	Beixing Shequ	N	24.885269	118.679341		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19334377		Beixing Shequ		BEIXINGSHEQU	24:53:07	118:40:46	50RPN6963553290	2019-09-18T00:00:00.000Z	2019-06-05T00:00:00.000Z	1,2
5	14779717	19327406	东北	VS	24.920111	118.590051		PPL	P	CHN	CN-FJ		zho		Hans	19326437		东北		东北	24:55:12	118:35:24	50RPN6056957041	2019-09-18T00:00:00.000Z	2019-06-11T00:00:00.000Z	1,2
5	11853883	14446206	Heshan Zhen	N	24.498527	118.126491	2004-07-08T00:00:00.000Z	ADM4	A	CHN	CN-000	2	zho	zho_Hani2Latn_GCH_1979		14446362	Zhen	Heshan Zhen	ZHEN	HESHANZHEN	24:29:55	118:07:35	50RPN1413609888	2025-04-29T13:40:15.000Z	2019-03-13T00:00:00.000Z	1,2,3,4,5
5	14779617	19337788	Dongmei Shequ	N	24.891902	118.604699		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19337789		Dongmei Shequ		DONGMEISHEQU	24:53:31	118:36:17	50RPN6208553934	2019-09-18T00:00:00.000Z	2019-06-11T00:00:00.000Z	1,2
5	10160421	19334496	Changtai Jiedao	N	24.914743	118.509845		ADM4	A	CHN	CN-FJ	2	zho	zho_Hani2Latn_GCH_1979		19334497	Jiedao	Changtai Jiedao	JIEDAO	CHANGTAIJIEDAO	24:54:53	118:30:35	50RPN5247456354	2019-06-06T00:00:00.000Z	2019-06-06T00:00:00.000Z	1,2,3,4,5
5	14779754	19334681	Chengkou Shequ	N	24.929584	118.572944		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19334682		Chengkou Shequ		CHENGKOUSHEQU	24:55:47	118:34:23	50RPN5882958070	2019-09-18T00:00:00.000Z	2019-06-06T00:00:00.000Z	1,2
5	6258721	6288387	Puzhao Shequ	N	24.798421	118.571693		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19334678		Puzhao Shequ		PUZHAOSHEQU	24:47:54	118:34:18	50RPN5887043542	2019-09-18T00:00:00.000Z	2019-06-06T00:00:00.000Z	1,2
5	13483946	19333747	Baoshan Shequ	N	24.890273	118.643932		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19333746		Baoshan Shequ		BAOSHANSHEQU	24:53:25	118:38:38	50RPN6605153801	2019-09-18T00:00:00.000Z	2019-07-08T00:00:00.000Z	1,2
5	14779680	19335013	Cujin Shequ	N	24.902921	118.593471		PPL	P	CHN	CN-FJ	1	zho	zho_Hani2Latn_GCH_1979		19335014		Cujin Shequ		CUJINSHEQU	24:54:11	118:35:36	50RPN6093655141	2019-09-18T00:00:00.000Z	2019-06-07T00:00:00.000Z	1,2

Records Information

2,149,695 geographic name rows; 2,149,695 distinct UNI name identifiers; 923,691 distinct UFI feature identifiers. Shared-country name rows are included only when the exact CHN token occurs in cc_ft.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

Discuss your data needs Explore the catalog

License rights

Single Product Publication

Read the complete Oddity Software Single Product Publication License

Use the entire listed package for internal work, customer-facing websites and apps, and client projects. The license is for this product, not one named project. Raw dataset handoff or standalone resale needs a separate grant.

Downloads of an eligible purchased version are unlimited while it remains the current public version. A newer release does not automatically become part of the earlier order.

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Database guides and examples Working with file formats Samples and record counts Licenses and permitted use Ask about this database

Oddity Software - Databases, Development and Design

China Geocode Database

Flexible data delivery

China Geocode Database v.2.0.0

2,149,695 Database Records

Table Schema Database Field Statistics

China Geocode Database

Tables and fields

What is inside this database

Feature Class

Table and column statistics

Representative sample data

Records Information

Data shaped around your project.

Find a database

RECENT DATA UPDATES

BROWSE CONTENT LISTS

Custom Data Solutions

Database Help

Single Product Publication

Get more from your data

How can we help?

Tell us what happened

Request received

Details