trees
3,267 rows where qSpecies_id = 67 sorted by PlantDate descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53878 | 63011 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23425 | 6007777.05506636 | 2098194.1467313 | 37.7416810309377 | -122.415705589886 | (37.7416810309377, -122.415705589886) | 2 | 7 | 7 | 28859 | 2 | ||
| 189991 | 52037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2005 12:00:00 AM | 0 | Permit Number 48249 | 5982130.19675143 | 2097871.80760373 | 37.7393208872786 | -122.50435848033 | (37.7393208872786, -122.50435848033) | 1 | 8 | 3 | 29491 | 35 | ||
| 28220 | 67519 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 343 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31055 | 5997813.90677575 | 2093780.36383283 | 37.7289967307539 | -122.449836649621 | (37.7289967307539, -122.449836649621) | 9 | 7 | 4 | 28861 | 40 | ||
| 106907 | 67517 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 331 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31053 | 5997889.85712008 | 2093779.21238518 | 37.7289979144345 | -122.449574001825 | (37.7289979144345, -122.449574001825) | 9 | 7 | 4 | 28861 | 40 | ||
| 26637 | 55149 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4201-4203 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1972 12:00:00 AM | Permit Number 11053 | 6001854.68954035 | 2102324.20100835 | 37.7526864815527 | -122.436478647094 | (37.7526864815527, -122.436478647094) | 2 | 4 | 5 | 28862 | 22 | |||
| 45623 | 45667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.446461503008 | (37.8006529814106, -122.446461503008) | 13 | 9 | 1 | 57 | 17 | ||
| 2685 | 264708 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 19591 | 264707 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 3736 | 38554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.7383941607708 | -122.392199668106 | (37.7383941607708, -122.392199668106) | 10 | 3 | 8 | 58 | 1 | |
| 71105 | 38624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.7283455672948 | -122.386147618696 | (37.7283455672948, -122.386147618696) | 10 | 3 | 8 | 58 | 1 | |
| 154087 | 38560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | 10 | 3 | 8 | 58 | 1 | |
| 172467 | 38559 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1538 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 9 | Permit Number 40524 | 6015720.042 | 2095709.5571 | 37.7353021647635 | -122.388067809168 | (37.7353021647635, -122.388067809168) | 10 | 3 | 8 | 58 | 1 | |
| 154800 | 16092 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 286 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2014 12:00:00 AM | 3 | 3x3 | 6000192.86492 | 2094709.10895 | 37.7316826767984 | -122.44167906036 | (37.7316826767984, -122.44167906036) | 9 | 7 | 4 | 63 | 40 | ||
| 144466 | 64657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 160 Boutwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1988 12:00:00 AM | 11 | Permit Number 25583 | 6010631.28531 | 2095737.02804 | 37.7350943449268 | -122.405663540735 | (37.7350943449268, -122.405663540735) | 10 | 3 | 8 | 58 | 1 | ||
| 28731 | 54993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 681 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 4 | Permit Number 10871 | 5990951.13867 | 2110770.38221 | 37.7752518210128 | -122.474801107552 | (37.7752518210128, -122.474801107552) | 11 | 6 | 2 | 54 | 26 | ||
| 36546 | 55003 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 571 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 10 | Permit Number 10881 | 5990924.60032 | 2111507.07887 | 37.7772730502959 | -122.474946695736 | (37.7772730502959, -122.474946695736) | 11 | 6 | 2 | 54 | 26 | ||
| 73279 | 55091 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 526 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10988 | 5990960.9789 | 2111793.50527 | 37.7780616066781 | -122.47484176352 | (37.7780616066781, -122.47484176352) | 11 | 6 | 2 | 54 | 26 | ||
| 87891 | 54999 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | Permit Number 773428 | 5990967.79402544 | 2111724.41194432 | 37.77787229032 | -122.474813143378 | (37.77787229032, -122.474813143378) | 11 | 6 | 2 | 54 | 26 | |||
| 91514 | 55089 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 518 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10986 | 5990960.72715 | 2111836.53902 | 37.778179750938 | -122.474845776298 | (37.778179750938, -122.474845776298) | 11 | 6 | 2 | 54 | 26 | ||
| 141237 | 54997 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 516 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 7 | 5x6 | Permit Number 10875 | 5990960.36326 | 2111860.51542 | 37.7782455624536 | -122.474848785636 | (37.7782455624536, -122.474848785636) | 11 | 6 | 2 | 54 | 26 | |
| 160097 | 54998 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 534 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 10 | Permit Number 10876 | 5990962.96365 | 2111750.1463 | 37.7779426698765 | -122.474831732013 | (37.7779426698765, -122.474831732013) | 11 | 6 | 2 | 54 | 26 | ||
| 161271 | 55090 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 522 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10987 | 5990959.39462 | 2111814.61979 | 37.7781194895386 | -122.47484878563 | (37.7781194895386, -122.47484878563) | 11 | 6 | 2 | 54 | 26 | ||
| 142451 | 54970 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 542 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/1972 12:00:00 AM | 9 | Permit Number 10848 | 5993164.55901 | 2111769.98644 | 37.7781244795562 | -122.467217143666 | (37.7781244795562, -122.467217143666) | 11 | 6 | 2 | 54 | 11 | ||
| 163914 | 54973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 570 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/1972 12:00:00 AM | 8 | Permit Number 10851 | 5993170.16242 | 2111603.62161 | 37.7776680101154 | -122.467185660412 | (37.7776680101154, -122.467185660412) | 11 | 6 | 2 | 54 | 11 | ||
| 81383 | 10049 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 389 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2003 12:00:00 AM | 3 | 3X3 | 6005557.3779151 | 2106729.2709881 | 37.7649914764619 | -122.42398730533 | (37.7649914764619, -122.42398730533) | 8 | 4 | 5 | 28853 | 19 | ||
| 128142 | 45665 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1610 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2001 12:00:00 AM | 9 | Permit Number 44361 | 6006993.4943 | 2116431.09301 | 37.7917113145738 | -122.41970856252 | (37.7917113145738, -122.41970856252) | 13 | 9 | 10 | 28858 | 21 | ||
| 154744 | 66170 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29242 | 6009342.82621351 | 2096790.80066071 | 37.7379156423933 | -122.41019259909 | (37.7379156423933, -122.41019259909) | 10 | 7 | 7 | 28859 | 2 | ||
| 194439 | 62177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 33 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780357 | 6000151.49887 | 2091775.04378 | 37.7236240542963 | -122.441611590516 | (37.7236240542963, -122.441611590516) | 9 | 7 | 6 | 28861 | 25 |
| 22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
| 62485 | 65261 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28060 | 6009449.44831989 | 2102437.73284005 | 37.7534268519722 | -122.410222530405 | (37.7534268519722, -122.410222530405) | 2 | 4 | 7 | 28859 | 19 | ||
| 179273 | 56426 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 292 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12587 | 5990281.61207 | 2113449.40035 | 37.7825688429946 | -122.477312959682 | (37.7825688429946, -122.477312959682) | 11 | 6 | 2 | 55 | 26 | ||
| 27779 | 92558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52904 | 5989977.22773 | 2113271.83238 | 37.7820636253324 | -122.478352998578 | (37.7820636253324, -122.478352998578) | 11 | 6 | 2 | 55 | 26 | |
| 7645 | 56389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.7277249515347 | -122.386350953513 | (37.7277249515347, -122.386350953513) | 10 | 3 | 8 | 58 | 1 | ||
| 19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
| 49667 | 53512 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1362 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12547 | 6016030.8057 | 2093035.8489 | 37.727977908748 | -122.38680697572 | (37.727977908748, -122.38680697572) | 10 | 3 | 8 | 58 | 1 | ||
| 79896 | 56392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1363 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 9 | Permit Number 12548 | 6016014.8311 | 2092970.2978 | 37.7277970339363 | -122.386857631263 | (37.7277970339363, -122.386857631263) | 10 | 3 | 8 | 58 | 1 | ||
| 100096 | 56386 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1310 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 13 | Permit Number 12538 | 6016291.3574 | 2092843.6025 | 37.727464460543 | -122.385892838032 | (37.727464460543, -122.385892838032) | 10 | 3 | 8 | 58 | 1 | ||
| 108502 | 56391 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1344 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12544 | 6016127.2043 | 2092964.2385 | 37.7277866175614 | -122.386468729017 | (37.7277866175614, -122.386468729017) | 10 | 3 | 8 | 58 | 1 | ||
| 113371 | 53509 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 4 | Permit Number 12537 | 6016318.8998 | 2092822.1194 | 37.7274069963434 | -122.385796126204 | (37.7274069963434, -122.385796126204) | 10 | 3 | 8 | 58 | 1 | ||
| 138175 | 56385 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 8 | Permit Number 12536 | 6016338.1795 | 2092806.6957 | 37.7273657127679 | -122.385728401086 | (37.7273657127679, -122.385728401086) | 10 | 3 | 8 | 58 | 1 | ||
| 144127 | 53510 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1326 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12541 | 6016208.73 | 2092903.6451 | 37.7276247527235 | -122.386182668022 | (37.7276247527235, -122.386182668022) | 10 | 3 | 8 | 58 | 1 | ||
| 178893 | 56393 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1367 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12549 | 6015984.5344 | 2092993.9843 | 37.7278603948519 | -122.386964019791 | (37.7278603948519, -122.386964019791) | 10 | 3 | 8 | 58 | 1 | ||
| 180551 | 56388 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1322 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 12 | Permit Number 12540 | 6016246.7386 | 2092876.1026 | 37.7275512300997 | -122.386049351457 | (37.7275512300997, -122.386049351457) | 10 | 3 | 8 | 58 | 1 | ||
| 57323 | 56315 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 234 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12449 | 5993086.94537 | 2113893.42731 | 37.7839503904288 | -122.467640101935 | (37.7839503904288, -122.467640101935) | 11 | 6 | 2 | 54 | 11 | ||
| 63351 | 56312 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 225 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 9 | Permit Number 12446 | 5993038.82882 | 2113952.32181 | 37.7841093203597 | -122.467810851014 | (37.7841093203597, -122.467810851014) | 11 | 6 | 2 | 54 | 11 | ||
| 163155 | 56311 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 211 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 7 | Permit Number 12445 | 5993036.23894 | 2114024.56075 | 37.784307519182 | -122.467825066835 | (37.784307519182, -122.467825066835) | 11 | 6 | 2 | 54 | 11 | ||
| 7526 | 54915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 491 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10781 | 6011237.02996 | 2106095.07508 | 37.7635691382211 | -122.404298060519 | (37.7635691382211, -122.404298060519) | 8 | 3 | 8 | 28856 | 29 | ||
| 139532 | 54810 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1026 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 11 | Permit Number 10663 | 6012161.95384 | 2103585.91754 | 37.7567311880086 | -122.400922718734 | (37.7567311880086, -122.400922718734) | 10 | 3 | 8 | 28856 | 29 | ||
| 115655 | 32272 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2170 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1996 12:00:00 AM | 9 | Permit Number 36858 | 5990725.74886 | 2100621.09548 | 37.7473715261751 | -122.474839805332 | (37.7473715261751, -122.474839805332) | 1 | 8 | 4 | 29491 | 40 | ||
| 78926 | 60175 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25533 | 6005979.27726365 | 2105187.71035503 | 37.7607825242813 | -122.42241851621 | (37.7607825242813, -122.42241851621) | 2 | 4 | 5 | 28859 | 19 | ||
| 33832 | 62064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.7632636666362 | -122.500827758091 | (37.7632636666362, -122.500827758091) | 1 | 8 | 3 | 56 | 35 | ||
| 19821 | 4865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/14/1992 12:00:00 AM | 35 | 3X3 | 6000909.0364823 | 2098039.6345395 | 37.7408683019977 | -122.439441771578 | (37.7408683019977, -122.439441771578) | 2 | 7 | 5 | 63 | 7 | ||
| 25945 | 62056 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | 13 | 9 | 1 | 57 | 17 | ||
| 54526 | 40684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | 9 | 7 | 6 | 28861 | 5 | ||
| 94086 | 58957 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 573 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1993 12:00:00 AM | 7 | Permit Number 32270 | 5994672.72826 | 2111619.94034 | 37.7777994373643 | -122.461988995399 | (37.7777994373643, -122.461988995399) | 11 | 6 | 2 | 54 | 11 | ||
| 48295 | 54813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 330 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 10 | Permit Number 10667 | 5997647.89997 | 2115270.37281 | 37.7879934021327 | -122.451960326717 | (37.7879934021327, -122.451960326717) | 11 | 6 | 1 | 54 | 31 | ||
| 184311 | 64229 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 290 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | Permit Number 25022 | 6010413.42426416 | 2099945.44819884 | 37.7466375738905 | -122.406713254495 | (37.7466375738905, -122.406713254495) | 2 | 7 | 7 | 28859 | 2 | ||
| 43794 | 32060 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3641 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 4 | Permit Number 35437 | 6004597.15155 | 2105983.21796 | 37.7628887345501 | -122.427255342182 | (37.7628887345501, -122.427255342182) | 8 | 4 | 5 | 28862 | 3 | |
| 85594 | 32090 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3983 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 6 | Permit Number 35463 | 6003141.07697 | 2104736.86022 | 37.759384082832 | -122.432202380562 | (37.759384082832, -122.432202380562) | 2 | 4 | 5 | 28862 | 3 | |
| 106486 | 66536 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839585 | (37.7287144005277, -122.41162839585) | 9 | 3 | 7 | 309 | 28 | |
| 178784 | 68283 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 653 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 6 | Permit Number 32092 | 6008989.79233 | 2093018.55465 | 37.7275380702003 | -122.411146829576 | (37.7275380702003, -122.411146829576) | 9 | 3 | 7 | 309 | 28 | |
| 187653 | 68276 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 543 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 6 | Permit Number 32083 | 6008845.70964 | 2093488.4538 | 37.7288202318587 | -122.411678113946 | (37.7288202318587, -122.411678113946) | 9 | 3 | 7 | 309 | 28 | |
| 74635 | 54765 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 179 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 9 | Permit Number 10614 | 6012917.58994 | 2087110.3835 | 37.7115349095784 | -122.397154203219 | (37.7115349095784, -122.397154203219) | 10 | 3 | 8 | 309 | 1 | ||
| 156478 | 88716 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | ||
| 178960 | 62947 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 121 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | 15 | Permit Number 23329 | 6007211.24104465 | 2097034.38673891 | 37.7384647641833 | -122.417579811496 | (37.7384647641833, -122.417579811496) | 2 | 7 | 7 | 28859 | 2 | |
| 129858 | 56162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 547 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778533 | 5990919.363 | 2111652.3047 | 37.7776714970248 | -122.474975416646 | (37.7776714970248, -122.474975416646) | 11 | 6 | 2 | 54 | 26 | ||
| 129854 | 38361 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1626 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40425 | 5980991.46797396 | 2103984.91123867 | 37.756038708992 | -122.5087493697 | (37.756038708992, -122.5087493697) | 1 | 8 | 3 | 56 | 35 | ||
| 191388 | 38376 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | Permit Number 40435 | 5982211.97867906 | 2102828.4142054 | 37.7529351608085 | -122.504442832568 | (37.7529351608085, -122.504442832568) | 1 | 8 | 3 | 56 | 35 | ||
| 122615 | 31651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.504805016487 | (37.736233320022, -122.504805016487) | 1 | 8 | 3 | 29491 | 35 | |
| 180962 | 43130 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 64 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/02/2003 12:00:00 AM | Permit Number 42948 | 6007257.5436596 | 2099135.12051049 | 37.7442355171504 | -122.417568566517 | (37.7442355171504, -122.417568566517) | 2 | 7 | 7 | 28859 | 2 | ||
| 126760 | 22807 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.7455120267519 | -122.446479507446 | (37.7455120267519, -122.446479507446) | 2 | 7 | 5 | 63 | 7 | ||
| 151365 | 54449 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 447 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10234 | 6011226.09198 | 2106274.47363 | 37.7640611150446 | -122.404348519663 | (37.7640611150446, -122.404348519663) | 8 | 3 | 8 | 28856 | 29 | ||
| 181381 | 54522 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 455 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | 11 | 3x3 | Permit Number 10316 | 6012987.2061 | 2104898.57156 | 37.760381447175 | -122.398160764916 | (37.760381447175, -122.398160764916) | 10 | 3 | 8 | 28856 | 29 | |
| 56078 | 38346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.504175425295 | (37.7518433707941, -122.504175425295) | 1 | 8 | 3 | 56 | 35 | |
| 69457 | 38344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | 1 | 8 | 3 | 56 | 35 | |
| 104318 | 34699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 783 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38358 | 5981962.67601 | 2110441.20269 | 37.7738230269301 | -122.505869302151 | (37.7738230269301, -122.505869302151) | 11 | 6 | 2 | 55 | 26 | |
| 171017 | 34645 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1514 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38324 | 5987781.2369 | 2104967.961 | 37.7591357755256 | -122.485340512692 | (37.7591357755256, -122.485340512692) | 1 | 8 | 3 | 56 | 35 | |
| 100228 | 43816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2633 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986134.8144 | 2097343.6322 | 37.738105378566 | -122.490473636095 | (37.738105378566, -122.490473636095) | 1 | 8 | 3 | 29491 | 35 | |
| 170090 | 43815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2633 33rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2000 12:00:00 AM | 4 | Permit Number 43447 | 5986135.8757 | 2097320.2838 | 37.7380413320507 | -122.490468249476 | (37.7380413320507, -122.490468249476) | 1 | 8 | 3 | 29491 | 35 | |
| 27153 | 67346 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 855 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30832 | 6010206.11053857 | 2104246.74223384 | 37.7584363722785 | -122.407733365614 | (37.7584363722785, -122.407733365614) | 10 | 4 | 7 | 28859 | 19 | ||
| 50639 | 67344 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 845 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30830 | 6010203.04777611 | 2104302.92364301 | 37.7585904623549 | -122.407747919472 | (37.7585904623549, -122.407747919472) | 10 | 4 | 7 | 28859 | 19 | ||
| 84243 | 54629 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1693 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 11 | Permit Number 10452 | 6012827.80218 | 2095784.63135 | 37.7353476380685 | -122.39807268081 | (37.7353476380685, -122.39807268081) | 10 | 3 | 8 | 58 | 1 | ||
| 69032 | 51091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 780 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | Permit Number 47548 | 6001488.77752298 | 2100017.17375191 | 37.7463311353619 | -122.437578831852 | (37.7463311353619, -122.437578831852) | 2 | 7 | 5 | 63 | 22 | |||
| 66511 | 43782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.29398 | 2114516.23084 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | 11 | 6 | 2 | 55 | 26 | |
| 90836 | 64569 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1429 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | Permit Number 25462 | 6000923.9519361 | 2111020.37522765 | 37.7765110963127 | -122.440320891248 | (37.7765110963127, -122.440320891248) | 15 | 5 | 11 | 29492 | 10 | ||
| 68497 | 99961 | Property Tree 8 | Callistemon citrinus :: Lemon Bottlebrush 67 | 537 Valley St | 1 | Front Yard : Yard | Tree | Private 2 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459 | 2099152 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | 2 | 7 | 5 | 63 | 22 | |||
| 37915 | 43699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992748.80796 | 2111348.45458 | 37.7769430589995 | -122.468624685117 | (37.7769430589995, -122.468624685117) | 11 | 6 | 2 | 54 | 11 | |
| 131960 | 43698 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992720.92787 | 2111349.56559 | 37.7769444989499 | -122.468721210908 | (37.7769444989499, -122.468721210908) | 11 | 6 | 2 | 54 | 11 | |
| 134998 | 43663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 646 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 3 | Permit Number 43306 | 5992570.03325 | 2111039.10475 | 37.7760833392201 | -122.469220595166 | (37.7760833392201, -122.469220595166) | 11 | 6 | 2 | 54 | 11 | |
| 59223 | 66041 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1990 12:00:00 AM | 13 | Permit Number 29080 | 6004614.4703 | 2093089.36495 | 37.7274861568572 | -122.426277398677 | (37.7274861568572, -122.426277398677) | 9 | 7 | 6 | 28861 | 5 | ||
| 121445 | 54628 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 8 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1972 12:00:00 AM | 8 | Permit Number 10451 | 6012754.31078 | 2095657.32991 | 37.734994001272 | -122.398317840498 | (37.734994001272, -122.398317840498) | 10 | 3 | 8 | 58 | 1 | ||
| 156779 | 92263 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2530 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52711 | 5992102.6 | 2098202.2 | 37.7408095493016 | -122.469902704935 | (37.7408095493016, -122.469902704935) | 1 | 8 | 4 | 59 | 40 | ||
| 153126 | 50248 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52899 | 5985267.5978 | 2105900.7074 | 37.7615500789995 | -122.49410249664 | (37.7615500789995, -122.49410249664) | 1 | 8 | 3 | 56 | 35 | |
| 6980 | 43621 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
| 41349 | 43584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43245 | 6005148.55344947 | 2099289.0817491 | 37.7445393628941 | -122.424871957382 | (37.7445393628941, -122.424871957382) | 2 | 7 | 5 | 63 | 22 | ||
| 53062 | 43620 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
| 63650 | 43622 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
| 80478 | 43619 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
| 94137 | 43556 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 338 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43219 | 6003694.36665872 | 2099553.79617946 | 37.745183962731 | -122.429919119626 | (37.745183962731, -122.429919119626) | 2 | 7 | 5 | 63 | 22 | ||
| 117404 | 43562 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 406 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43223 | 6003924.16559982 | 2098981.19483718 | 37.7436247428067 | -122.429083695417 | (37.7436247428067, -122.429083695417) | 2 | 7 | 5 | 63 | 22 |
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) );