trees
1,011 rows where qLegalStatus_id = 2 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
14175 | 260509 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5995686 | 2095271 | 37.7329676771739 | -122.457300730651 | (37.7329676771739, -122.457300730651) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |
160778 | 215785 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Agua Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 775074 | 5997502.62133 | 2098608.67839 | 37.7422363073547 | -122.451260857411 | (37.7422363073547, -122.451260857411) | 9 | 7 | 4 | 59 | 40 | |
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 | ||||
137347 | 116851 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 3 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
164459 | 116850 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 83 Panorama Dr | 2 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
183437 | 116849 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 83 Panorama Dr | 1 | Front Yard : Yard | Tree | Private 2 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | 1 | 5 | 4 | 59 | 38 | |||
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 | |
39006 | 253854 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650 Joost Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 10x9 | Permit Number 776163 | 5997782.66631 | 2095011.71334 | 37.7323759368037 | -122.450033362597 | (37.7323759368037, -122.450033362597) | 9 | 7 | 4 | 59 | 40 | |
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 | ||||
18618 | 170106 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 6x10 | Permit Number 783167 | 5997920.28587 | 2095246.22061 | 37.7330277118397 | -122.449574473879 | (37.7330277118397, -122.449574473879) | 9 | 7 | 4 | 59 | 40 | |
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 | ||
17886 | 261591 | Planning Code 138.1 required 2 | :: 45 | 1747 Cayuga Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/28/2020 12:00:00 AM | 3 | Permit Number 784552 | 5998049.81023 | 2088594.07996 | 37.7147698965646 | -122.44864773571 | (37.7147698965646, -122.44864773571) | 9 | 7 | 6 | 28861 | 25 | ||
16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
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 | ||
53406 | 256184 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 412 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 10x3 | Permit Number 770911 | 5998674.66662 | 2094402.01563 | 37.7307528521501 | -122.446905665072 | (37.7307528521501, -122.446905665072) | 9 | 7 | 4 | 59 | 40 | |
8622 | 256682 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 8 | Front Yard : Yard | 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 | ||
19663 | 256686 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 11 | Back Yard : Yard | 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 | ||
23587 | 256680 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 6 | Front Yard : Yard | 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 | ||
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 | ||
75229 | 256683 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 1 | Back Yard : Yard | 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 | ||
78128 | 256675 | Planning Code 138.1 required 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 330 Twin Peaks Blvd | 3 | Side Yard : 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 | ||
127405 | 256685 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 10 | Back Yard : Yard | 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 | ||
130529 | 256674 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 2 | Side Yard : 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 | ||
158426 | 256673 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 1 | Side Yard : 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 | ||
176698 | 256681 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 330 Twin Peaks Blvd | 7 | Front Yard : Yard | 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 | ||
185964 | 256684 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 9 | Back Yard : Yard | 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 | ||
32624 | 258085 | Planning Code 138.1 required 2 | Cornus florida :: Eastern Dogwood 385 | 330 Twin Peaks Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/27/2019 12:00:00 AM | 3 | 10x10 | 5998725.10706 | 2103975.38052 | 37.7570418811558 | -122.447420092492 | (37.7570418811558, -122.447420092492) | 15 | 5 | 4 | 63 | 38 | ||
110069 | 116528 | Planning Code 138.1 required 2 | :: 45 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | 3x3 | 5998841 | 2104182 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | 2 | 5 | 5 | 28862 | 3 | |||
1810 | 253859 | Planning Code 138.1 required 2 | Prunus spp :: Cherry 68 | 130 Graystone Ter | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | Permit Number 780749 | 5998952.88335 | 2104176.47413 | 37.7576070480405 | -122.446646826709 | (37.7576070480405, -122.446646826709) | 2 | 5 | 5 | 28862 | 3 | |||
5670 | 253203 | Planning Code 138.1 required 2 | Acer buergeranum :: Trident Maple 110 | 349 Mangels Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5999103 | 2095207 | 37.732987611392 | -122.445482716078 | (37.732987611392, -122.445482716078) | 9 | 7 | 4 | 59 | 40 | ||
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 | |
15827 | 262585 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
158236 | 116267 | Planning Code 138.1 required 2 | Acer japonicum :: Japanese Maple 124 | 717 PARIS ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001138 | 2089523 | 37.7174966063475 | -122.438040195581 | (37.7174966063475, -122.438040195581) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );