Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51 sorted by PlantDate

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2079 181058 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5258 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   5999890.56935 2088656.9040700002 37.7150474825255 -122.442289836724 (37.7150474825255, -122.442289836724)
2511 246852 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 300 Broderick St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6001238.428669999 2109976.67902 37.7736632691848 -122.43915820668998 (37.7736632691848, -122.43915820669)
2885 205488 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1430 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 3ft   5990862.44739 2105654.74875 37.761200533507 -122.474734450646 (37.761200533507, -122.474734450646)
3661 253519 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 701 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6015696.1864 2103920.99342 37.7578477430893 -122.38872333331899 (37.7578477430893, -122.388723333319)
3809 95203 Planning Code 138.1 required 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 314 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 3x3 Permit Number 769992 5998598.6333800005 2115400.1597599997 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474)
4081 102392 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 30X Harriet St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6010436.41014 2111752.09711 37.7790572463352 -122.40746601596202 (37.7790572463352, -122.407466015962)
6520 121576 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3553-3555 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   5997856.717119999 2115116.32362 37.787582382260396 -122.451226746117 (37.7875823822604, -122.451226746117)
6718 97922 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2939 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000509.433540001 2118403.315 37.7967591273891 -122.442284956098 (37.7967591273891, -122.442284956098)
6827 100292 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3701 Buchanan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003061.81659 2121064.97367 37.804212487284005 -122.43364345509701 (37.804212487284, -122.433643455097)
8183 112515 Section 143 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2646 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6000218.93903 2118886.7143900003 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154)
8887 97923 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2939 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6000511.871719999 2118390.4696 37.7967239962744 -122.442275596851 (37.7967239962744, -122.442275596851)
9415 15943 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 5810X MISSION ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
9563 108596 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 36 Bronte St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344)
9705 110500 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9707 110499 Section 143 8 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
9708 110501 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900X JESSIE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
12406 27090 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 725 Silver Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2X3   6006149.91754 2093595.5123 37.7289625981285 -122.42100526258801 (37.7289625981285, -122.421005262588)
13559 106005 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 59 Reddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3 3x3   6013632.51665 2093922.487 37.7302793593954 -122.395160068985 (37.7302793593954, -122.395160068985)
13583 100891 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013606.47382 2111993.91964 37.7798981618967 -122.396516359044 (37.7798981618967, -122.396516359044)
14003 100882 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013366.225459999 2111763.75465 37.7792528084154 -122.397331345366 (37.7792528084154, -122.397331345366)
14258 100759 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 362 Brannan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6014440.04423 2112282.11717 37.780735840838396 -122.39365282322201 (37.7807358408384, -122.393652823222)
14420 27150 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1735 Silver Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6011122.20395 2095139.1072200001 37.73348002049129 -122.403924187157 (37.7334800204913, -122.403924187157)
14587 100888 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013550.27415 2111938.66795 37.7797433256341 -122.396706905611 (37.7797433256341, -122.396706905611)
14663 28516 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 117 06th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 4x4   6010207.243969999 2112381.64795 37.7807730152091 -122.40830321374901 (37.7807730152091, -122.408303213749)
15030 101775 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1700 Yosemite Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914)
15099 99592 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1855X Evans Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   6014373.22453 2099430.50237 37.7454443986533 -122.392984546922 (37.7454443986533, -122.392984546922)
15205 102387 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 84 Harriet St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6010709.4483199995 2111466.67522 37.778288823307 -122.406501343779 (37.778288823307, -122.406501343779)
15396 100890 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013579.59012 2111966.26913 37.779820743762606 -122.39660742352 (37.7798207437626, -122.39660742352)
15469 12131 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6016434.11275 2095220.18267 37.7339979769066 -122.38556488553499 (37.7339979769066, -122.385564885535)
15592 102388 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 90X Harriet St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   6010739.31321 2111434.0362400003 37.778200875001104 -122.406395729189 (37.7782008750011, -122.406395729189)
15713 100889 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013566.0867800005 2111954.86803 37.7797886874229 -122.396653338395 (37.7797886874229, -122.396653338395)
15863 100892 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013627.65977 2112013.31498 37.7799525960738 -122.396444426786 (37.7799525960738, -122.396444426786)
16098 100884 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 91 Welsh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6013403.42787 2111798.46493 37.7793501860944 -122.397205080544 (37.7793501860944, -122.397205080544)
16106 12141 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6016374.05041 2095443.42618 37.7346076354195 -122.38578809634899 (37.7346076354195, -122.385788096349)
18818 10127 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 892 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3x3   6005646.424 2103793.6441599997 37.7569359627397 -122.42347059841002 (37.7569359627397, -122.42347059841)
20345 5583 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1069 Dolores St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6005153.43733 2102137.63056 37.752361098006894 -122.42505770847299 (37.7523610980069, -122.425057708473)
21052 16925 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 512 Oak St 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW 2     25     6004419.62206 2110173.45228 37.7743840640969 -122.42816799305099 (37.7743840640969, -122.428167993051)
21591 27507 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1398 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X3   6005804.30319 2100875.6461400003 37.7489327240794 -122.42271723090799 (37.7489327240794, -122.422717230908)
22997 12121 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400X La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6016540.00349 2094984.34395 37.733356269266295 -122.38518235797899 (37.7333562692663, -122.385182357979)
23024 2316 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2263 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     5     6009682.41451 2104184.36513 37.7582357681755 -122.409540144857 (37.7582357681755, -122.409540144857)
23088 29 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 742 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 3X3   6003854.77769 2107764.13441 37.7677366901162 -122.42994999788799 (37.7677366901162, -122.429949997888)
23242 1673 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 200 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     4     5994963.861330001 2111486.70203 37.7774503572538 -122.460972213003 (37.7774503572538, -122.460972213003)
23334 8279 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1601 Galvez Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3x3   6015771.79311 2097687.24817 37.740735369454605 -122.388026849781 (37.7407353694546, -122.388026849781)
23708 242897 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2240 Bryant St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009615.11015 2104286.89095 37.7585135094078 -122.409780150527 (37.7585135094078, -122.409780150527)
23715 242332 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 206 28th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004510.161859999 2099597.97023 37.7453514204499 -122.42710138452101 (37.7453514204499, -122.427101384521)
23782 219426 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1426 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5991173.89859 2105672.02771 37.7612660194265 -122.473658544928 (37.7612660194265, -122.473658544928)
23892 180452 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008393.709980001 2091906.0725900002 37.724449984452704 -122.413128866997 (37.7244499844527, -122.413128866997)
24076 198405 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 155 Grace St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6008338.60303 2110264.2023400003 37.7748541981831 -122.414617883501 (37.7748541981831, -122.414617883501)
24196 198273 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 101 Pennsylvania Ave 39 Front Yard : Yard 7 Tree 1 Private 1     1     6014246.68754 2106694.7124400004 37.7653833298046 -122.393930504207 (37.7653833298046, -122.393930504207)
24235 217813 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 198 Lee Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5996579.91933 2091952.01212 37.7239058307663 -122.453970623549 (37.7239058307663, -122.453970623549)
25481 198281 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017868.75025 2099595.89007 37.7460920687928 -122.380908946009 (37.7460920687928, -122.380908946009)
25557 242876 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3298 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6005033.62978 2106658.32415 37.7647670900596 -122.425793770266 (37.7647670900596, -122.425793770266)
26251 116376 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 50x Madera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6012832.143680001 2103274.0879599997 37.7559123328161 -122.39858306046801 (37.7559123328161, -122.398583060468)
26433 198400 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 89 Harriet St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6010709.70909 2111519.6014400003 37.7784341609423 -122.406504172125 (37.7784341609423, -122.406504172125)
26512 242907 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 320 Lily St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6004859.69332 2110047.4287099997 37.774062923387795 -122.426636727297 (37.7740629233878, -122.426636727297)
26764 242331 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 206 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004526.0717 2099598.82102 37.74535465619329 -122.427046431465 (37.7453546561933, -122.427046431465)
27116 136928 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3835 Scott St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6000577.85991 2121479.43113 37.8052092229902 -122.442269124421 (37.8052092229902, -122.442269124421)
27257 198403 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 85 Harriet St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6010625.154180001 2111610.62913 37.778679370990204 -122.406803097794 (37.7786793709902, -122.406803097794)
27672 120104 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2651 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5987387.7348 2110475.1455200003 37.7742340474401 -122.48710588538201 (37.7742340474401, -122.487105885382)
28007 198263 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015429.86935 2107171.76588 37.7667588995269 -122.38987144293002 (37.7667588995269, -122.38987144293)
28474 198266 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015509.21403 2107176.39831 37.7667760190131 -122.389597324184 (37.7667760190131, -122.389597324184)
28616 198332 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 441 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010628.31321 2112645.1996400002 37.781520235806106 -122.406865104253 (37.7815202358061, -122.406865104253)
28847 198338 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 474 Natoma St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6010471.529619999 2112264.21742 37.7804653742171 -122.40738063611299 (37.7804653742171, -122.407380636113)
29033 123711 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 437 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994213.82065 2111401.8338099997 37.777174144242295 -122.46356067075199 (37.7771741442423, -122.463560670752)
29092 242342 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 50 Whitney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6004264.15883 2097942.68629 37.740792476382 -122.427834099074 (37.740792476382, -122.427834099074)
29241 180442 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008511.7814 2091523.97842 37.723407462461296 -122.412693709355 (37.7234074624613, -122.412693709355)
29284 198256 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 718 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6015417.87325 2105664.96075 37.762620874174104 -122.38980767650499 (37.7626208741741, -122.389807676505)
29317 217810 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 198 Lee Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5996576.41484 2091837.9853700001 37.7235925393546 -122.453974506819 (37.7235925393546, -122.453974506819)
29488 219440 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 142 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001119.093859999 2094963.2287700002 37.732433161058395 -122.438495108681 (37.7324331610584, -122.438495108681)
29751 219429 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900x Kirkham St 1 Median : Cutout 11 Tree 1 DPW 2     1 Width 4ft   5992085.46562 2105232.9931400004 37.7601132972171 -122.47047387378099 (37.7601132972171, -122.470473873781)
29811 180436 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6008572.212 2091322.68535 37.722858145766004 -122.412470589353 (37.722858145766, -122.412470589353)
30123 120689 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 598 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5989116.38632 2111294.87868 37.7765854515948 -122.48118627511299 (37.7765854515948, -122.481186275113)
30440 123815 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1951 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992581.39914 2112024.84953 37.7787905839512 -122.469253041386 (37.7787905839512, -122.469253041386)
30456 198402 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 85 Harriet St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010657.10977 2111573.60472 37.778579498568604 -122.406689940589 (37.7785794985686, -122.406689940589)
30819 123714 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 339 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5994520.39053 2111414.8777 37.7772276185203 -122.462501102485 (37.7772276185203, -122.462501102485)
30849 198285 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017793.32679 2099592.23757 37.7460778765941 -122.381169499371 (37.7460778765941, -122.381169499371)
30973 198274 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1236 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011932.48905 2102621.16084 37.7540693755115 -122.401648489597 (37.7540693755115, -122.401648489597)
31042 198387 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 120 Minna St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6011311.4774 2113337.57021 37.7834595257768 -122.404550424668 (37.7834595257768, -122.404550424668)
31158 198377 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 413 Minna St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6011450.02335 2113431.79039 37.7837259742093 -122.404077740098 (37.7837259742093, -122.404077740098)
31159 242866 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 98 McCoppin St 5 : 4 Tree 1 Private 1     1 Width 3ft   6006095.439119999 2109158.70233 37.7716924795429 -122.422298906788 (37.7716924795429, -122.422298906788)
31207 198409 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 50 Washburn St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6008437.7646 2110373.29523 37.7751593120891 -122.41428258206801 (37.7751593120891, -122.414282582068)
31564 242341 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1867 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6004609.18081 2097837.81117 37.7405240251544 -122.426633675907 (37.7405240251544, -122.426633675907)
31590 198270 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 101 Pennsylvania Ave 9 Front Yard : Yard 7 Tree 1 Private 1     1     6014327.719219999 2106393.16587 37.764559852075 -122.39362912521099 (37.764559852075, -122.393629125211)
31735 198284 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017813.21777 2099593.44192 37.74608228148 -122.381100801954 (37.74608228148, -122.381100801954)
31927 117672 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 7751 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   5982922.15587 2112497.69809 37.77952599164671 -122.502702614984 (37.7795259916467, -122.502702614984)
32025 242890 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2230 Bryant St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009606.26166 2104418.84355 37.7588753255595 -122.40982006693999 (37.7588753255595, -122.40982006694)
32167 198365 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 413 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6011243.08951 2113235.2529700003 37.7831747644438 -122.404779815658 (37.7831747644438, -122.404779815658)
32179 180406 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 23 Gorham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6002284.81507 2094188.8168099998 37.7303730435723 -122.43440959293999 (37.7303730435723, -122.43440959294)
32498 136953 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 685 North Point St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6007628.69919 2121609.81563 37.8059665519739 -122.41787801227 (37.8059665519739, -122.41787801227)
32694 104489 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 101X Arkansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6012893.40207 2106545.4722700003 37.7648982471715 -122.398600762736 (37.7648982471715, -122.398600762736)
32706 120106 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2651 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5987317.09594 2110472.8163099997 37.7742235329464 -122.487350063639 (37.7742235329464, -122.487350063639)
32720 198344 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 451 Tehama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6010981.61371 2112109.48263 37.780069044799106 -122.40560510460101 (37.7800690447991, -122.405605104601)
33652 180465 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 33 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008194.47669 2092552.7848 37.7262145316512 -122.413863317257 (37.7262145316512, -122.413863317257)
33703 117914 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 839 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5983220.24264 2110063.17362 37.7728590079713 -122.501491276363 (37.7728590079713, -122.501491276363)
33722 242337 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 157 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004758.7797 2102744.04826 37.754003877891606 -122.42646567447599 (37.7540038778916, -122.426465674476)
33820 198396 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 16 Moss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6010197.36501 2111335.28961 37.7778994078643 -122.408263568012 (37.7778994078643, -122.408263568012)
33823 136938 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1277 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008610.97542 2116946.31505 37.7932169703383 -122.41414853544201 (37.7932169703383, -122.414148535442)
33869 198258 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015275.05109 2107162.53945 37.766724978901 -122.390406293135 (37.766724978901, -122.390406293135)
33902 201660 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 130 Dore St 2 : 4 Tree 1 Private 1     3 Width 2ft   6009127.89234 2109540.91695 37.7729125385177 -122.411836435997 (37.7729125385177, -122.411836435997)
34285 242910 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 360 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6004800.5697 2110038.5843599997 37.774035296231105 -122.426840616201 (37.7740352962311, -122.426840616201)

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