trees
1,732 rows where qLegalStatus_id = 6 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189234 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
193693 | 255496 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2100 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 5999950 | 2111978 | 37.7790849877594 | -122.443758873408 | (37.7790849877594, -122.443758873408) | 15 | 5 | 1 | 29490 | 16 | |||||
194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
2008 | 106059 | Significant Tree 6 | Salix spp :: Willow 203 | 339 FILBERT ST | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6011263.6 | 2119947.8 | 37.801606957686 | -122.405181687156 | (37.801606957686, -122.405181687156) | 3 | 1 | 10 | 308 | 23 | ||||
4419 | 260950 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
5983 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 131X Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.7962664536588 | -122.397554954018 | (37.7962664536588, -122.397554954018) | 3 | 1 | 10 | 28860 | 6 | |
12731 | 107057 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 601X Davis St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 9 | Permit Number 771755 | 6013145.32204 | 2118507.86888 | 37.7977582696821 | -122.398568926718 | (37.7977582696821, -122.398568926718) | 3 | 1 | 10 | 28860 | 6 | ||
13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
16781 | 260951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 190 Jackson St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6013038 | 2118237 | 37.7970085486816 | -122.398921272101 | (37.7970085486816, -122.398921272101) | 3 | 1 | 10 | 28860 | 6 | ||||
18276 | 119614 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 2X Sutter St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012582 | 2115890 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | 4 | 1 | 10 | 28854 | 6 | ||||
19052 | 260948 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 370 Drumm St | 1 | Side Yard : Yard | Tree | Private 2 | 6013616 | 2118213 | 37.7969748404412 | -122.396919555024 | (37.7969748404412, -122.396919555024) | 3 | 1 | 10 | 28860 | 6 | |||||
34175 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | |||||
34754 | 101438 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
40158 | 253917 | Significant Tree 6 | Eriobotrya japonica :: Edible Loquat 119 | 1819 Mason St | 1 | Front Yard : Yard | Tree | Private 2 | 6009087 | 2119549 | 37.8003900283184 | -122.412685532944 | (37.8003900283184, -122.412685532944) | 3 | 1 | 10 | 308 | 32 | |||||
44600 | 107186 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
45867 | 107185 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 10 Florence St | 1 | Front Yard : Cutout | Tree | Private 2 | Permit Number 773363 | 6008515.42073 | 2118375.20615 | 37.7971349853662 | -122.41458032272 | (37.7971349853662, -122.41458032272) | 5 | 1 | 10 | 308 | 21 | ||||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
55812 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348649 | (37.7959312951427, -122.42262348649) | 13 | 9 | 10 | 28858 | 32 | ||
63716 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.7959053703882 | -122.422808406898 | (37.7959053703882, -122.422808406898) | 13 | 9 | 10 | 28858 | 32 | ||
64053 | 96906 | Significant Tree 6 | Ulmus 'Frontier' :: Frontier Elm 115 | 1155@Sansome Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 08/05/2011 12:00:00 AM | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | ||
65969 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
70862 | 115250 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1404x Mason St | 1 | Front Yard : Yard | Tree | Private 2 | 01/20/2016 12:00:00 AM | 6009352.6 | 2118074.7 | 37.7963568672402 | -122.41166222086 | (37.7963568672402, -122.41166222086) | 3 | 1 | 10 | 308 | 4 | ||||
76886 | 106942 | Significant Tree 6 | Tree(s) :: 17 | 1300@ Embarcadero Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 07/02/2014 12:00:00 AM | Permit Number 772680 | 6012231.9986 | 2120618.97397 | 37.8035039293343 | -122.401877773891 | (37.8035039293343, -122.401877773891) | 3 | 1 | 10 | 28860 | 6 | |||
80305 | 111179 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 400 NORTH POINT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 9x6 | 6008572 | 2121805 | 37.806555520543 | -122.414627380808 | (37.806555520543, -122.414627380808) | 3 | 1 | 10 | 308 | 23 | ||
84037 | 107611 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470x Broadway | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 774041 | 6011286.02608 | 2118707.45024 | 37.7982025127238 | -122.40501669829 | (37.7982025127238, -122.40501669829) | 3 | 1 | 10 | 308 | 23 | ||||
84386 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1155@Sansome Battery St | 3 | Front Yard : Yard | Tree | Private 2 | Plaza | Permit Number 768022 | 6012245 | 2120028 | 37.8018819838627 | -122.401791216362 | (37.8018819838627, -122.401791216362) | 3 | 1 | 10 | 28860 | 6 | |||
89552 | 107399 | Significant Tree 6 | Tree(s) :: 17 | 1300X Sansome St | 1 | Front Yard : Yard | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | Permit Number 772689 | 6012222 | 2120529 | 37.8032563246841 | -122.401906046114 | (37.8032563246841, -122.401906046114) | 3 | 1 | 10 | 28860 | 6 | ||
93882 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1155@Sansome Battery St | 2 | Front Yard : Yard | Tree | Private 2 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | 3 | 1 | 10 | 28860 | 6 | ||
97189 | 114476 | Significant Tree 6 | Pittosporum spp :: Pittosporum spp 170 | 299x UNION ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/29/2015 12:00:00 AM | 6011527 | 2119680 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | 3 | 1 | 10 | 308 | 23 | ||||
100360 | 107056 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 601X Davis St | 1 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 12 | Permit Number 771755 | 6013142.97136 | 2118525.31961 | 37.7978060542679 | -122.39857828598 | (37.7978060542679, -122.39857828598) | 3 | 1 | 10 | 28860 | 6 | ||
101055 | 119613 | Significant Tree 6 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 2X Sutter St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 6012582 | 2115890 | 37.7905388243453 | -122.400334219916 | (37.7905388243453, -122.400334219916) | 4 | 1 | 10 | 28854 | 6 | |||
101661 | 257928 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 101 Lombard St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 6ft | 6011760.21977 | 2120791.0173 | 37.8039499778675 | -122.403522505873 | (37.8039499778675, -122.403522505873) | 3 | 1 | 10 | 28860 | 6 | ||||
104435 | 106173 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 267 Green St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 771881 | 6011670.8 | 2119368.7 | 37.8000396459541 | -122.403731811098 | (37.8000396459541, -122.403731811098) | 3 | 1 | 10 | 308 | 23 | ||||
106637 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
111290 | 106058 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 301 FILBERT ST | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 6011273 | 2120044 | 37.8018716248897 | -122.405155936594 | (37.8018716248897, -122.405155936594) | 3 | 1 | 10 | 308 | 23 | ||||
126483 | 106838 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 735 Battery St | 1 | Front Yard : Pot | Tree | Private 2 | Permit Number 773117 | 6012413.67639 | 2118682.92207 | 37.7981981357359 | -122.401112945062 | (37.7981981357359, -122.401112945062) | 3 | 1 | 10 | 28860 | 6 | ||||
127351 | 101436 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
129267 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 600 Front St | Front Yard : Yard | Tree | Private 2 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.399449857041 | (37.7974274520849, -122.399449857041) | 3 | 1 | 10 | 28860 | 6 | ||||
139061 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 720 BATTERY ST | 1 | unknown : Yard | Tree | Private 2 | 6012486 | 2118560 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | 3 | 1 | 10 | 28860 | 6 | |||||
140481 | 101742 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1590 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | 8 | Permit Number 769428 | 6006220.99461 | 2117990.30451 | 37.7959489722299 | -122.422492252021 | (37.7959489722299, -122.422492252021) | 13 | 9 | 10 | 28858 | 32 | ||
142994 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1735x GRANT AVE | 1 | Back Yard : Yard | Tree | Private 2 | 6010373 | 2120454 | 37.8029470287696 | -122.408299306743 | (37.8029470287696, -122.408299306743) | 3 | 1 | 10 | 308 | 23 | |||||
144153 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | ||
150077 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
155139 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
161031 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
172328 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.7959478507639 | -122.422745597666 | (37.7959478507639, -122.422745597666) | 13 | 9 | 10 | 28858 | 32 | |||
175229 | 107058 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 600X Front St | 2 | Front Yard : Yard | Tree | Private 2 | 07/23/2014 12:00:00 AM | 14 | Permit Number 771755 | 6012887.2102 | 2118277.80134 | 37.797112176041 | -122.399445910496 | (37.797112176041, -122.399445910496) | 3 | 1 | 10 | 28860 | 6 | ||
191590 | 107016 | Significant Tree 6 | Tree(s) :: 17 | 945 SACRAMENTO ST | 1 | Front Yard : Yard | Tree | Private 2 | 01/24/2015 12:00:00 AM | Permit Number 773422 | 6010352.6 | 2116759.1 | 37.7928005931964 | -122.408109164657 | (37.7928005931964, -122.408109164657) | 3 | 1 | 10 | 28857 | 4 | |||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
3436 | 103654 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
5712 | 258876 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Hayes St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 0ft | 6001504 | 2110473 | 37.7750411502564 | -122.438275119801 | (37.7750411502564, -122.438275119801) | 15 | 5 | 11 | 29492 | 10 | ||||
12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
14733 | 255398 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 637 MASONIC AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999139.3301 | 2110590.1819 | 37.7752281241925 | -122.446463429304 | (37.7752281241925, -122.446463429304) | 15 | 5 | 11 | 29492 | 16 | ||||
14822 | 96765 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 184 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 07/12/2011 12:00:00 AM | Permit Number 767998 | 5996632 | 2105999 | 37.7624783944866 | -122.454805014883 | (37.7624783944866, -122.454805014883) | 15 | 5 | 11 | 29492 | 12 | |||
15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
15509 | 258701 | Significant Tree 6 | Tree(s) :: 17 | 206 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783089 | 5996625 | 2105876 | 37.7621402663071 | -122.454820337862 | (37.7621402663071, -122.454820337862) | 15 | 5 | 11 | 29492 | 12 | |
15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
15969 | 261831 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 1507 Cole St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5998279 | 2105297 | 37.7606452154312 | -122.449058098094 | (37.7606452154312, -122.449058098094) | 15 | 5 | 11 | 29492 | 12 | ||||
17108 | 105086 | Significant Tree 6 | :: 45 | 344 Fulton St | 6 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
17242 | 253971 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
17502 | 260902 | Significant Tree 6 | Populus alba :: White Poplar 184 | 1901 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
18711 | 262449 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 155 Baker St | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 6000750.251 | 2109577.8851 | 37.7725404908768 | -122.440818271359 | (37.7725404908768, -122.440818271359) | 15 | 5 | 11 | 29492 | 9 | ||||
20021 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
20207 | 105239 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 6 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
21449 | 255662 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 1626 Shrader St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | Permit Number 782137 | 5998119 | 2105007 | 37.759839795982 | -122.44959056596 | (37.759839795982, -122.44959056596) | 15 | 5 | 11 | 29492 | 12 | |||
22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
22312 | 116999 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 2 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
24761 | 101258 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1049 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992548 | 2106581 | 37.7638413023971 | -122.468972303767 | (37.7638413023971, -122.468972303767) | 1 | 8 | 11 | 56 | 12 | ||||
25451 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
25777 | 257968 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
27012 | 255276 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 263 Willow St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 6006404.75096 | 2113360.62408 | 37.7832473828943 | -122.421527451234 | (37.7832473828943, -122.421527451234) | 7 | 9 | 11 | 28858 | 41 | ||||
27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
29114 | 103653 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
35924 | 89310 | Significant Tree 6 | Tree(s) :: 17 | 32 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780094 | 6000399 | 2109002 | 37.7709392449299 | -122.441991937871 | (37.7709392449299, -122.441991937871) | 15 | 5 | 11 | 29492 | 9 | |
36041 | 255248 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
36670 | 87156 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 237 Rivoli St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50138 | 5997662 | 2105892 | 37.7622436280127 | -122.451234923187 | (37.7622436280127, -122.451234923187) | 15 | 5 | 11 | 29492 | 9 | ||||
37143 | 257967 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499X Carl St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5995946 | 2106884 | 37.7648690031923 | -122.457241646887 | (37.7648690031923, -122.457241646887) | 15 | 5 | 11 | 29492 | 12 | ||||
37603 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
38032 | 110839 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 | ||||
41224 | 258232 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||
44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
50301 | 254481 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1274 11th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5992738 | 2106820 | 37.7645085090972 | -122.468332545675 | (37.7645085090972, -122.468332545675) | 11 | 8 | 11 | 56 | 12 | ||||
51498 | 88569 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 60 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
53621 | 258239 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
59354 | 102987 | Significant Tree 6 | Quercus palustris :: Pin Oak 379 | 161 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769930 | 5996558.2 | 2106100.3 | 37.7627523048829 | -122.455067580852 | (37.7627523048829, -122.455067580852) | 15 | 5 | 11 | 29492 | 12 | ||||
60074 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 7 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
60332 | 112420 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 2 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
61598 | 99299 | Significant Tree 6 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 1457 Willard St | 1 | Front Yard : | Tree | Private 2 | 05/02/2012 12:00:00 AM | Permit Number 768720 | 5996809.7 | 2106270.3 | 37.763233506694 | -122.454210015753 | (37.763233506694, -122.454210015753) | 15 | 5 | 11 | 29492 | 12 | |||
62810 | 110841 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 6000252 | 2111948 | 37.7790198360362 | -122.442711981138 | (37.7790198360362, -122.442711981138) | 15 | 5 | 11 | 29490 | 16 |
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) );