Street_Tree_List

Data source: data.sfgov.org

4,048 rows where qSpecies = 18 sorted by qCareAssistant descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant ▲ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
97679 86443 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2450 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 12/29/2006 12:00:00 AM 3 3x3   5987997.37774 2098622.10748 37.741724349066 -122.484127634313 (37.741724349066, -122.484127634313)
143691 91888 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1104 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Cleary Bros. Landscape 8 02/18/2009 12:00:00 AM 3 3x3   5992367.653968 2106623.490856 37.763947549515 -122.469599153768 (37.763947549515, -122.469599153768)
101061 113808 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4101x 25TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
105585 113819 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4101x 25TH ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   7 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
119959 100985 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2190 Powell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW 4 03/23/2016 02:34:00 PM 3 3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169)
101459 98790 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950x CLAY ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
120907 78998 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450X Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 6 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
73 65479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1051 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
1252 61532 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 772896 5991195.07104 2113068.5037599998 37.781575964268896 -122.474125016615 (37.7815759642689, -122.474125016615)
4845 38140 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 423 Burrows St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1998 12:00:00 AM 2   Permit Number 40297 6010109.0 2093148.0 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302)
4846 76677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 423 Burrows St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1994 12:00:00 AM 3     6010109.0 2093148.0 37.7279562025478 -122.407286823302 (37.7279562025478, -122.407286823302)
4918 43245 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 150 Felton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 9   Permit Number 43034 6010460.0 2093774.0 37.729694705520004 -122.40611748494 (37.72969470552, -122.40611748494)
7256 71253 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1436 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1995 12:00:00 AM 10 3x3   6007270.15279 2117448.61656 37.7945207624857 -122.418823519012 (37.7945207624857, -122.418823519012)
8180 21666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1765 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2014 12:00:00 AM 3 4X4 Permit Number 774582 6004178.5577 2114595.027 37.7865109691436 -122.42931724201799 (37.7865109691436, -122.429317242018)
9780 65693 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3779 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2016 12:00:00 AM 3 4x4 Permit Number 779357 6005288.42845233 2101344.00549356 37.7501896116955 -122.424534439725 (37.7501896116955, -122.424534439725)
10315 47259 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1487 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/11/2014 12:00:00 AM 1 3x3 Permit Number 770986 5989591.7291 2105266.36 37.7600604072843 -122.479100863475 (37.7600604072843, -122.479100863475)
10329 109051 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 De Long St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772570 5995048.30925 2086814.9244099997 37.7097126663738 -122.45889335865 (37.7097126663738, -122.45889335865)
10582 69800 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 367 Delano Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2000 12:00:00 AM 3 3x3   5999779.7835 2091764.7216900003 37.7235745268131 -122.442895800812 (37.7235745268131, -122.442895800812)
10595 78395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 367 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/13/2011 12:00:00 AM 3 3x3 Permit Number 768554 5999771.76948 2091747.9413700001 37.723527995008396 -122.442922299331 (37.7235279950084, -122.442922299331)
10801 83237 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2012 12:00:00 AM 4 3x3 Permit Number 769756 6004043.10746 2093201.4009 37.727761469894794 -122.42826058457099 (37.7277614698948, -122.428260584571)
11888 108379 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Bertita St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/19/2014 12:00:00 AM 3 3x3 Permit Number 773806 6000690.090969999 2090159.58738 37.7192190489897 -122.439634019098 (37.7192190489897, -122.439634019098)
11960 108570 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772580 6010210.43031 2095090.8811299999 37.733296619935004 -122.407073064382 (37.733296619935, -122.407073064382)
12339 62181 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/17/2016 12:00:00 AM 3   Permit Number 778619 6000227.937530001 2091768.58709 37.7236106804803 -122.44134689306802 (37.7236106804803, -122.441346893068)
12716 108567 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450 Hamilton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773758 6009500.29517 2092233.5680799999 37.725411278805296 -122.409326636833 (37.7254112788053, -122.409326636833)
12718 109057 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 825 Huron Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/22/2015 12:00:00 AM 3 3x3 Permit Number 772770 5997289.5352300005 2087142.99435 37.7107420465867 -122.45117096298401 (37.7107420465867, -122.451170962984)
12764 83412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/01/2009 12:00:00 AM 5 3x3 Permit Number 52320 6003991.38049 2093029.1643599998 37.727285619722295 -122.428427134505 (37.7272856197223, -122.428427134505)
13060 109069 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1065 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/23/2015 12:00:00 AM 3 3x3 Permit Number 772763 6002105.570119999 2087176.80573 37.7111094529054 -122.434528092094 (37.7111094529054, -122.434528092094)
13168 95747 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 2 3x3 Permit Number 767492 6002627.86341 2092385.97592 37.7254423161963 -122.433094867748 (37.7254423161963, -122.433094867748)
13234 82735 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 174 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 5 4x4 Permit Number 769757 6003803.82611 2092820.0296 37.726700767200896 -122.429060604385 (37.7267007672009, -122.429060604385)
13327 48822 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 512 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/27/2017 12:00:00 AM 3   Permit Number 46801 6003066.62090041 2102150.20608679 37.7522775247752 -122.43227515114401 (37.7522775247752, -122.432275151144)
13385 108724 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 566 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.762601916479504 -122.40246509469401 (37.7626019164795, -122.402465094694)
14693 67488 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1117 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3   Permit Number 773109 6012239.52235 2103185.1315 37.7556350439301 -122.400626303061 (37.7556350439301, -122.400626303061)
18366 92323 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2595 27th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM   3x3 Permit Number 52755 5987970.2 2097662.1 37.739086838436606 -122.484151218827 (37.7390868384366, -122.484151218827)
19061 50930 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2287 Cecelia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM     Permit Number 47426 5991460.4982554 2099833.27531374 37.745250926286396 -122.47224169859699 (37.7452509262864, -122.472241698597)
19226 30599 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1995 12:00:00 AM 8 5x7 Permit Number 34566 6004311.30995 2108965.65965 37.771061631219 -122.428456559416 (37.771061631219, -122.428456559416)
19771 31446 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 239 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1995 12:00:00 AM 7   Permit Number 35021 6002088.5838 2104465.22029 37.758578494425294 -122.435822975577 (37.7585784944253, -122.435822975577)
20479 73501 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2011 12:00:00 AM   3x3 Permit Number 767446 6001962.16426713 2101054.16463509 37.74920537061129 -122.436016109621 (37.7492053706113, -122.436016109621)
20662 84576 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3966 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 4 3x3 Permit Number 769743 6003390.40048346 2101879.79659646 37.7515533971776 -122.43113617160401 (37.7515533971776, -122.431136171604)
22957 108702 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2382 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772586 6001605.971969999 2118381.98302 37.79676299019629 -122.438489159966 (37.7967629901963, -122.438489159966)
23606 31666 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4066 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35467 6002585.751619999 2104753.963 37.7593995412727 -122.434124187708 (37.7593995412727, -122.434124187708)
23887 83255 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 790 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1     5983253.61867 2110435.38712 37.773882958787205 -122.501403365431 (37.7738829587872, -122.501403365431)
24421 47030 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/02/2002 12:00:00 AM     Permit Number 45025 6005541.3 2109365.2 37.772228199123504 -122.424230399247 (37.7722281991235, -122.424230399247)
24585 49743 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 114 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 8   Permit Number 46542 6010621.23603 2087831.01483 37.7133855110935 -122.405141759495 (37.7133855110935, -122.405141759495)
24726 72266 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 359 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 12     6002393.10905 2091502.19798 37.7230023412585 -122.43384325116999 (37.7230023412585, -122.43384325117)
24823 47425 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 754 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45336 5984176.15569 2110679.3098400002 37.7746068364777 -122.49823022658701 (37.7746068364777, -122.498230226587)
25042 70403 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 215 Oxford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1994 12:00:00 AM 18     6006511.50188 2092924.3025099998 37.7271399781258 -122.419707630826 (37.7271399781258, -122.419707630826)
25098 95928 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 758 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767625 5987895.384330001 2110807.039 37.775174921567796 -122.485374215588 (37.7751749215678, -122.485374215588)
25348 50499 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 608 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 5   Permit Number 47136 6002721.49496 2090080.38174 37.719116979545795 -122.432606577246 (37.7191169795458, -122.432606577246)
25642 43023 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 519 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 9   Permit Number 42885 6004020.081809999 2110698.29349 37.7758025350991 -122.429587516272 (37.7758025350991, -122.429587516272)
26028 78318 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Colby St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 5 3x6   6008900.368419999 2091273.5690900001 37.722741693447105 -122.411332749116 (37.7227416934471, -122.411332749116)
26032 48415 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2475 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2002 12:00:00 AM 8   Permit Number 45793 6001140.73556 2118622.32163 37.797396422056295 -122.440116223893 (37.7973964220563, -122.440116223893)
26265 96024 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 668 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/2011 12:00:00 AM 0 3x3 Permit Number 767665 6007552.0 2113596.0 37.783958288790004 -122.41757510581999 (37.78395828879, -122.41757510582)
27276 84392 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2101 Jerrold Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/29/2006 12:00:00 AM 3     6012504.257680001 2099077.65785 37.744371568599796 -122.39942241122499 (37.7443715685998, -122.399422411225)
27317 45508 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2929 25th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2001 12:00:00 AM 3   Permit Number 44276 5988794.6572900005 2095738.11606 37.7338520448427 -122.48115980898899 (37.7338520448427, -122.481159808989)
27626 67962 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 859 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 3   Permit Number 31683 5986944.37754 2110090.6261299998 37.773152403641205 -122.488611249777 (37.7731524036412, -122.488611249777)
28327 95833 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/29/2011 12:00:00 AM 2 3x3 Permit Number 767565 6010212.70231 2112022.42286 37.7797869733249 -122.408258986859 (37.7797869733249, -122.408258986859)
28805 64858 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 2   Permit Number 25874 5995885.498430001 2112555.8177099996 37.7804388557843 -122.45786137054199 (37.7804388557843, -122.457861370542)
28886 40657 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 7   Permit Number 47919 6004684.27364 2093706.73058 37.729185251382 -122.4260800191 (37.729185251382, -122.4260800191)
29621 66088 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2229 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/08/1990 12:00:00 AM 12   Permit Number 29132 6007569.63634 2120087.67012 37.8017838015514 -122.41797443666401 (37.8017838015514, -122.417974436664)
30074 47440 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 859 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45351 5982914.18523 2109947.95579 37.7725246733221 -122.50254141771099 (37.7725246733221, -122.502541417711)
30548 45544 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 79 Riverton Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 3   Permit Number 44297 5987024.26021 2095319.08797 37.732598422284205 -122.48724975796301 (37.7325984222842, -122.487249757963)
30633 95739 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 612 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 6 3x3 Permit Number 767485 6003904.92985 2091757.6805900002 37.7237895151604 -122.428635396826 (37.7237895151604, -122.428635396826)
30704 43671 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM 12   Permit Number 43314 5995229.94076 2114692.20799 37.786267125837796 -122.460284069366 (37.7862671258378, -122.460284069366)
31915 64862 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 74 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 10   Permit Number 25878 5995911.37415 2112317.03505 37.779784708505105 -122.45775457163401 (37.7797847085051, -122.457754571634)
32051 68219 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 263 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/27/1993 12:00:00 AM 4   Permit Number 32006 5990848.54158 2113649.76494 37.7831518664143 -122.475366281729 (37.7831518664143, -122.475366281729)
32635 64938 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2810 Gough St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/23/1989 12:00:00 AM 11   Permit Number 25967 6004818.34721 2119246.7576099997 37.799319643836895 -122.427435236266 (37.7993196438369, -122.427435236266)
32843 31989 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 147 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/30/1995 12:00:00 AM 6   Permit Number 35389 5994568.75053 2114560.8648099997 37.78586843793 -122.462562068449 (37.78586843793, -122.462562068449)
33510 40676 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 191 Maynard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 6   Permit Number 47920 6004632.23626 2093798.9275599997 37.7294354625595 -122.426266478225 (37.7294354625595, -122.426266478225)
33753 47399 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 627 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 3   Permit Number 45310 5994686.98675 2111235.69119 37.776745212476705 -122.461911800485 (37.7767452124767, -122.461911800485)
33962 41935 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 639 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 15   Permit Number 42294 5994689.00791 2111165.50547 37.7765526175284 -122.461899718162 (37.7765526175284, -122.461899718162)
34283 71395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1988 12:00:00 AM 7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714)
34490 68541 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 6   Permit Number 32425 5982517.9924800005 2112299.68917 37.778958557712606 -122.504086094205 (37.7789585577126, -122.504086094205)
34912 41947 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 690 08th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 9   Permit Number 42304 5993509.40357 2110837.2069 37.7755832179423 -122.46595641563499 (37.7755832179423, -122.465956415635)
35428 48426 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3130 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2002 12:00:00 AM 9   Permit Number 45804 6001942.5823800005 2118964.92546 37.798382739120704 -122.437366176208 (37.7983827391207, -122.437366176208)
36253 46768 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 39 Cotter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/25/2002 12:00:00 AM 8   Permit Number 44864 6002453.43832 2093143.7233900002 37.7275130240946 -122.433751972693 (37.7275130240946, -122.433751972693)
36774 69416 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 148 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 2   Permit Number 33521 6001460.481240001 2087339.3254900002 37.7115190554232 -122.436769298869 (37.7115190554232, -122.436769298869)
37021 52927 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 155 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 7   Permit Number 48911 6000347.40158 2092558.92243 37.7257875650324 -122.44099059964199 (37.7257875650324, -122.440990599642)
37098 37620 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 630 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1998 12:00:00 AM 3   Permit Number 40044 5990677.73899 2111070.74016 37.7760606748146 -122.47576878804199 (37.7760606748146, -122.475768788042)
37645 40655 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 7   Permit Number 47919 6004683.61058 2093747.9444400002 37.729298378011705 -122.42608524416401 (37.7292983780117, -122.426085244164)
37977 72335 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 775 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 1     5988805.09626 2110041.06897 37.773124736634294 -122.482171226619 (37.7731247366343, -122.482171226619)
38249 64864 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 14 Parsons St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 15   Permit Number 25882 5996577.342130001 2110690.66447 37.775357357934205 -122.45533313851999 (37.7753573579342, -122.45533313852)
38896 62496 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2003 12:00:00 AM 13   Permit Number 22668 6000676.96581 2092453.0598400002 37.7255156559072 -122.439843736499 (37.7255156559072, -122.439843736499)
38950 32086 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3928 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 5   Permit Number 35459 6003448.93768 2104799.28963 37.759572949446394 -122.431142104137 (37.7595729494464, -122.431142104137)
39307 66567 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/15/1991 12:00:00 AM 16   Permit Number 29756 6005047.11996 2093219.91873 37.7278690746777 -122.424791009107 (37.7278690746777, -122.424791009107)
39453 68949 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 726 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 4   Permit Number 32938 5988844.72891 2110346.33242 37.7739652106004 -122.48205650095699 (37.7739652106004, -122.482056500957)
39708 70395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1994 12:00:00 AM 16     6005551.028469999 2092833.80452 37.72683733826221 -122.423021551618 (37.7268373382622, -122.423021551618)
40185 62775 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Delano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/1986 12:00:00 AM 6   Permit Number 23130 6000616.95925 2093064.6604900002 37.727191555121706 -122.440095009781 (37.7271915551217, -122.440095009781)
40285 30587 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 68 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/26/1995 12:00:00 AM 11   Permit Number 34557 6002888.52611 2108685.82804 37.7702126667237 -122.43335801118499 (37.7702126667237, -122.433358011185)
40751 68941 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 730 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32928 5989462.36102 2110347.5276900004 37.774004395159295 -122.479920119491 (37.7740043951593, -122.479920119491)
41204 78480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 2     6001855.9620900005 2090141.3500299999 37.719235261989 -122.43560274687799 (37.719235261989, -122.435602746878)
41435 44490 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 49 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/26/2001 12:00:00 AM 8   Permit Number 43795 6005454.79601 2093298.7109 37.728108438248704 -122.423387260924 (37.7281084382487, -122.423387260924)
41715 52943 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 428 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 4   Permit Number 48930 6000112.39427 2091327.92801 37.722394148651 -122.44171469507299 (37.722394148651, -122.441714695073)
41835 36752 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2579 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1999 12:00:00 AM 5   Permit Number 41197 6002410.05116 2116400.74901 37.7913687394284 -122.435565056287 (37.7913687394284, -122.435565056287)
41917 45509 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2929 25th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/2001 12:00:00 AM 3   Permit Number 44276 5988795.25848 2095722.9447599999 37.7338104233161 -122.48115661998399 (37.7338104233161, -122.481156619984)
42627 68954 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 754 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 3   Permit Number 32943 5988851.01728 2110187.80327 37.7735302992339 -122.482023133058 (37.7735302992339, -122.482023133058)
42740 96157 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 539 Holly Park Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/08/2011 12:00:00 AM   3x3 Permit Number 767790 6006264.3 2096224.2 37.736186842338206 -122.42079637851499 (37.7361868423382, -122.420796378515)
43236 50295 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3052 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 4   Permit Number 47008 5990301.1325 2094963.1495599998 37.7318116476733 -122.47589494839501 (37.7318116476733, -122.475894948395)
43257 31128 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Foerster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM 11 6x4 Permit Number 34844 5998083.53233 2093940.2779 37.7294512402595 -122.44891605234501 (37.7294512402595, -122.448916052345)
43330 108919 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 624 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773067 6007633.7 2096431.2 37.7368323085558 -122.416076443366 (37.7368323085558, -122.416076443366)
43896 62169 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 68 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/06/1985 12:00:00 AM 11   Permit Number 22285 6000002.99959 2091885.11189 37.7239178142491 -122.44213282229201 (37.7239178142491, -122.442132822292)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2441.156ms · Data source: data.sfgov.org