calls

80,878 rows sorted by Latitude

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
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
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                                                        
791417 791417 410056 2009-04-13T07:50:35 2009-04-14T06:36:51 2009-04-14T06:36:51 Closed 2 Invalid Request. Per DPW, PVT Tree. 311 Supervisor Queue 5 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                                                        
791663 791663 434546 2009-05-19T15:07:30 2009-05-29T18:12:16 2009-05-29T18:12:16 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
792635 792635 298874 2008-10-17T07:29:52 2008-10-23T14:06:51 2008-10-23T14:06:51 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                                                        
793849 793849 251402 2008-07-21T10:53:33 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                                                        
794196 794196 291377 2008-10-02T14:14:21 2010-07-08T09:17:03 2010-07-08T09:17:03 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                                                        
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                                                        
798570 798570 299090 2008-10-17T11:27:32 2008-10-17T14:06:52 2008-10-17T14:06:52 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 100 O'SHAUGHNESSY BLVD, SAN FRANCISCO, CA, 94127 OSHAUGHNESSY BLVD 0     0.0 0.0 POINT (0 0) Phone                                                        
798795 798795 356689 2009-01-22T13:26:07 2009-09-24T18:16:17 2009-09-24T18:16:17 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                                                        
800955 800955 387393 2009-03-11T12:55:51 2009-03-11T14:10:09 2009-03-11T14:10:09 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                                                        
803018 803018 463677 2009-07-06T21:47:03 2009-07-18T15:11:02 2009-07-18T15:11:02 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                                                        
803114 803114 491502 2009-08-21T19:16:53 2010-12-11T10:09:24 2010-12-11T10:09:24 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                                                        
805546 805546 546795 2009-11-17T11:55:07 2011-01-15T06:09:23 2011-01-15T06:09:23 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
806507 806507 539389 2009-11-05T18:56:55 2010-07-09T15:51:58 2010-07-09T15:51:58 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                                                        
809061 809061 524927 2009-10-15T08:30:07 2010-07-02T17:17:04 2010-07-02T17:17:04 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                                                        
814696 814696 517132 2009-10-03T19:59:57 2010-01-05T18:16:32 2010-01-05T18:16:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
815789 815789 528445 2009-10-20T11:19:37 2009-11-12T10:16:26 2009-11-12T10:16:26 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                                                        
816867 816867 617888 2010-03-11T12:56:14 2010-03-12T09:16:46 2010-03-12T09:16:46 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) Twitter                                                        
819839 819839 542754 2009-11-11T07:55:25 2010-07-09T09:17:01 2010-07-09T09:17:01 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                                                        
821478 821478 455410 2009-06-22T19:26:06 2009-07-01T17:11:00 2009-07-01T17:11:00 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                                                        
824219 824219 523453 2009-10-13T13:26:05 2009-10-23T09:16:33 2009-10-23T09:16:33 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                                                        
827016 827016 540112 2009-11-06T19:09:14 2009-11-09T09:16:25 2009-11-09T09:16:25 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
827902 827902 508188 2009-09-19T12:02:43 2011-01-13T15:09:22 2011-01-13T15:09:22 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                                                        
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                                                        
828708 828708 470110 2009-07-16T20:15:23 2009-07-17T06:11:05 2009-07-17T06:11:05 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                                                        
832578 832578 540840 2009-11-08T15:55:32 2013-03-05T04:31:51 2013-03-05T04:31:51 Closed 2 resolved: Damaged sidewalk @ 5915 & 5923 Geary. City tree roots. - X1104 # 937711,X1104 # 937712, Work completed. Refer to new photos.-NH 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                                                        
838322 838322 485014 2009-08-10T18:52:48 2009-08-20T15:11:15 2009-08-20T15:11:15 Closed 2   DPW Ops Queue 1 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                                                        
838456 838456 515641 2009-10-01T14:46:39 2009-10-01T16:16:18 2009-10-01T16:16:18 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                                                        
840256 840256 585109 2010-01-20T11:56:31 2010-10-06T16:09:37 2010-10-06T16:09:37 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                                                        
844301 844301 585099 2010-01-20T11:50:44 2010-10-06T16:09:36 2010-10-06T16:09:36 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                                                        
844849 844849 539636 2009-11-06T09:48:18 2009-11-06T11:28:36 2009-11-06T11:28:36 Closed 2 duplicate original sr#510331 9/23/09 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
845325 845325 532733 2009-10-26T17:01:09 2010-03-15T15:16:40 2010-03-15T15:16:40 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                                                        
846127 846127 521272 2009-10-10T09:11:07 2009-10-16T11:16:21 2009-10-16T11:16:21 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                                                        
846734 846734 539891 2009-11-06T14:48:40 2012-03-28T06:07:18 2012-03-28T06:07:18 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                                                        
848076 848076 520780 2009-10-09T11:33:54 2010-07-08T10:17:04 2010-07-08T10:17:04 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                                                        
848245 848245 533559 2009-10-28T05:40:16 2012-03-29T12:07:05 2012-03-29T12:07:05 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                                                        
850485 850485 547911 2009-11-18T22:34:42 2009-11-19T06:16:26 2009-11-19T06:16:26 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                                                        
850816 850816 528317 2009-10-20T09:50:07 2015-09-04T12:00:00 2015-09-04T12:00:00 Closed 2 resolved: Request closed by SES . Notes = " BUF Action:Repair Sidewalk. date completed - 9/4/2015. ". 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                                                        
851501 851501 490693 2009-08-20T14:43:09 2009-08-20T16:11:11 2009-08-20T16:11:11 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                                                        
851726 851726 547578 2009-11-18T11:49:15 2009-12-19T06:16:36 2009-12-19T06:16:36 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                                                        
852846 852846 506316 2009-09-16T12:13:33 2009-10-07T09:17:01 2009-10-07T09:17:01 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                                                        
853958 853958 486126 2009-08-12T16:28:55 2010-01-13T11:41:32 2010-01-13T11:41:32 Closed 2   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                                                        
856806 856806 501425 2009-09-08T15:20:57 2010-07-02T16:17:11 2010-07-02T16:17:11 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                                                        
859939 859939 525083 2009-10-15T11:06:29 2009-10-22T10:16:22 2009-10-22T10:16:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
860374 860374 529797 2009-10-22T08:56:48 2009-10-23T07:16:21 2009-10-23T07:16:21 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                                                        
860927 860927 498938 2009-09-03T14:35:42 2009-09-18T09:11:21 2009-09-18T09:11:21 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                                                        
862197 862197 464100 2009-07-07T14:28:22 2011-03-17T13:02:16 2011-03-17T13:02:16 Closed 2 Confirmed with DPW - work previously completed. 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                                                        
863776 863776 586793 2010-01-22T16:26:21 2010-01-23T06:16:51 2010-01-23T06:16:51 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                                                        
864180 864180 525276 2009-10-15T14:12:54 2009-10-16T06:16:23 2009-10-16T06:16:23 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                                                        
866317 866317 605627 2010-02-19T17:32:23 2010-02-22T06:16:45 2010-02-22T06:16:45 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                                                        
867792 867792 483692 2009-08-08T12:35:37 2009-08-22T06:11:29 2009-08-22T06:11:29 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                                                        
870733 870733 459025 2009-06-29T09:00:25 2012-12-04T17:00:38 2012-12-04T17:00:38 Closed 2 resolved: Request closed by SES . Notes = " Notes:Mailed Dead Tree Letter 12/4/12 DM. BUF Action:Correspondence. date completed - 12/4/2012. ". DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 100 LUNDY'S LN, SAN FRANCISCO, CA, 94110 LUNDY'S LN 0     0.0 0.0 POINT (0 0) Phone                                                        
871121 871121 565421 2009-12-18T12:59:09 2009-12-18T15:16:36 2009-12-18T15:16:36 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
871878 871878 477504 2009-07-29T12:37:49 2009-07-29T14:11:14 2009-07-29T14:11:14 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                                                        
874567 874567 519669 2009-10-07T16:30:24 2010-11-18T16:54:28 2010-11-18T16:54:28 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                                                        
876073 876073 528163 2009-10-19T22:00:54 2009-10-20T06:16:22 2009-10-20T06:16:22 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                                                        
877885 877885 494818 2009-08-27T18:10:41 2009-09-01T12:11:22 2009-09-01T12:11:22 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                                                        
879378 879378 498300 2009-09-02T16:06:47 2017-05-03T15:25:15 2017-05-03T15:25:15 Closed 2 Tree has been removed 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                                                        
879849 879849 583872 2010-01-18T18:41:09 2010-01-21T13:16:33 2010-01-21T13:16:33 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                                                        
881861 881861 563572 2009-12-15T11:00:31 2010-10-26T06:09:46 2010-10-26T06:09:46 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                                                        
882732 882732 549320 2009-11-20T17:32:41 2009-12-16T11:16:29 2009-12-16T11:16:29 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                                                        
883609 883609 523623 2009-10-13T14:56:41 2009-10-20T08:16:22 2009-10-20T08:16:22 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 19 SAINT MARY'S AVE, SAN FRANCISCO, CA, 94112 SAINT MARY'S AVE 0     0.0 0.0 POINT (0 0) Phone                                                        
887411 887411 482506 2009-08-06T12:46:13 2009-09-02T08:11:19 2009-09-02T08:11:19 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                                                        
887448 887448 508752 2009-09-20T18:48:48 2010-12-13T18:09:22 2010-12-13T18:09:22 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                                                        
888192 888192 526775 2009-10-17T18:57:05 2010-02-19T09:16:50 2010-02-19T09:16:50 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                                                        
889216 889216 530139 2009-10-22T14:16:23 2010-01-05T14:16:31 2010-01-05T14:16:31 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
891438 891438 494107 2009-08-26T15:08:23 2009-11-09T09:16:27 2009-11-09T09:16:27 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                                                        
892121 892121 512840 2009-09-27T14:24:21 2009-10-02T08:47:20 2009-10-02T08:47:20 Closed 2 ucsf - Mission Bay 415-476-5343 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 3RD ST and MISSION BAY NORTH BLVD 3RD ST 6 Mission Bay SOUTHERN 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 69.89ms