trees
155 rows where qSpecies_id = 12 sorted by qAddress
This data as json, CSV (advanced)
These facets timed out: Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180437 | 241173 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 344 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003615.63748 | 2108670.28544 | 37.7702112142959 | -122.430841829505 | (37.7702112142959, -122.430841829505) | 15 | 9 | 11 | 29492 | 10 | |||
11832 | 197944 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015356.38098 | 2115113.47831 | 37.7885609912507 | -122.390680660994 | (37.7885609912507, -122.390680660994) | 6 | 2 | 9 | 28855 | 6 | |||
56111 | 197942 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015382.55256 | 2115087.30392 | 37.7884905743282 | -122.390588280823 | (37.7884905743282, -122.390588280823) | 6 | 2 | 9 | 28855 | 6 | |||
87448 | 197940 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015409.43942 | 2115059.04086 | 37.7884144620023 | -122.39049328005 | (37.7884144620023, -122.39049328005) | 6 | 2 | 9 | 28855 | 6 | |||
100647 | 197939 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015423.89897 | 2115043.66303 | 37.7883730401228 | -122.390442176979 | (37.7883730401228, -122.390442176979) | 6 | 2 | 9 | 28855 | 6 | |||
113100 | 197945 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015345.08989 | 2115126.34059 | 37.7885956816912 | -122.390720625978 | (37.7885956816912, -122.390720625978) | 6 | 2 | 9 | 28855 | 6 | |||
125340 | 197946 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015324.49804 | 2115147.49947 | 37.78865263665 | -122.390793350551 | (37.78865263665, -122.390793350551) | 6 | 2 | 9 | 28855 | 6 | |||
141989 | 197943 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015369.55372 | 2115100.01237 | 37.7885247476754 | -122.390634143574 | (37.7885247476754, -122.390634143574) | 6 | 2 | 9 | 28855 | 6 | |||
158604 | 197941 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 351 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6015395.33914 | 2115073.46848 | 37.7884532947311 | -122.390543073727 | (37.7884532947311, -122.390543073727) | 6 | 2 | 9 | 28855 | 6 | |||
43435 | 197956 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014936.72139 | 2115049.06267 | 37.7883608291328 | -122.392128124328 | (37.7883608291328, -122.392128124328) | 6 | 2 | 9 | 28855 | 6 | |||
52544 | 197961 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014857.78399 | 2115129.52624 | 37.7885773804879 | -122.392406867389 | (37.7885773804879, -122.392406867389) | 6 | 2 | 9 | 28855 | 6 | |||
63000 | 197955 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014952.39535 | 2115030.72864 | 37.7883113583401 | -122.392072611873 | (37.7883113583401, -122.392072611873) | 6 | 2 | 9 | 28855 | 6 | |||
77617 | 197959 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014895.93588 | 2115091.70056 | 37.7884756383871 | -122.392272219997 | (37.7884756383871, -122.392272219997) | 6 | 2 | 9 | 28855 | 6 | |||
88352 | 197962 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014844.47808 | 2115146.79251 | 37.7886240508001 | -122.392454112385 | (37.7886240508001, -122.392454112385) | 6 | 2 | 9 | 28855 | 6 | |||
121522 | 197957 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014920.6101 | 2115062.64622 | 37.7883972318904 | -122.392184817599 | (37.7883972318904, -122.392184817599) | 6 | 2 | 9 | 28855 | 6 | |||
137275 | 197960 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014878.139 | 2115106.33815 | 37.7885148416282 | -122.392334819105 | (37.7885148416282, -122.392334819105) | 6 | 2 | 9 | 28855 | 6 | |||
153468 | 197958 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6014908.62801 | 2115077.84616 | 37.7884383021313 | -122.392227337523 | (37.7884383021313, -122.392227337523) | 6 | 2 | 9 | 28855 | 6 | |||
165547 | 197954 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 355 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014967.3458 | 2115010.36938 | 37.7882562865359 | -122.392019461055 | (37.7882562865359, -122.392019461055) | 6 | 2 | 9 | 28855 | 6 | |||
132182 | 31880 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 357 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35318 | 5986819.04944 | 2113546.00987 | 37.7826325931106 | -122.489298876891 | (37.7826325931106, -122.489298876891) | 11 | 6 | 2 | 55 | 26 | ||
78617 | 120014 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 359 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5986817.89176 | 2113535.36693 | 37.7826033030644 | -122.489302099137 | (37.7826033030644, -122.489302099137) | 11 | 6 | 2 | 55 | 26 | |||
54192 | 114572 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 3633 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 777013 | 5997417 | 2115685 | 37.7891186297883 | -122.452789133032 | (37.7891186297883, -122.452789133032) | 11 | 6 | 1 | 54 | 31 | ||
24409 | 246997 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004899.11495 | 2101036.5235 | 37.7493233437145 | -122.425858826318 | (37.7493233437145, -122.425858826318) | 2 | 4 | 5 | 28862 | 22 | |||
112670 | 52291 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 37 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48450 | 6004924.5040582 | 2101031.6740118 | 37.7493114629054 | -122.425770685059 | (37.7493114629054, -122.425770685059) | 2 | 4 | 5 | 28862 | 22 | ||
80481 | 197953 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015054.91567 | 2114917.83312 | 37.7880070646074 | -122.391710008824 | (37.7880070646074, -122.391710008824) | 6 | 2 | 9 | 28855 | 6 | |||
123910 | 197949 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015139.49005 | 2114827.68285 | 37.7877642269846 | -122.391411089446 | (37.7877642269846, -122.391411089446) | 6 | 2 | 9 | 28855 | 6 | |||
126102 | 197948 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015157.51241 | 2114808.67556 | 37.7877130375663 | -122.391347405751 | (37.7877130375663, -122.391347405751) | 6 | 2 | 9 | 28855 | 6 | |||
126569 | 197952 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015071.96178 | 2114899.8114 | 37.7879585273121 | -122.391649771325 | (37.7879585273121, -122.391649771325) | 6 | 2 | 9 | 28855 | 6 | |||
132212 | 197951 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015100.083 | 2114872.3871 | 37.7878847873904 | -122.391550558114 | (37.7878847873904, -122.391550558114) | 6 | 2 | 9 | 28855 | 6 | |||
154596 | 197947 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015181.90784 | 2114782.68657 | 37.7876430316507 | -122.39126118415 | (37.7876430316507, -122.39126118415) | 6 | 2 | 9 | 28855 | 6 | |||
187036 | 197950 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 375 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.06913 | 2114845.42683 | 37.78781198099 | -122.39147260399 | (37.78781198099, -122.39147260399) | 6 | 2 | 9 | 28855 | 6 | |||
62007 | 51401 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 423 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774507 | 6011161.37558 | 2112281.69407 | 37.7805519474533 | -122.404995352556 | (37.7805519474533, -122.404995352556) | 14 | 2 | 9 | 28853 | 34 | |
23049 | 96152 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767787 | 6008219 | 2096805 | 37.7378915730232 | -122.414079234094 | (37.7378915730232, -122.414079234094) | 2 | 7 | 7 | 28859 | 2 | |
142926 | 241167 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 436 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008217.59189 | 2096787.94812 | 37.7378446732024 | -122.41408289663 | (37.7378446732024, -122.41408289663) | 2 | 7 | 7 | 28859 | 2 | |||
54236 | 136738 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011887.11576 | 2118514.31229 | 37.7977057852396 | -122.402923146385 | (37.7977057852396, -122.402923146385) | 3 | 1 | 10 | 308 | 23 | |||
62557 | 136739 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 48 Osgood Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011886.33726 | 2118519.22734 | 37.7977192373121 | -122.402926186096 | (37.7977192373121, -122.402926186096) | 3 | 1 | 10 | 308 | 23 | |||
2213 | 261044 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
9433 | 261043 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||||
16799 | 261042 | Significant Tree 6 | Tilia cordata :: Littleleaf Linden 12 | 499x Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2019 12:00:00 AM | 3 | 3x3 | 6014038 | 2115260 | 37.7888900740934 | -122.39525236007 | (37.7888900740934, -122.39525236007) | 6 | 2 | 9 | 28855 | 6 | ||
45003 | 197963 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 530 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013370.97049 | 2111262.30601 | 37.7778762089677 | -122.397279756668 | (37.7778762089677, -122.397279756668) | 6 | 2 | 9 | 28856 | 34 | |||
83512 | 197964 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 542 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013328.41225 | 2111219.96647 | 37.777757584773 | -122.397424011506 | (37.777757584773, -122.397424011506) | 6 | 2 | 9 | 28856 | 34 | |||
130425 | 197965 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 542 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013312.52382 | 2111204.97894 | 37.7777155477834 | -122.397477924066 | (37.7777155477834, -122.397477924066) | 6 | 2 | 9 | 28856 | 34 | |||
33696 | 49458 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013268.6937 | 2111162.24572 | 37.7775957715643 | -122.397626550549 | (37.7775957715643, -122.397626550549) | 6 | 2 | 9 | 28856 | 34 | |
37313 | 49455 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 548 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013246.33649 | 2111139.83952 | 37.7775330042846 | -122.39770232023 | (37.7775330042846, -122.39770232023) | 6 | 2 | 9 | 28856 | 34 | |
177018 | 123142 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 588 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5992875.98523 | 2111469.09089 | 37.7772816395031 | -122.468193521633 | (37.7772816395031, -122.468193521633) | 11 | 6 | 2 | 54 | 11 | |||
184080 | 84157 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 607 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52665 | 6007912.35762405 | 2104388.06639727 | 37.7586957437969 | -122.415676213523 | (37.7586957437969, -122.415676213523) | 2 | 4 | 7 | 28859 | 19 | ||
21846 | 83987 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 619 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52667 | 6007916.08016795 | 2104321.00982212 | 37.7585118310793 | -122.415658591374 | (37.7585118310793, -122.415658591374) | 2 | 4 | 7 | 28859 | 19 | ||
45536 | 50054 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 646 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51273 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341 | (37.7605408596837, -122.42837316341) | 2 | 4 | 5 | 28862 | 3 | ||
1320 | 124050 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992519.13358 | 2110941.9567 | 37.7758136556158 | -122.469389596118 | (37.7758136556158, -122.469389596118) | 11 | 6 | 2 | 54 | 11 | |||
143196 | 108470 | Permitted Site 7 | Tilia cordata :: Littleleaf Linden 12 | 663 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773783 | 5992531.7071 | 2110944.78333 | 37.7758221433837 | -122.469346307299 | (37.7758221433837, -122.469346307299) | 11 | 6 | 2 | 54 | 11 | |||
69957 | 112882 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | 5994670.4 | 2110971.2 | 37.7760180351325 | -122.46194999449 | (37.7760180351325, -122.46194999449) | 11 | 6 | 2 | 54 | 11 | ||||
102491 | 123341 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 671 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994696.02985 | 2110963.62248 | 37.7759987047787 | -122.461860785147 | (37.7759987047787, -122.461860785147) | 11 | 6 | 2 | 54 | 11 | |||
28759 | 197973 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011498.91524 | 2113552.62708 | 37.7840604950255 | -122.403917097798 | (37.7840604950255, -122.403917097798) | 12 | 2 | 9 | 28853 | 34 | |||
28889 | 197972 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011477.0733 | 2113572.89989 | 37.7841149391088 | -122.403994090559 | (37.7841149391088, -122.403994090559) | 12 | 2 | 9 | 28853 | 34 | |||
40312 | 197971 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011459.89889 | 2113592.30017 | 37.7841672481653 | -122.404054873931 | (37.7841672481653, -122.404054873931) | 12 | 2 | 9 | 28853 | 34 | |||
168053 | 197970 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011429.88 | 2113631.09913 | 37.7842721037271 | -122.404161460703 | (37.7842721037271, -122.404161460703) | 12 | 2 | 9 | 28853 | 34 |
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) );