calls

78 rows where Responsible_Agency = 19

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
56533 56533 11477780 2019-09-28T13:03:36 2019-09-28T15:06:00 2019-09-28T15:06:00 Closed 2 Need a street address for this issue RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CONCOURSE DR and MUSIC CONCOURSE ACCESS RD CONCOURSE DR 1 Golden Gate Park RICHMOND 37.770690917969 -122.469359340568 POINT (-122.46935934 37.77069092) Mobile/Open311 http://mobile311.sfgov.org/reports/11477780/photos 9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
102541 102541 9817366 2018-11-16T13:08:00 2018-11-20T20:52:00 2018-11-20T20:52:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 4715 LINCOLN WAY, SAN FRANCISCO, CA, 94122 LINCOLN WAY 4 Outer Sunset TARAVAL 37.764014 -122.50862099999999 POINT (-122.508621 37.764014) Mobile/Open311 http://mobile311.sfgov.org/reports/9817366/photos 39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
125192 125192 6083987 2016-07-15T08:33:07 2016-07-22T09:50:31 2016-07-22T09:50:31 Closed 2 Please state specific issues with trees. Thank you RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 295 DAY ST, SAN FRANCISCO, CA, 94131 DAY ST 8 Noe Valley INGLESIDE 37.743338162975995 -122.423393346236 POINT (-122.42339335 37.74333816) Phone   84 9 5 22 5 2 4 28,859 7 22 22   84   5             1         84
195637 195637 9121988 2018-06-11T12:26:00 2018-09-02T01:38:00 2018-09-02T01:38:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Other Grattan Playground, 1180 STANYAN ST, SAN FRANCISCO, CA, 94117 STANYAN ST 5 Ashbury Heights PARK 37.762388891064 -122.45164689231301 POINT (-122.45164689 37.76238889) Web   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
320585 320585 9731288 2018-10-28T09:09:00 2018-10-28T16:18:00 2018-10-28T16:18:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of JOHN MUIR DR and SKYLINE BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.720484966214 -122.500583141328 POINT (-122.50058314 37.72048497) Mobile/Open311 http://mobile311.sfgov.org/reports/9731288/photos 43 10 8 16 4 1 5 64 8 14 14   43   8             2         43
341475 341475 9691744 2018-10-18T19:40:00 2018-10-18T21:27:00 2018-10-18T21:27:00 Closed 2 SFFD, SFPD & RPD responded RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of VISITACION AVE and HAHN ST VISITACION AVE 10 Visitacion Valley INGLESIDE 37.71350479126 -122.41529083251999 POINT (-122.41529083 37.71350479) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
369856 369856 9515304 2018-09-09T07:57:00 2018-11-04T00:55:00 2018-11-04T00:55:00 Closed 2 Insufficient information was provided for park staff to identify and/ or locate the problem. Please provide additional information in a new 311 if the issue persists. If you attach a photo, please also describe the problem and where it is located. RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 480 UPPER TER, SAN FRANCISCO, CA, 94117 UPPER TER 8 Buena Vista PARK 37.763145446777 -122.445510864258 POINT (-122.44551086 37.76314545) Phone   112 7 5 3 5 15 8 29,492 5 9 9   112   5             1         112
385584 385584 9615652 2018-10-02T09:20:00 2018-10-03T06:34:00 2018-10-03T06:34:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 2019 LINCOLN WAY, SAN FRANCISCO, CA, 94122 LINCOLN WAY 4 Outer Sunset TARAVAL 37.76517868042 -122.479789733887 POINT (-122.47978973 37.76517868) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
419777 419777 9415369 2018-08-17T10:30:00 2018-08-17T20:32:00 2018-08-17T20:32:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Douglass Playground, , SAN FRANCISCO, CA, 94131 Douglass Playground 8 Diamond Heights MISSION 37.747276306152 -122.438934326172 POINT (-122.43893433 37.74727631) Phone   57 3 5 22 5 2 7 63 4 22 22   57   5             1         57
425316 425316 9550778 2018-09-17T09:25:33 2018-09-17T09:27:00 2018-09-17T09:27:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Other GGP Tree Fern Dell, , SAN FRANCISCO, CA, 94122 GGP Tree Fern Dell 1 Golden Gate Park RICHMOND 37.771225489338995 -122.46153249810101 POINT (-122.4615325 37.77122549) Mobile/Open311   9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
447174 447174 10322539 2019-01-06T17:08:00 2019-01-06T19:52:00 2019-01-06T19:52:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of UNIVERSITY ST and MANSELL ST UNIVERSITY ST 9 Portola BAYVIEW 37.719074249268 -122.410987854004 POINT (-122.41098785 37.71907425) Phone   91 2 9 19 8 9 3 309 3 18 18   91   9             2         91
471580 471580 10332554 2019-01-08T17:12:00 2019-01-10T15:00:00 2019-01-10T15:00:00 Closed 2 area does demonstrate to be on SF Park property RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 58 VERNA ST, SAN FRANCISCO, CA, 94127 VERNA ST 7 Miraloma Park INGLESIDE 37.7349807 -122.44835990000001 POINT (-122.4483599 37.7349807) Web   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
485397 485397 11416462 2019-09-14T16:39:00 2019-09-14T19:29:00 2019-09-14T19:29:00 Closed 2 Ranger dispatched to location RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of YALE ST and WAYLAND ST YALE ST 9 University Mound BAYVIEW 37.723083496094 -122.41592407226601 POINT (-122.41592407 37.7230835) Phone   92 2 2 25 7 9 3 309 3 28 28   92   2             1         92
487183 487183 9866468 2018-11-29T08:41:58 2018-11-29T10:36:00 2018-11-29T10:36:00 Closed 2 3W32 Out on foot between 18th and 20th and did not find any tree as being described as being hazardous. Code 4 RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 610 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Mission Dolores MISSION 37.759326933918 -122.426104964802 POINT (-122.42610496 37.75932693) Mobile/Open311 http://mobile311.sfgov.org/reports/9866468/photos 37 3 5 5 5 2 7 28,862 4 3 3   37   5             1   5     37
497172 497172 9947395 2018-12-17T16:36:00 2019-01-03T16:02:00 2019-01-03T16:02:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 96 AMETHYST WAY, SAN FRANCISCO, CA, 94131 AMETHYST WAY 8 Diamond Heights INGLESIDE 37.746131896973 -122.447250366211 POINT (-122.44725037 37.7461319) Phone   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
507081 507081 10321982 2019-01-06T13:55:00 2019-01-06T15:45:00 2019-01-06T15:45:00 Closed 2 No Merit. no tree, may have been a X-mas tree in the bus lane. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FULTON ST and 8TH AVE FULTON ST 1 Golden Gate Park RICHMOND 37.773399353027 -122.46588134765601 POINT (-122.46588135 37.77339935) Phone   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
552319 552319 10322537 2019-01-06T17:08:00 2019-01-06T19:52:00 2019-01-06T19:52:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MANSELL ST and UNIVERSITY ST MANSELL ST 9 Portola BAYVIEW 37.719074249268 -122.410987854004 POINT (-122.41098785 37.71907425) Phone   91 2 9 19 8 9 3 309 3 18 18   91   9             2         91
590036 590036 10489024 2019-02-14T11:49:26 2019-02-14T12:59:00 2019-02-14T12:59:00 Closed 2 Ranger dispatched to area to survey issue RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 22ND ST and CONNECTICUT ST 22ND ST 10 Potrero Hill BAYVIEW 37.757325001036 -122.39711804973801 POINT (-122.39711805 37.757325) Web   54 2 9 26 8 10 3 28,856 3 29 29   54   9             2         54
602955 602955 10594240 2019-03-12T17:03:00 2019-03-12T18:59:00 2019-03-12T18:59:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 9TH AVE and LINCOLN WAY 9TH AVE 5 Inner Sunset TARAVAL 37.765926361084 -122.466445922852 POINT (-122.46644592 37.76592636) Phone   9 10 11 12 11 11 5 56 8 8 8 2 9   11 2     2     1         9
629424 629424 10708193 2019-04-09T16:02:00 2019-04-09T21:18:00 2019-04-09T21:18:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FULTON ST and 32ND AVE FULTON ST 1 Outer Richmond RICHMOND 37.772228240967 -122.49169158935499 POINT (-122.49169159 37.77222824) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
642524 642524 10461137 2019-02-07T12:26:00 2019-05-06T18:13:00 2019-05-06T18:13:00 Closed 2 The tree stump is not leaning or about to fall, it is just the way the tree had grown, there are multiple trees there pointing in a diagonal way RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Rocky Outcrop, , SAN FRANCISCO, CA, 94116 Rocky Outcrop 7 Golden Gate Heights TARAVAL 37.753728318416 -122.47084983902 POINT (-122.47084984 37.75372832) Web http://mobile311.sfgov.org/reports/10461137/photos 44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
1793203 1793203 3877448 2014-07-31T16:46:55 2014-08-02T15:41:21 2014-08-02T15:41:21 Closed 2 same as SR #3877444 RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Portola Open Space, , SAN FRANCISCO, CA, 94114 Portola Open Space 8 Upper Market MISSION 37.746973 -122.44376299999999 POINT (-122.443763 37.746973) Mobile/Open311 http://mobile311.sfgov.org/reports/3877448/photos 51 3 5 22 5 2 7 63 4 22 22   51   5             1         51
1837099 1837099 3877451 2014-07-31T16:47:18 2014-08-02T15:43:28 2014-08-02T15:43:28 Closed 2 same as SR #3877444 RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Portola Open Space, , SAN FRANCISCO, CA, 94114 Portola Open Space 8 Upper Market MISSION 37.746973 -122.44376299999999 POINT (-122.443763 37.746973) Mobile/Open311 http://mobile311.sfgov.org/reports/3877451/photos 51 3 5 22 5 2 7 63 4 22 22   51   5             1         51
1865321 1865321 3877449 2014-07-31T16:47:12 2014-08-02T15:42:14 2014-08-02T15:42:14 Closed 2 same as SR #3877444 RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Portola Open Space, , SAN FRANCISCO, CA, 94114 Portola Open Space 8 Upper Market MISSION 37.746973 -122.44376299999999 POINT (-122.443763 37.746973) Mobile/Open311 http://mobile311.sfgov.org/reports/3877449/photos 51 3 5 22 5 2 7 63 4 22 22   51   5             1         51
1900845 1900845 3877452 2014-07-31T16:47:30 2014-08-02T15:44:48 2014-08-02T15:44:48 Closed 2 Same as SR #3877444. RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Portola Open Space, , SAN FRANCISCO, CA, 94114 Portola Open Space 8 Upper Market MISSION 37.746973 -122.44376299999999 POINT (-122.443763 37.746973) Mobile/Open311 http://mobile311.sfgov.org/reports/3877452/photos 51 3 5 22 5 2 7 63 4 22 22   51   5             1         51
2040928 2040928 4347338 2014-12-30T16:31:05 2014-12-31T09:20:10 2014-12-31T09:20:10 Closed 2 Same as #4347307. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Telegraph Hill/Pioneer Park, , SAN FRANCISCO, CA, 94133 Telegraph Hill/Pioneer Park 3 Telegraph Hill CENTRAL 37.803342230873 -122.406623474841 POINT (-122.40662347 37.80334223) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
2067537 2067537 4553988 2015-03-07T10:45:12 2015-03-09T11:30:20 2015-03-09T11:30:20 Closed 2 Same as #4556539 RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of VALENCIA ST and DUBOCE AVE VALENCIA ST 9 Mission Dolores MISSION 37.769865492482 -122.422367338622 POINT (-122.42236734 37.76986549) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5     3       2   3     37
2202240 2202240 4953563 2015-07-30T11:09:44 2015-07-30T12:00:52 2015-07-30T12:00:52 Closed 2 Duplicate case of case #4953557 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764101000000004 -122.42048100000001 POINT (-122.420481 37.764101) Mobile/Open311 http://mobile311.sfgov.org/reports/4953563/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2208929 2208929 4926102 2015-07-21T08:17:27 2015-07-21T08:48:00 2015-07-21T08:48:00 Closed 2 Same as #4909943. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764035 -122.42047 POINT (-122.42047 37.764035) Mobile/Open311 http://mobile311.sfgov.org/reports/4926102/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2255291 2255291 5240082 2015-10-30T15:44:37 2015-10-31T11:28:36 2015-10-31T11:28:36 Closed 2 Same as #5240079 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764236 -122.420277 POINT (-122.420277 37.764236) Mobile/Open311 http://mobile311.sfgov.org/reports/5240082/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2260108 2260108 4909943 2015-07-15T08:35:40 2015-07-15T12:22:15 2015-07-15T12:22:15 Closed 2 Same as SR #4903666 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764139 -122.420268 POINT (-122.420268 37.764139) Mobile/Open311 http://mobile311.sfgov.org/reports/4909943/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2284693 2284693 5240079 2015-10-30T15:43:45 2015-10-31T11:29:36 2015-10-31T11:29:36 Closed 2 see #5240068 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764223 -122.420258 POINT (-122.420258 37.764223) Mobile/Open311 http://mobile311.sfgov.org/reports/5240079/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2339188 2339188 5354848 2015-12-08T07:48:49 2015-12-08T16:29:51 2015-12-08T16:29:51 Closed 2 Per PSA Manager, DPW or RPD structural are not willing to deal with this. RPD has no power to make this replacement happen. These are on the sidewalk not in the park. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764072 -122.42048799999999 POINT (-122.420488 37.764072) Mobile/Open311 http://mobile311.sfgov.org/reports/5354848/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2343014 2343014 5281654 2015-11-13T11:57:33 2015-11-14T09:59:58 2015-11-14T09:59:58 Closed 2 Same as #5281661 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764032 -122.420474 POINT (-122.420474 37.764032) Mobile/Open311 http://mobile311.sfgov.org/reports/5281654/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2345751 2345751 5340053 2015-12-03T07:58:50 2015-12-05T09:33:51 2015-12-05T09:33:51 Closed 2 This has already been reported and addressed by park mgmt. Completion of work is still pending (RPD work order has been submitted). RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764195 -122.42038400000001 POINT (-122.420384 37.764195) Mobile/Open311   53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2346736 2346736 5424714 2016-01-02T12:20:28 2016-01-02T13:36:40 2016-01-02T13:36:40 Closed 2 Kid Power Park mgmt. is already aware of this complaint due to the fact that it has been reported many times. RPD is unable to follow-up with this customer because there is no contact information given by the customer. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.76412 -122.420367 POINT (-122.420367 37.76412) Mobile/Open311 http://mobile311.sfgov.org/reports/5424714/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2359188 2359188 5583317 2016-02-19T09:57:54 2016-02-19T11:46:26 2016-02-19T11:46:26 Closed 2 Duplicate case RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764171000000005 -122.42027900000001 POINT (-122.420279 37.764171) Mobile/Open311 http://mobile311.sfgov.org/reports/5583317/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2375360 2375360 5448278 2016-01-09T10:32:49 2016-01-09T11:34:39 2016-01-09T11:34:39 Closed 2 Please refer to SR #5371007, which is still open. This issue has been reported several times and park manager has been advised every time. Please contact 311 call center directly by telephone for further assistance. Thanks. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764168 -122.42031100000001 POINT (-122.420311 37.764168) Mobile/Open311 http://mobile311.sfgov.org/reports/5448278/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2378431 2378431 5549023 2016-02-08T19:08:16 2016-10-04T18:23:39 2016-10-04T18:23:39 Closed 2 RPD was advised of this graffiti this month, 2 years after it was reported. This site has been swept and abated for graffiti since. RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 19TH ST and DIAMOND ST 19TH ST 8 Eureka Valley MISSION 37.759308333333 -122.4366 POINT (-122.4366 37.75930833) Mobile/Open311 http://mobile311.sfgov.org/reports/5549023/photos 38 3 5 5 5 2 7 28,862 4 3 3   38   5         9   1   5     38
2387340 2387340 5357437 2015-12-08T17:20:52 2015-12-09T10:57:52 2015-12-09T10:57:52 Closed 2 Please see SR #5354848 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764205 -122.420326 POINT (-122.420326 37.764205) Mobile/Open311 http://mobile311.sfgov.org/reports/5357437/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2408213 2408213 5347339 2015-12-05T08:37:48 2015-12-05T09:34:33 2015-12-05T09:34:33 Closed 2 Already reported, see #5340053. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764208 -122.420277 POINT (-122.420277 37.764208) Mobile/Open311 http://mobile311.sfgov.org/reports/5347339/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2415576 2415576 5358415 2015-12-09T08:26:15 2015-12-09T17:15:15 2015-12-09T17:15:15 Closed 2 Since this is a repeat request, please close with reference to pending case number 5018546. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764165000000006 -122.42032900000001 POINT (-122.420329 37.764165) Mobile/Open311 http://mobile311.sfgov.org/reports/5358415/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2417516 2417516 5357419 2015-12-08T17:16:39 2015-12-09T10:58:09 2015-12-09T10:58:09 Closed 2 Please see SR #5354848. RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764159 -122.42026499999999 POINT (-122.420265 37.764159) Mobile/Open311 http://mobile311.sfgov.org/reports/5357419/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2469736 2469736 5693127 2016-03-23T13:45:25 2016-04-02T15:04:08 2016-04-02T15:04:08 Closed 2 Please state the reason for the complaint and direct location RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of CLARENDON AVE and PANORAMA DR CLARENDON AVE 7 Midtown Terrace PARK 37.753772168962996 -122.455537739653 POINT (-122.45553774 37.75377217) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
2487029 2487029 5761848 2016-04-14T08:29:18 2016-04-14T09:13:26 2016-04-14T09:13:26 Closed 2 same as #5761859 RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Kidpower Park, 45 HOFF ST, SAN FRANCISCO, CA, 94110 HOFF ST 6 Mission MISSION 37.764165999999996 -122.42035 POINT (-122.42035 37.764166) Mobile/Open311 http://mobile311.sfgov.org/reports/5761848/photos 53 3 2 20 7 8 7 28,859 4 19 19   53   2     3       2   3     53
2536510 2536510 5830504 2016-05-04T12:31:20 2016-05-18T09:45:00 2016-05-18T09:45:00 Closed 2 GGNRA was advised of this issue via email from the 311 call center on 5/11/16. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 48TH AVE and GEARY BLVD 48TH AVE 1 Sutro Heights RICHMOND 37.77887 -122.51033799999999 POINT (-122.510338 37.77887) Mobile/Open311   6   4 29 2 11 9 55 6 26 26   6   4             1         6
2638493 2638493 6423927 2016-10-15T13:11:20 2016-12-16T07:53:58 2016-12-16T07:53:58 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 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
2644772 2644772 6373911 2016-10-02T12:13:20 2016-10-02T15:16:53 2016-10-02T15:16:53 Closed 2 RPD has responded RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage GGP Petanque Courts, , SAN FRANCISCO, CA, 94122 GGP Petanque Courts 1 Golden Gate Park RICHMOND 37.771043 -122.499369 POINT (-122.499369 37.771043) Mobile/Open311 http://mobile311.sfgov.org/reports/6373911/photos 9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
2701525 2701525 6228219 2016-08-23T12:42:11 2016-10-04T18:26:33 2016-10-04T18:26:33 Closed 2 Site unknown. RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 171 FOREST KNOLLS DR, SAN FRANCISCO, CA, 94131 FOREST KNOLLS DR 7 Forest Knolls PARK 37.754595262284 -122.455597462389 POINT (-122.45559746 37.75459526) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
2738783 2738783 6486080 2016-11-01T20:34:39 2017-02-03T16:00:47 2017-02-03T16:00:47 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2511 20TH AVE, SAN FRANCISCO, CA, 94116 20TH AVE 4 Parkside TARAVAL 37.740849 -122.476875 POINT (-122.476875 37.740849) Web   40 10 7 35 3 1 5 29,491 8 35 35   40   7             1         40
2756096 2756096 6705151 2017-01-08T12:33:55 2017-01-11T11:08:56 2017-01-11T11:08:56 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 309 CRESTMONT DR, SAN FRANCISCO, CA, 94131 CRESTMONT DR 7 Forest Knolls PARK 37.757313098615 -122.460326010861 POINT (-122.46032601 37.7573131) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
2789311 2789311 6719755 2017-01-11T17:29:07 2017-01-20T09:59:12 2017-01-20T09:59:12 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 150 MIDCREST WAY, SAN FRANCISCO, CA, 94131 MIDCREST WAY 7 Midtown Terrace PARK 37.749313332356 -122.448516666779 POINT (-122.44851667 37.74931333) Mobile/Open311 http://mobile311.sfgov.org/reports/6719755/photos 48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
2791380 2791380 6709921 2017-01-09T14:18:53 2017-01-10T14:23:37 2017-01-10T14:23:37 Closed 2 Same as #6710066 RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 118 KENSINGTON WAY, SAN FRANCISCO, CA, 94127 KENSINGTON WAY 7 Laguna Honda TARAVAL 37.741645 -122.460305 POINT (-122.460305 37.741645) Mobile/Open311 http://mobile311.sfgov.org/reports/6709921/photos 49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
2808799 2808799 6714146 2017-01-10T14:29:46 2017-01-20T09:58:59 2017-01-20T09:58:59 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 150 MIDCREST WAY, SAN FRANCISCO, CA, 94131 MIDCREST WAY 7 Midtown Terrace PARK 37.749325385981 -122.448380790962 POINT (-122.44838079 37.74932539) Mobile/Open311 http://mobile311.sfgov.org/reports/6714146/photos 48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
2828004 2828004 6545990 2016-11-18T16:01:15 2016-11-19T11:46:33 2016-11-19T11:46:33 Closed 2 Please state where the tree damage is located RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 863 VERMONT ST, SAN FRANCISCO, CA, 94107 VERMONT ST 10 Potrero Hill BAYVIEW 37.75877608657 -122.403756651822 POINT (-122.40375665 37.75877609) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
2846626 2846626 6715731 2017-01-10T23:30:29 2017-01-20T15:10:17 2017-01-20T15:10:17 Closed 2 original Case 6718041 RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 197 PORTOLA DR, SAN FRANCISCO, CA, 94131 PORTOLA DR 8 Upper Market MISSION 37.74680885811 -122.44509826516199 POINT (-122.44509827 37.74680886) Mobile/Open311   57 9 5 22 5 2 4 63 7 22 22   57   5             1         57
2872809 2872809 6839151 2017-02-13T17:57:32 2017-02-25T03:50:56 2017-02-25T03:50:56 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of 16TH AVE and FULTON ST 16TH AVE 1 Golden Gate Park RICHMOND 37.772943952824 -122.474561539424 POINT (-122.47456154 37.77294395) Mobile/Open311 http://mobile311.sfgov.org/reports/6839151/photos 9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
2905817 2905817 6864720 2017-02-21T15:13:10 2017-02-21T22:50:38 2017-02-21T22:50:38 Closed 2 original 6864734 RPD NSA Queue 19 Tree Maintenance 1 Trees - Tree_Other 4 Other GGP Middle Lake, , SAN FRANCISCO, CA, 94122 GGP Middle Lake 1 Golden Gate Park RICHMOND 37.767313813974 -122.500508987836 POINT (-122.50050899 37.76731381) Web   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
2955547 2955547 7004142 2017-04-03T11:28:10 2017-04-07T15:00:58 2017-04-07T15:00:58 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 2043 WAWONA ST, SAN FRANCISCO, CA, 94132 WAWONA ST 4 Parkside TARAVAL 37.736289903836 -122.489226437604 POINT (-122.48922644 37.7362899) Web   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
2968110 2968110 7033608 2017-04-11T11:10:17 2017-04-11T11:23:53 2017-04-11T11:23:53 Closed 2 Tree down already reported in SR #7002132. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Peixotto Playground, , SAN FRANCISCO, CA, 94114 Peixotto Playground 8 Corona Heights PARK 37.765397275833 -122.43774114188 POINT (-122.43774114 37.76539728) Mobile/Open311 http://mobile311.sfgov.org/reports/7033608/photos 113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
2974360 2974360 6814150 2017-02-07T06:25:04 2017-03-01T00:39:04 2017-03-01T00:39:04 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of OAK ST and STANYAN ST OAK ST 5 Golden Gate Park PARK 37.771193308283 -122.454126514782 POINT (-122.45412651 37.77119331) Mobile/Open311 http://mobile311.sfgov.org/reports/6814150/photos 9 7 11 12 11 11 8 29,492 5 8 8   9   11             1         9
3107218 3107218 7430622 2017-07-27T21:03:01 2017-08-12T17:53:38 2017-08-12T17:53:38 Closed 2 Unable to process request with the information provided RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 7TH AVE and FULTON ST 7TH AVE 1 Inner Richmond RICHMOND 37.773463299999996 -122.46483300000001 POINT (-122.464833 37.7734633) Web   9 8 4 12 2 11 9 54 6 8 8 6 9   4 7     7     1         9
3129675 3129675 7549208 2017-08-25T09:24:00 2017-12-19T15:02:00 2017-12-19T15:02:00 Closed 2 This is not RPD property. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of CRESTMONT DR and DEVONSHIRE WAY CRESTMONT DR 7 Forest Knolls PARK 37.755933026163 -122.45956649222799 POINT (-122.45956649 37.75593303) Phone   111 7 8 14 4 1 8 63 5 12 12   111   8             1         111
3200749 3200749 8152820 2017-10-17T15:34:00 2017-10-17T23:12:00 2017-10-17T23:12:00 Closed 2 Information received and ranger dispatched RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FELL ST and ASHBURY ST FELL ST 5 Panhandle PARK 37.772789001465 -122.447494506836 POINT (-122.44749451 37.772789) Phone   24 7 11 12 11 15 8 29,492 5 8 8   24   11             1         24
3204794 3204794 8202143 2017-10-30T07:46:10 2017-10-30T09:16:00 2017-10-30T09:16:00 Closed 2 Same as #8202134 RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Sgt. John Macaulay Park, , SAN FRANCISCO, CA, 94109 Sgt. John Macaulay Park 6 Tenderloin TENDERLOIN 37.785422 -122.418277 POINT (-122.418277 37.785422) Mobile/Open311 http://mobile311.sfgov.org/reports/8202143/photos 20 5 10 36 9 13 6 28,858 9 36 36   20   10   15     10 1 2 1   41 11 20
3239694 3239694 8114603 2017-10-07T18:14:11 2017-10-08T08:49:00 2017-10-08T08:49:00 Closed 2 No specific location given for issue. Please resubmit 311 request with additional information. Thank You RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Golden Gate Park, , SAN FRANCISCO, CA, 94122 Golden Gate Park 1 Golden Gate Park RICHMOND 37.768946666667 -122.478378333333 POINT (-122.47837833 37.76894667) Mobile/Open311 http://mobile311.sfgov.org/reports/8114603/photos 9 8 4 12 2 11 9 54 6 8 8   9   4             1         9
3274417 3274417 8524494 2018-01-18T17:38:00 2018-01-18T19:05:00 2018-01-18T19:05:00 Closed 2 RPD and S SFFD moved the tree out of lanes of traffic RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PARK PRESIDIO BLVD and GEARY BLVD PARK PRESIDIO BLVD 1 Inner Richmond RICHMOND 37.780654907227 -122.472312927246 POINT (-122.47231293 37.78065491) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
3329510 3329510 8345901 2017-12-04T17:41:00 2017-12-04T18:54:00 2017-12-04T18:54:00 Closed 2 Ranger and tree toppers cut the tree and moved it out of the road. It is no longer blocking traffic RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FULTON ST and 8TH AVE FULTON ST 1 Golden Gate Park RICHMOND 37.773399353027 -122.46588134765601 POINT (-122.46588135 37.77339935) Phone   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
3341065 3341065 8665955 2018-02-22T13:23:00 2018-03-01T00:46:00 2018-03-01T00:46:00 Closed 2 Not enough information included in request for action to be taken. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of KEARNY ST and LOMBARD ST KEARNY ST 3 Telegraph Hill CENTRAL 37.8035447 -122.40630520000002 POINT (-122.4063052 37.8035447) Mobile/Open311   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
3412212 3412212 8781848 2018-03-23T21:14:00 2018-06-20T13:31:00 2018-06-20T13:31:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 575 RAYMOND AVE, SAN FRANCISCO, CA, 94134 RAYMOND AVE 10 Visitacion Valley INGLESIDE 37.715278625488 -122.41506195068399 POINT (-122.41506195 37.71527863) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
3416117 3416117 8860681 2018-04-11T17:29:40 2018-04-12T00:36:00 2018-04-12T00:36:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism Intersection of BRAZIL AVE and MANSELL ST BRAZIL AVE 9 McLaren Park INGLESIDE 37.719076652081 -122.422934857178 POINT (-122.42293486 37.71907665) Web   73 9 2 19 7 9 4 309 7 18 18   73   2             2         73
3419381 3419381 9022539 2018-05-19T16:28:00 2018-05-19T18:37:00 2018-05-19T18:37:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ARGUELLO BLVD and ANZA ST ARGUELLO BLVD 1 Inner Richmond RICHMOND 37.779335021973 -122.45873260498001 POINT (-122.4587326 37.77933502) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
3452607 3452607 8807553 2018-03-30T10:38:00 2019-06-20T10:13:51 2019-06-20T10:13:51 Closed 2 Unable to Locate Close Note: Please resubmit with a photo of the issue and better directions to the issue as we are having trouble locating it. RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Golden Gate Park, , SAN FRANCISCO, CA, 94122 Golden Gate Park 1 Golden Gate Park RICHMOND 37.769058227539 -122.48094940185499 POINT (-122.4809494 37.76905823) Phone   9 8 4 12 2 11 9 55 6 8 8   9   4             1         9
3505733 3505733 8909434 2018-04-23T16:23:00 2018-04-24T00:39:00 2018-04-24T00:39:00 Closed 2   RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of PARK PRESIDIO BLVD and CLEMENT ST PARK PRESIDIO BLVD 1 Inner Richmond RICHMOND 37.782577514648 -122.472450256348 POINT (-122.47245026 37.78257751) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
3528577 3528577 8942874 2018-05-01T10:41:00 2018-06-12T00:32:00 2018-06-12T00:32:00 Closed 2 Not enough information included in this request for an appropriate action. Please resubmit a request with a more detailed description of the problem, location of the issue, and a photo. Thanks RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1230 TWIN PEAKS BLVD, SAN FRANCISCO, CA, 94131 TWIN PEAKS BLVD 7 Midtown Terrace PARK 37.746406555176 -122.44997406005899 POINT (-122.44997406 37.74640656) Phone   48 7 8 38 4 2 8 63 5 38 38   48   8             1         48
3688412 3688412 10844342 2019-05-10T11:21:00 2019-05-15T11:33:00 2019-05-15T11:33:00 Closed 2 Please provide more information: what is the problem with the tree? Also a perspective photograph or map app pin drop would help. Thanks RPD NSA Queue 19 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of DOUGLASS ST and SEWARD ST DOUGLASS ST 8 Eureka Valley MISSION 37.75785446167 -122.439071655273 POINT (-122.43907166 37.75785446) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1         115
3763035 3763035 11384101 2019-09-07T20:43:00 2019-09-12T19:15:00 2019-09-12T19:15:00 Closed 2 Ranger dispatched to location to verify RPD NSA Queue 19 Tree Maintenance 1 Trees - Damaged_Tree 1 Damaged_vandalism 1540 OAK ST, SAN FRANCISCO, CA, 94117 (Virtual) OAK ST 5 Panhandle PARK 37.772282000000004 -122.44471999999999 POINT (-122.44472 37.772282) Mobile/Open311   24 7 11 12 11 15 8 29,492 5 8 8   24   11             1         24
3843693 3843693 11446379 2019-09-21T10:55:00   2019-10-31T05:35:00 Open 1 sent RPD NSA Queue 19 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 880 CLIPPER ST, SAN FRANCISCO, CA, 94114 CLIPPER ST 8 Upper Market MISSION 37.747157957725 -122.443782205741 POINT (-122.44378221 37.74715796) Mobile/Open311 http://mobile311.sfgov.org/reports/11446379/photos 51 3 5 22 5 2 7 63 4 22 22   51   5             1         51

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