calls

80,878 rows where Category = 1 sorted by :@computed_region_fcz8_est8 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
14651 14651 11310025 2019-08-22T17:20:43 2019-09-30T13:32:50 2019-09-30T13:32:50 Closed 2 There is no immediate safety issue with the sidewalk adjacent to this property so it will be repaired in the next few years. The City has taken over responsibility for the maintenance of tree-related sidewalks. Through a program called StreetTreeSF, tree-related sidewalks that are in the worst condition are being addressed first and every tree-related sidewalk will be addressed following a maintenance schedule that is focused on public safety. Thank you for your patience. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2270 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.764913262835 -122.43247655231701 POINT (-122.43247655 37.76491326) Mobile/Open311 http://mobile311.sfgov.org/reports/11310025/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
33778 33778 11613879 2019-10-28T15:26:00   2019-10-28T15:35:13 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of MARKET ST and SANCHEZ ST MARKET ST 8 Castro MISSION 37.765869140625 -122.43102264404301 POINT (-122.43102264 37.76586914) Phone   37 3 5 5 5 15 7 28,862 4 3 3   37   5     5   9   1   5     37
33790 33790 11613922 2019-10-28T15:35:00   2019-10-28T16:10:06 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 44 HARTFORD ST, SAN FRANCISCO, CA, 94114 HARTFORD ST 8 Castro MISSION 37.761763846438 -122.434067551215 POINT (-122.43406755 37.76176385) Mobile/Open311 http://mobile311.sfgov.org/reports/11613922/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
46260 46260 11300910 2019-08-20T23:15:47 2019-09-24T07:56:17 2019-09-24T07:56:17 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 3951 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Castro MISSION 37.762426122712995 -122.434181256964 POINT (-122.43418126 37.76242612) Mobile/Open311   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
58497 58497 11346093 2019-08-30T11:12:00   2019-10-15T12:39:43 Open 1 open DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 130 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768970489502 -122.429130554199 POINT (-122.42913055 37.76897049) Phone   28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
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
71301 71301 11559854 2019-10-16T15:37:19   2019-10-16T15:45:32 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 498 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761179460248 -122.435033870975 POINT (-122.43503387 37.76117946) Mobile/Open311 http://mobile311.sfgov.org/reports/11559854/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
73469 73469 11487114 2019-09-30T17:20:27   2019-10-03T11:56:14 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 134 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768922390565 -122.42915890979799 POINT (-122.42915891 37.76892239) Mobile/Open311 http://mobile311.sfgov.org/reports/11487114/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
78060 78060 11489380 2019-10-01T09:57:00   2019-10-01T12:04:25 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 410 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762403923283 -122.435351777286 POINT (-122.43535178 37.76240392) Mobile/Open311 http://mobile311.sfgov.org/reports/11489380/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5 48 16 38
81894 81894 11436538 2019-09-19T09:30:00 2019-10-02T21:30:59 2019-10-02T21:30:59 Closed 2 Per process - cases are closed 10 days after assignment. Clear Channel - Transit Queue 23 Tree Maintenance 1 Trees - Landscaping 5 Other 410 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762235202838 -122.435481568732 POINT (-122.43548157 37.7622352) Mobile/Open311 http://mobile311.sfgov.org/reports/11436538/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
86828 86828 10301804 2019-01-01T12:22:00 2019-02-08T01:28:27 2019-02-08T01:28:27 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2164 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.766574986358 -122.430105418095 POINT (-122.43010542 37.76657499) Mobile/Open311 http://mobile311.sfgov.org/reports/10301804/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5     5   9   1   5     37
100106 100106 9475555 2018-08-30T14:20:00 2019-01-23T00:00:00 2019-01-23T00:00:00 Closed 2 Center median dry need irrigation from market and Dolores to San Jose and Dolores - X1104: 1138766 DPW BSM Queue 3 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 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
123003 123003 6295453 2016-09-10T08:22:14 2016-10-12T05:25:09 2016-10-12T05:25:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 3555 16TH ST, SAN FRANCISCO, CA, 94114 16TH ST 8 Castro MISSION 37.764066874255 -122.43190520703199 POINT (-122.43190521 37.76406687) Mobile/Open311   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
127380 127380 5866567 2016-05-14T12:56:39 2016-05-16T01:39:59 2016-05-16T01:39:59 Closed 2 inspection does not find conditions warranting further enforcement. trees appear to be properly staked with wood chips in each basin. no stains on sidewalk that warranty further enforcement. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of DOLORES ST and MARKET ST DOLORES ST 8 Mission Dolores MISSION 37.769076826556 -122.426873626544 POINT (-122.42687363 37.76907683) Mobile/Open311 http://mobile311.sfgov.org/reports/5866567/photos 37 3 5 20 5 8 7 28,862 4 19 19   37   5     5   9   2   5     37
131322 131322 5422649 2016-01-01T13:08:34 2016-01-21T01:21:28 2016-01-21T01:21:28 Closed 2 resolved: duplicate DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 16TH ST and MARKET ST 16TH ST 8 Castro MISSION 37.764305 -122.43304499999999 POINT (-122.433045 37.764305) Mobile/Open311 http://mobile311.sfgov.org/reports/5422649/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
133858 133858 5320678 2015-11-25T15:42:36 2015-12-01T12:11:58 2015-12-01T12:11:58 Closed 2 resolved: privet property trees, Please contact the property owner . DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2000 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mint Hill MISSION 37.769233333333 -122.427466666667 POINT (-122.42746667 37.76923333) Mobile/Open311 http://mobile311.sfgov.org/reports/5320678/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20 12 5 20 9   1   5     28
145516 145516 3550561 2014-04-14T14:33:30 2014-04-30T01:45:54 2014-04-30T01:45:54 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 2020 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.769283147574 -122.42690963598301 POINT (-122.42690964 37.76928315) Phone   28 3 5 5 5 7 7 28,862 4 3 3 18 28   5 20   5 20 9   1   5     28
145970 145970 9291907 2018-07-20T09:11:00 2018-07-25T09:46:00 2018-07-25T09:46:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 2425 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.7621600591 -122.43575488228599 POINT (-122.43575488 37.76216006) Mobile/Open311   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1     1   5   16 38
173059 173059 9062680 2018-05-29T09:41:00 2018-06-19T14:48:06 2018-06-19T14:48:06 Closed 2 site is recorded as a planting site DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 4126 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.760942755302 -122.43568179209 POINT (-122.43568179 37.76094276) Mobile/Open311 http://mobile311.sfgov.org/reports/9062680/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5   12 5 1 9   1   5     38
182959 182959 9384642 2018-08-10T09:56:00   2018-08-15T10:00:10 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 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
185215 185215 9145675 2018-06-16T14:46:00   2018-06-16T16:06:42 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of CASTRO ST and 18TH ST CASTRO ST 8 Castro MISSION 37.760887145996 -122.43499755859399 POINT (-122.43499756 37.76088715) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
188168 188168 9072431 2018-05-30T19:16:52 2018-06-19T15:11:53 2018-06-19T15:11:53 Closed 2 stump removal request created DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 498 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.76120959319 -122.435141243155 POINT (-122.43514124 37.76120959) Mobile/Open311 http://mobile311.sfgov.org/reports/9072431/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
195401 195401 9364519 2018-08-06T09:05:00   2018-08-06T09:35:02 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of 18TH ST and CASTRO ST 18TH ST 8 Castro MISSION 37.760887145996 -122.43499755859399 POINT (-122.43499756 37.76088715) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
204253 204253 9081366 2018-06-01T13:43:00 2018-08-13T15:42:04 2018-08-13T15:42:04 Closed 2 site has been recorded as a potential planting site. The property owner or tenant can expedite and plant a tree themselves DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 130 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768978402054 -122.42889429453999 POINT (-122.42889429 37.7689784) Mobile/Open311 http://mobile311.sfgov.org/reports/9081366/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20 12 5 20 9   1   5     28
211660 211660 9402878 2018-08-14T15:17:00 2018-10-29T13:36:22 2018-10-29T13:36:22 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 4122 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.760986328125 -122.43563842773399 POINT (-122.43563843 37.76098633) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
220888 220888 9234220 2018-07-06T17:24:00 2018-07-27T10:25:19 2018-07-27T10:25:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 160 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768326415716 -122.42910459648998 POINT (-122.4291046 37.76832642) Mobile/Open311 http://mobile311.sfgov.org/reports/9234220/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
232303 232303 9063181 2018-05-29T10:49:00 2018-05-29T11:15:18 2018-05-29T11:15:18 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of COLLINGWOOD ST and 18TH ST COLLINGWOOD ST 8 Castro MISSION 37.760822296143 -122.43611145019501 POINT (-122.43611145 37.7608223) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
235453 235453 9125575 2018-06-12T08:39:23 2018-08-13T15:41:07 2018-08-13T15:41:07 Closed 2 this species is known for dropping aphid related honeydew, which is sticky. It is seasonal and will eventually stop DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 130 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.769153254547 -122.428969156262 POINT (-122.42896916 37.76915325) Mobile/Open311 http://mobile311.sfgov.org/reports/9125575/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20 12 5 20 9   1   5     28
248761 248761 9173859 2018-06-22T21:25:31 2018-08-13T15:49:51 2018-08-13T15:49:51 Closed 2 were aware of missing tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 498 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761078500224 -122.435129424671 POINT (-122.43512942 37.7610785) Mobile/Open311 http://mobile311.sfgov.org/reports/9173859/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
258390 258390 9342617 2018-07-31T16:12:25 2018-08-13T15:49:13 2018-08-13T15:49:13 Closed 2 were aware of missing tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 474 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761260303704 -122.435066895674 POINT (-122.4350669 37.7612603) Mobile/Open311 http://mobile311.sfgov.org/reports/9342617/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
269561 269561 9325986 2018-07-27T16:51:00 2018-08-30T13:00:49 2018-08-30T13:00:49 Closed 2 Notes:site recorded as a planting site. BUF Action:Inspect. date completed - 8/30/2018. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 2029 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mission Dolores MISSION 37.768599456211 -122.42732109513399 POINT (-122.4273211 37.76859946) Mobile/Open311 http://mobile311.sfgov.org/reports/9325986/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5     5   9   1   5     37
286655 286655 9320684 2018-07-26T14:38:37 2018-08-13T15:50:14 2018-08-13T15:50:14 Closed 2 were aware of missing tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 474 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761248736677 -122.43508919153601 POINT (-122.43508919 37.76124874) Mobile/Open311 http://mobile311.sfgov.org/reports/9320684/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
288255 288255 9274151 2018-07-16T13:37:00 2018-07-16T14:09:45 2018-07-16T14:09:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 130 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768970489502 -122.429130554199 POINT (-122.42913055 37.76897049) Phone   28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
290729 290729 9083520 2018-06-02T06:48:12 2018-06-19T13:34:15 2018-06-19T13:34:15 Closed 2 BUF is aware of the missing tree DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 432 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761988333333 -122.435128333333 POINT (-122.43512833 37.76198833) Mobile/Open311 http://mobile311.sfgov.org/reports/9083520/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
293550 293550 9650104 2018-10-09T18:39:07 2018-10-29T13:28:33 2018-10-29T13:28:33 Closed 2 Palm dead. posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 489 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761246 -122.434891 POINT (-122.434891 37.761246) Mobile/Open311 http://mobile311.sfgov.org/reports/9650104/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
296043 296043 9572651 2018-09-21T16:14:00 2018-09-24T07:15:47 2018-09-24T07:15:47 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 - Tree_Other 4 Other 4052 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.761002518272 -122.43408068094601 POINT (-122.43408068 37.76100252) Mobile/Open311 http://mobile311.sfgov.org/reports/9572651/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
309591 309591 9439451 2018-08-22T17:56:13 2018-12-12T09:16:52 2018-12-12T09:16:52 Closed 2 property owner required to remove and replace tree. If not removed soon, the city will remove it during normal block maintenance DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 124 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768891397899 -122.429214231784 POINT (-122.42921423 37.7688914) Mobile/Open311 http://mobile311.sfgov.org/reports/9439451/photos 28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
325766 325766 9613211 2018-10-01T15:53:00 2018-10-04T14:33:06 2018-10-04T14:33:06 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 4126 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.760868575459 -122.435704590867 POINT (-122.43570459 37.76086858) Mobile/Open311 http://mobile311.sfgov.org/reports/9613211/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
325993 325993 9471565 2018-08-29T17:22:45 2018-10-29T13:33:06 2018-10-29T13:33:06 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 421 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762152054382 -122.435057927037 POINT (-122.43505793 37.76215205) Mobile/Open311 http://mobile311.sfgov.org/reports/9471565/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
365668 365668 9411253 2018-08-16T11:47:00 2018-08-30T13:09:17 2018-08-30T13:09:17 Closed 2 property owner required to remove and replace tree. If not removed soon, the city will remove it during normal block maintenance DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 130 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Duboce Triangle PARK 37.768970489502 -122.429130554199 POINT (-122.42913055 37.76897049) Phone   28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
369602 369602 9572647 2018-09-21T16:14:00   2018-09-21T19:40:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 4072 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.761004529929 -122.434269860501 POINT (-122.43426986 37.76100453) Mobile/Open311 http://mobile311.sfgov.org/reports/9572647/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
379816 379816 9682823 2018-10-17T07:55:09 2018-10-29T13:28:21 2018-10-29T13:28:21 Closed 2 Palm dead. posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 498 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761191666666996 -122.435075 POINT (-122.435075 37.76119167) Mobile/Open311 http://mobile311.sfgov.org/reports/9682823/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
382110 382110 9451603 2018-08-25T12:48:00 2018-08-27T07:37:35 2018-08-27T07:37:35 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 2266 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.764924285037 -122.43234177131399 POINT (-122.43234177 37.76492429) Mobile/Open311 http://mobile311.sfgov.org/reports/9451603/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
389664 389664 9712631 2018-10-23T18:51:00 2018-11-20T04:46:00 2018-11-20T04:46:00 Closed 2 Notes:from CMMS: Tree Crew Planted New King Palm Tree here.. BUF Action:Backfill/Adjust. date completed - 11/20/2018. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 427 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762344360352 -122.43492889404301 POINT (-122.43492889 37.76234436) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
406792 406792 9540858 2018-09-14T11:46:00 2018-10-24T00:00:00 2018-10-24T00:00:00 Closed 2 Low tree basin - X1104: 1139569 DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 462 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761499939386 -122.435120608382 POINT (-122.43512061 37.76149994) Mobile/Open311 http://mobile311.sfgov.org/reports/9540858/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
408004 408004 9429267 2018-08-20T19:02:14 2018-10-29T13:36:39 2018-10-29T13:36:39 Closed 2 in queue to plant DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 85 COLLINGWOOD ST, SAN FRANCISCO, CA, 94114 COLLINGWOOD ST 8 Castro MISSION 37.761151674239 -122.43609619338301 POINT (-122.43609619 37.76115167) Mobile/Open311 http://mobile311.sfgov.org/reports/9429267/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
419841 419841 9734395 2018-10-29T08:25:54 2019-07-12T10:15:03 2019-07-12T10:15:03 Closed 2 tree is okay and is supporting itself now DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2198 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.765897719922 -122.431231153368 POINT (-122.43123115 37.76589772) Mobile/Open311 http://mobile311.sfgov.org/reports/9734395/photos 28 3 5 5 5 15 7 28,862 4 3 3 18 28   5 20   5 20 9   1   5     28
425446 425446 9526304 2018-09-11T13:25:00 2018-09-12T06:52:22 2018-09-12T06:52:22 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 2266 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.764925997833 -122.432278529911 POINT (-122.43227853 37.764926) Mobile/Open311 http://mobile311.sfgov.org/reports/9526304/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
433527 433527 9861534 2018-11-28T09:07:00 2019-03-09T15:57:40 2019-03-09T15:57:40 Closed 2 basins can be within an inch of sidewalk grade, these basins on the 400 block of Castro on the west side are currently fine. please let us know if the are 2 or more inches below sidewalk grade. thank you. DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 468 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761376789323 -122.435174167192 POINT (-122.43517417 37.76137679) Mobile/Open311   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
446152 446152 10312391 2019-01-03T16:59:51 2019-07-12T10:01:35 2019-07-12T10:01:35 Closed 2 Notes:stump must be removed planting site is viable . BUF Action:Inspect. date completed - 7/12/2019. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2175 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mission Dolores MISSION 37.76649228147 -122.42997698023599 POINT (-122.42997698 37.76649228) Mobile/Open311   37 3 5 5 5 8 7 28,862 4 3 3   37   5     5   9   1   5     37
462545 462545 10302764 2019-01-01T18:00:39 2019-02-08T01:28:14 2019-02-08T01:28:14 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2150 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.76670640338 -122.430036831761 POINT (-122.43003683 37.7667064) Mobile/Open311 http://mobile311.sfgov.org/reports/10302764/photos 28 3 5 5 5 7 7 28,862 4 3 3 18 28   5 20   5 20 9   1   5     28
488104 488104 10316432 2019-01-04T14:27:43 2019-02-26T15:44:50 2019-02-26T15:44:50 Closed 2 tree posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CASTRO ST and 18TH ST CASTRO ST 8 Castro MISSION 37.760853342759994 -122.43488669033998 POINT (-122.43488669 37.76085334) Mobile/Open311 http://mobile311.sfgov.org/reports/10316432/photos 38 3 5 5 5 2 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
496783 496783 10304815 2019-01-02T10:47:00 2019-07-12T10:02:56 2019-07-12T10:02:56 Closed 2 I found no issues at 2141 DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2141 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mission Dolores MISSION 37.766613914009994 -122.429900046663 POINT (-122.42990005 37.76661391) Mobile/Open311   37 3 5 5 5 8 7 28,862 4 3 3   37   5     5   9   1   5     37
496791 496791 10310298 2019-01-03T11:45:00 2019-02-26T15:45:53 2019-02-26T15:45:53 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2175 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Mission Dolores MISSION 37.766394638491995 -122.430087961371 POINT (-122.43008796 37.76639464) Mobile/Open311 http://mobile311.sfgov.org/reports/10310298/photos 37 3 5 5 5 8 7 28,862 4 3 3   37   5     5   9   1   5     37
501063 501063 10316452 2019-01-04T14:30:28 2019-02-26T15:47:36 2019-02-26T15:47:36 Closed 2 posted for removal DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 497 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.76097554213 -122.43502934474701 POINT (-122.43502934 37.76097554) Mobile/Open311 http://mobile311.sfgov.org/reports/10316452/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
504221 504221 10403004 2019-01-24T23:14:00 2019-02-26T15:45:25 2019-02-26T15:45:25 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2475 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.762344380962 -122.435987910356 POINT (-122.43598791 37.76234438) Mobile/Open311 http://mobile311.sfgov.org/reports/10403004/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5       1   5     38
507404 507404 6659192 2016-12-24T14:21:36 2016-12-28T18:25:11 2016-12-28T18:25:11 Closed 2 10-98 Completed DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of POND ST and 16TH ST POND ST 8 Castro MISSION 37.764289194573 -122.432281791764 POINT (-122.43228179 37.76428919) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
531408 531408 10403006 2019-01-24T23:16:00   2019-02-15T11:00:09 Open 1 in progress DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 2450 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Corona Heights MISSION 37.762427033378 -122.43581135254999 POINT (-122.43581135 37.76242703) Mobile/Open311 http://mobile311.sfgov.org/reports/10403006/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5       1   5     38
544754 544754 10316296 2019-01-04T14:06:00   2019-01-04T15:01:15 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 90 COLLINGWOOD ST, SAN FRANCISCO, CA, 94114 COLLINGWOOD ST 8 Castro MISSION 37.7610081 -122.43623999999998 POINT (-122.43624 37.7610081) Web http://mobile311.sfgov.org/reports/10316296/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5   12 5 1 9   1   5     38
545037 545037 9820583 2018-11-17T12:36:00 2018-11-17T12:50:46 2018-11-17T12:50:46 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 76 COLLINGWOOD ST, SAN FRANCISCO, CA, 94114 COLLINGWOOD ST 8 Castro MISSION 37.761164750008 -122.436136677975 POINT (-122.43613668 37.76116475) Mobile/Open311 http://mobile311.sfgov.org/reports/9820583/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
548195 548195 10341532 2019-01-10T14:43:05 2019-07-12T10:22:54 2019-07-12T10:22:54 Closed 2 small hanger stuck in tree. I will have tree crew remove. its been sitting there since janruary DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2219 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.765599203571 -122.43131465030399 POINT (-122.43131465 37.7655992) Mobile/Open311 http://mobile311.sfgov.org/reports/10341532/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5   9   1   5     38
567284 567284 10622095 2019-03-19T16:07:00 2019-05-14T12:39:27 2019-05-14T12:39:27 Closed 2 buf is aware, tree was planted by private property owener DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of CHURCH ST and MARKET ST CHURCH ST 8 Duboce Triangle MISSION 37.767505645752 -122.42894744873001 POINT (-122.42894745 37.76750565) Phone   28 3 5 5 5 7 7 28,862 4 3 3   28   5     5   9   1   5     28
573092 573092 10699189 2019-04-07T22:38:00 2019-04-09T05:41:18 2019-04-09T05:41: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 patie DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3973 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Castro MISSION 37.762373499999995 -122.4344653 POINT (-122.4344653 37.7623735) Web   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
583141 583141 10593065 2019-03-12T13:32:00 2019-03-14T06:02:52 2019-03-14T06:02:52 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 2262 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.764932625031 -122.432275973374 POINT (-122.43227597 37.76493263) Mobile/Open311 http://mobile311.sfgov.org/reports/10593065/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
591727 591727 10579933 2019-03-08T17:38:00   2019-03-28T22:10:07 Open 1 accepted DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2266 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Duboce Triangle MISSION 37.7649188368 -122.43232542660299 POINT (-122.43232543 37.76491884) Mobile/Open311 http://mobile311.sfgov.org/reports/10579933/photos 28 3 5 5 5 15 7 28,862 4 3 3   28   5     5   9   1   5     28
592677 592677 10746119 2019-04-18T12:05:54 2019-04-18T16:11:32 2019-04-18T16:11:32 Closed 2 request already into cmms DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 4124 18TH ST, SAN FRANCISCO, CA, 94114 18TH ST 8 Castro MISSION 37.760861 -122.43565530000001 POINT (-122.4356553 37.760861) Web   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
623610 623610 10489512 2019-02-14T13:11:00 2019-02-14T13:38:32 2019-02-14T13:38:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MARKET ST and SANCHEZ ST MARKET ST 8 Castro MISSION 37.765869140625 -122.43102264404301 POINT (-122.43102264 37.76586914) Phone   37 3 5 5 5 15 7 28,862 4 3 3   37   5     5   9   1   5     37
630012 630012 10658108 2019-03-28T14:24:39 2019-08-10T10:31:54 2019-08-10T10:31:54 Closed 2 very little that can be done here DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2367 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.763045821996 -122.43449080386299 POINT (-122.4344908 37.76304582) Mobile/Open311 http://mobile311.sfgov.org/reports/10658108/photos 38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1 9   1   5     38
656825 656825 10535352 2019-02-26T09:15:00 2019-02-26T10:06:51 2019-02-26T10:06:51 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2475 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Castro MISSION 37.762096272817004 -122.435921849797 POINT (-122.43592185 37.76209627) Mobile/Open311 http://mobile311.sfgov.org/reports/10535352/photos 38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1     1   5   16 38
660445 660445 410311 2009-04-13T12:05:26 2009-04-15T09:10:22 2009-04-15T09:10:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of MARKET ST and SANCHEZ ST MARKET ST 8 Castro MISSION 37.765869140625 -122.43102264404301 POINT (-122.43102264 37.76586914) Phone   37 3 5 5 5 15 7 28,862 4 3 3   37   5     5   9   1   5     37
660896 660896 418003 2009-04-24T09:59:56 2009-04-29T09:10:39 2009-04-29T09:10:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CHURCH ST and MARKET ST CHURCH ST 8 Duboce Triangle MISSION 37.767505645752 -122.42894744873001 POINT (-122.42894745 37.76750565) Phone   28 3 5 5 5 7 7 28,862 4 3 3   28   5     5   9   1   5     28
661459 661459 389289 2009-03-14T15:30:41 2009-03-27T10:10:17 2009-03-27T10:10:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
664585 664585 416544 2009-04-22T08:22:48 2010-03-26T13:59:36 2010-03-26T13:59:36 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 16TH ST and POND ST 16TH ST 8 Castro MISSION 37.764289855956996 -122.43228149414101 POINT (-122.43228149 37.76428986) Web   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
676701 676701 243939 2008-07-07T21:24:05 2008-07-08T17:05:42 2008-07-08T17:05:42 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 17TH ST and MARKET ST 17TH ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
681678 681678 252682 2008-07-23T10:21:25 2010-11-12T16:34:28 2010-11-12T16:34:28 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 486 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761108398438 -122.435218811035 POINT (-122.43521881 37.7611084) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
690010 690010 284104 2008-09-19T09:09:28 2010-06-26T19:17:00 2010-06-26T19:17:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
695924 695924 307269 2008-11-01T15:34:21 2011-08-08T10:06:08 2011-08-08T10:06:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of MARKET ST and SANCHEZ ST MARKET ST 8 Castro MISSION 37.765869140625 -122.43102264404301 POINT (-122.43102264 37.76586914) Phone   37 3 5 5 5 15 7 28,862 4 3 3   37   5     5   9   1   5     37
698277 698277 317989 2008-11-21T00:03:21 2008-12-17T16:07:04 2008-12-17T16:07:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 16TH ST and MARKET ST 16TH ST 8 Castro MISSION 37.764194488525 -122.433074951172 POINT (-122.43307495 37.76419449) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
700519 700519 268606 2008-08-21T18:41:36 2008-12-23T09:07:05 2008-12-23T09:07:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 17TH ST and HARTFORD ST 17TH ST 8 Castro MISSION 37.762550354004 -122.43405914306601 POINT (-122.43405914 37.76255035) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
701967 701967 297263 2008-10-14T13:07:43 2009-03-12T09:10:09 2009-03-12T09:10:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CHURCH ST and MARKET ST CHURCH ST 8 Duboce Triangle MISSION 37.767505645752 -122.42894744873001 POINT (-122.42894745 37.76750565) Phone   28 3 5 5 5 7 7 28,862 4 3 3   28   5     5   9   1   5     28
714448 714448 244406 2008-07-08T16:59:49 2008-08-01T11:04:51 2008-08-01T11:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 17TH ST and MARKET ST 17TH ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
719226 719226 255169 2008-07-28T09:54:12 2008-10-16T16:47:17 2008-10-16T16:47:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 440 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761833190918004 -122.435287475586 POINT (-122.43528748 37.76183319) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
725488 725488 432843 2009-05-16T19:31:30 2009-05-29T18:12:10 2009-05-29T18:12:10 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of 17TH ST and MARKET ST 17TH ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
730038 730038 282640 2008-09-16T15:08:58 2010-06-26T19:16:58 2010-06-26T19:16:58 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
734012 734012 314181 2008-11-14T10:39:25 2009-03-12T09:10:16 2009-03-12T09:10:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin Intersection of CHURCH ST and MARKET ST CHURCH ST 8 Duboce Triangle MISSION 37.767505645752 -122.42894744873001 POINT (-122.42894745 37.76750565) Phone   28 3 5 5 5 7 7 28,862 4 3 3   28   5     5   9   1   5     28
734399 734399 268410 2008-08-21T13:30:57 2010-07-12T10:16:59 2010-07-12T10:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of MARKET ST and NOE ST MARKET ST 8 Castro MISSION 37.764194488525 -122.433074951172 POINT (-122.43307495 37.76419449) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
746861 746861 253257 2008-07-24T08:02:42 2008-08-01T09:04:49 2008-08-01T09:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 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
754159 754159 392946 2009-03-20T10:03:56 2009-05-29T18:13:07 2009-05-29T18:13:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 491 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.761219024658 -122.434844970703 POINT (-122.43484497 37.76121902) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
757747 757747 353822 2009-01-17T23:01:49 2010-12-20T15:09:23 2010-12-20T15:09:23 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of 17TH ST and HARTFORD ST 17TH ST 8 Castro MISSION 37.762550354004 -122.43405914306601 POINT (-122.43405914 37.76255035) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
764291 764291 344096 2009-01-04T10:00:28 2009-06-03T12:10:42 2009-06-03T12:10:42 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 20 HARTFORD ST, SAN FRANCISCO, CA, 94114 HARTFORD ST 8 Castro MISSION 37.762187957764 -122.434135437012 POINT (-122.43413544 37.76218796) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1   5 1     1   5     38
768671 768671 266424 2008-08-18T10:44:07 2009-03-12T09:10:14 2009-03-12T09:10:14 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 14TH ST and MARKET ST 14TH ST 8 Duboce Triangle MISSION 37.767734527588 -122.428657531738 POINT (-122.42865753 37.76773453) Phone   37 3 5 5 5 7 7 28,862 4 3 3   37   5     5   9   1   5     37
781445 781445 347559 2009-01-08T17:01:45 2009-01-10T15:07:11 2009-01-10T15:07:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of 16TH ST and PROSPER ST 16TH ST 8 Castro MISSION 37.764324188232 -122.43170166015601 POINT (-122.43170166 37.76432419) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1     1   5     38
781865 781865 253303 2008-07-24T09:11:09 2008-07-29T14:04:46 2008-07-29T14:04:46 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of CHURCH ST and DUBOCE AVE CHURCH ST 8 Duboce Triangle PARK 37.769454956055 -122.429130554199 POINT (-122.42913055 37.76945496) Phone   28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20   5 20 9   1   5     28
784703 784703 243940 2008-07-07T21:30:16 2008-08-01T11:04:50 2008-08-01T11:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
793375 793375 304148 2008-10-27T10:37:46 2010-06-26T19:17:06 2010-06-26T19:17:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
806960 806960 482698 2009-08-06T15:42:46 2009-08-06T17:11:09 2009-08-06T17:11:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of CHURCH ST and MARKET ST CHURCH ST 8 Duboce Triangle MISSION 37.767505645752 -122.42894744873001 POINT (-122.42894745 37.76750565) Phone   28 3 5 5 5 7 7 28,862 4 3 3   28   5     5   9   1   5     28
818320 818320 468304 2009-07-14T13:22:28 2009-08-12T18:11:09 2009-08-12T18:11:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 426 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Castro MISSION 37.762058258056996 -122.435302734375 POINT (-122.43530273 37.76205826) Phone   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12 5 1 9   1   5     38
830966 830966 615166 2010-03-06T21:17:51 2010-03-16T10:16:40 2010-03-16T10:16:40 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 14TH ST and MARKET ST 14TH ST 8 Duboce Triangle MISSION 37.767734527588 -122.428657531738 POINT (-122.42865753 37.76773453) Phone   37 3 5 5 5 7 7 28,862 4 3 3   37   5     5   9   1   5     37
851201 851201 576416 2010-01-07T09:26:25 2010-01-07T17:16:32 2010-01-07T17:16:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 16TH ST and MARKET ST 16TH ST 8 Castro MISSION 37.764194488525 -122.433074951172 POINT (-122.43307495 37.76419449) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38
859522 859522 457702 2009-06-26T09:57:15 2009-06-27T15:10:55 2009-06-27T15:10:55 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of 16TH ST and MARKET ST 16TH ST 8 Castro MISSION 37.764194488525 -122.433074951172 POINT (-122.43307495 37.76419449) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5     5 1 9   1   5     38

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