Data source: data.sfgov.org
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
62916 | 62916 | 186533 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | |||
64027 | 64027 | 186552 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.623 | 2104776.3995 | 37.758433365006105 | -122.49577295137699 | (37.7584333650061, -122.495772951377) | |||
65848 | 65848 | 186549 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | |||
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) | |||
72947 | 72947 | 186547 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | |||
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) | |||
132337 | 132337 | 186535 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | |||
136486 | 136486 | 186550 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | |||
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) | |||
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) | |||
147019 | 147019 | 186536 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.758741787333705 | -122.495848242848 | (37.7587417873337, -122.495848242848) | |||
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) | |||
148409 | 148409 | 186553 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984733.406 | 2104758.3944 | 37.7583823340555 | -122.495865750271 | (37.7583823340555, -122.495865750271) | |||
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) | |||
150157 | 150157 | 186541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.49583138713601 | (37.7587075661518, -122.495831387136) | |||
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) | |||
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) | |||
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) | |||
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) | |||
172365 | 172365 | 186543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
178921 | 178921 | 186554 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5984714.9821 | 2104746.2514 | 37.7583479137241 | -122.495928571528 | (37.7583479137241, -122.495928571528) | |||
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) | |||
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) | |||
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) | |||
183109 | 183109 | 186548 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5984713.0979 | 2104804.2446 | 37.7585070365446 | -122.49593936599 | (37.7585070365446, -122.49593936599) | |||
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) | |||
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) | ||||
109114 | 109114 | 105137 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 3 | unknown : Yard 19 | Tree 1 | DPW 2 | 18 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
139638 | 139638 | 105139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
143716 | 143716 | 105138 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
85853 | 85853 | 114950 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | ||||
111345 | 111345 | 114949 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 30 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | |||
176910 | 176910 | 200204 | Undocumented 2 | :: 54 | 2 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014372.6432 | 2089670.326 | 37.71864490712711 | -122.392304046142 | (37.7186449071271, -122.392304046142) | |||
126465 | 126465 | 101951 | Property Tree 7 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard 19 | Tree 1 | Private 1 | 6003106.0 | 2094969.0 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | ||||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
73057 | 73057 | 185408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.742942801420796 | -122.49417377884599 | (37.7429428014208, -122.494173778846) | |||
76866 | 76866 | 185401 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | |||
131257 | 131257 | 185403 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985110.6332 | 2099073.9214 | 37.742796413512 | -122.49414218382499 | (37.742796413512, -122.494142183825) | |||
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) | |||
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) | |||
137933 | 137933 | 185406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.742876046964604 | -122.494142591708 | (37.7428760469646, -122.494142591708) | |||
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) | |||
149365 | 149365 | 185409 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985081.6412 | 2099150.9001 | 37.7430060796886 | -122.494248101225 | (37.7430060796886, -122.494248101225) | |||
149629 | 149629 | 181352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985091.6384 | 2099018.9366 | 37.7426443285892 | -122.494203809651 | (37.7426443285892, -122.494203809651) | |||
152435 | 152435 | 185402 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.742712196982495 | -122.494088049359 | (37.7427121969825, -122.494088049359) | |||
152791 | 152791 | 185391 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985125.1292 | 2098935.9595 | 37.7424184556167 | -122.49408189561899 | (37.7424184556167, -122.494081895619) | |||
159653 | 159653 | 185399 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985110.1333 | 2099026.9344 | 37.7426673706481 | -122.49414044992399 | (37.7426673706481, -122.494140449924) | |||
160873 | 160873 | 185390 | Undocumented 2 | Araucaria araucana :: Monkey puzzle 154 | 2300 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985092.6382 | 2098924.4627 | 37.742384987274704 | -122.49419339090001 | (37.7423849872747, -122.4941933909) | |||
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) | |||
162943 | 162943 | 185411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985100.1361 | 2099184.3909 | 37.7430991186582 | -122.49418661978599 | (37.7430991186582, -122.494186619786) | |||
167557 | 167557 | 185404 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985080.6415 | 2099060.4251 | 37.7427576012847 | -122.494244890555 | (37.7427576012847, -122.494244890555) | |||
170252 | 170252 | 185410 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985099.6362 | 2099155.3989 | 37.7430194852088 | -122.494186211855 | (37.7430194852088, -122.494186211855) | |||
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) | |||
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) | |||
178149 | 178149 | 181354 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.742797140118796 | -122.494261514147 | (37.7427971401188, -122.494261514147) | |||
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) | |||
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) | |||
181170 | 181170 | 185396 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985088.1394 | 2098992.4439 | 37.742571382036 | -122.49421395573499 | (37.742571382036, -122.494213955735) | |||
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) | |||
183931 | 183931 | 185393 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985089.6389999995 | 2098965.9512 | 37.742498727988895 | -122.49420681837499 | (37.7424987279889, -122.494206818375) | |||
185674 | 185674 | 185392 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985108.1339 | 2098944.4572 | 37.7424407935289 | -122.494141285581 | (37.7424407935289, -122.494141285581) | |||
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) | |||
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) | |||
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) | |||
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) |
JSON shape: default, array, newline-delimited
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");