trees
8,298 rows where qLegalStatus_id = 4 sorted by qAddress descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
59876 | 116749 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
62277 | 116746 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
131415 | 116747 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
156017 | 116748 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011671 | 2087411 | 37.7122908654107 | -122.40148388608 | (37.7122908654107, -122.40148388608) | 10 | 3 | 8 | 309 | 1 | ||||
184600 | 115801 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 9M CAIRE TER | 1 | Front Yard : Yard | Tree | Private 2 | 6012720 | 2101959 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | 10 | 3 | 8 | 28856 | 29 | |||||
92681 | 115442 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
137554 | 115443 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
150284 | 115440 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
4323 | 264887 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
12086 | 264891 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
13415 | 264888 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
15114 | 264890 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
17002 | 264889 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
18389 | 264893 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 99x South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007378 | 2109480 | 37.7726469495053 | -122.417885217611 | (37.7726469495053, -122.417885217611) | 8 | 2 | 9 | 28853 | 19 | ||||
27792 | 121374 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
107285 | 121373 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
124117 | 121376 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
155774 | 121375 | Undocumented 4 | Palm (unknown Genus) :: Palm Spp 273 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006202 | 2097575 | 37.7398923261482 | -122.421107660096 | (37.7398923261482, -122.421107660096) | 2 | 7 | 7 | 28859 | 2 | ||||
17186 | 110519 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
92925 | 110520 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
136878 | 110521 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
139612 | 110517 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
149801 | 110518 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
150794 | 110522 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006400 | 2107588 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | 8 | 4 | 7 | 28853 | 19 | |||
59912 | 108412 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
82815 | 108411 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
115122 | 108413 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
135346 | 108414 | Undocumented 4 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108 | 2112443 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | 7 | 10 | 9 | 28852 | 36 | ||
8589 | 111310 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
86119 | 111312 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
89537 | 111311 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 99x GILROY ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015277 | 2088666 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | 10 | 3 | 8 | 58 | 1 | ||||
63560 | 254930 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
93694 | 254933 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
107777 | 254932 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3 | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | ||
136261 | 254931 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 99x De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2018 12:00:00 AM | 3x3 | 6011946 | 2108010 | 37.76886668305 | -122.40198056734 | (37.76886668305, -122.40198056734) | 8 | 2 | 8 | 28856 | 20 | |||
122000 | 104507 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5998517 | 2087907 | 37.7129100350962 | -122.446983527065 | (37.7129100350962, -122.446983527065) | 9 | 7 | 6 | 28861 | 25 | |||
12772 | 111858 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
59455 | 111853 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | |||
71655 | 111854 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
94741 | 111857 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
120888 | 111855 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
178196 | 111856 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
139654 | 111669 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
145614 | 111670 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998115 | 2107097 | 37.7655781805803 | -122.449755015442 | (37.7655781805803, -122.449755015442) | 15 | 5 | 11 | 29492 | 9 | ||||
96453 | 111065 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | ||||
137179 | 111064 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | |||
52000 | 106170 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 | |||
172870 | 117258 | Undocumented 4 | Tree(s) :: 17 | 99X PROSPER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6003339 | 2106236 | 37.7635115803019 | -122.431624896471 | (37.7635115803019, -122.431624896471) | 15 | 4 | 5 | 28862 | 3 | ||||
99985 | 101898 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | 5 | 1 | 10 | 308 | 32 | |||||
129291 | 101899 | Undocumented 4 | Cedrus deodara :: Deodar Cedar 109 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | 5 | 1 | 10 | 308 | 32 | |||||
96237 | 121608 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
153155 | 121606 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
186126 | 121607 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
134437 | 106104 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 6002644 | 2105609 | 37.7617505722061 | -122.433983855891 | (37.7617505722061, -122.433983855891) | 15 | 4 | 5 | 28862 | 3 | |||
2335 | 262272 | Undocumented 4 | Tree(s) :: 17 | 99X Glendale St | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
36150 | 113586 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | 6011271 | 2095434 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | 10 | 3 | 8 | 58 | 1 | |||
183393 | 113369 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x9 | 6009304 | 2096928 | 37.7382901856605 | -122.410336525414 | (37.7382901856605, -122.410336525414) | 10 | 7 | 7 | 28859 | 2 | |||
69625 | 102708 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 999X PHELPS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744 | 2097272 | 37.7395381878784 | -122.391551574015 | (37.7395381878784, -122.391551574015) | 10 | 3 | 8 | 58 | 1 | |
143371 | 102709 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 999X PHELPS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744 | 2097272 | 37.7395381878784 | -122.391551574015 | (37.7395381878784, -122.391551574015) | 10 | 3 | 8 | 58 | 1 | |
81713 | 109645 | Undocumented 4 | Acacia decurrens :: Acacia: Silver Wattle 111 | 999X PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2109394 | 37.7720977038705 | -122.437028639855 | (37.7720977038705, -122.437028639855) | 15 | 5 | 11 | 29492 | 9 | ||||
82376 | 117621 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 999X BRAZIL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004288 | 2090756 | 37.7210607924735 | -122.427239868866 | (37.7210607924735, -122.427239868866) | 9 | 7 | 6 | 28861 | 5 | |||
122369 | 117625 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 999X BRAZIL AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6004288 | 2090756 | 37.7210607924735 | -122.427239868866 | (37.7210607924735, -122.427239868866) | 9 | 7 | 6 | 28861 | 5 | |||
139703 | 117623 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 999X BRAZIL AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004288 | 2090756 | 37.7210607924735 | -122.427239868866 | (37.7210607924735, -122.427239868866) | 9 | 7 | 6 | 28861 | 5 | |||
111383 | 106448 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 999 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002658 | 2110219 | 37.7744092970816 | -122.434265023957 | (37.7744092970816, -122.434265023957) | 15 | 5 | 11 | 29492 | 10 | |||||
47056 | 122449 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
154909 | 122450 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
158983 | 122451 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998x Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008865 | 2090425 | 37.7204097170763 | -122.411395091465 | (37.7204097170763, -122.411395091465) | 9 | 3 | 7 | 309 | 28 | ||||
94546 | 113832 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 998X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007963 | 2102149 | 37.7525506242512 | -122.415342560511 | (37.7525506242512, -122.415342560511) | 2 | 4 | 7 | 28859 | 19 | |||
24114 | 116895 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
124474 | 116896 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
70765 | 121597 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 998X Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000144 | 2102038 | 37.7518032865281 | -122.442373952551 | (37.7518032865281, -122.442373952551) | 2 | 4 | 5 | 28862 | 22 | ||||
114634 | 121596 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 998X Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000144 | 2102038 | 37.7518032865281 | -122.442373952551 | (37.7518032865281, -122.442373952551) | 2 | 4 | 5 | 28862 | 22 | ||||
85986 | 134827 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 991 Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007349.29025 | 2120528.21446 | 37.8029810213102 | -122.418768198988 | (37.8029810213102, -122.418768198988) | 5 | 1 | 1 | 28858 | 32 | |||
72158 | 113805 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 990X OSHAUGHNESSY BLVD | 2 | Front Yard : Yard | Tree | Rec/Park 5 | 3x30 | 6000025 | 2096199 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | 9 | 7 | 4 | 63 | 40 | ||||
122223 | 113804 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x30 | 6000025 | 2096199 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | 9 | 7 | 4 | 63 | 40 | ||||
25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
95460 | 118310 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
186957 | 118311 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 990 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||||
59664 | 115245 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | 3 | 1 | 10 | 308 | 4 | |||
132258 | 115247 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 990 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | 3 | 1 | 10 | 308 | 4 | |||
189547 | 115246 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | 3x3 | 6009439.8 | 2118094.4 | 37.7964158497349 | -122.411361881702 | (37.7964158497349, -122.411361881702) | 3 | 1 | 10 | 308 | 4 | |||
2279 | 264803 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 99 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010906 | 2089373 | 37.7176354050598 | -122.404265973296 | (37.7176354050598, -122.404265973296) | 10 | 7 | 8 | 309 | 39 | ||||
10020 | 264802 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 99 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010906 | 2089373 | 37.7176354050598 | -122.404265973296 | (37.7176354050598, -122.404265973296) | 10 | 7 | 8 | 309 | 39 | ||||
99114 | 122757 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 99 Park Hill Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x5 | 6001111 | 2107407 | 37.766600319422 | -122.439414765245 | (37.766600319422, -122.439414765245) | 15 | 5 | 5 | 29492 | 3 | |||
119597 | 122758 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 99 Park Hill Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x5 | 6001111 | 2107407 | 37.766600319422 | -122.439414765245 | (37.766600319422, -122.439414765245) | 15 | 5 | 5 | 29492 | 3 | |||
57017 | 255393 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 99 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2018 04:52:00 AM | 3 | 3x9 | 5999596 | 2089282 | 37.7167470609644 | -122.443352863315 | (37.7167470609644, -122.443352863315) | 9 | 7 | 6 | 28861 | 25 | ||
124557 | 108626 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 LYELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003201 | 2094452 | 37.7311476483304 | -122.431260994556 | (37.7311476483304, -122.431260994556) | 9 | 7 | 5 | 28861 | 25 | ||||
39584 | 256022 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 99 Heron St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
95858 | 256023 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99 Heron St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
128814 | 256024 | Undocumented 4 | Acer buergeranum :: Trident Maple 110 | 99 Heron St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
55876 | 122756 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 99 Fernwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | 3x3 | 5994769 | 2095318 | 37.7330440171503 | -122.460474420297 | (37.7330440171503, -122.460474420297) | 9 | 8 | 4 | 59 | 40 | |||
12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
46282 | 110937 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
84958 | 110935 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | |||
153970 | 110938 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
188520 | 110936 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 98x WILMOT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003200 | 2115008 | 37.7875894402279 | -122.432732318133 | (37.7875894402279, -122.432732318133) | 13 | 9 | 11 | 29490 | 27 | ||||
158117 | 107675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 98x LUNDYS LN | 1 | Unaccepted Street : Yard | Tree | Private 2 | 14 | 8x10 | 6006855 | 2099015 | 37.7438830341993 | -122.418951960739 | (37.7438830341993, -122.418951960739) | 2 | 7 | 7 | 28859 | 2 | |||
192657 | 73935 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 98x LANDERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1984 12:00:00 AM | 13 | 3x3 | 6004473 | 2107480 | 37.7669915173508 | -122.427791394155 | (37.7669915173508, -122.427791394155) | 8 | 4 | 5 | 28862 | 3 | |
66147 | 111283 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 98X THOR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 |
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) );