calls

2,192 rows where Responsible_Agency = 3

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
419 419 5695378 2016-03-24T09:26:26 2016-11-10T01:25:10 2016-11-10T01:25:10 Closed 2 1215 Fairfax Ave: Int. of Keith St. and Bowman Ct near curb ramp: overgrown ivy blocking pedestrian path 8/1616: some trimming done. NEED more trimming of ivy on the other side of the fence. IV - NTR: 1068063 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BOWMAN CT and KEITH ST BOWMAN CT 10 Bayview BAYVIEW 37.73776880012 -122.38179734416401 POINT (-122.38179734 37.7377688) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7882 7882 6867227 2017-02-22T10:33:40 2019-10-07T10:37:19 2019-10-07T10:37:19 Closed 2 No conditions found - No Action Required DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 118 TARAVAL ST, SAN FRANCISCO, CA, 94116 TARAVAL ST 7 Forest Hill TARAVAL 37.743646986545 -122.466427348312 POINT (-122.46642735 37.74364699) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
8305 8305 11394197 2019-09-10T08:28:00   2019-10-09T06:10:24 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MIDDLE POINT RD and INNES AVE MIDDLE POINT RD 10 Hunters Point BAYVIEW 37.734081268311 -122.379432678223 POINT (-122.37943268 37.73408127) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
14981 14981 10531082 2019-02-25T10:14:00 2019-10-08T00:00:00 2019-10-08T00:00:00 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 4530 20TH ST, SAN FRANCISCO, CA, 94114 20TH ST 8 Eureka Valley MISSION 37.757553100586 -122.43862915039101 POINT (-122.43862915 37.7575531) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
20693 20693 11383528 2019-09-07T17:08:00   2019-10-10T01:30:27 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 900 POWHATTAN AVE, SAN FRANCISCO, CA, 94110 POWHATTAN AVE 9 Bernal Heights INGLESIDE 37.741302490234 -122.411064147949 POINT (-122.41106415 37.74130249) Phone http://mobile311.sfgov.org/reports/11383528/photos 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
25567 25567 11595048 2019-10-24T10:08:00 2019-10-29T11:27:03 2019-10-30T00:00:00 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 80 THOR AVE, SAN FRANCISCO, CA, 94131 THOR AVE 8 Glen Park INGLESIDE 37.734819705998994 -122.434214153773 POINT (-122.43421415 37.73481971) Mobile/Open311 http://mobile311.sfgov.org/reports/11595048/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
41046 41046 11419449 2019-09-15T15:49:00   2019-10-09T06:10:20 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 1425 17TH ST, SAN FRANCISCO, CA, 94107 17TH ST 10 Potrero Hill SOUTHERN 37.765003333333 -122.398361666667 POINT (-122.39836167 37.76500333) Mobile/Open311 http://mobile311.sfgov.org/reports/11419449/photos 54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
58510 58510 11410285 2019-09-13T09:44:00   2019-10-13T06:10:38 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 3RD ST and FITZGERALD AVE 3RD ST 10 Bayview BAYVIEW 37.723220825195 -122.395263671875 POINT (-122.39526367 37.72322083) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
60938 60938 11411779 2019-09-13T13:49:00 2019-10-15T09:12:36 2019-10-15T09:12:36 Closed 2 10/11/19 Duplicate of RFA #21365707. lz - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 625 BAY SHORE BLVD, SAN FRANCISCO, CA, 94124 BAY SHORE BLVD 10 Apparel City BAYVIEW 37.737045288086 -122.406593322754 POINT (-122.40659332 37.73704529) Phone   82 2 9 1 8 10 3 58 3 1 1   82   9             2         82
64890 64890 11398610 2019-09-10T22:26:00   2019-10-16T06:10:34 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1001 WISCONSIN ST, SAN FRANCISCO, CA, 94107 WISCONSIN ST 10 Potrero Hill BAYVIEW 37.753601074219 -122.397003173828 POINT (-122.39700317 37.75360107) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
70906 70906 11309243 2019-08-22T14:53:00   2019-10-01T11:49:08 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of PINK ALY and PEARL ST PINK ALY 8 Mint Hill SOUTHERN 37.770660400391 -122.42390441894501 POINT (-122.42390442 37.7706604) Phone   27 1 5 20 5 8 2 28,853 2 19 19   27   5             2         27
72754 72754 11306386 2019-08-22T07:09:00 2019-10-03T00:00:00 2019-10-03T00:00:00 Closed 2 overgrown vegetation - NTR # 1179331, DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 33 POND ST, SAN FRANCISCO, CA, 94114 POND ST 8 Castro MISSION 37.763717651367 -122.43212890625 POINT (-122.43212891 37.76371765) Phone http://mobile311.sfgov.org/reports/11306386/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5       1     1   5     38
76117 76117 11206975 2019-07-31T14:17:00 2019-10-17T12:20:00 2019-10-17T12:20:00 Closed 2 overgrown vegetation - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 265 CASITAS AVE, SAN FRANCISCO, CA, 94127 CASITAS AVE 7 Sherwood Forest INGLESIDE 37.73607635498 -122.459770202637 POINT (-122.4597702 37.73607635) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
76162 76162 11400701 2019-09-11T11:22:00 2019-10-17T00:00:00 2019-10-17T00:00:00 Closed 2 No conditions found - NTR: 1181311 NTR: 1181860No Action Required DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 390 SANTA ANA AVE, SAN FRANCISCO, CA, 94127 SANTA ANA AVE 7 Balboa Terrace TARAVAL 37.729904174805 -122.46851348876999 POINT (-122.46851349 37.72990417) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
81713 81713 11400497 2019-09-11T10:53:00 2019-10-08T00:00:00 2019-10-08T00:00:00 Closed 2 condition not found - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 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) Phone   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
82258 82258 11467467 2019-09-26T08:00:00   2019-10-08T01:15:33 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3550 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Clarendon Heights MISSION 37.756381988525 -122.44176483154301 POINT (-122.44176483 37.75638199) Phone   47 7 5 38 5 2 8 28,862 5 38 38   47   5             1         47
87740 87740 11403436 2019-09-11T19:11:00 2019-10-16T00:00:00 2019-10-16T00:00:00 Closed 2 Overgrown vegetation in over the retaining wall the house could be on Corbett - NTR # 1181489, DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 3750 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754199981689 -122.44219970703101 POINT (-122.44219971 37.75419998) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
87752 87752 11408112 2019-09-12T17:27:00 2019-10-08T00:00:00 2019-10-08T00:00:00 Closed 2 4 ft path of travel is clear.kjNo conditions found - No Action Required DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of BEVERLY ST and HOLLOWAY AVE BEVERLY ST 7 Ingleside Terraces TARAVAL 37.721630096436 -122.47167205810499 POINT (-122.47167206 37.7216301) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
98769 98769 9617038 2018-10-02T12:49:00 2019-01-24T22:00:11 2019-01-24T22:00:11 Closed 2 Closed: No response from BSM in 1 month DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 205 MULLEN AVE, SAN FRANCISCO, CA, 94110 MULLEN AVE 9 Peralta Heights INGLESIDE 37.746601104736 -122.407989501953 POINT (-122.4079895 37.7466011) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
99909 99909 9504208 2018-09-06T12:36:00 2019-01-25T00:00:00 2019-01-25T00:00:00 Closed 2 sunken sidewalk around utility vault, damaged sidewalk, missing svc - X1104: 1141157 NTR: 1141158 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 164 SAN CARLOS ST, SAN FRANCISCO, CA, 94110 SAN CARLOS ST 9 Mission MISSION 37.760753631592 -122.420112609863 POINT (-122.42011261 37.76075363) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
100106 100106 9475555 2018-08-30T14:20:00 2019-01-23T00:00:00 2019-01-23T00:00:00 Closed 2 Center median dry need irrigation from market and Dolores to San Jose and Dolores - X1104: 1138766 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of DOLORES ST and MARKET ST DOLORES ST 8 Mission Dolores MISSION 37.76904296875 -122.426856994629 POINT (-122.42685699 37.76904297) Phone   37 3 5 20 5 8 7 28,862 4 19 19   37   5     5   9   2   5     37
101943 101943 7165401 2017-05-19T06:33:36 2019-02-04T00:00:00 2019-02-04T00:00:00 Closed 2 No Action Described DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 40 WOODACRE DR, SAN FRANCISCO, CA, 94132 WOODACRE DR 7 Merced Manor TARAVAL 37.732861421509 -122.472730883232 POINT (-122.47273088 37.73286142) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
102104 102104 4438081 2015-01-28T16:27:06 2019-04-10T08:57:03 2019-04-10T08:57:03 Closed 2 Cargo Way: lifted sw one location, overgrown weeds. 3rd St: lifted sw 5 locations, missing tree. Burke Ave: sw in good repair. This location included in reported area of RFA 21258432 - Emailed copy of RFA to Fady Khoury to determine course of action to take. X1104# 1163693 DPW Tree - 1590 Burke Ave & 3521 3rd St X1104# 1163707 DPW Trees - 3343 3rd St & Cargo Way DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 3RD ST and BURKE AVE 3RD ST 10 Central Waterfront BAYVIEW 37.745069965618 -122.387129629514 POINT (-122.38712963 37.74506997) Phone   56 2 9 1 8 10 3 58 3 1 1   56   9             1         56
106595 106595 11296344 2019-08-20T08:40:00   2019-09-13T01:15:23 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 19TH AVE and WINSTON DR 19TH AVE 7 Stonestown TARAVAL 37.726989746094 -122.474899291992 POINT (-122.47489929 37.72698975) Phone   41 10 8 16 4 9 5 64 8 14 14   41   8             2         41
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
116442 116442 6796860 2017-02-01T15:38:05 2017-06-16T11:25:41 2017-06-16T11:25:41 Closed 2 transferred. but determined privately maintained. real estate dept. DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of UTAH ST and 24TH ST UTAH ST 10 Potrero Hill MISSION 37.753061747527 -122.405333129912 POINT (-122.40533313 37.75306175) Phone   54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
131918 131918 4819460 2015-06-11T11:26:47 2016-10-18T06:28:16 2016-10-18T06:28:16 Closed 2 717 Holly Park Cir: sections of bush slightly extending over sidewalk - NTR: 1038321 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of APPLETON AVE and HOLLY PARK CIR APPLETON AVE 9 Holly Park INGLESIDE 37.73755 -122.42112 POINT (-122.42112 37.73755) Mobile/Open311 http://mobile311.sfgov.org/reports/4819460/photos 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
132193 132193 4085803 2014-10-07T17:07:11 2016-04-28T03:12:00 2016-04-28T03:12:00 Closed 2 2285-2345 Jerrold Ave: Barneveld Ave: uprooted sidewalk - NTR: 1018405 4/28/16 Work has been completed. I will close out. Refer to the most recent photo uploaded from Google Maps (dated: 6/2015). -LL DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 125 BARNEVELD AVE, SAN FRANCISCO, CA, 94124 BARNEVELD AVE 10 Produce Market BAYVIEW 37.745956947646 -122.40269136879 POINT (-122.40269137 37.74595695) Phone   85 2 9 1 8 10 3 58 3 1 1   85   9             1         85
132296 132296 1959716 2013-01-31T11:57:58 2016-10-08T05:12:11 2016-10-08T05:12:11 Closed 2 Raised and lifted sidewalk fronting 142 & 148 ChiltonChilton - met with p.o., of 148. P.O., very upset with neighbors tree damaging his sidewalk. Gave him phone # to contact BUF. DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 142 CHILTON AVE, SAN FRANCISCO, CA, 94131 CHILTON AVE 8 Glen Park INGLESIDE 37.733455657959 -122.436965942383 POINT (-122.43696594 37.73345566) Phone   96 9 5 41 5 9 4 63 7 40 40   96   5             1         96
132299 132299 1974031 2013-02-04T09:36:11 2016-01-12T10:47:00 2016-01-12T10:47:00 Closed 2 resolved: raised damaged sidewalk from free roots - Posted Residence NTR: 985135 DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 236 DAY ST, SAN FRANCISCO, CA, 94131 DAY ST 8 Noe Valley INGLESIDE 37.743087768555 -122.427505493164 POINT (-122.42750549 37.74308777) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
132519 132519 922607 2011-07-18T13:44:07 2016-10-07T01:13:52 2016-10-07T01:13:52 Closed 2 OVER GROWN VEGETATION, near pole. - posted, took photos;NTR # 961782, DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
135828 135828 5117185 2015-09-21T14:37:13 2015-10-01T12:00:00 2015-10-01T12:00:00 Closed 2 resolved: Found overgrown tree. - Contacted Steve from BUF to notify appropriate party. DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 138 ORD ST, SAN FRANCISCO, CA, 94114 ORD ST 8 Eureka Valley PARK 37.761463165283 -122.440254211426 POINT (-122.44025421 37.76146317) Web   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
143249 143249 6212100 2016-08-18T17:31:13 2018-12-07T00:00:00 2018-12-07T00:00:00 Closed 2 weeds on sidewalk has reported. - NTR: 1075060, sent 9.7.16 (AD) DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 4321 24TH ST, SAN FRANCISCO, CA, 94114 24TH ST 8 Upper Market MISSION 37.750852594935004 -122.439387705448 POINT (-122.43938771 37.75085259) Phone   51 3 5 22 5 2 7 28,862 4 22 22   51   5             1         51
147294 147294 3905621 2014-08-10T21:44:32 2018-08-14T00:00:00 2018-08-14T00:00:00 Closed 2 Overgrown vegetation blocking sidewalk path of travel - Send notice to owner NTR # 1013993, DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 1000 MORAGA ST, SAN FRANCISCO, CA, 94122 MORAGA ST 7 Golden Gate Heights TARAVAL 37.756351470946996 -122.47386932373001 POINT (-122.47386932 37.75635147) Web   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
147870 147870 2695859 2013-08-09T11:24:28 2014-02-09T05:12:19 2014-02-09T05:12:19 Closed 2 resolved: Found 500 square feet of damaged/uneven sidewalk. - NTR # 993818, DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
154704 154704 9283226 2018-07-18T11:10:00 2018-08-03T00:00:00 2018-08-03T00:00:00 Closed 2 condition fine - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GLENDALE ST and MARKET ST GLENDALE ST 8 Clarendon Heights MISSION 37.756637573242 -122.442222595215 POINT (-122.4422226 37.75663757) Phone   47 3 5 5 5 2 7 28,862 4 3 3   47   5             1         47
163626 163626 2275107 2013-04-22T15:03:51 2017-02-16T01:14:32 2017-02-16T01:14:32 Closed 2 Overgrown tree obscuring sign overgrown Bush entering through zone - NTR: 988616 DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 23 MELROSE AVE, SAN FRANCISCO, CA, 94131 MELROSE AVE 7 Sunnyside INGLESIDE 37.733707427979 -122.44260406494101 POINT (-122.44260406 37.73370743) Web   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
163760 163760 3093816 2013-11-22T12:25:11 2017-01-07T06:41:08 2017-01-07T06:41:08 Closed 2 Overgrown tree blocking city parking sign - posted resident NTR: 998489 DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 611 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Bernal Heights INGLESIDE 37.746014215408 -122.421508096551 POINT (-122.4215081 37.74601422) Phone   83 9 5 2 5 2 4 28,859 7 2 2   83   5             1         83
163813 163813 2490855 2013-06-14T14:44:59 2017-01-06T01:11:38 2017-01-06T01:11:38 Closed 2 Root damaged asw - NTR: 991045 DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 424 BRYANT ST, SAN FRANCISCO, CA, 94107 BRYANT ST 6 South of Market SOUTHERN 37.782676696777 -122.39440155029301 POINT (-122.39440155 37.7826767) Twitter   32 1 10 8 9 6 2 28,856 2 6 6   32   10             1         32
163816 163816 3126203 2013-12-03T12:06:32 2017-02-12T05:11:48 2017-02-12T05:11:48 Closed 2 Found overgrown vegetation. - NTR # 998419, DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 678 12TH AVE, SAN FRANCISCO, CA, 94118 12TH AVE 1 Inner Richmond RICHMOND 37.775491576155 -122.470260546034 POINT (-122.47026055 37.77549158) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
163990 163990 3022404 2013-11-03T17:55:59 2017-02-10T06:00:15 2017-02-10T06:00:15 Closed 2 root damaged asw,low tree branches - NTR: 997178 DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 143 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Mission MISSION 37.752471923828004 -122.421417236328 POINT (-122.42141724 37.75247192) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
164039 164039 2505388 2013-06-18T14:39:39 2017-02-22T01:18:10 2017-02-22T01:18:10 Closed 2 Duplicate Complaint / Generic 21289814 - Entered By: Leah Lintz on 2/16/2017 4:42:02 PM 145 SOUTH VAN NESS AVE Zip: 94103 Root damaged asw and regular damage.Complaint / Generic 21128078 - - X1104: 991208 9/14/16 No work done.JP 2/17/17 No work done.JP DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 145 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 6 South of Market SOUTHERN 37.771190643311 -122.417770385742 POINT (-122.41777039 37.77119064) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2 1 1     32
168157 168157 9128600 2018-06-12T16:37:00 2019-04-23T09:29:00 2019-04-23T09:29:00 Closed 2 Damaged sidewalk around utility vaults, damaged sidewalk. - X1104: 1130287 X1104: 1130289 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1815 EGBERT AVE, SAN FRANCISCO, CA, 94124 EGBERT AVE 10 Bayview BAYVIEW 37.726066589355 -122.399185180664 POINT (-122.39918518 37.72606659) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
171897 171897 9121265 2018-06-11T10:43:00 2018-09-20T00:00:00 2018-09-20T00:00:00 Closed 2 No obstructions to traffic or pedestrians found due to vine. - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 30 ZIRCON PL, SAN FRANCISCO, CA, 94131 ZIRCON PL 8 Fairmount INGLESIDE 37.742959899999995 -122.434702 POINT (-122.434702 37.7429599) Web   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
172950 172950 9197621 2018-06-28T10:35:00 2018-08-03T00:00:00 2018-08-03T00:00:00 Closed 2 weeds in railroad. not pedestrian access - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 21ST ST and CHATTANOOGA ST 21ST ST 8 Dolores Heights MISSION 37.756561279296996 -122.426788330078 POINT (-122.42678833 37.75656128) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
176977 176977 9267789 2018-07-14T21:13:00 2018-11-01T10:09:00 2018-11-01T10:09:00 Closed 2 overgrown Hedges blocking sidewalk path of travel - NTR: 1134917 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 22 ROBBLEE AVE, SAN FRANCISCO, CA, 94124 ROBBLEE AVE 10 Silver Terrace BAYVIEW 37.735920674251 -122.39888886127198 POINT (-122.39888886 37.73592067) Mobile/Open311 http://mobile311.sfgov.org/reports/9267789/photos 87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
178567 178567 9073663 2018-05-31T08:33:00 2018-09-10T00:00:00 2018-09-10T00:00:00 Closed 2 Condition not found - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GOLD MINE DR and ADDISON ST GOLD MINE DR 8 Diamond Heights INGLESIDE 37.740154266357 -122.435836791992 POINT (-122.43583679 37.74015427) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
181471 181471 9141822 2018-06-15T13:07:00 2018-06-25T22:00:15 2018-06-25T22:00:15 Closed 2 Closed: No response from BSM in 1 month DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 574 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.759735467879 -122.435065303112 POINT (-122.4350653 37.75973547) Mobile/Open311 http://mobile311.sfgov.org/reports/9141822/photos 38 3 5 5 5 2 7 28,862 4 3 3 1 38   5 1 12     9   1   5     38
208306 208306 9248962 2018-07-10T14:49:00 2018-08-22T00:00:00 2018-08-22T00:00:00 Closed 2 Bushes trimmed. - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 96 MANOR DR, SAN FRANCISCO, CA, 94127 MANOR DR 7 Mt. Davidson Manor TARAVAL 37.728055771475 -122.463820846865 POINT (-122.46382085 37.72805577) Mobile/Open311 http://mobile311.sfgov.org/reports/9248962/photos 68 10 8 41 4 9 5 59 8 40 40   68   8             1         68
209356 209356 9266799 2018-07-14T14:33:00 2018-07-20T00:00:00 2018-07-20T00:00:00 Closed 2 Condition not found as described in RFA - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 700 VICTORIA ST, SAN FRANCISCO, CA, 94127 VICTORIA ST 7 Ingleside Terraces TARAVAL 37.723358154296996 -122.46436309814501 POINT (-122.4643631 37.72335815) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
214180 214180 9323091 2018-07-27T09:10:00 2018-09-11T00:00:00 2018-09-11T00:00:00 Closed 2 Multiple locations ( 6 blocks) provided for inspection, a more specific location is needed. - DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of MANSELL ST and HAMILTON ST MANSELL ST 9 Portola BAYVIEW 37.719989776611 -122.406997680664 POINT (-122.40699768 37.71998978) Phone   75 2 9 19 8 10 4 309 7 18 18   75   9             2         75
215567 215567 9325256 2018-07-27T14:39:00 2018-08-24T00:00:00 2018-08-24T00:00:00 Closed 2 Condition not found - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CLEARFIELD DR and LAKE MERCED BLVD CLEARFIELD DR 7 Lakeshore TARAVAL 37.729652404785 -122.490547180176 POINT (-122.49054718 37.7296524) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
224238 224238 9325381 2018-07-27T15:04:00 2018-08-14T00:00:00 2018-08-14T00:00:00 Closed 2 condition not found. no number on file - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of ZOO RD and SKYLINE BLVD ZOO RD 7 Lakeshore TARAVAL 37.731575012206996 -122.499061584473 POINT (-122.49906158 37.73157501) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
232428 232428 9263759 2018-07-13T16:04:00 2018-08-15T00:00:00 2018-08-15T00:00:00 Closed 2 condition not found - no action needed DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 174 SHOTWELL ST, SAN FRANCISCO, CA, 94103 SHOTWELL ST 9 Mission MISSION 37.765720367431996 -122.41656494140601 POINT (-122.41656494 37.76572037) Phone   53 3 2 20 7 8 7 28,853 4 19 19 12 53   2 14   3 14     2   3     53
243659 243659 9272069 2018-07-16T09:12:00 2018-07-31T08:24:00 2018-07-31T08:24:00 Closed 2 overgrown vegetation - posted property NTR: 1133080 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 1965 10TH AVE, SAN FRANCISCO, CA, 94116 10TH AVE 7 Golden Gate Heights TARAVAL 37.75162529999999 -122.466775 POINT (-122.466775 37.7516253) Web http://mobile311.sfgov.org/reports/9272069/photos 44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
250395 250395 9219750 2018-07-03T11:31:00 2018-08-07T00:00:00 2018-08-07T00:00:00 Closed 2 Called reporter, defect at the back of property next to Adam Rodgers Park. - X1104: 1135048 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1218 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Bayview BAYVIEW 37.73006439209 -122.383743286133 POINT (-122.38374329 37.73006439) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
269749 269749 9176260 2018-06-23T16:23:00 2018-08-20T00:00:00 2018-08-20T00:00:00 Closed 2 condition not found. called requester. - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of FULTON ST and 17TH AVE FULTON ST 1 Golden Gate Park RICHMOND 37.772960662842 -122.475616455078 POINT (-122.47561646 37.77296066) Phone   9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
288189 288189 9122427 2018-06-11T13:25:00 2018-08-23T00:00:00 2018-08-23T00:00:00 Closed 2 weeds are in muni tracks - DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of MARKET ST and GLENDALE ST MARKET ST 8 Clarendon Heights MISSION 37.756637573242 -122.442222595215 POINT (-122.4422226 37.75663757) Phone   47 3 5 5 5 2 7 28,862 4 3 3   47   5             1         47
311661 311661 9443844 2018-08-23T16:08:00   2018-12-21T06:10:01 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2375 BUSH ST, SAN FRANCISCO, CA, 94115 BUSH ST 2 Lower Pacific Heights NORTHERN 37.78653717041 -122.43625640869101 POINT (-122.43625641 37.78653717) Phone   103 4 6 30 1 13 9 29,490 6 27 27   103   6             1         103
344591 344591 9411398 2018-08-16T12:09:00 2019-03-24T00:00:00 2019-03-24T00:00:00 Closed 2 8.22.18: 4214 Mission St- Plywood covering old cut out for tree on sidewalk - next to new cutout for tree (New tree installed). AA - Spoke to resident at 4214 Mission: Urban Forestry cut sidewalk, then decided to put tree in a new location. See pictures. AA DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 4224 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 11 Mission Terrace INGLESIDE 37.72957 -122.430466666667 POINT (-122.43046667 37.72957) Mobile/Open311 http://mobile311.sfgov.org/reports/9411398/photos 94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
364948 364948 9633939 2018-10-05T22:23:00 2018-10-18T00:00:00 2018-10-18T00:00:00 Closed 2 No conditions found - No Action Required DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 550 37TH AVE, SAN FRANCISCO, CA, 94121 37TH AVE 1 Outer Richmond RICHMOND 37.77851930372 -122.49723542969801 POINT (-122.49723543 37.7785193) Mobile/Open311   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
404731 404731 9558390 2018-09-18T15:17:00 2018-10-09T07:51:00 2018-10-09T07:51:00 Closed 2 Damaged concrete apron around trees. - NTR: 1140204 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 2900 25TH ST, SAN FRANCISCO, CA, 94110 25TH ST 9 Mission MISSION 37.75138092041 -122.408187866211 POINT (-122.40818787 37.75138092) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       1   3     53
406792 406792 9540858 2018-09-14T11:46:00 2018-10-24T00:00:00 2018-10-24T00:00:00 Closed 2 Low tree basin - X1104: 1139569 DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 462 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761499939386 -122.435120608382 POINT (-122.43512061 37.76149994) Mobile/Open311 http://mobile311.sfgov.org/reports/9540858/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
508018 508018 1114359 2012-04-29T13:29:21 2016-10-01T05:26:15 2016-10-01T05:26:15 Closed 2 Please remove all weeds/trim all trees/remove all debris and fix all fences around property area per city standard. - Blight # 973843, DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1080 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Hunters Point BAYVIEW 37.728500366211 -122.380996704102 POINT (-122.3809967 37.72850037) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
519103 519103 438590 2009-05-27T12:21:40 2010-01-26T04:41:34 2010-01-26T04:41:34 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
585199 585199 10737505 2019-04-16T14:26:00 2019-06-17T00:00:00 2019-06-17T00:00:00 Closed 2 Overgrown vegetation in Weeds on property area missing sewer vent cover could be blight talk to FK about this matter on Monday - NTR # 1166298, DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1834 EGBERT AVE, SAN FRANCISCO, CA, 94124 EGBERT AVE 10 Bayview BAYVIEW 37.727584838867 -122.40103149414101 POINT (-122.40103149 37.72758484) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
620261 620261 10657943 2019-03-28T13:42:00 2019-06-15T00:00:00 2019-06-15T00:00:00 Closed 2 repair missing sewer vent cover, and Planter Box should be at least 18 inches away from curb.PB - NTR: 1164747 DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 2059 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Panhandle PARK 37.775146484375 -122.450630187988 POINT (-122.45063019 37.77514648) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
662717 662717 367799 2009-02-07T09:30:46 2011-06-06T04:31:03 2011-06-06T04:31:03 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 338 NORIEGA ST, SAN FRANCISCO, CA, 94122 NORIEGA ST 7 Golden Gate Heights TARAVAL 37.754760742188 -122.46743774414101 POINT (-122.46743774 37.75476074) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
663614 663614 448191 2009-06-11T10:14:08 2010-03-20T04:41:40 2010-03-20T04:41:40 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 470 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 8 Mission Dolores MISSION 37.76815032959 -122.423721313477 POINT (-122.42372131 37.76815033) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
663737 663737 447566 2009-06-10T10:54:29 2009-08-31T13:47:53 2009-08-31T13:47:53 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 75 TOPAZ WAY, SAN FRANCISCO, CA, 94131 TOPAZ WAY 8 Diamond Heights INGLESIDE 37.741939544678004 -122.43654632568399 POINT (-122.43654633 37.74193954) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
663904 663904 396481 2009-03-23T17:13:38 2011-01-05T04:34:24 2011-01-05T04:34:24 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 112 OTSEGO AVE, SAN FRANCISCO, CA, 94112 OTSEGO AVE 11 Mission Terrace INGLESIDE 37.725799560546996 -122.439872741699 POINT (-122.43987274 37.72579956) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
664585 664585 416544 2009-04-22T08:22:48 2010-03-26T13:59:36 2010-03-26T13:59:36 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 16TH ST and POND ST 16TH ST 8 Castro MISSION 37.764289855956996 -122.43228149414101 POINT (-122.43228149 37.76428986) Web   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
665181 665181 241323 2008-07-02T13:11:27 2009-03-12T05:10:11 2009-03-12T05:10:11 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 201 BELLA VISTA WAY, SAN FRANCISCO, CA, 94127 BELLA VISTA WAY 7 Miraloma Park INGLESIDE 37.737892150879 -122.449600219727 POINT (-122.44960022 37.73789215) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
665264 665264 439985 2009-05-29T12:17:14 2009-08-31T13:47:25 2009-08-31T13:47:25 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of LAFAYETTE ST and NATOMA ST LAFAYETTE ST 6 South of Market SOUTHERN 37.772815704346 -122.41691589355499 POINT (-122.41691589 37.7728157) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
665870 665870 254532 2008-07-26T13:03:18 2009-03-19T05:10:10 2009-03-19T05:10:10 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 2490 17TH AVE, SAN FRANCISCO, CA, 94116 17TH AVE 7 West Portal TARAVAL 37.741512298584 -122.473281860352 POINT (-122.47328186 37.7415123) Phone   46 10 8 41 4 1 5 29,491 8 40 40   46   8             1         46
665927 665927 421429 2009-04-29T11:31:02 2009-05-29T17:16:56 2009-05-29T17:16:56 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 101 HENRY ADAMS ST, SAN FRANCISCO, CA, 94103 HENRY ADAMS ST 10 Showplace Square SOUTHERN 37.767566680908 -122.403617858887 POINT (-122.40361786 37.76756668) Phone   33 1 9 4 8 8 2 28,853 2 20 20   33   9             1         33
666946 666946 391557 2009-03-18T10:28:11 2009-05-29T17:15:50 2009-05-29T17:15:50 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 118 WHITNEY ST, SAN FRANCISCO, CA, 94131 WHITNEY ST 8 Fairmount INGLESIDE 37.739322662354 -122.42774200439501 POINT (-122.427742 37.73932266) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
670207 670207 445822 2009-06-07T17:18:08 2016-04-11T05:10:38 2016-04-11T05:10:38 Closed 2 Very old SR Closed: No response from BSM in 1 month DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of CHAVES AVE and DEL SUR AVE CHAVES AVE 7 Miraloma Park INGLESIDE 37.741863250732 -122.453964233398 POINT (-122.45396423 37.74186325) Twitter   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
671007 671007 401836 2009-03-31T12:27:30 2009-04-24T05:10:35 2009-04-24T05:10:35 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of EDDY ST and SCOTT ST EDDY ST 5 Western Addition NORTHERN 37.780799865723 -122.43726348876999 POINT (-122.43726349 37.78079987) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
674074 674074 258306 2008-08-01T19:15:59 2008-12-11T05:07:05 2008-12-11T05:07:05 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2670 LEAVENWORTH ST, SAN FRANCISCO, CA, 94133 LEAVENWORTH ST 2 Fisherman's Wharf CENTRAL 37.806072235107 -122.41867828369101 POINT (-122.41867828 37.80607224) Phone   99 6 6 23 1 5 1 308 1 23 23   99   6         2   2         99
674590 674590 334706 2008-12-18T09:13:04 2009-01-22T05:07:13 2009-01-22T05:07:13 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 770 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Cole Valley PARK 37.767868041992 -122.453086853027 POINT (-122.45308685 37.76786804) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
674810 674810 260465 2008-08-06T09:25:46 2008-08-06T10:03:49 2008-08-06T10:03:49 Closed 2 Case is Invalid Per CSR cancel request because invalid form was used. DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 700 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 2 Presidio Terrace RICHMOND 37.786697387695 -122.46701812744101 POINT (-122.46701813 37.78669739) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
676004 676004 359795 2009-01-26T21:17:12 2009-10-16T09:56:25 2009-10-16T09:56:25 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 61 HILL ST, SAN FRANCISCO, CA, 94110 HILL ST 8 Dolores Heights MISSION 37.755905151367 -122.42234039306601 POINT (-122.42234039 37.75590515) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
676942 676942 423028 2009-05-01T16:21:33 2009-08-25T12:26:22 2009-08-25T12:26:22 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
677712 677712 389701 2009-03-15T16:26:42 2009-06-04T05:10:46 2009-06-04T05:10:46 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2555 BAY SHORE BLVD, SAN FRANCISCO, CA, 94134 BAY SHORE BLVD 10 Little Hollywood INGLESIDE 37.709136962891 -122.40472412109399 POINT (-122.40472412 37.70913696) Phone   89 2 9 1 8 10 3 309 3 1 1   89   9   1         1         89
677722 677722 445627 2009-06-07T07:47:51 2009-08-25T12:26:32 2009-08-25T12:26:32 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 96 CRESTLINE DR, SAN FRANCISCO, CA, 94131 CRESTLINE DR 8 Upper Market PARK 37.752468109130994 -122.446487426758 POINT (-122.44648743 37.75246811) Phone   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
678177 678177 276738 2008-09-05T16:37:38 2008-10-08T10:03:37 2008-10-08T10:03:37 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 10 BEAVER ST, SAN FRANCISCO, CA, 94114 BEAVER ST 8 Duboce Triangle PARK 37.765151977539 -122.433738708496 POINT (-122.43373871 37.76515198) Phone   28 7 5 5 5 15 8 28,862 5 3 3   28   5             1   5     28
678767 678767 279095 2008-09-10T09:27:47   2008-09-10T09:47:00 Open 1 Open DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
678786 678786 417494 2009-04-23T13:15:18 2009-05-29T17:16:33 2009-05-29T17:16:33 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of DIAMOND HEIGHTS BLVD and DUNCAN ST DIAMOND HEIGHTS BLVD 8 Diamond Heights MISSION 37.745296478271 -122.440086364746 POINT (-122.44008636 37.74529648) Phone   57 3 5 22 5 2 7 63 4 22 22   57   5             1         57
683531 683531 251379 2008-07-21T10:37:30 2008-12-12T05:07:02 2008-12-12T05:07:02 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of BENGAL ALY and MIRALOMA DR BENGAL ALY 7 Sherwood Forest INGLESIDE 37.738109588623 -122.461441040039 POINT (-122.46144104 37.73810959) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
684490 684490 279814 2008-09-11T10:53:50 2009-03-20T05:10:11 2009-03-20T05:10:11 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 475 COUNTRY CLUB DR, SAN FRANCISCO, CA, 94132 COUNTRY CLUB DR 7 Lakeshore TARAVAL 37.730567932129 -122.495170593262 POINT (-122.49517059 37.73056793) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
686445 686445 335042 2008-12-18T15:10:27 2009-04-14T05:10:20 2009-04-14T05:10:20 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2424 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Cayuga INGLESIDE 37.715911865234 -122.44504547119101 POINT (-122.44504547 37.71591187) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
686654 686654 416548 2009-04-22T08:25:57 2009-06-06T05:10:50 2009-06-06T05:10:50 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 661 ANDERSON ST, SAN FRANCISCO, CA, 94110 ANDERSON ST 9 Bernal Heights INGLESIDE 37.73518371582 -122.41541290283199 POINT (-122.4154129 37.73518372) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
687432 687432 433899 2009-05-18T17:16:35 2009-05-29T18:11:16 2009-05-29T18:11:16 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1683 32ND AVE, SAN FRANCISCO, CA, 94122 32ND AVE 4 Outer Sunset TARAVAL 37.755840301514 -122.49069976806601 POINT (-122.49069977 37.7558403) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
689326 689326 293673 2008-10-07T09:09:42 2008-11-13T05:06:55 2008-11-13T05:06:55 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 1385 MONTEREY BLVD, SAN FRANCISCO, CA, 94127 MONTEREY BLVD 7 Mt. Davidson Manor TARAVAL 37.731269836426 -122.463768005371 POINT (-122.46376801 37.73126984) Phone   68 10 8 41 4 9 5 59 8 40 40   68   8             1         68
690787 690787 305914 2008-10-30T07:53:00 2008-12-17T05:07:07 2008-12-17T05:07:07 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 18TH ST and DOLORES ST 18TH ST 8 Mission Dolores MISSION 37.761428833008 -122.426078796387 POINT (-122.4260788 37.76142883) Phone   37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
691422 691422 295866 2008-10-10T17:21:38 2009-01-21T05:07:11 2009-01-21T05:07:11 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of 35TH AVE and LINCOLN WAY 35TH AVE 4 Golden Gate Park TARAVAL 37.764686584473 -122.494400024414 POINT (-122.49440002 37.76468658) Phone   9 10 7 35 3 1 5 56 8 35 35   9   7             1         9
692096 692096 301690 2008-10-22T12:34:48 2008-12-16T05:07:07 2008-12-16T05:07:07 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 509 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.79972076416 -122.409599304199 POINT (-122.4095993 37.79972076) Phone   106 6 3 6 10 3 1 308 1 4 4 21 106   3 23 20   23     2         106
692610 692610 304370 2008-10-27T13:48:27 2008-12-10T05:07:05 2008-12-10T05:07:05 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of BACON ST and UNIVERSITY ST BACON ST 9 University Mound BAYVIEW 37.72505569458 -122.413467407227 POINT (-122.41346741 37.72505569) Phone   91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
693865 693865 377791 2009-02-24T14:35:49 2009-02-26T05:10:10 2009-02-26T05:10:10 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2155 BUCHANAN ST, SAN FRANCISCO, CA, 94115 BUCHANAN ST 2 Pacific Heights NORTHERN 37.790054321289 -122.43083190918001 POINT (-122.43083191 37.79005432) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102

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.916ms