47 attribute fields, profiled from the November 2022 vintage.
Columns in Deuel County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| record | OFTString | 5.7k | 637, 638, 639 | |
| owner1 | OFTString | 3.1k | DAVID L & MARCEEN A NYSTROM LIVING TRUST, EDWARD A TRAVNICEK TRUST, ROGER & JUNE CARLSON LE | |
| add_l_owne | OFTString | 255 | ROBERT LEE VAN WORMER, ALAN D HAWLEY & PAUL R HAWLEY, RONALD J GORDER & KATHY A GORDER | |
| legal | OFTString | 4.4k | GOV LOT 4 & SE1/4 SW1/4 LESS E860' W2410' S355' & S1/2 SE1/4, E860' W2410' S355' IN S1/2 SW1/4, GOV LOT 1 LESS W32 RODS N52 RODS & GOV LOT 2 & E1/2 NW1/4 | |
| legal_acre | OFTString | 1.9k | 397.09, 152.81, 007.01 | |
| prop_stree | OFTString | 2.8k | 46609 SD HWY 28, STR 30-113-50, 46634 195 ST | |
| twn_twp | OFTString | 23 | GRANGE TOWNSHIP, GRANGE TOWNSHIP, GRANGE TOWNSHIP | |
| section_lo | OFTString | 40 | 30, 30, 30 | |
| twp_block | OFTString | 38 | 113, 113, 113 | |
| township | OFTString | 5 | 113N, 113N, 113N | |
| range | OFTString | 4 | 50W, 50W, 50W | |
| str | OFTString | 661 | 30-113N-50W, 30-113N-50W, 30-113N-50W | |
| quarter | OFTString | 5 | 1, 3, 3 | |
| sixteenth | OFTString | 5 | 2, 3, 4 | |
| addition | OFTString | 122 | 0, 0, 0 | |
| split | OFTString | 292 | 0010, 0010, 0020 | |
| owner_stre | OFTString | 2.3k | PO BOX 213, 298 EXETER ROAD, APT 207, 17781 468 AVE | |
| owner_city | OFTString | 318 | ESTELLINE, HAMPTON, GOODWIN | |
| owner_st | OFTString | 39 | SD, NH, SD | |
| owner_zip | OFTString | 469 | 57234, 03842-, 57238 | |
| school_dis | OFTString | 7 | 28-2, 28-2, 28-2 | |
| land_code | OFTString | 3 | A, A, C | |
| filed_date | OFTString | 2.0k | 01/16/2007, 11/07/2013, 12/09/2005 | |
| instrument | OFTString | 2.1k | 01/04/2007, 10/18/2013, 12/07/2005 | |
| book | OFTString | 92 | 2007, 2013, 2005 | |
| page | OFTString | 599 | 1019, 1279, 1326 | |
| deed_type | OFTString | 42 | QCD, TD, WD | |
| lot_size | OFTString | 992 | 145X208, 150X208, 25X90 | |
| year_built | OFTString | 145 | 2005, 0, 0 | |
| sale_type | OFTString | 3 | 0, 2, 0 | |
| sale_numbe | OFTString | 596 | 0, 5426, 0 | |
| selling_pr | OFTString | 731 | 0, 0, 0 | |
| sale_year | OFTString | 17 | 0, 2013, 0 | |
| code_name | OFTString | 3 | AG, AG, NON-AG | |
| owner_occu | OFTString | 1 | OWNER OCCUPIED, OWNER OCCUPIED, OWNER OCCUPIED | |
| record_q | OFTString | 5.7k | 637, 638, 639 | |
| build_tv | OFTReal | 2.6k | 182082.0, 0.0, 0.0 | |
| land_tv | OFTReal | 4.4k | 481878.0, 204452.0, 77708.0 | |
| mh_tv | OFTReal | 117 | 0.0, 0.0, 0.0 | |
| total_av | OFTReal | 5.2k | 663960.0, 204452.0, 77708.0 | |
| up_date | OFTString | 32 | 2015-01-01, 2015-01-01, 2015-01-01 | |
| comments | OFTString | 5 | UPDATE AUGUST 2020, UPDATE AUGUST 2020, UPDATE AUGUST 2020 | |
| ckd | OFTString | 1 | OK, OK, OK | |
| extent | OFTReal | 6.8k | 17559061.587852, 6743605.1317803, 305300.279263242 | |
| objectid | OFTInteger | 6.8k | 4482, 4483, 4484 | |
| shape_leng | OFTReal | 6.8k | 26528.1436182241, 13985.3966435102, 2430.00133085948 | |
| shape_area | OFTReal | 6.8k | 17559061.587852, 6743605.1317803, 305300.279263242 |
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.