calls

7,158 rows where Responsible_Agency = 2 sorted by Supervisor_District

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
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
486305 486305 4292315 2014-12-11T08:28:46 2014-12-29T11:38:00 2014-12-29T11:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
543968 543968 374779 2009-02-19T12:46:01 2010-03-26T13:56:41 2010-03-26T13:56:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
547835 547835 9897323 2018-12-05T22:28:00 2019-06-25T16:23:35 2019-06-25T16:23:35 Closed 2   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) Phone                                                        
796807 796807 379667 2009-02-27T12:41:38 2010-03-26T13:56:42 2010-03-26T13:56:42 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) Phone                                                        
828321 828321 532703 2009-10-26T16:27:08 2011-03-17T12:09:52 2011-03-17T12:09:52 Closed 2 Confirmed with DPW - work previously completed. 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                                                        
973266 973266 759589 2010-10-25T22:27:01 2011-03-17T12:08:46 2011-03-17T12:08:46 Closed 2 Confirmed with DPW - work previously completed. 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                                                        
1163868 1163868 893282 2011-06-03T07:37:29   2011-06-03T08:42:44 Open 1 Open 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) Web                                                        
1199815 1199815 894565 2011-06-05T15:24:34   2011-06-05T16:09:38 Open 1 Open 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                                                        
1269000 1269000 1111743 2012-04-24T17:46:03   2012-04-25T09:54:48 Open 1 Open DPW BUF Queue 2 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                                                        
1312541 1312541 1063243 2012-02-12T11:25:27   2012-02-12T12:23:16 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1389941 1389941 1176640 2012-07-28T02:33:46   2014-10-09T07:04:00 Open 1 scheduled 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                                                        
1803037 1803037 3646040 2014-05-15T14:45:34   2014-05-15T15:26:49 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1924697 1924697 4152500 2014-10-28T09:15:19 2014-12-08T02:15:59 2014-12-08T02:15:59 Closed 2 resolved: 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                                                        
1930607 1930607 4274287 2014-12-05T15:29:56 2016-06-20T08:05:28 2016-06-20T08:05:28 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                                                        
1938944 1938944 4039133 2014-09-23T08:51:29 2016-06-20T07:49:18 2016-06-20T07:49:18 Closed 2 All the trees on 1800 block of Pierce are Privately owned/maintained 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                                                        
1940864 1940864 4081348 2014-10-06T13:59:08 2015-02-06T06:08:00 2015-02-06T06:08:00 Closed 2 resolved: 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                                                        
1946061 1946061 3974878 2014-09-02T14:40:33 2014-09-30T12:57:11 2014-09-30T12:57:11 Closed 2 resolved: 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                                                        
1953248 1953248 3941651 2014-08-22T12:55:57 2014-09-10T12:48:03 2014-09-10T12:48:03 Closed 2 resolved: DPW did no work to this tree at all we do not top Bottlebrush trees we only raise the skirt DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1961440 1961440 3981394 2014-09-04T14:01:26 2014-09-05T01:59:42 2014-09-05T01:59:42 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) Web                                                        
1968280 1968280 4155876 2014-10-29T08:32:17 2015-02-26T12:15:30 2015-02-26T12:15:30 Closed 2 cancelled: complaint was given to contractor and in October the contractor did send guy to litter pick area DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1972937 1972937 4079809 2014-10-06T09:06:06 2014-10-08T07:26:22 2014-10-08T07:26:22 Closed 2 cancelled: 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) Phone                                                        
1974795 1974795 3978235 2014-09-03T14:40:53 2014-09-05T02:11:28 2014-09-05T02:11:28 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1979670 1979670 3941433 2014-08-22T12:11:01 2014-08-23T11:54:54 2014-08-23T11:54:54 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
1987060 1987060 4041997 2014-09-23T18:54:45 2014-09-30T01:01:50 2014-09-30T01:01:50 Closed 2 resolved: 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                                                        
1987997 1987997 3941376 2014-08-22T12:02:51 2014-08-22T04:24:49 2014-08-22T04:24:49 Closed 2 cancelled: 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) Phone                                                        
1989938 1989938 4105897 2014-10-14T09:45:59 2016-06-20T07:53:35 2016-06-20T07:53:35 Closed 2 Tree is privately maintained and responsibility of home owner 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                                                        
1991722 1991722 3972728 2014-09-01T22:20:41 2014-09-10T09:50:47 2014-09-10T09:50:47 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1992799 1992799 4011640 2014-09-14T17:42:07 2014-11-29T01:52:10 2014-11-29T01:52:10 Closed 2 resolved: joe Park Merced is way out by the Pacific Ocean(Robs Area) - Tom-Please note there is job number to charge to. 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                                                        
1997444 1997444 4011666 2014-09-14T17:50:53 2014-09-30T01:10:51 2014-09-30T01:10:51 Closed 2 resolved: Unsure if City or Privately Owned-- 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                                                        
2002309 2002309 4065422 2014-10-01T10:45:18 2015-01-02T08:34:46 2015-01-02T08:34:46 Closed 2 cancelled: Inspected location trees just trimmed in November 2014 not work needed - 0 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                                                        
2017299 2017299 3959233 2014-08-28T06:58:10 2014-09-24T06:50:34 2014-09-24T06:50:34 Closed 2 resolved: No city maintain trees on the 1200 block of Taylor Street 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                                                        
2022441 2022441 4296089 2014-12-12T08:34:55 2014-12-29T11:08:00 2014-12-29T11:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023753 2023753 4066053 2014-10-01T13:32:49 2014-10-16T12:58:31 2014-10-16T12:58:31 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023982 2023982 3949041 2014-08-25T09:46:49 2014-09-24T01:51:13 2014-09-24T01:51:13 Closed 2 resolved: 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                                                        
2029364 2029364 3989423 2014-09-07T18:02:38 2014-10-07T02:06:11 2014-10-07T02:06:11 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2054000 2054000 4018281 2014-09-16T14:06:34 2014-12-08T02:14:32 2014-12-08T02:14:32 Closed 2 resolved: cleared signs 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                                                        
2065689 2065689 4463860 2015-02-05T16:09:15 2015-02-28T12:38:00 2015-02-28T12:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Pink Triangle Park, , SAN FRANCISCO, CA         0.0 0.0 POINT (0 0) Phone                                                        
2091336 2091336 4717579 2015-05-04T10:14:25 2015-08-06T12:37:00 2015-08-06T12:37:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2107526 2107526 4821764 2015-06-12T09:53:05 2015-08-06T12:39:00 2015-08-06T12:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2128341 2128341 4712447 2015-05-01T15:51:00 2015-06-29T09:14:45 2015-06-29T09:14:45 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
2159286 2159286 4391816 2015-01-14T05:33:16 2015-03-04T09:29:00 2015-03-04T09:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
2161601 2161601 4395348 2015-01-15T09:35:29 2015-01-15T12:47:00 2015-01-15T12:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
2184944 2184944 4468980 2015-02-07T09:30:04 2016-06-20T07:30:25 2016-06-20T07:30:25 Closed 2   DPW BUF Queue 2 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                                                        
2238871 2238871 4983855 2015-08-10T12:22:39 2015-08-12T10:18:00 2015-08-12T10:18:00 Closed 2 resolved: 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                                                        
2302481 2302481 4904095 2015-07-13T10:49:26 2015-07-15T11:52:00 2015-07-15T11:52:00 Closed 2 resolved: 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                                                        
2309584 2309584 4943026 2015-07-27T10:31:29 2015-08-06T11:43:08 2015-08-06T11:43:08 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2358787 2358787 5637975 2016-03-06T14:30:23 2016-03-11T02:52:00 2016-03-11T02:52:00 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) Phone                                                        
2385145 2385145 5284753 2015-11-14T15:00:20 2016-03-29T02:48:00 2016-03-29T02:48:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
2415625 2415625 5306360 2015-11-21T09:04:15 2016-06-01T04:47:00 2016-06-01T04: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                                                        
2422975 2422975 5402492 2015-12-24T13:42:04 2016-02-26T01:39:00 2016-02-26T01:39:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2489252 2489252 5842130 2016-05-07T13:57:07 2016-07-05T09:51:00 2016-07-05T09:51: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                                                        
2496103 2496103 5666514 2016-03-15T09:55:48 2016-03-30T12:09:09 2016-03-30T12:09:09 Closed 2   DPW BUF Queue 2 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                                                        
2509427 2509427 5703919 2016-03-27T09:48:29 2016-06-01T07:14:00 2016-06-01T07:14:00 Closed 2   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                                                        
2527442 2527442 5920127 2016-05-29T11:53:47 2016-11-08T08:10:25 2016-11-08T08:10:25 Closed 2   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                                                        
2529465 2529465 5909530 2016-05-25T18:42:27 2016-11-10T09:40:22 2016-11-10T09:40:22 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                                                        
2529685 2529685 5734346 2016-04-05T20:55:01 2016-04-12T12:00:00 2016-04-12T12:00:00 Closed 2 Request closed by in Operations system at Apr 12 2016 12:00AM. Notes = " Notes:a few beanchesmeed to be pruned so stop sign is visible. :: Closed By CMMS SO 504491from CMMS: . BUF Action:Prune. date completed - 4/12/2016. ". 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                                                        
2533831 2533831 5712230 2016-03-29T21:28:54   2016-03-29T21:46:27 Open 1 accepted 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                                                        
2537126 2537126 5947732 2016-06-06T08:36:26 2016-06-14T03:09:50 2016-06-14T03:09:50 Closed 2 Location is under contract DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
2563186 2563186 5642032 2016-03-07T18:15:00 2016-06-02T03:36:00 2016-06-02T03:36: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                                                        
2575929 2575929 5661024 2016-03-13T16:40:14 2016-04-04T09:19:35 2016-04-04T09:19:35 Closed 2   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                                                        
2578512 2578512 5824292 2016-05-02T23:45:42 2016-08-22T23:10:53 2016-08-22T23:10:53 Closed 2 jade plants lying on the stair way. please clear DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2582298 2582298 5808257 2016-04-28T08:11:30 2016-08-22T23:11:21 2016-08-22T23:11:21 Closed 2 dpw maintained median at Delancey and Bryant? 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                                                        
2584045 2584045 5776917 2016-04-19T08:15:29 2016-08-22T23:12:08 2016-08-22T23:12:08 Closed 2 they need a street inspector to come out . transferri g to BSM 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) Web                                                        
2585171 2585171 5721927 2016-04-01T15:34:29 2016-04-07T03:17:13 2016-04-07T03:17:13 Closed 2 Landscape area at 637 Hamilton is privately maintained. Not under the care and maintenance of Public Works. Please forward Service Order to correct property owner. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2763330 2763330 6649733 2016-12-21T11:44:45 2017-01-02T16:40:10 2017-01-02T16:40:10 Closed 2 Thank you for the info around the water leak. the system has been turned off. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
3062907 3062907 7296911 2017-06-24T18:59:16 2017-10-09T06:47:09 2017-10-09T06:47:09 Closed 2 Your service request has been scheduled for planned maintenance and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
3150383 3150383 8011309 2017-09-12T16:43:00   2017-09-12T19:25:07 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                                                        
3394709 3394709 8929677 2018-04-27T20:18:00 2018-05-07T11:18:00 2018-05-07T11:18:00 Closed 2   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                                                        
3578936 3578936 11063346 2019-06-29T14:42:00 2019-08-06T07:02:00 2019-08-06T07:02:00 Closed 2 Set up traffic control.Litter pick the medians.Hand weed medians.Prune and hedge trim the shrubs.Remove debris and green waste.Break down traffic control. - The planned maintenance for the Lombard St Medians began on Tuesday, July 16, 2019. Set up traffic control.Litter pick the medians.Hand weed medians.Prune and hedge trim the shrubs.Remove debris and green waste.Break down traffic control. - 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                                                        
2238835 2238835 5064641 2015-09-03T18:20:25 2015-09-12T08:10:00 2015-09-12T08:10:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 440 VALLEJO ST, SAN FRANCISCO, CA, 94133 VALLEJO ST 0     37.799122898377 -122.404759997795 POINT (-122.40476 37.7991229) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
2456761 2456761 5538464 2016-02-05T10:09:47   2016-02-22T14:06:47 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 725 BUENA VISTA WEST AVE, SAN FRANCISCO, CA, 94117 BUENA VISTA WEST AVE 0     37.768025 -122.44378666666701 POINT (-122.44378667 37.768025) Mobile/Open311 http://mobile311.sfgov.org/reports/5538464/photos 112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
3074936 3074936 7217261 2017-06-02T15:24:00 2018-04-03T07:04:00 2018-04-03T07:04:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2 FULTON ST, SAN FRANCISCO, CA, 94102 FULTON ST 0     37.7802357 -122.41454750000001 POINT (-122.4145475 37.7802357) Web http://mobile311.sfgov.org/reports/7217261/photos 21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
13892 13892 11610663 2019-10-28T07:16:00 2019-10-28T10:01:57 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 9TH AVE and ANZA ST 9TH AVE 1 Inner Richmond RICHMOND 37.778945922852 -122.467353820801 POINT (-122.46735382 37.77894592) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
23031 23031 11627389 2019-10-31T14:02:00   2019-10-31T17:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ANZA ST and ROSSI AVE ANZA ST 1 Lone Mountain RICHMOND 37.779693603516 -122.456497192383 POINT (-122.45649719 37.7796936) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
23049 23049 11254502 2019-08-10T18:15:00 2019-09-18T14:46:00 2019-09-18T14:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BALBOA ST and 26TH AVE BALBOA ST 1 Outer Richmond RICHMOND 37.776252746581996 -122.48553466796899 POINT (-122.48553467 37.77625275) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
32582 32582 11610643 2019-10-28T07:11:00 2019-10-28T10:02:03 2019-10-29T15:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 901 BALBOA ST, SAN FRANCISCO, CA, 94118 BALBOA ST 1 Inner Richmond RICHMOND 37.776889801025 -122.468505859375 POINT (-122.46850586 37.7768898) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
81001 81001 11526485 2019-10-09T09:28:00 2019-10-10T14:13:00 2019-10-10T14:13:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ARGUELLO BLVD and ANZA ST ARGUELLO BLVD 1 Inner Richmond RICHMOND 37.779335021973 -122.45873260498001 POINT (-122.4587326 37.77933502) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
110140 110140 7479385 2017-08-09T07:09:06 2017-10-25T01:17:00 2017-10-25T01:17:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of ANZA ST and 45TH AVE ANZA ST 1 Sutro Heights RICHMOND 37.77718767951 -122.506021348209 POINT (-122.50602135 37.77718768) Phone   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
111989 111989 7251820 2017-06-12T13:40:47 2017-10-10T01:49:00 2017-10-10T01:49:00 Closed 2 Weeded D1 CCT DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
129597 129597 5579601 2016-02-18T10:58:44 2016-02-23T01:39:00 2016-02-23T01:39:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 250 23RD AVE, SAN FRANCISCO, CA, 94121 23RD AVE 1 Outer Richmond RICHMOND 37.782937864217 -122.48226388634501 POINT (-122.48226389 37.78293786) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
134350 134350 5136732 2015-09-27T14:50:11 2015-10-03T03:06:00 2015-10-03T03:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 1909 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.778742628618005 -122.46869594745199 POINT (-122.46869595 37.77874263) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
134499 134499 5244301 2015-11-01T12:33:56 2015-12-05T06:16:00 2015-12-05T06:16:00 Closed 2 resolved: Inspected by Jose Santiago for triaging. It is in fact a young tree that needs restaking. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of GEARY BLVD and 17TH AVE GEARY BLVD 1 Inner Richmond RICHMOND 37.780474532114 -122.476169109631 POINT (-122.47616911 37.78047453) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
136169 136169 5090960 2015-09-12T14:09:02 2015-09-28T01:48:00 2015-09-28T01:48:00 Closed 2 resolved: JP DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 7TH AVE and ANZA ST 7TH AVE 1 Inner Richmond RICHMOND 37.779042490026 -122.465211844154 POINT (-122.46521184 37.77904249) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
139212 139212 4809824 2015-06-08T08:04:05 2015-07-12T08:12:00 2015-07-12T08:12:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 38TH AVE and FULTON ST 38TH AVE 1 Golden Gate Park RICHMOND 37.771934509277 -122.498115539551 POINT (-122.49811554 37.77193451) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8

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 52.74ms