calls

80,878 rows sorted by Request_Details

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
1750934 1750934 3135047 2013-12-05T14:20:58 2014-01-29T15:18:53 2014-01-29T15:18:53 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1311 SUTTER ST, SAN FRANCISCO, CA, 94109 SUTTER ST 2 Cathedral Hill NORTHERN 37.787330616657 -122.42191099575001 POINT (-122.421911 37.78733062) Mobile/Open311 http://mobile311.sfgov.org/reports/3135047/photos 100 4 6 39 1 13 6 28,858 9 41 41   100   6             1         100
1751581 1751581 3065394 2013-11-14T16:51:21 2013-11-22T09:33:58 2013-11-22T09:33:58 Closed 2 resolved: Request closed by SES . Notes = " Notes:leaning at 45 degrees, probably hit by car. Building side root failure, removal is probable. Tom going to look at it 11_22_13. Maybe restake but unlikely.. BUF Action:INSPECT. date completed - 11/22/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 3RD ST and HOLLISTER AVE 3RD ST 10 Bret Harte BAYVIEW 37.721599191462005 -122.39584193576401 POINT (-122.39584194 37.72159919) Mobile/Open311 http://mobile311.sfgov.org/reports/3065394/photos 88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
1753122 1753122 3118789 2013-12-01T11:24:51 2014-01-01T23:01:20 2014-01-01T23:01:20 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   95 SANCHEZ ST, SAN FRANCISCO, CA, 94114 SANCHEZ ST 8 Duboce Triangle PARK 37.767719 -122.43101399999999 POINT (-122.431014 37.767719) Mobile/Open311 http://mobile311.sfgov.org/reports/3118789/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20     20     1   5     28
1753842 1753842 3381722 2014-02-19T08:28:04 2014-05-14T02:00:20 2014-05-14T02:00:20 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   25 HOLLY PARK CIR, SAN FRANCISCO, CA, 94110 HOLLY PARK CIR 9 Holly Park INGLESIDE 37.738156938385 -122.420533584903 POINT (-122.42053358 37.73815694) Mobile/Open311 http://mobile311.sfgov.org/reports/3381722/photos 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
1756021 1756021 3305508 2014-01-25T09:45:44 2014-02-08T15:20:22 2014-02-08T15:20:22 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 22ND ST and VALENCIA ST 22ND ST 8 Mission MISSION 37.755371765269 -122.421169951672 POINT (-122.42116995 37.75537177) Mobile/Open311 http://mobile311.sfgov.org/reports/3305508/photos 52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1758099 1758099 2990911 2013-10-26T15:48:58 2013-12-04T13:19:47 2013-12-04T13:19:47 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter to Park and Rec 12/4/13 DM. BUF Action:Correspondence. date completed - 12/4/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 19TH ST and DIAMOND ST 19TH ST 8 Eureka Valley MISSION 37.759235 -122.436752 POINT (-122.436752 37.759235) Mobile/Open311   38 3 5 5 5 2 7 28,862 4 3 3   38   5             1   5     38
1761734 1761734 3296098 2014-01-22T10:46:39 2014-01-23T10:00:49 2014-01-23T10:00:49 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 1/23/14 DM. BUF Action:Correspondence. date completed - 1/22/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   112 HYDE ST, SAN FRANCISCO, CA, 94102 HYDE ST 6 Tenderloin TENDERLOIN 37.781829955092 -122.41557167854401 POINT (-122.41557168 37.78182996) Mobile/Open311 http://mobile311.sfgov.org/reports/3296098/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
1763812 1763812 3151508 2013-12-10T14:37:36 2014-05-24T12:00:00 2014-05-24T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:empty basin confirmed. Request to be planted with Divis greening contract. BUF Action:PLANT. date completed - 5/24/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1000 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.7790545739 -122.438496938126 POINT (-122.43849694 37.77905457) Mobile/Open311 http://mobile311.sfgov.org/reports/3151508/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
1766337 1766337 3296469 2014-01-22T12:06:10 2014-01-23T05:10:43 2014-01-23T05:10:43 Closed 2 resolved: Duplicate to RFA 21141584 - DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4   256 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.783156475087 -122.413308145592 POINT (-122.41330815 37.78315648) Mobile/Open311 http://mobile311.sfgov.org/reports/3296469/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1767073 1767073 3300291 2014-01-23T13:43:52 2014-01-23T16:23:08 2014-01-23T16:23:08 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   1271 31ST AVE, SAN FRANCISCO, CA, 94122 31ST AVE 4 Outer Sunset TARAVAL 37.763565704262 -122.49043808330099 POINT (-122.49043808 37.7635657) Mobile/Open311   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1767100 1767100 2969602 2013-10-21T13:30:56 2013-10-25T11:17:37 2013-10-25T11:17:37 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1150 WAYLAND ST, SAN FRANCISCO, CA, 94134 WAYLAND ST 9 University Mound BAYVIEW 37.723739375595 -122.41360337479601 POINT (-122.41360337 37.72373938) Mobile/Open311 http://mobile311.sfgov.org/reports/2969602/photos 92 2 2 25 7 9 3 309 3 28 28   92   2             1         92
1768263 1768263 2946916 2013-10-15T14:19:56 2013-10-31T15:27:57 2013-10-31T15:27:57 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1300 BATTERY ST, SAN FRANCISCO, CA, 94111 BATTERY ST 3 Northern Waterfront CENTRAL 37.803504943848 -122.40187835693399 POINT (-122.40187836 37.80350494) Phone http://mobile311.sfgov.org/reports/2946916/photos 77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
1769230 1769230 2972830 2013-10-22T09:45:44 2013-10-29T04:17:56 2013-10-29T04:17:56 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1033 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.78144641645 -122.41093687396601 POINT (-122.41093687 37.78144642) Mobile/Open311 http://mobile311.sfgov.org/reports/2972830/photos 32 5 10 34 9 14 2 28,853 2 34 34 17 32 1 10 18 14 1 18 7 1 2 1 1     32
1769260 1769260 3284704 2014-01-18T11:28:33 2014-01-18T12:19:17 2014-01-18T12:19:17 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1630 POLK ST, SAN FRANCISCO, CA, 94109 POLK ST 3 Polk Gulch NORTHERN 37.792041839090004 -122.420783050522 POINT (-122.42078305 37.79204184) Mobile/Open311 http://mobile311.sfgov.org/reports/3284704/photos 105 4 3 21 10 13 6 28,858 9 21 21   105   3   18         1         105
1772122 1772122 3195981 2013-12-23T14:39:16 2013-12-30T23:00:21 2013-12-30T23:00:21 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3765 24TH ST, SAN FRANCISCO, CA, 94114 24TH ST 8 Dolores Heights MISSION 37.75175997798 -122.42682583930201 POINT (-122.42682584 37.75175998) Mobile/Open311 http://mobile311.sfgov.org/reports/3195981/photos 52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1774799 1774799 3305484 2014-01-25T09:35:07 2014-01-25T16:16:02 2014-01-25T16:16:02 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 22ND ST and VALENCIA ST 22ND ST 8 Mission MISSION 37.755371765269 -122.421169951672 POINT (-122.42116995 37.75537177) Mobile/Open311 http://mobile311.sfgov.org/reports/3305484/photos 52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1777866 1777866 3135146 2013-12-05T14:38:27 2014-01-17T16:01:34 2014-01-17T16:01:34 Closed 2 resolved: Request closed by SES . Notes = " Notes:missing Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum per google March 2011. confirmed vacant site per Wendy of Davey 10.10.12. BUF Action:TREE MISSING. date completed - 3/31/2011. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   609 LARCH ST, SAN FRANCISCO, CA, 94102 LARCH ST 5 Western Addition NORTHERN 37.782353374925 -122.420983454365 POINT (-122.42098345 37.78235337) Mobile/Open311 http://mobile311.sfgov.org/reports/3135146/photos 100 4 11 39 11 7 6 28,852 9 41 41   100 1 11             2         100
1781529 1781529 3626709 2014-05-09T10:23:38 2014-05-09T12:05:11 2014-05-09T12:05:11 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of LAGUNA ST and MARINA BLVD LAGUNA ST 2 Marina NORTHERN 37.805069 -122.432144 POINT (-122.432144 37.805069) Mobile/Open311 http://mobile311.sfgov.org/reports/3626709/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1     14   17
1781855 1781855 3825834 2014-07-14T12:02:49 2014-07-14T15:02:32 2014-07-14T15:02:32 Closed 2 Matter reported as test invaild report. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - NA 7   243 OAK ST, SAN FRANCISCO, CA, 94102 OAK ST 5 Lower Haight NORTHERN 37.774677747441004 -122.42338546829201 POINT (-122.42338547 37.77467775) Web   26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
1782135 1782135 3526142 2014-04-06T22:36:40 2014-04-07T10:19:14 2014-04-07T10:19:14 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   245 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Mission Dolores MISSION 37.766872 -122.42884099999999 POINT (-122.428841 37.766872) Mobile/Open311   37 3 5 5 5 8 7 28,862 4 3 3   37   5         9   1   5     37
1785174 1785174 3568708 2014-04-19T18:42:53 2014-10-28T03:52:11 2014-10-28T03:52:11 Closed 2 resolved: taking care of it. city is aware. sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   640 DAVIS ST, SAN FRANCISCO, CA, 94111 DAVIS ST 3 Northern Waterfront CENTRAL 37.798499341229 -122.39711036404199 POINT (-122.39711036 37.79849934) Mobile/Open311 http://mobile311.sfgov.org/reports/3568708/photos 77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
1785755 1785755 3506739 2014-03-31T12:02:19 2014-04-03T14:25:17 2014-04-03T14:25:17 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1715 34TH AVE, SAN FRANCISCO, CA, 94122 34TH AVE 4 Outer Sunset TARAVAL 37.75508445 -122.49287456 POINT (-122.49287456 37.75508445) Mobile/Open311   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1785848 1785848 3734931 2014-06-12T13:24:57 2014-07-11T10:31:20 2014-07-11T10:31:20 Closed 2 resolved: 1098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HAYES ST and VAN NESS AVE HAYES ST 5 Civic Center NORTHERN 37.777369776776 -122.419598428647 POINT (-122.41959843 37.77736978) Mobile/Open311 http://mobile311.sfgov.org/reports/3734931/photos 21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
1786768 1786768 3570568 2014-04-20T17:28:11 2014-06-06T10:13:04 2014-06-06T10:13:04 Closed 2 resolved: Site is private. sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 7TH ST and MINNA ST 7TH ST 6 South of Market SOUTHERN 37.778709917364004 -122.410518983493 POINT (-122.41051898 37.77870992) Mobile/Open311 http://mobile311.sfgov.org/reports/3570568/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1786787 1786787 3608656 2014-05-03T10:13:25 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1791978 1791978 3549527 2014-04-14T11:30:47 2014-04-19T06:16:03 2014-04-19T06:16:03 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 9TH ST and CLEMENTINA ST 9TH ST 6 South of Market SOUTHERN 37.77426 -122.41221399999999 POINT (-122.412214 37.77426) Mobile/Open311 http://mobile311.sfgov.org/reports/3549527/photos 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
1792256 1792256 3608663 2014-05-03T10:14:14 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1792872 1792872 3662370 2014-05-21T03:14:03 2014-05-29T01:50:33 2014-05-29T01:50:33 Closed 2 resolved: not enough information to do what? Where? DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   410 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 8 Mission Dolores MISSION 37.768421508407 -122.422328498329 POINT (-122.4223285 37.76842151) Mobile/Open311 http://mobile311.sfgov.org/reports/3662370/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1793895 1793895 3632973 2014-05-11T18:13:09 2014-05-12T03:15:00 2014-05-12T03:15:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1600 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 5 Civic Center SOUTHERN 37.774056831915004 -122.42093073762 POINT (-122.42093074 37.77405683) Mobile/Open311 http://mobile311.sfgov.org/reports/3632973/photos 21 1 11 9 11 7 2 28,852 2 10 10   21 1 11     1     1 1 1 1     21
1794132 1794132 3679508 2014-05-27T03:44:06 2014-05-28T06:00:12 2014-05-28T06:00:12 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CLARION ALY and VALENCIA ST CLARION ALY 9 Mission MISSION 37.762897834217 -122.421602290238 POINT (-122.42160229 37.76289783) Mobile/Open311 http://mobile311.sfgov.org/reports/3679508/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
1795401 1795401 3382287 2014-02-19T10:40:39 2014-03-07T00:41:42 2014-03-07T00:41:42 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   408 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 1 Lone Mountain PARK 37.774547999999996 -122.45456200000001 POINT (-122.454562 37.774548) Mobile/Open311 http://mobile311.sfgov.org/reports/3382287/photos 12 7 4 18 2 15 8 29,492 5 16 16   12   4             1         12
1796078 1796078 3493235 2014-03-26T17:00:46 2014-03-27T12:16:22 2014-03-27T12:16:22 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BACON ST and GOETTINGEN ST BACON ST 9 Portola BAYVIEW 37.727090999999994 -122.40635900000001 POINT (-122.406359 37.727091) Mobile/Open311 http://mobile311.sfgov.org/reports/3493235/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
1796920 1796920 3808068 2014-07-08T10:17:13 2014-07-08T13:13:14 2014-07-08T13:13:14 Closed 2 Transfer DPW/BSES SR#3808068 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   195 ORD ST, SAN FRANCISCO, CA, 94114 ORD ST 8 Eureka Valley MISSION 37.760930978728 -122.439952790851 POINT (-122.43995279 37.76093098) Mobile/Open311 http://mobile311.sfgov.org/reports/3808068/photos 115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1797614 1797614 3626820 2014-05-09T11:00:04 2014-05-09T12:00:00 2014-05-09T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 5/9/14 DM per Peachy's SR report to 311. BUF Action:Correspondence. date completed - 5/9/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of LAGUNA ST and MARINA BLVD LAGUNA ST 2 Marina NORTHERN 37.805069 -122.432144 POINT (-122.432144 37.805069) Mobile/Open311 http://mobile311.sfgov.org/reports/3626820/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1     14   17
1799277 1799277 3682901 2014-05-28T03:08:13 2014-05-28T04:28:39 2014-05-28T04:28:39 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CLARION ALY and MISSION ST CLARION ALY 9 Mission MISSION 37.763097239692996 -122.41963002842199 POINT (-122.41963003 37.76309724) Mobile/Open311 http://mobile311.sfgov.org/reports/3682901/photos 53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1799959 1799959 3480362 2014-03-22T17:52:25 2014-03-30T23:16:18 2014-03-30T23:16:18 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   601 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Lower Nob Hill CENTRAL 37.786856523053004 -122.41494303569401 POINT (-122.41494304 37.78685652) Mobile/Open311 http://mobile311.sfgov.org/reports/3480362/photos 50 6 10 36 9 13 1 28,858 1 36 36   50   10             2         50
1800568 1800568 3787632 2014-06-30T16:29:01 2014-06-30T16:33:09 2014-06-30T16:33:09 Closed 2 cancel per agent-Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HYDE ST and BROADWAY HYDE ST 3 Nob Hill CENTRAL 37.796274816719 -122.418457437787 POINT (-122.41845744 37.79627482) Phone   16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
1801202 1801202 3609300 2014-05-03T14:27:58 2014-05-05T08:48:58 2014-05-05T08:48:58 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776691 -122.463201 POINT (-122.463201 37.776691) Mobile/Open311 http://mobile311.sfgov.org/reports/3609300/photos 5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1803220 1803220 3715624 2014-06-06T14:41:59 2014-07-23T01:36:03 2014-07-23T01:36:03 Closed 2 resolved: Request Letter Sent. Sent empty basin letter. Sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3271 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 8 Mission Dolores MISSION 37.764688837377 -122.42556642752399 POINT (-122.42556643 37.76468884) Mobile/Open311 http://mobile311.sfgov.org/reports/3715624/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             2         37
1805618 1805618 3735197 2014-06-12T14:22:07 2014-07-01T03:37:09 2014-07-01T03:37:09 Closed 2 resolved: 1098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   661 18TH AVE, SAN FRANCISCO, CA, 94121 18TH AVE 1 Inner Richmond RICHMOND 37.775481476413 -122.476963503486 POINT (-122.4769635 37.77548148) Mobile/Open311 http://mobile311.sfgov.org/reports/3735197/photos 5 8 4 29 2 11 9 55 6 26 26   5   4             1         5
1806847 1806847 3754341 2014-06-19T07:17:10 2014-06-19T08:43:05 2014-06-19T08:43:05 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   395 RALSTON ST, SAN FRANCISCO, CA, 94132 RALSTON ST 11 Ingleside TARAVAL 37.719508000000005 -122.46897299999999 POINT (-122.468973 37.719508) Mobile/Open311 http://mobile311.sfgov.org/reports/3754341/photos 64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
1807120 1807120 3568350 2014-04-19T16:09:11 2014-04-20T13:19:24 2014-04-20T13:19:24 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BAKER ST and PAGE ST BAKER ST 5 Buena Vista PARK 37.771609574930004 -122.440486992063 POINT (-122.44048699 37.77160957) Mobile/Open311 http://mobile311.sfgov.org/reports/3568350/photos 112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
1807476 1807476 3421772 2014-03-04T09:36:08 2014-03-20T16:03:00 2014-03-20T16:03:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Tree uprooted. Obvious root pruning on North & West side of root system. BUF Action:INSPECT. date completed - 3/20/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   4400 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Eureka Valley MISSION 37.760834 -122.438347 POINT (-122.438347 37.760834) Mobile/Open311   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1807767 1807767 3570407 2014-04-20T16:28:58 2014-04-23T08:18:55 2014-04-23T08:18:55 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   786 MINNA ST, SAN FRANCISCO, CA, 94103 MINNA ST 6 South of Market SOUTHERN 37.776211942581 -122.41375649359301 POINT (-122.41375649 37.77621194) Mobile/Open311 http://mobile311.sfgov.org/reports/3570407/photos 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1     1 2 1 1     32
1807860 1807860 3679493 2014-05-27T03:09:01 2014-07-07T03:39:26 2014-07-07T03:39:26 Closed 2 resolved: 6/9/14: changed category to Landscaping. CB 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   680 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission Dolores MISSION 37.762039988337 -122.421905212218 POINT (-122.42190521 37.76203999) Mobile/Open311 http://mobile311.sfgov.org/reports/3679493/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             1         37
1808150 1808150 3648494 2014-05-16T11:24:42 2014-06-04T12:00:00 2014-06-04T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter. SR related. I will check if we rec'd their removal app for dead tree referenced 2 yrs ago. CB. BUF Action:Correspondence. date completed - 6/4/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BRADY ST and MARKET ST BRADY ST 6 South of Market SOUTHERN 37.773467 -122.42097199999999 POINT (-122.420972 37.773467) Mobile/Open311 http://mobile311.sfgov.org/reports/3648494/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
1809388 1809388 3666124 2014-05-22T05:57:17 2014-06-06T01:47:12 2014-06-06T01:47:12 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   308 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.749141873827 -122.399752596507 POINT (-122.3997526 37.74914187) Mobile/Open311 http://mobile311.sfgov.org/reports/3666124/photos 85 2 9 1 8 10 3 58 3 1 1   85   9             1         85
1810975 1810975 3626699 2014-05-09T10:21:04 2014-05-09T12:05:35 2014-05-09T12:05:35 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of LAGUNA ST and MARINA BLVD LAGUNA ST 2 Marina NORTHERN 37.805069 -122.432144 POINT (-122.432144 37.805069) Mobile/Open311 http://mobile311.sfgov.org/reports/3626699/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1     14   17
1812311 1812311 3654434 2014-05-18T16:43:41 2014-07-10T12:00:00 2014-07-10T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Plant pyrus calleryana new bradford. Re-submitted segment 6/26/14 DM. BUF Action:PLANT. date completed - 7/10/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1382 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.75123131465 -122.41623200487601 POINT (-122.416232 37.75123131) Mobile/Open311 http://mobile311.sfgov.org/reports/3654434/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1814776 1814776 3662371 2014-05-21T03:15:09 2014-05-21T11:24:05 2014-05-21T11:24:05 Closed 2 resolved: Don’t know what it's about will talk with Traci. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   5 BROSNAN ST, SAN FRANCISCO, CA, 94103 BROSNAN ST 8 Mission Dolores MISSION 37.768509769847 -122.422394463907 POINT (-122.42239446 37.76850977) Mobile/Open311 http://mobile311.sfgov.org/reports/3662371/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
1814996 1814996 3640206 2014-05-13T20:37:26 2014-06-27T12:00:00 2014-06-27T12:00:00 Closed 2 resolved: This is DPW tree. no missing, but 2 sq's meeting criteria for repairs, raised. - X1104 # 1005726, DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4   398 HAIGHT ST, SAN FRANCISCO, CA, 94102 HAIGHT ST 5 Lower Haight NORTHERN 37.772488198278 -122.428257018442 POINT (-122.42825702 37.7724882) Mobile/Open311 http://mobile311.sfgov.org/reports/3640206/photos 26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
1815157 1815157 3735598 2014-06-12T16:05:08 2014-07-07T03:32:54 2014-07-07T03:32:54 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   207 DOLORES ST, SAN FRANCISCO, CA, 94103 DOLORES ST 8 Mission Dolores MISSION 37.766044735944 -122.42636899475201 POINT (-122.42636899 37.76604474) Mobile/Open311 http://mobile311.sfgov.org/reports/3735598/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5             2   5     37
1816281 1816281 3597583 2014-04-29T16:25:44   2014-04-29T20:50:14 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   2929 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Eureka Valley MISSION 37.760954999999996 -122.44039699999999 POINT (-122.440397 37.760955) Mobile/Open311   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1817436 1817436 3679506 2014-05-27T03:36:46 2014-05-29T06:02:35 2014-05-29T06:02:35 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   548 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission Dolores MISSION 37.76407310277 -122.421902697647 POINT (-122.4219027 37.7640731) Mobile/Open311 http://mobile311.sfgov.org/reports/3679506/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5     3       2   3     37
1818108 1818108 3385778 2014-02-20T11:02:03 2014-03-07T13:30:14 2014-03-07T13:30:14 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter. Tree was relinquished in 2012 (March 7, 2014 letter mailed). BUF Action:Correspondence. date completed - 3/7/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   5050 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 11 Cayuga INGLESIDE 37.71766819067 -122.44048539518101 POINT (-122.4404854 37.71766819) Mobile/Open311 http://mobile311.sfgov.org/reports/3385778/photos 80 9 1 28 6 9 4 28,861 7 25 25   80   1   3         2         80
1818112 1818112 3609341 2014-05-03T14:40:27 2014-05-05T08:48:58 2014-05-05T08:48:58 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776728000000006 -122.463305 POINT (-122.463305 37.776728) Mobile/Open311 http://mobile311.sfgov.org/reports/3609341/photos 5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1818760 1818760 3608660 2014-05-03T10:14:04 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1819484 1819484 3570629 2014-04-20T17:52:53 2014-07-22T12:00:00 2014-07-22T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 7/22/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   117 6TH ST, SAN FRANCISCO, CA, 94103 6TH ST 6 South of Market SOUTHERN 37.780722286587 -122.40801145334 POINT (-122.40801145 37.78072229) Mobile/Open311 http://mobile311.sfgov.org/reports/3570629/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6     6 7 1 2 1       32
1820357 1820357 3605566 2014-05-02T09:15:05 2014-08-08T03:10:33 2014-08-08T03:10:33 Closed 2 resolved: Request Letter Sent. Sent letter. Sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   560 NATOMA ST, SAN FRANCISCO, CA, 94103 NATOMA ST 6 South of Market SOUTHERN 37.779129 -122.409126 POINT (-122.409126 37.779129) Mobile/Open311   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1821063 1821063 3709967 2014-06-05T02:47:02 2014-06-11T01:45:02 2014-06-11T01:45:02 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2806 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.752371463028 -122.414261838535 POINT (-122.41426184 37.75237146) Mobile/Open311 http://mobile311.sfgov.org/reports/3709967/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       2   3     53
1823502 1823502 3682905 2014-05-28T03:12:10 2014-06-05T06:41:43 2014-06-05T06:41:43 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CLARION ALY and MISSION ST CLARION ALY 9 Mission MISSION 37.763160187786 -122.419498348723 POINT (-122.41949835 37.76316019) Mobile/Open311 http://mobile311.sfgov.org/reports/3682905/photos 53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1825639 1825639 3435698 2014-03-08T11:11:30 2014-03-11T23:17:07 2014-03-11T23:17:07 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2230 BRYANT ST, SAN FRANCISCO, CA, 94110 BRYANT ST 9 Mission MISSION 37.758669583161996 -122.409761091808 POINT (-122.40976109 37.75866958) Mobile/Open311 http://mobile311.sfgov.org/reports/3435698/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1825770 1825770 3626703 2014-05-09T10:21:54 2014-05-10T12:06:03 2014-05-10T12:06:03 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of LAGUNA ST and MARINA BLVD LAGUNA ST 2 Marina NORTHERN 37.805069 -122.432144 POINT (-122.432144 37.805069) Mobile/Open311 http://mobile311.sfgov.org/reports/3626703/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1     14   17
1832914 1832914 3662363 2014-05-21T03:00:04 2015-09-18T06:45:28 2015-09-18T06:45:28 Closed 2 resolved: Request closed by SES . Notes = " Notes:Closed By CMMS SO 482928. BUF Action:Backfill/Adjust. date completed - 9/18/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   29 MAXWELL CT, SAN FRANCISCO, CA, 94103 MAXWELL CT 8 Mission Dolores MISSION 37.767024495628 -122.42230611876002 POINT (-122.42230612 37.7670245) Mobile/Open311 http://mobile311.sfgov.org/reports/3662363/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
1833642 1833642 3733233 2014-06-12T04:51:35 2014-07-16T12:00:00 2014-07-16T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:PLANT. date completed - 7/16/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1834 POST ST, SAN FRANCISCO, CA, 94115 POST ST 5 Japantown NORTHERN 37.785386366667 -122.431819243389 POINT (-122.43181924 37.78538637) Mobile/Open311 http://mobile311.sfgov.org/reports/3733233/photos 101 4 11 15 11 13 6 29,490 9 13 13 8 101   11 9     9     2         101
1834052 1834052 3704981 2014-06-03T16:38:08 2014-06-08T12:00:00 2014-06-08T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Sent another letter. Letter also sent on 3/27/14 by SK. Called into 311 by Gideon Kramer. Owner had planted a magnolia that didn't make it. Pull basin back in line with bus shelter or relocate to non bus zone frontage along same block. CB. BUF Action:Correspondence. date completed - 6/8/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3310 16TH ST, SAN FRANCISCO, CA, 94114 16TH ST 8 Mission Dolores MISSION 37.764583560672996 -122.426815079639 POINT (-122.42681508 37.76458356) Mobile/Open311 http://mobile311.sfgov.org/reports/3704981/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
1834610 1834610 3662360 2014-05-21T02:48:58   2014-05-21T06:46:04 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of SPARROW ST and VALENCIA ST SPARROW ST 8 Mission MISSION 37.765927137842 -122.42198752250799 POINT (-122.42198752 37.76592714) Mobile/Open311 http://mobile311.sfgov.org/reports/3662360/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1834823 1834823 3508764 2014-03-31T20:41:09 2014-04-07T10:22:36 2014-04-07T10:22:36 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of MCKINNON AVE and MENDELL ST MCKINNON AVE 10 Bayview BAYVIEW 37.735915000000006 -122.389104 POINT (-122.389104 37.735915) Mobile/Open311   86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
1834996 1834996 3748420 2014-06-17T11:06:20 2014-06-17T12:03:56 2014-06-17T12:03:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of FOLSOM ST and SPEAR ST FOLSOM ST 6 Rincon Hill SOUTHERN 37.790153000000004 -122.390826 POINT (-122.390826 37.790153) Mobile/Open311 http://mobile311.sfgov.org/reports/3748420/photos 30 1 10 8 9 6 2 28,855 2 6 6   30   10         3   1         30
1835205 1835205 3666883 2014-05-22T10:10:19 2014-05-23T02:26:01 2014-05-23T02:26:01 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   665 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.78304281648 -122.41842613566901 POINT (-122.41842614 37.78304282) Mobile/Open311 http://mobile311.sfgov.org/reports/3666883/photos 20 5 10 36 9 7 6 28,852 9 36 36   20 1 10   15     6 1 2 1       20
1835323 1835323 3679492 2014-05-27T03:07:00 2014-05-29T06:01:38 2014-05-29T06:01:38 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3520 18TH ST, SAN FRANCISCO, CA, 94110 18TH ST 8 Mission Dolores MISSION 37.761872517912 -122.422042340154 POINT (-122.42204234 37.76187252) Mobile/Open311 http://mobile311.sfgov.org/reports/3679492/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             1         37
1839385 1839385 3652461 2014-05-17T16:25:00 2014-07-11T02:08:56 2014-07-11T02:08:56 Closed 2 resolved: Per Supervisor Abe this is a private tree. Sending email to carla short. 7/11/14 not seeing the tree in question. Lots of large pines on hillside. Odd side of street is hill between Portola and Twin Peaks. Pines are on even side. One fell recently no debris onsidwalk or street DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1240 TWIN PEAKS BLVD, SAN FRANCISCO, CA, 94131 TWIN PEAKS BLVD 7 Midtown Terrace PARK 37.746187881602005 -122.450642902518 POINT (-122.4506429 37.74618788) Mobile/Open311 http://mobile311.sfgov.org/reports/3652461/photos 48 7 5 38 5 1 8 63 5 38 38   48   5             1         48
1840734 1840734 3735582 2014-06-12T16:02:26 2014-07-07T03:33:31 2014-07-07T03:33:31 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of ALERT ALY and DOLORES ST ALERT ALY 8 Mission Dolores MISSION 37.765650576946996 -122.426624139885 POINT (-122.42662414 37.76565058) Mobile/Open311 http://mobile311.sfgov.org/reports/3735582/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
1841303 1841303 3477411 2014-03-21T15:16:00 2015-01-27T03:14:40 2015-01-27T03:14:40 Closed 2 resolved: directions are incorrect, no empty basins at listed address DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of MCALLISTER ST and VAN NESS AVE MCALLISTER ST 5 Civic Center NORTHERN 37.779975 -122.419953 POINT (-122.419953 37.779975) Mobile/Open311   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
1843778 1843778 3666095 2014-05-22T05:29:14 2014-07-07T04:37:50 2014-07-07T04:37:50 Closed 2 resolved: Per Updated Bing Maps. Missing tree not found. Location notes states tree location as 2100 Cesar Chavez, which is miles away from this location. Inspector will check Randolph St/Victoria St location DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2315 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94124 CESAR CHAVEZ ST 10 Produce Market BAYVIEW 37.749011032318 -122.399487644548 POINT (-122.39948764 37.74901103) Mobile/Open311 http://mobile311.sfgov.org/reports/3666095/photos 85 2 9 1 8 10 3 58 3 1 1   85   9             1         85
1844049 1844049 3592803 2014-04-28T12:24:42 2015-10-30T02:25:00 2015-10-30T02:25:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Tristaniopsis laurina :: Swamp Myrtle was planted and tree is removed per Google Maps December/2013 Segment submitted 5/12/14 DM See photo in photo drive :: Closed By CMMS SO 488290. BUF Action:Plant. date completed - 10/30/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of MCCOPPIN ST and VALENCIA ST MCCOPPIN ST 6 South of Market SOUTHERN 37.771776029875 -122.422353895495 POINT (-122.4223539 37.77177603) Mobile/Open311 http://mobile311.sfgov.org/reports/3592803/photos 32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
1844685 1844685 3728962 2014-06-10T17:44:05 2014-07-07T03:33:56 2014-07-07T03:33:56 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   340 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Mission Dolores MISSION 37.765615792049 -122.42901809525 POINT (-122.4290181 37.76561579) Mobile/Open311 http://mobile311.sfgov.org/reports/3728962/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
1845546 1845546 3635997 2014-05-12T16:11:28 2014-05-20T08:58:21 2014-05-20T08:58:21 Closed 2 resolved: 1098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   55 9TH ST, SAN FRANCISCO, CA, 94103 9TH ST 6 South of Market TENDERLOIN 37.776956892412 -122.415316884216 POINT (-122.41531688 37.77695689) Mobile/Open311 http://mobile311.sfgov.org/reports/3635997/photos 32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   7 1 2 1 1     32
1846292 1846292 3662397 2014-05-21T04:18:11 2014-05-22T03:45:34 2014-05-22T03:45:34 Closed 2 resolved: tree is very stable - not uprooting DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2520 BAY SHORE BLVD, SAN FRANCISCO, CA, 94134 BAY SHORE BLVD 10 Visitacion Valley INGLESIDE 37.710056179238 -122.40480428573 POINT (-122.40480429 37.71005618) Mobile/Open311 http://mobile311.sfgov.org/reports/3662397/photos 75 9 9 40 8 9 4 309 7 39 39   75   9   1         2         75
1846296 1846296 3715829 2014-06-06T15:26:40 2014-06-26T03:15:04 2014-06-26T03:15:04 Closed 2 resolved: Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   903 SHOTWELL ST, SAN FRANCISCO, CA, 94110 SHOTWELL ST 9 Mission MISSION 37.754029445385 -122.41505099471901 POINT (-122.41505099 37.75402945) Mobile/Open311 http://mobile311.sfgov.org/reports/3715829/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1847801 1847801 3608665 2014-05-03T10:14:46 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1849727 1849727 3626701 2014-05-09T10:21:12 2014-05-09T10:35:27 2014-05-09T10:35:27 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of LAGUNA ST and MARINA BLVD LAGUNA ST 2 Marina NORTHERN 37.805069 -122.432144 POINT (-122.432144 37.805069) Mobile/Open311 http://mobile311.sfgov.org/reports/3626701/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1     14   17
1849989 1849989 3705006 2014-06-03T16:46:53 2014-08-18T12:00:00 2014-08-18T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:New trees were planted at 347 dolores . BUF Action:INSPECT. date completed - 8/18/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CHULA LN and DOLORES ST CHULA LN 8 Mission Dolores MISSION 37.763996408356 -122.426180821026 POINT (-122.42618082 37.76399641) Mobile/Open311 http://mobile311.sfgov.org/reports/3705006/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             2   5     37
1850689 1850689 3705913 2014-06-04T03:32:09 2014-08-22T11:04:36 2014-08-22T11:04:36 Closed 2 resolved: Request Letter Sent. sent empty tree basin letter. sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2879 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.750912802329005 -122.41815372381599 POINT (-122.41815372 37.7509128) Mobile/Open311 http://mobile311.sfgov.org/reports/3705913/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1850839 1850839 3466931 2014-03-18T15:33:04 2014-04-01T16:19:08 2014-04-01T16:19:08 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1737 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Inner Richmond RICHMOND 37.77655744463 -122.477849722029 POINT (-122.47784972 37.77655744) Mobile/Open311 http://mobile311.sfgov.org/reports/3466931/photos 5 8 4 29 2 11 9 55 6 26 26   5   4             1         5
1851217 1851217 3662368 2014-05-21T03:10:33   2014-05-21T06:59:12 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 14TH ST and VALENCIA ST 14TH ST 8 Mission Dolores MISSION 37.768293641497 -122.42229312681002 POINT (-122.42229313 37.76829364) Mobile/Open311 http://mobile311.sfgov.org/reports/3662368/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1851358 1851358 3608659 2014-05-03T10:13:40 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1852332 1852332 3718849 2014-06-07T17:07:05 2014-08-04T12:00:00 2014-08-04T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Contacted by Mary Beth Frederick (PO: 415-626-1405) requesting status of stump removal and sidewall repair. Request submitted to Carla.. BUF Action:REMOVE STUMP. date completed - 8/4/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   430 OAK ST, SAN FRANCISCO, CA, 94102 OAK ST 5 Hayes Valley NORTHERN 37.774590002408 -122.42635214711399 POINT (-122.42635215 37.77459) Mobile/Open311 http://mobile311.sfgov.org/reports/3718849/photos 22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
1852782 1852782 3577306 2014-04-22T17:31:16 2012-06-13T12:00:00 2012-06-13T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:In-lieu fee paid, no replacement required. Cbuck. 4/28/14 Sent to BSM to request owner to pave empty basin. No re-plant required. DM. BUF Action:Permit Remove Tree. date completed - 6/13/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   542 NATOMA ST, SAN FRANCISCO, CA, 94103 NATOMA ST 6 South of Market SOUTHERN 37.779455697199005 -122.408680748309 POINT (-122.40868075 37.7794557) Mobile/Open311 http://mobile311.sfgov.org/reports/3577306/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1854429 1854429 3679501 2014-05-27T03:24:35 2014-05-29T06:02:35 2014-05-29T06:02:35 Closed 2 resolved: 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   520 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission Dolores MISSION 37.764496724156 -122.42194502625799 POINT (-122.42194503 37.76449672) Mobile/Open311 http://mobile311.sfgov.org/reports/3679501/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5     3       2   3     37
1855595 1855595 3613269 2014-05-05T10:56:29 2015-10-29T07:54:10 2015-10-29T07:54:10 Closed 2 resolved: Request closed by SES . Notes = " Notes:Closed By CMMS SO 485678. BUF Action:Prune. date completed - 10/29/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2121 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.763345243044 -122.415053424855 POINT (-122.41505342 37.76334524) Phone   53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1859265 1859265 3608680 2014-05-03T10:16:59 2014-06-09T11:40:19 2014-06-09T11:40:19 Closed 2 resolved: private property tree in backyard not protected by city ordinance DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   629 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 1 Inner Richmond RICHMOND 37.776701 -122.463319 POINT (-122.463319 37.776701) Mobile/Open311   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
1860360 1860360 3686551 2014-05-29T04:53:22 2014-09-19T11:34:35 2014-09-19T11:34:35 Closed 2 resolved: the city will pave the old basin and cut a new one DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   675 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.771683354477 -122.43317107685301 POINT (-122.43317108 37.77168335) Mobile/Open311 http://mobile311.sfgov.org/reports/3686551/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
1860973 1860973 3734793 2014-06-12T12:49:56 2014-07-09T01:35:34 2014-07-09T01:35:34 Closed 2 resolved: Minor sidewalk lifting, can be repaired, basin can be expanded, comm and low voltage power lines, no pruning required. PG & E will prune when necessary for high voltage power lines. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3   1285 8TH AVE, SAN FRANCISCO, CA, 94122 8TH AVE 5 Inner Sunset TARAVAL 37.764390954890004 -122.46533633913602 POINT (-122.46533634 37.76439095) Phone   109 10 11 14 11 11 5 56 8 12 12 2 109   11 2     2     1         109
1862719 1862719 3682918 2014-05-28T03:44:25 2014-06-26T01:08:45 2014-06-26T01:08:45 Closed 2 resolved: No empty basins only pave overs due to utility, and other trees DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1900 MISSION ST, SAN FRANCISCO, CA, 94103 MISSION ST 9 Mission MISSION 37.766496771982005 -122.419987013678 POINT (-122.41998701 37.76649677) Mobile/Open311 http://mobile311.sfgov.org/reports/3682918/photos 53 3 2 20 7 8 7 28,853 4 19 19 12 53   2 14   3 14     2   3     53
1863245 1863245 3648831 2014-05-16T12:29:43 2014-05-18T06:12:24 2014-05-18T06:12:24 Closed 2 resolved: not falling down DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   Intersection of ESMERALDA AVE and COLERIDGE ST ESMERALDA AVE 9 Bernal Heights INGLESIDE 37.744058284717 -122.419492668356 POINT (-122.41949267 37.74405828) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
1863460 1863460 3506962 2014-03-31T12:41:43 2014-03-31T16:57:03 2014-03-31T16:57:03 Closed 2 Could not identify nature of the issue. The sidewalk is not broken nor is there garbage. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   479 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.784553151613004 -122.41421800118201 POINT (-122.414218 37.78455315) Mobile/Open311 http://mobile311.sfgov.org/reports/3506962/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
1864414 1864414 3640204 2014-05-13T20:36:32 2014-05-16T12:00:00 2014-05-16T12:00:00 Closed 2 resolved: private tree. Established tree. - Tree is not missing at this location. No addtional action required at this time. DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4   325 HAIGHT ST, SAN FRANCISCO, CA, 94102 HAIGHT ST 5 Mint Hill NORTHERN 37.772549092805 -122.42769358691099 POINT (-122.42769359 37.77254909) Mobile/Open311 http://mobile311.sfgov.org/reports/3640204/photos 26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
1865415 1865415 3605556 2014-05-02T09:13:24 2014-08-08T03:03:54 2014-08-08T03:03:54 Closed 2 resolved: Request Letter Sent. Sent letter. Sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   556 NATOMA ST, SAN FRANCISCO, CA, 94103 NATOMA ST 6 South of Market SOUTHERN 37.779175 -122.40908799999998 POINT (-122.409088 37.779175) Mobile/Open311   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1865744 1865744 3433703 2014-03-07T14:35:17 2016-04-11T05:10:34 2016-04-11T05:10:34 Closed 2 called Rec & Park----Rochelle DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   105 CRESTLAKE DR, SAN FRANCISCO, CA, 94132 CRESTLAKE DR 4 Parkside TARAVAL 37.735323384439 -122.482604188959 POINT (-122.48260419 37.73532338) Mobile/Open311   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40

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