trees
13 rows where qSiteInfo = "Sidewalk: Curb side : Pot" and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24514 | 233561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 560 27th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6002675.90697 | 2100082.82266 | 37.7465788160682 | -122.433478573399 | (37.7465788160682, -122.433478573399) | 2 | 7 | 5 | 63 | 22 | |||
| 32973 | 251043 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5527 Geary Blvd | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 2ft | 5989811.4148 | 2112601.8948 | 37.7802145363711 | -122.478877614898 | (37.7802145363711, -122.478877614898) | 11 | 6 | 2 | 55 | 26 | |||
| 33991 | 233554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 650 27th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6002271.55455 | 2100062.74856 | 37.7465007477171 | -122.434875343722 | (37.7465007477171, -122.434875343722) | 2 | 7 | 5 | 63 | 22 | |||
| 59416 | 233570 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2145 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 10ft | 6002716.42325 | 2099240.68879 | 37.7442688120496 | -122.433278307845 | (37.7442688120496, -122.433278307845) | 2 | 7 | 5 | 63 | 22 | |||
| 63935 | 132295 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1213 Lombard St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 3ft | 6006526.56714 | 2120062.48471 | 37.8016558891581 | -122.421582156104 | (37.8016558891581, -122.421582156104) | 13 | 9 | 1 | 28858 | 32 | |||
| 70253 | 118678 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4749 Balboa St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 5980862.87698 | 2110909.19366 | 37.7750431971102 | -122.50970838455 | (37.7750431971102, -122.50970838455) | 11 | 6 | 2 | 55 | 26 | |||
| 70609 | 233553 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 916 Alvarado St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 3ft | 6000357.83918 | 2102588.4411 | 37.7533268502794 | -122.441673968381 | (37.7533268502794, -122.441673968381) | 2 | 4 | 5 | 28862 | 22 | |||
| 94577 | 211339 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 66 Aerial Way | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5992292.22601 | 2102565.50209 | 37.7528010166768 | -122.469564608839 | (37.7528010166768, -122.469564608839) | 1 | 8 | 4 | 56 | 12 | |||
| 98287 | 118677 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4749 Balboa St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 5980875.63021 | 2110909.60557 | 37.7750450801709 | -122.509664299747 | (37.7750450801709, -122.509664299747) | 11 | 6 | 2 | 55 | 26 | |||
| 169281 | 132297 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1213 Lombard St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 6006573.88684 | 2120067.71779 | 37.8016729259367 | -122.42141877985 | (37.8016729259367, -122.42141877985) | 13 | 9 | 1 | 28858 | 32 | |||
| 175273 | 132296 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1213 Lombard St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6006544.07919 | 2120063.3183 | 37.801659165409 | -122.421521615528 | (37.801659165409, -122.421521615528) | 13 | 9 | 1 | 28858 | 32 | |||
| 185068 | 233548 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 630 Alvarado St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 4ft | 6002336.17454 | 2102683.27276 | 37.7536997550592 | -122.434839264735 | (37.7536997550592, -122.434839264735) | 2 | 4 | 5 | 28862 | 22 | |||
| 190943 | 132287 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 926 Taylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 6009134.27648 | 2116171.69815 | 37.7911194401688 | -122.412283098711 | (37.7911194401688, -122.412283098711) | 5 | 1 | 10 | 28857 | 21 |
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) );