99 attribute fields, profiled from the May 2022 vintage.
Columns in Madison County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 50.0k | 766541, 766542, 766576 | |
| name | OFTString | 50.0k | 481604300007000014, 481604300002000014, 481604300004000014 | |
| createdbyr | OFTString | 9.2k | {170659FB-90D3-40E5-B29C-4E39DF24A3E7}, {58A79FE7-96B8-43F0-9147-49628659229B}, {EA9EB127-28A5-4E28-8487-FA4557CC6416} | |
| retiredbyr | OFTString | 116 | {9C57CD1B-AD84-4332-86B9-0402C4C44A39}, {3369DFE5-FF1F-4AD9-A4F6-97A8DC420AD5}, {58DAC653-7105-4DBD-8002-62E46DE2D5BF} | |
| statedarea | OFTReal | 11.2k | 0.138, 0.706, 14.584 | |
| statedar_1 | OFTInteger | 3 | 109402, 109402, 109402 | |
| calculated | OFTReal | 18 | 0.149, 0.197, 0.285 | |
| misclosera | OFTReal | 1 | 100000.0 | |
| misclosedi | OFTReal | 1 | 0.0 | |
| isseed | OFTInteger | 2 | 0, 0, 0 | |
| created_us | OFTString | 2 | OBRIEN, OBRIEN, OBRIEN | |
| created_da | OFTString | 83 | 2021-06-28, 2021-06-28, 2021-06-28 | |
| last_edite | OFTString | 2 | VO89265, VO89265, VO89265 | |
| last_edi_1 | OFTString | 92 | 2021-07-09, 2021-07-09, 2021-07-09 | |
| globalid | OFTString | 50.0k | {DB3DAF22-1913-415A-ACA2-DA7A628E1D0E}, {51F6046D-92CD-4900-9B93-2E2FF070D8E5}, {EA8D502D-487D-4437-AD42-F7765E41FFEF} | |
| keyno | OFTString | 50.0k | 06-3004-8-002, 06-0021-1-013, 06-0021-1-031 | |
| taxingunit | OFTString | 41 | 06, 06, 06 | |
| taxlink | OFTString | 50.0k | 06-06-3004-8-002, 06-06-0021-1-013, 06-06-0021-1-031 | |
| state_pin_ | OFTString | 2 | 48, 48, 48 | |
| state_pi_1 | OFTString | 19 | 16, 16, 16 | |
| state_pi_2 | OFTString | 38 | 04, 04, 04 | |
| state_pi_3 | OFTString | 28 | 300, 300, 300 | |
| state_pi_4 | OFTString | 1.9k | 007000, 002000, 004000 | |
| state_pi_5 | OFTString | 46 | 014, 014, 014 | |
| state_pin | OFTString | 50.0k | 481604300007000014, 481604300002000014, 481604300004000014 | |
| legal_desc | OFTString | 16.7k | SW SW, SW SW, SW SW | |
| legal_str | OFTString | 836 | 04176, 04176, 04176 | |
| legal_sect | OFTString | 144 | 04, 04, 04 | |
| legal_bloc | OFTString | 213 | Common Area D, 1, R/W | |
| subdivisio | OFTString | 2.3k | ADMIN. PLAT 2011-P-031 REPLAT, ADMIN. PLAT 2011-P-031 REPLAT, WATT LANDING | |
| legal_lot_ | OFTString | 4.3k | 000, 000, 000 | |
| legal_acre | OFTReal | 49.6k | 0.127, 0.66, 14.583 | |
| legal_s | OFTString | 62 | 33, 33, 33 | |
| legal_t | OFTInteger | 26 | 17, 17, 17 | |
| legal_r | OFTString | 12 | 6, 6, 6 | |
| misc | OFTString | 2.9k | frontage in Hamilton Co, frontage in Hamilton Co, frontage in Hamilton Co | |
| notes | OFTString | 310 | *legal measures 17.522A, *have made to work, *have made to work | |
| frmtd_pin | OFTString | 50.0k | 48-16-04-300-007.000-014, 48-16-04-300-002.000-014, 48-16-04-300-004.000-014 | |
| created__1 | OFTString | — | ||
| created__2 | OFTString | 1 | 2021-05-03 | |
| last_edi_2 | OFTString | — | ||
| last_edi_3 | OFTString | — | ||
| qtrsection | OFTString | 224 | SW, SW, SW | |
| instrument | OFTString | 9.1k | DR 653-625=orig 0.787A, 2013R004273=0.056A, 2021R0tbd=0.706A, 2012R003653, 2011R016098=orig Plat of Lt 1, 2015R018140=RP of Lt 1 | |
| surveyorte | OFTString | 977 | ACCURA EXPRESS, Accura Express=orig Plat, Ward=REPLAT, S=BENCHMARK 12/2005 REFLECTS GAP BETWEEN EAST ADJOINER | |
| vacationte | OFTString | 278 | V/A OP Ingalls per Ordinance #052217=2017R007065, ORDINANCE #2005-4=2005016751, ORDINANCE #2005-4=2005016751 | |
| annexation | OFTString | 137 | Ordinance 2005-02, Ordinance 2005-2=3.022A, Ordinance 2012-7=bal 4.978A, Ordinance 2005-2=2.149A, Ordinance 2012-7=bal 38.094A | |
| combineste | OFTString | 1.1k | 48-16-04-300-004.001-014 (0.056A) per 2021 deed, 06-0022-1-107, 06-0022-1-073 | |
| classifica | OFTString | 18 | 2020R004614=removal from CFL, CFL per Instr 2014R001875=21.1A, #155-6-1A/48-14-20-100-206.000-013 per DR 533-711 | |
| rwtext | OFTString | 50 | 40' Madison County, 50' State of Indiana, 30' RW per plat | |
| grantstext | OFTString | 49 | 2009012885-888=0.043A, Subj to R/W Grant per Instr 9412382, Subj to R/W Grant per Instr 9412382 | |
| rrtext | OFTString | 2 | Correct Parcel location 6/1/2018 BLJ | |
| easementte | OFTString | 127 | PRIVATE DR per PLAT, 50' PRIVATE ROADWAY as SHOWN ON PLAT, Subj to INGRESS/EGRESS Esmt per DR 577-479 | |
| validation | OFTInteger | 1 | 2, 2, 2 | |
| parcelkey | OFTInteger | 50.0k | 9039, 8055, 8072 | |
| num | OFTString | 50.0k | 48-16-04-300-007.000-014, 48-16-04-300-002.000-014, 48-16-04-300-004.000-014 | |
| altnum | OFTString | 50.0k | 06-3004-8-002, 06-0021-1-013, 06-0021-1-031 | |
| taxid | OFTString | 50.0k | 06-06-3004-8-002, 06-06-0021-1-013, 06-06-0021-1-031 | |
| routingnbr | OFTString | 927 | M11-, M11-, M11- | |
| sectionpla | OFTString | 238 | -00, 04, 04 | |
| zoningcode | OFTString | — | ||
| subdivis_1 | OFTString | — | ||
| subdivis_2 | OFTString | 1.4k | 000, 000, 000 | |
| streetaddr | OFTString | 50.0k | 2980 ST RD 238, 1103 N MERRILL ST, 0 SR 238 | |
| city | OFTString | 141 | FORTVILLE, FORTVILLE, FORTVILLE | |
| state | OFTString | 1 | IN, IN, IN | |
| zip | OFTString | 75 | 46064, 46040, 46040 | |
| neighborho | OFTString | 714 | AVERAGE RATING NBHD, RURAL RES, RURAL RES | |
| neighbor_1 | OFTString | 1.0k | 4-014, 60001-014, 60001-014 | |
| neighbor_2 | OFTString | 125 | 1.130000, 1.330000, 1.330000 | |
| propertycl | OFTString | 121 | 610, 511, 100 | |
| property_1 | OFTString | 120 | Exempt, State of Indiana, 1 Family Dwell - Unplatted (0 to 9.99 Acres), Vacant Land | |
| legaldesc | OFTString | 42.0k | SW SW 0.1270Acres STR: 04176 SECTION: PLAT: IN: OUT:, SW SW 0.6600Acres STR: 04176 SECTION: PLAT: 00 IN: OUT:, SW SW 04-17-6 000 14.583AC | |
| ownername | OFTString | 50.0k | STATE OF INDIANA, SMITH WILLIAM HARVEY & JESSICA, TRIPLE L RANCH LLC | |
| ownername2 | OFTString | 5.7k | C/O GREEN TOWNSHIP TRUSTEE, COOPER, L/E MARIE FAUSSET | |
| owneraddre | OFTString | 46.4k | 32 S BROADWAY ST, 1103 N MERRILL STREET, 3145 KILLION MILL ROAD | |
| owneradd_1 | OFTString | 427 | c/o Samuel Scott Summerlin, c/o Morris & Barbara Hensley, c/o Morris & Barbara Hensley | |
| ownercity | OFTString | 1.1k | GREENFIELD, FORTVILLE, LOOGOOTEE | |
| ownerstate | OFTString | 53 | IN, IN, IN | |
| ownerzip | OFTString | 12.3k | 46140, 46040-9760, 47553 | |
| townshipna | OFTString | 14 | GREEN TOWNSHIP, GREEN TOWNSHIP, GREEN TOWNSHIP | |
| townshipnu | OFTString | 14 | 0006, 0006, 0006 | |
| taxdistric | OFTString | 43 | 014, 014, 014 | |
| taxdistr_1 | OFTString | 43 | GREEN TOWNSHIP, GREEN TOWNSHIP, GREEN TOWNSHIP | |
| schoolcorp | OFTString | 6 | SOUTH MADISON COMMUNITY, SOUTH MADISON COMMUNITY, SOUTH MADISON COMMUNITY | |
| totalacrea | OFTReal | 8.5k | 0.127, 0.66, 14.583 | |
| marketarea | OFTString | 2.3k | 999999, <1940 Rural Res SFH's-South, 60001-100-199 | |
| calculat_1 | OFTReal | 16.1k | 0.126997, 0.660009, 14.583011 | |
| calculat_2 | OFTReal | 16.8k | 0.08999, 0.660009, 14.583011 | |
| lat | OFTReal | 39.9k | 39.943656, 39.943958, 39.944263 | |
| long | OFTReal | 25.7k | -85.862365, -85.862251, -85.860008 | |
| confidenti | OFTInteger | 2 | 0, 0, 0 | |
| reviewyear | OFTInteger | 4 | 2018, 2018, 2018 | |
| listerdate | OFTString | 839 | 2018-05-14, 2018-09-27, 2018-05-22 | |
| reviewerda | OFTString | 701 | 2018-10-10, 2018-05-22, 2018-05-22 | |
| dataentere | OFTInteger | 2 | 1, 1, 1 | |
| dataentryd | OFTString | 739 | 2018-07-27, 2018-09-06, 2018-05-22 | |
| starea() | OFTReal | 50.0k | 6025.646575, 30725.708725, 635264.613522 | |
| stlength() | OFTReal | 50.0k | 386.702884, 735.177804, 3679.690676 |
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.