Aged
87 attribute fields, profiled from the January 2021 vintage.
Columns in McKenzie County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 18.1k | 10885, 10886, 10888 | |
| pid | OFTString | 17.0k | 520000900, 520000950, 520000970 | |
| acreage | OFTReal | 6.1k | 161.6, 159.54, 635.23 | |
| last_edite | OFTString | 41 | 2020-10-28, 2020-05-11, 2020-05-11 | |
| txprcl | OFTString | 16.9k | 52-00-00900, 52-00-00950, 52-00-00970 | |
| txyear | OFTInteger | 1 | 2020, 2020, 2020 | |
| txpnr | OFTInteger | 4.8k | 5097, 5097, 2677 | |
| txpnre | OFTString | 4.8k | JEFFERY GORRELL, JEFFERY GORRELL, USA | |
| txpadr1 | OFTString | 4.1k | 1680 HWY 16, 1680 HWY 16, 1680 HWY 16 | |
| txpadr2 | OFTString | 1.7k | BEACH ND 58621, BEACH ND 58621, BEACH ND 58621 | |
| txpadr3 | OFTString | 423 | SIDNEY MT 59270, SIDNEY MT 59270, SIDNEY MT 59270 | |
| txpadr4 | OFTString | 16 | A, M, M | |
| alnr | OFTInteger | 804 | 0, 0, 0 | |
| alnrev | OFTString | 798 | CODY SMITH, CODY SMITH, CODY SMITH | |
| aladr1 | OFTString | 767 | 710 VINQUIST RD, 710 VINQUIST RD, 710 VINQUIST RD | |
| aladr2 | OFTString | 353 | BEACH ND 58621-9244, BEACH ND 58621-9244, BEACH ND 58621-9244 | |
| aladr3 | OFTString | 75 | GRASSY BUTTE ND 58634, GRASSY BUTTE ND 58634, GRASSY BUTTE ND 58634 | |
| aladr4 | OFTString | 7 | SPRING TX 77387, ARNEGARD ND 58835, ARNEGARD ND 58835 | |
| svnr | OFTInteger | 209 | 0, 0, 0 | |
| svnrev | OFTString | 208 | TARA ANN SKAAR & PATTI J HUTCHINSON, TARA ANN SKAAR & PATTI J HUTCHINSON, TARA ANN SKAAR & PATTI J HUTCHINSON | |
| svadr1 | OFTString | 191 | & EUGENE C SMITH, & EUGENE C SMITH, & EUGENE C SMITH | |
| svadr2 | OFTString | 98 | 561 ROAD 101, 561 ROAD 101, 561 ROAD 101 | |
| svadr3 | OFTString | 29 | SIDNEY MT 59270, SIDNEY MT 59270, SIDNEY MT 59270 | |
| svadr4 | OFTString | 2 | ELEVA WI 54738, NEW TOWN ND 58763 | |
| tpfalc | OFTInteger | 5 | 0, 0, 0 | |
| tpsect | OFTInteger | 37 | 17, 17, 18 | |
| tptwp | OFTInteger | 11 | 145, 145, 145 | |
| tprang | OFTInteger | 14 | 104, 104, 104 | |
| tpblok | OFTInteger | 17 | 0, 0, 0 | |
| txplat | OFTString | 242 | WALKERS 1ST ADDITION IN 3RD COMM.DIST., WALKERS 1ST ADDITION IN 3RD COMM.DIST., WALKERS 1ST ADDITION IN 3RD COMM.DIST. | |
| txdsc1 | OFTString | 6.8k | SW1/4, SE1/4 EX 1.00 A RW, ALL | |
| txdsc2 | OFTString | 4.3k | 160.00 ACRES, 159.00 ACRES, 635.68 ACRES | |
| txdsc3 | OFTString | 807 | 83.09 ACRES, 75.46 ACRES, 118.33 ACRES | |
| txdsc4 | OFTString | 219 | 12894 - FARM EX MH (JEFF), 156.85 ACRES, RIVER BANK | |
| txdsc5 | OFTString | 356 | 2005 COMMANDER #10313OU 14 X 84, 2011 FRIENDSHIP 16X80 #MY1132533V, 112 ACRES | |
| txdsc6 | OFTString | 161 | 1997 MARSHFIELD 28X60 #91503, 1979 ARTCRAFT 14X70 #20342, #MY1233430ABV | |
| txdsc7 | OFTString | 67 | 2012 16X25 SERIAL#00018, SERIAL # M-0-38670-2, 1973 RIVERIA 14X70 VIN #3X1204703833 | |
| txdsc8 | OFTString | 1 | & TAMMI - 1/3 EACH) | |
| tpcity | OFTInteger | 74 | 52, 52, 52 | |
| tpschl | OFTInteger | 7 | 18, 18, 18 | |
| tpstd1 | OFTInteger | 9 | 1, 1, 1 | |
| tpstd2 | OFTInteger | 1 | 3, 3, 3 | |
| tpstd3 | OFTInteger | 4 | 0, 0, 0 | |
| tpstd4 | OFTInteger | 8 | 3, 3, 3 | |
| propad | OFTString | 6.7k | 351 HIGHWAY 16 S, 498 SMITH CREEK ROAD, 302 SKAAR RD S | |
| propzi | OFTString | 60 | 00000-9326, 00000-9326, 00000-9326 | |
| txdeed | OFTString | 2.8k | 160.00, 159.00, .00 | |
| tpclas | OFTInteger | 1 | 0, 0, 0 | |
| txasmd | OFTString | 29 | AGRICULTURAL, AGRICULTURAL, NATIONAL GRASSLANDS | |
| tpland | OFTInteger | 3.3k | 45600, 66400, 0 | |
| tpbldg | OFTInteger | 3.4k | 0, 0, 0 | |
| tpavgr | OFTInteger | 5.3k | 22800, 33200, 0 | |
| tpavtx | OFTInteger | 5.0k | 2280, 3320, 0 | |
| txtmr | OFTString | 35 | .054180, .054180, .000000 | |
| txtxst | OFTString | 2.3k | 2.28, 3.32, .00 | |
| txcnty | OFTString | 5.0k | 41.13, 59.89, .00 | |
| txtown | OFTString | 4.1k | .00, .00, .00 | |
| txskol | OFTString | 6.7k | 39.08, 56.90, .00 | |
| txwide | OFTString | 2.3k | 2.28, 3.32, .00 | |
| txtitx | OFTString | 1 | .00, .00, .00 | |
| txspc1 | OFTString | 3.5k | 11.40, 16.60, .00 | |
| txspc2 | OFTString | 3.3k | 4.56, 6.64, .00 | |
| txspc3 | OFTString | 3.0k | .00, .00, .00 | |
| txspc4 | OFTString | 2.5k | 22.80, 33.20, .00 | |
| txdue | OFTString | 1 | .00, .00, .00 | |
| txintr | OFTString | 1 | .00, .00, .00 | |
| txsapn | OFTString | 1 | .00, .00, .00 | |
| txsain | OFTString | 1 | .00, .00, .00 | |
| grosst | OFTString | 9.1k | 123.53, 179.87, .00 | |
| txtasm | OFTString | 431 | .00, .00, .00 | |
| taxdue | OFTString | 9.2k | 123.53, 179.87, .00 | |
| discav | OFTString | 3.4k | 6.17, 8.99, .00 | |
| netdue | OFTString | 9.9k | 117.36, 170.88, .00 | |
| taxaba | OFTString | 3 | .00, .00, .00 | |
| txsaab | OFTString | 2 | .00, .00, .00 | |
| adjnet | OFTString | 9.9k | 117.36, 170.88, .00 | |
| txtrc | OFTString | 5.7k | .00, .00, .00 | |
| txdisc | OFTString | 3.6k | .00, .00, .00 | |
| remdue | OFTString | 4.6k | 117.36, 170.88, .00 | |
| starea() | OFTReal | 18.1k | 1425350.3346, 1407176.743349, 5603492.821848 | |
| stlength() | OFTReal | 18.1k | 4775.56064, 4707.932077, 9469.834135 | |
| tplot4 | OFTString | 209 | 1, 2, 3 | |
| tsc_addr1 | OFTString | 4.3k | 1680 HWY 16 BEACH ND 58621, 1680 HWY 16 BEACH ND 58621, 1680 HWY 16 BEACH ND 58621 | |
| tsc_addr2 | OFTString | 782 | 710 VINQUIST RD BEACH ND 58621-9244, 710 VINQUIST RD BEACH ND 58621-9244, 710 VINQUIST RD BEACH ND 58621-9244 | |
| tsc_addr3 | OFTString | 195 | & EUGENE C SMITH 561 ROAD 101 SIDNEY MT 59270, & EUGENE C SMITH 561 ROAD 101 SIDNEY MT 59270, & EUGENE C SMITH 561 ROAD 101 SIDNEY MT 59270 | |
| tsc_legal | OFTString | 8.1k | SW1/4 160.00 ACRES, SE1/4 EX 1.00 A RW 159.00 ACRES, ALL 635.68 ACRES | |
| tsc_legalc | OFTString | 172 | 1997 MARSHFIELD 28X60 #91503, 1979 ARTCRAFT 14X70 #20342, #MY1233430ABV |
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.