calls

80,878 rows sorted by Media_URL 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
96646 96646 11608237 2019-10-27T11:29:00 2019-10-27T22:15:30 2019-10-27T22:15:30 Closed 2 Request is a duplicate and has been previously reported as 11608096 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 331 PARK ST, SAN FRANCISCO, CA, 94110 PARK ST 9 Holly Park INGLESIDE 37.73649597168 -122.418319702148 POINT (-122.4183197 37.73649597) Twitter pic.twitter.com/Z7XI1ITQwn 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
31651 31651 11608096 2019-10-27T10:54:00 2019-10-31T00:25:25 2019-10-31T00:25:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 331 PARK ST, SAN FRANCISCO, CA, 94110 PARK ST 9 Holly Park INGLESIDE 37.73649597168 -122.418319702148 POINT (-122.4183197 37.73649597) Twitter pic.twitter.com/PJSBKjO0VW 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
3524384 3524384 8726801 2018-03-09T15:07:00 2018-03-12T10:01:00 2018-03-12T10:01:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1292 BOWDOIN ST, SAN FRANCISCO, CA, 94134 BOWDOIN ST 9 Portola BAYVIEW 37.719909667969 -122.408187866211 POINT (-122.40818787 37.71990967) Phone https://www.google.com/maps/place/1292+Bowdoin+St,+San+Francisco,+CA+94134/@37.7199115,-122.408047,3a,75y,252.27h,80.81t/data=!3m6!1e1!3m4!1sjRf_xIAs0I-fezy-vH5mMA!2e0!7i13312!8i6656!4m5!3m4!1s0x808f7 91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
516025 516025 10395040 2019-01-23T11:17:00 2019-04-02T13:21:03 2019-04-02T13:21:03 Closed 2 fine issued DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of SANTA CLARA AVE and PORTOLA DR SANTA CLARA AVE 7 St. Francis Wood TARAVAL 37.739234924316 -122.46615600585899 POINT (-122.46615601 37.73923492) Twitter https://twitter.com/xtineweibel/status/1088137500160225280/photo/1 116 10 8 41 4 1 5 59 8 40 40   116   8             1         116
558410 558410 10379441 2019-01-19T13:47:00   2019-02-01T14:00:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of HAVELOCK ST and CIRCULAR AVE HAVELOCK ST 7 Sunnyside INGLESIDE 37.726715087891 -122.44593048095699 POINT (-122.44593048 37.72671509) Twitter https://twitter.com/xtineweibel/status/1086740514148208640/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
1859902 1859902 3384808 2014-02-20T06:36:23 2014-03-20T23:21:04 2014-03-20T23:21:04 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 2 BRYANT ST, SAN FRANCISCO, CA, 94105 BRYANT ST 6 Rincon Hill SOUTHERN 37.787152338005 -122.38782521871599 POINT (-122.38782522 37.78715234) Twitter https://twitter.com/transitdiaries/status/436504847227949057/photo/1 30 1 10 8 9 6 2 28,856 2 6 6   30   10             1         30
299781 299781 9543171 2018-09-14T19:18:00   2018-09-14T19:30:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 701 MINNA ST, SAN FRANCISCO, CA, 94103 MINNA ST 6 South of Market SOUTHERN 37.776763916016 -122.412811279297 POINT (-122.41281128 37.77676392) Twitter https://twitter.com/stuffonfire/status/1040782734174502913/photo/1 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1     1 2 1 1     32
2129892 2129892 4815030 2015-06-09T17:00:27 2015-06-09T20:08:33 2015-06-09T20:08:33 Closed 2 resolved: 1098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of DOUGLASS ST and MARKET ST DOUGLASS ST 8 Eureka Valley MISSION 37.761422367019 -122.43941452504 POINT (-122.43941453 37.76142237) Twitter https://twitter.com/stanfrisco/status/608414471032303616/photo/1 115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
2069290 2069290 4721873 2015-05-05T17:25:17 2015-05-06T17:26:05 2015-05-06T17:26:05 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BURNETT AVE and PORTOLA DR BURNETT AVE 8 Upper Market INGLESIDE 37.746944350783 -122.444848392007 POINT (-122.44484839 37.74694435) Twitter https://twitter.com/stanfrisco/status/595730592811057153/photo/1 57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
1877124 1877124 3840253 2014-07-18T21:04:43 2014-07-18T02:06:15 2014-07-18T02:06:15 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CABRILLO ST and 12TH AVE CABRILLO ST 1 Inner Richmond RICHMOND 37.775076161611 -122.470297976194 POINT (-122.47029798 37.77507616) Twitter https://twitter.com/sidewalksf/status/490339384630079488 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
2899535 2899535 6859615 2017-02-20T09:03:24 2017-02-22T08:10:09 2017-02-22T08:10:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 14TH ST and DOLORES ST 14TH ST 8 Mission Dolores MISSION 37.767868041992 -122.42669677734399 POINT (-122.42669678 37.76786804) Twitter https://twitter.com/shaygilmore/status/833712951735443461/photo/1 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
3588636 3588636 10871514 2019-05-16T14:37:00 2019-05-18T14:25:00 2019-05-18T14:25:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MASONIC AVE and HAIGHT ST MASONIC AVE 5 Haight Ashbury PARK 37.770210266113 -122.445343017578 POINT (-122.44534302 37.77021027) Twitter https://twitter.com/saint_cetacean/status/1129137490789511168/photo/1 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
3498288 3498288 9054731 2018-05-26T17:09:00 2018-06-27T11:40:38 2018-06-27T11:40:38 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of MARKET ST and 6TH ST MARKET ST 6 Tenderloin TENDERLOIN 37.782230377196996 -122.410293579102 POINT (-122.41029358 37.78223038) Twitter https://twitter.com/rappolee/status/1000500902128640000/photo/1 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
2157799 2157799 4418125 2015-01-22T12:06:47 2015-03-30T08:04:00 2015-03-30T08:04:00 Closed 2 resolved: Area is under maintenance...waiting for plant materials. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 23RD AVE and ANZA ST 23RD AVE 1 Outer Richmond RICHMOND 37.778262102344 -122.482454028357 POINT (-122.48245403 37.7782621) Twitter https://twitter.com/ptraughber/status/558337110688546816/photo/1 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
3053401 3053401 7393628 2017-07-19T12:16:20 2017-07-25T08:25:09 2017-07-25T08:25:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of VAN NESS AVE and OFARRELL ST VAN NESS AVE 6 Cathedral Hill NORTHERN 37.784753656726 -122.42119522193501 POINT (-122.42119522 37.78475366) Twitter https://twitter.com/nobleb_g/status/887742747636924416/photo/1 20 4 11 39 11 13 6 28,858 9 41 41   20   11             1         20
2307986 2307986 4959897 2015-08-01T19:11:54 2015-08-24T01:08:00 2015-08-24T01:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CASTRO ST and 19TH ST CASTRO ST 8 Eureka Valley MISSION 37.759288788165996 -122.43485395584801 POINT (-122.43485396 37.75928879) Twitter https://twitter.com/mickd415/status/627660901227716608/photo/1 115 3 5 5 5 2 7 28,862 4 3 3 1 115   5 1           1   5     115
2280764 2280764 4905753 2015-07-13T17:42:01 2015-07-14T02:36:53 2015-07-14T02:36:53 Closed 2 resolved: I have reviewed tree & will now weigh removal Vs pruning. I also spoke with Mr. McCullough in person & described our options DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of MIRABEL AVE and COSO AVE MIRABEL AVE 9 Bernal Heights INGLESIDE 37.745956139248 -122.41782241177 POINT (-122.41782241 37.74595614) Phone https://twitter.com/messages/media/620768938708721667 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2298353 2298353 4905766 2015-07-13T17:48:46 2015-07-14T02:37:10 2015-07-14T02:37:10 Closed 2 resolved: I have reviewed tree & will now weigh removal Vs pruning. I also spoke with Mr. McCullough in person & described our options DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of MIRABEL AVE and COSO AVE MIRABEL AVE 9 Bernal Heights INGLESIDE 37.745956139248 -122.41782241177 POINT (-122.41782241 37.74595614) Phone https://twitter.com/messages/media/620768938708721667 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2847241 2847241 6708152 2017-01-09T10:06:45 2017-01-18T08:55:09 2017-01-18T08:55:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CASTRO ST and LLOYD ST CASTRO ST 8 Buena Vista PARK 37.769752502441 -122.43620300293001 POINT (-122.436203 37.7697525) Twitter https://twitter.com/laurakayw/status/818501413042995200/photo/1 28 7 5 3 5 15 8 29,492 5 9 9   28   5             1         28
1876996 1876996 3575294 2014-04-22T08:29:56 2014-05-08T12:00:00 2014-05-08T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Letter created. Asked owner to remove the tree. It suffered a trunk failure and has base rot? The basin is replantable. . BUF Action:INSPECT. date completed - 5/8/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1347 GREEN ST, SAN FRANCISCO, CA, 94109 GREEN ST 3 Polk Gulch NORTHERN 37.797879943283 -122.42126830745701 POINT (-122.42126831 37.79787994) Twitter https://twitter.com/joydifranza/status/458625005824131074/photo/1 105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
433552 433552 10380646 2019-01-19T20:17:00 2019-04-20T15:23:07 2019-04-20T15:23:07 Closed 2 will contact the school and ask to add more mulch or we will have to backfill with soil. plants in the basin are the responsibility of the property owner. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of LILY ST and FRANKLIN ST LILY ST 5 Civic Center NORTHERN 37.774761199951 -122.420860290527 POINT (-122.42086029 37.7747612) Twitter https://twitter.com/josephpwilson/status/1086835440496259072/photo/1 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1 1 1     21
2154309 2154309 4584436 2015-03-17T21:16:38 2016-06-13T12:00:00 2016-06-13T12:00:00 Closed 2 cleaned DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of NORTH POINT ST and HYDE ST NORTH POINT ST 2 Aquatic Park / Ft. Mason CENTRAL 37.805720498178 -122.420370258166 POINT (-122.42037026 37.8057205) Twitter https://twitter.com/jackhutton/status/578022164458143744/photo/1 98 6 6 32 1 5 1 28,858 1 32 32   98   6             1         98
98437 98437 9638276 2018-10-07T10:48:00   2019-01-04T09:25:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 685 BEACH ST, SAN FRANCISCO, CA, 94109 BEACH ST 2 Fisherman's Wharf CENTRAL 37.806461334229 -122.420021057129 POINT (-122.42002106 37.80646133) Twitter https://twitter.com/jackhutton/status/1048987645626335233/photo/1 99 6 6 32 1 5 1 28,858 1 32 32   99   6         2   1         99
3472655 3472655 9013014 2018-05-17T10:47:00 2018-05-21T12:22:41 2018-05-21T12:22:41 Closed 2 basin to be paved over. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 302 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.783988952637 -122.41253662109399 POINT (-122.41253662 37.78398895) Twitter https://twitter.com/i/web/status/997170626522574848 20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
3526927 3526927 8811867 2018-03-31T12:42:00   2018-04-13T13:45:03 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 20 COOK ST, SAN FRANCISCO, CA, 94118 COOK ST 2 Laurel Heights / Jordan Park RICHMOND 37.783290863037 -122.452362060547 POINT (-122.45236206 37.78329086) Twitter https://twitter.com/i/web/status/980167578675904512 11 8 6 31 1 15 9 54 6 31 31   11   6             1         11
3265718 3265718 8503653 2018-01-14T10:22:00   2018-01-14T10:30:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 75 HOWARD ST, SAN FRANCISCO, CA, 94105 HOWARD ST 6 Financial District SOUTHERN 37.791675567627 -122.39178466796899 POINT (-122.39178467 37.79167557) Twitter https://twitter.com/i/web/status/952605960631074816 108 1 10 8 9 6 2 28,855 2 6 6   108   10         3   1         108
3183676 3183676 7597873 2017-09-06T08:38:15 2017-09-09T06:44:00 2017-09-09T06:44:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 405 HOWARD ST, SAN FRANCISCO, CA, 94105 HOWARD ST 6 South of Market SOUTHERN 37.788890142472 -122.395248900284 POINT (-122.3952489 37.78889014) Twitter https://twitter.com/i/web/status/905453102404313088 32 1 10 8 9 6 2 28,855 2 6 6   32   10         3   1         32
3058969 3058969 7494891 2017-08-12T13:14:08 2017-10-17T06:34:39 2017-10-17T06:34:39 Closed 2 SR is unclear. found no sidewalk erosion issues near intersecton DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of POWHATTAN AVE and BERNAL HEIGHTS BLVD POWHATTAN AVE 9 Bernal Heights INGLESIDE 37.741394045717 -122.411194620682 POINT (-122.41119462 37.74139405) Twitter https://twitter.com/i/web/status/896461060932124672 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
3037560 3037560 7463731 2017-08-04T20:00:11 2017-08-18T12:15:50 2017-08-18T12:15:50 Closed 2 The tree is still under maintenance contract & will be replaced DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 429 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762004399647005 -122.434921226802 POINT (-122.43492123 37.7620044) Twitter https://twitter.com/i/web/status/893666253566377985 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
2961957 2961957 7149885 2017-05-15T09:58:32 2017-07-13T08:40:26 2017-07-13T08:40:26 Closed 2 Due to 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 schedules routes. Your tree will be addressed at a later date under this schedules maintenance plan. Thank you for your patience. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of STANYAN ST and HAYES ST STANYAN ST 1 Panhandle PARK 37.772895160338 -122.45428669035101 POINT (-122.45428669 37.77289516) Twitter https://twitter.com/i/web/status/864160456386125824   7 4 12 2 11 8 29,492 5 8 8       4             1          
2832472 2832472 6505450 2016-11-07T11:16:00 2016-12-02T16:25:12 2016-12-02T16:25:12 Closed 2 Request Letter Sent. letter sent DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 17TH ST and MISSOURI ST 17TH ST 10 Potrero Hill SOUTHERN 37.765129697457 -122.39677070167801 POINT (-122.3967707 37.7651297) Twitter https://twitter.com/i/web/status/795667201122398208 54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
2759786 2759786 6471869 2016-10-28T15:30:11   2016-11-01T06:54:21 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 16TH ST and MISSION ST 16TH ST 9 Mission MISSION 37.76505279541 -122.41967010498001 POINT (-122.4196701 37.7650528) Phone https://twitter.com/i/web/status/792128104382607360 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3 50 24 53
287243 287243 9293084 2018-07-20T12:14:00 2018-08-24T07:21:39 2018-08-24T07:21:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of DETROIT ST and STAPLES AVE DETROIT ST 7 Sunnyside INGLESIDE 37.729091644287 -122.444282531738 POINT (-122.44428253 37.72909164) Twitter https://twitter.com/i/web/status/1020384518895620096 95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
212811 212811 9085202 2018-06-02T16:15:00 2018-08-15T12:39:00 2018-08-15T12:39:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of CAROLINA ST and 23RD ST CAROLINA ST 10 Potrero Hill BAYVIEW 37.754680633545 -122.39973449706999 POINT (-122.3997345 37.75468063) Twitter https://twitter.com/i/web/status/1003039378396966912 54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
2126022 2126022 4466841 2015-02-06T14:49:28 2015-02-23T10:45:00 2015-02-23T10:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3512 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.781536725428 -122.45695410398001 POINT (-122.4569541 37.78153673) Twitter https://twitter.com/hul/status/563810268837195777/photo/1 11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
3575280 3575280 11057128 2019-06-28T08:21:00 2019-06-28T13:50:00 2019-06-28T13:50:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of EDNA ST and FLOOD AVE EDNA ST 7 Sunnyside INGLESIDE 37.729892730713 -122.446571350098 POINT (-122.44657135 37.72989273) Twitter https://twitter.com/estelle_smith/status/1144620938794680327/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
3674222 3674222 10788635 2019-04-28T11:33:00 2019-05-02T16:07:12 2019-05-02T16:07:12 Closed 2 StreetTreeSF went into effect July 1, 2017. Since then, we have begun tree maintenance work throughout the City, starting with the "worst first". These are street trees and sidewalks that pose a safety risk and are located near bus stops, schools and senior centers. Crews also continue to concentrate their efforts on emergency work, such as fallen limbs, pedestrian and visibility obstructions and damaged trees during storm season that pose safety hazards. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 2140 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.762840270996 -122.415267944336 POINT (-122.41526794 37.76284027) Twitter https://twitter.com/esquared415/status/1122237041423503360/photo/1 53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
2012134 2012134 3906745 2014-08-11T10:30:50 2014-08-11T12:58:12 2014-08-11T12:58:12 Closed 2 resolved: 1098--- chipper DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of THE EMBARCADERO and HARRISON ST THE EMBARCADERO 6 Rincon Hill SOUTHERN 37.789570071176 -122.388482032787 POINT (-122.38848203 37.78957007) Twitter https://twitter.com/ernestsemerda/status/498872191757217793/photo/1 30 1 10 8 9 6 2 28,855 2 6 6   30   10             1         30
31587 31587 11607880 2019-10-27T10:06:00   2019-10-28T16:44:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1223 6TH AVE, SAN FRANCISCO, CA, 94122 6TH AVE 5 Inner Sunset PARK 37.76549911499 -122.46337127685499 POINT (-122.46337128 37.76549911) Twitter https://twitter.com/clair_415/status/1188501353707884544/photo/1 109 7 11 14 11 11 8 56 5 12 12   109   11             1         109
533265 533265 10376987 2019-01-18T17:45:00 2019-01-25T12:41:00 2019-01-25T12:41:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of VALENCIA ST and 22ND ST VALENCIA ST 8 Mission MISSION 37.755294799805 -122.420967102051 POINT (-122.4209671 37.7552948) Twitter https://twitter.com/charleydelabay/status/1086433583688933376/photo/1 52 3 5 20 5 2 7 28,859 4 19 19   52   5     3       1   3     52
521786 521786 9792578 2018-11-10T15:23:00 2018-11-14T00:30:25 2018-11-14T00:30:25 Closed 2 10-98. Tree was cut down by LP. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3132 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.776054382324 -122.49258422851601 POINT (-122.49258423 37.77605438) Twitter https://twitter.com/cfmceroz/status/1061396949289492481/photo/1 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
212696 212696 9248199 2018-07-10T12:40:00   2018-07-10T12:50:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 633 CABRILLO ST, SAN FRANCISCO, CA, 94118 CABRILLO ST 1 Inner Richmond RICHMOND 37.775196075439 -122.465293884277 POINT (-122.46529388 37.77519608) Twitter https://twitter.com/blcsfo/status/1016761716187848704/photo/1 5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1734348 1734348 2982928 2013-10-24T14:09:34 2014-01-17T08:18:16 2014-01-17T08:18:16 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of ARLINGTON ST and HIGHLAND AVE ARLINGTON ST 8 Fairmount INGLESIDE 37.737754821777 -122.425506591797 POINT (-122.42550659 37.73775482) Twitter https://twitter.com/bernalcut/status/393466424204603392/photo/1 59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
282139 282139 9345439 2018-08-01T11:22:00 2018-08-01T15:06:00 2018-08-01T15:06:00 Closed 2 DPW Ops Queue to CSP Supervisor Queue at 2018-08-01T12:29:00 : Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of HYDE ST and WASHINGTON ST HYDE ST 3 Nob Hill CENTRAL 37.793682098389 -122.417938232422 POINT (-122.41793823 37.7936821) Twitter https://twitter.com/VickiJohnsonPhD/status/1024718001591832576/photo/1 16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
14952 14952 10848920 2019-05-11T13:35:00 2019-10-08T16:12:46 2019-10-08T16:12:46 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 Near_communication_line 415 EDNA ST, SAN FRANCISCO, CA, 94112 EDNA ST 7 Sunnyside INGLESIDE 37.730369567871 -122.44669342041 POINT (-122.44669342 37.73036957) Twitter https://twitter.com/Sunnyside_Assoc/status/1126906178066190336/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
3633581 3633581 10848925 2019-05-11T13:36:00 2019-05-13T14:28:45 2019-05-13T14:28:45 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. Conditions requiring immediate attenti DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 436 EDNA ST, SAN FRANCISCO, CA, 94112 EDNA ST 7 Sunnyside INGLESIDE 37.730438232421996 -122.446434020996 POINT (-122.44643402 37.73043823) Twitter https://twitter.com/Sunnyside_Assoc/status/1126906178066190336/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
3638306 3638306 10848936 2019-05-11T13:38:00 2019-05-13T14:29:05 2019-05-13T14:29:05 Closed 2 communication lines low priority 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. Cond DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 430 EDNA ST, SAN FRANCISCO, CA, 94112 EDNA ST 7 Sunnyside INGLESIDE 37.730369567871 -122.446434020996 POINT (-122.44643402 37.73036957) Twitter https://twitter.com/Sunnyside_Assoc/status/1126906178066190336/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
3687565 3687565 10848902 2019-05-11T13:32:00 2019-05-20T08:46:44 2019-05-20T08:46:44 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 411 EDNA ST, SAN FRANCISCO, CA, 94112 EDNA ST 7 Sunnyside INGLESIDE 37.73023223877 -122.44669342041 POINT (-122.44669342 37.73023224) Twitter https://twitter.com/Sunnyside_Assoc/status/1126906178066190336/photo/1 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
417855 417855 9439389 2018-08-22T17:39:00 2018-08-24T07:57:59 2018-08-24T07:57:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of DETROIT ST and FLOOD AVE DETROIT ST 7 Sunnyside INGLESIDE 37.72989654541 -122.444290161133 POINT (-122.44429016 37.72989655) Twitter https://twitter.com/StvnFlngn/status/1032423777718624256/photo/1 95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
4273 4273 11515551 2019-10-07T09:00:00 2019-10-15T13:27:00 2019-10-15T13:27:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HEARST AVE and FOERSTER ST HEARST AVE 7 Sunnyside INGLESIDE 37.730690002441 -122.44886016845699 POINT (-122.44886017 37.73069) Twitter https://twitter.com/StvnFlngn 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
2110819 2110819 4605939 2015-03-25T11:26:05 2016-06-14T11:55:44 2016-06-14T11:55:44 Closed 2 6/14/16 inspected property no graffiti found.gd DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1539 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.778916864692 -122.464838204058 POINT (-122.4648382 37.77891686) Twitter https://twitter.com/SidewalkSf/status/580776472446525441/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1938638 1938638 3938348 2014-08-21T14:30:09 2016-10-17T01:11:17 2016-10-17T01:11:17 Closed 2 Found missing sewer vent cover. - NTR # 1014487, DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 700 3RD AVE, SAN FRANCISCO, CA, 94118 3RD AVE 1 Inner Richmond RICHMOND 37.775474241751 -122.460590788594 POINT (-122.46059079 37.77547424) Twitter https://twitter.com/SidewalkSf/status/502555650267045888/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1807484 1807484 3780043 2014-06-27T20:53:54 2014-08-22T09:48:52 2014-08-22T09:48:52 Closed 2 resolved: Request Letter Sent. Privately maintained tree. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 522 9TH AVE, SAN FRANCISCO, CA, 94118 9TH AVE 1 Inner Richmond RICHMOND 37.778500258185 -122.467253257808 POINT (-122.46725326 37.77850026) Twitter https://twitter.com/SidewalkSf/status/482723661372084225/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1752056 1752056 3297074 2014-01-22T14:01:51 2016-06-18T07:52:22 2016-06-18T07:52:22 Closed 2 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 210 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 2 Presidio Terrace RICHMOND 37.786570687722 -122.46824583575399 POINT (-122.46824584 37.78657069) Phone https://twitter.com/SidewalkSf/status/426108238589730816/photo/1 4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
1698919 1698919 3297098 2014-01-22T14:06:05 2014-01-29T05:16:33 2014-01-29T05:16:33 Closed 2 resolved: Condition not found at this location. - Condition not found at this location. No additional action is required at this time. DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 8TH AVE and BALBOA ST 8TH AVE 1 Inner Richmond RICHMOND 37.786570687722 -122.46824583575399 POINT (-122.46824584 37.78657069) Phone https://twitter.com/SidewalkSf/status/426106045333663744/photo/1 4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
1648402 1648402 3274165 2014-01-15T11:22:32 2014-01-30T14:22:04 2014-01-30T14:22:04 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 1/30/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 414 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 2 Presidio Terrace RICHMOND 37.7866561882 -122.466084815152 POINT (-122.46608482 37.78665619) Twitter https://twitter.com/SidewalkSf/status/423519495420780544/photo/1 4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
1733855 1733855 2744583 2013-08-22T19:45:56 2013-08-27T04:40:56 2013-08-27T04:40:56 Closed 2 resolved: Refer to PGE - Contacted 311, Spoke with Paul& Joanna. 311 will re-direct to PGE. DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 679 12TH AVE, SAN FRANCISCO, CA, 94118 12TH AVE 1 Inner Richmond RICHMOND 37.775608062744006 -122.470474243164 POINT (-122.47047424 37.77560806) Phone https://twitter.com/SidewalkSf/status/370724240447643648/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1648811 1648811 2744443 2013-08-22T19:08:40 2013-08-26T04:39:20 2013-08-26T04:39:20 Closed 2 resolved: Already inspected. Refer to RFA #21103121 and NTR #974059. - Already inspected. Refer to RFA #21103121 and NTR #974059. No additional action is required at this time. DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3420 FULTON ST, SAN FRANCISCO, CA, 94118 FULTON ST 1 Inner Richmond RICHMOND 37.773410797119006 -122.46856689453101 POINT (-122.46856689 37.7734108) Twitter https://twitter.com/SidewalkSf/status/370690618499940352/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
3632521 3632521 10761470 2019-04-22T10:53:00 2019-04-24T10:08:00 2019-04-24T10:08:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 678 12TH AVE, SAN FRANCISCO, CA, 94118 12TH AVE 1 Inner Richmond RICHMOND 37.775581359863 -122.470176696777 POINT (-122.4701767 37.77558136) Twitter https://twitter.com/SidewalkSf/status/1120373677290291203/photo/1 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
558013 558013 9867021 2018-11-29T09:50:00 2018-11-29T22:10:49 2018-11-29T22:10:49 Closed 2 Request is a duplicate and has been previously reported as 9866586 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CLAY ST and POLK ST CLAY ST 3 Polk Gulch NORTHERN 37.792385101318004 -122.42105102539101 POINT (-122.42105103 37.7923851) Twitter https://twitter.com/SOBtweets/status/1068183106618716162/photo/1 105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
3449985 3449985 8837671 2018-04-06T11:22:00 2018-04-27T12:59:46 2018-04-27T12:59:46 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 - Overgrown_Tree 3 Blocking_sidewalk Intersection of FOLSOM ST and LANGTON ST FOLSOM ST 6 South of Market SOUTHERN 37.776317596436 -122.408378601074 POINT (-122.4083786 37.7763176) Twitter https://twitter.com/R27D/status/982304476949200896/photo/1 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
3336491 3336491 8555699 2018-01-26T12:30:00 2018-02-06T08:56:00 2018-02-06T08:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRODERICK ST and TURK ST BRODERICK ST 5 Western Addition PARK 37.779438018799 -122.440399169922 POINT (-122.44039917 37.77943802) Phone https://twitter.com/PetiteKaybee/status/957353687935889408/photo/1 97 7 11 39 11 15 8 29,490 5 41 41   97   11             1         97
3797449 3797449 11395523 2019-09-10T11:21:00 2019-09-10T22:15:35 2019-09-10T22:15:35 Closed 2 Request is a duplicate and has been previously reported as 11394575 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BARNEVELD AVE and JERROLD AVE BARNEVELD AVE 10 Produce Market BAYVIEW 37.746334075928004 -122.402694702148 POINT (-122.4026947 37.74633408) Twitter https://twitter.com/MsMirandaJones/status/1171484157161009158/photo/1 85 2 9 1 8 10 3 58 3 1 1   85   9             1         85
2987665 2987665 6855311 2017-02-18T11:13:17 2017-02-22T00:37:00 2017-02-22T00:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of DIAMOND HEIGHTS BLVD and ADDISON ST DIAMOND HEIGHTS BLVD 8 Diamond Heights INGLESIDE 37.740151169466 -122.43583958365299 POINT (-122.43583958 37.74015117) Twitter https://twitter.com/M12Topaz/status/833026662786752512/photo/1 96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
650051 650051 10730612 2019-04-15T09:43:00 2019-05-13T06:12:00 2019-05-13T06:12:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of ARGUELLO BLVD and FULTON ST ARGUELLO BLVD 1 Golden Gate Park RICHMOND 37.774307250977 -122.458374023438 POINT (-122.45837402 37.77430725) Twitter https://twitter.com/Jewels5005630/status/1117821176045158402/photo/1 9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
3838105 3838105 11425036 2019-09-16T18:42:00   2019-09-16T19:10:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 3RD ST and MEADE AVE 3RD ST 10 Bret Harte BAYVIEW 37.71817779541 -122.397979736328 POINT (-122.39797974 37.7181778) Twitter https://twitter.com/Jacktsoodol/status/1173729847228547072/photo/1 88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
544364 544364 9864804 2018-11-28T17:01:00 2019-07-27T22:07:01 2019-07-27T22:07:01 Closed 2 FUF responded DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of BRYANT ST and DORE ST BRYANT ST 6 Showplace Square SOUTHERN 37.770820617676 -122.409133911133 POINT (-122.40913391 37.77082062) Twitter https://twitter.com/EsmeAlaki/status/1067938631543775232/photo/1 33 1 10 34 9 8 2 28,853 2 34 34   33   10             2         33
3320999 3320999 8659217 2018-02-21T08:37:00 2018-02-21T10:32:00 2018-02-21T10:32:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 532 FOLSOM ST, SAN FRANCISCO, CA, 94105 FOLSOM ST 6 South of Market SOUTHERN 37.786670684814 -122.39550018310499 POINT (-122.39550018 37.78667068) Twitter https://twitter.com/ECDispatch/status/966337806929833984/photo/1 32 1 10 8 9 6 2 28,855 2 6 6   32   10         3   1         32
106102 106102 8450124 2018-01-01T13:26:00 2018-01-31T11:29:59 2018-01-31T11:29:59 Closed 2 tree seems to be stable DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 81 LANSING ST, SAN FRANCISCO, CA, 94105 LANSING ST 6 Rincon Hill SOUTHERN 37.785690307617 -122.39429473876999 POINT (-122.39429474 37.78569031) Twitter https://twitter.com/ECDispatch/status/947933902928199680/photo/1 30 1 10 8 9 6 2 28,855 2 6 6   30   10         3   1         30
3133897 3133897 8041642 2017-09-20T08:44:00 2017-09-20T02:14:08 2017-09-20T02:14:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 235 2ND ST, SAN FRANCISCO, CA, 94105 2ND ST 6 South of Market SOUTHERN 37.786262512206996 -122.39733123779301 POINT (-122.39733124 37.78626251) Twitter https://twitter.com/ECDispatch/status/910518337687261187/photo/1 32 1 10 8 9 6 2 28,855 2 6 6   32   10         3   1         32
3766539 3766539 11126782 2019-07-14T12:12:00 2019-08-06T07:44:00 2019-08-06T07:44:00 Closed 2 not a hazard - 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 yo DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of STANYAN ST and FREDERICK ST STANYAN ST 5 Parnassus Heights PARK 37.766372680664 -122.452949523926 POINT (-122.45294952 37.76637268) Twitter https://twitter.com/Dzhena/status/1150481998923780097/photo/1 110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
2407909 2407909 5425492 2016-01-02T16:52:47 2016-01-08T12:00:00 2016-01-08T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 1/8/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAY ST and MASON ST BAY ST 3 North Beach CENTRAL 37.805616189109 -122.41360607074101 POINT (-122.41360607 37.80561619) Twitter https://twitter.com/DannySauter/status/683449363507490816/photo/1 106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
2242788 2242788 5018562 2015-08-20T16:41:04 2015-08-21T08:41:40 2015-08-21T08:41:40 Closed 2 resolved: This is a private tree basin we have sent the owners multiple letters. Fines may be assessed DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 2088 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.763628320903 -122.419603896599 POINT (-122.4196039 37.76362832) Twitter https://twitter.com/DPClean/status/634500411240652801/photo/1 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3     53
2259705 2259705 5018578 2015-08-20T16:44:01 2015-08-21T12:21:32 2015-08-21T12:21:32 Closed 2 resolved: Request closed by SES . Notes = " Notes:Letter created by Susan Nawbary. BUF Action:Correspondence. date completed - 7/21/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 83 6TH ST, SAN FRANCISCO, CA, 94103 6TH ST 6 South of Market TENDERLOIN 37.781437284179 -122.40890256963101 POINT (-122.40890257 37.78143728) Twitter https://twitter.com/DPClean/status/634494740751327232/photo/1 32 5 10 34 9 14 2 28,853 2 34 34   32 1 10   14     7 1 2 1       32
2118851 2118851 4424845 2015-01-24T14:52:35 2015-01-30T09:54:02 2015-01-30T09:54:02 Closed 2 resolved: request submitted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 929 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 9 Mission MISSION 37.757990165422 -122.42104283881099 POINT (-122.42104284 37.75799017) Twitter https://twitter.com/DPClean/status/559107903769305088/photo/1 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
2124066 2124066 4424594 2015-01-24T13:13:58 2015-02-24T04:49:50 2015-02-24T04:49:50 Closed 2 resolved: the owner was permitted to remove the tree, they are in the process of replanting DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 700 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.761744777569 -122.41735808595301 POINT (-122.41735809 37.76174478) Twitter https://twitter.com/DPClean/status/559089696589246464/photo/1 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1981011 1981011 4329292 2014-12-23T14:57:21 2015-01-08T06:15:23 2015-01-08T06:15:23 Closed 2 resolved: Request closed by SES . Notes = " Notes:Acer rubrum :: Closed By CMMS SO 458718. BUF Action:Plant. date completed - 1/8/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 2862 24TH ST, SAN FRANCISCO, CA, 94110 24TH ST 9 Mission MISSION 37.752899601014 -122.409580869997 POINT (-122.40958087 37.7528996) Twitter https://twitter.com/DPClean/status/547518437950779394/photo/1 53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       1   3     53
1939096 1939096 4328019 2014-12-23T10:30:36 2014-12-29T12:15:54 2014-12-29T12:15:54 Closed 2 resolved: A request has been msde into CMMS to pave this location; unplantable per utilities. See SR 1610442. SS 12/29/14 DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 1845 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Union Street NORTHERN 37.800206541944 -122.431862949519 POINT (-122.43186295 37.80020654) Twitter https://twitter.com/DPClean/status/547447926306660352/photo/1 15 4 6 13 1 13 6 57 9 17 17   15   6   21         1         15
2026848 2026848 4214654 2014-11-16T15:42:32 2014-11-25T12:00:00 2014-11-25T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:private tree with graffiti on trunk. Send letter to owner. BUF Action:Inspect. date completed - 11/25/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2331 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.75968577908 -122.41897264685 POINT (-122.41897265 37.75968578) Twitter https://twitter.com/DPClean/status/534116516661579777/photo/1 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
2050259 2050259 4198128 2014-11-11T10:28:16 2016-06-13T12:00:00 2016-06-13T12:00:00 Closed 2 cleaned DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2160 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.762458511869 -122.41958058786699 POINT (-122.41958059 37.76245851) Twitter https://twitter.com/DPClean/status/532203368048242688/photo/1 53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
2006113 2006113 4194898 2014-11-10T11:43:53 2014-11-14T07:20:15 2014-11-14T07:20:15 Closed 2 resolved: done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2401 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.758435185819 -122.418680849765 POINT (-122.41868085 37.75843519) Twitter https://twitter.com/DPClean/status/531883375163088896/photo/1 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1997675 1997675 4194779 2014-11-10T11:26:02 2014-11-30T11:00:03 2014-11-30T11:00:03 Closed 2 resolved: Mailed letter to property owner. Cbuck DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 3525 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758540625497 -122.419628128994 POINT (-122.41962813 37.75854063) Twitter https://twitter.com/DPClean/status/531883342682419200/photo/1 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
3583362 3583362 11015213 2019-06-18T19:23:00 2019-06-18T19:43:28 2019-06-18T19:43:28 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 64 RICHLAND AVE, SAN FRANCISCO, CA, 94110 RICHLAND AVE 8 St. Mary's Park INGLESIDE 37.735900878906 -122.425468444824 POINT (-122.42546844 37.73590088) Twitter https://twitter.com/CHNA_311/status/1141167890952941568/photo/1 93 9 5 2 5 2 4 28,859 7 2 2   93   5             1         93
3548920 3548920 10497477 2019-02-16T13:45:00 2019-02-20T00:25:12 2019-02-20T00:25:12 Closed 2 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SAN JOSE AVE and RANDALL ST SAN JOSE AVE 8 Holly Park INGLESIDE 37.739868164063 -122.42414855956999 POINT (-122.42414856 37.73986816) Twitter https://twitter.com/CHNA_311/status/1096865617976602624/photo/1 61 9 5 10 5 2 4 28,859 7 7 7   61   5             1         61
655108 655108 10496638 2019-02-16T10:08:00   2019-02-25T08:50:04 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 29 HIGHLAND AVE, SAN FRANCISCO, CA, 94110 HIGHLAND AVE 8 Holly Park INGLESIDE 37.737495422363 -122.424644470215 POINT (-122.42464447 37.73749542) Twitter https://twitter.com/CHNA_311/status/1096828480287735808/photo/1 61 9 5 2 5 2 4 28,859 7 2 2   61   5             1         61
2053246 2053246 4350190 2014-12-31T13:47:56 2015-01-02T07:34:00 2015-01-02T07:34:00 Closed 2 resolved: removed PRIVATE tree off roof of fire station home owner removing brush @ wood DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PORTOLA DR and MIRALOMA DR PORTOLA DR 7 Sherwood Forest INGLESIDE 37.740533628636 -122.458904418391 POINT (-122.45890442 37.74053363) Twitter https://t.co/zcLxmAvf1e 117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
325935 325935 9738668 2018-10-29T20:04:00   2018-10-29T20:15:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of FOLSOM ST and 8TH ST FOLSOM ST 6 South of Market SOUTHERN 37.774990081787 -122.41006469726601 POINT (-122.4100647 37.77499008) Twitter https://t.co/qRqjDAfJqP 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
89383 89383 9809165 2018-11-14T15:09:00 2019-01-07T07:39:00 2019-01-07T07:39:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of DETROIT ST and FLOOD AVE DETROIT ST 7 Sunnyside INGLESIDE 37.72989654541 -122.444290161133 POINT (-122.44429016 37.72989655) Twitter https://t.co/hq4hbwnvkg 95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
2184401 2184401 4768626 2015-05-22T17:10:51 2015-06-11T08:49:00 2015-06-11T08:49:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of HAYES ST and WEBSTER ST HAYES ST 5 Hayes Valley NORTHERN 37.776043986568 -122.429556004021 POINT (-122.429556 37.77604399) Twitter https://t.co/gwjBwYiuaS 22 4 11 9 11 7 6 29,492 9 10 10   22   11             1         22
2098571 2098571 4636090 2015-04-04T10:15:03 2016-06-14T12:29:10 2016-06-14T12:29:10 Closed 2 SES Graffiti Crew - Clean using chemicals - Pole - Sign (Comment) DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 619 HAYES ST, SAN FRANCISCO, CA, 94102 HAYES ST 5 Hayes Valley NORTHERN 37.776289602154 -122.426631133458 POINT (-122.42663113 37.7762896) Twitter https://t.co/glFXap8TEy 22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
3092053 3092053 7230555 2017-06-06T12:59:20 2017-06-07T17:00:00 2017-06-07T17:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 20TH ST and MISSOURI ST 20TH ST 10 Potrero Hill BAYVIEW 37.76020156787 -122.39336482053999 POINT (-122.39336482 37.76020157) Phone https://t.co/c7uSGIXTvu 54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
2096352 2096352 4395392 2015-01-15T09:45:33 2015-01-24T01:11:00 2015-01-24T01:11:00 Closed 2 resolved: cleared towaway sign DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of HAYES ST and WEBSTER ST HAYES ST 5 Hayes Valley NORTHERN 37.776042938232 -122.429550170898 POINT (-122.42955017 37.77604294) Twitter https://t.co/aNsVpjLAbJ 22 4 11 9 11 7 6 29,492 9 10 10   22   11             1         22
623133 623133 10718540 2019-04-11T19:32:00 2019-04-11T19:57:05 2019-04-11T19:57:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 760 TEHAMA ST, SAN FRANCISCO, CA, 94103 TEHAMA ST 6 South of Market SOUTHERN 37.775325775146 -122.412147521973 POINT (-122.41214752 37.77532578) Twitter https://t.co/UY8XVWJl66 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
562994 562994 10377395 2019-01-18T20:22:00 2019-02-13T09:04:00 2019-02-13T09:04:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 305 HEARST AVE, SAN FRANCISCO, CA, 94112 HEARST AVE 7 Sunnyside INGLESIDE 37.730583190918004 -122.44448852539101 POINT (-122.44448853 37.73058319) Twitter https://t.co/MRNTnqupmG 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
325807 325807 9706438 2018-10-22T15:39:00 2018-10-29T09:27:55 2018-10-29T09:27:55 Closed 2 Since StreetTreeSF went into effect on July 1, 2017, we have been working on the worst first. The pruning of the most problematic street trees is prioritized based on safety considerations, to correct structural flaws and to gain necessary clearances for overhead wires, traffic signs and signals, adjacent buildings and traffic flow. Trees that do not pose safety concerns also continue to be pruned by tree crews. You can find out when nearby street trees will be pruned by visiting www.sfpublicwor DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 9TH ST and NATOMA ST 9TH ST 6 South of Market SOUTHERN 37.775436401367 -122.413719177246 POINT (-122.41371918 37.7754364) Twitter https://t.co/JLdVQizgLk 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1     1 2 1 1     32
2568404 2568404 5991460 2016-06-17T15:16:06 2016-06-21T01:01:04 2016-06-21T01:01:04 Closed 2 Request Letter Sent. sent letter to owner. Notes:broken edging. notifying owner to remove.. BUF Action:Inspect. date completed - 6/21/2016. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 982 HAYES ST, SAN FRANCISCO, CA, 94117 HAYES ST 5 Alamo Square NORTHERN 37.775772565914004 -122.43254247875299 POINT (-122.43254248 37.77577257) Twitter https://t.co/I9Bfbj6FM0 23 4 11 9 11 15 6 29,492 9 10 10   23   11             1         23
3553576 3553576 10597851 2019-03-13T14:36:00 2019-03-28T12:32:27 2019-03-28T12:32:27 Closed 2 these were just pruned DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of ELK ST and BOSWORTH ST ELK ST 8 Glen Park INGLESIDE 37.734855651855 -122.43993377685499 POINT (-122.43993378 37.73485565) Twitter https://t.co/I085zMBR58 96 9 5 41 5 9 4 63 7 40 40   96   5             1     80   96
2209551 2209551 5150306 2015-10-01T12:32:39 2015-10-01T20:12:58 2015-10-01T20:12:58 Closed 2 resolved: yes, the work will be completed. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1688 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Noe Valley INGLESIDE 37.742449574097 -122.42448419689501 POINT (-122.4244842 37.74244957) Twitter https://t.co/CWiNzvluso 84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
3096260 3096260 7227310 2017-06-05T17:23:27 2017-06-06T17:00:00 2017-06-06T17:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of TENNESSEE ST and 20TH ST TENNESSEE ST 10 Dogpatch BAYVIEW 37.760434135164 -122.389485190982 POINT (-122.38948519 37.76043414) Twitter https://t.co/CCWzS1VFLm 55 2 9 26 8 10 3 28,856 3 29 29 20 55   9 22     22 14   1         55
613572 613572 10541974 2019-02-27T14:15:00 2019-03-04T11:20:00 2019-03-04T11:20:00 Closed 2 Reported to CalTrans. 311 Service Request Queue - Hold 25 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BEALE ST and BRYANT ST BEALE ST 6 Rincon Hill SOUTHERN 37.786224365234 -122.389633178711 POINT (-122.38963318 37.78622437) Twitter https://t.co/BpF08YYZsW 31 1 10 8 9 6 2 28,855 2 6 6   31   10             1         31

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