Street_Tree_List

Data source: data.sfgov.org

9,170 rows where qSiteInfo = 2 sorted by XCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▲ YCoord Latitude Longitude Location
160306 160306 198282 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017853.17114 2099595.49021 37.74609011098 -122.38096278932301 (37.74609011098, -122.380962789323)
74955 74955 198283 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017833.27301 2099593.92963 37.7460847276446 -122.381031486718 (37.7460847276446, -122.381031486718)
31735 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)
30849 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)
55610 55610 198286 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017773.62926 2099591.7423799997 37.7460754295565 -122.381237577149 (37.7460754295565, -122.381237577149)
138563 138563 108589 Significant Tree 6 Tree(s) :: 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6017760.0 2094672.0 37.732566047797704 -122.38094273978099 (37.7325660477977, -122.380942739781)
38795 38795 198287 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017753.37339 2099590.18904 37.7460700461913 -122.38130751204399 (37.7460700461913, -122.381307512044)
65432 65432 198288 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017733.321719999 2099589.8795 37.7460680892801 -122.3813768273 (37.7460680892801, -122.3813768273)
182337 182337 201470 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Catalina St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017720.50763 2095978.01132 37.7361499169812 -122.381170049779 (37.7361499169812, -122.381170049779)
170643 170643 198289 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017712.53976 2099588.87163 37.746064174537004 -122.381448619273 (37.746064174537, -122.381448619273)
24903 24903 201466 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301 Catalina St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017699.909990001 2096021.8364 37.7362691149141 -122.38124431128 (37.7362691149141, -122.38124431128)
36013 36013 201469 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Catalina St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017698.8541 2095974.10398 37.7361379928748 -122.381244644042 (37.7361379928748, -122.381244644042)
67092 67092 198290 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017692.8350599995 2099588.0199599997 37.746060748120705 -122.381516697036 (37.7460607481207, -122.381516697036)
180128 180128 201468 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Catalina St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6017677.66407 2095970.41595 37.7361266964906 -122.381317651001 (37.7361266964906, -122.381317651001)
131704 131704 198291 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017672.75114 2099586.10688 37.746054386310796 -122.38158601229601 (37.7460543863108, -122.381586012296)
129658 129658 201467 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 301 Catalina St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   6017657.01116 2096011.92919 37.7362395434261 -122.381391943098 (37.7362395434261, -122.381391943098)
37378 37378 198292 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017651.2465699995 2099584.75723 37.7460494930826 -122.381660279195 (37.7460494930826, -122.381660279195)
57835 57835 198293 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017632.06769 2099583.36051 37.746044598982 -122.381726500798 (37.746044598982, -122.381726500798)
57758 57758 198294 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017591.2197 2099581.33021 37.7460367685821 -122.381867608025 (37.7460367685821, -122.381867608025)
73875 73875 198295 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017570.97457 2099580.31165 37.746032853833206 -122.38193754289101 (37.7460328538332, -122.381937542891)
53948 53948 198296 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017552.343280001 2099579.4388200003 37.7460294283132 -122.382001907384 (37.7460294283132, -122.382001907384)
183395 183395 198297 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017533.81233 2099583.55419 37.7460397048816 -122.382066271836 (37.7460397048816, -122.382066271836)
172019 172019 198298 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017519.7761 2099586.1475400003 37.7460460504973 -122.38211498813601 (37.7460460504973, -122.382114988136)
147691 147691 198299 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017490.49598 2099601.17912 37.746085707003004 -122.38221728150499 (37.746085707003, -122.382217281505)
36796 36796 192719 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1423 Ingalls St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   6017105.54794 2093739.1329299998 37.729968434997204 -122.383140454481 (37.7299684349972, -122.383140454481)
178373 178373 192718 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1423 Ingalls St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   6017094.51562 2093725.2995 37.729929841478295 -122.38317763244 (37.7299298414783, -122.38317763244)
32003 32003 192717 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1423 Ingalls St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   6017071.066459999 2093695.6527900002 37.729847141614 -122.38325663697799 (37.729847141614, -122.383256636978)
175311 175311 194985 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2 Progress St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 4ft   6017047.98136 2094998.67285 37.7334237013335 -122.383427116962 (37.7334237013335, -122.383427116962)
151664 151664 187723 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 57 Progress St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 4ft   6016846.42344 2095098.5772 37.733686877130204 -122.384130920999 (37.7336868771302, -122.384130920999)
183672 183672 200636 Undocumented 2 :: 54 1301 Quesada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 0ft   6016782.3625 2093458.8747 37.729181036936396 -122.384238246013 (37.7291810369364, -122.384238246013)
56563 56563 188656 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100 Cargo Way 122 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6016757.253769999 2099196.6677 37.7449344758533 -122.384724588679 (37.7449344758533, -122.384724588679)
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)
66792 66792 188540 Undocumented 2 Acacia decurrens :: Acacia: Silver Wattle 181 701 Terry A Francois Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6016727.21777 2107625.64787 37.7680770223524 -122.38541572217599 (37.7680770223524, -122.385415722176)
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)
155152 155152 190988 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 119 Lindsay Cir 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 5ft   6016552.3921 2095641.6616099998 37.7351618174613 -122.385185311358 (37.7351618174613, -122.385185311358)
163933 163933 199612 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1570 Michigan St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23     6016520.08797 2100945.2789 37.7497226822544 -122.385666519716 (37.7497226822544, -122.385666519716)
32272 32272 195931 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   6016388.5375 2097212.10904 37.7394648837006 -122.38586125081801 (37.7394648837006, -122.385861250818)
170263 170263 195930 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   6016382.509430001 2097206.98617 37.7394504837496 -122.385881736453 (37.7394504837496, -122.385881736453)
66705 66705 195929 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   6016374.07266 2097196.6674900004 37.739421683856 -122.38591018830799 (37.739421683856, -122.385910188308)
38176 38176 195928 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 10ft   6016367.965340001 2097187.6132799997 37.7393964848479 -122.385930673971 (37.7393964848479, -122.385930673971)
25771 25771 198601 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6016359.83761 2108655.37305 37.770884091558706 -122.386758280474 (37.7708840915587, -122.386758280474)
34341 34341 195927 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 10ft   6016357.22552 2097177.34103 37.7393676849746 -122.385967092025 (37.7393676849746, -122.385967092025)
153528 153528 198652 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6016352.81609 2108774.30794 37.771210272076104 -122.38679086381501 (37.7712102720761, -122.386790863815)
186031 186031 195926 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 623 Mendell St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 10ft   6016351.11158 2097167.95878 37.73934158485871 -122.385987577683 (37.7393415848587, -122.385987577683)
159214 159214 198602 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016341.1963599995 2108654.11325 37.7708796003339 -122.38682267373801 (37.7708796003339, -122.386822673738)
71828 71828 198651 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016332.95432 2108773.69506 37.7712074895574 -122.386859524348 (37.7712074895574, -122.386859524348)
153260 153260 198603 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016318.412280001 2108651.0285 37.7708698687754 -122.386901269979 (37.7708698687754, -122.386901269979)
186702 186702 198650 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016310.0808 2108775.16968 37.771210272057296 -122.38693874834499 (37.7712102720573, -122.386938748345)
55185 55185 198604 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016296.79375 2108651.46445 37.7708698687766 -122.386976080084 (37.7708698687766, -122.386976080084)
125197 125197 110465 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1485 FAIRFAX AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     9 3x3   6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
147997 147997 198649 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016285.57372 2108771.35591 37.7711984432851 -122.387023254046 (37.7711984432851, -122.387023254046)
59240 59240 198605 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016273.49532 2108650.02611 37.770864629317 -122.38705657031099 (37.770864629317, -122.387056570311)
153228 153228 188363 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 1888 Illinois St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   6016272.9604 2100359.33307 37.748100119129504 -122.38648025416 (37.7481001191295, -122.38648025416)
69196 69196 188362 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 1888 Illinois St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   6016272.68217 2100361.78629 37.748106839761704 -122.386481387306 (37.7481068397617, -122.386481387306)
43130 43130 188825 Undocumented 2 Betula pendula :: European White Birch 146 1888 Illinois St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   6016272.37699 2100354.77616 37.7480875745024 -122.38648195390199 (37.7480875745024, -122.386481953902)
69313 69313 198648 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016263.67679 2108770.7838 37.77119565988 -122.387098957165 (37.77119565988, -122.387098957165)
129645 129645 196362 Undocumented 2 Prunus persica :: Peach 330 1800 Illinois St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6016258.9741400005 2100621.98176 37.7488205237488 -122.38654692990801 (37.7488205237488, -122.386546929908)
31727 31727 197188 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1800 Illinois St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016258.08648 2100618.43223 37.748810728335705 -122.386549751994 (37.7488107283357, -122.386549751994)
158651 158651 197187 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1800 Illinois St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6016257.355909999 2100633.78015 37.7488528300966 -122.386553348365 (37.7488528300966, -122.386553348365)
147685 147685 196064 Undocumented 2 Prunus spp :: Cherry 84 1800 Illinois St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   6016257.27394 2100629.7145700003 37.7488416623195 -122.386553348372 (37.7488416623195, -122.386553348372)
170333 170333 197186 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1800 Illinois St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6016257.1896 2100643.95159 37.7488807495539 -122.38655463261101 (37.7488807495539, -122.386554632611)
65774 65774 197066 Undocumented 2 Pyrus spp :: Pear Tree 291 1800 Illinois St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6016257.10018 2100639.51638 37.7488685664372 -122.38655463261101 (37.7488685664372, -122.386554632611)
40762 40762 198606 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6016250.47578 2108648.85468 37.7708601381228 -122.387136114449 (37.7708601381228, -122.387136114449)
173274 173274 198647 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6016245.346419999 2108770.39329 37.7711935725654 -122.387162335966 (37.7711935725654, -122.387162335966)
57004 57004 193613 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 400 Cargo Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6016243.299930001 2099581.7873299997 37.745963497216 -122.386528611609 (37.745963497216, -122.386528611609)
57322 57322 198607 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016227.74089 2108648.22285 37.7708571442621 -122.387214711603 (37.7708571442621, -122.387214711603)
40257 40257 193614 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 400 Cargo Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6016222.8918 2099596.86251 37.746003760769796 -122.38660023182 (37.7460037607698, -122.38660023182)
164008 164008 198646 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016222.396269999 2108768.06856 37.771185918433 -122.387241559965 (37.771185918433, -122.387241559965)
134544 134544 198608 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016209.64695 2108646.95211 37.77085265305929 -122.387277210877 (37.7708526530593, -122.387277210877)
134027 134027 193615 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 400 Cargo Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6016204.3919 2099609.55217 37.746037579778296 -122.38666508732 (37.7460375797783, -122.38666508732)
151576 151576 198645 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016201.48613 2108765.95621 37.7711789603748 -122.387313742229 (37.7711789603748, -122.387313742229)
53686 53686 191794 Undocumented 2 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 800 Terry A Francois Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 4ft   6016193.39876 2106582.6581099997 37.7651836497265 -122.387189402894 (37.7651836497265, -122.387189402894)
67052 67052 193616 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 400 Cargo Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6016188.46596 2099620.47272 37.7460666836449 -122.386720919033 (37.7460666836449, -122.386720919033)
63171 63171 198609 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6016187.15273 2108644.67946 37.7708451671001 -122.387354861049 (37.7708451671001, -122.387354861049)
63853 63853 198644 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016180.118480001 2108766.38719 37.7711789603624 -122.38738768448799 (37.7711789603624, -122.387387684488)
162785 162785 198610 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6016166.070780001 2108644.55968 37.770843670618504 -122.38742777629601 (37.7708436706185, -122.387427776296)
131254 131254 198643 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6016155.89645 2108764.08817 37.7711713062286 -122.38747130976401 (37.7711713062286, -122.387471309764)
73680 73680 198611 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 456 Mission Bay Blvd South 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6016143.32489 2108643.38282 37.7708391794209 -122.38750637344101 (37.7708391794209, -122.387506373441)
74157 74157 198642 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 421 Mission Bay Blvd North 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6016136.74684 2108760.92666 37.77116156477771 -122.38753732899099 (37.7711615647777, -122.387537328991)
134407 134407 197275 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6016114.884459999 2108006.33732 37.7690884161304 -122.387560299479 (37.7690884161304, -122.387560299479)
132422 132422 197277 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6016113.5620800005 2108033.0539700002 37.7691617009916 -122.387566737717 (37.7691617009916, -122.387566737717)
49137 49137 197279 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6016112.1574800005 2108055.69454 37.769223789269205 -122.387573175954 (37.7692237892692, -122.387573175954)
130848 130848 197281 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6016110.38845 2108078.71323 37.7692868955955 -122.38758090114099 (37.7692868955955, -122.387580901141)
180283 180283 197283 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6016109.01375 2108102.83593 37.769353055133294 -122.38758733939501 (37.7693530551333, -122.387587339395)
71308 71308 197285 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6016108.43544 2108129.53724 37.769426339083 -122.387591202882 (37.769426339083, -122.387591202882)
154929 154929 197287 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6016106.643999999 2108151.44442 37.7694863922003 -122.38759892806499 (37.7694863922003, -122.387598928065)
169780 169780 197289 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6016104.5103 2108174.84091 37.7695505156795 -122.387607941055 (37.7695505156795, -122.387607941055)
135436 135436 197290 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016103.1804599995 2108201.18695 37.7696227825046 -122.38761437932301 (37.7696227825046, -122.387614379323)
62665 62665 197292 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6016102.8622 2108222.32256 37.769680798655 -122.38761695497699 (37.769680798655, -122.387616954977)
52449 52449 197294 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6016100.76588 2108247.57178 37.769750011393796 -122.387625967988 (37.7697500113938, -122.387625967988)
177898 177898 197296 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 11 Bridgeview Way 24 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6016097.57551 2108273.95502 37.7698222773026 -122.387638844473 (37.7698222773026, -122.387638844473)
159996 159996 194590 Undocumented 2 Pittosporum eugenioides :: Tarata 110 13 Bridgeview Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6016094.38858 2108337.40723 37.7699963267064 -122.387654295729 (37.7699963267064, -122.387654295729)
64854 64854 197298 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 13 Bridgeview Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016094.16751 2108363.36014 37.7700675754904 -122.387656871394 (37.7700675754904, -122.387656871394)
35417 35417 194857 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 13 Bridgeview Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6016092.3761 2108385.2666700003 37.770127626813505 -122.387664596547 (37.7701276268135, -122.387664596547)
166999 166999 197301 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 13 Bridgeview Way 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6016091.41098 2108411.23459 37.7701988755957 -122.38766974696101 (37.7701988755957, -122.387669746961)
29684 29684 197303 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 13 Bridgeview Way 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016090.0437900005 2108435.7275799997 37.770266052269605 -122.387676185234 (37.7702660522696, -122.387676185234)
157001 157001 197304 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 13 Bridgeview Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6016087.22721 2108480.63748 37.7703892090349 -122.387689061714 (37.7703892090349, -122.387689061714)
29752 29752 197306 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 13 Bridgeview Way 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   6016086.21724 2108504.38173 37.7704543496162 -122.387694212136 (37.7704543496162, -122.387694212136)
133998 133998 197329 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 14 Bridgeview Way 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016083.653580001 2108026.91709 37.7691431938187 -122.38766976225901 (37.7691431938187, -122.387669762259)
53823 53823 197330 Undocumented 2 Quercus virginiana :: Southern Live Oak 341 14 Bridgeview Way 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   6016083.25197 2108007.00917 37.7690885087587 -122.38766976226002 (37.7690885087587, -122.38766976226)

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