Street_Tree_List

Data source: data.sfgov.org

302 rows where qSiteInfo = 19 sorted by rowid 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
188973 188973 200161 Undocumented 2 :: 54 1083 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014425.6299 2089982.8806 37.7195060625081 -122.392142737787 (37.7195060625081, -122.392142737787)
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)
187469 187469 200742 Undocumented 2 :: 54 1454 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6015834.4667 2094922.2745 37.733146784173606 -122.38761728786601 (37.7331467841736, -122.387617287866)
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)
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)
186420 186420 200171 Undocumented 2 :: 54 1059 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014549.7127 2089886.9679 37.7192495938582 -122.391707122944 (37.7192495938582, -122.391707122944)
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)
185290 185290 185463 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 15 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985112.4406 2098384.9036 37.740904662190104 -122.494085163354 (37.7409046621901, -122.494085163354)
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)
183984 183984 200230 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1079 Ingerson Ave 4 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   6013720.7054 2090151.9015 37.7199309952824 -122.394591251483 (37.7199309952824, -122.394591251483)
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)
183371 183371 185462 Undocumented 2 Pinus Spp :: Pine Spp 105 2400 Sunset Blvd 13 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985138.3382 2098374.943 37.740878828405 -122.49399488645399 (37.740878828405, -122.493994886454)
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)
182857 182857 181357 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 12 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985137.6741 2098360.3342 37.740838677714294 -122.49399610623999 (37.7408386777143, -122.49399610624)
182655 182655 186512 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 13 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968)
182621 182621 200227 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1079 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     11 Width 0ft   6013668.3894 2090192.8153 37.7200404277679 -122.39477495490499 (37.7200404277679, -122.394774954905)
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)
182449 182449 200194 Undocumented 2 :: 54 1011 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014781.1104 2089713.2519999999 37.718785446443206 -122.390895127615 (37.7187854464432, -122.390895127615)
182401 182401 186519 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1400 Lower Great Hwy 7 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980902.9388 2105057.6001 37.758978786758 -122.509135180581 (37.758978786758, -122.509135180581)
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)
182172 182172 185464 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 16 unknown : Yard 19 Tree 1 Private 1     46 Width 0ft   5985103.8081 2098378.9273 37.740887747752105 -122.494114570537 (37.7408877477521, -122.494114570537)
181911 181911 186516 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 2 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980905.2686 2104991.5894 37.758797677676704 -122.509122221366 (37.7587976776767, -122.509122221366)
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)
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)
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)
180431 180431 185459 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 9 unknown : Yard 19 Tree 1 Private 1     28 Width 0ft   5985114.4327 2098335.7647 37.7407698565631 -122.494074654765 (37.7407698565631, -122.494074654765)
180173 180173 186625 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1300 Lower Great Hwy 1 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980868.2988 2105582.371 37.76041761449721 -122.50929395155 (37.7604176144972, -122.50929395155)
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)
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)
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)
179207 179207 200191 Undocumented 2 :: 54 981 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014255.2675 2089757.5194 37.7188778046353 -122.39271586587799 (37.7188778046353, -122.392715865878)
179075 179075 200190 Undocumented 2 :: 54 1027 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014706.6607 2089771.6044 37.7189415394071 -122.391156549139 (37.7189415394071, -122.391156549139)
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)
178803 178803 186506 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 6 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5980906.3041 2105016.4405 37.7588659727132 -122.50912048557801 (37.7588659727132, -122.509120485578)
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)
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)
177846 177846 200172 Undocumented 2 :: 54 1053 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014576.5414 2089866.8464 37.7191958334242 -122.391612979464 (37.7191958334242, -122.391612979464)
177805 177805 200235 Undocumented 2 :: 54 923 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014534.9569 2089547.5847 37.7183168953073 -122.39173441165 (37.7183168953073, -122.39173441165)
177358 177358 200205 Undocumented 2 :: 54 1003 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014813.9755 2089679.7161 37.71869518696921 -122.39077918277701 (37.7186951869692, -122.390779182777)
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)
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)
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)
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)
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)
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)
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)
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)
174389 174389 186633 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 9 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980876.555 2105686.5399 37.760704119089 -122.509273133786 (37.760704119089, -122.509273133786)
174165 174165 186511 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 12 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980895.6906 2105140.9548 37.7592072275053 -122.509166437696 (37.7592072275053, -122.509166437696)
173333 173333 200730 Undocumented 2 :: 54 1466 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6015770.4184 2094966.2292 37.733263927070006 -122.387841787924 (37.73326392707, -122.387841787924)
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)
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)
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)
171950 171950 200244 Undocumented 2 :: 54 1123 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014193.5615 2090152.5722 37.7199591140845 -122.39295678576201 (37.7199591140845, -122.392956785762)
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)
170571 170571 186629 Undocumented 2 Myoporum laetum :: Myoporum 1 1300 Lower Great Hwy 5 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980862.5019 2105665.4602 37.7606454117292 -122.50932017074 (37.7606454117292, -122.50932017074)
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)
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)
168550 168550 200246 Undocumented 2 :: 54 1071 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013781.7407 2090110.9877 37.719822047209 -122.394377408818 (37.719822047209, -122.394377408818)
168399 168399 200213 Undocumented 2 :: 54 1101 Ingerson Ave 2 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013590.5861 2090251.1677 37.7201963256026 -122.395047981349 (37.7201963256026, -122.395047981349)
168385 168385 186505 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 1400 Lower Great Hwy 5 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980903.7154 2105004.5327 37.7588331246947 -122.509128554095 (37.7588331246947, -122.509128554095)
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)
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)
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)
166847 166847 185467 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 19 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985112.4406 2098402.8327 37.740953890671896 -122.49408648444799 (37.7409538906719, -122.494086484448)
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)
165416 165416 200238 Undocumented 2 :: 54 917 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014595.9922 2089500.6344 37.7181913669776 -122.391520156023 (37.7181913669776, -122.391520156023)
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)
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)
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)
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)
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)
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)
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)
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)
161360 161360 185461 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 11 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985111.1125 2098351.0376 37.7408115975576 -122.494087259969 (37.7408115975576, -122.494087259969)
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)
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)
159555 159555 185466 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 18 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985111.7766 2098394.8642 37.740931972462796 -122.494088193127 (37.7409319724628, -122.494088193127)
158735 158735 186635 Undocumented 2 Myoporum laetum :: Myoporum 1 1300 Lower Great Hwy 11 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5980866.0152 2105705.863 37.7607565533288 -122.50931102062 (37.7607565533288, -122.50931102062)
157610 157610 200239 Undocumented 2 :: 54 1131 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014148.6234 2090188.791 37.7200560674381 -122.39311465541401 (37.7200560674381, -122.393114655414)
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)
157531 157531 186484 Undocumented 2 Myoporum laetum :: Myoporum 1 1400 Lower Great Hwy 24 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5980883.7828 2105293.6854 37.7596258798004 -122.50921896188801 (37.7596258798004, -122.509218961888)
157249 157249 200733 Undocumented 2 Schinus molle :: California Pepper 138 1462 Oakdale Ave 3 unknown : Yard 19 Tree 1 Private 1     14 Width 0ft   6015790.512 2094948.0194 37.7332150397253 -122.387771048105 (37.7332150397253, -122.387771048105)
157058 157058 185451 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2400 Sunset Blvd 1 unknown : Yard 19 Tree 1 Private 1     30 Width 0ft   5985130.3697 2098228.1903 37.740475418723506 -122.49401162519399 (37.7404754187235, -122.494011625194)
156632 156632 200165 Undocumented 2 :: 54 1071 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014485.3238 2089939.2839 37.7193896687982 -122.39193334918501 (37.7193896687982, -122.391933349185)
156135 156135 200237 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 919 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   6014571.1757 2089512.0366 37.7182212977035 -122.39160673351002 (37.7182212977035, -122.39160673351)
155462 155462 186632 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 8 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980861.0966 2105687.2426 37.7607051370684 -122.509326648666 (37.7607051370684, -122.509326648666)
155117 155117 186636 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1300 Lower Great Hwy 12 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980864.6099 2105729.0507 37.7608201372164 -122.509317602916 (37.7608201372164, -122.509317602916)
153024 153024 186626 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1300 Lower Great Hwy 2 unknown : Yard 19 Tree 1 Private 1     7 Width 0ft   5980879.19 2105650.5288 37.7606053983358 -122.509261346313 (37.7606053983358, -122.509261346313)
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)
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)
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)
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)
150420 150420 200167 Undocumented 2 :: 54 1019 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014049.3571 2089910.4430000002 37.7192862641022 -122.393438318502 (37.7192862641022, -122.393438318502)
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)
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)
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)
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)
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)

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