trees
19 rows where qLegalStatus_id = 4 and qSpecies_id = 100 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35285 | 110616 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 182X LOWER TER | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999820 | 2106230 | 37.7632950157782 | -122.44379552503 | (37.7632950157782, -122.44379552503) | 15 | 5 | 5 | 29492 | 3 | |||||
54825 | 110699 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
60871 | 110703 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
61690 | 106324 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 800 INDIANA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | ||||
61835 | 110697 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
80145 | 110707 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
93191 | 110709 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 15 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
98050 | 110259 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 655 SANCHEZ ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003729.2 | 2104438 | 37.7585968119418 | -122.430147043342 | (37.7585968119418, -122.430147043342) | 2 | 4 | 5 | 28862 | 3 | |||||
99587 | 110713 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
107393 | 98343 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999x Turk St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/01/2012 12:00:00 AM | 5x3 | Permit Number 768613 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||
116302 | 110705 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
125688 | 117419 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 452 OAK ST | 1 | Front Yard : Yard | Tree | Private 2 | 6004802 | 2110240 | 37.774588415373 | -122.426850015779 | (37.774588415373, -122.426850015779) | 7 | 9 | 11 | 28852 | 10 | |||||
154648 | 110701 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
165349 | 110711 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 2999X Turk St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5x3 | 5996638 | 2111487 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | 15 | 6 | 2 | 54 | 16 | ||||
167631 | 112904 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 727 BURNETT AVE | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999303 | 2101616 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | 2 | 5 | 5 | 63 | 38 | |||||
175590 | 110271 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 298X 28TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004269 | 2099559 | 37.7452307768148 | -122.427932506483 | (37.7452307768148, -122.427932506483) | 2 | 7 | 5 | 63 | 22 | ||||
177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
182249 | 173897 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 90x Knollview Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997593 | 2101480 | 37.7501254274205 | -122.451155378281 | (37.7501254274205, -122.451155378281) | 1 | 5 | 4 | 63 | 38 |
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) );