calls

7,158 rows where Responsible_Agency = 2 sorted by Point

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
601878 601878 10567767 2019-03-06T02:09:00   2019-05-18T15:00:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 435 AVENUE F, SAN FRANCISCO, CA, 94130 AVENUE F 6 Treasure Island SOUTHERN 37.8235515 -122.370648 POINT (-122.370648 37.8235515) Web   36 1 10 37 9   2 62 2 37 37   36   10             2         36
2421706 2421706 5271961 2015-11-10T12:47:09 2015-11-12T11:45:00 2015-11-12T11:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of DONAHUE ST and KIRKWOOD AVE DONAHUE ST 10 Hunters Point BAYVIEW 37.727561325247 -122.37127424846399 POINT (-122.37127425 37.72756133) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
1935200 1935200 4298237 2014-12-12T16:28:12 2014-12-15T12:24:00 2014-12-15T12:24:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 112 DOLPHIN CT, SAN FRANCISCO, CA, 94124 DOLPHIN CT 10 Hunters Point BAYVIEW 37.727840423584 -122.371383666992 POINT (-122.37138367 37.72784042) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2530436 2530436 5934721 2016-06-02T12:04:55 2016-07-12T06:44:34 2016-07-12T06:44:34 Closed 2 TRANSFER TO SES DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 700 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 India Basin BAYVIEW 37.729950234157 -122.372022649349 POINT (-122.37202265 37.72995023) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
2017016 2017016 4296585 2014-12-12T10:23:39 2014-12-16T12:52:34 2014-12-16T12:52:34 Closed 2 cancelled: area is under private maintenance. Not under the care of Public Works. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CALIFORNIA AVE and AVENUE OF THE PALMS CALIFORNIA AVE 6 Treasure Island SOUTHERN 37.81731367135 -122.372452998147 POINT (-122.372453 37.81731367) Phone   36 1 10 37 9   2 62 2 37 37   36   10             2         36
2372989 2372989 5633163 2016-03-05T21:18:17 2016-03-10T11:41:48 2016-03-10T11:41:48 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GATEVIEW AVE and MARINER DR GATEVIEW AVE 6 Treasure Island SOUTHERN 37.829262081419 -122.372827170877 POINT (-122.37282717 37.82926208) Phone   36 1 10 37 9   2 62 2 37 37   36   10             2         36
75957 75957 11523299 2019-10-08T13:39:00   2019-10-08T15:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of ARELIOUS WALKER DR and HUDSON AVE ARELIOUS WALKER DR 10 India Basin BAYVIEW 37.731559753418004 -122.373329162598 POINT (-122.37332916 37.73155975) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
2088934 2088934 4794783 2015-06-02T13:53:24 2015-07-13T06:52:00 2015-07-13T06:52:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of INNES AVE and ARELIOUS WALKER DR INNES AVE 10 Hunters Point BAYVIEW 37.730934143806 -122.37389086325001 POINT (-122.37389086 37.73093414) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2521012 2521012 5769578 2016-04-16T13:23:31 2016-05-26T05:41:00 2016-05-26T05:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of ARELIOUS WALKER DR and INNES AVE ARELIOUS WALKER DR 10 Hunters Point BAYVIEW 37.730937957764 -122.37389373779301 POINT (-122.37389374 37.73093796) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2508782 2508782 5808930 2016-04-28T10:14:18 2016-11-08T06:55:12 2016-11-08T06:55:12 Closed 2 HOUSING AUTHORITY PROPERTY DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GRIFFITH ST and INNES AVE GRIFFITH ST 10 Hunters Point BAYVIEW 37.731994961303 -122.375757609877 POINT (-122.37575761 37.73199496) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2970080 2970080 6992082 2017-03-30T11:42:47 2017-08-06T06:40:06 2017-08-06T06:40:06 Closed 2 This service order is not within the scope and will not be accepted. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 951 HUDSON AVE, SAN FRANCISCO, CA, 94124 HUDSON AVE 10 India Basin BAYVIEW 37.733565824496004 -122.37612583747601 POINT (-122.37612584 37.73356582) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
2305516 2305516 4859241 2015-06-27T01:11:57 2015-07-01T08:06:00 2015-07-01T08:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JENNINGS ST and CARGO WAY JENNINGS ST 10 India Basin BAYVIEW 37.74019241333 -122.376846313477 POINT (-122.37684631 37.74019241) Phone   56 2 9 1 8 10 3 58 3 1 1   56   9             2         56
1991628 1991628 4099551 2014-10-12T02:00:55 2014-10-17T07:07:11 2014-10-17T07:07:11 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of CARGO WAY and JENNINGS ST CARGO WAY 10 India Basin BAYVIEW 37.740190876729 -122.37684654951299 POINT (-122.37684655 37.74019088) Phone   56 2 9 1 8 10 3 58 3 1 1   56   9             2         56
2863387 2863387 6895703 2017-03-02T11:12:07 2017-03-07T14:25:53 2017-03-07T14:25:53 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CARGO WAY and JENNINGS ST CARGO WAY 10 India Basin BAYVIEW 37.739989925211 -122.376971421877 POINT (-122.37697142 37.73998993) Mobile/Open311 http://mobile311.sfgov.org/reports/6895703/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
2951353 2951353 6861914 2017-02-21T07:56:48 2017-02-28T16:20:21 2017-02-28T16:20:21 Closed 2 crew needs to pick up branch. and stump. branch is blocking sidewalk, low use. 4.5" dia. 7' long. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BURKE AVE and JENNINGS ST BURKE AVE 10 India Basin BAYVIEW 37.739781634917 -122.377172503734 POINT (-122.3771725 37.73978163) Mobile/Open311 http://mobile311.sfgov.org/reports/6861914/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
237982 237982 9117539 2018-06-10T11:19:00   2018-06-10T12:10:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 101 CARGO WAY, SAN FRANCISCO, CA, 94124 CARGO WAY 10 India Basin BAYVIEW 37.740322113037 -122.37743377685499 POINT (-122.37743378 37.74032211) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
3643185 3643185 10845701 2019-05-10T15:08:00 2019-05-11T20:17:00 2019-05-11T20:17:00 Closed 2 Your request has been received and will be transferred to San Francisco Housing Authority. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of INNES AVE and HAWES ST INNES AVE 10 Hunters Point BAYVIEW 37.733070373535 -122.377647399902 POINT (-122.3776474 37.73307037) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2053284 2053284 4349624 2014-12-31T11:36:04 2015-01-09T08:18:00 2015-01-09T08:18:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of NEWHALL ST and JENNINGS ST NEWHALL ST 10 India Basin BAYVIEW 37.739218213970005 -122.377724776913 POINT (-122.37772478 37.73921821) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
2335328 2335328 5393615 2015-12-21T14:29:25 2015-12-23T05:04:00 2015-12-23T05:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 45 MIDDLE POINT RD, SAN FRANCISCO, CA, 94124 MIDDLE POINT RD 10 India Basin BAYVIEW 37.735430986404 -122.378538748293 POINT (-122.37853875 37.73543099) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
3688923 3688923 10903005 2019-05-23T21:08:00   2019-06-10T20:30:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 1068 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 India Basin BAYVIEW 37.733894348145 -122.37882995605499 POINT (-122.37882996 37.73389435) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
3032938 3032938 7291661 2017-06-23T08:41:03 2017-06-26T05:19:00 2017-06-26T05:19:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing 1068 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 India Basin BAYVIEW 37.733893480477 -122.37883538029101 POINT (-122.37883538 37.73389348) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
2122475 2122475 4473526 2015-02-08T22:36:31 2015-02-18T10:08:00 2015-02-18T10:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1048 GRIFFITH ST, SAN FRANCISCO, CA, 94124 GRIFFITH ST 10 Hunters Point BAYVIEW 37.728655785697 -122.37896581506 POINT (-122.37896582 37.72865579) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
3584695 3584695 11054402 2019-06-27T13:50:00   2019-06-27T14:25:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MIDDLE POINT RD and EVANS AVE MIDDLE POINT RD 10 Bayview BAYVIEW 37.737678527831996 -122.379112243652 POINT (-122.37911224 37.73767853) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3113898 3113898 7466157 2017-08-05T16:03:53 2017-08-08T00:00:00 2017-08-08T00:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of INNES AVE and MIDDLE POINT RD INNES AVE 10 Hunters Point BAYVIEW 37.73407900334 -122.37943151584 POINT (-122.37943152 37.734079) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
194374 194374 9114500 2018-06-09T10:41:00 2018-07-31T11:14:00 2018-07-31T11:14:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of MIDDLE POINT RD and INNES AVE MIDDLE POINT RD 10 Hunters Point BAYVIEW 37.734081268311 -122.379432678223 POINT (-122.37943268 37.73408127) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
129048 129048 5633178 2016-03-05T21:30:17 2016-03-08T02:33:35 2016-03-08T02:33:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of KISKA RD and INGALLS ST KISKA RD 10 Hunters Point BAYVIEW 37.731107645366 -122.37955351316799 POINT (-122.37955351 37.73110765) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2427449 2427449 5394969 2015-12-22T07:03:48 2015-12-22T10:31:00 2015-12-22T10:31:00 Closed 2 resolved: no hangers seen no hazards seen a city crew with white city truck # 661-402 was removing a tree at this location DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of INGALLS ST and HARBOR RD INGALLS ST 10 Hunters Point BAYVIEW 37.733378787201 -122.379932614099 POINT (-122.37993261 37.73337879) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2436740 2436740 5271776 2015-11-10T12:15:00 2015-11-12T11:41:00 2015-11-12T11:41:00 Closed 2 resolved: this is not a DPW tree it is private DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 20 BALDWIN CT, SAN FRANCISCO, CA, 94124 BALDWIN CT 10 Hunters Point BAYVIEW 37.729658362604 -122.38017398262801 POINT (-122.38017398 37.72965836) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2008229 2008229 4215413 2014-11-17T00:10:51 2014-11-18T08:03:31 2014-11-18T08:03:31 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BERTHA LN and HUDSON AVE BERTHA LN 10 Bayview BAYVIEW 37.732421579822 -122.38018509359199 POINT (-122.38018509 37.73242158) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
143281 143281 4473210 2015-02-08T19:23:16 2015-02-13T09:24:00 2015-02-13T09:24:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 54 MIDDLE POINT RD, SAN FRANCISCO, CA, 94124 MIDDLE POINT RD 10 Bayview BAYVIEW 37.736018581747 -122.380276101311 POINT (-122.3802761 37.73601858) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2388778 2388778 5599521 2016-02-24T12:24:09 2016-02-26T05:01:00 2016-02-26T05:01:00 Closed 2 Case Resolved: The stakes were removed on Tree ID 18801 at 11X Lillian St DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LILLIAN ST and ROSIE LEE LN LILLIAN ST 10 Bayview BAYVIEW 37.731847534923 -122.38062626693599 POINT (-122.38062627 37.73184753) Mobile/Open311 http://mobile311.sfgov.org/reports/5599521/photos 86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2004466 2004466 4295313 2014-12-11T17:25:17 2014-12-19T01:07:00 2014-12-19T01:07:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of EVANS AVE and KEITH ST EVANS AVE 10 Bayview BAYVIEW 37.738763073508004 -122.380943946163 POINT (-122.38094395 37.73876307) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2010457 2010457 4295250 2014-12-11T17:00:02 2014-12-15T10:26:50 2014-12-15T10:26:50 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of EVANS AVE and KEITH ST EVANS AVE 10 Bayview BAYVIEW 37.738763073508004 -122.380943946163 POINT (-122.38094395 37.73876307) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
3014659 3014659 7395205 2017-07-19T16:53:38   2017-07-19T17:05:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of KEITH ST and EVANS AVE KEITH ST 10 Bayview BAYVIEW 37.738763073508004 -122.380943946163 POINT (-122.38094395 37.73876307) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2172365 2172365 4468485 2015-02-07T06:24:11 2015-02-18T07:55:00 2015-02-18T07:55:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1066 PALOU AVE, Apt E, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Hunters Point BAYVIEW 37.728401184081996 -122.380996704102 POINT (-122.3809967 37.72840118) Integrated Agency   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
34793 34793 11616241 2019-10-29T08:47:00   2019-10-31T17:15:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BERTHA LN and HARBOR RD BERTHA LN 10 Bayview BAYVIEW 37.7340377 -122.38134070000001 POINT (-122.3813407 37.7340377) Web http://mobile311.sfgov.org/reports/11616241/photos 86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
598082 598082 10487737 2019-02-14T08:31:00 2019-02-16T00:35:13 2019-02-16T00:35:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 92 GARNETT TER, SAN FRANCISCO, CA, 94124 GARNETT TER 10 Bayview BAYVIEW 37.732448577880994 -122.38134765625 POINT (-122.38134766 37.73244858) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2168587 2168587 4617282 2015-03-29T11:49:39 2015-03-31T11:28:00 2015-03-31T11:28:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LA SALLE AVE and INGALLS ST LA SALLE AVE 10 Hunters Point BAYVIEW 37.730580360102 -122.381438939119 POINT (-122.38143894 37.73058036) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2352855 2352855 5453791 2016-01-11T12:32:17 2016-11-15T07:10:05 2016-11-15T07:10:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 5 WHITFIELD CT, SAN FRANCISCO, CA, 94124 WHITFIELD CT 10 Bayview BAYVIEW 37.731090188062 -122.381550874675 POINT (-122.38155087 37.73109019) Mobile/Open311 http://mobile311.sfgov.org/reports/5453791/photos 86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2871313 2871313 6926602 2017-03-11T09:57:58 2017-10-06T07:07:00 2017-10-06T07:07:00 Closed 2 Weeded D10 CCT DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of FAIRFAX AVE and KEITH ST FAIRFAX AVE 10 Bayview BAYVIEW 37.73812149234 -122.38155723233 POINT (-122.38155723 37.73812149) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2070475 2070475 4529516 2015-02-27T09:46:01 2015-10-05T06:08:00 2015-10-05T06:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LA SALLE AVE and WHITFIELD CT LA SALLE AVE 10 Bayview BAYVIEW 37.731174468994006 -122.381607055664 POINT (-122.38160706 37.73117447) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2569958 2569958 5789157 2016-04-22T09:53:51 2016-11-08T06:55:12 2016-11-08T06:55:12 Closed 2 HOUSING AUTHORITY DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1124 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Hunters Point BAYVIEW 37.728988647461 -122.38201904296899 POINT (-122.38201904 37.72898865) Web   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
591387 591387 10493584 2019-02-15T11:44:00   2019-02-15T18:10:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1 CASHMERE ST, SAN FRANCISCO, CA, 94124 CASHMERE ST 10 Bayview BAYVIEW 37.735572814941 -122.382041931152 POINT (-122.38204193 37.73557281) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3571277 3571277 10867363 2019-05-15T20:38:00 2019-05-17T12:57:10 2019-05-17T12:57:10 Closed 2 restake? DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 151 MENDELL ST, SAN FRANCISCO, CA, 94124 MENDELL ST 10 India Basin BAYVIEW 37.743130900000004 -122.3820797 POINT (-122.3820797 37.7431309) Web http://mobile311.sfgov.org/reports/10867363/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
8309 8309 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and HUDSON AVE WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.733631134033 -122.382278442383 POINT (-122.38227844 37.73363113) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1983535 1983535 4347211 2014-12-30T16:01:12 2015-01-06T10:26:00 2015-01-06T10:26:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HUDSON AVE and WHITNEY YOUNG CIR HUDSON AVE 10 Bayview BAYVIEW 37.733629726475 -122.382280518206 POINT (-122.38228052 37.73362973) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2164748 2164748 4589148 2015-03-19T11:42:56 2015-07-07T11:52:00 2015-07-07T11:52:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of HUDSON AVE and WHITNEY YOUNG CIR HUDSON AVE 10 Bayview BAYVIEW 37.733629726475 -122.382280518206 POINT (-122.38228052 37.73362973) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2043260 2043260 4348565 2014-12-31T07:40:52 2015-01-09T08:27:00 2015-01-09T08:27:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 607 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.737047641431 -122.38240514018801 POINT (-122.38240514 37.73704764) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2227334 2227334 5081435 2015-09-09T13:02:16 2015-09-23T12:30:00 2015-09-23T12:30:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1215 QUESADA AVE, SAN FRANCISCO, CA, 94124 QUESADA AVE 10 Hunters Point BAYVIEW 37.728133 -122.38255 POINT (-122.38255 37.728133) Mobile/Open311 http://mobile311.sfgov.org/reports/5081435/photos 78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2782447 2782447 6612509 2016-12-09T15:15:10 2016-12-13T06:10:05 2016-12-13T06:10:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1215 QUESADA AVE, SAN FRANCISCO, CA, 94124 QUESADA AVE 10 Hunters Point BAYVIEW 37.72812319884 -122.382559531887 POINT (-122.38255953 37.7281232) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
43816 43816 10886739 2019-05-20T13:55:00   2019-05-22T17:55:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 655 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.73722076416 -122.38280487060499 POINT (-122.38280487 37.73722076) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2485022 2485022 5760297 2016-04-13T15:31:14 2016-08-01T14:16:18 2016-08-01T14:16:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 619 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.735397973717 -122.38284412722601 POINT (-122.38284413 37.73539797) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3191576 3191576 8118865 2017-10-09T10:36:00 2017-10-10T04:37:00 2017-10-10T04:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of OAKDALE AVE and INGALLS ST OAKDALE AVE 10 Hunters Point BAYVIEW 37.73034286499 -122.38288879394501 POINT (-122.38288879 37.73034286) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1982173 1982173 3963052 2014-08-29T09:09:34 2014-09-22T08:35:28 2014-09-22T08:35:28 Closed 2 resolved: prune all on both sides of 1200 oakdale St @ Ingalls St DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1220 OAKDALE AVE, SAN FRANCISCO, CA, 94124 OAKDALE AVE 10 Bayview BAYVIEW 37.730454684528 -122.382943697121 POINT (-122.3829437 37.73045468) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2063059 2063059 4532031 2015-02-28T02:43:24 2015-03-04T09:29:00 2015-03-04T09:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CARGO WAY and MENDELL ST CARGO WAY 10 India Basin BAYVIEW 37.743881553007 -122.383117903226 POINT (-122.3831179 37.74388155) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
2415790 2415790 5479900 2016-01-19T12:39:31 2016-01-29T07:12:00 2016-01-29T07:12:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of HUDSON AVE and WESTBROOK CT HUDSON AVE 10 Bayview BAYVIEW 37.73497580482 -122.383134345532 POINT (-122.38313435 37.7349758) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2377855 2377855 5394192 2015-12-21T16:37:45 2015-12-23T01:22:00 2015-12-23T01:22:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of INGALLS ST and OAKDALE AVE INGALLS ST 10 Hunters Point BAYVIEW 37.730223356974 -122.383152267325 POINT (-122.38315227 37.73022336) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2029869 2029869 4219834 2014-11-18T09:20:08 2014-11-21T01:03:45 2014-11-21T01:03:45 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1436 INGALLS ST, SAN FRANCISCO, CA, 94124 INGALLS ST 10 Bayview BAYVIEW 37.729966985218 -122.383380952911 POINT (-122.38338095 37.72996699) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2498554 2498554 5736117 2016-04-06T11:42:46 2016-09-02T14:55:09 2016-09-02T14:55:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of PROGRESS ST and WHITNEY YOUNG CIR PROGRESS ST 10 Bayview BAYVIEW 37.733235374236 -122.383408444539 POINT (-122.38340844 37.73323537) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1418434 1418434 1173188 2012-07-23T17:09:03 2013-11-20T13:38:49 2013-11-20T13:38:49 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CASHMERE ST and HUDSON AVE CASHMERE ST 10 Bayview BAYVIEW 37.735801696777 -122.383422851563 POINT (-122.38342285 37.7358017) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2001231 2001231 4347278 2014-12-30T16:17:01 2015-01-07T09:19:00 2015-01-07T09:19:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CASHMERE ST and HUDSON AVE CASHMERE ST 10 Bayview BAYVIEW 37.735801696777 -122.383422851563 POINT (-122.38342285 37.7358017) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3643828 3643828 11033434 2019-06-22T20:50:00   2019-09-09T13:00:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CASHMERE ST and HUDSON AVE CASHMERE ST 10 Bayview BAYVIEW 37.735801696777 -122.383422851563 POINT (-122.38342285 37.7358017) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2106550 2106550 4589142 2015-03-19T11:41:52 2015-10-26T08:43:00 2015-10-26T08:43:00 Closed 2 resolved: the 100 block of Cashmere St - on Cashmere the upper road from Duke Ct going towards Hudson elevate for the busses sidewalk trees and the median landscape side also prune all as needed DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CASHMERE ST and HUDSON AVE CASHMERE ST 10 Bayview BAYVIEW 37.735800726094 -122.383425038029 POINT (-122.38342504 37.73580073) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3525681 3525681 9028979 2018-05-21T11:13:00   2018-09-13T08:00:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 1201 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Bayview BAYVIEW 37.729705810546996 -122.38367462158199 POINT (-122.38367462 37.72970581) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
108207 108207 8076068 2017-09-28T10:40:00 2017-09-29T17:00:00 2017-09-29T17:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of THOMAS AVE and HAWES ST THOMAS AVE 10 Hunters Point BAYVIEW 37.726169586181996 -122.38381195068399 POINT (-122.38381195 37.72616959) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2033890 2033890 4186908 2014-11-07T13:28:23 2014-11-17T08:53:08 2014-11-17T08:53:08 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1367 HUDSON AVE, SAN FRANCISCO, CA, 94124 HUDSON AVE 10 Bayview BAYVIEW 37.737505021263 -122.38420843956001 POINT (-122.38420844 37.73750502) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2241818 2241818 5064825 2015-09-03T19:57:58 2015-10-08T10:35:00 2015-10-08T10:35:00 Closed 2 resolved: tree is on private property no hazard to the public DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 40 GARLINGTON CT, SAN FRANCISCO, CA, 94124 GARLINGTON CT 10 Bayview BAYVIEW 37.732370908842 -122.384216616463 POINT (-122.38421662 37.73237091) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2168341 2168341 4520719 2015-02-24T14:19:23 2015-12-18T01:47:00 2015-12-18T01:47:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 25 GARLINGTON CT, SAN FRANCISCO, CA, 94124 GARLINGTON CT 10 Bayview BAYVIEW 37.732563814913995 -122.384349478458 POINT (-122.38434948 37.73256381) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3585880 3585880 11044859 2019-06-25T14:16:00   2019-06-25T14:40:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GARLINGTON CT and COMMER CT GARLINGTON CT 10 Bayview BAYVIEW 37.732353210449 -122.38449859619101 POINT (-122.3844986 37.73235321) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3500657 3500657 8937245 2018-04-30T09:37:00 2018-05-01T10:46:21 2018-05-01T10:46:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of NEWCOMB AVE and WHITNEY YOUNG CIR NEWCOMB AVE 10 Bayview BAYVIEW 37.733474731445 -122.38454437255899 POINT (-122.38454437 37.73347473) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2140107 2140107 4655082 2015-04-11T09:16:42 2015-04-16T06:45:00 2015-04-16T06:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NEWCOMB AVE and WHITNEY YOUNG CIR NEWCOMB AVE 10 Bayview BAYVIEW 37.733472600689 -122.384548916466 POINT (-122.38454892 37.7334726) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7213 7213 5657133 2016-03-11T17:23:03 2016-03-21T12:11:00 2016-03-21T12:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of INGALLS ST and REVERE AVE INGALLS ST 10 Bayview BAYVIEW 37.7284840677 -122.384557302501 POINT (-122.3845573 37.72848407) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
3092560 3092560 7290848 2017-06-22T20:32:51 2017-06-27T10:25:36 2017-06-27T10:25:36 Closed 2 forwarded to cmms buf. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1500 BURKE AVE, SAN FRANCISCO, CA, 94124 BURKE AVE 10 India Basin BAYVIEW 37.744647287799 -122.384589901308 POINT (-122.3845899 37.74464729) Mobile/Open311 http://mobile311.sfgov.org/reports/7290848/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
1649616 1649616 3186711 2013-12-20T11:33:51 2016-04-11T05:09:44 2016-04-11T05:09:44 Closed 2 This is a Private Tree forwarding to BSM via red button DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 1263 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Bayview BAYVIEW 37.730350771044 -122.384632306751 POINT (-122.38463231 37.73035077) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2136181 2136181 4475515 2015-02-09T12:53:55 2015-04-20T09:05:00 2015-04-20T09:05:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 11 DEDMAN CT, SAN FRANCISCO, CA, 94124 DEDMAN CT 10 Bayview BAYVIEW 37.736766815186 -122.38467407226601 POINT (-122.38467407 37.73676682) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2056181 2056181 4569145 2015-03-12T11:16:37 2015-03-13T11:03:52 2015-03-13T11:03:52 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 51 DEDMAN CT, SAN FRANCISCO, CA, 94124 DEDMAN CT 10 Bayview BAYVIEW 37.736764095962 -122.384677354092 POINT (-122.38467735 37.7367641) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1502617 1502617 1164744 2012-07-11T10:27:04 2013-11-20T13:42:35 2013-11-20T13:42:35 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of EVANS AVE and MENDELL ST EVANS AVE 10 India Basin BAYVIEW 37.740898132324 -122.38470458984399 POINT (-122.38470459 37.74089813) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
1921601 1921601 4296676 2014-12-12T10:46:58 2014-12-16T08:53:00 2014-12-16T08:53:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MENDELL ST and EVANS AVE MENDELL ST 10 India Basin BAYVIEW 37.740897739053004 -122.384706096849 POINT (-122.3847061 37.74089774) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
1940206 1940206 4295310 2014-12-11T17:24:20 2014-12-15T10:25:00 2014-12-15T10:25:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of EVANS AVE and MENDELL ST EVANS AVE 10 India Basin BAYVIEW 37.740897739053004 -122.384706096849 POINT (-122.3847061 37.74089774) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2916373 2916373 7021097 2017-04-07T10:53:35 2017-04-14T13:25:56 2017-04-14T13:25:56 Closed 2 called radio room. transferred to cmms crews. approximately 12' long thickest caliper 4". please pick up branch. along even side (east side) grassy park area DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BELL CT and WHITNEY YOUNG CIR BELL CT 10 Bayview BAYVIEW 37.734285049479 -122.384733906746 POINT (-122.38473391 37.73428505) Web   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2079601 2079601 4464466 2015-02-05T20:08:13 2015-03-13T08:07:00 2015-03-13T08:07:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1500 BURKE AVE, SAN FRANCISCO, CA, 94124 BURKE AVE 10 India Basin BAYVIEW 37.743807200000006 -122.3848212 POINT (-122.3848212 37.7438072) Web http://mobile311.sfgov.org/reports/4464466/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
2161928 2161928 4479223 2015-02-10T12:49:38 2015-03-04T12:25:00 2015-03-04T12:25:00 Closed 2 resolved: Not DPWs responsibility will inspect DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of WHITNEY YOUNG CIR and CARPENTER CT WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.73494261577 -122.384866356924 POINT (-122.38486636 37.73494262) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2123302 2123302 4594819 2015-03-21T15:12:12 2015-03-23T12:57:00 2015-03-23T12:57:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LA SALLE AVE and NEWCOMB AVE LA SALLE AVE 10 Bayview BAYVIEW 37.733070373535 -122.38500213623001 POINT (-122.38500214 37.73307037) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3820799 3820799 11184372 2019-07-26T14:27:00   2019-07-26T15:10:03 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NEWCOMB AVE and LA SALLE AVE NEWCOMB AVE 10 Bayview BAYVIEW 37.733070373535 -122.38500213623001 POINT (-122.38500214 37.73307037) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2081100 2081100 4505155 2015-02-18T16:40:28 2015-02-19T08:09:46 2015-02-19T08:09:46 Closed 2 cancelled: This needs to go to Rec/Park they cut trees down and left this big log in the street on La Salle @ Newcomb St please forward to Rec/Park DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LA SALLE AVE and NEWCOMB AVE LA SALLE AVE 10 Bayview BAYVIEW 37.733069794232 -122.385002167699 POINT (-122.38500217 37.73306979) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2564862 2564862 5687923 2016-03-22T08:22:32 2016-06-01T06:56:00 2016-06-01T06:56:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LA SALLE AVE and NEWCOMB AVE LA SALLE AVE 10 Bayview BAYVIEW 37.733069794232 -122.385002167699 POINT (-122.38500217 37.73306979) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3601183 3601183 11006563 2019-06-17T09:43:00 2019-06-29T05:59:21 2019-06-29T05:59:21 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1295 SHAFTER AVE, SAN FRANCISCO, CA, 94124 SHAFTER AVE 10 Hunters Point BAYVIEW 37.727527618408 -122.385063171387 POINT (-122.38506317 37.72752762) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
130837 130837 5460825 2016-01-13T10:06:48 2016-01-15T08:39:00 2016-01-15T08:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 5 BASS CT, SAN FRANCISCO, CA, 94124 BASS CT 10 Bayview BAYVIEW 37.733752226312 -122.385099028477 POINT (-122.38509903 37.73375223) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
644789 644789 10676975 2019-04-02T12:36:00 2019-04-03T06:08:09 2019-04-03T06:08:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of INGALLS ST and SHAFTER AVE INGALLS ST 10 Hunters Point BAYVIEW 37.72785949707 -122.385116577148 POINT (-122.38511658 37.7278595) Integrated Agency   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
1932927 1932927 4322868 2014-12-21T16:06:28 2014-12-23T10:35:00 2014-12-23T10:35:00 Closed 2 resolved: checked all trees on two blocks of Ingalls st and no trees are falling down some trees are growing at a nan angle but are stable and not uprooting DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of INGALLS ST and SHAFTER AVE INGALLS ST 10 Hunters Point BAYVIEW 37.727859771229 -122.38511903472799 POINT (-122.38511903 37.72785977) Phone     2 9 1 8 10 3 58 3 1 1       9             2          
2133242 2133242 4668110 2015-04-15T15:52:52 2015-04-30T02:22:00 2015-04-30T02:22:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1400 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737500463847 -122.385180276816 POINT (-122.38518028 37.73750046) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2410779 2410779 5395212 2015-12-22T08:31:27 2016-01-02T03:01:00 2016-01-02T03:01:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1400 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737500463847 -122.385180276816 POINT (-122.38518028 37.73750046) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2447697 2447697 5437097 2016-01-06T08:46:33 2016-01-12T06:50:00 2016-01-12T06:50:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1427 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737500463847 -122.385180276816 POINT (-122.38518028 37.73750046) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2143870 2143870 4469689 2015-02-07T12:31:25 2015-02-12T11:57:00 2015-02-12T11:57:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1385 FAIRFAX AVE, SAN FRANCISCO, CA, 94124 FAIRFAX AVE 10 Bayview BAYVIEW 37.740240272297 -122.38528091622 POINT (-122.38528092 37.74024027) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2361049 2361049 5629903 2016-03-04T13:54:01 2016-03-09T11:11:00 2016-03-09T11:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FAIRFAX AVE and MENDELL ST FAIRFAX AVE 10 Bayview BAYVIEW 37.740240272297 -122.38528091622 POINT (-122.38528092 37.74024027) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2506684 2506684 5717728 2016-03-31T13:09:14 2016-08-24T06:40:08 2016-08-24T06:40:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MENDELL ST and FAIRFAX AVE MENDELL ST 10 Bayview BAYVIEW 37.740240272297 -122.38528091622 POINT (-122.38528092 37.74024027) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             1         86
2199574 2199574 5065734 2015-09-04T09:24:05 2015-09-14T07:30:00 2015-09-14T07:30:00 Closed 2 resolved: inspected and nothing found no tree problems seen DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 5 BELL CT, SAN FRANCISCO, CA, 94124 BELL CT 10 Bayview BAYVIEW 37.734350354214 -122.38564392562901 POINT (-122.38564393 37.73435035) Mobile/Open311 http://mobile311.sfgov.org/reports/5065734/photos 86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1999538 1999538 4366315 2015-01-06T09:24:29 2015-01-07T06:17:00 2015-01-07T06:17:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 140 CASHMERE ST, SAN FRANCISCO, CA, 94124 CASHMERE ST 10 Bayview BAYVIEW 37.736847123569 -122.385668698571 POINT (-122.3856687 37.73684712) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2957481 2957481 6998873 2017-04-01T13:32:23 2017-10-08T21:23:12 2017-10-08T21:23:12 Closed 2 Your service request is scheduled for planned maintenance and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of INNES AVE and MENDELL ST INNES AVE 10 Bayview BAYVIEW 37.737783662149 -122.385678627947 POINT (-122.38567863 37.73778366) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
3631374 3631374 10977396 2019-06-10T12:56:00   2019-08-16T09:57:58 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and CASHMERE ST WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.736602783203004 -122.385711669922 POINT (-122.38571167 37.73660278) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86

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