trees
6 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Curb side : Pot" sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74248 | 208929 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 501 Saint Francis Blvd | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 34 | Width 6ft | 5993145.62708 | 2096072.03007 | 37.735020873007 | -122.466141577798 | (37.735020873007, -122.466141577798) | 1 | 8 | 4 | 59 | 40 | |||
11129 | 236516 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6009359.84862 | 2097078.24448 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | 10 | 7 | 7 | 28859 | 2 | |||
15717 | 221238 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 55 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6009363.02974 | 2097125.97708 | 37.7388370966643 | -122.41014640214 | (37.7388370966643, -122.41014640214) | 10 | 7 | 7 | 28859 | 2 | |||
551 | 234021 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6009064.54563 | 2097789.74594 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | 10 | 7 | 7 | 28859 | 2 | |||
30260 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | ||||
187436 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 |
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) );