trees
154 rows where Fire Prevention Districts = 7 and qSpecies_id = 54
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128250 | 111732 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005836.5524 | 2111203.7796 | 37.7772931610788 | -122.423339818124 | (37.7772931610788, -122.423339818124) | 7 | 9 | 11 | 28852 | 10 | |||
128466 | 6224 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1220 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6005090.9413 | 2113387.3731 | 37.7832466624445 | -122.426074615309 | (37.7832466624445, -122.426074615309) | 7 | 9 | 11 | 28858 | 41 | |||
129493 | 139435 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 408 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005375.9537 | 2111162.1376 | 37.7771528162036 | -122.424930215803 | (37.7771528162036, -122.424930215803) | 7 | 9 | 11 | 28852 | 10 | |||
131718 | 6245 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6004753.0279 | 2113338.633 | 37.7830937301366 | -122.427240188063 | (37.7830937301366, -122.427240188063) | 7 | 9 | 11 | 28858 | 41 | ||
132720 | 244480 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 436 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6004459.1128 | 2109828.0982 | 37.7734380404188 | -122.428006772012 | (37.7734380404188, -122.428006772012) | 7 | 9 | 11 | 28852 | 10 | |||
133022 | 245850 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 381 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005186.7592 | 2110228.7704 | 37.7745793288374 | -122.42551825752 | (37.7745793288374, -122.42551825752) | 7 | 9 | 11 | 28852 | 10 | |||
136758 | 6242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.7831383969133 | -122.426886998286 | (37.7831383969133, -122.426886998286) | 7 | 9 | 11 | 28858 | 41 | ||
137918 | 141793 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003797.3488 | 2112989.7381 | 37.7820816595285 | -122.430521544957 | (37.7820816595285, -122.430521544957) | 7 | 9 | 11 | 29490 | 41 | |||
138681 | 16953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 643 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003890.8551 | 2110044.9948 | 37.7740014196611 | -122.429987931494 | (37.7740014196611, -122.429987931494) | 7 | 9 | 11 | 29492 | 10 | |||
138710 | 245220 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.7741913919096 | -122.425893994936 | (37.7741913919096, -122.425893994936) | 7 | 9 | 11 | 28852 | 10 | |||
140176 | 140213 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 658 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003592.9683 | 2110633.2956 | 37.7755998738913 | -122.431060369379 | (37.7755998738913, -122.431060369379) | 7 | 9 | 11 | 29492 | 10 | |||
140575 | 7160 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 722 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6003546.1461 | 2110964.158 | 37.7765056869903 | -122.431245960959 | (37.7765056869903, -122.431245960959) | 7 | 9 | 11 | 29492 | 10 | |||
144570 | 58783 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | 7 | 9 | 11 | 28852 | 10 | |
148172 | 141792 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003805.1483 | 2112935.1558 | 37.7819322319873 | -122.430490666465 | (37.7819322319873, -122.430490666465) | 7 | 9 | 11 | 29490 | 41 | |||
149100 | 60603 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631 | -122.431018929857 | (37.775379238631, -122.431018929857) | 7 | 9 | 11 | 29492 | 10 | |
149390 | 141767 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003884.399 | 2113511.8848 | 37.7835202748029 | -122.430257654213 | (37.7835202748029, -122.430257654213) | 7 | 9 | 11 | 29490 | 41 | |||
152841 | 140214 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 668 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003589.5295 | 2110658.3502 | 37.7756684727789 | -122.43107405366 | (37.7756684727789, -122.43107405366) | 7 | 9 | 11 | 29492 | 10 | |||
155347 | 10637 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003821.4079 | 2110734.0055 | 37.7758893402664 | -122.430277327931 | (37.7758893402664, -122.430277327931) | 7 | 9 | 11 | 29492 | 10 | ||
156143 | 108009 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6005268.3816 | 2111120.1092 | 37.7770313396992 | -122.425299350558 | (37.7770313396992, -122.425299350558) | 7 | 9 | 11 | 28852 | 10 | ||||
156612 | 140631 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 810 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003522.9612 | 2111140.977 | 37.7769898742733 | -122.431338789049 | (37.7769898742733, -122.431338789049) | 7 | 9 | 11 | 29492 | 10 | |||
157202 | 140051 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 FULTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005299.4561 | 2111632.5014 | 37.7784399990073 | -122.42522832358 | (37.7784399990073, -122.42522832358) | 7 | 9 | 11 | 28852 | 10 | |||
157841 | 12247 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 503 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004991.7276 | 2110673.0436 | 37.7757881731565 | -122.426224546997 | (37.7757881731565, -122.426224546997) | 7 | 9 | 11 | 28852 | 10 | |||
158884 | 111730 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 313 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x3 | 6005810.6231 | 2111200.9612 | 37.7772839590018 | -122.423429315645 | (37.7772839590018, -122.423429315645) | 7 | 9 | 11 | 28852 | 10 | |||
159706 | 244974 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | 7 | 9 | 11 | 28852 | 10 | |||
163587 | 141799 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1280 WEBSTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003782.7951 | 2113127.1113 | 37.782458027558 | -122.430581699509 | (37.782458027558, -122.430581699509) | 7 | 9 | 11 | 29490 | 41 | |||
165292 | 66381 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 648 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | 13 | Permit Number 29507 | 6003596.4072 | 2110594.4854 | 37.775493505524 | -122.431045702786 | (37.775493505524, -122.431045702786) | 7 | 9 | 11 | 29492 | 10 | |
166303 | 33642 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005737 | (37.776111096903, -122.42556005737) | 7 | 9 | 11 | 28852 | 10 | |
166492 | 247345 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 604 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004033.5399 | 2110118.9664 | 37.7742126072073 | -122.429499636998 | (37.7742126072073, -122.429499636998) | 7 | 9 | 11 | 29492 | 10 | |||
167006 | 112132 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6003600.3374 | 2110567.9569 | 37.7754208875098 | -122.431030213476 | (37.7754208875098, -122.431030213476) | 7 | 9 | 11 | 29492 | 10 | |||
169233 | 68430 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 501 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32281 | 6005253.5217 | 2111626.0919 | 37.7784198049854 | -122.425386771844 | (37.7784198049854, -122.425386771844) | 7 | 9 | 11 | 28852 | 10 | ||
170449 | 10636 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003811.0913 | 2110732.5317 | 37.7758847092198 | -122.430312910525 | (37.7758847092198, -122.430312910525) | 7 | 9 | 11 | 29492 | 10 | ||
173051 | 140068 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 582 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005004.7286 | 2111303.2254 | 37.7775192332012 | -122.426224448803 | (37.7775192332012, -122.426224448803) | 7 | 9 | 11 | 28852 | 10 | |||
174691 | 108010 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 419X Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6005279.8436 | 2111122.0196 | 37.7770372327377 | -122.42525983588 | (37.7770372327377, -122.42525983588) | 7 | 9 | 11 | 28852 | 10 | ||||
175132 | 244244 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 150 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005791.8047 | 2110016.6014 | 37.7740309317752 | -122.423410197258 | (37.7740309317752, -122.423410197258) | 7 | 9 | 11 | 28852 | 10 | |||
176648 | 140610 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 860 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6003498.0852 | 2111306.0629 | 37.7774417494141 | -122.431436630621 | (37.7774417494141, -122.431436630621) | 7 | 9 | 11 | 29492 | 10 | |||
177613 | 244504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 697 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003691.552 | 2110018.3364 | 37.773916933054 | -122.430675451783 | (37.773916933054, -122.430675451783) | 7 | 9 | 11 | 29492 | 10 | |||
177953 | 16896 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 377 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005209.3255 | 2110233.2837 | 37.7745929962798 | -122.425440517449 | (37.7745929962798, -122.425440517449) | 7 | 9 | 11 | 28852 | 10 | |||
181093 | 139436 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 410 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005361.8436 | 2111159.167 | 37.7771438626442 | -122.424978815742 | (37.7771438626442, -122.424978815742) | 7 | 9 | 11 | 28852 | 10 | |||
181551 | 244967 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 290 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005160.4976 | 2110090.7807 | 37.7741989587748 | -122.425599278654 | (37.7741989587748, -122.425599278654) | 7 | 9 | 11 | 28852 | 10 | |||
182947 | 33693 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37765 | 6005397.8063 | 2111143.0332 | 37.7771015944949 | -122.424853261184 | (37.7771015944949, -122.424853261184) | 7 | 9 | 11 | 28852 | 10 | ||
183700 | 141776 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 5 Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003896.2863 | 2113355.7647 | 37.783092281356 | -122.430205387238 | (37.783092281356, -122.430205387238) | 7 | 9 | 11 | 29490 | 41 | |||
185324 | 57510 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 630 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1976 12:00:00 AM | 16 | Permit Number 16363 | 6005412.5487 | 2111488.2587 | 37.7780503321524 | -122.424826828837 | (37.7780503321524, -122.424826828837) | 7 | 9 | 11 | 28852 | 10 | ||
185720 | 139434 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 406 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005390.0639 | 2111164.7368 | 37.7771607499747 | -122.424881589077 | (37.7771607499747, -122.424881589077) | 7 | 9 | 11 | 28852 | 10 | |||
186831 | 16865 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 230 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005838.6934 | 2110371.3705 | 37.7750076883115 | -122.423273225017 | (37.7750076883115, -122.423273225017) | 7 | 9 | 11 | 28852 | 10 | |||
187565 | 33694 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.7770914710207 | -122.424910846803 | (37.7770914710207, -122.424910846803) | 7 | 9 | 11 | 28852 | 10 | ||
188166 | 7161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 726 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003541.3006 | 2110998.0762 | 37.7765985433792 | -122.431265144599 | (37.7765985433792, -122.431265144599) | 7 | 9 | 11 | 29492 | 10 | |||
188275 | 59956 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | 7 | 9 | 11 | 28852 | 10 | ||
189603 | 244508 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 470 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003685.2048 | 2109943.0159 | 37.7737097618778 | -122.430692031876 | (37.7737097618778, -122.430692031876) | 7 | 9 | 11 | 29492 | 10 | |||
189942 | 141780 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1480 ELLIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003842.3971 | 2113219.4567 | 37.7827149612606 | -122.430382093414 | (37.7827149612606, -122.430382093414) | 7 | 9 | 11 | 29490 | 41 | |||
190297 | 141778 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 9 Hollis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003916.891 | 2113262.7794 | 37.7828381339765 | -122.430127467778 | (37.7828381339765, -122.430127467778) | 7 | 9 | 11 | 29490 | 41 | |||
192060 | 244242 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 151 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005776.1437 | 2110149.7201 | 37.7743955596449 | -122.423473837096 | (37.7743955596449, -122.423473837096) | 7 | 9 | 11 | 28852 | 10 | |||
192110 | 140209 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003569 | 2110758 | 37.7759409231905 | -122.431152184499 | (37.7759409231905, -122.431152184499) | 7 | 9 | 11 | 29492 | 10 | |||
192358 | 10629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003911.8012 | 2110745.3047 | 37.7759254847018 | -122.429965440473 | (37.7759254847018, -122.429965440473) | 7 | 9 | 11 | 29492 | 10 | ||
192634 | 244321 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 255 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005987.0957 | 2110521.4851 | 37.7754282408756 | -122.422770539085 | (37.7754282408756, -122.422770539085) | 7 | 9 | 11 | 28852 | 10 |
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) );