trees

184 rows where SiteOrder = 2 and qLegalStatus_id = 2 sorted by YCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: SiteOrder

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)
190939 13063 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 590 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2017 12:00:00 AM 3 2X2 Permit Number 780933 6009554.3361 2120533.7978 37.803120257284 -122.411137959105 (37.803120257284, -122.411137959105) 3 1 10 308 23
118329 172747 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.8025188570147 -122.423348551388 (37.8025188570147, -122.423348551388) 5 9 1 28858 32
186623 257921 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
4259 33111 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2626 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 4x4 Permit Number 769981 6000363.34088 2118561.77591 37.7971858916671 -122.442801853125 (37.7971858916671, -122.442801853125) 13 9 1 57 17
81974 256777 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2828 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 777329 6003004.23187 2118313.15271 37.7966534371422 -122.433645942426 (37.7966534371422, -122.433645942426) 13 9 1 57 17
190292 116775 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.7961019747828 -122.413589186808 (37.7961019747828, -122.413589186808) 5 1 10 308 21
64492 117113 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005663.57094 2117913.49378 37.7957066076266 -122.424415580821 (37.7957066076266, -122.424415580821) 13 9 1 28858 27
127597 103379 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2712 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520 2117210 37.7934832007909 -122.44216269001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
20307 253871 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
70032 253393 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 2 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
175873 112198 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2015 12:00:00 AM 3 3x3 Permit Number 771994 6001873.5131 2116702.41623 37.7921665513862 -122.437443074554 (37.7921665513862, -122.437443074554) 13 6 1 29490 27
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
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
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
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
8436 260432 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2019 12:00:00 AM 3 3x3   6013986 2115554 37.7896944377585 -122.395452879395 (37.7896944377585, -122.395452879395) 12 2 9 28855 6
49532 256566 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 2099X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
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
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
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
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 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
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
72671 255301 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1238 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2018 12:00:00 AM 3 3x3 Permit Number 777218 6006649 2115006 37.7877789501949 -122.420799295532 (37.7877789501949, -122.420799295532) 13 9 10 28858 21
184490 253342 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
96508 115347 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 2 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
152753 115349 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014896.08459 2114567.05321 37.7870350854597 -122.392234997951 (37.7870350854597, -122.392234997951) 6 2 9 28855 6
162627 35487 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557) 15 6 1 29490 27
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
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
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
11471 260869 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
193198 111714 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3038 CLEMENT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051 2113265 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217) 11 6 2 55 26
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
97662 117018 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.66458 2112987.05621 37.7823185388132 -122.415547303188 (37.7823185388132, -122.415547303188) 7 10 9 28852 36
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
102847 256610 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
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
178528 121507 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012241.512 2112714.7441 37.7818013227969 -122.401289065763 (37.7818013227969, -122.401289065763) 6 2 9 28856 34
160249 113337 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
93218 113240 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 2 3x4 Permit Number 770912 6014728.70394 2112464.72966 37.7812532891345 -122.392666980121 (37.7812532891345, -122.392666980121) 6 2 9 28856 6
57241 253248 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
27168 75842 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 2 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
60760 122593 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend St 2 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
126119 85804 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 923 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031) 14 2 9 28856 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
728 102430 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.7794962351107 -122.407028471514 (37.7794962351107, -122.407028471514) 14 2 9 28853 34
122740 115096 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335) 14 2 9 28853 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
96128 73589 Planning Code 138.1 required 2 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 468 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 12 3x3 Permit Number 770905 6010928.13640467 2111848.51157587 37.7793494887795 -122.405771720076 (37.7793494887795, -122.405771720076) 14 2 9 28853 34
52945 117454 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 236 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2016 12:00:00 AM 3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
168133 121551 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009293.51408 2111653.12836 37.7787214646499 -122.411412777974 (37.7787214646499, -122.411412777974) 8 2 9 28853 34
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
97781 119286 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
12720 115537 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
135842 115529 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161) 7 9 9 28852 36
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
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
87472 255403 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
109022 255406 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
126056 255417 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6007395 2111066 37.7770026839515 -122.417938862064 (37.7770026839515, -122.417938862064) 7 9 9 28852 36
105455 256779 Planning Code 138.1 required 2 Tree(s) :: 17 1231 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4 Permit Number 782672 6001926.50082 2110819.32275 37.7760160870933 -122.436838397294 (37.7760160870933, -122.436838397294) 15 5 11 29492 10
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
61214 15236 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008261.49106 2110663.48431 37.7759461992201 -122.414912896556 (37.7759461992201, -122.414912896556) 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
26508 113650 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
154892 113645 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
158086 15247 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007902.55668 2110326.57547 37.7750009522643 -122.416130681693 (37.7750009522643, -122.416130681693) 8 2 9 28853 34
130781 255652 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 949 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002910 2110236 37.7744702748436 -122.433394524315 (37.7744702748436, -122.433394524315) 15 5 11 29492 10
74052 201694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009941.3987 2109939.6045 37.7740528464887 -122.409050544971 (37.7740528464887, -122.409050544971) 8 2 9 28853 34
181014 253484 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
135281 253476 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
161626 255692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
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
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20
642 260182 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
47024 120519 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
161200 257940 Planning Code 138.1 required 2 Tree(s) :: 17 65 Buena Vista Ave East 2 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2019 12:00:00 AM 3 3x3 Permit Number 779175 6001128.17111 2108817.40029 37.7704739053605 -122.439456486198 (37.7704739053605, -122.439456486198) 15 5 11 29492 9
148641 253378 Planning Code 138.1 required 2 :: 45 2 Alpine Ter 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001556 2108661 37.7700688079313 -122.43796542225 (37.7700688079313, -122.43796542225) 15 5 5 29492 9
67103 253756 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
163114 253748 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
174788 253736 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
170272 31068 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1450 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007659.7746 2107385.50696 37.7669118184545 -122.4167621155 (37.7669118184545, -122.4167621155) 8 4 7 28853 19
26464 251519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
166298 251296 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 2 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
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
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
49512 254717 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
169212 253102 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
177206 36045 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3030 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008531.98185334 2106261.58493121 37.7638748076146 -122.413665776536 (37.7638748076146, -122.413665776536) 8 4 7 28859 19
176658 252906 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 600 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19
47537 18353 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2013 12:00:00 AM 3 3x3   6010310.70956 2106111.3358 37.7635619805233 -122.407503071611 (37.7635619805233, -122.407503071611) 8 4 8 28859 19
105170 252909 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 3201x 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2017 12:00:00 AM 3 3x6 Permit Number 777588 6007417 2106083 37.7633217807187 -122.417509514421 (37.7633217807187, -122.417509514421) 8 4 7 28859 19
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
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
16696 195151 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29

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