trees
54 rows where Supervisor Districts = 8 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
2420 | 260860 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6013106 | 2103855 | 37.7575226440732 | -122.397676712285 | (37.7575226440732, -122.397676712285) | 10 | 3 | 8 | 28856 | 29 | ||
3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
5103 | 55566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.28081 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | 10 | 7 | 8 | 309 | 39 | |
10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
11351 | 78716 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 412 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008662.0794 | 2088043.12802 | 37.7138582091656 | -122.411928294567 | (37.7138582091656, -122.411928294567) | 9 | 7 | 8 | 309 | 39 | |||
18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
19928 | 176429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 246 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009787.6259 | 2087905.19547 | 37.7135425579218 | -122.4080282487 | (37.7135425579218, -122.4080282487) | 9 | 7 | 8 | 309 | 39 | |||
23203 | 6798 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x9 | 6016915.23611 | 2097187.56543 | 37.7394266247399 | -122.384038431137 | (37.7394266247399, -122.384038431137) | 10 | 3 | 8 | 58 | 1 | |||
25718 | 176421 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 526 Lathrop Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6013003.58559 | 2086544.76512 | 37.7099866196603 | -122.396817348641 | (37.7099866196603, -122.396817348641) | 10 | 3 | 8 | 309 | 1 | |||
30016 | 199432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6014474.33722 | 2095838.07196 | 37.7355859449403 | -122.39238369005 | (37.7355859449403, -122.39238369005) | 10 | 3 | 8 | 58 | 1 | |||
31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
33799 | 112160 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1328 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6013587.23518 | 2105720.84823 | 37.7626726418425 | -122.396143156607 | (37.7626726418425, -122.396143156607) | 14 | 3 | 8 | 28856 | 29 | |||
36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
37053 | 176425 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011982.06755 | 2090001.33634 | 37.7194207606357 | -122.400590586484 | (37.7194207606357, -122.400590586484) | 10 | 7 | 8 | 309 | 28 | |||
37377 | 176427 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 383 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6010742.02473 | 2089174.64706 | 37.7170816042145 | -122.404818807562 | (37.7170816042145, -122.404818807562) | 9 | 7 | 8 | 309 | 39 | |||
39200 | 111610 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 9x3 | 6011193.26322 | 2089621.79675 | 37.7183345981422 | -122.403290521257 | (37.7183345981422, -122.403290521257) | 10 | 7 | 8 | 309 | 39 | |||
39941 | 6742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1300X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 01:53:00 PM | 3 | 3x3 | 6016901.50063 | 2097278.26947 | 37.7396749203573 | -122.384092237585 | (37.7396749203573, -122.384092237585) | 10 | 3 | 8 | 58 | 1 | ||
46674 | 111609 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 15x3 | 6011168.56615 | 2089615.14952 | 37.7183149668287 | -122.403375421742 | (37.7183149668287, -122.403375421742) | 10 | 7 | 8 | 309 | 39 | |||
59959 | 176428 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009763.04467 | 2087916.93122 | 37.7135734055712 | -122.408114037746 | (37.7135734055712, -122.408114037746) | 9 | 7 | 8 | 309 | 39 | |||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
61919 | 43305 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | 10 | 3 | 8 | 28856 | 29 | |
69802 | 111611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x3 | 6011211.14629 | 2089627.82993 | 37.7183521627878 | -122.403229130826 | (37.7183521627878, -122.403229130826) | 10 | 7 | 8 | 309 | 39 | |||
71033 | 62088 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | 10 | 3 | 8 | 28856 | 29 | ||
71962 | 199434 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6014431.27107 | 2095902.06527 | 37.7357592658851 | -122.392537062245 | (37.7357592658851, -122.392537062245) | 10 | 3 | 8 | 58 | 1 | |||
74260 | 176431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.412870211214 | (37.7120611046958, -122.412870211214) | 9 | 7 | 8 | 309 | 39 | |||
75846 | 32047 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
78944 | 55568 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.402935191909 | (37.7179885201224, -122.402935191909) | 10 | 7 | 8 | 309 | 39 | |
84831 | 111317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1114 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011270.9057 | 2089563.62226 | 37.7181791988873 | -122.403018052761 | (37.7181791988873, -122.403018052761) | 10 | 7 | 8 | 309 | 39 | |||
90644 | 61306 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1494 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21205 | 6011999.58311152 | 2101400.41872379 | 37.7507212274206 | -122.401330679383 | (37.7507212274206, -122.401330679383) | 10 | 3 | 8 | 28856 | 29 | ||
101216 | 199433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1400 Newhall St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6014453.55095 | 2095806.16281 | 37.7354971746608 | -122.392453325466 | (37.7354971746608, -122.392453325466) | 10 | 3 | 8 | 58 | 1 | |||
102221 | 28251 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011988.71606 | 2089960.7357 | 37.7193096502899 | -122.400564754381 | (37.7193096502899, -122.400564754381) | 10 | 7 | 8 | 309 | 28 | |||
109268 | 200443 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2535 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015875.48388 | 2103755.07735 | 37.7574021083324 | -122.388091663914 | (37.7574021083324, -122.388091663914) | 10 | 3 | 8 | 28856 | 29 | |||
115001 | 67594 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | 10 | 3 | 8 | 28856 | 29 | ||
118175 | 26002 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | 10 | 3 | 8 | 58 | 1 | |||
120742 | 26003 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692502 | (37.7357217425631, -122.39246692502) | 10 | 3 | 8 | 58 | 1 | |||
120892 | 176426 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3338 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011984.529 | 2089984.5422 | 37.7193747846049 | -122.400580899003 | (37.7193747846049, -122.400580899003) | 10 | 7 | 8 | 309 | 28 | |||
121851 | 61725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | 10 | 3 | 8 | 58 | 1 | ||
122926 | 122750 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 9 | 6011285.1392 | 2105241.40164 | 37.7612278306072 | -122.404071583333 | (37.7612278306072, -122.404071583333) | 10 | 3 | 8 | 28856 | 29 | |||
124236 | 30843 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | 10 | 3 | 8 | 28856 | 29 | ||
129505 | 176430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 242 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009808.91529 | 2087898.02053 | 37.7135240489616 | -122.407954158975 | (37.7135240489616, -122.407954158975) | 9 | 7 | 8 | 309 | 39 | |||
129824 | 26001 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014400.39468 | 2095925.25999 | 37.7358212390678 | -122.392645436853 | (37.7358212390678, -122.392645436853) | 10 | 3 | 8 | 58 | 1 | |||
134941 | 61310 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2337 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21209 | 6011897.61971652 | 2101840.97458612 | 37.7519252086186 | -122.4017142423 | (37.7519252086186, -122.4017142423) | 10 | 3 | 8 | 28856 | 29 | ||
139460 | 176420 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 526 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012864.54988 | 2086589.64347 | 37.7101021070033 | -122.397301031027 | (37.7101021070033, -122.397301031027) | 10 | 3 | 8 | 309 | 1 | |||
143067 | 122749 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 6011285.50671 | 2105214.92948 | 37.7611551645106 | -122.404068449214 | (37.7611551645106, -122.404068449214) | 10 | 3 | 8 | 28856 | 29 | |||
150846 | 28252 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011993.05449 | 2089944.36853 | 37.7192649513087 | -122.400548608856 | (37.7192649513087, -122.400548608856) | 10 | 7 | 8 | 309 | 28 | |||
150898 | 54789 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.64652 | 37.7117995683772 | -122.39799240103 | (37.7117995683772, -122.39799240103) | 10 | 3 | 8 | 309 | 1 | ||
164692 | 55317 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1126 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 4 | Permit Number 11246 | 6011285.28669 | 2089520.65076 | 37.7180620109438 | -122.402965322811 | (37.7180620109438, -122.402965322811) | 10 | 7 | 8 | 309 | 39 | ||
165378 | 61309 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485559 | (37.7519317939639, -122.40160485559) | 10 | 3 | 8 | 28856 | 29 | ||
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
173842 | 32046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
187823 | 199429 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1340 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6013567.84766 | 2105719.02996 | 37.7626665705253 | -122.396210084142 | (37.7626665705253, -122.396210084142) | 14 | 3 | 8 | 28856 | 29 | |||
193156 | 176432 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Britton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008419.02136 | 2087402.07841 | 37.7120843800612 | -122.4127231046 | (37.7120843800612, -122.4127231046) | 9 | 7 | 8 | 309 | 39 |
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) );