Street_Tree_List

Data source: data.sfgov.org

288 rows where DBH = 2 and qSpecies = 18

View and edit SQL

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

DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
2102 196505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3536 Jennings St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6013064.418880001 2089502.0027700001 37.7181099951501 -122.39681428375299 (37.7181099951501, -122.396814283753)
3084 238169 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1018 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/24/1989 12:00:00 AM 2 Width 4ft Permit Number 27197 6003120.08624 2102266.16095 37.7525989407879 -122.432098539422 (37.7525989407879, -122.432098539422)
3683 213464 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 Dorantes Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/24/2005 12:00:00 AM 2 Width 3ft Permit Number 48287 5993110.29995 2099700.9644 37.7449829754007 -122.46652739502701 (37.7449829754007, -122.466527395027)
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)
13168 95747 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 223 London St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 2 3x3 Permit Number 767492 6002627.86341 2092385.97592 37.7254423161963 -122.433094867748 (37.7254423161963, -122.433094867748)
23502 214703 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Darien Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992960.1777800005 2094882.5024400002 37.7317440249629 -122.46669629760001 (37.7317440249629, -122.4666962976)
23638 179012 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6001860.73543 2090148.2767900003 37.719254552441704 -122.435586742551 (37.7192545524417, -122.435586742551)
23681 237227 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Grattan St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5997877.39625 2106473.17188 37.763851709710394 -122.450531852572 (37.7638517097104, -122.450531852572)
24236 213361 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 Elmhurst Dr 6 : 4 Tree 1 Private 1     2 Width 3ft   5991216.12738 2094471.85178 37.730515676960394 -122.47269584493701 (37.7305156769604, -122.472695844937)
24443 237069 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007234.90053 2100610.51952 37.7482853569883 -122.417751419212 (37.7482853569883, -122.417751419212)
24568 214543 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 642 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993736.09449 2106681.4613900003 37.7641857161125 -122.46487037437001 (37.7641857161125, -122.46487037437)
25098 95928 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 758 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 2 3x3 Permit Number 767625 5987895.384330001 2110807.039 37.775174921567796 -122.485374215588 (37.7751749215678, -122.485374215588)
25219 238508 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 442 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003891.58392 2096046.22548 37.7355641435676 -122.428987145049 (37.7355641435676, -122.428987145049)
25818 96898 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 334 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/05/2011 12:00:00 AM 2 4x4 Permit Number 768036 5987169.6042 2113664.32132 37.7829778993822 -122.48809482 (37.7829778993822, -122.48809482)
26031 238323 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Danvers St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5999937.71667 2105097.48598 37.7601921263874 -122.443307034709 (37.7601921263874, -122.443307034709)
26159 238177 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1333 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002578.9962 2101606.95929 37.7507582372102 -122.43392260556999 (37.7507582372102, -122.43392260557)
26879 122163 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 557 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5991250.26553 2111589.08538 37.7775170853646 -122.473826110289 (37.7775170853646, -122.473826110289)
26900 124493 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3148 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995905.24735 2111438.77615 37.7773728899422 -122.45771219988 (37.7773728899422, -122.45771219988)
27033 213619 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 203 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5998052.82257 2096265.87803 37.7358350292576 -122.44918969537399 (37.7358350292576, -122.449189695374)
27374 237263 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 233 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005858.82097 2096143.67043 37.7359428633604 -122.422192568239 (37.7359428633604, -122.422192568239)
27648 214621 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1415 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992391.88162 2105788.8525099996 37.7616572533136 -122.469454599246 (37.7616572533136, -122.469454599246)
28327 95833 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Natoma St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/29/2011 12:00:00 AM 2 3x3 Permit Number 767565 6010212.70231 2112022.42286 37.7797869733249 -122.408258986859 (37.7797869733249, -122.408258986859)
28762 123988 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 9 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993914.451719999 2115450.72048 37.7882740365456 -122.464890390305 (37.7882740365456, -122.464890390305)
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)
29079 238214 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 173 Clipper St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004038.9586 2100983.92112 37.7491302628649 -122.428829515491 (37.7491302628649, -122.428829515491)
29090 238061 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 Montezuma St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007362.55888 2099757.0495599997 37.7459491035629 -122.417249508474 (37.7459491035629, -122.417249508474)
31074 237092 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600 15th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006640.82063 2107331.42339 37.766705953729 -122.420282681595 (37.766705953729, -122.420282681595)
31599 218216 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 130 Lenox Way 1 : 4 Tree 1 Private 1     2 Width 2ft   5993396.63989 2098589.94545 37.7419489172986 -122.465456597447 (37.7419489172986, -122.465456597447)
31693 119100 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 855 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5981674.98764 2109913.6134599997 37.772357483762704 -122.50682530453399 (37.7723574837627, -122.506825304534)
32323 214702 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Darien Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992979.91933 2094883.59777 37.7317481717454 -122.466628127212 (37.7317481717454, -122.466628127212)
32494 179102 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 135 Craut St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004051.16086 2094125.98713 37.730300632864896 -122.428298612397 (37.7303006328649, -122.428298612397)
33106 238440 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 701 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002273.481930001 2108783.68455 37.7704464445658 -122.43549244322901 (37.7704464445658, -122.435492443229)
33954 214718 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 120 Westgate Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993393.66752 2093805.3618400001 37.7288114697568 -122.465119441606 (37.7288114697568, -122.465119441606)
34079 239451 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 135 Swiss Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001309.11459 2096395.72955 37.736377283592 -122.437940733303 (37.736377283592, -122.437940733303)
35376 179161 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 233 Naylor St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6002647.79999 2086739.6543400001 37.7099398962889 -122.432622809119 (37.7099398962889, -122.432622809119)
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)
37093 238317 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 80 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6000563.230830001 2104921.8259099997 37.7597454565059 -122.441131080058 (37.7597454565059, -122.441131080058)
37368 213397 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2011 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991583.99315 2101696.28864 37.7503734254013 -122.47195043737301 (37.7503734254013, -122.471950437373)
37777 92608 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2524 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/2009 12:00:00 AM 2 3x3 Permit Number 52920 5990771.27794 2112015.60912 37.7786604478424 -122.47551422168101 (37.7786604478424, -122.475514221681)
37982 237111 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2x Coso Ave 7 Median : Yard 3 Tree 1 DPW 2     2     6007125.29232 2099860.06971 37.7462186223039 -122.418077248072 (37.7462186223039, -122.418077248072)
38000 214644 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993333.17302 2106942.2711 37.764878591599704 -122.466282908025 (37.7648785915997, -122.466282908025)
38004 238044 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 38 Dolores St 13 : 4 Tree 1 Private 1     2 Width 3ft   6004736.08926 2107889.20151 37.7681299654601 -122.426910555597 (37.7681299654601, -122.426910555597)
38835 119957 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 346 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5987171.5706 2113609.1286400002 37.7828264707534 -122.48808396026399 (37.7828264707534, -122.488083960264)
39340 238493 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1314 Castro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002509.40645 2101693.40172 37.750991638256295 -122.434169431668 (37.7509916382563, -122.434169431668)
39432 237070 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6007214.5669 2100609.67167 37.7482818846986 -122.41782167243 (37.7482818846986, -122.41782167243)
39978 196453 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950 Cesar Chavez St 7 : 4 Tree 1 Private 1     2 Width 3ft   6012987.92898 2101021.89129 37.749736965294794 -122.39788632150601 (37.7497369652948, -122.397886321506)
40093 238438 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 704 Waller St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002263.552630001 2108823.29827 37.7705546501166 -122.43552962300501 (37.7705546501166, -122.435529623005)
40213 213483 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 200 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994968.55628 2100619.47305 37.74761202648929 -122.460168457927 (37.7476120264893, -122.460168457927)
40304 196431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Utah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010634.804819999 2105805.21273 37.7627395712088 -122.40636055221701 (37.7627395712088, -122.406360552217)
40670 213401 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991567.73676 2101101.51332 37.7487393860095 -122.47196330756 (37.7487393860095, -122.47196330756)
41067 239466 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1476 Willard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5996878.53195 2106155.72843 37.762922869208495 -122.453963675406 (37.7629228692085, -122.453963675406)
41204 78480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 575 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/2000 12:00:00 AM 2     6001855.9620900005 2090141.3500299999 37.719235261989 -122.43560274687799 (37.719235261989, -122.435602746878)
41298 179046 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 179 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001233.0942400005 2093248.7296099998 37.727732024306796 -122.437978219718 (37.7277320243068, -122.437978219718)
41436 238247 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3837 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004009.69774 2105367.8329 37.761165794492506 -122.429243257591 (37.7611657944925, -122.429243257591)
41495 214526 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 845 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993056.887069999 2106598.6195099996 37.7639190698192 -122.46721351391899 (37.7639190698192, -122.467213513919)
42014 238507 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 540 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6003369.41114 2095637.2176700002 37.734411530166994 -122.430763315968 (37.734411530167, -122.430763315968)
42821 124018 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 222 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991848.751540001 2113924.91675 37.7839652833195 -122.471926053095 (37.7839652833195, -122.471926053095)
42855 213400 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991548.4151099995 2101099.1787400004 37.7487318577911 -122.472029950926 (37.7487318577911, -122.472029950926)
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)
43992 238062 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2 Montezuma St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007370.57854 2099757.5498 37.745950928290604 -122.417221812951 (37.7459509282906, -122.417221812951)
44011 214579 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1409 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991361.73298 2106537.8564299997 37.7636542311812 -122.473072054748 (37.7636542311812, -122.473072054748)
44300 179120 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009351.5528 2094781.0170099998 37.7323976980807 -122.41002058520701 (37.7323976980807, -122.410020585207)
44616 214708 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 300 San Benito Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992868.56396 2094867.3457099998 37.7316971208256 -122.46701192098101 (37.7316971208256, -122.467011920981)
45242 213576 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994554.1980800005 2099981.39248 37.7458361756945 -122.46155502007299 (37.7458361756945, -122.461555020073)
45985 84283 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 156 Tioga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM 2 3x3 Permit Number 50701 6010175.00365 2089148.86152 37.7169790922895 -122.40677692123501 (37.7169790922895, -122.406776921235)
46047 179127 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009957.2988599995 2092936.1916 37.727366129731294 -122.407796331556 (37.7273661297313, -122.407796331556)
47651 214645 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5993641.37954 2106958.7171099996 37.764941526166396 -122.46521810353201 (37.7649415261664, -122.465218103532)
48540 238462 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002872.0423099995 2108810.23213 37.7705533146101 -122.433423919803 (37.7705533146101, -122.433423919803)
49145 237242 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 467 Belvedere St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5998531.28643 2106457.3554 37.7638456860521 -122.448269115134 (37.7638456860521, -122.448269115134)
49260 213458 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5992978.54855 2099656.27544 37.7448526672074 -122.46697971536301 (37.7448526672074, -122.466979715363)
49316 123273 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 578 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5993791.71774 2111566.05198 37.7776007134003 -122.465032776868 (37.7776007134003, -122.465032776868)
49337 213548 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 140 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5996162.65905 2093980.6549 37.729452065849294 -122.455559574538 (37.7294520658493, -122.455559574538)
49350 237136 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1346 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 6ft   6010061.84572 2101335.33586 37.7504342222613 -122.40802698336901 (37.7504342222613, -122.408026983369)
49667 214777 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 36 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993930.07421 2101127.47655 37.7489470880465 -122.46379630688101 (37.7489470880465, -122.463796306881)
49737 214704 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 520 Darien Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5992936.67794 2094882.99637 37.7317440249531 -122.46677757652701 (37.7317440249531, -122.466777576527)
50305 213569 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995296.87532 2100197.80172 37.7464731016692 -122.459002630776 (37.7464731016692, -122.459002630776)
50571 214615 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1381 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5993310.7573 2106091.15894 37.7625403677758 -122.466298577838 (37.7625403677758, -122.466298577838)
50816 214567 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1550 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5990896.39166 2106586.0775 37.763759680286604 -122.47468502841299 (37.7637596802866, -122.474685028413)
50981 237277 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 530 Anderson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007819.187390001 2096382.7211200001 37.736709623536 -122.41543169892 (37.736709623536, -122.41543169892)
51380 213399 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 621 Quintara St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991532.61986 2101100.8826900003 37.74873562236029 -122.472084694454 (37.7487356223603, -122.472084694454)
51538 237417 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 767 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001578.47219 2099976.37294 37.7462242052793 -122.437265757933 (37.7462242052793, -122.437265757933)
52150 179154 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 374 Rolph St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001871.82658 2087846.75593 37.712935716983 -122.435383858181 (37.712935716983, -122.435383858181)
52836 213657 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 18 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994715.35615 2099021.32381 37.7432093423507 -122.46092819170099 (37.7432093423507, -122.460928191701)
52844 238224 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004109.39347 2102773.48647 37.754047977045396 -122.428713505628 (37.7540479770454, -122.428713505628)
53006 239400 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 338 Hoffman Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 3ft   6000612.89044 2101776.73481 37.751112629454106 -122.440733730797 (37.7511126294541, -122.440733730797)
53536 238225 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 Vicksburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004109.18497 2102785.07127 37.7540797743823 -122.428715052456 (37.7540797743823, -122.428715052456)
53796 237094 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600 15th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6006486.26316 2107324.29875 37.7666776808499 -122.420816764707 (37.7666776808499, -122.420816764707)
53913 213317 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 341 Howth St 1 : 4 Tree 1 Private 1     2 Width 3ft   5997142.77814 2090220.59605 37.7191840249054 -122.45190007034401 (37.7191840249054, -122.451900070344)
54329 213663 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Edgehill Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994711.26401 2098940.32402 37.7429867016817 -122.460936471749 (37.7429867016817, -122.460936471749)
54993 213486 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 266 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994659.1262300005 2100320.90612 37.74677443390021 -122.461216802127 (37.7467744339002, -122.461216802127)
55367 214651 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Hillway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5996116.3572 2106704.47478 37.7643858557403 -122.45663944446699 (37.7643858557403, -122.456639444467)
55478 238520 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 63 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002414.26728 2096581.70885 37.736950724596895 -122.434133053216 (37.7369507245969, -122.434133053216)
55693 238463 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 82 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002869.55426 2108831.69037 37.77061209250439 -122.43343405964599 (37.7706120925044, -122.433434059646)
55943 238340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 227 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6002088.29914 2104514.86028 37.7587147776761 -122.43582751174601 (37.7587147776761, -122.435827511746)
57276 213677 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 182 Lippard Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001809.23817 2095209.0401400002 37.7331473360722 -122.43612670538 (37.7331473360722, -122.43612670538)
58106 213327 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 331 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 10ft   5991934.3542 2090733.0516599999 37.7202914059971 -122.469940735003 (37.7202914059971, -122.469940735003)
58128 238075 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 539 Holly Park Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006266.954609999 2096259.9712599998 37.736285211897794 -122.42078973917499 (37.7362852118978, -122.420789739175)
59387 214520 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 955 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5992757.19823 2106588.47757 37.76387391848029 -122.468249300883 (37.7638739184803, -122.468249300883)
60177 239427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4146 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6001293.26785 2102923.46256 37.7542999913694 -122.43846307032301 (37.7542999913694, -122.438463070323)

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