This data as json, CSV (advanced)
| 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 | 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 | 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 | 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) | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 13 | 53 | 2 | 15 | 3 | 15 | 2 | 3 | 53 | |||||||||||
| 1034545 | 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 | 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) | 37 | 3 | 5 | 20 | 5 | 2 | 7 | 28,859 | 4 | 19 | 19 | 37 | 5 | 1 | 37 | ||||||||||||||||
| 1074665 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 |
JSON shape: default, array, newline-delimited
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))