trees
1,121 rows where qSpecies_id = 6 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76042 | 79199 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | 11 | 6 | 1 | 54 | 31 | |
| 76341 | 47469 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2907 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/14/2002 12:00:00 AM | 4 | Permit Number 45370 | 5999522.715 | 2114292.4911 | 37.7854156010234 | -122.445403484856 | (37.7854156010234, -122.445403484856) | 15 | 6 | 1 | 29490 | 31 | |
| 76667 | 95935 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.4875820769 | (37.7758745231149, -122.4875820769) | 11 | 6 | 2 | 55 | 26 |
| 76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
| 77796 | 83657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 7 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 7 | Permit Number 769748 | 6003905.60089 | 2093401.91906 | 37.728304266518 | -122.428750235745 | (37.728304266518, -122.428750235745) | 9 | 7 | 6 | 28861 | 5 | |
| 79056 | 94672 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 658 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53808 | 5997731.1 | 2095032.6 | 37.732430335747 | -122.450213143469 | (37.732430335747, -122.450213143469) | 9 | 7 | 4 | 59 | 40 | |
| 80475 | 92440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1352 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52830 | 5982162.934 | 2105885.2573 | 37.7613255007309 | -122.504838927947 | (37.7613255007309, -122.504838927947) | 1 | 8 | 3 | 56 | 35 |
| 84495 | 52937 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.7294958700207 | -122.435099629266 | (37.7294958700207, -122.435099629266) | 9 | 7 | 6 | 28861 | 25 | |
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 84873 | 69398 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.44104 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | 9 | 7 | 6 | 28861 | 5 | |
| 86722 | 94695 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 12 Dehon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53832 | 6003771 | 2106542 | 37.7643762595393 | -122.430152577782 | (37.7643762595393, -122.430152577782) | 8 | 4 | 5 | 28862 | 3 | |
| 86891 | 41786 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011862.44614 | 2107450.91483 | 37.7673268978362 | -122.402230262809 | (37.7673268978362, -122.402230262809) | 8 | 2 | 8 | 28853 | 20 | |
| 89273 | 38913 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 91948 | 109136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.47436 | 2111505.41074 | 37.7768703987748 | -122.498566890903 | (37.7768703987748, -122.498566890903) | 11 | 6 | 2 | 55 | 26 |
| 92269 | 165133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995820.38989 | 2094571.40487 | 37.731054476063 | -122.456785533051 | (37.731054476063, -122.456785533051) | 9 | 7 | 4 | 28861 | 40 |
| 92859 | 96110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 714 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767765 | 5982615.54512 | 2110891.71154 | 37.7750983990599 | -122.503644329704 | (37.7750983990599, -122.503644329704) | 11 | 6 | 2 | 55 | 26 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
| 94732 | 88465 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 955X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
| 95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
| 96851 | 82945 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52470 | 6007551.81764 | 2093700.90463 | 37.7293309082802 | -122.416166238177 | (37.7293309082802, -122.416166238177) | 9 | 3 | 7 | 309 | 28 |
| 97730 | 41784 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011899.9957 | 2107451.97946 | 37.7673319169733 | -122.40210045827 | (37.7673319169733, -122.40210045827) | 8 | 2 | 8 | 28853 | 20 | |
| 99236 | 46892 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
| 100769 | 254857 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1353 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 5x5 | 6001388 | 2110371 | 37.7747544855289 | -122.438669077925 | (37.7747544855289, -122.438669077925) | 15 | 5 | 11 | 29492 | 10 | |
| 103230 | 49761 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 366@ REY Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46555 | 6008949.54261 | 2087928.88077 | 37.713560633393 | -122.41092664676 | (37.713560633393, -122.41092664676) | 9 | 7 | 8 | 309 | 39 | |
| 103589 | 49895 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1411 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46669 | 6007945.54854347 | 2107355.95750477 | 37.7668467518318 | -122.415771573837 | (37.7668467518318, -122.415771573837) | 8 | 4 | 7 | 28853 | 19 |
| 104233 | 102092 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 105283 | 83202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | 11 | 6 | 2 | 55 | 26 | |||
| 106563 | 95938 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.7747452702656 | -122.488574294001 | (37.7747452702656, -122.488574294001) | 11 | 6 | 2 | 55 | 26 |
| 107198 | 50036 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.62107 | 2093714.43935 | 37.7293838567558 | -122.415196429982 | (37.7293838567558, -122.415196429982) | 9 | 3 | 7 | 309 | 28 | |
| 108082 | 41787 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011846.53611 | 2107450.83181 | 37.7673257817889 | -122.402285287842 | (37.7673257817889, -122.402285287842) | 8 | 2 | 8 | 28853 | 20 | |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 109142 | 96082 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 448 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767705 | 5982547.81502 | 2112777.55396 | 37.7802723877651 | -122.504018332463 | (37.7802723877651, -122.504018332463) | 11 | 6 | 2 | 55 | 26 | |
| 109198 | 94671 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53807 | 5997755.7 | 2095032.2 | 37.7324306451966 | -122.450128067067 | (37.7324306451966, -122.450128067067) | 9 | 7 | 4 | 59 | 40 | |
| 110666 | 254576 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2138 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781492 | 5982342.68444 | 2100548.37441 | 37.7466824957237 | -122.50382198427 | (37.7466824957237, -122.50382198427) | 1 | 8 | 3 | 29491 | 35 | |
| 114221 | 95521 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.493907267319 | (37.7587753414156, -122.493907267319) | 1 | 8 | 3 | 56 | 35 |
| 114989 | 50035 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 73 University St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46766 | 6007848.45417861 | 2093691.5625558 | 37.7293219318135 | -122.415140074598 | (37.7293219318135, -122.415140074598) | 9 | 3 | 7 | 309 | 28 | ||
| 116939 | 67239 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 3x9 | Permit Number 30703 | 6003792.49486353 | 2108815.33294247 | 37.770619498227 | -122.430240430849 | (37.770619498227, -122.430240430849) | 15 | 9 | 11 | 29492 | 10 | |
| 117146 | 39959 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 492 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 2 | Permit Number 43327 | 5993771.39961 | 2112170.75464 | 37.7792598926327 | -122.465146995833 | (37.7792598926327, -122.465146995833) | 11 | 6 | 2 | 54 | 11 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 117931 | 74157 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | Permit Number 768269 | 6008310.54477322 | 2097714.64471242 | 37.740394399357 | -122.413827044611 | (37.740394399357, -122.413827044611) | 2 | 7 | 7 | 28859 | 2 | ||
| 120663 | 82736 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.7551159683234 | -122.49732843264 | (37.7551159683234, -122.49732843264) | 1 | 8 | 3 | 56 | 35 |
| 120971 | 95999 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767649 | 6014786.9 | 2096088.7 | 37.7362914700729 | -122.39132054684 | (37.7362914700729, -122.39132054684) | 10 | 3 | 8 | 58 | 1 | |
| 121138 | 95828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 174 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767563 | 6010564.55165 | 2110346.83579 | 37.775205897855 | -122.406923649213 | (37.775205897855, -122.406923649213) | 8 | 2 | 9 | 28853 | 34 |
| 126848 | 41809 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 2 | Permit Number 42201 | 5999967.3577 | 2112168.7485 | 37.7796097242619 | -122.443712533479 | (37.7796097242619, -122.443712533479) | 15 | 5 | 1 | 29490 | 16 | |
| 127936 | 52557 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1671 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 5 | Permit Number 48653 | 5984052.4061 | 2103791.5706 | 37.7556877987927 | -122.498149511058 | (37.7556877987927, -122.498149511058) | 1 | 8 | 3 | 56 | 35 | |
| 129402 | 82909 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Princeton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52470 | 6007555.60486 | 2093720.99529 | 37.7293862858368 | -122.416154567675 | (37.7293862858368, -122.416154567675) | 9 | 3 | 7 | 309 | 28 |
| 131191 | 71549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.414625660841 | (37.7875672592553, -122.414625660841) | 5 | 1 | 10 | 28858 | 21 |
| 131707 | 52954 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 975 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 5 | Permit Number 48941 | 6000767.51384 | 2091342.11633 | 37.7224704120511 | -122.439451120374 | (37.7224704120511, -122.439451120374) | 9 | 7 | 6 | 28861 | 25 | |
| 132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
| 134165 | 258203 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2422 41st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781120 | 5983650.02463 | 2098655.15546 | 37.741561019666 | -122.499161539913 | (37.741561019666, -122.499161539913) | 1 | 8 | 3 | 29491 | 35 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 135075 | 52442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.431503592933 | (37.7920224826905, -122.431503592933) | 13 | 9 | 1 | 29490 | 27 | |
| 136000 | 95898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989073.1619 | 2103670.6386 | 37.755648856222 | -122.48077749294 | (37.755648856222, -122.48077749294) | 1 | 8 | 3 | 56 | 35 |
| 136480 | 83533 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 242 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769751 | 6002979.54268 | 2092016.08462 | 37.724446620113 | -122.431852745731 | (37.724446620113, -122.431852745731) | 9 | 7 | 6 | 28861 | 5 |
| 136837 | 95677 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 231 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767429 | 6006245.60839 | 2092760.95718 | 37.7266764855102 | -122.420615232913 | (37.7266764855102, -122.420615232913) | 9 | 7 | 7 | 309 | 5 |
| 138739 | 82870 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.39976 | 2094273.0498 | 37.730850041274 | -122.419392243064 | (37.730850041274, -122.419392243064) | 9 | 7 | 7 | 309 | 5 |
| 140513 | 86510 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1280 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987725.9187 | 2106586.638 | 37.7635769970805 | -122.485650622827 | (37.7635769970805, -122.485650622827) | 1 | 8 | 3 | 56 | 35 | |
| 140514 | 95742 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.44311 | 2091416.58174 | 37.7229052675357 | -122.425411786848 | (37.7229052675357, -122.425411786848) | 9 | 7 | 6 | 28861 | 5 |
| 140711 | 41785 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | 8 | 2 | 8 | 28853 | 20 | |
| 145329 | 110718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||||
| 145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
| 145694 | 40073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | 10 | 3 | 8 | 58 | 1 | |
| 146089 | 52362 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.93646 | 2117377.76116 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | 5 | 1 | 10 | 28858 | 21 | |
| 146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
| 148517 | 109183 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 148668 | 49802 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 101 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46598 | 6014071 | 2106574 | 37.765042114519 | -122.394529717904 | (37.765042114519, -122.394529717904) | 14 | 3 | 8 | 28856 | 29 | ||
| 148992 | 94654 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53793 | 6003689 | 2095884 | 37.7351072400417 | -122.429675988088 | (37.7351072400417, -122.429675988088) | 2 | 7 | 5 | 63 | 7 | |
| 150802 | 61555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1175- 1175 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781207 | 6012252.19835 | 2102963.49184 | 37.7550271768774 | -122.400566896541 | (37.7550271768774, -122.400566896541) | 10 | 3 | 8 | 28856 | 29 |
| 152525 | 109744 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.7583589503944 | -122.507191346523 | (37.7583589503944, -122.507191346523) | 1 | 8 | 3 | 56 | 35 |
| 152713 | 48663 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1300 11th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2002 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.7638910715093 | -122.468357408335 | (37.7638910715093, -122.468357408335) | 1 | 8 | 11 | 56 | 12 | ||
| 152733 | 40072 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.7308327545053 | -122.393144818701 | (37.7308327545053, -122.393144818701) | 10 | 3 | 8 | 58 | 1 | |
| 152989 | 47678 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | 10 | 3 | 8 | 28856 | 29 | |
| 154355 | 38914 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 70 Borica St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40725 | 5992519.41888039 | 2091685.55807474 | 37.7229405587858 | -122.467987623931 | (37.7229405587858, -122.467987623931) | 9 | 8 | 4 | 59 | 40 | ||
| 154918 | 52292 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48451 | 6006201.82590602 | 2099532.89904471 | 37.7452682661505 | -122.421247257698 | (37.7452682661505, -122.421247257698) | 2 | 7 | 5 | 28859 | 2 | ||
| 155044 | 52456 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.7741102732547 | -122.469236887906 | (37.7741102732547, -122.469236887906) | 11 | 6 | 2 | 54 | 11 | |
| 155117 | 94712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) | 11 | 6 | 2 | 54 | 11 |
| 156644 | 41807 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999913.2102 | 2112161.3032 | 37.7795861928813 | -122.443899317319 | (37.7795861928813, -122.443899317319) | 15 | 5 | 1 | 29490 | 16 | |
| 158624 | 49803 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | 14 | 3 | 8 | 28856 | 29 | |
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 165167 | 95901 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1700 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092 | 2103686.6 | 37.7556937768723 | -122.480713514054 | (37.7556937768723, -122.480713514054) | 1 | 8 | 3 | 56 | 35 | |
| 166701 | 254575 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2446 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781489 | 5983035.61421 | 2098477.14413 | 37.7410361869592 | -122.501272763587 | (37.7410361869592, -122.501272763587) | 1 | 8 | 3 | 29491 | 35 | |
| 166705 | 92392 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2506 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52796 | 5986151.5297 | 2098152.0694 | 37.7403261082431 | -122.490475302823 | (37.7403261082431, -122.490475302823) | 1 | 8 | 3 | 29491 | 35 |
| 167406 | 176915 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 143 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778564 | 6009701.03874 | 2093769.75693 | 37.7296405745301 | -122.408741008189 | (37.7296405745301, -122.408741008189) | 10 | 3 | 7 | 309 | 28 |
| 167721 | 102093 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 167882 | 94679 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 218 Roanoke St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547 | 2096007 | 37.7354369283878 | -122.430175705062 | (37.7354369283878, -122.430175705062) | 2 | 7 | 5 | 63 | 7 | |
| 169035 | 47267 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1386 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45208 | 5988680.1995 | 2105896.4201 | 37.7617374028544 | -122.48229953296 | (37.7617374028544, -122.48229953296) | 1 | 8 | 3 | 56 | 35 | |
| 169615 | 109265 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260 | 2101732.7 | 37.7499882212347 | -122.500737615767 | (37.7499882212347, -122.500737615767) | 1 | 8 | 3 | 29491 | 35 |
| 171342 | 47598 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | 10 | 7 | 7 | 28859 | 2 | ||
| 171435 | 258215 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2400 43rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2019 12:00:00 AM | 3 | Permit Number 783182 | 5983025.27936 | 2098776.48804 | 37.7418574964013 | -122.501330634264 | (37.7418574964013, -122.501330634264) | 1 | 8 | 3 | 29491 | 35 | ||
| 171605 | 83555 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 117X Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769748 | 6003936.82497 | 2093347.62291 | 37.7281569485605 | -122.428638423918 | (37.7281569485605, -122.428638423918) | 9 | 7 | 6 | 28861 | 5 |
| 171991 | 47551 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | 2 | 7 | 5 | 63 | 22 | ||
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
| 175408 | 95911 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) | 1 | 8 | 3 | 56 | 35 |
| 175521 | 41812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Anzavista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 3 | Permit Number 42201 | 5999993.4162 | 2112171.4558 | 37.7796186440476 | -122.44362258073 | (37.7796186440476, -122.44362258073) | 15 | 5 | 1 | 29490 | 16 | |
| 176365 | 68842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 602 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2004 12:00:00 AM | 5 | 3x3 | Permit Number 767166 | 6014359.28345 | 2104329.14494 | 37.7588942535933 | -122.393375500204 | (37.7588942535933, -122.393375500204) | 10 | 3 | 8 | 28856 | 29 |
| 177940 | 50032 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 33 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 5 | Permit Number 46764 | 6007353.74197 | 2093754.84576 | 37.7294678795239 | -122.416854825683 | (37.7294678795239, -122.416854825683) | 9 | 3 | 7 | 309 | 28 | |
| 178343 | 46893 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1383 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44948 | 5992692.47897134 | 2106059.86172468 | 37.7624187406256 | -122.468434681685 | (37.7624187406256, -122.468434681685) | 1 | 8 | 11 | 56 | 12 | ||
| 178982 | 95429 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767294 | 5988962.2823 | 2105532.8441 | 37.760755525792 | -122.481297307618 | (37.760755525792, -122.481297307618) | 1 | 8 | 3 | 56 | 35 |
| 179141 | 104731 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.54792 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | 1 | 8 | 4 | 29491 | 40 |
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) );