calls

80,878 rows where Category = 1 sorted by :@computed_region_n4xg_c4py 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
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
2998 2998 11509292 2019-10-05T13:11:46 2019-10-07T12:45:39 2019-10-07T12:45:39 Closed 2 contacted property owner who is responsible DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.774400185043 -122.42094753614401 POINT (-122.42094754 37.77440019) Mobile/Open311 http://mobile311.sfgov.org/reports/11509292/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1 1 1     21
3438 3438 11512959 2019-10-06T14:23:32 2019-10-07T09:35:32 2019-10-07T09:35:32 Closed 2 the tree was inspected in May. our records do not indicate we are removing it. twig dieback normal for species Notes:request to replace tree. BUF Action:Inspect. date completed - 10/7/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 475 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 5 Civic Center NORTHERN 37.7797 -122.42 POINT (-122.42 37.7797) Mobile/Open311   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
8224 8224 11622531 2019-10-30T12:14:01   2019-10-30T12:20:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 229 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.77590386573 -122.41107587714 POINT (-122.41107588 37.77590387) Mobile/Open311 http://mobile311.sfgov.org/reports/11622531/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
10942 10942 11521677 2019-10-08T09:52:00 2019-10-08T15:40:23 2019-10-08T15:40:23 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 269 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 9 Mission MISSION 37.768268077669 -122.419259715939 POINT (-122.41925972 37.76826808) Mobile/Open311 http://mobile311.sfgov.org/reports/11521677/photos 53 3 2 20 7 8 7 28,853 4 19 19 12 53 1 2 14   3 14     2   3     53
11527 11527 11523858 2019-10-08T15:18:00   2019-10-08T16:06:54 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 700 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin NORTHERN 37.783176422119006 -122.419464111328 POINT (-122.41946411 37.78317642) Phone   20 4 10 36 9 7 6 28,858 9 36 36   20 1 10   16       1 2 1       20
11534 11534 11523890 2019-10-08T15:24:00 2019-10-08T16:26:33 2019-10-08T16:26:33 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1275 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.777725219727 -122.41565704345699 POINT (-122.41565704 37.77772522) Phone   32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   7 1 2 1 1 35   32
12237 12237 11589182 2019-10-23T08:46:00   2019-10-23T08:55:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of HAYES ST and GOUGH ST HAYES ST 5 Hayes Valley NORTHERN 37.776882171630994 -122.42298126220699 POINT (-122.42298126 37.77688217) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22 1 11     1   8   1   1     22
13822 13822 11436869 2019-09-19T10:24:37   2019-10-07T10:35:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1050 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.778998120602004 -122.408549997126 POINT (-122.40855 37.77899812) Mobile/Open311 http://mobile311.sfgov.org/reports/11436869/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
13853 13853 9813716 2018-11-15T14:56:00 2018-11-17T07:26:00 2018-11-17T07:26:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRADY ST and STEVENSON ST BRADY ST 6 South of Market SOUTHERN 37.773162841796996 -122.420776367188 POINT (-122.42077637 37.77316284) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
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
18293 18293 11523897 2019-10-08T15:25:00   2019-10-08T16:35:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 704 POLK ST, SAN FRANCISCO, CA, 94109 POLK ST 6 Tenderloin NORTHERN 37.783275 -122.419183 POINT (-122.419183 37.783275) Mobile/Open311 http://mobile311.sfgov.org/reports/11523897/photos 20 4 10 36 9 7 6 28,858 9 36 36   20 1 10           1 2 1       20
22654 22654 11236529 2019-08-06T20:59:00 2019-08-14T14:07:00 2019-08-14T14:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 21 BRADY ST, SAN FRANCISCO, CA, 94103 BRADY ST 6 South of Market SOUTHERN 37.773153333333 -122.420721666667 POINT (-122.42072167 37.77315333) Mobile/Open311 http://mobile311.sfgov.org/reports/11236529/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
22668 22668 5649574 2016-03-09T15:18:01 2016-06-14T08:30:00 2016-06-14T08:30:00 Closed 2 1098 Duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1779 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 9 Mission MISSION 37.768634843156 -122.41520756759701 POINT (-122.41520757 37.76863484) Mobile/Open311 http://mobile311.sfgov.org/reports/5649574/photos 53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
25528 25528 11594922 2019-10-24T09:49:00 2019-10-26T07:51:01 2019-10-26T07:51:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of NATOMA ST and 11TH ST NATOMA ST 6 South of Market SOUTHERN 37.773532867431996 -122.41610717773399 POINT (-122.41610718 37.77353287) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
26751 26751 11400773 2019-09-11T11:34:00   2019-10-11T13:35:30 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1133 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776093532633 -122.408640999348 POINT (-122.408641 37.77609353) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
27835 27835 11601292 2019-10-25T13:28:26 2019-10-28T10:06:25 2019-10-25T13:35:50 Closed 2 there is a 6ft path of travel DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 50 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 6 South of Market SOUTHERN 37.773872999999995 -122.419132 POINT (-122.419132 37.773873) Mobile/Open311 http://mobile311.sfgov.org/reports/11601292/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1   8 1 2 1 1     32
28434 28434 11602216 2019-10-25T15:56:00   2019-10-25T16:10:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 100 RUSS ST, SAN FRANCISCO, CA, 94103 RUSS ST 6 South of Market SOUTHERN 37.778785705566 -122.408271789551 POINT (-122.40827179 37.77878571) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
28945 28945 11535433 2019-10-11T07:39:00   2019-10-11T08:10:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 448 TEHAMA ST, SAN FRANCISCO, CA, 94103 TEHAMA ST 6 South of Market SOUTHERN 37.780122530216 -122.40572688586501 POINT (-122.40572689 37.78012253) Mobile/Open311 http://mobile311.sfgov.org/reports/11535433/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
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
31826 31826 11608748 2019-10-27T13:27:00   2019-10-31T07:45:45 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 131 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.77628922785 -122.4199512132 POINT (-122.41995121 37.77628923) Mobile/Open311 http://mobile311.sfgov.org/reports/11608748/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
31829 31829 11608754 2019-10-27T13:28:34 2019-10-28T07:09:14 2019-10-29T15:15:12 Closed 2 Sending Arborist DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 131 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.776306152344 -122.42004359152399 POINT (-122.42004359 37.77630615) Mobile/Open311 http://mobile311.sfgov.org/reports/11608754/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
32851 32851 11611192 2019-10-28T08:48:00   2019-10-28T09:05:42 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1275 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.777725219727 -122.41565704345699 POINT (-122.41565704 37.77772522) Phone   32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   7 1 2 1 1 35   32
33296 33296 11612419 2019-10-28T11:42:00 2019-11-01T08:08:00 2019-10-30T12:00:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of LASKIE ST and MISSION ST LASKIE ST 6 South of Market SOUTHERN 37.776706695556996 -122.414108276367 POINT (-122.41410828 37.7767067) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1   7 1 2 1 1     32
33742 33742 11613782 2019-10-28T15:12:00 2019-10-28T15:28:04 2019-10-28T15:49:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 226 6TH ST, SAN FRANCISCO, CA, 94103 6TH ST 6 South of Market SOUTHERN 37.77921295166 -122.406753540039 POINT (-122.40675354 37.77921295) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6 14 1 6     2   1     32
38735 38735 11625346 2019-10-31T08:07:00   2019-10-31T22:33:07 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 200 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.776214335043 -122.420972473919 POINT (-122.42097247 37.77621434) Mobile/Open311 http://mobile311.sfgov.org/reports/11625346/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
40028 40028 11628418 2019-10-31T17:19:00   2019-10-31T22:37:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 910 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.780159139512 -122.40373794047501 POINT (-122.40373794 37.78015914) Web http://mobile311.sfgov.org/reports/11628418/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         4   2         32
43341 43341 11529967 2019-10-09T20:28:54   2019-10-09T20:35:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 15 LANGTON ST, SAN FRANCISCO, CA, 94103 LANGTON ST 6 South of Market SOUTHERN 37.777315 -122.409586 POINT (-122.409586 37.777315) Mobile/Open311 http://mobile311.sfgov.org/reports/11529967/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
43895 43895 10870536 2019-05-16T11:56:00 2019-05-30T11:36:00 2019-05-30T11:36:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1450 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.773590999999996 -122.414852 POINT (-122.414852 37.773591) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
44666 44666 11495842 2019-10-02T14:12:47 2019-10-07T10:30:06 2019-10-07T10:30:06 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 45 11TH ST, SAN FRANCISCO, CA, 94103 11TH ST 6 South of Market TENDERLOIN 37.775027561009004 -122.41788962202101 POINT (-122.41788962 37.77502756) Web http://mobile311.sfgov.org/reports/11495842/photos 32 5 10 34 9 8 2 28,853 2 34 34   32 1 10     1   8 1 2 1 1     32
45748 45748 10713753 2019-04-10T18:26:00 2019-09-27T11:02:47 2019-09-27T11:02:47 Closed 2 Notes - Needs more information - Thank you, ACraven946 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of MARKET ST and 6TH ST MARKET ST 6 Tenderloin TENDERLOIN 37.782230377196996 -122.410293579102 POINT (-122.41029358 37.78223038) Phone   20 5 10 34 9 14 2 28,853 2 34 34 17 20 1 10 18   1 18 7 1 2 1 1 35   20
47515 47515 11429566 2019-09-17T16:27:45   2019-09-25T15:30:01 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 740 NATOMA ST, SAN FRANCISCO, CA, 94103 NATOMA ST 6 South of Market SOUTHERN 37.7762081 -122.41300179999999 POINT (-122.4130018 37.7762081) Web   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1     1 2 1 1     32
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
49379 49379 11454475 2019-09-23T12:41:00 2019-09-24T08:12:14 2019-09-24T08:12:14 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 230 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.775707244873 -122.42258453369101 POINT (-122.42258453 37.77570724) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
49557 49557 11455770 2019-09-23T15:49:00 2019-09-25T13:12:20 2019-09-25T13:12:20 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of FULTON ST and LARKIN ST FULTON ST 6 Civic Center TENDERLOIN 37.779582977295 -122.41677093505899 POINT (-122.41677094 37.77958298) Phone   21 5 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1 39   21
50179 50179 11457841 2019-09-24T08:06:00   2019-09-24T08:50:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 76 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.773659796004 -122.42218558318999 POINT (-122.42218558 37.7736598) Mobile/Open311 http://mobile311.sfgov.org/reports/11457841/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1     1 1   1     21
52796 52796 11465111 2019-09-25T14:01:00 2019-10-17T10:22:19 2019-10-17T10:22:19 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 112 7TH ST, SAN FRANCISCO, CA, 94103 7TH ST 6 South of Market SOUTHERN 37.778877258301 -122.41077423095699 POINT (-122.41077423 37.77887726) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6 14 1 6 7 1 2 1 1     32
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
64898 64898 11470919 2019-09-26T17:40:00 2019-09-30T09:34:02 2019-09-30T09:34:02 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 229 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.77590078334 -122.411010756952 POINT (-122.41101076 37.77590078) Mobile/Open311 http://mobile311.sfgov.org/reports/11470919/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
65091 65091 11473317 2019-09-27T11:02:00 2019-09-30T09:33:40 2019-09-30T09:33:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 239 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.775830207219 -122.410985968053 POINT (-122.41098597 37.77583021) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
70878 70878 11208862 2019-07-31T20:07:36 2019-10-12T10:43:53 2019-10-12T10:43:53 Closed 2 Notes:please backfill with soil . BUF Action:Backfill/Adjust. Notes:please backfill with soil . BUF Action:Backfill/Adjust. Notes:please backfill with soil. BUF Action:Backfill/Adjust. Notes:please backfill with soil :: Closed By CMMS SO 1228412. BUF Action:Backfill/Adjust. date completed - 10/12/2019. Notes:please backfill with soil :: Closed By CMMS SO 1228412from CMMS: . BUF Action:Backfill/Adjust. date completed - 10/12/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.774408799999996 -122.4223277 POINT (-122.4223277 37.7744088) Web   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
72934 72934 11400302 2019-09-11T10:27:00 2019-10-03T10:22:22 2019-10-03T10:22:22 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1133 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776119 -122.408597 POINT (-122.408597 37.776119) Mobile/Open311 http://mobile311.sfgov.org/reports/11400302/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
72937 72937 11400670 2019-09-11T11:15:00 2019-10-03T10:21:15 2019-10-03T10:21:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1126 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776243 -122.40844299999999 POINT (-122.408443 37.776243) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
73024 73024 11431296 2019-09-18T08:34:00   2019-10-03T10:35:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 33 RAUSCH ST, SAN FRANCISCO, CA, 94103 RAUSCH ST 6 South of Market SOUTHERN 37.776699066162 -122.40985107421899 POINT (-122.40985107 37.77669907) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
73546 73546 11490114 2019-10-01T11:44:00 2019-10-03T08:32:00 2019-10-03T08:32:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 8TH ST and HOWARD ST 8TH ST 6 South of Market SOUTHERN 37.776222229004 -122.411605834961 POINT (-122.41160583 37.77622223) Twitter   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
73598 73598 11491706 2019-10-01T15:48:00 2019-10-03T07:40:00 2019-10-03T07:40:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 239 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.775844573975 -122.41091156005899 POINT (-122.41091156 37.77584457) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
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
80978 80978 11598020 2019-10-24T18:34:43   2019-10-24T18:40:49 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 541 NATOMA ST, SAN FRANCISCO, CA, 94103 NATOMA ST 6 South of Market SOUTHERN 37.779383 -122.40845900000001 POINT (-122.408459 37.779383) Web   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
81725 81725 11403188 2019-09-11T18:10:00 2019-10-11T13:08:00 2019-10-11T13:08:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1126 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776295000000005 -122.40847 POINT (-122.40847 37.776295) Mobile/Open311 http://mobile311.sfgov.org/reports/11403188/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
82349 82349 11471995 2019-09-27T07:08:00 2019-10-02T06:31:00 2019-10-02T06:31:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 252 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 9 Mission MISSION 37.76838684082 -122.418998718262 POINT (-122.41899872 37.76838684) Phone   53 3 2 20 7 8 7 28,853 4 19 19 12 53 1 2 14   3 14     2   3     53
89157 89157 9814016 2018-11-15T15:39:00 2019-03-10T16:37:59 2019-03-10T16:37:59 Closed 2 Thanks for reporting this empty basin. Currently, the City has limited planting resources and is focused on planting in certain districts with low canopy coverage. We suggest contacting friends of the urban forest (FUF) or planting through a landscape company. If you plant the tree on your own please apply for a tree planting permit and choose a tree from our recommended species list found at sfpublicworks.org/streettreesf. Please contact us at 415.554.6700 for assistance. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 225 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Hayes Valley NORTHERN 37.77542273826 -122.42278976387699 POINT (-122.42278976 37.77542274) Mobile/Open311 http://mobile311.sfgov.org/reports/9814016/photos 22 4 11 9 11 7 6 28,852 9 10 10   22 1 11     1       1   1     22
89198 89198 9813348 2018-11-15T13:52:00 2019-03-10T16:38:32 2019-03-10T16:38:32 Closed 2 Thanks for reporting this empty basin. Currently, the City has limited planting resources and is focused on planting in certain districts with low canopy coverage. We suggest contacting friends of the urban forest (FUF) or planting through a landscape company. If you plant the tree on your own please apply for a tree planting permit and choose a tree from our recommended species list found at sfpublicworks.org/streettreesf. Please contact us at 415.554.6700 for assistance. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 410 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.777073885629996 -122.422924962799 POINT (-122.42292496 37.77707389) Mobile/Open311 http://mobile311.sfgov.org/reports/9813348/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
89359 89359 9810092 2018-11-14T18:23:04 2019-02-26T09:39:55 2019-02-26T09:39:55 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 480 TEHAMA ST, SAN FRANCISCO, CA, 94103 TEHAMA ST 6 South of Market SOUTHERN 37.779661803301 -122.40631394599899 POINT (-122.40631395 37.7796618) Mobile/Open311 http://mobile311.sfgov.org/reports/9810092/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
91232 91232 9784498 2018-11-08T14:40:00 2019-03-18T10:11:26 2019-03-18T10:11:26 Closed 2 In queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1580 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 5 Civic Center SOUTHERN 37.774529 -122.420422 POINT (-122.420422 37.774529) Mobile/Open311 http://mobile311.sfgov.org/reports/9784498/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8 1 1 1 1     21
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
92423 92423 9756272 2018-11-02T11:06:51 2019-02-13T11:36:25 2019-02-13T11:36:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 600 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin NORTHERN 37.782314051909 -122.419045139218 POINT (-122.41904514 37.78231405) Mobile/Open311 http://mobile311.sfgov.org/reports/9756272/photos 20 4 10 36 9 7 6 28,852 9 36 36   20 1 10           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
93868 93868 11492086 2019-10-01T17:19:00 2019-10-07T10:30:32 2019-10-07T10:30:32 Closed 2 inspection completed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 45 11TH ST, SAN FRANCISCO, CA, 94103 11TH ST 6 South of Market TENDERLOIN 37.774941666667 -122.418013333333 POINT (-122.41801333 37.77494167) Mobile/Open311 http://mobile311.sfgov.org/reports/11492086/photos 32 5 10 20 9 8 2 28,853 2 19 19   32 1 10     1   8 1 2 1 1     32
96316 96316 11608174 2019-10-27T11:16:00 2019-10-29T09:29:50 2019-10-27T14:45:05 Closed 2 this tree is being removed very soon DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 111 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.776291666667 -122.41992166666701 POINT (-122.41992167 37.77629167) Mobile/Open311 http://mobile311.sfgov.org/reports/11608174/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
97158 97158 9686441 2018-10-17T17:02:00 2019-03-11T09:46:39 2019-03-11T09:46:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1627 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market SOUTHERN 37.773792 -122.42069099999999 POINT (-122.420691 37.773792) Mobile/Open311 http://mobile311.sfgov.org/reports/9686441/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
97251 97251 9684463 2018-10-17T11:31:00 2018-10-17T22:10:17 2018-10-17T22:10:17 Closed 2 Request is a duplicate and has been previously reported as 9630677 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1744 MISSION ST, SAN FRANCISCO, CA, 94103 MISSION ST 9 Mission MISSION 37.769357 -122.42004399999999 POINT (-122.420044 37.769357) Mobile/Open311 http://mobile311.sfgov.org/reports/9684463/photos 53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
98068 98068 9660060 2018-10-11T17:01:21 2019-03-18T10:11:07 2019-03-18T10:11:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1621 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market SOUTHERN 37.773857 -122.420686 POINT (-122.420686 37.773857) Mobile/Open311 http://mobile311.sfgov.org/reports/9660060/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
99715 99715 9527614 2018-09-11T16:45:00 2019-01-11T08:00:28 2019-01-11T08:00:28 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1700 MISSION ST, SAN FRANCISCO, CA, 94103 MISSION ST 9 Mission MISSION 37.769844055176 -122.420288085938 POINT (-122.42028809 37.76984406) Phone   53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
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
100281 100281 9325317 2018-07-27T14:51:59 2019-03-11T12:43:14 2019-03-11T12:43:14 Closed 2 Notes:Please contact FUF about replanting this basin.. BUF Action:Inspect. date completed - 3/11/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 475 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 5 Civic Center NORTHERN 37.7797 -122.42 POINT (-122.42 37.7797) Mobile/Open311   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
103692 103692 9254144 2018-07-11T16:16:00 2018-07-14T13:44:00 2018-07-14T13:44:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1118 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.77647 -122.40841666666701 POINT (-122.40841667 37.77647) Mobile/Open311 http://mobile311.sfgov.org/reports/9254144/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
105834 105834 8509224 2018-01-15T20:30:00 2018-01-30T00:00:00 2018-01-30T00:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 131 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.776342 -122.42017 POINT (-122.42017 37.776342) Mobile/Open311   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
106428 106428 8288933 2017-11-19T22:54:35 2018-02-05T15:20:02 2018-02-05T15:20:02 Closed 2 owner fined DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1597 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.7717592 -122.4165503 POINT (-122.4165503 37.7717592) Mobile/Open311   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2   1     32
108226 108226 8072483 2017-09-27T13:45:00 2017-10-11T06:36:00 2017-10-11T06:36:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1400 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.772552490234 -122.413429260254 POINT (-122.41342926 37.77255249) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
108990 108990 8000414 2017-09-10T10:21:17 2017-09-19T06:19:49 2017-09-19T06:19:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 345 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Hayes Valley NORTHERN 37.776736255579 -122.423182228969 POINT (-122.42318223 37.77673626) Mobile/Open311   22 4 11 9 11 7 6 28,852 9 10 10   22 1 11             1         22
111739 111739 7280728 2017-06-20T12:55:02   2017-06-20T13:05:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 724 SAN BRUNO AVE, SAN FRANCISCO, CA, 94107 SAN BRUNO AVE 10 Potrero Hill BAYVIEW 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
112578 112578 7186534 2017-05-24T20:18:31 2017-05-29T23:25:56 2017-05-29T23:25:56 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1175 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.775238342617996 -122.409340739364 POINT (-122.40934074 37.77523834) Mobile/Open311 http://mobile311.sfgov.org/reports/7186534/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6     6     2         32
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
117055 117055 6746056 2017-01-19T07:54:13 2017-02-08T11:25:04 2017-02-08T11:25:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 224 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 9 Mission MISSION 37.769181663206 -122.418665522824 POINT (-122.41866552 37.76918166) Mobile/Open311 http://mobile311.sfgov.org/reports/6746056/photos 53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
117600 117600 6702448 2017-01-07T13:23:25 2017-02-04T12:16:57 2017-02-04T12:16:57 Closed 2 Trees will be replaced after development DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1525 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market SOUTHERN 37.774845264703 -122.417954708593 POINT (-122.41795471 37.77484526) Mobile/Open311 http://mobile311.sfgov.org/reports/6702448/photos 32 5 10 20 9 8 2 28,853 2 19 19   32 1 10     1   7 1 2 1 1     32
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
119096 119096 9351754 2018-08-02T16:08:00   2018-10-30T11:10:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of LARKIN ST and EDDY ST LARKIN ST 6 Tenderloin TENDERLOIN 37.783309936523 -122.417526245117 POINT (-122.41752625 37.78330994) Phone   20 5 10 36 9 7 6 28,852 9 36 36 17 20 1 10 18     18 6 1 2 1       20
120612 120612 6535752 2016-11-15T17:44:30 2016-11-15T18:14:50 2016-11-15T18:14:50 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 10TH ST and FELL ST 10TH ST 6 Civic Center TENDERLOIN 37.776109000000005 -122.41755900000001 POINT (-122.417559 37.776109) Mobile/Open311 http://mobile311.sfgov.org/reports/6535752/photos 32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   8 1 2 1 1     32
124208 124208 6178221 2016-08-10T09:08:17 2016-08-27T14:40:33 2016-08-27T14:40:33 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 956 FOLSOM ST, SAN FRANCISCO, CA, 94107 FOLSOM ST 6 South of Market SOUTHERN 37.779361724854 -122.40476226806601 POINT (-122.40476227 37.77936172) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
125747 125747 6030532 2016-06-29T02:30:31 2016-07-12T08:01:00 2016-07-12T08:01:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1500 MISSION ST, SAN FRANCISCO, CA, 94103 MISSION ST 6 South of Market SOUTHERN 37.774095003678 -122.41769074623699 POINT (-122.41769075 37.774095) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10     1   7 1 2 1 1     32
126580 126580 5949885 2016-06-06T14:16:51   2016-06-06T14:21:20 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 28TH ST and GUERRERO ST 28TH ST 8 Noe Valley INGLESIDE 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
127558 127558 5847668 2016-05-09T14:54:25 2016-05-21T07:23:00 2016-05-21T07:23:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1007 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.781944 -122.410546 POINT (-122.410546 37.781944) Mobile/Open311 http://mobile311.sfgov.org/reports/5847668/photos 32 5 10 34 9 14 2 28,853 2 34 34 17 32 1 10 18   1 18 7 1 2 1 1 35   32
127633 127633 5840513 2016-05-06T17:42:34 2016-05-19T06:09:49 2016-05-19T06:09:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of HAYES ST and VAN NESS AVE HAYES ST 5 Civic Center NORTHERN 37.77730178833 -122.419692993164 POINT (-122.41969299 37.77730179) Phone   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8   2 1 1     21
130242 130242 5519502 2016-01-30T16:29:50 2016-02-25T08:20:44 2016-02-25T08:20:44 Closed 2 Cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 137 ANZAVISTA AVE, SAN FRANCISCO, CA, 94115 ANZAVISTA AVE 2 Anza Vista PARK 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
131482 131482 5418943 2015-12-31T08:04:23 2016-01-05T02:46:42 2016-01-05T02:46:42 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1033 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.78157904282 -122.410975210483 POINT (-122.41097521 37.78157904) Mobile/Open311 http://mobile311.sfgov.org/reports/5418943/photos 32 5 10 34 9 14 2 28,853 2 34 34 17 32 1 10 18   1 18 7 1 2 1 1 35   32
132104 132104 4232796 2014-11-22T06:33:15 2016-04-11T17:31:02 2016-04-11T17:31:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 357 DELLBROOK AVE, SAN FRANCISCO, CA, 94131 DELLBROOK AVE 7 Midtown Terrace PARK 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
134723 134723 5223982 2015-10-26T07:09:59   2015-10-26T07:09:59 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 110 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.774282 -122.42247900000001 POINT (-122.422479 37.774282) Mobile/Open311 http://mobile311.sfgov.org/reports/5223982/photos 26 4 11 9 11 7 6 28,852 9 10 10   26 1 11     1       1   1     26
135356 135356 5161719 2015-10-05T15:32:04 2015-10-05T22:16:55 2015-10-05T22:16:55 Closed 2 resolved: done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 284 LINDEN ST, SAN FRANCISCO, CA, 94102 LINDEN ST 5 Civic Center NORTHERN 37.776555103122 -122.42265123042 POINT (-122.42265123 37.7765551) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
136364 136364 5067347 2015-09-04T15:10:05 2015-09-08T11:11:00 2015-09-08T11:11:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 272 9TH ST, SAN FRANCISCO, CA, 94103 9TH ST 6 South of Market SOUTHERN 37.773976343713 -122.41214375660101 POINT (-122.41214376 37.77397634) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
139863 139863 4760687 2015-05-20T09:59:23 2015-05-20T12:29:00 2015-05-20T12:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 190 9TH ST, SAN FRANCISCO, CA, 94103 9TH ST 6 South of Market SOUTHERN 37.774879495044 -122.41353397208799 POINT (-122.41353397 37.7748795) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1     1 2 1 1     32
142592 142592 4524897 2015-02-25T18:15:47 2015-03-12T06:25:00 2015-03-12T06:25:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1630 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.771328703878005 -122.417193682871 POINT (-122.41719368 37.7713287) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2 1 1     32
143122 143122 4485630 2015-02-12T09:38:35 2015-02-26T11:58:48 2015-02-26T11:58:48 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of FRANKLIN ST and HICKORY ST FRANKLIN ST 5 Civic Center NORTHERN 37.775459624862 -122.421080432946 POINT (-122.42108043 37.77545962) Mobile/Open311 http://mobile311.sfgov.org/reports/4485630/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
147923 147923 9090099 2018-06-04T10:08:00 2018-06-05T12:58:00 2018-06-05T12:58:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 479 TEHAMA ST, SAN FRANCISCO, CA, 94103 TEHAMA ST 6 South of Market SOUTHERN 37.779655456543004 -122.406044006348 POINT (-122.40604401 37.77965546) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
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
150074 150074 8760016 2018-03-19T08:51:00   2018-04-23T18:43:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of NATOMA ST and 7TH ST NATOMA ST 6 South of Market SOUTHERN 37.778415679931996 -122.40993499755899 POINT (-122.409935 37.77841568) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
150455 150455 9321712 2018-07-26T18:13:00 2018-10-30T12:04:12 2018-10-30T12:04:12 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 Pruning_request 50 GROVE ST, SAN FRANCISCO, CA, 94102 GROVE ST 6 Civic Center TENDERLOIN 37.778751 -122.416551 POINT (-122.416551 37.778751) Mobile/Open311   21 5 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
152379 152379 8566875 2018-01-29T15:01:00   2018-01-29T15:15:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 33 GOUGH ST, SAN FRANCISCO, CA, 94103 GOUGH ST 6 South of Market SOUTHERN 37.772148132324 -122.42108154296899 POINT (-122.42108154 37.77214813) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10             2         32

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