trees

1,011 rows where qLegalStatus_id = 2 sorted by PlotSize 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)
1080 169338 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
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
5118 169123 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009469.52117 2113800.26568 37.7846268637924 -122.410955591431 (37.7846268637924, -122.410955591431) 14 10 9 28852 36
9750 169122 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009478.56357 2113738.5186 37.7844578281201 -122.410919945006 (37.7844578281201, -122.410919945006) 14 10 9 28852 36
16066 260290 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
26024 203202 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013039.197 2107156.64294 37.7665845074832 -122.398139372753 (37.7665845074832, -122.398139372753) 14 3 8 28856 20
32980 147589 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.11416 2112971.56981 37.7812551417606 -122.477380075345 (37.7812551417606, -122.477380075345) 11 6 2 55 26
36722 203212 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 13 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013314.65603 2107418.87056 37.7673198651342 -122.397204991541 (37.7673198651342, -122.397204991541) 14 3 8 28856 20
37035 198590 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013501.44813 2107135.10099 37.766551094089 -122.396539005766 (37.766551094089, -122.396539005766) 14 3 8 28856 20
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
50671 203206 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013175.33077 2107284.78304 37.7669439332411 -122.397677495329 (37.7669439332411, -122.397677495329) 14 3 8 28856 20
51331 199439 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 17 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013405.93741 2107506.73149 37.7675661930534 -122.396895420613 (37.7675661930534, -122.396895420613) 14 3 8 28856 20
52682 192595 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008285.14461 2110684.68439 37.7760057386966 -122.414832573262 (37.7760057386966, -122.414832573262) 8 2 9 28853 34
55756 198584 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013716.83628 2107143.63605 37.7665865138841 -122.395794609033 (37.7665865138841, -122.395794609033) 14 3 8 28856 20
57754 203208 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013261.21102 2107370.66012 37.7671845144907 -122.397386470235 (37.7671845144907, -122.397386470235) 14 3 8 28856 20
58102 203211 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013299.1332 2107408.33786 37.7672900804932 -122.39725794451 (37.7672900804932, -122.39725794451) 14 3 8 28856 20
59194 198587 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
61796 203209 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013274.22218 2107384.36901 37.7672228804628 -122.397342427714 (37.7672228804628, -122.397342427714) 14 3 8 28856 20
64611 203204 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013138.40782 2107249.76439 37.7668457236901 -122.397802750202 (37.7668457236901, -122.397802750202) 14 3 8 28856 20
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
70940 203205 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013159.72459 2107270.14751 37.7669028782866 -122.397730448328 (37.7669028782866, -122.397730448328) 14 3 8 28856 20
71116 199441 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 19 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013426.97714 2107527.99953 37.7676257614597 -122.39682413764 (37.7676257614597, -122.39682413764) 14 3 8 28856 20
72278 198591 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013476.96853 2107132.95858 37.7665438491392 -122.396623526764 (37.7665438491392, -122.396623526764) 14 3 8 28856 20
82264 203203 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013052.87668 2107169.70276 37.7666211287738 -122.398092973126 (37.7666211287738, -122.398092973126) 14 3 8 28856 20
86670 146397 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3318 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 Width 4ft Permit Number 780850 6000857.39871 2119780.85133 37.8005613036105 -122.441179804419 (37.8005613036105, -122.441179804419) 13 9 1 57 17
93355 199442 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 20 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013442.0065 2107543.23317 37.7676684261738 -122.396773220723 (37.7676684261738, -122.396773220723) 14 3 8 28856 20
114271 203207 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013251.61126 2107360.27951 37.7671554771575 -122.397418946544 (37.7671554771575, -122.397418946544) 14 3 8 28856 20
114716 198586 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013678.51918 2107141.48068 37.7665784640576 -122.39592699106 (37.7665784640576, -122.39592699106) 14 3 8 28856 20
116306 147588 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.64201 2112933.29364 37.7811500766647 -122.477375451022 (37.7811500766647, -122.477375451022) 11 6 2 55 26
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
131688 198592 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013452.45897 2107129.35079 37.766532578853 -122.396708048633 (37.766532578853, -122.396708048633) 14 3 8 28856 20
134962 147590 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990251.14725 2113004.86394 37.7813465020817 -122.477385854376 (37.7813465020817, -122.477385854376) 11 6 2 55 26
139833 198581 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013801.3988 2107146.90693 37.7666001988537 -122.395502349162 (37.7666001988537, -122.395502349162) 14 3 8 28856 20
142606 199438 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 16 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013354.61019 2107458.2254 37.7674301489953 -122.397069554541 (37.7674301489953, -122.397069554541) 14 3 8 28856 20
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
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
155834 203210 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013290.07277 2107397.08786 37.7672586860712 -122.397288494465 (37.7672586860712, -122.397288494465) 14 3 8 28856 20
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
158870 198585 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013694.72301 2107142.03178 37.7665808787261 -122.395870983078 (37.7665808787261, -122.395870983078) 14 3 8 28856 20
159283 192594 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/1995 12:00:00 AM 2 Width 4ft Permit Number 770747 6008274.3646 2110675.08431 37.7759787734355 -122.414869184668 (37.7759787734355, -122.414869184668) 8 2 9 28853 34
162521 192596 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1335 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008295.90964 2110693.56586 37.7760307299718 -122.414795962779 (37.7760307299718, -122.414795962779) 8 2 9 28853 34
166195 198588 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013599.81261 2107136.62549 37.766560753709 -122.396198884879 (37.766560753709, -122.396198884879) 14 3 8 28856 20
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
171909 199437 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 15 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013340.81155 2107445.60575 37.7673947300992 -122.397116397514 (37.7673947300992, -122.397116397514) 14 3 8 28856 20
172837 199440 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 18 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013418.56487 2107519.66805 37.767602416836 -122.396852650636 (37.767602416836, -122.396852650636) 14 3 8 28856 20
176004 203201 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013028.4198 2107143.70013 37.7665483691258 -122.398175741313 (37.7665483691258, -122.398175741313) 14 3 8 28856 20
181013 199436 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 14 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013326.10031 2107431.53826 37.767355284933 -122.397166295486 (37.767355284933, -122.397166295486) 14 3 8 28856 20
182084 203200 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013014.64692 2107133.40427 37.7665193318293 -122.398222657156 (37.7665193318293, -122.398222657156) 14 3 8 28856 20
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
189573 198589 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013524.37895 2107133.46335 37.76654787361 -122.396459576758 (37.76654787361, -122.396459576758) 14 3 8 28856 20
193648 147591 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990250.17652 2113053.797 37.7814808023322 -122.477392789959 (37.7814808023322, -122.477392789959) 11 6 2 55 26
1432 228461 Planning Code 138.1 required 2 :: 45 1813 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft Permit Number 782329 6005355.14245 2107219.1964 37.7663252752163 -122.424721643507 (37.7663252752163, -122.424721643507) 8 4 5 28853 19
8601 222646 Planning Code 138.1 required 2 Ceanothus Sps :: California lilac 192 4209 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2018 12:00:00 AM 3 Width 3ft   6001770.77195 2101738.59247 37.7510737715579 -122.436726932715 (37.7510737715579, -122.436726932715) 2 4 5 28862 22
11734 243526 Planning Code 138.1 required 2 Cassia leptophylla :: Gold Medallion Tree 152 3443 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007325.13159 2104386.27009 37.7586577840397 -122.417706987288 (37.7586577840397, -122.417706987288) 2 4 7 28859 19
16618 251060 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 5418 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990225.155 2112720.9896 37.7805655538274 -122.477455019941 (37.7805655538274, -122.477455019941) 11 6 2 55 26
17339 166211 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 3140 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008730.35876 2101584.0935 37.7510426163255 -122.412648961786 (37.7510426163255, -122.412648961786) 2 4 7 28859 19
26571 150167 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 333 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 3ft Permit Number 779492 6014367.55242 2105483.96934 37.7620656102492 -122.393427719319 (37.7620656102492, -122.393427719319) 10 3 8 28856 29
27355 239457 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437) 2 7 5 63 7
33336 192346 Planning Code 138.1 required 2 Fraxinus spp :: Ash Spp 121 118 10th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.54528 37.7750719195804 -122.415815392882 (37.7750719195804, -122.415815392882) 8 2 9 28853 34
39373 251291 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
57131 192563 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.7776687794229 -122.413273679445 (37.7776687794229, -122.413273679445) 8 2 9 28853 34
71488 190612 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 9 Washburn St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 3ft Permit Number 775218 6008236.46776 2110619.04505 37.7758227734432 -122.414996312823 (37.7758227734432, -122.414996312823) 8 2 9 28853 34
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
90355 222216 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2 Van Buren St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887) 2 7 5 63 7
96451 225775 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002401.77617 2104846.28665 37.75964259654 -122.43476706624 (37.75964259654, -122.43476706624) 2 4 5 28862 3
98537 196590 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 2 : Tree Private 2     10 Width 3ft Permit Number 772992 6007565.69447 2109618.27361 37.7730371773558 -122.417245760983 (37.7730371773558, -122.417245760983) 8 2 9 28853 19
104300 196537 Planning Code 138.1 required 2 Prunus x yedoensis :: Yoshino Cherry 77 526 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782869 6010635.96485 2105787.36101 37.7626906193079 -122.406355282166 (37.7626906193079, -122.406355282166) 8 4 8 28859 19
112760 196591 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 3 : Tree Private 2     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782) 8 2 9 28853 19
112949 244834 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1875 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2017 12:00:00 AM 3 Width 3ft   6006796.01232 2107481.11788 37.7671257231045 -122.419756521569 (37.7671257231045, -122.419756521569) 8 4 7 28853 19
115391 224618 Planning Code 138.1 required 2 Ficus microcarpa :: Chinese Banyan 97 165 Sussex St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198) 2 7 5 63 7
115603 251289 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
120060 221127 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1218 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2016 12:00:00 AM 1 Width 3ft Permit Number 778419 6008662.3869 2101444.26707 37.750654869142 -122.412874131348 (37.750654869142, -122.412874131348) 2 4 7 28859 19
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
128513 199503 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.98308 2111924.50305 37.7795342467397 -122.407254787701 (37.7795342467397, -122.407254787701) 14 2 9 28853 34
132587 199504 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342) 14 2 9 28853 34
141915 225774 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002400.68275 2104833.82508 37.7596083179996 -122.434769956692 (37.7596083179996, -122.434769956692) 2 4 5 28862 3
156271 253867 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1628 Clay St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 Width 3ft Permit Number 56289 6006959.29312 2116755.16361 37.7925992053311 -122.419849904466 (37.7925992053311, -122.419849904466) 13 9 10 28858 32
156329 253868 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1628 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 Width 3ft Permit Number 56289 6006959.29312 2116755.16361 37.7925992053311 -122.419849904466 (37.7925992053311, -122.419849904466) 13 9 10 28858 32
158927 251290 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
159683 239458 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029) 2 7 5 63 7
164491 251061 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 5418 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990182.6788 2112719.9143 37.7805601365444 -122.477601885097 (37.7805601365444, -122.477601885097) 11 6 2 55 26
169960 192564 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
173303 241645 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 472 Oak St 1 : Tree Private 2   09/17/2018 12:00:00 AM 3 Width 3ft Permit Number 774132 6004722.92891 2110216.20564 37.7745186107768 -122.427121843201 (37.7745186107768, -122.427121843201) 7 9 11 28852 10
176904 190611 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 9 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2018 12:00:00 AM 3 Width 3ft Permit Number 775218 6008250.0486 2110605.54207 37.7757864606069 -122.41494837717 (37.7757864606069, -122.41494837717) 8 2 9 28853 34
181676 196592 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 4 : Tree Private 2     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.417358489209 (37.7731013709756, -122.417358489209) 8 2 9 28853 19
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
22749 184649 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1688 42nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 782197 5983169.0582 2103665.8835 37.7552908641291 -122.501195062681 (37.7552908641291, -122.501195062681) 1 8 3 56 35
35632 182616 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1856 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/16/2018 12:00:00 AM 0 Width 0ft Permit Number 780914 5987553.0951 2102630.1854 37.7527035840583 -122.485957928463 (37.7527035840583, -122.485957928463) 1 8 3 56 35
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
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
5173 169519 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1753 Noe St 1 Front Yard : Yard Tree Private 2     0 8x8 Permit Number 779099 6003417.91334 2098032.77345 37.7409919262491 -122.430766523865 (37.7409919262491, -122.430766523865) 2 7 5 63 7
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
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
46657 121543 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
48226 121547 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 8 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
73712 121545 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 6 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
117838 121542 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
139844 121546 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6

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