calls

4 rows where Responsible_Agency = 29

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
255588 255588 9148564 2018-06-17T16:20:00 2018-07-08T06:59:00 2018-07-08T06:59:00 Closed 2   RPD Golf Queue 29 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 3641 CLEMENT ST, SAN FRANCISCO, CA, 94121 CLEMENT ST 1 Outer Richmond RICHMOND 37.781422612868 -122.498358449592 POINT (-122.49835845 37.78142261) Mobile/Open311 http://mobile311.sfgov.org/reports/9148564/photos 8 8 4 17 2 11 9 55 6 15 15   8   4             1         8
599670 599670 10681277 2019-04-03T11:04:00   2019-04-03T16:51:35 Open 1 sent RPD Golf Queue 29 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1100 LAKE MERCED BLVD, SAN FRANCISCO, CA, 94132 LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.7136839 -122.4854213 POINT (-122.4854213 37.7136839) Web   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
2733461 2733461 6616630 2016-12-11T11:45:26 2019-01-14T09:31:00 2019-01-14T09:31:00 Closed 2 Confirmed completed by the manager. RPD Golf Queue 29 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 39TH AVE and CLEMENT ST 39TH AVE 1 Outer Richmond RICHMOND 37.78132744485 -122.499872150644 POINT (-122.49987215 37.78132744) Phone   8 8 4 17 2 11 9 55 6 15 15   8   4             1         8
2970794 2970794 7168746 2017-05-19T19:37:25 2018-08-30T12:35:48 2018-08-30T12:35:48 Closed 2 Due to the length this case has been open, Rec and Park believes this issue has been resolved. If the issue is still valid, please recreate the service request. RPD Golf Queue 29 Tree Maintenance 1 Trees - Landscaping 5 Other 99 HARDING RD, SAN FRANCISCO, CA, 94132 HARDING RD 7 Lakeshore TARAVAL 37.726374389837 -122.49323117508499 POINT (-122.49323118 37.72637439) Web   43 10 8 16 4 1 5 64 8 14 14   43   8             2         43

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