calls

80,878 rows where Category = 1 sorted by Status

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
13523 13523 11608225 2019-10-27T11:26:00   2019-10-29T14:00:12 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 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
13536 13536 11608842 2019-10-27T13:49:00   2019-10-27T14:00:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of TARA ST and GENEVA AVE TARA ST 11 Oceanview TARAVAL 37.721397399902 -122.44841003418001 POINT (-122.44841003 37.7213974) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
13564 13564 11368001 2019-09-04T12:18:00   2019-10-15T11:29:26 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 439 GREENWICH ST, SAN FRANCISCO, CA, 94133 GREENWICH ST 3 Telegraph Hill CENTRAL 37.802501678467 -122.407028198242 POINT (-122.4070282 37.80250168) Phone   18 6 3 23 10 3 1 308 1 23 23   18   3       23     1         18
13621 13621 11609875 2019-10-27T18:40:00   2019-10-28T06:15:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 314 PACHECO ST, SAN FRANCISCO, CA, 94116 PACHECO ST 7 Forest Hill TARAVAL 37.748302459717 -122.46240234375 POINT (-122.46240234 37.74830246) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
13822 13822 11436869 2019-09-19T10:24:37   2019-10-07T10:35:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1050 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.778998120602004 -122.408549997126 POINT (-122.40855 37.77899812) Mobile/Open311 http://mobile311.sfgov.org/reports/11436869/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
14229 14229 11398622 2019-09-10T22:37:06   2019-10-07T09:45:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 410 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.783771666667 -122.414588333333 POINT (-122.41458833 37.78377167) Mobile/Open311 http://mobile311.sfgov.org/reports/11398622/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20 1 10 18     18 6 1 2 1       20
14370 14370 11491511 2019-10-01T15:21:00   2019-10-08T13:20:50 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 1253 17TH AVE, SAN FRANCISCO, CA, 94122 17TH AVE 4 Inner Sunset TARAVAL 37.764484405518 -122.47518157959 POINT (-122.47518158 37.76448441) Phone   109 10 7 14 3 11 5 56 8 12 12   109   7             1         109
14413 14413 11371629 2019-09-05T08:28:00   2019-10-07T06:05:39 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 34TH AVE and NORIEGA ST 34TH AVE 4 Outer Sunset TARAVAL 37.753532409668004 -122.49254608154301 POINT (-122.49254608 37.75353241) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
14557 14557 11339611 2019-08-29T08:24:00   2019-10-07T10:05:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 60 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.781170700000004 -122.4135524 POINT (-122.4135524 37.7811707) Web http://mobile311.sfgov.org/reports/11339611/photos 20 5 10 36 9 7 10 28,852 10 36 36   20 1 10     1   6 1 2 1 1     20
14574 14574 11335785 2019-08-28T11:23:00   2019-10-08T12:55:27 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3402 CLAY ST, SAN FRANCISCO, CA, 94118 CLAY ST 2 Presidio Heights RICHMOND 37.788928985596 -122.44912719726601 POINT (-122.4491272 37.78892899) Phone   10 8 6 31 1 13 9 54 6 31 31   10   6             1         10
14663 14663 11298889 2019-08-20T14:19:00   2019-10-08T13:00:54 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1901 JACKSON ST, SAN FRANCISCO, CA, 94109 JACKSON ST 2 Pacific Heights NORTHERN 37.793365478516 -122.42653656005899 POINT (-122.42653656 37.79336548) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
14797 14797 11109328 2019-07-10T11:32:58   2019-10-07T22:10:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 19 TOPAZ WAY, SAN FRANCISCO, CA, 94131 TOPAZ WAY 8 Diamond Heights INGLESIDE 37.742594372073995 -122.43755057147699 POINT (-122.43755057 37.74259437) Mobile/Open311 http://mobile311.sfgov.org/reports/11109328/photos 57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
14911 14911 10972443 2019-06-09T10:00:24   2019-10-08T13:05:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2016 PACIFIC AVE, SAN FRANCISCO, CA, 94109 PACIFIC AVE 2 Pacific Heights NORTHERN 37.794364 -122.428918 POINT (-122.428918 37.794364) Web http://mobile311.sfgov.org/reports/10972443/photos 102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
14917 14917 10916967 2019-05-28T08:07:15   2019-10-08T22:10:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 855 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Lower Haight NORTHERN 37.773549459826995 -122.43330639633498 POINT (-122.4333064 37.77354946) Mobile/Open311 http://mobile311.sfgov.org/reports/10916967/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
14987 14987 11613559 2019-10-28T14:38:00   2019-10-28T14:50:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1303 LARKIN ST, SAN FRANCISCO, CA, 94109 LARKIN ST 3 Polk Gulch CENTRAL 37.790065765380994 -122.41925048828101 POINT (-122.41925049 37.79006577) Phone   105 4 3 21 10 13 6 28,858 9 21 21   105   3         10   1         105
14990 14990 10354913 2019-01-14T10:46:00   2019-10-08T13:36:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1370 4TH AVE, SAN FRANCISCO, CA, 94122 4TH AVE 5 Inner Sunset PARK 37.763179779053004 -122.460723876953 POINT (-122.46072388 37.76317978) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
15032 15032 8179933 2017-10-24T12:15:00   2019-10-07T11:08:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 320 SILLIMAN ST, SAN FRANCISCO, CA, 94134 SILLIMAN ST 9 Portola BAYVIEW 37.730438232421996 -122.408531188965 POINT (-122.40853119 37.73043823) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
15082 15082 11614062 2019-10-28T15:58:00   2019-10-28T16:30:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 246 MUNICH ST, SAN FRANCISCO, CA, 94112 MUNICH ST 11 Excelsior INGLESIDE 37.721755981445 -122.426322937012 POINT (-122.42632294 37.72175598) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
15351 15351 5670633 2016-03-16T10:36:20   2016-03-16T10:41:53 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of LARKIN ST and GREENWICH ST LARKIN ST 2 Russian Hill CENTRAL 37.80083344221 -122.42106432207501 POINT (-122.42106432 37.80083344) Phone   107 6 6 32 1 5 6 28,858 9 32 32   107   6             1         107
15541 15541 5670362 2016-03-16T09:49:35   2016-03-16T09:52:09 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 155 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 6 South of Market SOUTHERN 37.770650780128 -122.422387662652 POINT (-122.42238766 37.77065078) Phone   32 1 2 20 7 8 2 28,853 2 19 19   32   2             2         32
16042 16042 11511885 2019-10-06T10:00:00   2019-10-31T11:40:13 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 606 KANSAS ST, SAN FRANCISCO, CA, 94107 KANSAS ST 10 Potrero Hill BAYVIEW 37.761909484863 -122.403427124023 POINT (-122.40342712 37.76190948) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
16075 16075 11511951 2019-10-06T10:10:07   2019-10-06T10:15:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1100 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 5 Cathedral Hill NORTHERN 37.783916666667 -122.423845 POINT (-122.423845 37.78391667) Mobile/Open311 http://mobile311.sfgov.org/reports/11511951/photos 100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
16630 16630 11513414 2019-10-06T16:22:00   2019-10-06T16:41:52 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3677 22ND ST, SAN FRANCISCO, CA, 94114 22ND ST 8 Dolores Heights MISSION 37.754771257037 -122.429459812731 POINT (-122.42945981 37.75477126) Mobile/Open311   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
16846 16846 11514415 2019-10-06T22:46:54   2019-10-06T22:55:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 451 BRODERICK ST, SAN FRANCISCO, CA, 94117 BRODERICK ST 5 Panhandle PARK 37.774565796166 -122.439481362665 POINT (-122.43948136 37.7745658) Mobile/Open311   24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
17009 17009 8353784 2017-12-06T13:14:00   2018-12-10T10:31:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2272 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.764930725098 -122.432510375977 POINT (-122.43251038 37.76493073) Phone   28 7 5 5 5 15 8 28,862 5 3 3   28   5   12     9   1   5     28
17187 17187 10716672 2019-04-11T12:55:00   2019-10-21T08:53:48 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2038 10TH AVE, SAN FRANCISCO, CA, 94116 10TH AVE 7 Forest Hill TARAVAL 37.750186920166 -122.466255187988 POINT (-122.46625519 37.75018692) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
18124 18124 11576571 2019-10-20T14:12:00   2019-10-27T09:01:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 106 3RD AVE, SAN FRANCISCO, CA, 94118 3RD AVE 2 Presidio Terrace RICHMOND 37.786487 -122.4612534 POINT (-122.4612534 37.786487) Web   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
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
18293 18293 11523897 2019-10-08T15:25:00   2019-10-08T16:35:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 704 POLK ST, SAN FRANCISCO, CA, 94109 POLK ST 6 Tenderloin NORTHERN 37.783275 -122.419183 POINT (-122.419183 37.783275) Mobile/Open311 http://mobile311.sfgov.org/reports/11523897/photos 20 4 10 36 9 7 6 28,858 9 36 36   20 1 10           1 2 1       20
18403 18403 11577836 2019-10-20T22:56:00   2019-10-21T00:40:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 381 WILDE AVE, SAN FRANCISCO, CA, 94134 WILDE AVE 10 Visitacion Valley INGLESIDE 37.716939900816 -122.40466032726002 POINT (-122.40466033 37.7169399) Mobile/Open311   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
18703 18703 11579091 2019-10-21T09:39:13   2019-10-21T09:45:40 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 201 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.763717 -122.398323 POINT (-122.398323 37.763717) Mobile/Open311 http://mobile311.sfgov.org/reports/11579091/photos 54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
18924 18924 11580249 2019-10-21T12:15:00   2019-10-21T12:25:45 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 797 14TH AVE, SAN FRANCISCO, CA, 94118 14TH AVE 1 Inner Richmond RICHMOND 37.773319244385 -122.472496032715 POINT (-122.47249603 37.77331924) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
18980 18980 11580687 2019-10-21T13:09:00   2019-10-21T15:49:44 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 401 DELLBROOK AVE, SAN FRANCISCO, CA, 94131 DELLBROOK AVE 7 Clarendon Heights PARK 37.753601074219 -122.452850341797 POINT (-122.45285034 37.75360107) Other Department   47 7 8 38 4 1 8 63 5 38 38   47   8             1         47
19050 19050 11581237 2019-10-21T14:27:58   2019-10-21T16:19:23 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 652 17TH AVE, SAN FRANCISCO, CA, 94121 17TH AVE 1 Inner Richmond RICHMOND 37.775699700000004 -122.47562669999999 POINT (-122.4756267 37.7756997) Web http://mobile311.sfgov.org/reports/11581237/photos 5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
19055 19055 11581334 2019-10-21T14:42:00   2019-10-21T16:19:27 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2281 CECILIA AVE, SAN FRANCISCO, CA, 94116 CECILIA AVE 7 Golden Gate Heights TARAVAL 37.745300292969 -122.47219085693399 POINT (-122.47219086 37.74530029) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
19062 19062 11581363 2019-10-21T14:45:00   2019-10-21T16:19:28 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 674 VIENNA ST, SAN FRANCISCO, CA, 94112 VIENNA ST 11 Excelsior INGLESIDE 37.717819213867 -122.432571411133 POINT (-122.43257141 37.71781921) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
19117 19117 11581973 2019-10-21T16:28:52   2019-10-21T16:35:40 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 182 BANKS ST, SAN FRANCISCO, CA, 94110 BANKS ST 9 Bernal Heights INGLESIDE 37.7404162 -122.4128678 POINT (-122.4128678 37.7404162) Web http://mobile311.sfgov.org/reports/11581973/photos 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
19517 19517 10984577 2019-06-11T21:28:18   2019-06-11T22:10:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of FRIEDELL ST and HUDSON AVE FRIEDELL ST 10 Hunters Point BAYVIEW 37.729016666667 -122.369011666667 POINT (-122.36901167 37.72901667) Mobile/Open311 http://mobile311.sfgov.org/reports/10984577/photos 78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
19778 19778 11533780 2019-10-10T15:46:17   2019-10-31T11:40:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 415 DE HARO ST, SAN FRANCISCO, CA, 94103 DE HARO ST 10 Potrero Hill SOUTHERN 37.7645888 -122.4013138 POINT (-122.4013138 37.7645888) Web   54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
20562 20562 9440840 2018-08-23T08:16:00   2019-10-09T10:06:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 627 WISCONSIN ST, SAN FRANCISCO, CA, 94107 WISCONSIN ST 10 Potrero Hill BAYVIEW 37.75899887085 -122.39892578125 POINT (-122.39892578 37.75899887) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
20635 20635 10571474 2019-03-06T18:25:11   2019-10-10T09:00:35 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 501 SCOTT ST, SAN FRANCISCO, CA, 94117 SCOTT ST 5 Alamo Square NORTHERN 37.774545415225 -122.43603408084499 POINT (-122.43603408 37.77454542) Mobile/Open311 http://mobile311.sfgov.org/reports/10571474/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
20637 20637 10763422 2019-04-22T15:43:00   2019-10-10T09:48:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1980 8TH AVE, SAN FRANCISCO, CA, 94116 8TH AVE 7 Forest Hill TARAVAL 37.751396179199 -122.46422576904301 POINT (-122.46422577 37.75139618) Phone   45 10 8 14 4 1 5 29,491 8 12 12   45   8             1         45
20641 20641 10845535 2019-05-10T14:40:00   2019-10-10T12:02:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 285 SEACLIFF AVE, SAN FRANCISCO, CA, 94121 SEACLIFF AVE 2 Seacliff RICHMOND 37.788459777831996 -122.489402770996 POINT (-122.48940277 37.78845978) Phone   1 8 6 33 1 11 9 55 6 33 33   1   6             1         1
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
20677 20677 11296821 2019-08-20T09:42:56   2019-10-10T13:00:30 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 48 PALOMA AVE, SAN FRANCISCO, CA, 94127 PALOMA AVE 7 Ingleside Terraces TARAVAL 37.729032730814 -122.4688602 POINT (-122.4688602 37.72903273) Web http://mobile311.sfgov.org/reports/11296821/photos 67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
20693 20693 11383528 2019-09-07T17:08:00   2019-10-10T01:30:27 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 900 POWHATTAN AVE, SAN FRANCISCO, CA, 94110 POWHATTAN AVE 9 Bernal Heights INGLESIDE 37.741302490234 -122.411064147949 POINT (-122.41106415 37.74130249) Phone http://mobile311.sfgov.org/reports/11383528/photos 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
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
21465 21465 11529866 2019-10-09T19:42:41   2019-10-10T15:25:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 15 BURLWOOD DR, SAN FRANCISCO, CA, 94127 BURLWOOD DR 7 Sherwood Forest INGLESIDE 37.734940394221 -122.45500579031 POINT (-122.45500579 37.73494039) Mobile/Open311 http://mobile311.sfgov.org/reports/11529866/photos 117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
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
21962 21962 11531808 2019-10-10T10:40:00   2019-10-10T10:50:24 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 769 14TH AVE, SAN FRANCISCO, CA, 94118 14TH AVE 1 Inner Richmond RICHMOND 37.773696899414 -122.47248840331999 POINT (-122.4724884 37.7736969) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
21968 21968 11531841 2019-10-10T10:44:00   2019-10-10T10:55:24 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 769 14TH AVE, SAN FRANCISCO, CA, 94118 14TH AVE 1 Inner Richmond RICHMOND 37.773696899414 -122.47248840331999 POINT (-122.4724884 37.7736969) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
22068 22068 11532304 2019-10-10T11:51:00   2019-10-10T12:00:34 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 128 CLIPPER ST, SAN FRANCISCO, CA, 94114 CLIPPER ST 8 Noe Valley MISSION 37.749347686768 -122.428009033203 POINT (-122.42800903 37.74934769) Phone   84 3 5 22 5 2 7 28,862 4 22 22   84   5             1         84
22071 22071 11532323 2019-10-10T11:54:00   2019-10-10T12:29:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 828 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 India Basin BAYVIEW 37.731573 -122.3744662 POINT (-122.3744662 37.731573) Web http://mobile311.sfgov.org/reports/11532323/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
22075 22075 11532343 2019-10-10T11:57:17   2019-10-10T12:50:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3535 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 8 Mission Dolores MISSION 37.759907 -122.422193 POINT (-122.422193 37.759907) Mobile/Open311 http://mobile311.sfgov.org/reports/11532343/photos 37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
22143 22143 11532676 2019-10-10T12:42:39   2019-10-10T12:50:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1421 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.751132 -122.40423899999999 POINT (-122.404239 37.751132) Mobile/Open311 http://mobile311.sfgov.org/reports/11532676/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
22192 22192 11532932 2019-10-10T13:27:00   2019-10-31T22:35:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 1123 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Hunters Point BAYVIEW 37.72883605957 -122.38214111328101 POINT (-122.38214111 37.72883606) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
22242 22242 11533306 2019-10-10T14:27:00   2019-10-10T14:35:25 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 16TH ST and SAN BRUNO AVE 16TH ST 10 Potrero Hill MISSION 37.765899658203004 -122.405586242676 POINT (-122.40558624 37.76589966) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
22311 22311 11533651 2019-10-10T15:21:00   2019-10-10T15:35:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1751 CARROLL AVE, SAN FRANCISCO, CA, 94124 CARROLL AVE 10 Bayview BAYVIEW 37.72615814209 -122.39556884765601 POINT (-122.39556885 37.72615814) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
22316 22316 11533673 2019-10-10T15:25:21   2019-10-10T15:55:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3555 CALIFORNIA ST, SAN FRANCISCO, CA, 94118 CALIFORNIA ST 2 Laurel Heights / Jordan Park RICHMOND 37.786324 -122.4526558 POINT (-122.4526558 37.786324) Web http://mobile311.sfgov.org/reports/11533673/photos 11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
22346 22346 11533873 2019-10-10T16:05:28   2019-10-30T14:10:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 18 TOPAZ WAY, SAN FRANCISCO, CA, 94131 TOPAZ WAY 8 Diamond Heights INGLESIDE 37.742387 -122.437749 POINT (-122.437749 37.742387) Web   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
22374 22374 11534030 2019-10-10T16:36:13   2019-10-10T17:10:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1814 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition PARK 37.777445 -122.44203 POINT (-122.44203 37.777445) Mobile/Open311 http://mobile311.sfgov.org/reports/11534030/photos 97 7 11 18 11 15 8 29,490 5 16 16   97   11             1         97
22401 22401 11534178 2019-10-10T16:58:00   2019-10-10T17:15:25 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 215 AVILA ST, SAN FRANCISCO, CA, 94123 AVILA ST 2 Marina NORTHERN 37.802808209226 -122.440864490807 POINT (-122.44086449 37.80280821) Web   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
22590 22590 11536735 2019-10-11T11:03:12   2019-10-11T12:00:36 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1298 THOMAS AVE, SAN FRANCISCO, CA, 94124 THOMAS AVE 10 Hunters Point BAYVIEW 37.727312 -122.385581 POINT (-122.385581 37.727312) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
22608 22608 11537841 2019-10-11T13:56:00   2019-10-11T14:05:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of CONGDON ST and MAYNARD ST CONGDON ST 11 Mission Terrace INGLESIDE 37.729396820068004 -122.426025390625 POINT (-122.42602539 37.72939682) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
22930 22930 11563304 2019-10-17T11:25:00   2019-10-17T11:35:33 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 645 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 6 Lower Nob Hill CENTRAL 37.786869049071996 -122.416694641113 POINT (-122.41669464 37.78686905) Phone   50 6 10 36 9 13 1 28,858 1 36 36   50   10             2         50
22940 22940 11623465 2019-10-30T15:33:58   2019-10-30T15:40:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 274 DOLORES ST, SAN FRANCISCO, CA, 94103 DOLORES ST 8 Mission Dolores MISSION 37.765024 -122.42658600000001 POINT (-122.426586 37.765024) Mobile/Open311 http://mobile311.sfgov.org/reports/11623465/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
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
23143 23143 10983652 2019-06-11T17:10:00   2019-10-30T12:30:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2369 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.762832641602 -122.434379577637 POINT (-122.43437958 37.76283264) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12   1 9   1   5     38
23144 23144 10984770 2019-06-11T23:37:56   2019-10-30T15:40:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4030 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 8 St. Mary's Park INGLESIDE 37.733045000000004 -122.427151 POINT (-122.427151 37.733045) Mobile/Open311 http://mobile311.sfgov.org/reports/10984770/photos 93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
23153 23153 11022281 2019-06-20T10:20:00   2019-10-31T22:36:58 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 46 DAY ST, SAN FRANCISCO, CA, 94110 DAY ST 8 Noe Valley INGLESIDE 37.743179321289 -122.423622131348 POINT (-122.42362213 37.74317932) Phone   84 9 5 22 5 2 4 28,859 7 22 22   84   5             1         84
23188 23188 11139597 2019-07-17T08:09:00   2019-10-30T08:36:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 325 RICHLAND AVE, SAN FRANCISCO, CA, 94110 RICHLAND AVE 9 Holly Park INGLESIDE 37.735836029053004 -122.419403076172 POINT (-122.41940308 37.73583603) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
23203 23203 11228867 2019-08-05T12:39:00   2019-10-27T10:33:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3631 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94110 CESAR CHAVEZ ST 9 Bernal Heights MISSION 37.747955322266 -122.421730041504 POINT (-122.42173004 37.74795532) Phone   83 3 2 22 7 2 7 28,859 4 22 22   83   2             1         83
23206 23206 11234658 2019-08-06T14:02:00   2019-10-30T11:05:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 761 NOE ST, SAN FRANCISCO, CA, 94114 NOE ST 8 Dolores Heights MISSION 37.756771087646 -122.43220520019501 POINT (-122.4322052 37.75677109) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
23312 23312 11459733 2019-09-24T12:38:00   2019-10-31T22:30:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 160 STRATFORD DR, SAN FRANCISCO, CA, 94132 STRATFORD DR 7 Stonestown TARAVAL 37.722045898438 -122.473686218262 POINT (-122.47368622 37.7220459) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
24669 24669 11590897 2019-10-23T11:41:00   2019-10-31T11:35:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 430 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.764137268066 -122.40557861328101 POINT (-122.40557861 37.76413727) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
25620 25620 11595202 2019-10-24T10:32:09   2019-10-24T10:40:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2427 23RD ST, SAN FRANCISCO, CA, 94110 23RD ST 10 Potrero Hill MISSION 37.754303 -122.40413600000001 POINT (-122.404136 37.754303) Mobile/Open311 http://mobile311.sfgov.org/reports/11595202/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
25624 25624 11595212 2019-10-24T10:33:33   2019-10-24T11:35:45 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CHENERY ST and THOR AVE CHENERY ST 8 Glen Park INGLESIDE 37.734543870022996 -122.43427544446301 POINT (-122.43427544 37.73454387) Mobile/Open311 http://mobile311.sfgov.org/reports/11595212/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
25629 25629 11595225 2019-10-24T10:36:00   2019-10-31T22:30:34 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 142 JULES AVE, SAN FRANCISCO, CA, 94112 JULES AVE 11 Ingleside TARAVAL 37.720783233643 -122.461082458496 POINT (-122.46108246 37.72078323) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
25911 25911 11596396 2019-10-24T13:20:00   2019-10-24T13:40:56 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 367 SILVER AVE, SAN FRANCISCO, CA, 94112 SILVER AVE 11 Mission Terrace INGLESIDE 37.728633880615 -122.42913818359399 POINT (-122.42913818 37.72863388) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
25943 25943 11596516 2019-10-24T13:44:00   2019-10-24T13:55:45 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1536 20TH ST, SAN FRANCISCO, CA, 94107 20TH ST 10 Potrero Hill BAYVIEW 37.7600440979 -122.39665222168001 POINT (-122.39665222 37.7600441) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
25948 25948 11596535 2019-10-24T13:47:00   2019-10-24T14:00:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of CABRILLO ST and 8TH AVE CABRILLO ST 1 Inner Richmond RICHMOND 37.775272369385 -122.466018676758 POINT (-122.46601868 37.77527237) Phone   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
26364 26364 11597965 2019-10-24T18:23:32   2019-10-24T18:30:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2500 46TH AVE, SAN FRANCISCO, CA, 94116 46TH AVE 4 Outer Sunset TARAVAL 37.739799600000005 -122.50442609999999 POINT (-122.5044261 37.7397996) Web http://mobile311.sfgov.org/reports/11597965/photos 39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
26751 26751 11400773 2019-09-11T11:34:00   2019-10-11T13:35:30 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1133 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776093532633 -122.408640999348 POINT (-122.408641 37.77609353) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
27132 27132 11599708 2019-10-25T09:18:00   2019-10-25T09:55:48 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 1868 BUCHANAN ST, SAN FRANCISCO, CA, 94115 BUCHANAN ST 5 Japantown NORTHERN 37.787330627441 -122.429985046387 POINT (-122.42998505 37.78733063) Phone   101 4 11 30 11 13 6 29,490 9 27 27   101   11             1         101
27235 27235 11599949 2019-10-25T09:50:00   2019-10-25T10:50:50 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 220 CRAUT ST, SAN FRANCISCO, CA, 94112 CRAUT ST 11 Mission Terrace INGLESIDE 37.729690551758 -122.42840576171899 POINT (-122.42840576 37.72969055) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
27520 27520 11600575 2019-10-25T11:24:00   2019-10-26T08:54:33 Open 1 Open RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Edgehill Mountain, , SAN FRANCISCO, CA, 94127 Edgehill Mountain 7 Laguna Honda TARAVAL 37.7421109 -122.4597433 POINT (-122.4597433 37.7421109) Web   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
27557 27557 11600688 2019-10-25T11:39:00   2019-10-25T11:57:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1273 28TH AVE, SAN FRANCISCO, CA, 94122 28TH AVE 4 Outer Sunset TARAVAL 37.763641666667 -122.486846666667 POINT (-122.48684667 37.76364167) Mobile/Open311 http://mobile311.sfgov.org/reports/11600688/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
27604 27604 11600773 2019-10-25T11:56:00   2019-10-26T08:53:38 Open 1 Open RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Edgehill Mountain, , SAN FRANCISCO, CA, 94127 Edgehill Mountain 7 Laguna Honda TARAVAL 37.7421109 -122.4597433 POINT (-122.4597433 37.7421109) Web   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
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
27715 27715 11527262 2019-10-09T11:23:00   2019-10-11T09:40:24 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 587 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 8 Duboce Triangle PARK 37.770668029785 -122.433242797852 POINT (-122.4332428 37.77066803) Phone   28 7 5 3 5 15 8 29,492 5 9 9   28   5             1         28
27895 27895 11601416 2019-10-25T13:47:45   2019-10-25T14:30:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of SAN JOSE AVE and THERESA ST SAN JOSE AVE 11 Mission Terrace INGLESIDE 37.730414256948 -122.436466203021 POINT (-122.4364662 37.73041426) Mobile/Open311 http://mobile311.sfgov.org/reports/11601416/photos 94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
27918 27918 11601465 2019-10-25T13:56:00   2019-10-26T08:35:49 Open 1 Open RPD GGP Queue 14 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 9TH AVE and MARTIN LUTHER KING JR DR 9TH AVE 5 Golden Gate Park RICHMOND 37.766627 -122.466205 POINT (-122.466205 37.766627) Mobile/Open311   9 8 11 12 11 11 9 29,492 6 8 8   9   11             1         9
28434 28434 11602216 2019-10-25T15:56:00   2019-10-25T16:10:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 100 RUSS ST, SAN FRANCISCO, CA, 94103 RUSS ST 6 South of Market SOUTHERN 37.778785705566 -122.408271789551 POINT (-122.40827179 37.77878571) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
28744 28744 11602745 2019-10-25T17:55:58   2019-10-25T18:05:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2219 43RD AVE, SAN FRANCISCO, CA, 94116 43RD AVE 4 Outer Sunset TARAVAL 37.745212753396004 -122.50182258462601 POINT (-122.50182258 37.74521275) Mobile/Open311 http://mobile311.sfgov.org/reports/11602745/photos 39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
28858 28858 11535280 2019-10-11T06:29:08   2019-10-11T06:35:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 500 CARGO WAY, SAN FRANCISCO, CA, 94124 CARGO WAY 10 Central Waterfront BAYVIEW 37.744597222425 -122.384581248818 POINT (-122.38458125 37.74459722) Web   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
28912 28912 11535384 2019-10-11T07:27:00   2019-10-11T07:50:27 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2424 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 9 Portola BAYVIEW 37.731864929199 -122.405487060547 POINT (-122.40548706 37.73186493) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2   4         2         91
28945 28945 11535433 2019-10-11T07:39:00   2019-10-11T08:10:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 448 TEHAMA ST, SAN FRANCISCO, CA, 94103 TEHAMA ST 6 South of Market SOUTHERN 37.780122530216 -122.40572688586501 POINT (-122.40572689 37.78012253) Mobile/Open311 http://mobile311.sfgov.org/reports/11535433/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
29126 29126 11603070 2019-10-25T19:40:00   2019-10-25T20:15:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of TURK ST and HYDE ST TURK ST 6 Tenderloin TENDERLOIN 37.782585144043004 -122.41569519043001 POINT (-122.41569519 37.78258514) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20

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 108.169ms