Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2627 | 2627 | 44896 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2630 | 2630 | 44978 | Permitted Site 1 | Tree(s) :: 17 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 2650 | 2650 | 253148 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 375 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | 3x3 | Permit Number 43092 | 6003622.0 | 2091383.0 | 37.722744709081205 | -122.42958672889 | (37.7227447090812, -122.42958672889) | |||
| 2659 | 2659 | 253154 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | ||||
| 2673 | 2673 | 46063 | Permitted Site 1 | Tree(s) :: 17 | 105 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2699 | 2699 | 36646 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 2726 | 2726 | 46033 | Permitted Site 1 | Tree(s) :: 17 | 213 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 2842 | 2842 | 36843 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 2860 | 2860 | 44877 | Permitted Site 1 | Tree(s) :: 17 | 150 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
| 2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
| 2904 | 2904 | 44678 | Permitted Site 1 | Tree(s) :: 17 | 98 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 2945 | 2945 | 44998 | Permitted Site 1 | Tree(s) :: 17 | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2960 | 2960 | 44920 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 2992 | 2992 | 43017 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 3027 | 3027 | 45855 | Permitted Site 1 | Tree(s) :: 17 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3062 | 3062 | 34116 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 3077 | 3077 | 35211 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3090 | 3090 | 44576 | Permitted Site 1 | Tree(s) :: 17 | 140 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3117 | 3117 | 38667 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | Permit Number 40586 | ||||||||
| 3118 | 3118 | 48324 | Permitted Site 1 | Tree(s) :: 17 | 176 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3134 | 3134 | 44852 | Permitted Site 1 | Tree(s) :: 17 | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3168 | 3168 | 33093 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 3177 | 3177 | 46976 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 94122 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44996 | ||||||||
| 3178 | 3178 | 48242 | Permitted Site 1 | Tree(s) :: 17 | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3193 | 3193 | 48299 | Permitted Site 1 | Tree(s) :: 17 | 133 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3194 | 3194 | 253362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3195 | 3195 | 253357 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3197 | 3197 | 253348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1728 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3198 | 3198 | 253367 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | Permit Number 23367 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | |||
| 3199 | 3199 | 253365 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1745 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3200 | 3200 | 253352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3205 | 3205 | 253356 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3207 | 3207 | 253355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3209 | 3209 | 253364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3212 | 3212 | 34102 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 3215 | 3215 | 253360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3217 | 3217 | 253347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3221 | 3221 | 253361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3224 | 3224 | 253358 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3225 | 3225 | 253351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3227 | 3227 | 48059 | Permitted Site 1 | Tree(s) :: 17 | 230 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3229 | 3229 | 253353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3233 | 3233 | 253345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3234 | 3234 | 253359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3236 | 3236 | 253349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3238 | 3238 | 253363 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3242 | 3242 | 253354 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3244 | 3244 | 253350 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3246 | 3246 | 253346 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3266 | 3266 | 44618 | Permitted Site 1 | Tree(s) :: 17 | 182 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3285 | 3285 | 44952 | Permitted Site 1 | Tree(s) :: 17 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3297 | 3297 | 44585 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3322 | 3322 | 44559 | Permitted Site 1 | Tree(s) :: 17 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3393 | 3393 | 33932 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1997 12:00:00 AM | Permit Number 37893 | |||||||||
| 3395 | 3395 | 46141 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3402 | 3402 | 253446 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1339 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 3x3 | 6002186.0 | 2113207.0 | 37.7825867929513 | -122.43611162356399 | (37.7825867929513, -122.436111623564) | |||
| 3408 | 3408 | 44959 | Permitted Site 1 | Tree(s) :: 17 | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3420 | 3420 | 35199 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | Permit Number 38712 | |||||||||
| 3444 | 3444 | 48277 | Permitted Site 1 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3448 | 3448 | 48107 | Permitted Site 1 | Tree(s) :: 17 | 202 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3458 | 3458 | 44636 | Permitted Site 1 | Tree(s) :: 17 | 164 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3465 | 3465 | 39926 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 3539 | 3539 | 46147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3543 | 3543 | 44857 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 3545 | 3545 | 43015 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 3614 | 3614 | 46882 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2002 12:00:00 AM | Permit Number 44940 | |||||||||
| 3622 | 3622 | 34463 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1521 Ralston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | Permit Number 38201 | ||||||||
| 3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
| 3636 | 3636 | 64705 | Permitted Site 1 | Tree(s) :: 17 | 252 Walker Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1988 12:00:00 AM | Permit Number 25649 | ||||||||
| 3649 | 3649 | 253514 | Permitted Site 1 | Tree(s) :: 17 | 128 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2007 12:00:00 AM | Permit No. 49290 | 5994510.638119999 | 2105337.44986 | 37.760540036372205 | -122.46209399567199 | (37.7605400363722, -122.462093995672) | |||
| 3663 | 3663 | 36860 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 3670 | 3670 | 253512 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2498 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 3x3 | 6000414.87165 | 2119245.42001 | 37.7990659347341 | -122.442672656788 | (37.7990659347341, -122.442672656788) | |||
| 3695 | 3695 | 57738 | Permitted Site 1 | Tree(s) :: 17 | 1999 So. Bascom Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | Permit Number 16656 | ||||||||
| 3744 | 3744 | 46296 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 3746 | 3746 | 253553 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2763 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4X4 | 6007078.6273 | 2102287.5862 | 37.7528814055888 | -122.41841070542401 | (37.7528814055888, -122.418410705424) | ||||
| 3751 | 3751 | 45854 | Permitted Site 1 | Tree(s) :: 17 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 3765 | 3765 | 45857 | Permitted Site 1 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 3821 | 3821 | 46195 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 3838 | 3838 | 48141 | Permitted Site 1 | Tree(s) :: 17 | 251 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3864 | 3864 | 44703 | Permitted Site 1 | Tree(s) :: 17 | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 3875 | 3875 | 48176 | Permitted Site 1 | Tree(s) :: 17 | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 3909 | 3909 | 48174 | Permitted Site 1 | Tree(s) :: 17 | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4009 | 4009 | 34002 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37940 | ||||||||||
| 4038 | 4038 | 45886 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4053 | 4053 | 45907 | Permitted Site 1 | Tree(s) :: 17 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4084 | 4084 | 45961 | Permitted Site 1 | Tree(s) :: 17 | 162 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4133 | 4133 | 48248 | Permitted Site 1 | Tree(s) :: 17 | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 4165 | 4165 | 253615 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221.0 | 2118816.0 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | ||
| 4171 | 4171 | 39901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | Permit Number 41185 | |||||||||
| 4256 | 4256 | 44534 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 4347 | 4347 | 45877 | Permitted Site 1 | Tree(s) :: 17 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 4351 | 4351 | 36746 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5555 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39516 | ||||||||
| 4378 | 4378 | 45905 | Permitted Site 1 | Tree(s) :: 17 | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 |
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");