1,732 rows where qLegalStatus_id = 6 sorted by qAddress

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)
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
105498 93932 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
105921 102569 Significant Tree 6 Olea europaea :: Olive Tree 9 0 Diaz Ave 1 Front Yard : Yard Tree Private 2   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.81974 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439) 1 8 4 64 14
8751 262427 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
11014 262425 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
15980 262426 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
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
68234 107718 Significant Tree 6 Tree(s) :: 17 1 DOUGLASS ST 1 Front Yard : Yard Tree Private 2     16     6001037.5 2106279.2 37.7634994759637 -122.439588129958 (37.7634994759637, -122.439588129958) 15 5 5 28862 3
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
149707 108978 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 MIGUEL ST 1 Front Yard : Yard Tree Private 2     44     6003334.2 2097391.9 37.7392274919289 -122.431010244874 (37.7392274919289, -122.431010244874) 2 7 5 63 7
1408 260469 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 4 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
3184 260470 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 5 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
7030 260467 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 2 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15148 260466 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 1 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16043 260472 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 7 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16147 260471 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Masonic Ave 6 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
18482 260468 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 3 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
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
9862 114526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
59395 114525 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 TIOGA AVE 1 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
38051 108038 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1 Twin Peaks Blvd   Front Yard : Yard Tree Private 2           5998985.48572 2105240.3128 37.7605299471227 -122.446610614338 (37.7605299471227, -122.446610614338) 15 5 5 28862 12
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
18868 260249 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 10 Crestline Dr 1 Median : Yard Tree Private 2       3x3   5999247 2101231 37.7495362941779 -122.445417868856 (37.7495362941779, -122.445417868856) 2 5 5 63 38
45867 107185 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 10 Florence St 1 Front Yard : Cutout Tree Private 2         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272) 5 1 10 308 21
155327 107408 Significant Tree 6 Acer japonicum :: Japanese Maple 124 10 PEMBERTON PL 1 Front Yard : Yard Tree Private 2     30     5998956.5 2104566.5 37.7586781689727 -122.446662380642 (37.7586781689727, -122.446662380642) 15 5 5 28862 12
181978 107824 Significant Tree 6 Tree(s) :: 17 10 STARR KING WAY 6 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 774657 6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
76263 85093 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 2 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
182598 92909 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 1 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
104704 256850 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 100 Brentwood Ave 1 Front Yard : Yard Tree Private 2       6x6   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
123466 254110 Significant Tree 6 Tree(s) :: 17 100 Cerritos Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/04/2018 12:00:00 AM 3 10x10 Permit Number 781003 5992103 2092952 37.7263938396388 -122.469519230239 (37.7263938396388, -122.469519230239) 9 8 4 59 40
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                        
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18171 260058 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
116051 115752 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
177311 115751 Significant Tree 6 Acer rubrum :: Red Maple 75 100 Yerba Buena Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2016 12:00:00 AM 3   Permit Number 776558 5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
179237 115750 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
188246 115749 Significant Tree 6 Eucalyptus camaldulensis :: River Red Gum 342 100 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5994139.5 2096643.4 37.7366470041966 -122.462746867769 (37.7366470041966, -122.462746867769) 9 8 4 59 40
167754 107159 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000 ESMERALDA AVE   Front Yard : Yard Tree Private 2           6009839 2098688 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619) 10 7 7 28859 2
124108 258218 Significant Tree 6 Olea europaea :: Olive Tree 9 1000 North Point St 1 Sidewalk: Property side : Yard Tree Private 2           6005937.91741 2121414.48699 37.8053349315385 -122.423715341013 (37.8053349315385, -122.423715341013) 5 1 1 28858 32
79585 108000 Significant Tree 6 Tree(s) :: 17 1000 Rhode Island St 1 Back Yard : Yard Tree Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774025 6011852.20179 2103661.18899 37.7569205837919 -122.401999252275 (37.7569205837919, -122.401999252275) 10 3 8 28856 29
194359 262298 Significant Tree 6 Tree(s) :: 17 1000X Mandalay Ln 1 Side Yard : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 10x10 Permit Number 787936 5991616 2101838 37.7507643799851 -122.471850083311 (37.7507643799851, -122.471850083311) 1 8 4 29491 12
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                    
2175 121189 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
42733 121190 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
52280 121184 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
57354 121187 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67180 121191 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67746 121188 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
88321 121186 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
88853 121193 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
110196 121181 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
113996 121192 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
114919 121183 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
122047 121185 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
154884 121182 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
191505 121180 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14736 92056 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
45541 92053 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
161427 92055 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
175545 92054 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
127746 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781 2114962 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609) 11 6 1 55 33
89812 107834 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
170160 107835 Significant Tree 6 Salix babylonica :: Weeping Willow 308 100X SUSSEX ST 1 Front Yard : Yard Tree Private 2     13     6002188 2096682 37.7372132564844 -122.434922529204 (37.7372132564844, -122.434922529204) 2 7 5 63 7
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
184595 187668 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 100x OGDEN AVE 4 Back Yard : Yard Tree Private 2           6007659 2096105 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682) 2 7 7 28859 2
25399 252916 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001472 2098865 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716) 2 7 5 63 7
154007 105073 Significant Tree 6 Myoporum laetum :: Myoporum 62 101 LUNDYS LN 1 Front Yard : Cutout Tree Private 2     18     6006875 2098969 37.7437578546964 -122.418879543436 (37.7437578546964, -122.418879543436) 2 7 7 28859 2
101661 257928 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Lombard St 12 Sidewalk: Property side : Yard Tree Private 2       Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
17188 260389 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 101 Santa Clara Ave 1 Sidewalk: Curb side : Yard Tree Private 2       10x6   5993303.46118 2096918.61416 37.7373544866644 -122.465657379584 (37.7373544866644, -122.465657379584) 1 8 4 59 40
120316 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 URBANO DR 1 Front Yard : Yard Tree Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
66903 233917 Significant Tree 6 Persea americana :: Avocado 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree Private 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
143592 105678 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 101X 03RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4   6012079.1 2114345.8 37.7862707590298 -122.401965633825 (37.7862707590298, -122.401965633825) 12 2 9 28853 6
99529 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 101X Laguna St 1 Front Yard : Yard Tree Private 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
85061 255144 Significant Tree 6 Cupressus sempervirens :: Italian Cypress 204 101x Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013362 2113756 37.7847228211314 -122.3974857221 (37.7847228211314, -122.3974857221) 6 2 9 28856 6
167489 104452 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1045 Mission St 1 Sidewalk: Property side : Cutout Tree Private 2       2x6 Permit Number 770594 6009749.9 2112056.4 37.7798543407434 -122.409862429103 (37.7798543407434, -122.409862429103) 14 2 9 28853 34
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
56298 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 104x TAPIA DR 1 Front Yard : Cutout Tree Private 2     10     5988688 2090939 37.7206686952673 -122.481177253578 (37.7206686952673, -122.481177253578) 1 8 4 64 14
178383 254277 Significant Tree 6 Juniperus chinensis :: Juniper 113 105 Gladeview Way 1 Front Yard : Cutout Tree Private 2       3x6 Permit Number 781296 5997754 2101950 37.7514251480437 -122.450632514859 (37.7514251480437, -122.450632514859) 1 5 4 63 38
93101 251659 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
103238 121134 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 2 Front Yard : Yard Tree Private 2       3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
143771 251658 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
151937 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
157788 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
163986 121133 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Front Yard : Yard Tree Private 2     20 3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
182270 107121 Significant Tree 6 Cercis canadensis :: Eastern Redbud 346 1054 GUERRERO ST 1 Front Yard : Yard Tree Private 2     6     6005686.8 2102852.5 37.7543540785936 -122.423264063467 (37.7543540785936, -122.423264063467) 2 4 5 28859 19
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
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                    
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                              
123285 107037 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1060 Clayton St 1 Front Yard : Yard Tree Private 2     99     5998985 2106259 37.7633269800406 -122.446685590868 (37.7633269800406, -122.446685590868) 15 5 5 29492 9
108934 104726 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 1079 Church St 1 Front Yard : Yard Tree Private 2         Permit Number 770313 6004474.7 2102638.1 37.7536969056436 -122.427440543051 (37.7536969056436, -122.427440543051) 2 4 5 28862 22
193192 99376 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 1088 Ashbury St 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 768767 5998994 2106195 37.7631517661679 -122.446649857914 (37.7631517661679, -122.446649857914) 15 5 5 29492 9
134585 24480 Significant Tree 6 Salix babylonica :: Weeping Willow 308 108X Sussex St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780363 6002195.08262 2096706.93645 37.737282128351 -122.434899824187 (37.737282128351, -122.434899824187) 2 7 5 63 7

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