trees
18 rows where Police Districts = 7 and qLegalStatus_id = 5
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
| 2103 | 262299 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
| 3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
| 3533 | 263634 | Section 806 (d) 5 | Tree(s) :: 17 | 211 Sawyer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/2020 12:00:00 AM | 3 | 3x3 | 6008194.27066 | 2088426.33179 | 37.71488415001 | -122.413572307092 | (37.71488415001, -122.413572307092) | 9 | 7 | 8 | 309 | 39 | ||
| 6139 | 264669 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
| 6318 | 261662 | Section 806 (d) 5 | Aesculus californica :: California Buckeye 168 | 137 Elsie St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/13/2020 12:00:00 AM | 3 | 6007155.81154 | 2098485.15545 | 37.7424451335194 | -122.417874270912 | (37.7424451335194, -122.417874270912) | 2 | 7 | 7 | 28859 | 2 | |||
| 9107 | 264723 | Section 806 (d) 5 | Pistacia chinensis :: Chinese Pistache 32 | 335 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782646 | 6008658.96802 | 2100212.34216 | 37.7472720863526 | -122.412798868954 | (37.7472720863526, -122.412798868954) | 2 | 7 | 7 | 28859 | 2 | |
| 10736 | 262270 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 4 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 12694 | 262268 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 2 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 14968 | 262269 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 3 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 15098 | 169494 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 1890 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 770415 | 6004581.61952 | 2097649.26106 | 37.7400047512279 | -122.426715548384 | (37.7400047512279, -122.426715548384) | 2 | 7 | 5 | 63 | 7 | |
| 15368 | 262300 | Section 806 (d) 5 | Lagunaria patersonii :: Primrose Tree 6 | 209 Prentiss St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2020 12:00:00 AM | 3 | 3x3 | Permit Number 773443 | 6008837.63968 | 2097618.9316 | 37.7401611793174 | -122.411997789374 | (37.7401611793174, -122.411997789374) | 10 | 7 | 7 | 28859 | 2 | |
| 16257 | 225172 | Section 806 (d) 5 | Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | 4x4 | Permit Number 779647 | 6006535.62128 | 2098220.14009 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | 2 | 7 | 7 | 28859 | 2 | |
| 16264 | 111321 | Section 806 (d) 5 | Acacia melanoxylon :: Blackwood Acacia 70 | 1X Peabody St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6010185.88551 | 2087316.24933 | 37.7119477217782 | -122.406610237293 | (37.7119477217782, -122.406610237293) | 9 | 7 | 8 | 309 | 39 | ||||
| 16422 | 262267 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 17710 | 169495 | Section 806 (d) 5 | Prunus subhirtella 'autumnalis' :: Higan Cherry 297 | 150 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 770415 | 6004561.3283 | 2097566.6275 | 37.7397767110236 | -122.426779823841 | (37.7397767110236, -122.426779823841) | 2 | 7 | 5 | 63 | 7 | |
| 194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
| 194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 |
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) );