calls

7,158 rows where Responsible_Agency = 2 sorted by Status_Notes

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
44004 44004 7091066 2017-04-28T08:45:47 2017-04-28T03:37:00 2017-04-28T03:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GRAYSTONE TER and IRON ALY GRAYSTONE TER 8 Clarendon Heights PARK 37.757270904363 -122.44496649598699 POINT (-122.4449665 37.7572709) Phone   47 7 5 5 5 2 8 28,862 5 3 3   47   5             1         47
45763 45763 10759845 2019-04-22T06:50:00 2019-09-26T15:09:00 2019-09-26T15:09:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LAKE MERCED BLVD and SKYLINE BLVD LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.732269287109 -122.49810791015601 POINT (-122.49810791 37.73226929) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
46094 46094 11230262 2019-08-05T16:14:00 2019-09-27T14:22:00 2019-09-27T14:22:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 162 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.744312286377 -122.458251953125 POINT (-122.45825195 37.74431229) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
46972 46972 11407269 2019-09-12T14:52:00 2019-09-24T09:35:00 2019-09-24T09:35:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WEST PORTAL AVE and PORTOLA DR WEST PORTAL AVE 7 Merced Manor TARAVAL 37.734706878662 -122.471572875977 POINT (-122.47157288 37.73470688) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
48270 48270 11444221 2019-09-20T16:44:00 2019-09-26T14:24:00 2019-09-26T14:24:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 501 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763191223145 -122.40721893310499 POINT (-122.40721893 37.76319122) Phone http://mobile311.sfgov.org/reports/11444221/photos 54 3 9 20 8 8 7 28,859 4 19 19   54   9     3   15   2   3     54
51217 51217 11461057 2019-09-24T16:26:00 2019-10-16T14:52:02 2019-10-16T14:52:02 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of PERALTA AVE and YORK ST PERALTA AVE 9 Peralta Heights INGLESIDE 37.747470299999996 -122.4073159 POINT (-122.4073159 37.7474703) Web http://mobile311.sfgov.org/reports/11461057/photos 60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
52932 52932 11465668 2019-09-25T15:46:00 2019-09-26T13:10:44 2019-09-26T13:10:44 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 550 10TH ST, SAN FRANCISCO, CA, 94103 10TH ST 6 South of Market SOUTHERN 37.769683333333 -122.40899666666701 POINT (-122.40899667 37.76968333) Mobile/Open311 http://mobile311.sfgov.org/reports/11465668/photos 32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
55419 55419 11473326 2019-09-27T11:04:00 2019-09-27T11:56:13 2019-09-27T11:56:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 89 CASTENADA AVE, SAN FRANCISCO, CA, 94116 CASTENADA AVE 7 Forest Hill TARAVAL 37.749404882084 -122.461666656815 POINT (-122.46166666 37.74940488) Mobile/Open311 http://mobile311.sfgov.org/reports/11473326/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
59717 59717 11500719 2019-10-03T14:24:00 2019-10-04T14:52:08 2019-10-04T14:52:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 243 GRAFTON AVE, SAN FRANCISCO, CA, 94112 GRAFTON AVE 11 Ingleside TARAVAL 37.719921112061 -122.455879211426 POINT (-122.45587921 37.71992111) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
60119 60119 10662348 2019-03-29T15:21:00 2019-04-04T09:14:00 2019-04-04T09:14:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1707 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 2 Pacific Heights NORTHERN 37.789374087041004 -122.425569947923 POINT (-122.42556995 37.78937409) Mobile/Open311 http://mobile311.sfgov.org/reports/10662348/photos 102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
60927 60927 11329362 2019-08-27T09:21:00 2019-10-15T06:09:33 2019-10-15T06:09:33 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 343 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.732569405681 -122.497712046483 POINT (-122.49771205 37.73256941) Mobile/Open311 http://mobile311.sfgov.org/reports/11329362/photos 43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
60979 60979 11520858 2019-10-08T08:02:00 2019-10-16T10:07:11 2019-10-16T10:07:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 466 HEARST AVE, SAN FRANCISCO, CA, 94112 HEARST AVE 7 Sunnyside INGLESIDE 37.730670638521 -122.448080930124 POINT (-122.44808093 37.73067064) Mobile/Open311 http://mobile311.sfgov.org/reports/11520858/photos 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
61031 61031 11530813 2019-10-10T08:17:00 2019-10-15T11:26:00 2019-10-15T11:26:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 919 ROCKDALE DR, SAN FRANCISCO, CA, 94127 ROCKDALE DR 7 Miraloma Park INGLESIDE 37.740951538086 -122.45447540283199 POINT (-122.4544754 37.74095154) Phone https://goo.gl/maps/wtv83isidzk5UNfw5 72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
61999 61999 11467401 2019-09-26T07:50:00 2019-10-01T13:58:31 2019-10-01T13:58:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 2746 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 9 Portola BAYVIEW 37.727073 -122.4034 POINT (-122.4034 37.727073) Mobile/Open311 http://mobile311.sfgov.org/reports/11467401/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
64043 64043 10833228 2019-05-08T09:31:00 2019-09-30T14:46:56 2019-09-30T14:46:56 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SKYLINE BLVD and JOHN MUIR DR SKYLINE BLVD 7 Lakeshore TARAVAL 37.718955993652 -122.50022125244101 POINT (-122.50022125 37.71895599) Phone   43 10 8 16 4 1 5   8 14 14   43   8             2         43
64066 64066 10983555 2019-06-11T16:49:00 2019-09-30T14:45:17 2019-09-30T14:45:17 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
64140 64140 11267867 2019-08-13T17:32:00 2019-09-30T13:36:08 2019-09-30T13:36:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3248 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94110 CESAR CHAVEZ ST 9 Mission MISSION 37.748308663437 -122.415241715456 POINT (-122.41524172 37.74830866) Mobile/Open311 http://mobile311.sfgov.org/reports/11267867/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
64200 64200 11595511 2019-10-24T11:21:00 2019-10-30T06:18:00 2019-10-30T06:18:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 264 MOULTRIE ST, SAN FRANCISCO, CA, 94110 MOULTRIE ST 9 Bernal Heights INGLESIDE 37.7408474 -122.4159219 POINT (-122.4159219 37.7408474) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
64273 64273 11403356 2019-09-11T18:49:00 2019-09-30T13:28:52 2019-09-30T13:28:52 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 380 BEACON ST, SAN FRANCISCO, CA, 94131 BEACON ST 8 Fairmount INGLESIDE 37.741282785742 -122.434022088536 POINT (-122.43402209 37.74128279) Mobile/Open311 http://mobile311.sfgov.org/reports/11403356/photos 59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
64725 64725 10994519 2019-06-13T23:55:00 2019-10-16T13:42:56 2019-10-16T13:42:56 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 736 DELANO AVE, SAN FRANCISCO, CA, 94112 DELANO AVE 11 Cayuga INGLESIDE 37.7196195 -122.44565120000001 POINT (-122.4456512 37.7196195) Web http://mobile311.sfgov.org/reports/10994519/photos 80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
64776 64776 11248436 2019-08-09T11:42:00 2019-10-16T13:07:12 2019-10-16T13:07:12 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 90 VALMAR TER, SAN FRANCISCO, CA, 94112 VALMAR TER 11 Excelsior INGLESIDE 37.726118400000004 -122.4240472 POINT (-122.4240472 37.7261184) Web   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
64814 64814 11300212 2019-08-20T18:01:00 2019-10-18T08:08:00 2019-10-18T08:08:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 714 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.771732 -122.43398300000001 POINT (-122.433983 37.771732) Mobile/Open311 http://mobile311.sfgov.org/reports/11300212/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
64898 64898 11470919 2019-09-26T17:40:00 2019-09-30T09:34:02 2019-09-30T09:34:02 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 229 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.77590078334 -122.411010756952 POINT (-122.41101076 37.77590078) Mobile/Open311 http://mobile311.sfgov.org/reports/11470919/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
64923 64923 11471364 2019-09-26T20:01:00 2019-09-30T13:27:09 2019-09-30T13:27:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 716 DUBOCE AVE, SAN FRANCISCO, CA, 94117 DUBOCE AVE 8 Duboce Triangle PARK 37.769093 -122.43552 POINT (-122.43552 37.769093) Mobile/Open311 http://mobile311.sfgov.org/reports/11471364/photos 28 7 5 3 5 15 8 29,492 5 9 9   28   5             1   5     28
65081 65081 11473238 2019-09-27T10:51:00 2019-09-30T09:42:35 2019-09-30T09:42:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DEMING ST and URANUS TER DEMING ST 8 Eureka Valley PARK 37.760478973389 -122.4453125 POINT (-122.4453125 37.76047897) Phone   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
65091 65091 11473317 2019-09-27T11:02:00 2019-09-30T09:33:40 2019-09-30T09:33:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 239 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.775830207219 -122.410985968053 POINT (-122.41098597 37.77583021) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
65494 65494 11477609 2019-09-28T12:18:00 2019-09-30T09:30:00 2019-09-30T09:30:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 133 LOS PALMOS DR, SAN FRANCISCO, CA, 94127 LOS PALMOS DR 7 Miraloma Park INGLESIDE 37.735614776611 -122.448280334473 POINT (-122.44828033 37.73561478) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
65630 65630 11478446 2019-09-28T15:13:00 2019-09-30T09:18:51 2019-09-30T09:18:51 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 491 LINDEN ST, SAN FRANCISCO, CA, 94102 LINDEN ST 5 Hayes Valley NORTHERN 37.775957399999996 -122.4258216 POINT (-122.4258216 37.7759574) Web   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
65949 65949 11481125 2019-09-29T12:26:00 2019-09-30T09:26:36 2019-09-30T09:26:36 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1246 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Ashbury Heights PARK 37.760912899999994 -122.45157830000001 POINT (-122.4515783 37.7609129) Web http://mobile311.sfgov.org/reports/11481125/photos 114 7 11 14 11 15 8 29,492 5 12 12   114   11             1         114
67523 67523 11552652 2019-10-15T10:31:00 2019-10-16T08:53:28 2019-10-16T08:53:28 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 777 ALABAMA ST, SAN FRANCISCO, CA, 94110 ALABAMA ST 9 Mission MISSION 37.759469 -122.41153600000001 POINT (-122.411536 37.759469) Mobile/Open311 http://mobile311.sfgov.org/reports/11552652/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
67807 67807 11555621 2019-10-15T18:25:00 2019-10-16T08:53:45 2019-10-16T08:53:45 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2386 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Corona Heights PARK 37.765838333333 -122.436791666667 POINT (-122.43679167 37.76583833) Mobile/Open311 http://mobile311.sfgov.org/reports/11555621/photos 113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
68499 68499 11558975 2019-10-16T13:25:00 2019-10-29T12:31:47 2019-10-30T06:00:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3530 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758721760509 -122.41976916801399 POINT (-122.41976917 37.75872176) Mobile/Open311 http://mobile311.sfgov.org/reports/11558975/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
68655 68655 11492246 2019-10-01T17:57:00 2019-10-09T15:57:04 2019-10-09T15:57:04 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 125 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Mission MISSION 37.752734483255 -122.421491900573 POINT (-122.4214919 37.75273448) Mobile/Open311 http://mobile311.sfgov.org/reports/11492246/photos 53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
71066 71066 11405513 2019-09-12T10:17:00 2019-10-01T09:59:00 2019-10-01T09:59:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 4 TIOGA AVE, SAN FRANCISCO, CA, 94134 TIOGA AVE 10 Visitacion Valley INGLESIDE 37.715847015380994 -122.402633666992 POINT (-122.40263367 37.71584702) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
71254 71254 11456489 2019-09-23T18:12:00 2019-10-01T10:04:00 2019-10-01T10:04:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of MISSION ST and 23RD ST MISSION ST 9 Mission MISSION 37.753837585449 -122.418594360352 POINT (-122.41859436 37.75383759) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
71634 71634 11602959 2019-10-25T18:55:00 2019-10-28T10:15:21 2019-10-29T13:58:52 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 301 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Mission Dolores MISSION 37.764416383615 -122.42629976023198 POINT (-122.42629976 37.76441638) Mobile/Open311   37 3 5 5 5 8 7 28,859 4 3 3   37   5             1   5     37
72162 72162 11608820 2019-10-27T13:44:00 2019-10-28T09:23:39 2019-10-29T15:15:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 8TH AVE and IRVING ST 8TH AVE 5 Inner Sunset TARAVAL 37.764083862305 -122.46524810791 POINT (-122.46524811 37.76408386) Phone   109 10 11 14 11 11 5 56 8 12 12 2 109   11 2     2     1         109
72335 72335 11557210 2019-10-16T09:20:00 2019-10-23T13:03:00 2019-10-23T13:03:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of DOLORES ST and VALLEY ST DOLORES ST 8 Noe Valley INGLESIDE 37.744636535645 -122.424461364746 POINT (-122.42446136 37.74463654) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
72447 72447 11564383 2019-10-17T14:10:00 2019-10-19T08:12:00 2019-10-19T08:12:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of ELLIS ST and LAGUNA ST ELLIS ST 5 Cathedral Hill NORTHERN 37.782985687255994 -122.42758178710899 POINT (-122.42758179 37.78298569) Phone   100 4 11 39 11 7 6 28,858 9 41 41 8 100   11 9     9     2         100
72934 72934 11400302 2019-09-11T10:27:00 2019-10-03T10:22:22 2019-10-03T10:22:22 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1133 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776119 -122.408597 POINT (-122.408597 37.776119) Mobile/Open311 http://mobile311.sfgov.org/reports/11400302/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
72937 72937 11400670 2019-09-11T11:15:00 2019-10-03T10:21:15 2019-10-03T10:21:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1126 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776243 -122.40844299999999 POINT (-122.408443 37.776243) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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