calls

80,878 rows where Category = 1 sorted by Opened

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
784703 784703 243940 2008-07-07T21:30:16 2008-08-01T11:04:50 2008-08-01T11:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of CASTRO ST and MARKET ST CASTRO ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
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
766874 766874 244005 2008-07-08T08:10:33 2008-07-22T15:05:02 2008-07-22T15:05:02 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 477 FLOOD AVE, SAN FRANCISCO, CA, 94112 FLOOD AVE 7 Sunnyside INGLESIDE 37.729747772217 -122.450630187988 POINT (-122.45063019 37.72974777) Phone   95 9 8 41 4 9 4 28,861 7 40 40   95   8             1         95
665893 665893 244089 2008-07-08T10:17:11 2008-07-09T07:13:45 2008-07-09T07:13:45 Closed 2 Case Resolved Muni complaint was submitted. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 760 DELANO AVE, SAN FRANCISCO, CA, 94112 DELANO AVE 11 Cayuga INGLESIDE 37.719367980956996 -122.44570922851601 POINT (-122.44570923 37.71936798) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
734533 734533 244189 2008-07-08T12:18:21 2008-07-26T16:04:47 2008-07-26T16:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding 3032 BAKER ST, SAN FRANCISCO, CA, 94123 BAKER ST 2 Cow Hollow NORTHERN 37.799110412598 -122.44587707519501 POINT (-122.44587708 37.79911041) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6             1         14
698706 698706 244257 2008-07-08T13:39:19 2008-07-08T18:05:08 2008-07-08T18:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CLIPPER TER and HIGH ST CLIPPER TER 8 Upper Market MISSION 37.748008728027 -122.44347381591801 POINT (-122.44347382 37.74800873) Phone   51 3 5 22 5 2 7 63 4 22 22   51   5             1         51
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
509354 509354 244270 2008-07-08T14:02:20 2008-07-26T16:04:47 2008-07-26T16:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
731994 731994 244346 2008-07-08T15:36:49 2008-07-16T09:05:14 2008-07-16T09:05:14 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 142 VERNON ST, SAN FRANCISCO, CA, 94132 VERNON ST 11 Merced Heights TARAVAL 37.715103149414 -122.46786499023399 POINT (-122.46786499 37.71510315) Phone   65 10 1 24 6 9 5 64 8 24 24   65   1             2         65
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
705177 705177 244402 2008-07-08T16:55:23 2008-07-11T10:05:09 2008-07-11T10:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of POWELL ST and UNION ST POWELL ST 3 North Beach CENTRAL 37.800239562988 -122.410835266113 POINT (-122.41083527 37.80023956) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3             2     17   107
734637 734637 244403 2008-07-08T16:58:15 2008-07-09T10:05:09 2008-07-09T10:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 30 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 5 Inner Sunset PARK 37.764514923096 -122.458320617676 POINT (-122.45832062 37.76451492) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
772622 772622 244404 2008-07-08T16:58:35 2008-07-21T09:04:49 2008-07-21T09:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 649 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 1 Presidio Terrace RICHMOND 37.786449432373 -122.466514587402 POINT (-122.46651459 37.78644943) Phone   4 8 4 11 2 11 9 54 6 11 11   4   4             1         4
714448 714448 244406 2008-07-08T16:59:49 2008-08-01T11:04:51 2008-08-01T11:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 17TH ST and MARKET ST 17TH ST 8 Castro MISSION 37.762672424316 -122.43518829345699 POINT (-122.43518829 37.76267242) Phone   113 3 5 5 5 15 7 28,862 4 3 3 1 113   5 1   5 1 9   1   5     113
747895 747895 244430 2008-07-08T18:00:06 2008-07-08T19:05:08 2008-07-08T19:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 555 CALIFORNIA ST, SAN FRANCISCO, CA, 94104 CALIFORNIA ST 3 Financial District CENTRAL 37.792263031005994 -122.40348815918001 POINT (-122.40348816 37.79226303) Phone   108 6 3 8 10 4 1 28,854 1 6 6   108   3   17         2         108
761119 761119 244442 2008-07-08T18:13:08 2008-07-10T06:05:32 2008-07-10T06:05:32 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 2372 BRYANT ST, SAN FRANCISCO, CA, 94110 BRYANT ST 9 Mission MISSION 37.756519317627 -122.40964508056601 POINT (-122.40964508 37.75651932) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
776321 776321 244451 2008-07-08T18:25:18 2010-06-25T11:16:56 2010-06-25T11:16:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 246 2ND ST, SAN FRANCISCO, CA, 94105 2ND ST 6 South of Market SOUTHERN 37.785800933838 -122.397285461426 POINT (-122.39728546 37.78580093) Phone   32 1 10 8 9 6 2 28,855 2 6 6   32   10         4   1         32
798877 798877 244511 2008-07-08T22:41:19 2008-07-11T10:05:09 2008-07-11T10:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of POWELL ST and UNION ST POWELL ST 3 North Beach CENTRAL 37.800239562988 -122.410835266113 POINT (-122.41083527 37.80023956) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3             2     17   107
730019 730019 244520 2008-07-08T23:10:25 2008-07-22T13:05:22 2008-07-22T13:05:22 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of POWELL ST and UNION ST POWELL ST 3 North Beach CENTRAL 37.800239562988 -122.410835266113 POINT (-122.41083527 37.80023956) Phone   107 6 3 6 10 3 1 308 1 4 4   107   3             2     17   107
702732 702732 244590 2008-07-09T08:23:50 2008-08-10T06:04:25 2008-08-10T06:04:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of JUNIPERO SERRA BLVD and OCEAN AVE JUNIPERO SERRA BLVD 7 Merced Manor TARAVAL 37.731204986571996 -122.47216033935499 POINT (-122.47216034 37.73120499) Phone   62 10 8 41 4 1 5 64 8 40 40   62   8             1         62
747763 747763 244646 2008-07-09T09:29:07 2008-07-21T09:04:50 2008-07-21T09:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 724 FILLMORE ST, SAN FRANCISCO, CA, 94117 FILLMORE ST 5 Hayes Valley NORTHERN 37.776084899902 -122.431106567383 POINT (-122.43110657 37.7760849) Phone   22 4 11 9 11 7 6 29,492 9 10 10   22   11             1         22
758901 758901 244651 2008-07-09T09:33:16 2008-07-15T11:05:11 2008-07-15T11:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of OSHAUGHNESSY BLVD and PORTOLA DR OSHAUGHNESSY BLVD 7 Miraloma Park INGLESIDE 37.745532989502 -122.451622009277 POINT (-122.45162201 37.74553299) Phone   72 9 5 10 5 1 4 59 7 7 7   72   5             1         72
767049 767049 244673 2008-07-09T09:54:30 2008-07-11T10:05:10 2008-07-11T10:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1275 FAIRFAX AVE, SAN FRANCISCO, CA, 94124 FAIRFAX AVE 10 Bayview BAYVIEW 37.738704681396 -122.38288879394501 POINT (-122.38288879 37.73870468) Phone   86 2 9 1 8 10 3 58 3 1 1   86   9             2         86
712596 712596 244686 2008-07-09T10:05:15 2008-07-11T09:05:10 2008-07-11T09:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1125 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 5 Western Addition NORTHERN 37.780261993408 -122.43297576904301 POINT (-122.43297577 37.78026199) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11   24         2         97
736761 736761 244687 2008-07-09T10:07:44 2008-07-21T08:04:52 2008-07-21T08:04:52 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other 1125 FILLMORE ST, SAN FRANCISCO, CA, 94115 FILLMORE ST 5 Western Addition NORTHERN 37.780261993408 -122.43297576904301 POINT (-122.43297577 37.78026199) Phone   97 4 11 39 11 15 6 29,490 9 41 41   97   11   24         2         97
669207 669207 244706 2008-07-09T10:18:14 2008-07-14T14:05:13 2008-07-14T14:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 1151 WASHINGTON ST, SAN FRANCISCO, CA, 94108 WASHINGTON ST 3 Nob Hill CENTRAL 37.794315338135 -122.412208557129 POINT (-122.41220856 37.79431534) Phone   16 6 3 21 10 3 1 28,857 1 21 21   16   3             1         16
721053 721053 244793 2008-07-09T11:59:21 2008-07-14T14:05:13 2008-07-14T14:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3400 CALIFORNIA ST, SAN FRANCISCO, CA, 94118 CALIFORNIA ST 2 Presidio Heights RICHMOND 37.786930084229 -122.450424194336 POINT (-122.45042419 37.78693008) Phone   10 8 6 31 1 11 9 54 6 31 31   10   6             1         10
687839 687839 244794 2008-07-09T12:02:29 2008-07-09T19:56:26 2008-07-09T19:56:26 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 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
735642 735642 244865 2008-07-09T13:38:12 2008-07-23T11:03:22 2008-07-23T11:03:22 Closed 2 Case is Invalid Staff found no issues at site - staff will call caller. RPD Park Service Area 4 Queue 22 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Victoria Manalo Draves Park, SAN FRANCISCO, CA, 94103 Victoria Manalo Draves Park 6 South of Market SOUTHERN 37.777008056641 -122.405952453613 POINT (-122.40595245 37.77700806) Phone   32 1 10 34 9 14 2 28,853 2 34 34 24 32   10 6     6     2     38 12 32
746197 746197 244934 2008-07-09T14:36:27 2008-07-14T12:05:12 2008-07-14T12:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 724 CLAYTON ST, SAN FRANCISCO, CA, 94117 CLAYTON ST 5 Haight Ashbury PARK 37.768356323242 -122.44812774658199 POINT (-122.44812775 37.76835632) Phone   25 7 11 3 11 15 8 29,492 5 9 9   25   11             1         25
765201 765201 244947 2008-07-09T14:43:03 2008-07-09T16:05:18 2008-07-09T16:05:18 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding 1263 SILVER AVE, SAN FRANCISCO, CA, 94134 SILVER AVE 9 Portola BAYVIEW 37.730728149414 -122.411361694336 POINT (-122.41136169 37.73072815) Phone   91 2 2 25 7 9 3 309 3 28 28   91   2             2         91
685437 685437 244958 2008-07-09T14:57:52 2010-07-30T15:17:03 2010-07-30T15:17:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of 6TH AVE and CALIFORNIA ST 6TH AVE 1 Presidio Terrace RICHMOND 37.784992218018 -122.464569091797 POINT (-122.46456909 37.78499222) Phone   4 8 4 11 2 11 9 54 6 11 11   4   4             1         4
716059 716059 244977 2008-07-09T15:25:30 2008-07-16T09:05:14 2008-07-16T09:05:14 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 719 MONTEREY BLVD, SAN FRANCISCO, CA, 94112 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731239318848 -122.451591491699 POINT (-122.45159149 37.73123932) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
721447 721447 244987 2008-07-09T15:32:28 2008-07-09T19:05:08 2008-07-09T19:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of MAGELLAN AVE and SOLA AVE MAGELLAN AVE 7 Forest Hill TARAVAL 37.747753143311 -122.45996856689501 POINT (-122.45996857 37.74775314) Phone   45 10 8 41 4 1 5 29,491 8 40 40   45   8             1         45
794903 794903 245061 2008-07-09T16:57:24 2010-07-08T08:16:58 2010-07-08T08:16:58 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of ORD CT and VULCAN STWY ORD CT 8 Corona Heights PARK 37.763492584229 -122.440284729004 POINT (-122.44028473 37.76349258) Phone   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
703782 703782 245132 2008-07-09T19:29:31 2010-06-25T11:16:57 2010-06-25T11:16:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 24TH AVE and CABRILLO ST 24TH AVE 1 Outer Richmond RICHMOND 37.774486541748 -122.483253479004 POINT (-122.48325348 37.77448654) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
690173 690173 245139 2008-07-09T19:37:55 2008-07-15T10:04:14 2008-07-15T10:04:14 Closed 2 Long-term issue This is an ongoing issue that will require considerable effort and multi-divisional coordination to repair properly. For the time being, the leak is only occurring when the line is charged. The gardener has been very diligent in shutting off the valve at all times when not absolutely needed to minimize water waste. I anticipate this issue being unresolved for a quite some time as we coordinate a proper solution. RPD Park Service Area 2 Queue 10 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 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
782260 782260 245254 2008-07-10T08:45:19 2008-07-22T15:05:02 2008-07-22T15:05:02 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 15TH AVE and ORTEGA ST 15TH AVE 7 Golden Gate Heights TARAVAL 37.752571105956996 -122.472007751465 POINT (-122.47200775 37.75257111) Phone   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
718609 718609 245257 2008-07-10T08:47:19 2008-07-11T10:05:10 2008-07-11T10:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of CORTLAND AVE and MISSION ST CORTLAND AVE 9 Bernal Heights INGLESIDE 37.741027832031 -122.42284393310499 POINT (-122.42284393 37.74102783) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
689987 689987 245262 2008-07-10T08:52:08 2008-07-22T16:04:53 2008-07-22T16:04:53 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of SAN ANSELMO AVE and SAN BENITO WAY SAN ANSELMO AVE 7 St. Francis Wood TARAVAL 37.737133026123 -122.467300415039 POINT (-122.46730042 37.73713303) Phone   116 10 8 41 4 1 5 59 8 40 40   116   8             1         116
727621 727621 245264 2008-07-10T08:53:27 2008-07-22T15:05:03 2008-07-22T15:05:03 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 16TH AVE and ORTEGA ST 16TH AVE 7 Golden Gate Heights TARAVAL 37.752521514893 -122.47313690185499 POINT (-122.4731369 37.75252151) Phone   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
765191 765191 245268 2008-07-10T08:55:34 2008-07-16T09:05:14 2008-07-16T09:05:14 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 18TH AVE and ORTEGA ST 18TH AVE 7 Golden Gate Heights TARAVAL 37.752422332764 -122.475273132324 POINT (-122.47527313 37.75242233) Phone   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
757899 757899 245293 2008-07-10T09:17:44 2008-07-10T09:20:52 2008-07-10T09:20:52 Closed 2 Case is Invalid PROPERTY OWNERS RESPONSIBITITY NOT A CITY TREE DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 3233 IRVING ST, SAN FRANCISCO, CA, 94122 IRVING ST 4 Outer Sunset TARAVAL 37.762733459473 -122.49273681640601 POINT (-122.49273682 37.76273346) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
770113 770113 245325 2008-07-10T09:43:10 2008-08-06T09:05:10 2008-08-06T09:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of BOSWORTH ST and ELK ST BOSWORTH ST 8 Glen Park INGLESIDE 37.734855651855 -122.43993377685499 POINT (-122.43993378 37.73485565) Phone   96 9 5 41 5 9 4 63 7 40 40   96   5             1     80   96
793935 793935 245345 2008-07-10T10:00:02 2008-08-01T10:04:49 2008-08-01T10:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding 971 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Russian Hill CENTRAL 37.800483703613 -122.41544342041 POINT (-122.41544342 37.8004837) Phone   107 6 3 32 10 5 1 308 1 32 32   107   3             1         107
715939 715939 245369 2008-07-10T10:22:27 2010-07-08T10:16:58 2010-07-08T10:16:58 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 3126 22ND ST, SAN FRANCISCO, CA, 94110 22ND ST 9 Mission MISSION 37.75562286377 -122.417343139648 POINT (-122.41734314 37.75562286) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
688821 688821 245402 2008-07-10T10:50:51 2008-07-14T12:05:12 2008-07-14T12:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 219 ROOSEVELT WAY, SAN FRANCISCO, CA, 94114 ROOSEVELT WAY 8 Corona Heights PARK 37.766242980956996 -122.439682006836 POINT (-122.43968201 37.76624298) Phone   113 7 5 5 5 15 8 28,862 5 3 3   113   5             1         113
786662 786662 245416 2008-07-10T11:06:04 2008-07-16T15:05:11 2008-07-16T15:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line Intersection of 24TH ST and LILAC ST 24TH ST 9 Mission MISSION 37.752269744873 -122.41787719726601 POINT (-122.4178772 37.75226974) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
721833 721833 245431 2008-07-10T11:20:08 2008-07-12T16:05:10 2008-07-12T16:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of HAHN ST and SUNNYDALE AVE HAHN ST 10 Visitacion Valley INGLESIDE 37.7119140625 -122.416000366211 POINT (-122.41600037 37.71191406) Phone   75 9 9 40 8 9 4 309 7 39 39 14 75   9 16     16     2         75
790518 790518 245436 2008-07-10T11:22:27 2008-07-14T12:05:13 2008-07-14T12:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of BAY SHORE BLVD and SAN BRUNO AVE BAY SHORE BLVD 9 Apparel City BAYVIEW 37.738456726074 -122.407051086426 POINT (-122.40705109 37.73845673) Phone   82 2 2 2 7 10 3 58 3 2 2   82   2             1         82
705399 705399 245548 2008-07-10T13:50:15 2008-07-21T09:04:50 2008-07-21T09:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Hitting_window_or_building 2952 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 CALIFORNIA ST 2 Pacific Heights RICHMOND 37.787864685059 -122.44305419921899 POINT (-122.4430542 37.78786469) Phone   102 8 6 30 1 13 9 29,490 6 27 27   102   6             1         102
722821 722821 245558 2008-07-10T14:04:47 2010-07-08T08:16:59 2010-07-08T08:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 126 GOLD MINE DR, SAN FRANCISCO, CA, 94131 GOLD MINE DR 8 Diamond Heights INGLESIDE 37.742713928223 -122.438430786133 POINT (-122.43843079 37.74271393) Phone   57 9 5 10 5 2 4 63 7 7 7   57   5             1         57
696519 696519 245591 2008-07-10T14:39:19 2008-07-16T09:05:15 2008-07-16T09:05:15 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of OCEAN AVE and PHELAN AVE OCEAN AVE 7 Ingleside TARAVAL 37.723079681396 -122.45233154296899 POINT (-122.45233154 37.72307968) Phone   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19     19     2         64
785878 785878 245604 2008-07-10T15:12:06 2008-07-22T15:05:03 2008-07-22T15:05:03 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 15TH AVE and PACHECO ST 15TH AVE 7 Golden Gate Heights TARAVAL 37.750701904296996 -122.471878051758 POINT (-122.47187805 37.7507019) Phone   44 10 8 14 4 1 5 29,491 8 12 12   44   8             1         44
746623 746623 245631 2008-07-10T15:41:35 2008-07-11T06:05:25 2008-07-11T06:05:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 3080 MARKET ST, SAN FRANCISCO, CA, 94114 MARKET ST 8 Eureka Valley PARK 37.76095199585 -122.44303894043001 POINT (-122.44303894 37.760952) Phone   115 7 5 5 5 15 8 28,862 5 3 3   115   5             1         115
689477 689477 245646 2008-07-10T15:58:39 2008-07-10T17:05:10 2008-07-10T17:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 766 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 8 Mission Dolores MISSION 37.760665893555 -122.421676635742 POINT (-122.42167664 37.76066589) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
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
680471 680471 245700 2008-07-10T17:47:15 2008-07-21T09:04:50 2008-07-21T09:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1245 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.774318695068004 -122.410659790039 POINT (-122.41065979 37.7743187) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10             2         32
754874 754874 245727 2008-07-10T18:42:53 2008-07-27T06:44:30 2008-07-27T06:44:30 Closed 2 Case is Invalid request was denied. 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding 743 SILVER AVE, SAN FRANCISCO, CA, 94134 SILVER AVE 11 Mission Terrace INGLESIDE 37.729019165039 -122.420616149902 POINT (-122.42061615 37.72901917) Phone   94 9 1 7 6 9 4 28,861 7 5 5   94   1             2         94
707298 707298 245821 2008-07-11T07:35:24 2010-07-08T10:16:59 2010-07-08T10:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of 20TH ST and CASTRO ST 20TH ST 8 Eureka Valley MISSION 37.75768661499 -122.43470001220699 POINT (-122.43470001 37.75768661) Phone   115 3 5 5 5 2 7 28,862 4 3 3   115   5             1   5     115
714757 714757 245822 2008-07-11T07:39:28 2010-07-30T16:17:03 2010-07-30T16:17:03 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 198 CARL ST, SAN FRANCISCO, CA, 94117 CARL ST 5 Cole Valley PARK 37.765613555908 -122.45245361328101 POINT (-122.45245361 37.76561356) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
686520 686520 245909 2008-07-11T09:48:03 2008-07-14T12:05:13 2008-07-14T12:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of GROVE ST and OCTAVIA ST GROVE ST 5 Hayes Valley NORTHERN 37.777603149414 -122.42481231689501 POINT (-122.42481232 37.77760315) Phone   22 4 11 9 11 7 6 28,852 9 10 10   22   11             1         22
703219 703219 245943 2008-07-11T10:17:03 2008-07-26T16:04:47 2008-07-26T16:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of MCALLISTER ST and WEBSTER ST MCALLISTER ST 5 Western Addition NORTHERN 37.77885055542 -122.43004608154301 POINT (-122.43004608 37.77885056) Phone   97 4 11 39 11 7 6 29,490 9 41 41   97   11             2         97
740688 740688 245945 2008-07-11T10:18:55 2008-07-26T16:04:47 2008-07-26T16:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 22 PEACE PLZ, SAN FRANCISCO, CA, 94115 PEACE PLZ 5 Japantown NORTHERN 37.785438537598 -122.429023742676 POINT (-122.42902374 37.78543854) Phone   101 4 11 15 11 13 6 29,490 9 13 13 8 101   11 9 25   9 11   2         101
680116 680116 245952 2008-07-11T10:22:08 2010-06-25T11:16:57 2010-06-25T11:16:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding 15 ROTTECK ST, SAN FRANCISCO, CA, 94112 ROTTECK ST 8 St. Mary's Park INGLESIDE 37.732791900635 -122.430946350098 POINT (-122.43094635 37.7327919) Phone   93 9 5 28 5 9 4 28,861 7 25 25   93   5             1         93
786645 786645 245972 2008-07-11T10:31:30 2009-07-16T12:11:06 2009-07-16T12:11:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 5212 CALIFORNIA ST, SAN FRANCISCO, CA, 94118 CALIFORNIA ST 1 Lake Street RICHMOND 37.784557342529 -122.473487854004 POINT (-122.47348785 37.78455734) Phone   2 8 4 29 2 11 9 54 6 26 26   2   4             1         2
665975 665975 246002 2008-07-11T10:52:48 2008-07-14T12:05:13 2008-07-14T12:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3000 BAKER ST, SAN FRANCISCO, CA, 94123 BAKER ST 2 Cow Hollow NORTHERN 37.798770904541 -122.445846557617 POINT (-122.44584656 37.7987709) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6   21         1         14
734266 734266 246016 2008-07-11T11:02:46 2008-07-22T11:04:19 2008-07-22T11:04:19 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2674 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Cow Hollow NORTHERN 37.798789978027 -122.44553375244101 POINT (-122.44553375 37.79878998) Phone   14 4 6 13 1 13 6 57 9 17 17   14   6   21         1         14
661168 661168 246035 2008-07-11T11:12:47 2008-10-30T13:23:05 2008-10-30T13:23:05 Closed 2   RPD - Urban Forestry - G 35 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of 36TH AVE and LINCOLN WAY 36TH AVE 1 Outer Sunset TARAVAL 37.764636993408 -122.49547576904301 POINT (-122.49547577 37.76463699) Phone   39 10 7 35 3 1 5 56 8 35 35   39   7             1         39
775407 775407 246076 2008-07-11T11:53:34 2008-08-12T06:04:25 2008-08-12T06:04:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 915 FRANKLIN ST, SAN FRANCISCO, CA, 94109 FRANKLIN ST 5 Cathedral Hill NORTHERN 37.78299331665 -122.422660827637 POINT (-122.42266083 37.78299332) Phone   100 4 11 39 11 7 6 28,858 9 41 41   100   11             2         100
769654 769654 246079 2008-07-11T11:57:23 2010-06-25T11:16:57 2010-06-25T11:16:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of BALBOA ST and LA PLAYA BALBOA ST 1 Outer Richmond RICHMOND 37.775127410889 -122.51016998291 POINT (-122.51016998 37.77512741) Phone   8 8 4 29 2 11 9 55 6 26 26   8   4             1         8
760196 760196 246125 2008-07-11T12:56:10 2008-07-17T08:05:13 2008-07-17T08:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of CARL ST and STANYAN ST CARL ST 5 Parnassus Heights PARK 37.765441894531 -122.452758789063 POINT (-122.45275879 37.76544189) Phone   110 7 11 14 11 15 8 29,492 5 12 12   110   11             1         110
670537 670537 246218 2008-07-11T14:36:58 2010-07-08T10:16:59 2010-07-08T10:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of MISSION ST and PARK ST MISSION ST 8 Holly Park INGLESIDE 37.736736297607 -122.42423248291 POINT (-122.42423248 37.7367363) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
693683 693683 246251 2008-07-11T15:09:34 2008-07-12T06:05:21 2008-07-12T06:05:21 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 1851 DIVISADERO ST, SAN FRANCISCO, CA, 94115 DIVISADERO ST 2 Lower Pacific Heights NORTHERN 37.786762237549 -122.440376281738 POINT (-122.44037628 37.78676224) Phone   103 8 6 30 1 13 9 29,490 6 27 27   103   6             1         103
664770 664770 246261 2008-07-11T15:21:16 2008-07-17T09:05:11 2008-07-17T09:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below Intersection of BAKER ST and WASHINGTON ST BAKER ST 2 Pacific Heights RICHMOND 37.790325164795 -122.444297790527 POINT (-122.44429779 37.79032516) Phone   102 8 6 30 1 13 9 29,490 6 27 27   102   6             1         102
757275 757275 246263 2008-07-11T15:22:39 2008-07-11T16:05:09 2008-07-11T16:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of COLUMBUS AVE and FILBERT ST COLUMBUS AVE 3 Russian Hill CENTRAL 37.801124572754 -122.411376953125 POINT (-122.41137695 37.80112457) Phone   107 6 3 6 10 3 1 308 1 4 4 21 107   3 23     23     2         107
751993 751993 246299 2008-07-11T15:56:19 2010-07-14T15:16:59 2010-07-14T15:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of DRUMM ST and MARKET ST DRUMM ST 3 Financial District CENTRAL 37.793254852295 -122.39630126953101 POINT (-122.39630127 37.79325485) Phone   108 6 10 8 9 4 2 28,855 2 6 6   108   10             1     35   108
707669 707669 246318 2008-07-11T16:22:16 2011-08-11T13:06:01 2011-08-11T13:06:01 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 1969 CLAY ST, SAN FRANCISCO, CA, 94109 CLAY ST 2 Pacific Heights NORTHERN 37.791702270508 -122.425415039063 POINT (-122.42541504 37.79170227) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
760031 760031 246503 2008-07-12T09:51:26 2008-07-13T06:05:17 2008-07-13T06:05:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of 11TH ST and MISSION ST 11TH ST 6 South of Market SOUTHERN 37.774326324463 -122.41710662841801 POINT (-122.41710663 37.77432632) Phone   32 1 10 20 9 8 2 28,853 2 19 19   32 1 10     1   7 1 2 1 1     32
769100 769100 246531 2008-07-12T10:59:45 2008-07-13T06:05:18 2008-07-13T06:05:18 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of LARKIN ST and TURK ST LARKIN ST 6 Civic Center TENDERLOIN 37.782379150391 -122.417335510254 POINT (-122.41733551 37.78237915) Phone   20 5 10 36 9 7 6 28,852 9 36 36 17 20 1 10 18   1 18 6 1 2 1 1     20
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
796603 796603 246589 2008-07-12T12:39:26 2010-08-16T16:19:06 2010-08-16T16:19:06 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of COLE ST and HAIGHT ST COLE ST 5 Haight Ashbury PARK 37.769527435303004 -122.45070648193399 POINT (-122.45070648 37.76952744) Phone   25 7 11 3 11 15 8 29,492 5 9 9 22 25   11 24     25     1         25
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
699127 699127 246662 2008-07-12T16:19:08 2008-08-01T10:04:49 2008-08-01T10:04:49 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of BALCETA AVE and LAGUNA HONDA BLVD BALCETA AVE 7 Laguna Honda PARK 37.745491027831996 -122.457397460938 POINT (-122.45739746 37.74549103) Phone   49 7 8 41 4 1 8 59 5 40 40   49   8             1         49
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
772858 772858 246850 2008-07-13T11:51:26 2008-07-17T09:05:12 2008-07-17T09:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of BOSWORTH ST and CHILTON AVE BOSWORTH ST 8 Glen Park INGLESIDE 37.734039306641 -122.43667602539101 POINT (-122.43667603 37.73403931) Phone   96 9 5 41 5 9 4 63 7 40 40 15 96   5 17     17     1     80   96
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
752706 752706 246926 2008-07-13T16:27:51 2008-07-15T06:05:17 2008-07-15T06:05:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism 491 GUERRERO ST, SAN FRANCISCO, CA, 94110 GUERRERO ST 8 Mission Dolores MISSION 37.763431549071996 -122.423789978027 POINT (-122.42378998 37.76343155) Phone   37 3 5 20 5 8 7 28,859 4 19 19   37   5             2         37
781601 781601 246933 2008-07-13T16:40:50 2008-08-11T06:04:43 2008-08-11T06:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 19TH ST and MARKET ST 19TH ST 8 Eureka Valley MISSION 37.759407043456996 -122.444946289063 POINT (-122.44494629 37.75940704) Phone   115 3 5 5 5 15 7 28,862 4 3 3   115   5             1         115
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
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
675466 675466 247123 2008-07-14T09:04:30 2008-07-26T16:04:48 2008-07-26T16:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 473 UNION ST, SAN FRANCISCO, CA, 94133 UNION ST 3 North Beach CENTRAL 37.800567626953004 -122.40713500976601 POINT (-122.40713501 37.80056763) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23     23     2         106
716666 716666 247128 2008-07-14T09:09:02 2008-07-14T10:05:13 2008-07-14T10:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of FULTON ST and PARK PRESIDIO BLVD FULTON ST 1 Golden Gate Park RICHMOND 37.773139953613 -122.47176361084 POINT (-122.47176361 37.77313995) Phone   5 8 4 29 2 11 9 54 6 26 26   5   4             1     3   5
668297 668297 247130 2008-07-14T09:11:31 2008-07-16T22:50:03 2008-07-16T22:50:03 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Tree_Other 4 Other 156 MOFFITT ST, SAN FRANCISCO, CA, 94131 MOFFITT ST 8 Fairmount INGLESIDE 37.737945556641 -122.43360137939501 POINT (-122.43360138 37.73794556) Phone   59 9 5 10 5 2 4 63 7 7 7   59   5             1         59
773877 773877 247161 2008-07-14T09:42:37 2008-07-24T09:04:16 2008-07-24T09:04:16 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2 MIRALOMA DR, SAN FRANCISCO, CA, 94127 MIRALOMA DR 7 Sherwood Forest INGLESIDE 37.740215301514 -122.45987701416 POINT (-122.45987701 37.7402153) Phone   117 10 8 41 4 9 5 59 8 40 40   117   8             1         117
676911 676911 247186 2008-07-14T10:01:14 2008-07-16T23:00:58 2008-07-16T23:00:58 Closed 2 Case Resolved 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 38 DUBLIN ST, SAN FRANCISCO, CA, 94112 DUBLIN ST 11 Excelsior INGLESIDE 37.719039916992 -122.42608642578101 POINT (-122.42608643 37.71903992) Phone   90 9 1 7 6 9 4 309 7 5 5   90   1             2         90
771753 771753 247263 2008-07-14T11:17:10 2008-07-21T10:04:41 2008-07-21T10:04:41 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1300 BAY SHORE BLVD, SAN FRANCISCO, CA, 94134 BAY SHORE BLVD 10 Portola BAYVIEW 37.728076934814 -122.402275085449 POINT (-122.40227509 37.72807693) Phone   91 2 9 25 8 10 3 309 3 28 28   91   9             2         91
691277 691277 247292 2008-07-14T11:36:44 2008-07-21T10:04:41 2008-07-21T10:04:41 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below Intersection of 24TH ST and DIAMOND ST 24TH ST 8 Noe Valley MISSION 37.751152038574 -122.43630218505899 POINT (-122.43630219 37.75115204) Phone   84 3 5 22 5 2 7 28,862 4 22 22   84   5         12   1         84
680665 680665 247330 2008-07-14T12:13:35 2010-07-08T10:16:59 2010-07-08T10:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of CHENERY ST and DIAMOND ST CHENERY ST 8 Glen Park INGLESIDE 37.734508514404 -122.433876037598 POINT (-122.43387604 37.73450851) Phone   96 9 5 10 5 2 4 63 7 7 7 15 96   5 17     17     1         96
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

Next page

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