calls

41 rows where Responsible_Agency = 10

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
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
189382 189382 9127999 2018-06-12T14:57:00 2018-08-31T09:55:27 2018-08-31T09:55:27 Closed 2 Case Resolved Close Note: Soil added RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other Esprit Park, , SAN FRANCISCO, CA, 94107 Esprit Park 10 Dogpatch BAYVIEW 37.7609966 -122.39096359999999 POINT (-122.3909636 37.7609966) Web http://mobile311.sfgov.org/reports/9127999/photos 55 2 9 26 8 10 3 28,856 3 29 29 20 55   9 22     22 14   1         55
239036 239036 9358320 2018-08-04T09:49:00 2018-09-11T12:00:17 2018-09-11T12:00:17 Closed 2 Case Resolved Close Note: The Monterrey Cypress branch is growing in an unusual way. It is not a broken, hanging branch. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 715 SCOTT ST, SAN FRANCISCO, CA, 94117 SCOTT ST 5 Alamo Square NORTHERN 37.776685855429996 -122.43622376161301 POINT (-122.43622376 37.77668586) Mobile/Open311 http://mobile311.sfgov.org/reports/9358320/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
250511 250511 9232026 2018-07-06T10:49:00 2018-08-31T08:20:34 2018-08-31T08:20:34 Closed 2 Case Resolved Close Note: A planting plan for this area has been established. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Other 1111 BUCHANAN ST, SAN FRANCISCO, CA, 94115 BUCHANAN ST 5 Western Addition NORTHERN 37.780829491129 -122.428824892382 POINT (-122.42882489 37.78082949) Mobile/Open311 http://mobile311.sfgov.org/reports/9232026/photos 97 4 11 39 11 7 6 29,490 9 41 41   97   11             2     32 7 97
616860 616860 10496878 2019-02-16T11:03:00 2019-03-11T09:25:51 2019-03-11T09:25:51 Closed 2 Case Resolved Close Note: Tree has been staked RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1080 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 5 Cathedral Hill NORTHERN 37.782036820462 -122.42497256968399 POINT (-122.42497257 37.78203682) Mobile/Open311 http://mobile311.sfgov.org/reports/10496878/photos 100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
631518 631518 10472482 2019-02-10T17:33:00 2019-04-17T19:18:57 2019-04-17T19:18:57 Closed 2 Case Resolved Close Note: Hanger has been removed RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1199 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.776933969211 -122.436197068207 POINT (-122.43619707 37.77693397) Mobile/Open311 http://mobile311.sfgov.org/reports/10472482/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
680780 680780 287886 2008-09-26T08:37:08 2009-02-09T21:17:22 2009-02-09T21:17:22 Closed 2 The sprinkler has been taken care of. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of COLUMBUS AVE and UNION ST COLUMBUS AVE 3 North Beach CENTRAL 37.800315856934 -122.410209655762 POINT (-122.41020966 37.80031586) Phone   106 6 3 6 10 3 1 308 1 4 4 21 106   3 23     23     2         106
690173 690173 245139 2008-07-09T19:37:55 2008-07-15T10:04:14 2008-07-15T10:04:14 Closed 2 Long-term issue This is an ongoing issue that will require considerable effort and multi-divisional coordination to repair properly. For the time being, the leak is only occurring when the line is charged. The gardener has been very diligent in shutting off the valve at all times when not absolutely needed to minimize water waste. I anticipate this issue being unresolved for a quite some time as we coordinate a proper solution. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Washington Square, SAN FRANCISCO, CA, 94133 Washington Square 3 North Beach CENTRAL 37.800838470459 -122.41002655029301 POINT (-122.41002655 37.80083847) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
723938 723938 276620 2008-09-05T14:10:53 2009-02-09T21:13:37 2009-02-09T21:13:37 Closed 2 The lawn mower has been taken care of. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other 3601 LYON ST, SAN FRANCISCO, CA, 94123 LYON ST 2 Marina NORTHERN 37.80297088623 -122.448310852051 POINT (-122.44831085 37.80297089) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1     15   17
766761 766761 303548 2008-10-25T16:42:55 2008-10-31T14:48:35 2008-10-31T14:48:35 Closed 2   RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other Telegraph Hill/Pioneer Park, SAN FRANCISCO, CA, 94133 Telegraph Hill/Pioneer Park 3 Telegraph Hill CENTRAL 37.802783966064 -122.40583801269501 POINT (-122.40583801 37.80278397) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
1875814 1875814 3883060 2014-08-02T19:41:08 2014-08-03T12:04:03 2014-08-03T12:04:03 Closed 2 PSA manager is aware of this issue and repairs are in the works. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of VALENCIA ST and DUBOCE AVE VALENCIA ST 9 Mission Dolores MISSION 37.769865492482 -122.422367338622 POINT (-122.42236734 37.76986549) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1950050 1950050 4015249 2014-09-15T15:43:31 2016-05-18T10:14:13 2016-05-18T10:14:13 Closed 2 Tree inspection and appropriate remedial work were completed at the time of request. Due to error, case was not closed at that time. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of HYDE ST and ELLIS ST HYDE ST 6 Tenderloin TENDERLOIN 37.784446970716 -122.416071754662 POINT (-122.41607175 37.78444697) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
1986651 1986651 4312302 2014-12-17T15:33:24 2015-02-03T15:07:33 2015-02-03T15:07:33 Closed 2 Customer was called back to try to obtain more information but no voicemail was set up. Trees have been inspected and the location of the concern is not evident. If the customer wishes to follow up with a more specific location, please feel free to contact the Site Supervisor at 415-254-8030. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of COLUMBIA SQUARE ST and HARRISON ST COLUMBIA SQUARE ST 6 South of Market SOUTHERN 37.776618094545995 -122.40489575212099 POINT (-122.40489575 37.77661809) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32   10 6     6     2         32
2048448 2048448 4182874 2014-11-06T11:46:55 2015-04-14T17:33:09 2015-04-14T17:33:09 Closed 2 Per PSA Manager, Hazard has been removed. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Alamo Square, , SAN FRANCISCO, CA, 94117 Alamo Square 5 Alamo Square NORTHERN 37.776510505972 -122.434971928711 POINT (-122.43497193 37.77651051) Mobile/Open311 http://mobile311.sfgov.org/reports/4182874/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
2106066 2106066 4535263 2015-03-01T13:19:13 2015-03-20T14:18:07 2015-03-20T14:18:07 Closed 2 Per Manager, The fountain has been disabled pending repair. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of VALENCIA ST and DUBOCE AVE VALENCIA ST 9 Mission Dolores MISSION 37.769865492482 -122.422367338622 POINT (-122.42236734 37.76986549) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
2186664 2186664 4469416 2015-02-07T11:13:57 2015-02-12T10:58:15 2015-02-12T10:58:15 Closed 2 Per PSA Manager, Tree limbs have been removed. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FOLSOM ST and COLUMBIA SQUARE ST FOLSOM ST 6 South of Market SOUTHERN 37.777856766715004 -122.406436431431 POINT (-122.40643643 37.77785677) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
2384495 2384495 5446557 2016-01-08T15:11:17 2016-01-09T11:04:14 2016-01-09T11:04:14 Closed 2 Response from park manager: This site will be undergoing extensive renovation starting late 2016. Due to extensive construction and likely impacts during renovation, replacement street trees will be included in park renovation. No action is possible at this time. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Other Jefferson Square, , SAN FRANCISCO, CA, 94102 Jefferson Square 6 Cathedral Hill NORTHERN 37.781353333333 -122.425421666667 POINT (-122.42542167 37.78135333) Mobile/Open311 http://mobile311.sfgov.org/reports/5446557/photos 100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
2402468 2402468 5282247 2015-11-13T14:22:02 2016-05-12T04:21:45 2016-05-12T04:21:45 Closed 2 Per PSA manager: The trees have been recently pruned and watering completed. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Utah and 18th Mini Park, , SAN FRANCISCO, CA, 94110 Utah and 18th Mini Park 10 Potrero Hill BAYVIEW 37.762385699933 -122.406119993071 POINT (-122.40611999 37.7623857) Mobile/Open311 http://mobile311.sfgov.org/reports/5282247/photos 54 2 9 20 8 8 7 28,859 4 19 19   54   9         15   2         54
2565593 2565593 5983525 2016-06-15T15:07:38 2016-09-17T04:22:26 2016-09-17T04:22:26 Closed 2 # 5983525. The tree has been inspected and is on our watch list. We will continue to monitor it and take action should any changes in condition occur. Please close. Thank you RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other 1749 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.782194825945 -122.43496015980699 POINT (-122.43496016 37.78219483) Mobile/Open311   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
2653051 2653051 6156594 2016-08-04T09:55:28 2016-09-17T04:28:23 2016-09-17T04:28:23 Closed 2 # 6156594. Trees have been pruned. Please close. Thank you RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Golden Gate and Steiner Mini Park, , SAN FRANCISCO, CA, 94115 Golden Gate and Steiner Mini Park 5 Western Addition NORTHERN 37.779548862053 -122.433669548596 POINT (-122.43366955 37.77954886) Mobile/Open311   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
2657720 2657720 6427093 2016-10-16T20:29:35 2016-10-25T23:26:35 2016-10-25T23:26:35 Closed 2 Per PSA manager, Fallen tree has been removed from the wires RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Franklin Square, , SAN FRANCISCO, CA, 94110 Franklin Square 6 Mission MISSION 37.765605862868 -122.410488829428 POINT (-122.41048883 37.76560586) Phone   53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
2686162 2686162 6198244 2016-08-15T15:25:44 2017-05-09T13:27:14 2017-05-09T13:27:14 Closed 2 Tree inspection and appropriate remedial work were completed at the time of request. Due to error, case was not closed at that time. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 302 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784108659288 -122.412765082086 POINT (-122.41276508 37.78410866) Mobile/Open311   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
2689245 2689245 6308487 2016-09-13T21:13:03 2016-09-15T15:12:18 2016-09-15T15:12:18 Closed 2 RPD PSA manager of Jackson Playground has requested to close this service request. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 185 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill SOUTHERN 37.76407177934 -122.398573475577 POINT (-122.39857348 37.76407178) Mobile/Open311   54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
2703147 2703147 6158947 2016-08-04T16:23:38 2016-08-06T02:42:49 2016-08-06T02:42:49 Closed 2 Service Request # 124576 has a status of Created as of Aug 5 2016 4:46PM . The action requested is as follows: 311# 6158947 The row of flowering plum street trees are severely damaged with numerous trunk scars and die back. Please prune/remove to correct. Please close. Thank you RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of RIVOLI ST and STANYAN ST RIVOLI ST 5 Parnassus Heights PARK 37.762166171275 -122.45209791489201 POINT (-122.45209791 37.76216617) Phone http://mobile311.sfgov.org/reports/6158947/photos 110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
2712015 2712015 6231921 2016-08-24T09:59:00 2016-09-15T15:55:52 2016-09-15T15:55:52 Closed 2 The dead tree has been removed. The department is working with the community to replant a new tree. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of HAYES ST and OCTAVIA ST HAYES ST 5 Hayes Valley NORTHERN 37.776605633329 -122.42462170321699 POINT (-122.4246217 37.77660563) Mobile/Open311 http://mobile311.sfgov.org/reports/6231921/photos 22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
2717759 2717759 6417673 2016-10-13T15:36:38 2017-01-07T14:18:11 2017-01-07T14:18:11 Closed 2 Per PSA manager: Request for tree pruning has been made.  The work will be conducted at the earliest opportunity.  Please refer to request #129727 for future inquiries RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 831 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 5 Western Addition NORTHERN 37.780527826434 -122.424202608059 POINT (-122.42420261 37.78052783) Mobile/Open311   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
2900185 2900185 7008899 2017-04-04T12:22:11 2018-08-24T06:52:26 2018-08-24T06:52:26 Closed 2 Case Resolved Close Note: Tree wells have been weeded and cleaned RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other Grattan Playground, 1180 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Ashbury Heights PARK 37.762748628196 -122.451584458374 POINT (-122.45158446 37.76274863) Mobile/Open311   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
2904315 2904315 7046114 2017-04-14T14:58:24 2017-04-15T09:13:38 2017-04-15T09:13:38 Closed 2 Per PSA manager: Planning for a park renovation at this site is underway. Until plans are finalized, no tree planting is possible due to potential conflicts and construction impacts. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Other Fillmore and Turk Mini Park, , SAN FRANCISCO, CA, 94115 Fillmore and Turk Mini Park 5 Western Addition NORTHERN 37.780169241958 -122.431879367713 POINT (-122.43187937 37.78016924) Mobile/Open311 http://mobile311.sfgov.org/reports/7046114/photos 97 4 11 39 11 15 6 29,490 9 41 41   97   11   24         2     28   97
2909296 2909296 6883170 2017-02-27T11:01:00 2018-08-29T09:37:34 2018-08-29T09:37:34 Closed 2 Case Resolved Close Note: Noted RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BUCHANAN ST and PAGE ST BUCHANAN ST 5 Lower Haight NORTHERN 37.773277144914 -122.427322184781 POINT (-122.42732218 37.77327714) Mobile/Open311 http://mobile311.sfgov.org/reports/6883170/photos 26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
2932923 2932923 6820562 2017-02-08T13:26:12 2017-02-22T15:40:20 2017-02-22T15:40:20 Closed 2 Tree has been pruned to remove damaged areas and is being monitored for further decline. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Victoria Manalo Draves Park, , SAN FRANCISCO, CA, 94103 Victoria Manalo Draves Park 6 South of Market SOUTHERN 37.777856766715004 -122.406436431431 POINT (-122.40643643 37.77785677) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
3001963 3001963 7229050 2017-06-06T09:08:45 2017-07-06T00:48:00 2017-07-06T00:48:00 Closed 2 Per PSA manager:A request for Urban Forestry evaluation has been made RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Buchanan Street Mall, , SAN FRANCISCO, CA, 94115 Buchanan Street Mall 5 Western Addition NORTHERN 37.779759000000006 -122.428671 POINT (-122.428671 37.779759) Mobile/Open311 http://mobile311.sfgov.org/reports/7229050/photos 97 4 11 39 11 7 6 29,490 9 41 41   97   11             2       7 97
3080207 3080207 7200345 2017-05-29T16:08:46 2018-08-28T09:31:17 2018-08-28T09:31:17 Closed 2 Case Resolved Close Note: Work order complete uf-3630 RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Alamo Square, , SAN FRANCISCO, CA, 94117 Alamo Square 5 Alamo Square NORTHERN 37.775911 -122.43509099999999 POINT (-122.435091 37.775911) Mobile/Open311 http://mobile311.sfgov.org/reports/7200345/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
3140559 3140559 8011744 2017-09-12T18:38:00 2018-08-24T06:54:13 2018-08-24T06:54:13 Closed 2 Case Resolved Close Note: Trees have been pruned RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism McKinley Square, , SAN FRANCISCO, CA, 94107 McKinley Square 10 Potrero Hill BAYVIEW 37.758784798537 -122.40474161766899 POINT (-122.40474162 37.7587848) Mobile/Open311 http://mobile311.sfgov.org/reports/8011744/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
3156250 3156250 8290759 2017-11-20T10:52:00 2018-08-21T15:44:13 2018-08-21T15:44:13 Closed 2 Case Resolved Close Note: Nesting Orioles currently utilize these fronds. Will reconsider when they abandon the nest RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Potrero Hill Recreation Center, 801 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.755971 -122.397093 POINT (-122.397093 37.755971) Mobile/Open311 http://mobile311.sfgov.org/reports/8290759/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
3196072 3196072 8202134 2017-10-30T07:43:00 2018-08-28T05:53:43 2018-08-28T05:53:43 Closed 2 Case Resolved Close Note: Palms have been trimmed and bait boxes set out in park. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Sgt. John Macaulay Park, , SAN FRANCISCO, CA, 94109 Sgt. John Macaulay Park 6 Tenderloin TENDERLOIN 37.785422 -122.418277 POINT (-122.418277 37.785422) Mobile/Open311 http://mobile311.sfgov.org/reports/8202134/photos 20 5 10 36 9 13 6 28,858 9 36 36   20   10   15     10 1 2 1   41 11 20
3326642 3326642 8617991 2018-02-10T16:47:00 2018-08-28T07:54:57 2018-08-28T07:54:57 Closed 2 Case Resolved Close Note: Tree hanger has been removed RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of HAYES ST and PIERCE ST HAYES ST 5 Alamo Square NORTHERN 37.775912517316996 -122.434084672752 POINT (-122.43408467 37.77591252) Mobile/Open311 http://mobile311.sfgov.org/reports/8617991/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
3335676 3335676 8544079 2018-01-23T17:19:00 2018-08-27T12:55:36 2018-08-27T12:55:36 Closed 2 Case Resolved Close Note: Trees removed RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism McKinley Square, , SAN FRANCISCO, CA, 94107 McKinley Square 10 Potrero Hill BAYVIEW 37.759336 -122.404721 POINT (-122.404721 37.759336) Mobile/Open311 http://mobile311.sfgov.org/reports/8544079/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
3629137 3629137 10841434 2019-05-09T17:49:00 2019-06-17T10:17:41 2019-06-17T10:17:41 Closed 2 Case Resolved Close Note: Tree has been removed, stump will be removed this week. Replacement tree is being decided ASAP. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other 501 HAYES ST, SAN FRANCISCO, CA, 94102 HAYES ST 5 Hayes Valley NORTHERN 37.776433000000004 -122.42461000000002 POINT (-122.42461 37.776433) Mobile/Open311 http://mobile311.sfgov.org/reports/10841434/photos 22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
3693974 3693974 10802863 2019-05-01T11:21:00 2019-05-07T06:30:45 2019-05-07T06:30:45 Closed 2 Case Resolved Close Note: RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Tree_Other 4 Other SOMA Rec Center, SAN FRANCISCO, CA, 94103 6TH ST 6 South of Market SOUTHERN 37.778701 -122.40638799999999 POINT (-122.406388 37.778701) Mobile/Open311   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6 14 1 6     2   1     32
3710072 3710072 11321013 2019-08-25T12:34:00 2019-09-10T06:08:02 2019-09-10T06:08:02 Closed 2 Case Resolved Close Note: Limb has been cleared RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1650 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 5 Japantown NORTHERN 37.784905 -122.432869 POINT (-122.432869 37.784905) Mobile/Open311   101 4 11 15 11 13 6 29,490 9 13 13 8 101   11 9 24   9 11   2         101
3717333 3717333 11105865 2019-07-09T16:08:00 2019-07-24T13:51:36 2019-07-24T13:51:36 Closed 2 Unable to Locate. If the problem still exists, please submit a new request with more details regarding the location of the issue. Close Note: Unable to locate RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 300 BUCHANAN ST, SAN FRANCISCO, CA, 94102 BUCHANAN ST 5 Lower Haight NORTHERN 37.77254486084 -122.427108764648 POINT (-122.42710876 37.77254486) Phone   26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26

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