Data source: data.sfgov.org
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 80300 | 80300 | 86765 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 89237 | 89237 | 87112 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 89740 | 89740 | 86764 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 90997 | 90997 | 86768 | Permitted Site 1 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 105408 | 105408 | 86766 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 114230 | 114230 | 86759 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 116169 | 116169 | 87111 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 117147 | 117147 | 86767 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 117606 | 117606 | 86758 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 117988 | 117988 | 86763 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 120349 | 120349 | 86760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 123656 | 123656 | 86762 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 125822 | 125822 | 86761 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 141981 | 141981 | 87114 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 143327 | 143327 | 87115 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 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) | ||||
| 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) | |||
| 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) |
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");