calls

7,158 rows where Responsible_Agency = 2 sorted by :@computed_region_jx4q_fizf

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
95201 95201 11509805 2019-10-05T15:15:00   2019-10-31T12:55:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1230 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 Fisherman's Wharf CENTRAL 37.805592 -122.417658 POINT (-122.417658 37.805592) Mobile/Open311 http://mobile311.sfgov.org/reports/11509805/photos 99 6 3 23 10 5 1 308 1 23 23   99   3         2   2         99
97990 97990 9663767 2018-10-12T13:30:00 2019-01-07T12:01:05 2019-01-07T12:01:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 45 BROADWAY, SAN FRANCISCO, CA, 94111 BROADWAY 3 Northern Waterfront CENTRAL 37.798992492588 -122.398538086449 POINT (-122.39853809 37.79899249) Mobile/Open311 http://mobile311.sfgov.org/reports/9663767/photos 77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
111309 111309 7333603 2017-07-04T16:48:46 2017-07-05T04:00:00 2017-07-05T04:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BROADWAY and HYDE ST BROADWAY 3 Nob Hill CENTRAL 37.796274816719 -122.418457437787 POINT (-122.41845744 37.79627482) Phone   16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
115479 115479 6890390 2017-03-01T01:17:50 2017-03-07T14:15:18 2017-03-07T14:15:18 Closed 2 Crookedest street has broken sprinkler head. Damian will be fixing it. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1065 LOMBARD ST, SAN FRANCISCO, CA, 94109 LOMBARD ST 2 Russian Hill CENTRAL 37.801947001141 -122.418974430424 POINT (-122.41897443 37.801947) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
129200 129200 5618549 2016-03-01T12:31:10   2016-03-02T03:48:37 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of JACKSON ST and KEARNY ST JACKSON ST 3 Chinatown CENTRAL 37.796305 -122.40502099999999 POINT (-122.405021 37.796305) Mobile/Open311 http://mobile311.sfgov.org/reports/5618549/photos 106 6 3 6 10 3 1 308 1 4 4 5 106   3 5 17   5     2         106
136095 136095 9622160 2018-10-03T13:16:00   2019-03-13T09:50:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 505 SANSOME ST, SAN FRANCISCO, CA, 94111 SANSOME ST 3 Financial District CENTRAL 37.795097351074 -122.401679992676 POINT (-122.40167999 37.79509735) Phone   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
136891 136891 5015589 2015-08-19T21:21:14 2015-12-18T12:17:55 2015-12-18T12:17:55 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 698 BUSH ST, SAN FRANCISCO, CA, 94108 BUSH ST 3 Nob Hill CENTRAL 37.790293425468 -122.408555640716 POINT (-122.40855564 37.79029343) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
138908 138908 4834319 2015-06-17T11:02:47 2015-06-30T02:25:00 2015-06-30T02:25:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 2643 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 2 Aquatic Park / Ft. Mason CENTRAL 37.805336022023 -122.420533417855 POINT (-122.42053342 37.80533602) Phone   98 6 6 32 1 5 1 28,858 1 32 32   98   6             1         98
140074 140074 4743541 2015-05-13T19:52:53 2015-07-12T08:06:00 2015-07-12T08:06:00 Closed 2 resolved: Maiden Ln is not under the care and maintenance of public works. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 140 GRANT AVE, SAN FRANCISCO, CA, 94108 GRANT AVE 3 Downtown / Union Square CENTRAL 37.788351494854005 -122.404981982077 POINT (-122.40498198 37.78835149) Mobile/Open311 http://mobile311.sfgov.org/reports/4743541/photos 19 6 3 8 10 5 1 28,857 1 6 6 10 19   3 12     12 5   2         19
140781 140781 4677841 2015-04-19T15:31:54 2015-04-28T09:30:00 2015-04-28T09:30:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 426 LOMBARD ST, SAN FRANCISCO, CA, 94133 LOMBARD ST 3 North Beach CENTRAL 37.803509700182 -122.40866689284701 POINT (-122.40866689 37.8035097) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3       23     1         106
141295 141295 4631109 2015-04-02T13:55:56 2015-05-15T07:50:09 2015-05-15T07:50:09 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 615 UNION ST, SAN FRANCISCO, CA, 94133 UNION ST 3 North Beach CENTRAL 37.800277709961 -122.40948486328101 POINT (-122.40948486 37.80027771) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
142732 142732 9567047 2018-09-20T12:34:00 2019-01-08T06:55:00 2019-01-08T06:55:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Request_water_meter 700 BROADWAY, SAN FRANCISCO, CA, 94133 BROADWAY 3 North Beach CENTRAL 37.79772567749 -122.40885925293001 POINT (-122.40885925 37.79772568) Phone   106 6 3 6 10 3 1 308 1 4 4   106   3   17         2         106
144940 144940 4345194 2014-12-30T08:22:45 2015-01-09T08:20:27 2015-01-09T08:20:27 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 430 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.799051432179 -122.40816110406999 POINT (-122.4081611 37.79905143) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
148450 148450 9176232 2018-06-23T16:14:00 2018-08-08T08:12:00 2018-08-08T08:12:00 Closed 2 replace the valve DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MONTGOMERY ST and UNION ST MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.801036834717 -122.40442657470699 POINT (-122.40442657 37.80103683) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
158701 158701 9212172 2018-07-01T19:26:00 2018-08-09T08:29:00 2018-08-09T08:29:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BROADWAY and HYDE ST BROADWAY 3 Nob Hill CENTRAL 37.796276092529 -122.41845703125 POINT (-122.41845703 37.79627609) Phone   16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
174409 174409 9165994 2018-06-21T09:59:00 2018-07-05T11:26:58 2018-07-05T11:26:58 Closed 2 where specifically? reported branch to Robert Stafford and Drew. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of GREENWICH ST and HYDE ST GREENWICH ST 2 Russian Hill CENTRAL 37.801105 -122.419416 POINT (-122.419416 37.801105) Mobile/Open311 http://mobile311.sfgov.org/reports/9165994/photos 107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
180783 180783 9283808 2018-07-18T12:27:00 2018-07-30T10:00:15 2018-07-30T10:00:15 Closed 2 sent to landscape DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1299 BROADWAY, SAN FRANCISCO, CA, 94109 BROADWAY 3 Nob Hill CENTRAL 37.796208333333 -122.41850333333299 POINT (-122.41850333 37.79620833) Mobile/Open311 http://mobile311.sfgov.org/reports/9283808/photos 16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
219812 219812 9275297 2018-07-16T16:42:00 2018-07-18T11:48:00 2018-07-18T11:48:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1331 WASHINGTON ST, SAN FRANCISCO, CA, 94109 WASHINGTON ST 3 Nob Hill CENTRAL 37.793918609619006 -122.41530609130899 POINT (-122.41530609 37.79391861) Phone   16 6 3 21 10 5 1 28,858 1 21 21   16   3             1         16
257980 257980 9286898 2018-07-19T08:19:00 2019-05-17T09:50:41 2019-05-17T09:50:41 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of KEARNY ST and VALLEJO ST KEARNY ST 3 North Beach CENTRAL 37.798969268799 -122.40564727783199 POINT (-122.40564728 37.79896927) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23     23     2         106
363074 363074 9520736 2018-09-10T12:45:00 2019-05-17T09:45:10 2019-05-17T09:45:10 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1955 LEAVENWORTH ST, SAN FRANCISCO, CA, 94133 LEAVENWORTH ST 3 Russian Hill CENTRAL 37.799238748884 -122.417538995037 POINT (-122.417539 37.79923875) Mobile/Open311 http://mobile311.sfgov.org/reports/9520736/photos 107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
379577 379577 9695603 2018-10-19T16:16:00 2018-12-07T10:34:00 2018-12-07T10:34:00 Closed 2 Your service order has been accepted, closed out as - Inspected - No work needed. Thank you DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 434 UNION ST, SAN FRANCISCO, CA, 94133 UNION ST 3 Telegraph Hill CENTRAL 37.800899505615 -122.40662384033199 POINT (-122.40662384 37.80089951) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     2         18
429682 429682 9869133 2018-11-29T15:17:00 2018-12-08T07:11:00 2018-12-08T07:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2425 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 2 Russian Hill CENTRAL 37.803356910376 -122.42005167301599 POINT (-122.42005167 37.80335691) Web http://mobile311.sfgov.org/reports/9869133/photos 107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
436278 436278 10303451 2019-01-02T07:09:00 2019-04-04T09:11:00 2019-04-04T09:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 501 POWELL ST, SAN FRANCISCO, CA, 94108 POWELL ST 3 Downtown / Union Square CENTRAL 37.789328669852 -122.408659795454 POINT (-122.4086598 37.78932867) Mobile/Open311   19 6 3 21 10 5 1 28,857 1 21 21 10 19   3 12     12 5   2         19
464022 464022 10391565 2019-01-22T15:52:00   2019-04-24T10:15:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 828 JONES ST, SAN FRANCISCO, CA, 94109 JONES ST 3 Lower Nob Hill CENTRAL 37.7890304 -122.41314550000001 POINT (-122.4131455 37.7890304) Web http://mobile311.sfgov.org/reports/10391565/photos 50 6 3 21 10 5 1 28,858 1 21 21   50   3             2         50
478871 478871 10368490 2019-01-17T09:20:00   2019-01-26T08:15:02 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1631 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Nob Hill CENTRAL 37.795862407097005 -122.418435601392 POINT (-122.4184356 37.79586241) Mobile/Open311 http://mobile311.sfgov.org/reports/10368490/photos 16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
488907 488907 10388112 2019-01-22T09:00:00 2019-04-04T09:08:00 2019-04-04T09:08:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of HOOKER ALY and MASON ST HOOKER ALY 3 Lower Nob Hill CENTRAL 37.790409999999994 -122.41048300000001 POINT (-122.410483 37.79041) Mobile/Open311 http://mobile311.sfgov.org/reports/10388112/photos 16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
499740 499740 10397224 2019-01-23T16:49:00 2019-02-22T11:20:05 2019-02-22T11:20:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 138 TRENTON ST, SAN FRANCISCO, CA, 94133 TRENTON ST 3 Chinatown CENTRAL 37.796351 -122.40912250000001 POINT (-122.4091225 37.796351) Web http://mobile311.sfgov.org/reports/10397224/photos 104 6 3 6 10 3 1 308 1 4 4   104   3             2         104
509977 509977 9908863 2018-12-08T15:20:00 2019-01-05T07:28:00 2019-01-05T07:28:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of GREEN ST and TAYLOR ST GREEN ST 3 Russian Hill CENTRAL 37.7990082 -122.4138837 POINT (-122.4138837 37.7990082) Web   107 6 3 32 10 3 1 308 1 32 32   107   3             1         107
512004 512004 9827128 2018-11-19T12:03:00   2018-11-19T14:20:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 831 BROADWAY, SAN FRANCISCO, CA, 94133 BROADWAY 3 Russian Hill CENTRAL 37.797119140625 -122.41073608398399 POINT (-122.41073608 37.79711914) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3             2         107
516248 516248 10348070 2019-01-12T10:28:00 2019-04-26T10:13:58 2019-04-26T10:13:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2599 TAYLOR ST, SAN FRANCISCO, CA, 94133 TAYLOR ST 3 Fisherman's Wharf CENTRAL 37.8061423 -122.4156814 POINT (-122.4156814 37.8061423) Web http://mobile311.sfgov.org/reports/10348070/photos 99 6 3 23 10 5 1 308 1 23 23   99   3         2   2         99
525842 525842 10370698 2019-01-17T14:20:00 2019-01-25T08:13:00 2019-01-25T08:13:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 810 GREEN ST, SAN FRANCISCO, CA, 94133 GREEN ST 3 Russian Hill CENTRAL 37.799075133648 -122.41249527026001 POINT (-122.41249527 37.79907513) Mobile/Open311 http://mobile311.sfgov.org/reports/10370698/photos 107 6 3 32 10 3 1 308 1 32 32   107   3             1         107
534265 534265 9951458 2018-12-18T15:14:00   2019-01-23T15:05:46 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of GRANT AVE and PFEIFFER ST GRANT AVE 3 North Beach CENTRAL 37.804836273193004 -122.40842437744101 POINT (-122.40842438 37.80483627) Phone   18 6 3 23 10 3 1 308 1 23 23   18   3             2         18
535283 535283 9806193 2018-11-14T08:10:00 2018-11-30T15:14:00 2018-11-30T15:14:00 Closed 2 Your service order has been accepted, closed out as - work previously done. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1050 LARKIN ST, SAN FRANCISCO, CA, 94109 LARKIN ST 3 Lower Nob Hill CENTRAL 37.787700653076 -122.418243408203 POINT (-122.41824341 37.78770065) Phone   50 6 3 21 10 13 1 28,858 1 21 21   50   3             2         50
536785 536785 10367239 2019-01-17T01:39:00 2019-01-29T07:43:46 2019-01-29T07:43:46 Closed 2 Should be routed to 311 Call Center Need to inspect for removal DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1212 KEARNY ST, SAN FRANCISCO, CA, 94133 KEARNY ST 3 Telegraph Hill CENTRAL 37.799283730380004 -122.405657119049 POINT (-122.40565712 37.79928373) Web http://mobile311.sfgov.org/reports/10367239/photos 18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
537314 537314 10934309 2019-05-31T11:23:00   2019-05-31T12:20:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of THE EMBARCADERO and BAY ST THE EMBARCADERO 3 Northern Waterfront CENTRAL 37.806617736816 -122.405563354492 POINT (-122.40556335 37.80661774) Phone   77 6 3 23 10 3 1 308 1 23 23   77   3             2         77
537806 537806 10388068 2019-01-22T08:55:00 2019-04-04T09:47:00 2019-04-04T09:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MASON ST and PINE ST MASON ST 3 Nob Hill CENTRAL 37.790882110596 -122.41062164306601 POINT (-122.41062164 37.79088211) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
558403 558403 9851351 2018-11-26T10:06:00   2019-03-26T10:34:36 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 1200 CALIFORNIA ST, SAN FRANCISCO, CA, 94109 CALIFORNIA ST 3 Nob Hill CENTRAL 37.791496276855 -122.414497375488 POINT (-122.41449738 37.79149628) Phone   16 6 3 21 10 5 1 28,858 1 21 21   16   3             1         16
567719 567719 10486250 2019-02-13T17:11:00 2019-02-26T11:47:26 2019-02-26T11:47:26 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of PACIFIC AVE and TRENTON ST PACIFIC AVE 3 Chinatown CENTRAL 37.796528333333 -122.409386666667 POINT (-122.40938667 37.79652833) Mobile/Open311 http://mobile311.sfgov.org/reports/10486250/photos 104 6 3 6 10 3 1 308 1 4 4   104   3             2         104
573824 573824 10490290 2019-02-14T15:22:00 2019-02-16T22:43:00 2019-02-16T22:43:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1106 BUSH ST, SAN FRANCISCO, CA, 94109 BUSH ST 3 Lower Nob Hill CENTRAL 37.78933 -122.415625 POINT (-122.415625 37.78933) Mobile/Open311 http://mobile311.sfgov.org/reports/10490290/photos 50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
577454 577454 10508051 2019-02-19T15:49:00 2019-02-26T11:45:50 2019-02-26T11:45:50 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of PACIFIC AVE and TRENTON ST PACIFIC AVE 3 Chinatown CENTRAL 37.796433 -122.409306 POINT (-122.409306 37.796433) Mobile/Open311 http://mobile311.sfgov.org/reports/10508051/photos 104 6 3 6 10 3 1 308 1 4 4   104   3             2         104
580194 580194 10740137 2019-04-17T08:39:00 2019-05-07T14:22:13 2019-05-07T14:22:13 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 640 FRANCISCO ST, SAN FRANCISCO, CA, 94133 FRANCISCO ST 3 North Beach CENTRAL 37.804882049561 -122.41590118408199 POINT (-122.41590118 37.80488205) Phone   106 6 3 23 10 5 1 308 1 23 23   106   3             2         106
590155 590155 10684253 2019-04-03T22:32:00   2019-04-30T08:30:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 467 BROADWAY, SAN FRANCISCO, CA, 94133 BROADWAY 3 North Beach CENTRAL 37.7978432 -122.40485520000001 POINT (-122.4048552 37.7978432) Mobile/Open311 http://mobile311.sfgov.org/reports/10684253/photos 106 6 3 23 10 3 1 308 1 23 23 21 106   3 23       1   2         106
592903 592903 10533790 2019-02-25T17:12:00 2019-06-08T13:45:00 2019-06-08T13:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 920 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 3 Lower Nob Hill CENTRAL 37.789532717726004 -122.41532072209101 POINT (-122.41532072 37.78953272) Mobile/Open311 http://mobile311.sfgov.org/reports/10533790/photos 50 6 3 21 10 5 1 28,858 1 21 21   50   3             1         50
621551 621551 10487869 2019-02-14T08:50:00 2019-02-14T22:15:18 2019-02-14T22:15:18 Closed 2 Request is a duplicate and has been previously reported as 10487869 DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 399 THE EMBARCADERO, SAN FRANCISCO, CA, 94111 THE EMBARCADERO 3 Northern Waterfront CENTRAL 37.798337872333 -122.397495846406 POINT (-122.39749585 37.79833787) Mobile/Open311 http://mobile311.sfgov.org/reports/10487869/photos 77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
637540 637540 10571154 2019-03-06T16:51:00 2019-03-13T13:32:38 2019-03-13T13:32:38 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2711 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 2 Aquatic Park / Ft. Mason CENTRAL 37.805909318885 -122.420539716373 POINT (-122.42053972 37.80590932) Mobile/Open311 http://mobile311.sfgov.org/reports/10571154/photos 98 6 6 32 1 5 1 28,858 1 32 32   98   6         2   1         98
639230 639230 10494600 2019-02-15T14:48:00 2019-03-08T00:00:43 2019-03-08T00:00:43 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 317 GREEN ST, SAN FRANCISCO, CA, 94133 GREEN ST 3 Telegraph Hill CENTRAL 37.799906299999996 -122.40458329999998 POINT (-122.4045833 37.7999063) Web   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
649253 649253 10486641 2019-02-13T19:52:00 2019-02-22T11:19:46 2019-02-22T11:19:46 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 138 TRENTON ST, SAN FRANCISCO, CA, 94133 TRENTON ST 3 Chinatown CENTRAL 37.796286 -122.409254 POINT (-122.409254 37.796286) Mobile/Open311 http://mobile311.sfgov.org/reports/10486641/photos 104 6 3 6 10 3 1 308 1 4 4   104   3             2         104
650651 650651 10505140 2019-02-19T08:42:00 2019-02-26T11:45:57 2019-02-26T11:45:57 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of TRENTON ST and JACKSON ST TRENTON ST 3 Chinatown CENTRAL 37.7957322 -122.409097 POINT (-122.409097 37.7957322) Web   104 6 3 6 10 3 1 308 1 4 4 5 104   3 5     5     2         104
1010359 1010359 759456 2010-10-25T17:01:48 2011-03-17T12:08:46 2011-03-17T12:08:46 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 755 BUSH ST, SAN FRANCISCO, CA, 94108 BUSH ST 3 Downtown / Union Square CENTRAL 37.789909362793004 -122.409736633301 POINT (-122.40973663 37.78990936) Web   19 6 3 21 10 5 1 28,857 1 21 21   19   3             2         19
1141806 1141806 894005 2011-06-04T08:13:23   2011-06-06T09:06:54 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CLAY ST and MASON ST CLAY ST 3 Nob Hill CENTRAL 37.793643951416 -122.411186218262 POINT (-122.41118622 37.79364395) Phone   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
1238818 1238818 1054638 2012-01-30T17:16:36   2012-01-31T09:23:13 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 300 BROADWAY, SAN FRANCISCO, CA, 94133 BROADWAY 3 North Beach CENTRAL 37.798515319824 -122.402557373047 POINT (-122.40255737 37.79851532) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3             2         106
1244355 1244355 1106027 2012-04-16T10:17:36   2012-04-16T13:39:29 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 843 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 North Beach CENTRAL 37.796951293945 -122.403770446777 POINT (-122.40377045 37.79695129) Phone   106 6 3 6 10 3 1 308 1 4 4   106   3             2         106
1252645 1252645 1004911 2011-11-15T14:39:32   2011-11-16T08:53:14 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BAY ST and THE EMBARCADERO BAY ST 3 Northern Waterfront CENTRAL 37.806617736816 -122.405563354492 POINT (-122.40556335 37.80661774) Phone   77 6 3 23 10 3 1 308 1 23 23   77   3             2         77
1296618 1296618 1054418 2012-01-30T14:01:56   2012-01-30T14:39:39 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1359 PINE ST, SAN FRANCISCO, CA, 94109 PINE ST 3 Lower Nob Hill CENTRAL 37.789775848389 -122.41834259033199 POINT (-122.41834259 37.78977585) Phone   50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
1360289 1360289 1042830 2012-01-12T23:03:55   2012-02-14T09:40:12 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 407 GREENWICH ST, SAN FRANCISCO, CA, 94133 GREENWICH ST 3 North Beach CENTRAL 37.802627563477 -122.40651702880899 POINT (-122.40651703 37.80262756) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
1607355 1607355 2270375 2013-04-21T14:24:34 2014-09-16T02:17:01 2014-09-16T02:17:01 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 940 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Russian Hill CENTRAL 37.801063537598 -122.41503143310499 POINT (-122.41503143 37.80106354) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
1659468 1659468 3082916 2013-11-19T19:06:31 2013-11-20T13:49:59 2013-11-20T13:49:59 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 600 GEARY ST, SAN FRANCISCO, CA, 94109 GEARY ST 3 Lower Nob Hill CENTRAL 37.786777496338 -122.413223266602 POINT (-122.41322327 37.7867775) Phone http://pic.twitter.com/tbgf7aYOC4 50 6 3 36 10 5 1 28,852 1 36 36   50   3             2         50
1734796 1734796 3354240 2014-02-10T11:27:24 2016-04-11T05:10:18 2016-04-11T05:10:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1060 PINE ST, SAN FRANCISCO, CA, 94108 PINE ST 3 Nob Hill CENTRAL 37.79065322876 -122.413291931152 POINT (-122.41329193 37.79065323) Web   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
1782684 1782684 3858862 2014-07-25T11:48:18 2015-02-14T10:42:11 2015-02-14T10:42:11 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1906 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Russian Hill CENTRAL 37.7984224176 -122.418824487082 POINT (-122.41882449 37.79842242) Phone   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
1823121 1823121 3808158 2014-07-08T10:37:06 2016-04-11T17:20:39 2016-04-11T17:20:39 Closed 2 Closed: No response from Rec & Park: Tree Issues in 1 month DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1557 CLAY ST, SAN FRANCISCO, CA, 94109 CLAY ST 3 Nob Hill CENTRAL 37.798401266163 -122.413587115751 POINT (-122.41358712 37.79840127) Mobile/Open311 http://mobile311.sfgov.org/reports/3808158/photos 107 6 3 21 10 3 1 308 1 21 21   107   3             1     22   107
1860782 1860782 3430989 2014-03-06T17:56:43   2014-03-07T20:25:50 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of STOCKTON ST and BUSH ST STOCKTON ST 3 Downtown / Union Square CENTRAL 37.790368660046 -122.40713148318999 POINT (-122.40713148 37.79036866) Phone   104 6 3 8 10 5 1 28,857 1 6 6   104   3         5   2         104
1919165 1919165 4355519 2015-01-02T13:43:10 2015-07-21T07:44:00 2015-07-21T07:44:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 2000 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 2 Russian Hill CENTRAL 37.799407522098 -122.418888025535 POINT (-122.41888803 37.79940752) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
1923987 1923987 4124664 2014-10-19T21:52:45 2014-10-22T05:55:10 2014-10-22T05:55:10 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of VALLEJO ST and COLUMBUS AVE VALLEJO ST 3 North Beach CENTRAL 37.798696273269 -122.407871572904 POINT (-122.40787157 37.79869627) Phone   106 6 3 6 10 3 1 308 1 4 4 21 106   3 23     23     2         106
1928793 1928793 4187103 2014-11-07T14:09:56 2014-11-15T01:47:24 2014-11-15T01:47:24 Closed 2 resolved: Area has been cleaned and has been installed with tree gator bags to facilitate watering. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LOMBARD ST and JONES ST LOMBARD ST 3 Russian Hill CENTRAL 37.802410372928 -122.416324163461 POINT (-122.41632416 37.80241037) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
1930997 1930997 4014256 2014-09-15T12:53:42 2014-09-26T07:24:32 2014-09-26T07:24:32 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MASON ST and NORTH POINT ST MASON ST 3 Fisherman's Wharf CENTRAL 37.806621999022 -122.41372700011298 POINT (-122.413727 37.806622) Mobile/Open311   99 6 3 23 10 3 1 308 1 23 23   99   3         2   2         99
1931165 1931165 4014579 2014-09-15T13:53:08 2014-10-02T07:17:09 2014-10-02T07:17:09 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1109 GREENWICH ST, SAN FRANCISCO, CA, 94109 GREENWICH ST 2 Russian Hill CENTRAL 37.801194742361005 -122.41793718915599 POINT (-122.41793719 37.80119474) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
1933418 1933418 4349414 2014-12-31T10:49:05 2015-01-09T07:41:11 2015-01-09T07:41:11 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of NORTH POINT ST and THE EMBARCADERO NORTH POINT ST 3 Fisherman's Wharf CENTRAL 37.807419013842 -122.407278660912 POINT (-122.40727866 37.80741901) Phone   99 6 3 23 10 3 1 308 1 23 23   99   3             2         99
1937796 1937796 4227708 2014-11-20T13:29:53 2014-11-26T06:42:22 2014-11-26T06:42:22 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 251 FRANCISCO ST, SAN FRANCISCO, CA, 94133 FRANCISCO ST 3 North Beach CENTRAL 37.805094562385 -122.409181941497 POINT (-122.40918194 37.80509456) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3             2         106
1939646 1939646 4269363 2014-12-04T09:43:10 2014-12-06T10:20:25 2014-12-06T10:20:25 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HYDE ST and UNION ST HYDE ST 3 Russian Hill CENTRAL 37.799196142335 -122.41904872929399 POINT (-122.41904873 37.79919614) Phone   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
1942151 1942151 4263859 2014-12-02T21:00:41 2014-12-05T12:19:10 2014-12-05T12:19:10 Closed 2 cancelled: Area is under the care and maintenance of Rec and Park. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 850 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.802501678467 -122.413284301758 POINT (-122.4132843 37.80250168) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3       23     1         106
1945289 1945289 4039277 2014-09-23T09:10:18 2015-02-14T10:43:40 2015-02-14T10:43:40 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1810 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Russian Hill CENTRAL 37.797458728901 -122.418626496466 POINT (-122.4186265 37.79745873) Phone   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
1950553 1950553 4266297 2014-12-03T12:30:57 2014-12-27T12:58:00 2014-12-27T12:58:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 423 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.798946380615 -122.408485412598 POINT (-122.40848541 37.79894638) Phone   106 6 3 6 10 3 1 308 1 4 4 21 106   3 23 20   23     2         106
1951240 1951240 4162440 2014-10-31T00:51:14 2014-11-01T09:53:45 2014-11-01T09:53:45 Closed 2 cancelled: Area is under inspection and being repaired as needed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of HYDE ST and LOMBARD ST HYDE ST 2 Russian Hill CENTRAL 37.801994242775 -122.419616109791 POINT (-122.41961611 37.80199424) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1     16   107
1951974 1951974 4119628 2014-10-17T16:30:54 2014-10-22T06:40:04 2014-10-22T06:40:04 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of TAYLOR ST and VALLEJO ST TAYLOR ST 3 Russian Hill CENTRAL 37.797955589505 -122.41374442611999 POINT (-122.41374443 37.79795559) Phone   107 6 3 21 10 5 1 308 1 21 21   107   3             1     22   107
1952319 1952319 4275359 2014-12-06T06:52:32 2015-03-22T12:20:23 2015-03-22T12:20:23 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 530 LOMBARD ST, SAN FRANCISCO, CA, 94133 LOMBARD ST 3 North Beach CENTRAL 37.803276062012 -122.410301208496 POINT (-122.41030121 37.80327606) Web   106 6 3 23 10 3 1 308 1 23 23   106   3       23     1         106
1955325 1955325 4347373 2014-12-30T16:39:48 2016-06-20T08:13:01 2016-06-20T08:13:01 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of POWELL ST and SUTTER ST POWELL ST 3 Downtown / Union Square CENTRAL 37.789226531982 -122.408592224121 POINT (-122.40859222 37.78922653) Web   19 6 3 8 10 5 1 28,857 1 6 6 10 19   3 12     12 5   2         19
1956851 1956851 4054483 2014-09-28T00:07:20 2014-09-30T02:09:38 2014-09-30T02:09:38 Closed 2 cancelled: Area is not under Public Works maintenance. Private. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1255 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 2 Fisherman's Wharf CENTRAL 37.805587161925004 -122.41792948774099 POINT (-122.41792949 37.80558716) Phone   99 6 6 32 1 5 1 308 1 32 32   99   6         2   1         99
1957260 1957260 4128961 2014-10-20T18:01:37 2015-02-14T10:34:00 2015-02-14T10:34:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1469 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Nob Hill CENTRAL 37.794411296181 -122.418357366773 POINT (-122.41835737 37.7944113) Phone   16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
1960461 1960461 4012378 2014-09-15T07:23:07 2014-09-15T02:40:00 2014-09-15T02:40:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1470 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.802749509027 -122.404736224676 POINT (-122.40473622 37.80274951) Mobile/Open311   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
1961279 1961279 4347421 2014-12-30T16:50:40 2015-01-08T03:06:00 2015-01-08T03:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SUTTER ST and POWELL ST SUTTER ST 3 Downtown / Union Square CENTRAL 37.789224204843 -122.40859738679701 POINT (-122.40859739 37.7892242) Phone   19 6 3 21 10 5 1 28,852 1 21 21 10 19   3 12     12 5   2         19
1962187 1962187 4016875 2014-09-16T08:41:09 2014-09-30T07:44:33 2014-09-30T07:44:33 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1360 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.801622584372 -122.40441908324101 POINT (-122.40441908 37.80162258) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
1962223 1962223 4355029 2015-01-02T11:46:54 2015-01-09T07:42:52 2015-01-09T07:42:52 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of COLUMBUS AVE and GREEN ST COLUMBUS AVE 3 North Beach CENTRAL 37.799488126751 -122.409013547361 POINT (-122.40901355 37.79948813) Twitter http://pic.twitter.com/29VLXb8Uxi 106 6 3 6 10 3 1 308 1 4 4 21 106   3 23     23     2         106
1965967 1965967 4346088 2014-12-30T11:36:08 2015-01-07T06:26:00 2015-01-07T06:26:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of POWELL ST and SUTTER ST POWELL ST 3 Downtown / Union Square CENTRAL 37.789224204843 -122.40859738679701 POINT (-122.40859739 37.7892242) Phone   19 6 3 21 10 5 1 28,852 1 21 21 10 19   3 12     12 5   2         19
1967837 1967837 4348626 2014-12-31T08:04:06 2015-01-17T08:45:49 2015-01-17T08:45:49 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 855 SACRAMENTO ST, SAN FRANCISCO, CA, 94108 SACRAMENTO ST 3 Chinatown CENTRAL 37.793183000145 -122.406867998743 POINT (-122.406868 37.793183) Phone   104 6 3 6 10 3 1 28,857 1 4 4 5 104   3 5 17   5     2         104
1968770 1968770 4347502 2014-12-30T17:09:16 2015-01-08T07:31:00 2015-01-08T07:31:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of HYDE ST and FILBERT ST HYDE ST 2 Russian Hill CENTRAL 37.800132597806 -122.419232178685 POINT (-122.41923218 37.8001326) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
1969201 1969201 4065685 2014-10-01T11:55:21 2015-02-02T01:08:00 2015-02-02T01:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1321 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.801315503481 -122.404646615412 POINT (-122.40464662 37.8013155) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
1973887 1973887 4014536 2014-09-15T13:42:53 2014-09-16T02:21:13 2014-09-16T02:21:13 Closed 2 cancelled: Area is privately maintained. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MONTGOMERY ST and FILBERT ST MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.801966426015 -122.404559455997 POINT (-122.40455946 37.80196643) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
1974048 1974048 4266510 2014-12-03T13:11:24 2014-12-04T07:02:56 2014-12-04T07:02:56 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of KEARNY ST and BROADWAY KEARNY ST 3 North Beach CENTRAL 37.798015594482 -122.405471801758 POINT (-122.4054718 37.79801559) Twitter http://pic.twitter.com/tF7DqLrAz1 106 6 3 23 10 3 1 308 1 23 23 21 106   3 23     23 1   2         106
1975957 1975957 4151790 2014-10-27T22:00:40 2014-10-29T07:55:34 2014-10-29T07:55:34 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 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
1979494 1979494 4302932 2014-12-15T07:45:31   2014-12-17T09:46:33 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 724 PINE ST, SAN FRANCISCO, CA, 94108 PINE ST 3 Nob Hill CENTRAL 37.791370391846 -122.407821655273 POINT (-122.40782166 37.79137039) Web   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
1980151 1980151 3924921 2014-08-17T18:19:16 2014-08-28T12:12:48 2014-08-28T12:12:48 Closed 2 resolved: Elevated and lighten weight of Ficus tree to reduce possibility of tree falling DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 801 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 North Beach CENTRAL 37.796407 -122.40388700000001 POINT (-122.403887 37.796407) Mobile/Open311   106 6 3 6 10 3 1 28,860 1 4 4 5 106   3 5           2         106
1980371 1980371 4197367 2014-11-11T07:37:05 2014-11-20T01:22:51 2014-11-20T01:22:51 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 1847 GRANT AVE, SAN FRANCISCO, CA, 94133 GRANT AVE 3 North Beach CENTRAL 37.804096728017996 -122.408377325929 POINT (-122.40837733 37.80409673) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3             1         106
1981777 1981777 4003130 2014-09-11T14:04:55 2014-09-18T09:33:40 2014-09-18T09:33:40 Closed 2 resolved: Reduce canopy by 4' to 6' ft. Do not raise lower branches !! Send a climber up the center of the tree. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 404 LOMBARD ST, SAN FRANCISCO, CA, 94133 LOMBARD ST 3 North Beach CENTRAL 37.803526731398 -122.408293434659 POINT (-122.40829343 37.80352673) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3       23     1         106
1985368 1985368 4014270 2014-09-15T12:58:15 2014-09-24T06:43:58 2014-09-24T06:43:58 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of NORTH POINT ST and POWELL ST NORTH POINT ST 3 Fisherman's Wharf CENTRAL 37.806961 -122.412102 POINT (-122.412102 37.806961) Mobile/Open311   99 6 3 23 10 3 1 308 1 23 23   99   3         2   2         99
1990806 1990806 3985001 2014-09-05T16:16:32 2014-10-22T06:15:47 2014-10-22T06:15:47 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 1960 JONES ST, SAN FRANCISCO, CA, 94109 JONES ST 3 Russian Hill CENTRAL 37.799334045365 -122.415635485654 POINT (-122.41563549 37.79933405) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
1991910 1991910 4356620 2015-01-02T18:43:37 2015-01-08T03:21:00 2015-01-08T03:21:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of BEACH ST and POWELL ST BEACH ST 3 Fisherman's Wharf CENTRAL 37.807688818533 -122.41233001098401 POINT (-122.41233001 37.80768882) Phone   99 6 3 23 10 3 1 308 1 23 23   99   3         2   2         99
1993510 1993510 4347582 2014-12-30T17:29:57 2015-01-09T07:42:02 2015-01-09T07:42:02 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 735 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 Russian Hill CENTRAL 37.801329440511 -122.41201042933999 POINT (-122.41201043 37.80132944) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3   20   23     2         107
1994058 1994058 4350145 2014-12-31T13:35:24 2015-01-17T08:44:00 2015-01-17T08:44:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1270 CALIFORNIA ST, SAN FRANCISCO, CA, 94109 CALIFORNIA ST 3 Nob Hill CENTRAL 37.791400909424 -122.415245056152 POINT (-122.41524506 37.79140091) Phone   16 6 3 21 10 5 1 28,858 1 21 21   16   3             1         16
1999763 1999763 4072219 2014-10-03T11:16:57 2015-01-28T09:54:00 2015-01-28T09:54:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 336 LOMBARD ST, SAN FRANCISCO, CA, 94133 LOMBARD ST 3 Telegraph Hill CENTRAL 37.803604436021 -122.407225672873 POINT (-122.40722567 37.80360444) Phone   18 6 3 23 10 3 1 308 1 23 23   18   3       23     1         18
2001469 2001469 4328702 2014-12-23T12:55:35 2014-12-24T07:15:00 2014-12-24T07:15:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 420 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.799076080321996 -122.40811920166 POINT (-122.4081192 37.79907608) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106

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