trees
154 rows where Fire Prevention Districts = 3 and qSpecies_id = 54 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146897 | 142493 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 651 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6009645.6019 | 2119599.491 | 37.8005599999984 | -122.410756107582 | (37.8005599999984, -122.410756107582) | 3 | 1 | 10 | 308 | 4 | |||
| 147078 | 142746 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 661 LOMBARD ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 6009447.7459 | 2120475.7434 | 37.8029548762002 | -122.411502714696 | (37.8029548762002, -122.411502714696) | 3 | 1 | 10 | 308 | 23 | |||
| 148028 | 142943 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010269.581 | 2121139.6226 | 37.8048237870919 | -122.408705588917 | (37.8048237870919, -122.408705588917) | 3 | 1 | 10 | 308 | 23 | |||
| 148262 | 143049 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 475 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6010056.7368 | 2120562.2475 | 37.8032265348731 | -122.409401389822 | (37.8032265348731, -122.409401389822) | 3 | 1 | 10 | 308 | 23 | |||
| 151577 | 142960 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 180 Pfeiffer St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009952.201 | 2121096.811 | 37.8046884559914 | -122.409800896711 | (37.8046884559914, -122.409800896711) | 3 | 1 | 10 | 308 | 23 | |||
| 153254 | 115984 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.7963991373929 | -122.405076175742 | (37.7963991373929, -122.405076175742) | 3 | 1 | 10 | 308 | 4 | |||
| 153779 | 142620 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | 3 | 1 | 10 | 308 | 4 | |||
| 155158 | 143189 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | 3 | 1 | 10 | 308 | 23 | |||
| 158367 | 115983 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862759 | -122.405070122367 | (37.796351862759, -122.405070122367) | 3 | 1 | 10 | 308 | 4 | |||
| 159446 | 142953 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 19 Bellair Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010052.6528 | 2121119.7714 | 37.804757128417 | -122.409454893216 | (37.804757128417, -122.409454893216) | 3 | 1 | 10 | 308 | 23 | |||
| 159544 | 143505 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 11 Gerke Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010554.2854 | 2120185.3922 | 37.802219647583 | -122.407653012156 | (37.802219647583, -122.407653012156) | 3 | 1 | 10 | 308 | 23 | |||
| 161089 | 98347 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.8003305339083 | -122.40598139082 | (37.8003305339083, -122.40598139082) | 3 | 1 | 10 | 308 | 23 | |||
| 164628 | 4605 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 270 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010895.3992 | 2118554.4574 | 37.7977605876582 | -122.406357604418 | (37.7977605876582, -122.406357604418) | 3 | 1 | 10 | 308 | 23 | |||
| 165733 | 143210 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010365.1796 | 2121277.1884 | 37.8052068625476 | -122.408384467587 | (37.8052068625476, -122.408384467587) | 3 | 1 | 10 | 308 | 23 | |||
| 166162 | 142959 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 178 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009960.8111 | 2121097.7677 | 37.8046915653635 | -122.409771168052 | (37.8046915653635, -122.409771168052) | 3 | 1 | 10 | 308 | 23 | |||
| 167542 | 143170 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 179 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009922.0853 | 2121576.7805 | 37.8060046449874 | -122.409939018662 | (37.8060046449874, -122.409939018662) | 3 | 1 | 10 | 308 | 23 | |||
| 169613 | 143218 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010143.2987 | 2121269.7317 | 37.8051739606787 | -122.409151790672 | (37.8051739606787, -122.409151790672) | 3 | 1 | 10 | 308 | 23 | |||
| 170149 | 142562 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2145 POWELL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009382.2185 | 2121078.4189 | 37.804605997205 | -122.4117720848 | (37.804605997205, -122.4117720848) | 3 | 1 | 10 | 308 | 23 | |||
| 170680 | 143496 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | 3 | 1 | 10 | 28857 | 4 | |||
| 172748 | 142944 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 152 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6010124.6433 | 2121121.924 | 37.8047670723213 | -122.409205913626 | (37.8047670723213, -122.409205913626) | 3 | 1 | 10 | 308 | 23 | |||
| 173201 | 142961 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 188 Pfeiffer St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009941.6774 | 2121096.811 | 37.8046878662366 | -122.409837314827 | (37.8046878662366, -122.409837314827) | 3 | 1 | 10 | 308 | 23 | |||
| 173263 | 142465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1457 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6010961.892 | 2119955.2575 | 37.8016105625065 | -122.406226265244 | (37.8016105625065, -122.406226265244) | 3 | 1 | 10 | 308 | 23 | |||
| 180082 | 143557 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 848 KEARNY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6011271.7921 | 2117938.489 | 37.7960903354635 | -122.405011780806 | (37.7960903354635, -122.405011780806) | 3 | 1 | 10 | 28857 | 4 | |||
| 181493 | 143163 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2130 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6009857.4165 | 2121454.9705 | 37.8056665605493 | -122.410154211058 | (37.8056665605493, -122.410154211058) | 3 | 1 | 10 | 308 | 23 | |||
| 184353 | 142464 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1456 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010990.4041 | 2119956.0656 | 37.8016143761567 | -122.406127656852 | (37.8016143761567, -122.406127656852) | 3 | 1 | 10 | 308 | 23 | |||
| 184369 | 13052 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 557 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6009686.1191 | 2120512.8313 | 37.8030700779734 | -122.410680437216 | (37.8030700779734, -122.410680437216) | 3 | 1 | 10 | 308 | 23 | |||
| 184752 | 142629 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 725 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6009330.2372 | 2119895.0012 | 37.8013537106151 | -122.41186829545 | (37.8013537106151, -122.41186829545) | 3 | 1 | 10 | 308 | 4 | |||
| 184765 | 142517 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 402 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 0ft | 6010454.8754 | 2118953.3694 | 37.798831249998 | -122.407910090593 | (37.798831249998, -122.407910090593) | 3 | 1 | 10 | 308 | 23 | |||
| 185698 | 143162 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | 3 | 1 | 10 | 308 | 23 | |||
| 186082 | 108616 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | 3 | 1 | 10 | 308 | 23 | |||
| 191059 | 258059 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 600 California St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011288 | 2116842 | 37.793080546408 | -122.404878460446 | (37.793080546408, -122.404878460446) | 3 | 1 | 10 | 28857 | 4 | ||||
| 191595 | 142969 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 155 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010117.5609 | 2121101.8588 | 37.8047115814823 | -122.409229006305 | (37.8047115814823, -122.409229006305) | 3 | 1 | 10 | 308 | 23 | |||
| 191640 | 12985 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 306 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6010818.9339 | 2120706.9936 | 37.8036666476299 | -122.406773977327 | (37.8036666476299, -122.406773977327) | 3 | 1 | 10 | 308 | 23 | |||
| 192123 | 143020 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 560 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 0ft | 6009678.016 | 2120549.6995 | 37.8031708545804 | -122.410711083519 | (37.8031708545804, -122.410711083519) | 3 | 1 | 10 | 308 | 23 | |||
| 193541 | 143069 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1709 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010441.5711 | 2120399.4535 | 37.8028010970412 | -122.408058165055 | (37.8028010970412, -122.408058165055) | 3 | 1 | 10 | 308 | 23 | |||
| 132132 | 143034 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 670 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2016 12:36:00 PM | 25 | Width 0ft | 6009144.7897 | 2120475.5959 | 37.8029374735533 | -122.412551093577 | (37.8029374735533, -122.412551093577) | 3 | 1 | 10 | 308 | 23 | ||
| 131288 | 53752 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.8051637752792 | -122.409212803017 | (37.8051637752792, -122.409212803017) | 3 | 1 | 10 | 308 | 23 | ||
| 137208 | 4702 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1989 12:00:00 AM | 30 | 3X3 | 6008773.44 | 2120486.1314 | 37.8029455537581 | -122.413836905739 | (37.8029455537581, -122.413836905739) | 3 | 1 | 10 | 308 | 23 | ||
| 65586 | 59151 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | 3 | 1 | 10 | 308 | 23 | ||
| 20967 | 64425 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | 3 | 1 | 10 | 308 | 23 | ||
| 162693 | 62689 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 523 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1986 12:00:00 AM | 14 | Permit Number 23025 | 6010433.276 | 2119569.2907 | 37.8005212097535 | -122.408028291205 | (37.8005212097535, -122.408028291205) | 3 | 1 | 10 | 308 | 23 | ||
| 80867 | 59153 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 20 Bellair Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/1982 12:00:00 AM | 11 | Permit Number 19779 | 6010063.4155 | 2121130.5341 | 37.8047872831513 | -122.409418407658 | (37.8047872831513, -122.409418407658) | 3 | 1 | 10 | 308 | 23 | ||
| 36126 | 63909 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2119 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 12 | Permit Number 24624 | 6009399.6734 | 2120957.786 | 37.8042757485475 | -122.411703151333 | (37.8042757485475, -122.411703151333) | 3 | 1 | 10 | 308 | 23 | ||
| 177769 | 63908 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | 3 | 1 | 10 | 308 | 23 | ||
| 119949 | 56977 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441 | (37.8046566775876, -122.40963527441) | 3 | 1 | 10 | 308 | 23 | ||
| 17669 | 64062 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1990 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | 3 | 1 | 10 | 308 | 23 | |
| 39745 | 142504 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 610 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/1999 12:00:00 AM | 12 | Width 0ft | 6010596.4955 | 2118942.3174 | 37.7988088315184 | -122.407419256939 | (37.7988088315184, -122.407419256939) | 3 | 1 | 10 | 308 | 23 | ||
| 76877 | 53483 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.8035903907477 | -122.413979278997 | (37.8035903907477, -122.413979278997) | 3 | 1 | 10 | 308 | 23 | ||
| 167831 | 97937 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.588 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | 3 | 1 | 10 | 308 | 23 | |
| 37866 | 67753 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | 3 | 1 | 10 | 308 | 4 | |
| 45570 | 142505 | Permitted Site 7 | Ficus retusa nitida :: Banyan Fig 54 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | 3 | 1 | 10 | 308 | 23 | |
| 52068 | 142514 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 VALLEJO ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 20 | Width 0ft | Permit Number 774306 | 6010535.3238 | 2118936.1488 | 37.7987884700296 | -122.407630496745 | (37.7987884700296, -122.407630496745) | 3 | 1 | 10 | 308 | 23 | |
| 138054 | 142515 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 624 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2014 12:00:00 AM | 21 | Width 0ft | Permit Number 774306 | 6010502.9388 | 2118931.0084 | 37.7987725428783 | -122.407742197219 | (37.7987725428783, -122.407742197219) | 3 | 1 | 10 | 308 | 23 | |
| 194465 | 63910 | Prune Opt Out 3 | Ficus retusa nitida :: Banyan Fig 54 | 2135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1991 12:00:00 AM | 14 | Permit Number 788005 | 6009385.3216 | 2121038.8544 | 37.8044975370449 | -122.411758548847 | (37.8044975370449, -122.411758548847) | 3 | 1 | 10 | 308 | 23 |
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) );