calls

80,878 rows where Category = 1 sorted by Responsible_Agency 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
3690250 3690250 10888688 2019-05-20T20:16:00 2019-06-10T11:11:00 2019-06-10T11:11:00 Closed 2 Contractor reminded to put up tree protection. DPW IDC Queue 61 Tree Maintenance 1 Trees - Tree_Other 4 Other 2026 MARIPOSA ST, SAN FRANCISCO, CA, 94107 MARIPOSA ST 10 Potrero Hill BAYVIEW 37.763499738684004 -122.40361439075599 POINT (-122.40361439 37.76349974) Mobile/Open311 http://mobile311.sfgov.org/reports/10888688/photos 54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
3617139 3617139 10772412 2019-04-24T13:12:00 2019-04-29T14:40:10 2019-04-29T14:40:10 Closed 2 sfpd -appropriate enforcement measures have been taken. Duplicate Case Hold Queue 60 Tree Maintenance 1 Trees - Tree_Other 4 Other 152 3RD AVE, SAN FRANCISCO, CA, 94118 3RD AVE 2 Presidio Terrace RICHMOND 37.785717104597 -122.461291272307 POINT (-122.46129127 37.7857171) Mobile/Open311   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
3792776 3792776 11230504 2019-08-05T16:52:00 2019-09-21T10:31:26 2019-09-21T10:31:26 Closed 2 Encampment Removed Close Note: Duplicate Case Hold Queue 60 Tree Maintenance 1 Trees - Landscaping 5 Other 625 BAY SHORE BLVD, SAN FRANCISCO, CA, 94124 BAY SHORE BLVD 10 Apparel City BAYVIEW 37.736814493025996 -122.406825071198 POINT (-122.40682507 37.73681449) Web   83 2 2 25 7 10 3 58 3 28 28   83   2             2         83
2794789 2794789 6473565 2016-10-29T10:47:31 2016-10-31T11:44:52 2016-10-31T11:44:52 Closed 2 COURTESY LETTER ISSUED PUC - Water Waste - Customer Service Queue 59 Tree Maintenance 1 Trees - Tree_Other 4 Other 366 LIBERTY ST, SAN FRANCISCO, CA, 94114 LIBERTY ST 8 Dolores Heights MISSION 37.757275756484 -122.429346079121 POINT (-122.42934608 37.75727576) Mobile/Open311 http://mobile311.sfgov.org/reports/6473565/photos 52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
2567197 2567197 5709300 2016-03-29T09:09:24 2018-08-30T11:16:28 2018-08-30T11:16:28 Closed 2 Due to the length this case has been open, Rec and Park believes this issue has been resolved. If the issue is still valid, please recreate the service request. RPD Capital Queue 58 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4 GUY PL, SAN FRANCISCO, CA, 94105 GUY PL 6 Rincon Hill SOUTHERN 37.786827696592 -122.39402291301901 POINT (-122.39402291 37.7868277) Phone   30 1 10 8 9 6 2 28,855 2 6 6   30   10         3   1         30
2383294 2383294 5559748 2016-02-11T16:05:19 2016-06-13T18:38:06 2016-06-13T18:38:06 Closed 2 not a city can call Recology_Overflowing 57 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2676 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.754490483405 -122.41446536617599 POINT (-122.41446537 37.75449048) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
2370647 2370647 5381690 2015-12-16T16:19:00   2019-07-30T14:46:09 Open 1 in progress PUC - Sewer - G 56 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 3264 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.745826969003 -122.413602169536 POINT (-122.41360217 37.74582697) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2271660 2271660 5061863 2015-09-03T07:26:14 2016-06-13T07:33:53 2016-06-13T07:33:53 Closed 2 Pickup completed COMPLETED BY DPW Recology_Litter 55 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 525 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Civic Center NORTHERN 37.781086666667 -122.419241666667 POINT (-122.41924167 37.78108667) Mobile/Open311 http://mobile311.sfgov.org/reports/5061863/photos 21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
2375775 2375775 5490711 2016-01-21T19:53:03 2016-01-22T07:26:47 2016-01-22T07:26:47 Closed 2 resolved: DUPLICATE SERVICE REQUEST DUPLICATE PER BSES Recology_Litter 55 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SAINT CHARLES AVE and PAYSON ST SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.712188720703004 -122.46929931640601 POINT (-122.46929932 37.71218872) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
3667805 3667805 11040346 2019-06-24T15:45:00 2019-06-25T09:17:49 2019-06-25T09:17:49 Closed 2 Pickup completed REALLOCATED TO RECOLOGY OPERATIONS Recology_Litter 55 Tree Maintenance 1 Trees - Tree_Other 4 Other 6524 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bret Harte BAYVIEW 37.71907604488 -122.397243012785 POINT (-122.39724301 37.71907604) Mobile/Open311 http://mobile311.sfgov.org/reports/11040346/photos 88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
2171043 2171043 4653060 2015-04-10T11:05:18 2015-04-15T16:12:00 2015-04-15T16:12:00 Closed 2 See service request number 4668195 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 351 SAN LEANDRO WAY, SAN FRANCISCO, CA, 94127 SAN LEANDRO WAY 7 Balboa Terrace TARAVAL 37.730730458188 -122.468748741238 POINT (-122.46874874 37.73073046) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
2299780 2299780 4866480 2015-06-30T08:14:17 2015-08-12T09:22:49 2015-08-12T09:22:49 Closed 2 See service request number 4887067 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 8TH ST and DIVISION ST 8TH ST 10 Showplace Square SOUTHERN 37.769805104328 -122.403406068363 POINT (-122.40340607 37.7698051) Phone   33 1 9 4 8 8 2 28,853 2 20 20   33   9     2       1   2     33
2710678 2710678 6208238 2016-08-17T18:58:24 2016-09-09T14:45:29 2016-09-09T14:45:29 Closed 2 Already sent courtesy letter to this building on 8/24/2016 PUC - Water Waste - Water Queue 54 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH ST and MISSION ST 5TH ST 6 South of Market SOUTHERN 37.782731787459 -122.406481972863 POINT (-122.40648197 37.78273179) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32 1 10           1 2 1       32
2153398 2153398 4724092 2015-05-06T13:45:14   2015-05-27T11:51:35 Open 1 new City College - G 53 Tree Maintenance 1 Trees - Landscaping 5 Weeding 50 PHELAN AVE, SAN FRANCISCO, CA, 94112 PHELAN AVE 7 Sunnyside INGLESIDE 37.724439061392005 -122.452293229392 POINT (-122.45229323 37.72443906) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8 19     19 13   1         95
2056829 2056829 4635704 2015-04-04T08:07:43 2015-04-07T11:40:42 2015-04-07T11:40:42 Closed 2 Tree complaint has been sent to DPW Urban Forestry 415-641-2676. HIS complaint # 201539262 for falling fence was filed with Housing Inspection Division (415) 558-6220. To view the status, please go to our website www.sfdbi.org DBI Building Inspection Queue 52 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 4190 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.734791594593 -122.413834948207 POINT (-122.41383495 37.73479159) Mobile/Open311 http://mobile311.sfgov.org/reports/4635704/photos 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2637394 2637394 6098997 2016-07-19T15:58:29 2016-09-06T13:27:22 2016-09-06T13:27:22 Closed 2 No description of complaint DBI Building Inspection Queue 52 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 149 MANGELS AVE, SAN FRANCISCO, CA, 94131 MANGELS AVE 8 Sunnyside INGLESIDE 37.732977761453 -122.440750900986 POINT (-122.4407509 37.73297776) Phone   95 9 5 41 5 9 4 63 7 40 40   95   5             1         95
2014754 2014754 4302807 2014-12-15T05:38:11 2015-04-09T15:18:16 2015-04-09T15:18:16 Closed 2   PUC - Other - G 51 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
1964040 1964040 3985064 2014-09-05T16:32:11 2015-05-11T21:24:41 2015-05-11T21:24:41 Closed 2 Per process - cases are closed 14 days after assignment. City Attorney - G 50 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots Intersection of DOLORES ST and VALLEY ST DOLORES ST 8 Noe Valley INGLESIDE 37.744636535645 -122.424461364746 POINT (-122.42446136 37.74463654) Web   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
1868601 1868601 3668978 2014-05-22T18:12:56 2014-10-22T15:19:44 2014-10-22T15:19:44 Closed 2 PSR 463227 , forwarded to Facilities Maintenance MUNI Work Queue 49 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MASONIC AVE and GEARY BLVD MASONIC AVE 2 Lone Mountain RICHMOND 37.782390594482 -122.447303771973 POINT (-122.44730377 37.78239059) Web   12 8 4 18 2 15 8 54 5 16 16   12   4             1     7   12
1816151 1816151 3675674 2014-05-25T11:00:24 2015-06-10T13:31:42 2015-06-10T13:31:42 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 50 CARMELITA ST, SAN FRANCISCO, CA, 94117 CARMELITA ST 8 Duboce Triangle PARK 37.769498271036 -122.43390182703399 POINT (-122.43390183 37.76949827) Mobile/Open311 http://mobile311.sfgov.org/reports/3675674/photos 28 7 5 3 5 15 8 29,492 5 9 9   28   5       20     1         28
1832642 1832642 3721649 2014-06-08T18:52:55 2015-06-10T13:31:38 2015-06-10T13:31:38 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of GREAT HWY and TARAVAL ST GREAT HWY 4 Outer Sunset TARAVAL 37.741671392431 -122.506864755319 POINT (-122.50686476 37.74167139) Twitter   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
1837292 1837292 3646739 2014-05-15T17:48:51 2015-06-10T13:31:44 2015-06-10T13:31:44 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of PORTOLA DR and DIAMOND HEIGHTS BLVD PORTOLA DR 8 Upper Market INGLESIDE 37.74694442749 -122.44484710693399 POINT (-122.44484711 37.74694443) Web   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
1902513 1902513 3718648 2014-06-07T16:13:06 2015-06-10T13:31:39 2015-06-10T13:31:39 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 350 OSHAUGHNESSY BLVD, SAN FRANCISCO, CA, 94127 OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.74210952229 -122.446358033396 POINT (-122.44635803 37.74210952) Phone   72 9 8 41 4 9 4 63 7 40 40   72   8             1         72
1903168 1903168 3726171 2014-06-10T07:51:29 2015-06-10T13:31:37 2015-06-10T13:31:37 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 366 FUNSTON AVE, SAN FRANCISCO, CA, 94118 FUNSTON AVE 1 Inner Richmond RICHMOND 37.781328575528 -122.471754812909 POINT (-122.47175481 37.78132858) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1908070 1908070 3648404 2014-05-16T11:00:40 2015-06-10T13:31:43 2015-06-10T13:31:43 Closed 2 Administrative Close Rec and Park 48 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DIAMOND HEIGHTS BLVD and ELK ST DIAMOND HEIGHTS BLVD 8 Glen Park INGLESIDE 37.737198028102 -122.439692000294 POINT (-122.439692 37.73719803) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
1795145 1795145 3725319 2014-06-09T17:40:10 2014-07-22T08:30:11 2014-07-22T08:30:11 Closed 2 same as #3720455 RPD - Park Patrol - G 47 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of GREAT HWY and SANTIAGO ST GREAT HWY 4 Outer Sunset TARAVAL 37.743533712912004 -122.50719525645799 POINT (-122.50719526 37.74353371) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
1985542 1985542 3996951 2014-09-09T19:47:32 2014-09-20T14:27:30 2014-09-20T14:27:30 Closed 2 Duplicate of #3996932 RPD - Park Patrol - G 47 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PARK PRESIDIO BLVD and BALBOA ST PARK PRESIDIO BLVD 1 Inner Richmond RICHMOND 37.776868237255 -122.47204131256001 POINT (-122.47204131 37.77686824) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
1794875 1794875 3637109 2014-05-12T23:24:48 2014-05-13T13:58:25 2014-05-13T13:58:25 Closed 2 No contact information provided, need more information 311 Service Request Queue 46 Tree Maintenance 1 Trees - Overgrown_Tree 3 Overgrown_Tree Intersection of 18TH ST and I-280 S OFF RAMP 18TH ST 10 Potrero Hill BAYVIEW 37.762904507728 -122.39291429574 POINT (-122.3929143 37.76290451) Mobile/Open311 http://mobile311.sfgov.org/reports/3637109/photos 54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
2232499 2232499 4889078 2015-07-07T15:07:13 2015-07-08T13:10:19 2015-07-08T13:10:19 Closed 2 Contacted SFUSD (School District) - 415-695-5525 [Call: 415-695-5525] Monday thru Friday - Work control - Tree contractor will go out this afternoon. 311 Service Request Queue 46 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of ELLIS ST and INCA LN ELLIS ST 5 Western Addition NORTHERN 37.782827154641 -122.428821988581 POINT (-122.42882199 37.78282715) Phone   97 4 11 39 11 7 6 29,490 9 41 41 8 97   11 9     9     2         97
2247195 2247195 4872293 2015-07-01T13:46:02 2015-07-10T11:03:03 2015-07-10T11:03:03 Closed 2 See corrected SR # 4897833 311 Service Request Queue 46 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MIDDLE POINT RD and INNES AVE MIDDLE POINT RD 10 Hunters Point BAYVIEW 37.73407900334 -122.37943151584 POINT (-122.37943152 37.734079) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
3250286 3250286 8144233 2017-10-15T20:06:00 2017-10-30T16:54:00 2017-10-30T16:54:00 Closed 2   311 Service Request Queue 46 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Garden for the Environment, , SAN FRANCISCO, CA, 94122 Garden for the Environment 7 Inner Sunset PARK 37.759121666667 -122.463821666667 POINT (-122.46382167 37.75912167) Mobile/Open311 http://mobile311.sfgov.org/reports/8144233/photos 109 7 8 14 4 1 8 56 5 12 12   109   8             1         109
3406751 3406751 8775644 2018-03-22T14:42:00 2018-03-22T18:58:00 2018-03-22T18:58:00 Closed 2   311 Service Request Queue 46 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 14TH ST and SANCHEZ ST 14TH ST 8 Duboce Triangle PARK 37.767593383789 -122.431190490723 POINT (-122.43119049 37.76759338) Phone   28 7 5 5 5 15 6 28,862 9 3 3 18 28   5 20     20     1   5     28
3524723 3524723 8775651 2018-03-22T14:44:00 2018-03-22T15:49:00 2018-03-22T15:49:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-03-22T14:52:47 : Duplicate 311 Service Request Queue 46 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 14TH ST and SANCHEZ ST 14TH ST 8 Duboce Triangle PARK 37.767593383789 -122.431190490723 POINT (-122.43119049 37.76759338) Phone   28 7 5 5 5 15 6 28,862 9 3 3 18 28   5 20     20     1   5     28
3713770 3713770 11163844 2019-07-22T13:40:00 2019-07-22T17:37:00 2019-07-22T17:37:00 Closed 2   311 Service Request Queue 46 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 325 OLMSTEAD ST, SAN FRANCISCO, CA, 94134 OLMSTEAD ST 9 Portola BAYVIEW 37.721556054253995 -122.40503879363999 POINT (-122.40503879 37.72155605) Web http://mobile311.sfgov.org/reports/11163844/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             1         91
1651169 1651169 3324244 2014-01-30T23:12:14 2014-03-06T13:57:54 2014-03-06T13:57:54 Closed 2   RPD - Structural Maintenance - G 45 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PARK PRESIDIO BLVD and CLEMENT ST PARK PRESIDIO BLVD 1 Inner Richmond RICHMOND 37.782577514648 -122.472450256348 POINT (-122.47245026 37.78257751) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
1615995 1615995 2601427 2013-07-15T08:44:47 2013-07-15T14:36:55 2013-07-15T14:36:55 Closed 2 Replaced with SR 2603687 to park and rec Housing Authority SR Hold Queue 44 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1329 PIERCE ST, SAN FRANCISCO, CA, 94115 PIERCE ST 5 Western Addition NORTHERN 37.782459259033 -122.43604278564501 POINT (-122.43604279 37.78245926) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
1364094 1364094 1129602 2012-05-22T15:58:53   2012-05-23T14:05:46 Open 1 open DPW - Bureau of Street and Sewer Repair - G 43 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 2001 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mission Dolores MISSION 37.768623352051 -122.427177429199 POINT (-122.42717743 37.76862335) Phone   37 3 5 5 5 8 7 28,862 4 3 3   37   5   12     9   1   5     37
1080023 1080023 722767 2010-08-30T10:28:18 2010-09-24T16:42:55 2010-09-24T16:42:55 Closed 2   DBI Support Services Queue 42 Tree Maintenance 1 Trees - Landscaping 5 Weeding 151 PINEHURST WAY, SAN FRANCISCO, CA, 94127 PINEHURST WAY 7 Mt. Davidson Manor TARAVAL 37.729137420654 -122.46436309814501 POINT (-122.4643631 37.72913742) Phone   68 10 8 41 4 9 5 59 8 40 40   68   8             1         68
1010020 1010020 688695 2010-07-07T09:03:11 2010-07-07T14:11:51 2010-07-07T14:11:51 Closed 2   DPT - Other - G 41 Tree Maintenance 1 Trees - Landscaping 5 Landscaping request Intersection of BRODERICK ST and HAIGHT ST BRODERICK ST 5 Buena Vista PARK 37.771057128906 -122.438705444336 POINT (-122.43870544 37.77105713) Web   112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
779162 779162 338737 2008-12-25T12:00:38 2008-12-25T14:07:05 2008-12-25T14:07:05 Closed 2   RPD Urban Forestry Queue 40 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 332 FUNSTON AVE, SAN FRANCISCO, CA, 94118 FUNSTON AVE 1 Inner Richmond RICHMOND 37.781967163086 -122.471733093262 POINT (-122.47173309 37.78196716) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1324430 1324430 1078012 2012-03-05T09:09:22 2012-03-07T07:04:36 2012-03-07T07:04:36 Closed 2 road cleared RPD Urban Forestry Queue 40 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 29TH AVE and LINCOLN WAY 29TH AVE 1 Golden Gate Park TARAVAL 37.76496887207 -122.487968444824 POINT (-122.48796844 37.76496887) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
764727 764727 276948 2008-09-06T08:41:10 2010-03-26T13:53:38 2010-03-26T13:53:38 Closed 2   DPW Work Queue 39 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of KENSINGTON WAY and PORTOLA DR KENSINGTON WAY 7 Sherwood Forest INGLESIDE 37.740535736084 -122.45890808105499 POINT (-122.45890808 37.74053574) Phone   49 9 8 41 4 9 4 59 7 40 40   49   8             1         49
765200 765200 310489 2008-11-07T10:44:04 2010-03-26T13:56:13 2010-03-26T13:56:13 Closed 2   DPW Work Queue 39 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 7TH ST and BERRY ST 7TH ST 6 Mission Bay SOUTHERN 37.770515441895 -122.400024414063 POINT (-122.40002441 37.77051544) Phone   34 1 9 4 8 14 2 28,856 2 20 20   34   9             1         34
1341515 1341515 1131322 2012-05-24T19:13:21 2012-07-12T12:00:24 2012-07-12T12:00:24 Closed 2   DPW Work Queue 39 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 89 PARADISE AVE, SAN FRANCISCO, CA, 94131 PARADISE AVE 8 Glen Park INGLESIDE 37.735389709473 -122.43958282470699 POINT (-122.43958282 37.73538971) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
1446429 1446429 1222797 2012-08-02T11:43:03 2012-08-06T00:00:00 2012-08-06T00:00:00 Closed 2   DPW Work Queue 39 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 223 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.783203125 -122.41259002685499 POINT (-122.41259003 37.78320313) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1629125 1629125 2283374 2013-04-24T12:33:26   2013-04-24T13:52:48 Open 1 open DPW Work Queue 39 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1085 14TH ST, SAN FRANCISCO, CA, 94114 14TH ST 8 Corona Heights PARK 37.767044067383 -122.437690734863 POINT (-122.43769073 37.76704407) Phone   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
1735610 1735610 2840855 2013-09-17T22:09:42   2013-09-18T05:14:45 Open 1 open DPW Work Queue 39 Tree Maintenance 1 Trees - Damaged_Tree 1 damaged_vandalism Intersection of 19TH ST and SANCHEZ ST 19TH ST 8 Dolores Heights MISSION 37.759529775975 -122.430578721801 POINT (-122.43057872 37.75952978) Mobile/Open311 http://mobile311.sfgov.org/reports/2840855/photos 52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
683740 683740 287852 2008-09-26T07:46:26 2008-10-23T11:14:19 2008-10-23T11:14:19 Closed 2 Palou/Selby Mini Park - water leak repaired. RPD Neighborhood Service Area 7 Queue 38 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PALOU AVE and SELBY ST PALOU AVE 10 Silver Terrace BAYVIEW 37.739276885986 -122.400245666504 POINT (-122.40024567 37.73927689) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
688190 688190 314596 2008-11-14T20:44:11 2008-11-20T11:50:03 2008-11-20T11:50:03 Closed 2 As of 11/19/08 water had been shut off. RPD Neighborhood Service Area 7 Queue 38 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues India Basin/Shoreline Park, SAN FRANCISCO, CA India Basin/Shoreline Park 10 India Basin BAYVIEW 37.733661651611 -122.37371826171899 POINT (-122.37371826 37.73366165) Phone     2 9   8   3   3           9                        
765358 765358 349112 2009-01-11T11:51:37 2009-01-13T18:18:15 2009-01-13T18:18:15 Closed 2 Area cleaned on 1/12/09 per NSA manager. RPD Neighborhood Service Area 7 Queue 38 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of QUESADA AVE and SELBY ST QUESADA AVE 10 Silver Terrace BAYVIEW 37.738647460938 -122.400810241699 POINT (-122.40081024 37.73864746) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
781753 781753 284366 2008-09-19T14:38:10 2008-10-29T11:56:58 2008-10-29T11:56:58 Closed 2   RPD Neighborhood Service Area 7 Queue 38 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of JENNINGS ST and PALOU AVE JENNINGS ST 10 Bayview BAYVIEW 37.73078918457 -122.385284423828 POINT (-122.38528442 37.73078918) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
675866 675866 305252 2008-10-28T19:29:18 2008-10-31T14:51:57 2008-10-31T14:51:57 Closed 2 Duplicate of #305249 RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Pine Lake Park, SAN FRANCISCO, CA, 94132 Pine Lake Park 4 Parkside TARAVAL 37.736309051514 -122.48593139648399 POINT (-122.4859314 37.73630905) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
684338 684338 400535 2009-03-29T19:21:41 2013-09-09T15:31:38 2013-09-09T15:31:38 Closed 2   RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of ALEMANY BLVD and CHESTER AVE ALEMANY BLVD 7 Merced Heights TARAVAL 37.709899902344 -122.470405578613 POINT (-122.47040558 37.7098999) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
719590 719590 305953 2008-10-30T08:57:27 2008-10-30T10:03:53 2008-10-30T10:03:53 Closed 2 Aware of issues with broken sprinkler RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues McCoppin Square, SAN FRANCISCO, CA, 94116 McCoppin Square 4 Parkside TARAVAL 37.743827819824 -122.480079650879 POINT (-122.48007965 37.74382782) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7 25 8   24     1         40
795487 795487 294154 2008-10-07T20:53:52 2008-10-09T17:10:39 2008-10-09T17:10:39 Closed 2 Hose repaired. RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Sigmund Stern Recreation Grove, SAN FRANCISCO, CA, 94132 Sigmund Stern Recreation Grove 4 Parkside TARAVAL 37.736083984375 -122.47829437255899 POINT (-122.47829437 37.73608398) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
943745 943745 745421 2010-10-03T18:14:09 2011-11-29T16:13:04 2011-11-29T16:13:04 Closed 2 Request cancelled. RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Tree_Other 4 Other 236 CLAREMONT BLVD, SAN FRANCISCO, CA, 94127 CLAREMONT BLVD 7 West Portal TARAVAL 37.741607666016 -122.46450805664101 POINT (-122.46450806 37.74160767) Web   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
672714 672714 267066 2008-08-19T10:37:24 2008-09-10T16:09:14 2008-09-10T16:09:14 Closed 2 Case Resolved BSM Inspector Miguel Navarro inspected (RFA 20089984) the site and found: Damaged ASW at 34 Prospect Ave. Damaged ASW & missing tree at Fair Ave/Prosoect intersection. Damaged ASW, warped sidewalk at garage entrance and damaged metal curb at 42 & 44 Propect Ave. Actions Taken: NTR# 39403, NTR# 39404, NTR# 39405 to PO, X1104# 36136, X1104# 36140, X1104# 36141 TO; Notices sent to DPW-Urban Forestry. DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of FAIR AVE and PROSPECT AVE FAIR AVE 9 Bernal Heights INGLESIDE 37.744770050049 -122.41785430908199 POINT (-122.41785431 37.74477005) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
676161 676161 396937 2009-03-24T12:52:35 2009-06-19T05:10:58 2009-06-19T05:10:58 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 201 SANCHEZ ST, SAN FRANCISCO, CA, 94114 SANCHEZ ST 8 Mission Dolores MISSION 37.765693664551 -122.430824279785 POINT (-122.43082428 37.76569366) Phone   37 3 5 5 5 8 7 28,862 4 3 3   37   5   12     9   1   5     37
677759 677759 447707 2009-06-10T13:43:10 2010-09-06T04:44:10 2010-09-06T04:44:10 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 215 MISSOURI ST, SAN FRANCISCO, CA, 94107 MISSOURI ST 10 Potrero Hill BAYVIEW 37.763610839844 -122.396446228027 POINT (-122.39644623 37.76361084) Phone   54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
685363 685363 386703 2009-03-10T11:46:29 2009-06-05T05:10:48 2009-06-05T05:10:48 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 21ST ST and HARRISON ST 21ST ST 9 Mission MISSION 37.757431030273 -122.41234588623001 POINT (-122.41234589 37.75743103) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
704801 704801 332828 2008-12-15T13:32:47 2009-03-03T05:10:05 2009-03-03T05:10:05 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1426 FLORIDA ST, SAN FRANCISCO, CA, 94110 FLORIDA ST 9 Mission MISSION 37.749031066895 -122.409873962402 POINT (-122.40987396 37.74903107) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       1   3     53
706211 706211 401640 2009-03-31T09:42:06 2009-05-29T17:15:59 2009-05-29T17:15:59 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of CRESTLAKE DR and PALOS PL CRESTLAKE DR 4 Parkside TARAVAL 37.735080718994006 -122.48501586914101 POINT (-122.48501587 37.73508072) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
718941 718941 386719 2009-03-10T12:06:27 2009-04-23T05:10:28 2009-04-23T05:10:28 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 378 LOS PALMOS DR, SAN FRANCISCO, CA, 94127 LOS PALMOS DR 7 Miraloma Park INGLESIDE 37.735000610352 -122.450752258301 POINT (-122.45075226 37.73500061) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
728115 728115 447706 2009-06-10T13:41:50 2010-09-06T04:44:09 2010-09-06T04:44:09 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 221 MISSOURI ST, SAN FRANCISCO, CA, 94107 MISSOURI ST 10 Potrero Hill BAYVIEW 37.763534545898 -122.39640045166 POINT (-122.39640045 37.76353455) Phone   54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
765357 765357 403228 2009-04-02T09:59:24 2009-04-09T05:10:27 2009-04-09T05:10:27 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2731 FRANKLIN ST, SAN FRANCISCO, CA, 94123 FRANKLIN ST 2 Union Street NORTHERN 37.799728393555 -122.426078796387 POINT (-122.4260788 37.79972839) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
779980 779980 262982 2008-08-11T12:13:51 2008-09-15T22:40:50 2008-09-15T22:40:50 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1470 45TH AVE, SAN FRANCISCO, CA, 94122 45TH AVE 4 Outer Sunset TARAVAL 37.759170532227 -122.504608154297 POINT (-122.50460815 37.75917053) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
848368 848368 529970 2009-10-22T11:33:59 2013-04-04T05:21:09 2013-04-04T05:21:09 Closed 2 resolved: tree inside the private property (on the easement) @ 235 Otsego looks dead - notified James from BUF with photo thru email Admin Closed per CPW DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 235 OTSEGO AVE, SAN FRANCISCO, CA, 94112 OTSEGO AVE 11 Mission Terrace INGLESIDE 37.724132537842 -122.440391540527 POINT (-122.44039154 37.72413254) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
893695 893695 467431 2009-07-13T11:55:50 2009-08-25T12:28:18 2009-08-25T12:28:18 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CASITAS AVE and CRESTA VISTA DR CASITAS AVE 7 Sherwood Forest INGLESIDE 37.735504150391 -122.45970916748001 POINT (-122.45970917 37.73550415) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
923051 923051 476116 2009-07-27T12:54:11 2009-08-25T12:29:28 2009-08-25T12:29:28 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 35 PARK ST, SAN FRANCISCO, CA, 94110 PARK ST 8 Holly Park INGLESIDE 37.736808776855 -122.42530059814501 POINT (-122.4253006 37.73680878) Phone   61 9 5 2 5 2 4 28,859 7 2 2   61   5             1         61
937931 937931 468150 2009-07-14T10:32:19 2009-08-25T12:28:24 2009-08-25T12:28:24 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1149 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Ashbury Heights PARK 37.763347625732 -122.449638366699 POINT (-122.44963837 37.76334763) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
945748 945748 767968 2010-11-08T09:18:56 2015-12-02T11:16:00 2015-12-02T11:16:00 Closed 2 resolved: Massive tree with big low branches, root damaged asw and curb. Tree stump. 5/5/2011 damaged asw and curb repaired. Low tree branches & tree stump removed. Two empty tree basins need to be re-planted.JP - NTR # 952082, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 140 MADRONE AVE, SAN FRANCISCO, CA, 94127 MADRONE AVE 7 West Portal TARAVAL 37.740859985352 -122.46802520751999 POINT (-122.46802521 37.74085999) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
951115 951115 754021 2010-10-16T16:43:08 2011-03-17T12:03:25 2011-03-17T12:03:25 Closed 2 Confirmed with DPW - work previously completed. DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 567 CORBETT AVE, SAN FRANCISCO, CA, 94114 CORBETT AVE 8 Clarendon Heights PARK 37.757343292236 -122.443809509277 POINT (-122.44380951 37.75734329) Phone   47 7 5 5 5 2 8 28,862 5 3 3   47   5             1         47
967774 967774 763307 2010-10-31T19:06:36 2011-01-14T04:34:29 2011-01-14T04:34:29 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
969392 969392 779219 2010-11-28T10:16:49 2011-01-12T04:34:27 2011-01-12T04:34:27 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 33 ELSIE ST, SAN FRANCISCO, CA, 94110 ELSIE ST 9 Bernal Heights INGLESIDE 37.744518280029 -122.416458129883 POINT (-122.41645813 37.74451828) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
977603 977603 696400 2010-07-19T11:56:11 2011-03-17T12:03:26 2011-03-17T12:03:26 Closed 2 Confirmed with DPW - work previously completed. DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2345 WAWONA ST, SAN FRANCISCO, CA, 94116 WAWONA ST 4 Parkside TARAVAL 37.737049102783 -122.492156982422 POINT (-122.49215698 37.7370491) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
985768 985768 764564 2010-11-02T12:22:03 2013-07-23T04:42:03 2013-07-23T04:42:03 Closed 2 resolved: damaged sidewalk around private trees on Bennington frontage fronting 399 Cortland Ave - NTR # 951167, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of BENNINGTON ST and CORTLAND AVE BENNINGTON ST 9 Holly Park INGLESIDE 37.739185333252 -122.417778015137 POINT (-122.41777802 37.73918533) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
988292 988292 785055 2010-12-07T16:13:54 2014-03-09T05:14:31 2014-03-09T05:14:31 Closed 2 resolved: Found tree roots lifting street lighting box - X1104 # 981879, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1846 SACRAMENTO ST, SAN FRANCISCO, CA, 94109 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.791301727295 -122.423309326172 POINT (-122.42330933 37.79130173) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
988429 988429 790233 2010-12-16T16:55:55 2013-04-16T04:38:44 2013-04-16T04:38:44 Closed 2 resolved: overgrown tree branches fronting 469 Vernon St - NTR # 953234, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 469 VERNON ST, SAN FRANCISCO, CA, 94132 VERNON ST 11 Ingleside TARAVAL 37.720886230469 -122.46818542480499 POINT (-122.46818542 37.72088623) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
992325 992325 784362 2010-12-06T16:52:21 2014-10-21T12:00:00 2014-10-21T12:00:00 Closed 2 resolved: No conditions foundNo conditions foundNo conditions found - No Action RequiredNo Action RequiredNo Action Required DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 431 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.739418029785 -122.437431335449 POINT (-122.43743134 37.73941803) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
993500 993500 691988 2010-07-12T13:24:25 2013-11-11T05:06:06 2013-11-11T05:06:06 Closed 2 resolved: Dup RFA#21059376 - NTR Number 945929 DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 353 10TH ST, SAN FRANCISCO, CA, 94103 10TH ST 6 South of Market SOUTHERN 37.772254943848 -122.411849975586 POINT (-122.41184998 37.77225494) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32   10             2         32
1003759 1003759 764643 2010-11-02T13:38:44 2010-11-02T14:23:08 2010-11-02T14:23:08 Closed 2 Customer notified that the owner of the property is responsible for this tree. DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 207 11TH ST, SAN FRANCISCO, CA, 94103 11TH ST 6 South of Market SOUTHERN 37.773017883301 -122.415199279785 POINT (-122.41519928 37.77301788) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
1007344 1007344 759371 2010-10-25T15:28:52 2010-12-23T04:34:24 2010-12-23T04:34:24 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1010499 1010499 764569 2010-11-02T12:27:13 2014-01-15T05:21:42 2014-01-15T05:21:42 Closed 2 resolved: 155 sq ft damaged sidewalk, 2 trees with root problems; both with LTB. - painted, posted, took pics;NTR # 950694, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 404 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.771820068359 -122.447227478027 POINT (-122.44722748 37.77182007) Twitter   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
1027336 1027336 795975 2010-12-28T11:48:00 2012-06-01T04:38:32 2012-06-01T04:38:32 Closed 2 resolved: damaged sidewalk - notified BUFX1104 # 953023, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of HARRISON ST and PRECITA AVE HARRISON ST 9 Bernal Heights INGLESIDE 37.746879577637 -122.41161346435499 POINT (-122.41161346 37.74687958) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
1033981 1033981 696665 2010-07-19T16:46:44 2014-09-26T11:58:00 2014-09-26T11:58:00 Closed 2 resolved: Found damaged sidewalk at two properties - NTR # 947024,NTR # 947026, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Tree_Other 4 Other 37 FREDERICK ST, SAN FRANCISCO, CA, 94117 FREDERICK ST 8 Buena Vista PARK 37.76732635498 -122.44450378418001 POINT (-122.44450378 37.76732635) Twitter   112 7 5 3 5 15 8 29,492 5 9 9   112   5             1         112
1036537 1036537 716952 2010-08-20T13:24:06 2011-06-20T08:56:27 2011-06-20T08:56:27 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of GRANT AVE and PINE ST GRANT AVE 3 Chinatown CENTRAL 37.791496276855 -122.40573883056601 POINT (-122.40573883 37.79149628) Phone   104 6 3 8 10 5 1 28,857 1 6 6   104   3             2         104
1047798 1047798 703044 2010-07-29T18:22:14 2013-03-26T04:44:39 2013-03-26T04:44:39 Closed 2 resolved: 2 cm trees with root problems & damaged sidewalk in front of 1799 Fulton St/masonic ave frontage. - painted, took pics;X1104 # 946824, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of FULTON ST and MASONIC AVE FULTON ST 5 Lone Mountain PARK 37.775802612305 -122.44647216796899 POINT (-122.44647217 37.77580261) Phone   12 7 4 18 2 15 8 29,492 5 16 16   12   4             1         12
1051691 1051691 786712 2010-12-10T12:25:03 2015-12-09T12:00:00 2015-12-09T12:00:00 Closed 2 resolved: 12/9/15: No condition found. GS - DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of RANDALL ST and SAN JOSE AVE RANDALL ST 8 Holly Park INGLESIDE 37.739868164063 -122.42414855956999 POINT (-122.42414856 37.73986816) Phone   61 9 5 10 5 2 4 28,859 7 7 7   61   5             1         61
1062372 1062372 790228 2010-12-16T16:48:45 2013-03-28T04:35:14 2013-03-28T04:35:14 Closed 2 resolved: City Maintained trees with root problems, damaging sidewalk; 40 sq ft - painted; photos;X1104 # 955943, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1624 EDDY ST, SAN FRANCISCO, CA, 94115 EDDY ST 5 Western Addition NORTHERN 37.781299591064 -122.43445587158199 POINT (-122.43445587 37.78129959) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
1085938 1085938 833522 2011-02-28T08:55:17 2011-03-02T04:32:32 2011-03-02T04:32:32 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of BUCHANAN ST and BUSH ST BUCHANAN ST 5 Japantown NORTHERN 37.787441253662 -122.43016815185499 POINT (-122.43016815 37.78744125) Phone   101 4 11 30 11 13 6 29,490 9 27 27   101   11             1         101
1095530 1095530 869311 2011-04-25T18:13:52 2014-08-19T08:09:00 2014-08-19T08:09:00 Closed 2 resolved: Root damaged asw & curb. - NTR # 958539, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 218 FLOOD AVE, SAN FRANCISCO, CA, 94112 FLOOD AVE 7 Sunnyside INGLESIDE 37.730007171630994 -122.44476318359399 POINT (-122.44476318 37.73000717) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
1105230 1105230 920291 2011-07-14T15:24:49   2011-07-14T18:33:14 Open 1 Open DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CLARENDON AVE and LAGUNA HONDA BLVD CLARENDON AVE 7 Forest Hill PARK 37.751502990723 -122.461524963379 POINT (-122.46152496 37.75150299) Phone   45 7 8 41 4 1 8 63 5 40 40   45   8             1         45
1107345 1107345 870032 2011-04-26T17:38:09 2016-03-02T12:00:00 2016-03-02T12:00:00 Closed 2 Case Resolved: the side of telegraph hill coming down to Sansome has foliage that in some places is growing through the fence. - DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of GREEN ST and SANSOME ST GREEN ST 3 Telegraph Hill CENTRAL 37.800308227539 -122.402603149414 POINT (-122.40260315 37.80030823) Phone   77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
1119259 1119259 879385 2011-05-10T21:16:27 2014-10-17T12:00:00 2014-10-17T12:00:00 Closed 2 resolved: No conditions found - No Action Required DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of LYON ST and PINE ST LYON ST 2 Lower Pacific Heights RICHMOND 37.786479949951 -122.445205688477 POINT (-122.44520569 37.78647995) Phone   103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
1135654 1135654 846038 2011-03-20T15:20:58 2014-07-23T12:00:00 2014-07-23T12:00:00 Closed 2 resolved: Several trees damaging the ASW at this locationl. - X1104 # 960498, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 22ND ST and POTRERO AVE 22ND ST 9 Mission MISSION 37.756168365479 -122.406639099121 POINT (-122.4066391 37.75616837) Phone   53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
1137565 1137565 869315 2011-04-25T18:17:12 2017-02-09T01:20:48 2017-02-09T01:20:48 Closed 2 Found raised \ damaged sidewalk around private tree. - NTR # 958708 DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 170 FLOOD AVE, SAN FRANCISCO, CA, 94131 FLOOD AVE 7 Sunnyside INGLESIDE 37.730010986328004 -122.44361114501999 POINT (-122.44361115 37.73001099) Phone   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
1163416 1163416 864015 2011-04-17T13:12:29 2016-04-26T03:49:00 2016-04-26T03:49:00 Closed 2 1 Tree damaging ASW at this location. - Photos taken NTR # 960062,X1104 # 960073,X1104 # 960076, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 560 3RD ST, SAN FRANCISCO, CA, 94107 3RD ST 6 South of Market SOUTHERN 37.780460357666 -122.39501190185499 POINT (-122.3950119 37.78046036) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
1164353 1164353 944225 2011-08-19T14:03:14 2012-05-10T04:35:59 2012-05-10T04:35:59 Closed 2 resolved: 401 Munich St: root damaged asw on both frontages due to City maintained trees along Persia Ave. SEC Persia Ave @ Munich St: root damaged asw due to City maintained trees along Persia Ave.. - X1104 # 964101,X1104 # 964102, DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of MUNICH ST and PERSIA AVE MUNICH ST 11 Excelsior INGLESIDE 37.719326019287 -122.427993774414 POINT (-122.42799377 37.71932602) Web   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
1164729 1164729 846612 2011-03-21T12:31:12 2013-10-03T04:41:58 2013-10-03T04:41:58 Closed 2 resolved: Overgrown City maintained tree, damaged asw,100Sf. - Closed. Will create new X1104 from RFA 21133556. Prior X1104 971299 also cancelled. TB DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1406 25TH AVE, SAN FRANCISCO, CA, 94122 25TH AVE 4 Outer Sunset TARAVAL 37.761211395264 -122.48324584960899 POINT (-122.48324585 37.7612114) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1183876 1183876 830289 2011-02-22T10:42:05 2011-03-25T04:31:10 2011-03-25T04:31:10 Closed 2   DPW - Bureau of Street Use and Mapping - G 36 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 202 FONT BLVD, SAN FRANCISCO, CA, 94132 FONT BLVD 7 Parkmerced TARAVAL 37.716770172119006 -122.474975585938 POINT (-122.47497559 37.71677017) Phone   42 10 8 16 4 1 5 64 8 14 14   42   8             2         42

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