calls

7,158 rows where Responsible_Agency = 2 sorted by Source

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
19355 19355 5657415 2016-03-11T19:22:59 2016-03-17T09:21:58 2016-03-17T09:21:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 24TH AVE and SANTIAGO ST 24TH AVE 4 Parkside TARAVAL 37.744682312012 -122.48117828369101 POINT (-122.48117828 37.74468231) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7 25     24     1         40
103250 103250 9463836 2018-08-28T11:20:00   2018-08-29T12:30:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
118798 118798 6631962 2016-12-15T13:44:56 2016-12-20T07:45:11 2016-12-20T07:45:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 60 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Buena Vista PARK 37.768119812012 -122.435859680176 POINT (-122.43585968 37.76811981) Integrated Agency   112 7 5 5 5 15 8 29,492 5 3 3   112   5             1         112
128977 128977 5642258 2016-03-07T20:15:35 2016-03-09T09:11:00 2016-03-09T09:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2659 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Cow Hollow NORTHERN 37.798595428467 -122.445213317871 POINT (-122.44521332 37.79859543) Integrated Agency   14 4 6 13 1 13 6 57 9 17 17   14   6   21         1         14
168278 168278 9397820 2018-08-13T15:27:00 2018-08-17T13:16:00 2018-08-17T13:16:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
178840 178840 9377538 2018-08-08T15:40:00 2018-08-09T08:33:00 2018-08-09T08:33:00 Closed 2 Service Order Duplicate | Closed out as Duplicate. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 284 DIVISADERO ST, SAN FRANCISCO, CA, 94117 DIVISADERO ST 5 Lower Haight NORTHERN 37.771938323975 -122.437065124512 POINT (-122.43706512 37.77193832) Integrated Agency   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
191843 191843 9244774 2018-07-09T16:11:00 2018-08-10T09:24:00 2018-08-10T09:24:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
200678 200678 9244775 2018-07-09T16:11:00 2019-05-26T10:12:03 2019-05-26T10:12:03 Closed 2 Should be routed to DPW-BSES DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
272068 272068 9377539 2018-08-08T15:40:00   2018-08-08T16:10:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 284 DIVISADERO ST, SAN FRANCISCO, CA, 94117 DIVISADERO ST 5 Lower Haight NORTHERN 37.771938323975 -122.437065124512 POINT (-122.43706512 37.77193832) Integrated Agency   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
274321 274321 9397819 2018-08-13T15:27:00 2019-05-17T09:49:11 2019-05-17T09:49:11 Closed 2 Should be routed to DPW-BSES DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
295305 295305 9447168 2018-08-24T11:43:00 2018-08-27T14:28:00 2018-08-27T14:28:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
334797 334797 9447165 2018-08-24T11:43:00 2018-08-27T14:31:00 2018-08-27T14:31:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
374360 374360 9632328 2018-10-05T14:36:00 2018-10-09T06:12:21 2018-10-09T06:12:21 Closed 2 Should be routed to DPW-BSES DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 101 SANTOS ST, SAN FRANCISCO, CA, 94134 SANTOS ST 10 Sunnydale INGLESIDE 37.71070098877 -122.418998718262 POINT (-122.41899872 37.71070099) Integrated Agency   74 9 9 40 8 9 4 309 7 39 39   74   9 16     16     2         74
384188 384188 9540198 2018-09-14T10:14:00 2018-11-16T08:41:00 2018-11-16T08:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2469 BRYANT ST, SAN FRANCISCO, CA, 94110 BRYANT ST 9 Mission MISSION 37.754894256592 -122.40910339355499 POINT (-122.40910339 37.75489426) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
386039 386039 9616578 2018-10-02T11:28:00 2018-10-10T11:26:00 2018-10-10T11:26:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of AVALON AVE and EDINBURGH ST AVALON AVE 11 Excelsior INGLESIDE 37.725902557373 -122.428482055664 POINT (-122.42848206 37.72590256) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
392993 392993 9463838 2018-08-28T11:20:00 2019-01-31T06:41:00 2019-01-31T06:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
401095 401095 9447167 2018-08-24T11:43:00 2018-08-27T14:29:00 2018-08-27T14:29:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
406992 406992 9652336 2018-10-10T10:43:00 2018-10-11T08:30:41 2018-10-11T08:30:41 Closed 2 Should be routed to DPW-BSES DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 101 SANTOS ST, SAN FRANCISCO, CA, 94134 SANTOS ST 10 Sunnydale INGLESIDE 37.71070098877 -122.418998718262 POINT (-122.41899872 37.71070099) Integrated Agency   74 9 9 40 8 9 4 309 7 39 39   74   9 16     16     2         74
413815 413815 9463839 2018-08-28T11:20:00   2018-08-28T12:57:00 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
414326 414326 9447169 2018-08-24T11:43:00 2018-08-27T14:25:00 2018-08-27T14:25:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
421567 421567 9616577 2018-10-02T11:28:00 2018-10-10T11:28:00 2018-10-10T11:28:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of AVALON AVE and EDINBURGH ST AVALON AVE 11 Excelsior INGLESIDE 37.725902557373 -122.428482055664 POINT (-122.42848206 37.72590256) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
422012 422012 9463841 2018-08-28T11:20:00   2018-08-28T12:57:20 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 478 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Excelsior INGLESIDE 37.720489501953004 -122.429458618164 POINT (-122.42945862 37.7204895) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
457988 457988 10306590 2019-01-02T14:52:00 2019-01-02T23:24:00 2019-01-02T23:24:00 Closed 2 Your tree inspection 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 2048 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 4 Outer Sunset TARAVAL 37.763561248779 -122.47997283935499 POINT (-122.47997284 37.76356125) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35 9 39   7 11 13   11     1         39
464844 464844 10306591 2019-01-02T14:52:00 2019-01-02T23:27:00 2019-01-02T23:27:00 Closed 2 Your tree inspection 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 2048 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 4 Outer Sunset TARAVAL 37.763561248779 -122.47997283935499 POINT (-122.47997284 37.76356125) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35 9 39   7 11 13   11     1         39
486117 486117 11052972 2019-06-27T10:11:00 2019-09-16T07:16:00 2019-09-16T07:16:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 14TH ST and DIVISADERO ST 14TH ST 8 Buena Vista PARK 37.767272949219 -122.436477661133 POINT (-122.43647766 37.76727295) Integrated Agency   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
494271 494271 10976255 2019-06-10T10:16:00   2019-08-30T18:00:02 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
516382 516382 10306592 2019-01-02T14:52:00 2019-01-03T08:01:00 2019-01-03T08:01:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GROVE ST and OCTAVIA ST GROVE ST 5 Hayes Valley NORTHERN 37.777603149414 -122.42481231689501 POINT (-122.42481232 37.77760315) Integrated Agency   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
547004 547004 9802228 2018-11-13T10:56:00   2018-11-15T14:20:05 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 3843 24TH ST, SAN FRANCISCO, CA, 94114 24TH ST 8 Noe Valley MISSION 37.751518249512 -122.428382873535 POINT (-122.42838287 37.75151825) Integrated Agency   84 3 5 22 5 2 7 28,862 4 22 22   84   5   9     12   1         84
564540 564540 10577529 2019-03-08T09:46:00 2019-03-08T11:33:00 2019-03-08T11:33:00 Closed 2 inspected on 3/8/19 and found no leaning tree about to fall no hazard seen DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of PAUL AVE and SAN BRUNO AVE PAUL AVE 9 Portola BAYVIEW 37.723918914795 -122.402061462402 POINT (-122.40206146 37.72391891) Integrated Agency   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
616245 616245 10489255 2019-02-14T12:29:00 2019-02-19T10:39:48 2019-02-19T10:39:48 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 100 PORTOLA DR, SAN FRANCISCO, CA, 94131 PORTOLA DR 8 Upper Market MISSION 37.749649047852 -122.44367980956999 POINT (-122.44367981 37.74964905) Integrated Agency   51 7 5 38 5 2 8 28,862 5 38 38   51   5             1         51
644789 644789 10676975 2019-04-02T12:36:00 2019-04-03T06:08:09 2019-04-03T06:08:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of INGALLS ST and SHAFTER AVE INGALLS ST 10 Hunters Point BAYVIEW 37.72785949707 -122.385116577148 POINT (-122.38511658 37.7278595) Integrated Agency   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
1928369 1928369 4138254 2014-10-23T11:29:07 2016-09-27T10:33:08 2016-09-27T10:33:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 700 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.761745452880994 -122.417358398438 POINT (-122.4173584 37.76174545) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1931904 1931904 3980363 2014-09-04T10:05:00   2014-09-04T10:47:06 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 530 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.728458404541 -122.472122192383 POINT (-122.47212219 37.7284584) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
1936575 1936575 4313844 2014-12-18T09:26:08 2014-12-19T09:21:23 2014-12-19T09:21:23 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 385 NIAGARA AVE, SAN FRANCISCO, CA, 94112 NIAGARA AVE 11 Cayuga INGLESIDE 37.719234466553004 -122.44725799560499 POINT (-122.447258 37.71923447) Integrated Agency   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
1939204 1939204 4346622 2014-12-30T13:34:14 2015-01-06T08:34:10 2015-01-06T08:34:10 Closed 2 resolved: removed down acacia DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and GOLDEN GATE AVE DIVISADERO ST 5 Western Addition NORTHERN 37.77872467041 -122.43855285644501 POINT (-122.43855286 37.77872467) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             1         97
1941267 1941267 4046637 2014-09-25T09:48:58 2014-10-03T09:33:15 2014-10-03T09:33:15 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 31ST AVE and FULTON ST 31ST AVE 1 Outer Richmond RICHMOND 37.772277832031 -122.490615844727 POINT (-122.49061584 37.77227783) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1954193 1954193 3959324 2014-08-28T07:49:19   2014-08-29T10:01:00 Open 1 scheduled DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 16TH ST and CHURCH ST 16TH ST 8 Mission Dolores MISSION 37.764507293701 -122.428665161133 POINT (-122.42866516 37.76450729) Integrated Agency   37 3 5 5 5 8 7 28,862 4 3 3   37   5       1     1   5     37
1958971 1958971 3944362 2014-08-23T12:08:16   2014-08-25T10:04:55 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 175 BOCANA ST, SAN FRANCISCO, CA, 94110 BOCANA ST 9 Bernal Heights INGLESIDE 37.74125289917 -122.41717529296899 POINT (-122.41717529 37.7412529) Integrated Agency   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
1961536 1961536 4075857 2014-10-04T15:35:56 2015-02-27T02:59:06 2015-02-27T02:59:06 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1450 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 5 Western Addition NORTHERN 37.783061981201 -122.43853759765601 POINT (-122.4385376 37.78306198) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
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
1970018 1970018 4070108 2014-10-02T16:22:03 2014-10-04T12:28:30 2014-10-04T12:28:30 Closed 2 resolved: Area is currently under inspection for irrigation repairs. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BROADWAY and POLK ST BROADWAY 3 Polk Gulch NORTHERN 37.795944213867 -122.421768188477 POINT (-122.42176819 37.79594421) Integrated Agency   105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
1974876 1974876 4347935 2014-12-30T19:28:00 2015-01-12T06:37:48 2015-01-12T06:37:48 Closed 2 cancelled: no down trees on Church st seen anywhhere on Church St DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HILL ST and CHURCH ST HILL ST 8 Dolores Heights MISSION 37.75569152832 -122.42781066894501 POINT (-122.42781067 37.75569153) Integrated Agency   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1987953 1987953 3980361 2014-09-04T10:04:55   2014-09-04T10:47:19 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 400 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.729930877686 -122.472061157227 POINT (-122.47206116 37.72993088) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
1994493 1994493 4348422 2014-12-31T04:36:40 2015-01-07T08:42:00 2015-01-07T08:42:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 3725 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Mission Dolores MISSION 37.762702941895 -122.42911529541 POINT (-122.4291153 37.76270294) Integrated Agency   37 3 5 5 5 8 7 28,862 4 3 3   37   5       1     1   5     37
2001083 2001083 4310320 2014-12-17T07:06:50 2014-12-22T07:56:00 2014-12-22T07:56:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 11TH ST and MISSION ST 11TH ST 6 South of Market SOUTHERN 37.774326324463 -122.41710662841801 POINT (-122.41710663 37.77432632) Integrated Agency   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1   7 1 2 1 1     32
2011353 2011353 4372970 2015-01-08T04:39:41 2015-03-09T04:01:00 2015-03-09T04:01:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BAY SHORE BLVD and RAYMOND AVE BAY SHORE BLVD 10 Visitacion Valley INGLESIDE 37.711818695068004 -122.403282165527 POINT (-122.40328217 37.7118187) Integrated Agency   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
2013253 2013253 3978356 2014-09-03T15:13:55 2014-09-09T02:44:28 2014-09-09T02:44:28 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 2743 LAGUNA ST, SAN FRANCISCO, CA, 94123 LAGUNA ST 2 Pacific Heights NORTHERN 37.796440124512 -122.43044281005899 POINT (-122.43044281 37.79644012) Integrated Agency   102 4 6 13 1 13 6 57 9 17 17   102   6             1         102
2025576 2025576 3980362 2014-09-04T10:04:57   2014-09-04T10:47:28 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 600 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.727794647217 -122.47216033935499 POINT (-122.47216034 37.72779465) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
2029735 2029735 4291829 2014-12-11T05:59:32 2014-12-16T01:54:00 2014-12-16T01:54:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BROTHERHOOD WAY and LAKE MERCED BLVD BROTHERHOOD WAY 7 Parkmerced TARAVAL 37.714694976806996 -122.485229492188 POINT (-122.48522949 37.71469498) Integrated Agency   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
2047498 2047498 4347999 2014-12-30T19:59:36 2015-01-06T08:14:05 2015-01-06T08:14:05 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 29 MENDOSA AVE, SAN FRANCISCO, CA, 94116 MENDOSA AVE 7 Forest Hill TARAVAL 37.748908996581996 -122.465545654297 POINT (-122.46554565 37.748909) Integrated Agency   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
2054861 2054861 4530306 2015-02-27T12:40:48 2015-03-05T10:18:00 2015-03-05T10:18:00 Closed 2 resolved: Half of tree fell on 2/27 tree was unsafe removed remaining tree DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1042 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Buena Vista PARK 37.771087646484 -122.439559936523 POINT (-122.43955994 37.77108765) Integrated Agency   112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
2070475 2070475 4529516 2015-02-27T09:46:01 2015-10-05T06:08:00 2015-10-05T06:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LA SALLE AVE and WHITFIELD CT LA SALLE AVE 10 Bayview BAYVIEW 37.731174468994006 -122.381607055664 POINT (-122.38160706 37.73117447) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2070489 2070489 4468452 2015-02-07T01:22:13 2015-02-09T09:53:00 2015-02-09T09:53:00 Closed 2 resolved: removed down tree DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1100 SCOTT ST, Apt 107, SAN FRANCISCO, CA, 94115 SCOTT ST 5 Western Addition NORTHERN 37.78039932251 -122.435997009277 POINT (-122.43599701 37.78039932) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
2081658 2081658 4694698 2015-04-25T07:10:49 2015-04-29T02:18:00 2015-04-29T02:18:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of MOULTRIE ST and OGDEN AVE MOULTRIE ST 9 Bernal Heights INGLESIDE 37.736038208008 -122.416061401367 POINT (-122.4160614 37.73603821) Integrated Agency   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2082472 2082472 4401559 2015-01-17T03:32:57 2015-02-28T12:55:15 2015-02-28T12:55:15 Closed 2 cancelled: no water running now private DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GELLERT DR and MORNINGSIDE DR GELLERT DR 7 Lakeshore TARAVAL 37.729228973389 -122.491264343262 POINT (-122.49126434 37.72922897) Integrated Agency   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
2094816 2094816 4805929 2015-06-05T21:37:33 2015-09-14T07:00:00 2015-09-14T07:00:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2445 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 5 Lower Pacific Heights NORTHERN 37.78731918335 -122.43644714355499 POINT (-122.43644714 37.78731918) Integrated Agency   103 4 11 30 11 13 9 29,490 6 27 27   103   11             1         103
2116744 2116744 4466549 2015-02-06T13:56:37 2015-02-07T07:20:00 2015-02-07T07:20:00 Closed 2 resolved: removed limb DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 704 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.726593017578004 -122.472221374512 POINT (-122.47222137 37.72659302) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
2129657 2129657 4528767 2015-02-26T23:52:29 2016-08-15T11:40:24 2016-08-15T11:40:24 Closed 2 Need BUF tree inspector to inspect DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 100 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 6 Civic Center NORTHERN 37.77672958374 -122.41931915283199 POINT (-122.41931915 37.77672958) Integrated Agency   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
2136414 2136414 4466989 2015-02-06T15:18:45 2015-02-17T09:39:00 2015-02-17T09:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of FOLSOM ST and STONEMAN ST FOLSOM ST 9 Bernal Heights INGLESIDE 37.745147705078004 -122.413375854492 POINT (-122.41337585 37.74514771) Integrated Agency   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2139020 2139020 4468028 2015-02-06T19:53:30 2015-02-28T11:09:00 2015-02-28T11:09:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of EDDY ST and VAN NESS AVE EDDY ST 6 Tenderloin NORTHERN 37.782894134521 -122.42081451416 POINT (-122.42081451 37.78289413) Integrated Agency   20 4 10 36 9 7 6 28,852 9 36 36   20 1 10           1 2 1       20
2144736 2144736 4468391 2015-02-06T23:07:16 2015-03-02T09:57:33 2015-03-02T09:57:33 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1862 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.782279968262 -122.436813354492 POINT (-122.43681335 37.78227997) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
2157447 2157447 4702079 2015-04-28T09:22:40 2015-04-29T01:32:00 2015-04-29T01:32:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PLYMOUTH AVE and OCEAN AVE PLYMOUTH AVE 7 Ingleside TARAVAL 37.723886089456 -122.456152029459 POINT (-122.45615203 37.72388609) Integrated Agency   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19 13   2         64
2159286 2159286 4391816 2015-01-14T05:33:16 2015-03-04T09:29:00 2015-03-04T09:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
2161516 2161516 4469268 2015-02-07T10:39:09 2015-02-08T09:57:00 2015-02-08T09:57:00 Closed 2 resolved: removed down tree and limbs on island DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ALEMANY BLVD and CHESTER AVE ALEMANY BLVD 7 Merced Heights TARAVAL 37.709899902344 -122.470405578613 POINT (-122.47040558 37.7098999) Integrated Agency   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
2163325 2163325 4550507 2015-03-06T07:54:27   2017-01-03T08:15:00 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GOULD ST and PAUL AVE GOULD ST 10 Bret Harte BAYVIEW 37.722873687744006 -122.397666931152 POINT (-122.39766693 37.72287369) Integrated Agency   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
2172365 2172365 4468485 2015-02-07T06:24:11 2015-02-18T07:55:00 2015-02-18T07:55:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1066 PALOU AVE, Apt E, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Hunters Point BAYVIEW 37.728401184081996 -122.380996704102 POINT (-122.3809967 37.72840118) Integrated Agency   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
2186075 2186075 4466548 2015-02-06T13:56:35 2015-02-14T12:04:00 2015-02-14T12:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HYDE ST and VALLEJO ST HYDE ST 3 Russian Hill CENTRAL 37.797332763671996 -122.418670654297 POINT (-122.41867065 37.79733276) Integrated Agency   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
2186663 2186663 4468504 2015-02-07T06:52:20 2015-03-02T09:47:15 2015-03-02T09:47:15 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1864 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.782279968262 -122.436813354492 POINT (-122.43681335 37.78227997) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
2192567 2192567 4869346 2015-06-30T17:39:18 2015-07-07T08:50:43 2015-07-07T08:50:43 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HAIGHT ST and SCOTT ST HAIGHT ST 5 Lower Haight NORTHERN 37.771480560303004 -122.435371398926 POINT (-122.4353714 37.77148056) Integrated Agency   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
2194707 2194707 5164137 2015-10-06T12:25:33 2015-12-18T12:33:00 2015-12-18T12:33:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2128 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Pacific Heights NORTHERN 37.794174194336 -122.424629211426 POINT (-122.42462921 37.79417419) Integrated Agency   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
2234366 2234366 4972742 2015-08-06T10:23:03 2015-08-17T08:13:00 2015-08-17T08:13:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 36TH AVE and QUINTARA ST 36TH AVE 4 Outer Sunset TARAVAL 37.747840216073 -122.494297043325 POINT (-122.49429704 37.74784022) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
2239171 2239171 4980120 2015-08-09T02:08:19 2015-08-12T07:49:00 2015-08-12T07:49:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2762 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 2 Lower Pacific Heights RICHMOND 37.78710625321 -122.44141095751101 POINT (-122.44141096 37.78710625) Integrated Agency   103 8 6 30 1 13 9 29,490 6 27 27   103   6             1         103
2246399 2246399 5159850 2015-10-05T07:26:57 2015-10-26T03:19:00 2015-10-26T03:19:00 Closed 2 resolved: Communicated this information to the crew. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 1180 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.752239227295 -122.423065185547 POINT (-122.42306519 37.75223923) Integrated Agency   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
2255874 2255874 5211387 2015-10-21T14:02:07 2016-05-12T07:54:00 2016-05-12T07:54:00 Closed 2 San Francisco Department of Public WorksLocation: 410 DouglassDPW-BBR Plumbing Shop Scope: Repair break in irrigation line. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 410 DOUGLASS ST, SAN FRANCISCO, CA, 94114 DOUGLASS ST 8 Eureka Valley MISSION 37.756843566895 -122.43909454345699 POINT (-122.43909454 37.75684357) Integrated Agency   115 3 5 38 5 2 7 28,862 4 38 38   115   5             1         115
2260121 2260121 5220064 2015-10-24T06:14:16   2015-10-28T05:52:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CESAR CHAVEZ ST and FOLSOM ST CESAR CHAVEZ ST 9 Bernal Heights MISSION 37.748254179940005 -122.41366814201099 POINT (-122.41366814 37.74825418) Integrated Agency   83 3 2 2 7 2 7 28,859 4 2 2   83   2     3       1   3     83
2281836 2281836 4882039 2015-07-05T11:54:03 2015-07-17T02:10:00 2015-07-17T02:10:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CESAR CHAVEZ ST and SHOTWELL ST CESAR CHAVEZ ST 9 Bernal Heights MISSION 37.748189098759 -122.41429262194299 POINT (-122.41429262 37.7481891) Integrated Agency   83 3 2 2 7 2 7 28,859 4 2 2   83   2     3       1   3     83
2288642 2288642 4831111 2015-06-16T10:28:15 2015-06-20T07:49:18 2015-06-20T07:49:18 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1863 14TH AVE, SAN FRANCISCO, CA, 94122 14TH AVE 7 Golden Gate Heights TARAVAL 37.75313949585 -122.47119903564501 POINT (-122.47119904 37.7531395) Integrated Agency   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
2305914 2305914 4985734 2015-08-10T22:39:35 2015-08-14T09:20:00 2015-08-14T09:20:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1800 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 9 Mission MISSION 37.76789855957 -122.41571044921899 POINT (-122.41571045 37.76789856) Integrated Agency   53 3 2 20 7 8 7 28,853 4 19 19 12 53   2 14   3 14     2   3     53
2317270 2317270 5010658 2015-08-18T14:24:11 2015-08-18T11:35:00 2015-08-18T11:35:00 Closed 2 resolved: area has been inspected and has been determined to be private or Water Department. No shut off has been located to turn off water source. Information has been forwarded. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 1400 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 Telegraph Hill CENTRAL 37.802097320556996 -122.40447998046899 POINT (-122.40447998 37.80209732) Integrated Agency   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
2324087 2324087 5493117 2016-01-22T14:54:05 2016-01-26T03:04:00 2016-01-26T03:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1068 CAROLINA ST, SAN FRANCISCO, CA, 94107 CAROLINA ST 10 Potrero Hill BAYVIEW 37.755149841309 -122.399864196777 POINT (-122.3998642 37.75514984) Integrated Agency   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
2344834 2344834 5409628 2015-12-28T11:28:54   2017-02-21T11:55:00 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 10TH ST and MARKET ST 10TH ST 6 Civic Center TENDERLOIN 37.776542663574 -122.41750335693399 POINT (-122.41750336 37.77654266) Integrated Agency   21 5 10 36 9 8 2 28,853 2 36 36   21 1 10     1   8 1 2 1 1 35   21
2345809 2345809 5254187 2015-11-04T12:25:51 2015-11-06T01:12:00 2015-11-06T01:12:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 879 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Lower Haight NORTHERN 37.773541757302 -122.433733719573 POINT (-122.43373372 37.77354176) Integrated Agency   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
2353382 2353382 5397724 2015-12-22T18:44:12 2015-12-24T09:30:29 2015-12-24T09:30:29 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2945 BAKER ST, SAN FRANCISCO, CA, 94123 BAKER ST 2 Cow Hollow NORTHERN 37.798233032227 -122.44603729248001 POINT (-122.44603729 37.79823303) Integrated Agency   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
2357420 2357420 5338364 2015-12-02T14:25:07 2016-11-04T12:10:11 2016-11-04T12:10:11 Closed 2 Ficus tree needs to be removed please post for removal DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2940 24TH ST, SAN FRANCISCO, CA, 94110 24TH ST 9 Mission MISSION 37.75280380249 -122.41081237793001 POINT (-122.41081238 37.7528038) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       1   3     53
2363003 2363003 5578777 2016-02-18T08:35:46 2016-02-26T05:47:00 2016-02-26T05:47:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BREWSTER ST and COSTA ST BREWSTER ST 9 Peralta Heights INGLESIDE 37.744812011719 -122.406898498535 POINT (-122.4068985 37.74481201) Integrated Agency   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
2383784 2383784 5436744 2016-01-06T07:01:31 2016-01-07T06:57:00 2016-01-07T06:57:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 11TH ST and MARKET ST 11TH ST 6 South of Market TENDERLOIN 37.77555847168 -122.418655395508 POINT (-122.4186554 37.77555847) Integrated Agency   32 5 10 34 9 8 2 28,853 2 34 34   32 1 10     1   8 1 2 1 1     32
2395252 2395252 5370614 2015-12-13T10:23:43 2015-12-18T06:39:00 2015-12-18T06:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAKER ST and GREENWICH ST BAKER ST 2 Cow Hollow NORTHERN 37.797691345215 -122.445785522461 POINT (-122.44578552 37.79769135) Integrated Agency   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
2429670 2429670 5294028 2015-11-17T15:45:12 2015-11-22T09:59:51 2015-11-22T09:59:51 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 371 STAPLES AVE, SAN FRANCISCO, CA, 94112 STAPLES AVE 7 Sunnyside INGLESIDE 37.728939056396 -122.45044708251999 POINT (-122.45044708 37.72893906) Integrated Agency   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
2433816 2433816 5404676 2015-12-26T03:52:59 2016-01-05T10:07:00 2016-01-05T10:07:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1035 BOSWORTH ST, SAN FRANCISCO, CA, 94131 BOSWORTH ST 8 Glen Park INGLESIDE 37.734188079834 -122.438186645508 POINT (-122.43818665 37.73418808) Integrated Agency   96 9 5 41 5 9 4 63 7 40 40   96   5             1         96
2455353 2455353 5473905 2016-01-17T15:01:39 2016-01-19T07:29:37 2016-01-19T07:29:37 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 426 BOSWORTH ST, SAN FRANCISCO, CA, 94112 BOSWORTH ST 8 St. Mary's Park INGLESIDE 37.73323059082 -122.431297302246 POINT (-122.4312973 37.73323059) Integrated Agency   93 9 5 28 5 2 4 28,861 7 25 25   93   5             1         93
2456504 2456504 5398065 2015-12-23T02:22:19 2015-12-29T08:48:00 2015-12-29T08:48:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 190 BELGRAVE AVE, SAN FRANCISCO, CA, 94117 BELGRAVE AVE 5 Ashbury Heights PARK 37.759559631348 -122.45126342773399 POINT (-122.45126343 37.75955963) Integrated Agency   114 7 11 14 11 15 8 29,492 5 12 12   114   11             1         114
2496175 2496175 5642634 2016-03-07T20:27:09 2016-03-09T08:37:00 2016-03-09T08:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 2659 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Cow Hollow NORTHERN 37.798595428467 -122.445213317871 POINT (-122.44521332 37.79859543) Integrated Agency   14 4 6 13 1 13 6 57 9 17 17   14   6   21         1         14
2597576 2597576 6239698 2016-08-25T23:52:10 2016-08-27T15:25:32 2016-08-27T15:25:32 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1280 LOMBARD ST, SAN FRANCISCO, CA, 94109 LOMBARD ST 2 Russian Hill NORTHERN 37.80171585083 -122.422508239746 POINT (-122.42250824 37.80171585) Integrated Agency   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
2728630 2728630 6529865 2016-11-14T12:55:04 2016-11-15T11:31:09 2016-11-15T11:31:09 Closed 2 Should be routed to DPW-BSES DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 1818 CABRILLO ST, SAN FRANCISCO, CA, 94121 CABRILLO ST 1 Outer Richmond RICHMOND 37.774833679199 -122.478309631348 POINT (-122.47830963 37.77483368) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2737053 2737053 6480219 2016-10-31T13:40:08 2016-11-01T15:25:25 2016-11-01T15:25:25 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 2401 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.776245117188 -122.48448944091801 POINT (-122.48448944 37.77624512) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2740650 2740650 6479925 2016-10-31T12:53:44 2016-11-03T12:40:41 2016-11-03T12:40:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 600 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 1 Outer Richmond RICHMOND 37.778011322021 -122.484420776367 POINT (-122.48442078 37.77801132) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2770551 2770551 6479831 2016-10-31T12:39:05 2016-11-03T12:55:07 2016-11-03T12:55:07 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 636 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 1 Outer Richmond RICHMOND 37.777454376221 -122.48438262939501 POINT (-122.48438263 37.77745438) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2791442 2791442 6480216 2016-10-31T13:40:00 2016-12-16T12:15:19 2016-12-16T12:15:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 2449 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.776126861571996 -122.485244750977 POINT (-122.48524475 37.77612686) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2808537 2808537 6480220 2016-10-31T13:40:09 2016-12-16T11:55:12 2016-12-16T11:55:12 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 2401 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.776245117188 -122.48448944091801 POINT (-122.48448944 37.77624512) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
2827557 2827557 6631963 2016-12-15T13:44:57 2016-12-20T07:45:12 2016-12-20T07:45:12 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 60 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Buena Vista PARK 37.768119812012 -122.435859680176 POINT (-122.43585968 37.76811981) Integrated Agency   112 7 5 5 5 15 8 29,492 5 3 3   112   5             1         112

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