trees
4,014 rows where qSpecies_id = 40 sorted by TreeID
This data as json, CSV (advanced)
rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53915 | 104995 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2220 Castro St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | 2 | 7 | 5 | 63 | 22 | |||
163788 | 105008 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1957 - 1959 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | 11 | 3x3 | Permit Number 771758 | 6004438.4 | 2107144.3 | 37.7660678085542 | -122.427887146988 | (37.7660678085542, -122.427887146988) | 8 | 4 | 5 | 28862 | 3 | ||
33621 | 105147 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.416220575031 | (37.7464458666696, -122.416220575031) | 2 | 7 | 7 | 28859 | 2 | |||
29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
159382 | 105428 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 701 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | 15 | 5x4 | Permit Number 770977 | 6002351 | 2108797 | 37.7704874078199 | -122.435225260833 | (37.7704874078199, -122.435225260833) | 15 | 5 | 5 | 29492 | 9 | |
130599 | 105719 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775548 | 6003614.61217 | 2116568.84347 | 37.7918986253737 | -122.431409307988 | (37.7918986253737, -122.431409307988) | 13 | 9 | 1 | 29490 | 27 | |
69335 | 105728 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82-98X Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862 | 2108710 | 37.7702775320686 | -122.433451492357 | (37.7702775320686, -122.433451492357) | 15 | 5 | 5 | 29492 | 9 |
143336 | 105729 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 82-98X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772582 | 6002862 | 2108710 | 37.7702775320686 | -122.433451492357 | (37.7702775320686, -122.433451492357) | 15 | 5 | 5 | 29492 | 9 |
25179 | 105960 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1937 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2014 12:00:00 AM | 3x3 | Permit Number 772672 | 5989989.1 | 2102175.5 | 37.7515967965888 | -122.477500650678 | (37.7515967965888, -122.477500650678) | 1 | 8 | 3 | 29491 | 35 | ||
28261 | 105980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 750 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772437 | 5989466.79489 | 2110227.47578 | 37.7736750233383 | -122.479895995237 | (37.7736750233383, -122.479895995237) | 11 | 6 | 2 | 55 | 26 | |
134437 | 106104 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 6002644 | 2105609 | 37.7617505722061 | -122.433983855891 | (37.7617505722061, -122.433983855891) | 15 | 4 | 5 | 28862 | 3 | |||
174364 | 106348 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1348X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x5.5 | EXPANDED BASIN from 3x3 to 4x5.5 | 6005187 | 2100476 | 37.7478005400646 | -122.424823440941 | (37.7478005400646, -122.424823440941) | 2 | 4 | 5 | 63 | 22 | |||
187819 | 106551 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 203 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X4 | Permit Number 58742 | 5998066.5 | 2096226.6 | 37.7357279634759 | -122.449139578572 | (37.7357279634759, -122.449139578572) | 9 | 7 | 4 | 59 | 40 | ||||
156500 | 106553 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 213 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2014 12:00:00 AM | 2.5x4 | Permit Number 771194 | 5998005.6 | 2096224.8 | 37.7357195377121 | -122.449350002926 | (37.7357195377121, -122.449350002926) | 9 | 7 | 4 | 59 | 40 | |||
192165 | 106875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2014 12:00:00 AM | 9 | 3x3 | Permit Number 772880 | 5999376.01262 | 2115702.70086 | 37.7892792923525 | -122.446012495778 | (37.7892792923525, -122.446012495778) | 13 | 6 | 1 | 29490 | 31 | |
188709 | 106920 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6006764 | 2107336 | 37.76672546023 | -122.419856949025 | (37.76672546023, -122.419856949025) | 8 | 4 | 7 | 28853 | 19 | ||||
81042 | 106983 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1737-1795 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/01/2012 12:00:00 AM | 4 | 6003734.5 | 2114103.2 | 37.7851353863698 | -122.430818459211 | (37.7851353863698, -122.430818459211) | 13 | 9 | 11 | 29490 | 13 | |||
192951 | 106990 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1737-1795 Post St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2014 02:15:00 PM | 3 | 6003734.5 | 2114103.2 | 37.7851353863698 | -122.430818459211 | (37.7851353863698, -122.430818459211) | 13 | 9 | 11 | 29490 | 13 | |||
100038 | 106991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2014 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427 | -122.429819799587 | (37.785503891427, -122.429819799587) | 13 | 9 | 11 | 29490 | 13 | ||||
104168 | 106992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1701X Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2012 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427 | -122.429819799587 | (37.785503891427, -122.429819799587) | 13 | 9 | 11 | 29490 | 13 | ||||
82166 | 10703 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | 9 | 8 | 6 | 64 | 24 | |||
181539 | 107126 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1234 DIAMOND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6001925.9 | 2100390.5 | 37.7473810444908 | -122.436094026786 | (37.7473810444908, -122.436094026786) | 2 | 4 | 5 | 63 | 22 | |||
70712 | 107827 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90x FERN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006921 | 2115099 | 37.7880496324193 | -122.419864826729 | (37.7880496324193, -122.419864826729) | 13 | 9 | 10 | 28858 | 21 | |||
185715 | 107937 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 613 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772422 | 5994837.09376 | 2092346.05841 | 37.7248877040282 | -122.460023781173 | (37.7248877040282, -122.460023781173) | 9 | 8 | 4 | 28861 | 40 | |
58230 | 107938 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 613 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772422 | 5994837.09376 | 2092346.05841 | 37.7248877040282 | -122.460023781173 | (37.7248877040282, -122.460023781173) | 9 | 8 | 4 | 28861 | 40 | |
151241 | 107953 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Danvers St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.7601351040878 | -122.443202492583 | (37.7601351040878, -122.443202492583) | 2 | 4 | 5 | 28862 | 3 | |
99889 | 107954 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 105 Danvers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.7601351040878 | -122.443202492583 | (37.7601351040878, -122.443202492583) | 2 | 4 | 5 | 28862 | 3 | |
57460 | 108081 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
193932 | 108082 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
74075 | 108083 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
194236 | 108084 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 626 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010239.31853 | 2105432.72154 | 37.7616946632209 | -122.407702139761 | (37.7616946632209, -122.407702139761) | 10 | 4 | 8 | 28859 | 19 | |||||
22165 | 108189 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 490X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013735.53307 | 2112587.71036 | 37.7815357570631 | -122.396111508062 | (37.7815357570631, -122.396111508062) | 6 | 2 | 9 | 28856 | 6 | ||||
175154 | 108241 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 201 SUSSEX ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775545 | 6001706.4 | 2096365.4 | 37.7363165900689 | -122.436564983425 | (37.7363165900689, -122.436564983425) | 2 | 7 | 5 | 63 | 7 | |
126431 | 108310 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1563 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | 5986200.15787 | 2104606.03112 | 37.7580497793679 | -122.490781932561 | (37.7580497793679, -122.490781932561) | 1 | 8 | 3 | 56 | 35 | |||
16875 | 108379 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 125 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 01:08:00 PM | 3 | 3x3 | Permit Number 773806 | 6000690.09097 | 2090159.58738 | 37.7192190489897 | -122.439634019098 | (37.7192190489897, -122.439634019098) | 9 | 7 | 6 | 28861 | 25 |
188794 | 108402 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1285 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772748 | 6010079.79191 | 2101731.52319 | 37.7515230698123 | -122.407992860037 | (37.7515230698123, -122.407992860037) | 2 | 4 | 7 | 28859 | 19 |
2772 | 108460 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 944 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773734 | 6010189.19593 | 2103716.38941 | 37.7569791954421 | -122.407754468243 | (37.7569791954421, -122.407754468243) | 2 | 4 | 7 | 28859 | 19 |
110119 | 108498 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 762 10th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773796 | 5992905.3087 | 2110276.51424 | 37.774008838889 | -122.468005315635 | (37.774008838889, -122.468005315635) | 11 | 6 | 2 | 54 | 11 | |
173417 | 108563 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 60 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772473 | 6010406.15109 | 2094405.89757 | 37.7314267509243 | -122.406348153233 | (37.7314267509243, -122.406348153233) | 10 | 3 | 7 | 309 | 28 |
101405 | 108567 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773758 | 6009500.29517 | 2092233.56808 | 37.7254112788053 | -122.409326636833 | (37.7254112788053, -122.409326636833) | 9 | 3 | 7 | 309 | 28 |
174147 | 108570 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 40 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772580 | 6010210.43031 | 2095090.88113 | 37.733296619935 | -122.407073064382 | (37.733296619935, -122.407073064382) | 10 | 3 | 7 | 309 | 28 |
32057 | 108634 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 | |||
174379 | 108635 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
193634 | 108648 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 196 Lippard Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | 9 | 7 | 5 | 63 | 40 | |
184501 | 108692 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
31223 | 108693 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
118774 | 108694 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
147654 | 108702 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.97197 | 2118381.98302 | 37.7967629901963 | -122.438489159966 | (37.7967629901963, -122.438489159966) | 13 | 9 | 1 | 57 | 17 |
15749 | 108724 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 566 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773100 | 6011759.6093 | 2105732.18704 | 37.7626019164795 | -122.402465094694 | (37.7626019164795, -122.402465094694) | 8 | 3 | 8 | 28856 | 29 |
133242 | 1088 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2222 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 8 | 3X3 | 5999676.12109 | 2089518.75442 | 37.7174017035022 | -122.443092918703 | (37.7174017035022, -122.443092918703) | 9 | 7 | 6 | 28861 | 25 | ||
165984 | 108830 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Port 6 | FUF | 3x3 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | ||||
9573 | 108831 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | |||
90151 | 108899 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.7102333694046 | -122.43989417722 | (37.7102333694046, -122.43989417722) | 9 | 7 | 6 | 28861 | 5 |
15090 | 108919 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 624 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773067 | 6007633.7 | 2096431.2 | 37.7368323085558 | -122.416076443366 | (37.7368323085558, -122.416076443366) | 2 | 7 | 7 | 28859 | 2 |
141446 | 109046 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2033 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773275 | 5990629.8 | 2101538.2 | 37.7498840951568 | -122.475238529801 | (37.7498840951568, -122.475238529801) | 1 | 8 | 4 | 29491 | 12 |
180233 | 109051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 32 De Long St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772570 | 5995048.30925 | 2086814.92441 | 37.7097126663738 | -122.45889335865 | (37.7097126663738, -122.45889335865) | 9 | 8 | 6 | 28861 | 25 |
186213 | 109055 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 320 Hanover St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.7092287229218 | -122.443247602414 | (37.7092287229218, -122.443247602414) | 9 | 7 | 6 | 28861 | 5 | |
19987 | 109057 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 825 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772770 | 5997289.53523 | 2087142.99435 | 37.7107420465867 | -122.451170962984 | (37.7107420465867, -122.451170962984) | 9 | 7 | 6 | 28861 | 25 |
162470 | 109069 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.57012 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) | 9 | 7 | 6 | 28861 | 5 |
194103 | 109076 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.436420213894 | (37.7106245477128, -122.436420213894) | 9 | 7 | 6 | 28861 | 5 | ||
106981 | 109092 | Property Tree 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 237 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) | 2 | 7 | 5 | 63 | 22 |
131445 | 109099 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 605 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772813 | 5995572 | 2112087.6 | 37.7791352386671 | -122.458911991714 | (37.7791352386671, -122.458911991714) | 11 | 6 | 2 | 54 | 11 |
91638 | 109207 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2322 ANZA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774968 | 5991452 | 2112065.7 | 37.7788374208584 | -122.473163018087 | (37.7788374208584, -122.473163018087) | 11 | 6 | 2 | 54 | 26 | |
142536 | 109290 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2X Clover St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774871 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | 2 | 4 | 5 | 28862 | 3 |
45488 | 109311 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 85 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773228 | 6005854.7 | 2099005.5 | 37.7438005719751 | -122.422410095961 | (37.7438005719751, -122.422410095961) | 2 | 7 | 7 | 28859 | 2 |
35170 | 109379 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 515 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774800 | 6008907.5 | 2095937.9 | 37.7355493512503 | -122.411637495982 | (37.7355493512503, -122.411637495982) | 10 | 7 | 7 | 28859 | 2 |
102699 | 109418 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 113 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771960 | 6000642.7 | 2102407.9 | 37.7528473542915 | -122.440675914226 | (37.7528473542915, -122.440675914226) | 2 | 4 | 5 | 28862 | 22 |
162381 | 109718 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013027.72582 | 2089252.65271 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | 10 | 3 | 8 | 58 | 1 | |||
24175 | 109719 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013017.96817 | 2089237.91008 | 37.7173822637496 | -122.39695633886 | (37.7173822637496, -122.39695633886) | 10 | 3 | 8 | 58 | 1 | |||
114826 | 109720 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013003.04663 | 2089225.87008 | 37.7173483736975 | -122.39700707234 | (37.7173483736975, -122.39700707234) | 10 | 3 | 8 | 58 | 1 | |||
185463 | 109721 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6012983.30026 | 2089217.17599 | 37.717323402237 | -122.397074717543 | (37.717323402237, -122.397074717543) | 10 | 3 | 8 | 58 | 1 | |||
50077 | 109722 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012966.2543 | 2089212.97453 | 37.7173109169351 | -122.397133343428 | (37.7173109169351, -122.397133343428) | 10 | 3 | 8 | 58 | 1 | |||
39555 | 109792 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2083 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775060 | 5991259.8 | 2101279.3 | 37.7492097184614 | -122.47304110372 | (37.7492097184614, -122.47304110372) | 1 | 8 | 4 | 29491 | 12 |
35827 | 109793 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2083 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775060 | 5991259.8 | 2101279.3 | 37.7492097184614 | -122.47304110372 | (37.7492097184614, -122.47304110372) | 1 | 8 | 4 | 29491 | 12 |
81333 | 109901 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2271 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775113 | 5987275.3 | 2099830 | 37.7449988337527 | -122.486712981387 | (37.7449988337527, -122.486712981387) | 1 | 8 | 3 | 29491 | 35 |
171569 | 10995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016004.21156 | 2097242.69659 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | 10 | 3 | 8 | 58 | 1 | |||
82408 | 109971 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1435 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2015 12:00:00 AM | 3 | 3x3 | 5999653.8 | 2113835.4 | 37.7841680297741 | -122.444917101722 | (37.7841680297741, -122.444917101722) | 15 | 6 | 11 | 29490 | 31 | ||
72223 | 110504 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
115647 | 110505 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
177924 | 110506 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
138037 | 110507 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
126037 | 110508 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
122179 | 110509 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
104145 | 110510 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
57981 | 110511 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
174989 | 110512 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
41064 | 110513 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
193622 | 110514 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
31331 | 110515 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
137434 | 110516 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600x 15TH ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6006820 | 2107391 | 37.7668796319268 | -122.419667156869 | (37.7668796319268, -122.419667156869) | 8 | 4 | 7 | 28853 | 19 | |||
133111 | 11071 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6007332 | 2118349 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | 5 | 1 | 10 | 28858 | 32 | |||
12076 | 110751 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 510 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2015 12:00:00 AM | 3 | Permit Number 775489 | 5981042.2 | 2112214 | 37.778636382962 | -122.509184994454 | (37.778636382962, -122.509184994454) | 11 | 6 | 2 | 55 | 26 | ||
180377 | 111196 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | Permit Number 775548 | 6003599.35024 | 2116566.69152 | 37.7918918516902 | -122.431461960596 | (37.7918918516902, -122.431461960596) | 13 | 9 | 1 | 29490 | 27 | ||
129220 | 111197 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6003620.63323 | 2116569.07161 | 37.7918995930282 | -122.431388491405 | (37.7918995930282, -122.431388491405) | 13 | 9 | 1 | 29490 | 27 | ||||
111448 | 111204 | Section 143 10 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 168 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 3x3 | 6004024 | 2101044 | 37.7492943788142 | -122.428885525131 | (37.7492943788142, -122.428885525131) | 2 | 4 | 5 | 28862 | 22 | ||
177743 | 111661 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1398x Kansas St | 1 | Median : Cutout | Tree | DPW 1 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.79241 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | 10 | 3 | 8 | 28856 | 29 | ||
76594 | 112568 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | 3x3 | 6005755.8 | 2107791.7 | 37.7679198543098 | -122.423376545374 | (37.7679198543098, -122.423376545374) | 8 | 4 | 5 | 28853 | 19 | |||
95372 | 112887 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 738 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 774322 | 5993235.7 | 2110443.8 | 37.7744872348519 | -122.466874609154 | (37.7744872348519, -122.466874609154) | 11 | 6 | 2 | 54 | 11 | |||
63540 | 113152 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 21 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009396 | 2097313 | 37.7393524690061 | -122.410045605495 | (37.7393524690061, -122.410045605495) | 10 | 7 | 7 | 28859 | 2 | |||
34986 | 113307 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 COLONIAL WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6000472 | 2093592 | 37.7286312543271 | -122.440633939625 | (37.7286312543271, -122.440633939625) | 9 | 7 | 6 | 28861 | 25 |
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) );