trees

4,014 rows where qSpecies_id = 40 sorted by SiteOrder

✎ View and edit SQL

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)
3941 92078 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1151 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083 2115004 37.7877979108835 -122.419297592258 (37.7877979108835, -122.419297592258) 13 9 10 28858 21
6813 256911 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
9283 94134 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 18 Nebraska St   Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291 2097948 37.7410901551317 -122.410453476975 (37.7410901551317, -122.410453476975) 10 7 7 28859 2
9573 108831 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 774658 6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
16209 262261 - 12 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 290 Green St   : Tree Private 2 FUF 06/18/2020 12:00:00 AM 3   Permit Number 785454 6011550.34746 2119418.71162 37.8001702361868 -122.404152146942 (37.8001702361868, -122.404152146942) 3 1 10 308 23
16351 92032 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4232 21st St   Sidewalk: Curb side : Cutout Tree Private 2   06/12/2009 12:00:00 AM   3x3 Permit Number 52175 6001386.1 2103403.9 37.75562443672 -122.43817644846 (37.75562443672, -122.43817644846) 2 4 5 28862 3
18199 254500 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1715 Octavia St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/22/2018 12:00:00 AM 3 3x3 Permit Number 769839 6004851.87126 2115244.61878 37.7883326812086 -122.427034026756 (37.7883326812086, -122.427034026756) 13 9 11 28858 27
23777 88528 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 771 14th St   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51478 6003493 2107743 37.7676581652647 -122.431199833454 (37.7676581652647, -122.431199833454) 15 9 5 28862 3
28106 87131 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 De Montfort Ave   Sidewalk: Curb side : Cutout Tree Private 2   01/11/2008 12:00:00 AM   3x3 Permit Number 50083 5995245.2 2091924 37.7237522965749 -122.458582475556 (37.7237522965749, -122.458582475556) 9 8 4 28861 24
28784 87823 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 451 47th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 4 2x3 Permit Number 50716 5981265.58269 2112596.97795 37.7797010943021 -122.508440678428 (37.7797010943021, -122.508440678428) 11 6 2 55 26
31944 94585 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2010 12:00:00 AM   3x3 Permit Number 53761 5999865 2118793 37.7977923490456 -122.444542858 (37.7977923490456, -122.444542858) 13 9 1 57 17
33621 105147 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Mirabel Ave   Sidewalk: Curb side : Cutout Landscaping Private 2   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.416220575031 (37.7464458666696, -122.416220575031) 2 7 7 28859 2
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
44543 88377 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 458 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51355 5991270.95609 2112280.85053 37.7794176810179 -122.473805014236 (37.7794176810179, -122.473805014236) 11 6 2 54 26
46800 89366 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51946 6006673.6 2095420.1 37.7340020224619 -122.419324232824 (37.7340020224619, -122.419324232824) 2 7 7 28859 2
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
50704 95400 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 227 Valley St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767274 6004277.7 2099178.3 37.7441859544543 -122.427875301427 (37.7441859544543, -122.427875301427) 2 7 5 63 22
53915 104995 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2220 Castro St   Sidewalk: Curb side : Cutout Tree Private 2   12/03/2013 12:00:00 AM   3X3 Permit Number 771144 6002644.3 2099031.5 37.7436903366208 -122.433512747881 (37.7436903366208, -122.433512747881) 2 7 5 63 22
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
74016 94875 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 44 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53944 6011618 2095077 37.7333371742049 -122.402205704408 (37.7333371742049, -122.402205704408) 10 3 8 58 1
75509 94697 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2443 Clement St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM   3x3 Permit Number 53831 5987960 2113267 37.7819330460656 -122.485331246452 (37.7819330460656, -122.485331246452) 11 6 2 55 26
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
91237 94954 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1725 Monterey Blvd   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53987 5992718.5 2095334 37.7329697745731 -122.467564641429 (37.7329697745731, -122.467564641429) 9 8 4 59 40
100494 94874 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53943 6011600 2095102 37.7334048142135 -122.402269692882 (37.7334048142135, -122.402269692882) 10 3 8 58 1
101013 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
102643 98306 Section 143 10 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 155 Terrace Dr   Sidewalk: Curb side : Cutout Tree Private 2           5993776 2096639 37.7366139805049 -122.464003314893 (37.7366139805049, -122.464003314893) 1 8 4 59 40
107195 91489 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 430 Hamilton St   Sidewalk: Curb side : Cutout Tree Private 2   04/24/2009 12:00:00 AM   3x3 Permit Number 52114 6009410.2 2092292.9 37.7255691435472 -122.409642274765 (37.7255691435472, -122.409642274765) 9 3 7 309 28
110119 108498 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 762 10th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773796 5992905.3087 2110276.51424 37.774008838889 -122.468005315635 (37.774008838889, -122.468005315635) 11 6 2 54 11
115286 100355 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 591 Waller St   Sidewalk: Curb side : Cutout Landscaping Private 2   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.7706563827164 -122.43333123962 (37.7706563827164, -122.43333123962) 15 5 5 29492 9
116091 91235 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 470 Ramsell St   Sidewalk: Curb side : Cutout Tree Private 2   02/06/2009 12:00:00 AM   3x3 Permit Number 52048 5993008 2090300 37.719164355766 -122.466198071834 (37.719164355766, -122.466198071834) 9 8 6 64 24
123585 85007 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 850 Bryant St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49366 6010976 2110190 37.7747982776561 -122.40548930108 (37.7747982776561, -122.40548930108) 14 2 9 28853 34
133498 92826 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 755 14th Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/19/2009 12:00:00 AM 5 3x3 Permit Number 53040 5991610.35704 2110282.05129 37.7739491753353 -122.472485133979 (37.7739491753353, -122.472485133979) 11 6 2 54 26
134237 94878 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 56 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53946 6011673 2095004 37.73313980136 -122.402010422944 (37.73313980136, -122.402010422944) 10 3 8 58 1
134413 89318 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 450 Frederick St   Sidewalk: Curb side : Cutout Tree Private 2   10/30/2008 12:00:00 AM   3x3 Permit Number 51911 5997633 2107488 37.766624178434 -122.451450341927 (37.766624178434, -122.451450341927) 15 5 11 29492 9
135057 114039 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1328 TREAT WAY   Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6008689 2100921 37.7492195885474 -122.412745111821 (37.7492195885474, -122.412745111821) 2 4 7 28859 19
135218 94946 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
146951 94958 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 201 San Benito Way   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53990 5992929.1 2095285.9 37.7328498609093 -122.46683305318 (37.7328498609093, -122.46683305318) 9 8 4 59 40
156500 106553 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 213 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2   05/08/2014 12:00:00 AM   2.5x4 Permit Number 771194 5998005.6 2096224.8 37.7357195377121 -122.449350002926 (37.7357195377121, -122.449350002926) 9 7 4 59 40
163788 105008 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1957 - 1959 15TH ST   Sidewalk: Curb side : Cutout Tree Private 2   02/28/2014 12:00:00 AM 11 3x3 Permit Number 771758 6004438.4 2107144.3 37.7660678085542 -122.427887146988 (37.7660678085542, -122.427887146988) 8 4 5 28862 3
165984 108830 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 46 Ney St   Sidewalk: Curb side : Cutout Tree Port 6 FUF     3x3   6003763.1265 2093992.42876 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217) 9 7 6 28861 5
183304 89365 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Benton Ave   Sidewalk: Curb side : Cutout Tree Private 2   11/25/2008 12:00:00 AM   3x3 Permit Number 51945 6006769 2095411.9 37.733984879603 -122.418993823503 (37.733984879603, -122.418993823503) 2 7 7 28859 2
185997 94869 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53939 6012921 2095173 37.7336734157115 -122.397707572671 (37.7336734157115, -122.397707572671) 10 3 8 58 1
186213 109055 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 320 Hanover St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772693 5999569.6 2086544.4 37.7092287229218 -122.443247602414 (37.7092287229218, -122.443247602414) 9 7 6 28861 5
187819 106551 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 203 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2       2.5X4 Permit Number 58742 5998066.5 2096226.6 37.7357279634759 -122.449139578572 (37.7357279634759, -122.449139578572) 9 7 4 59 40
189602 94876 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 48 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53945 6011636 2095053 37.7332722799512 -122.402141786329 (37.7332722799512, -122.402141786329) 10 3 8 58 1
193634 108648 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 196 Lippard Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774607 6001751.75522 2094959.06379 37.7324576925005 -122.436307555189 (37.7324576925005, -122.436307555189) 9 7 5 63 40
78 237365 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
538 214628 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1442 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5992754.41359 2105631.11276 37.7612450859223 -122.468189283707 (37.7612450859223, -122.468189283707) 1 8 4 56 12
708 214648 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 8 Hillway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996112.80548 2106851.31964 37.7647888500462 -122.456662349289 (37.7647888500462, -122.456662349289) 15 5 11 29492 12
738 55617 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/14/1983 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.7873577334097 -122.45030520092 (37.7873577334097, -122.45030520092) 11 6 1 54 31
739 38480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2515 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1998 12:00:00 AM 9   Permit Number 40479 5999797.20513 2119471.52027 37.7996515161494 -122.444826245059 (37.7996515161494, -122.444826245059) 13 9 1 57 17
995 238517 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 258 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001824.70148 2096208.99046 37.7358938476086 -122.436144777258 (37.7358938476086, -122.436144777258) 2 7 5 63 7
1021 213351 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 752 Head St 1 : Tree Private 2     3 Width 3ft   5993534.80603 2090819.23886 37.7206204409725 -122.464414798499 (37.7206204409725, -122.464414798499) 9 8 6 64 24
1029 65280 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 435 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/1989 12:00:00 AM 1   Permit Number 28085 6011091.92612 2112217.73363 37.7803724445696 -122.405231107147 (37.7803724445696, -122.405231107147) 14 2 9 28853 34
1131 238080 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 690X Jarboe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6008716.17738 2096910.13853 37.7382081728556 -122.412367671831 (37.7382081728556, -122.412367671831) 10 7 7 28859 2
1334 73744 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 35 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5995854.8721 2112478.16796 37.7802238906314 -122.45796169979 (37.7802238906314, -122.45796169979) 11 6 2 54 16
1339 73360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 236 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003402.60575 2092794.29016 37.72660737262 -122.430445774353 (37.72660737262, -122.430445774353) 9 7 6 28861 5
1360 238060 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2x Montezuma St 1 Median : Cutout Tree DPW 1     3 Width 3ft   6007260.48935 2099759.47356 37.7459500163869 -122.417602623671 (37.7459500163869, -122.417602623671) 2 7 7 28859 2
1497 213565 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 125 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994666.93375 2099556.29013 37.744675439634 -122.461134390953 (37.744675439634, -122.461134390953) 1 8 4 59 40
1688 213308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 219 Tara St 1 : Tree Private 2     3 Width 3ft   5997858.51511 2090428.83634 37.7197967734736 -122.44944104777 (37.7197967734736, -122.44944104777) 9 8 6 28861 24
1705 31912 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2256 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1995 12:00:00 AM 9   Permit Number 35336 5991754.81336 2100091.67364 37.745977450207 -122.471242839091 (37.745977450207, -122.471242839091) 1 8 4 29491 40
2029 239485 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 679 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007429.64294 2095798.50666 37.7350835962332 -122.416737151198 (37.7350835962332, -122.416737151198) 2 7 7 28859 2
2070 213331 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 151 Byxbee St 1 : Tree Private 2     6 Width 2ft   5991924.78555 2089552.62516 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591) 9 8 6 64 24
2081 238328 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 230 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002043.41709 2104477.94194 37.7586108592227 -122.435980092511 (37.7586108592227, -122.435980092511) 2 4 5 28862 3
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
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
2431 237346 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6008796.40457 2097657.68171 37.7402652650326 -122.412143102127 (37.7402652650326, -122.412143102127) 10 7 7 28859 2
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
2473 88167 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 189 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 1 3x3 Permit Number 51184 6010014.6058 2087504.2072 37.7124542316575 -122.407215472312 (37.7124542316575, -122.407215472312) 9 7 8 309 39
2569 49452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1483 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2003 12:00:00 AM 4   Permit Number 46386 6011771.85534 2101466.16969 37.7508890570981 -122.402122808245 (37.7508890570981, -122.402122808245) 10 3 8 28856 29
2608 94102 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Holyoke St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2010 12:00:00 AM 5 3x3 Permit Number 53477 6009512.58757 2093214.72689 37.7281060226502 -122.409353352981 (37.7281060226502, -122.409353352981) 10 3 7 309 28
2670 262494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Miraloma Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994945 2097531 37.7391304944698 -122.4600262078 (37.7391304944698, -122.4600262078) 9 7 4 59 40
2717 237342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007526 2096627 37.7373638762388 -122.416462675749 (37.7373638762388, -122.416462675749) 2 7 7 28859 2
2743 238264 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4076 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002529.27285 2104747.10596 37.7593775078944 -122.434319028496 (37.7593775078944, -122.434319028496) 2 4 5 28862 3
2772 108460 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 944 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 773734 6010189.19593 2103716.38941 37.7569791954421 -122.407754468243 (37.7569791954421, -122.407754468243) 2 4 7 28859 19
2806 91889 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1112 Irving St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/18/2009 12:00:00 AM 3 3x3   5992343.82828 2106622.674723 37.7639439315835 -122.469681499547 (37.7639439315835, -122.469681499547) 11 8 11 56 12
2989 261184 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 380 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006769 2095411 37.733982408401 -122.41899375969 (37.733982408401, -122.41899375969) 2 7 7 28859 2
3019 70395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   16     6005551.02847 2092833.80452 37.7268373382622 -122.423021551618 (37.7268373382622, -122.423021551618) 9 7 7 309 5
3032 4178 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3814 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2016 05:09:00 AM 3 4x4   6005035.97287 2100499.61266 37.7478568435292 -122.425347365702 (37.7478568435292, -122.425347365702) 2 4 5 63 22
3057 70502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 78 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11 6x7   6004601.41978 2093074.4867 37.727444566791 -122.426321455564 (37.727444566791, -122.426321455564) 9 7 6 28861 5
3215 48784 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 268 Onondaga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2002 12:00:00 AM 7   Permit Number 46039 6000083.90087 2091529.02554 37.7229446929396 -122.441827615748 (37.7229446929396, -122.441827615748) 9 7 6 28861 25
3266 48394 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2520 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/23/2002 12:00:00 AM 14   Permit Number 45776 6002671.64848 2116160.62189 37.7907242663701 -122.434642758376 (37.7907242663701, -122.434642758376) 13 9 1 29490 27
3267 50930 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2287 Cecelia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2004 12:00:00 AM     Permit Number 47426 5991460.4982554 2099833.27531374 37.7452509262864 -122.472241698597 (37.7452509262864, -122.472241698597) 1 8 4 29491 40
3312 102758 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1392 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5993422.3 2106025.2 37.7623656970292 -122.465908002531 (37.7623656970292, -122.465908002531) 1 8 11 56 12
3431 80385 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011729.10125 2092748.56003 37.7269499630479 -122.401657992736 (37.7269499630479, -122.401657992736) 10 3 8 58 1
3444 213580 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 45 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5995131.70851 2099996.48556 37.74591084191 -122.459559177141 (37.74591084191, -122.459559177141) 1 8 4 59 40
3465 123273 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 578 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868) 11 6 2 54 11
3608 71395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714) 10 3 8 58 1
3679 238393 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 84 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6001698 2105474 37.7613261636576 -122.437246018283 (37.7613261636576, -122.437246018283) 15 4 5 28862 3
3725 73662 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 828 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6011416.18719 2109390.39573 37.7726273509159 -122.403910314231 (37.7726273509159, -122.403910314231) 14 2 9 28853 34
3765 37799 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 425 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM 6   Permit Number 40126 6010088.32636 2092511.70686 37.7262079180568 -122.407313455853 (37.7262079180568, -122.407313455853) 10 3 7 309 28
3776 261180 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340 Benton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2095420 37.7340017140914 -122.419326300122 (37.7340017140914, -122.419326300122) 2 7 7 28859 2
3806 237447 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 837 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001298.41812 2101483.90892 37.7503476157529 -122.438342133081 (37.7503476157529, -122.438342133081) 2 4 5 28862 22
3847 239502 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 81 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008343.66274 2098237.09844 37.7418308021463 -122.413749481054 (37.7418308021463, -122.413749481054) 2 7 7 28859 2
3851 68224 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1500 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/2012 12:00:00 AM 1   Permit Number 769229 5990833.38749 2113424.07906 37.7825313172153 -122.47540222512 (37.7825313172153, -122.47540222512) 11 6 2 54 26
3867 33659 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 545 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/03/1996 12:00:00 AM 8   Permit Number 37747 6004792.43502 2110705.04365 37.7758647708832 -122.426916230306 (37.7758647708832, -122.426916230306) 7 9 11 28852 10
3894 178998 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001820.55644 2089152.21762 37.7165173138053 -122.435654403046 (37.7165173138053, -122.435654403046) 9 7 6 28861 5
4321 214786 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Fairfield Way 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993908.89145 2093024.31926 37.7266966141529 -122.463281639244 (37.7266966141529, -122.463281639244) 9 8 4 59 40
4327 213589 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1971 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993451.57313 2102072.49612 37.7515142846609 -122.465519594973 (37.7515142846609, -122.465519594973) 1 8 4 29491 12
4459 78281 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34 Wanda St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6000546.67018 2091525.62315 37.7229617089923 -122.440227677765 (37.7229617089923, -122.440227677765) 9 7 6 28861 25

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