45 attribute fields, profiled from the February 2021 vintage.
Columns in Wake County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 292539, 335749, 335750 | |
| pin_num | OFTString | 50.0k | 0655578422, 0655462810, 0655465226 | |
| reid | OFTString | 50.0k | 0027170, 0445418, 0467958 | |
| map_name | OFTString | 990 | 0655 02, 0655 01, 0655 01 | |
| owner | OFTString | 50.0k | GUNTER, BARBARA P, LEIGH, WILLIAM T LEIGH, CATHERINE E, WEATHERS, JAMES G | |
| addr1 | OFTString | 50.0k | 410 GERANIUM CT, 401 KEITH WEATHERS RD, 305 KEITH WEATHERS RD | |
| addr2 | OFTString | 43.8k | FUQUAY VARINA NC 27526-2366, FUQUAY VARINA NC 27526-8199, FUQUAY VARINA NC 27526-8187 | |
| addr3 | OFTString | 2.1k | ANGIER NC 27501-0758, AGOURA HILLS CA 91301-2148, FUQUAY VARINA NC 27526-7755 | |
| deed_book | OFTString | 16.8k | 12-E, 016992, 000815 | |
| deed_page | OFTString | 5.2k | 3205, 00311, 00233 | |
| deed_acres | OFTReal | 3.3k | 24.65, 10.75, 0.19 | |
| bldg_val | OFTReal | 50.0k | 0.0, 477631.0, 0.0 | |
| land_val | OFTReal | 16.6k | 759022.0, 237240.0, 4180.0 | |
| total_valu | OFTReal | 50.0k | 759022.0, 714871.0, 4180.0 | |
| billing_cl | OFTString | 6 | Individual, Individual, Individual | |
| propdesc | OFTString | 50.0k | TR1 PROP OF GUNTER - TOREN BM1993 -722, LO1 RCMB FRANCES A WEATHERS HEIRS BM2016 -01646, WEATHERS JAMES G HARN ID 0035944 | |
| heatedarea | OFTReal | 8.9k | 3562.0, 2090.0, 2190.0 | |
| site_addre | OFTString | 50.0k | 0 S MAIN ST, 401 KEITH WEATHERS RD, 0 KEITH WEATHERS RD | |
| city_decod | OFTString | 11 | FUQUAY-VARINA, FUQUAY-VARINA, FUQUAY-VARINA | |
| township_d | OFTString | 28 | Middle Creek, Middle Creek, Middle Creek | |
| firedist | OFTString | 1 | 23, 23, 23 | |
| year_built | OFTInteger | 176 | 2019, 1950, 1953 | |
| totsalpric | OFTReal | 3.8k | 250000.0, 385000.0, 370000.0 | |
| sale_date | OFTString | 9.7k | 2014-10-15, 2020-09-25, 2020-11-06 | |
| type_use_d | OFTString | 105 | SINGLFAM, SINGLFAM, SINGLFAM | |
| design_sty | OFTString | 15 | Conventional, Conventional, Conventional | |
| land_class | OFTString | 23 | Forestry, Acres Greater Than 10 With House, Vacant | |
| exemptdesc | OFTString | 44 | CEMETERY, CEMETERY, BUILDERS INVENTORY | |
| exemptstat | OFTString | 44 | 782, 782, BLDR EXC | |
| ownership | OFTInteger | 17 | 1010, 1010, 1010 | |
| activity | OFTInteger | 37 | 9000, 1100, 9000 | |
| function | OFTInteger | 52 | 9900, 1100, 9900 | |
| structure | OFTInteger | 66 | 9000, 1110, 9000 | |
| site | OFTInteger | 14 | 3200, 6100, 1000 | |
| totstructs | OFTInteger | 38 | 1, 1, 1 | |
| totunits | OFTInteger | 297 | 0, 1, 0 | |
| old_parcel | OFTString | 50.0k | 875-00000-0030, 875-00000-0028, 875-00000-0034 | |
| parcel_pk | OFTInteger | 50.0k | 190020, 491563, 491564 | |
| billclass | OFTReal | 6 | 2.0, 2.0, 2.0 | |
| township | OFTString | 15 | 12, 12, 12 | |
| units | OFTReal | 297 | 0.0, 1.0, 0.0 | |
| taxable_st | OFTString | 1 | ACTIVE, ACTIVE, ACTIVE | |
| deed_date | OFTString | 12.4k | 06/24/2012, 12/11/2017, 11/01/1986 | |
| shape_leng | OFTReal | 50.0k | 5044.59001, 2893.389379, 539.758765 | |
| shape_area | OFTReal | 50.0k | 1078692.478295, 468310.399464, 8225.0985 |
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.