trees
53 rows where Supervisor Districts = 4 and qSpecies_id = 116 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39945 | 215415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 484 Faxon Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994798.18805 | 2091784.91271 | 37.7233446951982 | -122.460117638125 | (37.7233446951982, -122.460117638125) | 9 | 8 | 4 | 28861 | 24 | |||
10106 | 49071 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
66523 | 49072 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
77367 | 49070 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
89349 | 49073 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
110955 | 49074 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
143055 | 49075 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
153581 | 49076 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
132359 | 215424 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993760.13704 | 2092800.2871 | 37.7260729055276 | -122.463779620842 | (37.7260729055276, -122.463779620842) | 9 | 8 | 4 | 59 | 40 | |||
128873 | 215423 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993769.4086 | 2092813.96021 | 37.7261109828263 | -122.46374856184 | (37.7261109828263, -122.46374856184) | 9 | 8 | 4 | 59 | 40 | |||
2455 | 215422 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | 9 | 8 | 4 | 59 | 40 | |||
153487 | 215427 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993797.5326 | 2092869.73491 | 37.7262657471456 | -122.463655385788 | (37.7262657471456, -122.463655385788) | 9 | 8 | 4 | 59 | 40 | |||
181035 | 215434 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993586.39661 | 2092891.16546 | 37.7263124219742 | -122.464386821508 | (37.7263124219742, -122.464386821508) | 9 | 8 | 4 | 59 | 40 | |||
50185 | 215433 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993594.89235 | 2092910.67012 | 37.726366466724 | -122.464358867875 | (37.726366466724, -122.464358867875) | 9 | 8 | 4 | 59 | 40 | |||
65860 | 215426 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993822.27885 | 2092914.39696 | 37.7263898041365 | -122.463573079846 | (37.7263898041365, -122.463573079846) | 9 | 8 | 4 | 59 | 40 | |||
32219 | 215432 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993607.07382 | 2092934.57084 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | 9 | 8 | 4 | 59 | 40 | |||
45824 | 215425 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 15 Fairfield Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993828.92178 | 2092931.25645 | 37.7264364789445 | -122.463551338741 | (37.7264364789445, -122.463551338741) | 9 | 8 | 4 | 59 | 40 | |||
58620 | 215431 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993618.37614 | 2092959.38451 | 37.7265015781724 | -122.464281221309 | (37.7265015781724, -122.464281221309) | 9 | 8 | 4 | 59 | 40 | |||
177793 | 215430 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993628.72422 | 2092981.53442 | 37.7265629928729 | -122.464247056069 | (37.7265629928729, -122.464247056069) | 9 | 8 | 4 | 59 | 40 | |||
60373 | 215429 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993645.02193 | 2093008.92736 | 37.726639146565 | -122.464192703738 | (37.726639146565, -122.464192703738) | 9 | 8 | 4 | 59 | 40 | |||
85554 | 215428 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | 9 | 8 | 4 | 59 | 40 | |||
2544 | 49162 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
50033 | 49161 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 804 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.459789497745 | (37.7277062535492, -122.459789497745) | 9 | 7 | 4 | 28861 | 40 | ||
20538 | 42308 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | ||
89456 | 42310 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
116195 | 42309 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
167583 | 215437 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5998668.44451 | 2093778.09263 | 37.729039350777 | -122.446882296697 | (37.729039350777, -122.446882296697) | 9 | 7 | 4 | 28861 | 40 | |||
117606 | 215439 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5998709.41817 | 2093777.72882 | 37.729040692553 | -122.44674062198 | (37.729040692553, -122.44674062198) | 9 | 7 | 4 | 28861 | 40 | |||
85930 | 215438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.446785584491 | (37.7290433761531, -122.446785584491) | 9 | 7 | 4 | 28861 | 40 | |||
152907 | 50801 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | 9 | 7 | 4 | 28861 | 40 | ||
150544 | 215413 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5997941.5079 | 2094069.28168 | 37.7297973308762 | -122.44941633349 | (37.7297973308762, -122.44941633349) | 9 | 7 | 4 | 28861 | 40 | |||
59259 | 215414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5997954.5929 | 2094069.33464 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | 9 | 7 | 4 | 28861 | 40 | |||
46226 | 16202 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
171394 | 16201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
54851 | 16285 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
57490 | 16286 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
96877 | 16284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
145108 | 28414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 600X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | 9 | 7 | 4 | 59 | 40 | ||
115633 | 16314 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
158182 | 16313 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
176905 | 16312 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
62921 | 16273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
151718 | 28415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
48943 | 16228 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
81686 | 16227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
100468 | 16027 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 160 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6001078.56062 | 2094701.12537 | 37.7317111799206 | -122.438616467699 | (37.7317111799206, -122.438616467699) | 9 | 7 | 4 | 63 | 40 | ||
181839 | 215435 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 271 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999640.40097 | 2095213.212 | 37.7330353327146 | -122.443625232838 | (37.7330353327146, -122.443625232838) | 9 | 7 | 4 | 63 | 40 | |||
51586 | 215436 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | 9 | 7 | 4 | 59 | 40 | |||
28741 | 215420 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2085 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993528.81827 | 2101394.66819 | 37.7496575974161 | -122.465203244928 | (37.7496575974161, -122.465203244928) | 1 | 8 | 4 | 29491 | 40 | |||
4646 | 215421 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2085 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993516.19097 | 2101401.96684 | 37.7496769094628 | -122.465247440321 | (37.7496769094628, -122.465247440321) | 1 | 8 | 4 | 29491 | 40 | |||
24867 | 215411 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1939 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5991245.12391 | 2102202.13663 | 37.7517427376545 | -122.473159145982 | (37.7517427376545, -122.473159145982) | 1 | 8 | 4 | 29491 | 12 | |||
156738 | 215412 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | 1 | 8 | 4 | 56 | 12 | |||
94691 | 69068 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33076 | 5991768.06854816 | 2105844.04694914 | 37.7617727319168 | -122.471616117782 | (37.7617727319168, -122.471616117782) | 1 | 8 | 4 | 56 | 12 |
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) );