trees
53 rows where Zip Codes = 56 and qLegalStatus_id = 6 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | |||
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 | ||||
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 | |
123649 | 98302 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
180522 | 98301 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 6 Locksley Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 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 | ||||
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 | ||||
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 | ||||
75471 | 98104 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | ||||
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 | |||
93603 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 6 | Front Yard : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
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 | ||
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 | ||||
167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 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 | |
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 | ||||||
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 | |
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 | |
80420 | 105436 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 15 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
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 | |||
155656 | 105435 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 16 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 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 | |
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 | ||||
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 | ||||
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 | |||||
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 | |||
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 | |||||
153784 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 1 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
163794 | 100464 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 3 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
168323 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 2 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 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 | |||
125728 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 6 Locksley Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5994194 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | 1 | 5 | 4 | 56 | 12 | |||||
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 | |||
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 | |||
77181 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
122339 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
96515 | 253513 | Significant Tree 6 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | 3x3 | Permit Number 768941 | 5994803.92058 | 2105050.88998 | 37.7597700982665 | -122.461058902115 | (37.7597700982665, -122.461058902115) | 1 | 5 | 4 | 56 | 12 | ||
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 |
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) );