Street_Tree_List

Data source: data.sfgov.org

479 rows where qSiteInfo = 2 and qSpecies = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 479 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
854 854 203901 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 3794 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
2211 2211 188595 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Rhode Island St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   07/05/2017 12:00:00 AM 3 Width 7ft   6011997.611930001 2102271.8897 37.7531139870419 -122.401398733477 (37.7531139870419, -122.401398733477)
13306 13306 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 5 2072 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
23402 23402 123384 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 735 03rd Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5995024.54572 2110548.53973 37.7748779041184 -122.460694283234 (37.7748779041184, -122.460694283234)
23448 23448 121887 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 50 18th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5990232.62779 2114784.35142 37.78623140306821 -122.47758002792801 (37.7862314030682, -122.477580027928)
23761 23761 123510 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2714 Fulton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 8ft   5994935.84099 2110268.0504400004 37.774102650784 -122.460980795496 (37.774102650784, -122.460980795496)
24278 24278 183048 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2600 20th Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5990217.9332 2097368.8862 37.7384123615974 -122.47635825040301 (37.7384123615974, -122.476358250403)
24378 24378 124854 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 55 Casa Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6001534.02589 2121572.74926 37.8055198982766 -122.438966893034 (37.8055198982766, -122.438966893034)
24386 24386 125162 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2667 Vallejo St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6000844.12478 2117536.98502 37.7943994826029 -122.441064665996 (37.7943994826029, -122.441064665996)
24641 24641 203805 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 San Marcos Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 4ft   5993891.16391 2100082.05221 37.7460743755414 -122.463854985838 (37.7460743755414, -122.463854985838)
24760 24760 188680 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Middle Point Rd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6018245.47476 2096448.1212400002 37.7374697107694 -122.37938765012501 (37.7374697107694, -122.379387650125)
25026 25026 124921 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 125 Maple St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5996572.93556 2115696.21149 37.789101010747 -122.455710282907 (37.789101010747, -122.455710282907)
25388 25388 203818 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1615 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5993134.0104 2095339.6445 37.7330092541688 -122.466128535825 (37.7330092541688, -122.466128535825)
25518 25518 203700 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 75 Farnsworth Ln 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   5996532.95426 2106404.6778599997 37.7635866003516 -122.455176893212 (37.7635866003516, -122.455176893212)
25629 25629 123514 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2744 Fulton St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5994834.09227 2110246.18844 37.7740367681104 -122.461331174398 (37.7740367681104, -122.461331174398)
25674 25674 218195 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1365 Portola Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   5993371.5777900005 2097679.7437299998 37.7394482867046 -122.46547714694599 (37.7394482867046, -122.465477146946)
26244 26244 187704 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   6013733.429690001 2087045.5271 37.7114022110065 -122.394329886826 (37.7114022110065, -122.394329886826)
26389 26389 205121 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1251 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5994202.93264 2097870.50509 37.7400199830445 -122.462616542022 (37.7400199830445, -122.462616542022)
26453 26453 124643 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Arguello Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 3ft   5995522.3743900005 2115756.08929 37.7892050736096 -122.459349404637 (37.7892050736096, -122.459349404637)
26454 26454 188657 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 123 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6016750.167669999 2099204.87087 37.744956608177205 -122.38474966268801 (37.7449566081772, -122.384749662688)
26470 26470 125163 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2667 Vallejo St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   6000855.2875 2117538.5038 37.7944042885745 -122.44102615076099 (37.7944042885745, -122.441026150761)
26510 26510 182982 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2500 20th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 0ft   5990198.1355 2098062.4817 37.7403156480562 -122.47647735467599 (37.7403156480562, -122.476477354676)
26622 26622 205143 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 30 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5994052.7239 2101916.59991 37.751120887023895 -122.463429445513 (37.7511208870239, -122.463429445513)
26768 26768 203786 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 09th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   5993506.591630001 2101771.6935400004 37.7506915308916 -122.465307488051 (37.7506915308916, -122.465307488051)
26839 26839 204003 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5993686.91421 2097806.1272299998 37.7398134860985 -122.464396034156 (37.7398134860985, -122.464396034156)
26891 26891 203788 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 09th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 6ft   5993504.43454 2101812.32675 37.7508029748893 -122.465317898622 (37.7508029748893, -122.465317898622)
26896 26896 123340 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 707 04th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5994708.91585 2110680.4557 37.7752219458277 -122.461795672579 (37.7752219458277, -122.461795672579)
27032 27032 203761 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1701 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 5ft   5991748.48888 2096138.80576 37.73512351624029 -122.470976798948 (37.7351235162403, -122.470976798948)
27387 27387 187706 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6013695.628330001 2087031.1132200002 37.7113605319472 -122.394459530409 (37.7113605319472, -122.394459530409)
27663 27663 174978 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 861 Lisbon St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 6ft   6001016.58593 2088794.32712 37.7154889282344 -122.43840769096799 (37.7154889282344, -122.438407690968)
28123 28123 220224 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 62 Carmel St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5998625.21868 2105405.54522 37.7609630486351 -122.447868504035 (37.7609630486351, -122.447868504035)
28148 28148 221373 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 653 Sanchez St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6003694.53347 2104497.08534 37.7587570827045 -122.430271151217 (37.7587570827045, -122.430271151217)
28185 28185 203813 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 60 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 4ft   5993917.658419999 2101338.69255 37.749526317999795 -122.46385456944701 (37.7495263179998, -122.463854569447)
28294 28294 188658 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 124 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6016703.96276 2099238.37904 37.7450460592258 -122.384911766374 (37.7450460592258, -122.384911766374)
28392 28392 220289 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 300 Virginia Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6006929.46462 2098339.11421 37.742031395942 -122.41864655850901 (37.742031395942, -122.418646558509)
28682 28682 220133 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 751 Dolores St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 6ft   6005049.364440001 2103949.71117 37.7573307687038 -122.42554656283501 (37.7573307687038, -122.425546562835)
29026 29026 204002 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1301 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5993726.75775 2097804.5817 37.739811539083796 -122.464258160896 (37.7398115390838, -122.464258160896)
29428 29428 203810 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 47 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   5993892.4495 2101209.214 37.7491693500911 -122.463932344596 (37.7491693500911, -122.463932344596)
29489 29489 218126 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 17 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   5994158.0804 2100834.77067 37.7481565281971 -122.462986632842 (37.7481565281971, -122.462986632842)
29568 29568 247533 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1101 Waller St 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6000119.08328 2108491.6907099998 37.769522108775 -122.44292352241501 (37.769522108775, -122.442923522415)
30175 30175 203844 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 475 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995208.98293 2098195.24807 37.74096953491 -122.45916156705401 (37.74096953491, -122.459161567054)
30340 30340 124896 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3757 Washington St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5996809.08847 2115624.77841 37.788918424105795 -122.45488806513 (37.7889184241058, -122.45488806513)
30419 30419 124070 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 501 Funston Ave 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5991895.55651 2111444.2784599997 37.7771568387438 -122.47158330000201 (37.7771568387438, -122.471583300002)
30514 30514 188756 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 151 Executive Park Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6013935.51575 2087041.28736 37.711401800917 -122.393631123501 (37.711401800917, -122.393631123501)
30886 30886 203804 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 San Marcos Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 4ft   5993878.73057 2100098.05602 37.746117601451104 -122.463899139836 (37.7461176014511, -122.463899139836)
31128 31128 125181 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2401 Broadway 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 4ft   6002076.54699 2117350.16777 37.793956650132706 -122.436786965158 (37.7939566501327, -122.436786965158)
32044 32044 218190 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1401 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5993083.56044 2097460.2146099997 37.738828899343204 -122.466457024875 (37.7388288993432, -122.466457024875)
32101 32101 122195 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 57 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 7ft   5991459.5618199995 2114871.1888599996 37.786540956413205 -122.47334153385799 (37.7865409564132, -122.473341533858)
32864 32864 218189 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1421 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 5ft   5993057.32079 2097427.16876 37.7387366495817 -122.46654534729299 (37.7387366495817, -122.466545347293)
32957 32957 217756 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 West Portal Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5991795.2978300005 2096615.5612700002 37.7364352736738 -122.47084968247299 (37.7364352736738, -122.470849682473)
33135 33135 182986 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2500 20th Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 0ft   5990190.0134 2098292.9469 37.7409479749381 -122.476522269354 (37.7409479749381, -122.476522269354)
33179 33179 205144 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 3ft   5994040.666780001 2101956.54336 37.7512298668798 -122.463474038404 (37.7512298668798, -122.463474038404)
33379 33379 203776 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1519 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 4ft   5992455.01955 2096844.76822 37.737102749576295 -122.468585438685 (37.7371027495763, -122.468585438685)
33920 33920 203778 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1529 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5992369.0893 2096762.72523 37.736872515956705 -122.468876567225 (37.7368725159567, -122.468876567225)
33960 33960 125206 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2006 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6005017.11491 2116813.45375 37.7926496501144 -122.42657406704599 (37.7926496501144, -122.426574067046)
34318 34318 125190 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2809 Buchanan St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6003477.09721 2118091.6097 37.7960719563118 -122.431993895221 (37.7960719563118, -122.431993895221)
34628 34628 188726 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   6014282.88696 2086958.43171 37.7111935916762 -122.39242471805001 (37.7111935916762, -122.39242471805)
35032 35032 203989 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 665 Faxon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 3ft   5994872.64121 2092622.4417599998 37.725648630558 -122.45992091053999 (37.725648630558, -122.45992091054)
35050 35050 250805 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 279 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   5986180.52669 2114067.55703 37.784027318145 -122.491546263649 (37.784027318145, -122.491546263649)
35748 35748 124820 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 290 Cervantes Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6000687.14631 2121612.80249 37.805581652937896 -122.44190050493 (37.8055816529379, -122.44190050493)
35933 35933 188732 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6014643.15959 2086929.06971 37.7111329692742 -122.391177465365 (37.7111329692742, -122.391177465365)
35985 35985 203237 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5995777.03066 2100174.8002400002 37.7464375352614 -122.457340653955 (37.7464375352614, -122.457340653955)
36400 36400 124903 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3799 Washington St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   5996683.61318 2115609.94285 37.7888704911189 -122.45532111749901 (37.7888704911189, -122.455321117499)
36572 36572 125283 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1022 Vallejo St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19     6008553.3357 2118652.52979 37.797898577410706 -122.414468760628 (37.7978985774107, -122.414468760628)
37352 37352 124900 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3799 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   5996734.39445 2115617.1831099996 37.7888932844445 -122.455145945735 (37.7888932844445, -122.455145945735)
37940 37940 220243 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1435 Douglass St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 2ft   6001404.3339599995 2099524.15777 37.7449726286816 -122.437835521604 (37.7449726286816, -122.437835521604)
38597 38597 123332 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 737 04th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5994713.86391 2110546.24566 37.7748537255052 -122.461768822817 (37.7748537255052, -122.461768822817)
38609 38609 188748 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   6013906.67984 2086991.4991 37.7112634896854 -122.39372730596399 (37.7112634896854, -122.393727305964)
38647 38647 122188 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 9 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 7ft   5991455.25466 2115068.89976 37.7870835661247 -122.473370861161 (37.7870835661247, -122.473370861161)
38872 38872 205131 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1261 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5994543.00751 2097885.11 37.740079663839396 -122.461441770226 (37.7400796638394, -122.461441770226)
38970 38970 123388 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 711 03rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 4ft   5995021.55418 2110687.0257 37.7752579778238 -122.460714669617 (37.7752579778238, -122.460714669617)
39003 39003 174984 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1005 Madrid St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 4ft   6001116.49451 2088434.7952400001 37.7145074162652 -122.438036624391 (37.7145074162652, -122.438036624391)
39168 39168 203797 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 459 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5993806.730690001 2101751.7911400003 37.7506541883464 -122.46426814517599 (37.7506541883464, -122.464268145176)
39206 39206 125212 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2010 Washington St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6004876.33851 2116792.20983 37.7925833601806 -122.427059645199 (37.7925833601806, -122.427059645199)
39262 39262 221370 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 675 Sanchez St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   6003706.223180001 2104404.27248 37.758502902814605 -122.430224101377 (37.7585029028146, -122.430224101377)
39522 39522 221393 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 19 Short St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   6000071.20975 2104148.07597 37.757592891423705 -122.442777172152 (37.7575928914237, -122.442777172152)
39596 39596 205119 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 60 Santa Monica Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 3ft   5993716.65626 2097340.34007 37.7385362653418 -122.46425939206001 (37.7385362653418, -122.46425939206)
39716 39716 203826 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1477 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 4ft   5992726.669869999 2097075.17992 37.737751090641396 -122.467662980681 (37.7377510906414, -122.467662980681)
39878 39878 205142 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 36 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5994062.584840001 2101897.71543 37.7510696031844 -122.463393975348 (37.7510696031844, -122.463393975348)
39955 39955 203806 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 San Marcos Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5993903.6097099995 2100066.65342 37.746032811564795 -122.463810832713 (37.7460328115648, -122.463810832713)
40033 40033 123387 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 717 03rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5995022.2555599995 2110652.6076700003 37.7751635153787 -122.46070974861999 (37.7751635153787, -122.46070974862)
40037 40037 218131 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 24 Lopez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 0ft   5994065.43015 2100781.9542900003 37.74800617055929 -122.463303179825 (37.7480061705593, -122.463303179825)
40058 40058 203815 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 52 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 4ft   5993928.07646 2101267.78247 37.7493322173128 -122.463813397578 (37.7493322173128, -122.463813397578)
40092 40092 125208 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2006 Washington St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6004975.93089 2116805.94473 37.7926267039054 -122.426716030424 (37.7926267039054, -122.426716030424)
40250 40250 188750 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 150 Executive Park Blvd 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 3ft   6014131.496280001 2086972.33958 37.7112233718385 -122.39294893824801 (37.7112233718385, -122.392948938248)
40316 40316 220130 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 420 Dolores St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6004868.33246 2105707.1608700003 37.7621460797944 -122.42629776564199 (37.7621460797944, -122.426297765642)
41902 41902 187705 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 51 Executive Park Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6013715.36859 2087039.19615 37.711383823464104 -122.394391868106 (37.7113838234641, -122.394391868106)
42001 42001 188730 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 250 Executive Park Blvd 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6014544.34623 2086934.52337 37.7111424598152 -122.39151937233 (37.7111424598152, -122.39151937233)
42043 42043 188631 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 101 Charter Oak Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     6010953.30174 2096155.7818599998 37.7362621559727 -122.404579676927 (37.7362621559727, -122.404579676927)
42156 42156 124996 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 233 Cervantes Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 2ft   6000861.45694 2121438.45328 37.8051128678164 -122.441284762493 (37.8051128678164, -122.441284762493)
42389 42389 203234 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 3ft   5994034.24105 2100880.02581 37.7482736532082 -122.463418145541 (37.7482736532082, -122.463418145541)
42467 42467 122191 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 33 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 7ft   5991455.42177 2114972.80191 37.7868197178511 -122.47336327131501 (37.7868197178511, -122.473363271315)
42695 42695 188606 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1150 19th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   6014179.73832 2105282.17122 37.761501079734 -122.3940631731 (37.761501079734, -122.3940631731)
43572 43572 250846 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 232 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 4ft   5986528.43338 2114238.12689 37.784515979183205 -122.490355201546 (37.7845159791832, -122.490355201546)
43742 43742 124919 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 125 Maple St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5996564.36921 2115728.48041 37.7891891209281 -122.455742254727 (37.7891891209281, -122.455742254727)
43942 43942 203975 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 380 Santa Clara Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 3ft   5993162.43396 2095420.1144400002 37.7332318444753 -122.466036114303 (37.7332318444753, -122.466036114303)
44518 44518 221376 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 653 Sanchez St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   6003698.336519999 2104516.5748900003 37.7588108117755 -122.430259388974 (37.7588108117755, -122.430259388974)
44586 44586 125019 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 135 Marina Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6002839.24225 2121472.8453599997 37.8053197640715 -122.43444286966499 (37.8053197640715, -122.434442869665)
44602 44602 203730 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2340 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 4ft   5992344.21794 2099488.56945 37.7443555561562 -122.469160888787 (37.7443555561562, -122.469160888787)
44619 44619 203266 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 3ft   5995209.57464 2099663.22163 37.7450002594644 -122.45926579939 (37.7450002594644, -122.45926579939)

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