Meta

Sample

##   :created_at application_permit_number longitude          final_date
## 1  1451992044                   6269636 -122.3714 2012-05-17T00:00:00
## 2  1451992044                   6271067 -122.3406                <NA>
## 3  1451992044                   6271066 -122.3152 2011-01-31T00:00:00
## 4  1451992044                   6271026 -122.3475 2011-02-09T00:00:00
## 5  1451992044                   6271020 -122.2915 2011-10-20T00:00:00
## 6  1451992044                   6271006 -122.3541 2012-08-28T00:00:00
##   :position               category          issue_date :updated_at
## 1         1 SINGLE FAMILY / DUPLEX 2011-01-04T00:00:00  1451992044
## 2         2             COMMERCIAL 2011-01-04T00:00:00  1451992044
## 3         3            MULTIFAMILY 2011-01-04T00:00:00  1451992044
## 4         4            MULTIFAMILY 2011-01-04T00:00:00  1451992044
## 5         5 SINGLE FAMILY / DUPLEX 2011-01-04T00:00:00  1451992044
## 6         6 SINGLE FAMILY / DUPLEX 2011-01-04T00:00:00  1451992044
##   :created_meta                 contractor latitude        status
## 1        387110                       <NA> 47.72120 Permit Closed
## 2        387110                       <NA> 47.61304 Permit Closed
## 3        387110                       <NA> 47.65947 Permit Closed
## 4        387110 ROOFING SPECIALISTS NW INC 47.68075 Permit Closed
## 5        387110                       <NA> 47.61958 Permit Closed
## 6        387110 CARLISLE CLASSIC HOMES LLC 47.63419 Permit Closed
##                                                                                                                                                                                                         description
## 1                                                                                                   Construct interior non-structural alterations to existing single family residence, subject to field inspection.
## 2 CLOSED AS INCOMPLETE - EXPIRED PERMIT. Construct interior, non-structural alterationsto remove non structural interior walls within existing office space, per floor plan and subject to field inspection (STFI),
## 3                         Complete work begun under Permit 6170791: (Non structural alterations to basement kitchen of existing boarding house to create bedroom per floor plan subject to field inspection, STFI).
## 4                                                 Alterations to replace exterior deck posts (2) and beam (1) in kind to repair rot at northeasterly corner of existing condo building, subject to field inspection
## 5               Remove and replace existing deck and front porch and steps, and interior alterations to 2nd and 3rd level of existing single family residence, per plot plan and subject to field inspection, STFI.
## 6                                                                                                       Replace wood decking on front porch and replace wood steps with concrete steps, subject to field inspection
##        work_type           address :updated_meta :sid    application_date
## 1 No plan review 12558 12TH AVE NW        387110    1 2011-01-04T00:00:00
## 2 No plan review      2001 4TH AVE        387110    2 2011-01-04T00:00:00
## 3 No plan review  4238 12TH AVE NE        387110    3 2011-01-04T00:00:00
## 4 No plan review 7111 LINDEN AVE N        387110    4 2011-01-04T00:00:00
## 5 No plan review    121 32ND AVE E        387110    5 2011-01-04T00:00:00
## 6 No plan review 1702 WARREN AVE N        387110    6 2011-01-04T00:00:00
##         applicant_name     expiration_date value  permit_type
## 1       PARISH, DIANNA 2012-07-04T00:00:00 12000 Construction
## 2   GOODFELLOW, GEORGE 2012-07-04T00:00:00 10000 Construction
## 3 SABAH, SHARIFAH NOOR 2012-07-04T00:00:00  3000 Construction
## 4           HILL, DAVE 2012-07-04T00:00:00  1000 Construction
## 5       SCHLITT, GRACE 2012-07-04T00:00:00 60000 Construction
## 6         BARNETT, AMY 2014-01-04T00:00:00 10000 Construction
##                                    :id :meta master_use_permit action_type
## 1 51135EA6-20E4-4DED-B748-F9C9F8F91C3C  <NA>                NA     ADD/ALT
## 2 381DB944-D21A-4DB3-B145-B3D5CBD842B1  <NA>                NA     ADD/ALT
## 3 6EC2EC64-8889-4D38-AB1D-3B00C3D57C70  <NA>                NA     ADD/ALT
## 4 10CC33F9-2C98-4617-A0FF-224194F5A4CF  <NA>                NA     ADD/ALT
## 5 10C5A87B-0215-43E5-A413-573316CA3EE0  <NA>                NA     ADD/ALT
## 6 AEBD6159-EAA1-4D40-9B77-7EFD13937ACA  <NA>                NA     ADD/ALT
##                                permit_and_complaint_status_url.url
## 1 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6269636
## 2 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6271067
## 3 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6271066
## 4 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6271026
## 5 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6271020
## 6 http://web6.seattle.gov/dpd/PermitStatus/Project.aspx?id=6271006
##   permit_and_complaint_status_url.description location.latitude
## 1                                          NA          47.72120
## 2                                          NA          47.61304
## 3                                          NA          47.65947
## 4                                          NA          47.68075
## 5                                          NA          47.61958
## 6                                          NA          47.63419
##   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.3714
## 2          -122.3406
## 3          -122.3152
## 4          -122.3475
## 5          -122.2915
## 6          -122.3541

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:

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