calls

7,158 rows where Responsible_Agency = 2 sorted by Neighborhoods

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 ▼
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                                                        
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                                                        
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                                                        
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          
104408 104408 9001048 2018-05-14T19:01:00 2018-05-15T07:34:37 2018-05-15T07:34:37 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
106724 106724 8384888 2017-12-13T22:04:00   2017-12-15T10:55:12 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
111989 111989 7251820 2017-06-12T13:40:47 2017-10-10T01:49:00 2017-10-10T01:49:00 Closed 2 Weeded D1 CCT DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
127658 127658 5837044 2016-05-05T22:51:48 2016-05-10T09:47:00 2016-05-10T09:47: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) Web                                                        
128084 128084 5790504 2016-04-22T14:32:41 2016-09-10T13:55:10 2016-09-10T13:55:10 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DIVISADERO ST and HAIGHT ST DIVISADERO ST 5 Buena Vista NORTHERN 37.771265128723 -122.437044992878 POINT (-122.43704499 37.77126513) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
131754 131754 5176596 2015-10-09T20:06:09 2016-01-16T02:33:00 2016-01-16T02:33:00 Closed 2 resolved: area was inspected and found to be cleared. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132001 132001 4572450 2015-03-13T13:08:21 2016-06-20T07:26:17 2016-06-20T07:26:17 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132250 132250 3730334 2014-06-11T09:46:00 2016-06-20T08:11:48 2016-06-20T08:11:48 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132261 132261 3537207 2014-04-10T08:12:26   2016-06-16T15:13:40 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
135774 135774 4387002 2015-01-12T15:01:45 2016-08-17T15:25:34 2016-08-17T15:25:34 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) Web                                                        
137122 137122 4991139 2015-08-12T09:07:22 2015-08-25T02:40:00 2015-08-25T02:40:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
140878 140878 10499352 2019-02-17T10:42:00   2019-02-17T11:15:06 Open 1 accepted 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                                                        
147510 147510 3284434 2014-01-18T09:31:04   2014-01-21T10:03:48 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
147761 147761 9251895 2018-07-11T09:32:00   2018-07-11T09:47:55 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
151996 151996 8053291 2017-09-22T13:37:00 2018-02-13T10:44:14 2018-02-13T10:44:14 Closed 2 Please check the irrigation at this site. DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
218194 218194 9242015 2018-07-09T09:44:00 2018-08-09T08:15:00 2018-08-09T08:15:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781257629395 -122.458862304688 POINT (-122.4588623 37.78125763) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
245661 245661 9272126 2018-07-16T09:18:00 2018-07-17T12:29:46 2018-07-17T12:29:46 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DIVISADERO ST and PAGE ST DIVISADERO ST 5 Buena Vista NORTHERN 37.772205352783 -122.43723297119101 POINT (-122.43723297 37.77220535) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
306268 306268 9474801 2018-08-30T12:16:00 2018-09-22T07:22:00 2018-09-22T07:22:00 Closed 2 Your service request has been transferred to the contractors and will be closed. Thank you. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 19TH AVE and VICENTE ST 19TH AVE 4 Parkside TARAVAL 37.739326477051 -122.475410461426 POINT (-122.47541046 37.73932648) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
312045 312045 9627154 2018-10-04T13:20:00 2018-12-05T08:00:00 2018-12-05T08:00:00 Closed 2 Your service order has been inspected by landscape, transferred out as - Private Property DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of YERBA BUENA AVE and MIRALOMA DR YERBA BUENA AVE 7 Monterey Heights INGLESIDE 37.735179901123 -122.460479736328 POINT (-122.46047974 37.7351799) Phone     9 8 41 4 9 4 59 7 40 40       8             1          
355738 355738 8448793 2017-12-31T23:05:00   2017-12-31T23:40:02 Open 1 accepted DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 19TH AVE and TARAVAL ST 19TH AVE 7 Parkside TARAVAL 37.743053436279 -122.47564697265601 POINT (-122.47564697 37.74305344) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
486305 486305 4292315 2014-12-11T08:28:46 2014-12-29T11:38:00 2014-12-29T11:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
543968 543968 374779 2009-02-19T12:46:01 2010-03-26T13:56:41 2010-03-26T13:56:41 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
547835 547835 9897323 2018-12-05T22:28:00 2019-06-25T16:23:35 2019-06-25T16:23:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
568830 568830 10717337 2019-04-11T14:54:00   2019-05-13T06:35:01 Open 1 in progress DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 375 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Outer Richmond RICHMOND 37.78098866347 -122.47834928345199 POINT (-122.47834928 37.78098866) Mobile/Open311 http://mobile311.sfgov.org/reports/10717337/photos   8 4 29 2 11 9 55 6 26 26       4             2          
796807 796807 379667 2009-02-27T12:41:38 2010-03-26T13:56:42 2010-03-26T13:56:42 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
828321 828321 532703 2009-10-26T16:27:08 2011-03-17T12:09:52 2011-03-17T12:09:52 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
973266 973266 759589 2010-10-25T22:27:01 2011-03-17T12:08:46 2011-03-17T12:08:46 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1163868 1163868 893282 2011-06-03T07:37:29   2011-06-03T08:42:44 Open 1 Open 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) Web                                                        
1199815 1199815 894565 2011-06-05T15:24:34   2011-06-05T16:09:38 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1269000 1269000 1111743 2012-04-24T17:46:03   2012-04-25T09:54:48 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1312541 1312541 1063243 2012-02-12T11:25:27   2012-02-12T12:23:16 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1389941 1389941 1176640 2012-07-28T02:33:46   2014-10-09T07:04:00 Open 1 scheduled DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1803037 1803037 3646040 2014-05-15T14:45:34   2014-05-15T15:26:49 Open 1 new DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1828586 1828586 3819005 2014-07-11T14:23:11 2015-01-02T07:14:00 2015-01-02T07:14:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of MIRALOMA DR and YERBA BUENA AVE MIRALOMA DR 7 Monterey Heights INGLESIDE 37.735178344315 -122.460478843818 POINT (-122.46047884 37.73517834) Phone     9 8 41 4 9 4 59 7 40 40       8             1          
1924697 1924697 4152500 2014-10-28T09:15:19 2014-12-08T02:15:59 2014-12-08T02:15:59 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1930607 1930607 4274287 2014-12-05T15:29:56 2016-06-20T08:05:28 2016-06-20T08:05:28 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1931118 1931118 4038194 2014-09-22T20:31:26 2014-09-26T07:53:30 2014-09-26T07:53:30 Closed 2 cancelled: This location is under Rec and Park or the Olympic Club. This area is not under DPW responsibility. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of JOHN MUIR DR and LAKE MERCED BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
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          
1938944 1938944 4039133 2014-09-23T08:51:29 2016-06-20T07:49:18 2016-06-20T07:49:18 Closed 2 All the trees on 1800 block of Pierce are Privately owned/maintained DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1940864 1940864 4081348 2014-10-06T13:59:08 2015-02-06T06:08:00 2015-02-06T06:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1942205 1942205 3942185 2014-08-22T14:41:23 2014-09-22T01:49:20 2014-09-22T01:49:20 Closed 2 cancelled: No hazard found DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
1942660 1942660 4348667 2014-12-31T08:14:01 2016-06-20T08:00:43 2016-06-20T08:00:43 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JOHN MUIR DR and LAKE MERCED BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.708084106445 -122.48572540283199 POINT (-122.4857254 37.70808411) Phone                 28,589                                      
1946061 1946061 3974878 2014-09-02T14:40:33 2014-09-30T12:57:11 2014-09-30T12:57:11 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1951286 1951286 4375721 2015-01-08T15:48:07 2015-02-02T09:01:00 2015-02-02T09:01:00 Closed 2 resolved: Work was performed on an overtime shit on Sunday 01/25/15 DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781257629395 -122.458862304688 POINT (-122.4588623 37.78125763) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
1953248 1953248 3941651 2014-08-22T12:55:57 2014-09-10T12:48:03 2014-09-10T12:48:03 Closed 2 resolved: DPW did no work to this tree at all we do not top Bottlebrush trees we only raise the skirt DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1961440 1961440 3981394 2014-09-04T14:01:26 2014-09-05T01:59:42 2014-09-05T01:59:42 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) Web                                                        
1968280 1968280 4155876 2014-10-29T08:32:17 2015-02-26T12:15:30 2015-02-26T12:15:30 Closed 2 cancelled: complaint was given to contractor and in October the contractor did send guy to litter pick area DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1968499 1968499 4313454 2014-12-18T08:12:17 2016-06-20T07:59:18 2016-06-20T07:59:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
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                                                        
1974795 1974795 3978235 2014-09-03T14:40:53 2014-09-05T02:11:28 2014-09-05T02:11:28 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1987060 1987060 4041997 2014-09-23T18:54:45 2014-09-30T01:01:50 2014-09-30T01:01:50 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1987997 1987997 3941376 2014-08-22T12:02:51 2014-08-22T04:24:49 2014-08-22T04:24:49 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
1989938 1989938 4105897 2014-10-14T09:45:59 2016-06-20T07:53:35 2016-06-20T07:53:35 Closed 2 Tree is privately maintained and responsibility of home owner DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1991722 1991722 3972728 2014-09-01T22:20:41 2014-09-10T09:50:47 2014-09-10T09:50:47 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1992799 1992799 4011640 2014-09-14T17:42:07 2014-11-29T01:52:10 2014-11-29T01:52:10 Closed 2 resolved: joe Park Merced is way out by the Pacific Ocean(Robs Area) - Tom-Please note there is job number to charge to. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1997444 1997444 4011666 2014-09-14T17:50:53 2014-09-30T01:10:51 2014-09-30T01:10:51 Closed 2 resolved: Unsure if City or Privately Owned-- DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2002309 2002309 4065422 2014-10-01T10:45:18 2015-01-02T08:34:46 2015-01-02T08:34:46 Closed 2 cancelled: Inspected location trees just trimmed in November 2014 not work needed - 0 DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2017299 2017299 3959233 2014-08-28T06:58:10 2014-09-24T06:50:34 2014-09-24T06:50:34 Closed 2 resolved: No city maintain trees on the 1200 block of Taylor Street DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2022441 2022441 4296089 2014-12-12T08:34:55 2014-12-29T11:08:00 2014-12-29T11:08:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023753 2023753 4066053 2014-10-01T13:32:49 2014-10-16T12:58:31 2014-10-16T12:58:31 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023982 2023982 3949041 2014-08-25T09:46:49 2014-09-24T01:51:13 2014-09-24T01:51:13 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2029364 2029364 3989423 2014-09-07T18:02:38 2014-10-07T02:06:11 2014-10-07T02:06:11 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2047713 2047713 4297940 2014-12-12T15:27:11 2014-12-15T12:39:00 2014-12-15T12:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 7TH AVE and FULTON ST 7TH AVE 1 Inner Richmond RICHMOND 37.773487091064 -122.464813232422 POINT (-122.46481323 37.77348709) Phone     8 4 12 2 11 9 54 6 8 8 6     4 7     7     1          
2054000 2054000 4018281 2014-09-16T14:06:34 2014-12-08T02:14:32 2014-12-08T02:14:32 Closed 2 resolved: cleared signs DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2056571 2056571 4597346 2015-03-22T22:21:05 2015-04-02T07:04:00 2015-04-02T07:04:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ANZA ST and 19TH AVE ANZA ST 1 Inner Richmond RICHMOND 37.778457641602 -122.478164672852 POINT (-122.47816467 37.77845764) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
2062634 2062634 4630858 2015-04-02T12:51:21 2015-04-03T07:42:00 2015-04-03T07:42:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MARKET ST and 10TH ST MARKET ST 6 Civic Center TENDERLOIN 37.77654009327 -122.41750124396799 POINT (-122.41750124 37.77654009) Phone     5 10 34 9 8 2 28,853 2 34 34     1 10     1   8 1 2 1 1 35    
2065689 2065689 4463860 2015-02-05T16:09:15 2015-02-28T12:38:00 2015-02-28T12:38:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Pink Triangle Park, , SAN FRANCISCO, CA         0.0 0.0 POINT (0 0) Phone                                                        
2083285 2083285 4549563 2015-03-05T17:23:46 2015-04-16T11:51:00 2015-04-16T11:51:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ARGUELLO BLVD and EUCLID AVE ARGUELLO BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.783825889684 -122.459046104263 POINT (-122.4590461 37.78382589) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
2085494 2085494 4466912 2015-02-06T15:05:27 2015-02-17T11:30:12 2015-02-17T11:30:12 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 PRAGUE ST, SAN FRANCISCO, CA, 94112 PRAGUE ST 11 Excelsior INGLESIDE 37.722045164320996 -122.424661354152 POINT (-122.42466135 37.72204516) Phone     9 1 19 6 9 4 28,861 7 18 18       1             2          
2091336 2091336 4717579 2015-05-04T10:14:25 2015-08-06T12:37:00 2015-08-06T12:37:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2107526 2107526 4821764 2015-06-12T09:53:05 2015-08-06T12:39:00 2015-08-06T12:39:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2119722 2119722 4792828 2015-06-01T22:53:46 2015-11-05T09:28:00 2015-11-05T09:28:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
2151478 2151478 4766929 2015-05-22T08:37:44 2015-06-03T10:11:00 2015-06-03T10:11:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ARGUELLO BLVD and GEARY BLVD ARGUELLO BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
2159286 2159286 4391816 2015-01-14T05:33:16 2015-03-04T09:29:00 2015-03-04T09:29:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
2184944 2184944 4468980 2015-02-07T09:30:04 2016-06-20T07:30:25 2016-06-20T07:30:25 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2193980 2193980 5142280 2015-09-29T10:11:42 2015-10-31T17:44:31 2015-10-31T17:44:31 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
2200106 2200106 5157307 2015-10-03T16:57:53 2015-10-21T09:26:18 2015-10-21T09:26:18 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 426 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
2206060 2206060 5200900 2015-10-18T17:47:04 2015-10-20T02:53:00 2015-10-20T02:53:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of VAN NESS AVE and CHESTNUT ST VAN NESS AVE 2 Union Street NORTHERN 37.802278920781 -122.424733311986 POINT (-122.42473331 37.80227892) Phone     4 6 13 1 5 6 28,858 9 17 17       6             1          
2230763 2230763 5157262 2015-10-03T16:40:08 2015-10-21T09:28:13 2015-10-21T09:28:13 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 426 19TH AVE, SAN FRANCISCO, CA, 94121 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
2238871 2238871 4983855 2015-08-10T12:22:39 2015-08-12T10:18:00 2015-08-12T10:18:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2245426 2245426 5092894 2015-09-13T13:15:07 2015-11-05T09:33:00 2015-11-05T09:33:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of ARGUELLO BLVD and GEARY BLVD ARGUELLO BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
2296093 2296093 5218896 2015-10-23T15:19:55 2016-01-09T03:13:00 2016-01-09T03:13:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
2302481 2302481 4904095 2015-07-13T10:49:26 2015-07-15T11:52:00 2015-07-15T11:52:00 Closed 2 resolved: 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) Web                                                        
2309584 2309584 4943026 2015-07-27T10:31:29 2015-08-06T11:43:08 2015-08-06T11:43:08 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2358787 2358787 5637975 2016-03-06T14:30:23 2016-03-11T02:52:00 2016-03-11T02:52:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2374348 2374348 5478526 2016-01-19T08:34:55 2016-01-20T07:28:36 2016-01-20T07:28:36 Closed 2 cancelled: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
2387392 2387392 5371577 2015-12-13T16:08:04 2015-12-14T07:36:00 2015-12-14T07:36:00 Closed 2 resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of VAN NESS AVE and FRANCISCO ST VAN NESS AVE 2 Marina NORTHERN 37.803203582764 -122.42491912841801 POINT (-122.42491913 37.80320358) Web     4 6 32 1 5 6 28,858 9 32 32       6             1          
2415625 2415625 5306360 2015-11-21T09:04:15 2016-06-01T04:47:00 2016-06-01T04:47: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) Web                                                        
2422975 2422975 5402492 2015-12-24T13:42:04 2016-02-26T01:39:00 2016-02-26T01:39:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2454064 2454064 5521292 2016-01-31T14:39:33 2016-02-23T03:14:00 2016-02-23T03:14:00 Closed 2 Case Resolved: DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
2483991 2483991 5657615 2016-03-11T22:23:30 2016-03-12T09:54:00 2016-03-12T09:54:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3040 FULTON ST, SAN FRANCISCO, CA, 94118 FULTON ST 1 Inner Richmond RICHMOND 37.773622411243 -122.463749926476 POINT (-122.46374993 37.77362241) Phone     8 4 12 2 11 9 29,492 6 8 8 6     4 7     7     1          
2484135 2484135 5935076 2016-06-02T12:55:36 2016-11-11T10:10:18 2016-11-11T10:10:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 150 CANYON DR, SAN FRANCISCO, CA, 94112 CANYON DR 11 Crocker Amazon INGLESIDE 37.708307331811 -122.432399881107 POINT (-122.43239988 37.70830733) Phone     9 1 7 6 9 4 28,861 7 5 5       1             2          
2489252 2489252 5842130 2016-05-07T13:57:07 2016-07-05T09:51:00 2016-07-05T09:51: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) Web                                                        
2496103 2496103 5666514 2016-03-15T09:55:48 2016-03-30T12:09:09 2016-03-30T12:09:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2509427 2509427 5703919 2016-03-27T09:48:29 2016-06-01T07:14:00 2016-06-01T07:14:00 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2527442 2527442 5920127 2016-05-29T11:53:47 2016-11-08T08:10:25 2016-11-08T08:10:25 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        

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