calls

69 rows where Responsible_Agency = 34

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
660601 660601 244397 2008-07-08T16:46:07 2008-08-05T14:53:52 2008-08-05T14:53:52 Closed 2 Case Resolved limb removed 8/1/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Washington Square, SAN FRANCISCO, CA, 94133 Washington Square 3 North Beach CENTRAL 37.800838470459 -122.41002655029301 POINT (-122.41002655 37.80083847) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23 20   23     2         106
661315 661315 249445 2008-07-17T14:34:19 2008-09-03T13:38:51 2008-09-03T13:38:51 Closed 2 Case Resolved trees trimmed RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Jefferson Square, SAN FRANCISCO, CA, 94102 Jefferson Square 6 Cathedral Hill NORTHERN 37.781799316406 -122.425659179688 POINT (-122.42565918 37.78179932) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
666620 666620 275429 2008-09-03T16:55:17 2008-09-08T09:41:00 2008-09-08T09:41:00 Closed 2 Work plan in process. Work party scheduled on September 20th, from 10 am - 1 pm, 18+ people. Focus will be pulling weeds. Recently replaced several broken sprinkelers (they were damaged by dogs biting them). They were broken just before the heat wave, so the grass turned brown in a very short time. It should be turning green soon, with water and some overseeding / fertilizing. This park's part-time gardener is on modified duty due to knee surgery and the mobile crew tends this garden in addition to their other parks. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Weeding Patricia's Green in Hayes Valley, SAN FRANCISCO, CA, 94102 Patricia's Green in Hayes Valley 5 Hayes Valley NORTHERN 37.776222229004 -122.424415588379 POINT (-122.42441559 37.77622223) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
667052 667052 297131 2008-10-14T10:12:29 2008-11-12T14:25:04 2008-11-12T14:25:04 Closed 2 Talked with homeowner, explained to her that we were out there about a year ago, and said that we believe the trees are on private property. Also suggested she could have her boundries surveyed. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 15th Avenue Steps, SAN FRANCISCO, CA, 94122 15th Avenue Steps 7 Golden Gate Heights TARAVAL 37.759563446045 -122.472267150879 POINT (-122.47226715 37.75956345) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
667564 667564 256115 2008-07-29T14:25:35 2008-07-30T09:29:53 2008-07-30T09:29:53 Closed 2 Case Resolved Tarea on top of Kite Hill has been mowed for the year already. This is the core of the recreational use area. The slope toward Seward does not require mowing. Mowing the slope will make it prone to erosion. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Kite Hill, SAN FRANCISCO, CA, 94114 Kite Hill 8 Eureka Valley MISSION 37.758239746094 -122.44165802001999 POINT (-122.44165802 37.75823975) Phone   115 3 5 38 5 2 7 28,862 4 38 38   115   5             1         115
667703 667703 255786 2008-07-29T07:52:17 2008-07-30T16:01:58 2008-07-30T16:01:58 Closed 2 Case Resolved Natural Areas will address this large project with a combination of volunteers (hand cutting) and staff (spray). Spary will be environmental and posted. We don't currently have a volunteer group for this project and it may take some time to find one. We project that the project will get done this fall. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Glen Canyon Park , SAN FRANCISCO, CA, 94131 Glen Canyon Park 8 Glen Park INGLESIDE 37.74002456665 -122.442733764648 POINT (-122.44273376 37.74002457) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
671376 671376 270733 2008-08-25T19:02:48 2008-08-28T16:10:07 2008-08-28T16:10:07 Closed 2 Case Resolved Head has been repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Sigmund Stern Recreation Grove, SAN FRANCISCO, CA, 94132 Sigmund Stern Recreation Grove 4 Parkside TARAVAL 37.736083984375 -122.47829437255899 POINT (-122.47829437 37.73608398) Phone   40 10 7 35 3 1 5 64 8 35 35   40   7             1         40
675422 675422 241636 2008-07-02T21:21:40 2008-07-07T06:42:45 2008-07-07T06:42:45 Closed 2 Case Resolved Limb removed 7/3/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 30 CRESTLINE DR, SAN FRANCISCO, CA, 94131 CRESTLINE DR 8 Upper Market PARK 37.750099182129 -122.44619750976601 POINT (-122.44619751 37.75009918) Phone   51 7 5 38 5 2 8 63 5 38 38   51   5             1         51
676438 676438 265297 2008-08-15T13:04:21 2008-09-10T10:33:10 2008-09-10T10:33:10 Closed 2 personnel matter Park Sup is following up regarding site staff. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of JACKSON ST and STEINER ST JACKSON ST 2 Pacific Heights NORTHERN 37.792263031005994 -122.43620300293001 POINT (-122.436203 37.79226303) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
677630 677630 246559 2008-07-12T11:48:48 2008-07-15T10:22:14 2008-07-15T10:22:14 Closed 2 Repair is dangerous The contractor/designer for the park has been called in to do a repair. Water is entering the electrical controller for the sprinklet system at this park and creating puddles that could be connected to electrical current. Hence, on site staff is unable to effect the reparid due to potential hazard to them and the area building is now off limits until repair is done. Negotiating a time when contractor can complete. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Potrero del Sol, SAN FRANCISCO, CA, 94110 Potrero del Sol 10 Potrero Hill MISSION 37.750606536865 -122.405082702637 POINT (-122.4050827 37.75060654) Phone   54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
678818 678818 247053 2008-07-14T07:06:27 2008-07-14T12:01:41 2008-07-14T12:01:41 Closed 2 Case Resolved Tree removed 7/14/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Ferry Park, SAN FRANCISCO, CA, 94111 Ferry Park 3 Financial District CENTRAL 37.795925140380994 -122.39650726318399 POINT (-122.39650726 37.79592514) Phone   108 6 3 8 10 3 1 28,860 1 6 6   108   3     4       1   4     108
680358 680358 256085 2008-07-29T13:34:41 2008-08-04T09:59:09 2008-08-04T09:59:09 Closed 2 This type of tree maintenance is part of long-term projects and will be completed according to those schedules. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of FUNSTON AVE and LINCOLN WAY FUNSTON AVE 5 Golden Gate Park TARAVAL 37.765739440918004 -122.47072601318399 POINT (-122.47072601 37.76573944) Phone   9 10 11 14 11 11 5 56 8 12 12   9   11             1         9
680939 680939 272418 2008-08-28T15:03:18 2008-08-29T12:05:08 2008-08-29T12:05:08 Closed 2 Case Resolved hanging limb removed 8/29/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Glen Canyon Park , SAN FRANCISCO, CA, 94131 Glen Canyon Park 8 Glen Park INGLESIDE 37.74002456665 -122.442733764648 POINT (-122.44273376 37.74002457) Phone   96 9 5 10 5 2 4 63 7 7 7   96   5             1         96
682073 682073 248402 2008-07-16T08:21:27 2008-07-16T08:30:29 2008-07-16T08:30:29 Closed 2 Case is Invalid This is a street tree in front of a home. not Rec&Park Property. RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 120 QUINTARA ST, SAN FRANCISCO, CA, 94116 QUINTARA ST 7 Golden Gate Heights TARAVAL 37.749179840088 -122.46678924560499 POINT (-122.46678925 37.74917984) Phone   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
683018 683018 260755 2008-08-06T15:08:55 2008-08-11T12:23:09 2008-08-11T12:23:09 Closed 2 Case Resolved Sprinkler adjusted. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 3851 20TH ST, SAN FRANCISCO, CA, 94114 20TH ST 8 Dolores Heights MISSION 37.758045196533 -122.42683410644501 POINT (-122.42683411 37.7580452) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1         52
686269 686269 259966 2008-08-05T12:57:29 2008-08-07T09:37:57 2008-08-07T09:37:57 Closed 2 Case Resolved Staff has called and will meet with caller today to determine what needs to be done. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Shrubbery_blocking_visibility 1932 GREAT HWY, SAN FRANCISCO, CA, 94116 GREAT HWY 4 Outer Sunset TARAVAL 37.75032043457 -122.50794219970699 POINT (-122.5079422 37.75032043) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
687639 687639 259249 2008-08-04T11:40:12 2008-08-04T14:09:59 2008-08-04T14:09:59 Closed 2 Case Transferred Case closed / went to R&P redirected to DPW see SR259359 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of KIRKHAM ST and SUNSET BLVD KIRKHAM ST 4 Outer Sunset TARAVAL 37.759002685546996 -122.495620727539 POINT (-122.49562073 37.75900269) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
688848 688848 267122 2008-08-19T12:22:55 2008-09-03T13:45:17 2008-09-03T13:45:17 Closed 2 Case Resolved double, trees already done RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building Juri Commons, SAN FRANCISCO, CA, 94110 Juri Commons 9 Mission MISSION 37.749504089355 -122.42198944091801 POINT (-122.42198944 37.74950409) Phone   53 3 5 20 5 2 7 28,859 4 19 19   53   5             1         53
691753 691753 255967 2008-07-29T11:12:43 2008-08-04T07:54:29 2008-08-04T07:54:29 Closed 2 Case Resolved limb removed RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Allyne Park, 2609 GOUGH ST, SAN FRANCISCO, CA, 94123 GOUGH ST 2 Union Street NORTHERN 37.797462463379 -122.427597045898 POINT (-122.42759705 37.79746246) Phone   15 4 6 13 1 13 6 57 9 17 17   15   6             1         15
694928 694928 288141 2008-09-26T13:39:24 2009-03-12T07:19:43 2009-03-12T07:19:43 Closed 2 tree raised up to clear for bus passage. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 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
695764 695764 247944 2008-07-15T12:23:43 2008-07-23T11:05:22 2008-07-23T11:05:22 Closed 2 Case Resolved Repair made. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of MCALLISTER ST and POLK ST MCALLISTER ST 6 Civic Center NORTHERN 37.780261993408 -122.418601989746 POINT (-122.41860199 37.78026199) Phone   21 4 10 36 9 7 6 28,852 9 36 36   21 1 10     1   8 1 2 1 1     21
696210 696210 296041 2008-10-11T10:32:21 2008-10-29T08:48:29 2008-10-29T08:48:29 Closed 2 Tree was pruned away from house 10/28/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1461 BROADWAY, SAN FRANCISCO, CA, 94109 BROADWAY 3 Polk Gulch NORTHERN 37.795860290527 -122.42131042480499 POINT (-122.42131042 37.79586029) Phone   105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
697141 697141 260494 2008-08-06T09:52:47 2008-08-06T16:29:08 2008-08-06T16:29:08 Closed 2 Case Resolved NSA mgr met with Ms. Beckstead today and explained that the tree has been pruned to the extent possible with regular gardening staff and that 6000 lady bugs have been released in the vicinity for pest control. Although the tree appears to not have such an infestation as described by the caller. Tree toppers have greater priority pruning of trees in other parks. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 47 PIERCE ST, SAN FRANCISCO, CA, 94117 PIERCE ST 8 Duboce Triangle PARK 37.769847869873 -122.43350219726601 POINT (-122.4335022 37.76984787) Phone   28 7 5 3 5 15 8 29,492 5 9 9   28   5             1         28
699156 699156 288964 2008-09-28T19:43:34 2008-09-30T16:20:46 2008-09-30T16:20:46 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1572 GENEVA AVE, SAN FRANCISCO, CA, 94112 GENEVA AVE 11 Crocker Amazon INGLESIDE 37.712299346924 -122.43048095703101 POINT (-122.43048096 37.71229935) Phone   58 9 1 7 6 9 4 28,861 7 5 5   58   1             2         58
700088 700088 257512 2008-07-31T15:35:30 2009-06-08T12:08:13 2009-06-08T12:08:13 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 678 CAMPBELL AVE, SAN FRANCISCO, CA, 94134 CAMPBELL AVE 10 Visitacion Valley INGLESIDE 37.716468811035 -122.410255432129 POINT (-122.41025543 37.71646881) Phone   75 9 9 40 8 9 4 309 7 39 39   75   9             2         75
706196 706196 240986 2008-07-02T00:31:40 2008-07-17T14:06:29 2008-07-17T14:06:29 Closed 2 Case Resolved Repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues GGP Panhandle, SAN FRANCISCO, CA, 94117 GGP Panhandle 5 Panhandle PARK 37.772205352783 -122.448699951172 POINT (-122.44869995 37.77220535) Phone   24 7 11 12 11 15 8 29,492 5 8 8   24   11             1         24
707190 707190 257375 2008-07-31T12:49:31 2008-08-01T16:00:17 2008-08-01T16:00:17 Closed 2 Case Resolved Sprinklers adjusted as much as possible. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 300 PRECITA AVE, SAN FRANCISCO, CA, 94110 PRECITA AVE 9 Bernal Heights INGLESIDE 37.746677398681996 -122.413314819336 POINT (-122.41331482 37.7466774) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
709504 709504 268070 2008-08-20T20:37:21 2008-08-21T18:30:30 2008-08-21T18:30:30 Closed 2 Case Resolved Leak repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 19TH AVE and SLOAT BLVD 19TH AVE 7 Parkside TARAVAL 37.73462677002 -122.47510528564501 POINT (-122.47510529 37.73462677) Phone   40 10 8 35 4 1 5 64 8 35 35   40   8             1         40
710527 710527 247365 2008-07-14T12:51:56 2008-07-14T13:30:26 2008-07-14T13:30:26 Closed 2 Case is a Duplicate Dup of 245368 RecPark Work Queue 34 Tree Maintenance 1 Trees - Tree_Other 4 Other Cayuga Playground, 301 NAGLEE AVE, SAN FRANCISCO, CA, 94112 NAGLEE AVE 11 Outer Mission INGLESIDE 37.713886260986 -122.450294494629 POINT (-122.45029449 37.71388626) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
711009 711009 248345 2008-07-16T06:23:29 2008-07-16T16:38:54 2008-07-16T16:38:54 Closed 2 Case is Invalid Will double check irrigation as part of the effort to reduce water use City-wide. However, this is a rare complaint, as after renovations, most regular users have nothing but praise for this park. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Duboce Park, SAN FRANCISCO, CA, 94117 Duboce Park 8 Duboce Triangle PARK 37.76961517334 -122.43342590331999 POINT (-122.4334259 37.76961517) Phone   28 7 5 3 5 15 8 29,492 5 9 9   28   5       20     1         28
715034 715034 265876 2008-08-16T19:42:30 2008-08-19T10:06:42 2008-08-19T10:06:42 Closed 2 Case Resolved Sprinkler adjusted. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CLAYTON ST and OAK ST CLAYTON ST 5 Panhandle PARK 37.771667480469 -122.448959350586 POINT (-122.44895935 37.77166748) Phone   24 7 11 3 11 15 8 29,492 5 9 9 22 24   11 24     25     1         24
718286 718286 253154 2008-07-23T20:53:52 2008-09-03T11:40:45 2008-09-03T11:40:45 Closed 2 Case Resolved Work order shows completed 8/5/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Tree_Other 4 Other Alta Plaza Park, SAN FRANCISCO, CA, 94115 Alta Plaza Park 2 Pacific Heights NORTHERN 37.791172027588 -122.43766784668001 POINT (-122.43766785 37.79117203) Phone   102 4 6 30 1 13 9 29,490 6 27 27   102   6             1         102
722320 722320 278055 2008-09-08T13:21:08 2008-09-10T10:32:21 2008-09-10T10:32:21 Closed 2 Case Resolved Sprinklers have been adjusted/repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Noe Valley Courts, SAN FRANCISCO, CA, 94114 Noe Valley Courts 8 Upper Market MISSION 37.751403808594 -122.438919067383 POINT (-122.43891907 37.75140381) Phone   51 3 5 22 5 2 7 28,862 4 22 22   51   5         12   1         51
727208 727208 246922 2008-07-13T16:15:43 2008-08-01T15:55:51 2008-08-01T15:55:51 Closed 2 Case Transferred Case is now a work order in the plumbing shop. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of FOLSOM ST and PRECITA AVE FOLSOM ST 9 Bernal Heights INGLESIDE 37.747169494629 -122.41357421875 POINT (-122.41357422 37.74716949) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
727586 727586 261816 2008-08-08T10:59:40 2008-08-08T11:44:12 2008-08-08T11:44:12 Closed 2 DPW trees This has been sent to wrong location. Sunset Blvd. is not RPD property it is DPW's RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 37TH AVE and KIRKHAM ST 37TH AVE 4 Outer Sunset TARAVAL 37.758979797363 -122.49615478515601 POINT (-122.49615479 37.7589798) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
728684 728684 250791 2008-07-19T19:02:52 2008-08-12T15:18:06 2008-08-12T15:18:06 Closed 2 unauthorized watering Some member of the public has somehow gained access to sprinkler system. Site staff will try to witness this access and instruct perpetrator to stop. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 14TH ST and ROOSEVELT WAY 14TH ST 8 Corona Heights PARK 37.767223358154 -122.437301635742 POINT (-122.43730164 37.76722336) Phone   112 7 5 5 5 15 8 28,862 5 3 3   112   5             1         112
728745 728745 279057 2008-09-10T08:53:26 2008-09-12T11:35:38 2008-09-12T11:35:38 Closed 2 Case Resolved Sprinkler repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CLEMENT ST and PARK PRESIDIO BLVD CLEMENT ST 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
734325 734325 259971 2008-08-05T13:05:23 2008-08-11T12:23:49 2008-08-11T12:23:49 Closed 2 Case Resolved Sprinklers are repaired. In order to identify issue, that had to run while being repaired. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Precita Park, 3200 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.747062683105 -122.41202545166 POINT (-122.41202545 37.74706268) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
736178 736178 245687 2008-07-10T17:09:58 2008-07-14T13:05:41 2008-07-14T13:05:41 Closed 2 Case is a Duplicate Dup of 244455 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Muriel Leff Mini Park, SAN FRANCISCO, CA, 94118 Muriel Leff Mini Park 1 Inner Richmond RICHMOND 37.78006362915 -122.46501159668001 POINT (-122.4650116 37.78006363) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1       2 5
739645 739645 254664 2008-07-26T18:32:13 2008-08-01T15:58:28 2008-08-01T15:58:28 Closed 2 Case Resolved Sprinklers adjusted. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 20TH ST and CHURCH ST 20TH ST 8 Dolores Heights MISSION 37.758087158203004 -122.428047180176 POINT (-122.42804718 37.75808716) Phone   52 3 5 5 5 2 7 28,862 4 3 3   52   5             1   5     52
741904 741904 258454 2008-08-02T09:55:05 2008-08-19T14:26:04 2008-08-19T14:26:04 Closed 2 Case Resolved Area currently being renovated. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Aptos Playground, SAN FRANCISCO, CA, 94127 Aptos Playground 7 Balboa Terrace TARAVAL 37.728523254395 -122.466537475586 POINT (-122.46653748 37.72852325) Phone   63 10 8 41 4 9 5 59 8 40 40   63   8             1         63
744273 744273 246822 2008-07-13T09:52:44 2008-07-14T14:52:04 2008-07-14T14:52:04 Closed 2 Case is a Duplicate Dup of 246922 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Precita Park, 3200 FOLSOM ST, SAN FRANCISCO, CA, 94110 FOLSOM ST 9 Bernal Heights INGLESIDE 37.747062683105 -122.41202545166 POINT (-122.41202545 37.74706268) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2     3       1   3     83
746349 746349 287961 2008-09-26T09:26:43 2009-08-24T16:29:20 2009-08-24T16:29:20 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Mt. Davidson Park, SAN FRANCISCO, CA, 94127 Mt. Davidson Park 7 Sherwood Forest INGLESIDE 37.739063262939 -122.454658508301 POINT (-122.45465851 37.73906326) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
749401 749401 309319 2008-11-05T11:30:00 2008-11-05T12:41:19 2008-11-05T12:41:19 Closed 2 hazard was cleared off road early this morning. 11/5/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CROSSOVER DR and MARTIN LUTHER KING JR DR CROSSOVER DR 5 Golden Gate Park RICHMOND 37.766063690186 -122.477363586426 POINT (-122.47736359 37.76606369) Phone   9 8 4 12 2 11 9 29,492 6 8 8   9   4             1         9
750630 750630 241665 2008-07-03T05:36:43 2008-07-11T06:48:09 2008-07-11T06:48:09 Closed 2 Case Resolved Hanging limb removed RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of GEARY BLVD and PARK PRESIDIO BLVD GEARY 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
755850 755850 318756 2008-11-22T12:55:58 2008-12-09T16:34:40 2008-12-09T16:34:40 Closed 2 same as case #318752 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Park Presidio Blvd, SAN FRANCISCO, CA, 94118 Park Presidio Blvd 1 Inner Richmond RICHMOND 37.780120849609 -122.47228240966801 POINT (-122.47228241 37.78012085) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
757762 757762 258309 2008-08-01T19:32:05 2008-08-06T16:26:08 2008-08-06T16:26:08 Closed 2 Case Resolved Site staff contacted Mr. Madden and explained that the irrigation system is 60 years old, that only 19% of it is automatic or adjustable, that water pressure varies throughout this park and that the park will be renovated as part of the new capital program. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 18TH ST and DOLORES ST 18TH ST 8 Mission Dolores MISSION 37.761428833008 -122.426078796387 POINT (-122.4260788 37.76142883) Phone   37 3 5 5 5 8 7 28,862 4 3 3   37   5             1   5     37
758721 758721 272639 2008-08-28T21:58:59 2008-09-03T13:38:31 2008-09-03T13:38:31 Closed 2 Case Resolved nothing found RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of ANZA ST and ARGUELLO BLVD ANZA ST 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
764215 764215 275881 2008-09-04T12:21:22 2008-09-04T15:26:29 2008-09-04T15:26:29 Closed 2 RPD maintains for horticultural requirements not for view. Chain link fence is aesthetically more pleasing with ivy. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Other 25 EDWARD ST, SAN FRANCISCO, CA, 94118 EDWARD ST 1 Lone Mountain RICHMOND 37.778045654296996 -122.457534790039 POINT (-122.45753479 37.77804565) Phone   12 8 4 18 2 11 9 54 6 16 16   12   4             1         12
764902 764902 264715 2008-08-14T11:10:51 2008-09-04T15:13:37 2008-09-04T15:13:37 Closed 2 Case Resolved Weeds removed. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LA SALLE AVE and NEWCOMB AVE LA SALLE AVE 10 Bayview BAYVIEW 37.733070373535 -122.38500213623001 POINT (-122.38500214 37.73307037) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
764992 764992 274419 2008-09-02T11:13:46 2008-09-04T07:44:43 2008-09-04T07:44:43 Closed 2 Case Resolved branches removed fron signs RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of MARTIN LUTHER KING JR DR and STOW LAKE DR MARTIN LUTHER KING JR DR 5 Golden Gate Park RICHMOND 37.767055511475 -122.473281860352 POINT (-122.47328186 37.76705551) Phone   9 8 11 12 11 11 9 29,492 6 8 8   9   11             1         9
771092 771092 246615 2008-07-12T14:04:17 2008-07-14T14:28:25 2008-07-14T14:28:25 Closed 2 Case is a Duplicate Dup of 246559 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Potrero del Sol, SAN FRANCISCO, CA, 94110 Potrero del Sol 10 Potrero Hill MISSION 37.750606536865 -122.405082702637 POINT (-122.4050827 37.75060654) Phone   54 3 9 20 8 10 7 28,859 4 19 19 23 54   9 10     10     1         54
771631 771631 247107 2008-07-14T08:50:00 2008-07-15T10:09:17 2008-07-15T10:09:17 Closed 2 Case Resolved The sprinklers are being tested for repairs and the problem should be repaired immediately. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Helen Wills Playground, SAN FRANCISCO, CA, 94109 Helen Wills Playground 3 Polk Gulch NORTHERN 37.79577255249 -122.42066192626999 POINT (-122.42066193 37.79577255) Phone   105 4 3 32 10 13 6 28,858 9 32 32   105   3             1         105
771974 771974 282356 2008-09-16T09:35:10 2009-04-14T11:57:06 2009-04-14T11:57:06 Closed 2 branches trimmed away from wire RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Seward Mini Park, SAN FRANCISCO, CA, 94114 Seward Mini Park 8 Eureka Valley MISSION 37.757610321045 -122.440063476563 POINT (-122.44006348 37.75761032) Phone   115 3 5 38 5 2 7 28,862 4 38 38   115   5             1         115
777173 777173 268345 2008-08-21T12:12:23 2008-08-29T12:04:27 2008-08-29T12:04:27 Closed 2 Case Resolved Tree work done 8/28/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb George Christopher Playground, 5210 DIAMOND HEIGHTS BLVD, SAN FRANCISCO, CA, 94131 DIAMOND HEIGHTS BLVD 8 Diamond Heights INGLESIDE 37.743469238281 -122.440551757813 POINT (-122.44055176 37.74346924) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
777318 777318 270638 2008-08-25T16:37:46 2008-08-26T09:34:33 2008-08-26T09:34:33 Closed 2 Case Resolved Work order submitted to repair sprinkler head. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1003 TURK ST, SAN FRANCISCO, CA, 94102 TURK ST 5 Cathedral Hill NORTHERN 37.781204223633 -122.425605773926 POINT (-122.42560577 37.78120422) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100   11             2         100
777706 777706 278722 2008-09-09T14:45:51 2008-09-15T14:57:56 2008-09-15T14:57:56 Closed 2 Hedge pruned in the area. Should the caller again see the illegal camping after 10 pm, they should call SFPD to have the campers ticketed. RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Weeding 127 LINCOLN WAY, SAN FRANCISCO, CA, 94122 LINCOLN WAY 5 Inner Sunset PARK 37.766082763671996 -122.45946502685499 POINT (-122.45946503 37.76608276) Phone   109 7 11 14 11 15 8 29,492 5 12 12   109   11             1         109
778986 778986 243957 2008-07-07T23:51:15 2008-07-08T09:20:33 2008-07-08T09:20:33 Closed 2 Case is Invalid sent tree crew sup to inspect, this is nowhere near RPD property. DPW maintains this Blvd. Limb is still on ground 7/8/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 881 ARGUELLO BLVD, SAN FRANCISCO, CA, 94118 ARGUELLO BLVD 1 Inner Richmond RICHMOND 37.774673461914 -122.45862579345699 POINT (-122.45862579 37.77467346) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
780262 780262 255021 2008-07-28T05:20:22 2008-08-04T07:53:02 2008-08-04T07:53:02 Closed 2 Case Resolved limb cut up, 7/29/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH AVE and LINCOLN WAY 19TH AVE 5 Inner Sunset TARAVAL 37.765449523926 -122.477310180664 POINT (-122.47731018 37.76544952) Phone   9 10 4 12 2 11 5 56 8 8 8   9   4             1         9
781243 781243 287395 2008-09-25T10:22:45 2009-06-08T12:48:58 2009-06-08T12:48:58 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of EDDY ST and GOUGH ST EDDY ST 5 Cathedral Hill NORTHERN 37.78247833252 -122.424110412598 POINT (-122.42411041 37.78247833) Phone   100 4 11 39 11 7 6 28,852 9 41 41   100 1 11             2         100
782928 782928 289539 2008-09-29T15:54:53 2009-06-08T12:33:00 2009-06-08T12:33:00 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of MELROSE AVE and TERESITA BLVD MELROSE AVE 7 Miraloma Park INGLESIDE 37.733848571777 -122.445785522461 POINT (-122.44578552 37.73384857) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
783023 783023 244260 2008-07-08T13:44:38 2009-08-24T16:27:05 2009-08-24T16:27:05 Closed 2   RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of CLIPPER ST and HIGH ST CLIPPER ST 8 Diamond Heights MISSION 37.747505187988 -122.443161010742 POINT (-122.44316101 37.74750519) Phone   57 3 5 22 5 2 7 63 4 22 22   57   5             1         57
787177 787177 280287 2008-09-12T02:30:27 2008-09-12T13:56:47 2008-09-12T13:56:47 Closed 2 could not locate If this problem persists, caller should call back with very specific location information RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 5TH AVE and FULTON ST 5TH AVE 1 Inner Richmond RICHMOND 37.77375793457 -122.462684631348 POINT (-122.46268463 37.77375793) Phone     8 4 12 2 11 9 29,492 6 8 8 6     4 7     7     1          
791886 791886 274727 2008-09-02T16:05:49 2008-09-03T10:14:18 2008-09-03T10:14:18 Closed 2 tree work planned The Department is in the process of finalizing a plan to do significant pruning of all trees on Park Presidio Blvd. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 14TH AVE and BALBOA ST 14TH AVE 1 Inner Richmond RICHMOND 37.776844024658 -122.47257232666 POINT (-122.47257233 37.77684402) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
795385 795385 243107 2008-07-06T14:26:56 2008-07-08T08:46:41 2008-07-08T08:46:41 Closed 2 Case Resolved job completed 7/7/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Telegraph Hill/Pioneer Park, SAN FRANCISCO, CA, 94133 Telegraph Hill/Pioneer Park 3 Telegraph Hill CENTRAL 37.802783966064 -122.40583801269501 POINT (-122.40583801 37.80278397) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
796641 796641 250800 2008-07-19T19:40:56 2008-07-31T11:09:35 2008-07-31T11:09:35 Closed 2 Case Resolved Sprinkler was repaired 7/30/08 RecPark Work Queue 34 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of COLE ST and OAK ST COLE ST 5 Panhandle PARK 37.771461486816 -122.45059967041 POINT (-122.45059967 37.77146149) Phone   24 7 11 12 11 15 8 29,492 5 8 8 22 24   11 24     25     1         24
1700770 1700770 3128111 2013-12-03T18:02:01 2013-12-04T02:35:23 2013-12-04T02:35:23 Closed 2 Please refer to new SR #3128717 for Rec and Park. SR will be cancelled and closed out. RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 723 LINCOLN WAY, SAN FRANCISCO, CA, 94122 LINCOLN WAY 5 Inner Sunset TARAVAL 37.765924528767 -122.46644268429199 POINT (-122.46644268 37.76592453) Phone   109 10 11 14 11 11 5 56 8 12 12 2 109   11 2     2     1         109
1874771 1874771 3408574 2014-02-27T14:48:48 2015-06-10T13:35:18 2015-06-10T13:35:18 Closed 2 Administative Close. If case has not been resloved please resubmit your service request to 311. RecPark Work Queue 34 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of BRYANT ST and I-80 E OFF RAMP BRYANT ST 6 South of Market SOUTHERN 37.779567718505994 -122.39806365966801 POINT (-122.39806366 37.77956772) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
1895722 1895722 3489126 2014-03-25T14:41:59 2015-06-10T13:35:18 2015-06-10T13:35:18 Closed 2 Administative Close. If case has not been resloved please resubmit your service request to 311. RecPark Work Queue 34 Tree Maintenance 1 Trees - Overgrown_Tree 3 Overgrown_Tree 370 FELL ST, SAN FRANCISCO, CA, 94102 FELL ST 5 Hayes Valley NORTHERN 37.775940000000006 -122.424278 POINT (-122.424278 37.77594) Mobile/Open311   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22

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