Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179168 | 179168 | 247007 | Undocumented 2 | Callistemon salignus :: White flowering bottlebrush 557 | 401 Valley St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003259.67301 | 2099184.77085 | 37.744146077987 | -122.431395876644 | (37.744146077987, -122.431395876644) | |||
| 63830 | 63830 | 197460 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012999.02284 | 2095922.1714 | 37.7357348294881 | -122.39749034641501 | (37.7357348294881, -122.397490346415) | ||||
| 157896 | 157896 | 197461 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013002.43415 | 2095918.1263700002 | 37.7357239126183 | -122.397478268512 | (37.7357239126183, -122.397478268512) | ||||
| 158584 | 158584 | 197462 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013004.79745 | 2095911.61797 | 37.7357061734926 | -122.397469641308 | (37.7357061734926, -122.397469641308) | ||||
| 169281 | 169281 | 197459 | Undocumented 2 | Salix discolor :: Pussy Willow 437 | 1999 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6012989.149119999 | 2095915.1657 | 37.73571504351771 | -122.397523992755 | (37.7357150435177, -122.397523992755) | ||||
| 43066 | 43066 | 195953 | Undocumented 2 | Populus alba :: White Poplar 408 | 1599 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6012519.43639 | 2096471.57125 | 37.737216651423296 | -122.39918702716999 | (37.7372166514233, -122.39918702717) | ||||
| 43664 | 43664 | 120267 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 100 24th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988369.5187800005 | 2115107.91648 | 37.7870115292654 | -122.48404955627501 | (37.7870115292654, -122.484049556275) | ||||
| 173508 | 173508 | 247008 | Undocumented 2 | Callistemon 'Jeffers' :: Purple bottlebrush 395 | 401 Valley St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 8ft | 6003270.60035 | 2099185.34055 | 37.74414826155 | -122.43135813298599 | (37.74414826155, -122.431358132986) | |||
| 162388 | 162388 | 239565 | Undocumented 2 | Schefflera species :: Umbrella tree 386 | 198 Corbin Pl | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6000083.996040001 | 2105681.3583 | 37.761803635962295 | -122.44284305286101 | (37.7618036359623, -122.442843052861) | |||
| 66256 | 66256 | 221653 | Undocumented 2 | Acer circinatum :: Vine Maple 379 | 198 Corbin Pl | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6000080.29991 | 2105696.606 | 37.761845291655895 | -122.44285693122801 | (37.7618452916559, -122.442856931228) | |||
| 37839 | 37839 | 239036 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3911 21st St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6002387.68734 | 2103532.26119 | 37.75603379883479 | -122.43472182765801 | (37.7560337988348, -122.434721827658) | ||||
| 64839 | 64839 | 239037 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3911 21st St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6002388.77933 | 2103534.57817 | 37.756040222701294 | -122.434718216874 | (37.7560402227013, -122.434718216874) | ||||
| 165261 | 165261 | 179181 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 287 Hester Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6012224.031 | 2087775.33367 | 37.7133220954184 | -122.399597997574 | (37.7133220954184, -122.399597997574) | ||||
| 30197 | 30197 | 196336 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 1750 22nd St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6012821.16046 | 2103795.98592 | 37.757344738798 | -122.398657667323 | (37.757344738798, -122.398657667323) | ||||
| 25721 | 25721 | 190755 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1999 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6012974.9721800005 | 2095942.04055 | 37.7357880468688 | -122.397574892566 | (37.7357880468688, -122.397574892566) | ||||
| 148916 | 148916 | 188810 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 1499 Rankin St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 5ft | 6012693.20045 | 2096700.71926 | 37.737855526197706 | -122.39860231674801 | (37.7378555261977, -122.398602316748) | |||
| 167037 | 167037 | 221195 | Undocumented 2 | Bambusa spp :: Bamboo Species 346 | 200 Saint Marys Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 7ft | 6003941.6017 | 2095959.6325400001 | 37.7353292100649 | -122.428808043276 | (37.7353292100649, -122.428808043276) | |||
| 170593 | 170593 | 247004 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 401 Valley St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 6003237.98739 | 2099191.84637 | 37.7441642766696 | -122.43147136571501 | (37.7441642766696, -122.431471365715) | |||
| 181323 | 181323 | 189132 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 1750 22nd St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012850.6766099995 | 2103796.49604 | 37.7573477838995 | -122.398555623956 | (37.7573477838995, -122.398555623956) | ||||
| 157067 | 157067 | 218988 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1510 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5991201.1182 | 2105012.79044 | 37.759457505289504 | -122.47351631712 | (37.7594575052895, -122.47351631712) | ||||
| 72539 | 72539 | 196368 | Undocumented 2 | Prunus persica :: Peach 330 | 1700 Armstrong Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013900.47248 | 2092876.9434099998 | 37.727423406648995 | -122.394160532785 | (37.727423406649, -122.394160532785) | ||||
| 75164 | 75164 | 237968 | Undocumented 2 | Prunus persica :: Peach 330 | 200 Saint Marys Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 2ft | 6003940.67465 | 2095963.2417 | 37.7353390675306 | -122.428811505646 | (37.7353390675306, -122.428811505646) | |||
| 170275 | 170275 | 196369 | Undocumented 2 | Prunus persica :: Peach 330 | 1499 Rankin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | Width 3ft | 6012673.95486 | 2096676.86192 | 37.7377889466986 | -122.39866718483499 | (37.7377889466986, -122.398667184835) | |||
| 29484 | 29484 | 190646 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 230 Middle Point Rd | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 6018218.4425 | 2096359.44868 | 37.7372247426365 | -122.379474956329 | (37.7372247426365, -122.379474956329) | |||
| 160229 | 160229 | 120264 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 100 24th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5988352.12015 | 2115168.07199 | 37.787175686198 | -122.48411416398301 | (37.787175686198, -122.484114163983) | ||||
| 158153 | 158153 | 208909 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 747 Detroit St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999437.80886 | 2095432.36155 | 37.7336255092046 | -122.44434138813801 | (37.7336255092046, -122.444341388138) | ||||
| 165040 | 165040 | 131051 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1285 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006739.62065 | 2119756.87873 | 37.8008287835889 | -122.42082318315701 | (37.8008287835889, -122.420823183157) | ||||
| 166855 | 166855 | 129091 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 200 Spruce St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 5997131.25122 | 2115563.65608 | 37.78876907367739 | -122.45376901623399 | (37.7887690736774, -122.453769016234) | |||
| 31310 | 31310 | 249769 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 295 Kearny St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6010840.59654 | 2120830.53405 | 37.8040070713206 | -122.40670772380399 | (37.8040070713206, -122.406707723804) | |||
| 46389 | 46389 | 248236 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 298 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006718.26384 | 2099043.39902 | 37.743953311000396 | -122.419426777927 | (37.7439533110004, -122.419426777927) | ||||
| 49584 | 49584 | 178353 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 648 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6005050.25442 | 2092601.27902 | 37.7261706033722 | -122.42473618194599 | (37.7261706033722, -122.424736181946) | ||||
| 138040 | 138040 | 248089 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010641.03165 | 2100300.14916 | 37.7476242374868 | -122.405951190707 | (37.7476242374868, -122.405951190707) | ||||
| 156767 | 156767 | 248090 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010640.27543 | 2100283.5284 | 37.74757855821579 | -122.40595263501001 | (37.7475785582158, -122.40595263501) | ||||
| 160690 | 160690 | 118626 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 499 46th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 10ft | 5981578.2503 | 2112431.17888 | 37.7792642811872 | -122.507346739716 | (37.7792642811872, -122.507346739716) | |||
| 173872 | 173872 | 211287 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1549 15th Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5991543.24459 | 2104910.37541 | 37.759196107445796 | -122.472325621056 | (37.7591961074458, -122.472325621056) | ||||
| 188376 | 188376 | 248091 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010638.35138 | 2100271.0907099997 | 37.747544299426295 | -122.405958412248 | (37.7475442994263, -122.405958412248) | ||||
| 187659 | 187659 | 203390 | Undocumented 2 | Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 305 | 747 Detroit St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999418.77768 | 2095445.8952400002 | 37.733661583696396 | -122.44440815651899 | (37.7336615836964, -122.444408156519) | ||||
| 59021 | 59021 | 247993 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 260 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6009745.41433 | 2099623.13704 | 37.7457151800111 | -122.409000435623 | (37.7457151800111, -122.409000435623) | ||||
| 166987 | 166987 | 247992 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 260 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009735.72559 | 2099644.7711400003 | 37.7457740397574 | -122.40903546421998 | (37.7457740397574, -122.40903546422) | ||||
| 46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
| 64022 | 64022 | 136289 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006495.00775 | 2121066.48783 | 37.80441084625 | -122.42176272108101 | (37.80441084625, -122.421762721081) | ||||
| 147910 | 147910 | 136288 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6006500.63968 | 2121061.90297 | 37.804398574988205 | -122.421742905414 | (37.8043985749882, -122.421742905414) | ||||
| 54275 | 54275 | 197067 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1700 Armstrong Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013902.76145 | 2092874.5647599997 | 37.7274170025835 | -122.394152453295 | (37.7274170025835, -122.394152453295) | ||||
| 164552 | 164552 | 197065 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1750 22nd St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012833.7263400005 | 2103797.94864 | 37.7573508280876 | -122.398614346997 | (37.7573508280876, -122.398614346997) | ||||
| 53325 | 53325 | 247883 | Undocumented 2 | Quercus rubra :: Red Oak 285 | 387 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009924.04752 | 2098397.97998 | 37.7423611710447 | -122.408296348302 | (37.7423611710447, -122.408296348302) | ||||
| 133366 | 133366 | 247524 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 1101 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6000021.13855 | 2108488.5030900002 | 37.769507771781704 | -122.44326207937901 | (37.7695077717817, -122.443262079379) | ||||
| 37065 | 37065 | 190085 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012534.55717 | 2096576.85892 | 37.7375065919613 | -122.399142135727 | (37.7375065919613, -122.399142135727) | ||||
| 47514 | 47514 | 225238 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3911 21st St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6002335.3278 | 2103527.7741799997 | 37.7560185058709 | -122.434902583282 | (37.7560185058709, -122.434902583282) | ||||
| 52971 | 52971 | 126040 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2390 Bay St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.801529357251205 | -122.446341287942 | (37.8015293572512, -122.446341287942) | |||
| 62955 | 62955 | 190086 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012527.48639 | 2096566.74721 | 37.73747843327921 | -122.399165873323 | (37.7374784332792, -122.399165873323) | ||||
| 154273 | 154273 | 190078 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6013893.72787 | 2092886.08627 | 37.7274481362093 | -122.394184488917 | (37.7274481362093, -122.394184488917) | ||||
| 167249 | 167249 | 190082 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6013888.29247 | 2092890.0974700002 | 37.7274588480349 | -122.39420355996401 | (37.7274588480349, -122.394203559964) | ||||
| 179179 | 179179 | 225241 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 301 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6004065.1857199995 | 2097137.17926 | 37.7385694799892 | -122.428464673104 | (37.7385694799892, -122.428464673104) | ||||
| 179275 | 179275 | 225250 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 200 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6000060.0999300005 | 2105713.56645 | 37.761890709215 | -122.442928012745 | (37.761890709215, -122.442928012745) | |||
| 157171 | 157171 | 228516 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 592 Duncan St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6002757.83463 | 2099794.05926 | 37.7457905872828 | -122.43317464749501 | (37.7457905872828, -122.433174647495) | ||||
| 54011 | 54011 | 196056 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 2399 Lane St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013962.891369999 | 2092855.96285 | 37.7273692674706 | -122.39394328085599 | (37.7273692674706, -122.393943280856) | ||||
| 162918 | 162918 | 126034 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 2390 Bay St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 4ft | 5999370.04259 | 2120163.81894 | 37.801527995669204 | -122.446354207574 | (37.8015279956692, -122.446354207574) | |||
| 25720 | 25720 | 196053 | Undocumented 2 | Populus trichocarpa :: Black Cottonwood Poplar 258 | 2399 Lane St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013983.40604 | 2092884.07422 | 37.727447595718395 | -122.393874328035 | (37.7274475957184, -122.393874328035) | ||||
| 62771 | 62771 | 247889 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 360 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010002.07047 | 2098377.0945200003 | 37.74230819285879 | -122.408025094795 | (37.7423081928588, -122.408025094795) | ||||
| 183614 | 183614 | 247888 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 360 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6009996.89336 | 2098378.14108 | 37.7423107766219 | -122.408043069531 | (37.7423107766219, -122.408043069531) | ||||
| 184292 | 184292 | 247887 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 360 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009991.26305 | 2098380.13852 | 37.7423159459174 | -122.408062678348 | (37.7423159459174, -122.408062678348) | ||||
| 28950 | 28950 | 132461 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006461.025 | 2120401.5247299997 | 37.8025831108771 | -122.42183305885901 | (37.8025831108771, -122.421833058859) | ||||
| 60330 | 60330 | 250004 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 232 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6011504.01109 | 2120100.18107 | 37.802038796226796 | -122.40436048246599 | (37.8020387962268, -122.404360482466) | |||
| 62403 | 62403 | 132460 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006458.07728 | 2120400.55617 | 37.8025802852249 | -122.421843190623 | (37.8025802852249, -122.421843190623) | ||||
| 154158 | 154158 | 132459 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 1109 Chestnut St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.42185659591699 | (37.8025801584021, -122.421856595917) | ||||
| 34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
| 46836 | 46836 | 136715 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6003190.857480001 | 2120979.91426 | 37.803986257417 | -122.43319081820499 | (37.803986257417, -122.433190818205) | |||
| 66458 | 66458 | 136660 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 7ft | 6003228.45993 | 2120985.21121 | 37.8040029344509 | -122.433061071222 | (37.8040029344509, -122.433061071222) | |||
| 72993 | 72993 | 136716 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 7ft | 6003215.33658 | 2120983.87446 | 37.8039985196804 | -122.43310638985001 | (37.8039985196804, -122.43310638985) | |||
| 75488 | 75488 | 136658 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 7ft | 6003175.48548 | 2120978.26665 | 37.803980861494395 | -122.433243896185 | (37.8039808614944, -122.433243896185) | |||
| 115469 | 115469 | 136714 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 7ft | 6003161.03368 | 2120976.61805 | 37.803975515032604 | -122.433293789677 | (37.8039755150326, -122.433293789677) | |||
| 147721 | 147721 | 136659 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1599 North Point St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 7ft | 6003202.747769999 | 2120982.34817 | 37.8039936147875 | -122.433149845112 | (37.8039936147875, -122.433149845112) | |||
| 172278 | 172278 | 241053 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 201 Coso Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 5ft | 6007672.87316 | 2099533.1354400003 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | |||
| 25114 | 25114 | 249640 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999291.5931400005 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | ||||
| 35008 | 35008 | 250159 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999252.38937 | 2117479.90418 | 37.79415196309329 | -122.44656813112302 | (37.7941519630933, -122.446568131123) | ||||
| 37530 | 37530 | 249638 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | ||||
| 64471 | 64471 | 250154 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999263.267440001 | 2117392.55411 | 37.793912744324395 | -122.446524204627 | (37.7939127443244, -122.446524204627) | ||||
| 73767 | 73767 | 249636 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999299.542640001 | 2117085.0893099997 | 37.7930705993714 | -122.446376560233 | (37.7930705993714, -122.446376560233) | ||||
| 132167 | 132167 | 250156 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999256.55789 | 2117425.58205 | 37.7940030470443 | -122.44654979756201 | (37.7940030470443, -122.446549797562) | ||||
| 162632 | 162632 | 250157 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999256.81946 | 2117443.6781200003 | 37.7940527489909 | -122.446550195053 | (37.7940527489909, -122.446550195053) | ||||
| 174728 | 174728 | 250155 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999259.65981 | 2117410.03204 | 37.7939605280209 | -122.44653794537099 | (37.7939605280209, -122.446537945371) | ||||
| 178599 | 178599 | 250158 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999254.28786 | 2117464.37854 | 37.794109442247404 | -122.446560444632 | (37.7941094422474, -122.446560444632) | ||||
| 179334 | 179334 | 136052 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1114 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155004 | -122.41796325270201 | (37.801284085155, -122.417963252702) | ||||
| 179533 | 179533 | 249637 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | ||||
| 33944 | 33944 | 208889 | Undocumented 2 | Malus :: Crab Apple 235 | 714 Detroit St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999450.60571 | 2095416.85302 | 37.733583656540496 | -122.44429603176201 | (37.7335836565405, -122.444296031762) | ||||
| 34864 | 34864 | 246661 | Undocumented 2 | Malus :: Crab Apple 235 | 3301 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6009058.25509 | 2099385.89739 | 37.7450252552125 | -122.41135978362699 | (37.7450252552125, -122.411359783627) | |||
| 55107 | 55107 | 208887 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999422.56432 | 2095411.3960400003 | 37.733567073059895 | -122.44439258657302 | (37.7335670730599, -122.444392586573) | ||||
| 69340 | 69340 | 231470 | Undocumented 2 | Malus :: Crab Apple 235 | 200 Saint Marys Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 2ft | 6003936.80205 | 2095969.7041 | 37.7353565926307 | -122.42882535522 | (37.7353565926307, -122.42882535522) | |||
| 164168 | 164168 | 177470 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | ||||
| 172416 | 172416 | 193454 | Undocumented 2 | Malus :: Crab Apple 235 | 1751 22nd St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 4ft | 6012836.35508 | 2103764.61447 | 37.75725944619679 | -122.39860291658701 | (37.7572594461968, -122.398602916587) | |||
| 176813 | 176813 | 208888 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999417.485309999 | 2095405.5962 | 37.73355085827271 | -122.44440972944099 | (37.7335508582727, -122.444409729441) | ||||
| 179229 | 179229 | 177471 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.44547622197399 | (37.7169201246297, -122.445476221974) | ||||
| 27802 | 27802 | 206466 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999436.63595 | 2095454.0058900001 | 37.733684872551606 | -122.444346998137 | (37.7336848725516, -122.444346998137) | ||||
| 29447 | 29447 | 206472 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 714 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999457.34155 | 2095426.0503099998 | 37.733609294436796 | -122.444273404802 | (37.7336092944368, -122.444273404802) | ||||
| 46759 | 46759 | 187578 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 211 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6009088.83114 | 2088896.1901099999 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | ||||
| 47116 | 47116 | 206467 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999430.1593 | 2095426.08584 | 37.7336078411342 | -122.44436738395099 | (37.7336078411342, -122.444367383951) | ||||
| 47540 | 47540 | 176072 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 653 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.42456068104299 | (37.7261496752474, -122.424560681043) | ||||
| 59831 | 59831 | 206471 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 714 Detroit St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 5999468.77343 | 2095408.32034 | 37.7335612643209 | -122.444232607974 | (37.7335612643209, -122.444232607974) | ||||
| 64819 | 64819 | 246768 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) | ||||
| 76969 | 76969 | 206469 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999419.31958 | 2095424.67998 | 37.733603362501604 | -122.444404758876 | (37.7336033625016, -122.444404758876) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");