Meta

Sample

##   :created_at application_permit_number longitude final_date :position
## 1  1451991730                   6511999 -122.3259       <NA>         1
## 2  1451991730                   6512016 -122.3774       <NA>         2
## 3  1451991730                   6481368 -122.3230       <NA>         3
## 4  1451991730                   6512001 -122.3583       <NA>         4
## 5  1451991730                   6510984 -122.3197       <NA>         5
## 6  1451991730                   6511954 -122.3348       <NA>         6
##                 category          issue_date :updated_at :created_meta
## 1             COMMERCIAL                <NA>  1451991730        387110
## 2 SINGLE FAMILY / DUPLEX 2016-01-04T00:00:00  1451991730        387110
## 3             COMMERCIAL                <NA>  1451991730        387110
## 4             COMMERCIAL                <NA>  1451991730        387110
## 5 SINGLE FAMILY / DUPLEX 2016-01-04T00:00:00  1451991730        387110
## 6             COMMERCIAL                <NA>  1451991730        387110
##                       contractor latitude               status
## 1                           <NA> 47.70619 Application Accepted
## 2                           <NA> 47.57761        Permit Issued
## 3     SELLEN CONSTRUCTION CO INC 47.60980 Application Accepted
## 4 BLANKET: 3131 ELLIOTT BUILDING 47.61814 Application Accepted
## 5                           <NA> 47.67204        Permit Issued
## 6 BLANKET: SECURITY PACIFIC BANK 47.60897 Application Accepted
##                                                                                                                                description
## 1                                                                      Shoring and excavation for constuction of parking garage per plan..
## 2                                                           Construct basement alterations to existing single family residence, per (STFI)
## 3 Construct tenant improvements to existing Institution ( Swedish Cancer Institute) on the 3rd and 4th floors for new dumbwaiter, per plan
## 4                                                   Blanket Permit for interior non-structural alterations. floor 4 (Water's Edge tenant).
## 5                                                        Construct front porch alterations to existing single family residence, per (STFI)
## 6                  Blanket Permit for interior non-structural alterations.  Interior tenant improvement of new walls and doors, per plans.
##        work_type              address :updated_meta :sid
## 1    Plan Review 301 NE NORTHGATE WAY        387110    1
## 2 No plan review     2757 36TH AVE SW        387110    2
## 3    Plan Review      1221 MADISON ST        387110    3
## 4    Plan Review     3131 ELLIOTT AVE        387110    4
## 5 No plan review       809 NE 60TH ST        387110    5
## 6    Plan Review         1301 5TH AVE        387110    6
##      application_date     applicant_name     expiration_date   value
## 1 2016-01-04T00:00:00  CELIN, JACQUELINE                <NA> 2308800
## 2 2016-01-04T00:00:00        NAHUM, RICK 2017-07-04T00:00:00   20000
## 3 2016-01-04T00:00:00    HINTHORNE, BRAD                <NA>   45000
## 4 2016-01-04T00:00:00    JENSEN, MARLEEN                <NA>  338866
## 5 2016-01-04T00:00:00 SCHMIDT, CATHERINE 2017-07-04T00:00:00    4500
## 6 2016-01-04T00:00:00       HOWARD, TARA                <NA>  125000
##    permit_type                                  :id :meta
## 1 Construction E371B168-AEE1-4F09-8D84-C5C469FECD7F  <NA>
## 2 Construction 9C19D40C-AD29-41C1-A7C5-AA3554B88BA6  <NA>
## 3 Construction DD3DB1E4-3A9B-40E8-AE2A-AFD96548B00F  <NA>
## 4 Construction 86ECF8AC-2934-4CFA-9759-807F6E518C08  <NA>
## 5 Construction 221BFF38-D9C6-44DC-B79E-311B26CDFA40  <NA>
## 6 Construction 6E517BE7-971F-4A85-84E3-0AD4969AD637  <NA>
##   master_use_permit action_type
## 1           3018742         NEW
## 2                NA     ADD/ALT
## 3                NA     ADD/ALT
## 4                NA       ALTER
## 5                NA     ADD/ALT
## 6                NA       ALTER
##                                permit_and_complaint_status_url.url
## 1 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6511999
## 2 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6512016
## 3 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6481368
## 4 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6512001
## 5 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6510984
## 6 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6511954
##   permit_and_complaint_status_url.description location.latitude
## 1                                          NA          47.70619
## 2                                          NA          47.57761
## 3                                          NA          47.60980
## 4                                          NA          47.61814
## 5                                          NA          47.67204
## 6                                          NA          47.60897
##   location.needs_recoding location.human_address location.machine_address
## 1                   FALSE                     NA                       NA
## 2                   FALSE                     NA                       NA
## 3                   FALSE                     NA                       NA
## 4                   FALSE                     NA                       NA
## 5                   FALSE                     NA                       NA
## 6                   FALSE                     NA                       NA
##   location.longitude
## 1          -122.3259
## 2          -122.3774
## 3          -122.3230
## 4          -122.3583
## 5          -122.3197
## 6          -122.3348

Missing Values

Variables

The following variables are all NA: permit_and_complaint_status_url.description, location.human_address, location.machine_address

The following variables are duplicates:

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