calls

7,158 rows where Responsible_Agency = 2 sorted by rowid

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
322 322 5699261 2016-03-25T11:05:16 2016-04-12T02:41:00 2016-04-12T02:41:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3430 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.781599066561 -122.456177018353 POINT (-122.45617702 37.78159907) Phone   11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
453 453 11607582 2019-10-27T08:57:00 2019-10-28T10:23:02 2019-10-30T12:00:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2515 GOUGH ST, SAN FRANCISCO, CA, 94123 GOUGH ST 2 Pacific Heights NORTHERN 37.796714782715 -122.42711639404301 POINT (-122.42711639 37.79671478) Phone   102 4 6 13 1 13 6 57 9 17 17   102   6             1         102
480 480 11608308 2019-10-27T11:48:00 2019-10-28T09:59:39 2019-10-29T15:05:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 470 GROVE ST, SAN FRANCISCO, CA, 94102 GROVE ST 5 Hayes Valley NORTHERN 37.777782440186 -122.424278259277 POINT (-122.42427826 37.77778244) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
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
720 720 5686204 2016-03-21T14:47:48 2016-03-22T02:45:00 2016-03-22T02:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 600 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 5 Civic Center NORTHERN 37.779960461199 -122.42219602543301 POINT (-122.42219603 37.77996046) Phone   21 4 11 39 11 7 6 28,852 9 41 41   21 1 11     1       2   1     21
965 965 5683126 2016-03-20T14:26:08 2016-08-02T13:40:17 2016-08-02T13:40:17 Closed 2 see photo this is for landscape/gardeners DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of MALTA DR and OSHAUGHNESSY BLVD MALTA DR 8 Glen Park INGLESIDE 37.736519629304 -122.44368662151199 POINT (-122.44368662 37.73651963) Mobile/Open311 http://mobile311.sfgov.org/reports/5683126/photos 72 9 8 41 4 9 4 63 7 40 40   72   8             1         72
1079 1079 5682449 2016-03-20T09:14:10   2016-03-20T09:36:28 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 90 VERNA ST, SAN FRANCISCO, CA, 94127 VERNA ST 7 Miraloma Park INGLESIDE 37.734508514404 -122.448432922363 POINT (-122.44843292 37.73450851) Web   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
1307 1307 10732373 2019-04-15T13:46:00 2019-10-10T06:35:49 2019-10-10T06:35:49 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 640 EDNA ST, SAN FRANCISCO, CA, 94127 EDNA ST 7 Sunnyside INGLESIDE 37.732208251953004 -122.44717407226601 POINT (-122.44717407 37.73220825) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
1319 1319 10919880 2019-05-28T14:12:00 2019-10-07T11:45:00 2019-10-07T11:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of ALEMANY BLVD and JUNIPERO SERRA BLVD ALEMANY BLVD 7 Merced Heights TARAVAL 37.709087371826 -122.471015930176 POINT (-122.47101593 37.70908737) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
1348 1348 11371783 2019-09-05T08:50:00 2019-10-22T14:38:46 2019-10-22T14:38:46 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2163 39TH AVE, SAN FRANCISCO, CA, 94116 39TH AVE 4 Outer Sunset TARAVAL 37.746556894889004 -122.497386261935 POINT (-122.49738626 37.74655689) Mobile/Open311 http://mobile311.sfgov.org/reports/11371783/photos 39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
1537 1537 11242074 2019-08-08T07:48:00 2019-10-16T13:09:47 2019-10-16T13:09:47 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 423 MOUNT VERNON AVE, SAN FRANCISCO, CA, 94112 MOUNT VERNON AVE 11 Oceanview TARAVAL 37.718311026790005 -122.44877021076701 POINT (-122.44877021 37.71831103) Mobile/Open311 http://mobile311.sfgov.org/reports/11242074/photos 81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
2161 2161 10637100 2019-03-23T12:55:00 2019-08-14T13:55:41 2019-08-14T13:55:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3814 19TH AVE, SAN FRANCISCO, CA, 94132 19TH AVE 7 Stonestown TARAVAL 37.719253251059996 -122.47441993552499 POINT (-122.47441994 37.71925325) Mobile/Open311 http://mobile311.sfgov.org/reports/10637100/photos 42 10 8 41 4 9 5 64 8 40 40   42   8             1         42
4309 4309 11515675 2019-10-07T09:14:00   2019-10-07T10:00:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3274 26TH ST, SAN FRANCISCO, CA, 94110 26TH ST 9 Mission MISSION 37.749320983887 -122.41564178466801 POINT (-122.41564178 37.74932098) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
5384 5384 11585037 2019-10-22T11:06:00   2019-10-22T12:10:42 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of SUNSET BLVD and MORAGA ST SUNSET BLVD 4 Outer Sunset TARAVAL 37.755275726318004 -122.495361328125 POINT (-122.49536133 37.75527573) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
5504 5504 11585373 2019-10-22T11:55:00   2019-10-22T15:08:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2603 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789539033009994 -122.435863326343 POINT (-122.43586333 37.78953903) Mobile/Open311 http://mobile311.sfgov.org/reports/11585373/photos 102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
6165 6165 11525827 2019-10-09T07:53:00 2019-10-09T10:31:01 2019-10-09T10:31:01 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 576 DEWEY BLVD, SAN FRANCISCO, CA, 94116 DEWEY BLVD 7 Forest Hill TARAVAL 37.744289398193004 -122.463233947754 POINT (-122.46323395 37.7442894) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
6924 6924 11613883 2019-10-28T15:27:00   2019-10-28T16:00:20 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CESAR CHAVEZ ST and FLORIDA ST CESAR CHAVEZ ST 9 Peralta Heights MISSION 37.748332977295 -122.40964508056601 POINT (-122.40964508 37.74833298) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
7039 7039 11615523 2019-10-29T05:44:00 2019-10-29T11:25:34 2019-10-30T06:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of ELLSWORTH ST and BERNAL HEIGHTS BLVD ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742402488401 -122.414591414968 POINT (-122.41459141 37.74240249) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
7213 7213 5657133 2016-03-11T17:23:03 2016-03-21T12:11:00 2016-03-21T12:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of INGALLS ST and REVERE AVE INGALLS ST 10 Bayview BAYVIEW 37.7284840677 -122.384557302501 POINT (-122.3845573 37.72848407) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
7502 7502 7515634 2017-08-17T11:28:13 2017-08-21T00:00:00 2017-08-21T00:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NEWHALL ST and HUDSON AVE NEWHALL ST 10 Bayview BAYVIEW 37.740043997162 -122.388274912707 POINT (-122.38827491 37.740044) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7847 7847 5670544 2016-03-16T10:20:43 2016-05-27T02:47:00 2016-05-27T02:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of NOE ST and CESAR CHAVEZ ST NOE ST 8 Noe Valley MISSION 37.747433478415 -122.431476739669 POINT (-122.43147674 37.74743348) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
8099 8099 10703913 2019-04-08T17:50:00 2019-10-08T09:20:00 2019-10-08T09:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MINERVA ST and SUMMIT ST MINERVA ST 11 Oceanview TARAVAL 37.715793609619006 -122.453514099121 POINT (-122.4535141 37.71579361) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
8199 8199 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1031 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719181060791 -122.396774291992 POINT (-122.39677429 37.71918106) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
8251 8251 11312563 2019-08-23T10:17:00 2019-10-09T09:19:00 2019-10-09T09:19:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 853 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.757141205857 -122.427875488361 POINT (-122.42787549 37.75714121) Web   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
8309 8309 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and HUDSON AVE WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.733631134033 -122.382278442383 POINT (-122.38227844 37.73363113) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
9096 9096 11509026 2019-10-05T12:13:00 2019-10-08T10:10:27 2019-10-08T10:10:27 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of LAGUNA HONDA BLVD and 7TH AVE LAGUNA HONDA BLVD 7 Golden Gate Heights PARK 37.754787445068004 -122.46363067626999 POINT (-122.46363068 37.75478745) Phone   44 7 8 14 4 1 8 56 5 12 12   44   8             1         44
9194 9194 11510552 2019-10-05T18:34:00 2019-10-08T11:42:53 2019-10-08T11:42:53 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CAPITOL AVE and HOLLOWAY AVE CAPITOL AVE 7 Ingleside TARAVAL 37.7218421 -122.45922900000001 POINT (-122.459229 37.7218421) Web   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19     2         64
10529 10529 11520660 2019-10-08T07:30:00 2019-10-08T15:41:11 2019-10-08T15:41:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1686 BRYANT ST, SAN FRANCISCO, CA, 94103 BRYANT ST 9 Mission MISSION 37.765704993828 -122.410897103119 POINT (-122.4108971 37.76570499) Web http://mobile311.sfgov.org/reports/11520660/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
10942 10942 11521677 2019-10-08T09:52:00 2019-10-08T15:40:23 2019-10-08T15:40:23 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 269 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 9 Mission MISSION 37.768268077669 -122.419259715939 POINT (-122.41925972 37.76826808) Mobile/Open311 http://mobile311.sfgov.org/reports/11521677/photos 53 3 2 20 7 8 7 28,853 4 19 19 12 53 1 2 14   3 14     2   3     53
10953 10953 11521686 2019-10-08T09:53:00 2019-10-08T10:04:41 2019-10-08T10:04:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1265 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Parnassus Heights PARK 37.7604063 -122.45195430000001 POINT (-122.4519543 37.7604063) Web http://mobile311.sfgov.org/reports/11521686/photos 110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
13519 13519 10990704 2019-06-13T09:23:00 2019-10-09T14:44:00 2019-10-09T14:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of PALMETTO AVE and HEAD ST PALMETTO AVE 7 Merced Heights TARAVAL 37.71076965332 -122.46436309814501 POINT (-122.4643631 37.71076965) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
13542 13542 4169880 2014-11-02T17:40:01 2014-11-29T10:07:40 2014-11-29T10:07:40 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
13892 13892 11610663 2019-10-28T07:16:00 2019-10-28T10:01:57 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 9TH AVE and ANZA ST 9TH AVE 1 Inner Richmond RICHMOND 37.778945922852 -122.467353820801 POINT (-122.46735382 37.77894592) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
14049 14049 5674640 2016-03-17T11:39:27 2016-05-27T02:38:00 2016-05-27T02:38:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
14737 14737 11246895 2019-08-09T07:38:00 2019-10-03T09:33:00 2019-10-03T09:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 430 BURNETT AVE, SAN FRANCISCO, CA, 94131 BURNETT AVE 8 Upper Market PARK 37.755022197997 -122.44440626364401 POINT (-122.44440626 37.7550222) Mobile/Open311 http://mobile311.sfgov.org/reports/11246895/photos 51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
14796 14796 11113957 2019-07-11T10:51:00 2019-10-01T11:54:00 2019-10-01T11:54:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of FRANCISCO ST and POWELL ST FRANCISCO ST 3 North Beach CENTRAL 37.80489730835 -122.411766052246 POINT (-122.41176605 37.80489731) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
15598 15598 11510224 2019-10-05T17:03:00 2019-10-06T13:08:38 2019-10-06T13:08:38 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1079 CAPITOL AVE, SAN FRANCISCO, CA, 94112 CAPITOL AVE 11 Ingleside TARAVAL 37.721374511719 -122.45970916748001 POINT (-122.45970917 37.72137451) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
17193 17193 10820153 2019-05-05T14:27:00 2019-10-21T13:17:00 2019-10-21T13:17:00 Closed 2 Notes:dead pine with missing top. BUF Action:Remove Tree. Notes:dead pine with missing top. BUF Action:Remove Tree. Notes:dead pine with missing top :: Closed By CMMS SO 1143263. BUF Action:Remove Tree. date completed - 10/21/2019. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2266 9TH AVE, SAN FRANCISCO, CA, 94116 9TH AVE 7 Forest Hill TARAVAL 37.747303009033 -122.466278076172 POINT (-122.46627808 37.74730301) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
17480 17480 10998649 2019-06-14T17:58:00 2019-07-16T12:33:00 2019-07-16T12:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BAY SHORE BLVD and CARROLL AVE BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.730659484863 -122.40340423584 POINT (-122.40340424 37.73065948) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
18140 18140 11155298 2019-07-20T11:03:00   2019-09-21T11:11:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BRADFORD ST and TOMPKINS AVE BRADFORD ST 9 Bernal Heights INGLESIDE 37.73685836792 -122.40975952148399 POINT (-122.40975952 37.73685837) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
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
19369 19369 5657312 2016-03-11T18:38:06 2016-06-14T01:00:00 2016-06-14T01:00:00 Closed 2 1098 DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CHENERY ST and DIAMOND ST CHENERY ST 8 Glen Park INGLESIDE 37.734631476107005 -122.433860323461 POINT (-122.43386032 37.73463148) Mobile/Open311 http://mobile311.sfgov.org/reports/5657312/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
20009 20009 5651481 2016-03-10T09:41:58 2016-06-24T08:37:00 2016-06-24T08:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 222 MONCADA WAY, SAN FRANCISCO, CA, 94127 MONCADA WAY 7 Ingleside Terraces TARAVAL 37.727577209473 -122.468681335449 POINT (-122.46868134 37.72757721) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
20043 20043 5651319 2016-03-10T09:12:49 2016-04-26T02:42:42 2016-04-26T02:42:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
20096 20096 5650882 2016-03-10T06:49:11 2016-03-11T03:02:00 2016-03-11T03:02:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 8TH AVE and JUDAH ST 8TH AVE 5 Inner Sunset TARAVAL 37.762222290039 -122.465118408203 POINT (-122.46511841 37.76222229) Phone   109 10 11 14 11 1 5 56 8 12 12   109   11             1         109
20169 20169 5650355 2016-03-09T18:12:51 2016-04-07T08:05:00 2016-04-07T08:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of MONTEREY BLVD and HAZELWOOD AVE MONTEREY BLVD 7 Westwood Park INGLESIDE 37.731464385986 -122.454917907715 POINT (-122.45491791 37.73146439) Web   71 9 8 41 4 9 4 59 7 40 40   71   8             1         71
20657 20657 11148097 2019-07-18T15:57:00   2019-10-10T11:08:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTCALM ST and WRIGHT ST MONTCALM ST 9 Peralta Heights INGLESIDE 37.747459411621 -122.405921936035 POINT (-122.40592194 37.74745941) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
21108 21108 11523861 2019-10-08T15:19:00   2019-10-18T13:37:22 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 17TH AVE and NORIEGA ST 17TH AVE 7 Golden Gate Heights TARAVAL 37.754333496094 -122.474334716797 POINT (-122.47433472 37.7543335) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
21222 21222 11526457 2019-10-09T09:23:00 2019-10-10T14:00:00 2019-10-10T14:00:00 Closed 2 Notes:Tree fell over now gone . BUF Action:Inspect. date completed - 10/10/2019. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 76 WINFIELD ST, SAN FRANCISCO, CA, 94110 WINFIELD ST 9 Bernal Heights INGLESIDE 37.744054799999994 -122.41783000000001 POINT (-122.41783 37.7440548) Web http://mobile311.sfgov.org/reports/11526457/photos 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
21857 21857 11531342 2019-10-10T09:29:00   2019-10-10T10:20:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 122 ROUSSEAU ST, SAN FRANCISCO, CA, 94112 ROUSSEAU ST 8 St. Mary's Park INGLESIDE 37.732772827148 -122.43030548095699 POINT (-122.43030548 37.73277283) Phone   93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
22255 22255 11533385 2019-10-10T14:39:00 2019-10-28T15:00:47 2019-10-28T15:40:12 Closed 2 trees not dead just poor structure. only trees on wawona were posted and they are alive and did not fail despite past topping prior to city maintenance they will remove stump will call for brush pick up DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 201 VICENTE ST, SAN FRANCISCO, CA, 94127 VICENTE ST 7 West Portal TARAVAL 37.739887237549 -122.468460083008 POINT (-122.46846008 37.73988724) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
23031 23031 11627389 2019-10-31T14:02:00   2019-10-31T17:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ANZA ST and ROSSI AVE ANZA ST 1 Lone Mountain RICHMOND 37.779693603516 -122.456497192383 POINT (-122.45649719 37.7796936) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
23049 23049 11254502 2019-08-10T18:15:00 2019-09-18T14:46:00 2019-09-18T14:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BALBOA ST and 26TH AVE BALBOA ST 1 Outer Richmond RICHMOND 37.776252746581996 -122.48553466796899 POINT (-122.48553467 37.77625275) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
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
25077 25077 11593409 2019-10-23T19:41:00 2019-10-25T13:36:07 2019-10-25T13:36:07 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 269 MOULTRIE ST, SAN FRANCISCO, CA, 94110 MOULTRIE ST 9 Bernal Heights INGLESIDE 37.7407513 -122.415568 POINT (-122.415568 37.7407513) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
26475 26475 11598258 2019-10-24T20:18:00 2019-10-25T15:16:54 2019-10-25T15:16:54 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2259 9TH AVE, SAN FRANCISCO, CA, 94116 9TH AVE 7 Golden Gate Heights TARAVAL 37.747402191162 -122.46654510498001 POINT (-122.4665451 37.74740219) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
26794 26794 11599196 2019-10-25T08:05:00   2019-10-31T17:15:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 150 FRANCE AVE, SAN FRANCISCO, CA, 94112 FRANCE AVE 11 Excelsior INGLESIDE 37.719418262167004 -122.43706882942699 POINT (-122.43706883 37.71941826) Mobile/Open311 http://mobile311.sfgov.org/reports/11599196/photos 90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4           2         90
27709 27709 11601003 2019-10-25T12:38:00   2019-10-25T13:35:51 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 371 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Duboce Triangle PARK 37.771114349365 -122.42974853515601 POINT (-122.42974854 37.77111435) Phone   28 7 11 9 11 7 6 29,492 9 10 10   28   11             1         28
27710 27710 11601004 2019-10-25T12:38:00   2019-10-25T13:35:50 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 301 EXECUTIVE PARK BLVD, SAN FRANCISCO, CA, 94134 EXECUTIVE PARK BLVD 10 Candlestick Point SRA BAYVIEW 37.711143493652 -122.390769958496 POINT (-122.39076996 37.71114349) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
31373 31373 11607221 2019-10-27T06:20:00 2019-10-28T10:03:55 2019-10-31T22:30:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 753 SHRADER ST, SAN FRANCISCO, CA, 94117 SHRADER ST 5 Cole Valley PARK 37.767768859863 -122.451675415039 POINT (-122.45167542 37.76776886) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
31410 31410 11607379 2019-10-27T08:01:00 2019-10-28T10:23:13 2019-10-30T11:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 74 CERVANTES BLVD, SAN FRANCISCO, CA, 94123 CERVANTES BLVD 2 Marina NORTHERN 37.803726196289 -122.43834686279301 POINT (-122.43834686 37.8037262) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
31457 31457 11607529 2019-10-27T08:43:00 2019-10-29T13:55:31 2019-10-29T13:55:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3723 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754257202148 -122.441749572754 POINT (-122.44174957 37.7542572) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31458 31458 11607532 2019-10-27T08:44:00 2019-10-28T10:07:35 2019-10-29T13:54:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3721 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754318237305 -122.44171142578101 POINT (-122.44171143 37.75431824) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31466 31466 11607558 2019-10-27T08:50:00 2019-10-28T10:07:30 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MARKET ST and SHORT ST MARKET ST 8 Eureka Valley MISSION 37.757797241211 -122.443214416504 POINT (-122.44321442 37.75779724) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
31467 31467 11607563 2019-10-27T08:52:00 2019-10-28T10:07:40 2019-10-29T13:57:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3701 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754543304443004 -122.441619873047 POINT (-122.44161987 37.7545433) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31489 31489 11607622 2019-10-27T09:07:00 2019-10-28T09:51:13 2019-10-28T10:40:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 279 MONTEREY BLVD, SAN FRANCISCO, CA, 94131 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731407165527 -122.441513061523 POINT (-122.44151306 37.73140717) Phone   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
31532 31532 11607717 2019-10-27T09:30:00 2019-10-28T09:22:32 2019-10-28T10:40:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 15 CAINE AVE, SAN FRANCISCO, CA, 94112 CAINE AVE 11 Oceanview TARAVAL 37.7178169 -122.4498754 POINT (-122.4498754 37.7178169) Web http://mobile311.sfgov.org/reports/11607717/photos 81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
31654 31654 11608113 2019-10-27T10:58:00 2019-10-28T09:32:08 2019-10-28T10:45:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 8 SAN LORENZO WAY, SAN FRANCISCO, CA, 94127 SAN LORENZO WAY 7 St. Francis Wood TARAVAL 37.739846091753 -122.464244971166 POINT (-122.46424497 37.73984609) Mobile/Open311 http://mobile311.sfgov.org/reports/11608113/photos 116 10 8 41 4 1 5 59 8 40 40   116   8             1         116
31811 31811 11608711 2019-10-27T13:20:00 2019-10-28T09:24:53 2019-10-29T15:15:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1275 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Parnassus Heights PARK 37.7601349 -122.451899 POINT (-122.451899 37.7601349) Web http://mobile311.sfgov.org/reports/11608711/photos 110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
31966 31966 11609120 2019-10-27T14:51:00 2019-10-28T09:48:39 2019-10-31T22:35:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2249 17TH AVE, SAN FRANCISCO, CA, 94116 17TH AVE 7 Golden Gate Heights TARAVAL 37.745956420898 -122.473823547363 POINT (-122.47382355 37.74595642) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
31976 31976 11609142 2019-10-27T14:57:00 2019-10-28T09:51:34 2019-10-28T10:40:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 141 ASHTON AVE, SAN FRANCISCO, CA, 94112 ASHTON AVE 11 Ingleside TARAVAL 37.72075 -122.46234399999999 POINT (-122.462344 37.72075) Mobile/Open311 http://mobile311.sfgov.org/reports/11609142/photos 64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
31978 31978 11609144 2019-10-27T14:57:00 2019-10-28T09:22:41 2019-10-28T10:50:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 462 HEAD ST, SAN FRANCISCO, CA, 94132 HEAD ST 11 Merced Heights TARAVAL 37.715476989746 -122.46427154541 POINT (-122.46427155 37.71547699) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
32051 32051 11609326 2019-10-27T15:44:00 2019-10-28T09:22:56 2019-10-30T07:00:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1421 10TH AVE, SAN FRANCISCO, CA, 94122 10TH AVE 7 Inner Sunset TARAVAL 37.761684417725 -122.46736145019501 POINT (-122.46736145 37.76168442) Phone   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
32582 32582 11610643 2019-10-28T07:11:00 2019-10-28T10:02:03 2019-10-29T15:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 901 BALBOA ST, SAN FRANCISCO, CA, 94118 BALBOA ST 1 Inner Richmond RICHMOND 37.776889801025 -122.468505859375 POINT (-122.46850586 37.7768898) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
32883 32883 11611273 2019-10-28T08:58:00 2019-10-28T09:26:08 2019-10-28T10:50:04 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 276 ONEIDA AVE, SAN FRANCISCO, CA, 94112 ONEIDA AVE 11 Cayuga INGLESIDE 37.721931010872005 -122.443419468787 POINT (-122.44341947 37.72193101) Web http://mobile311.sfgov.org/reports/11611273/photos 80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
33010 33010 11611610 2019-10-28T09:46:00 2019-10-28T10:19:31 2019-10-31T22:35:42 Closed 2 branches down Clean up tree crews are cleaning up all over the city. they will try to get there when worst is cleaned up DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 728 FAXON AVE, SAN FRANCISCO, CA, 94112 FAXON AVE 7 Westwood Park INGLESIDE 37.726413333333 -122.45995333333299 POINT (-122.45995333 37.72641333) Mobile/Open311 http://mobile311.sfgov.org/reports/11611610/photos 71 9 8 41 4 9 4 28,861 7 40 40   71   8             1         71
33327 33327 11612501 2019-10-28T11:54:00 2019-10-28T12:08:30 2019-10-30T11:43:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1360 TAYLOR ST, SAN FRANCISCO, CA, 94108 TAYLOR ST 3 Nob Hill CENTRAL 37.794998 -122.413122 POINT (-122.413122 37.794998) Mobile/Open311 http://mobile311.sfgov.org/reports/11612501/photos 16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
33561 33561 11613220 2019-10-28T13:50:00 2019-10-29T09:30:57 2019-10-29T14:10:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 959 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Buena Vista PARK 37.7709491 -122.43798740000001 POINT (-122.4379874 37.7709491) Web   112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
33916 33916 11614275 2019-10-28T16:36:00   2019-10-28T17:10:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CESAR CHAVEZ ST and NOE ST CESAR CHAVEZ ST 8 Noe Valley MISSION 37.74743270874 -122.43147277831999 POINT (-122.43147278 37.74743271) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
34792 34792 11616238 2019-10-29T08:47:00 2019-10-29T09:30:34 2019-10-30T11:55:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3699 CLAY ST, SAN FRANCISCO, CA, 94118 CLAY ST 2 Presidio Heights RICHMOND 37.788216471423 -122.45355627644399 POINT (-122.45355628 37.78821647) Mobile/Open311 http://mobile311.sfgov.org/reports/11616238/photos 10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
34793 34793 11616241 2019-10-29T08:47:00   2019-10-31T17:15:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BERTHA LN and HARBOR RD BERTHA LN 10 Bayview BAYVIEW 37.7340377 -122.38134070000001 POINT (-122.3813407 37.7340377) Web http://mobile311.sfgov.org/reports/11616241/photos 86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
35411 35411 11617730 2019-10-29T12:24:00   2019-10-29T13:20:06 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 20TH ST and CHURCH ST 20TH ST 8 Dolores Heights MISSION 37.758087158203004 -122.428047180176 POINT (-122.42804718 37.75808716) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
35971 35971 11619231 2019-10-29T16:23:00   2019-10-29T17:05:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 215 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710277557373 -122.46923065185499 POINT (-122.46923065 37.71027756) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35976 35976 11619243 2019-10-29T16:25:00   2019-10-29T17:10:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 130 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711681365967 -122.46935272216801 POINT (-122.46935272 37.71168137) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35984 35984 11619257 2019-10-29T16:26:00 2019-10-30T08:57:16 2019-10-30T08:57:16 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 134 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711620330811 -122.46935272216801 POINT (-122.46935272 37.71162033) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35985 35985 11619258 2019-10-29T16:26:00   2019-10-31T17:15:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 822 BRAZIL AVE, SAN FRANCISCO, CA, 94112 BRAZIL AVE 11 Excelsior INGLESIDE 37.721399744076 -122.42801561963002 POINT (-122.42801562 37.72139974) Mobile/Open311 http://mobile311.sfgov.org/reports/11619258/photos 90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
36243 36243 11619759 2019-10-29T18:04:00   2019-10-30T11:30:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of NORMANDIE TER and VALLEJO ST NORMANDIE TER 2 Pacific Heights NORTHERN 37.794505900000004 -122.44088870000002 POINT (-122.4408887 37.7945059) Web   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
36425 36425 11620103 2019-10-29T19:42:00   2019-10-30T10:40:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 176 LEE AVE, SAN FRANCISCO, CA, 94112 LEE AVE 11 Ingleside TARAVAL 37.721404619409 -122.454032478505 POINT (-122.45403248 37.72140462) Mobile/Open311 http://mobile311.sfgov.org/reports/11620103/photos 64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
36620 36620 11620630 2019-10-30T06:19:00   2019-10-30T11:30:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 58 ELLSWORTH ST, SAN FRANCISCO, CA, 94110 ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742154 -122.41458700000001 POINT (-122.414587 37.742154) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
36878 36878 11621063 2019-10-30T08:24:00 2019-10-30T22:15:34 2019-10-30T22:15:34 Closed 2 Request is a duplicate and has been previously reported as 11619759 DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2646 VALLEJO ST, SAN FRANCISCO, CA, 94123 VALLEJO ST 2 Pacific Heights NORTHERN 37.794609069824 -122.44082641601601 POINT (-122.44082642 37.79460907) Phone   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
36983 36983 11621288 2019-10-30T08:57:00   2019-10-30T10:50:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1319 25TH AVE, SAN FRANCISCO, CA, 94122 25TH AVE 4 Outer Sunset TARAVAL 37.76285649475 -122.483562867769 POINT (-122.48356287 37.76285649) Mobile/Open311 http://mobile311.sfgov.org/reports/11621288/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
37045 37045 11621408 2019-10-30T09:15:00   2019-10-30T10:55:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 99 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 MAGELLAN AVE 7 Forest Hill TARAVAL 37.748896 -122.46023600000001 POINT (-122.460236 37.748896) Mobile/Open311 http://mobile311.sfgov.org/reports/11621408/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
37533 37533 11622753 2019-10-30T13:44:00   2019-10-30T15:45:16 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2900 BUSH ST, SAN FRANCISCO, CA, 94115 BUSH ST 2 Lower Pacific Heights RICHMOND 37.785705 -122.44516899999999 POINT (-122.445169 37.785705) Mobile/Open311 http://mobile311.sfgov.org/reports/11622753/photos 103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
38735 38735 11625346 2019-10-31T08:07:00   2019-10-31T22:33:07 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 200 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.776214335043 -122.420972473919 POINT (-122.42097247 37.77621434) Mobile/Open311 http://mobile311.sfgov.org/reports/11625346/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
38779 38779 11625433 2019-10-31T08:26:00   2019-10-31T08:55:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GILROY ST and INGERSON AVE GILROY ST 10 Bret Harte BAYVIEW 37.71688079834 -122.38913726806601 POINT (-122.38913727 37.7168808) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
39250 39250 11626464 2019-10-31T11:19:00   2019-10-31T22:36:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 210 JOICE ST, SAN FRANCISCO, CA, 94108 JOICE ST 3 Nob Hill CENTRAL 37.793313299999994 -122.4084815 POINT (-122.4084815 37.7933133) Web http://mobile311.sfgov.org/reports/11626464/photos 16 6 3 6 10 3 1 28,857 1 4 4 5 16   3 5     5     2         16
39536 39536 11627160 2019-10-31T13:24:00   2019-10-31T14:00:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of POPLAR ST and 26TH ST POPLAR ST 8 Mission MISSION 37.748878479004 -122.420829772949 POINT (-122.42082977 37.74887848) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
39894 39894 11628119 2019-10-31T16:11:00   2019-10-31T22:37:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1309 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.729553222656 -122.433395385742 POINT (-122.43339539 37.72955322) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
41184 41184 11482592 2019-09-29T20:43:00 2019-10-09T09:51:44 2019-10-09T09:51:44 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 - Damaged_Tree 1 Damaged_vandalism 1207 38TH AVE, SAN FRANCISCO, CA, 94122 38TH AVE 4 Outer Sunset TARAVAL 37.764391081529006 -122.497651712234 POINT (-122.49765171 37.76439108) Web http://mobile311.sfgov.org/reports/11482592/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
43463 43463 11566340 2019-10-17T23:13:00 2019-10-29T12:30:27 2019-10-30T06:00:30 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CORTLAND AVE and PROSPECT AVE CORTLAND AVE 9 Holly Park INGLESIDE 37.740241 -122.42087920000002 POINT (-122.4208792 37.740241) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83

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