calls

80,878 rows sorted by :@computed_region_9jxd_iqea 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
16042 16042 11511885 2019-10-06T10:00:00   2019-10-31T11:40:13 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 606 KANSAS ST, SAN FRANCISCO, CA, 94107 KANSAS ST 10 Potrero Hill BAYVIEW 37.761909484863 -122.403427124023 POINT (-122.40342712 37.76190948) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
19513 19513 5655407 2016-03-11T11:23:42 2016-06-17T23:42:34 2016-06-17T23:42:34 Closed 2 Per PSA manager: Damaged tree removed RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other Utah and 18th Mini Park, , SAN FRANCISCO, CA, 94110 Utah and 18th Mini Park 10 Potrero Hill BAYVIEW 37.762384000000004 -122.40616100000001 POINT (-122.406161 37.762384) Mobile/Open311 http://mobile311.sfgov.org/reports/5655407/photos 54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
19722 19722 5653750 2016-03-10T18:03:42 2016-04-11T19:35:44 2016-04-11T19:35:44 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760659133495004 -122.407067688893 POINT (-122.40706769 37.76065913) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
22242 22242 11533306 2019-10-10T14:27:00   2019-10-10T14:35:25 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 16TH ST and SAN BRUNO AVE 16TH ST 10 Potrero Hill MISSION 37.765899658203004 -122.405586242676 POINT (-122.40558624 37.76589966) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
24669 24669 11590897 2019-10-23T11:41:00   2019-10-31T11:35:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 430 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.764137268066 -122.40557861328101 POINT (-122.40557861 37.76413727) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
44442 44442 11078320 2019-07-02T18:18:19 2019-10-12T10:08:59 2019-10-12T10:08:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MARIPOSA ST and UTAH ST MARIPOSA ST 10 Potrero Hill BAYVIEW 37.763226242624 -122.406221767283 POINT (-122.40622177 37.76322624) Mobile/Open311 http://mobile311.sfgov.org/reports/11078320/photos 54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
48184 48184 11442877 2019-09-20T13:01:00 2019-09-24T05:08:30 2019-09-24T05:08:30 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 - Tree_Other 4 Other 666 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.7611583 -122.4044505 POINT (-122.4044505 37.7611583) Web   54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
48270 48270 11444221 2019-09-20T16:44:00 2019-09-26T14:24:00 2019-09-26T14:24:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 501 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763191223145 -122.40721893310499 POINT (-122.40721893 37.76319122) Phone http://mobile311.sfgov.org/reports/11444221/photos 54 3 9 20 8 8 7 28,859 4 19 19   54   9     3   15   2   3     54
68899 68899 11568411 2019-10-18T11:31:00   2019-10-18T11:40:38 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 18TH ST and VERMONT ST 18TH ST 10 Potrero Hill BAYVIEW 37.762111663818004 -122.404258728027 POINT (-122.40425873 37.76211166) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
73575 73575 10448843 2019-02-04T17:35:00 2019-02-04T19:07:31 2019-02-04T19:07:31 Closed 2 completed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2007 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 10 Potrero Hill MISSION 37.765682220459 -122.406860351563 POINT (-122.40686035 37.76568222) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
77039 77039 11549043 2019-10-14T13:15:00 2019-10-17T05:12:59 2019-10-17T05:12: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 Near_communication_line 465 UTAH ST, SAN FRANCISCO, CA, 94110 UTAH ST 10 Potrero Hill MISSION 37.763710021973 -122.40617370605499 POINT (-122.40617371 37.76371002) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
96714 96714 9694592 2018-10-19T13:17:00 2019-01-29T10:28:01 2019-01-29T10:28:01 Closed 2 Since StreetTreeSF went into effect on July 1, 2017, we have been working on the worst first. The pruning of the most problematic street trees is prioritized based on safety considerations, to correct structural flaws and to gain necessary clearances for overhead wires, traffic signs and signals, adjacent buildings and traffic flow. Trees that do not pose safety concerns also continue to be pruned by tree crews. You can find out when nearby street trees will be pruned by visiting www.sfpublicwor DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 546 UTAH ST, SAN FRANCISCO, CA, 94110 UTAH ST 10 Potrero Hill BAYVIEW 37.762357835633004 -122.406220141453 POINT (-122.40622014 37.76235784) Mobile/Open311   54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
100019 100019 9492594 2018-09-04T10:06:00 2019-02-16T00:15:22 2019-02-16T00:15:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 401 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.764293670654 -122.407188415527 POINT (-122.40718842 37.76429367) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
123839 123839 6212611 2016-08-18T21:57:42 2016-08-22T13:55:34 2016-08-22T13:55:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
144925 144925 4348246 2014-12-30T23:15:58 2015-01-27T12:25:00 2015-01-27T12:25:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of POTRERO AVE and 17TH ST POTRERO AVE 10 Mission MISSION 37.764488092197 -122.407422042315 POINT (-122.40742204 37.76448809) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
174135 174135 9161169 2018-06-20T10:31:43 2018-06-20T11:31:13 2018-06-20T11:31:13 Closed 2 Since implementation of prop e in July trees are being pruned on a block by block basis beginning with trees in the poorest condition. This tree will be pruned when the whole block is pruned. see http://sfpublicworks.org/streettreesf to se when this location is scheduled. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 630 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.761635812966 -122.404375970478 POINT (-122.40437597 37.76163581) Mobile/Open311 http://mobile311.sfgov.org/reports/9161169/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
178368 178368 9134238 2018-06-13T20:38:40 2018-06-27T14:44:02 2018-06-27T14:44:02 Closed 2 BUF is investigating the matter and will issue fines where appropriate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2246 19TH ST, SAN FRANCISCO, CA, 94107 19TH ST 10 Potrero Hill BAYVIEW 37.760929889081 -122.405028166363 POINT (-122.40502817 37.76092989) Mobile/Open311 http://mobile311.sfgov.org/reports/9134238/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
181916 181916 9323088 2018-07-27T09:10:12 2018-09-06T14:37:09 2018-09-06T14:37:09 Closed 2 Trees still have green leaves and may have experienced initial planting shock. please co tact friends of the urban forest if trees die DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2248 MARIPOSA ST, SAN FRANCISCO, CA, 94110 MARIPOSA ST 10 Potrero Hill BAYVIEW 37.763324724545 -122.406022679175 POINT (-122.40602268 37.76332472) Mobile/Open311 http://mobile311.sfgov.org/reports/9323088/photos 54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
191007 191007 9337432 2018-07-30T16:54:00 2018-09-06T14:34:53 2018-09-06T14:34:53 Closed 2 Low voltage and communication lines are designed to contact trees and do not pose a hazard. do not top trees below these lines. Since implementation of prop e in July 2017 trees are being pruned on a block by block basis beginning with trees in the poorest condition. This tree will be pruned when the whole block is pruned. see http://sfpublicworks.org/streettreesf to se when this location is scheduled. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of SAN BRUNO AVE and 17TH ST SAN BRUNO AVE 10 Potrero Hill MISSION 37.76460647583 -122.405464172363 POINT (-122.40546417 37.76460648) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9     2   15   2   2     54
218204 218204 9187959 2018-06-26T12:02:00 2018-06-28T07:17:05 2018-06-28T07:17:05 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 patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2330 17TH ST, SAN FRANCISCO, CA, 94103 17TH ST 10 Potrero Hill MISSION 37.764641666666996 -122.407088333333 POINT (-122.40708833 37.76464167) Mobile/Open311 http://mobile311.sfgov.org/reports/9187959/photos 54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
262000 262000 9184540 2018-06-25T16:10:00 2018-06-28T07:19:21 2018-06-28T07:19:21 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 patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 2007 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 10 Potrero Hill MISSION 37.765682220459 -122.406860351563 POINT (-122.40686035 37.76568222) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
273730 273730 9161177 2018-06-20T10:32:14 2018-06-20T11:30:52 2018-06-20T11:30:52 Closed 2 Since implementation of prop e in July trees are being pruned on a block by block basis beginning with trees in the poorest condition. This tree will be pruned when the whole block is pruned. see http://sfpublicworks.org/streettreesf to se when this location is scheduled. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 630 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.761635812966 -122.404375970478 POINT (-122.40437597 37.76163581) Mobile/Open311 http://mobile311.sfgov.org/reports/9161177/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
289147 289147 9071614 2018-05-30T16:20:00 2018-05-30T17:06:00 2018-05-30T17:06:00 Closed 2 Case has been reallocated from DPW Ops Queue to CSP Supervisor Queue at 2018-05-30T16:50:03 : duplicate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2007 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 10 Potrero Hill MISSION 37.765682220459 -122.406860351563 POINT (-122.40686035 37.76568222) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
294895 294895 9560260 2018-09-19T07:36:00   2018-09-19T07:55:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2009 17TH ST, SAN FRANCISCO, CA, 94103 17TH ST 10 Potrero Hill SOUTHERN 37.764583587646 -122.40386962890601 POINT (-122.40386963 37.76458359) Phone   54 1 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
347832 347832 9481719 2018-08-31T19:29:00 2018-09-01T00:00:00 2018-09-01T00:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 401 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.764293670654 -122.407188415527 POINT (-122.40718842 37.76429367) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
432720 432720 10382337 2019-01-20T14:02:00 2019-01-24T00:25:08 2019-01-24T00:25:08 Closed 2 Complete. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 313 POTRERO AVE, SAN FRANCISCO, CA, 94103 POTRERO AVE 10 Potrero Hill MISSION 37.765598297119006 -122.40744781494101 POINT (-122.40744781 37.7655983) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     3   15   2   3     54
532401 532401 10354280 2019-01-14T09:30:23 2019-03-08T00:00:00 2019-03-08T00:00:00 Closed 2 Notes:Will be issuing a fine for this topping. Canopy has been reduced by 80%.. BUF Action:Inspect. date completed - 3/8/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 622 SAN BRUNO AVE, SAN FRANCISCO, CA, 94107 SAN BRUNO AVE 10 Potrero Hill BAYVIEW 37.761818538455 -122.405270151908 POINT (-122.40527015 37.76181854) Mobile/Open311 http://mobile311.sfgov.org/reports/10354280/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
550842 550842 9805029 2018-11-13T18:30:00 2018-11-19T10:43:00 2018-11-19T10:43:00 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 patien DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of VERMONT ST and MARIPOSA ST VERMONT ST 10 Potrero Hill BAYVIEW 37.763381958008 -122.40437316894501 POINT (-122.40437317 37.76338196) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
555368 555368 9805000 2018-11-13T18:21:00 2018-11-15T06:33:11 2018-11-15T06:33:11 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 patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of VERMONT ST and MARIPOSA ST VERMONT ST 10 Potrero Hill BAYVIEW 37.763381958008 -122.40437316894501 POINT (-122.40437317 37.76338196) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
566141 566141 10507568 2019-02-19T14:33:00 2019-02-26T14:20:50 2019-02-26T14:20:50 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 309 SAN BRUNO AVE, SAN FRANCISCO, CA, 94103 SAN BRUNO AVE 10 Potrero Hill MISSION 37.765815658529995 -122.405547509084 POINT (-122.40554751 37.76581566) Mobile/Open311 http://mobile311.sfgov.org/reports/10507568/photos 54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
587725 587725 10699450 2019-04-08T06:10:00 2019-04-09T12:04:00 2019-04-09T12:04:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 17TH ST and VERMONT ST 17TH ST 10 Potrero Hill SOUTHERN 37.764663696289 -122.404495239258 POINT (-122.40449524 37.7646637) Phone   54 1 9 26 8 8 3 28,856 3 29 29   54   9     2   15   1   2     54
597723 597723 10462721 2019-02-07T16:47:13 2019-04-07T09:52:09 2019-04-07T09:52:09 Closed 2 tree is in decline may need to be removed as part of this areas key map, PO could replant MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 461 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill SOUTHERN 37.763893813860996 -122.40442492079201 POINT (-122.40442492 37.76389381) Mobile/Open311 http://mobile311.sfgov.org/reports/10462721/photos 54 1 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
602066 602066 10536114 2019-02-26T11:02:00 2019-02-27T08:22:00 2019-02-27T08:22:00 Closed 2 needs a packer - on corner alarge pile of trees DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of VERMONT ST and MARIPOSA ST VERMONT ST 10 Potrero Hill BAYVIEW 37.763381958008 -122.40437316894501 POINT (-122.40437317 37.76338196) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
610578 610578 10479674 2019-02-12T11:13:00   2019-02-12T14:05:04 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 394 KANSAS ST, SAN FRANCISCO, CA, 94103 KANSAS ST 10 Potrero Hill SOUTHERN 37.764808654785 -122.403602600098 POINT (-122.4036026 37.76480865) Phone   54 1 9 4 8 8 3 28,853 3 20 20   54   9         15   1         54
611921 611921 10510623 2019-02-20T09:38:34 2019-03-08T16:31:19 2019-03-08T16:31:19 Closed 2 crews picked up tree brsnch DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 309 SAN BRUNO AVE, SAN FRANCISCO, CA, 94103 SAN BRUNO AVE 10 Potrero Hill MISSION 37.765834565599 -122.40553017347901 POINT (-122.40553017 37.76583457) Mobile/Open311 http://mobile311.sfgov.org/reports/10510623/photos 54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
641466 641466 10739641 2019-04-17T06:48:00 2019-07-05T12:45:00 2019-07-05T12:45:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 2009 17TH ST, SAN FRANCISCO, CA, 94103 17TH ST 10 Potrero Hill SOUTHERN 37.764583587646 -122.40386962890601 POINT (-122.40386963 37.76458359) Phone   54 1 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
673560 673560 448964 2009-06-12T12:20:19 2010-07-12T17:17:01 2010-07-12T17:17:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
677772 677772 295736 2008-10-10T14:00:18 2009-06-01T12:10:42 2009-06-01T12:10:42 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
686348 686348 363288 2009-01-31T14:32:19 2009-02-01T06:10:12 2009-02-01T06:10:12 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 513 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.762630462646 -122.40704345703101 POINT (-122.40704346 37.76263046) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
686832 686832 363270 2009-01-31T14:18:02 2009-02-04T09:09:55 2009-02-04T09:09:55 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
713025 713025 311683 2008-11-10T09:31:43 2008-11-10T13:07:00 2008-11-10T13:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
738990 738990 363278 2009-01-31T14:24:43 2009-02-01T06:10:03 2009-02-01T06:10:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
750119 750119 310051 2008-11-06T14:39:34 2008-12-24T19:17:01 2008-12-24T19:17:01 Closed 2 NOTED DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 625 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.761413574219 -122.40692138671899 POINT (-122.40692139 37.76141357) Phone   54 3 9 20 8 10 7 28,859 4 19 19   54   9         15   2         54
751631 751631 309938 2008-11-06T12:07:30 2010-07-12T15:17:00 2010-07-12T15:17:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 625 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.761413574219 -122.40692138671899 POINT (-122.40692139 37.76141357) Phone   54 3 9 20 8 10 7 28,859 4 19 19   54   9         15   2         54
753917 753917 259852 2008-08-05T10:47:05 2017-05-25T10:25:19 2017-05-25T10:25:19 Closed 2 sidewalk damage repaired DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 593 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.762084960938 -122.40699005126999 POINT (-122.40699005 37.76208496) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
762076 762076 363268 2009-01-31T14:15:50 2009-02-04T09:09:52 2009-02-04T09:09:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
767266 767266 421819 2009-04-30T03:52:05 2009-06-04T08:10:44 2009-06-04T08:10:44 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of 16TH ST and UTAH ST 16TH ST 10 Potrero Hill MISSION 37.765842437744006 -122.40655517578101 POINT (-122.40655518 37.76584244) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
769154 769154 343110 2009-01-02T13:33:50 2009-01-07T08:07:12 2009-01-07T08:07:12 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
782770 782770 259857 2008-08-05T10:49:48 2008-08-06T10:05:07 2008-08-06T10:05:07 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 593 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.762084960938 -122.40699005126999 POINT (-122.40699005 37.76208496) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
798794 798794 363282 2009-01-31T14:27:25 2010-12-21T14:09:21 2010-12-21T14:09:21 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
805686 805686 501068 2009-09-08T10:06:53 2009-10-07T08:16:39 2009-10-07T08:16:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
807353 807353 580473 2010-01-13T09:24:37 2010-09-11T08:18:10 2010-09-11T08:18:10 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
818166 818166 606338 2010-02-21T10:50:23 2010-02-26T09:16:39 2010-02-26T09:16:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
818836 818836 479996 2009-08-02T22:19:52 2009-09-30T08:16:19 2009-09-30T08:16:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 467 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763633728027 -122.407119750977 POINT (-122.40711975 37.76363373) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
821756 821756 535101 2009-10-30T13:44:45 2011-01-15T06:09:21 2011-01-15T06:09:21 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 585 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.762180328369006 -122.406997680664 POINT (-122.40699768 37.76218033) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
843547 843547 618137 2010-03-11T17:45:42 2010-05-19T11:16:51 2010-05-19T11:16:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
844691 844691 573670 2010-01-03T18:32:11 2012-10-26T10:00:23 2012-10-26T10:00:23 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed empty basin letter for the empty basin on the Mariposa St frontage of propert. Additionally submitted a work order for CM'd empty basins to be planted on the Potrero St frontage of property DM 10/26/12. BUF Action:Correspondence. date completed - 10/26/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
856350 856350 523842 2009-10-13T17:14:48 2009-10-14T15:16:45 2009-10-14T15:16:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 625 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.761413574219 -122.40692138671899 POINT (-122.40692139 37.76141357) Phone   54 3 9 20 8 10 7 28,859 4 19 19   54   9         15   2         54
864006 864006 488288 2009-08-16T18:58:08 2009-08-30T15:11:14 2009-08-30T15:11:14 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 313 POTRERO AVE, SAN FRANCISCO, CA, 94103 POTRERO AVE 10 Potrero Hill MISSION 37.765598297119006 -122.40744781494101 POINT (-122.40744781 37.7655983) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     3   15   2   3     54
879564 879564 523464 2009-10-13T13:35:33 2009-10-13T14:16:25 2009-10-13T14:16:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
891350 891350 488313 2009-08-16T19:41:14 2009-08-30T15:11:14 2009-08-30T15:11:14 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 301 POTRERO AVE, SAN FRANCISCO, CA, 94103 POTRERO AVE 10 Potrero Hill MISSION 37.765628814696996 -122.407325744629 POINT (-122.40732574 37.76562881) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
901430 901430 598092 2010-02-08T12:26:37 2010-04-09T13:16:42 2010-04-09T13:16:42 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
905312 905312 470326 2009-07-17T11:09:42 2009-07-18T07:11:04 2009-07-18T07:11:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 624 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.761711120605 -122.40437316894501 POINT (-122.40437317 37.76171112) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9         15   1         54
916866 916866 523214 2009-10-13T10:50:19 2009-10-13T12:16:26 2009-10-13T12:16:26 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
933326 933326 535042 2009-10-30T12:44:09 2009-11-10T10:16:32 2009-11-10T10:16:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 459 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763710021973 -122.407127380371 POINT (-122.40712738 37.76371002) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
938761 938761 533287 2009-10-27T14:34:37 2009-11-04T06:16:52 2009-11-04T06:16:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 314 UTAH ST, SAN FRANCISCO, CA, 94103 UTAH ST 10 Potrero Hill MISSION 37.765487670898 -122.40671539306601 POINT (-122.40671539 37.76548767) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
989825 989825 768051 2010-11-08T10:21:26 2011-01-07T15:09:21 2011-01-07T15:09:21 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 625 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.761413574219 -122.40692138671899 POINT (-122.40692139 37.76141357) Phone   54 3 9 20 8 10 7 28,859 4 19 19   54   9         15   2         54
1033710 1033710 661629 2010-05-24T08:38:29 2014-12-23T12:00:00 2014-12-23T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:18 Flags expand to curb + 1/2 FL. SMK, sidewalk repaired since request. BUF Action:Repair Sidewalk. date completed - 12/23/2014. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
1086054 1086054 863040 2011-04-15T11:49:02 2011-04-29T16:06:02 2011-04-29T16:06:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 528 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.762916564941 -122.40453338623001 POINT (-122.40453339 37.76291656) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
1093465 1093465 936521 2011-08-08T10:34:09 2014-03-19T13:18:38 2014-03-19T13:18:38 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 472 UTAH ST, SAN FRANCISCO, CA, 94110 UTAH ST 10 Potrero Hill MISSION 37.763610839844 -122.406494140625 POINT (-122.40649414 37.76361084) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1100388 1100388 901672 2011-06-16T00:17:57 2011-07-29T06:06:17 2011-07-29T06:06:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1108226 1108226 859587 2011-04-10T09:28:17 2011-04-18T14:06:08 2011-04-18T14:06:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 430 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.764137268066 -122.40557861328101 POINT (-122.40557861 37.76413727) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1125616 1125616 895867 2011-06-07T12:32:35 2011-10-31T08:07:04 2011-10-31T08:07:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
1127568 1127568 895712 2011-06-07T10:03:31 2011-06-29T15:06:09 2011-06-29T15:06:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 489 UTAH ST, SAN FRANCISCO, CA, 94110 UTAH ST 10 Potrero Hill MISSION 37.76350402832 -122.406150817871 POINT (-122.40615082 37.76350403) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1144783 1144783 895624 2011-06-07T08:22:17 2011-06-07T16:06:15 2011-06-07T16:06:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 17TH ST and UTAH ST 17TH ST 10 Potrero Hill MISSION 37.764549255371 -122.406425476074 POINT (-122.40642548 37.76454926) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9     2   15   2   2     54
1160994 1160994 832354 2011-02-25T12:36:40 2011-02-25T14:06:05 2011-02-25T14:06:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 528 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.762916564941 -122.40453338623001 POINT (-122.40453339 37.76291656) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
1175346 1175346 951755 2011-08-31T10:14:40 2011-09-02T06:11:13 2011-09-02T06:11:13 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
1181647 1181647 951812 2011-08-31T10:43:00 2011-09-02T06:11:15 2011-09-02T06:11:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 17TH ST and POTRERO AVE 17TH ST 10 Mission MISSION 37.764488220215 -122.407417297363 POINT (-122.4074173 37.76448822) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
1188542 1188542 934947 2011-08-05T10:25:24 2017-05-25T10:25:20 2017-05-25T10:25:20 Closed 2 all new sidewalk ifo 595 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 595 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.762077331543004 -122.406951904297 POINT (-122.4069519 37.76207733) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1217777 1217777 818177 2011-02-02T09:31:54 2011-09-30T08:10:36 2011-09-30T08:10:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
1223298 1223298 848685 2011-03-24T11:50:14 2011-03-24T13:06:06 2011-03-24T13:06:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 459 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763710021973 -122.407127380371 POINT (-122.40712738 37.76371002) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1242565 1242565 995940 2011-11-01T20:12:51 2013-03-06T12:32:12 2013-03-06T12:32:12 Closed 2 resolved: Request closed by SES . Notes = " Notes:C Buck Magnolia 'Sam Somers'. BUF Action:PLANT. date completed - 3/5/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1247483 1247483 1053834 2012-01-29T23:22:46 2016-06-11T11:03:35 2016-06-11T11:03:35 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 16TH ST and SAN BRUNO AVE 16TH ST 10 Potrero Hill MISSION 37.765899658203004 -122.405586242676 POINT (-122.40558624 37.76589966) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
1281664 1281664 1022475 2011-12-13T12:43:05 2011-12-19T15:09:07 2011-12-19T15:09:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of 16TH ST and UTAH ST 16TH ST 10 Potrero Hill MISSION 37.765842437744006 -122.40655517578101 POINT (-122.40655518 37.76584244) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
1282491 1282491 970852 2011-09-27T10:06:07 2011-09-28T15:05:51 2011-09-28T15:05:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
1306088 1306088 978183 2011-10-06T11:42:14 2011-11-15T10:07:02 2011-11-15T10:07:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 625 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.761413574219 -122.40692138671899 POINT (-122.40692139 37.76141357) Phone   54 3 9 20 8 10 7 28,859 4 19 19   54   9         15   2         54
1307495 1307495 1064679 2012-02-14T12:37:27 2013-03-06T11:47:24 2013-03-06T11:47:24 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 3/5/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1311704 1311704 1097041 2012-04-02T12:55:14 2012-04-04T06:07:52 2012-04-04T06:07:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1327880 1327880 1032195 2011-12-29T15:08:15   2011-12-29T15:09:56 Open 1 Open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 16TH ST and SAN BRUNO AVE 16TH ST 10 Potrero Hill MISSION 37.765899658203004 -122.405586242676 POINT (-122.40558624 37.76589966) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
1329185 1329185 1034360 2012-01-02T15:10:51 2012-08-22T15:45:54 2012-08-22T15:45:54 Closed 2 resolved: Request closed by SES . Notes = " Notes:Back Fill Letter Mailed. BUF Action:Correspondence. date completed - 8/22/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of 16TH ST and UTAH ST 16TH ST 10 Potrero Hill MISSION 37.765842437744006 -122.40655517578101 POINT (-122.40655518 37.76584244) Phone   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
1332204 1332204 1064676 2012-02-14T12:36:25 2013-03-06T11:47:13 2013-03-06T11:47:13 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 3/5/2013. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1406807 1406807 1456987 2012-09-22T00:00:08 2012-09-22T02:15:20 2012-09-22T02:15:20 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760662078857 -122.407066345215 POINT (-122.40706635 37.76066208) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
1443137 1443137 1172205 2012-07-22T16:04:08 2012-08-03T10:15:56 2012-08-03T10:15:56 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 18TH ST and UTAH ST 18TH ST 10 Potrero Hill BAYVIEW 37.7619972229 -122.406181335449 POINT (-122.40618134 37.76199722) Phone   54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1482814 1482814 1811412 2012-12-22T12:20:55 2012-12-22T13:16:16 2012-12-22T13:16:16 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2345 MARIPOSA ST, SAN FRANCISCO, CA, 94110 MARIPOSA ST 10 Potrero Hill MISSION 37.763111114502 -122.40690612793001 POINT (-122.40690613 37.76311111) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1509673 1509673 2251198 2013-04-16T12:51:19 2014-04-16T14:29:56 2014-04-16T14:29:56 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 430 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.764137268066 -122.40557861328101 POINT (-122.40557861 37.76413727) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
1515363 1515363 2425127 2013-05-29T15:01:30 2014-04-02T11:19:51 2014-04-02T11:19:51 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 2116 18TH ST, SAN FRANCISCO, CA, 94107 18TH ST 10 Potrero Hill BAYVIEW 37.76224899292 -122.403739929199 POINT (-122.40373993 37.76224899) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
1528676 1528676 2191160 2013-03-31T19:00:07 2013-06-21T07:45:28 2013-06-21T07:45:28 Closed 2 resolved: Field Work has been completed PUC Sewer Ops 27 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Integrated Agency   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
1539958 1539958 2551806 2013-06-30T22:12:32 2013-07-10T10:24:12 2013-07-10T10:24:12 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of 18TH ST and POTRERO AVE 18TH ST 10 Mission MISSION 37.761936187744006 -122.407188415527 POINT (-122.40718842 37.76193619) Phone   53 3 9 20 8 8 7 28,859 4 19 19   53   9     3   15   2   3     53
1540970 1540970 2655469 2013-07-29T19:40:11 2013-08-02T08:02:09 2013-08-02T08:02:09 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 301 POTRERO AVE, SAN FRANCISCO, CA, 94103 POTRERO AVE 10 Potrero Hill MISSION 37.765628814696996 -122.407325744629 POINT (-122.40732574 37.76562881) Web   54 3 9 20 8 8 7 28,853 4 19 19   54   9     2   15   2   2     54
1569661 1569661 2299799 2013-04-28T22:53:46 2013-06-19T09:18:50 2013-06-19T09:18:50 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 467 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763633728027 -122.407119750977 POINT (-122.40711975 37.76363373) Phone   54 3 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54

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