Meta

Sample

##   :created_at
## 1  1451733094
## 2  1451733094
## 3  1451733094
## 4  1451733094
## 5  1451733094
## 6  1451733094
##                                                                                                                                                                                       job_description
## 1 To construct interior alterations to an existing Semi-Detached House, Basement development (NOT to be used as an additional Dwelling).1 bedroom, 1 bathroom, living room, mechanical room, storage,
## 2                                                                                        To construct a Single Detached House with front veranda, fireplace, and rear uncovered deck (3.51m x 3.05m).
## 3                                                                                                                                  To construct a Single Detached House with a front attached Garage.
## 4                                                                                                                                          To construct a Single Detached House with a front veranda.
## 5                                        To construct a Single Detached House with a front attached Garage, front covered balcony (2.44m x 1.37m), fireplace and rear uncovered deck (3.05m x 3.96m).
## 6                                                                                                     To construct an rear uncovered deck (4.23m x 2.41m @1.25 in Height) (existing without permits).
##   year :position neighbourhood          issue_date
## 1 2015    342118    RUTHERFORD 2015-12-31T00:00:00
## 2 2015    342105        LAUREL 2015-12-31T00:00:00
## 3 2015    342106     AMBLESIDE 2015-12-31T00:00:00
## 4 2015    342107    SUMMERSIDE 2015-12-31T00:00:00
## 5 2015    342108        LAUREL 2015-12-31T00:00:00
## 6 2015    342109     GREENVIEW 2015-12-31T00:00:00
##             legal_description :updated_at month_number :created_meta
## 1 Plan 0620257 Blk 21 Lot 18B  1451733094           12        393213
## 2   Plan 1425229 Blk 2 Lot 53  1451733094           12        393213
## 3  Plan 1424369 Blk 21 Lot 48  1451733094           12        393213
## 4 Plan 1024850 Blk 26 Lot 103  1451733094           12        393213
## 5   Plan 1425229 Blk 5 Lot 37  1451733094           12        393213
## 6   Plan 7721465 Blk 2 Lot 64  1451733094           12        393213
##                                    :id units_added latitude floor_area
## 1 40D4B809-2D01-47F2-94FD-2B3FADC6214C           0 53.41076        375
## 2 B3A0AF91-AD1D-4424-99C5-5A7F41284604           1 53.45107       1546
## 3 E5CD82E5-604C-463B-8404-D7B312CDD42F           1 53.43107       2734
## 4 9F5EFECC-5FEC-4C52-848D-7B31E0DD5C35           1 53.41806       1824
## 5 ADC5CC4E-40CB-48EE-9FBF-4DE3473F81B7           1 53.45210       2727
## 6 748CD34A-8BF6-48D9-BDF7-6F9BEFCC80CD           0 53.47606         NA
##                   work_type   zoning                               address
## 1 (03) Interior Alterations RA7, RF4                  11807 - 21 AVENUE SW
## 2                  (01) New      RPL                   2643 - 21 AVENUE NW
## 3                  (01) New      RSL                2026 - AINSLIE LINK SW
## 4                  (01) New      RPL 7820 - SUMMERSIDE GRANDE BOULEVARD SW
## 5                  (01) New      RSL                   2116 - 22 STREET NW
## 6        (03) Deck Attached      RF1                   5512 - 40 AVENUE NW
##   :updated_meta   :sid count neighbourhood_numberr         permit_date
## 1        393213 342118     1                  5454 2015-12-31T00:00:00
## 2        393213 342105     1                  6444 2015-12-31T00:00:00
## 3        393213 342106     1                  5505 2015-12-31T00:00:00
## 4        393213 342107     1                  6213 2015-12-31T00:00:00
## 5        393213 342108     1                  6444 2015-12-31T00:00:00
## 6        393213 342109     1                  6280 2015-12-31T00:00:00
##   longitude construction_value               building_type :meta
## 1 -113.5295              15000   Semi-Detached House (210)  <NA>
## 2 -113.3800             293740 Single Detached House (110)  <NA>
## 3 -113.6022             519460 Single Detached House (110)  <NA>
## 4 -113.4577             346560 Single Detached House (110)  <NA>
## 5 -113.3747             518130 Single Detached House (110)  <NA>
## 6 -113.4214               3000          Single House (110)  <NA>
##                   job_category permit_number location.latitude
## 1 Other Miscellaneous Building 185157437-002          53.41076
## 2            House Combination 182683588-001          53.45107
## 3            House Combination 182609918-001          53.43107
## 4            House Combination 183862132-001          53.41806
## 5            House Combination 181980187-001          53.45210
## 6   Uncovered Deck Combination 172387903-002          53.47606
##   location.needs_recoding                       location.human_address
## 1                   FALSE {"address":"","city":"","state":"","zip":""}
## 2                   FALSE {"address":"","city":"","state":"","zip":""}
## 3                   FALSE {"address":"","city":"","state":"","zip":""}
## 4                   FALSE {"address":"","city":"","state":"","zip":""}
## 5                   FALSE {"address":"","city":"","state":"","zip":""}
## 6                   FALSE {"address":"","city":"","state":"","zip":""}
##   location.machine_address location.longitude
## 1                       NA          -113.5295
## 2                       NA          -113.3800
## 3                       NA          -113.6022
## 4                       NA          -113.4577
## 5                       NA          -113.3747
## 6                       NA          -113.4214

Missing Values

Variables

The following variables are all NA: location.machine_address

The following variables are duplicates:

• :created_meta, :updated_meta
• longitude, location.longitude
• :position, :sid
• issue_date, permit_date
• latitude, location.latitude
• :created_at, :updated_at