calls

7,158 rows where Responsible_Agency = 2 sorted by Updated

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
790940 790940 267730 2008-08-20T12:08:19 2008-09-15T22:58:07 2008-09-15T22:58:07 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 350 LAGUNA HONDA BLVD, SAN FRANCISCO, CA, 94116 LAGUNA HONDA BLVD 7 Forest Hill PARK 37.748394012451 -122.459312438965 POINT (-122.45931244 37.74839401) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
776317 776317 334801 2008-12-18T10:54:55 2009-01-29T15:02:09 2009-01-29T15:02:09 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 23RD ST and CAROLINA ST 23RD ST 10 Potrero Hill BAYVIEW 37.754680633545 -122.39973449706999 POINT (-122.3997345 37.75468063) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
779651 779651 292108 2008-10-03T17:48:20 2009-08-27T18:11:15 2009-08-27T18:11:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 280 CHENERY ST, SAN FRANCISCO, CA, 94131 CHENERY ST 8 Fairmount INGLESIDE 37.737674713135 -122.42716217041 POINT (-122.42716217 37.73767471) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
807359 807359 505163 2009-09-14T15:13:42 2009-09-30T15:16:26 2009-09-30T15:16:26 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1325 GREENWICH ST, SAN FRANCISCO, CA, 94109 GREENWICH ST 2 Russian Hill NORTHERN 37.800647735596 -122.42153930664101 POINT (-122.42153931 37.80064774) Phone   107 4 6 32 1 13 6 28,858 9 32 32   107   6             1         107
812945 812945 523846 2009-10-13T17:16:22 2010-01-19T09:16:35 2010-01-19T09:16:35 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1050 FELL ST, SAN FRANCISCO, CA, 94117 FELL ST 5 Alamo Square NORTHERN 37.774482727051 -122.43514251709 POINT (-122.43514252 37.77448273) Phone   23 4 11 9 11 15 8 29,492 5 10 10   23   11             1         23
784125 784125 260648 2008-08-06T12:52:18 2010-03-26T13:53:36 2010-03-26T13:53:36 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility Intersection of OSHAUGHNESSY BLVD and PORTOLA DR OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.745532989502 -122.451622009277 POINT (-122.45162201 37.74553299) Phone   72 9 5 10 5 1 4 59 7 7 7   72   5             1         72
765003 765003 269080 2008-08-22T15:07:53 2010-03-26T13:53:37 2010-03-26T13:53:37 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of LAKE MERCED BLVD and SUNSET BLVD LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.729595184326 -122.49346923828101 POINT (-122.49346924 37.72959518) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
735523 735523 281889 2008-09-15T13:04:13 2010-03-26T13:53:40 2010-03-26T13:53:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request John McLaren Park, SAN FRANCISCO, CA, 94134 John McLaren Park 10 McLaren Park INGLESIDE 37.718082427979 -122.41907501220699 POINT (-122.41907501 37.71808243) Phone   73 9 9 19 8 9 4 309 7 18 18   73   9             2         73
767966 767966 309406 2008-11-05T12:52:54 2010-03-26T13:56:13 2010-03-26T13:56:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1620 LAWTON ST, SAN FRANCISCO, CA, 94122 LAWTON ST 4 Outer Sunset TARAVAL 37.757926940918004 -122.48040771484399 POINT (-122.48040771 37.75792694) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
713547 713547 314864 2008-11-15T14:26:07 2010-03-26T13:56:15 2010-03-26T13:56:15 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of LAKE MERCED BLVD and SKYLINE BLVD LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.732269287109 -122.49810791015601 POINT (-122.49810791 37.73226929) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
738949 738949 365423 2009-02-03T15:54:11 2010-03-26T13:56:36 2010-03-26T13:56:36 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 410 LOCUST ST, SAN FRANCISCO, CA, 94118 LOCUST ST 2 Presidio Heights RICHMOND 37.787174224854 -122.451713562012 POINT (-122.45171356 37.78717422) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
665095 665095 374044 2009-02-18T11:46:39 2010-03-26T13:56:40 2010-03-26T13:56:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2324 CHESTNUT ST, SAN FRANCISCO, CA, 94123 CHESTNUT ST 2 Marina NORTHERN 37.800231933594 -122.44171142578101 POINT (-122.44171143 37.80023193) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
670279 670279 370942 2009-02-12T12:57:12 2010-03-26T13:56:40 2010-03-26T13:56:40 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 422 2ND AVE, SAN FRANCISCO, CA, 94118 2ND AVE 1 Inner Richmond RICHMOND 37.780681610107 -122.459800720215 POINT (-122.45980072 37.78068161) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
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                                                        
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                                                        
745355 745355 387400 2009-03-11T13:02:45 2010-03-26T13:56:45 2010-03-26T13:56:45 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 901 MONTEREY BLVD, SAN FRANCISCO, CA, 94112 MONTEREY BLVD 7 Westwood Park INGLESIDE 37.731185913086 -122.455909729004 POINT (-122.45590973 37.73118591) Phone   71 9 8 41 4 9 4 28,861 7 40 40   71   8             1         71
690972 690972 393192 2009-03-20T14:49:57 2010-03-26T13:56:51 2010-03-26T13:56:51 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 333 MARKET ST, SAN FRANCISCO, CA, 94105 MARKET ST 6 Financial District CENTRAL 37.791957855225 -122.397636413574 POINT (-122.39763641 37.79195786) Web   108 6 10 8 9 12 2 28,855 2 6 6   108   10             1         108
739292 739292 407002 2009-04-07T15:15:24 2010-03-26T13:59:26 2010-03-26T13:59:26 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 204 FREDERICK ST, SAN FRANCISCO, CA, 94117 FREDERICK ST 5 Haight Ashbury PARK 37.767311096191 -122.44670104980499 POINT (-122.44670105 37.7673111) Phone   25 7 11 3 11 15 8 29,492 5 9 9   25   11             1         25
714546 714546 420861 2009-04-28T13:10:38 2010-03-26T14:02:11 2010-03-26T14:02:11 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CHESTNUT ST and CULEBRA TER CHESTNUT ST 2 Russian Hill NORTHERN 37.802562713623 -122.422523498535 POINT (-122.4225235 37.80256271) Phone   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
689298 689298 421328 2009-04-29T09:57:47 2010-03-26T14:02:12 2010-03-26T14:02:12 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 350 CONNECTICUT ST, SAN FRANCISCO, CA, 94107 CONNECTICUT ST 10 Potrero Hill BAYVIEW 37.761859893799 -122.397567749023 POINT (-122.39756775 37.76185989) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
777721 777721 421656 2009-04-29T16:00:51 2010-03-26T14:02:13 2010-03-26T14:02:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 534 BUCHANAN ST, SAN FRANCISCO, CA, 94102 BUCHANAN ST 5 Hayes Valley NORTHERN 37.774959564209 -122.427490234375 POINT (-122.42749023 37.77495956) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
738048 738048 431931 2009-05-15T10:01:40 2010-03-26T14:02:16 2010-03-26T14:02:16 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 14TH AVE and TARAVAL ST 14TH AVE 7 West Portal TARAVAL 37.74328994751 -122.47023773193399 POINT (-122.47023773 37.74328995) Phone   44 10 8 41 4 1 5 29,491 8 40 40   44   8             1         44
748266 748266 441037 2009-05-31T13:00:56 2010-03-26T14:02:18 2010-03-26T14:02:18 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of HOLLYWOOD CT and POPE ST HOLLYWOOD CT 11 Crocker Amazon INGLESIDE 37.714691162109 -122.44148254394501 POINT (-122.44148254 37.71469116) Web   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
1002541 1002541 762628 2010-10-30T09:31:49 2011-03-17T12:08:44 2011-03-17T12:08:44 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of 30TH ST and CASTRO ST 30TH ST 8 Fairmount INGLESIDE 37.741901397705 -122.43325805664101 POINT (-122.43325806 37.7419014) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
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                                                        
1010359 1010359 759456 2010-10-25T17:01:48 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 - Damaged_Tree 1 Dead_tree 755 BUSH ST, SAN FRANCISCO, CA, 94108 BUSH ST 3 Downtown / Union Square CENTRAL 37.789909362793004 -122.409736633301 POINT (-122.40973663 37.78990936) Web   19 6 3 21 10 5 1 28,857 1 21 21   19   3             2         19
1001010 1001010 746916 2010-10-05T15:56:42 2011-03-17T12:08:47 2011-03-17T12:08:47 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3869 20TH ST, SAN FRANCISCO, CA, 94114 20TH ST 8 Dolores Heights MISSION 37.75802230835 -122.42733001709 POINT (-122.42733002 37.75802231) Web   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
949533 949533 716021 2010-08-19T08:39:25 2011-03-17T12:09:51 2011-03-17T12:09:51 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of LAIDLEY ST and MIGUEL ST LAIDLEY ST 8 Fairmount INGLESIDE 37.737743377686 -122.428253173828 POINT (-122.42825317 37.73774338) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
804313 804313 533148 2009-10-27T11:13:40 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 - Damaged_Tree 1 Dead_tree Intersection of FULTON ST and MASONIC AVE FULTON ST 5 Lone Mountain PARK 37.775802612305 -122.44647216796899 POINT (-122.44647217 37.77580261) Phone   12 7 4 18 2 15 8 29,492 5 16 16   12   4             1         12
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                                                        
1022699 1022699 694191 2010-07-15T15:10:20 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 Intersection of 16TH ST and DOLORES ST 16TH ST 8 Mission Dolores MISSION 37.764644622803004 -122.42638397216801 POINT (-122.42638397 37.76464462) Phone   37 3 5 5 5 8 7 28,859 4 3 3   37   5             1   5     37
867696 867696 515971 2009-10-01T23:44:44 2011-03-17T12:09:53 2011-03-17T12:09:53 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 121 DOLORES ST, SAN FRANCISCO, CA, 94103 DOLORES ST 8 Mission Dolores MISSION 37.767528533936 -122.426376342773 POINT (-122.42637634 37.76752853) Web   37 3 5 20 5 8 7 28,862 4 19 19   37   5             2         37
872482 872482 523650 2009-10-13T15:12:01 2011-03-17T12:09:53 2011-03-17T12:09:53 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 915 MINNESOTA ST, SAN FRANCISCO, CA, 94107 MINNESOTA ST 10 Dogpatch BAYVIEW 37.758987426758 -122.39014434814501 POINT (-122.39014435 37.75898743) Phone   55 2 9 26 8 10 3 28,856 3 29 29 20 55   9 22     22 14   1         55
921057 921057 482524 2009-08-06T13:00:28 2011-03-17T12:09:54 2011-03-17T12:09:54 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 3122 STEINER ST, SAN FRANCISCO, CA, 94123 STEINER ST 2 Union Street NORTHERN 37.798183441162 -122.437240600586 POINT (-122.4372406 37.79818344) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
936086 936086 482535 2009-08-06T13:08:15 2011-03-17T12:09:54 2011-03-17T12:09:54 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 57 BELLE AVE, SAN FRANCISCO, CA, 94132 BELLE AVE 7 Merced Heights TARAVAL 37.70858001709 -122.470161437988 POINT (-122.47016144 37.70858002) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
903750 903750 472516 2009-07-21T12:31:25 2011-03-17T12:09:55 2011-03-17T12:09:55 Closed 2 Confirmed with DPW - work previously completed. DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 387 FAIR OAKS ST, SAN FRANCISCO, CA, 94110 FAIR OAKS ST 8 Dolores Heights MISSION 37.750610351563 -122.42371368408199 POINT (-122.42371368 37.75061035) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1153990 1153990 804567 2011-01-12T08:59:36   2011-04-05T14:46:57 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 2 ENCANTO AVE, SAN FRANCISCO, CA, 94115 ENCANTO AVE 2 Anza Vista PARK 37.779819488525 -122.44335174560499 POINT (-122.44335175 37.77981949) Phone   13 7 6 18 1 15 8 29,490 5 16 16   13   6             1         13
1142187 1142187 857443 2011-04-06T17:33:39   2011-04-06T18:04:19 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 2638 3RD ST, SAN FRANCISCO, CA, 94107 3RD ST 10 Dogpatch BAYVIEW 37.756141662598 -122.388290405273 POINT (-122.38829041 37.75614166) Phone   55 2 9 26 8 10 3 28,856 3 29 29   55   9       22 14   1         55
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                                                        
1141806 1141806 894005 2011-06-04T08:13:23   2011-06-06T09:06:54 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CLAY ST and MASON ST CLAY ST 3 Nob Hill CENTRAL 37.793643951416 -122.411186218262 POINT (-122.41118622 37.79364395) Phone   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
1225504 1225504 892592 2011-06-02T08:56:29   2011-06-06T09:25:52 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 3001 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 2 Lower Pacific Heights RICHMOND 37.786327362061 -122.445411682129 POINT (-122.44541168 37.78632736) Phone   103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
1128451 1128451 901107 2011-06-15T09:53:21   2011-06-15T10:50:04 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 740 COLBY ST, SAN FRANCISCO, CA, 94134 COLBY ST 9 Portola BAYVIEW 37.72119140625 -122.410888671875 POINT (-122.41088867 37.72119141) Phone   91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
1219852 1219852 937276 2011-08-09T09:54:45   2011-08-09T11:30:52 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of GOLDEN GATE AVE and VAN NESS AVE GOLDEN GATE AVE 6 Cathedral Hill NORTHERN 37.781032562255994 -122.420440673828 POINT (-122.42044067 37.78103256) Phone   100 4 10 36 9 7 6 28,852 9 36 36   100 1 10     1   8   2 1 1     100
1114767 1114767 963715 2011-09-16T12:11:09   2011-09-17T05:58:33 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 35 DICHIERA CT, SAN FRANCISCO, CA, 94112 DICHIERA CT 11 Outer Mission INGLESIDE 37.712802886963 -122.44659423828101 POINT (-122.44659424 37.71280289) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
1208625 1208625 963111 2011-09-15T13:45:20   2011-09-20T09:48:55 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 517 BOWDOIN ST, SAN FRANCISCO, CA, 94134 BOWDOIN ST 9 Portola BAYVIEW 37.729164123535 -122.411743164063 POINT (-122.41174316 37.72916412) Phone   91 2 2 25 7 9 3 309 3 28 28   91   2             2         91
1133953 1133953 967930 2011-09-22T15:40:29   2011-09-22T17:01:54 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 235 PIERCE ST, SAN FRANCISCO, CA, 94117 PIERCE ST 5 Lower Haight NORTHERN 37.772178649902 -122.43400573730499 POINT (-122.43400574 37.77217865) Phone   26 4 11 3 11 15 8 29,492 5 9 9   26   11             1         26
1323185 1323185 970405 2011-09-26T16:34:50   2011-09-27T08:30:40 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1995 45TH AVE, SAN FRANCISCO, CA, 94116 45TH AVE 4 Outer Sunset TARAVAL 37.749530792236 -122.50422668456999 POINT (-122.50422668 37.74953079) Twitter   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
1271421 1271421 970102 2011-09-26T12:01:34   2011-09-27T11:16:13 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 2225 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 2 Pacific Heights NORTHERN 37.790225982666 -122.434280395508 POINT (-122.4342804 37.79022598) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
1263759 1263759 971682 2011-09-28T09:24:54   2011-09-28T09:49:33 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 547 29TH AVE, SAN FRANCISCO, CA, 94121 29TH AVE 1 Outer Richmond RICHMOND 37.778938293456996 -122.489120483398 POINT (-122.48912048 37.77893829) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1261651 1261651 975349 2011-10-03T09:15:25   2011-10-03T10:43:57 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of GREENWICH ST and LYON ST GREENWICH ST 2 Cow Hollow NORTHERN 37.797515869141 -122.447158813477 POINT (-122.44715881 37.79751587) Phone   14 4 6 27 1 13   57   30 30   14   6             1         14
1324551 1324551 997264 2011-11-03T14:28:19   2011-11-04T08:17:58 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 41ST AVE and NORIEGA ST 41ST AVE 4 Outer Sunset TARAVAL 37.753200531005994 -122.500045776367 POINT (-122.50004578 37.75320053) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1332773 1332773 1004307 2011-11-14T18:08:39   2011-11-15T08:45:37 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 22ND ST and HAMPSHIRE ST 22ND ST 9 Mission MISSION 37.756107330321996 -122.40760040283199 POINT (-122.4076004 37.75610733) Web   53 3 2 20 7 10 7 28,859 4 19 19   53   2     3       2   3     53
1252645 1252645 1004911 2011-11-15T14:39:32   2011-11-16T08:53:14 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BAY ST and THE EMBARCADERO BAY ST 3 Northern Waterfront CENTRAL 37.806617736816 -122.405563354492 POINT (-122.40556335 37.80661774) Phone   77 6 3 23 10 3 1 308 1 23 23   77   3             2         77
1362233 1362233 978158 2011-10-06T11:15:16   2011-11-23T08:40:21 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 250 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 8 Mission Dolores MISSION 37.768989562988 -122.42243957519501 POINT (-122.42243958 37.76898956) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
1235420 1235420 1011188 2011-11-26T21:58:40   2011-11-28T08:50:18 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of PIERCE ST and SUTTER ST PIERCE ST 2 Lower Pacific Heights NORTHERN 37.785667419434 -122.436553955078 POINT (-122.43655396 37.78566742) Phone   103 4 11 15 11 13 9 29,490 6 13 13   103   11             2         103
1350517 1350517 1011189 2011-11-26T22:00:33   2011-11-28T08:50:47 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of PIERCE ST and SUTTER ST PIERCE ST 2 Lower Pacific Heights NORTHERN 37.785667419434 -122.436553955078 POINT (-122.43655396 37.78566742) Phone   103 4 11 15 11 13 9 29,490 6 13 13   103   11             2         103
1333308 1333308 1011187 2011-11-26T21:55:13   2011-11-28T08:51:06 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of PRESIDIO AVE and SUTTER ST PRESIDIO AVE 5 Laurel Heights / Jordan Park RICHMOND 37.784439086914 -122.446250915527 POINT (-122.44625092 37.78443909) Phone   11 8 6 31 1 15 9 54 6 31 31   11   6             1         11
1300040 1300040 1013336 2011-11-29T17:05:07   2011-12-02T08:57:15 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Trees - Overgrown Tree 51 POTOMAC ST, SAN FRANCISCO, CA, 94117 POTOMAC ST 8 Duboce Triangle PARK 37.769924163818004 -122.432632446289 POINT (-122.43263245 37.76992416) Web   28 7 5 3 5 15 8 29,492 5 9 9   28   5             1         28
1315244 1315244 1017610 2011-12-06T08:14:04   2011-12-06T08:48:20 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 116 SAN JOSE AVE, SAN FRANCISCO, CA, 94110 SAN JOSE AVE 8 Dolores Heights MISSION 37.752635955811 -122.42169189453101 POINT (-122.42169189 37.75263596) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
1324038 1324038 1021481 2011-12-12T09:07:28   2011-12-12T09:59:25 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 450 17TH AVE, SAN FRANCISCO, CA, 94118 17TH AVE 1 Inner Richmond RICHMOND 37.779468536377 -122.475936889648 POINT (-122.47593689 37.77946854) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1         5
1253180 1253180 1015848 2011-12-03T00:08:33   2011-12-13T09:05:17 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 18TH ST and ARKANSAS ST 18TH ST 10 Potrero Hill BAYVIEW 37.762462615967 -122.39846038818399 POINT (-122.39846039 37.76246262) Phone   54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
1301090 1301090 985103 2011-10-17T11:00:01 2011-12-15T09:34:13 2011-12-15T09:34:13 Closed 2   DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1178 DOLORES ST, SAN FRANCISCO, CA, 94114 DOLORES ST 8 Dolores Heights MISSION 37.750545501709 -122.42529296875 POINT (-122.42529297 37.7505455) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1264663 1264663 1023103 2011-12-14T11:19:38   2011-12-19T08:57:56 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 454 36TH AVE, SAN FRANCISCO, CA, 94121 36TH AVE 1 Outer Richmond RICHMOND 37.780452728271 -122.49642944335899 POINT (-122.49642944 37.78045273) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1342710 1342710 1024000 2011-12-15T14:49:21   2011-12-20T05:46:12 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1060 KEY AVE, SAN FRANCISCO, CA, 94124 KEY AVE 10 Bret Harte BAYVIEW 37.719299316406 -122.39642333984399 POINT (-122.39642334 37.71929932) Web   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
1307580 1307580 1026555 2011-12-20T08:25:49   2011-12-20T08:57:29 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1045 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.754211425781 -122.427490234375 POINT (-122.42749023 37.75421143) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1321058 1321058 1026548 2011-12-20T08:19:37   2011-12-20T08:58:10 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1005 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.754711151123 -122.427536010742 POINT (-122.42753601 37.75471115) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1279795 1279795 1026597 2011-12-20T08:56:37   2011-12-20T09:05:35 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 292 CRESCENT AVE, SAN FRANCISCO, CA, 94110 CRESCENT AVE 9 Holly Park INGLESIDE 37.734882354736 -122.41883087158199 POINT (-122.41883087 37.73488235) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
1347235 1347235 1026577 2011-12-20T08:38:59   2011-12-20T09:08:14 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3541 21ST ST, SAN FRANCISCO, CA, 94114 21ST ST 8 Dolores Heights MISSION 37.756458282471 -122.426544189453 POINT (-122.42654419 37.75645828) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
1339305 1339305 1028548 2011-12-22T18:13:51   2011-12-23T09:50:48 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of 18TH ST and DOUGLASS ST 18TH ST 8 Eureka Valley MISSION 37.760627746581996 -122.43933868408199 POINT (-122.43933868 37.76062775) Phone   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
1323473 1323473 1034329 2012-01-02T14:40:24   2012-01-03T09:27:05 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1738 BRYANT ST, SAN FRANCISCO, CA, 94110 BRYANT ST 9 Mission MISSION 37.765090942383 -122.410575866699 POINT (-122.41057587 37.76509094) Phone   53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
1264961 1264961 1049528 2012-01-23T17:00:16   2012-01-24T08:57:56 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1342 SHOTWELL ST, SAN FRANCISCO, CA, 94110 SHOTWELL ST 9 Bernal Heights INGLESIDE 37.74764251709 -122.41497802734399 POINT (-122.41497803 37.74764252) Web   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
1296618 1296618 1054418 2012-01-30T14:01:56   2012-01-30T14:39:39 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 1359 PINE ST, SAN FRANCISCO, CA, 94109 PINE ST 3 Lower Nob Hill CENTRAL 37.789775848389 -122.41834259033199 POINT (-122.41834259 37.78977585) Phone   50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
1238818 1238818 1054638 2012-01-30T17:16:36   2012-01-31T09:23:13 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 300 BROADWAY, SAN FRANCISCO, CA, 94133 BROADWAY 3 North Beach CENTRAL 37.798515319824 -122.402557373047 POINT (-122.40255737 37.79851532) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3             2         106
1313709 1313709 1059382 2012-02-06T13:11:40   2012-02-07T09:34:46 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of BROAD ST and PLYMOUTH AVE BROAD ST 11 Oceanview TARAVAL 37.713191986084 -122.4560546875 POINT (-122.45605469 37.71319199) Phone   81 10 1 24 6 9 5 28,861 8 24 24 7 81   1 8     8     2     75   81
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                                                        
1360289 1360289 1042830 2012-01-12T23:03:55   2012-02-14T09:40:12 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other 407 GREENWICH ST, SAN FRANCISCO, CA, 94133 GREENWICH ST 3 North Beach CENTRAL 37.802627563477 -122.40651702880899 POINT (-122.40651703 37.80262756) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
1134975 1134975 834095 2011-02-28T17:49:36   2012-02-23T08:57:06 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of ALEMANY BLVD and FOOTE AVE ALEMANY BLVD 11 Outer Mission INGLESIDE 37.714649200439 -122.447265625 POINT (-122.44726563 37.7146492) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
1293938 1293938 1065595 2012-02-15T16:42:27   2012-02-23T09:50:52 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Tree_Other 4 Other 222 VALENCIA ST, SAN FRANCISCO, CA, 94103 VALENCIA ST 8 Mission Dolores MISSION 37.769462585449 -122.422485351563 POINT (-122.42248535 37.76946259) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
1294951 1294951 1071572 2012-02-24T06:55:26   2012-02-24T11:54:41 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 209 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.763488769531 -122.398384094238 POINT (-122.39838409 37.76348877) Phone   54 2 9 26 8 14 3 28,856 3 29 29   54   9             1         54
1354389 1354389 1063884 2012-02-13T11:29:14   2012-03-15T13:42:35 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of SUNSET BLVD and VICENTE ST SUNSET BLVD 4 Parkside TARAVAL 37.738494873046996 -122.494178771973 POINT (-122.49417877 37.73849487) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1347388 1347388 1101618 2012-04-09T12:23:30   2012-04-10T10:14:21 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Empty_tree_basin 600 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Haight Ashbury PARK 37.770812988281 -122.45368957519501 POINT (-122.45368958 37.77081299) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
1244355 1244355 1106027 2012-04-16T10:17:36   2012-04-16T13:39:29 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 843 MONTGOMERY ST, SAN FRANCISCO, CA, 94133 MONTGOMERY ST 3 North Beach CENTRAL 37.796951293945 -122.403770446777 POINT (-122.40377045 37.79695129) Phone   106 6 3 6 10 3 1 308 1 4 4   106   3             2         106
1346114 1346114 1106328 2012-04-16T14:32:27   2012-04-17T11:47:25 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 750 14TH ST, SAN FRANCISCO, CA, 94114 14TH ST 8 Duboce Triangle PARK 37.767753601074 -122.430274963379 POINT (-122.43027496 37.7677536) Phone   28 7 5 5 5 7 6 28,862 9 3 3 18 28   5 20     20     1   5     28
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                                                        
1290749 1290749 1137618 2012-06-03T08:55:18   2012-06-04T10:47:48 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 21 BROMPTON AVE, SAN FRANCISCO, CA, 94131 BROMPTON AVE 8 Glen Park INGLESIDE 37.734313964844 -122.43475341796899 POINT (-122.43475342 37.73431396) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
1439655 1439655 1158633 2012-07-02T12:17:07   2012-07-02T15:34:04 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of FITZGERALD AVE and INGALLS ST FITZGERALD AVE 10 Bret Harte BAYVIEW 37.720977783203004 -122.391304016113 POINT (-122.39130402 37.72097778) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
1498558 1498558 1676837 2012-11-13T07:51:45   2012-11-13T08:21:27 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 221 SAN JUAN AVE, SAN FRANCISCO, CA, 94112 SAN JUAN AVE 11 Mission Terrace INGLESIDE 37.725158691406 -122.43836212158199 POINT (-122.43836212 37.72515869) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
1450500 1450500 1676819 2012-11-13T07:48:19   2012-11-13T08:21:50 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Weeding 401 CAPISTRANO AVE, SAN FRANCISCO, CA, 94112 CAPISTRANO AVE 11 Mission Terrace INGLESIDE 37.725345611571996 -122.43869781494101 POINT (-122.43869781 37.72534561) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
1375817 1375817 1801172 2012-12-19T09:20:58   2012-12-19T12:34:36 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 1616 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.726390838623 -122.436378479004 POINT (-122.43637848 37.72639084) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
1528111 1528111 2225094 2013-04-09T15:05:42   2013-04-10T16:42:04 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 152 JUDSON AVE, SAN FRANCISCO, CA, 94112 JUDSON AVE 7 Sunnyside INGLESIDE 37.72838973999 -122.44549560546899 POINT (-122.44549561 37.72838974) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
1559431 1559431 2398892 2013-05-22T19:28:37   2013-05-23T09:00:46 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1042 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.779106140137 -122.408233642578 POINT (-122.40823364 37.77910614) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32 1 10 6   1 6   1 2 1 1     32
1532816 1532816 2483861 2013-06-13T04:10:58   2013-06-13T06:06:09 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GOUGH ST and HAYES ST GOUGH ST 5 Hayes Valley NORTHERN 37.776882171630994 -122.42298126220699 POINT (-122.42298126 37.77688217) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22 1 11     1   8   1   1     22
1509022 1509022 2483863 2013-06-13T04:13:40   2013-06-13T06:06:27 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of FELL ST and LAGUNA ST FELL ST 5 Hayes Valley NORTHERN 37.775524139404 -122.426071166992 POINT (-122.42607117 37.77552414) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
1589013 1589013 2579084 2013-07-08T11:25:22   2013-07-08T12:06:32 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 183 TRUMBULL ST, SAN FRANCISCO, CA, 94112 TRUMBULL ST 11 Mission Terrace INGLESIDE 37.730983734130994 -122.426719665527 POINT (-122.42671967 37.73098373) Web   94 9 1 7 6 9 4 28,861 7 5 5 16 94   1             2         94
1689101 1689101 2857216 2013-09-22T10:54:24   2013-09-22T13:24:42 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3741 MARKET ST, SAN FRANCISCO, CA, 94131 MARKET ST 8 Upper Market MISSION 37.754127502441 -122.44183349609399 POINT (-122.4418335 37.7541275) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
1771312 1771312 2960836 2013-10-18T13:52:32   2013-10-18T19:51:31 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 990 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.777602 -122.432928 POINT (-122.432928 37.777602) Mobile/Open311 http://mobile311.sfgov.org/reports/2960836/photos 23 4 11 39 11 15 6 29,492 9 41 41   23   11             2         23
1712329 1712329 3053633 2013-11-12T06:41:31   2013-11-12T06:46:41 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of ARGUELLO BLVD and SACRAMENTO ST ARGUELLO BLVD 2 Presidio Terrace RICHMOND 37.786624908446996 -122.459259033203 POINT (-122.45925903 37.78662491) Web   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
1713757 1713757 3053631 2013-11-12T06:40:29   2013-11-12T06:47:20 Open 1 Open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of ARGUELLO BLVD and CALIFORNIA ST ARGUELLO BLVD 2 Presidio Terrace RICHMOND 37.785682678223 -122.459175109863 POINT (-122.45917511 37.78568268) Web   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
1767266 1767266 3063798 2013-11-14T12:11:14   2013-11-14T12:39:13 Open 1 open DPW BUF Queue 2 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1666 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 5 Civic Center SOUTHERN 37.773487091064 -122.42174530029301 POINT (-122.4217453 37.77348709) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1     1 1   1     21

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.716ms