Field dictionary

GEOID39021

Columns in Champaign County

Field	Type	Filled	Distinct	Example values
objectid	OFTInteger	100%	27.7k	1845, 1919, 2053
name	OFTString	96%	26.0k	K411110062300500, K411110062300600, K411110062300400
book_no	OFTString	87%	838	OR580, OR392, OR478
page_no	OFTString	87%	5.0k	3989, 3, 2837
surveys	OFTString	96%	26.0k	K411110062300500.pdf, K411110062300600.pdf, K411110062300400.pdf
parcel	OFTString	95%	25.7k	K41-11-10-06-23-005-00, K41-11-10-06-23-006-00, K41-11-10-06-23-004-00
parcel2	OFTString	95%	25.7k	K411110062300500, K411110062300600, K411110062300400
pptaxpayer	OFTString	95%	13.7k	CUSHMAN JAMES G & PEGGY J, MORGAN JOHN P, SHORT RICHARD KEITH & SHELLY N
pptaxpay_1	OFTString	95%	13.4k	4909 MUTUAL CATAWBA RD MECHANICSBURG OH 43044, 5148 E COUNTY LINE RD SPRINGFIELD OH 45502, 5108 E COUNTY LINE RD SPRINGFIELD OH 45502
ppacres	OFTReal	95%	8.4k	0.0, 0.0, 0.0
ppowner	OFTString	95%	15.0k	CUSHMAN JAMES G, MORGAN JOHN P, SHORT RICHARD KEITH
ppowneradd	OFTString	95%	15.1k	4909 MUTUAL CATAWBA RD MECHANICSBURG OH 43044, 5148 E COUNTY LINE RD SPRINGFIELD OH 45502, 5108 E COUNTY LINE RD SPRINGFIELD OH 45502
ppgrade	OFTString	51%	78	C, C, C+1
ppconditio	OFTString	51%	33	A-AVERAGE, A-AVERAGE, A-AVERAGE
pplivingar	OFTString	51%	2.8k	1334, 1670, 1661
ppyearbuil	OFTString	51%	340	1976, 1992, 1991
ppsaledate	OFTString	10%	665	2021-09-10, 2021-03-02, 2022-08-01
ppamount	OFTReal	10%	731	22000.0, 374900.0, 245000.0
ppclasscod	OFTString	95%	6	Residential, Residential, Residential
ppclassnum	OFTString	95%	99	500-RESIDENTIAL VACANT LAND, 510-SINGLE FAMILY DWELLING, 510-SINGLE FAMILY DWELLING
pplandvalu	OFTInteger	95%	9.6k	19100, 23870, 25580
ppimprvalu	OFTInteger	95%	12.3k	0, 105230, 190240
pptotalval	OFTInteger	95%	17.1k	19100, 129100, 215820
pphascauv	OFTInteger	95%	2	0, 0, 0
ppaddress	OFTString	95%	16.2k	E COUNTY LINE RD, 5148 E COUNTY LINE RD, 5108 E COUNTY LINE RD
shape__are	OFTReal	100%	27.3k	36804.0537109375, 39132.9113769531, 40449.0643310547
shape__len	OFTReal	100%	27.3k	816.814493117626, 833.099893415228, 844.255217136644

Why this differs from the next county over

There is no national parcel schema. Every assessor's office built its own, usually decades ago, usually inside whatever CAMA system it bought at the time. One county's owner column is OWNER_NAME, the next one's is own1, and a third splits it across four fields. Shapefile's ten-character DBF limit truncated a generation of them into things like TOTLNDVAL.

Nothing here is renamed or remapped. The columns above are exactly what is in the file, because a normalisation layer that quietly guesses wrong is worse than no normalisation at all — and every guess it makes is one you cannot audit.

The Filled column is the share of rows with a real value. Placeholder text such as n/a counts as empty; a column that is 100% present but 90% placeholder is a column that will disappoint you, and the profiler treats it accordingly.