calls

876 rows where Responsible_Agency = 5

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
1712 1712 11419283 2019-09-15T14:37:00 2019-10-07T17:44:00 2019-10-07T17:44:00 Closed 2 According to DPW, this is private property. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1433 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737487792969 -122.385726928711 POINT (-122.38572693 37.73748779) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
14459 14459 11363787 2019-09-03T16:00:00 2019-10-08T16:06:00 2019-10-08T16:06:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 530 FLOOD AVE, SAN FRANCISCO, CA, 94112 FLOOD AVE 7 Sunnyside INGLESIDE 37.729976654053004 -122.451866149902 POINT (-122.45186615 37.72997665) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
43788 43788 11465123 2019-09-25T14:03:00 2019-09-25T15:03:00 2019-09-25T15:03:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PAGE ST and MASONIC AVE PAGE ST 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
52530 52530 11464217 2019-09-25T11:29:00 2019-09-25T12:31:00 2019-09-25T12:31:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of MCALLISTER ST and LAGUNA ST MCALLISTER ST 5 Western Addition NORTHERN 37.779258728027 -122.426826477051 POINT (-122.42682648 37.77925873) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
64533 64533 11457167 2019-09-23T23:07:00 2019-09-30T08:58:00 2019-09-30T08:58:00 Closed 2 Cannot contact reporting party for more information. Need to confirm if they are out 24 7. BUF does not handle garbage toters. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIAMOND ST and KERN ST DIAMOND ST 8 Glen Park INGLESIDE 37.733892438678005 -122.43406148473 POINT (-122.43406148 37.73389244) Mobile/Open311 http://mobile311.sfgov.org/reports/11457167/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
102259 102259 11614583 2019-10-28T17:50:00 2019-10-28T18:44:00 2019-10-28T18:44:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 225 CLIPPER ST, SAN FRANCISCO, CA, 94114 CLIPPER ST 8 Noe Valley MISSION 37.7489083 -122.43073229999999 POINT (-122.4307323 37.7489083) Web   84 3 5 22 5 2 7 28,862 4 22 22   84   5             1         84
119310 119310 6705994 2017-01-08T15:53:51 2017-01-08T21:42:47 2017-01-08T21:42:47 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SUNSET BLVD and SANTIAGO ST SUNSET BLVD 4 Parkside TARAVAL 37.744091409322 -122.494573488881 POINT (-122.49457349 37.74409141) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
120206 120206 6575592 2016-11-29T10:02:10 2016-11-29T15:31:51 2016-11-29T15:31:51 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other 1010 FRANCISCO ST, SAN FRANCISCO, CA, 94109 FRANCISCO ST 2 Russian Hill NORTHERN 37.803697620566 -122.42195893130899 POINT (-122.42195893 37.80369762) Phone   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
120612 120612 6535752 2016-11-15T17:44:30 2016-11-15T18:14:50 2016-11-15T18:14:50 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 10TH ST and FELL ST 10TH ST 6 Civic Center TENDERLOIN 37.776109000000005 -122.41755900000001 POINT (-122.417559 37.776109) Mobile/Open311 http://mobile311.sfgov.org/reports/6535752/photos 32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   8 1 2 1 1     32
124734 124734 6131719 2016-07-28T14:34:56 2016-08-02T14:40:58 2016-08-02T14:40:58 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of CROOK ST and LUNDEEN ST CROOK ST 2 Presidio National Park   37.80403515964 -122.450170582274 POINT (-122.45017058 37.80403516) Mobile/Open311   3   6 27 1 11   61   30 30   3   6             1         3
132374 132374 9254879 2018-07-11T19:07:00 2018-07-11T20:35:00 2018-07-11T20:35:00 Closed 2 ggnra property ggnra police already on scene 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3721 CLEMENT ST, SAN FRANCISCO, CA, 94121 CLEMENT ST 1 Outer Richmond RICHMOND 37.781223297119006 -122.49920654296899 POINT (-122.49920654 37.7812233) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
141000 141000 4656802 2015-04-11T20:45:53 2015-04-12T03:44:26 2015-04-12T03:44:26 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CLEMENT ST and FUNSTON AVE CLEMENT ST 1 Inner Richmond RICHMOND 37.782596588135 -122.47191619873001 POINT (-122.4719162 37.78259659) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1     3   5
158357 158357 9076812 2018-05-31T15:30:00 2018-05-31T20:48:00 2018-05-31T20:48:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and SLOAT BLVD 19TH AVE 7 Parkside TARAVAL 37.73462677002 -122.47510528564501 POINT (-122.47510529 37.73462677) Phone   40 10 8 35 4 1 5 64 8 35 35   40   8             1         40
188919 188919 9397228 2018-08-13T14:00:00 2018-12-04T15:28:00 2018-12-04T15:28:00 Closed 2 No contact info: Need better location this is Cal Trans Property based on Highway 1? but address given is not near a highway ? 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 346 WEST PACIFIC AVE, SAN FRANCISCO, CA, 94129 WEST PACIFIC AVE 2 Presidio National Park   37.791108397284 -122.47014352852699 POINT (-122.47014353 37.7911084) Mobile/Open311   3   6 27 1 11   61   30 30   3   6             1         3
189170 189170 9200886 2018-06-28T20:21:00 2018-06-28T20:59:00 2018-06-28T20:59:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-06-28T20:39:30 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 19TH AVE and WINSTON DR 19TH AVE 7 Stonestown TARAVAL 37.726989746094 -122.474899291992 POINT (-122.47489929 37.72698975) Phone   41 10 8 16 4 9 5 64 8 14 14   41   8             2         41
199020 199020 9098691 2018-06-05T19:17:00 2018-06-05T20:19:00 2018-06-05T20:19:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-06-05T19:50:51 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FOLSOM ST and 25TH ST FOLSOM ST 9 Mission MISSION 37.750904083252 -122.413925170898 POINT (-122.41392517 37.75090408) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
205070 205070 9284533 2018-07-18T14:27:00 2018-07-18T18:08:00 2018-07-18T18:08:00 Closed 2 DPW Ops Queue to CSP Supervisor Queue at 2018-07-18T16:28:34 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 121 HOLLY PARK CIR, SAN FRANCISCO, CA, 94110 HOLLY PARK CIR 9 Holly Park INGLESIDE 37.737987518311 -122.418769836426 POINT (-122.41876984 37.73798752) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
209971 209971 9163798 2018-06-20T17:17:00 2018-06-20T21:49:00 2018-06-20T21:49:00 Closed 2 Per DPW, dup 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1161 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.730709075928004 -122.430076599121 POINT (-122.4300766 37.73070908) Phone   94 9 1 28 6 9 4 28,861 7 25 25 16 94   1             1         94
210753 210753 9251228 2018-07-11T07:36:00 2018-07-11T10:23:00 2018-07-11T10:23:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 72 BAY VIEW ST, SAN FRANCISCO, CA, 94124 BAY VIEW ST 10 Silver Terrace BAYVIEW 37.732791900635 -122.393836975098 POINT (-122.39383698 37.7327919) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
219053 219053 9218331 2018-07-03T08:02:00 2018-07-03T09:09:00 2018-07-03T09:09:00 Closed 2 DPW Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1600 10TH AVE, SAN FRANCISCO, CA, 94122 10TH AVE 7 Golden Gate Heights TARAVAL 37.758266448975 -122.466827392578 POINT (-122.46682739 37.75826645) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
221296 221296 9393371 2018-08-12T16:16:00 2018-08-12T16:47:00 2018-08-12T16:47:00 Closed 2 Per DPW SR is a duplicate. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 160 EUCALYPTUS DR, SAN FRANCISCO, CA, 94132 EUCALYPTUS DR 7 Merced Manor TARAVAL 37.731185913086 -122.47381591796899 POINT (-122.47381592 37.73118591) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
223478 223478 9239501 2018-07-08T14:57:00 2018-10-18T16:55:00 2018-10-18T16:55:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 507 CRESTMONT DR, SAN FRANCISCO, CA, 94131 CRESTMONT DR 7 Forest Knolls PARK 37.759044647217 -122.459663391113 POINT (-122.45966339 37.75904465) Phone   111 7 8 14 4 15 8 63 5 12 12   111   8             1         111
226039 226039 9403498 2018-08-14T17:06:00 2018-08-21T12:11:00 2018-08-21T12:11:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 2 TOWNSEND ST, SAN FRANCISCO, CA, 94107 TOWNSEND ST 6 South Beach SOUTHERN 37.781509399414 -122.389617919922 POINT (-122.38961792 37.7815094) Phone   31 1 10 8 9 6 2 28,856 2 6 6   31   10             1         31
227881 227881 9076892 2018-05-31T15:44:00 2018-05-31T19:13:00 2018-05-31T19:13:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and WAWONA ST 19TH AVE 4 Parkside TARAVAL 37.737453460693004 -122.475288391113 POINT (-122.47528839 37.73745346) Phone     10 8 41 4 1 5 29,491 8 40 40       8             1          
234526 234526 9332784 2018-07-29T20:48:00 2018-07-29T21:15:00 2018-07-29T21:15:00 Closed 2 per dpw 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other 4244 19TH ST, SAN FRANCISCO, CA, 94114 19TH ST 8 Castro MISSION 37.759269266424 -122.436486035699 POINT (-122.43648604 37.75926927) Mobile/Open311 http://mobile311.sfgov.org/reports/9332784/photos 38 3 5 5 5 2 7 28,862 4 3 3   38   5         9   1   5     38
241149 241149 9098644 2018-06-05T19:05:00 2018-06-05T20:19:00 2018-06-05T20:19:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-06-05T19:49:56 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of FOLSOM ST and 24TH ST FOLSOM ST 9 Mission MISSION 37.752506256104 -122.41408538818399 POINT (-122.41408539 37.75250626) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
245481 245481 9091429 2018-06-04T13:00:00 2018-06-04T18:25:00 2018-06-04T18:25:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-06-04T13:40:25 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1271 BOSWORTH ST, SAN FRANCISCO, CA, 94131 BOSWORTH ST 7 Miraloma Park INGLESIDE 37.735862731934 -122.441947937012 POINT (-122.44194794 37.73586273) Phone   72 9 8 41 4 9 4 63 7 40 40   72   8             1         72
246110 246110 3979777 2014-09-04T07:56:08 2017-07-06T14:26:57 2017-07-06T14:26:57 Closed 2 See Notes. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 29 DEDMAN CT, SAN FRANCISCO, CA, 94124 DEDMAN CT 10 Bayview BAYVIEW 37.736981487636 -122.385340055285 POINT (-122.38534006 37.73698149) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
247018 247018 9146293 2018-06-16T18:27:00 2018-06-16T19:43:00 2018-06-16T19:43:00 Closed 2 per dpw- rec and park 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MARTIN LUTHER KING JR DR and 25TH AVE MARTIN LUTHER KING JR DR 1 Golden Gate Park RICHMOND 37.76676940918 -122.482368469238 POINT (-122.48236847 37.76676941) Phone   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
247618 247618 9285345 2018-07-18T16:50:00 2018-07-18T19:17:00 2018-07-18T19:17:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-07-18T18:38:40 : Work Transferred from DPW SES to 311 Incomplete Info Return duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3125 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.747901916504 -122.41345977783199 POINT (-122.41345978 37.74790192) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
256245 256245 9131574 2018-06-13T11:40:00 2018-07-10T10:11:00 2018-07-10T10:11:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 28 NIAGARA AVE, SAN FRANCISCO, CA, 94112 NIAGARA AVE 11 Cayuga INGLESIDE 37.716053009033 -122.442123413086 POINT (-122.44212341 37.71605301) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
259078 259078 9407936 2018-08-15T15:18:00 2018-08-15T16:00:00 2018-08-15T16:00:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 15TH ST and HARRISON ST 15TH ST 9 Mission MISSION 37.766723632813 -122.413223266602 POINT (-122.41322327 37.76672363) Phone   53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
259695 259695 9103444 2018-06-06T18:04:00 2018-06-13T10:48:00 2018-06-13T10:48:00 Closed 2 The following information was provided by DPW BUF : Work has been assigned 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 2494 47TH AVE, SAN FRANCISCO, CA, 94116 47TH AVE 4 Outer Sunset TARAVAL 37.740016937255994 -122.505409240723 POINT (-122.50540924 37.74001694) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
264104 264104 9092646 2018-06-04T15:44:00 2018-06-04T20:03:00 2018-06-04T20:03:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-06-04T19:10:33 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GUERRERO ST and ALVARADO ST GUERRERO ST 8 Dolores Heights MISSION 37.754375457764 -122.423065185547 POINT (-122.42306519 37.75437546) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
265329 265329 9332502 2018-07-29T18:27:00 2018-08-01T15:07:00 2018-08-01T15:07:00 Closed 2 DPW BUF : Work has been assigned 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CESAR CHAVEZ ST and BRYANT ST CESAR CHAVEZ ST 9 Peralta Heights MISSION 37.748352050781 -122.408706665039 POINT (-122.40870667 37.74835205) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
270062 270062 9088607 2018-06-03T20:56:00 2018-06-03T21:29:00 2018-06-03T21:29:00 Closed 2 Per DPW, duplicate SR 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FULTON ST and FILLMORE ST FULTON ST 5 Hayes Valley NORTHERN 37.777698516846 -122.431571960449 POINT (-122.43157196 37.77769852) Phone   22 4 11 9 11 15 6 29,492 9 10 10   22   11             1         22
279579 279579 9154008 2018-06-18T18:52:00 2018-06-18T19:52:00 2018-06-18T19:52:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1011 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 5 Cathedral Hill NORTHERN 37.781204223633 -122.425605773926 POINT (-122.42560577 37.78120422) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
282139 282139 9345439 2018-08-01T11:22:00 2018-08-01T15:06:00 2018-08-01T15:06:00 Closed 2 DPW Ops Queue to CSP Supervisor Queue at 2018-08-01T12:29:00 : Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of HYDE ST and WASHINGTON ST HYDE ST 3 Nob Hill CENTRAL 37.793682098389 -122.417938232422 POINT (-122.41793823 37.7936821) Twitter https://twitter.com/VickiJohnsonPhD/status/1024718001591832576/photo/1 16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
287748 287748 9066046 2018-05-29T16:52:00 2018-05-29T18:08:00 2018-05-29T18:08:00 Closed 2 DPW reports DUPLICATE 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 59 WOODLAND AVE, SAN FRANCISCO, CA, 94117 WOODLAND AVE 5 Parnassus Heights PARK 37.763107299805 -122.453384399414 POINT (-122.4533844 37.7631073) Phone   110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
287908 287908 9403837 2018-08-14T18:28:00 2018-08-15T05:00:00 2018-08-15T05:00:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3014 22ND ST, SAN FRANCISCO, CA, 94110 22ND ST 9 Mission MISSION 37.755722045898 -122.41471862793001 POINT (-122.41471863 37.75572205) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
289147 289147 9071614 2018-05-30T16:20:00 2018-05-30T17:06:00 2018-05-30T17:06:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-05-30T16:50:03 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2007 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 10 Potrero Hill MISSION 37.765682220459 -122.406860351563 POINT (-122.40686035 37.76568222) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
291378 291378 9191845 2018-06-27T08:30:00 2018-07-09T13:22:00 2018-07-09T13:22:00 Closed 2 DPW BUF : Your request has been received and will be transferred to the inspectors. Thank you. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of OCTAVIA ST and JACKSON ST OCTAVIA ST 2 Pacific Heights NORTHERN 37.793308258056996 -122.42798614501999 POINT (-122.42798615 37.79330826) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
305094 305094 9412305 2018-08-16T14:44:00 2018-08-16T17:25:00 2018-08-16T17:25:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 555 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.779537200928004 -122.422554016113 POINT (-122.42255402 37.7795372) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
317538 317538 9549152 2018-09-16T18:41:00 2018-09-16T20:13:00 2018-09-16T20:13:00 Closed 2 per dpw it is a duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1225 INGALLS ST, SAN FRANCISCO, CA, 94124 INGALLS ST 10 Hunters Point BAYVIEW 37.730491638184 -122.381660461426 POINT (-122.38166046 37.73049164) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
325464 325464 9439185 2018-08-22T16:51:00 2018-08-22T18:05:00 2018-08-22T18:05:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-08-22T17:31:37 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BOSWORTH ST and LIPPARD AVE BOSWORTH ST 8 Glen Park INGLESIDE 37.733875274658 -122.435836791992 POINT (-122.43583679 37.73387527) Phone   96 9 5 41 5 9 4 63 7 40 40 15 96   5 17     17     1     80   96
341136 341136 9622059 2018-10-03T13:03:00 2018-10-04T17:46:00 2018-10-04T17:46:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OXFORD ST and WAYLAND ST OXFORD ST 9 McLaren Park INGLESIDE 37.721512271125995 -122.420020792747 POINT (-122.42002079 37.72151227) Mobile/Open311 http://mobile311.sfgov.org/reports/9622059/photos 73 9 2 19 7 9 4 309 7 18 18   73   2             2         73
341797 341797 9534600 2018-09-13T08:28:00 2018-09-13T17:36:00 2018-09-13T17:36:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 266 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Mission MISSION 37.750852662174 -122.421646127591 POINT (-122.42164613 37.75085266) Mobile/Open311 http://mobile311.sfgov.org/reports/9534600/photos 53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
348716 348716 9734190 2018-10-29T07:57:00 2018-10-31T11:33:00 2018-10-31T11:33:00 Closed 2 The following information was provided by DPW BUF : Your service has been accepted - Inspected - closed out as - Private Property. Thank you 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 763 FOERSTER ST, SAN FRANCISCO, CA, 94127 FOERSTER ST 7 Miraloma Park INGLESIDE 37.735050201416 -122.449028015137 POINT (-122.44902802 37.7350502) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
353817 353817 9439171 2018-08-22T16:49:00 2018-08-22T18:04:00 2018-08-22T18:04:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-08-22T17:31:11 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BOSWORTH ST and DIAMOND ST BOSWORTH ST 8 Glen Park INGLESIDE 37.733551025391 -122.43414306640601 POINT (-122.43414307 37.73355103) Phone   96 9 5 10 5 9 4 63 7 7 7 15 96   5 17     17     1     80   96
360915 360915 9538180 2018-09-13T17:38:00 2018-09-13T21:15:00 2018-09-13T21:15:00 Closed 2 to caltrans 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BAY SHORE BLVD and PAUL AVE BAY SHORE BLVD 10 Portola BAYVIEW 37.723617553711 -122.40078735351601 POINT (-122.40078735 37.72361755) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
365237 365237 9755658 2018-11-02T09:36:00 2018-11-02T10:52:00 2018-11-02T10:52:00 Closed 2 This has been reported already see 9755501 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 1530 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772606 -122.44462 POINT (-122.44462 37.772606) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8   24   11             1         24
371203 371203 9488073 2018-09-03T08:13:00 2018-09-14T11:47:00 2018-09-14T11:47:00 Closed 2 THIS IS PRIVATE PROPERTY Per Last Service Request: everything in back is private property. work with your neighbors. there are no street trees ifo this address. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 833 COLBY ST, SAN FRANCISCO, CA, 94134 COLBY ST 9 Portola BAYVIEW 37.720204200000005 -122.4099154 POINT (-122.4099154 37.7202042) Web   91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
379425 379425 9602587 2018-09-28T18:25:00 2018-09-28T21:56:00 2018-09-28T21:56:00 Closed 2 Per DPW, this is not city property. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of ATHENS ST and PERU AVE ATHENS ST 11 Excelsior INGLESIDE 37.726265000000005 -122.42483500000002 POINT (-122.424835 37.726265) Mobile/Open311 http://mobile311.sfgov.org/reports/9602587/photos 90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
381655 381655 9505956 2018-09-06T17:55:00 2018-09-06T18:11:00 2018-09-06T18:11:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BROADWAY and MASON ST BROADWAY 3 Russian Hill CENTRAL 37.797130584717 -122.41188812255899 POINT (-122.41188812 37.79713058) Phone   107 6 3 21 10 3 1 308 1 21 21   107   3             1         107
392086 392086 9584513 2018-09-24T20:33:00 2018-10-09T09:04:00 2018-10-09T09:04:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1110 OCEAN AVE, SAN FRANCISCO, CA, 94112 OCEAN AVE 7 Westwood Park TARAVAL 37.723583221436 -122.454315185547 POINT (-122.45431519 37.72358322) Phone   71 10 8 41 4 9 5 28,861 8 40 40   71   8 19     19 13   1         71
411594 411594 9582278 2018-09-24T12:44:00 2018-09-26T01:57:00 2018-09-26T01:57:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 165 PARK ST, SAN FRANCISCO, CA, 94110 PARK ST 9 Holly Park INGLESIDE 37.7367335 -122.42188390000001 POINT (-122.4218839 37.7367335) Web   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
422654 422654 9424234 2018-08-19T19:24:00 2018-08-19T20:48:00 2018-08-19T20:48:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-08-19T20:25:09 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 170 BOCANA ST, SAN FRANCISCO, CA, 94110 BOCANA ST 9 Bernal Heights INGLESIDE 37.741257 -122.41734299999999 POINT (-122.417343 37.741257) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
422942 422942 9651049 2018-10-10T07:28:00 2018-11-15T10:48:00 2018-11-15T10:48:00 Closed 2 Please contact San Francisco Beekeepers Association at 415-997-9276 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 310 29TH AVE, SAN FRANCISCO, CA, 94121 29TH AVE 1 Outer Richmond RICHMOND 37.783424377441 -122.489112854004 POINT (-122.48911285 37.78342438) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
424111 424111 9622053 2018-10-03T13:02:00 2018-10-04T18:18:00 2018-10-04T18:18:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OXFORD ST and WAYLAND ST OXFORD ST 9 McLaren Park INGLESIDE 37.721497016063 -122.419935297335 POINT (-122.4199353 37.72149702) Mobile/Open311 http://mobile311.sfgov.org/reports/9622053/photos 73 9 2 19 7 9 4 309 7 18 18   73   2             2         73
439221 439221 10370065 2019-01-17T12:43:00 2019-01-17T15:26:00 2019-01-17T15:26:00 Closed 2 Per dpw duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of EUGENIA AVE and WINFIELD ST EUGENIA AVE 9 Bernal Heights INGLESIDE 37.741233825684 -122.419464111328 POINT (-122.41946411 37.74123383) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
439350 439350 10372669 2019-01-18T00:19:00 2019-01-18T01:54:00 2019-01-18T01:54:00 Closed 2 Per SFPD- Fire Dept has dispatched and fire is extinguished. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 1909 DONNER AVE, SAN FRANCISCO, CA, 94124 DONNER AVE 10 Silver Terrace BAYVIEW 37.728553195519 -122.401780430342 POINT (-122.40178043 37.7285532) Mobile/Open311 http://mobile311.sfgov.org/reports/10372669/photos 87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
447715 447715 9780400 2018-11-07T16:45:00 2018-11-07T19:42:00 2018-11-07T19:42:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of FELL ST and LYON ST FELL ST 5 Panhandle PARK 37.773426055908 -122.44256591796899 POINT (-122.44256592 37.77342606) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
452939 452939 10387039 2019-01-21T21:46:00 2019-01-22T06:11:00 2019-01-22T06:11:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of VALLEJO ST and HYDE ST VALLEJO ST 3 Russian Hill CENTRAL 37.797333833782 -122.41867173310301 POINT (-122.41867173 37.79733383) Mobile/Open311   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
454967 454967 10388801 2019-01-22T10:05:00 2019-03-26T15:22:00 2019-03-26T15:22:00 Closed 2 private tree 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SEWARD ST and DOUGLASS ST SEWARD ST 8 Eureka Valley MISSION 37.75785446167 -122.439071655273 POINT (-122.43907166 37.75785446) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
469912 469912 9980673 2018-12-27T09:31:00 2018-12-27T10:42:00 2018-12-27T10:42:00 Closed 2 DPW Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 325 HAYES ST, SAN FRANCISCO, CA, 94102 HAYES ST 5 Civic Center NORTHERN 37.776921 -122.42171299999998 POINT (-122.421713 37.776921) Mobile/Open311 http://mobile311.sfgov.org/reports/9980673/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
471673 471673 9840008 2018-11-22T13:56:00 2018-12-05T17:27:00 2018-12-05T17:27:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 763 FOERSTER ST, SAN FRANCISCO, CA, 94127 FOERSTER ST 7 Miraloma Park INGLESIDE 37.735050201416 -122.449028015137 POINT (-122.44902802 37.7350502) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
490355 490355 9817490 2018-11-16T13:26:00 2018-11-16T15:24:00 2018-11-16T15:24:00 Closed 2 This is investigated and enforced by the Bay Area Air Quality Management District (BAAQMD). Should be referred to BAAQMD. Please call 415-749-4900 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 23RD AVE and SLOAT BLVD 23RD AVE 7 Merced Manor TARAVAL 37.734531402588 -122.479461669922 POINT (-122.47946167 37.7345314) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
498054 498054 9885248 2018-12-03T14:22:00 2019-04-20T15:47:00 2019-04-20T15:47:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 171 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.776132169166004 -122.420798638887 POINT (-122.42079864 37.77613217) Mobile/Open311 http://mobile311.sfgov.org/reports/9885248/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
500561 500561 9830880 2018-11-20T09:42:00 2018-11-20T12:37:00 2018-11-20T12:37:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other 570 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.771985493635995 -122.431632578487 POINT (-122.43163258 37.77198549) Mobile/Open311 http://mobile311.sfgov.org/reports/9830880/photos 26 4 11 9 11 15 6 29,492 9 10 10   26   11             1         26
524600 524600 9980849 2018-12-27T09:57:00 2018-12-27T10:50:00 2018-12-27T10:50:00 Closed 2 DPW Duplicate. Closed. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 349 HAYES ST, SAN FRANCISCO, CA, 94102 HAYES ST 5 Civic Center NORTHERN 37.776882171630994 -122.422119140625 POINT (-122.42211914 37.77688217) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
527297 527297 10310044 2019-01-03T11:12:00 2019-03-28T19:12:00 2019-03-28T19:12:00 Closed 2 Case transferred, see SR#10659047 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 861 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.758777618408 -122.403755187988 POINT (-122.40375519 37.75877762) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
530224 530224 9905223 2018-12-07T14:52:00 2018-12-07T16:49:00 2018-12-07T16:49:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of OSHAUGHNESSY BLVD and DEL VALE AVE OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.741199493408 -122.445960998535 POINT (-122.445961 37.74119949) Phone   96 9 5 10 5 9 4 59 7 7 7   96   5             1         96
545285 545285 10386032 2019-01-21T15:49:00 2019-01-21T16:50:00 2019-01-21T16:50:00 Closed 2 Note Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2019-01-21T16:29:58 : Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 5268 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Silver Terrace BAYVIEW 37.72970199585 -122.392616271973 POINT (-122.39261627 37.729702) Phone   87 2 9 1 8 10 3 58 3 1 1 11 87   9 13     13     2         87
556053 556053 9875577 2018-12-01T07:34:00 2018-12-01T08:33:00 2018-12-01T08:33:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JOHN F KENNEDY DR and TRANSVERSE DR JOHN F KENNEDY DR 1 Golden Gate Park RICHMOND 37.770496368408 -122.47989654541 POINT (-122.47989655 37.77049637) Phone   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
571813 571813 10688370 2019-04-04T18:42:00 2019-04-04T19:41:00 2019-04-04T19:41:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 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
574153 574153 10524584 2019-02-23T10:27:00 2019-02-23T10:54:00 2019-02-23T10:54:00 Closed 2 Per DPW, this is a duplicate. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of CHURCH ST and CESAR CHAVEZ ST CHURCH ST 8 Noe Valley MISSION 37.747695922852 -122.427047729492 POINT (-122.42704773 37.74769592) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
576367 576367 10692810 2019-04-05T18:04:00 2019-04-05T18:34:00 2019-04-05T18:34:00 Closed 2 what kind of landscaping is needed. PLease add info. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other 5738 GEARY BLVD, SAN FRANCISCO, CA, 94121 GEARY BLVD 1 Outer Richmond RICHMOND 37.780285513888 -122.480884419245 POINT (-122.48088442 37.78028551) Mobile/Open311   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
580173 580173 10542752 2019-02-27T16:37:00 2019-02-27T18:00:00 2019-02-27T18:00:00 Closed 2 Per DPW, Duplicate Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2019-02-27T16:46:26 : Work Transferred from DPW SES to 311 Incomplete Info Return duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of WAVERLY PL and SACRAMENTO ST WAVERLY PL 3 Chinatown CENTRAL 37.793315887451 -122.40664672851601 POINT (-122.40664673 37.79331589) Phone   104 6 3 6 10 3 1 28,857 1 4 4 5 104   3 5     5     2     23   104
586862 586862 10487627 2019-02-14T08:11:00 2019-02-14T09:14:00 2019-02-14T09:14:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2900 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Outer Mission INGLESIDE 37.711902618408 -122.452812194824 POINT (-122.45281219 37.71190262) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
609460 609460 10437831 2019-02-01T15:31:00 2019-02-01T17:54:00 2019-02-01T17:54:00 Closed 2 needs more description but no contact info and no photo. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other 3 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 6 Mission SOUTHERN 37.7579842 -122.42095479999999 POINT (-122.4209548 37.7579842) Web   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
609784 609784 10588409 2019-03-11T13:06:00 2019-08-10T14:39:00 2019-08-10T14:39:00 Closed 2 Photo provided does not match location. Left detailed message advising customer case will be closed due to unverifiable location and to please call 3-1-1 to submit new SR with correct location details. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 9TH AVE and MARTIN LUTHER KING JR DR 9TH AVE 5 Golden Gate Park RICHMOND 37.7663645 -122.4664619 POINT (-122.4664619 37.7663645) Web http://mobile311.sfgov.org/reports/10588409/photos 9 8 11 12 11 11 9 29,492 6 8 8   9   11             1         9
621197 621197 10541975 2019-02-27T14:15:00 2019-06-21T14:30:00 2019-06-21T14:30:00 Closed 2 Duplicate of case 10870857 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 20 CRESTLINE DR, SAN FRANCISCO, CA, 94131 CRESTLINE DR 8 Upper Market PARK 37.7499049 -122.4457064 POINT (-122.4457064 37.7499049) Web   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
646596 646596 10573929 2019-03-07T11:55:00 2019-03-07T15:00:00 2019-03-07T15:00:00 Closed 2 Per notes: Please cancel this SR. Customer called stating that the tree is on the sidewalk and he cut it up into pieces. New SR # 10574003 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 15 BEAVER ST, SAN FRANCISCO, CA, 94114 BEAVER ST 8 Duboce Triangle PARK 37.764958750378 -122.433878837042 POINT (-122.43387884 37.76495875) Mobile/Open311 http://mobile311.sfgov.org/reports/10573929/photos 28 7 5 5 5 15 8 28,862 5 3 3   28   5             1   5     28
658368 658368 10497741 2019-02-16T15:14:00 2019-02-16T16:00:00 2019-02-16T16:00:00 Closed 2 Privately owned tree- refer to property owner to resolve. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 164 GEARY ST, SAN FRANCISCO, CA, 94108 GEARY ST 3 Downtown / Union Square CENTRAL 37.787529774977 -122.40606601361401 POINT (-122.40606601 37.78752977) Mobile/Open311 http://mobile311.sfgov.org/reports/10497741/photos 19 6 3 8 10 5 10 28,857 10 6 6 10 19   3 12     12 5   2         19
659105 659105 10622336 2019-03-19T16:55:00 2019-03-19T17:56:00 2019-03-19T17:56:00 Closed 2 Case transferred, see SR#10622614 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of COLUMBUS AVE and UNION ST COLUMBUS AVE 3 North Beach CENTRAL 37.800315856934 -122.410209655762 POINT (-122.41020966 37.80031586) Phone   106 6 3 6 10 3 1 308 1 4 4 21 106   3 23     23     2         106
661164 661164 277758 2008-09-08T09:15:32 2009-02-19T12:56:54 2009-02-19T12:56:54 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 299 ARGUELLO BLVD, SAN FRANCISCO, CA, 94118 ARGUELLO BLVD 1 Inner Richmond RICHMOND 37.785259246826 -122.45935821533199 POINT (-122.45935822 37.78525925) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
661970 661970 380659 2009-02-28T22:54:56 2009-03-01T07:06:25 2009-03-01T07:06:25 Closed 2 Per DPW, Duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of LISBON ST and SILVER AVE LISBON ST 11 Mission Terrace INGLESIDE 37.728534698486 -122.428665161133 POINT (-122.42866516 37.7285347) Phone     9 1 7 6 9 4 28,861 7 5 5 16     1             2          
663253 663253 341478 2008-12-30T13:30:20 2008-12-31T06:56:32 2008-12-31T06:56:32 Closed 2 Per BSM Private Tree, BSM to Enforce 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 1704 FELTON ST, SAN FRANCISCO, CA, 94134 FELTON ST 9 University Mound INGLESIDE 37.725688934326 -122.421600341797 POINT (-122.42160034 37.72568893) Phone   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
663271 663271 262326 2008-08-09T15:16:50 2008-08-17T07:47:56 2008-08-17T07:47:56 Closed 2 Case is Invalid SR 265607 sreated sand sent to Rec/Park. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Yacht Harbor and Marina Green, SAN FRANCISCO, CA, 94123 Yacht Harbor and Marina Green 2 Marina NORTHERN 37.806774139404 -122.440757751465 POINT (-122.44075775 37.80677414) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
663980 663980 326030 2008-12-05T13:35:05 2008-12-11T07:35:38 2008-12-11T07:35:38 Closed 2 INVALID EXACT ADDRESS NEEDED 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of ALEMANY BLVD and OCEAN AVE ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.72371673584 -122.43743896484399 POINT (-122.43743896 37.72371674) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
665893 665893 244089 2008-07-08T10:17:11 2008-07-09T07:13:45 2008-07-09T07:13:45 Closed 2 Case Resolved Muni complaint was submitted. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 760 DELANO AVE, SAN FRANCISCO, CA, 94112 DELANO AVE 11 Cayuga INGLESIDE 37.719367980956996 -122.44570922851601 POINT (-122.44570923 37.71936798) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
667849 667849 443886 2009-06-04T11:00:40 2009-06-05T06:55:27 2009-06-05T06:55:27 Closed 2 Private trees 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 526 47TH AVE, SAN FRANCISCO, CA, 94121 47TH AVE 1 Sutro Heights RICHMOND 37.778392791748 -122.508094787598 POINT (-122.50809479 37.77839279) Phone   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
668180 668180 380399 2009-02-28T16:16:30 2009-03-01T07:05:53 2009-03-01T07:05:53 Closed 2 Invalid Requet. Exact Address. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of MISSION ST and SILVER AVE MISSION ST 11 Mission Terrace INGLESIDE 37.728729248046996 -122.431297302246 POINT (-122.4312973 37.72872925) Phone   94 9 1 28 6 9 4 28,861 7 25 25 16 94   1       4     1         94
668297 668297 247130 2008-07-14T09:11:31 2008-07-16T22:50:03 2008-07-16T22:50:03 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 156 MOFFITT ST, SAN FRANCISCO, CA, 94131 MOFFITT ST 8 Fairmount INGLESIDE 37.737945556641 -122.43360137939501 POINT (-122.43360138 37.73794556) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
671906 671906 263447 2008-08-12T09:09:12 2008-08-13T22:34:09 2008-08-13T22:34:09 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 54 HOWTH ST, SAN FRANCISCO, CA, 94112 HOWTH ST 7 Oceanview INGLESIDE 37.722290039063 -122.45011901855499 POINT (-122.45011902 37.72229004) Phone   81 9 8 24 4 9 4 28,861 7 24 24   81   8             2         81
672043 672043 251294 2008-07-21T09:20:15 2008-07-23T20:29:51 2008-07-23T20:29:51 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 315 NORIEGA ST, SAN FRANCISCO, CA, 94122 NORIEGA ST 7 Golden Gate Heights TARAVAL 37.754512786865 -122.467071533203 POINT (-122.46707153 37.75451279) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
674805 674805 344737 2009-01-05T10:34:24 2009-01-06T10:10:24 2009-01-06T10:10:24 Closed 2 Sent Back. Not a City Tree, Closing Out. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of GOLDEN GATE AVE and PARKER AVE GOLDEN GATE AVE 1 Lone Mountain PARK 37.776851654053004 -122.45318603515601 POINT (-122.45318604 37.77685165) Phone   12 7 4 18 2 15 9 29,492 6 16 16   12   4             1         12
676068 676068 383591 2009-03-05T11:32:14 2009-03-05T16:43:44 2009-03-05T16:43:44 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 635 PAUL AVE, SAN FRANCISCO, CA, 94134 PAUL AVE 9 Portola BAYVIEW 37.723705291748 -122.401718139648 POINT (-122.40171814 37.72370529) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2   4         2         91
676701 676701 243939 2008-07-07T21:24:05 2008-07-08T17:05:42 2008-07-08T17:05:42 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 17TH ST and MARKET ST 17TH ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
676911 676911 247186 2008-07-14T10:01:14 2008-07-16T23:00:58 2008-07-16T23:00:58 Closed 2 Case Resolved 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 38 DUBLIN ST, SAN FRANCISCO, CA, 94112 DUBLIN ST 11 Excelsior INGLESIDE 37.719039916992 -122.42608642578101 POINT (-122.42608643 37.71903992) Phone   90 9 1 7 6 9 4 309 7 5 5   90   1             2         90

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