trees
18 rows where Neighborhoods (old) = 25 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35895 | 178404 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001626.60618 | 2094150.6328 | 37.7302308148923 | -122.436682376683 | (37.7302308148923, -122.436682376683) | 9 | 7 | 6 | 28861 | 25 | ||||
| 47540 | 178414 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6001625.71874 | 2094150.12483 | 37.7302293696897 | -122.436685408329 | (37.7302293696897, -122.436685408329) | 9 | 7 | 6 | 28861 | 25 | ||||
| 57539 | 178401 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6001606.4733 | 2094132.41207 | 37.7301796407671 | -122.436750674803 | (37.7301796407671, -122.436750674803) | 9 | 7 | 6 | 28861 | 25 | ||||
| 64599 | 178420 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 164 Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000582.8572 | 2092343.33574 | 37.7252090212659 | -122.440161196294 | (37.7252090212659, -122.440161196294) | 9 | 7 | 6 | 28861 | 25 | |||
| 71065 | 178402 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6001615.13724 | 2094139.06666 | 37.7301984051332 | -122.436721198652 | (37.7301984051332, -122.436721198652) | 9 | 7 | 6 | 28861 | 25 | ||||
| 83578 | 178415 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001633.0697 | 2094156.39849 | 37.730247013477 | -122.436660444024 | (37.730247013477, -122.436660444024) | 9 | 7 | 6 | 28861 | 25 | ||||
| 100190 | 178417 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6001651.54923 | 2094173.30469 | 37.7302944841952 | -122.436597767571 | (37.7302944841952, -122.436597767571) | 9 | 7 | 6 | 28861 | 25 | ||||
| 101762 | 178405 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6001634.24365 | 2094157.92996 | 37.7302512852578 | -122.436656495109 | (37.7302512852578, -122.436656495109) | 9 | 7 | 6 | 28861 | 25 | ||||
| 102274 | 178416 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6001641.53674 | 2094164.63815 | 37.7302701188701 | -122.436631761946 | (37.7302701188701, -122.436631761946) | 9 | 7 | 6 | 28861 | 25 | ||||
| 108250 | 178418 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6001657.79965 | 2094178.37716 | 37.7303087672308 | -122.43657652199 | (37.7303087672308, -122.43657652199) | 9 | 7 | 6 | 28861 | 25 | ||||
| 110033 | 178406 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001639.75964 | 2094163.19973 | 37.7302660683079 | -122.436637802688 | (37.7302660683079, -122.436637802688) | 9 | 7 | 6 | 28861 | 25 | ||||
| 118123 | 178413 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6001621.7877 | 2094145.76947 | 37.7302171874661 | -122.43669868679 | (37.7302171874661, -122.43669868679) | 9 | 7 | 6 | 28861 | 25 | ||||
| 120885 | 178419 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 164 Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000583.99969 | 2092347.99835 | 37.7252218887704 | -122.440157581032 | (37.7252218887704, -122.440157581032) | 9 | 7 | 6 | 28861 | 25 | |||
| 154998 | 178408 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6001651.19856 | 2094173.31719 | 37.7302944985896 | -122.436598980777 | (37.7302944985896, -122.436598980777) | 9 | 7 | 6 | 28861 | 25 | ||||
| 164364 | 178403 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6001622.1469 | 2094146.16948 | 37.7302183062155 | -122.436697473612 | (37.7302183062155, -122.436697473612) | 9 | 7 | 6 | 28861 | 25 | ||||
| 165208 | 178407 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1601 San Jose Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6001645.05047 | 2094167.64617 | 37.730278577884 | -122.436619829756 | (37.730278577884, -122.436619829756) | 9 | 7 | 6 | 28861 | 25 | ||||
| 166260 | 178411 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6001607.21703 | 2094132.14841 | 37.7301789590848 | -122.43674808477 | (37.7301789590848, -122.43674808477) | 9 | 7 | 6 | 28861 | 25 | ||||
| 181253 | 178412 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1703 San Jose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001615.63687 | 2094138.09403 | 37.7301957629086 | -122.436719401772 | (37.7301957629086, -122.436719401772) | 9 | 7 | 6 | 28861 | 25 |
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) );