trees
155 rows where Police Districts = 8 and qLegalStatus_id = 2 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2139 | 251538 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981086 | 2103156 | 37.753768326371 | -122.508360924805 | (37.753768326371, -122.508360924805) | 1 | 8 | 3 | 56 | 35 | ||||
6357 | 261583 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
6460 | 261585 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
6598 | 261578 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
9333 | 261584 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
11732 | 261580 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
14010 | 261579 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 496 Urbano Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
14168 | 261582 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
16304 | 162975 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 131 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5996790.92866 | 2090757.22233 | 37.72063731584 | -122.453154991525 | (37.72063731584, -122.453154991525) | 9 | 8 | 6 | 28861 | 24 | |||
19480 | 261581 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 496 Urbano Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5992575 | 2091875 | 37.7234639294961 | -122.467809264789 | (37.7234639294961, -122.467809264789) | 9 | 8 | 4 | 59 | 40 | ||||
22749 | 184649 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 782197 | 5983169.0582 | 2103665.8835 | 37.7552908641291 | -122.501195062681 | (37.7552908641291, -122.501195062681) | 1 | 8 | 3 | 56 | 35 | ||
26702 | 117483 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
36980 | 105047 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 278 Capitol Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | 9 | 8 | 6 | 28861 | 24 | |||||
37551 | 253474 | Planning Code 138.1 required 2 | Prunus cerasifera :: Cherry Plum 7 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x2 | 5991633 | 2092401 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | 9 | 8 | 4 | 59 | 40 | ||||
45409 | 114908 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 281 LOBOS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994225 | 2088676 | 37.714775380269 | -122.461873702271 | (37.714775380269, -122.461873702271) | 9 | 8 | 6 | 28861 | 24 | ||||
51709 | 173899 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
55332 | 115079 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | 1 | 8 | 3 | 56 | 35 | ||||
56397 | 251539 | Planning Code 138.1 required 2 | Brahea edulis :: Guadalupe Palm 218 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5981086 | 2103156 | 37.753768326371 | -122.508360924805 | (37.753768326371, -122.508360924805) | 1 | 8 | 3 | 56 | 35 | ||||
68264 | 173898 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
80043 | 255924 | Planning Code 138.1 required 2 | Maytenus boaria :: Mayten 58 | 454 Ralston St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5992261 | 2090872 | 37.7206918008503 | -122.468821743954 | (37.7206918008503, -122.468821743954) | 9 | 8 | 6 | 64 | 24 | ||||
138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
160718 | 117479 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
164050 | 114792 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | ||||
166329 | 117480 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
167011 | 254235 | Planning Code 138.1 required 2 | Syzygium australe :: Eugenia 228 | 454 Ralston St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 10x10 | 5992261 | 2090872 | 37.7206918008503 | -122.468821743954 | (37.7206918008503, -122.468821743954) | 9 | 8 | 6 | 64 | 24 | ||||
184372 | 117482 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
186896 | 114793 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 10 Linares Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | Permit Number 777094 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | |||
187328 | 117481 | Planning Code 138.1 required 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 601 PACHECO ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x9 | 5993107 | 2101833 | 37.7508368102529 | -122.466693753982 | (37.7508368102529, -122.466693753982) | 1 | 8 | 4 | 29491 | 12 | ||||
194418 | 265072 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 41st Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5983517.97374 | 2101348.17171 | 37.7489475550359 | -122.499817124771 | (37.7489475550359, -122.499817124771) | 1 | 8 | 3 | 29491 | 35 | ||||
4912 | 261377 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
17863 | 261376 | Planning Code 138.1 required 2 | Olea Majestic Beauty :: 183 | 3015 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 4x10 | Permit Number 784883 | 5988814.87181 | 2095155.07295 | 37.7322523337557 | -122.481047245899 | (37.7322523337557, -122.481047245899) | 1 | 8 | 4 | 64 | 35 | |
24135 | 254150 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2123 30th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 3x6 | Permit Number 778310 | 5986951.71761 | 2100810.65655 | 37.7476725845461 | -122.487903895201 | (37.7476725845461, -122.487903895201) | 1 | 8 | 3 | 29491 | 35 | |
95009 | 173748 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1259 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773489 | 5989520 | 2106786 | 37.7642287625639 | -122.479460118399 | (37.7642287625639, -122.479460118399) | 1 | 8 | 3 | 56 | 35 | |
639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
38353 | 256715 | Planning Code 138.1 required 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 | 1540 17th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/15/2019 12:00:00 AM | 3 | 4x8 | Permit Number 779534 | 5990911 | 2104908 | 37.7591529734205 | -122.474512031039 | (37.7591529734205, -122.474512031039) | 1 | 8 | 4 | 56 | 12 | |
6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
37845 | 256671 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 423 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781122 | 5994719 | 2091406 | 37.7222997368586 | -122.460363933092 | (37.7222997368586, -122.460363933092) | 9 | 8 | 4 | 28861 | 24 | |
84340 | 115405 | Planning Code 138.1 required 2 | Podocarpus macrophyllus :: Yew Pine 137 | 2050 43RD AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/29/2016 12:00:00 AM | 3 | 3x3 | 5982969 | 2101168 | 37.7484206232379 | -122.50170211889 | (37.7484206232379, -122.50170211889) | 1 | 8 | 3 | 29491 | 35 | ||
31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
23597 | 115495 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
27737 | 115492 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
46086 | 115494 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
65049 | 115493 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
71090 | 115491 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
155417 | 106315 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
186409 | 115490 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
2574 | 216200 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784456 | 5992806.74011 | 2104217.97153 | 37.7573679916535 | -122.467905522425 | (37.7573679916535, -122.467905522425) | 1 | 8 | 4 | 56 | 12 | |
180231 | 254400 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2346 46th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3X3 | 5982081.05878 | 2099125.72352 | 37.7427609043033 | -122.504621254744 | (37.7427609043033, -122.504621254744) | 1 | 8 | 3 | 29491 | 35 | ||
77927 | 187639 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1671 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2017 12:00:00 AM | 3 | 3x6 | 5985585 | 2103854 | 37.7559489545124 | -122.492853989295 | (37.7559489545124, -122.492853989295) | 1 | 8 | 3 | 56 | 35 | ||
28863 | 115887 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
29841 | 115885 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 10x10 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
45389 | 115886 | Planning Code 138.1 required 2 | Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | 2x4 | Permit Number 772714 | 5991633.6 | 2092401.5 | 37.7248551637156 | -122.471101821397 | (37.7248551637156, -122.471101821397) | 9 | 8 | 4 | 59 | 40 | |
145605 | 183545 | Planning Code 138.1 required 2 | Agonis flexuosa :: Peppermint Willow 65 | 2580 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | 4x4 | Permit Number 777874 | 5988340.9772 | 2097760.0505 | 37.7393773655768 | -122.482876432223 | (37.7393773655768, -122.482876432223) | 1 | 8 | 3 | 29491 | 35 | |
82445 | 254665 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778441 | 5989948 | 2103325 | 37.7547506343258 | -122.477726795598 | (37.7547506343258, -122.477726795598) | 1 | 8 | 3 | 56 | 35 | |
57156 | 254766 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 79 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776608 | 5997440.77634 | 2089380.40278 | 37.7168941131095 | -122.450809461106 | (37.7168941131095, -122.450809461106) | 9 | 8 | 6 | 28861 | 24 | |
62051 | 254764 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 77 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776607 | 5997448.21567 | 2089391.00345 | 37.7169236459528 | -122.450784510991 | (37.7169236459528, -122.450784510991) | 9 | 8 | 6 | 28861 | 24 | |
144548 | 254740 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1814 42nd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779958 | 5983225 | 2102757 | 37.752798609062 | -122.500934388909 | (37.752798609062, -122.500934388909) | 1 | 8 | 3 | 56 | 35 | |
46091 | 98406 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778181 | 5994692.2 | 2088928.8 | 37.7154963945459 | -122.460277182084 | (37.7154963945459, -122.460277182084) | 9 | 8 | 6 | 28861 | 24 | |
49019 | 113699 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 239 Minerva St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778180 | 5994635.15348587 | 2088996.04011087 | 37.7156777383317 | -122.460479228374 | (37.7156777383317, -122.460479228374) | 9 | 8 | 6 | 28861 | 24 | |
65989 | 255377 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2699X Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 3x3 | 5984648 | 2097442 | 37.7382885158105 | -122.495621472041 | (37.7382885158105, -122.495621472041) | 1 | 8 | 3 | 29491 | 35 | ||
101680 | 255378 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2699X Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 3x3 | 5984648 | 2097442 | 37.7382885158105 | -122.495621472041 | (37.7382885158105, -122.495621472041) | 1 | 8 | 3 | 29491 | 35 | ||
165057 | 255376 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2699X Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 3x3 | 5984648 | 2097442 | 37.7382885158105 | -122.495621472041 | (37.7382885158105, -122.495621472041) | 1 | 8 | 3 | 29491 | 35 | ||
172845 | 255375 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2699X Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/2018 12:00:00 AM | 3 | 3x3 | 5984648 | 2097442 | 37.7382885158105 | -122.495621472041 | (37.7382885158105, -122.495621472041) | 1 | 8 | 3 | 29491 | 35 | ||
37901 | 251534 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226 | 2102732 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | 1 | 8 | 3 | 56 | 35 | ||
89164 | 67994 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776577 | 5994615.10957021 | 2088996.30431809 | 37.7156773106674 | -122.460548527933 | (37.7156773106674, -122.460548527933) | 9 | 8 | 6 | 28861 | 24 | |
4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
41357 | 255423 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
56985 | 255424 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
93370 | 255421 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2727 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780223 | 5985829 | 2096861 | 37.7367623321138 | -122.491495459369 | (37.7367623321138, -122.491495459369) | 1 | 8 | 3 | 29491 | 35 | |
170704 | 255422 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
32475 | 255482 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1559 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | 3x5 | 5993958 | 2104895 | 37.7592933500003 | -122.463973185629 | (37.7592933500003, -122.463973185629) | 1 | 8 | 4 | 56 | 12 | ||
6656 | 258684 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
8278 | 258683 | Planning Code 138.1 required 2 | Magnolia spp :: Magnolia 224 | 222 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/06/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782190 | 5990522.43491 | 2094710.12159 | 37.7311297256611 | -122.475111403646 | (37.7311297256611, -122.475111403646) | 1 | 8 | 4 | 64 | 35 | |
20111 | 1217 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.09824 | 37.7112992341463 | -122.463612070865 | (37.7112992341463, -122.463612070865) | 9 | 8 | 4 | 64 | 24 | ||
25596 | 117510 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 23x BRIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993679 | 2087403 | 37.7112485771375 | -122.463668552658 | (37.7112485771375, -122.463668552658) | 9 | 8 | 4 | 64 | 24 | ||
15585 | 258769 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 1633 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2019 12:00:00 AM | 3 | 3x3 | 5988962.35654 | 2103065.4403 | 37.7539807026125 | -122.481116375927 | (37.7539807026125, -122.481116375927) | 1 | 8 | 3 | 56 | 35 | ||
35612 | 255646 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1542 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2018 12:00:00 AM | 3 | 3x5 | Permit Number 779777 | 5989956.05847 | 2104865.26605 | 37.7589802621415 | -122.477811515827 | (37.7589802621415, -122.477811515827) | 1 | 8 | 3 | 56 | 35 | |
25630 | 255709 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2458 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 775348 | 5983968.47211 | 2098431.39968 | 37.740965323086 | -122.498043953777 | (37.740965323086, -122.498043953777) | 1 | 8 | 3 | 29491 | 35 | |
4524 | 183636 | Planning Code 138.1 required 2 | Pittosporum crassifolium :: Karo Tree 95 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x9 | Permit Number 781673 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | 1 | 8 | 3 | 56 | 35 | |
5422 | 122567 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 241 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 777809 | 5994026.14526 | 2086558.74537 | 37.7089504501359 | -122.46240754496 | (37.7089504501359, -122.46240754496) | 9 | 8 | 6 | 28861 | 25 | |
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
18060 | 258219 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
37533 | 253101 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
156097 | 253105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
169212 | 253102 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
176443 | 253103 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
186709 | 253104 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
120709 | 253166 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 2405 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778209 | 5986396.6612 | 2098868.17463 | 37.742306656921 | -122.489680395865 | (37.742306656921, -122.489680395865) | 1 | 8 | 3 | 29491 | 35 |
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) );