44 attribute fields, profiled from the December 2022 vintage.
Columns in Johnson County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| PARCEL_ID | OFTString | 12.4k | 08-32-101-000, 07-33-206-000, 07-33-312-000 | |
| SITUS | OFTString | 5.9k | 801 E DIVISION, 200 E MILL ST, 3225 MT OLIVE RD | |
| ADDR_NUMBE | OFTString | 2.2k | 801, 200, 3225 | |
| STREET_PRE | OFTString | 42 | E, E, MT | |
| STREET_NAM | OFTString | 2.1k | DIVISION, MILL, OLIVE | |
| STREET_SUF | OFTString | 8 | S, S, S | |
| STREET_TYP | OFTString | 48 | St, Rd, St | |
| SITUS_CITY | OFTString | 12 | BELKNAP, BELKNAP, BELKNAP | |
| SITUS_ZIP | OFTString | 12 | 62908, 62908, 62908 | |
| ADDR_SEC_U | OFTString | 46 | # 2 BOX 35A, SUITE 36, SUITE 19 | |
| OWNER | OFTString | 7.1k | RICHEY STEVEN L, ALLEN WILLIAM F, EDDLEMAN DANA | |
| LAND_USE_C | OFTString | 11 | 0030, 0029, 0040 | |
| LAND_US_01 | OFTString | 2 | Residential, Residential, Residential | |
| LAND_COVER | OFTString | 11.8k | {"21": 1, "41": 404, "81": 228}, {"41": 519, "81": 241, "82": 20}, {"21": 104, "81": 352, "82": 142} | |
| CROP_COVER | OFTString | 10.4k | {"141": 0.67, "176": 0.39}, {"5": 0.2, "176": 0.8}, {"121": 0.37, "141": 31.77, "143": 0.42, "190": 50.44} | |
| MUNI_ID | OFTInteger64 | 17 | 1928444, 1928444, 1928444 | |
| SCHOOL_DIS | OFTInteger64 | 8 | 1700015, 1739630, 1739630 | |
| ACREAGE | OFTReal | 572 | 1.06, 0.0, 1.0 | |
| ACREAGE_AD | OFTReal | 8.2k | 1.06543636954066, 40.1892969687439, 1.00297095904328 | |
| ZIP_CODE | OFTString | 10 | 62908, 62923, 62923 | |
| BUILDINGS | OFTInteger64 | 16 | 0, 0, 1 | |
| LEGAL_DESC | OFTString | 12.2k | SE NE QTR (40A) WD 5/90 230/241 $15600, PT S PT SE SW QTR (1A) WD 6/2017 894/312 $29,000, W 1/2 NW QTR (80 A.) WD 7/94 185/375 $400000 (8P) | |
| PLSS_SECTI | OFTString | 36 | 32, 33, 33 | |
| PLSS_TOWNS | OFTString | 5 | 13S, 13S, 13S | |
| PLSS_RANGE | OFTString | 3 | 3E, 2E, 2E | |
| MAIL_ADDRE | OFTString | 6.6k | 801 EAST DIVISION, 200 EAST MILL ST, EDDLEMAN JAMA | |
| MAIL_AD_01 | OFTString | 1.7k | 3225 MT OLIVE RD, 524 SOUTH 2ND ST, 2645 STATE RT 147 | |
| MAIL_AD_02 | OFTString | 1.3k | DE MOTTE IN 463100000, RED BUD IL 622780000, DONGOLA IL 629260000 | |
| MAIL_NAME | OFTString | 7.1k | RICHEY STEVEN L, ALLEN WILLIAM F, EDDLEMAN DANA | |
| OWNER_OCCU | OFTString | 3 | T, T, F | |
| USPS_RESID | OFTString | 3 | ?, ?, ? | |
| COOWNER | OFTString | 142 | MARION G RUSHING DEC OF TRUST #100, BETTS EVIN, MYERS HALEY AUTUMN | |
| CENSUS_TRA | OFTInteger64 | 4 | 977800, 977800, 977800 | |
| CENSUS_BLK | OFTInteger | 5 | 3, 2, 2 | |
| CENSUS_BLO | OFTInteger | 586 | 3231, 2073, 2074 | |
| AREA_METER | OFTReal | 12.6k | 4311.58742884005, 162637.274771332, 4058.80360585681 | |
| PLACE_GNIS | OFTInteger64 | 9 | 2398072, 2398072, 2398072 | |
| ELEVATION | OFTString | 12.6k | ||
| ROBUST_ID | OFTString | 12.6k | AABCv8w0obdP86Ui, AABCv0cpSQvnfD8Y, AABCv6juLaAy3t1T | |
| CALC_ACREA | OFTReal | 12.6k | 1.06543636954066, 40.1892969687439, 1.00297095904328 | |
| COUNTY_NAM | OFTString | 1 | Johnson, Johnson, Johnson | |
| COUNTY_FIP | OFTInteger64 | 1 | 17087, 17087, 17087 | |
| STATE_ABBR | OFTString | 1 | IL, IL, IL | |
| CTY_ROW_ID | OFTInteger64 | 12.6k | 2774, 1538, 1511 |
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.