calls

7,158 rows where Responsible_Agency = 2 sorted by Address

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
3306500 3306500 8325578 2017-11-29T14:57:00 2018-02-28T11:14:42 2018-02-28T11:14:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1 ARBOR ST, SAN FRANCISCO, CA, 94131 ARBOR ST 8 Glen Park INGLESIDE 37.738038618153 -122.43469130259199 POINT (-122.4346913 37.73803862) Mobile/Open311 http://mobile311.sfgov.org/reports/8325578/photos 96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
472144 472144 10407933 2019-01-26T07:41:00   2019-01-26T08:15:03 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1 BLUXOME ST, SAN FRANCISCO, CA, 94107 BLUXOME ST 6 South of Market SOUTHERN 37.777462005615 -122.395820617676 POINT (-122.39582062 37.77746201) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
2404947 2404947 5274071 2015-11-11T07:43:33 2015-11-20T06:07:00 2015-11-20T06:07:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1 BRADFORD ST, SAN FRANCISCO, CA, 94110 BRADFORD ST 9 Bernal Heights INGLESIDE 37.735889434814 -122.40979766845699 POINT (-122.40979767 37.73588943) Web   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
591387 591387 10493584 2019-02-15T11:44:00   2019-02-15T18:10:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1 CASHMERE ST, SAN FRANCISCO, CA, 94124 CASHMERE ST 10 Bayview BAYVIEW 37.735572814941 -122.382041931152 POINT (-122.38204193 37.73557281) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1943866 1943866 4347829 2014-12-30T18:45:57 2015-01-07T12:53:00 2015-01-07T12:53:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 CHURCH ST, SAN FRANCISCO, CA, 94117 CHURCH ST 8 Duboce Triangle PARK 37.769949315046 -122.429006648241 POINT (-122.42900665 37.76994932) Phone   28 7 5 9 5 7 6 29,492 9 10 10   28   5       20     1         28
2249045 2249045 4914870 2015-07-16T17:15:03 2015-07-24T01:15:26 2015-07-24T01:15:26 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 CHURCH ST, SAN FRANCISCO, CA, 94117 CHURCH ST 8 Duboce Triangle PARK 37.769949315046 -122.429006648241 POINT (-122.42900665 37.76994932) Phone   28 7 5 9 5 7 6 29,492 9 10 10   28   5       20     1         28
3143473 3143473 8006650 2017-09-11T17:48:00 2017-10-16T23:59:00 2017-10-16T23:59:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1 CHURCH ST, SAN FRANCISCO, CA, 94117 CHURCH ST 8 Duboce Triangle PARK 37.769872 -122.42893000000001 POINT (-122.42893 37.769872) Mobile/Open311 http://mobile311.sfgov.org/reports/8006650/photos 28 7 5 9 5 7 6 29,492 9 10 10   28   5       20     1         28
2357293 2357293 5528187 2016-02-02T12:06:29 2016-02-11T01:21:00 2016-02-11T01:21:00 Closed 2 Case Resolved: jp DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1 ELMHURST DR, SAN FRANCISCO, CA, 94132 ELMHURST DR 7 Stonestown TARAVAL 37.730322671323 -122.47276379351901 POINT (-122.47276379 37.73032267) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
2178376 2178376 4782075 2015-05-28T10:04:57 2015-06-15T01:29:00 2015-06-15T01:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 GILROY ST, SAN FRANCISCO, CA, 94124 GILROY ST 10 Bret Harte BAYVIEW 37.716396758746 -122.388555969851 POINT (-122.38855597 37.71639676) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
1934581 1934581 4111192 2014-10-15T12:50:44 2015-01-06T06:18:00 2015-01-06T06:18:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1 IGNACIO AVE, SAN FRANCISCO, CA, 94124 IGNACIO AVE 10 Bret Harte BAYVIEW 37.715062684792 -122.388497870739 POINT (-122.38849787 37.71506268) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
2030664 2030664 4049895 2014-09-26T08:59:08 2014-10-30T10:57:36 2014-10-30T10:57:36 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1 IGNACIO AVE, SAN FRANCISCO, CA, 94124 IGNACIO AVE 10 Bret Harte BAYVIEW 37.715062684792 -122.388497870739 POINT (-122.38849787 37.71506268) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
3366077 3366077 8653061 2018-02-19T19:50:00 2018-02-20T00:00:00 2018-02-20T00:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1 IGNACIO AVE, SAN FRANCISCO, CA, 94124 IGNACIO AVE 10 Bret Harte BAYVIEW 37.715190887451 -122.388641357422 POINT (-122.38864136 37.71519089) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
3511845 3511845 8818663 2018-04-02T13:05:00   2018-05-02T10:59:28 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1 IGNACIO AVE, SAN FRANCISCO, CA, 94124 IGNACIO AVE 10 Bret Harte BAYVIEW 37.715190887451 -122.388641357422 POINT (-122.38864136 37.71519089) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
3634783 3634783 10772513 2019-04-24T13:27:00   2019-04-24T14:15:06 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1 IGNACIO AVE, SAN FRANCISCO, CA, 94124 IGNACIO AVE 10 Bret Harte BAYVIEW 37.715190887451 -122.388641357422 POINT (-122.38864136 37.71519089) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
614 614 11611350 2019-10-28T09:11:00 2019-10-28T10:16:49 2019-10-29T14:50:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 5 Parnassus Heights PARK 37.764459011778 -122.457307885178 POINT (-122.45730789 37.76445901) Mobile/Open311   110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
1918257 1918257 4271378 2014-12-04T16:59:51 2014-12-05T06:32:19 2014-12-05T06:32:19 Closed 2 resolved: private HOA trees no hazard found DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 LYNDHURST DR, SAN FRANCISCO, CA, 94132 LYNDHURST DR 7 Stonestown TARAVAL 37.724709862057 -122.47280848145901 POINT (-122.47280848 37.72470986) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
2411209 2411209 5274043 2015-11-11T07:36:30 2015-11-12T11:37:02 2015-11-12T11:37:02 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 MASSASOIT ST, SAN FRANCISCO, CA, 94110 MASSASOIT ST 9 Peralta Heights INGLESIDE 37.744823455811 -122.407745361328 POINT (-122.40774536 37.74482346) Web   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
3004370 3004370 7448597 2017-08-01T13:48:31   2017-10-17T11:15:16 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1 NEWBURG ST, SAN FRANCISCO, CA, 94131 NEWBURG ST 8 Noe Valley INGLESIDE 37.746266518487 -122.433791844453 POINT (-122.43379184 37.74626652) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
2085494 2085494 4466912 2015-02-06T15:05:27 2015-02-17T11:30:12 2015-02-17T11:30:12 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 PRAGUE ST, SAN FRANCISCO, CA, 94112 PRAGUE ST 11 Excelsior INGLESIDE 37.722045164320996 -122.424661354152 POINT (-122.42466135 37.72204516) Phone     9 1 19 6 9 4 28,861 7 18 18       1             2          
164264 164264 8209075 2017-10-31T12:53:00 2017-11-02T08:33:00 2017-11-02T08:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1 QUARTZ WAY, SAN FRANCISCO, CA, 94131 QUARTZ WAY 8 Diamond Heights INGLESIDE 37.745532989502 -122.445541381836 POINT (-122.44554138 37.74553299) Phone   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
3105318 3105318 7191569 2017-05-26T10:14:32 2017-06-03T10:10:13 2017-06-03T10:10:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1 SAINT FRANCIS PL, SAN FRANCISCO, CA, 94107 SAINT FRANCIS PL 6 South of Market SOUTHERN 37.783074 -122.39806200000001 POINT (-122.398062 37.783074) Mobile/Open311   32 1 10 34 9 6 2 28,856 2 34 34   32   10         4   2         32
2898125 2898125 7145196 2017-05-13T11:24:19 2017-05-14T02:34:00 2017-05-14T02:34:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1 SAN ANTONIO PL, SAN FRANCISCO, CA, 94133 SAN ANTONIO PL 3 North Beach CENTRAL 37.799435113445 -122.40583770574301 POINT (-122.40583771 37.79943511) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23     23     2         106
498448 498448 10329547 2019-01-08T09:08:00 2019-01-08T11:17:04 2019-01-08T11:17:04 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1 SERGEANT JOHN V YOUNG ST, SAN FRANCISCO, CA, 94112 SERGEANT JOHN V YOUNG ST 11 Mission Terrace INGLESIDE 37.725142446911995 -122.44533546242701 POINT (-122.44533546 37.72514245) Web http://mobile311.sfgov.org/reports/10329547/photos 94 9 1 28 6 9 4 28,861 7 25 25   94   1             1     70   94
3024951 3024951 7295300 2017-06-24T09:10:27 2017-10-05T05:48:47 2017-10-05T05:48:47 Closed 2 Area is not under the care and maintenance of Public Works. Please forward to correct property owner. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1 SHIELDS ST, SAN FRANCISCO, CA, 94132 SHIELDS ST 11 Merced Heights TARAVAL 37.717837171742 -122.46276369896401 POINT (-122.4627637 37.71783717) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
1956260 1956260 4192225 2014-11-09T15:25:46 2014-11-26T07:17:08 2014-11-26T07:17:08 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 6 South of Market SOUTHERN 37.773052553763 -122.418618953459 POINT (-122.41861895 37.77305255) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2   1     32
3731863 3731863 11130895 2019-07-15T11:59:00 2019-07-21T14:17:48 2019-07-21T14:17:48 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you for your pat DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1 SOUTHWOOD DR, SAN FRANCISCO, CA, 94112 SOUTHWOOD DR 7 Westwood Park INGLESIDE 37.725519446987 -122.45662201578399 POINT (-122.45662202 37.72551945) Mobile/Open311 http://mobile311.sfgov.org/reports/11130895/photos 71 9 8 41 4 9 4 28,861 7 40 40   71   8             1         71
263845 263845 9408539 2018-08-15T17:11:00   2018-08-21T08:15:03 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1 WINSTON DR, SAN FRANCISCO, CA, 94132 WINSTON DR 7 Stonestown TARAVAL 37.726508 -122.472656 POINT (-122.472656 37.726508) Web http://mobile311.sfgov.org/reports/9408539/photos 41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
1995887 1995887 3930570 2014-08-19T11:52:39 2014-08-28T09:39:32 2014-08-28T09:39:32 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 10 ARBOR ST, SAN FRANCISCO, CA, 94131 ARBOR ST 8 Glen Park INGLESIDE 37.738195382378 -122.43483395587499 POINT (-122.43483396 37.73819538) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
2574872 2574872 6028231 2016-06-28T12:43:18 2016-11-11T10:10:47 2016-11-11T10:10:47 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 10 CANYON DR, SAN FRANCISCO, CA, 94112 CANYON DR 11 Crocker Amazon INGLESIDE 37.708953857421996 -122.43034362793001 POINT (-122.43034363 37.70895386) Web   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
1382470 1382470 1219998 2012-08-01T18:05:52 2013-11-20T13:39:23 2013-11-20T13:39:23 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 10 DIAMOND ST, SAN FRANCISCO, CA, 94114 DIAMOND ST 8 Eureka Valley PARK 37.762035369873 -122.43743896484399 POINT (-122.43743896 37.76203537) Mobile/Open311   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
1527932 1527932 2369775 2013-05-15T19:06:10 2013-11-20T13:45:02 2013-11-20T13:45:02 Closed 2 resolved: Request closed by SES . Notes = " Notes:mailed empty basin letter 5/29/13 SR# 1419375 reports an empty basin that could be seen on Google Maps , but no empty basin on Diamond ST. This property id directly next door , but the frontage of property is on 17th St.. BUF Action:Correspondence. date completed - 5/29/2013. ". DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 10 DIAMOND ST, SAN FRANCISCO, CA, 94114 DIAMOND ST 8 Eureka Valley PARK 37.762035369873 -122.43743896484399 POINT (-122.43743896 37.76203537) Web   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
3312985 3312985 8408987 2017-12-20T10:32:00 2018-01-16T12:36:55 2018-01-16T12:36:55 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 10 LOCKSLEY AVE, SAN FRANCISCO, CA, 94122 LOCKSLEY AVE 7 Inner Sunset PARK 37.759498596191 -122.463096618652 POINT (-122.46309662 37.7594986) Twitter http://pic.twitter.com/5wDLy4NgTx 109 7 8 14 4 1 8 56 5 12 12   109   8             1         109
2200184 2200184 4977572 2015-08-07T18:39:47 2015-09-15T02:49:00 2015-09-15T02:49:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 10 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 6 South of Market SOUTHERN 37.7743 -122.419802 POINT (-122.419802 37.7743) Mobile/Open311 http://mobile311.sfgov.org/reports/4977572/photos 32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1   8 1 2 1 1     32
2039621 2039621 3949647 2014-08-25T11:32:24 2014-09-19T12:52:47 2014-09-19T12:52:47 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 100 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 2 Presidio Terrace RICHMOND 37.78667654108 -122.463544790678 POINT (-122.46354479 37.78667654) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
3087778 3087778 7342529 2017-07-06T14:48:41 2017-07-10T04:35:00 2017-07-10T04:35:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 100 BEMIS ST, SAN FRANCISCO, CA, 94131 BEMIS ST 8 Fairmount INGLESIDE 37.7376945 -122.4299774 POINT (-122.4299774 37.7376945) Web http://mobile311.sfgov.org/reports/7342529/photos 59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
593381 593381 10733993 2019-04-15T18:49:00 2019-05-11T12:42:14 2019-05-11T12:42:14 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 100 BRIGHT ST, SAN FRANCISCO, CA, 94132 BRIGHT ST 11 Merced Heights TARAVAL 37.712635799999994 -122.463321 POINT (-122.463321 37.7126358) Web   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
2310045 2310045 5063963 2015-09-03T15:03:58 2015-10-19T06:39:00 2015-10-19T06:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 100 CASITAS AVE, SAN FRANCISCO, CA, 94127 CASITAS AVE 7 Sherwood Forest INGLESIDE 37.737744402989 -122.45880321918399 POINT (-122.45880322 37.7377444) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
2290261 2290261 5225523 2015-10-26T12:02:20 2015-10-29T03:09:45 2015-10-29T03:09:45 Closed 2 cancelled: Trees and shrubs are privately maintained in this area. Not under the care and maintenance of Public Works. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 100 COMMONWEALTH AVE, SAN FRANCISCO, CA, 94118 COMMONWEALTH AVE 2 Laurel Heights / Jordan Park RICHMOND 37.783793690899 -122.455525298109 POINT (-122.4555253 37.78379369) Phone   11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
3177218 3177218 8145704 2017-10-16T10:15:00 2017-12-29T10:43:38 2017-12-29T10:43:38 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 DELANO AVE, SAN FRANCISCO, CA, 94112 DELANO AVE 11 Mission Terrace INGLESIDE 37.72647070000001 -122.4408293 POINT (-122.4408293 37.7264707) Web   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
2187242 2187242 4481979 2015-02-11T09:41:04 2015-02-28T02:16:00 2015-02-28T02:16:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Civic Center NORTHERN 37.776414952276 -122.420392194877 POINT (-122.42039219 37.77641495) Mobile/Open311 http://mobile311.sfgov.org/reports/4481979/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
3633995 3633995 10825348 2019-05-06T15:35:00 2019-07-21T15:34:40 2019-07-21T15:34:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.744135 -122.456861 POINT (-122.456861 37.744135) Mobile/Open311 http://mobile311.sfgov.org/reports/10825348/photos 49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
2502070 2502070 5686801 2016-03-21T17:09:50 2016-06-01T06:36:00 2016-06-01T06:36:00 Closed 2 PLEASE CONTACT THE PROPERTY OWNER/PRIVATE VEGETATION DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 100 JOOST AVE, SAN FRANCISCO, CA, 94131 JOOST AVE 8 Sunnyside INGLESIDE 37.732486724854 -122.43783569335899 POINT (-122.43783569 37.73248672) Web   95 9 5 41 5 9 4 63 7 40 40   95   5             1         95
293471 293471 9410960 2018-08-16T11:03:00   2018-08-17T12:35:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 100 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 MAGELLAN AVE 7 Forest Hill TARAVAL 37.748699188232 -122.46022796630899 POINT (-122.46022797 37.74869919) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
2262899 2262899 4965750 2015-08-04T08:07:46 2015-08-14T11:18:00 2015-08-14T11:18:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 100 NORTH POINT ST, SAN FRANCISCO, CA, 94133 NORTH POINT ST 3 Fisherman's Wharf CENTRAL 37.806963127598 -122.410497144959 POINT (-122.41049714 37.80696313) Phone   99 6 3 23 10 3 1 308 1 23 23   99   3             2         99
2388704 2388704 5302341 2015-11-19T20:17:11 2015-11-20T09:34:00 2015-11-20T09:34:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 100 OSHAUGHNESSY BLVD, SAN FRANCISCO, CA, 94127 OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.745532985079 -122.451626327485 POINT (-122.45162633 37.74553299) Phone   72 9 8 41 4 1 4 59 7 40 40   72   8             1         72
529624 529624 10812636 2019-05-03T12:04:00 2019-06-08T14:01:00 2019-06-08T14:01:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 100 PALO ALTO AVE, SAN FRANCISCO, CA, 94114 PALO ALTO AVE 7 Clarendon Heights PARK 37.756847381592 -122.44929504394501 POINT (-122.44929504 37.75684738) Phone   47 7 8 38 4 15 8 63 5 38 38   47   8             1         47
2208129 2208129 5239725 2015-10-30T14:30:57 2016-07-14T13:57:00 2016-07-14T13:57:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 100 PERSIA AVE, SAN FRANCISCO, CA, 94112 PERSIA AVE 11 Excelsior INGLESIDE 37.722593362779996 -122.435129831071 POINT (-122.43512983 37.72259336) Phone   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4           2         90
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
232604 232604 9294306 2018-07-20T15:38:00 2018-09-13T08:05:00 2018-09-13T08:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 100 REY ST, SAN FRANCISCO, CA, 94134 REY ST 10 Visitacion Valley INGLESIDE 37.712371826171996 -122.41175079345699 POINT (-122.41175079 37.71237183) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
2088933 2088933 4717942 2015-05-04T11:56:13 2015-05-06T02:13:00 2015-05-06T02:13:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 100 RHINE ST, SAN FRANCISCO, CA, 94112 RHINE ST 11 Outer Mission TARAVAL 37.709051430772 -122.46133538603998 POINT (-122.46133539 37.70905143) Phone   66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
283912 283912 9179349 2018-06-24T15:30:00 2018-09-24T08:31:00 2018-09-24T08:31:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 ROANOKE ST, SAN FRANCISCO, CA, 94131 ROANOKE ST 8 Glen Park INGLESIDE 37.735957487549 -122.430875728836 POINT (-122.43087573 37.73595749) Web   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
2399617 2399617 5269272 2015-11-09T15:21:45 2016-01-27T10:02:00 2016-01-27T10:02:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 100 THE EMBARCADERO, SAN FRANCISCO, CA, 94111 THE EMBARCADERO 6 Financial District CENTRAL 37.79331961788 -122.392762360119 POINT (-122.39276236 37.79331962) Phone   108 1 10 8 9 12 2 28,855 2 6 6   108   10     4       1   4     108
635321 635321 10489963 2019-02-14T14:23:00 2019-03-18T10:12:42 2019-03-18T10:12:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 6 Civic Center NORTHERN 37.7767268 -122.4192173 POINT (-122.4192173 37.7767268) Web   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
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
3541426 3541426 10491624 2019-02-14T22:33:00 2019-03-18T10:12:36 2019-03-18T10:12:36 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 100 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 6 Civic Center NORTHERN 37.776668837672 -122.41933793070801 POINT (-122.41933793 37.77666884) Mobile/Open311   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
3568641 3568641 10493608 2019-02-15T11:47:00   2019-02-15T18:10:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 100 WHITNEY YOUNG CIR, SAN FRANCISCO, CA, 94124 WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.736297607421996 -122.385879516602 POINT (-122.38587952 37.73629761) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
624844 624844 10757281 2019-04-21T09:32:00 2019-04-21T10:12:28 2019-04-21T10:12:28 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1000 16TH ST, SAN FRANCISCO, CA, 94107 16TH ST 10 Showplace Square SOUTHERN 37.766668475268 -122.396859834085 POINT (-122.39685983 37.76666848) Mobile/Open311 http://mobile311.sfgov.org/reports/10757281/photos 33 1 9 4 8 14 3 28,856 3 20 20   33   9             1     67 20 33
2015608 2015608 4164139 2014-10-31T13:26:01 2014-11-01T07:06:02 2014-11-01T07:06:02 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1000 BRANNAN ST, SAN FRANCISCO, CA, 94103 BRANNAN ST 6 Showplace Square SOUTHERN 37.76989364624 -122.407424926758 POINT (-122.40742493 37.76989365) Web   33 1 10 34 9 8 2 28,853 2 34 34   33   10             2         33
1948131 1948131 4258100 2014-12-01T12:05:01 2014-12-12T02:23:00 2014-12-12T02:23:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1000 CAROLINA ST, SAN FRANCISCO, CA, 94107 CAROLINA ST 10 Potrero Hill BAYVIEW 37.755909525408 -122.399936257493 POINT (-122.39993626 37.75590953) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
2423235 2423235 5286939 2015-11-15T15:07:20 2015-11-17T08:30:00 2015-11-17T08:30:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1000 CAYUGA AVE, SAN FRANCISCO, CA, 94112 CAYUGA AVE 11 Cayuga INGLESIDE 37.721186687595 -122.44132140464 POINT (-122.4413214 37.72118669) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
235957 235957 9181909 2018-06-25T09:57:00 2018-06-25T13:56:35 2018-06-25T13:56:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1000 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94124 CESAR CHAVEZ ST 10 Central Waterfront BAYVIEW 37.7503065 -122.3877274 POINT (-122.3877274 37.7503065) Web   56 2 9 1 8 10 3 28,856 3 1 1   56   9         14   1         56
2412354 2412354 5586331 2016-02-20T09:12:17 2016-08-01T09:40:18 2016-08-01T09:40:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 1000 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.783896502158 -122.422550563405 POINT (-122.42255056 37.7838965) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
2443723 2443723 5403533 2015-12-25T00:48:02 2015-12-29T03:00:00 2015-12-29T03:00:00 Closed 2 resolved: water was turned off quick coupler is loose may need repair DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1000 GREAT HWY, SAN FRANCISCO, CA, 94117 GREAT HWY 1 Golden Gate Park RICHMOND 37.768848419189 -122.510528564453 POINT (-122.51052856 37.76884842) Phone   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
2431311 2431311 5329006 2015-11-30T07:22:30 2015-12-01T09:27:28 2015-12-01T09:27:28 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1000 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94132 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.719503708674004 -122.47284666572399 POINT (-122.47284667 37.71950371) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
2979051 2979051 7117107 2017-05-05T10:36:24 2017-07-08T19:54:18 2017-07-08T19:54:18 Closed 2 Your request is a duplicate of a previously submitted service order and will be closed. The work has been scheduled. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1000 LOMBARD ST, SAN FRANCISCO, CA, 94109 LOMBARD ST 2 Russian Hill CENTRAL 37.802284060514005 -122.41817996982701 POINT (-122.41817997 37.80228406) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1     16 3 107
2089166 2089166 4418398 2015-01-22T13:07:04 2015-01-26T07:04:00 2015-01-26T07:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1000 VAN NESS AVE, SAN FRANCISCO, CA, 94109 VAN NESS AVE 6 Tenderloin NORTHERN 37.784751812961 -122.42113979608101 POINT (-122.4211398 37.78475181) Phone   20 4 10 36 9 13 6 28,858 9 36 36   20   10           1 2 1       20
2189064 2189064 5125605 2015-09-23T16:23:12 2015-09-30T12:44:00 2015-09-30T12:44:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1000 VAN NESS AVE, SAN FRANCISCO, CA, 94109 VAN NESS AVE 6 Tenderloin NORTHERN 37.784751812961 -122.42113979608101 POINT (-122.4211398 37.78475181) Phone   20 4 10 36 9 13 6 28,858 9 36 36   20   10           1 2 1       20
2337959 2337959 5504120 2016-01-26T10:58:12 2016-02-13T10:07:00 2016-02-13T10:07:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1000 VAN NESS AVE, SAN FRANCISCO, CA, 94109 VAN NESS AVE 6 Tenderloin NORTHERN 37.784751812961 -122.42113979608101 POINT (-122.4211398 37.78475181) Phone   20 4 10 36 9 13 6 28,858 9 36 36   20   10           1 2 1       20
2426518 2426518 5288390 2015-11-16T09:01:13 2015-12-01T10:38:00 2015-12-01T10:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 1001 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.754906906813 -122.423176650377 POINT (-122.42317665 37.75490691) Mobile/Open311   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
2004764 2004764 4156206 2014-10-29T09:27:44 2016-04-11T17:30:11 2016-04-11T17:30:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1001 HAMPSHIRE ST, SAN FRANCISCO, CA, 94110 HAMPSHIRE ST 9 Mission MISSION 37.755859375 -122.407432556152 POINT (-122.40743256 37.75585938) Web   53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
2298474 2298474 4958070 2015-07-31T18:22:29 2015-08-17T11:56:00 2015-08-17T11:56:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1001 HARRISON ST, SAN FRANCISCO, CA, 94103 HARRISON ST 6 South of Market SOUTHERN 37.777115 -122.40425 POINT (-122.40425 37.777115) Mobile/Open311   32 1 10 34 9 14 2 28,853 2 34 34 24 32   10 6     6     2         32
2316539 2316539 5146574 2015-09-30T11:32:32 2015-10-01T01:26:50 2015-10-01T01:26:50 Closed 2 cancelled: Call back phone number not working DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1001 STEINER ST, SAN FRANCISCO, CA, 94115 STEINER ST 5 Western Addition NORTHERN 37.778601338308 -122.43358166496799 POINT (-122.43358166 37.77860134) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
2980717 2980717 6937935 2017-03-14T15:45:34 2017-08-06T21:30:34 2017-08-06T21:30:34 Closed 2 This service order is scheduled for planned maintenance and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing 1003 BOSWORTH ST, SAN FRANCISCO, CA, 94131 BOSWORTH ST 8 Glen Park INGLESIDE 37.734067955795005 -122.437600745635 POINT (-122.43760075 37.73406796) Phone   96 9 5 41 5 9 4 63 7 40 40   96   5             1         96
2268165 2268165 5078301 2015-09-08T15:30:38 2015-09-09T09:55:00 2015-09-09T09:55:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1003 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 5 Cathedral Hill NORTHERN 37.781201357921 -122.425606050897 POINT (-122.42560605 37.78120136) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
504441 504441 10333974 2019-01-09T08:20:00 2019-02-26T15:44:32 2019-02-26T15:44:32 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1004 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.754992 -122.42319099999999 POINT (-122.423191 37.754992) Mobile/Open311 http://mobile311.sfgov.org/reports/10333974/photos 52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1321058 1321058 1026548 2011-12-20T08:19:37   2011-12-20T08:58:10 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1005 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.754711151123 -122.427536010742 POINT (-122.42753601 37.75471115) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1951000 1951000 3942122 2014-08-22T14:30:58 2014-08-27T02:34:22 2014-08-27T02:34:22 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1005 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 5 Inner Sunset TARAVAL 37.763884577685 -122.46852016450501 POINT (-122.46852016 37.76388458) Phone   109 10 11 14 11 1 5 56 8 12 12 2 109   11 2     2     1         109
23117 23117 10812812 2019-05-03T12:32:00 2019-10-27T12:05:00 2019-10-27T12:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1006 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715091705321996 -122.471435546875 POINT (-122.47143555 37.71509171) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
136835 136835 5020332 2015-08-21T10:58:09 2015-10-14T02:37:00 2015-10-14T02:37:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1006 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715090957882 -122.471436282043 POINT (-122.47143628 37.71509096) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
2361899 2361899 5287683 2015-11-15T21:36:10 2015-12-01T10:35:00 2015-12-01T10:35:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 1007 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.754918396743 -122.42293892492901 POINT (-122.42293892 37.7549184) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
2153024 2153024 4466379 2015-02-06T13:23:41 2015-02-17T09:54:29 2015-02-17T09:54:29 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 101 AMBER DR, SAN FRANCISCO, CA, 94131 AMBER DR 8 Diamond Heights INGLESIDE 37.745535503632 -122.445160907689 POINT (-122.44516091 37.7455355) Phone   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
237982 237982 9117539 2018-06-10T11:19:00   2018-06-10T12:10:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 101 CARGO WAY, SAN FRANCISCO, CA, 94124 CARGO WAY 10 India Basin BAYVIEW 37.740322113037 -122.37743377685499 POINT (-122.37743378 37.74032211) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
2816510 2816510 6783907 2017-01-29T15:22:25 2017-02-16T11:55:08 2017-02-16T11:55:08 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 101 COMMONWEALTH AVE, SAN FRANCISCO, CA, 94118 COMMONWEALTH AVE 2 Laurel Heights / Jordan Park RICHMOND 37.783790927457 -122.455857492515 POINT (-122.45585749 37.78379093) Phone   11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
2000673 2000673 3964342 2014-08-29T13:41:28 2014-10-01T02:49:14 2014-10-01T02:49:14 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 101 CONGDON ST, SAN FRANCISCO, CA, 94112 CONGDON ST 11 Mission Terrace INGLESIDE 37.730861760585 -122.426072535844 POINT (-122.42607254 37.73086176) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
314844 314844 9494011 2018-09-04T12:54:00 2018-11-14T06:39:00 2018-11-14T06:39:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 101 DE LONG ST, SAN FRANCISCO, CA, 94112 DE LONG ST 11 Outer Mission TARAVAL 37.709513 -122.460901 POINT (-122.460901 37.709513) Mobile/Open311 http://mobile311.sfgov.org/reports/9494011/photos 66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
2164538 2164538 4466440 2015-02-06T13:35:39 2015-02-13T09:49:00 2015-02-13T09:49:00 Closed 2 resolved: removed down tree DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 101 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.775235509956005 -122.421032073987 POINT (-122.42103207 37.77523551) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
1823046 1823046 3618418 2014-05-06T16:40:12   2014-05-07T13:06:22 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 101 LINCOLN WAY, SAN FRANCISCO, CA, 94122 LINCOLN WAY 5 Inner Sunset PARK 37.766194971854 -122.458944448549 POINT (-122.45894445 37.76619497) Phone   109 7 11 14 11 15 8 29,492 5 12 12   109   11             1         109
2216628 2216628 5126957 2015-09-24T08:22:44 2015-10-13T02:47:00 2015-10-13T02:47:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 101 MARKET ST, SAN FRANCISCO, CA, 94105 MARKET ST 6 Financial District CENTRAL 37.79333114624 -122.395889282227 POINT (-122.39588928 37.79333115) Phone   108 6 10 8 9 12 2 28,855 2 6 6   108   10             1         108
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
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
3322872 3322872 8661265 2018-02-21T13:32:00 2018-10-03T11:32:12 2018-10-03T11:32:12 Closed 2 inspector needs measure to find if a street tree or not. 8ft prow. 6312001 SFCC HOUSING AUTHORITY DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 101 SANTOS ST, SAN FRANCISCO, CA, 94134 SANTOS ST 10 Sunnydale INGLESIDE 37.71070098877 -122.418998718262 POINT (-122.41899872 37.71070099) Phone   74 9 9 40 8 9 4 309 7 39 39   74   9 16     16     2         74
3020388 3020388 7464393 2017-08-05T08:09:44 2017-08-12T10:33:00 2017-08-12T10:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 101 VALMAR TER, SAN FRANCISCO, CA, 94112 VALMAR TER 11 Excelsior INGLESIDE 37.725798393359 -122.424101453471 POINT (-122.42410145 37.72579839) Phone   90 9 1 7 6 9 4 309 7 5 5   90   1             1         90
2141149 2141149 4569458 2015-03-12T12:24:07 2015-09-28T02:27:00 2015-09-28T02:27:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1010 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 5 Cathedral Hill NORTHERN 37.782599708318 -122.42408138070299 POINT (-122.42408138 37.78259971) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100 1 11             2         100
617249 617249 10498491 2019-02-16T21:10:00 2019-02-23T09:53:00 2019-02-23T09:53:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1010 PORTOLA DR, SAN FRANCISCO, CA, 94127 PORTOLA DR 7 Laguna Honda INGLESIDE 37.741433275614 -122.45703903173799 POINT (-122.45703903 37.74143328) Web http://mobile311.sfgov.org/reports/10498491/photos 49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
437726 437726 10319150 2019-01-05T11:04:00 2019-02-26T10:23:34 2019-02-26T10:23:34 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1010 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 9 Mission MISSION 37.755911882039 -122.406485622968 POINT (-122.40648562 37.75591188) Mobile/Open311   54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10   3 10     2   3     54
2473645 2473645 5779804 2016-04-19T17:28:26 2016-05-06T12:34:38 2016-05-06T12:34:38 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1010 TERESITA BLVD, SAN FRANCISCO, CA, 94127 TERESITA BLVD 7 Miraloma Park INGLESIDE 37.734390258789 -122.44856262206999 POINT (-122.44856262 37.73439026) Web   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
1981898 1981898 4347561 2014-12-30T17:24:32 2015-01-07T12:33:00 2015-01-07T12:33:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1011 MENDELL ST, SAN FRANCISCO, CA, 94124 MENDELL ST 10 Bayview BAYVIEW 37.736790228475996 -122.388192233908 POINT (-122.38819223 37.73679023) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2169573 2169573 4780863 2015-05-27T18:22:58 2015-06-09T02:20:00 2015-06-09T02:20:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1012 POST ST, SAN FRANCISCO, CA, 94109 POST ST 3 Lower Nob Hill NORTHERN 37.787046935309 -122.41852017118299 POINT (-122.41852017 37.78704694) Phone   50 4 3 21 10 13 6 28,858 9 21 21   50   3         10   2         50
2229703 2229703 5059074 2015-09-02T10:48:43 2015-09-25T02:55:00 2015-09-25T02:55:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1012 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715156508934996 -122.471458768172 POINT (-122.47145877 37.71515651) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
637353 637353 10660847 2019-03-29T10:49:00 2019-04-02T13:19:19 2019-04-02T13:19:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1019 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Ashbury Heights PARK 37.764194488525 -122.44622802734399 POINT (-122.44622803 37.76419449) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114

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