trees
43 rows where qSpecies_id = 156 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11584 | 118693 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4549 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5981405.36591 | 2110940.76552 | 37.7751618609691 | -122.507834173686 | (37.7751618609691, -122.507834173686) | 11 | 6 | 2 | 55 | 26 | |||
31741 | 118699 | Undocumented 4 | Dracaena draco :: Dragon Tree 156 | 4445 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5981706.97988 | 2110951.27348 | 37.7752084783718 | -122.506791621288 | (37.7752084783718, -122.506791621288) | 11 | 6 | 2 | 55 | 26 | ||||
49737 | 126468 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 1920 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001025.94107 | 2121026.55904 | 37.803991284631 | -122.440685983991 | (37.803991284631, -122.440685983991) | 13 | 9 | 1 | 57 | 17 | |||
182427 | 191052 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 2001 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012045.9363 | 2104645.58967 | 37.7596343416769 | -122.401398420519 | (37.7596343416769, -122.401398420519) | 10 | 3 | 8 | 28856 | 29 | |||
118939 | 191053 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 2001 20th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012058.9199 | 2104646.98445 | 37.7596388958398 | -122.401353614476 | (37.7596388958398, -122.401353614476) | 10 | 3 | 8 | 28856 | 29 | |||
131454 | 207526 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 1366 16th Ave | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 5991165.61053 | 2106115.51861 | 37.7624832473222 | -122.473719563019 | (37.7624832473222, -122.473719563019) | 1 | 8 | 11 | 56 | 12 | |||
193978 | 223339 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 3418 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006906.42406 | 2100897.24689 | 37.7490541550468 | -122.418907617295 | (37.7490541550468, -122.418907617295) | 2 | 4 | 7 | 28859 | 19 | |||
60419 | 223340 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 3418 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006896.51772 | 2100896.3312 | 37.7490510829549 | -122.41894180864 | (37.7490510829549, -122.41894180864) | 2 | 4 | 7 | 28859 | 19 | |||
148690 | 223341 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 3418 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006881.89927 | 2100895.73585 | 37.7490486250922 | -122.418992317251 | (37.7490486250922, -122.418992317251) | 2 | 4 | 7 | 28859 | 19 | |||
23843 | 223342 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 1201 San Jose Ave | 52 | Front Yard : Yard | Tree | Private 2 | 8 | 6004486.71132 | 2096081.71594 | 37.7356952611353 | -122.426932088964 | (37.7356952611353, -122.426932088964) | 2 | 7 | 5 | 28861 | 2 | ||||
96194 | 33471 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 106 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 770772 | 6006658.5962402 | 2099060.66654687 | 37.7439973628671 | -122.419634320147 | (37.7439973628671, -122.419634320147) | 2 | 7 | 7 | 28859 | 2 | |||
132139 | 38572 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 1222 Palou Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/25/2016 12:00:00 AM | 3 | Permit Number 777465 | 6016907.86791438 | 2093772.63366009 | 37.730049495784 | -122.383826196524 | (37.730049495784, -122.383826196524) | 10 | 3 | 8 | 58 | 1 | ||
2917 | 4317 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 751 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002188.03903 | 2095709.93291 | 37.7345441864792 | -122.434852898904 | (37.7345441864792, -122.434852898904) | 2 | 7 | 5 | 63 | 7 | |||
37689 | 89125 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 635 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
33874 | 89126 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 635 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 50531 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
77244 | 90289 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4800X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980602.31718 | 2110965.89815 | 37.7751835216483 | -122.510613916 | (37.7751835216483, -122.510613916) | 11 | 6 | 2 | 55 | 26 | ||
15239 | 90302 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4301 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982209.19544 | 2110968.11871 | 37.7752842914116 | -122.505055622528 | (37.7752842914116, -122.505055622528) | 11 | 6 | 2 | 55 | 26 | ||
103844 | 90308 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4149X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982646.10209 | 2110983.28462 | 37.7753516285836 | -122.503545410793 | (37.7753516285836, -122.503545410793) | 11 | 6 | 2 | 55 | 26 | ||
114154 | 90937 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4100X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982831.60605 | 2111046.13868 | 37.7755351118189 | -122.502908374104 | (37.7755351118189, -122.502908374104) | 11 | 6 | 2 | 55 | 26 | ||
189629 | 90938 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4100X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982813.88773 | 2111046.51795 | 37.7755351118152 | -122.502969693111 | (37.7755351118152, -122.502969693111) | 11 | 6 | 2 | 55 | 26 | ||
111063 | 90940 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4200 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982543.99778 | 2111038.21959 | 37.7754964606088 | -122.503902677063 | (37.7754964606088, -122.503902677063) | 11 | 6 | 2 | 55 | 26 | ||
26695 | 90941 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4248 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982339.24082 | 2111032.77391 | 37.7754694661516 | -122.504610564793 | (37.7754694661516, -122.504610564793) | 11 | 6 | 2 | 55 | 26 | ||
57973 | 90942 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4300X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982230.54886 | 2111028.62265 | 37.7754516738627 | -122.504986242042 | (37.7754516738627, -122.504986242042) | 11 | 6 | 2 | 55 | 26 | ||
146636 | 90943 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4300X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982210.57322 | 2111028.38039 | 37.7754498334281 | -122.505055323382 | (37.7754498334281, -122.505055323382) | 11 | 6 | 2 | 55 | 26 | ||
119107 | 90947 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4600 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981278.80363 | 2110991.60724 | 37.7752939998625 | -122.508275747758 | (37.7752939998625, -122.508275747758) | 11 | 6 | 2 | 55 | 26 | ||
27947 | 90948 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4640 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981162.97246 | 2110989.4012 | 37.7752811160997 | -122.508676263409 | (37.7752811160997, -122.508676263409) | 11 | 6 | 2 | 55 | 26 | ||
104894 | 90949 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4722 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980898.40146 | 2110978.10011 | 37.7752344887776 | -122.509590618998 | (37.7752344887776, -122.509590618998) | 11 | 6 | 2 | 55 | 26 | ||
108253 | 90950 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4800X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980719.998472 | 2110962.378876 | 37.7751808011063 | -122.510206575867 | (37.7751808011063, -122.510206575867) | 11 | 6 | 2 | 55 | 26 | |
127510 | 90951 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4899X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
144815 | 90952 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980655.26522 | 2110913.31037 | 37.7750422548765 | -122.510426851738 | (37.7750422548765, -122.510426851738) | 11 | 6 | 2 | 55 | 26 | ||
64182 | 90953 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4801 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980721.4437 | 2110922.404993 | 37.7750711298852 | -122.510198605975 | (37.7750711298852, -122.510198605975) | 11 | 6 | 2 | 55 | 26 | |
171253 | 90954 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4715 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980949.82194 | 2110923.96182 | 37.7750888730704 | -122.509408725446 | (37.7750888730704, -122.509408725446) | 11 | 6 | 2 | 55 | 26 | ||
73513 | 90955 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4715 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980930.33673 | 2110922.83667 | 37.7750846348075 | -122.509476044277 | (37.7750846348075, -122.509476044277) | 11 | 6 | 2 | 55 | 26 | ||
126100 | 90958 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4605 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981330.506528 | 2110944.422301 | 37.775167490626 | -122.508093395898 | (37.775167490626, -122.508093395898) | 11 | 6 | 2 | 55 | 26 | |
105228 | 90959 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4545X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981520.769284 | 2110951.300184 | 37.7751975846267 | -122.50743575643 | (37.7751975846267, -122.50743575643) | 11 | 6 | 2 | 55 | 26 | |
44609 | 90960 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4501X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981602.01998 | 2110947.69377 | 37.7751924682496 | -122.507154429295 | (37.7751924682496, -122.507154429295) | 11 | 6 | 2 | 55 | 26 | ||
952 | 90962 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4449X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981706.97988 | 2110951.27348 | 37.7752084783718 | -122.506791621288 | (37.7752084783718, -122.506791621288) | 11 | 6 | 2 | 55 | 26 | ||
97129 | 90963 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4401 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981890.20294 | 2110958.32067 | 37.7752386155682 | -122.506158344973 | (37.7752386155682, -122.506158344973) | 11 | 6 | 2 | 55 | 26 | ||
180666 | 90964 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4351 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982021.66913 | 2110961.16187 | 37.7752541549476 | -122.505703792045 | (37.7752541549476, -122.505703792045) | 11 | 6 | 2 | 55 | 26 | ||
94568 | 90967 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4201X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982528.42581 | 2110981.00259 | 37.7753384437452 | -122.503952304501 | (37.7753384437452, -122.503952304501) | 11 | 6 | 2 | 55 | 26 | ||
157920 | 96559 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 635 Buena Vista West Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2008 12:00:00 AM | Permit Number 56462 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
117968 | 96560 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 635 Buena Vista West Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2008 12:00:00 AM | Permit Number 56462 | 5999771 | 2107673 | 37.7672543384354 | -122.444068690497 | (37.7672543384354, -122.444068690497) | 15 | 5 | 5 | 29492 | 9 | ||||
145264 | 98811 | Permitted Site 7 | Dracaena draco :: Dragon Tree 156 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011846.1 | 2099745.4 | 37.7461683395908 | -122.401745122372 | (37.7461683395908, -122.401745122372) | 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) );