calls

47 rows where Responsible_Agency = 28

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
244378 244378 9197332 2018-06-28T09:52:00 2018-09-21T18:57:07 2018-09-21T18:57:07 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1216 JAMESTOWN AVE, SAN FRANCISCO, CA, 94124 JAMESTOWN AVE 10 Bret Harte BAYVIEW 37.720886230469 -122.39754486084 POINT (-122.39754486 37.72088623) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
429032 429032 10316181 2019-01-04T13:49:00 2019-01-04T14:52:01 2019-01-04T14:52:01 Closed 2 Pickup completed SCHEDULED Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other 3970 17TH ST, SAN FRANCISCO, CA, 94114 17TH ST 8 Castro MISSION 37.762795442011 -122.434376750531 POINT (-122.43437675 37.76279544) Mobile/Open311   38 3 5 5 5 15 7 28,862 4 3 3 1 38   5 1 12   1 9   1   5     38
464571 464571 10352913 2019-01-13T20:59:00 2019-01-22T13:28:26 2019-01-22T13:28:26 Closed 2 WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of FRANCISCO ST and POLK ST FRANCISCO ST 2 Russian Hill NORTHERN 37.803462072191 -122.423219038592 POINT (-122.42321904 37.80346207) Mobile/Open311   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
471298 471298 10304360 2019-01-02T09:41:00 2019-01-04T09:46:02 2019-01-04T09:46:02 Closed 2 CASE PREVIOUSLY REALLOCATED SCHEDULED PU Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other 1 HARRISON ST, SAN FRANCISCO, CA, 94105 HARRISON ST 6 Rincon Hill SOUTHERN 37.7890659 -122.38880659999998 POINT (-122.3888066 37.7890659) Web   30 1 10 8 9 6 2 28,855 2 6 6   30   10         3   1         30
548860 548860 10341945 2019-01-10T15:58:00 2019-01-10T18:29:07 2019-01-10T18:29:07 Closed 2 Pickup completed Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3801 BALBOA ST, SAN FRANCISCO, CA, 94121 BALBOA ST 1 Outer Richmond RICHMOND 37.775466918945 -122.499702453613 POINT (-122.49970245 37.77546692) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
560206 560206 10305541 2019-01-02T12:26:00 2019-01-04T15:35:10 2019-01-04T15:35:10 Closed 2 WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of NORIEGA ST and 16TH AVE NORIEGA ST 7 Golden Gate Heights TARAVAL 37.755550384521 -122.473342895508 POINT (-122.4733429 37.75555038) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
610436 610436 10424978 2019-01-30T06:56:00 2019-01-30T17:35:24 2019-01-30T17:35:24 Closed 2 Pickup completed. JC; Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other 295 TOWNSEND ST, SAN FRANCISCO, CA, 94107 TOWNSEND ST 6 Mission Bay SOUTHERN 37.777281923307 -122.394910847598 POINT (-122.39491085 37.77728192) Mobile/Open311 http://mobile311.sfgov.org/reports/10424978/photos 32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
657897 657897 10595958 2019-03-13T09:20:00 2019-03-13T16:36:04 2019-03-13T16:36:04 Closed 2 WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1836 SILVER AVE, SAN FRANCISCO, CA, 94124 SILVER AVE 10 Silver Terrace BAYVIEW 37.734298706055 -122.40225982666 POINT (-122.40225983 37.73429871) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
1535495 1535495 2630981 2013-07-23T08:28:54 2013-07-23T18:17:42 2013-07-23T18:17:42 Closed 2   Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FILLMORE ST and PINE ST FILLMORE ST 5 Lower Pacific Heights NORTHERN 37.787948608398 -122.433647155762 POINT (-122.43364716 37.78794861) Phone   103 4 11 30 11 13 6 29,490 9 27 27   103   11             1         103
1634362 1634362 2707999 2013-08-13T09:01:24 2013-08-13T18:39:01 2013-08-13T18:39:01 Closed 2 Serviced 11:51 AM Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BUSH ST and HYDE ST BUSH ST 3 Lower Nob Hill CENTRAL 37.789108276367 -122.41701507568399 POINT (-122.41701508 37.78910828) Phone   50 6 3 21 10 13 1 28,858 1 21 21   50   3             2         50
1652264 1652264 3333986 2014-02-03T14:26:10 2014-02-03T15:25:06 2014-02-03T15:25:06 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 99 GREEN ST, SAN FRANCISCO, CA, 94111 GREEN ST 3 Northern Waterfront CENTRAL 37.800408003541 -122.40138304323901 POINT (-122.40138304 37.800408) Phone   77 6 3 8 10 3 1 28,860 1 6 6   77   3             1         77
1662185 1662185 3170699 2013-12-16T11:01:57 2013-12-16T13:41:31 2013-12-16T13:41:31 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 22ND ST and FOLSOM ST 22ND ST 9 Mission MISSION 37.755699157715 -122.414390563965 POINT (-122.41439056 37.75569916) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1673099 1673099 2737258 2013-08-21T09:26:42 2013-08-21T15:10:55 2013-08-21T15:10:55 Closed 2 3pm Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 737 FOLSOM ST, SAN FRANCISCO, CA, 94107 FOLSOM ST 6 South of Market SOUTHERN 37.782814025879 -122.39990234375 POINT (-122.39990234 37.78281403) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10         4   2         32
1687888 1687888 2764862 2013-08-28T19:42:29 2013-08-29T11:59:00 2013-08-29T11:59:00 Closed 2 Serviced 9:50 AM Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of ESMERALDA AVE and PROSPECT AVE ESMERALDA AVE 9 Bernal Heights INGLESIDE 37.743679046630994 -122.418556213379 POINT (-122.41855621 37.74367905) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
1696927 1696927 2944817 2013-10-15T08:33:07 2013-10-15T17:09:16 2013-10-15T17:09:16 Closed 2 Serviced 2:26 PM Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 damaged_vandalism 3118 23RD ST, SAN FRANCISCO, CA, 94110 23RD ST 9 Mission MISSION 37.754187803842 -122.41466301948 POINT (-122.41466302 37.7541878) Mobile/Open311 http://mobile311.sfgov.org/reports/2944817/photos 53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1720535 1720535 3319051 2014-01-29T14:52:40 2014-01-29T17:48:06 2014-01-29T17:48:06 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CURTIS ST and PRAGUE ST CURTIS ST 11 Crocker Amazon INGLESIDE 37.710112394414 -122.43756415555201 POINT (-122.43756416 37.71011239) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
1722863 1722863 3247648 2014-01-08T11:45:33 2014-01-08T16:35:26 2014-01-08T16:35:26 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of OLMSTEAD ST and GOETTINGEN ST OLMSTEAD ST 9 Portola BAYVIEW 37.722061367634 -122.40456611034901 POINT (-122.40456611 37.72206137) Phone   91 2 2 25 7 10 3 309 3 28 28   91   2             1         91
1727751 1727751 3083986 2013-11-20T08:24:14 2013-11-20T11:30:38 2013-11-20T11:30:38 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRODERICK ST and OFARRELL ST BRODERICK ST 2 Anza Vista PARK 37.782237800649 -122.44096527333299 POINT (-122.44096527 37.7822378) Phone   13 7 6 39 1 15 8 29,490 5 41 41   13   6             2         13
1728116 1728116 3353983 2014-02-10T10:26:57 2014-02-10T14:22:05 2014-02-10T14:22:05 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 320 ROOSEVELT WAY, SAN FRANCISCO, CA, 94114 ROOSEVELT WAY 8 Buena Vista PARK 37.765340776268 -122.441672562299 POINT (-122.44167256 37.76534078) Phone   112 7 5 5 5 15 8 29,492 5 3 3   112   5             1         112
1736929 1736929 3251067 2014-01-09T08:41:43 2014-01-09T13:15:06 2014-01-09T13:15:06 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   864 ARKANSAS ST, SAN FRANCISCO, CA, 94107 ARKANSAS ST 10 Potrero Hill BAYVIEW 37.755309999999994 -122.39791899999999 POINT (-122.397919 37.75531) Mobile/Open311   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
1763110 1763110 3084581 2013-11-20T10:15:34 2013-11-20T17:53:06 2013-11-20T17:53:06 Closed 2 resolved: Pickup completed. OTHER Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 634 POWELL ST, SAN FRANCISCO, CA, 94108 POWELL ST 3 Nob Hill CENTRAL 37.790746083723995 -122.408591504792 POINT (-122.4085915 37.79074608) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
1764222 1764222 3255144 2014-01-10T07:34:01 2014-01-10T10:33:07 2014-01-10T10:33:07 Closed 2 resolved: WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SKYLINE BLVD and GREAT HWY SKYLINE BLVD 7 Lakeshore TARAVAL 37.725257253922 -122.50304265092899 POINT (-122.50304265 37.72525725) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
1767073 1767073 3300291 2014-01-23T13:43:52 2014-01-23T16:23:08 2014-01-23T16:23:08 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   1271 31ST AVE, SAN FRANCISCO, CA, 94122 31ST AVE 4 Outer Sunset TARAVAL 37.763565704262 -122.49043808330099 POINT (-122.49043808 37.7635657) Mobile/Open311   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1796078 1796078 3493235 2014-03-26T17:00:46 2014-03-27T12:16:22 2014-03-27T12:16:22 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of BACON ST and GOETTINGEN ST BACON ST 9 Portola BAYVIEW 37.727090999999994 -122.40635900000001 POINT (-122.406359 37.727091) Mobile/Open311 http://mobile311.sfgov.org/reports/3493235/photos 91 2 2 25 7 10 3 309 3 28 28   91   2             2         91
1799030 1799030 3445738 2014-03-11T18:19:32 2014-03-12T11:04:08 2014-03-12T11:04:08 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CORBETT AVE and MARS ST CORBETT AVE 8 Eureka Valley PARK 37.760514182457 -122.444352485814 POINT (-122.44435249 37.76051418) Phone   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
1810418 1810418 3748027 2014-06-17T09:32:19 2014-06-17T12:40:59 2014-06-17T12:40:59 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of PINE ST and PIERCE ST PINE ST 5 Lower Pacific Heights NORTHERN 37.787531454009994 -122.43693625744899 POINT (-122.43693626 37.78753145) Phone   103 4 11 30 11 13 9 29,490 6 27 27   103   11             1         103
1831394 1831394 3465646 2014-03-18T10:50:25 2014-03-18T14:06:07 2014-03-18T14:06:07 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of HUGO ST and 7TH AVE HUGO ST 5 Inner Sunset PARK 37.765065808564 -122.464236533074 POINT (-122.46423653 37.76506581) Phone   109 7 11 14 11 11 8 56 5 12 12   109   11             1         109
1857927 1857927 3513057 2014-04-02T08:03:49 2014-04-02T10:58:08 2014-04-02T10:58:08 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 209 PERSIA AVE, SAN FRANCISCO, CA, 94112 PERSIA AVE 11 Excelsior INGLESIDE 37.722387439605 -122.43428757531 POINT (-122.43428758 37.72238744) Phone   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4           2         90
1872926 1872926 3833811 2014-07-16T18:23:52 2014-07-17T12:40:17 2014-07-17T12:40:17 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 255 CRESTMONT DR, SAN FRANCISCO, CA, 94131 CRESTMONT DR 7 Forest Knolls PARK 37.756702222853 -122.45972863544901 POINT (-122.45972864 37.75670222) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
1893293 1893293 3827188 2014-07-14T16:28:26 2014-07-15T09:51:37 2014-07-15T09:51:37 Closed 2 resolved: PRIVATE PROPERTY TREE STILL IN GROUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 368 CLEMENTINA ST, SAN FRANCISCO, CA, 94103 CLEMENTINA ST 6 South of Market SOUTHERN 37.78125 -122.40329742431601 POINT (-122.40329742 37.78125) Phone   32 1 10 34 9 6 2 28,853 2 34 34   32   10         4   2         32
1894854 1894854 3513095 2014-04-02T08:18:22 2014-04-02T12:59:08 2014-04-02T12:59:08 Closed 2 resolved: WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 95 HAWTHORNE ST, SAN FRANCISCO, CA, 94105 HAWTHORNE ST 6 South of Market SOUTHERN 37.784788042832 -122.397871572521 POINT (-122.39787157 37.78478804) Phone   32 1 10 8 9 6 2 28,855 2 6 6   32   10         4   1         32
1914822 1914822 3613087 2014-05-05T10:15:30 2014-05-05T12:21:25 2014-05-05T12:21:25 Closed 2 resolved: WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4   Intersection of 9TH ST and CLEMENTINA ST 9TH ST 6 South of Market SOUTHERN 37.77426 -122.412213 POINT (-122.412213 37.77426) Mobile/Open311 http://mobile311.sfgov.org/reports/3613087/photos 32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
2006890 2006890 4016510 2014-09-16T06:50:03 2014-09-16T09:58:21 2014-09-16T09:58:21 Closed 2 resolved: WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 279 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Telegraph Hill CENTRAL 37.801955595535 -122.404209523857 POINT (-122.40420952 37.8019556) Phone   18 6 3 23 10 3 1 308 1 23 23   18   3             1         18
2117836 2117836 4472099 2015-02-08T12:14:04 2015-02-08T14:48:39 2015-02-08T14:48:39 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 3330 BRODERICK ST, SAN FRANCISCO, CA, 94123 BRODERICK ST 2 Marina NORTHERN 37.801177622413 -122.44464536757299 POINT (-122.44464537 37.80117762) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
2138886 2138886 4472014 2015-02-08T11:48:11 2015-02-09T10:16:22 2015-02-09T10:16:22 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of ANZA ST and STANYAN BLVD ANZA ST 1 Lone Mountain PARK 37.779939972208 -122.455842599652 POINT (-122.4558426 37.77993997) Phone   12 7 4 18 2 11 9 54 6 16 16   12   4             1         12
2145551 2145551 4480616 2015-02-10T17:46:41 2015-02-23T13:36:42 2015-02-23T13:36:42 Closed 2 resolved: Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Other 344 FULTON ST, SAN FRANCISCO, CA, 94102 FULTON ST 5 Civic Center NORTHERN 37.778903333333 -122.42291999999999 POINT (-122.42292 37.77890333) Mobile/Open311 http://mobile311.sfgov.org/reports/4480616/photos 21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
2480222 2480222 5807354 2016-04-27T18:15:25 2016-04-28T10:01:34 2016-04-28T10:01:34 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other 659 MCALLISTER ST, SAN FRANCISCO, CA, 94102 MCALLISTER ST 5 Civic Center NORTHERN 37.779755 -122.423133333333 POINT (-122.42313333 37.779755) Mobile/Open311 http://mobile311.sfgov.org/reports/5807354/photos 21 4 11 39 11 7 6 28,852 9 41 41   21 1 11     1       2   1     21
2584180 2584180 5807360 2016-04-27T18:17:16 2016-04-28T10:23:48 2016-04-28T10:23:48 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of FILLMORE ST and EDDY ST FILLMORE ST 5 Western Addition NORTHERN 37.781426472762 -122.432329661029 POINT (-122.43232966 37.78142647) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11             2         97
2750219 2750219 6704540 2017-01-08T10:19:50 2017-01-08T15:52:03 2017-01-08T15:52:03 Closed 2 Pickup completed;WILL BE SERVICED BY AM XMAS TREE CREW, THANKS. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FRANCISCO ST and POLK ST FRANCISCO ST 2 Russian Hill NORTHERN 37.803412421517 -122.42327749649598 POINT (-122.4232775 37.80341242) Phone   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         107
2788697 2788697 6520329 2016-11-11T09:02:33 2016-11-11T12:45:27 2016-11-11T12:45:27 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of RICHARDSON AVE and BAKER ST RICHARDSON AVE 2 Cow Hollow NORTHERN 37.799663461712 -122.44618085056001 POINT (-122.44618085 37.79966346) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
2800781 2800781 6728780 2017-01-14T10:36:03 2017-01-14T12:34:16 2017-01-14T12:34:16 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 53 CHENERY ST, SAN FRANCISCO, CA, 94131 CHENERY ST 8 Fairmount INGLESIDE 37.741017707512995 -122.425536729671 POINT (-122.42553673 37.74101771) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
2816766 2816766 6602611 2016-12-06T16:38:17 2016-12-07T09:47:19 2016-12-07T09:47:19 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 304 BRAZIL AVE, SAN FRANCISCO, CA, 94112 BRAZIL AVE 11 Excelsior INGLESIDE 37.723348812794 -122.43228258153799 POINT (-122.43228258 37.72334881) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
3130047 3130047 8224678 2017-11-03T16:59:00 2017-11-04T11:17:52 2017-11-04T11:17:52 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 21ST ST and FOLSOM ST 21ST ST 9 Mission MISSION 37.757438449224 -122.41469082433998 POINT (-122.41469082 37.75743845) Mobile/Open311 http://mobile311.sfgov.org/reports/8224678/photos 53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3 60 18 53
3235183 3235183 8046873 2017-09-21T09:18:00 2017-09-21T05:47:56 2017-09-21T05:47:56 Closed 2 Pickup completed. Recology_Abandoned 28 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CUESTA CT and PORTOLA DR CUESTA CT 8 Upper Market PARK 37.750457763671996 -122.443969726563 POINT (-122.44396973 37.75045776) Phone   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
3259072 3259072 8096163 2017-10-03T14:54:00 2017-10-03T08:54:46 2017-10-03T08:54:46 Closed 2 PRIVATE PROPERTY;SPDPW PLEASE SERVICE Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Other 620 DETROIT ST, SAN FRANCISCO, CA, 94131 DETROIT ST 7 Sunnyside INGLESIDE 37.732695069534 -122.444190268113 POINT (-122.44419027 37.73269507) Mobile/Open311 http://mobile311.sfgov.org/reports/8096163/photos 95 9 8 41 4 9 4 63 7 40 40   95   8             1         95
3274936 3274936 8468692 2018-01-05T14:41:00 2018-01-05T16:19:51 2018-01-05T16:19:51 Closed 2 DUPLICATE SERVICE REQUEST Recology_Abandoned 28 Tree Maintenance 1 Trees - Tree_Other 4 Other 939 HOWARD ST, SAN FRANCISCO, CA, 94103 HOWARD ST 6 South of Market SOUTHERN 37.780605 -122.40566000000001 POINT (-122.40566 37.780605) Mobile/Open311 http://mobile311.sfgov.org/reports/8468692/photos 32 1 10 34 9 14 2 28,853 2 34 34   32 1 10         7   2         32
3352137 3352137 8513326 2018-01-16T13:53:00 2018-01-17T08:40:31 2018-01-17T08:40:31 Closed 2 WASTE NOT FOUND Recology_Abandoned 28 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 135 EDINBURGH ST, SAN FRANCISCO, CA, 94112 EDINBURGH ST 11 Excelsior INGLESIDE 37.72688293457 -122.427680969238 POINT (-122.42768097 37.72688293) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90

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