trees
11 rows where Neighborhoods (old) = 29 and qLegalStatus_id = 9
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 675 | 150019 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.62882 | 2105456.11878 | 37.7620514180509 | -122.389544911688 | (37.7620514180509, -122.389544911688) | 10 | 3 | 8 | 28856 | 29 | |
| 1077 | 149677 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011154.9566 | 2106050.92707 | 37.7634433311543 | -122.404578819881 | (37.7634433311543, -122.404578819881) | 8 | 3 | 8 | 28856 | 29 | |
| 3212 | 150016 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.18586 | 2105386.64383 | 37.7618609074738 | -122.389524298311 | (37.7618609074738, -122.389524298311) | 10 | 3 | 8 | 28856 | 29 | |
| 3416 | 262187 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 4 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 8842 | 150020 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015489.50926 | 2105477.62507 | 37.7621104630605 | -122.389546827243 | (37.7621104630605, -122.389546827243) | 10 | 3 | 8 | 28856 | 29 | |
| 8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 14649 | 150018 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015492.47093 | 2105432.35195 | 37.7619863170408 | -122.389533421936 | (37.7619863170408, -122.389533421936) | 10 | 3 | 8 | 28856 | 29 | |
| 15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
| 18413 | 149679 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 3 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 19354 | 262188 | Private 9 | Jacaranda mimosifolia :: Jacaranda 50 | 490 Vermont St | 1 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784452 | 6011166 | 2106075 | 37.7635100471883 | -122.404542318782 | (37.7635100471883, -122.404542318782) | 8 | 3 | 8 | 28856 | 29 | |
| 142770 | 150735 | Private 9 | Cordyline australis :: Dracena Palm 64 | 783 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 778950 | 6012760.80751 | 2103885.27159 | 37.7575865350131 | -122.398872659244 | (37.7575865350131, -122.398872659244) | 10 | 3 | 8 | 28856 | 29 |
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) );