78 attribute fields, profiled from the November 2023 vintage.
Columns in Jefferson County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 403491, 403492, 403493 | |
| unique_id | OFTInteger | 50.0k | 269731, 269731, 269731 | |
| pid | OFTString | 50.0k | 4300202000005000, 4300202000005000, 4300202000005000 | |
| tax_townsh | OFTString | 29 | 43, 43, 43 | |
| isp_sectio | OFTString | 39 | 20, 20, 20 | |
| sec | OFTString | 39 | 20, 20, 20 | |
| qsection | OFTString | 5 | 2, 2, 2 | |
| block | OFTString | 69 | 000, 000, 000 | |
| parcel | OFTString | 4.1k | 005000, 005000, 005000 | |
| parcelid | OFTString | 50.0k | 4300202000005000, 4300202000005000, 4300202000005000 | |
| app_pid | OFTString | 50.0k | 4300202000005502, 4300202000005505, 4300202000005506 | |
| district | OFTString | 36 | 50, 50, 50 | |
| esn_num | OFTInteger | 41 | 503, 503, 503 | |
| addr_pspr | OFTString | 50.0k | 7403 TINGLE SPRINGS CIR, 7403 TINGLE SPRINGS CIR, 7403 TINGLE SPRINGS CIR | |
| bldg_numbe | OFTInteger | 9.3k | 7403, 7403, 7403 | |
| street_nam | OFTString | 3.6k | TINGLE SPRINGS, TINGLE SPRINGS, TINGLE SPRINGS | |
| street_typ | OFTString | 50 | CIR, CIR, CIR | |
| street_dir | OFTString | 7 | SW, SW, SW | |
| apartment | OFTString | 1.8k | JOINT, JOINT2, S1 | |
| addrapt_ps | OFTString | 50.0k | 7403 TINGLE SPRINGS CIR, 7403 TINGLE SPRINGS CIR, 7403 TINGLE SPRINGS CIR | |
| ownername | OFTString | 50.0k | WALNUT LAKE LAND CO INC, SIMMONS PETER N & MELANIE R, WALNUT LAKE LAND COMPANY, INC. | |
| prop_mail | OFTString | 50.0k | 7344 TINGLE SPRINGS CIRCLE, 7344 TINGLE SPRINGS CIR, 626 SOMERSET BOULEVARD | |
| citymail | OFTString | 2.5k | MCCALLA, MCCALLA, BESSEMER | |
| zip_mail | OFTString | 28.9k | 35111, 35111-4045, 35020 | |
| state_mail | OFTString | 136 | AL, AL, AL | |
| legal_desc | OFTString | 50.0k | BLDG ON LEASED LD, BLDG ON LEASED LD, BLDG ON LEASED LD | |
| property_c | OFTString | 12 | MCCALLA, MCCALLA, MCCALLA | |
| property_s | OFTString | 1 | AL, AL, AL | |
| neighbor_n | OFTString | 459 | 17-055.0, 17-055.0, 17-055.0 | |
| subdiv_nam | OFTString | 11.4k | ARROW WOOD PHASE ONE, ARROW WOOD PHASE ONE, ARROW WOOD PHASE ONE | |
| addr_apr | OFTString | 50.0k | 7459 TINGLE SPRINGS CIR, 7409 TINGLE SPRINGS CIR, 7405 TINGLE SPRINGS CIR | |
| zip | OFTInteger | 35 | 35111, 35111, 35111 | |
| totalmhval | OFTReal | 700 | 0.0, 0.0, 0.0 | |
| prevparcel | OFTReal | 6.9k | 0.0, 0.0, 0.0 | |
| prevparc_1 | OFTReal | 11.4k | 13500.0, 11700.0, 5000.0 | |
| prevparc_2 | OFTReal | 15.1k | 13500.0, 11700.0, 5000.0 | |
| zoning_boe | OFTString | 986 | A1, A1, A1 | |
| water | OFTString | 10 | 2, 2, 2 | |
| sewer | OFTString | 10 | 4, 4, 4 | |
| gas | OFTString | 9 | 0, 0, 0 | |
| acres_apr | OFTReal | 1.7k | 0.0, 0.0, 0.0 | |
| gis_acres | OFTReal | 3.4k | 21.73, 21.73, 21.73 | |
| remarks | OFTString | 50.0k | DEMAND ASSESSMENT*CORP BOUGHT FROM CLAUDE'S SON*CLAUDE DEC'D, DOES NOT JOIN H/E 38-17-3-4-5, OWNER PER CORP SHARES. MOVED HERE JAN 2003 | |
| name2 | OFTString | 3.8k | C/O MICHAEL MCDONOUGH, C/O MICHAEL MCDONOUGH, C/O MICHAEL MCDONOUGH | |
| plat_book | OFTString | 459 | 1000, 1000, 1000 | |
| plat_book2 | OFTString | 28 | 0, 0, 0 | |
| plat_page | OFTString | 191 | 0, 0, 0 | |
| plat_page2 | OFTString | 30 | 0, 0, 0 | |
| nbhdcd | OFTString | 9 | 0, 0, 0 | |
| ownership | OFTString | 10 | 0, 0, 0 | |
| topography | OFTString | 10 | 4, 4, 4 | |
| roadacc | OFTString | 10 | 5, 5, 5 | |
| maintdate | OFTString | 1.0k | 9/9/2020, 9/10/2020, 9/9/2020 | |
| city | OFTString | 36 | COUNTY (BESS DIV)-50, COUNTY (BESS DIV)-50, COUNTY (BESS DIV)-50 | |
| nbhname | OFTString | 453 | POWDER PLANT RD, POWDER PLANT RD, POWDER PLANT RD | |
| primuncode | OFTString | 36 | 50, 50, 50 | |
| secmuncode | OFTString | 3 | 00, 00, 00 | |
| priacreage | OFTReal | 746 | 0.0, 0.0, 0.0 | |
| secacreage | OFTReal | 2 | 0.0, 0.0, 0.0 | |
| legalremar | OFTString | 50.0k | 21.3, 184.9 X 198.9 IRR, 523S X 486S IRR | |
| parcelno | OFTString | 50.0k | 43 00 20 2 000 005.502, 43 00 20 2 000 005.505, 43 00 20 2 000 005.506 | |
| division | OFTString | 2 | 2, 2, 2 | |
| recordyear | OFTInteger | 1 | 2024, 2024, 2024 | |
| schdist | OFTString | 1 | 2, 2, 2 | |
| mapnumber | OFTString | 8.3k | 43 00 20 2 000, 43 00 20 2 000, 43 00 20 2 000 | |
| sqft | OFTReal | 1.9k | 0.0, 0.0, 0.0 | |
| firedeptna | OFTString | 33 | McCalla, McCalla, McCalla | |
| cls | OFTString | 7 | R, R, R | |
| bldg_ind | OFTString | 2 | YES, YES, YES | |
| tax_code | OFTString | 13 | 0, 0, 0 | |
| oby_ind | OFTString | 2 | NO, NO, NO | |
| assdvalue | OFTReal | 11.1k | 2700.0, 2340.0, 1000.0 | |
| territory | OFTString | 18 | 10, 10, 10 | |
| firefee_di | OFTString | 10 | 09, 09, 09 | |
| starea() | OFTReal | 50.0k | 946438.894855893, 946438.894855893, 946438.894855893 | |
| stlength() | OFTReal | 50.0k | 4666.229612333, 4666.229612333, 4666.229612333 | |
| parcel_id | OFTString | 50.0k | 43 00 20 2 000 005.502, 43 00 20 2 000 005.505, 43 00 20 2 000 005.506 | |
| market_val | OFTString | 50.0k | 287,600, 216,500, 210,700 |
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.