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
164003 164003 3456291 2014-03-15T09:57:07 2017-02-03T13:30:25 2017-02-03T13:30:25 Closed 2 Issue addressed by RPD IPM. RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Tree_Other 4   Washington Square, , SAN FRANCISCO, CA, 94133 Washington Square 3 North Beach CENTRAL 37.800636640785 -122.409655144552 POINT (-122.40965514 37.80063664) Mobile/Open311 http://mobile311.sfgov.org/reports/3456291/photos 106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
834765 834765 588282 2010-01-25T14:27:55 2010-03-05T10:16:40 2010-03-05T10:16:40 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HERMANN ST and LAGUNA ST HERMANN ST 8 Mint Hill PARK 37.77087020874 -122.425132751465 POINT (-122.42513275 37.77087021) Web   27 7 5 9 5 7 6 28,852 9 10 10   27   5         9   1         27
962381 962381 791048 2010-12-18T11:15:28 2010-12-18T20:09:22 2010-12-18T20:09:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2366 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.759231567383 -122.419273376465 POINT (-122.41927338 37.75923157) Twitter   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1034545 1034545 758696 2010-10-24T15:36:34 2010-11-17T08:09:31 2010-11-17T08:09:31 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   Intersection of SILLIMAN ST and SOMERSET ST SILLIMAN ST 9 Portola BAYVIEW 37.730201721191 -122.409042358398 POINT (-122.40904236 37.73020172) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
1065255 1065255 791063 2010-12-18T11:44:21 2010-12-22T06:09:25 2010-12-22T06:09:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3535 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 8 Mission Dolores MISSION 37.75993347168 -122.42223358154301 POINT (-122.42223358 37.75993347) Twitter   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
1074665 1074665 701465 2010-07-27T13:38:36 2010-07-27T14:17:06 2010-07-27T14:17:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 14TH ST and WALTER ST 14TH ST 8 Duboce Triangle PARK 37.767528533936 -122.43229675293001 POINT (-122.43229675 37.76752853) Web   28 7 5 5 5 15 8 28,862 5 3 3 18 28   5 20     20     1   5     28
1088158 1088158 844137 2011-03-17T04:44:38 2011-03-19T12:06:04 2011-03-19T12:06:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   602 SHOTWELL ST, SAN FRANCISCO, CA, 94110 SHOTWELL ST 9 Mission MISSION 37.758674621581996 -122.41588592529301 POINT (-122.41588593 37.75867462) Phone   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1088567 1088567 852102 2011-03-29T18:32:09 2011-03-31T19:06:02 2011-03-31T19:06:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   Intersection of BUENA VISTA EAST AVE and WALLER ST BUENA VISTA EAST AVE 5 Buena Vista PARK 0.0 0.0 POINT (0 0) Phone                                                        
1102527 1102527 858394 2011-04-08T04:58:19 2011-04-08T05:47:46 2011-04-08T05:47:46 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   118 HIGHLAND AVE, SAN FRANCISCO, CA, 94110 HIGHLAND AVE 9 Holly Park INGLESIDE 37.73726272583 -122.423446655273 POINT (-122.42344666 37.73726273) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
1143279 1143279 815233 2011-01-28T13:33:25 2011-08-26T15:45:54 2011-08-26T15:45:54 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   104 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.743259429931996 -122.43799591064501 POINT (-122.43799591 37.74325943) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
1147975 1147975 956850 2011-09-06T17:23:03 2011-09-06T19:05:39 2011-09-06T19:05:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of MISSION ST and THE EMBARCADERO MISSION ST 6 Financial District SOUTHERN 37.793769836426 -122.39250183105499 POINT (-122.39250183 37.79376984) Phone   108 1 3 8 10 12 2 28,855 2 6 6   108   3     4       1   4     108
1150585 1150585 868493 2011-04-24T13:59:54 2011-04-28T15:42:54 2011-04-28T15:42:54 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   640 POLK ST, SAN FRANCISCO, CA, 94102 POLK ST 6 Tenderloin NORTHERN 37.782722473145 -122.41893768310499 POINT (-122.41893768 37.78272247) Phone   20 5 10 36 9 7 6 28,852 9 36 36   20 1 10   16       1 2 1       20
1157575 1157575 843423 2011-03-15T21:22:25 2011-07-08T04:31:05 2011-07-08T04:31:05 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 SSP Tree Maintenance Damage 6   Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1193047 1193047 825265 2011-02-13T11:31:18 2014-10-31T09:35:00 2014-10-31T09:35:00 Closed 2 resolved: damaged sidewalk & curb due to tree root problems. - painted, posted, took photosNTR # 955652, DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4   3948 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Castro MISSION 37.762687683105 -122.43400573730499 POINT (-122.43400574 37.76268768) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1     1     1   5     38
1209229 1209229 860612 2011-04-11T18:17:25 2011-08-05T17:06:01 2011-08-05T17:06:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   538 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Hayes Valley NORTHERN 37.77555847168 -122.42673492431601 POINT (-122.42673492 37.77555847) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
1254655 1254655 1007057 2011-11-18T11:35:20 2011-11-18T16:07:00 2011-11-18T16:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of ASHBURY ST and FREDERICK ST ASHBURY ST 5 Haight Ashbury PARK 37.767219543456996 -122.44637298584 POINT (-122.44637299 37.76721954) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
1257634 1257634 1012828 2011-11-29T10:10:27 2014-05-22T10:58:35 2014-05-22T10:58:35 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3   1447 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Bayview BAYVIEW 37.732250213623 -122.38816070556601 POINT (-122.38816071 37.73225021) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1439474 1439474 1325194 2012-08-23T13:33:08 2012-09-08T15:19:12 2012-09-08T15:19:12 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   77 OTIS ST, SAN FRANCISCO, CA, 94103 OTIS ST 6 South of Market SOUTHERN 37.771778106689 -122.419723510742 POINT (-122.41972351 37.77177811) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2   1     32
1487859 1487859 1873687 2013-01-09T10:49:34 2013-01-24T09:13:13 2013-01-24T09:13:13 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3   2733 WAWONA ST, SAN FRANCISCO, CA, 94116 WAWONA ST 4 Parkside TARAVAL 37.736389160156 -122.49631500244101 POINT (-122.496315 37.73638916) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1507780 1507780 2541842 2013-06-28T08:03:11 2013-06-28T08:09:18 2013-06-28T08:09:18 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   2518 14TH AVE, SAN FRANCISCO, CA, 94127 14TH AVE 7 West Portal TARAVAL 37.741016387939 -122.469917297363 POINT (-122.4699173 37.74101639) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
1510471 1510471 2572114 2013-07-05T18:40:58 2013-07-05T20:01:26 2013-07-05T20:01:26 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   2734 DIAMOND ST, SAN FRANCISCO, CA, 94131 DIAMOND ST 8 Glen Park INGLESIDE 37.735595703125 -122.43423461914101 POINT (-122.43423462 37.7355957) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
1511606 1511606 2564273 2013-07-03T14:46:29   2013-07-03T15:24:56 Open 1 open DPW - Bureau of Urban Forestry - G 8 Tree Maintenance 1 Trees - Damaged_Tree 1   Intersection of MARKET ST and STORRIE ST MARKET ST 8 Eureka Valley MISSION 37.761047363281 -122.440254211426 POINT (-122.44025421 37.76104736) Phone   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1513257 1513257 2217628 2013-04-08T01:08:54 2013-04-08T05:20:30 2013-04-08T05:20:30 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CALIFORNIA ST and PARK PRESIDIO BLVD CALIFORNIA ST 1 Inner Richmond RICHMOND 37.784450531005994 -122.472587585449 POINT (-122.47258759 37.78445053) Phone   2 8 4 29 2 11 9 54 6 26 26   2   4             1     3   2
1518666 1518666 2695652 2013-08-09T10:49:36 2013-08-22T17:59:36 2013-08-22T17:59:36 Closed 2 Reassigned to SR# 2744236 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   672 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.771757002955 -122.433437034602 POINT (-122.43343703 37.771757) Mobile/Open311 http://mobile311.sfgov.org/reports/2695652/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
1530254 1530254 2308470 2013-04-30T17:18:10 2014-08-07T11:32:04 2014-08-07T11:32:04 Closed 2 resolved: Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   1616 INGALLS ST, SAN FRANCISCO, CA, 94124 INGALLS ST 10 Bayview BAYVIEW 37.728939056396 -122.38430023193399 POINT (-122.38430023 37.72893906) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1538128 1538128 2695640 2013-08-09T10:46:37 2013-09-04T07:17:52 2013-09-04T07:17:52 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   628 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.77188646145 -122.432749047989 POINT (-122.43274905 37.77188646) Mobile/Open311 http://mobile311.sfgov.org/reports/2695640/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
1539507 1539507 2222131 2013-04-08T18:42:02 2013-04-23T09:18:02 2013-04-23T09:18:02 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1   Intersection of 37TH AVE and YORBA ST 37TH AVE 4 Parkside TARAVAL 37.734809875488 -122.49446105956999 POINT (-122.49446106 37.73480988) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1546081 1546081 1959876 2013-01-31T12:25:46 2014-06-06T12:00:00 2014-06-06T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:New tree appears to meet size requirement. Establishing well. BUF Action:INSPECT. date completed - 6/6/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   433 CORTLAND AVE, SAN FRANCISCO, CA, 94110 CORTLAND AVE 9 Bernal Heights INGLESIDE 37.739231109619006 -122.417282104492 POINT (-122.4172821 37.73923111) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
1548034 1548034 2461782 2013-06-07T10:25:57 2013-07-17T07:02:52 2013-07-17T07:02:52 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3   63 POWELL ST, SAN FRANCISCO, CA, 94102 POWELL ST 3 Downtown / Union Square CENTRAL 37.785305023193004 -122.408065795898 POINT (-122.4080658 37.78530502) Phone   19 5 3 36 10 14 10 28,852 10 36 36   19   3         5 1 2 1       19
1573613 1573613 2393163 2013-05-21T14:53:21 2013-06-14T09:22:52 2013-06-14T09:22:52 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2   333 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Hayes Valley NORTHERN 37.775608062744006 -122.42342376709 POINT (-122.42342377 37.77560806) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
1624789 1624789 2250042 2013-04-16T09:31:10 2013-04-18T00:02:45 2013-04-18T00:02:45 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of COLUMBUS AVE and GREENWICH ST COLUMBUS AVE 3 Russian Hill CENTRAL 37.801929473877 -122.412544250488 POINT (-122.41254425 37.80192947) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3       23     2         107
1628996 1628996 2500103 2013-06-17T12:29:29 2013-07-11T13:18:03 2013-07-11T13:18:03 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3   550 MONTEREY BLVD, SAN FRANCISCO, CA, 94127 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731700897217 -122.44775390625 POINT (-122.44775391 37.7317009) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
1643198 1643198 3209279 2013-12-28T08:41:16 2015-02-26T02:57:13 2015-02-26T02:57:13 Closed 2 resolved: no empty basin found at 2600 harrison st. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2600 HARRISON ST, SAN FRANCISCO, CA, 94110 HARRISON ST 9 Mission MISSION 37.755450530358 -122.41242231983601 POINT (-122.41242232 37.75545053) Mobile/Open311 http://mobile311.sfgov.org/reports/3209279/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1643327 1643327 2772850 2013-08-30T16:11:33 2013-08-31T22:16:10 2013-08-31T22:16:10 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   100 LAIDLEY ST, SAN FRANCISCO, CA, 94131 LAIDLEY ST 8 Fairmount INGLESIDE 37.740172231605 -122.430974850545 POINT (-122.43097485 37.74017223) Mobile/Open311 http://mobile311.sfgov.org/reports/2772850/photos 59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
1643920 1643920 3296514 2014-01-22T12:15:27 2014-02-08T15:20:11 2014-02-08T15:20:11 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   150 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.783172568341996 -122.41169295285101 POINT (-122.41169295 37.78317257) Mobile/Open311 http://mobile311.sfgov.org/reports/3296514/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
1645046 1645046 2803618 2013-09-08T18:42:28 2013-09-10T10:04:43 2013-09-10T10:04:43 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 8TH AVE and LAWTON ST 8TH AVE 7 Inner Sunset TARAVAL 37.758500640601 -122.46487770101601 POINT (-122.4648777 37.75850064) Mobile/Open311   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
1648075 1648075 3105514 2013-11-26T12:08:46 2013-12-03T14:05:02 2013-12-03T14:05:02 Closed 2 resolved: 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.764009479814 -122.42189892574899 POINT (-122.42189893 37.76400948) Mobile/Open311 http://mobile311.sfgov.org/reports/3105514/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5     3       2   3     37
1648387 1648387 3151488 2013-12-10T14:33:24 2013-12-11T11:03:13 2013-12-11T11:03:13 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   938 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.778203482775 -122.43839509796601 POINT (-122.4383951 37.77820348) Mobile/Open311 http://mobile311.sfgov.org/reports/3151488/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
1648507 1648507 3251810 2014-01-09T10:41:19 2014-01-10T09:17:22 2014-01-10T09:17:22 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   111 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.782351351378004 -122.412478001902 POINT (-122.412478 37.78235135) Mobile/Open311 http://mobile311.sfgov.org/reports/3251810/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
1655715 1655715 3125524 2013-12-03T10:18:51 2014-01-03T23:02:30 2014-01-03T23:02:30 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HAYES ST and MARKET ST HAYES ST 6 Civic Center TENDERLOIN 37.777960247238 -122.415801715812 POINT (-122.41580172 37.77796025) Mobile/Open311 http://mobile311.sfgov.org/reports/3125524/photos 21 5 10 36 9 7 2 28,852 2 36 36   21 1 10     1   7 1 2 1 1 35   21
1655895 1655895 3317510 2014-01-29T09:35:17 2014-02-10T14:17:25 2014-02-10T14:17:25 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3261 23RD ST, SAN FRANCISCO, CA, 94110 23RD ST 9 Mission MISSION 37.753763361869 -122.41785759117701 POINT (-122.41785759 37.75376336) Mobile/Open311 http://mobile311.sfgov.org/reports/3317510/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1656428 1656428 3251865 2014-01-09T10:49:00 2014-01-14T14:21:13 2014-01-14T14:21:13 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   335 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.784335683135 -122.412694422642 POINT (-122.41269442 37.78433568) Mobile/Open311 http://mobile311.sfgov.org/reports/3251865/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
1656582 1656582 3217514 2013-12-31T06:09:00 2014-03-28T23:23:57 2014-03-28T23:23:57 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   198 NOE ST, SAN FRANCISCO, CA, 94114 NOE ST 8 Duboce Triangle PARK 37.765879102448004 -122.433442 POINT (-122.433442 37.7658791) Mobile/Open311   28 7 5 5 5 15 8 28,862 5 3 3 18 28   5 20     20     1   5     28
1657512 1657512 3251725 2014-01-09T10:27:44 2014-01-22T16:19:11 2014-01-22T16:19:11 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   55 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.781636668404005 -122.41208086733 POINT (-122.41208087 37.78163667) Mobile/Open311 http://mobile311.sfgov.org/reports/3251725/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
1658090 1658090 3305723 2014-01-25T11:11:41 2014-10-31T02:57:41 2014-10-31T02:57:41 Closed 2 resolved: legal removal. sb DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BRYANT ST and JACK LONDON ALY BRYANT ST 6 South Beach SOUTHERN 37.782154250925004 -122.394802663589 POINT (-122.39480266 37.78215425) Mobile/Open311 http://mobile311.sfgov.org/reports/3305723/photos 32 1 10 8 9 6 2 28,856 2 6 6   32   10             1         32
1660276 1660276 2824235 2013-09-13T12:16:19 2013-09-18T16:18:17 2013-09-18T16:18:17 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   995 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.782453054359 -122.40992204010401 POINT (-122.40992204 37.78245305) Mobile/Open311 http://mobile311.sfgov.org/reports/2824235/photos 32 5 10 34 9 14 2 28,853 2 34 34 17 32 1 10 18     18 7 1 2 1   35   32
1660572 1660572 2837599 2013-09-17T10:17:17 2014-01-31T12:18:10 2014-01-31T12:18:10 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   396 CUMBERLAND ST, SAN FRANCISCO, CA, 94114 CUMBERLAND ST 8 Dolores Heights MISSION 37.758889 -122.432524 POINT (-122.432524 37.758889) Mobile/Open311 http://mobile311.sfgov.org/reports/2837599/photos 52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
1661654 1661654 3162356 2013-12-13T09:48:09 2014-01-16T07:16:37 2014-01-16T07:16:37 Closed 2 resolved: 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.751105963288005 -122.416186323503 POINT (-122.41618632 37.75110596) Mobile/Open311 http://mobile311.sfgov.org/reports/3162356/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1662151 1662151 3126553 2013-12-03T13:05:52 2013-12-16T13:16:10 2013-12-16T13:16:10 Closed 2 resolved: Request closed by SES . Notes = " Notes:Emmpty basin reported on this block of Potrero could be other side of street reported but no empty basins spotted on Google. DM will use even side of street on this block as SR. BUF Action:PLANT. date completed - 12/14/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 21ST ST and POTRERO AVE 21ST ST 9 Mission MISSION 37.757878624869 -122.406795071552 POINT (-122.40679507 37.75787862) Mobile/Open311 http://mobile311.sfgov.org/reports/3126553/photos 54 3 2 20 7 10 7 28,859 4 19 19   54   2     3       2   3     54
1662722 1662722 3135129 2013-12-05T14:34:58 2013-12-05T15:09:52 2013-12-05T15:09:52 Closed 2 uneven dirt, what tripping hazard, no contact information- invalid 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of OFARRELL ST and VAN NESS AVE OFARRELL ST 6 Cathedral Hill NORTHERN 37.784957285074 -122.421382935832 POINT (-122.42138294 37.78495729) Mobile/Open311 http://mobile311.sfgov.org/reports/3135129/photos 100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
1662895 1662895 3278256 2014-01-16T11:58:47 2014-03-07T04:09:05 2014-03-07T04:09:05 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 16TH ST and SHOTWELL ST 16TH ST 9 Mission MISSION 37.765202480403 -122.416738355646 POINT (-122.41673836 37.76520248) Mobile/Open311 http://mobile311.sfgov.org/reports/3278256/photos 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3     53
1664476 1664476 3333256 2014-02-03T12:19:58 2014-02-13T11:04:09 2014-02-13T11:04:09 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 2/13/14 May need pave. DM. BUF Action:REMOVE STUMP. date completed - 2/13/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   169 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 2 Seacliff RICHMOND 37.786300694604996 -122.485392261411 POINT (-122.48539226 37.78630069) Mobile/Open311 http://mobile311.sfgov.org/reports/3333256/photos 1 8 6 33 1 11 9 55 6 33 33   1   6             1         1
1665711 1665711 3344125 2014-02-06T11:37:42 2016-04-11T05:10:07 2016-04-11T05:10:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   390 CORBETT AVE, SAN FRANCISCO, CA, 94114 CORBETT AVE 8 Eureka Valley PARK 37.759106 -122.446396 POINT (-122.446396 37.759106) Mobile/Open311   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
1665865 1665865 3269893 2014-01-14T11:31:36 2014-05-09T03:28:36 2014-05-09T03:28:36 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HAIGHT ST and MARKET ST HAIGHT ST 5 South of Market SOUTHERN 37.772934995627 -122.42171905014901 POINT (-122.42171905 37.772935) Mobile/Open311 http://mobile311.sfgov.org/reports/3269893/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
1666746 1666746 2931982 2013-10-11T08:06:26 2013-10-18T15:21:23 2013-10-18T15:21:23 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3134 23RD ST, SAN FRANCISCO, CA, 94110 23RD ST 9 Mission MISSION 37.754080616904 -122.414979580904 POINT (-122.41497958 37.75408062) Mobile/Open311 http://mobile311.sfgov.org/reports/2931982/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1672554 1672554 3218986 2013-12-31T12:42:51 2014-04-18T08:33:05 2014-04-18T08:33:05 Closed 2 resolved: Request closed by SES . Notes = " Notes:Sending ltr remove angel trumpet fro basin, too large a species, complaint from public, clearance issues . BUF Action:INSPECT. date completed - 4/18/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2179 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Duboce Triangle PARK 37.765847509762004 -122.432823395471 POINT (-122.4328234 37.76584751) Mobile/Open311 http://mobile311.sfgov.org/reports/3218986/photos 28 7 5 5 5 15 8 28,862 5 3 3 18 28   5 20     20     1   5     28
1673948 1673948 3135239 2013-12-05T14:54:26 2014-01-29T16:31:46 2014-01-29T16:31:46 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Correspondence. date completed - 1/28/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   710 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 6 Tenderloin NORTHERN 37.782135024458 -122.420474337502 POINT (-122.42047434 37.78213502) Mobile/Open311 http://mobile311.sfgov.org/reports/3135239/photos 20 4 10 36 9 7 6 28,852 9 36 36   20 1 10           1 2 1       20
1676888 1676888 3185746 2013-12-20T08:43:45 2014-01-17T12:01:09 2014-01-17T12:01:09 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 1/17/14. BUF Action:Correspondence. date completed - 1/17/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   787 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 9 Mission MISSION 37.760399589363 -122.42134666151001 POINT (-122.42134666 37.76039959) Mobile/Open311 http://mobile311.sfgov.org/reports/3185746/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1677861 1677861 3379351 2014-02-18T12:56:31 2014-07-02T10:31:30 2014-07-02T10:31:30 Closed 2 resolved: Crosswalk clearly visible DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   502 PRECITA AVE, SAN FRANCISCO, CA, 94110 PRECITA AVE 9 Peralta Heights INGLESIDE 37.746773273719 -122.410569526369 POINT (-122.41056953 37.74677327) Mobile/Open311 http://mobile311.sfgov.org/reports/3379351/photos 60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
1678869 1678869 2776880 2013-09-01T09:22:21 2013-09-03T09:06:52 2013-09-03T09:06:52 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of CORTLAND AVE and WINFIELD ST CORTLAND AVE 9 Holly Park INGLESIDE 37.739890569696996 -122.420215982001 POINT (-122.42021598 37.73989057) Mobile/Open311   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
1679090 1679090 3206160 2013-12-27T09:49:07 2014-03-27T15:28:23 2014-03-27T15:28:23 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 12TH AVE and JUDAH ST 12TH AVE 7 Inner Sunset TARAVAL 37.762032311654 -122.469391470571 POINT (-122.46939147 37.76203231) Phone   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
1684599 1684599 2824717 2013-09-13T13:46:58 2013-09-13T15:06:11 2013-09-13T15:06:11 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   974 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Tenderloin TENDERLOIN 37.78265894985 -122.409755719811 POINT (-122.40975572 37.78265895) Mobile/Open311 http://mobile311.sfgov.org/reports/2824717/photos 20 5 10 34 9 14 2 28,853 2 34 34 17 20 1 10 18     18 7 1 2 1   35   20
1686680 1686680 3243389 2014-01-07T12:36:01 2014-01-24T12:17:45 2014-01-24T12:17:45 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3841 CLEMENT ST, SAN FRANCISCO, CA, 94121 CLEMENT ST 1 Outer Richmond RICHMOND 37.781244024338996 -122.500633549039 POINT (-122.50063355 37.78124402) Mobile/Open311 http://mobile311.sfgov.org/reports/3243389/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1686883 1686883 3085532 2013-11-20T12:47:56 2014-06-04T10:21:12 2014-06-04T10:21:12 Closed 2 resolved: Trees have been removed. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2430 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Corona Heights MISSION 37.762823 -122.435763 POINT (-122.435763 37.762823) Mobile/Open311   113 7 5 5 5 15 8 28,862 5 3 3 1 113   5 1           1         113
1688794 1688794 3063712 2013-11-14T11:59:40 2013-11-18T10:17:20 2013-11-18T10:17:20 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2876 24TH ST, SAN FRANCISCO, CA, 94110 24TH ST 9 Mission MISSION 37.752865451283 -122.409657156211 POINT (-122.40965716 37.75286545) Mobile/Open311 http://mobile311.sfgov.org/reports/3063712/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       1   3     53
1690494 1690494 3176766 2013-12-17T19:45:32 2013-12-18T13:01:26 2013-12-18T13:01:26 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   683 18TH AVE, SAN FRANCISCO, CA, 94121 18TH AVE 1 Inner Richmond RICHMOND 37.775089773385 -122.476907847563 POINT (-122.47690785 37.77508977) Mobile/Open311 http://mobile311.sfgov.org/reports/3176766/photos 5 8 4 29 2 11 9 55 6 26 26   5   4             1         5
1693981 1693981 3105487 2013-11-26T12:03:07 2013-12-03T14:06:24 2013-12-03T14:06:24 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   580 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission Dolores MISSION 37.763629230883005 -122.42183648062 POINT (-122.42183648 37.76362923) Mobile/Open311 http://mobile311.sfgov.org/reports/3105487/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5     3       2   3     37
1695429 1695429 3106063 2013-11-26T13:55:18 2013-12-03T11:48:23 2013-12-03T11:48:23 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 12/3/13 DM. BUF Action:Correspondence. date completed - 12/3/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   684 GEARY ST, SAN FRANCISCO, CA, 94109 GEARY ST 3 Lower Nob Hill CENTRAL 37.786692758755 -122.414746312536 POINT (-122.41474631 37.78669276) Mobile/Open311 http://mobile311.sfgov.org/reports/3106063/photos 50 6 3 36 10 5 1 28,858 1 36 36   50   3             2         50
1696259 1696259 3126611 2013-12-03T13:13:26 2014-04-16T14:28:32 2014-04-16T14:28:32 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2608 22ND ST, SAN FRANCISCO, CA, 94110 22ND ST 9 Mission MISSION 37.756358330035 -122.40676850092899 POINT (-122.4067685 37.75635833) Mobile/Open311 http://mobile311.sfgov.org/reports/3126611/photos 53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
1696261 1696261 3067707 2013-11-15T10:52:42 2013-12-06T15:20:21 2013-12-06T15:20:21 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 12/7/13 DM. BUF Action:Correspondence. date completed - 12/7/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BOYLSTON ST and GAVEN ST BOYLSTON ST 9 Portola BAYVIEW 37.73253536294 -122.411270924026 POINT (-122.41127092 37.73253536) Mobile/Open311 http://mobile311.sfgov.org/reports/3067707/photos 91 2 2 25 7 9 3 309 3 28 28   91   2             2         91
1696640 1696640 3296410 2014-01-22T11:55:52 2014-02-08T15:19:02 2014-02-08T15:19:02 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   288 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.783005223645 -122.413646187747 POINT (-122.41364619 37.78300522) Mobile/Open311 http://mobile311.sfgov.org/reports/3296410/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1702213 1702213 2930439 2013-10-10T15:35:03 2014-01-29T16:01:28 2014-01-29T16:01:28 Closed 2 resolved: Request closed by SES . Notes = " Notes:still paved due to Traffic light and handicap ramp.. BUF Action:INSPECT. date completed - 5/27/2011. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   6222 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bret Harte BAYVIEW 37.722053419043 -122.395965154586 POINT (-122.39596515 37.72205342) Mobile/Open311   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
1703958 1703958 3178038 2013-12-18T10:00:28 2014-01-31T11:30:59 2014-01-31T11:30:59 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Correspondence. date completed - 1/31/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   151 6TH ST, SAN FRANCISCO, CA, 94103 6TH ST 6 South of Market SOUTHERN 37.780386 -122.40789099999999 POINT (-122.407891 37.780386) Mobile/Open311 http://mobile311.sfgov.org/reports/3178038/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6 7 1 2 1 1     32
1704361 1704361 3251715 2014-01-09T10:26:54 2014-02-03T11:32:20 2014-02-03T11:32:20 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter due to SR# 1493259. There is a removal permit that's on file and it's possible that the tree hasn't been planted. 2/3/14. BUF Action:Correspondence. date completed - 2/3/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   55 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.781636668404005 -122.41208086733 POINT (-122.41208087 37.78163667) Mobile/Open311 http://mobile311.sfgov.org/reports/3251715/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
1708087 1708087 3305493 2014-01-25T09:38:34 2014-02-08T15:18:47 2014-02-08T15:18:47 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/3305493/photos 52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1708926 1708926 3042836 2013-11-08T11:44:53 2013-11-18T12:47:18 2013-11-18T12:47:18 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter 11/18/13. BUF Action:Correspondence. date completed - 11/18/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   4640 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Eureka Valley MISSION 37.760544 -122.441971 POINT (-122.441971 37.760544) Mobile/Open311   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1712281 1712281 3299042 2014-01-23T09:03:56 2014-01-23T10:01:01 2014-01-23T10:01:01 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter DM 1/16/14. BUF Action:Correspondence. date completed - 1/16/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   233 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Mission Dolores MISSION 37.766973852788 -122.42869481134701 POINT (-122.42869481 37.76697385) Mobile/Open311 http://mobile311.sfgov.org/reports/3299042/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5         9   1   5     37
1712405 1712405 3251760 2014-01-09T10:33:28 2014-01-13T07:20:06 2014-01-13T07:20:06 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of GOLDEN GATE AVE and JONES ST GOLDEN GATE AVE 6 Tenderloin TENDERLOIN 37.78199193537 -122.41212906327299 POINT (-122.41212906 37.78199194) Mobile/Open311 http://mobile311.sfgov.org/reports/3251760/photos 20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
1715412 1715412 3278233 2014-01-16T11:53:39 2014-02-14T14:16:54 2014-02-14T14:16:54 Closed 2 resolved: Request closed by SES . Notes = " Notes:Letter created. BUF Action:INSPECT. date completed - 2/14/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2740 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765448489262 -122.413825895751 POINT (-122.4138259 37.76544849) Mobile/Open311 http://mobile311.sfgov.org/reports/3278233/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
1715797 1715797 2856277 2013-09-21T19:14:22 2013-09-24T08:02:14 2013-09-24T08:02:14 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2807 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.752247 -122.418136 POINT (-122.418136 37.752247) Mobile/Open311 http://mobile311.sfgov.org/reports/2856277/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3 51   53
1716993 1716993 3126598 2013-12-03T13:11:27 2013-12-04T12:05:01 2013-12-04T12:05:01 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   934 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 9 Mission MISSION 37.757166800374996 -122.406853493413 POINT (-122.40685349 37.7571668) Mobile/Open311 http://mobile311.sfgov.org/reports/3126598/photos 53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
1721743 1721743 3090511 2013-11-21T14:57:27 2013-11-26T16:22:11 2013-11-26T16:22:11 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Permit Plant Tree. date completed - 3/13/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   169 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 2 Seacliff RICHMOND 37.786329821719 -122.48540240351299 POINT (-122.4854024 37.78632982) Mobile/Open311 http://mobile311.sfgov.org/reports/3090511/photos 1 8 6 33 1 11 9 55 6 33 33   1   6             1         1
1723074 1723074 3151335 2013-12-10T14:14:18 2013-12-11T11:03:03 2013-12-11T11:03:03 Closed 2 resolved: Request closed by SES . Notes = " Notes:basin to be shifted due to sewer line.. BUF Action:PAVE. date completed - 9/16/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   284 DIVISADERO ST, SAN FRANCISCO, CA, 94117 DIVISADERO ST 5 Lower Haight NORTHERN 37.77177213229 -122.437093053127 POINT (-122.43709305 37.77177213) Mobile/Open311 http://mobile311.sfgov.org/reports/3151335/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
1723410 1723410 3224437 2014-01-02T09:14:40 2014-01-22T14:24:25 2014-01-22T14:24:25 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1639 POLK ST, SAN FRANCISCO, CA, 94109 POLK ST 3 Polk Gulch NORTHERN 37.79199963439 -122.42108822811599 POINT (-122.42108823 37.79199963) Mobile/Open311 http://mobile311.sfgov.org/reports/3224437/photos 105 4 3 21 10 13 6 28,858 9 21 21   105   3             1         105
1726284 1726284 3104583 2013-11-26T09:20:12 2013-12-04T14:09:18 2013-12-04T14:09:18 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of NORTH POINT ST and POLK ST NORTH POINT ST 2 Aquatic Park / Ft. Mason CENTRAL 37.805739484143 -122.423752583629 POINT (-122.42375258 37.80573948) Mobile/Open311 http://mobile311.sfgov.org/reports/3104583/photos 98 6 6 32 1 5 1 28,858 1 32 32   98   6         2   1         98
1729633 1729633 3140915 2013-12-07T09:14:40 2013-12-09T10:03:56 2013-12-09T10:03:56 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   2783 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.752527399404 -122.418274926093 POINT (-122.41827493 37.7525274) Mobile/Open311 http://mobile311.sfgov.org/reports/3140915/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       2   3 51   53
1733236 1733236 3339010 2014-02-04T20:42:42 2014-02-04T22:15:22 2014-02-04T22:15:22 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1451 STOCKTON ST, SAN FRANCISCO, CA, 94133 STOCKTON ST 3 North Beach CENTRAL 37.799524 -122.40933999999999 POINT (-122.40934 37.799524) Mobile/Open311 http://mobile311.sfgov.org/reports/3339010/photos 106 6 3 6 10 3 1 308 1 4 4 21 106   3 23     23     2         106
1733726 1733726 3186178 2013-12-20T09:58:33 2013-12-20T12:02:53 2013-12-20T12:02:53 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   939 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 9 Mission MISSION 37.757953352341 -122.421009513454 POINT (-122.42100951 37.75795335) Mobile/Open311 http://mobile311.sfgov.org/reports/3186178/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1736929 1736929 3251067 2014-01-09T08:41:43 2014-01-09T13:15:06 2014-01-09T13:15:06 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   864 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.755309999999994 -122.39791899999999 POINT (-122.397919 37.75531) Mobile/Open311   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
1737717 1737717 2929999 2013-10-10T14:01:33 2013-10-11T13:47:21 2013-10-11T13:47:21 Closed 2 Transferred: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4   1254 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Civic Center TENDERLOIN 37.778400067248 -122.41538199858 POINT (-122.415382 37.77840007) Mobile/Open311 http://mobile311.sfgov.org/reports/2929999/photos 21 5 10 36 9 7 2 28,852 2 36 36   21 1 10     1   7 1 2 1 1 35   21
1738774 1738774 3379968 2014-02-18T14:48:49 2015-02-15T20:35:26 2015-02-15T20:35:26 Closed 2 Per PSA Manager, Trees are being replanted. RPD Park Service Area 5 Queue 11 Tree Maintenance 1 Trees - Tree_Other 4   Eureka Valley Playground, 100 COLLINGWOOD ST, SAN FRANCISCO, CA, 94114 COLLINGWOOD ST 8 Castro MISSION 37.759344200639 -122.43611807014999 POINT (-122.43611807 37.7593442) Mobile/Open311 http://mobile311.sfgov.org/reports/3379968/photos 38 3 5 5 5 2 7 28,862 4 3 3   38   5         9   1   5     38
1739629 1739629 3151499 2013-12-10T14:35:29 2013-12-11T10:04:12 2013-12-11T10:04:12 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   942 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.778357942938 -122.43834765647199 POINT (-122.43834766 37.77835794) Mobile/Open311 http://mobile311.sfgov.org/reports/3151499/photos 97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
1740719 1740719 3096528 2013-11-23T11:34:30 2013-12-06T15:20:32 2013-12-06T15:20:32 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Correspondence. date completed - 12/6/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 41ST AVE and BALBOA ST 41ST AVE 1 Outer Richmond RICHMOND 37.775466314712 -122.501482749462 POINT (-122.50148275 37.77546631) Mobile/Open311 http://mobile311.sfgov.org/reports/3096528/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1740723 1740723 3322474 2014-01-30T14:16:22 2015-01-23T03:04:22 2015-01-23T03:04:22 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Plant. date completed - 1/23/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3016 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765028 -122.419974 POINT (-122.419974 37.765028) Mobile/Open311 http://mobile311.sfgov.org/reports/3322474/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3   24 53
1742809 1742809 3370397 2014-02-15T11:32:43 2014-02-26T13:47:46 2014-02-26T13:47:46 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 2/26/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   1711 WASHINGTON ST, SAN FRANCISCO, CA, 94109 WASHINGTON ST 3 Polk Gulch NORTHERN 37.793117129324 -122.42172458986299 POINT (-122.42172459 37.79311713) Mobile/Open311 http://mobile311.sfgov.org/reports/3370397/photos 105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
1742827 1742827 3361452 2014-02-12T13:34:06 2014-02-12T14:21:40 2014-02-12T14:21:40 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of RITCH ST and BRANNAN ST RITCH ST 6 South of Market SOUTHERN 37.778879847382 -122.393829965832 POINT (-122.39382997 37.77887985) Mobile/Open311 http://mobile311.sfgov.org/reports/3361452/photos 32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
1743518 1743518 2934805 2013-10-11T17:24:40 2013-10-30T13:19:32 2013-10-30T13:19:32 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3662 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 8 Mission Dolores MISSION 37.759953018982 -122.424968965583 POINT (-122.42496897 37.75995302) Mobile/Open311 http://mobile311.sfgov.org/reports/2934805/photos 37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
1743619 1743619 2930437 2013-10-10T15:34:52 2013-10-15T15:19:10 2013-10-15T15:19:10 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5   Intersection of RANDOLPH ST and VERNON ST RANDOLPH ST 11 Merced Heights TARAVAL 37.714267730713 -122.46799468994101 POINT (-122.46799469 37.71426773) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
1744347 1744347 2848570 2013-09-19T15:48:28 2013-09-20T23:19:32 2013-09-20T23:19:32 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   3122 24TH ST, SAN FRANCISCO, CA, 94110 24TH ST 9 Mission MISSION 37.752525 -122.414576 POINT (-122.414576 37.752525) Mobile/Open311 http://mobile311.sfgov.org/reports/2848570/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1749990 1749990 2855225 2013-09-21T13:29:13 2013-09-25T14:26:09 2013-09-25T14:26:09 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of HENRY ST and SANCHEZ ST HENRY ST 8 Duboce Triangle PARK 37.766755322078 -122.431153217436 POINT (-122.43115322 37.76675532) Mobile/Open311 http://mobile311.sfgov.org/reports/2855225/photos 28 7 5 5 5 15 6 28,862 9 3 3 18 28   5 20     20     1   5     28

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