trees
37 rows where Fire Prevention Districts = 3, 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 | |
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||||
| 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 | |||||
| 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 | |||||
| 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 |
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) );