trees

736 rows where DBH = 3 and qLegalStatus_id = 2 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
34999 154898 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 4 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
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
139506 254366 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 79 Ashton Ave 1 Front Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929 5994130.90698 2090445.22251 37.7196278254181 -122.462327167234 (37.7196278254181, -122.462327167234) 9 8 6 28861 24
139523 254363 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 634 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 3x3 Permit Number 772779 5981973.79907 2111426.3014 37.7765284742444 -122.505903875162 (37.7765284742444, -122.505903875162) 11 6 2 55 26
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
160246 254370 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1101X Ortega St 1 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
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
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
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
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
40425 115540 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
75364 115539 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 4 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
93518 115534 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 4 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.7775284833993 -122.418420222514 (37.7775284833993, -122.418420222514) 7 9 9 28852 36
115681 115533 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 3 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452) 7 9 9 28852 36
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
164265 115538 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 3 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
167439 115530 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 101 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243) 7 9 9 28852 36
168962 115531 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 1 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.73746 2111269.98589 37.7775581502144 -122.41823790028 (37.7775581502144, -122.41823790028) 7 9 9 28852 36
171393 115528 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007325.8351 2111377.63368 37.7778544624367 -122.418200224953 (37.7778544624367, -122.418200224953) 7 9 9 28852 36
184734 115535 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 5 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.7775281488378 -122.418497266559 (37.7775281488378, -122.418497266559) 7 9 9 28852 36
185440 115536 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 1 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
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
36458 113646 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 3 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
99698 113643 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 5 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
117291 113647 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 4 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
124821 113644 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 1 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
139476 113655 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 901X JESSIE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 3x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
152719 113648 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 6 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
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
23597 115495 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 3 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
27737 115492 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 3 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
46086 115494 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
65049 115493 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 4 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
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
155417 106315 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1199X OCEAN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259 2091739 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389) 9 8 4 28861 24
186409 115490 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 280 BRIGHTON AVE 1 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
2574 216200 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2020 12:00:00 AM 3 4x4 Permit Number 784456 5992806.74011 2104217.97153 37.7573679916535 -122.467905522425 (37.7573679916535, -122.467905522425) 1 8 4 56 12
122256 254396 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 167 Harvard St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3x3 Permit Number 774780 6006150.23201 2093073.81475 37.7275301484246 -122.420967149802 (37.7275301484246, -122.420967149802) 9 7 7 309 5
180231 254400 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2346 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   02/12/2018 12:00:00 AM 3 3X3   5982081.05878 2099125.72352 37.7427609043033 -122.504621254744 (37.7427609043033, -122.504621254744) 1 8 3 29491 35
83711 258012 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 238 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2019 12:00:00 AM 3 3x3 Permit Number 781835 6001423.51445 2104434.57022 37.7584565353532 -122.438120885556 (37.7584565353532, -122.438120885556) 2 4 5 28862 3
54415 224728 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 3x3 Permit Number 771820 6009984.63313 2102660.33541 37.754068053508 -122.408387439738 (37.754068053508, -122.408387439738) 2 4 7 28859 19
3879 260548 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
4508 260546 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
6679 152982 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006311.85744 2102620.48455 37.7537522736602 -122.421085978553 (37.7537522736602, -122.421085978553) 2 4 5 28859 19
7127 260547 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
8822 260549 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
13165 152981 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
77927 187639 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1671 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2017 12:00:00 AM 3 3x6   5985585 2103854 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295) 1 8 3 56 35
142797 115805 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 872 Kansas St   Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3   6011546.4 2104246.9 37.7585117443173 -122.403098033012 (37.7585117443173, -122.403098033012) 10 3 8 28856 29
78698 173775 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1057 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2018 12:00:00 AM 3 4x4 Permit Number 779347 6009462.91602 2103024.17334 37.7550378411013 -122.410217357343 (37.7550378411013, -122.410217357343) 2 4 7 28859 19
8777 18349 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 480 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 3 3X3   6010308 2106081 37.7634785336334 -122.407510304274 (37.7634785336334, -122.407510304274) 8 4 8 28859 19
28863 115887 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
29841 115885 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Property side : Yard Tree Private 2   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
45389 115886 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 134 Lunado Way 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
17726 65839 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2328 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2018 12:00:00 AM 3 6x6 Permit Number 772721 5999589.88517 2120533.82376 37.802556482867 -122.445620078411 (37.802556482867, -122.445620078411) 13 9 1 57 17
84799 115962 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 209 Grattan St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2016 12:00:00 AM 3 3x3   5997642.1 2106419.3 37.7636903209387 -122.451341781368 (37.7636903209387, -122.451341781368) 15 5 11 29492 9
8713 261829 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 256 Casitas Ave 1 Sidewalk: Property side : Yard Tree Private 2   03/05/2020 12:00:00 AM 3 3x3 Permit Number 781540 5994862.12068 2096567.59314 37.7364804498834 -122.460242983215 (37.7364804498834, -122.460242983215) 9 7 4 59 40
12606 261830 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 256 Casitas Ave 2 Sidewalk: Property side : Yard Tree Private 2   03/05/2020 12:00:00 AM 3 3x3 Permit Number 781540 5994862.12068 2096567.59314 37.7364804498834 -122.460242983215 (37.7364804498834, -122.460242983215) 9 7 4 59 40
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
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
31022 79408 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 322 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 4x4 Permit Number 776851 6004758.73696772 2101857.84943819 37.7515705801104 -122.426402728229 (37.7515705801104, -122.426402728229) 2 4 5 28862 22
119230 254617 Planning Code 138.1 required 2 :: 45 685 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3 Permit Number 773164 6009303.1948 2105068.09113 37.7606410229668 -122.410914072761 (37.7606410229668, -122.410914072761) 2 4 7 28859 19
168205 157655 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 4171 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3 Permit Number 777107 6002113.71434 2101756.88931 37.7511434941804 -122.435542313334 (37.7511434941804, -122.435542313334) 2 4 5 28862 22
145605 183545 Planning Code 138.1 required 2 Agonis flexuosa :: Peppermint Willow 65 2580 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 4x4 Permit Number 777874 5988340.9772 2097760.0505 37.7393773655768 -122.482876432223 (37.7393773655768, -122.482876432223) 1 8 3 29491 35
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
129107 46432 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2St. Ankeny St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2002 12:00:00 AM 3 3x3 Permit Number 44652 6011085.82067 2089727.08588 37.7186176993268 -122.403669311209 (37.7186176993268, -122.403669311209) 10 7 8 309 28
16815 109466 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.397382385507 (37.7726711397891, -122.397382385507) 14 2 9 310 20
27368 109463 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.397195438039 (37.7728133064148, -122.397195438039) 14 2 9 310 20
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
4228 254718 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 3 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
15059 254699 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
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
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
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
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
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
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
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
96441 254702 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
111570 254719 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 4 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
114018 254721 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 6 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
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
126016 254720 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 5 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
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
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
131987 254722 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 7 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
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

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