trees
59 rows where qSpecies_id = 206
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1864 | 102860 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 10X CRANLEIGH DR | 1 | Median : Yard | Tree | DPW 1 | 03/06/2013 12:00:00 AM | 6 | 5991339 | 2095700 | 37.7338949747581 | -122.472360557436 | (37.7338949747581, -122.472360557436) | 1 | 8 | 4 | 64 | 40 | |||
| 2185 | 78440 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 953 Key Ave | 1 | Front Yard : Yard | Tree | Private 2 | 31 | 6013574.75289 | 2089557.59456 | 37.7182910313742 | -122.395054157617 | (37.7182910313742, -122.395054157617) | 10 | 3 | 8 | 58 | 1 | ||||
| 8887 | 261586 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 20 Aptos Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5993103 | 2094790 | 37.7314982775013 | -122.466195816439 | (37.7314982775013, -122.466195816439) | 9 | 8 | 4 | 59 | 40 | |||||
| 9067 | 222603 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 395 Sussex St | 2 | Side Yard : Yard | Tree | Private 2 | 35 | 6000867.7107 | 2096663.72062 | 37.7370880132991 | -122.439486052732 | (37.7370880132991, -122.439486052732) | 2 | 7 | 5 | 63 | 7 | ||||
| 10888 | 262140 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 1 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
| 12093 | 262143 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 420X Portola Dr | 4 | Median : Yard | Tree | DPW 1 | Private | 3x3 | 5998701 | 2100185 | 37.7466330487878 | -122.44723067426 | (37.7466330487878, -122.44723067426) | 2 | 7 | 5 | 63 | 22 | |||
| 13954 | 222598 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 514 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 5ft | 6001818.72622 | 2100905.72803 | 37.7487896491338 | -122.436501496941 | (37.7487896491338, -122.436501496941) | 2 | 4 | 5 | 28862 | 22 | |||
| 14413 | 106060 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 12X Canyon Dr | 3 | Median : Yard | Tree | DPW 1 | 24 | 6003183.55845 | 2086355.52394 | 37.7089155261884 | -122.430743733243 | (37.7089155261884, -122.430743733243) | 9 | 7 | 6 | 28861 | 5 | ||||
| 17113 | 204675 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2020 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 6ft | 5993508.90003 | 2101694.15892 | 37.7504787737838 | -122.465293874122 | (37.7504787737838, -122.465293874122) | 1 | 8 | 4 | 29491 | 40 | |||
| 26454 | 256322 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 3000X Sunset Blvd | 1 | Median : Yard | Tree | Private 2 | 3x3 | 5985361 | 2095009 | 37.7316498716246 | -122.492977136553 | (37.7316498716246, -122.492977136553) | 1 | 8 | 4 | 64 | 35 | ||||
| 27560 | 204682 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 650 Laguna Honda Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 3ft | 5995842.54098 | 2099655.29629 | 37.7450148689513 | -122.457076556356 | (37.7450148689513, -122.457076556356) | 1 | 5 | 4 | 59 | 40 | |||
| 30358 | 247105 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2301 Castro St | 23 | Front Yard : Yard | Tree | Private 2 | 1 | 6002700.64797 | 2098823.03882 | 37.7431211476283 | -122.433303017637 | (37.7431211476283, -122.433303017637) | 2 | 7 | 5 | 63 | 22 | ||||
| 36084 | 97336 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 514 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6001848 | 2100904 | 37.7487865678003 | -122.436400144832 | (37.7487865678003, -122.436400144832) | 2 | 4 | 5 | 28862 | 22 | ||||
| 36157 | 112873 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 1899x 21ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5989645 | 2102484 | 37.752423882657 | -122.478713138519 | (37.752423882657, -122.478713138519) | 1 | 8 | 3 | 56 | 35 | |||
| 37472 | 125891 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 3001 Divisadero St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 9ft | 6000478.83017 | 2118614.89434 | 37.7973383240724 | -122.442406047996 | (37.7973383240724, -122.442406047996) | 13 | 9 | 1 | 57 | 17 | |||
| 40353 | 116722 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 10X CRANLEIGH DR | 2 | Median : Yard | Tree | DPW 1 | 7 | 3x3 | 5991371 | 2095902 | 37.7344514677467 | -122.472264644795 | (37.7344514677467, -122.472264644795) | 1 | 8 | 4 | 64 | 40 | |||
| 41520 | 188360 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1310 Indiana St | 19 | : Yard | Tree | Private 2 | 1 | 6014888.31128 | 2102546.96867 | 37.7540301569914 | -122.391421271577 | (37.7540301569914, -122.391421271577) | 10 | 3 | 8 | 28856 | 29 | ||||
| 45119 | 253723 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1X Glenview Dr | 1 | Median : Yard | Tree | DPW 1 | 3x3 | 5998487 | 2100314 | 37.7469750212332 | -122.447979947083 | (37.7469750212332, -122.447979947083) | 2 | 5 | 5 | 63 | 38 | ||||
| 48588 | 188361 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1900 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 6012074.25849 | 2105151.35272 | 37.7610246351109 | -122.401336010248 | (37.7610246351109, -122.401336010248) | 10 | 3 | 8 | 28856 | 29 | ||||
| 49571 | 25715 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 998 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001180.02254 | 2096104.07947 | 37.7355691383982 | -122.43836616926 | (37.7355691383982, -122.43836616926) | 2 | 7 | 5 | 63 | 7 | |||
| 51062 | 247874 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 388 Mayflower St | 3 | Side Yard : Yard | Tree | Private 2 | 5 | 6009897.47446 | 2098392.17671 | 37.7423437484768 | -122.408387821062 | (37.7423437484768, -122.408387821062) | 10 | 7 | 7 | 28859 | 2 | ||||
| 63121 | 222600 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 6ft | 6003358.58638 | 2096297.6712 | 37.7362243718596 | -122.430847858561 | (37.7362243718596, -122.430847858561) | 2 | 7 | 5 | 63 | 7 | |||
| 63640 | 204679 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 81 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 5ft | 5992424.23101 | 2088413.99238 | 37.7139521370686 | -122.468078803789 | (37.7139521370686, -122.468078803789) | 9 | 8 | 6 | 64 | 24 | |||
| 65112 | 204680 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 122 Arch St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | Width 10ft | 5992729.38243 | 2088047.65674 | 37.7129638855601 | -122.466997477852 | (37.7129638855601, -122.466997477852) | 9 | 8 | 6 | 64 | 24 | |||
| 65661 | 248194 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 216 Esmeralda Ave | 13 | Side Yard : Yard | Tree | Private 2 | 12 | 6007325.73728 | 2098765.61768 | 37.7432247818956 | -122.417306587522 | (37.7432247818956, -122.417306587522) | 2 | 7 | 7 | 28859 | 2 | ||||
| 70504 | 204681 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2 Cranleigh Dr | 15 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 5991372.65879 | 2095865.03063 | 37.7343500551982 | -122.472256215855 | (37.7343500551982, -122.472256215855) | 1 | 8 | 4 | 64 | 40 | |||
| 71123 | 248039 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 21 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6010496.95071 | 2099420.94304 | 37.7452020700153 | -122.406387476112 | (37.7452020700153, -122.406387476112) | 2 | 7 | 7 | 28859 | 2 | ||||
| 72054 | 122402 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 2020 09th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5993533 | 2101713 | 37.7505318963709 | -122.465211903667 | (37.7505318963709, -122.465211903667) | 1 | 8 | 4 | 29491 | 40 | ||||
| 81808 | 114407 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 500X ARBALLO DR | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | ||||
| 82324 | 253122 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2 Warren Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2103402 | 37.7553185401494 | -122.45637419556 | (37.7553185401494, -122.45637419556) | 1 | 5 | 4 | 63 | 12 | ||||
| 84778 | 125894 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 575 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008991.2267 | 2114571.87552 | 37.7867186868654 | -122.412664902283 | (37.7867186868654, -122.412664902283) | 5 | 1 | 9 | 28852 | 36 | |||
| 84839 | 117534 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 100 BRENTWOOD AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x10 | 5995843 | 2095739 | 37.7342617075966 | -122.456791779994 | (37.7342617075966, -122.456791779994) | 9 | 7 | 4 | 59 | 40 | ||||
| 85744 | 188362 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1888 Illinois St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6016272.68217 | 2100361.78629 | 37.7481068397617 | -122.386481387306 | (37.7481068397617, -122.386481387306) | 3 | 8 | 58 | 1 | ||||
| 91185 | 247285 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 532 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998960.7787 | 2108866.9831 | 37.7704864601808 | -122.446957047096 | (37.7704864601808, -122.446957047096) | 15 | 5 | 11 | 29492 | 9 | |||
| 97005 | 204673 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1459 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5991459.64177 | 2105500.40872 | 37.7608113437765 | -122.472657776632 | (37.7608113437765, -122.472657776632) | 1 | 8 | 4 | 56 | 12 | |||
| 97348 | 222601 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 6ft | 6003357.30994 | 2096300.31548 | 37.7362315601275 | -122.43085246039 | (37.7362315601275, -122.43085246039) | 2 | 7 | 5 | 63 | 7 | |||
| 99660 | 248067 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 20 Rutledge St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6010631.32823 | 2099397.64766 | 37.7451456222698 | -122.405921178544 | (37.7451456222698, -122.405921178544) | 2 | 7 | 7 | 28859 | 2 | ||||
| 104704 | 256850 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 100 Brentwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | 5995843 | 2095739 | 37.7342617075966 | -122.456791779994 | (37.7342617075966, -122.456791779994) | 9 | 7 | 4 | 59 | 40 | ||||
| 108811 | 204677 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 369 Kensington Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 5ft | 5994076.02183 | 2099112.26471 | 37.7434222343611 | -122.463145421645 | (37.7434222343611, -122.463145421645) | 1 | 8 | 4 | 59 | 40 | |||
| 111076 | 222599 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 514 Clipper St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 5ft | 6001802.25056 | 2100905.49353 | 37.7487880690163 | -122.436558452831 | (37.7487880690163, -122.436558452831) | 2 | 4 | 5 | 28862 | 22 | |||
| 113006 | 185057 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 700x Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 5989061.5867 | 2095971.0284 | 37.7345070764722 | -122.480254005554 | (37.7345070764722, -122.480254005554) | 1 | 8 | 4 | 64 | 35 | |||
| 115480 | 254095 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1X Glenview Dr | 3 | Median : Yard | Tree | DPW 1 | 3x3 | 5998487 | 2100314 | 37.7469750212332 | -122.447979947083 | (37.7469750212332, -122.447979947083) | 2 | 5 | 5 | 63 | 38 | ||||
| 116757 | 247216 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 800 Duboce Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6001815.64932 | 2108295.72731 | 37.769080621688 | -122.437041145039 | (37.769080621688, -122.437041145039) | 15 | 5 | 5 | 29492 | 9 | |||
| 117541 | 97335 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 514 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x4 | 6001848 | 2100904 | 37.7487865678003 | -122.436400144832 | (37.7487865678003, -122.436400144832) | 2 | 4 | 5 | 28862 | 22 | ||||
| 123644 | 249888 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 230 Greenwich St | 24 | Back Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011477.22379 | 2120439.43792 | 37.8029688157308 | -122.404477074154 | (37.8029688157308, -122.404477074154) | 3 | 1 | 10 | 28860 | 6 | |||
| 127076 | 104193 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 122 Arch St | 1 | Front Yard : Yard | Tree | Private 2 | 5992720.4 | 2088013.1 | 37.7128684825751 | -122.467026013031 | (37.7128684825751, -122.467026013031) | 9 | 8 | 6 | 64 | 24 | |||||
| 127232 | 116294 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 20 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6007210 | 2099458 | 37.7451193965097 | -122.417755844265 | (37.7451193965097, -122.417755844265) | 2 | 7 | 7 | 28859 | 2 | |||
| 144000 | 125892 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 3001 Divisadero St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 9ft | 6000476.92366 | 2118604.49605 | 37.7973096644524 | -122.442411898085 | (37.7973096644524, -122.442411898085) | 13 | 9 | 1 | 57 | 17 | |||
| 144501 | 204674 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2020 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 6ft | 5993511.09309 | 2101677.27799 | 37.7504325495392 | -122.465285064363 | (37.7504325495392, -122.465285064363) | 1 | 8 | 4 | 29491 | 40 | |||
| 149290 | 204676 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 369 Kensington Way | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 5ft | 5994061.69592 | 2099122.21438 | 37.7434487283817 | -122.463195678435 | (37.7434487283817, -122.463195678435) | 1 | 8 | 4 | 59 | 40 | |||
| 149774 | 125893 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2300 North Point St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 5999689.26041 | 2120554.06865 | 37.8026177428776 | -122.445277648072 | (37.8026177428776, -122.445277648072) | 13 | 9 | 1 | 57 | 17 | |||
| 151671 | 217839 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 2 Cranleigh Dr | 29 | Front Yard : Yard | Tree | Private 2 | 6 | 5991400.82027 | 2095852.26956 | 37.7343166462934 | -122.472157923553 | (37.7343166462934, -122.472157923553) | 1 | 8 | 4 | 64 | 40 | ||||
| 152392 | 188363 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 1888 Illinois St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6016272.9604 | 2100359.33307 | 37.7481001191295 | -122.38648025416 | (37.7481001191295, -122.38648025416) | 3 | 8 | 58 | 1 | ||||
| 156334 | 204678 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 56 Paradise Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 3ft | 6001013.21275 | 2096039.11507 | 37.7353812718197 | -122.438938238827 | (37.7353812718197, -122.438938238827) | 2 | 7 | 5 | 63 | 7 | |||
| 177478 | 249876 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 230 Greenwich St | 12 | Back Yard : Yard | Tree | Private 2 | 29 | Width 0ft | 6011590.62668 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | 3 | 1 | 10 | 28860 | 6 | |||
| 179533 | 176846 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 211 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6007213.98461 | 2092669.27766 | 37.7264792821724 | -122.417261085441 | (37.7264792821724, -122.417261085441) | 9 | 3 | 7 | 309 | 28 | |||
| 182834 | 112183 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 301x CORBETT AVE | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5999677 | 2105220 | 37.760513648973 | -122.444217531177 | (37.760513648973, -122.444217531177) | 15 | 5 | 5 | 28862 | 3 | ||||
| 193192 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768767 | 5998994 | 2106195 | 37.7631517661679 | -122.446649857914 | (37.7631517661679, -122.446649857914) | 15 | 5 | 5 | 29492 | 9 | ||||
| 194191 | 29620 | DPW Maintained 1 | Calocedrus decurrens :: Incense Cedar 206 | 900X Junipero Serra Blvd | 29 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991161.61567 | 2090864.54697 | 37.7206077605242 | -122.472621393665 | (37.7206077605242, -122.472621393665) | 9 | 8 | 4 | 64 | 40 |
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) );