trees
142 rows where Zip Codes = 59 and qLegalStatus_id = 6 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189375 | 100473 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
139989 | 100474 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 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 | |||
154657 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
157181 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | 1 | 8 | 4 | 59 | 40 | |||||
78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
154838 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 760 Victoria St | 5 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
164851 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1365 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | ||||
15671 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 105 | 2 Allston Way | 1 | Back Yard : Yard | Tree | Private 2 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | 1 | 8 | 4 | 59 | 40 | |||||
169388 | 104432 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1601X PORTOLA DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
33433 | 104433 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
35139 | 104434 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
146533 | 104435 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 4 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||
76095 | 106244 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 735 MANGELS AVE | 1 | Front Yard : Yard | Tree | Private 2 | 06/02/2014 12:00:00 AM | 14 | Permit Number 772876 | 5996640.8 | 2095225.8 | 37.7328983615352 | -122.453996493912 | (37.7328983615352, -122.453996493912) | 9 | 7 | 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 | ||||
28198 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 155 BORICA ST | 1 | Front Yard : Yard | Tree | Private 2 | 5992696 | 2092292.5 | 37.7246172684066 | -122.467421338179 | (37.7246172684066, -122.467421338179) | 9 | 8 | 4 | 59 | 40 | |||||
81747 | 107245 | Significant Tree 6 | Tree(s) :: 17 | 140 CEDRO AVE | Front Yard : Yard | Tree | Private 2 | 5991993.7 | 2093259.3 | 37.7272312918526 | -122.469919436342 | (37.7272312918526, -122.469919436342) | 9 | 8 | 4 | 59 | 40 | ||||||
24927 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 276 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5995080.66446 | 2095640.15746 | 37.7339465073544 | -122.459420244296 | (37.7339465073544, -122.459420244296) | 9 | 8 | 4 | 59 | 40 | ||||
139381 | 109706 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 96 CRESTA VISTA DR | Back Yard : Cutout | Tree | Private 2 | 5995602.1 | 2096103.5 | 37.7352487002973 | -122.457651008037 | (37.7352487002973, -122.457651008037) | 9 | 7 | 4 | 59 | 40 | ||||||
128997 | 109708 | Significant Tree 6 | Tree(s) :: 17 | 621 Laguna Honda Blvd | 3 | Front Yard : Cutout | Tree | Private 2 | FUF | 07/29/2015 12:00:00 AM | Permit Number 774799 | 5995723.9 | 2099907.4 | 37.7457002690083 | -122.457505029341 | (37.7457002690083, -122.457505029341) | 1 | 5 | 4 | 59 | 40 | ||
101112 | 110321 | Significant Tree 6 | Ilex opaca :: American Holly 473 | 1x SAN PABLO AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774750 | 5994773 | 2097898 | 37.740128291439 | -122.460647489756 | (37.740128291439, -122.460647489756) | 9 | 8 | 4 | 59 | 40 | ||
160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
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 | |
173122 | 112354 | Significant Tree 6 | Tree(s) :: 17 | 300 Moncada Way | 1 | Front Yard : Yard | Tree | Private 2 | 01/04/2016 12:00:00 AM | 10x10 | Permit Number 775546 | 5992209.2 | 2093928.1 | 37.729080105492 | -122.469223117768 | (37.729080105492, -122.469223117768) | 9 | 8 | 4 | 59 | 40 | ||
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 | ||||
124516 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 24 | 5993401 | 2098089 | 37.7405736985828 | -122.465405140197 | (37.7405736985828, -122.465405140197) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |||||
47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
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 | ||||
104794 | 115276 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 598X PORTOLA DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997411 | 2099824 | 37.7455680371271 | -122.451665301061 | (37.7455680371271, -122.451665301061) | 1 | 7 | 4 | 59 | 40 | ||||
36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 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 | |||
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 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 | ||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 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 | ||
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 | ||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
188246 | 115749 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
179237 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
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 | |
47809 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | ||||
194175 | 116308 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 699X DETROIT ST | 9 | Back Yard : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
185127 | 116345 | Significant Tree 6 | Tree(s) :: 17 | 85x SANTA CLARA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777165 | 5993361 | 2096925 | 37.7373753392635 | -122.465458906558 | (37.7373753392635, -122.465458906558) | 1 | 8 | 4 | 59 | 40 | |
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 | |
180538 | 116957 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 10x Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||||
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
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 | ||||
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 | ||
187303 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 8 Keystone Way | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 5994105 | 2092664 | 37.7257185609933 | -122.46257757783 | (37.7257185609933, -122.46257757783) | 9 | 8 | 4 | 59 | 40 | |||
134725 | 187654 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 375 Woodside Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5997267 | 2099886 | 37.7457300260474 | -122.452167701039 | (37.7457300260474, -122.452167701039) | 1 | 5 | 4 | 59 | 38 | ||||
891 | 207770 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 40 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | Width 10ft | 5993240.61068 | 2097284.1687 | 37.7383545825079 | -122.465901234858 | (37.7383545825079, -122.465901234858) | 1 | 8 | 4 | 59 | 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 | |||
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 | |
46153 | 209002 | Significant Tree 6 | Tree(s) :: 17 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781950 | 5994125 | 2096751 | 37.7369416119865 | -122.462804803775 | (37.7369416119865, -122.462804803775) | 9 | 8 | 4 | 59 | 40 | |
193743 | 211099 | Significant Tree 6 | Tree(s) :: 17 | 501 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/18/2018 12:00:00 AM | 3 | 10x10 | Permit Number 781418 | 5993137.63738 | 2096084.35497 | 37.7350542531473 | -122.466170096172 | (37.7350542531473, -122.466170096172) | 1 | 8 | 4 | 59 | 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 | ||
192391 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | DPW | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | |
144728 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 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 | ||
171749 | 253384 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 55 Cerritos Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5992588 | 2092941 | 37.7263916542788 | -122.46784182224 | (37.7263916542788, -122.46784182224) | 9 | 8 | 4 | 59 | 40 | ||||
34696 | 253950 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 431 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | ||||
130286 | 253951 | Significant Tree 6 | Tree(s) :: 17 | 431 Yerba Buena Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 01/17/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780852 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | |
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 | ||||
21096 | 253953 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 11X Ravenwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x10 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | ||||
10088 | 253978 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 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 | |
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 | ||||
128499 | 255151 | Significant Tree 6 | Araucaria bidwillii :: Bunya Bunya 551 | 201 Vicente St | 4 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 5992494.60347 | 2097875.96956 | 37.7399364549038 | -122.468523586018 | (37.7399364549038, -122.468523586018) | 1 | 8 | 4 | 59 | 40 | ||||
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 | |
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 | |
12152 | 255704 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 201X Hernandez Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995122 | 2099706 | 37.7451126829106 | -122.459571712369 | (37.7451126829106, -122.459571712369) | 1 | 8 | 4 | 59 | 40 | ||||
146280 | 255793 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | Permit Number 782172 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | |||
34088 | 256489 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2198X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | ||||
72983 | 256490 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 2198X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | ||||
54695 | 256491 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2198X Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | ||||
143508 | 256539 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
104704 | 256850 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 206 | 100 Brentwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6x6 | 5995843 | 2095739 | 37.7342617075966 | -122.456791779994 | (37.7342617075966, -122.456791779994) | 9 | 7 | 4 | 59 | 40 | ||||
102524 | 258404 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
16652 | 258405 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 15 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
12033 | 259149 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 150 Lenox Way | 1 | Front Yard : Yard | Tree | Private 2 | 5x5 | 5993309.4847 | 2098463.34097 | 37.7415962663129 | -122.465748753199 | (37.7415962663129, -122.465748753199) | 1 | 8 | 4 | 59 | 40 | ||||
17188 | 260389 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x6 | 5993303.46118 | 2096918.61416 | 37.7373544866644 | -122.465657379584 | (37.7373544866644, -122.465657379584) | 1 | 8 | 4 | 59 | 40 | ||||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
797 | 260459 | Significant Tree 6 | Tree(s) :: 17 | 1798X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 5x10 | Permit Number 784470 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | |
15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
13149 | 260567 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 131 Edgehill Way | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994866 | 2098973 | 37.743085324311 | -122.460403807929 | (37.743085324311, -122.460403807929) | 1 | 8 | 4 | 59 | 40 |
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) );