Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
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) | ||||
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) | ||||
1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
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) | |||
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) | |||
48369 | 48369 | 179631 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 184 Mount Vernon Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998932.987869999 | 2089405.3609099998 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | ||||
59717 | 59717 | 178076 | Undocumented 2 | Persea americana :: Avocado 113 | 184 Mount Vernon Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998937.21643 | 2089402.34913 | 37.7170399224441 | -122.44563859365401 | (37.7170399224441, -122.445638593654) | ||||
174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
35448 | 35448 | 176098 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5998949.65718 | 2089392.42013 | 37.717013369950706 | -122.44559487852699 | (37.7170133699507, -122.445594878527) | ||||
184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
65775 | 65775 | 176097 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998962.663240001 | 2089377.08137 | 37.716971995749795 | -122.445548820645 | (37.7169719957498, -122.445548820645) | ||||
180895 | 180895 | 176096 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998966.43073 | 2089373.6298 | 37.7169627336137 | -122.445535550248 | (37.7169627336137, -122.445535550248) | ||||
178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
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) | ||||
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) | ||||
67603 | 67603 | 181293 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 184 Mount Vernon Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 5998992.1360599995 | 2089349.9308099998 | 37.7168991290824 | -122.44544499658998 | (37.7168991290824, -122.44544499659) | ||||
178664 | 178664 | 223860 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999452.08936 | 2105235.56335 | 37.7605435481615 | -122.4449965101 | (37.7605435481615, -122.4449965101) | |||
137558 | 137558 | 223859 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999452.72733 | 2105240.37235 | 37.7605567888939 | -122.44499464937799 | (37.7605567888939, -122.444994649378) | |||
161757 | 161757 | 223861 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999453.3613 | 2105232.0542599997 | 37.760533985665 | -122.44499185878999 | (37.760533985665, -122.44499185879) | |||
30657 | 30657 | 220393 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 20 Deming St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 5999466.4358 | 2105239.81948 | 37.7605560532329 | -122.44494719845801 | (37.7605560532329, -122.444947198458) | |||
1918 | 1918 | 251819 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298X Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
100045 | 100045 | 120550 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298x Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 10 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
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) | ||||
136760 | 136760 | 207514 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 747 Detroit St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999418.54493 | 2095450.46717 | 37.7336741238608 | -122.444409289657 | (37.7336741238608, -122.444409289657) | ||||
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) | ||||
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) | ||||
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) | ||||
25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
56881 | 56881 | 237937 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999630.47363 | 2105335.88644 | 37.7608291899486 | -122.44438677244301 | (37.7608291899486, -122.444386772443) | |||
152906 | 152906 | 215179 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 747 Detroit St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999425.63373 | 2095397.4728 | 37.733529018245605 | -122.444380974518 | (37.7335290182456, -122.444380974518) | ||||
132915 | 132915 | 206470 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999427.716030001 | 2095403.5068599998 | 37.733545705162705 | -122.44437420892599 | (37.7335457051627, -122.444374208926) | ||||
167940 | 167940 | 240620 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 272 Corbett Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 3ft | 5999634.90147 | 2105345.61253 | 37.7608561480145 | -122.44437215754401 | (37.7608561480145, -122.444372157544) | |||
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) | ||||
166087 | 166087 | 237935 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 5999636.03267 | 2105332.26436 | 37.7608195617885 | -122.444367285948 | (37.7608195617885, -122.444367285948) | |||
154241 | 154241 | 222765 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 272 Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 5999637.29501 | 2105376.06979 | 37.760939912666004 | -122.444366068238 | (37.760939912666, -122.444366068238) | |||
66579 | 66579 | 237936 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999637.58135 | 2105322.06296 | 37.7607916396321 | -122.444361196632 | (37.7607916396321, -122.444361196632) | |||
161626 | 161626 | 226818 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 272 Corbett Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 5999639.14958 | 2105380.58985 | 37.7609524294432 | -122.44435997895599 | (37.7609524294432, -122.444359978956) | |||
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) | ||||
174607 | 174607 | 237938 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999643.14509 | 2105335.6231299997 | 37.7608291899369 | -122.44434292871 | (37.7608291899369, -122.44434292871) | |||
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) | ||||
161777 | 161777 | 206468 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999438.31164 | 2095424.2853299999 | 37.7336033624897 | -122.444339069698 | (37.7336033624897, -122.444339069698) | ||||
168341 | 168341 | 203438 | Undocumented 2 | Acer spp :: Maple 158 | 714 Detroit St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999448.55059 | 2095428.3134400002 | 37.73361500690729 | -122.44430396017401 | (37.7336150069073, -122.444303960174) | ||||
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) | ||||
162408 | 162408 | 213702 | Undocumented 2 | Prunus spp :: Cherry 84 | 714 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 5999450.30082 | 2095402.17977 | 37.7335433498509 | -122.444296031758 | (37.7335433498509, -122.444296031758) | ||||
129644 | 129644 | 214463 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 714 Detroit St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999453.46925 | 2095428.5374599998 | 37.733615902639706 | -122.44428697109 | (37.7336159026397, -122.44428697109) | ||||
165904 | 165904 | 205419 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 714 Detroit St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999453.91846 | 2095387.09878 | 37.733502147395896 | -122.444282441206 | (37.7335021473959, -122.444282441206) | ||||
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) | ||||
62960 | 62960 | 210898 | Undocumented 2 | Persea americana :: Avocado 113 | 714 Detroit St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999457.20499 | 2095395.4919200002 | 37.7335253804911 | -122.44427168171002 | (37.7335253804911, -122.44427168171) | ||||
29144 | 29144 | 205629 | Undocumented 2 | Betula pendula :: European White Birch 146 | 714 Detroit St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999458.60233 | 2095454.85434 | 37.7336884554611 | -122.444271115125 | (37.7336884554611, -122.444271115125) | ||||
150791 | 150791 | 205420 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 714 Detroit St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5999461.8044300005 | 2095388.23948 | 37.7335057294051 | -122.444255259197 | (37.7335057294051, -122.444255259197) | ||||
184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
146611 | 146611 | 206798 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 714 Detroit St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5999465.474230001 | 2095438.72707 | 37.7336445658277 | -122.444246198512 | (37.7336445658277, -122.444246198512) | ||||
53472 | 53472 | 207987 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999466.174219999 | 2095456.6543299998 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | ||||
186431 | 186431 | 211852 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 714 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.44424166861602 | (37.7335800736498, -122.444241668616) | ||||
56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
25566 | 25566 | 214228 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999467.5472800005 | 2095443.9032 | 37.733658896535 | -122.444239403229 | (37.733658896535, -122.444239403229) | ||||
28786 | 28786 | 214229 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999467.99685 | 2095449.76583 | 37.7336750195872 | -122.444238270085 | (37.7336750195872, -122.444238270085) | ||||
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) | ||||
159551 | 159551 | 247520 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000003.99995 | 2108482.26842 | 37.7694896756401 | -122.443320913055 | (37.7694896756401, -122.443320913055) | ||||
164851 | 164851 | 247521 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1101 Waller St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000007.86979 | 2108477.01107 | 37.7694754609529 | -122.443307149811 | (37.7694754609529, -122.443307149811) | ||||
156377 | 156377 | 247522 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000010.6242 | 2108472.60358 | 37.7694635161602 | -122.443297305835 | (37.7694635161602, -122.443297305835) | ||||
58076 | 58076 | 247523 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1101 Waller St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6000011.18383 | 2108488.88375 | 37.769508249328 | -122.44329653959801 | (37.769508249328, -122.443296539598) | ||||
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) | ||||
159854 | 159854 | 247525 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1101 Waller St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000029.935269999 | 2108491.2793400004 | 37.7695158962756 | -122.443231851395 | (37.7695158962756, -122.443231851395) | ||||
33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) | ||||
130643 | 130643 | 247527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000059.53834 | 2108484.86365 | 37.769499968379705 | -122.443128995021 | (37.7694999683797, -122.443128995021) | ||||
27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
69221 | 69221 | 247529 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000073.75314 | 2108487.72588 | 37.7695086378454 | -122.44308003233499 | (37.7695086378454, -122.443080032335) | ||||
173692 | 173692 | 237872 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000053.4214699995 | 2105717.34957 | 37.7619007159651 | -122.44295138252 | (37.7619007159651, -122.44295138252) | |||
177957 | 177957 | 240632 | Undocumented 2 | Sequoiadendron giganteum :: Sierra Redwood 212 | 200 Corbin Pl | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6000056.026330001 | 2105707.20258 | 37.7618730033536 | -122.442941644657 | (37.7618730033536, -122.442941644657) | |||
34805 | 34805 | 236092 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000056.44576 | 2105686.72803 | 37.761816809218296 | -122.44293872364099 | (37.7618168092183, -122.442938723641) | |||
169254 | 169254 | 236090 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000058.01731 | 2105721.74002 | 37.7619130330791 | -122.442935802668 | (37.7619130330791, -122.442935802668) | |||
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) | |||
148101 | 148101 | 236091 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6000061.20427 | 2105698.96506 | 37.7618506803725 | -122.44292314469101 | (37.7618506803725, -122.442923144691) | |||
25273 | 25273 | 237871 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.7105 | 2105723.34521 | 37.761917651093704 | -122.44292314469 | (37.7619176510937, -122.44292314469) | |||
70823 | 70823 | 237870 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000061.78033 | 2105726.70817 | 37.7619268889309 | -122.442923144685 | (37.7619268889309, -122.442923144685) | |||
64330 | 64330 | 236093 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 200 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6000063.11815 | 2105682.66467 | 37.7618060326498 | -122.44291535476201 | (37.7618060326498, -122.442915354762) | |||
40020 | 40020 | 224067 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 198 Corbin Pl | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6000076.797040001 | 2105677.0536599997 | 37.7617914060643 | -122.44286764213301 | (37.7617914060643, -122.442867642133) | |||
58384 | 58384 | 236089 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 198 Corbin Pl | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 3ft | 6000079.09557 | 2105681.45742 | 37.761803628741795 | -122.442860008701 | (37.7618036287418, -122.442860008701) | |||
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) | |||
49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
68436 | 68436 | 227459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | |||
60526 | 60526 | 224443 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 198 Corbin Pl | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000083.78895 | 2105729.05454 | 37.76193458623221 | -122.442847194237 | (37.7619345862322, -122.442847194237) | |||
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) | |||
151746 | 151746 | 231168 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 198 Corbin Pl | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 3ft | 6000085.93778 | 2105710.50665 | 37.7618837808207 | -122.442838430352 | (37.7618837808207, -122.442838430352) | |||
181045 | 181045 | 223003 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 198 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000086.83847 | 2105686.0969700003 | 37.761816809226 | -122.442833562346 | (37.761816809226, -122.442833562346) | |||
48170 | 48170 | 240950 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 4806 25th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000018.52876 | 2101091.51792 | 37.7491973234931 | -122.44273989253401 | (37.7491973234931, -122.442739892534) | ||||
34593 | 34593 | 234491 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 24 Saturn St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6000385.28479 | 2106021.7264900003 | 37.762755374980394 | -122.44182544748999 | (37.7627553749804, -122.44182544749) | |||
188250 | 188250 | 245744 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 24 Saturn St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6000500.5382900005 | 2106017.92887 | 37.762751514198705 | -122.441426555002 | (37.7627515141987, -122.441426555002) | |||
138174 | 138174 | 233332 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Saturn St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6000503.342180001 | 2106030.7905200003 | 37.7627869888479 | -122.44141778031201 | (37.7627869888479, -122.441417780312) | |||
3261 | 3261 | 253388 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 30 Grand View Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
3280 | 3280 | 253389 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
65858 | 65858 | 204573 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 403 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 10ft | 6000740.47882 | 2095257.8114200002 | 37.7332204725414 | -122.439825179911 | (37.7332204725414, -122.439825179911) | |||
154831 | 154831 | 207505 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 404 Baden St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6000763.5114400005 | 2095280.18835 | 37.7332832254367 | -122.439747153813 | (37.7332832254367, -122.439747153813) | ||||
58506 | 58506 | 205602 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000764.56926 | 2095288.2895 | 37.733305529524294 | -122.43974407725099 | (37.7333055295243, -122.439744077251) | ||||
180394 | 180394 | 203576 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 404 Baden St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000769.77181 | 2095296.00897 | 37.7333270215234 | -122.439726643888 | (37.7333270215234, -122.439726643888) | ||||
41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) |
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");