trees
67 rows where Police Districts = 1 and qLegalStatus_id = 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |
6580 | 261206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Leavenworth St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
8743 | 261207 | Significant Tree 6 | Umbellularia californica :: California Bay 326 | 2301 Leavenworth St | 3 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
9964 | 262274 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Montclair Ter | 1 | Side Yard : Yard | Tree | Private 2 | 6007298.70359 | 2120216.09204 | 37.8021211637502 | -122.418921105258 | (37.8021211637502, -122.418921105258) | 5 | 1 | 1 | 28858 | 32 | |||||
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 | ||||
15016 | 261205 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2301 Leavenworth St | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
32951 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 4 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
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 | |||
51973 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 773092 | 6006825 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | 5 | 1 | 1 | 28858 | 32 | |||
61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 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 | ||||
70399 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 96 | 930 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6007386.5238 | 2120591.43483 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | 5 | 1 | 1 | 28858 | 32 | |||
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 | ||||
71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | ||
80380 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060 | 2120781 | 37.8036588138585 | -122.41978724304 | (37.8036588138585, -122.41978724304) | 5 | 1 | 1 | 28858 | 32 | ||
83429 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 1275 Columbus Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
83898 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 2 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
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 | ||
93101 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | ||||
103238 | 121134 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 2 | Front Yard : Yard | Tree | Private 2 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | ||||
115879 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 5 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
123789 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 3 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
124108 | 258218 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1000 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6005937.91741 | 2121414.48699 | 37.8053349315385 | -122.423715341013 | (37.8053349315385, -122.423715341013) | 5 | 1 | 1 | 28858 | 32 | |||||
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 | |||||
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 | |||||
143771 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
147624 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | 5 | 1 | 1 | 28858 | 32 | |||
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 | ||||
151937 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||||
157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
157788 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||||
163986 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | |||
167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
171699 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.52821 | 37.8031223210123 | -122.418746939923 | (37.8031223210123, -122.418746939923) | 5 | 1 | 1 | 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 | ||
178107 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
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 |
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) );