trees
149 rows where qCareAssistant = "FUF" and qSpecies_id = 93
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
139891 | 50200 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.91124 | 37.7785524043317 | -122.483470659433 | (37.7785524043317, -122.483470659433) | 11 | 6 | 2 | 55 | 26 |
143677 | 41343 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | 15 | 9 | 11 | 29492 | 10 | ||
144248 | 30958 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
144596 | 62792 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | 9 | 7 | 6 | 28861 | 25 | ||
145627 | 40587 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
146432 | 62345 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 21 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1989 12:00:00 AM | Permit Number 27053 | 6005775.86880093 | 2099617.25647877 | 37.7454758690666 | -122.422726141692 | (37.7454758690666, -122.422726141692) | 2 | 7 | 5 | 28859 | 22 | ||
147627 | 40595 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1745 Alameda St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | 8 | 2 | 8 | 28853 | 20 | ||
150529 | 49695 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4227 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2006 12:00:00 AM | Permit Number 46516 | 6002391.92264985 | 2101184.34624044 | 37.7495872238662 | -122.434539307309 | (37.7495872238662, -122.434539307309) | 2 | 4 | 5 | 28862 | 22 | ||
150643 | 30948 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
151617 | 30952 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
151691 | 30955 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
152346 | 49884 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 438@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46657 | 6003687.07481325 | 2099844.22133211 | 37.7459809898986 | -122.429965046522 | (37.7459809898986, -122.429965046522) | 2 | 7 | 5 | 63 | 22 | ||
153237 | 30950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
153538 | 64837 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30263 | 6004446.78862161 | 2099595.17558793 | 37.7453401631208 | -122.427320319833 | (37.7453401631208, -122.427320319833) | 2 | 7 | 5 | 63 | 22 | ||
153863 | 30953 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
153954 | 52473 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.7796281496591 | -122.471610624408 | (37.7796281496591, -122.471610624408) | 11 | 6 | 2 | 54 | 11 | ||
155805 | 66517 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29684 | 6002746.62066356 | 2101256.12020049 | 37.7498044269933 | -122.43331787905 | (37.7498044269933, -122.43331787905) | 2 | 4 | 5 | 28862 | 22 | ||
157646 | 35120 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 679 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 11 | Permit Number 38655 | 6001477.30735 | 2089545.09865 | 37.7175765748797 | -122.436868949145 | (37.7175765748797, -122.436868949145) | 9 | 7 | 6 | 28861 | 5 | |
158647 | 69407 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 795 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 12 | Permit Number 33511 | 6002413.58939 | 2087078.56796 | 37.7108571939861 | -122.43345648782 | (37.7108571939861, -122.43345648782) | 9 | 7 | 6 | 28861 | 5 | |
159824 | 30944 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
162241 | 62350 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 74 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.423930949775 | (37.7455448191665, -122.423930949775) | 2 | 7 | 5 | 28859 | 22 | ||
163383 | 50263 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | 2 | 7 | 7 | 28859 | 2 | ||
165237 | 35113 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
166144 | 35111 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.7190332505533 | -122.43595568835 | (37.7190332505533, -122.43595568835) | 9 | 7 | 6 | 28861 | 5 | ||
167756 | 68408 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.463022856253 | (37.7289893248225, -122.463022856253) | 9 | 8 | 4 | 59 | 40 | ||
167833 | 44448 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.7104761197367 | -122.432657792736 | (37.7104761197367, -122.432657792736) | 9 | 7 | 6 | 28861 | 5 | |
170135 | 43696 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | 11 | 6 | 2 | 54 | 11 | |
171923 | 49833 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.07851 | 2105148.78787 | 37.7611424148166 | -122.393582289386 | (37.7611424148166, -122.393582289386) | 10 | 3 | 8 | 28856 | 29 | |
172022 | 35126 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.7174791459225 | -122.43602056561 | (37.7174791459225, -122.43602056561) | 9 | 7 | 6 | 28861 | 5 | |
172994 | 30951 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
173907 | 48950 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | 2 | 4 | 7 | 28859 | 19 | ||
174395 | 65162 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 957 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | 4x12 | Permit Number 27142 | 6000403.82793053 | 2102538.64719816 | 37.7531927484611 | -122.441511357285 | (37.7531927484611, -122.441511357285) | 2 | 4 | 5 | 28862 | 22 |
175799 | 30947 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
176752 | 64740 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1225 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1988 12:00:00 AM | Permit Number 25701 | 6000702.83668032 | 2109256.16819914 | 37.7716544366578 | -122.440959198032 | (37.7716544366578, -122.440959198032) | 15 | 5 | 11 | 29492 | 9 | ||
177149 | 47230 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.57098 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | 10 | 3 | 7 | 309 | 28 | |
178550 | 30956 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2390 Bush St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.7866938860132 | -122.436585716056 | (37.7866938860132, -122.436585716056) | 13 | 6 | 11 | 29490 | 27 | ||
179056 | 41712 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 395 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.439608818975 | (37.7371207489149, -122.439608818975) | 2 | 7 | 5 | 63 | 7 | ||
179233 | 62796 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1872 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23153 | 6000282.71540486 | 2093136.39817936 | 37.7273694960454 | -122.441255629685 | (37.7273694960454, -122.441255629685) | 9 | 7 | 6 | 28861 | 25 | ||
181204 | 50265 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 35 Park St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.7367610435591 | -122.425024502668 | (37.7367610435591, -122.425024502668) | 2 | 7 | 5 | 28859 | 2 | ||
182662 | 30961 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/2013 12:00:00 AM | 8 | Permit Number 770536 | 6001993.3657 | 2115129.3914 | 37.7878542434133 | -122.436915720974 | (37.7878542434133, -122.436915720974) | 13 | 6 | 1 | 29490 | 27 | |
183911 | 30960 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2401 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507417 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | 13 | 6 | 1 | 29490 | 27 | ||
184922 | 39497 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 430 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40954 | 6003565.0004553 | 2102762.00333018 | 37.7539856215362 | -122.430595327752 | (37.7539856215362, -122.430595327752) | 2 | 4 | 5 | 28862 | 22 | ||
185426 | 30965 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1932 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 12 | Permit Number 34756 | 6001977.8019 | 2115220.4687 | 37.7881034337143 | -122.436976091665 | (37.7881034337143, -122.436976091665) | 13 | 6 | 1 | 29490 | 27 | |
186462 | 30968 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1902 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34759 | 6002518.1694 | 2114816.0277 | 37.7870236405814 | -122.435077578769 | (37.7870236405814, -122.435077578769) | 13 | 9 | 11 | 29490 | 27 | |
186788 | 62232 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 31 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | Permit Number 22358 | 6001252.08087827 | 2093926.39351405 | 37.7295938138913 | -122.437961102136 | (37.7295938138913, -122.437961102136) | 9 | 7 | 6 | 28861 | 25 | ||
188270 | 30966 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1901X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 16 | 3x3 | Permit Number 34757 | 6001967.37934743 | 2115036.16142537 | 37.7875967808045 | -122.436998951614 | (37.7875967808045, -122.436998951614) | 13 | 6 | 1 | 29490 | 27 |
189564 | 43657 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.04136 | 37.7779394229571 | -122.468438730278 | (37.7779394229571, -122.468438730278) | 11 | 6 | 2 | 54 | 11 | |
192693 | 67989 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 315 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1993 12:00:00 AM | Permit Number 31713 | 5995887.5336506 | 2091190.06532653 | 37.7217739820868 | -122.456309007028 | (37.7217739820868, -122.456309007028) | 9 | 8 | 6 | 28861 | 24 | ||
193921 | 62259 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 73 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 9 | Permit Number 22385 | 6001393.61197 | 2093758.63795 | 37.7291412430561 | -122.437459807321 | (37.7291412430561, -122.437459807321) | 9 | 7 | 6 | 28861 | 25 |
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) );