calls

21 rows where Responsible_Agency = 4

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
966 966 5683130 2016-03-20T14:29:18 2016-03-23T02:51:00 2016-03-23T02:51:00 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1455 44TH AVE, SAN FRANCISCO, CA, 94122 44TH AVE 4 Outer Sunset TARAVAL 37.759473663406 -122.503851056924 POINT (-122.50385106 37.75947366) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
507470 507470 2221950 2013-04-08T17:59:04 2016-04-11T05:06:06 2016-04-11T05:06:06 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 55 LUNDY'S LN, SAN FRANCISCO, CA, 94110 LUNDY'S LN 0     0.0 0.0 POINT (0 0) Phone                                                        
584389 584389 10534996 2019-02-26T08:18:00 2019-02-27T10:44:00 2019-02-27T10:44:00 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of JONES ST and GOLDEN GATE AVE JONES ST 6 Tenderloin TENDERLOIN 37.782073974609 -122.41222381591801 POINT (-122.41222382 37.78207397) Phone   20 5 10 36 9 7 10 28,852 10 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
602066 602066 10536114 2019-02-26T11:02:00 2019-02-27T08:22:00 2019-02-27T08:22:00 Closed 2 needs a packer - on corner alarge pile of trees DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of VERMONT ST and MARIPOSA ST VERMONT ST 10 Potrero Hill BAYVIEW 37.763381958008 -122.40437316894501 POINT (-122.40437317 37.76338196) Phone   54 2 9 26 8 8 3 28,856 3 29 29   54   9         15   1         54
1075471 1075471 657217 2010-05-16T11:46:07 2010-05-25T10:16:55 2010-05-25T10:16:55 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Weeding 2205 MISSION ST, SAN FRANCISCO, CA, 94110 MISSION ST 9 Mission MISSION 37.761669158936 -122.419158935547 POINT (-122.41915894 37.76166916) Phone   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
1136224 1136224 919094 2011-07-12T18:57:50 2011-07-13T10:06:13 2011-07-13T10:06:13 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DE LONG ST and SHAKESPEARE ST DE LONG ST 11 Outer Mission TARAVAL 37.70964050293 -122.46460723876999 POINT (-122.46460724 37.7096405) Web   66 10 1 28 6 9 5 28,861 8 25 25   66   1             2         66
1140356 1140356 956403 2011-09-06T11:05:13 2012-04-14T13:07:01 2012-04-14T13:07:01 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1760 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Russian Hill CENTRAL 37.797164916992 -122.418487548828 POINT (-122.41848755 37.79716492) Phone   107 6 3 32 10 5 1 28,858 1 32 32   107   3             1         107
1142392 1142392 941710 2011-08-16T08:48:20 2011-12-20T06:09:01 2011-12-20T06:09:01 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of MISSION ST and RUSSIA AVE MISSION ST 11 Cayuga INGLESIDE 37.721576690674 -122.437149047852 POINT (-122.43714905 37.72157669) Phone   80 9 1 28 6 9 4 28,861 7 25 25 4 80   1 4     4     2         80
1149419 1149419 956826 2011-09-06T17:04:17 2012-12-12T13:17:56 2012-12-12T13:17:56 Closed 2 resolved: DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ALEMANY BLVD and SICKLES AVE ALEMANY BLVD 11 Outer Mission INGLESIDE 37.710479736328004 -122.454887390137 POINT (-122.45488739 37.71047974) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
1186466 1186466 956564 2011-09-06T13:23:42 2011-09-13T11:10:44 2011-09-13T11:10:44 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 25 PROGRESS ST, SAN FRANCISCO, CA, 94124 PROGRESS ST 10 Bayview BAYVIEW 37.733459472656 -122.38394165039101 POINT (-122.38394165 37.73345947) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
1252761 1252761 1017801 2011-12-06T12:09:50 2011-12-12T12:07:05 2011-12-12T12:07:05 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 2149 LAGUNA ST, SAN FRANCISCO, CA, 94115 LAGUNA ST 2 Pacific Heights NORTHERN 37.790874481201 -122.42931365966801 POINT (-122.42931366 37.79087448) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
1279260 1279260 1123459 2012-05-13T14:29:04 2012-05-13T14:38:00 2012-05-13T14:38:00 Closed 2 sent to bsm via red button DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 45 WOOL ST, SAN FRANCISCO, CA, 94110 WOOL ST 9 Bernal Heights INGLESIDE 37.741111755371 -122.416870117188 POINT (-122.41687012 37.74111176) Mobile/Open311   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
1294609 1294609 1019228 2011-12-08T11:27:29 2011-12-16T13:04:00 2011-12-16T13:04:00 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 3060 PIERCE ST, SAN FRANCISCO, CA, 94123 PIERCE ST 2 Cow Hollow NORTHERN 37.798385620117 -122.43896484375 POINT (-122.43896484 37.79838562) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
1301561 1301561 1117202 2012-05-03T11:41:51 2017-05-31T16:25:34 2017-05-31T16:25:34 Closed 2 sidewalk has been repaired since 2/2017 DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 281 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Duboce Triangle PARK 37.76441192627 -122.435165405273 POINT (-122.43516541 37.76441193) Phone   28 7 5 5 5 15 8 28,862 5 3 3   28   5             1   5     28
1318902 1318902 1028895 2011-12-23T11:20:20 2011-12-23T17:09:01 2011-12-23T17:09:01 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 2712 36TH AVE, SAN FRANCISCO, CA, 94116 36TH AVE 4 Parkside TARAVAL 37.736427307129 -122.493377685547 POINT (-122.49337769 37.73642731) Phone   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
1528161 1528161 2217809 2013-04-08T06:20:35 2016-04-11T05:06:06 2016-04-11T05:06:06 Closed 2   DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 25 SOUTH HILL BLVD, SAN FRANCISCO, CA, 94112 SOUTH HILL BLVD 11 Crocker Amazon INGLESIDE 37.71195602417 -122.43197631835899 POINT (-122.43197632 37.71195602) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
1549984 1549984 2374817 2013-05-17T03:52:38   2013-05-17T05:43:41 Open 1 open DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 23RD ST and SOUTH VAN NESS AVE 23RD ST 9 Mission MISSION 37.753967285156 -122.41641235351601 POINT (-122.41641235 37.75396729) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
1933359 1933359 4161952 2014-10-30T18:15:14 2014-11-07T10:30:56 2014-11-07T10:30:56 Closed 2 resolved: i can see 3 signals from two blocks away. 4th light is bisiable morethan half a block away. if anyone cannot see these they should not be driving. DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of LINCOLN WAY and 19TH AVE LINCOLN WAY 5 Inner Sunset TARAVAL 37.765446070581 -122.477309120654 POINT (-122.47730912 37.76544607) Phone   39 10 7 35 3 11 5 56 8 35 35   39   7             1         39
1947612 1947612 4291858 2014-12-11T06:24:21 2016-04-11T17:31:18 2016-04-11T17:31:18 Closed 2 sent email DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of LINCOLN WAY and 43RD AVE LINCOLN WAY 4 Outer Sunset TARAVAL 37.764309441891996 -122.502978035536 POINT (-122.50297804 37.76430944) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
1995127 1995127 3926396 2014-08-18T10:51:35 2016-04-11T17:20:17 2016-04-11T17:20:17 Closed 2 done@ 2:23pm- city tree--- Called PGE - Tina 1-800-743-5000-line hanging- or Cable--1-800-934-6489--naomi----ticket-cr389357620- DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1011 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 5 Cathedral Hill NORTHERN 37.78124891678 -122.425721496193 POINT (-122.4257215 37.78124892) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
2277663 2277663 5129368 2015-09-24T16:02:26   2015-09-25T11:53:03 Open 1 open DPW - Bureau of Street Environmental Services - G 4 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1727 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 5 Lower Pacific Heights NORTHERN 37.785459753587 -122.433286058102 POINT (-122.43328606 37.78545975) Phone   103 4 11 15 11 13 6 29,490 9 13 13   103   11   24         2         103

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