calls

14 rows where Responsible_Agency = 30

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
258427 258427 9379374 2018-08-09T08:03:00 2018-08-24T08:56:00 2018-08-24T08:56:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Weeding 191 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.729595184326 -122.496932983398 POINT (-122.49693298 37.72959518) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
444710 444710 9767605 2018-11-05T10:09:00 2018-11-06T13:35:00 2018-11-06T13:35:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Weeding 97 SAN DIEGO AVE, SAN FRANCISCO, CA, 94112 SAN DIEGO AVE 11 Outer Mission TARAVAL 37.708316802979 -122.466499328613 POINT (-122.46649933 37.7083168) Phone   66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
1598555 1598555 2462362 2013-06-07T12:23:31 2013-06-19T15:58:23 2013-06-19T15:58:23 Closed 2 Inspector Irene Sanchez, Healthy Housing & Vector Control Program, DPH referred caller to the different agency Urban Forestry. DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 319 LAWTON ST, SAN FRANCISCO, CA, 94122 LAWTON ST 7 Golden Gate Heights TARAVAL 37.758285522461 -122.46630096435499 POINT (-122.46630096 37.75828552) Web   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
1737744 1737744 3238560 2014-01-06T12:14:04 2014-01-06T16:17:45 2014-01-06T16:17:45 Closed 2 Healthy Housing & Vector Control Program, DPH Lillian Dyson, Inspector 415-252-3880 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 246 GOUGH ST, SAN FRANCISCO, CA, 94102 GOUGH ST 5 Civic Center NORTHERN 37.775610167441 -122.422650994237 POINT (-122.42265099 37.77561017) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1       1   1     21
2300457 2300457 5138143 2015-09-28T08:55:44 2015-10-08T09:14:09 2015-10-08T09:14:09 Closed 2 Healthy Housing & Vector Control Program, DPH 7415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Weeding 73 ANDERSON ST, SAN FRANCISCO, CA, 94110 ANDERSON ST 9 Bernal Heights INGLESIDE 37.741965059373996 -122.414938255916 POINT (-122.41493826 37.74196506) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
2524391 2524391 5963153 2016-06-09T14:56:19 2016-06-21T11:51:11 2016-06-21T11:51:11 Closed 2 DPH Environmental Health 415-252-3800 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 850 JUDAH ST, SAN FRANCISCO, CA, 94122 JUDAH ST 5 Inner Sunset TARAVAL 37.762075283259 -122.471257612385 POINT (-122.47125761 37.76207528) Phone   109 10 11 14 11 1 5 56 8 12 12   109   11             1         109
2630206 2630206 6074401 2016-07-12T12:05:49 2016-09-07T16:16:37 2016-09-07T16:16:37 Closed 2 DPH Environmental Health 415-252-3800 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of ALEMANY BLVD and ADMIRAL AVE ALEMANY BLVD 11 Mission Terrace INGLESIDE 37.730575978561 -122.430945238684 POINT (-122.43094524 37.73057598) Phone   94 9 1 28 6 9 4 28,861 7 25 25 16 94   1             1         94
2662551 2662551 6203880 2016-08-16T20:15:56 2016-09-08T09:59:05 2016-09-08T09:59:05 Closed 2 DPH Environmental Health 415-252-3800 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 1304 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission MISSION 37.751856906229 -122.420835819436 POINT (-122.42083582 37.75185691) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
2854296 2854296 6719282 2017-01-11T15:49:59 2017-01-18T07:34:44 2017-01-18T07:34:44 Closed 2 Not enough information 01/18/2017. DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 152 LAKE MERCED HILL ST, SAN FRANCISCO, CA, 94132 LAKE MERCED HILL ST SOUTH 7 Lakeshore TARAVAL 37.709018060092 -122.483829967928 POINT (-122.48382997 37.70901806) Phone   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
2981748 2981748 7049332 2017-04-15T19:11:16 2017-04-18T15:06:22 2017-04-18T15:06:22 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Other 445 45TH AVE, SAN FRANCISCO, CA, 94121 45TH AVE 1 Sutro Heights RICHMOND 37.780000311358 -122.50653435487499 POINT (-122.50653435 37.78000031) Mobile/Open311   6 8 4 29 2 11 9 55 6 26 26   6   4             1         6
3131306 3131306 8207473 2017-10-31T08:42:00 2017-11-01T11:24:00 2017-11-01T11:24:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Other 154 LISBON ST, SAN FRANCISCO, CA, 94112 LISBON ST 11 Excelsior INGLESIDE 37.725808612652 -122.430762046252 POINT (-122.43076205 37.72580861) Mobile/Open311   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
3132490 3132490 8075992 2017-09-28T10:31:00 2017-10-02T10:08:00 2017-10-02T10:08:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Other 121 BURNSIDE AVE, SAN FRANCISCO, CA, 94131 BURNSIDE AVE 8 Sunnyside INGLESIDE 37.733951568604 -122.43838500976601 POINT (-122.43838501 37.73395157) Phone   95 9 5 41 5 9 4 63 7 40 40   95   5             1         95
3267728 3267728 8415813 2017-12-21T20:48:00 2017-12-26T15:29:00 2017-12-26T15:29:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of FELLA PL and POWELL ST FELLA PL 3 Nob Hill CENTRAL 37.790687690412 -122.409037123617 POINT (-122.40903712 37.79068769) Mobile/Open311 http://mobile311.sfgov.org/reports/8415813/photos 16 6 3 21 10 5 1 28,857 1 21 21   16   3             1         16
3714213 3714213 11206972 2019-07-31T14:16:00 2019-08-12T11:09:00 2019-08-12T11:09:00 Closed 2 DPH Environmental Health Healthy Housing & Vector Control Program 415-252-3805 DPH - Environmental Health - G 30 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 1940 VALLEJO ST, SAN FRANCISCO, CA, 94123 VALLEJO ST 2 Pacific Heights NORTHERN 37.796073913574 -122.42928314209 POINT (-122.42928314 37.79607391) Phone   102 4 6 13 1 13 6 57 9 17 17   102   6             1         102

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