50 attribute fields, profiled from the September 2022 vintage.
Columns in Dane County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 6972, 6997, 6998 | |
| parcelno | OFTString | 50.0k | 050911223131, 050911223501, 050911223531 | |
| currentpar | OFTString | 2 | Active, Active, Active | |
| owner | OFTString | 50.0k | FRED-BERGAMONT APARTMENTS LLC, NEUENSCHWANDER REV TR, TUCKER LIVING TR, DOUGLAS A & BEVERLY M | |
| coowner | OFTString | 41.5k | KAMI LEASE, ROBERTA B RUSCH, MELISS M ZERNICK | |
| conctowner | OFTString | 50.0k | FRED-BERGAMONT APARTMENTS LLC, NEUENSCHWANDER REV TR, TUCKER LIVING TR, DOUGLAS A & BEVERLY M | |
| attention | OFTString | 1.2k | % FORWARD MANAGEMENT INC, % RALPH KIEFFER, % JOHN THOMPSON | |
| propertyad | OFTString | 50.0k | 207 BERGAMONT BLVD, 256 EAGLE DR, 258 EAGLE DR | |
| primaryadd | OFTString | 2 | Yes, Yes, Yes | |
| propertyst | OFTString | 9.3k | 207, 256, 258 | |
| propertynu | OFTString | 4 | 1/2, 1/2, 1/2 | |
| propertypr | OFTString | 4 | S, S, S | |
| property_1 | OFTString | 3.6k | BERGAMONT, EAGLE, EAGLE | |
| property_2 | OFTString | 35 | BLVD, DR, DR | |
| propertysu | OFTString | 5 | S, S, S | |
| propertyun | OFTString | 6 | APT, UNIT, UNIT | |
| property_3 | OFTString | 3.7k | 2, 3, 4 | |
| propertyzi | OFTString | 45 | 53575, 53575, 53575 | |
| property_4 | OFTString | 3 | 1520, 2133, 9406 | |
| property_5 | OFTString | 28 | Oregon, Oregon, Oregon | |
| billingstr | OFTString | 50.0k | STE 200 789 N WATER ST, 256 EAGLE DR, 258 EAGLE DR | |
| billingcty | OFTString | 9.1k | MILWAUKEE WI 53202, OREGON WI 53575, OREGON WI 53575 | |
| billingcit | OFTString | 1.4k | MILWAUKEE, OREGON, OREGON | |
| billingsta | OFTString | 60 | WI, WI, WI | |
| billingzip | OFTString | 1.8k | 53202, 53575, 53575 | |
| municipali | OFTString | 36 | Village of Oregon, Village of Oregon, Village of Oregon | |
| municipa_1 | OFTString | 36 | 165, 165, 165 | |
| municipa_2 | OFTString | 36 | 60200, 60200, 60200 | |
| municipa_3 | OFTString | 37 | Oregon, Village of, Oregon, Village of, Oregon, Village of | |
| township | OFTString | 3 | 05, 05, 05 | |
| townshipdi | OFTString | 1 | N, N, N | |
| range | OFTString | 7 | 09, 09, 09 | |
| rangedirec | OFTString | 1 | E, E, E | |
| section | OFTString | 36 | 11, 11, 11 | |
| quarter160 | OFTString | 4 | NW, NW, NW | |
| block | OFTString | 94 | 4, 4, 4 | |
| lot | OFTString | 2.9k | 2, 2, 3 | |
| lottype | OFTString | 3 | LOT, UNIT, UNIT | |
| platcode | OFTString | 6.6k | 13776, 715827, 715827 | |
| platdescri | OFTString | 6.6k | CSM 13776, BERGAMONT SENIOR TOWNHOMES CONDO, BERGAMONT SENIOR TOWNHOMES CONDO | |
| sdstatecod | OFTString | 14 | 4144, 4144, 4144 | |
| schooldist | OFTString | 14 | OREGON SCHOOL DIST, OREGON SCHOOL DIST, OREGON SCHOOL DIST | |
| ddstatecod | OFTString | 10 | DD32, DD32, DD32 | |
| drainagedi | OFTString | 10 | DRAINAGE DISTRICT 32, DRAINAGE DISTRICT 32, DRAINAGE DISTRICT 32 | |
| legaldescr | OFTString | 50.0k | BERGAMONT SENIOR TOWNHOMES CONDOMINIUM UNIT 2, BERGAMONT SENIOR TOWNHOMES CONDOMINIUM UNIT 3, THE BERGAMONT LOT 33 | |
| assessed_a | OFTReal | 7.1k | 4.75, 0.0, 0.0 | |
| sum_landva | OFTReal | 5.3k | 247400.0, 32500.0, 32500.0 | |
| sum_improv | OFTReal | 9.7k | 4860600.0, 359100.0, 359100.0 | |
| shape_leng | OFTReal | 50.0k | 2106.123138, 1632.94544, 1632.94544 | |
| shape_area | OFTReal | 50.0k | 206594.723988, 142100.589872, 142100.589872 |
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.