calls

29 rows where Responsible_Agency = 20

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
60094 60094 11419243 2019-09-15T14:08:00 2019-10-12T12:35:00 2019-10-12T12:35:00 Closed 2 Per caller, resolved. Lawn has been mowed. PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of 22ND AVE and SLOAT BLVD 22ND AVE 7 Merced Manor TARAVAL 37.734512329102 -122.477981567383 POINT (-122.47798157 37.73451233) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
98364 98364 9643309 2018-10-08T13:36:00 2019-02-26T15:52:00 2019-02-26T15:52:00 Closed 2 notified don lampe sfwd /cdd PUC - Water - G 20 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of LAKE MERCED BLVD and UNNAMED 129 LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.70913 -122.48498000000001 POINT (-122.48498 37.70913) Web http://mobile311.sfgov.org/reports/9643309/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
228363 228363 9289893 2018-07-19T16:08:00 2018-08-13T10:44:00 2018-08-13T10:44:00 Closed 2 W/O ISSUED TO SVC DEPT FOR LEAK AT METER. PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 100 MAGELLAN AVE, SAN FRANCISCO, CA, 94116 MAGELLAN AVE 7 Forest Hill TARAVAL 37.748699188232 -122.46022796630899 POINT (-122.46022797 37.74869919) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
640485 640485 10544282 2019-02-28T08:35:00 2019-03-21T09:15:00 2019-03-21T09:15:00 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BOWDOIN ST and WAYLAND ST BOWDOIN ST 9 Portola BAYVIEW 37.724070052685 -122.410110887295 POINT (-122.41011089 37.72407005) Mobile/Open311 http://mobile311.sfgov.org/reports/10544282/photos 91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
958715 958715 650061 2010-05-04T14:47:24 2010-05-13T12:12:44 2010-05-13T12:12:44 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BAY ST and LEAVENWORTH ST BAY ST 2 Russian Hill CENTRAL 37.805000305176 -122.41853332519501 POINT (-122.41853333 37.80500031) Phone   99 6 6 32 1 5 1 308 1 32 32   99   6             1         99
1519293 1519293 2502210 2013-06-17T19:32:10 2013-06-20T13:14:44 2013-06-20T13:14:44 Closed 2 Please refer to Real Estate Department PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of CRESCENT AVE and PUTNAM ST CRESCENT AVE 9 Bernal Heights INGLESIDE 37.7350730896 -122.411163330078 POINT (-122.41116333 37.73507309) Phone   83 9 2 2 7 10 4 28,859 7 2 2   83   2             1         83
1652978 1652978 3140710 2013-12-07T07:58:28 2013-12-07T11:31:06 2013-12-07T11:31:06 Closed 2 THE WATER DEPARTMENT IS AWARE OF THIS ISSUE AND IS CURRENTLY WORKING IN IT - THANK YOU PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of PORTOLA DR and 15TH AVE PORTOLA DR 7 West Portal TARAVAL 37.736185227188 -122.469941305076 POINT (-122.46994131 37.73618523) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8             1         46
1679516 1679516 2919340 2013-10-08T07:56:37 2013-10-08T13:24:42 2013-10-08T13:24:42 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1575 BURKE AVE, SAN FRANCISCO, CA, 94124 BURKE AVE 10 India Basin BAYVIEW 37.744514465331996 -122.386459350586 POINT (-122.38645935 37.74451447) Phone   76 2 9 1 8 10 3 58 3 1 1   76   9             1         76
1709660 1709660 3070760 2013-11-16T08:35:54 2013-11-16T09:36:57 2013-11-16T09:36:57 Closed 2 Spoke to 311 about this. PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 22ND AVE and SLOAT BLVD 22ND AVE 7 Merced Manor TARAVAL 37.734512329102 -122.477981567383 POINT (-122.47798157 37.73451233) Phone   62 10 8 35 4 1 5 64 8 35 35   62   8             1         62
1716171 1716171 2739648 2013-08-21T16:51:35 2013-08-21T21:30:11 2013-08-21T21:30:11 Closed 2 TO CSP SUPERVISOR QUEUE, NOT SFWD PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of HOWARD ST and THE EMBARCADERO HOWARD ST 6 Financial District SOUTHERN 37.792518615723 -122.39099884033199 POINT (-122.39099884 37.79251862) Phone http://mobile311.sfgov.org/reports/2739648/photos 108 1 10 8 9 6 2 28,855 2 6 6   108   10     4       1   4     108
1814301 1814301 3872849 2014-07-30T10:42:00 2014-07-31T08:23:05 2014-07-31T08:23:05 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and MERCEDES WAY JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.726807841327 -122.471702123197 POINT (-122.47170212 37.72680784) Phone http://mobile311.sfgov.org/reports/3872849/photos 67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
1814849 1814849 3716275 2014-06-06T17:19:22 2014-06-06T18:30:08 2014-06-06T18:30:08 Closed 2 w/o issued PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of RUTLAND ST and WILDE AVE RUTLAND ST 10 Visitacion Valley INGLESIDE 37.717325454546 -122.40537338636899 POINT (-122.40537339 37.71732545) Mobile/Open311 http://mobile311.sfgov.org/reports/3716275/photos 75 9 9 40 8 10 4 309 7 39 39   75   9             2         75
1844348 1844348 3848312 2014-07-22T07:08:53 2014-07-23T09:27:05 2014-07-23T09:27:05 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and PALOMA AVE JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.728906836167 -122.471847733053 POINT (-122.47184773 37.72890684) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
1856180 1856180 3710460 2014-06-05T08:13:37 2014-07-03T12:44:50 2014-07-03T12:44:50 Closed 2 SEE #3792508 PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 25TH AVE and IRVING ST 25TH AVE 4 Outer Sunset TARAVAL 37.763278146104 -122.48355586229799 POINT (-122.48355586 37.76327815) Phone   39 10 7 35 3 1 5 56 8 35 35 9 39   7 11     11     1         39
1857868 1857868 3464657 2014-03-18T05:58:12 2014-03-29T14:12:29 2014-03-29T14:12:29 Closed 2 w/o issued . PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and MERCEDES WAY JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.726807841327 -122.471702123197 POINT (-122.47170212 37.72680784) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
1894793 1894793 3758484 2014-06-20T11:50:27 2014-07-03T16:45:43 2014-07-03T16:45:43 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and MERCEDES WAY JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.726807841327 -122.471702123197 POINT (-122.47170212 37.72680784) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
1909173 1909173 3408028 2014-02-27T10:27:52 2014-02-28T15:16:26 2014-02-28T15:16:26 Closed 2 Spoke to customer. This is NOT on SFWD property. This tree is a Private Property issue at apt complex. PUC - Water - G 20 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 654 CLARENDON AVE, SAN FRANCISCO, CA, 94131 CLARENDON AVE 7 Forest Knolls PARK 37.751980200598 -122.45923389936002 POINT (-122.4592339 37.7519802) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
1937865 1937865 4001175 2014-09-11T07:40:03 2014-09-11T08:53:34 2014-09-11T08:53:34 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of SOUTHWOOD DR and MIRAMAR AVE SOUTHWOOD DR 7 Westwood Park INGLESIDE 37.725071782336 -122.45819601563299 POINT (-122.45819602 37.72507178) Phone   71 9 8 41 4 9 4 28,861 7 40 40   71   8 19     19     1         71
2012456 2012456 4144498 2014-10-25T10:50:25 2014-10-25T13:40:20 2014-10-25T13:40:20 Closed 2 To file a complaint, call 551 3000 Mon-Fri PUC - Water - G 20 Tree Maintenance 1 Trees - Tree_Other 4 Other 3327 20TH ST, SAN FRANCISCO, CA, 94110 20TH ST 9 Mission MISSION 37.7587582 -122.41518020000001 POINT (-122.4151802 37.7587582) Mobile/Open311   53 3 2 20 7 2 7 28,859 4 19 19 13 53   2 15   3 15     2   3     53
2022449 2022449 4031037 2014-09-20T12:38:52 2014-09-20T13:21:42 2014-09-20T13:21:42 Closed 2 No callback for further info . PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and MERCEDES WAY JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.726807841327 -122.471702123197 POINT (-122.47170212 37.72680784) Phone http://mobile311.sfgov.org/reports/4031037/photos 67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
2149952 2149952 4622502 2015-03-31T06:49:43 2015-04-03T10:25:29 2015-04-03T10:25:29 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of HARRISON ST and SPEAR ST HARRISON ST 6 Rincon Hill SOUTHERN 37.788837432861 -122.38942718505899 POINT (-122.38942719 37.78883743) Phone   30 1 10 8 9 6 2 28,855 2 6 6   30   10         3   1         30
2197344 2197344 4867164 2015-06-30T10:20:21 2015-07-13T10:19:30 2015-07-13T10:19:30 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 773 BURROWS ST, SAN FRANCISCO, CA, 94134 BURROWS ST 9 Portola BAYVIEW 37.726619720459 -122.41082763671899 POINT (-122.41082764 37.72661972) Web   91 2 2 25 7 9 3 309 3 28 28   91   2             1         91
2438655 2438655 5593569 2016-02-22T17:33:08 2016-02-23T13:11:09 2016-02-23T13:11:09 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Tree_Other 4 Other 2670 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Outer Mission INGLESIDE 37.714225769043004 -122.448585510254 POINT (-122.44858551 37.71422577) Integrated Agency   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
2524004 2524004 5773788 2016-04-18T11:10:55 2016-04-18T13:50:55 2016-04-18T13:50:55 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of GREENWICH ST and HYDE ST GREENWICH ST 2 Russian Hill CENTRAL 37.801060646618 -122.419425801067 POINT (-122.4194258 37.80106065) Phone   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
2810936 2810936 6704764 2017-01-08T11:09:36 2017-01-19T12:21:46 2017-01-19T12:21:46 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 56 AGUA WAY, SAN FRANCISCO, CA, 94127 AGUA WAY 7 Miraloma Park INGLESIDE 37.742198932199 -122.452410471551 POINT (-122.45241047 37.74219893) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
2927269 2927269 6982149 2017-03-27T18:28:24 2017-03-30T08:06:28 2017-03-30T08:06:28 Closed 2 Not a water issue, please redirect complaint. PUC - Water - G 20 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1188 LOMBARD ST, SAN FRANCISCO, CA, 94109 LOMBARD ST 2 Russian Hill CENTRAL 37.801731879795 -122.42081589558398 POINT (-122.4208159 37.80173188) Mobile/Open311 http://mobile311.sfgov.org/reports/6982149/photos 107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107
3358181 3358181 8562852 2018-01-28T17:06:00 2018-01-29T14:02:00 2018-01-29T14:02:00 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 252 EVELYN WAY, SAN FRANCISCO, CA, 94127 EVELYN WAY 7 Miraloma Park INGLESIDE 37.742665046732995 -122.44921970177201 POINT (-122.4492197 37.74266505) Mobile/Open311 http://mobile311.sfgov.org/reports/8562852/photos 72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
3500219 3500219 8964618 2018-05-06T10:21:00 2018-10-09T07:26:00 2018-10-09T07:26:00 Closed 2 TIMELINE PUC - Water - G 20 Tree Maintenance 1 Trees - Landscaping 5 Weeding 301 JUNIPERO SERRA BLVD, SAN FRANCISCO, CA, 94127 JUNIPERO SERRA BLVD 7 Ingleside Terraces TARAVAL 37.730484008789 -122.47137451171899 POINT (-122.47137451 37.73048401) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
3538508 3538508 10522410 2019-02-22T15:16:00 2019-03-05T06:34:00 2019-03-05T06:34:00 Closed 2   PUC - Water - G 20 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of GREENWICH ST and HYDE ST GREENWICH ST 2 Russian Hill CENTRAL 37.80118 -122.41960300000001 POINT (-122.419603 37.80118) Web   107 6 6 32 1 5 1 28,858 1 32 32   107   6             1         107

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