calls

Custom SQL query returning 101 rows (hide)

Query parameters

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
43 43 11535870 2019-10-11T08:56:58   2019-10-11T09:15:22 1 accepted 1 1 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 11509062 2019-10-05T12:19:00   2019-10-05T14:18:20 1 accepted 1 1 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 5694342 2016-03-23T18:50:33   2016-03-23T18:51:40 1 open 1 1 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 11548402 2019-10-14T11:27:00   2019-10-14T11:35:27 1 accepted 1 1 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 11548490 2019-10-14T11:41:00   2019-10-14T12:10:32 1 accepted 1 1 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 11611037 2019-10-28T08:24:00   2019-10-28T09:50:05 1 accepted 1 1 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 11549544 2019-10-14T14:52:21   2019-10-14T15:25:28 1 accepted 1 1 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 11611992 2019-10-28T10:39:00   2019-10-29T15:15:05 1 in progress 1 1 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 11618478 2019-10-29T14:21:00   2019-10-29T15:26:16 1 accepted 1 1 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 5682449 2016-03-20T09:14:10   2016-03-20T09:36:28 1 open 2 1 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 10708134 2019-04-09T15:51:00   2019-10-22T07:56:54 1 accepted 1 1 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 11249723 2019-08-09T15:02:00   2019-10-22T10:49:45 1 accepted 1 1 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 11281111 2019-08-16T13:26:00   2019-10-22T14:44:19 1 accepted 1 1 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 11368089 2019-09-04T12:29:00   2019-10-22T22:10:46 1 accepted 1 1 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 11304398 2019-08-21T15:07:00   2019-10-11T15:58:46 1 accepted 1 1 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 10924592 2019-05-29T12:33:00   2019-06-10T15:46:10 1 open 1 1 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 11486922 2019-09-30T16:42:00   2019-10-07T07:43:27 1 sent 6 1 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 11583314 2019-10-22T05:06:00   2019-10-22T05:40:41 1 accepted 1 1 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 11514506 2019-10-07T00:22:48   2019-10-07T00:30:15 1 accepted 1 1 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 11583551 2019-10-22T07:30:00   2019-10-22T08:00:44 1 accepted 1 1 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 11515675 2019-10-07T09:14:00   2019-10-07T10:00:39 1 accepted 2 1 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 11516785 2019-10-07T11:32:22   2019-10-07T12:15:18 1 accepted 1 1 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 11516786 2019-10-07T11:32:33   2019-10-29T18:35:58 1 accepted 1 1 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 11517195 2019-10-07T12:18:00   2019-10-07T12:30:21 1 accepted 1 1 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 11517473 2019-10-07T12:57:00   2019-10-07T14:00:45 1 accepted 1 1 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 11517758 2019-10-07T13:33:17   2019-10-07T13:40:17 1 accepted 1 1 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 11517764 2019-10-07T13:34:07   2019-10-07T13:40:17 1 accepted 1 1 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 11517833 2019-10-07T13:44:00   2019-10-21T15:31:08 1 accepted 1 1 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 11584425 2019-10-22T09:31:00   2019-10-22T09:40:47 1 accepted 1 1 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 11518419 2019-10-07T15:09:00   2019-10-07T16:00:35 1 accepted 1 1 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 11584535 2019-10-22T09:48:01   2019-10-22T09:55:42 1 accepted 1 1 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 11518643 2019-10-07T15:38:00   2019-10-07T15:50:17 1 accepted 1 1 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 11584627 2019-10-22T10:04:00   2019-10-22T11:15:44 1 accepted 1 1 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 11518880 2019-10-07T16:15:00   2019-10-20T12:04:28 1 accepted 1 1 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 11584772 2019-10-22T10:27:00   2019-10-22T10:39:52 1 open 1 1 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 11585037 2019-10-22T11:06:00   2019-10-22T12:10:42 1 accepted 2 1 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 11519264 2019-10-07T17:24:00   2019-10-07T17:35:16 1 accepted 1 1 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 11585234 2019-10-22T11:37:00   2019-10-22T11:45:56 1 accepted 1 1 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 11585356 2019-10-22T11:53:04   2019-10-22T13:00:44 1 accepted 1 1 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 11585373 2019-10-22T11:55:00   2019-10-22T15:08:32 1 accepted 2 1 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 11519734 2019-10-07T19:18:00   2019-10-23T11:17:30 1 accepted 1 1 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 11585580 2019-10-22T12:28:00   2019-10-22T12:35:47 1 accepted 1 1 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 11519949 2019-10-07T20:52:32   2019-10-07T21:00:22 1 accepted 1 1 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 11586288 2019-10-22T14:09:00   2019-10-22T14:20:43 1 accepted 1 1 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 11586668 2019-10-22T15:11:41   2019-10-22T15:55:43 1 accepted 1 1 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 11525260 2019-10-08T21:43:00   2019-10-09T00:38:14 1 sent 7 1 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 11528031 2019-10-09T13:43:00   2019-10-09T13:50:22 1 accepted 1 1 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 11602298 2019-10-25T16:12:00   2019-10-25T16:40:50 1 accepted 1 1 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 11538643 2019-10-11T16:13:00   2019-10-15T07:50:30 1 in progress 1 1 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 11611574 2019-10-28T09:41:00   2019-10-28T09:50:07 1 accepted 1 1 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 11613807 2019-10-28T15:17:00   2019-10-29T10:20:34 1 accepted 1 1 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 11613883 2019-10-28T15:27:00   2019-10-28T16:00:20 1 accepted 2 1 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 11620909 2019-10-30T08:01:00   2019-10-30T08:30:13 1 accepted 1 1 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 11617465 2019-10-29T11:43:00   2019-10-29T11:50:12 1 accepted 1 1 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 9876964 2018-12-01T13:39:00   2018-12-01T14:45:08 1 accepted 1 1 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 11523120 2019-10-08T13:14:43   2019-10-08T13:20:17 1 accepted 1 1 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 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
7732 7732 11554557 2019-10-15T14:58:00   2019-10-15T15:05:29 1 accepted 1 1 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 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
7884 7884 9137778 2018-06-14T15:03:00   2019-10-07T11:22:00 1 accepted 1 1 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 9813428 2018-11-15T14:11:00   2019-10-07T08:34:46 1 accepted 1 1 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 10995190 2019-06-14T08:48:00   2019-10-08T15:55:19 1 accepted 1 1 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 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 1 accepted 2 1 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 11622531 2019-10-30T12:14:01   2019-10-30T12:20:07 1 accepted 1 1 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 11274433 2019-08-15T08:48:00   2019-10-08T17:37:37 1 accepted 1 1 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 11367641 2019-09-04T11:24:58   2019-10-08T13:10:19 1 accepted 1 1 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 11386228 2019-09-08T14:42:00   2019-10-10T08:15:25 1 in progress 1 1 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 11394197 2019-09-10T08:28:00   2019-10-09T06:10:24 1 accepted 3 1 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 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 1 accepted 2 1 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 11013873 2019-06-18T14:50:00   2019-10-30T14:55:08 1 accepted 1 1 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 11265998 2019-08-13T12:16:00   2019-10-23T09:35:42 1 accepted 1 1 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 11482122 2019-09-29T17:30:00   2019-10-08T12:08:05 1 accepted 8 1 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 11520818 2019-10-08T07:55:08   2019-10-08T08:00:42 1 accepted 1 1 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 11521237 2019-10-08T08:53:00   2019-10-08T09:00:42 1 accepted 1 1 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 11521878 2019-10-08T10:19:00   2019-10-08T11:30:25 1 accepted 1 1 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 11522140 2019-10-08T10:56:00   2019-10-08T12:07:53 1 accepted 1 1 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 11522242 2019-10-08T11:12:34   2019-10-08T12:50:21 1 accepted 1 1 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 11522481 2019-10-08T11:40:10   2019-10-08T11:45:21 1 accepted 1 1 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 11523007 2019-10-08T12:59:00   2019-10-08T13:10:28 1 accepted 1 1 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 11523150 2019-10-08T13:18:52   2019-10-08T13:25:19 1 accepted 1 1 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 11523644 2019-10-08T14:39:00   2019-10-30T12:20:08 1 accepted 1 1 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 11523858 2019-10-08T15:18:00   2019-10-08T16:06:54 1 accepted 1 1 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 11525199 2019-10-08T21:09:00   2019-10-08T21:25:21 1 accepted 1 1 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 11588776 2019-10-23T08:01:00   2019-10-23T08:30:47 1 accepted 1 1 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 11589179 2019-10-23T08:46:00   2019-10-23T09:30:44 1 accepted 1 1 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 11589182 2019-10-23T08:46:00   2019-10-23T08:55:43 1 accepted 1 1 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 11589271 2019-10-23T08:54:08   2019-10-23T09:00:43 1 accepted 1 1 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 11590046 2019-10-23T10:11:23   2019-10-23T10:20:43 1 accepted 1 1 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 11590331 2019-10-23T10:37:00   2019-10-23T11:40:54 1 accepted 1 1 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 11591402 2019-10-23T13:05:00   2019-10-23T13:15:46 1 accepted 1 1 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 11591509 2019-10-23T13:22:00   2019-10-23T15:05:42 1 accepted 1 1 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 11591922 2019-10-23T14:26:00   2019-10-23T14:35:44 1 accepted 1 1 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 11592221 2019-10-23T15:20:00   2019-10-23T15:40:47 1 accepted 1 1 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 11592319 2019-10-23T15:39:00   2019-10-23T15:45:43 1 accepted 1 1 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 11592792 2019-10-23T16:59:35   2019-10-23T17:05:43 1 accepted 1 1 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 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
13167 13167 11531820 2019-10-10T10:41:00   2019-10-10T10:50:24 1 accepted 1 1 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 11532168 2019-10-10T11:35:18   2019-10-10T11:40:22 1 accepted 1 1 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 11535256 2019-10-11T06:13:00   2019-10-11T06:20:22 1 accepted 1 1 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 11604606 2019-10-26T10:40:00   2019-10-26T11:15:50 1 accepted 1 1 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
13523 13523 11608225 2019-10-27T11:26:00   2019-10-29T14:00:12 1 in progress 1 1 1 About_to_fall 617 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Lower Haight NORTHERN 37.774005889893 -122.429527282715 POINT (-122.42952728 37.77400589) Phone   26 4 11 9 11 7 6 29,492 9 10 10   26   11             1         26
Powered by Datasette · Query took 47.231ms