Street_Tree_List

Data source: data.sfgov.org

302 rows where qSiteInfo = 19 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188560 188560 185508 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 62 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985138.3382 2098803.9124 37.742056662806796 -122.494026493821 (37.7420566628068, -122.494026493821)
134120 134120 185507 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 61 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985116.4249 2098801.2563 37.7420480876484 -122.494102066238 (37.7420480876484, -122.494102066238)
57323 57323 185506 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 60 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985096.5037 2098790.6317 37.7420177496615 -122.494170163503 (37.7420177496615, -122.494170163503)
40115 40115 185505 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 59 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5985087.8712 2098781.9991 37.7419935417222 -122.49419937536501 (37.7419935417222, -122.494199375365)
65093 65093 185504 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2400 Sunset Blvd 58 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5985115.0968 2098786.6474 37.7420078978362 -122.49410558184499 (37.7420078978362, -122.494105581845)
172640 172640 185503 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 57 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985131.0337 2098785.3193 37.7420051837622 -122.49405038008001 (37.7420051837622, -122.49405038008)
59085 59085 185502 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2400 Sunset Blvd 56 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985117.0889 2098738.1726 37.7418749156753 -122.494095121998 (37.7418749156753, -122.494095121998)
184474 184474 185501 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 55 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985131.6978 2098729.54 37.741852067703704 -122.494043973834 (37.7418520677037, -122.494043973834)
132494 132494 185500 Undocumented 2 Juniperus chinensis :: Juniper 19 2400 Sunset Blvd 54 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5985111.7766 2098706.9627 37.7417889108579 -122.49411119019399 (37.7417889108579, -122.494111190194)
162494 162494 186583 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1501 Sunset Blvd 54 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5984720.8443 2104581.693 37.757896425499794 -122.49589615853 (37.7578964254998, -122.49589615853)
55166 55166 185499 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 53 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985130.3697 2098685.0494 37.741729830798995 -122.494045287668 (37.741729830799, -122.494045287668)
150075 150075 186582 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1501 Sunset Blvd 53 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5984722.9379 2104579.1806 37.757889649764294 -122.495888732757 (37.7578896497643, -122.495888732757)
75550 75550 186581 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 52 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984771.5099 2104576.6683 37.75788559627829 -122.495720567601 (37.7578855962783, -122.495720567601)
131653 131653 185498 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 52 unknown : Yard 19 Tree 1 Private 1     33 Width 0ft   5985102.48 2098665.7923 37.74167532404589 -122.494140300571 (37.7416753240459, -122.494140300571)
29764 29764 185497 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 51 unknown : Yard 19 Tree 1 Private 1     33 Width 0ft   5985111.7766 2098651.8474 37.7416375791026 -122.494107128969 (37.7416375791026, -122.494107128969)
28544 28544 185496 Undocumented 2 Pinus Spp :: Pine Spp 105 2400 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.49400366283501 (37.7416338578085, -122.494003662835)
47580 47580 186579 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984739.2681 2104595.0921 37.7579342947119 -122.495833430643 (37.7579342947119, -122.495833430643)
57083 57083 185434 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     20 Width 0ft   5985080.6415 2099410.3284 37.7437183411386 -122.494270675975 (37.7437183411386, -122.494270675975)
134264 134264 185433 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 49 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985073.6434 2099396.3323 37.7436795021074 -122.49429384193199 (37.7436795021074, -122.494293841932)
137771 137771 181360 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 49 unknown : Yard 19 Tree 1 Private 1     47 Width 0ft   5985113.1047 2098629.2701 37.7415756656355 -122.494100873291 (37.7415756656355, -122.494100873291)
30516 30516 185495 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985112.4406 2098617.3174 37.74154280788321 -122.494102288748 (37.7415428078832, -122.494102288748)
150480 150480 186577 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     29 Width 0ft   5984764.3916 2104600.9543 37.75795186201471 -122.495746976697 (37.7579518620147, -122.495746976697)
181515 181515 185432 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 48 unknown : Yard 19 Tree 1 Private 1     28 Width 0ft   5985081.6412 2099386.335 37.7436525202566 -122.49426545113899 (37.7436525202566, -122.494265451139)
25247 25247 185431 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 47 unknown : Yard 19 Tree 1 Private 1     40 Width 0ft   5985098.6365 2099386.335 37.743653514796705 -122.49420668637899 (37.7436535147967, -122.494206686379)
45810 45810 185494 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 47 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985136.346 2098616.6534 37.74154238350489 -122.494019584309 (37.7415423835049, -122.494019584309)
157600 157600 186576 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 47 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984768.5788 2104614.3534 37.7579888974289 -122.495733484153 (37.7579888974289, -122.495733484153)
34361 34361 185493 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5985113.7687 2098601.3804 37.741499126889295 -122.49409652237499 (37.7414991268893, -122.494096522375)
35563 35563 186575 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     30 Width 0ft   5984766.4852 2104638.2207 37.75805430778821 -122.49574248511298 (37.7580543077882, -122.495742485113)
179607 179607 185430 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 46 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985106.6343 2099374.8382 37.7436224157034 -122.49417818512899 (37.7436224157034, -122.494178185129)
172749 172749 186574 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 45 unknown : Yard 19 Tree 1 Private 1     46 Width 0ft   5984720.0068 2104642.8266 37.7580642323025 -122.495903564638 (37.7580642323025, -122.495903564638)
176577 176577 185492 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 45 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985138.3382 2098590.7558 37.7414713922408 -122.494010787869 (37.7414713922408, -122.494010787869)
24948 24948 186573 Undocumented 2 Myoporum laetum :: Myoporum 1 1501 Sunset Blvd 44 unknown : Yard 19 Tree 1 Private 1     15 Width 0ft   5984743.4554 2104652.876 37.758093198452 -122.49582321186399 (37.758093198452, -122.495823211864)
41710 41710 185491 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 44 unknown : Yard 19 Tree 1 Private 1     11 Width 0ft   5985120.4091 2098579.4672 37.7414393477039 -122.494071947824 (37.7414393477039, -122.494071947824)
37856 37856 185490 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 43 unknown : Yard 19 Tree 1 Private 1     18 Width 0ft   5985127.7135 2098570.8346 37.741416072315204 -122.49404605602501 (37.7414160723152, -122.494046056025)
174794 174794 186572 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 1501 Sunset Blvd 43 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984761.0418 2104653.2947 37.7580953780168 -122.495762422342 (37.7580953780168, -122.495762422342)
77313 77313 185489 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 42 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985101.1519 2098546.2652 37.7413470571288 -122.494136085042 (37.7413470571288, -122.494136085042)
132393 132393 185426 Undocumented 2 Pinus radiata :: Monterey Pine 3 2300 Sunset Blvd 42 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985086.6398 2099317.3541 37.7434634098799 -122.49424308404801 (37.7434634098799, -122.494243084048)
175132 175132 185488 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 41 unknown : Yard 19 Tree 1 Private 1     27 Width 0ft   5985122.4012 2098536.3046 37.741320951397704 -122.494061879541 (37.7413209513977, -122.494061879541)
179756 179756 186570 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 41 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984760.623 2104719.4531 37.7582770060448 -122.495768750789 (37.7582770060448, -122.495768750789)
48606 48606 185487 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985139.0022 2098533.6484 37.7413146295557 -122.49400428423901 (37.7413146295557, -122.494004284239)
147893 147893 185424 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985084.6404 2099301.8584 37.7434207458763 -122.49424885544599 (37.7434207458763, -122.494248855446)
178107 178107 186569 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     26 Width 0ft   5984763.5541 2104672.9747 37.7581495609485 -122.49575518551701 (37.7581495609485, -122.495755185517)
51500 51500 185486 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985131.6978 2098522.3598 37.7412832067047 -122.494028708144 (37.7412832067047, -122.494028708144)
60439 60439 185423 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985071.643999999 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743)
187425 187425 186568 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984708.7013 2104680.5118 37.7581670432315 -122.495945443345 (37.7581670432315, -122.495945443345)
147307 147307 186567 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 38 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984755.1796 2104685.1177 37.7581824118079 -122.49578504343799 (37.7581824118079, -122.495785043438)
150810 150810 186483 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 38 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980878.6055 2105409.1394 37.7599425780444 -122.509245441233 (37.7599425780444, -122.509245441233)
171864 171864 185485 Undocumented 2 Tree(s) :: 17 2400 Sunset Blvd 38 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985115.7608 2098504.4307 37.741233045699296 -122.49408249075898 (37.7412330456993, -122.494082490759)
187450 187450 185422 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 38 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985084.6404 2099285.363 37.7433754539691 -122.494247639854 (37.7433754539691, -122.494247639854)
146842 146842 186566 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984742.1992 2104682.6054 37.7581747535408 -122.49582974929 (37.7581747535408, -122.49582974929)
164196 164196 185484 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2400 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985117.0889 2098499.1184 37.741218537266796 -122.494077507295 (37.7412185372668, -122.494077507295)
167996 167996 186482 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980889.9955 2105407.5862 37.7599389849374 -122.50920593411199 (37.7599389849374, -122.509205934112)
177017 177017 185421 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985094.1378 2099288.8619999997 37.7433856170495 -122.494215058601 (37.7433856170495, -122.494215058601)
55505 55505 186565 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 36 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984733.8247 2104692.236 37.7582007060302 -122.49585942192302 (37.7582007060302, -122.495859421923)
164141 164141 185483 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Sunset Blvd 36 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985132.3618 2098506.4228 37.741239486847206 -122.494025238023 (37.7412394868472, -122.494025238023)
167264 167264 186490 Undocumented 2 Pinus Spp :: Pine Spp 105 1400 Lower Great Hwy 36 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711)
174524 174524 185420 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 36 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985096.6371 2099279.3646 37.7433596860109 -122.494205716911 (37.7433596860109, -122.494205716911)
61319 61319 186489 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 35 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5980878.6055 2105387.9124 37.759884294807 -122.509243864844 (37.759884294807, -122.509243864844)
163100 163100 185482 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985148.9628 2098503.7667 37.741233165261896 -122.49396764279498 (37.7412331652619, -122.493967642795)
179741 179741 185419 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985098.1367 2099271.3668 37.7433378139676 -122.49419994238899 (37.7433378139676, -122.494199942389)
182562 182562 186564 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984731.3124 2104697.6794 37.7582155049555 -122.49586851196199 (37.7582155049555, -122.495868511962)
24279 24279 138266 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2600 GEARY BLVD 34 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5999024.6838 2113178.2607 37.7823277718518 -122.44704630425699 (37.7823277718518, -122.447046304257)
52764 52764 185481 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 34 unknown : Yard 19 Tree 1 Private 1     26 Width 0ft   5985135.017999999 2098495.7982 37.741210469977105 -122.49401527111799 (37.7412104699771, -122.494015271118)
60508 60508 185418 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 34 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985092.1383 2099264.8686 37.7433196206545 -122.494220204145 (37.7433196206545, -122.494220204145)
166154 166154 186488 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1400 Lower Great Hwy 34 unknown : Yard 19 Tree 1 Private 1     15 Width 0ft   5980888.4423 2105382.2174 37.7598692379346 -122.50920942183998 (37.7598692379346, -122.50920942184)
180584 180584 186563 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 1501 Sunset Blvd 34 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984717.9132 2104705.2165 37.7582354149831 -122.495915407531 (37.7582354149831, -122.495915407531)
51431 51431 186843 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 33 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980882.2296 2105351.6713 37.759785000838704 -122.509228639712 (37.7597850008387, -122.509228639712)
53374 53374 185417 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 33 unknown : Yard 19 Tree 1 Private 1     24 Width 0ft   5985081.6412 2099246.8736 37.7432695969748 -122.49425517376801 (37.7432695969748, -122.494255173768)
135953 135953 185480 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 33 unknown : Yard 19 Tree 1 Private 1     16 Width 0ft   5985125.7214 2098482.5174 37.7411734605092 -122.49404643640601 (37.7411734605092, -122.494046436406)
176494 176494 186562 Undocumented 2 Myoporum laetum :: Myoporum 1 1501 Sunset Blvd 33 unknown : Yard 19 Tree 1 Private 1     10 Width 0ft   5984757.692000001 2104711.0786 37.758253840349205 -122.495778269581 (37.7582538403492, -122.495778269581)
34443 34443 186561 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     85 Width 0ft   5984740.943 2104715.6846 37.758265506246296 -122.495836533834 (37.7582655062463, -122.495836533834)
38172 38172 185416 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985081.6412 2099232.3776 37.743229794878296 -122.49425410551599 (37.7432297948783, -122.494254105516)
49608 49608 186504 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 32 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5980883.7828 2105343.3876 37.7597623477539 -122.50922265288601 (37.7597623477539, -122.509222652886)
162935 162935 185479 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 32 unknown : Yard 19 Tree 1 Private 1     17 Width 0ft   5985115.7608 2098477.2051 37.741158291534504 -122.494080484656 (37.7411582915345, -122.494080484656)
164558 164558 138264 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2600 GEARY BLVD 32 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.44699593627199 (37.7823276740968, -122.446995936272)
39945 39945 181359 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 31 unknown : Yard 19 Tree 1 Private 1     22 Width 0ft   5985110.4485 2098473.2209 37.741147041149 -122.494098558838 (37.741147041149, -122.494098558838)
57913 57913 185415 Undocumented 2 Pinus radiata :: Monterey Pine 3 2300 Sunset Blvd 31 unknown : Yard 19 Tree 1 Private 1     16 Width 0ft   5985091.6384 2099216.8819 37.743187832897 -122.494218396427 (37.743187832897, -122.494218396427)
67056 67056 138263 Undocumented 2 Myoporum laetum :: Myoporum 1 2600 GEARY BLVD 31 unknown : Yard 19 Tree 1 Private 1     17 Width 0ft   5999038.5591 2113167.7696 37.7822997587534 -122.44699754685101 (37.7822997587534, -122.446997546851)
70661 70661 186503 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 31 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5980885.336 2105334.0684 37.759736851483396 -122.50921658916701 (37.7597368514834, -122.509216589167)
137799 137799 186560 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 31 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984754.3422 2104716.1033 37.7582674405997 -122.495790225123 (37.7582674405997, -122.495790225123)
39570 39570 186559 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984761.8792 2104726.5714 37.7582966244824 -122.495764931436 (37.7582966244824, -122.495764931436)
62482 62482 185414 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985079.1419 2099209.8838 37.743167886728 -122.494261089675 (37.743167886728, -122.494261089675)
64449 64449 185478 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2400 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985137.6741 2098467.2445 37.7411322246193 -122.494003983523 (37.7411322246193, -122.494003983523)
182255 182255 186502 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 30 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980892.5842 2105334.0684 37.7597372788194 -122.509191521679 (37.7597372788194, -122.509191521679)
33040 33040 185413 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2300 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985092.6382 2099208.8841 37.7431659316065 -122.49421435006501 (37.7431659316065, -122.494214350065)
45919 45919 185477 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     38 Width 0ft   5985132.3618 2098455.9558 37.741100918055295 -122.494021519499 (37.7411009180553, -122.494021519499)
47007 47007 186501 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 29 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980893.6197 2105317.501 37.7596918505514 -122.50918671014799 (37.7596918505514, -122.509186710148)
174920 174920 186558 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5984755.5984 2104741.6454 37.7583376456641 -122.495787764797 (37.7583376456641, -122.495787764797)
33000 33000 138260 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2600 GEARY BLVD 28 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5999060.2181 2113180.9681 37.7823372358083 -122.446923566676 (37.7823372358083, -122.446923566676)
37834 37834 185476 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 28 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985139.6662 2098449.3154 37.741083112699 -122.49399577462098 (37.741083112699, -122.493995774621)
67760 67760 186557 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 28 unknown : Yard 19 Tree 1 Private 1     36 Width 0ft   5984754.7609 2104747.5076 37.758353692586 -122.49579109362101 (37.758353692586, -122.495791093621)
147843 147843 186500 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 28 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980882.7473 2105316.9833 37.7596897880858 -122.509224273257 (37.7596897880858, -122.509224273257)
162312 162312 185412 Undocumented 2 Pinus radiata :: Monterey Pine 3 2300 Sunset Blvd 28 unknown : Yard 19 Tree 1 Private 1     47 Width 0ft   5985078.1422 2099185.3906 37.7431005765205 -122.494262741341 (37.7431005765205, -122.494262741341)
53561 53561 138259 Undocumented 2 Myoporum laetum :: Myoporum 1 2600 GEARY BLVD 27 unknown : Yard 19 Tree 1 Private 1     19 Width 0ft   5999063.9407 2113176.2302 37.782324439437204 -122.44691034713499 (37.7823244394372, -122.446910347135)
63349 63349 186499 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 27 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5980882.7473 2105311.2882 37.7596741509783 -122.50922385032601 (37.7596741509783, -122.509223850326)
133868 133868 185475 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 27 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5985123.7293 2098442.675 37.7410639474436 -122.494050388555 (37.7410639474436, -122.494050388555)
169801 169801 186556 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 27 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984748.0613 2104746.2514 37.7583498510528 -122.495814170782 (37.7583498510528, -122.495814170782)
34988 34988 186555 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984748.8988 2104750.8574 37.7583625468943 -122.495811614145 (37.7583625468943, -122.495811614145)
38441 38441 185474 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     27 Width 0ft   5985113.1047 2098438.0268 37.7410505630538 -122.494086781525 (37.7410505630538, -122.494086781525)
65556 65556 186486 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 26 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980884.8182 2105306.6287 37.759661479426796 -122.509216342217 (37.7596614794268, -122.509216342217)

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