trees
20 rows where qSiteInfo = "Front Yard : Yard" and qSpecies_id = 77
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16844 | 249665 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 17 | Front Yard : Yard | Tree | Private 2 | 9 | 5999244.57563 | 2117118.96584 | 37.7931604758161 | -122.44656918694 | (37.7931604758161, -122.44656918694) | 11 | 1 | 57 | 30 | |||||
| 24251 | 136053 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1101 Greenwich St | 13 | Front Yard : Yard | Tree | Private 2 | 4 | 6007566.05683 | 2119890.57017 | 37.8012424132723 | -122.417972843093 | (37.8012424132723, -122.417972843093) | 5 | 1 | 1 | 28858 | 32 | ||||
| 26148 | 250147 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5999210.3991 | 2117472.66602 | 37.7941296904761 | -122.446712900392 | (37.7941296904761, -122.446712900392) | 11 | 1 | 57 | 30 | |||||
| 57531 | 250151 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 5999220.87756 | 2117406.81737 | 37.7939494861264 | -122.446671903881 | (37.7939494861264, -122.446671903881) | 11 | 1 | 57 | 30 | |||||
| 67120 | 249663 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 15 | Front Yard : Yard | Tree | Private 2 | 9 | 5999240.36151 | 2117161.61527 | 37.7932773391397 | -122.446586837907 | (37.7932773391397, -122.446586837907) | 11 | 1 | 57 | 30 | |||||
| 88103 | 250148 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | 5999211.58041 | 2117458.26171 | 37.7940902075462 | -122.446707776048 | (37.7940902075462, -122.446707776048) | 11 | 1 | 57 | 30 | |||||
| 90248 | 249642 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 5999289.16084 | 2117209.34278 | 37.7934111735351 | -122.446421424722 | (37.7934111735351, -122.446421424722) | 13 | 9 | 1 | 57 | 27 | ||||
| 116012 | 249662 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 14 | Front Yard : Yard | Tree | Private 2 | 12 | 5999235.55005 | 2117182.17249 | 37.7933335089853 | -122.446604965544 | (37.7933335089853, -122.446604965544) | 11 | 1 | 57 | 30 | |||||
| 130390 | 249661 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 5999232.65842 | 2117208.86838 | 37.7934066436505 | -122.446616892353 | (37.7934066436505, -122.446616892353) | 11 | 1 | 57 | 30 | |||||
| 133564 | 249667 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 19 | Front Yard : Yard | Tree | Private 2 | 12 | 5999247.61227 | 2117079.36111 | 37.7930519051704 | -122.446555829313 | (37.7930519051704, -122.446555829313) | 11 | 1 | 57 | 30 | |||||
| 137971 | 250150 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 5999218.59352 | 2117421.61343 | 37.7939899817095 | -122.446680871938 | (37.7939899817095, -122.446680871938) | 11 | 1 | 57 | 30 | |||||
| 140665 | 246630 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3320 Harrison St | 1 | Front Yard : Yard | Tree | Private 2 | 1 | 6009028.43524 | 2099278.75412 | 37.7447293908617 | -122.411455327621 | (37.7447293908617, -122.411455327621) | 2 | 7 | 7 | 28859 | 2 | ||||
| 141006 | 120282 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 129 24th Ave | 12 | Front Yard : Yard | Tree | Private 2 | 10 | 5988304.19862 | 2115114.50046 | 37.7870258038912 | -122.484276029631 | (37.7870258038912, -122.484276029631) | 11 | 6 | 1 | 55 | 33 | ||||
| 145142 | 249664 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 16 | Front Yard : Yard | Tree | Private 2 | 10 | 5999241.54149 | 2117138.79958 | 37.7932147607016 | -122.446581112841 | (37.7932147607016, -122.446581112841) | 11 | 1 | 57 | 30 | |||||
| 152580 | 250149 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 5999215.63832 | 2117439.7417 | 37.794039588317 | -122.446692402146 | (37.794039588317, -122.446692402146) | 11 | 1 | 57 | 30 | |||||
| 158964 | 249680 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Baker St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 5999746.74355 | 2117232.18734 | 37.7935000229554 | -122.444839803216 | (37.7935000229554, -122.444839803216) | 13 | 9 | 1 | 57 | 27 | ||||
| 177445 | 136054 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1101 Greenwich St | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6007578.67798 | 2119880.17499 | 37.80121458104 | -122.417928430959 | (37.80121458104, -122.417928430959) | 5 | 1 | 1 | 28858 | 32 | ||||
| 184368 | 249641 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2460 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 5999290.35855 | 2117187.34 | 37.7933508281386 | -122.446415696946 | (37.7933508281386, -122.446415696946) | 13 | 9 | 1 | 57 | 27 | ||||
| 189111 | 249666 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2401 Lyon St | 18 | Front Yard : Yard | Tree | Private 2 | 8 | 5999246.11095 | 2117099.98704 | 37.793108452756 | -122.44656250858 | (37.793108452756, -122.44656250858) | 11 | 1 | 57 | 30 | |||||
| 193715 | 250146 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2501 Lyon St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 5999207.44391 | 2117490.79429 | 37.7941792970798 | -122.446724430609 | (37.7941792970798, -122.446724430609) | 11 | 1 | 57 | 30 |
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) );