4,014 rows where qSpecies_id = 40 sorted by PermitNotes descending

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)
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
188589 66638 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 952-956 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3   Permit Number 772673 6010185.68090669 2103671.40205978 37.7568554734734 -122.407763452505 (37.7568554734734, -122.407763452505) 2 4 7 28859 19
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
186883 67219 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 433 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1992 12:00:00 AM   3x3 Permit Number 772588 6003633.80184801 2108969.08064564 37.771032662095 -122.430800325407 (37.771032662095, -122.430800325407) 15 9 11 29492 10
147654 108702 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2382 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772586 6001605.97197 2118381.98302 37.7967629901963 -122.438489159966 (37.7967629901963, -122.438489159966) 13 9 1 57 17
69335 105728 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82-98X Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772582 6002862 2108710 37.7702775320686 -122.433451492357 (37.7702775320686, -122.433451492357) 15 5 5 29492 9
143336 105729 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82-98X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772582 6002862 2108710 37.7702775320686 -122.433451492357 (37.7702775320686, -122.433451492357) 15 5 5 29492 9
174147 108570 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772580 6010210.43031 2095090.88113 37.733296619935 -122.407073064382 (37.733296619935, -122.407073064382) 10 3 7 309 28
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
173417 108563 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 60 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772473 6010406.15109 2094405.89757 37.7314267509243 -122.406348153233 (37.7314267509243, -122.406348153233) 10 3 7 309 28
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
58230 107938 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3 3x3 Permit Number 772422 5994837.09376 2092346.05841 37.7248877040282 -122.460023781173 (37.7248877040282, -122.460023781173) 9 8 4 28861 40
185715 107937 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 613 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3 3x3 Permit Number 772422 5994837.09376 2092346.05841 37.7248877040282 -122.460023781173 (37.7248877040282, -122.460023781173) 9 8 4 28861 40
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
58746 67729 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1475 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2014 12:00:00 AM   3x3 Permit Number 771981 5991458.91301226 2105384.63302746 37.760493412232 -122.472651855625 (37.760493412232, -122.472651855625) 1 8 4 56 12
102699 109418 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 113 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2015 12:00:00 AM 3 3x3 Permit Number 771960 6000642.7 2102407.9 37.7528473542915 -122.440675914226 (37.7528473542915, -122.440675914226) 2 4 5 28862 22
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
19275 104234 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 298X Shrader St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2015 12:00:00 AM 3 6x6 Permit Number 771309 5997366.55609 2109687.30332 37.7726476392362 -122.452530652813 (37.7726476392362, -122.452530652813) 15 5 11 29492 16
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
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
99889 107954 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999967.5 2105076.1 37.7601351040878 -122.443202492583 (37.7601351040878, -122.443202492583) 2 4 5 28862 3
151241 107953 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999967.5 2105076.1 37.7601351040878 -122.443202492583 (37.7601351040878, -122.443202492583) 2 4 5 28862 3
157509 81336 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 105 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 771125 5999938.45094538 2105136.44437451 37.760299138392 -122.443307293466 (37.760299138392, -122.443307293466) 2 4 5 28862 3
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
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
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
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
122088 36536 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3759 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 770982 6008462.40683005 2097385.74676262 37.7394998450165 -122.413278711194 (37.7394998450165, -122.413278711194) 10 7 7 28859 2
116753 44108 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 701 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2014 12:00:00 AM 15 5x4 Permit Number 770977 6002352.33429439 2108791.12474046 37.770471351578 -122.435220225203 (37.770471351578, -122.435220225203) 15 5 5 29492 9
159382 105428 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 701 WALLER ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2014 12:00:00 AM 15 5x4 Permit Number 770977 6002351 2108797 37.7704874078199 -122.435225260833 (37.7704874078199, -122.435225260833) 15 5 5 29492 9
190473 69303 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 813 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2014 12:00:00 AM 6   Permit Number 770956 5999968.796 2111801.6454 37.7786018352438 -122.443681177953 (37.7786018352438, -122.443681177953) 15 5 11 29490 16
54467 59596 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1401 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2014 12:00:00 AM 0   Permit Number 770950 6000181.59670606 2113731.76941076 37.7839135947641 -122.443083674123 (37.7839135947641, -122.443083674123) 15 6 11 29490 31
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
38740 54202 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 121 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2015 12:00:00 AM 3 3x3 Permit Number 770897 5995407.75355189 2107023.99587375 37.7652224678553 -122.459113429254 (37.7652224678553, -122.459113429254) 15 5 11 56 12
187225 37725 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 75 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 770874 6002405.30455981 2096579.06253335 37.7369429497362 -122.434163852172 (37.7369429497362, -122.434163852172) 2 7 5 63 7
52276 104869 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 4 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
84450 104867 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 411 Holladay Ave 2 Front Yard : Yard Tree Private 2         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
80306 104072 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3020 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2013 12:00:00 AM 4 3x3 Permit Number 770362 6003851.5174 2119222.18029 37.7991974313859 -122.430779048741 (37.7991974313859, -122.430779048741) 13 9 1 57 17
160867 67082 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 131 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 770232 6007172.1618472 2097205.87642653 37.7389334378594 -122.417727080669 (37.7389334378594, -122.417727080669) 2 7 7 28859 2
14998 101958 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200X Ripley St 1 Sidewalk: Property side : Cutout Tree Private 2   06/12/2013 12:00:00 AM   3x3 Permit Number 770180 6009339 2099105 37.744269714821 -122.410369184032 (37.744269714821, -122.410369184032) 2 7 7 28859 2
192046 102844 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1471 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2013 12:00:00 AM   3x3 Permit Number 770146 6003321 2099676 37.7454983546222 -122.431218877952 (37.7454983546222, -122.431218877952) 2 7 5 63 22
177592 103235 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 116 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2013 12:00:00 AM 5   Permit Number 770114 5998278 2110273 37.7743079905046 -122.44942009354 (37.7743079905046, -122.44942009354) 15 5 11 29492 16
100631 65547 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 340X Juanita Way 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1990 12:00:00 AM     Permit Number 770105 5994976.11327418 2097601.99657825 37.7393272229464 -122.459923774546 (37.7393272229464, -122.459923774546) 9 7 4 59 40
65214 103112 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 539 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/2013 12:00:00 AM   3x3 Permit Number 770029 5994732.2 2092139.3 37.7243139617339 -122.460371410138 (37.7243139617339, -122.460371410138) 9 8 4 28861 24
54255 18943 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2799X Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2013 12:00:00 AM 3 3x3 Permit Number 769995 6001475.92192 2115618.2324 37.7891670515542 -122.438741019305 (37.7891670515542, -122.438741019305) 13 6 1 29490 27
117467 33992 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2034 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/12/2013 12:00:00 AM 3   Permit Number 769995 6001444.58 2115566.6422 37.7890236150982 -122.438845759727 (37.7890236150982, -122.438845759727) 13 6 1 29490 27
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
87888 83699 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2013 12:00:00 AM 4 3x3 Permit Number 769773 6002629 2105596 37.7617140260812 -122.434034805509 (37.7617140260812, -122.434034805509) 15 4 5 28862 3
79494 102172 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 9X Hattie St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809) 15 5 5 28862 3
187812 102171 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 9X Hattie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809) 15 5 5 28862 3
60974 82735 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 174 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2012 12:00:00 AM 5 4x4 Permit Number 769757 6003803.82611 2092820.0296 37.7267007672009 -122.429060604385 (37.7267007672009, -122.429060604385) 9 7 6 28861 5
131449 83237 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 100 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2012 12:00:00 AM 4 3x3 Permit Number 769756 6004043.10746 2093201.4009 37.7277614698948 -122.428260584571 (37.7277614698948, -122.428260584571) 9 7 6 28861 5
13306 84576 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3966 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003390.40048346 2101879.79659646 37.7515533971776 -122.431136171604 (37.7515533971776, -122.431136171604) 2 4 5 28862 22
86937 84667 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4045 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM     Permit Number 769743 6002887.32453677 2101799.94982156 37.7513056360956 -122.432870165781 (37.7513056360956, -122.432870165781) 2 4 5 28862 22
92904 84579 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3930 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003612.12595164 2101892.03490833 37.7515995627601 -122.43037029061 (37.7515995627601, -122.43037029061) 2 4 5 28862 22
99703 84660 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 816 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6001872.13741629 2101710.47895055 37.751002338731 -122.436374389271 (37.751002338731, -122.436374389271) 2 4 5 28862 22
109323 84674 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4045 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6002887.32453677 2101799.94982156 37.7513056360956 -122.432870165781 (37.7513056360956, -122.432870165781) 2 4 5 28862 22
138060 84575 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3972-3976 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003353.44622149 2101877.75687686 37.7515457024264 -122.431263818404 (37.7515457024264, -122.431263818404) 2 4 5 28862 22
144274 84578 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3934 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003587.48978851 2101890.6750959 37.7515944334967 -122.430455388545 (37.7515944334967, -122.430455388545) 2 4 5 28862 22
161430 84577 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3950 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003488.94513598 2101885.23584618 37.7515739158287 -122.430795780168 (37.7515739158287, -122.430795780168) 2 4 5 28862 22
152606 95275 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2013 12:00:00 AM 8 3x3 Permit Number 769625 6009044.4 2104856.4 37.7600452523756 -122.411794171614 (37.7600452523756, -122.411794171614) 2 4 7 28859 19
136396 51419 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2504 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/15/2012 12:00:00 AM     Permit Number 769443 6001518.65549528 2114626.94659681 37.7864476669078 -122.43852211335 (37.7864476669078, -122.43852211335) 13 6 1 29490 27
163775 100870 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 23 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2012 12:00:00 AM 1 3x3 Permit Number 769325 5995481.9791 2111446.40578 37.7773695144675 -122.459176965843 (37.7773695144675, -122.459176965843) 11 6 2 54 11
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
46867 50838 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 202 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/14/2012 12:00:00 AM     Permit Number 769141 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742) 1 5 11 56 12
30472 100032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
32309 88409 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009413.9789 2117291.03714 37.7942085637169 -122.41139444529 (37.7942085637169, -122.41139444529) 3 1 10 28857 21
42087 88407 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009407.88363 2117347.72867 37.7943638829406 -122.411419542685 (37.7943638829406, -122.411419542685) 3 1 10 28857 21
71695 100034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199@Washington Mason St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
87213 100031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334) 3 1 10 28857 21
143356 100035 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199@Washington Mason St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
151278 100037 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199@Washington Mason St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
153256 100033 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
178352 100036 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199@Washington Mason St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM     Permit Number 769129 6009411 2117399.5 37.7945062091547 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
180788 88408 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1199 Mason St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   08/02/2012 12:00:00 AM 5 3x3 Permit Number 769129 6009412.43491 2117319.72378 37.7942872436256 -122.411401815264 (37.7942872436256, -122.411401815264) 3 1 10 28857 21
192905 56621 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1120 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2012 12:00:00 AM     Permit Number 769116 6001921.73131937 2100826.98518644 37.7485792926383 -122.436139672143 (37.7485792926383, -122.436139672143) 2 4 5 28862 22
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
170697 54378 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2105 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2013 12:00:00 AM 3 0 Permit Number 769000 6003486.81156 2117545.01589 37.7945717009834 -122.431921232674 (37.7945717009834, -122.431921232674) 13 9 1 29490 27
105736 99740 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2770 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2012 12:00:00 AM   3x3 Permit Number 768985 6000934 2116568 37.7917440216798 -122.440684150501 (37.7917440216798, -122.440684150501) 13 6 1 29490 27
142216 99741 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2770 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2012 12:00:00 AM   3x3 Permit Number 768985 6000934 2116568 37.7917440216798 -122.440684150501 (37.7917440216798, -122.440684150501) 13 6 1 29490 27
104438 97562 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 182 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2012 12:00:00 AM     Permit Number 768967 5994515.7 2091119.6 37.7215016543215 -122.461045939781 (37.7215016543215, -122.461045939781) 9 8 6 28861 24
123875 103273 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 76-78 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/28/2013 12:00:00 AM   3x3 Permit Number 768961 6001664.7 2105412.5 37.7611554066092 -122.437356784873 (37.7611554066092, -122.437356784873) 15 4 5 28862 3
25135 99865 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2012 12:00:00 AM   3x3 Permit Number 768884 5986943.1 2112080 37.7786145879683 -122.488761926719 (37.7786145879683, -122.488761926719) 11 6 2 55 26
73001 98796 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950@Washington Clay St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.408747227007 (37.7940014192822, -122.408747227007) 3 1 10 28857 4
104181 98790 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950x CLAY ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
180637 63769 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013040.47104 2113998.55413 37.7853709106802 -122.398615140189 (37.7853709106802, -122.398615140189) 6 2 9 28855 6
138866 98832 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 333 Pacheco St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2012 12:00:00 AM     Permit Number 768672 5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
54843 98458 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200 Upper Ter 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999564.1 2106366.8 37.7636560350194 -122.444690429241 (37.7636560350194, -122.444690429241) 15 5 5 29492 9
56755 98460 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 UPPER TER 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999573.7 2106360.6 37.7636395591816 -122.444656780294 (37.7636395591816, -122.444656780294) 15 5 5 29492 9
58240 98456 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200 Upper Ter 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999564.1 2106366.8 37.7636560350194 -122.444690429241 (37.7636560350194, -122.444690429241) 15 5 5 29492 9
72160 98459 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 UPPER TER 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999573.7 2106360.6 37.7636395591816 -122.444656780294 (37.7636395591816, -122.444656780294) 15 5 5 29492 9
120670 98457 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 200 Upper Ter 2 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999564.1 2106366.8 37.7636560350194 -122.444690429241 (37.7636560350194, -122.444690429241) 15 5 5 29492 9
193760 98461 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 UPPER TER 3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/2012 12:00:00 AM   3x3 Permit Number 768632 5999573.7 2106360.6 37.7636395591816 -122.444656780294 (37.7636395591816, -122.444656780294) 15 5 5 29492 9
34649 98361 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 729 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2012 12:00:00 AM   2x3 Permit Number 768618 5994749.5 2089887.4 37.7181317785027 -122.460148537137 (37.7181317785027, -122.460148537137) 9 8 6 28861 24
172531 78395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 367 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/13/2011 12:00:00 AM 3 3x3 Permit Number 768554 5999771.76948 2091747.94137 37.7235279950084 -122.442922299331 (37.7235279950084, -122.442922299331) 9 7 6 28861 25
105701 98239 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2015 12:00:00 AM 3 3x3 Permit Number 768500 5993314 2106663 37.7641106803471 -122.466328924005 (37.7641106803471, -122.466328924005) 11 8 11 56 12
188328 214548 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2 DPW 06/17/2015 12:00:00 AM 1 Width 4ft Permit Number 768500 5993241.50872 2106665.18013 37.7641124834295 -122.46657980664 (37.7641124834295, -122.46657980664) 11 8 11 56 12
133360 115765 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 161 De Soto St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 768395 5993291.8 2092241 37.7245102406902 -122.465358011485 (37.7245102406902, -122.465358011485) 9 8 4 59 40
26554 62872 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 184 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/21/1986 12:00:00 AM     Permit Number 768360 6008262.44852126 2097761.23005493 37.7405196112884 -122.413996637761 (37.7405196112884, -122.413996637761) 2 7 7 28859 2

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