trees
15 rows where qSpecies_id = 397
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23233 | 193771 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014972.46673 | 2104797.14166 | 37.760213320715 | -122.391287523504 | (37.760213320715, -122.391287523504) | 10 | 3 | 8 | 28856 | 29 | |||
| 27432 | 193768 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6014974.37118 | 2104747.05815 | 37.7600759078852 | -122.391277435814 | (37.7600759078852, -122.391277435814) | 10 | 3 | 8 | 28856 | 29 | |||
| 28168 | 193766 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014976.88926 | 2104727.34672 | 37.7600219242934 | -122.391267349009 | (37.7600219242934, -122.391267349009) | 10 | 3 | 8 | 28856 | 29 | |||
| 63185 | 233280 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 310 Liberty St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 6003983.2907 | 2103931.17849 | 37.7572195882419 | -122.42923214376 | (37.7572195882419, -122.42923214376) | 2 | 4 | 5 | 28862 | 3 | |||
| 73997 | 193770 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6014971.07911 | 2104783.98833 | 37.7601771274964 | -122.391291403187 | (37.7601771274964, -122.391291403187) | 10 | 3 | 8 | 28856 | 29 | |||
| 100095 | 193761 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6014979.54491 | 2104658.92807 | 37.7598342088018 | -122.391253381647 | (37.7598342088018, -122.391253381647) | 10 | 3 | 8 | 28856 | 29 | |||
| 114085 | 193760 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6014979.95579 | 2104645.96144 | 37.7597986280312 | -122.391251054199 | (37.7597986280312, -122.391251054199) | 10 | 3 | 8 | 28856 | 29 | |||
| 119386 | 119515 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 741 31st Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5986356.13407 | 2110783.06434 | 37.7750192997319 | -122.490696989661 | (37.7750192997319, -122.490696989661) | 11 | 6 | 2 | 55 | 26 | ||||
| 129303 | 193762 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6014979.31335 | 2104675.40185 | 37.7598794294022 | -122.391255334071 | (37.7598794294022, -122.391255334071) | 10 | 3 | 8 | 28856 | 29 | |||
| 146405 | 193765 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6014976.26212 | 2104717.32753 | 37.7599943789521 | -122.391268817625 | (37.7599943789521, -122.391268817625) | 10 | 3 | 8 | 28856 | 29 | |||
| 159476 | 193764 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6014977.27835 | 2104706.21361 | 37.7599639189205 | -122.391264526045 | (37.7599639189205, -122.391264526045) | 10 | 3 | 8 | 28856 | 29 | |||
| 171292 | 233281 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 480 Roosevelt Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 3ft | 5999948.40455 | 2106302.46261 | 37.7635013032636 | -122.443356622434 | (37.7635013032636, -122.443356622434) | 15 | 5 | 5 | 29492 | 3 | |||
| 177965 | 193763 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 8ft | 6014978.7942 | 2104687.03862 | 37.7599113526545 | -122.391257943019 | (37.7599113526545, -122.391257943019) | 10 | 3 | 8 | 28856 | 29 | |||
| 190728 | 193769 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6014971.69624 | 2104770.12403 | 37.7601390933668 | -122.391288299633 | (37.7601390933668, -122.391288299633) | 10 | 3 | 8 | 28856 | 29 | |||
| 190888 | 193767 | DPW Maintained 1 | Metasequoia glyplostroboides :: Dawn Redwood 397 | 801 Indiana St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6014975.74225 | 2104737.20034 | 37.7600489165544 | -122.391272004802 | (37.7600489165544, -122.391272004802) | 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) );