calls

78 rows where Responsible_Agency = 24

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
108325 108325 2068657 2013-02-28T07:01:30 2013-04-05T12:47:14 2013-04-05T12:47:14 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
560137 560137 10321788 2019-01-06T12:49:00 2019-03-15T07:20:08 2019-03-15T07:20:08 Closed 2   DPW BSSR Queue 24 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of OLYMPIC COUNTRY CLUB RD and SKYLINE BLVD OLYMPIC COUNTRY CLUB RD 7 Lakeshore TARAVAL 37.709795897488 -122.498209160096 POINT (-122.49820916 37.7097959) Mobile/Open311   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
837874 837874 515614 2009-10-01T14:12:02 2010-06-24T13:31:56 2010-06-24T13:31:56 Closed 2   DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of PACHECO ST and SUNSET BLVD PACHECO ST 4 Outer Sunset TARAVAL 37.749683380127 -122.494972229004 POINT (-122.49497223 37.74968338) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
1250225 1250225 1122130 2012-05-11T09:30:12   2014-06-04T08:18:00 Open 1 scheduled DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LAGUNA ST and MARKET ST LAGUNA ST 8 Mint Hill SOUTHERN 37.770748138428004 -122.424850463867 POINT (-122.42485046 37.77074814) Integrated Agency   27 1 5 20 5 7 2 28,853 2 19 19   27   5         9   2         27
1256985 1256985 1122962 2012-05-12T14:15:18 2012-05-30T14:01:44 2012-05-30T14:01:44 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 27TH AVE and CLEMENT ST 27TH AVE 1 Outer Richmond RICHMOND 37.781925201416 -122.487022399902 POINT (-122.4870224 37.7819252) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             2         8
1293254 1293254 1079205 2012-03-06T13:40:14 2012-03-08T06:22:07 2012-03-08T06:22:07 Closed 2   DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Trees - Damaging Property Intersection of MISSION BAY NORTH BLVD and TERRY A FRANCOIS BLVD MISSION BAY NORTH BLVD 6 Mission Bay SOUTHERN 0.0 0.0 POINT (0 0) Mobile/Open311                                                        
1294790 1294790 1029930 2011-12-26T11:58:31 2012-01-09T10:32:03 2012-01-09T10:32:03 Closed 2   DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 366 DOLORES ST, SAN FRANCISCO, CA, 94114 DOLORES ST 8 Mission Dolores MISSION 37.763603210449 -122.42650604248001 POINT (-122.42650604 37.76360321) Phone   37 3 5 5 5 8 7 28,859 4 3 3   37   5             1   5     37
1327367 1327367 1136064 2012-05-31T20:45:15   2012-06-01T08:45:18 Open 1 accepted DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 855 LA PLAYA, SAN FRANCISCO, CA, 94121 LA PLAYA 1 Outer Richmond RICHMOND 37.772220611571996 -122.510093688965 POINT (-122.51009369 37.77222061) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1339658 1339658 1138135 2012-06-04T09:15:20 2012-06-25T15:11:08 2012-06-25T15:11:08 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MIDDLE WEST DR and TRANSVERSE DR MIDDLE WEST DR 1 Golden Gate Park RICHMOND 37.767761230469 -122.479682922363 POINT (-122.47968292 37.76776123) Integrated Agency   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
1360302 1360302 1137279 2012-06-02T13:15:26   2012-06-04T14:30:57 Open 1 accepted DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 9TH AVE and IRVING ST 9TH AVE 5 Inner Sunset TARAVAL 37.764038085938 -122.46630859375 POINT (-122.46630859 37.76403809) Integrated Agency   109 10 11 14 11 11 5 56 8 12 12 2 109   11 2     2     1         109
1378954 1378954 1753649 2012-12-03T18:57:56 2013-04-05T09:23:04 2013-04-05T09:23:04 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HOWARD ST and THE EMBARCADERO HOWARD ST 6 Financial District SOUTHERN 37.792518615723 -122.39099884033199 POINT (-122.39099884 37.79251862) Integrated Agency   108 1 10 8 9 6 2 28,855 2 6 6   108   10     4       1   4     108
1387012 1387012 1955584 2013-01-30T12:43:34 2013-04-17T15:32:43 2013-04-17T15:32:43 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CLAY ST and SANSOME ST CLAY ST 3 Financial District CENTRAL 37.79483795166 -122.401489257813 POINT (-122.40148926 37.79483795) Integrated Agency   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
1398432 1398432 1224175 2012-08-02T14:45:20   2014-11-25T13:52:00 Open 1 scheduled DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HEMLOCK ST and POLK ST HEMLOCK ST 3 Lower Nob Hill NORTHERN 37.787281036377 -122.420021057129 POINT (-122.42002106 37.78728104) Integrated Agency   50 4 3 21 10 13 6 28,858 9 21 21   50   3         10   2         50
1403192 1403192 1153604 2012-06-26T07:00:24   2012-06-27T14:32:26 Open 1 accepted DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 3220 21ST ST, SAN FRANCISCO, CA, 94110 21ST ST 9 Mission MISSION 37.757118225098 -122.41937255859399 POINT (-122.41937256 37.75711823) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1432852 1432852 1236352 2012-08-05T13:15:19   2014-12-10T15:28:54 Open 1 in progress DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1818 23RD ST, SAN FRANCISCO, CA, 94107 23RD ST 10 Potrero Hill BAYVIEW 37.754886627196996 -122.398094177246 POINT (-122.39809418 37.75488663) Integrated Agency   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
1442768 1442768 1948643 2013-01-28T18:14:03 2013-04-05T12:17:44 2013-04-05T12:17:44 Closed 2 Transferred: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CHESTNUT ST and SANSOME ST CHESTNUT ST 3 Northern Waterfront CENTRAL 37.805183410645 -122.40343475341801 POINT (-122.40343475 37.80518341) Integrated Agency   77 6 3 23 10 3 1 28,860 1 23 23   77   3             2         77
1474308 1474308 1513742 2012-10-05T09:40:53 2012-12-19T12:01:05 2012-12-19T12:01:05 Closed 2 Transferred: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MCCOPPIN ST and VALENCIA ST MCCOPPIN ST 6 South of Market SOUTHERN 37.771595001221 -122.422523498535 POINT (-122.4225235 37.771595) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32   10             2         32
1475334 1475334 1167800 2012-07-16T07:15:15 2012-07-19T14:04:46 2012-07-19T14:04:46 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HARRISON ST and THE EMBARCADERO HARRISON ST 6 Rincon Hill SOUTHERN 37.789573669434 -122.388481140137 POINT (-122.38848114 37.78957367) Integrated Agency   30 1 10 8 9 6 2 28,855 2 6 6   30   10             1         30
1478440 1478440 1950472 2013-01-29T10:44:21 2013-04-05T12:17:52 2013-04-05T12:17:52 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 18TH ST and 3RD ST 18TH ST 10 Dogpatch BAYVIEW 37.763050079346 -122.388740539551 POINT (-122.38874054 37.76305008) Integrated Agency   55 2 9 26 8 14 3 28,856 3 29 29   55   9         14   1         55
1480127 1480127 1790843 2012-12-16T07:43:52   2013-04-05T11:48:14 Open 1 open DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1200 HOLLISTER AVE, SAN FRANCISCO, CA, 94124 HOLLISTER AVE 10 Bret Harte BAYVIEW 37.720951080321996 -122.394332885742 POINT (-122.39433289 37.72095108) Integrated Agency   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
1486382 1486382 1597229 2012-10-25T13:30:19 2015-10-28T01:27:09 2015-10-28T01:27:09 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 5TH ST and STEVENSON ST 5TH ST 6 South of Market TENDERLOIN 37.783527374268 -122.407485961914 POINT (-122.40748596 37.78352737) Integrated Agency   32 5 10 34 9 12 2 28,853 2 34 34 17 32 1 10 18     18 7 1 2 1       32
1496274 1496274 1633651 2012-11-02T15:44:04 2014-01-03T07:47:19 2014-01-03T07:47:19 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 18TH ST and FLORIDA ST 18TH ST 9 Mission MISSION 37.761699676514 -122.411087036133 POINT (-122.41108704 37.76169968) Integrated Agency   53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
1505299 1505299 2061296 2013-02-26T10:29:13 2013-04-05T12:47:12 2013-04-05T12:47:12 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2047 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 5 Japantown NORTHERN 37.788303375244006 -122.429885864258 POINT (-122.42988586 37.78830338) Integrated Agency   101 4 11 30 11 13 6 29,490 9 27 27   101   11             1         101
1506961 1506961 2050637 2013-02-23T11:29:29 2013-04-05T12:32:50 2013-04-05T12:32:50 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2067 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 5 Japantown NORTHERN 37.788383483887 -122.429794311523 POINT (-122.42979431 37.78838348) Integrated Agency   101 4 11 30 11 13 6 29,490 9 27 27   101   11             1         101
1511427 1511427 2276398 2013-04-22T19:00:40 2013-04-26T16:49:59 2013-04-26T16:49:59 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2150 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 1 Lone Mountain PARK 37.775234222412 -122.451782226563 POINT (-122.45178223 37.77523422) Integrated Agency   12 7 4 18 2 15 9 29,492 6 16 16   12   4             1         12
1514599 1514599 2289184 2013-04-25T17:00:45   2013-04-25T17:01:19 Open 1 accepted DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of NEBRASKA ST and POWHATTAN AVE NEBRASKA ST 9 Bernal Heights INGLESIDE 37.741359710693004 -122.410362243652 POINT (-122.41036224 37.74135971) Integrated Agency   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
1515617 1515617 2087387 2013-03-04T15:29:42 2013-04-08T14:18:32 2013-04-08T14:18:32 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 690 MARKET ST, SAN FRANCISCO, CA, 94104 MARKET ST 3 Downtown / Union Square CENTRAL 37.788242340088 -122.403198242188 POINT (-122.40319824 37.78824234) Integrated Agency   19 6 3 8 10 4 1 28,854 1 6 6 10 19   3 12           2         19
1520503 1520503 2212715 2013-04-06T07:15:55 2013-04-08T07:45:33 2013-04-08T07:45:33 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAY ST and POLK ST BAY ST 2 Russian Hill CENTRAL 37.804355621338 -122.42346954345699 POINT (-122.42346954 37.80435562) Integrated Agency   98 6 6 32 1 5 1 28,858 1 32 32   98   6             1         98
1521853 1521853 2222708 2013-04-09T05:59:04   2013-04-09T05:59:19 Open 1 open DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 254 IVY ST, SAN FRANCISCO, CA, 94102 IVY ST 5 Civic Center NORTHERN 37.77755355835 -122.42235565185499 POINT (-122.42235565 37.77755356) Integrated Agency   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
1526597 1526597 1958553 2013-01-31T08:58:49 2013-04-05T12:33:25 2013-04-05T12:33:25 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
1527416 1527416 2231331 2013-04-11T08:30:40 2013-04-11T10:31:28 2013-04-11T10:31:28 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HAIGHT ST and MARKET ST HAIGHT ST 5 South of Market SOUTHERN 37.773036956787 -122.421943664551 POINT (-122.42194366 37.77303696) Integrated Agency   26 1 11 9 11 8 2 28,853 2 10 10   26 1 11     1       1   1     26
1532706 1532706 2045268 2013-02-21T22:00:51 2013-04-05T13:02:44 2013-04-05T13:02:44 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2685 22ND ST, SAN FRANCISCO, CA, 94110 22ND ST 9 Mission MISSION 37.755928039551 -122.408164978027 POINT (-122.40816498 37.75592804) Integrated Agency   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1534012 1534012 2280452 2013-04-23T16:45:52 2013-04-26T16:50:07 2013-04-26T16:50:07 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1121 ATHENS ST, SAN FRANCISCO, CA, 94112 ATHENS ST 11 Crocker Amazon INGLESIDE 37.712471008301 -122.435127258301 POINT (-122.43512726 37.71247101) Integrated Agency   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
1535200 1535200 2112018 2013-03-10T20:00:26 2013-04-05T13:03:00 2013-04-05T13:03:00 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 9TH AVE and CLEMENT ST 9TH AVE 1 Inner Richmond RICHMOND 37.782802581787 -122.467628479004 POINT (-122.46762848 37.78280258) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1538931 1538931 2081349 2013-03-03T09:59:51 2013-04-05T12:47:17 2013-04-05T12:47:17 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1345 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 5 Western Addition NORTHERN 37.781826019287 -122.432548522949 POINT (-122.43254852 37.78182602) Integrated Agency   97 4 11 39 11 15 6 29,490 9 41 41   97   11   24         2         97
1541249 1541249 2095840 2013-03-06T12:01:51 2013-04-08T14:18:28 2013-04-08T14:18:28 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of EDDY ST and MASON ST EDDY ST 6 Tenderloin TENDERLOIN 37.78434753418 -122.40930938720699 POINT (-122.40930939 37.78434753) Integrated Agency   20 5 10 36 9 14 10 28,852 10 36 36 17 20 1 10 18     18 6 1 2 1       20
1552983 1552983 2114366 2013-03-11T12:30:33 2013-04-11T06:32:41 2013-04-11T06:32:41 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 49 CRAGMONT AVE, SAN FRANCISCO, CA, 94116 CRAGMONT AVE 7 Golden Gate Heights TARAVAL 37.750213623046996 -122.467559814453 POINT (-122.46755981 37.75021362) Integrated Agency   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
1553771 1553771 2123638 2013-03-13T16:00:44 2013-04-18T15:49:11 2013-04-18T15:49:11 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 159 MONTEREY BLVD, SAN FRANCISCO, CA, 94131 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731418609619006 -122.438804626465 POINT (-122.43880463 37.73141861) Integrated Agency   95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
1557804 1557804 1962772 2013-02-01T07:27:30 2013-04-05T12:33:12 2013-04-05T12:33:12 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of MARKET ST and MCALLISTER ST MARKET ST 6 Tenderloin TENDERLOIN 37.781177520752 -122.41169738769501 POINT (-122.41169739 37.78117752) Integrated Agency   20 5 10 34 9 14 2 28,852 2 34 34   20 1 10     1   7 1 2 1 1 35   20
1558473 1558473 2244862 2013-04-15T08:44:21 2013-04-22T16:17:19 2013-04-22T16:17:19 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2346 36TH AVE, SAN FRANCISCO, CA, 94116 36TH AVE 4 Parkside TARAVAL 37.743228912354 -122.49382019043001 POINT (-122.49382019 37.74322891) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1562093 1562093 2106564 2013-03-08T18:01:13 2013-04-05T13:02:48 2013-04-05T13:02:48 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of EVANS AVE and RANKIN ST EVANS AVE 10 Produce Market BAYVIEW 37.745101928711 -122.39218139648399 POINT (-122.3921814 37.74510193) Integrated Agency     2 9 1 8 10 3 58 3 1 1       9             1          
1566117 1566117 1969211 2013-02-02T17:57:39 2013-04-05T12:33:28 2013-04-05T12:33:28 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and LYON ST GEARY BLVD 2 Lower Pacific Heights RICHMOND 37.782775878906 -122.444458007813 POINT (-122.44445801 37.78277588) Integrated Agency   103 8 6 31 1 15 8 29,490 5 31 31   103   6             1         103
1566118 1566118 2021298 2013-02-15T14:43:09 2013-04-05T12:32:57 2013-04-05T12:32:57 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 17TH ST and CLAYTON ST 17TH ST 5 Ashbury Heights PARK 37.761779785156 -122.44678497314501 POINT (-122.44678497 37.76177979) Integrated Agency   114 7 11 14 11 15 8 29,492 5 12 12   114   11             1         114
1567536 1567536 2094788 2013-03-06T09:16:47 2013-04-11T08:47:51 2013-04-11T08:47:51 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 785 LE CONTE AVE, SAN FRANCISCO, CA, 94124 LE CONTE AVE 10 Bret Harte BAYVIEW 37.716850280762 -122.396697998047 POINT (-122.396698 37.71685028) Integrated Agency   88 2 9 1 8 10 3 58 3 1 1   88   9             1         88
1568173 1568173 2214612 2013-04-06T18:45:52 2013-04-10T15:02:19 2013-04-10T15:02:19 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1235 38TH AVE, SAN FRANCISCO, CA, 94122 38TH AVE 4 Outer Sunset TARAVAL 37.763832092285 -122.497703552246 POINT (-122.49770355 37.76383209) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1570374 1570374 2135867 2013-03-17T06:14:01 2013-04-05T13:03:16 2013-04-05T13:03:16 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GREAT HWY and SLOAT BLVD GREAT HWY 4 Parkside TARAVAL 37.735572814941 -122.506134033203 POINT (-122.50613403 37.73557281) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1573017 1573017 2161171 2013-03-23T08:58:42 2013-04-05T13:03:07 2013-04-05T13:03:07 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LOMBARD ST and VAN NESS AVE LOMBARD ST 2 Union Street NORTHERN 37.801303863525 -122.42453765869101 POINT (-122.42453766 37.80130386) Integrated Agency   107 4 6 32 1 13 6 28,858 9 32 32   107   6             1         107
1578690 1578690 2137592 2013-03-17T17:29:13 2013-04-05T13:03:20 2013-04-05T13:03:20 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2040 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.778938293456996 -122.469940185547 POINT (-122.46994019 37.77893829) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1585971 1585971 2133678 2013-03-16T10:00:00 2013-04-05T13:17:31 2013-04-05T13:17:31 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1851 21ST AVE, SAN FRANCISCO, CA, 94122 21ST AVE 4 Outer Sunset TARAVAL 37.753211975098 -122.478691101074 POINT (-122.4786911 37.75321198) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7 25           1         39
1588418 1588418 1957420 2013-01-30T17:43:21 2013-04-05T12:33:32 2013-04-05T12:33:32 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of COMMERCIAL ST and SANSOME ST COMMERCIAL ST 3 Financial District CENTRAL 37.794425964355 -122.401405334473 POINT (-122.40140533 37.79442596) Integrated Agency   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
1592190 1592190 2081550 2013-03-03T11:14:55 2013-04-17T15:32:47 2013-04-17T15:32:47 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of FULTON ST and LA PLAYA FULTON ST 1 Golden Gate Park RICHMOND 37.771396636963 -122.50989532470699 POINT (-122.50989532 37.77139664) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
1593247 1593247 2113744 2013-03-11T10:45:31 2013-04-05T09:46:29 2013-04-05T09:46:29 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GREEN ST and POLK ST GREEN ST 3 Polk Gulch NORTHERN 37.797824859619006 -122.422149658203 POINT (-122.42214966 37.79782486) Integrated Agency   105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
1594527 1594527 2195892 2013-04-01T19:44:07   2014-10-18T14:45:00 Open 1 scheduled DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BAY ST and MASON ST BAY ST 3 North Beach CENTRAL 37.805618286133 -122.413604736328 POINT (-122.41360474 37.80561829) Integrated Agency   106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
1596544 1596544 2118445 2013-03-12T12:14:53 2013-04-08T15:03:49 2013-04-08T15:03:49 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 133 KEARNY ST, SAN FRANCISCO, CA, 94108 KEARNY ST 3 Downtown / Union Square CENTRAL 37.789257049561 -122.403877258301 POINT (-122.40387726 37.78925705) Integrated Agency   19 6 3 8 10 5 1 28,857 1 6 6 10 19   3 12     12 5   2         19
1599967 1599967 1956973 2013-01-30T16:13:33 2013-04-05T12:33:36 2013-04-05T12:33:36 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of COMMERCIAL ST and SANSOME ST COMMERCIAL ST 3 Financial District CENTRAL 37.794425964355 -122.401405334473 POINT (-122.40140533 37.79442596) Integrated Agency   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
1600040 1600040 2054101 2013-02-24T13:43:57 2013-04-05T12:32:46 2013-04-05T12:32:46 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 5937 GEARY BLVD, SAN FRANCISCO, CA, 94121 GEARY BLVD 1 Outer Richmond RICHMOND 37.779956817627 -122.48328399658199 POINT (-122.483284 37.77995682) Integrated Agency   8 8 4 29 2 11 9 55 6 26 26   8   4   22         1         8
1602435 1602435 2250817 2013-04-16T11:45:38 2013-04-22T16:17:23 2013-04-22T16:17:23 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BEACH ST and POLK ST BEACH ST 2 Aquatic Park / Ft. Mason CENTRAL 37.806221008301 -122.423843383789 POINT (-122.42384338 37.80622101) Integrated Agency   98 6 6 32 1 5 1 28,858 1 32 32   98   6             1         98
1603221 1603221 2192793 2013-04-01T10:29:36 2013-04-04T06:59:32 2013-04-04T06:59:32 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LA PLAYA and LAWTON ST LA PLAYA 4 Outer Sunset TARAVAL 37.756549835205 -122.50890350341801 POINT (-122.5089035 37.75654984) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1605498 1605498 2253149 2013-04-16T20:15:38 2013-04-22T16:02:41 2013-04-22T16:02:41 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1270 35TH AVE, SAN FRANCISCO, CA, 94122 35TH AVE 4 Outer Sunset TARAVAL 37.763370513916 -122.49414825439501 POINT (-122.49414825 37.76337051) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1609252 1609252 2020034 2013-02-15T11:13:09 2013-04-05T12:33:16 2013-04-05T12:33:16 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and WEBSTER ST GEARY BLVD 5 Japantown NORTHERN 37.784568786621 -122.431205749512 POINT (-122.43120575 37.78456879) Integrated Agency   101 4 11 15 11 13 6 29,490 9 13 13 8 101   11 9     9     2         101
1610030 1610030 2040752 2013-02-21T00:30:30 2013-04-05T12:33:01 2013-04-05T12:33:01 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GREAT HWY and SLOAT BLVD GREAT HWY 4 Parkside TARAVAL 37.735572814941 -122.506134033203 POINT (-122.50613403 37.73557281) Integrated Agency   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1611762 1611762 2131212 2013-03-15T13:15:21 2013-04-05T13:03:11 2013-04-05T13:03:11 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 410 BUSH ST, SAN FRANCISCO, CA, 94108 BUSH ST 3 Chinatown CENTRAL 37.790813446045 -122.404457092285 POINT (-122.40445709 37.79081345) Integrated Agency   104 6 3 8 10 5 1 28,857 1 6 6   104   3   17         2         104
1614103 1614103 2255074 2013-04-17T11:45:41 2013-04-25T09:48:08 2013-04-25T09:48:08 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Balboa Natural Area, SAN FRANCISCO, CA, 94121 Balboa Natural Area 1 Sutro Heights RICHMOND 37.775913238525 -122.511039733887 POINT (-122.51103973 37.77591324) Integrated Agency   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
1616043 1616043 2110154 2013-03-10T09:00:18 2013-04-05T13:02:56 2013-04-05T13:02:56 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HAHN ST and VISITACION AVE HAHN ST 10 Visitacion Valley INGLESIDE 37.71350479126 -122.41529083251999 POINT (-122.41529083 37.71350479) Integrated Agency   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
1616272 1616272 2137718 2013-03-17T18:29:12 2013-04-08T15:47:24 2013-04-08T15:47:24 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2047 ANZA ST, SAN FRANCISCO, CA, 94118 ANZA ST 1 Inner Richmond RICHMOND 37.77864074707 -122.470359802246 POINT (-122.4703598 37.77864075) Integrated Agency   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
1621757 1621757 2207527 2013-04-04T17:16:05 2013-04-10T15:32:10 2013-04-10T15:32:10 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 30 LARKIN ST, SAN FRANCISCO, CA, 94102 LARKIN ST 6 Civic Center TENDERLOIN 37.778259277344 -122.416343688965 POINT (-122.41634369 37.77825928) Integrated Agency   21 5 10 36 9 7 10 28,852 10 36 36   21 1 10     1   7 1 2 1 1     21
1622840 1622840 2107885 2013-03-09T10:30:24 2013-04-05T12:32:54 2013-04-05T12:32:54 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GEARY BLVD and PARK PRESIDIO BLVD GEARY BLVD 1 Inner Richmond RICHMOND 37.780654907227 -122.472312927246 POINT (-122.47231293 37.78065491) Integrated Agency   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
1623303 1623303 1982701 2013-02-06T07:56:14 2013-04-05T12:33:09 2013-04-05T12:33:09 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 8TH ST and MARKET ST 8TH ST 6 Civic Center TENDERLOIN 37.778720855713 -122.414741516113 POINT (-122.41474152 37.77872086) Integrated Agency   21 5 10 36 9 8 2 28,853 2 36 36 3 21 1 10 3   1 3 7 1 2 1 1 35   21
1626736 1626736 2130685 2013-03-15T11:30:14 2013-04-05T09:46:34 2013-04-05T09:46:34 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1630 POLK ST, SAN FRANCISCO, CA, 94109 POLK ST 3 Polk Gulch NORTHERN 37.792015075684 -122.42082214355499 POINT (-122.42082214 37.79201508) Integrated Agency   105 4 3 21 10 13 6 28,858 9 21 21   105   3   18         1         105
1626748 1626748 2043135 2013-02-21T13:45:38 2013-04-05T12:33:05 2013-04-05T12:33:05 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 1343 22ND AVE, SAN FRANCISCO, CA, 94122 22ND AVE 4 Outer Sunset TARAVAL 37.762550354004 -122.480415344238 POINT (-122.48041534 37.76255035) Integrated Agency   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1632552 1632552 2107432 2013-03-09T07:00:13 2013-04-05T13:02:52 2013-04-05T13:02:52 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 2025 VAN NESS AVE, SAN FRANCISCO, CA, 94109 VAN NESS AVE 2 Pacific Heights NORTHERN 37.794464111328004 -122.423393249512 POINT (-122.42339325 37.79446411) Integrated Agency   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
1634761 1634761 2093960 2013-03-06T03:16:46 2013-04-05T12:47:19 2013-04-05T12:47:19 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other 211 13TH ST, SAN FRANCISCO, CA, 94103 13TH ST 9 Mission MISSION 37.769500732421996 -122.41937255859399 POINT (-122.41937256 37.76950073) Integrated Agency   53 3 2 20 7 8 7 28,853 4 19 19   53 1 2     3       2   3     53
1637808 1637808 2231330 2013-04-11T08:30:40 2013-04-16T16:06:05 2013-04-16T16:06:05 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of HAIGHT ST and MARKET ST HAIGHT ST 5 South of Market SOUTHERN 37.773036956787 -122.421943664551 POINT (-122.42194366 37.77303696) Integrated Agency   26 1 11 9 11 8 2 28,853 2 10 10   26 1 11     1       1   1     26
1737717 1737717 2929999 2013-10-10T14:01:33 2013-10-11T13:47:21 2013-10-11T13:47:21 Closed 2 Transferred: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Tree_Other 4   1254 MARKET ST, SAN FRANCISCO, CA, 94102 MARKET ST 6 Civic Center TENDERLOIN 37.778400067248 -122.41538199858 POINT (-122.415382 37.77840007) Mobile/Open311 http://mobile311.sfgov.org/reports/2929999/photos 21 5 10 36 9 7 2 28,852 2 36 36   21 1 10     1   7 1 2 1 1 35   21
1906326 1906326 3785458 2014-06-30T08:50:31 2014-07-01T12:00:00 2014-07-01T12:00:00 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Landscaping 5 Other 1550 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.7275150418 -122.435683372652 POINT (-122.43568337 37.72751504) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
2009531 2009531 3998908 2014-09-10T12:38:12 2014-11-04T08:15:56 2014-11-04T08:15:56 Closed 2 resolved: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1687 37TH AVE, SAN FRANCISCO, CA, 94122 37TH AVE 4 Outer Sunset TARAVAL 37.755516917842996 -122.495983925045 POINT (-122.49598393 37.75551692) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
2191343 2191343 5214595 2015-10-22T12:14:00 2017-09-13T09:23:30 2017-09-13T09:23:30 Closed 2   DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 40 BOARDMAN PL, SAN FRANCISCO, CA, 94103 BOARDMAN PL 6 South of Market SOUTHERN 37.774530996227 -122.402990778827 POINT (-122.40299078 37.774531) Phone   32 1 10 34 9 14 2 28,853 2 34 34   32   10             2         32
2416303 2416303 5468728 2016-01-15T13:00:33 2016-01-19T08:02:58 2016-01-19T08:02:58 Closed 2 cancelled: DPW BSSR Queue 24 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of SAN BRUNO AVE and WILDE AVE SAN BRUNO AVE 10 Portola INGLESIDE 37.716545 -122.399688333333 POINT (-122.39968833 37.716545) Mobile/Open311 http://mobile311.sfgov.org/reports/5468728/photos 91 9 9 25 8 10 4 309 7 28 28   91   9             2         91

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