Aged
109 attribute fields, profiled from the October 2022 vintage.
Columns in St. Clair County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 11.0k | 153, 176, 177 | |
| pid | OFTString | 10.9k | 20-8.0-33-000-000-004.00, 20-8.0-34-000-000-001.00, 20-8.0-34-000-000-002.00 | |
| gis_acres | OFTReal | 10.3k | 0.437868, 319.654467, 320.941644 | |
| comments | OFTString | 20 | MAINT, MAINT, MAINT | |
| parcelid | OFTInteger | 10.9k | 11739, 11740, 11741 | |
| parcelnumb | OFTReal | 8.3k | 2.08033000000004e+16, 2.08034000000001e+16, 2.08034000000002e+16 | |
| formattedp | OFTString | 10.9k | 20-8.0-33-000-000-004.00, 20-8.0-34-000-000-001.00, 20-8.0-34-000-000-002.00 | |
| localutili | OFTString | — | ||
| createdate | OFTString | 375 | 2010-10-31, 2010-10-31, 2010-10-31 | |
| deacdate | OFTString | — | ||
| maintdate | OFTString | 358 | 2021-01-02, 2021-01-02, 2021-01-02 | |
| maintuser | OFTString | 7 | ic, ic, ic | |
| locationad | OFTString | — | ||
| locationdi | OFTString | — | ||
| locationst | OFTString | 8.4k | CNTY RD, S & E OF RD, 395 SW 1300 RD | |
| locationsu | OFTString | — | ||
| legaldescr | OFTString | 9.5k | PT SE 1/4 SW 1/4, E 1/2, W2 ENTIRE SECTION | |
| legaldes_1 | OFTString | 1.7k | NE 1/4 SW 1/4 & PT E 1/2 SW 1/4, /4, X CEM) | |
| legaldes_2 | OFTString | 242 | TRIANGLE IN NW COR S 1/2 SE4 SE4, NE 665.21' TO POB); ALSO BEG NW COR E 1/2 NE4 NE4, COMM NE COR W 1/2 NE4 TH S 659.73' AS POB: TH S | |
| legaldes_3 | OFTString | 33 | TH E 80.93' TH SW 664.74' TH N 659.73' TO POB, 660.23' TH W 80.98' TH NE 665.21' TO POB, TO POB | |
| fulllegald | OFTString | 47 | TH PT W2 SW4 LY EAST OF CO RD, ALL TH PT SW4 LY S OF HWY W & WEST OF RBSR (EX S2 SE4 SW4), W2 NE4 SE4 | |
| sec | OFTInteger | 37 | 33, 34, 34 | |
| twp | OFTInteger | 12 | 36, 36, 36 | |
| rge | OFTInteger | 12 | 26, 26, 26 | |
| deedacres | OFTReal | 2.2k | 0.6, 328.2, 326.9 | |
| mappedacre | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| overrideac | OFTReal | 40 | 0.0, 0.0, 0.0 | |
| calcacres | OFTReal | 2.2k | 0.6, 328.2, 326.9 | |
| owner1 | OFTString | 7.8k | PRESTON CEMETERY, LGS HOLDING GROUP 2013, LLC, WILLINGER, BONNIE AS TRUSTEE | |
| owner2 | OFTString | 586 | OF THE BMW FAMILY TRUST, OF THE BMW FAMILY TRUST, WARREN TODD ROLAND | |
| ownercareo | OFTString | 442 | WILSON TIRE, WILSON TIRE, 21ST MORTGAGE CORP | |
| ownermaili | OFTString | 6.3k | 235 CORPORATE CENTER DRIVE-SUITE 100, 608 E HILLCREST, 395 SW 1300 RD | |
| ownermai_1 | OFTString | 72 | 1401 ELM, STORE #385, STE 1000 | |
| ownercity | OFTString | 659 | STOCKBRIDGE, STOCKTON, STOCKTON | |
| ownerstate | OFTString | 46 | GA, MO, MO | |
| ownerzip1 | OFTInteger | 750 | 0, 30281, 65785 | |
| ownerzip2 | OFTInteger | 182 | 1225, 1225, 9802 | |
| neighborho | OFTString | 13 | Z2, Z2, Z2 | |
| subdivisio | OFTString | 1 | 2 | |
| notes | OFTString | 1.1k | COUNTY WIDE SITE VALUE INCREASE 2021, COUNTY WIDE SITE VALUE INCREASE 2021, COUNTY WIDE SITE VALUE INCREASE 2021 | |
| aglandcomp | OFTInteger | 747 | 0, 32000, 57900 | |
| agbldgcomp | OFTInteger | 577 | 0, 0, 0 | |
| agtotalcom | OFTInteger | 950 | 0, 32000, 57900 | |
| reslandcom | OFTInteger | 224 | 0, 0, 0 | |
| resbldgcom | OFTInteger | 1.4k | 0, 0, 0 | |
| restotalco | OFTInteger | 1.5k | 0, 0, 0 | |
| comlandcom | OFTInteger | 121 | 0, 0, 0 | |
| combldgcom | OFTInteger | 258 | 0, 0, 0 | |
| comtotalco | OFTInteger | 289 | 0, 0, 0 | |
| exlandcomp | OFTInteger | 23 | 0, 0, 0 | |
| exbldgcomp | OFTInteger | 17 | 0, 0, 0 | |
| extotalcom | OFTInteger | 31 | 0, 0, 0 | |
| utillandco | OFTInteger | 1 | 0, 0, 0 | |
| utilbldgco | OFTInteger | 1 | 0, 0, 0 | |
| utiltotalc | OFTInteger | 1 | 0, 0, 0 | |
| aglandovrd | OFTInteger | 1 | 0, 0, 0 | |
| agbldgovrd | OFTInteger | 1 | 0, 0, 0 | |
| reslandovr | OFTInteger | 19 | 0, 0, 0 | |
| resbldgovr | OFTInteger | 1 | 0, 0, 0 | |
| comlandovr | OFTInteger | 6 | 0, 0, 0 | |
| combldgovr | OFTInteger | 1 | 0, 0, 0 | |
| exlandovrd | OFTInteger | 1 | 0, 0, 0 | |
| exbldgovrd | OFTInteger | 1 | 0, 0, 0 | |
| utillandov | OFTInteger | 1 | 0, 0, 0 | |
| utilbldgov | OFTInteger | 1 | 0, 0, 0 | |
| aglandfina | OFTInteger | 747 | 0, 32000, 57900 | |
| agbldgfina | OFTInteger | 577 | 0, 0, 0 | |
| agtotalfin | OFTInteger | 950 | 0, 32000, 57900 | |
| reslandfin | OFTInteger | 224 | 0, 0, 0 | |
| resbldgfin | OFTInteger | 1.4k | 0, 0, 0 | |
| restotalfi | OFTInteger | 1.5k | 0, 0, 0 | |
| comlandfin | OFTInteger | 122 | 0, 0, 0 | |
| combldgfin | OFTInteger | 258 | 0, 0, 0 | |
| comtotalfi | OFTInteger | 289 | 0, 0, 0 | |
| exlandfina | OFTInteger | 23 | 0, 0, 0 | |
| exbldgfina | OFTInteger | 17 | 0, 0, 0 | |
| extotalfin | OFTInteger | 31 | 0, 0, 0 | |
| utillandfi | OFTInteger | 1 | 0, 0, 0 | |
| utilbldgfi | OFTInteger | 1 | 0, 0, 0 | |
| utiltotalf | OFTInteger | 1 | 0, 0, 0 | |
| agassd | OFTInteger | 225 | 0, 3800, 6900 | |
| resassd | OFTInteger | 454 | 0, 0, 0 | |
| comassd | OFTInteger | 223 | 0, 0, 0 | |
| totalassd | OFTInteger | 570 | 0, 3800, 6900 | |
| landmodel | OFTInteger | 5 | 0, 0, 0 | |
| code1 | OFTInteger | 7 | 3, 3, 3 | |
| code2 | OFTInteger | 6 | 0, 0, 0 | |
| code3 | OFTInteger | 8 | 4, 4, 4 | |
| code4 | OFTInteger | 8 | 2, 2, 2 | |
| code5 | OFTInteger | 2 | 1, 1, 1 | |
| code6 | OFTInteger | 2 | 2, 2, 2 | |
| code7 | OFTInteger | 1 | 0, 0, 0 | |
| code8 | OFTInteger | 1 | 0, 0, 0 | |
| croplandva | OFTInteger | 2 | 0, 0, 0 | |
| croplandas | OFTInteger | 2 | 0, 0, 0 | |
| addrchgdat | OFTString | — | ||
| addrchgcod | OFTString | — | ||
| reviewrequ | OFTInteger | 2 | 0, 0, 0 | |
| reviewnote | OFTString | 172 | GATE LOCKED, STILL HERE, 3 CAR GARAGE | |
| reviewer | OFTString | 3 | Cathy, Cathy, gladys | |
| exemptcode | OFTInteger | 13 | 5, 5, 1 | |
| lotsize | OFTString | 43 | 240 100, 420 X 100, 180 X 100 | |
| parceltype | OFTInteger | 3 | 0, 0, 0 | |
| ownerphone | OFTString | 445 | 816-529-7199, 636-669-8919, 417-425-7898 | |
| lotsizesca | OFTString | 6 | 106 X 197.7, 110 X 113, 109 X 196 | |
| retired | OFTInteger | 2 | 0, 0, 0 | |
| surveyedac | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| starea() | OFTReal | 10.9k | 19071.968018, 13924148.585938, 13980218.013672 | |
| stlength() | OFTReal | 10.8k | 782.608544, 15828.657707, 15871.098421 |
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.