calls

4 rows where Responsible_Agency = 18

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
55235 55235 11472668 2019-09-27T09:17:00 2019-09-27T11:49:00 2019-09-27T11:49:00 Closed 2 landscaping noted. SFMTA - Muni System Feedback Queue 18 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BAY SHORE BLVD and LOIS LN BAY SHORE BLVD 10 Little Hollywood INGLESIDE 37.713908 -122.39983400000001 POINT (-122.399834 37.713908) Mobile/Open311   89 9 9 40 8 10 4 309 7 39 39   89   9             2         89
2338074 2338074 5386245 2015-12-18T11:06:32 2016-03-01T12:35:12 2016-03-01T12:35:12 Closed 2 to PSR #493791 SFMTA - Muni System Feedback Queue 18 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GREAT HWY and TARAVAL ST GREAT HWY 4 Outer Sunset TARAVAL 37.741671392431 -122.506864755319 POINT (-122.50686476 37.74167139) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
3491924 3491924 9020338 2018-05-18T17:23:00 2018-05-22T14:16:00 2018-05-22T14:16:00 Closed 2 already dealt with when reported SFMTA - Muni System Feedback Queue 18 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of WEBSTER ST and MCALLISTER ST WEBSTER ST 5 Western Addition NORTHERN 37.77885055542 -122.43004608154301 POINT (-122.43004608 37.77885056) Phone   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
3848385 3848385 11426037 2019-09-17T07:30:00 2019-09-19T15:46:00 2019-09-19T15:46:00 Closed 2 Comment noted on bushes. SFMTA - Muni System Feedback Queue 18 Tree Maintenance 1 Trees - Landscaping 5 Other 3546 21ST ST, SAN FRANCISCO, CA, 94114 21ST ST 8 Dolores Heights MISSION 37.756664276123 -122.426742553711 POINT (-122.42674255 37.75666428) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52

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