calls

80,878 rows sorted by Request_Type

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
14723 14723 11251568 2019-08-09T23:33:00 2019-10-08T15:08:36 2019-10-08T15:08:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 405 PANORAMA DR, SAN FRANCISCO, CA, 94131 PANORAMA DR 7 Midtown Terrace PARK 37.751628875732 -122.45223999023399 POINT (-122.45223999 37.75162888) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
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
14813 14813 5672772 2016-03-16T17:44:34 2016-04-14T02:55:14 2016-04-14T02:55:14 Closed 2 Request Letter Sent. letter sent to homeowner requesting tree be removed and to apply. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2322 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.778835511625 -122.47316296712499 POINT (-122.47316297 37.77883551) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
14896 14896 10975079 2019-06-10T07:20:00 2019-10-08T15:57:53 2019-10-08T15:57:53 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ASHWOOD LN and CLARENDON AVE ASHWOOD LN 7 Forest Knolls PARK 37.752853393555 -122.45603179931601 POINT (-122.4560318 37.75285339) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
14904 14904 10961333 2019-06-06T12:25:00 2019-10-08T15:58:48 2019-10-08T15:58:48 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of JULES AVE and OCEAN AVE JULES AVE 7 Mt. Davidson Manor TARAVAL 37.724948883056996 -122.461212158203 POINT (-122.46121216 37.72494888) Phone   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19 13   2         64
14917 14917 10916967 2019-05-28T08:07:15   2019-10-08T22:10:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 855 OAK ST, SAN FRANCISCO, CA, 94117 OAK ST 5 Lower Haight NORTHERN 37.773549459826995 -122.43330639633498 POINT (-122.4333064 37.77354946) Mobile/Open311 http://mobile311.sfgov.org/reports/10916967/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
14928 14928 10900754 2019-05-23T12:45:50 2019-10-08T16:39:46 2019-10-08T16:39:46 Closed 2 we are investigating if failure or illegal pruning Notes:failure or illegal pruning? SR 2211541 shows one branch failure.. BUF Action:Inspect. Notes:failure or illegal pruning? SR 2211541 shows one branch failure, also SR 2203764. BUF Action:Inspect. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1331 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.751923600000005 -122.41593259999999 POINT (-122.4159326 37.7519236) Web http://mobile311.sfgov.org/reports/10900754/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
14994 14994 11501872 2019-10-03T18:03:46 2019-10-08T13:43:40 2019-10-08T13:43:40 Closed 2 I cannot find a tree that is falling DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1379 8TH AVE, SAN FRANCISCO, CA, 94122 8TH AVE 5 Inner Sunset TARAVAL 37.762637385868004 -122.46514350793501 POINT (-122.46514351 37.76263739) Web   109 10 11 14 11 1 5 56 8 12 12   109   11             1         109
15192 15192 5671667 2016-03-16T14:04:31 2016-03-16T20:17:36 2016-03-16T20:17:36 Closed 2 Completed/ Removed Tree Branches DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3255 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.746019015959 -122.413278479711 POINT (-122.41327848 37.74601902) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
15297 15297 7423731 2017-07-26T12:49:08 2017-08-08T15:15:42 2017-08-08T15:15:42 Closed 2 posted tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2263 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.790177973913 -122.430328254599 POINT (-122.43032825 37.79017797) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
15339 15339 9773972 2018-11-06T12:29:00 2018-11-16T10:54:37 2018-11-16T10:54:37 Closed 2 please call 4155546700. I don't know what this is about DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OAK ST and PIERCE ST OAK ST 5 Lower Haight NORTHERN 37.773548126221 -122.434112548828 POINT (-122.43411255 37.77354813) Phone   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
15520 15520 9756868 2018-11-02T12:34:00 2018-12-07T11:59:36 2018-12-07T11:59:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of JACKSON ST and TAYLOR ST JACKSON ST 3 Nob Hill CENTRAL 37.795196533203004 -122.413185119629 POINT (-122.41318512 37.79519653) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
15852 15852 11511457 2019-10-06T07:56:00 2019-10-06T22:15:22 2019-10-06T22:15:22 Closed 2 Request is a duplicate and has been previously reported as 11511457 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1265 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Parnassus Heights PARK 37.760410308838 -122.451873779297 POINT (-122.45187378 37.76041031) Phone   110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
15990 15990 11511779 2019-10-06T09:36:58 2019-10-22T12:38:59 2019-10-22T12:38:59 Closed 2 stump made safe. in queue to remove DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 721 2ND ST, SAN FRANCISCO, CA, 94107 2ND ST 6 South Beach SOUTHERN 37.780573129504 -122.390052295224 POINT (-122.3900523 37.78057313) Mobile/Open311 http://mobile311.sfgov.org/reports/11511779/photos 31 1 10 4 9 6 2 28,856 2 20 20   31   10             1         31
16171 16171 5669666 2016-03-16T07:20:57 2016-03-17T08:26:30 2016-03-17T08:26:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 311 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.731745855640995 -122.49785305228501 POINT (-122.49785305 37.73174586) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
16668 16668 11513556 2019-10-06T17:05:00 2019-10-06T17:20:11 2019-10-06T17:20:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 466 HEARST AVE, SAN FRANCISCO, CA, 94112 HEARST AVE 7 Sunnyside INGLESIDE 37.730804443359 -122.448097229004 POINT (-122.44809723 37.73080444) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
16751 16751 9141677 2018-06-15T12:45:00 2018-11-26T09:31:35 2018-11-26T09:31:35 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1567 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.757736206055 -122.496200561523 POINT (-122.49620056 37.75773621) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
16846 16846 11514415 2019-10-06T22:46:54   2019-10-06T22:55:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 451 BRODERICK ST, SAN FRANCISCO, CA, 94117 BRODERICK ST 5 Panhandle PARK 37.774565796166 -122.439481362665 POINT (-122.43948136 37.7745658) Mobile/Open311   24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
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
17195 17195 10896123 2019-05-22T13:23:00 2019-10-21T13:37:19 2019-10-21T13:37:19 Closed 2 Notes:D11 REPLACECEMRNT . BUF Action:Remove Tree. Notes:D11 REPLACEment. BUF Action:Remove Tree. Notes:D11 REPLACEment :: Closed By CMMS SO 1166654. BUF Action:Remove Tree. date completed - 10/21/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 326 FAXON AVE, SAN FRANCISCO, CA, 94112 FAXON AVE 11 Ingleside TARAVAL 37.720554351806996 -122.460060119629 POINT (-122.46006012 37.72055435) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
17236 17236 11361638 2019-09-03T11:02:57 2019-10-21T11:58:50 2019-10-21T11:58:50 Closed 2 warning letter was sent to owner DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 651 HOWARD ST, SAN FRANCISCO, CA, 94105 HOWARD ST 6 South of Market SOUTHERN 37.7857115 -122.3993203 POINT (-122.3993203 37.7857115) Web http://mobile311.sfgov.org/reports/11361638/photos 32 1 10 8 9 6 2 28,853 2 6 6   32   10         4   1         32
17261 17261 11409675 2019-09-13T08:18:00 2019-10-26T07:20:54 2019-10-26T07:20:54 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRYANT ST and CESAR CHAVEZ ST BRYANT ST 9 Peralta Heights MISSION 37.748352050781 -122.408706665039 POINT (-122.40870667 37.74835205) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
18119 18119 10994135 2019-06-13T20:01:00 2019-07-05T11:00:00 2019-07-05T11:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 3RD ST and 20TH ST 3RD ST 10 Dogpatch BAYVIEW 37.76049041748 -122.38855743408199 POINT (-122.38855743 37.76049042) Phone   55 2 9 26 8 10 3 28,856 3 29 29 20 55   9 22     22 14   1         55
18337 18337 5663409 2016-03-14T13:02:41 2016-03-15T20:31:47 2016-03-15T20:31:47 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH ST and MISSOURI ST 19TH ST 10 Potrero Hill BAYVIEW 37.761298128353 -122.396406448219 POINT (-122.39640645 37.76129813) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
18365 18365 5663342 2016-03-14T12:51:23 2016-03-15T20:25:54 2016-03-15T20:25:54 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CLARENDON AVE and PANORAMA DR CLARENDON AVE 7 Midtown Terrace PARK 37.753772168962996 -122.455537739653 POINT (-122.45553774 37.75377217) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
18988 18988 11580730 2019-10-21T13:16:00 2019-10-21T22:16:14 2019-10-21T22:16:14 Closed 2 Request is a duplicate and has been previously reported as 11580584 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MANSELL ST and GIRARD ST MANSELL ST 10 Portola BAYVIEW 37.721279144287 -122.402053833008 POINT (-122.40205383 37.72127914) Phone   91 2 9 25 8 10 3 309 3 28 28   91   9             2         91
19055 19055 11581334 2019-10-21T14:42:00   2019-10-21T16:19:27 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2281 CECILIA AVE, SAN FRANCISCO, CA, 94116 CECILIA AVE 7 Golden Gate Heights TARAVAL 37.745300292969 -122.47219085693399 POINT (-122.47219086 37.74530029) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
19334 19334 11231994 2019-08-06T07:38:00 2019-08-22T11:43:00 2019-08-22T11:43:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1119 MASON ST, SAN FRANCISCO, CA, 94108 MASON ST 3 Nob Hill CENTRAL 37.793895721436 -122.411415100098 POINT (-122.4114151 37.79389572) Phone   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
19342 19342 5657507 2016-03-11T20:34:22 2016-05-16T05:12:30 2016-05-16T05:12:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2203 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 4 Outer Sunset TARAVAL 37.763316145425 -122.481460005817 POINT (-122.48146001 37.76331615) Phone   39 10 7 35 3 1 5 56 8 35 35 9 39   7 11     11     1         39
19348 19348 5657442 2016-03-11T19:43:23 2016-03-11T22:19:54 2016-03-11T22:19:54 Closed 2 Duplicate SR Arborist Responding DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BAKER ST and JEFFERSON ST BAKER ST 2 Marina NORTHERN 37.804216416561 -122.447099936525 POINT (-122.44709994 37.80421642) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1     15   17
19350 19350 5657481 2016-03-11T20:11:33 2016-05-16T05:12:24 2016-05-16T05:12:24 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GREEN ST and FRANKLIN ST GREEN ST 2 Union Street NORTHERN 37.797408141001 -122.425437864596 POINT (-122.42543786 37.79740814) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
19359 19359 5657352 2016-03-11T18:53:00 2016-03-11T22:21:50 2016-03-11T22:21:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MUSEUM WAY and ROOSEVELT WAY MUSEUM WAY 8 Corona Heights PARK 37.765270959474 -122.44124166726601 POINT (-122.44124167 37.76527096) Phone   112 7 5 5 5 15 8 28,862 5 3 3   112   5             1         112
19413 19413 5656612 2016-03-11T15:21:11 2016-03-11T22:20:50 2016-03-11T22:20:50 Closed 2 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of OCTAVIA ST and PAGE ST OCTAVIA ST 5 Lower Haight NORTHERN 37.773887634277 -122.423950195313 POINT (-122.4239502 37.77388763) Phone   26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
19539 19539 5655111 2016-03-11T10:18:01 2016-03-11T20:11:31 2016-03-11T20:11:31 Closed 2 LP was able to remove tree branch DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2170 36TH AVE, SAN FRANCISCO, CA, 94116 36TH AVE 4 Parkside TARAVAL 37.746545114836 -122.49404779816003 POINT (-122.4940478 37.74654511) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
19624 19624 5654312 2016-03-11T07:03:42 2016-03-11T16:29:24 2016-03-11T16:29:24 Closed 2 1098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 950 CLEMENT ST, SAN FRANCISCO, CA, 94118 CLEMENT ST 1 Inner Richmond RICHMOND 37.782779574148 -122.469252904348 POINT (-122.4692529 37.78277957) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
19713 19713 5653772 2016-03-10T18:23:45 2016-03-10T22:09:20 2016-03-10T22:09:20 Closed 2 location has been given to Arborist Robert. 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3255 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.746019015959 -122.413278479711 POINT (-122.41327848 37.74601902) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
19720 19720 5653757 2016-03-10T18:09:19 2016-03-11T13:38:10 2016-03-11T13:38:10 Closed 2 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SLOAT BLVD and RIVERTON DR SLOAT BLVD 7 Merced Manor TARAVAL 37.734116630084 -122.487287798006 POINT (-122.4872878 37.73411663) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
19722 19722 5653750 2016-03-10T18:03:42 2016-04-11T19:35:44 2016-04-11T19:35:44 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 19TH ST and POTRERO AVE 19TH ST 10 Mission MISSION 37.760659133495004 -122.407067688893 POINT (-122.40706769 37.76065913) Phone   53 3 9 20 8 10 7 28,859 4 19 19   53   9     3   15   2   3     53
19778 19778 11533780 2019-10-10T15:46:17   2019-10-31T11:40:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 415 DE HARO ST, SAN FRANCISCO, CA, 94103 DE HARO ST 10 Potrero Hill SOUTHERN 37.7645888 -122.4013138 POINT (-122.4013138 37.7645888) Web   54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
19814 19814 5653001 2016-03-10T14:56:30 2016-03-14T12:20:03 2016-03-14T12:20:03 Closed 2 RPD staff have met on site with PG&E to assess the tree across from 1670 Sanchez (between Day Street and 30th) that is leaning into the power lines and over the recreation building's fence. PG&E has stated that they will remove the tree from the power lines. RPD Urban Foresters have also been notified and will take action once the tree is removed from the power lines. RPD Park Service Area 5 Queue 11 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1670 SANCHEZ ST, SAN FRANCISCO, CA, 94131 SANCHEZ ST 8 Noe Valley INGLESIDE 37.742417997095 -122.42893532739599 POINT (-122.42893533 37.742418) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
19818 19818 5652994 2016-03-10T14:55:44 2016-08-01T09:40:21 2016-08-01T09:40:21 Closed 2 Area is being inspected and we will prioritize the work asap. Thank you. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of JUNIPERO SERRA BLVD and STONECREST DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.72531 -122.472131 POINT (-122.472131 37.72531) Mobile/Open311   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
20034 20034 5651446 2016-03-10T09:35:49 2016-06-14T01:59:57 2016-06-14T01:59:57 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 616 GRANT AVE, SAN FRANCISCO, CA, 94108 GRANT AVE 3 Chinatown CENTRAL 37.792927 -122.40596699999999 POINT (-122.405967 37.792927) Mobile/Open311 http://mobile311.sfgov.org/reports/5651446/photos 104 6 3 6 10 3 1 28,857 1 4 4   104   3             2         104
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
20140 20140 5650618 2016-03-09T20:49:45 2016-06-29T11:27:47 2016-06-29T11:27:47 Closed 2 SES Graffiti Crew - Steam Clean - Misc - Other Work DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2482 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.757323010263 -122.41899811150199 POINT (-122.41899811 37.75732301) Phone http://mobile311.sfgov.org/reports/5650618/photos 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
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
20355 20355 5649631 2016-03-09T15:29:52 2016-03-11T12:00:00 2016-03-11T12:00:00 Closed 2 Request closed by SES . Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 3/11/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 129 OCTAVIA ST, SAN FRANCISCO, CA, 94102 OCTAVIA ST 5 Lower Haight NORTHERN 37.773270229843995 -122.424132870624 POINT (-122.42413287 37.77327023) Mobile/Open311 http://mobile311.sfgov.org/reports/5649631/photos 26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
20363 20363 5649590 2016-03-09T15:21:27 2016-03-10T12:00:00 2016-03-10T12:00:00 Closed 2 Request closed by SES . Notes = " Notes:Empty basin. Will request replanting. . BUF Action:Inspect. date completed - 3/10/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 333 HAIGHT ST, SAN FRANCISCO, CA, 94102 HAIGHT ST 5 Mint Hill NORTHERN 37.772297677619 -122.427655616889 POINT (-122.42765562 37.77229768) Mobile/Open311 http://mobile311.sfgov.org/reports/5649590/photos 27 4 11 9 11 7 6 28,852 9 10 10   27   11             1         27
20671 20671 11255265 2019-08-11T00:50:19 2019-10-10T12:15:38 2019-10-10T12:15:38 Closed 2 to be removed soon 1801 2 palms DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1839 OCEAN AVE, SAN FRANCISCO, CA, 94112 OCEAN AVE 7 Ingleside TARAVAL 37.724957838041 -122.46157628699801 POINT (-122.46157629 37.72495784) Mobile/Open311   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19 13   2         64
20677 20677 11296821 2019-08-20T09:42:56   2019-10-10T13:00:30 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 48 PALOMA AVE, SAN FRANCISCO, CA, 94127 PALOMA AVE 7 Ingleside Terraces TARAVAL 37.729032730814 -122.4688602 POINT (-122.4688602 37.72903273) Web http://mobile311.sfgov.org/reports/11296821/photos 67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
20687 20687 11353077 2019-09-01T08:44:04 2019-10-10T12:45:53 2019-10-10T12:45:53 Closed 2 tree location has been noted and will be planted as soon as funding becomes available MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4699 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bayview BAYVIEW 37.735845863242 -122.390198747908 POINT (-122.39019875 37.73584586) Mobile/Open311 http://mobile311.sfgov.org/reports/11353077/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
20692 20692 11379426 2019-09-06T15:26:38 2019-10-10T12:47:55 2019-10-10T12:47:55 Closed 2 will follow up with people posting signs MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1148 MENDELL ST, SAN FRANCISCO, CA, 94124 MENDELL ST 10 Bayview BAYVIEW 37.736069 -122.3892824 POINT (-122.3892824 37.736069) Web http://mobile311.sfgov.org/reports/11379426/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
20694 20694 11384602 2019-09-08T07:32:40 2019-10-10T12:48:29 2019-10-10T12:48:29 Closed 2 tree location has been noted and will be planted as soon as funding becomes available MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4730 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bayview BAYVIEW 37.735362279105 -122.390536783539 POINT (-122.39053678 37.73536228) Mobile/Open311 http://mobile311.sfgov.org/reports/11384602/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
20695 20695 11384618 2019-09-08T07:37:54 2019-10-10T12:45:06 2019-10-10T12:45:06 Closed 2 tree location has been noted and will be planted as soon as funding becomes available MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4601 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bayview BAYVIEW 37.736041099721 -122.39019453058901 POINT (-122.39019453 37.7360411) Mobile/Open311 http://mobile311.sfgov.org/reports/11384618/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
20736 20736 11483206 2019-09-30T07:36:00 2019-10-10T07:35:00 2019-10-10T07:35:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1322 BAKER ST, SAN FRANCISCO, CA, 94115 BAKER ST 2 Lower Pacific Heights RICHMOND 37.783351898193004 -122.442726135254 POINT (-122.44272614 37.7833519) Phone   103 8 6 15 1 15 9 29,490 6 13 13   103   6             2         103
20865 20865 11511459 2019-10-06T07:56:45 2019-10-10T12:46:46 2019-10-10T12:46:46 Closed 2 tree location has been noted and will be planted as soon as funding becomes available MD DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4702 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bayview BAYVIEW 37.735496666667 -122.390716666667 POINT (-122.39071667 37.73549667) Mobile/Open311 http://mobile311.sfgov.org/reports/11511459/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13 5   13     2         86
20884 20884 11512840 2019-10-06T13:46:30 2019-10-10T00:00:00 2019-10-10T00:00:00 Closed 2 this tree has no structural roots! only somehow surviving on feeder roots DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2356 18TH AVE, SAN FRANCISCO, CA, 94116 18TH AVE 7 Golden Gate Heights TARAVAL 37.743942600000004 -122.47435390000001 POINT (-122.4743539 37.7439426) Web http://mobile311.sfgov.org/reports/11512840/photos 44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
20891 20891 11513600 2019-10-06T17:22:00 2019-10-10T00:25:32 2019-10-10T00:25:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH ST and NOE ST 19TH ST 8 Eureka Valley MISSION 37.759422302246 -122.43264007568399 POINT (-122.43264008 37.7594223) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1   5     115
20922 20922 11515965 2019-10-07T09:49:00 2019-10-10T14:36:42 2019-10-10T14:36:42 Closed 2 issuing fine DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2143 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Union Street NORTHERN 37.799587249755994 -122.436729431152 POINT (-122.43672943 37.79958725) Phone   15 4 6 13 1 13 6 57 9 17 17 19 15   6 21 21   21     1         15
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
21968 21968 11531841 2019-10-10T10:44:00   2019-10-10T10:55:24 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 769 14TH AVE, SAN FRANCISCO, CA, 94118 14TH AVE 1 Inner Richmond RICHMOND 37.773696899414 -122.47248840331999 POINT (-122.4724884 37.7736969) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
22143 22143 11532676 2019-10-10T12:42:39   2019-10-10T12:50:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1421 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.751132 -122.40423899999999 POINT (-122.404239 37.751132) Mobile/Open311 http://mobile311.sfgov.org/reports/11532676/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
22251 22251 11533343 2019-10-10T14:34:57 2019-10-25T12:06:24 2019-10-25T12:06:24 Closed 2 these have been removed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 528 DIVISADERO ST, SAN FRANCISCO, CA, 94117 DIVISADERO ST 5 Alamo Square NORTHERN 37.774436666667 -122.437666666667 POINT (-122.43766667 37.77443667) Mobile/Open311 http://mobile311.sfgov.org/reports/11533343/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
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
22346 22346 11533873 2019-10-10T16:05:28   2019-10-30T14:10:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 18 TOPAZ WAY, SAN FRANCISCO, CA, 94131 TOPAZ WAY 8 Diamond Heights INGLESIDE 37.742387 -122.437749 POINT (-122.437749 37.742387) Web   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
22446 22446 11534409 2019-10-10T17:55:00 2019-10-10T18:16:12 2019-10-10T18:16:12 Closed 2 completed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CORTLAND AVE and PROSPECT AVE CORTLAND AVE 9 Holly Park INGLESIDE 37.740219116211 -122.420852661133 POINT (-122.42085266 37.74021912) Phone http://mobile311.sfgov.org/reports/11534409/photos 61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
22668 22668 5649574 2016-03-09T15:18:01 2016-06-14T08:30:00 2016-06-14T08:30:00 Closed 2 1098 Duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1779 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 9 Mission MISSION 37.768634843156 -122.41520756759701 POINT (-122.41520757 37.76863484) Mobile/Open311 http://mobile311.sfgov.org/reports/5649574/photos 53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
22674 22674 5649583 2016-03-09T15:19:50 2016-06-15T03:03:11 2016-06-15T03:03:11 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1779 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 9 Mission MISSION 37.76865 -122.415178333333 POINT (-122.41517833 37.76865) Mobile/Open311 http://mobile311.sfgov.org/reports/5649583/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
23103 23103 10660668 2019-03-29T10:20:00 2019-10-29T14:57:25 2019-10-29T15:25:07 Closed 2 Request Letter Sent. Notes:Letter created. BUF Action:Inspect. date completed - 10/29/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 657 HOWARD ST, SAN FRANCISCO, CA, 94105 HOWARD ST 6 South of Market SOUTHERN 37.785606384277 -122.39947509765601 POINT (-122.3994751 37.78560638) Phone   32 1 10 8 9 6 2 28,853 2 6 6   32   10         4   1         32
23143 23143 10983652 2019-06-11T17:10:00   2019-10-30T12:30:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2369 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.762832641602 -122.434379577637 POINT (-122.43437958 37.76283264) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12   1 9   1   5     38
23144 23144 10984770 2019-06-11T23:37:56   2019-10-30T15:40:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4030 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 8 St. Mary's Park INGLESIDE 37.733045000000004 -122.427151 POINT (-122.427151 37.733045) Mobile/Open311 http://mobile311.sfgov.org/reports/10984770/photos 93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
23188 23188 11139597 2019-07-17T08:09:00   2019-10-30T08:36:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 325 RICHLAND AVE, SAN FRANCISCO, CA, 94110 RICHLAND AVE 9 Holly Park INGLESIDE 37.735836029053004 -122.419403076172 POINT (-122.41940308 37.73583603) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
23203 23203 11228867 2019-08-05T12:39:00   2019-10-27T10:33:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3631 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94110 CESAR CHAVEZ ST 9 Bernal Heights MISSION 37.747955322266 -122.421730041504 POINT (-122.42173004 37.74795532) Phone   83 3 2 22 7 2 7 28,859 4 22 22   83   2             1         83
23218 23218 11309493 2019-08-22T15:33:00 2019-10-25T09:30:19 2019-10-25T09:30:19 Closed 2 in discussion to see if we can get this tree pruned to mitigate risk. submitted this tree for pruning request. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2022 HAYES ST, SAN FRANCISCO, CA, 94117 HAYES ST 5 Panhandle PARK 37.77360534668 -122.44979858398399 POINT (-122.44979858 37.77360535) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
23249 23249 11354275 2019-09-01T13:28:00 2019-10-25T09:38:37 2019-10-25T09:38:37 Closed 2 duplicate request, will be out soon to view tree, will likely be fine just needs portions of dead wood removed. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OLIVE ST and FRANKLIN ST OLIVE ST 5 Cathedral Hill NORTHERN 37.784084320068004 -122.422744750977 POINT (-122.42274475 37.78408432) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
23301 23301 11405879 2019-09-12T11:12:00 2019-10-28T14:10:02 2019-10-28T14:45:03 Closed 2 the reporting of this address is confusing. s.stacy. no major damage can be found. BUF Action:Inspect. date completed - 10/28/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2715 STEINER ST, SAN FRANCISCO, CA, 94123 STEINER ST 2 Pacific Heights NORTHERN 37.794448852539 -122.436782836914 POINT (-122.43678284 37.79444885) Phone   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
23312 23312 11459733 2019-09-24T12:38:00   2019-10-31T22:30:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 160 STRATFORD DR, SAN FRANCISCO, CA, 94132 STRATFORD DR 7 Stonestown TARAVAL 37.722045898438 -122.473686218262 POINT (-122.47368622 37.7220459) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
23615 23615 11571916 2019-10-19T09:10:27 2019-10-24T13:44:15 2019-10-24T13:44:15 Closed 2 There is no immediate safety issue with the steet tree adjacent to this property so it will be serviced in the next few years. The City has taken over responsibility for the care and maintenance of street trees. Through a program called StreetTreeSF, trees that are in the worst condition are being addressed first and every tree will be addressed following a maintenance schedule that is focused on public safety. Thank you for your patience. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2501 36TH AVE, SAN FRANCISCO, CA, 94116 36TH AVE 4 Parkside TARAVAL 37.740414985373995 -122.493961003985 POINT (-122.493961 37.74041499) Mobile/Open311   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
23903 23903 11580621 2019-10-21T13:00:00 2019-10-28T14:03:55 2019-10-28T14:40:12 Closed 2 Thank you this tree will be evaluated during our regularly scheduled tree assessment and maintenance MD Notes:tree looks to be in decline, curently in stable condition, will be assessed during regular scheduled maintenance MD. BUF Action:Inspect. date completed - 10/28/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of MANSELL ST and BRUSSELS ST MANSELL ST 10 Portola BAYVIEW 37.72102355957 -122.403030395508 POINT (-122.4030304 37.72102356) Phone   91 2 9 25 8 10 3 309 3 28 28   91   9             2         91
24302 24302 11586803 2019-10-22T15:35:00 2019-10-25T00:00:00 2019-10-25T00:00:00 Closed 2 Notes:trees can remain structurally sound for years after declining. this tree does not appear to have significant rot at base and no soil movement after a strong push. this tree will be removed during the area's regular scheduled maintenance . BUF Action:Inspect. date completed - 10/25/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 3356 STEINER ST, SAN FRANCISCO, CA, 94123 STEINER ST 2 Marina NORTHERN 37.800430297852 -122.437698364258 POINT (-122.43769836 37.8004303) Phone   17 4 6 13 1 13 6 57 9 17 17 19 17   6 21     21     1         17
25528 25528 11594922 2019-10-24T09:49:00 2019-10-26T07:51:01 2019-10-26T07:51:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of NATOMA ST and 11TH ST NATOMA ST 6 South of Market SOUTHERN 37.773532867431996 -122.41610717773399 POINT (-122.41610718 37.77353287) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
25567 25567 11595048 2019-10-24T10:08:00 2019-10-29T11:27:03 2019-10-30T00:00:00 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 80 THOR AVE, SAN FRANCISCO, CA, 94131 THOR AVE 8 Glen Park INGLESIDE 37.734819705998994 -122.434214153773 POINT (-122.43421415 37.73481971) Mobile/Open311 http://mobile311.sfgov.org/reports/11595048/photos 96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
25620 25620 11595202 2019-10-24T10:32:09   2019-10-24T10:40:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2427 23RD ST, SAN FRANCISCO, CA, 94110 23RD ST 10 Potrero Hill MISSION 37.754303 -122.40413600000001 POINT (-122.404136 37.754303) Mobile/Open311 http://mobile311.sfgov.org/reports/11595202/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
25629 25629 11595225 2019-10-24T10:36:00   2019-10-31T22:30:34 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 142 JULES AVE, SAN FRANCISCO, CA, 94112 JULES AVE 11 Ingleside TARAVAL 37.720783233643 -122.461082458496 POINT (-122.46108246 37.72078323) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
25654 25654 11595295 2019-10-24T10:45:00 2019-10-26T06:53:00 2019-10-26T06:53:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PIERCE ST and CLAY ST PIERCE ST 2 Pacific Heights NORTHERN 37.79029083252 -122.43749237060499 POINT (-122.43749237 37.79029083) Phone   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
26076 26076 11596980 2019-10-24T15:07:00 2019-10-24T15:15:59 2019-10-24T15:15:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 545 ORIZABA AVE, SAN FRANCISCO, CA, 94132 ORIZABA AVE 11 Ingleside TARAVAL 37.718803405762 -122.462768554688 POINT (-122.46276855 37.71880341) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
26413 26413 11598092 2019-10-24T18:59:00 2019-10-30T13:05:00 2019-10-30T13:05:00 Closed 2 For tree crew DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 20TH AVE and BUCKINGHAM WAY 20TH AVE 7 Stonestown TARAVAL 37.730117797852 -122.475936889648 POINT (-122.47593689 37.7301178) Phone   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
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
26800 26800 11461149 2019-09-24T16:47:54 2019-10-11T10:36:26 2019-10-11T10:36:26 Closed 2 sent to crew for urgent removal Notes:submitting for urgent removal, limb fsilure, being held up by adjacent wall over PROW. :: Closed By CMMS SO 1226304. BUF Action:Remove Tree. date completed - 10/11/2019. Notes:submitting for urgent removal, limb fsilure, being held up by adjacent wall over PROW. :: Closed By CMMS SO 1226304from CMMS: . BUF Action:Remove Tree. date completed - 10/11/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1095 HAYES ST, SAN FRANCISCO, CA, 94117 HAYES ST 5 Alamo Square NORTHERN 37.775089200000004 -122.43402809999999 POINT (-122.4340281 37.7750892) Web   23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
27209 27209 11599914 2019-10-25T09:46:00 2019-10-26T11:08:00 2019-10-26T11:08:00 Closed 2   RPD Park Patrol Queue 13 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of HAVELOCK ST and SAN JOSE AVE HAVELOCK ST 11 Mission Terrace INGLESIDE 37.726760864258 -122.441581726074 POINT (-122.44158173 37.72676086) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1     70   94
27520 27520 11600575 2019-10-25T11:24:00   2019-10-26T08:54:33 Open 1 Open RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Edgehill Mountain, , SAN FRANCISCO, CA, 94127 Edgehill Mountain 7 Laguna Honda TARAVAL 37.7421109 -122.4597433 POINT (-122.4597433 37.7421109) Web   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
27715 27715 11527262 2019-10-09T11:23:00   2019-10-11T09:40:24 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 587 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 8 Duboce Triangle PARK 37.770668029785 -122.433242797852 POINT (-122.4332428 37.77066803) Phone   28 7 5 3 5 15 8 29,492 5 9 9   28   5             1         28
27918 27918 11601465 2019-10-25T13:56:00   2019-10-26T08:35:49 Open 1 Open RPD GGP Queue 14 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 9TH AVE and MARTIN LUTHER KING JR DR 9TH AVE 5 Golden Gate Park RICHMOND 37.766627 -122.466205 POINT (-122.466205 37.766627) Mobile/Open311   9 8 11 12 11 11 9 29,492 6 8 8   9   11             1         9
28024 28024 11530377 2019-10-10T02:45:00 2019-10-14T00:25:41 2019-10-14T00:25:41 Closed 2 Tree is on Private Property DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2003 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 2 Pacific Heights NORTHERN 37.793106079102 -122.42471313476601 POINT (-122.42471313 37.79310608) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
28057 28057 11601786 2019-10-25T14:42:40 2019-10-25T15:54:31 2019-10-25T15:54:31 Closed 2 contacted school to let them know they must remove the sign. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1532 PAGE ST, SAN FRANCISCO, CA, 94117 (Virtual) PAGE ST 5 Haight Ashbury PARK 37.77107 -122.446013333333 POINT (-122.44601333 37.77107) Mobile/Open311 http://mobile311.sfgov.org/reports/11601786/photos 25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
28135 28135 11531190 2019-10-10T09:11:56 2019-10-11T05:22:00 2019-10-11T05:22:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1244 19TH ST, SAN FRANCISCO, CA, 94107 19TH ST 10 Potrero Hill BAYVIEW 37.761423499359005 -122.395221758748 POINT (-122.39522176 37.7614235) Mobile/Open311 http://mobile311.sfgov.org/reports/11531190/photos 54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
28849 28849 11535259 2019-10-11T06:15:00 2019-10-11T07:29:37 2019-10-11T07:29:37 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 3RD ST and CARGO WAY 3RD ST 10 Central Waterfront BAYVIEW 37.746158599854 -122.387176513672 POINT (-122.38717651 37.7461586) Phone   56 2 9 1 8 10 3 58 3 1 1   56   9             1         56
28858 28858 11535280 2019-10-11T06:29:08   2019-10-11T06:35:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 500 CARGO WAY, SAN FRANCISCO, CA, 94124 CARGO WAY 10 Central Waterfront BAYVIEW 37.744597222425 -122.384581248818 POINT (-122.38458125 37.74459722) Web   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
28912 28912 11535384 2019-10-11T07:27:00   2019-10-11T07:50:27 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2424 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 9 Portola BAYVIEW 37.731864929199 -122.405487060547 POINT (-122.40548706 37.73186493) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2   4         2         91

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