calls

80,878 rows where Category = 1 sorted by :@computed_region_bh8s_q3mv 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
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
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
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
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
7798 7798 11624131 2019-10-30T18:01:00   2019-10-30T18:15:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 459 VICTORIA ST, SAN FRANCISCO, CA, 94132 VICTORIA ST 11 Ingleside TARAVAL 37.7189803 -122.46557649999998 POINT (-122.4655765 37.7189803) Web   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
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
14955 14955 10831222 2019-05-07T16:54:00 2019-10-01T14:55:00 2019-10-01T14:55:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708359 -122.485928 POINT (-122.485928 37.708359) Mobile/Open311 http://mobile311.sfgov.org/reports/10831222/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
16171 16171 5669666 2016-03-16T07:20:57 2016-03-17T08:26:30 2016-03-17T08:26:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 311 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.731745855640995 -122.49785305228501 POINT (-122.49785305 37.73174586) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
19720 19720 5653757 2016-03-10T18:09:19 2016-03-11T13:38:10 2016-03-11T13:38:10 Closed 2 10-98 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SLOAT BLVD and RIVERTON DR SLOAT BLVD 7 Merced Manor TARAVAL 37.734116630084 -122.487287798006 POINT (-122.4872878 37.73411663) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
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
23312 23312 11459733 2019-09-24T12:38:00   2019-10-31T22:30:28 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 160 STRATFORD DR, SAN FRANCISCO, CA, 94132 STRATFORD DR 7 Stonestown TARAVAL 37.722045898438 -122.473686218262 POINT (-122.47368622 37.7220459) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
26076 26076 11596980 2019-10-24T15:07:00 2019-10-24T15:15:59 2019-10-24T15:15:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 545 ORIZABA AVE, SAN FRANCISCO, CA, 94132 ORIZABA AVE 11 Ingleside TARAVAL 37.718803405762 -122.462768554688 POINT (-122.46276855 37.71880341) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
26413 26413 11598092 2019-10-24T18:59:00 2019-10-30T13:05:00 2019-10-30T13:05:00 Closed 2 For tree crew DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 20TH AVE and BUCKINGHAM WAY 20TH AVE 7 Stonestown TARAVAL 37.730117797852 -122.475936889648 POINT (-122.47593689 37.7301178) Phone   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
30220 30220 11539206 2019-10-11T17:53:49   2019-10-11T18:05:24 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of SARGENT ST and ORIZABA AVE SARGENT ST 11 Oceanview TARAVAL 37.716145000000004 -122.46264099999999 POINT (-122.462641 37.716145) Mobile/Open311 http://mobile311.sfgov.org/reports/11539206/photos 65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
31456 31456 11607527 2019-10-27T08:43:00   2019-10-27T13:45:01 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 806 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.724091925679005 -122.472607249088 POINT (-122.47260725 37.72409193) Mobile/Open311   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
31581 31581 11607862 2019-10-27T10:04:00 2019-10-27T22:15:28 2019-10-27T22:15:28 Closed 2 Request is a duplicate and has been previously reported as 11607527 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 784 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.724564768388 -122.472497067614 POINT (-122.47249707 37.72456477) Mobile/Open311 http://mobile311.sfgov.org/reports/11607862/photos 41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
31655 31655 11608114 2019-10-27T10:58:00 2019-10-27T22:15:17 2019-10-27T22:15:17 Closed 2 Request is a duplicate and has been previously reported as 11608085 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 806 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.724078000000006 -122.47263600000001 POINT (-122.472636 37.724078) Mobile/Open311 http://mobile311.sfgov.org/reports/11608114/photos 41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
31978 31978 11609144 2019-10-27T14:57:00 2019-10-28T09:22:41 2019-10-28T10:50:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 462 HEAD ST, SAN FRANCISCO, CA, 94132 HEAD ST 11 Merced Heights TARAVAL 37.715476989746 -122.46427154541 POINT (-122.46427155 37.71547699) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
32315 32315 11609931 2019-10-27T19:16:00 2019-10-28T06:15:17 2019-10-28T06:15:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and BUCKINGHAM WAY 19TH AVE 7 Stonestown TARAVAL 37.725692749023 -122.47510528564501 POINT (-122.47510529 37.72569275) Phone   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
33073 33073 11611800 2019-10-28T10:14:00 2019-10-28T22:15:13 2019-10-28T22:15:13 Closed 2 Request is a duplicate and has been previously reported as 11611800 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 531 ARCH ST, SAN FRANCISCO, CA, 94132 ARCH ST 11 Ingleside TARAVAL 37.720275878906 -122.46728515625 POINT (-122.46728516 37.72027588) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
33104 33104 11611873 2019-10-28T10:24:00   2019-10-28T11:15:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 458 VICTORIA ST, SAN FRANCISCO, CA, 94132 VICTORIA ST 11 Ingleside TARAVAL 37.718983 -122.465078 POINT (-122.465078 37.718983) Mobile/Open311   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
33348 33348 11612554 2019-10-28T12:03:00 2019-10-28T13:14:45 2019-10-28T13:45:03 Closed 2 Completed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3063 19TH AVE, SAN FRANCISCO, CA, 94132 19TH AVE 7 Merced Manor TARAVAL 37.731567382813 -122.475082397461 POINT (-122.4750824 37.73156738) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
33392 33392 11612677 2019-10-28T12:24:00 2019-10-29T05:53:42 2019-10-29T06:10:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 278 RAMSELL ST, SAN FRANCISCO, CA, 94132 RAMSELL ST 11 Merced Heights TARAVAL 37.71573638916 -122.46607208251999 POINT (-122.46607208 37.71573639) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
33931 33931 11614328 2019-10-28T16:45:00 2019-10-29T06:00:50 2019-10-29T06:10:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 227 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710052490234 -122.46923065185499 POINT (-122.46923065 37.71005249) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
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
39738 39738 11627727 2019-10-31T15:03:00   2019-10-31T15:10:09 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of 19TH AVE and EUCALYPTUS DR 19TH AVE 7 Stonestown TARAVAL 37.731067657471 -122.474853515625 POINT (-122.47485352 37.73106766) Phone   62 10 8 41 4 9 5 64 8 40 40   62   8             1         62
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
43677 43677 11458850 2019-09-24T10:22:00   2019-09-24T10:45:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 435 BRIGHT ST, SAN FRANCISCO, CA, 94132 BRIGHT ST 11 Ingleside TARAVAL 37.718589782715 -122.463668823242 POINT (-122.46366882 37.71858978) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
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
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
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
46970 46970 11407176 2019-09-12T14:35:00 2019-09-27T11:55:47 2019-09-27T11:55:47 Closed 2 Outreach and Enforcement Incident created. referred to BUF DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ALEMANY BLVD and SAINT CHARLES AVE ALEMANY BLVD 7 Merced Heights TARAVAL 37.710594177246 -122.469291687012 POINT (-122.46929169 37.71059418) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
47620 47620 11431748 2019-09-18T09:42:00 2019-09-24T14:51:00 2019-09-24T14:51:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3063 19TH AVE, SAN FRANCISCO, CA, 94132 19TH AVE 7 Merced Manor TARAVAL 37.731567382813 -122.475082397461 POINT (-122.4750824 37.73156738) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
55239 55239 11472659 2019-09-27T09:17:00 2019-10-27T00:00:00 2019-10-27T00:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 936 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94132 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.72078704834 -122.472778320313 POINT (-122.47277832 37.72078705) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
57189 57189 11480161 2019-09-29T08:30:00 2019-09-29T09:20:00 2019-09-29T09:20:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3911 ALEMANY BLVD, SAN FRANCISCO, CA, 94132 ALEMANY BLVD 7 Merced Heights TARAVAL 37.710506439209 -122.46752166748001 POINT (-122.46752167 37.71050644) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
60094 60094 11419243 2019-09-15T14:08:00 2019-10-12T12:35:00 2019-10-12T12:35:00 Closed 2 Per caller, resolved. Lawn has been mowed. PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of 22ND AVE and SLOAT BLVD 22ND AVE 7 Merced Manor TARAVAL 37.734512329102 -122.477981567383 POINT (-122.47798157 37.73451233) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
60927 60927 11329362 2019-08-27T09:21:00 2019-10-15T06:09:33 2019-10-15T06:09:33 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 343 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.732569405681 -122.497712046483 POINT (-122.49771205 37.73256941) Mobile/Open311 http://mobile311.sfgov.org/reports/11329362/photos 43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
61829 61829 11550843 2019-10-14T21:43:00 2019-10-15T22:15:37 2019-10-15T22:15:37 Closed 2 Request is a duplicate and has been previously reported as 11550843 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and WINSTON DR 19TH AVE 7 Stonestown TARAVAL 37.726989746094 -122.474899291992 POINT (-122.47489929 37.72698975) Phone   41 10 8 16 4 9 5 64 8 14 14   41   8             2         41
63829 63829 11525557 2019-10-09T06:12:54   2019-10-09T06:20:18 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 170 GELLERT DR, SAN FRANCISCO, CA, 94132 GELLERT DR 7 Lakeshore TARAVAL 37.730757000000004 -122.4928267 POINT (-122.4928267 37.730757) Web   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
64782 64782 11256232 2019-08-11T11:04:00 2019-10-16T13:02:20 2019-10-16T13:02:20 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 338 SHIELDS ST, SAN FRANCISCO, CA, 94132 SHIELDS ST 11 Ingleside TARAVAL 37.71808660000001 -122.4660298 POINT (-122.4660298 37.7180866) Web http://mobile311.sfgov.org/reports/11256232/photos 64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
66155 66155 11545526 2019-10-13T15:21:00   2019-10-16T10:34:39 Open 1 sent RPD Natural Areas Queue 12 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 200 LAKE MERCED HILL ST NORTH, SAN FRANCISCO, CA, 94132 LAKE MERCED HILL ST NORTH 7 Lakeshore TARAVAL 37.712525 -122.484091666667 POINT (-122.48409167 37.712525) Mobile/Open311 http://mobile311.sfgov.org/reports/11545526/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
67622 67622 11553586 2019-10-15T12:35:00   2019-10-29T09:16:42 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 GABILAN WAY, SAN FRANCISCO, CA, 94132 GABILAN WAY 4 Parkside TARAVAL 37.735122680664 -122.481605529785 POINT (-122.48160553 37.73512268) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
67790 67790 11555370 2019-10-15T17:19:00 2019-10-16T09:51:49 2019-10-16T09:51:49 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 460 RAMSELL ST, SAN FRANCISCO, CA, 94132 RAMSELL ST 11 Ingleside TARAVAL 37.7189804 -122.4660298 POINT (-122.4660298 37.7189804) Web http://mobile311.sfgov.org/reports/11555370/photos 64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
67795 67795 11555383 2019-10-15T17:23:00 2019-10-16T09:52:42 2019-10-16T09:52:42 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 454 RAMSELL ST, SAN FRANCISCO, CA, 94132 RAMSELL ST 11 Ingleside TARAVAL 37.7189195 -122.4659856 POINT (-122.4659856 37.7189195) Web http://mobile311.sfgov.org/reports/11555383/photos 64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
69242 69242 11585126 2019-10-22T11:18:00 2019-10-28T12:42:00 2019-10-28T12:42:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 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
70855 70855 11058418 2019-06-28T11:40:00 2019-10-01T09:37:00 2019-10-01T09:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1100 LAKE MERCED BLVD, SAN FRANCISCO, CA, 94132 LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.714386 -122.485173 POINT (-122.485173 37.714386) Mobile/Open311   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
71921 71921 11609013 2019-10-27T14:31:13 2019-10-28T07:30:56 2019-10-28T08:20:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 285 WINSTON DR, SAN FRANCISCO, CA, 94132 WINSTON DR 7 Stonestown TARAVAL 37.727844238281 -122.47680501001601 POINT (-122.47680501 37.72784424) Mobile/Open311   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
72091 72091 11607531 2019-10-27T08:44:08 2019-10-28T06:39:17 2019-10-28T06:55:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 800 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.724142652396004 -122.472598477395 POINT (-122.47259848 37.72414265) Mobile/Open311 http://mobile311.sfgov.org/reports/11607531/photos 41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
72264 72264 11537818 2019-10-11T13:51:00   2019-10-19T08:45:16 Open 1 sent RPD Park Service Area 4 Queue 22 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 530 CRESTLAKE DR, SAN FRANCISCO, CA, 94116 CRESTLAKE DR 4 Parkside TARAVAL 37.7362993 -122.4893919 POINT (-122.4893919 37.7362993) Web http://mobile311.sfgov.org/reports/11537818/photos 40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
79357 79357 11561883 2019-10-17T08:03:00 2019-10-17T12:45:18 2019-10-17T12:45:18 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 Near_communication_line 531 ARCH ST, SAN FRANCISCO, CA, 94132 ARCH ST 11 Ingleside TARAVAL 37.720275878906 -122.46728515625 POINT (-122.46728516 37.72027588) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
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
87577 87577 10846109 2019-05-10T16:21:36 2019-10-04T07:45:00 2019-10-04T07:45:00 Closed 2 Job Complete / Duplicate Landscape - DReed60098 DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 200 LAKE MERCED HILL ST NORTH, SAN FRANCISCO, CA, 94132 LAKE MERCED HILL ST NORTH 7 Lakeshore TARAVAL 37.712711336679995 -122.485312310028 POINT (-122.48531231 37.71271134) Web   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
87752 87752 11408112 2019-09-12T17:27:00 2019-10-08T00:00:00 2019-10-08T00:00:00 Closed 2 4 ft path of travel is clear.kjNo conditions found - No Action Required DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of BEVERLY ST and HOLLOWAY AVE BEVERLY ST 7 Ingleside Terraces TARAVAL 37.721630096436 -122.47167205810499 POINT (-122.47167206 37.7216301) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
91141 91141 9787164 2018-11-09T09:34:00 2019-01-11T07:09:50 2019-01-11T07:09:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 160 GELLERT DR, SAN FRANCISCO, CA, 94132 GELLERT DR 7 Lakeshore TARAVAL 37.730892181396 -122.49292755126999 POINT (-122.49292755 37.73089218) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
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
91306 91306 9782688 2018-11-08T10:03:00   2019-04-03T22:55:22 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 350 CHESTER AVE, SAN FRANCISCO, CA, 94132 CHESTER AVE 7 Merced Heights TARAVAL 37.709541320801 -122.470512390137 POINT (-122.47051239 37.70954132) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
98364 98364 9643309 2018-10-08T13:36:00 2019-02-26T15:52:00 2019-02-26T15:52:00 Closed 2 notified don lampe sfwd /cdd PUC - Water - G 20 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of LAKE MERCED BLVD and UNNAMED 129 LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.70913 -122.48498000000001 POINT (-122.48498 37.70913) Web http://mobile311.sfgov.org/reports/9643309/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
100451 100451 11610683 2019-10-28T07:22:00 2019-10-28T09:26:29 2019-10-28T10:45:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 459 VICTORIA ST, SAN FRANCISCO, CA, 94132 VICTORIA ST 11 Ingleside TARAVAL 37.7189803 -122.46557649999998 POINT (-122.4655765 37.7189803) Web   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
101943 101943 7165401 2017-05-19T06:33:36 2019-02-04T00:00:00 2019-02-04T00:00:00 Closed 2 No Action Described DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 40 WOODACRE DR, SAN FRANCISCO, CA, 94132 WOODACRE DR 7 Merced Manor TARAVAL 37.732861421509 -122.472730883232 POINT (-122.47273088 37.73286142) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
104394 104394 9007077 2018-05-16T08:49:00   2018-05-16T09:05:04 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3250 19TH AVE, SAN FRANCISCO, CA, 94132 19TH AVE 7 Stonestown TARAVAL 37.729465484619006 -122.47453308105499 POINT (-122.47453308 37.72946548) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
104855 104855 8865613 2018-04-12T20:24:00 2018-04-14T08:56:00 2018-04-14T08:56:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of ALEMANY BLVD and PALMETTO AVE ALEMANY BLVD 7 Merced Heights TARAVAL 37.710594177246 -122.469291687012 POINT (-122.46929169 37.71059418) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
106595 106595 11296344 2019-08-20T08:40:00   2019-09-13T01:15:23 Open 1 accepted DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 19TH AVE and WINSTON DR 19TH AVE 7 Stonestown TARAVAL 37.726989746094 -122.474899291992 POINT (-122.47489929 37.72698975) Phone   41 10 8 16 4 9 5 64 8 14 14   41   8             2         41
111747 111747 7279144 2017-06-20T08:57:44 2017-06-30T04:25:00 2017-06-30T04:25:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of JUNIPERO SERRA BLVD and STONECREST DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.725548134137995 -122.47245376501101 POINT (-122.47245377 37.72554813) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
112875 112875 7155763 2017-05-16T14:12:59 2017-06-04T17:10:10 2017-06-04T17:10:10 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 27 PAYSON ST, SAN FRANCISCO, CA, 94132 PAYSON ST 7 Merced Heights TARAVAL 37.712083611006996 -122.469759026414 POINT (-122.46975903 37.71208361) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
115563 115563 6881335 2017-02-26T17:28:39 2017-03-06T11:15:55 2017-03-06T11:15:55 Closed 2 call mta they installed the sign after the trees they should move it DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 123 EUCALYPTUS DR, SAN FRANCISCO, CA, 94132 EUCALYPTUS DR 7 Stonestown TARAVAL 37.730880206896 -122.472605660181 POINT (-122.47260566 37.73088021) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
118085 118085 6667600 2016-12-28T08:18:04 2017-02-03T11:20:54 2017-02-03T11:20:54 Closed 2 Notes:clearance requested from dpw arborists. BUF Action:Inspect. date completed - 1/30/2017. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of VERNON ST and RANDOLPH ST VERNON ST 11 Merced Heights TARAVAL 37.714263929756 -122.46799795234301 POINT (-122.46799795 37.71426393) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
118799 118799 4101236 2014-10-12T17:19:59 2017-07-06T14:40:31 2017-07-06T14:40:31 Closed 2 Should be routed to DPW-BSES This request came in to landscaping and the tree work should go to the Arborists. Can you have an inspector inspect the trees? Thanks Jada DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 620 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.727603912354 -122.47217559814501 POINT (-122.4721756 37.72760391) Integrated Agency   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
121720 121720 6427205 2016-10-16T22:40:57 2016-10-18T01:30:10 2016-10-18T01:30:10 Closed 2 per Lp made safe with caution tape and orange cones, tre is too large to move out the away from the street tree might of come from SF State University. Arborist have been contacted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 175 BUCKINGHAM WAY, SAN FRANCISCO, CA, 94132 BUCKINGHAM WAY 7 Stonestown TARAVAL 37.725971221924 -122.47834777831999 POINT (-122.47834778 37.72597122) Phone   41 10 8 16 4 1 5 64 8 14 14   41   8             2         41
124886 124886 6117976 2016-07-25T10:48:20 2016-07-25T14:22:26 2016-07-25T14:22:26 Closed 2 Thank you for the information regarding this property. The property in question is private and not maintained by Public Works. Please forward to correct property owner to abate the ivy. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of BERKSHIRE WAY and LAKE MERCED BLVD BERKSHIRE WAY 7 Lakeshore TARAVAL 37.73127746582 -122.498001098633 POINT (-122.4980011 37.73127747) Web   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
125066 125066 6097072 2016-07-19T10:59:12 2016-08-22T23:27:33 2016-08-22T23:27:33 Closed 2 Request Letter Sent. DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of OCEAN AVE and LAGUNITAS DR OCEAN AVE 7 Merced Manor TARAVAL 37.732119706665 -122.474208821691 POINT (-122.47420882 37.73211971) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
126866 126866 5920218 2016-05-29T12:49:28 2016-05-31T04:28:00 2016-05-31T04:28:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SLOAT BLVD and VALE AVE SLOAT BLVD 4 Parkside TARAVAL 37.73441696167 -122.484077453613 POINT (-122.48407745 37.73441696) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
127193 127193 5887289 2016-05-19T19:55:46 2016-05-20T11:47:00 2016-05-20T11:47:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JUNIPERO SERRA BLVD and OCEAN AVE JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.731203549959 -122.47216115561501 POINT (-122.47216116 37.73120355) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
127295 127295 5875436 2016-05-17T08:47:01 2016-05-25T12:29:35 2016-05-25T12:29:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SLOAT BLVD and 21ST AVE SLOAT BLVD 7 Parkside TARAVAL 37.734619140625 -122.477081298828 POINT (-122.4770813 37.73461914) Web   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
127641 127641 5838588 2016-05-06T11:40:03 2016-08-12T14:40:19 2016-08-12T14:40:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of JUNIPERO SERRA BLVD and WOODACRE DR JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.733829498291 -122.47201538085899 POINT (-122.47201538 37.7338295) Integrated Agency   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
129044 129044 5633233 2016-03-05T22:10:44 2016-03-08T08:49:00 2016-03-08T08:49:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JUNIPERO SERRA BLVD and LYNDHURST DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.72480995753 -122.47257250991501 POINT (-122.47257251 37.72480996) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
129576 129576 5581776 2016-02-18T17:16:17 2016-02-24T02:05:29 2016-02-24T02:05:29 Closed 2 Case Resolved: notify Park Merced management DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 10 JUAN BAUTISTA CIR, SAN FRANCISCO, CA, 94132 JUAN BAUTISTA CIR 7 Parkmerced TARAVAL 37.718631744385 -122.47811126709 POINT (-122.47811127 37.71863174) Phone   42 10 8 16 4 1 5 64 8 14 14   42   8             2         42
131525 131525 5403600 2015-12-25T06:29:39 2016-04-11T18:57:46 2016-04-11T18:57:46 Closed 2 sent request DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of EUCALYPTUS DR and 19TH AVE EUCALYPTUS DR 7 Stonestown TARAVAL 37.731064966374 -122.47485870315701 POINT (-122.4748587 37.73106497) Phone   41 10 8 16 4 9 5 64 8 14 14   41   8             2         41
131966 131966 4722973 2015-05-06T09:07:39 2016-04-11T17:52:25 2016-04-11T17:52:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of SUNSET BLVD ON RAMP and SLOAT BLVD SUNSET BLVD ON RAMP 7 Lakeshore TARAVAL 37.733749389648 -122.49526977539101 POINT (-122.49526978 37.73374939) Web   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
133234 133234 5395007 2015-12-22T07:20:03 2015-12-29T08:50:39 2015-12-29T08:50:39 Closed 2 cancelled: DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LAKE MERCED BLVD and BROTHERHOOD WAY LAKE MERCED BLVD 7 Parkmerced TARAVAL 37.714694976806996 -122.485229492188 POINT (-122.48522949 37.71469498) Integrated Agency   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
133486 133486 5364202 2015-12-10T19:12:43 2015-12-11T03:03:52 2015-12-11T03:03:52 Closed 2 cancelled: Tree needs restake DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of JUNIPERO SERRA BLVD and WINSTON DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.726818465302 -122.47238026639299 POINT (-122.47238027 37.72681847) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
133599 133599 5350641 2015-12-06T17:32:58 2015-12-16T08:45:00 2015-12-16T08:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of ARCH ST and BROTHERHOOD WAY ARCH ST 11 Merced Heights TARAVAL 37.712419657575005 -122.46707430201 POINT (-122.4670743 37.71241966) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
136835 136835 5020332 2015-08-21T10:58:09 2015-10-14T02:37:00 2015-10-14T02:37:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1006 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715090957882 -122.471436282043 POINT (-122.47143628 37.71509096) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
139913 139913 4756569 2015-05-19T00:52:04 2015-06-02T02:03:00 2015-06-02T02:03:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1657 HOLLOWAY AVE, SAN FRANCISCO, CA, 94132 HOLLOWAY AVE 7 Parkmerced TARAVAL 37.720471706276996 -122.47802505257799 POINT (-122.47802505 37.72047171) Phone   42 10 8 16 4 1 5 64 8 14 14   42   8             2         42
149889 149889 9488856 2018-09-03T11:23:00 2018-09-16T10:22:47 2018-09-16T10:22:47 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 19TH AVE and BANBURY DR 19TH AVE 7 Parkmerced TARAVAL 37.719573974609 -122.474678039551 POINT (-122.47467804 37.71957397) Phone   42 10 8 41 4 9 5 64 8 40 40   42   8             1         42
151470 151470 9107171 2018-06-07T14:06:00 2018-06-29T13:43:00 2018-06-29T13:43:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SLOAT BLVD and SUNSET BLVD OFF RAMP SLOAT BLVD 7 Lakeshore TARAVAL 37.733787536621 -122.49437713623001 POINT (-122.49437714 37.73378754) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
153851 153851 9389740 2018-08-11T13:51:00 2018-08-24T07:12:00 2018-08-24T07:12:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 19TH AVE and DENSLOWE DR 19TH AVE 7 Stonestown TARAVAL 37.724906921387 -122.47484588623001 POINT (-122.47484589 37.72490692) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
156340 156340 7432679 2017-07-28T11:36:11 2017-08-05T12:25:27 2017-08-05T12:25:27 Closed 2 trees to be pruned on a coordinated block schedule DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 20TH AVE and OCEAN AVE 20TH AVE 7 Merced Manor TARAVAL 37.732690597233 -122.476039832381 POINT (-122.47603983 37.7326906) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
158357 158357 9076812 2018-05-31T15:30:00 2018-05-31T20:48:00 2018-05-31T20:48:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and SLOAT BLVD 19TH AVE 7 Parkside TARAVAL 37.73462677002 -122.47510528564501 POINT (-122.47510529 37.73462677) Phone   40 10 8 35 4 1 5 64 8 35 35   40   8             1         40
159537 159537 9210985 2018-07-01T13:31:00 2018-08-10T11:52:00 2018-08-10T11:52:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LAKESHORE DR and OCEAN AVE LAKESHORE DR 7 Lakeshore TARAVAL 37.731958376805004 -122.494303074646 POINT (-122.49430307 37.73195838) Web   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
160391 160391 9325230 2018-07-27T14:35:00 2018-09-10T11:33:59 2018-09-10T11:33:59 Closed 2 not a real path of travel the path of travel is the sidewalk this is a landscaping median with a use trail DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 210 GELLERT DR, SAN FRANCISCO, CA, 94132 GELLERT DR 7 Lakeshore TARAVAL 37.730152130127 -122.49284362793001 POINT (-122.49284363 37.73015213) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
165912 165912 9247699 2018-07-10T11:12:00 2018-07-18T13:51:57 2018-07-18T13:51:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 500 VICTORIA ST, SAN FRANCISCO, CA, 94132 VICTORIA ST 11 Ingleside TARAVAL 37.719755269055 -122.46527100113899 POINT (-122.465271 37.71975527) Mobile/Open311 http://mobile311.sfgov.org/reports/9247699/photos 64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
165921 165921 9167569 2018-06-21T14:06:00 2018-07-13T10:41:32 2018-07-13T10:41:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 615 GARFIELD ST, SAN FRANCISCO, CA, 94132 GARFIELD ST 11 Ingleside TARAVAL 37.719551086426 -122.468360900879 POINT (-122.4683609 37.71955109) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
169096 169096 9099389 2018-06-06T05:54:00 2018-11-15T08:14:25 2018-11-15T08:14:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 19TH AVE and EUCALYPTUS DR 19TH AVE 7 Stonestown TARAVAL 37.731067657471 -122.474853515625 POINT (-122.47485352 37.73106766) Phone   62 10 8 41 4 9 5 64 8 40 40   62   8             1         62
171834 171834 9390101 2018-08-11T15:24:00 2018-10-03T13:46:37 2018-10-03T13:46:37 Closed 2 appears to be duplicate of 744 Junipero Serra DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of JUNIPERO SERRA BLVD and WINSTON DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.726821899414 -122.472381591797 POINT (-122.47238159 37.7268219) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
171839 171839 9146798 2018-06-16T23:49:00 2018-10-15T06:18:20 2018-10-15T06:18:20 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 patie DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 67 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 11 Merced Heights TARAVAL 37.7130232 -122.4691697 POINT (-122.4691697 37.7130232) Web   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
171862 171862 9086704 2018-06-03T10:18:00 2018-06-05T08:25:00 2018-06-05T08:25:00 Closed 2 Per PSA Manager: the damaged tree at this site has been removed by park staff. RPD Park Service Area 4 Queue 22 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 19TH AVE and SLOAT BLVD 19TH AVE 7 Parkside TARAVAL 37.73462677002 -122.47510528564501 POINT (-122.47510529 37.73462677) Phone   40 10 8 35 4 1 5 64 8 35 35   40   8             1         40
173179 173179 9362389 2018-08-05T15:01:09 2018-08-07T08:24:44 2018-08-07T08:24:44 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 patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LAKESHORE DR and OCEAN AVE LAKESHORE DR 7 Lakeshore TARAVAL 37.732026258747 -122.49415287094101 POINT (-122.49415287 37.73202626) Web   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43

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.356ms