calls

80,878 rows where Category = 1 sorted by Updated 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
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
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
33044 33044 11611711 2019-10-28T10:01:46   2019-10-30T15:49:49 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 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/11611711/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
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
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
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
72032 72032 11608247 2019-10-27T11:31:00 2019-10-30T15:42:00 2019-10-30T15:42:00 Closed 2   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
53789 53789 11467926 2019-09-26T09:04:00   2019-10-30T15:41:07 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of ADDISON ST and DIGBY ST ADDISON ST 8 Fairmount INGLESIDE 37.740081787109 -122.43370819091801 POINT (-122.43370819 37.74008179) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
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
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
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
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
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
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
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
6839 6839 11611964 2019-10-28T10:36:29 2019-10-28T10:22:54 2019-10-30T15:04:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CALIFORNIA ST and JOICE ST CALIFORNIA ST 3 Nob Hill CENTRAL 37.792140960693004 -122.408363342285 POINT (-122.40836334 37.79214096) Integrated Agency   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
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
3721700 3721700 11273670 2019-08-14T23:13:16   2019-10-30T15:00:30 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 309 SURREY ST, SAN FRANCISCO, CA, 94131 SURREY ST 8 Glen Park INGLESIDE 37.7358048 -122.4370136 POINT (-122.4370136 37.7358048) Web   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
3808206 3808206 11398018 2019-09-10T18:17:00   2019-10-30T15:00:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2598 DIAMOND ST, SAN FRANCISCO, CA, 94131 DIAMOND ST 8 Glen Park INGLESIDE 37.737338 -122.434858 POINT (-122.434858 37.737338) Mobile/Open311   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
8405 8405 11013873 2019-06-18T14:50:00   2019-10-30T14:55:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 461 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.739784240723 -122.436805725098 POINT (-122.43680573 37.73978424) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
1276 1276 10964957 2019-06-07T09:45:00 2019-10-30T00:00:00 2019-10-30T14:55:07 Closed 2 Notes:blocking driveway access . BUF Action:Prune. Notes:blocking driveway access . BUF Action:Prune. date completed - 10/30/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 127 HOLLOWAY AVE, SAN FRANCISCO, CA, 94112 HOLLOWAY AVE 11 Ingleside TARAVAL 37.721740722656 -122.454383850098 POINT (-122.45438385 37.72174072) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1 19     19     2         64
31774 31774 11608593 2019-10-27T12:52:00 2019-10-30T14:48:16 2019-10-30T14:48:16 Closed 2 Case Resolved Close Note: RPD Park Service Area 6 Queue 15 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Precita Park, 3200 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.747060499999996 -122.4122163 POINT (-122.4122163 37.7470605) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
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
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
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
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
33934 33934 11614333 2019-10-28T16:46:00 2019-10-30T00:00:00 2019-10-30T13:40:06 Closed 2 Notes:decay in greater than 50 percent of trunk, cracking wood.. BUF Action:Inspect. date completed - 10/30/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of ANZA ST and 19TH AVE ANZA ST 1 Inner Richmond RICHMOND 37.778457641602 -122.478164672852 POINT (-122.47816467 37.77845764) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
26413 26413 11598092 2019-10-24T18:59:00 2019-10-30T13:05:00 2019-10-30T13:05:00 Closed 2 For tree crew DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 20TH AVE and BUCKINGHAM WAY 20TH AVE 7 Stonestown TARAVAL 37.730117797852 -122.475936889648 POINT (-122.47593689 37.7301178) Phone   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
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
11485 11485 11523644 2019-10-08T14:39:00   2019-10-30T12:20:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 4042 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Corona Heights MISSION 37.762554168701 -122.43621826171899 POINT (-122.43621826 37.76255417) Phone   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
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
3712827 3712827 11324794 2019-08-26T11:04:00   2019-10-30T12:20:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 2430 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Corona Heights MISSION 37.762680053711 -122.435775756836 POINT (-122.43577576 37.76268005) Phone   113 7 5 5 5 15 8 28,862 5 3 3 1 113   5 1           1         113
623 623 11611558 2019-10-28T09:39:00 2019-10-28T14:06:44 2019-10-30T12:00:19 Closed 2 Made safe DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 245 MARKET ST, SAN FRANCISCO, CA, 94105 MARKET ST 6 Financial District CENTRAL 37.792785644531 -122.396743774414 POINT (-122.39674377 37.79278564) Phone   108 6 10 8 9 12 2 28,855 2 6 6   108   10             1         108
453 453 11607582 2019-10-27T08:57:00 2019-10-28T10:23:02 2019-10-30T12:00:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2515 GOUGH ST, SAN FRANCISCO, CA, 94123 GOUGH ST 2 Pacific Heights NORTHERN 37.796714782715 -122.42711639404301 POINT (-122.42711639 37.79671478) Phone   102 4 6 13 1 13 6 57 9 17 17   102   6             1         102
33296 33296 11612419 2019-10-28T11:42:00 2019-11-01T08:08:00 2019-10-30T12:00:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of LASKIE ST and MISSION ST LASKIE ST 6 South of Market SOUTHERN 37.776706695556996 -122.414108276367 POINT (-122.41410828 37.7767067) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1   7 1 2 1 1     32
33491 33491 11612991 2019-10-28T13:13:00   2019-10-30T12:00:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 2111 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Pacific Heights NORTHERN 37.793899536133 -122.42486572265601 POINT (-122.42486572 37.79389954) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
34792 34792 11616238 2019-10-29T08:47:00 2019-10-29T09:30:34 2019-10-30T11:55:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3699 CLAY ST, SAN FRANCISCO, CA, 94118 CLAY ST 2 Presidio Heights RICHMOND 37.788216471423 -122.45355627644399 POINT (-122.45355628 37.78821647) Mobile/Open311 http://mobile311.sfgov.org/reports/11616238/photos 10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
33072 33072 11611799 2019-10-28T10:14:00   2019-10-30T11:55:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2133 GREENWICH ST, SAN FRANCISCO, CA, 94123 GREENWICH ST 2 Union Street NORTHERN 37.798938751221 -122.43473815918001 POINT (-122.43473816 37.79893875) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
33216 33216 11612194 2019-10-28T11:05:00   2019-10-30T11:55:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3773 SACRAMENTO ST, SAN FRANCISCO, CA, 94118 SACRAMENTO ST 2 Presidio Heights RICHMOND 37.787075042725 -122.45471954345699 POINT (-122.45471954 37.78707504) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
71940 71940 11609242 2019-10-27T15:21:37 2019-10-28T07:34:53 2019-10-30T11:53:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 683 7TH ST, SAN FRANCISCO, CA, 94103 7TH ST 6 South of Market SOUTHERN 37.772105983494 -122.401979919637 POINT (-122.40197992 37.77210598) Mobile/Open311 http://mobile311.sfgov.org/reports/11609242/photos 32 1 10 34 9 14 2 28,853 2 34 34   32   10             2         32
32957 32957 11611479 2019-10-28T09:29:53 2019-10-30T11:51:00 2019-10-30T11:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
3713662 3713662 11297170 2019-08-20T10:25:00   2019-10-30T11:45:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1030 PLYMOUTH AVE, SAN FRANCISCO, CA, 94112 PLYMOUTH AVE 11 Ingleside TARAVAL 37.720630645752 -122.45597839355499 POINT (-122.45597839 37.72063065) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
52606 52606 11464421 2019-09-25T12:06:00 2019-10-30T00:00:00 2019-10-30T11:45:09 Closed 2 Notes:unfortunately this tree has canker, it will eventually die from it but can remain stable and green for many years. we will monitor it and remove once it is closer to being fully dead.. BUF Action:Inspect. date completed - 10/30/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 588 2ND AVE, SAN FRANCISCO, CA, 94118 2ND AVE 1 Inner Richmond RICHMOND 37.77766418457 -122.459579467773 POINT (-122.45957947 37.77766418) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
52710 52710 11464796 2019-09-25T13:06:00   2019-10-30T11:45:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 4053 19TH ST, SAN FRANCISCO, CA, 94114 19TH ST 8 Eureka Valley MISSION 37.7592081 -122.4338388 POINT (-122.4338388 37.7592081) Web http://mobile311.sfgov.org/reports/11464796/photos 115 3 5 5 5 2 7 28,862 4 3 3 1 115   5 1           1   5     115
31410 31410 11607379 2019-10-27T08:01:00 2019-10-28T10:23:13 2019-10-30T11:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 74 CERVANTES BLVD, SAN FRANCISCO, CA, 94123 CERVANTES BLVD 2 Marina NORTHERN 37.803726196289 -122.43834686279301 POINT (-122.43834686 37.8037262) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
33327 33327 11612501 2019-10-28T11:54:00 2019-10-28T12:08:30 2019-10-30T11:43:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1360 TAYLOR ST, SAN FRANCISCO, CA, 94108 TAYLOR ST 3 Nob Hill CENTRAL 37.794998 -122.413122 POINT (-122.413122 37.794998) Mobile/Open311 http://mobile311.sfgov.org/reports/11612501/photos 16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
34604 34604 11615863 2019-10-29T07:53:00 2019-10-29T13:26:21 2019-10-30T11:38:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CALIFORNIA ST and GRANT AVE CALIFORNIA ST 3 Chinatown CENTRAL 37.792449951171996 -122.405937194824 POINT (-122.40593719 37.79244995) Phone   104 6 3 8 10 3 1 28,857 1 6 6   104   3             2         104
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
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
3704589 3704589 11383931 2019-09-07T19:25:00   2019-10-30T11:20:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 725 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Eureka Valley MISSION 37.757287901858 -122.43439474014299 POINT (-122.43439474 37.7572879) Mobile/Open311 http://mobile311.sfgov.org/reports/11383931/photos 115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
3839351 3839351 11427081 2019-09-17T10:09:00   2019-10-30T11:10:07 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 625 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Lower Nob Hill CENTRAL 37.787038834469 -122.414991104463 POINT (-122.4149911 37.78703883) Mobile/Open311 http://mobile311.sfgov.org/reports/11427081/photos 50 6 10 36 9 13 1 28,858 1 36 36   50   10             2         50
35255 35255 11617343 2019-10-29T11:24:00 2019-10-29T11:58:23 2019-10-30T11:09:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2801 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 1 Lone Mountain RICHMOND 37.782028198242 -122.449165344238 POINT (-122.44916534 37.7820282) Phone   12 7 4 18 2 15 9 54 6 16 16   12   4             1         12
45702 45702 11502131 2019-10-03T19:32:00   2019-10-30T11:08:54 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 3099 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 CALIFORNIA ST 2 Lower Pacific Heights RICHMOND 37.787341666667 -122.44532 POINT (-122.44532 37.78734167) Mobile/Open311 http://mobile311.sfgov.org/reports/11502131/photos 103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
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
71941 71941 11609479 2019-10-27T16:31:00 2019-10-28T06:12:40 2019-10-30T10:59:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SANTIAGO ST and 19TH AVE SANTIAGO ST 7 Parkside TARAVAL 37.744918823242 -122.475776672363 POINT (-122.47577667 37.74491882) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
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
55243 55243 11472694 2019-09-27T09:20:00   2019-10-30T10:55:07 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 190 JONES ST, SAN FRANCISCO, CA, 94102 JONES ST 6 Tenderloin TENDERLOIN 37.782726820405 -122.412443891991 POINT (-122.41244389 37.78272682) Mobile/Open311 http://mobile311.sfgov.org/reports/11472694/photos 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
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
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
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
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
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
84663 84663 11494889 2019-10-02T11:34:00   2019-10-30T10:00:18 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 490 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Mission MISSION 37.763432632542 -122.40740150298402 POINT (-122.4074015 37.76343263) Mobile/Open311 http://mobile311.sfgov.org/reports/11494889/photos 53 3 9 20 8 8 7 28,859 4 19 19   53   9     3       2   3     53
43003 43003 11528189 2019-10-09T14:11:00   2019-10-30T10:00:12 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of GEARY BLVD and DIVISADERO ST GEARY BLVD 5 Western Addition NORTHERN 37.783309936523 -122.439483642578 POINT (-122.43948364 37.78330994) Phone   103 4 11 15 11 15 8 29,490 5 13 13   103   11             2         103
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
45694 45694 11543525 2019-10-13T06:50:00   2019-10-30T09:55:09 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 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
38421 38421 11549960 2019-10-14T16:19:00   2019-10-30T09:50:12 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 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
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
72198 72198 11608987 2019-10-27T14:22:45 2019-10-28T07:29:42 2019-10-30T09:43:38 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 807 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Cole Valley PARK 37.766876220703004 -122.44799565412501 POINT (-122.44799565 37.76687622) Mobile/Open311 http://mobile311.sfgov.org/reports/11608987/photos 29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
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
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
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
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
26247 26247 11597627 2019-10-24T17:03:02 2019-10-29T11:48:56 2019-10-30T08:29:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CLAY ST and LAGUNA ST CLAY ST 2 Pacific Heights NORTHERN 37.7913539 -122.42929509999999 POINT (-122.4292951 37.7913539) Web http://mobile311.sfgov.org/reports/11597627/photos 102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
35641 35641 11618273 2019-10-29T13:46:00 2019-10-30T07:43:28 2019-10-30T07:43:28 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 348 WILDE AVE, SAN FRANCISCO, CA, 94134 WILDE AVE 10 Visitacion Valley INGLESIDE 37.716882389304 -122.403784534216 POINT (-122.40378453 37.71688239) Mobile/Open311   75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
32034 32034 11609293 2019-10-27T15:36:00   2019-10-30T07:01:52 Open 1 Open RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CRESTWELL WALK and END (000 BLOCK OF) CRESTWELL WALK 7 Golden Gate Heights TARAVAL 37.756138333333 -122.471763333333 POINT (-122.47176333 37.75613833) Mobile/Open311 http://mobile311.sfgov.org/reports/11609293/photos 44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
32051 32051 11609326 2019-10-27T15:44:00 2019-10-28T09:22:56 2019-10-30T07:00:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1421 10TH AVE, SAN FRANCISCO, CA, 94122 10TH AVE 7 Inner Sunset TARAVAL 37.761684417725 -122.46736145019501 POINT (-122.46736145 37.76168442) Phone   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
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
64200 64200 11595511 2019-10-24T11:21:00 2019-10-30T06:18:00 2019-10-30T06:18:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 264 MOULTRIE ST, SAN FRANCISCO, CA, 94110 MOULTRIE ST 9 Bernal Heights INGLESIDE 37.7408474 -122.4159219 POINT (-122.4159219 37.7408474) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
31697 31697 11608210 2019-10-27T11:24:06 2019-10-28T06:44:35 2019-10-30T06:14:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 186 BREWSTER ST, SAN FRANCISCO, CA, 94110 BREWSTER ST 9 Peralta Heights INGLESIDE 37.74346920000001 -122.40750449999999 POINT (-122.4075045 37.7434692) Web   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
68499 68499 11558975 2019-10-16T13:25:00 2019-10-29T12:31:47 2019-10-30T06:00:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3530 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758721760509 -122.41976916801399 POINT (-122.41976917 37.75872176) Mobile/Open311 http://mobile311.sfgov.org/reports/11558975/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
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
43463 43463 11566340 2019-10-17T23:13:00 2019-10-29T12:30:27 2019-10-30T06:00:30 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CORTLAND AVE and PROSPECT AVE CORTLAND AVE 9 Holly Park INGLESIDE 37.740241 -122.42087920000002 POINT (-122.4208792 37.740241) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
79943 79943 11565239 2019-10-17T16:45:00 2019-10-29T12:30:12 2019-10-30T06:00:26 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 621 JARBOE AVE, SAN FRANCISCO, CA, 94110 JARBOE AVE 9 Bernal Heights INGLESIDE 37.738296666667 -122.412405 POINT (-122.412405 37.73829667) Mobile/Open311 http://mobile311.sfgov.org/reports/11565239/photos 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
7039 7039 11615523 2019-10-29T05:44:00 2019-10-29T11:25:34 2019-10-30T06:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of ELLSWORTH ST and BERNAL HEIGHTS BLVD ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742402488401 -122.414591414968 POINT (-122.41459141 37.74240249) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
33660 33660 11613532 2019-10-28T14:35:00   2019-10-30T06:00:08 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MANSELL ST and VISITACION AVE MANSELL ST 10 McLaren Park INGLESIDE 37.718753814696996 -122.411674499512 POINT (-122.4116745 37.71875381) Phone   73 9 9 19 8 9 4 309 7 18 18   73   9             2         73
33054 33054 11611736 2019-10-28T10:04:00 2019-10-28T10:27:04 2019-10-30T06:00:07 Closed 2 Made Safe DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1775 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Silver Terrace BAYVIEW 37.735710144043004 -122.39426422119101 POINT (-122.39426422 37.73571014) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
102223 102223 11614284 2019-10-28T16:38:00   2019-10-30T05:55:08 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 487 HARKNESS AVE, SAN FRANCISCO, CA, 94134 HARKNESS AVE 10 Visitacion Valley INGLESIDE 37.718445 -122.406655 POINT (-122.406655 37.718445) Mobile/Open311 http://mobile311.sfgov.org/reports/11614284/photos 75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
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
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
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
30721 30721 11605180 2019-10-26T12:25:00 2019-10-30T00:25:18 2019-10-30T00:25:18 Closed 2 complete DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1431 19TH ST, SAN FRANCISCO, CA, 94107 19TH ST 10 Potrero Hill BAYVIEW 37.761285 -122.39676399999999 POINT (-122.396764 37.761285) Mobile/Open311 http://mobile311.sfgov.org/reports/11605180/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
25567 25567 11595048 2019-10-24T10:08:00 2019-10-29T11:27:03 2019-10-30T00:00:00 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 80 THOR AVE, SAN FRANCISCO, CA, 94131 THOR AVE 8 Glen Park INGLESIDE 37.734819705998994 -122.434214153773 POINT (-122.43421415 37.73481971) Mobile/Open311 http://mobile311.sfgov.org/reports/11595048/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
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
102280 102280 8620513 2018-02-11T15:21:54 2019-10-29T00:00:00 2019-10-29T22:10:07 Closed 2 request made to repair sidewalk but may takeover. year Notes:SIRP Abatement Completed. BUF Action:Repair Sidewalk. date completed - 10/29/2019. BUF Action:Basin Expansion. date completed - 10/29/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 4650 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Sutro Heights RICHMOND 37.775367423927 -122.509019924442 POINT (-122.50901992 37.77536742) Mobile/Open311   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
31766 31766 11608554 2019-10-27T12:44:00 2019-10-29T21:14:00 2019-10-29T21:14:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GUERRERO ST and 26TH ST GUERRERO ST 8 Mission MISSION 37.74877166748 -122.422569274902 POINT (-122.42256927 37.74877167) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
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
35783 35783 11618690 2019-10-29T14:49:00 2019-10-29T15:04:43 2019-10-29T18:59:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 299 SANTA PAULA AVE, SAN FRANCISCO, CA, 94127 SANTA PAULA AVE 7 Monterey Heights TARAVAL 37.735641479492 -122.463340759277 POINT (-122.46334076 37.73564148) Phone   69 10 8 41 4 9 5 59 8 40 40   69   8             1         69
4680 4680 11516786 2019-10-07T11:32:33   2019-10-29T18:35:58 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LAWTON ST and 7TH AVE LAWTON ST 7 Inner Sunset PARK 37.758573331463 -122.463848559636 POINT (-122.46384856 37.75857333) Mobile/Open311   109 7 8 14 4 1 8 56 5 12 12   109   8             1         109
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

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