calls

7,158 rows where Responsible_Agency = 2 sorted by Request_Type descending

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
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
4309 4309 11515675 2019-10-07T09:14:00   2019-10-07T10:00:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3274 26TH ST, SAN FRANCISCO, CA, 94110 26TH ST 9 Mission MISSION 37.749320983887 -122.41564178466801 POINT (-122.41564178 37.74932098) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
5384 5384 11585037 2019-10-22T11:06:00   2019-10-22T12:10:42 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of SUNSET BLVD and MORAGA ST SUNSET BLVD 4 Outer Sunset TARAVAL 37.755275726318004 -122.495361328125 POINT (-122.49536133 37.75527573) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
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
7847 7847 5670544 2016-03-16T10:20:43 2016-05-27T02:47:00 2016-05-27T02:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of NOE ST and CESAR CHAVEZ ST NOE ST 8 Noe Valley MISSION 37.747433478415 -122.431476739669 POINT (-122.43147674 37.74743348) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
8099 8099 10703913 2019-04-08T17:50:00 2019-10-08T09:20:00 2019-10-08T09:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MINERVA ST and SUMMIT ST MINERVA ST 11 Oceanview TARAVAL 37.715793609619006 -122.453514099121 POINT (-122.4535141 37.71579361) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
8199 8199 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1031 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719181060791 -122.396774291992 POINT (-122.39677429 37.71918106) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
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
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
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                                                        
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
17480 17480 10998649 2019-06-14T17:58:00 2019-07-16T12:33:00 2019-07-16T12:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BAY SHORE BLVD and CARROLL AVE BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.730659484863 -122.40340423584 POINT (-122.40340424 37.73065948) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
18140 18140 11155298 2019-07-20T11:03:00   2019-09-21T11:11:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BRADFORD ST and TOMPKINS AVE BRADFORD ST 9 Bernal Heights INGLESIDE 37.73685836792 -122.40975952148399 POINT (-122.40975952 37.73685837) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
20657 20657 11148097 2019-07-18T15:57:00   2019-10-10T11:08:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTCALM ST and WRIGHT ST MONTCALM ST 9 Peralta Heights INGLESIDE 37.747459411621 -122.405921936035 POINT (-122.40592194 37.74745941) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
21108 21108 11523861 2019-10-08T15:19:00   2019-10-18T13:37:22 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 17TH AVE and NORIEGA ST 17TH AVE 7 Golden Gate Heights TARAVAL 37.754333496094 -122.474334716797 POINT (-122.47433472 37.7543335) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
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
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
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
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
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
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
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
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
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
44411 44411 11574866 2019-10-20T01:55:00   2019-10-20T02:25:36 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of TIFFANY AVE and VALENCIA ST TIFFANY AVE 9 Bernal Heights INGLESIDE 37.746574401855 -122.420127868652 POINT (-122.42012787 37.7465744) Phone http://mobile311.sfgov.org/reports/11574866/photos 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
44667 44667 11536012 2019-10-11T09:21:00   2019-10-22T11:11:22 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of HESTER AVE and BAY SHORE BLVD HESTER AVE 10 Visitacion Valley INGLESIDE 37.715339660645 -122.398994445801 POINT (-122.39899445 37.71533966) Phone   75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
45347 45347 11541521 2019-10-12T12:38:00   2019-10-12T13:10:24 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SAN JOSE AVE and SAINT MARYS AVE SAN JOSE AVE 8 St. Mary's Park INGLESIDE 37.734951019287 -122.428436279297 POINT (-122.42843628 37.73495102) Phone   93 9 5 2 5 2 4 28,861 7 2 2   93   5             1         93
45740 45740 10681827 2019-04-03T12:44:00 2019-09-25T15:08:00 2019-09-25T15:08:00 Closed 2 Job complete - Duplicate DREED60098 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SUNSET BLVD and OCEAN AVE SUNSET BLVD 7 Lakeshore TARAVAL 37.731910705566 -122.493721008301 POINT (-122.49372101 37.73191071) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
45748 45748 10713753 2019-04-10T18:26:00 2019-09-27T11:02:47 2019-09-27T11:02:47 Closed 2 Notes - Needs more information - Thank you, ACraven946 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of MARKET ST and 6TH ST MARKET ST 6 Tenderloin TENDERLOIN 37.782230377196996 -122.410293579102 POINT (-122.41029358 37.78223038) Phone   20 5 10 34 9 14 2 28,853 2 34 34 17 20 1 10 18   1 18 7 1 2 1 1 35   20
45763 45763 10759845 2019-04-22T06:50:00 2019-09-26T15:09:00 2019-09-26T15:09:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LAKE MERCED BLVD and SKYLINE BLVD LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.732269287109 -122.49810791015601 POINT (-122.49810791 37.73226929) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
45821 45821 11001547 2019-06-15T15:55:00   2019-09-24T11:40:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 36TH AVE and SANTIAGO ST 36TH AVE 4 Parkside TARAVAL 37.744113922119006 -122.494041442871 POINT (-122.49404144 37.74411392) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
46094 46094 11230262 2019-08-05T16:14:00 2019-09-27T14:22:00 2019-09-27T14:22:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 162 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.744312286377 -122.458251953125 POINT (-122.45825195 37.74431229) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
46306 46306 11314161 2019-08-23T14:19:00   2019-10-18T15:34:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of JUNIPERO SERRA BLVD and OCEAN AVE JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.731204986571996 -122.47216033935499 POINT (-122.47216034 37.73120499) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
46972 46972 11407269 2019-09-12T14:52:00 2019-09-24T09:35:00 2019-09-24T09:35:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WEST PORTAL AVE and PORTOLA DR WEST PORTAL AVE 7 Merced Manor TARAVAL 37.734706878662 -122.471572875977 POINT (-122.47157288 37.73470688) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
47023 47023 11411057 2019-09-13T11:48:00   2019-09-27T09:45:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SAN JOSE AVE and OCEAN AVE SAN JOSE AVE 11 Mission Terrace INGLESIDE 37.722965240479 -122.44474792480499 POINT (-122.44474792 37.72296524) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2     70   80
47446 47446 11427239 2019-09-17T10:33:00   2019-09-27T10:20:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of HARNEY WAY and JAMESTOWN AVE HARNEY WAY 10 Candlestick Point SRA BAYVIEW 37.711162567139 -122.38645172119101 POINT (-122.38645172 37.71116257) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
48270 48270 11444221 2019-09-20T16:44:00 2019-09-26T14:24:00 2019-09-26T14:24:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 501 POTRERO AVE, SAN FRANCISCO, CA, 94110 POTRERO AVE 10 Potrero Hill MISSION 37.763191223145 -122.40721893310499 POINT (-122.40721893 37.76319122) Phone http://mobile311.sfgov.org/reports/11444221/photos 54 3 9 20 8 8 7 28,859 4 19 19   54   9     3   15   2   3     54
48508 48508 11446960 2019-09-21T13:19:00 2019-09-27T14:08:00 2019-09-27T14:08:00 Closed 2 Landscape - Area Inspected - No access to back of house / Private Property. EHernandez DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 45 FREDSON CT, SAN FRANCISCO, CA, 94112 FREDSON CT 11 Outer Mission INGLESIDE 37.71354675293 -122.44727325439501 POINT (-122.44727325 37.71354675) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
52196 52196 11463262 2019-09-25T09:13:00   2019-09-25T10:05:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PEMBERTON PL and VILLA TER PEMBERTON PL 8 Clarendon Heights PARK 37.758453369141 -122.44676971435499 POINT (-122.44676971 37.75845337) Phone   47 7 5 5 5 15 8 28,862 5 3 3   47   5             1         47
54207 54207 11469291 2019-09-26T12:42:00   2019-09-26T13:20:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH AVE and LINCOLN WAY 5TH AVE 5 Inner Sunset PARK 37.766109466553004 -122.462158203125 POINT (-122.4621582 37.76610947) Phone   109 7 11 14 11 11 8 29,492 5 12 12   109   11             1         109
55111 55111 11472317 2019-09-27T08:24:00   2019-10-21T08:26:30 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MASONIC AVE and GEARY BLVD MASONIC AVE 2 Lone Mountain RICHMOND 37.782390594482 -122.447303771973 POINT (-122.44730377 37.78239059) Phone   12 8 4 18 2 15 8 54 5 16 16   12   4             1     7   12
55223 55223 11472616 2019-09-27T09:10:00   2019-09-27T10:00:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 23RD ST and ARKANSAS ST 23RD ST 10 Potrero Hill BAYVIEW 37.754825592041 -122.39772796630899 POINT (-122.39772797 37.75482559) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
58153 58153 9648717 2018-10-09T14:32:00 2019-09-25T15:15:00 2019-09-25T15:15:00 Closed 2 Job Complete - Duplicate DREED60098 - The Monterey Blvd Medians is scheduled for planned maintenance. (See Multi-Assets for full scope of work.) DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
59386 59386 11490810 2019-10-01T13:36:00   2019-10-04T09:15:13 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 30TH AVE and CALIFORNIA ST 30TH AVE 2 Seacliff RICHMOND 37.783641815186 -122.49036407470699 POINT (-122.49036407 37.78364182) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
59992 59992 11511529 2019-10-06T08:20:00   2019-10-06T08:55:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DOLORES ST and MARKET ST DOLORES ST 8 Mission Dolores MISSION 37.76904296875 -122.426856994629 POINT (-122.42685699 37.76904297) Phone   37 3 5 20 5 8 7 28,862 4 19 19   37   5     5   9   2   5     37
60050 60050 11513655 2019-10-06T17:39:00   2019-10-06T18:10:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of VISITACION AVE and RUTLAND ST VISITACION AVE 10 Visitacion Valley INGLESIDE 37.711448669434 -122.407928466797 POINT (-122.40792847 37.71144867) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
60115 60115 11473778 2019-09-27T12:08:00   2019-10-07T16:00:33 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3400 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 10 Portola INGLESIDE 37.719013214111 -122.400535583496 POINT (-122.40053558 37.71901321) Phone   91 9 9 40 8 10 4 309 7 39 39   91   9             2         91
60951 60951 11576077 2019-10-20T12:07:00   2019-10-20T12:40:39 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 715 ROCKDALE DR, SAN FRANCISCO, CA, 94127 ROCKDALE DR 7 Miraloma Park INGLESIDE 37.741176605225 -122.451377868652 POINT (-122.45137787 37.74117661) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
61031 61031 11530813 2019-10-10T08:17:00 2019-10-15T11:26:00 2019-10-15T11:26:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 919 ROCKDALE DR, SAN FRANCISCO, CA, 94127 ROCKDALE DR 7 Miraloma Park INGLESIDE 37.740951538086 -122.45447540283199 POINT (-122.4544754 37.74095154) Phone https://goo.gl/maps/wtv83isidzk5UNfw5 72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
62507 62507 11554852 2019-10-15T15:39:00   2019-10-15T16:25:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Phone   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
64040 64040 10771219 2019-04-24T10:15:00 2019-09-30T14:50:12 2019-09-30T14:50:12 Closed 2 Work Completed - DREED60098 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of CURTIS ST and NAPLES ST CURTIS ST 11 Crocker Amazon INGLESIDE 37.711097717285 -122.43881225585899 POINT (-122.43881226 37.71109772) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
64043 64043 10833228 2019-05-08T09:31:00 2019-09-30T14:46:56 2019-09-30T14:46:56 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SKYLINE BLVD and JOHN MUIR DR SKYLINE BLVD 7 Lakeshore TARAVAL 37.718955993652 -122.50022125244101 POINT (-122.50022125 37.71895599) Phone   43 10 8 16 4 1 5   8 14 14   43   8             2         43
64066 64066 10983555 2019-06-11T16:49:00 2019-09-30T14:45:17 2019-09-30T14:45:17 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
64230 64230 11386236 2019-09-08T14:43:00   2019-09-30T11:57:04 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of PORTOLA DR and SAN PABLO AVE PORTOLA DR 7 St. Francis Wood TARAVAL 37.740295410156 -122.46106719970699 POINT (-122.4610672 37.74029541) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
65477 65477 11477310 2019-09-28T10:52:00 2019-09-30T12:34:00 2019-09-30T12:34:00 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of URBANO DR and VICTORIA ST URBANO DR 7 Ingleside Terraces TARAVAL 37.72314453125 -122.464637756348 POINT (-122.46463776 37.72314453) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
65494 65494 11477609 2019-09-28T12:18:00 2019-09-30T09:30:00 2019-09-30T09:30:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 133 LOS PALMOS DR, SAN FRANCISCO, CA, 94127 LOS PALMOS DR 7 Miraloma Park INGLESIDE 37.735614776611 -122.448280334473 POINT (-122.44828033 37.73561478) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
68207 68207 11557479 2019-10-16T09:53:00   2019-10-16T11:00:36 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1491 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94110 SOUTH VAN NESS AVE 9 Mission MISSION 37.749370574951 -122.415626525879 POINT (-122.41562653 37.74937057) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
68478 68478 11558915 2019-10-16T13:16:00   2019-10-16T14:30:33 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 901 BAY SHORE BLVD, SAN FRANCISCO, CA, 94124 BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.732898712158 -122.404556274414 POINT (-122.40455627 37.73289871) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
70218 70218 11547960 2019-10-14T10:24:00   2019-10-14T10:55:29 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 426 BOSWORTH ST, SAN FRANCISCO, CA, 94112 BOSWORTH ST 8 St. Mary's Park INGLESIDE 37.73323059082 -122.431297302246 POINT (-122.4312973 37.73323059) Phone   93 9 5 28 5 2 4 28,861 7 25 25   93   5             1         93
70836 70836 10935496 2019-05-31T14:24:00   2019-10-04T15:13:25 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 123 BOUTWELL ST, SAN FRANCISCO, CA, 94124 BOUTWELL ST 10 Silver Terrace BAYVIEW 37.735378265380994 -122.405471801758 POINT (-122.4054718 37.73537827) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
71064 71064 11405157 2019-09-12T09:25:00   2019-10-26T10:20:22 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of EGBERT AVE and HAWES ST EGBERT AVE 10 Bret Harte BAYVIEW 37.720561981201 -122.388916015625 POINT (-122.38891602 37.72056198) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
71066 71066 11405513 2019-09-12T10:17:00 2019-10-01T09:59:00 2019-10-01T09:59:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 4 TIOGA AVE, SAN FRANCISCO, CA, 94134 TIOGA AVE 10 Visitacion Valley INGLESIDE 37.715847015380994 -122.402633666992 POINT (-122.40263367 37.71584702) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
71217 71217 11559156 2019-10-16T13:55:00   2019-10-16T15:00:32 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1853 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 8 Mint Hill SOUTHERN 37.77087020874 -122.42433929443399 POINT (-122.42433929 37.77087021) Phone   27 1 5 20 5 8 2 28,853 2 19 19   27   5   12     9   2         27
71254 71254 11456489 2019-09-23T18:12:00 2019-10-01T10:04:00 2019-10-01T10:04:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of MISSION ST and 23RD ST MISSION ST 9 Mission MISSION 37.753837585449 -122.418594360352 POINT (-122.41859436 37.75383759) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
72335 72335 11557210 2019-10-16T09:20:00 2019-10-23T13:03:00 2019-10-23T13:03:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of DOLORES ST and VALLEY ST DOLORES ST 8 Noe Valley INGLESIDE 37.744636535645 -122.424461364746 POINT (-122.42446136 37.74463654) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
72852 72852 11374862 2019-09-05T16:35:00   2019-10-22T14:05:51 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NORIEGA ST and 12TH AVE NORIEGA ST 7 Golden Gate Heights TARAVAL 37.755218505859 -122.46891784668001 POINT (-122.46891785 37.75521851) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
73546 73546 11490114 2019-10-01T11:44:00 2019-10-03T08:32:00 2019-10-03T08:32:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 8TH ST and HOWARD ST 8TH ST 6 South of Market SOUTHERN 37.776222229004 -122.411605834961 POINT (-122.41160583 37.77622223) Twitter   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
75797 75797 11598727 2019-10-25T01:12:00   2019-10-25T07:01:46 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 49 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.742828369141 -122.43597412109399 POINT (-122.43597412 37.74282837) Phone   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
75957 75957 11523299 2019-10-08T13:39:00   2019-10-08T15:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of ARELIOUS WALKER DR and HUDSON AVE ARELIOUS WALKER DR 10 India Basin BAYVIEW 37.731559753418004 -122.373329162598 POINT (-122.37332916 37.73155975) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
76173 76173 11450803 2019-09-22T15:28:00   2019-10-17T16:24:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of ROCKDALE DR and ISOLA WAY ROCKDALE DR 7 Miraloma Park INGLESIDE 37.741161346436 -122.450996398926 POINT (-122.4509964 37.74116135) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
78508 78508 11491072 2019-10-01T14:18:00   2019-10-01T15:05:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MISSION ST and 30TH ST MISSION ST 9 Bernal Heights INGLESIDE 37.742374420166 -122.42196655273399 POINT (-122.42196655 37.74237442) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
80375 80375 10384852 2019-01-21T11:49:00   2019-01-21T12:25:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of LELAND AVE and CORA ST LELAND AVE 10 Visitacion Valley INGLESIDE 37.712814331055 -122.40833282470699 POINT (-122.40833282 37.71281433) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
80639 80639 11589436 2019-10-23T09:10:00   2019-10-23T10:15:43 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 990 GREEN ST, SAN FRANCISCO, CA, 94133 GREEN ST 3 Russian Hill CENTRAL 37.798824310303004 -122.415351867676 POINT (-122.41535187 37.79882431) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
81558 81558 11278269 2019-08-15T20:44:00   2019-10-06T12:35:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of OGDEN AVE and BANKS ST OGDEN AVE 9 Bernal Heights INGLESIDE 37.735858917236 -122.412963867188 POINT (-122.41296387 37.73585892) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
81662 81662 11386173 2019-09-08T14:31:00   2019-10-17T09:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 301 CRESTMONT DR, SAN FRANCISCO, CA, 94131 CRESTMONT DR 7 Forest Knolls PARK 37.757305145264 -122.460060119629 POINT (-122.46006012 37.75730515) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
82092 82092 11554350 2019-10-15T14:31:00   2019-10-18T11:30:36 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of OCEAN AVE and 19TH AVE OCEAN AVE 7 Merced Manor TARAVAL 37.732456207275 -122.474952697754 POINT (-122.4749527 37.73245621) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
82542 82542 11477711 2019-09-28T12:50:00 2019-10-02T10:23:13 2019-10-02T10:23:13 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of PALMETTO AVE and ALEMANY BLVD PALMETTO AVE 11 Outer Mission TARAVAL 37.71032333374 -122.460479736328 POINT (-122.46047974 37.71032333) Phone   66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
83478 83478 11490652 2019-10-01T13:11:00 2019-10-03T08:42:00 2019-10-03T08:42:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 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
87595 87595 9959066 2018-12-20T11:44:00   2019-04-26T17:30:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 3750 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754199981689 -122.44219970703101 POINT (-122.44219971 37.75419998) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
89894 89894 11504585 2019-10-04T11:26:00   2019-10-04T12:10:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of QUINTARA ST and 36TH AVE QUINTARA ST 4 Outer Sunset TARAVAL 37.747840881348 -122.494300842285 POINT (-122.49430084 37.74784088) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
91007 91007 11511123 2019-10-05T23:39:00   2019-10-06T00:10:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BRODERICK ST and FELL ST BRODERICK ST 5 Panhandle PARK 37.773845672607 -122.439277648926 POINT (-122.43927765 37.77384567) Phone   24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
91275 91275 9783759 2018-11-08T12:50:00   2019-01-23T14:40:02 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 263 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.70938873291 -122.469223022461 POINT (-122.46922302 37.70938873) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
91278 91278 9783716 2018-11-08T12:45:00   2019-01-23T15:05:33 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 229 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710018157959 -122.46923065185499 POINT (-122.46923065 37.71001816) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
92309 92309 11533440 2019-10-10T14:49:00   2019-10-21T15:30:16 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DICHIERA CT and ELLINGTON AVE DICHIERA CT 11 Outer Mission INGLESIDE 37.712615966796996 -122.44621276855499 POINT (-122.44621277 37.71261597) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
93310 93310 9739273 2018-10-30T07:12:00   2018-11-08T11:05:10 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of JONES ST and PINE ST JONES ST 3 Nob Hill CENTRAL 37.790462493896 -122.413917541504 POINT (-122.41391754 37.79046249) Phone   50 6 3 21 10 5 1 28,858 1 21 21   50   3             1         50
93354 93354 9737945 2018-10-29T16:46:00 2019-02-05T14:09:00 2019-02-05T14:09:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LYELL ST and BOSWORTH ST LYELL ST 8 Mission Terrace INGLESIDE 37.731651306152 -122.431686401367 POINT (-122.4316864 37.73165131) Phone   94 9 5 28 5 9 4 28,861 7 25 25   94   5             1         94
94122 94122 9728660 2018-10-27T11:31:00 2018-11-10T05:29:00 2018-11-10T05:29:00 Closed 2 Work Completed - sent to tree crew DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1538 9TH AVE, SAN FRANCISCO, CA, 94122 9TH AVE 7 Inner Sunset TARAVAL 37.759559631348 -122.465835571289 POINT (-122.46583557 37.75955963) Phone   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
96917 96917 9690310 2018-10-18T14:25:00   2019-03-03T14:42:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3750 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754199981689 -122.44219970703101 POINT (-122.44219971 37.75419998) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
96958 96958 9689714 2018-10-18T12:53:00 2019-04-27T03:31:00 2019-04-27T03:31:00 Closed 2 AFTER INSPECTING THE AREA, BUF/YTC WILL ADD WEBSTER MEDIANS BETWEEN TURK ST AND ELLIS ST TO THE WATER SPECIALS LIST. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of WEBSTER ST and TURK ST WEBSTER ST 5 Western Addition NORTHERN 37.780715942383 -122.43042755126999 POINT (-122.43042755 37.78071594) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
97073 97073 11608339 2019-10-27T11:54:00 2019-10-28T09:30:28 2019-10-28T10:50:04 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of 19TH AVE and IRVING ST 19TH AVE 4 Outer Sunset TARAVAL 37.763561248779 -122.477172851563 POINT (-122.47717285 37.76356125) Phone   39 10 7 14 3 1 5 56 8 12 12 9 39   7 11     11     1         39

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