4,014 rows where qSpecies_id = 40 sorted by XCoord

View and edit SQL

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

Next page

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