calls

80,878 rows where Category = 1 sorted by Status_Notes

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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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) Twitter https://twitter.com/StvnFlngn 95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
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
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
6165 6165 11525827 2019-10-09T07:53:00 2019-10-09T10:31:01 2019-10-09T10:31:01 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 576 DEWEY BLVD, SAN FRANCISCO, CA, 94116 DEWEY BLVD 7 Forest Hill TARAVAL 37.744289398193004 -122.463233947754 POINT (-122.46323395 37.7442894) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
6702 6702 11607372 2019-10-27T07:59:00 2019-10-27T12:23:49 2019-10-27T12:23:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1201 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.764427185059 -122.49671173095699 POINT (-122.49671173 37.76442719) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
6839 6839 11611964 2019-10-28T10:36:29 2019-10-28T10:22:54 2019-10-30T15:04:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CALIFORNIA ST and JOICE ST CALIFORNIA ST 3 Nob Hill CENTRAL 37.792140960693004 -122.408363342285 POINT (-122.40836334 37.79214096) Integrated Agency   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
7039 7039 11615523 2019-10-29T05:44:00 2019-10-29T11:25:34 2019-10-30T06:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of ELLSWORTH ST and BERNAL HEIGHTS BLVD ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742402488401 -122.414591414968 POINT (-122.41459141 37.74240249) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
7053 7053 11417305 2019-09-14T21:21:30 2019-10-01T10:11:46 2019-10-01T10:11:46 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 61 CURTIS ST, SAN FRANCISCO, CA, 94112 CURTIS ST 11 Crocker Amazon INGLESIDE 37.713811 -122.43956399999999 POINT (-122.439564 37.713811) Mobile/Open311   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
7213 7213 5657133 2016-03-11T17:23:03 2016-03-21T12:11:00 2016-03-21T12:11:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of INGALLS ST and REVERE AVE INGALLS ST 10 Bayview BAYVIEW 37.7284840677 -122.384557302501 POINT (-122.3845573 37.72848407) Phone   78 2 9 1 8 10 3 58 3 1 1   78   9             2         78
7370 7370 9873416 2018-11-30T13:42:00 2018-12-06T08:52:56 2018-12-06T08:52:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 299 2ND ST, SAN FRANCISCO, CA, 94105 2ND ST 6 South of Market SOUTHERN 37.785594940186 -122.396675109863 POINT (-122.39667511 37.78559494) Phone   32 1 10 8 9 6 2 28,855 2 6 6   32   10         3   1         32
7502 7502 7515634 2017-08-17T11:28:13 2017-08-21T00:00:00 2017-08-21T00:00:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of NEWHALL ST and HUDSON AVE NEWHALL ST 10 Bayview BAYVIEW 37.740043997162 -122.388274912707 POINT (-122.38827491 37.740044) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7621 7621 9867411 2018-11-29T10:42:00 2018-11-30T10:38:00 2018-11-30T10:38:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1744 OAKDALE AVE, SAN FRANCISCO, CA, 94124 OAKDALE AVE 10 Bayview BAYVIEW 37.736232757568004 -122.39295196533199 POINT (-122.39295197 37.73623276) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
7645 7645 9866498 2018-11-29T08:45:00 2018-12-03T00:25:17 2018-12-03T00:25:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 416 15TH AVE, SAN FRANCISCO, CA, 94118 15TH AVE 1 Inner Richmond RICHMOND 37.780178070068004 -122.47378540039101 POINT (-122.4737854 37.78017807) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
7847 7847 5670544 2016-03-16T10:20:43 2016-05-27T02:47:00 2016-05-27T02:47:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of NOE ST and CESAR CHAVEZ ST NOE ST 8 Noe Valley MISSION 37.747433478415 -122.431476739669 POINT (-122.43147674 37.74743348) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
8099 8099 10703913 2019-04-08T17:50:00 2019-10-08T09:20:00 2019-10-08T09:20:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MINERVA ST and SUMMIT ST MINERVA ST 11 Oceanview TARAVAL 37.715793609619006 -122.453514099121 POINT (-122.4535141 37.71579361) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
8251 8251 11312563 2019-08-23T10:17:00 2019-10-09T09:19:00 2019-10-09T09:19:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 853 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.757141205857 -122.427875488361 POINT (-122.42787549 37.75714121) Web   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
8528 8528 11489361 2019-10-01T09:54:00 2019-10-08T10:55:00 2019-10-08T10:55:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 154 STEINER ST, SAN FRANCISCO, CA, 94117 STEINER ST 5 Duboce Triangle PARK 37.770736631973 -122.431852603445 POINT (-122.4318526 37.77073663) Mobile/Open311 http://mobile311.sfgov.org/reports/11489361/photos 28 7 11 9 11 15 6 29,492 9 10 10   28   11             1         28
8683 8683 11496107 2019-10-02T14:54:00 2019-10-08T05:36:00 2019-10-08T05:36:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 83 BENTON AVE, SAN FRANCISCO, CA, 94112 BENTON AVE 9 St. Mary's Park INGLESIDE 37.732940673828004 -122.42554473876999 POINT (-122.42554474 37.73294067) Phone   93 9 2 2 7 2 4 28,861 7 2 2   93   2             1         93
8924 8924 5660354 2016-03-13T11:12:26 2016-03-17T02:24:00 2016-03-17T02:24:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 149 FILLMORE ST, SAN FRANCISCO, CA, 94117 FILLMORE ST 5 Duboce Triangle PARK 37.770971015405 -122.43035855350901 POINT (-122.43035855 37.77097102) Phone   28 7 11 9 11 15 6 29,492 9 10 10   28   11             1         28
9096 9096 11509026 2019-10-05T12:13:00 2019-10-08T10:10:27 2019-10-08T10:10:27 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of LAGUNA HONDA BLVD and 7TH AVE LAGUNA HONDA BLVD 7 Golden Gate Heights PARK 37.754787445068004 -122.46363067626999 POINT (-122.46363068 37.75478745) Phone   44 7 8 14 4 1 8 56 5 12 12   44   8             1         44
9194 9194 11510552 2019-10-05T18:34:00 2019-10-08T11:42:53 2019-10-08T11:42:53 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CAPITOL AVE and HOLLOWAY AVE CAPITOL AVE 7 Ingleside TARAVAL 37.7218421 -122.45922900000001 POINT (-122.459229 37.7218421) Web   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19     2         64
10529 10529 11520660 2019-10-08T07:30:00 2019-10-08T15:41:11 2019-10-08T15:41:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1686 BRYANT ST, SAN FRANCISCO, CA, 94103 BRYANT ST 9 Mission MISSION 37.765704993828 -122.410897103119 POINT (-122.4108971 37.76570499) Web http://mobile311.sfgov.org/reports/11520660/photos 53 3 2 20 7 8 7 28,853 4 19 19   53   2     3       2   3     53
10942 10942 11521677 2019-10-08T09:52:00 2019-10-08T15:40:23 2019-10-08T15:40:23 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 269 14TH ST, SAN FRANCISCO, CA, 94103 14TH ST 9 Mission MISSION 37.768268077669 -122.419259715939 POINT (-122.41925972 37.76826808) Mobile/Open311 http://mobile311.sfgov.org/reports/11521677/photos 53 3 2 20 7 8 7 28,853 4 19 19 12 53 1 2 14   3 14     2   3     53
10953 10953 11521686 2019-10-08T09:53:00 2019-10-08T10:04:41 2019-10-08T10:04:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1265 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Parnassus Heights PARK 37.7604063 -122.45195430000001 POINT (-122.4519543 37.7604063) Web http://mobile311.sfgov.org/reports/11521686/photos 110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
11368 11368 7473412 2017-08-07T16:43:14 2017-08-08T12:25:12 2017-08-08T12:25:12 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1371 24TH AVE, SAN FRANCISCO, CA, 94122 24TH AVE 4 Outer Sunset TARAVAL 37.762018083323 -122.48252916083099 POINT (-122.48252916 37.76201808) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
11534 11534 11523890 2019-10-08T15:24:00 2019-10-08T16:26:33 2019-10-08T16:26:33 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1275 MARKET ST, SAN FRANCISCO, CA, 94103 MARKET ST 6 South of Market TENDERLOIN 37.777725219727 -122.41565704345699 POINT (-122.41565704 37.77772522) Phone   32 5 10 34 9 8 2 28,853 2 34 34   32 1 10   14 1   7 1 2 1 1 35   32
11535 11535 5652662 2016-03-10T13:32:39 2016-03-17T09:17:07 2016-03-17T09:17:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
12769 12769 11592323 2019-10-23T15:41:00 2019-10-23T16:20:49 2019-10-23T16:20:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ALEMANY BLVD and CONGDON ST ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.7311668396 -122.426162719727 POINT (-122.42616272 37.73116684) Phone   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
13519 13519 10990704 2019-06-13T09:23:00 2019-10-09T14:44:00 2019-10-09T14:44:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of PALMETTO AVE and HEAD ST PALMETTO AVE 7 Merced Heights TARAVAL 37.71076965332 -122.46436309814501 POINT (-122.4643631 37.71076965) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
13853 13853 9813716 2018-11-15T14:56:00 2018-11-17T07:26:00 2018-11-17T07:26:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRADY ST and STEVENSON ST BRADY ST 6 South of Market SOUTHERN 37.773162841796996 -122.420776367188 POINT (-122.42077637 37.77316284) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1     1 2 1 1     32
13892 13892 11610663 2019-10-28T07:16:00 2019-10-28T10:01:57 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 9TH AVE and ANZA ST 9TH AVE 1 Inner Richmond RICHMOND 37.778945922852 -122.467353820801 POINT (-122.46735382 37.77894592) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
13941 13941 7435983 2017-07-29T10:04:13 2017-07-31T12:16:17 2017-07-31T12:16:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 521 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 1 Presidio Terrace RICHMOND 37.786508437181 -122.465225974437 POINT (-122.46522597 37.78650844) Phone   4 8 4 11 2 11 9 54 6 11 11   4   4             1         4
14049 14049 5674640 2016-03-17T11:39:27 2016-05-27T02:38:00 2016-05-27T02:38:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
14248 14248 11397190 2019-09-10T15:21:00 2019-10-08T10:13:00 2019-10-08T10:13:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1400 PINE ST, SAN FRANCISCO, CA, 94109 PINE ST 3 Polk Gulch NORTHERN 37.7897605896 -122.420364379883 POINT (-122.42036438 37.78976059) Phone   105 4 3 21 10 13 6 28,858 9 21 21   105   3   16     10   1         105
14453 14453 11611993 2019-10-28T10:39:00 2019-10-28T10:54:03 2019-10-29T15:15:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 82 STANTON ST, SAN FRANCISCO, CA, 94114 STANTON ST 8 Eureka Valley MISSION 37.7569414 -122.44190619999999 POINT (-122.4419062 37.7569414) Web   115 3 5 38 5 2 7 28,862 4 38 38   115   5             1         115
14459 14459 11363787 2019-09-03T16:00:00 2019-10-08T16:06:00 2019-10-08T16:06:00 Closed 2   311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 530 FLOOD AVE, SAN FRANCISCO, CA, 94112 FLOOD AVE 7 Sunnyside INGLESIDE 37.729976654053004 -122.451866149902 POINT (-122.45186615 37.72997665) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
14474 14474 11361775 2019-09-03T11:19:00 2019-10-08T10:25:00 2019-10-08T10:25:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 3245 OCTAVIA ST, SAN FRANCISCO, CA, 94123 OCTAVIA ST 2 Marina NORTHERN 37.802242279053004 -122.42992401123001 POINT (-122.42992401 37.80224228) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
14723 14723 11251568 2019-08-09T23:33:00 2019-10-08T15:08:36 2019-10-08T15:08:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 405 PANORAMA DR, SAN FRANCISCO, CA, 94131 PANORAMA DR 7 Midtown Terrace PARK 37.751628875732 -122.45223999023399 POINT (-122.45223999 37.75162888) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
14737 14737 11246895 2019-08-09T07:38:00 2019-10-03T09:33:00 2019-10-03T09:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 430 BURNETT AVE, SAN FRANCISCO, CA, 94131 BURNETT AVE 8 Upper Market PARK 37.755022197997 -122.44440626364401 POINT (-122.44440626 37.7550222) Mobile/Open311 http://mobile311.sfgov.org/reports/11246895/photos 51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
14786 14786 11149727 2019-07-19T06:50:00 2019-10-08T15:20:26 2019-10-08T15:20:26 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 20 SOUTHWOOD DR, SAN FRANCISCO, CA, 94112 SOUTHWOOD DR 7 Westwood Park INGLESIDE 37.725646972656 -122.45708254068701 POINT (-122.45708254 37.72564697) Mobile/Open311 http://mobile311.sfgov.org/reports/11149727/photos 71 9 8 41 4 9 4 28,861 7 40 40   71   8             1         71
14796 14796 11113957 2019-07-11T10:51:00 2019-10-01T11:54:00 2019-10-01T11:54:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of FRANCISCO ST and POWELL ST FRANCISCO ST 3 North Beach CENTRAL 37.80489730835 -122.411766052246 POINT (-122.41176605 37.80489731) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
14887 14887 11501046 2019-10-03T15:21:00 2019-10-06T10:10:00 2019-10-06T10:10:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
14896 14896 10975079 2019-06-10T07:20:00 2019-10-08T15:57:53 2019-10-08T15:57:53 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ASHWOOD LN and CLARENDON AVE ASHWOOD LN 7 Forest Knolls PARK 37.752853393555 -122.45603179931601 POINT (-122.4560318 37.75285339) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
14902 14902 10991190 2019-06-13T10:41:00 2019-10-04T11:37:00 2019-10-04T11:37:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 29 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 6 South of Market SOUTHERN 37.772304 -122.422473 POINT (-122.422473 37.772304) Mobile/Open311   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
14904 14904 10961333 2019-06-06T12:25:00 2019-10-08T15:58:48 2019-10-08T15:58:48 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of JULES AVE and OCEAN AVE JULES AVE 7 Mt. Davidson Manor TARAVAL 37.724948883056996 -122.461212158203 POINT (-122.46121216 37.72494888) Phone   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19 13   2         64
14926 14926 10923701 2019-05-29T10:27:00 2019-10-01T11:34:00 2019-10-01T11:34:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1059 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Nob Hill CENTRAL 37.7906451 -122.4179937 POINT (-122.4179937 37.7906451) Web http://mobile311.sfgov.org/reports/10923701/photos 16 6 3 21 10 13 1 28,858 1 21 21   16   3             1         16
14955 14955 10831222 2019-05-07T16:54:00 2019-10-01T14:55:00 2019-10-01T14:55:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708359 -122.485928 POINT (-122.485928 37.708359) Mobile/Open311 http://mobile311.sfgov.org/reports/10831222/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
14981 14981 10531082 2019-02-25T10:14:00 2019-10-08T00:00:00 2019-10-08T00:00:00 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 4530 20TH ST, SAN FRANCISCO, CA, 94114 20TH ST 8 Eureka Valley MISSION 37.757553100586 -122.43862915039101 POINT (-122.43862915 37.7575531) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
15328 15328 5670664 2016-03-16T10:42:15 2016-03-17T08:32:03 2016-03-17T08:32:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CLAYTON ST and PEMBERTON PL CLAYTON ST 8 Clarendon Heights PARK 37.758853912354 -122.446395874023 POINT (-122.44639587 37.75885391) Integrated Agency   47 7 5 5 5 15 8 28,862 5 3 3   47   5             1         47
15520 15520 9756868 2018-11-02T12:34:00 2018-12-07T11:59:36 2018-12-07T11:59:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of JACKSON ST and TAYLOR ST JACKSON ST 3 Nob Hill CENTRAL 37.795196533203004 -122.413185119629 POINT (-122.41318512 37.79519653) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
15594 15594 11510218 2019-10-05T17:01:00 2019-10-06T10:00:00 2019-10-06T10:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1847 47TH AVE, SAN FRANCISCO, CA, 94122 47TH AVE 4 Outer Sunset TARAVAL 37.751933 -122.50673799999998 POINT (-122.506738 37.751933) Mobile/Open311 http://mobile311.sfgov.org/reports/11510218/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
15598 15598 11510224 2019-10-05T17:03:00 2019-10-06T13:08:38 2019-10-06T13:08:38 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1079 CAPITOL AVE, SAN FRANCISCO, CA, 94112 CAPITOL AVE 11 Ingleside TARAVAL 37.721374511719 -122.45970916748001 POINT (-122.45970917 37.72137451) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
16015 16015 11511833 2019-10-06T09:46:49 2019-10-06T09:58:21 2019-10-06T09:58:21 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 3RD ST and MCKINNON AVE 3RD ST 10 Bayview BAYVIEW 37.736496666667 -122.390175 POINT (-122.390175 37.73649667) Mobile/Open311 http://mobile311.sfgov.org/reports/11511833/photos 86 2 9 1 8 10 3 58 3 1 1 11 86   9 13     13     2         86
16016 16016 11511835 2019-10-06T09:47:00 2019-10-06T09:56:49 2019-10-06T09:56:49 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 4800 3RD ST, SAN FRANCISCO, CA, 94124 3RD ST 10 Silver Terrace BAYVIEW 37.734741666667 -122.390921666667 POINT (-122.39092167 37.73474167) Mobile/Open311 http://mobile311.sfgov.org/reports/11511835/photos 87 2 9 1 8 10 3 58 3 1 1 11 87   9 13 5   13     2         87
16171 16171 5669666 2016-03-16T07:20:57 2016-03-17T08:26:30 2016-03-17T08:26:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 311 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.731745855640995 -122.49785305228501 POINT (-122.49785305 37.73174586) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
16330 16330 9573104 2018-09-21T17:46:35 2018-12-13T08:49:00 2018-12-13T08:49:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of MISSION ST and ROLPH ST MISSION ST 11 Crocker Amazon INGLESIDE 37.715766756321 -122.44158693866699 POINT (-122.44158694 37.71576676) Web http://mobile311.sfgov.org/reports/9573104/photos 80 9 1 28 6 9 4 28,861 7 25 25   80   1       4     2         80
16668 16668 11513556 2019-10-06T17:05:00 2019-10-06T17:20:11 2019-10-06T17:20:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 466 HEARST AVE, SAN FRANCISCO, CA, 94112 HEARST AVE 7 Sunnyside INGLESIDE 37.730804443359 -122.448097229004 POINT (-122.44809723 37.73080444) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
16751 16751 9141677 2018-06-15T12:45:00 2018-11-26T09:31:35 2018-11-26T09:31:35 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1567 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.757736206055 -122.496200561523 POINT (-122.49620056 37.75773621) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
17261 17261 11409675 2019-09-13T08:18:00 2019-10-26T07:20:54 2019-10-26T07:20:54 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRYANT ST and CESAR CHAVEZ ST BRYANT ST 9 Peralta Heights MISSION 37.748352050781 -122.408706665039 POINT (-122.40870667 37.74835205) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
17480 17480 10998649 2019-06-14T17:58:00 2019-07-16T12:33:00 2019-07-16T12:33:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BAY SHORE BLVD and CARROLL AVE BAY SHORE BLVD 10 Silver Terrace BAYVIEW 37.730659484863 -122.40340423584 POINT (-122.40340424 37.73065948) Phone   91 2 9 25 8 10 3 58 3 28 28   91   9             2         91
17747 17747 11570349 2019-10-18T16:25:00 2019-10-21T05:24:32 2019-10-21T05:24:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1092 INNES AVE, SAN FRANCISCO, CA, 94124 INNES AVE 10 India Basin BAYVIEW 37.734193 -122.379225 POINT (-122.379225 37.734193) Mobile/Open311 http://mobile311.sfgov.org/reports/11570349/photos 76 2 9 1 8 10 3 58 3 1 1   76   9             2         76
17945 17945 11522241 2019-10-08T11:12:32 2019-10-09T08:14:00 2019-10-09T08:14:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GENEVA AVE and MISSION ST GENEVA AVE 11 Crocker Amazon INGLESIDE 37.716461181641 -122.441017150879 POINT (-122.44101715 37.71646118) Integrated Agency   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4     4     2         90
18116 18116 5664203 2016-03-14T15:33:14 2016-04-12T02:34:00 2016-04-12T02:34:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of SCOTT ST and PINE ST SCOTT ST 2 Lower Pacific Heights NORTHERN 37.787323112213 -122.438581847698 POINT (-122.43858185 37.78732311) Phone   103 4 6 30 1 13 9 29,490 6 27 27   103   6             1         103
18119 18119 10994135 2019-06-13T20:01:00 2019-07-05T11:00:00 2019-07-05T11:00:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of 3RD ST and 20TH ST 3RD ST 10 Dogpatch BAYVIEW 37.76049041748 -122.38855743408199 POINT (-122.38855743 37.76049042) Phone   55 2 9 26 8 10 3 28,856 3 29 29 20 55   9 22     22 14   1         55
18463 18463 11578073 2019-10-21T06:33:00 2019-10-21T06:37:51 2019-10-21T06:37:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 819 LAGUNA ST, SAN FRANCISCO, CA, 94102 LAGUNA ST 5 Western Addition NORTHERN 37.778480200000004 -122.42692849999999 POINT (-122.4269285 37.7784802) Web   97 4 11 39 11 7 6 28,852 9 41 41   97   11             2         97
19133 19133 5659443 2016-03-12T17:37:50 2016-04-19T20:25:52 2016-04-19T20:25:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
19331 19331 5657697 2016-03-12T02:52:39 2016-03-26T10:27:00 2016-03-26T10:27:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 32 MUSEUM WAY, SAN FRANCISCO, CA, 94114 MUSEUM WAY 8 Corona Heights PARK 37.764839172363 -122.440879821777 POINT (-122.44087982 37.76483917) Integrated Agency   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
19334 19334 11231994 2019-08-06T07:38:00 2019-08-22T11:43:00 2019-08-22T11:43:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1119 MASON ST, SAN FRANCISCO, CA, 94108 MASON ST 3 Nob Hill CENTRAL 37.793895721436 -122.411415100098 POINT (-122.4114151 37.79389572) Phone   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
19342 19342 5657507 2016-03-11T20:34:22 2016-05-16T05:12:30 2016-05-16T05:12:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 2203 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 4 Outer Sunset TARAVAL 37.763316145425 -122.481460005817 POINT (-122.48146001 37.76331615) Phone   39 10 7 35 3 1 5 56 8 35 35 9 39   7 11     11     1         39
19343 19343 5657495 2016-03-11T20:22:49 2016-03-14T12:30:00 2016-03-14T12:30:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAKER ST and JEFFERSON ST BAKER ST 2 Marina NORTHERN 37.804218292236 -122.44709777831999 POINT (-122.44709778 37.80421829) Integrated Agency   17 4 6 13 1 13 6 57 9 17 17   17   6             1     15   17
19346 19346 5657456 2016-03-11T19:52:38 2016-03-15T01:56:00 2016-03-15T01:56:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BOSWORTH ST and ELK ST BOSWORTH ST 8 Glen Park INGLESIDE 37.734855651855 -122.43993377685499 POINT (-122.43993378 37.73485565) Integrated Agency   96 9 5 41 5 9 4 63 7 40 40   96   5             1     80   96
19349 19349 5657458 2016-03-11T19:52:40 2016-03-12T11:58:00 2016-03-12T11:58:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of OSHAUGHNESSY BLVD and WOODSIDE AVE OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.745532989502 -122.451622009277 POINT (-122.45162201 37.74553299) Integrated Agency   72 9 5 10 5 1 4 59 7 7 7   72   5             1         72
19350 19350 5657481 2016-03-11T20:11:33 2016-05-16T05:12:24 2016-05-16T05:12:24 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GREEN ST and FRANKLIN ST GREEN ST 2 Union Street NORTHERN 37.797408141001 -122.425437864596 POINT (-122.42543786 37.79740814) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
19352 19352 5657465 2016-03-11T19:53:31 2016-05-16T05:12:39 2016-05-16T05:12:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of MISSION ST and 16TH ST MISSION ST 9 Mission MISSION 37.76505279541 -122.41967010498001 POINT (-122.4196701 37.7650528) Phone   53 3 2 20 7 8 7 28,859 4 19 19 12 53   2 14   3 14     2   3 50 24 53
19355 19355 5657415 2016-03-11T19:22:59 2016-03-17T09:21:58 2016-03-17T09:21:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 24TH AVE and SANTIAGO ST 24TH AVE 4 Parkside TARAVAL 37.744682312012 -122.48117828369101 POINT (-122.48117828 37.74468231) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7 25     24     1         40
19359 19359 5657352 2016-03-11T18:53:00 2016-03-11T22:21:50 2016-03-11T22:21:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MUSEUM WAY and ROOSEVELT WAY MUSEUM WAY 8 Corona Heights PARK 37.765270959474 -122.44124166726601 POINT (-122.44124167 37.76527096) Phone   112 7 5 5 5 15 8 28,862 5 3 3   112   5             1         112
19847 19847 5652663 2016-03-10T13:32:40 2016-03-11T07:52:25 2016-03-11T07:52:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and GOUGH ST GEARY BLVD 5 Cathedral Hill NORTHERN 37.785335540771 -122.42469024658199 POINT (-122.42469025 37.78533554) Integrated Agency   100 4 11 39 11 13 6 28,858 9 41 41   100   11             2         100
20009 20009 5651481 2016-03-10T09:41:58 2016-06-24T08:37:00 2016-06-24T08:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 222 MONCADA WAY, SAN FRANCISCO, CA, 94127 MONCADA WAY 7 Ingleside Terraces TARAVAL 37.727577209473 -122.468681335449 POINT (-122.46868134 37.72757721) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
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                                                        
20096 20096 5650882 2016-03-10T06:49:11 2016-03-11T03:02:00 2016-03-11T03:02:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 8TH AVE and JUDAH ST 8TH AVE 5 Inner Sunset TARAVAL 37.762222290039 -122.465118408203 POINT (-122.46511841 37.76222229) Phone   109 10 11 14 11 1 5 56 8 12 12   109   11             1         109
20169 20169 5650355 2016-03-09T18:12:51 2016-04-07T08:05:00 2016-04-07T08:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of MONTEREY BLVD and HAZELWOOD AVE MONTEREY BLVD 7 Westwood Park INGLESIDE 37.731464385986 -122.454917907715 POINT (-122.45491791 37.73146439) Web   71 9 8 41 4 9 4 59 7 40 40   71   8             1         71
20680 20680 11315340 2019-08-23T17:58:00 2019-10-10T07:17:34 2019-10-10T07:17:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 440 AUSTIN ST, SAN FRANCISCO, CA, 94109 AUSTIN ST 5 Cathedral Hill NORTHERN 37.788558 -122.42598000000001 POINT (-122.42598 37.788558) Mobile/Open311 http://mobile311.sfgov.org/reports/11315340/photos 100 4 11 30 11 13 6 28,858 9 27 27   100   11             1         100
20697 20697 11384386 2019-09-08T00:47:00 2019-10-16T10:31:56 2019-10-16T10:31:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1355 35TH AVE, SAN FRANCISCO, CA, 94122 35TH AVE 4 Outer Sunset TARAVAL 37.761739299999995 -122.4942252 POINT (-122.4942252 37.7617393) Web   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
20736 20736 11483206 2019-09-30T07:36:00 2019-10-10T07:35:00 2019-10-10T07:35:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1322 BAKER ST, SAN FRANCISCO, CA, 94115 BAKER ST 2 Lower Pacific Heights RICHMOND 37.783351898193004 -122.442726135254 POINT (-122.44272614 37.7833519) Phone   103 8 6 15 1 15 9 29,490 6 13 13   103   6             2         103
20784 20784 11499307 2019-10-03T10:46:00 2019-10-10T10:02:00 2019-10-10T10:02:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1000 UNION ST, SAN FRANCISCO, CA, 94133 UNION ST 2 Russian Hill CENTRAL 37.799705505371 -122.415962219238 POINT (-122.41596222 37.79970551) Phone   107 6 6 32 1 5 1 308 1 32 32   107   6             1         107

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