trees
16 rows where Neighborhoods (old) = 9 and qSpecies_id = 143
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17453 | 247523 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1101 Waller St | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6000011.18383 | 2108488.88375 | 37.769508249328 | -122.443296539598 | (37.769508249328, -122.443296539598) | 15 | 5 | 11 | 29492 | 9 | ||||
| 24643 | 233985 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 524 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5998610.01706 | 2106121.66353 | 37.7629284612055 | -122.447972640126 | (37.7629284612055, -122.447972640126) | 15 | 5 | 11 | 29492 | 9 | |||
| 33797 | 248507 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 130 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999267.956 | 2107716.9114 | 37.7673461983853 | -122.445811798931 | (37.7673461983853, -122.445811798931) | 15 | 5 | 11 | 29492 | 9 | |||
| 36544 | 88462 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 815 Buena Vista West Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2008 12:00:00 AM | 3x3 | Permit Number 51420 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
| 43661 | 233990 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 36 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998337.94426 | 2106576.71217 | 37.7641623544426 | -122.448946422455 | (37.7641623544426, -122.448946422455) | 15 | 5 | 11 | 29492 | 9 | |||
| 64435 | 248506 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 130 Frederick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999287.9427 | 2107719.9397 | 37.7673556545062 | -122.445742885801 | (37.7673556545062, -122.445742885801) | 15 | 5 | 11 | 29492 | 9 | |||
| 66559 | 233977 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 79 Scott St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002355.60896 | 2108678.85755 | 37.7701632795355 | -122.435200866851 | (37.7701632795355, -122.435200866851) | 15 | 5 | 5 | 29492 | 9 | |||
| 86630 | 233987 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 516 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998601.66076 | 2106187.38756 | 37.7631084452326 | -122.448006273897 | (37.7631084452326, -122.448006273897) | 15 | 5 | 11 | 29492 | 9 | |||
| 96008 | 233986 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 524 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 5998609.24404 | 2106138.43946 | 37.7629744795115 | -122.447976521626 | (37.7629744795115, -122.447976521626) | 15 | 5 | 11 | 29492 | 9 | |||
| 107845 | 233989 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 577 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998615.03299 | 2105838.59692 | 37.7621515180031 | -122.447934910876 | (37.7621515180031, -122.447934910876) | 15 | 5 | 11 | 29492 | 9 | |||
| 128015 | 233991 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 252 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999009.85314 | 2106698.21052 | 37.764534361698 | -122.44663123474 | (37.764534361698, -122.44663123474) | 15 | 5 | 11 | 29492 | 9 | |||
| 134456 | 248505 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 130 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999316.1058 | 2107725.6935 | 37.7673730609399 | -122.445645887747 | (37.7673730609399, -122.445645887747) | 15 | 5 | 11 | 29492 | 9 | |||
| 134766 | 233988 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 575 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/1969 12:00:00 AM | 17 | Width 4ft | Permit Number 6238 | 5998611.18796 | 2105870.92024 | 37.7622400499559 | -122.447950536602 | (37.7622400499559, -122.447950536602) | 15 | 5 | 11 | 29492 | 9 | |
| 171981 | 233976 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 85 Scott St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 6002352.16344 | 2108701.24422 | 37.7702245521494 | -122.435214386342 | (37.7702245521494, -122.435214386342) | 15 | 5 | 5 | 29492 | 9 | |||
| 174966 | 88461 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 815 Buena Vista West Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2008 12:00:00 AM | 3x3 | Permit Number 51420 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
| 189474 | 247531 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1101 Waller St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6000098.46541 | 2108483.59021 | 37.7694986913322 | -122.442994256792 | (37.7694986913322, -122.442994256792) | 15 | 5 | 11 | 29492 | 9 |
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) );