trees
208 rows where qLegalStatus_id = 5 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
4387 | 264910 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1615 Wallace Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 11/04/2020 12:00:00 AM | 3 | 4x4 | Permit Number 775989 | 6014687.7877 | 2092924.6213 | 37.7275980500808 | -122.391442091837 | (37.7275980500808, -122.391442091837) | 10 | 3 | 8 | 58 | 1 | |
67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
33 | 261067 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1832 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782484 | 6011934 | 2092960 | 37.727541965346 | -122.400964507068 | (37.727541965346, -122.400964507068) | 10 | 3 | 8 | 58 | 1 | |
37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
746 | 110743 | Section 806 (d) 5 | Cercis occidentalis :: Western Redbud 136 | 2300x Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010565.19201 | 2106016.80838 | 37.7633166706365 | -122.406616231274 | (37.7633166706365, -122.406616231274) | 8 | 4 | 8 | 28859 | 19 | ||
881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
1296 | 114159 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.7953963109343 | -122.434341453993 | (37.7953963109343, -122.434341453993) | 13 | 9 | 1 | 57 | 17 | |
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
2103 | 262299 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
2107 | 113082 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.7262806120542 | -122.407514778095 | (37.7262806120542, -122.407514778095) | 10 | 3 | 7 | 309 | 28 | ||
2349 | 95912 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 858 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2011 12:00:00 AM | 4 | Permit Number 767389 | 5985440.58134 | 2110021.2041 | 37.7728739243823 | -122.493807884231 | (37.7728739243823, -122.493807884231) | 11 | 6 | 2 | 55 | 26 | ||
2411 | 110745 | Section 806 (d) 5 | Cotinus coggygria 'Royal Purple' :: Smoke tree 229 | 2300x Mariposa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010533.01376 | 2106015.32988 | 37.7633108106613 | -122.406727421634 | (37.7633108106613, -122.406727421634) | 8 | 4 | 8 | 28859 | 19 | ||
2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
2593 | 19154 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 64 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774356 | 6003450.27402 | 2107953.58185 | 37.7682339504649 | -122.431362651168 | (37.7682339504649, -122.431362651168) | 15 | 9 | 5 | 28862 | 3 | |
2854 | 255187 | Section 806 (d) 5 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4740 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780757 | 5980843 | 2110991 | 37.7752666409579 | -122.509783220192 | (37.7752666409579, -122.509783220192) | 11 | 6 | 2 | 55 | 26 | |
3241 | 31650 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3632 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2015 12:00:00 AM | 3 | Permit Number 35160 | 5981711.46236471 | 2097421.70961548 | 37.7380604052223 | -122.505772893936 | (37.7380604052223, -122.505772893936) | 1 | 8 | 3 | 29491 | 35 | ||
3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
3414 | 262418 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
3701 | 78185 | Section 806 (d) 5 | Tree(s) :: 17 | 811 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999080 | 2107571 | 37.7669348288429 | -122.446451411547 | (37.7669348288429, -122.446451411547) | 15 | 5 | 11 | 29492 | 9 | |||||
3788 | 110746 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.26001 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | 8 | 4 | 8 | 28859 | 19 | ||
3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
3977 | 262296 | Section 806 (d) 5 | Acer rubrum :: Red Maple 75 | 45 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782635 | 5998403.0154 | 2106238.4273 | 37.7632372305534 | -122.448696994498 | (37.7632372305534, -122.448696994498) | 15 | 5 | 11 | 29492 | 9 | |
4024 | 114160 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.434397600465 | (37.7953804657925, -122.434397600465) | 13 | 9 | 1 | 57 | 17 | |
4243 | 162646 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
4594 | 221063 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006493.11817 | 2110111.72475 | 37.7743316749983 | -122.420990984947 | (37.7743316749983, -122.420990984947) | 7 | 9 | 11 | 28852 | 10 | |||
4750 | 113090 | Section 806 (d) 5 | Pyrus calleryana :: Ornamental Pear 44 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.60872 | 37.7303322746045 | -122.41230559973 | (37.7303322746045, -122.41230559973) | 9 | 3 | 7 | 309 | 28 | ||
4810 | 262420 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
5386 | 262533 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
5528 | 167133 | Section 806 (d) 5 | Melaleuca quinquenervia :: Cajeput 10 | 4564 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2019 12:00:00 AM | 3 | 3x5 | Permit Number 785333 | 6000784.60188 | 2104670.73247 | 37.7590686222364 | -122.440347461192 | (37.7590686222364, -122.440347461192) | 2 | 4 | 5 | 28862 | 3 | |
5719 | 108450 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6014379.30863 | 2103997.39375 | 37.7579844490278 | -122.393283028308 | (37.7579844490278, -122.393283028308) | 10 | 3 | 8 | 28856 | 29 | |||
5830 | 98280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.415320022909 | (37.776578287595, -122.415320022909) | 8 | 2 | 9 | 28853 | 34 | ||
5958 | 102480 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1456 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768914 | 6004877.03101 | 2120232.91154 | 37.8020306879258 | -122.427302455863 | (37.8020306879258, -122.427302455863) | 13 | 9 | 1 | 57 | 17 | |
6139 | 264669 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
6198 | 112830 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 2265 MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 3 | 3x3 | 6006944 | 2105170 | 37.760788269781 | -122.419080706794 | (37.760788269781, -122.419080706794) | 2 | 4 | 7 | 28859 | 19 | ||
6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
6545 | 254389 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
6557 | 264929 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 4725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784398 | 5981118.81181 | 2106198.14775 | 37.7621231273763 | -122.508473270866 | (37.7621231273763, -122.508473270866) | 1 | 8 | 3 | 56 | 35 | |
6642 | 114245 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 54 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 5996571 | 2114184 | 37.7849487713586 | -122.455607632252 | (37.7849487713586, -122.455607632252) | 11 | 6 | 1 | 54 | 31 | |||
6880 | 24222 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.382882921904 | (37.7334154068844, -122.382882921904) | 10 | 3 | 8 | 58 | 1 | |
6990 | 97154 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | 10 | 3 | 8 | 58 | 1 | ||
7043 | 112197 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.7921756543416 | -122.437399303646 | (37.7921756543416, -122.437399303646) | 13 | 6 | 1 | 29490 | 27 | ||
7105 | 262039 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1251 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783100 | 6007540 | 2116706 | 37.7924969115625 | -122.417837146347 | (37.7924969115625, -122.417837146347) | 5 | 1 | 10 | 28858 | 21 | ||
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
7398 | 13267 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000572.6787 | 2119285.0637 | 37.7991837803388 | -122.442129440006 | (37.7991837803388, -122.442129440006) | 13 | 9 | 1 | 57 | 17 | |
7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
7728 | 116230 | Section 806 (d) 5 | Pittosporum undulatum :: Victorian Box 36 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.16403 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | 8 | 2 | 9 | 28853 | 34 | |
7765 | 263633 | Section 806 (d) 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 160 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782824 | 6000235.49843 | 2104901.88273 | 37.7596720242526 | -122.442263109517 | (37.7596720242526, -122.442263109517) | 2 | 4 | 5 | 28862 | 3 | |
7842 | 108451 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014380.97285 | 2103975.72487 | 37.7579250434155 | -122.393275756387 | (37.7579250434155, -122.393275756387) | 10 | 3 | 8 | 28856 | 29 | |||
7952 | 262419 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 101 Brighton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996197.23422 | 2090625.75995 | 37.7202423066045 | -122.455197699909 | (37.7202423066045, -122.455197699909) | 9 | 8 | 6 | 28861 | 24 | |
8444 | 103091 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008424.20559 | 2117797.21945 | 37.7955428518875 | -122.414855023041 | (37.7955428518875, -122.414855023041) | 5 | 1 | 10 | 308 | 21 | |
8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
8647 | 146616 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1320 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | Permit Number 783073 | 6005474.41066 | 2120313.40732 | 37.8022854748664 | -122.425240967805 | (37.8022854748664, -122.425240967805) | 13 | 9 | 1 | 57 | 17 | ||
8728 | 96402 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2160 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2011 12:00:00 AM | 1 | 2x3 | 5985141.5215 | 2100472.7854 | 37.7466391224256 | -122.494138462065 | (37.7466391224256, -122.494138462065) | 1 | 8 | 3 | 29491 | 35 | ||
8745 | 262534 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991046.77559 | 2098937.57906 | 37.7427676232348 | -122.473606942703 | (37.7427676232348, -122.473606942703) | 1 | 8 | 4 | 29491 | 40 | |
8764 | 13266 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2460 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781193 | 6000592.3683 | 2119282.3787 | 37.7991775301158 | -122.442061114605 | (37.7991775301158, -122.442061114605) | 13 | 9 | 1 | 57 | 17 | |
8951 | 108447 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014378.0974 | 2104018.35584 | 37.7580419391129 | -122.393288684138 | (37.7580419391129, -122.393288684138) | 10 | 3 | 8 | 28856 | 29 | |||
8961 | 260880 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
9006 | 112755 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | 11 | 6 | 2 | 55 | 26 | |||
9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
9475 | 163463 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 109 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995872.36784 | 2087580.2575 | 37.7118614273349 | -122.456100577893 | (37.7118614273349, -122.456100577893) | 9 | 8 | 6 | 28861 | 24 | |
9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
9877 | 126318 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 752 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 778828 | 6010086.22048 | 2116329.20443 | 37.791605285407 | -122.409000507567 | (37.791605285407, -122.409000507567) | 5 | 1 | 10 | 28857 | 21 | |
9912 | 103092 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008422.05981 | 2117808.63756 | 37.7955740826282 | -122.414863256344 | (37.7955740826282, -122.414863256344) | 5 | 1 | 10 | 308 | 21 | |
9924 | 101922 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769132 | 6007599.52227 | 2116115.67925 | 37.7908793859256 | -122.417589338874 | (37.7908793859256, -122.417589338874) | 13 | 1 | 10 | 28858 | 21 | |
10091 | 163462 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995871.2375 | 2087597.30845 | 37.7119081803938 | -122.45610571662 | (37.7119081803938, -122.45610571662) | 9 | 8 | 6 | 28861 | 24 | |
10128 | 256113 | Section 806 (d) 5 | Magnolia spp :: Magnolia 224 | 356 Willard North St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2018 12:00:00 AM | 3 | |||||||||||||
10248 | 108452 | Section 806 (d) 5 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 | 696 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014381.40925 | 2103952.18314 | 37.757860427147 | -122.393272599772 | (37.757860427147, -122.393272599772) | 10 | 3 | 8 | 28856 | 29 | |||
10365 | 256095 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | ||||
10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
10996 | 103096 | Section 806 (d) 5 | Fagus sylvatica :: European Beech 272 | 1540 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2013 12:00:00 AM | 3 | 3x3 | Permit Number 768649 | 6008414.12252 | 2117870.41106 | 37.7957432514055 | -122.414895095058 | (37.7957432514055, -122.414895095058) | 5 | 1 | 10 | 308 | 21 | |
11247 | 264702 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 625 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3x3 | Permit Number 783216 | 6005628.43923 | 2105332.18724 | 37.761159426347 | -122.42364218242 | (37.761159426347, -122.42364218242) | 2 | 4 | 5 | 28859 | 19 | ||
11543 | 110044 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 550 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2015 12:00:00 AM | 3 | 3x3 | 5985672.92923 | 2112141.09949 | 37.7787081437008 | -122.493160374959 | (37.7787081437008, -122.493160374959) | 11 | 6 | 2 | 55 | 26 | ||
11626 | 262262 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1324 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784290 | 5993653.14185 | 2106470.72632 | 37.763602309694 | -122.465141974097 | (37.763602309694, -122.465141974097) | 1 | 8 | 11 | 56 | 12 | |
11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
11965 | 221066 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006423.38991 | 2110105.498 | 37.7743106470621 | -122.421231746062 | (37.7743106470621, -122.421231746062) | 7 | 9 | 11 | 28852 | 10 | |||
12144 | 111632 | Section 806 (d) 5 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774682 | 5985071 | 2103231.6 | 37.7542099449347 | -122.49458566251 | (37.7542099449347, -122.49458566251) | 1 | 8 | 3 | 56 | 35 | ||
12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
13211 | 262230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782723 | 5994180.46761 | 2100058.80006 | 37.7460271985036 | -122.462852932256 | (37.7460271985036, -122.462852932256) | 1 | 8 | 4 | 29491 | 40 | |
13701 | 112515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2646 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6000218.93903 | 2118886.71439 | 37.7980698532985 | -122.443324869154 | (37.7980698532985, -122.443324869154) | 13 | 9 | 1 | 57 | 17 | |||
13794 | 101919 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769132 | 6007497.40622 | 2116101.25633 | 37.7908340376155 | -122.417941633898 | (37.7908340376155, -122.417941633898) | 13 | 1 | 10 | 28858 | 21 | |
13918 | 112756 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 590x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 3x3 | 5989085.68012 | 2111584.93801 | 37.7773800886213 | -122.481313741677 | (37.7773800886213, -122.481313741677) | 11 | 6 | 2 | 55 | 26 | |||
14057 | 107967 | Section 806 (d) 5 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001240.68928 | 2116684.58018 | 37.7920815807513 | -122.439631370586 | (37.7920815807513, -122.439631370586) | 13 | 6 | 1 | 29490 | 27 | |
14075 | 110744 | Section 806 (d) 5 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 | 2300x Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010545.16814 | 2106015.79361 | 37.7633127639997 | -122.406685416098 | (37.7633127639997, -122.406685416098) | 8 | 4 | 8 | 28859 | 19 | ||
14180 | 256094 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 439 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777292 | 5982503.90034 | 2112800.93962 | 37.7803340153983 | -122.504171983842 | (37.7803340153983, -122.504171983842) | 11 | 6 | 2 | 55 | 26 | |
14443 | 260878 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2019 12:00:00 AM | 3 | 4x4 | 5987323.25257 | 2098992.99273 | 37.7427034297078 | -122.486485729507 | (37.7427034297078, -122.486485729507) | 1 | 8 | 3 | 29491 | 35 | ||
14464 | 44040 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.74454 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | 13 | 6 | 1 | 29490 | 27 | ||
14595 | 262138 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783072 | 5995073.28586 | 2091364.23184 | 37.7222054253906 | -122.459136235782 | (37.7222054253906, -122.459136235782) | 9 | 8 | 4 | 28861 | 24 |
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) );