calls

5 rows where Responsible_Agency = 37

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
675866 675866 305252 2008-10-28T19:29:18 2008-10-31T14:51:57 2008-10-31T14:51:57 Closed 2 Duplicate of #305249 RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Pine Lake Park, SAN FRANCISCO, CA, 94132 Pine Lake Park 4 Parkside TARAVAL 37.736309051514 -122.48593139648399 POINT (-122.4859314 37.73630905) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
684338 684338 400535 2009-03-29T19:21:41 2013-09-09T15:31:38 2013-09-09T15:31:38 Closed 2   RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of ALEMANY BLVD and CHESTER AVE ALEMANY BLVD 7 Merced Heights TARAVAL 37.709899902344 -122.470405578613 POINT (-122.47040558 37.7098999) Phone   65 10 8 24 4 9 5 64 8 24 24   65   8             2         65
719590 719590 305953 2008-10-30T08:57:27 2008-10-30T10:03:53 2008-10-30T10:03:53 Closed 2 Aware of issues with broken sprinkler RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues McCoppin Square, SAN FRANCISCO, CA, 94116 McCoppin Square 4 Parkside TARAVAL 37.743827819824 -122.480079650879 POINT (-122.48007965 37.74382782) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7 25 8   24     1         40
795487 795487 294154 2008-10-07T20:53:52 2008-10-09T17:10:39 2008-10-09T17:10:39 Closed 2 Hose repaired. RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Sigmund Stern Recreation Grove, SAN FRANCISCO, CA, 94132 Sigmund Stern Recreation Grove 4 Parkside TARAVAL 37.736083984375 -122.47829437255899 POINT (-122.47829437 37.73608398) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
943745 943745 745421 2010-10-03T18:14:09 2011-11-29T16:13:04 2011-11-29T16:13:04 Closed 2 Request cancelled. RPD Neighborhood Service Area 8 Queue 37 Tree Maintenance 1 Trees - Tree_Other 4 Other 236 CLAREMONT BLVD, SAN FRANCISCO, CA, 94127 CLAREMONT BLVD 7 West Portal TARAVAL 37.741607666016 -122.46450805664101 POINT (-122.46450806 37.74160767) Web   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46

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