calls

13,387 rows where Request_Type = 5

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
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
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
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
965 965 5683126 2016-03-20T14:26:08 2016-08-02T13:40:17 2016-08-02T13:40:17 Closed 2 see photo this is for landscape/gardeners DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of MALTA DR and OSHAUGHNESSY BLVD MALTA DR 8 Glen Park INGLESIDE 37.736519629304 -122.44368662151199 POINT (-122.44368662 37.73651963) Mobile/Open311 http://mobile311.sfgov.org/reports/5683126/photos 72 9 8 41 4 9 4 63 7 40 40   72   8             1         72
1079 1079 5682449 2016-03-20T09:14:10   2016-03-20T09:36:28 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 90 VERNA ST, SAN FRANCISCO, CA, 94127 VERNA ST 7 Miraloma Park INGLESIDE 37.734508514404 -122.448432922363 POINT (-122.44843292 37.73450851) Web   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
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
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
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
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
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
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
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
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
6924 6924 11613883 2019-10-28T15:27:00   2019-10-28T16:00:20 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CESAR CHAVEZ ST and FLORIDA ST CESAR CHAVEZ ST 9 Peralta Heights MISSION 37.748332977295 -122.40964508056601 POINT (-122.40964508 37.74833298) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
7502 7502 7515634 2017-08-17T11:28:13 2017-08-21T00:00:00 2017-08-21T00:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NEWHALL ST and HUDSON AVE NEWHALL ST 10 Bayview BAYVIEW 37.740043997162 -122.388274912707 POINT (-122.38827491 37.740044) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7610 7610 11627033 2019-10-31T13:04:00   2019-10-31T13:30:12 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 243 GRAFTON AVE, SAN FRANCISCO, CA, 94112 GRAFTON AVE 11 Ingleside TARAVAL 37.719921112061 -122.455879211426 POINT (-122.45587921 37.71992111) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
7847 7847 5670544 2016-03-16T10:20:43 2016-05-27T02:47:00 2016-05-27T02:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of NOE ST and CESAR CHAVEZ ST NOE ST 8 Noe Valley MISSION 37.747433478415 -122.431476739669 POINT (-122.43147674 37.74743348) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
8099 8099 10703913 2019-04-08T17:50:00 2019-10-08T09:20:00 2019-10-08T09:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MINERVA ST and SUMMIT ST MINERVA ST 11 Oceanview TARAVAL 37.715793609619006 -122.453514099121 POINT (-122.4535141 37.71579361) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
8114 8114 10995190 2019-06-14T08:48:00   2019-10-08T15:55:19 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of RHINE ST and DE LONG ST RHINE ST 11 Outer Mission TARAVAL 37.709674835205 -122.460609436035 POINT (-122.46060944 37.70967484) Phone   66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
8199 8199 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1031 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719181060791 -122.396774291992 POINT (-122.39677429 37.71918106) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
8305 8305 11394197 2019-09-10T08:28:00   2019-10-09T06:10:24 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MIDDLE POINT RD and INNES AVE MIDDLE POINT RD 10 Hunters Point BAYVIEW 37.734081268311 -122.379432678223 POINT (-122.37943268 37.73408127) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
8309 8309 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and HUDSON AVE WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.733631134033 -122.382278442383 POINT (-122.38227844 37.73363113) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
8446 8446 11340027 2019-08-29T09:22:00 2019-10-23T15:07:34 2019-10-23T15:07:34 Closed 2 registered as approved planting site DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 3659 18TH ST, SAN FRANCISCO, CA, 94110 18TH ST 8 Mission Dolores MISSION 37.761360168456996 -122.42523193359399 POINT (-122.42523193 37.76136017) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
9828 9828 11517011 2019-10-07T11:54:00 2019-10-08T13:44:32 2019-10-08T13:44:32 Closed 2 we will allow FUF to hand dig , I've emailed them asking them to carry on Susan.Nawbary@sfdpw.org DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1366 4TH AVE, SAN FRANCISCO, CA, 94122 4TH AVE 5 Inner Sunset PARK 37.763248443604 -122.460723876953 POINT (-122.46072388 37.76324844) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
10064 10064 11518944 2019-10-07T16:26:00 2019-10-08T08:47:05 2019-10-08T08:47:05 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 495 38TH AVE, SAN FRANCISCO, CA, 94121 38TH AVE 1 Outer Richmond RICHMOND 37.779720644522 -122.49883634663999 POINT (-122.49883635 37.77972064) Mobile/Open311   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
11092 11092 11522140 2019-10-08T10:56:00   2019-10-08T12:07:53 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 282 2ND ST, SAN FRANCISCO, CA, 94105 2ND ST 6 South of Market SOUTHERN 37.785542 -122.3971267 POINT (-122.3971267 37.785542) Web   32 1 10 8 9 6 2 28,855 2 6 6   32   10         4   1         32
11125 11125 11522242 2019-10-08T11:12:34   2019-10-08T12:50:21 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
12116 12116 11588776 2019-10-23T08:01:00   2019-10-23T08:30:47 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LYON ST and FILBERT ST LYON ST 2 Cow Hollow NORTHERN 37.796577453613 -122.44701385498001 POINT (-122.44701385 37.79657745) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
12697 12697 11591922 2019-10-23T14:26:00   2019-10-23T14:35:44 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 1245 30TH AVE, SAN FRANCISCO, CA, 94122 30TH AVE 4 Outer Sunset TARAVAL 37.764011383056996 -122.489112854004 POINT (-122.48911285 37.76401138) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
13519 13519 10990704 2019-06-13T09:23:00 2019-10-09T14:44:00 2019-10-09T14:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of PALMETTO AVE and HEAD ST PALMETTO AVE 7 Merced Heights TARAVAL 37.71076965332 -122.46436309814501 POINT (-122.4643631 37.71076965) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
13890 13890 9813152 2018-11-15T13:22:06 2018-12-07T07:32:25 2018-12-07T07:32:25 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 - Landscaping 5 Other Intersection of GOUGH ST and ELLIS ST GOUGH ST 5 Cathedral Hill NORTHERN 37.78339704256 -122.424289381376 POINT (-122.42428938 37.78339704) Mobile/Open311   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
13946 13946 5675217 2016-03-17T13:39:56 2016-04-28T09:02:50 2016-04-28T09:02:50 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1077 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Ashbury Heights PARK 37.763133333333 -122.44688333333299 POINT (-122.44688333 37.76313333) Mobile/Open311 http://mobile311.sfgov.org/reports/5675217/photos 114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
14049 14049 5674640 2016-03-17T11:39:27 2016-05-27T02:38:00 2016-05-27T02:38:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
14557 14557 11339611 2019-08-29T08:24:00   2019-10-07T10:05:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 60 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.781170700000004 -122.4135524 POINT (-122.4135524 37.7811707) Web http://mobile311.sfgov.org/reports/11339611/photos 20 5 10 36 9 7 10 28,852 10 36 36   20 1 10     1   6 1 2 1 1     20
14574 14574 11335785 2019-08-28T11:23:00   2019-10-08T12:55:27 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3402 CLAY ST, SAN FRANCISCO, CA, 94118 CLAY ST 2 Presidio Heights RICHMOND 37.788928985596 -122.44912719726601 POINT (-122.4491272 37.78892899) Phone   10 8 6 31 1 13 9 54 6 31 31   10   6             1         10
14796 14796 11113957 2019-07-11T10:51:00 2019-10-01T11:54:00 2019-10-01T11:54:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of FRANCISCO ST and POWELL ST FRANCISCO ST 3 North Beach CENTRAL 37.80489730835 -122.411766052246 POINT (-122.41176605 37.80489731) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
14887 14887 11501046 2019-10-03T15:21:00 2019-10-06T10:10:00 2019-10-06T10:10:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
14902 14902 10991190 2019-06-13T10:41:00 2019-10-04T11:37:00 2019-10-04T11:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 29 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 6 South of Market SOUTHERN 37.772304 -122.422473 POINT (-122.422473 37.772304) Mobile/Open311   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
14926 14926 10923701 2019-05-29T10:27:00 2019-10-01T11:34:00 2019-10-01T11:34:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1059 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Nob Hill CENTRAL 37.7906451 -122.4179937 POINT (-122.4179937 37.7906451) Web http://mobile311.sfgov.org/reports/10923701/photos 16 6 3 21 10 13 1 28,858 1 21 21   16   3             1         16
14960 14960 5672447 2016-03-16T16:34:09 2016-04-28T08:51:39 2016-04-28T08:51:39 Closed 2 done DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LAGUNA ST and REDWOOD ST LAGUNA ST 5 Western Addition NORTHERN 37.779596666667 -122.426895 POINT (-122.426895 37.77959667) Mobile/Open311 http://mobile311.sfgov.org/reports/5672447/photos 97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
14986 14986 10516677 2019-02-21T12:21:00 2019-10-01T13:42:01 2019-10-01T13:42:01 Closed 2 Notes:stump grind . BUF Action:Remove Stump. Notes:stump grind :: Closed By CMMS SO 1132759. BUF Action:Remove Stump. date completed - 10/1/2019. Notes:stump grind :: Closed By CMMS SO 1132759from CMMS: . BUF Action:Remove Stump. date completed - 10/1/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of CENTRAL AVE and MCALLISTER ST CENTRAL AVE 5 Western Addition PARK 37.776958465576 -122.444969177246 POINT (-122.44496918 37.77695847) Phone   97 7 11 18 11 15 8 29,492 5 16 16   97   11             1         97
15594 15594 11510218 2019-10-05T17:01:00 2019-10-06T10:00:00 2019-10-06T10:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1847 47TH AVE, SAN FRANCISCO, CA, 94122 47TH AVE 4 Outer Sunset TARAVAL 37.751933 -122.50673799999998 POINT (-122.506738 37.751933) Mobile/Open311 http://mobile311.sfgov.org/reports/11510218/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
16630 16630 11513414 2019-10-06T16:22:00   2019-10-06T16:41:52 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3677 22ND ST, SAN FRANCISCO, CA, 94114 22ND ST 8 Dolores Heights MISSION 37.754771257037 -122.429459812731 POINT (-122.42945981 37.75477126) Mobile/Open311   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
17480 17480 10998649 2019-06-14T17:58:00 2019-07-16T12:33:00 2019-07-16T12:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BAY SHORE BLVD and CARROLL AVE BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.730659484863 -122.40340423584 POINT (-122.40340424 37.73065948) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
17945 17945 11522241 2019-10-08T11:12:32 2019-10-09T08:14:00 2019-10-09T08:14:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
18140 18140 11155298 2019-07-20T11:03:00   2019-09-21T11:11:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BRADFORD ST and TOMPKINS AVE BRADFORD ST 9 Bernal Heights INGLESIDE 37.73685836792 -122.40975952148399 POINT (-122.40975952 37.73685837) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
18214 18214 5663870 2016-03-14T14:29:24 2016-03-25T12:00:00 2016-03-25T12:00:00 Closed 2 Request closed by in Operations system at Mar 25 2016 12:00AM. Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 3/25/2016. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of 24TH ST and SAN JOSE AVE 24TH ST 8 Mission MISSION 37.752045057488 -122.421594879129 POINT (-122.42159488 37.75204506) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
19358 19358 5657343 2016-03-11T18:49:16 2016-06-21T11:18:49 2016-06-21T11:18:49 Closed 2 SES Graffiti Crew - Removed Stickers - Pole - Power Line - WOOD DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 40 MALTA DR, SAN FRANCISCO, CA, 94131 MALTA DR 7 Miraloma Park INGLESIDE 37.735241666667 -122.44375500000001 POINT (-122.443755 37.73524167) Mobile/Open311 http://mobile311.sfgov.org/reports/5657343/photos 72 9 8 41 4 9 4 63 7 40 40   72   8             1         72
19517 19517 10984577 2019-06-11T21:28:18   2019-06-11T22:10:05 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of FRIEDELL ST and HUDSON AVE FRIEDELL ST 10 Hunters Point BAYVIEW 37.729016666667 -122.369011666667 POINT (-122.36901167 37.72901667) Mobile/Open311 http://mobile311.sfgov.org/reports/10984577/photos 78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
20657 20657 11148097 2019-07-18T15:57:00   2019-10-10T11:08:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTCALM ST and WRIGHT ST MONTCALM ST 9 Peralta Heights INGLESIDE 37.747459411621 -122.405921936035 POINT (-122.40592194 37.74745941) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
20693 20693 11383528 2019-09-07T17:08:00   2019-10-10T01:30:27 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 900 POWHATTAN AVE, SAN FRANCISCO, CA, 94110 POWHATTAN AVE 9 Bernal Heights INGLESIDE 37.741302490234 -122.411064147949 POINT (-122.41106415 37.74130249) Phone http://mobile311.sfgov.org/reports/11383528/photos 83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
20757 20757 11488668 2019-10-01T08:22:00 2019-10-11T12:51:58 2019-10-11T12:51:58 Closed 2 Case Resolved Close Note: Staff have cut back vegetation and cleared soil from the road. RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Landscaping 5 Weeding 39 DALEWOOD WAY, SAN FRANCISCO, CA, 94127 DALEWOOD WAY 7 Sherwood Forest INGLESIDE 37.737037658691 -122.45471954345699 POINT (-122.45471954 37.73703766) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
21108 21108 11523861 2019-10-08T15:19:00   2019-10-18T13:37:22 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 17TH AVE and NORIEGA ST 17TH AVE 7 Golden Gate Heights TARAVAL 37.754333496094 -122.474334716797 POINT (-122.47433472 37.7543335) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
21857 21857 11531342 2019-10-10T09:29:00   2019-10-10T10:20:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 122 ROUSSEAU ST, SAN FRANCISCO, CA, 94112 ROUSSEAU ST 8 St. Mary's Park INGLESIDE 37.732772827148 -122.43030548095699 POINT (-122.43030548 37.73277283) Phone   93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
22075 22075 11532343 2019-10-10T11:57:17   2019-10-10T12:50:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3535 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 8 Mission Dolores MISSION 37.759907 -122.422193 POINT (-122.422193 37.759907) Mobile/Open311 http://mobile311.sfgov.org/reports/11532343/photos 37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
22316 22316 11533673 2019-10-10T15:25:21   2019-10-10T15:55:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3555 CALIFORNIA ST, SAN FRANCISCO, CA, 94118 CALIFORNIA ST 2 Laurel Heights / Jordan Park RICHMOND 37.786324 -122.4526558 POINT (-122.4526558 37.786324) Web http://mobile311.sfgov.org/reports/11533673/photos 11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
22374 22374 11534030 2019-10-10T16:36:13   2019-10-10T17:10:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1814 MCALLISTER ST, SAN FRANCISCO, CA, 94115 MCALLISTER ST 5 Western Addition PARK 37.777445 -122.44203 POINT (-122.44203 37.777445) Mobile/Open311 http://mobile311.sfgov.org/reports/11534030/photos 97 7 11 18 11 15 8 29,490 5 16 16   97   11             1         97
22590 22590 11536735 2019-10-11T11:03:12   2019-10-11T12:00:36 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1298 THOMAS AVE, SAN FRANCISCO, CA, 94124 THOMAS AVE 10 Hunters Point BAYVIEW 37.727312 -122.385581 POINT (-122.385581 37.727312) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
22608 22608 11537841 2019-10-11T13:56:00   2019-10-11T14:05:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of CONGDON ST and MAYNARD ST CONGDON ST 11 Mission Terrace INGLESIDE 37.729396820068004 -122.426025390625 POINT (-122.42602539 37.72939682) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
23049 23049 11254502 2019-08-10T18:15:00 2019-09-18T14:46:00 2019-09-18T14:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BALBOA ST and 26TH AVE BALBOA ST 1 Outer Richmond RICHMOND 37.776252746581996 -122.48553466796899 POINT (-122.48553467 37.77625275) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
23117 23117 10812812 2019-05-03T12:32:00 2019-10-27T12:05:00 2019-10-27T12:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1006 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715091705321996 -122.471435546875 POINT (-122.47143555 37.71509171) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
23554 23554 11569034 2019-10-18T12:50:00 2019-10-24T16:42:05 2019-10-24T16:42:05 Closed 2 the city currently has very limited planting resources and are focusing efforts on certain districts with very low tree canopy coverage. this basin will be replaced as the budget allows. you can replant your tree with a landscaping company or with Friends of the urban forest, but please contact 415.554.6700 for a tree permit DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 101 NOE ST, SAN FRANCISCO, CA, 94114 NOE ST 8 Duboce Triangle PARK 37.76732635498 -122.433212280273 POINT (-122.43321228 37.76732635) Phone   28 7 5 5 5 15 8 28,862 5 3 3 18 28   5 20     20     1   5     28
24259 24259 11586026 2019-10-22T13:34:00 2019-10-25T09:06:09 2019-10-25T09:06:09 Closed 2 sent back fill request the city currently has very limited planting resources and are focusing efforts on certain districts with very low tree canopy coverage. this basin will be replaced as the budget allows. you can replant your tree with a landscaping company or with Friends of the urban forest, but please contact 415.554.6700 for a tree permit DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 945 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Lower Nob Hill CENTRAL 37.789739799941 -122.417135469884 POINT (-122.41713547 37.7897398) Mobile/Open311 http://mobile311.sfgov.org/reports/11586026/photos 50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
27709 27709 11601003 2019-10-25T12:38:00   2019-10-25T13:35:51 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 371 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Duboce Triangle PARK 37.771114349365 -122.42974853515601 POINT (-122.42974854 37.77111435) Phone   28 7 11 9 11 7 6 29,492 9 10 10   28   11             1         28
27710 27710 11601004 2019-10-25T12:38:00   2019-10-25T13:35:50 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 301 EXECUTIVE PARK BLVD, SAN FRANCISCO, CA, 94134 EXECUTIVE PARK BLVD 10 Candlestick Point SRA BAYVIEW 37.711143493652 -122.390769958496 POINT (-122.39076996 37.71114349) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
29130 29130 11535838 2019-10-11T08:53:00   2019-10-11T09:40:27 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 4612 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Bayview BAYVIEW 37.736199 -122.390266 POINT (-122.390266 37.736199) Mobile/Open311   86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
29446 29446 11536786 2019-10-11T11:10:00 2019-10-21T14:33:00 2019-10-21T14:33:00 Closed 2 Landscape - Area has been weeded & liter picked. needs plants Thank you. SMckinney / AEvans DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1203 REVERE AVE, SAN FRANCISCO, CA, 94124 REVERE AVE 10 Hunters Point BAYVIEW 37.727483 -122.382922 POINT (-122.382922 37.727483) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
29601 29601 11537291 2019-10-11T12:20:38 2019-10-21T14:44:00 2019-10-21T14:44:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1211 SHAFTER AVE, SAN FRANCISCO, CA, 94124 SHAFTER AVE 10 Hunters Point BAYVIEW 37.726894 -122.38358600000001 POINT (-122.383586 37.726894) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
29617 29617 11537300 2019-10-11T12:21:38   2019-10-11T12:40:26 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of INGALLS ST and SHAFTER AVE INGALLS ST 10 Hunters Point BAYVIEW 37.72781 -122.38508 POINT (-122.38508 37.72781) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
29620 29620 11537311 2019-10-11T12:23:59   2019-10-11T12:45:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 2501 INGALLS ST, SAN FRANCISCO, CA, 94124 INGALLS ST 10 Hunters Point BAYVIEW 37.723193 -122.38930900000001 POINT (-122.389309 37.723193) Mobile/Open311   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
29730 29730 11537793 2019-10-11T13:47:38   2019-10-11T14:40:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1413 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 SAN BRUNO AVE 10 Potrero Hill MISSION 37.751381 -122.404358 POINT (-122.404358 37.751381) Mobile/Open311 http://mobile311.sfgov.org/reports/11537793/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
29820 29820 11538110 2019-10-11T14:51:00   2019-10-11T16:15:25 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 323 BARTLETT ST, SAN FRANCISCO, CA, 94110 BARTLETT ST 9 Mission MISSION 37.751751771437995 -122.419459401628 POINT (-122.4194594 37.75175177) Mobile/Open311 http://mobile311.sfgov.org/reports/11538110/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
29998 29998 11538690 2019-10-11T16:20:00 2019-10-11T22:15:52 2019-10-11T22:15:52 Closed 2 Request is a duplicate and has been previously reported as 11532343 DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3533 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 8 Mission Dolores MISSION 37.760009000000004 -122.422095 POINT (-122.422095 37.760009) Mobile/Open311 http://mobile311.sfgov.org/reports/11538690/photos 37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
31352 31352 11607152 2019-10-27T03:23:00 2019-10-29T10:10:00 2019-10-28T04:20:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of CALIFORNIA ST and TAYLOR ST CALIFORNIA ST 3 Nob Hill CENTRAL 37.791625976563 -122.412460327148 POINT (-122.41246033 37.79162598) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
32956 32956 11611478 2019-10-28T09:29:50 2019-10-29T16:19:29 2019-10-29T16:19:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
32957 32957 11611479 2019-10-28T09:29:53 2019-10-30T11:51:00 2019-10-30T11:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 421 LEAVENWORTH ST, SAN FRANCISCO, CA, 94102 LEAVENWORTH ST 6 Tenderloin TENDERLOIN 37.785018920898 -122.41464233398399 POINT (-122.41464233 37.78501892) Integrated Agency   20 5 10 36 9 7 10 28,858 10 36 36   20   10         6 1 2 1       20
33916 33916 11614275 2019-10-28T16:36:00   2019-10-28T17:10:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CESAR CHAVEZ ST and NOE ST CESAR CHAVEZ ST 8 Noe Valley MISSION 37.74743270874 -122.43147277831999 POINT (-122.43147278 37.74743271) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
35411 35411 11617730 2019-10-29T12:24:00   2019-10-29T13:20:06 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 20TH ST and CHURCH ST 20TH ST 8 Dolores Heights MISSION 37.758087158203004 -122.428047180176 POINT (-122.42804718 37.75808716) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
35517 35517 11618000 2019-10-29T13:06:19   2019-10-29T14:20:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 18TH ST and SAN CARLOS ST 18TH ST 9 Mission MISSION 37.761798 -122.42004299999999 POINT (-122.420043 37.761798) Mobile/Open311 http://mobile311.sfgov.org/reports/11618000/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
35971 35971 11619231 2019-10-29T16:23:00   2019-10-29T17:05:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 215 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710277557373 -122.46923065185499 POINT (-122.46923065 37.71027756) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35976 35976 11619243 2019-10-29T16:25:00   2019-10-29T17:10:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 130 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711681365967 -122.46935272216801 POINT (-122.46935272 37.71168137) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35984 35984 11619257 2019-10-29T16:26:00 2019-10-30T08:57:16 2019-10-30T08:57:16 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 134 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711620330811 -122.46935272216801 POINT (-122.46935272 37.71162033) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
36193 36193 11619685 2019-10-29T17:50:00 2019-10-30T06:46:57 2019-10-30T06:46:57 Closed 2 Should be routed to 311 Call Center DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 153 OXFORD ST, SAN FRANCISCO, CA, 94134 OXFORD ST 9 University Mound INGLESIDE 37.727936 -122.4198487 POINT (-122.4198487 37.727936) Web   92 9 2 7 7 9 4 309 7 5 5   92   2             2         92
37597 37597 11622869 2019-10-30T13:58:37   2019-10-30T15:20:08 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 25TH ST and VERMONT ST 25TH ST 10 Potrero Hill MISSION 37.751944 -122.40333600000001 POINT (-122.403336 37.751944) Mobile/Open311 http://mobile311.sfgov.org/reports/11622869/photos 54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
38421 38421 11549960 2019-10-14T16:19:00   2019-10-30T09:50:12 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of MISSION ST and 23RD ST MISSION ST 9 Mission MISSION 37.753837585449 -122.418594360352 POINT (-122.41859436 37.75383759) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
38779 38779 11625433 2019-10-31T08:26:00   2019-10-31T08:55:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GILROY ST and INGERSON AVE GILROY ST 10 Bret Harte BAYVIEW 37.71688079834 -122.38913726806601 POINT (-122.38913727 37.7168808) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
39237 39237 11626424 2019-10-31T11:13:00   2019-10-31T12:00:11 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 311 VIRGINIA AVE, SAN FRANCISCO, CA, 94110 VIRGINIA AVE 9 Bernal Heights INGLESIDE 37.742023468018 -122.41858673095699 POINT (-122.41858673 37.74202347) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
39536 39536 11627160 2019-10-31T13:24:00   2019-10-31T14:00:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of POPLAR ST and 26TH ST POPLAR ST 8 Mission MISSION 37.748878479004 -122.420829772949 POINT (-122.42082977 37.74887848) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
39894 39894 11628119 2019-10-31T16:11:00   2019-10-31T22:37:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1309 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.729553222656 -122.433395385742 POINT (-122.43339539 37.72955322) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
40365 40365 3937135 2014-08-21T09:59:23 2014-11-16T03:23:09 2014-11-16T03:23:09 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of JUNIPERO SERRA BLVD and GARFIELD ST JUNIPERO SERRA BLVD 11 Ingleside TARAVAL 37.719635009766 -122.472343444824 POINT (-122.47234344 37.71963501) Web   64 10 8 24 4 9 5 64 8 24 24   64   8             2         64
41042 41042 11410608 2019-09-13T10:32:00 2019-10-09T11:30:00 2019-10-09T11:30:00 Closed 2 Referred to CES. To view status, see http://dbiweb.sfgov.org/dbipts/default.aspx?page=AddressComplaint&ComplaintNo=201992171 or call (415) 558-6454. DBI Inspection Services Queue 17 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 300 BELLA VISTA WAY, SAN FRANCISCO, CA, 94127 BELLA VISTA WAY 7 Miraloma Park INGLESIDE 37.736595153809 -122.451972961426 POINT (-122.45197296 37.73659515) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
41046 41046 11419449 2019-09-15T15:49:00   2019-10-09T06:10:20 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Other 1425 17TH ST, SAN FRANCISCO, CA, 94107 17TH ST 10 Potrero Hill SOUTHERN 37.765003333333 -122.398361666667 POINT (-122.39836167 37.76500333) Mobile/Open311 http://mobile311.sfgov.org/reports/11419449/photos 54 1 9 26 8 14 3 28,856 3 29 29   54   9             1         54
43003 43003 11528189 2019-10-09T14:11:00   2019-10-30T10:00:12 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of GEARY BLVD and DIVISADERO ST GEARY BLVD 5 Western Addition NORTHERN 37.783309936523 -122.439483642578 POINT (-122.43948364 37.78330994) Phone   103 4 11 15 11 15 8 29,490 5 13 13   103   11             2         103
43404 43404 11538660 2019-10-11T16:16:00   2019-10-11T16:55:23 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3420 19TH ST, SAN FRANCISCO, CA, 94110 19TH ST 9 Mission MISSION 37.760306 -122.41973899999999 POINT (-122.419739 37.760306) Mobile/Open311 http://mobile311.sfgov.org/reports/11538660/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
43816 43816 10886739 2019-05-20T13:55:00   2019-05-22T17:55:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 655 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.73722076416 -122.38280487060499 POINT (-122.38280487 37.73722076) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
43895 43895 10870536 2019-05-16T11:56:00 2019-05-30T11:36:00 2019-05-30T11:36:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1450 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.773590999999996 -122.414852 POINT (-122.414852 37.773591) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
44004 44004 7091066 2017-04-28T08:45:47 2017-04-28T03:37:00 2017-04-28T03:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GRAYSTONE TER and IRON ALY GRAYSTONE TER 8 Clarendon Heights PARK 37.757270904363 -122.44496649598699 POINT (-122.4449665 37.7572709) Phone   47 7 5 5 5 2 8 28,862 5 3 3   47   5             1         47
44409 44409 11490692 2019-10-01T13:18:00   2019-10-01T14:30:13 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 95 MCCOPPIN ST, SAN FRANCISCO, CA, 94103 MCCOPPIN ST 6 South of Market SOUTHERN 37.771102905273 -122.422050476074 POINT (-122.42205048 37.77110291) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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