calls

80,878 rows where Category = 1 sorted by :@computed_region_pigm_ib2e 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
6722 6722 11608576 2019-10-27T12:49:00 2019-10-27T22:15:21 2019-10-27T22:15:21 Closed 2 Request is a duplicate and has been previously reported as 9885451 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 600 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Haight Ashbury PARK 37.770812988281 -122.45368957519501 POINT (-122.45368958 37.77081299) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
13619 13619 11446795 2019-09-21T12:31:30 2019-10-01T09:59:11 2019-10-01T09:59:11 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1312 WALLER ST, SAN FRANCISCO, CA, 94117 (Virtual) WALLER ST 5 Haight Ashbury PARK 37.769320969951 -122.44539934509301 POINT (-122.44539935 37.76932097) Mobile/Open311 http://mobile311.sfgov.org/reports/11446795/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
26961 26961 11505217 2019-10-04T13:08:00 2019-10-11T08:39:28 2019-10-11T08:39:28 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1510 PAGE ST, SAN FRANCISCO, CA, 94117 (Virtual) PAGE ST 5 Haight Ashbury PARK 37.771172050759 -122.44571225630199 POINT (-122.44571226 37.77117205) Mobile/Open311 http://mobile311.sfgov.org/reports/11505217/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
28057 28057 11601786 2019-10-25T14:42:40 2019-10-25T15:54:31 2019-10-25T15:54:31 Closed 2 contacted school to let them know they must remove the sign. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1532 PAGE ST, SAN FRANCISCO, CA, 94117 (Virtual) PAGE ST 5 Haight Ashbury PARK 37.77107 -122.446013333333 POINT (-122.44601333 37.77107) Mobile/Open311 http://mobile311.sfgov.org/reports/11601786/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
43788 43788 11465123 2019-09-25T14:03:00 2019-09-25T15:03:00 2019-09-25T15:03:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PAGE ST and MASONIC AVE PAGE ST 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
47143 47143 11416342 2019-09-14T16:12:00   2019-09-24T08:00:58 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1632 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772065904708 -122.446262096588 POINT (-122.4462621 37.7720659) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
47708 47708 11433919 2019-09-18T15:28:00 2019-09-24T08:35:17 2019-09-24T08:35:17 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1500 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.771266499999996 -122.4459055 POINT (-122.4459055 37.7712665) Web   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
52777 52777 11465023 2019-09-25T13:45:37   2019-09-25T15:25:04 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 613 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Haight Ashbury PARK 37.7696466 -122.44870379999999 POINT (-122.4487038 37.7696466) Web   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
57865 57865 11482808 2019-09-29T23:11:32   2019-09-29T23:21:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1312 WALLER ST, SAN FRANCISCO, CA, 94117 (Virtual) WALLER ST 5 Haight Ashbury PARK 37.769328163578 -122.44530858986401 POINT (-122.44530859 37.76932816) Mobile/Open311   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
64064 64064 10941704 2019-06-02T09:47:00   2019-10-04T13:40:13 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1361 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.769078819916004 -122.44605074010201 POINT (-122.44605074 37.76907882) Mobile/Open311 http://mobile311.sfgov.org/reports/10941704/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
70613 70613 11550302 2019-10-14T17:46:58 2019-10-18T14:28:09 2019-10-18T14:28:09 Closed 2 We are working with Friends of the urban forest to replace these trees DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1517 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Cole Valley PARK 37.768785368091 -122.448807854688 POINT (-122.44880785 37.76878537) Mobile/Open311 http://mobile311.sfgov.org/reports/11550302/photos 29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
70928 70928 11342742 2019-08-29T16:12:02 2019-10-01T10:00:01 2019-10-01T10:00:01 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1001 MASONIC AVE, SAN FRANCISCO, CA, 94117 (Virtual) MASONIC AVE 5 Haight Ashbury PARK 37.771958333333004 -122.44580833333299 POINT (-122.44580833 37.77195833) Mobile/Open311 http://mobile311.sfgov.org/reports/11342742/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
72860 72860 11379727 2019-09-06T16:29:00 2019-10-03T14:04:33 2019-10-03T14:04:33 Closed 2 I have emailed the constituent about this issue DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1672 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770935058594 -122.448272705078 POINT (-122.44827271 37.77093506) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
73391 73391 11482810 2019-09-29T23:12:38 2019-10-03T16:04:28 2019-10-03T16:04:28 Closed 2 this block has really good sidewalk clearance. unsure what the caller is referring to. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1524 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768838644708 -122.449019646064 POINT (-122.44901965 37.76883864) Mobile/Open311   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
73796 73796 11494687 2019-10-02T11:01:05 2019-10-03T15:52:08 2019-10-03T15:52:08 Closed 2 made sure they are on the watering list. it could be transplanting shock. will alert watering crews. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1510 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.76886709038 -122.44865463126699 POINT (-122.44865463 37.76886709) Mobile/Open311 http://mobile311.sfgov.org/reports/11494687/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
81591 81591 11220932 2019-08-03T11:19:00 2019-10-18T08:24:01 2019-10-18T08:24:01 Closed 2 sent to crews Notes:please remove dead plum tree and grind stump :: Closed By CMMS SO 1199046. BUF Action:Remove Tree. date completed - 10/18/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1901 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770160675049 -122.452247619629 POINT (-122.45224762 37.77016068) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
82868 82868 11563377 2019-10-17T11:35:00 2019-10-18T09:44:14 2019-10-18T09:44:14 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1544 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.771099090576 -122.446723937988 POINT (-122.44672394 37.77109909) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
99893 99893 9506083 2018-09-06T18:25:00 2019-04-09T08:08:56 2019-04-09T08:08:56 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: RPD GGP Queue 14 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
116159 116159 6820107 2017-02-08T12:00:35 2017-02-14T10:05:11 2017-02-14T10:05:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1833 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770133947317 -122.451002717623 POINT (-122.45100272 37.77013395) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
131356 131356 5422329 2016-01-01T10:26:21 2016-01-05T01:31:30 2016-01-05T01:31:30 Closed 2 resolved: Request Letter Sent. two letters previously sent. a third warning letter to be sent will require replacement or a violation to be issued. 2 empty basins ifo 1361 Waller. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DELMAR ST and WALLER ST DELMAR ST 5 Haight Ashbury PARK 37.769111666667 -122.445991666667 POINT (-122.44599167 37.76911167) Mobile/Open311 http://mobile311.sfgov.org/reports/5422329/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
132213 132213 4056412 2014-09-28T19:11:54 2016-04-11T17:21:23 2016-04-11T17:21:23 Closed 2 sent direct DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1630 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769783188888 -122.44912485639799 POINT (-122.44912486 37.76978319) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
139174 139174 4811273 2015-06-08T13:15:46 2015-06-09T12:00:00 2015-06-09T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:Tree requires proper staking. If not supported correctly, tree is more susceptible to vandalism, damage, and may not establish. Please contact us for staking specs. Second notice.. BUF Action:Inspect. date completed - 6/9/2015. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1701 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.76936828552 -122.45095838353001 POINT (-122.45095838 37.76936829) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
143232 143232 4477703 2015-02-10T00:37:42 2015-02-10T10:30:52 2015-02-10T10:30:52 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1889 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Haight Ashbury PARK 37.771362304688 -122.450302124023 POINT (-122.45030212 37.7713623) Integrated Agency   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
225374 225374 11424326 2019-09-16T16:11:00 2019-09-17T11:04:00 2019-09-17T11:04:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1430 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.769134521484 -122.447372436523 POINT (-122.44737244 37.76913452) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
235036 235036 9279433 2018-07-17T14:00:00   2018-07-17T15:09:50 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1750 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768447875977 -122.45252227783199 POINT (-122.45252228 37.76844788) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
270048 270048 9359291 2018-08-04T13:51:00 2019-05-17T09:49:50 2019-05-17T09:49:50 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 534 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.770503999999995 -122.446549 POINT (-122.446549 37.770504) Mobile/Open311   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
283694 283694 9138832 2018-06-14T18:51:00 2018-08-16T07:00:42 2018-08-16T07:00:42 Closed 2 Issue has been resolved or a work order was issued to the appropriate division. RPD GGP Queue 14 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
283821 283821 9084184 2018-06-02T11:20:00 2018-06-14T06:57:50 2018-06-14T06:57:50 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
287594 287594 9254347 2018-07-11T16:57:00 2018-07-20T14:38:00 2018-07-20T14:38:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1420 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.769142150879 -122.447067260742 POINT (-122.44706726 37.76914215) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
292219 292219 9633455 2018-10-05T18:19:00 2018-10-05T20:58:12 2018-10-05T20:58:12 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1762 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770706176758 -122.449813842773 POINT (-122.44981384 37.77070618) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
304115 304115 9511019 2018-09-07T19:35:00 2018-09-11T00:25:10 2018-09-11T00:25:10 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 600 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Haight Ashbury PARK 37.770812988281 -122.45368957519501 POINT (-122.45368958 37.77081299) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
312968 312968 9655939 2018-10-11T04:33:57 2018-10-16T05:50:00 2018-10-16T05:50:00 Closed 2 Crew backfilled 10/12/18 DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of HAIGHT ST and ASHBURY ST HAIGHT ST 5 Haight Ashbury PARK 37.770031484227 -122.446917644199 POINT (-122.44691764 37.77003148) Mobile/Open311   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
316570 316570 9510687 2018-09-07T17:46:09 2018-09-19T13:00:02 2018-09-19T13:00:02 Closed 2 limb has been cleared DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2076 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.77109 -122.45349499999999 POINT (-122.453495 37.77109) Mobile/Open311 http://mobile311.sfgov.org/reports/9510687/photos 24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
330181 330181 9470926 2018-08-29T15:35:16 2018-09-06T18:04:28 2018-09-06T18:04:28 Closed 2 request in the system at 1649 haight to remove stump. tree will,be replanted under haight streetscape project DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1640 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769725266022 -122.44926815111 POINT (-122.44926815 37.76972527) Mobile/Open311 http://mobile311.sfgov.org/reports/9470926/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
330244 330244 9509886 2018-09-07T15:15:00 2018-09-14T09:52:00 2018-09-14T09:52:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 2017 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Haight Ashbury PARK 37.771083831787 -122.45250701904301 POINT (-122.45250702 37.77108383) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
334118 334118 9510464 2018-09-07T16:54:55 2018-09-13T00:00:00 2018-09-13T00:00:00 Closed 2 need,to likely post,for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 22 OAK ACCESS RD, SAN FRANCISCO, CA, 94117 (Virtual) OAK ACCESS RD 5 Panhandle PARK 37.771084355226 -122.45353901770201 POINT (-122.45353902 37.77108436) Mobile/Open311 http://mobile311.sfgov.org/reports/9510464/photos 24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
345485 345485 8312195 2017-11-27T00:53:00 2017-11-29T07:22:00 2017-11-29T07:22:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of HAIGHT ST and MASONIC AVE HAIGHT ST 5 Haight Ashbury PARK 37.770210266113 -122.445343017578 POINT (-122.44534302 37.77021027) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
360658 360658 9466751 2018-08-28T19:15:44 2018-09-06T18:05:53 2018-09-06T18:05:53 Closed 2 duplicate request. request is in system for stump,removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1640 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769725266022 -122.44926815111 POINT (-122.44926815 37.76972527) Mobile/Open311 http://mobile311.sfgov.org/reports/9466751/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
372783 372783 9655009 2018-10-10T17:52:00 2018-10-10T22:04:04 2018-10-10T22:04:04 Closed 2 ending DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1762 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770706176758 -122.449813842773 POINT (-122.44981384 37.77070618) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
376878 376878 9576612 2018-09-22T17:54:00 2019-05-17T09:47:40 2019-05-17T09:47:40 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BELVEDERE ST and WALLER ST BELVEDERE ST 5 Cole Valley PARK 37.768730163574 -122.44945526123001 POINT (-122.44945526 37.76873016) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
389166 389166 9721364 2018-10-25T15:36:08 2018-10-29T09:54:08 2018-10-29T09:54:08 Closed 2 yes we are aware of this insect. a native insect that defoliates the tree. it is temporary and doesn't usually cause any detrimental damage to the tree. we don't use chemicals on trees in the public right of way. thanks DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1844 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.771667480469 -122.449629450676 POINT (-122.44962945 37.77166748) Mobile/Open311 http://mobile311.sfgov.org/reports/9721364/photos 24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
426714 426714 9413106 2018-08-16T17:21:00 2018-08-17T11:08:52 2018-08-17T11:08:52 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1436 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.769264 -122.44750900000001 POINT (-122.447509 37.769264) Web http://mobile311.sfgov.org/reports/9413106/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
432663 432663 10373757 2019-01-18T09:35:00 2019-01-29T09:33:00 2019-01-29T09:33:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1525 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Cole Valley PARK 37.768646240234 -122.449111938477 POINT (-122.44911194 37.76864624) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
452583 452583 9906443 2018-12-07T20:39:00 2018-12-11T00:25:32 2018-12-11T00:25:32 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 629 STANYAN ST, SAN FRANCISCO, CA, 94117 (Virtual) STANYAN ST 5 Golden Gate Park PARK 37.77045 -122.453833333333 POINT (-122.45383333 37.77045) Mobile/Open311 http://mobile311.sfgov.org/reports/9906443/photos 9 7 11 12 11 11 8 29,492 5 8 8 22 9   11 24     25     1         9
465619 465619 10322741 2019-01-06T18:47:00 2019-01-10T00:30:08 2019-01-10T00:30:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1762 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770706176758 -122.449813842773 POINT (-122.44981384 37.77070618) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
478952 478952 9866338 2018-11-29T08:23:00   2018-12-13T10:45:08 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ASHBURY ST and WALLER ST ASHBURY ST 5 Haight Ashbury PARK 37.769073486328004 -122.446746826172 POINT (-122.44674683 37.76907349) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
480867 480867 9885451 2018-12-03T14:53:00   2018-12-03T15:45:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of HAIGHT ST and STANYAN ST HAIGHT ST 5 Golden Gate Park PARK 37.769165039063 -122.45353698730499 POINT (-122.45353699 37.76916504) Phone   9 7 11 3 11 11 8 29,492 5 9 9 22 9   11 24     25     1         9
482499 482499 9906446 2018-12-07T20:39:00 2019-04-06T13:16:27 2019-04-06T13:16:27 Closed 2 Thanks for reporting this empty basin. Currently, the City has limited planting resources and is focused on planting in certain districts with low canopy coverage. We suggest contacting friends of the urban forest (FUF) or planting through a landscape company. FUF has their own timeline for plantings, but a new tree can usually be planted within the year. If you plant the tree on your own please apply for a tree planting permit and choose a tree from our recommended species list found at sfpubli DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 624 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Haight Ashbury PARK 37.770505559482004 -122.45363767069401 POINT (-122.45363767 37.77050556) Mobile/Open311 http://mobile311.sfgov.org/reports/9906446/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
488149 488149 9879852 2018-12-02T13:07:00 2018-12-06T07:55:12 2018-12-06T07:55:12 Closed 2 not a hazard - 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 is 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 y DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 508 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Haight Ashbury PARK 37.770317077637 -122.450210571289 POINT (-122.45021057 37.77031708) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
488643 488643 10381135 2019-01-20T07:29:00 2019-01-29T09:33:00 2019-01-29T09:33:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1534 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768805 -122.44911166666701 POINT (-122.44911167 37.768805) Mobile/Open311 http://mobile311.sfgov.org/reports/10381135/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
510827 510827 10368622 2019-01-17T09:38:00 2019-01-17T22:20:57 2019-01-17T22:20:57 Closed 2 Request is a duplicate and has been previously reported as 10368622 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 554 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Haight Ashbury PARK 37.769942 -122.44846299999999 POINT (-122.448463 37.769942) Mobile/Open311 http://mobile311.sfgov.org/reports/10368622/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
512415 512415 9947250 2018-12-17T16:11:00   2018-12-17T16:20:10 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1790 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770664215088 -122.450164794922 POINT (-122.45016479 37.77066422) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
519222 519222 10344322 2019-01-11T09:50:00 2019-01-16T05:10:00 2019-01-16T05:10:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 712 SHRADER ST, SAN FRANCISCO, CA, 94117 SHRADER ST 5 Cole Valley PARK 37.76831817627 -122.45158386230499 POINT (-122.45158386 37.76831818) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
522702 522702 9993862 2018-12-31T00:06:58 2019-01-02T14:12:01 2019-01-02T14:12:01 Closed 2 we cannot replace at this moment due to planting funding issues but property owners invited to plant and water replacements DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1512 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768833 -122.448776 POINT (-122.448776 37.768833) Mobile/Open311 http://mobile311.sfgov.org/reports/9993862/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
569814 569814 10640910 2019-03-24T17:56:00   2019-03-24T18:40:03 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 623 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Haight Ashbury PARK 37.769565582275 -122.44860076904301 POINT (-122.44860077 37.76956558) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
573751 573751 10543667 2019-02-27T23:26:00 2019-03-04T22:29:54 2019-03-04T22:29:54 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1486 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768994799999994 -122.4481665 POINT (-122.4481665 37.7689948) Web   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
590082 590082 10633668 2019-03-22T12:04:00 2019-03-22T12:11:00 2019-03-22T12:11:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MASONIC AVE and WALLER ST MASONIC AVE 5 Haight Ashbury PARK 37.769283294678004 -122.445106506348 POINT (-122.44510651 37.76928329) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
592533 592533 10472080 2019-02-10T15:23:00 2019-02-12T14:48:00 2019-02-12T14:48:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1654 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770941646674 -122.44805546902701 POINT (-122.44805547 37.77094165) Mobile/Open311 http://mobile311.sfgov.org/reports/10472080/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
598154 598154 10625691 2019-03-20T14:01:00 2019-05-16T00:00:00 2019-05-16T00:00:00 Closed 2 possibly cabled opt out inspect please BUF Action:Posted Tree 15 Day. date completed - 5/16/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1901 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770160675049 -122.452247619629 POINT (-122.45224762 37.77016068) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
605417 605417 10430458 2019-01-31T08:36:00 2019-02-13T06:24:12 2019-02-13T06:24:12 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 401 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.771715 -122.447456 POINT (-122.447456 37.771715) Mobile/Open311 http://mobile311.sfgov.org/reports/10430458/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
624097 624097 10623169 2019-03-19T20:59:00 2019-03-19T21:09:43 2019-03-19T21:09:43 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1762 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770706176758 -122.449813842773 POINT (-122.44981384 37.77070618) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
627500 627500 10431240 2019-01-31T10:32:00   2019-02-07T12:35:03 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1727 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770542144775 -122.449264526367 POINT (-122.44926453 37.77054214) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
630375 630375 10471775 2019-02-10T13:49:00 2019-02-12T14:48:00 2019-02-12T14:48:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1639 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770725250244006 -122.44783020019501 POINT (-122.4478302 37.77072525) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
633284 633284 10430298 2019-01-31T08:13:00 2019-02-13T06:24:12 2019-02-13T06:24:12 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 401 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.771715 -122.447456 POINT (-122.447456 37.771715) Mobile/Open311 http://mobile311.sfgov.org/reports/10430298/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
637354 637354 10458841 2019-02-06T20:28:53 2019-05-30T08:59:36 2019-05-30T08:59:36 Closed 2 sent a request to crews for pruning. pls call 4155546700 for updates DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 403 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.771691 -122.44745 POINT (-122.44745 37.771691) Mobile/Open311   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
639154 639154 10465450 2019-02-08T11:17:00 2019-05-08T09:57:02 2019-05-08T09:57:02 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 is 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 for your pat DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1922 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.770415 -122.4525403 POINT (-122.4525403 37.770415) Web   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
644835 644835 10468646 2019-02-09T10:24:00 2019-05-07T07:04:00 2019-05-07T07:04:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 403 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Haight Ashbury PARK 37.771691 -122.44745 POINT (-122.44745 37.771691) Mobile/Open311 http://mobile311.sfgov.org/reports/10468646/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
648402 648402 10559266 2019-03-04T09:30:00   2019-03-20T11:04:27 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1206 MASONIC AVE, SAN FRANCISCO, CA, 94117 MASONIC AVE 5 Haight Ashbury PARK 37.770042419434 -122.445098876953 POINT (-122.44509888 37.77004242) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
660862 660862 337941 2008-12-23T15:29:25 2010-06-25T14:16:59 2010-06-25T14:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1787 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769290924071996 -122.451560974121 POINT (-122.45156097 37.76929092) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
662478 662478 403696 2009-04-02T16:35:57 2010-08-16T16:19:08 2010-08-16T16:19:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1727 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Cole Valley PARK 37.768253326416 -122.452178955078 POINT (-122.45217896 37.76825333) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
662574 662574 382958 2009-03-04T13:18:36 2009-03-09T11:10:10 2009-03-09T11:10:10 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1608 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.76989364624 -122.448921203613 POINT (-122.4489212 37.76989365) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
663917 663917 243666 2008-07-07T12:58:59 2008-07-14T12:05:10 2008-07-14T12:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of BELVEDERE ST and WALLER ST BELVEDERE ST 5 Cole Valley PARK 37.768730163574 -122.44945526123001 POINT (-122.44945526 37.76873016) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
671354 671354 416196 2009-04-21T15:20:55 2009-05-29T18:20:45 2009-05-29T18:20:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MASONIC AVE and PAGE ST MASONIC AVE 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
672963 672963 412697 2009-04-16T16:30:31 2009-05-13T17:10:36 2009-05-13T17:10:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of HAIGHT ST and SHRADER ST HAIGHT ST 5 Haight Ashbury PARK 37.769378662109 -122.451866149902 POINT (-122.45186615 37.76937866) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
674359 674359 278450 2008-09-09T07:18:09 2008-09-10T11:07:28 2008-09-10T11:07:28 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MASONIC AVE and PAGE ST MASONIC AVE 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
690086 690086 438540 2009-05-27T11:34:44 2009-06-04T16:10:47 2009-06-04T16:10:47 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1879 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Haight Ashbury PARK 37.771373748779 -122.45021820068399 POINT (-122.4502182 37.77137375) Web   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
690883 690883 404227 2009-04-03T11:39:40 2009-04-06T10:10:18 2009-04-06T10:10:18 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of CLAYTON ST and WALLER ST CLAYTON ST 5 Cole Valley PARK 37.768863677979 -122.448387145996 POINT (-122.44838715 37.76886368) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
691417 691417 414244 2009-04-18T22:09:08 2009-04-21T17:10:03 2009-04-21T17:10:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of COLE ST and WALLER ST COLE ST 5 Cole Valley PARK 37.768592834473 -122.450523376465 POINT (-122.45052338 37.76859283) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
694983 694983 416272 2009-04-21T16:39:13 2009-04-22T06:22:39 2009-04-22T06:22:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1520 PAGE ST, SAN FRANCISCO, CA, 94117 PAGE ST 5 Haight Ashbury PARK 37.77116394043 -122.446243286133 POINT (-122.44624329 37.77116394) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
696442 696442 287844 2008-09-26T07:31:36 2008-10-08T14:06:50 2008-10-08T14:06:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MASONIC AVE and PAGE ST MASONIC AVE 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
703260 703260 436915 2009-05-23T17:33:46 2009-05-29T17:41:55 2009-05-29T17:41:55 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of OAK ST and STANYAN ST OAK ST 5 Golden Gate Park PARK 37.771053314209 -122.453903198242 POINT (-122.4539032 37.77105331) Phone   9 7 11 12 11 15 8 29,492 5 8 8 22 9   11 24     25     1         9
703365 703365 295058 2008-10-09T11:24:34 2008-10-20T08:06:50 2008-10-20T08:06:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ASHBURY ST and OAK ST ASHBURY ST 5 Panhandle PARK 37.771877288818004 -122.447311401367 POINT (-122.4473114 37.77187729) Phone   24 7 11 3 11 15 8 29,492 5 9 9 22 24   11 24     25     1         24
705121 705121 262621 2008-08-10T18:12:24 2008-08-12T13:04:50 2008-08-12T13:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 1425 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Haight Ashbury PARK 37.768886566162 -122.447212219238 POINT (-122.44721222 37.76888657) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
706298 706298 403734 2009-04-02T17:01:30 2010-08-12T12:46:27 2010-08-12T12:46:27 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SHRADER ST and WALLER ST SHRADER ST 5 Cole Valley PARK 37.768444061279 -122.451675415039 POINT (-122.45167542 37.76844406) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
712441 712441 352813 2009-01-16T10:24:53 2010-08-16T16:19:07 2010-08-16T16:19:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of COLE ST and HAIGHT ST COLE ST 5 Haight Ashbury PARK 37.769527435303004 -122.45070648193399 POINT (-122.45070648 37.76952744) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
715034 715034 265876 2008-08-16T19:42:30 2008-08-19T10:06:42 2008-08-19T10:06:42 Closed 2 Case Resolved Sprinkler adjusted. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CLAYTON ST and OAK ST CLAYTON ST 5 Panhandle PARK 37.771667480469 -122.448959350586 POINT (-122.44895935 37.77166748) Phone   24 7 11 3 11 15 8 29,492 5 9 9 22 24   11 24     25     1         24
718537 718537 413113 2009-04-17T10:30:34 2009-04-17T14:10:25 2009-04-17T14:10:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 18 BELVEDERE ST, SAN FRANCISCO, CA, 94117 BELVEDERE ST 5 Haight Ashbury PARK 37.769359588623 -122.449432373047 POINT (-122.44943237 37.76935959) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
722292 722292 372845 2009-02-16T12:34:10 2009-04-02T10:05:18 2009-04-02T10:05:18 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1666 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769760131836 -122.449737548828 POINT (-122.44973755 37.76976013) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
724614 724614 393449 2009-03-20T18:32:55 2009-05-11T10:36:02 2009-05-11T10:36:02 Closed 2 no contact information provided to find out what the customer was asking for. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 1701 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.769367218018 -122.450958251953 POINT (-122.45095825 37.76936722) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
725278 725278 381504 2009-03-02T13:30:36 2009-03-11T15:10:08 2009-03-11T15:10:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1206 MASONIC AVE, SAN FRANCISCO, CA, 94117 MASONIC AVE 5 Haight Ashbury PARK 37.770042419434 -122.445098876953 POINT (-122.44509888 37.77004242) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
725965 725965 412381 2009-04-16T10:35:48 2009-04-17T14:10:29 2009-04-17T14:10:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 18 BELVEDERE ST, SAN FRANCISCO, CA, 94117 BELVEDERE ST 5 Haight Ashbury PARK 37.769359588623 -122.449432373047 POINT (-122.44943237 37.76935959) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
729535 729535 369027 2009-02-09T14:54:57 2010-10-26T09:59:31 2010-10-26T09:59:31 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1879 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Haight Ashbury PARK 37.771373748779 -122.45021820068399 POINT (-122.4502182 37.77137375) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
729998 729998 323972 2008-12-02T13:52:42 2009-01-15T08:07:15 2009-01-15T08:07:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of HAIGHT ST and MASONIC AVE HAIGHT ST 5 Haight Ashbury PARK 37.770210266113 -122.445343017578 POINT (-122.44534302 37.77021027) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
730866 730866 393329 2009-03-20T16:28:23 2010-12-22T10:54:22 2010-12-22T10:54:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of ASHBURY ST and HAIGHT ST ASHBURY ST 5 Haight Ashbury PARK 37.770008087158 -122.44692993164101 POINT (-122.44692993 37.77000809) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
731694 731694 272318 2008-08-28T12:41:31 2008-09-08T13:37:42 2008-09-08T13:37:42 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of MASONIC AVE and PAGE ST MASONIC AVE 5 Haight Ashbury PARK 37.771141052246 -122.44553375244101 POINT (-122.44553375 37.77114105) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
736152 736152 393325 2009-03-20T16:25:25 2010-10-27T06:09:34 2010-10-27T06:09:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1608 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Haight Ashbury PARK 37.76989364624 -122.448921203613 POINT (-122.4489212 37.76989365) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
738295 738295 259092 2008-08-04T08:41:25 2008-08-27T10:05:23 2008-08-27T10:05:23 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of OAK ST and STANYAN ST OAK ST 5 Golden Gate Park PARK 37.771053314209 -122.453903198242 POINT (-122.4539032 37.77105331) Phone   9 7 11 12 11 15 8 29,492 5 8 8 22 9   11 24     25     1         9
740787 740787 311250 2008-11-09T08:23:11 2010-08-04T17:17:03 2010-08-04T17:17:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ASHBURY ST and PAGE ST ASHBURY ST 5 Haight Ashbury PARK 37.770935058594 -122.447120666504 POINT (-122.44712067 37.77093506) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
745448 745448 417759 2009-04-23T17:44:23 2009-04-24T06:15:38 2009-04-24T06:15:38 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of HAIGHT ST and MASONIC AVE HAIGHT ST 5 Haight Ashbury PARK 37.770210266113 -122.445343017578 POINT (-122.44534302 37.77021027) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
754367 754367 381501 2009-03-02T13:27:37 2009-03-11T15:10:07 2009-03-11T15:10:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1206 MASONIC AVE, SAN FRANCISCO, CA, 94117 MASONIC AVE 5 Haight Ashbury PARK 37.770042419434 -122.445098876953 POINT (-122.44509888 37.77004242) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25

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