calls

Custom SQL query returning 101 rows (hide)

Query parameters

rowidrowidCaseIDOpenedClosedUpdatedStatusStatus_NotesResponsible_AgencyCategoryRequest_TypeRequest_DetailsAddressStreetSupervisor_DistrictNeighborhoodPolice_DistrictLatitudeLongitudePointSourceMedia_URLSF_Find_NeighborhoodsCurrent_Police_DistrictsCurrent_Supervisor_DistrictsAnalysis_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_4iupNeighborhoods
13542 13542 4169880 2014-11-02T17:40:01 2014-11-29T10:07:40 2014-11-29T10:07:40 2 resolved: 2 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
14049 14049 5674640 2016-03-17T11:39:27 2016-05-27T02:38:00 2016-05-27T02:38:00 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
20043 20043 5651319 2016-03-10T09:12:49 2016-04-26T02:42:42 2016-04-26T02:42:42 2   2 1 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
104408 104408 9001048 2018-05-14T19:01:00 2018-05-15T07:34:37 2018-05-15T07:34:37 2   2 1 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
106724 106724 8384888 2017-12-13T22:04:00   2017-12-15T10:55:12 1 accepted 2 1 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
127658 127658 5837044 2016-05-05T22:51:48 2016-05-10T09:47:00 2016-05-10T09:47:00 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
131754 131754 5176596 2015-10-09T20:06:09 2016-01-16T02:33:00 2016-01-16T02:33:00 2 resolved: area was inspected and found to be cleared. 2 1 5 Vacant_lot_weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132001 132001 4572450 2015-03-13T13:08:21 2016-06-20T07:26:17 2016-06-20T07:26:17 2   2 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132250 132250 3730334 2014-06-11T09:46:00 2016-06-20T08:11:48 2016-06-20T08:11:48 2   2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132261 132261 3537207 2014-04-10T08:12:26   2016-06-16T15:13:40 1 accepted 2 1 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
135774 135774 4387002 2015-01-12T15:01:45 2016-08-17T15:25:34 2016-08-17T15:25:34 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
137122 137122 4991139 2015-08-12T09:07:22 2015-08-25T02:40:00 2015-08-25T02:40:00 2 resolved: 2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
140878 140878 10499352 2019-02-17T10:42:00   2019-02-17T11:15:06 1 accepted 2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
147510 147510 3284434 2014-01-18T09:31:04   2014-01-21T10:03:48 1 open 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
147761 147761 9251895 2018-07-11T09:32:00   2018-07-11T09:47:55 1 open 2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
151996 151996 8053291 2017-09-22T13:37:00 2018-02-13T10:44:14 2018-02-13T10:44:14 2 Please check the irrigation at this site. 2 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
252019 252019 9230993 2018-07-06T08:19:00 2018-12-04T13:09:46 2018-12-04T13:09:46 2 call presidio this is federal 2 1 3 Pruning_request 1809 WYMAN AVE, SAN FRANCISCO, CA, 94129 WYMAN AVE 2 Presidio National Park   37.789211911416004 -122.471173244249 POINT (-122.47117324 37.78921191) Mobile/Open311   3   6 27 1 11   61   30 30   3   6             1         3
486305 486305 4292315 2014-12-11T08:28:46 2014-12-29T11:38:00 2014-12-29T11:38:00 2 resolved: 2 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
543968 543968 374779 2009-02-19T12:46:01 2010-03-26T13:56:41 2010-03-26T13:56:41 2   2 1 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
547835 547835 9897323 2018-12-05T22:28:00 2019-06-25T16:23:35 2019-06-25T16:23:35 2   2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
796807 796807 379667 2009-02-27T12:41:38 2010-03-26T13:56:42 2010-03-26T13:56:42 2   2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
828321 828321 532703 2009-10-26T16:27:08 2011-03-17T12:09:52 2011-03-17T12:09:52 2 Confirmed with DPW - work previously completed. 2 1 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
973266 973266 759589 2010-10-25T22:27:01 2011-03-17T12:08:46 2011-03-17T12:08:46 2 Confirmed with DPW - work previously completed. 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1163868 1163868 893282 2011-06-03T07:37:29   2011-06-03T08:42:44 1 Open 2 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1199815 1199815 894565 2011-06-05T15:24:34   2011-06-05T16:09:38 1 Open 2 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1261651 1261651 975349 2011-10-03T09:15:25   2011-10-03T10:43:57 1 Open 2 1 5 Weeding Intersection of GREENWICH ST and LYON ST GREENWICH ST 2 Cow Hollow NORTHERN 37.797515869141 -122.447158813477 POINT (-122.44715881 37.79751587) Phone   14 4 6 27 1 13   57   30 30   14   6             1         14
1269000 1269000 1111743 2012-04-24T17:46:03   2012-04-25T09:54:48 1 Open 2 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1312541 1312541 1063243 2012-02-12T11:25:27   2012-02-12T12:23:16 1 Open 2 1 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1389941 1389941 1176640 2012-07-28T02:33:46   2014-10-09T07:04:00 1 scheduled 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1803037 1803037 3646040 2014-05-15T14:45:34   2014-05-15T15:26:49 1 new 2 1 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1924697 1924697 4152500 2014-10-28T09:15:19 2014-12-08T02:15:59 2014-12-08T02:15:59 2 resolved: 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1930607 1930607 4274287 2014-12-05T15:29:56 2016-06-20T08:05:28 2016-06-20T08:05:28 2   2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1931118 1931118 4038194 2014-09-22T20:31:26 2014-09-26T07:53:30 2014-09-26T07:53:30 2 cancelled: This location is under Rec and Park or the Olympic Club. This area is not under DPW responsibility. 2 1 3 Pruning_request Intersection of JOHN MUIR DR and LAKE MERCED BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
1938944 1938944 4039133 2014-09-23T08:51:29 2016-06-20T07:49:18 2016-06-20T07:49:18 2 All the trees on 1800 block of Pierce are Privately owned/maintained 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1940864 1940864 4081348 2014-10-06T13:59:08 2015-02-06T06:08:00 2015-02-06T06:08:00 2 resolved: 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1942660 1942660 4348667 2014-12-31T08:14:01 2016-06-20T08:00:43 2016-06-20T08:00:43 2   2 1 1 Fallen_tree Intersection of JOHN MUIR DR and LAKE MERCED BLVD JOHN MUIR DR 7 Lakeshore TARAVAL 37.708084106445 -122.48572540283199 POINT (-122.4857254 37.70808411) Phone                 28,589                                      
1946061 1946061 3974878 2014-09-02T14:40:33 2014-09-30T12:57:11 2014-09-30T12:57:11 2 resolved: 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1953248 1953248 3941651 2014-08-22T12:55:57 2014-09-10T12:48:03 2014-09-10T12:48:03 2 resolved: DPW did no work to this tree at all we do not top Bottlebrush trees we only raise the skirt 2 1 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1961440 1961440 3981394 2014-09-04T14:01:26 2014-09-05T01:59:42 2014-09-05T01:59:42 2 resolved: 2 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1968280 1968280 4155876 2014-10-29T08:32:17 2015-02-26T12:15:30 2015-02-26T12:15:30 2 cancelled: complaint was given to contractor and in October the contractor did send guy to litter pick area 2 1 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1968499 1968499 4313454 2014-12-18T08:12:17 2016-06-20T07:59:18 2016-06-20T07:59:18 2   2 1 1 Fallen_tree Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
1972937 1972937 4079809 2014-10-06T09:06:06 2014-10-08T07:26:22 2014-10-08T07:26:22 2 cancelled: 2 1 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
1974795 1974795 3978235 2014-09-03T14:40:53 2014-09-05T02:11:28 2014-09-05T02:11:28 2 resolved: 2 1 1 Damaged_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1987060 1987060 4041997 2014-09-23T18:54:45 2014-09-30T01:01:50 2014-09-30T01:01:50 2 resolved: 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1987997 1987997 3941376 2014-08-22T12:02:51 2014-08-22T04:24:49 2014-08-22T04:24:49 2 cancelled: 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
1989938 1989938 4105897 2014-10-14T09:45:59 2016-06-20T07:53:35 2016-06-20T07:53:35 2 Tree is privately maintained and responsibility of home owner 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1991722 1991722 3972728 2014-09-01T22:20:41 2014-09-10T09:50:47 2014-09-10T09:50:47 2 resolved: 2 1 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1992799 1992799 4011640 2014-09-14T17:42:07 2014-11-29T01:52:10 2014-11-29T01:52:10 2 resolved: joe Park Merced is way out by the Pacific Ocean(Robs Area) - Tom-Please note there is job number to charge to. 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
1997444 1997444 4011666 2014-09-14T17:50:53 2014-09-30T01:10:51 2014-09-30T01:10:51 2 resolved: Unsure if City or Privately Owned-- 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2002309 2002309 4065422 2014-10-01T10:45:18 2015-01-02T08:34:46 2015-01-02T08:34:46 2 cancelled: Inspected location trees just trimmed in November 2014 not work needed - 0 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2017299 2017299 3959233 2014-08-28T06:58:10 2014-09-24T06:50:34 2014-09-24T06:50:34 2 resolved: No city maintain trees on the 1200 block of Taylor Street 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2022441 2022441 4296089 2014-12-12T08:34:55 2014-12-29T11:08:00 2014-12-29T11:08:00 2 resolved: 2 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023753 2023753 4066053 2014-10-01T13:32:49 2014-10-16T12:58:31 2014-10-16T12:58:31 2 resolved: 2 1 2 Hitting_window_or_building Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2023982 2023982 3949041 2014-08-25T09:46:49 2014-09-24T01:51:13 2014-09-24T01:51:13 2 resolved: 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2029364 2029364 3989423 2014-09-07T18:02:38 2014-10-07T02:06:11 2014-10-07T02:06:11 2 resolved: 2 1 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2054000 2054000 4018281 2014-09-16T14:06:34 2014-12-08T02:14:32 2014-12-08T02:14:32 2 resolved: cleared signs 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2065689 2065689 4463860 2015-02-05T16:09:15 2015-02-28T12:38:00 2015-02-28T12:38:00 2 resolved: 2 1 5 Sprinkler_system_issues Pink Triangle Park, , SAN FRANCISCO, CA         0.0 0.0 POINT (0 0) Phone                                                        
2091336 2091336 4717579 2015-05-04T10:14:25 2015-08-06T12:37:00 2015-08-06T12:37:00 2 resolved: 2 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2107526 2107526 4821764 2015-06-12T09:53:05 2015-08-06T12:39:00 2015-08-06T12:39:00 2 resolved: 2 1 5 Lawn_mowing Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2159286 2159286 4391816 2015-01-14T05:33:16 2015-03-04T09:29:00 2015-03-04T09:29:00 2 resolved: 2 1 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
2184944 2184944 4468980 2015-02-07T09:30:04 2016-06-20T07:30:25 2016-06-20T07:30:25 2   2 1 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2213420 2213420 5041479 2015-08-28T04:34:49 2015-09-08T11:29:23 2015-09-08T11:29:23 2 cancelled: 2 1 1 Fallen_tree Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794704455931 -122.446729350584 POINT (-122.44672935 37.79470446) Phone   102 4 6 27 1 13   57   30 30   102   6             1         102
2238871 2238871 4983855 2015-08-10T12:22:39 2015-08-12T10:18:00 2015-08-12T10:18:00 2 resolved: 2 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2258425 2258425 4908412 2015-07-14T15:19:09 2015-07-15T05:50:04 2015-07-15T05:50:04 2 cancelled: 2 1 1 About_to_fall Intersection of LYON ST and UNION ST LYON ST 2 Cow Hollow NORTHERN 37.795638808894 -122.44687154396699 POINT (-122.44687154 37.79563881) Phone   14 4 6 27 1 13   57   30 30   14   6             1         14
2278578 2278578 5053746 2015-09-01T08:11:45 2015-09-12T08:13:00 2015-09-12T08:13:00 2 resolved: 2 1 5 Remove_garden_debris Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794704455931 -122.446729350584 POINT (-122.44672935 37.79470446) Phone   102 4 6 27 1 13   57   30 30   102   6             1         102
2296093 2296093 5218896 2015-10-23T15:19:55 2016-01-09T03:13:00 2016-01-09T03:13:00 2 resolved: 2 1 5 Shrubbery_blocking_visibility Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
2302481 2302481 4904095 2015-07-13T10:49:26 2015-07-15T11:52:00 2015-07-15T11:52:00 2 resolved: 2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2309584 2309584 4943026 2015-07-27T10:31:29 2015-08-06T11:43:08 2015-08-06T11:43:08 2 cancelled: 2 1 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2358787 2358787 5637975 2016-03-06T14:30:23 2016-03-11T02:52:00 2016-03-11T02:52:00 2   2 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2415625 2415625 5306360 2015-11-21T09:04:15 2016-06-01T04:47:00 2016-06-01T04:47:00 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2422975 2422975 5402492 2015-12-24T13:42:04 2016-02-26T01:39:00 2016-02-26T01:39:00 2 Case Resolved: 2 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2454064 2454064 5521292 2016-01-31T14:39:33 2016-02-23T03:14:00 2016-02-23T03:14:00 2 Case Resolved: 2 1 1 Fallen_tree Intersection of LAKE MERCED BLVD and JOHN MUIR DR LAKE MERCED BLVD 7 Lakeshore TARAVAL 37.708085129817 -122.485724047994 POINT (-122.48572405 37.70808513) Phone                 28,589                                      
2489252 2489252 5842130 2016-05-07T13:57:07 2016-07-05T09:51:00 2016-07-05T09:51:00 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2496103 2496103 5666514 2016-03-15T09:55:48 2016-03-30T12:09:09 2016-03-30T12:09:09 2   2 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2509427 2509427 5703919 2016-03-27T09:48:29 2016-06-01T07:14:00 2016-06-01T07:14:00 2   2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2527442 2527442 5920127 2016-05-29T11:53:47 2016-11-08T08:10:25 2016-11-08T08:10:25 2   2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
2529465 2529465 5909530 2016-05-25T18:42:27 2016-11-10T09:40:22 2016-11-10T09:40:22 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2529685 2529685 5734346 2016-04-05T20:55:01 2016-04-12T12:00:00 2016-04-12T12:00:00 2 Request closed by in Operations system at Apr 12 2016 12:00AM. Notes = " Notes:a few beanchesmeed to be pruned so stop sign is visible. :: Closed By CMMS SO 504491from CMMS: . BUF Action:Prune. date completed - 4/12/2016. ". 2 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2533831 2533831 5712230 2016-03-29T21:28:54   2016-03-29T21:46:27 1 accepted 2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2563186 2563186 5642032 2016-03-07T18:15:00 2016-06-02T03:36:00 2016-06-02T03:36:00 2   2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2575929 2575929 5661024 2016-03-13T16:40:14 2016-04-04T09:19:35 2016-04-04T09:19:35 2   2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2578512 2578512 5824292 2016-05-02T23:45:42 2016-08-22T23:10:53 2016-08-22T23:10:53 2 jade plants lying on the stair way. please clear 2 1 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2582298 2582298 5808257 2016-04-28T08:11:30 2016-08-22T23:11:21 2016-08-22T23:11:21 2 dpw maintained median at Delancey and Bryant? 2 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2584045 2584045 5776917 2016-04-19T08:15:29 2016-08-22T23:12:08 2016-08-22T23:12:08 2 they need a street inspector to come out . transferri g to BSM 2 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2585171 2585171 5721927 2016-04-01T15:34:29 2016-04-07T03:17:13 2016-04-07T03:17:13 2 Landscape area at 637 Hamilton is privately maintained. Not under the care and maintenance of Public Works. Please forward Service Order to correct property owner. Thank you. 2 1 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
2643853 2643853 6242537 2016-08-26T15:10:30 2016-08-27T13:40:25 2016-08-27T13:40:25 2 Inspected saw no spewing water or broken heads. 2 1 5 Sprinkler_system_issues Intersection of LAKE ST and PARK PRESIDIO BLVD LAKE ST 2 Lake Street RICHMOND 37.786315917969 -122.472625732422 POINT (-122.47262573 37.78631592) Phone   2   6 33 1 11   54   33 33   2   6             1     3   2
3096486 3096486 7439528 2017-07-30T14:44:37 2017-09-29T14:32:00 2017-09-29T14:32:00 2   2 1 5 Sprinkler_system_issues Intersection of GREEN ST and LYON ST GREEN ST 2 Pacific Heights NORTHERN 37.794704455931 -122.446729350584 POINT (-122.44672935 37.79470446) Phone   102 4 6 27 1 13   57   30 30   102   6             1         102
3150383 3150383 8011309 2017-09-12T16:43:00   2017-09-12T19:25:07 1 accepted 2 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
3254839 3254839 8253337 2017-11-10T16:11:00 2017-11-11T10:31:00 2017-11-11T10:31:00 2   2 1 5 Weeding Intersection of BROADWAY and LYON ST BROADWAY 2 Pacific Heights NORTHERN 37.792812347412 -122.446449279785 POINT (-122.44644928 37.79281235) Phone   102 4 6 27 1 13   29,490   30 30   102   6             1         102
3394709 3394709 8929677 2018-04-27T20:18:00 2018-05-07T11:18:00 2018-05-07T11:18:00 2   2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
3578936 3578936 11063346 2019-06-29T14:42:00 2019-08-06T07:02:00 2019-08-06T07:02:00 2 Set up traffic control.Litter pick the medians.Hand weed medians.Prune and hedge trim the shrubs.Remove debris and green waste.Break down traffic control. - The planned maintenance for the Lombard St Medians began on Tuesday, July 16, 2019. Set up traffic control.Litter pick the medians.Hand weed medians.Prune and hedge trim the shrubs.Remove debris and green waste.Break down traffic control. - 2 1 5 Weeding Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
3736839 3736839 11183608 2019-07-26T12:32:00 2019-08-01T13:40:00 2019-08-01T13:40:00 2   2 1 5 Shrubbery_blocking_visibility Intersection of LYON ST and BROADWAY LYON ST 2 Pacific Heights NORTHERN 37.792812347412 -122.446449279785 POINT (-122.44644928 37.79281235) Phone   102 4 6 27 1 13   29,490   30 30   102   6             1         102
14796 14796 11113957 2019-07-11T10:51:00 2019-10-01T11:54:00 2019-10-01T11:54:00 2   2 1 5 Weeding Intersection of FRANCISCO ST and POWELL ST FRANCISCO ST 3 North Beach CENTRAL 37.80489730835 -122.411766052246 POINT (-122.41176605 37.80489731) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3         2   2         106
33327 33327 11612501 2019-10-28T11:54:00 2019-10-28T12:08:30 2019-10-30T11:43:00 2   2 1 1 Damaged_vandalism 1360 TAYLOR ST, SAN FRANCISCO, CA, 94108 TAYLOR ST 3 Nob Hill CENTRAL 37.794998 -122.413122 POINT (-122.413122 37.794998) Mobile/Open311 http://mobile311.sfgov.org/reports/11612501/photos 16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
39250 39250 11626464 2019-10-31T11:19:00   2019-10-31T22:36:08 1 accepted 2 1 1 Damaged_vandalism 210 JOICE ST, SAN FRANCISCO, CA, 94108 JOICE ST 3 Nob Hill CENTRAL 37.793313299999994 -122.4084815 POINT (-122.4084815 37.7933133) Web http://mobile311.sfgov.org/reports/11626464/photos 16 6 3 6 10 3 1 28,857 1 4 4 5 16   3 5     5     2         16
71133 71133 10488270 2019-02-14T09:55:00   2019-03-13T10:15:07 1 in progress 2 1 1 Damaged_vandalism 1106 BUSH ST, SAN FRANCISCO, CA, 94109 BUSH ST 3 Lower Nob Hill CENTRAL 37.789321777141 -122.415700837751 POINT (-122.41570084 37.78932178) Mobile/Open311   50 6 3 21 10 13 1 28,858 1 21 21   50   3             1         50
80639 80639 11589436 2019-10-23T09:10:00   2019-10-23T10:15:43 1 accepted 2 1 5 Weeding 990 GREEN ST, SAN FRANCISCO, CA, 94133 GREEN ST 3 Russian Hill CENTRAL 37.798824310303004 -122.415351867676 POINT (-122.41535187 37.79882431) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
80903 80903 11595953 2019-10-24T12:07:00 2019-10-25T08:29:36 2019-10-25T08:29:36 2   2 1 1 Damaged_vandalism 500 VALLEJO ST, SAN FRANCISCO, CA, 94133 VALLEJO ST 3 North Beach CENTRAL 37.799113833061 -122.40563635161502 POINT (-122.40563635 37.79911383) Mobile/Open311 http://mobile311.sfgov.org/reports/11595953/photos 18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
81251 81251 9363139 2018-08-05T19:11:00 2019-10-01T12:06:00 2019-10-01T12:06:00 2   2 1 1 Damaged_vandalism 432 LOMBARD ST, SAN FRANCISCO, CA, 94133 LOMBARD ST 3 North Beach CENTRAL 37.803666 -122.408817 POINT (-122.408817 37.803666) Web http://mobile311.sfgov.org/reports/9363139/photos 106 6 3 23 10 3 1 308 1 23 23   106   3             1         106
93310 93310 9739273 2018-10-30T07:12:00   2018-11-08T11:05:10 1 in progress 2 1 5 Remove_garden_debris Intersection of JONES ST and PINE ST JONES ST 3 Nob Hill CENTRAL 37.790462493896 -122.413917541504 POINT (-122.41391754 37.79046249) Phone   50 6 3 21 10 5 1 28,858 1 21 21   50   3             1         50
95201 95201 11509805 2019-10-05T15:15:00   2019-10-31T12:55:10 1 accepted 2 1 1 Damaged_vandalism 1230 COLUMBUS AVE, SAN FRANCISCO, CA, 94133 COLUMBUS AVE 3 Fisherman's Wharf CENTRAL 37.805592 -122.417658 POINT (-122.417658 37.805592) Mobile/Open311 http://mobile311.sfgov.org/reports/11509805/photos 99 6 3 23 10 5 1 308 1 23 23   99   3         2   2         99
Powered by Datasette · Query took 31.577ms