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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
987 | 186502 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 30 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980892.5842 | 2105334.0684 | 37.7597372788194 | -122.509191521679 | (37.7597372788194, -122.509191521679) | 1 | 8 | 3 | 56 | 35 | |||
1202 | 254563 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 98x High St | 1 | unknown : Yard | Tree | DPW 1 | 3x3 | 5999731 | 2100707 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | 2 | 4 | 5 | 63 | 22 | ||||
1399 | 185502 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 56 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | 1 | 8 | 3 | 29491 | 35 | |||
2233 | 256484 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 2 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
2735 | 262549 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 3 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | |||
4407 | 185467 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.7409538906719 | -122.494086484448 | (37.7409538906719, -122.494086484448) | 1 | 8 | 3 | 29491 | 35 | |||
5288 | 260453 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 4 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
5768 | 87061 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | unknown : Yard | Tree | Private 2 | 3x3 | Permit Number 50003 | |||||||||||||||
6379 | 186568 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 39 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984708.7013 | 2104680.5118 | 37.7581670432315 | -122.495945443345 | (37.7581670432315, -122.495945443345) | 1 | 8 | 3 | 56 | 35 | |||
7863 | 260451 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 2 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
8305 | 86762 | 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 | ||||
8587 | 260455 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 6 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
8775 | 186544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 15 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | 1 | 8 | 3 | 56 | 35 | |||
9254 | 87113 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 470 West Portal Ave | 4 | 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 | |||
9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
11749 | 200232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 3 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | 10 | 3 | 8 | 58 | 1 | ||
12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
12648 | 260457 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 8 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
12825 | 181360 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 49 | unknown : Yard | Tree | Private 2 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | 1 | 8 | 3 | 29491 | 35 | |||
13102 | 200235 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 923 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 08/20/2020 12:00:00 AM | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | 10 | 3 | 8 | 58 | 1 | ||
14544 | 105135 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X ESMERALDA AVE | 1 | unknown : Yard | Tree | DPW 1 | 26 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
15799 | 186582 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1501 Sunset Blvd | 53 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5984722.9379 | 2104579.1806 | 37.7578896497643 | -122.495888732757 | (37.7578896497643, -122.495888732757) | 1 | 8 | 3 | 56 | 35 | |||
16690 | 260450 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
17811 | 185472 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 24 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985147.6347 | 2098429.3943 | 37.7410288809669 | -122.493966755049 | (37.7410288809669, -122.493966755049) | 1 | 8 | 3 | 29491 | 35 | |||
18816 | 185421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 37 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985094.1378 | 2099288.862 | 37.7433856170495 | -122.494215058601 | (37.7433856170495, -122.494215058601) | 1 | 8 | 3 | 29491 | 35 | |||
19362 | 260454 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 5 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
19609 | 260452 | Property Tree 8 | Myoporum laetum :: Myoporum 62 | 3554 Alemany Blvd | 3 | unknown : Yard | Tree | Private 2 | 3x3 | 5993855 | 2087505 | 37.7115387848875 | -122.463067653224 | (37.7115387848875, -122.463067653224) | 9 | 8 | 6 | 64 | 24 | ||||
19971 | 186635 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1300 Lower Great Hwy | 11 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5980866.0152 | 2105705.863 | 37.7607565533288 | -122.50931102062 | (37.7607565533288, -122.50931102062) | 1 | 8 | 3 | 56 | 35 | |||
21396 | 186498 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 18 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980888.4423 | 2105252.2669 | 37.7595124312164 | -122.5091997715 | (37.7595124312164, -122.5091997715) | 1 | 8 | 3 | 56 | 35 | |||
21512 | 186501 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 29 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980893.6197 | 2105317.501 | 37.7596918505514 | -122.509186710148 | (37.7596918505514, -122.509186710148) | 1 | 8 | 3 | 56 | 35 | |||
21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
21617 | 186533 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 4 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | 1 | 8 | 3 | 56 | 35 | |||
21649 | 185394 | DPW Maintained 1 | Podocarpus macrophyllus :: Yew Pine 137 | 2300 Sunset Blvd | 4 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985078.642 | 2098945.9568 | 37.7424431852403 | -122.494243368761 | (37.7424431852403, -122.494243368761) | 1 | 8 | 3 | 29491 | 35 | |||
21921 | 185481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 34 | unknown : Yard | Tree | Private 2 | 26 | Width 0ft | 5985135.018 | 2098495.7982 | 37.7412104699771 | -122.494015271118 | (37.7412104699771, -122.494015271118) | 1 | 8 | 3 | 29491 | 35 | |||
22713 | 186516 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 2 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980905.2686 | 2104991.5894 | 37.7587976776767 | -122.509122221366 | (37.7587976776767, -122.509122221366) | 1 | 8 | 3 | 56 | 35 | |||
23834 | 107210 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 603 PERALTA AVE | 1 | unknown : Yard | Tree | Private 2 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.408607810015 | (37.7431547125392, -122.408607810015) | 10 | 7 | 7 | 28859 | 2 | ||||
24254 | 186636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 12 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | 1 | 8 | 3 | 56 | 35 | |||
24467 | 186496 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 16 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980891.5487 | 2105237.2527 | 37.7594713896823 | -122.509187913256 | (37.7594713896823, -122.509187913256) | 1 | 8 | 3 | 56 | 35 | |||
25674 | 185500 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2400 Sunset Blvd | 54 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.494111190194 | (37.7417889108579, -122.494111190194) | 1 | 8 | 3 | 29491 | 35 | |||
26015 | 186626 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1300 Lower Great Hwy | 2 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5980879.19 | 2105650.5288 | 37.7606053983358 | -122.509261346313 | (37.7606053983358, -122.509261346313) | 1 | 8 | 3 | 56 | 35 | |||
26072 | 185497 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 51 | unknown : Yard | Tree | Private 2 | 33 | Width 0ft | 5985111.7766 | 2098651.8474 | 37.7416375791026 | -122.494107128969 | (37.7416375791026, -122.494107128969) | 1 | 8 | 3 | 29491 | 35 | |||
26178 | 181359 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 31 | unknown : Yard | Tree | Private 2 | 22 | Width 0ft | 5985110.4485 | 2098473.2209 | 37.741147041149 | -122.494098558838 | (37.741147041149, -122.494098558838) | 1 | 8 | 3 | 29491 | 35 | |||
26196 | 185484 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2400 Sunset Blvd | 37 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985117.0889 | 2098499.1184 | 37.7412185372668 | -122.494077507295 | (37.7412185372668, -122.494077507295) | 1 | 8 | 3 | 29491 | 35 | |||
26314 | 200498 | DPW Maintained 1 | :: 45 | 1055 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | 10 | 3 | 8 | 58 | 1 | |||
27177 | 101951 | Property Tree 8 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard | Tree | Private 2 | 6003106 | 2094969 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | 9 | 7 | 5 | 28861 | 25 | ||||||
28661 | 142738 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 BAY ST | 3 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 6009098.7568 | 2121462.5595 | 37.805644845194 | -122.412780209055 | (37.805644845194, -122.412780209055) | 3 | 1 | 10 | 308 | 23 | |||
28805 | 200245 | DPW Maintained 1 | :: 45 | 1075 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.7198415597531 | -122.394424294358 | (37.7198415597531, -122.394424294358) | 10 | 3 | 8 | 58 | 1 | |||
30476 | 185415 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 31 | unknown : Yard | Tree | Private 2 | 16 | Width 0ft | 5985091.6384 | 2099216.8819 | 37.743187832897 | -122.494218396427 | (37.743187832897, -122.494218396427) | 1 | 8 | 3 | 29491 | 35 | |||
32067 | 185505 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 59 | unknown : Yard | Tree | Private 2 | 19 | Width 0ft | 5985087.8712 | 2098781.9991 | 37.7419935417222 | -122.494199375365 | (37.7419935417222, -122.494199375365) | 1 | 8 | 3 | 29491 | 35 | |||
33445 | 185494 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 47 | unknown : Yard | Tree | Private 2 | 25 | Width 0ft | 5985136.346 | 2098616.6534 | 37.7415423835049 | -122.494019584309 | (37.7415423835049, -122.494019584309) | 1 | 8 | 3 | 29491 | 35 | |||
34911 | 185504 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 58 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.494105581845 | (37.7420078978362, -122.494105581845) | 1 | 8 | 3 | 29491 | 35 | |||
35872 | 200227 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1079 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 6013668.3894 | 2090192.8153 | 37.7200404277679 | -122.394774954905 | (37.7200404277679, -122.394774954905) | 10 | 3 | 8 | 58 | 1 | |||
36043 | 185476 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985139.6662 | 2098449.3154 | 37.741083112699 | -122.493995774621 | (37.741083112699, -122.493995774621) | 1 | 8 | 3 | 29491 | 35 | |||
37694 | 86761 | Permitted Site 7 | Arbutus unedo :: Strawberry Tree 106 | 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 | |||||
38006 | 186548 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 11 | Width 0ft | 5984713.0979 | 2104804.2446 | 37.7585070365446 | -122.49593936599 | (37.7585070365446, -122.49593936599) | 1 | 8 | 3 | 56 | 35 | |||
38575 | 185464 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 16 | unknown : Yard | Tree | Private 2 | 46 | Width 0ft | 5985103.8081 | 2098378.9273 | 37.7408877477521 | -122.494114570537 | (37.7408877477521, -122.494114570537) | 1 | 8 | 3 | 29491 | 35 | |||
38915 | 186491 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 21 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5980895.1728 | 2105273.4939 | 37.759571111269 | -122.509178070846 | (37.759571111269, -122.509178070846) | 1 | 8 | 3 | 56 | 35 | |||
39595 | 185474 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2400 Sunset Blvd | 26 | unknown : Yard | Tree | Private 2 | 27 | Width 0ft | 5985113.1047 | 2098438.0268 | 37.7410505630538 | -122.494086781525 | (37.7410505630538, -122.494086781525) | 1 | 8 | 3 | 29491 | 35 | |||
39788 | 186497 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 17 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | 1 | 8 | 3 | 56 | 35 | |||
40118 | 142638 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 333 BAY ST | 2 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 6009068.3546 | 2121458.9525 | 37.8056332348144 | -122.412885165433 | (37.8056332348144, -122.412885165433) | 3 | 1 | 10 | 308 | 23 | |||
40373 | 186512 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 13 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | 1 | 8 | 3 | 56 | 35 | |||
41424 | 200250 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 917 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 6014641.601 | 2089467.7692 | 37.7181036570096 | -122.391360208379 | (37.7181036570096, -122.391360208379) | 10 | 3 | 8 | 58 | 1 | |||
41505 | 185426 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 42 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985086.6398 | 2099317.3541 | 37.7434634098799 | -122.494243084048 | (37.7434634098799, -122.494243084048) | 1 | 8 | 3 | 29491 | 35 | |||
43178 | 185424 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 40 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985084.6404 | 2099301.8584 | 37.7434207458763 | -122.494248855446 | (37.7434207458763, -122.494248855446) | 1 | 8 | 3 | 29491 | 35 | |||
43382 | 186503 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 31 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5980885.336 | 2105334.0684 | 37.7597368514834 | -122.509216589167 | (37.7597368514834, -122.509216589167) | 1 | 8 | 3 | 56 | 35 | |||
44209 | 186506 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 6 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5980906.3041 | 2105016.4405 | 37.7588659727132 | -122.509120485578 | (37.7588659727132, -122.509120485578) | 1 | 8 | 3 | 56 | 35 | |||
44572 | 181354 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2300 Sunset Blvd | 19 | unknown : Yard | Tree | Private 2 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.7427971401188 | -122.494261514147 | (37.7427971401188, -122.494261514147) | 1 | 8 | 3 | 29491 | 35 | |||
45777 | 186843 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 33 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5980882.2296 | 2105351.6713 | 37.7597850008387 | -122.509228639712 | (37.7597850008387, -122.509228639712) | 1 | 8 | 3 | 56 | 35 | |||
45981 | 185462 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 2400 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985138.3382 | 2098374.943 | 37.740878828405 | -122.493994886454 | (37.740878828405, -122.493994886454) | 1 | 8 | 3 | 29491 | 35 | |||
46378 | 185499 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 2400 Sunset Blvd | 53 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985130.3697 | 2098685.0494 | 37.741729830799 | -122.494045287668 | (37.741729830799, -122.494045287668) | 1 | 8 | 3 | 29491 | 35 | |||
47281 | 186628 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1300 Lower Great Hwy | 4 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980874.0957 | 2105652.4611 | 37.760610403518 | -122.509279108369 | (37.760610403518, -122.509279108369) | 1 | 8 | 3 | 56 | 35 | |||
47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
47826 | 186634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300 Lower Great Hwy | 10 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | 1 | 8 | 3 | 56 | 35 | |||
48446 | 185418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 34 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985092.1383 | 2099264.8686 | 37.7433196206545 | -122.494220204145 | (37.7433196206545, -122.494220204145) | 1 | 8 | 3 | 29491 | 35 | |||
48827 | 185468 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 20 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985131.0337 | 2098396.1923 | 37.7409367458634 | -122.494021708019 | (37.7409367458634, -122.494021708019) | 1 | 8 | 3 | 29491 | 35 | |||
49179 | 86765 | 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 | ||||
49684 | 138263 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2600 GEARY BLVD | 31 | unknown : Yard | Tree | Private 2 | 17 | Width 0ft | 5999038.5591 | 2113167.7696 | 37.7822997587534 | -122.446997546851 | (37.7822997587534, -122.446997546851) | 15 | 5 | 1 | 54 | 16 | |||
49732 | 186510 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 11 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.7591962518414 | -122.509142853237 | (37.7591962518414, -122.509142853237) | 1 | 8 | 3 | 56 | 35 | |||
49833 | 186558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 29 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5984755.5984 | 2104741.6454 | 37.7583376456641 | -122.495787764797 | (37.7583376456641, -122.495787764797) | 1 | 8 | 3 | 56 | 35 | |||
50432 | 185406 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 21 | unknown : Yard | Tree | Private 2 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.7428760469646 | -122.494142591708 | (37.7428760469646, -122.494142591708) | 1 | 8 | 3 | 29491 | 35 | |||
50825 | 200155 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.7196076106807 | -122.392358707449 | (37.7196076106807, -122.392358707449) | 10 | 3 | 8 | 58 | 1 | |||
50901 | 185402 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 16 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.7427121969825 | -122.494088049359 | (37.7427121969825, -122.494088049359) | 1 | 8 | 3 | 29491 | 35 | |||
50928 | 105667 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 301X DORADO TER | 1 | unknown : Yard | Tree | Private 2 | 5994306.4 | 2092922 | 37.7264385629619 | -122.461900058607 | (37.7264385629619, -122.461900058607) | 9 | 8 | 4 | 28861 | 40 | |||||
51838 | 186505 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1400 Lower Great Hwy | 5 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | 1 | 8 | 3 | 56 | 35 | |||
52493 | 185399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985110.1333 | 2099026.9344 | 37.7426673706481 | -122.494140449924 | (37.7426673706481, -122.494140449924) | 1 | 8 | 3 | 29491 | 35 | |||
54336 | 186575 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunset Blvd | 46 | unknown : Yard | Tree | Private 2 | 30 | Width 0ft | 5984766.4852 | 2104638.2207 | 37.7580543077882 | -122.495742485113 | (37.7580543077882, -122.495742485113) | 1 | 8 | 3 | 56 | 35 | |||
54606 | 185398 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2300 Sunset Blvd | 11 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985116.1317 | 2099019.9363 | 37.7426485067542 | -122.494119193821 | (37.7426485067542, -122.494119193821) | 1 | 8 | 3 | 29491 | 35 | |||
58275 | 86763 | 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 | ||||
58962 | 185390 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 2300 Sunset Blvd | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985092.6382 | 2098924.4627 | 37.7423849872747 | -122.4941933909 | (37.7423849872747, -122.4941933909) | 1 | 8 | 3 | 29491 | 35 | |||
60303 | 86768 | Permitted Site 7 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 | 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 | |||||
60315 | 186488 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1400 Lower Great Hwy | 34 | unknown : Yard | Tree | Private 2 | 15 | Width 0ft | 5980888.4423 | 2105382.2174 | 37.7598692379346 | -122.50920942184 | (37.7598692379346, -122.50920942184) | 1 | 8 | 3 | 56 | 35 | |||
60436 | 138256 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2600 GEARY BLVD | 1 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5999357.6908 | 2113236.4692 | 37.7825066175753 | -122.445898439469 | (37.7825066175753, -122.445898439469) | 15 | 5 | 1 | 54 | 16 | |||
60852 | 186535 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1501 Sunset Blvd | 6 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | 1 | 8 | 3 | 56 | 35 | |||
60913 | 186485 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 1400 Lower Great Hwy | 25 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 5980894.6551 | 2105298.8627 | 37.7596407361809 | -122.509181745183 | (37.7596407361809, -122.509181745183) | 1 | 8 | 3 | 56 | 35 | |||
60950 | 200230 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1079 Ingerson Ave | 4 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 6013720.7054 | 2090151.9015 | 37.7199309952824 | -122.394591251483 | (37.7199309952824, -122.394591251483) | 10 | 3 | 8 | 58 | 1 | |||
61239 | 186542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | 1 | 8 | 3 | 56 | 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) );