trees
194,517 rows sorted by qSiteInfo descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
62362 | 200730 | DPW Maintained 1 | :: 45 | 1466 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.73326392707 | -122.387841787924 | (37.73326392707, -122.387841787924) | 10 | 3 | 8 | 58 | 1 | |||
62440 | 186536 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 7 | unknown : Yard | Tree | Private 2 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.7587417873337 | -122.495848242848 | (37.7587417873337, -122.495848242848) | 1 | 8 | 3 | 56 | 35 | |||
62684 | 106004 | Undocumented 4 | Eucalyptus globulus :: Blue Gum 56 | 695X CAMPBELL AVE | unknown : Yard | Tree | Rec/Park 5 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.410348471622 | (37.716271678506, -122.410348471622) | 9 | 7 | 8 | 309 | 39 | ||||||
62817 | 200162 | DPW Maintained 1 | :: 45 | 1035 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | 10 | 3 | 8 | 58 | 1 | |||
64282 | 186564 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Sunset Blvd | 35 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984731.3124 | 2104697.6794 | 37.7582155049555 | -122.495868511962 | (37.7582155049555, -122.495868511962) | 1 | 8 | 3 | 56 | 35 | |||
64392 | 185506 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 60 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985096.5037 | 2098790.6317 | 37.7420177496615 | -122.494170163503 | (37.7420177496615, -122.494170163503) | 1 | 8 | 3 | 29491 | 35 | |||
65395 | 186627 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1300 Lower Great Hwy | 3 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980877.609 | 2105668.6222 | 37.7606549843877 | -122.509268157881 | (37.7606549843877, -122.509268157881) | 1 | 8 | 3 | 56 | 35 | |||
65466 | 186576 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 47 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984768.5788 | 2104614.3534 | 37.7579888974289 | -122.495733484153 | (37.7579888974289, -122.495733484153) | 1 | 8 | 3 | 56 | 35 | |||
65616 | 86757 | Permitted Site 7 | Prunus spp :: Cherry 68 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
66506 | 200248 | DPW Maintained 1 | :: 45 | 1107 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.7197997141545 | -122.392672078819 | (37.7197997141545, -122.392672078819) | 10 | 3 | 8 | 58 | 1 | |||
66895 | 185407 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 22 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985075.6429 | 2099093.416 | 37.742847892869 | -122.494264605229 | (37.742847892869, -122.494264605229) | 1 | 8 | 3 | 29491 | 35 | |||
67096 | 185405 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 20 | unknown : Yard | Tree | Private 2 | 23 | Width 0ft | 5985107.634 | 2099090.4168 | 37.7428415299236 | -122.494153769583 | (37.7428415299236, -122.494153769583) | 1 | 8 | 3 | 29491 | 35 | |||
68121 | 186559 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 30 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984761.8792 | 2104726.5714 | 37.7582966244824 | -122.495764931436 | (37.7582966244824, -122.495764931436) | 1 | 8 | 3 | 56 | 35 | |||
68762 | 87112 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 3 | unknown : Yard | Tree | Private 2 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694 | 2096460 | 37.7360022829337 | -122.471188578306 | (37.7360022829337, -122.471188578306) | 1 | 8 | 4 | 29491 | 40 | |||
69315 | 138260 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | 15 | 5 | 1 | 54 | 16 | |||
69782 | 185391 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2300 Sunset Blvd | 2 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985125.1292 | 2098935.9595 | 37.7424184556167 | -122.494081895619 | (37.7424184556167, -122.494081895619) | 1 | 8 | 3 | 29491 | 35 | |||
69996 | 200194 | DPW Maintained 1 | :: 45 | 1011 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014781.1104 | 2089713.252 | 37.7187854464432 | -122.390895127615 | (37.7187854464432, -122.390895127615) | 10 | 3 | 8 | 58 | 1 | |||
71340 | 185404 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 18 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985080.6415 | 2099060.4251 | 37.7427576012847 | -122.494244890555 | (37.7427576012847, -122.494244890555) | 1 | 8 | 3 | 29491 | 35 | |||
71785 | 200213 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013590.5861 | 2090251.1677 | 37.7201963256026 | -122.395047981349 | (37.7201963256026, -122.395047981349) | 10 | 3 | 8 | 58 | 1 | |||
72016 | 186632 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | 1 | 8 | 3 | 56 | 35 | |||
72190 | 186532 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984706.503 | 2104907.5647 | 37.7587903384946 | -122.495969795836 | (37.7587903384946, -122.495969795836) | 1 | 8 | 3 | 56 | 35 | |||
73349 | 86764 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
73454 | 185493 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 46 | unknown : Yard | Tree | Private 2 | 19 | Width 0ft | 5985113.7687 | 2098601.3804 | 37.7414991268893 | -122.494096522375 | (37.7414991268893, -122.494096522375) | 1 | 8 | 3 | 29491 | 35 | |||
73735 | 186507 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980898.797 | 2105106.7845 | 37.759113588816 | -122.509153157003 | (37.759113588816, -122.509153157003) | 1 | 8 | 3 | 56 | 35 | |||
73741 | 185501 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 55 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985131.6978 | 2098729.54 | 37.7418520677037 | -122.494043973834 | (37.7418520677037, -122.494043973834) | 1 | 8 | 3 | 29491 | 35 | |||
74549 | 185478 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2400 Sunset Blvd | 30 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985137.6741 | 2098467.2445 | 37.7411322246193 | -122.494003983523 | (37.7411322246193, -122.494003983523) | 1 | 8 | 3 | 29491 | 35 | |||
74798 | 186517 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 1400 Lower Great Hwy | 3 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 5980906.8218 | 2104997.2844 | 37.7588134060814 | -122.509117272676 | (37.7588134060814, -122.509117272676) | 1 | 8 | 3 | 56 | 35 | |||
74819 | 105668 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 301X DORADO TER | 2 | unknown : Yard | Tree | Private 2 | 12 | 5994306.4 | 2092922 | 37.7264385629619 | -122.461900058607 | (37.7264385629619, -122.461900058607) | 9 | 8 | 4 | 28861 | 40 | ||||
74858 | 186484 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 24 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980883.7828 | 2105293.6854 | 37.7596258798004 | -122.509218961888 | (37.7596258798004, -122.509218961888) | 1 | 8 | 3 | 56 | 35 | |||
75061 | 200171 | DPW Maintained 1 | :: 45 | 1059 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | 10 | 3 | 8 | 58 | 1 | |||
75714 | 114950 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 1X WOODACRE DR | 2 | unknown : Yard | Tree | DPW 1 | 30x100 | 5991187 | 2095315 | 37.7328290635508 | -122.472857998502 | (37.7328290635508, -122.472857998502) | 1 | 8 | 4 | 64 | 40 | ||||
77012 | 200166 | DPW Maintained 1 | :: 45 | 1023 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | 10 | 3 | 8 | 58 | 1 | |||
77041 | 186492 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 22 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | 1 | 8 | 3 | 56 | 35 | |||
77887 | 185419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 35 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985098.1367 | 2099271.3668 | 37.7433378139676 | -122.494199942389 | (37.7433378139676, -122.494199942389) | 1 | 8 | 3 | 29491 | 35 | |||
78275 | 183037 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2523 43rd Ave | 1 | unknown : Yard | Tree | Private 2 | 15 | Width 0ft | 5983009.062 | 2097931.9719 | 37.7395377337872 | -122.501324253443 | (37.7395377337872, -122.501324253443) | 1 | 8 | 3 | 29491 | 35 | |||
78404 | 185480 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 33 | unknown : Yard | Tree | Private 2 | 16 | Width 0ft | 5985125.7214 | 2098482.5174 | 37.7411734605092 | -122.494046436406 | (37.7411734605092, -122.494046436406) | 1 | 8 | 3 | 29491 | 35 | |||
79420 | 185488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 41 | unknown : Yard | Tree | Private 2 | 27 | Width 0ft | 5985122.4012 | 2098536.3046 | 37.7413209513977 | -122.494061879541 | (37.7413209513977, -122.494061879541) | 1 | 8 | 3 | 29491 | 35 | |||
79662 | 186630 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 6 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.509326793851 | (37.7606655657469, -122.509326793851) | 1 | 8 | 3 | 56 | 35 | |||
79908 | 186560 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Sunset Blvd | 31 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5984754.3422 | 2104716.1033 | 37.7582674405997 | -122.495790225123 | (37.7582674405997, -122.495790225123) | 1 | 8 | 3 | 56 | 35 | |||
80134 | 185495 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 48 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985112.4406 | 2098617.3174 | 37.7415428078832 | -122.494102288748 | (37.7415428078832, -122.494102288748) | 1 | 8 | 3 | 29491 | 35 | |||
80411 | 186483 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 38 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980878.6055 | 2105409.1394 | 37.7599425780444 | -122.509245441233 | (37.7599425780444, -122.509245441233) | 1 | 8 | 3 | 56 | 35 | |||
81680 | 186561 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 32 | unknown : Yard | Tree | Private 2 | 85 | Width 0ft | 5984740.943 | 2104715.6846 | 37.7582655062463 | -122.495836533834 | (37.7582655062463, -122.495836533834) | 1 | 8 | 3 | 56 | 35 | |||
84797 | 186549 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 20 | unknown : Yard | Tree | Private 2 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | 1 | 8 | 3 | 56 | 35 | |||
86075 | 100243 | Private 9 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard | Tree | Private 2 | 6008043 | 2100485 | 37.7479861507453 | -122.414948142067 | (37.7479861507453, -122.414948142067) | 2 | 7 | 7 | 28859 | 2 | ||||||
86077 | 200212 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013545.648 | 2090276.655 | 37.7202638095936 | -122.395205102903 | (37.7202638095936, -122.395205102903) | 10 | 3 | 8 | 58 | 1 | |||
86386 | 186518 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1400 Lower Great Hwy | 4 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.7588231736816 | -122.509128284969 | (37.7588231736816, -122.509128284969) | 1 | 8 | 3 | 56 | 35 | |||
87926 | 185461 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 11 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985111.1125 | 2098351.0376 | 37.7408115975576 | -122.494087259969 | (37.7408115975576, -122.494087259969) | 1 | 8 | 3 | 29491 | 35 | |||
88943 | 186550 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 21 | unknown : Yard | Tree | Private 2 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | 1 | 8 | 3 | 56 | 35 | |||
89916 | 200231 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1079 Ingerson Ave | 5 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 6013732.1076 | 2090145.865 | 37.7199150541563 | -122.394551415253 | (37.7199150541563, -122.394551415253) | 10 | 3 | 8 | 58 | 1 | |||
90677 | 200229 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1079 Ingerson Ave | 3 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 6013701.2545 | 2090170.6816 | 37.7199814803008 | -122.394659801452 | (37.7199814803008, -122.394659801452) | 10 | 3 | 8 | 58 | 1 | |||
91321 | 186519 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Lower Great Hwy | 7 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980902.9388 | 2105057.6001 | 37.758978786758 | -122.509135180581 | (37.758978786758, -122.509135180581) | 1 | 8 | 3 | 56 | 35 | |||
91743 | 185417 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 33 | unknown : Yard | Tree | Private 2 | 24 | Width 0ft | 5985081.6412 | 2099246.8736 | 37.7432695969748 | -122.494255173768 | (37.7432695969748, -122.494255173768) | 1 | 8 | 3 | 29491 | 35 | |||
91759 | 185458 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.494035231844 | (37.7407559309555, -122.494035231844) | 1 | 8 | 3 | 29491 | 35 | |||
93116 | 186569 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 40 | unknown : Yard | Tree | Private 2 | 26 | Width 0ft | 5984763.5541 | 2104672.9747 | 37.7581495609485 | -122.495755185517 | (37.7581495609485, -122.495755185517) | 1 | 8 | 3 | 56 | 35 | |||
94199 | 185473 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 25 | unknown : Yard | Tree | Private 2 | 12 | Width 0ft | 5985104.4721 | 2098432.7145 | 37.7410354717752 | -122.494116238038 | (37.7410354717752, -122.494116238038) | 1 | 8 | 3 | 29491 | 35 | |||
94232 | 200742 | DPW Maintained 1 | :: 45 | 1454 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.7331467841736 | -122.387617287866 | (37.7331467841736, -122.387617287866) | 10 | 3 | 8 | 58 | 1 | |||
94439 | 186509 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 10 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | 1 | 8 | 3 | 56 | 35 | |||
95422 | 185452 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2400 Sunset Blvd | 2 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985111.1125 | 2098241.4711 | 37.7405107574318 | -122.494079186673 | (37.7405107574318, -122.494079186673) | 1 | 8 | 3 | 29491 | 35 | |||
95954 | 200161 | DPW Maintained 1 | :: 45 | 1083 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | 10 | 3 | 8 | 58 | 1 | |||
96178 | 186633 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | 1 | 8 | 3 | 56 | 35 | |||
96224 | 186541 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.495831387136 | (37.7587075661518, -122.495831387136) | 1 | 8 | 3 | 56 | 35 | |||
97541 | 138266 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2600 GEARY BLVD | 34 | unknown : Yard | Tree | Private 2 | 19 | Width 0ft | 5999024.6838 | 2113178.2607 | 37.7823277718518 | -122.447046304257 | (37.7823277718518, -122.447046304257) | 15 | 5 | 1 | 54 | 16 | |||
97657 | 185422 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 38 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985084.6404 | 2099285.363 | 37.7433754539691 | -122.494247639854 | (37.7433754539691, -122.494247639854) | 1 | 8 | 3 | 29491 | 35 | |||
97709 | 200156 | DPW Maintained 1 | :: 45 | 1047 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | 10 | 3 | 8 | 58 | 1 | |||
98768 | 185397 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985126.1289 | 2099011.9385 | 37.742627131937 | -122.494084037578 | (37.742627131937, -122.494084037578) | 1 | 8 | 3 | 29491 | 35 | |||
99224 | 186530 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984710.6902 | 2104914.2643 | 37.7588089789692 | -122.495955809021 | (37.7588089789692, -122.495955809021) | 1 | 8 | 3 | 56 | 35 | |||
99469 | 186539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984748.3754 | 2104879.0915 | 37.7587146113666 | -122.49582288356 | (37.7587146113666, -122.49582288356) | 1 | 8 | 3 | 56 | 35 | |||
99939 | 186540 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 11 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984760.5184 | 2104876.1604 | 37.7587072745291 | -122.495780671922 | (37.7587072745291, -122.495780671922) | 1 | 8 | 3 | 56 | 35 | |||
100708 | 200169 | DPW Maintained 1 | :: 45 | 1061 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.7193145533562 | -122.391792274296 | (37.7193145533562, -122.391792274296) | 10 | 3 | 8 | 58 | 1 | |||
101197 | 186570 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1501 Sunset Blvd | 41 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5984760.623 | 2104719.4531 | 37.7582770060448 | -122.495768750789 | (37.7582770060448, -122.495768750789) | 1 | 8 | 3 | 56 | 35 | |||
102296 | 186625 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980868.2988 | 2105582.371 | 37.7604176144972 | -122.50929395155 | (37.7604176144972, -122.50929395155) | 1 | 8 | 3 | 56 | 35 | |||
103324 | 185401 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 14 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | 1 | 8 | 3 | 29491 | 35 | |||
103805 | 138259 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2600 GEARY BLVD | 27 | unknown : Yard | Tree | Private 2 | 19 | Width 0ft | 5999063.9407 | 2113176.2302 | 37.7823244394372 | -122.446910347135 | (37.7823244394372, -122.446910347135) | 15 | 5 | 1 | 54 | 16 | |||
103836 | 200167 | DPW Maintained 1 | :: 45 | 1019 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014049.3571 | 2089910.443 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | 10 | 3 | 8 | 58 | 1 | |||
105057 | 186572 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 43 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984761.0418 | 2104653.2947 | 37.7580953780168 | -122.495762422342 | (37.7580953780168, -122.495762422342) | 1 | 8 | 3 | 56 | 35 | |||
106032 | 185392 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 38 | Width 0ft | 5985108.1339 | 2098944.4572 | 37.7424407935289 | -122.494141285581 | (37.7424407935289, -122.494141285581) | 1 | 8 | 3 | 29491 | 35 | |||
106271 | 185466 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 18 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985111.7766 | 2098394.8642 | 37.7409319724628 | -122.494088193127 | (37.7409319724628, -122.494088193127) | 1 | 8 | 3 | 29491 | 35 | |||
107456 | 186508 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Lower Great Hwy | 9 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.7591295006299 | -122.509137465432 | (37.7591295006299, -122.509137465432) | 1 | 8 | 3 | 56 | 35 | |||
107754 | 200193 | DPW Maintained 1 | :: 45 | 975 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | 10 | 3 | 8 | 58 | 1 | |||
110315 | 185498 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 52 | unknown : Yard | Tree | Private 2 | 33 | Width 0ft | 5985102.48 | 2098665.7923 | 37.7416753240459 | -122.494140300571 | (37.7416753240459, -122.494140300571) | 1 | 8 | 3 | 29491 | 35 | |||
110820 | 185470 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 22 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985119.081 | 2098414.7854 | 37.7409870981235 | -122.494064405444 | (37.7409870981235, -122.494064405444) | 1 | 8 | 3 | 29491 | 35 | |||
112155 | 186489 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 35 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5980878.6055 | 2105387.9124 | 37.759884294807 | -122.509243864844 | (37.759884294807, -122.509243864844) | 1 | 8 | 3 | 56 | 35 | |||
112574 | 186500 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980882.7473 | 2105316.9833 | 37.7596897880858 | -122.509224273257 | (37.7596897880858, -122.509224273257) | 1 | 8 | 3 | 56 | 35 | |||
113568 | 105140 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 125X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 12 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
113701 | 181357 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 25 | Width 0ft | 5985137.6741 | 2098360.3342 | 37.7408386777143 | -122.49399610624 | (37.7408386777143, -122.49399610624) | 1 | 8 | 3 | 29491 | 35 | |||
114161 | 185460 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.494048228448 | (37.7408122581003, -122.494048228448) | 1 | 8 | 3 | 29491 | 35 | |||
115202 | 186631 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 7 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.509330032989 | (37.7606954284135, -122.509330032989) | 1 | 8 | 3 | 56 | 35 | |||
115629 | 200244 | DPW Maintained 1 | :: 45 | 1123 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.392956785762 | (37.7199591140845, -122.392956785762) | 10 | 3 | 8 | 58 | 1 | |||
115659 | 185507 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 61 | unknown : Yard | Tree | Private 2 | 40 | Width 0ft | 5985116.4249 | 2098801.2563 | 37.7420480876484 | -122.494102066238 | (37.7420480876484, -122.494102066238) | 1 | 8 | 3 | 29491 | 35 | |||
116382 | 185433 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 49 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985073.6434 | 2099396.3323 | 37.7436795021074 | -122.494293841932 | (37.7436795021074, -122.494293841932) | 1 | 8 | 3 | 29491 | 35 | |||
118129 | 186543 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 14 | unknown : Yard | Tree | Private 2 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | 1 | 8 | 3 | 56 | 35 | |||
118244 | 200165 | DPW Maintained 1 | :: 45 | 1071 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.391933349185 | (37.7193896687982, -122.391933349185) | 10 | 3 | 8 | 58 | 1 | |||
119017 | 105441 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 425 WAWONA ST | unknown : Yard | Tree | Private 2 | 5991587.6 | 2097036.5 | 37.7375790508831 | -122.471598439568 | (37.7375790508831, -122.471598439568) | 1 | 8 | 4 | 29491 | 40 | ||||||
119093 | 186511 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 12 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980895.6906 | 2105140.9548 | 37.7592072275053 | -122.509166437696 | (37.7592072275053, -122.509166437696) | 1 | 8 | 3 | 56 | 35 | |||
121852 | 186555 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 26 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5984748.8988 | 2104750.8574 | 37.7583625468943 | -122.495811614145 | (37.7583625468943, -122.495811614145) | 1 | 8 | 3 | 56 | 35 | |||
121880 | 186579 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1501 Sunset Blvd | 50 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984739.2681 | 2104595.0921 | 37.7579342947119 | -122.495833430643 | (37.7579342947119, -122.495833430643) | 1 | 8 | 3 | 56 | 35 | |||
122288 | 186537 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.495841156765 | (37.7587476583889, -122.495841156765) | 1 | 8 | 3 | 56 | 35 | |||
122628 | 200190 | DPW Maintained 1 | :: 45 | 1027 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | 10 | 3 | 8 | 58 | 1 | |||
122689 | 185396 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5985088.1394 | 2098992.4439 | 37.742571382036 | -122.494213955735 | (37.742571382036, -122.494213955735) | 1 | 8 | 3 | 29491 | 35 | |||
122769 | 185451 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 1 | unknown : Yard | Tree | Private 2 | 30 | Width 0ft | 5985130.3697 | 2098228.1903 | 37.7404754187235 | -122.494011625194 | (37.7404754187235, -122.494011625194) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );