calls

7,158 rows where Responsible_Agency = 2 sorted by Closed

View and edit SQL

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
1079 1079 5682449 2016-03-20T09:14:10   2016-03-20T09:36:28 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 90 VERNA ST, SAN FRANCISCO, CA, 94127 VERNA ST 7 Miraloma Park INGLESIDE 37.734508514404 -122.448432922363 POINT (-122.44843292 37.73450851) Web   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
4309 4309 11515675 2019-10-07T09:14:00   2019-10-07T10:00:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3274 26TH ST, SAN FRANCISCO, CA, 94110 26TH ST 9 Mission MISSION 37.749320983887 -122.41564178466801 POINT (-122.41564178 37.74932098) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
5384 5384 11585037 2019-10-22T11:06:00   2019-10-22T12:10:42 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of SUNSET BLVD and MORAGA ST SUNSET BLVD 4 Outer Sunset TARAVAL 37.755275726318004 -122.495361328125 POINT (-122.49536133 37.75527573) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
5504 5504 11585373 2019-10-22T11:55:00   2019-10-22T15:08:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2603 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789539033009994 -122.435863326343 POINT (-122.43586333 37.78953903) Mobile/Open311 http://mobile311.sfgov.org/reports/11585373/photos 102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
6924 6924 11613883 2019-10-28T15:27:00   2019-10-28T16:00:20 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CESAR CHAVEZ ST and FLORIDA ST CESAR CHAVEZ ST 9 Peralta Heights MISSION 37.748332977295 -122.40964508056601 POINT (-122.40964508 37.74833298) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
8199 8199 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1031 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719181060791 -122.396774291992 POINT (-122.39677429 37.71918106) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
8309 8309 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and HUDSON AVE WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.733631134033 -122.382278442383 POINT (-122.38227844 37.73363113) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
18140 18140 11155298 2019-07-20T11:03:00   2019-09-21T11:11:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BRADFORD ST and TOMPKINS AVE BRADFORD ST 9 Bernal Heights INGLESIDE 37.73685836792 -122.40975952148399 POINT (-122.40975952 37.73685837) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
20657 20657 11148097 2019-07-18T15:57:00   2019-10-10T11:08:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTCALM ST and WRIGHT ST MONTCALM ST 9 Peralta Heights INGLESIDE 37.747459411621 -122.405921936035 POINT (-122.40592194 37.74745941) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
21108 21108 11523861 2019-10-08T15:19:00   2019-10-18T13:37:22 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 17TH AVE and NORIEGA ST 17TH AVE 7 Golden Gate Heights TARAVAL 37.754333496094 -122.474334716797 POINT (-122.47433472 37.7543335) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
21857 21857 11531342 2019-10-10T09:29:00   2019-10-10T10:20:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 122 ROUSSEAU ST, SAN FRANCISCO, CA, 94112 ROUSSEAU ST 8 St. Mary's Park INGLESIDE 37.732772827148 -122.43030548095699 POINT (-122.43030548 37.73277283) Phone   93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
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
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
27709 27709 11601003 2019-10-25T12:38:00   2019-10-25T13:35:51 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 371 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Duboce Triangle PARK 37.771114349365 -122.42974853515601 POINT (-122.42974854 37.77111435) Phone   28 7 11 9 11 7 6 29,492 9 10 10   28   11             1         28
27710 27710 11601004 2019-10-25T12:38:00   2019-10-25T13:35:50 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 301 EXECUTIVE PARK BLVD, SAN FRANCISCO, CA, 94134 EXECUTIVE PARK BLVD 10 Candlestick Point SRA BAYVIEW 37.711143493652 -122.390769958496 POINT (-122.39076996 37.71114349) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
33916 33916 11614275 2019-10-28T16:36:00   2019-10-28T17:10:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CESAR CHAVEZ ST and NOE ST CESAR CHAVEZ ST 8 Noe Valley MISSION 37.74743270874 -122.43147277831999 POINT (-122.43147278 37.74743271) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
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
35411 35411 11617730 2019-10-29T12:24:00   2019-10-29T13:20:06 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 20TH ST and CHURCH ST 20TH ST 8 Dolores Heights MISSION 37.758087158203004 -122.428047180176 POINT (-122.42804718 37.75808716) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
35971 35971 11619231 2019-10-29T16:23:00   2019-10-29T17:05:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 215 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710277557373 -122.46923065185499 POINT (-122.46923065 37.71027756) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35976 35976 11619243 2019-10-29T16:25:00   2019-10-29T17:10:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 130 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711681365967 -122.46935272216801 POINT (-122.46935272 37.71168137) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
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
36243 36243 11619759 2019-10-29T18:04:00   2019-10-30T11:30:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of NORMANDIE TER and VALLEJO ST NORMANDIE TER 2 Pacific Heights NORTHERN 37.794505900000004 -122.44088870000002 POINT (-122.4408887 37.7945059) Web   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
36425 36425 11620103 2019-10-29T19:42:00   2019-10-30T10:40:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 176 LEE AVE, SAN FRANCISCO, CA, 94112 LEE AVE 11 Ingleside TARAVAL 37.721404619409 -122.454032478505 POINT (-122.45403248 37.72140462) Mobile/Open311 http://mobile311.sfgov.org/reports/11620103/photos 64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
36620 36620 11620630 2019-10-30T06:19:00   2019-10-30T11:30:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 58 ELLSWORTH ST, SAN FRANCISCO, CA, 94110 ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742154 -122.41458700000001 POINT (-122.414587 37.742154) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
36983 36983 11621288 2019-10-30T08:57:00   2019-10-30T10:50:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1319 25TH AVE, SAN FRANCISCO, CA, 94122 25TH AVE 4 Outer Sunset TARAVAL 37.76285649475 -122.483562867769 POINT (-122.48356287 37.76285649) Mobile/Open311 http://mobile311.sfgov.org/reports/11621288/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
37045 37045 11621408 2019-10-30T09:15:00   2019-10-30T10:55:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 99 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 MAGELLAN AVE 7 Forest Hill TARAVAL 37.748896 -122.46023600000001 POINT (-122.460236 37.748896) Mobile/Open311 http://mobile311.sfgov.org/reports/11621408/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
37533 37533 11622753 2019-10-30T13:44:00   2019-10-30T15:45:16 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2900 BUSH ST, SAN FRANCISCO, CA, 94115 BUSH ST 2 Lower Pacific Heights RICHMOND 37.785705 -122.44516899999999 POINT (-122.445169 37.785705) Mobile/Open311 http://mobile311.sfgov.org/reports/11622753/photos 103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
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
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
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
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
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
43816 43816 10886739 2019-05-20T13:55:00   2019-05-22T17:55:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 655 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.73722076416 -122.38280487060499 POINT (-122.38280487 37.73722076) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
44409 44409 11490692 2019-10-01T13:18:00   2019-10-01T14:30:13 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 95 MCCOPPIN ST, SAN FRANCISCO, CA, 94103 MCCOPPIN ST 6 South of Market SOUTHERN 37.771102905273 -122.422050476074 POINT (-122.42205048 37.77110291) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
44411 44411 11574866 2019-10-20T01:55:00   2019-10-20T02:25:36 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of TIFFANY AVE and VALENCIA ST TIFFANY AVE 9 Bernal Heights INGLESIDE 37.746574401855 -122.420127868652 POINT (-122.42012787 37.7465744) Phone http://mobile311.sfgov.org/reports/11574866/photos 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
44667 44667 11536012 2019-10-11T09:21:00   2019-10-22T11:11:22 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of HESTER AVE and BAY SHORE BLVD HESTER AVE 10 Visitacion Valley INGLESIDE 37.715339660645 -122.398994445801 POINT (-122.39899445 37.71533966) Phone   75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
45347 45347 11541521 2019-10-12T12:38:00   2019-10-12T13:10:24 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SAN JOSE AVE and SAINT MARYS AVE SAN JOSE AVE 8 St. Mary's Park INGLESIDE 37.734951019287 -122.428436279297 POINT (-122.42843628 37.73495102) Phone   93 9 5 2 5 2 4 28,861 7 2 2   93   5             1         93
45821 45821 11001547 2019-06-15T15:55:00   2019-09-24T11:40:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 36TH AVE and SANTIAGO ST 36TH AVE 4 Parkside TARAVAL 37.744113922119006 -122.494041442871 POINT (-122.49404144 37.74411392) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
46306 46306 11314161 2019-08-23T14:19:00   2019-10-18T15:34:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of JUNIPERO SERRA BLVD and OCEAN AVE JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.731204986571996 -122.47216033935499 POINT (-122.47216034 37.73120499) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
47007 47007 11409708 2019-09-13T08:24:00   2019-09-25T16:10:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CASTENADA AVE and SAN MARCOS AVE CASTENADA AVE 7 Forest Hill TARAVAL 37.746400008767 -122.464055644158 POINT (-122.46405564 37.74640001) Mobile/Open311 http://mobile311.sfgov.org/reports/11409708/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
47023 47023 11411057 2019-09-13T11:48:00   2019-09-27T09:45:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SAN JOSE AVE and OCEAN AVE SAN JOSE AVE 11 Mission Terrace INGLESIDE 37.722965240479 -122.44474792480499 POINT (-122.44474792 37.72296524) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2     70   80
47143 47143 11416342 2019-09-14T16:12:00   2019-09-24T08:00:58 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1632 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772065904708 -122.446262096588 POINT (-122.4462621 37.7720659) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
47415 47415 11426085 2019-09-17T07:40:00   2019-09-24T09:25:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1114 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Ashbury Heights PARK 37.763793945313 -122.449394226074 POINT (-122.44939423 37.76379395) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
47446 47446 11427239 2019-09-17T10:33:00   2019-09-27T10:20:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of HARNEY WAY and JAMESTOWN AVE HARNEY WAY 10 Candlestick Point SRA BAYVIEW 37.711162567139 -122.38645172119101 POINT (-122.38645172 37.71116257) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
51276 51276 11461171 2019-09-24T16:52:00   2019-10-11T08:00:36 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 529 PIERCE ST, SAN FRANCISCO, CA, 94117 PIERCE ST 5 Alamo Square NORTHERN 37.774842674879 -122.434405060599 POINT (-122.43440506 37.77484267) Mobile/Open311 http://mobile311.sfgov.org/reports/11461171/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
52196 52196 11463262 2019-09-25T09:13:00   2019-09-25T10:05:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PEMBERTON PL and VILLA TER PEMBERTON PL 8 Clarendon Heights PARK 37.758453369141 -122.44676971435499 POINT (-122.44676971 37.75845337) Phone   47 7 5 5 5 15 8 28,862 5 3 3   47   5             1         47
54207 54207 11469291 2019-09-26T12:42:00   2019-09-26T13:20:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH AVE and LINCOLN WAY 5TH AVE 5 Inner Sunset PARK 37.766109466553004 -122.462158203125 POINT (-122.4621582 37.76610947) Phone   109 7 11 14 11 11 8 29,492 5 12 12   109   11             1         109
55111 55111 11472317 2019-09-27T08:24:00   2019-10-21T08:26:30 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MASONIC AVE and GEARY BLVD MASONIC AVE 2 Lone Mountain RICHMOND 37.782390594482 -122.447303771973 POINT (-122.44730377 37.78239059) Phone   12 8 4 18 2 15 8 54 5 16 16   12   4             1     7   12
55223 55223 11472616 2019-09-27T09:10:00   2019-09-27T10:00:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 23RD ST and ARKANSAS ST 23RD ST 10 Potrero Hill BAYVIEW 37.754825592041 -122.39772796630899 POINT (-122.39772797 37.75482559) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
59386 59386 11490810 2019-10-01T13:36:00   2019-10-04T09:15:13 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 30TH AVE and CALIFORNIA ST 30TH AVE 2 Seacliff RICHMOND 37.783641815186 -122.49036407470699 POINT (-122.49036407 37.78364182) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
59992 59992 11511529 2019-10-06T08:20:00   2019-10-06T08:55:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DOLORES ST and MARKET ST DOLORES ST 8 Mission Dolores MISSION 37.76904296875 -122.426856994629 POINT (-122.42685699 37.76904297) Phone   37 3 5 20 5 8 7 28,862 4 19 19   37   5     5   9   2   5     37
60050 60050 11513655 2019-10-06T17:39:00   2019-10-06T18:10:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of VISITACION AVE and RUTLAND ST VISITACION AVE 10 Visitacion Valley INGLESIDE 37.711448669434 -122.407928466797 POINT (-122.40792847 37.71144867) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
60115 60115 11473778 2019-09-27T12:08:00   2019-10-07T16:00:33 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3400 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 10 Portola INGLESIDE 37.719013214111 -122.400535583496 POINT (-122.40053558 37.71901321) Phone   91 9 9 40 8 10 4 309 7 39 39   91   9             2         91
60632 60632 11475647 2019-09-27T17:53:00   2019-10-04T10:25:16 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 LAPIDGE ST, SAN FRANCISCO, CA, 94110 LAPIDGE ST 8 Mission Dolores MISSION 37.761123657227 -122.422485351563 POINT (-122.42248535 37.76112366) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
60951 60951 11576077 2019-10-20T12:07:00   2019-10-20T12:40:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 715 ROCKDALE DR, SAN FRANCISCO, CA, 94127 ROCKDALE DR 7 Miraloma Park INGLESIDE 37.741176605225 -122.451377868652 POINT (-122.45137787 37.74117661) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
62507 62507 11554852 2019-10-15T15:39:00   2019-10-15T16:25:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Phone   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
63103 63103 11572019 2019-10-19T09:34:00   2019-10-30T06:00:34 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3527 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758541107178004 -122.41967010498001 POINT (-122.4196701 37.75854111) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
64074 64074 9520126 2018-09-10T11:21:00   2019-10-22T13:24:58 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 718 BRUSSELS ST, SAN FRANCISCO, CA, 94134 BRUSSELS ST 9 Portola BAYVIEW 37.723255157471 -122.404106140137 POINT (-122.40410614 37.72325516) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
64230 64230 11386236 2019-09-08T14:43:00   2019-09-30T11:57:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of PORTOLA DR and SAN PABLO AVE PORTOLA DR 7 St. Francis Wood TARAVAL 37.740295410156 -122.46106719970699 POINT (-122.4610672 37.74029541) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
64422 64422 11448248 2019-09-21T19:42:00   2019-10-04T14:50:11 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 FILLMORE ST, SAN FRANCISCO, CA, 94117 FILLMORE ST 8 Duboce Triangle PARK 37.769954 -122.429992 POINT (-122.429992 37.769954) Mobile/Open311 http://mobile311.sfgov.org/reports/11448248/photos 28 7 5 9 5 7 6 29,492 9 10 10   28   5       20     1         28
67197 67197 11485842 2019-09-30T13:48:00   2019-10-30T15:40:13 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2435 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765654105542005 -122.410913196373 POINT (-122.4109132 37.76565411) Web http://mobile311.sfgov.org/reports/11485842/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
68207 68207 11557479 2019-10-16T09:53:00   2019-10-16T11:00:36 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1491 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.749370574951 -122.415626525879 POINT (-122.41562653 37.74937057) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
68478 68478 11558915 2019-10-16T13:16:00   2019-10-16T14:30:33 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 901 BAY SHORE BLVD, SAN FRANCISCO, CA, 94124 BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.732898712158 -122.404556274414 POINT (-122.40455627 37.73289871) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
70218 70218 11547960 2019-10-14T10:24:00   2019-10-14T10:55:29 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 426 BOSWORTH ST, SAN FRANCISCO, CA, 94112 BOSWORTH ST 8 St. Mary's Park INGLESIDE 37.73323059082 -122.431297302246 POINT (-122.4312973 37.73323059) Phone   93 9 5 28 5 2 4 28,861 7 25 25   93   5             1         93
70836 70836 10935496 2019-05-31T14:24:00   2019-10-04T15:13:25 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 123 BOUTWELL ST, SAN FRANCISCO, CA, 94124 BOUTWELL ST 10 Silver Terrace BAYVIEW 37.735378265380994 -122.405471801758 POINT (-122.4054718 37.73537827) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
71035 71035 11391895 2019-09-09T15:48:00   2019-10-01T12:50:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 55 GLENDALE ST, SAN FRANCISCO, CA, 94114 GLENDALE ST 8 Clarendon Heights PARK 37.756171566469 -122.44290104147301 POINT (-122.44290104 37.75617157) Mobile/Open311 http://mobile311.sfgov.org/reports/11391895/photos 47 7 5 38 5 2 8 28,862 5 38 38   47   5             1         47
71064 71064 11405157 2019-09-12T09:25:00   2019-10-26T10:20:22 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of EGBERT AVE and HAWES ST EGBERT AVE 10 Bret Harte BAYVIEW 37.720561981201 -122.388916015625 POINT (-122.38891602 37.72056198) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
71133 71133 10488270 2019-02-14T09:55:00   2019-03-13T10:15:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1106 BUSH ST, SAN FRANCISCO, CA, 94109 BUSH ST 3 Lower Nob Hill CENTRAL 37.789321777141 -122.415700837751 POINT (-122.41570084 37.78932178) Mobile/Open311   50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
71217 71217 11559156 2019-10-16T13:55:00   2019-10-16T15:00:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1853 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 8 Mint Hill SOUTHERN 37.77087020874 -122.42433929443399 POINT (-122.42433929 37.77087021) Phone   27 1 5 20 5 8 2 28,853 2 19 19   27   5   12     9   2         27
72042 72042 11607953 2019-10-27T10:21:00   2019-10-28T10:50:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 34 CAINE AVE, SAN FRANCISCO, CA, 94112 CAINE AVE 11 Oceanview TARAVAL 37.717670440674 -122.450386047363 POINT (-122.45038605 37.71767044) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
72852 72852 11374862 2019-09-05T16:35:00   2019-10-22T14:05:51 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NORIEGA ST and 12TH AVE NORIEGA ST 7 Golden Gate Heights TARAVAL 37.755218505859 -122.46891784668001 POINT (-122.46891785 37.75521851) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
73024 73024 11431296 2019-09-18T08:34:00   2019-10-03T10:35:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 33 RAUSCH ST, SAN FRANCISCO, CA, 94103 RAUSCH ST 6 South of Market SOUTHERN 37.776699066162 -122.40985107421899 POINT (-122.40985107 37.77669907) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
75797 75797 11598727 2019-10-25T01:12:00   2019-10-25T07:01:46 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 49 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.742828369141 -122.43597412109399 POINT (-122.43597412 37.74282837) Phone   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
75957 75957 11523299 2019-10-08T13:39:00   2019-10-08T15:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of ARELIOUS WALKER DR and HUDSON AVE ARELIOUS WALKER DR 10 India Basin BAYVIEW 37.731559753418004 -122.373329162598 POINT (-122.37332916 37.73155975) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
76173 76173 11450803 2019-09-22T15:28:00   2019-10-17T16:24:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of ROCKDALE DR and ISOLA WAY ROCKDALE DR 7 Miraloma Park INGLESIDE 37.741161346436 -122.450996398926 POINT (-122.4509964 37.74116135) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
78508 78508 11491072 2019-10-01T14:18:00   2019-10-01T15:05:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MISSION ST and 30TH ST MISSION ST 9 Bernal Heights INGLESIDE 37.742374420166 -122.42196655273399 POINT (-122.42196655 37.74237442) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
80375 80375 10384852 2019-01-21T11:49:00   2019-01-21T12:25:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of LELAND AVE and CORA ST LELAND AVE 10 Visitacion Valley INGLESIDE 37.712814331055 -122.40833282470699 POINT (-122.40833282 37.71281433) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
80639 80639 11589436 2019-10-23T09:10:00   2019-10-23T10:15:43 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 990 GREEN ST, SAN FRANCISCO, CA, 94133 GREEN ST 3 Russian Hill CENTRAL 37.798824310303004 -122.415351867676 POINT (-122.41535187 37.79882431) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
81558 81558 11278269 2019-08-15T20:44:00   2019-10-06T12:35:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of OGDEN AVE and BANKS ST OGDEN AVE 9 Bernal Heights INGLESIDE 37.735858917236 -122.412963867188 POINT (-122.41296387 37.73585892) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
81662 81662 11386173 2019-09-08T14:31:00   2019-10-17T09:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 301 CRESTMONT DR, SAN FRANCISCO, CA, 94131 CRESTMONT DR 7 Forest Knolls PARK 37.757305145264 -122.460060119629 POINT (-122.46006012 37.75730515) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
81701 81701 11532150 2019-10-10T11:31:00   2019-10-23T12:30:44 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2386 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Corona Heights PARK 37.765778333333 -122.43684499999999 POINT (-122.436845 37.76577833) Mobile/Open311 http://mobile311.sfgov.org/reports/11532150/photos 113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
82092 82092 11554350 2019-10-15T14:31:00   2019-10-18T11:30:36 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of OCEAN AVE and 19TH AVE OCEAN AVE 7 Merced Manor TARAVAL 37.732456207275 -122.474952697754 POINT (-122.4749527 37.73245621) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
84821 84821 11495386 2019-10-02T12:49:00   2019-10-02T14:05:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 370 NAPLES ST, SAN FRANCISCO, CA, 94112 NAPLES ST 11 Excelsior INGLESIDE 37.722927093505994 -122.429794311523 POINT (-122.42979431 37.72292709) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
87595 87595 9959066 2018-12-20T11:44:00   2019-04-26T17:30:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 3750 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754199981689 -122.44219970703101 POINT (-122.44219971 37.75419998) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
89894 89894 11504585 2019-10-04T11:26:00   2019-10-04T12:10:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of QUINTARA ST and 36TH AVE QUINTARA ST 4 Outer Sunset TARAVAL 37.747840881348 -122.494300842285 POINT (-122.49430084 37.74784088) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
91007 91007 11511123 2019-10-05T23:39:00   2019-10-06T00:10:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BRODERICK ST and FELL ST BRODERICK ST 5 Panhandle PARK 37.773845672607 -122.439277648926 POINT (-122.43927765 37.77384567) Phone   24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
91275 91275 9783759 2018-11-08T12:50:00   2019-01-23T14:40:02 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 263 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.70938873291 -122.469223022461 POINT (-122.46922302 37.70938873) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
91278 91278 9783716 2018-11-08T12:45:00   2019-01-23T15:05:33 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 229 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710018157959 -122.46923065185499 POINT (-122.46923065 37.71001816) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
91989 91989 9764382 2018-11-04T13:05:00   2019-02-13T15:15:03 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2140 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 2 Pacific Heights NORTHERN 37.788556799999995 -122.43112959999999 POINT (-122.4311296 37.7885568) Web http://mobile311.sfgov.org/reports/9764382/photos 102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
92309 92309 11533440 2019-10-10T14:49:00   2019-10-21T15:30:16 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DICHIERA CT and ELLINGTON AVE DICHIERA CT 11 Outer Mission INGLESIDE 37.712615966796996 -122.44621276855499 POINT (-122.44621277 37.71261597) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
92954 92954 9745896 2018-10-31T10:46:00   2019-04-24T09:50:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 200 DORE ST, SAN FRANCISCO, CA, 94103 DORE ST 6 South of Market SOUTHERN 37.77196706989 -122.410592411505 POINT (-122.41059241 37.77196707) Mobile/Open311 http://mobile311.sfgov.org/reports/9745896/photos 32 1 10 34 9 8 2 28,853 2 34 34   32   10             2         32
93310 93310 9739273 2018-10-30T07:12:00   2018-11-08T11:05:10 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of JONES ST and PINE ST JONES ST 3 Nob Hill CENTRAL 37.790462493896 -122.413917541504 POINT (-122.41391754 37.79046249) Phone   50 6 3 21 10 5 1 28,858 1 21 21   50   3             1         50
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
96917 96917 9690310 2018-10-18T14:25:00   2019-03-03T14:42:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3750 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754199981689 -122.44219970703101 POINT (-122.44219971 37.75419998) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
97837 97837 9669702 2018-10-14T09:54:00   2019-03-06T13:00:03 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 200 SHOTWELL ST, SAN FRANCISCO, CA, 94110 SHOTWELL ST 9 Mission MISSION 37.765044 -122.416397 POINT (-122.416397 37.765044) Mobile/Open311 http://mobile311.sfgov.org/reports/9669702/photos 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3     53
98345 98345 9644210 2018-10-08T16:37:00   2019-03-10T14:05:08 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1150 PRAGUE ST, SAN FRANCISCO, CA, 94112 PRAGUE ST 11 Crocker Amazon INGLESIDE 37.710144042969 -122.43894195556601 POINT (-122.43894196 37.71014404) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
100100 100100 9478555 2018-08-31T09:43:00   2019-01-08T08:20:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2367 37TH AVE, SAN FRANCISCO, CA, 94116 37TH AVE 4 Outer Sunset TARAVAL 37.742805406486 -122.494762223328 POINT (-122.49476222 37.74280541) Mobile/Open311 http://mobile311.sfgov.org/reports/9478555/photos 39 10 7 35 3 1 5 29,491 8 35 35   39   7   8         1         39
100101 100101 9478292 2018-08-31T09:06:00   2019-01-08T08:20:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1771 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.753949649667 -122.495730416963 POINT (-122.49573042 37.75394965) Mobile/Open311 http://mobile311.sfgov.org/reports/9478292/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
100102 100102 9478319 2018-08-31T09:10:00   2019-01-08T08:20:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1845 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.752530132456 -122.49537309643101 POINT (-122.4953731 37.75253013) Mobile/Open311 http://mobile311.sfgov.org/reports/9478319/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
102564 102564 9778952 2018-11-07T12:33:00   2018-11-14T13:50:18 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of AVALON AVE and NAPLES ST AVALON AVE 11 Excelsior INGLESIDE 37.725521087646 -122.427680969238 POINT (-122.42768097 37.72552109) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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))
Powered by Datasette · Query took 46.781ms