trees
416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by Location 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50301 | 254481 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1274 11th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5992738 | 2106820 | 37.7645085090972 | -122.468332545675 | (37.7645085090972, -122.468332545675) | 11 | 8 | 11 | 56 | 12 | ||||
24761 | 101258 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1049 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992548 | 2106581 | 37.7638413023971 | -122.468972303767 | (37.7638413023971, -122.468972303767) | 1 | 8 | 11 | 56 | 12 | ||||
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 | |||
10025 | 264885 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1279 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 787806 | 5982392 | 2106415 | 37.7627934961857 | -122.504085938563 | (37.7627934961857, -122.504085938563) | 1 | 8 | 3 | 56 | 35 | |||
99362 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991942 | 2105939 | 37.7620435090796 | -122.471021481615 | (37.7620435090796, -122.471021481615) | 1 | 8 | 11 | 56 | 12 | |||||
188643 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | 1 | 8 | 4 | 56 | 12 | |
127456 | 107197 | Significant Tree 6 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 339 Kirkham St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/07/2014 12:00:00 AM | 3x3 | Permit Number 773549 | 5993785.2645 | 2105241.58741 | 37.7602350326789 | -122.464595750688 | (37.7602350326789, -122.464595750688) | 1 | 8 | 4 | 56 | 12 | ||
194374 | 265048 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 959 Kirkham St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | 5991956 | 2105209 | 37.7600399316741 | -122.470919881603 | (37.7600399316741, -122.470919881603) | 1 | 8 | 4 | 56 | 12 | ||||
101005 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 6 | 1499X 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
183804 | 121087 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1443 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778784 | 5981521.32072 | 2105258.5458 | 37.7595669638281 | -122.507011468719 | (37.7595669638281, -122.507011468719) | 1 | 8 | 3 | 56 | 35 | |||
183573 | 104808 | Significant Tree 6 | Ilex aquifolium :: European Holly 390 | 1665 08th Ave | Front Yard : Yard | Tree | Private 2 | 40 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.464904006701 | (37.7572689897716, -122.464904006701) | 1 | 8 | 4 | 56 | 12 | |||||
183605 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 390 | 1665 18TH AVE | Front Yard : Yard | Tree | Private 2 | 50 | 9x9 | 5990543.2 | 2104073 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | 1 | 8 | 4 | 56 | 12 | ||||
186272 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 390 | 1665 18TH AVE | Front Yard : Yard | Tree | Private 2 | 50 | 9x9 | 5990543.2 | 2104073 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | 1 | 8 | 4 | 56 | 12 | ||||
117949 | 254767 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900x Moraga St | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5991390 | 2103897 | 37.7564047756354 | -122.47278171886 | (37.7564047756354, -122.47278171886) | 1 | 8 | 4 | 56 | 12 | ||||
4096 | 261159 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
6747 | 261157 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
9381 | 261160 | Significant Tree 6 | Tree(s) :: 17 | 1100X Moraga St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |
11981 | 261158 | Significant Tree 6 | Juniperus californica :: California juniper 295 | 1100X Moraga St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784837 | 5990881 | 2103853 | 37.7562544846391 | -122.474538790377 | (37.7562544846391, -122.474538790377) | 1 | 8 | 4 | 56 | 12 | |||
63888 | 254137 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1619 47th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 6x6 | 5981543 | 2104041 | 37.756225206981 | -122.506846181577 | (37.756225206981, -122.506846181577) | 1 | 8 | 3 | 56 | 35 | ||||
83312 | 254136 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1623 47th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x6 | Permit Number 781075 | 5981544 | 2104016 | 37.7561566229771 | -122.506840869024 | (37.7561566229771, -122.506840869024) | 1 | 8 | 3 | 56 | 35 | |||
14866 | 259322 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1721 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 11/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783194 | 5990247 | 2103661 | 37.7556905489205 | -122.476717329726 | (37.7556905489205, -122.476717329726) | 1 | 8 | 3 | 56 | 35 | |
75557 | 254361 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 1749 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | 5993372 | 2103579 | 37.7556461665355 | -122.465904219148 | (37.7556461665355, -122.465904219148) | 1 | 8 | 4 | 56 | 12 | ||||
14911 | 264785 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1738 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10x10 | 5991929 | 2103547 | 37.7554749546691 | -122.470892190435 | (37.7554749546691, -122.470892190435) | 1 | 8 | 4 | 56 | 12 | ||||
13325 | 259319 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1746 20th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5990028 | 2103516 | 37.7552797120334 | -122.477464095722 | (37.7552797120334, -122.477464095722) | 1 | 8 | 3 | 56 | 35 | ||||
172960 | 173598 | Significant Tree 6 | Casuarina cunninghamiana :: Horsetail pine 112 | 1771 11th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992768 | 2103420 | 37.7551747322674 | -122.467981458634 | (37.7551747322674, -122.467981458634) | 1 | 8 | 4 | 56 | 12 | |||
7291 | 105130 | Significant Tree 6 | Tree(s) :: 17 | 4045 MORAGA ST | Sidewalk: Property side : Yard | Tree | Private 2 | 5981665.2 | 2103465.9 | 37.7546533409301 | -122.506380933635 | (37.7546533409301, -122.506380933635) | 1 | 8 | 3 | 56 | 35 | ||||||
185053 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Cascade Walk | 1 | Front Yard : Yard | Tree | Private 2 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | 1 | 8 | 4 | 56 | 12 | |||||
43207 | 111069 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
75962 | 111070 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1836 08TH AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | |||
97746 | 111068 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1836 08TH AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x15 | 5993799 | 2102987 | 37.7540453100112 | -122.464384550175 | (37.7540453100112, -122.464384550175) | 1 | 8 | 4 | 56 | 12 | ||||
8974 | 260925 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 1900 Noriega St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5987961.4849 | 2103092.5821 | 37.7539969916819 | -122.484579575666 | (37.7539969916819, -122.484579575666) | 1 | 8 | 3 | 56 | 35 | ||||
101814 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1860 09TH AVE | 2 | Front Yard : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494 | 2102835 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | 1 | 8 | 4 | 56 | 12 | ||
43088 | 112378 | Significant Tree 6 | :: 45 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | |||
178381 | 254173 | Significant Tree 6 | Geijera parviflora :: Australian Willow 25 | 1850 19th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x6 | 5990394 | 2102783 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | 1 | 8 | 4 | 56 | 12 | ||||
16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
68 | 264976 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 2 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
97021 | 105907 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 1837 30TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 5986904 | 2102674 | 37.7527860393128 | -122.488205804709 | (37.7527860393128, -122.488205804709) | 1 | 8 | 3 | 56 | 35 | ||||
95967 | 254201 | Significant Tree 6 | Tree(s) :: 17 | 55X Aerial Way | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781191 | 5992360 | 2102538 | 37.7527294198072 | -122.469328234463 | (37.7527294198072, -122.469328234463) | 1 | 8 | 4 | 56 | 12 | |||
21303 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout | Tree | Private 2 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727 | 2102215 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | 1 | 8 | 4 | 29491 | 12 | |
165013 | 85367 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1990 09th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49643 | 5993523.3 | 2101996.8 | 37.7513105791605 | -122.465266058842 | (37.7513105791605, -122.465266058842) | 1 | 8 | 4 | 29491 | 12 | |||
85339 | 115176 | Significant Tree 6 | Tree(s) :: 17 | 460 Pacheco St | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2016 12:00:00 AM | 10x10 | Permit Number 775764 | 5993727.4 | 2101897.6 | 37.7510499693469 | -122.464553061226 | (37.7510499693469, -122.464553061226) | 1 | 8 | 4 | 29491 | 12 | ||
194359 | 262298 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 1 | Side Yard : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x10 | Permit Number 787936 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |
16256 | 260911 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2035 15th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 5991575 | 2101572 | 37.7500316406912 | -122.471972478281 | (37.7500316406912, -122.471972478281) | 1 | 8 | 4 | 29491 | 12 | ||||
145907 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5991666 | 2101424 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | 1 | 8 | 4 | 29491 | 12 | ||||
59764 | 105504 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 39 MAGELLAN AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5994694.1 | 2101166.3 | 37.7490976851152 | -122.461157135733 | (37.7490976851152, -122.461157135733) | 1 | 8 | 4 | 29491 | 40 | ||||
156684 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | 1 | 8 | 4 | 29491 | 40 | |||
159746 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445 | 2101187 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | 1 | 8 | 4 | 29491 | 40 | |
35440 | 97955 | Significant Tree 6 | Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12/05/2011 12:00:00 AM | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | |||
42536 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
52128 | 112811 | Significant Tree 6 | Tree(s) :: 17 | 2023 43rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5982877.4 | 2101339.2 | 37.7488853101021 | -122.502031530859 | (37.7488853101021, -122.502031530859) | 1 | 8 | 3 | 29491 | 35 | |||||
160882 | 113234 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2023 43RD AVE | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5982877 | 2101339 | 37.7488847374588 | -122.502032899239 | (37.7488847374588, -122.502032899239) | 1 | 8 | 3 | 29491 | 35 | |||
20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
22895 | 256572 | Significant Tree 6 | Ilex aquifolium :: European Holly 390 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994536 | 2100823 | 37.748145970457 | -122.461678955671 | (37.748145970457, -122.461678955671) | 1 | 8 | 4 | 29491 | 40 | ||||
27831 | 98834 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 333 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
122278 | 106109 | Significant Tree 6 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
188800 | 106107 | Significant Tree 6 | Magnolia champaca :: Champa 141 | 135 MENDOSA AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 772704 | 5992893.2 | 2100790.2 | 37.747961208182 | -122.467357269235 | (37.747961208182, -122.467357269235) | 1 | 8 | 4 | 29491 | 40 | |||
107229 | 255805 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
187309 | 106198 | Significant Tree 6 | Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 | 2101 42ND AVE | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 5983206.1 | 2100796.8 | 37.7474153345648 | -122.500854798087 | (37.7474153345648, -122.500854798087) | 1 | 8 | 3 | 29491 | 35 | ||||
45348 | 93222 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
67970 | 93221 | Significant Tree 6 | Tree(s) :: 17 | 85 Santa Rita Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/26/2010 12:00:00 AM | Permit Number 53213 | 5993788 | 2100441 | 37.7470540096767 | -122.464237765204 | (37.7470540096767, -122.464237765204) | 1 | 8 | 4 | 29491 | 40 | |||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
6296 | 260461 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784513 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |||
66926 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 2 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
94784 | 253250 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99X Lopez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
102553 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 270 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
144280 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 270 Castenada Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780226 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | |
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
95583 | 102077 | Significant Tree 6 | Ulmus glabra :: Scotch Elm 531 | 273 Magellan Ave | 7 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
106522 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 138 | 273 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
110154 | 102074 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 273 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
40036 | 104493 | Significant Tree 6 | Acer circinatum :: Vine Maple 452 | 171 SAN MARCOS AVE | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770388 | 5993514 | 2100282 | 37.7466016393389 | -122.465173679454 | (37.7466016393389, -122.465173679454) | 1 | 8 | 4 | 29491 | 40 | ||||
69183 | 104494 | Significant Tree 6 | Acer circinatum :: Vine Maple 452 | 171 SAN MARCOS AVE | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770388 | 5993514 | 2100282 | 37.7466016393389 | -122.465173679454 | (37.7466016393389, -122.465173679454) | 1 | 8 | 4 | 29491 | 40 | ||||
76823 | 255913 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 121 San Marcos Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5993694 | 2100263 | 37.7465598483618 | -122.464549884035 | (37.7465598483618, -122.464549884035) | 1 | 8 | 4 | 29491 | 40 | ||||
6370 | 261832 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 16 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995265 | 2100184 | 37.7464333732005 | -122.459111852123 | (37.7464333732005, -122.459111852123) | 1 | 8 | 4 | 59 | 40 | ||||
194467 | 265133 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 2166 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/11/2021 12:00:00 AM | 3 | 3x3 | Permit Number 783123 | 5983589.67085 | 2100408.11005 | 37.7463706120083 | -122.499499736486 | (37.7463706120083, -122.499499736486) | 1 | 8 | 3 | 29491 | 35 | |
44754 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2179 41st Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x5 | 5983532 | 2100331 | 37.7461555051432 | -122.499693454208 | (37.7461555051432, -122.499693454208) | 1 | 8 | 3 | 29491 | 35 | ||||
107818 | 98757 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 340 Castenada Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5993579.1 | 2100062.8 | 37.7460035255592 | -122.464932655613 | (37.7460035255592, -122.464932655613) | 1 | 8 | 4 | 29491 | 40 | |||||
52558 | 255280 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
107089 | 255281 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
111294 | 255282 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 3 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
168382 | 255283 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
114772 | 92311 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2211 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5986022.3 | 2100155.2 | 37.7458186185696 | -122.491069496457 | (37.7458186185696, -122.491069496457) | 1 | 8 | 3 | 29491 | 35 | |
20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 | |||
12287 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 Vasquez Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | 1 | 8 | 4 | 59 | 40 | |||||
12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
48743 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 801X Santiago St | 1 | Side Yard : Yard | Tree | Private 2 | 5990274 | 2099728 | 37.7448931297685 | -122.476336677657 | (37.7448931297685, -122.476336677657) | 1 | 8 | 3 | 29491 | 35 | |||||
2657 | 260570 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 4 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
5792 | 260568 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
8040 | 260572 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 6 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11442 | 260571 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
11875 | 260569 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
13149 | 260567 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 | ||||
13972 | 260573 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 129 Edgehill Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5994858 | 2098970 | 37.7430766268484 | -122.460431252252 | (37.7430766268484, -122.460431252252) | 1 | 8 | 4 | 59 | 40 | ||||
8007 | 261753 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 3 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
11628 | 261752 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 2 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
19112 | 261751 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 1 | Back Yard : Cutout | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | 5994849.50332 | 2098967.43632 | 37.7430690988325 | -122.46046044555 | (37.7430690988325, -122.46046044555) | 1 | 8 | 4 | 59 | 40 | |||
125509 | 254393 | Significant Tree 6 | Araucaria heterophylla :: Norfolk Island Pine 238 | 150 Granville Way | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994538 | 2098550 | 37.7419049979895 | -122.461507275162 | (37.7419049979895, -122.461507275162) | 1 | 8 | 4 | 59 | 40 | ||||
12033 | 259149 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 150 Lenox Way | 1 | Front Yard : Yard | Tree | Private 2 | 5x5 | 5993309.4847 | 2098463.34097 | 37.7415962663129 | -122.465748753199 | (37.7415962663129, -122.465748753199) | 1 | 8 | 4 | 59 | 40 |
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) );