trees
151 rows where Zip Codes = 28859 and qLegalStatus_id = 2 sorted by Longitude
This data as json, CSV (advanced)
These facets timed out: Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
178976 | 252905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 600 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777588 | 6007451.05071 | 2106154.24093 | 37.7635193076139 | -122.417396792879 | (37.7635193076139, -122.417396792879) | 8 | 4 | 7 | 28859 | 19 | |
58996 | 242613 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.7444035295914 | -122.417403753004 | (37.7444035295914, -122.417403753004) | 2 | 7 | 7 | 28859 | 2 | ||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
81103 | 156905 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
105170 | 252909 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 3201x 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2017 12:00:00 AM | 3 | 3x6 | Permit Number 777588 | 6007417 | 2106083 | 37.7633217807187 | -122.417509514421 | (37.7633217807187, -122.417509514421) | 8 | 4 | 7 | 28859 | 19 | |
11734 | 243526 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3443 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6007325.13159 | 2104386.27009 | 37.7586577840397 | -122.417706987288 | (37.7586577840397, -122.417706987288) | 2 | 4 | 7 | 28859 | 19 | |||
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
15201 | 243525 | Planning Code 138.1 required 2 | Cassia leptophylla :: Gold Medallion Tree 152 | 3445 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x5 | 6007302.00064 | 2104384.8851 | 37.7586526795002 | -122.417786886671 | (37.7586526795002, -122.417786886671) | 2 | 4 | 7 | 28859 | 19 | |||
6487 | 261445 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 339 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007092 | 2095790 | 37.7350412423636 | -122.417903903871 | (37.7350412423636, -122.417903903871) | 2 | 7 | 7 | 28859 | 2 | ||||
524 | 225191 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
3713 | 225189 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
6489 | 225192 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
9271 | 225190 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
12438 | 260430 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
13706 | 225187 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
17210 | 225188 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | ||
7744 | 225194 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 778605 | 6007219.63733 | 2103836.19178 | 37.7571414587344 | -122.418032839538 | (37.7571414587344, -122.418032839538) | 2 | 4 | 7 | 28859 | 19 | ||
1675 | 225195 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007206.11976 | 2103835.77909 | 37.7571395647689 | -122.418079559351 | (37.7571395647689, -122.418079559351) | 2 | 4 | 7 | 28859 | 19 | ||
1462 | 225196 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007182.851 | 2103832.80652 | 37.7571300930895 | -122.418159821127 | (37.7571300930895, -122.418159821127) | 2 | 4 | 7 | 28859 | 19 | ||
11548 | 225197 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007163.79352 | 2103832.50742 | 37.7571281991351 | -122.418225708166 | (37.7571281991351, -122.418225708166) | 2 | 4 | 7 | 28859 | 19 | ||
11511 | 225198 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 3160 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 778605 | 6007149.23047 | 2103831.77129 | 37.7571253581517 | -122.418276020715 | (37.7571253581517, -122.418276020715) | 2 | 4 | 7 | 28859 | 19 | ||
4773 | 165865 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x4 | 6006836.83511 | 2097542.23848 | 37.7398381374333 | -122.418910337746 | (37.7398381374333, -122.418910337746) | 2 | 7 | 7 | 28859 | 2 | |||
68317 | 228832 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 517 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2018 12:00:00 AM | 3 | 4x4 | 6006836.21643 | 2100716.23735 | 37.7485531903885 | -122.419137558645 | (37.7485531903885, -122.419137558645) | 2 | 4 | 7 | 28859 | 19 | ||
17746 | 262424 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 328 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2020 12:00:00 AM | 3 | 3x3 | 6006735.98718 | 2096026.524 | 37.7356706425738 | -122.419151541699 | (37.7356706425738, -122.419151541699) | 2 | 7 | 7 | 28859 | 2 | ||
152218 | 152308 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 3420 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006693.54336 | 2105565.92746 | 37.7618612870018 | -122.419975023524 | (37.7618612870018, -122.419975023524) | 8 | 4 | 7 | 28859 | 19 | |||
180665 | 152326 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006659.4536 | 2105583.0811 | 37.7619064662287 | -122.420094144155 | (37.7619064662287, -122.420094144155) | 8 | 4 | 7 | 28859 | 19 | |||
67108 | 152327 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 49 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 4x4 | 6006657.39777 | 2105617.1383 | 37.7619998635108 | -122.420103671551 | (37.7619998635108, -122.420103671551) | 8 | 4 | 7 | 28859 | 19 | |||
76348 | 258086 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 381 Lexington St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x1 | 6006575 | 2103913 | 37.7573160533564 | -122.420267699006 | (37.7573160533564, -122.420267699006) | 2 | 4 | 7 | 28859 | 19 | ||||
1023 | 228184 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1190 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 776221 | 6006352.00962 | 2102676.26299 | 37.7539076917969 | -122.420951082919 | (37.7539076917969, -122.420951082919) | 2 | 4 | 5 | 28859 | 19 | ||
4508 | 260546 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
7127 | 260547 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
6679 | 152982 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006311.85744 | 2102620.48455 | 37.7537522736602 | -122.421085978553 | (37.7537522736602, -122.421085978553) | 2 | 4 | 5 | 28859 | 19 | |
63824 | 120132 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006324.60427 | 2103454.53368 | 37.7560430985606 | -122.421101114609 | (37.7560430985606, -122.421101114609) | 2 | 4 | 5 | 28859 | 19 | |
147853 | 64697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006319.44787647 | 2103419.18592492 | 37.7559457511246 | -122.421116437378 | (37.7559457511246, -122.421116437378) | 2 | 4 | 5 | 28859 | 19 | |
52242 | 243372 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1050 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006308.99467 | 2103436.4955 | 37.7559926899263 | -122.42115381712 | (37.7559926899263, -122.42115381712) | 2 | 4 | 5 | 28859 | 19 | |
48832 | 243143 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
100425 | 243144 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 98x Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195 | 2098242 | 37.7417233638646 | -122.421179213365 | (37.7417233638646, -122.421179213365) | 2 | 7 | 7 | 28859 | 2 | ||
124974 | 243371 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006273.47273 | 2103450.37091 | 37.7560287860041 | -122.42127764924 | (37.7560287860041, -122.42127764924) | 2 | 4 | 5 | 28859 | 19 | |
168129 | 23050 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1058 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006261.27662 | 2103419.73409 | 37.7559439767922 | -122.421317651992 | (37.7559439767922, -122.421317651992) | 2 | 4 | 5 | 28859 | 19 | |
30240 | 243370 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006249.22799 | 2103449.78821 | 37.7560258191488 | -122.421361454386 | (37.7560258191488, -122.421361454386) | 2 | 4 | 5 | 28859 | 19 | |
19151 | 242322 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006212.50813 | 2102671.12138 | 37.7538857096745 | -122.421433147433 | (37.7538857096745, -122.421433147433) | 2 | 4 | 5 | 28859 | 19 | |
4098 | 242321 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99x San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006210.72103 | 2102654.46682 | 37.7538398793324 | -122.421438144967 | (37.7538398793324, -122.421438144967) | 2 | 4 | 5 | 28859 | 19 | |
21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
7195 | 4140 | Planning Code 138.1 required 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3620 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2020 12:00:00 AM | 3 | 3x6 | Permit Number 780969 | 6006062.29639 | 2100597.35658 | 37.7481831571401 | -122.421805323766 | (37.7481831571401, -122.421805323766) | 2 | 4 | 5 | 28859 | 19 | |
135960 | 103695 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1X Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778691 | 6006027.79546 | 2103458.18152 | 37.7560363783091 | -122.422127839194 | (37.7560363783091, -122.422127839194) | 2 | 4 | 5 | 28859 | 19 | |
30794 | 10153 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:51:00 AM | 3 | 3x3 | Permit Number 780464 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | |
57409 | 256506 | Planning Code 138.1 required 2 | Cercis canadensis :: Eastern Redbud 346 | 978 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/15/2018 12:00:00 AM | 3 | 3x3 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | 2 | 4 | 5 | 28859 | 19 | ||
180615 | 122686 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3474 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6005720 | 2106109 | 37.7632975389877 | -122.423380737252 | (37.7632975389877, -122.423380737252) | 8 | 4 | 5 | 28859 | 19 | |||
6664 | 226514 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1225 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781565 | 6005204.64951 | 2101211.39699 | 37.7498207677153 | -122.424814719741 | (37.7498207677153, -122.424814719741) | 2 | 4 | 5 | 28859 | 19 |
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) );