calls

80,878 rows 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
678326 678326 242779 2008-07-05T14:45:26 2008-07-16T09:05:13 2008-07-16T09:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 14 SHIELDS ST, SAN FRANCISCO, CA, 94132 SHIELDS ST 11 Ingleside TARAVAL 37.718013763428004 -122.462944030762 POINT (-122.46294403 37.71801376) Phone   64 10 1 24 6 9 5 64 8 24 24   64   1             2         64
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
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
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
694444 694444 247517 2008-07-14T16:10:33 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 129 IDORA AVE, SAN FRANCISCO, CA, 94127 IDORA AVE 7 Laguna Honda TARAVAL 37.743953704834 -122.457237243652 POINT (-122.45723724 37.7439537) Phone   49 10 8 41 4 1 5 59 8 40 40   49   8             1         49
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
715654 715654 248522 2008-07-16T10:08:41 2008-07-16T12:50:08 2008-07-16T12:50:08 Closed 2 Case Resolved DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 209 GOLDEN GATE AVE, SAN FRANCISCO, CA, 94102 GOLDEN GATE AVE 6 Civic Center TENDERLOIN 37.78169631958 -122.414184570313 POINT (-122.41418457 37.78169632) Phone   21 5 10 36 9 7 10 28,852 10 36 36 17 21 1 10 18   1 18 6 1 2 1 1     21
661115 661115 241152 2008-07-02T10:26:49 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 Blocking_sidewalk 471 NOE ST, SAN FRANCISCO, CA, 94114 NOE ST 8 Castro MISSION 37.761505126953004 -122.432655334473 POINT (-122.43265533 37.76150513) Phone   38 3 5 5 5 15 7 28,862 4 3 3   38   5       1     1   5     38
707702 707702 241256 2008-07-02T12:00:48 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 Blocking_signs 80 DUNCAN ST, SAN FRANCISCO, CA, 94110 DUNCAN ST 8 Bernal Heights INGLESIDE 37.746501922607 -122.421875 POINT (-122.421875 37.74650192) Phone   83 9 5 22 5 2 4 28,859 7 22 22   83   5             1         83
766401 766401 241301 2008-07-02T12:53:20 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 193 VALMAR TER, SAN FRANCISCO, CA, 94112 VALMAR TER 11 Excelsior INGLESIDE 37.725215911865 -122.42554473876999 POINT (-122.42554474 37.72521591) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             1         90
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
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
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
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
717403 717403 247789 2008-07-15T09:31:55 2008-07-16T23:31:40 2008-07-16T23:31:40 Closed 2 Case Transferred 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Landscaping 5 Lawn_mowing Intersection of ENCLINE CT and MARIETTA DR ENCLINE CT 7 Miraloma Park INGLESIDE 37.741897583008 -122.449081420898 POINT (-122.44908142 37.74189758) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
764438 764438 247912 2008-07-15T11:46:15 2008-07-16T23:38:02 2008-07-16T23:38:02 Closed 2 Case is Invalid 311 Supervisor Queue 5 Tree Maintenance 1 Trees - Overgrown_Tree 3 Other_enter_additional_details_below 65 MIRALOMA DR, SAN FRANCISCO, CA, 94127 MIRALOMA DR 7 Sherwood Forest INGLESIDE 37.739086151123 -122.460746765137 POINT (-122.46074677 37.73908615) Phone   117 9 8 41 4 9 4 59 7 40 40   117   8             1         117
734694 734694 243400 2008-07-07T09:06:14 2008-07-17T08:05:12 2008-07-17T08:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of DRUMM ST and WASHINGTON ST DRUMM ST 3 Northern Waterfront CENTRAL 37.796348571777 -122.396957397461 POINT (-122.3969574 37.79634857) Phone   77 6 3 8 10 3 1 28,860 1 6 6   77   3     4       1   4     77
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
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
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
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
687704 687704 249550 2008-07-17T16:22:08 2008-07-17T17:05:18 2008-07-17T17:05:18 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 317 WEST PORTAL AVE, SAN FRANCISCO, CA, 94127 WEST PORTAL AVE 7 West Portal TARAVAL 37.737670898438 -122.46912384033199 POINT (-122.46912384 37.7376709) Phone   46 10 8 41 4 1 5 59 8 40 40   46   8   23         1         46
758850 758850 247580 2008-07-14T17:49:13 2008-07-18T06:04:55 2008-07-18T06:04:55 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of 25TH ST and GUERRERO ST 25TH ST 8 Dolores Heights MISSION 37.750373840331996 -122.422729492188 POINT (-122.42272949 37.75037384) Phone   52 3 5 20 5 2 7 28,859 4 19 19   52   5             1         52
758495 758495 249637 2008-07-17T18:15:41 2008-07-18T06:05:05 2008-07-18T06:05:05 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of MIRAMAR AVE and WILDWOOD WAY MIRAMAR AVE 7 Westwood Park INGLESIDE 37.727584838867 -122.458206176758 POINT (-122.45820618 37.72758484) Phone   71 9 8 41 4 9 4 28,861 7 40 40   71   8             1         71
694137 694137 249763 2008-07-18T08:24:34 2008-07-18T11:04:20 2008-07-18T11:04:20 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other Intersection of GRANT AVE and UNION ST GRANT AVE 3 North Beach CENTRAL 37.800636291504 -122.40758514404301 POINT (-122.40758514 37.80063629) Phone   106 6 3 23 10 3 1 308 1 23 23 21 106   3 23     23     2         106
679047 679047 250315 2008-07-18T14:25:45 2008-07-18T17:04:47 2008-07-18T17:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 2247 LOMBARD ST, SAN FRANCISCO, CA, 94123 LOMBARD ST 2 Cow Hollow NORTHERN 37.799339294434 -122.438438415527 POINT (-122.43843842 37.79933929) Phone   14 4 6 13 1 13 6 57 9 17 17 19 14   6 21 21   21     1         14
752498 752498 250699 2008-07-19T14:53:37 2008-07-19T16:04:35 2008-07-19T16:04:35 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree 85 CORTLAND AVE, SAN FRANCISCO, CA, 94110 CORTLAND AVE 9 Bernal Heights INGLESIDE 37.740447998046996 -122.421142578125 POINT (-122.42114258 37.740448) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
743725 743725 250787 2008-07-19T18:42:20 2008-07-19T18:49:53 2008-07-19T18:49:53 Closed 2 Case is a Duplicate please see SR # 250773 DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1091 CHURCH ST, SAN FRANCISCO, CA, 94114 CHURCH ST 8 Dolores Heights MISSION 37.753498077393 -122.427421569824 POINT (-122.42742157 37.75349808) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
673088 673088 250917 2008-07-20T11:12:00 2008-07-20T12:04:41 2008-07-20T12:04:41 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 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
689225 689225 249485 2008-07-17T15:11:30 2008-07-21T06:05:11 2008-07-21T06:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 43 STARVIEW WAY, SAN FRANCISCO, CA, 94131 STARVIEW WAY 7 Midtown Terrace PARK 37.750381469727 -122.451675415039 POINT (-122.45167542 37.75038147) Phone   48 7 8 38 4 1 8 63 5 38 38   48   8             1         48
670472 670472 248833 2008-07-16T15:34:55 2008-07-21T07:04:58 2008-07-21T07:04:58 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 154 21ST AVE, SAN FRANCISCO, CA, 94121 21ST AVE 1 Lake Street RICHMOND 37.784942626953004 -122.480628967285 POINT (-122.48062897 37.78494263) Phone   2 8 4 29 2 11 9 55 6 26 26   2   4             2         2
701489 701489 250759 2008-07-19T17:25:45 2008-07-21T07:04:59 2008-07-21T07:04:59 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 3RD ST and FOLSOM ST 3RD ST 6 South of Market SOUTHERN 37.783782958984 -122.39893341064501 POINT (-122.39893341 37.78378296) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10         4   2         32
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
693383 693383 247415 2008-07-14T13:41:21 2008-07-21T08:04:53 2008-07-21T08:04:53 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2350 CALIFORNIA ST, SAN FRANCISCO, CA, 94115 CALIFORNIA ST 2 Pacific Heights NORTHERN 37.789134979248 -122.43308258056601 POINT (-122.43308258 37.78913498) Phone   102 4 6 30 1 13 6 29,490 9 27 27   102   6             1         102
677757 677757 248504 2008-07-16T09:53:42 2008-07-21T08:04:54 2008-07-21T08:04:54 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 501 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 1 Presidio Terrace RICHMOND 37.786518096924 -122.46501159668001 POINT (-122.4650116 37.7865181) Phone   4 8 4 11 2 11 9 54 6 11 11   4   4             1         4
703186 703186 247409 2008-07-14T13:38:39 2008-07-21T08:04:54 2008-07-21T08:04:54 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 3330 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 2 Laurel Heights / Jordan Park RICHMOND 37.781707763671996 -122.454765319824 POINT (-122.45476532 37.78170776) Phone   11 8 6 31 1 11 9 54 6 31 31   11   6             1         11
785032 785032 249513 2008-07-17T15:41:38 2008-07-21T08:04:57 2008-07-21T08:04:57 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1430 CALIFORNIA ST, SAN FRANCISCO, CA, 94109 CALIFORNIA ST 3 Nob Hill CENTRAL 37.791038513184 -122.41797637939501 POINT (-122.41797638 37.79103851) Phone   16 6 3 21 10 5 1 28,858 1 21 21   16   3             1         16
666956 666956 250134 2008-07-18T11:57:27 2008-07-21T08:04:58 2008-07-21T08:04:58 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1237 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.774394989014 -122.41056060791 POINT (-122.41056061 37.77439499) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10             2         32
683514 683514 250231 2008-07-18T13:38:43 2008-07-21T08:04:58 2008-07-21T08:04:58 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1178 FULTON ST, SAN FRANCISCO, CA, 94117 FULTON ST 5 Alamo Square NORTHERN 37.777236938477 -122.436073303223 POINT (-122.4360733 37.77723694) Phone   23 4 11 39 11 15 8 29,492 5 41 41   23   11             1         23
674597 674597 242066 2008-07-03T16:00:16 2008-07-21T09:04:47 2008-07-21T09:04:47 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of FILBERT ST and KEARNY ST FILBERT ST 3 Telegraph Hill CENTRAL 37.801765441895 -122.406288146973 POINT (-122.40628815 37.80176544) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     2         18
689030 689030 249487 2008-07-17T15:11:57 2008-07-21T09:04:48 2008-07-21T09:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of FILBERT ST and KEARNY ST FILBERT ST 3 Telegraph Hill CENTRAL 37.801765441895 -122.406288146973 POINT (-122.40628815 37.80176544) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     2         18
698652 698652 242884 2008-07-05T19:09:49 2008-07-21T09:04:48 2008-07-21T09:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1900 GOUGH ST, SAN FRANCISCO, CA, 94109 GOUGH ST 2 Pacific Heights NORTHERN 37.791160583496 -122.42569732666 POINT (-122.42569733 37.79116058) Phone   102 4 6 30 1 13 6 28,858 9 27 27   102   6             1         102
705173 705173 243667 2008-07-07T13:02:39 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 - Damaging_Property 2 Hitting_window_or_building Intersection of BUSH ST and POWELL ST BUSH ST 3 Downtown / Union Square CENTRAL 37.790161132813 -122.40878295898399 POINT (-122.40878296 37.79016113) Phone   16 6 3 21 10 5 1 28,857 1 21 21   16   3         5   1         16
727416 727416 243751 2008-07-07T15:17:31 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 - Overgrown_Tree 3 Near_communication_line 223 26TH AVE, SAN FRANCISCO, CA, 94121 26TH AVE 2 Lake Street RICHMOND 37.785205841064 -122.486328125 POINT (-122.48632813 37.78520584) Phone   2 8 6 29 1 11 9 55 6 26 26   2   6             2         2
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
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
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
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
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
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
776342 776342 248106 2008-07-15T15:45:27 2008-07-21T11:04:34 2008-07-21T11:04:34 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of 16TH ST and DOLORES ST 16TH ST 8 Mission Dolores MISSION 37.764644622803004 -122.42638397216801 POINT (-122.42638397 37.76464462) Phone   37 3 5 5 5 8 7 28,859 4 3 3   37   5             1   5     37
709505 709505 248104 2008-07-15T15:41:53 2008-07-21T11:04:35 2008-07-21T11:04:35 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 2929 24TH ST, SAN FRANCISCO, CA, 94110 24TH ST 9 Mission MISSION 37.752586364746 -122.41063690185499 POINT (-122.4106369 37.75258636) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2   10 3       1   3     53
795801 795801 249059 2008-07-17T08:30:13 2008-07-21T11:04:35 2008-07-21T11:04:35 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 1524 CHURCH ST, SAN FRANCISCO, CA, 94131 CHURCH ST 8 Noe Valley INGLESIDE 37.746429443359 -122.427085876465 POINT (-122.42708588 37.74642944) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
678981 678981 249277 2008-07-17T11:34:29 2008-07-21T11:04:36 2008-07-21T11:04:36 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1993 ALEMANY BLVD, SAN FRANCISCO, CA, 94112 ALEMANY BLVD 11 Cayuga INGLESIDE 37.720264434814 -122.439254760742 POINT (-122.43925476 37.72026443) Phone   80 9 1 28 6 9 4 28,861 7 25 25   80   1             2         80
729584 729584 249555 2008-07-17T16:34:26 2008-07-21T11:04:36 2008-07-21T11:04:36 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of ARGENT ALY and MARKET ST ARGENT ALY 8 Upper Market MISSION 37.753040313721 -122.442665100098 POINT (-122.4426651 37.75304031) Phone   51 3 5 38 5 2 7 63 4 38 38   51   5             1         51
748518 748518 249614 2008-07-17T17:37:56 2008-07-21T11:04:36 2008-07-21T11:04:36 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 18TH ST and VALENCIA ST 18TH ST 9 Mission MISSION 37.761699676514 -122.421577453613 POINT (-122.42157745 37.76169968) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
750709 750709 249178 2008-07-17T10:12:54 2008-07-21T11:04:36 2008-07-21T11:04:36 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 105 PERSIA AVE, SAN FRANCISCO, CA, 94112 PERSIA AVE 11 Excelsior INGLESIDE 37.722751617431996 -122.434951782227 POINT (-122.43495178 37.72275162) Phone   90 9 1 7 6 9 4 28,861 7 5 5 4 90   1 4           2         90
780376 780376 250078 2008-07-18T11:17:17 2008-07-21T11:04:36 2008-07-21T11:04:36 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 97 SAN JUAN AVE, SAN FRANCISCO, CA, 94112 SAN JUAN AVE 11 Mission Terrace INGLESIDE 37.724552154541 -122.43693542480499 POINT (-122.43693542 37.72455215) Phone   94 9 1 28 6 9 4 28,861 7 25 25   94   1             1         94
667168 667168 250801 2008-07-19T19:41:29 2008-07-21T11:04:37 2008-07-21T11:04:37 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of 24TH ST and MISSION ST 24TH ST 9 Mission MISSION 37.752239227295 -122.418441772461 POINT (-122.41844177 37.75223923) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3 51   53
746562 746562 250713 2008-07-19T15:11:28 2008-07-21T11:04:37 2008-07-21T11:04:37 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 21ST ST and DOLORES ST 21ST ST 8 Dolores Heights MISSION 37.756629943848 -122.42561340331999 POINT (-122.4256134 37.75662994) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
775914 775914 250727 2008-07-19T15:48:26 2008-07-21T11:04:37 2008-07-21T11:04:37 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights Intersection of 21ST ST and BRYANT ST 21ST ST 9 Mission MISSION 37.757595062255994 -122.40959167480499 POINT (-122.40959167 37.75759506) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
704230 704230 248286 2008-07-15T20:58:22 2008-07-21T15:04:12 2008-07-21T15:04:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 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
748608 748608 248214 2008-07-15T18:11:12 2008-07-21T15:04:12 2008-07-21T15:04:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 30 PARK ST, SAN FRANCISCO, CA, 94110 PARK ST 8 Holly Park INGLESIDE 37.736618041992 -122.425506591797 POINT (-122.42550659 37.73661804) Phone   61 9 5 2 5 2 4 28,859 7 2 2   61   5             1         61
740464 740464 250773 2008-07-19T18:00:07 2008-07-21T16:05:11 2008-07-21T16: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 23RD ST and CHURCH ST 23RD ST 8 Dolores Heights MISSION 37.75329208374 -122.42758178710899 POINT (-122.42758179 37.75329208) Phone   52 3 5 22 5 2 7 28,862 4 22 22   52   5             1         52
672150 672150 248713 2008-07-16T13:07:26 2008-07-22T06:04:51 2008-07-22T06:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 859 CAROLINA ST, SAN FRANCISCO, CA, 94107 CAROLINA ST 10 Potrero Hill BAYVIEW 37.757793426514 -122.399780273438 POINT (-122.39978027 37.75779343) Phone   54 2 9 26 8 10 3 28,856 3 29 29   54   9             1         54
661990 661990 251060 2008-07-20T18:12:23 2008-07-22T06:05:02 2008-07-22T06:05:02 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 655 CENTRAL AVE, SAN FRANCISCO, CA, 94117 CENTRAL AVE 5 Panhandle PARK 37.775581359863 -122.44483184814501 POINT (-122.44483185 37.77558136) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
740221 740221 251857 2008-07-21T20:56:58 2008-07-22T06:05:06 2008-07-22T06:05:06 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 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
663132 663132 247455 2008-07-14T14:39:38 2008-07-22T08:04:36 2008-07-22T08:04:36 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 2000 MCALLISTER ST, SAN FRANCISCO, CA, 94118 MCALLISTER ST 5 Western Addition PARK 37.777038574219 -122.44515991210899 POINT (-122.44515991 37.77703857) Phone   97 7 11 18 11 15 8 54 5 16 16   97   11             1         97
697692 697692 248360 2008-07-16T07:25:17 2008-07-22T08:04:37 2008-07-22T08:04:37 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 LARKIN ST and PINE ST LARKIN ST 3 Polk Gulch CENTRAL 37.78982925415 -122.418846130371 POINT (-122.41884613 37.78982925) Phone   50 6 3 21 10 13 6 28,858 9 21 21   50   3             1         50
759757 759757 248824 2008-07-16T15:21:21 2008-07-22T08:04:37 2008-07-22T08:04:37 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of KING ST and TOWNSEND ST KING ST 6 South Beach SOUTHERN 37.781856536865 -122.388084411621 POINT (-122.38808441 37.78185654) Phone   31 1 10 4 9 6 2 28,856 2 20 20   31   10             1         31
766284 766284 249486 2008-07-17T15:11:43 2008-07-22T08:04:38 2008-07-22T08:04:38 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs Intersection of 9TH ST and HOWARD ST 9TH ST 6 South of Market SOUTHERN 37.774990081787 -122.41316223144501 POINT (-122.41316223 37.77499008) Phone   32 1 10 34 9 8 2 28,853 2 34 34   32 1 10     1       2   1     32
692194 692194 250703 2008-07-19T14:58:43 2008-07-22T10:04:24 2008-07-22T10:04:24 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of SACRAMENTO ST and SANSOME ST SACRAMENTO ST 3 Financial District CENTRAL 37.79398727417 -122.401313781738 POINT (-122.40131378 37.79398727) Phone   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
708684 708684 250714 2008-07-19T15:12:37 2008-07-22T10:04:24 2008-07-22T10:04:24 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 450 SANSOME ST, SAN FRANCISCO, CA, 94111 SANSOME ST 3 Financial District CENTRAL 37.794631958008 -122.401298522949 POINT (-122.40129852 37.79463196) Phone   108 6 3 6 10 3 1 28,860 1 4 4   108   3             2         108
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
710203 710203 241872 2008-07-03T11:36:22 2008-07-22T13:05:19 2008-07-22T13:05:19 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 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
749136 749136 242611 2008-07-05T08:34:59 2008-07-22T13:05:20 2008-07-22T13:05:20 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Other_enter_additional_details_below 1150 FRANCISCO ST, SAN FRANCISCO, CA, 94109 FRANCISCO ST 2 Russian Hill NORTHERN 37.803359985352 -122.424125671387 POINT (-122.42412567 37.80335999) Phone   107 4 6 32 1 5 6 28,858 9 32 32   107   6             1         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
665705 665705 241220 2008-07-02T11:26:55 2008-07-22T14:05:11 2008-07-22T14:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree 1140 FOLSOM ST, SAN FRANCISCO, CA, 94103 FOLSOM ST 6 South of Market SOUTHERN 37.776149749755994 -122.40882110595699 POINT (-122.40882111 37.77614975) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
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
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
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
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
707404 707404 248796 2008-07-16T14:53:43 2008-07-22T15:05:09 2008-07-22T15:05:09 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 208 GLENVIEW DR, SAN FRANCISCO, CA, 94131 GLENVIEW DR 8 Midtown Terrace PARK 37.748313903809 -122.44686126709 POINT (-122.44686127 37.7483139) Phone   48 7 5 38 5 2 8 63 5 38 38   48   5             1         48
694964 694964 249525 2008-07-17T15:52:55 2008-07-22T15:05:10 2008-07-22T15:05:10 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request Intersection of CHULA LN and DOLORES ST CHULA LN 8 Mission Dolores MISSION 37.763969421387 -122.426315307617 POINT (-122.42631531 37.76396942) Phone   37 3 5 20 5 8 7 28,859 4 19 19   37   5             2   5     37
768160 768160 249531 2008-07-17T15:58:43 2008-07-22T15:05:10 2008-07-22T15: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 Intersection of CHULA LN and DOLORES ST CHULA LN 8 Mission Dolores MISSION 37.763969421387 -122.426315307617 POINT (-122.42631531 37.76396942) Phone   37 3 5 20 5 8 7 28,859 4 19 19   37   5             2   5     37
716796 716796 249650 2008-07-17T18:55:17 2008-07-22T15:05:11 2008-07-22T15:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 911 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 9 Mission MISSION 37.758247375488 -122.42106628418001 POINT (-122.42106628 37.75824738) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
766120 766120 250131 2008-07-18T11:51:20 2008-07-22T15:05:11 2008-07-22T15:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Damage_vandalism Intersection of 3RD AVE and GEARY BLVD 3RD AVE 1 Inner Richmond RICHMOND 37.781158447266 -122.461059570313 POINT (-122.46105957 37.78115845) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
792148 792148 249652 2008-07-17T18:59:10 2008-07-22T15:05:11 2008-07-22T15:05:11 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Tree_Other 4 Other 963 VALENCIA ST, SAN FRANCISCO, CA, 94110 VALENCIA ST 9 Mission MISSION 37.757518768311 -122.420997619629 POINT (-122.42099762 37.75751877) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
743595 743595 250140 2008-07-18T12:04:14 2008-07-22T15:05:12 2008-07-22T15:05:12 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Intersection of 8TH ST and FOLSOM ST 8TH ST 6 South of Market SOUTHERN 37.774990081787 -122.41006469726601 POINT (-122.4100647 37.77499008) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6     2   1     32
663667 663667 250347 2008-07-18T14:50:21 2008-07-22T15:05:13 2008-07-22T15:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 50 RIZAL ST, SAN FRANCISCO, CA, 94107 RIZAL ST 6 South of Market SOUTHERN 37.781764984130994 -122.399620056152 POINT (-122.39962006 37.78176498) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10         4   2         32
665946 665946 250214 2008-07-18T13:20:20 2008-07-22T15:05:13 2008-07-22T15:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris Intersection of CAMBRIDGE ST and TRUMBULL ST CAMBRIDGE ST 11 Mission Terrace INGLESIDE 37.73108291626 -122.421752929688 POINT (-122.42175293 37.73108292) Phone   94 9 1 7 6 9 4 28,861 7 5 5   94   1             2         94
703821 703821 250489 2008-07-18T17:03:43 2008-07-22T15:05:13 2008-07-22T15:05:13 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 4355 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 1 Inner Richmond RICHMOND 37.780628204346 -122.466049194336 POINT (-122.46604919 37.7806282) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
727344 727344 251965 2008-07-22T08:53:49 2008-07-22T15:05:17 2008-07-22T15:05:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Fallen_tree Intersection of 8TH ST and MISSION ST 8TH ST 6 South of Market SOUTHERN 37.777458190918004 -122.413154602051 POINT (-122.4131546 37.77745819) Phone   32 1 10 34 9 8 2 28,853 2 34 34 24 32 1 10 6   1 6 7 1 2 1 1     32
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
748808 748808 250825 2008-07-20T01:05:56 2008-07-22T18:04:46 2008-07-22T18:04:46 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 333 BAKER ST, SAN FRANCISCO, CA, 94117 BAKER ST 5 Panhandle PARK 37.774013519287 -122.441192626953 POINT (-122.44119263 37.77401352) Phone   24 7 11 18 11 15 8 29,492 5 16 16   24   11             1         24
698481 698481 251455 2008-07-21T11:40:25 2008-07-23T08:04:23 2008-07-23T08:04:23 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 201 ELSIE ST, SAN FRANCISCO, CA, 94110 ELSIE ST 9 Bernal Heights INGLESIDE 37.740898132324 -122.41886138916 POINT (-122.41886139 37.74089813) Phone   83 9 2 2 7 2 4 28,859 7 2 2   83   2             1         83
735476 735476 251689 2008-07-21T16:24:10 2008-07-23T08:04:25 2008-07-23T08: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 2445 HARRISON ST, SAN FRANCISCO, CA, 94110 HARRISON ST 9 Mission MISSION 37.758274078369006 -122.412254333496 POINT (-122.41225433 37.75827408) Phone   53 3 2 20 7 2 7 28,859 4 19 19   53   2     3       2   3     53
732233 732233 251411 2008-07-21T10:57:42 2008-07-23T09:04:17 2008-07-23T09:04:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        
743705 743705 251416 2008-07-21T11:02:09 2008-07-23T09:04:17 2008-07-23T09:04:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk 329 NORIEGA ST, SAN FRANCISCO, CA, 94122 NORIEGA ST 7 Golden Gate Heights TARAVAL 37.754505157471 -122.467239379883 POINT (-122.46723938 37.75450516) Phone   44 10 8 14 4 1 5 56 8 12 12   44   8             1         44
793849 793849 251402 2008-07-21T10:53:33 2008-07-23T09:04:17 2008-07-23T09:04:17 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_sidewalk Not associated with a specific address         0.0 0.0 POINT (0 0) Phone                                                        

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