Street_Tree_List

Data source: data.sfgov.org

500 rows where qSiteInfo = 2 and qSpecies = 15

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 400 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
41907 41907 211927 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 145 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993219.3101 2096667.4089099998 37.736659885632704 -122.46593007882299 (37.7366598856327, -122.465930078823)
42112 42112 211890 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 33 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5992746.48615 2096899.9823599998 37.737271186301705 -122.467581729613 (37.7372711863017, -122.467581729613)
42376 42376 119573 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 341 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5986510.27034 2113543.4852 37.782607631800396 -122.49036691985901 (37.7826076318004, -122.490366919859)
42580 42580 211899 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 50 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   5992903.15569 2096794.06334 37.7369894035426 -122.46703235718 (37.7369894035426, -122.46703235718)
42642 42642 250966 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6542 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5986349.34208 2113940.89483 37.7836894041789 -122.490952908074 (37.7836894041789, -122.490952908074)
42823 42823 133438 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3699 Washington St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5997123.61634 2115669.84757 37.7890602094127 -122.453803103231 (37.7890602094127, -122.453803103231)
42866 42866 135103 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6010086.51333 2122398.36657 37.80826972922029 -122.40942800570299 (37.8082697292203, -122.409428005703)
43023 43023 133488 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 Spruce St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   5997064.99147 2115637.7546099997 37.7889687294832 -122.454003617874 (37.7889687294832, -122.454003617874)
43552 43552 238612 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4124 23rd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 3ft   6002325.43989 2102396.57167 37.7529119327637 -122.434855886005 (37.7529119327637, -122.434855886005)
43749 43749 211923 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 135 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   5993369.75745 2096567.1017 37.736393144928 -122.465402637242 (37.736393144928, -122.465402637242)
43776 43776 133317 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2800 Green St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   5999554.61404 2117752.57923 37.794917914796 -122.44554202175199 (37.794917914796, -122.445542021752)
43816 43816 134080 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2701 Pierce St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   6001585.13136 2117716.51533 37.794934604395706 -122.438513569051 (37.7949346043957, -122.438513569051)
43865 43865 218163 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1410 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 5ft   5993032.60064 2097530.3684400003 37.7390185834404 -122.466638316523 (37.7390185834404, -122.466638316523)
44213 44213 133315 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2800 Green St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5999586.754319999 2117755.95898 37.794929029509 -122.445431055296 (37.794929029509, -122.445431055296)
44501 44501 212771 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 49 Sola Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5994804.37376 2100763.43192 37.747997856333 -122.46074661856599 (37.747997856333, -122.460746618566)
45068 45068 135138 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009649.7092699995 2122468.55895 37.808437976201404 -122.410944649373 (37.8084379762014, -122.410944649373)
45098 45098 138817 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 725 Grove St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   6004365.9381 2111158.4731 37.777085652085795 -122.42842391857 (37.7770856520858, -122.42842391857)
45462 45462 211908 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 140 San Anselmo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 8ft   5993318.47057 2096556.76908 37.7363618161472 -122.46557920562401 (37.7363618161472, -122.465579205624)
45473 45473 238703 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 153 Highland Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6005805.52049 2096667.42175 37.737377961008896 -122.422414052383 (37.7373779610089, -122.422414052383)
45879 45879 133434 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3499 Washington St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5998080.637999999 2115804.23864 37.7894840329082 -122.450501639835 (37.7894840329082, -122.450501639835)
46016 46016 133283 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2800 Divisadero St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6000617.1223 2117994.59021 37.795643013872 -122.44188297894199 (37.795643013872, -122.441882978942)
46112 46112 134975 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2100 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6009928.574659999 2122361.54548 37.808159777214705 -122.409971995727 (37.8081597772147, -122.409971995727)
46336 46336 250260 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008585.75695 2112153.44443 37.7800554911055 -122.413896594858 (37.7800554911055, -122.413896594858)
46338 46338 211930 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5993491.51146 2102216.31715 37.751911483734006 -122.46539193081699 (37.751911483734, -122.465391930817)
46424 46424 250965 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6540 California St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986394.617190001 2113942.87838 37.7836974953865 -122.490796421524 (37.7836974953865, -122.490796421524)
46669 46669 211886 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 63 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5992960.04473 2096809.6715400002 37.7370355432472 -122.4668368023 (37.7370355432472, -122.4668368023)
46812 46812 182458 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1500 31st Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5986548.9803 2104767.4719 37.758513422441204 -122.489587443554 (37.7585134224412, -122.489587443554)
47067 47067 211960 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 265 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993488.382619999 2095510.5494799998 37.73349895569989 -122.464915795553 (37.7334989556999, -122.464915795553)
47872 47872 250281 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6008344.09456 2112135.7661599996 37.7799933758261 -122.414731365385 (37.7799933758261, -122.414731365385)
47889 47889 135126 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6009794.33207 2122480.55113 37.808479012257706 -122.410444987853 (37.8084790122577, -122.410444987853)
48102 48102 135159 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009379.72618 2122524.34495 37.8085760077391 -122.41188294806001 (37.8085760077391, -122.41188294806)
48351 48351 133509 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3599 Jackson St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5997087.31178 2115992.6513099996 37.7899444606189 -122.453952033671 (37.7899444606189, -122.453952033671)
48425 48425 120039 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5987565.05941 2110100.68571 37.7732162236667 -122.486464996708 (37.7732162236667, -122.486464996708)
48496 48496 211895 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 42 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5992673.51698 2096879.9592900001 37.737211994721704 -122.46783255953599 (37.7372119947217, -122.467832559536)
48608 48608 124162 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 951 Anza St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   5995744.87271 2112148.90226 37.7793134939309 -122.458318396526 (37.7793134939309, -122.458318396526)
48953 48953 238715 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 198 Appleton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6006193.2878 2096742.46627 37.7376058833953 -122.421078685037 (37.7376058833953, -122.421078685037)
49064 49064 133495 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 Spruce St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   5997079.70026 2115532.16413 37.788679649605896 -122.453945098999 (37.7886796496059, -122.453945098999)
49100 49100 238717 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 192 Appleton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6006147.39306 2096767.2042 37.7376712209412 -122.421239121397 (37.7376712209412, -122.421239121397)
49200 49200 135105 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6010067.690119999 2122402.63653 37.8082803987861 -122.409493450268 (37.8082803987861, -122.409493450268)
49467 49467 138833 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 745 BUCHANAN ST 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 0ft   6004458.1976 2111049.1657 37.7767907411066 -122.428096972449 (37.7767907411066, -122.428096972449)
50132 50132 238722 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 168 Appleton Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   6006009.52254 2096845.84918 37.737879388816 -122.421721390947 (37.737879388816, -122.421721390947)
50373 50373 133953 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2640 Broadway 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6001029.35919 2117263.89104 37.793660186827296 -122.440404139142 (37.7936601868273, -122.440404139142)
50658 50658 212775 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 272 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5993713.17033 2096341.04582 37.735792251198795 -122.46419891805 (37.7357922511988, -122.46419891805)
50784 50784 211937 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 49 Marcela Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5994739.96213 2100701.79555 37.7478249121935 -122.460964883138 (37.7478249121935, -122.460964883138)
51080 51080 250299 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 United Nations Plz 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6008402.94933 2112049.56006 37.7797599810866 -122.414521657841 (37.7797599810866, -122.414521657841)
51481 51481 238730 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 102 Appleton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   6005725.63877 2096998.88108 37.738283567534 -122.42271378923 (37.738283567534, -122.42271378923)
51845 51845 250272 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008485.20638 2112139.2449 37.780010855049 -122.414243440893 (37.780010855049, -122.414243440893)
51893 51893 211942 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 210 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   5993613.96365 2095942.7531599998 37.7346929199321 -122.46451300089599 (37.7346929199321, -122.464513000896)
52496 52496 211907 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 140 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   5993271.966130001 2096587.08569 37.736442375607794 -122.465742191567 (37.7364423756078, -122.465742191567)
52676 52676 195096 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 805 22nd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 5ft   6015449.373980001 2103905.82684 37.7577924167994 -122.38957586186199 (37.7577924167994, -122.389575861862)
52747 52747 135162 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009337.24139 2122533.99681 37.8086001257557 -122.41203066168998 (37.8086001257557, -122.41203066169)
53002 53002 134079 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2701 Pierce St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   6001581.43471 2117753.9287900003 37.795037121715104 -122.438529041908 (37.7950371217151, -122.438529041908)
53089 53089 133437 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3699 Washington St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5997143.78378 2115672.84462 37.7890695947259 -122.453733543379 (37.7890695947259, -122.453733543379)
53487 53487 120032 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 854 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 2ft   5987298.75417 2110090.52019 37.773172785402004 -122.487385423111 (37.773172785402, -122.487385423111)
54152 54152 135194 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 33 Bay St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   6010953.55365 2121723.39359 37.806464962561996 -122.40637977613301 (37.806464962562, -122.406379776133)
54261 54261 250302 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008493.92418 2112059.32847 37.7797919133004 -122.41420762629 (37.7797919133004, -122.41420762629)
54574 54574 238670 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 206 Palo Alto Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   5997584.930790001 2103890.70413 37.7567441598203 -122.45135712893601 (37.7567441598203, -122.451357128936)
54576 54576 133281 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2601 Baker St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   5999615.04263 2117803.60321 37.7950614627619 -122.445336601322 (37.7950614627619, -122.445336601322)
54635 54635 250961 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6538 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5986661.98827 2113952.34597 37.783739106117295 -122.489872127989 (37.7837391061173, -122.489872127989)
54968 54968 124442 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2 Edward St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5996053.7599 2111748.8774 37.7782328765774 -122.457220887918 (37.7782328765774, -122.457220887918)
54984 54984 250304 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4 United Nations Plz 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6008532.24811 2112064.35949 37.7798078798681 -122.414075402566 (37.7798078798681, -122.414075402566)
55037 55037 124171 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 951 Anza St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   5996216.82319 2112220.8979 37.7795382839639 -122.456690941181 (37.7795382839639, -122.456690941181)
55279 55279 250816 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 66 Sea View Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5986143.35026 2114166.31593 37.7842963089792 -122.491682151215 (37.7842963089792, -122.491682151215)
55510 55510 211946 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 230 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 4ft   5993605.73542 2095779.3177099999 37.7342436923742 -122.464529585292 (37.7342436923742, -122.464529585292)
55526 55526 211891 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 25 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 8ft   5992707.7708 2096909.12858 37.73729406415679 -122.467716250229 (37.7372940641568, -122.467716250229)
55569 55569 133486 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Spruce St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5997077.73236 2115875.669 37.789622709270894 -122.45397672545401 (37.7896227092709, -122.453976725454)
55939 55939 143028 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   6010783.2032 2120659.2378 37.8035335227011 -122.406894258002 (37.8035335227011, -122.406894258002)
56314 56314 135119 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6009951.286669999 2122420.2562 37.808322255030106 -122.40989754175399 (37.8083222550301, -122.409897541754)
56832 56832 135192 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 35 Bay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   6010823.80585 2121697.83678 37.806387530914 -122.406826991865 (37.806387530914, -122.406826991865)
56874 56874 135058 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 5ft   6010554.37876 2122187.95865 37.8077182047045 -122.407793978909 (37.8077182047045, -122.407793978909)
57187 57187 211955 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 290 San Anselmo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 4ft   5993309.844769999 2095438.0104200002 37.733289485612396 -122.46552777877899 (37.7332894856124, -122.465527778779)
57519 57519 201207 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 790 Folsom St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012455.0194 2113006.6214 37.7826146597246 -122.400570934911 (37.7826146597246, -122.400570934911)
57782 57782 211929 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1960 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993493.17539 2102180.3885 37.75181292883779 -122.46538356709401 (37.7518129288378, -122.465383567094)
58027 58027 143033 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 LOMBARD ST 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6010849.0879 2120667.4053 37.803559635028 -122.40666683581001 (37.803559635028, -122.40666683581)
58316 58316 201197 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   6012737.1706 2113278.7917 37.783377707887794 -122.39961392201401 (37.7833777078878, -122.399613922014)
58338 58338 120043 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 855 27th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 2ft   5987561.7468 2110191.3833 37.7734650607809 -122.48648311573 (37.7734650607809, -122.48648311573)
58351 58351 133571 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 200 Laurel St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5998062.22028 2115780.87502 37.7894188284574 -122.450563677765 (37.7894188284574, -122.450563677765)
58372 58372 211925 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 115 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5993291.36421 2096622.2118400002 37.73653994216279 -122.465677676 (37.7365399421628, -122.465677676)
58454 58454 250271 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008499.1431599995 2112156.4663299997 37.7800589238189 -122.41419644590799 (37.7800589238189, -122.414196445908)
58970 58970 135150 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009533.57548 2122492.01614 37.8084958709589 -122.41134822196301 (37.8084958709589, -122.411348221963)
59427 59427 211882 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 99 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   5993133.46797 2096720.62207 37.7368010432217 -122.466230735658 (37.7368010432217, -122.466230735658)
59578 59578 200809 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6012806.2688 2113339.4447 37.7835480984018 -122.39937912727501 (37.7835480984018, -122.399379127275)
59696 59696 134005 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2651 Green St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6000362.52365 2117817.67444 37.7951427389981 -122.442751223112 (37.7951427389981, -122.442751223112)
60061 60061 135166 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009296.71843 2122542.1924 37.8086203551155 -122.412171482933 (37.8086203551155, -122.412171482933)
60151 60151 250277 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 43 United Nations Plz 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 0ft   6008392.9818 2112142.72321 37.780015224857294 -122.41456273439199 (37.7800152248573, -122.414562734392)
60329 60329 124320 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 125 Jordan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5996195.05871 2113590.2363 37.783296874145 -122.45686530058201 (37.783296874145, -122.456865300582)
60783 60783 250954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 6532 California St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5987082.436980001 2113964.03529 37.7837957427146 -122.48841841257601 (37.7837957427146, -122.488418412576)
60800 60800 211968 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993650.102080001 2095813.5177 37.734340154581105 -122.464378679032 (37.7343401545811, -122.464378679032)
60882 60882 201626 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 401 Galvez Ave 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6021390.17472 2093479.1465200002 37.729490394945294 -122.36830984254298 (37.7294903949453, -122.368309842543)
61053 61053 135074 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   6010403.22449 2122267.85965 37.807929129896294 -122.408322726326 (37.8079291298963, -122.408322726326)
61096 61096 133492 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 201 Spruce St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 5ft   5997073.49595 2115580.84706 37.7888129641882 -122.453970082159 (37.7888129641882, -122.453970082159)
61438 61438 135060 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 5ft   6010535.39568 2122199.10611 37.8077477501305 -122.407860461315 (37.8077477501305, -122.407860461315)
61764 61764 201633 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 451 Galvez Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   6021837.4277 2093144.7538400001 37.7285967251547 -122.36674056154699 (37.7285967251547, -122.366740561547)
62281 62281 135072 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1401 The Embarcadero 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6010421.04395 2122258.5290599996 37.8079045082466 -122.408260398818 (37.8079045082466, -122.408260398818)
62434 62434 212776 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 199 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5993673.47282 2096359.92225 37.7358417930475 -122.464337536855 (37.7358417930475, -122.464337536855)
62743 62743 238613 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4124 23rd St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   6002316.14238 2102396.33354 37.7529107510333 -122.43488802147199 (37.7529107510333, -122.434888021472)
62798 62798 201195 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 700 Folsom St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   6012829.3016 2113361.7096 37.7836105163668 -122.399301005654 (37.7836105163668, -122.399301005654)
63098 63098 211910 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 160 San Anselmo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 8ft   5993413.89239 2096486.3053099997 37.7361738434551 -122.465244178503 (37.7361738434551, -122.465244178503)
63299 63299 133485 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Spruce St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5997070.63549 2115917.82612 37.7897380545196 -122.454004325646 (37.7897380545196, -122.454004325646)
63512 63512 124163 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 951 Anza St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5995786.60824 2112157.1253400003 37.7793384705457 -122.458174612166 (37.7793384705457, -122.458174612166)

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