52 attribute fields, profiled from the September 2021 vintage.
Columns in Bernalillo County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 18906, 23889, 123541 | |
| upc | OFTString | 50.0k | 200704326003040110, 200904445028010120, 200904353051010102 | |
| taxyr | OFTString | 1 | 2021, 2021, 2021 | |
| owner | OFTString | 50.0k | US INDIAN SERVICE & BUREAU OF INDIAN AFFAIRS, US INDIAN SERVICE & BUREAU OF INDIAN AFFAIRS, US INDIAN SERV BIA LAGUNA AGCY | |
| ownhsenum | OFTString | 9.9k | 1001, 1001, 1001 | |
| ownsubnum | OFTString | 33 | C, 1/2, A | |
| ownaddir | OFTString | 8 | E, W, E | |
| ownstr | OFTString | 12.1k | INDIAN SCHOOL, INDIAN SCHOOL, INDIAN SCHOOL | |
| ownstrtype | OFTString | 18 | RD, RD, RD | |
| owndirect | OFTString | 8 | NW, NW, NW | |
| ownbox | OFTString | 4.8k | PO BOX 1448, PO BOX 26567, PO BOX 2882 | |
| ownunit | OFTString | 10 | SUITE, SUITE, APT | |
| ownunitno | OFTString | 2.2k | A, 111, 29 | |
| owncity | OFTString | 2.2k | ALBUQUERQUE, ALBUQUERQUE, LAGUNA | |
| ownstate | OFTString | 61 | NM, NM, NM | |
| owncountry | OFTString | 31 | CANADA, IRELAND, IRELAND | |
| owncode | OFTString | 44 | T3B 6H4, V6G 3E2, V6G 3E2 | |
| ownzipcode | OFTString | 4.0k | 87104, 87104, 87026 | |
| ownzip4 | OFTString | 9.2k | 1448, 6567, 2303 | |
| ownadd | OFTString | 50.0k | 1001 INDIAN SCHOOL RD NW, 1001 INDIAN SCHOOL RD NW, PO BOX 1448 | |
| ownadd2 | OFTString | 45.2k | ALBUQUERQUE NM 87104, ALBUQUERQUE NM 87104, LAGUNA NM 87026-1448 | |
| situsnum | OFTString | 9.3k | 3701, 452, 395 | |
| situsstr | OFTString | 6.8k | BOSQUE PLAZA, LA JARA, LA JARA | |
| situsstrty | OFTString | 30 | RD, RD, RD | |
| situsdirec | OFTString | 7 | NW, SE, SE | |
| situscity | OFTString | 10 | ALBUQUERQUE, ALBUQUERQUE, ALBUQUERQUE | |
| situsstate | OFTString | 1 | NM, NM, NM | |
| situszip | OFTString | 27 | 87068, 87026, 87068 | |
| situszip2 | OFTString | 2.3k | 8624, 2101, 8641 | |
| situsadd | OFTString | 50.0k | 3701 BOSQUE PLAZA NW, 452 LA JARA RD, 395 LA JARA RD | |
| situsadd2 | OFTString | 3.0k | ALBUQUERQUE NM 87068, ALBUQUERQUE NM 87026, ALBUQUERQUE NM 87068 | |
| taxdist | OFTString | 11 | X1, X1, X1 | |
| legaldesc | OFTString | 50.0k | TR IN S 1/2 S 1/2 SEC 36 T8N R2W CONT 69.0 AC, T8N R2W SEC 27 110.20AC, TR IN NE 1/2 T8N R2W SEC 34 CONT 13.90 AC | |
| docnum | OFTString | 50.0k | 00081464 051900, 2020021414 030220 WD - EN, 2020021414 030220 WD - EN | |
| rolltype | OFTString | 1 | RP, RP, RP | |
| valclass | OFTString | 2 | NR, NR, NR | |
| propclass | OFTString | 3 | V, V, V | |
| landvalue | OFTReal | 21.5k | 579600.0, 661200.0, 150100.0 | |
| agvalue | OFTReal | 1.5k | 0.0, 0.0, 0.0 | |
| imptvalue | OFTReal | 45.2k | 0.0, 0.0, 0.0 | |
| totvalue | OFTReal | 50.0k | 579600.0, 661200.0, 150100.0 | |
| landtxble | OFTReal | 19.9k | 193181.0, 220378.0, 50028.0 | |
| impttxble | OFTReal | 40.5k | 0.0, 0.0, 0.0 | |
| tottxble | OFTReal | 50.0k | 193181.0, 220378.0, 50028.0 | |
| hohexemp | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| vetexemp | OFTReal | 53 | 0.0, 0.0, 0.0 | |
| otherexemp | OFTReal | 6.0k | 193181.0, 220378.0, 50028.0 | |
| totalexemp | OFTReal | 6.0k | 193181.0, 220378.0, 50028.0 | |
| nettaxable | OFTReal | 50.0k | 0.0, 0.0, 0.0 | |
| par_calcac | OFTReal | 15.6k | 69.0, 110.2, 13.9 | |
| shape_leng | OFTReal | 50.0k | 11785.035854, 17996.176053, 12763.683739 | |
| shape_area | OFTReal | 50.0k | 3307577.427073, 8714796.058417, 4994179.105288 |
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.