trees
18 rows where PlotSize = "Width 2ft" and qSpecies_id = 136
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16893 | 201267 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 200 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 2ft | 6013091.83169 | 2092838.18677 | 37.7272720093758 | -122.396953309066 | (37.7272720093758, -122.396953309066) | 10 | 3 | 8 | 58 | 1 | |||
| 29946 | 202323 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 145 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012916.63794 | 2093046.14755 | 37.7278332735801 | -122.397573536383 | (37.7278332735801, -122.397573536383) | 10 | 3 | 8 | 58 | 1 | |||
| 32371 | 201249 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 75 Orsi Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6012867.89314 | 2093249.63424 | 37.7283892920331 | -122.397756316395 | (37.7283892920331, -122.397756316395) | 10 | 3 | 8 | 58 | 1 | |||
| 38443 | 202302 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 142 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012862.67742 | 2093038.03739 | 37.7278079999277 | -122.397759511686 | (37.7278079999277, -122.397759511686) | 10 | 3 | 8 | 58 | 1 | |||
| 54951 | 202317 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 171 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6013014.6223 | 2092973.46989 | 37.7276391711032 | -122.397229705795 | (37.7276391711032, -122.397229705795) | 10 | 3 | 8 | 58 | 1 | |||
| 57643 | 202297 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 128 Orsi Cir | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6012789.45196 | 2093091.80408 | 37.7279515541956 | -122.398016425535 | (37.7279515541956, -122.398016425535) | 10 | 3 | 8 | 58 | 1 | |||
| 58709 | 225129 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 501 Alabama St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6009000.51877 | 2105809.55198 | 37.7626599281265 | -122.412013295782 | (37.7626599281265, -122.412013295782) | 8 | 4 | 7 | 28859 | 19 | |||
| 71270 | 201269 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 200 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013069.13486 | 2092810.94141 | 37.7271959357375 | -122.397029862935 | (37.7271959357375, -122.397029862935) | 10 | 3 | 8 | 58 | 1 | |||
| 78028 | 202318 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 165 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013007.15783 | 2092979.14399 | 37.7276543354547 | -122.397255908459 | (37.7276543354547, -122.397255908459) | 10 | 3 | 8 | 58 | 1 | |||
| 91110 | 202324 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 139 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6012910.81057 | 2093050.49966 | 37.7278448990995 | -122.397593986976 | (37.7278448990995, -122.397593986976) | 10 | 3 | 8 | 58 | 1 | |||
| 100340 | 201253 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 75 Orsi Cir | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 6012901.23159 | 2093261.84433 | 37.7284246749358 | -122.397641919057 | (37.7284246749358, -122.397641919057) | 10 | 3 | 8 | 58 | 1 | |||
| 111137 | 225130 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 501 Alabama St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 6009000.12546 | 2105825.81959 | 37.7627045731891 | -122.412015805783 | (37.7627045731891, -122.412015805783) | 8 | 4 | 7 | 28859 | 19 | |||
| 125274 | 202319 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 159 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6012982.5618 | 2092996.94727 | 37.7277018502531 | -122.397342185804 | (37.7277018502531, -122.397342185804) | 10 | 3 | 8 | 58 | 1 | |||
| 129400 | 206023 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 238 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5999152.99249 | 2094098.71035 | 37.7299473620575 | -122.445230225021 | (37.7299473620575, -122.445230225021) | 9 | 7 | 4 | 28861 | 40 | |||
| 164121 | 201268 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 200 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6013087.7822 | 2092834.49936 | 37.7272616590859 | -122.396967049805 | (37.7272616590859, -122.396967049805) | 10 | 3 | 8 | 58 | 1 | |||
| 171927 | 202311 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 192 Orsi Cir | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013079.04829 | 2092877.72524 | 37.7273798623663 | -122.39700027256 | (37.7273798623663, -122.39700027256) | 10 | 3 | 8 | 58 | 1 | |||
| 185676 | 202298 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 132 Orsi Cir | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6012798.01394 | 2093085.55544 | 37.7279348735704 | -122.397986388177 | (37.7279348735704, -122.397986388177) | 10 | 3 | 8 | 58 | 1 | |||
| 190965 | 202310 | DPW Maintained 1 | Cercis occidentalis :: Western Redbud 136 | 188 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013055.73834 | 2092895.13423 | 37.727426366308 | -122.397082075775 | (37.727426366308, -122.397082075775) | 10 | 3 | 8 | 58 | 1 |
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) );