Meta

Sample

##   permit_value :created_at number month prefix year
## 1         1500  1362414180   7120     6     NE 1984
## 2        54400  1362414180   5402    12     NW 1986
## 3        54400  1362414180   5406    12     NW 1986
## 4         4367  1362414180   1116     8     NE 1985
## 5       120000  1362414180      7     6      W 1984
## 6        38000  1362414180    601     3      E 1983
##   dwelling_units_gained_or_lost :position suffix :updated_at :created_meta
## 1                             0         1     ST  1362414180        701271
## 2                             1         2     ST  1362414180        701271
## 3                             1         3     ST  1362414180        701271
## 4                             0         4     PL  1362414180        701271
## 5                             1         5     ST  1362414180        701271
## 6                             0         6     ST  1362414180        701271
##           res_non fraction how_far_north                            type
## 1     Residential       NA       1098816 Additions, Alterations, Repairs
## 2     Residential       NA       1122444                New Construction
## 3     Residential       NA       1122441                New Construction
## 4     Residential       NA       1129986 Additions, Alterations, Repairs
## 5     Residential       NA        993560                New Construction
## 6 Non-Residential       NA       1072680 Additions, Alterations, Repairs
##           sf_mf :updated_meta :sid day  name how_far_east
## 1            NA        701271    1   6    50      2789883
## 2 Single Family        701271    2   2    85      2748192
## 3 Single Family        701271    3   2    85      2748136
## 4            NA        701271    4   6    97      2769932
## 5 Single Family        701271    5   5   128      2761391
## 6            NA        701271    6  15   1ST      2766749
##                                    :id :meta permit_number
## 1 9C945C78-5D80-4404-A7EC-B31D46A9A5A4  {\n}          7351
## 2 F3ED7E1F-483A-4F4E-9504-16ACDA9C2732  {\n}         26880
## 3 0F7FF572-67CB-4B47-B5A1-0ACE6B4499D2  {\n}         26881
## 4 91B75EC2-ABE8-4B3D-8795-1FA33DCBC25E  {\n}         19723
## 5 871FED3C-9ABD-49EC-8D9A-A6ED54125AFE  {\n}          7262
## 6 604DCBEA-553D-4504-AD6F-390BF1084212  {\n}          3499
##   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":"7120 NE 50 ST","city":"","state":"","zip":""}
## 2 {"address":"5402 NW 85 ST","city":"","state":"","zip":""}
## 3 {"address":"5406 NW 85 ST","city":"","state":"","zip":""}
## 4 {"address":"1116 NE 97 PL","city":"","state":"","zip":""}
## 5    {"address":"7 W 128 ST","city":"","state":"","zip":""}
## 6  {"address":"601 E 1ST 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: fraction, location_1.latitude, location_1.machine_address, location_1.longitude

The following variables are duplicates:

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