trees
85 rows where qCaretaker_id = 18
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11205 | 17641 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 19804 | 29809 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 19975 | 29822 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 24613 | 6699 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 24791 | 29820 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 25279 | 6695 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 26979 | 29831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 29038 | 86623 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010870.62173 | 2109748.7492 | 37.7735808121462 | -122.405822739627 | (37.7735808121462, -122.405822739627) | 14 | 2 | 9 | 28853 | 34 | ||
| 31612 | 29821 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 35348 | 17631 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | ||
| 35988 | 17646 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 38193 | 6703 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 38581 | 29817 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 41584 | 29827 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 41932 | 29823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 43501 | 17638 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 48269 | 29808 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 54027 | 86813 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 54518 | 200335 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 7 | : | Tree | Purchasing Dept 18 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | 10 | 3 | 8 | 58 | 1 | |||
| 55826 | 86803 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 12 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 55872 | 86805 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 56423 | 29810 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 57188 | 28729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 60255 | 29807 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 68696 | 86625 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010895.2675 | 2109773.10415 | 37.7736490634866 | -122.405739201611 | (37.7736490634866, -122.405739201611) | 14 | 2 | 9 | 28853 | 34 | ||
| 71834 | 17642 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 72377 | 17649 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 72416 | 29816 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 74365 | 17636 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 75159 | 86806 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 75374 | 29812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 78700 | 86807 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 700X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 78949 | 29814 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 79754 | 86812 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/26/2012 02:00:00 PM | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 81099 | 6689 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 81581 | 17650 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 84528 | 17645 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 89345 | 17639 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 94190 | 6693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 103418 | 17640 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 600X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 105906 | 29804 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 108380 | 17634 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 110210 | 86626 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010925.67942 | 2109801.58517 | 37.7737289664413 | -122.405636007996 | (37.7737289664413, -122.405636007996) | 14 | 2 | 9 | 28853 | 34 | ||
| 110822 | 17654 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 9 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 111628 | 29815 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 113550 | 29819 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 116439 | 17643 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 122158 | 17651 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 123510 | 29813 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 124098 | 29825 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 126907 | 6688 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 128702 | 29830 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 132652 | 17653 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 132986 | 200334 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 750 Phelps St | 4 | : | Tree | Purchasing Dept 18 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.7425659089002 | -122.388913512973 | (37.7425659089002, -122.388913512973) | 10 | 3 | 8 | 58 | 1 | ||
| 135378 | 29826 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 137825 | 28730 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 142707 | 6696 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 143601 | 29833 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 145278 | 6687 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 148712 | 29832 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 30 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/28/2011 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 149229 | 6690 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 150774 | 29818 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 151268 | 17647 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 650X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 6 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 152792 | 6700 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 157248 | 6697 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | |||
| 160133 | 29811 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1695X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | |||
| 161509 | 86815 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 710X Phelps St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 162032 | 6694 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 11/01/1989 12:00:00 AM | 12 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 164193 | 86808 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | |||
| 169099 | 29805 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 171929 | 17637 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 420X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 | |||
| 173791 | 17655 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 10 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 174113 | 29824 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 176808 | 86624 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010883.02334 | 2109759.81343 | 37.7736118855124 | -122.405780619884 | (37.7736118855124, -122.405780619884) | 14 | 2 | 9 | 28853 | 34 | ||
| 179312 | 86811 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 700X Phelps St | 6 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/26/2012 02:00:00 PM | 9 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 179513 | 86814 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 710X Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 3 | 2x2 | 6015125.852778 | 2097818.007348 | 37.7410585994074 | -122.390269419031 | (37.7410585994074, -122.390269419031) | 10 | 3 | 8 | 58 | 1 | |||
| 180373 | 86804 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 13 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 10/01/2007 12:00:00 AM | 3 | 2x2 | 6015141.822176 | 2097839.440048 | 37.7411183349667 | -122.3902156992 | (37.7411183349667, -122.3902156992) | 10 | 3 | 8 | 58 | 1 | ||
| 186185 | 29829 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 187024 | 6698 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 187221 | 6691 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1795X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6014623.8379379 | 2099253.7018787 | 37.7449728593106 | -122.392105596748 | (37.7449728593106, -122.392105596748) | 10 | 3 | 8 | 58 | 1 | ||
| 187488 | 29806 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 190140 | 17652 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 650X Phelps St | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 2x2 | 6015137.8127243 | 2097842.4274144 | 37.7411263152677 | -122.390229771214 | (37.7411263152677, -122.390229771214) | 10 | 3 | 8 | 58 | 1 | |||
| 191015 | 17644 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.7417507208067 | -122.38966824015 | (37.7417507208067, -122.38966824015) | 10 | 3 | 8 | 58 | 1 | |||
| 191457 | 29828 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
| 194098 | 17635 | Permitted Site 7 | Liriodendron tulipifera :: Tulip Tree 145 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.388649846738 | (37.7428823403387, -122.388649846738) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );