calls

80,878 rows where Category = 1 sorted by Updated

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
722519 722519 240220 2008-07-01T01:56:58 2008-07-01T06:10:23 2008-07-01T06:10:23 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 2ND AVE and IRVING ST 2ND AVE 5 Inner Sunset PARK 37.764366149902 -122.45881652831999 POINT (-122.45881653 37.76436615) Phone   109 7 11 14 11 15 8 56 5 12 12   109   11             1         109
664350 664350 240341 2008-07-01T09:16:02 2008-07-01T12:05:13 2008-07-01T12:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 60 CASTRO ST, SAN FRANCISCO, CA, 94114 CASTRO ST 8 Buena Vista PARK 37.768119812012 -122.435859680176 POINT (-122.43585968 37.76811981) Phone   112 7 5 5 5 15 8 29,492 5 3 3   112   5             1         112
780962 780962 240509 2008-07-01T11:28:17 2008-07-01T15:05:08 2008-07-01T15: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 PIERCE ST and WALLER ST PIERCE ST 8 Duboce Triangle PARK 37.770755767821996 -122.433547973633 POINT (-122.43354797 37.77075577) Phone   28 7 11 3 11 15 8 29,492 5 9 9   28   11             1         28
697128 697128 241193 2008-07-02T11:13:29 2008-07-02T14:05:11 2008-07-02T14:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1909 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Cayuga INGLESIDE 37.721244812012 -122.43864440918001 POINT (-122.43864441 37.72124481) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
748355 748355 241223 2008-07-02T11:29:23 2008-07-02T15:05:08 2008-07-02T15:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
788755 788755 240690 2008-07-01T14:14:45 2008-07-03T15:05:07 2008-07-03T15:05:07 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1434 HYDE ST, SAN FRANCISCO, CA, 94109 HYDE ST 3 Nob Hill CENTRAL 37.794170379639 -122.417869567871 POINT (-122.41786957 37.79417038) Phone   16 6 3 32 10 5 1 28,858 1 32 32   16   3             1         16
675622 675622 240628 2008-07-01T13:06:41 2008-07-03T16:05:10 2008-07-03T16:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of 8TH AVE and CABRILLO ST 8TH AVE 1 Inner Richmond RICHMOND 37.775272369385 -122.466018676758 POINT (-122.46601868 37.77527237) Phone   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
747201 747201 242235 2008-07-03T21:05:18 2008-07-03T21:06:11 2008-07-03T21:06:11 Closed 2 Case Resolved DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 16 5TH AVE, SAN FRANCISCO, CA, 94118 5TH AVE 2 Presidio Terrace RICHMOND 37.788433074951 -122.463584899902 POINT (-122.4635849 37.78843307) Phone   4 8 6 11 1 11 9 54 6 11 11   4   6             1         4
697269 697269 241372 2008-07-02T13:51:49 2008-07-04T06:05:31 2008-07-04T06:05:31 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Backfill_tree_basin 3178 16TH ST, SAN FRANCISCO, CA, 94103 16TH ST 8 Mission Dolores MISSION 37.764942169189 -122.423538208008 POINT (-122.42353821 37.76494217) Phone   37 3 5 20 5 8 7 28,853 4 19 19   37   5             2         37
694599 694599 242478 2008-07-04T17:13:01 2008-07-04T19:05:08 2008-07-04T19:05:08 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FOLSOM ST and JUNIPER ST FOLSOM ST 6 South of Market SOUTHERN 37.772342681885 -122.41342163085899 POINT (-122.41342163 37.77234268) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
706442 706442 241933 2008-07-03T13:14:04 2008-07-05T06:05:12 2008-07-05T06:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of 4TH AVE and LINCOLN WAY 4TH AVE 5 Inner Sunset PARK 37.766159057617 -122.46109008789101 POINT (-122.46109009 37.76615906) Phone   109 7 11 14 11 11 8 29,492 5 12 12   109   11             1         109
747210 747210 242541 2008-07-04T20:16:36 2008-07-05T06:05:17 2008-07-05T06:05:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of FARALLONES ST and SAN JOSE AVE FARALLONES ST 11 Oceanview TARAVAL 37.71410369873 -122.45217132568399 POINT (-122.45217133 37.7141037) Phone   81 10 1 24 6 9 5 28,861 8 24 24   81   1             2         81
701204 701204 242589 2008-07-05T02:43:22 2008-07-05T06:05:18 2008-07-05T06:05:18 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of KINGSTON ST and MISSION ST KINGSTON ST 9 Bernal Heights INGLESIDE 37.741760253906 -122.42236328125 POINT (-122.42236328 37.74176025) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
775529 775529 241240 2008-07-02T11:46:50 2008-07-05T13:05:11 2008-07-05T13:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 19TH AVE and JUNIPERO SERRA BLVD 19TH AVE 7 Parkmerced TARAVAL 37.717174530029 -122.47257232666 POINT (-122.47257233 37.71717453) Phone   65 10 8 41 4 9 5 64 8 40 40   65   8             1         65
788953 788953 240639 2008-07-01T13:16:04 2008-07-05T13:05:11 2008-07-05T13:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 1345 OCEAN AVE, SAN FRANCISCO, CA, 94112 OCEAN AVE 7 Ingleside TARAVAL 37.723896026611 -122.456855773926 POINT (-122.45685577 37.72389603) Phone   64 10 8 24 4 9 5 28,861 8 24 24   64   8 19 6   19 13   2         64
662852 662852 241727 2008-07-03T08:36:25 2008-07-05T13:05:12 2008-07-05T13:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 1135 PORTOLA DR, SAN FRANCISCO, CA, 94127 PORTOLA DR 7 Sherwood Forest TARAVAL 37.740169525146 -122.460502624512 POINT (-122.46050262 37.74016953) Phone   117 10 8 41 4 9 5 59 8 40 40   117   8             1         117
791741 791741 241237 2008-07-02T11:44:10 2008-07-05T13:05:12 2008-07-05T13:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 15 WEST PORTAL AVE, SAN FRANCISCO, CA, 94127 WEST PORTAL AVE 7 West Portal TARAVAL 37.740581512451 -122.465789794922 POINT (-122.46578979 37.74058151) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8   23         1         46
706087 706087 242649 2008-07-05T10:36:16 2008-07-05T16:30:30 2008-07-05T16:30:30 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 77 OAKWOOD ST, SAN FRANCISCO, CA, 94110 OAKWOOD ST 8 Mission Dolores MISSION 37.760307312012 -122.42478179931601 POINT (-122.4247818 37.76030731) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
753025 753025 242651 2008-07-05T10:40:21 2008-07-05T16:47:03 2008-07-05T16:47:03 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Weeding 65 OAKWOOD ST, SAN FRANCISCO, CA, 94110 OAKWOOD ST 8 Mission Dolores MISSION 37.760456085205 -122.42479705810499 POINT (-122.42479706 37.76045609) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
732430 732430 242643 2008-07-05T10:26:23 2008-07-05T16:49:37 2008-07-05T16:49:37 Closed 2 Case is Invalid DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 74 OAKWOOD ST, SAN FRANCISCO, CA, 94110 OAKWOOD ST 8 Mission Dolores MISSION 37.760440826416 -122.42502593994101 POINT (-122.42502594 37.76044083) Phone   37 3 5 20 5 2 7 28,859 4 19 19   37   5             1         37
661069 661069 242325 2008-07-04T11:04:12 2008-07-05T19:05:07 2008-07-05T19:05:07 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of 3RD ST and PAUL AVE 3RD ST 10 Bret Harte BAYVIEW 37.722431182861 -122.39562225341801 POINT (-122.39562225 37.72243118) Phone   88 2 9 1 8 10 3 58 3 1 1   88   9             2         88
726807 726807 242851 2008-07-05T17:49:00 2008-07-05T19:08:24 2008-07-05T19:08:24 Closed 2 Case Transferred DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of DOWNEY ST and FREDERICK ST DOWNEY ST 5 Ashbury Heights PARK 37.767108917236 -122.447196960449 POINT (-122.44719696 37.76710892) Phone   114 7 11 3 11 15 8 29,492 5 9 9   114   11             1         114
766512 766512 242853 2008-07-05T17:51:44 2008-07-05T19:09:05 2008-07-05T19:09:05 Closed 2 Case Transferred DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of CLAYTON ST and FREDERICK ST CLAYTON ST 5 Cole Valley PARK 37.76700592041 -122.448013305664 POINT (-122.44801331 37.76700592) Phone   29 7 11 3 11 15 8 29,492 5 9 9   29   11             1         29
662056 662056 242855 2008-07-05T17:53:36 2008-07-05T19:09:57 2008-07-05T19:09:57 Closed 2 Case Transferred DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal 415 DEWEY BLVD, SAN FRANCISCO, CA, 94116 DEWEY BLVD 7 Laguna Honda TARAVAL 37.746887207031 -122.459442138672 POINT (-122.45944214 37.74688721) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
699173 699173 242856 2008-07-05T17:56:02 2008-07-05T19:10:44 2008-07-05T19:10:44 Closed 2 Case Transferred DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal 417 DEWEY BLVD, SAN FRANCISCO, CA, 94116 DEWEY BLVD 7 Laguna Honda TARAVAL 37.7467918396 -122.45956420898399 POINT (-122.45956421 37.74679184) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
660381 660381 240319 2008-07-01T08:52:00 2008-07-06T06:05:15 2008-07-06T06:05:15 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of 23RD ST and PENNSYLVANIA AVE 23RD ST 10 Potrero Hill BAYVIEW 37.755096435546996 -122.39288330078101 POINT (-122.3928833 37.75509644) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9         14   2         54
767158 767158 242917 2008-07-05T22:32:14 2008-07-06T06:05:39 2008-07-06T06:05:39 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of RANDALL ST and SAN JOSE AVE RANDALL ST 8 Holly Park INGLESIDE 37.739868164063 -122.42414855956999 POINT (-122.42414856 37.73986816) Phone   61 9 5 10 5 2 4 28,859 7 7 7   61   5             1         61
715471 715471 242988 2008-07-06T09:56:24 2008-07-06T11:05:13 2008-07-06T11:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of ASHBURY ST and CLAYTON ST ASHBURY ST 8 Buena Vista PARK 37.762722015380994 -122.446990966797 POINT (-122.44699097 37.76272202) Phone   112 7 5 3 5 15 8 29,492 5 9 9   112   5             1         112
801377 801377 243027 2008-07-06T11:15:55 2008-07-06T14:36:21 2008-07-06T14:36:21 Closed 2 Case Resolved Added note, now reclosing. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ASHBURY ST and CLAYTON ST ASHBURY ST 8 Buena Vista PARK 37.762722015380994 -122.446990966797 POINT (-122.44699097 37.76272202) Phone   112 7 5 3 5 15 8 29,492 5 9 9   112   5             1         112
800072 800072 243093 2008-07-06T13:53:30 2008-07-06T20:05:07 2008-07-06T20:05:07 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 145 KINGSTON ST, SAN FRANCISCO, CA, 94110 KINGSTON ST 9 Bernal Heights INGLESIDE 37.741607666016 -122.421836853027 POINT (-122.42183685 37.74160767) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
734402 734402 241879 2008-07-03T11:43:47 2008-07-07T06:05:17 2008-07-07T06:05:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 1600 DOLORES ST, SAN FRANCISCO, CA, 94131 DOLORES ST 8 Noe Valley INGLESIDE 37.743675231934 -122.424598693848 POINT (-122.42459869 37.74367523) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
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
728278 728278 240266 2008-07-01T07:35:21 2008-07-07T07:05:09 2008-07-07T07:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 330 11TH AVE, SAN FRANCISCO, CA, 94118 11TH AVE 1 Inner Richmond RICHMOND 37.782093048096 -122.469566345215 POINT (-122.46956635 37.78209305) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
754727 754727 243867 2008-07-07T17:36:04 2008-07-08T06:05:16 2008-07-08T06:05:16 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 3RD AVE and KEZAR DR 3RD AVE 5 Golden Gate Park PARK 37.76634979248 -122.459930419922 POINT (-122.45993042 37.76634979) Phone   9 7 11 12 11 11 9 29,492 6 8 8   9   11             1         9
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
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
764766 764766 241818 2008-07-03T10:26:56 2008-07-08T11:05:10 2008-07-08T11:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of BUSH ST and STEINER ST BUSH ST 2 Lower Pacific Heights NORTHERN 37.786811828613 -122.435104370117 POINT (-122.43510437 37.78681183) Phone   103 4 11 30 11 13 6 29,490 9 27 27   103   11             1         103
699680 699680 241939 2008-07-03T13:22:04 2008-07-08T11:05:11 2008-07-08T11:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1820 POST ST, SAN FRANCISCO, CA, 94115 POST ST 5 Japantown NORTHERN 37.785385131836 -122.43215179443399 POINT (-122.43215179 37.78538513) Phone   101 4 11 15 11 13 6 29,490 9 13 13 8 101   11 9 24   9     2         101
759094 759094 241253 2008-07-02T11:57:51 2008-07-08T12:05:23 2008-07-08T12:05:23 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of CESAR CHAVEZ ST and DIAMOND ST CESAR CHAVEZ ST 8 Noe Valley MISSION 37.747177124023 -122.435913085938 POINT (-122.43591309 37.74717712) Phone   84 3 5 22 5 2 7 63 4 22 22   84   5             1         84
737925 737925 241386 2008-07-02T14:07:29 2008-07-08T12:05:24 2008-07-08T12:05:24 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage Intersection of ALEMANY BLVD and NAGLEE AVE ALEMANY BLVD 11 Outer Mission INGLESIDE 37.713886260986 -122.44895172119101 POINT (-122.44895172 37.71388626) Phone   66 9 1 28 6 9 4 28,861 7 25 25   66   1             2         66
746022 746022 241938 2008-07-03T13:20:50 2008-07-08T12:05:25 2008-07-08T12:05:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 66 CORTLAND AVE, SAN FRANCISCO, CA, 94110 CORTLAND AVE 9 Holly Park INGLESIDE 37.740379333496 -122.42155456543001 POINT (-122.42155457 37.74037933) Phone   61 9 2 2 7 2 4 28,859 7 2 2   61   2             1         61
780345 780345 241529 2008-07-02T16:40:07 2008-07-08T12:05:25 2008-07-08T12:05:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 1742 CHURCH ST, SAN FRANCISCO, CA, 94131 CHURCH ST 8 Noe Valley INGLESIDE 37.743076324463 -122.426773071289 POINT (-122.42677307 37.74307632) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
668148 668148 243173 2008-07-06T16:36:28 2008-07-08T12:05:29 2008-07-08T12:05:29 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
676701 676701 243939 2008-07-07T21:24:05 2008-07-08T17:05:42 2008-07-08T17:05:42 Closed 2 Case Transferred 311 Supervisor Queue 5 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
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
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
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
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
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
760754 760754 243745 2008-07-07T15:07:37 2008-07-09T17:05:16 2008-07-09T17:05:16 Closed 2 See Notes tab for more details PUC Sewer Ops 27 Tree Maintenance 1 Trees - Damaging_Property 2 Sewer_damage_tree_roots 779 6TH AVE, SAN FRANCISCO, CA, 94118 6TH AVE 1 Inner Richmond RICHMOND 37.774127960205 -122.463966369629 POINT (-122.46396637 37.77412796) Phone   5 8 4 11 2 11 9 54 6 11 11 6 5   4 7     7     1         5
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
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
734990 734990 243434 2008-07-07T09:38:40 2008-07-10T06:05:20 2008-07-10T06:05:20 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of CHESTNUT ST and GRANT AVE CHESTNUT ST 3 Telegraph Hill CENTRAL 37.80436706543 -122.40833282470699 POINT (-122.40833282 37.80436707) Phone   106 6 3 23 10 3 1 308 1 23 23   106   3             2         106
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
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
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
728276 728276 242418 2008-07-04T13:53:36 2008-07-10T20:05:10 2008-07-10T20:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of BOSWORTH ST and LIPPARD AVE BOSWORTH ST 8 Glen Park INGLESIDE 37.733875274658 -122.435836791992 POINT (-122.43583679 37.73387527) Phone   96 9 5 41 5 9 4 63 7 40 40 15 96   5 17     17     1     80   96
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
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
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
771783 771783 243343 2008-07-07T07:56:58 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 - Damaged_Tree 1 Fallen_tree Intersection of GEARY BLVD and MASONIC AVE GEARY BLVD 2 Lone Mountain RICHMOND 37.782390594482 -122.447303771973 POINT (-122.44730377 37.78239059) Phone   12 8 4 18 2 15 8 54 5 16 16   12   4             1     7   12
672201 672201 243851 2008-07-07T17:11:08 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 - Overgrown_Tree 3 Other_enter_additional_details_below 2490 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 CALIFORNIA ST 2 Pacific Heights NORTHERN 37.788848876953004 -122.435340881348 POINT (-122.43534088 37.78884888) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
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
724912 724912 243514 2008-07-07T10:53:28 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 - Overgrown_Tree 3 Pruning_request 1655 DOLORES ST, SAN FRANCISCO, CA, 94110 DOLORES ST 8 Noe Valley INGLESIDE 37.742858886719 -122.42404937744101 POINT (-122.42404938 37.74285889) Phone   84 9 5 22 5 2 4 28,859 7 22 22   84   5             1         84
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
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
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
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
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
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
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
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
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
663917 663917 243666 2008-07-07T12:58:59 2008-07-14T12:05:10 2008-07-14T12:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of BELVEDERE ST and WALLER ST BELVEDERE ST 5 Cole Valley PARK 37.768730163574 -122.44945526123001 POINT (-122.44945526 37.76873016) Phone   29 7 11 3 11 15 8 29,492 5 9 9 22 29   11 24     25     1         29
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
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
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
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
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
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
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
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
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
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
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
699987 699987 247549 2008-07-14T16:46:17 2008-07-15T06:05:23 2008-07-15T06:05:23 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 23RD ST and MISSION ST 23RD ST 9 Mission MISSION 37.753837585449 -122.418594360352 POINT (-122.41859436 37.75383759) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
673607 673607 240465 2008-07-01T10:50:48 2008-07-15T08:05:14 2008-07-15T08:05:14 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 119 HAIGHT ST, SAN FRANCISCO, CA, 94102 HAIGHT ST 5 Mint Hill NORTHERN 37.772754669189 -122.424354553223 POINT (-122.42435455 37.77275467) Phone   27 4 11 9 11 7 6 28,852 9 10 10   27   11             1         27
681791 681791 240489 2008-07-01T11:15:17 2008-07-15T08:05:14 2008-07-15T08:05:14 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of CALIFORNIA ST and DRUMM ST CALIFORNIA ST 3 Financial District CENTRAL 37.793663024902 -122.39639282226601 POINT (-122.39639282 37.79366302) Phone   108 6 3 8 10 4 1 28,855 1 6 6   108   3             2         108
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
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
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
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
685821 685821 247814 2008-07-15T10:02:58 2008-07-15T12:05:10 2008-07-15T12:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1600 FELL ST, SAN FRANCISCO, CA, 94117 FELL ST 5 Panhandle PARK 37.773456573486 -122.44457244873001 POINT (-122.44457245 37.77345657) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
661406 661406 247829 2008-07-15T10:18:05 2008-07-15T12:05:11 2008-07-15T12:05:11 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 CENTRAL AVE and FELL ST CENTRAL AVE 5 Panhandle PARK 37.773212432861 -122.444213867188 POINT (-122.44421387 37.77321243) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
666627 666627 248061 2008-07-15T14:32:33 2008-07-15T16:05:11 2008-07-15T16:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 3237 PIERCE ST, SAN FRANCISCO, CA, 94123 PIERCE ST 2 Marina NORTHERN 37.799987792969 -122.439590454102 POINT (-122.43959045 37.79998779) Phone   17 4 6 13 1 13 6 57 9 17 17 19 17   6 21     21     1         17
778523 778523 248063 2008-07-15T14:35:06 2008-07-15T16:05:11 2008-07-15T16:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CHESTNUT ST and PIERCE ST CHESTNUT ST 2 Marina NORTHERN 37.800403594971 -122.439506530762 POINT (-122.43950653 37.80040359) Phone   17 4 6 13 1 13 6 57 9 17 17 19 17   6 21     21     1         17
792065 792065 247946 2008-07-15T12:27:55 2008-07-15T17:05:10 2008-07-15T17:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of CHESTNUT ST and PIERCE ST CHESTNUT ST 2 Marina NORTHERN 37.800403594971 -122.439506530762 POINT (-122.43950653 37.80040359) Phone   17 4 6 13 1 13 6 57 9 17 17 19 17   6 21     21     1         17
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

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