trees

202 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Property side : Yard" sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 202 ✖
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)
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
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
13058 260903 Significant Tree 6 Taxus baccata :: Irish Yew 86 51 Shore View Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5984536 2112849 37.7805852728313 -122.497145662996 (37.7805852728313, -122.497145662996) 11 6 2 55 26
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
19844 254259 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
53875 254255 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
92424 254257 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
139664 254256 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
144483 254258 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
18983 262256 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 4210 Ocean Ave 9 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
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
37232 256765 Significant Tree 6 Tree(s) :: 17 355 Serrano Dr 1 Sidewalk: Property side : Yard Tree Private 2   01/15/2019 12:00:00 AM 3 3x3 Permit Number 782555 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
9478 260514 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3025 22nd Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5989750.29916 2095052.76589 37.7320257582668 -122.477805820702 (37.7320257582668, -122.477805820702) 1 8 4 64 35
156060 253715 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 2959 21st Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x15 Permit Number 780322 5989962 2095532 37.7333538971055 -122.477108940264 (37.7333538971055, -122.477108940264) 1 8 4 64 35
160994 253716 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2959 21st Ave 2 Sidewalk: Property side : Yard Tree Private 2       5x15   5989962 2095532 37.7333538971055 -122.477108940264 (37.7333538971055, -122.477108940264) 1 8 4 64 35
19616 262407 Significant Tree 6 Pinus radiata :: Monterey Pine 15 300 Font Blvd 1 Sidewalk: Property side : Yard Tree Private 2       6x5   5990018 2089729 37.7174235665943 -122.476491559856 (37.7174235665943, -122.476491559856) 1 8 4 64 14
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
6044 259265 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
15055 259264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
17333 259266 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
18957 259263 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
59933 122637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
69281 122640 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
94162 122638 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
162024 122639 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
133059 253652 Significant Tree 6 Tree(s) :: 17 131 Font Blvd 2 Sidewalk: Property side : Yard Tree Private 2   11/20/2017 12:00:00 AM 3 10x10 Permit Number 780806 5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
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
43131 116576 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree MTA 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
154657 100850 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Estero Ave 1 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 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
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
144728 253098 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1   08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
192391 253097 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1290 Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2 DPW 08/22/2017 12:00:00 AM 3 3x3   5994035 2097938 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736) 1 8 4 59 40
1002 260458 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 835 Darien Way 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2019 12:00:00 AM 3 6x10 Permit Number 784514 5994066 2094094 37.7296427463027 -122.462816092129 (37.7296427463027, -122.462816092129) 9 8 4 59 40
163821 87242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
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
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
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
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
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
25777 257968 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499X Carl St 2 Sidewalk: Property side : Yard Tree Private 2       10x10   5995946 2106884 37.7648690031923 -122.457241646887 (37.7648690031923, -122.457241646887) 15 5 11 29492 12
37143 257967 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499X Carl St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   5995946 2106884 37.7648690031923 -122.457241646887 (37.7648690031923, -122.457241646887) 15 5 11 29492 12
5115 260959 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree Private 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
1427 260648 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 6 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
4071 260649 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 7 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
55810 116521 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 70 BEAUMONT AVE 1 Sidewalk: Property side : Yard Tree Private 2     10 3x3   5996728 2112568 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336) 11 6 2 54 16
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38
12431 262225 Significant Tree 6 Cupressus spp :: Cypress species 337 2450 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045) 15 6 2 54 16
124269 256872 Significant Tree 6 Tree(s) :: 17 2401X Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3 Permit Number 782666 5997871 2111315 37.7771457625148 -122.450903124986 (37.7771457625148, -122.450903124986) 15 6 2 29492 16
119037 112769 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
133887 112770 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
136074 112773 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
137248 112771 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
140130 112774 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
165386 112772 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
21449 255662 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
85388 255663 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
114550 178337 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 3 Sidewalk: Property side : Yard Tree MTA 3     29     5998676.28102 2091524.00797 37.7228506076618 -122.446693087413 (37.7228506076618, -122.446693087413) 9 7 6 28861 25
63382 177743 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 401 Ocean Ave 4 Sidewalk: Property side : Yard Tree MTA 3     37     5998700.41574 2091522.98281 37.7228491714484 -122.446609585371 (37.7228491714484, -122.446609585371) 9 7 6 28861 25
173815 177104 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 11 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998921.08183 2091519.29315 37.7228516427808 -122.445846526795 (37.7228516427808, -122.445846526795) 9 7 6 28861 25
49633 177105 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 12 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998924.5969 2091518.78116 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179) 9 7 6 28861 25
176521 177106 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 13 Sidewalk: Property side : Yard Tree MTA 3     7 Width 5ft   5998933.17773 2091518.16383 37.7228492325857 -122.445804632792 (37.7228492325857, -122.445804632792) 9 7 6 28861 25
57339 177108 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 15 Sidewalk: Property side : Yard Tree MTA 3     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369564 (37.7228504376851, -122.44574369564) 9 7 6 28861 25
36628 177109 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 16 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998958.08532 2091518.52367 37.7228516427597 -122.445718558684 (37.7228516427597, -122.445718558684) 9 7 6 28861 25
47041 177110 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 17 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998978.57855 2091518.53644 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081) 9 7 6 28861 25
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
143852 98290 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 6 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
165161 98288 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
34770 251426 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
14497 251425 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
30295 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
156627 125128 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2545 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   5999632.15337 2117620.57677 37.7945598973812 -122.44526423016 (37.7945598973812, -122.44526423016) 13 9 1 57 27
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
190335 173903 Significant Tree 6 Pinus radiata :: Monterey Pine 15 675 Corbett Ave 1 Sidewalk: Property side : Yard Tree Private 2           5999984 2103563 37.7559814441149 -122.443036761048 (37.7559814441149, -122.443036761048) 2 5 5 28862 38
13663 258677 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 607 Congo St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   6000094 2095817 37.7347190533418 -122.442100351643 (37.7347190533418, -122.442100351643) 9 7 4 63 40
167295 223958 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000714.90104 2104629.88079 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054) 2 4 5 28862 38
67906 223957 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6000715.72405 2104622.00656 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927) 2 4 5 28862 38
159982 102589 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5157 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415) 2 4 5 63 22
194262 262537 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 65 Ocean Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25
194276 262536 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 65 Ocean Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 785586 6001004.64572 2091720.9184 37.7235240092161 -122.438658540667 (37.7235240092161, -122.438658540667) 9 7 6 28861 25

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);