calls

80,878 rows where Category = 1 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
1341022 1341022 1012343 2011-11-28T16:05:15 2011-11-30T11:07:01 2011-11-30T11:07:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 37TH AVE and RIVERA ST 37TH AVE 4 Outer Sunset TARAVAL 37.745929718018 -122.495239257813 POINT (-122.49523926 37.74592972) Email   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
151 151 5704626 2016-03-27T16:23:04 2016-03-28T01:28:00 2016-03-28T01:28:00 Closed 2 nothing seen all clear DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 20TH ST and SHOTWELL ST 20TH ST 9 Mission MISSION 37.75883102417 -122.41577911376999 POINT (-122.41577911 37.75883102) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
6839 6839 11611964 2019-10-28T10:36:29 2019-10-28T10:22:54 2019-10-30T15:04:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CALIFORNIA ST and JOICE ST CALIFORNIA ST 3 Nob Hill CENTRAL 37.792140960693004 -122.408363342285 POINT (-122.40836334 37.79214096) Integrated Agency   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
11125 11125 11522242 2019-10-08T11:12:34   2019-10-08T12:50:21 Open 1 accepted DPW Ops Queue 1 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
11535 11535 5652662 2016-03-10T13:32:39 2016-03-17T09:17:07 2016-03-17T09:17:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
15328 15328 5670664 2016-03-16T10:42:15 2016-03-17T08:32:03 2016-03-17T08:32:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CLAYTON ST and PEMBERTON PL CLAYTON ST 8 Clarendon Heights PARK 37.758853912354 -122.446395874023 POINT (-122.44639587 37.75885391) Integrated Agency   47 7 5 5 5 15 8 28,862 5 3 3   47   5             1         47
17945 17945 11522241 2019-10-08T11:12:32 2019-10-09T08:14:00 2019-10-09T08:14:00 Closed 2   DPW Ops Queue 1 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
19133 19133 5659443 2016-03-12T17:37:50 2016-04-19T20:25:52 2016-04-19T20:25:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
19331 19331 5657697 2016-03-12T02:52:39 2016-03-26T10:27:00 2016-03-26T10:27:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 32 MUSEUM WAY, SAN FRANCISCO, CA, 94114 MUSEUM WAY 8 Corona Heights PARK 37.764839172363 -122.440879821777 POINT (-122.44087982 37.76483917) Integrated Agency   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
19343 19343 5657495 2016-03-11T20:22:49 2016-03-14T12:30:00 2016-03-14T12:30:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAKER ST and JEFFERSON ST BAKER ST 2 Marina NORTHERN 37.804218292236 -122.44709777831999 POINT (-122.44709778 37.80421829) Integrated Agency   17 4 6 13 1 13 6 57 9 17 17   17   6             1     15   17
19346 19346 5657456 2016-03-11T19:52:38 2016-03-15T01:56:00 2016-03-15T01:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BOSWORTH ST and ELK ST BOSWORTH ST 8 Glen Park INGLESIDE 37.734855651855 -122.43993377685499 POINT (-122.43993378 37.73485565) Integrated Agency   96 9 5 41 5 9 4 63 7 40 40   96   5             1     80   96
19349 19349 5657458 2016-03-11T19:52:40 2016-03-12T11:58:00 2016-03-12T11:58:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of OSHAUGHNESSY BLVD and WOODSIDE AVE OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.745532989502 -122.451622009277 POINT (-122.45162201 37.74553299) Integrated Agency   72 9 5 10 5 1 4 59 7 7 7   72   5             1         72
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
19847 19847 5652663 2016-03-10T13:32:40 2016-03-11T07:52:25 2016-03-11T07:52:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
20177 20177 5650341 2016-03-09T18:07:34 2016-03-10T12:00:00 2016-03-10T12:00:00 Closed 2 Request closed by SES . Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 3/10/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 847 DIAMOND ST, SAN FRANCISCO, CA, 94114 DIAMOND ST 8 Noe Valley MISSION 37.750514984130994 -122.43605804443399 POINT (-122.43605804 37.75051498) Integrated Agency   84 3 5 22 5 2 7 28,862 4 22 22   84   5             1         84
27854 27854 11529073 2019-10-09T16:23:52 2019-10-11T12:07:00 2019-10-11T12:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 22ND ST and POTRERO AVE 22ND ST 9 Mission MISSION 37.756168365479 -122.406639099121 POINT (-122.4066391 37.75616837) Integrated Agency   53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
32956 32956 11611478 2019-10-28T09:29:50 2019-10-29T16:19:29 2019-10-29T16:19:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
32957 32957 11611479 2019-10-28T09:29:53 2019-10-30T11:51:00 2019-10-30T11:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
35854 35854 11618899 2019-10-29T15:26:38 2019-10-29T14:57:47 2019-10-29T16:20:23 Closed 2 Gave the request over channel 6 spoke to Ricardo DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2998 SAN JOSE AVE, SAN FRANCISCO, CA, 94112 SAN JOSE AVE 11 Oceanview TARAVAL 37.711246490479 -122.455856323242 POINT (-122.45585632 37.71124649) Integrated Agency   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
43121 43121 11528868 2019-10-09T15:54:24 2019-10-10T08:30:00 2019-10-10T08:30:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 23RD ST and HOFFMAN AVE 23RD ST 8 Upper Market MISSION 37.752498626709 -122.440773010254 POINT (-122.44077301 37.75249863) Integrated Agency   51 3 5 22 5 2 7 28,862 4 22 22   51   5             1         51
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
106743 106743 2027920 2013-02-17T19:12:05 2018-04-19T09:42:38 2018-04-19T09:42:38 Closed 2 missing svc - NTR: 985372 DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 270 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 8 Mission Dolores MISSION 37.768505096436 -122.422431945801 POINT (-122.42243195 37.7685051) Integrated Agency   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
108325 108325 2068657 2013-02-28T07:01:30 2013-04-05T12:47:14 2013-04-05T12:47:14 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
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
118799 118799 4101236 2014-10-12T17:19:59 2017-07-06T14:40:31 2017-07-06T14:40:31 Closed 2 Should be routed to DPW-BSES This request came in to landscaping and the tree work should go to the Arborists. Can you have an inspector inspect the trees? Thanks Jada DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 620 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.727603912354 -122.47217559814501 POINT (-122.4721756 37.72760391) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
122551 122551 4628547 2015-04-01T17:52:53 2015-06-29T09:09:51 2015-06-29T09:09:51 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
123209 123209 4532160 2015-02-28T07:53:38 2015-06-10T09:47:00 2015-06-10T09:47:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 655 ELLIS ST, SAN FRANCISCO, CA, 94109 ELLIS ST 6 Tenderloin TENDERLOIN 37.784217834473 -122.41690063476601 POINT (-122.41690063 37.78421783) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36 17 20   10 18 15   18 6 1 2 1       20
127641 127641 5838588 2016-05-06T11:40:03 2016-08-12T14:40:19 2016-08-12T14:40:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of JUNIPERO SERRA BLVD and WOODACRE DR JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.733829498291 -122.47201538085899 POINT (-122.47201538 37.7338295) Integrated Agency   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
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
129019 129019 5637297 2016-03-06T10:54:38 2016-03-07T10:30:00 2016-03-07T10:30:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 15TH AVE and CABRILLO ST 15TH AVE 1 Inner Richmond RICHMOND 37.774929046630994 -122.473564147949 POINT (-122.47356415 37.77492905) Integrated Agency   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
129904 129904 5551786 2016-02-09T14:05:19 2016-02-11T10:23:00 2016-02-11T10:23:00 Closed 2 Case Resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of SUNSET BLVD and SANTIAGO ST SUNSET BLVD 4 Parkside TARAVAL 37.744091033936 -122.494575500488 POINT (-122.4945755 37.74409103) Integrated Agency   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
131055 131055 5444344 2016-01-08T07:35:06 2016-01-08T12:19:00 2016-01-08T12:19:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 199 CAPP ST, SAN FRANCISCO, CA, 94110 CAPP ST 9 Mission MISSION 37.763568878174 -122.41845703125 POINT (-122.41845703 37.76356888) Integrated Agency   53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3     53
131547 131547 5398066 2015-12-23T02:22:21 2016-01-02T08:13:52 2016-01-02T08:13:52 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LA PLAYA and LAWTON ST LA PLAYA 4 Outer Sunset TARAVAL 37.756549835205 -122.50890350341801 POINT (-122.5089035 37.75654984) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
131994 131994 4619246 2015-03-30T09:09:41 2016-04-11T17:47:25 2016-04-11T17:47:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MISSOURI ST and 16TH ST MISSOURI ST 10 Potrero Hill SOUTHERN 37.766429901123 -122.39689636230499 POINT (-122.39689636 37.7664299) Integrated Agency   54 1 9 4 8 14 3 28,856 3 20 20   54   9             1         54
132330 132330 1764854 2012-12-07T08:14:46 2016-04-11T05:04:26 2016-04-11T05:04:26 Closed 2 sent- nothing wrong DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 310 11TH AVE, SAN FRANCISCO, CA, 94118 11TH AVE 1 Inner Richmond RICHMOND 37.78246307373 -122.469680786133 POINT (-122.46968079 37.78246307) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
133234 133234 5395007 2015-12-22T07:20:03 2015-12-29T08:50:39 2015-12-29T08:50:39 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LAKE MERCED BLVD and BROTHERHOOD WAY LAKE MERCED BLVD 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
133444 133444 5368434 2015-12-12T11:09:20 2015-12-15T10:25:00 2015-12-15T10:25:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of WISCONSIN ST and 26TH ST WISCONSIN ST 10 Potrero Hill BAYVIEW 37.751052856445 -122.398338317871 POINT (-122.39833832 37.75105286) Integrated Agency   54 2 9 1 8 10 3 28,856 3 1 1   54   9             1         54
136246 136246 5084413 2015-09-10T11:26:34 2015-09-14T07:33:00 2015-09-14T07:33:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CHESTNUT ST and LARKIN ST CHESTNUT ST 2 Russian Hill CENTRAL 37.802696228027 -122.42147827148399 POINT (-122.42147827 37.80269623) Integrated Agency   107 6 6 32 1 5 6 28,858 9 32 32   107   6             1         107
137215 137215 4980797 2015-08-09T12:53:21 2015-08-14T09:24:00 2015-08-14T09:24:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAY SHORE BLVD and ARLETA AVE BAY SHORE BLVD 10 Little Hollywood INGLESIDE 37.712181091309 -122.40245819091801 POINT (-122.40245819 37.71218109) Integrated Agency   75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
137752 137752 4932231 2015-07-22T20:38:06 2015-08-04T01:55:29 2015-08-04T01:55:29 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
138639 138639 4856308 2015-06-25T23:37:23 2015-07-01T08:15:00 2015-07-01T08:15:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 3384 16TH ST, SAN FRANCISCO, CA, 94114 16TH ST 8 Mission Dolores MISSION 37.764659881592 -122.42823028564501 POINT (-122.42823029 37.76465988) Integrated Agency   37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
141162 141162 4641225 2015-04-06T13:53:24 2015-04-07T06:27:00 2015-04-07T06:27:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of KEITH ST and EVANS AVE KEITH ST 10 Bayview BAYVIEW 37.738761901855 -122.38094329834 POINT (-122.3809433 37.7387619) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
142090 142090 4554475 2015-03-07T13:39:35 2015-03-13T08:03:00 2015-03-13T08:03:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1745 YOSEMITE AVE, SAN FRANCISCO, CA, 94124 YOSEMITE AVE 10 Bayview BAYVIEW 37.728225708008 -122.39440155029301 POINT (-122.39440155 37.72822571) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
143232 143232 4477703 2015-02-10T00:37:42 2015-02-10T10:30:52 2015-02-10T10:30:52 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1889 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Haight Ashbury PARK 37.771362304688 -122.450302124023 POINT (-122.45030212 37.7713623) Integrated Agency   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
143242 143242 4476223 2015-02-09T14:56:38 2015-03-09T04:16:00 2015-03-09T04:16:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 3RD ST and BANCROFT AVE 3RD ST 10 Bayview BAYVIEW 37.726238250732 -122.393905639648 POINT (-122.39390564 37.72623825) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
143278 143278 4473507 2015-02-08T22:22:51 2015-02-13T09:20:00 2015-02-13T09:20:00 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of POTRERO AVE and 25TH ST POTRERO AVE 10 Potrero Hill MISSION 37.751365661621 -122.40618896484399 POINT (-122.40618896 37.75136566) Integrated Agency   53 3 2 20 7 10 7 28,859 4 19 19 23 53   2 10   3 10     1   3     53
143457 143457 4467596 2015-02-06T17:16:18 2015-02-17T11:56:59 2015-02-17T11:56:59 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of VISITACION AVE and MANSELL ST VISITACION AVE 10 McLaren Park INGLESIDE 37.718753814696996 -122.411674499512 POINT (-122.4116745 37.71875381) Integrated Agency   73 9 9 19 8 9 4 309 7 18 18   73   9             2         73
143459 143459 4467599 2015-02-06T17:16:28 2015-02-28T10:44:57 2015-02-28T10:44:57 Closed 2 cancelled: DPW Ops Queue 1 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
143480 143480 4466410 2015-02-06T13:30:25 2015-02-09T09:53:26 2015-02-09T09:53:26 Closed 2 resolved: Completed, Niu DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
144937 144937 4346623 2014-12-30T13:34:16 2015-01-06T08:24:26 2015-01-06T08:24:26 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and MCALLISTER ST DIVISADERO ST 5 Western Addition NORTHERN 37.777793884277 -122.43836212158199 POINT (-122.43836212 37.77779388) Integrated Agency   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
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
495932 495932 5351445 2015-12-07T08:29:37 2015-12-08T05:56:18 2015-12-08T05:56:18 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
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
1226842 1226842 1132840 2012-05-27T19:30:18   2012-05-27T19:30:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 883 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Russian Hill CENTRAL 37.800682067871 -122.413902282715 POINT (-122.41390228 37.80068207) Integrated Agency   107 6 3 32 10 3 1 308 1 32 32   107   3             1         107
1228260 1228260 1130318 2012-05-23T14:00:51 2012-06-08T08:11:15 2012-06-08T08:11:15 Closed 2 resolved: Maximo Work Order has been completed Ck OFV, possible tree rootsOFV possible tree roots (Source: OPS) Unable to locate ofv in area - need correct address. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 2ND ST and HARRISON ST 2ND ST 6 Rincon Hill SOUTHERN 37.784309387206996 -122.395164489746 POINT (-122.39516449 37.78430939) Integrated Agency   32 1 10 8 9 6 2 28,856 2 6 6   32   10         3   1         32
1232239 1232239 1122626 2012-05-11T19:00:15 2012-11-16T12:00:00 2012-11-16T12:00:00 Closed 2 resolved: Damaged asw due to private tree. Root damaged asw due to City maintained trees. Missing sewer vent cover. Damaged utility vault frame. - NTR # 974017,X1104 # 974019,X1104 # 974020, DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 4950 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 11 Cayuga INGLESIDE 37.719589233398 -122.438842773438 POINT (-122.43884277 37.71958923) Integrated Agency   80 9 1 28 6 9 4 28,861 7 25 25 4 80   1 4 3   4     2         80
1235938 1235938 1132698 2012-05-27T13:45:13 2012-06-13T08:18:48 2012-06-13T08:18:48 Closed 2 resolved: Maximo Work Order has been completed sinkhole formingnot sewer related, temp. asphalt while constrution crew is working DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 24TH ST and MISSION ST 24TH ST 9 Mission MISSION 37.752239227295 -122.418441772461 POINT (-122.41844177 37.75223923) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3 51   53
1237991 1237991 1124466 2012-05-15T06:30:26   2012-05-15T07:30:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1650 GREAT HWY, SAN FRANCISCO, CA, 94122 GREAT HWY 4 Outer Sunset TARAVAL 37.755577087402 -122.508644104004 POINT (-122.5086441 37.75557709) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1241158 1241158 1126475 2012-05-17T19:30:15 2012-06-05T08:30:52 2012-06-05T08:30:52 Closed 2 resolved: Maximo Work Order has been completed relieved s/s DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1300 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition NORTHERN 37.778610229492 -122.43361663818399 POINT (-122.43361664 37.77861023) Integrated Agency   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
1244714 1244714 1136663 2012-06-01T14:45:14 2012-06-05T04:36:57 2012-06-05T04:36:57 Closed 2 resolved: Need a more specific location description. - MD - Need a more specific location description. - MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 24TH ST and POTRERO AVE 24TH ST 9 Potrero Hill MISSION 37.753002166748 -122.40633392334 POINT (-122.40633392 37.75300217) Integrated Agency   54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10   3 10     1   3     54
1245274 1245274 1137278 2012-06-02T13:15:23   2012-06-02T13:15:24 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 93 ROCKAWAY AVE, SAN FRANCISCO, CA, 94127 ROCKAWAY AVE 7 Laguna Honda TARAVAL 37.743671417236 -122.458984375 POINT (-122.45898438 37.74367142) Integrated Agency   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
1245415 1245415 1123248 2012-05-13T09:45:11 2012-05-21T04:37:55 2012-05-21T04:37:55 Closed 2 resolved: insufficient info to process request - insufficient info to process request DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 271 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 Chinatown CENTRAL 37.797622680664 -122.40655517578101 POINT (-122.40655518 37.79762268) Integrated Agency   104 6 3 6 10 3 1 308 1 4 4 21 104   3 23 17   23     2         104
1250225 1250225 1122130 2012-05-11T09:30:12   2014-06-04T08:18:00 Open 1 scheduled DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LAGUNA ST and MARKET ST LAGUNA ST 8 Mint Hill SOUTHERN 37.770748138428004 -122.424850463867 POINT (-122.42485046 37.77074814) Integrated Agency   27 1 5 20 5 7 2 28,853 2 19 19   27   5         9   2         27
1252038 1252038 1128204 2012-05-21T09:00:14 2012-06-25T20:02:03 2012-06-25T20:02:03 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 3RD ST and MISSION ST 3RD ST 6 South of Market SOUTHERN 37.786247253418004 -122.40202331543001 POINT (-122.40202332 37.78624725) Integrated Agency   32 1 10 8 9 12 2 28,853 2 6 6   32   10         4   1         32
1252744 1252744 1129817 2012-05-23T03:15:16   2012-05-23T03:15:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GREAT HWY and SLOAT BLVD GREAT HWY 4 Parkside TARAVAL 37.735572814941 -122.506134033203 POINT (-122.50613403 37.73557281) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1252933 1252933 1122604 2012-05-11T18:15:14 2012-05-24T11:37:47 2012-05-24T11:37:47 Closed 2 resolved: Maximo Work Order has been completed lost item in cb, unable to locatelost item in c/b. Unable to locate Officer or item in c/b, went to tender loin police station, will call back PUC Sewer Ops 27 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ELLIS ST and JONES ST ELLIS ST 6 Tenderloin TENDERLOIN 37.784866333008 -122.41278076171899 POINT (-122.41278076 37.78486633) Integrated Agency   20 5 10 36 9 7 10 28,852 10 36 36 17 20   10 18     18 6 1 2 1       20
1254353 1254353 1137598 2012-06-03T07:45:14 2012-06-12T04:33:38 2012-06-12T04:33:38 Closed 2 resolved: 6-8-12: Already inspected, refer to RFA # 21100992, NTR # 972676, 4-13-12 - 6-8-12: Already inspected, refer to RFA # 21100992, NTR # 972676, 4-13-12 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1014 CLEMENT ST, SAN FRANCISCO, CA, 94118 CLEMENT ST 1 Inner Richmond RICHMOND 37.782806396484 -122.47015380859399 POINT (-122.47015381 37.7828064) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1256985 1256985 1122962 2012-05-12T14:15:18 2012-05-30T14:01:44 2012-05-30T14:01:44 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 27TH AVE and CLEMENT ST 27TH AVE 1 Outer Richmond RICHMOND 37.781925201416 -122.487022399902 POINT (-122.4870224 37.7819252) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
1258463 1258463 1127478 2012-05-19T12:15:14 2012-05-31T09:49:18 2012-05-31T09:49:18 Closed 2 resolved: Maximo Work Order has been completed blockage on their side, flush lateral to mslateral blockage is on their side. I flushed lateral to m/s. Talked with owner DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1411 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Bayview BAYVIEW 37.731895446777 -122.38752746581999 POINT (-122.38752747 37.73189545) Integrated Agency   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1259212 1259212 1139090 2012-06-05T10:01:09   2012-06-05T12:30:36 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CYRIL MAGNIN ST and MARKET ST CYRIL MAGNIN ST 6 Downtown / Union Square TENDERLOIN 37.783992767334 -122.408065795898 POINT (-122.4080658 37.78399277) Integrated Agency   19 5 10 34 9 12 2 28,853 2 34 34 17 19 1 10 18     18 7 1 2 1   35   19
1259402 1259402 1122325 2012-05-11T12:45:15 2012-05-16T10:30:51 2012-05-16T10:30:51 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 690 SUTTER ST, SAN FRANCISCO, CA, 94108 SUTTER ST 3 Lower Nob Hill CENTRAL 37.788944244385 -122.411674499512 POINT (-122.4116745 37.78894424) Integrated Agency   50 6 3 21 10 5 1 28,857 1 21 21   50   3             2         50
1261285 1261285 1123411 2012-05-13T12:30:14 2012-05-23T16:50:45 2012-05-23T16:50:45 Closed 2 resolved: Maximo Work Order has been completed trap pack w/grease, flush lateralck lateral m/s (Source: Dispatch) trap was packed with grease apon arrival, I flushed lateral clear to m/s, City side running PUC Sewer Ops 27 Tree Maintenance 1 Trees - Tree_Other 4 Other 328 2ND AVE, SAN FRANCISCO, CA, 94118 2ND AVE 1 Inner Richmond RICHMOND 37.782566070556996 -122.460029602051 POINT (-122.4600296 37.78256607) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1264376 1264376 1134195 2012-05-29T20:15:15 2012-07-11T04:35:48 2012-07-11T04:35:48 Closed 2 resolved: This location has been USA'ed prior to this inspection. - Photo taken. DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 2001 LYON ST, SAN FRANCISCO, CA, 94115 LYON ST 2 Presidio Heights RICHMOND 37.789367675781 -122.445922851563 POINT (-122.44592285 37.78936768) Integrated Agency   10 8 6 31 1 13 9 29,490 6 31 31   10   6             1         10
1264417 1264417 1126326 2012-05-17T15:45:13 2012-05-18T09:54:56 2012-05-18T09:54:56 Closed 2 resolved: Maximo Work Order has been completed pg@e 12''cover missing,made safe with mc3pg@e 12''cover missing made safe with mc3. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 450 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Mission Dolores MISSION 37.764343261719 -122.429054260254 POINT (-122.42905426 37.76434326) Integrated Agency   37 3 5 5 5 8 7 28,862 4 3 3   37   5       1     1   5     37
1267470 1267470 1137623 2012-06-03T09:00:13 2012-06-14T16:11:51 2012-06-14T16:11:51 Closed 2 resolved: Maximo Work Order has been completed flush & relieve lateral, already mkd for d/u(Called in address: 341 Arkansas) Flushed & relieved lateral, unable to get to m/s, already marked for a dig up DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 341 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.761878967285 -122.398223876953 POINT (-122.39822388 37.76187897) Integrated Agency   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "calls" (
"rowid" INTEGER,
  "CaseID" INTEGER,
  "Opened" TEXT,
  "Closed" REAL,
  "Updated" TEXT,
  "Status" INTEGER,
  "Status_Notes" TEXT,
  "Responsible_Agency" INTEGER,
  "Category" INTEGER,
  "Request_Type" INTEGER,
  "Request_Details" TEXT,
  "Address" TEXT,
  "Street" TEXT,
  "Supervisor_District" INTEGER,
  "Neighborhood" TEXT,
  "Police_District" TEXT,
  "Latitude" REAL,
  "Longitude" REAL,
  "Point" TEXT,
  "Source" TEXT,
  "Media_URL" TEXT,
  "SF_Find_Neighborhoods" INTEGER,
  "Current_Police_Districts" INTEGER,
  "Current_Supervisor_Districts" INTEGER,
  "Analysis_Neighborhoods" INTEGER,
  ":@computed_region_rxqg_mtj9" INTEGER,
  ":@computed_region_yftq_j783" INTEGER,
  ":@computed_region_jx4q_fizf" INTEGER,
  ":@computed_region_bh8s_q3mv" TEXT,
  ":@computed_region_p5aj_wyqh" INTEGER,
  ":@computed_region_fyvs_ahh9" INTEGER,
  ":@computed_region_f58d_8dbm" INTEGER,
  ":@computed_region_9dfj_4gjx" INTEGER,
  ":@computed_region_vtsz_7cme" INTEGER,
  ":@computed_region_n4xg_c4py" INTEGER,
  ":@computed_region_sruu_94in" INTEGER,
  ":@computed_region_4isq_27mq" INTEGER,
  ":@computed_region_viu7_rrfi" INTEGER,
  ":@computed_region_fcz8_est8" INTEGER,
  ":@computed_region_pigm_ib2e" INTEGER,
  ":@computed_region_9jxd_iqea" INTEGER,
  ":@computed_region_6ezc_tdp2" INTEGER,
  ":@computed_region_6pnf_4xz7" INTEGER,
  ":@computed_region_h4ep_8xdi" INTEGER,
  ":@computed_region_nqbw_i6c3" INTEGER,
  ":@computed_region_2dwj_jsy4" INTEGER,
  ":@computed_region_y6ts_4iup" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("Status") REFERENCES [Status](id),
    FOREIGN KEY ("Responsible_Agency") REFERENCES [Responsible_Agency](id),
    FOREIGN KEY ("Category") REFERENCES [Category](id),
    FOREIGN KEY ("Request_Type") REFERENCES [Request_Type](id))
Powered by Datasette · Query took 70.207ms