calls

7,158 rows where Responsible_Agency = 2 sorted by Media_URL

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
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
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
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
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
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
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
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
6924 6924 11613883 2019-10-28T15:27:00   2019-10-28T16:00:20 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CESAR CHAVEZ ST and FLORIDA ST CESAR CHAVEZ ST 9 Peralta Heights MISSION 37.748332977295 -122.40964508056601 POINT (-122.40964508 37.74833298) Phone   60 3 2 2 7 2 7 28,859 4 2 2   60   2     3       1   3     60
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
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
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
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
8199 8199 11110966 2019-07-10T15:57:00   2019-10-16T08:23:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1031 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719181060791 -122.396774291992 POINT (-122.39677429 37.71918106) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
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
8309 8309 11400751 2019-09-11T11:30:00   2019-10-08T17:05:18 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WHITNEY YOUNG CIR and HUDSON AVE WHITNEY YOUNG CIR 10 Bayview BAYVIEW 37.733631134033 -122.382278442383 POINT (-122.38227844 37.73363113) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
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
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
13542 13542 4169880 2014-11-02T17:40:01 2014-11-29T10:07:40 2014-11-29T10:07:40 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
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
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                                                        
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
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
17193 17193 10820153 2019-05-05T14:27:00 2019-10-21T13:17:00 2019-10-21T13:17:00 Closed 2 Notes:dead pine with missing top. BUF Action:Remove Tree. Notes:dead pine with missing top. BUF Action:Remove Tree. Notes:dead pine with missing top :: Closed By CMMS SO 1143263. BUF Action:Remove Tree. date completed - 10/21/2019. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2266 9TH AVE, SAN FRANCISCO, CA, 94116 9TH AVE 7 Forest Hill TARAVAL 37.747303009033 -122.466278076172 POINT (-122.46627808 37.74730301) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
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
18140 18140 11155298 2019-07-20T11:03:00   2019-09-21T11:11:06 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BRADFORD ST and TOMPKINS AVE BRADFORD ST 9 Bernal Heights INGLESIDE 37.73685836792 -122.40975952148399 POINT (-122.40975952 37.73685837) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
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
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
20657 20657 11148097 2019-07-18T15:57:00   2019-10-10T11:08:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTCALM ST and WRIGHT ST MONTCALM ST 9 Peralta Heights INGLESIDE 37.747459411621 -122.405921936035 POINT (-122.40592194 37.74745941) Phone   60 9 2 2 7 2 4 28,859 7 2 2   60   2             1         60
21108 21108 11523861 2019-10-08T15:19:00   2019-10-18T13:37:22 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of 17TH AVE and NORIEGA ST 17TH AVE 7 Golden Gate Heights TARAVAL 37.754333496094 -122.474334716797 POINT (-122.47433472 37.7543335) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
21857 21857 11531342 2019-10-10T09:29:00   2019-10-10T10:20:27 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 122 ROUSSEAU ST, SAN FRANCISCO, CA, 94112 ROUSSEAU ST 8 St. Mary's Park INGLESIDE 37.732772827148 -122.43030548095699 POINT (-122.43030548 37.73277283) Phone   93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
22255 22255 11533385 2019-10-10T14:39:00 2019-10-28T15:00:47 2019-10-28T15:40:12 Closed 2 trees not dead just poor structure. only trees on wawona were posted and they are alive and did not fail despite past topping prior to city maintenance they will remove stump will call for brush pick up DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 201 VICENTE ST, SAN FRANCISCO, CA, 94127 VICENTE ST 7 West Portal TARAVAL 37.739887237549 -122.468460083008 POINT (-122.46846008 37.73988724) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
23031 23031 11627389 2019-10-31T14:02:00   2019-10-31T17:00:34 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ANZA ST and ROSSI AVE ANZA ST 1 Lone Mountain RICHMOND 37.779693603516 -122.456497192383 POINT (-122.45649719 37.7796936) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
23049 23049 11254502 2019-08-10T18:15:00 2019-09-18T14:46:00 2019-09-18T14:46:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of BALBOA ST and 26TH AVE BALBOA ST 1 Outer Richmond RICHMOND 37.776252746581996 -122.48553466796899 POINT (-122.48553467 37.77625275) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
23117 23117 10812812 2019-05-03T12:32:00 2019-10-27T12:05:00 2019-10-27T12:05:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1006 RANDOLPH ST, SAN FRANCISCO, CA, 94132 RANDOLPH ST 11 Merced Heights TARAVAL 37.715091705321996 -122.471435546875 POINT (-122.47143555 37.71509171) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
25077 25077 11593409 2019-10-23T19:41:00 2019-10-25T13:36:07 2019-10-25T13:36:07 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 269 MOULTRIE ST, SAN FRANCISCO, CA, 94110 MOULTRIE ST 9 Bernal Heights INGLESIDE 37.7407513 -122.415568 POINT (-122.415568 37.7407513) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
26475 26475 11598258 2019-10-24T20:18:00 2019-10-25T15:16:54 2019-10-25T15:16:54 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 2259 9TH AVE, SAN FRANCISCO, CA, 94116 9TH AVE 7 Golden Gate Heights TARAVAL 37.747402191162 -122.46654510498001 POINT (-122.4665451 37.74740219) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
27709 27709 11601003 2019-10-25T12:38:00   2019-10-25T13:35:51 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 371 WALLER ST, SAN FRANCISCO, CA, 94117 WALLER ST 5 Duboce Triangle PARK 37.771114349365 -122.42974853515601 POINT (-122.42974854 37.77111435) Phone   28 7 11 9 11 7 6 29,492 9 10 10   28   11             1         28
27710 27710 11601004 2019-10-25T12:38:00   2019-10-25T13:35:50 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 301 EXECUTIVE PARK BLVD, SAN FRANCISCO, CA, 94134 EXECUTIVE PARK BLVD 10 Candlestick Point SRA BAYVIEW 37.711143493652 -122.390769958496 POINT (-122.39076996 37.71114349) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
31373 31373 11607221 2019-10-27T06:20:00 2019-10-28T10:03:55 2019-10-31T22:30:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 753 SHRADER ST, SAN FRANCISCO, CA, 94117 SHRADER ST 5 Cole Valley PARK 37.767768859863 -122.451675415039 POINT (-122.45167542 37.76776886) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
31410 31410 11607379 2019-10-27T08:01:00 2019-10-28T10:23:13 2019-10-30T11:45:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 74 CERVANTES BLVD, SAN FRANCISCO, CA, 94123 CERVANTES BLVD 2 Marina NORTHERN 37.803726196289 -122.43834686279301 POINT (-122.43834686 37.8037262) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
31457 31457 11607529 2019-10-27T08:43:00 2019-10-29T13:55:31 2019-10-29T13:55:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3723 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754257202148 -122.441749572754 POINT (-122.44174957 37.7542572) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31458 31458 11607532 2019-10-27T08:44:00 2019-10-28T10:07:35 2019-10-29T13:54:58 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3721 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754318237305 -122.44171142578101 POINT (-122.44171143 37.75431824) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31466 31466 11607558 2019-10-27T08:50:00 2019-10-28T10:07:30 2019-10-29T14:55:06 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MARKET ST and SHORT ST MARKET ST 8 Eureka Valley MISSION 37.757797241211 -122.443214416504 POINT (-122.44321442 37.75779724) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
31467 31467 11607563 2019-10-27T08:52:00 2019-10-28T10:07:40 2019-10-29T13:57:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3701 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754543304443004 -122.441619873047 POINT (-122.44161987 37.7545433) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
31489 31489 11607622 2019-10-27T09:07:00 2019-10-28T09:51:13 2019-10-28T10:40:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 279 MONTEREY BLVD, SAN FRANCISCO, CA, 94131 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731407165527 -122.441513061523 POINT (-122.44151306 37.73140717) Phone   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
31966 31966 11609120 2019-10-27T14:51:00 2019-10-28T09:48:39 2019-10-31T22:35:31 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2249 17TH AVE, SAN FRANCISCO, CA, 94116 17TH AVE 7 Golden Gate Heights TARAVAL 37.745956420898 -122.473823547363 POINT (-122.47382355 37.74595642) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
31978 31978 11609144 2019-10-27T14:57:00 2019-10-28T09:22:41 2019-10-28T10:50:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 462 HEAD ST, SAN FRANCISCO, CA, 94132 HEAD ST 11 Merced Heights TARAVAL 37.715476989746 -122.46427154541 POINT (-122.46427155 37.71547699) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
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
32582 32582 11610643 2019-10-28T07:11:00 2019-10-28T10:02:03 2019-10-29T15:00:21 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 901 BALBOA ST, SAN FRANCISCO, CA, 94118 BALBOA ST 1 Inner Richmond RICHMOND 37.776889801025 -122.468505859375 POINT (-122.46850586 37.7768898) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
33561 33561 11613220 2019-10-28T13:50:00 2019-10-29T09:30:57 2019-10-29T14:10:05 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 959 HAIGHT ST, SAN FRANCISCO, CA, 94117 HAIGHT ST 5 Buena Vista PARK 37.7709491 -122.43798740000001 POINT (-122.4379874 37.7709491) Web   112 7 11 3 11 15 8 29,492 5 9 9   112   11             1         112
33916 33916 11614275 2019-10-28T16:36:00   2019-10-28T17:10:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CESAR CHAVEZ ST and NOE ST CESAR CHAVEZ ST 8 Noe Valley MISSION 37.74743270874 -122.43147277831999 POINT (-122.43147278 37.74743271) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
35411 35411 11617730 2019-10-29T12:24:00   2019-10-29T13:20:06 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 20TH ST and CHURCH ST 20TH ST 8 Dolores Heights MISSION 37.758087158203004 -122.428047180176 POINT (-122.42804718 37.75808716) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
35971 35971 11619231 2019-10-29T16:23:00   2019-10-29T17:05:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 215 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.710277557373 -122.46923065185499 POINT (-122.46923065 37.71027756) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35976 35976 11619243 2019-10-29T16:25:00   2019-10-29T17:10:09 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 130 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711681365967 -122.46935272216801 POINT (-122.46935272 37.71168137) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
35984 35984 11619257 2019-10-29T16:26:00 2019-10-30T08:57:16 2019-10-30T08:57:16 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 134 SAINT CHARLES AVE, SAN FRANCISCO, CA, 94132 SAINT CHARLES AVE 7 Merced Heights TARAVAL 37.711620330811 -122.46935272216801 POINT (-122.46935272 37.71162033) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
36243 36243 11619759 2019-10-29T18:04:00   2019-10-30T11:30:15 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of NORMANDIE TER and VALLEJO ST NORMANDIE TER 2 Pacific Heights NORTHERN 37.794505900000004 -122.44088870000002 POINT (-122.4408887 37.7945059) Web   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
36620 36620 11620630 2019-10-30T06:19:00   2019-10-30T11:30:11 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 58 ELLSWORTH ST, SAN FRANCISCO, CA, 94110 ELLSWORTH ST 9 Bernal Heights INGLESIDE 37.742154 -122.41458700000001 POINT (-122.414587 37.742154) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
36878 36878 11621063 2019-10-30T08:24:00 2019-10-30T22:15:34 2019-10-30T22:15:34 Closed 2 Request is a duplicate and has been previously reported as 11619759 DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2646 VALLEJO ST, SAN FRANCISCO, CA, 94123 VALLEJO ST 2 Pacific Heights NORTHERN 37.794609069824 -122.44082641601601 POINT (-122.44082642 37.79460907) Phone   102 4 6 30 1 13 6 57 9 27 27   102   6             1         102
38779 38779 11625433 2019-10-31T08:26:00   2019-10-31T08:55:10 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GILROY ST and INGERSON AVE GILROY ST 10 Bret Harte BAYVIEW 37.71688079834 -122.38913726806601 POINT (-122.38913727 37.7168808) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
39536 39536 11627160 2019-10-31T13:24:00   2019-10-31T14:00:44 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of POPLAR ST and 26TH ST POPLAR ST 8 Mission MISSION 37.748878479004 -122.420829772949 POINT (-122.42082977 37.74887848) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
39894 39894 11628119 2019-10-31T16:11:00   2019-10-31T22:37:05 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 1309 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.729553222656 -122.433395385742 POINT (-122.43339539 37.72955322) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
43463 43463 11566340 2019-10-17T23:13:00 2019-10-29T12:30:27 2019-10-30T06:00:30 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CORTLAND AVE and PROSPECT AVE CORTLAND AVE 9 Holly Park INGLESIDE 37.740241 -122.42087920000002 POINT (-122.4208792 37.740241) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
43816 43816 10886739 2019-05-20T13:55:00   2019-05-22T17:55:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 655 KEITH ST, SAN FRANCISCO, CA, 94124 KEITH ST 10 Bayview BAYVIEW 37.73722076416 -122.38280487060499 POINT (-122.38280487 37.73722076) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
44004 44004 7091066 2017-04-28T08:45:47 2017-04-28T03:37:00 2017-04-28T03:37:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GRAYSTONE TER and IRON ALY GRAYSTONE TER 8 Clarendon Heights PARK 37.757270904363 -122.44496649598699 POINT (-122.4449665 37.7572709) Phone   47 7 5 5 5 2 8 28,862 5 3 3   47   5             1         47
44409 44409 11490692 2019-10-01T13:18:00   2019-10-01T14:30:13 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 95 MCCOPPIN ST, SAN FRANCISCO, CA, 94103 MCCOPPIN ST 6 South of Market SOUTHERN 37.771102905273 -122.422050476074 POINT (-122.42205048 37.77110291) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
44667 44667 11536012 2019-10-11T09:21:00   2019-10-22T11:11:22 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of HESTER AVE and BAY SHORE BLVD HESTER AVE 10 Visitacion Valley INGLESIDE 37.715339660645 -122.398994445801 POINT (-122.39899445 37.71533966) Phone   75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
45347 45347 11541521 2019-10-12T12:38:00   2019-10-12T13:10:24 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of SAN JOSE AVE and SAINT MARYS AVE SAN JOSE AVE 8 St. Mary's Park INGLESIDE 37.734951019287 -122.428436279297 POINT (-122.42843628 37.73495102) Phone   93 9 5 2 5 2 4 28,861 7 2 2   93   5             1         93
45740 45740 10681827 2019-04-03T12:44:00 2019-09-25T15:08:00 2019-09-25T15:08:00 Closed 2 Job complete - Duplicate DREED60098 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SUNSET BLVD and OCEAN AVE SUNSET BLVD 7 Lakeshore TARAVAL 37.731910705566 -122.493721008301 POINT (-122.49372101 37.73191071) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
45748 45748 10713753 2019-04-10T18:26:00 2019-09-27T11:02:47 2019-09-27T11:02:47 Closed 2 Notes - Needs more information - Thank you, ACraven946 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of MARKET ST and 6TH ST MARKET ST 6 Tenderloin TENDERLOIN 37.782230377196996 -122.410293579102 POINT (-122.41029358 37.78223038) Phone   20 5 10 34 9 14 2 28,853 2 34 34 17 20 1 10 18   1 18 7 1 2 1 1 35   20
45763 45763 10759845 2019-04-22T06:50:00 2019-09-26T15:09:00 2019-09-26T15:09:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LAKE MERCED BLVD and SKYLINE BLVD LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.732269287109 -122.49810791015601 POINT (-122.49810791 37.73226929) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
45821 45821 11001547 2019-06-15T15:55:00   2019-09-24T11:40:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 36TH AVE and SANTIAGO ST 36TH AVE 4 Parkside TARAVAL 37.744113922119006 -122.494041442871 POINT (-122.49404144 37.74411392) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
46094 46094 11230262 2019-08-05T16:14:00 2019-09-27T14:22:00 2019-09-27T14:22:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 162 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.744312286377 -122.458251953125 POINT (-122.45825195 37.74431229) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
46306 46306 11314161 2019-08-23T14:19:00   2019-10-18T15:34:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of JUNIPERO SERRA BLVD and OCEAN AVE JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.731204986571996 -122.47216033935499 POINT (-122.47216034 37.73120499) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
46972 46972 11407269 2019-09-12T14:52:00 2019-09-24T09:35:00 2019-09-24T09:35:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of WEST PORTAL AVE and PORTOLA DR WEST PORTAL AVE 7 Merced Manor TARAVAL 37.734706878662 -122.471572875977 POINT (-122.47157288 37.73470688) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
47023 47023 11411057 2019-09-13T11:48:00   2019-09-27T09:45:07 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of SAN JOSE AVE and OCEAN AVE SAN JOSE AVE 11 Mission Terrace INGLESIDE 37.722965240479 -122.44474792480499 POINT (-122.44474792 37.72296524) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2     70   80
47143 47143 11416342 2019-09-14T16:12:00   2019-09-24T08:00:58 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1632 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772065904708 -122.446262096588 POINT (-122.4462621 37.7720659) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
47415 47415 11426085 2019-09-17T07:40:00   2019-09-24T09:25:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1114 COLE ST, SAN FRANCISCO, CA, 94117 COLE ST 5 Ashbury Heights PARK 37.763793945313 -122.449394226074 POINT (-122.44939423 37.76379395) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
47446 47446 11427239 2019-09-17T10:33:00   2019-09-27T10:20:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of HARNEY WAY and JAMESTOWN AVE HARNEY WAY 10 Candlestick Point SRA BAYVIEW 37.711162567139 -122.38645172119101 POINT (-122.38645172 37.71116257) Phone   79 2 9 1 8 10 3 58 3 1 1   79   9             1         79
48508 48508 11446960 2019-09-21T13:19:00 2019-09-27T14:08:00 2019-09-27T14:08:00 Closed 2 Landscape - Area Inspected - No access to back of house / Private Property. EHernandez DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 45 FREDSON CT, SAN FRANCISCO, CA, 94112 FREDSON CT 11 Outer Mission INGLESIDE 37.71354675293 -122.44727325439501 POINT (-122.44727325 37.71354675) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
52196 52196 11463262 2019-09-25T09:13:00   2019-09-25T10:05:08 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PEMBERTON PL and VILLA TER PEMBERTON PL 8 Clarendon Heights PARK 37.758453369141 -122.44676971435499 POINT (-122.44676971 37.75845337) Phone   47 7 5 5 5 15 8 28,862 5 3 3   47   5             1         47
54207 54207 11469291 2019-09-26T12:42:00   2019-09-26T13:20:01 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH AVE and LINCOLN WAY 5TH AVE 5 Inner Sunset PARK 37.766109466553004 -122.462158203125 POINT (-122.4621582 37.76610947) Phone   109 7 11 14 11 11 8 29,492 5 12 12   109   11             1         109
54508 54508 11470389 2019-09-26T16:00:00 2019-09-27T11:36:15 2019-09-27T11:36:15 Closed 2 PGE is required to prune trees away from high voltage line to mitigate potential fire hazards. SFPW will prune tree away from muni lines. These trees do not meet the criteria for removal at this time. MD Notes:tree has bad structure may need to be pruned for vehicle clearance MD. BUF Action:Inspect. date completed - 9/27/2019. Notes:tree has good structure, upper canopy needs to be pruned away from muni lines MD. BUF Action:Inspect. date completed - 9/27/2019. Notes:tree has good DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 700 TENNESSEE ST, SAN FRANCISCO, CA, 94107 TENNESSEE ST 10 Dogpatch BAYVIEW 37.762855529785 -122.38986968994101 POINT (-122.38986969 37.76285553) Phone   55 2 9 26 8 10 3 28,856 3 29 29   55   9         14   1         55
55111 55111 11472317 2019-09-27T08:24:00   2019-10-21T08:26:30 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MASONIC AVE and GEARY BLVD MASONIC AVE 2 Lone Mountain RICHMOND 37.782390594482 -122.447303771973 POINT (-122.44730377 37.78239059) Phone   12 8 4 18 2 15 8 54 5 16 16   12   4             1     7   12
55223 55223 11472616 2019-09-27T09:10:00   2019-09-27T10:00:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 23RD ST and ARKANSAS ST 23RD ST 10 Potrero Hill BAYVIEW 37.754825592041 -122.39772796630899 POINT (-122.39772797 37.75482559) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
58153 58153 9648717 2018-10-09T14:32:00 2019-09-25T15:15:00 2019-09-25T15:15:00 Closed 2 Job Complete - Duplicate DREED60098 - The Monterey Blvd Medians is scheduled for planned maintenance. (See Multi-Assets for full scope of work.) DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of MONTEREY BLVD and SAN JACINTO WAY MONTEREY BLVD 7 Balboa Terrace TARAVAL 37.732051849365 -122.464111328125 POINT (-122.46411133 37.73205185) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
59386 59386 11490810 2019-10-01T13:36:00   2019-10-04T09:15:13 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 30TH AVE and CALIFORNIA ST 30TH AVE 2 Seacliff RICHMOND 37.783641815186 -122.49036407470699 POINT (-122.49036407 37.78364182) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
59717 59717 11500719 2019-10-03T14:24:00 2019-10-04T14:52:08 2019-10-04T14:52:08 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 243 GRAFTON AVE, SAN FRANCISCO, CA, 94112 GRAFTON AVE 11 Ingleside TARAVAL 37.719921112061 -122.455879211426 POINT (-122.45587921 37.71992111) Phone   64 10 1 24 6 9 5 28,861 8 24 24   64   1             2         64
59992 59992 11511529 2019-10-06T08:20:00   2019-10-06T08:55:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DOLORES ST and MARKET ST DOLORES ST 8 Mission Dolores MISSION 37.76904296875 -122.426856994629 POINT (-122.42685699 37.76904297) Phone   37 3 5 20 5 8 7 28,862 4 19 19   37   5     5   9   2   5     37
60050 60050 11513655 2019-10-06T17:39:00   2019-10-06T18:10:17 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of VISITACION AVE and RUTLAND ST VISITACION AVE 10 Visitacion Valley INGLESIDE 37.711448669434 -122.407928466797 POINT (-122.40792847 37.71144867) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
60115 60115 11473778 2019-09-27T12:08:00   2019-10-07T16:00:33 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3400 SAN BRUNO AVE, SAN FRANCISCO, CA, 94134 SAN BRUNO AVE 10 Portola INGLESIDE 37.719013214111 -122.400535583496 POINT (-122.40053558 37.71901321) Phone   91 9 9 40 8 10 4 309 7 39 39   91   9             2         91
60632 60632 11475647 2019-09-27T17:53:00   2019-10-04T10:25:16 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 30 LAPIDGE ST, SAN FRANCISCO, CA, 94110 LAPIDGE ST 8 Mission Dolores MISSION 37.761123657227 -122.422485351563 POINT (-122.42248535 37.76112366) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37

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