trees

844 rows where qLegalStatus_id = 2 and qSiteInfo = "Sidewalk: Curb side : Cutout" sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Curb side : Cutout · 744 ✖
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)
11989 261017 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 79 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 774761 5992858 2101375 37.749564886931 -122.467521508976 (37.749564886931, -122.467521508976) 1 8 4 29491 12
4685 163919 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 528 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/2020 12:00:00 AM 3 4x4 Permit Number 785290 5993187.06549 2105302.66577 37.7603682343238 -122.466669061634 (37.7603682343238, -122.466669061634) 1 8 4 56 12
43838 253762 Planning Code 138.1 required 2 :: 45 520 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993490 2111935 37.7785963431655 -122.466103329181 (37.7785963431655, -122.466103329181) 11 6 2 54 11
81759 256725 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 432 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2018 12:00:00 AM 3 3x3 Permit Number 781907 5993569.91313 2105305.27634 37.7603974888061 -122.465345170025 (37.7603974888061, -122.465345170025) 1 8 11 56 12
25596 117510 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 23x BRIGHT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2016 12:00:00 AM 3 3x3   5993679 2087403 37.7112485771375 -122.463668552658 (37.7112485771375, -122.463668552658) 9 8 4 64 24
20111 1217 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3501 Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2016 12:00:00 AM 3 3x3   5993695.72185 2087421.09824 37.7112992341463 -122.463612070865 (37.7112992341463, -122.463612070865) 9 8 4 64 24
164050 114792 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
186896 114793 Planning Code 138.1 required 2 Tree(s) :: 17 10 Linares Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x10 Permit Number 777094 5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
32475 255482 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1559 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2018 12:00:00 AM 3 3x5   5993958 2104895 37.7592933500003 -122.463973185629 (37.7592933500003, -122.463973185629) 1 8 4 56 12
5422 122567 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 241 Flournoy St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 3x3 Permit Number 777809 5994026.14526 2086558.74537 37.7089504501359 -122.46240754496 (37.7089504501359, -122.46240754496) 9 8 6 28861 25
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19183 261351 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
167690 256776 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 244 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 781951 5994190.23703 2091515.08881 37.7225688371899 -122.462199635944 (37.7225688371899, -122.462199635944) 9 8 4 28861 24
45409 114908 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 281 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994225 2088676 37.714775380269 -122.461873702271 (37.714775380269, -122.461873702271) 9 8 6 28861 24
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
89164 67994 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 241 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 776577 5994615.10957021 2088996.30431809 37.7156773106674 -122.460548527933 (37.7156773106674, -122.460548527933) 9 8 6 28861 24
49019 113699 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 239 Minerva St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778180 5994635.15348587 2088996.04011087 37.7156777383317 -122.460479228374 (37.7156777383317, -122.460479228374) 9 8 6 28861 24
46091 98406 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 237 Minerva St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 778181 5994692.2 2088928.8 37.7154963945459 -122.460277182084 (37.7154963945459, -122.460277182084) 9 8 6 28861 24
37845 256671 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 423 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2019 12:00:00 AM 3 3x3 Permit Number 781122 5994719 2091406 37.7222997368586 -122.460363933092 (37.7222997368586, -122.460363933092) 9 8 4 28861 24
24860 121465 Planning Code 138.1 required 2 Tree(s) :: 17 218 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778899 5994755.06729 2090055.4837 37.7185936165551 -122.460141464151 (37.7185936165551, -122.460141464151) 9 8 6 28861 24
58189 121145 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 962 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2016 12:00:00 AM 3 3x3   5995080 2090346 37.7194099895512 -122.459039336024 (37.7194099895512, -122.459039336024) 9 8 6 28861 24
36980 105047 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 278 Capitol Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392) 9 8 6 28861 24
8349 163331 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 159 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/15/2019 12:00:00 AM 3 3x3 Permit Number 780897 5995371.93865 2087733.0149 37.7122521261194 -122.45784123641 (37.7122521261194, -122.45784123641) 9 8 6 28861 24
119324 253343 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
184490 253342 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
61488 254585 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1236 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995818 2107128 37.7655316119834 -122.457702020035 (37.7655316119834, -122.457702020035) 15 5 11 29492 12
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
176912 255710 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 70 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996728 2112568 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336) 11 6 2 54 16
16304 162975 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 131 Harold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   5996790.92866 2090757.22233 37.72063731584 -122.453154991525 (37.72063731584, -122.453154991525) 9 8 6 28861 24
58719 121093 Planning Code 138.1 required 2 Tree(s) :: 17 150 Ridgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778915 5996816.77701 2094570.70089 37.7311097051787 -122.453340820219 (37.7311097051787, -122.453340820219) 9 7 4 59 40
79775 251140 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 138 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996904.98449 2113495.29925 37.783076941712 -122.454402393245 (37.783076941712, -122.454402393245) 11 6 1 54 31
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
131750 39246 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3524 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM 1   Permit Number 772836 5997390.1418 2116079.35829 37.7901998932662 -122.452910535096 (37.7901998932662, -122.452910535096) 11 6 1 54 31
57156 254766 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 79 Caine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 776608 5997440.77634 2089380.40278 37.7168941131095 -122.450809461106 (37.7168941131095, -122.450809461106) 9 8 6 28861 24
62051 254764 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 77 Caine Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2018 12:00:00 AM 3 3x3 Permit Number 776607 5997448.21567 2089391.00345 37.7169236459528 -122.450784510991 (37.7169236459528, -122.450784510991) 9 8 6 28861 24
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
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
46287 164504 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1241 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2018 12:00:00 AM 3 4x4 Permit Number 775664 5997725 2106255 37.7632439412228 -122.451043208712 (37.7632439412228, -122.451043208712) 15 5 11 29492 9
60238 252840 Planning Code 138.1 required 2 Tree(s) :: 17 80 Blake St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997842 2113206 37.782336294689 -122.451139847811 (37.782336294689, -122.451139847811) 15 6 1 54 31
142552 120109 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 555 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2016 12:00:00 AM 3 3x3   5997970 2087042 37.7105036758619 -122.448811863159 (37.7105036758619, -122.448811863159) 9 7 6 28861 25
67632 159354 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 417x Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998501.29354 2087549.7908 37.7119283225022 -122.447012123728 (37.7119283225022, -122.447012123728) 9 7 6 28861 25
14035 159355 Planning Code 138.1 required 2 Melaleuca quinquenervia :: Cajeput 10 417 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998509.88268 2087558.19074 37.7119518775514 -122.44698304145 (37.7119518775514, -122.44698304145) 9 7 6 28861 25
27220 159357 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 Naglee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998577.13551 2087591.01668 37.7120458522191 -122.446752958004 (37.7120458522191, -122.446752958004) 9 7 6 28861 25
113669 159358 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 49 Naglee Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 776198 5998584.62871 2087583.88571 37.712026700246 -122.446726546692 (37.712026700246, -122.446726546692) 9 7 6 28861 25
159609 102525 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 310 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2013 12:00:00 AM 0 3x3 Permit Number 769739 5998596.99117 2115413.44206 37.7884405486385 -122.448686963531 (37.7884405486385, -122.448686963531) 13 6 1 54 31
47145 95203 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 314 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3 Permit Number 769992 5998598.63338 2115400.15976 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474) 13 6 1 54 31
28167 256679 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
75947 256676 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
123272 256677 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
161826 256678 Planning Code 138.1 required 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 330 Twin Peaks Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2019 12:00:00 AM 3 3x3   5998688 2103995 37.7570936308358 -122.447549834506 (37.7570936308358, -122.447549834506) 15 5 4 63 38
175587 68987 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 767 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 3 10x10 Permit Number 775182 5999291.63198947 2121477.34728573 37.8051301110493 -122.44672010757 (37.8051301110493, -122.44672010757) 13 9 1 57 17
40028 57959 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 336 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288) 9 7 6 28861 5
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
60006 257929 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 255 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 3x3 Permit Number 781730 5999620.44198 2090680.5387 37.7205885233371 -122.443368776907 (37.7205885233371, -122.443368776907) 9 7 6 28861 25
134738 115357 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 270 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2016 12:00:00 AM 3 3x6   5999894.51999 2091641.88128 37.7232437759734 -122.442490363056 (37.7232437759734, -122.442490363056) 9 7 6 28861 25
157324 32045 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2979 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3   Permit Number 781325 5999951.23823 2116389.65594 37.7911983214916 -122.444071670681 (37.7911983214916, -122.444071670681) 13 6 1 29490 27
16386 262532 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 815 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2020 12:00:00 AM 3 4x4 Permit Number 781917 5999987.51846 2111668.14853 37.7782363548085 -122.443606817465 (37.7782363548085, -122.443606817465) 15 5 11 29490 16
36929 256611 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
78803 256612 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2375 Ofarrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
99613 256169 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
102847 256610 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
118314 120115 Planning Code 138.1 required 2 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2225 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6000127.23839 2120216.52423 37.8017159270068 -122.443737765003 (37.8017159270068, -122.443737765003) 13 9 1 57 17
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
13240 157603 Planning Code 138.1 required 2 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 16 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 5x5 Permit Number 784681 6000322.25182 2101567.57465 37.7505217703771 -122.441723777343 (37.7505217703771, -122.441723777343) 2 4 5 28862 22
184280 63407 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2125 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3x3 Permit Number 770314 6000344.0086 2116075.34024 37.7903576909945 -122.442690122255 (37.7903576909945, -122.442690122255) 13 6 1 29490 27
4259 33111 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2626 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2020 12:00:00 AM 3 4x4 Permit Number 769981 6000363.34088 2118561.77591 37.7971858916671 -122.442801853125 (37.7971858916671, -122.442801853125) 13 9 1 57 17
15497 33110 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2626 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2020 12:00:00 AM 3   Permit Number 769981 6000381.41365 2118563.70291 37.7971922129921 -122.442739455458 (37.7971922129921, -122.442739455458) 13 9 1 57 17
4743 167761 Planning Code 138.1 required 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 451 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 4x4 Permit Number 780770 6000439.87639 2107208.3352 37.7660166188918 -122.441721798828 (37.7660166188918, -122.441721798828) 15 5 5 29492 3
127597 103379 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2712 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2013 12:00:00 AM 4 3x3 Permit Number 770136 6000520 2117210 37.7934832007909 -122.44216269001 (37.7934832007909, -122.44216269001) 13 9 1 57 27
55452 35488 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094) 15 6 1 29490 27
13014 167662 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 24 Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2017 12:00:00 AM 3 3x6   6000818.42136 2106216.38176 37.7633145212709 -122.440341345773 (37.7633145212709, -122.440341345773) 15 5 5 28862 3
982 104688 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
81956 122427 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
99982 122422 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
113221 122425 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
136423 122426 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 8 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
159819 122424 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
172560 122428 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 10 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
177350 122423 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
86670 146397 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3318 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 Width 4ft Permit Number 780850 6000857.39871 2119780.85133 37.8005613036105 -122.441179804419 (37.8005613036105, -122.441179804419) 13 9 1 57 17
162627 35487 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557) 15 6 1 29490 27
84809 167131 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 4540 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/2018 12:00:00 AM 3 3x3 Permit Number 780648 6000902.50099 2104660.33643 37.7590467894041 -122.439938965707 (37.7590467894041, -122.439938965707) 2 4 5 28862 3
161064 114972 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1431 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3x3 Permit Number 777191 6000962.5 2110659.8 37.7755232425188 -122.440161680014 (37.7755232425188, -122.440161680014) 15 5 11 29492 10
19030 221366 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 55 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2019 12:00:00 AM 3 3x3 Permit Number 778991 6000992.93047 2101385.53728 37.7500601303816 -122.439391477336 (37.7500601303816, -122.439391477336) 2 4 5 28862 22
45743 161753 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 175x Newton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 4x4 Permit Number 780462 6001022 2087749 37.7126190008501 -122.43831413288 (37.7126190008501, -122.43831413288) 9 7 6 28861 5
119152 5313 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 1785 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3X3 Permit Number 770253 6001045 2114480 37.786017234839 -122.440150297316 (37.786017234839, -122.440150297316) 15 6 1 29490 27
91584 157471 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 844 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2018 12:00:00 AM 3 3x3   6001109 2099712 37.7454716006778 -122.438870189158 (37.7454716006778, -122.438870189158) 2 4 5 63 22
49446 257939 Planning Code 138.1 required 2 Tree(s) :: 17 65 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2019 12:00:00 AM 3 3x3 Permit Number 779175 6001128.17111 2108817.40029 37.7704739053605 -122.439456486198 (37.7704739053605, -122.439456486198) 15 5 11 29492 9
161200 257940 Planning Code 138.1 required 2 Tree(s) :: 17 65 Buena Vista Ave East 2 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2019 12:00:00 AM 3 3x3 Permit Number 779175 6001128.17111 2108817.40029 37.7704739053605 -122.439456486198 (37.7704739053605, -122.439456486198) 15 5 11 29492 9
148677 121464 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2353 Lombard St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001140 2119261 37.7991500226194 -122.440164592168 (37.7991500226194, -122.440164592168) 13 9 1 57 17

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