Archive
263 attribute fields, profiled from the September 2023 vintage.
Columns in Dinwiddie County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 19.8k | 19483, 19488, 19489 | |
| address2 | OFTString | — | ||
| cama_link | OFTString | 17.6k | 99-1-10, 99-1-6, 99-1-7 | |
| cama_link_ | OFTString | 1.9k | 10, 6, 7 | |
| comments | OFTString | 38 | NEW, CORRECTED, NEW DAVID | |
| creationda | OFTString | 12 | 2023-04-25, 2023-04-25, 2023-04-25 | |
| creator | OFTString | 4 | SChristmas@dinwiddieva.us, SChristmas@dinwiddieva.us, SChristmas@dinwiddieva.us | |
| date_modif | OFTString | 81 | 2018-02-07, 2018-02-07, 2018-02-07 | |
| editdate | OFTString | 14 | 2023-05-18, 2023-05-18, 2023-05-18 | |
| editor | OFTString | 15 | NICOLE.MAUS, NICOLE.MAUS, NICOLE.MAUS | |
| editor_1 | OFTString | 1 | SChristmas@dinwiddieva.us, SChristmas@dinwiddieva.us, SChristmas@dinwiddieva.us | |
| globalid | OFTString | 19.8k | af4986fc-6a59-483f-94ea-006ca53cd330, 7673376f-bb31-42b6-9758-98e8ef912ff2, 1aa3831e-969c-40d7-ab14-39141133153b | |
| linked | OFTString | 3 | LINKED, LINKED, LINKED | |
| m_br | OFTInteger | 10 | 0, 0, 0 | |
| m_dunt | OFTInteger | 5 | 0, 0, 0 | |
| m_fbth | OFTInteger | 8 | 0, 0, 0 | |
| m_flue | OFTInteger | 1 | 0, 0, 0 | |
| m_hbth | OFTInteger | 10 | 0, 0, 0 | |
| m_room | OFTInteger | 28 | 0, 0, 0 | |
| m0depr | OFTString | 1 | Y, Y, Y | |
| m1adj | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| m1area | OFTReal | 48 | 0.0, 0.0, 0.0 | |
| m1dfac | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| m1dpth | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| m1frnt | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| m1rate | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| m1um | OFTString | 1 | S, S, S | |
| m2adj | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| m2area | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| m2dfac | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| m2dpth | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| m2frnt | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| m2rate | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| m2um | OFTString | 2 | S, S, Q | |
| mac | OFTString | 3 | N, N, N | |
| macct | OFTReal | 15.5k | 14145.0, 14141.0, 14142.0 | |
| macpct | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| macre | OFTString | 3.6k | 35.8, 20.7, 20.9 | |
| macre_ | OFTReal | 3.4k | 35.8, 20.7, 20.9 | |
| macsf | OFTReal | 12 | 0.0, 0.0, 0.0 | |
| madd1 | OFTString | 11.2k | 2557 CHAPTICO ROAD, 2557 CHAPTICO RD, 2435 CHAPTICO RD | |
| madd2 | OFTString | 32 | SUITE 525, 270 MOHEGAN AVE, BEIRUT | |
| mage | OFTReal | 165 | 0.0, 0.0, 0.0 | |
| map | OFTString | 94 | 99, 99, 99 | |
| map_block | OFTString | 55 | A, A, B | |
| map_block_ | OFTString | 236 | 93-A, 93-A, 93-B | |
| map_dblc_1 | OFTString | 848 | 99-1, 99-1, 99-1 | |
| map_dblcir | OFTString | 26 | 1, 1, 1 | |
| map_lot | OFTString | 2.3k | 10, 6, 7 | |
| map_pin | OFTString | 19.8k | 99-1-10, 99-1-6, 99-1-7 | |
| map_taxmap | OFTString | 249 | 99, 99, 99 | |
| mascom | OFTString | 378 | MAPPED WRONG, 11112 IS ALSO ON PARCEL, LEASED 8X8 MINI BARN ON PROP | |
| massb | OFTReal | 2.7k | 0.0, 0.0, 0.0 | |
| massl | OFTReal | 2.4k | 88400.0, 58200.0, 58600.0 | |
| masslu | OFTReal | 2.4k | 42971.0, 32461.0, 32600.0 | |
| massm | OFTReal | 35 | 0.0, 0.0, 0.0 | |
| mathom | OFTString | 2 | N, N, N | |
| mbasa | OFTReal | 1.8k | 0.0, 0.0, 0.0 | |
| mbastp | OFTReal | 6 | 0.0, 0.0, 0.0 | |
| mbi_c | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| mbrate | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mcada | OFTReal | 32 | 18.0, 22.0, 14.0 | |
| mcalc | OFTString | 1 | Y, Y, Y | |
| mcamo | OFTReal | 13 | 2.0, 9.0, 11.0 | |
| mcar_c | OFTInteger | 4 | 0, 0, 0 | |
| mcarpt | OFTReal | 5 | 0.0, 0.0, 0.0 | |
| mcayr | OFTReal | 23 | 2009.0, 2016.0, 2008.0 | |
| mcdda | OFTReal | 32 | 1.0, 1.0, 1.0 | |
| mcdmo | OFTReal | 13 | 3.0, 3.0, 3.0 | |
| mcdr | OFTString | — | ||
| mcdrdt | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mcdyr | OFTReal | 19 | 2022.0, 2022.0, 2022.0 | |
| mchar | OFTReal | 10 | 61.0, 61.0, 61.0 | |
| mcity | OFTString | 556 | SOUTH HILL, SOUTH HILL, SOUTH HILL | |
| mclass | OFTString | 6 | C, C, C | |
| mcnst1 | OFTString | — | ||
| mcnst2 | OFTString | — | ||
| mcomm1 | OFTString | 1.1k | SPLIT BY PLAT, SPLIT BY PLAT PB17 PG171, ACREAGE ADJUSTED BY PLAT | |
| mcomm2 | OFTString | 438 | DB 554 PG 170, PB17 PG164, PB 17 PG 139 | |
| mcomm3 | OFTString | 87 | DOUBLEWIDE ADDED 2003, DOUBLEWIDE ADDED 2003, MIN VALUE REMOVED | |
| mcond | OFTString | 5 | A, F, F | |
| mcvda | OFTReal | 32 | 1.0, 1.0, 1.0 | |
| mcvexp | OFTString | 150 | REVALUED-GENERAL REASS., REVALUED-GENERAL REASS., REVALUED-GENERAL REASS. | |
| mcvmo | OFTReal | 13 | 1.0, 1.0, 1.0 | |
| mcvyr | OFTReal | 9 | 2019.0, 2019.0, 2019.0 | |
| mdasld | OFTReal | 32 | 12.0, 21.0, 21.0 | |
| mdatlg | OFTReal | 23 | 0.0, 0.0, 0.0 | |
| mdatpr | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mdbook | OFTString | 626 | 318, 318, 318 | |
| mdcode | OFTString | 7 | D, D, D | |
| mdelay | OFTString | 1 | Y, Y, Y | |
| mdeprc | OFTReal | 92 | 0.0, 0.0, 0.0 | |
| mdesc1 | OFTString | 7.1k | NOTTOWAY RIVER FARMS, NOTTOWAY RIVER FARMS, NOTTOWAY RIVER FARMS | |
| mdesc2 | OFTString | 4.3k | LOT 10, LOT 6, LOT 7 | |
| mdesc3 | OFTString | 3.2k | DB291/140, DB272/307, DB-177/272 | |
| mdesc4 | OFTString | 17.0k | 99-(1)-10, 99-(1)-6, 99-(1)-7 | |
| mdirct | OFTString | 2 | W, W, N | |
| mdpage | OFTReal | 460 | 0.0, 360.0, 366.0 | |
| mdsufx | OFTString | 3 | 6, 1, 3 | |
| mdwell | OFTReal | 3 | 1.0, 1.0, 1.0 | |
| meacre | OFTReal | 625 | 0.0, 0.0, 0.0 | |
| mease | OFTReal | 6 | 22.0, 22.0, 22.0 | |
| mecond | OFTReal | 8 | 0.0, 0.0, 0.0 | |
| meffag | OFTReal | 14 | 0.0, 0.0, 0.0 | |
| mekit | OFTReal | 5 | 0.0, 0.0, 0.0 | |
| melec | OFTString | 2 | N, N, N | |
| metxyr | OFTReal | 8 | 2019.0, 2019.0, 2019.0 | |
| mexwl2 | OFTReal | 22 | 0.0, 0.0, 0.0 | |
| mexwll | OFTReal | 30 | 0.0, 0.0, 0.0 | |
| mfactr | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| mfairv | OFTReal | 40 | 0.0, 0.0, 0.0 | |
| mfill4 | OFTString | — | ||
| mfill7 | OFTString | 1 | X, X, X | |
| mfill9 | OFTString | — | ||
| mfloor | OFTString | 96 | 2122, 20, 20 | |
| mflutp | OFTString | — | ||
| mfnam | OFTString | 1.6k | LINDA JEANETTE, LINDA JEANETTE, WOODRUFF WILSON DUANE | |
| mfound | OFTReal | 19 | 0.0, 0.0, 0.0 | |
| mfp_ | OFTReal | 7 | 0.0, 0.0, 0.0 | |
| mfp1 | OFTString | — | ||
| mfp2 | OFTString | — | ||
| mfuel | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| mfuncd | OFTReal | 12 | 0.0, 0.0, 0.0 | |
| mgar_2 | OFTInteger | 4 | 0, 0, 0 | |
| mgar_c | OFTInteger | 5 | 0, 0, 0 | |
| mgart | OFTReal | 9 | 0.0, 0.0, 0.0 | |
| mgart2 | OFTInteger | 3 | 0, 0, 0 | |
| mgas | OFTString | 2 | N, N, N | |
| mgispn | OFTString | — | ||
| mgrntr | OFTString | 8.5k | POWERS KIMBERLY L, BEALE KENNETH C & TASHA M & MARTIN, GRIFFIN LAND & TIMBER PRODUCTS LTD | |
| mheat | OFTReal | 20 | 0.0, 0.0, 0.0 | |
| mhidnm | OFTString | 2 | N, N, N | |
| mhidpc | OFTString | 2 | N, N, N | |
| mhrdat | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mhrnam | OFTString | — | ||
| mhrph_ | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mhrses | OFTString | — | ||
| mhrtim | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mhse_ | OFTInteger | 6.5k | 0, 0, 0 | |
| mhse_2 | OFTString | 29 | 22326, 22326, 4013 | |
| mimadj | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mimprv | OFTReal | 2.9k | 0.0, 0.0, 0.0 | |
| minit | OFTString | 35 | JD/MW, JD/MW, JD/MW | |
| minno_ | OFTReal | 1.7k | 405.0, 0.0, 0.0 | |
| minno2 | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| minspd | OFTReal | 347 | 4102018.0, 4102018.0, 4102018.0 | |
| mintyp | OFTString | 9 | D, DB, DB | |
| mintyr | OFTReal | 54 | 2009.0, 0.0, 0.0 | |
| minwll | OFTString | 34 | 10, 12, 12 | |
| miofp_ | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| mlgbk_ | OFTString | 39 | 25, 109, 109 | |
| mlgbkc | OFTString | 2 | W, D, D | |
| mlgity | OFTString | 4 | 94, DB, DB | |
| mlgiyr | OFTReal | 12 | 0.0, 0.0, 0.0 | |
| mlgno_ | OFTReal | 11 | 0.0, 0.0, 0.0 | |
| mlgno2 | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mlgpg_ | OFTReal | 40 | 0.0, 0.0, 0.0 | |
| mlnam | OFTString | 12.6k | POWERS DAVID C, POWERS GRAHAM H JR, POWERS GRAHAM H III & | |
| mltrcd | OFTString | 2 | N, C, C | |
| mluse | OFTString | 15 | 5, 5, 5 | |
| mmagcd | OFTString | 6 | 04, 04, 04 | |
| mmcode | OFTReal | 31 | 0.0, 2.0, 2.0 | |
| mmfl_ | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| mmnnud | OFTReal | 30 | 0.0, 0.0, 0.0 | |
| mmnud | OFTReal | 7 | 0.0, 0.0, 0.0 | |
| mmortc | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| mmosld | OFTReal | 13 | 2.0, 8.0, 8.0 | |
| mnbadj | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| mnbrhd | OFTReal | 5 | 1.0, 1.0, 1.0 | |
| moccup | OFTReal | 15 | 15.0, 15.0, 15.0 | |
| moldoc | OFTReal | 18 | 0.0, 0.0, 0.0 | |
| motdes | OFTString | 299 | WL=C/O YOUNG TIMBER, WL=C/O YOUNG TIMBER, WL=C/O YOUNG TIMBER | |
| mpbfin | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mpbook | OFTString | 689 | 17, 17, 17 | |
| mpbtot | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| mpcode | OFTString | 5 | P, P, P | |
| mpcomp | OFTReal | 8 | 0.0, 0.0, 0.0 | |
| mperr | OFTString | — | ||
| mpict | OFTString | — | ||
| mppage | OFTReal | 1.3k | 0.0, 0.0, 0.0 | |
| mprcit | OFTString | 35 | MCKENNEY, MCKENNEY, MCKENNEY | |
| mprout | OFTString | — | ||
| mprsta | OFTString | 5 | VA, VA, VA | |
| mprzip1 | OFTString | 19 | 0, 0, 0 | |
| mprzp4 | OFTString | 1 | 9735 | |
| mpsf | OFTReal | 2.4k | 0.0, 0.0, 0.0 | |
| mpsufx | OFTString | 8 | 1, A, 1 | |
| mpuse | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mqafil | OFTString | — | ||
| mqapch | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mrecid | OFTString | 1 | M, M, M | |
| mrem1 | OFTString | 4.3k | RIVER FRONT LOT, RIVER FRONT LOT, RIVER FRONT LOT | |
| mrem2 | OFTString | 1.5k | S BY DIRT ROW RIVER FRONT SITE, OLD DWLG VERY POOR VACANT-STRG, 20.74 MINERALS UNDEV 45ACLESS20.74 | |
| mroofg | OFTReal | 16 | 0.0, 0.0, 0.0 | |
| mrooft | OFTReal | 8 | 0.0, 0.0, 0.0 | |
| mrow | OFTReal | 5 | 11.0, 11.0, 11.0 | |
| msbfin | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| msbtot | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| msdirs | OFTString | 1 | S | |
| msellp | OFTReal | 1.3k | 0.0, 29950.0, 29950.0 | |
| msewer | OFTReal | 6 | 42.0, 42.0, 42.0 | |
| msfl_ | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| msfp_ | OFTReal | 5 | 0.0, 0.0, 0.0 | |
| msfx | OFTString | 16 | A, A, A | |
| mstate | OFTString | 45 | VA, VA, VA | |
| mstor_ | OFTReal | 67 | 0.0, 0.0, 0.0 | |
| mstory | OFTString | 2 | S/F, S/F, S/L | |
| mstrt | OFTString | 569 | CHERRY HILL, RIDGE, RIDGE | |
| msttyp | OFTString | 16 | RD, RD, RD | |
| msubdv | OFTString | — | ||
| mswl | OFTReal | 6 | 0.0, 0.0, 0.0 | |
| mtac | OFTReal | 2.3k | 0.0, 0.0, 0.0 | |
| mtbas | OFTReal | 5 | 0.0, 0.0, 0.0 | |
| mtbi | OFTReal | 4 | 0.0, 0.0, 0.0 | |
| mtbimp | OFTReal | 7 | 0.0, 0.0, 0.0 | |
| mtbv | OFTReal | 4.2k | 0.0, 0.0, 0.0 | |
| mterrn | OFTReal | 4 | 50.0, 50.0, 50.0 | |
| mtfbas | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| mtfl | OFTReal | 8 | 0.0, 0.0, 0.0 | |
| mtfp | OFTReal | 23 | 0.0, 0.0, 0.0 | |
| mtheat | OFTReal | 267 | 0.0, 0.0, 0.0 | |
| mtime | OFTReal | 13.0k | 155834.0, 145846.0, 155800.0 | |
| mtota | OFTReal | 2.7k | 0.0, 0.0, 0.0 | |
| mtotbv | OFTReal | 9.9k | 0.0, 0.0, 0.0 | |
| mtotld | OFTReal | 2.4k | 88400.0, 58200.0, 58600.0 | |
| mtotoi | OFTReal | 3.9k | 0.0, 0.0, 0.0 | |
| mtotpr | OFTReal | 4.0k | 88400.0, 58200.0, 58600.0 | |
| mtplum | OFTReal | 21 | 0.0, 0.0, 0.0 | |
| mtsubt | OFTReal | 9.6k | 0.0, 0.0, 0.0 | |
| mttadd | OFTReal | 5.5k | 0.0, 0.0, 0.0 | |
| mtutil | OFTReal | 1 | 0.0, 0.0, 0.0 | |
| muser1 | OFTString | 11 | F, F, A | |
| muser2 | OFTString | 10 | F, F, A | |
| muser3 | OFTString | 7 | M, A, F | |
| muser4 | OFTString | 6 | M, A, M | |
| musrid | OFTString | 17 | WAMPLER, LORI, WAMPLER | |
| mwater | OFTReal | 9 | 34.0, 34.0, 34.0 | |
| mwbook | OFTString | 37 | 2016, 2016, 2015 | |
| mwcode | OFTString | 3 | W, W, W | |
| mwpage | OFTReal | 225 | 0.0, 0.0, 0.0 | |
| mwsufx | OFTString | — | ||
| myrblt | OFTReal | 173 | 0.0, 0.0, 0.0 | |
| myrsld | OFTReal | 58 | 2009.0, 1992.0, 1992.0 | |
| mzip4 | OFTString | 298 | 0570, 0570, 0570 | |
| mzip5 | OFTString | 644 | 23970, 23970, 23970 | |
| mzone | OFTString | 18 | A2, A2, A2 | |
| objectid_1 | OFTInteger | 1 | 0, 0, 0 | |
| parcel_id | OFTString | 19.8k | 99-1-10, 99-1-6, 99-1-7 | |
| pin_owner | OFTString | — | ||
| recno | OFTString | 17.1k | 14145, 14141, 14142 | |
| shape_leng | OFTReal | 19.7k | 6377.44388165, 5059.77850227, 5006.46794273 | |
| sheettype | OFTString | 2 | Section, Section, Section | |
| updated | OFTString | 20 | ORG 3rd Quarter 2006, ORG 3rd Quarter 2006, ORG 3rd Quarter 2006 | |
| updated_by | OFTString | 6 | WVS, WVS, WVS | |
| visionpid | OFTString | 15.2k | 7228, 10715, 10715 | |
| x | OFTReal | 19.7k | -77.65730919, -77.66557753, -77.66441869 | |
| y | OFTReal | 19.7k | 36.89766281, 36.89876852, 36.89740351 | |
| year_updat | OFTString | 17 | 2013, 2013, 2013 | |
| zoning | OFTString | 18 | A-2, A-2, A-2 | |
| shape__are | OFTReal | 18.7k | 245385.80078125, 136787.875, 132935.859375 | |
| shape__len | OFTReal | 19.8k | 2430.84782725673, 1930.74734755138, 1911.55316266801 | |
| parceladdr | OFTString | 11.9k | 0, 0, 0 | |
| fullparcel | OFTString | 9.7k | 0, 0, 27630 RIDGE RD MCKENNEY, VA 23872 |
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.