trees
953 rows where qSpecies_id = 60 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
| 168861 | 95412 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
| 105406 | 95411 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467 | 2095594 | 37.734241695714 | -122.433880155045 | (37.734241695714, -122.433880155045) | 2 | 7 | 5 | 63 | 7 | |
| 98772 | 66797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2655 Polk St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | Permit Number 782624 | 6006123.61383 | 2119959.43623 | 37.8013502149967 | -122.422969232649 | (37.8013502149967, -122.422969232649) | 13 | 9 | 1 | 28858 | 32 | |
| 39542 | 254749 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 164 Escolta Way | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 4x6 | Permit Number 781597 | 5986451.85258 | 2097316.8045 | 37.7380502293434 | -122.489375519691 | (37.7380502293434, -122.489375519691) | 1 | 8 | 3 | 29491 | 35 | |
| 9453 | 260830 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
| 18512 | 260829 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
| 2854 | 255187 | Section 806 (d) 5 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4740 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780757 | 5980843 | 2110991 | 37.7752666409579 | -122.509783220192 | (37.7752666409579, -122.509783220192) | 11 | 6 | 2 | 55 | 26 | |
| 158962 | 56733 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | 10 | 3 | 8 | 58 | 1 | |||
| 12538 | 38150 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2017 12:00:00 AM | 3 | 3x5 | Permit Number 780230 | 6010281.37407 | 2093721.85483 | 37.7295415331127 | -122.406731343599 | (37.7295415331127, -122.406731343599) | 10 | 3 | 7 | 309 | 28 |
| 157029 | 239509 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779587 | 6008753.78485 | 2096712.524 | 37.7376676767118 | -122.412223680483 | (37.7376676767118, -122.412223680483) | 10 | 7 | 7 | 28859 | 2 | |
| 180671 | 114552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | 10 | 3 | 8 | 28856 | 29 | ||
| 142317 | 63711 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 168 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2015 12:00:00 AM | 3x3 | Permit Number 776230 | 6007522.60556555 | 2100213.34826998 | 37.7472110003238 | -122.416728407454 | (37.7472110003238, -122.416728407454) | 2 | 7 | 7 | 28859 | 2 | ||
| 191095 | 47724 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | 8 | 4 | 7 | 28859 | 19 | ||
| 187057 | 114669 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 176X Peralta Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||
| 74586 | 113271 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1321 Revere Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260 | 37.7286210040554 | -122.385097187433 | (37.7286210040554, -122.385097187433) | 10 | 3 | 8 | 58 | 1 | ||||
| 132499 | 108374 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 637 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773812 | 6002670.30203 | 2089919.45736 | 37.7186722135403 | -122.432772041698 | (37.7186722135403, -122.432772041698) | 9 | 7 | 6 | 28861 | 5 | |
| 174509 | 108373 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 637 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773812 | 6002662.58132 | 2089906.96275 | 37.718637468222 | -122.432797836946 | (37.718637468222, -122.432797836946) | 9 | 7 | 6 | 28861 | 5 | |
| 103431 | 52815 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337349 | (37.7957603016641, -122.44363337349) | 13 | 9 | 1 | 57 | 17 | |
| 88423 | 108730 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 |
| 111726 | 108723 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.397959844253 | (37.7565264696642, -122.397959844253) | 10 | 3 | 8 | 28856 | 29 | |
| 153219 | 5139 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2895 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | Permit Number 772999 | 6002420.62305 | 2095396.76149 | 37.7336974920456 | -122.43402640033 | (37.7336974920456, -122.43402640033) | 2 | 7 | 5 | 63 | 7 | ||
| 62252 | 31341 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 430 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772811 | 6005729.4209 | 2111051.1148 | 37.7768679337671 | -122.423699563703 | (37.7768679337671, -122.423699563703) | 7 | 9 | 11 | 28852 | 10 | |
| 44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
| 78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 79831 | 102872 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
| 186025 | 102585 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | |||
| 187776 | 102871 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 173 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.447738107529 | (37.7272185530423, -122.447738107529) | 9 | 7 | 4 | 28861 | 40 | ||||
| 109225 | 63555 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/2012 12:00:00 AM | Permit Number 768997 | 6008364.95764339 | 2103853.79348965 | 37.7572541841117 | -122.414073113457 | (37.7572541841117, -122.414073113457) | 2 | 4 | 7 | 28859 | 19 | ||
| 54578 | 99239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | 1 | 8 | 4 | 59 | 40 | ||||
| 192026 | 95843 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 30 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767866 | 6009338.07268 | 2109475.65364 | 37.7727451297231 | -122.411104783558 | (37.7727451297231, -122.411104783558) | 8 | 2 | 9 | 28853 | 34 |
| 12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 149802 | 96017 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) | 5 | 1 | 10 | 28858 | 21 |
| 166077 | 96016 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884507 | -122.41348521079 | (37.788722884507, -122.41348521079) | 5 | 1 | 10 | 28858 | 21 |
| 117356 | 95997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.7305589972874 | -122.397110809125 | (37.7305589972874, -122.397110809125) | 10 | 3 | 8 | 58 | 1 |
| 69202 | 43888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.7756943547316 | -122.412113186199 | (37.7756943547316, -122.412113186199) | 8 | 2 | 9 | 28853 | 34 |
| 61923 | 95866 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) | 8 | 2 | 9 | 28853 | 34 |
| 129227 | 95797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767539 | 6008624.3 | 2103231.6 | 37.7555603448561 | -122.413132208673 | (37.7555603448561, -122.413132208673) | 2 | 4 | 7 | 28859 | 19 | |
| 84422 | 95534 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767323 | 6004904 | 2102501 | 37.7533447323081 | -122.425946167651 | (37.7533447323081, -122.425946167651) | 2 | 4 | 5 | 28862 | 22 | |
| 185120 | 53646 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4122 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1970 12:00:00 AM | 4x4 | Permit Number 6582 | 6002264.58930584 | 2105323.26782976 | 37.76094448188 | -122.435275644763 | (37.76094448188, -122.435275644763) | 15 | 4 | 5 | 28862 | 3 | ||
| 74296 | 94146 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53554 | 5992756.7 | 2103771.7 | 37.7561397565087 | -122.468046118338 | (37.7561397565087, -122.468046118338) | 1 | 8 | 4 | 56 | 12 | ||
| 150558 | 43896 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 716 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51474 | 6009227.05246 | 2110468.55015 | 37.7754651643179 | -122.411558979885 | (37.7754651643179, -122.411558979885) | 8 | 2 | 9 | 28853 | 34 | |
| 99375 | 88065 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | 10 | 3 | 8 | 58 | 1 | |
| 170132 | 88064 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2055 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51066 | 6012497.5295 | 2096095.30681 | 37.7361822871662 | -122.399236364881 | (37.7361822871662, -122.399236364881) | 10 | 3 | 8 | 58 | 1 | |
| 147067 | 84186 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 467 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50687 | 6010581.88487 | 2088390.34321 | 37.7149191133084 | -122.405317136301 | (37.7149191133084, -122.405317136301) | 9 | 7 | 8 | 309 | 39 | |
| 164498 | 82438 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 34 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50574 | 6003937.17383095 | 2095914.17170256 | 37.7352041342879 | -122.42882011217 | (37.7352041342879, -122.42882011217) | 2 | 7 | 5 | 63 | 7 | ||
| 188225 | 84181 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50119 | 6004433.25452855 | 2097264.30389086 | 37.738939357085 | -122.427201119802 | (37.738939357085, -122.427201119802) | 2 | 7 | 5 | 63 | 7 | ||
| 87233 | 82031 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49837 | 5998319.05661716 | 2095227.73962292 | 37.7329997723608 | -122.448194494208 | (37.7329997723608, -122.448194494208) | 9 | 7 | 4 | 59 | 40 | ||
| 161829 | 53084 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | 8 | 2 | 9 | 28853 | 34 | ||
| 147837 | 52957 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 227 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48944 | 5992946.65383726 | 2088708.6513983 | 37.714791356792 | -122.466294530657 | (37.714791356792, -122.466294530657) | 9 | 8 | 6 | 64 | 24 | ||
| 44825 | 52659 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280509 | (37.8056520959413, -122.44242280509) | 13 | 9 | 1 | 57 | 17 | ||
| 5626 | 52490 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | ||
| 106183 | 52491 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | |||
| 99767 | 52421 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3987 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48541 | 6003110.11516472 | 2104732.93493797 | 37.7593715494171 | -122.432309181209 | (37.7593715494171, -122.432309181209) | 2 | 4 | 5 | 28862 | 3 | |||
| 56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
| 188978 | 51756 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1350 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48024 | 6016094.75384316 | 2092981.324561 | 37.7278317360968 | -122.386582102799 | (37.7278317360968, -122.386582102799) | 10 | 3 | 8 | 58 | 1 | |||
| 138793 | 51290 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 738 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47662 | 5995079.16819472 | 2089446.39884805 | 37.7169398504084 | -122.458977110473 | (37.7169398504084, -122.458977110473) | 9 | 8 | 6 | 28861 | 24 | |||
| 163528 | 51289 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.7180119072102 | -122.45917632674 | (37.7180119072102, -122.45917632674) | 9 | 8 | 6 | 28861 | 24 | |||
| 137328 | 50846 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 5 | Permit Number 47372 | 6003324.61709 | 2090530.54695 | 37.7203872188685 | -122.430553920527 | (37.7203872188685, -122.430553920527) | 9 | 7 | 6 | 28861 | 5 | ||
| 28386 | 49816 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.7583436247676 | -122.400103532548 | (37.7583436247676, -122.400103532548) | 10 | 3 | 8 | 28856 | 29 |
| 90148 | 49815 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.85302 | 2104156.13739 | 37.7583108228906 | -122.400098515246 | (37.7583108228906, -122.400098515246) | 10 | 3 | 8 | 28856 | 29 | |
| 89713 | 49814 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.7582818746203 | -122.400097759826 | (37.7582818746203, -122.400097759826) | 10 | 3 | 8 | 28856 | 29 | |
| 42932 | 49808 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | 14 | 3 | 8 | 28856 | 29 | ||
| 189663 | 33403 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/2003 12:00:00 AM | Permit Number 46425 | 5992447.80765363 | 2094243.66151518 | 37.729960344136 | -122.468421188533 | (37.729960344136, -122.468421188533) | 9 | 8 | 4 | 59 | 40 | ||
| 65125 | 49467 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3624 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46393 | 6006125.2277225 | 2104366.11259234 | 37.7585348409416 | -122.421855375902 | (37.7585348409416, -122.421855375902) | 2 | 4 | 5 | 28859 | 19 |
| 80527 | 49416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.391689093304 | (37.7383045729921, -122.391689093304) | 10 | 3 | 8 | 58 | 1 | ||
| 66804 | 48736 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553 | (37.7355533009373, -122.39050541553) | 10 | 3 | 8 | 58 | 1 | ||
| 111482 | 48643 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45936 | 5993334.71771315 | 2105415.01360696 | 37.7606852319988 | -122.466166570005 | (37.7606852319988, -122.466166570005) | 1 | 8 | 4 | 56 | 12 | ||
| 6670 | 48442 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 54152 | 48439 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 134728 | 48438 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 155439 | 48437 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 174074 | 48440 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | 15 | 6 | 11 | 29490 | 13 | |||
| 176800 | 48441 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2399 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2002 12:00:00 AM | 5 | Permit Number 45814 | 6000736.2676 | 2113774.3561 | 37.784062137114 | -122.441167778959 | (37.784062137114, -122.441167778959) | 15 | 6 | 11 | 29490 | 13 | ||
| 98519 | 48359 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1400X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45770 | 6005451 | 2114476 | 37.7862561057092 | -122.424906431455 | (37.7862561057092, -122.424906431455) | 13 | 9 | 11 | 28858 | 13 | |
| 148813 | 47793 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.486090868119 | (37.7392627758453, -122.486090868119) | 1 | 8 | 3 | 29491 | 35 | |
| 126229 | 47485 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | 7 | Permit Number 45478 | 6001374.27527 | 2093423.01793 | 37.7282186079017 | -122.437502631244 | (37.7282186079017, -122.437502631244) | 9 | 7 | 6 | 28861 | 25 | |
| 105282 | 47486 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | 10 | Permit Number 45383 | 6001387.26681 | 2093436.23595 | 37.7282556401779 | -122.437458665212 | (37.7282556401779, -122.437458665212) | 9 | 7 | 6 | 28861 | 25 | ||
| 164959 | 47376 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 454 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45293 | 5993277.02762299 | 2090193.33113846 | 37.718886987019 | -122.465260409649 | (37.718886987019, -122.465260409649) | 9 | 8 | 6 | 64 | 24 | ||
| 40426 | 47227 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
| 53960 | 47228 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.39624 | 2091994.05057 | 37.724845479317 | -122.403633167442 | (37.724845479317, -122.403633167442) | 10 | 3 | 7 | 309 | 28 | |
| 82760 | 47226 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
| 151801 | 47229 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Girard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | 10 | 3 | 7 | 309 | 28 | ||
| 26486 | 47221 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 32778 | 47219 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | 9 | 3 | 7 | 309 | 28 | |
| 99448 | 47220 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 112888 | 47216 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.03698 | 37.7287813307689 | -122.414003510773 | (37.7287813307689, -122.414003510773) | 9 | 3 | 7 | 309 | 28 | |
| 140714 | 47217 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 157797 | 47218 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | 9 | 3 | 7 | 309 | 28 | ||
| 143512 | 33376 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45124 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.468648408098 | (37.7330764284901, -122.468648408098) | 9 | 8 | 4 | 59 | 40 | ||
| 53155 | 46798 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.462081536077 | (37.7338125312017, -122.462081536077) | 9 | 8 | 4 | 59 | 40 | ||
| 127603 | 45765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.7822453472 | -122.451230630986 | (37.7822453472, -122.451230630986) | 15 | 6 | 1 | 54 | 31 | |
| 164108 | 45767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.7823129863308 | -122.451244120994 | (37.7823129863308, -122.451244120994) | 15 | 6 | 1 | 54 | 31 |
| 132011 | 46402 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44632 | 5997151.20329152 | 2090327.07955038 | 37.7194768863059 | -122.451878625824 | (37.7194768863059, -122.451878625824) | 9 | 8 | 6 | 28861 | 24 | ||
| 40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
| 140237 | 46180 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 321 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2001 12:00:00 AM | Permit Number 44508 | 5996626.00544099 | 2106611.60599874 | 37.7641601102413 | -122.454870012466 | (37.7641601102413, -122.454870012466) | 15 | 5 | 11 | 29492 | 12 | ||
| 81616 | 45782 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.7384201816637 | -122.468357005493 | (37.7384201816637, -122.468357005493) | 1 | 8 | 4 | 59 | 40 | |||
| 47496 | 45707 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.0354809 | 2103995.03426473 | 37.7571302242183 | -122.445339815815 | (37.7571302242183, -122.445339815815) | 2 | 5 | 5 | 28862 | 3 |
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) );