trees
61 rows where qSpecies_id = 81
This data as json, CSV (advanced)
qLegalStatus_id ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
266 | 219228 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 200x Terrace Dr | 4 | Median : Yard | Tree | DPW 1 | 10 | 5993785.97496 | 2096493.89011 | 37.736216119669 | -122.463958297244 | (37.736216119669, -122.463958297244) | 1 | 8 | 4 | 59 | 40 | ||||
2963 | 183435 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2502 26th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988322.9645 | 2098243.2971 | 37.740703186103 | -122.48297412001 | (37.740703186103, -122.48297412001) | 1 | 8 | 3 | 29491 | 35 | |||
3732 | 118637 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 489 45th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5981892.63195 | 2112480.11557 | 37.7794171598516 | -122.506262811826 | (37.7794171598516, -122.506262811826) | 11 | 6 | 2 | 55 | 26 | |||
6225 | 19831 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 100 STAIRWAY25 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
6370 | 261832 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 16 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995265 | 2100184 | 37.7464333732005 | -122.459111852123 | (37.7464333732005, -122.459111852123) | 1 | 8 | 4 | 59 | 40 | ||||
13139 | 182087 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2445 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988353.2291 | 2098271.1187 | 37.7407813379181 | -122.482871516272 | (37.7407813379181, -122.482871516272) | 1 | 8 | 3 | 29491 | 35 | |||
16656 | 19780 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 100 STAIRWAY19 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
16878 | 117887 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 592 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5982584.75817 | 2111760.42718 | 37.7774818283717 | -122.50381517937 | (37.7774818283717, -122.50381517937) | 11 | 6 | 2 | 55 | 26 | |||
19823 | 116396 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 491 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5986227.46387 | 2112707.13917 | 37.7802947441584 | -122.491283721582 | (37.7802947441584, -122.491283721582) | 11 | 6 | 2 | 55 | 26 | |||
31003 | 247544 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 815 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 6000179.66489 | 2108445.2622 | 37.7693980814777 | -122.442710639406 | (37.7693980814777, -122.442710639406) | 15 | 5 | 11 | 29492 | 9 | |||
32791 | 254539 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 5 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
35009 | 244388 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 867 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003258.1157 | 2110303.4924 | 37.7746753358595 | -122.432195147264 | (37.7746753358595, -122.432195147264) | 15 | 9 | 11 | 29492 | 10 | |||
35326 | 183434 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2502 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988323.5274 | 2098241.0455 | 37.7406970365538 | -122.482972008757 | (37.7406970365538, -122.482972008757) | 1 | 8 | 3 | 29491 | 35 | |||
36703 | 244150 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 403 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004582.2514 | 2109632.0608 | 37.772906735272 | -122.427566848583 | (37.772906735272, -122.427566848583) | 7 | 9 | 11 | 28852 | 10 | |||
38400 | 182091 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2445 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5988425.6513 | 2098272.8108 | 37.740790197611 | -122.482621234539 | (37.740790197611, -122.482621234539) | 1 | 8 | 3 | 29491 | 35 | |||
40307 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49875 | 5993901 | 2092133 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | 9 | 8 | 4 | 59 | 40 | |||
40889 | 183436 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2502 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988324.0903 | 2098255.9623 | 37.7407380269297 | -122.482971155492 | (37.7407380269297, -122.482971155492) | 1 | 8 | 3 | 29491 | 35 | |||
43207 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
43728 | 254538 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 737 Buena Vista Ave West | 4 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
53410 | 129098 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 699 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 5999673.75993 | 2121514.33526 | 37.8052534912214 | -122.445400374028 | (37.8052534912214, -122.445400374028) | 13 | 9 | 1 | 57 | 17 | |||
54394 | 228523 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 885 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998683.04499 | 2107050.20185 | 37.7654821679992 | -122.447786913029 | (37.7654821679992, -122.447786913029) | 15 | 5 | 11 | 29492 | 9 | |||
60246 | 190677 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 900x Carolina St | 71 | Median : Yard | Tree | DPW 1 | 7 | 6012520.45276 | 2102813.85342 | 37.7546312593522 | -122.399628684232 | (37.7546312593522, -122.399628684232) | 10 | 3 | 8 | 28856 | 29 | ||||
63781 | 182010 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2798 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987426.2917 | 2098298.8693 | 37.7408035561751 | -122.486078512429 | (37.7408035561751, -122.486078512429) | 1 | 8 | 3 | 29491 | 35 | |||
67127 | 183439 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2506 26th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5988324.3717 | 2098230.6319 | 37.7406684926665 | -122.482968326485 | (37.7406684926665, -122.482968326485) | 1 | 8 | 3 | 29491 | 35 | |||
68606 | 117716 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 3945 Clement St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 5983209.45945 | 2113085.35212 | 37.7811563972474 | -122.501752215396 | (37.7811563972474, -122.501752215396) | 11 | 6 | 2 | 55 | 26 | |||
72029 | 183057 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 912 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5990112.1764 | 2097710.1846 | 37.7393433452946 | -122.476748830936 | (37.7393433452946, -122.476748830936) | 1 | 8 | 3 | 29491 | 35 | |||
73248 | 129095 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2942 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000568.08591 | 2118422.82625 | 37.7968160427755 | -122.442083407248 | (37.7968160427755, -122.442083407248) | 13 | 9 | 1 | 57 | 17 | |||
73662 | 183058 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 920 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5990096.9474 | 2097710.523 | 37.7393433910761 | -122.476801510221 | (37.7393433910761, -122.476801510221) | 1 | 8 | 3 | 29491 | 35 | |||
77275 | 118638 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 489 45th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | Width 9ft | 5981883.80409 | 2112496.71277 | 37.779462211155 | -122.506294581666 | (37.779462211155, -122.506294581666) | 11 | 6 | 2 | 55 | 26 | |||
82605 | 182089 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2445 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5988388.4249 | 2098272.134 | 37.7407861734754 | -122.482749898297 | (37.7407861734754, -122.482749898297) | 1 | 8 | 3 | 29491 | 35 | |||
90283 | 3132 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 3266 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 5998797.59633 | 2114972.68409 | 37.7872418121422 | -122.447961158094 | (37.7872418121422, -122.447961158094) | 13 | 6 | 1 | 54 | 31 | |||
95132 | 122063 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 5 17th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 5990505.08019 | 2115005.32961 | 37.7868539537607 | -122.476653573827 | (37.7868539537607, -122.476653573827) | 11 | 6 | 1 | 61 | 30 | |||
95303 | 123326 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 799 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994723.62372 | 2110289.80732 | 37.7741501756081 | -122.461716464535 | (37.7741501756081, -122.461716464535) | 11 | 6 | 2 | 54 | 11 | |||
97746 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
102261 | 244100 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 1601 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998872.1214 | 2109002.8983 | 37.7708545832672 | -122.447273495634 | (37.7708545832672, -122.447273495634) | 15 | 5 | 11 | 29492 | 9 | |||
103673 | 244149 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 403 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004569.5642 | 2109632.0608 | 37.7729060176478 | -122.427610735127 | (37.7729060176478, -122.427610735127) | 7 | 9 | 11 | 28852 | 10 | |||
103915 | 183059 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 924 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5990080.3647 | 2097710.523 | 37.7393424291485 | -122.476858845232 | (37.7393424291485, -122.476858845232) | 1 | 8 | 3 | 29491 | 35 | |||
109067 | 181783 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2755 Ulloa St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5987457.0881 | 2098239.9839 | 37.7406436671581 | -122.485967710136 | (37.7406436671581, -122.485967710136) | 1 | 8 | 3 | 29491 | 35 | |||
109572 | 249700 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2400 Baker St | 32 | Front Yard : Yard | Tree | Private 2 | 4 | 5999694.38585 | 2117225.06205 | 37.7934774706624 | -122.445020451827 | (37.7934774706624, -122.445020451827) | 13 | 9 | 1 | 57 | 27 | ||||
112002 | 219227 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 70 Aloha Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991836.36372 | 2104420.02538 | 37.7578666954186 | -122.471276157164 | (37.7578666954186, -122.471276157164) | 1 | 8 | 4 | 56 | 12 | |||
115341 | 182090 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2445 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988408.7302 | 2098273.1492 | 37.7407901423219 | -122.482679765429 | (37.7407901423219, -122.482679765429) | 1 | 8 | 3 | 29491 | 35 | |||
125082 | 129096 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 313 Maple St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996631.61587 | 2115198.1283 | 37.7877367751689 | -122.455471243996 | (37.7877367751689, -122.455471243996) | 11 | 6 | 1 | 54 | 31 | |||
125938 | 116398 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 491 31st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5986230.22871 | 2112671.88005 | 37.7801980942572 | -122.491271561101 | (37.7801980942572, -122.491271561101) | 11 | 6 | 2 | 55 | 26 | |||
130801 | 182587 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2447 26th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5988270.6541 | 2098478.9097 | 37.7413470724826 | -122.483172253202 | (37.7413470724826, -122.483172253202) | 1 | 8 | 3 | 29491 | 35 | |||
132465 | 182088 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2445 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988370.827 | 2098270.4419 | 37.7407805035232 | -122.482810620505 | (37.7407805035232, -122.482810620505) | 1 | 8 | 3 | 29491 | 35 | |||
136228 | 252825 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 3852 17th St | 4 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
136654 | 118083 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 7309 Geary Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5984328.88362 | 2112397.00903 | 37.7793320968225 | -122.49782878117 | (37.7793320968225, -122.49782878117) | 11 | 6 | 2 | 55 | 26 | |||
145083 | 219225 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 1820 16th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 5ft | 5991268.14409 | 2102994.44508 | 37.7539195421662 | -122.473137315828 | (37.7539195421662, -122.473137315828) | 1 | 8 | 4 | 56 | 12 | |||
148432 | 219231 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 449 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5997163.53491 | 2095515.52142 | 37.7337238258 | -122.452210171862 | (37.7337238258, -122.452210171862) | 9 | 7 | 4 | 59 | 40 | ||||
152436 | 219226 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 98 Lurline St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991838.56734 | 2105160.13567 | 37.759898970787 | -122.471322460584 | (37.759898970787, -122.471322460584) | 1 | 8 | 4 | 56 | 12 | |||
156283 | 219230 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 175 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 5999606.10326 | 2095741.44552 | 37.7344837817026 | -122.443781745426 | (37.7344837817026, -122.443781745426) | 9 | 7 | 4 | 63 | 40 | |||
163605 | 120103 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2551 Cabrillo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 5987706.88835 | 2110474.66057 | 37.77425132027 | -122.486001854101 | (37.77425132027, -122.486001854101) | 11 | 6 | 2 | 55 | 26 | |||
165251 | 138779 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 538 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999189.3925 | 2114781.3264 | 37.7867387814828 | -122.446591859454 | (37.7867387814828, -122.446591859454) | 15 | 6 | 1 | 29490 | 31 | |||
166543 | 219229 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 300x Marietta Dr | 47 | Median : Cutout | Tree | DPW 1 | 11 | Width 5ft | 5999539.46642 | 2097492.37053 | 37.7392876066259 | -122.444137903966 | (37.7392876066259, -122.444137903966) | 9 | 7 | 4 | 59 | 40 | |||
170567 | 182009 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2796 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5987440.5055 | 2098297.1772 | 37.7407997384745 | -122.486029242895 | (37.7407997384745, -122.486029242895) | 1 | 8 | 3 | 29491 | 35 | |||
171576 | 129097 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 699 Marina Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 5999648.00124 | 2121510.04753 | 37.8052402478033 | -122.445489206378 | (37.8052402478033, -122.445489206378) | 13 | 9 | 1 | 57 | 17 | |||
171930 | 129094 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2942 Divisadero St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000566.12061 | 2118445.50816 | 37.7968782093121 | -122.442091836579 | (37.7968782093121, -122.442091836579) | 13 | 9 | 1 | 57 | 17 | |||
176304 | 181782 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2755 Ulloa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987437.7981 | 2098239.3071 | 37.7406406846815 | -122.48603435705 | (37.7406406846815, -122.48603435705) | 1 | 8 | 3 | 29491 | 35 | |||
177272 | 185003 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 2701 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985018.8709 | 2096488.705 | 37.7356927337416 | -122.494268955014 | (37.7356927337416, -122.494268955014) | 1 | 8 | 3 | 29491 | 35 | |||
177413 | 218287 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 1 Woodacre Dr | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5991329.99765 | 2095591.79515 | 37.7335973505247 | -122.472383795489 | (37.7335973505247, -122.472383795489) | 1 | 8 | 4 | 64 | 40 | ||||
188319 | 117909 | DPW Maintained 1 | Ilex spp :: Holly Species 81 | 835 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5983528.95902 | 2110122.17554 | 37.7730391366516 | -122.500427770772 | (37.7730391366516, -122.500427770772) | 11 | 6 | 2 | 55 | 26 |
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) );