calls

80,878 rows where Category = 1 sorted by CaseID

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
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
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
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
747780 747780 240370 2008-07-01T09:36:10 2017-05-04T13:30:57 2017-05-04T13:30:57 Closed 2 320 dolores I am assuming they are referring to. The photos in the tree database show the sidewalk has been repaired. DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 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
745923 745923 240413 2008-07-01T10:06:52 2008-08-04T14:04:42 2008-08-04T14:04:42 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Vacant_lot_weeding Intersection of HOLLADAY AVE and PERALTA AVE HOLLADAY AVE 9 Peralta Heights INGLESIDE 37.748222351074 -122.40493774414101 POINT (-122.40493774 37.74822235) Phone   60 9 2 2 7 10 4 28,859 7 2 2   60   2     3       1   3 58   60
757035 757035 240420 2008-07-01T10:11:09 2008-07-25T12:04:50 2008-07-25T12:04:50 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_signs 555 BATTERY ST, SAN FRANCISCO, CA, 94111 BATTERY ST 3 North Beach CENTRAL 37.796337127686 -122.40072631835899 POINT (-122.40072632 37.79633713) Phone   106 6 3 6 10 3 1 28,860 1 4 4   106   3             2         106
691122 691122 240422 2008-07-01T10:13:30 2008-07-25T12:04:51 2008-07-25T12:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 630 SANSOME ST, SAN FRANCISCO, CA, 94111 SANSOME ST 3 North Beach CENTRAL 37.796573638916 -122.401504516602 POINT (-122.40150452 37.79657364) Phone   106 6 3 6 10 3 1 28,860 1 4 4   106   3             2         106
728178 728178 240455 2008-07-01T10:42:33 2008-07-25T12:04:51 2008-07-25T12:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_traffic_signal Intersection of 2ND ST and KING ST 2ND ST 6 South Beach SOUTHERN 37.779861450195 -122.38958740234399 POINT (-122.3895874 37.77986145) Phone   31 1 10 4 9 6 2 28,856 2 20 20   31   10             1         31
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
730965 730965 240467 2008-07-01T10:52:00 2008-08-04T14:04:42 2008-08-04T14:04:42 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of SUNSET BLVD and TARAVAL ST SUNSET BLVD 4 Parkside TARAVAL 37.742225646973 -122.49444580078101 POINT (-122.4944458 37.74222565) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
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
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
755144 755144 240584 2008-07-01T12:26:55 2008-07-31T15:04:48 2008-07-31T15:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of MOSCOW ST and PERSIA AVE MOSCOW ST 11 Excelsior INGLESIDE 37.719711303711 -122.42880249023399 POINT (-122.42880249 37.7197113) Phone   90 9 1 7 6 9 4 28,861 7 5 5   90   1             2         90
796197 796197 240614 2008-07-01T12:53:00 2008-08-04T14:04:43 2008-08-04T14:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Other Intersection of PRINCETON ST and SILVER AVE PRINCETON ST 9 University Mound BAYVIEW 37.72891998291 -122.416175842285 POINT (-122.41617584 37.72891998) Phone   92 2 2 25 7 9 3 309 3 28 28   92   2             2         92
691748 691748 240618 2008-07-01T12:58:11 2008-07-31T15:04:48 2008-07-31T15:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of STONEYBROOK AVE and TRUMBULL ST STONEYBROOK AVE 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
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
780277 780277 240631 2008-07-01T13:09:28 2008-08-04T14:04:43 2008-08-04T14:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall Intersection of SANTIAGO ST and SUNSET BLVD SANTIAGO ST 4 Parkside TARAVAL 37.744091033936 -122.494575500488 POINT (-122.4945755 37.74409103) Phone   39 10 7 35 3 1 5 29,491 8 35 35   39   7             1         39
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
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
791000 791000 240800 2008-07-01T16:33:33 2008-08-04T14:04:43 2008-08-04T14:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 51 LAKESHORE DR, SAN FRANCISCO, CA, 94132 LAKESHORE DR 7 Lakeshore TARAVAL 37.731044769287 -122.494354248047 POINT (-122.49435425 37.73104477) Phone   43 10 8 35 4 1 5 64 8 35 35   43   8             1         43
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
664066 664066 241039 2008-07-02T08:18:08 2008-08-04T14:04:43 2008-08-04T14:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 1235 FELL ST, SAN FRANCISCO, CA, 94117 FELL ST 5 Panhandle PARK 37.773830413818004 -122.438430786133 POINT (-122.43843079 37.77383041) Phone   24 7 11 9 11 15 8 29,492 5 10 10   24   11             1         24
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
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
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
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                                                        
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
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
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
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
665181 665181 241323 2008-07-02T13:11:27 2009-03-12T05:10:11 2009-03-12T05:10:11 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Tree_Other 4 Other 201 BELLA VISTA WAY, SAN FRANCISCO, CA, 94127 BELLA VISTA WAY 7 Miraloma Park INGLESIDE 37.737892150879 -122.449600219727 POINT (-122.44960022 37.73789215) Phone   72 9 8 41 4 9 4 59 7 40 40   72   8             1         72
691100 691100 241329 2008-07-02T13:14:28 2008-08-04T14:04:43 2008-08-04T14:04:43 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding 675 MONTEREY BLVD, SAN FRANCISCO, CA, 94112 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731369018555 -122.45055389404301 POINT (-122.45055389 37.73136902) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
747219 747219 241333 2008-07-02T13:16:41 2008-08-01T09:04:48 2008-08-01T09:04:48 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Remove_garden_debris 695 MONTEREY BLVD, SAN FRANCISCO, CA, 94112 MONTEREY BLVD 7 Sunnyside INGLESIDE 37.731369018555 -122.45086669921899 POINT (-122.4508667 37.73136902) Phone   95 9 8 41 4 9 4 59 7 40 40   95   8             1         95
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
792483 792483 241376 2008-07-02T13:52:32 2009-03-06T05:10:05 2009-03-06T05:10:05 Closed 2   DPW BSM Queue 3 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 641 LAKE ST, SAN FRANCISCO, CA, 94118 LAKE ST 1 Presidio Terrace RICHMOND 37.786460876465 -122.46630859375 POINT (-122.46630859 37.78646088) Phone   4 8 4 11 2 11 9 54 6 11 11   4   4             1         4
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
768209 768209 241459 2008-07-02T15:16:55 2010-07-12T10:16:59 2010-07-12T10:16:59 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots Intersection of RETIRO WAY and RICO WAY RETIRO WAY 2 Marina NORTHERN 37.804927825928004 -122.43814086914101 POINT (-122.43814087 37.80492783) Phone   17 4 6 13 1 13 6 57 9 17 17   17   6             1         17
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
752349 752349 241538 2008-07-02T16:47:08 2010-06-25T11:16:56 2010-06-25T11:16:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb Intersection of ELLIS ST and WEBSTER ST ELLIS ST 5 Western Addition NORTHERN 37.782569885254 -122.430801391602 POINT (-122.43080139 37.78256989) Phone   97 4 11 39 11 15 6 29,490 9 41 41 8 97   11 9     9     2         97
798154 798154 241571 2008-07-02T17:54:07 2010-10-21T12:09:32 2010-10-21T12:09:32 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Blocking_street_lights 4228 GEARY BLVD, SAN FRANCISCO, CA, 94118 GEARY BLVD 1 Inner Richmond RICHMOND 37.781173706055 -122.464950561523 POINT (-122.46495056 37.78117371) Phone   5 8 4 11 2 11 9 54 6 11 11   5   4             1         5
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
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
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
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
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
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
767009 767009 241909 2008-07-03T12:38:04 2010-06-25T11:16:56 2010-06-25T11:16:56 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of 29TH ST and DOLORES ST 29TH ST 8 Noe Valley INGLESIDE 37.743839263916 -122.424385070801 POINT (-122.42438507 37.74383926) Phone   84 9 5 22 5 2 4 63 7 22 22   84   5             1         84
730558 730558 241925 2008-07-03T12:55:41 2008-07-26T16:04:46 2008-07-26T16:04:46 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree 2925 PINE ST, SAN FRANCISCO, CA, 94115 PINE ST 2 Lower Pacific Heights RICHMOND 37.786506652831996 -122.444007873535 POINT (-122.44400787 37.78650665) Phone   103 8 6 31 1 15 9 29,490 6 31 31   103   6             1         103
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
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
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
671072 671072 241941 2008-07-03T13:24:07 2010-08-16T15:19:05 2010-08-16T15:19:05 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Lifted_sidewalk_tree_roots 1901 SUTTER ST, SAN FRANCISCO, CA, 94115 SUTTER ST 5 Japantown NORTHERN 37.785743713379 -122.432334899902 POINT (-122.4323349 37.78574371) Phone   101 4 11 15 11 13 6 29,490 9 13 13   101   11   24         2         101
691301 691301 241948 2008-07-03T13:32:23 2008-07-26T16:04:46 2008-07-26T16:04:46 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Restake_tree Intersection of FRANKLIN ST and FULTON ST FRANKLIN ST 5 Civic Center NORTHERN 37.778957366943004 -122.42170715331999 POINT (-122.42170715 37.77895737) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
790468 790468 241951 2008-07-03T13:37:22 2008-07-26T16:04:46 2008-07-26T16:04:46 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Dead_tree Intersection of FRANKLIN ST and FULTON ST FRANKLIN ST 5 Civic Center NORTHERN 37.778957366943004 -122.42170715331999 POINT (-122.42170715 37.77895737) Phone   21 4 11 9 11 7 6 28,852 9 10 10   21 1 11     1   8   1   1     21
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
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
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
752855 752855 242328 2008-07-04T11:11:15 2008-08-14T13:04:51 2008-08-14T13:04:51 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Pruning_request 525 5TH ST, SAN FRANCISCO, CA, 94107 5TH ST 6 South of Market SOUTHERN 37.777721405029 -122.399803161621 POINT (-122.39980316 37.77772141) Phone   32 1 10 34 9 6 2 28,856 2 34 34   32   10             2         32
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
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
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
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
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
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
762759 762759 242671 2008-07-05T11:19:06 2008-09-08T16:22:59 2008-09-08T16:22:59 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues 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
772269 772269 242745 2008-07-05T13:23:28 2008-08-13T11:35:46 2008-08-13T11:35:46 Closed 2 Case is Invalid CLOSED BACK AFTER NOTATION. DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Weeding Intersection of LAMARTINE ST and STILL ST LAMARTINE ST 8 Mission Terrace INGLESIDE 37.731334686279 -122.43337249755899 POINT (-122.4333725 37.73133469) Phone   94 9 5 28 5 9 4 28,861 7 25 25   94   5             1         94
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
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
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
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
752546 752546 242921 2008-07-05T22:41:40 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 Weeding 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
703854 703854 243046 2008-07-06T11:57:07 2008-08-07T06:04:25 2008-08-07T06:04:25 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 Hanging_limb 1 TELEGRAPH HILL BLVD, SAN FRANCISCO, CA, 94133 TELEGRAPH HILL BLVD 3 Telegraph Hill CENTRAL 37.802780151367 -122.40576934814501 POINT (-122.40576935 37.80278015) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23     23     1         18
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
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
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                                                        
779961 779961 243336 2008-07-07T07:45:48 2008-08-08T06:04:24 2008-08-08T06:04:24 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Landscaping 5 Sprinkler_system_issues Intersection of EL PLAZUELA WAY and JUNIPERO SERRA BLVD EL PLAZUELA WAY 7 Ingleside Terraces TARAVAL 37.727626800537 -122.47165679931601 POINT (-122.4716568 37.7276268) Phone   67 10 8 41 4 9 5 59 8 40 40   67   8             1         67
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
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
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
706139 706139 243487 2008-07-07T10:31:21 2008-08-14T13:04:52 2008-08-14T13:04:52 Closed 2 See Notes tab for more details DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaged_Tree 1 About_to_fall 300 FILBERT ST, SAN FRANCISCO, CA, 94133 FILBERT ST 3 Telegraph Hill CENTRAL 37.802040100098 -122.40480804443399 POINT (-122.40480804 37.8020401) Phone   18 6 3 23 10 3 1 308 1 23 23 21 18   3 23           1         18
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
719096 719096 243546 2008-07-07T11:21:19 2008-08-14T13:04:52 2008-08-14T13:04:52 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
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
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
724394 724394 243715 2008-07-07T14:06:04 2008-10-01T08:07:11 2008-10-01T08:07:11 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Damaging_Property 2 Property_damage 1255 SILVER AVE, SAN FRANCISCO, CA, 94134 SILVER AVE 9 Portola BAYVIEW 37.730667114258 -122.411514282227 POINT (-122.41151428 37.73066711) 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
751524 751524 243749 2008-07-07T15:14:07 2010-07-06T15:16:57 2010-07-06T15:16:57 Closed 2   DPW Ops Queue 1 Tree Maintenance 1 Trees - Overgrown_Tree 3 Near_communication_line 2043 PALOU AVE, SAN FRANCISCO, CA, 94124 PALOU AVE 10 Silver Terrace BAYVIEW 37.738552093505994 -122.399269104004 POINT (-122.3992691 37.73855209) Phone   87 2 9 1 8 10 3 58 3 1 1   87   9             2         87
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
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
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
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

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