trees
15 rows where qSiteInfo = "Side Yard : Yard" and qSpecies_id = 95 sorted by qSpecies_id
This data as json, CSV (advanced)
These facets timed out: qCareAssistant, qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21040 | 211323 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5991179.3605 | 2105090.25132 | 37.7596689323038 | -122.473597215644 | (37.7596689323038, -122.473597215644) | 1 | 8 | 4 | 56 | 12 | ||||
26580 | 194561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 999 Kansas St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011649.57806 | 2103809.76096 | 37.7573172186375 | -122.402710453142 | (37.7573172186375, -122.402710453142) | 10 | 3 | 8 | 28856 | 29 | ||||
34035 | 250222 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 312 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011281.01551 | 2120075.58607 | 37.8019588006185 | -122.405130424447 | (37.8019588006185, -122.405130424447) | 3 | 1 | 10 | 308 | 23 | |||
47301 | 211324 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 5991176.95636 | 2105105.05253 | 37.7597094332699 | -122.473606609976 | (37.7597094332699, -122.473606609976) | 1 | 8 | 4 | 56 | 12 | ||||
53973 | 248190 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 216 Esmeralda Ave | 9 | Side Yard : Yard | Tree | Private 2 | 8 | 6007395.06383 | 2098734.36623 | 37.7431428725527 | -122.417064660027 | (37.7431428725527, -122.417064660027) | 2 | 7 | 7 | 28859 | 2 | ||||
75543 | 132299 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2836 Larkin St | 9 | Side Yard : Yard | Tree | Private 2 | 6 | 6006506.76363 | 2120995.98891 | 37.8042179371566 | -122.421717028328 | (37.8042179371566, -122.421717028328) | 5 | 9 | 1 | 28858 | 32 | ||||
83314 | 248245 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 296 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 7 | 6006801.13477 | 2098995.22543 | 37.7438257043874 | -122.419136812224 | (37.7438257043874, -122.419136812224) | 2 | 7 | 7 | 28859 | 2 | ||||
111509 | 248244 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 296 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5 | 6006798.41265 | 2099004.72131 | 37.7438516246444 | -122.419146898128 | (37.7438516246444, -122.419146898128) | 2 | 7 | 7 | 28859 | 2 | ||||
115636 | 219153 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 7 | Side Yard : Yard | Tree | Private 2 | 8 | Width 6ft | 5991180.54312 | 2105148.28148 | 37.7598283362197 | -122.473597358645 | (37.7598283362197, -122.473597358645) | 1 | 8 | 4 | 56 | 12 | |||
124004 | 194560 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2045 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6011621.05801 | 2105090.22678 | 37.7608315011953 | -122.402899143494 | (37.7608315011953, -122.402899143494) | 10 | 3 | 8 | 28856 | 29 | |||
130274 | 211325 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 6 | Width 6ft | 5991167.02607 | 2105120.24929 | 37.7597505844426 | -122.47364206215 | (37.7597505844426, -122.47364206215) | 1 | 8 | 4 | 56 | 12 | |||
131338 | 132298 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2836 Larkin St | 8 | Side Yard : Yard | Tree | Private 2 | 19 | 6006506.15813 | 2120992.00348 | 37.8042069600397 | -122.421718840462 | (37.8042069600397, -122.421718840462) | 5 | 9 | 1 | 28858 | 32 | ||||
172384 | 248238 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 298 Esmeralda Ave | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6006759.3942 | 2099022.22298 | 37.7438974828793 | -122.419283056376 | (37.7438974828793, -122.419283056376) | 2 | 7 | 7 | 28859 | 2 | ||||
188455 | 219151 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 5991179.47447 | 2105124.8493 | 37.7597639357807 | -122.473599345261 | (37.7597639357807, -122.473599345261) | 1 | 8 | 4 | 56 | 12 | |||
193706 | 219152 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1500 16th Ave | 6 | Side Yard : Yard | Tree | Private 2 | 15 | Width 6ft | 5991180.06905 | 2105137.85002 | 37.759799666743 | -122.473598237272 | (37.759799666743, -122.473598237272) | 1 | 8 | 4 | 56 | 12 |
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) );