calls

7,158 rows where Responsible_Agency = 2

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
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
47007 47007 11409708 2019-09-13T08:24:00   2019-09-25T16:10:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CASTENADA AVE and SAN MARCOS AVE CASTENADA AVE 7 Forest Hill TARAVAL 37.746400008767 -122.464055644158 POINT (-122.46405564 37.74640001) Mobile/Open311 http://mobile311.sfgov.org/reports/11409708/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
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
47143 47143 11416342 2019-09-14T16:12:00   2019-09-24T08:00:58 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1632 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772065904708 -122.446262096588 POINT (-122.4462621 37.7720659) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
47415 47415 11426085 2019-09-17T07:40:00   2019-09-24T09:25:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1114 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Ashbury Heights PARK 37.763793945313 -122.449394226074 POINT (-122.44939423 37.76379395) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
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
51217 51217 11461057 2019-09-24T16:26:00 2019-10-16T14:52:02 2019-10-16T14:52:02 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of PERALTA AVE and YORK ST PERALTA AVE 9 Peralta Heights INGLESIDE 37.747470299999996 -122.4073159 POINT (-122.4073159 37.7474703) Web http://mobile311.sfgov.org/reports/11461057/photos 60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
51276 51276 11461171 2019-09-24T16:52:00   2019-10-11T08:00:36 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 529 PIERCE ST, SAN FRANCISCO, CA, 94117 PIERCE ST 5 Alamo Square NORTHERN 37.774842674879 -122.434405060599 POINT (-122.43440506 37.77484267) Mobile/Open311 http://mobile311.sfgov.org/reports/11461171/photos 23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
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
52932 52932 11465668 2019-09-25T15:46:00 2019-09-26T13:10:44 2019-09-26T13:10:44 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 550 10TH ST, SAN FRANCISCO, CA, 94103 10TH ST 6 South of Market SOUTHERN 37.769683333333 -122.40899666666701 POINT (-122.40899667 37.76968333) Mobile/Open311 http://mobile311.sfgov.org/reports/11465668/photos 32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
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
54508 54508 11470389 2019-09-26T16:00:00 2019-09-27T11:36:15 2019-09-27T11:36:15 Closed 2 PGE is required to prune trees away from high voltage line to mitigate potential fire hazards. SFPW will prune tree away from muni lines. These trees do not meet the criteria for removal at this time. MD Notes:tree has bad structure may need to be pruned for vehicle clearance MD. BUF Action:Inspect. date completed - 9/27/2019. Notes:tree has good structure, upper canopy needs to be pruned away from muni lines MD. BUF Action:Inspect. date completed - 9/27/2019. Notes:tree has good DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 700 TENNESSEE ST, SAN FRANCISCO, CA, 94107 TENNESSEE ST 10 Dogpatch BAYVIEW 37.762855529785 -122.38986968994101 POINT (-122.38986969 37.76285553) Phone   55 2 9 26 8 10 3 28,856 3 29 29   55   9         14   1         55
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
55419 55419 11473326 2019-09-27T11:04:00 2019-09-27T11:56:13 2019-09-27T11:56:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 89 CASTENADA AVE, SAN FRANCISCO, CA, 94116 CASTENADA AVE 7 Forest Hill TARAVAL 37.749404882084 -122.461666656815 POINT (-122.46166666 37.74940488) Mobile/Open311 http://mobile311.sfgov.org/reports/11473326/photos 45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
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          
59717 59717 11500719 2019-10-03T14:24:00 2019-10-04T14:52:08 2019-10-04T14:52:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 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
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
60119 60119 10662348 2019-03-29T15:21:00 2019-04-04T09:14:00 2019-04-04T09:14:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1707 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 2 Pacific Heights NORTHERN 37.789374087041004 -122.425569947923 POINT (-122.42556995 37.78937409) Mobile/Open311 http://mobile311.sfgov.org/reports/10662348/photos 102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
60632 60632 11475647 2019-09-27T17:53:00   2019-10-04T10:25:16 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 LAPIDGE ST, SAN FRANCISCO, CA, 94110 LAPIDGE ST 8 Mission Dolores MISSION 37.761123657227 -122.422485351563 POINT (-122.42248535 37.76112366) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
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
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
60979 60979 11520858 2019-10-08T08:02:00 2019-10-16T10:07:11 2019-10-16T10:07:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 466 HEARST AVE, SAN FRANCISCO, CA, 94112 HEARST AVE 7 Sunnyside INGLESIDE 37.730670638521 -122.448080930124 POINT (-122.44808093 37.73067064) Mobile/Open311 http://mobile311.sfgov.org/reports/11520858/photos 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
61007 61007 11479105 2019-09-28T18:05:00 2019-10-10T06:34:59 2019-10-10T06:34:59 Closed 2 no tree found at location DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 190 OSHAUGHNESSY BLVD, SAN FRANCISCO, CA, 94127 OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.743163206335 -122.44964059285499 POINT (-122.44964059 37.74316321) Mobile/Open311   72 9 5 10 5 9 4 59 7 7 7   72   5             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
61999 61999 11467401 2019-09-26T07:50:00 2019-10-01T13:58:31 2019-10-01T13:58:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 2746 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 9 Portola BAYVIEW 37.727073 -122.4034 POINT (-122.4034 37.727073) Mobile/Open311 http://mobile311.sfgov.org/reports/11467401/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
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
63103 63103 11572019 2019-10-19T09:34:00   2019-10-30T06:00:34 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3527 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758541107178004 -122.41967010498001 POINT (-122.4196701 37.75854111) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
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
64074 64074 9520126 2018-09-10T11:21:00   2019-10-22T13:24:58 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 718 BRUSSELS ST, SAN FRANCISCO, CA, 94134 BRUSSELS ST 9 Portola BAYVIEW 37.723255157471 -122.404106140137 POINT (-122.40410614 37.72325516) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
64140 64140 11267867 2019-08-13T17:32:00 2019-09-30T13:36:08 2019-09-30T13:36:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3248 CESAR CHAVEZ ST, SAN FRANCISCO, CA, 94110 CESAR CHAVEZ ST 9 Mission MISSION 37.748308663437 -122.415241715456 POINT (-122.41524172 37.74830866) Mobile/Open311 http://mobile311.sfgov.org/reports/11267867/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
64200 64200 11595511 2019-10-24T11:21:00 2019-10-30T06:18:00 2019-10-30T06:18:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 264 MOULTRIE ST, SAN FRANCISCO, CA, 94110 MOULTRIE ST 9 Bernal Heights INGLESIDE 37.7408474 -122.4159219 POINT (-122.4159219 37.7408474) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
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
64273 64273 11403356 2019-09-11T18:49:00 2019-09-30T13:28:52 2019-09-30T13:28:52 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 380 BEACON ST, SAN FRANCISCO, CA, 94131 BEACON ST 8 Fairmount INGLESIDE 37.741282785742 -122.434022088536 POINT (-122.43402209 37.74128279) Mobile/Open311 http://mobile311.sfgov.org/reports/11403356/photos 59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
64422 64422 11448248 2019-09-21T19:42:00   2019-10-04T14:50:11 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 FILLMORE ST, SAN FRANCISCO, CA, 94117 FILLMORE ST 8 Duboce Triangle PARK 37.769954 -122.429992 POINT (-122.429992 37.769954) Mobile/Open311 http://mobile311.sfgov.org/reports/11448248/photos 28 7 5 9 5 7 6 29,492 9 10 10   28   5       20     1         28
64725 64725 10994519 2019-06-13T23:55:00 2019-10-16T13:42:56 2019-10-16T13:42:56 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 736 DELANO AVE, SAN FRANCISCO, CA, 94112 DELANO AVE 11 Cayuga INGLESIDE 37.7196195 -122.44565120000001 POINT (-122.4456512 37.7196195) Web http://mobile311.sfgov.org/reports/10994519/photos 80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
64776 64776 11248436 2019-08-09T11:42:00 2019-10-16T13:07:12 2019-10-16T13:07:12 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 90 VALMAR TER, SAN FRANCISCO, CA, 94112 VALMAR TER 11 Excelsior INGLESIDE 37.726118400000004 -122.4240472 POINT (-122.4240472 37.7261184) Web   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
64814 64814 11300212 2019-08-20T18:01:00 2019-10-18T08:08:00 2019-10-18T08:08:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 714 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Lower Haight NORTHERN 37.771732 -122.43398300000001 POINT (-122.433983 37.771732) Mobile/Open311 http://mobile311.sfgov.org/reports/11300212/photos 26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
64898 64898 11470919 2019-09-26T17:40:00 2019-09-30T09:34:02 2019-09-30T09:34:02 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 229 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.77590078334 -122.411010756952 POINT (-122.41101076 37.77590078) Mobile/Open311 http://mobile311.sfgov.org/reports/11470919/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
64923 64923 11471364 2019-09-26T20:01:00 2019-09-30T13:27:09 2019-09-30T13:27:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 716 DUBOCE AVE, SAN FRANCISCO, CA, 94117 DUBOCE AVE 8 Duboce Triangle PARK 37.769093 -122.43552 POINT (-122.43552 37.769093) Mobile/Open311 http://mobile311.sfgov.org/reports/11471364/photos 28 7 5 3 5 15 8 29,492 5 9 9   28   5             1   5     28
65081 65081 11473238 2019-09-27T10:51:00 2019-09-30T09:42:35 2019-09-30T09:42:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DEMING ST and URANUS TER DEMING ST 8 Eureka Valley PARK 37.760478973389 -122.4453125 POINT (-122.4453125 37.76047897) Phone   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
65091 65091 11473317 2019-09-27T11:02:00 2019-09-30T09:33:40 2019-09-30T09:33:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 239 8TH ST, SAN FRANCISCO, CA, 94103 8TH ST 6 South of Market SOUTHERN 37.775830207219 -122.410985968053 POINT (-122.41098597 37.77583021) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
65630 65630 11478446 2019-09-28T15:13:00 2019-09-30T09:18:51 2019-09-30T09:18:51 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 491 LINDEN ST, SAN FRANCISCO, CA, 94102 LINDEN ST 5 Hayes Valley NORTHERN 37.775957399999996 -122.4258216 POINT (-122.4258216 37.7759574) Web   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
65949 65949 11481125 2019-09-29T12:26:00 2019-09-30T09:26:36 2019-09-30T09:26:36 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1246 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Ashbury Heights PARK 37.760912899999994 -122.45157830000001 POINT (-122.4515783 37.7609129) Web http://mobile311.sfgov.org/reports/11481125/photos 114 7 11 14 11 15 8 29,492 5 12 12   114   11             1         114
67197 67197 11485842 2019-09-30T13:48:00   2019-10-30T15:40:13 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2435 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 9 Mission MISSION 37.765654105542005 -122.410913196373 POINT (-122.4109132 37.76565411) Web http://mobile311.sfgov.org/reports/11485842/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
67471 67471 11552456 2019-10-15T10:13:00 2019-10-16T09:10:55 2019-10-16T09:10:55 Closed 2 right of way is 5 feet, beyond is Park property DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 194 MIDCREST WAY, SAN FRANCISCO, CA, 94131 MIDCREST WAY 7 Midtown Terrace PARK 37.749946594238 -122.447875976563 POINT (-122.44787598 37.74994659) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
67523 67523 11552652 2019-10-15T10:31:00 2019-10-16T08:53:28 2019-10-16T08:53:28 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 777 ALABAMA ST, SAN FRANCISCO, CA, 94110 ALABAMA ST 9 Mission MISSION 37.759469 -122.41153600000001 POINT (-122.411536 37.759469) Mobile/Open311 http://mobile311.sfgov.org/reports/11552652/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
67807 67807 11555621 2019-10-15T18:25:00 2019-10-16T08:53:45 2019-10-16T08:53:45 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2386 15TH ST, SAN FRANCISCO, CA, 94114 15TH ST 8 Corona Heights PARK 37.765838333333 -122.436791666667 POINT (-122.43679167 37.76583833) Mobile/Open311 http://mobile311.sfgov.org/reports/11555621/photos 113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
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
68499 68499 11558975 2019-10-16T13:25:00 2019-10-29T12:31:47 2019-10-30T06:00:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3530 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.758721760509 -122.41976916801399 POINT (-122.41976917 37.75872176) Mobile/Open311 http://mobile311.sfgov.org/reports/11558975/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
68655 68655 11492246 2019-10-01T17:57:00 2019-10-09T15:57:04 2019-10-09T15:57:04 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 125 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Mission MISSION 37.752734483255 -122.421491900573 POINT (-122.4214919 37.75273448) Mobile/Open311 http://mobile311.sfgov.org/reports/11492246/photos 53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
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
71035 71035 11391895 2019-09-09T15:48:00   2019-10-01T12:50:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 55 GLENDALE ST, SAN FRANCISCO, CA, 94114 GLENDALE ST 8 Clarendon Heights PARK 37.756171566469 -122.44290104147301 POINT (-122.44290104 37.75617157) Mobile/Open311 http://mobile311.sfgov.org/reports/11391895/photos 47 7 5 38 5 2 8 28,862 5 38 38   47   5             1         47
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
71071 71071 11405673 2019-09-12T10:39:00 2019-10-01T05:18:03 2019-10-01T05:18:03 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 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 is for your pat DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1210 NEWHALL ST, SAN FRANCISCO, CA, 94124 NEWHALL ST 10 Bayview BAYVIEW 37.736614227295 -122.391555786133 POINT (-122.39155579 37.73661423) Phone   86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
71133 71133 10488270 2019-02-14T09:55:00   2019-03-13T10:15:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1106 BUSH ST, SAN FRANCISCO, CA, 94109 BUSH ST 3 Lower Nob Hill CENTRAL 37.789321777141 -122.415700837751 POINT (-122.41570084 37.78932178) Mobile/Open311   50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
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
71240 71240 11454996 2019-09-23T13:48:00 2019-10-01T06:12:00 2019-10-01T06:12:00 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 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 is for your pati DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 127 CORTLAND AVE, SAN FRANCISCO, CA, 94110 CORTLAND AVE 9 Bernal Heights INGLESIDE 37.740131778407005 -122.42041305529699 POINT (-122.42041306 37.74013178) Mobile/Open311 http://mobile311.sfgov.org/reports/11454996/photos 83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
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
71628 71628 11602933 2019-10-25T18:42:00 2019-10-28T10:15:12 2019-10-29T15:15:07 Closed 2 down branch DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 301 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Mission Dolores MISSION 37.764389393886 -122.426237231235 POINT (-122.42623723 37.76438939) Mobile/Open311 http://mobile311.sfgov.org/reports/11602933/photos 37 3 5 20 5 8 7 28,859 4 19 19   37   5             2   5     37
71634 71634 11602959 2019-10-25T18:55:00 2019-10-28T10:15:21 2019-10-29T13:58:52 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 301 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Mission Dolores MISSION 37.764416383615 -122.42629976023198 POINT (-122.42629976 37.76441638) Mobile/Open311   37 3 5 5 5 8 7 28,859 4 3 3   37   5             1   5     37
72042 72042 11607953 2019-10-27T10:21:00   2019-10-28T10:50:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 34 CAINE AVE, SAN FRANCISCO, CA, 94112 CAINE AVE 11 Oceanview TARAVAL 37.717670440674 -122.450386047363 POINT (-122.45038605 37.71767044) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
72162 72162 11608820 2019-10-27T13:44:00 2019-10-28T09:23:39 2019-10-29T15:15:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 8TH AVE and IRVING ST 8TH AVE 5 Inner Sunset TARAVAL 37.764083862305 -122.46524810791 POINT (-122.46524811 37.76408386) Phone   109 10 11 14 11 11 5 56 8 12 12 2 109   11 2     2     1         109
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
72447 72447 11564383 2019-10-17T14:10:00 2019-10-19T08:12:00 2019-10-19T08:12:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of ELLIS ST and LAGUNA ST ELLIS ST 5 Cathedral Hill NORTHERN 37.782985687255994 -122.42758178710899 POINT (-122.42758179 37.78298569) Phone   100 4 11 39 11 7 6 28,858 9 41 41 8 100   11 9     9     2         100
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
72934 72934 11400302 2019-09-11T10:27:00 2019-10-03T10:22:22 2019-10-03T10:22:22 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1133 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776119 -122.408597 POINT (-122.408597 37.776119) Mobile/Open311 http://mobile311.sfgov.org/reports/11400302/photos 32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
72937 72937 11400670 2019-09-11T11:15:00 2019-10-03T10:21:15 2019-10-03T10:21:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1126 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776243 -122.40844299999999 POINT (-122.408443 37.776243) Mobile/Open311   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
72971 72971 11412622 2019-09-13T16:23:00 2019-10-03T10:20:00 2019-10-03T10:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1714 LAKE ST, SAN FRANCISCO, CA, 94121 LAKE ST 2 Lake Street RICHMOND 37.786193847656 -122.47801971435499 POINT (-122.47801971 37.78619385) Phone   2 8 6 33 1 11 9 55 6 33 33   2   6             1         2
73024 73024 11431296 2019-09-18T08:34:00   2019-10-03T10:35:09 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 33 RAUSCH ST, SAN FRANCISCO, CA, 94103 RAUSCH ST 6 South of Market SOUTHERN 37.776699066162 -122.40985107421899 POINT (-122.40985107 37.77669907) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
76446 76446 11478941 2019-09-28T17:27:00 2019-10-01T09:01:00 2019-10-01T09:01:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of LAGUNA ST and LINDEN ST LAGUNA ST 5 Hayes Valley NORTHERN 37.775997161865 -122.426170349121 POINT (-122.42617035 37.77599716) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
76935 76935 11484172 2019-09-30T09:55:00 2019-10-22T13:46:00 2019-10-22T13:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of PERU AVE and VALMAR TER PERU AVE 11 Excelsior INGLESIDE 37.725964700000006 -122.4241652 POINT (-122.4241652 37.7259647) Web http://mobile311.sfgov.org/reports/11484172/photos 90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90

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