105 rows where Fire Prevention Districts = 9 and qLegalStatus_id = 2 sorted by DBH

View and edit SQL

Fire Prevention Districts

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)
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
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
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
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
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
158236 116267 Planning Code 138.1 required 2 Acer japonicum :: Japanese Maple 124 717 PARIS ST 1 Front Yard : Yard Tree Private 2       3x3   6001138 2089523 37.7174966063475 -122.438040195581 (37.7174966063475, -122.438040195581) 9 7 6 28861 5
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
71950 176972 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 161 University St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft Permit Number 781886 6008005.59306 2093164.83572 37.7278844827614 -122.414559571484 (37.7278844827614, -122.414559571484) 9 3 7 309 28
3 121463 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
27 121462 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 415 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/2020 12:00:00 AM 3 3x3 Permit Number 778984 6006773.54328 2092061.724 37.7247862819155 -122.418740608563 (37.7247862819155, -122.418740608563) 9 7 7 309 28
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
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
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
8349 163331 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 159 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2019 12:00:00 AM 3 3x3 Permit Number 780897 5995371.93865 2087733.0149 37.7122521261194 -122.45784123641 (37.7122521261194, -122.45784123641) 9 8 6 28861 24
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
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
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
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
14035 159355 Planning Code 138.1 required 2 Melaleuca quinquenervia :: Cajeput 10 417 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.88268 2087558.19074 37.7119518775514 -122.44698304145 (37.7119518775514, -122.44698304145) 9 7 6 28861 25
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
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
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
15827 262585 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
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
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
17886 261591 Planning Code 138.1 required 2 :: 45 1747 Cayuga Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/28/2020 12:00:00 AM 3   Permit Number 784552 5998049.81023 2088594.07996 37.7147698965646 -122.44864773571 (37.7147698965646, -122.44864773571) 9 7 6 28861 25
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
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
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
21720 122796 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 306 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3   6009497.08014 2088289.51504 37.7145815488228 -122.4090595839 (37.7145815488228, -122.4090595839) 9 7 8 309 39
23551 121466 Planning Code 138.1 required 2 Tree(s) :: 17 79 Harrington St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778952 6001819.85633 2092538.60283 37.7258155279415 -122.435898987028 (37.7258155279415, -122.435898987028) 9 7 6 28861 25
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
23615 117008 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1315 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2016 12:00:00 AM 3 3x3   6006952.61647 2093135.11232 37.7277436552341 -122.418197638517 (37.7277436552341, -122.418197638517) 9 3 7 309 5
24860 121465 Planning Code 138.1 required 2 Tree(s) :: 17 218 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778899 5994755.06729 2090055.4837 37.7185936165551 -122.460141464151 (37.7185936165551, -122.460141464151) 9 8 6 28861 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
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
27220 159357 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998577.13551 2087591.01668 37.7120458522191 -122.446752958004 (37.7120458522191, -122.446752958004) 9 7 6 28861 25
27287 255049 Planning Code 138.1 required 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 925 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2018 12:00:00 AM 3 3x3 Permit Number 779631 6009075.60356 2091383.60862 37.7230536656288 -122.410734764023 (37.7230536656288, -122.410734764023) 9 3 7 309 28
27582 116803 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 931 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2016 12:00:00 AM 3 3x3   6007342.71844 2093540.39539 37.7288784251848 -122.416877747635 (37.7288784251848, -122.416877747635) 9 3 7 309 28
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
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
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
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
40028 57959 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 336 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288) 9 7 6 28861 5
41739 253164 Planning Code 138.1 required 2 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout Tree Private 2   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.41191 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225) 9 7 7 309 5
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
45743 161753 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 175x Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022 2087749 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288) 9 7 6 28861 5
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
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
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
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
58189 121145 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 962 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5995080 2090346 37.7194099895512 -122.459039336024 (37.7194099895512, -122.459039336024) 9 8 6 28861 24
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
59056 160371 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 868 Edinburgh St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.39451 37.7159253269669 -122.436102948002 (37.7159253269669, -122.436102948002) 9 7 6 28861 5
60006 257929 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 255 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 3x3 Permit Number 781730 5999620.44198 2090680.5387 37.7205885233371 -122.443368776907 (37.7205885233371, -122.443368776907) 9 7 6 28861 25
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
64837 253415 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 55 Stoneybrook Ave   Front Yard : Cutout Tree Private 2   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.42686 37.7299849530428 -122.421802746417 (37.7299849530428, -122.421802746417) 9 7 6 28861 5
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
67632 159354 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 417x Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.447012123728 (37.7119283225022, -122.447012123728) 9 7 6 28861 25
71010 251406 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 445 Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2017 12:00:00 AM 3 3x3   6001636 2088904 37.7158252789105 -122.436274566668 (37.7158252789105, -122.436274566668) 9 7 6 28861 5
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
76325 253875 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 274 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2017 12:00:00 AM 3 3x3 Permit Number 777423 6003013.5236 2093666.24958 37.728979528994 -122.431853049446 (37.728979528994, -122.431853049446) 9 7 6 28861 25
84579 116262 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 35 La Grande Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x4   6005278.18089 2092026.49943 37.7246052551119 -122.42390739822 (37.7246052551119, -122.42390739822) 9 7 6 309 5
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
99548 256905 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 338 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2019 12:00:00 AM 3 3x3 Permit Number 781421 6007824.5446 2092249.93927 37.7253622000817 -122.415120729164 (37.7253622000817, -122.415120729164) 9 3 7 309 28
102650 120680 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 522 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2016 12:00:00 AM 3 3x3   6003717 2090174 37.7194304401491 -122.42917217064 (37.7194304401491, -122.42917217064) 9 7 6 28861 5
103770 170499 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 1178 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003338.82121 2094328.64534 37.7308167537817 -122.430775723045 (37.7308167537817, -122.430775723045) 9 7 5 28861 25
113669 159358 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 49 Naglee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.88571 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692) 9 7 6 28861 25
114847 253246 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1192 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001173 2087586 37.7121800264355 -122.437780563503 (37.7121800264355, -122.437780563503) 9 7 6 28861 5
120065 258340 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 121 Peabody St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/03/2019 12:00:00 AM 3 3x3   6010033.53413 2086907.42536 37.7108166491636 -122.407108010284 (37.7108166491636, -122.407108010284) 9 7 8 309 39
122256 254396 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 167 Harvard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3x3 Permit Number 774780 6006150.23201 2093073.81475 37.7275301484246 -122.420967149802 (37.7275301484246, -122.420967149802) 9 7 7 309 5
126952 175423 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 175 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2017 12:00:00 AM 3 Width 3ft   6004547.44022 2093795.9618 37.7294225258266 -122.426559415306 (37.7294225258266, -122.426559415306) 9 7 6 28861 5
134738 115357 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 270 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2016 12:00:00 AM 3 3x6   5999894.51999 2091641.88128 37.7232437759734 -122.442490363056 (37.7232437759734, -122.442490363056) 9 7 6 28861 25
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
142552 120109 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 555 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3   5997970 2087042 37.7105036758619 -122.448811863159 (37.7105036758619, -122.448811863159) 9 7 6 28861 25
147840 170500 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 1178 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003320.2391 2094320.37512 37.7307929928046 -122.430839374365 (37.7307929928046, -122.430839374365) 9 7 5 28861 25
148882 159485 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 125 Farragut Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2019 12:00:00 AM 3 Width 0ft Permit Number 782109 5997299.08146 2087363.42174 37.7113478362182 -122.451153855174 (37.7113478362182, -122.451153855174) 9 7 6 28861 25
151446 170486 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 121 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003308.3245 2094432.02915 37.7310988944888 -122.430888530379 (37.7310988944888, -122.430888530379) 9 7 5 28861 25
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
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
158600 160369 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 868 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001700.06015 2088961.7176 37.7159873981889 -122.436057273237 (37.7159873981889, -122.436057273237) 9 7 6 28861 5
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
162589 108261 Planning Code 138.1 required 2 Melaleuca quinquenervia :: Cajeput 10 379 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/2015 12:00:00 AM 3 4x4 Permit Number 774479 6002548.02456 2091247.69967 37.7223123355393 -122.433289563782 (37.7223123355393, -122.433289563782) 9 7 6 28861 5
163376 253126 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 182 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.20381 37.7261633586637 -122.432716365158 (37.7261633586637, -122.432716365158) 9 7 6 28861 5
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
167690 256776 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 244 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 781951 5994190.23703 2091515.08881 37.7225688371899 -122.462199635944 (37.7225688371899, -122.462199635944) 9 8 4 28861 24
173437 255664 Planning Code 138.1 required 2 Tree(s) :: 17 368 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2018 12:00:00 AM 3 3x3 Permit Number 781650 6007860.32032 2092132.7947 37.7250425565594 -122.414988767826 (37.7250425565594, -122.414988767826) 9 3 7 309 28
174013 257892 Planning Code 138.1 required 2 Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 91 Canyon Dr 1 Front Yard : Yard Tree Private 2   01/11/2019 12:00:00 AM 3 3x3   6002890 2086311 37.7087766368694 -122.43175513536 (37.7087766368694, -122.43175513536) 9 7 6 28861 5

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)
);