trees
118 rows where Supervisor Districts = 6 and qSpecies_id = 95 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 5223 | 62183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1957 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1985 12:00:00 AM | Permit Number 22301 | 5999981.22618008 | 2092577.81268407 | 37.7258185704465 | -122.44225779266 | (37.7258185704465, -122.44225779266) | 9 | 7 | 6 | 28861 | 25 | ||
| 96099 | 159380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 321 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 09:55:00 AM | 3 | Width 0ft | 5998873.83978 | 2087899.28592 | 37.7129092346593 | -122.445749622169 | (37.7129092346593, -122.445749622169) | 9 | 7 | 6 | 28861 | 25 | ||
| 9322 | 159377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 339 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:19:00 AM | 3 | Width 0ft | 5998814.07521 | 2087846.21352 | 37.7127600973784 | -122.445952372517 | (37.7127600973784, -122.445952372517) | 9 | 7 | 6 | 28861 | 25 | ||
| 32759 | 159367 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 399 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:25:00 AM | 3 | Width 0ft | 5998606.24226 | 2087650.90159 | 37.7122119452855 | -122.446656663084 | (37.7122119452855, -122.446656663084) | 9 | 7 | 6 | 28861 | 25 | ||
| 34121 | 159344 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:59:00 AM | 3 | Width 0ft | 5998260.09428 | 2087319.5949 | 37.7112824734796 | -122.447829210846 | (37.7112824734796, -122.447829210846) | 9 | 7 | 6 | 28861 | 25 | ||
| 141835 | 159342 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:41:00 AM | 3 | Width 0ft | 5998239.66156 | 2087300.46869 | 37.7112287893569 | -122.447898455055 | (37.7112287893569, -122.447898455055) | 9 | 7 | 6 | 28861 | 25 | ||
| 46603 | 159343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 483 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:53:00 AM | 3 | Width 0ft | 5998248.04644 | 2087308.67333 | 37.711251796703 | -122.447870065251 | (37.711251796703, -122.447870065251) | 9 | 7 | 6 | 28861 | 25 | ||
| 28372 | 180665 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 316 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 02:13:00 PM | 3 | Width 6ft | 6002643.65919 | 2086652.61793 | 37.7097006784091 | -122.432630907484 | (37.7097006784091, -122.432630907484) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 155794 | 52524 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | Permit Number 48624 | 6000729.49329 | 2092545.62188 | 37.7257727999708 | -122.439668786882 | (37.7257727999708, -122.439668786882) | 9 | 7 | 6 | 28861 | 25 |
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) );