trees

1,011 rows where qLegalStatus_id = 2 sorted by Zip Codes descending

✎ View and edit SQL

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)
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
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
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
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
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
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
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
67232 256000 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 8 Springfield Dr 1 Sidewalk: Property side : Yard Tree Private 2   08/21/2018 12:00:00 AM 3 6x10 Permit Number 780036 5986792.13129 2095812.03329 37.733938381975 -122.488088482457 (37.733938381975, -122.488088482457) 1 8 4 64 35
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
95904 256882 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3075 25th Ave 2 Sidewalk: Property side : Yard Tree Private 2   12/21/2018 12:00:00 AM 3 3x10 Permit Number 781920 5988824.60597 2094879.63635 37.7314966214822 -122.480993433312 (37.7314966214822, -122.480993433312) 1 8 4 64 35
106240 122625 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 189 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222 2094938 37.7313882480876 -122.496909587532 (37.7313882480876, -122.496909587532) 1 8 4 64 35
120310 173614 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2955 20th Ave 2 Sidewalk: Property side : Yard Tree Private 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
140218 256881 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3075 25th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/21/2018 12:00:00 AM 3 3x10 Permit Number 781920 5988824.60597 2094879.63635 37.7314966214822 -122.480993433312 (37.7314966214822, -122.480993433312) 1 8 4 64 35
146537 173613 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2955 20th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
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
171095 122627 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 34 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731 2094410 37.7299683129055 -122.495110985344 (37.7299683129055, -122.495110985344) 1 8 4 64 35
178269 122626 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 330 Country Club Dr 1 Sidewalk: Property side : Cutout Tree Private 2   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613 2095517 37.7330009316807 -122.495600537949 (37.7330009316807, -122.495600537949) 1 8 4 64 35
179923 122379 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 466 Vernon St 1 Front Yard : Cutout Tree Private 2   10/26/2016 12:00:00 AM 3 3x3   5992521 2090937 37.7208852925782 -122.467927737968 (37.7208852925782, -122.467927737968) 9 8 6 64 24
2678 157809 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 647 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2019 12:00:00 AM 3 3x3 Permit Number 781831 6002443.37703 2099727.28553 37.7455893990301 -122.4342572226 (37.7455893990301, -122.4342572226) 2 7 5 63 22
3850 262121 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
5173 169519 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1753 Noe St 1 Front Yard : Yard Tree Private 2     0 8x8 Permit Number 779099 6003417.91334 2098032.77345 37.7409919262491 -122.430766523865 (37.7409919262491, -122.430766523865) 2 7 5 63 7
7182 262122 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
8622 256682 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 8 Front Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
11200 4249 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 4043 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1995 12:00:00 AM 12 4x4   6003613.964 2100376.48243 37.7474383143284 -122.430255820476 (37.7474383143284, -122.430255820476) 2 4 5 63 22
11885 157920 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
15356 251313 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 390 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
18063 259659 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
18657 251312 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1499 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
19663 256686 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 11 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
23587 256680 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 6 Front Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
27355 239457 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437) 2 7 5 63 7
28167 256679 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
32624 258085 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 12 Sidewalk: Property side : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 10x10   5998725.10706 2103975.38052 37.7570418811558 -122.447420092492 (37.7570418811558, -122.447420092492) 15 5 4 63 38
51236 243740 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 550 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.05577 2096015.80768 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248) 2 7 5 63 7
75229 256683 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
75947 256676 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
78128 256675 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 330 Twin Peaks Blvd 3 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
90355 222216 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2 Van Buren St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887) 2 7 5 63 7
91584 157471 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 844 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2018 12:00:00 AM 3 3x3   6001109 2099712 37.7454716006778 -122.438870189158 (37.7454716006778, -122.438870189158) 2 4 5 63 22
108115 242845 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 1559 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2018 12:00:00 AM 3 3x3   6004609.7731 2099770.4554 37.7458306574531 -122.426769226215 (37.7458306574531, -122.426769226215) 2 7 5 63 22
112660 169518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1783 Noe St 1 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 3x3 Permit Number 780948 6003426.12868 2097901.04069 37.7406306838602 -122.430728719953 (37.7406306838602, -122.430728719953) 2 7 5 63 7
115391 224618 Planning Code 138.1 required 2 Ficus microcarpa :: Chinese Banyan 97 165 Sussex St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198) 2 7 5 63 7
123272 256677 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
124453 158406 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 50 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2017 12:00:00 AM 3 3X3 Permit Number 770857 6001789.37716 2096842.5543 37.7376314601307 -122.436312235543 (37.7376314601307, -122.436312235543) 2 7 5 63 7
127405 256685 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 10 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
130529 256674 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 2 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
133424 254076 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 416 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2017 12:00:00 AM 3 3x3   6003139 2099532 37.7450926486102 -122.431837924964 (37.7450926486102, -122.431837924964) 2 7 5 63 22
144520 43569 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 601 29TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2   07/20/2000 12:00:00 AM   3x3 Permit Number 43230 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
152110 239088 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 3855 26th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 3x3 Permit Number 780732 6004794.15723 2100737.40071 37.748496089722 -122.426200479689 (37.748496089722, -122.426200479689) 2 4 5 63 22
156678 255580 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 384 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2018 12:00:00 AM 3 3x3 Permit Number 778885 6003411.13256 2099532.22132 37.7451086791398 -122.430896954644 (37.7451086791398, -122.430896954644) 2 7 5 63 22
158426 256673 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 1 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
159683 239458 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029) 2 7 5 63 7
161826 256678 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
168649 243745 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 130 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2017 12:00:00 AM 3 3x3 Permit Number 774373 6003834.27428 2096405.12406 37.7365463534355 -122.429210869408 (37.7365463534355, -122.429210869408) 2 7 5 63 7
170182 258184 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 95 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003372 2097903 37.74063299685 -122.430916015884 (37.74063299685, -122.430916015884) 2 7 5 63 7
172284 256143 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4068 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2018 12:00:00 AM 3 3x3   6003463 2100411 37.7475245395629 -122.430780306583 (37.7475245395629, -122.430780306583) 2 4 5 63 22
176698 256681 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 330 Twin Peaks Blvd 7 Front Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
185964 256684 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 9 Back Yard : Yard Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
191974 108030 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2014 12:00:00 AM 3 3x3   6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
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
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
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
137347 116851 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 3 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
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
164459 116850 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 83 Panorama Dr 2 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
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
183437 116849 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 83 Panorama Dr 1 Front Yard : Yard Tree Private 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
4781 254118 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 5 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
6889 173762 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.71929 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894) 10 3 8 58 1
8065 255771 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 450 Toland St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2018 12:00:00 AM 3   Permit Number 779472 6012768.71675 2099101.44192 37.7444516111373 -122.398509629682 (37.7444516111373, -122.398509629682) 10 3 8 58 1
8434 255770 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 450 Toland St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2018 12:00:00 AM 3   Permit Number 779472 6012768.71675 2099101.44192 37.7444516111373 -122.398509629682 (37.7444516111373, -122.398509629682) 10 3 8 58 1
31747 173761 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.71929 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894) 10 3 8 58 1
48804 254117 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
71449 255772 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 450 Toland St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2018 12:00:00 AM 3   Permit Number 779472 6012768.71675 2099101.44192 37.7444516111373 -122.398509629682 (37.7444516111373, -122.398509629682) 10 3 8 58 1
74634 254115 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
75135 254116 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
115977 258090 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1223 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2019 12:00:00 AM 3 4x6   6013685 2090528 37.7209617016481 -122.394740998302 (37.7209617016481, -122.394740998302) 10 3 8 58 1
118980 254114 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);