calls

80,878 rows sorted by :@computed_region_p5aj_wyqh 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
8940 8940 11504684 2019-10-04T11:42:00 2019-10-08T12:55:55 2019-10-08T12:55:55 Closed 2 not enough information DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of TURK ST and HYDE ST TURK ST 6 Tenderloin TENDERLOIN 37.782585144043004 -122.41569519043001 POINT (-122.41569519 37.78258514) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
14229 14229 11398622 2019-09-10T22:37:06   2019-10-07T09:45:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 410 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.783771666667 -122.414588333333 POINT (-122.41458833 37.78377167) Mobile/Open311 http://mobile311.sfgov.org/reports/11398622/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20 1 10 18     18 6 1 2 1       20
14557 14557 11339611 2019-08-29T08:24:00   2019-10-07T10:05:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 60 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.781170700000004 -122.4135524 POINT (-122.4135524 37.7811707) Web http://mobile311.sfgov.org/reports/11339611/photos 20 5 10 36 9 7 10 28,852 10 36 36   20 1 10     1   6 1 2 1 1     20
29126 29126 11603070 2019-10-25T19:40:00   2019-10-25T20:15:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of TURK ST and HYDE ST TURK ST 6 Tenderloin TENDERLOIN 37.782585144043004 -122.41569519043001 POINT (-122.41569519 37.78258514) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
29286 29286 11536273 2019-10-11T09:57:00   2019-10-11T11:05:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of ADA CT and OFARRELL ST ADA CT 6 Tenderloin TENDERLOIN 37.785449981689 -122.415672302246 POINT (-122.4156723 37.78544998) Phone   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
32956 32956 11611478 2019-10-28T09:29:50 2019-10-29T16:19:29 2019-10-29T16:19:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
32957 32957 11611479 2019-10-28T09:29:53 2019-10-30T11:51:00 2019-10-30T11:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
34054 34054 11614615 2019-10-28T18:02:08   2019-10-28T18:10:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 886 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 3 Downtown / Union Square TENDERLOIN 37.784868219073 -122.40741715293699 POINT (-122.40741715 37.78486822) Mobile/Open311 http://mobile311.sfgov.org/reports/11614615/photos 19 6 3 8 10 14 10 28,852 10 6 6   19   3         5   2         19
37023 37023 11621354 2019-10-30T09:05:00   2019-10-30T09:45:10 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 387 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.784768 -122.41288600000001 POINT (-122.412886 37.784768) Mobile/Open311 http://mobile311.sfgov.org/reports/11621354/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
55243 55243 11472694 2019-09-27T09:20:00   2019-10-30T10:55:07 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 190 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.782726820405 -122.412443891991 POINT (-122.41244389 37.78272682) Mobile/Open311 http://mobile311.sfgov.org/reports/11472694/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
74182 74182 11580874 2019-10-21T13:34:30   2019-10-21T15:50:40 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 75 HYDE ST, SAN FRANCISCO, CA, 94102 HYDE ST 6 Civic Center TENDERLOIN 37.7811191 -122.4156554 POINT (-122.4156554 37.7811191) Web   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   6 1 2 1 1     21
76143 76143 11372569 2019-09-05T10:33:00 2019-10-17T09:48:57 2019-10-17T09:48:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 281 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.784996032715 -122.410751342773 POINT (-122.41075134 37.78499603) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
79743 79743 11563687 2019-10-17T12:18:00 2019-10-17T22:16:10 2019-10-17T22:16:10 Closed 2 Request is a duplicate and has been previously reported as 11562091 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1000 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Tenderloin TENDERLOIN 37.782035827637 -122.410926818848 POINT (-122.41092682 37.78203583) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18 14 1 18 6 1 2 1 1     20
81250 81250 9353225 2018-08-03T06:21:00 2019-10-01T11:37:00 2019-10-01T11:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 251 GEARY ST, SAN FRANCISCO, CA, 94102 GEARY ST 3 Downtown / Union Square CENTRAL 37.787349437176 -122.407355217307 POINT (-122.40735522 37.78734944) Mobile/Open311 http://mobile311.sfgov.org/reports/9353225/photos 19 6 3 8 10 5 10 28,852 10 6 6 10 19   3 12     12 5   2         19
91147 91147 9786956 2018-11-09T09:06:43 2019-02-13T11:38:11 2019-02-13T11:38:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 474 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785373261909 -122.414480949755 POINT (-122.41448095 37.78537326) Mobile/Open311 http://mobile311.sfgov.org/reports/9786956/photos 20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
91181 91181 9786097 2018-11-09T00:39:49 2019-02-13T11:38:05 2019-02-13T11:38:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 474 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785271187348 -122.414758131022 POINT (-122.41475813 37.78527119) Mobile/Open311 http://mobile311.sfgov.org/reports/9786097/photos 20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
93589 93589 11400264 2019-09-11T10:21:00   2019-10-05T15:00:23 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 490 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.783628333333 -122.41558 POINT (-122.41558 37.78362833) Mobile/Open311 http://mobile311.sfgov.org/reports/11400264/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20 1 10 18     18 6 1 2 1       20
99750 99750 9523316 2018-09-10T22:49:34 2019-03-11T12:04:28 2019-03-11T12:04:28 Closed 2 tree has been posted to be removed DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 301 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.785009098269 -122.41133591857 POINT (-122.41133592 37.7850091) Mobile/Open311 http://mobile311.sfgov.org/reports/9523316/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
99841 99841 5647964 2016-03-09T10:11:20 2016-04-11T20:04:45 2016-04-11T20:04:45 Closed 2 Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 366 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Tenderloin TENDERLOIN 37.781752422487 -122.416856289024 POINT (-122.41685629 37.78175242) Mobile/Open311 http://mobile311.sfgov.org/reports/5647964/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18 15 1 18 6 1 2 1 1     20
116270 116270 6811784 2017-02-06T11:46:46   2017-02-06T11:47:53 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 50 HYDE ST, SAN FRANCISCO, CA, 94102 HYDE ST 6 Civic Center TENDERLOIN 37.781424149909995 -122.41530157073299 POINT (-122.41530157 37.78142415) Phone   21 5 10 36 9 7 10 28,852 10 36 36 17 21 1 10 18   1 18 6 1 2 1 1     21
118833 118833 9148114 2018-06-17T13:41:00 2018-06-17T16:19:51 2018-06-17T16:19:51 Closed 2 1098- niu picked up DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 200 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.783031463623 -122.413940429688 POINT (-122.41394043 37.78303146) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
123209 123209 4532160 2015-02-28T07:53:38 2015-06-10T09:47:00 2015-06-10T09:47:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 655 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784217834473 -122.41690063476601 POINT (-122.41690063 37.78421783) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18 15   18 6 1 2 1       20
132887 132887 9092948 2018-06-04T16:29:00 2018-06-05T16:57:00 2018-06-05T16:57:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JONES ST and ELLIS ST JONES ST 6 Tenderloin TENDERLOIN 37.784866333008 -122.41278076171899 POINT (-122.41278076 37.78486633) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
165902 165902 9091550 2018-06-04T13:14:07   2018-06-04T13:25:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 716 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 3 Downtown / Union Square TENDERLOIN 37.787471999999994 -122.404082 POINT (-122.404082 37.787472) Mobile/Open311 http://mobile311.sfgov.org/reports/9091550/photos 19 6 3 8 10 5 10 28,857 10 6 6 10 19   3 12     12 5   2     35   19
169110 169110 9140905 2018-06-15T10:40:00 2018-07-25T11:27:06 2018-07-25T11:27:06 Closed 2 post trees not replaceable due to white zone DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 477 OFARRELL ST, SAN FRANCISCO, CA, 94102 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785781860352 -122.41259765625 POINT (-122.41259766 37.78578186) Phone   20 5 10 36 9 14 10 28,852 10 36 36   20   10         6 1 2 1       20
179968 179968 9130490 2018-06-13T08:52:00 2018-06-28T12:47:57 2018-06-28T12:47:57 Closed 2 tree posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 526 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784701637028 -122.41482820373301 POINT (-122.4148282 37.78470164) Mobile/Open311 http://mobile311.sfgov.org/reports/9130490/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
194767 194767 9140365 2018-06-15T09:20:00 2018-07-25T11:26:46 2018-07-25T11:26:46 Closed 2 post trees not replaceable several dead trees at site, all need to be removed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 477 OFARRELL ST, SAN FRANCISCO, CA, 94102 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785781860352 -122.41259765625 POINT (-122.41259766 37.78578186) Phone   20 5 10 36 9 14 10 28,852 10 36 36   20   10         6 1 2 1       20
194967 194967 9277906 2018-07-17T10:31:00 2018-07-25T12:51:00 2018-07-25T12:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1170 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Civic Center TENDERLOIN 37.779361347328 -122.414297305542 POINT (-122.41429731 37.77936135) Mobile/Open311 http://mobile311.sfgov.org/reports/9277906/photos 21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3 14 1 3 6 1 2 1 1     21
197251 197251 9399747 2018-08-14T07:45:00 2018-08-15T07:06:00 2018-08-15T07:06:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 198 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 6 Civic Center TENDERLOIN 37.780879974365 -122.414939880371 POINT (-122.41493988 37.78087997) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   6 1 2 1 1     21
199092 199092 10957628 2019-06-05T15:25:00 2019-07-12T14:03:02 2019-07-12T14:03:02 Closed 2 restaked DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 270 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 6 Civic Center TENDERLOIN 37.780681610107 -122.41648101806601 POINT (-122.41648102 37.78068161) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   6 1 2 1 1     21
203172 203172 9246654 2018-07-10T08:38:40 2018-07-12T14:29:15 2018-07-12T14:29:15 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 - Damaging_Property 2 Property_damage Intersection of ADA CT and AMITY ALY ADA CT 6 Tenderloin TENDERLOIN 37.785846509068 -122.415731879953 POINT (-122.41573188 37.78584651) Mobile/Open311   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
211203 211203 9078318 2018-05-31T21:41:00 2018-07-13T13:39:00 2018-07-13T13:39:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 450 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.785579681396 -122.412773132324 POINT (-122.41277313 37.78557968) Phone   20 5 10 36 9 14 10 28,852 10 36 36   20   10         6 1 2 1       20
220317 220317 9198061 2018-06-28T11:35:00 2018-07-11T12:40:04 2018-07-11T12:40:04 Closed 2 mini lines clear DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of EDDY ST and JONES ST EDDY ST 6 Tenderloin TENDERLOIN 37.783931732178004 -122.41259765625 POINT (-122.41259766 37.78393173) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
226722 226722 9091701 2018-06-04T13:33:00 2018-06-28T12:53:51 2018-06-28T12:53:51 Closed 2 debris removed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 209 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.783096313477 -122.412498474121 POINT (-122.41249847 37.78309631) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
236744 236744 9090114 2018-06-04T10:11:00 2018-06-14T07:25:07 2018-06-14T07:25:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of HYDE ST and OFARRELL ST HYDE ST 6 Tenderloin TENDERLOIN 37.785377502441 -122.416259765625 POINT (-122.41625977 37.7853775) Phone   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
248232 248232 9257199 2018-07-12T11:25:00 2018-07-14T07:24:01 2018-07-14T07:24:01 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 667 OFARRELL ST, SAN FRANCISCO, CA, 94109 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785414660145 -122.41568174502899 POINT (-122.41568175 37.78541466) Mobile/Open311 http://mobile311.sfgov.org/reports/9257199/photos 20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
250488 250488 9173140 2018-06-22T17:25:00 2018-07-11T13:09:58 2018-07-11T13:09:58 Closed 2 Due to Prop E, trees are to be pruned on a block schedule based on the highest number of high prority trees. Priority considers the health of the tree and dead branches. Your tree will be addressed at a later date and clearance issues will be a consideration of pruning. To see when your area will be under maintenance, please visit was.sfpublicwork.org/streettreesf. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 530 LARKIN ST, SAN FRANCISCO, CA, 94102 LARKIN ST 6 Tenderloin TENDERLOIN 37.7828185 -122.41712759999999 POINT (-122.4171276 37.7828185) Web   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18 15   18 6 1 2 1       20
251388 251388 9272793 2018-07-16T10:38:00 2018-07-16T22:10:17 2018-07-16T22:10:17 Closed 2 Request is a duplicate and has been previously reported as 9272793 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 545 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7861328125 -122.41487121581999 POINT (-122.41487122 37.78613281) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
251697 251697 9258613 2018-07-12T15:12:00 2018-10-30T12:55:02 2018-10-30T12:55:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of JONES ST and EDDY ST JONES ST 6 Tenderloin TENDERLOIN 37.783931732178004 -122.41259765625 POINT (-122.41259766 37.78393173) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
268683 268683 9347418 2018-08-01T16:50:07 2018-11-10T04:41:00 2018-11-10T04:41:00 Closed 2 Notes:from CMMS: Tree Crew Inspected, Work Completed. 11/9/2018. BUF Action:Backfill/Adjust. date completed - 11/10/2018. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LEAVENWORTH ST and GOLDEN GATE AVE LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7818155 -122.41386829999999 POINT (-122.4138683 37.7818155) Web   21 5 10 36 9 7 10 28,852 10 36 36 17 21 1 10 18   1 18 6 1 2 1 1     21
271664 271664 9180508 2018-06-24T22:17:06 2018-06-27T11:20:29 2018-06-27T11:20:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 345 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.784564467297 -122.41283881609199 POINT (-122.41283882 37.78456447) Mobile/Open311   20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
272081 272081 9350111 2018-08-02T11:30:22 2019-07-09T09:10:02 2019-07-09T09:10:02 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 50 UNITED NATIONS PLZ, SAN FRANCISCO, CA, 94102 UNITED NATIONS PLZ 6 Civic Center TENDERLOIN 37.780174 -122.41411000000001 POINT (-122.41411 37.780174) Mobile/Open311   21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1 39   21
274865 274865 9346658 2018-08-01T14:46:00 2018-08-20T11:58:41 2018-08-20T11:58:41 Closed 2 failure to protect tree. how removed tree. will fine contractor DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 334 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 6 Tenderloin TENDERLOIN 37.784046173096 -122.415824890137 POINT (-122.41582489 37.78404617) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
282433 282433 9074866 2018-05-31T11:00:00 2018-06-01T14:06:08 2018-06-01T14:06:08 Closed 2 Due to Prop E, trees are to be pruned on a block schedule based on the highest number of high prority trees. Priority considers the health of the tree and dead branches. Your tree will be addressed at a later date and clearance issues will be a consideration of pruning. To see when your area will be under maintenance, please visit was.sfpublicwork.org/streettreesf. please have PUC contact BUF at 415.554.6700 DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 10 ADA CT, SAN FRANCISCO, CA, 94109 ADA CT 6 Tenderloin TENDERLOIN 37.785888671875 -122.41567993164101 POINT (-122.41567993 37.78588867) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
309935 309935 9591078 2018-09-26T10:39:00 2018-10-02T11:00:10 2018-10-02T11:00:10 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 333 TAYLOR ST, SAN FRANCISCO, CA, 94102 TAYLOR ST 6 Tenderloin TENDERLOIN 37.785458500000004 -122.4114919 POINT (-122.4114919 37.7854585) Web http://mobile311.sfgov.org/reports/9591078/photos 20 5 10 36 9 14 10 28,852 10 36 36   20   10         6 1 2 1       20
310160 310160 9416719 2018-08-17T14:21:22 2018-08-27T14:32:30 2018-08-27T14:32:30 Closed 2 Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 526 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7859766 -122.41458440000001 POINT (-122.4145844 37.7859766) Web http://mobile311.sfgov.org/reports/9416719/photos 20 5 10 36 9 5 10 28,852 10 36 36   20   10           1 2 1       20
311494 311494 9519989 2018-09-10T11:06:00 2018-09-18T09:29:00 2018-09-18T09:29:00 Closed 2 Per D. Reed. We can not replace planter boxes DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 144 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784374237061 -122.409996032715 POINT (-122.40999603 37.78437424) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
312648 312648 9615160 2018-10-02T08:06:00 2018-10-30T12:53:02 2018-10-30T12:53:02 Closed 2 tree not dead yet DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 145 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.782276153564 -122.414016723633 POINT (-122.41401672 37.78227615) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
318200 318200 9483698 2018-09-01T13:29:53 2018-09-18T16:57:43 2018-09-18T16:57:43 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 424 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785069542504 -122.414332986463 POINT (-122.41433299 37.78506954) Mobile/Open311 http://mobile311.sfgov.org/reports/9483698/photos 20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
320412 320412 9615148 2018-10-02T08:02:00 2018-10-30T12:50:36 2018-10-30T12:50:36 Closed 2 tree posted for removal. Will be paved over DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 68 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.781482696533 -122.413627624512 POINT (-122.41362762 37.7814827) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
333883 333883 9751195 2018-11-01T10:46:00 2018-11-09T08:17:10 2018-11-09T08:17:10 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 324 LARKIN ST, SAN FRANCISCO, CA, 94102 LARKIN ST 6 Civic Center TENDERLOIN 37.780941009521 -122.416885375977 POINT (-122.41688538 37.78094101) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10   15 1   6 1 2 1 1     21
344300 344300 9438177 2018-08-22T14:16:00 2018-08-22T22:05:32 2018-08-22T22:05:32 Closed 2 Request is a duplicate and has been previously reported as 9438177 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 609 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784409024788 -122.41621649835501 POINT (-122.4162165 37.78440902) Mobile/Open311 http://mobile311.sfgov.org/reports/9438177/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
353454 353454 9542076 2018-09-14T14:59:00 2018-09-14T16:57:33 2018-09-14T16:57:33 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 201 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.782810211181996 -122.412948608398 POINT (-122.41294861 37.78281021) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
356594 356594 9438802 2018-08-22T15:53:00   2019-02-07T12:20:06 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 632 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784477233887 -122.41672515869101 POINT (-122.41672516 37.78447723) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
356749 356749 9612044 2018-10-01T13:09:00 2018-10-30T12:55:13 2018-10-30T12:55:13 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of EDDY ST and LEAVENWORTH ST EDDY ST 6 Tenderloin TENDERLOIN 37.783721923828004 -122.414237976074 POINT (-122.41423798 37.78372192) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
367451 367451 9436712 2018-08-22T10:47:00 2018-08-24T16:46:19 2018-08-24T16:46:19 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 516 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784847607871 -122.414695434386 POINT (-122.41469543 37.78484761) Mobile/Open311 http://mobile311.sfgov.org/reports/9436712/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
370245 370245 9602990 2018-09-28T21:56:46 2018-10-01T14:18:00 2018-10-01T14:18:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 227 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.785233333333004 -122.41008000000001 POINT (-122.41008 37.78523333) Mobile/Open311 http://mobile311.sfgov.org/reports/9602990/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
376034 376034 9438184 2018-08-22T14:18:00 2018-08-27T12:07:12 2018-08-27T12:07:12 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 644 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784322565457 -122.416801722834 POINT (-122.41680172 37.78432257) Mobile/Open311 http://mobile311.sfgov.org/reports/9438184/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
376554 376554 9718202 2018-10-25T01:39:35 2019-04-18T08:46:34 2019-04-18T08:46:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 301 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.784996505961 -122.411424617599 POINT (-122.41142462 37.78499651) Mobile/Open311 http://mobile311.sfgov.org/reports/9718202/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
377902 377902 9460720 2018-08-27T16:58:00   2019-06-12T16:44:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 240 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Tenderloin TENDERLOIN 37.781883239746 -122.41455078125 POINT (-122.41455078 37.78188324) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
380162 380162 9643267 2018-10-08T13:26:00 2018-10-30T13:19:03 2018-10-30T13:19:03 Closed 2 tree ok DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 628 OFARRELL ST, SAN FRANCISCO, CA, 94109 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785629272461 -122.415176391602 POINT (-122.41517639 37.78562927) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
391952 391952 9483704 2018-09-01T13:30:58 2018-10-30T13:24:06 2018-10-30T13:24:06 Closed 2 posted tree for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 434 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785262961167 -122.41442950204399 POINT (-122.4144295 37.78526296) Mobile/Open311 http://mobile311.sfgov.org/reports/9483704/photos 20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
393363 393363 9585100 2018-09-25T07:26:33 2018-10-02T11:18:53 2018-10-02T11:18:53 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 - Damaging_Property 2 Property_damage Intersection of ADA CT and AMITY ALY ADA CT 6 Tenderloin TENDERLOIN 37.785780103429 -122.41573685991999 POINT (-122.41573686 37.7857801) Mobile/Open311   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
399421 399421 9574464 2018-09-22T09:11:00 2018-09-27T11:49:21 2018-09-27T11:49:21 Closed 2 landscaping is permitted and allows for a clear path of travel DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 238 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784168243408 -122.411636352539 POINT (-122.41163635 37.78416824) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
400449 400449 9606012 2018-09-29T21:12:48 2018-10-01T14:17:39 2018-10-01T14:17:39 Closed 2 Due to Prop E, the City of San Francisco has taken back responsibility and maintenance of all street trees. We will be pruning trees on a block by block schedule and dealing with the worst first. You can check when your tree will be pruned at www.sfpublicworks.org/trees Thank you for your patience. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 245 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.783354503586004 -122.414257103456 POINT (-122.4142571 37.7833545) Mobile/Open311   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
406373 406373 9521118 2018-09-10T13:36:00 2018-09-13T13:03:10 2018-09-13T13:03:10 Closed 2 planted boxes are permitted and allow a clear path of travel. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 144 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784374237061 -122.409996032715 POINT (-122.40999603 37.78437424) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
410442 410442 9683089 2018-10-17T08:36:00   2018-11-10T15:00:11 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 477 OFARRELL ST, SAN FRANCISCO, CA, 94102 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785781860352 -122.41259765625 POINT (-122.41259766 37.78578186) Phone   20 5 10 36 9 14 10 28,852 10 36 36   20   10         6 1 2 1       20
419542 419542 9552251 2018-09-17T12:22:00 2018-10-30T12:03:55 2018-10-30T12:03:55 Closed 2 light is still visible 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 DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of HYDE ST and FULTON ST HYDE ST 6 Civic Center TENDERLOIN 37.779788970946996 -122.41513061523399 POINT (-122.41513062 37.77978897) Phone   21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1 39   21
424590 424590 9436673 2018-08-22T10:43:00 2018-08-23T00:23:00 2018-08-23T00:23:00 Closed 2 Your tree planting request has been received and will be transferred to the tree inspectors. Thank you. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 525 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785883485375 -122.41477062005801 POINT (-122.41477062 37.78588349) Mobile/Open311 http://mobile311.sfgov.org/reports/9436673/photos 20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
426013 426013 9737422 2018-10-29T15:14:00 2018-11-01T21:56:00 2018-11-01T21:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 256 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.782988082653 -122.413350138927 POINT (-122.41335014 37.78298808) Mobile/Open311 http://mobile311.sfgov.org/reports/9737422/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
433534 433534 9919336 2018-12-11T09:44:00   2019-04-24T10:15:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 555 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784419 -122.41543300000001 POINT (-122.415433 37.784419) Mobile/Open311 http://mobile311.sfgov.org/reports/9919336/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
439697 439697 9985244 2018-12-28T10:45:00 2019-01-07T13:58:37 2019-01-07T13:58:37 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 609 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.7844 -122.416191666667 POINT (-122.41619167 37.7844) Mobile/Open311 http://mobile311.sfgov.org/reports/9985244/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
455852 455852 10381133 2019-01-20T07:27:00 2019-01-21T08:25:00 2019-01-21T08:25:00 Closed 2 a frame place around tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 639 GEARY ST, SAN FRANCISCO, CA, 94102 GEARY ST 6 Tenderloin CENTRAL 37.786544799805 -122.41366577148399 POINT (-122.41366577 37.7865448) Phone   20 5 10 36 9 5 10 28,852 10 36 36   20   10           1 2 1       20
460299 460299 10366586 2019-01-16T19:23:44   2019-02-13T14:10:03 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 665 GEARY ST, SAN FRANCISCO, CA, 94102 GEARY ST 6 Tenderloin CENTRAL 37.786298724858 -122.414119346181 POINT (-122.41411935 37.78629872) Mobile/Open311   20 5 10 36 9 5 10 28,852 10 36 36   20   10           1 2 1       20
464522 464522 9975363 2018-12-25T16:47:04 2018-12-28T09:53:27 2018-12-28T09:53:27 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 141 MASON ST, SAN FRANCISCO, CA, 94102 MASON ST 6 Tenderloin TENDERLOIN 37.784703333333 -122.41005 POINT (-122.41005 37.78470333) Mobile/Open311 http://mobile311.sfgov.org/reports/9975363/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
475734 475734 9784108 2018-11-08T13:38:00 2019-05-17T09:46:00 2019-05-17T09:46:00 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1244 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Civic Center TENDERLOIN 37.77823638916 -122.415733337402 POINT (-122.41573334 37.77823639) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10   14 1   7 1 2 1 1     21
499913 499913 10373555 2019-01-18T09:06:00 2019-07-12T14:47:13 2019-07-12T14:47:13 Closed 2 not found DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 545 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7861328125 -122.41487121581999 POINT (-122.41487122 37.78613281) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
522313 522313 9985171 2018-12-28T10:34:00 2019-02-13T11:36:06 2019-02-13T11:36:06 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 609 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.78437 -122.41621333333299 POINT (-122.41621333 37.78437) Mobile/Open311 http://mobile311.sfgov.org/reports/9985171/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
526299 526299 9788362 2018-11-09T13:06:00 2019-07-26T10:20:48 2019-07-26T10:20:48 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 121 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Tenderloin TENDERLOIN 37.781749725342 -122.41252136230499 POINT (-122.41252136 37.78174973) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
529178 529178 9828342 2018-11-19T15:14:58 2018-11-26T15:28:47 2018-11-26T15:28:47 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 POWELL ST, SAN FRANCISCO, CA, 94102 POWELL ST 3 Downtown / Union Square CENTRAL 37.785219399999995 -122.4073716 POINT (-122.4073716 37.7852194) Mobile/Open311 http://mobile311.sfgov.org/reports/9828342/photos 19 6 3 8 10 14 10 28,852 10 6 6   19   3         5   2         19
531318 531318 10356057 2019-01-14T13:23:14 2019-01-18T15:47:08 2019-01-18T15:47:08 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 220 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.783325 -122.412461666667 POINT (-122.41246167 37.783325) Mobile/Open311 http://mobile311.sfgov.org/reports/10356057/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
535961 535961 10381659 2019-01-20T11:00:36 2019-03-06T12:18:18 2019-03-06T12:18:18 Closed 2 tree ok DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 50 OFARRELL ST, SAN FRANCISCO, CA, 94108 OFARRELL ST 3 Downtown / Union Square CENTRAL 37.786893672345 -122.405824279527 POINT (-122.40582428 37.78689367) Mobile/Open311 http://mobile311.sfgov.org/reports/10381659/photos 19 6 3 8 10 5 10 28,857 10 6 6 10 19   3 12     12 5   2         19
556208 556208 9965791 2018-12-22T08:17:00 2018-12-28T09:54:24 2018-12-28T09:54:24 Closed 2 The city took back responsibility of trees in the public right of way July 2017. unfortunately, it is going to take us time to get all trees pruned. we are currently following the zone map prioritization resulting from a census we had performed before we took back responsibility. the city is not immediately responsible for anything that exists come July 1, 2017. homeowners were required to maintain their trees before StreetTreeSF began and had they not maintained them all those years, the homeow DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 246 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784183502196996 -122.411766052246 POINT (-122.41176605 37.7841835) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1     30 20
556427 556427 9985161 2018-12-28T10:33:00 2019-02-13T11:38:44 2019-02-13T11:38:44 Closed 2 in queue to remove and plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 526 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.78465 -122.414916666667 POINT (-122.41491667 37.78465) Mobile/Open311 http://mobile311.sfgov.org/reports/9985161/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
565294 565294 10535993 2019-02-26T10:43:43 2019-03-28T12:34:17 2019-03-28T12:34:17 Closed 2 in queue to pave over DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 486 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.78365 -122.41554166666701 POINT (-122.41554167 37.78365) Mobile/Open311 http://mobile311.sfgov.org/reports/10535993/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20 1 10 18     18 6 1 2 1       20
566305 566305 10740635 2019-04-17T09:58:53 2019-04-18T08:23:35 2019-04-18T08:23:35 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 124 MASON ST, SAN FRANCISCO, CA, 94102 MASON ST 3 Downtown / Union Square TENDERLOIN 37.784771666667 -122.409325 POINT (-122.409325 37.78477167) Mobile/Open311 http://mobile311.sfgov.org/reports/10740635/photos 19 5 3 36 10 14 10 28,852 10 36 36 17 19   3 18     18 5 1 2 1       19
569541 569541 10539478 2019-02-27T07:40:00   2019-03-01T10:40:02 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 45 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.781387329102 -122.412216186523 POINT (-122.41221619 37.78138733) Phone   20 5 10 36 9 7 10 28,852 10 36 36   20 1 10     1   6 1 2 1 1     20
580237 580237 10598682 2019-03-13T17:28:00   2019-06-07T14:30:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LEAVENWORTH ST and MCALLISTER ST LEAVENWORTH ST 6 Civic Center TENDERLOIN 37.780925750732 -122.413673400879 POINT (-122.4136734 37.78092575) Phone http://mobile311.sfgov.org/reports/10598682/photos 21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
580931 580931 10537791 2019-02-26T15:21:00 2019-03-04T22:37:32 2019-03-04T22:37:32 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 - Damaging_Property 2 Hitting_window_or_building 545 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7861328125 -122.41487121581999 POINT (-122.41487122 37.78613281) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
583616 583616 10754957 2019-04-20T14:13:00 2019-04-20T16:26:45 2019-04-20T16:26:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 100 LARKIN ST, SAN FRANCISCO, CA, 94102 LARKIN ST 6 Civic Center TENDERLOIN 37.779079437255994 -122.41644287109399 POINT (-122.41644287 37.77907944) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   8 1 2 1 1     21
584006 584006 10457580 2019-02-06T15:15:00 2019-02-13T11:50:29 2019-02-13T11:50:29 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 - Damaging_Property 2 Hitting_window_or_building 545 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.7861328125 -122.41487121581999 POINT (-122.41487122 37.78613281) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
584389 584389 10534996 2019-02-26T08:18:00 2019-02-27T10:44:00 2019-02-27T10:44:00 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JONES ST and GOLDEN GATE AVE JONES ST 6 Tenderloin TENDERLOIN 37.782073974609 -122.41222381591801 POINT (-122.41222382 37.78207397) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
595009 595009 10754594 2019-04-20T12:51:00 2019-04-27T06:56:00 2019-04-27T06:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 240 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784168243408 -122.41164398193399 POINT (-122.41164398 37.78416824) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
599396 599396 10720244 2019-04-12T10:23:00 2019-04-15T15:27:42 2019-04-15T15:27:42 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 - Damaging_Property 2 Hitting_window_or_building 96 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 6 Tenderloin TENDERLOIN 37.781169891357 -122.41349029541 POINT (-122.4134903 37.78116989) Phone   20 5 10 36 9 7 10 28,852 10 36 36   20 1 10     1   6 1 2 1 1     20
602033 602033 10753343 2019-04-20T07:12:00 2019-04-26T14:06:00 2019-04-26T14:06:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 100 LARKIN ST, SAN FRANCISCO, CA, 94102 LARKIN ST 6 Civic Center TENDERLOIN 37.779079437255994 -122.41644287109399 POINT (-122.41644287 37.77907944) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   8 1 2 1 1     21
620043 620043 10481467 2019-02-12T16:03:00 2019-02-13T11:37:52 2019-02-13T11:37:52 Closed 2 in queue to remove and replace DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 628 OFARRELL ST, SAN FRANCISCO, CA, 94109 OFARRELL ST 6 Tenderloin TENDERLOIN 37.785629272461 -122.415176391602 POINT (-122.41517639 37.78562927) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
625382 625382 10751390 2019-04-19T14:34:00 2019-04-19T16:33:00 2019-04-19T16:33:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 256 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.783078551415 -122.413264550264 POINT (-122.41326455 37.78307855) Mobile/Open311 http://mobile311.sfgov.org/reports/10751390/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
631426 631426 10488966 2019-02-14T11:41:00 2019-06-17T15:44:37 2019-06-17T15:44:37 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 350 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.782802581787 -122.41487121581999 POINT (-122.41487122 37.78280258) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
631919 631919 10712176 2019-04-10T13:28:00 2019-04-10T13:39:03 2019-04-10T13:39:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ADA CT and OFARRELL ST ADA CT 6 Tenderloin TENDERLOIN 37.785449981689 -122.415672302246 POINT (-122.4156723 37.78544998) Phone   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
639200 639200 10754687 2019-04-20T13:09:00 2019-04-27T06:56:00 2019-04-27T06:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 249 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.783920288086 -122.41175079345699 POINT (-122.41175079 37.78392029) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20

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.752ms