Meta

property	value
dataset name	2010-2012 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-2012-Building-Permit-Listing/fx3a-kauu
dataset key	fx3a-kauu
number of records	38602
number of variables	42

Sample

##   council_district permit_value :created_at   school_district number month
## 1                2         3630  1362415850 North Kansas City    908     5
## 2                2          500  1362415850 North Kansas City    908     6
## 3                2        10816  1362415850 North Kansas City   1617     5
## 4                2          500  1362415850 North Kansas City   1704     8
## 5                5         2200  1362415850            Center   1511     2
## 6                5          249  1362415850     Hickman Mills   5604     9
##    county prefix owner_name year dwelling_units_gained_or_lost :position
## 1    Clay     NE         NA 2010                             0         1
## 2    Clay     NE         NA 2012                             0         2
## 3    Clay     NE         NA 2011                             0         3
## 4    Clay     NE         NA 2011                             0         4
## 5 Jackson      E         NA 2012                             0         5
## 6 Jackson      E         NA 2012                             0         6
##   suffix    pin :updated_at :created_meta     res_non fraction
## 1     CT 103892  1362415850        701271 Residential     <NA>
## 2     CT 103892  1362415850        701271 Residential     <NA>
## 3     CT 103904  1362415850        701271 Residential     <NA>
## 4     CT 103969  1362415850        701271 Residential     <NA>
## 5     ST 154149  1362415850        701271 Residential     <NA>
## 6     ST  57820  1362415850        701271 Residential     <NA>
##   structure_class how_far_north                            type sf_mf
## 1              97       1131658 Additions, Alterations, Repairs    NA
## 2              97       1131658 Additions, Alterations, Repairs    NA
## 3              97       1131893 Additions, Alterations, Repairs    NA
## 4              97       1132202 Additions, Alterations, Repairs    NA
## 5              97       1011966 Additions, Alterations, Repairs    NA
## 6              97       1011454 Additions, Alterations, Repairs    NA
##   project_description              parcel applicant_representative
## 1       SINGLE FAMILY  CL0991500030750001            BRENDA ZITTEL
## 2       SINGLE FAMILY  CL0991500030750001             MEGAN KAPPLE
## 3       SINGLE FAMILY  CL0991500030570001      EUGENE (GENE) AMICK
## 4       SINGLE FAMILY  CL0991500070270001          PATRICK KOEHLER
## 5       SINGLE FAMILY JA48720018300000000              PAUL MORTON
## 6       SINGLE FAMILY JA49810020800000000             JUANITA FARR
##   :updated_meta :sid day                          applicant_name
## 1        701271    1  26  APEX HEATING AND AIR CONDITIONING INC.
## 2        701271    2  11                        A.B. MAY COMPANY
## 3        701271    3   5 CLIMATE CONTROL HEATING & COOLING, INC.
## 4        701271    4  18                     K & S PLUMBING, LLC
## 5        701271    5  16                 MORTON MECHANICAL, INC.
## 6        701271    6  28             ADT SECURITY SERVICES, INC.
##                                           legal_description
## 1 908 NE 100TH CT               WILLOW PARK 2ND PLAT LOT 50
## 2                                                      <NA>
## 3                                            GIVHAN FELICIA
## 4                                                      <NA>
## 5                                                      <NA>
## 6                                                      <NA>
##                      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      2771259
## 4 Existing One Or Two Family Residence        <NA> 100TH      2772082
## 5 Existing One Or Two Family Residence        <NA> 100TH      2768407
## 6 Existing One Or Two Family Residence        <NA> 100TH      2781944
##                                    :id :meta permit_number
## 1 DC42F91F-C6B1-4B25-B391-578859FCE02B  {\n}     201110970
## 2 090C7210-B48B-4E04-A068-78B884EBFC25  {\n}     201311766
## 3 17C58624-3470-4B09-99C5-91B9968BB274  {\n}     201210162
## 4 6C676AC4-BC96-45EB-B724-B84DD60440B3  {\n}     201214443
## 5 08F891E4-675E-4249-85A9-08E857CD4EC6  {\n}     201221561
## 6 47DA82DA-EA35-41A5-A8C9-394D83234585  {\n}     201316832
##   location_1.latitude location_1.needs_recoding
## 1                  NA                      TRUE
## 2                  NA                      TRUE
## 3                  NA                      TRUE
## 4                  NA                      TRUE
## 5                  NA                      TRUE
## 6                  NA                      TRUE
##                                       location_1.human_address
## 1  {"address":"908 NE 100TH CT","city":"","state":"","zip":""}
## 2  {"address":"908 NE 100TH CT","city":"","state":"","zip":""}
## 3 {"address":"1617 NE 100TH CT","city":"","state":"","zip":""}
## 4 {"address":"1704 NE 100TH CT","city":"","state":"","zip":""}
## 5  {"address":"1511 E 100TH ST","city":"","state":"","zip":""}
## 6  {"address":"5604 E 100TH ST","city":"","state":"","zip":""}
##   location_1.machine_address location_1.longitude
## 1                         NA                   NA
## 2                         NA                   NA
## 3                         NA                   NA
## 4                         NA                   NA
## 5                         NA                   NA
## 6                         NA                   NA

Missing Values

Variables

The following variables are all NA: owner_name, location_1.latitude, location_1.machine_address, location_1.longitude

The following variables are duplicates:

• :created_meta, :updated_meta
• :created_at, :updated_at
• :position, :sid