trees

11,761 rows where qSpecies_id = 17 sorted by PlantType

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType ▼ qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
227 102275 Property Tree 8 Tree(s) :: 17 267 Topaz Way   Back Yard : Yard Landscaping Private 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
2598 95032 - 12 Tree(s) :: 17 211 Maynard St   Front Yard : Cutout Landscaping Private 2           6004772 2093802 37.7294517978782 -122.425783519869 (37.7294517978782, -122.425783519869) 9 7 6 28861 5
2857 99536 DPW Maintained 1 Tree(s) :: 17 188 Spear St 4 Sidewalk: Curb side : Cutout Landscaping Private 2       5x9   6014774.7 2116168.9 37.7914266467329 -122.392767069159 (37.7914266467329, -122.392767069159) 12 2 9 28855 6
3740 102276 DPW Maintained 1 Tree(s) :: 17 279 Topaz Way   Back Yard : Yard Landscaping Private 2           6001205.6 2097796.6 37.7402178594385 -122.438398959733 (37.7402178594385, -122.438398959733) 2 7 5 63 7
11448 96234 Permitted Site 7 Tree(s) :: 17     Sidewalk: Curb side : Cutout Landscaping Private 2   04/15/2011 12:00:00 AM     Permit Number 767856                    
11972 99201 DPW Maintained 1 Tree(s) :: 17 4016 26th St   Sidewalk: Curb side : Cutout Landscaping DPW 1 FUF 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855) 2 4 5 28862 22
12231 96231 Permitted Site 7 Tree(s) :: 17     Sidewalk: Curb side : Cutout Landscaping Private 2                              
15191 96232 Permitted Site 7 Tree(s) :: 17     Sidewalk: Curb side : Cutout Landscaping Private 2                              
18729 99529 DPW Maintained 1 Tree(s) :: 17 120 Howard St 3 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
29040 89138 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Curb side : Cutout Landscaping Private 2   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373 (37.7541940143569, -122.41572017373) 2 4 7 28859 19
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
50373 95369 - 12 Tree(s) :: 17 27 Hartford St   Front Yard : Cutout Landscaping Private 2   02/18/2011 12:00:00 AM       6002651 2105744 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968) 15 4 5 28862 3
54211 98502 Property Tree 8 Tree(s) :: 17 244 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
55462 94961 DPW Maintained 1 Tree(s) :: 17 3098 PACIFIC AVE 1 Sidewalk: Property side : Cutout Landscaping Private 2   10/25/2010 12:00:00 AM       5999362 2116697 37.792008575714 -122.446132526841 (37.792008575714, -122.446132526841) 13 6 1 29490 27
68093 106516 DPW Maintained 1 Tree(s) :: 17 366 Hill St   Sidewalk: Curb side : Cutout Landscaping Private 2   05/07/2014 12:00:00 AM   3X3 Permit Number 772751 6003996.2 2103381.7 37.7557115810688 -122.42914832014 (37.7557115810688, -122.42914832014) 2 4 5 28862 22
72279 103619 DPW Maintained 1 Tree(s) :: 17 1200 Monterey Blvd 1 Front Yard : Yard Landscaping Private 2           5994284.3 2094292 37.7301989768893 -122.462075764747 (37.7301989768893, -122.462075764747) 9 8 4 59 40
73650 99530 DPW Maintained 1 Tree(s) :: 17 120 Howard St 4 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
74831 181347 DPW Maintained 1 Tree(s) :: 17 2500 Sunset Blvd 69 Sidewalk: Property side : Yard Landscaping Private 2     6 Width 0ft   5985144.6465 2098114.9716 37.7401653859663 -122.493953920474 (37.7401653859663, -122.493953920474) 1 8 3 29491 35
86616 99531 DPW Maintained 1 Tree(s) :: 17 120 Howard St 5 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
88857 100242 DPW Maintained 1 Tree(s) :: 17 76 Linda St   Sidewalk: Curb side : Pot Landscaping Private 2           6005815 2105046 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568) 2 4 5 28859 19
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
91537 85195 DPW Maintained 1 Tree(s) :: 17 333 Eucalyptus Dr   Sidewalk: Property side : Cutout Landscaping Private 2           5990168 2094689 37.7310511825826 -122.476335191755 (37.7310511825826, -122.476335191755) 1 8 4 64 14
94087 96183 DPW Maintained 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout Landscaping Private 2           6007366 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618) 8 4 7 28853 19
94473 96289 DPW Maintained 1 Tree(s) :: 17 228 30th St   Sidewalk: Curb side : Cutout Landscaping Private 2         Permit Number 767877 6005120 2098458 37.7422557889482 -122.424911572967 (37.7422557889482, -122.424911572967) 2 7 5 63 22
99131 94962 DPW Maintained 1 Tree(s) :: 17 3098@Lyon Pacific Ave   Sidewalk: Property side : Cutout Landscaping Private 2   10/25/2010 12:00:00 AM       5999362 2116697.3 37.7920093994348 -122.446132548429 (37.7920093994348, -122.446132548429) 13 6 1 29490 27
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
115447 85273 DPW Maintained 1 Tree(s) :: 17 36 Santa Cruz Ave   Sidewalk: Property side : Cutout Landscaping Private 2           5993017.1 2086630.8 37.709090137513 -122.465900153218 (37.709090137513, -122.465900153218) 9 8 6 28861 25
119847 89137 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Curb side : Cutout Landscaping Private 2   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373 (37.7541940143569, -122.41572017373) 2 4 7 28859 19
120050 96291 DPW Maintained 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot Landscaping Private 2   03/21/2011 12:00:00 AM       6006773 2119090 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797) 5 9 1 28858 32
120956 99527 DPW Maintained 1 Tree(s) :: 17 120 Howard St 1 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
123690 98250 DPW Maintained 1 Tree(s) :: 17 650 Eddy St   Sidewalk: Curb side : Cutout Landscaping Private 2         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554) 7 9 9 28858 36
126618 89140 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Property side : Cutout Landscaping Private 2   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373 (37.7541940143569, -122.41572017373) 2 4 7 28859 19
127049 107717 DPW Maintained 1 Tree(s) :: 17 2400X 25th Ave 3 Sidewalk: Curb side : Cutout Landscaping Private 2 Port 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789 2098909 37.7423832554664 -122.491784477839 (37.7423832554664, -122.491784477839) 1 8 3 29491 35
129391 93160 DPW Maintained 1 Tree(s) :: 17 201 Upper Ter 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
129876 104375 DPW Maintained 1 Tree(s) :: 17 30 GARDENSIDE DR 1 Median : Yard Landscaping Private 2       50x50   5999465 2102094 37.7519183246276 -122.444726043725 (37.7519183246276, -122.444726043725) 2 5 5 63 38
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
138736 99533 DPW Maintained 1 Tree(s) :: 17 188 Spear St 1 Sidewalk: Curb side : Cutout Landscaping Private 2       5x9   6014774.7 2116168.9 37.7914266467329 -122.392767069159 (37.7914266467329, -122.392767069159) 12 2 9 28855 6
140484 92775 Permitted Site 7 Tree(s) :: 17 2701 Pacific Ave   Sidewalk: Curb side : Cutout Landscaping Private 2   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141) 13 6 1 29490 27
142477 89139 DPW Maintained 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Property side : Cutout Landscaping Private 2   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373 (37.7541940143569, -122.41572017373) 2 4 7 28859 19
144676 99532 DPW Maintained 1 Tree(s) :: 17 120 Howard St 6 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
152155 107078 DPW Maintained 1 Tree(s) :: 17 92 Homestead St   Sidewalk: Property side : Cutout Landscaping Private 2   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227) 2 4 5 28862 22
153433 104374 DPW Maintained 1 Tree(s) :: 17 22 GARDENSIDE DR 1 Median : Yard Landscaping Private 2       50x50   5999468 2101996 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009) 2 5 5 63 38
153742 96292 DPW Maintained 1 Tree(s) :: 17 1294 Union St   Sidewalk: Property side : Pot Landscaping Private 2   03/21/2011 12:00:00 AM       6006773 2119090 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797) 5 9 1 28858 32
159483 93161 DPW Maintained 1 Tree(s) :: 17 201 Upper Ter 2 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
160040 99534 DPW Maintained 1 Tree(s) :: 17 188 Spear St 2 Sidewalk: Curb side : Cutout Landscaping Private 2       5x9   6014774.7 2116168.9 37.7914266467329 -122.392767069159 (37.7914266467329, -122.392767069159) 12 2 9 28855 6
162713 96182 DPW Maintained 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout Landscaping Private 2   04/04/2011 12:00:00 AM     Permit Number 767813 6007366 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618) 8 4 7 28853 19
169278 5412 DPW Maintained 1 Tree(s) :: 17 414 Dolores St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   07/07/2008 12:00:00 AM   3x3   6004849.3785887 2105949.0211321 37.7628090992038 -122.426380541105 (37.7628090992038, -122.426380541105) 8 4 5 28859 3
170913 99535 DPW Maintained 1 Tree(s) :: 17 188 Spear St 3 Sidewalk: Curb side : Cutout Landscaping Private 2       5x9   6014774.7 2116168.9 37.7914266467329 -122.392767069159 (37.7914266467329, -122.392767069159) 12 2 9 28855 6
171678 107716 DPW Maintained 1 Tree(s) :: 17 2400X 25th Ave 2 Sidewalk: Curb side : Cutout Landscaping Private 2 Port 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789 2098909 37.7423832554664 -122.491784477839 (37.7423832554664, -122.491784477839) 1 8 3 29491 35
179378 99528 DPW Maintained 1 Tree(s) :: 17 120 Howard St 2 Sidewalk: Curb side : Cutout Landscaping Private 2       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069) 12 2 9 28855 6
186942 99610 DPW Maintained 1 Tree(s) :: 17 111 Corwin St   Unaccepted Street : Yard Landscaping Private 2           6000616 2104331 37.7581261988062 -122.44090619354 (37.7581261988062, -122.44090619354) 2 4 5 28862 38
188940 93162 DPW Maintained 1 Tree(s) :: 17 201 Upper Ter 3 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   3x3   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
191726 93936 DPW Maintained 1 Tree(s) :: 17 230 Seacliff Ave   Sidewalk: Curb side : Landscaping Private 2   04/26/2010 12:00:00 AM   37x6   5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212) 11 6 1 55 33
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
29 264952 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 2 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 1 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
74 106076 Permitted Site 7 Tree(s) :: 17 2500 Arelious Walker Dr 13 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
81 46536 Permitted Site 7 Tree(s) :: 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
99 255073 Private 9 Tree(s) :: 17 173R Glenview Dr   Back Yard : Yard Tree Private 2                              
108 44866 Permitted Site 7 Tree(s) :: 17   25 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38517                    
110 45916 Permitted Site 7 Tree(s) :: 17   51 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 Permitted Site 7 Tree(s) :: 17   5 Unaccepted Street : Yard Tree Private 2                              
112 33929 Permitted Site 7 Tree(s) :: 17   4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
115 121173 Significant Tree 6 Tree(s) :: 17 950 Duncan St 2 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
121 120916 Undocumented 4 Tree(s) :: 17 1430 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2016 12:00:00 AM 3 3x3 Permit Number 778800 5990886 2105639 37.7611586563939 -122.474651843595 (37.7611586563939, -122.474651843595) 1 8 4 56 12
129 107934 DPW Maintained 1 Tree(s) :: 17 3098X Market St 3 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
135 99586 Permitted Site 7 Tree(s) :: 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
139 106382 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 9 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
140 97920 Undocumented 4 Tree(s) :: 17 399X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6000685 2110085 37.7739291843989 -122.441080369401 (37.7739291843989, -122.441080369401) 15 5 11 29492 16
148 108238 Undocumented 4 Tree(s) :: 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree Private 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
162 105806 Undocumented 4 Tree(s) :: 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree Private 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
164 116129 Undocumented 4 Tree(s) :: 17 1601X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
167 99668 DPW Maintained 1 Tree(s) :: 17 150X Alma St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
169 258020 DPW Maintained 1 Tree(s) :: 17 1001X San Jose Ave 1 Side Yard : Yard Tree Private 2       3x3   6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
171 50655 Permitted Site 7 Tree(s) :: 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
180 110904 Significant Tree 6 Tree(s) :: 17 203 CORBETT AVE 1 Front Yard : Yard Tree Private 2     20 3x3   6000094 2105620 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122) 15 5 5 28862 3
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
194 112359 Undocumented 4 Tree(s) :: 17 1129 DOUGLASS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001379 2100423 37.7474391957634 -122.437987492815 (37.7474391957634, -122.437987492815) 2 4 5 63 22
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
198 102463 Undocumented 4 Tree(s) :: 17 3119 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6007346.2 2103903.1 37.7573322957921 -122.417599878082 (37.7573322957921, -122.417599878082) 2 4 7 28859 19
203 56596 Permitted Site 7 Tree(s) :: 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
205 61223 Permitted Site 7 Tree(s) :: 17 420 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1983 12:00:00 AM     Permit Number 21092 6011911.40369591 2116824.99897206 37.793068691891 -122.402720238707 (37.793068691891, -122.402720238707) 4 1 10 28854 6
207 251656 DPW Maintained 1 Tree(s) :: 17 31x Malta Dr 1 unknown : Yard Tree Private 2       3x3   5999423 2096089 37.7354276387403 -122.44443976141 (37.7354276387403, -122.44443976141) 9 7 4 63 40
220 64608 Permitted Site 7 Tree(s) :: 17 2449 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1988 12:00:00 AM     Permit Number 25511 6008240.06203716 2104170.72475134 37.75811738928 -122.414527478763 (37.75811738928, -122.414527478763) 2 4 7 28859 19
222 59632 Permitted Site 7 Tree(s) :: 17 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/1982 12:00:00 AM     Permit Number 19874 5999538.23629958 2110533.95574653 37.7750965176114 -122.445079484139 (37.7750965176114, -122.445079484139) 15 5 11 29492 16
223 65500 Permitted Site 7 Tree(s) :: 17 5322 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/1989 12:00:00 AM     Permit Number 28384 5990524.68926015 2112731.41132738 37.7806115451711 -122.47641956102 (37.7806115451711, -122.47641956102) 11 6 2 55 26
226 56655 Permitted Site 7 Tree(s) :: 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
233 100684 Undocumented 4 Tree(s) :: 17 400 California St 3 Sidewalk: Curb side : Pot Tree Private 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
241 57687 Permitted Site 7 Tree(s) :: 17 4124 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/1976 12:00:00 AM     Permit Number 16590 6001721.25492757 2103540.26074256 37.7560179062476 -122.437027141607 (37.7560179062476, -122.437027141607) 2 4 5 28862 3
260 56449 Permitted Site 7 Tree(s) :: 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
273 117070 Private 9 Tree(s) :: 17 6 JOY ST 3 Front Yard : Yard Tree Private 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
293 102283 Undocumented 4 Tree(s) :: 17 4428 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6000463 2102288 37.7525079029002 -122.441288746114 (37.7525079029002, -122.441288746114) 2 4 5 28862 22
294 53493 Permitted Site 7 Tree(s) :: 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/04/1969 12:00:00 AM     Permit Number 6403 5992228.28376051 2089608.56362168 37.717220822263 -122.468842940668 (37.717220822263, -122.468842940668) 9 8 6 64 24
297 113036 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
305 56460 Permitted Site 7 Tree(s) :: 17 2430 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006920.19744074 2104198.59660265 37.7581196808576 -122.419094125211 (37.7581196808576, -122.419094125211) 2 4 7 28859 19
307 99748 Undocumented 4 Tree(s) :: 17 4224 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002441 2100645 37.7481090922721 -122.434331041256 (37.7481090922721, -122.434331041256) 2 4 5 28862 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);