Created by gkorkmaz, last modified by molfe on 31 Dec 2015

Codebooks

  • BKFS dataset came with a codebook.
  • 51013 is the code for Arlington.

Data Description

The tables below show the overall description of the various data tables used for this study. 

"APN-A" (Field No. 3)  is the Parcel Identification Number
YearNUnit of AnalysisUniqueness
200964,827APN-Aunique
201065,201APN-Aunique
201165,264APN-Aunique
201265,364APN-Aunique
201365,443APN-Aunique
201465,622APN-Aunique
2009-2014

66,106

APN-A 

Data Quality

The tables below contain the results of the data profiling of key variables for the the following tables

 

Quality: 2009-2014
DuplicationsNo duplicated rows
Field No. 3 "APN-A"   No duplications
VariablesCompletenessValidityUniquenessConsistency

Field No. 1 "State (Postal Code)"

100%100%VA100%

Field No. 2 "County Name"

100%100%Arlington100%

Field No. 4 "Duplicate APN /Multiple Address ID"

all NA 

 

NA Coding: NA

Field No. 5 "Property Address Source Flag"

2009: 18,911 missing

2010: 18,691 missing

2011: 18,418 missing

2012: 18,707 missing

2013: 18,902 missing

2014: 19,383 missing

 Levels: "P" (Partial situs address (city state & ZIP only) was created from the mailing addressNA Coding: " "

Field No. 6 "House Number"


2009: 2,596 missing

2010: 2,558 missing

2011: 2,556 missing

2012: 2,531 missing

2013: 2,521 missing

2014: 2,546 missing

 

(2009-2014) 6,514 levels

2009 Levels: 6,291

2010 Levels: 6,486

2011 Levels: 6,252

2012 Levels: 6,263

2013 Levels: 6,254

2014 Levels: 6,251

NA Coding: " "

Field No. 7 "House Alpha"

2009: 64,556 missing

2010: 65,193 missing

2011: 64,949 missing

2012: 65,049 missing

2013: 65,128 missing

2014: 65,307 missing

 Levels: "A" "B" "C" "D" "E" "F" "G" "H" "I" "J"NA Coding: " "

Field No. 8 "Street Direction - Left"

2009: 28,490 missing

2010: 28,314 missing

2011: 28,356 missing

2012: 28,400 missing

2013: 28,498 missing

2014: 28,501 missing

 

Levels: "N" "S"

NA Coding: " "

Field No. 9 "Street Name"

(2009-2014) 27 missing

2009: 0 missing

2010: 0 missing

2011: 19 missing

2012: 0 missing

2013: 5 missing

2014: 3 missing

Levels coded with spaces

(2009-2014) 295 levels

2009 Levels: 293

2010 Levels: 293

2011 Levels: 293

2012 Levels: 294

2013 Levels: 293

2014 Levels: 294

NA coding: “ ”

Field No. 10 "Suffix"

(2009-2014) 27 missing

2009: 0 missing

2010: 0 missing

2011: 19 missing

2012: 0 missing

2013: 5 missing

2014: 3 missing

 

13 Levels: "AVE" "BLVD" "CIR" "CT" "DR" "HWY" "LN" "PIKE" "PKWY" "PL" "RD" "ST" "TER"

2009 Levels: 13

2010 Levels: 13

2011 Levels: 13

2012 Levels: 13

2013 Levels: 13

2014 Levels: 13

NA coding: " "

Field No. 11 "Street Direction - Right"

2009: 46,818 missing

2010: 47,176 missing

2011: 47,228 missing

2012: 47,318 missing

2013: 47,387 missing

2014: 47,562 missing

 Levels: "N" "S"NA Coding: " "

Field No. 12 "Unit Number"

2009: 64,827 missing

2010: 65,185 missing

2011: 64,926 missing

2012: 65,030 missing

2013: 65,111 missing

2014: 65,291 missing

 

2009 Levels: 0

2010 Levels: 8

2011 Levels: 43

2012 Levels: 39

2013 Levels: 36

2014 Levels: 36

NA Coding: " "

Field No. 13 "Full Street Add."

(2009-2014) 27 missing

2009: 0 missing

2010: 0 missing

2011: 19 missing

2012: 0 missing

2013: 5 missing

2014: 3 missing

Levels coded with spaces(2009-2014) 41,685 levels

2009 Levels: 40,566

2010 Levels: 40,675

2011 Levels: 40,717

2012 Levels: 40,767

2013 Levels: 40,819

2014 Levels: 40,862

 NA Coding: " "

Field No. 14 "City Name"

2009: 1,014 missing

2010: 814 missing

2011: 1,013 missing

2012: 1,009 missing

2013: 985 missing

2014: 1,037 missing

Levels coded with spaces

Levels: "ARLINGTON" "FALLS CHURCH" "MC LEAN" "MCLEAN" "ROSSLYN"NA Coding: " "

Field No. 15 "State"

2009: 1,014 missing

2010: 814 missing

2011: 1,013 missing

2012: 1,009 missing

2013: 985 missing

2014: 1,037 missing

 VANA Coding: " "

Field No. 16 "Property ZIP Code"

2009: 1 missing

2010: 2 missing

2011: 23 missing

2012: 4 missing

2013: 11 missing

2014: 9 missing

 

Levels: "22214" "22211" "22212" "22046" "22101" "22213" "22202" "22209"

"22205" "22203" "22206" "22201" "22207" "22204"

NA Coding: NA

Field No. 17 "Property ZIP+4"

2009: 2999 missing

2010: 2840 missing

2011: 3609 missing

2012: 4968 missing

2013: 2971 missing

2014: 3020 missing

 4,144 LevelsNA Coding: NA

Field No. 117 "Property Address: Latitude"

2009: 2,990 missing

2010: 2,581 missing

2011: 2,970 missing

2012: 2,912 missing

2013: 2,873 missing

2014: 2,918 missing

 

 Levels: ( 99.999999)

(2009-2014) 65,019 levels

2009 Levels: 28,649

2010 Levels: 20,482

2011 Levels: 18,324

2012 Levels: 29,688

2013 Levels: 29,223

2014 Levels: 29,246

NA Coding: NA

Field No. 118 "Property Address: Longitude"

2009: 2,990 missing

2010: 2,581 missing

2011: 2,970 missing

2012: 2,912 missing

2013: 2,873 missing

2014: 2,918 missing

 

 Levels: ( -999.999999)

(2009-2014) 69,809 levels

2009 Levels: 30,081

2010 Levels: 16,852

2011 Levels: 13,712

2012 Levels: 30,679

2013 Levels: 30,721

2014 Levels: 30,740

NA Coding: NA

Field No. 119 "Property Address: Census Tract & Block"

2009: 2,990 missing

2010: 2,581 missing

2011: 2,970 missing

2012: 2,912 missing

2013: 2,873 missing

2014: 2,918 missing

 2,564 Levels for all years: (999999999.99999C)NA Coding: " "

Field No. 71 "County Land Use Description"

2009: 98 missing

2010: 0 missing

2011: 0 missing

2012: 0 missing

2013: 0 missing

2014: 32 missing

Levels coded with spaces60 LevelsNA Coding: " "

Field No. 72 "County Land Use Code"

100% 57 Levels (some codes have multiple descriptions in V71) 

Field No. 73 "Standardized Land Use Code"

2009: 98 missing

2010: 0 missing

2011: 0 missing

2012: 0 missing

2013: 0 missing

2014: 2 missing

 

34 Levels: [char](4)

NA Coding: NA

Field No. 78 "Year Built”

2009: 29,724 missing

2010: 30,008 missing

2011: 29,970 missing

2012: 30,033 missing

2013: 30,004 missing

2014: 30,228 missing

 

146 Levels: 1832-2012

2009 Levels: 142

2010 Levels: 143

2011 Levels: 143

2012 Levels: 143

2013 Levels: 144

2014 Levels: 144

NA Coding: NA
Field No. 149 "Effective Year Built"

2009: 64,827 (all) missing

2010: 31,771 missing

2011: 31,655 missing

2012: 31,692 missing

2013: 31,710 missing

2014: 31,814 missing

 103 Levels: 1900-2014

2009 Levels: 0

2010 Levels: 97

2011 Levels: 97

2012 Levels: 96

2013 Levels: 97

2014 Levels: 97

NA Coding: NA

Field No. 79 "No of Buildings”

all NA  NA Coding: NA

Field No. 80 "No of Stories”

2009: 31754 missing

2010: 31987 missing

2011: 31941 missing

2012: 32115 missing

2013: 32078 missing

2014: 32162 missing

 

34 Levels: "1" "1.5" "1.5+A" "1.5+B" "1.75" "1+A" "1+AB" "1+B" "2" "2.25"

"2.5" "2.5+A" "2.5+B" "2.75" "2+A" "2+AB" "2+B" "2+B+A" "2+BB" "3" "3.5"

"3.5+B" "3/L" "3/L+B" "3+B" "4" "4/L" "4/L+B" "4+B" "5" "S/F" "S/F+B" "S/L" "S/L+B"

 

S/L

Split level

4/L

4 split levels

1+A

1 story with attic

B/L

Bi-level

3/L

3 split levels

1+B

1 story with basement

S/E

Split entry

S/F

split foyer

2+B

2 stories with basement

NA Coding: " "

Field No. 81 "No of Units”

2009: 64,040 missing

2010: 64,420 missing

2011: 64,479 missing

2012: 64,580 missing

2013: 64,529 missing

2014: 64,730 missing

 

2009 Levels: 200 min:1 max: 842

2010 Levels: 201 min:1 max: 842

2011 Levels: 208 min:1 max: 842

2012 Levels: 209 min:1 max: 842

2013 Levels: 234 min:1 max: 9907

2014 Levels: 241 min:1 max: 9907

NA Coding: NA

Field No. 82 "Total # Rooms”

all NA  NA Coding: NA

Field No. 83 "No of Bedrooms”

2009: 14,791 missing

2010: 14,422 missing

2011: 13,991 missing

2012: 13,652 missing

2013: 13,247 missing

2014: 12,969 missing

 13 Levels: min:1 max:13NA Coding: NA

Field No. 84 "No of Baths”

2009: 7,978 missing

2010: 7,891 missing

2011: 7,723 missing

2012: 7,708 missing

2013: 7,620 missing

2014: 7,610 missing

 11 Levels: "100"  "200"  "300"  "400"  "500"  "600"  "700"  "800"  "900"  "1000" "1100"NA Coding: NA

Field No. 85 "No of Partial Baths”

2009: 46621 missing

2010: 46557 missing

2011: 46439 missing

2012: 46318 missing

2013: 46041 missing

2014: 46168 missing

 7 Levels: "1" "2" "3" "4" "5" "6" "7"NA Coding: NA
Field No. 104 "Heating"2009: 32,302 missing

2010: 32,754 missing

2011: 32,911 missing

2012: 33,159 missing

2013: 33,179 missing

2014: 33,282 missing

 

8 Levels "A" "C" "D" "F" "G" "H" "J" "M"

A: Baseboard (1,185); C: Central (5,231); D: Forced air (149,252); F: Floor/wall (24);

G: Gravity (259); H: Heat pump (629); J: Hot water (37,073); M: Radiant (481)

NA Coding: " "
Field No. 150 "Heating Fuel Type"all NA  NA Coding: NA
Field No. 134 "of Plumbing Fixtures"all NA  NA Coding: NA

Attachments: