calls

7,158 rows where Responsible_Agency = 2 sorted by Request_Details

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
1816281 1816281 3597583 2014-04-29T16:25:44   2014-04-29T20:50:14 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   2929 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Eureka Valley MISSION 37.760954999999996 -122.44039699999999 POINT (-122.440397 37.760955) Mobile/Open311   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1834610 1834610 3662360 2014-05-21T02:48:58   2014-05-21T06:46:04 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of SPARROW ST and VALENCIA ST SPARROW ST 8 Mission MISSION 37.765927137842 -122.42198752250799 POINT (-122.42198752 37.76592714) Mobile/Open311 http://mobile311.sfgov.org/reports/3662360/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1851217 1851217 3662368 2014-05-21T03:10:33   2014-05-21T06:59:12 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 14TH ST and VALENCIA ST 14TH ST 8 Mission Dolores MISSION 37.768293641497 -122.42229312681002 POINT (-122.42229313 37.76829364) Mobile/Open311 http://mobile311.sfgov.org/reports/3662368/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1865744 1865744 3433703 2014-03-07T14:35:17 2016-04-11T05:10:34 2016-04-11T05:10:34 Closed 2 called Rec & Park----Rochelle DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   105 CRESTLAKE DR, SAN FRANCISCO, CA, 94132 CRESTLAKE DR 4 Parkside TARAVAL 37.735323384439 -122.482604188959 POINT (-122.48260419 37.73532338) Mobile/Open311   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
1878055 1878055 3662362 2014-05-21T02:58:42 2014-06-09T04:35:00 2014-06-09T04:35:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   395 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 9 Mission MISSION 37.766855935555 -122.422100678313 POINT (-122.42210068 37.76685594) Mobile/Open311 http://mobile311.sfgov.org/reports/3662362/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1898543 1898543 3662369 2014-05-21T03:12:12   2014-05-21T08:12:23 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   410 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 8 Mission Dolores MISSION 37.768393386144 -122.42228399053499 POINT (-122.42228399 37.76839339) Mobile/Open311 http://mobile311.sfgov.org/reports/3662369/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
1911034 1911034 3662381 2014-05-21T03:47:33 2014-06-26T12:00:00 2014-06-26T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " Notes:No dg needed . BUF Action:INSPECT. date completed - 6/26/2014. ". DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4   3106 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 8 Mission Dolores MISSION 37.765264337870995 -122.42195634193999 POINT (-122.42195634 37.76526434) Mobile/Open311 http://mobile311.sfgov.org/reports/3662381/photos 37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
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
20043 20043 5651319 2016-03-10T09:12:49 2016-04-26T02:42:42 2016-04-26T02:42:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
32051 32051 11609326 2019-10-27T15:44:00 2019-10-28T09:22:56 2019-10-30T07:00:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1421 10TH AVE, SAN FRANCISCO, CA, 94122 10TH AVE 7 Inner Sunset TARAVAL 37.761684417725 -122.46736145019501 POINT (-122.46736145 37.76168442) Phone   109 10 8 14 4 1 5 56 8 12 12   109   8             1         109
76446 76446 11478941 2019-09-28T17:27:00 2019-10-01T09:01:00 2019-10-01T09:01:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of LAGUNA ST and LINDEN ST LAGUNA ST 5 Hayes Valley NORTHERN 37.775997161865 -122.426170349121 POINT (-122.42617035 37.77599716) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
90482 90482 9799004 2018-11-12T14:55:00 2019-01-04T13:55:58 2019-01-04T13:55:58 Closed 2 No Hazard seen DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1291 ARGUELLO BLVD, SAN FRANCISCO, CA, 94122 ARGUELLO BLVD 5 Inner Sunset PARK 37.764656066895 -122.457901000977 POINT (-122.457901 37.76465607) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
93414 93414 9736666 2018-10-29T13:28:00 2019-01-04T14:10:49 2019-01-04T14:10:49 Closed 2 not a hazard - 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 y DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 200 ARGUELLO BLVD, SAN FRANCISCO, CA, 94118 ARGUELLO BLVD 2 Presidio Heights RICHMOND 37.786479949951 -122.459037780762 POINT (-122.45903778 37.78647995) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
96734 96734 11608299 2019-10-27T11:46:00 2019-10-28T09:48:48 2019-10-28T10:40:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1951 44TH AVE, SAN FRANCISCO, CA, 94116 44TH AVE 4 Outer Sunset TARAVAL 37.750221252441 -122.503204345703 POINT (-122.50320435 37.75022125) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
123656 123656 4468308 2015-02-06T22:29:19 2015-02-09T09:56:00 2015-02-09T09:56:00 Closed 2 resolved: removed down limbs DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 522 HAYES ST, SAN FRANCISCO, CA, 94102 HAYES ST 5 Hayes Valley NORTHERN 37.776744929944 -122.42515827663601 POINT (-122.42515828 37.77674493) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
129899 129899 5552071 2016-02-09T14:54:26 2016-02-13T05:32:00 2016-02-13T05:32:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 875 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Hayes Valley NORTHERN 37.777709937261 -122.431153191247 POINT (-122.43115319 37.77770994) Phone   22 4 11 9 11 7 6 29,492 9 10 10   22   11             1         22
130242 130242 5519502 2016-01-30T16:29:50 2016-02-25T08:20:44 2016-02-25T08:20:44 Closed 2 Cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 137 ANZAVISTA AVE, SAN FRANCISCO, CA, 94115 ANZAVISTA AVE 2 Anza Vista PARK 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
131112 131112 5438420 2016-01-06T12:29:35 2016-01-07T07:31:00 2016-01-07T07:31:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2480 WASHINGTON ST, SAN FRANCISCO, CA, 94115 WASHINGTON ST 2 Pacific Heights NORTHERN 37.791727526977 -122.43416576698601 POINT (-122.43416577 37.79172753) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
131533 131533 5400616 2015-12-23T17:36:55 2016-01-05T01:38:00 2016-01-05T01:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 155 DWIGHT ST, SAN FRANCISCO, CA, 94134 DWIGHT ST 9 Portola BAYVIEW 37.723461151123 -122.403861999512 POINT (-122.403862 37.72346115) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
133486 133486 5364202 2015-12-10T19:12:43 2015-12-11T03:03:52 2015-12-11T03:03:52 Closed 2 cancelled: Tree needs restake DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of JUNIPERO SERRA BLVD and WINSTON DR JUNIPERO SERRA BLVD 7 Stonestown TARAVAL 37.726818465302 -122.47238026639299 POINT (-122.47238027 37.72681847) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
136891 136891 5015589 2015-08-19T21:21:14 2015-12-18T12:17:55 2015-12-18T12:17:55 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 698 BUSH ST, SAN FRANCISCO, CA, 94108 BUSH ST 3 Nob Hill CENTRAL 37.790293425468 -122.408555640716 POINT (-122.40855564 37.79029343) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
138487 138487 4868227 2015-06-30T13:59:35 2015-07-02T12:24:00 2015-07-02T12:24:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2502 CLAY ST, SAN FRANCISCO, CA, 94115 CLAY ST 2 Pacific Heights NORTHERN 37.790815982665 -122.434474320964 POINT (-122.43447432 37.79081598) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
141295 141295 4631109 2015-04-02T13:55:56 2015-05-15T07:50:09 2015-05-15T07:50:09 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 615 UNION ST, SAN FRANCISCO, CA, 94133 UNION ST 3 North Beach CENTRAL 37.800277709961 -122.40948486328101 POINT (-122.40948486 37.80027771) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
142530 142530 4529791 2015-02-27T10:45:32 2015-02-27T14:49:29 2015-02-27T14:49:29 Closed 2 resolved: made safe for the night their arborist is coming tomorrow DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 208 FAIR OAKS ST, SAN FRANCISCO, CA, 94110 FAIR OAKS ST 8 Dolores Heights MISSION 37.753081147935 -122.42425793855699 POINT (-122.42425794 37.75308115) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
142949 142949 4498449 2015-02-16T17:41:32 2015-03-24T03:19:00 2015-03-24T03:19:00 Closed 2 resolved: removed hanger DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of OAKHURST LN and OAK PARK DR OAKHURST LN 7 Forest Knolls PARK 37.757080139405 -122.46062433276899 POINT (-122.46062433 37.75708014) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
144940 144940 4345194 2014-12-30T08:22:45 2015-01-09T08:20:27 2015-01-09T08:20:27 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 430 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.799051432179 -122.40816110406999 POINT (-122.4081611 37.79905143) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
199191 199191 9125192 2018-06-12T07:22:00 2018-12-04T07:46:32 2018-12-04T07:46:32 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of GRAFTON AVE and PLYMOUTH AVE GRAFTON AVE 11 Ingleside TARAVAL 37.720031738281 -122.45613098144501 POINT (-122.45613098 37.72003174) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
265265 265265 9350436 2018-08-02T12:31:00 2019-05-17T09:50:03 2019-05-17T09:50:03 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 52 CLARENDON AVE, SAN FRANCISCO, CA, 94114 CLARENDON AVE 5 Ashbury Heights PARK 37.75891494751 -122.4501953125 POINT (-122.45019531 37.75891495) Phone   114 7 11 14 11 15 8 28,862 5 12 12   114   11             1         114
499995 499995 10353473 2019-01-14T07:43:00 2019-02-12T07:39:09 2019-02-12T07:39:09 Closed 2 Due to the implementation of Prop-E, resources are being focused into priority 1 and priority 2 tree pruning requests as identified in the recent tree census. A block pruning plan is in place for all of San Francisco and maintenance of your tree will take place under these scheduled routes. Your tree will be addressed at a later date under this scheduled maintenance plan. Thank you for your patie DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 255 SAN MARCOS AVE, SAN FRANCISCO, CA, 94116 SAN MARCOS AVE 7 Forest Hill TARAVAL 37.746379852295 -122.466270446777 POINT (-122.46627045 37.74637985) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
513252 513252 9818157 2018-11-16T15:21:00 2018-11-26T09:41:47 2018-11-26T09:41:47 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of LINCOLN WAY and 28TH AVE LINCOLN WAY 4 Golden Gate Park TARAVAL 37.765018463135 -122.48690032959 POINT (-122.48690033 37.76501846) Phone   9 10 7 35 3 1 5 56 8 35 35   9   7             1         9
515753 515753 10304913 2019-01-02T11:04:00 2019-01-02T13:48:33 2019-01-02T13:48:33 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3579 JACKSON ST, SAN FRANCISCO, CA, 94118 JACKSON ST 2 Presidio Heights RICHMOND 37.789878845215 -122.45368957519501 POINT (-122.45368958 37.78987885) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
550192 550192 10333778 2019-01-09T07:43:00 2019-01-10T12:03:08 2019-01-10T12:03:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of GUERRERO ST and 22ND ST GUERRERO ST 8 Dolores Heights MISSION 37.755168914795 -122.423179626465 POINT (-122.42317963 37.75516891) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
551636 551636 9979277 2018-12-26T17:38:00 2019-04-06T10:56:18 2019-04-06T10:56:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2050 KIRKHAM ST, SAN FRANCISCO, CA, 94122 KIRKHAM ST 4 Outer Sunset TARAVAL 37.759689331055 -122.483139038086 POINT (-122.48313904 37.75968933) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
570192 570192 10512726 2019-02-20T14:40:00 2019-03-07T09:22:00 2019-03-07T09:22:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of GORHAM ST and CAYUGA AVE GORHAM ST 8 Mission Terrace INGLESIDE 37.730228424071996 -122.434219360352 POINT (-122.43421936 37.73022842) Phone   94 9 5 28 5 9 4 28,861 7 25 25   94   5             1         94
580194 580194 10740137 2019-04-17T08:39:00 2019-05-07T14:22:13 2019-05-07T14:22:13 Closed 2 Should be routed to 311 Call Center DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 640 FRANCISCO ST, SAN FRANCISCO, CA, 94133 FRANCISCO ST 3 North Beach CENTRAL 37.804882049561 -122.41590118408199 POINT (-122.41590118 37.80488205) Phone   106 6 3 23 10 5 1 308 1 23 23   106   3             2         106
621551 621551 10487869 2019-02-14T08:50:00 2019-02-14T22:15:18 2019-02-14T22:15:18 Closed 2 Request is a duplicate and has been previously reported as 10487869 DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 399 THE EMBARCADERO, SAN FRANCISCO, CA, 94111 THE EMBARCADERO 3 Northern Waterfront CENTRAL 37.798337872333 -122.397495846406 POINT (-122.39749585 37.79833787) Mobile/Open311 http://mobile311.sfgov.org/reports/10487869/photos 77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
626535 626535 10500694 2019-02-17T19:19:00 2019-02-19T10:57:42 2019-02-19T10:57:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of PORTOLA DR and OSHAUGHNESSY BLVD PORTOLA DR 7 Miraloma Park INGLESIDE 37.745532989502 -122.451622009277 POINT (-122.45162201 37.74553299) Phone   72 9 5 10 5 1 4 59 7 7 7   72   5             1         72
632755 632755 10483496 2019-02-13T09:38:00 2019-02-21T10:44:00 2019-02-21T10:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 4075 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Castro PARK 37.762271881104 -122.436714172363 POINT (-122.43671417 37.76227188) Phone   38 7 5 5 5 15 8 28,862 5 3 3   38   5             1         38
637353 637353 10660847 2019-03-29T10:49:00 2019-04-02T13:19:19 2019-04-02T13:19:19 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1019 ASHBURY ST, SAN FRANCISCO, CA, 94117 ASHBURY ST 5 Ashbury Heights PARK 37.764194488525 -122.44622802734399 POINT (-122.44622803 37.76419449) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
647252 647252 10646821 2019-03-26T07:51:00 2019-04-05T14:27:28 2019-04-05T14:27:28 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 138 SCOTT ST, SAN FRANCISCO, CA, 94117 SCOTT ST 5 Lower Haight NORTHERN 37.771110534668004 -122.43514251709 POINT (-122.43514252 37.77111053) Phone   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
921057 921057 482524 2009-08-06T13:00:28 2011-03-17T12:09:54 2011-03-17T12:09:54 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3122 STEINER ST, SAN FRANCISCO, CA, 94123 STEINER ST 2 Union Street NORTHERN 37.798183441162 -122.437240600586 POINT (-122.4372406 37.79818344) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
1272204 1272204 1127980 2012-05-20T17:41:11 2013-11-20T13:34:48 2013-11-20T13:34:48 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:INSPECT. date completed - 5/23/2012. ". DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 7TH ST and MINNA ST 7TH ST 6 South of Market SOUTHERN 37.778785705566 -122.410400390625 POINT (-122.41040039 37.77878571) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1290749 1290749 1137618 2012-06-03T08:55:18   2012-06-04T10:47:48 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 21 BROMPTON AVE, SAN FRANCISCO, CA, 94131 BROMPTON AVE 8 Glen Park INGLESIDE 37.734313964844 -122.43475341796899 POINT (-122.43475342 37.73431396) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
1439655 1439655 1158633 2012-07-02T12:17:07   2012-07-02T15:34:04 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of FITZGERALD AVE and INGALLS ST FITZGERALD AVE 10 Bret Harte BAYVIEW 37.720977783203004 -122.391304016113 POINT (-122.39130402 37.72097778) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
1549407 1549407 2629262 2013-07-22T15:42:07 2013-11-20T13:47:05 2013-11-20T13:47:05 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 300 GROVE ST, SAN FRANCISCO, CA, 94102 GROVE ST 5 Civic Center NORTHERN 37.778102874755994 -122.42176055908199 POINT (-122.42176056 37.77810287) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
1917082 1917082 4373665 2015-01-08T09:24:50 2016-06-20T08:25:49 2016-06-20T08:25:49 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BAY SHORE BLVD and BACON ST BAY SHORE BLVD 10 Portola BAYVIEW 37.728103637695 -122.402206420898 POINT (-122.40220642 37.72810364) Web   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
1917158 1917158 3952461 2014-08-26T08:51:39 2014-09-05T08:12:14 2014-09-05T08:12:14 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 36TH AVE and MORAGA ST 36TH AVE 4 Outer Sunset TARAVAL 37.755300342236 -122.49482252638599 POINT (-122.49482253 37.75530034) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1918257 1918257 4271378 2014-12-04T16:59:51 2014-12-05T06:32:19 2014-12-05T06:32:19 Closed 2 resolved: private HOA trees no hazard found DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 LYNDHURST DR, SAN FRANCISCO, CA, 94132 LYNDHURST DR 7 Stonestown TARAVAL 37.724709862057 -122.47280848145901 POINT (-122.47280848 37.72470986) Phone   41 10 8 41 4 9 5 64 8 40 40   41   8             1         41
1920942 1920942 4270544 2014-12-04T14:10:09 2014-12-05T06:39:15 2014-12-05T06:39:15 Closed 2 cancelled: private not dpw maintained - No hazard found DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 8 MIDCREST WAY, SAN FRANCISCO, CA, 94131 MIDCREST WAY 7 Midtown Terrace PARK 37.747047424316 -122.44961547851601 POINT (-122.44961548 37.74704742) Web   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
1921492 1921492 3937310 2014-08-21T10:39:59 2014-08-25T06:59:51 2014-08-25T06:59:51 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 66 TOWNSEND ST, SAN FRANCISCO, CA, 94107 TOWNSEND ST 6 South Beach SOUTHERN 37.781082180783 -122.390024357376 POINT (-122.39002436 37.78108218) Phone   31 1 10 8 9 6 2 28,856 2 6 6   31   10             1         31
1924005 1924005 4242401 2014-11-25T10:11:30 2014-11-29T09:31:29 2014-11-29T09:31:29 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of CHESTNUT ST and CULEBRA TER CHESTNUT ST 2 Russian Hill NORTHERN 37.802559361285 -122.422528385491 POINT (-122.42252839 37.80255936) Phone   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
1924006 1924006 4291587 2014-12-10T22:24:14 2014-12-26T12:23:00 2014-12-26T12:23:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 130 WAYLAND ST, SAN FRANCISCO, CA, 94134 WAYLAND ST 9 Portola BAYVIEW 37.726382863494 -122.403680831795 POINT (-122.40368083 37.72638286) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
1929572 1929572 4255445 2014-11-30T16:15:42 2014-12-08T09:34:24 2014-12-08T09:34:24 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of PORTOLA DR and DEL SUR AVE PORTOLA DR 7 Miraloma Park INGLESIDE 37.742074897515 -122.45574877295601 POINT (-122.45574877 37.7420749) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
1932468 1932468 3948951 2014-08-25T09:29:42 2014-08-29T09:34:19 2014-08-29T09:34:19 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 145 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.744046970439 -122.457748246755 POINT (-122.45774825 37.74404697) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
1932927 1932927 4322868 2014-12-21T16:06:28 2014-12-23T10:35:00 2014-12-23T10:35:00 Closed 2 resolved: checked all trees on two blocks of Ingalls st and no trees are falling down some trees are growing at a nan angle but are stable and not uprooting DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of INGALLS ST and SHAFTER AVE INGALLS ST 10 Hunters Point BAYVIEW 37.727859771229 -122.38511903472799 POINT (-122.38511903 37.72785977) Phone     2 9 1 8 10 3 58 3 1 1       9             2          
1934916 1934916 4347907 2014-12-30T19:21:55 2015-01-06T10:08:04 2015-01-06T10:08:04 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of MISSOURI ST and WATCHMAN WAY MISSOURI ST 10 Potrero Hill BAYVIEW 37.755619625004 -122.39576329250299 POINT (-122.39576329 37.75561963) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
1936113 1936113 4346644 2014-12-30T13:38:32 2015-03-27T12:00:00 2015-03-27T12:00:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2780 SACRAMENTO ST, SAN FRANCISCO, CA, 94115 SACRAMENTO ST 2 Pacific Heights NORTHERN 37.789389973512996 -122.43867734161199 POINT (-122.43867734 37.78938997) Phone   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
1939646 1939646 4269363 2014-12-04T09:43:10 2014-12-06T10:20:25 2014-12-06T10:20:25 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HYDE ST and UNION ST HYDE ST 3 Russian Hill CENTRAL 37.799196142335 -122.41904872929399 POINT (-122.41904873 37.79919614) Phone   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
1941337 1941337 4347962 2014-12-30T19:37:29 2016-06-20T08:18:59 2016-06-20T08:18:59 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 255 WOODSIDE AVE, Apt 201, SAN FRANCISCO, CA, 94127 WOODSIDE AVE 7 Laguna Honda PARK 37.746574647355 -122.45523760722999 POINT (-122.45523761 37.74657465) Phone   49 7 8 38 4 1 8 59 5 38 38   49   8             1         49
1943828 1943828 4006594 2014-09-12T14:35:55 2014-09-16T06:35:00 2014-09-16T06:35:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of MONTEREY BLVD and RIDGEWOOD AVE MONTEREY BLVD 7 Westwood Park INGLESIDE 37.731529621641 -122.453413342119 POINT (-122.45341334 37.73152962) Phone   71 9 8 41 4 9 4 59 7 40 40   71   8             1         71
1949252 1949252 4347616 2014-12-30T17:38:36 2015-01-07T12:57:00 2015-01-07T12:57:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2170 BRYANT ST, SAN FRANCISCO, CA, 94110 BRYANT ST 9 Mission MISSION 37.759441269509004 -122.410181516109 POINT (-122.41018152 37.75944127) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1949553 1949553 4272482 2014-12-05T08:29:39 2014-12-16T07:35:00 2014-12-16T07:35:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 154 PORTOLA DR, SAN FRANCISCO, CA, 94131 PORTOLA DR 8 Upper Market MISSION 37.748482468638 -122.444359355645 POINT (-122.44435936 37.74848247) Phone   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
1953132 1953132 4340510 2014-12-28T16:49:28 2015-01-02T06:22:12 2015-01-02T06:22:12 Closed 2 cancelled: Private tree - not under the care and maintenance of Public Works. Please forward to property owner or Recreation and Parks. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of SEQUOIA WAY and OMAR WAY SEQUOIA WAY 7 Miraloma Park INGLESIDE 37.739277138104 -122.448701711957 POINT (-122.44870171 37.73927714) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
1956260 1956260 4192225 2014-11-09T15:25:46 2014-11-26T07:17:08 2014-11-26T07:17:08 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1 SOUTH VAN NESS AVE, SAN FRANCISCO, CA, 94103 SOUTH VAN NESS AVE 6 South of Market SOUTHERN 37.773052553763 -122.418618953459 POINT (-122.41861895 37.77305255) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1       2   1     32
1960047 1960047 4348636 2014-12-31T08:06:00 2015-01-09T07:35:00 2015-01-09T07:35:00 Closed 2 resolved: Cancel removed PRIVATE NOT DPW MAINTAINED DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1491 31ST AVE, SAN FRANCISCO, CA, 94122 31ST AVE 4 Outer Sunset TARAVAL 37.759482435728 -122.489876288242 POINT (-122.48987629 37.75948244) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1960509 1960509 4346894 2014-12-30T14:43:23 2014-12-31T06:39:00 2014-12-31T06:39:00 Closed 2 resolved: private not dpw maintained - made safe cleared bld DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1091 PORTOLA DR, SAN FRANCISCO, CA, 94127 PORTOLA DR 7 Sherwood Forest INGLESIDE 37.73984698676 -122.458568082509 POINT (-122.45856808 37.73984699) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
1962643 1962643 4281644 2014-12-08T12:10:23 2014-12-16T01:39:00 2014-12-16T01:39:00 Closed 2 resolved: Removed down tree DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 111 MONTEREY BLVD, SAN FRANCISCO, CA, 94131 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731417167772996 -122.437766822859 POINT (-122.43776682 37.73141717) Phone   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
1964560 1964560 4293785 2014-12-11T11:55:32 2014-12-17T08:50:00 2014-12-17T08:50:00 Closed 2 resolved: inspected trees and saw no unstable trees about to fall on the block DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2355 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.759623279224 -122.41470836062099 POINT (-122.41470836 37.75962328) Phone   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1965657 1965657 4348914 2014-12-31T09:06:35 2015-01-12T09:06:00 2015-01-12T09:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 315 MONTEREY BLVD, SAN FRANCISCO, CA, 94131 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.73140335083 -122.442420959473 POINT (-122.44242096 37.73140335) Phone   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
1965776 1965776 4184040 2014-11-06T16:02:41 2014-11-12T01:18:32 2014-11-12T01:18:32 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 173 EUREKA ST, SAN FRANCISCO, CA, 94114 EUREKA ST 8 Eureka Valley MISSION 37.759569259561 -122.438013296423 POINT (-122.4380133 37.75956926) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
1967101 1967101 4347357 2014-12-30T16:36:42 2015-01-02T08:05:00 2015-01-02T08:05:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of WALLER ST and CLAYTON ST WALLER ST 5 Cole Valley PARK 37.7688641039 -122.448391353759 POINT (-122.44839135 37.7688641) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
1969810 1969810 4293109 2014-12-11T10:14:38 2014-12-18T02:06:00 2014-12-18T02:06:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of COLUMBIA SQUARE ST and FOLSOM ST COLUMBIA SQUARE ST 6 South of Market SOUTHERN 37.781109888904 -122.462141270267 POINT (-122.46214127 37.78110989) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1972937 1972937 4079809 2014-10-06T09:06:06 2014-10-08T07:26:22 2014-10-08T07:26:22 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
1973387 1973387 4185330 2014-11-07T08:16:03 2014-11-29T01:43:19 2014-11-29T01:43:19 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 18TH ST and BRYANT ST 18TH ST 9 Mission MISSION 37.774826441129 -122.41848828231599 POINT (-122.41848828 37.77482644) Phone   32 5 10 20 9 8 2 28,853 2 19 19   32 1 10   14 1   8 1 2 1 1     32
1978808 1978808 4105356 2014-10-14T08:24:36 2014-10-17T10:52:22 2014-10-17T10:52:22 Closed 2 resolved: Removed hangers and down half of tree DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 777 BROTHERHOOD WAY, SAN FRANCISCO, CA, 94132 BROTHERHOOD WAY 7 Lakeshore TARAVAL 37.713424325352 -122.474341630368 POINT (-122.47434163 37.71342433) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
1981161 1981161 4295376 2014-12-11T18:09:36 2014-12-11T09:27:49 2014-12-11T09:27:49 Closed 2 cancelled: private not dpw maintained not a hazard DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1451 29TH AVE, SAN FRANCISCO, CA, 94122 29TH AVE 4 Outer Sunset TARAVAL 37.760256693625 -122.48778293973999 POINT (-122.48778294 37.76025669) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1981898 1981898 4347561 2014-12-30T17:24:32 2015-01-07T12:33:00 2015-01-07T12:33:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1011 MENDELL ST, SAN FRANCISCO, CA, 94124 MENDELL ST 10 Bayview BAYVIEW 37.736790228475996 -122.388192233908 POINT (-122.38819223 37.73679023) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1983535 1983535 4347211 2014-12-30T16:01:12 2015-01-06T10:26:00 2015-01-06T10:26:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HUDSON AVE and WHITNEY YOUNG CIR HUDSON AVE 10 Bayview BAYVIEW 37.733629726475 -122.382280518206 POINT (-122.38228052 37.73362973) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1987783 1987783 4295946 2014-12-12T07:57:00 2014-12-16T10:04:00 2014-12-16T10:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 15TH ST and CHURCH ST 15TH ST 8 Mission Dolores MISSION 37.766128634779 -122.428820922857 POINT (-122.42882092 37.76612863) Phone   37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
1988939 1988939 3947284 2014-08-24T15:09:56 2014-08-26T12:43:01 2014-08-26T12:43:01 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of VALLEJO ST and VAN NESS AVE VALLEJO ST 3 Pacific Heights NORTHERN 37.796690946055996 -122.423601877406 POINT (-122.42360188 37.79669095) Phone   102 4 6 13 1 13 6 28,858 9 17 17   102   6             1         102
1989161 1989161 4292404 2014-12-11T08:39:34 2014-12-11T09:52:00 2014-12-11T09:52:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 188 MIDCREST WAY, SAN FRANCISCO, CA, 94131 MIDCREST WAY 7 Midtown Terrace PARK 37.749853157746 -122.448020811934 POINT (-122.44802081 37.74985316) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
1989678 1989678 4348832 2014-12-31T08:47:54 2015-01-09T08:25:00 2015-01-09T08:25:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2140 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Mission MISSION 37.762840270996 -122.415267944336 POINT (-122.41526794 37.76284027) Web   53 3 2 20 7 8 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1993497 1993497 4347991 2014-12-30T19:53:28 2015-01-06T06:27:00 2015-01-06T06:27:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 815 FELL ST, SAN FRANCISCO, CA, 94117 FELL ST 5 Lower Haight NORTHERN 37.77473523590999 -122.43130771197201 POINT (-122.43130771 37.77473524) Phone   26 4 11 9 11 15 6 29,492 9 10 10   26   11             1         26
1993500 1993500 4291946 2014-12-11T07:06:00 2014-12-17T02:49:00 2014-12-17T02:49:00 Closed 2 resolved: Needs a restake DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1538 40TH AVE, SAN FRANCISCO, CA, 94122 40TH AVE 4 Outer Sunset TARAVAL 37.758092052951 -122.49915323024901 POINT (-122.49915323 37.75809205) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1993571 1993571 4301701 2014-12-14T11:49:37 2014-12-18T02:08:00 2014-12-18T02:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of TURK BLVD and WILLARD ST NORTH TURK BLVD 1 Lone Mountain RICHMOND 37.777400970459 -122.45686340331999 POINT (-122.4568634 37.77740097) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
1997296 1997296 4260819 2014-12-02T07:50:49 2014-12-04T01:14:47 2014-12-04T01:14:47 Closed 2 resolved: no trees are falling down or a hazard at 1098 Geneva DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1098 GENEVA AVE, SAN FRANCISCO, CA, 94112 GENEVA AVE 11 Crocker Amazon INGLESIDE 37.714856676894 -122.438047440113 POINT (-122.43804744 37.71485668) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1       4     2         58
1998144 1998144 4297676 2014-12-12T14:38:09 2014-12-15T12:08:00 2014-12-15T12:08:00 Closed 2 resolved: tree is stablle and not falling DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 126 HIGHLAND AVE, SAN FRANCISCO, CA, 94110 HIGHLAND AVE 9 Holly Park INGLESIDE 37.737243652344 -122.42310333251999 POINT (-122.42310333 37.73724365) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
2001469 2001469 4328702 2014-12-23T12:55:35 2014-12-24T07:15:00 2014-12-24T07:15:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 420 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 North Beach CENTRAL 37.799076080321996 -122.40811920166 POINT (-122.4081192 37.79907608) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
2010489 2010489 4348117 2014-12-30T21:30:00 2015-01-09T09:43:37 2015-01-09T09:43:37 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BAY SHORE BLVD and SALINAS AVE BAY SHORE BLVD 10 Portola BAYVIEW 37.721515504696 -122.399925083409 POINT (-122.39992508 37.7215155) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
2013973 2013973 4006782 2014-09-12T15:18:28 2014-09-17T01:04:30 2014-09-17T01:04:30 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 4840 MISSION ST, SAN FRANCISCO, CA, 94112 MISSION ST 11 Cayuga INGLESIDE 37.720731922386996 -122.437910147675 POINT (-122.43791015 37.72073192) Phone   80 9 1 28 6 9 4 28,861 7 25 25 4 80   1 4     4     2         80
2018252 2018252 4326754 2014-12-22T18:36:41   2014-12-27T13:14:01 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 17TH AVE and LAKE ST 17TH AVE 2 Lake Street RICHMOND 37.786128997803004 -122.476577758789 POINT (-122.47657776 37.786129) Phone   2 8 6 33 1 11 9 54 6 33 33   2   6             1         2
2020297 2020297 4355190 2015-01-02T12:18:14 2016-06-20T08:24:47 2016-06-20T08:24:47 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BAY SHORE BLVD and BACON ST BAY SHORE BLVD 10 Portola BAYVIEW 37.728103637695 -122.402206420898 POINT (-122.40220642 37.72810364) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
2020991 2020991 4347691 2014-12-30T17:59:23 2015-01-22T06:15:00 2015-01-22T06:15:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of ALEMANY BLVD and GENEVA AVE ALEMANY BLVD 11 Cayuga INGLESIDE 37.717832510814 -122.4423299991 POINT (-122.44233 37.71783251) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
2023987 2023987 4005078 2014-09-12T08:48:37 2014-09-12T07:03:00 2014-09-12T07:03:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1044 TARAVAL ST, SAN FRANCISCO, CA, 94116 TARAVAL ST 4 Parkside TARAVAL 37.743034567034 -122.477252370195 POINT (-122.47725237 37.74303457) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7 25     24     1         40
2024287 2024287 4281714 2014-12-08T12:21:25 2015-02-14T11:45:00 2015-02-14T11:45:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of LINCOLN WAY and ARGUELLO BLVD LINCOLN WAY 5 Golden Gate Park PARK 37.766013611451 -122.457790849361 POINT (-122.45779085 37.76601361) Phone   109 7 11 14 11 15 8 29,492 5 12 12   109   11             1         109
2025943 2025943 4349129 2014-12-31T09:49:03 2015-01-12T07:03:00 2015-01-12T07:03:00 Closed 2 resolved: Sam H inspected on Saturday Jan 10 and says it is private tree and done DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of MARKET ST and ROMAIN ST MARKET ST 8 Eureka Valley MISSION 37.756218321777 -122.44099820166201 POINT (-122.4409982 37.75621832) Phone   115 3 5 38 5 2 7 28,862 4 38 38   115   5             1         115
2027465 2027465 4116748 2014-10-16T18:02:26 2014-10-17T12:14:05 2014-10-17T12:14:05 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 3RD ST and 24TH ST 3RD ST 10 Central Waterfront BAYVIEW 37.754111786803 -122.387878250597 POINT (-122.38787825 37.75411179) Phone   56 2 9 26 8 10 3 28,856 3 29 29   56   9       22 14   1         56
2027516 2027516 4173332 2014-11-03T15:53:47 2016-04-11T17:30:30 2016-04-11T17:30:30 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2729 35TH AVE, SAN FRANCISCO, CA, 94116 35TH AVE 4 Parkside TARAVAL 37.736334466718 -122.492594310631 POINT (-122.49259431 37.73633447) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
2029869 2029869 4219834 2014-11-18T09:20:08 2014-11-21T01:03:45 2014-11-21T01:03:45 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1436 INGALLS ST, SAN FRANCISCO, CA, 94124 INGALLS ST 10 Bayview BAYVIEW 37.729966985218 -122.383380952911 POINT (-122.38338095 37.72996699) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
2030299 2030299 4298371 2014-12-12T17:07:29 2014-12-16T09:34:00 2014-12-16T09:34:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of BERNAL HEIGHTS BLVD and ELLSWORTH ST BERNAL HEIGHTS BLVD 9 Bernal Heights INGLESIDE 37.742458343505994 -122.414375305176 POINT (-122.41437531 37.74245834) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83

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