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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43 | 43 | 43 | 11535870 | 2019-10-11T08:56:58 | 2019-10-11T09:15:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 450 CARGO WAY, SAN FRANCISCO, CA, 94124 | CARGO WAY | 10 | Central Waterfront | BAYVIEW | 37.744414755201 | -122.384434893885 | POINT (-122.38443489 37.74441476) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11535870/photos | 76 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 76 | 9 | 1 | 76 | |||||||||||||
| 164 | 164 | 164 | 11509062 | 2019-10-05T12:19:00 | 2019-10-05T14:18:20 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 1601 9TH AVE, SAN FRANCISCO, CA, 94122 | 9TH AVE | 7 | Golden Gate Heights | TARAVAL | 37.75830078125 | -122.46605682373001 | POINT (-122.46605682 37.75830078) | Phone | 44 | 10 | 8 | 14 | 4 | 1 | 5 | 56 | 8 | 12 | 12 | 44 | 8 | 1 | 44 | ||||||||||||||
| 452 | 452 | 452 | 5694342 | 2016-03-23T18:50:33 | 2016-03-23T18:51:40 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 134 BARTLETT ST, SAN FRANCISCO, CA, 94110 | BARTLETT ST | 9 | Mission | MISSION | 37.754232202848 | -122.419873156843 | POINT (-122.41987316 37.7542322) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 569 | 569 | 569 | 11548402 | 2019-10-14T11:27:00 | 2019-10-14T11:35:27 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 2715 35TH AVE, SAN FRANCISCO, CA, 94116 | 35TH AVE | 4 | Parkside | TARAVAL | 37.7366065979 | -122.49261474609399 | POINT (-122.49261475 37.7366066) | Phone | 40 | 10 | 7 | 35 | 3 | 1 | 5 | 29,491 | 8 | 35 | 35 | 40 | 7 | 1 | 40 | ||||||||||||||
| 571 | 571 | 571 | 11548490 | 2019-10-14T11:41:00 | 2019-10-14T12:10:32 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 1433 INNES AVE, SAN FRANCISCO, CA, 94124 | INNES AVE | 10 | Bayview | BAYVIEW | 37.737487792969 | -122.385726928711 | POINT (-122.38572693 37.73748779) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 588 | 588 | 588 | 11611037 | 2019-10-28T08:24:00 | 2019-10-28T09:50:05 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Intersection of 45TH AVE and BALBOA ST | 45TH AVE | 1 | Outer Richmond | RICHMOND | 37.775321960449 | -122.50588226318399 | POINT (-122.50588226 37.77532196) | Phone | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 1 | 8 | ||||||||||||||
| 598 | 598 | 598 | 11549544 | 2019-10-14T14:52:21 | 2019-10-14T15:25:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of PIERCE ST and OAK ST | PIERCE ST | 5 | Lower Haight | NORTHERN | 37.773571000000004 | -122.43413000000001 | POINT (-122.43413 37.773571) | Mobile/Open311 | 26 | 4 | 11 | 9 | 11 | 15 | 8 | 29,492 | 5 | 10 | 10 | 26 | 11 | 1 | 26 | ||||||||||||||
| 640 | 640 | 640 | 11611992 | 2019-10-28T10:39:00 | 2019-10-29T15:15:05 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 763 15TH AVE, SAN FRANCISCO, CA, 94118 | 15TH AVE | 1 | Inner Richmond | RICHMOND | 37.773754119873 | -122.47365570068399 | POINT (-122.4736557 37.77375412) | Phone | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 54 | 6 | 26 | 26 | 5 | 4 | 1 | 5 | ||||||||||||||
| 1040 | 1040 | 1040 | 11618478 | 2019-10-29T14:21:00 | 2019-10-29T15:26:16 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1862 DIVISADERO ST, SAN FRANCISCO, CA, 94115 | DIVISADERO ST | 2 | Lower Pacific Heights | NORTHERN | 37.786952972412 | -122.44003295898399 | POINT (-122.44003296 37.78695297) | Phone | 103 | 4 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 103 | 6 | 1 | 103 | ||||||||||||||
| 1079 | 1079 | 1079 | 5682449 | 2016-03-20T09:14:10 | 2016-03-20T09:36:28 | Open 1 | open | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 90 VERNA ST, SAN FRANCISCO, CA, 94127 | VERNA ST | 7 | Miraloma Park | INGLESIDE | 37.734508514404 | -122.448432922363 | POINT (-122.44843292 37.73450851) | Web | 72 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 72 | 8 | 1 | 72 | ||||||||||||||
| 1246 | 1246 | 1246 | 10708134 | 2019-04-09T15:51:00 | 2019-10-22T07:56:54 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1240 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 8 | Mission Terrace | INGLESIDE | 37.730506896973 | -122.43194580078101 | POINT (-122.4319458 37.7305069) | Phone | 94 | 9 | 5 | 28 | 5 | 9 | 4 | 28,861 | 7 | 25 | 25 | 16 | 94 | 5 | 1 | 94 | |||||||||||||
| 1326 | 1326 | 1326 | 11249723 | 2019-08-09T15:02:00 | 2019-10-22T10:49:45 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 111 CHESTNUT ST, SAN FRANCISCO, CA, 94133 | CHESTNUT ST | 3 | Telegraph Hill | CENTRAL | 37.804584503174 | -122.405570983887 | POINT (-122.40557098 37.8045845) | Phone | 18 | 6 | 3 | 23 | 10 | 3 | 1 | 28,860 | 1 | 23 | 23 | 18 | 3 | 1 | 18 | ||||||||||||||
| 1329 | 1329 | 1329 | 11281111 | 2019-08-16T13:26:00 | 2019-10-22T14:44:19 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 128 STANYAN BLVD, SAN FRANCISCO, CA, 94118 | STANYAN BLVD | 1 | Lone Mountain | PARK | 37.779289245605 | -122.455360412598 | POINT (-122.45536041 37.77928925) | Phone | 12 | 7 | 4 | 18 | 2 | 15 | 9 | 54 | 6 | 16 | 16 | 12 | 4 | 1 | 12 | ||||||||||||||
| 1343 | 1343 | 1343 | 11368089 | 2019-09-04T12:29:00 | 2019-10-22T22:10:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 1985 ELLIS ST, SAN FRANCISCO, CA, 94115 | ELLIS ST | 5 | Western Addition | NORTHERN | 37.781436920166 | -122.43878173828101 | POINT (-122.43878174 37.78143692) | Phone | 97 | 4 | 11 | 39 | 11 | 15 | 8 | 29,490 | 5 | 41 | 41 | 97 | 11 | 2 | 97 | ||||||||||||||
| 1568 | 1568 | 1568 | 11304398 | 2019-08-21T15:07:00 | 2019-10-11T15:58:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 154 NEWMAN ST, SAN FRANCISCO, CA, 94110 | NEWMAN ST | 9 | Holly Park | INGLESIDE | 37.737617492676 | -122.417091369629 | POINT (-122.41709137 37.73761749) | Phone | 61 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 61 | 2 | 1 | 61 | ||||||||||||||
| 1700 | 1700 | 1700 | 10924592 | 2019-05-29T12:33:00 | 2019-06-10T15:46:10 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 713 SHRADER ST, SAN FRANCISCO, CA, 94117 | SHRADER ST | 5 | Cole Valley | PARK | 37.768146514893 | -122.45178985595699 | POINT (-122.45178986 37.76814651) | Phone | 29 | 7 | 11 | 3 | 11 | 15 | 8 | 29,492 | 5 | 9 | 9 | 29 | 11 | 1 | 29 | ||||||||||||||
| 2092 | 2092 | 2092 | 11486922 | 2019-09-30T16:42:00 | 2019-10-07T07:43:27 | Open 1 | sent | RPD TMA Queue 6 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 233 MELROSE AVE, SAN FRANCISCO, CA, 94127 | MELROSE AVE | 7 | Sunnyside | INGLESIDE | 37.733641666667 | -122.447616666667 | POINT (-122.44761667 37.73364167) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11486922/photos | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | |||||||||||||
| 3744 | 3744 | 3744 | 11583314 | 2019-10-22T05:06:00 | 2019-10-22T05:40:41 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2542 JUDAH ST, SAN FRANCISCO, CA, 94122 | JUDAH ST | 4 | Outer Sunset | TARAVAL | 37.761207756875 | -122.489307675015 | POINT (-122.48930768 37.76120776) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11583314/photos | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | |||||||||||||
| 3798 | 3798 | 3798 | 11514506 | 2019-10-07T00:22:48 | 2019-10-07T00:30:15 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 112 MONTCALM ST, SAN FRANCISCO, CA, 94110 | MONTCALM ST | 9 | Peralta Heights | INGLESIDE | 37.746482 | -122.4071608 | POINT (-122.4071608 37.746482) | Web | 60 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 60 | 2 | 1 | 60 | ||||||||||||||
| 4071 | 4071 | 4071 | 11583551 | 2019-10-22T07:30:00 | 2019-10-22T08:00:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 655 STOCKTON ST, SAN FRANCISCO, CA, 94108 | STOCKTON ST | 3 | Nob Hill | CENTRAL | 37.792074269058 | -122.40760890840099 | POINT (-122.40760891 37.79207427) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11583551/photos | 16 | 6 | 3 | 21 | 10 | 5 | 1 | 28,857 | 1 | 21 | 21 | 16 | 3 | 1 | 16 | |||||||||||||
| 4309 | 4309 | 4309 | 11515675 | 2019-10-07T09:14:00 | 2019-10-07T10:00:39 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 3274 26TH ST, SAN FRANCISCO, CA, 94110 | 26TH ST | 9 | Mission | MISSION | 37.749320983887 | -122.41564178466801 | POINT (-122.41564178 37.74932098) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 4677 | 4677 | 4677 | 11516785 | 2019-10-07T11:32:22 | 2019-10-07T12:15:18 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Intersection of I-280 N OFF RAMP and SAN JOSE AVE | I-280 N OFF RAMP | 8 | St. Mary's Park | INGLESIDE | 37.733584 | -122.43149 | POINT (-122.43149 37.733584) | Mobile/Open311 | 93 | 9 | 5 | 28 | 5 | 2 | 4 | 28,861 | 7 | 25 | 25 | 93 | 5 | 1 | 93 | ||||||||||||||
| 4680 | 4680 | 4680 | 11516786 | 2019-10-07T11:32:33 | 2019-10-29T18:35:58 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of LAWTON ST and 7TH AVE | LAWTON ST | 7 | Inner Sunset | PARK | 37.758573331463 | -122.463848559636 | POINT (-122.46384856 37.75857333) | Mobile/Open311 | 109 | 7 | 8 | 14 | 4 | 1 | 8 | 56 | 5 | 12 | 12 | 109 | 8 | 1 | 109 | ||||||||||||||
| 4789 | 4789 | 4789 | 11517195 | 2019-10-07T12:18:00 | 2019-10-07T12:30:21 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 238 MUNICH ST, SAN FRANCISCO, CA, 94112 | MUNICH ST | 11 | Excelsior | INGLESIDE | 37.721866607666 | -122.426239013672 | POINT (-122.42623901 37.72186661) | Phone | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 2 | 90 | ||||||||||||||
| 4857 | 4857 | 4857 | 11517473 | 2019-10-07T12:57:00 | 2019-10-07T14:00:45 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 1948 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Cayuga | INGLESIDE | 37.721126556396 | -122.439163208008 | POINT (-122.43916321 37.72112656) | Phone | 80 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 80 | 1 | 2 | 80 | ||||||||||||||
| 4961 | 4961 | 4961 | 11517758 | 2019-10-07T13:33:17 | 2019-10-07T13:40:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1319 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 | SAN BRUNO AVE | 10 | Potrero Hill | MISSION | 37.752827 | -122.4042 | POINT (-122.4042 37.752827) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11517758/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
| 4965 | 4965 | 4965 | 11517764 | 2019-10-07T13:34:07 | 2019-10-07T13:40:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1364 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 | SAN BRUNO AVE | 10 | Potrero Hill | MISSION | 37.752295000000004 | -122.404435 | POINT (-122.404435 37.752295) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11517764/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
| 4980 | 4980 | 4980 | 11517833 | 2019-10-07T13:44:00 | 2019-10-21T15:31:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1750 SACRAMENTO ST, SAN FRANCISCO, CA, 94109 | SACRAMENTO ST | 3 | Polk Gulch | NORTHERN | 37.791500091553004 | -122.42172241210899 | POINT (-122.42172241 37.79150009) | Phone | 105 | 4 | 3 | 21 | 10 | 13 | 6 | 28,858 | 9 | 21 | 21 | 105 | 3 | 1 | 105 | ||||||||||||||
| 5093 | 5093 | 5093 | 11584425 | 2019-10-22T09:31:00 | 2019-10-22T09:40:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 1528 HAMPSHIRE ST, SAN FRANCISCO, CA, 94110 | HAMPSHIRE ST | 9 | Peralta Heights | INGLESIDE | 37.748329162598 | -122.406639099121 | POINT (-122.4066391 37.74832916) | Phone | 60 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 60 | 2 | 1 | 60 | ||||||||||||||
| 5155 | 5155 | 5155 | 11518419 | 2019-10-07T15:09:00 | 2019-10-07T16:00:35 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 1370 GUERRERO ST, SAN FRANCISCO, CA, 94110 | GUERRERO ST | 8 | Dolores Heights | MISSION | 37.749153137206996 | -122.42276763916 | POINT (-122.42276764 37.74915314) | Phone | 52 | 3 | 5 | 20 | 5 | 2 | 7 | 28,859 | 4 | 19 | 19 | 52 | 5 | 1 | 52 | ||||||||||||||
| 5175 | 5175 | 5175 | 11584535 | 2019-10-22T09:48:01 | 2019-10-22T09:55:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of 24TH ST and MASSACHUSETTS ST | 24TH ST | 10 | Central Waterfront | BAYVIEW | 37.755224363277 | -122.381316852064 | POINT (-122.38131685 37.75522436) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11584535/photos | 56 | 2 | 9 | 26 | 8 | 3 | 28,856 | 3 | 29 | 29 | 56 | 9 | 1 | 56 | ||||||||||||||
| 5221 | 5221 | 5221 | 11518643 | 2019-10-07T15:38:00 | 2019-10-07T15:50:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 224 HARVARD ST, SAN FRANCISCO, CA, 94134 | HARVARD ST | 9 | University Mound | INGLESIDE | 37.726715087891 | -122.420829772949 | POINT (-122.42082977 37.72671509) | Phone | 92 | 9 | 2 | 7 | 7 | 9 | 4 | 309 | 7 | 5 | 5 | 92 | 2 | 2 | 92 | ||||||||||||||
| 5234 | 5234 | 5234 | 11584627 | 2019-10-22T10:04:00 | 2019-10-22T11:15:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 785 BRANNAN ST, SAN FRANCISCO, CA, 94103 | BRANNAN ST | 6 | South of Market | SOUTHERN | 37.77318572998 | -122.402534484863 | POINT (-122.40253448 37.77318573) | Phone | 32 | 1 | 10 | 34 | 9 | 14 | 2 | 28,853 | 2 | 34 | 34 | 32 | 10 | 2 | 32 | ||||||||||||||
| 5288 | 5288 | 5288 | 11518880 | 2019-10-07T16:15:00 | 2019-10-20T12:04:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 3458 26TH ST, SAN FRANCISCO, CA, 94110 | 26TH ST | 9 | Mission | MISSION | 37.749080657959 | -122.419692993164 | POINT (-122.41969299 37.74908066) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 5307 | 5307 | 5307 | 11584772 | 2019-10-22T10:27:00 | 2019-10-22T10:39:52 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 3098 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 | CALIFORNIA ST | 2 | Pacific Heights | RICHMOND | 37.787593841553004 | -122.44519805908199 | POINT (-122.44519806 37.78759384) | Phone | 102 | 8 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 102 | 6 | 1 | 102 | ||||||||||||||
| 5384 | 5384 | 5384 | 11585037 | 2019-10-22T11:06:00 | 2019-10-22T12:10:42 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Sprinkler_system_issues | Intersection of SUNSET BLVD and MORAGA ST | SUNSET BLVD | 4 | Outer Sunset | TARAVAL | 37.755275726318004 | -122.495361328125 | POINT (-122.49536133 37.75527573) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 5392 | 5392 | 5392 | 11519264 | 2019-10-07T17:24:00 | 2019-10-07T17:35:16 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 1254 41ST AVE, SAN FRANCISCO, CA, 94122 | 41ST AVE | 4 | Outer Sunset | TARAVAL | 37.763362884521 | -122.500595092773 | POINT (-122.50059509 37.76336288) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 5455 | 5455 | 5455 | 11585234 | 2019-10-22T11:37:00 | 2019-10-22T11:45:56 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 51 MARNE AVE, SAN FRANCISCO, CA, 94127 | MARNE AVE | 7 | Sherwood Forest | INGLESIDE | 37.739490509033 | -122.45892333984399 | POINT (-122.45892334 37.73949051) | Phone | 117 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 117 | 8 | 1 | 117 | ||||||||||||||
| 5501 | 5501 | 5501 | 11585356 | 2019-10-22T11:53:04 | 2019-10-22T13:00:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2600 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 | SACRAMENTO ST | 2 | Pacific Heights | NORTHERN | 37.789680343652 | -122.435752728243 | POINT (-122.43575273 37.78968034) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11585356/photos | 102 | 4 | 6 | 30 | 1 | 13 | 6 | 29,490 | 9 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
| 5504 | 5504 | 5504 | 11585373 | 2019-10-22T11:55:00 | 2019-10-22T15:08:32 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2603 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 | SACRAMENTO ST | 2 | Pacific Heights | NORTHERN | 37.789539033009994 | -122.435863326343 | POINT (-122.43586333 37.78953903) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11585373/photos | 102 | 4 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
| 5563 | 5563 | 5563 | 11519734 | 2019-10-07T19:18:00 | 2019-10-23T11:17:30 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 1419 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Mission Terrace | INGLESIDE | 37.729068299999994 | -122.43395670000001 | POINT (-122.4339567 37.7290683) | Web | http://mobile311.sfgov.org/reports/11519734/photos | 94 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 94 | 1 | 1 | 94 | |||||||||||||
| 5610 | 5610 | 5610 | 11585580 | 2019-10-22T12:28:00 | 2019-10-22T12:35:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Intersection of BAY ST and DIVISADERO ST | BAY ST | 2 | Marina | NORTHERN | 37.801837921143 | -122.443222045898 | POINT (-122.44322205 37.80183792) | Phone | 17 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 17 | 6 | 1 | 17 | ||||||||||||||
| 5611 | 5611 | 5611 | 11519949 | 2019-10-07T20:52:32 | 2019-10-07T21:00:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 384 ALLISON ST, SAN FRANCISCO, CA, 94112 | ALLISON ST | 11 | Crocker Amazon | INGLESIDE | 37.710160242440004 | -122.440802441367 | POINT (-122.44080244 37.71016024) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11519949/photos | 58 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 58 | 1 | 2 | 58 | |||||||||||||
| 5773 | 5773 | 5773 | 11586288 | 2019-10-22T14:09:00 | 2019-10-22T14:20:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2755 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 | SAN BRUNO AVE | 9 | Portola | BAYVIEW | 37.726974487305 | -122.403160095215 | POINT (-122.4031601 37.72697449) | Phone | 91 | 2 | 2 | 25 | 7 | 10 | 3 | 309 | 3 | 28 | 28 | 91 | 2 | 4 | 2 | 91 | |||||||||||||
| 5826 | 5826 | 5826 | 11586668 | 2019-10-22T15:11:41 | 2019-10-22T15:55:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 1930 15TH ST, SAN FRANCISCO, CA, 94114 | 15TH ST | 8 | Mission Dolores | MISSION | 37.766420700000005 | -122.4271957 | POINT (-122.4271957 37.7664207) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11586668/photos | 37 | 3 | 5 | 5 | 5 | 8 | 7 | 28,862 | 4 | 3 | 3 | 37 | 5 | 1 | 5 | 37 | ||||||||||||
| 6146 | 6146 | 6146 | 11525260 | 2019-10-08T21:43:00 | 2019-10-09T00:38:14 | Open 1 | sent | DPH - Other - G 7 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 3310 19TH ST, SAN FRANCISCO, CA, 94110 | 19TH ST | 9 | Mission | MISSION | 37.760490399999995 | -122.4173226 | POINT (-122.4173226 37.7604904) | Web | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 13 | 53 | 2 | 15 | 3 | 15 | 2 | 3 | 53 | |||||||||
| 6265 | 6265 | 6265 | 11528031 | 2019-10-09T13:43:00 | 2019-10-09T13:50:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 2145 KEITH ST, SAN FRANCISCO, CA, 94124 | KEITH ST | 10 | Bayview | BAYVIEW | 37.727615356445 | -122.390800476074 | POINT (-122.39080048 37.72761536) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 6488 | 6488 | 6488 | 11602298 | 2019-10-25T16:12:00 | 2019-10-25T16:40:50 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 617 MORSE ST, SAN FRANCISCO, CA, 94112 | MORSE ST | 11 | Crocker Amazon | INGLESIDE | 37.711486816406 | -122.444496154785 | POINT (-122.44449615 37.71148682) | Phone | 58 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 58 | 1 | 2 | 58 | ||||||||||||||
| 6738 | 6738 | 6738 | 11538643 | 2019-10-11T16:13:00 | 2019-10-15T07:50:30 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of OFARRELL ST and DIVISADERO ST | OFARRELL ST | 5 | Western Addition | NORTHERN | 37.782451629639 | -122.43930053710899 | POINT (-122.43930054 37.78245163) | Phone | 97 | 4 | 11 | 39 | 11 | 15 | 8 | 29,490 | 5 | 41 | 41 | 97 | 11 | 2 | 97 | ||||||||||||||
| 6823 | 6823 | 6823 | 11611574 | 2019-10-28T09:41:00 | 2019-10-28T09:50:07 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 120 TOPEKA AVE, SAN FRANCISCO, CA, 94124 | TOPEKA AVE | 10 | Silver Terrace | BAYVIEW | 37.733722686768 | -122.399070739746 | POINT (-122.39907074 37.73372269) | Phone | 87 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 87 | 9 | 2 | 87 | ||||||||||||||
| 6921 | 6921 | 6921 | 11613807 | 2019-10-28T15:17:00 | 2019-10-29T10:20:34 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | 2140 LAKE ST, SAN FRANCISCO, CA, 94121 | LAKE ST | 2 | Lake Street | RICHMOND | 37.785984039306996 | -122.48260498046899 | POINT (-122.48260498 37.78598404) | Phone | 2 | 8 | 6 | 33 | 1 | 11 | 9 | 55 | 6 | 33 | 33 | 2 | 6 | 1 | 2 | ||||||||||||||
| 6924 | 6924 | 6924 | 11613883 | 2019-10-28T15:27:00 | 2019-10-28T16:00:20 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Remove_garden_debris | Intersection of CESAR CHAVEZ ST and FLORIDA ST | CESAR CHAVEZ ST | 9 | Peralta Heights | MISSION | 37.748332977295 | -122.40964508056601 | POINT (-122.40964508 37.74833298) | Phone | 60 | 3 | 2 | 2 | 7 | 2 | 7 | 28,859 | 4 | 2 | 2 | 60 | 2 | 3 | 1 | 3 | 60 | ||||||||||||
| 7055 | 7055 | 7055 | 11620909 | 2019-10-30T08:01:00 | 2019-10-30T08:30:13 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 4800 CALIFORNIA ST, SAN FRANCISCO, CA, 94118 | CALIFORNIA ST | 1 | Inner Richmond | RICHMOND | 37.784736633301 | -122.469024658203 | POINT (-122.46902466 37.78473663) | Phone | 5 | 8 | 4 | 11 | 2 | 11 | 9 | 54 | 6 | 11 | 11 | 5 | 4 | 1 | 5 | ||||||||||||||
| 7137 | 7137 | 7137 | 11617465 | 2019-10-29T11:43:00 | 2019-10-29T11:50:12 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Intersection of LYON ST and BUSH ST | LYON ST | 2 | Lower Pacific Heights | RICHMOND | 37.785549163818004 | -122.445022583008 | POINT (-122.44502258 37.78554916) | Phone | 103 | 8 | 6 | 31 | 1 | 15 | 9 | 29,490 | 6 | 31 | 31 | 103 | 6 | 1 | 103 | ||||||||||||||
| 7244 | 7244 | 7244 | 9876964 | 2018-12-01T13:39:00 | 2018-12-01T14:45:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of CARRIE ST and CHENERY ST | CARRIE ST | 8 | Glen Park | INGLESIDE | 37.734539031982 | -122.432647705078 | POINT (-122.43264771 37.73453903) | Phone | 96 | 9 | 5 | 10 | 5 | 2 | 4 | 63 | 7 | 7 | 7 | 15 | 96 | 5 | 17 | 17 | 1 | 96 | |||||||||||
| 7408 | 7408 | 7408 | 11523120 | 2019-10-08T13:14:43 | 2019-10-08T13:20:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 650 CHURCH ST, SAN FRANCISCO, CA, 94114 | CHURCH ST | 8 | Dolores Heights | MISSION | 37.7603512 | -122.4285305 | POINT (-122.4285305 37.7603512) | Web | 52 | 3 | 5 | 5 | 5 | 2 | 7 | 28,862 | 4 | 3 | 3 | 52 | 5 | 1 | 5 | 52 | |||||||||||||
| 7610 | 7610 | 7610 | 11627033 | 2019-10-31T13:04:00 | 2019-10-31T13:30:12 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 243 GRAFTON AVE, SAN FRANCISCO, CA, 94112 | GRAFTON AVE | 11 | Ingleside | TARAVAL | 37.719921112061 | -122.455879211426 | POINT (-122.45587921 37.71992111) | Phone | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
| 7732 | 7732 | 7732 | 11554557 | 2019-10-15T14:58:00 | 2019-10-15T15:05:29 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 2687 SAN JOSE AVE, SAN FRANCISCO, CA, 94112 | SAN JOSE AVE | 11 | Oceanview | TARAVAL | 37.714569091796996 | -122.451499938965 | POINT (-122.45149994 37.71456909) | Phone | 81 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 81 | 1 | 2 | 81 | ||||||||||||||
| 7798 | 7798 | 7798 | 11624131 | 2019-10-30T18:01:00 | 2019-10-30T18:15:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 459 VICTORIA ST, SAN FRANCISCO, CA, 94132 | VICTORIA ST | 11 | Ingleside | TARAVAL | 37.7189803 | -122.46557649999998 | POINT (-122.4655765 37.7189803) | Web | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 64 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
| 7884 | 7884 | 7884 | 9137778 | 2018-06-14T15:03:00 | 2019-10-07T11:22:00 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 262 SOMERSET ST, SAN FRANCISCO, CA, 94134 | SOMERSET ST | 9 | Portola | BAYVIEW | 37.728214263916 | -122.408348083496 | POINT (-122.40834808 37.72821426) | Phone | 91 | 2 | 2 | 25 | 7 | 10 | 3 | 309 | 3 | 28 | 28 | 91 | 2 | 2 | 91 | ||||||||||||||
| 7888 | 7888 | 7888 | 9813428 | 2018-11-15T14:11:00 | 2019-10-07T08:34:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 271 21ST AVE, SAN FRANCISCO, CA, 94121 | 21ST AVE | 1 | Outer Richmond | RICHMOND | 37.782760620117 | -122.48080444335899 | POINT (-122.48080444 37.78276062) | Phone | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 2 | 8 | ||||||||||||||
| 8114 | 8114 | 8114 | 10995190 | 2019-06-14T08:48:00 | 2019-10-08T15:55:19 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Intersection of RHINE ST and DE LONG ST | RHINE ST | 11 | Outer Mission | TARAVAL | 37.709674835205 | -122.460609436035 | POINT (-122.46060944 37.70967484) | Phone | 66 | 10 | 1 | 28 | 6 | 9 | 5 | 28,861 | 8 | 25 | 25 | 66 | 1 | 2 | 66 | ||||||||||||||
| 8199 | 8199 | 8199 | 11110966 | 2019-07-10T15:57:00 | 2019-10-16T08:23:08 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 1031 KEY AVE, SAN FRANCISCO, CA, 94124 | KEY AVE | 10 | Bret Harte | BAYVIEW | 37.719181060791 | -122.396774291992 | POINT (-122.39677429 37.71918106) | Phone | 88 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 88 | 9 | 1 | 88 | ||||||||||||||
| 8224 | 8224 | 8224 | 11622531 | 2019-10-30T12:14:01 | 2019-10-30T12:20:07 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 229 8TH ST, SAN FRANCISCO, CA, 94103 | 8TH ST | 6 | South of Market | SOUTHERN | 37.77590386573 | -122.41107587714 | POINT (-122.41107588 37.77590387) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11622531/photos | 32 | 1 | 10 | 34 | 9 | 8 | 2 | 28,853 | 2 | 34 | 34 | 24 | 32 | 1 | 10 | 6 | 1 | 6 | 2 | 1 | 32 | |||||||
| 8231 | 8231 | 8231 | 11274433 | 2019-08-15T08:48:00 | 2019-10-08T17:37:37 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 2385 BRYANT ST, SAN FRANCISCO, CA, 94110 | BRYANT ST | 9 | Mission | MISSION | 37.756290435791 | -122.409278869629 | POINT (-122.40927887 37.75629044) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 8267 | 8267 | 8267 | 11367641 | 2019-09-04T11:24:58 | 2019-10-08T13:10:19 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 2520 SUTTER ST, SAN FRANCISCO, CA, 94115 | SUTTER ST | 2 | Lower Pacific Heights | RICHMOND | 37.7851819 | -122.44203359999999 | POINT (-122.4420336 37.7851819) | Web | 103 | 8 | 6 | 30 | 1 | 15 | 9 | 29,490 | 6 | 27 | 27 | 103 | 6 | 1 | 103 | ||||||||||||||
| 8300 | 8300 | 8300 | 11386228 | 2019-09-08T14:42:00 | 2019-10-10T08:15:25 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 427 18TH AVE, SAN FRANCISCO, CA, 94121 | 18TH AVE | 1 | Inner Richmond | RICHMOND | 37.779819488525 | -122.477333068848 | POINT (-122.47733307 37.77981949) | Phone | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 5 | 4 | 1 | 5 | ||||||||||||||
| 8305 | 8305 | 8305 | 11394197 | 2019-09-10T08:28:00 | 2019-10-09T06:10:24 | Open 1 | accepted | DPW BSM Queue 3 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Intersection of MIDDLE POINT RD and INNES AVE | MIDDLE POINT RD | 10 | Hunters Point | BAYVIEW | 37.734081268311 | -122.379432678223 | POINT (-122.37943268 37.73408127) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 8309 | 8309 | 8309 | 11400751 | 2019-09-11T11:30:00 | 2019-10-08T17:05:18 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Intersection of WHITNEY YOUNG CIR and HUDSON AVE | WHITNEY YOUNG CIR | 10 | Bayview | BAYVIEW | 37.733631134033 | -122.382278442383 | POINT (-122.38227844 37.73363113) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 8405 | 8405 | 8405 | 11013873 | 2019-06-18T14:50:00 | 2019-10-30T14:55:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 461 GOLD MINE DR, SAN FRANCISCO, CA, 94131 | GOLD MINE DR | 8 | Diamond Heights | INGLESIDE | 37.739784240723 | -122.436805725098 | POINT (-122.43680573 37.73978424) | Phone | 57 | 9 | 5 | 10 | 5 | 2 | 4 | 63 | 7 | 7 | 7 | 57 | 5 | 1 | 57 | ||||||||||||||
| 8439 | 8439 | 8439 | 11265998 | 2019-08-13T12:16:00 | 2019-10-23T09:35:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Sewer_damage_tree_roots | 1422 DOLORES ST, SAN FRANCISCO, CA, 94110 | DOLORES ST | 8 | Noe Valley | INGLESIDE | 37.746639251709 | -122.424911499023 | POINT (-122.4249115 37.74663925) | Phone | 84 | 9 | 5 | 22 | 5 | 2 | 4 | 63 | 7 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
| 8481 | 8481 | 8481 | 11482122 | 2019-09-29T17:30:00 | 2019-10-08T12:08:05 | Open 1 | accepted | DPW - Bureau of Urban Forestry - G 8 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 1590 7TH AVE, SAN FRANCISCO, CA, 94122 | 7TH AVE | 7 | Inner Sunset | PARK | 37.758645 | -122.463653333333 | POINT (-122.46365333 37.758645) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11482122/photos | 109 | 7 | 8 | 14 | 4 | 1 | 8 | 56 | 5 | 12 | 12 | 109 | 8 | 1 | 109 | |||||||||||||
| 10623 | 10623 | 10623 | 11520818 | 2019-10-08T07:55:08 | 2019-10-08T08:00:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1398 BRYANT ST, SAN FRANCISCO, CA, 94103 | BRYANT ST | 9 | Mission | MISSION | 37.768611666667 | -122.41082 | POINT (-122.41082 37.76861167) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11520818/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,853 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | |||||||||||
| 10802 | 10802 | 10802 | 11521237 | 2019-10-08T08:53:00 | 2019-10-08T09:00:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 2006 22ND ST, SAN FRANCISCO, CA, 94107 | 22ND ST | 10 | Potrero Hill | BAYVIEW | 37.757263183594 | -122.401321411133 | POINT (-122.40132141 37.75726318) | Phone | 54 | 2 | 9 | 26 | 8 | 10 | 3 | 28,856 | 3 | 29 | 29 | 54 | 9 | 1 | 54 | ||||||||||||||
| 11027 | 11027 | 11027 | 11521878 | 2019-10-08T10:19:00 | 2019-10-08T11:30:25 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 697 HYDE ST, SAN FRANCISCO, CA, 94109 | HYDE ST | 6 | Lower Nob Hill | CENTRAL | 37.787034999999996 | -122.41680600000001 | POINT (-122.416806 37.787035) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11521878/photos | 50 | 6 | 10 | 36 | 9 | 13 | 1 | 28,858 | 1 | 36 | 36 | 50 | 10 | 2 | 50 | |||||||||||||
| 11092 | 11092 | 11092 | 11522140 | 2019-10-08T10:56:00 | 2019-10-08T12:07:53 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 282 2ND ST, SAN FRANCISCO, CA, 94105 | 2ND ST | 6 | South of Market | SOUTHERN | 37.785542 | -122.3971267 | POINT (-122.3971267 37.785542) | Web | 32 | 1 | 10 | 8 | 9 | 6 | 2 | 28,855 | 2 | 6 | 6 | 32 | 10 | 4 | 1 | 32 | |||||||||||||
| 11125 | 11125 | 11125 | 11522242 | 2019-10-08T11:12:34 | 2019-10-08T12:50:21 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Intersection of GENEVA AVE and MISSION ST | GENEVA AVE | 11 | Crocker Amazon | INGLESIDE | 37.716461181641 | -122.441017150879 | POINT (-122.44101715 37.71646118) | Integrated Agency | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 4 | 90 | 1 | 4 | 4 | 2 | 90 | |||||||||||
| 11180 | 11180 | 11180 | 11522481 | 2019-10-08T11:40:10 | 2019-10-08T11:45:21 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1210 GRIFFITH ST, SAN FRANCISCO, CA, 94124 | GRIFFITH ST | 10 | Hunters Point | BAYVIEW | 37.727652 | -122.37983100000001 | POINT (-122.379831 37.727652) | Mobile/Open311 | 78 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 78 | 9 | 2 | 78 | ||||||||||||||
| 11315 | 11315 | 11315 | 11523007 | 2019-10-08T12:59:00 | 2019-10-08T13:10:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1312 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 | LEAVENWORTH ST | 3 | Nob Hill | CENTRAL | 37.793212890625 | -122.41595458984399 | POINT (-122.41595459 37.79321289) | Phone | 16 | 6 | 3 | 21 | 10 | 5 | 1 | 28,858 | 1 | 21 | 21 | 16 | 3 | 1 | 16 | ||||||||||||||
| 11363 | 11363 | 11363 | 11523150 | 2019-10-08T13:18:52 | 2019-10-08T13:25:19 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 855 MONTEREY BLVD, SAN FRANCISCO, CA, 94127 | MONTEREY BLVD | 7 | Westwood Park | INGLESIDE | 37.7312708 | -122.4550172 | POINT (-122.4550172 37.7312708) | Web | 71 | 9 | 8 | 41 | 4 | 9 | 4 | 28,861 | 7 | 40 | 40 | 71 | 8 | 1 | 71 | ||||||||||||||
| 11485 | 11485 | 11485 | 11523644 | 2019-10-08T14:39:00 | 2019-10-30T12:20:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Other_enter_additional_details_below | 4042 17TH ST, SAN FRANCISCO, CA, 94114 | 17TH ST | 8 | Corona Heights | MISSION | 37.762554168701 | -122.43621826171899 | POINT (-122.43621826 37.76255417) | Phone | 113 | 7 | 5 | 5 | 5 | 15 | 8 | 28,862 | 5 | 3 | 3 | 113 | 5 | 1 | 113 | ||||||||||||||
| 11527 | 11527 | 11527 | 11523858 | 2019-10-08T15:18:00 | 2019-10-08T16:06:54 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_signs | 700 EDDY ST, SAN FRANCISCO, CA, 94109 | EDDY ST | 6 | Tenderloin | NORTHERN | 37.783176422119006 | -122.419464111328 | POINT (-122.41946411 37.78317642) | Phone | 20 | 4 | 10 | 36 | 9 | 7 | 6 | 28,858 | 9 | 36 | 36 | 20 | 1 | 10 | 16 | 1 | 2 | 1 | 20 | ||||||||||
| 11955 | 11955 | 11955 | 11525199 | 2019-10-08T21:09:00 | 2019-10-08T21:25:21 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of WEBSTER ST and BUSH ST | WEBSTER ST | 5 | Japantown | NORTHERN | 37.787231445313 | -122.431816101074 | POINT (-122.4318161 37.78723145) | Phone | 101 | 4 | 11 | 30 | 11 | 13 | 6 | 29,490 | 9 | 27 | 27 | 101 | 11 | 1 | 101 | ||||||||||||||
| 12116 | 12116 | 12116 | 11588776 | 2019-10-23T08:01:00 | 2019-10-23T08:30:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Intersection of LYON ST and FILBERT ST | LYON ST | 2 | Cow Hollow | NORTHERN | 37.796577453613 | -122.44701385498001 | POINT (-122.44701385 37.79657745) | Phone | 14 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 14 | 6 | 1 | 14 | ||||||||||||||
| 12236 | 12236 | 12236 | 11589179 | 2019-10-23T08:46:00 | 2019-10-23T09:30:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 88 NORTON ST, SAN FRANCISCO, CA, 94112 | NORTON ST | 11 | Mission Terrace | INGLESIDE | 37.725399017334 | -122.43637084960899 | POINT (-122.43637085 37.72539902) | Phone | 94 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 94 | 1 | 1 | 94 | ||||||||||||||
| 12237 | 12237 | 12237 | 11589182 | 2019-10-23T08:46:00 | 2019-10-23T08:55:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | Intersection of HAYES ST and GOUGH ST | HAYES ST | 5 | Hayes Valley | NORTHERN | 37.776882171630994 | -122.42298126220699 | POINT (-122.42298126 37.77688217) | Phone | 22 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 22 | 1 | 11 | 1 | 8 | 1 | 1 | 22 | ||||||||||
| 12245 | 12245 | 12245 | 11589271 | 2019-10-23T08:54:08 | 2019-10-23T09:00:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 726 POTRERO AVE, SAN FRANCISCO, CA, 94110 | POTRERO AVE | 10 | Mission | MISSION | 37.760296666666996 | -122.406921666667 | POINT (-122.40692167 37.76029667) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11589271/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 54 | 9 | 3 | 2 | 3 | 54 | |||||||||||
| 12412 | 12412 | 12412 | 11590046 | 2019-10-23T10:11:23 | 2019-10-23T10:20:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1201 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Mission Terrace | INGLESIDE | 37.730521666667 | -122.43103833333299 | POINT (-122.43103833 37.73052167) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11590046/photos | 94 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 16 | 94 | 1 | 1 | 94 | ||||||||||||
| 12449 | 12449 | 12449 | 11590331 | 2019-10-23T10:37:00 | 2019-10-23T11:40:54 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 26 BRIGHTON AVE, SAN FRANCISCO, CA, 94112 | BRIGHTON AVE | 11 | Ingleside | TARAVAL | 37.7187615 | -122.45488449999999 | POINT (-122.4548845 37.7187615) | Web | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
| 12619 | 12619 | 12619 | 11591402 | 2019-10-23T13:05:00 | 2019-10-23T13:15:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 345 PRENTISS ST, SAN FRANCISCO, CA, 94110 | PRENTISS ST | 9 | Bernal Heights | INGLESIDE | 37.739032745361 | -122.41194152831999 | POINT (-122.41194153 37.73903275) | Phone | 83 | 9 | 2 | 2 | 7 | 10 | 4 | 28,859 | 7 | 2 | 2 | 83 | 2 | 1 | 83 | ||||||||||||||
| 12639 | 12639 | 12639 | 11591509 | 2019-10-23T13:22:00 | 2019-10-23T15:05:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 1296 CHURCH ST, SAN FRANCISCO, CA, 94114 | CHURCH ST | 8 | Noe Valley | MISSION | 37.750166896766 | -122.427412206421 | POINT (-122.42741221 37.7501669) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11591509/photos | 84 | 3 | 5 | 22 | 5 | 2 | 7 | 28,862 | 4 | 22 | 22 | 84 | 5 | 1 | 84 | |||||||||||||
| 12697 | 12697 | 12697 | 11591922 | 2019-10-23T14:26:00 | 2019-10-23T14:35:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Backfill_tree_basin | 1245 30TH AVE, SAN FRANCISCO, CA, 94122 | 30TH AVE | 4 | Outer Sunset | TARAVAL | 37.764011383056996 | -122.489112854004 | POINT (-122.48911285 37.76401138) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 12754 | 12754 | 12754 | 11592221 | 2019-10-23T15:20:00 | 2019-10-23T15:40:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 393 SILVER AVE, SAN FRANCISCO, CA, 94112 | SILVER AVE | 11 | Mission Terrace | INGLESIDE | 37.728637695313 | -122.428421020508 | POINT (-122.42842102 37.7286377) | Phone | 94 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 16 | 94 | 1 | 2 | 94 | |||||||||||||
| 12768 | 12768 | 12768 | 11592319 | 2019-10-23T15:39:00 | 2019-10-23T15:45:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 342 LONDON ST, SAN FRANCISCO, CA, 94112 | LONDON ST | 11 | Excelsior | INGLESIDE | 37.723693847656 | -122.43466186523399 | POINT (-122.43466187 37.72369385) | Phone | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 4 | 2 | 90 | |||||||||||||
| 12880 | 12880 | 12880 | 11592792 | 2019-10-23T16:59:35 | 2019-10-23T17:05:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2359 18TH AVE, SAN FRANCISCO, CA, 94116 | 18TH AVE | 7 | Golden Gate Heights | TARAVAL | 37.743854999999996 | -122.474725 | POINT (-122.474725 37.743855) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11592792/photos | 44 | 10 | 8 | 41 | 4 | 1 | 5 | 29,491 | 8 | 40 | 40 | 44 | 8 | 1 | 44 | |||||||||||||
| 13122 | 13122 | 13122 | 11596081 | 2019-10-24T12:26:00 | 2019-10-31T12:30:10 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 375 TEXAS ST, SAN FRANCISCO, CA, 94107 | TEXAS ST | 10 | Potrero Hill | BAYVIEW | 37.761707305908 | -122.395294189453 | POINT (-122.39529419 37.76170731) | Phone | 54 | 2 | 9 | 26 | 8 | 10 | 3 | 28,856 | 3 | 29 | 29 | 54 | 9 | 1 | 54 | ||||||||||||||
| 13167 | 13167 | 13167 | 11531820 | 2019-10-10T10:41:00 | 2019-10-10T10:50:24 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 1540 LA PLAYA, SAN FRANCISCO, CA, 94122 | LA PLAYA | 4 | Outer Sunset | TARAVAL | 37.757659912109 | -122.508758544922 | POINT (-122.50875854 37.75765991) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 13198 | 13198 | 13198 | 11532168 | 2019-10-10T11:35:18 | 2019-10-10T11:40:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 822 BRAZIL AVE, SAN FRANCISCO, CA, 94112 | BRAZIL AVE | 11 | Excelsior | INGLESIDE | 37.721444314758 | -122.42804956954201 | POINT (-122.42804957 37.72144431) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11532168/photos | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 2 | 90 | |||||||||||||
| 13292 | 13292 | 13292 | 11535256 | 2019-10-11T06:13:00 | 2019-10-11T06:20:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1945 GROVE ST, SAN FRANCISCO, CA, 94117 | GROVE ST | 5 | Panhandle | PARK | 37.774444580078004 | -122.448631286621 | POINT (-122.44863129 37.77444458) | Phone | 24 | 7 | 11 | 18 | 11 | 15 | 8 | 29,492 | 5 | 16 | 16 | 24 | 11 | 1 | 24 | ||||||||||||||
| 13417 | 13417 | 13417 | 11604606 | 2019-10-26T10:40:00 | 2019-10-26T11:15:50 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 3062 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Outer Mission | INGLESIDE | 37.710929870605 | -122.454063415527 | POINT (-122.45406342 37.71092987) | Phone | 66 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 66 | 1 | 2 | 66 |
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))