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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 26561 | 26561 | 79997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 6 | 5981344.9471 | 2112403.2124900003 | 37.7791737487824 | -122.50815174160499 | (37.7791737487824, -122.508151741605) | ||
| 168947 | 168947 | 79998 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.50813990451401 | (37.7791033052806, -122.508139904514) | ||
| 147049 | 147049 | 79999 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | ||
| 132819 | 132819 | 80000 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 4 | 5981404.80446 | 2112378.67743 | 37.7791099097712 | -122.50794285274799 | (37.7791099097712, -122.507942852748) | ||
| 67321 | 67321 | 79880 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5981353.9893 | 2102319.4895 | 37.751487294996295 | -122.507372114024 | (37.7514872949963, -122.507372114024) | ||
| 34434 | 34434 | 83787 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1926 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 9 | 5981682.722 | 2101945.6334 | 37.750480149523796 | -122.506207617383 | (37.7504801495238, -122.506207617383) | ||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 125226 | 125226 | 70167 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | |
| 49251 | 49251 | 79990 | Undocumented 2 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2005 12:00:00 AM | 5 | 5981694.1032 | 2096684.9357 | 37.736036404783796 | -122.505778307285 | (37.7360364047838, -122.505778307285) | ||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 47382 | 47382 | 84587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5981781.9237 | 2098926.9802 | 37.7421976095989 | -122.50564083146999 | (37.7421976095989, -122.50564083147) | |||
| 155376 | 155376 | 78523 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981811.5356 | 2099469.1319 | 37.7436879505195 | -122.50557862346201 | (37.7436879505195, -122.505578623462) | ||
| 61060 | 61060 | 78524 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981824.7341 | 2099468.7935 | 37.743687798107295 | -122.50553296193998 | (37.7436877981073, -122.50553296194) | ||
| 186836 | 186836 | 78525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 4 | 5981839.9629999995 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | ||
| 36833 | 36833 | 78526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3550 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 6 | 5981863.3141 | 2099471.5008 | 37.7436975019585 | -122.505399764525 | (37.7436975019585, -122.505399764525) | ||
| 134601 | 134601 | 69761 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411001 | (37.7454063146777, -122.50535336411) | ||
| 133356 | 133356 | 78173 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1203 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 3 | 5982086.3748 | 2106829.8545 | 37.7639145899835 | -122.50517371769101 | (37.7639145899835, -122.505173717691) | ||
| 168113 | 168113 | 70380 | Undocumented 2 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | ||
| 41953 | 41953 | 78551 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | ||
| 62316 | 62316 | 70381 | Undocumented 2 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.50471186838499 | (37.7594237635385, -122.504711868385) | ||
| 135519 | 135519 | 70226 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1466 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982190.0408 | 2105127.5478 | 37.759246640966 | -122.504689034952 | (37.759246640966, -122.504689034952) | ||
| 164747 | 164747 | 79480 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 881 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 7 | 5982298.725380001 | 2109767.28551 | 37.7719924204152 | -122.50465693044599 | (37.7719924204152, -122.504656930446) | ||
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 157408 | 157408 | 69788 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | 1 | 5982204.5216 | 2104686.309 | 37.758035976388896 | -122.50460626225299 | (37.7580359763889, -122.504606262253) | ||
| 162877 | 162877 | 74930 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982222.2441 | 2104869.0336 | 37.758538728740504 | -122.50455850908999 | (37.7585387287405, -122.50455850909) | ||
| 150731 | 150731 | 74788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982233.8553 | 2104870.2558 | 37.758542767533 | -122.504518443568 | (37.758542767533, -122.504518443568) | ||
| 157821 | 157821 | 74635 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 4 | 5982248.2166 | 2104869.6447 | 37.7585419343481 | -122.504468731299 | (37.7585419343481, -122.504468731299) | ||
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 53271 | 53271 | 74480 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | ||
| 46713 | 46713 | 70364 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5982287.6338 | 2104871.478 | 37.758549286455604 | -122.504332547004 | (37.7585492864556, -122.504332547004) | ||
| 60075 | 60075 | 70358 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3833 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982319.9846 | 2104190.4495 | 37.7566812777905 | -122.504170218425 | (37.7566812777905, -122.504170218425) | ||
| 31704 | 31704 | 70357 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3827 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982346.2639999995 | 2104189.8384 | 37.7566811453358 | -122.50407929098 | (37.7566811453358, -122.50407929098) | ||
| 59691 | 59691 | 69869 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.50404752601101 | (37.747904810916, -122.504047526011) | ||
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 41830 | 41830 | 73381 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.50376486060101 | (37.7591449348846, -122.503764860601) | ||
| 163200 | 163200 | 70250 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | ||
| 63369 | 63369 | 73417 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1501 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982464.5527 | 2104844.8944 | 37.7584866992539 | -122.503718723326 | (37.7584866992539, -122.503718723326) | ||
| 148725 | 148725 | 78560 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2214 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 3 | 5982364.6255 | 2099997.6781 | 37.7451717266117 | -122.503705339024 | (37.7451717266117, -122.503705339024) | ||
| 168388 | 168388 | 81295 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2274 45th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2005 12:00:00 AM | 2 | 5982376.5473 | 2099668.9758 | 37.744269902082706 | -122.503639778557 | (37.7442699020827, -122.503639778557) | ||
| 71403 | 71403 | 78558 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2286 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 2 | 5982378.4208 | 2099556.0589 | 37.7439599736661 | -122.50362494012501 | (37.7439599736661, -122.503624940125) | ||
| 56847 | 56847 | 71337 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | ||
| 85446 | 85446 | 70434 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.50361073719101 | (37.772435937677, -122.503610737191) | |
| 161732 | 161732 | 74932 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1494 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 4.5x6 | 5982503.1091 | 2104954.5575 | 37.758790069955396 | -122.503593501173 | (37.7587900699554, -122.503593501173) | |
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 54349 | 54349 | 79894 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4119 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2001 12:00:00 AM | 7 | 5982716.5012300005 | 2113074.1195 | 37.78109658773229 | -122.503456745272 | (37.7810965877323, -122.503456745272) | ||
| 46613 | 46613 | 70168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 6 | 5982718.93125 | 2111668.1719299997 | 37.7772364107813 | -122.50334420523399 | (37.7772364107813, -122.503344205234) | ||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 173093 | 173093 | 70444 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3933 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 3 | 5982611.2212 | 2104882.7837 | 37.758599355061996 | -122.503214291779 | (37.758599355062, -122.503214291779) | ||
| 37548 | 37548 | 70361 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3933 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982619.7769 | 2104883.3949 | 37.75860153616 | -122.503184748041 | (37.75860153616, -122.503184748041) | ||
| 42861 | 42861 | 70362 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | ||
| 183688 | 183688 | 79638 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1307 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2002 12:00:00 AM | 4 | 5982729.5509 | 2106184.5595 | 37.7621806168968 | -122.502901428306 | (37.7621806168968, -122.502901428306) | ||
| 160957 | 160957 | 75711 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.50270417470301 | (37.7615029058487, -122.502704174703) | ||
| 137949 | 137949 | 75807 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1360 43rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 4 | 5982781.2778 | 2105905.2346 | 37.761416710141894 | -122.502701850909 | (37.7614167101419, -122.502701850909) | ||
| 62127 | 62127 | 75880 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | ||
| 134165 | 134165 | 70332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 765 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 7 | 5982891.42605 | 2110581.736 | 37.7742635126433 | -122.502667063271 | (37.7742635126433, -122.502667063271) | ||
| 171006 | 171006 | 72283 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 779 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982894.68666 | 2110493.65125 | 37.774021849099704 | -122.502649263154 | (37.7740218490997, -122.502649263154) | ||
| 50854 | 50854 | 78554 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2210 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/2000 12:00:00 AM | 3 | 5982671.6049 | 2100049.9563 | 37.745333312577 | -122.50264774353998 | (37.745333312577, -122.50264774354) | ||
| 25852 | 25852 | 70376 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | ||
| 69292 | 69292 | 73402 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 16 | 5982802.3301 | 2105339.2702 | 37.759863969648 | -122.502587148941 | (37.759863969648, -122.502587148941) | ||
| 180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
| 174126 | 174126 | 72282 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 734 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.57235 | 2110777.2604400003 | 37.774802607591894 | -122.50254958518299 | (37.7748026075919, -122.502549585183) | ||
| 137610 | 137610 | 72285 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 863 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 5 | 5982914.89246 | 2109924.42924 | 37.7724601177826 | -122.502537229747 | (37.7724601177826, -122.502537229747) | ||
| 153673 | 153673 | 72284 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 828 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 3 | 5982951.02608 | 2110145.8974099997 | 37.773070328481396 | -122.502428636033 | (37.7730703284814, -122.502428636033) | ||
| 67644 | 67644 | 70573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 11 | 5982961.78283 | 2109923.12422 | 37.772459289826 | -122.502374937437 | (37.772459289826, -122.502374937437) | ||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 52169 | 52169 | 82920 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 1 | 5982872.9956 | 2103302.6049 | 37.754276013066104 | -122.502192036803 | (37.7542760130661, -122.502192036803) | ||
| 152944 | 152944 | 70360 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3826 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982955.4526 | 2104949.3397 | 37.7588023275687 | -122.502028728145 | (37.7588023275687, -122.502028728145) | ||
| 30206 | 30206 | 70458 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | ||
| 41486 | 41486 | 81182 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | ||
| 26855 | 26855 | 73378 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 6 | 5983190.4387300005 | 2110910.57285 | 37.775183970412996 | -122.501657073915 | (37.775183970413, -122.501657073915) | ||
| 27399 | 27399 | 70234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 5 | 5983192.21244 | 2110893.91815 | 37.775138345619396 | -122.501649705941 | (37.7751383456194, -122.501649705941) | ||
| 180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
| 56897 | 56897 | 70367 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1406 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983105.9662 | 2105534.9379 | 37.7604190558161 | -122.50155151240601 | (37.7604190558161, -122.501551512406) | ||
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 37064 | 37064 | 70204 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1466 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 2 | 5983116.0005 | 2105270.034 | 37.7596922939576 | -122.501497212024 | (37.7596922939576, -122.501497212024) | ||
| 147818 | 147818 | 72278 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 716 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 3 | 5983237.15085 | 2110912.93675 | 37.7751932045665 | -122.501495663732 | (37.7751932045665, -122.501495663732) | ||
| 157423 | 157423 | 70369 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983117.2046 | 2105238.7271 | 37.759606404775504 | -122.50149073173 | (37.7596064047755, -122.50149073173) | ||
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 30576 | 30576 | 70371 | Undocumented 2 | Tree(s) :: 17 | 1470 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2015 12:00:00 AM | 7 | Permit Number 776609 | 5983120.8169 | 2105139.9902 | 37.759335513294396 | -122.50147093465598 | (37.7593355132944, -122.501470934656) | |
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 75941 | 75941 | 73418 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 3 | 5983001.5767 | 2098246.6338 | 37.740401269768796 | -122.50137340388001 | (37.7404012697688, -122.50137340388) | ||
| 58302 | 58302 | 70437 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 8 | 5983020.7059 | 2098971.1879 | 37.742391820222295 | -122.50136084638201 | (37.7423918202223, -122.501360846382) | ||
| 35629 | 35629 | 70375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | ||
| 12715 | 12715 | 70439 | Undocumented 2 | Tree(s) :: 17 | 2426 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773392 | 5983041.4986 | 2098597.8907 | 37.7413680695353 | -122.501261346997 | (37.7413680695353, -122.501261346997) |
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 45057 | 45057 | 70451 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | ||
| 60617 | 60617 | 70028 | Undocumented 2 | Melaleuca ericifolia :: Heath Melaleuca 184 | 555 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/11/1992 12:00:00 AM | 5 | 5983452.32231 | 2112030.7596400003 | 37.7782750565666 | -122.500834032057 | (37.7782750565666, -122.500834032057) | ||
| 13187 | 13187 | 106199 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x4 | 5983225.8003 | 2100763.9337 | 37.74732624942661 | -122.500784246807 | (37.7473262494266, -122.500784246807) | ||
| 174370 | 174370 | 71615 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | ||
| 58760 | 58760 | 72570 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3841 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1996 12:00:00 AM | 13 | 5983527.11089 | 2113102.27119 | 37.7812215053692 | -122.500654568438 | (37.7812215053692, -122.500654568438) | ||
| 151092 | 151092 | 72277 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983524.1138 | 2110218.5518 | 37.773303473649605 | -122.500451657892 | (37.7733034736496, -122.500451657892) | ||
| 26181 | 26181 | 74488 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.50035771523599 | (37.7433893618735, -122.500357715236) | ||
| 180951 | 180951 | 73633 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 782 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 1 | 5983562.4874599995 | 2110479.0519 | 37.7740209842304 | -122.500338183608 | (37.7740209842304, -122.500338183608) | ||
| 61266 | 61266 | 74796 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) |
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");