calls

80,878 rows sorted by Opened descending

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
40373 40373 11629179 2019-10-31T21:38:48   2019-10-31T21:45:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 355 15TH AVE, SAN FRANCISCO, CA, 94118 15TH AVE 1 Inner Richmond RICHMOND 37.781524600000004 -122.4743067 POINT (-122.4743067 37.7815246) Web   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
40349 40349 11629116 2019-10-31T21:05:49   2019-10-31T22:37:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 110 CAMBRIDGE ST, SAN FRANCISCO, CA, 94134 CAMBRIDGE ST 9 University Mound BAYVIEW 37.7308747 -122.4195279 POINT (-122.4195279 37.7308747) Web http://mobile311.sfgov.org/reports/11629116/photos 92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
40339 40339 11629075 2019-10-31T20:45:00   2019-10-31T21:00:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 810 SILVER AVE, SAN FRANCISCO, CA, 94134 SILVER AVE 9 University Mound BAYVIEW 37.729022979736 -122.419227600098 POINT (-122.4192276 37.72902298) Phone   92 2 2 7 7 9 3 309 3 5 5   92   2             2         92
40239 40239 11628855 2019-10-31T19:11:00   2019-10-31T19:40:10 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FULTON ST and 33RD AVE FULTON ST 1 Golden Gate Park RICHMOND 37.772178649902 -122.49275970459 POINT (-122.4927597 37.77217865) Phone   8 8 4 12 2 11 9 55 6 8 8   8   4             1         8
40206 40206 11628795 2019-10-31T18:55:00 2019-10-31T20:37:00 2019-10-31T20:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 645 CAMBRIDGE ST, SAN FRANCISCO, CA, 94134 CAMBRIDGE ST 9 University Mound BAYVIEW 37.723495483398 -122.417045593262 POINT (-122.41704559 37.72349548) Phone   92 2 2 25 7 9 3 309 3 28 28   92   2             1         92
40182 40182 11628752 2019-10-31T18:42:00   2019-10-31T18:50:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots Intersection of MISSION ST and 23RD ST MISSION ST 9 Mission MISSION 37.753837585449 -122.418594360352 POINT (-122.41859436 37.75383759) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
40034 40034 11628432 2019-10-31T17:23:00   2019-10-31T18:00:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 265 BEACON ST, SAN FRANCISCO, CA, 94131 BEACON ST 8 Fairmount INGLESIDE 37.74048614502 -122.432518005371 POINT (-122.43251801 37.74048615) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
40028 40028 11628418 2019-10-31T17:19:00   2019-10-31T22:37:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 910 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.780159139512 -122.40373794047501 POINT (-122.40373794 37.78015914) Web http://mobile311.sfgov.org/reports/11628418/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         4   2         32
39894 39894 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
39847 39847 11628028 2019-10-31T15:54:00   2019-10-31T16:00:39 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1456 CHURCH ST, SAN FRANCISCO, CA, 94131 CHURCH ST 8 Noe Valley INGLESIDE 37.747486114502 -122.42722320556601 POINT (-122.42722321 37.74748611) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
39840 39840 11628012 2019-10-31T15:52:00   2019-10-31T16:00:40 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1420 CHURCH ST, SAN FRANCISCO, CA, 94131 CHURCH ST 8 Noe Valley MISSION 37.747978210449 -122.42726898193399 POINT (-122.42726898 37.74797821) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
39837 39837 11628003 2019-10-31T15:51:00   2019-10-31T17:15:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 1225 4TH AVE, SAN FRANCISCO, CA, 94122 4TH AVE 5 Inner Sunset PARK 37.765682220459 -122.461128234863 POINT (-122.46112823 37.76568222) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
39835 39835 11627990 2019-10-31T15:48:00   2019-10-31T22:37:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3901 26TH ST, SAN FRANCISCO, CA, 94131 26TH ST 8 Noe Valley MISSION 37.748363494873 -122.42736053466801 POINT (-122.42736053 37.74836349) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
39813 39813 11627920 2019-10-31T15:35:00   2019-10-31T15:45:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1310 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Noe Valley MISSION 37.74987411499 -122.427421569824 POINT (-122.42742157 37.74987411) Phone   84 3 5 22 5 2 7 28,862 4 22 22   84   5             1         84
39814 39814 11627922 2019-10-31T15:35:00   2019-10-31T17:02:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 346 LEXINGTON ST, SAN FRANCISCO, CA, 94110 LEXINGTON ST 9 Mission MISSION 37.757774353027 -122.42053985595699 POINT (-122.42053986 37.75777435) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
39809 39809 11627900 2019-10-31T15:33:00   2019-10-31T15:40:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 175 DORANTES AVE, SAN FRANCISCO, CA, 94116 DORANTES AVE 7 Forest Hill TARAVAL 37.745216369629 -122.464286804199 POINT (-122.4642868 37.74521637) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
39790 39790 11627840 2019-10-31T15:23:00   2019-10-31T16:35:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 845 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Russian Hill CENTRAL 37.800762176514 -122.413375854492 POINT (-122.41337585 37.80076218) Phone   107 6 3 32 10 3 1 308 1 32 32   107   3             1         107
39781 39781 11627812 2019-10-31T15:16:00   2019-10-31T17:25:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2420 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 2 Pacific Heights NORTHERN 37.791996002196996 -122.43430328369101 POINT (-122.43430328 37.791996) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
39760 39760 11627774 2019-10-31T15:10:18   2019-10-31T22:36:55 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1232 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772904 -122.439733 POINT (-122.439733 37.772904) Mobile/Open311 http://mobile311.sfgov.org/reports/11627774/photos 24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
39738 39738 11627727 2019-10-31T15:03:00   2019-10-31T15:10:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of 19TH AVE and EUCALYPTUS DR 19TH AVE 7 Stonestown TARAVAL 37.731067657471 -122.474853515625 POINT (-122.47485352 37.73106766) Phone   62 10 8 41 4 9 5 64 8 40 40   62   8             1         62
39715 39715 11627662 2019-10-31T14:52:00 2019-10-31T15:59:00 2019-10-31T15:59:00 Closed 2 i cut up the tree branch an put it in thr truck DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1219 FELL ST, SAN FRANCISCO, CA, 94117 FELL ST 5 Panhandle PARK 37.773956298828004 -122.43800232 POINT (-122.43800232 37.7739563) Mobile/Open311 http://mobile311.sfgov.org/reports/11627662/photos 24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
39672 39672 11627548 2019-10-31T14:33:00   2019-10-31T22:36:50 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 491 30TH AVE, SAN FRANCISCO, CA, 94121 30TH AVE 1 Outer Richmond RICHMOND 37.7802006 -122.49033329999999 POINT (-122.4903333 37.7802006) Mobile/Open311 http://mobile311.sfgov.org/reports/11627548/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
39657 39657 11627517 2019-10-31T14:26:00   2019-10-31T14:35:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1710 10TH AVE, SAN FRANCISCO, CA, 94122 10TH AVE 7 Golden Gate Heights TARAVAL 37.756328582764 -122.46670532226601 POINT (-122.46670532 37.75632858) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
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
39614 39614 11627357 2019-10-31T13:56:00   2019-10-31T14:25:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2067 HAYES ST, SAN FRANCISCO, CA, 94117 HAYES ST 5 Panhandle PARK 37.773258209229 -122.45043182373001 POINT (-122.45043182 37.77325821) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
39588 39588 11627277 2019-10-31T13:43:43   2019-10-31T22:36:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3411 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 1 Lone Mountain RICHMOND 37.781383700000006 -122.4555344 POINT (-122.4555344 37.7813837) Web http://mobile311.sfgov.org/reports/11627277/photos 12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
39576 39576 11627253 2019-10-31T13:40:55   2019-10-31T22:36:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2641 25TH ST, SAN FRANCISCO, CA, 94110 25TH ST 10 Potrero Hill MISSION 37.751596 -122.404661 POINT (-122.404661 37.751596) Mobile/Open311 http://mobile311.sfgov.org/reports/11627253/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
39564 39564 11627231 2019-10-31T13:37:01   2019-10-31T22:36:42 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1383 VERMONT ST, SAN FRANCISCO, CA, 94110 VERMONT ST 10 Potrero Hill MISSION 37.752492 -122.403222 POINT (-122.403222 37.752492) Mobile/Open311 http://mobile311.sfgov.org/reports/11627231/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
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
39525 39525 11627133 2019-10-31T13:20:00   2019-10-31T22:36:41 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 28 CORTLAND AVE, SAN FRANCISCO, CA, 94110 CORTLAND AVE 9 Holly Park INGLESIDE 37.740646362305 -122.42221069335899 POINT (-122.42221069 37.74064636) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
7610 7610 11627033 2019-10-31T13:04:00   2019-10-31T13:30:12 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 243 GRAFTON AVE, SAN FRANCISCO, CA, 94112 GRAFTON AVE 11 Ingleside TARAVAL 37.719921112061 -122.455879211426 POINT (-122.45587921 37.71992111) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
39410 39410 11626860 2019-10-31T12:28:00   2019-10-31T12:35:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 83 ELSIE ST, SAN FRANCISCO, CA, 94110 ELSIE ST 9 Bernal Heights INGLESIDE 37.743537902831996 -122.417091369629 POINT (-122.41709137 37.7435379) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
39274 39274 11626538 2019-10-31T11:33:00   2019-10-31T11:40:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 2032 MCALLISTER ST, SAN FRANCISCO, CA, 94118 MCALLISTER ST 5 Western Addition PARK 37.776985168456996 -122.44557952880899 POINT (-122.44557953 37.77698517) Phone   97 7 11 18 11 15 8 29,492 5 16 16   97   11             1         97
39272 39272 11626533 2019-10-31T11:32:00   2019-10-31T11:40:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 261 GRANADA AVE, SAN FRANCISCO, CA, 94112 GRANADA AVE 7 Ingleside TARAVAL 37.723201751709 -122.457305908203 POINT (-122.45730591 37.72320175) Phone   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19     2         64
39253 39253 11626477 2019-10-31T11:22:00   2019-10-31T11:40:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 611 FREDERICK ST, SAN FRANCISCO, CA, 94117 FREDERICK ST 5 Parnassus Heights PARK 37.765998840331996 -122.45491027831999 POINT (-122.45491028 37.76599884) Phone   110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
39250 39250 11626464 2019-10-31T11:19:00   2019-10-31T22:36:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 210 JOICE ST, SAN FRANCISCO, CA, 94108 JOICE ST 3 Nob Hill CENTRAL 37.793313299999994 -122.4084815 POINT (-122.4084815 37.7933133) Web http://mobile311.sfgov.org/reports/11626464/photos 16 6 3 6 10 3 1 28,857 1 4 4 5 16   3 5     5     2         16
39238 39238 11626431 2019-10-31T11:15:00   2019-10-31T22:36:06 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 210 JOICE ST, SAN FRANCISCO, CA, 94108 JOICE ST 3 Nob Hill CENTRAL 37.793313299999994 -122.4084815 POINT (-122.4084815 37.7933133) Web http://mobile311.sfgov.org/reports/11626431/photos 16 6 3 6 10 3 1 28,857 1 4 4 5 16   3 5     5     2         16
39237 39237 11626424 2019-10-31T11:13:00   2019-10-31T12:00:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 311 VIRGINIA AVE, SAN FRANCISCO, CA, 94110 VIRGINIA AVE 9 Bernal Heights INGLESIDE 37.742023468018 -122.41858673095699 POINT (-122.41858673 37.74202347) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
39135 39135 11626216 2019-10-31T10:37:00   2019-10-31T22:35:58 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1655 JONES ST, SAN FRANCISCO, CA, 94109 JONES ST 3 Russian Hill CENTRAL 37.796585083008 -122.41527557373001 POINT (-122.41527557 37.79658508) Phone   107 6 3 21 10 5 1 28,858 1 21 21   107   3             1         107
39092 39092 11626136 2019-10-31T10:26:00   2019-10-31T22:35:50 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 350 RHODE ISLAND ST, SAN FRANCISCO, CA, 94103 RHODE ISLAND ST 10 Potrero Hill SOUTHERN 37.76541519165 -122.402786254883 POINT (-122.40278625 37.76541519) Phone   54 1 9 4 8 8 3 28,853 3 20 20   54   9             1         54
39065 39065 11626053 2019-10-31T10:10:50   2019-10-31T22:35:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1110 JACKSON ST, SAN FRANCISCO, CA, 94133 JACKSON ST 3 Nob Hill CENTRAL 37.795166024042004 -122.413444854433 POINT (-122.41344485 37.79516602) Mobile/Open311 http://mobile311.sfgov.org/reports/11626053/photos 16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
39037 39037 11625993 2019-10-31T09:57:00   2019-10-31T22:35:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4760 17TH ST, SAN FRANCISCO, CA, 94117 17TH ST 5 Ashbury Heights PARK 37.761773036343996 -122.44894858836099 POINT (-122.44894859 37.76177304) Web http://mobile311.sfgov.org/reports/11625993/photos 114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
38893 38893 11625674 2019-10-31T09:07:00   2019-10-31T09:20:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of HENRY ST and CASTRO ST HENRY ST 8 Corona Heights PARK 37.766529083252 -122.435546875 POINT (-122.43554688 37.76652908) Phone   28 7 5 5 5 15 8 28,862 5 3 3   28   5             1   5     28
38839 38839 11625557 2019-10-31T08:47:00   2019-10-31T09:10:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 40 BROMPTON AVE, SAN FRANCISCO, CA, 94131 BROMPTON AVE 8 Glen Park INGLESIDE 37.734104156494006 -122.43498229980499 POINT (-122.4349823 37.73410416) Phone   96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
38812 38812 11625499 2019-10-31T08:37:00   2019-10-31T14:15:08 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 HIDALGO TER, SAN FRANCISCO, CA, 94103 HIDALGO TER 8 Mission Dolores MISSION 37.767051696777 -122.42562866210899 POINT (-122.42562866 37.7670517) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
38789 38789 11625450 2019-10-31T08:28:46   2019-10-31T08:35:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1111 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.784683881995 -122.422934857178 POINT (-122.42293486 37.78468388) Web   100 4 11 39 11 13 6 28,858 9 41 41   100   11             1         100
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
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
38321 38321 11624464 2019-10-30T19:35:00   2019-10-31T22:32:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 137 ASHTON AVE, SAN FRANCISCO, CA, 94112 ASHTON AVE 11 Ingleside TARAVAL 37.720693 -122.462473 POINT (-122.462473 37.720693) Web http://mobile311.sfgov.org/reports/11624464/photos 64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
7798 7798 11624131 2019-10-30T18:01:00   2019-10-30T18:15:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 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
38125 38125 11624088 2019-10-30T17:50:00   2019-10-31T22:31:40 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2400 WEBSTER ST, SAN FRANCISCO, CA, 94115 WEBSTER ST 2 Pacific Heights NORTHERN 37.792937 -122.43281200000001 POINT (-122.432812 37.792937) Mobile/Open311 http://mobile311.sfgov.org/reports/11624088/photos 102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
38057 38057 11623938 2019-10-30T17:14:00 2019-10-31T10:49:05 2019-10-31T10:49:05 Closed 2 Unable to Locate. If the problem still exists, please submit a new request with more details regarding the location of the issue. Close Note: Unable to locate. No parking lot at Persia/sunnydale. Please resend 311 if issue persists RPD Park Service Area 3 Queue 16 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PERSIA AVE and SUNNYDALE AVE PERSIA AVE 11 Excelsior INGLESIDE 37.718280792236 -122.425834655762 POINT (-122.42583466 37.71828079) Phone   90 9 1 19 6 9 4 309 7 18 18   90   1             2         90
37992 37992 11623780 2019-10-30T16:44:00   2019-10-31T13:46:02 Open 1 closed DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 65 CRESTLINE DR, SAN FRANCISCO, CA, 94131 CRESTLINE DR 8 Upper Market PARK 37.751298 -122.4465027 POINT (-122.4465027 37.751298) Web   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
37952 37952 11623689 2019-10-30T16:33:17   2019-10-31T22:30:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1483 12TH AVE, SAN FRANCISCO, CA, 94122 12TH AVE 7 Inner Sunset TARAVAL 37.76049520000001 -122.46952350000001 POINT (-122.4695235 37.7604952) Web http://mobile311.sfgov.org/reports/11623689/photos 109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
37908 37908 11623600 2019-10-30T16:14:00   2019-10-31T10:35:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 926 CAPITOL AVE, SAN FRANCISCO, CA, 94112 CAPITOL AVE 11 Ingleside TARAVAL 37.718763 -122.45896499999999 POINT (-122.458965 37.718763) Mobile/Open311   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
37902 37902 11623593 2019-10-30T16:12:00   2019-10-31T10:25:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 939 CAPITOL AVE, SAN FRANCISCO, CA, 94112 CAPITOL AVE 11 Ingleside TARAVAL 37.718946 -122.45919599999999 POINT (-122.459196 37.718946) Mobile/Open311   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
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
37840 37840 11623458 2019-10-30T15:33:17   2019-10-30T15:40:12 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.765011 -122.42658700000001 POINT (-122.426587 37.765011) Mobile/Open311   37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
37837 37837 11623451 2019-10-30T15:32:00 2019-11-03T01:01:12 2019-10-30T15:45:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2077 HAYES ST, SAN FRANCISCO, CA, 94117 HAYES ST 5 Panhandle PARK 37.773231506348 -122.45066070556601 POINT (-122.45066071 37.77323151) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
37801 37801 11623357 2019-10-30T15:15:31   2019-10-30T15:55:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1637 CHESTNUT ST, SAN FRANCISCO, CA, 94123 CHESTNUT ST 2 Marina NORTHERN 37.801450777566 -122.43027757469801 POINT (-122.43027757 37.80145078) Mobile/Open311 http://mobile311.sfgov.org/reports/11623357/photos 17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
37758 37758 11623232 2019-10-30T14:53:51   2019-10-30T15:00:53 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 929 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Ashbury Heights PARK 37.7646778 -122.4477351 POINT (-122.4477351 37.7646778) Web   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
37755 37755 11623228 2019-10-30T14:53:00   2019-10-30T15:45:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 415 JACKSON ST, SAN FRANCISCO, CA, 94111 JACKSON ST 3 North Beach CENTRAL 37.796318054199 -122.40225982666 POINT (-122.40225983 37.79631805) Phone   106 6 3 6 10 3 1 28,860 1 4 4   106   3             2         106
37713 37713 11623135 2019-10-30T14:40:00   2019-10-30T15:35:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of LAGUNA ST and MCALLISTER ST LAGUNA ST 5 Western Addition NORTHERN 37.779258728027 -122.426826477051 POINT (-122.42682648 37.77925873) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
37702 37702 11623106 2019-10-30T14:36:00   2019-10-30T15:06:03 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 543 JERSEY ST, SAN FRANCISCO, CA, 94114 JERSEY ST 8 Noe Valley MISSION 37.750186920166 -122.43712615966801 POINT (-122.43712616 37.75018692) Phone   84 3 5 22 5 2 7 28,862 4 22 22   84   5             1         84
37642 37642 11622948 2019-10-30T14:09:29   2019-10-30T14:15:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 777 ALABAMA ST, SAN FRANCISCO, CA, 94110 ALABAMA ST 9 Mission MISSION 37.759399414063 -122.4116108102 POINT (-122.41161081 37.75939941) Mobile/Open311 http://mobile311.sfgov.org/reports/11622948/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
37597 37597 11622869 2019-10-30T13:58:37   2019-10-30T15:20:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 25TH ST and VERMONT ST 25TH ST 10 Potrero Hill MISSION 37.751944 -122.40333600000001 POINT (-122.403336 37.751944) Mobile/Open311 http://mobile311.sfgov.org/reports/11622869/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
37593 37593 11622865 2019-10-30T13:58:18   2019-10-30T14:05:36 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2789 25TH ST, SAN FRANCISCO, CA, 94110 25TH ST 10 Potrero Hill MISSION 37.751597 -122.40548500000001 POINT (-122.405485 37.751597) Mobile/Open311 http://mobile311.sfgov.org/reports/11622865/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
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
8224 8224 11622531 2019-10-30T12:14:01   2019-10-30T12:20:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 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
37241 37241 11621949 2019-10-30T10:40:00   2019-10-30T10:50:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2226 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Duboce Triangle PARK 37.765922546387 -122.433944702148 POINT (-122.4339447 37.76592255) Phone   28 7 5 5 5 15 8 28,862 5 3 3   28   5             1   5     28
37148 37148 11621710 2019-10-30T10:06:21   2019-10-30T10:16:36 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1616 8TH AVE, SAN FRANCISCO, CA, 94122 8TH AVE 7 Golden Gate Heights TARAVAL 37.758141666667 -122.464783333333 POINT (-122.46478333 37.75814167) Mobile/Open311 http://mobile311.sfgov.org/reports/11621710/photos 44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
37138 37138 11621690 2019-10-30T10:03:00   2019-10-30T10:45:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of LAKE ST and 26TH AVE LAKE ST 2 Seacliff RICHMOND 37.785697937012 -122.486221313477 POINT (-122.48622131 37.78569794) Phone   1 8 6 33 1 11 9 55 6 33 33   1   6             1         1
37113 37113 11621606 2019-10-30T09:49:00   2019-10-30T10:00:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 122 WOOL ST, SAN FRANCISCO, CA, 94110 WOOL ST 9 Bernal Heights INGLESIDE 37.740047454834 -122.417152404785 POINT (-122.4171524 37.74004745) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
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
37023 37023 11621354 2019-10-30T09:05:00   2019-10-30T09:45:10 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 387 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.784768 -122.41288600000001 POINT (-122.412886 37.784768) Mobile/Open311 http://mobile311.sfgov.org/reports/11621354/photos 20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
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
36878 36878 11621063 2019-10-30T08:24:00 2019-10-30T22:15:34 2019-10-30T22:15:34 Closed 2 Request is a duplicate and has been previously reported as 11619759 DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2646 VALLEJO ST, SAN FRANCISCO, CA, 94123 VALLEJO ST 2 Pacific Heights NORTHERN 37.794609069824 -122.44082641601601 POINT (-122.44082642 37.79460907) Phone   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
36803 36803 11620939 2019-10-30T08:08:00   2019-10-30T08:45:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 74 FRANK NORRIS ST, SAN FRANCISCO, CA, 94109 FRANK NORRIS ST 3 Lower Nob Hill NORTHERN 37.78919125892 -122.419955137152 POINT (-122.41995514 37.78919126) Mobile/Open311 http://mobile311.sfgov.org/reports/11620939/photos 50 4 3 21 10 13 6 28,858 9 21 21   50   3         10   1         50
7055 7055 11620909 2019-10-30T08:01:00   2019-10-30T08:30:13 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 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
36628 36628 11620645 2019-10-30T06:29:00   2019-10-30T14:10:31 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 3715 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754383087158 -122.44167327880899 POINT (-122.44167328 37.75438309) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
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
36529 36529 11620385 2019-10-29T22:26:00   2019-10-30T02:10:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1352 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 2 Lake Street RICHMOND 37.786368599999996 -122.47420790000001 POINT (-122.4742079 37.7863686) Web http://mobile311.sfgov.org/reports/11620385/photos 2 8 6 33 1 11 9 54 6 33 33   2   6             1         2
36512 36512 11620325 2019-10-29T21:44:00   2019-10-29T22:25:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 72 CENTRAL AVE, SAN FRANCISCO, CA, 94117 CENTRAL AVE 5 Buena Vista PARK 37.76994599782 -122.44343483240499 POINT (-122.44343483 37.769946) Mobile/Open311 http://mobile311.sfgov.org/reports/11620325/photos 112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
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
36292 36292 11619846 2019-10-29T18:21:00   2019-10-29T18:30:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 123 MANCHESTER ST, SAN FRANCISCO, CA, 94110 MANCHESTER ST 9 Bernal Heights INGLESIDE 37.744506835938 -122.41397094726601 POINT (-122.41397095 37.74450684) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
36259 36259 11619786 2019-10-29T18:10:05   2019-10-29T18:20:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2146 22ND AVE, SAN FRANCISCO, CA, 94116 22ND AVE 4 Parkside TARAVAL 37.747601524344 -122.47930961225401 POINT (-122.47930961 37.74760152) Mobile/Open311 http://mobile311.sfgov.org/reports/11619786/photos 40 10 7 35 3 1 5 29,491 8 35 35   40   7 25     24     1         40
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
36236 36236 11619750 2019-10-29T18:02:00 2019-10-30T05:36:59 2019-10-30T05:36:59 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you is for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 153 OXFORD ST, SAN FRANCISCO, CA, 94134 OXFORD ST 9 University Mound INGLESIDE 37.727936 -122.4198487 POINT (-122.4198487 37.727936) Web   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
1130 1130 11619706 2019-10-29T17:54:00 2019-10-29T18:51:54 2019-10-29T19:30:05 Closed 2 Emailed to on-call arborist Ricardo Lizarraga DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GREAT HWY and SKYLINE BLVD GREAT HWY 7 Lakeshore TARAVAL 37.725257873535 -122.50304412841801 POINT (-122.50304413 37.72525787) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
36197 36197 11619694 2019-10-29T17:51:00   2019-10-29T18:05:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1042 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Ashbury Heights PARK 37.764308929443004 -122.449501037598 POINT (-122.44950104 37.76430893) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
36193 36193 11619685 2019-10-29T17:50:00 2019-10-30T06:46:57 2019-10-30T06:46:57 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 153 OXFORD ST, SAN FRANCISCO, CA, 94134 OXFORD ST 9 University Mound INGLESIDE 37.727936 -122.4198487 POINT (-122.4198487 37.727936) Web   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
35984 35984 11619257 2019-10-29T16:26:00 2019-10-30T08:57:16 2019-10-30T08:57:16 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 134 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711620330811 -122.46935272216801 POINT (-122.46935272 37.71162033) 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
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
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
35914 35914 11619060 2019-10-29T15:51:46   2019-10-29T16:00:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4900 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 11 Cayuga INGLESIDE 37.720185876859 -122.438327372188 POINT (-122.43832737 37.72018588) Mobile/Open311 http://mobile311.sfgov.org/reports/11619060/photos 80 9 1 28 6 9 4 28,861 7 25 25 4 80   1 4     4     2         80
35910 35910 11619044 2019-10-29T15:49:00   2019-10-29T16:30:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 697 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Mission Dolores MISSION 37.758361816406 -122.42552947998001 POINT (-122.42552948 37.75836182) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
35897 35897 11618995 2019-10-29T15:42:07   2019-10-29T15:50:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1000 HARRISON ST, SAN FRANCISCO, CA, 94103 HARRISON ST 6 South of Market SOUTHERN 37.777131 -122.404508 POINT (-122.404508 37.777131) Mobile/Open311 http://mobile311.sfgov.org/reports/11618995/photos 32 1 10 34 9 14 2 28,853 2 34 34 24 32   10 6     6     2         32
35854 35854 11618899 2019-10-29T15:26:38 2019-10-29T14:57:47 2019-10-29T16:20:23 Closed 2 Gave the request over channel 6 spoke to Ricardo DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2998 SAN JOSE AVE, SAN FRANCISCO, CA, 94112 SAN JOSE AVE 11 Oceanview TARAVAL 37.711246490479 -122.455856323242 POINT (-122.45585632 37.71124649) Integrated Agency   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
35834 35834 11618849 2019-10-29T15:15:00 2019-10-30T05:38:48 2019-10-30T05:38:48 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you is for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1737 FELTON ST, SAN FRANCISCO, CA, 94134 FELTON ST 9 University Mound INGLESIDE 37.725387573242 -122.421920776367 POINT (-122.42192078 37.72538757) Phone   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92

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