calls

7,158 rows where Responsible_Agency = 2 sorted by :@computed_region_jx4q_fizf 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
433534 433534 9919336 2018-12-11T09:44:00   2019-04-24T10:15:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 555 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784419 -122.41543300000001 POINT (-122.415433 37.784419) Mobile/Open311 http://mobile311.sfgov.org/reports/9919336/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
526299 526299 9788362 2018-11-09T13:06:00 2019-07-26T10:20:48 2019-07-26T10:20:48 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 121 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Tenderloin TENDERLOIN 37.781749725342 -122.41252136230499 POINT (-122.41252136 37.78174973) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
580237 580237 10598682 2019-03-13T17:28:00   2019-06-07T14:30:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LEAVENWORTH ST and MCALLISTER ST LEAVENWORTH ST 6 Civic Center TENDERLOIN 37.780925750732 -122.413673400879 POINT (-122.4136734 37.78092575) Phone http://mobile311.sfgov.org/reports/10598682/photos 21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
631426 631426 10488966 2019-02-14T11:41:00 2019-06-17T15:44:37 2019-06-17T15:44:37 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 350 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 6 Tenderloin TENDERLOIN 37.782802581787 -122.41487121581999 POINT (-122.41487122 37.78280258) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1244925 1244925 1135633 2012-05-31T12:30:29 2013-11-20T13:34:55 2013-11-20T13:34:55 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 391 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.784477233887 -122.41452789306601 POINT (-122.41452789 37.78447723) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
1512201 1512201 2327413 2013-05-05T13:16:32 2013-11-20T13:45:16 2013-11-20T13:45:16 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LEAVENWORTH ST and MCALLISTER ST LEAVENWORTH ST 6 Civic Center TENDERLOIN 37.780925750732 -122.413673400879 POINT (-122.4136734 37.78092575) Phone   21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
1673782 1673782 2785542 2013-09-03T17:37:36 2013-11-20T13:48:01 2013-11-20T13:48:01 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 238 EDDY ST, SAN FRANCISCO, CA, 94102 EDDY ST 6 Tenderloin TENDERLOIN 37.784168243408 -122.411636352539 POINT (-122.41163635 37.78416824) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1821533 1821533 3639697 2014-05-13T17:07:52   2014-05-14T09:04:21 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 30 GROVE ST, SAN FRANCISCO, CA, 94102 GROVE ST 6 Civic Center TENDERLOIN 37.779163360596 -122.415809631348 POINT (-122.41580963 37.77916336) Phone   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   8 1 2 1 1     21
1935441 1935441 4309962 2014-12-16T21:14:09 2014-12-29T07:48:40 2014-12-29T07:48:40 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ELLIS ST and HYDE ST ELLIS ST 6 Tenderloin TENDERLOIN 37.784533076955 -122.41592573013399 POINT (-122.41592573 37.78453308) Mobile/Open311 http://mobile311.sfgov.org/reports/4309962/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
1959981 1959981 3955888 2014-08-27T08:07:57 2014-08-27T01:46:13 2014-08-27T01:46:13 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 209 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Civic Center TENDERLOIN 37.78169631958 -122.414184570313 POINT (-122.41418457 37.78169632) Web   21 5 10 36 9 7 10 28,852 10 36 36 17 21 1 10 18   1 18 6 1 2 1 1     21
1967680 1967680 4291879 2014-12-11T06:36:19 2014-12-22T06:20:00 2014-12-22T06:20:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LEAVENWORTH ST and OFARRELL ST LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785583496094 -122.414619445801 POINT (-122.41461945 37.7855835) Integrated Agency   20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
2000136 2000136 4309948 2014-12-16T21:07:10 2015-01-09T01:09:00 2015-01-09T01:09:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 500 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784776277875 -122.414724435771 POINT (-122.41472444 37.78477628) Mobile/Open311 http://mobile311.sfgov.org/reports/4309948/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
2011982 2011982 4028625 2014-09-19T13:25:13 2014-09-19T01:58:24 2014-09-19T01:58:24 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 47 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 6 Civic Center TENDERLOIN 37.780312 -122.413048 POINT (-122.413048 37.780312) Mobile/Open311   21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3 14 1 3 6 1 2 1 1 39 31 21
2043793 2043793 3955868 2014-08-27T08:03:35 2014-08-29T02:17:16 2014-08-29T02:17:16 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 535 EDDY ST, SAN FRANCISCO, CA, 94109 EDDY ST 6 Tenderloin TENDERLOIN 37.783390045166 -122.416458129883 POINT (-122.41645813 37.78339005) Web   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
2045412 2045412 3955816 2014-08-27T07:51:50 2014-09-26T07:21:45 2014-09-26T07:21:45 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 251 HYDE ST, SAN FRANCISCO, CA, 94102 HYDE ST 6 Tenderloin TENDERLOIN 37.783218383789 -122.41595458984399 POINT (-122.41595459 37.78321838) Web   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
2050986 2050986 4309984 2014-12-16T21:27:38 2014-12-29T07:51:09 2014-12-29T07:51:09 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 644 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784374 -122.416855 POINT (-122.416855 37.784374) Mobile/Open311 http://mobile311.sfgov.org/reports/4309984/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
2150376 2150376 4566409 2015-03-11T14:29:09 2015-04-09T07:45:00 2015-04-09T07:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 760 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 3 Downtown / Union Square TENDERLOIN 37.786379752162 -122.40545765819799 POINT (-122.40545766 37.78637975) Phone   19 6 3 8 10 5 10 28,852 10 6 6 10 19   3 12     12 5   2         19
2167954 2167954 4387787 2015-01-12T17:51:42 2015-01-14T07:08:00 2015-01-14T07:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 570 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784619699104 -122.415584731569 POINT (-122.41558473 37.7846197) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1     29 20
2198436 2198436 4996393 2015-08-13T16:58:00 2015-10-03T03:02:00 2015-10-03T03:02:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 281 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 6 Tenderloin TENDERLOIN 37.784996032715 -122.410751342773 POINT (-122.41075134 37.78499603) Phone   20 5 10 36 9 14 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
2243773 2243773 4928097 2015-07-21T16:17:04 2015-07-23T06:11:00 2015-07-23T06:11:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 795 GEARY ST, SAN FRANCISCO, CA, 94109 GEARY ST 6 Tenderloin CENTRAL 37.786219661684 -122.41618325588199 POINT (-122.41618326 37.78621966) Phone   20 5 10 36 9 13 10 28,858 10 36 36   20   10           1 2 1       20
2284450 2284450 5070235 2015-09-05T20:09:37 2016-03-31T11:56:00 2016-03-31T11:56:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 570 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784619699104 -122.415584731569 POINT (-122.41558473 37.7846197) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1     29 20
2305943 2305943 5001950 2015-08-15T17:50:54 2015-08-31T09:03:23 2015-08-31T09:03:23 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LEAVENWORTH ST and OFARRELL ST LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785580312059004 -122.41461961623502 POINT (-122.41461962 37.78558031) Phone   20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
2316988 2316988 5070237 2015-09-05T20:13:52 2015-11-22T11:00:00 2015-11-22T11:00:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 519 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784441425653 -122.41489137105499 POINT (-122.41489137 37.78444143) Phone   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
2331083 2331083 5570554 2016-02-15T18:40:21 2016-02-25T08:48:00 2016-02-25T08:48:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 530 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784634471690005 -122.414908250905 POINT (-122.41490825 37.78463447) Mobile/Open311 http://mobile311.sfgov.org/reports/5570554/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
2341906 2341906 5340413 2015-12-03T09:11:39 2015-12-03T18:09:48 2015-12-03T18:09:48 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LEAVENWORTH ST and OFARRELL ST LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785580312059004 -122.41461961623502 POINT (-122.41461962 37.78558031) Phone   20 5 10 36 9 7 10 28,852 10 36 36   20   10         6 1 2 1       20
2347832 2347832 5340441 2015-12-03T09:15:48 2015-12-03T18:10:04 2015-12-03T18:10:04 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 500 LEAVENWORTH ST, SAN FRANCISCO, CA, 94109 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785815555461 -122.414511462364 POINT (-122.41451146 37.78581556) Phone   20 5 10 36 9 5 10 28,852 10 36 36   20   10           1 2 1       20
2356987 2356987 5510638 2016-01-27T19:46:33 2016-03-02T08:57:00 2016-03-02T08:57:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of ELLIS ST and HYDE ST ELLIS ST 6 Tenderloin TENDERLOIN 37.784446970716 -122.416071754662 POINT (-122.41607175 37.78444697) Twitter http://pic.twitter.com/NAWHHoelHF 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1       20
2369887 2369887 5382788 2015-12-17T08:32:05 2016-06-30T02:19:00 2016-06-30T02:19:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of MCALLISTER ST and HYDE ST MCALLISTER ST 6 Civic Center TENDERLOIN 37.78071975708 -122.415313720703 POINT (-122.41531372 37.78071976) Phone   21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
2563056 2563056 5717970 2016-03-31T13:47:29 2016-04-01T08:20:00 2016-04-01T08:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 340 MASON ST, SAN FRANCISCO, CA, 94102 MASON ST 3 Downtown / Union Square TENDERLOIN 37.786973414737 -122.409681744195 POINT (-122.40968174 37.78697341) Phone   19 5 3 36 10 5 10 28,852 10 36 36   19   3         5 1 2 1       19
3074936 3074936 7217261 2017-06-02T15:24:00 2018-04-03T07:04:00 2018-04-03T07:04:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2 FULTON ST, SAN FRANCISCO, CA, 94102 FULTON ST 0     37.7802357 -122.41454750000001 POINT (-122.4145475 37.7802357) Web http://mobile311.sfgov.org/reports/7217261/photos 21 5 10 36 9 7 10 28,852 10 36 36 3 21 1 10 3   1 3 6 1 2 1 1     21
3348622 3348622 8491539 2018-01-11T08:39:00 2018-01-26T14:36:00 2018-01-26T14:36:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 120 CYRIL MAGNIN ST, SAN FRANCISCO, CA, 94102 CYRIL MAGNIN ST 3 Downtown / Union Square TENDERLOIN 37.785851740618 -122.40860470243 POINT (-122.4086047 37.78585174) Mobile/Open311 http://mobile311.sfgov.org/reports/8491539/photos 19 5 3 36 10 14 10 28,852 10 36 36   19   3         5 1 2 1       19
3590753 3590753 10983002 2019-06-11T15:12:00 2019-06-17T15:43:58 2019-06-17T15:43:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 560 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784643609872 -122.41538199043501 POINT (-122.41538199 37.78464361) Mobile/Open311 http://mobile311.sfgov.org/reports/10983002/photos 20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18     18 6 1 2 1     29 20
3657189 3657189 10904443 2019-05-24T09:56:00 2019-07-27T13:40:00 2019-07-27T13:40:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 20 ELLIS ST, SAN FRANCISCO, CA, 94102 ELLIS ST 3 Downtown / Union Square CENTRAL 37.785709393246 -122.406399361903 POINT (-122.40639936 37.78570939) Mobile/Open311 http://mobile311.sfgov.org/reports/10904443/photos 19 6 3 8 10 14 10 28,852 10 6 6 10 19   3 12     12 5   2         19
322 322 5699261 2016-03-25T11:05:16 2016-04-12T02:41:00 2016-04-12T02:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3430 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.781599066561 -122.456177018353 POINT (-122.45617702 37.78159907) Phone   11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
5504 5504 11585373 2019-10-22T11:55:00   2019-10-22T15:08:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2603 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789539033009994 -122.435863326343 POINT (-122.43586333 37.78953903) Mobile/Open311 http://mobile311.sfgov.org/reports/11585373/photos 102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
13892 13892 11610663 2019-10-28T07:16:00 2019-10-28T10:01:57 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 9TH AVE and ANZA ST 9TH AVE 1 Inner Richmond RICHMOND 37.778945922852 -122.467353820801 POINT (-122.46735382 37.77894592) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
23031 23031 11627389 2019-10-31T14:02:00   2019-10-31T17:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ANZA ST and ROSSI AVE ANZA ST 1 Lone Mountain RICHMOND 37.779693603516 -122.456497192383 POINT (-122.45649719 37.7796936) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
23049 23049 11254502 2019-08-10T18:15:00 2019-09-18T14:46:00 2019-09-18T14:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BALBOA ST and 26TH AVE BALBOA ST 1 Outer Richmond RICHMOND 37.776252746581996 -122.48553466796899 POINT (-122.48553467 37.77625275) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
32582 32582 11610643 2019-10-28T07:11:00 2019-10-28T10:02:03 2019-10-29T15:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 901 BALBOA ST, SAN FRANCISCO, CA, 94118 BALBOA ST 1 Inner Richmond RICHMOND 37.776889801025 -122.468505859375 POINT (-122.46850586 37.7768898) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
34792 34792 11616238 2019-10-29T08:47:00 2019-10-29T09:30:34 2019-10-30T11:55:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3699 CLAY ST, SAN FRANCISCO, CA, 94118 CLAY ST 2 Presidio Heights RICHMOND 37.788216471423 -122.45355627644399 POINT (-122.45355628 37.78821647) Mobile/Open311 http://mobile311.sfgov.org/reports/11616238/photos 10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
37533 37533 11622753 2019-10-30T13:44:00   2019-10-30T15:45:16 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2900 BUSH ST, SAN FRANCISCO, CA, 94115 BUSH ST 2 Lower Pacific Heights RICHMOND 37.785705 -122.44516899999999 POINT (-122.445169 37.785705) Mobile/Open311 http://mobile311.sfgov.org/reports/11622753/photos 103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
59386 59386 11490810 2019-10-01T13:36:00   2019-10-04T09:15:13 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 30TH AVE and CALIFORNIA ST 30TH AVE 2 Seacliff RICHMOND 37.783641815186 -122.49036407470699 POINT (-122.49036407 37.78364182) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
72971 72971 11412622 2019-09-13T16:23:00 2019-10-03T10:20:00 2019-10-03T10:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1714 LAKE ST, SAN FRANCISCO, CA, 94121 LAKE ST 2 Lake Street RICHMOND 37.786193847656 -122.47801971435499 POINT (-122.47801971 37.78619385) Phone   2 8 6 33 1 11 9 55 6 33 33   2   6             1         2
81001 81001 11526485 2019-10-09T09:28:00 2019-10-10T14:13:00 2019-10-10T14:13:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ARGUELLO BLVD and ANZA ST ARGUELLO BLVD 1 Inner Richmond RICHMOND 37.779335021973 -122.45873260498001 POINT (-122.4587326 37.77933502) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
93414 93414 9736666 2018-10-29T13:28:00 2019-01-04T14:10:49 2019-01-04T14:10:49 Closed 2 not a hazard - Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank y DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 200 ARGUELLO BLVD, SAN FRANCISCO, CA, 94118 ARGUELLO BLVD 2 Presidio Heights RICHMOND 37.786479949951 -122.459037780762 POINT (-122.45903778 37.78647995) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
100366 100366 9208114 2018-06-30T14:37:00 2019-10-17T09:37:31 2019-10-17T09:37:31 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2332 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 2 Pacific Heights NORTHERN 37.791344 -122.440758 POINT (-122.440758 37.791344) Mobile/Open311   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
110140 110140 7479385 2017-08-09T07:09:06 2017-10-25T01:17:00 2017-10-25T01:17:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of ANZA ST and 45TH AVE ANZA ST 1 Sutro Heights RICHMOND 37.77718767951 -122.506021348209 POINT (-122.50602135 37.77718768) Phone   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
111989 111989 7251820 2017-06-12T13:40:47 2017-10-10T01:49:00 2017-10-10T01:49:00 Closed 2 Weeded D1 CCT DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
129597 129597 5579601 2016-02-18T10:58:44 2016-02-23T01:39:00 2016-02-23T01:39:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 250 23RD AVE, SAN FRANCISCO, CA, 94121 23RD AVE 1 Outer Richmond RICHMOND 37.782937864217 -122.48226388634501 POINT (-122.48226389 37.78293786) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
131895 131895 4913859 2015-07-16T12:15:53 2016-02-16T09:31:00 2016-02-16T09:31:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 2501 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 5 Lower Pacific Heights NORTHERN 37.787176622531 -122.437466958903 POINT (-122.43746696 37.78717662) Phone   103 4 11 30 11 13 9 29,490 6 27 27   103   11             1         103
134350 134350 5136732 2015-09-27T14:50:11 2015-10-03T03:06:00 2015-10-03T03:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 1909 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.778742628618005 -122.46869594745199 POINT (-122.46869595 37.77874263) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
134360 134360 5260227 2015-11-06T09:59:20 2015-12-03T12:54:00 2015-12-03T12:54:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of SUTTER ST and SCOTT ST SUTTER ST 5 Lower Pacific Heights NORTHERN 37.785458607651 -122.43820782448601 POINT (-122.43820782 37.78545861) Phone   103 4 11 15 11 15 9 29,490 6 13 13   103   11             2         103
134499 134499 5244301 2015-11-01T12:33:56 2015-12-05T06:16:00 2015-12-05T06:16:00 Closed 2 resolved: Inspected by Jose Santiago for triaging. It is in fact a young tree that needs restaking. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of GEARY BLVD and 17TH AVE GEARY BLVD 1 Inner Richmond RICHMOND 37.780474532114 -122.476169109631 POINT (-122.47616911 37.78047453) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
136169 136169 5090960 2015-09-12T14:09:02 2015-09-28T01:48:00 2015-09-28T01:48:00 Closed 2 resolved: JP DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 7TH AVE and ANZA ST 7TH AVE 1 Inner Richmond RICHMOND 37.779042490026 -122.465211844154 POINT (-122.46521184 37.77904249) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
139212 139212 4809824 2015-06-08T08:04:05 2015-07-12T08:12:00 2015-07-12T08:12:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 38TH AVE and FULTON ST 38TH AVE 1 Golden Gate Park RICHMOND 37.771934509277 -122.498115539551 POINT (-122.49811554 37.77193451) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
140269 140269 4720773 2015-05-05T12:18:43 2015-05-26T09:26:00 2015-05-26T09:26:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CORNWALL ST and 5TH AVE CORNWALL ST 1 Inner Richmond RICHMOND 37.784853607923004 -122.463482746425 POINT (-122.46348275 37.78485361) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
142408 142408 4538908 2015-03-02T14:37:21 2015-03-05T02:32:00 2015-03-05T02:32:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 4333 CABRILLO ST, SAN FRANCISCO, CA, 94121 CABRILLO ST 1 Outer Richmond RICHMOND 37.773335004109995 -122.505297833293 POINT (-122.50529783 37.773335) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
143461 143461 4467315 2015-02-06T16:20:19 2015-02-08T06:19:00 2015-02-08T06:19:00 Closed 2 resolved: removed limb DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 560 BALBOA ST, SAN FRANCISCO, CA, 94118 BALBOA ST 1 Inner Richmond RICHMOND 37.777409112283 -122.464819080822 POINT (-122.46481908 37.77740911) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
144987 144987 4332716 2014-12-24T17:49:21 2015-03-30T07:33:00 2015-03-30T07:33:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of DIVISADERO ST and SACRAMENTO ST DIVISADERO ST 2 Pacific Heights NORTHERN 37.788993835449 -122.440620422363 POINT (-122.44062042 37.78899384) Web   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
147890 147890 9275026 2018-07-16T15:48:00 2018-07-18T11:14:00 2018-07-18T11:14:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 9 EDWARD ST, SAN FRANCISCO, CA, 94118 EDWARD ST 1 Lone Mountain RICHMOND 37.778144836426 -122.457206726074 POINT (-122.45720673 37.77814484) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
171174 171174 9216552 2018-07-02T16:18:00 2018-07-23T13:02:50 2018-07-23T13:02:50 Closed 2 . trees will be pruned according to the block pruning cycle. thanks for your patience. if you cannot wait for the city to get to your zone, please contact us if you wish to hire a certified arborist yourself 415.554.6700. unfortunately the city does not reimburse DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 3199 CLAY ST, SAN FRANCISCO, CA, 94115 CLAY ST 2 Pacific Heights RICHMOND 37.789161682129 -122.44546508789101 POINT (-122.44546509 37.78916168) Phone   102 8 6 30 1 13 9 29,490 6 27 27   102   6             1         102
203556 203556 9349091 2018-08-02T08:36:00 2018-08-08T08:00:00 2018-08-08T08:00:00 Closed 2 Couldn't find a sprinkler system on the sidewalk DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of EUCLID AVE and LAUREL ST EUCLID AVE 2 Laurel Heights / Jordan Park RICHMOND 37.784687042236 -122.449272155762 POINT (-122.44927216 37.78468704) Phone   11 8 6 31 1 15 9 54 6 31 31   11   6             1         11
207271 207271 9229711 2018-07-05T18:48:00 2019-02-12T06:41:00 2019-02-12T06:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 6527 GEARY BLVD, SAN FRANCISCO, CA, 94121 GEARY BLVD 1 Outer Richmond RICHMOND 37.779865657544 -122.48951568688 POINT (-122.48951569 37.77986566) Mobile/Open311   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
208602 208602 9403311 2018-08-14T16:24:00 2018-08-21T11:22:00 2018-08-21T11:22:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 34TH AVE and CLEMENT ST 34TH AVE 1 Outer Richmond RICHMOND 37.781578063965 -122.494522094727 POINT (-122.49452209 37.78157806) Phone   8 8 4 17 2 11 9 55 6 15 15   8   4             1         8
211385 211385 9258265 2018-07-12T14:15:00 2018-08-11T07:23:24 2018-08-11T07:23:24 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 403 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 1 Outer Richmond RICHMOND 37.781829833984 -122.485038757324 POINT (-122.48503876 37.78182983) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
212357 212357 9297908 2018-07-21T17:46:00 2018-08-07T09:25:00 2018-08-07T09:25:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 4521 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.7751121521 -122.50741577148399 POINT (-122.50741577 37.77511215) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
218194 218194 9242015 2018-07-09T09:44:00 2018-08-09T08:15:00 2018-08-09T08:15:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781257629395 -122.458862304688 POINT (-122.4588623 37.78125763) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
231036 231036 9345523 2018-08-01T11:38:00 2018-08-07T09:12:00 2018-08-07T09:12:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 10TH AVE and LAKE ST 10TH AVE 1 Presidio Terrace RICHMOND 37.786483764648 -122.46897125244101 POINT (-122.46897125 37.78648376) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
237891 237891 9057496 2018-05-27T17:07:00 2018-06-09T08:03:00 2018-06-09T08:03:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 5TH AVE and LAKE ST 5TH AVE 2 Presidio Terrace RICHMOND 37.786720275879 -122.46361541748001 POINT (-122.46361542 37.78672028) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
240886 240886 9338792 2018-07-31T07:48:00 2018-08-10T11:46:00 2018-08-10T11:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 138 BLAKE ST, SAN FRANCISCO, CA, 94118 BLAKE ST 1 Lone Mountain PARK 37.781437 -122.45098 POINT (-122.45098 37.781437) Mobile/Open311 http://mobile311.sfgov.org/reports/9338792/photos 12 7 4 18 2 15 9 54 6 16 16   12   4             1         12
348706 348706 8362368 2017-12-08T10:37:00 2017-12-21T10:16:00 2017-12-21T10:16:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of PRESIDIO AVE and MASONIC AVE PRESIDIO AVE 2 Laurel Heights / Jordan Park RICHMOND 37.78630065918 -122.44660949706999 POINT (-122.4466095 37.78630066) Phone   11 8 6 31 1 15 9 54 6 31 31   11   6             1         11
350127 350127 9436318 2018-08-22T09:58:00 2018-08-23T08:44:00 2018-08-23T08:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 10TH AVE and LAKE ST 10TH AVE 1 Presidio Terrace RICHMOND 37.786483764648 -122.46897125244101 POINT (-122.46897125 37.78648376) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
357832 357832 9464275 2018-08-28T12:21:00 2018-08-29T00:07:00 2018-08-29T00:07:00 Closed 2 Your tree planting request has been received and will be transferred to the tree inspectors. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 713 14TH AVE, SAN FRANCISCO, CA, 94118 14TH AVE 1 Inner Richmond RICHMOND 37.774678333333 -122.472558333333 POINT (-122.47255833 37.77467833) Mobile/Open311 http://mobile311.sfgov.org/reports/9464275/photos 5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
362071 362071 9591668 2018-09-26T12:01:00 2018-09-27T02:53:00 2018-09-27T02:53:00 Closed 2 Your request is a duplicate of SO #981376 and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of BALBOA ST and LA PLAYA BALBOA ST 1 Outer Richmond RICHMOND 37.775127410889 -122.51016998291 POINT (-122.51016998 37.77512741) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
364724 364724 9537220 2018-09-13T14:33:00 2018-09-20T11:28:00 2018-09-20T11:28:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1835 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.776424407959 -122.47869873046899 POINT (-122.47869873 37.77642441) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
400296 400296 9568613 2018-09-20T17:39:00 2018-10-25T06:41:10 2018-10-25T06:41:10 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 515 27TH AVE, SAN FRANCISCO, CA, 94121 27TH AVE 1 Outer Richmond RICHMOND 37.779605 -122.48694666666701 POINT (-122.48694667 37.779605) Mobile/Open311 http://mobile311.sfgov.org/reports/9568613/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
401349 401349 9472073 2018-08-29T20:07:00 2018-11-16T08:31:51 2018-11-16T08:31:51 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1090 POINT LOBOS AVE, SAN FRANCISCO, CA, 94121 POINT LOBOS AVE 1 Lincoln Park / Ft. Miley RICHMOND 37.778415679931996 -122.514434814453 POINT (-122.51443481 37.77841568) Phone   7   4 29 2   9 55 6 26 26   7   4             1         7
414958 414958 9417418 2018-08-17T16:25:00   2019-07-09T13:15:17 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 75 MASONIC AVE, SAN FRANCISCO, CA, 94118 MASONIC AVE 1 Lone Mountain PARK 37.781308200000005 -122.4478186 POINT (-122.4478186 37.7813082) Web   12 7 4 18 2 15 9 54 6 16 16   12   4             1         12
422921 422921 9431217 2018-08-21T10:06:00 2018-08-29T08:44:00 2018-08-29T08:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 559 21ST AVE, SAN FRANCISCO, CA, 94121 21ST AVE 1 Outer Richmond RICHMOND 37.777256011963 -122.480369567871 POINT (-122.48036957 37.77725601) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
432425 432425 10330912 2019-01-08T12:36:00 2019-01-16T14:51:47 2019-01-16T14:51:47 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2670 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.782880878111 -122.44699987594299 POINT (-122.44699988 37.78288088) Mobile/Open311 http://mobile311.sfgov.org/reports/10330912/photos 11 8 6 31 1 15 9 54 6 31 31   11   6             1         11
435359 435359 9867854 2018-11-29T11:42:00 2019-05-11T14:30:41 2019-05-11T14:30:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 201 MASONIC AVE, SAN FRANCISCO, CA, 94118 MASONIC AVE 1 Lone Mountain PARK 37.780036666667 -122.44754666666701 POINT (-122.44754667 37.78003667) Mobile/Open311 http://mobile311.sfgov.org/reports/9867854/photos 12 7 4 18 2 15 9 54 6 16 16   12   4             1         12
444429 444429 9874117 2018-11-30T15:52:00   2018-12-18T11:45:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 121 STANYAN BLVD, SAN FRANCISCO, CA, 94118 STANYAN BLVD 1 Lone Mountain PARK 37.779445648193004 -122.455726623535 POINT (-122.45572662 37.77944565) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
447593 447593 10405111 2019-01-25T12:10:00 2019-03-31T14:40:35 2019-03-31T14:40:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 785 37TH AVE, SAN FRANCISCO, CA, 94121 37TH AVE 1 Outer Richmond RICHMOND 37.7742619 -122.49748770000001 POINT (-122.4974877 37.7742619) Web http://mobile311.sfgov.org/reports/10405111/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
464874 464874 10366972 2019-01-16T21:37:00   2019-02-01T09:45:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1465 BAKER ST, SAN FRANCISCO, CA, 94115 BAKER ST 5 Lower Pacific Heights RICHMOND 37.784508333333 -122.443175 POINT (-122.443175 37.78450833) Mobile/Open311 http://mobile311.sfgov.org/reports/10366972/photos 103 8 11 31 11 15 9 29,490 6 31 31   103   11             1         103
477130 477130 9773009 2018-11-06T10:05:00 2018-11-06T12:30:00 2018-11-06T12:30:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 35TH AVE and GEARY BLVD 35TH AVE 1 Outer Richmond RICHMOND 37.779590606689 -122.49543762206999 POINT (-122.49543762 37.77959061) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
489309 489309 10322665 2019-01-06T17:50:00 2019-01-25T07:46:00 2019-01-25T07:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 184 JORDAN AVE, SAN FRANCISCO, CA, 94118 JORDAN AVE 2 Laurel Heights / Jordan Park RICHMOND 37.781921386719 -122.45620827431401 POINT (-122.45620827 37.78192139) Mobile/Open311 http://mobile311.sfgov.org/reports/10322665/photos 11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
496865 496865 9873737 2018-11-30T14:41:00 2019-05-11T14:31:25 2019-05-11T14:31:25 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3039 ANZA ST, SAN FRANCISCO, CA, 94121 ANZA ST 1 Outer Richmond RICHMOND 37.778186798096 -122.480995178223 POINT (-122.48099518 37.7781868) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
498507 498507 10368998 2019-01-17T10:20:00 2019-05-11T14:40:45 2019-05-11T14:40:45 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 616 44TH AVE, SAN FRANCISCO, CA, 94121 44TH AVE 1 Sutro Heights RICHMOND 37.776871011627996 -122.50485629786002 POINT (-122.5048563 37.77687101) Mobile/Open311 http://mobile311.sfgov.org/reports/10368998/photos 6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
507050 507050 10309634 2019-01-03T10:12:00   2019-01-11T11:05:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 2866 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789180755615 -122.44002532959 POINT (-122.44002533 37.78918076) Phone   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
509217 509217 10333981 2019-01-09T08:23:00 2019-01-11T15:14:06 2019-01-11T15:14:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 838 34TH AVE, SAN FRANCISCO, CA, 94121 34TH AVE 1 Outer Richmond RICHMOND 37.773262023926 -122.493759155273 POINT (-122.49375916 37.77326202) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
515753 515753 10304913 2019-01-02T11:04:00 2019-01-02T13:48:33 2019-01-02T13:48:33 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3579 JACKSON ST, SAN FRANCISCO, CA, 94118 JACKSON ST 2 Presidio Heights RICHMOND 37.789878845215 -122.45368957519501 POINT (-122.45368958 37.78987885) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
515866 515866 9804668 2018-11-13T16:44:00 2018-11-30T15:19:00 2018-11-30T15:19:00 Closed 2 Your service order has been accepted, closed out as - work previously done. thank you DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of CLEMENT ST and 39TH AVE CLEMENT ST 1 Outer Richmond RICHMOND 37.781326293945 -122.49987030029301 POINT (-122.4998703 37.78132629) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
522849 522849 10349219 2019-01-12T15:34:00   2019-05-11T15:30:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 479 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Outer Richmond RICHMOND 37.778910338102 -122.47824964406999 POINT (-122.47824964 37.77891034) Mobile/Open311 http://mobile311.sfgov.org/reports/10349219/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
523070 523070 9884837 2018-12-03T13:26:00   2019-04-25T12:23:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 646 FUNSTON AVE, SAN FRANCISCO, CA, 94118 FUNSTON AVE 1 Inner Richmond RICHMOND 37.77600479126 -122.47128295898399 POINT (-122.47128296 37.77600479) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
558469 558469 10374619 2019-01-18T11:44:00 2019-01-25T08:01:00 2019-01-25T08:01:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1928 PIERCE ST, SAN FRANCISCO, CA, 94115 PIERCE ST 2 Lower Pacific Heights NORTHERN 37.7880128725 -122.43699365979201 POINT (-122.43699366 37.78801287) Mobile/Open311 http://mobile311.sfgov.org/reports/10374619/photos 103 4 6 30 1 13 9 29,490 6 27 27   103   6             1         103
561399 561399 10374756 2019-01-18T12:05:00 2019-02-13T09:08:21 2019-02-13T09:08:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 154 21ST AVE, SAN FRANCISCO, CA, 94121 21ST AVE 1 Lake Street RICHMOND 37.784937 -122.480457 POINT (-122.480457 37.784937) Mobile/Open311 http://mobile311.sfgov.org/reports/10374756/photos 2 8 4 29 2 11 9 55 6 26 26   2   4             2         2
561884 561884 10366962 2019-01-16T21:35:00 2019-01-17T13:17:55 2019-01-17T13:17:55 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1459 BAKER ST, SAN FRANCISCO, CA, 94115 BAKER ST 5 Lower Pacific Heights RICHMOND 37.78447 -122.44308333333299 POINT (-122.44308333 37.78447) Mobile/Open311 http://mobile311.sfgov.org/reports/10366962/photos 103 8 11 15 11 15 9 29,490 6 13 13   103   11             2         103
565765 565765 10439462 2019-02-02T08:39:00   2019-02-07T10:45:12 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 14TH AVE and LAKE ST 14TH AVE 2 Lake Street RICHMOND 37.786289215088 -122.473251342773 POINT (-122.47325134 37.78628922) Phone   2 8 6 33 1 11 9 54 6 33 33   2   6             1         2
568830 568830 10717337 2019-04-11T14:54:00   2019-05-13T06:35:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 375 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Outer Richmond RICHMOND 37.78098866347 -122.47834928345199 POINT (-122.47834928 37.78098866) Mobile/Open311 http://mobile311.sfgov.org/reports/10717337/photos   8 4 29 2 11 9 55 6 26 26       4             2          
604398 604398 10649408 2019-03-26T14:59:00 2019-04-02T08:23:00 2019-04-02T08:23:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 399 LAUREL ST, SAN FRANCISCO, CA, 94118 LAUREL ST 2 Presidio Heights RICHMOND 37.787929534912 -122.450477600098 POINT (-122.4504776 37.78792953) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10

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