calls

80,878 rows sorted by :@computed_region_vtsz_7cme

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
673859 673859 295106 2008-10-09T12:19:30 2010-06-26T19:17:04 2010-06-26T19:17:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
675184 675184 402105 2009-03-31T16:20:59 2009-05-29T18:20:50 2009-05-29T18:20:50 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) Phone                                                        
676942 676942 423028 2009-05-01T16:21:33 2009-08-25T12:26:22 2009-08-25T12:26:22 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
677320 677320 279403 2008-09-10T14:24:29 2008-11-19T16:06:57 2008-11-19T16:06:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
677520 677520 422425 2009-04-30T19:07:31 2017-05-03T14:25:34 2017-05-03T14:25:34 Closed 2 planting request exists & site was recently backfilled DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
677772 677772 295736 2008-10-10T14:00:18 2009-06-01T12:10:42 2009-06-01T12:10:42 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
678767 678767 279095 2008-09-10T09:27:47   2008-09-10T09:47:00 Open 1 Open DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
680512 680512 411512 2009-04-15T07:46:34 2009-05-03T12:10:31 2009-05-03T12:10:31 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794708251953004 -122.446723937988 POINT (-122.44672394 37.79470825) Phone     4 6 13 1 13 6 57 9 17 17       6             1          
682243 682243 412319 2009-04-16T09:57:00 2009-04-17T13:10:25 2009-04-17T13:10:25 Closed 2   DPW Ops Queue 1 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) Phone                                                        
682693 682693 392506 2009-03-19T13:02:12 2009-09-03T12:11:15 2009-09-03T12:11:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
683924 683924 414435 2009-04-19T16:17:07 2009-04-19T18:10:25 2009-04-19T18:10:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of DUBOCE AVE and GUERRERO ST DUBOCE AVE 8 Mint Hill MISSION 37.769733428955 -122.42458343505899 POINT (-122.42458344 37.76973343) Phone     3 5 20 5 8 7 28,853 4 19 19       5             2          
684312 684312 282880 2008-09-17T07:11:53 2010-07-26T16:17:02 2010-07-26T16:17:02 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) Phone                                                        
684629 684629 426176 2009-05-06T12:02:57 2010-04-13T06:16:52 2010-04-13T06:16:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
686653 686653 302439 2008-10-23T15:47:49 2008-10-29T10:06:52 2008-10-29T10:06:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
686832 686832 363270 2009-01-31T14:18:02 2009-02-04T09:09:55 2009-02-04T09:09:55 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
688190 688190 314596 2008-11-14T20:44:11 2008-11-20T11:50:03 2008-11-20T11:50:03 Closed 2 As of 11/19/08 water had been shut off. RPD Neighborhood Service Area 7 Queue 38 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues India Basin/Shoreline Park, SAN FRANCISCO, CA India Basin/Shoreline Park 10 India Basin BAYVIEW 37.733661651611 -122.37371826171899 POINT (-122.37371826 37.73366165) Phone     2 9   8   3   3           9                        
690435 690435 309503 2008-11-05T14:51:39 2010-06-25T14:16:56 2010-06-25T14:16:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
690485 690485 440196 2009-05-29T15:43:25 2011-08-31T10:05:36 2011-08-31T10:05:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
690827 690827 250375 2008-07-18T15:13:03 2008-07-26T16:04:49 2008-07-26T16:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 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                                      
691883 691883 370158 2009-02-11T09:10:20 2012-06-11T13:30:45 2012-06-11T13:30:45 Closed 2 resolved: Request closed by SES . Notes = " Notes:completed through ASAP. BUF Action:REPAIR SWK. date completed - 6/7/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
692207 692207 254681 2008-07-26T19:15:36 2012-07-18T10:16:52 2012-07-18T10:16:52 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Intersection of 19TH AVE and CALIFORNIA ST 19TH AVE 1 Outer Richmond RICHMOND 37.784175872803004 -122.47857666015601 POINT (-122.47857666 37.78417587) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
692623 692623 392996 2009-03-20T11:00:30 2015-03-31T06:51:38 2015-03-31T06:51:38 Closed 2 resolved: DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
693157 693157 320077 2008-11-25T08:10:20 2008-11-26T07:07:00 2008-11-26T07:07:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
695070 695070 418984 2009-04-25T17:35:28 2009-04-25T18:10:25 2009-04-25T18:10:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
695234 695234 426870 2009-05-07T11:38:37 2009-06-04T08:10:45 2009-06-04T08:10:45 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
697143 697143 389833 2009-03-15T18:16:15 2009-03-15T20:10:10 2009-03-15T20:10:10 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
701130 701130 387516 2009-03-11T15:39:12 2009-03-16T13:10:09 2009-03-16T13:10:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
706097 706097 346262 2009-01-07T08:29:26 2009-01-07T09:07:09 2009-01-07T09:07:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
708951 708951 290563 2008-10-01T11:50:19 2008-12-17T10:07:04 2008-12-17T10:07:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of LISBON ST and SILVER AVE LISBON ST 11 Mission Terrace INGLESIDE 37.728534698486 -122.428665161133 POINT (-122.42866516 37.7285347) Phone     9 1 7 6 9 4 28,861 7 5 5 16     1             2          
710680 710680 414077 2009-04-18T16:12:02 2009-04-22T06:22:28 2009-04-22T06:22:28 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
712181 712181 376649 2009-02-23T06:47:07 2009-05-29T18:22:19 2009-05-29T18:22:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
714312 714312 398612 2009-03-26T10:20:31 2009-03-26T11:10:19 2009-03-26T11:10:19 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
715447 715447 282984 2008-09-17T10:01:45   2016-06-10T13:43:44 Open 1 SENT DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
717304 717304 409963 2009-04-12T19:12:28 2011-09-07T07:45:44 2011-09-07T07:45:44 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
719026 719026 267158 2008-08-19T13:05:26 2008-08-28T16:05:26 2008-08-28T16:05:26 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 7 RICHARDS CT, SAN FRANCISCO, CA, 94124 RICHARDS CT 0     0.0 0.0 POINT (0 0) Phone                                                        
719703 719703 339112 2008-12-26T13:13:23 2010-01-12T08:16:35 2010-01-12T08:16:35 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
719814 719814 353450 2009-01-17T10:35:31 2010-08-16T16:19:07 2010-08-16T16:19:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
720286 720286 450316 2009-06-15T09:30:44 2009-06-22T10:10:50 2009-06-22T10:10:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
723793 723793 334448 2008-12-17T17:23:16 2010-10-02T19:09:41 2010-10-02T19:09:41 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
724704 724704 377470 2009-02-24T07:34:21 2009-03-09T09:10:15 2009-03-09T09:10:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
725174 725174 255388 2008-07-28T13:06:32 2008-07-29T10:04:47 2008-07-29T10:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
725436 725436 402692 2009-04-01T13:11:57 2011-09-07T07:45:39 2011-09-07T07:45:39 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
725729 725729 432441 2009-05-15T20:10:34 2010-11-22T10:59:53 2010-11-22T10:59:53 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
726770 726770 344895 2009-01-05T12:48:04 2009-06-25T11:10:51 2009-06-25T11:10:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
727659 727659 437259 2009-05-24T17:49:21 2009-05-29T18:11:24 2009-05-29T18:11:24 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
728456 728456 401513 2009-03-31T06:37:59 2017-06-19T12:30:43 2017-06-19T12:30:43 Closed 2 Pending; Forwarded to BUF Inspector. //// all new concrete in 2011 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
730298 730298 302818 2008-10-24T13:26:40 2009-03-12T10:10:08 2009-03-12T10:10:08 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
732233 732233 251411 2008-07-21T10:57:42 2008-07-23T09:04:17 2008-07-23T09:04:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
733245 733245 381689 2009-03-02T15:54:38 2009-03-09T11:10:11 2009-03-09T11:10:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 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          
735906 735906 423819 2009-05-03T11:08:10 2009-05-03T12:10:31 2009-05-03T12:10:31 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794708251953004 -122.446723937988 POINT (-122.44672394 37.79470825) Phone     4 6 13 1 13 6 57 9 17 17       6             1          
736942 736942 381529 2009-03-02T14:07:09 2009-03-06T09:10:04 2009-03-06T09:10:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
738495 738495 393163 2009-03-20T14:00:35 2009-05-29T18:16:30 2009-05-29T18:16:30 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
739308 739308 337354 2008-12-22T19:41:57 2017-05-04T13:30:39 2017-05-04T13:30:39 Closed 2 sidewalk has been repaired DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
739559 739559 411247 2009-04-14T16:15:50 2009-05-29T17:16:14 2009-05-29T17:16:14 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
740071 740071 417673 2009-04-23T16:18:40 2010-11-22T10:59:52 2010-11-22T10:59:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
742410 742410 317073 2008-11-19T14:27:48 2008-11-20T06:07:01 2008-11-20T06:07:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
744437 744437 397983 2009-03-25T11:41:58 2009-04-22T06:22:15 2009-04-22T06:22:15 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
745291 745291 273099 2008-08-29T17:09:23 2008-11-03T11:06:52 2008-11-03T11:06:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 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          
746067 746067 297747 2008-10-15T10:18:23 2008-10-29T09:24:27 2008-10-29T09:24:27 Closed 2 DUPLICATE, CLOSED PER NOTES. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
747299 747299 287470 2008-09-25T11:48:24 2008-10-23T13:06:51 2008-10-23T13:06:51 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of 19TH AVE and WAWONA ST 19TH AVE 4 Parkside TARAVAL 37.737453460693004 -122.475288391113 POINT (-122.47528839 37.73745346) Phone     10 8 41 4 1 5 29,491 8 40 40       8             1          
747635 747635 324780 2008-12-03T14:23:55 2008-12-05T17:07:02 2008-12-05T17:07:02 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
748047 748047 430790 2009-05-13T14:10:58 2009-05-15T15:10:36 2009-05-15T15:10:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
748199 748199 376876 2009-02-23T11:07:03 2009-03-06T14:10:04 2009-03-06T14:10:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
748355 748355 241223 2008-07-02T11:29:23 2008-07-02T15:05:08 2008-07-02T15:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
750301 750301 412181 2009-04-16T03:15:25 2009-05-11T08:10:34 2009-05-11T08:10:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of FELL ST and FILLMORE ST FELL ST 5 Hayes Valley NORTHERN 37.77490234375 -122.431015014648 POINT (-122.43101501 37.77490234) Phone     4 11 9 11 7 6 29,492 9 10 10       11             1          
751956 751956 305310 2008-10-29T07:22:27 2008-10-29T08:04:23 2008-10-29T08:04:23 Closed 2   311 Supervisor Queue 5 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) Phone                                                        
752267 752267 437033 2009-05-24T08:20:01 2009-05-30T08:20:54 2009-05-30T08:20:54 Closed 2 Invalid Request. Unable to locate 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
754653 754653 256281 2008-07-29T19:39:46 2008-08-15T13:04:52 2008-08-15T13:04:52 Closed 2 See Notes tab for more details 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) Phone                                                        
757482 757482 421081 2009-04-28T17:53:34 2009-12-15T09:16:29 2009-12-15T09:16:29 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
757921 757921 277871 2008-09-08T10:51:27 2008-09-09T13:07:27 2008-09-09T13:07:27 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of DUBOCE AVE and GUERRERO ST DUBOCE AVE 8 Mint Hill MISSION 37.769733428955 -122.42458343505899 POINT (-122.42458344 37.76973343) Phone     3 5 20 5 8 7 28,853 4 19 19       5             2          
757935 757935 406654 2009-04-07T08:19:01 2009-05-29T17:21:52 2009-05-29T17:21:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
758804 758804 255925 2008-07-29T10:32:06 2008-08-07T12:04:57 2008-08-07T12:04:57 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
759287 759287 380657 2009-02-28T22:45:11 2009-03-12T08:10:11 2009-03-12T08:10:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of LISBON ST and SILVER AVE LISBON ST 11 Mission Terrace INGLESIDE 37.728534698486 -122.428665161133 POINT (-122.42866516 37.7285347) Phone     9 1 7 6 9 4 28,861 7 5 5 16     1             2          
760053 760053 398543 2009-03-26T09:18:58 2010-07-02T13:17:00 2010-07-02T13:17:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of TUNNEL AVE and TUNNEL AVE 10 Little Hollywood BAYVIEW 37.708377838135 -122.401313781738 POINT (-122.40131378 37.70837784) Phone       9   8 10   309             9                        
762052 762052 338623 2008-12-24T19:31:00 2008-12-24T19:49:53 2008-12-24T19:49:53 Closed 2 invalid address. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
762076 762076 363268 2009-01-31T14:15:50 2009-02-04T09:09:52 2009-02-04T09:09:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of MARIPOSA ST and POTRERO AVE MARIPOSA ST 10 Mission MISSION 37.763187408446996 -122.40730285644501 POINT (-122.40730286 37.76318741) Phone     3 9 20 8 8 7 28,859 4 19 19       9     3   15   2   3      
762741 762741 430822 2009-05-13T14:46:09 2012-09-24T15:56:24 2012-09-24T15:56:24 Closed 2 resolved: Request closed by SES . Notes = " Notes:Paved basin per google 4/2011 DM. date completed - 9/24/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
763295 763295 343614 2009-01-03T10:09:00 2009-01-03T12:07:16 2009-01-03T12:07:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
764853 764853 436037 2009-05-22T06:50:23 2009-05-29T17:27:11 2009-05-29T17:27:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
765057 765057 297290 2008-10-14T13:41:49 2010-06-26T19:17:04 2010-06-26T19:17:04 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of MIRALOMA DR and YERBA BUENA AVE MIRALOMA DR 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          
765181 765181 364653 2009-02-02T17:14:39 2009-02-05T16:09:50 2009-02-05T16:09:50 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
766634 766634 286892 2008-09-24T13:47:35 2008-09-24T13:54:53 2008-09-24T13:54:53 Closed 2 TEST ONLY DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
767567 767567 429224 2009-05-11T14:37:05 2009-05-12T16:10:34 2009-05-12T16:10:34 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 263 MALLORCA WY, SAN FRANCISCO, CA, 94123 MALLORCA WY 0     0.0 0.0 POINT (0 0) Phone                                                        
771187 771187 294257 2008-10-08T08:40:05 2010-07-30T17:17:03 2010-07-30T17:17:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
771396 771396 428701 2009-05-10T17:46:00 2009-06-10T14:10:52 2009-06-10T14:10:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
771705 771705 400775 2009-03-30T10:26:56 2009-04-07T06:27:32 2009-04-07T06:27:32 Closed 2 Invalid Request. Privately owned tree. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
773519 773519 427144 2009-05-07T16:45:19 2009-05-29T18:12:14 2009-05-29T18:12:14 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
773692 773692 393232 2009-03-20T15:28:10 2009-03-27T06:10:17 2009-03-27T06:10:17 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
774728 774728 261426 2008-08-07T15:50:44 2009-08-04T10:11:07 2009-08-04T10:11:07 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
774799 774799 330709 2008-12-12T06:57:03 2009-01-13T06:07:09 2009-01-13T06:07:09 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of DUBOCE AVE and GUERRERO ST DUBOCE AVE 8 Mint Hill MISSION 37.769733428955 -122.42458343505899 POINT (-122.42458344 37.76973343) Phone     3 5 20 5 8 7 28,853 4 19 19       5             2          
775894 775894 439903 2009-05-29T10:44:46 2009-06-11T13:10:47 2009-06-11T13:10:47 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
777444 777444 351849 2009-01-14T20:10:04 2009-02-19T12:09:59 2009-02-19T12:09:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
779895 779895 345852 2009-01-06T14:50:01 2009-01-13T08:07:16 2009-01-13T08:07:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
783905 783905 265389 2008-08-15T14:55:57 2008-10-16T16:47:14 2008-10-16T16:47:14 Closed 2   DPW Ops Queue 1 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) Phone                                                        
787177 787177 280287 2008-09-12T02:30:27 2008-09-12T13:56:47 2008-09-12T13:56:47 Closed 2 could not locate If this problem persists, caller should call back with very specific location information RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH AVE and FULTON ST 5TH AVE 1 Inner Richmond RICHMOND 37.77375793457 -122.462684631348 POINT (-122.46268463 37.77375793) Phone     8 4 12 2 11 9 29,492 6 8 8 6     4 7     7     1          
788041 788041 440768 2009-05-30T17:47:05 2009-07-18T14:11:03 2009-07-18T14:11:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
789089 789089 371767 2009-02-13T15:51:55 2009-03-06T15:10:06 2009-03-06T15:10:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
789558 789558 436484 2009-05-22T17:09:23 2009-05-29T17:51:32 2009-05-29T17:51:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
789864 789864 269587 2008-08-23T16:36:43 2010-06-25T13:17:00 2010-06-25T13:17:00 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
790553 790553 311973 2008-11-10T13:47:59 2009-03-12T10:10:16 2009-03-12T10:10:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 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 89.758ms