trees

1,011 rows where qLegalStatus_id = 2 sorted by Neighborhoods (old) 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) ▲
168121 121519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
171370 121537 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
180599 75872 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
183412 121520 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 15 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
183902 253394 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
184177 121536 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184275 121529 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184398 115346 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
185771 121538 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
186332 121541 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
187581 121535 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
190355 121534 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
192715 121509 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
194150 121524 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
179761 160920 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 666 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3 Permit Number 779533 6002104.11317 2090113.36167 37.7191725036747 -122.434742983299 (37.7191725036747, -122.434742983299) 9 7 6 28861 5
179839 160370 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 868 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349) 9 7 6 28861 5
4552 250073 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1599X Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083 2115238 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373) 13 9 1 28858 41
48155 107646 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
50564 250075 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1599X Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083 2115238 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373) 13 9 1 28858 41
65206 116853 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3X3 Permit Number 773331 6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971) 13 9 1 28858 41
68582 107647 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
69912 250072 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1599X Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083 2115238 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373) 13 9 1 28858 41
83479 17757 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 7 Sidewalk: Curb side : Cutout Tree DPW 1   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6005917.49192 2115584.99362 37.7893274652545 -122.423371354677 (37.7893274652545, -122.423371354677) 13 9 1 28858 41
117515 119808 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3x3 Permit Number 773331 6006048 2115627 37.7894501691998 -122.422922798032 (37.7894501691998, -122.422922798032) 13 9 1 28858 41
122248 249557 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 3 : Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.7880665835567 -122.423464052238 (37.7880665835567, -122.423464052238) 13 9 1 28858 41
143851 249555 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 1 : Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.7878982115887 -122.423418809148 (37.7878982115887, -122.423418809148) 13 9 1 28858 41
149634 118361 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
151779 249556 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 2 : Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005884.08324 2115105.79396 37.7880098165527 -122.423452863778 (37.7880098165527, -122.423452863778) 13 9 1 28858 41
157692 249558 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 4 : Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005877.98213 2115146.79048 37.7881220384566 -122.423476888259 (37.7881220384566, -122.423476888259) 13 9 1 28858 41
162323 107645 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
167100 250074 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1599X Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083 2115238 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373) 13 9 1 28858 41
179827 118360 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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