Meta

property	value
dataset name	2010-2013 Building Permit Listing
data source	State of Missouri
data level	City
description	listing of building permits for new construction, demolition and additions/alterations/repairs and their characteristics
permalink	https://data.kcmo.org/Construction/2010-2013-Building-Permit-Listing/vcj3-ncb3
dataset key	vcj3-ncb3
number of records	52508
number of variables	42

Sample

##   council_district permit_value :created_at   school_district number month
## 1                2         3630  1402432974 North Kansas City    908     5
## 2                2          500  1402432974 North Kansas City    908     6
## 3                2         7752  1402432974 NORTH KANSAS CITY   1603    11
## 4                2         1000  1402432974 North Kansas City   1605     3
## 5                2         3846  1402432974 North Kansas City   1611     3
## 6                2        10816  1402432974 North Kansas City   1617     5
##   county prefix                       owner_name year
## 1   Clay     NE                             <NA> 2010
## 2   Clay     NE                             <NA> 2012
## 3   Clay     NE     KOLLER DONALD D & GRETCHEN A 2013
## 4   Clay     NE SMYTH DONALD CRAIG & CHRISTINA M 2013
## 5   Clay     NE                  NEHER STANLEY V 2013
## 6   Clay     NE                             <NA> 2011
##   dwelling_units_gained_or_lost :position suffix    pin :updated_at
## 1                             0         1     CT 103892  1402434307
## 2                             0         2     CT 103892  1402433474
## 3                             0         3     CT 104149  1402432974
## 4                             0         4     CT 104148  1402432974
## 5                             0         5     CT 103788  1402432974
## 6                             0         6     CT 103904  1402433430
##   :created_meta     res_non fraction structure_class how_far_north
## 1        701271 Residential     <NA>              97       1131658
## 2        701271 Residential     <NA>              97       1131658
## 3        701271 Residential     <NA>              97       1131673
## 4        701271 Residential     <NA>              97       1131686
## 5        701271 Residential     <NA>              97       1131826
## 6        701271 Residential     <NA>              97       1131893
##                              type sf_mf       project_description
## 1 Additions, Alterations, Repairs    NA             SINGLE FAMILY
## 2 Additions, Alterations, Repairs    NA             SINGLE FAMILY
## 3 Additions, Alterations, Repairs    NA             SINGLE FAMILY
## 4 Additions, Alterations, Repairs    NA             SINGLE FAMILY
## 5 Additions, Alterations, Repairs    NA SINGLE FAMILY/ MECHANICAL
## 6 Additions, Alterations, Repairs    NA             SINGLE FAMILY
##               parcel applicant_representative :updated_meta :sid day
## 1 CL0991500030750001            BRENDA ZITTEL        701271    1  26
## 2 CL0991500030750001             MEGAN KAPPLE        701271    2  11
## 3 CL0991500030510001               JOE BRANDT        701271    3  25
## 4 CL0991500030520001              PATRICK LEE        701271    4  14
## 5 CL0991500030550001       PERMIT SERVICE INC        701271    5  14
## 6 CL0991500030570001      EUGENE (GENE) AMICK        701271    6   5
##                            applicant_name
## 1  APEX HEATING AND AIR CONDITIONING INC.
## 2                        A.B. MAY COMPANY
## 3         ZIPCO CLEANIONG AND RESTORATION
## 4           METRO MECHANICAL SERVICES INC
## 5     ANTHONY PLUMBING, HEATING & COOLING
## 6 CLIMATE CONTROL HEATING & COOLING, INC.
##                                            legal_description
## 1  908 NE 100TH CT               WILLOW PARK 2ND PLAT LOT 50
## 2                                                       <NA>
## 3 1603 NE 100TH CT              WILLOW WOODS 1ST PLAT LOT 45
## 4 1605 NE 100TH CT              WILLOW WOODS 1ST PLAT LOT 44
## 5 1611 NE 100TH CT              WILLOW WOODS 1ST PLAT LOT 41
## 6                                             GIVHAN FELICIA
##                      class_description subdivision  name how_far_east
## 1 Existing One Or Two Family Residence        <NA> 100TH      2770140
## 2 Existing One Or Two Family Residence        <NA> 100TH      2770140
## 3 Existing One Or Two Family Residence        <NA> 100TH      2770727
## 4 Existing One Or Two Family Residence        <NA> 100TH      2770829
## 5 Existing One Or Two Family Residence        <NA> 100TH      2771067
## 6 Existing One Or Two Family Residence        <NA> 100TH      2771259
##                                    :id :meta permit_number
## 1 FDE86284-3AB0-49D4-851D-1AED5B1416C0  {\n}     201110970
## 2 414E759E-516F-4499-BA6F-EE6B6E83CA37  {\n}     201311766
## 3 90A07D7D-0235-4850-962D-AD619AB14593  {\n}     201419459
## 4 54ECF48C-2233-42AD-AC16-E9CF032A038E  {\n}     201323288
## 5 FF90B5D5-0B4F-4C7E-938E-B5424DADECED  {\n}     201323270
## 6 3845F68A-51B5-4F39-995D-6FF6EC117889  {\n}     201210162
##   location_1.latitude location_1.needs_recoding
## 1   39.52368635500045                     FALSE
## 2   39.52368635500045                     FALSE
## 3                <NA>                      TRUE
## 4                <NA>                      TRUE
## 5                <NA>                      TRUE
## 6   39.52368635500045                     FALSE
##                                       location_1.human_address
## 1  {"address":"908 NE 100TH CT","city":"","state":"","zip":""}
## 2  {"address":"908 NE 100TH CT","city":"","state":"","zip":""}
## 3                 {"address":"","city":"","state":"","zip":""}
## 4                 {"address":"","city":"","state":"","zip":""}
## 5                 {"address":"","city":"","state":"","zip":""}
## 6 {"address":"1617 NE 100TH CT","city":"","state":"","zip":""}
##   location_1.machine_address location_1.longitude
## 1                         NA   -99.11415045099966
## 2                         NA   -99.11415045099966
## 3                         NA                 <NA>
## 4                         NA                 <NA>
## 5                         NA                 <NA>
## 6                         NA   -99.11415045099966

Missing Values

Variables

The following variables are all NA: location_1.machine_address

The following variables are duplicates:

• :position, :sid
• :created_meta, :updated_meta