154 attribute fields, profiled from the June 2022 vintage.
Columns in Montgomery County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 21765, 22809, 62116 | |
| taxpinno | OFTString | 50.0k | D14 00910 0001, D14 00910 0013, D14 00910 0011 | |
| acad_color | OFTReal | 2 | 7.0, 7.0, 7.0 | |
| taxdistric | OFTString | 67 | D14, D14, D14 | |
| taxbook | OFTString | 256 | 009, 009, 009 | |
| taxpage | OFTString | 67 | 10, 10, 10 | |
| taxsuf | OFTString | 6 | W, A, W | |
| taxindex | OFTString | 512 | 0001, 0013, 0011 | |
| sourcedoc | OFTString | 6.9k | t3r4300d.tif, t3r4300d.tif, t3r4300d.tif | |
| taxarea | OFTString | 25 | DA, DA, DA | |
| lotnumber | OFTString | 50.0k | 317, 294, 248 | |
| acreage | OFTString | 12.6k | 53.750, 5.003, 14.000 | |
| cogosurvey | OFTString | 6 | N, N, N | |
| survey | OFTString | 4.6k | SUR-2003-308, 64-54.tif, SUR-2003-308 | |
| loc_nbr | OFTReal | 11.5k | 10216.0, 10654.0, 10600.0 | |
| loc_dir | OFTString | 8 | S, S, S | |
| loc_street | OFTString | 5.0k | PREBLE COUNTY LINE, PREBLE COUNTY LINE, PREBLE COUNTY LINE | |
| loc_suffix | OFTString | 43 | RD, RD, RD | |
| pid_flg01 | OFTString | 31 | CAUV, CAUV, CAUV | |
| loc_area | OFTString | 22 | GERMAN TOWNSHIP, GERMAN TOWNSHIP, GERMAN TOWNSHIP | |
| pid_verify | OFTString | 5 | N, N, N | |
| k_dist | OFTString | 48 | K50, K51, K50 | |
| k_book | OFTReal | 215 | 0.0, 0.0, 0.0 | |
| k_page | OFTReal | 44 | 0.0, 0.0, 0.0 | |
| k_pages | OFTString | 4 | A, A, A | |
| k_indx | OFTReal | 267 | 0.0, 0.0, 0.0 | |
| pid_status | OFTReal | 3 | 0.0, 0.0, 0.0 | |
| cama_match | OFTString | 3 | X, X, X | |
| nbhd_1 | OFTString | 878 | 87000000, 87000000, 87000000 | |
| k_pid | OFTString | 13.0k | ROW, K50 18431 0005, K51 00103 0005 | |
| survey_req | OFTString | 4 | N, N, N | |
| str_id | OFTInteger | 2 | 1, 1, 1 | |
| mcstr_id | OFTInteger | 6.0k | 13837, 13837, 13837 | |
| bldg_cnt | OFTInteger | 1 | 0, 0, 0 | |
| addr_cnt | OFTInteger | 1 | 0, 0, 0 | |
| hot_link | OFTString | 6.9k | \\nasunisys\gisdata\BKPG_tiff\t3\t3r4300d.tif, \\nasunisys\gisdata\BKPG_tiff\t3\t3r4300d.tif, \\nasunisys\gisdata\BKPG_tiff\t3\t3r4300d.tif | |
| vprecinct | OFTString | 277 | 1470, 1470, 1470 | |
| vname | OFTString | 277 | GERMAN TOWNSHIP A, GERMAN TOWNSHIP A, GERMAN TOWNSHIP A | |
| vlabel | OFTString | 276 | GERTWP-A, GERTWP-A, GERTWP-A | |
| vprec_spli | OFTString | 6 | 01, 01, 01 | |
| photo_link | OFTString | 50.0k | D14 00910 0001, D14 00910 0013, D14 00910 0011 | |
| web_bkpg_l | OFTString | 6.9k | PDF_BKPG/t3/t3r4300d.pdf, PDF_BKPG/t3/t3r4300d.pdf, PDF_BKPG/t3/t3r4300d.pdf | |
| web_archiv | OFTString | 1 | http://www.mcegisohio.org/PDF_BKPG/oa/oa22333z.pdf, http://www.mcegisohio.org/PDF_BKPG/oa/oa22333z.pdf, http://www.mcegisohio.org/PDF_BKPG/oa/oa22333z.pdf | |
| v_uscong | OFTString | 2 | CN10, CN10, CN10 | |
| v_senate | OFTString | 3 | SN06, SN06, SN06 | |
| v_house | OFTString | 6 | HS42, HS42, HS42 | |
| v_city | OFTString | 13 | X, X, X | |
| v_village | OFTString | 4 | CAR, X, CAR | |
| v_town | OFTString | 10 | GERTWP, GERTWP, GERTWP | |
| v_cobded | OFTString | 4 | MONT, MONT, MONT | |
| v_school | OFTString | 18 | VV, VV, VV | |
| v_vocsch | OFTString | 4 | MV, MV, MV | |
| v_courts | OFTString | 8 | MBG, MBG, MBG | |
| v_library | OFTString | 5 | GTN, GTN, GTN | |
| v_ward | OFTString | 57 | GERTWP, GERTWP, GERTWP | |
| v_unctwp | OFTString | 6 | GERTWP, GERTWP, GERTWP | |
| v_cocrts | OFTString | 2 | X, X, X | |
| v_crtapl | OFTString | 2 | AP02, AP02, AP02 | |
| v_stbded | OFTString | 2 | ED03, ED03, ED03 | |
| v_type2 | OFTString | 1 | JKNL, JKNL | |
| v_location | OFTString | 2 | VL0002, VL0002, VL0001 | |
| c_block | OFTString | 8 | 2, 2, 2 | |
| c_track | OFTString | 129 | 160100, 160100, 160100 | |
| x_gis_ref | OFTReal | 10.3k | 18093.0, 18034.0, 17467.0 | |
| v_police | OFTString | 30 | GERTWP, GERTWP, GERTWP | |
| v_fire | OFTString | 24 | GERTWP, GERTWP, GERTWP | |
| v_park | OFTString | 6 | GERTWP, GERTWP, GERTWP | |
| v_roads | OFTString | 28 | GERTWP, GERTWP, GERTWP | |
| v_other | OFTString | 27 | GTN GERTWP INC CEMTRY, GTN GERTWP INC CEMTRY, GTN GERTWP INC CEMTRY | |
| owner1 | OFTString | 50.0k | DAY ROBERT AND, NEFF RICHARD P, EISENMENGER CARL L TRUSTEE | |
| owner2 | OFTString | 29.1k | JOAN, ELAINE, JAKE EDWARD JR | |
| loc_city | OFTString | — | ||
| loc_state | OFTString | — | ||
| loc_zip | OFTString | 43 | 45042, 45042, 45042 | |
| loc_zip4 | OFTString | — | ||
| loc_faddre | OFTString | 1 | V, V | |
| loc_zip_fl | OFTString | 5 | V, V, V | |
| parcel_use | OFTString | 6 | ROADWAY, RAILROAD, MCD | |
| parcel_u_1 | OFTString | 29 | DEEDS/1969-B02489P00676.pdf, DEEDS/2002-164625.pdf, DEEDS/2003-042985.pdf | |
| parcel_u_2 | OFTString | 15 | www.miamisburgcityschools.org, www.miamisburgcityschools.org, www.centerville.k12.oh.us | |
| disclaimer | OFTString | 15 | 45459 45458 (two zip code parcel), 45449 45342 (two zip code parcel), 45439 45459 (two zip code parcel) | |
| disclaim_1 | OFTString | 76 | RA_175_32_X_P.pdf, RA___X_P.pdf, RA_ _ _X_P.pdf | |
| web_arch_1 | OFTString | 2.3k | DE_001_04_X_P.pdf, DE_001_09_X_P.pdf, DE_001_09_X_P.pdf | |
| web_arch_2 | OFTString | 109 | T3R4S30X_S.pdf, T3R4S30X_S.pdf, T3R4S30X_S.pdf | |
| create_flg | OFTString | 4 | S, S, S | |
| create_ope | OFTString | 6 | JTP, CAJ, DDW | |
| create_dat | OFTString | 580 | 20190418, 20200512, 20210714 | |
| objectid_1 | OFTInteger | 50.0k | 154839, 19095, 145464 | |
| parid | OFTString | 50.0k | D14 00910 0001, D14 00910 0013, D14 00910 0011 | |
| nbhd | OFTString | 880 | 87000000, 87000000, 87000000 | |
| parloc | OFTString | 50.0k | 10216 S PREBLE COUNTY LINE RD, 10654 COUNTY LINE RD, 10600 S PREBLE COUNTY LINE RD | |
| legal1 | OFTString | 50.0k | 4-3-30/19, 4-3-30, 4-3-30 | |
| legal2 | OFTString | 10.8k | AG-DIST 5/2020, AG-DIST 12/10/19, AG-DIST 12/10/19 | |
| legal3 | OFTString | 11.0k | 8-9-14, FOR R/W TOTAL AC 0.011 9-8-14E, 9-8-19 | |
| class | OFTString | 5 | A, R, A | |
| luc | OFTString | 106 | 101, 511, 101 | |
| acres | OFTString | 10.7k | 63.6500, 5.0030, 14.0000 | |
| assdcauv | OFTString | 2.1k | 101,330, 0, 41,480 | |
| assdland | OFTString | 7.2k | 35,470, 32,650, 14,520 | |
| assdbldg | OFTString | 15.9k | 30,190, 20,840, 64,420 | |
| assdtotal | OFTString | 18.7k | 65,660, 53,490, 78,940 | |
| apprcauv | OFTString | 2.1k | 101,330, 0, 41,480 | |
| apprland | OFTString | 12.5k | 101,330, 93,280, 41,480 | |
| apprbldg | OFTString | 32.1k | 86,270, 59,530, 184,070 | |
| apprtotal | OFTString | 37.6k | 187,600, 152,810, 225,550 | |
| dwel_style | OFTString | 20 | OLD STYLE, RANCH, RANCH | |
| dwel_yrblt | OFTReal | 218 | 1919.0, 1948.0, 1973.0 | |
| dwel_rmtot | OFTReal | 33 | 7.0, 5.0, 7.0 | |
| dwel_rmbed | OFTReal | 19 | 3.0, 3.0, 3.0 | |
| dwel_sfla | OFTReal | 4.3k | 1800.0, 1212.0, 2498.0 | |
| dwel_bsmt | OFTString | 3 | PART, CRAWL, FULL | |
| dwel_heat | OFTString | 3 | CENTRAL HEAT WITH A/C, CENTRAL HEAT WITH A/C, CENTRAL HEAT WITH A/C | |
| dwel_fuel | OFTString | 6 | OIL, OIL, GAS | |
| comm_yrblt | OFTReal | 171 | 0.0, 0.0, 0.0 | |
| comm_units | OFTReal | 133 | 0.0, 0.0, 0.0 | |
| comm_sf | OFTReal | 5.7k | 0.0, 0.0, 0.0 | |
| comm_bed | OFTReal | 138 | 0.0, 0.0, 0.0 | |
| oby_units | OFTReal | 24 | 1.0, 1.0, 1.0 | |
| oby_area | OFTReal | 2.3k | 2380.0, 2600.0, 120.0 | |
| oby_yrblt | OFTReal | 154 | 1900.0, 1900.0, 2000.0 | |
| oby_grade | OFTString | — | ||
| oby_value | OFTReal | 3.3k | 11120.0, 2600.0, 700.0 | |
| sale_date | OFTString | 6.8k | 08/26/1996, 01/10/2020, 06/11/2015 | |
| sale_price | OFTString | 10.7k | 119900, 334900, 348000 | |
| specasmts | OFTString | 2 | Y, Y, Y | |
| createdate | OFTString | 1 | 2022-06-23, 2022-06-23, 2022-06-23 | |
| hmsdflag | OFTString | 2 | Y, N, Y | |
| globalid | OFTString | 50.0k | {E0914A13-37D8-4E09-8DC8-08C80F507A90}, {A5C3AB35-611C-4D26-8123-15F408DA6B4B}, {D02A240C-8666-479E-AD94-D717DCDA0CB8} | |
| owner_name | OFTString | 50.0k | DAY ROBERT AND, NEFF RICHARD P, EISENMENGER CARL L TRUSTEE | |
| owner_na_1 | OFTString | 29.1k | JOAN, ELAINE, JAKE EDWARD JR | |
| owner_addr | OFTString | 50.0k | 10216 PREBLE COUNTY LINE R, 10654 PREBLE COUNTY LINE R, 10600 PREBLE COUNTY LINE R | |
| owner_ad_1 | OFTString | 409 | #1410, PO BOX 972, PO BOX 972 | |
| owner_ad_2 | OFTString | 26.9k | MIDDLETOWN, OH 45042-9427, MIDDLETOWN, OH 45042-9431, MIDDLETOWN, OH 45042-9431 | |
| mailing_na | OFTString | 50.0k | ROBERT DAY, RICHARD P NEFF, CARL L EISENMENGER TR | |
| mailing__1 | OFTString | 26.1k | ELAINE, JAKE EDWARD JR, YANG | |
| mailing_ad | OFTString | 50.0k | 10216 PREBLE COUNTY LINE R, 10654 PREBLE COUNTY LINE R, 10600 PREBLE COUNTY LINE R | |
| mailing__2 | OFTString | 406 | REAL ESTATE SERVICES, P O BOX 972, P O BOX 972 | |
| mailing__3 | OFTString | 26.4k | MIDDLETOWN OH 45042 9427, MIDDLETOWN OH 45042 9431, MIDDLETOWN OH 45042 9431 | |
| dwel_extwa | OFTString | 9 | ALUMINUM/VINYL, ALUMINUM/VINYL, BRICK | |
| dwel_stori | OFTReal | 7 | 2.0, 1.0, 1.0 | |
| dwel_fixba | OFTReal | 12 | 1.0, 1.0, 2.0 | |
| dwel_fixha | OFTReal | 7 | 0.0, 0.0, 1.0 | |
| dwel_heats | OFTString | 4 | HOT AIR, HOT AIR, HOT AIR | |
| dwel_wbfp_ | OFTReal | 10 | 1.0, 0.0, 1.0 | |
| dwel_wbf_1 | OFTReal | 7 | 0.0, 0.0, 0.0 | |
| comm_struc | OFTString | 84 | MIXED RESIDENTIAL/COMMERCIAL, APARTMENTS - GARDEN, RESIDENTIAL 1 FAMILY | |
| comm_stori | OFTReal | 21 | 0.0, 0.0, 0.0 | |
| oby_improv | OFTString | 134 | FLAT BARN, SOUND VALUE OF MISC. STRUCTURE, FRAME UTILITY SHED | |
| oby_condit | OFTString | 6 | AVERAGE CONDITION, AVERAGE CONDITION, AVERAGE CONDITION | |
| sale_convn | OFTString | 26.0k | 14386, 537, 8669 | |
| sale_oldow | OFTString | 50.0k | WILLIAMS THOMAS D AND, STEVENS KENNETH L AND, JACKSON R RUSSELL ET AL 3 | |
| mcityname | OFTString | 2.0k | MIDDLETOWN, MIDDLETOWN, MIDDLETOWN | |
| mstatecode | OFTString | 61 | OH, OH, OH | |
| mzip1 | OFTString | 3.7k | 45042, 45042, 45042 |
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.