trees
4,014 rows where qSpecies_id = 40 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40172 | 65973 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2245 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1990 12:00:00 AM | 9 | Permit Number 28997 | 5988612.04832 | 2110519.74016 | 37.7744278044001 | -122.48287408378 | (37.7744278044001, -122.48287408378) | 11 | 6 | 2 | 55 | 26 | ||
42287 | 99851 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 191 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988632 | 2114084 | 37.7842154230523 | -122.483066364805 | (37.7842154230523, -122.483066364805) | 11 | 6 | 2 | 55 | 26 | |||
29041 | 92309 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2550 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | 1 | 8 | 3 | 29491 | 35 | ||
117067 | 93676 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2550 25th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | 1 | 8 | 3 | 29491 | 35 | ||
118573 | 92308 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2550 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52753 | 5988779.9 | 2097863.1 | 37.7396858417248 | -122.481366393427 | (37.7396858417248, -122.481366393427) | 1 | 8 | 3 | 29491 | 35 | ||
179158 | 52549 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1820 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49862 | 5988786.85487252 | 2102928.5390264 | 37.7535946042411 | -122.481713268594 | (37.7535946042411, -122.481713268594) | 1 | 8 | 3 | 56 | 35 | ||
63274 | 45510 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 4 | Permit Number 44276 | 5988794.07528 | 2095754.20535 | 37.7338961880477 | -122.481162998885 | (37.7338961880477, -122.481162998885) | 1 | 8 | 4 | 64 | 35 | |
25542 | 45508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988794.65729 | 2095738.11606 | 37.7338520448427 | -122.481159808989 | (37.7338520448427, -122.481159808989) | 1 | 8 | 4 | 64 | 35 | |
148417 | 27310 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2140 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2014 12:00:00 AM | 5 | 5 | 5988795.04874 | 2114709.3 | 37.7859418063725 | -122.4825481157 | (37.7859418063725, -122.4825481157) | 11 | 6 | 1 | 55 | 33 | ||
92016 | 45509 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2929 25th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2001 12:00:00 AM | 3 | Permit Number 44276 | 5988795.25848 | 2095722.94476 | 37.7338104233161 | -122.481156619984 | (37.7338104233161, -122.481156619984) | 1 | 8 | 4 | 64 | 35 | |
106407 | 68952 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 747 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 3 | Permit Number 32941 | 5988797.45218 | 2110217.11495 | 37.7736076654938 | -122.482210568345 | (37.7736076654938, -122.482210568345) | 11 | 6 | 2 | 55 | 26 | |
17390 | 72335 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988805.09626 | 2110041.06897 | 37.7731247366343 | -122.482171226619 | (37.7731247366343, -122.482171226619) | 11 | 6 | 2 | 55 | 26 | |||
10496 | 68949 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 726 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 4 | Permit Number 32938 | 5988844.72891 | 2110346.33242 | 37.7739652106004 | -122.482056500957 | (37.7739652106004, -122.482056500957) | 11 | 6 | 2 | 55 | 26 | |
2470 | 68950 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 734 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 32939 | 5988846.075 | 2110312.98983 | 37.7738737393837 | -122.482049401575 | (37.7738737393837, -122.482049401575) | 11 | 6 | 2 | 55 | 26 | |
88542 | 120326 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 738 23rd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 5988846.16685 | 2110288.25768 | 37.773805837099 | -122.482047271679 | (37.773805837099, -122.482047271679) | 11 | 6 | 2 | 55 | 26 | |||
139935 | 120325 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 742 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5988848.2342 | 2110250.1988 | 37.7737014582029 | -122.482037331833 | (37.7737014582029, -122.482037331833) | 11 | 6 | 2 | 55 | 26 | |||
9062 | 68953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 750 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 3 | 3x3 | Permit Number 32942 | 5988850.38114 | 2110206.21118 | 37.7735808052559 | -122.482026682299 | (37.7735808052559, -122.482026682299) | 11 | 6 | 2 | 55 | 26 |
190142 | 68954 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 754 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 3 | Permit Number 32943 | 5988851.01728 | 2110187.80327 | 37.7735302992339 | -122.482023133058 | (37.7735302992339, -122.482023133058) | 11 | 6 | 2 | 55 | 26 | |
73305 | 86200 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.37374 | 2099150.307919 | 37.7432254380566 | -122.481147807758 | (37.7432254380566, -122.481147807758) | 1 | 8 | 3 | 29491 | 35 | ||
190120 | 86213 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2487 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988895.867106 | 2098417.748537 | 37.7412155036968 | -122.481006033613 | (37.7412155036968, -122.481006033613) | 1 | 8 | 3 | 29491 | 35 | ||
122792 | 86214 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2491 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 04:31:00 PM | 3 | 3x3 | 5988896.775501 | 2098391.645558 | 37.7411438845393 | -122.481000981974 | (37.7411438845393, -122.481000981974) | 1 | 8 | 3 | 29491 | 35 | ||
66760 | 86217 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2621 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2013 12:00:00 AM | 3 | 3x3 | 5988925.7787 | 2097455.0086 | 37.7385738093546 | -122.480832143468 | (37.7385738093546, -122.480832143468) | 1 | 8 | 3 | 29491 | 35 | ||
25941 | 86219 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2643 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988933.146151 | 2097346.520353 | 37.7382763570454 | -122.480798730272 | (37.7382763570454, -122.480798730272) | 1 | 8 | 3 | 29491 | 35 | ||
37152 | 86220 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988937.695499 | 2097215.793619 | 37.7379176798007 | -122.480773433176 | (37.7379176798007, -122.480773433176) | 1 | 8 | 3 | 29491 | 35 | ||
107224 | 86109 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2548 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988950.841471 | 2097988.149582 | 37.7400391325334 | -122.480784510326 | (37.7400391325334, -122.480784510326) | 1 | 8 | 3 | 29491 | 35 | ||
167898 | 86101 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2600X 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988963.56832 | 2097622.4377 | 37.7390357226089 | -122.48071374038 | (37.7390357226089, -122.48071374038) | 1 | 8 | 3 | 29491 | 35 | ||
171595 | 120701 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 70 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 5988982.8407 | 2114887.49266 | 37.7864419959893 | -122.481911472455 | (37.7864419959893, -122.481911472455) | 11 | 6 | 1 | 55 | 33 | |||
38275 | 95921 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.25498 | 2113497.8107 | 37.7826268110713 | -122.481780533127 | (37.7826268110713, -122.481780533127) | 11 | 6 | 2 | 55 | 26 |
10066 | 91129 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2100X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52620 | 5989031.08283 | 2111274.17492 | 37.776523645314 | -122.481479844539 | (37.776523645314, -122.481479844539) | 11 | 6 | 2 | 55 | 26 | |
191604 | 50298 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2909 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 6 | Permit Number 47009 | 5989047.46422 | 2095832.25514 | 37.7341252202046 | -122.48029267727 | (37.7341252202046, -122.48029267727) | 1 | 8 | 4 | 64 | 35 | |
165049 | 50297 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2909 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 1 | Permit Number 47009 | 5989047.82914 | 2095849.49826 | 37.7341725865769 | -122.480292677287 | (37.7341725865769, -122.480292677287) | 1 | 8 | 4 | 64 | 35 | |
20594 | 50299 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 4 | Permit Number 47010 | 5989048.57412 | 2095810.27611 | 37.7340649359436 | -122.480287231884 | (37.7340649359436, -122.480287231884) | 1 | 8 | 4 | 64 | 35 | |
94407 | 50300 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.15693 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | 1 | 8 | 4 | 64 | 35 | |
47361 | 120691 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 346 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5989055.07358 | 2112994.27839 | 37.7812479638107 | -122.481522861281 | (37.7812479638107, -122.481522861281) | 11 | 6 | 2 | 55 | 26 | |||
29854 | 179040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 4 | : | Tree | Private 2 | 1 | Width 2ft | 5989055.54597 | 2095618.79902 | 37.7335395942586 | -122.480249118621 | (37.7335395942586, -122.480249118621) | 1 | 8 | 4 | 64 | 35 | |||
98877 | 179037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 1 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.57419 | 2095644.93656 | 37.7336113628596 | -122.480250933435 | (37.7336113628596, -122.480250933435) | 1 | 8 | 4 | 64 | 35 | |||
47943 | 179039 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 3 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.72291 | 2095627.1595 | 37.7335625602678 | -122.480249118597 | (37.7335625602678, -122.480249118597) | 1 | 8 | 4 | 64 | 35 | |||
56724 | 179038 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2945 24th Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 5989055.89984 | 2095635.51997 | 37.7335855262488 | -122.480249118607 | (37.7335855262488, -122.480249118607) | 1 | 8 | 4 | 64 | 35 | |||
14867 | 59187 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 559 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/1980 12:00:00 AM | 13 | Permit Number 18503 | 5989063.8728 | 2111532.21619 | 37.7772340613072 | -122.481385317518 | (37.7772340613072, -122.481385317518) | 11 | 6 | 2 | 55 | 26 | |
70859 | 96362 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1432 23rd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2011 12:00:00 AM | Permit Number 767816 | 5989066.4 | 2105558.5 | 37.7608320226819 | -122.480939093689 | (37.7608320226819, -122.480939093689) | 1 | 8 | 3 | 56 | 35 | ||||
62757 | 82798 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49857 | 5989069.54890365 | 2102231.72490285 | 37.7516977731236 | -122.480684653834 | (37.7516977731236, -122.480684653834) | 1 | 8 | 3 | 29491 | 35 | ||
193299 | 82189 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1925 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49857 | 5989069.54890365 | 2102231.72490285 | 37.7516977731236 | -122.480684653834 | (37.7516977731236, -122.480684653834) | 1 | 8 | 3 | 29491 | 35 | ||
64510 | 92305 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52751 | 5989074.6 | 2101678 | 37.7501776851115 | -122.480626655297 | (37.7501776851115, -122.480626655297) | 1 | 8 | 3 | 29491 | 35 | |
133322 | 92306 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52751 | 5989074.6 | 2101678 | 37.7501776851115 | -122.480626655297 | (37.7501776851115, -122.480626655297) | 1 | 8 | 3 | 29491 | 35 | |
106552 | 12805 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2099 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2003 12:00:00 AM | 5 | 3X3 | 5989075.33471 | 2114664.85982 | 37.7858360879126 | -122.481575158504 | (37.7858360879126, -122.481575158504) | 11 | 6 | 2 | 55 | 26 | ||
69896 | 120426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 667 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989088.89156 | 2110781.28528 | 37.7751736683191 | -122.481243768191 | (37.7751736683191, -122.481243768191) | 11 | 6 | 2 | 55 | 26 | |||
150848 | 62035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 526 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1985 12:00:00 AM | 3 | Permit Number 22108 | 5989101.14075 | 2111731.85837 | 37.777784389853 | -122.481271020374 | (37.777784389853, -122.481271020374) | 11 | 6 | 2 | 55 | 26 | ||
181579 | 67942 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 586 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 4 | Permit Number 31656 | 5989115.53927 | 2111342.90988 | 37.7767172826693 | -122.481192723227 | (37.7767172826693, -122.481192723227) | 11 | 6 | 2 | 55 | 26 | |
43061 | 95924 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 528 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767621 | 5989176.7 | 2111724.7 | 37.7777691275223 | -122.481009113569 | (37.7777691275223, -122.481009113569) | 11 | 6 | 2 | 55 | 26 | |
22245 | 94798 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495@Ulloa 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | 1 | 8 | 3 | 29491 | 35 | ||
162714 | 94797 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | 1 | 8 | 3 | 29491 | 35 | ||
191775 | 94799 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495@Ulloa 23rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | 1 | 8 | 3 | 29491 | 35 | ||
115317 | 51291 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2020 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2004 12:00:00 AM | 1 | Permit Number 47663 | 5989189.38676 | 2113364.18569 | 37.7822714342333 | -122.481085302679 | (37.7822714342333, -122.481085302679) | 11 | 6 | 2 | 55 | 26 | ||
165978 | 90579 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2050X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989191.56818 | 2110598.34198 | 37.774677325483 | -122.480875193908 | (37.774677325483, -122.480875193908) | 11 | 6 | 2 | 55 | 26 | ||
143085 | 120705 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989295.69695 | 2115021.44108 | 37.78682797013 | -122.480838891203 | (37.78682797013, -122.480838891203) | 11 | 6 | 1 | 55 | 33 | |||
37141 | 120704 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5989296.74954 | 2115035.23836 | 37.7868659147395 | -122.480836260043 | (37.7868659147395, -122.480836260043) | 11 | 6 | 1 | 55 | 33 | |||
38213 | 120706 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5989297.54688 | 2115010.04334 | 37.7867967826872 | -122.480831656181 | (37.7867967826872, -122.480831656181) | 11 | 6 | 1 | 55 | 33 | |||
135920 | 40949 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 543 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 8 | Permit Number 45163 | 5989370.51415 | 2111642.49878 | 37.7775546903632 | -122.480332633054 | (37.7775546903632, -122.480332633054) | 11 | 6 | 2 | 55 | 26 | |
1941 | 40950 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 543 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42451 | 5989371.25434 | 2111628.81002 | 37.7775171478462 | -122.480329070335 | (37.7775171478462, -122.480329070335) | 11 | 6 | 2 | 55 | 26 | |
93975 | 120727 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 474 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989397.82148 | 2112121.21454 | 37.7788706974235 | -122.48027321576 | (37.7788706974235, -122.48027321576) | 11 | 6 | 2 | 55 | 26 | |||
38866 | 88580 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 474 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.7788295288058 | -122.480271570948 | (37.7788295288058, -122.480271570948) | 11 | 6 | 2 | 55 | 26 | ||
2289 | 72333 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 522 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5989411.86479 | 2111751.27895 | 37.7778557732807 | -122.48019755247 | (37.7778557732807, -122.48019755247) | 11 | 6 | 2 | 55 | 26 | |||
46568 | 67432 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 11 | 3x9 | Permit Number 30934 | 5989425.04603 | 2110106.51713 | 37.7733404786579 | -122.480031555496 | (37.7733404786579, -122.480031555496) | 11 | 6 | 2 | 55 | 26 |
167568 | 68941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 730 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 6 | Permit Number 32928 | 5989462.36102 | 2110347.52769 | 37.7740043951593 | -122.479920119491 | (37.7740043951593, -122.479920119491) | 11 | 6 | 2 | 55 | 26 | |
60429 | 120737 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 734 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5989462.46052 | 2110322.27124 | 37.773935053699 | -122.4799179267 | (37.773935053699, -122.4799179267) | 11 | 6 | 2 | 55 | 26 | |||
28261 | 105980 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 750 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2014 12:00:00 AM | 1 | 3x4 | Permit Number 772437 | 5989466.79489 | 2110227.47578 | 37.7736750233383 | -122.479895995237 | (37.7736750233383, -122.479895995237) | 11 | 6 | 2 | 55 | 26 | |
151908 | 67434 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 772 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1992 12:00:00 AM | 10 | Permit Number 30936 | 5989473.46135 | 2110070.59902 | 37.7732446703113 | -122.479861453207 | (37.7732446703113, -122.479861453207) | 11 | 6 | 2 | 55 | 26 | ||
160172 | 47259 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1487 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2014 12:00:00 AM | 1 | 3x3 | Permit Number 770986 | 5989591.7291 | 2105266.36 | 37.7600604072843 | -122.479100863475 | (37.7600604072843, -122.479100863475) | 1 | 8 | 3 | 56 | 35 |
178728 | 251678 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989656 | 2102823 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | 1 | 8 | 3 | 56 | 35 | ||||
18326 | 97050 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2011 12:00:00 AM | 4x4 | Permit Number 768113 | 5989656.1 | 2102823.3 | 37.7533561549786 | -122.478699565369 | (37.7533561549786, -122.478699565369) | 1 | 8 | 3 | 56 | 35 | ||
154034 | 68939 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 491 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/2010 12:00:00 AM | 3 | Permit Number 53187 | 5989664.28625 | 2112063.79605 | 37.7787285224831 | -122.479347217114 | (37.7787285224831, -122.479347217114) | 11 | 6 | 2 | 55 | 26 | |
21374 | 12771 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1831 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1992 12:00:00 AM | 6 | 3X3 | 5989737.94266 | 2114686.68849 | 37.785934529444 | -122.479284343127 | (37.785934529444, -122.479284343127) | 11 | 6 | 2 | 55 | 26 | ||
96447 | 103499 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989789.80565 | 2110619.51755 | 37.7747702228862 | -122.478807342211 | (37.7747702228862, -122.478807342211) | 11 | 6 | 2 | 55 | 26 | |
192680 | 103498 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.14229 | 37.7747702228876 | -122.478745931564 | (37.7747702228876, -122.478745931564) | 11 | 6 | 2 | 55 | 26 | |
72031 | 103497 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989824.39083 | 2110619.3957 | 37.7747718964667 | -122.47868769738 | (37.7747718964667, -122.47868769738) | 11 | 6 | 2 | 55 | 26 | |
11117 | 12763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 5989830.30372 | 2114748.73304 | 37.7861102501687 | -122.478969342589 | (37.7861102501687, -122.478969342589) | 11 | 6 | 1 | 55 | 33 | |||
25179 | 105960 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1937 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2014 12:00:00 AM | 3x3 | Permit Number 772672 | 5989989.1 | 2102175.5 | 37.7515967965888 | -122.477500650678 | (37.7515967965888, -122.477500650678) | 1 | 8 | 3 | 29491 | 35 | ||
102209 | 12753 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1730 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2000 12:00:00 AM | 12 | 3X3 | 5990048.72352 | 2114754.53717 | 37.7861388679375 | -122.478214101082 | (37.7861388679375, -122.478214101082) | 11 | 6 | 1 | 55 | 33 | ||
9801 | 72374 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 766 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990089.45799 | 2110137.86742 | 37.7734651388758 | -122.477735579303 | (37.7734651388758, -122.477735579303) | 11 | 6 | 2 | 55 | 26 | |||
180226 | 179042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2913 20th Ave | 1 | : | Tree | Private 2 | 5 | Width 2ft | 5990217.22266 | 2095888.70199 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | 1 | 8 | 4 | 64 | 35 | |||
59147 | 179041 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2908 20th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5990269.38069 | 2095895.56899 | 37.7343699931708 | -122.476072795627 | (37.7343699931708, -122.476072795627) | 1 | 8 | 4 | 64 | 35 | |||
85139 | 45478 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3008 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 4 | Permit Number 44261 | 5990292.27426 | 2095193.28859 | 37.732443037405 | -122.475942374151 | (37.732443037405, -122.475942374151) | 1 | 8 | 4 | 64 | 35 | |
101896 | 45479 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3008 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 5 | Permit Number 44261 | 5990293.0566 | 2095176.19647 | 37.7323961521473 | -122.475938421626 | (37.7323961521473, -122.475938421626) | 1 | 8 | 4 | 64 | 35 | |
97841 | 45547 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990293.17037 | 2095939.46173 | 37.7344918908758 | -122.475993752415 | (37.7344918908758, -122.475993752415) | 1 | 8 | 4 | 64 | 35 | ||
103857 | 45480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3014 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 4 | Permit Number 44262 | 5990294.42195 | 2095159.66129 | 37.7323508299087 | -122.475932494187 | (37.7323508299087, -122.475932494187) | 1 | 8 | 4 | 64 | 35 | |
15304 | 45481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3014 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44262 | 5990295.67943 | 2095138.00578 | 37.7322914422893 | -122.475926565872 | (37.7322914422893, -122.475926565872) | 1 | 8 | 4 | 64 | 35 | |
176541 | 45482 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3020 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 2 | Permit Number 44263 | 5990295.80642 | 2095116.94306 | 37.7322336167725 | -122.475924589162 | (37.7322336167725, -122.475924589162) | 1 | 8 | 4 | 64 | 35 | |
26361 | 45483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3020 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44263 | 5990296.64858 | 2095102.69561 | 37.7321945457224 | -122.475920637525 | (37.7321945457224, -122.475920637525) | 1 | 8 | 4 | 64 | 35 | |
59438 | 45485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3036 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2001 12:00:00 AM | 3 | Permit Number 44264 | 5990298.1598 | 2095038.91467 | 37.7320195070769 | -122.475910756673 | (37.7320195070769, -122.475910756673) | 1 | 8 | 4 | 64 | 35 | |
103698 | 50296 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3052 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 5 | Permit Number 47008 | 5990299.81493 | 2094981.96074 | 37.7318632220065 | -122.475900876741 | (37.7318632220065, -122.475900876741) | 1 | 8 | 4 | 64 | 35 | |
111402 | 50295 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3052 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2004 12:00:00 AM | 4 | Permit Number 47008 | 5990301.1325 | 2094963.14956 | 37.7318116476733 | -122.475894948395 | (37.7318116476733, -122.475894948395) | 1 | 8 | 4 | 64 | 35 | |
172130 | 45548 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990306.88184 | 2095939.17218 | 37.7344918908736 | -122.475946326684 | (37.7344918908736, -122.475946326684) | 1 | 8 | 4 | 64 | 35 | ||
80364 | 45549 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 4 | Permit Number 44299 | 5990323.96119 | 2095935.96592 | 37.7344840775814 | -122.475887044262 | (37.7344840775814, -122.475887044262) | 1 | 8 | 4 | 64 | 35 | ||
111713 | 45550 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 345 Sloat Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44299 | 5990341.11287 | 2095936.17267 | 37.7344856397084 | -122.475827760949 | (37.7344856397084, -122.475827760949) | 1 | 8 | 4 | 64 | 35 | ||
15075 | 70171 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 775 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5990355.07569 | 2110118.24586 | 37.7734266747554 | -122.476815345127 | (37.7734266747554, -122.476815345127) | 11 | 6 | 2 | 55 | 26 | |||
49719 | 91420 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 770 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52101 | 5990400.34087 | 2110139.21584 | 37.7734868781795 | -122.476660300393 | (37.7734868781795, -122.476660300393) | 11 | 6 | 2 | 55 | 26 | ||
157807 | 94825 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1255 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53905 | 5990438 | 2106842.5 | 37.764437175462 | -122.476289179121 | (37.764437175462, -122.476289179121) | 11 | 8 | 3 | 56 | 12 | |
86841 | 214660 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1215 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990499.97268 | 2103786.33445 | 37.7560493544197 | -122.475851631658 | (37.7560493544197, -122.475851631658) | 1 | 8 | 4 | 56 | 12 | |||
169096 | 214661 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1207 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990516.2149 | 2103788.47288 | 37.7560561676768 | -122.475795617379 | (37.7560561676768, -122.475795617379) | 1 | 8 | 4 | 56 | 12 | |||
28058 | 114800 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1587 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 770932 | 5990525.1 | 2104605.1 | 37.7582989241527 | -122.475824523864 | (37.7582989241527, -122.475824523864) | 1 | 8 | 4 | 56 | 12 |
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) );