trees

74 rows where Zip Codes = 57 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
4658 46466 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3310X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM 12 3x3 Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
11093 95037 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3224 Pierce St 8 Sidewalk: Property side : Cutout Tree Dept of Real Estate 7     10 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
15062 102786 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3345 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4.5x6 Permit Number 772480 6003174.4 2119873.2 37.8009465759098 -122.433168646536 (37.8009465759098, -122.433168646536) 13 9 1 57 17
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
29776 44063 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
41634 13254 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2408 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 45 3X3   6000832.23006 2119380.36917 37.7994602521243 -122.441238147567 (37.7994602521243, -122.441238147567) 13 9 1 57 17
43653 95034 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
49412 94931 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1771 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6004522 2118744 37.7979224352085 -122.428424847305 (37.7979224352085, -122.428424847305) 13 9 1 57 17
50801 95033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
50984 95035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
55002 13200 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
56427 44064 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
57812 13193 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002451.4681 2119463.3271 37.7997801365268 -122.435640954547 (37.7997801365268, -122.435640954547) 13 9 1 57 17
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
63529 56688 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6002930 2119911 37.801036497901 -122.434017077007 (37.801036497901, -122.434017077007) 13 9 1 57 17
66213 50374 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
67334 99615 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
70447 44061 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
70974 23955 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1985X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6002890.93346 2119517.51166 37.7999538645084 -122.434124118866 (37.7999538645084, -122.434124118866) 13 9 1 57 17
75083 46223 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1888 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
77560 95038 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
77688 1668 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
77847 13285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2576 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1993 12:00:00 AM 3 3X3   6000068.81033 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799) 13 9 1 57 17
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
87780 95040 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 13 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
90065 13211 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2190 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6001897.52108 2119466.22991 37.7997566277665 -122.437558020868 (37.7997566277665, -122.437558020868) 13 9 1 57 17
95876 26159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 210 Richardson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5999117.59522 2119823.02413 37.800577843616 -122.447203245105 (37.800577843616, -122.447203245105) 13 9 1 57 17
99582 99612 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
107261 18696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 3 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
115478 13204 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2150 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6001979.60867 2119494.8171 37.7998397874351 -122.437276016047 (37.7998397874351, -122.437276016047) 13 9 1 57 17
115585 13186 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2051X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002574.7502816 2119473.5963948 37.7998153348368 -122.435215088035 (37.7998153348368, -122.435215088035) 13 9 1 57 17
120455 1669 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     13 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
120658 13201 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
120981 95046 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 10 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     13 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
122270 95039 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
123904 98659 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
127089 108101 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 3 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
129349 95041 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
131050 110659 Undocumented 4 Ficus nitida :: Laurel Fig 53 2393 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001559 2118656 37.7975126970015 -122.438671337949 (37.7975126970015, -122.438671337949) 13 9 1 57 17
134352 18684 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 165X Richardson Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5999250.42609 2119592.62258 37.7999528116563 -122.446727010779 (37.7999528116563, -122.446727010779) 13 9 1 57 17
135783 13192 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002431.86629 2119459.61132 37.7997688205881 -122.435708517981 (37.7997688205881, -122.435708517981) 13 9 1 57 17
141424 95044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 6 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
142649 58321 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/1978 12:00:00 AM 12 3x3 Permit Number 17346 6002930 2119911 37.801036497901 -122.434017077007 (37.801036497901, -122.434017077007) 13 9 1 57 17
142881 95042 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     11 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
147341 127216 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 5 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999932.8876 2117120.87416 37.7932050075595 -122.444187729973 (37.7932050075595, -122.444187729973) 13 9 1 57 27
147848 101072 Undocumented 4 Ficus nitida :: Laurel Fig 53 1828 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004239 2118751 37.7979256371892 -122.429404607028 (37.7979256371892, -122.429404607028) 13 9 1 57 17
155737 117286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3500 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6002513 2120207 37.8018255621759 -122.435481260672 (37.8018255621759, -122.435481260672) 13 9 1 57 17
156467 109326 Undocumented 4 Ficus nitida :: Laurel Fig 53 1624 VALLEJO ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005582.1 2118270.7 37.7966828044962 -122.424722909098 (37.7966828044962, -122.424722909098) 13 9 1 57 17
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
171543 18697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 4 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
175212 13101 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6005049.00181 2119804.80205 37.800864933484 -122.426676850993 (37.800864933484, -122.426676850993) 13 9 1 57 17
176842 99613 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
179011 100052 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
182401 99616 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
183408 50980 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/06/2004 12:00:00 AM   3x3 Permit Number 47465 5999116.7 2119758.3 37.8004000774175 -122.447201682136 (37.8004000774175, -122.447201682136) 13 9 1 57 17
184158 127219 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 8 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999916.98549 2117117.82475 37.7931957274607 -122.444242532876 (37.7931957274607, -122.444242532876) 13 9 1 57 27
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
186277 13199 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
187091 100051 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
188786 99614 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
193344 13225 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2265 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001602.67751 2119341.9386 37.799398588794 -122.438569375951 (37.799398588794, -122.438569375951) 13 9 1 57 17

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