trees

8,298 rows where qLegalStatus_id = 4 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▲ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
18337 113889 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 1x STORRIE ST 2 Sidewalk: Property side : Yard Tree DPW 1     90     6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
113111 113895 Undocumented 4 Populus spp :: Poplar Spp 262 1x STORRIE ST 27 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   6000722 2105303 37.7608011093363 -122.440609317727 (37.7608011093363, -122.440609317727) 15 4 5 28862 3
369 138522 Undocumented 4 Tristania conferta :: 61 1602 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001658.1955 2114019.9111 37.7847888393579 -122.437995843174 (37.7847888393579, -122.437995843174) 13 6 11 29490 13
8808 198709 Undocumented 4 Ulmus spp :: Elm Spp 98 1575 Bay Shore Blvd 5 : Tree Private 2     9 Width 3ft   6011880.53852 2091897.11167 37.7246205103096 -122.401074672678 (37.7246205103096, -122.401074672678) 10 3 8 58 1
14738 103343 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
18623 99145 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 302X Pacheco St 29 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
23402 105461 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 1118 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000021.8 2108530.5 37.7696231224597 -122.443262808274 (37.7696231224597, -122.443262808274) 15 5 11 29492 9
23868 205774 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 367 Kensington Way 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 5ft   5994104.03782 2099097.57437 37.7433835122355 -122.463047484554 (37.7433835122355, -122.463047484554) 1 8 4 59 40
29583 116767 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 598X EUREKA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6001504 2102368 37.7527868092986 -122.437694527956 (37.7527868092986, -122.437694527956) 2 4 5 28862 22
32073 237557 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 268 Dorland St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003747.65215 2105721.43729 37.7621218691579 -122.430174787942 (37.7621218691579, -122.430174787942) 8 4 5 28862 3
32399 102602 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
32479 125072 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2559 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002527.91845 2116093.19627 37.7905309723786 -122.435135231625 (37.7905309723786, -122.435135231625) 13 9 1 29490 27
34481 201714 Undocumented 4 Acacia stenophylla :: Shoestring Acacia 30 726 Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015317.96334 2088364.51894 37.7151118613908 -122.388945312084 (37.7151118613908, -122.388945312084) 10 3 8 58 1
35901 94252 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 10 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
36324 102902 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 290 PACIFIC AVE   Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6012556 2118523 37.797766966668 -122.400609219963 (37.797766966668, -122.400609219963) 3 1 10 28860 6
37319 105121 Undocumented 4 :: 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree Private 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
37764 76002 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 49 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1996 12:00:00 AM 9 3x3   6015772.4 2112409.7 37.7811600997206 -122.389052431052 (37.7811600997206, -122.389052431052) 6 2 9 28856 20
39406 129582 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2230 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6003450.16372 2117252.10795 37.7937653733223 -122.432027112554 (37.7937653733223, -122.432027112554) 13 9 1 29490 27
39468 99019 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 520 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010049.73515 2105870.79075 37.7628868873314 -122.408388735644 (37.7628868873314, -122.408388735644) 8 4 8 28859 19
39839 93152 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 222 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x13   5994796 2087777 37.7123397937745 -122.459835021723 (37.7123397937745, -122.459835021723) 9 8 6 28861 24
39923 94251 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
41812 115588 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2574 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5987741.7 2097778.5 37.7393931357191 -122.484949795247 (37.7393931357191, -122.484949795247) 1 8 3 29491 35
42331 76087 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 49 Townsend St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1996 12:00:00 AM 9 3x3   6015772.4 2112409.7 37.7811600997206 -122.389052431052 (37.7811600997206, -122.389052431052) 6 2 9 28856 20
42902 104963 Undocumented 4 Jacaranda mimosifolia :: Jacaranda 50 1474X SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3z3 Permit Number 770948 6008023 2099506 37.7452969115591 -122.414948020341 (37.7452969115591, -122.414948020341) 2 7 7 28859 2
45351 94249 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
48739 106913 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 141 JULIAN AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6006471.6 2107041.4 37.7659000812053 -122.420847395478 (37.7659000812053, -122.420847395478) 8 4 7 28853 19
50823 237156 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 874 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010167.02292 2104149.38568 37.7581668648249 -122.407861683494 (37.7581668648249, -122.407861683494) 2 4 7 28859 19
52051 100288 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
52319 76025 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 49 Townsend St 8 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1996 12:00:00 AM 9 3x4   6015772.4 2112409.7 37.7811600997206 -122.389052431052 (37.7811600997206, -122.389052431052) 6 2 9 28856 20
54145 111850 Undocumented 4 :: 45 245 STATES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000624 2106601 37.764359516173 -122.441041378606 (37.764359516173, -122.441041378606) 15 5 5 28862 3
54991 94248 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
63011 102695 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 384 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000881 2096712 37.7372213335044 -122.439443565515 (37.7372213335044, -122.439443565515) 2 7 5 63 7
63497 177892 Undocumented 4 Olea europaea :: Olive Tree 9 350 Rutland St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010348.87494 2088600.69344 37.7154836618219 -122.406137331491 (37.7154836618219, -122.406137331491) 9 7 8 309 39
67925 175029 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 54 Desmond St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6010591.02139 2086933.10615 37.7109183460773 -122.405183003288 (37.7109183460773, -122.405183003288) 9 7 8 309 39
70356 106222 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 940 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000384 2101992 37.7516906579726 -122.441540701476 (37.7516906579726, -122.441540701476) 2 4 5 28862 22
73467 100290 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
75148 105367 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 249 BROAD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5994550.4 2088030.5 37.71302171758 -122.460702242455 (37.71302171758, -122.460702242455) 9 8 6 28861 24
75871 125324 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 640 Davis St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6013147.44886 2118845.30288 37.798684901431 -122.398585258406 (37.798684901431, -122.398585258406) 3 1 10 28860 6
80343 102221 Undocumented 4 Tree(s) :: 17 30 Aloha Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5992101.6 2104316.3 37.7575972316932 -122.470351313846 (37.7575972316932, -122.470351313846) 1 8 4 56 12
81726 114266 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 800x BROTHERHOOD WAY 7 Front Yard : Cutout Tree Private 2     9     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
82621 94976 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 2040@Jackson Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005619 2117006 37.7932123416077 -122.42450522172 (37.7932123416077, -122.42450522172) 13 9 1 28858 27
83269 99143 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 302X Pacheco St 26 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
83417 236282 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 774 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007316.44531 2102811.00154 37.7543319694717 -122.417625379218 (37.7543319694717, -122.417625379218) 2 4 7 28859 19
84141 102599 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
85182 210484 Undocumented 4 Myoporum laetum :: Myoporum 62 200 Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992541.10435 2099158.31764 37.7434601434812 -122.468456080182 (37.7434601434812, -122.468456080182) 1 8 4 29491 40
85367 107721 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2690 03RD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 774467 6015722.8 2103248.4 37.7560024194125 -122.388584342965 (37.7560024194125, -122.388584342965) 10 3 8 28856 29
85492 95237 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
88849 99151 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 302X Pacheco St 35 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
89717 112625 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1811 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008061 2107870 37.7682646820652 -122.415408640275 (37.7682646820652, -122.415408640275) 8 4 7 28853 19
91014 74195 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1035 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1995 12:00:00 AM 9     6007605.80977 2115075.33872 37.7880232200293 -122.417493821895 (37.7880232200293, -122.417493821895) 13 1 10 28858 21
92321 130230 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1541 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006202.08528 2118286.61055 37.7967614871941 -122.422578747925 (37.7967614871941, -122.422578747925) 13 9 10 28858 32
92764 100287 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
93417 94253 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 12 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
98499 102601 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100078 102598 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100420 211735 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2560 Ocean Ave 1 : Tree Private 2     9 Width 3ft   5991148.534 2094888.45325 37.7316556467951 -122.472959890411 (37.7316556467951, -122.472959890411) 1 8 4 64 40
102701 223409 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 898 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010169.99414 2104057.76493 37.7579154611487 -122.407844947098 (37.7579154611487, -122.407844947098) 2 4 7 28859 19
105839 212199 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 820 Bosworth St 7 Sidewalk: Property side : Yard Tree Private 2     9     6001716.86925 2095561.16435 37.7341089397759 -122.436471242853 (37.7341089397759, -122.436471242853) 2 7 5 63 7
107208 100135 Undocumented 4 Tree(s) :: 17 155 05th St 1 Front Yard : Yard Tree Private 2   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
107887 99154 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 302X Pacheco St 37 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
108094 100289 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
108744 230393 Undocumented 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 3420 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005567.36067 2103163.57677 37.7552014816894 -122.423699232135 (37.7552014816894, -122.423699232135) 2 4 5 28859 19
110206 92942 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 377 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9     5992043 2096735 37.73677754441 -122.470001973507 (37.73677754441, -122.470001973507) 1 8 4 59 40
110925 94974 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 2040@Jackson Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005619 2117006 37.7932123416077 -122.42450522172 (37.7932123416077, -122.42450522172) 13 9 1 28858 27
111496 106221 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 940 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6000384 2101992 37.7516906579726 -122.441540701476 (37.7516906579726, -122.441540701476) 2 4 5 28862 22
112699 122500 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 722 Duboce Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6002237 2108339 37.7692233784846 -122.435586816367 (37.7692233784846, -122.435586816367) 15 5 5 29492 9
120525 103005 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 41X Beulah St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5997709.4 2107777.7 37.7674239953752 -122.451206983541 (37.7674239953752, -122.451206983541) 15 5 11 29492 9
124421 110921 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 20x DE BOOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014792 2113102 37.7830066040332 -122.392492594241 (37.7830066040332, -122.392492594241) 6 2 9 28856 6
124909 103134 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 345X Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005937 2110878 37.7764043178826 -122.422969176765 (37.7764043178826, -122.422969176765) 7 9 11 28852 10
126420 99141 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 23 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
127110 103340 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 772809 6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
135773 80511 Undocumented 4 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
138225 101082 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1699X Tennessee St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015823 2101385 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
141508 200338 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 21 : Tree Private 2     9 Width 2ft   6015318.39191 2098076.99567 37.7417804059521 -122.389621766852 (37.7417804059521, -122.389621766852) 10 3 8 58 1
141864 246311 Undocumented 4 Tristania conferta :: 61 1601 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6007089.8834 2109370.8451 37.772331017243 -122.418874102872 (37.772331017243, -122.418874102872) 8 2 9 28853 19
143277 102760 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010215.5 2111581.3 37.7785759102049 -122.408218187711 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
143815 94250 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 8 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
144564 102324 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3201X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008125.3 2105602.6 37.7620425418858 -122.415025724241 (37.7620425418858, -122.415025724241) 2 4 7 28859 19
145825 105308 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 334 EL CAMINO DEL MAR 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5987596.5 2115333.2 37.7875850583177 -122.486740542282 (37.7875850583177, -122.486740542282) 11 6 1 55 33
146428 102835 Undocumented 4 Schinus terebinthifolius :: Brazilian Pepper 93 25X Lansing St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014531.5 2114230.8 37.7860915609161 -122.393472847757 (37.7860915609161, -122.393472847757) 6 2 9 28855 6
150564 102603 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
152209 105842 Undocumented 4 Ficus nitida :: Laurel Fig 53 51 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 2x3   6003352 2106231 37.7634985883576 -122.431579576657 (37.7634985883576, -122.431579576657) 15 4 5 28862 3
154035 99243 Undocumented 4 Ficus nitida :: Laurel Fig 53 570 Ellis St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     9 4x4   6008204 2113818 37.784604512923 -122.41533513918 (37.784604512923, -122.41533513918) 7 10 9 28858 36
155305 102600 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
155778 94256 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2777X 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.409573390285 (37.7597963985886, -122.409573390285) 2 4 8 28859 19
159235 100291 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3755X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003046.2 2121203.4 37.804591683504 -122.433707396943 (37.804591683504, -122.433707396943) 13 9 1 57 17
159414 107010 Undocumented 4 Arbutus unedo :: Strawberry Tree 106 400 ALABAMA ST 9 Sidewalk: Curb side : Cutout Tree Private 2     9     6008836.3 2106230.4 37.7638062650833 -122.412611023479 (37.7638062650833, -122.412611023479) 8 4 7 28859 19
160674 200336 Undocumented 4 Liriodendron tulipifera :: Tulip Tree 145 750 Phelps St 8 : Tree Private 2     9 Width 3ft   6015493.51667 2098314.62088 37.7424425848476 -122.38903282511 (37.7424425848476, -122.38903282511) 10 3 8 58 1
163243 94977 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 2040@Jackson Franklin St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005619 2117006 37.7932123416077 -122.42450522172 (37.7932123416077, -122.42450522172) 13 9 1 28858 27
165035 103135 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 345X Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6005937 2110878 37.7764043178826 -122.422969176765 (37.7764043178826, -122.422969176765) 7 9 11 28852 10
169183 99144 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 302X Pacheco St 27 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
169725 138345 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2250 Sutter St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6001736.79 2114308.7957 37.7855865118356 -122.437744629649 (37.7855865118356, -122.437744629649) 13 6 1 29490 27
172696 101083 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1699X Tennessee St 9 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6015823 2101385 37.7508914678049 -122.388107781388 (37.7508914678049, -122.388107781388) 10 3 8 28856 1
172758 102442 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 4145 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008344 2095883 37.735366982035 -122.413581854524 (37.735366982035, -122.413581854524) 10 7 7 28859 2
173585 114422 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 30X OGDEN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x9   6009444 2095952 37.7356181472918 -122.40978359874 (37.7356181472918, -122.40978359874) 10 7 7 28859 2
175904 103037 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 500X Alvarado St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 4x4   6003108.4 2102730.8 37.7538740670297 -122.432172131424 (37.7538740670297, -122.432172131424) 2 4 5 28862 22
177969 122633 Undocumented 4 Ficus nitida :: Laurel Fig 53 260 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6006915 2105702 37.7622473847542 -122.419218743707 (37.7622473847542, -122.419218743707) 8 4 7 28859 19
179795 194762 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 900 Quint St 2 Side Yard : Yard Tree Private 2     9 Width 3ft   6014169.91323 2097651.03706 37.7405470630994 -122.393563052915 (37.7405470630994, -122.393563052915) 10 3 8 58 1
181280 117508 Undocumented 4 Malus :: Crab Apple 82 21 MOUNTAIN SPRING AVE 1 Sidewalk: Property side : Cutout Tree Private 2     9 3x10 Permit Number 778424 5997487 2104391 37.7581122388252 -122.451731896555 (37.7581122388252, -122.451731896555) 15 5 4 28862 38
182844 105828 Undocumented 4 Myoporum laetum :: Myoporum 62 936 ELIZABETH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9     6000414.4 2102014.7 37.7517547185995 -122.441437203296 (37.7517547185995, -122.441437203296) 2 4 5 28862 22

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