trees
29 rows where Neighborhoods (old) = 40 and qLegalStatus_id = 2
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5670 | 253203 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5999103 | 2095207 | 37.732987611392 | -122.445482716078 | (37.732987611392, -122.445482716078) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||||
8713 | 261829 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781540 | 5994862.12068 | 2096567.59314 | 37.7364804498834 | -122.460242983215 | (37.7364804498834, -122.460242983215) | 9 | 7 | 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 | ||||
9453 | 260830 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 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 | ||||
12606 | 261830 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 256 Casitas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781540 | 5994862.12068 | 2096567.59314 | 37.7364804498834 | -122.460242983215 | (37.7364804498834, -122.460242983215) | 9 | 7 | 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 | ||||
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
14313 | 261295 | Planning Code 138.1 required 2 | Ginkgo biloba 'Saratoga' :: Ginkgo: Saratoga 174 | 185 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/20/2019 12:00:00 AM | 3 | 3x10 | Permit Number 782878 | 5990774.03183 | 2093262.32002 | 37.727169005397 | -122.474135998689 | (37.727169005397, -122.474135998689) | 9 | 8 | 4 | 64 | 40 | |
18512 | 260829 | Planning Code 138.1 required 2 | Callistemon viminalis :: Weeping Bottlebrush 60 | 165 Cerritos Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/10/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781510 | 5991854 | 2092943 | 37.7263547341381 | -122.470379348754 | (37.7263547341381, -122.470379348754) | 9 | 8 | 4 | 59 | 40 | |
18618 | 170106 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 6x10 | Permit Number 783167 | 5997920.28587 | 2095246.22061 | 37.7330277118397 | -122.449574473879 | (37.7330277118397, -122.449574473879) | 9 | 7 | 4 | 59 | 40 | |
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 | ||||
22364 | 114870 | Planning Code 138.1 required 2 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3 | 3x4 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 40 | ||
26576 | 173651 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
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 | |
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 | ||||
39006 | 253854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x9 | Permit Number 776163 | 5997782.66631 | 2095011.71334 | 37.7323759368037 | -122.450033362597 | (37.7323759368037, -122.450033362597) | 9 | 7 | 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 | |
53406 | 256184 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 412 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 10x3 | Permit Number 770911 | 5998674.66662 | 2094402.01563 | 37.7307528521501 | -122.446905665072 | (37.7307528521501, -122.446905665072) | 9 | 7 | 4 | 59 | 40 | |
58719 | 121093 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 150 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778915 | 5996816.77701 | 2094570.70089 | 37.7311097051787 | -122.453340820219 | (37.7311097051787, -122.453340820219) | 9 | 7 | 4 | 59 | 40 | ||
160778 | 215785 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Agua Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 775074 | 5997502.62133 | 2098608.67839 | 37.7422363073547 | -122.451260857411 | (37.7422363073547, -122.451260857411) | 9 | 7 | 4 | 59 | 40 | |
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 | ||||
167666 | 173650 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.45657 | 2092194.59394 | 37.7243327619491 | -122.468352901223 | (37.7243327619491, -122.468352901223) | 9 | 8 | 4 | 59 | 40 | ||
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 |
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) );