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

View and edit SQL

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)
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
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
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
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
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
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
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
186896 114793 Planning Code 138.1 required 2 Tree(s) :: 17 10 Linares Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x10 Permit Number 777094 5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
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
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
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
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
183675 122698 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 98 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
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
179839 160370 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 868 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349) 9 7 6 28861 5
179256 152616 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009096.56353 2101019.92176 37.7495140728181 -122.411342732484 (37.7495140728181, -122.411342732484) 2 4 7 28859 19
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
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
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
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
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
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
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
173710 243660 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 4471 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/14/2018 12:00:00 AM 3 4x4 Permit Number 773370 6000282.83907 2102244.20874 37.7523773981989 -122.441908628496 (37.7523773981989, -122.441908628496) 2 4 5 28862 22
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
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
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
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
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
167666 173650 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Entrada Ct 2 Sidewalk: Property side : Yard Tree Private 2   12/21/2016 12:00:00 AM 3 4x10   5992424.45657 2092194.59394 37.7243327619491 -122.468352901223 (37.7243327619491, -122.468352901223) 9 8 4 59 40
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
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
165057 255376 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2699X Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/15/2018 12:00:00 AM 3 3x3   5984648 2097442 37.7382885158105 -122.495621472041 (37.7382885158105, -122.495621472041) 1 8 3 29491 35
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
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
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
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
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
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
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
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
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
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
155799 256869 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 985 Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776274 6009287.99434 2098069.06568 37.7414224065761 -122.410472416169 (37.7414224065761, -122.410472416169) 10 7 7 28859 2
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
152864 124718 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 610 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/22/2018 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.7389386461297 -122.415817669649 (37.7389386461297, -122.415817669649) 2 7 7 28859 2
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
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
151446 170486 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 121 Cayuga Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003308.3245 2094432.02915 37.7310988944888 -122.430888530379 (37.7310988944888, -122.430888530379) 9 7 5 28861 25
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
147840 170500 Planning Code 138.1 required 2 Rhamnus alaternus :: Italian Buckthorn 29 1178 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2018 12:00:00 AM 3 4x4 Permit Number 779173 6003320.2391 2094320.37512 37.7307929928046 -122.430839374365 (37.7307929928046, -122.430839374365) 9 7 5 28861 25
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
135962 187674 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
135960 103695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1X Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006027.79546 2103458.18152 37.7560363783091 -122.422127839194 (37.7560363783091, -122.422127839194) 2 4 5 28859 19
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
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
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
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
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
130529 256674 Planning Code 138.1 required 2 Cornus florida :: Eastern Dogwood 385 330 Twin Peaks Blvd 2 Side Yard : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
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
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
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
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
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
123272 256677 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
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
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
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
120310 173614 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2955 20th Ave 2 Sidewalk: Property side : Yard Tree Private 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
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
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
113669 159358 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 49 Naglee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.88571 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692) 9 7 6 28861 25
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
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
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
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
100425 243144 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 98x Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
100024 258333 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 2 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
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
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
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
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
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
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
95904 256882 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3075 25th Ave 2 Sidewalk: Property side : Yard Tree Private 2   12/21/2018 12:00:00 AM 3 3x10 Permit Number 781920 5988824.60597 2094879.63635 37.7314966214822 -122.480993433312 (37.7314966214822, -122.480993433312) 1 8 4 64 35
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
93272 256871 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1025 Powhattan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2018 12:00:00 AM 3 3x3 Permit Number 776275 6009358.6182 2098062.94866 37.7414095695618 -122.410227790564 (37.7414095695618, -122.410227790564) 10 7 7 28859 2
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
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
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
86852 154903 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
82212 156914 Planning Code 138.1 required 2 Tree(s) :: 17 2995 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2018 12:00:00 AM 3 3x3 Permit Number 782654 6009047.12311 2101072.92433 37.7496568330138 -122.411517443787 (37.7496568330138, -122.411517443787) 2 4 7 28859 19
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
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
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
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
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
71090 115491 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
70866 224462 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010311.37562 2101086.64633 37.7497653433983 -122.407146558773 (37.7497653433983, -122.407146558773) 2 4 7 28859 19

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