76 rows where qSpecies_id = 186

View and edit SQL

Suggested facets: 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)
1410 68319 Permitted Site 7 Heteromeles arbutifolia :: Toyon 186 100 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32134 5993677.209627 2114838.05789906 37.7865781513031 -122.465666673248 (37.7865781513031, -122.465666673248) 11 6 2 54 11
2392 228420 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 2717 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008985 2102620 37.7539012717242 -122.411841575704 (37.7539012717242, -122.411841575704) 2 4 7 28859 19
2799 261855 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1900x Bay Shore Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
3554 264866 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 8 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5206 264864 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 6 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5321 264860 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 2 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
5474 264865 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 7 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
6005 264861 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 3 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
7163 255651 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 1 Unaccepted Street : Yard Tree Private 2       10x100 Permit Number 783039 5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
8122 264863 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 5 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
8802 176563 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010260.41532 2089074.47273 37.7167796145598 -122.406476454124 (37.7167796145598, -122.406476454124) 9 7 8 309 39
12645 264862 Section 806 (d) 5 Heteromeles arbutifolia :: Toyon 186 10X Selma Way 4 Unaccepted Street : Yard Tree Private 2       10x100   5992494 2103402 37.7551094821546 -122.468927712716 (37.7551094821546, -122.468927712716) 1 8 4 56 12
13615 247594 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 800 Tompkins Ave 15 Front Yard : Yard Tree Private 2     3     6009044.34802 2096418.84248 37.7368775908376 -122.411198321169 (37.7368775908376, -122.411198321169) 10 7 7 28859 2
15120 219172 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 47 Ralston St 2 Back Yard : Yard Tree Private 2     4     5992175.93719 2088256.51499 37.7135053997375 -122.468925539806 (37.7135053997375, -122.468925539806) 9 8 6 64 24
22822 219173 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 47 Ralston St 3 Back Yard : Yard Tree Private 2     14     5992177.27741 2088252.32059 37.71349396036 -122.468920602522 (37.71349396036, -122.468920602522) 9 8 6 64 24
28188 201534 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 3 Front Yard : Yard Tree Private 2     4     6020030.3592 2093817.11357 37.7303437436519 -122.373034303211 (37.7303437436519, -122.373034303211) 10 3 8 58 1
30228 201537 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 6 Front Yard : Yard Tree Private 2     4     6020208.27308 2093682.62725 37.7299842468553 -122.372409919208 (37.7299842468553, -122.372409919208) 10 3 8 58 1
32453 129083 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1000 Vallejo St 1 Front Yard : Yard Tree Private 2     6     6008684.91148 2118672.65791 37.7979612349835 -122.414014894389 (37.7979612349835, -122.414014894389) 5 1 10 308 21
33367 120264 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 100 24th Ave 4 Side Yard : Yard Tree Private 2     7     5988352.12015 2115168.07199 37.787175686198 -122.484114163983 (37.787175686198, -122.484114163983) 11 6 1 55 33
39086 228411 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1001 San Jose Ave 15 Front Yard : Yard Tree Private 2     15     6005184.56128 2096919.47868 37.7380350039047 -122.424578923778 (37.7380350039047, -122.424578923778) 2 7 5 28859 2
40057 190640 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1450 Rhode Island St 1 : Tree Private 2     11 Width 6ft   6011986.5577 2101606.22651 37.7512856041566 -122.401390184524 (37.7512856041566, -122.401390184524) 10 3 8 28856 29
41028 97042 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
45133 176561 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 130 Tucker Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010209.02707 2088857.9685 37.7161822632845 -122.406638830318 (37.7161822632845, -122.406638830318) 9 7 8 309 39
47481 201543 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 12 Sidewalk: Property side : Yard Tree Private 2     7     6020620.74495 2093375.17595 37.72916269819 -122.370962683378 (37.72916269819, -122.370962683378) 10 3 8 58 1
48755 228413 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1001 San Jose Ave 33 Front Yard : Yard Tree Private 2     24     6005270.82882 2097081.76625 37.7384854806095 -122.424292192952 (37.7384854806095, -122.424292192952) 2 7 5 28859 2
52297 228415 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Coso Ave 3 Sidewalk: Property side : Yard Tree Private 2     15     6007485.33781 2099637.23904 37.7456270374703 -122.416816467813 (37.7456270374703, -122.416816467813) 2 7 7 28859 2
53311 176560 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 130 Tucker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010230.7823 2088849.41401 37.7161599915583 -122.406563030976 (37.7161599915583, -122.406563030976) 9 7 8 309 39
58369 228412 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1001 San Jose Ave 25 Front Yard : Yard Tree Private 2     3     6005246.06696 2097029.70767 37.7383411412288 -122.424374105882 (37.7383411412288, -122.424374105882) 2 7 5 28859 2
58606 190642 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 180x Bay Shore Blvd 2 Median : Yard Tree DPW 1     4     6011171.25582 2099566.12799 37.7456384147754 -122.404066047117 (37.7456384147754, -122.404066047117) 10 3 7 58 1
61479 201536 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 5 Front Yard : Yard Tree Private 2     4     6020184.94124 2093703.94604 37.7300415022109 -122.372492056066 (37.7300415022109, -122.372492056066) 10 3 8 58 1
66287 176559 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 130 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010251.33586 2088843.37979 37.7161445727026 -122.406491562734 (37.7161445727026, -122.406491562734) 9 7 8 309 39
70539 228421 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 840 27th St 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6001133.99652 2099998.61422 37.7462599974077 -122.438804290182 (37.7462599974077, -122.438804290182) 2 4 5 63 22
74560 176566 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Tioga Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010219.37892 2089089.59788 37.716818849299 -122.406619362691 (37.716818849299, -122.406619362691) 9 7 8 309 39
75132 228418 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 200 Eugenia Ave 25 Front Yard : Yard Tree Private 2     6     6006650.86618 2098057.80903 37.7412433056354 -122.419589911363 (37.7412433056354, -122.419589911363) 2 7 7 28859 2
77704 228427 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 12 Harper St 6 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003646.9059 2098243.92046 37.7415846586187 -122.429989809976 (37.7415846586187, -122.429989809976) 2 7 5 63 7
79842 16144 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 370 Monterey Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   5999723.79091 2094721.55467 37.7316901124118 -122.443301631573 (37.7316901124118, -122.443301631573) 9 7 4 63 40
79959 176567 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Tioga Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010201.353 2089095.69821 37.7168345910218 -122.406682099409 (37.7168345910218, -122.406682099409) 9 7 8 309 39
81659 228426 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 12 Harper St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003647.62905 2098253.18086 37.741610126501 -122.429987969992 (37.741610126501, -122.429987969992) 2 7 5 63 7
82074 219170 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1485x Northwood Dr 2 Median : Yard Tree DPW 1     26     5995884.37538 2093916.02711 37.7292586405571 -122.456516950515 (37.7292586405571, -122.456516950515) 9 7 4 28861 40
85886 219175 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 900 Junipero Serra Blvd 44 : Tree Private 2     3 Width 0ft   5991147.96907 2090696.24871 37.7201448650745 -122.472656300859 (37.7201448650745, -122.472656300859) 9 8 4 64 40
86297 176568 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 331 Trumbull St 1 Sidewalk: Property side : Yard Tree Private 2     26 Width 8ft   6005242.43396 2094359.74451 37.7310098139482 -122.424196833342 (37.7310098139482, -122.424196833342) 9 7 6 28861 5
97121 219174 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 700 Junipero Serra Blvd 128 : Tree Private 2     25 Width 0ft   5991213.30125 2091731.56505 37.722991369546 -122.47250591174 (37.722991369546, -122.47250591174) 9 8 4 64 40
101391 228414 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1000 San Jose Ave 51 Front Yard : Yard Tree Private 2     6     6005106.2212 2097134.84761 37.7386219338653 -122.424865102441 (37.7386219338653, -122.424865102441) 2 7 5 63 7
108365 228409 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 3526 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6006042.70531 2104942.06917 37.7601116289648 -122.422181694537 (37.7601116289648, -122.422181694537) 2 4 5 28859 19
114072 176565 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Tioga Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010235.34544 2089083.11111 37.7168019312417 -122.406563717151 (37.7168019312417, -122.406563717151) 9 7 8 309 39
118637 219169 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 183 Edgewood Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996570.01425 2105985.95468 37.7624390195773 -122.455018456938 (37.7624390195773, -122.455018456938) 15 5 11 29492 12
120723 97043 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
122937 228422 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 840 27th St 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6001124.36874 2099998.49404 37.746259119672 -122.438837573191 (37.746259119672, -122.438837573191) 2 4 5 63 22
123835 247595 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 800 Tompkins Ave 16 Front Yard : Yard Tree Private 2     12     6009066.01664 2096417.50903 37.736875144675 -122.41112330872 (37.736875144675, -122.41112330872) 10 7 7 28859 2
126648 190639 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 845 Vermont St 6 Sidewalk: Curb side : Yard Tree Private 2     18     6011328.94664 2104371.38115 37.7588413959188 -122.403858847825 (37.7588413959188, -122.403858847825) 10 3 8 28856 29
128370 190645 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1427x Innes Ave 10 Median : Yard Tree DPW 1     25     6016289.87558 2096646.78665 37.7379071625864 -122.38616298323 (37.7379071625864, -122.38616298323) 10 3 8 58 1
134786 228423 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 840 27th St 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6001113.13112 2099998.08788 37.7462573651032 -122.438876402327 (37.7462573651032, -122.438876402327) 2 4 5 63 22
137070 228425 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 12 Harper St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003643.93015 2098280.28853 37.7416843484423 -122.430002692783 (37.7416843484423, -122.430002692783) 2 7 5 63 7
137829 190638 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 889 Vermont St 8 Sidewalk: Curb side : Yard Tree Private 2     9     6011331.78056 2104200.20298 37.7583715370391 -122.403837001476 (37.7583715370391, -122.403837001476) 10 3 8 28856 29
138482 201533 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 2 Front Yard : Yard Tree Private 2     7     6020026.38212 2093819.59918 37.7303503500706 -122.373048224703 (37.7303503500706, -122.373048224703) 10 3 8 58 1
139112 219176 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 900 Junipero Serra Blvd 45 : Tree Private 2     3 Width 0ft   5991144.913 2090692.17248 37.7201334958488 -122.472666567517 (37.7201334958488, -122.472666567517) 9 8 4 64 40
139633 190643 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 2 Middle Point Rd 4 Sidewalk: Curb side : Yard Tree Private 2     8     6018217.52844 2096361.11678 37.7372292724971 -122.379478232531 (37.7372292724971, -122.379478232531) 10 3 8 58 1
142749 12737 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1628 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 4   5990390.11665 2114767.32426 37.786193788988 -122.477033918701 (37.786193788988, -122.477033918701) 11 6 1 55 33
145387 176562 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 130 Tucker Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010187.91081 2088867.13359 37.7162062472954 -122.406712464114 (37.7162062472954, -122.406712464114) 9 7 8 309 39
147049 228417 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1201 San Jose Ave 29 Front Yard : Yard Tree Private 2     6     6004356.2801 2096019.85272 37.7355180227423 -122.427378634733 (37.7355180227423, -122.427378634733) 2 7 5 28861 2
147935 201538 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 7 Front Yard : Yard Tree Private 2     11     6020320.60238 2093595.7564 37.7297518872405 -122.372015570059 (37.7297518872405, -122.372015570059) 10 3 8 58 1
148250 190641 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 2275 Jerrold Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6011948.10187 2099483.81894 37.7454557858727 -122.401374030901 (37.7454557858727, -122.401374030901) 10 3 8 58 1
150573 228410 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1001 San Jose Ave 11 Front Yard : Yard Tree Private 2     17     6005112.19304 2096765.80607 37.7376089662775 -122.42481820732 (37.7376089662775, -122.42481820732) 2 7 5 28859 2
153456 201532 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 601 Innes Ave 1 Front Yard : Yard Tree Private 2     5     6020021.83334 2093823.70013 37.7303613604801 -122.373064234453 (37.7303613604801, -122.373064234453) 10 3 8 58 1
158168 190646 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 230 Middle Point Rd 4 Side Yard : Yard Tree Private 2     8 Width 8ft   6018218.4425 2096359.44868 37.7372247426365 -122.379474956329 (37.7372247426365, -122.379474956329) 10 3 8 58 1
161343 202065 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1 Hwy 101 S On Ramp 4 Sidewalk: Property side : Yard Tree Private 2     10 Width 9ft   6012968.07347 2090188.26026 37.7199889576912 -122.397195405666 (37.7199889576912, -122.397195405666) 10 3 8 58 1
165091 176564 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 145 Tioga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010251.14123 2089077.27273 37.7167867839527 -122.406508707432 (37.7167867839527, -122.406508707432) 9 7 8 309 39
167097 219171 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1485x Northwood Dr 3 Median : Yard Tree DPW 1     7     5995877.51816 2093932.37838 37.72930314352 -122.456541838346 (37.72930314352, -122.456541838346) 9 7 4 28861 40
169404 201515 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1001 Innes Ave 13 Sidewalk: Property side : Yard Tree Private 2     5 Width 8ft   6018702.03341 2094815.0321 37.7330107362577 -122.37769578973 (37.7330107362577, -122.37769578973) 10 3 8 58 1
174278 228419 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 998 York St 8 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6009935.93265 2103433.97636 37.7561895713205 -122.408610430245 (37.7561895713205, -122.408610430245) 2 4 7 28859 19
175126 97044 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
176615 228424 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1533 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6002044.82441 2099554.19338 37.7450914992898 -122.435622973542 (37.7450914992898, -122.435622973542) 2 7 5 63 22
184206 176558 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 300x Mansell St 19 Median : Cutout Tree DPW 1     10 Width 0ft   6010777.60358 2090452.8911 37.7205933893479 -122.404785768266 (37.7205933893479, -122.404785768266) 10 3 7 309 28
185560 228416 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1201 San Jose Ave 24 Front Yard : Yard Tree Private 2     1     6004325.98543 2095958.82684 37.7353487460293 -122.427479028752 (37.7353487460293, -122.427479028752) 2 7 5 28861 2
186801 190644 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 1427x Innes Ave 8 Median : Yard Tree DPW 1     26     6016311.73446 2096627.56435 37.7378555918516 -122.386086066043 (37.7378555918516, -122.386086066043) 10 3 8 58 1
192663 54794 DPW Maintained 1 Heteromeles arbutifolia :: Toyon 186 340 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1972 12:00:00 AM 1   Permit Number 10644 6012527.25356 2086869.29429 37.7108511883114 -122.398486411239 (37.7108511883114, -122.398486411239) 10 3 8 309 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);