calls

80,878 rows sorted by SF_Find_Neighborhoods

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
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                                                        
205234 205234 9077793 2018-05-31T18:37:00 2018-06-05T09:19:33 2018-06-05T09:19:33 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you for your patience. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of TARAVAL ST and 19TH AVE TARAVAL ST 7 Parkside TARAVAL 37.743053436279 -122.47564697265601 POINT (-122.47564697 37.74305344) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
218194 218194 9242015 2018-07-09T09:44:00 2018-08-09T08:15:00 2018-08-09T08:15:00 Closed 2   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.781257629395 -122.458862304688 POINT (-122.4588623 37.78125763) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
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                                                        
227881 227881 9076892 2018-05-31T15:44:00 2018-05-31T19:13:00 2018-05-31T19:13:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and WAWONA ST 19TH AVE 4 Parkside TARAVAL 37.737453460693004 -122.475288391113 POINT (-122.47528839 37.73745346) Phone     10 8 41 4 1 5 29,491 8 40 40       8             1          
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                        
236710 236710 9359390 2018-08-04T14:14:00 2018-08-04T14:34:49 2018-08-04T14:34:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LYON ST and GREEN ST LYON ST 2 Pacific Heights NORTHERN 37.794708251953004 -122.446723937988 POINT (-122.44672394 37.79470825) Phone     4 6 13 1 13 6 57 9 17 17       6             1          
245661 245661 9272126 2018-07-16T09:18:00 2018-07-17T12:29:46 2018-07-17T12:29:46 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and PAGE ST DIVISADERO ST 5 Buena Vista NORTHERN 37.772205352783 -122.43723297119101 POINT (-122.43723297 37.77220535) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
250066 250066 9196933 2018-06-28T09:01:00 2018-08-14T07:34:00 2018-08-14T07:34:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of ELLIS ST and DIVISADERO ST ELLIS ST 5 Anza Vista NORTHERN 37.781520843505994 -122.43911743164101 POINT (-122.43911743 37.78152084) Phone     4 11 39 11 15 8 29,490 5 41 41       11             2          
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                                                        
280355 280355 9227457 2018-07-05T11:45:00 2019-05-17T09:51:00 2019-05-17T09:51:00 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of ARGUELLO BLVD and CLEMENT ST ARGUELLO BLVD 2 Inner Richmond RICHMOND 37.783187866211 -122.458999633789 POINT (-122.45899963 37.78318787) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
283694 283694 9138832 2018-06-14T18:51:00 2018-08-16T07:00:42 2018-08-16T07:00:42 Closed 2 Issue has been resolved or a work order was issued to the appropriate division. RPD GGP Queue 14 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
283821 283821 9084184 2018-06-02T11:20:00 2018-06-14T06:57:50 2018-06-14T06:57:50 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
291891 291891 9586323 2018-09-25T10:42:00 2018-09-26T12:57:00 2018-09-26T12:57:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LYON ST and GREEN ST LYON ST 2 Pacific Heights NORTHERN 37.794708251953004 -122.446723937988 POINT (-122.44672394 37.79470825) Phone     4 6 13 1 13 6 57 9 17 17       6             1          
306268 306268 9474801 2018-08-30T12:16:00 2018-09-22T07:22:00 2018-09-22T07:22:00 Closed 2 Your service request has been transferred to the contractors and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 19TH AVE and VICENTE ST 19TH AVE 4 Parkside TARAVAL 37.739326477051 -122.475410461426 POINT (-122.47541046 37.73932648) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
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                                                        
312045 312045 9627154 2018-10-04T13:20:00 2018-12-05T08:00:00 2018-12-05T08:00:00 Closed 2 Your service order has been inspected by landscape, transferred out as - Private Property DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of YERBA BUENA AVE and MIRALOMA DR YERBA BUENA AVE 7 Monterey Heights INGLESIDE 37.735179901123 -122.460479736328 POINT (-122.46047974 37.7351799) Phone     9 8 41 4 9 4 59 7 40 40       8             1          
339140 339140 9674501 2018-10-15T12:05:00   2018-10-15T12:25:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780380249023 -122.478302001953 POINT (-122.478302 37.78038025) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
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                                                      
341438 341438 9664115 2018-10-12T14:25:00 2018-10-13T09:06:00 2018-10-13T09:06:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of ELLIS ST and DIVISADERO ST ELLIS ST 5 Anza Vista NORTHERN 37.781520843505994 -122.43911743164101 POINT (-122.43911743 37.78152084) Phone     4 11 39 11 15 8 29,490 5 41 41       11             2          
355738 355738 8448793 2017-12-31T23:05:00   2017-12-31T23:40:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 19TH AVE and TARAVAL ST 19TH AVE 7 Parkside TARAVAL 37.743053436279 -122.47564697265601 POINT (-122.47564697 37.74305344) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
399643 399643 9534901 2018-09-13T09:06:00 2018-10-16T21:08:51 2018-10-16T21:08:51 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of FRANCISCO ST and VAN NESS AVE FRANCISCO ST 2 Marina NORTHERN 37.803203582764 -122.42491912841801 POINT (-122.42491913 37.80320358) Phone     4 6 32 1 5 6 28,858 9 32 32       6             1          
411806 411806 9644691 2018-10-08T18:32:00 2018-10-23T13:18:18 2018-10-23T13:18:18 Closed 2 tree in private property cbc DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 110 SHAKESPEARE ST, SAN FRANCISCO, CA, 94112 SHAKESPEARE ST 11 Outer Mission TARAVAL 37.708099365234 -122.46246337890601 POINT (-122.46246338 37.70809937) Phone                 28,588                                      
427456 427456 9417966 2018-08-17T18:52:00 2018-09-12T10:40:53 2018-09-12T10:40:53 Closed 2 this is not an issue to be concerned about. trees will be allowed to grow DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794708251953004 -122.446723937988 POINT (-122.44672394 37.79470825) Phone     4 6 13 1 13 6 57 9 17 17       6             1          
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                                                        
443368 443368 10303544 2019-01-02T07:34:00   2019-01-04T11:50:01 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of DIVISADERO ST and PAGE ST DIVISADERO ST 5 Buena Vista NORTHERN 37.772205352783 -122.43723297119101 POINT (-122.43723297 37.77220535) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
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 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                                                        
485282 485282 997540 2011-11-04T05:08:01   2011-11-04T05:52:58 Open 1 Open 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                                                        
485423 485423 920593 2011-07-15T06:36:04 2011-07-30T16:06:06 2011-07-30T16:06:06 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                                                        
485925 485925 1460675 2012-09-23T11:02:51 2012-10-03T13:16:44 2012-10-03T13:16:44 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                                                        
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                                                        
486606 486606 3046221 2013-11-09T11:16:30 2013-11-09T13:17:25 2013-11-09T13:17:25 Closed 2 resolved: 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                                                        
486982 486982 2915010 2013-10-07T08:54:21 2014-04-10T12:25:46 2014-04-10T12:25:46 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                                                        
487042 487042 970283 2011-09-26T14:34:59 2014-03-07T11:12:55 2014-03-07T11:12:55 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) Web                                                        
495932 495932 5351445 2015-12-07T08:29:37 2015-12-08T05:56:18 2015-12-08T05:56:18 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                                                        
507470 507470 2221950 2013-04-08T17:59:04 2016-04-11T05:06:06 2016-04-11T05:06:06 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 55 LUNDY'S LN, SAN FRANCISCO, CA, 94110 LUNDY'S LN 0     0.0 0.0 POINT (0 0) Phone                                                        
507493 507493 3046979 2013-11-09T15:40:42 2016-06-14T03:03:00 2016-06-14T03:03:00 Closed 2 10/98 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) Phone                                                        
509354 509354 244270 2008-07-08T14:02:20 2008-07-26T16:04:47 2008-07-26T16:04:47 Closed 2 See Notes tab for more details 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) Phone                                                        
512735 512735 342850 2009-01-02T09:44:29 2009-01-06T11:07:17 2009-01-06T11:07:17 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                                                        
519103 519103 438590 2009-05-27T12:21:40 2010-01-26T04:41:34 2010-01-26T04:41:34 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
520884 520884 438638 2009-05-27T13:06:35 2011-09-20T14:40:47 2011-09-20T14:40:47 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
524256 524256 383967 2009-03-05T18:47:33 2010-07-02T13:16:58 2010-07-02T13:16:58 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                                                        
527551 527551 445020 2009-06-05T19:53:48 2009-06-11T08:10:49 2009-06-11T08:10:49 Closed 2   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) Phone                                                        
528900 528900 10306405 2019-01-02T14:25:00 2019-04-03T15:53:49 2019-04-03T15:53: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 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
538141 538141 401920 2009-03-31T13:55:01 2009-04-06T12:10:21 2009-04-06T12:10:21 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                                                        
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                                                        
545004 545004 446991 2009-06-09T12:26:00 2009-06-11T06:10:47 2009-06-11T06:10:47 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                                                        
547262 547262 430788 2009-05-13T14:09:17 2009-05-15T15:10:36 2009-05-15T15:10:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 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                                                        
566607 566607 10457935 2019-02-06T16:17:00 2019-02-06T19:11:40 2019-02-06T19:11:40 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of DIVISADERO ST and ELLIS ST DIVISADERO ST 5 Anza Vista NORTHERN 37.781520843505994 -122.43911743164101 POINT (-122.43911743 37.78152084) Phone     4 11 39 11 15 8 29,490 5 41 41       11             2          
568830 568830 10717337 2019-04-11T14:54:00   2019-05-13T06:35:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 375 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Outer Richmond RICHMOND 37.78098866347 -122.47834928345199 POINT (-122.47834928 37.78098866) Mobile/Open311 http://mobile311.sfgov.org/reports/10717337/photos   8 4 29 2 11 9 55 6 26 26       4             2          
572053 572053 260228 2008-08-05T18:06:20 2010-06-25T13:16:55 2010-06-25T13:16:55 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
574111 574111 10536335 2019-02-26T11:34:00 2019-02-26T14:14:47 2019-02-26T14:14:47 Closed 2 notified engineer- private residence----Seacliff-- not Baker Beach LM 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                                                        
588941 588941 411333 2009-04-14T17:24:52 2009-04-14T20:10:18 2009-04-14T20:10:18 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                                                        
595421 595421 10515978 2019-02-21T10:42:00 2019-08-10T10:24:15 2019-08-10T10:24:15 Closed 2 There is no immediate safety issue with the steet tree adjacent to this property 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 - Damaged_Tree 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
605280 605280 10624176 2019-03-20T09:24:00 2019-03-31T10:51:36 2019-03-31T10:51:36 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you for your patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780380249023 -122.478302001953 POINT (-122.478302 37.78038025) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
606146 606146 10492426 2019-02-15T08:46:00 2019-03-25T07:33:00 2019-03-25T07:33:00 Closed 2 Tree removed as of Friday, 3/22/19. Port Authority - G 33 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3301 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Central Waterfront BAYVIEW 37.747616074083 -122.38710497517401 POINT (-122.38710498 37.74761607) Mobile/Open311 http://mobile311.sfgov.org/reports/10492426/photos   2         3 58 3                                    
609394 609394 10538413 2019-02-26T17:15:00 2019-05-07T17:07:48 2019-05-07T17:07:48 Closed 2 trees are not blocking the stop sign here. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780380249023 -122.478302001953 POINT (-122.478302 37.78038025) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
620846 620846 321423 2008-11-27T12:44:19 2009-09-24T16:16:16 2009-09-24T16:16:16 Closed 2   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                                                        
654546 654546 10632620 2019-03-22T09:04:19 2019-05-10T11:33:51 2019-05-10T11:33:51 Closed 2 issue fine photos already taken DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2636 GREEN ST, SAN FRANCISCO, CA, 94123 GREEN ST 2 Cow Hollow NORTHERN 37.795228576382 -122.44262327590201 POINT (-122.44262328 37.79522858) Mobile/Open311 http://mobile311.sfgov.org/reports/10632620/photos   4 6 30 1 13 6 57 9 27 27       6             1          
659503 659503 525109 2009-10-15T11:29:19 2009-10-21T09:16:21 2009-10-21T09:16:21 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                                                        
659707 659707 525539 2009-10-15T18:17:04 2010-07-02T17:17:04 2010-07-02T17:17:04 Closed 2   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) Phone                                                        
659736 659736 531243 2009-10-23T18:57:38 2009-11-25T08:16:30 2009-11-25T08:16:30 Closed 2   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) Phone                                                        
659904 659904 762674 2010-10-30T10:59:22 2010-12-11T08:09:25 2010-12-11T08:09:25 Closed 2   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                                                        
659905 659905 780224 2010-11-29T18:24:39 2011-01-05T09:09:22 2011-01-05T09:09:22 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) Twitter                                                        
659917 659917 715203 2010-08-17T17:47:15 2010-09-15T09:18:14 2010-09-15T09:18:14 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                                                        
659997 659997 671831 2010-06-09T07:30:57 2010-06-10T06:21:59 2010-06-10T06:21:59 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                                                        
660034 660034 690879 2010-07-10T13:16:57 2011-01-15T07:09:19 2011-01-15T07:09:19 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                                                        
660102 660102 746494 2010-10-05T08:29:45 2010-10-05T12:09:44 2010-10-05T12:09:44 Closed 2   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) Phone                                                        
660189 660189 744147 2010-10-01T12:20:28 2010-10-27T10:09:49 2010-10-27T10:09:49 Closed 2   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                                                        
660234 660234 684326 2010-06-29T14:51:15 2010-12-06T12:09:23 2010-12-06T12:09:23 Closed 2   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                                                        
661024 661024 353429 2009-01-17T10:08:43 2009-01-23T06:07:23 2009-01-23T06:07:23 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                                                        
661970 661970 380659 2009-02-28T22:54:56 2009-03-01T07:06:25 2009-03-01T07:06:25 Closed 2 Per DPW, Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of LISBON ST and SILVER AVE LISBON ST 11 Mission Terrace INGLESIDE 37.728534698486 -122.428665161133 POINT (-122.42866516 37.7285347) Phone     9 1 7 6 9 4 28,861 7 5 5 16     1             2          
662629 662629 315711 2008-11-17T11:51:10 2009-06-03T11:10:43 2009-06-03T11:10:43 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 815 BUENA VISTA WEST AVE, SAN FRANCISCO, CA, 94117 BUENA VISTA WEST AVE 0     0.0 0.0 POINT (0 0) Phone                                                        
662863 662863 384602 2009-03-06T17:10:45 2012-03-29T06:07:00 2012-03-29T06:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
664048 664048 401901 2009-03-31T13:35:45 2009-05-29T18:12:38 2009-05-29T18:12:38 Closed 2   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) Phone                                                        
665533 665533 433961 2009-05-18T18:13:55 2009-05-29T18:00:50 2009-05-29T18:00:50 Closed 2   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) Phone                                                        
667140 667140 314449 2008-11-14T15:06:32 2009-02-23T13:10:01 2009-02-23T13:10:01 Closed 2   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                                                        
667923 667923 382061 2009-03-03T09:26:08 2009-03-11T14:10:10 2009-03-11T14:10:10 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                                                        
668148 668148 243173 2008-07-06T16:36:28 2008-07-08T12:05:29 2008-07-08T12:05:29 Closed 2 See Notes tab for more details 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) Phone                                                        
668301 668301 309667 2008-11-05T22:04:36 2010-06-25T14:16:56 2010-06-25T14:16:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 19TH AVE and ANZA ST 19TH AVE 1 Inner Richmond RICHMOND 37.778457641602 -122.478164672852 POINT (-122.47816467 37.77845764) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
668511 668511 413472 2009-04-17T16:38:39 2009-05-29T18:16:01 2009-05-29T18:16:01 Closed 2   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) Phone                                                        
669256 669256 277003 2008-09-06T11:15:01 2008-10-23T15:06:52 2008-10-23T15:06:52 Closed 2   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) Phone                                                        
670041 670041 268567 2008-08-21T17:19:16 2008-11-19T15:06:57 2008-11-19T15:06:57 Closed 2   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                                                        
670246 670246 370015 2009-02-10T18:34:52 2011-09-20T14:05:36 2011-09-20T14:05:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780380249023 -122.478302001953 POINT (-122.478302 37.78038025) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
670352 670352 420434 2009-04-27T20:22:43 2009-04-28T06:10:29 2009-04-28T06:10:29 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                                                        
671943 671943 425665 2009-05-05T15:49:16 2009-05-05T18:10:31 2009-05-05T18:10:31 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                                                        
673701 673701 403823 2009-04-02T18:23:37 2009-05-03T06:10:57 2009-05-03T06:10:57 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                                                        
673852 673852 302231 2008-10-23T11:20:08 2009-03-12T10:10:10 2009-03-12T10:10:10 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                                                        

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