Aged
136 attribute fields, profiled from the August 2022 vintage.
Columns in York County
| Field | Type | Filled | Distinct | Example values |
|---|---|---|---|---|
| objectid | OFTInteger | 27.8k | 20846, 20919, 20973 | |
| gpin | OFTString | 27.8k | S03c-0949-0074, S02a-1858-3769, S02b-3036-4855 | |
| record_gpi | OFTString | 27.0k | S03c-0949-0074, S02a-1858-3769, S02b-3036-4855 | |
| map | OFTString | 27.3k | 036 23, 036 1 A1, 036 21 | |
| strtnumb | OFTInteger | 2.0k | 401, 600, 222 | |
| numbsfx | OFTString | 40 | A, LL, Z1 | |
| subdivisio | OFTString | 492 | COMMONWEALTH GREEN, ROAD, LANDINGS AT LANGLEY | |
| zonetype | OFTString | 49 | GB, PD, EO | |
| near_hydra | OFTInteger | 1.9k | 146, 1054, 818 | |
| priorowner | OFTString | 19.9k | YORKTOWN HOTEL LLC, COMMONWEALTH GREEN LLLP, GIBSON EQUIPMENT CO INC | |
| prv1date | OFTString | 6.5k | 2013-07-24, 2013-03-27, 1975-10-01 | |
| prv1cons | OFTReal | 4.2k | 5100000.0, 0.0, 27500.0 | |
| prv1deed | OFTString | 19.3k | 130014202, 130005619, 281-552 | |
| priorown_1 | OFTString | 15.0k | PATEL MAHESH & MINABEN, J L K FAMILY THE LLC, YORK AUTO PARTS INC | |
| prv2date | OFTString | 5.4k | 2013-07-03, 2013-03-22, 1986-08-01 | |
| prv2cons | OFTReal | 3.4k | 0.0, 0.0, 0.0 | |
| prv2deed | OFTString | 13.2k | 130012713, 451-645, 426-522 | |
| tablzone_d | OFTString | 17 | General Business, Planned Development, Economic Opportunity | |
| supdistr | OFTInteger | 5 | 2, 2, 2 | |
| precinct | OFTString | 13 | KILN CREEK, KILN CREEK, KILN CREEK | |
| polladdr | OFTString | 15 | 100 LONG GREEN BLVD, 23693, 100 LONG GREEN BLVD, 23693, 100 LONG GREEN BLVD, 23693 | |
| poll | OFTString | 13 | TABB LIBRARY, TABB LIBRARY, TABB LIBRARY | |
| sthouse | OFTInteger | — | ||
| stsenate | OFTInteger | — | ||
| elemdist | OFTString | 10 | GRAFTON BETHEL, GRAFTON BETHEL, GRAFTON BETHEL | |
| highdist | OFTString | 4 | GRAFTON, GRAFTON, GRAFTON | |
| trashday | OFTString | 5 | TUESDAY, TUESDAY, WEDNESDAY | |
| recycleday | OFTString | 5 | TUESDAY, TUESDAY, FRIDAY | |
| recweek | OFTString | 2 | BLUE, BLUE, BLUE | |
| fldzone | OFTString | 19 | X, X, X | |
| bfe | OFTString | 39 | 8, 18, 18 | |
| surge | OFTInteger | 5 | 0, 0, 0 | |
| rpa | OFTString | 2 | NO, YES, NO | |
| rma | OFTString | 2 | NO, YES, NO | |
| wmp200 | OFTString | 2 | NO, YES, NO | |
| wmp500 | OFTString | 2 | YES, YES, NO | |
| airportzon | OFTString | 2 | NO, NO, NO | |
| firestnumb | OFTInteger | 6 | 2, 2, 2 | |
| firestname | OFTString | 6 | STATION NUMBER 2 TABB, STATION NUMBER 2 TABB, STATION NUMBER 2 TABB | |
| firestaddr | OFTString | 7 | 4405 BIG BETHEL RD, 23693, 4405 BIG BETHEL RD, 23693, 4405 BIG BETHEL RD, 23693 | |
| change_dat | OFTString | 1.1k | 2004-10-21, 2013-03-29, 2013-04-12 | |
| rooftype | OFTString | 8 | Typical, Typical, Flat | |
| lval2014 | OFTReal | 1.0k | 479000.0, 2355000.0, 323000.0 | |
| ival2014 | OFTReal | 4.6k | 4431200.0, 0.0, 94200.0 | |
| mval2014 | OFTReal | 6.0k | 4910200.0, 2355000.0, 417200.0 | |
| lval2012 | OFTReal | 2.4k | 479200.0, 2354700.0, 323200.0 | |
| ival2012 | OFTReal | 4.7k | 4431200.0, 0.0, 94200.0 | |
| mval2012 | OFTReal | 6.4k | 4910400.0, 2354700.0, 417400.0 | |
| lval2010 | OFTReal | 2.7k | 575000.0, 0.0, 369400.0 | |
| ival2010 | OFTReal | 4.8k | 5783400.0, 0.0, 111600.0 | |
| mval2010 | OFTReal | 6.5k | 6358400.0, 0.0, 481000.0 | |
| lval2008 | OFTReal | 2.8k | 500800.0, 0.0, 323200.0 | |
| ival2008 | OFTReal | 5.0k | 5395000.0, 0.0, 115600.0 | |
| mval2008 | OFTReal | 6.7k | 5895800.0, 0.0, 438800.0 | |
| starea() | OFTReal | 27.6k | 96694.28334, 617210.523134, 93675.393594 | |
| stlength() | OFTReal | 27.5k | 1312.498025, 3703.021335, 1245.680635 | |
| evaczone | OFTString | 4 | B, B, A | |
| lval2016 | OFTReal | 996 | 479000.0, 11071000.0, 323000.0 | |
| ival2016 | OFTReal | 4.7k | 4431200.0, 9531400.0, 94200.0 | |
| mval2016 | OFTReal | 6.1k | 4910200.0, 20602400.0, 417200.0 | |
| lval2018 | OFTReal | 2.6k | 1603800.0, 6033500.0, 323000.0 | |
| ival2018 | OFTReal | 4.7k | 3742900.0, 39098000.0, 161700.0 | |
| mval2018 | OFTReal | 6.3k | 5346700.0, 45131500.0, 484700.0 | |
| prclkey | OFTInteger | 27.6k | 321113, 3402735, 313916 | |
| lval2020 | OFTReal | 2.8k | 1721400.0, 6033500.0, 323000.0 | |
| ival2020 | OFTReal | 4.7k | 4016600.0, 43707200.0, 236100.0 | |
| mval2020 | OFTReal | 6.4k | 5738000.0, 49740700.0, 559100.0 | |
| pid | OFTInteger | 27.0k | 19594, 19596, 19592 | |
| accountnum | OFTString | 27.0k | 120009932, 120017118, 12408 | |
| gisacres | OFTReal | 1.1k | 2.22, 14.17, 2.15 | |
| whole_stna | OFTString | 1.4k | COMMONWEALTH DRIVE, COMMONWEALTH DRIVE, APPLE LANE | |
| address | OFTString | 27.2k | 401 COMMONWEALTH DR, 600 COMMONWEALTH DR, 222 APPLE LN | |
| prefix | OFTString | 4 | E, W, W | |
| stname | OFTString | 1.3k | COMMONWEALTH, COMMONWEALTH, APPLE | |
| road_type | OFTString | 43 | DR, DR, LN | |
| addrkey | OFTInteger | 27.2k | 1893654, 3789527, 334825 | |
| appraiserc | OFTString | 4 | TABB, TABB, TABB | |
| appraiserd | OFTString | 4 | Tabb, Tabb, Tabb | |
| legaldescr | OFTString | 26.2k | RESUB OF JEANETTE J KEENER, PLAT OF GIBSON EQUIP CO & R/W, PLAT OF STEPHEN D ASHE & BOBBY D ASHE JR | |
| ownername | OFTString | 23.6k | YORKTOWN HOLDINGS LLC, MOYORK LLC, 222 APPLE LANE LLC | |
| ownercolin | OFTString | 610 | C/O VIRGINIA FITZHUGH-WILSON, C/O THOMAS R TUCKER, C/O THOMAS R TUCKER | |
| owneraddre | OFTString | 22.5k | 2768 NESTLEBROOK TRL, 242 MUSTANG TRAIL STE 1, 248 W BUTE ST #200 | |
| ownercity | OFTString | 733 | VIRGINIA BEACH, VIRGINIA BEACH, NORFOLK | |
| ownerstate | OFTString | 53 | VA, VA, VA | |
| ownerzip | OFTString | 1.7k | 23456, 23452, 23510 | |
| deed | OFTString | 24.1k | 210023859, 130005621, 080026367 | |
| transferda | OFTString | 6.3k | 2021-12-01, 2013-03-27, 2008-11-25 | |
| saletype | OFTString | 2 | Q, Q, Q | |
| prv1salety | OFTString | 2 | Q, U, U | |
| prv2salety | OFTString | 2 | U, U, U | |
| mapnumber | OFTString | 26.7k | 36 -00 -00 -023, 36 -01 -00 -000A1, 36 -00 -00 -021 | |
| parcelstat | OFTString | 2 | A, A, A | |
| classtype | OFTString | 14 | 4, 3, 4 | |
| usecode | OFTString | 79 | HOTL, APTS, COMM | |
| usedescrip | OFTString | 79 | Hotels, Apartments, Commercial Improved | |
| magesteria | OFTString | 4 | Bethel, Bethel, Bethel | |
| neighborho | OFTString | 398 | CVCBLV, APT, CRT17 | |
| neighbor_1 | OFTString | 394 | VICTORY BLVD COMM CORRIDOR, APARTMENT SITES PER UNIT, ROUTE 17 COMMERCIAL CORRIDOR | |
| legalacres | OFTReal | 7.4k | 2.2, 14.12, 2.12 | |
| vis_street | OFTInteger | 2.0k | 401, 600, 222 | |
| vis_stre_1 | OFTString | 40 | A, LL, Z1 | |
| vis_stre_2 | OFTString | 4 | E, W, W | |
| vis_stre_3 | OFTString | 1.3k | COMMONWEALTH, COMMONWEALTH, APPLE | |
| vis_stre_4 | OFTString | 44 | DR, DR, LN | |
| propertyzi | OFTString | 9 | 23693, 23693, 23693 | |
| propertyde | OFTString | 877 | Bldg permit issued 08/20/20 to convert S, In 2011 two heat pumps were installed,, 2021 - Changed to Advanced | |
| considerat | OFTReal | 4.6k | 10275000.0, 8640000.0, 400000.0 | |
| primarybui | OFTString | 3 | Commercial, Commercial, Commercial | |
| buildingst | OFTString | 70 | Commercial, Commercial, Commercial | |
| livingarea | OFTReal | 4.1k | 67925.0, 33572.0, 4800.0 | |
| yearbuilt | OFTInteger | 144 | 2008, 2016, 1976 | |
| storycount | OFTString | 16 | 4, 1, 2 | |
| roomcount | OFTString | 19 | 1, 5, 6 | |
| bedroomcou | OFTString | 13 | 0, 0, 0 | |
| fullbathco | OFTString | 10 | 0, 0, 1 | |
| halfbathco | OFTString | 9 | 0, 2, 1 | |
| fireplacec | OFTString | 8 | 0, 0, 0 | |
| hassplitle | OFTString | 2 | N, N, N | |
| hvac | OFTString | 3 | Heat / CAC, Heat / CAC, Heat / CAC | |
| heatfuel | OFTString | 10 | Gas, Heat Pump, Heat Pump | |
| heatsystem | OFTString | 13 | Forced Air, Heat Pump, Heat Pump | |
| roofcover | OFTString | 14 | Arch Shng, Tar/Gravel, Metal | |
| exteriorwa | OFTString | 24 | Brick, Concrete Block, Metal | |
| exterior_1 | OFTString | 19 | Dryvit, Vinyl, Brick Veneer | |
| foundation | OFTString | 6 | Slab, Slab, Slab | |
| utilities | OFTString | 11 | Water/Sewer, Sewer, Water/Septic | |
| currlandva | OFTReal | 3.6k | 859900.0, 6156000.0, 314800.0 | |
| currimprov | OFTReal | 5.1k | 9140100.0, 51254600.0, 253300.0 | |
| curroutbui | OFTReal | 1.0k | 0.0, 0.0, 71200.0 | |
| currtotalv | OFTReal | 6.9k | 10000000.0, 57410600.0, 568100.0 | |
| photofilep | OFTString | 24.5k | \\po-yorkfile\gov$\~VISION\Images\0063\IMG_7124_63184.JPG, \\po-yorkfile\gov$\~VISION\Images\S02\S02a-1858-3769_g.JPG, \\po-yorkfile\gov$\~VISION\Images\S02\S02b-3036-4855_b.JPG | |
| globalid | OFTString | 27.8k | {233366D7-8C0A-4C6E-888D-F840FE97F79D}, {E28A30B8-7981-4835-8626-252A8B6D1455}, {5A916F67-B081-43E1-9125-57B83B7D9F0F} | |
| lastedited | OFTString | 33 | 2022-07-01, 2022-05-31, 2022-07-01 | |
| lval2022 | OFTReal | 3.6k | 859900.0, 6156000.0, 314800.0 | |
| ival2022 | OFTReal | 5.0k | 9140100.0, 51254600.0, 253300.0 | |
| mval2022 | OFTReal | 6.9k | 10000000.0, 57410600.0, 568100.0 |
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.