Street_Tree_List

Data source: data.sfgov.org

889 rows where qSpecies = 20 sorted by SiteOrder

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24046 222589 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4384 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000100.50643 2105785.88471 37.762091580878604 -122.44279345615601 (37.7620915808786, -122.442793456156)
24143 221342 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 211 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6005048.208 2100165.37235 37.7469397877337 -122.425281276331 (37.7469397877337, -122.425281276331)
24841 175769 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
25555 175783 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 771 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006465.53434 2093625.53998 37.729062833884605 -122.419916279827 (37.7290628338846, -122.419916279827)
26245 204609 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1382 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5990541.2449199995 2105988.9613 37.7620995740555 -122.475869749413 (37.7620995740555, -122.475869749413)
27115 175782 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 769 Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6006531.05237 2093633.80708 37.729089224484795 -122.419690364741 (37.7290892244848, -122.419690364741)
27371 222562 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 190 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6007642.65731 2100277.00661 37.747392543349704 -122.416317784757 (37.7473925433497, -122.416317784757)
27384 39767 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 476 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/23/2000 12:00:00 AM 3 2x2 Permit Number 42916 6008173.90648 2113469.9166 37.7836470686025 -122.41541460189899 (37.7836470686025, -122.415414601899)
28171 221347 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 115 Bronte St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6009327.08226 2096770.42354 37.7378588087266 -122.41024559558001 (37.7378588087266, -122.41024559558)
28362 222576 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 471 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003000.71138 2105505.41806 37.7614863982993 -122.432742735495 (37.7614863982993, -122.432742735495)
28372 204655 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 452 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993265.60688 2090192.2995 37.7188834957636 -122.46529981143298 (37.7188834957636, -122.465299811433)
29109 222592 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 352 Hermann St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003592.38415 2108668.4276900003 37.7702047958459 -122.43092212997699 (37.7702047958459, -122.430922129977)
29332 61172 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 346 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1989 12:00:00 AM 11   Permit Number 27084 5989366.0565 2113024.18126 37.781348145965296 -122.480449215491 (37.7813481459653, -122.480449215491)
29365 222548 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 191 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6007220.93745 2097850.24968 37.740705488567706 -122.417604094958 (37.7407054885677, -122.417604094958)
30100 188310 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 189 Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6012910.658530001 2106249.7856099997 37.764087318611395 -122.39852032646499 (37.7640873186114, -122.398520326465)
30793 141963 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 841 LAGUNA ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6004850.8791 2111736.5633 37.7787003755045 -122.42678753375401 (37.7787003755045, -122.426787533754)
31017 222574 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 382 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6003928.91308 2102165.887 37.752369435600706 -122.429294326484 (37.7523694356007, -122.429294326484)
31367 204614 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1255 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5990910.22691 2105165.14407 37.7598589779192 -122.474533471065 (37.7598589779192, -122.474533471065)
31738 221360 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 184 Graystone Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999311.904680001 2104005.96159 37.757159364222495 -122.44539292943399 (37.7571593642225, -122.445392929434)
31785 124081 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 3220 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5993396.8995199995 2110067.15404 37.7734623682136 -122.46628961516399 (37.7734623682136, -122.466289615164)
32793 67326 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 714 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/15/1992 12:00:00 AM 12   Permit Number 30809 5993329.61616 2111427.9815700003 37.7771949529998 -122.466621290245 (37.7771949529998, -122.466621290245)
32795 204648 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 733 Plymouth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5995892.41562 2089491.7886299998 37.71711119551271 -122.456169405709 (37.7171111955127, -122.456169405709)
32947 222552 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 188 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6007202.63127 2097897.94559 37.740835420825206 -122.417670770702 (37.7408354208252, -122.417670770702)
33995 244917 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1350 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5999690.9856 2108819.5575 37.7703979319451 -122.444427856782 (37.7703979319451, -122.444427856782)
34144 71268 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1733 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/09/1989 12:00:00 AM 13     5999451.8492 2110818.1122 37.775871807627 -122.445398751236 (37.775871807627, -122.445398751236)
34236 188300 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 90 Kissling St 1 : 4 Tree 1 Private 1     7 Width 3ft   6008269.7706 2109537.20803 37.7728541761188 -122.41480452791001 (37.7728541761188, -122.41480452791)
34559 175753 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 755 London St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6000826.82092 2089512.30625 37.7174495420436 -122.439115030257 (37.7174495420436, -122.439115030257)
35496 204653 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 131 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5991405.61668 2090064.78105 37.718425920692795 -122.47171971360599 (37.7184259206928, -122.471719713606)
36392 44281 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1588 Newhall St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/2001 12:00:00 AM 7   Permit Number 43704 6014169.386469999 2095432.395 37.734455100518 -122.393409648353 (37.734455100518, -122.393409648353)
37729 247042 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 596 Valley St 1 Front Yard : Yard 7 Tree 1 Private 1     4     6002114.968169999 2099165.77298 37.7440289718731 -122.43535264990601 (37.7440289718731, -122.435352649906)
37998 221341 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 217 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005002.96321 2100161.85612 37.7469275767478 -122.42543747867201 (37.7469275767478, -122.425437478672)
38265 222573 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 3917 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6003673.95782 2101843.15091 37.7514688410299 -122.43015298120301 (37.7514688410299, -122.430152981203)
38724 204643 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 290 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995381.41136 2092014.7979700002 37.7240094335681 -122.458118187113 (37.7240094335681, -122.458118187113)
38894 50846 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 500 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/2004 12:00:00 AM 5   Permit Number 47372 6003324.61709 2090530.54695 37.720387218868495 -122.430553920527 (37.7203872188685, -122.430553920527)
39548 72980 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1730 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1999 12:00:00 AM 7     5987835.4413 2103488.2738 37.7550761133303 -122.48504448823499 (37.7550761133303, -122.485044488235)
40165 32579 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1247 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 5   Permit Number 37053 5985814.1748 2106726.0184 37.763848120851705 -122.49227291177401 (37.7638481208517, -122.492272911774)
40334 222553 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 184 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6007213.79342 2097921.72013 37.740901328538996 -122.417633860722 (37.740901328539, -122.417633860722)
41434 175767 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
41763 222502 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2 Camp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6005857.93432 2106390.78551 37.764079039426704 -122.42292369548599 (37.7640790394267, -122.422923695486)
41975 65113 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 363 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/1989 12:00:00 AM 10   Permit Number 27082 5989323.435380001 2112903.08855 37.781013182321104 -122.480587794991 (37.7810131823211, -122.480587794991)
41982 188330 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 214 Texas St 1 : 4 Tree 1 Private 1     13 Width 3ft   6013707.236830001 2106019.4851599997 37.763499309471506 -122.395749036807 (37.7634993094715, -122.395749036807)
42881 78349 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 741 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 4     5986607.90066 2110854.65361 37.7752305672016 -122.489831352395 (37.7752305672016, -122.489831352395)
43337 204651 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 27 Majestic Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5997399.75585 2089775.82239 37.7179774953307 -122.45097974552401 (37.7179774953307, -122.450979745524)
44057 175774 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
44147 188289 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 40 Sheridan St 1 : 4 Tree 1 Private 1     5 Width 3ft   6009413.38466 2109546.86827 37.772944891630104 -122.41084930056101 (37.7729448916301, -122.410849300561)
44455 222555 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 121 Coleridge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006651.1877 2098952.76416 37.743700669854796 -122.419652282953 (37.7437006698548, -122.419652282953)
45243 221339 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 451 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6002975.42772 2099463.08044 37.744894137656395 -122.43239860720699 (37.7448941376564, -122.432398607207)
45314 221329 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 92 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6010301.696169999 2100286.438 37.7475676053645 -122.407123632349 (37.7475676053645, -122.407123632349)
45511 221338 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 117 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6005011.955130001 2099285.1526 37.7445208578632 -122.425344007646 (37.7445208578632, -122.425344007646)
45600 57691 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 120 Conrad St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/13/1976 12:00:00 AM 8 3x3 Permit Number 16595 6001759.0 2096663.0 37.7371367196384 -122.436404416578 (37.7371367196384, -122.436404416578)
45681 49816 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 824 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2003 12:00:00 AM 12 3x3 Permit Number 46737 6012410.64537 2104168.1082 37.758343624767605 -122.400103532548 (37.7583436247676, -122.400103532548)
45847 43213 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 361 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 3   Permit Number 43004 6008709.78977 2094511.79844 37.7316224914874 -122.41222029725 (37.7316224914874, -122.41222029725)
46013 221321 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 76 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6005240.58146 2105045.63355 37.7603507164348 -122.424963229285 (37.7603507164348, -122.424963229285)
46438 38557 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1511 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/17/1998 12:00:00 AM 12   Permit Number 40522 6015824.3664 2095556.8722 37.7348887022439 -122.38769646850001 (37.7348887022439, -122.3876964685)
46539 221335 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1641 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6010542.34793 2100138.1982400003 37.7471740359465 -122.406281026071 (37.7471740359465, -122.406281026071)
46843 54597 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 630 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/1972 12:00:00 AM 19   Permit Number 10420 6014092.76415 2104176.14538 37.7584593387525 -122.394286543097 (37.7584593387525, -122.394286543097)
47450 125886 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 260 Willow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006255.845480001 2113363.12878 37.7832458630397 -122.42204278345699 (37.7832458630397, -122.422042783457)
47820 70445 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2471 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/1994 12:00:00 AM 5     5982997.1409 2098317.8833 37.740596640895795 -122.501394010052 (37.7405966408958, -122.501394010052)
47824 204629 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 223 Molimo Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 2ft   5997855.18506 2096638.3314 37.7368463906537 -122.449899836933 (37.7368463906537, -122.449899836933)
49781 222588 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4380 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000121.81513 2105788.1369 37.762098979601 -122.44271991951 (37.762098979601, -122.44271991951)
50304 221348 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 225 Bennington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6007116.4311 2096880.25923 37.7380362287807 -122.41789669659401 (37.7380362287807, -122.417896696594)
50384 43896 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 716 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM 6 3x3 Permit Number 51474 6009227.05246 2110468.55015 37.7754651643179 -122.411558979885 (37.7754651643179, -122.411558979885)
50558 70268 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 656 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 11     6002561.31186 2089826.6998700001 37.71841134000321 -122.43314215230801 (37.7184113400032, -122.433142152308)
50641 246815 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 182 Brewster St 1 : 4 Tree 1 Private 1     6 Width 2ft   6010185.45324 2098877.40442 37.74369220094071 -122.407426274006 (37.7436922009407, -122.407426274006)
50710 72270 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 619 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 5     6002965.14713 2089877.08907 37.7185725974338 -122.431749858784 (37.7185725974338, -122.431749858784)
50847 222571 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 593 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6001358.40825 2101420.45569 37.7501768003212 -122.43813013861099 (37.7501768003212, -122.438130138611)
52591 222563 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 184 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6007620.90266 2100266.50742 37.747362491591296 -122.41639226749201 (37.7473624915913, -122.416392267492)
52936 222568 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 34 Saint Marys Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004529.9479 2095570.0555900002 37.734292801673796 -122.426746177496 (37.7342928016738, -122.426746177496)
53234 188328 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1850 23rd St 1 : 4 Tree 1 Private 1     10 Width 2ft   6012921.09525 2102885.8261700002 37.754851205638204 -122.39824819520099 (37.7548512056382, -122.398248195201)
53675 222572 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 524 Elizabeth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6002965.6945400005 2102138.50273 37.7522396670301 -122.432623334298 (37.7522396670301, -122.432623334298)
53683 125881 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2101 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6001760.22052 2119747.88013 37.8005221579273 -122.438053316704 (37.8005221579273, -122.438053316704)
53944 221365 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1190 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6001927.1952 2100682.80135 37.748183708409 -122.43611046183099 (37.748183708409, -122.436110461831)
54422 204645 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 111 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5994132.807630001 2090689.3393400002 37.7202982210683 -122.462338293601 (37.7202982210683, -122.462338293601)
54695 52371 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 970JONES Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/2005 12:00:00 AM 6 3x3 Permit Number 48503 6008855.4568 2115649.67517 37.78967044259821 -122.41321087889901 (37.7896704425982, -122.413210878899)
55473 222549 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 199 Bocana St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6007198.14969 2097813.68298 37.740603802237295 -122.417680295405 (37.7406038022373, -122.417680295405)
56301 204608 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1563 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5990535.7174 2104763.29262 37.7587338945762 -122.47579935676399 (37.7587338945762, -122.475799356764)
57424 125888 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 575 Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6008045.66737 2113749.49498 37.784407514645096 -122.415878065725 (37.7844075146451, -122.415878065725)
58559 221337 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 26 Hidalgo Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   6004997.11684 2107512.5522 37.7671105326404 -122.425980872425 (37.7671105326404, -122.425980872425)
58940 107105 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 532 NOE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   6002950.4 2105092.9 37.760350869576705 -122.43288727007901 (37.7603508695767, -122.432887270079)
59363 222560 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1409 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008015.99739 2099911.75152 37.7464106212529 -122.415000947938 (37.7464106212529, -122.415000947938)
59966 188338 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1580 Newhall St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 4ft   6014174.61235 2095442.29815 37.7344825828894 -122.39339227343001 (37.7344825828894, -122.39339227343)
60191 188333 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 300 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 2ft   6013450.6432300005 2105637.1609900002 37.7624352541126 -122.396609715869 (37.7624352541126, -122.396609715869)
60387 35218 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 896 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/1998 12:00:00 AM 5   Permit Number 40401 6011658.1335 2112244.4696 37.780477493902204 -122.403274202035 (37.7804774939022, -122.403274202035)
60672 204624 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1830 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993464.78312 2103004.20884 37.7540732902536 -122.465541593278 (37.7540732902536, -122.465541593278)
61402 222561 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 380 Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008138.86201 2096500.51335 37.7370510178737 -122.414334773354 (37.7370510178737, -122.414334773354)
61469 181675 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2700 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5987341.4731 2106458.4895 37.763202728798106 -122.486970869844 (37.7632027287981, -122.486970869844)
61588 56137 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 767 Carolina St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/1973 12:00:00 AM 23   Permit Number 12241 6012457.22858 2104373.65416 37.7589106059655 -122.399956860327 (37.7589106059655, -122.399956860327)
61670 222577 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 4016 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   6002861.59805 2105354.01605 37.7610627942241 -122.433213052158 (37.7610627942241, -122.433213052158)
62010 188308 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 195 Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6012915.64836 2106174.8089400004 37.76388172727871 -122.398497806527 (37.7638817272787, -122.398497806527)
63204 204667 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 582 Mangels Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   5997581.48097 2095279.2111 37.7330989075759 -122.45074818359899 (37.7330989075759, -122.450748183599)
63595 181646 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1266 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986485.3888 2106651.0455 37.7636814828681 -122.489945903056 (37.7636814828681, -122.489945903056)
63668 175754 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 12 Farragut Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5997730.99268 2086963.4604 37.7102743532383 -122.449632264321 (37.7102743532383, -122.449632264321)
64059 52490 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 380 Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48600 6008167.536314401 2096496.40585448 37.7370413503065 -122.414235342537 (37.7370413503065, -122.414235342537)
64789 56717 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1526 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11     6015787.6443 2095659.5423 37.735168579406704 -122.387830592307 (37.7351685794067, -122.387830592307)
65031 204644 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 150 Ashton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994179.89282 2090937.7889 37.7209831150476 -122.46219354590099 (37.7209831150476, -122.462193545901)
67038 69446 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 443 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/16/1994 12:00:00 AM 10   Permit Number 33556 5985911.814680001 2112907.20872 37.7808256288006 -122.492390419974 (37.7808256288006, -122.492390419974)
67302 32207 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1760 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1995 12:00:00 AM 9   Permit Number 35529 6009303.23325 2099186.73635 37.7444921398121 -122.41049862882 (37.7444921398121, -122.41049862882)
67719 222596 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 73 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   6002296.29369 2096683.33913 37.73722308157 -122.43454820456002 (37.73722308157, -122.43454820456)
67811 42713 Permitted Site 1 Callistemon viminalis :: Weeping Bottlebrush 20 1740 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/2000 12:00:00 AM 8   Permit Number 42726 6014522.39227 2095210.25322 37.7338647513416 -122.392173650716 (37.7338647513416, -122.392173650716)
67823 246058 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 610 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5997562.1198 2108443.0956 37.769242567665295 -122.451764409004 (37.7692425676653, -122.451764409004)

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