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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40349 | 40349 | 40349 | 11629116 | 2019-10-31T21:05:49 | 2019-10-31T22:37:55 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 110 CAMBRIDGE ST, SAN FRANCISCO, CA, 94134 | CAMBRIDGE ST | 9 | University Mound | BAYVIEW | 37.7308747 | -122.4195279 | POINT (-122.4195279 37.7308747) | Web | http://mobile311.sfgov.org/reports/11629116/photos | 92 | 9 | 2 | 7 | 7 | 9 | 4 | 309 | 7 | 5 | 5 | 92 | 2 | 2 | 92 | |||||||||||||
66666 | 66666 | 66666 | 11483974 | 2019-09-30T09:27:00 | 2019-10-31T22:37:24 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 2314 BRYANT ST, SAN FRANCISCO, CA, 94110 | BRYANT ST | 9 | Mission | MISSION | 37.757095336914 | -122.409706115723 | POINT (-122.40970612 37.75709534) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
40028 | 40028 | 40028 | 11628418 | 2019-10-31T17:19:00 | 2019-10-31T22:37:18 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 910 FOLSOM ST, SAN FRANCISCO, CA, 94103 | FOLSOM ST | 6 | South of Market | SOUTHERN | 37.780159139512 | -122.40373794047501 | POINT (-122.40373794 37.78015914) | Web | http://mobile311.sfgov.org/reports/11628418/photos | 32 | 1 | 10 | 34 | 9 | 14 | 2 | 28,853 | 2 | 34 | 34 | 32 | 1 | 10 | 4 | 2 | 32 | |||||||||||
39894 | 39894 | 39894 | 11628119 | 2019-10-31T16:11:00 | 2019-10-31T22:37:05 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Remove_garden_debris | 1309 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Mission Terrace | INGLESIDE | 37.729553222656 | -122.433395385742 | POINT (-122.43339539 37.72955322) | Phone | 94 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 94 | 1 | 1 | 94 | ||||||||||||||
39835 | 39835 | 39835 | 11627990 | 2019-10-31T15:48:00 | 2019-10-31T22:37:01 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 3901 26TH ST, SAN FRANCISCO, CA, 94131 | 26TH ST | 8 | Noe Valley | MISSION | 37.748363494873 | -122.42736053466801 | POINT (-122.42736053 37.74836349) | Phone | 84 | 3 | 5 | 22 | 5 | 2 | 7 | 63 | 4 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
23153 | 23153 | 23153 | 11022281 | 2019-06-20T10:20:00 | 2019-10-31T22:36:58 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 46 DAY ST, SAN FRANCISCO, CA, 94110 | DAY ST | 8 | Noe Valley | INGLESIDE | 37.743179321289 | -122.423622131348 | POINT (-122.42362213 37.74317932) | Phone | 84 | 9 | 5 | 22 | 5 | 2 | 4 | 28,859 | 7 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
39760 | 39760 | 39760 | 11627774 | 2019-10-31T15:10:18 | 2019-10-31T22:36:55 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1232 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) | OAK ST | 5 | Panhandle | PARK | 37.772904 | -122.439733 | POINT (-122.439733 37.772904) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11627774/photos | 24 | 7 | 11 | 9 | 11 | 15 | 8 | 29,492 | 5 | 10 | 10 | 24 | 11 | 1 | 24 | |||||||||||||
39672 | 39672 | 39672 | 11627548 | 2019-10-31T14:33:00 | 2019-10-31T22:36:50 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 491 30TH AVE, SAN FRANCISCO, CA, 94121 | 30TH AVE | 1 | Outer Richmond | RICHMOND | 37.7802006 | -122.49033329999999 | POINT (-122.4903333 37.7802006) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11627548/photos | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 2 | 8 | |||||||||||||
24316 | 24316 | 24316 | 11586950 | 2019-10-22T16:01:00 | 2019-10-28T12:11:14 | 2019-10-31T22:36:46 | Closed 2 | BSM already notified . duplicate request, suggest they call Fady at 5545810 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 191 WAWONA ST, SAN FRANCISCO, CA, 94127 | WAWONA ST | 7 | West Portal | TARAVAL | 37.74015045166 | -122.467636108398 | POINT (-122.46763611 37.74015045) | Phone | 46 | 10 | 8 | 41 | 4 | 1 | 5 | 59 | 8 | 40 | 40 | 46 | 8 | 1 | 46 | |||||||||||||
39576 | 39576 | 39576 | 11627253 | 2019-10-31T13:40:55 | 2019-10-31T22:36:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2641 25TH ST, SAN FRANCISCO, CA, 94110 | 25TH ST | 10 | Potrero Hill | MISSION | 37.751596 | -122.404661 | POINT (-122.404661 37.751596) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11627253/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
39588 | 39588 | 39588 | 11627277 | 2019-10-31T13:43:43 | 2019-10-31T22:36:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 3411 GEARY BLVD, SAN FRANCISCO, CA, 94118 | GEARY BLVD | 1 | Lone Mountain | RICHMOND | 37.781383700000006 | -122.4555344 | POINT (-122.4555344 37.7813837) | Web | http://mobile311.sfgov.org/reports/11627277/photos | 12 | 8 | 4 | 18 | 2 | 11 | 9 | 54 | 6 | 16 | 16 | 12 | 4 | 1 | 12 | |||||||||||||
39564 | 39564 | 39564 | 11627231 | 2019-10-31T13:37:01 | 2019-10-31T22:36:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1383 VERMONT ST, SAN FRANCISCO, CA, 94110 | VERMONT ST | 10 | Potrero Hill | MISSION | 37.752492 | -122.403222 | POINT (-122.403222 37.752492) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11627231/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
39525 | 39525 | 39525 | 11627133 | 2019-10-31T13:20:00 | 2019-10-31T22:36:41 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 28 CORTLAND AVE, SAN FRANCISCO, CA, 94110 | CORTLAND AVE | 9 | Holly Park | INGLESIDE | 37.740646362305 | -122.42221069335899 | POINT (-122.42221069 37.74064636) | Phone | 61 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 61 | 2 | 1 | 61 | ||||||||||||||
39250 | 39250 | 39250 | 11626464 | 2019-10-31T11:19:00 | 2019-10-31T22:36:08 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 210 JOICE ST, SAN FRANCISCO, CA, 94108 | JOICE ST | 3 | Nob Hill | CENTRAL | 37.793313299999994 | -122.4084815 | POINT (-122.4084815 37.7933133) | Web | http://mobile311.sfgov.org/reports/11626464/photos | 16 | 6 | 3 | 6 | 10 | 3 | 1 | 28,857 | 1 | 4 | 4 | 5 | 16 | 3 | 5 | 5 | 2 | 16 | ||||||||||
39238 | 39238 | 39238 | 11626431 | 2019-10-31T11:15:00 | 2019-10-31T22:36:06 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 210 JOICE ST, SAN FRANCISCO, CA, 94108 | JOICE ST | 3 | Nob Hill | CENTRAL | 37.793313299999994 | -122.4084815 | POINT (-122.4084815 37.7933133) | Web | http://mobile311.sfgov.org/reports/11626431/photos | 16 | 6 | 3 | 6 | 10 | 3 | 1 | 28,857 | 1 | 4 | 4 | 5 | 16 | 3 | 5 | 5 | 2 | 16 | ||||||||||
39135 | 39135 | 39135 | 11626216 | 2019-10-31T10:37:00 | 2019-10-31T22:35:58 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 1655 JONES ST, SAN FRANCISCO, CA, 94109 | JONES ST | 3 | Russian Hill | CENTRAL | 37.796585083008 | -122.41527557373001 | POINT (-122.41527557 37.79658508) | Phone | 107 | 6 | 3 | 21 | 10 | 5 | 1 | 28,858 | 1 | 21 | 21 | 107 | 3 | 1 | 107 | ||||||||||||||
3707082 | 3707082 | 3707082 | 11115734 | 2019-07-11T15:35:00 | 2019-10-31T22:35:52 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 571 ATHENS ST, SAN FRANCISCO, CA, 94112 | ATHENS ST | 11 | Excelsior | INGLESIDE | 37.718929290771 | -122.43029022216801 | POINT (-122.43029022 37.71892929) | Phone | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 2 | 90 | ||||||||||||||
39092 | 39092 | 39092 | 11626136 | 2019-10-31T10:26:00 | 2019-10-31T22:35:50 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 350 RHODE ISLAND ST, SAN FRANCISCO, CA, 94103 | RHODE ISLAND ST | 10 | Potrero Hill | SOUTHERN | 37.76541519165 | -122.402786254883 | POINT (-122.40278625 37.76541519) | Phone | 54 | 1 | 9 | 4 | 8 | 8 | 3 | 28,853 | 3 | 20 | 20 | 54 | 9 | 1 | 54 | ||||||||||||||
39065 | 39065 | 39065 | 11626053 | 2019-10-31T10:10:50 | 2019-10-31T22:35:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1110 JACKSON ST, SAN FRANCISCO, CA, 94133 | JACKSON ST | 3 | Nob Hill | CENTRAL | 37.795166024042004 | -122.413444854433 | POINT (-122.41344485 37.79516602) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11626053/photos | 16 | 6 | 3 | 21 | 10 | 5 | 1 | 28,857 | 1 | 21 | 21 | 16 | 3 | 1 | 16 | |||||||||||||
3836228 | 3836228 | 3836228 | 11428560 | 2019-09-17T13:47:00 | 2019-10-31T22:35:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 638 HEAD ST, SAN FRANCISCO, CA, 94132 | HEAD ST | 11 | Ingleside | TARAVAL | 37.718650817871 | -122.464309692383 | POINT (-122.46430969 37.71865082) | Phone | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 64 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
22192 | 22192 | 22192 | 11532932 | 2019-10-10T13:27:00 | 2019-10-31T22:35:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Sewer_damage_tree_roots | 1123 PALOU AVE, SAN FRANCISCO, CA, 94124 | PALOU AVE | 10 | Hunters Point | BAYVIEW | 37.72883605957 | -122.38214111328101 | POINT (-122.38214111 37.72883606) | Phone | 78 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 78 | 9 | 2 | 78 | ||||||||||||||
39037 | 39037 | 39037 | 11625993 | 2019-10-31T09:57:00 | 2019-10-31T22:35:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 4760 17TH ST, SAN FRANCISCO, CA, 94117 | 17TH ST | 5 | Ashbury Heights | PARK | 37.761773036343996 | -122.44894858836099 | POINT (-122.44894859 37.76177304) | Web | http://mobile311.sfgov.org/reports/11625993/photos | 114 | 7 | 11 | 3 | 11 | 15 | 8 | 29,492 | 5 | 9 | 9 | 114 | 11 | 1 | 114 | |||||||||||||
33010 | 33010 | 33010 | 11611610 | 2019-10-28T09:46:00 | 2019-10-28T10:19:31 | 2019-10-31T22:35:42 | Closed 2 | branches down Clean up tree crews are cleaning up all over the city. they will try to get there when worst is cleaned up | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 728 FAXON AVE, SAN FRANCISCO, CA, 94112 | FAXON AVE | 7 | Westwood Park | INGLESIDE | 37.726413333333 | -122.45995333333299 | POINT (-122.45995333 37.72641333) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11611610/photos | 71 | 9 | 8 | 41 | 4 | 9 | 4 | 28,861 | 7 | 40 | 40 | 71 | 8 | 1 | 71 | ||||||||||||
31966 | 31966 | 31966 | 11609120 | 2019-10-27T14:51:00 | 2019-10-28T09:48:39 | 2019-10-31T22:35:31 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 2249 17TH AVE, SAN FRANCISCO, CA, 94116 | 17TH AVE | 7 | Golden Gate Heights | TARAVAL | 37.745956420898 | -122.473823547363 | POINT (-122.47382355 37.74595642) | Phone | 44 | 10 | 8 | 41 | 4 | 1 | 5 | 29,491 | 8 | 40 | 40 | 44 | 8 | 1 | 44 | ||||||||||||||
65015 | 65015 | 65015 | 11515657 | 2019-10-07T09:13:00 | 2019-10-31T22:33:30 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Restake_tree | 477 GROVE ST, SAN FRANCISCO, CA, 94102 | GROVE ST | 5 | Hayes Valley | NORTHERN | 37.777534484863 | -122.424362182617 | POINT (-122.42436218 37.77753448) | Phone | 22 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 22 | 11 | 1 | 22 | ||||||||||||||
38735 | 38735 | 38735 | 11625346 | 2019-10-31T08:07:00 | 2019-10-31T22:33:07 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 200 FRANKLIN ST, SAN FRANCISCO, CA, 94102 | FRANKLIN ST | 5 | Civic Center | NORTHERN | 37.776214335043 | -122.420972473919 | POINT (-122.42097247 37.77621434) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11625346/photos | 21 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 21 | 1 | 11 | 1 | 8 | 1 | 1 | 21 | |||||||||
33559 | 33559 | 33559 | 11613217 | 2019-10-28T13:50:00 | 2019-11-01T12:52:24 | 2019-10-31T22:32:42 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of MASON ST and FRANCISCO ST | MASON ST | 3 | North Beach | CENTRAL | 37.804683685303004 | -122.413429260254 | POINT (-122.41342926 37.80468369) | Phone | 106 | 6 | 3 | 23 | 10 | 3 | 1 | 308 | 1 | 23 | 23 | 106 | 3 | 2 | 106 | ||||||||||||||
56350 | 56350 | 56350 | 11476961 | 2019-09-28T09:34:00 | 2019-10-31T22:32:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 999 TENNESSEE ST, SAN FRANCISCO, CA, 94107 | TENNESSEE ST | 10 | Dogpatch | BAYVIEW | 37.759517669678004 | -122.38918304443399 | POINT (-122.38918304 37.75951767) | Phone | 55 | 2 | 9 | 26 | 8 | 10 | 3 | 28,856 | 3 | 29 | 29 | 20 | 55 | 9 | 22 | 22 | 14 | 1 | 55 | ||||||||||
38321 | 38321 | 38321 | 11624464 | 2019-10-30T19:35:00 | 2019-10-31T22:32:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 137 ASHTON AVE, SAN FRANCISCO, CA, 94112 | ASHTON AVE | 11 | Ingleside | TARAVAL | 37.720693 | -122.462473 | POINT (-122.462473 37.720693) | Web | http://mobile311.sfgov.org/reports/11624464/photos | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | |||||||||||||
38125 | 38125 | 38125 | 11624088 | 2019-10-30T17:50:00 | 2019-10-31T22:31:40 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2400 WEBSTER ST, SAN FRANCISCO, CA, 94115 | WEBSTER ST | 2 | Pacific Heights | NORTHERN | 37.792937 | -122.43281200000001 | POINT (-122.432812 37.792937) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11624088/photos | 102 | 4 | 6 | 30 | 1 | 13 | 6 | 29,490 | 9 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
25629 | 25629 | 25629 | 11595225 | 2019-10-24T10:36:00 | 2019-10-31T22:30:34 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 142 JULES AVE, SAN FRANCISCO, CA, 94112 | JULES AVE | 11 | Ingleside | TARAVAL | 37.720783233643 | -122.461082458496 | POINT (-122.46108246 37.72078323) | Phone | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
23312 | 23312 | 23312 | 11459733 | 2019-09-24T12:38:00 | 2019-10-31T22:30:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 160 STRATFORD DR, SAN FRANCISCO, CA, 94132 | STRATFORD DR | 7 | Stonestown | TARAVAL | 37.722045898438 | -122.473686218262 | POINT (-122.47368622 37.7220459) | Phone | 41 | 10 | 8 | 41 | 4 | 9 | 5 | 64 | 8 | 40 | 40 | 41 | 8 | 1 | 41 | ||||||||||||||
37952 | 37952 | 37952 | 11623689 | 2019-10-30T16:33:17 | 2019-10-31T22:30:14 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1483 12TH AVE, SAN FRANCISCO, CA, 94122 | 12TH AVE | 7 | Inner Sunset | TARAVAL | 37.76049520000001 | -122.46952350000001 | POINT (-122.4695235 37.7604952) | Web | http://mobile311.sfgov.org/reports/11623689/photos | 109 | 10 | 8 | 14 | 4 | 1 | 5 | 56 | 8 | 12 | 12 | 109 | 8 | 1 | 109 | |||||||||||||
31373 | 31373 | 31373 | 11607221 | 2019-10-27T06:20:00 | 2019-10-28T10:03:55 | 2019-10-31T22:30:11 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 753 SHRADER ST, SAN FRANCISCO, CA, 94117 | SHRADER ST | 5 | Cole Valley | PARK | 37.767768859863 | -122.451675415039 | POINT (-122.45167542 37.76776886) | Phone | 29 | 7 | 11 | 3 | 11 | 15 | 8 | 29,492 | 5 | 9 | 9 | 29 | 11 | 1 | 29 | ||||||||||||||
40373 | 40373 | 40373 | 11629179 | 2019-10-31T21:38:48 | 2019-10-31T21:45:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 355 15TH AVE, SAN FRANCISCO, CA, 94118 | 15TH AVE | 1 | Inner Richmond | RICHMOND | 37.781524600000004 | -122.4743067 | POINT (-122.4743067 37.7815246) | Web | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 54 | 6 | 26 | 26 | 5 | 4 | 1 | 5 | ||||||||||||||
40339 | 40339 | 40339 | 11629075 | 2019-10-31T20:45:00 | 2019-10-31T21:00:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 810 SILVER AVE, SAN FRANCISCO, CA, 94134 | SILVER AVE | 9 | University Mound | BAYVIEW | 37.729022979736 | -122.419227600098 | POINT (-122.4192276 37.72902298) | Phone | 92 | 2 | 2 | 7 | 7 | 9 | 3 | 309 | 3 | 5 | 5 | 92 | 2 | 2 | 92 | ||||||||||||||
40206 | 40206 | 40206 | 11628795 | 2019-10-31T18:55:00 | 2019-10-31T20:37:00 | 2019-10-31T20:37:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 645 CAMBRIDGE ST, SAN FRANCISCO, CA, 94134 | CAMBRIDGE ST | 9 | University Mound | BAYVIEW | 37.723495483398 | -122.417045593262 | POINT (-122.41704559 37.72349548) | Phone | 92 | 2 | 2 | 25 | 7 | 9 | 3 | 309 | 3 | 28 | 28 | 92 | 2 | 1 | 92 | ||||||||||||||
40239 | 40239 | 40239 | 11628855 | 2019-10-31T19:11:00 | 2019-10-31T19:40:10 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of FULTON ST and 33RD AVE | FULTON ST | 1 | Golden Gate Park | RICHMOND | 37.772178649902 | -122.49275970459 | POINT (-122.4927597 37.77217865) | Phone | 8 | 8 | 4 | 12 | 2 | 11 | 9 | 55 | 6 | 8 | 8 | 8 | 4 | 1 | 8 | ||||||||||||||
40182 | 40182 | 40182 | 11628752 | 2019-10-31T18:42:00 | 2019-10-31T18:50:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Sewer_damage_tree_roots | Intersection of MISSION ST and 23RD ST | MISSION ST | 9 | Mission | MISSION | 37.753837585449 | -122.418594360352 | POINT (-122.41859436 37.75383759) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
40034 | 40034 | 40034 | 11628432 | 2019-10-31T17:23:00 | 2019-10-31T18:00:16 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 265 BEACON ST, SAN FRANCISCO, CA, 94131 | BEACON ST | 8 | Fairmount | INGLESIDE | 37.74048614502 | -122.432518005371 | POINT (-122.43251801 37.74048615) | Phone | 59 | 9 | 5 | 10 | 5 | 2 | 4 | 63 | 7 | 7 | 7 | 59 | 5 | 1 | 59 | ||||||||||||||
39781 | 39781 | 39781 | 11627812 | 2019-10-31T15:16:00 | 2019-10-31T17:25:10 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 2420 FILLMORE ST, SAN FRANCISCO, CA, 94115 | FILLMORE ST | 2 | Pacific Heights | NORTHERN | 37.791996002196996 | -122.43430328369101 | POINT (-122.43430328 37.791996) | Phone | 102 | 4 | 6 | 30 | 1 | 13 | 6 | 29,490 | 9 | 27 | 27 | 102 | 6 | 1 | 102 | ||||||||||||||
26794 | 26794 | 26794 | 11599196 | 2019-10-25T08:05:00 | 2019-10-31T17:15:12 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 150 FRANCE AVE, SAN FRANCISCO, CA, 94112 | FRANCE AVE | 11 | Excelsior | INGLESIDE | 37.719418262167004 | -122.43706882942699 | POINT (-122.43706883 37.71941826) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11599196/photos | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 4 | 90 | 1 | 4 | 2 | 90 | |||||||||||
34793 | 34793 | 34793 | 11616241 | 2019-10-29T08:47:00 | 2019-10-31T17:15:12 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Intersection of BERTHA LN and HARBOR RD | BERTHA LN | 10 | Bayview | BAYVIEW | 37.7340377 | -122.38134070000001 | POINT (-122.3813407 37.7340377) | Web | http://mobile311.sfgov.org/reports/11616241/photos | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | |||||||||||||
35985 | 35985 | 35985 | 11619258 | 2019-10-29T16:26:00 | 2019-10-31T17:15:12 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 822 BRAZIL AVE, SAN FRANCISCO, CA, 94112 | BRAZIL AVE | 11 | Excelsior | INGLESIDE | 37.721399744076 | -122.42801561963002 | POINT (-122.42801562 37.72139974) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11619258/photos | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 2 | 90 | |||||||||||||
39837 | 39837 | 39837 | 11628003 | 2019-10-31T15:51:00 | 2019-10-31T17:15:11 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | 1225 4TH AVE, SAN FRANCISCO, CA, 94122 | 4TH AVE | 5 | Inner Sunset | PARK | 37.765682220459 | -122.461128234863 | POINT (-122.46112823 37.76568222) | Phone | 109 | 7 | 11 | 14 | 11 | 15 | 8 | 56 | 5 | 12 | 12 | 109 | 11 | 1 | 109 | ||||||||||||||
39814 | 39814 | 39814 | 11627922 | 2019-10-31T15:35:00 | 2019-10-31T17:02:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 346 LEXINGTON ST, SAN FRANCISCO, CA, 94110 | LEXINGTON ST | 9 | Mission | MISSION | 37.757774353027 | -122.42053985595699 | POINT (-122.42053986 37.75777435) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
23031 | 23031 | 23031 | 11627389 | 2019-10-31T14:02:00 | 2019-10-31T17:00:34 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of ANZA ST and ROSSI AVE | ANZA ST | 1 | Lone Mountain | RICHMOND | 37.779693603516 | -122.456497192383 | POINT (-122.45649719 37.7796936) | Phone | 12 | 8 | 4 | 18 | 2 | 11 | 9 | 54 | 6 | 16 | 16 | 12 | 4 | 1 | 12 | ||||||||||||||
39790 | 39790 | 39790 | 11627840 | 2019-10-31T15:23:00 | 2019-10-31T16:35:10 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | 845 FILBERT ST, SAN FRANCISCO, CA, 94133 | FILBERT ST | 3 | Russian Hill | CENTRAL | 37.800762176514 | -122.413375854492 | POINT (-122.41337585 37.80076218) | Phone | 107 | 6 | 3 | 32 | 10 | 3 | 1 | 308 | 1 | 32 | 32 | 107 | 3 | 1 | 107 | ||||||||||||||
39840 | 39840 | 39840 | 11628012 | 2019-10-31T15:52:00 | 2019-10-31T16:00:40 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1420 CHURCH ST, SAN FRANCISCO, CA, 94131 | CHURCH ST | 8 | Noe Valley | MISSION | 37.747978210449 | -122.42726898193399 | POINT (-122.42726898 37.74797821) | Phone | 84 | 3 | 5 | 22 | 5 | 2 | 7 | 63 | 4 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
39847 | 39847 | 39847 | 11628028 | 2019-10-31T15:54:00 | 2019-10-31T16:00:39 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1456 CHURCH ST, SAN FRANCISCO, CA, 94131 | CHURCH ST | 8 | Noe Valley | INGLESIDE | 37.747486114502 | -122.42722320556601 | POINT (-122.42722321 37.74748611) | Phone | 84 | 9 | 5 | 22 | 5 | 2 | 4 | 63 | 7 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
39715 | 39715 | 39715 | 11627662 | 2019-10-31T14:52:00 | 2019-10-31T15:59:00 | 2019-10-31T15:59:00 | Closed 2 | i cut up the tree branch an put it in thr truck | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1219 FELL ST, SAN FRANCISCO, CA, 94117 | FELL ST | 5 | Panhandle | PARK | 37.773956298828004 | -122.43800232 | POINT (-122.43800232 37.7739563) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11627662/photos | 24 | 7 | 11 | 9 | 11 | 15 | 8 | 29,492 | 5 | 10 | 10 | 24 | 11 | 1 | 24 | ||||||||||||
39813 | 39813 | 39813 | 11627920 | 2019-10-31T15:35:00 | 2019-10-31T15:45:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1310 CHURCH ST, SAN FRANCISCO, CA, 94114 | CHURCH ST | 8 | Noe Valley | MISSION | 37.74987411499 | -122.427421569824 | POINT (-122.42742157 37.74987411) | Phone | 84 | 3 | 5 | 22 | 5 | 2 | 7 | 28,862 | 4 | 22 | 22 | 84 | 5 | 1 | 84 | ||||||||||||||
39809 | 39809 | 39809 | 11627900 | 2019-10-31T15:33:00 | 2019-10-31T15:40:10 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 175 DORANTES AVE, SAN FRANCISCO, CA, 94116 | DORANTES AVE | 7 | Forest Hill | TARAVAL | 37.745216369629 | -122.464286804199 | POINT (-122.4642868 37.74521637) | Phone | 45 | 10 | 8 | 41 | 4 | 1 | 5 | 29,491 | 8 | 40 | 40 | 45 | 8 | 1 | 45 | ||||||||||||||
39738 | 39738 | 39738 | 11627727 | 2019-10-31T15:03:00 | 2019-10-31T15:10:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Intersection of 19TH AVE and EUCALYPTUS DR | 19TH AVE | 7 | Stonestown | TARAVAL | 37.731067657471 | -122.474853515625 | POINT (-122.47485352 37.73106766) | Phone | 62 | 10 | 8 | 41 | 4 | 9 | 5 | 64 | 8 | 40 | 40 | 62 | 8 | 1 | 62 | ||||||||||||||
39657 | 39657 | 39657 | 11627517 | 2019-10-31T14:26:00 | 2019-10-31T14:35:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 1710 10TH AVE, SAN FRANCISCO, CA, 94122 | 10TH AVE | 7 | Golden Gate Heights | TARAVAL | 37.756328582764 | -122.46670532226601 | POINT (-122.46670532 37.75632858) | Phone | 44 | 10 | 8 | 14 | 4 | 1 | 5 | 56 | 8 | 12 | 12 | 44 | 8 | 1 | 44 | ||||||||||||||
39614 | 39614 | 39614 | 11627357 | 2019-10-31T13:56:00 | 2019-10-31T14:25:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 2067 HAYES ST, SAN FRANCISCO, CA, 94117 | HAYES ST | 5 | Panhandle | PARK | 37.773258209229 | -122.45043182373001 | POINT (-122.45043182 37.77325821) | Phone | 24 | 7 | 11 | 18 | 11 | 15 | 8 | 29,492 | 5 | 16 | 16 | 24 | 11 | 1 | 24 | ||||||||||||||
38812 | 38812 | 38812 | 11625499 | 2019-10-31T08:37:00 | 2019-10-31T14:15:08 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | 1 HIDALGO TER, SAN FRANCISCO, CA, 94103 | HIDALGO TER | 8 | Mission Dolores | MISSION | 37.767051696777 | -122.42562866210899 | POINT (-122.42562866 37.7670517) | Phone | 37 | 3 | 5 | 20 | 5 | 8 | 7 | 28,853 | 4 | 19 | 19 | 37 | 5 | 2 | 37 | ||||||||||||||
39536 | 39536 | 39536 | 11627160 | 2019-10-31T13:24:00 | 2019-10-31T14:00:44 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Remove_garden_debris | Intersection of POPLAR ST and 26TH ST | POPLAR ST | 8 | Mission | MISSION | 37.748878479004 | -122.420829772949 | POINT (-122.42082977 37.74887848) | Phone | 53 | 3 | 5 | 20 | 5 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 5 | 1 | 53 | ||||||||||||||
3834830 | 3834830 | 3834830 | 11444616 | 2019-09-20T18:09:00 | 2019-10-31T13:51:37 | 2019-10-31T13:51:37 | Closed 2 | Unable to Locate. If the problem still exists, please submit a new request with more details regarding the location of the issue. Close Note: | RPD GGP Queue 14 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | GGP Speedway Meadow, , SAN FRANCISCO, CA, 94122 | GGP Speedway Meadow | 1 | Golden Gate Park | RICHMOND | 37.7694208 | -122.4862138 | POINT (-122.4862138 37.7694208) | Web | http://mobile311.sfgov.org/reports/11444616/photos | 9 | 8 | 4 | 12 | 2 | 11 | 9 | 55 | 6 | 8 | 8 | 9 | 4 | 1 | 9 | ||||||||||||
37992 | 37992 | 37992 | 11623780 | 2019-10-30T16:44:00 | 2019-10-31T13:46:02 | Open 1 | closed | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 65 CRESTLINE DR, SAN FRANCISCO, CA, 94131 | CRESTLINE DR | 8 | Upper Market | PARK | 37.751298 | -122.4465027 | POINT (-122.4465027 37.751298) | Web | 51 | 7 | 5 | 38 | 5 | 2 | 8 | 63 | 5 | 38 | 38 | 51 | 5 | 1 | 51 | ||||||||||||||
42972 | 42972 | 42972 | 11528050 | 2019-10-09T13:47:02 | 2019-10-31T13:35:12 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2517 24TH ST, SAN FRANCISCO, CA, 94110 | 24TH ST | 10 | Potrero Hill | MISSION | 37.752965 | -122.4048 | POINT (-122.4048 37.752965) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11528050/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
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 | ||||||||||||||
72126 | 72126 | 72126 | 11608886 | 2019-10-27T13:57:43 | 2019-10-28T07:20:34 | 2019-10-31T13:16:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2159 CHESTNUT ST, SAN FRANCISCO, CA, 94123 | CHESTNUT ST | 2 | Marina | NORTHERN | 37.800431 | -122.43880300000001 | POINT (-122.438803 37.800431) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11608886/photos | 17 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 19 | 17 | 6 | 21 | 21 | 1 | 17 | ||||||||||
95201 | 95201 | 95201 | 11509805 | 2019-10-05T15:15:00 | 2019-10-31T12:55:10 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1230 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 | COLUMBUS AVE | 3 | Fisherman's Wharf | CENTRAL | 37.805592 | -122.417658 | POINT (-122.417658 37.805592) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11509805/photos | 99 | 6 | 3 | 23 | 10 | 5 | 1 | 308 | 1 | 23 | 23 | 99 | 3 | 2 | 2 | 99 | ||||||||||||
39410 | 39410 | 39410 | 11626860 | 2019-10-31T12:28:00 | 2019-10-31T12:35:11 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 83 ELSIE ST, SAN FRANCISCO, CA, 94110 | ELSIE ST | 9 | Bernal Heights | INGLESIDE | 37.743537902831996 | -122.417091369629 | POINT (-122.41709137 37.7435379) | Phone | 83 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 83 | 2 | 1 | 83 | ||||||||||||||
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 | ||||||||||||||
39237 | 39237 | 39237 | 11626424 | 2019-10-31T11:13:00 | 2019-10-31T12:00:11 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 311 VIRGINIA AVE, SAN FRANCISCO, CA, 94110 | VIRGINIA AVE | 9 | Bernal Heights | INGLESIDE | 37.742023468018 | -122.41858673095699 | POINT (-122.41858673 37.74202347) | Phone | 83 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 83 | 2 | 1 | 83 | ||||||||||||||
39272 | 39272 | 39272 | 11626533 | 2019-10-31T11:32:00 | 2019-10-31T11:40:26 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 261 GRANADA AVE, SAN FRANCISCO, CA, 94112 | GRANADA AVE | 7 | Ingleside | TARAVAL | 37.723201751709 | -122.457305908203 | POINT (-122.45730591 37.72320175) | Phone | 64 | 10 | 8 | 24 | 4 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 8 | 19 | 19 | 2 | 64 | ||||||||||||
39253 | 39253 | 39253 | 11626477 | 2019-10-31T11:22:00 | 2019-10-31T11:40:23 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Other_enter_additional_details_below | 611 FREDERICK ST, SAN FRANCISCO, CA, 94117 | FREDERICK ST | 5 | Parnassus Heights | PARK | 37.765998840331996 | -122.45491027831999 | POINT (-122.45491028 37.76599884) | Phone | 110 | 7 | 11 | 14 | 11 | 15 | 8 | 29,492 | 5 | 12 | 12 | 110 | 11 | 1 | 110 | ||||||||||||||
39274 | 39274 | 39274 | 11626538 | 2019-10-31T11:33:00 | 2019-10-31T11:40:14 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 2032 MCALLISTER ST, SAN FRANCISCO, CA, 94118 | MCALLISTER ST | 5 | Western Addition | PARK | 37.776985168456996 | -122.44557952880899 | POINT (-122.44557953 37.77698517) | Phone | 97 | 7 | 11 | 18 | 11 | 15 | 8 | 29,492 | 5 | 16 | 16 | 97 | 11 | 1 | 97 | ||||||||||||||
16042 | 16042 | 16042 | 11511885 | 2019-10-06T10:00:00 | 2019-10-31T11:40:13 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_street_lights | 606 KANSAS ST, SAN FRANCISCO, CA, 94107 | KANSAS ST | 10 | Potrero Hill | BAYVIEW | 37.761909484863 | -122.403427124023 | POINT (-122.40342712 37.76190948) | Phone | 54 | 2 | 9 | 26 | 8 | 10 | 3 | 28,856 | 3 | 29 | 29 | 54 | 9 | 15 | 1 | 54 | |||||||||||||
19778 | 19778 | 19778 | 11533780 | 2019-10-10T15:46:17 | 2019-10-31T11:40:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 415 DE HARO ST, SAN FRANCISCO, CA, 94103 | DE HARO ST | 10 | Potrero Hill | SOUTHERN | 37.7645888 | -122.4013138 | POINT (-122.4013138 37.7645888) | Web | 54 | 1 | 9 | 26 | 8 | 14 | 3 | 28,856 | 3 | 29 | 29 | 54 | 9 | 1 | 54 | ||||||||||||||
24669 | 24669 | 24669 | 11590897 | 2019-10-23T11:41:00 | 2019-10-31T11:35:11 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 430 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 | SAN BRUNO AVE | 10 | Potrero Hill | MISSION | 37.764137268066 | -122.40557861328101 | POINT (-122.40557861 37.76413727) | Phone | 54 | 3 | 9 | 20 | 8 | 8 | 7 | 28,859 | 4 | 19 | 19 | 54 | 9 | 15 | 2 | 54 | |||||||||||||
3842766 | 3842766 | 3842766 | 11449867 | 2019-09-22T11:23:58 | 2019-10-31T10:55:14 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 316 UTAH ST, SAN FRANCISCO, CA, 94103 | UTAH ST | 10 | Potrero Hill | MISSION | 37.765634986607 | -122.406541518981 | POINT (-122.40654152 37.76563499) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11449867/photos | 54 | 3 | 9 | 20 | 8 | 8 | 7 | 28,853 | 4 | 19 | 19 | 54 | 9 | 2 | 15 | 2 | 2 | 54 | ||||||||||
38057 | 38057 | 38057 | 11623938 | 2019-10-30T17:14:00 | 2019-10-31T10:49:05 | 2019-10-31T10:49:05 | Closed 2 | Unable to Locate. If the problem still exists, please submit a new request with more details regarding the location of the issue. Close Note: Unable to locate. No parking lot at Persia/sunnydale. Please resend 311 if issue persists | RPD Park Service Area 3 Queue 16 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of PERSIA AVE and SUNNYDALE AVE | PERSIA AVE | 11 | Excelsior | INGLESIDE | 37.718280792236 | -122.425834655762 | POINT (-122.42583466 37.71828079) | Phone | 90 | 9 | 1 | 19 | 6 | 9 | 4 | 309 | 7 | 18 | 18 | 90 | 1 | 2 | 90 | |||||||||||||
37908 | 37908 | 37908 | 11623600 | 2019-10-30T16:14:00 | 2019-10-31T10:35:20 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 926 CAPITOL AVE, SAN FRANCISCO, CA, 94112 | CAPITOL AVE | 11 | Ingleside | TARAVAL | 37.718763 | -122.45896499999999 | POINT (-122.458965 37.718763) | Mobile/Open311 | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
37902 | 37902 | 37902 | 11623593 | 2019-10-30T16:12:00 | 2019-10-31T10:25:10 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 939 CAPITOL AVE, SAN FRANCISCO, CA, 94112 | CAPITOL AVE | 11 | Ingleside | TARAVAL | 37.718946 | -122.45919599999999 | POINT (-122.459196 37.718946) | Mobile/Open311 | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 2 | 64 | ||||||||||||||
38893 | 38893 | 38893 | 11625674 | 2019-10-31T09:07:00 | 2019-10-31T09:20:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Intersection of HENRY ST and CASTRO ST | HENRY ST | 8 | Corona Heights | PARK | 37.766529083252 | -122.435546875 | POINT (-122.43554688 37.76652908) | Phone | 28 | 7 | 5 | 5 | 5 | 15 | 8 | 28,862 | 5 | 3 | 3 | 28 | 5 | 1 | 5 | 28 | |||||||||||||
38839 | 38839 | 38839 | 11625557 | 2019-10-31T08:47:00 | 2019-10-31T09:10:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 40 BROMPTON AVE, SAN FRANCISCO, CA, 94131 | BROMPTON AVE | 8 | Glen Park | INGLESIDE | 37.734104156494006 | -122.43498229980499 | POINT (-122.4349823 37.73410416) | Phone | 96 | 9 | 5 | 10 | 5 | 2 | 4 | 63 | 7 | 7 | 7 | 15 | 96 | 5 | 17 | 17 | 1 | 96 | |||||||||||
38779 | 38779 | 38779 | 11625433 | 2019-10-31T08:26:00 | 2019-10-31T08:55:10 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Intersection of GILROY ST and INGERSON AVE | GILROY ST | 10 | Bret Harte | BAYVIEW | 37.71688079834 | -122.38913726806601 | POINT (-122.38913727 37.7168808) | Phone | 88 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 88 | 9 | 2 | 88 | ||||||||||||||
38789 | 38789 | 38789 | 11625450 | 2019-10-31T08:28:46 | 2019-10-31T08:35:09 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1111 FRANKLIN ST, SAN FRANCISCO, CA, 94109 | FRANKLIN ST | 5 | Cathedral Hill | NORTHERN | 37.784683881995 | -122.422934857178 | POINT (-122.42293486 37.78468388) | Web | 100 | 4 | 11 | 39 | 11 | 13 | 6 | 28,858 | 9 | 41 | 41 | 100 | 11 | 1 | 100 | ||||||||||||||
31826 | 31826 | 31826 | 11608748 | 2019-10-27T13:27:00 | 2019-10-31T07:45:45 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 131 FELL ST, SAN FRANCISCO, CA, 94102 | FELL ST | 5 | Civic Center | NORTHERN | 37.77628922785 | -122.4199512132 | POINT (-122.41995121 37.77628923) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11608748/photos | 21 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 21 | 1 | 11 | 1 | 8 | 1 | 1 | 21 | |||||||||
97074 | 97074 | 97074 | 11608342 | 2019-10-27T11:54:00 | 2019-10-31T07:45:43 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1439 PAGE ST, SAN FRANCISCO, CA, 94117 | PAGE ST | 5 | Haight Ashbury | PARK | 37.7710597 | -122.44445890000001 | POINT (-122.4444589 37.7710597) | Web | http://mobile311.sfgov.org/reports/11608342/photos | 25 | 7 | 11 | 3 | 11 | 15 | 8 | 29,492 | 5 | 9 | 9 | 25 | 11 | 1 | 25 | |||||||||||||
3756447 | 3756447 | 3756447 | 11227085 | 2019-08-05T09:02:00 | 2019-10-31T07:22:28 | 2019-10-31T07:22:28 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 400 DUBOCE AVE, SAN FRANCISCO, CA, 94117 | DUBOCE AVE | 8 | Duboce Triangle | PARK | 37.769794464111 | -122.429725646973 | POINT (-122.42972565 37.76979446) | Phone | 28 | 7 | 5 | 9 | 5 | 7 | 6 | 29,492 | 9 | 10 | 10 | 28 | 5 | 20 | 1 | 28 | |||||||||||||
3843693 | 3843693 | 3843693 | 11446379 | 2019-09-21T10:55:00 | 2019-10-31T05:35:00 | Open 1 | sent | RPD NSA Queue 19 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 880 CLIPPER ST, SAN FRANCISCO, CA, 94114 | CLIPPER ST | 8 | Upper Market | MISSION | 37.747157957725 | -122.443782205741 | POINT (-122.44378221 37.74715796) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11446379/photos | 51 | 3 | 5 | 22 | 5 | 2 | 7 | 63 | 4 | 22 | 22 | 51 | 5 | 1 | 51 | |||||||||||||
32071 | 32071 | 32071 | 11609374 | 2019-10-27T15:58:00 | 2019-10-31T00:30:09 | 2019-10-31T00:30:09 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 581 FREDERICK ST, SAN FRANCISCO, CA, 94117 | FREDERICK ST | 5 | Parnassus Heights | PARK | 37.766090393066 | -122.454200744629 | POINT (-122.45420074 37.76609039) | Phone | 110 | 7 | 11 | 14 | 11 | 15 | 8 | 29,492 | 5 | 12 | 12 | 110 | 11 | 1 | 110 | ||||||||||||||
72119 | 72119 | 72119 | 11608000 | 2019-10-27T10:32:00 | 2019-10-31T00:30:08 | 2019-10-31T00:30:08 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of WEBSTER ST and SUTTER ST | WEBSTER ST | 5 | Japantown | NORTHERN | 37.786304473877 | -122.43154907226601 | POINT (-122.43154907 37.78630447) | Phone | 101 | 4 | 11 | 30 | 11 | 13 | 6 | 29,490 | 9 | 27 | 27 | 101 | 11 | 1 | 101 | ||||||||||||||
31518 | 31518 | 31518 | 11607691 | 2019-10-27T09:25:00 | 2019-10-31T00:25:31 | 2019-10-31T00:25:31 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 416 FRANCONIA ST, SAN FRANCISCO, CA, 94110 | FRANCONIA ST | 9 | Bernal Heights | INGLESIDE | 37.742929 | -122.40820500000001 | POINT (-122.408205 37.742929) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11607691/photos | 83 | 9 | 2 | 2 | 7 | 10 | 4 | 28,859 | 7 | 2 | 2 | 83 | 2 | 1 | 83 | |||||||||||||
31514 | 31514 | 31514 | 11607681 | 2019-10-27T09:23:00 | 2019-10-31T00:25:28 | 2019-10-31T00:25:28 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2810 LAGUNA ST, SAN FRANCISCO, CA, 94123 | LAGUNA ST | 2 | Union Street | NORTHERN | 37.7972619 | -122.4302125 | POINT (-122.4302125 37.7972619) | Web | 15 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 15 | 6 | 1 | 15 | ||||||||||||||
31620 | 31620 | 31620 | 11608005 | 2019-10-27T10:33:02 | 2019-10-31T00:25:26 | 2019-10-31T00:25:26 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Intersection of 19TH AVE and ANZA ST | 19TH AVE | 1 | Inner Richmond | RICHMOND | 37.778454151691 | -122.478017172927 | POINT (-122.47801717 37.77845415) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11608005/photos | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 5 | 4 | 1 | 5 | |||||||||||||
102186 | 102186 | 102186 | 11608734 | 2019-10-27T13:24:00 | 2019-10-31T00:25:26 | 2019-10-31T00:25:26 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 3082 HARRISON ST, SAN FRANCISCO, CA, 94110 | HARRISON ST | 9 | Mission | MISSION | 37.748519897461 | -122.41156005859399 | POINT (-122.41156006 37.7485199) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
31651 | 31651 | 31651 | 11608096 | 2019-10-27T10:54:00 | 2019-10-31T00:25:25 | 2019-10-31T00:25:25 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 331 PARK ST, SAN FRANCISCO, CA, 94110 | PARK ST | 9 | Holly Park | INGLESIDE | 37.73649597168 | -122.418319702148 | POINT (-122.4183197 37.73649597) | pic.twitter.com/PJSBKjO0VW | 61 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 61 | 2 | 1 | 61 | ||||||||||||||
93762 | 93762 | 93762 | 11607510 | 2019-10-27T08:39:00 | 2019-10-31T00:25:21 | 2019-10-31T00:25:21 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 409 DOUGLASS ST, SAN FRANCISCO, CA, 94114 | DOUGLASS ST | 8 | Eureka Valley | MISSION | 37.757263183594 | -122.438865661621 | POINT (-122.43886566 37.75726318) | Phone | 115 | 3 | 5 | 5 | 5 | 2 | 7 | 28,862 | 4 | 3 | 3 | 115 | 5 | 1 | 115 | ||||||||||||||
31382 | 31382 | 31382 | 11607245 | 2019-10-27T06:49:00 | 2019-10-31T00:25:20 | 2019-10-31T00:25:20 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 1473 11TH AVE, SAN FRANCISCO, CA, 94122 | 11TH AVE | 7 | Inner Sunset | TARAVAL | 37.76070022583 | -122.468360900879 | POINT (-122.4683609 37.76070023) | Phone | 109 | 10 | 8 | 14 | 4 | 1 | 5 | 56 | 8 | 12 | 12 | 109 | 8 | 1 | 109 | ||||||||||||||
31594 | 31594 | 31594 | 11607894 | 2019-10-27T10:09:00 | 2019-10-31T00:25:20 | 2019-10-31T00:25:20 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 63 LANDERS ST, SAN FRANCISCO, CA, 94114 | LANDERS ST | 8 | Mission Dolores | MISSION | 37.766876810167 | -122.427684424452 | POINT (-122.42768442 37.76687681) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11607894/photos | 37 | 3 | 5 | 5 | 5 | 8 | 7 | 28,862 | 4 | 3 | 3 | 37 | 5 | 1 | 5 | 37 | ||||||||||||
31498 | 31498 | 31498 | 11607642 | 2019-10-27T09:12:00 | 2019-10-31T00:25:19 | 2019-10-31T00:25:19 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of LOPEZ AVE and CASTENADA AVE | LOPEZ AVE | 7 | Forest Hill | TARAVAL | 37.746677398681996 | -122.46360015869101 | POINT (-122.46360016 37.7466774) | Phone | 45 | 10 | 8 | 41 | 4 | 1 | 5 | 29,491 | 8 | 40 | 40 | 45 | 8 | 1 | 45 | ||||||||||||||
93496 | 93496 | 93496 | 11607453 | 2019-10-27T08:26:00 | 2019-10-31T00:25:18 | 2019-10-31T00:25:18 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 159 SAN CARLOS ST, SAN FRANCISCO, CA, 94110 | SAN CARLOS ST | 9 | Mission | MISSION | 37.760921666667 | -122.419761666667 | POINT (-122.41976167 37.76092167) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11607453/photos | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | |||||||||||
31823 | 31823 | 31823 | 11608744 | 2019-10-27T13:26:00 | 2019-10-31T00:25:17 | 2019-10-31T00:25:17 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 200 ARGUELLO BLVD, SAN FRANCISCO, CA, 94118 | ARGUELLO BLVD | 2 | Presidio Heights | RICHMOND | 37.786479949951 | -122.459037780762 | POINT (-122.45903778 37.78647995) | Phone | 10 | 8 | 6 | 31 | 1 | 11 | 9 | 54 | 6 | 31 | 31 | 10 | 6 | 1 | 10 | ||||||||||||||
36878 | 36878 | 36878 | 11621063 | 2019-10-30T08:24:00 | 2019-10-30T22:15:34 | 2019-10-30T22:15:34 | Closed 2 | Request is a duplicate and has been previously reported as 11619759 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 2646 VALLEJO ST, SAN FRANCISCO, CA, 94123 | VALLEJO ST | 2 | Pacific Heights | NORTHERN | 37.794609069824 | -122.44082641601601 | POINT (-122.44082642 37.79460907) | Phone | 102 | 4 | 6 | 30 | 1 | 13 | 6 | 57 | 9 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
70593 | 70593 | 70593 | 11526123 | 2019-10-09T08:38:00 | 2019-10-30T19:12:12 | Open 1 | sent | RPD Park Service Area 5 Queue 11 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | Portola Open Space, , SAN FRANCISCO, CA, 94114 | Portola Open Space | 8 | Upper Market | MISSION | 37.747077941895 | -122.444061279297 | POINT (-122.44406128 37.74707794) | Phone | 51 | 3 | 5 | 22 | 5 | 2 | 7 | 63 | 4 | 22 | 22 | 51 | 5 | 1 | 51 |
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))