calls

80,878 rows sorted by :@computed_region_f58d_8dbm descending

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
76 76 11537288 2019-10-11T12:20:00 2019-10-11T12:30:06 2019-10-11T12:30:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 775 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 5 Western Addition NORTHERN 37.778961181641 -122.425079345703 POINT (-122.42507935 37.77896118) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
720 720 5686204 2016-03-21T14:47:48 2016-03-22T02:45:00 2016-03-22T02:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 600 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 5 Civic Center NORTHERN 37.779960461199 -122.42219602543301 POINT (-122.42219603 37.77996046) Phone   21 4 11 39 11 7 6 28,852 9 41 41   21 1 11     1       2   1     21
1245 1245 10499981 2019-02-17T14:13:00 2019-10-22T07:17:50 2019-10-22T07:17:50 Closed 2 this tree is stable and is to about to fall. sent to crews for pruning for pruning large branch over street , but still might take a while because it's as their schedule allows. We are trying as hard as possible to prune the city's nearly 125000 street trees so we ask for your patience. pls call 415.554.6700 for updates. Notes:over extended branch on street side , please reduce or remove as time allows. believe it should be addressed before regular maintenance, but it's not super urgent.. B DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1835 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.781707763671996 -122.436645507813 POINT (-122.43664551 37.78170776) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
1343 1343 11368089 2019-09-04T12:29:00   2019-10-22T22:10:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1985 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.781436920166 -122.43878173828101 POINT (-122.43878174 37.78143692) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
6738 6738 11538643 2019-10-11T16:13:00   2019-10-15T07:50:30 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of OFARRELL ST and DIVISADERO ST OFARRELL ST 5 Western Addition NORTHERN 37.782451629639 -122.43930053710899 POINT (-122.43930054 37.78245163) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
7285 7285 5677049 2016-03-18T07:37:17 2016-03-22T03:58:00 2016-03-22T03:58:00 Closed 2 picked up. near trash can by playground at dead end of Ellis. removed from sidewalk DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ELLIS ST and HOLLIS ST ELLIS ST 5 Western Addition NORTHERN 37.782654 -122.42968 POINT (-122.42968 37.782654) Mobile/Open311   97 4 11 39 11 7 6 29,490 9 41 41 8 97   11 9     9     2         97
11535 11535 5652662 2016-03-10T13:32:39 2016-03-17T09:17:07 2016-03-17T09:17:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
13890 13890 9813152 2018-11-15T13:22:06 2018-12-07T07:32:25 2018-12-07T07:32:25 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 - Landscaping 5 Other Intersection of GOUGH ST and ELLIS ST GOUGH ST 5 Cathedral Hill NORTHERN 37.78339704256 -122.424289381376 POINT (-122.42428938 37.78339704) Mobile/Open311   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
14777 14777 11166855 2019-07-23T08:11:00 2019-10-01T12:47:06 2019-10-01T12:47:06 Closed 2 I am assuming this is the tree on the north west corner. it looks like it has been pruned to achieve better visibility. it looks all clear to me. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of SCOTT ST and TURK ST SCOTT ST 5 Western Addition NORTHERN 37.77986907959 -122.43707275390601 POINT (-122.43707275 37.77986908) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
14960 14960 5672447 2016-03-16T16:34:09 2016-04-28T08:51:39 2016-04-28T08:51:39 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LAGUNA ST and REDWOOD ST LAGUNA ST 5 Western Addition NORTHERN 37.779596666667 -122.426895 POINT (-122.426895 37.77959667) Mobile/Open311 http://mobile311.sfgov.org/reports/5672447/photos 97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
16075 16075 11511951 2019-10-06T10:10:07   2019-10-06T10:15:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1100 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 5 Cathedral Hill NORTHERN 37.783916666667 -122.423845 POINT (-122.423845 37.78391667) Mobile/Open311 http://mobile311.sfgov.org/reports/11511951/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
18463 18463 11578073 2019-10-21T06:33:00 2019-10-21T06:37:51 2019-10-21T06:37:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 819 LAGUNA ST, SAN FRANCISCO, CA, 94102 LAGUNA ST 5 Western Addition NORTHERN 37.778480200000004 -122.42692849999999 POINT (-122.4269285 37.7784802) Web   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
19847 19847 5652663 2016-03-10T13:32:40 2016-03-11T07:52:25 2016-03-11T07:52:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
23249 23249 11354275 2019-09-01T13:28:00 2019-10-25T09:38:37 2019-10-25T09:38:37 Closed 2 duplicate request, will be out soon to view tree, will likely be fine just needs portions of dead wood removed. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OLIVE ST and FRANKLIN ST OLIVE ST 5 Cathedral Hill NORTHERN 37.784084320068004 -122.422744750977 POINT (-122.42274475 37.78408432) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
28361 28361 11532774 2019-10-10T13:00:40 2019-10-11T09:20:28 2019-10-11T09:20:28 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 Pruning_request Intersection of STEINER ST and GOLDEN GATE AVE STEINER ST 5 Western Addition NORTHERN 37.779317034296 -122.433563719756 POINT (-122.43356372 37.77931703) Mobile/Open311   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
31120 31120 11606308 2019-10-26T17:42:00 2019-10-26T17:50:08 2019-10-26T17:50:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1311 BUCHANAN ST, SAN FRANCISCO, CA, 94115 BUCHANAN ST 5 Western Addition NORTHERN 37.782062530518 -122.42961120605499 POINT (-122.42961121 37.78206253) Phone   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
31695 31695 11608204 2019-10-27T11:22:00 2019-10-28T06:47:35 2019-10-28T11:51:13 Closed 2 Duplicate Sent to BUF DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1300 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition NORTHERN 37.778622600000006 -122.433619 POINT (-122.433619 37.7786226) Web http://mobile311.sfgov.org/reports/11608204/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
32750 32750 11610967 2019-10-28T08:14:00   2019-10-28T09:29:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1717 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition PARK 37.77733 -122.440422 POINT (-122.440422 37.77733) Mobile/Open311 http://mobile311.sfgov.org/reports/11610967/photos 97 7 11 39 11 15 8 29,492 5 41 41   97   11             1         97
35038 35038 11616812 2019-10-29T10:13:29   2019-10-29T11:10:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1365 SCOTT ST, SAN FRANCISCO, CA, 94115 SCOTT ST 5 Western Addition NORTHERN 37.782414 -122.43786100000001 POINT (-122.437861 37.782414) Web   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
37713 37713 11623135 2019-10-30T14:40:00   2019-10-30T15:35:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of LAGUNA ST and MCALLISTER ST LAGUNA ST 5 Western Addition NORTHERN 37.779258728027 -122.426826477051 POINT (-122.42682648 37.77925873) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
38789 38789 11625450 2019-10-31T08:28:46   2019-10-31T08:35:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1111 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.784683881995 -122.422934857178 POINT (-122.42293486 37.78468388) Web   100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
41014 41014 11363717 2019-09-03T15:47:41 2019-10-09T10:10:43 2019-10-09T10:10:43 Closed 2 inspection made. will review again when area under scheduled maintenance DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1340 LAGUNA ST, SAN FRANCISCO, CA, 94115 LAGUNA ST 5 Cathedral Hill NORTHERN 37.783260600000006 -122.4278085 POINT (-122.4278085 37.7832606) Web   97 4 11 39 11 7 6 29,490 9 41 41 8 97   11 9     9     2         97
41088 41088 11464360 2019-09-25T11:54:53 2019-10-09T09:58:46 2019-10-09T09:58:46 Closed 2 I did not find the tree causing problem. we cannot prioritize pruning off of the cantilevered roof. not an emergency. see online pruning schedule Notes:pruning request . BUF Action:Inspect. date completed - 10/9/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1280 LAGUNA ST, SAN FRANCISCO, CA, 94115 LAGUNA ST 5 Cathedral Hill NORTHERN 37.7827172 -122.4272412 POINT (-122.4272412 37.7827172) Web   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
42066 42066 11524134 2019-10-08T16:09:36 2019-10-09T14:35:28 2019-10-09T14:35:28 Closed 2 this is in an approaching keymap for maintenance DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 452 FULTON ST, SAN FRANCISCO, CA, 94102 FULTON ST 5 Western Addition NORTHERN 37.779337 -122.4247567 POINT (-122.4247567 37.779337) Web http://mobile311.sfgov.org/reports/11524134/photos 97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
43362 43362 11530165 2019-10-09T22:25:23   2019-10-09T22:35:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1531 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94115 GOLDEN GATE AVE 5 Western Addition NORTHERN 37.778735600000005 -122.43669140000002 POINT (-122.4366914 37.7787356) Web http://mobile311.sfgov.org/reports/11530165/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
44343 44343 11574501 2019-10-19T21:08:00 2019-10-19T21:11:15 2019-10-19T21:11:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1210 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.777254 -122.437324 POINT (-122.437324 37.777254) Web   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
48221 48221 11443525 2019-09-20T14:31:02 2019-09-24T12:21:41 2019-09-24T12:21:41 Closed 2 duplicate, will be out to see this tree soon DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of FRANKLIN ST and GOLDEN GATE AVE FRANKLIN ST 5 Civic Center NORTHERN 37.780778999999995 -122.42208600000001 POINT (-122.422086 37.780779) Mobile/Open311 http://mobile311.sfgov.org/reports/11443525/photos 21 4 11 39 11 7 6 28,852 9 41 41   21 1 11     1   8   2   1     21
48576 48576 11447737 2019-09-21T16:59:00 2019-09-25T00:25:11 2019-09-25T00:25:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 300 AUSTIN ST, SAN FRANCISCO, CA, 94109 AUSTIN ST 2 Cathedral Hill NORTHERN 37.788793 -122.423775 POINT (-122.423775 37.788793) Mobile/Open311 http://mobile311.sfgov.org/reports/11447737/photos 100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
49041 49041 11452367 2019-09-23T07:58:00 2019-09-24T13:50:00 2019-09-24T13:50:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of OFARRELL ST and PIERCE ST OFARRELL ST 5 Western Addition NORTHERN 37.782848358154 -122.43602752685499 POINT (-122.43602753 37.78284836) Phone   97 4 11 39 11 13 8 29,490 5 41 41   97   11             2         97
51571 51571 11461907 2019-09-24T20:42:18 2019-09-27T14:39:54 2019-09-27T14:39:54 Closed 2 please contact friends of the urban forest for a replacement tree. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1915 EDDY ST, SAN FRANCISCO, CA, 94115 EDDY ST 5 Anza Vista PARK 37.780250567847 -122.43964532081499 POINT (-122.43964532 37.78025057) Mobile/Open311   13 7 11 39 11 15 8 29,490 5 41 41   13   11             2         13
52530 52530 11464217 2019-09-25T11:29:00 2019-09-25T12:31:00 2019-09-25T12:31:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of MCALLISTER ST and LAGUNA ST MCALLISTER ST 5 Western Addition NORTHERN 37.779258728027 -122.426826477051 POINT (-122.42682648 37.77925873) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
60775 60775 11390123 2019-09-09T11:41:00   2019-10-01T15:25:06 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of EDDY ST and PIERCE ST EDDY ST 5 Western Addition NORTHERN 37.781009674071996 -122.435615539551 POINT (-122.43561554 37.78100967) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
62384 62384 11553734 2019-10-15T12:59:00   2019-10-15T13:05:29 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1961 OFARRELL ST, SAN FRANCISCO, CA, 94115 OFARRELL ST 5 Western Addition NORTHERN 37.782489776611 -122.43675994873001 POINT (-122.43675995 37.78248978) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
62482 62482 11554631 2019-10-15T15:09:00   2019-10-15T15:25:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1315 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.782909393311 -122.42784881591801 POINT (-122.42784882 37.78290939) Phone   97 4 11 39 11 7 6 29,490 9 41 41 8 97   11 9     9     2         97
62484 62484 11554653 2019-10-15T15:11:00   2019-10-15T15:25:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of LAGUNA ST and ELLIS ST LAGUNA ST 5 Cathedral Hill NORTHERN 37.782985687255994 -122.42758178710899 POINT (-122.42758179 37.78298569) Phone   100 4 11 39 11 7 6 28,858 9 41 41 8 100   11 9     9     2         100
66583 66583 11483719 2019-09-30T08:53:00 2019-09-30T12:30:03 2019-09-30T12:30:03 Closed 2 Seperate SR for BUF DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 999 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.77844619751 -122.43865966796899 POINT (-122.43865967 37.7784462) Phone   97 7 11 39 11 15 8 29,490 5 41 41   97   11             1         97
69066 69066 11509252 2019-10-05T13:02:00 2019-10-05T13:14:37 2019-10-05T13:14:37 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 8 SEYMOUR ST, SAN FRANCISCO, CA, 94115 SEYMOUR ST 5 Western Addition NORTHERN 37.779331207275 -122.437637329102 POINT (-122.43763733 37.77933121) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
70955 70955 11356854 2019-09-02T10:51:00 2019-10-01T13:36:48 2019-10-01T13:36:48 Closed 2 Notes:pls remove small stump or make safe with cone. BUF Action:Remove Stump. Notes:pls remove small stump or make safe with cone :: Closed By CMMS SO 1213473. BUF Action:Remove Stump. date completed - 10/1/2019. Notes:pls remove small stump or make safe with cone :: Closed By CMMS SO 1213473from CMMS: . BUF Action:Remove Stump. date completed - 10/1/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1480 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.783091999999996 -122.439481 POINT (-122.439481 37.783092) Mobile/Open311 http://mobile311.sfgov.org/reports/11356854/photos 13 4 11 39 11 15 8 29,490 5 41 41   13   11             2         13
71001 71001 11375414 2019-09-05T18:34:00 2019-10-01T14:52:15 2019-10-01T14:52:15 Closed 2 Notes:tree is leaning, but I believe the lean is stable. shook the tree hard and could not see movement at base. wound in lower trunk and branch failure. should be monitored.. BUF Action:Inspect. date completed - 10/1/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 604 FULTON ST, SAN FRANCISCO, CA, 94102 FULTON ST 5 Western Addition NORTHERN 37.778690338135 -122.427558898926 POINT (-122.4275589 37.77869034) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
71087 71087 11414801 2019-09-14T10:10:00 2019-10-01T15:37:19 2019-10-01T15:37:19 Closed 2 this has been added to our priority list for pruning DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of MCALLISTER ST and LAGUNA ST MCALLISTER ST 5 Western Addition NORTHERN 37.779258728027 -122.426826477051 POINT (-122.42682648 37.77925873) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
71836 71836 11607803 2019-10-27T09:54:00 2019-10-28T06:46:18 2019-10-29T15:20:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1300 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition NORTHERN 37.778622600000006 -122.433619 POINT (-122.433619 37.7786226) Web   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
72447 72447 11564383 2019-10-17T14:10:00 2019-10-19T08:12:00 2019-10-19T08:12:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of ELLIS ST and LAGUNA ST ELLIS ST 5 Cathedral Hill NORTHERN 37.782985687255994 -122.42758178710899 POINT (-122.42758179 37.78298569) Phone   100 4 11 39 11 7 6 28,858 9 41 41 8 100   11 9     9     2         100
73548 73548 11490290 2019-10-01T12:16:33 2019-10-03T13:28:54 2019-10-03T13:28:54 Closed 2 this area will be pruned in the near future as part of grid map 25. please call 4155546700 for updates DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1101 BUCHANAN ST, SAN FRANCISCO, CA, 94115 BUCHANAN ST 5 Western Addition NORTHERN 37.779784226059 -122.42876864836398 POINT (-122.42876865 37.77978423) Mobile/Open311   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2       7 97
75480 75480 11508098 2019-10-05T09:01:00 2019-10-19T08:26:00 2019-10-19T08:26:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of STEINER ST and GOLDEN GATE AVE STEINER ST 5 Western Addition NORTHERN 37.77928285162 -122.43352534460399 POINT (-122.43352534 37.77928285) Mobile/Open311   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
77061 77061 11485178 2019-09-30T12:09:00 2019-10-01T07:48:43 2019-10-01T07:48:43 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1280 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 5 Cathedral Hill NORTHERN 37.78313 -122.42728400000001 POINT (-122.427284 37.78313) Mobile/Open311 http://mobile311.sfgov.org/reports/11485178/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
79849 79849 11564367 2019-10-17T14:07:00   2019-10-17T14:15:36 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 1327 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Alamo Square NORTHERN 37.778205871581996 -122.433891296387 POINT (-122.4338913 37.77820587) Phone   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
80377 80377 11579224 2019-10-21T09:52:00   2019-10-21T10:25:39 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1355 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Cathedral Hill NORTHERN 37.787059783936 -122.423484802246 POINT (-122.4234848 37.78705978) Phone   100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
81241 81241 7034841 2017-04-11T14:53:21 2019-10-01T11:23:00 2019-10-01T11:23:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of FRANKLIN ST and GEARY BLVD FRANKLIN ST 2 Cathedral Hill NORTHERN 37.785481930141 -122.423027715499 POINT (-122.42302772 37.78548193) Phone   100 4 11 39 11 13 6 28,858 9 41 41   100   11         10   1         100
82318 82318 11470454 2019-09-26T16:10:43 2019-10-02T15:54:14 2019-10-02T15:54:14 Closed 2 Request Letter Sent. this is property owner responsibility DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1817 CALIFORNIA ST, SAN FRANCISCO, CA, 94109 CALIFORNIA ST 2 Pacific Heights NORTHERN 37.7899114 -122.4245607 POINT (-122.4245607 37.7899114) Web   102 4 6 39 1 13 6 28,858 9 41 41   102   6             1         102
82583 82583 11478554 2019-09-28T15:40:00 2019-10-02T00:25:13 2019-10-02T00:25:13 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1050 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94115 GOLDEN GATE AVE 5 Western Addition NORTHERN 37.780193328857 -122.427879333496 POINT (-122.42787933 37.78019333) Phone   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
87638 87638 11305137 2019-08-21T17:34:00 2019-10-04T12:19:09 2019-10-04T12:19:09 Closed 2 we will replant the tree as the budget allows. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1188 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.785270690918004 -122.422836303711 POINT (-122.4228363 37.78527069) Phone   100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
89194 89194 9813101 2018-11-15T13:10:02 2019-02-25T13:30:55 2019-02-25T13:30:55 Closed 2 bent trees have adequate clearance from designated path of travel DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of EDDY ST and LAGUNA ST EDDY ST 5 Cathedral Hill NORTHERN 37.782058899999996 -122.42737226054301 POINT (-122.42737226 37.7820589) Mobile/Open311   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
91370 91370 9780882 2018-11-07T19:13:00 2019-02-25T11:36:27 2019-02-25T11:36:27 Closed 2 site has been paved over. original location too close to intersection, new site will need to be cut 6ft to the south. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1295 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Cathedral Hill NORTHERN 37.786170496196 -122.42344056123301 POINT (-122.42344056 37.7861705) Mobile/Open311 http://mobile311.sfgov.org/reports/9780882/photos 100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
91381 91381 9780580 2018-11-07T17:29:49 2019-02-26T11:06:22 2019-02-26T11:06:22 Closed 2 tree has been removed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 50 STARR KING WAY, SAN FRANCISCO, CA, 94109 STARR KING WAY 5 Cathedral Hill NORTHERN 37.784995991702 -122.42378885767201 POINT (-122.42378886 37.78499599) Web http://mobile311.sfgov.org/reports/9780580/photos 100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
92304 92304 11532945 2019-10-10T13:29:00   2019-10-10T13:40:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 880 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.782451629639 -122.422256469727 POINT (-122.42225647 37.78245163) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100 1 11             2         100
96958 96958 9689714 2018-10-18T12:53:00 2019-04-27T03:31:00 2019-04-27T03:31:00 Closed 2 AFTER INSPECTING THE AREA, BUF/YTC WILL ADD WEBSTER MEDIANS BETWEEN TURK ST AND ELLIS ST TO THE WATER SPECIALS LIST. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of WEBSTER ST and TURK ST WEBSTER ST 5 Western Addition NORTHERN 37.780715942383 -122.43042755126999 POINT (-122.43042755 37.78071594) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
97031 97031 9688835 2018-10-18T10:27:45 2019-10-22T07:11:18 2019-10-22T07:11:18 Closed 2 sent to crews for pruning, but still might take a while because it's as their schedule allows. We are trying as hard as possible to prune the city's nearly 125000 street trees so we ask for your patience. pls call 415.554.6700 for updates. Notes:branch over street has multiple weak attachments and i believe it shouod be reduced before the regular pruning cycle, when possible. :: Closed By CMMS SO 1124189. BUF Action:Prune. date completed - 10/22/2019. Notes:branch over street has mult DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1895 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.78166961403 -122.437249426459 POINT (-122.43724943 37.78166961) Web http://mobile311.sfgov.org/reports/9688835/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
97757 97757 9671493 2018-10-14T18:05:00 2019-03-14T09:05:00 2019-03-14T09:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1650 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Pacific Heights NORTHERN 37.789863000000004 -122.42389299999999 POINT (-122.423893 37.789863) Mobile/Open311 http://mobile311.sfgov.org/reports/9671493/photos 102 4 6 39 1 13 6 28,858 9 41 41   102   6             1         102
98149 98149 9655496 2018-10-10T20:20:00 2019-02-25T11:37:40 2019-02-25T11:37:40 Closed 2 Notes:tree does not appear to be severely overgrown. however, the city is systematically pruning tree block by block in order to achieve a 3-5 test pruning cycle, starting with hazardous tree first. Please call 415-554-6700 for more details.. BUF Action:Inspect. date completed - 2/25/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1301 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Cathedral Hill NORTHERN 37.786392202463006 -122.42327318743901 POINT (-122.42327319 37.7863922) Mobile/Open311 http://mobile311.sfgov.org/reports/9655496/photos 100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
98624 98624 9625761 2018-10-04T09:54:20 2019-02-26T11:49:57 2019-02-26T11:49:57 Closed 2 Since StreetTreeSF went into effect on July 1, 2017, we have been working on the worst first. The pruning of the most problematic street trees is prioritized based on safety considerations, to correct structural flaws and to gain necessary clearances for overhead wires, traffic signs and signals, adjacent buildings and traffic flow. Trees that do not pose safety concerns also continue to be pruned by tree crews. You can find out when nearby street trees will be pruned by visiting www.sfpublicwor DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1809 CALIFORNIA ST, SAN FRANCISCO, CA, 94109 CALIFORNIA ST 2 Pacific Heights NORTHERN 37.789951 -122.424361 POINT (-122.424361 37.789951) Mobile/Open311 http://mobile311.sfgov.org/reports/9625761/photos 102 4 6 39 1 13 6 28,858 9 41 41   102   6             1         102
98689 98689 11549369 2019-10-14T14:16:38 2019-10-24T16:27:23 2019-10-24T16:27:23 Closed 2 this tree will be replaced as the budget allows, at the moment we are currently focusing tree planting efforts in low canopy coverage districts. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1939 EDDY ST, SAN FRANCISCO, CA, 94115 EDDY ST 5 Anza Vista PARK 37.780393100000005 -122.43957730000001 POINT (-122.4395773 37.7803931) Web   13 7 11 39 11 15 8 29,490 5 41 41   13   11             2         13
99532 99532 9558556 2018-09-18T15:46:00 2019-02-25T14:24:12 2019-02-25T14:24:12 Closed 2 thank you for reporting the damage. city crews are systematically pruning all trees on a 3-5 year basis and this tree is one the schedule. when work begins they will remove the damaged branch. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of FRANKLIN ST and ELLIS ST FRANKLIN ST 5 Cathedral Hill NORTHERN 37.783618927002 -122.422653198242 POINT (-122.4226532 37.78361893) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
101828 101828 8066279 2017-09-26T10:19:00 2019-05-17T09:53:55 2019-05-17T09:53:55 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1214 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.777254 -122.437324 POINT (-122.437324 37.777254) Web   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
103147 103147 9510769 2018-09-07T18:06:00 2018-09-25T08:28:00 2018-09-25T08:28:00 Closed 2 Per D. Reed. No Irrigation needed DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and TURK ST DIVISADERO ST 5 Anza Vista NORTHERN 37.77965927124 -122.43874359130899 POINT (-122.43874359 37.77965927) Phone   13 4 11 39 11 15 8 29,490 5 41 41   13   11             1         13
103516 103516 9322732 2018-07-27T08:10:00 2018-08-18T07:09:00 2018-08-18T07:09:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of STEINER ST and MCALLISTER ST STEINER ST 5 Alamo Square NORTHERN 37.778423309326 -122.43341064453101 POINT (-122.43341064 37.77842331) Phone   97 4 11 39 11 15 6 29,492 9 41 41   97   11             2         97
103535 103535 9315218 2018-07-25T12:33:00 2018-07-25T12:52:43 2018-07-25T12:52:43 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1778 TURK ST, SAN FRANCISCO, CA, 94115 TURK ST 5 Western Addition NORTHERN 37.779811859130994 -122.438407897949 POINT (-122.4384079 37.77981186) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
107414 107414 8264293 2017-11-13T18:12:07 2017-12-30T13:50:57 2017-12-30T13:50:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of TURK ST and WEBSTER ST TURK ST 5 Western Addition NORTHERN 37.780865000000006 -122.430561050262 POINT (-122.43056105 37.780865) Web   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
111511 111511 7306668 2017-06-27T12:59:06 2017-07-07T08:15:21 2017-07-07T08:15:21 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of DIVISADERO ST and EDDY ST DIVISADERO ST 5 Western Addition NORTHERN 37.780590057373 -122.438926696777 POINT (-122.4389267 37.78059006) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
112641 112641 7180218 2017-05-23T10:48:28 2017-05-26T11:10:27 2017-05-26T11:10:27 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1345 TURK ST, SAN FRANCISCO, CA, 94115 TURK ST 5 Western Addition NORTHERN 37.780320466819 -122.43126260341002 POINT (-122.4312626 37.78032047) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
113880 113880 7057065 2017-04-18T11:56:48 2017-04-25T07:25:22 2017-04-25T07:25:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1450 SUTTER ST, SAN FRANCISCO, CA, 94109 SUTTER ST 2 Cathedral Hill NORTHERN 37.787340663405 -122.424263060102 POINT (-122.42426306 37.78734066) Phone   100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
116772 116772 6769637 2017-01-25T10:59:20 2017-01-31T12:30:43 2017-01-31T12:30:43 Closed 2 an address would have been very helpful. no empty basins found on McAllister near corner of intersection. contacted 1700 MCAllister to appropriately stake trees. Notes:trees need appropriately staked. BUF Action:Inspect. date completed - 1/27/2017. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of MCALLISTER ST and BRODERICK ST MCALLISTER ST 5 Western Addition PARK 37.777586217528 -122.44002695666 POINT (-122.44002696 37.77758622) Phone   97 7 11 39 11 15 8 29,492 5 41 41   97   11             1         97
121478 121478 6447492 2016-10-21T19:14:53 2016-10-21T20:10:20 2016-10-21T20:10:20 Closed 2 1098 - cmp DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FRANKLIN ST and OFARRELL ST FRANKLIN ST 5 Cathedral Hill NORTHERN 37.784545590914995 -122.422837335107 POINT (-122.42283734 37.78454559) Phone   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
122050 122050 6395622 2016-10-07T16:52:19 2016-10-21T14:31:16 2016-10-21T14:31:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GEARY BLVD and STEINER ST GEARY BLVD 5 Western Addition NORTHERN 37.784150490559 -122.434563737386 POINT (-122.43456374 37.78415049) Phone   97 4 11 39 11 13 6 29,490 9 41 41   97   11             2         97
124260 124260 6172458 2016-08-08T17:20:17 2016-08-22T23:26:45 2016-08-22T23:26:45 Closed 2 limbs have been removed. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1345 PIERCE ST, SAN FRANCISCO, CA, 94115 PIERCE ST 5 Western Addition NORTHERN 37.782367 -122.43586699999999 POINT (-122.435867 37.782367) Mobile/Open311 http://mobile311.sfgov.org/reports/6172458/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
128919 128919 5711022 2016-03-29T14:37:55   2016-03-29T14:37:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of DIVISADERO ST and GEARY BLVD DIVISADERO ST 5 Western Addition NORTHERN 37.783307726614 -122.43947003215901 POINT (-122.43947003 37.78330773) Mobile/Open311 http://mobile311.sfgov.org/reports/5711022/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
129049 129049 5633123 2016-03-05T20:55:48 2016-03-08T10:00:00 2016-03-08T10:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FILLMORE ST and MCALLISTER ST FILLMORE ST 5 Alamo Square NORTHERN 37.778631112095 -122.431765489524 POINT (-122.43176549 37.77863111) Phone   23 4 11 39 11 15 6 29,492 9 41 41   23   11             2         23
131847 131847 5016530 2015-08-20T09:22:57 2016-04-11T18:19:23 2016-04-11T18:19:23 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 85 CLEARY CT, SAN FRANCISCO, CA, 94109 CLEARY CT 5 Cathedral Hill NORTHERN 37.783590900374996 -122.426799784419 POINT (-122.42679978 37.7835909) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
131927 131927 4805613 2015-06-05T17:50:11 2016-06-13T01:23:48 2016-06-13T01:23:48 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of ELLIS ST and FRANKLIN ST ELLIS ST 5 Cathedral Hill NORTHERN 37.783617375651005 -122.42265409201799 POINT (-122.42265409 37.78361738) Phone http://mobile311.sfgov.org/reports/4805613/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
131987 131987 4649849 2015-04-09T09:50:49 2016-06-14T02:40:50 2016-06-14T02:40:50 Closed 2 SES Graffiti Crew - Removed Stickers - Pole - Signal Light DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of EDDY ST and STEINER ST EDDY ST 5 Western Addition NORTHERN 37.781218195021 -122.433975128943 POINT (-122.43397513 37.7812182) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
139454 139454 4795433 2015-06-02T16:24:18 2015-06-12T06:50:00 2015-06-12T06:50:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of SCOTT ST and TURK ST SCOTT ST 5 Western Addition NORTHERN 37.779865310455 -122.437072029768 POINT (-122.43707203 37.77986531) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
140399 140399 4710899 2015-05-01T08:51:21 2015-05-07T03:05:59 2015-05-07T03:05:59 Closed 2 resolved: Request Letter Sent. confirming ownership DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 343 AUSTIN ST, SAN FRANCISCO, CA, 94109 AUSTIN ST 2 Cathedral Hill NORTHERN 37.788570404053004 -122.424423217773 POINT (-122.42442322 37.7885704) Web   100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
141277 141277 4631878 2015-04-02T16:42:13 2015-04-04T06:52:22 2015-04-04T06:52:22 Closed 2 cancelled: A maintenance schedule has been updated and will be in the works starting next week. Landscape crews will be weeding and removing debris from the medians. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Web   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
143435 143435 4468167 2015-02-06T20:52:38 2015-02-12T09:15:00 2015-02-12T09:15:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1355 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Cathedral Hill NORTHERN 37.787059400695 -122.423487375692 POINT (-122.42348738 37.7870594) Phone   100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
144937 144937 4346623 2014-12-30T13:34:16 2015-01-06T08:24:26 2015-01-06T08:24:26 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and MCALLISTER ST DIVISADERO ST 5 Western Addition NORTHERN 37.777793884277 -122.43836212158199 POINT (-122.43836212 37.77779388) Integrated Agency   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
146010 146010 9385753 2018-08-10T12:40:10 2018-08-13T10:39:03 2018-08-13T10:39:03 Closed 2 request is in the system for tree planting . thanks for your patience DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1179 PIERCE ST, SAN FRANCISCO, CA, 94115 PIERCE ST 5 Western Addition NORTHERN 37.780785754923 -122.4357165563 POINT (-122.43571656 37.78078575) Mobile/Open311 http://mobile311.sfgov.org/reports/9385753/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
146328 146328 4949079 2015-07-29T07:00:08 2015-07-29T07:43:00 2015-07-29T07:43:00 Closed 2 resolved: Dupe DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GEARY BLVD and LAGUNA ST GEARY BLVD 5 Japantown NORTHERN 37.784953123131 -122.427991152031 POINT (-122.42799115 37.78495312) Phone   101 4 11 39 11 13 6 28,858 9 41 41 8 101   11 9     9     2         101
147937 147937 9073533 2018-05-31T08:17:00 2018-06-12T08:00:00 2018-06-12T08:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 715 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Western Addition NORTHERN 37.780362 -122.42392690000001 POINT (-122.4239269 37.780362) Web   97 4 11 39 11 7 6 28,852 9 41 41   97 1 11             2         97
149214 149214 9323453 2018-07-27T10:03:00 2018-08-07T09:47:00 2018-08-07T09:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SAINT JOSEPHS AVE and TURK ST SAINT JOSEPHS AVE 2 Anza Vista PARK 37.779365539551 -122.440956115723 POINT (-122.44095612 37.77936554) Phone   13 7 6 39 1 15 8 29,490 5 41 41   13   6             2         13
150519 150519 8029451 2017-09-17T12:05:00 2018-04-05T09:31:00 2018-04-05T09:31:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1785 TURK ST, SAN FRANCISCO, CA, 94115 TURK ST 5 Western Addition NORTHERN 37.779576299999995 -122.4384142 POINT (-122.4384142 37.7795763) Web   97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
155355 155355 9401781 2018-08-14T12:44:00 2019-02-05T12:54:29 2019-02-05T12:54:29 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1275 EDDY ST, SAN FRANCISCO, CA, 94115 EDDY ST 5 Western Addition NORTHERN 37.781900310440996 -122.42862592025699 POINT (-122.42862592 37.78190031) Mobile/Open311 http://mobile311.sfgov.org/reports/9401781/photos 97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
155629 155629 9293187 2018-07-20T12:31:00 2019-05-17T09:50:35 2019-05-17T09:50:35 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1106 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 5 Cathedral Hill NORTHERN 37.782307346387 -122.426061295087 POINT (-122.4260613 37.78230735) Mobile/Open311 http://mobile311.sfgov.org/reports/9293187/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
156654 156654 9066092 2018-05-29T17:01:00 2018-07-28T07:31:00 2018-07-28T07:31:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1864 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.782279968262 -122.436813354492 POINT (-122.43681335 37.78227997) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
156658 156658 9275890 2018-07-16T19:17:55   2018-08-01T14:00:59 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 120 SAINT JOSEPHS AVE, SAN FRANCISCO, CA, 94115 SAINT JOSEPHS AVE 2 Anza Vista PARK 37.780497499999996 -122.4410619 POINT (-122.4410619 37.7804975) Web http://mobile311.sfgov.org/reports/9275890/photos 13 7 6 39 1 15 8 29,490 5 41 41   13   6             2         13
158219 158219 9155335 2018-06-19T08:44:00 2018-07-12T13:56:00 2018-07-12T13:56:00 Closed 2 No Palm trees at 921 Divisadero DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 921 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.777963466977 -122.43837305356001 POINT (-122.43837305 37.77796347) Mobile/Open311 http://mobile311.sfgov.org/reports/9155335/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
160759 160759 9094604 2018-06-05T07:35:06 2018-06-07T12:59:28 2018-06-07T12:59:28 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1067 OFARRELL ST, SAN FRANCISCO, CA, 94109 OFARRELL ST 5 Cathedral Hill NORTHERN 37.78463 -122.422036666667 POINT (-122.42203667 37.78463) Mobile/Open311 http://mobile311.sfgov.org/reports/9094604/photos 100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
166471 166471 9126121 2018-06-12T09:54:00 2018-06-27T11:43:27 2018-06-27T11:43:27 Closed 2 tree posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 50 STARR KING WAY, SAN FRANCISCO, CA, 94109 STARR KING WAY 5 Cathedral Hill NORTHERN 37.785085091924 -122.42379653809799 POINT (-122.42379654 37.78508509) Web http://mobile311.sfgov.org/reports/9126121/photos 100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
166535 166535 9142712 2018-06-15T15:22:00 2018-06-30T11:51:07 2018-06-30T11:51:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1047 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 5 Cathedral Hill NORTHERN 37.783617 -122.42314499999999 POINT (-122.423145 37.783617) Mobile/Open311 http://mobile311.sfgov.org/reports/9142712/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
167120 167120 9092094 2018-06-04T14:24:00 2018-06-15T11:10:20 2018-06-15T11:10:20 Closed 2 don't know what this is referring to DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1340 PIERCE ST, SAN FRANCISCO, CA, 94115 PIERCE ST 5 Western Addition NORTHERN 37.782384585624 -122.43585135799101 POINT (-122.43585136 37.78238459) Mobile/Open311 http://mobile311.sfgov.org/reports/9092094/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
167852 167852 9144929 2018-06-16T11:26:00 2018-06-30T11:53:25 2018-06-30T11:53:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1198 TURK ST, SAN FRANCISCO, CA, 94115 TURK ST 5 Western Addition NORTHERN 37.78148651123 -122.428123474121 POINT (-122.42812347 37.78148651) Phone   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
168679 168679 9076166 2018-05-31T14:01:30 2018-06-04T12:23:15 2018-06-04T12:23:15 Closed 2 will post tree for removal. diseased DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1115 WEBSTER ST, SAN FRANCISCO, CA, 94115 WEBSTER ST 5 Western Addition NORTHERN 37.780933000000005 -122.430829 POINT (-122.430829 37.780933) Web   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97

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