trees
205 rows where qCaretaker_id = 2 and qLegalStatus_id = 5 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
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 | |||||||||||||
15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
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 | |
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 | |
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 | ||
18205 | 262139 | Section 806 (d) 5 | Podocarpus gracilor :: Fern Pine 51 | 1582 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782766 | 5981929 | 2104333 | 37.7570496794991 | -122.505532928251 | (37.7570496794991, -122.505532928251) | 1 | 8 | 3 | 56 | 35 | |
2057 | 111315 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
9406 | 111316 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
16827 | 111314 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
17482 | 111313 | Section 806 (d) 5 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.62139 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | 1 | 8 | 3 | 29491 | 35 | ||
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 | ||||
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 | |
16964 | 264738 | Section 806 (d) 5 | Prunus cerasifera :: Cherry Plum 7 | 2722 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/29/2020 12:00:00 AM | 3 | 3x6 | Permit Number 781841 | 5983409.1923 | 2096639.50516 | 37.7360124610612 | -122.499845290879 | (37.7360124610612, -122.499845290879) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
11539 | 262395 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2755 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784406 | 5983997.14788 | 2096421.7593 | 37.7354490751144 | -122.497796450434 | (37.7354490751144, -122.497796450434) | 1 | 8 | 3 | 29491 | 35 | |
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 | ||
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 | ||
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 | ||
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 | ||
9833 | 262515 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1951 34th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 779100 | 5985670.12137 | 2101944.25665 | 37.7507102998335 | -122.49241898675 | (37.7507102998335, -122.49241898675) | 1 | 8 | 3 | 29491 | 35 | |
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 | ||
7739 | 262320 | Section 806 (d) 5 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2567 31st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785009 | 5986744.29234 | 2097795.22153 | 37.7393809030196 | -122.48839957369 | (37.7393809030196, -122.48839957369) | 1 | 8 | 3 | 29491 | 35 | |
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 | ||||
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 | ||
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 | ||
18095 | 260879 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2395 29th Ave | 2 | 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 | ||
194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
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 | |||
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 | |||
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 | |
15035 | 164228 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991043.64805 | 2099007.36638 | 37.7429590601275 | -122.473622846338 | (37.7429590601275, -122.473622846338) | 1 | 8 | 4 | 29491 | 40 | |
15653 | 164229 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773215 | 5991045.42225 | 2098958.21862 | 37.7428242157788 | -122.47361312736 | (37.7428242157788, -122.47361312736) | 1 | 8 | 4 | 29491 | 40 | |
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 | |
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 | |
18260 | 164230 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 2401 17th Ave | 3 | 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 | |
194494 | 264749 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 1339 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2021 12:00:00 AM | 3 | 3x3 | Permit Number 785207 | 5991088 | 2106284 | 37.7629413570223 | -122.474000279679 | (37.7629413570223, -122.474000279679) | 1 | 8 | 11 | 56 | 12 | |
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 | |
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 | |
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 | |
3554 | 264866 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 8 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
5206 | 264864 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 6 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
5321 | 264860 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 2 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
5474 | 264865 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 7 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
6005 | 264861 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 3 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
7163 | 255651 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | Permit Number 783039 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | |||
8122 | 264863 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 5 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
12645 | 264862 | Section 806 (d) 5 | Heteromeles arbutifolia :: Toyon 186 | 10X Selma Way | 4 | Unaccepted Street : Yard | Tree | Private 2 | 10x100 | 5992494 | 2103402 | 37.7551094821546 | -122.468927712716 | (37.7551094821546, -122.468927712716) | 1 | 8 | 4 | 56 | 12 | ||||
7830 | 262278 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
15881 | 264923 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
591 | 264763 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
18566 | 256863 | Section 806 (d) 5 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 274 Victoria St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/19/2018 12:00:00 AM | 3 | 3x8 | Permit Number 781692 | 5993256.27541 | 2089011.86791 | 37.7156417766237 | -122.465246370223 | (37.7156417766237, -122.465246370223) | 9 | 8 | 6 | 64 | 24 | |
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 | |
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 | |
16663 | 262231 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 42 Dorantes Ave | 2 | 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 | |
194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
194448 | 265090 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 784731 | 5994883.78198 | 2089306.03852 | 37.7165432206381 | -122.459642300713 | (37.7165432206381, -122.459642300713) | 9 | 8 | 6 | 28861 | 24 | |
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 | |
19607 | 163461 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.30801 | 2087623.97935 | 37.7119813591246 | -122.456110856234 | (37.7119813591246, -122.456110856234) | 9 | 8 | 6 | 28861 | 24 | |
17374 | 163460 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 115 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 774886 | 5995870.33981 | 2087649.24929 | 37.7120507463226 | -122.45611257216 | (37.7120507463226, -122.45611257216) | 9 | 8 | 6 | 28861 | 24 | |
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 | |
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 | |
19533 | 259217 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784737 | 5996177 | 2090586 | 37.7201319742324 | -122.455264770625 | (37.7201319742324, -122.455264770625) | 9 | 8 | 6 | 28861 | 24 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |
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 | |||||
10736 | 262270 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 4 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
12694 | 262268 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 2 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
14968 | 262269 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 3 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
16422 | 262267 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
19451 | 254404 | Section 806 (d) 5 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 127 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2018 12:00:00 AM | 3 | 3x3 | 5999857 | 2108965 | 37.7708067512445 | -122.443864065657 | (37.7708067512445, -122.443864065657) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
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 | |
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 | |
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 | |
194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |
16986 | 111918 | Section 806 (d) 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 41 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773012 | 6001705.38657 | 2120044.83908 | 37.8013344103251 | -122.438264349848 | (37.8013344103251, -122.438264349848) | 13 | 9 | 1 | 57 | 17 | |
16057 | 167157 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 368 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782616 | 6001774.58914 | 2103700.91584 | 37.7564620577863 | -122.436854194887 | (37.7564620577863, -122.436854194887) | 2 | 4 | 5 | 28862 | 3 | |
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 | ||
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 | |
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 | ||
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 | |
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 |
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) );