Street_Tree_List

Data source: data.sfgov.org

340 rows where DBH = 5 and qSpecies = 18 sorted by qSiteInfo

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
2424 239429 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 565 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM 5 Width 2ft Permit Number 51470 6001213.70363 2103034.08129 37.7545991976029 -122.438746149019 (37.7545991976029, -122.438746149019)
3739 237154 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 861 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1992 12:00:00 AM 5 Width 6ft Permit Number 30833 6010197.69553 2104230.40256 37.7583910361238 -122.407761316458 (37.7583910361238, -122.407761316458)
12764 83412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 131 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/01/2009 12:00:00 AM 5 3x3 Permit Number 52320 6003991.38049 2093029.1643599998 37.727285619722295 -122.428427134505 (37.7272856197223, -122.428427134505)
13234 82735 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 174 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2012 12:00:00 AM 5 4x4 Permit Number 769757 6003803.82611 2092820.0296 37.726700767200896 -122.429060604385 (37.7267007672009, -122.429060604385)
13759 109718 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 91x Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6013027.725819999 2089252.6527099998 37.7174232872231 -122.396923644015 (37.7174232872231, -122.396923644015)
23939 179130 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009941.55337 2092988.7834299998 37.727509654348104 -122.40785447092199 (37.7275096543481, -122.407854470922)
24140 213364 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1256 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995501.45899 2106973.1472099996 37.765088237057206 -122.45878564505101 (37.7650882370572, -122.458785645051)
24527 214750 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 115 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995612.00037 2093456.6914400002 37.7279817741139 -122.457425350319 (37.7279817741139, -122.457425350319)
24566 239506 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 405 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008613.321269999 2096852.4753900003 37.738044069977605 -122.412719223109 (37.7380440699776, -122.412719223109)
24761 239379 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1045 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001966.9971 2100951.6663900004 37.7489242092946 -122.43599206429899 (37.7489242092946, -122.435992064299)
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)
26028 78318 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Colby St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 5 3x6   6008900.368419999 2091273.5690900001 37.722741693447105 -122.411332749116 (37.7227416934471, -122.411332749116)
26309 214582 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1301 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990775.418980001 2105160.42766 37.7598382161767 -122.47499935674 (37.7598382161767, -122.47499935674)
26412 237354 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1498 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008702.0539 2100646.6699900003 37.7484670721949 -122.412680580152 (37.7484670721949, -122.412680580152)
26611 239479 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 251 Alma St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997609.51363 2106133.00912 37.7629023727565 -122.45143383661001 (37.7629023727565, -122.45143383661)
26784 238156 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 716 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001753.21271 2102071.4405400003 37.7519866949399 -122.436811478876 (37.7519866949399, -122.436811478876)
26826 239412 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 615 27th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6002538.56212 2100033.91802 37.7464367420653 -122.433950001585 (37.7464367420653, -122.433950001585)
26947 213289 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 524 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995193.9429 2090587.80207 37.720080470027206 -122.45866297574301 (37.7200804700272, -122.458662975743)
27109 237439 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 660 Clipper St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001006.72174 2100905.12685 37.7487418231752 -122.439309355757 (37.7487418231752, -122.439309355757)
28192 213505 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 435 Montecito Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995673.53388 2093929.48913 37.7292834969286 -122.457246816911 (37.7292834969286, -122.457246816911)
28595 238397 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2236 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002628.54913 2107109.0712900003 37.765868526625 -122.43414453396099 (37.765868526625, -122.434144533961)
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)
31450 238199 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3980 24th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003307.887069999 2101869.812 37.7515213056834 -122.431420800429 (37.7515213056834, -122.431420800429)
31805 196440 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1400 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6014910.39402 2101173.59345 37.7502603851252 -122.391248908417 (37.7502603851252, -122.391248908417)
31890 237043 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1650 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009416.7221099995 2107184.85565 37.7664595394906 -122.410670920049 (37.7664595394906, -122.410670920049)
32455 118090 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 6909 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5985513.83516 2112457.38253 37.779567259959 -122.493734048085 (37.779567259959, -122.493734048085)
33345 238295 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4331 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001522.95996 2105232.46628 37.76065301904121 -122.437834106978 (37.7606530190412, -122.437834106978)
34053 239393 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4186 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001999.227390001 2101796.41317 37.7512455141744 -122.43594104846301 (37.7512455141744, -122.435941048463)
34754 238174 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4045 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002875.79226 2101798.6488099997 37.7513014097308 -122.43290995272801 (37.7513014097308, -122.432909952728)
35218 179144 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 27 Wayland St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6011384.73394 2092575.3064700002 37.7264550220761 -122.402836290783 (37.7264550220761, -122.402836290783)
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)
36554 120353 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2240 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 6ft   5988483.640819999 2114700.0523900003 37.7858982939261 -122.48362481032801 (37.7858982939261, -122.483624810328)
37641 214515 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1203 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992128.70606 2106565.35498 37.7637741108079 -122.47042136146601 (37.7637741108079, -122.470421361466)
38148 237309 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 211 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009018.3172 2097311.07667 37.739326012187 -122.411351334505 (37.739326012187, -122.411351334505)
38174 214754 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5995607.36531 2093372.70982 37.7277509145579 -122.457435300396 (37.7277509145579, -122.457435300396)
38439 238364 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 650 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003643.84732 2104453.78786 37.7586353270644 -122.430443357901 (37.7586353270644, -122.430443357901)
38826 237101 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Dearborn St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6005826.7194 2106021.63498 37.7630636778686 -122.423005419568 (37.7630636778686, -122.423005419568)
38861 239477 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 251 Alma St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997493.63796 2106118.1181400004 37.76285484988 -122.45183353400299 (37.76285484988, -122.451833534003)
38909 213410 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2251 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991507.31959 2100089.11073 37.745956094003404 -122.472098444193 (37.7459560940034, -122.472098444193)
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)
38958 238240 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 198 Hancock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003097.13649 2105073.6590299997 37.760306360067 -122.432378403045 (37.760306360067, -122.432378403045)
38966 239488 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 500 Andover St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007558.6613 2097161.9696299997 37.738834621714 -122.416387631511 (37.738834621714, -122.416387631511)
39188 214537 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 635 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993761.60534 2106621.85728 37.7640235296755 -122.464777811668 (37.7640235296755, -122.464777811668)
40352 214556 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1134 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992207.40042 2106631.63575 37.763960649997 -122.47015401102199 (37.763960649997, -122.470154011022)
40440 179026 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 376 Ordway St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010795.80251 2090029.68717 37.7194323753865 -122.40469308234199 (37.7194323753865, -122.404693082342)
40487 239545 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 98 Bennington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007158.6919599995 2097383.79915 37.7394212162163 -122.417786261644 (37.7394212162163, -122.417786261644)
40503 239548 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 229 Elsie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6006756.29841 2097775.0153900003 37.7404727557057 -122.419205308176 (37.7404727557057, -122.419205308176)
41563 214831 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 114 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996535.21399 2090645.46472 37.7203157965229 -122.45403084486999 (37.7203157965229, -122.45403084487)
41693 91420 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 770 18th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2009 12:00:00 AM 5 3x3 Permit Number 52101 5990400.3408699995 2110139.21584 37.7734868781795 -122.47666030039301 (37.7734868781795, -122.476660300393)
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)
41995 214691 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 369 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5994018.2022 2099672.39876 37.744956890555 -122.463385984879 (37.744956890555, -122.463385984879)
42755 178970 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008583.66239 2086910.8267599999 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132)
43586 238207 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3777 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003264.80394 2102992.67661 37.754601984619 -122.431649945898 (37.754601984619, -122.431649945898)
44104 213536 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Montecito Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5996026.04035 2094120.0100900002 37.729826861019 -122.456041946591 (37.729826861019, -122.456041946591)
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)
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)
44901 238395 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2265 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002497.14561 2107057.57077 37.765719660058 -122.43459534789 (37.765719660058, -122.43459534789)
45094 213387 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1818 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5993154.76021 2103068.62065 37.7542322625174 -122.466618400145 (37.7542322625174, -122.466618400145)
45195 179089 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6004232.136580001 2092904.6382099998 37.7269573195072 -122.427585973436 (37.7269573195072, -122.427585973436)
46303 135920 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2495 Filbert St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001110.697980001 2118617.5430900003 37.797381591353606 -122.440219818601 (37.7973815913536, -122.440219818601)
46384 214835 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 551 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5994751.30135 2092246.5764900001 37.7246096159288 -122.460313148958 (37.7246096159288, -122.460313148958)
46574 214676 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2690 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991464.73998 2097129.41713 37.737827068958204 -122.47202999139499 (37.7378270689582, -122.472029991395)
47802 238163 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3888 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002568.78071 2102996.86313 37.754574003112005 -122.434057276326 (37.754574003112, -122.434057276326)
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)
48211 73744 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/1996 12:00:00 AM 5     5995854.8721 2112478.1679599998 37.7802238906314 -122.45796169978998 (37.7802238906314, -122.45796169979)
48529 214705 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 365 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992551.259190001 2094363.4412599998 37.730295204541704 -122.46807225674699 (37.7302952045417, -122.468072256747)
48655 238097 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 954 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009388.543409999 2103614.69928 37.7566551233629 -122.410516257342 (37.7566551233629, -122.410516257342)
49020 213515 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 136 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995664.797590001 2093624.26858 37.7284449330771 -122.457254947662 (37.7284449330771, -122.457254947662)
49382 214518 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1115 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992295.0711900005 2106570.75423 37.7637985534841 -122.469846353829 (37.7637985534841, -122.469846353829)
50179 238196 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3976 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003363.68406 2101870.95339 37.7515276018353 -122.431227929123 (37.7515276018353, -122.431227929123)
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)
51106 179030 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 121 Tucker Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010311.02154 2088780.05452 37.715974033352 -122.406280800329 (37.715974033352, -122.406280800329)
51459 237355 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1490 Treat Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008699.155040001 2100670.9782 37.748533654421394 -122.41269232260001 (37.7485336544214, -122.4126923226)
51769 178969 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1029 Sunnydale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6008570.63643 2086915.27252 37.710756219889 -122.412164693966 (37.710756219889, -122.412164693966)
52416 238208 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3773 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003290.34471 2102990.62078 37.7545977874707 -122.43156147239701 (37.7545977874707, -122.431561472397)
52757 213426 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2341 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5991445.55169 2099460.12688 37.744225491721295 -122.472266184835 (37.7442254917213, -122.472266184835)
53191 102037 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3601X Jennings St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3 Permit Number 52501 6012999.572000001 2089254.628 37.7174271437906 -122.39702109783701 (37.7174271437906, -122.397021097837)
53778 239415 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1331 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6003277.56126 2100489.89633 37.7477306623461 -122.43142717303499 (37.7477306623461, -122.431427173035)
54119 237222 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3723 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004971.74704 2101913.37952 37.751735091610996 -122.425670064031 (37.751735091611, -122.425670064031)
54683 237231 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 156 Rivoli St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997890.32696 2105949.42746 37.762414379941 -122.450449370342 (37.762414379941, -122.450449370342)
56131 49551 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1084REVISED Howard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2003 12:00:00 AM 5   Permit Number 46441 6009968.28689 2111507.46699 37.7783593364429 -122.40906818514601 (37.7783593364429, -122.409068185146)
56137 239512 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 184 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008807.60125 2097692.07072 37.7403603179715 -122.41210681810101 (37.7403603179715, -122.412106818101)
56506 214706 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 365 Santa Ana Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992562.58655 2094392.71432 37.7303762352585 -122.468035225354 (37.7303762352585, -122.468035225354)
56890 178996 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Wanda St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6000569.64733 2091569.3239400003 37.72308300956121 -122.440151382899 (37.7230830095612, -122.440151382899)
56919 239433 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4 Carrie St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6002800.77676 2095592.1026 37.7342554213364 -122.43272604769399 (37.7342554213364, -122.432726047694)
56998 238518 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 218 Surrey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6002025.02718 2096169.5718200002 37.7357969924364 -122.43544935400699 (37.7357969924364, -122.435449354007)
57124 213298 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 769 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5994373.81571 2089911.00711 37.7181749819741 -122.461448817305 (37.7181749819741, -122.461448817305)
57767 196435 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2400 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6010616.04846 2105554.51436 37.7620501608016 -122.40640775851101 (37.7620501608016, -122.406407758511)
57997 237244 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 91 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5998158.2745 2107170.05749 37.7657812537214 -122.449610604152 (37.7657812537214, -122.449610604152)
58131 239544 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 91 Bennington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6007182.00683 2097328.45529 37.7392705662735 -122.41770172716801 (37.7392705662735, -122.417701727168)
58431 238422 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 39 Ord St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000862.680480001 2106132.31447 37.7630862130923 -122.440182239531 (37.7630862130923, -122.440182239531)
58542 43804 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 284 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2000 12:00:00 AM 5 6x5 Permit Number 43434 5988398.115730001 2114095.5575599996 37.7842335442368 -122.483876359267 (37.7842335442368, -122.483876359267)
58594 238191 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3920 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003665.42017 2101888.16596 37.7515919582256 -122.430185716505 (37.7515919582256, -122.430185716505)
58752 238229 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3827 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004278.21836 2101874.86861 37.7515901361879 -122.428065634918 (37.7515901361879, -122.428065634918)
59195 237324 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 141 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6009324.726 2096749.59433 37.7378014841462 -122.41025227214199 (37.7378014841462, -122.410252272142)
59270 238469 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 434 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003617.97734 2109021.6986599998 37.7711762417126 -122.430858818585 (37.7711762417126, -122.430858818585)
59880 238421 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 39 Ord St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6000861.2181 2106117.7165599996 37.7630460475704 -122.44018625051599 (37.7630460475704, -122.440186250516)
60427 88580 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 474 21st Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/2008 12:00:00 AM 5 3x3 Permit Number 51522 5989397.97956 2112106.21746 37.778829528805794 -122.480271570948 (37.7788295288058, -122.480271570948)
60883 68231 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 257 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/27/1993 12:00:00 AM 5   Permit Number 32026 5990849.231930001 2113671.85139 37.7832125496886 -122.475365506488 (37.7832125496886, -122.475365506488)

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