35 attribute fields, profiled from the April 2022 vintage.
Columns in Union County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 84875, 84876, 84877 | |
| acres | OFTString | 11.6k | 3.1100, 265.8900, 56.8500 | |
| doc1ref | OFTString | 50.0k | 7231 210, CS13 435, D148 0805 | |
| doc2ref | OFTString | 50.0k | W17E 0493, D148 0805, 6582 396 | |
| doc3ref | OFTString | 37.4k | CS13 540, 1835 723, 1465 822 | |
| legal1 | OFTString | 50.0k | 7231-210, MCCAIN MAGIC ROBINSON RD, 343-383 | |
| distnum | OFTString | 63 | 925, 925, 925 | |
| finsize | OFTString | 6.1k | 0, 0, 0 | |
| grantornam | OFTString | 50.0k | COOK ANGELA FAYE, MCCAIN WILLIAM DONALD & WF ANN J, FREEMAN, JIMMY L | |
| grantorn_1 | OFTString | 38.7k | COOK GEORGE K, FREEMAN, JIMMY L, FRENCH SABINE LEE | |
| grantorn_2 | OFTString | 23.7k | FRENCH ELFIE T, MUNTEANU NICOLAI HEIRS, PITTS JAMES S & MARJORIE | |
| imprtype | OFTString | — | ||
| landval1 | OFTInteger | — | ||
| owneraddre | OFTString | 50.0k | 10330 SCOTLAND AVE, 8110 S PROVIDENCE RD, PO BOX 210735 | |
| ownercity | OFTString | 1.4k | FORT MILL, WAXHAW, COLUMBIA | |
| ownerstate | OFTString | 57 | SC, NC, SC | |
| ownerzip | OFTString | 7.6k | 29707, 28173, 29221 | |
| ownername1 | OFTString | 50.0k | COOMBS BRUCE, MCCAIN WILLIAM DONALD JR, MCMULLEN JAMES F | |
| ownername2 | OFTString | 50.0k | COOMBS CHERYL, MCCAIN MARK STEPHEN, MCMULLEN WILLIAM C | |
| acctno | OFTString | 50.0k | 05189002A, 05189002, 05189001 | |
| propertyst | OFTString | 50.0k | 9105 TIRZAH CHURCH RD, 0 MAGIC ROBINSON RD, 0 TIRZAH CHURCH RD | |
| sale1amt | OFTString | 2.6k | 96000, 0, 0 | |
| sale2amt | OFTString | 2.4k | 0, 0, 56000 | |
| sale3amt | OFTString | 2.0k | 0, 53000, 35000 | |
| sale1d | OFTString | 7.3k | 09/07/2018, 09/12/2013, 05/29/2021 | |
| sale2d | OFTString | 7.3k | 12/02/2016, 05/29/2021, 12/11/2015 | |
| sale3d | OFTString | 6.7k | 12/17/2013, 05/31/2002, 11/15/2000 | |
| starea() | OFTReal | 50.0k | 115627.906677, 11013244.464783, 2748396.651611 | |
| stlength() | OFTReal | 50.0k | 3086.026919, 19759.997532, 7566.514183 | |
| shape_star | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| shape_stle | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| taxdwlg1 | OFTInteger | 9.5k | 43800, 0, 0 | |
| totval1 | OFTInteger | 11.6k | 90700, 1861700, 337700 | |
| usedesc | OFTString | 118 | 41 Double Wide Mobile Home, 62 Conventional 2.0+ 81-2000, 45 Modular Home | |
| yrbuilt | OFTString | 133 | 0, 0, 0 |
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.