trees
43 rows where qSpecies_id = 152
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 907 | 261102 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1188 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013127 | 2090401 | 37.7205819447786 | -122.396660953022 | (37.7205819447786, -122.396660953022) | 10 | 3 | 8 | 58 | 1 | |
| 2290 | 259356 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1700 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
| 2421 | 261075 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1909 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6011712 | 2093356 | 37.7286169132467 | -122.401759790518 | (37.7286169132467, -122.401759790518) | 10 | 3 | 8 | 58 | 1 | |
| 3981 | 165759 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 811 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007598.20411 | 2095627.91616 | 37.7346246712757 | -122.416142295533 | (37.7346246712757, -122.416142295533) | 2 | 7 | 7 | 28859 | 2 | |||
| 4924 | 259757 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1539 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015839.81008 | 2096956.81487 | 37.7387335166642 | -122.387740719291 | (37.7387335166642, -122.387740719291) | 10 | 3 | 8 | 58 | 1 | |||
| 4979 | 152151 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 470 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 3ft | 6005642.27481 | 2107862.84764 | 37.7681088008051 | -122.423774276056 | (37.7681088008051, -122.423774276056) | 8 | 4 | 5 | 28853 | 19 | ||
| 5621 | 259746 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1470 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015121.56589 | 2092999.9365 | 37.727828916905 | -122.389947762273 | (37.727828916905, -122.389947762273) | 10 | 3 | 8 | 58 | 1 | ||
| 6146 | 259357 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1700 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
| 6321 | 259358 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1457 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6015839.83075 | 2093812.95308 | 37.7301011067088 | -122.387521378795 | (37.7301011067088, -122.387521378795) | 10 | 3 | 8 | 58 | 1 | ||
| 8133 | 243850 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 3110 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008204.06732 | 2102723.2468 | 37.7541409219928 | -122.414549537725 | (37.7541409219928, -122.414549537725) | 2 | 4 | 7 | 28859 | 19 | |||
| 8310 | 156714 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 501 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2018 12:00:00 AM | 3 | Width 3ft | 6007274.21723 | 2104354.09616 | 37.7585665766127 | -122.417880792084 | (37.7585665766127, -122.417880792084) | 2 | 4 | 7 | 28859 | 19 | ||
| 10069 | 259085 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1145 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009158.70905 | 2087361.78618 | 37.7120152347601 | -122.410163676866 | (37.7120152347601, -122.410163676866) | 9 | 7 | 8 | 309 | 39 | |||
| 10772 | 264676 | Private 9 | Cassia leptophylla :: Gold Medallion Tree 152 | 668 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | 3x3 | 6003797.75621 | 2110080.31484 | 37.7740931268852 | -122.430312496695 | (37.7740931268852, -122.430312496695) | 7 | 9 | 11 | 29492 | 10 | ||
| 11504 | 156715 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 501 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2018 12:00:00 AM | 3 | Width 3ft | 6007276.15856 | 2104318.47907 | 37.7584688895536 | -122.417871553343 | (37.7584688895536, -122.417871553343) | 2 | 4 | 7 | 28859 | 19 | ||
| 11725 | 167335 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 4406 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6001304.44278 | 2105265.56414 | 37.7607314695933 | -122.438592229143 | (37.7607314695933, -122.438592229143) | 15 | 4 | 5 | 28862 | 3 | |||
| 11734 | 243526 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3443 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007325.13159 | 2104386.27009 | 37.7586577840397 | -122.417706987288 | (37.7586577840397, -122.417706987288) | 2 | 4 | 7 | 28859 | 19 | |||
| 12832 | 259086 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1145 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009158.70905 | 2087361.78618 | 37.7120152347601 | -122.410163676866 | (37.7120152347601, -122.410163676866) | 9 | 7 | 8 | 309 | 39 | |||
| 14827 | 261073 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 521 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2019 12:00:00 AM | 3 | 4x5 | 6012513 | 2094400 | 37.7315281895212 | -122.399063918423 | (37.7315281895212, -122.399063918423) | 10 | 3 | 8 | 58 | 1 | |
| 15201 | 243525 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x5 | 6007302.00064 | 2104384.8851 | 37.7586526795002 | -122.417786886671 | (37.7586526795002, -122.417786886671) | 2 | 4 | 7 | 28859 | 19 | |||
| 16031 | 255481 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 2622 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781778 | 6009922 | 2105074 | 37.7606919266783 | -122.40877431288 | (37.7606919266783, -122.40877431288) | 2 | 4 | 8 | 28859 | 19 | |
| 17119 | 259087 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1145 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009158.70905 | 2087361.78618 | 37.7120152347601 | -122.410163676866 | (37.7120152347601, -122.410163676866) | 9 | 7 | 8 | 309 | 39 | |||
| 17234 | 259374 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1538 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6015254.77011 | 2093948.92875 | 37.7304420460935 | -122.389553517646 | (37.7304420460935, -122.389553517646) | 10 | 3 | 8 | 58 | 1 | ||
| 17544 | 259759 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1563 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015716.96571 | 2097048.42371 | 37.7389782502581 | -122.388171852411 | (37.7389782502581, -122.388171852411) | 10 | 3 | 8 | 58 | 1 | |||
| 17821 | 259088 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1145 Visitacion Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009158.70905 | 2087361.78618 | 37.7120152347601 | -122.410163676866 | (37.7120152347601, -122.410163676866) | 9 | 7 | 8 | 309 | 39 | |||
| 19080 | 151581 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 2619 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010713.21679 | 2102706.97126 | 37.7542368787385 | -122.405871093493 | (37.7542368787385, -122.405871093493) | 10 | 4 | 8 | 28859 | 19 | |||
| 24239 | 78664 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 1110 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2008 12:00:00 AM | 3x3 | Permit Number 51506 | 6001236.93227028 | 2109383.43753665 | 37.7720342914694 | -122.439120856334 | (37.7720342914694, -122.439120856334) | 15 | 5 | 11 | 29492 | 9 | ||
| 51111 | 112619 | Section 143 10 | Cassia leptophylla :: Gold Medallion Tree 152 | 3534 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2015 12:00:00 AM | 3x3 | 6005980 | 2102026.6 | 37.7521028905256 | -122.42219142885 | (37.7521028905256, -122.42219142885) | 2 | 4 | 5 | 28859 | 19 | |||
| 71745 | 222614 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 2876 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010138.73273 | 2101659.88938 | 37.7513296790307 | -122.407783983864 | (37.7513296790307, -122.407783983864) | 2 | 4 | 7 | 28859 | 19 | |||
| 100169 | 48535 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 20 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | 6 | Permit Number 45858 | 5997506.862 | 2113470.6571 | 37.7830437798156 | -122.452318374447 | (37.7830437798156, -122.452318374447) | 15 | 6 | 1 | 54 | 31 | |
| 118622 | 93548 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 1860 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2010 12:00:00 AM | Permit Number 53244 | 5997669 | 2108882 | 37.7704538072826 | -122.451426378466 | (37.7704538072826, -122.451426378466) | 15 | 5 | 11 | 29492 | 9 | |||
| 133590 | 188395 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1618 Jerrold Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015178.3816 | 2097166.29925 | 37.7392720564504 | -122.390042276342 | (37.7392720564504, -122.390042276342) | 10 | 3 | 8 | 58 | 1 | |||
| 137320 | 224707 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 3128 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008124.01042 | 2102718.13782 | 37.7541223959334 | -122.414826033413 | (37.7541223959334, -122.414826033413) | 2 | 4 | 7 | 28859 | 19 | |||
| 142329 | 188394 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 1618 Jerrold Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6015188.47499 | 2097158.6579 | 37.7392516346604 | -122.390006843959 | (37.7392516346604, -122.390006843959) | 10 | 3 | 8 | 58 | 1 | |||
| 148032 | 66824 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 225 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 5x5 | Permit Number 30120 | 5997817.9413 | 2109780.1957 | 37.7729285493952 | -122.450975970453 | (37.7729285493952, -122.450975970453) | 15 | 5 | 11 | 29492 | 16 |
| 152793 | 222615 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 34 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998460.8716 | 2107260.22492 | 37.7660461373306 | -122.44857048426 | (37.7660461373306, -122.44857048426) | 15 | 5 | 11 | 29492 | 9 | |||
| 157587 | 108511 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 301x LEXINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775600 | 6006555 | 2104289 | 37.7583473352026 | -122.420363554061 | (37.7583473352026, -122.420363554061) | 2 | 4 | 7 | 28859 | 19 | |
| 157657 | 247207 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 800 Duboce Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001883.43002 | 2108299.04695 | 37.7690935890354 | -122.436806933701 | (37.7690935890354, -122.436806933701) | 15 | 5 | 5 | 29492 | 9 | |||
| 157829 | 236313 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 3132 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6008037 | 2102739 | 37.7541747893693 | -122.415128414232 | (37.7541747893693, -122.415128414232) | 2 | 4 | 7 | 28859 | 19 | |||
| 158244 | 222613 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 2671 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010097.92629 | 2103368.28649 | 37.7560182729435 | -122.408045566068 | (37.7560182729435, -122.408045566068) | 2 | 4 | 7 | 28859 | 19 | |||
| 163169 | 255400 | Permitted Site 7 | Cassia leptophylla :: Gold Medallion Tree 152 | 166 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781900 | 6013265.07114 | 2093776.54393 | 37.7298581884477 | -122.396420161087 | (37.7298581884477, -122.396420161087) | 10 | 3 | 8 | 58 | 1 |
| 172202 | 236315 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 3118 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008156.61181 | 2102721.96866 | 37.7541347463233 | -122.414713560577 | (37.7541347463233, -122.414713560577) | 2 | 4 | 7 | 28859 | 19 | |||
| 177917 | 236316 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 3110 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6008182.79992 | 2102721.4328 | 37.7541347463246 | -122.414622957478 | (37.7541347463246, -122.414622957478) | 2 | 4 | 7 | 28859 | 19 | |||
| 194327 | 163429 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 426 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995056.70261 | 2088533.80912 | 37.714432803101 | -122.458988723671 | (37.714432803101, -122.458988723671) | 9 | 8 | 6 | 28861 | 24 |
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) );