1,732 rows where qLegalStatus_id = 6 sorted by Longitude

View and edit SQL

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)
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
394 119605 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 299x Avalon Ave 1 Front Yard : Yard Tree Private 2                              
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
2100 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 199X Kissling St 1 Side Yard : Cutout Tree Private 2       5x10                      
3171 119608 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 299x Avalon Ave 4 Front Yard : Yard Tree Private 2                              
3182 261252 Significant Tree 6 Banksia integrifolia :: Coast Banksia 21 100 Collins St 1 Front Yard : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3                        
4934 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
5622 251139 Significant Tree 6 Tree(s) :: 17 621X Gough St 1 Back Yard : Yard Tree Private 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
6834 103660 Significant Tree 6 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7039 119606 Significant Tree 6 Myoporum laetum :: Myoporum 62 299x Avalon Ave 2 Front Yard : Yard Tree Private 2                              
7389 119599 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 1 Front Yard : Yard Tree Private 2         Permit Number 774415                    
7411 103658 Significant Tree 6 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8509 103668 Significant Tree 6 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
11338 85030 Significant Tree 6 Tree(s) :: 17 411 Panama St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2007 12:00:00 AM     Permit Number 49384                    
13434 260582 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2101X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/2019 12:00:00 AM 3 5x5 Permit Number 782628                    
13805 119600 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 2 Front Yard : Yard Tree Private 2         Permit Number 774415                    
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14456 103661 Significant Tree 6 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
15093 119607 Significant Tree 6 Pinus radiata :: Monterey Pine 15 299x Avalon Ave 3 Front Yard : Yard Tree Private 2                              
15289 119601 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 3 Front Yard : Yard Tree Private 2         Permit Number 774415                    
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
16207 254459 Significant Tree 6 Tree(s) :: 17 1055X Duncan St 4 Side Yard : Yard Tree Private 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
18988 103657 Significant Tree 6 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
19367 254458 Significant Tree 6 Tree(s) :: 17 1055X Duncan St 3 Side Yard : Yard Tree Private 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
19573 254456 Significant Tree 6 Juniperus chinensis :: Juniper 113 1055X Duncan St 1 Side Yard : Yard Tree Private 2                              
127144 258338 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 209 Spear St 1 Sidewalk: Property side : Cutout Tree Private 2                              
194363 265042 Significant Tree 6 Tree(s) :: 17 1000X Mandalay Ln 2 Unaccepted Street : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 10x010 Permit Number 787936                    
2201 107549 Significant Tree 6 Tree(s) :: 17 198X Jennings St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
130009 107550 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 198X Jennings St 3 Front Yard : Yard Tree DPW 1           6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
178439 107539 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 198X JENNINGS ST 1 Front Yard : Yard Tree DPW 1           6018784 2097136 37.739388174499 -122.377573417349 (37.739388174499, -122.377573417349) 10 3 8 58 1
36574 107552 Significant Tree 6 Tree(s) :: 17 1 Newhall St 2 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
56372 107551 Significant Tree 6 Tree(s) :: 17 1 Newhall St 1 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
119862 107553 Significant Tree 6 Tree(s) :: 17 1 Newhall St 3 Front Yard : Yard Tree DPW 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726 2097063 37.73918453522 -122.377768892846 (37.73918453522, -122.377768892846) 10 3 8 58 1
20461 104283 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 5 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
30460 104285 Significant Tree 6 Tree(s) :: 17 71X Middle Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
34585 104280 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 2 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
48640 104279 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
59683 104288 Significant Tree 6 Tree(s) :: 17 137X Middle Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
67820 104290 Significant Tree 6 Tree(s) :: 17 11X Hare St 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
126993 104281 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 3 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
132116 104289 Significant Tree 6 Tree(s) :: 17 10X Hare St 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
133125 104286 Significant Tree 6 Tree(s) :: 17 200X West Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
156652 104284 Significant Tree 6 Tree(s) :: 17 45X Middle Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
174752 104282 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 4 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
182512 104287 Significant Tree 6 Tree(s) :: 17 119X Middle Point Rd 1 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
182689 108589 Significant Tree 6 Tree(s) :: 17 1139x HUDSON AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6017760 2094672 37.7325660477977 -122.380942739781 (37.7325660477977, -122.380942739781) 10 3 8 58 1
42183 110954 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Mendell St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6017060.74507 2098543.22184 37.7431570265693 -122.383629676533 (37.7431570265693, -122.383629676533) 10 3 8 58 1
25337 106567 Significant Tree 6 Tree(s) :: 17 50 Mendell St 1 Front Yard : Yard Tree Private 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
51060 106568 Significant Tree 6 Tree(s) :: 17 50 Mendell St 5 Front Yard : Yard Tree Private 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
62092 106569 Significant Tree 6 Tree(s) :: 17 50 Mendell St 6 Front Yard : Yard Tree Private 2   05/09/2014 12:00:00 AM     Permit Number 772455 6017061.8 2098665.7 37.7434933850228 -122.383634554004 (37.7434933850228, -122.383634554004) 10 3 8 58 1
140790 108047 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1301 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2015 12:00:00 AM 3 3x3   6017036.14467 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928) 10 3 8 58 1
162063 113132 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1375 FAIRFAX AVE 1 Front Yard : Yard Tree Private 2           6016814 2097238 37.7395595104895 -122.384391976269 (37.7395595104895, -122.384391976269) 10 3 8 58 1
133009 110951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
141742 110952 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 8 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
146688 110953 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 10 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
96506 97264 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Newhall St 1 Front Yard : Yard Tree Private 2   09/09/2011 12:00:00 AM     Permit Number 768179 6016549.1 2098591.6 37.7432615694897 -122.385402196424 (37.7432615694897, -122.385402196424) 10 3 8 58 1
58489 104690 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1435X La Salle Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
119566 104691 Significant Tree 6 Tree(s) :: 17 1435X La Salle Ave 2 Front Yard : Yard Tree Private 2   10/31/2013 12:00:00 AM     Permit Number 770699 6016460.43075 2095036.98644 37.7334964128222 -122.385461132957 (37.7334964128222, -122.385461132957) 10 3 8 58 1
117587 103942 Significant Tree 6 Tree(s) :: 17 1490X Evans Ave 1 Front Yard : Yard Tree Private 2   06/25/2013 12:00:00 AM     Permit Number 770233 6016485.18907 2097945.03196 37.7414826893772 -122.385578134526 (37.7414826893772, -122.385578134526) 10 3 8 58 1
16142 94943 Significant Tree 6 Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
68149 94937 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
79851 94940 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
133191 94939 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
138259 94938 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
144050 94941 Significant Tree 6 Morus alba :: White Mulberry 246 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
172566 94942 Significant Tree 6 Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
179763 94944 Significant Tree 6 Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 568 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
182637 94936 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 504 2525 Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
26236 99105 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1400@ Mendell Evans Ave 1 Front Yard : Yard Tree Private 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
138273 99106 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1400 Evans Ave 3 Front Yard : Yard Tree Private 2   04/09/2012 12:00:00 AM     Permit Number 768768 6016404 2098045.1 37.7417529632601 -122.385865834439 (37.7417529632601, -122.385865834439) 10 3 8 58 1
164393 120551 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1485 Fairfax Ave 1 Front Yard : Yard Tree Private 2           6016296 2097688 37.7407664622153 -122.386214376382 (37.7407664622153, -122.386214376382) 10 3 8 58 1
37942 98308 Significant Tree 6 Tree(s) :: 17 1490 Fairfax Ave 1 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147) 10 3 8 58 1
135121 98310 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1499@Newhall Evans Ave 2 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.27381 37.7417009175609 -122.386401389915 (37.7417009175609, -122.386401389915) 10 3 8 58 1
57862 96848 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 1486 Innes Ave   Front Yard : Yard Tree Private 2           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251) 10 3 8 58 1
89508 98309 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 401X Newhall St 1 Front Yard : Tree Private 2     6 3x3   6016081.14502 2097910.94016 37.7413667159929 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
5905 261162 Significant Tree 6 Pinus radiata :: Monterey Pine 15 595 Newhall St 1 Sidewalk: Property side : Cutout Tree DPW 1 Private     3x3   6016024 2097656 37.7406635379999 -122.387152626875 (37.7406635379999, -122.387152626875) 10 3 8 58 1
3726 94934 Significant Tree 6 Ficus carica 'Black Mission' :: Black Mission Fig 265 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
45754 94935 Significant Tree 6 Ficus carica 'Brown Turkey' :: Brown Turkey Fig 463 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
173631 96998 Significant Tree 6 Prunus spp :: Cherry 68 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
175413 96996 Significant Tree 6 Malus :: Crab Apple 82 2451X Griffith St   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
41328 121446 Significant Tree 6 Tree(s) :: 17 500 Terry A Francois Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6016102 2110410 37.775687633053 -122.387772601034 (37.775687633053, -122.387772601034) 14 3 9 310 20
4313 105327 Significant Tree 6 Tree(s) :: 17 2051 03rd St 1 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
7964 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
60629 106612 Significant Tree 6 Schinus molle :: California Pepper 91 1189 TENNESSEE ST   Front Yard : Yard Tree Private 2     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024) 10 3 8 28856 29
40244 115123 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
46337 115125 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
110338 115124 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 499X MAIN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
7767 262288 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18011 262289 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
179978 105160 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1600X OAKDALE AVE 1 Front Yard : Yard Tree Arts Commission 19     13   Permit Number 770204 6015006 2095503 37.7346954145828 -122.390522107646 (37.7346954145828, -122.390522107646) 10 3 8 58 1
2862 261320 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 872 Ingerson Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014869 2089377 37.7178670406836 -122.390567842363 (37.7178670406836, -122.390567842363) 10 3 8 58 1
3099 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 953 Indiana St 1 Front Yard : Cutout Tree Private 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
29803 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree Arts Commission 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
102464 248911 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 Oakdale Ave 1 Front Yard : Yard Tree Private 2           6014844.92913 2095599.8976 37.7349525388235 -122.391085759591 (37.7349525388235, -122.391085759591) 10 3 8 58 1
3682 261986 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1500 Bancroft Ave 3 Front Yard : Yard Tree Private 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
12244 261985 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1500x Bancroft Ave   Front Yard : Yard Tree Private 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
48723 96186 Significant Tree 6 Tree(s) :: 17 333 Harrison St 3 Sidewalk: Property side : Tree Private 2         Permit Number 767224 6015127.7 2114620.1 37.7871935976335 -122.39143736362 (37.7871935976335, -122.39143736362) 6 2 9 28855 6

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