Street_Tree_List

Data source: data.sfgov.org

1,114 rows where qLegalStatus = 1 and qSpecies = 18 sorted by PlotSize

View and edit SQL

qLegalStatus

  • Permitted Site · 1,114
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▼ PermitNotes XCoord YCoord Latitude Longitude Location
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)
2617 59596 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/21/2014 12:00:00 AM 0   Permit Number 770950 6000181.59670606 2113731.76941076 37.7839135947641 -122.443083674123 (37.7839135947641, -122.443083674123)
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)
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)
7289 111196 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/27/2015 12:00:00 AM 3   Permit Number 775548 6003599.3502400005 2116566.69152 37.7918918516902 -122.43146196059601 (37.7918918516902, -122.431461960596)
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)
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)
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)
15561 43296 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 589 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/12/2015 12:00:00 AM 3   Permit Number 775309 6013581.06232 2104334.57728 37.758865901566296 -122.39606735184601 (37.7588659015663, -122.396067351846)
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)
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)
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)
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)
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)
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)
25624 33992 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2034 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2013 12:00:00 AM 3   Permit Number 769995 6001444.58 2115566.6422 37.7890236150982 -122.438845759727 (37.7890236150982, -122.438845759727)
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)
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)
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)
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)
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)
30826 51284 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2205 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/24/2004 12:00:00 AM 4   Permit Number 47656 6000322.72568 2116238.1776 37.7908035865572 -122.442775457127 (37.7908035865572, -122.442775457127)
31288 49149 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2721 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/23/2003 12:00:00 AM 8   Permit Number 46272 6001579.27273 2117782.40416 37.7951151846669 -122.43853856390301 (37.7951151846669, -122.438538563903)
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)
31936 48575 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2275 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/2002 12:00:00 AM 6   Permit Number 45888 5999350.9725 2120803.18902 37.80328244439271 -122.446466222664 (37.8032824443927, -122.446466222664)
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)
33377 59100 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 574 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 4   Permit Number 53750 5993480.53201 2111592.2596 37.777654724152896 -122.46611116933201 (37.7776547241529, -122.466111169332)
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)
33711 49142 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2003 12:00:00 AM 4   Permit Number 46265 5985047.031690001 2112314.4789400003 37.7791475672211 -122.495338355641 (37.7791475672211, -122.495338355641)
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)
34126 45776 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 782 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/2001 12:00:00 AM 4   Permit Number 44418 5991347.84343 2110102.5113 37.7734410095192 -122.47338010572399 (37.7734410095192, -122.473380105724)
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)
34567 67434 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 772 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1992 12:00:00 AM 10   Permit Number 30936 5989473.46135 2110070.59902 37.7732446703113 -122.479861453207 (37.7732446703113, -122.479861453207)
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)
36163 66052 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2153 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1990 12:00:00 AM 5   Permit Number 29091 6000458.6364 2120609.1379299997 37.8028128355005 -122.442619184653 (37.8028128355005, -122.442619184653)
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)
37085 43877 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 144 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/2000 12:00:00 AM 7   Permit Number 43492 6003098.49585 2092711.51751 37.726362865838 -122.431491164302 (37.726362865838, -122.431491164302)
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)
37962 31466 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 512 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/01/1995 12:00:00 AM 4   Permit Number 35032 6002998.75397 2102141.19875 37.7522489444334 -122.432509202251 (37.7522489444334, -122.432509202251)
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)
38699 52528 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2005 12:00:00 AM 7   Permit Number 48628 6001332.37944 2092272.13723 37.725056169781205 -122.437565081984 (37.7250561697812, -122.437565081984)
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)
39049 51052 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 326 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2004 12:00:00 AM 10   Permit Number 47522 5987167.50591 2113744.97071 37.7831992171669 -122.488108007262 (37.7831992171669, -122.488108007262)
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)
39495 40843 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 630 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/02/1999 12:00:00 AM 3   Permit Number 41769 5994424.39514 2111218.1597700003 37.7766819550203 -122.462818903997 (37.7766819550203, -122.462818903997)
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)
40502 38237 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 81 Langton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1998 12:00:00 AM 8   Permit Number 40353 6010112.774540001 2110816.57283 37.776470395916796 -122.408519597801 (37.7764703959168, -122.408519597801)
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)
40854 64351 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2829 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/1988 12:00:00 AM 10   Permit Number 25187 5999331.75802 2118714.3640900003 37.797545994610296 -122.44638235637501 (37.7975459946103, -122.446382356375)
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)
41980 54425 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 664 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/1972 12:00:00 AM 10   Permit Number 10199 6012377.17429 2104832.12129 37.760164992032706 -122.40026592765498 (37.7601649920327, -122.400265927655)
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)
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)
43631 50013 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 999 Wisconsin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/22/2009 12:00:00 AM 2   Permit Number 52022 6012813.23846 2102916.22313 37.7549286606329 -122.398623329429 (37.7549286606329, -122.398623329429)
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)
44234 40656 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Congdon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 5   Permit Number 47919 6004682.83135 2093737.6135099998 37.729269967531295 -122.42608720287501 (37.7292699675313, -122.426087202875)
44542 34480 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 771 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM 18   Permit Number 38207 6009276.26447 2119410.9605 37.8000216267413 -122.412020839304 (37.8000216267413, -122.412020839304)
44613 64863 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 77 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 5   Permit Number 25879 5995882.63467 2112271.55178 37.7796581724444 -122.45785070123999 (37.7796581724444, -122.45785070124)
44768 121639 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 195 Otsego Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   14     6000575.25086 2092201.75917 37.7248198513454 -122.440177342728 (37.7248198513454, -122.440177342728)
45015 64286 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2137 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1988 12:00:00 AM 3   Permit Number 25090 6003796.622169999 2115819.36952 37.789851074108896 -122.43072604627399 (37.7898510741089, -122.430726046274)
45771 48784 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 268 Onondaga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/2002 12:00:00 AM 7   Permit Number 46039 6000083.90087 2091529.02554 37.7229446929396 -122.44182761574801 (37.7229446929396, -122.441827615748)
46117 68549 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 3   Permit Number 32436 5982217.68828 2112054.92779 37.7782688503059 -122.50510680493 (37.7782688503059, -122.50510680493)
46218 34478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 755 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM 16   Permit Number 38205 6009336.13836 2119417.92641 37.8000441124981 -122.411814144501 (37.8000441124981, -122.411814144501)
46269 41181 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1780 Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/24/1999 12:00:00 AM 11   Permit Number 41899 6001559.95191 2121091.33566 37.8041995397404 -122.438842652585 (37.8041995397404, -122.438842652585)
46283 31905 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2259 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 9   Permit Number 35330 5991969.67434 2100068.6545599997 37.7459266717829 -122.47049820945 (37.7459266717829, -122.47049820945)
46285 65280 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 435 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1989 12:00:00 AM 1   Permit Number 28085 6011091.92612 2112217.73363 37.7803724445696 -122.405231107147 (37.7803724445696, -122.405231107147)
46506 46788 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Tingley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/25/2002 12:00:00 AM 13   Permit Number 44879 6002727.62043 2093608.9961599999 37.7288061125106 -122.432837348688 (37.7288061125106, -122.432837348688)
46730 40853 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 126 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/2002 12:00:00 AM 11   Permit Number 45449 6014213.93466 2112556.76874 37.781477404701 -122.394454288235 (37.781477404701, -122.394454288235)
46997 31908 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2227 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 13   Permit Number 35333 5991730.6123 2100240.74702 37.746385367410205 -122.47133738212601 (37.7463853674102, -122.471337382126)
47328 45483 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3020 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/19/2001 12:00:00 AM 3   Permit Number 44263 5990296.648580001 2095102.6956099998 37.7321945457224 -122.47592063752501 (37.7321945457224, -122.475920637525)
47842 52649 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46@ LAKE 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/17/2006 12:00:00 AM 4   Permit Number 48733 5993970.1832 2115226.91418 37.787662738807605 -122.46468131190001 (37.7876627388076, -122.4646813119)
48200 31194 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 354 Victoria St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/2003 12:00:00 AM 5   Permit Number 46596 5993258.721390001 2089558.71458 37.7171434272164 -122.46527761436899 (37.7171434272164, -122.465277614369)
48217 32078 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3847 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35451 6003283.17124 2105912.34445 37.7626197356314 -122.431794879733 (37.7626197356314, -122.431794879733)
48514 50297 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2909 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 1   Permit Number 47009 5989047.82914 2095849.4982599998 37.7341725865769 -122.48029267728701 (37.7341725865769, -122.480292677287)
48739 57611 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 356 Connecticut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/12/1976 12:00:00 AM 13   Permit Number 16500 6013179.72476 2105412.69394 37.761803835594705 -122.397530985864 (37.7618038355947, -122.397530985864)
48981 45577 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3866 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 3   Permit Number 44317 5996397.2109199995 2114961.83643 37.78707452790071 -122.456265143944 (37.7870745279007, -122.456265143944)
49916 37808 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 925 Woolsey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/06/1998 12:00:00 AM 14   Permit Number 40128 6009009.75323 2091360.17391 37.7229856264714 -122.41096074186702 (37.7229856264714, -122.410960741867)
49985 31912 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2256 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 9   Permit Number 35336 5991754.81336 2100091.67364 37.745977450207 -122.47124283909099 (37.745977450207, -122.471242839091)
50848 50228 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 741 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/2003 12:00:00 AM 5   Permit Number 46935 5987844.86264 2110914.45258 37.775466905732706 -122.485556863724 (37.7754669057327, -122.485556863724)
50853 38717 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 458 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/1998 12:00:00 AM 8   Permit Number 40620 5994382.59481 2112404.76272 37.779937641475705 -122.463049617411 (37.7799376414757, -122.463049617411)
51253 51883 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 209 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM     Permit Number 48099 6006849.08815448 2097918.82782797 37.740872857816 -122.418894673949 (37.740872857816, -122.418894673949)

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 3422.919ms · Data source: data.sfgov.org