calls

80,878 rows where Category = 1 sorted by :@computed_region_fyvs_ahh9

View and edit SQL

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 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 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 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 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 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 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 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 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 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                                                        
44280 44280 10797978 2019-04-30T11:47:00   2019-07-19T16:19:41 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 389 GUTTENBERG ST, SAN FRANCISCO, CA, 94112 GUTTENBERG ST 11 Crocker Amazon INGLESIDE 37.708213806152 -122.442016601563 POINT (-122.4420166 37.70821381) Phone                 28,588                                      
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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                                                        
198677 198677 9395169 2018-08-13T09:07:00 2018-10-30T13:25:49 2018-10-30T13:25:49 Closed 2 trees posted for removal. will be removing DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 477 OFARRELL ST, SAN FRANCISCO, CA, 94102 OFARRELL ST 0     0.0 0.0 POINT (0 0) Phone                                                        
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                                                        
232744 232744 7209856 2017-05-31T20:07:16 2017-06-05T14:30:48 2017-06-05T14:30:48 Closed 2 Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 97 SAN DIEGO AVE, SAN FRANCISCO, CA, 94112 SAN DIEGO AVE 11 Outer Mission TARAVAL 37.7081902 -122.46663400000001 POINT (-122.466634 37.7081902) Web       1   6     28,588             1                        
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 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 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 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                                                      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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))
Powered by Datasette · Query took 128.053ms