trees
8 rows where DBH = 11 and qCaretaker_id = 4 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16064 | 235284 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.436539154285 | (37.7591334867264, -122.436539154285) | 2 | 4 | 5 | 28862 | 3 | |||
| 47875 | 234074 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.85229 | 37.751468148542 | -122.404311456823 | (37.751468148542, -122.404311456823) | 10 | 4 | 8 | 28859 | 19 | |||
| 45053 | 98657 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002607.56666 | 2119218.59599 | 37.7991170337862 | -122.435083283187 | (37.7991170337862, -122.435083283187) | 13 | 9 | 1 | 57 | 17 | ||
| 49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
| 58468 | 100975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | 3 | 1 | 10 | 308 | 23 | ||
| 65323 | 110958 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | 5 | 1 | 10 | 308 | 32 | ||
| 89640 | 116047 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 5x12 | 6011496.1211 | 2105415.82819 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | 10 | 3 | 8 | 28856 | 29 | ||
| 184781 | 116053 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11 | 4x4 | 6011508.10962 | 2105241.51829 | 37.7612406063998 | -122.403300427289 | (37.7612406063998, -122.403300427289) | 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) );