Street_Tree_List

Data source: data.sfgov.org

302 rows where qSiteInfo = 19

✎ 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
1691 1691 251656 Undocumented 2 Tree(s) :: 17 31x Malta Dr 1 unknown : Yard 19 Tree 1 Private 1       3x3   5999423.0 2096089.0 37.7354276387403 -122.44443976141001 (37.7354276387403, -122.44443976141)
15790 15790 87061 Permitted Site 1 Eucalyptus Spp :: Eucalyptus 40     unknown : Yard 19 Tree 1 Private 1       3x3 Permit Number 50003          
23747 23747 186497 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 17 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
24212 24212 181351 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2300 Sunset Blvd 5 unknown : Yard 19 Tree 1 Private 1     32 Width 0ft   5985090.6387 2098949.4558 37.7424534945744 -122.49420214621 (37.7424534945744, -122.49420214621)
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)
24598 24598 186532 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984706.503 2104907.5647 37.7587903384946 -122.49596979583599 (37.7587903384946, -122.495969795836)
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)
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)
26814 26814 185398 Undocumented 2 Myoporum laetum :: Myoporum 1 2300 Sunset Blvd 11 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5985116.1317 2099019.9363 37.7426485067542 -122.49411919382099 (37.7426485067542, -122.494119193821)
27012 27012 186514 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 15 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5980897.7615 2105153.3803 37.759241466452295 -122.509160198369 (37.7592414664523, -122.509160198369)
27191 27191 186631 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 7 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980860.0426 2105683.7293 37.7606954284135 -122.50933003298901 (37.7606954284135, -122.509330032989)
27414 27414 186546 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 17 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984749.2128 2104853.9681 37.758645678551105 -122.495818134238 (37.7586456785511, -122.495818134238)
28131 28131 200245 Undocumented 2 :: 54 1075 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
28513 28513 200177 Undocumented 2 :: 54 1041 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876001 (37.7190489123065, -122.39135410876)
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)
29234 29234 186513 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 14 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980894.1374 2105147.1675 37.759224194224 -122.509172270667 (37.759224194224, -122.509172270667)
29647 29647 200249 Undocumented 2 :: 54 1067 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885)
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)
29863 29863 200176 Undocumented 2 :: 54 1047 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738)
30380 30380 186493 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 23 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980884.8182 2105286.9549 37.7596074608269 -122.509214881201 (37.7596074608269, -122.509214881201)
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)
30597 30597 200732 Undocumented 2 Juniperus chinensis :: Juniper 19 1462 Oakdale Ave 2 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   6015803.6984 2094934.205 37.7331778386107 -122.387724495212 (37.7331778386107, -122.387724495212)
30792 30792 200164 Undocumented 2 :: 54 1027 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555)
30894 30894 200231 Undocumented 2 Myoporum laetum :: Myoporum 1 1079 Ingerson Ave 5 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   6013732.1076 2090145.865 37.719915054156296 -122.39455141525299 (37.7199150541563, -122.394551415253)
32088 32088 186539 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 10 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984748.3754 2104879.0915 37.7587146113666 -122.49582288356001 (37.7587146113666, -122.49582288356)
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)
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)
34013 34013 185453 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     32 Width 0ft   5985125.7214 2098256.744 37.740553547520705 -122.494029800854 (37.7405535475207, -122.494029800854)
34066 34066 185473 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 25 unknown : Yard 19 Tree 1 Private 1     12 Width 0ft   5985104.4721 2098432.7145 37.741035471775206 -122.494116238038 (37.7410354717752, -122.494116238038)
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)
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)
34689 34689 186540 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1501 Sunset Blvd 11 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984760.5184 2104876.1604 37.7587072745291 -122.49578067192199 (37.7587072745291, -122.495780671922)
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)
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)
35616 35616 185394 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2300 Sunset Blvd 4 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985078.642000001 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761)
35633 35633 185470 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 22 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985119.081 2098414.7854 37.7409870981235 -122.49406440544399 (37.7409870981235, -122.494064405444)
35785 35785 138256 Undocumented 2 Myoporum laetum :: Myoporum 1 2600 GEARY BLVD 1 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5999357.6908 2113236.4692 37.7825066175753 -122.44589843946899 (37.7825066175753, -122.445898439469)
37581 37581 200170 Undocumented 2 :: 54 1001 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014099.661 2089867.5171 37.71917119290661 -122.393261433304 (37.7191711929066, -122.393261433304)
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)
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)
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)
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)
38464 38464 185405 Undocumented 2 Pinus radiata :: Monterey Pine 3 2300 Sunset Blvd 20 unknown : Yard 19 Tree 1 Private 1     23 Width 0ft   5985107.634 2099090.4168 37.7428415299236 -122.494153769583 (37.7428415299236, -122.494153769583)
39317 39317 186508 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1400 Lower Great Hwy 9 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980903.4565 2105112.4796 37.759129500629896 -122.50913746543199 (37.7591295006299, -122.509137465432)
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)
39813 39813 200248 Undocumented 2 :: 54 1107 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014274.7183 2090092.8783 37.719799714154504 -122.392672078819 (37.7197997141545, -122.392672078819)
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)
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)
40807 40807 200183 Undocumented 2 :: 54 1197 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013828.6909 2090422.2008 37.7206791862384 -122.39423689451401 (37.7206791862384, -122.394236894514)
41370 41370 186537 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1501 Sunset Blvd 8 unknown : Yard 19 Tree 1 Private 1     14 Width 0ft   5984743.3507 2104891.2345 37.7587476583889 -122.49584115676501 (37.7587476583889, -122.495841156765)
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)
42125 42125 200722 Undocumented 2 :: 54 1476 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6015747.1852 2094980.6714 37.7333022953684 -122.387923119588 (37.7333022953684, -122.387923119588)
43519 43519 200180 Undocumented 2 :: 54 1031 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817)
44552 44552 185455 Undocumented 2 Myoporum laetum :: Myoporum 1 2400 Sunset Blvd 5 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985131.0337 2098285.2977 37.7406322591341 -122.494013537118 (37.7406322591341, -122.494013537118)
44928 44928 200155 Undocumented 2 :: 54 1091 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014363.9238 2090021.1115 37.719607610680704 -122.39235870744899 (37.7196076106807, -122.392358707449)
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)
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)
46197 46197 186496 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 16 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980891.5487 2105237.2527 37.7594713896823 -122.509187913256 (37.7594713896823, -122.509187913256)
46337 46337 185407 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 22 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985075.6429 2099093.4159999997 37.742847892869 -122.49426460522899 (37.742847892869, -122.494264605229)
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)
47539 47539 186530 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 1 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984710.6902 2104914.2643 37.7588089789692 -122.495955809021 (37.7588089789692, -122.495955809021)
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)
48044 48044 186542 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 13 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984733.3013 2104876.5792 37.7587068304654 -122.495874830593 (37.7587068304654, -122.495874830593)
48440 48440 186534 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 5 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984706.503 2104895.4217 37.758756997201 -122.49596890002701 (37.758756997201, -122.495968900027)
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)
48984 48984 200734 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1434 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   6015941.8417 2094834.993 37.7329130736504 -122.387239974213 (37.7329130736504, -122.387239974213)
49038 49038 186494 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 19 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980884.3005 2105262.6215 37.7595406177816 -122.50921486458799 (37.7595406177816, -122.509214864588)
49295 49295 186515 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 1 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980905.2686 2104984.8589 37.7587791976552 -122.509121721574 (37.7587791976552, -122.509121721574)
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)
49960 49960 105135 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 175X ESMERALDA AVE 1 unknown : Yard 19 Tree 1 DPW 2     26     6007213.0 2098808.0 37.7433348108676 -122.41769940776301 (37.7433348108676, -122.417699407763)
50995 50995 186509 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 10 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980901.3856 2105130.6001 37.759179132228 -122.509145973072 (37.759179132228, -122.509145973072)
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)
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)
52467 52467 200157 Undocumented 2 :: 54 1091 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014392.094 2090006.3557 37.7195686584119 -122.39226030100401 (37.7195686584119, -122.392260301004)
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)
52894 52894 186485 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 25 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5980894.6551 2105298.8627 37.7596407361809 -122.50918174518299 (37.7596407361809, -122.509181745183)
52895 52895 186634 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1300 Lower Great Hwy 10 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980874.0957 2105690.7559 37.7607155500113 -122.509281952349 (37.7607155500113, -122.509281952349)
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)
53419 53419 186531 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.49581571217699 (37.7588251541556, -122.495815712177)
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)
53840 53840 185397 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 10 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985126.1289 2099011.9385 37.742627131937 -122.49408403757799 (37.742627131937, -122.494084037578)
53924 53924 185395 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 7 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815)
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)
55366 55366 200178 Undocumented 2 :: 54 3201 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014218.378 2089782.3359 37.7189438969212 -122.39284511455 (37.7189438969212, -122.39284511455)
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)
55634 55634 185460 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2400 Sunset Blvd 10 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985122.4012 2098351.0376 37.7408122581003 -122.49404822844801 (37.7408122581003, -122.494048228448)
55679 55679 200228 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1079 Ingerson Ave 2 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   6013685.1573 2090181.4131 37.7200100518893 -122.394716195485 (37.7200100518893, -122.394716195485)
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)
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)
57892 57892 185452 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2400 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985111.1125 2098241.4711 37.7405107574318 -122.49407918667299 (37.7405107574318, -122.494079186673)
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)
58301 58301 200156 Undocumented 2 :: 54 1047 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013914.5428 2090009.7093 37.7195513382693 -122.39391126933 (37.7195513382693, -122.39391126933)
58408 58408 186491 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 21 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5980895.1728 2105273.4939 37.759571111269004 -122.509178070846 (37.759571111269, -122.509178070846)
58500 58500 186538 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 9 unknown : Yard 19 Tree 1 Private 1     29 Width 0ft   5984747.9566 2104882.4413 37.7587237844572 -122.495824579043 (37.7587237844572, -122.495824579043)
58818 58818 186492 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 22 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980885.336 2105278.6712 37.759584746696 -122.509212475259 (37.759584746696, -122.509212475259)
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)
59949 59949 186544 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 15 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984717.8085 2104869.8796 37.7586875278599 -122.495927916751 (37.7586875278599, -122.495927916751)
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)
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)
60510 60510 181353 Undocumented 2 Pinus radiata :: Monterey Pine 3 2300 Sunset Blvd 15 unknown : Yard 19 Tree 1 Private 1     34 Width 0ft   5985103.1353 2099041.4304 37.7427067632535 -122.49416571483 (37.7427067632535, -122.49416571483)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 89.993ms · Data source: data.sfgov.org