trees
1,732 rows where qLegalStatus_id = 6 sorted by Supervisor Districts
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
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 | |||||
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 | ||||
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 | |||||
3188 | 260646 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
3724 | 260475 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 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 | ||||
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 | ||||
6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
6580 | 261206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2301 Leavenworth St | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
6928 | 260474 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 2 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 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 | |||||
7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
8183 | 261995 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 2 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
8456 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 1 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
8743 | 261207 | Significant Tree 6 | Umbellularia californica :: California Bay 326 | 2301 Leavenworth St | 3 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
9964 | 262274 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Montclair Ter | 1 | Side Yard : Yard | Tree | Private 2 | 6007298.70359 | 2120216.09204 | 37.8021211637502 | -122.418921105258 | (37.8021211637502, -122.418921105258) | 5 | 1 | 1 | 28858 | 32 | |||||
10123 | 257894 | Significant Tree 6 | Metrosideros robusta :: Northern Rata Tree 335 | 1776 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 01/27/2020 12:00:00 AM | 3 | 6005064 | 2118169 | 37.7963742870274 | -122.426508408066 | (37.7963742870274, -122.426508408066) | 13 | 9 | 1 | 28858 | 17 | |||
10213 | 260647 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
10395 | 260478 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
11407 | 260477 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
11487 | 260838 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
11600 | 260651 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
12511 | 260840 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
12545 | 260484 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
12590 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 778992 | 6001431 | 2120732 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | 13 | 9 | 1 | 57 | 17 | ||
13981 | 261996 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
14136 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
14326 | 112045 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785474 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | 13 | 9 | 1 | 29490 | 27 | |
14823 | 260479 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
14900 | 260476 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 4 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
15016 | 261205 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2301 Leavenworth St | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6007514 | 2120271 | 37.8022840477627 | -122.418179969724 | (37.8022840477627, -122.418179969724) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||||
15393 | 260480 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
15591 | 262378 | Significant Tree 6 | Yucca spp :: Yucca 289 | 2172 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002662 | 2118213 | 37.796359019498 | -122.434822974351 | (37.796359019498, -122.434822974351) | 13 | 9 | 1 | 57 | 17 | ||||
16021 | 260481 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 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 | |||||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
17264 | 260645 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3905 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
17369 | 260483 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 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 | |||||
18519 | 260473 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 520 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
24819 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2590 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
26906 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3700 Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | 11 | 6 | 1 | 54 | 31 | |
27860 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001231.00707 | 2116743.47753 | 37.7922427464694 | -122.439669095376 | (37.7922427464694, -122.439669095376) | 13 | 6 | 1 | 29490 | 27 | |||
28531 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
30713 | 99829 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2398 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
31713 | 107635 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 1150 Lombard St | 10 | Front Yard : Yard | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 773092 | 6006825.00646 | 2120436.80144 | 37.8027004912885 | -122.420576003873 | (37.8027004912885, -122.420576003873) | 5 | 1 | 1 | 28858 | 32 | ||
32335 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
32951 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 4 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
35278 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5999865 | 2112093 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | 15 | 5 | 1 | 29490 | 16 | ||||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
39009 | 255287 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2758 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999862 | 2117824 | 37.7951315610034 | -122.444483561153 | (37.7951315610034, -122.444483561153) | 13 | 9 | 1 | 57 | 17 | ||||
40123 | 256065 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2800 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2018 12:00:00 AM | 3 | 3x3 | 6002545 | 2117972 | 37.7956906526811 | -122.435210571933 | (37.7956906526811, -122.435210571933) | 13 | 9 | 1 | 57 | 17 | ||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
43750 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1451 Bay St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||||
44979 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3524 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||
46495 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
47695 | 104013 | Significant Tree 6 | Fremontodendron spp :: Flannel Bush Tree 107 | 3978 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2013 12:00:00 AM | Permit Number 770312 | 5995753.1 | 2114886.6 | 37.7868309532778 | -122.458488162336 | (37.7868309532778, -122.458488162336) | 11 | 6 | 1 | 54 | 31 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );