Street_Tree_List

Data source: data.sfgov.org

351 rows where qLegalStatus = 3 and qSpecies = 18 sorted by SiteOrder

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes

qLegalStatus

  • DPW Maintained · 351
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2141 18982 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2920 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6000616.67404 2115546.70514 37.7889217363036 -122.44170876675699 (37.7889217363036, -122.441708766757)
4128 135978 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Fern St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 4 Width 4ft   6006877.42 2115159.3392 37.788212853775896 -122.420019889812 (37.7882128537759, -122.420019889812)
4797 214559 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1342 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1340 Irving St 1 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
7138 29119 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 509 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/19/2005 12:00:00 AM 3 3x3   6008381.9659 2113792.89597 37.7845455839642 -122.414717657915 (37.7845455839642, -122.414717657915)
7662 88451 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3200X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2   06/07/2008 12:00:00 AM 3 5x12   6005480.84439 2121378.35155 37.805209901088396 -122.425294529632 (37.8052099010884, -122.425294529632)
7952 17354 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2200 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6005542.87933 2117567.08542 37.7947486417029 -122.424808539584 (37.7947486417029, -122.424808539584)
8858 21651 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1689 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/31/2013 12:00:00 AM 3 4X4   6004532.1578 2114645.7829 37.7866703442988 -122.428097491401 (37.7866703442988, -122.428097491401)
8875 2624 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1822 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6004615.6699 2115060.0567 37.7878125608959 -122.427838089219 (37.7878125608959, -122.427838089219)
10377 28246 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3326 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282)
11150 28262 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3624 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/20/2003 12:00:00 AM 12 3x3   6012194.4874599995 2088681.14992 37.715807638979705 -122.399763675165 (37.7158076389797, -122.399763675165)
11292 86217 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2621 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2013 12:00:00 AM 3 3x3   5988925.7787 2097455.0086 37.7385738093546 -122.48083214346799 (37.7385738093546, -122.480832143468)
11481 28255 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/25/2003 12:00:00 AM 6 3x3   6012058.005419999 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219)
11602 27093 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 711 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6006091.0826900005 2093593.66537 37.7289542101608 -122.421208528251 (37.7289542101608, -122.421208528251)
12009 28254 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3410 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/23/2002 12:00:00 AM 8 3X3   6012011.64722 2089824.91922 37.7189380045612 -122.400475954423 (37.7189380045612, -122.400475954423)
12039 28243 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3230 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/21/2004 12:00:00 AM 8 2X3   6011870.75873 2090643.72462 37.7211784199346 -122.401020454343 (37.7211784199346, -122.401020454343)
12282 17504 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 132 Persia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6002139.261969999 2091310.46109 37.7224614665061 -122.43470704369 (37.7224614665061, -122.43470704369)
12568 28244 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3260 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/20/2003 12:00:00 AM 12 2X3   6011894.92216 2090508.59301 37.7208087239121 -122.40092743836 (37.7208087239121, -122.40092743836)
12793 13368 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 900 Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X50   6009218.46856 2090025.7710400003 37.719333336630896 -122.410145089137 (37.7193333366309, -122.410145089137)
13815 27724 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1200 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015353.113480001 2101161.82636 37.750252634763996 -122.389717121075 (37.750252634764, -122.389717121075)
14286 27729 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1100 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2006 12:00:00 AM 3 3X3   6015622.7491 2101166.85438 37.75028138877779 -122.38878504659999 (37.7502813887778, -122.3887850466)
16131 4050 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2550 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6011878.426080001 2100960.1838700003 37.7495056776496 -122.40171871317101 (37.7495056776496, -122.401718713171)
17088 4158 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3739-3737 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/31/1989 12:00:00 AM 12 3X3   6005577.7811900005 2100485.8259400004 37.74784958418571 -122.423472835916 (37.7478495841857, -122.423472835916)
17098 4184 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3835 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 12 3X3   6004944.66483 2100451.1135299997 37.7477185170056 -122.425659653475 (37.7477185170056, -122.425659653475)
17135 4290 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4319 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001811.82225 2100290.20269 37.7470991700926 -122.43648132156099 (37.7470991700926, -122.436481321561)
17328 1375 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 57 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/24/1999 12:00:00 AM 3 1X1   5998969.3690599995 2100010.78272 37.7461700211271 -122.446290155185 (37.7461700211271, -122.446290155185)
17633 23053 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1074 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/16/1992 12:00:00 AM 18 3X3   6006318.63458 2103360.59062 37.7557848161263 -122.421115089604 (37.7557848161263, -122.421115089604)
17744 4206 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3920 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/06/1995 12:00:00 AM 3 3X3   6004377.17948 2100465.22503 37.7477251809744 -122.427622993127 (37.7477251809744, -122.427622993127)
17823 24441 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4162 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/28/1995 12:00:00 AM 3 3X3   6002908.04263 2100385.0344599998 37.747421786581995 -122.432697458221 (37.747421786582, -122.432697458221)
18070 4052 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2900 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/25/2008 12:00:00 AM 3 3X3   6010072.48365 2100637.4543 37.7485185889697 -122.407940988391 (37.7485185889697, -122.407940988391)
18298 10022 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 282 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/01/2003 12:00:00 AM 3 2x2   6005445.78054 2107378.48496 37.766767762334794 -122.42441947400499 (37.7667677623348, -122.424419474005)
18418 27508 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1325 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/24/2000 12:00:00 AM 12 3X3   6005854.22427 2101278.43596 37.750041509014004 -122.42257322160299 (37.750041509014, -122.422573221603)
18600 4218 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3955 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/19/1998 12:00:00 AM 3 3X3   6004198.47443 2100405.87482 37.747552109146206 -122.42823671656099 (37.7475521091462, -122.428236716561)
18694 10178 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1086 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/29/2001 12:00:00 AM 16 2X2   6005705.19862 2102704.3683 37.7539483816144 -122.423189907382 (37.7539483816144, -122.423189907382)
18995 19331 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/05/2000 12:00:00 AM 6 3x3   5993203.76699 2089824.45321 37.7178699121392 -122.465486857851 (37.7178699121392, -122.465486857851)
19154 4234 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4013X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/05/1995 12:00:00 AM 3 3x3   6003806.79862 2100387.84018 37.7474804205949 -122.429589821227 (37.7474804205949, -122.429589821227)
19279 91934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992339.241228 2106582.494136 37.7638333412086 -122.46969443927 (37.7638333412086, -122.46969443927)
19308 4173 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3807X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/30/1995 12:00:00 AM 6 3X3   6005111.29038 2100461.84082 37.7477573856943 -122.42508423394301 (37.7477573856943, -122.425084233943)
19447 2552 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 59 Burnside Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/1999 12:00:00 AM 25 3X3   6001211.45267 2095788.41504 37.7347041848314 -122.43823489701799 (37.7347041848314, -122.438234897018)
19895 4295 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4342 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/17/2003 12:00:00 AM 3 3X3   6001671.89746 2100317.83526 37.7471670905043 -122.436967147015 (37.7471670905043, -122.436967147015)
19906 1353 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 284 Amber Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5999905.46078 2099295.02318 37.7442581344216 -122.44300188482401 (37.7442581344216, -122.443001884824)
20569 26702 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 140 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/11/1998 12:00:00 AM 30 3X3   6006456.60108 2097572.163 37.739898885722 -122.42022715296899 (37.739898885722, -122.420227152969)
20594 4060 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3017 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/06/1998 12:00:00 AM 3 3X3   6009461.72254 2100536.5932400003 37.7482074334345 -122.410045879537 (37.7482074334345, -122.410045879537)
20735 1373 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 49 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/24/1999 12:00:00 AM 3 1X1   5999002.70945 2100014.0540299998 37.7461809074259 -122.446175104021 (37.7461809074259, -122.446175104021)
20787 4288 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4314 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001830.459 2100325.99082 37.7471984948291 -122.436419438314 (37.7471984948291, -122.436419438314)
20828 4100 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3321 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/19/2000 12:00:00 AM 3 3x3   6007597.59872 2100526.27366 37.748074440783796 -122.416491248692 (37.7480744407838, -122.416491248692)
20836 4276 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4221 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/1995 12:00:00 AM 3 3x3   6002451.40883 2100314.3802 37.7472018789671 -122.434271414787 (37.7472018789671, -122.434271414787)
20906 89402 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1914 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/10/2008 12:00:00 AM 3 3x3   5992725.997880001 2112086.29643 37.7789676550624 -122.468757294436 (37.7789676550624, -122.468757294436)
20923 1370 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 41 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 1X1   5999037.99816 2100015.3023099997 37.7461863501203 -122.446053170314 (37.7461863501203, -122.446053170314)
21015 19321 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/26/2010 12:00:00 AM 3 3X3   5993639.27417 2089852.22483 37.7179712747243 -122.46398352863001 (37.7179712747243, -122.46398352863)
21078 1362 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 17 Amethyst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 1X1   5999159.03773 2100010.23642 37.7461793516141 -122.445634267927 (37.7461793516141, -122.445634267927)
21277 4291 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4324 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001780.20994 2100324.37087 37.7471911914402 -122.43659307941999 (37.7471911914402, -122.43659307942)
21292 27301 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/06/1999 12:00:00 AM 18 2X3   6010383.48436 2104847.2768900003 37.7600952334384 -122.407162256428 (37.7600952334384, -122.407162256428)
21356 4210 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3932 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/05/2004 12:00:00 AM 3 3X3   6004303.84786 2100460.14425 37.7477070821197 -122.427876208032 (37.7477070821197, -122.427876208032)
21550 27620 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1149 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010601.0802 2102491.1542599997 37.7536380210979 -122.40624368710199 (37.7536380210979, -122.406243687102)
21590 22829 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 88 Turquoise Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3X3   5999388.64339 2099036.75019 37.743519498737896 -122.44477036118299 (37.7435194987379, -122.444770361183)
21630 26477 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 112 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/23/2001 12:00:00 AM 8 3x3   6001287.0278199995 2098748.5722 37.742836382684295 -122.438185594392 (37.7428363826843, -122.438185594392)
21715 4289 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4318 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001802.38664 2100324.70976 37.747193382168604 -122.43651641850799 (37.7471933821686, -122.436516418508)
22002 4306 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4390 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/07/1995 12:00:00 AM 3 3X3   6001409.31695 2100304.12131 37.747114507137205 -122.437874145675 (37.7471145071372, -122.437874145675)
22029 25409 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3763-3767 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/19/1996 12:00:00 AM 6 3x3   6005453.81691 2100480.39517 37.7478276749239 -122.42390111285 (37.7478276749239, -122.42390111285)
22114 10208 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1286 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/28/1991 12:00:00 AM 3 2X2   6005769.15445 2101526.21369 37.750717050048706 -122.422885005752 (37.7507170500487, -122.422885005752)
22261 4054 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2957 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/1999 12:00:00 AM 3 3X3   6009770.62771 2100537.88813 37.7482282977114 -122.40897778170799 (37.7482282977114, -122.408977781708)
23069 4182 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3830 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     10 3X3   6004950.59619 2100495.54046 37.747840838281796 -122.42564230465 (37.7478408382818, -122.42564230465)
23228 28259 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3562 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/21/2004 12:00:00 AM 10 3x3   6012127.60331 2089140.68412 37.717065698801 -122.400027111788 (37.717065698801, -122.400027111788)
24090 238060 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2x Montezuma St 1 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6007260.48935 2099759.47356 37.7459500163869 -122.417602623671 (37.7459500163869, -122.417602623671)
44141 88407 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1199 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009407.88363 2117347.72867 37.7943638829406 -122.411419542685 (37.7943638829406, -122.411419542685)
51558 91889 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1112 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5992343.82828 2106622.674723 37.7639439315835 -122.46968149954701 (37.7639439315835, -122.469681499547)
54134 91923 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1427 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991353.957672 2106548.744029 37.763683675450004 -122.473099740894 (37.76368367545, -122.473099740894)
65800 91919 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1445 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991297.838563 2106546.8216959997 37.7636751478808 -122.47329369732799 (37.7636751478808, -122.473293697328)
77375 86070 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2115 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987568.946045 2100884.101082 37.7479102288924 -122.485774970523 (37.7479102288924, -122.485774970523)
77667 4142 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3615-3623X Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/01/1995 12:00:00 AM 3 3X3   6005538.0 2100417.0 37.747658358497404 -122.423605504909 (37.7476583584974, -122.423605504909)
78561 14625 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 15 Matthew Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 12 3X4   6017974.7726653 2094204.2737729999 37.7312936151853 -122.380167719121 (37.7312936151853, -122.380167719121)
79666 86376 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1343 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/20/2006 12:00:00 AM 3 3x3   5988009.291975 2106160.192246 37.7624226008214 -122.484639253233 (37.7624226008214, -122.484639253233)
80455 91941 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 925 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5992928.667696 2106602.6844200003 37.7639228286278 -122.467657278128 (37.7639228286278, -122.467657278128)
80485 23868 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1495X Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/30/2011 12:00:00 AM 3 3X3   6003590.023580001 2113875.44534 37.7845018426272 -122.43130203900499 (37.7845018426272, -122.431302039005)
80739 86034 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1284 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987415.003943 2106546.656914 37.763449099217404 -122.486723028948 (37.7634490992174, -122.486723028948)
81177 91970 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1350 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993350.61101 2106290.929173 37.763091183898 -122.466175257659 (37.763091183898, -122.466175257659)
81351 85991 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2222 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987633.933236 2100153.700526 37.7459085303186 -122.48549665823 (37.7459085303186, -122.48549665823)
81410 85988 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2258 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987642.054438 2099919.450203 37.7452658143921 -122.48545138958299 (37.7452658143921, -122.485451389583)
81475 91983 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1239 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993284.406043 2107051.954484 37.7651769393996 -122.46645955171999 (37.7651769393996, -122.46645955172)
81586 85943 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1538 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988095.160504 2104827.59989 37.7587686653948 -122.484244534442 (37.7587686653948, -122.484244534442)
82005 52014 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301X 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/12/2005 12:00:00 AM 9 3x3 Permit Number 48233 6004302.0 2098976.0 37.7436318598049 -122.427776865938 (37.7436318598049, -122.427776865938)
82772 85934 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1630 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988116.725594 2104200.7569 37.7570487799795 -122.484123984508 (37.7570487799795, -122.484123984508)
83265 91984 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1243 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993285.31415 2107025.55813 37.7651045143653 -122.466454492146 (37.7651045143653, -122.466454492146)
83935 91902 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1516 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/2008 12:00:00 AM 3 3x3   5991061.448475 2106578.7477680002 37.7637491175921 -122.474113618488 (37.7637491175921, -122.474113618488)
84020 85942 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1542 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988096.057532 2104801.525596 37.758697124688894 -122.48423951990299 (37.7586971246889, -122.484239519903)
84264 91966 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1376 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/20/2009 12:00:00 AM 3 3x3   5993356.433228 2106121.691358 37.76262683713129 -122.466142821616 (37.7626268371313, -122.466142821616)
84503 86007 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1742 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/12/2007 12:00:00 AM 3 3x3   5987522.322672 2103422.5340299997 37.7548773659795 -122.48612250342899 (37.7548773659795, -122.486122503429)
84609 91947 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 827 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993232.703908999 2106613.098951 37.7639689741056 -122.466606473793 (37.7639689741056, -122.466606473793)
84650 85958 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1300 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/21/2006 12:00:00 AM 3 3x3   5988039.866297 2106434.861495 37.7631785479619 -122.48455365718 (37.7631785479619, -122.48455365718)
84697 91953 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 701 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/11/2014 12:00:00 AM 3 3x3   5993618.512619 2106626.3144610003 37.7640275170127 -122.465273046982 (37.7640275170127, -122.465273046982)
84968 86321 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/12/2006 12:00:00 AM 3 3x3   5988408.134093 2103583.601964 37.7553712008265 -122.483070961912 (37.7553712008265, -122.483070961912)
85360 91951 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 751 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993470.629208 2106621.248866 37.764005078882796 -122.46578415986299 (37.7640050788828, -122.465784159863)
86154 91926 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1401 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991435.018606 2106551.520732 37.7636959924857 -122.472819581527 (37.7636959924857, -122.472819581527)
86457 91921 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1437 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991322.7803879995 2106547.676066 37.763678937950296 -122.473207494478 (37.7636789379503, -122.473207494478)
86947 91880 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 840 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/11/2008 12:00:00 AM 3 3x3   5993189.659614 2106651.6479599997 37.7640723354625 -122.466758152363 (37.7640723354625, -122.466758152363)
87057 4219 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3957 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/06/1995 12:00:00 AM 3 3X3   6004180.2435918 2100406.5432146 37.7475529128468 -122.428299805317 (37.7475529128468, -122.428299805317)
87144 91948 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 823 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2009 12:00:00 AM 3 3x3   5993244.611031 2106613.506821 37.763970781134795 -122.466565320592 (37.7639707811348, -122.466565320592)
88045 91918 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1523 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/18/2009 12:00:00 AM 3 3x3   5991044.965492 2106538.159703 37.7636367187828 -122.474167665735 (37.7636367187828, -122.474167665735)
88698 85946 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/18/2006 12:00:00 AM 3 3x3   5988083.436249 2105168.393711 37.7597037099979 -122.48431007589701 (37.7597037099979, -122.484310075897)

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