trees

416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
50301 254481 Significant Tree 6 Juniperus chinensis :: Juniper 113 1274 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992738 2106820 37.7645085090972 -122.468332545675 (37.7645085090972, -122.468332545675) 11 8 11 56 12
51266 255290 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3353 19th Ave 1 Side Yard : Cutout Tree Private 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
51737 116458 Significant Tree 6 Eucalyptus lehmanni :: Bushy Yate 260 777 Brotherhood Way 1 Sidewalk: Curb side : Yard Tree Private 2     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327) 1 8 4 64 14
52054 255462 Significant Tree 6 Tree(s) :: 17 98 Saint Francis Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x5 Permit Number 777805 5992112.53458 2095987.97644 37.7347304251367 -122.469707196177 (37.7347304251367, -122.469707196177) 9 8 4 59 40
52128 112811 Significant Tree 6 Tree(s) :: 17 2023 43rd Ave 1 Front Yard : Yard Tree Private 2           5982877.4 2101339.2 37.7488853101021 -122.502031530859 (37.7488853101021, -122.502031530859) 1 8 3 29491 35
52558 255280 Significant Tree 6 Olea europaea :: Olive Tree 9 320 Magellan Ave 1 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
54288 115736 Significant Tree 6 Acer rubrum :: Red Maple 75 66 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776551 5993801.4 2096894.7 37.7373175329251 -122.463934052027 (37.7373175329251, -122.463934052027) 1 8 4 59 40
55399 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2591 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM   3x3   5988279 2097698.2 37.7392039339278 -122.483086187221 (37.7392039339278, -122.483086187221) 1 8 3 29491 35
55614 104904 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 417 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
56298 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 104x TAPIA DR 1 Front Yard : Cutout Tree Private 2     10     5988688 2090939 37.7206686952673 -122.481177253578 (37.7206686952673, -122.481177253578) 1 8 4 64 14
58321 114094 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 239x VIDAL DR 1 Front Yard : Yard Tree Private 2     24     5987668 2090475 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602) 1 8 4 64 14
58651 100191 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1201 Holloway Ave 1 Front Yard : Yard Tree Private 2           5992431.5 2091178.1 37.7215421255294 -122.468254640211 (37.7215421255294, -122.468254640211) 9 8 6 64 24
59764 105504 Significant Tree 6 Pinus radiata :: Monterey Pine 15 39 MAGELLAN AVE 1 Front Yard : Yard Tree Private 2     18     5994694.1 2101166.3 37.7490976851152 -122.461157135733 (37.7490976851152, -122.461157135733) 1 8 4 29491 40
59933 122637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630X 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x8   5990614 2091411 37.7220764711857 -122.47455416919 (37.7220764711857, -122.47455416919) 9 8 4 64 40
60308 99100 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 60 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2           5993700.7 2097327 37.7384987171226 -122.464313592449 (37.7384987171226, -122.464313592449) 1 8 4 59 40
62177 99097 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Santa Monica Way 1 Sidewalk: Curb side : Yard Tree Private 2           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094) 9 8 4 59 40
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
64792 114144 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1200x JUNIPERO SERRA BLVD 1 Front Yard : Yard Tree Private 2     10     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
66315 109521 Significant Tree 6 Tree(s) :: 17 1308 Ulloa St 1 Front Yard : Yard Tree Private 2       3x3   5991965.5 2098469.9 37.7415366593774 -122.470396231887 (37.7415366593774, -122.470396231887) 1 8 4 29491 40
67970 93221 Significant Tree 6 Tree(s) :: 17 85 Santa Rita Ave 1 Front Yard : Yard Tree Private 2   02/26/2010 12:00:00 AM     Permit Number 53213 5993788 2100441 37.7470540096767 -122.464237765204 (37.7470540096767, -122.464237765204) 1 8 4 29491 40
69013 254092 Significant Tree 6 Tree(s) :: 17 716 Gonzalez Dr 1 Front Yard : Yard Tree Private 2   01/24/2018 12:00:00 AM 3 10x10 Permit Number 781051 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
69528 253807 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 2 Garfield St 1 Side Yard : Yard Tree Private 2       10x2 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
71845 114379 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 443X ARBALLO DR 1 Front Yard : Yard Tree Private 2     36     5988110 2090275 37.7188118998372 -122.483126550771 (37.7188118998372, -122.483126550771) 1 8 4 64 14
72904 117269 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 399X SANTA CLARA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993324 2095440 37.7332957649176 -122.465478985137 (37.7332957649176, -122.465478985137) 9 8 4 59 40
73267 115729 Significant Tree 6 Acer rubrum :: Red Maple 75 10x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 776540 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
73343 122634 Significant Tree 6 Tree(s) :: 17 3680X 19th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592 2091224 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991) 9 8 4 64 40
74248 208929 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 501 Saint Francis Blvd 1 Sidewalk: Curb side : Pot Tree Private 2     34 Width 6ft   5993145.62708 2096072.03007 37.735020873007 -122.466141577798 (37.735020873007, -122.466141577798) 1 8 4 59 40
75453 100529 Significant Tree 6 Tree(s) :: 17 720 Victoria St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769203 5993611.6 2091925.6 37.723662667106 -122.464229627127 (37.723662667106, -122.464229627127) 9 8 4 59 40
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
76029 114099 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 201x VIDAL DR 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5987665 2090646 37.7198046658936 -122.484691919383 (37.7198046658936, -122.484691919383) 1 8 4 64 14
76411 104900 Significant Tree 6 Betula pendula :: European White Birch 253 317 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
76823 255913 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 121 San Marcos Ave 1 Side Yard : Yard Tree Private 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
78664 114390 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 1 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
81276 114097 Significant Tree 6 Pinus thunbergii :: Japanese Black Pine 207 221x VIDAL DR 1 Front Yard : Yard Tree Private 2     14     5987664 2090556 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519) 1 8 4 64 14
82975 255461 Significant Tree 6 Tree(s) :: 17 37 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/24/2018 12:00:00 AM 3 10x6 Permit Number 777804 5994021.13024 2097608.02637 37.7392888101295 -122.463226093964 (37.7392888101295, -122.463226093964) 1 8 4 59 40
83163 115737 Significant Tree 6 Acer rubrum :: Red Maple 75 9x Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.27748 2097056.19499 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033) 1 8 4 59 40
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84826 174950 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 309 Crestlake Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987294 2096147 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564) 1 8 3 64 35
85339 115176 Significant Tree 6 Tree(s) :: 17 460 Pacheco St 1 Front Yard : Yard Tree Private 2   01/14/2016 12:00:00 AM   10x10 Permit Number 775764 5993727.4 2101897.6 37.7510499693469 -122.464553061226 (37.7510499693469, -122.464553061226) 1 8 4 29491 12
89112 106184 Significant Tree 6 Olea europaea :: Olive Tree 9 1327 ULLOA ST 1 Front Yard : Cutout Tree Private 2 FUF   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077) 1 8 4 59 40
89539 112250 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 243 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990059 2093141 37.7267944442094 -122.476598971146 (37.7267944442094, -122.476598971146) 1 8 4 64 14
90582 112375 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 1 Sidewalk: Curb side : Cutout Tree MTA 3     42     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
92153 117518 Significant Tree 6 Ulmus americana :: American Elm 74 30 Santa Paula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2016 12:00:00 AM 3   Permit Number 777803 5993995.8 2097679.6 37.7394838741894 -122.463318866351 (37.7394838741894, -122.463318866351) 1 8 4 59 40
92766 114034 Significant Tree 6 Ulmus pumila :: Siberian Elm 99 198x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   5990818 2089012 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302) 1 8 4 64 14
92919 115827 Significant Tree 6 Myoporum laetum :: Myoporum 62 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
93552 104749 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree Private 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
94784 253250 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Lopez Ave 1 Front Yard : Yard Tree Private 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
95436 104406 Significant Tree 6 Pinus radiata :: Monterey Pine 15 290 Stonecrest Dr 1 Back Yard : Yard Tree Private 2     36   Permit Number 770927 5990725 2092655 37.7254986161427 -122.474261202586 (37.7254986161427, -122.474261202586) 9 8 4 64 40
95967 254201 Significant Tree 6 Tree(s) :: 17 55X Aerial Way 1 Side Yard : Yard Tree Private 2       10x10 Permit Number 781191 5992360 2102538 37.7527294198072 -122.469328234463 (37.7527294198072, -122.469328234463) 1 8 4 56 12
96414 114394 Significant Tree 6 Ficus Spp. :: 101 134x TAPIA DR 1 Front Yard : Yard Tree Private 2     28     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
96682 115070 Significant Tree 6 :: 45 401 DARIEN WAY 1 Front Yard : Yard Tree Private 2     17     5992724 2094938 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465) 9 8 4 59 40
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
97746 111068 Significant Tree 6 Ilex spp :: Holly Species 81 1836 08TH AVE 1 Front Yard : Cutout Tree Private 2       3x15   5993799 2102987 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
98635 105649 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469) 1 8 4 64 14
98944 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 301X Sargent St 1 Front Yard : Cutout Tree Private 2       3x3   5993018 2089140 37.7159798527116 -122.466079257059 (37.7159798527116, -122.466079257059) 9 8 6 64 24
99362 99847 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850@14th Ave Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
99854 104898 Significant Tree 6 Myoporum laetum :: Myoporum 62 310 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
101005 104736 Significant Tree 6 Lagunaria patersonii :: Primrose Tree 6 1499X 44th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35
101827 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99X Everglade Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5986361 2095495 37.7330427310611 -122.489555709533 (37.7330427310611, -122.489555709533) 1 8 4 64 35
102553 253254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 270 Castenada Ave 1 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
103685 248958 Significant Tree 6 Pinus Spp :: Pine Spp 100 98x Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 3x3   5994824 2095658 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898) 9 8 4 59 40
104010 104913 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 608 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
105921 102569 Significant Tree 6 Olea europaea :: Olive Tree 9 0 Diaz Ave 1 Front Yard : Yard Tree Private 2   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.81974 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439) 1 8 4 64 14
107229 255805 Significant Tree 6 Ailanthus altissima :: Tree Of Heaven 333 2 Sola Ave 1 Front Yard : Yard Tree Private 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
107818 98757 Significant Tree 6 Pinus radiata :: Monterey Pine 15 340 Castenada Ave 1 Front Yard : Yard Tree Private 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
109420 114102 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 7 ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     18     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
110540 253952 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 11X Ravenwood Dr 1 Sidewalk: Curb side : Yard Tree Private 2       10x10   5994792 2096029 37.7349975719357 -122.460446404237 (37.7349975719357, -122.460446404237) 9 8 4 59 40
112272 105540 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE 1 Front Yard : Yard Tree Private 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
113390 104936 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 837 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
114772 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2211 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457) 1 8 3 29491 35
117265 116346 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 121 SAN BENITO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777164 5992901 2095856 37.7344135917102 -122.466971633047 (37.7344135917102, -122.466971633047) 9 8 4 59 40
117949 254767 Significant Tree 6 Pinus radiata :: Monterey Pine 15 900x Moraga St 1 Back Yard : Yard Tree Private 2       10x10   5991390 2103897 37.7564047756354 -122.47278171886 (37.7564047756354, -122.47278171886) 1 8 4 56 12
120116 116009 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 243 199x SAN BUENAVENTURA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 777954 5993547 2095667 37.7339319096844 -122.464724497297 (37.7339319096844, -122.464724497297) 9 8 4 59 40
120316 106363 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 URBANO DR 1 Front Yard : Yard Tree Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
123466 254110 Significant Tree 6 Tree(s) :: 17 100 Cerritos Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/04/2018 12:00:00 AM 3 10x10 Permit Number 781003 5992103 2092952 37.7263938396388 -122.469519230239 (37.7263938396388, -122.469519230239) 9 8 4 59 40
124365 116951 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 299 Tara St 1 Front Yard : Yard Tree Private 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
125330 104932 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 717 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
125509 254393 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 150 Granville Way 1 Front Yard : Yard Tree Private 2       10x10   5994538 2098550 37.7419049979895 -122.461507275162 (37.7419049979895, -122.461507275162) 1 8 4 59 40
125570 253265 Significant Tree 6 Juniperus chinensis :: Juniper 113 180 San Aleso Ave 1 Front Yard : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   5993319 2094440 37.7305497238902 -122.465423653439 (37.7305497238902, -122.465423653439) 9 8 4 59 40
126287 114225 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 99x FONT BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     48     5990948 2088640 37.7144873339183 -122.473197635313 (37.7144873339183, -122.473197635313) 1 8 4 64 14
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
127076 104193 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 122 Arch St 1 Front Yard : Yard Tree Private 2           5992720.4 2088013.1 37.7128684825751 -122.467026013031 (37.7128684825751, -122.467026013031) 9 8 6 64 24
127456 107197 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 339 Kirkham St 1 Front Yard : Cutout Tree Private 2   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.58741 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688) 1 8 4 56 12
127778 114100 Significant Tree 6 Betula pendula :: European White Birch 253 21x ACEVEDO AVE 1 Front Yard : Yard Tree Private 2     10     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
132771 112955 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 121X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2           5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
133714 111093 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100x FONT BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 50 3x3 Permit Number 775594 5990916 2088996 37.715462969911 -122.473334188491 (37.715462969911, -122.473334188491) 1 8 4 64 14
133744 117251 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 1 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
135904 116578 Significant Tree 6 Myoporum laetum :: Myoporum 62 2699x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree MTA 3 DPW   11 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
137836 208971 Significant Tree 6 Tree(s) :: 17 150 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   12/18/2018 12:00:00 AM 3 Width 6ft Permit Number 782070 5994318.90627 2096521.25566 37.7363219572757 -122.462117732164 (37.7363219572757, -122.462117732164) 9 8 4 59 40
138477 104934 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 805 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
139444 115733 Significant Tree 6 Acer rubrum :: Red Maple 75 50 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3   Permit Number 776548 5993693.2 2096969 37.7375153061033 -122.464313539267 (37.7375153061033, -122.464313539267) 1 8 4 59 40
141906 114383 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
142152 117309 Significant Tree 6 Tree(s) :: 17 3711 19th Ave 1 Back Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3 10x10 Permit Number 777997 5990297.3 2090806 37.7203969366505 -122.475604756889 (37.7203969366505, -122.475604756889) 1 8 4 64 14
145907 187657 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2072 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5991666 2101424 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446) 1 8 4 29491 12
146154 99098 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 66 Santa Monica Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768466 5993736.6 2097303.5 37.7384362612216 -122.464187762983 (37.7384362612216, -122.464187762983) 1 8 4 59 40
147278 100431 Significant Tree 6 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 200X Stonecrest Dr 1 Front Yard : Yard Tree Private 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
149016 114404 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 500X ARBALLO DR 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
149040 114068 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 8 HIGUERA AVE 1 Front Yard : Yard Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
149763 112290 Significant Tree 6 Acer rubrum :: Red Maple 75 34 YERBA BUENA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2016 12:00:00 AM 3 3x3 Permit Number 776546 5993584 2097045 37.7377176881769 -122.464696609393 (37.7377176881769, -122.464696609393) 1 8 4 59 40
150390 99101 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 55x Santa Monica Way 1 Median : Yard Tree Private 2   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.7393969918941 -122.464361897304 (37.7393969918941, -122.464361897304) 1 8 4 59 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)
);