calls

Custom SQL query returning 101 rows (hide)

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
8306 8306 7492208 2017-08-11T15:52:58 2017-08-26T11:25:38 2017-08-26T11:25:38 2 trees will be pruned according to block pruning schedule. thanks for your patience. 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
13248 13248 4182619 2014-11-06T10:57:17 2014-11-25T02:58:56 2014-11-25T02:58:56 2 resolved: scheduled for removal 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
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                                                        
13949 13949 11427351 2019-09-17T10:48:00 2019-10-01T08:19:31 2019-10-01T08:19:31 2 There is no immediate safety issue with your tree so it will be serviced in the next few years. The City has taken over responsibility for the care and maintenance of street trees. Through a program called StreetTreeSF, trees that are in the worst condition are being addressed first and every tree will be addressed following a maintenance schedule that is focused on public safety. Thank you for your patience. 1 1 3 Other_enter_additional_details_below 12 CLEMENT ST, SAN FRANCISCO, CA, 94118         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                                                        
19133 19133 5659443 2016-03-12T17:37:50 2016-04-19T20:25:52 2016-04-19T20:25:52 2   1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
19757 19757 5653469 2016-03-10T16:32:58 2016-06-16T10:31:19 2016-06-16T10:31:19 2 called LP for debris sweeper could not get. 1 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
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                                                        
22693 22693 4050214 2014-09-26T10:18:09 2014-09-26T10:47:16 2014-09-26T10:47:16 2 resolved: 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
23132 23132 10920412 2019-05-28T15:22:00 2019-10-24T09:58:14 2019-10-24T09:58:14 2 sent to crews for pruning Notes:pls prune for streetlight clearance :: Closed By CMMS SO 1145841. BUF Action:Prune. date completed - 10/24/2019. Notes:pls prune for street light clearance :: Closed By CMMS SO 1145842. BUF Action:Prune. date completed - 10/24/2019. Notes:pls prune for streetlight clearance :: Closed By CMMS SO 1145841from CMMS: . BUF Action:Prune. date completed - 10/24/2019. Notes:pls prune for street light clearance :: Closed By CMMS SO 1145842from CM 1 1 3 Blocking_street_lights Intersection of SPRUCE ST and PACIFIC AVE SPRUCE ST 2 Presidio Heights RICHMOND 37.790561676025 -122.454246520996 POINT (-122.45424652 37.79056168) Phone     8 6 31 1 11   54   31 31       6             1          
33934 33934 11614333 2019-10-28T16:46:00 2019-10-30T00:00:00 2019-10-30T13:40:06 2 Notes:decay in greater than 50 percent of trunk, cracking wood.. BUF Action:Inspect. date completed - 10/30/2019. 1 1 3 Blocking_sidewalk Intersection of ANZA ST and 19TH AVE ANZA ST 1 Inner Richmond RICHMOND 37.778457641602 -122.478164672852 POINT (-122.47816467 37.77845764) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
35104 35104 11616958 2019-10-29T10:29:00   2019-10-29T14:10:06 1 in progress 1 1 1 Fallen_tree Intersection of HAIGHT ST and DIVISADERO ST HAIGHT ST 5 Buena Vista NORTHERN 37.771266937255994 -122.437042236328 POINT (-122.43704224 37.77126694) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
44280 44280 10797978 2019-04-30T11:47:00   2019-07-19T16:19:41 1 accepted 1 1 2 Sewer_damage_tree_roots 389 GUTTENBERG ST, SAN FRANCISCO, CA, 94112 GUTTENBERG ST 11 Crocker Amazon INGLESIDE 37.708213806152 -122.442016601563 POINT (-122.4420166 37.70821381) Phone                 28,588                                      
46886 46886 11403039 2019-09-11T17:36:00 2019-09-26T06:19:08 2019-09-26T06:19:08 2 Case Resolved Close Note: Hanger removed 16 1 1 Damaged_vandalism Intersection of PERSIA AVE and SUNNYDALE AVE PERSIA AVE 11 Excelsior INGLESIDE 37.718067637234995 -122.42585963486799 POINT (-122.42585963 37.71806764) Mobile/Open311 http://mobile311.sfgov.org/reports/11403039/photos   9 9 19 8 9 4 309 7 18 18       9             2          
54542 54542 11470538 2019-09-26T16:29:00   2019-09-26T16:40:03 1 accepted 1 1 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
59386 59386 11490810 2019-10-01T13:36:00   2019-10-04T09:15:13 1 in progress 2 1 5 Remove_garden_debris Intersection of 30TH AVE and CALIFORNIA ST 30TH AVE 2 Seacliff RICHMOND 37.783641815186 -122.49036407470699 POINT (-122.49036407 37.78364182) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
71941 71941 11609479 2019-10-27T16:31:00 2019-10-28T06:12:40 2019-10-30T10:59:51 2   1 1 1 Fallen_tree Intersection of SANTIAGO ST and 19TH AVE SANTIAGO ST 7 Parkside TARAVAL 37.744918823242 -122.475776672363 POINT (-122.47577667 37.74491882) Phone     10 7 35 3 1 5 29,491 8 35 35       7             1          
81696 81696 11396616 2019-09-10T13:42:00 2019-10-02T00:00:00 2019-10-02T00:00:00 2 Notes:currently you can still see stop sign from a reasonable distance. cannot expedite pruning at this time. it will be pruned in the next couple years during this area's regular scheduled maintenance . BUF Action:Inspect. date completed - 10/2/2019. 1 1 3 Pruning_request Intersection of CALIFORNIA ST and 28TH AVE CALIFORNIA ST 1 Outer Richmond RICHMOND 37.783737182617 -122.48822021484399 POINT (-122.48822021 37.78373718) Phone     8 6 33 1 11 9 55 6 33 33       6             1          
85059 85059 11496296 2019-10-02T15:34:00 2019-10-09T15:58:43 2019-10-09T15:58:43 2 this is ok trees can touch those 1 1 3 Near_communication_line Intersection of VALLEY ST and SAN JOSE AVE VALLEY ST 8 Bernal Heights INGLESIDE 37.744758605956996 -122.42243957519501 POINT (-122.42243958 37.74475861) Phone     9 5 22 5 2 4 28,859 7 22 22       5             1          
87432 87432 9389325 2018-08-11T12:22:00 2019-04-05T16:15:30 2019-04-05T16:15:30 2 contractor recently pruned this block 1 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
88272 88272 8248151 2017-11-09T13:17:00 2017-11-10T07:11:00 2017-11-10T07:11:00 2   1 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
94620 94620 8136795 2017-10-13T11:56:00   2017-12-08T15:10:05 1 accepted 1 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
95641 95641 3812595 2014-07-09T14:44:09 2014-08-14T06:45:00 2014-08-14T06:45:00 2 resolved: Cleared stop sign 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
99893 99893 9506083 2018-09-06T18:25:00 2019-04-09T08:08:56 2019-04-09T08:08:56 2 Unable to Locate. If the problem still exists, please submit a new request with more details regarding the location of the issue. Close Note: 14 1 3 Blocking_signs Intersection of OAK ST and SHRADER ST OAK ST 5 Panhandle PARK 37.771228790283 -122.45223999023399 POINT (-122.45223999 37.77122879) Phone     7 11 3 11 15 8 29,492 5 9 9 22     11 24     25     1          
103981 103981 9146100 2018-06-16T17:14:00 2018-09-23T09:14:45 2018-09-23T09:14:45 2 removed 1 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
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                                                        
104425 104425 870720 2011-04-27T14:41:27 2011-05-06T14:06:02 2011-05-06T14:06:02 2   1 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
105593 105593 8606292 2018-02-07T17:34:00   2018-02-07T17:40:06 1 accepted 1 1 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
105852 105852 1048689 2012-01-22T12:03:52 2012-01-25T15:07:02 2012-01-25T15:07:02 2   1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
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                                                        
106929 106929 2990196 2013-10-26T11:58:57 2013-10-26T13:16:52 2013-10-26T13:16:52 2 resolved: 1 1 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
108325 108325 2068657 2013-02-28T07:01:30 2013-04-05T12:47:14 2013-04-05T12:47:14 2 cancelled: 24 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
109427 109427 980260 2011-10-10T09:10:49 2013-11-01T13:19:38 2013-11-01T13:19:38 2 resolved: 1 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
111644 111644 3891095 2014-08-05T17:36:27 2014-08-14T05:35:42 2014-08-14T05:35:42 2 resolved: Completed 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
111647 111647 3890718 2014-08-05T15:11:41 2014-08-05T03:52:00 2014-08-05T03:52:00 2 resolved: 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
111666 111666 3887728 2014-08-04T16:47:42 2014-08-18T01:43:34 2014-08-18T01:43:34 2 resolved: 10-98 1 1 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
111989 111989 7251820 2017-06-12T13:40:47 2017-10-10T01:49:00 2017-10-10T01:49:00 2 Weeded D1 CCT 2 1 5 Weeding Intersection of GEARY BLVD and ARGUELLO BLVD GEARY BLVD 1 Lone Mountain RICHMOND 37.781255092519004 -122.458860615756 POINT (-122.45886062 37.78125509) Phone     8 4 11 2 11 9 54 6 11 11       4             1          
112956 112956 3643894 2014-05-14T23:22:55 2014-05-20T03:11:39 2014-05-20T03:11:39 2 resolved: all private not dpw maintained 1 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
113808 113808 3482589 2014-03-23T18:51:32 2014-04-27T07:52:12 2014-04-27T07:52:12 2 resolved: 1 1 3 Blocking_street_lights Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
114376 114376 3363375 2014-02-13T08:22:58 2014-03-07T09:52:20 2014-03-07T09:52:20 2 resolved: 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
115148 115148 6920846 2017-03-09T15:09:18 2017-03-17T13:20:10 2017-03-17T13:20:10 2 Could you please provide some more detailed information? I have looked at all the trees on all four corners and cannot see any of them that would be damaging a property. A photo or specific address would be great. JG 1 1 2 Property_damage Intersection of HAIGHT ST and DIVISADERO ST HAIGHT ST 5 Buena Vista NORTHERN 37.771265128723 -122.437044992878 POINT (-122.43704499 37.77126513) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
116242 116242 6814183 2017-02-07T06:44:01 2017-02-10T08:45:26 2017-02-10T08:45:26 2   1 1 1 Fallen_tree Intersection of VAN NESS AVE and FRANCISCO ST VAN NESS AVE 2 Marina NORTHERN 37.803204327417 -122.424920016464 POINT (-122.42492002 37.80320433) Phone     4 6 32 1 5 6 28,858 9 32 32       6             1          
119268 119268 5103070 2015-09-16T13:05:01 2015-09-17T04:05:41 2015-09-17T04:05:41 2 resolved: duplicate 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
122551 122551 4628547 2015-04-01T17:52:53 2015-06-29T09:09:51 2015-06-29T09:09:51 2 cancelled: 1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
124672 124672 6137203 2016-07-30T07:34:48 2016-08-01T08:25:24 2016-08-01T08:25:24 2   1 1 1 Fallen_tree Intersection of 19TH AVE and GEARY BLVD 19TH AVE 1 Inner Richmond RICHMOND 37.780381015931 -122.478305503337 POINT (-122.4783055 37.78038102) Phone     8 4 29 2 11 9 55 6 26 26       4             1          
125886 125886 6018676 2016-06-25T13:58:20 2016-08-22T23:22:19 2016-08-22T23:22:19 2 Request Letter Sent. 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
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                                                        
128084 128084 5790504 2016-04-22T14:32:41 2016-09-10T13:55:10 2016-09-10T13:55:10 2   2 1 5 Weeding Intersection of DIVISADERO ST and HAIGHT ST DIVISADERO ST 5 Buena Vista NORTHERN 37.771265128723 -122.437044992878 POINT (-122.43704499 37.77126513) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
128147 128147 5785216 2016-04-21T09:07:02 2016-08-22T23:11:40 2016-08-22T23:11:40 2 can we have the address? not city maintained 1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
129536 129536 6016927 2016-06-24T18:30:35 2016-08-22T23:22:52 2016-08-22T23:22:52 2 Request Letter Sent. 1 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
129626 129626 5575749 2016-02-17T10:35:21 2016-02-17T11:52:51 2016-02-17T11:52:51 2 Case Resolved: sent via direct data base 1 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
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                                                        
131885 131885 4937178 2015-07-24T14:31:55 2016-06-13T12:41:52 2016-06-13T12:41:52 2 no bin visable during inspection on Monday 1 1 2 Sewer_damage_tree_roots 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                                                        
132256 132256 5727269 2016-04-04T09:39:15   2016-04-04T09:39:15 1 open 1 1 3 Other_enter_additional_details_below 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                                                        
132263 132263 3467115 2014-03-18T16:14:40 2016-06-13T12:00:00 2016-06-13T12:00:00 2 cleaned 1 1 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
132333 132333 1561636 2012-10-16T15:51:41 2016-09-27T10:23:27 2016-09-27T10:23:27 2   1 1 5 Sprinkler_system_issues Intersection of DIVISADERO ST and HAIGHT ST DIVISADERO ST 5 Buena Vista NORTHERN 37.771266937255994 -122.437042236328 POINT (-122.43704224 37.77126694) Phone     4 11 3 11 15 8 29,492 5 9 9       11             1          
132519 132519 922607 2011-07-18T13:44:07 2016-10-07T01:13:52 2016-10-07T01:13:52 2 OVER GROWN VEGETATION, near pole. - posted, took photos;NTR # 961782, 3 1 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
133277 133277 5389897 2015-12-20T07:53:12 2015-12-22T11:58:47 2015-12-22T11:58:47 2 resolved: Request Letter Sent. 1 1 1 Damaged_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
134787 134787 5218893 2015-10-23T15:19:06 2015-10-27T12:35:14 2015-10-27T12:35:14 2 resolved: ??? no falling tree here 1 1 3 Other_enter_additional_details_below 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                                                        
136695 136695 5034395 2015-08-25T20:03:06 2015-08-28T08:33:05 2015-08-28T08:33:05 2 resolved: no acurpucturist at Valencia and Duboce. Need exact address. 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
136751 136751 5027821 2015-08-24T08:22:53 2015-08-24T09:13:56 2015-08-24T09:13:56 2 resolved: 1 1 1 Fallen_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
136974 136974 5006089 2015-08-17T11:26:36 2015-08-21T02:12:06 2015-08-21T02:12:06 2 resolved: I emailed the caller. This is a private tree in a backyard. I gave her several ideas on how to deal with the issue 1 1 3 Other_enter_additional_details_below 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                                                        
137467 137467 4958122 2015-07-31T19:09:48 2015-08-20T08:29:51 2015-08-20T08:29:51 2 resolved: problem not found. there is a damaged branch/stub left on tree 3 ifo 444 wash. 1 1 1 Damaged_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
137752 137752 4932231 2015-07-22T20:38:06 2015-08-04T01:55:29 2015-08-04T01:55:29 2 cancelled: 1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
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                                                        
143480 143480 4466410 2015-02-06T13:30:25 2015-02-09T09:53:26 2015-02-09T09:53:26 2 resolved: Completed, Niu 1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Integrated Agency                                                        
143606 143606 8947708 2018-05-02T10:34:00   2018-10-23T11:18:15 1 accepted 1 1 1 About_to_fall Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
144257 144257 4406708 2015-01-19T11:23:54   2015-01-19T11:23:54 1 accepted 1 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
145034 145034 4311252 2014-12-17T10:58:33 2015-05-15T03:21:18 2015-05-15T03:21:18 2 resolved: 1 1 4 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
146534 146534 3571454 2014-04-21T07:46:51 2014-04-23T09:16:33 2014-04-23T09:16:33 2 resolved: 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
146598 146598 3540612 2014-04-11T08:47:13 2014-05-28T11:03:43 2014-05-28T11:03:43 2 resolved: need specific address 1 1 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
146642 146642 3522950 2014-04-05T14:38:17 2014-04-06T07:20:43 2014-04-06T07:20:43 2 resolved: 1 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
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                                                        
147575 147575 3268801 2014-01-14T08:11:59 2014-01-14T10:17:53 2014-01-14T10:17:53 2 resolved: 1 1 2 Lifted_sidewalk_tree_roots 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                                                        
147846 147846 2783366 2013-09-03T11:58:29 2014-04-10T13:21:04 2014-04-10T13:21:04 2 resolved: 1 1 3 Pruning_request Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
147870 147870 2695859 2013-08-09T11:24:28 2014-02-09T05:12:19 2014-02-09T05:12:19 2 resolved: Found 500 square feet of damaged/uneven sidewalk. - NTR # 993818, 3 1 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
147908 147908 2148862 2013-03-20T10:40:41 2014-10-10T11:22:27 2014-10-10T11:22:27 2 resolved: No issues found. the sidewalk was accessible at this block 1 1 5 Shrubbery_blocking_visibility Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
148087 148087 1116701 2012-05-02T15:21:01 2014-03-07T03:33:08 2014-03-07T03:33:08 2 resolved: 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
148129 148129 1012357 2011-11-28T16:19:15 2014-07-30T02:31:30 2014-07-30T02:31:30 2 resolved: tree has been replaced. 1 1 1 Damage_vandalism Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
148130 148130 961430 2011-09-13T12:26:23 2014-05-20T01:32:26 2014-05-20T01:32:26 2 resolved: 1 1 3 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
148137 148137 864155 2011-04-17T18:47:31 2014-07-31T09:55:08 2014-07-31T09:55:08 2 resolved: tree has been replaced. 1 1 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
149475 149475 3063023 2013-11-14T10:11:11 2013-12-07T15:19:40 2013-12-07T15:19:40 2 resolved: 1 1 5 Sprinkler_system_issues Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
149678 149678 2985448 2013-10-25T08:45:49 2013-10-31T11:24:28 2013-10-31T11:24:28 2 resolved: 1 1 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
150253 150253 2805790 2013-09-09T11:21:23 2013-11-13T12:20:18 2013-11-13T12:20:18 2 resolved: 1 1 3 Near_communication_line Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
150635 150635 2644890 2013-07-26T12:45:19 2013-07-26T15:03:33 2013-07-26T15:03:33 2 resolved: 1 1 2 Property_damage Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
150949 150949 2458907 2013-06-06T15:06:27 2013-10-03T16:18:32 2013-10-03T16:18:32 2 resolved: 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
151191 151191 2279984 2013-04-23T15:19:36 2013-09-23T09:18:57 2013-09-23T09:18:57 2 resolved: 1 1 1 Dead_tree Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
151358 151358 9067072 2018-05-29T21:21:00 2018-05-29T21:39:43 2018-05-29T21:39:43 2 tree removed 1 1 1 Fallen_tree Intersection of GREEN ST and STEINER ST GREEN ST 2 Cow Hollow NORTHERN 37.795948028564 -122.43695068359399 POINT (-122.43695068 37.79594803) Phone     4 6 30 1 13 6 57 9 27 27       6             1          
151895 151895 1765166 2012-12-07T09:27:21 2012-12-11T09:24:37 2012-12-11T09:24:37 2 resolved: 1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
151911 151911 1739287 2012-11-30T07:22:47 2012-11-30T15:17:11 2012-11-30T15:17:11 2 resolved: 1 1 1 Fallen_tree 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                                                        
155013 155013 1031899 2011-12-29T09:59:55 2012-01-25T18:12:01 2012-01-25T18:12:01 2   1 1 5 Other Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
156548 156548 846507 2011-03-21T11:03:36 2012-04-20T18:27:21 2012-04-20T18:27:21 2   1 1 3 Blocking_traffic_signal Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
161325 161325 1014851 2011-12-01T17:14:05 2011-12-05T06:07:14 2011-12-05T06:07:14 2   1 1 1 Hanging_limb Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
161434 161434 985153 2011-10-17T11:44:19 2011-12-12T11:07:02 2011-12-12T11:07:02 2   1 1 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Web                                                        
Powered by Datasette · Query took 52.326ms