Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
| 142346 | 142346 | 46752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 375 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44854 | 5993218.00754376 | 2089670.83747573 | 37.7174489416695 | -122.465426481993 | (37.7174489416695, -122.465426481993) | ||
| 185548 | 185548 | 203447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 327 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992190.092759999 | 2090032.52678 | 37.7183827154591 | -122.469005784505 | (37.7183827154591, -122.469005784505) | |||
| 60321 | 60321 | 203473 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 128 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997584.72507 | 2091125.26044 | 37.7216933258806 | -122.450437617121 | (37.7216933258806, -122.450437617121) | |||
| 63274 | 63274 | 203472 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 126 Howth St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997592.47815 | 2091138.0222 | 37.721728810427706 | -122.450411736413 | (37.7217288104277, -122.450411736413) | |||
| 154495 | 154495 | 175170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004288.38035 | 2091053.9849099999 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | |||
| 12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
| 49140 | 49140 | 175171 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003766.2619199995 | 2091125.7997700002 | 37.7220466613948 | -122.429069717203 | (37.7220466613948, -122.429069717203) | |||
| 149006 | 149006 | 175172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003774.221480001 | 2091143.66189 | 37.7220961573958 | -122.42904347588998 | (37.7220961573958, -122.42904347589) | |||
| 26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
| 177207 | 177207 | 175173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003787.7125 | 2091165.48018 | 37.7221568292683 | -122.428998395553 | (37.7221568292683, -122.428998395553) | |||
| 52909 | 52909 | 175174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003793.29108 | 2091173.5648599998 | 37.722179343787396 | -122.428979687879 | (37.7221793437874, -122.428979687879) | |||
| 11199 | 11199 | 79973 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.8612400002 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | |
| 11423 | 11423 | 110030 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.5181900002 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) |
| 121106 | 121106 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 760 Victoria St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 54337 | 54337 | 175154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000079.77144 | 2092298.5573 | 37.7250574153596 | -122.44189709559299 | (37.7250574153596, -122.441897095593) | |||
| 183613 | 183613 | 175155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000081.06235 | 2092299.82458 | 37.7250609685792 | -122.441892723985 | (37.7250609685792, -122.441892723985) | |||
| 179679 | 179679 | 175156 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000083.66792 | 2092301.69867 | 37.7250662628724 | -122.441883851284 | (37.7250662628724, -122.441883851284) | |||
| 65811 | 65811 | 175157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000084.80379 | 2092303.48045 | 37.7250712199557 | -122.44188005254 | (37.7250712199557, -122.44188005254) | |||
| 70001 | 70001 | 175158 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000088.06493 | 2092305.57905 | 37.7250771680567 | -122.44186892971399 | (37.7250771680567, -122.441868929714) | |||
| 160711 | 160711 | 175159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000090.185269999 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | |||
| 24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
| 184886 | 184886 | 175161 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000095.42068 | 2092313.2586299998 | 37.7250986735632 | -122.44184405267 | (37.7250986735632, -122.44184405267) | |||
| 57123 | 57123 | 175162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000098.0141199995 | 2092315.01212 | 37.7251036360216 | -122.441835213242 | (37.7251036360216, -122.441835213242) | |||
| 33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
| 76902 | 76902 | 175164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000102.2336800005 | 2092318.3901400003 | 37.7251131517233 | -122.44182086904301 | (37.7251131517233, -122.441820869043) | |||
| 104293 | 104293 | 38940 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 153 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40740 | 5991575.72353287 | 2092547.36275219 | 37.7252523189339 | -122.47131251444401 | (37.7252523189339, -122.471312514444) | ||
| 82144 | 82144 | 40782 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | ||
| 99946 | 99946 | 38942 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1998 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
| 120539 | 120539 | 38941 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2001 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
| 111438 | 111438 | 38936 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
| 113313 | 113313 | 38937 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
| 41144 | 41144 | 175153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6001323.552619999 | 2092431.0494099997 | 37.7254920046417 | -122.43760697060101 | (37.7254920046417, -122.437606970601) | |||
| 2582 | 2582 | 253132 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | ||||
| 170748 | 170748 | 203482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 43 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994625.10613 | 2092859.45738 | 37.726285178816205 | -122.460793782631 | (37.7262851788162, -122.460793782631) | |||
| 149887 | 149887 | 175169 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266001 | (37.7271890729929, -122.41063996266) | |||
| 161535 | 161535 | 95678 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 307 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767430 | 6009637.5069 | 2092959.36639 | 37.7274118548521 | -122.40890349142799 | (37.7274118548521, -122.408903491428) |
| 66225 | 66225 | 99400 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 67476 | 67476 | 99401 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 79982 | 79982 | 99408 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 92011 | 92011 | 99403 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 100451 | 100451 | 99404 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 105779 | 105779 | 99406 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 119818 | 119818 | 99405 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 120185 | 120185 | 99407 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | ||
| 160003 | 160003 | 99402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
| 178911 | 178911 | 203459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993538.98145 | 2093351.56708 | 37.727573838962606 | -122.464584148065 | (37.7275738389626, -122.464584148065) | |||
| 91561 | 91561 | 33364 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
| 167329 | 167329 | 203458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993554.49033 | 2093381.1926 | 37.7276560774418 | -122.464532684353 | (37.7276560774418, -122.464532684353) | |||
| 68669 | 68669 | 203481 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993650.092119999 | 2093481.6421299998 | 37.7279373979817 | -122.464209479697 | (37.7279373979817, -122.464209479697) | |||
| 43774 | 43774 | 203480 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993659.30191 | 2093497.00296 | 37.7279801058879 | -122.464178756148 | (37.7279801058879, -122.464178756148) | |||
| 89745 | 89745 | 33370 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 108997 | 108997 | 33369 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 118540 | 118540 | 33368 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
| 152920 | 152920 | 203479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | |||
| 126893 | 126893 | 203457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993628.67358 | 2093513.96157 | 37.7280249047113 | -122.464285869009 | (37.7280249047113, -122.464285869009) | |||
| 163005 | 163005 | 203456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993632.52713 | 2093523.8641700002 | 37.7280523169437 | -122.46427326591001 | (37.7280523169437, -122.46427326591) | |||
| 107258 | 107258 | 33366 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 108145 | 108145 | 33367 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
| 271 | 271 | 175152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.3929700002 | 37.728639972642604 | -122.43966968351002 | (37.7286399726426, -122.43966968351) | |
| 267 | 267 | 175151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.728679573387495 | -122.43975313162399 | (37.7286795733875, -122.439753131624) | |
| 50704 | 50704 | 35721 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 556 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1998 12:00:00 AM | 10 | Permit Number 39004 | 6008810.28905 | 2093458.06001 | 37.728734789961706 | -122.411798418969 | (37.7287347899617, -122.411798418969) | |
| 64600 | 64600 | 203500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | |||
| 173963 | 173963 | 203499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 379 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997569.0689199995 | 2093791.20398 | 37.7290124835419 | -122.45068384968799 | (37.7290124835419, -122.450683849688) | |||
| 66904 | 66904 | 203470 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5999333.68862 | 2093807.8865599998 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | ||||
| 76690 | 76690 | 35734 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 202 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 6 | Permit Number 47062 | 6010246.45985 | 2093710.9780400002 | 37.7295097141809 | -122.40685127987899 | (37.7295097141809, -122.406851279879) | |
| 19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
| 49324 | 49324 | 175168 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | |||
| 43939 | 43939 | 203498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 234 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999190.87551 | 2094097.9228400001 | 37.72994736206179 | -122.445099202768 | (37.7299473620618, -122.445099202768) | |||
| 36512 | 36512 | 175167 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | |||
| 25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
| 33494 | 33494 | 175166 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | |||
| 65581 | 65581 | 35740 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/2000 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.7328599999 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | |
| 57215 | 57215 | 175165 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | |||
| 77902 | 77902 | 96256 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 86792 | 86792 | 96257 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 112630 | 112630 | 96255 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 117169 | 117169 | 96259 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 192@ Congdon Ney St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645.0 | 2094034.0 | 37.73008164064579 | -122.42623908205 | (37.7300816406458, -122.42623908205) | ||
| 167219 | 167219 | 203460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998498.644119999 | 2094367.6439099999 | 37.730648417773104 | -122.44751172680901 | (37.7306484177731, -122.447511726809) | |||
| 55188 | 55188 | 203461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 409 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998653.32929 | 2094365.51359 | 37.7306514071182 | -122.446976805539 | (37.7306514071182, -122.446976805539) | |||
| 53366 | 53366 | 203468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 5998155.09728 | 2094421.38368 | 37.7307763355428 | -122.448703284436 | (37.7307763355428, -122.448703284436) | |||
| 134166 | 134166 | 203466 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5998189.167859999 | 2094420.9335599998 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | |||
| 153900 | 153900 | 203467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5998177.872280001 | 2094421.44457 | 37.730777805043104 | -122.448624552388 | (37.7307778050431, -122.448624552388) | |||
| 71361 | 71361 | 203465 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5998202.03163 | 2094421.3515299999 | 37.7307789309899 | -122.448541023359 | (37.7307789309899, -122.448541023359) | |||
| 185204 | 185204 | 203464 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 312 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999389.85516 | 2094399.0679799998 | 37.730785591378606 | -122.44443294273701 | (37.7307855913786, -122.444432942737) | ||||
| 134639 | 134639 | 203462 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6000775.11209 | 2094438.40357 | 37.7309725397368 | -122.43964672021299 | (37.7309725397368, -122.439646720213) | |||
| 160402 | 160402 | 203463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.731015444602896 | -122.43964672024099 | (37.7310154446029, -122.439646720241) | |||
| 86242 | 86242 | 42581 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.732242319303104 | -122.47039977177499 | (37.7322423193031, -122.470399771775) | ||
| 161472 | 161472 | 203494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999675.09138 | 2094930.6164 | 37.732261369848 | -122.443485006944 | (37.732261369848, -122.443485006944) | |||
| 48836 | 48836 | 203495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999677.596390001 | 2094931.24105 | 37.732263227850204 | -122.443476391437 | (37.7322632278502, -122.443476391437) | |||
| 159436 | 159436 | 51699 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.913509999 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | ||
| 41684 | 41684 | 203490 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001874.24208 | 2094906.2061700001 | 37.7323195164307 | -122.43588030914302 | (37.7323195164307, -122.435880309143) | |||
| 185062 | 185062 | 203496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998101.393730001 | 2095150.6752900002 | 37.732775726305206 | -122.448941459085 | (37.7327757263052, -122.448941459085) | |||
| 97412 | 97412 | 50391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.732830315621705 | -122.455320609685 | (37.7328303156217, -122.455320609685) | ||
| 189070 | 189070 | 203497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.733017974899504 | -122.45086036952299 | (37.7330179748995, -122.450860369523) | |||
| 94135 | 94135 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 301 Hazelwood Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996219.7 | 2095283.8 | 37.733033461480495 | -122.45545652663701 | (37.7330334614805, -122.455456526637) | |||||
| 185700 | 185700 | 203483 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.733225844180105 | -122.457954104018 | (37.7332258441801, -122.457954104018) | |||
| 39883 | 39883 | 203492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | |||
| 148413 | 148413 | 203491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.733744960750705 | -122.44270283418899 | (37.7337449607507, -122.442702834189) |
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");