57 attribute fields, profiled from the April 2024 vintage.
Columns in Hamilton County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 17897, 19987, 25097 | |
| parcel_typ | OFTInteger | 4 | 1, 1, 1 | |
| pba_num | OFTString | 50.0k | 033164 00300P000, 033164 00100P000, 033176 00100P000 | |
| gislink | OFTString | 50.0k | 033164 00300, 033164 00100, 033176 00100 | |
| ownername1 | OFTString | 50.0k | TINKER MARK L, WILLIAMS GREGORY DALE ETAL, CARR PAUL D | |
| ownername2 | OFTString | 20.7k | MC NABB GLYNDAL W, DOHRER RENAE, GARCIA MACDONALD LAURA D | |
| stnum | OFTString | 13.3k | 541, 3301, 5065 | |
| dirpfx | OFTString | — | ||
| stname | OFTString | 6.0k | WHITESIDE, WHITESIDE, HWY 134 | |
| typesfx | OFTString | 57 | RD, RD, I-24 | |
| address | OFTString | 50.0k | WHITESIDE RD, WHITESIDE RD, 541 HWY 134 | |
| map | OFTString | 1.2k | 164, 164, 176 | |
| group_ | OFTString | 26 | A, A, E | |
| parcel | OFTString | 8.7k | 003, 001, 001 | |
| tax_map_no | OFTString | 50.0k | 164 003, 164 001, 176 001 | |
| mastnum | OFTString | — | ||
| madirpfx | OFTString | — | ||
| mastname | OFTString | 50.0k | 284 PINECREST DR, P O BOX 696, 3563 HWY 299 | |
| matypesfx | OFTString | — | ||
| maline2 | OFTString | 832 | 395 9TH AVE 58TH FL, 175 OLIVE MILL LN, 4700 CUMMINGS COVE DR | |
| macity | OFTString | 2.0k | WILDWOOD, BONSALL, WILDWOOD | |
| mastate | OFTString | 61 | GA, CA, GA | |
| mazip | OFTString | 5.3k | 30757, 92003-0696, 30707 | |
| legaldesc1 | OFTString | 50.0k | PT SE 1/4 SEC 3 2 TWP 2 R-5, WHITESIDE RD, WHITESIDE RD | |
| calcacres | OFTReal | 4.0k | 8.5, 57.5, 3.0 | |
| lucode | OFTReal | 176 | 910.0, 910.0, 910.0 | |
| neighcode | OFTString | 176 | 1, 1, 1 | |
| landvalue | OFTReal | 6.7k | 13600.0, 94900.0, 12400.0 | |
| buildvalue | OFTReal | 9.6k | 0.0, 0.0, 0.0 | |
| yarditemsv | OFTReal | 1.6k | 0.0, 0.0, 0.0 | |
| appvalue | OFTReal | 12.4k | 13600.0, 94900.0, 12400.0 | |
| assvalue | OFTReal | 15.3k | 3400.0, 23725.0, 3100.0 | |
| district | OFTString | 12 | 3, 3, 3 | |
| proptype | OFTString | 42 | 22, 22, 22 | |
| exemptcode | OFTString | 4 | EX, EX, EX | |
| sale1date | OFTString | 13.5k | 2020-06-24, 2010-12-16, 1985-07-29 | |
| sale1consd | OFTReal | 12.4k | 7000.0, 0.0, 18000.0 | |
| sale1book | OFTString | 12.3k | 12066, 9313, 3112 | |
| sale1page | OFTString | 1.8k | 0838, 0152, 0567 | |
| sale2date | OFTString | 14.5k | 2006-03-31, 1998-02-02, 1984-08-08 | |
| sale2consd | OFTReal | 11.7k | 7500.0, 0.0, 4000.0 | |
| sale2book | OFTString | 12.5k | 7890, 5056, 3014 | |
| sale2page | OFTString | 2.3k | 0442, 0448, 0012 | |
| sale3date | OFTString | 14.5k | 1986-03-03, 1983-06-03, 1983-01-13 | |
| sale3consd | OFTReal | 10.2k | 1500.0, 14375.0, 0.0 | |
| sale3book | OFTString | 12.4k | 3178, 2899, 2870 | |
| sale3page | OFTString | 2.3k | 0538, 0812, 0617 | |
| sale4date | OFTString | 13.9k | 1986-03-03, 1979-10-23, 1979-09-26 | |
| sale4consd | OFTReal | 8.4k | 1500.0, 0.0, 11092.0 | |
| sale4book | OFTString | 11.8k | 3453, 2817, ITEM | |
| sale4page | OFTString | 2.2k | 0721, 0512, 6531 | |
| currentuse | OFTString | 53 | RS, RS, RS | |
| recordsonl | OFTString | 50.0k | ||
| neighborho | OFTString | 603 | LKT VLLY, LKT VLLY, LKT VLLY | |
| neighbor_1 | OFTString | 603 | Lookout Valley, Lookout Valley, Lookout Valley | |
| shape_leng | OFTReal | 50.0k | 2756.75055152334, 6975.18239116635, 2520.07678048839 | |
| shape_area | OFTReal | 50.0k | 438200.277416429, 2484637.80974857, 121496.750068796 |
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.