Street_Tree_List

Data source: data.sfgov.org

308 rows where DBH = 6 and qSpecies = 18 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize

DBH

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1495 213442 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2455 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2002 12:00:00 AM 6 Width 3ft Permit Number 45711 5992014.67382 2098752.22599 37.742314697659204 -122.470246761681 (37.7423146976592, -122.470246761681)
10340 28256 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3476 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/19/2003 12:00:00 AM 6 3x3   6012060.981000001 2089540.1901200002 37.7181589470551 -122.400285438425 (37.7181589470551, -122.400285438425)
11313 26979 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 538 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6004789.78173 2093487.7597 37.728589968546 -122.42569968949199 (37.728589968546, -122.425699689492)
17409 4836 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 123 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/2000 12:00:00 AM 6 3X3   6006379.67825 2097659.7420099997 37.7401350234134 -122.420499335499 (37.7401350234134, -122.420499335499)
18266 4090 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3215 Cesar Chavez St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/1995 12:00:00 AM 6 3X3   6008246.07333 2100530.81306 37.748123352213504 -122.41424916149201 (37.7481233522135, -122.414249161492)
18339 3945 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Castro St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2000 12:00:00 AM 6 3X3   6002246.22679 2107489.51068 37.7668914137434 -122.435494123149 (37.7668914137434, -122.435494123149)
18631 10219 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1361 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/08/2002 12:00:00 AM 6 3X3   6005865.11973 2101072.64646 37.7494770729178 -122.422520923317 (37.7494770729178, -122.422520923317)
19214 10228 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1411 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/02/2002 12:00:00 AM 6 3X3   6005886.64477 2100667.53648 37.7483659479448 -122.422417708118 (37.7483659479448, -122.422417708118)
21301 3944 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/1999 12:00:00 AM 6 3X3   6002248.02502 2107476.74068 37.7668564525859 -122.435486989749 (37.7668564525859, -122.435486989749)
21380 4200 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3890 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/1995 12:00:00 AM 6 3X3   6004657.19405 2100480.3462900002 37.7477825352565 -122.42665579384399 (37.7477825352565, -122.426655793844)
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)
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)
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)
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)
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)
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)
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)
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)
52624 86960 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 208 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/2007 12:00:00 AM 6 3x3 Permit Number 49928 5993493.7535 2087361.9529 37.71112519553311 -122.464305827668 (37.7111251955331, -122.464305827668)
55895 40019 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 12 Latona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1999 12:00:00 AM 6   Permit Number 41264 6014412.91208 2094585.9323200001 37.732144413937796 -122.392508504263 (37.7321444139378, -122.392508504263)
56599 43215 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 365 Sweeny St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 6   Permit Number 43005 6008686.27116 2094503.726 37.731599006589704 -122.41230103567499 (37.7315990065897, -122.412301035675)
56604 33140 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3143 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 6   Permit Number 37367 6001896.074 2118984.29093 37.798433267540105 -122.437528496644 (37.7984332675401, -122.437528496644)
56945 84414 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 738 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 6 3x3 Permit Number 51575 5994138.61763 2110515.8988900003 37.7747372701378 -122.46375650168999 (37.7747372701378, -122.46375650169)
57991 37799 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 425 Somerset St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/2002 12:00:00 AM 6   Permit Number 40126 6010088.32636 2092511.7068599998 37.7262079180568 -122.407313455853 (37.7262079180568, -122.407313455853)
58413 40675 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 191 Maynard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2005 12:00:00 AM 6   Permit Number 47920 6004642.33575 2093798.50545 37.7294348744024 -122.42623153326099 (37.7294348744024, -122.426231533261)
59674 33813 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 261 Linden St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/26/1996 12:00:00 AM 6   Permit Number 37827 6006152.11101 2110895.2275099996 37.776463756237504 -122.42222627034401 (37.7764637562375, -122.422226270344)
61632 39922 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2335 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/25/1999 12:00:00 AM 6   Permit Number 41196 6003527.33622 2116558.3105 37.791864757797896 -122.431710530526 (37.7918647577979, -122.431710530526)
62513 69303 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 813 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/08/2014 12:00:00 AM 6   Permit Number 770956 5999968.796 2111801.6454 37.7786018352438 -122.443681177953 (37.7786018352438, -122.443681177953)
68081 64861 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 52 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/03/1989 12:00:00 AM 6   Permit Number 25877 5995901.579469999 2112392.78617 37.779992138301296 -122.457793938484 (37.7799921383013, -122.457793938484)
69163 34484 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 845 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1997 12:00:00 AM 6   Permit Number 38210 6008932.65781 2119362.16351 37.799868357993105 -122.41320640114901 (37.7998683579931, -122.413206401149)
79299 12771 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1831 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/1992 12:00:00 AM 6 3X3   5989737.94266 2114686.68849 37.785934529444 -122.479284343127 (37.785934529444, -122.479284343127)
84217 47482 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1809 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 6   Permit Number 45377 5999495.90716 2115146.40334 37.78775869076279 -122.445557657368 (37.7877586907628, -122.445557657368)
86950 94707 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1   10/29/2010 12:00:00 AM 6   Permit Number 53868 5994701.2 2098925.3 37.7429448703691 -122.460970181408 (37.7429448703691, -122.460970181408)
92859 28143 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 459 Eugenia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3X3   6006960.8227954 2097937.5089004 37.740930442807105 -122.418509660609 (37.7409304428071, -122.418509660609)
104135 16618 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 119 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/01/1998 12:00:00 AM 6 3X3   6002884.413921201 2107574.4751295 37.7671609304618 -122.433292810769 (37.7671609304618, -122.433292810769)
112779 2712 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2168 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/29/1997 12:00:00 AM 6 3X3   6003139.43848 2114860.32817 37.787180536009394 -122.43293129477699 (37.7871805360094, -122.432931294777)
131343 39995 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 869 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2004 12:00:00 AM 6 3x3 Permit Number 47551 6019405.77873 2094282.05396 37.7315860320638 -122.375225801726 (37.7315860320638, -122.375225801726)
131821 84213 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Tioga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 6 3x3 Permit Number 50702 6010145.69333 2089116.11525 37.716887537712005 -122.406875926694 (37.716887537712, -122.406875926694)
133177 82162 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 569-571 03rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 6 3x3 Permit Number 51568 5994982.94214 2111676.20425 37.7779717778616 -122.460919944539 (37.7779717778616, -122.460919944539)
135851 31058 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Winding Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/13/1995 12:00:00 AM 6   Permit Number 34809 6002732.75221 2087097.44922 37.71092714054029 -122.432354735598 (37.7109271405403, -122.432354735598)
140594 94706 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   10/29/2010 12:00:00 AM 6   Permit Number 53868 5994701.2 2098925.3 37.7429448703691 -122.460970181408 (37.7429448703691, -122.460970181408)
146555 50298 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2909 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 6   Permit Number 47009 5989047.4642199995 2095832.2551400003 37.734125220204604 -122.48029267726999 (37.7341252202046, -122.48029267727)
147429 69497 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 55 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/24/1994 12:00:00 AM 6   Permit Number 33620 6000865.527869999 2092792.12819 37.726457391768896 -122.439216186893 (37.7264573917689, -122.439216186893)
152059 65922 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 6   Permit Number 28938 6014500.58115 2112811.20719 37.7821919655182 -122.393480434 (37.7821919655182, -122.393480434)
152492 42978 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Oxford St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 6   Permit Number 42862 6006544.924430001 2092660.29869 37.7264169636546 -122.41957336651699 (37.7264169636546, -122.419573366517)
157218 55617 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 411 Laurel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/1996 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.787357733409706 -122.45030520091998 (37.7873577334097, -122.45030520092)
159871 84412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 569-571 03rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 6 3x3 Permit Number 51568 5994982.60822 2111689.36495 37.7780078944262 -122.460922053766 (37.7780078944262, -122.460922053766)
161168 68950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32939 5988846.075 2110312.98983 37.7738737393837 -122.482049401575 (37.7738737393837, -122.482049401575)
164404 40950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM 6   Permit Number 42451 5989371.25434 2111628.81002 37.777517147846204 -122.480329070335 (37.7775171478462, -122.480329070335)
168539 45578 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 6   Permit Number 44318 5998557.11063 2115405.08726 37.788415328045204 -122.448824341269 (37.7884153280452, -122.448824341269)
170473 82703 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 67 Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2009 12:00:00 AM 6 3x3 Permit Number 52500 6012950.17329 2089208.10371 37.71729664739521 -122.39718858698 (37.7172966473952, -122.39718858698)
170516 44260 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 320 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM 6   Permit Number 43692 6003282.08858 2092150.8754099999 37.72483387178 -122.430816500988 (37.72483387178, -122.430816500988)
172196 35478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 524 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1998 12:00:00 AM 6   Permit Number 38890 5986598.81458 2112347.1481 37.779328002919705 -122.489972580124 (37.7793280029197, -122.489972580124)
177753 111197 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6     6003620.633230001 2116569.07161 37.791899593028205 -122.43138849140499 (37.7918995930282, -122.431388491405)
184864 42977 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Oxford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 6   Permit Number 42862 6006537.3191599995 2092680.57085 37.7264721982142 -122.419601095323 (37.7264721982142, -122.419601095323)
186222 56305 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 147 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1973 12:00:00 AM 6   Permit Number 12437 5993019.12779 2114510.13973 37.785639797963704 -122.467919595671 (37.7856397979637, -122.467919595671)
24659 239434 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 641 Chenery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002846.37462 2095677.3876200002 37.734492180455 -122.43257449123699 (37.734492180455, -122.432574491237)
24891 213671 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Edgehill Way 7 Front Yard : Yard 7 Tree 1 Private 1     6 Width 3ft   5994885.5088599995 2098943.91671 37.7430065910919 -122.460334245238 (37.7430065910919, -122.460334245238)
26326 213639 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 32 Malta Dr 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999561.36601 2096051.1462299998 37.7353315950748 -122.44395866097099 (37.7353315950748, -122.443958660971)
26912 237377 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 979 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009171.618530001 2103483.06464 37.7562815207028 -122.411257166497 (37.7562815207028, -122.411257166497)
27195 135991 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1040 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008482.86494 2115597.67171 37.789506729108204 -122.414496332055 (37.7895067291082, -122.414496332055)
27694 238465 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 71 Potomac St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003081.83351 2108772.32809 37.7704611394919 -122.43269554267599 (37.7704611394919, -122.432695542676)
27986 237283 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 614 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007963.94281 2096020.98872 37.7357245205556 -122.414905620711 (37.7357245205556, -122.414905620711)
29054 238048 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 400 Lily St 3 : 4 Tree 1 Private 1     6 Width 3ft   6004553.97154 2110004.0488299998 37.7739265241283 -122.427691180609 (37.7739265241283, -122.427691180609)
29842 238504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 68 Wilder St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002684.617740001 2095553.88907 37.7341439071982 -122.433124916788 (37.7341439071982, -122.433124916788)
30210 237187 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 904 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6004333.66814 2103620.22544 37.7563856136086 -122.427998244239 (37.7563856136086, -122.427998244239)
30565 238390 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Collingwood St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6001989.17062 2105400.26005 37.7611402393495 -122.436233705824 (37.7611402393495, -122.436233705824)
31003 124618 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Euclid Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996155.438130001 2113845.79893 37.78399630583271 -122.45702086273 (37.7839963058327, -122.45702086273)
31403 238374 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 587 Liberty St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002502.863419999 2103825.71172 37.7568460818083 -122.434344490133 (37.7568460818083, -122.434344490133)
31639 213343 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 117 Vernon St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992434.92339 2088648.0359 37.7145953816368 -122.468058861341 (37.7145953816368, -122.468058861341)
31646 237358 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1400 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008695.940169999 2100749.23036 37.7487483369695 -122.41270897086399 (37.7487483369695, -122.412708970864)
32170 111793 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 55X Sherman St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     6 3x3   6010868.84129 2110834.34163 37.7765614981606 -122.405905386452 (37.7765614981606, -122.405905386452)
32602 213579 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 464 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994822.2189 2100134.8158400003 37.7462728613029 -122.460639364526 (37.7462728613029, -122.460639364526)
34110 213580 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 45 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5995131.70851 2099996.48556 37.74591084191 -122.459559177141 (37.74591084191, -122.459559177141)
34117 237115 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Hwy 101 Southbound 6 Back Yard : Yard 13 Tree 1 Private 1     6     6005846.05822 2108984.84199 37.7712010306339 -122.42314917169399 (37.7712010306339, -122.423149171694)
34178 213551 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 159 Valdez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996188.75737 2094532.8518700001 37.73096976354329 -122.455509245751 (37.7309697635433, -122.455509245751)
34374 213557 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Valdez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5996396.856430001 2093987.6566700002 37.7294847274146 -122.454750441903 (37.7294847274146, -122.454750441903)
34515 237052 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1359 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010359.96313 2101381.9177099997 37.7505788125805 -122.40699934965099 (37.7505788125805, -122.406999349651)
34790 237110 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 380 Lexington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 1ft   6006531.04727 2103908.9188900003 37.7573023708184 -122.420419415431 (37.7573023708184, -122.420419415431)
35079 213616 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 282 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995109.982340001 2095633.16995 37.733929007011206 -122.459318378264 (37.7339290070112, -122.459318378264)
35288 238420 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 242 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999803.1371 2105544.26543 37.7614111970029 -122.443804579221 (37.7614111970029, -122.443804579221)
35668 213507 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 170 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995650.65208 2093847.52813 37.729057137577 -122.457319993841 (37.729057137577, -122.457319993841)
36221 239472 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 192 Upper Ter 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5999641.79555 2106531.14704 37.764111724386204 -122.44443351741998 (37.7641117243862, -122.44443351742)
37063 213321 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Monticello St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5991673.594880001 2090710.5616 37.7202145769251 -122.470840448236 (37.7202145769251, -122.470840448236)
37224 238146 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 816 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001874.44025 2101652.14409 37.750842295952104 -122.436362251334 (37.7508422959521, -122.436362251334)
38356 213463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 314 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5993094.88579 2099699.80528 37.7449789032567 -122.46658060972 (37.7449789032567, -122.46658060972)
38505 237174 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1530 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008721.73548 2099825.28397 37.746212833362605 -122.412554466435 (37.7462128333626, -122.412554466435)
38891 238204 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3753 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003355.958330001 2103579.02376 37.7562171211382 -122.43137656370399 (37.7562171211382, -122.431376563704)
39061 238237 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3851 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003263.10271 2105914.5471 37.7626246459451 -122.43186444678899 (37.7626246459451, -122.431864446789)
39066 124480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 276 Willard St North 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5996245.79674 2110923.35846 37.7759772459796 -122.456496854767 (37.7759772459796, -122.456496854767)
39076 123168 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 598 10th Ave 1 Side Yard : Yard 17 Tree 1 Private 1     6     5992809.72377 2111438.2053099996 37.7771930089585 -122.468420491782 (37.7771930089585, -122.468420491782)
39376 239418 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2106 Castro St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6     6002637.419840001 2099337.55033 37.7445302890331 -122.433558405315 (37.7445302890331, -122.433558405315)
40172 213418 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1500 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991335.33208 2098431.48094 37.741394714585496 -122.47257231588301 (37.7413947145855, -122.472572315883)
40381 250676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 735 El Camino Del Mar 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986293.297259999 2114811.88275 37.786077611448 -122.49121092176 (37.786077611448, -122.49121092176)
41185 238302 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 224 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001725.92578 2104522.1250400003 37.758714133770496 -122.437081282675 (37.7587141337705, -122.437081282675)
41337 238326 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 358 Eureka St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001462.98209 2103653.8418 37.7563150887866 -122.437928468325 (37.7563150887866, -122.437928468325)
41344 196448 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 Madera St 2 : 4 Tree 1 Private 1     6 Width 3ft   6012976.23669 2103282.94556 37.755944680513295 -122.398085357651 (37.7559446805133, -122.398085357651)
42511 214723 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Miramar Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995322.28894 2093286.2773099998 37.7274972131074 -122.45841455420299 (37.7274972131074, -122.458414554203)
42810 237421 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4347 Cesar Chavez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001594.69603 2100278.73808 37.74705535061779 -122.43723130398199 (37.7470553506178, -122.437231303982)

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