calls

80,878 rows

View and edit SQL

Status

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
43 43 11535870 2019-10-11T08:56:58   2019-10-11T09:15:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 450 CARGO WAY, SAN FRANCISCO, CA, 94124 CARGO WAY 10 Central Waterfront BAYVIEW 37.744414755201 -122.384434893885 POINT (-122.38443489 37.74441476) Mobile/Open311 http://mobile311.sfgov.org/reports/11535870/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
59 59 11536492 2019-10-11T10:30:08 2019-10-21T09:36:53 2019-10-21T09:36:53 Closed 2 property owners hold the liability if the damage occurred prior to July 1 2017. we are responsible for repairing but the liability is with the adjacent owner until that time. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 220 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 MAGELLAN AVE 7 Forest Hill TARAVAL 37.747464 -122.46059 POINT (-122.46059 37.747464) Web   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
76 76 11537288 2019-10-11T12:20:00 2019-10-11T12:30:06 2019-10-11T12:30:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 775 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 5 Western Addition NORTHERN 37.778961181641 -122.425079345703 POINT (-122.42507935 37.77896118) Phone   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
151 151 5704626 2016-03-27T16:23:04 2016-03-28T01:28:00 2016-03-28T01:28:00 Closed 2 nothing seen all clear DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 20TH ST and SHOTWELL ST 20TH ST 9 Mission MISSION 37.75883102417 -122.41577911376999 POINT (-122.41577911 37.75883102) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
164 164 11509062 2019-10-05T12:19:00   2019-10-05T14:18:20 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1601 9TH AVE, SAN FRANCISCO, CA, 94122 9TH AVE 7 Golden Gate Heights TARAVAL 37.75830078125 -122.46605682373001 POINT (-122.46605682 37.75830078) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
268 268 11542632 2019-10-12T17:38:00 2019-10-12T17:48:51 2019-10-12T17:48:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 221 12TH AVE, SAN FRANCISCO, CA, 94118 12TH AVE 1 Inner Richmond RICHMOND 37.784196007484 -122.471058773174 POINT (-122.47105877 37.78419601) Mobile/Open311 http://mobile311.sfgov.org/reports/11542632/photos 5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
284 284 5700190 2016-03-25T14:26:51 2016-03-28T10:52:57 2016-03-28T10:52:57 Closed 2 Request closed by in Operations system at Mar 28 2016 12:00AM. Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 3/28/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1402 15TH ST, SAN FRANCISCO, CA, 94103 15TH ST 9 Mission MISSION 37.767029483838 -122.415954144786 POINT (-122.41595414 37.76702948) Mobile/Open311 http://mobile311.sfgov.org/reports/5700190/photos 53 3 2 20 7 8 7 28,853 4 19 19 12 53   2 14   3 14     2   3     53
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
358 358 11604477 2019-10-26T10:14:00 2019-10-28T14:18:48 2019-10-28T14:45:05 Closed 2 There is no immediate safety issue with your tree 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. Notes:not a pruning priority . BUF Action:Inspect. date completed - 10/28/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 2265 UNION ST, SAN FRANCISCO, CA, 94123 UNION ST 2 Union Street NORTHERN 37.796829223633 -122.43654632568399 POINT (-122.43654633 37.79682922) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6   19         1         15
376 376 5697359 2016-03-24T16:42:51 2016-04-04T02:07:00 2016-04-04T02:07:00 Closed 2 Request Letter Sent. letter sent to homeowner to replant. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3587 17TH ST, SAN FRANCISCO, CA, 94110 17TH ST 8 Mission Dolores MISSION 37.763008 -122.425896 POINT (-122.425896 37.763008) Mobile/Open311 http://mobile311.sfgov.org/reports/5697359/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             1         37
419 419 5695378 2016-03-24T09:26:26 2016-11-10T01:25:10 2016-11-10T01:25:10 Closed 2 1215 Fairfax Ave: Int. of Keith St. and Bowman Ct near curb ramp: overgrown ivy blocking pedestrian path 8/1616: some trimming done. NEED more trimming of ivy on the other side of the fence. IV - NTR: 1068063 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BOWMAN CT and KEITH ST BOWMAN CT 10 Bayview BAYVIEW 37.73776880012 -122.38179734416401 POINT (-122.38179734 37.7377688) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
441 441 11607259 2019-10-27T07:05:00 2019-10-28T07:44:28 2019-10-29T14:07:09 Closed 2   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
452 452 5694342 2016-03-23T18:50:33   2016-03-23T18:51:40 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 134 BARTLETT ST, SAN FRANCISCO, CA, 94110 BARTLETT ST 9 Mission MISSION 37.754232202848 -122.419873156843 POINT (-122.41987316 37.7542322) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
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
569 569 11548402 2019-10-14T11:27:00   2019-10-14T11:35:27 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 2715 35TH AVE, SAN FRANCISCO, CA, 94116 35TH AVE 4 Parkside TARAVAL 37.7366065979 -122.49261474609399 POINT (-122.49261475 37.7366066) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
571 571 11548490 2019-10-14T11:41:00   2019-10-14T12:10:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1433 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737487792969 -122.385726928711 POINT (-122.38572693 37.73748779) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
588 588 11611037 2019-10-28T08:24:00   2019-10-28T09:50:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of 45TH AVE and BALBOA ST 45TH AVE 1 Outer Richmond RICHMOND 37.775321960449 -122.50588226318399 POINT (-122.50588226 37.77532196) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
598 598 11549544 2019-10-14T14:52:21   2019-10-14T15:25:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of PIERCE ST and OAK ST PIERCE ST 5 Lower Haight NORTHERN 37.773571000000004 -122.43413000000001 POINT (-122.43413 37.773571) Mobile/Open311   26 4 11 9 11 15 8 29,492 5 10 10   26   11             1         26
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
623 623 11611558 2019-10-28T09:39:00 2019-10-28T14:06:44 2019-10-30T12:00:19 Closed 2 Made safe DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 245 MARKET ST, SAN FRANCISCO, CA, 94105 MARKET ST 6 Financial District CENTRAL 37.792785644531 -122.396743774414 POINT (-122.39674377 37.79278564) Phone   108 6 10 8 9 12 2 28,855 2 6 6   108   10             1         108
640 640 11611992 2019-10-28T10:39:00   2019-10-29T15:15:05 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 763 15TH AVE, SAN FRANCISCO, CA, 94118 15TH AVE 1 Inner Richmond RICHMOND 37.773754119873 -122.47365570068399 POINT (-122.4736557 37.77375412) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
657 657 5688660 2016-03-22T10:37:55 2016-03-28T11:05:00 2016-03-28T11:05:00 Closed 2 Request closed by in Operations system at Mar 28 2016 12:00AM. Notes = " Notes:planting request exists. BUF Action:Inspect. date completed - 3/28/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 17TH ST and FOLSOM ST 17TH ST 9 Mission MISSION 37.763659999999994 -122.415269 POINT (-122.415269 37.76366) Mobile/Open311 http://mobile311.sfgov.org/reports/5688660/photos 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3     53
686 686 11613518 2019-10-28T14:31:00 2019-10-29T10:52:29 2019-10-28T15:10:08 Closed 2 we apologize for the inconvenience and suggest pulling up and letting passengers in and out at the driveway area adjacent to the trees. these trees will be pruned during regular maintenance There is no immediate safety issue with your tree 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 a DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 4606 CABRILLO ST, SAN FRANCISCO, CA, 94121 CABRILLO ST 1 Outer Richmond RICHMOND 37.773475700000006 -122.5081149 POINT (-122.5081149 37.7734757) Web   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
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
757 757 11555081 2019-10-15T16:21:00 2019-10-22T10:15:51 2019-10-22T10:15:51 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 391 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.733299255371 -122.49645233154301 POINT (-122.49645233 37.73329926) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
795 795 5684106 2016-03-21T07:09:00 2016-03-28T03:03:00 2016-03-28T03:03:00 Closed 2 no branch found DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 638 MANSELL ST, SAN FRANCISCO, CA, 94134 MANSELL ST 9 Portola BAYVIEW 37.72007 -122.407455 POINT (-122.407455 37.72007) Mobile/Open311 http://mobile311.sfgov.org/reports/5684106/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             1         91
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
966 966 5683130 2016-03-20T14:29:18 2016-03-23T02:51:00 2016-03-23T02:51:00 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1455 44TH AVE, SAN FRANCISCO, CA, 94122 44TH AVE 4 Outer Sunset TARAVAL 37.759473663406 -122.503851056924 POINT (-122.50385106 37.75947366) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1040 1040 11618478 2019-10-29T14:21:00   2019-10-29T15:26:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1862 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 2 Lower Pacific Heights NORTHERN 37.786952972412 -122.44003295898399 POINT (-122.44003296 37.78695297) Phone   103 4 6 30 1 13 9 29,490 6 27 27   103   6             1         103
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
1130 1130 11619706 2019-10-29T17:54:00 2019-10-29T18:51:54 2019-10-29T19:30:05 Closed 2 Emailed to on-call arborist Ricardo Lizarraga DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GREAT HWY and SKYLINE BLVD GREAT HWY 7 Lakeshore TARAVAL 37.725257873535 -122.50304412841801 POINT (-122.50304413 37.72525787) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
1245 1245 10499981 2019-02-17T14:13:00 2019-10-22T07:17:50 2019-10-22T07:17:50 Closed 2 this tree is stable and is to about to fall. sent to crews for pruning for pruning large branch over street , but still might take a while because it's as their schedule allows. We are trying as hard as possible to prune the city's nearly 125000 street trees so we ask for your patience. pls call 415.554.6700 for updates. Notes:over extended branch on street side , please reduce or remove as time allows. believe it should be addressed before regular maintenance, but it's not super urgent.. B DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1835 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.781707763671996 -122.436645507813 POINT (-122.43664551 37.78170776) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
1246 1246 10708134 2019-04-09T15:51:00   2019-10-22T07:56:54 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1240 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 8 Mission Terrace INGLESIDE 37.730506896973 -122.43194580078101 POINT (-122.4319458 37.7305069) Phone   94 9 5 28 5 9 4 28,861 7 25 25 16 94   5             1         94
1258 1258 10891519 2019-05-21T13:29:20 2019-10-22T12:49:48 2019-10-22T12:49:48 Closed 2 Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 651 BRANNAN ST, SAN FRANCISCO, CA, 94107 BRANNAN ST 6 South of Market SOUTHERN 37.775558824686 -122.39995183434601 POINT (-122.39995183 37.77555882) Mobile/Open311 http://mobile311.sfgov.org/reports/10891519/photos 32 1 10 4 9 14 2 28,856 2 20 20   32   10             1         32
1274 1274 10956697 2019-06-05T12:40:04 2019-06-10T10:03:03 2019-06-10T10:03:03 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2978 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765067154577 -122.419337164725 POINT (-122.41933716 37.76506715) Mobile/Open311 http://mobile311.sfgov.org/reports/10956697/photos 53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3 50 24 53
1276 1276 10964957 2019-06-07T09:45:00 2019-10-30T00:00:00 2019-10-30T14:55:07 Closed 2 Notes:blocking driveway access . BUF Action:Prune. Notes:blocking driveway access . BUF Action:Prune. date completed - 10/30/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 127 HOLLOWAY AVE, SAN FRANCISCO, CA, 94112 HOLLOWAY AVE 11 Ingleside TARAVAL 37.721740722656 -122.454383850098 POINT (-122.45438385 37.72174072) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1 19     19     2         64
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
1308 1308 11180890 2019-07-25T19:20:00 2019-10-22T14:38:04 2019-10-22T14:38:04 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2570 41ST AVE, SAN FRANCISCO, CA, 94116 41ST AVE 4 Outer Sunset TARAVAL 37.7388137 -122.49878170000001 POINT (-122.4987817 37.7388137) Web   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
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
1326 1326 11249723 2019-08-09T15:02:00   2019-10-22T10:49:45 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 111 CHESTNUT ST, SAN FRANCISCO, CA, 94133 CHESTNUT ST 3 Telegraph Hill CENTRAL 37.804584503174 -122.405570983887 POINT (-122.40557098 37.8045845) Phone   18 6 3 23 10 3 1 28,860 1 23 23   18   3             1         18
1327 1327 11255860 2019-08-11T09:45:00 2019-10-22T11:48:57 2019-10-22T11:48:57 Closed 2 we MIGHT be able to prune it for sidewalk clearance but virtually nothing can be done about fruit. do not touch tree, stand by. will address in future keymap DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 535 LAKEVIEW AVE, SAN FRANCISCO, CA, 94112 LAKEVIEW AVE 11 Oceanview TARAVAL 37.718143463135 -122.454864501953 POINT (-122.4548645 37.71814346) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
1329 1329 11281111 2019-08-16T13:26:00   2019-10-22T14:44:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 128 STANYAN BLVD, SAN FRANCISCO, CA, 94118 STANYAN BLVD 1 Lone Mountain PARK 37.779289245605 -122.455360412598 POINT (-122.45536041 37.77928925) Phone   12 7 4 18 2 15 9 54 6 16 16   12   4             1         12
1339 1339 11354221 2019-09-01T13:13:00 2019-10-22T11:21:10 2019-10-22T11:21:10 Closed 2 sent for contract prune 2 month lead time DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 170 STAPLES AVE, SAN FRANCISCO, CA, 94112 STAPLES AVE 7 Sunnyside INGLESIDE 37.729116417503 -122.445896817485 POINT (-122.44589682 37.72911642) Mobile/Open311 http://mobile311.sfgov.org/reports/11354221/photos 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
1343 1343 11368089 2019-09-04T12:29:00   2019-10-22T22:10:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1985 ELLIS ST, SAN FRANCISCO, CA, 94115 ELLIS ST 5 Western Addition NORTHERN 37.781436920166 -122.43878173828101 POINT (-122.43878174 37.78143692) Phone   97 4 11 39 11 15 8 29,490 5 41 41   97   11             2         97
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
1377 1377 11462375 2019-09-25T06:11:00 2019-10-22T14:24:53 2019-10-22T14:24:53 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 165 PAGE ST, SAN FRANCISCO, CA, 94102 PAGE ST 5 Lower Haight NORTHERN 37.773788333333 -122.42353 POINT (-122.42353 37.77378833) Mobile/Open311 http://mobile311.sfgov.org/reports/11462375/photos 26 4 11 9 11 7 6 28,852 9 10 10   26   11             1         26
1525 1525 11229658 2019-08-05T14:35:00 2019-10-09T10:24:38 2019-10-09T10:24:38 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of 46TH AVE and TARAVAL ST 46TH AVE 4 Outer Sunset TARAVAL 37.741764068604 -122.504623413086 POINT (-122.50462341 37.74176407) Phone   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
1541 1541 11269996 2019-08-14T09:51:22 2019-10-07T13:30:26 2019-10-07T13:30:26 Closed 2 it appears someone recently pruned the tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 4166 20TH ST, SAN FRANCISCO, CA, 94114 20TH ST 8 Eureka Valley MISSION 37.757901462241 -122.434040584628 POINT (-122.43404058 37.75790146) Mobile/Open311   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1   5     115
1568 1568 11304398 2019-08-21T15:07:00   2019-10-11T15:58:46 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 154 NEWMAN ST, SAN FRANCISCO, CA, 94110 NEWMAN ST 9 Holly Park INGLESIDE 37.737617492676 -122.417091369629 POINT (-122.41709137 37.73761749) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
1576 1576 11560440 2019-10-16T17:06:00 2019-10-22T14:14:11 2019-10-22T14:14:11 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 700 DIVISADERO ST, SAN FRANCISCO, CA, 94117 DIVISADERO ST 5 Alamo Square NORTHERN 37.775891676989005 -122.437853438792 POINT (-122.43785344 37.77589168) Mobile/Open311 http://mobile311.sfgov.org/reports/11560440/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
1700 1700 10924592 2019-05-29T12:33:00   2019-06-10T15:46:10 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 713 SHRADER ST, SAN FRANCISCO, CA, 94117 SHRADER ST 5 Cole Valley PARK 37.768146514893 -122.45178985595699 POINT (-122.45178986 37.76814651) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
1712 1712 11419283 2019-09-15T14:37:00 2019-10-07T17:44:00 2019-10-07T17:44:00 Closed 2 According to DPW, this is private property. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1433 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 Bayview BAYVIEW 37.737487792969 -122.385726928711 POINT (-122.38572693 37.73748779) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1968 1968 5678617 2016-03-18T14:03:32 2016-06-21T03:05:52 2016-06-21T03:05:52 Closed 2 it was relinqished in 2015 and deemed to be acceptable DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 695 MONTEREY BLVD, SAN FRANCISCO, CA, 94127 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731365792993 -122.450866911647 POINT (-122.45086691 37.73136579) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
2089 2089 5678091 2016-03-18T11:47:34 2016-03-23T12:22:00 2016-03-23T12:22:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 409 18TH AVE, SAN FRANCISCO, CA, 94121 18TH AVE 1 Inner Richmond RICHMOND 37.780116158056 -122.47739167597099 POINT (-122.47739168 37.78011616) Phone   5 8 4 29 2 11 9 55 6 26 26   5   4   22         1         5
2092 2092 11486922 2019-09-30T16:42:00   2019-10-07T07:43:27 Open 1 sent RPD TMA Queue 6 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 233 MELROSE AVE, SAN FRANCISCO, CA, 94127 MELROSE AVE 7 Sunnyside INGLESIDE 37.733641666667 -122.447616666667 POINT (-122.44761667 37.73364167) Mobile/Open311 http://mobile311.sfgov.org/reports/11486922/photos 95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
2131 2131 11488495 2019-10-01T07:56:24 2019-10-07T10:31:44 2019-10-07T10:31:44 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2435 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765649864850005 -122.410945382881 POINT (-122.41094538 37.76564986) Web http://mobile311.sfgov.org/reports/11488495/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
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
2533 2533 11501688 2019-10-03T17:14:41 2019-10-07T09:26:29 2019-10-07T09:26:29 Closed 2 what is this request for? e-mailed constituent DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1294 VALLEJO ST, SAN FRANCISCO, CA, 94109 VALLEJO ST 3 Russian Hill CENTRAL 37.797388 -122.41854 POINT (-122.41854 37.797388) Mobile/Open311 http://mobile311.sfgov.org/reports/11501688/photos 107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
2598 2598 11503095 2019-10-04T07:53:00 2019-10-07T07:47:02 2019-10-07T07:47:02 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 473 CAPP ST, SAN FRANCISCO, CA, 94110 CAPP ST 9 Mission MISSION 37.759106 -122.41794099999998 POINT (-122.417941 37.759106) Mobile/Open311 http://mobile311.sfgov.org/reports/11503095/photos 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
2630 2630 11503609 2019-10-04T09:11:08 2019-10-07T10:32:10 2019-10-07T10:32:10 Closed 2 duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2435 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765671068307 -122.410897103119 POINT (-122.4108971 37.76567107) Web http://mobile311.sfgov.org/reports/11503609/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
2998 2998 11509292 2019-10-05T13:11:46 2019-10-07T12:45:39 2019-10-07T12:45:39 Closed 2 contacted property owner who is responsible DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1 FRANKLIN ST, SAN FRANCISCO, CA, 94102 FRANKLIN ST 5 Civic Center NORTHERN 37.774400185043 -122.42094753614401 POINT (-122.42094754 37.77440019) Mobile/Open311 http://mobile311.sfgov.org/reports/11509292/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1 1 1     21
3041 3041 11581187 2019-10-21T14:20:00 2019-10-22T06:57:54 2019-10-22T06:57:54 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 569 25TH AVE, SAN FRANCISCO, CA, 94121 25TH AVE 1 Outer Richmond RICHMOND 37.778759002686 -122.48477935791 POINT (-122.48477936 37.778759) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
3077 3077 11581323 2019-10-21T14:40:00 2019-10-22T08:35:23 2019-10-22T08:35:23 Closed 2 I have a pave over request can you email me at Susan.Nawbary@sfdpw.org and tell me who sent the letter DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 54 RAE AVE, SAN FRANCISCO, CA, 94112 RAE AVE 11 Outer Mission INGLESIDE 37.712173461914 -122.448135375977 POINT (-122.44813538 37.71217346) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
3113 3113 11510348 2019-10-05T17:36:32 2019-10-07T09:18:56 2019-10-07T09:18:56 Closed 2 pruning scheduled for this year. grid 007 Notes:pruning request . BUF Action:Inspect. date completed - 10/7/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 855 SACRAMENTO ST, SAN FRANCISCO, CA, 94108 SACRAMENTO ST 3 Chinatown CENTRAL 37.793231 -122.406922 POINT (-122.406922 37.793231) Mobile/Open311 http://mobile311.sfgov.org/reports/11510348/photos 104 6 3 6 10 3 1 28,857 1 4 4 5 104   3 5     5     2         104
3438 3438 11512959 2019-10-06T14:23:32 2019-10-07T09:35:32 2019-10-07T09:35:32 Closed 2 the tree was inspected in May. our records do not indicate we are removing it. twig dieback normal for species Notes:request to replace tree. BUF Action:Inspect. date completed - 10/7/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 475 VAN NESS AVE, SAN FRANCISCO, CA, 94102 VAN NESS AVE 5 Civic Center NORTHERN 37.7797 -122.42 POINT (-122.42 37.7797) Mobile/Open311   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
3744 3744 11583314 2019-10-22T05:06:00   2019-10-22T05:40:41 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2542 JUDAH ST, SAN FRANCISCO, CA, 94122 JUDAH ST 4 Outer Sunset TARAVAL 37.761207756875 -122.489307675015 POINT (-122.48930768 37.76120776) Mobile/Open311 http://mobile311.sfgov.org/reports/11583314/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
3798 3798 11514506 2019-10-07T00:22:48   2019-10-07T00:30:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 112 MONTCALM ST, SAN FRANCISCO, CA, 94110 MONTCALM ST 9 Peralta Heights INGLESIDE 37.746482 -122.4071608 POINT (-122.4071608 37.746482) Web   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
4071 4071 11583551 2019-10-22T07:30:00   2019-10-22T08:00:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 655 STOCKTON ST, SAN FRANCISCO, CA, 94108 STOCKTON ST 3 Nob Hill CENTRAL 37.792074269058 -122.40760890840099 POINT (-122.40760891 37.79207427) Mobile/Open311 http://mobile311.sfgov.org/reports/11583551/photos 16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
4273 4273 11515551 2019-10-07T09:00:00 2019-10-15T13:27:00 2019-10-15T13:27:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HEARST AVE and FOERSTER ST HEARST AVE 7 Sunnyside INGLESIDE 37.730690002441 -122.44886016845699 POINT (-122.44886017 37.73069) Twitter https://twitter.com/StvnFlngn 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
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
4517 4517 11516259 2019-10-07T10:26:00 2019-10-09T08:28:00 2019-10-09T08:28:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1111 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.753318786621 -122.422821044922 POINT (-122.42282104 37.75331879) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
4677 4677 11516785 2019-10-07T11:32:22   2019-10-07T12:15:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of I-280 N OFF RAMP and SAN JOSE AVE I-280 N OFF RAMP 8 St. Mary's Park INGLESIDE 37.733584 -122.43149 POINT (-122.43149 37.733584) Mobile/Open311   93 9 5 28 5 2 4 28,861 7 25 25   93   5             1         93
4680 4680 11516786 2019-10-07T11:32:33   2019-10-29T18:35:58 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LAWTON ST and 7TH AVE LAWTON ST 7 Inner Sunset PARK 37.758573331463 -122.463848559636 POINT (-122.46384856 37.75857333) Mobile/Open311   109 7 8 14 4 1 8 56 5 12 12   109   8             1         109
4707 4707 11516903 2019-10-07T11:45:00 2019-10-22T14:28:41 2019-10-22T14:28:41 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 Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 396 27TH AVE, SAN FRANCISCO, CA, 94121 27TH AVE 1 Outer Richmond RICHMOND 37.782096176968004 -122.487012329622 POINT (-122.48701233 37.78209618) Mobile/Open311 http://mobile311.sfgov.org/reports/11516903/photos 8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
4789 4789 11517195 2019-10-07T12:18:00   2019-10-07T12:30:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 238 MUNICH ST, SAN FRANCISCO, CA, 94112 MUNICH ST 11 Excelsior INGLESIDE 37.721866607666 -122.426239013672 POINT (-122.42623901 37.72186661) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
4791 4791 11517218 2019-10-07T12:21:00 2019-10-07T12:37:07 2019-10-07T12:37:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1434 QUESADA AVE, SAN FRANCISCO, CA, 94124 QUESADA AVE 10 Bayview BAYVIEW 37.730659484863 -122.38645172119101 POINT (-122.38645172 37.73065948) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
4857 4857 11517473 2019-10-07T12:57:00   2019-10-07T14:00:45 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1948 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Cayuga INGLESIDE 37.721126556396 -122.439163208008 POINT (-122.43916321 37.72112656) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
4961 4961 11517758 2019-10-07T13:33:17   2019-10-07T13:40:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1319 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.752827 -122.4042 POINT (-122.4042 37.752827) Mobile/Open311 http://mobile311.sfgov.org/reports/11517758/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
4965 4965 11517764 2019-10-07T13:34:07   2019-10-07T13:40:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1364 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.752295000000004 -122.404435 POINT (-122.404435 37.752295) Mobile/Open311 http://mobile311.sfgov.org/reports/11517764/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
4980 4980 11517833 2019-10-07T13:44:00   2019-10-21T15:31:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1750 SACRAMENTO ST, SAN FRANCISCO, CA, 94109 SACRAMENTO ST 3 Polk Gulch NORTHERN 37.791500091553004 -122.42172241210899 POINT (-122.42172241 37.79150009) Phone   105 4 3 21 10 13 6 28,858 9 21 21   105   3             1         105
5093 5093 11584425 2019-10-22T09:31:00   2019-10-22T09:40:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1528 HAMPSHIRE ST, SAN FRANCISCO, CA, 94110 HAMPSHIRE ST 9 Peralta Heights INGLESIDE 37.748329162598 -122.406639099121 POINT (-122.4066391 37.74832916) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
5155 5155 11518419 2019-10-07T15:09:00   2019-10-07T16:00:35 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1370 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Dolores Heights MISSION 37.749153137206996 -122.42276763916 POINT (-122.42276764 37.74915314) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
5175 5175 11584535 2019-10-22T09:48:01   2019-10-22T09:55:42 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 24TH ST and MASSACHUSETTS ST 24TH ST 10 Central Waterfront BAYVIEW 37.755224363277 -122.381316852064 POINT (-122.38131685 37.75522436) Mobile/Open311 http://mobile311.sfgov.org/reports/11584535/photos 56 2 9 26 8   3 28,856 3 29 29   56   9             1         56
5221 5221 11518643 2019-10-07T15:38:00   2019-10-07T15:50:17 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 224 HARVARD ST, SAN FRANCISCO, CA, 94134 HARVARD ST 9 University Mound INGLESIDE 37.726715087891 -122.420829772949 POINT (-122.42082977 37.72671509) Phone   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
5234 5234 11584627 2019-10-22T10:04:00   2019-10-22T11:15:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 785 BRANNAN ST, SAN FRANCISCO, CA, 94103 BRANNAN ST 6 South of Market SOUTHERN 37.77318572998 -122.402534484863 POINT (-122.40253448 37.77318573) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32   10             2         32
5288 5288 11518880 2019-10-07T16:15:00   2019-10-20T12:04:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3458 26TH ST, SAN FRANCISCO, CA, 94110 26TH ST 9 Mission MISSION 37.749080657959 -122.419692993164 POINT (-122.41969299 37.74908066) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
5307 5307 11584772 2019-10-22T10:27:00   2019-10-22T10:39:52 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 3098 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 CALIFORNIA ST 2 Pacific Heights RICHMOND 37.787593841553004 -122.44519805908199 POINT (-122.44519806 37.78759384) Phone   102 8 6 30 1 13 9 29,490 6 27 27   102   6             1         102
5352 5352 11519156 2019-10-07T16:58:00 2019-10-07T17:35:50 2019-10-07T17:35:50 Closed 2 10/98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of DELTA ST and LELAND AVE DELTA ST 10 Visitacion Valley INGLESIDE 37.71312713623 -122.409492492676 POINT (-122.40949249 37.71312714) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
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
5392 5392 11519264 2019-10-07T17:24:00   2019-10-07T17:35:16 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1254 41ST AVE, SAN FRANCISCO, CA, 94122 41ST AVE 4 Outer Sunset TARAVAL 37.763362884521 -122.500595092773 POINT (-122.50059509 37.76336288) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
5455 5455 11585234 2019-10-22T11:37:00   2019-10-22T11:45:56 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 51 MARNE AVE, SAN FRANCISCO, CA, 94127 MARNE AVE 7 Sherwood Forest INGLESIDE 37.739490509033 -122.45892333984399 POINT (-122.45892334 37.73949051) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
5501 5501 11585356 2019-10-22T11:53:04   2019-10-22T13:00:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2600 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789680343652 -122.435752728243 POINT (-122.43575273 37.78968034) Mobile/Open311 http://mobile311.sfgov.org/reports/11585356/photos 102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
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
5563 5563 11519734 2019-10-07T19:18:00   2019-10-23T11:17:30 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1419 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.729068299999994 -122.43395670000001 POINT (-122.4339567 37.7290683) Web http://mobile311.sfgov.org/reports/11519734/photos 94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
5610 5610 11585580 2019-10-22T12:28:00   2019-10-22T12:35:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of BAY ST and DIVISADERO ST BAY ST 2 Marina NORTHERN 37.801837921143 -122.443222045898 POINT (-122.44322205 37.80183792) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
5611 5611 11519949 2019-10-07T20:52:32   2019-10-07T21:00:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 384 ALLISON ST, SAN FRANCISCO, CA, 94112 ALLISON ST 11 Crocker Amazon INGLESIDE 37.710160242440004 -122.440802441367 POINT (-122.44080244 37.71016024) Mobile/Open311 http://mobile311.sfgov.org/reports/11519949/photos 58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
5773 5773 11586288 2019-10-22T14:09:00   2019-10-22T14:20:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2755 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 9 Portola BAYVIEW 37.726974487305 -122.403160095215 POINT (-122.4031601 37.72697449) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2   4         2         91
5826 5826 11586668 2019-10-22T15:11:41   2019-10-22T15:55:43 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1930 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Mission Dolores MISSION 37.766420700000005 -122.4271957 POINT (-122.4271957 37.7664207) Mobile/Open311 http://mobile311.sfgov.org/reports/11586668/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37

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