Aged
117 attribute fields, profiled from the November 2022 vintage.
Columns in Montgomery County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid_1 | OFTInteger | 50.0k | 89574, 89575, 89577 | |
| gislink | OFTString | 50.0k | 063156 00500, 063156 00501, 063156 00601 | |
| parcelid | OFTReal | 50.0k | 1711528.0, 1715481.0, 1686075.0 | |
| accountnum | OFTString | 50.0k | 69320, 69321, 405729 | |
| appraisali | OFTReal | 50.0k | 2001784.0, 2007151.0, 1967496.0 | |
| parcelno | OFTString | 50.0k | 156 00500 000, 156 00501 000, 156 00601 000 | |
| recordyear | OFTReal | 1 | 2023.0, 2023.0, 2023.0 | |
| totalcards | OFTReal | 43 | 1.0, 1.0, 1.0 | |
| owner1 | OFTString | 50.0k | HAMM GARY W, PENA TERRY J, HAMM GARY W | |
| owner2 | OFTString | 37.7k | HAMM LINDA M, PENA CARMEL J, HAMM LINDA M | |
| propertyad | OFTString | 50.0k | HODGES RD, 5975 HODGES RD, 5847 HODGES RD | |
| propertyci | OFTString | 15 | CUNNINGHAM, CUNNINGHAM, CUNNINGHAM | |
| mailingadd | OFTString | 50.0k | 5847 HODGES RD, 5975 HODGES RD, 5847 HODGES RD | |
| mailcity | OFTString | 1.5k | CUNNINGHAM, CUNNINGHAM, CUNNINGHAM | |
| mailstate | OFTString | 60 | TN, TN, TN | |
| mailzip | OFTString | 2.8k | 37052, 37052, 37052 | |
| subdivisio | OFTString | 2.1k | MCCURDY CROSSING, LIFE ESTATE, EARL DEANE HENDRICKSON PROPERTY | |
| lot1 | OFTString | 3.5k | T-6, 11, T1 | |
| block1 | OFTString | 306 | 2, 2, 1 | |
| lot2 | OFTString | 11 | PT9, P/O 6-7, PT19 | |
| block2 | OFTString | 3 | 2, 2, C | |
| deedbook | OFTString | 80 | L, G, K | |
| deedpage | OFTString | 1.4k | 11, 120, 24 | |
| zoning | OFTString | 39 | AG, AG, AG | |
| zoningpct | OFTString | 129 | 100, 100, 100 | |
| zoning2 | OFTString | 30 | C-2, C-5, C-1 | |
| zoningpct2 | OFTString | — | ||
| areaproxim | OFTString | 18 | TVA EASEMENT, TVA EASEMENT, TVA EASEMENT | |
| roadtypeco | OFTString | 9 | 3, 3, 3 | |
| roadtypede | OFTString | 9 | PAVED, PAVED, PAVED | |
| xcoordinat | OFTString | 50.0k | -87.46286188, -87.46511324, -87.45960353 | |
| ycoordinat | OFTString | 50.0k | 36.33362019, 36.33150329, 36.33066093 | |
| proptype | OFTString | 20 | AGRI, RS, AGRI | |
| assessment | OFTString | 20 | AGRI, RS, AGRI | |
| assessme_1 | OFTReal | 3 | 25.0, 25.0, 25.0 | |
| civildistr | OFTString | 27 | 20, 20, 20 | |
| taxingdist | OFTString | 2 | 000, 000, 000 | |
| taxingdi_1 | OFTString | 2 | MONTGOMERY, MONTGOMERY, MONTGOMERY | |
| landusedes | OFTString | 19 | AGRICULTURAL, RESIDENTIAL, AGRICULTURAL | |
| propertyty | OFTString | 19 | AGRICULTURAL, RESIDENTIAL, AGRICULTURAL | |
| neighborho | OFTString | 685 | P03, P03, P03 | |
| neighbor_1 | OFTString | 657 | TARSUS/SHILOH CANAAN/MARION RURAL AREA, TARSUS/SHILOH CANAAN/MARION RURAL AREA, TARSUS/SHILOH CANAAN/MARION RURAL AREA | |
| overrideva | OFTString | 1 | OVERRIDE, OVERRIDE, OVERRIDE | |
| agusestatu | OFTString | 2 | 1, 0, 1 | |
| vacantland | OFTString | 2 | Y, N, N | |
| deedacreag | OFTReal | 4.0k | 52.4, 10.73, 17.72 | |
| calcacreag | OFTReal | 4.0k | 50.25, 10.54, 17.49 | |
| agusevalue | OFTString | 2.6k | $50,591, $0, $41,966 | |
| mktlandval | OFTString | 4.4k | $164,100, $66,000, $97,400 | |
| buildingva | OFTString | 5.7k | $0, $229,100, $19,400 | |
| miscimprov | OFTString | 1.6k | $0, $2,900, $0 | |
| totalimpro | OFTString | 6.1k | $0, $232,000, $19,400 | |
| mktapprais | OFTString | 7.8k | $164,100, $298,000, $116,800 | |
| appraisedv | OFTString | 9.7k | $50,591, $298,000, $61,366 | |
| assessedva | OFTString | 11.3k | $12,648, $74,500, $15,342 | |
| dimensions | OFTString | — | ||
| dimensio_1 | OFTString | — | ||
| additional | OFTString | 11 | 26.03XIRR, OPEN SPCAE, NORTHERN PORTION OF LOT 8 | |
| addition_1 | OFTString | 1 | REPLAT | |
| bldgid | OFTReal | 50.0k | 0.0, 1775646.0, 1738847.0 | |
| bldgno | OFTString | 473 | 001, 001, 001 | |
| bldgcardno | OFTReal | 451 | 0.0, 1.0, 1.0 | |
| bldgtype | OFTString | 103 | RS5, RS1, RS1 | |
| bldgtypede | OFTString | 103 | SINGLE FAMILY 2 STORY, SINGLE FAMILY RANCH, SINGLE FAMILY RANCH | |
| yearbuilt | OFTReal | 188 | 0.0, 2001.0, 1943.0 | |
| effyearbui | OFTReal | 144 | 0.0, 2001.0, 1949.0 | |
| decade | OFTString | 9 | 2000s, 1940s, 2000s | |
| assmtclass | OFTString | 17 | RS, AGRI, AGFO | |
| bldgmktval | OFTReal | 5.7k | 0.0, 229100.0, 19400.0 | |
| bldgfinalv | OFTReal | 5.7k | 0.0, 229100.0, 19400.0 | |
| basearea | OFTReal | 4.7k | 0.0, 1348.0, 864.0 | |
| totaladjar | OFTReal | 6.6k | 0.0, 2883.0, 893.0 | |
| livingarea | OFTReal | 6.1k | 0.0, 2550.0, 864.0 | |
| unfinished | OFTReal | 4.1k | 0.0, 1473.0, 192.0 | |
| garagearea | OFTReal | 1.1k | 0.0, 0.0, 0.0 | |
| nostories | OFTReal | 10 | 0.0, 2.0, 1.0 | |
| nounits | OFTReal | 101 | 0.0, 1.0, 1.0 | |
| nofireplac | OFTReal | 13 | 0.0, 1.0, 0.0 | |
| extrafixtu | OFTReal | 269 | 0.0, 12.0, 3.0 | |
| bathtile | OFTString | 5 | FLOOR ONLY, FLOOR ONLY, FLOOR & 1/2 WALL | |
| cabmillwor | OFTString | 6 | ABOVE AVERAGE, ABOVE AVERAGE, BELOW AVERAGE | |
| electrical | OFTString | 5 | ABOVE AVERAGE, BELOW AVERAGE, ABOVE AVERAGE | |
| exteriorwa | OFTString | 21 | SIDING AVERAGE, SIDING AVERAGE, SIDING ABOVE AVERAGE | |
| floorfinis | OFTString | 15 | CARPET COMBINATION, PINE/SOFT WOOD, HARDWOOD-TERR-TILE | |
| floorsyste | OFTString | 8 | WOOD W/ SUB FLOOR, WOOD W/O SUB FLOOR, WOOD W/ SUB FLOOR | |
| foundation | OFTString | 5 | CONTINUOUS FOOTING, PIERS, CONTINUOUS FOOTING | |
| gradefacto | OFTString | 4 | ABOVE AVERAGE, BELOW AVERAGE, ABOVE AVERAGE | |
| heatair | OFTString | 12 | HEAT & COOLING SPLIT, HEAT & COOLING SPLIT, HEAT & COOLING SPLIT | |
| interiorfi | OFTString | 14 | DRYWALL, UNFINISHED, PANELING CUSTOM | |
| paintdecor | OFTString | 6 | ABOVE AVERAGE, ABOVE AVERAGE, BELOW AVERAGE | |
| partitionf | OFTString | — | ||
| roofcoverd | OFTString | 14 | COMPOSITION SHINGLE, CORRUGATED METAL, COMPOSITION SHINGLE | |
| roofframin | OFTString | 10 | GABLE/HIP, GABLE/HIP, GABLE/HIP | |
| sizefactor | OFTString | — | ||
| structural | OFTString | 6 | RIGID FRAME, RIGID FRAME, RIGID FRAME | |
| salesdate | OFTString | 12.0k | 1995-07-20, 2004-01-07, 1995-03-07 | |
| instrument | OFTString | 50.0k | V567-570, V943-2994, V556-2345 | |
| instrume_1 | OFTString | 38 | PYD, ACC, PYD | |
| grantor | OFTString | 36.1k | D D & F HOMES, HODGES KRISTY, THE ESTATE OF KATIE SMITH | |
| grantee | OFTString | 50.0k | HAMM GARY W ETUX LINDA M, PENA TERRY J ETUX CARMEL J, HAMM GARY W | |
| deedsalesp | OFTString | 6.9k | $40,000, $220,000, $35,000 | |
| salesprice | OFTString | 7.0k | $40,000, $220,000, $35,000 | |
| saletype | OFTString | 2 | VACANT, IMPROVED, IMPROVED | |
| reasoncode | OFTString | 4 | Q, Q, D | |
| starea() | OFTReal | 50.0k | 2188845.34265137, 458917.825317383, 762045.978759766 | |
| stlength() | OFTReal | 50.0k | 10225.6757311618, 4196.09835894432, 4444.82248620213 | |
| bldgimgid | OFTReal | 30.4k | 0.0, 0.0, 4789.0 | |
| imgpath | OFTString | 30.3k | ||
| bldgsketch | OFTReal | 50.0k | 0.0, 2775429.0, 2679490.0 | |
| sketchpath | OFTString | 50.0k | ||
| zoningdesc | OFTString | 27 | AGRICULTURAL PRODUCTION DISTRICT, AGRICULTURAL PRODUCTION DISTRICT, AGRICULTURAL PRODUCTION DISTRICT | |
| zoningde_1 | OFTString | 18 | GENERAL COMMERCIAL DISTRICT, HIGHWAY ARTERIAL COMMERCIAL DISTRICT, NEIGHBORHOOD COMMERCIAL DISTRICT | |
| norooms | OFTReal | 64 | 0.0, 0.0, 0.0 | |
| nobeds | OFTReal | 35 | 0.0, 0.0, 0.0 | |
| nobaths | OFTReal | 82 | 0.0, 0.0, 0.0 | |
| updatedate | OFTString | 1 | 2022-11-05, 2022-11-05, 2022-11-05 | |
| weburl | OFTString | 50.0k |
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.