trees
118 rows where Supervisor Districts = 6 and qSpecies_id = 95 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24827 | 60464 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20051 | 5997050.82952921 | 2089261.72152449 | 37.7165459118767 | -122.4521487519 | (37.7165459118767, -122.4521487519) | 9 | 8 | 6 | 28861 | 24 | ||
28558 | 45475 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1355 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44760 | 5999364.2117528 | 2089872.65901255 | 37.7183556553422 | -122.444196457807 | (37.7183556553422, -122.444196457807) | 9 | 7 | 6 | 28861 | 25 | ||
29456 | 44432 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
41816 | 44422 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
44311 | 60961 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 106 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/1983 12:00:00 AM | Permit Number 20766 | 5994477.00486337 | 2090637.97145314 | 37.7201769910182 | -122.461144804136 | (37.7201769910182, -122.461144804136) | 9 | 8 | 6 | 28861 | 24 | ||
55849 | 48560 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
57786 | 48561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4140 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | Permit Number 45980 | 5991967.17199853 | 2088459.93536695 | 37.7140518790132 | -122.469661899743 | (37.7140518790132, -122.469661899743) | 9 | 8 | 6 | 64 | 24 | ||
74256 | 60966 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 148 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/1983 12:00:00 AM | Permit Number 20771 | 5994481.61365217 | 2090903.91610475 | 37.7209074765337 | -122.461148140155 | (37.7209074765337, -122.461148140155) | 9 | 8 | 6 | 28861 | 24 | ||
75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
79738 | 62193 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 117 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1985 12:00:00 AM | Permit Number 22312 | 6000450.83413219 | 2092179.07109151 | 37.7247504709162 | -122.440605808871 | (37.7247504709162, -122.440605808871) | 9 | 7 | 6 | 28861 | 25 | ||
82780 | 44427 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
85575 | 44435 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
116879 | 65462 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 901 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1989 12:00:00 AM | Permit Number 28340 | 5995002.55717105 | 2089937.23341469 | 37.7182831614911 | -122.459277439941 | (37.7182831614911, -122.459277439941) | 9 | 8 | 6 | 28861 | 24 | ||
160852 | 44424 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
167021 | 60960 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1988 12:00:00 AM | Permit Number 25349 | 5994476.34646497 | 2090599.97936006 | 37.7200726359376 | -122.461144327567 | (37.7200726359376, -122.461144327567) | 9 | 8 | 6 | 28861 | 24 | ||
187874 | 53561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20055 | 5996986.48234272 | 2089260.31315795 | 37.7165383585573 | -122.452371064987 | (37.7165383585573, -122.452371064987) | 9 | 8 | 6 | 28861 | 24 | ||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 |
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) );