trees
13 rows where Neighborhoods (old) = 1 and qLegalStatus_id = 5 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18330 | 97157 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | 10 | 3 | 8 | 58 | 1 | ||
| 33 | 261067 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1832 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782484 | 6011934 | 2092960 | 37.727541965346 | -122.400964507068 | (37.727541965346, -122.400964507068) | 10 | 3 | 8 | 58 | 1 | |
| 4387 | 264910 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 1615 Wallace Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 11/04/2020 12:00:00 AM | 3 | 4x4 | Permit Number 775989 | 6014687.7877 | 2092924.6213 | 37.7275980500808 | -122.391442091837 | (37.7275980500808, -122.391442091837) | 10 | 3 | 8 | 58 | 1 | |
| 6293 | 97158 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.397943616401 | (37.7189762599209, -122.397943616401) | 10 | 3 | 8 | 58 | 1 | ||
| 6880 | 24222 | Section 806 (d) 5 | Quercus suber :: Cork Oak 78 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.382882921904 | (37.7334154068844, -122.382882921904) | 10 | 3 | 8 | 58 | 1 | |
| 8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
| 8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
| 10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
| 12625 | 97159 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.60574 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | 10 | 3 | 8 | 58 | 1 | ||
| 12626 | 97156 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.398022907844 | (37.7190195469812, -122.398022907844) | 10 | 3 | 8 | 58 | 1 | ||
| 18014 | 117148 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | 10 | 3 | 8 | 58 | 1 | |
| 18353 | 97155 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.95173 | 37.7190672497343 | -122.398087681509 | (37.7190672497343, -122.398087681509) | 10 | 3 | 8 | 58 | 1 | ||
| 6990 | 97154 | Section 806 (d) 5 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | 10 | 3 | 8 | 58 | 1 |
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) );