trees
12 rows where Neighborhoods (old) = 12 and qLegalStatus_id = 8 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
22075 | 187658 | Property Tree 8 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 600X Clarendon Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995637 | 2102382 | 37.7524899085688 | -122.457984564932 | (37.7524899085688, -122.457984564932) | 1 | 5 | 4 | 63 | 12 | ||||
28314 | 256608 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
46471 | 253626 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1671 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5992125 | 2104081 | 37.7569525124502 | -122.470253253306 | (37.7569525124502, -122.470253253306) | 1 | 8 | 4 | 56 | 12 | ||||
56515 | 102470 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1021 Kirkham St | 2 | Back Yard : Yard | Tree | Private 2 | 5991773 | 2105198 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | 1 | 8 | 4 | 56 | 12 | |||||
87678 | 254111 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 279 Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5995764 | 2102990 | 37.7541666190925 | -122.457589367448 | (37.7541666190925, -122.457589367448) | 1 | 5 | 4 | 63 | 12 | ||||
101829 | 257926 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 8 Hill Point Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5996384 | 2106804 | 37.7646744896132 | -122.455720942569 | (37.7646744896132, -122.455720942569) | 15 | 5 | 11 | 29492 | 12 | ||||
134313 | 255008 | Property Tree 8 | Pittosporum undulatum :: Victorian Box 36 | 1 Villa Ter | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5998933 | 2105018 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | 15 | 5 | 5 | 28862 | 12 | ||||
134592 | 102469 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1021 Kirkham St | 1 | Back Yard : Yard | Tree | Private 2 | 5991773 | 2105198 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | 1 | 8 | 4 | 56 | 12 | |||||
161514 | 253207 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 89 Woodhaven Ct | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5996069 | 2103645 | 37.7559825991437 | -122.456581972884 | (37.7559825991437, -122.456581972884) | 1 | 5 | 4 | 63 | 12 | ||||
177432 | 102706 | Property Tree 8 | Cupressus macrocarpa :: Monterey Cypress 41 | 1342 Funston Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | 1 | 8 | 11 | 56 | 12 | |||||
178160 | 173600 | Property Tree 8 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996184 | 2102497 | 37.7528370823128 | -122.456101271869 | (37.7528370823128, -122.456101271869) | 1 | 5 | 4 | 63 | 12 |
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) );