trees
9 rows where qSpecies_id = 376
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17918 | 226830 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 923 Shotwell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008001.21556 | 2102617.353 | 37.7538387632575 | -122.415243555361 | (37.7538387632575, -122.415243555361) | 2 | 4 | 7 | 28859 | 19 | |||
| 34920 | 226832 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 555 Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007867.10433 | 2104962.54137 | 37.7602705760452 | -122.415873400055 | (37.7602705760452, -122.415873400055) | 2 | 4 | 7 | 28859 | 19 | |||
| 92247 | 29377 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 3201 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6014173.2464 | 2089796.2958 | 37.7189797211541 | -122.393002094215 | (37.7189797211541, -122.393002094215) | 10 | 3 | 8 | 58 | 1 | |||
| 110535 | 176590 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 4103 Alemany Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 23 | Width 10ft | 5991596.71486 | 2086796.0596 | 37.7094618598487 | -122.470821200944 | (37.7094618598487, -122.470821200944) | 9 | 8 | 4 | 64 | 24 | |||
| 125210 | 29376 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 3201 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6014152.5379 | 2089770.1057 | 37.7189066579696 | -122.393071844457 | (37.7189066579696, -122.393071844457) | 10 | 3 | 8 | 58 | 1 | |||
| 149640 | 176589 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 161 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 10ft | 5994383.03058 | 2086790.743 | 37.7096080059674 | -122.461190912432 | (37.7096080059674, -122.461190912432) | 9 | 8 | 6 | 28861 | 25 | |||
| 170979 | 226829 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 1388 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007687.25628 | 2101588.48604 | 37.7509960782039 | -122.416256436585 | (37.7509960782039, -122.416256436585) | 2 | 4 | 7 | 28859 | 19 | |||
| 171546 | 219236 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 300 Junipero Serra Blvd | 8 | : | Tree | Private 2 | 14 | Width 0ft | 5991410.69549 | 2094564.77843 | 37.7307820912156 | -122.472029971608 | (37.7307820912156, -122.472029971608) | 9 | 8 | 4 | 64 | 40 | |||
| 176200 | 226831 | DPW Maintained 1 | Juglans nigra :: Eastern black walnut 376 | 555 Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007871.18778 | 2104938.9041 | 37.7602059031124 | -122.415857603464 | (37.7602059031124, -122.415857603464) | 2 | 4 | 7 | 28859 | 19 |
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) );