1,732 rows where qLegalStatus_id = 6 sorted by Neighborhoods (old)

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                    
703 262210 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2011 Bay Shore Blvd 1 Front Yard : Yard Tree Private 2       3x3   6012422 2088364 37.7149494891568 -122.398955034798 (37.7149494891568, -122.398955034798) 10 3 8 309 1
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
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
3578 261993 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 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
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
5747 94949 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
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
11444 261994 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557x Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014548 2092008 37.7250734320456 -122.391861276019 (37.7250734320456, -122.391861276019) 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
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
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
17557 261982 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree DPW 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
17656 261984 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree DPW 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 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
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
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
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
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
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
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
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
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
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
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
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
53862 173726 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1101 Connecticut St 1 Front Yard : Yard Tree Private 2           6013424 2101939 37.7522794251173 -122.396442635345 (37.7522794251173, -122.396442635345) 10 3 8 28856 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
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
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
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
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
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
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
70249 113112 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1633 OAKDALE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2           6014731 2095647 37.7350755495662 -122.391482947841 (37.7350755495662, -122.391482947841) 10 3 8 58 1
72268 94951 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
85934 88453 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 2 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 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
96193 88456 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 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
101013 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
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
118020 88454 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 3 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 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
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
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
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
130983 94950 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 116 50 Pomona St   : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
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
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
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
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
135218 94946 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 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
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
138601 88455 Significant Tree 6 Myoporum laetum :: Myoporum 62 2801 Oakdale Ave 4 Front Yard : Cutout Tree Private 2       3x3 Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 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
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
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
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 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
148080 88457 Significant Tree 6 Tree(s) :: 17 2801 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2008 12:00:00 AM     Permit Number 51417 6011007.5 2098422.1 37.742488010089 -122.404551775442 (37.742488010089, -122.404551775442) 10 3 8 58 1

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