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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48200 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout | Tree | Private 2 | 5998663.3699 | 2115944.31994 | 37.789901994506 | -122.448495552231 | (37.789901994506, -122.448495552231) | 13 | 6 | 1 | 54 | 31 | |||||
49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
50429 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | 13 | 9 | 1 | 57 | 17 | ||
51973 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 773092 | 6006825 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | 5 | 1 | 1 | 28858 | 32 | |||
56668 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | 13 | 9 | 1 | 57 | 27 | |||||
58472 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | 13 | 6 | 1 | 54 | 31 | |||
61387 | 114840 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2455x HYDE ST | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3x3 | 6006980 | 2120877 | 37.8039178984324 | -122.420070904619 | (37.8039178984324, -122.420070904619) | 5 | 1 | 1 | 28858 | 32 | ||||
61403 | 111037 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 2 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
62300 | 99828 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2398 Broadway | 2 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
68924 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 35 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||||
70399 | 121205 | Significant Tree 6 | Cotoneaster SPP :: Cotoneaster 96 | 930 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 6007386.5238 | 2120591.43483 | 37.8031567047665 | -122.418643837145 | (37.8031567047665, -122.418643837145) | 5 | 1 | 1 | 28858 | 32 | |||
71235 | 98244 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 901 Bay St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6006420.63185 | 2121080.7781 | 37.8044458892203 | -122.422021121489 | (37.8044458892203, -122.422021121489) | 5 | 1 | 1 | 28858 | 32 | ||||
72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
73226 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.7901043022718 | -122.429743441495 | (37.7901043022718, -122.429743441495) | 13 | 9 | 1 | 29490 | 27 | |
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 | |||
80380 | 114184 | Significant Tree 6 | Tree(s) :: 17 | 2454 HYDE ST | 1 | Front Yard : Cutout | Tree | Private 2 | 01/07/2016 12:00:00 AM | 30x30 | Permit Number 776893 | 6007060 | 2120781 | 37.8036588138585 | -122.41978724304 | (37.8036588138585, -122.41978724304) | 5 | 1 | 1 | 28858 | 32 | ||
80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
82918 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001257 | 2116757 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | 13 | 6 | 1 | 29490 | 27 | ||||
83429 | 112481 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 1275 Columbus Ave | 1 | 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 | ||||
83898 | 112482 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 2 | 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 | ||||
83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | 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 | ||||
90493 | 108096 | Significant Tree 6 | Ficus rubiginosa :: Port Jackson Fig 339 | 3370 Washington St | 1 | Front Yard : Cutout | Tree | Private 2 | 17 | Permit Number 773610 | 5998674.83986 | 2115933.37372 | 37.7898725948813 | -122.448455078738 | (37.7898725948813, -122.448455078738) | 13 | 6 | 1 | 54 | 31 | |||
91423 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Lombard St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006289 | 2120073 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | 5 | 9 | 1 | 28858 | 32 | ||||
92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
92381 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 15x4 | 6004495 | 2117637 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | 13 | 9 | 1 | 28858 | 27 | |||
92540 | 113772 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4 | 6001375.31674 | 2117310.7972 | 37.7938086711861 | -122.439210462719 | (37.7938086711861, -122.439210462719) | 13 | 9 | 1 | 57 | 27 | ||||
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 | ||||
94461 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard | Tree | Private 2 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | 11 | 6 | 1 | 54 | 11 | |||
95081 | 112874 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2636 Vallejo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 13 | 3x3 | Permit Number 776037 | 6000935.48392 | 2117605.97258 | 37.7945941075731 | -122.440753504176 | (37.7945941075731, -122.440753504176) | 13 | 9 | 1 | 57 | 27 | |
98322 | 107720 | Significant Tree 6 | Tree(s) :: 17 | 2301x Baker St | 3 | Front Yard : Yard | Tree | Private 2 | 10/20/2014 12:00:00 AM | 3 | Permit Number 773397 | 5999765.63181 | 2116886.19958 | 37.7925511097437 | -122.44474956777 | (37.7925511097437, -122.44474956777) | 13 | 6 | 1 | 29490 | 27 | ||
99727 | 258388 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 2 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
100759 | 99832 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 3 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
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 | ||||
104499 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
105054 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3020 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.443260250183 | (37.790530933705, -122.443260250183) | 13 | 6 | 1 | 29490 | 27 | |||
105107 | 85090 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
106956 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026 | 2116224 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | 13 | 9 | 1 | 29490 | 27 | |
108809 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 875 El Camino Del Mar | 2 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5985641 | 2114972 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | 11 | 6 | 1 | 55 | 15 | ||||
115527 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 190 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
115879 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 5 | 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 | ||||
116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 | ||||
118931 | 85087 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 3 | 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 | ||||
119552 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
123789 | 112483 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1275 Columbus Ave | 3 | 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 | ||||
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 | |||||
124902 | 257918 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 2200 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002990 | 2117900 | 37.7955182191045 | -122.433665645084 | (37.7955182191045, -122.433665645084) | 13 | 9 | 1 | 57 | 17 | ||||
127638 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 3760 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.46778 | 2115674.04938 | 37.7890540175629 | -122.45487301497 | (37.7890540175629, -122.45487301497) | 11 | 6 | 1 | 54 | 31 | ||
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 | |
128000 | 104003 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 | 2109 Steiner St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/17/2013 12:00:00 AM | Permit Number 767176 | 6002333.5 | 2115633.4 | 37.7892574480846 | -122.435774995524 | (37.7892574480846, -122.435774995524) | 13 | 6 | 1 | 29490 | 27 | |||
128387 | 113771 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 6001386.1067 | 2117311.2447 | 37.7938105138862 | -122.439173160634 | (37.7938105138862, -122.439173160634) | 13 | 9 | 1 | 57 | 27 | ||||
133531 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006264 | 2119500 | 37.8000966404513 | -122.42245076966 | (37.8000966404513, -122.42245076966) | 13 | 9 | 1 | 28858 | 32 | ||||
134012 | 117417 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2835 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | Permit Number 778177 | 6001153.1 | 2116153.5 | 37.7906183870332 | -122.439896334555 | (37.7906183870332, -122.439896334555) | 13 | 6 | 1 | 29490 | 27 | |||
137101 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2777 Pine St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 779015 | 6000658 | 2114782 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | 13 | 6 | 1 | 29490 | 27 | |||
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 | ||||
145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
146644 | 105349 | Significant Tree 6 | Tree(s) :: 17 | 151X Spruce St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | Permit Number 771071 | 5997060.93638 | 2115845.70083 | 37.7895394616557 | -122.45403267224 | (37.7895394616557, -122.45403267224) | 11 | 6 | 1 | 54 | 31 | |||
146707 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : | Tree | Private 2 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | 11 | 6 | 1 | 55 | 15 | |||
147066 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001200 | 2116539 | 37.7916795394978 | -122.439761713662 | (37.7916795394978, -122.439761713662) | 13 | 6 | 1 | 29490 | 27 | ||||
147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||||
147624 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | 5 | 1 | 1 | 28858 | 32 | |||
147948 | 111036 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
147971 | 253973 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 2 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
150357 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | 13 | 9 | 1 | 29490 | 27 | |||
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 | ||||
153500 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 106 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | 13 | 9 | 1 | 57 | 17 | ||
154508 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2637 Larkin St | 1 | Front Yard : Yard | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.8022627417937 | -122.421448236261 | (37.8022627417937, -122.421448236261) | 5 | 9 | 1 | 28858 | 32 | |
156627 | 125128 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2545 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5999632.15337 | 2117620.57677 | 37.7945598973812 | -122.44526423016 | (37.7945598973812, -122.44526423016) | 13 | 9 | 1 | 57 | 27 | |||
157354 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 875 El Camino Del Mar | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5985641 | 2114972 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | 11 | 6 | 1 | 55 | 15 | ||||
157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 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 | ||||
161834 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
162406 | 255994 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 179 Retiro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6001908 | 2121813 | 37.8062008335618 | -122.437689923584 | (37.8062008335618, -122.437689923584) | 13 | 9 | 1 | 57 | 17 | ||||
162612 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
163295 | 253972 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 1 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
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 | |||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
166311 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | 13 | 9 | 1 | 57 | 17 | |||
166780 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338 | 2118225 | 37.7962597494046 | -122.442865342513 | (37.7962597494046, -122.442865342513) | 13 | 9 | 1 | 57 | 17 | |
167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
171446 | 257980 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 782825 | 5999909.76407 | 2117098.92712 | 37.7931434275556 | -122.444266160734 | (37.7931434275556, -122.444266160734) | 13 | 9 | 1 | 57 | 27 | ||||
171699 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.52821 | 37.8031223210123 | -122.418746939923 | (37.8031223210123, -122.418746939923) | 5 | 1 | 1 | 28858 | 32 | |
172310 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.439113709125 | (37.7938132775122, -122.439113709125) | 13 | 9 | 1 | 57 | 27 | ||||
173520 | 258387 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
174679 | 98491 | Significant Tree 6 | Robinia pseudoacacia :: Black Locust 286 | 55X Perine Pl | 1 | Back Yard : Cutout | Tree | Private 2 | Permit Number 768655 | 6002130.5 | 2115544.8 | 37.7890026421633 | -122.436471006098 | (37.7890026421633, -122.436471006098) | 13 | 6 | 1 | 29490 | 27 | ||||
176820 | 99289 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998887.79124 | 2121333.18312 | 37.8047111982366 | -122.448107254257 | (37.8047111982366, -122.448107254257) | 13 | 9 | 1 | 57 | 17 | ||
177345 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout | Tree | Private 2 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497 | 2117826 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | 13 | 9 | 1 | 29490 | 27 | |
178107 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
180419 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 2040 Jackson St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | 13 | 9 | 1 | 28858 | 27 | ||
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 | ||
184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
185953 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2829 Divisadero St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.442112369006 | (37.7957189625051, -122.442112369006) | 13 | 9 | 1 | 57 | 17 | ||
186507 | 254476 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1511 Lyon St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999620 | 2114151 | 37.7850326563334 | -122.445056733542 | (37.7850326563334, -122.445056733542) | 15 | 6 | 1 | 29490 | 31 | |||||
187077 | 99831 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 2 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
188669 | 99699 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 2 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 |
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) );