trees
9 rows where qSiteInfo = "Front Yard : Yard" and qSpecies_id = 326
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13348 | 198717 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 6012427.07884 | 2104786.19155 | 37.7600416617243 | -122.400090104772 | (37.7600416617243, -122.400090104772) | 10 | 3 | 8 | 28856 | 29 | ||||
| 28947 | 198719 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 40 | Front Yard : Yard | Tree | Private 2 | 5 | 6012426.60188 | 2104780.3365 | 37.760025558456 | -122.40009134316 | (37.760025558456, -122.40009134316) | 10 | 3 | 8 | 28856 | 29 | ||||
| 34867 | 198712 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 12 | Front Yard : Yard | Tree | Private 2 | 4 | 6012409.2868 | 2104740.75677 | 37.7599159158162 | -122.400148448317 | (37.7599159158162, -122.400148448317) | 10 | 3 | 8 | 28856 | 29 | ||||
| 56866 | 198718 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 39 | Front Yard : Yard | Tree | Private 2 | 7 | 6012424.05702 | 2104786.65184 | 37.7600427570935 | -122.400100588189 | (37.7600427570935, -122.400100588189) | 10 | 3 | 8 | 28856 | 29 | ||||
| 60497 | 198711 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 11 | Front Yard : Yard | Tree | Private 2 | 9 | 6012390.58934 | 2104733.77688 | 37.7598957080306 | -122.400212623923 | (37.7598957080306, -122.400212623923) | 10 | 3 | 8 | 28856 | 29 | ||||
| 68375 | 198716 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 37 | Front Yard : Yard | Tree | Private 2 | 5 | 6012435.45526 | 2104782.66199 | 37.7600324373651 | -122.400060886699 | (37.7600324373651, -122.400060886699) | 10 | 3 | 8 | 28856 | 29 | ||||
| 142619 | 198714 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 14 | Front Yard : Yard | Tree | Private 2 | 6 | 6012392.10432 | 2104746.43 | 37.7599305351797 | -122.40020827299 | (37.7599305351797, -122.40020827299) | 10 | 3 | 8 | 28856 | 29 | ||||
| 189504 | 198713 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 13 | Front Yard : Yard | Tree | Private 2 | 3 | 6012404.84739 | 2104738.96788 | 37.759910756386 | -122.400163676537 | (37.759910756386, -122.400163676537) | 10 | 3 | 8 | 28856 | 29 | ||||
| 193943 | 198715 | DPW Maintained 1 | Umbellularia californica :: California Bay 326 | 1 Jack Balestreri Way | 15 | Front Yard : Yard | Tree | Private 2 | 4 | 6012393.75722 | 2104758.14097 | 37.7599627830829 | -122.40020337888 | (37.7599627830829, -122.40020337888) | 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) );