50 attribute fields, profiled from the May 2024 vintage.
Columns in Gentry County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| PARCEL_ID | OFTString | 7.7k | 07-06-24-04, 08-09-30-26, 08-09-30-23 | |
| SITUS | OFTString | 4.3k | 2001 BUSINESS 136, 101 E BETHANY AVE, 102 E BETHANY AVE | |
| ADDR_NUMBE | OFTString | 1.4k | 2001, 101, 102 | |
| STREET_PRE | OFTString | 27 | BUSINESS, E, E | |
| STREET_NAM | OFTString | 883 | 136, BETHANY, BETHANY | |
| STREET_SUF | OFTString | 6 | N, S, S | |
| STREET_TYP | OFTString | 14 | Ave, Ave, Ave | |
| SITUS_CITY | OFTString | 13 | ALBANY, ALBANY, ALBANY | |
| SITUS_ZIP | OFTString | 13 | 64402, 64402, 64402 | |
| ADDR_SEC_U | OFTString | 13 | # 1), ACCESS FROM PARCEL 9, HWY169 | |
| OWNER | OFTString | 4.2k | JCIALMO001 LLC, NICHOLS JULIAN R & KAREN L, MAUDLIN GARY D | |
| TRANS_DATE | OFTDate | 3.3k | 2022-12-22, 2013-05-16, 2022-03-31 | |
| SALE_PRICE | OFTReal | 449 | 0.0, 0.0, 0.0 | |
| BLDG_SQFT | OFTInteger64 | 1.2k | 1393, 2005, 1344 | |
| LAND_USE_C | OFTString | 5 | Commercial, Residential, Residential | |
| LAND_US_01 | OFTString | 2 | Agricultural, Agricultural, Agricultural | |
| LAND_COVER | OFTString | 7.1k | {"21": 67, "22": 510}, {"21": 337, "22": 154}, {"21": 48, "22": 294} | |
| CROP_COVER | OFTString | 6.5k | {"121": 0.12, "122": 0.34}, {"121": 0.27, "122": 0.12}, {"121": 0.04, "122": 0.23} | |
| MUNI_ID | OFTInteger64 | 8 | 766664, 766664, 766664 | |
| SCHOOL_DIS | OFTInteger64 | 4 | 2902970, 2902970, 2902970 | |
| ACREAGE | OFTReal | 2.1k | 15.0, 0.456, 0.426 | |
| ACREAGE_AD | OFTReal | 5.1k | 14.6028063056264, 0.458896700128412, 0.395106710293129 | |
| ZIP_CODE | OFTString | 11 | 64402, 64402, 64402 | |
| STYLE | OFTString | 19 | 1 Story Frame, 1 Story Frame, 1 Story Frame | |
| YEAR_BUILT | OFTInteger64 | 147 | 1976, 1930, 1971 | |
| LEGAL_DESC | OFTString | 7.6k | 30-63-30 LOTS 3, 4 & 5 BLK 156 STAPLETONS 1ST ADD, 30-63-30 LOT 1 & 2 BLK 156 STAPLETONS 1ST ADD, 19-63-30 LOT 3 & W1/2 OF LOT 2 BLK 1 CASE & KENYON 1ST ADD | |
| PLSS_SECTI | OFTString | 36 | 24, 30, 30 | |
| PLSS_TOWNS | OFTString | 4 | 63N, 63N, 63N | |
| PLSS_RANGE | OFTString | 4 | 31W, 30W, 30W | |
| MAIL_ADDRE | OFTString | 828 | ATTN: ENTERPRISE PROPERTY GROUP & SECURI, REVOCABLE TRUST, WILLIAMS, LINDA M | |
| MAIL_AD_01 | OFTString | 3.5k | 5757 GREEN BAY AVE (X-80), 101 E BETHANY AVE, 203 E STAPLETON ST | |
| MAIL_AD_02 | OFTString | 1.3k | MILWAUKEE WI 53209-0000, ALBANY MO 64402-1706, ALBANY MO 64402-0000 | |
| MAIL_NAME | OFTString | 30 | C/O JOHNSON CONTROLS INC, BENEFICIARY DEED, DEASON, KIMZIE | |
| OWNER_OCCU | OFTString | 3 | F, T, F | |
| USPS_RESID | OFTString | 3 | ?, T, T | |
| CENSUS_TRA | OFTInteger64 | 2 | 960100, 960100, 960100 | |
| CENSUS_BLK | OFTInteger | 4 | 2, 3, 3 | |
| CENSUS_BLO | OFTInteger | 739 | 2010, 3090, 3088 | |
| AREA_METER | OFTReal | 7.7k | 59094.3559776067, 1857.05434878561, 1598.9102435884 | |
| FLD_ZONE | OFTString | 8 | {AE,AE}, {AE,AE}, {AE} | |
| ZONE_SUBTY | OFTString | 8 | {NULL,FLOODWAY}, {NULL,FLOODWAY}, {FLOODWAY} | |
| PLACE_GNIS | OFTInteger64 | 6 | 2393899, 2393899, 2393899 | |
| ALT_ID_1 | OFTString | 7.7k | 07062404, 08093026, 08093023 | |
| ELEVATION | OFTString | 7.7k | ||
| ROBUST_ID | OFTString | 7.7k | AABxkyZRHbagF0ox, AABxk2A4Ch3bH75o, AABxk9-TxLZUCywp | |
| CALC_ACREA | OFTReal | 7.7k | 14.6028063056264, 0.458896700128412, 0.395106710293129 | |
| COUNTY_NAM | OFTString | 1 | Gentry, Gentry, Gentry | |
| COUNTY_FIP | OFTInteger64 | 1 | 29075, 29075, 29075 | |
| STATE_ABBR | OFTString | 1 | MO, MO, MO | |
| CTY_ROW_ID | OFTInteger64 | 7.7k | 5445, 6395, 6183 |
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.