calls

Custom SQL query returning 101 rows (hide)

rowidrowidCaseIDOpenedClosedUpdatedStatusStatus_NotesResponsible_AgencyCategoryRequest_TypeRequest_DetailsAddressStreetSupervisor_DistrictNeighborhoodPolice_DistrictLatitudeLongitudePointSourceMedia_URLSF_Find_NeighborhoodsCurrent_Police_DistrictsCurrent_Supervisor_DistrictsAnalysis_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_4iupNeighborhoods
40349 40349 11629116 2019-10-31T21:05:49   2019-10-31T22:37:55 1 accepted 1 1 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 11483974 2019-09-30T09:27:00   2019-10-31T22:37:24 1 accepted 1 1 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 11628418 2019-10-31T17:19:00   2019-10-31T22:37:18 1 accepted 1 1 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 11628119 2019-10-31T16:11:00   2019-10-31T22:37:05 1 accepted 2 1 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 11627990 2019-10-31T15:48:00   2019-10-31T22:37:01 1 accepted 1 1 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 11022281 2019-06-20T10:20:00   2019-10-31T22:36:58 1 accepted 1 1 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 11627774 2019-10-31T15:10:18   2019-10-31T22:36:55 1 accepted 1 1 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 11627548 2019-10-31T14:33:00   2019-10-31T22:36:50 1 accepted 1 1 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 11586950 2019-10-22T16:01:00 2019-10-28T12:11:14 2019-10-31T22:36:46 2 BSM already notified . duplicate request, suggest they call Fady at 5545810 1 1 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 11627253 2019-10-31T13:40:55   2019-10-31T22:36:43 1 accepted 1 1 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 11627277 2019-10-31T13:43:43   2019-10-31T22:36:43 1 accepted 1 1 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 11627231 2019-10-31T13:37:01   2019-10-31T22:36:42 1 accepted 1 1 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 11627133 2019-10-31T13:20:00   2019-10-31T22:36:41 1 accepted 1 1 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 11626464 2019-10-31T11:19:00   2019-10-31T22:36:08 1 accepted 2 1 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 11626431 2019-10-31T11:15:00   2019-10-31T22:36:06 1 open 1 1 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 11626216 2019-10-31T10:37:00   2019-10-31T22:35:58 1 accepted 1 1 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 11115734 2019-07-11T15:35:00   2019-10-31T22:35:52 1 accepted 1 1 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 11626136 2019-10-31T10:26:00   2019-10-31T22:35:50 1 accepted 1 1 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 11626053 2019-10-31T10:10:50   2019-10-31T22:35:47 1 accepted 1 1 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 11428560 2019-09-17T13:47:00   2019-10-31T22:35:47 1 accepted 1 1 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 11532932 2019-10-10T13:27:00   2019-10-31T22:35:44 1 accepted 1 1 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 11625993 2019-10-31T09:57:00   2019-10-31T22:35:43 1 accepted 1 1 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 11611610 2019-10-28T09:46:00 2019-10-28T10:19:31 2019-10-31T22:35:42 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 2 1 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 11609120 2019-10-27T14:51:00 2019-10-28T09:48:39 2019-10-31T22:35:31 2   2 1 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 11515657 2019-10-07T09:13:00   2019-10-31T22:33:30 1 accepted 1 1 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 11625346 2019-10-31T08:07:00   2019-10-31T22:33:07 1 accepted 2 1 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 11613217 2019-10-28T13:50:00 2019-11-01T12:52:24 2019-10-31T22:32:42 2   1 1 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 11476961 2019-09-28T09:34:00   2019-10-31T22:32:22 1 accepted 1 1 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 11624464 2019-10-30T19:35:00   2019-10-31T22:32:17 1 accepted 1 1 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 11624088 2019-10-30T17:50:00   2019-10-31T22:31:40 1 accepted 1 1 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 11595225 2019-10-24T10:36:00   2019-10-31T22:30:34 1 accepted 1 1 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 11459733 2019-09-24T12:38:00   2019-10-31T22:30:28 1 accepted 1 1 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 11623689 2019-10-30T16:33:17   2019-10-31T22:30:14 1 accepted 1 1 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 11607221 2019-10-27T06:20:00 2019-10-28T10:03:55 2019-10-31T22:30:11 2   2 1 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 11629179 2019-10-31T21:38:48   2019-10-31T21:45:09 1 accepted 1 1 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 11629075 2019-10-31T20:45:00   2019-10-31T21:00:22 1 accepted 1 1 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 11628795 2019-10-31T18:55:00 2019-10-31T20:37:00 2019-10-31T20:37:00 2   1 1 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 11628855 2019-10-31T19:11:00   2019-10-31T19:40:10 1 in progress 1 1 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 11628752 2019-10-31T18:42:00   2019-10-31T18:50:09 1 accepted 1 1 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 11628432 2019-10-31T17:23:00   2019-10-31T18:00:16 1 accepted 1 1 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 11627812 2019-10-31T15:16:00   2019-10-31T17:25:10 1 accepted 1 1 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 11599196 2019-10-25T08:05:00   2019-10-31T17:15:12 1 accepted 2 1 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 11616241 2019-10-29T08:47:00   2019-10-31T17:15:12 1 accepted 2 1 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 11619258 2019-10-29T16:26:00   2019-10-31T17:15:12 1 accepted 2 1 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 11628003 2019-10-31T15:51:00   2019-10-31T17:15:11 1 accepted 1 1 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 11627922 2019-10-31T15:35:00   2019-10-31T17:02:47 1 accepted 1 1 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 11627389 2019-10-31T14:02:00   2019-10-31T17:00:34 1 accepted 2 1 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 11627840 2019-10-31T15:23:00   2019-10-31T16:35:10 1 accepted 1 1 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 11628012 2019-10-31T15:52:00   2019-10-31T16:00:40 1 accepted 1 1 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 11628028 2019-10-31T15:54:00   2019-10-31T16:00:39 1 accepted 1 1 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 11627662 2019-10-31T14:52:00 2019-10-31T15:59:00 2019-10-31T15:59:00 2 i cut up the tree branch an put it in thr truck 1 1 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 11627920 2019-10-31T15:35:00   2019-10-31T15:45:09 1 accepted 1 1 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 11627900 2019-10-31T15:33:00   2019-10-31T15:40:10 1 accepted 1 1 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 11627727 2019-10-31T15:03:00   2019-10-31T15:10:09 1 accepted 1 1 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 11627517 2019-10-31T14:26:00   2019-10-31T14:35:08 1 accepted 1 1 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 11627357 2019-10-31T13:56:00   2019-10-31T14:25:09 1 accepted 1 1 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 11625499 2019-10-31T08:37:00   2019-10-31T14:15:08 1 in progress 1 1 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 11627160 2019-10-31T13:24:00   2019-10-31T14:00:44 1 accepted 2 1 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 11444616 2019-09-20T18:09:00 2019-10-31T13:51:37 2019-10-31T13:51:37 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: 14 1 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 11623780 2019-10-30T16:44:00   2019-10-31T13:46:02 1 closed 1 1 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 11528050 2019-10-09T13:47:02   2019-10-31T13:35:12 1 accepted 1 1 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 11627033 2019-10-31T13:04:00   2019-10-31T13:30:12 1 accepted 1 1 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 11608886 2019-10-27T13:57:43 2019-10-28T07:20:34 2019-10-31T13:16:00 2   1 1 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 11509805 2019-10-05T15:15:00   2019-10-31T12:55:10 1 accepted 2 1 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 11626860 2019-10-31T12:28:00   2019-10-31T12:35:11 1 accepted 1 1 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 11596081 2019-10-24T12:26:00   2019-10-31T12:30:10 1 accepted 1 1 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 11626424 2019-10-31T11:13:00   2019-10-31T12:00:11 1 accepted 1 1 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 11626533 2019-10-31T11:32:00   2019-10-31T11:40:26 1 accepted 1 1 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 11626477 2019-10-31T11:22:00   2019-10-31T11:40:23 1 accepted 1 1 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 11626538 2019-10-31T11:33:00   2019-10-31T11:40:14 1 accepted 1 1 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 11511885 2019-10-06T10:00:00   2019-10-31T11:40:13 1 accepted 1 1 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 11533780 2019-10-10T15:46:17   2019-10-31T11:40:09 1 accepted 1 1 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 11590897 2019-10-23T11:41:00   2019-10-31T11:35:11 1 accepted 1 1 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 11449867 2019-09-22T11:23:58   2019-10-31T10:55:14 1 accepted 1 1 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 11623938 2019-10-30T17:14:00 2019-10-31T10:49:05 2019-10-31T10:49:05 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 16 1 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 11623600 2019-10-30T16:14:00   2019-10-31T10:35:20 1 accepted 1 1 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 11623593 2019-10-30T16:12:00   2019-10-31T10:25:10 1 accepted 1 1 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 11625674 2019-10-31T09:07:00   2019-10-31T09:20:09 1 accepted 1 1 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 11625557 2019-10-31T08:47:00   2019-10-31T09:10:09 1 accepted 1 1 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 11625433 2019-10-31T08:26:00   2019-10-31T08:55:10 1 accepted 2 1 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 11625450 2019-10-31T08:28:46   2019-10-31T08:35:09 1 accepted 1 1 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 11608748 2019-10-27T13:27:00   2019-10-31T07:45:45 1 in progress 1 1 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 11608342 2019-10-27T11:54:00   2019-10-31T07:45:43 1 in progress 1 1 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 11227085 2019-08-05T09:02:00 2019-10-31T07:22:28 2019-10-31T07:22:28 2   1 1 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 11446379 2019-09-21T10:55:00   2019-10-31T05:35:00 1 sent 19 1 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 11609374 2019-10-27T15:58:00 2019-10-31T00:30:09 2019-10-31T00:30:09 2   1 1 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 11608000 2019-10-27T10:32:00 2019-10-31T00:30:08 2019-10-31T00:30:08 2   1 1 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 11607691 2019-10-27T09:25:00 2019-10-31T00:25:31 2019-10-31T00:25:31 2   1 1 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 11607681 2019-10-27T09:23:00 2019-10-31T00:25:28 2019-10-31T00:25:28 2   1 1 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 11608005 2019-10-27T10:33:02 2019-10-31T00:25:26 2019-10-31T00:25:26 2   1 1 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 11608734 2019-10-27T13:24:00 2019-10-31T00:25:26 2019-10-31T00:25:26 2   1 1 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 11608096 2019-10-27T10:54:00 2019-10-31T00:25:25 2019-10-31T00:25:25 2   1 1 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) Twitter pic.twitter.com/PJSBKjO0VW 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
93762 93762 11607510 2019-10-27T08:39:00 2019-10-31T00:25:21 2019-10-31T00:25:21 2   1 1 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 11607245 2019-10-27T06:49:00 2019-10-31T00:25:20 2019-10-31T00:25:20 2   1 1 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 11607894 2019-10-27T10:09:00 2019-10-31T00:25:20 2019-10-31T00:25:20 2   1 1 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 11607642 2019-10-27T09:12:00 2019-10-31T00:25:19 2019-10-31T00:25:19 2   1 1 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 11607453 2019-10-27T08:26:00 2019-10-31T00:25:18 2019-10-31T00:25:18 2   1 1 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 11608744 2019-10-27T13:26:00 2019-10-31T00:25:17 2019-10-31T00:25:17 2   1 1 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 11621063 2019-10-30T08:24:00 2019-10-30T22:15:34 2019-10-30T22:15:34 2 Request is a duplicate and has been previously reported as 11619759 2 1 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 11526123 2019-10-09T08:38:00   2019-10-30T19:12:12 1 sent 11 1 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
7798 7798 11624131 2019-10-30T18:01:00   2019-10-30T18:15:09 1 accepted 1 1 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
Powered by Datasette · Query took 179.329ms