This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43 | 43 | 43 | 11535870 | 2019-10-11T08:56:58 | 2019-10-11T09:15:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 450 CARGO WAY, SAN FRANCISCO, CA, 94124 | CARGO WAY | 10 | Central Waterfront | BAYVIEW | 37.744414755201 | -122.384434893885 | POINT (-122.38443489 37.74441476) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11535870/photos | 76 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 76 | 9 | 1 | 76 | |||||||||||||
| 59 | 59 | 59 | 11536492 | 2019-10-11T10:30:08 | 2019-10-21T09:36:53 | 2019-10-21T09:36:53 | Closed 2 | property owners hold the liability if the damage occurred prior to July 1 2017. we are responsible for repairing but the liability is with the adjacent owner until that time. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 220 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 | MAGELLAN AVE | 7 | Forest Hill | TARAVAL | 37.747464 | -122.46059 | POINT (-122.46059 37.747464) | Web | 45 | 10 | 8 | 41 | 4 | 1 | 5 | 29,491 | 8 | 40 | 40 | 45 | 8 | 1 | 45 | |||||||||||||
| 76 | 76 | 76 | 11537288 | 2019-10-11T12:20:00 | 2019-10-11T12:30:06 | 2019-10-11T12:30:06 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 775 MCALLISTER ST, SAN FRANCISCO, CA, 94102 | MCALLISTER ST | 5 | Western Addition | NORTHERN | 37.778961181641 | -122.425079345703 | POINT (-122.42507935 37.77896118) | Phone | 97 | 4 | 11 | 39 | 11 | 7 | 6 | 28,852 | 9 | 41 | 41 | 97 | 11 | 2 | 97 | ||||||||||||||
| 151 | 151 | 151 | 5704626 | 2016-03-27T16:23:04 | 2016-03-28T01:28:00 | 2016-03-28T01:28:00 | Closed 2 | nothing seen all clear | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | Intersection of 20TH ST and SHOTWELL ST | 20TH ST | 9 | Mission | MISSION | 37.75883102417 | -122.41577911376999 | POINT (-122.41577911 37.75883102) | Integrated Agency | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 13 | 53 | 2 | 15 | 3 | 15 | 2 | 3 | 53 | ||||||||
| 164 | 164 | 164 | 11509062 | 2019-10-05T12:19:00 | 2019-10-05T14:18:20 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 1601 9TH AVE, SAN FRANCISCO, CA, 94122 | 9TH AVE | 7 | Golden Gate Heights | TARAVAL | 37.75830078125 | -122.46605682373001 | POINT (-122.46605682 37.75830078) | Phone | 44 | 10 | 8 | 14 | 4 | 1 | 5 | 56 | 8 | 12 | 12 | 44 | 8 | 1 | 44 | ||||||||||||||
| 268 | 268 | 268 | 11542632 | 2019-10-12T17:38:00 | 2019-10-12T17:48:51 | 2019-10-12T17:48:51 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 221 12TH AVE, SAN FRANCISCO, CA, 94118 | 12TH AVE | 1 | Inner Richmond | RICHMOND | 37.784196007484 | -122.471058773174 | POINT (-122.47105877 37.78419601) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11542632/photos | 5 | 8 | 4 | 11 | 2 | 11 | 9 | 54 | 6 | 11 | 11 | 5 | 4 | 1 | 5 | |||||||||||||
| 284 | 284 | 284 | 5700190 | 2016-03-25T14:26:51 | 2016-03-28T10:52:57 | 2016-03-28T10:52:57 | Closed 2 | Request closed by in Operations system at Mar 28 2016 12:00AM. Notes = " Notes:Letter created. BUF Action:Inspect. date completed - 3/28/2016. ". | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1402 15TH ST, SAN FRANCISCO, CA, 94103 | 15TH ST | 9 | Mission | MISSION | 37.767029483838 | -122.415954144786 | POINT (-122.41595414 37.76702948) | Mobile/Open311 | http://mobile311.sfgov.org/reports/5700190/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,853 | 4 | 19 | 19 | 12 | 53 | 2 | 14 | 3 | 14 | 2 | 3 | 53 | |||||||
| 322 | 322 | 322 | 5699261 | 2016-03-25T11:05:16 | 2016-04-12T02:41:00 | 2016-04-12T02:41:00 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 3430 GEARY BLVD, SAN FRANCISCO, CA, 94118 | GEARY BLVD | 2 | Laurel Heights / Jordan Park | RICHMOND | 37.781599066561 | -122.456177018353 | POINT (-122.45617702 37.78159907) | Phone | 11 | 8 | 6 | 31 | 1 | 11 | 9 | 54 | 6 | 31 | 31 | 11 | 6 | 1 | 11 | ||||||||||||||
| 358 | 358 | 358 | 11604477 | 2019-10-26T10:14:00 | 2019-10-28T14:18:48 | 2019-10-28T14:45:05 | Closed 2 | There is no immediate safety issue with your tree so it will be serviced in the next few years. The City has taken over responsibility for the care and maintenance of street trees. Through a program called StreetTreeSF, trees that are in the worst condition are being addressed first and every tree will be addressed following a maintenance schedule that is focused on public safety. Thank you for your patience. Notes:not a pruning priority . BUF Action:Inspect. date completed - 10/28/2019. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 2265 UNION ST, SAN FRANCISCO, CA, 94123 | UNION ST | 2 | Union Street | NORTHERN | 37.796829223633 | -122.43654632568399 | POINT (-122.43654633 37.79682922) | Phone | 15 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 15 | 6 | 19 | 1 | 15 | ||||||||||||
| 376 | 376 | 376 | 5697359 | 2016-03-24T16:42:51 | 2016-04-04T02:07:00 | 2016-04-04T02:07:00 | Closed 2 | Request Letter Sent. letter sent to homeowner to replant. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 3587 17TH ST, SAN FRANCISCO, CA, 94110 | 17TH ST | 8 | Mission Dolores | MISSION | 37.763008 | -122.425896 | POINT (-122.425896 37.763008) | Mobile/Open311 | http://mobile311.sfgov.org/reports/5697359/photos | 37 | 3 | 5 | 20 | 5 | 8 | 7 | 28,859 | 4 | 19 | 19 | 37 | 5 | 1 | 37 | ||||||||||||
| 419 | 419 | 419 | 5695378 | 2016-03-24T09:26:26 | 2016-11-10T01:25:10 | 2016-11-10T01:25:10 | Closed 2 | 1215 Fairfax Ave: Int. of Keith St. and Bowman Ct near curb ramp: overgrown ivy blocking pedestrian path 8/1616: some trimming done. NEED more trimming of ivy on the other side of the fence. IV - NTR: 1068063 | DPW BSM Queue 3 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | Intersection of BOWMAN CT and KEITH ST | BOWMAN CT | 10 | Bayview | BAYVIEW | 37.73776880012 | -122.38179734416401 | POINT (-122.38179734 37.7377688) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | |||||||||||||
| 441 | 441 | 441 | 11607259 | 2019-10-27T07:05:00 | 2019-10-28T07:44:28 | 2019-10-29T14:07:09 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 1265 STANYAN ST, SAN FRANCISCO, CA, 94117 | STANYAN ST | 5 | Parnassus Heights | PARK | 37.760410308838 | -122.451873779297 | POINT (-122.45187378 37.76041031) | Phone | 110 | 7 | 11 | 14 | 11 | 15 | 8 | 29,492 | 5 | 12 | 12 | 110 | 11 | 1 | 110 | ||||||||||||||
| 452 | 452 | 452 | 5694342 | 2016-03-23T18:50:33 | 2016-03-23T18:51:40 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 134 BARTLETT ST, SAN FRANCISCO, CA, 94110 | BARTLETT ST | 9 | Mission | MISSION | 37.754232202848 | -122.419873156843 | POINT (-122.41987316 37.7542322) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 453 | 453 | 453 | 11607582 | 2019-10-27T08:57:00 | 2019-10-28T10:23:02 | 2019-10-30T12:00:15 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 2515 GOUGH ST, SAN FRANCISCO, CA, 94123 | GOUGH ST | 2 | Pacific Heights | NORTHERN | 37.796714782715 | -122.42711639404301 | POINT (-122.42711639 37.79671478) | Phone | 102 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 102 | 6 | 1 | 102 | ||||||||||||||
| 480 | 480 | 480 | 11608308 | 2019-10-27T11:48:00 | 2019-10-28T09:59:39 | 2019-10-29T15:05:05 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 470 GROVE ST, SAN FRANCISCO, CA, 94102 | GROVE ST | 5 | Hayes Valley | NORTHERN | 37.777782440186 | -122.424278259277 | POINT (-122.42427826 37.77778244) | Phone | 22 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 22 | 11 | 1 | 22 | ||||||||||||||
| 569 | 569 | 569 | 11548402 | 2019-10-14T11:27:00 | 2019-10-14T11:35:27 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 2715 35TH AVE, SAN FRANCISCO, CA, 94116 | 35TH AVE | 4 | Parkside | TARAVAL | 37.7366065979 | -122.49261474609399 | POINT (-122.49261475 37.7366066) | Phone | 40 | 10 | 7 | 35 | 3 | 1 | 5 | 29,491 | 8 | 35 | 35 | 40 | 7 | 1 | 40 | ||||||||||||||
| 571 | 571 | 571 | 11548490 | 2019-10-14T11:41:00 | 2019-10-14T12:10:32 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 1433 INNES AVE, SAN FRANCISCO, CA, 94124 | INNES AVE | 10 | Bayview | BAYVIEW | 37.737487792969 | -122.385726928711 | POINT (-122.38572693 37.73748779) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 588 | 588 | 588 | 11611037 | 2019-10-28T08:24:00 | 2019-10-28T09:50:05 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Other_enter_additional_details_below | Intersection of 45TH AVE and BALBOA ST | 45TH AVE | 1 | Outer Richmond | RICHMOND | 37.775321960449 | -122.50588226318399 | POINT (-122.50588226 37.77532196) | Phone | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 1 | 8 | ||||||||||||||
| 598 | 598 | 598 | 11549544 | 2019-10-14T14:52:21 | 2019-10-14T15:25:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of PIERCE ST and OAK ST | PIERCE ST | 5 | Lower Haight | NORTHERN | 37.773571000000004 | -122.43413000000001 | POINT (-122.43413 37.773571) | Mobile/Open311 | 26 | 4 | 11 | 9 | 11 | 15 | 8 | 29,492 | 5 | 10 | 10 | 26 | 11 | 1 | 26 | ||||||||||||||
| 614 | 614 | 614 | 11611350 | 2019-10-28T09:11:00 | 2019-10-28T10:16:49 | 2019-10-29T14:50:08 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1 IRVING ST, SAN FRANCISCO, CA, 94122 | IRVING ST | 5 | Parnassus Heights | PARK | 37.764459011778 | -122.457307885178 | POINT (-122.45730789 37.76445901) | Mobile/Open311 | 110 | 7 | 11 | 14 | 11 | 15 | 8 | 29,492 | 5 | 12 | 12 | 110 | 11 | 1 | 110 | ||||||||||||||
| 623 | 623 | 623 | 11611558 | 2019-10-28T09:39:00 | 2019-10-28T14:06:44 | 2019-10-30T12:00:19 | Closed 2 | Made safe | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | 245 MARKET ST, SAN FRANCISCO, CA, 94105 | MARKET ST | 6 | Financial District | CENTRAL | 37.792785644531 | -122.396743774414 | POINT (-122.39674377 37.79278564) | Phone | 108 | 6 | 10 | 8 | 9 | 12 | 2 | 28,855 | 2 | 6 | 6 | 108 | 10 | 1 | 108 | |||||||||||||
| 640 | 640 | 640 | 11611992 | 2019-10-28T10:39:00 | 2019-10-29T15:15:05 | Open 1 | in progress | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 763 15TH AVE, SAN FRANCISCO, CA, 94118 | 15TH AVE | 1 | Inner Richmond | RICHMOND | 37.773754119873 | -122.47365570068399 | POINT (-122.4736557 37.77375412) | Phone | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 54 | 6 | 26 | 26 | 5 | 4 | 1 | 5 | ||||||||||||||
| 657 | 657 | 657 | 5688660 | 2016-03-22T10:37:55 | 2016-03-28T11:05:00 | 2016-03-28T11:05:00 | Closed 2 | Request closed by in Operations system at Mar 28 2016 12:00AM. Notes = " Notes:planting request exists. BUF Action:Inspect. date completed - 3/28/2016. ". | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | Intersection of 17TH ST and FOLSOM ST | 17TH ST | 9 | Mission | MISSION | 37.763659999999994 | -122.415269 | POINT (-122.415269 37.76366) | Mobile/Open311 | http://mobile311.sfgov.org/reports/5688660/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,859 | 4 | 19 | 19 | 12 | 53 | 2 | 14 | 3 | 14 | 2 | 3 | 53 | |||||||
| 686 | 686 | 686 | 11613518 | 2019-10-28T14:31:00 | 2019-10-29T10:52:29 | 2019-10-28T15:10:08 | Closed 2 | we apologize for the inconvenience and suggest pulling up and letting passengers in and out at the driveway area adjacent to the trees. these trees will be pruned during regular maintenance There is no immediate safety issue with your tree so it will be serviced in the next few years. The City has taken over responsibility for the care and maintenance of street trees. Through a program called StreetTreeSF, trees that are in the worst condition are being addressed first and every tree will be a | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 4606 CABRILLO ST, SAN FRANCISCO, CA, 94121 | CABRILLO ST | 1 | Outer Richmond | RICHMOND | 37.773475700000006 | -122.5081149 | POINT (-122.5081149 37.7734757) | Web | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 1 | 8 | |||||||||||||
| 720 | 720 | 720 | 5686204 | 2016-03-21T14:47:48 | 2016-03-22T02:45:00 | 2016-03-22T02:45:00 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Hanging_limb | 600 MCALLISTER ST, SAN FRANCISCO, CA, 94102 | MCALLISTER ST | 5 | Civic Center | NORTHERN | 37.779960461199 | -122.42219602543301 | POINT (-122.42219603 37.77996046) | Phone | 21 | 4 | 11 | 39 | 11 | 7 | 6 | 28,852 | 9 | 41 | 41 | 21 | 1 | 11 | 1 | 2 | 1 | 21 | |||||||||||
| 757 | 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 | |||||||||||||
| 795 | 795 | 795 | 5684106 | 2016-03-21T07:09:00 | 2016-03-28T03:03:00 | 2016-03-28T03:03:00 | Closed 2 | no branch found | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 638 MANSELL ST, SAN FRANCISCO, CA, 94134 | MANSELL ST | 9 | Portola | BAYVIEW | 37.72007 | -122.407455 | POINT (-122.407455 37.72007) | Mobile/Open311 | http://mobile311.sfgov.org/reports/5684106/photos | 91 | 2 | 2 | 25 | 7 | 10 | 3 | 309 | 3 | 28 | 28 | 91 | 2 | 1 | 91 | ||||||||||||
| 965 | 965 | 965 | 5683126 | 2016-03-20T14:26:08 | 2016-08-02T13:40:17 | 2016-08-02T13:40:17 | Closed 2 | see photo this is for landscape/gardeners | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Shrubbery_blocking_visibility | Intersection of MALTA DR and OSHAUGHNESSY BLVD | MALTA DR | 8 | Glen Park | INGLESIDE | 37.736519629304 | -122.44368662151199 | POINT (-122.44368662 37.73651963) | Mobile/Open311 | http://mobile311.sfgov.org/reports/5683126/photos | 72 | 9 | 8 | 41 | 4 | 9 | 4 | 63 | 7 | 40 | 40 | 72 | 8 | 1 | 72 | ||||||||||||
| 966 | 966 | 966 | 5683130 | 2016-03-20T14:29:18 | 2016-03-23T02:51:00 | 2016-03-23T02:51:00 | Closed 2 | DPW - Bureau of Street Environmental Services - G 4 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 1455 44TH AVE, SAN FRANCISCO, CA, 94122 | 44TH AVE | 4 | Outer Sunset | TARAVAL | 37.759473663406 | -122.503851056924 | POINT (-122.50385106 37.75947366) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 1040 | 1040 | 1040 | 11618478 | 2019-10-29T14:21:00 | 2019-10-29T15:26:16 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1862 DIVISADERO ST, SAN FRANCISCO, CA, 94115 | DIVISADERO ST | 2 | Lower Pacific Heights | NORTHERN | 37.786952972412 | -122.44003295898399 | POINT (-122.44003296 37.78695297) | Phone | 103 | 4 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 103 | 6 | 1 | 103 | ||||||||||||||
| 1079 | 1079 | 1079 | 5682449 | 2016-03-20T09:14:10 | 2016-03-20T09:36:28 | Open 1 | open | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 90 VERNA ST, SAN FRANCISCO, CA, 94127 | VERNA ST | 7 | Miraloma Park | INGLESIDE | 37.734508514404 | -122.448432922363 | POINT (-122.44843292 37.73450851) | Web | 72 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 72 | 8 | 1 | 72 | ||||||||||||||
| 1130 | 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 | |||||||||||||
| 1245 | 1245 | 1245 | 10499981 | 2019-02-17T14:13:00 | 2019-10-22T07:17:50 | 2019-10-22T07:17:50 | Closed 2 | this tree is stable and is to about to fall. sent to crews for pruning for pruning large branch over street , but still might take a while because it's as their schedule allows. We are trying as hard as possible to prune the city's nearly 125000 street trees so we ask for your patience. pls call 415.554.6700 for updates. Notes:over extended branch on street side , please reduce or remove as time allows. believe it should be addressed before regular maintenance, but it's not super urgent.. B | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 1835 ELLIS ST, SAN FRANCISCO, CA, 94115 | ELLIS ST | 5 | Western Addition | NORTHERN | 37.781707763671996 | -122.436645507813 | POINT (-122.43664551 37.78170776) | Phone | 97 | 4 | 11 | 39 | 11 | 15 | 8 | 29,490 | 5 | 41 | 41 | 97 | 11 | 2 | 97 | |||||||||||||
| 1246 | 1246 | 1246 | 10708134 | 2019-04-09T15:51:00 | 2019-10-22T07:56:54 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 1240 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 8 | Mission Terrace | INGLESIDE | 37.730506896973 | -122.43194580078101 | POINT (-122.4319458 37.7305069) | Phone | 94 | 9 | 5 | 28 | 5 | 9 | 4 | 28,861 | 7 | 25 | 25 | 16 | 94 | 5 | 1 | 94 | |||||||||||||
| 1258 | 1258 | 1258 | 10891519 | 2019-05-21T13:29:20 | 2019-10-22T12:49:48 | 2019-10-22T12:49:48 | Closed 2 | Request Letter Sent. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 651 BRANNAN ST, SAN FRANCISCO, CA, 94107 | BRANNAN ST | 6 | South of Market | SOUTHERN | 37.775558824686 | -122.39995183434601 | POINT (-122.39995183 37.77555882) | Mobile/Open311 | http://mobile311.sfgov.org/reports/10891519/photos | 32 | 1 | 10 | 4 | 9 | 14 | 2 | 28,856 | 2 | 20 | 20 | 32 | 10 | 1 | 32 | ||||||||||||
| 1274 | 1274 | 1274 | 10956697 | 2019-06-05T12:40:04 | 2019-06-10T10:03:03 | 2019-06-10T10:03:03 | Closed 2 | in queue to plant | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 2978 16TH ST, SAN FRANCISCO, CA, 94103 | 16TH ST | 9 | Mission | MISSION | 37.765067154577 | -122.419337164725 | POINT (-122.41933716 37.76506715) | Mobile/Open311 | http://mobile311.sfgov.org/reports/10956697/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,859 | 4 | 19 | 19 | 12 | 53 | 2 | 14 | 3 | 14 | 2 | 3 | 50 | 24 | 53 | |||||
| 1276 | 1276 | 1276 | 10964957 | 2019-06-07T09:45:00 | 2019-10-30T00:00:00 | 2019-10-30T14:55:07 | Closed 2 | Notes:blocking driveway access . BUF Action:Prune. Notes:blocking driveway access . BUF Action:Prune. date completed - 10/30/2019. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 127 HOLLOWAY AVE, SAN FRANCISCO, CA, 94112 | HOLLOWAY AVE | 11 | Ingleside | TARAVAL | 37.721740722656 | -122.454383850098 | POINT (-122.45438385 37.72174072) | Phone | 64 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 64 | 1 | 19 | 19 | 2 | 64 | |||||||||||
| 1307 | 1307 | 1307 | 10732373 | 2019-04-15T13:46:00 | 2019-10-10T06:35:49 | 2019-10-10T06:35:49 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 640 EDNA ST, SAN FRANCISCO, CA, 94127 | EDNA ST | 7 | Sunnyside | INGLESIDE | 37.732208251953004 | -122.44717407226601 | POINT (-122.44717407 37.73220825) | Phone | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | ||||||||||||||
| 1308 | 1308 | 1308 | 11180890 | 2019-07-25T19:20:00 | 2019-10-22T14:38:04 | 2019-10-22T14:38:04 | 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 | 2570 41ST AVE, SAN FRANCISCO, CA, 94116 | 41ST AVE | 4 | Outer Sunset | TARAVAL | 37.7388137 | -122.49878170000001 | POINT (-122.4987817 37.7388137) | Web | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 29,491 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | |||||||||||||
| 1319 | 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 | ||||||||||||||
| 1326 | 1326 | 1326 | 11249723 | 2019-08-09T15:02:00 | 2019-10-22T10:49:45 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 111 CHESTNUT ST, SAN FRANCISCO, CA, 94133 | CHESTNUT ST | 3 | Telegraph Hill | CENTRAL | 37.804584503174 | -122.405570983887 | POINT (-122.40557098 37.8045845) | Phone | 18 | 6 | 3 | 23 | 10 | 3 | 1 | 28,860 | 1 | 23 | 23 | 18 | 3 | 1 | 18 | ||||||||||||||
| 1327 | 1327 | 1327 | 11255860 | 2019-08-11T09:45:00 | 2019-10-22T11:48:57 | 2019-10-22T11:48:57 | Closed 2 | we MIGHT be able to prune it for sidewalk clearance but virtually nothing can be done about fruit. do not touch tree, stand by. will address in future keymap | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 535 LAKEVIEW AVE, SAN FRANCISCO, CA, 94112 | LAKEVIEW AVE | 11 | Oceanview | TARAVAL | 37.718143463135 | -122.454864501953 | POINT (-122.4548645 37.71814346) | Phone | 81 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 81 | 1 | 2 | 81 | |||||||||||||
| 1329 | 1329 | 1329 | 11281111 | 2019-08-16T13:26:00 | 2019-10-22T14:44:19 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 128 STANYAN BLVD, SAN FRANCISCO, CA, 94118 | STANYAN BLVD | 1 | Lone Mountain | PARK | 37.779289245605 | -122.455360412598 | POINT (-122.45536041 37.77928925) | Phone | 12 | 7 | 4 | 18 | 2 | 15 | 9 | 54 | 6 | 16 | 16 | 12 | 4 | 1 | 12 | ||||||||||||||
| 1339 | 1339 | 1339 | 11354221 | 2019-09-01T13:13:00 | 2019-10-22T11:21:10 | 2019-10-22T11:21:10 | Closed 2 | sent for contract prune 2 month lead time | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 170 STAPLES AVE, SAN FRANCISCO, CA, 94112 | STAPLES AVE | 7 | Sunnyside | INGLESIDE | 37.729116417503 | -122.445896817485 | POINT (-122.44589682 37.72911642) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11354221/photos | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 28,861 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | ||||||||||||
| 1343 | 1343 | 1343 | 11368089 | 2019-09-04T12:29:00 | 2019-10-22T22:10:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | 1985 ELLIS ST, SAN FRANCISCO, CA, 94115 | ELLIS ST | 5 | Western Addition | NORTHERN | 37.781436920166 | -122.43878173828101 | POINT (-122.43878174 37.78143692) | Phone | 97 | 4 | 11 | 39 | 11 | 15 | 8 | 29,490 | 5 | 41 | 41 | 97 | 11 | 2 | 97 | ||||||||||||||
| 1348 | 1348 | 1348 | 11371783 | 2019-09-05T08:50:00 | 2019-10-22T14:38:46 | 2019-10-22T14:38:46 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2163 39TH AVE, SAN FRANCISCO, CA, 94116 | 39TH AVE | 4 | Outer Sunset | TARAVAL | 37.746556894889004 | -122.497386261935 | POINT (-122.49738626 37.74655689) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11371783/photos | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 29,491 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | |||||||||||||
| 1377 | 1377 | 1377 | 11462375 | 2019-09-25T06:11:00 | 2019-10-22T14:24:53 | 2019-10-22T14:24:53 | 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 | 165 PAGE ST, SAN FRANCISCO, CA, 94102 | PAGE ST | 5 | Lower Haight | NORTHERN | 37.773788333333 | -122.42353 | POINT (-122.42353 37.77378833) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11462375/photos | 26 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 26 | 11 | 1 | 26 | ||||||||||||
| 1525 | 1525 | 1525 | 11229658 | 2019-08-05T14:35:00 | 2019-10-09T10:24:38 | 2019-10-09T10:24:38 | 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 | Other_enter_additional_details_below | Intersection of 46TH AVE and TARAVAL ST | 46TH AVE | 4 | Outer Sunset | TARAVAL | 37.741764068604 | -122.504623413086 | POINT (-122.50462341 37.74176407) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 29,491 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | |||||||||||||
| 1537 | 1537 | 1537 | 11242074 | 2019-08-08T07:48:00 | 2019-10-16T13:09:47 | 2019-10-16T13:09:47 | Closed 2 | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 423 MOUNT VERNON AVE, SAN FRANCISCO, CA, 94112 | MOUNT VERNON AVE | 11 | Oceanview | TARAVAL | 37.718311026790005 | -122.44877021076701 | POINT (-122.44877021 37.71831103) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11242074/photos | 81 | 10 | 1 | 24 | 6 | 9 | 5 | 28,861 | 8 | 24 | 24 | 81 | 1 | 2 | 81 | |||||||||||||
| 1541 | 1541 | 1541 | 11269996 | 2019-08-14T09:51:22 | 2019-10-07T13:30:26 | 2019-10-07T13:30:26 | Closed 2 | it appears someone recently pruned the tree | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 4166 20TH ST, SAN FRANCISCO, CA, 94114 | 20TH ST | 8 | Eureka Valley | MISSION | 37.757901462241 | -122.434040584628 | POINT (-122.43404058 37.75790146) | Mobile/Open311 | 115 | 3 | 5 | 5 | 5 | 2 | 7 | 28,862 | 4 | 3 | 3 | 115 | 5 | 1 | 5 | 115 | ||||||||||||
| 1568 | 1568 | 1568 | 11304398 | 2019-08-21T15:07:00 | 2019-10-11T15:58:46 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 154 NEWMAN ST, SAN FRANCISCO, CA, 94110 | NEWMAN ST | 9 | Holly Park | INGLESIDE | 37.737617492676 | -122.417091369629 | POINT (-122.41709137 37.73761749) | Phone | 61 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 61 | 2 | 1 | 61 | ||||||||||||||
| 1576 | 1576 | 1576 | 11560440 | 2019-10-16T17:06:00 | 2019-10-22T14:14:11 | 2019-10-22T14:14:11 | 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 | 700 DIVISADERO ST, SAN FRANCISCO, CA, 94117 | DIVISADERO ST | 5 | Alamo Square | NORTHERN | 37.775891676989005 | -122.437853438792 | POINT (-122.43785344 37.77589168) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11560440/photos | 23 | 4 | 11 | 9 | 11 | 15 | 8 | 29,492 | 5 | 10 | 10 | 23 | 11 | 1 | 23 | ||||||||||||
| 1700 | 1700 | 1700 | 10924592 | 2019-05-29T12:33:00 | 2019-06-10T15:46:10 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 713 SHRADER ST, SAN FRANCISCO, CA, 94117 | SHRADER ST | 5 | Cole Valley | PARK | 37.768146514893 | -122.45178985595699 | POINT (-122.45178986 37.76814651) | Phone | 29 | 7 | 11 | 3 | 11 | 15 | 8 | 29,492 | 5 | 9 | 9 | 29 | 11 | 1 | 29 | ||||||||||||||
| 1712 | 1712 | 1712 | 11419283 | 2019-09-15T14:37:00 | 2019-10-07T17:44:00 | 2019-10-07T17:44:00 | Closed 2 | According to DPW, this is private property. | 311 Supervisor Queue 5 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 1433 INNES AVE, SAN FRANCISCO, CA, 94124 | INNES AVE | 10 | Bayview | BAYVIEW | 37.737487792969 | -122.385726928711 | POINT (-122.38572693 37.73748779) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | |||||||||||||
| 1968 | 1968 | 1968 | 5678617 | 2016-03-18T14:03:32 | 2016-06-21T03:05:52 | 2016-06-21T03:05:52 | Closed 2 | it was relinqished in 2015 and deemed to be acceptable | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Restake_tree | 695 MONTEREY BLVD, SAN FRANCISCO, CA, 94127 | MONTEREY BLVD | 7 | Sunnyside | INGLESIDE | 37.731365792993 | -122.450866911647 | POINT (-122.45086691 37.73136579) | Phone | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | |||||||||||||
| 2089 | 2089 | 2089 | 5678091 | 2016-03-18T11:47:34 | 2016-03-23T12:22:00 | 2016-03-23T12:22:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Restake_tree | 409 18TH AVE, SAN FRANCISCO, CA, 94121 | 18TH AVE | 1 | Inner Richmond | RICHMOND | 37.780116158056 | -122.47739167597099 | POINT (-122.47739168 37.78011616) | Phone | 5 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 5 | 4 | 22 | 1 | 5 | |||||||||||||
| 2092 | 2092 | 2092 | 11486922 | 2019-09-30T16:42:00 | 2019-10-07T07:43:27 | Open 1 | sent | RPD TMA Queue 6 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 233 MELROSE AVE, SAN FRANCISCO, CA, 94127 | MELROSE AVE | 7 | Sunnyside | INGLESIDE | 37.733641666667 | -122.447616666667 | POINT (-122.44761667 37.73364167) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11486922/photos | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | |||||||||||||
| 2131 | 2131 | 2131 | 11488495 | 2019-10-01T07:56:24 | 2019-10-07T10:31:44 | 2019-10-07T10:31:44 | Closed 2 | duplicate | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2435 16TH ST, SAN FRANCISCO, CA, 94103 | 16TH ST | 9 | Mission | MISSION | 37.765649864850005 | -122.410945382881 | POINT (-122.41094538 37.76564986) | Web | http://mobile311.sfgov.org/reports/11488495/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,853 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||
| 2161 | 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 | |||||||||||||
| 2533 | 2533 | 2533 | 11501688 | 2019-10-03T17:14:41 | 2019-10-07T09:26:29 | 2019-10-07T09:26:29 | Closed 2 | what is this request for? e-mailed constituent | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1294 VALLEJO ST, SAN FRANCISCO, CA, 94109 | VALLEJO ST | 3 | Russian Hill | CENTRAL | 37.797388 | -122.41854 | POINT (-122.41854 37.797388) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11501688/photos | 107 | 6 | 3 | 32 | 10 | 5 | 1 | 28,858 | 1 | 32 | 32 | 107 | 3 | 1 | 107 | ||||||||||||
| 2598 | 2598 | 2598 | 11503095 | 2019-10-04T07:53:00 | 2019-10-07T07:47:02 | 2019-10-07T07:47:02 | Closed 2 | Should be routed to 311 Call Center | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 473 CAPP ST, SAN FRANCISCO, CA, 94110 | CAPP ST | 9 | Mission | MISSION | 37.759106 | -122.41794099999998 | POINT (-122.417941 37.759106) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11503095/photos | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 13 | 53 | 2 | 15 | 3 | 15 | 2 | 3 | 53 | |||||||
| 2630 | 2630 | 2630 | 11503609 | 2019-10-04T09:11:08 | 2019-10-07T10:32:10 | 2019-10-07T10:32:10 | Closed 2 | duplicate | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2435 16TH ST, SAN FRANCISCO, CA, 94103 | 16TH ST | 9 | Mission | MISSION | 37.765671068307 | -122.410897103119 | POINT (-122.4108971 37.76567107) | Web | http://mobile311.sfgov.org/reports/11503609/photos | 53 | 3 | 2 | 20 | 7 | 8 | 7 | 28,853 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||
| 2998 | 2998 | 2998 | 11509292 | 2019-10-05T13:11:46 | 2019-10-07T12:45:39 | 2019-10-07T12:45:39 | Closed 2 | contacted property owner who is responsible | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1 FRANKLIN ST, SAN FRANCISCO, CA, 94102 | FRANKLIN ST | 5 | Civic Center | NORTHERN | 37.774400185043 | -122.42094753614401 | POINT (-122.42094754 37.77440019) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11509292/photos | 21 | 4 | 11 | 9 | 11 | 7 | 6 | 28,852 | 9 | 10 | 10 | 21 | 1 | 11 | 1 | 8 | 1 | 1 | 1 | 21 | |||||||
| 3041 | 3041 | 3041 | 11581187 | 2019-10-21T14:20:00 | 2019-10-22T06:57:54 | 2019-10-22T06:57:54 | 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 | 569 25TH AVE, SAN FRANCISCO, CA, 94121 | 25TH AVE | 1 | Outer Richmond | RICHMOND | 37.778759002686 | -122.48477935791 | POINT (-122.48477936 37.778759) | Phone | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 1 | 8 | |||||||||||||
| 3077 | 3077 | 3077 | 11581323 | 2019-10-21T14:40:00 | 2019-10-22T08:35:23 | 2019-10-22T08:35:23 | Closed 2 | I have a pave over request can you email me at Susan.Nawbary@sfdpw.org and tell me who sent the letter | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Backfill_tree_basin | 54 RAE AVE, SAN FRANCISCO, CA, 94112 | RAE AVE | 11 | Outer Mission | INGLESIDE | 37.712173461914 | -122.448135375977 | POINT (-122.44813538 37.71217346) | Phone | 66 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 66 | 1 | 2 | 66 | |||||||||||||
| 3113 | 3113 | 3113 | 11510348 | 2019-10-05T17:36:32 | 2019-10-07T09:18:56 | 2019-10-07T09:18:56 | Closed 2 | pruning scheduled for this year. grid 007 Notes:pruning request . BUF Action:Inspect. date completed - 10/7/2019. | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 855 SACRAMENTO ST, SAN FRANCISCO, CA, 94108 | SACRAMENTO ST | 3 | Chinatown | CENTRAL | 37.793231 | -122.406922 | POINT (-122.406922 37.793231) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11510348/photos | 104 | 6 | 3 | 6 | 10 | 3 | 1 | 28,857 | 1 | 4 | 4 | 5 | 104 | 3 | 5 | 5 | 2 | 104 | |||||||||
| 3744 | 3744 | 3744 | 11583314 | 2019-10-22T05:06:00 | 2019-10-22T05:40:41 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2542 JUDAH ST, SAN FRANCISCO, CA, 94122 | JUDAH ST | 4 | Outer Sunset | TARAVAL | 37.761207756875 | -122.489307675015 | POINT (-122.48930768 37.76120776) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11583314/photos | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | |||||||||||||
| 3798 | 3798 | 3798 | 11514506 | 2019-10-07T00:22:48 | 2019-10-07T00:30:15 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 112 MONTCALM ST, SAN FRANCISCO, CA, 94110 | MONTCALM ST | 9 | Peralta Heights | INGLESIDE | 37.746482 | -122.4071608 | POINT (-122.4071608 37.746482) | Web | 60 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 60 | 2 | 1 | 60 | ||||||||||||||
| 4071 | 4071 | 4071 | 11583551 | 2019-10-22T07:30:00 | 2019-10-22T08:00:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 655 STOCKTON ST, SAN FRANCISCO, CA, 94108 | STOCKTON ST | 3 | Nob Hill | CENTRAL | 37.792074269058 | -122.40760890840099 | POINT (-122.40760891 37.79207427) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11583551/photos | 16 | 6 | 3 | 21 | 10 | 5 | 1 | 28,857 | 1 | 21 | 21 | 16 | 3 | 1 | 16 | |||||||||||||
| 4273 | 4273 | 4273 | 11515551 | 2019-10-07T09:00:00 | 2019-10-15T13:27:00 | 2019-10-15T13:27:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | About_to_fall | Intersection of HEARST AVE and FOERSTER ST | HEARST AVE | 7 | Sunnyside | INGLESIDE | 37.730690002441 | -122.44886016845699 | POINT (-122.44886017 37.73069) | https://twitter.com/StvnFlngn | 95 | 9 | 8 | 41 | 4 | 9 | 4 | 28,861 | 7 | 40 | 40 | 95 | 8 | 1 | 95 | ||||||||||||||
| 4309 | 4309 | 4309 | 11515675 | 2019-10-07T09:14:00 | 2019-10-07T10:00:39 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Weeding | 3274 26TH ST, SAN FRANCISCO, CA, 94110 | 26TH ST | 9 | Mission | MISSION | 37.749320983887 | -122.41564178466801 | POINT (-122.41564178 37.74932098) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 4517 | 4517 | 4517 | 11516259 | 2019-10-07T10:26:00 | 2019-10-09T08:28:00 | 2019-10-09T08:28:00 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | 1111 GUERRERO ST, SAN FRANCISCO, CA, 94110 | GUERRERO ST | 8 | Dolores Heights | MISSION | 37.753318786621 | -122.422821044922 | POINT (-122.42282104 37.75331879) | Phone | 52 | 3 | 5 | 20 | 5 | 2 | 7 | 28,859 | 4 | 19 | 19 | 52 | 5 | 1 | 52 | ||||||||||||||
| 4677 | 4677 | 4677 | 11516785 | 2019-10-07T11:32:22 | 2019-10-07T12:15:18 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | Intersection of I-280 N OFF RAMP and SAN JOSE AVE | I-280 N OFF RAMP | 8 | St. Mary's Park | INGLESIDE | 37.733584 | -122.43149 | POINT (-122.43149 37.733584) | Mobile/Open311 | 93 | 9 | 5 | 28 | 5 | 2 | 4 | 28,861 | 7 | 25 | 25 | 93 | 5 | 1 | 93 | ||||||||||||||
| 4680 | 4680 | 4680 | 11516786 | 2019-10-07T11:32:33 | 2019-10-29T18:35:58 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of LAWTON ST and 7TH AVE | LAWTON ST | 7 | Inner Sunset | PARK | 37.758573331463 | -122.463848559636 | POINT (-122.46384856 37.75857333) | Mobile/Open311 | 109 | 7 | 8 | 14 | 4 | 1 | 8 | 56 | 5 | 12 | 12 | 109 | 8 | 1 | 109 | ||||||||||||||
| 4707 | 4707 | 4707 | 11516903 | 2019-10-07T11:45:00 | 2019-10-22T14:28:41 | 2019-10-22T14:28:41 | 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 | 396 27TH AVE, SAN FRANCISCO, CA, 94121 | 27TH AVE | 1 | Outer Richmond | RICHMOND | 37.782096176968004 | -122.487012329622 | POINT (-122.48701233 37.78209618) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11516903/photos | 8 | 8 | 4 | 29 | 2 | 11 | 9 | 55 | 6 | 26 | 26 | 8 | 4 | 2 | 8 | ||||||||||||
| 4789 | 4789 | 4789 | 11517195 | 2019-10-07T12:18:00 | 2019-10-07T12:30:21 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 238 MUNICH ST, SAN FRANCISCO, CA, 94112 | MUNICH ST | 11 | Excelsior | INGLESIDE | 37.721866607666 | -122.426239013672 | POINT (-122.42623901 37.72186661) | Phone | 90 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 90 | 1 | 2 | 90 | ||||||||||||||
| 4791 | 4791 | 4791 | 11517218 | 2019-10-07T12:21:00 | 2019-10-07T12:37:07 | 2019-10-07T12:37:07 | Closed 2 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 1434 QUESADA AVE, SAN FRANCISCO, CA, 94124 | QUESADA AVE | 10 | Bayview | BAYVIEW | 37.730659484863 | -122.38645172119101 | POINT (-122.38645172 37.73065948) | Phone | 86 | 2 | 9 | 1 | 8 | 10 | 3 | 58 | 3 | 1 | 1 | 86 | 9 | 2 | 86 | ||||||||||||||
| 4857 | 4857 | 4857 | 11517473 | 2019-10-07T12:57:00 | 2019-10-07T14:00:45 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 1948 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Cayuga | INGLESIDE | 37.721126556396 | -122.439163208008 | POINT (-122.43916321 37.72112656) | Phone | 80 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 80 | 1 | 2 | 80 | ||||||||||||||
| 4961 | 4961 | 4961 | 11517758 | 2019-10-07T13:33:17 | 2019-10-07T13:40:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1319 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 | SAN BRUNO AVE | 10 | Potrero Hill | MISSION | 37.752827 | -122.4042 | POINT (-122.4042 37.752827) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11517758/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
| 4965 | 4965 | 4965 | 11517764 | 2019-10-07T13:34:07 | 2019-10-07T13:40:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 1364 SAN BRUNO AVE, SAN FRANCISCO, CA, 94110 | SAN BRUNO AVE | 10 | Potrero Hill | MISSION | 37.752295000000004 | -122.404435 | POINT (-122.404435 37.752295) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11517764/photos | 54 | 3 | 9 | 20 | 8 | 10 | 7 | 28,859 | 4 | 19 | 19 | 23 | 54 | 9 | 10 | 10 | 1 | 54 | ||||||||||
| 4980 | 4980 | 4980 | 11517833 | 2019-10-07T13:44:00 | 2019-10-21T15:31:08 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 1750 SACRAMENTO ST, SAN FRANCISCO, CA, 94109 | SACRAMENTO ST | 3 | Polk Gulch | NORTHERN | 37.791500091553004 | -122.42172241210899 | POINT (-122.42172241 37.79150009) | Phone | 105 | 4 | 3 | 21 | 10 | 13 | 6 | 28,858 | 9 | 21 | 21 | 105 | 3 | 1 | 105 | ||||||||||||||
| 5093 | 5093 | 5093 | 11584425 | 2019-10-22T09:31:00 | 2019-10-22T09:40:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Near_communication_line | 1528 HAMPSHIRE ST, SAN FRANCISCO, CA, 94110 | HAMPSHIRE ST | 9 | Peralta Heights | INGLESIDE | 37.748329162598 | -122.406639099121 | POINT (-122.4066391 37.74832916) | Phone | 60 | 9 | 2 | 2 | 7 | 2 | 4 | 28,859 | 7 | 2 | 2 | 60 | 2 | 1 | 60 | ||||||||||||||
| 5155 | 5155 | 5155 | 11518419 | 2019-10-07T15:09:00 | 2019-10-07T16:00:35 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Landscaping 5 | Other | 1370 GUERRERO ST, SAN FRANCISCO, CA, 94110 | GUERRERO ST | 8 | Dolores Heights | MISSION | 37.749153137206996 | -122.42276763916 | POINT (-122.42276764 37.74915314) | Phone | 52 | 3 | 5 | 20 | 5 | 2 | 7 | 28,859 | 4 | 19 | 19 | 52 | 5 | 1 | 52 | ||||||||||||||
| 5175 | 5175 | 5175 | 11584535 | 2019-10-22T09:48:01 | 2019-10-22T09:55:42 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | Intersection of 24TH ST and MASSACHUSETTS ST | 24TH ST | 10 | Central Waterfront | BAYVIEW | 37.755224363277 | -122.381316852064 | POINT (-122.38131685 37.75522436) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11584535/photos | 56 | 2 | 9 | 26 | 8 | 3 | 28,856 | 3 | 29 | 29 | 56 | 9 | 1 | 56 | ||||||||||||||
| 5221 | 5221 | 5221 | 11518643 | 2019-10-07T15:38:00 | 2019-10-07T15:50:17 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Lifted_sidewalk_tree_roots | 224 HARVARD ST, SAN FRANCISCO, CA, 94134 | HARVARD ST | 9 | University Mound | INGLESIDE | 37.726715087891 | -122.420829772949 | POINT (-122.42082977 37.72671509) | Phone | 92 | 9 | 2 | 7 | 7 | 9 | 4 | 309 | 7 | 5 | 5 | 92 | 2 | 2 | 92 | ||||||||||||||
| 5234 | 5234 | 5234 | 11584627 | 2019-10-22T10:04:00 | 2019-10-22T11:15:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Hitting_window_or_building | 785 BRANNAN ST, SAN FRANCISCO, CA, 94103 | BRANNAN ST | 6 | South of Market | SOUTHERN | 37.77318572998 | -122.402534484863 | POINT (-122.40253448 37.77318573) | Phone | 32 | 1 | 10 | 34 | 9 | 14 | 2 | 28,853 | 2 | 34 | 34 | 32 | 10 | 2 | 32 | ||||||||||||||
| 5288 | 5288 | 5288 | 11518880 | 2019-10-07T16:15:00 | 2019-10-20T12:04:28 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 3458 26TH ST, SAN FRANCISCO, CA, 94110 | 26TH ST | 9 | Mission | MISSION | 37.749080657959 | -122.419692993164 | POINT (-122.41969299 37.74908066) | Phone | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 53 | 2 | 3 | 2 | 3 | 53 | ||||||||||||
| 5307 | 5307 | 5307 | 11584772 | 2019-10-22T10:27:00 | 2019-10-22T10:39:52 | Open 1 | open | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 3098 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 | CALIFORNIA ST | 2 | Pacific Heights | RICHMOND | 37.787593841553004 | -122.44519805908199 | POINT (-122.44519806 37.78759384) | Phone | 102 | 8 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 102 | 6 | 1 | 102 | ||||||||||||||
| 5352 | 5352 | 5352 | 11519156 | 2019-10-07T16:58:00 | 2019-10-07T17:35:50 | 2019-10-07T17:35:50 | Closed 2 | 10/98 | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Fallen_tree | Intersection of DELTA ST and LELAND AVE | DELTA ST | 10 | Visitacion Valley | INGLESIDE | 37.71312713623 | -122.409492492676 | POINT (-122.40949249 37.71312714) | Phone | 75 | 9 | 9 | 40 | 8 | 9 | 4 | 309 | 7 | 39 | 39 | 75 | 9 | 2 | 75 | |||||||||||||
| 5384 | 5384 | 5384 | 11585037 | 2019-10-22T11:06:00 | 2019-10-22T12:10:42 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Landscaping 5 | Sprinkler_system_issues | Intersection of SUNSET BLVD and MORAGA ST | SUNSET BLVD | 4 | Outer Sunset | TARAVAL | 37.755275726318004 | -122.495361328125 | POINT (-122.49536133 37.75527573) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 5392 | 5392 | 5392 | 11519264 | 2019-10-07T17:24:00 | 2019-10-07T17:35:16 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Blocking_sidewalk | 1254 41ST AVE, SAN FRANCISCO, CA, 94122 | 41ST AVE | 4 | Outer Sunset | TARAVAL | 37.763362884521 | -122.500595092773 | POINT (-122.50059509 37.76336288) | Phone | 39 | 10 | 7 | 35 | 3 | 1 | 5 | 56 | 8 | 35 | 35 | 39 | 7 | 1 | 39 | ||||||||||||||
| 5455 | 5455 | 5455 | 11585234 | 2019-10-22T11:37:00 | 2019-10-22T11:45:56 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | 51 MARNE AVE, SAN FRANCISCO, CA, 94127 | MARNE AVE | 7 | Sherwood Forest | INGLESIDE | 37.739490509033 | -122.45892333984399 | POINT (-122.45892334 37.73949051) | Phone | 117 | 9 | 8 | 41 | 4 | 9 | 4 | 59 | 7 | 40 | 40 | 117 | 8 | 1 | 117 | ||||||||||||||
| 5501 | 5501 | 5501 | 11585356 | 2019-10-22T11:53:04 | 2019-10-22T13:00:44 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2600 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 | SACRAMENTO ST | 2 | Pacific Heights | NORTHERN | 37.789680343652 | -122.435752728243 | POINT (-122.43575273 37.78968034) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11585356/photos | 102 | 4 | 6 | 30 | 1 | 13 | 6 | 29,490 | 9 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
| 5504 | 5504 | 5504 | 11585373 | 2019-10-22T11:55:00 | 2019-10-22T15:08:32 | Open 1 | accepted | DPW BUF Queue 2 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 2603 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 | SACRAMENTO ST | 2 | Pacific Heights | NORTHERN | 37.789539033009994 | -122.435863326343 | POINT (-122.43586333 37.78953903) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11585373/photos | 102 | 4 | 6 | 30 | 1 | 13 | 9 | 29,490 | 6 | 27 | 27 | 102 | 6 | 1 | 102 | |||||||||||||
| 5563 | 5563 | 5563 | 11519734 | 2019-10-07T19:18:00 | 2019-10-23T11:17:30 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaging_Property 2 | Property_damage | 1419 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 | ALEMANY BLVD | 11 | Mission Terrace | INGLESIDE | 37.729068299999994 | -122.43395670000001 | POINT (-122.4339567 37.7290683) | Web | http://mobile311.sfgov.org/reports/11519734/photos | 94 | 9 | 1 | 28 | 6 | 9 | 4 | 28,861 | 7 | 25 | 25 | 94 | 1 | 1 | 94 | |||||||||||||
| 5610 | 5610 | 5610 | 11585580 | 2019-10-22T12:28:00 | 2019-10-22T12:35:47 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Dead_tree | Intersection of BAY ST and DIVISADERO ST | BAY ST | 2 | Marina | NORTHERN | 37.801837921143 | -122.443222045898 | POINT (-122.44322205 37.80183792) | Phone | 17 | 4 | 6 | 13 | 1 | 13 | 6 | 57 | 9 | 17 | 17 | 17 | 6 | 1 | 17 | ||||||||||||||
| 5611 | 5611 | 5611 | 11519949 | 2019-10-07T20:52:32 | 2019-10-07T21:00:22 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 384 ALLISON ST, SAN FRANCISCO, CA, 94112 | ALLISON ST | 11 | Crocker Amazon | INGLESIDE | 37.710160242440004 | -122.440802441367 | POINT (-122.44080244 37.71016024) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11519949/photos | 58 | 9 | 1 | 7 | 6 | 9 | 4 | 28,861 | 7 | 5 | 5 | 58 | 1 | 2 | 58 | |||||||||||||
| 5773 | 5773 | 5773 | 11586288 | 2019-10-22T14:09:00 | 2019-10-22T14:20:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Damaged_Tree 1 | Damaged_vandalism | 2755 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 | SAN BRUNO AVE | 9 | Portola | BAYVIEW | 37.726974487305 | -122.403160095215 | POINT (-122.4031601 37.72697449) | Phone | 91 | 2 | 2 | 25 | 7 | 10 | 3 | 309 | 3 | 28 | 28 | 91 | 2 | 4 | 2 | 91 | |||||||||||||
| 5826 | 5826 | 5826 | 11586668 | 2019-10-22T15:11:41 | 2019-10-22T15:55:43 | Open 1 | accepted | DPW Ops Queue 1 | Tree Maintenance 1 | Trees - Overgrown_Tree 3 | Pruning_request | 1930 15TH ST, SAN FRANCISCO, CA, 94114 | 15TH ST | 8 | Mission Dolores | MISSION | 37.766420700000005 | -122.4271957 | POINT (-122.4271957 37.7664207) | Mobile/Open311 | http://mobile311.sfgov.org/reports/11586668/photos | 37 | 3 | 5 | 5 | 5 | 8 | 7 | 28,862 | 4 | 3 | 3 | 37 | 5 | 1 | 5 | 37 | ||||||||||||
| 6146 | 6146 | 6146 | 11525260 | 2019-10-08T21:43:00 | 2019-10-09T00:38:14 | Open 1 | sent | DPH - Other - G 7 | Tree Maintenance 1 | Trees - Tree_Other 4 | Other | 3310 19TH ST, SAN FRANCISCO, CA, 94110 | 19TH ST | 9 | Mission | MISSION | 37.760490399999995 | -122.4173226 | POINT (-122.4173226 37.7604904) | Web | 53 | 3 | 2 | 20 | 7 | 2 | 7 | 28,859 | 4 | 19 | 19 | 13 | 53 | 2 | 15 | 3 | 15 | 2 | 3 | 53 |
JSON shape: default, array, newline-delimited
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))