trees

165 rows where DBH = 3 and qLegalStatus_id = 5 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
7105 262039 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1251 Hyde St   Sidewalk: Curb side : Cutout Tree Private 2   04/16/2020 12:00:00 AM 3 3x3 Permit Number 783100 6007540 2116706 37.7924969115625 -122.417837146347 (37.7924969115625, -122.417837146347) 5 1 10 28858 21
17 164866 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 719 Faxon Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/16/2020 12:00:00 AM 3 4x6 Permit Number 782492 5994853.78052 2092811.30491 37.7261661184654 -122.459999785581 (37.7261661184654, -122.459999785581) 9 7 4 28861 40
33 261067 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1832 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2020 12:00:00 AM 3 4x6 Permit Number 782484 6011934 2092960 37.727541965346 -122.400964507068 (37.727541965346, -122.400964507068) 10 3 8 58 1
37 264963 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3   6005706 2110306 37.7748207071365 -122.423727591769 (37.7748207071365, -122.423727591769) 7 9 11 28852 10
38 167409 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 4 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6001979.94285 2107686.90453 37.7674182815445 -122.436429284105 (37.7674182815445, -122.436429284105) 15 5 5 29492 3
67 99921 Section 806 (d) 5 Olea europaea :: Olive Tree 9 1740 Jones St 1 Front Yard : Yard Tree Private 2   06/01/2015 12:00:00 AM 3   Permit Number 774389 6008331.64636 2118443.68708 37.7973126906849 -122.415221079511 (37.7973126906849, -122.415221079511) 5 1 10 308 21
591 264763 Section 806 (d) 5 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 274 Victoria St 1 Sidewalk: Property side : Cutout Tree Private 2   10/05/2020 12:00:00 AM 3 3x3 Permit Number 781692 5993256.27541 2089011.86791 37.7156417766237 -122.465246370223 (37.7156417766237, -122.465246370223) 9 8 6 64 24
1059 262280 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
1296 114159 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.7953963109343 -122.434341453993 (37.7953963109343, -122.434341453993) 13 9 1 57 17
1811 258532 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1565 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2019 12:00:00 AM 3 3x3 Permit Number 777683 6006695.00356 2117330.6469 37.7941644464503 -122.420805231935 (37.7941644464503, -122.420805231935) 13 9 10 28858 32
2103 262299 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
2107 113082 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 414 Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.7262806120542 -122.407514778095 (37.7262806120542, -122.407514778095) 10 3 7 309 28
2593 19154 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 64 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.27402 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168) 15 9 5 28862 3
2854 255187 Section 806 (d) 5 Callistemon viminalis :: Weeping Bottlebrush 60 4740 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/27/2018 12:00:00 AM 3 3x3 Permit Number 780757 5980843 2110991 37.7752666409579 -122.509783220192 (37.7752666409579, -122.509783220192) 11 6 2 55 26
3241 31650 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3632 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2015 12:00:00 AM 3   Permit Number 35160 5981711.46236471 2097421.70961548 37.7380604052223 -122.505772893936 (37.7380604052223, -122.505772893936) 1 8 3 29491 35
3516 92206 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 443 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.76844 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576) 9 7 6 28861 5
3533 263634 Section 806 (d) 5 Tree(s) :: 17 211 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2020 12:00:00 AM 3 3x3   6008194.27066 2088426.33179 37.71488415001 -122.413572307092 (37.71488415001, -122.413572307092) 9 7 8 309 39
3977 262296 Section 806 (d) 5 Acer rubrum :: Red Maple 75 45 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 782635 5998403.0154 2106238.4273 37.7632372305534 -122.448696994498 (37.7632372305534, -122.448696994498) 15 5 11 29492 9
4243 162646 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
4387 264910 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1615 Wallace Ave 1 Front Yard : Cutout Tree Private 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
4564 264686 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2455 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/15/2020 12:00:00 AM 3 3x3 Permit Number 782284 5990129.23032 2098669.31502 37.7419778589065 -122.476759924113 (37.7419778589065, -122.476759924113) 1 8 3 29491 35
4604 261733 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 540 De Haro St 1 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
4750 113090 Section 806 (d) 5 Pyrus calleryana :: Ornamental Pear 44 1213 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.60872 37.7303322746045 -122.41230559973 (37.7303322746045, -122.41230559973) 9 3 7 309 28
4989 256185 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
5528 167133 Section 806 (d) 5 Melaleuca quinquenervia :: Cajeput 10 4564 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2019 12:00:00 AM 3 3x5 Permit Number 785333 6000784.60188 2104670.73247 37.7590686222364 -122.440347461192 (37.7590686222364, -122.440347461192) 2 4 5 28862 3
5958 102480 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 1456 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.91154 37.8020306879258 -122.427302455863 (37.8020306879258, -122.427302455863) 13 9 1 57 17
6198 112830 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 2265 MISSION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2015 12:00:00 AM 3 3x3   6006944 2105170 37.760788269781 -122.419080706794 (37.760788269781, -122.419080706794) 2 4 7 28859 19
6318 261662 Section 806 (d) 5 Aesculus californica :: California Buckeye 168 137 Elsie St 1 Sidewalk: Property side : Yard Tree Private 2   02/13/2020 12:00:00 AM 3     6007155.81154 2098485.15545 37.7424451335194 -122.417874270912 (37.7424451335194, -122.417874270912) 2 7 7 28859 2
6557 264929 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 4725 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2020 12:00:00 AM 3 3x3 Permit Number 784398 5981118.81181 2106198.14775 37.7621231273763 -122.508473270866 (37.7621231273763, -122.508473270866) 1 8 3 56 35
6755 264922 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 Urbano Dr 1 Sidewalk: Property side : Yard Tree Private 2   11/10/2020 12:00:00 AM 3 4x6 Permit Number 781481 5992625.08037 2092677.96132 37.7256715559054 -122.467694516591 (37.7256715559054, -122.467694516591) 9 8 4 59 40
6880 24222 Section 806 (d) 5 Quercus suber :: Cork Oak 78 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.382882921904 (37.7334154068844, -122.382882921904) 10 3 8 58 1
7043 112197 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2570 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.7921756543416 -122.437399303646 (37.7921756543416, -122.437399303646) 13 6 1 29490 27
7524 111636 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2625 35TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2015 12:00:00 AM 3 3x3   5985486 2097347 37.7380767082098 -122.492717127165 (37.7380767082098, -122.492717127165) 1 8 3 29491 35
7728 116230 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 49 Grace St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2014 12:00:00 AM 3 2.5x4 Permit Number 770598 6008318.16403 2110322.45497 37.7750129977898 -122.414692709823 (37.7750129977898, -122.414692709823) 8 2 9 28853 34
7739 262320 Section 806 (d) 5 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2567 31st Ave 1 Sidewalk: Property side : Cutout Tree Private 2   07/07/2020 12:00:00 AM 3 6x10 Permit Number 785009 5986744.29234 2097795.22153 37.7393809030196 -122.48839957369 (37.7393809030196, -122.48839957369) 1 8 3 29491 35
7765 263633 Section 806 (d) 5 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 160 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2020 12:00:00 AM 3 4x4 Permit Number 782824 6000235.49843 2104901.88273 37.7596720242526 -122.442263109517 (37.7596720242526, -122.442263109517) 2 4 5 28862 3
7830 262278 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 15 Corona St 1 Sidewalk: Property side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
8444 103091 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041) 5 1 10 308 21
8525 117146 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646) 10 3 8 58 1
9107 264723 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2020 12:00:00 AM 3 4x4 Permit Number 782646 6008658.96802 2100212.34216 37.7472720863526 -122.412798868954 (37.7472720863526, -122.412798868954) 2 7 7 28859 2
9475 163463 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 109 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995872.36784 2087580.2575 37.7118614273349 -122.456100577893 (37.7118614273349, -122.456100577893) 9 8 6 28861 24
9500 256189 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 3600 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3                        
9833 262515 Section 806 (d) 5 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1951 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/07/2020 12:00:00 AM 3 3x3 Permit Number 779100 5985670.12137 2101944.25665 37.7507102998335 -122.49241898675 (37.7507102998335, -122.49241898675) 1 8 3 29491 35
9877 126318 Section 806 (d) 5 Platanus x hispanica :: Sycamore: London Plane 27 752 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2020 12:00:00 AM 3 Width 3ft Permit Number 778828 6010086.22048 2116329.20443 37.791605285407 -122.409000507567 (37.791605285407, -122.409000507567) 5 1 10 28857 21
10128 256113 Section 806 (d) 5 Magnolia spp :: Magnolia 224 356 Willard North St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/10/2018 12:00:00 AM 3                        
11539 262395 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2755 40th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   07/21/2020 12:00:00 AM 3 3x3 Permit Number 784406 5983997.14788 2096421.7593 37.7354490751144 -122.497796450434 (37.7354490751144, -122.497796450434) 1 8 3 29491 35
11543 110044 Section 806 (d) 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 550 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2015 12:00:00 AM 3 3x3   5985672.92923 2112141.09949 37.7787081437008 -122.493160374959 (37.7787081437008, -122.493160374959) 11 6 2 55 26
11626 262262 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 1324 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2020 12:00:00 AM 3 4x4 Permit Number 784290 5993653.14185 2106470.72632 37.763602309694 -122.465141974097 (37.763602309694, -122.465141974097) 1 8 11 56 12
12144 111632 Section 806 (d) 5 Tree(s) :: 17 1758 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 774682 5985071 2103231.6 37.7542099449347 -122.49458566251 (37.7542099449347, -122.49458566251) 1 8 3 56 35
13211 262230 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 42 Dorantes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2020 12:00:00 AM 3 3x3 Permit Number 782723 5994180.46761 2100058.80006 37.7460271985036 -122.462852932256 (37.7460271985036, -122.462852932256) 1 8 4 29491 40
14180 256094 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2018 12:00:00 AM 3 3x3 Permit Number 777292 5982503.90034 2112800.93962 37.7803340153983 -122.504171983842 (37.7803340153983, -122.504171983842) 11 6 2 55 26
14443 260878 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 2395 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
14464 44040 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2504 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.74454 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121) 13 6 1 29490 27
14595 262138 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 1118 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2020 12:00:00 AM 3 3x3 Permit Number 783072 5995073.28586 2091364.23184 37.7222054253906 -122.459136235782 (37.7222054253906, -122.459136235782) 9 8 4 28861 24
15035 164228 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 2401 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991043.64805 2099007.36638 37.7429590601275 -122.473622846338 (37.7429590601275, -122.473622846338) 1 8 4 29491 40
15098 169494 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
16057 167157 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 368 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/11/2020 12:00:00 AM 3 4x4 Permit Number 782616 6001774.58914 2103700.91584 37.7564620577863 -122.436854194887 (37.7564620577863, -122.436854194887) 2 4 5 28862 3
16257 225172 Section 806 (d) 5 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2020 12:00:00 AM 3 4x4 Permit Number 779647 6006535.62128 2098220.14009 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071) 2 7 7 28859 2
16422 262267 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 1 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
16964 264738 Section 806 (d) 5 Prunus cerasifera :: Cherry Plum 7 2722 42nd Ave 1 Sidewalk: Property side : Cutout Tree Private 2   09/29/2020 12:00:00 AM 3 3x6 Permit Number 781841 5983409.1923 2096639.50516 37.7360124610612 -122.499845290879 (37.7360124610612, -122.499845290879) 1 8 3 29491 35
16986 111918 Section 806 (d) 5 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 41 Toledo Way 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.8013344103251 -122.438264349848 (37.8013344103251, -122.438264349848) 13 9 1 57 17
17154 110741 Section 806 (d) 5 Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 215 2300x Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.56363 37.7633264372932 -122.406480331995 (37.7633264372932, -122.406480331995) 8 4 8 28859 19
17374 163460 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.33981 2087649.24929 37.7120507463226 -122.45611257216 (37.7120507463226, -122.45611257216) 9 8 6 28861 24
17482 111313 Section 806 (d) 5 Tree(s) :: 17 3400x Wawona St 1 Sidewalk: Property side : Cutout Tree Private 2   06/02/2015 12:00:00 AM 3 3x3   5982298.43845 2096733.62139 37.7362056333855 -122.503692516423 (37.7362056333855, -122.503692516423) 1 8 3 29491 35
17710 169495 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 150 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 770415 6004561.3283 2097566.6275 37.7397767110236 -122.426779823841 (37.7397767110236, -122.426779823841) 2 7 5 63 7
18205 262139 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 1582 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2020 12:00:00 AM 3 3x3 Permit Number 782766 5981929 2104333 37.7570496794991 -122.505532928251 (37.7570496794991, -122.505532928251) 1 8 3 56 35
18566 256863 Section 806 (d) 5 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 274 Victoria St 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/19/2018 12:00:00 AM 3 3x8 Permit Number 781692 5993256.27541 2089011.86791 37.7156417766237 -122.465246370223 (37.7156417766237, -122.465246370223) 9 8 6 64 24
18916 152848 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 160 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 Width 3ft Permit Number 781252 6006654.74312 2105190.58967 37.7608285109489 -122.420082580673 (37.7608285109489, -122.420082580673) 2 4 7 28859 19
19451 254404 Section 806 (d) 5 Metrosideros excelsa :: New Zealand Xmas Tree 16 127 Central Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2018 12:00:00 AM 3 3x3   5999857 2108965 37.7708067512445 -122.443864065657 (37.7708067512445, -122.443864065657) 15 5 11 29492 9
19533 259217 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 200 Grafton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996177 2090586 37.7201319742324 -122.455264770625 (37.7201319742324, -122.455264770625) 9 8 6 28861 24
194328 258403 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 1052 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2019 12:00:00 AM 3 3x5   6011869 2103486 37.7564404909426 -122.401928842587 (37.7564404909426, -122.401928842587) 10 3 8 28856 29
194346 265043 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1250 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/17/2020 12:00:00 AM 3 5x10 Permit Number 781946 5987698.06233 2094734.87015 37.7310335805158 -122.484877445397 (37.7310335805158, -122.484877445397) 1 8 4 64 35
194389 265057 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1190 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194400 265055 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 1085 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194410 265060 Section 806 (d) 5 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 48 Miraloma Dr 1 Sidewalk: Property side : Yard Tree Private 2   12/28/2020 12:00:00 AM 3 6x6 Permit Number 782253 5994833.01253 2097558.21258 37.7391987718964 -122.46041537824 (37.7391987718964, -122.46041537824) 9 7 4 59 40
194448 265090 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 215 Montana St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2021 12:00:00 AM 3 3x3 Permit Number 784731 5994883.78198 2089306.03852 37.7165432206381 -122.459642300713 (37.7165432206381, -122.459642300713) 9 8 6 28861 24
194494 264749 Section 806 (d) 5 Quercus suber :: Cork Oak 78 1339 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2021 12:00:00 AM 3 3x3 Permit Number 785207 5991088 2106284 37.7629413570223 -122.474000279679 (37.7629413570223, -122.474000279679) 1 8 11 56 12
3374 261742 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 10 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14658 261743 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 11 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
5885 261744 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 12 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
14638 261745 Section 806 (d) 5 Geijera parviflora :: Australian Willow 25 540 De Haro St 13 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
15024 261746 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 14 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
11461 261747 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 15 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3337 261748 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 16 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
56 124 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1032 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6002037.12702 2107659.05322 37.7673450578674 -122.436229498819 (37.7673450578674, -122.436229498819) 15 5 5 29492 3
881 254388 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 990 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2018 12:00:00 AM 3 3x3   6009377.71563 2118076.93343 37.7963644085284 -122.411575473026 (37.7963644085284, -122.411575473026) 3 1 10 308 4
3302 256186 Section 806 (d) 5 Olea europaea 'Fruitless' :: Fruitless Olive 177 1598 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2018 12:00:00 AM 3     6003155.82812 2120664.19895 37.8031173987704 -122.433289466249 (37.8031173987704, -122.433289466249) 13 9 1 57 17
3414 262418 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 101 Brighton Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2020 12:00:00 AM 3 3x3 Permit Number 784737 5996197.23422 2090625.75995 37.7202423066045 -122.455197699909 (37.7202423066045, -122.455197699909) 9 8 6 28861 24
3836 261734 Section 806 (d) 5 Podocarpus gracilor :: Fern Pine 51 540 De Haro St 2 Sidewalk: Property side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
3880 262281 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 10 Niantic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784434 5992391 2086794 37.7095021076955 -122.468075893068 (37.7095021076955, -122.468075893068) 9 8 4 64 24
4024 114160 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 2250 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.434397600465 (37.7953804657925, -122.434397600465) 13 9 1 57 17
6139 264669 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
6383 228279 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
9135 262279 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 15 Corona St 2 Sidewalk: Property side : Cutout Tree Private 2   06/25/2020 12:00:00 AM 3 3x3 Permit Number 784820 5992625 2091331 37.7219731255806 -122.467596882777 (37.7219731255806, -122.467596882777) 9 8 4 59 40
9912 103092 Section 806 (d) 5 Fagus sylvatica :: European Beech 272 1540 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.63756 37.7955740826282 -122.414863256344 (37.7955740826282, -122.414863256344) 5 1 10 308 21
10674 117147 Section 806 (d) 5 Eriobotrya deflexa :: Bronze Loquat 8 928 Toland St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978 (37.7414998183769, -122.40118925978) 10 3 8 58 1
12694 262268 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 10X Restani Stwy 2 Unaccepted Street : Yard Tree Private 2   06/19/2020 12:00:00 AM 3 3x3 Permit Number 782248 5999595 2089918 37.7184933152793 -122.443401977243 (37.7184933152793, -122.443401977243) 9 7 6 28861 25
14850 98281 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 66 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2012 12:00:00 AM 3   Permit Number 58649 6008165.69574 2110879.12634 37.7765329177037 -122.415259547114 (37.7765329177037, -122.415259547114) 8 2 9 28853 34
15368 262300 Section 806 (d) 5 Lagunaria patersonii :: Primrose Tree 6 209 Prentiss St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2020 12:00:00 AM 3 3x3 Permit Number 773443 6008837.63968 2097618.9316 37.7401611793174 -122.411997789374 (37.7401611793174, -122.411997789374) 10 7 7 28859 2
15653 164229 Section 806 (d) 5 Lophostemon confertus :: Brisbane Box 11 2401 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2020 12:00:00 AM 3 3x3 Permit Number 773215 5991045.42225 2098958.21862 37.7428242157788 -122.47361312736 (37.7428242157788, -122.47361312736) 1 8 4 29491 40

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