163,064 rows where qCaretaker_id = 2

View and edit SQL

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)
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
150 247856 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 80 Bradford St 5 Side Yard : Yard Tree Private 2     32     6009566.84713 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008) 10 7 7 28859 2
151 233915 DPW Maintained 1 Persea americana :: Avocado 34 998 York St 9 Sidewalk: Curb side : Yard Tree Private 2     1 Width 7ft   6009943.01185 2103432.65253 37.7561863328563 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
152 235666 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1301 Jessie St 4 : Tree Private 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
153 185313 DPW Maintained 1 Shrub :: Shrub 66 2601 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.494447317023 (37.7377379790483, -122.494447317023) 1 8 3 29491 35
155 142339 DPW Maintained 1 :: 45 516 Central Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999737.6235 2110265.9409 37.7743719952599 -122.444370497086 (37.7743719952599, -122.444370497086) 15 5 11 29492 16
156 222165 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 953 Elizabeth St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6000303.11526 2101951.8939 37.7515759277946 -122.441817532557 (37.7515759277946, -122.441817532557) 2 4 5 28862 22
157 114186 Undocumented 4 Shrub :: Shrub 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
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
159 117627 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree Private 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
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
165 104843 Permitted Site 7 :: 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
168 222969 DPW Maintained 1 Corymbia maculata :: Spotted Gum 69 1300 San Jose Ave 47 Front Yard : Yard Tree Private 2     16     6003392.92926 2095549.99469 37.7341733681018 -122.430675784084 (37.7341733681018, -122.430675784084) 2 7 5 63 7
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
170 108637 Property Tree 8 Pinus radiata :: Monterey Pine 15 15 TUCKER AVE   Back Yard : Yard Tree Private 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
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
174 113728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 5 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
175 184150 DPW Maintained 1 :: 45 1585 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982480.9001 2104357.3743 37.7571490682193 -122.503626084685 (37.7571490682193, -122.503626084685) 1 8 3 56 35
176 194490 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1501 22nd St 19 Front Yard : Yard Tree Private 2     29     6013346.63868 2103825.44695 37.7574548949481 -122.396842409144 (37.7574548949481, -122.396842409144) 10 3 8 28856 29
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
178 233603 DPW Maintained 1 Olea europaea :: Olive Tree 9 199 Franconia St 9 : Yard Tree Private 2     6 Width 3ft   6010152.72418 2099634.52308 37.7457692517475 -122.407592814071 (37.7457692517475, -122.407592814071) 2 7 7 28859 2
179 113995 DPW Maintained 1 :: 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
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
183 253381 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 899 Waller St 3 Side Yard : Yard Tree Private 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
185 184541 DPW Maintained 1 :: 45 1706 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984416.199 2103539.5001 37.7550170068332 -122.496872815694 (37.7550170068332, -122.496872815694) 1 8 3 56 35
188 112351 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
189 178694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree Private 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
191 244985 DPW Maintained 1 Olea europaea :: Olive Tree 9 1250 Haight St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6000147.9035 2108881.2284 37.7705933244615 -122.442851810939 (37.7705933244615, -122.442851810939) 15 5 11 29492 9
192 137920 DPW Maintained 1 :: 45 2028 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6002940.7431 2115305.2702 37.7883909617368 -122.433650548643 (37.7883909617368, -122.433650548643) 13 9 1 29490 27
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
197 104920 Undocumented 4 Washingtonia robusta :: Mexican Fan Palm 72 750 Gonzalez Dr 1 Median : Yard Tree Private 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
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
199 237529 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1197 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003874.24561 2101347.66783 37.7501197023675 -122.429425031242 (37.7501197023675, -122.429425031242) 2 4 5 28862 22
200 10663 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 963 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1992 12:00:00 AM 3 3x3   6003244.5235 2110652.1051 37.7756317694487 -122.432267067771 (37.7756317694487, -122.432267067771) 15 9 11 29492 10
201 229505 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Church St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6004360.58946 2103177.16015 37.7551705836636 -122.427873571204 (37.7551705836636, -122.427873571204) 2 4 5 28862 22
202 190636 DPW Maintained 1 Hakea suaveolens :: Sweet Hakea Tree 73 1 01st St 30 : Yard Tree Private 2     8     6014391.99798 2105898.86804 37.7632061898228 -122.393372206868 (37.7632061898228, -122.393372206868) 14 3 8 28856 29
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
208 107457 Undocumented 4 Prunus spp :: Cherry 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
209 138219 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 14 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5998675.4325 2112652.6916 37.7808647356786 -122.448216697429 (37.7808647356786, -122.448216697429) 15 6 2 54 16
211 196303 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 249 Shipley St 1 : Tree Private 2     1 Width 5ft   6011469.59111 2111688.37468 37.7789400547713 -122.403887319468 (37.7789400547713, -122.403887319468) 14 2 9 28856 34
212 138278 DPW Maintained 1 :: 45 2181 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6001737.3169 2113910.2795 37.7844923181381 -122.437714255164 (37.7844923181381, -122.437714255164) 13 6 11 29490 13
213 3891 DPW Maintained 1 Maytenus boaria :: Mayten 58 23 Castro St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6002162.16871 2108402.44463 37.7693933312702 -122.435850193556 (37.7693933312702, -122.435850193556) 15 5 5 29492 9
214 138888 DPW Maintained 1 :: 45 675 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004166.2354 2110619.5066 37.7755944800015 -122.429076315191 (37.7755944800015, -122.429076315191) 7 9 11 28852 10
217 105438 Undocumented 4 :: 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
218 181787 DPW Maintained 1 :: 45 2915 Ulloa St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5986983.636 2098224.4165 37.740573320949 -122.487603561386 (37.740573320949, -122.487603561386) 1 8 3 29491 35
219 131064 DPW Maintained 1 Maytenus boaria :: Mayten 58 1877 Greenwich St 1 : Tree Private 2     3 Width 4ft   6003926.06281 2119346.70194 37.7995435588443 -122.430529985984 (37.7995435588443, -122.430529985984) 13 9 1 57 17
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
221 182334 DPW Maintained 1 :: 45 1507 35th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5985257.4301 2104914.9526 37.758842875608 -122.494065007935 (37.758842875608, -122.494065007935) 1 8 3 56 35
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
224 183657 DPW Maintained 1 :: 45 1490 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981573.7378 2104946.7308 37.7587138957913 -122.506807059304 (37.7587138957913, -122.506807059304) 1 8 3 56 35
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
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
228 256437 Undocumented 4 Pinus radiata :: Monterey Pine 15 3001 Sunset Blvd 25 Median : Yard Tree Private 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
229 121402 Undocumented 4 :: 45 346X Duncan St 1 Back Yard : Yard Tree Private 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
230 114428 Undocumented 4 Pinus radiata :: Monterey Pine 15 34x HIGUERA AVE 2 Median : Yard Tree Private 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
232 228435 DPW Maintained 1 :: 45 178 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004070 2107898 37.7681164387884 -122.429215116616 (37.7681164387884, -122.429215116616) 7 9 5 28862 3
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
234 183167 DPW Maintained 1 :: 45 2422 45th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5982411.0498 2098597.3573 37.7413295619026 -122.503441142831 (37.7413295619026, -122.503441142831) 1 8 3 29491 35
235 184469 DPW Maintained 1 :: 45 2182 48th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5981423.7042 2100234.3036 37.7457660664858 -122.506976375045 (37.7457660664858, -122.506976375045) 1 8 3 29491 35
236 27345 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 664 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2008 12:00:00 AM 4 4x4   6004282.41706 2110648.93551 37.7756818605142 -122.428676512776 (37.7756818605142, -122.428676512776) 7 9 11 28852 10
237 15807 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 4959 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/1995 12:00:00 AM 6 3X3   6000887.014 2090089.1979 37.7190369816005 -122.438948290663 (37.7190369816005, -122.438948290663) 9 7 6 28861 5
239 205987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
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
242 184584 DPW Maintained 1 :: 45 1750 38th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5984424.998 2103256.5795 37.7542407008981 -122.496821507327 (37.7542407008981, -122.496821507327) 1 8 3 56 35
244 200570 DPW Maintained 1 :: 45 1445 La Salle Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6016341.8296 2095299.657 37.7342110910182 -122.385889477594 (37.7342110910182, -122.385889477594) 10 3 8 58 1
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
247 240348 DPW Maintained 1 Quercus suber :: Cork Oak 78 1201 San Jose Ave 26 Front Yard : Yard Tree Private 2     1     6004340.86769 2095971.00866 37.7353830362869 -122.427428442788 (37.7353830362869, -122.427428442788) 2 7 5 28861 2
250 248390 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 34 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998825.2199 2108039.7272 37.7682072798204 -122.447366392326 (37.7682072798204, -122.447366392326) 15 5 11 29492 9
251 187669 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 554 Valley St 1 Median : Yard Tree Private 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22
252 204152 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 900 Junipero Serra Blvd 37 : Tree Private 2     1 Width 0ft   5991169.92245 2090751.38969 37.7202975393725 -122.472584434247 (37.7202975393725, -122.472584434247) 9 8 4 64 40
253 200884 DPW Maintained 1 :: 45 1200 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6012817.0471 2107089.1245 37.7663867409086 -122.39890301604 (37.7663867409086, -122.39890301604) 14 3 8 28856 20
254 130309 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 95 Vallejo St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6013009.60555 2119229.44522 37.7997319839043 -122.399089221411 (37.7997319839043, -122.399089221411) 3 1 10 28860 6
255 118456 DPW Maintained 1 Myoporum laetum :: Myoporum 62 490 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5981010.56733 2112424.984 37.7792138173967 -122.509310094921 (37.7792138173967, -122.509310094921) 11 6 2 55 26
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
257 115298 Permitted Site 7 :: 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
258 139105 DPW Maintained 1 :: 45 1310 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5999792.0294 2113376.32 37.7829154028675 -122.444405875371 (37.7829154028675, -122.444405875371) 15 6 1 29490 31
259 196282 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1 25th St 13 : Yard Tree Private 2     12     6015015.25562 2102205.64875 37.7531000097757 -122.390958410295 (37.7531000097757, -122.390958410295) 10 3 8 28856 29
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
261 119280 Undocumented 4 Ficus nitida :: Laurel Fig 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
262 141330 DPW Maintained 1 :: 45 1314 HAYES ST 2 Sidewalk: Curb side : Pot Tree Private 2     0 Width 0ft   6001510.5734 2110463.2514 37.7750147569158 -122.438251682494 (37.7750147569158, -122.438251682494) 15 5 11 29492 10
264 103685 Undocumented 4 Prunus amygdalus :: Almond 80 901X SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
268 247892 DPW Maintained 1 :: 45 1283 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6000447.0072 2109223.9761 37.7715514711219 -122.441841814274 (37.7715514711219, -122.441841814274) 15 5 11 29492 9
269 194187 DPW Maintained 1 Olea europaea :: Olive Tree 9 1100 19th St 7 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6014241.14855 2105287.11165 37.7615180580268 -122.393851124637 (37.7615180580268, -122.393851124637) 10 3 8 28856 29
270 182815 DPW Maintained 1 :: 45 2111 Noriega St 2 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5987460.7639 2102999.1421 37.7537112584365 -122.486304306666 (37.7537112584365, -122.486304306666) 1 8 3 56 35
272 232035 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 39 Scott St 1 : Tree Private 2     5 Width 3ft   6002379.25876 2108512.04182 37.769706587622 -122.435107129612 (37.769706587622, -122.435107129612) 15 5 5 29492 9
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
274 232433 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 Church St 2 : Tree Private 2     7 Width 3ft   6004078.25972 2108290.75217 37.7691953086514 -122.429214555715 (37.7691953086514, -122.429214555715) 7 9 5 28862 3
275 193456 DPW Maintained 1 Malus :: Crab Apple 82 185 Hampshire St 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 5ft   6010023.67884 2107445.71101 37.76720979983 -122.40858996078 (37.76720979983, -122.40858996078) 8 4 8 28853 19
276 182945 DPW Maintained 1 :: 45 2691 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   5981809.5051 2096798.8146 37.7363558765881 -122.50538776138 (37.7363558765881, -122.50538776138) 1 8 3 29491 35
277 110381 Undocumented 4 Myoporum laetum :: Myoporum 62 2235 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       27x18   6011689 2097713 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204) 10 3 8 58 1
278 247719 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 12 Broderick St 1 : Tree Private 2     2 Width 3ft   6001402.47389 2108783.95066 37.770397668046 -122.438505276404 (37.770397668046, -122.438505276404) 15 5 11 29492 9
279 182423 DPW Maintained 1 :: 45 1539 25th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 0ft   5988365.4024 2104835.4768 37.7588060244513 -122.483310502266 (37.7588060244513, -122.483310502266) 1 8 3 56 35
281 136194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002528.73575 2118269.03723 37.7965053162169 -122.435288106477 (37.7965053162169, -122.435288106477) 13 9 1 57 17

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)
);