4,014 rows where qSpecies_id = 40 sorted by YCoord

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)
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                    
105181 178971 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 509 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010024.16897 2086365.71669 37.7093287026266 -122.407102219496 (37.7093287026266, -122.407102219496) 9 7 8 309 39
184571 179035 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 178 Desmond St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2018 12:00:00 AM 3 Width 3ft Permit Number 772137 6010379.06325 2086412.15144 37.7094760574448 -122.405878910409 (37.7094760574448, -122.405878910409) 9 7 8 309 39
122842 31023 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 330 Naylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 9   Permit Number 34788 6002794.80361 2086503.38224 37.7092994800486 -122.43209787574 (37.7092994800486, -122.43209787574) 9 7 6 28861 5
174366 31022 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 330 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 8   Permit Number 34788 6002783.56511 2086520.12567 37.7093448166924 -122.43213791266 (37.7093448166924, -122.43213791266) 9 7 6 28861 5
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
130405 31021 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 317 Naylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 7   Permit Number 34787 6002776.11429 2086581.19162 37.7095120680942 -122.432168021935 (37.7095120680942, -122.432168021935) 9 7 6 28861 5
40488 179162 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 171 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002093.74544 2086607.8879 37.7095466578231 -122.434528308849 (37.7095466578231, -122.434528308849) 9 7 6 28861 5
123056 179163 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 171 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002120.7512 2086617.73419 37.7095752265844 -122.43443567596 (37.7095752265844, -122.43443567596) 9 7 6 28861 5
69041 44741 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 271 Saint Charles Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/2001 12:00:00 AM 3   Permit Number 43859 5992054.55445 2086618.70048 37.7090013413078 -122.469225944836 (37.7090013413078, -122.469225944836) 9 8 4 64 24
153268 179161 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 233 Naylor St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   6002647.79999 2086739.65434 37.7099398962889 -122.432622809119 (37.7099398962889, -122.432622809119) 9 7 6 28861 5
114390 178972 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 856 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2018 12:00:00 AM 3 Width 3ft Permit Number 781438 6009124.92679 2086754.63916 37.7103462396574 -122.410237598787 (37.7103462396574, -122.410237598787) 9 7 8 309 39
55343 179153 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 412 Cordova St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 8ft   6001969.08964 2086773.82028 37.7099951946836 -122.434970999229 (37.7099951946836, -122.434970999229) 9 7 6 28861 5
180233 109051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 De Long St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772570 5995048.30925 2086814.92441 37.7097126663738 -122.45889335865 (37.7097126663738, -122.45889335865) 9 8 6 28861 25
150615 57927 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 559 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/1977 12:00:00 AM 3   Permit Number 16885 5999203.25613 2086855.58023 37.7100622571339 -122.444536089569 (37.7100622571339, -122.444536089569) 9 7 6 28861 5
91881 84197 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 551 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50697 6007614.52495 2086883.32703 37.7106148095844 -122.41546698201 (37.7106148095844, -122.41546698201) 9 7 8 309 39
90151 108899 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 16 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772775 6000547.04329 2086890.00633 37.7102333694046 -122.43989417722 (37.7102333694046, -122.43989417722) 9 7 6 28861 5
61096 179036 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 551 Sawyer St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007618.72078 2086894.99872 37.7106470934606 -122.415453306029 (37.7106470934606, -122.415453306029) 9 7 8 309 39
50426 178970 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008583.66239 2086910.82676 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132) 9 7 8 309 39
41071 178969 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008570.63643 2086915.27252 37.710756219889 -122.412164693966 (37.710756219889, -122.412164693966) 9 7 8 309 39
88047 178968 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008554.00356 2086922.92709 37.710776304465 -122.412222721805 (37.710776304465, -122.412222721805) 9 7 8 309 39
51918 84222 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
84241 84211 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
171735 84223 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
28068 178967 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 505 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5999517.95201 2086983.49864 37.7104314441356 -122.443457625269 (37.7104314441356, -122.443457625269) 9 7 6 28861 5
190502 37342 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 507 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 15   Permit Number 39850 5999504.92576 2086983.76919 37.7104314441222 -122.443502666028 (37.7104314441222, -122.443502666028) 9 7 6 28861 5
194103 109076 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.436420213894 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
49051 69397 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1137 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2015 12:00:00 AM 3   Permit Number 772744 6001523.93675849 2087030.79827901 37.7106755138649 -122.436527911504 (37.7106755138649, -122.436527911504) 9 7 6 28861 5
114270 31058 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 6   Permit Number 34809 6002732.75221 2087097.44922 37.7109271405403 -122.432354735598 (37.7109271405403, -122.432354735598) 9 7 6 28861 5
184269 31057 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 32 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 5   Permit Number 34809 6002747.27797 2087115.57732 37.7109777400017 -122.43230582505 (37.7109777400017, -122.43230582505) 9 7 6 28861 5
105221 178979 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Rae Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   5997616.63139 2087136.84676 37.7107438892848 -122.450040007061 (37.7107438892848, -122.450040007061) 9 7 6 28861 25
19987 109057 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 825 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772770 5997289.53523 2087142.99435 37.7107420465867 -122.451170962984 (37.7107420465867, -122.451170962984) 9 7 6 28861 25
73369 178978 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Rae Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 1ft   5997625.81626 2087145.61951 37.7107685028255 -122.450008894089 (37.7107685028255, -122.450008894089) 9 7 6 28861 25
109316 178977 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 190 Rae Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 1ft   5997636.8287 2087155.69902 37.7107968089962 -122.449971558745 (37.7107968089962, -122.449971558745) 9 7 6 28861 25
153903 69395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1075 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 4   Permit Number 33499 6002066.46838 2087158.9447 37.7110581906667 -122.434661960708 (37.7110581906667, -122.434661960708) 9 7 6 28861 5
171704 179021 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5642 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5998317.81093 2087173.37189 37.7108842770725 -122.447619209286 (37.7108842770725, -122.447619209286) 9 7 6 28861 25
17266 178980 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998273.42881 2087174.03892 37.7108835719974 -122.447772651587 (37.7108835719974, -122.447772651587) 9 7 6 28861 25
162470 109069 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1065 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772763 6002105.57012 2087176.80573 37.7111094529054 -122.434528092094 (37.7111094529054, -122.434528092094) 9 7 6 28861 5
80615 99888 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
97482 99892 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
118066 99890 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
140023 99887 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
182794 99891 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
192701 99889 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5646@ Whipple Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2012 12:00:00 AM   3x3 Permit Number 767758 5998305.1 2087181.1 37.7109047702551 -122.447663697002 (37.7109047702551, -122.447663697002) 9 7 6 28861 25
176378 178981 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5998261.9451 2087183.38329 37.7109085731488 -122.447813014086 (37.7109085731488, -122.447813014086) 9 7 6 28861 25
65700 179020 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5642 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5998346.4551 2087191.26802 37.7109350527871 -122.447521496121 (37.7109350527871, -122.447521496121) 9 7 6 28861 25
2810 178982 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998252.81183 2087192.10261 37.7109319923872 -122.447845208002 (37.7109319923872, -122.447845208002) 9 7 6 28861 25
53530 178983 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 38 Whipple Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   5998242.85384 2087202.59008 37.7109602194148 -122.447880379569 (37.7109602194148, -122.447880379569) 9 7 6 28861 25
180965 51976 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 163 Rae Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/2005 12:00:00 AM     Permit Number 48195 5997753.64161846 2087210.79293758 37.7109547676767 -122.449571795733 (37.7109547676767, -122.449571795733) 9 7 6 28861 25
120095 95016 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 83 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6010516.6 2087234.5 37.7117417518759 -122.405461434977 (37.7117417518759, -122.405461434977) 9 7 8 309 39
181121 69417 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 149 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 7   Permit Number 33522 6001453.45984 2087297.44526 37.7114036625088 -122.436790570551 (37.7114036625088, -122.436790570551) 9 7 6 28861 5
117218 179159 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 113 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001727.04807 2087313.14686 37.7114623208022 -122.435846103423 (37.7114623208022, -122.435846103423) 9 7 6 28861 5
160903 179160 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 113 Seville St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6001754.98626 2087320.62379 37.7114844378149 -122.435750076526 (37.7114844378149, -122.435750076526) 9 7 6 28861 5
138253 69416 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 148 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 2   Permit Number 33521 6001460.48124 2087339.32549 37.7115190554232 -122.436769298869 (37.7115190554232, -122.436769298869) 9 7 6 28861 5
147674 179158 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 148 Seville St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6001439.08808 2087342.21986 37.7115257868681 -122.436843446185 (37.7115257868681, -122.436843446185) 9 7 6 28861 5
23854 86960 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 208 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.7111251955331 -122.464305827668 (37.7111251955331, -122.464305827668) 9 8 4 64 24
132760 37340 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 131 Brunswick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 10   Permit Number 39848 6000626.60293 2087367.00998 37.7115476439893 -122.439653377918 (37.7115476439893, -122.439653377918) 9 7 6 28861 5
59928 69413 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 73 Seville St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 4   Permit Number 33518 6001961.1999 2087395.46496 37.711701646594 -122.43504269857 (37.711701646594, -122.43504269857) 9 7 6 28861 5
55464 86961 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 212 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/26/2007 12:00:00 AM 4 3x3 Permit Number 49929 5993495.99209 2087406.23034 37.7112468999028 -122.464301303157 (37.7112468999028, -122.464301303157) 9 8 4 64 24
99972 65739 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 130 Concord St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/19/1990 12:00:00 AM 12   Permit Number 28675 5999799.15568 2087425.51821 37.7116611636025 -122.442517443427 (37.7116611636025, -122.442517443427) 9 7 6 28861 5
65703 95006 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 195 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 3 3x3   6009968.4 2087457.4 37.7123231225616 -122.407371876718 (37.7123231225616, -122.407371876718) 9 7 8 309 39
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
157837 179155 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1219 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6001609.50582 2087555.82392 37.7121219807101 -122.436269715579 (37.7121219807101, -122.436269715579) 9 7 6 28861 5
127811 179156 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1219 Athens St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6001622.38743 2087558.00892 37.7121287121383 -122.436225349332 (37.7121287121383, -122.436225349332) 9 7 6 28861 5
30819 179157 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1219 Athens St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001634.55542 2087559.68334 37.7121340010651 -122.436183413036 (37.7121340010651, -122.436183413036) 9 7 6 28861 5
56894 44392 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1201X ATHENS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2001 12:00:00 AM     Permit Number 43750 6001492 2087581 37.7121844315022 -122.436677650137 (37.7121844315022, -122.436677650137) 9 7 6 28861 5
112553 44394 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1201X ATHENS ST 3 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2001 12:00:00 AM     Permit Number 43750 6001492 2087581 37.7121844315022 -122.436677650137 (37.7121844315022, -122.436677650137) 9 7 6 28861 5
168072 44393 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1201X ATHENS ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2001 12:00:00 AM     Permit Number 43750 6001492 2087581 37.7121844315022 -122.436677650137 (37.7121844315022, -122.436677650137) 9 7 6 28861 5
69638 48506 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 45 Cordova St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 5   Permit Number 45843 6001715.61599 2087735.00145 37.7126199910876 -122.43591578109 (37.7126199910876, -122.43591578109) 9 7 6 28861 5
146129 213304 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 252 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994495.39623 2087783.34428 37.7123399215102 -122.460874450904 (37.7123399215102, -122.460874450904) 9 8 6 28861 24
190897 49743 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 114 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 8   Permit Number 46542 6010621.23603 2087831.01483 37.7133855110935 -122.405141759495 (37.7133855110935, -122.405141759495) 9 7 8 309 39
111226 179154 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 374 Rolph St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001871.82658 2087846.75593 37.712935716983 -122.435383858181 (37.712935716983, -122.435383858181) 9 7 6 28861 5
119437 179029 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 226 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009880.60922 2087872.96636 37.7134592690157 -122.407704592601 (37.7134592690157, -122.407704592601) 9 7 8 309 39
54909 49745 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34@ LELAND Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46544 6008556.33506 2087877.23988 37.7133967814171 -122.412282069889 (37.7133967814171, -122.412282069889) 9 7 8 309 39
70587 213305 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 223 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995012.40881 2087891.7837 37.7126674060525 -122.459095358975 (37.7126674060525, -122.459095358975) 9 8 6 28861 24
5538 178975 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Dichiera Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 1ft   5998617.79966 2087941.66603 37.7130109785485 -122.44663762445 (37.7130109785485, -122.44663762445) 9 7 6 28861 25
57134 55259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/1972 12:00:00 AM 8   Permit Number 11181 6008604.18987 2088002.78931 37.7137441994136 -122.412125533875 (37.7137441994136, -122.412125533875) 9 7 8 309 39
91652 31006 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM 8   Permit Number 34780 6000669.33593 2088075.86611 37.7134964370899 -122.439556465166 (37.7134964370899, -122.439556465166) 9 7 6 28861 5
97062 178976 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 221 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 1ft   5998101.98654 2088087.6608 37.7133823688881 -122.448430945451 (37.7133823688881, -122.448430945451) 9 7 6 28861 25
101048 213357 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 25 Ralston St 1 : Tree Private 2     5 Width 3ft   5992244.95419 2088111.94244 37.7131124256698 -122.468676481533 (37.7131124256698, -122.468676481533) 9 8 6 64 24
50832 178974 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 126 Foote Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   5998851.51754 2088138.53591 37.7135648862728 -122.445843970916 (37.7135648862728, -122.445843970916) 9 7 6 28861 25
155603 179016 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 70 Curtis St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   6000604.90599 2088146.70208 37.7136872696207 -122.439784232863 (37.7136872696207, -122.439784232863) 9 7 6 28861 5
194485 181039 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 4ft   6000909.27168 2088176.54977 37.7137865448937 -122.438734374192 (37.7137865448937, -122.438734374192) 9 7 6 28861 5
136312 41410 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 531 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/2000 12:00:00 AM 5   Permit Number 42023 6007957.48629 2088255.06014 37.7144005749922 -122.414378624292 (37.7144005749922, -122.414378624292) 9 7 8 309 39
100942 179028 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 535 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007927.50802 2088265.22189 37.7144267929389 -122.41448296003 (37.7144267929389, -122.41448296003) 9 7 8 309 39
123356 49698 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 87@ TUCKER Alpha St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM 4 3x3 Permit Number 50825 6011117.29096 2088288.9421 37.7146706063491 -122.403459407649 (37.7146706063491, -122.403459407649) 10 7 8 309 39
140140 49699 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 87@ TUCKER Alpha St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM 5 3x3 Permit Number 50825 6011128.67682 2088300.86402 37.7147039774881 -122.403420891467 (37.7147039774881, -122.403420891467) 10 7 8 309 39
64309 179034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 88 Alpha St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6011090.19294 2088313.27178 37.7147358971229 -122.403554780747 (37.7147358971229, -122.403554780747) 9 7 8 309 39
44806 179033 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 88 Alpha St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6011104.28456 2088327.78048 37.7147765222032 -122.40350709418 (37.7147765222032, -122.40350709418) 9 7 8 309 39
148524 48689 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 455 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2002 12:00:00 AM 2   Permit Number 45968 6008469.24313 2088342.73235 37.714670039767 -122.412615977341 (37.714670039767, -122.412615977341) 9 7 8 309 39
183342 179032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 33 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6010961.71988 2088492.90138 37.7152219465056 -122.404011472662 (37.7152219465056, -122.404011472662) 9 7 8 309 39
123650 86870 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Randolph St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM   3x3 Permit Number 49803 5992443 2088555 37.7143403939216 -122.468024182233 (37.7143403939216, -122.468024182233) 9 8 6 64 24
151710 86869 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Randolph St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM   3x3 Permit Number 49803 5992443 2088555 37.7143403939216 -122.468024182233 (37.7143403939216, -122.468024182233) 9 8 6 64 24
187026 86868 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 602 Randolph St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM   3x3 Permit Number 49803 5992443 2088555 37.7143403939216 -122.468024182233 (37.7143403939216, -122.468024182233) 9 8 6 64 24
78426 179017 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Pope St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000125.72789 2088561.86941 37.714799938735 -122.441470215282 (37.714799938735, -122.441470215282) 9 7 6 28861 5
156838 179018 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Pope St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000118.27452 2088586.12335 37.7148661099687 -122.441497716551 (37.7148661099687, -122.441497716551) 9 7 6 28861 5
73858 179019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Pope St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000109.84085 2088611.05825 37.7149340951081 -122.441528655027 (37.7149340951081, -122.441528655027) 9 7 6 28861 5
59491 213344 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 117 Vernon St 3 : Tree Private 2     6 Width 3ft   5992432.58541 2088617.02757 37.7145101052228 -122.468064688059 (37.7145101052228, -122.468064688059) 9 8 6 64 24
93157 213343 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 117 Vernon St 1 : Tree Private 2     6 Width 3ft   5992434.92339 2088648.0359 37.7145953816368 -122.468058861341 (37.7145953816368, -122.468058861341) 9 8 6 64 24
75745 28262 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3624 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2003 12:00:00 AM 12 3x3   6012194.48746 2088681.14992 37.7158076389797 -122.399763675165 (37.7158076389797, -122.399763675165) 10 7 8 309 39

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