trees
41 rows where qSpecies_id = 268
This data as json, CSV (advanced)
Suggested facets: qLegalStatus_id, PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3842 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 268 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | |||
13080 | 199511 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1 01st St | 16 | : Yard | Tree | Private 2 | 4 | 6014447.50245 | 2105911.75995 | 37.7632446718137 | -122.393181136026 | (37.7632446718137, -122.393181136026) | 14 | 3 | 8 | 28856 | 29 | ||||
22356 | 93153 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 222 Sadowa St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 3x24 | 5994796 | 2087777 | 37.7123397937745 | -122.459835021723 | (37.7123397937745, -122.459835021723) | 9 | 8 | 6 | 28861 | 24 | |||
27269 | 173843 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 73 Margaret Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997033 | 2089669 | 37.7176631824639 | -122.452239750024 | (37.7176631824639, -122.452239750024) | 9 | 8 | 6 | 28861 | 24 | ||||
30837 | 199515 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1 01st St | 11 | : Yard | Tree | Private 2 | 3 | 6014438.12631 | 2105919.24405 | 37.7632647006382 | -122.393214088968 | (37.7632647006382, -122.393214088968) | 14 | 3 | 8 | 28856 | 29 | ||||
36794 | 96909 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 1399X 48TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210 | 2105881 | 37.7612577047615 | -122.508134351337 | (37.7612577047615, -122.508134351337) | 1 | 8 | 3 | 56 | 35 | ||
48537 | 106997 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 137 MULLEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009914.8 | 2099885.1 | 37.7464439600281 | -122.408433197003 | (37.7464439600281, -122.408433197003) | 2 | 7 | 7 | 28859 | 2 | |||
54901 | 59459 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 431 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1980 12:00:00 AM | Permit Number 18824 | 6003335.44850499 | 2095190.62300145 | 37.7331833583543 | -122.430848875023 | (37.7331833583543, -122.430848875023) | 9 | 7 | 5 | 28861 | 25 | |||
55053 | 205481 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 100 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | Width 8ft | 5998772.56194 | 2093243.78905 | 37.7275782258363 | -122.446483932112 | (37.7275782258363, -122.446483932112) | 9 | 7 | 4 | 28861 | 40 | ||
55819 | 199518 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1698 Galvez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6015460.66567 | 2098003.58866 | 37.7415867333391 | -122.389124702536 | (37.7415867333391, -122.389124702536) | 10 | 3 | 8 | 58 | 1 | |||
64880 | 90727 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 4799X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5980764.077178 | 2110242.237714 | 37.773206105836 | -122.510000589277 | (37.773206105836, -122.510000589277) | 11 | 6 | 2 | 55 | 26 | |
79404 | 115836 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 463 LOS PALMOS DR | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 4x6 | 5997227 | 2095765 | 37.7344124695252 | -122.452008748521 | (37.7344124695252, -122.452008748521) | 9 | 7 | 4 | 59 | 40 | |||
86495 | 90708 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 4400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981985.083822 | 2110326.577967 | 37.7735096198008 | -122.505783291903 | (37.7735096198008, -122.505783291903) | 11 | 6 | 2 | 55 | 26 | |
88333 | 40265 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 1 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41424 | 6006673.49895553 | 2103768.88738222 | 37.7569259031797 | -122.419916824047 | (37.7569259031797, -122.419916824047) | 2 | 4 | 7 | 28859 | 19 | ||
91653 | 106575 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
94579 | 199512 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1501 22nd St | 24 | Front Yard : Yard | Tree | Private 2 | 18 | 6013280.41424 | 2103787.32722 | 37.7573465401332 | -122.397068768517 | (37.7573465401332, -122.397068768517) | 10 | 3 | 8 | 28856 | 29 | ||||
94926 | 116679 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 100 Esmeralda Ave | 18 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
98364 | 116531 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 519 MOUNT VERNON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997873 | 2090032 | 37.7187079814725 | -122.449362402052 | (37.7187079814725, -122.449362402052) | 9 | 8 | 6 | 28861 | 24 | ||||
101255 | 96912 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 4300@48th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981169 | 2105631 | 37.7605688605658 | -122.508257593382 | (37.7605688605658, -122.508257593382) | 1 | 8 | 3 | 56 | 35 | ||
101482 | 200500 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1082 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6013578.933 | 2089972.0695 | 37.719429329564 | -122.395068723833 | (37.719429329564, -122.395068723833) | 10 | 3 | 8 | 58 | 1 | |||
107444 | 105691 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 701X DUBOCE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6x10 | 6002306 | 2108287 | 37.7690845180814 | -122.435344429196 | (37.7690845180814, -122.435344429196) | 15 | 5 | 5 | 28862 | 3 | |||
112549 | 90724 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 4799X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5980764.077178 | 2110242.237714 | 37.773206105836 | -122.510000589277 | (37.773206105836, -122.510000589277) | 11 | 6 | 2 | 55 | 26 | |
113504 | 84002 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1883 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51094 | 5984410.615 | 2102377.1904 | 37.7518252988512 | -122.496806349354 | (37.7518252988512, -122.496806349354) | 1 | 8 | 3 | 56 | 35 | |
117927 | 106571 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
123017 | 105651 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 150 BRONTE ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6009287.5 | 2096640.3 | 37.737499298819 | -122.410373266073 | (37.737499298819, -122.410373266073) | 10 | 7 | 7 | 28859 | 2 | ||||
124011 | 199513 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1700x Quesada Ave | 54 | Median : Yard | Tree | DPW 1 | 22 | 6014249.11151 | 2095406.32317 | 37.7343879418434 | -122.393132186809 | (37.7343879418434, -122.393132186809) | 10 | 3 | 8 | 58 | 1 | ||||
130096 | 181938 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 2441 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5987022.5545 | 2098654.889 | 37.7417575540763 | -122.487500612205 | (37.7417575540763, -122.487500612205) | 1 | 8 | 3 | 29491 | 35 | |||
130455 | 106574 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
144184 | 106572 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
145801 | 199516 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1 01st St | 12 | : Yard | Tree | Private 2 | 3 | 6014441.55665 | 2105919.02201 | 37.7632642815347 | -122.393202208925 | (37.7632642815347, -122.393202208925) | 14 | 3 | 8 | 28856 | 29 | ||||
147632 | 59027 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 910 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1980 12:00:00 AM | Permit Number 18318 | 6007958.45286242 | 2102614.15353136 | 37.753827574851 | -122.415391212603 | (37.753827574851, -122.415391212603) | 2 | 4 | 7 | 28859 | 19 | |||
148207 | 199514 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1301 Minnesota St | 78 | Front Yard : Yard | Tree | Private 2 | 4 | 6015365.49861 | 2102246.30047 | 37.753231058975 | -122.389750029948 | (37.753231058975, -122.389750029948) | 10 | 3 | 8 | 28856 | 29 | ||||
149227 | 105652 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 150 BRONTE ST | 4 | Unaccepted Street : Yard | Tree | Private 2 | 25 | 6009287.5 | 2096640.3 | 37.737499298819 | -122.410373266073 | (37.737499298819, -122.410373266073) | 10 | 7 | 7 | 28859 | 2 | ||||
152859 | 199517 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1 01st St | 13 | : Yard | Tree | Private 2 | 3 | 6014420.56618 | 2105901.8129 | 37.763215862946 | -122.393273604288 | (37.763215862946, -122.393273604288) | 14 | 3 | 8 | 28856 | 29 | ||||
158210 | 106703 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 3399X 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4x4 | 6005738 | 2103148 | 37.7551683424225 | -122.423108003191 | (37.7551683424225, -122.423108003191) | 2 | 4 | 5 | 28859 | 19 | |||
160361 | 5093 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 2607 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 45 | 3x3 | 6002289.9772201 | 2096641.3303008 | 37.7371073764507 | -122.434567040596 | (37.7371073764507, -122.434567040596) | 2 | 7 | 5 | 63 | 7 | ||
160528 | 111633 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 3009 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009514.91537658 | 2100993.40768569 | 37.7494647260255 | -122.40989418187 | (37.7494647260255, -122.40989418187) | 2 | 4 | 7 | 28859 | 19 | ||||
161144 | 243959 | DPW Maintained 1 | Yucca elephantipes :: Giant Yucca 268 | 1306 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010048.4151 | 2101559.31593 | 37.7510484700249 | -122.408089221845 | (37.7510484700249, -122.408089221845) | 2 | 4 | 7 | 28859 | 19 | |||
171603 | 33896 | Permitted Site 7 | Yucca elephantipes :: Giant Yucca 268 | 150 Bronte St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 03/03/1997 12:00:00 AM | 25 | Permit Number 37869 | 6009276.59000035 | 2096641.35700735 | 37.7375015895327 | -122.410411061845 | (37.7375015895327, -122.410411061845) | 10 | 7 | 7 | 28859 | 2 | ||
185543 | 106570 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 28859 | 19 | |||||
188306 | 106573 | Undocumented 4 | Yucca elephantipes :: Giant Yucca 268 | 580 York St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009757.6 | 2105594.3 | 37.7621113428358 | -122.409379620361 | (37.7621113428358, -122.409379620361) | 8 | 4 | 8 | 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) );