1,011 rows where qLegalStatus_id = 2 sorted by PlotSize

View and edit SQL

Supervisor Districts

Police Districts

  • 2 251
  • 4 171
  • 8 155
  • 7 104
  • 9 96
  • 3 92
  • 6 61
  • 5 41
  • - 22
  • 10 12
  • 1 6
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)
3289 262310 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1356 20th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/26/2016 12:00:00 AM       5989914.31197 2106134.19071 37.7624619657204 -122.478048663847 (37.7624619657204, -122.478048663847) 1 8 3 56 35
4535 106245 Planning Code 138.1 required 2 Tree(s) :: 17 566 De Haro St 1 Front Yard : Yard Tree Private 2     8   Permit Number 770844 6012026 2105714 37.7625668468002 -122.401542461625 (37.7625668468002, -122.401542461625) 8 3 8 28856 29
4642 254121 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
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
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
6991 112084 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
7505 247942 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 5 Unaccepted Street : Yard Tree DPW 1     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.407057283984 (37.7437730949632, -122.407057283984) 2 7 7 28859 2
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
9263 254120 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
15059 254699 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
15497 33110 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2626 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2020 12:00:00 AM 3   Permit Number 769981 6000381.41365 2118563.70291 37.7971922129921 -122.442739455458 (37.7971922129921, -122.442739455458) 13 9 1 57 17
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
17897 254369 Planning Code 138.1 required 2 Citrus spp :: Lemon: Orange: Lime 120 590X Orizaba Ave 2 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
18507 254122 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
19998 69332 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 160 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1994 12:00:00 AM 11   Permit Number 781107 6013130.58112 2106316.68773 37.7642832664742 -122.397764366249 (37.7642832664742, -122.397764366249) 14 3 8 28856 29
20702 37086 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1426 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2017 12:00:00 AM 3   Permit Number 780691 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192) 1 8 3 56 35
34272 115532 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 2 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.7775456658356 -122.418304279225 (37.7775456658356, -122.418304279225) 7 9 9 28852 36
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
37358 247943 Planning Code 138.1 required 2 Maytenus boaria :: Mayten 58 29 Joy St 6 Unaccepted Street : Yard Tree DPW 1     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297) 2 7 7 28859 2
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
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
55452 35488 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094) 15 6 1 29490 27
60942 247939 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 29 Joy St 2 Unaccepted Street : Yard Tree DPW 1     12   Permit Number 775404 6010258.29977 2098917.51569 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395) 2 7 7 28859 2
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
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
70042 256691 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2825 Lake St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2018 12:00:00 AM 3   Permit Number 772474 5986729.50015 2114421.37847 37.7850308764656 -122.489673069254 (37.7850308764656, -122.489673069254) 11 6 1 55 33
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
71462 187943 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6015093.73077 2115293.30797 37.7890401869059 -122.391601975949 (37.7890401869059, -122.391601975949) 6 2 9 28855 6
73578 187945 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 6 Sidewalk: Curb side : Yard Tree Private 2     3     6015129.76051 2115255.3706 37.7889380194338 -122.391474663423 (37.7889380194338, -122.391474663423) 6 2 9 28855 6
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
79208 43753 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 350 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 10   Permit Number 781765 5991242.53743 2113051.18607 37.781531164196 -122.473959543362 (37.781531164196, -122.473959543362) 11 6 2 54 26
93518 115534 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 4 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.7775284833993 -122.418420222514 (37.7775284833993, -122.418420222514) 7 9 9 28852 36
95475 46434 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2St. Ankeny St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174) 10 7 8 309 28
96441 254702 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
107033 104876 Planning Code 138.1 required 2 Prunus laurocerasus :: English laurel 371 2478 43rd Ave   Sidewalk: Property side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.7404797966413 -122.501143676277 (37.7404797966413, -122.501143676277) 1 8 3 29491 35
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
115681 115533 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 3 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452) 7 9 9 28852 36
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
120325 112085 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
126738 247941 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 4 Unaccepted Street : Yard Tree DPW 1     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.407074570729 (37.743786764646, -122.407074570729) 2 7 7 28859 2
126777 254698 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2051 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015756.78552 2106043.12781 37.763678027819 -122.388661890454 (37.763678027819, -122.388661890454) 14 3 8 28856 29
128791 247940 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 29 Joy St 3 Unaccepted Street : Yard Tree DPW 1     5   Permit Number 775404 6010280.31746 2098909.28814 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782) 2 7 7 28859 2
131750 39246 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3524 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 1   Permit Number 772836 5997390.1418 2116079.35829 37.7901998932662 -122.452910535096 (37.7901998932662, -122.452910535096) 11 6 1 54 31
133882 187944 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6015109.7038 2115276.55289 37.7889950679055 -122.391545539018 (37.7889950679055, -122.391545539018) 6 2 9 28855 6
135790 256689 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2825 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2018 12:00:00 AM 3   Permit Number 772474 5986729.50015 2114421.37847 37.7850308764656 -122.489673069254 (37.7850308764656, -122.489673069254) 11 6 1 55 33
135896 114985 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 1188 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2015 12:00:00 AM     Permit Number 773128 6003158.9 2101346.9 37.7500770674438 -122.43189868142 (37.7500770674438, -122.43189868142) 2 4 5 28862 22
136714 65940 Planning Code 138.1 required 2 Liquidambar styraciflua :: American Sweet Gum 37 620 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.7833233693217 -122.417975883707 (37.7833233693217, -122.417975883707) 7 9 9 28858 36
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
138593 56707 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8   Permit Number 782197 5983170.4061 2103643.307 37.7552289545408 -122.501188731534 (37.7552289545408, -122.501188731534) 1 8 3 56 35
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
145785 253796 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 100 Scotia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2017 12:00:00 AM 3   Permit Number 779938 6011980.63004 2095004.60122 37.7331586170673 -122.400946899168 (37.7331586170673, -122.400946899168) 10 3 8 58 1
145856 254700 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
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
157324 32045 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2979 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3   Permit Number 781325 5999951.23823 2116389.65594 37.7911983214916 -122.444071670681 (37.7911983214916, -122.444071670681) 13 6 1 29490 27
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
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
161423 254697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2051 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015756.78552 2106043.12781 37.763678027819 -122.388661890454 (37.763678027819, -122.388661890454) 14 3 8 28856 29
162044 247938 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 29 Joy St 1 Unaccepted Street : Yard Tree DPW 1     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056) 2 7 7 28859 2
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
162442 255923 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 539 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2018 12:00:00 AM 3   Permit Number 774708 5984698.21016 2112191.31166 37.7787889555839 -122.496535962511 (37.7787889555839, -122.496535962511) 11 6 2 55 26
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
167671 256690 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2825 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2018 12:00:00 AM 3   Permit Number 772474 5986729.50015 2114421.37847 37.7850308764656 -122.489673069254 (37.7850308764656, -122.489673069254) 11 6 1 55 33
168962 115531 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 1 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.73746 2111269.98589 37.7775581502144 -122.41823790028 (37.7775581502144, -122.41823790028) 7 9 9 28852 36
169255 256692 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2825 Lake St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2018 12:00:00 AM 3   Permit Number 772474 5986729.50015 2114421.37847 37.7850308764656 -122.489673069254 (37.7850308764656, -122.489673069254) 11 6 1 55 33
172142 255773 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 450 Toland St 4 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
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
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
184734 115535 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 5 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.7775281488378 -122.418497266559 (37.7775281488378, -122.418497266559) 7 9 9 28852 36
191366 254701 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
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
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
48760 255654 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 298X Coso Ave 2 Side Yard : Yard Tree Private 2   06/27/2018 12:00:00 AM 3 10x10 Permit Number 776462 6007785 2099424 37.7450583812321 -122.415765181935 (37.7450583812321, -122.415765181935) 2 7 7 28859 2
93370 255421 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2727 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/21/2018 12:00:00 AM 3 10x10 Permit Number 780223 5985829 2096861 37.7367623321138 -122.491495459369 (37.7367623321138, -122.491495459369) 1 8 3 29491 35
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
175587 68987 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 767 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 3 10x10 Permit Number 775182 5999291.63198947 2121477.34728573 37.8051301110493 -122.44672010757 (37.8051301110493, -122.44672010757) 13 9 1 57 17
183741 255653 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 298X Coso Ave 1 Side Yard : Yard Tree Private 2   06/27/2018 12:00:00 AM 3 10x10 Permit Number 776462 6007785 2099424 37.7450583812321 -122.415765181935 (37.7450583812321, -122.415765181935) 2 7 7 28859 2
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
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
18610 259660 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
35800 121504 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 4 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.394000660325 (37.7884522533286, -122.394000660325) 6 2 9 28855 6
37189 121502 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
40751 121505 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 5 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014377.50413 2115113.61118 37.7885069995398 -122.394067461056 (37.7885069995398, -122.394067461056) 6 2 9 28855 6
66507 121501 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 1 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014441.60375 2115047.86993 37.7883300516388 -122.393841081021 (37.7883300516388, -122.393841081021) 6 2 9 28855 6
120636 121503 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 3 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.393943755694 (37.7884053276005, -122.393943755694) 6 2 9 28855 6
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
10143 256870 Planning Code 138.1 required 2 Cupressus macrocarpa :: Monterey Cypress 41 30X Bernal Heights Blvd 1 Back Yard : Cutout Tree Private 2       12x6                      
16780 85805 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
17501 251213 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
34271 251211 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
88090 85806 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
91455 85807 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
124736 251212 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34

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