Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49231 | 49231 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 79797 | 79797 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | |||||
| 80545 | 80545 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 86013 | 86013 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105010 | 105010 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105245 | 105245 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105541 | 105541 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 112189 | 112189 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 117729 | 117729 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 125709 | 125709 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128194 | 128194 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128290 | 128290 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 138891 | 138891 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139193 | 139193 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139478 | 139478 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 85680 | 85680 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | |||||
| 3028 | 3028 | 191362 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 999 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6013336.3333 | 2089743.8780099999 | 37.718789267498295 | -122.39589132571999 | (37.7187892674983, -122.39589132572) | ||||
| 16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
| 39540 | 39540 | 131592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6008355.8018 | 2118946.79635 | 37.7986954612792 | -122.41517312674601 | (37.7986954612792, -122.415173126746) | ||||
| 54378 | 54378 | 131593 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008359.29361 | 2118943.47544 | 37.7986865391195 | -122.415160808731 | (37.7986865391195, -122.415160808731) | ||||
| 136669 | 136669 | 131594 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008361.61132 | 2118940.7694200003 | 37.7986792393119 | -122.41515259703999 | (37.7986792393119, -122.41515259704) | ||||
| 163624 | 163624 | 131595 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6008365.45395 | 2118940.10023 | 37.7986776178289 | -122.41513925288 | (37.7986776178289, -122.41513925288) | ||||
| 28201 | 28201 | 234514 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009944.54234 | 2103430.26244 | 37.7561798559202 | -122.408580392894 | (37.7561798559202, -122.408580392894) | |||
| 59133 | 59133 | 227950 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009943.9384 | 2103453.89323 | 37.756244706952295 | -122.408584148445 | (37.7562447069523, -122.408584148445) | |||
| 67533 | 67533 | 234513 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 998 York St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009942.57021 | 2103461.5506 | 37.7562656557487 | -122.408589420289 | (37.7562656557487, -122.408589420289) | |||
| 135349 | 135349 | 233915 | Undocumented 2 | Persea americana :: Avocado 113 | 998 York St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.01185 | 2103432.65253 | 37.756186332856295 | -122.408585854469 | (37.7561863328563, -122.408585854469) | |||
| 147808 | 147808 | 227948 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.19062 | 2103487.1600900004 | 37.756335896405396 | -122.40859599791 | (37.7563358964054, -122.40859599791) | |||
| 160514 | 160514 | 227949 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009941.58696 | 2103473.27819 | 37.756297802015794 | -122.408593647988 | (37.7562978020158, -122.408593647988) | |||
| 176124 | 176124 | 227951 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 7ft | 6009943.616780001 | 2103443.6327299997 | 37.7562165159053 | -122.408584536948 | (37.7562165159053, -122.408584536948) | |||
| 100469 | 100469 | 110542 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 996 SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6007549.0 | 2103894.0 | 37.757318718735704 | -122.41689786927 | (37.7573187187357, -122.41689786927) | |||||
| 132566 | 132566 | 203830 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 990 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5995335.27016 | 2094553.61244 | 37.730977754916 | -122.45846137648998 | (37.730977754916, -122.45846137649) | ||||
| 162351 | 162351 | 211153 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 990 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5995337.03671 | 2094563.98966 | 37.731006349766204 | -122.458456020149 | (37.7310063497662, -122.458456020149) | ||||
| 184458 | 184458 | 212074 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 5994256.6309 | 2097391.5669400003 | 37.738708030453 | -122.462396147864 | (37.738708030453, -122.462396147864) | |||
| 59427 | 59427 | 211882 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993133.46797 | 2096720.62207 | 37.7368010432217 | -122.466230735658 | (37.7368010432217, -122.466230735658) | |||
| 166996 | 166996 | 211883 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 5993091.26879 | 2096743.1724900003 | 37.73686052618039 | -122.466378273942 | (37.7368605261804, -122.466378273942) | |||
| 32758 | 32758 | 208066 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5994517.25257 | 2100489.12784 | 37.7472281625491 | -122.46171957892099 | (37.7472281625491, -122.461719578921) | |||
| 76885 | 76885 | 208068 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 6ft | 5994541.71354 | 2100515.18677 | 37.7473011218565 | -122.461636884428 | (37.7473011218565, -122.461636884428) | |||
| 167817 | 167817 | 208069 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994554.01203 | 2100525.45715 | 37.7473300296505 | -122.461595101959 | (37.7473300296505, -122.461595101959) | |||
| 183642 | 183642 | 208067 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99 Marcela Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 6ft | 5994528.34567 | 2100501.93042 | 37.7472639537695 | -122.461682148211 | (37.7472639537695, -122.461682148211) | |||
| 61028 | 61028 | 234093 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Lapidge St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006030.40587 | 2104961.66349 | 37.760164736632 | -122.42222562462798 | (37.760164736632, -122.422225624628) | |||
| 154159 | 154159 | 224137 | Undocumented 2 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 99 Lapidge St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6006030.22965 | 2104977.22383 | 37.7602074517435 | -122.42222733961901 | (37.7602074517435, -122.422227339619) | |||
| 167522 | 167522 | 234094 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 Lapidge St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 6006027.15545 | 2105008.64737 | 37.76029356002471 | -122.422240204431 | (37.7602935600247, -122.422240204431) | |||
| 178758 | 178758 | 223370 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 99 Lapidge St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6006029.2284 | 2104988.85011 | 37.7602393183104 | -122.42223162849899 | (37.7602393183104, -122.422231628499) | |||
| 180793 | 180793 | 123756 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 99 Cabrillo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5995405.24475 | 2110764.0495 | 37.77549153290371 | -122.45939298463101 | (37.7754915329037, -122.459392984631) | |||
| 62277 | 62277 | 250545 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 5ft | 5987996.344380001 | 2115386.3423900004 | 37.7877542741995 | -122.485361078263 | (37.7877542741995, -122.485361078263) | |||
| 36179 | 36179 | 232334 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000140.77216 | 2101983.38554 | 37.7516531444772 | -122.442381194354 | (37.7516531444772, -122.442381194354) | |||
| 39763 | 39763 | 232335 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000130.35257 | 2101984.21301 | 37.751654822617795 | -122.442417285937 | (37.7516548226178, -122.442417285937) | |||
| 148121 | 148121 | 247459 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 985 Oak St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6002326.2969 | 2109831.4554 | 37.7733263633354 | -122.435384717986 | (37.7733263633354, -122.435384717986) | |||
| 35526 | 35526 | 131605 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6008358.64628 | 2118966.19584 | 37.7987488873077 | -122.41516465784599 | (37.7987488873077, -122.415164657846) | ||||
| 47171 | 47171 | 131603 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6008364.00256 | 2118971.01393 | 37.7987624175955 | -122.415146464564 | (37.7987624175955, -122.415146464564) | ||||
| 47883 | 47883 | 131602 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6008366.73043 | 2118973.4018200003 | 37.798769127446604 | -122.41513719434099 | (37.7987691274466, -122.415137194341) | ||||
| 48841 | 48841 | 131606 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6008355.1511699995 | 2118961.6475299997 | 37.7987362023609 | -122.41517642996 | (37.7987362023609, -122.41517642996) | ||||
| 186284 | 186284 | 131604 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 982 Green St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008361.31812 | 2118968.29697 | 37.7987548066399 | -122.415155561198 | (37.7987548066399, -122.415155561198) | ||||
| 26514 | 26514 | 193470 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 981 Le Conte Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013233.09279 | 2089478.4366400002 | 37.7180546742753 | -122.396229595828 | (37.7180546742753, -122.396229595828) | ||||
| 57201 | 57201 | 193471 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 981 Le Conte Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6013228.480909999 | 2089472.4797 | 37.718038061083796 | -122.39624511993999 | (37.7180380610838, -122.39624511994) | ||||
| 128928 | 128928 | 194271 | Undocumented 2 | Persea americana :: Avocado 113 | 981 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013188.13717 | 2089502.23425 | 37.7181175161869 | -122.396386656119 | (37.7181175161869, -122.396386656119) | ||||
| 130738 | 130738 | 194469 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 981 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6013175.32991 | 2089516.2476299999 | 37.7181552814285 | -122.396431907321 | (37.7181552814285, -122.396431907321) | ||||
| 157743 | 157743 | 199425 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 981 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013195.96321 | 2089497.3406 | 37.7181045146991 | -122.396359261865 | (37.7181045146991, -122.396359261865) | ||||
| 53926 | 53926 | 209523 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 98 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5993587.65915 | 2101408.38697 | 37.749698658666894 | -122.465000768883 | (37.7496986586669, -122.465000768883) | |||
| 186426 | 186426 | 214765 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993613.7342 | 2101408.96874 | 37.7497017595309 | -122.464910643325 | (37.7497017595309, -122.464910643325) | |||
| 187571 | 187571 | 250436 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | |||
| 165081 | 165081 | 207774 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 98 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 10ft | 5993269.03182 | 2097018.73215 | 37.7376273996789 | -122.465783688974 | (37.7376273996789, -122.465783688974) | |||
| 28460 | 28460 | 211766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5992106.77002 | 2095921.0899200002 | 37.73454643836789 | -122.469722258175 | (37.7345464383679, -122.469722258175) | |||
| 150066 | 150066 | 211767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 98 San Fernando Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 5ft | 5992105.74103 | 2095889.53253 | 37.734459730225396 | -122.46972351902001 | (37.7344597302254, -122.46972351902) | |||
| 73442 | 73442 | 209080 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 5992832.63855 | 2096096.07642 | 37.73506883564 | -122.467225429034 | (37.73506883564, -122.467225429034) | |||
| 178638 | 178638 | 209079 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98 San Benito Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5992829.37061 | 2096132.65975 | 37.7351690956763 | -122.467239386499 | (37.7351690956763, -122.467239386499) | |||
| 44976 | 44976 | 140824 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 98 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996239.98 | 2113878.2862 | 37.784090361774794 | -122.456730730831 | (37.7840903617748, -122.456730730831) | |||
| 57413 | 57413 | 225818 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 98 Hill St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | |||
| 151325 | 151325 | 124638 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Arguello Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995530.63562 | 2115556.39278 | 37.788657236011 | -122.45930635468099 | (37.788657236011, -122.459306354681) | |||
| 176638 | 176638 | 124640 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995530.71624 | 2115532.72803 | 37.7885922636435 | -122.45930436133699 | (37.7885922636435, -122.459304361337) | |||
| 183732 | 183732 | 124639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Arguello Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995530.66555 | 2115544.05864 | 37.788623371519606 | -122.459305357571 | (37.7886233715196, -122.459305357571) | |||
| 31752 | 31752 | 250543 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5988034.75992 | 2115431.27896 | 37.78787989509 | -122.485231467955 | (37.78787989509, -122.485231467955) | |||
| 63366 | 63366 | 250542 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5988034.23001 | 2115456.27732 | 37.78794850256371 | -122.48523513629499 | (37.7879485025637, -122.485235136295) | |||
| 130166 | 130166 | 250541 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 5988032.7846800005 | 2115471.44116 | 37.7879900539321 | -122.4852412499 | (37.7879900539321, -122.4852412499) | |||
| 166042 | 166042 | 250544 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 5988034.70999 | 2115412.27568 | 37.787827714612 | -122.485230245793 | (37.787827714612, -122.485230245793) | |||
| 3254 | 3254 | 244746 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 98 12th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6007069.86029 | 2109755.10428 | 37.7733849739584 | -122.418970623803 | (37.7733849739584, -122.418970623803) | |||
| 3382 | 3382 | 122965 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993050.799269999 | 2114904.9128799997 | 37.786725565514004 | -122.467838745487 | (37.786725565514, -122.467838745487) | |||
| 44257 | 44257 | 122964 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.46784226780301 | (37.7867467201865, -122.467842267803) | |||
| 79910 | 79910 | 122968 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 5993052.13641 | 2114881.36584 | 37.786660989023396 | -122.467832406076 | (37.7866609890234, -122.467832406076) | |||
| 130099 | 130099 | 122967 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 98 09th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5993050.69162 | 2114890.11462 | 37.78668492734221 | -122.467838041215 | (37.7866849273422, -122.467838041215) | |||
| 138134 | 138134 | 122963 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 5ft | 5993049.89782 | 2114920.13829 | 37.7867673182529 | -122.467842972058 | (37.7867673182529, -122.467842972058) | |||
| 186187 | 186187 | 122966 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 98 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 5ft | 5993051.69731 | 2114899.21704 | 37.7867099781585 | -122.467835224084 | (37.7867099781585, -122.467835224084) | |||
| 64704 | 64704 | 191708 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 979 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6013251.209530001 | 2089459.918 | 37.7180048338374 | -122.396165676526 | (37.7180048338374, -122.396165676526) | ||||
| 4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
| 76302 | 76302 | 247458 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 977 Oak St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 6002343.7004 | 2109830.6644 | 37.773325179802605 | -122.435324460366 | (37.7733251798026, -122.435324460366) | |||
| 76783 | 76783 | 222163 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000221.60157 | 2101988.12675 | 37.7516707693994 | -122.442102016907 | (37.7516707693994, -122.442102016907) | |||
| 166351 | 166351 | 222164 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 6000208.07575 | 2101987.18481 | 37.75166741222971 | -122.442148723208 | (37.7516674122297, -122.442148723208) | |||
| 33211 | 33211 | 200211 | Undocumented 2 | :: 54 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014078.3317 | 2089599.8969999999 | 37.7184351760665 | -122.39331644356001 | (37.7184351760665, -122.39331644356) | |||
| 41321 | 41321 | 221280 | Undocumented 2 | Brachychiton populneus :: Bottle Tree 329 | 970 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000248.03946 | 2101990.02339 | 37.7516774837438 | -122.442010727629 | (37.7516774837438, -122.442010727629) | |||
| 37133 | 37133 | 212073 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 97 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994261.112380001 | 2097463.04726 | 37.7389045557057 | -122.46238583625 | (37.7389045557057, -122.46238583625) | |||
| 171028 | 171028 | 182594 | Undocumented 2 | :: 54 | 965 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990156.9225 | 2100377.7114 | 37.7466702775018 | -122.476788966542 | (37.7466702775018, -122.476788966542) | |||
| 49187 | 49187 | 197204 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 961 Le Conte Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6013357.29959 | 2089363.32814 | 37.71774551972621 | -122.395792202474 | (37.7177455197262, -122.395792202474) | ||||
| 67831 | 67831 | 188723 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013346.445730001 | 2089388.2762799999 | 37.717813418545205 | -122.39583146685499 | (37.7178134185452, -122.395831466855) | ||||
| 152170 | 152170 | 188724 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 961 Le Conte Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013382.05808 | 2089359.66984 | 37.7177368520568 | -122.395706366661 | (37.7177368520568, -122.395706366661) | ||||
| 45912 | 45912 | 242593 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 960 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000277.53945 | 2101991.5509200003 | 37.751683359019395 | -122.44190882273199 | (37.7516833590194, -122.441908822732) | |||
| 124363 | 124363 | 214772 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 96 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5993626.401000001 | 2101411.46451 | 37.7497093426138 | -122.46486702261801 | (37.7497093426138, -122.464867022618) | |||
| 75199 | 75199 | 214961 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993562.89782 | 2095215.2180400002 | 37.7326923447694 | -122.46463673950399 | (37.7326923447694, -122.464636739504) | |||
| 170486 | 170486 | 214960 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993567.2652 | 2095228.36715 | 37.7327287007546 | -122.464622594975 | (37.7327287007546, -122.464622594975) | |||
| 186356 | 186356 | 214959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 96 San Andreas Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993574.3517 | 2095241.11953 | 37.7327641241706 | -122.46459902103099 | (37.7327641241706, -122.464599021031) | |||
| 64672 | 64672 | 201451 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 96 Middle Point Rd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6018201.15931 | 2095830.10025 | 37.735770303244294 | -122.379497951066 | (37.7357703032443, -122.379497951066) |
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");