This data as json, CSV (advanced)
| Link | rowid | rowid | CaseID | Opened | Closed | Updated | Status | Status_Notes | Responsible_Agency | Category | Request_Type | Request_Details | Address | Street | Supervisor_District ▼ | Neighborhood | Police_District | Latitude | Longitude | Point | Source | Media_URL | SF_Find_Neighborhoods | Current_Police_Districts | Current_Supervisor_Districts | Analysis_Neighborhoods | :@computed_region_rxqg_mtj9 | :@computed_region_yftq_j783 | :@computed_region_jx4q_fizf | :@computed_region_bh8s_q3mv | :@computed_region_p5aj_wyqh | :@computed_region_fyvs_ahh9 | :@computed_region_f58d_8dbm | :@computed_region_9dfj_4gjx | :@computed_region_vtsz_7cme | :@computed_region_n4xg_c4py | :@computed_region_sruu_94in | :@computed_region_4isq_27mq | :@computed_region_viu7_rrfi | :@computed_region_fcz8_est8 | :@computed_region_pigm_ib2e | :@computed_region_9jxd_iqea | :@computed_region_6ezc_tdp2 | :@computed_region_6pnf_4xz7 | :@computed_region_h4ep_8xdi | :@computed_region_nqbw_i6c3 | :@computed_region_2dwj_jsy4 | :@computed_region_y6ts_4iup | Neighborhoods |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8306 | 8306 | 8306 | 7492208 | 2017-08-11T15:52:58 | 2017-08-26T11:25:38 | 2017-08-26T11:25:38 | Closed 2 | trees will be pruned according to block pruning schedule. thanks for your patience. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 13248 | 13248 | 13248 | 4182619 | 2014-11-06T10:57:17 | 2014-11-25T02:58:56 | 2014-11-25T02:58:56 | Closed 2 | resolved: scheduled for removal | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 13542 | 13542 | 13542 | 4169880 | 2014-11-02T17:40:01 | 2014-11-29T10:07:40 | 2014-11-29T10:07:40 | Closed 2 | resolved: | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 13949 | 13949 | 13949 | 11427351 | 2019-09-17T10:48:00 | 2019-10-01T08:19:31 | 2019-10-01T08:19:31 | Closed 2 | There is no immediate safety issue with your tree so it will be serviced in the next few years. The City has taken over responsibility for the care and maintenance of street trees. Through a program called StreetTreeSF, trees that are in the worst condition are being addressed first and every tree will be addressed following a maintenance schedule that is focused on public safety. Thank you for your patience. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | 12 CLEMENT ST, SAN FRANCISCO, CA, 94118 | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 14049 | 14049 | 14049 | 5674640 | 2016-03-17T11:39:27 | 2016-05-27T02:38:00 | 2016-05-27T02:38:00 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 19133 | 19133 | 19133 | 5659443 | 2016-03-12T17:37:50 | 2016-04-19T20:25:52 | 2016-04-19T20:25:52 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Integrated Agency | |||||||||||||||||||||||||||||||||
| 19757 | 19757 | 19757 | 5653469 | 2016-03-10T16:32:58 | 2016-06-16T10:31:19 | 2016-06-16T10:31:19 | Closed 2 | called LP for debris sweeper could not get. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 20043 | 20043 | 20043 | 5651319 | 2016-03-10T09:12:49 | 2016-04-26T02:42:42 | 2016-04-26T02:42:42 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 22693 | 22693 | 22693 | 4050214 | 2014-09-26T10:18:09 | 2014-09-26T10:47:16 | 2014-09-26T10:47:16 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 54542 | 54542 | 54542 | 11470538 | 2019-09-26T16:29:00 | 2019-09-26T16:40:03 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 87432 | 87432 | 87432 | 9389325 | 2018-08-11T12:22:00 | 2019-04-05T16:15:30 | 2019-04-05T16:15:30 | Closed 2 | contractor recently pruned this block | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 88272 | 88272 | 88272 | 8248151 | 2017-11-09T13:17:00 | 2017-11-10T07:11:00 | 2017-11-10T07:11:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 94620 | 94620 | 94620 | 8136795 | 2017-10-13T11:56:00 | 2017-12-08T15:10:05 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 95641 | 95641 | 95641 | 3812595 | 2014-07-09T14:44:09 | 2014-08-14T06:45:00 | 2014-08-14T06:45:00 | Closed 2 | resolved: Cleared stop sign | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 103981 | 103981 | 103981 | 9146100 | 2018-06-16T17:14:00 | 2018-09-23T09:14:45 | 2018-09-23T09:14:45 | Closed 2 | removed | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 104408 | 104408 | 104408 | 9001048 | 2018-05-14T19:01:00 | 2018-05-15T07:34:37 | 2018-05-15T07:34:37 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Sprinkler_system_issues | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 104425 | 104425 | 104425 | 870720 | 2011-04-27T14:41:27 | 2011-05-06T14:06:02 | 2011-05-06T14:06:02 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 105593 | 105593 | 105593 | 8606292 | 2018-02-07T17:34:00 | 2018-02-07T17:40:06 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 105852 | 105852 | 105852 | 1048689 | 2012-01-22T12:03:52 | 2012-01-25T15:07:02 | 2012-01-25T15:07:02 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 106724 | 106724 | 106724 | 8384888 | 2017-12-13T22:04:00 | 2017-12-15T10:55:12 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Sprinkler_system_issues | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 106929 | 106929 | 106929 | 2990196 | 2013-10-26T11:58:57 | 2013-10-26T13:16:52 | 2013-10-26T13:16:52 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 108325 | 108325 | 108325 | 2068657 | 2013-02-28T07:01:30 | 2013-04-05T12:47:14 | 2013-04-05T12:47:14 | Closed 2 | cancelled: | DPW BSSR Queue 24 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Integrated Agency | ||||||||||||||||||||||||||||||||
| 109427 | 109427 | 109427 | 980260 | 2011-10-10T09:10:49 | 2013-11-01T13:19:38 | 2013-11-01T13:19:38 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 111644 | 111644 | 111644 | 3891095 | 2014-08-05T17:36:27 | 2014-08-14T05:35:42 | 2014-08-14T05:35:42 | Closed 2 | resolved: Completed | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 111647 | 111647 | 111647 | 3890718 | 2014-08-05T15:11:41 | 2014-08-05T03:52:00 | 2014-08-05T03:52:00 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 111666 | 111666 | 111666 | 3887728 | 2014-08-04T16:47:42 | 2014-08-18T01:43:34 | 2014-08-18T01:43:34 | Closed 2 | resolved: 10-98 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 112956 | 112956 | 112956 | 3643894 | 2014-05-14T23:22:55 | 2014-05-20T03:11:39 | 2014-05-20T03:11:39 | Closed 2 | resolved: all private not dpw maintained | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 113808 | 113808 | 113808 | 3482589 | 2014-03-23T18:51:32 | 2014-04-27T07:52:12 | 2014-04-27T07:52:12 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_street_lights | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 114376 | 114376 | 114376 | 3363375 | 2014-02-13T08:22:58 | 2014-03-07T09:52:20 | 2014-03-07T09:52:20 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 119268 | 119268 | 119268 | 5103070 | 2015-09-16T13:05:01 | 2015-09-17T04:05:41 | 2015-09-17T04:05:41 | Closed 2 | resolved: duplicate | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 122551 | 122551 | 122551 | 4628547 | 2015-04-01T17:52:53 | 2015-06-29T09:09:51 | 2015-06-29T09:09:51 | Closed 2 | cancelled: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Integrated Agency | ||||||||||||||||||||||||||||||||
| 125886 | 125886 | 125886 | 6018676 | 2016-06-25T13:58:20 | 2016-08-22T23:22:19 | 2016-08-22T23:22:19 | Closed 2 | Request Letter Sent. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 127658 | 127658 | 127658 | 5837044 | 2016-05-05T22:51:48 | 2016-05-10T09:47:00 | 2016-05-10T09:47:00 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 128147 | 128147 | 128147 | 5785216 | 2016-04-21T09:07:02 | 2016-08-22T23:11:40 | 2016-08-22T23:11:40 | Closed 2 | can we have the address? not city maintained | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 129536 | 129536 | 129536 | 6016927 | 2016-06-24T18:30:35 | 2016-08-22T23:22:52 | 2016-08-22T23:22:52 | Closed 2 | Request Letter Sent. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 129626 | 129626 | 129626 | 5575749 | 2016-02-17T10:35:21 | 2016-02-17T11:52:51 | 2016-02-17T11:52:51 | Closed 2 | Case Resolved: sent via direct data base | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 131754 | 131754 | 131754 | 5176596 | 2015-10-09T20:06:09 | 2016-01-16T02:33:00 | 2016-01-16T02:33:00 | Closed 2 | resolved: area was inspected and found to be cleared. | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Vacant_lot_weeding | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 131885 | 131885 | 131885 | 4937178 | 2015-07-24T14:31:55 | 2016-06-13T12:41:52 | 2016-06-13T12:41:52 | Closed 2 | no bin visable during inspection on Monday | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Sewer_damage_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 132001 | 132001 | 132001 | 4572450 | 2015-03-13T13:08:21 | 2016-06-20T07:26:17 | 2016-06-20T07:26:17 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 132250 | 132250 | 132250 | 3730334 | 2014-06-11T09:46:00 | 2016-06-20T08:11:48 | 2016-06-20T08:11:48 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 132256 | 132256 | 132256 | 5727269 | 2016-04-04T09:39:15 | 2016-04-04T09:39:15 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 132261 | 132261 | 132261 | 3537207 | 2014-04-10T08:12:26 | 2016-06-16T15:13:40 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 132263 | 132263 | 132263 | 3467115 | 2014-03-18T16:14:40 | 2016-06-13T12:00:00 | 2016-06-13T12:00:00 | Closed 2 | cleaned | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 132519 | 132519 | 132519 | 922607 | 2011-07-18T13:44:07 | 2016-10-07T01:13:52 | 2016-10-07T01:13:52 | Closed 2 | OVER GROWN VEGETATION, near pole. - posted, took photos;NTR # 961782, | DPW BSM Queue 3 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 133277 | 133277 | 133277 | 5389897 | 2015-12-20T07:53:12 | 2015-12-22T11:58:47 | 2015-12-22T11:58:47 | Closed 2 | resolved: Request Letter Sent. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 134787 | 134787 | 134787 | 5218893 | 2015-10-23T15:19:06 | 2015-10-27T12:35:14 | 2015-10-27T12:35:14 | Closed 2 | resolved: ??? no falling tree here | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 135774 | 135774 | 135774 | 4387002 | 2015-01-12T15:01:45 | 2016-08-17T15:25:34 | 2016-08-17T15:25:34 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 136695 | 136695 | 136695 | 5034395 | 2015-08-25T20:03:06 | 2015-08-28T08:33:05 | 2015-08-28T08:33:05 | Closed 2 | resolved: no acurpucturist at Valencia and Duboce. Need exact address. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 136751 | 136751 | 136751 | 5027821 | 2015-08-24T08:22:53 | 2015-08-24T09:13:56 | 2015-08-24T09:13:56 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 136974 | 136974 | 136974 | 5006089 | 2015-08-17T11:26:36 | 2015-08-21T02:12:06 | 2015-08-21T02:12:06 | Closed 2 | resolved: I emailed the caller. This is a private tree in a backyard. I gave her several ideas on how to deal with the issue | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 137122 | 137122 | 137122 | 4991139 | 2015-08-12T09:07:22 | 2015-08-25T02:40:00 | 2015-08-25T02:40:00 | Closed 2 | resolved: | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 137467 | 137467 | 137467 | 4958122 | 2015-07-31T19:09:48 | 2015-08-20T08:29:51 | 2015-08-20T08:29:51 | Closed 2 | resolved: problem not found. there is a damaged branch/stub left on tree 3 ifo 444 wash. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 137752 | 137752 | 137752 | 4932231 | 2015-07-22T20:38:06 | 2015-08-04T01:55:29 | 2015-08-04T01:55:29 | Closed 2 | cancelled: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Integrated Agency | ||||||||||||||||||||||||||||||||
| 140878 | 140878 | 140878 | 10499352 | 2019-02-17T10:42:00 | 2019-02-17T11:15:06 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 143480 | 143480 | 143480 | 4466410 | 2015-02-06T13:30:25 | 2015-02-09T09:53:26 | 2015-02-09T09:53:26 | Closed 2 | resolved: Completed, Niu | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Integrated Agency | ||||||||||||||||||||||||||||||||
| 143606 | 143606 | 143606 | 8947708 | 2018-05-02T10:34:00 | 2018-10-23T11:18:15 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 144257 | 144257 | 144257 | 4406708 | 2015-01-19T11:23:54 | 2015-01-19T11:23:54 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 145034 | 145034 | 145034 | 4311252 | 2014-12-17T10:58:33 | 2015-05-15T03:21:18 | 2015-05-15T03:21:18 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 146534 | 146534 | 146534 | 3571454 | 2014-04-21T07:46:51 | 2014-04-23T09:16:33 | 2014-04-23T09:16:33 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 146598 | 146598 | 146598 | 3540612 | 2014-04-11T08:47:13 | 2014-05-28T11:03:43 | 2014-05-28T11:03:43 | Closed 2 | resolved: need specific address | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 146642 | 146642 | 146642 | 3522950 | 2014-04-05T14:38:17 | 2014-04-06T07:20:43 | 2014-04-06T07:20:43 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 147510 | 147510 | 147510 | 3284434 | 2014-01-18T09:31:04 | 2014-01-21T10:03:48 | Open 1 | open | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 147575 | 147575 | 147575 | 3268801 | 2014-01-14T08:11:59 | 2014-01-14T10:17:53 | 2014-01-14T10:17:53 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 147761 | 147761 | 147761 | 9251895 | 2018-07-11T09:32:00 | 2018-07-11T09:47:55 | Open 1 | open | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 147846 | 147846 | 147846 | 2783366 | 2013-09-03T11:58:29 | 2014-04-10T13:21:04 | 2014-04-10T13:21:04 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 147870 | 147870 | 147870 | 2695859 | 2013-08-09T11:24:28 | 2014-02-09T05:12:19 | 2014-02-09T05:12:19 | Closed 2 | resolved: Found 500 square feet of damaged/uneven sidewalk. - NTR # 993818, | DPW BSM Queue 3 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 147908 | 147908 | 147908 | 2148862 | 2013-03-20T10:40:41 | 2014-10-10T11:22:27 | 2014-10-10T11:22:27 | Closed 2 | resolved: No issues found. the sidewalk was accessible at this block | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 148087 | 148087 | 148087 | 1116701 | 2012-05-02T15:21:01 | 2014-03-07T03:33:08 | 2014-03-07T03:33:08 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 148129 | 148129 | 148129 | 1012357 | 2011-11-28T16:19:15 | 2014-07-30T02:31:30 | 2014-07-30T02:31:30 | Closed 2 | resolved: tree has been replaced. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damage_vandalism | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 148130 | 148130 | 148130 | 961430 | 2011-09-13T12:26:23 | 2014-05-20T01:32:26 | 2014-05-20T01:32:26 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 148137 | 148137 | 148137 | 864155 | 2011-04-17T18:47:31 | 2014-07-31T09:55:08 | 2014-07-31T09:55:08 | Closed 2 | resolved: tree has been replaced. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 149475 | 149475 | 149475 | 3063023 | 2013-11-14T10:11:11 | 2013-12-07T15:19:40 | 2013-12-07T15:19:40 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Sprinkler_system_issues | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 149678 | 149678 | 149678 | 2985448 | 2013-10-25T08:45:49 | 2013-10-31T11:24:28 | 2013-10-31T11:24:28 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Other_enter_additional_details_below | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 150253 | 150253 | 150253 | 2805790 | 2013-09-09T11:21:23 | 2013-11-13T12:20:18 | 2013-11-13T12:20:18 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 150635 | 150635 | 150635 | 2644890 | 2013-07-26T12:45:19 | 2013-07-26T15:03:33 | 2013-07-26T15:03:33 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 150949 | 150949 | 150949 | 2458907 | 2013-06-06T15:06:27 | 2013-10-03T16:18:32 | 2013-10-03T16:18:32 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 151191 | 151191 | 151191 | 2279984 | 2013-04-23T15:19:36 | 2013-09-23T09:18:57 | 2013-09-23T09:18:57 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 151895 | 151895 | 151895 | 1765166 | 2012-12-07T09:27:21 | 2012-12-11T09:24:37 | 2012-12-11T09:24:37 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | ||||||||||||||||||||||||||||||||
| 151911 | 151911 | 151911 | 1739287 | 2012-11-30T07:22:47 | 2012-11-30T15:17:11 | 2012-11-30T15:17:11 | Closed 2 | resolved: | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 151996 | 151996 | 151996 | 8053291 | 2017-09-22T13:37:00 | 2018-02-13T10:44:14 | 2018-02-13T10:44:14 | Closed 2 | Please check the irrigation at this site. | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 155013 | 155013 | 155013 | 1031899 | 2011-12-29T09:59:55 | 2012-01-25T18:12:01 | 2012-01-25T18:12:01 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 156548 | 156548 | 156548 | 846507 | 2011-03-21T11:03:36 | 2012-04-20T18:27:21 | 2012-04-20T18:27:21 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_traffic_signal | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 161325 | 161325 | 161325 | 1014851 | 2011-12-01T17:14:05 | 2011-12-05T06:07:14 | 2011-12-05T06:07:14 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 161434 | 161434 | 161434 | 985153 | 2011-10-17T11:44:19 | 2011-12-12T11:07:02 | 2011-12-12T11:07:02 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 161463 | 161463 | 161463 | 980880 | 2011-10-11T09:50:27 | 2011-10-11T11:10:45 | 2011-10-11T11:10:45 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 162563 | 162563 | 162563 | 936726 | 2011-08-08T14:08:01 | 2011-08-15T11:06:04 | 2011-08-15T11:06:04 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 162871 | 162871 | 162871 | 886510 | 2011-05-23T07:33:30 | 2011-05-25T14:06:04 | 2011-05-25T14:06:04 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 164303 | 164303 | 164303 | 851861 | 2011-03-29T14:13:46 | 2011-08-19T16:10:43 | 2011-08-19T16:10:43 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 164460 | 164460 | 164460 | 833217 | 2011-02-27T13:28:02 | 2011-03-26T06:06:00 | 2011-03-26T06:06:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Vacant_lot_weeding | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 164540 | 164540 | 164540 | 821337 | 2011-02-07T11:45:24 | 2011-05-09T15:05:59 | 2011-05-09T15:05:59 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Web | |||||||||||||||||||||||||||||||||
| 181570 | 181570 | 181570 | 7019672 | 2017-04-07T02:18:25 | 2017-04-12T11:10:30 | 2017-04-12T11:10:30 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 186979 | 186979 | 186979 | 9072129 | 2018-05-30T17:59:00 | 2018-05-31T06:23:00 | 2018-05-31T06:23:00 | Closed 2 | RPD Park Service Area 1 Queue 9 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 218582 | 218582 | 218582 | 9194741 | 2018-06-27T16:06:00 | 2018-06-28T07:00:00 | 2018-06-28T07:00:00 | Closed 2 | Your watering request has been received. Sunset Blvd landscapes and aprons are not currently on a watering schedule. Thank you. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 274690 | 274690 | 274690 | 9105825 | 2018-06-07T10:43:00 | 2018-12-24T07:56:00 | 2018-12-24T07:56:00 | Closed 2 | Notes:from CMMS: . BUF Action:Remove Tree. date completed - 12/24/2018. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 306457 | 306457 | 306457 | 9504038 | 2018-09-06T12:07:00 | 2019-05-06T00:00:00 | 2019-05-06T00:00:00 | Closed 2 | Notes:not replaceable, too close to light pole. tree has 80 percent canopy loss, large cavity in trunk 1 ft deep, 2ft tall, . BUF Action:Inspect. date completed - 5/6/2019. Notes:tree has 90 percent canopy loss, almost covered completely in ivy, hanging over busy sidewalk. . BUF Action:Inspect. date completed - 5/6/2019. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 310652 | 310652 | 310652 | 9519523 | 2018-09-10T10:11:00 | 2018-09-10T10:12:00 | 2018-09-10T10:12:00 | Closed 2 | no eform | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Sewer_damage_tree_roots | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 340908 | 340908 | 340908 | 9484314 | 2018-09-01T17:01:16 | 2018-09-13T12:15:54 | 2018-09-13T12:15:54 | Closed 2 | duplicate | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | Not associated with a specific address | 37.801436666667 | -122.381216666667 | POINT (-122.38121667 37.80143667) | Mobile/Open311 | http://mobile311.sfgov.org/reports/9484314/photos | |||||||||||||||||||||||||||||||
| 429523 | 429523 | 429523 | 9852820 | 2018-11-26T13:05:00 | 2019-04-22T13:10:19 | 2019-04-22T13:10:19 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | |||||||||||||||||||||||||||||||||
| 468557 | 468557 | 468557 | 9852868 | 2018-11-26T13:10:00 | 2019-03-11T15:06:49 | 2019-03-11T15:06:49 | Closed 2 | StreetTreeSF went into effect July 1, 2017. Since then, we have begun tree maintenance work throughout the City, starting with the "worst first". These are street trees and sidewalks that pose a safety risk and are located near bus stops, schools and senior centers. Crews also continue to concentrate their efforts on emergency work, such as fallen limbs, pedestrian and visibility obstructions and damaged trees during storm season that pose safety hazards. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone | ||||||||||||||||||||||||||||||||
| 480629 | 480629 | 480629 | 10281199 | 2008-09-14T01:28:47 | 2008-09-14T06:07:51 | 2008-09-14T06:07:51 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | Not associated with a specific address | 0.0 | 0.0 | POINT (0 0) | Phone |
JSON shape: default, array, newline-delimited
CREATE TABLE "calls" (
"rowid" INTEGER,
"CaseID" INTEGER,
"Opened" TEXT,
"Closed" REAL,
"Updated" TEXT,
"Status" INTEGER,
"Status_Notes" TEXT,
"Responsible_Agency" INTEGER,
"Category" INTEGER,
"Request_Type" INTEGER,
"Request_Details" TEXT,
"Address" TEXT,
"Street" TEXT,
"Supervisor_District" INTEGER,
"Neighborhood" TEXT,
"Police_District" TEXT,
"Latitude" REAL,
"Longitude" REAL,
"Point" TEXT,
"Source" TEXT,
"Media_URL" TEXT,
"SF_Find_Neighborhoods" INTEGER,
"Current_Police_Districts" INTEGER,
"Current_Supervisor_Districts" INTEGER,
"Analysis_Neighborhoods" INTEGER,
":@computed_region_rxqg_mtj9" INTEGER,
":@computed_region_yftq_j783" INTEGER,
":@computed_region_jx4q_fizf" INTEGER,
":@computed_region_bh8s_q3mv" TEXT,
":@computed_region_p5aj_wyqh" INTEGER,
":@computed_region_fyvs_ahh9" INTEGER,
":@computed_region_f58d_8dbm" INTEGER,
":@computed_region_9dfj_4gjx" INTEGER,
":@computed_region_vtsz_7cme" INTEGER,
":@computed_region_n4xg_c4py" INTEGER,
":@computed_region_sruu_94in" INTEGER,
":@computed_region_4isq_27mq" INTEGER,
":@computed_region_viu7_rrfi" INTEGER,
":@computed_region_fcz8_est8" INTEGER,
":@computed_region_pigm_ib2e" INTEGER,
":@computed_region_9jxd_iqea" INTEGER,
":@computed_region_6ezc_tdp2" INTEGER,
":@computed_region_6pnf_4xz7" INTEGER,
":@computed_region_h4ep_8xdi" INTEGER,
":@computed_region_nqbw_i6c3" INTEGER,
":@computed_region_2dwj_jsy4" INTEGER,
":@computed_region_y6ts_4iup" INTEGER,
"Neighborhoods" INTEGER
,
FOREIGN KEY ("Status") REFERENCES [Status](id),
FOREIGN KEY ("Responsible_Agency") REFERENCES [Responsible_Agency](id),
FOREIGN KEY ("Category") REFERENCES [Category](id),
FOREIGN KEY ("Request_Type") REFERENCES [Request_Type](id))