calls

80,878 rows sorted by :@computed_region_p5aj_wyqh

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
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                                                        
218983 218983 9176994 2018-06-23T20:43:00 2018-10-29T15:15:39 2018-10-29T15:15:39 Closed 2 You must call the presidio this is federal property DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1811 WYMAN AVE, SAN FRANCISCO, CA, 94129 WYMAN AVE 2 Presidio National Park   37.789055 -122.47142 POINT (-122.47142 37.789055) Mobile/Open311 http://mobile311.sfgov.org/reports/9176994/photos 3   6 27 1 11   61   30 30   3   6             1         3
228215 228215 9070712 2018-05-30T14:01:55 2018-10-04T15:59:29 2018-10-04T15:59:29 Closed 2 PRESIDIO ONLY. Not In Public Works Jurisdiction DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 553 SUMNER AVE, SAN FRANCISCO, CA, 94129 SUMNER AVE 2 Presidio National Park   37.797191666667 -122.45372833333299 POINT (-122.45372833 37.79719167) Mobile/Open311 http://mobile311.sfgov.org/reports/9070712/photos 3   6 27 1 11   61   30 30   3   6             1         3
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                        
252019 252019 9230993 2018-07-06T08:19:00 2018-12-04T13:09:46 2018-12-04T13:09:46 Closed 2 call presidio this is federal DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1809 WYMAN AVE, SAN FRANCISCO, CA, 94129 WYMAN AVE 2 Presidio National Park   37.789211911416004 -122.471173244249 POINT (-122.47117324 37.78921191) Mobile/Open311   3   6 27 1 11   61   30 30   3   6             1         3
252276 252276 9168685 2018-06-21T17:31:41 2018-09-14T12:09:43 2018-09-14T12:09:43 Closed 2 not public works department responsibility DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1199 EAST BEACH RD, SAN FRANCISCO, CA, 94129 EAST BEACH RD 2 Presidio National Park   37.806011666667 -122.449196666667 POINT (-122.44919667 37.80601167) Mobile/Open311 http://mobile311.sfgov.org/reports/9168685/photos 3   6 27 1 11   61   30 30   3   6             1         3
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                                                      
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                                      
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                                                        
437744 437744 9902126 2018-12-07T00:29:11 2018-12-20T12:01:07 2018-12-20T12:01:07 Closed 2 federal jurisdiction DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 300 FINLEY RD, SAN FRANCISCO, CA, 94129 FINLEY RD 2 Presidio National Park   37.790456299999995 -122.45974340000001 POINT (-122.4597434 37.7904563) Mobile/Open311   3   6 27 1 11   61   30 30   3   6             1         3
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                                                        
475356 475356 9862722 2018-11-28T11:51:00 2018-12-14T09:29:00 2018-12-14T09:29:00 Closed 2   311 Service Request Queue - Hold 25 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 346 WEST PACIFIC AVE, SAN FRANCISCO, CA, 94129 WEST PACIFIC AVE 2 Presidio National Park   37.790809347017 -122.469169129053 POINT (-122.46916913 37.79080935) Web   3   6 27 1 11   61   30 30   3   6             1         3
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                                                        
505558 505558 10365812 2019-01-16T16:26:00 2019-01-24T08:55:07 2019-01-24T08:55:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LOMBARD ST and LYON ST LOMBARD ST 2 Cow Hollow NORTHERN 37.798458099365 -122.447303771973 POINT (-122.44730377 37.7984581) Phone   14 4 6 27 1 13   57   30 30   14   6             1         14
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                                                        
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                                                        
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                                                        
642004 642004 10417182 2019-01-28T13:15:00 2019-02-06T15:31:48 2019-02-06T15:31:48 Closed 2 Issue addressed by staff. RPD Park Service Area 1 Queue 9 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 11TH AVE, SAN FRANCISCO, CA, 94118 11TH AVE 2 Presidio Terrace RICHMOND 37.78727722168 -122.469757080078 POINT (-122.46975708 37.78727722) Phone   4   6 11 1 11   54   11 11   4   6             1         4
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                                                        
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                                                        
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                                                        
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                                                        
673859 673859 295106 2008-10-09T12:19:30 2010-06-26T19:17:04 2010-06-26T19:17:04 Closed 2   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                                                        
675184 675184 402105 2009-03-31T16:20:59 2009-05-29T18:20:50 2009-05-29T18:20:50 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                                                        
676942 676942 423028 2009-05-01T16:21:33 2009-08-25T12:26:22 2009-08-25T12:26:22 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
677320 677320 279403 2008-09-10T14:24:29 2008-11-19T16:06:57 2008-11-19T16:06:57 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                                                        
677520 677520 422425 2009-04-30T19:07:31 2017-05-03T14:25:34 2017-05-03T14:25:34 Closed 2 planting request exists & site was recently backfilled 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                                                        
678767 678767 279095 2008-09-10T09:27:47   2008-09-10T09:47:00 Open 1 Open DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
682243 682243 412319 2009-04-16T09:57:00 2009-04-17T13:10:25 2009-04-17T13:10:25 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                                                        
682693 682693 392506 2009-03-19T13:02:12 2009-09-03T12:11:15 2009-09-03T12:11:15 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                                                        
684312 684312 282880 2008-09-17T07:11:53 2010-07-26T16:17:02 2010-07-26T16:17: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) Phone                                                        
684629 684629 426176 2009-05-06T12:02:57 2010-04-13T06:16:52 2010-04-13T06:16:52 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                                                        
686653 686653 302439 2008-10-23T15:47:49 2008-10-29T10:06:52 2008-10-29T10:06:52 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                                                        
690435 690435 309503 2008-11-05T14:51:39 2010-06-25T14:16:56 2010-06-25T14:16:56 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                                                        
690485 690485 440196 2009-05-29T15:43:25 2011-08-31T10:05:36 2011-08-31T10:05:36 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                                                        
690827 690827 250375 2008-07-18T15:13:03 2008-07-26T16:04:49 2008-07-26T16:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of JOHN MUIR DR and LAKE MERCED BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.708084106445 -122.48572540283199 POINT (-122.4857254 37.70808411) Phone                 28,589                                      
690967 690967 291436 2008-10-02T15:25:03 2008-10-09T11:17:57 2008-10-09T11:17:57 Closed 2 Currently resolved, but this site continues to have significant recurring irrigation issues that are not currently funded for capital repair. RPD Park Service Area 1 Queue 9 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of LAKE ST and PARK PRESIDIO BLVD LAKE ST 2 Lake Street RICHMOND 37.786315917969 -122.472625732422 POINT (-122.47262573 37.78631592) Phone   2   6 33 1 11   54   33 33   2   6             1     3   2
691883 691883 370158 2009-02-11T09:10:20 2012-06-11T13:30:45 2012-06-11T13:30:45 Closed 2 resolved: Request closed by SES . Notes = " Notes:completed through ASAP. BUF Action:REPAIR SWK. date completed - 6/7/2012. ". 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                                                        
692623 692623 392996 2009-03-20T11:00:30 2015-03-31T06:51:38 2015-03-31T06:51:38 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) Phone                                                        
693157 693157 320077 2008-11-25T08:10:20 2008-11-26T07:07:00 2008-11-26T07:07:00 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                                                        
695070 695070 418984 2009-04-25T17:35:28 2009-04-25T18:10:25 2009-04-25T18:10:25 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                                                        
695234 695234 426870 2009-05-07T11:38:37 2009-06-04T08:10:45 2009-06-04T08:10:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
697143 697143 389833 2009-03-15T18:16:15 2009-03-15T20:10:10 2009-03-15T20:10:10 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                                                        
701130 701130 387516 2009-03-11T15:39:12 2009-03-16T13:10:09 2009-03-16T13:10:09 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                                                        
706097 706097 346262 2009-01-07T08:29:26 2009-01-07T09:07:09 2009-01-07T09:07:09 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                                                        
710680 710680 414077 2009-04-18T16:12:02 2009-04-22T06:22:28 2009-04-22T06:22:28 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                                                        
712181 712181 376649 2009-02-23T06:47:07 2009-05-29T18:22:19 2009-05-29T18:22:19 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                                                        
714312 714312 398612 2009-03-26T10:20:31 2009-03-26T11:10:19 2009-03-26T11:10:19 Closed 2   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) Phone                                                        
715447 715447 282984 2008-09-17T10:01:45   2016-06-10T13:43:44 Open 1 SENT 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                                                        
717304 717304 409963 2009-04-12T19:12:28 2011-09-07T07:45:44 2011-09-07T07:45:44 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                                                        
719026 719026 267158 2008-08-19T13:05:26 2008-08-28T16:05:26 2008-08-28T16:05:26 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 7 RICHARDS CT, SAN FRANCISCO, CA, 94124 RICHARDS CT 0     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 76.047ms