Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179207 | 179207 | 200191 | Undocumented 2 | :: 54 | 981 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.39271586587799 | (37.7188778046353, -122.392715865878) | |||
| 147039 | 147039 | 200193 | Undocumented 2 | :: 54 | 975 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | |||
| 73420 | 73420 | 200232 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014491.3602 | 2089577.767 | 37.7183973497527 | -122.391887217647 | (37.7183973497527, -122.391887217647) | |||
| 177805 | 177805 | 200235 | Undocumented 2 | :: 54 | 923 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014534.9569 | 2089547.5847 | 37.7183168953073 | -122.39173441165 | (37.7183168953073, -122.39173441165) | |||
| 156135 | 156135 | 200237 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 919 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351002 | (37.7182212977035, -122.39160673351) | |||
| 137668 | 137668 | 200250 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6014641.601 | 2089467.7692 | 37.7181036570096 | -122.391360208379 | (37.7181036570096, -122.391360208379) | |||
| 165416 | 165416 | 200238 | Undocumented 2 | :: 54 | 917 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | |||
| 114979 | 114979 | 118322 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 720 BATTERY ST | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 6012486.0 | 2118560.0 | 37.7978646555778 | -122.400854041686 | (37.7978646555778, -122.400854041686) | |||||
| 89080 | 89080 | 106004 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 695X CAMPBELL AVE | unknown : Yard 19 | Tree 1 | Rec/Park 3 | 6009136.9 | 2088912.4 | 37.716271678506 | -122.41034847162202 | (37.716271678506, -122.410348471622) | ||||||
| 78014 | 78014 | 107210 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 603 PERALTA AVE | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.40860781001498 | (37.7431547125392, -122.408607810015) | ||||
| 117494 | 117494 | 107817 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 501X BROTHERHOOD WAY | unknown : Yard 19 | Tree 1 | DPW 2 | 5991892.0 | 2087849.0 | 37.712370053151204 | -122.469877266524 | (37.7123700531512, -122.469877266524) | ||||||
| 80300 | 80300 | 86765 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 89740 | 89740 | 86764 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 90997 | 90997 | 86768 | Permitted Site 1 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 105408 | 105408 | 86766 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 114230 | 114230 | 86759 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 117147 | 117147 | 86767 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 117606 | 117606 | 86758 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 117988 | 117988 | 86763 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 120349 | 120349 | 86760 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 123656 | 123656 | 86762 | Permitted Site 1 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||
| 125822 | 125822 | 86761 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 89237 | 89237 | 87112 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 116169 | 116169 | 87111 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 141981 | 141981 | 87114 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 143327 | 143327 | 87115 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) | ||||||
| 137300 | 137300 | 142638 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 BAY ST | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 6009068.3546 | 2121458.9525 | 37.8056332348144 | -122.41288516543301 | (37.8056332348144, -122.412885165433) | |||
| 137444 | 137444 | 142738 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 333 BAY ST | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 6009098.7568 | 2121462.5595 | 37.805644845194 | -122.412780209055 | (37.805644845194, -122.412780209055) | |||
| 55366 | 55366 | 200178 | Undocumented 2 | :: 54 | 3201 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | |||
| 1691 | 1691 | 251656 | Undocumented 2 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | 5999423.0 | 2096089.0 | 37.7354276387403 | -122.44443976141001 | (37.7354276387403, -122.44443976141) | ||||
| 105735 | 105735 | 105666 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 116266 | 116266 | 105664 | Undocumented 2 | Tree(s) :: 17 | 317X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 145561 | 145561 | 105665 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 78803 | 78803 | 105667 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | |||||
| 85276 | 85276 | 105668 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | ||||
| 24279 | 24279 | 138266 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2600 GEARY BLVD | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999024.6838 | 2113178.2607 | 37.7823277718518 | -122.44704630425699 | (37.7823277718518, -122.447046304257) | |||
| 33000 | 33000 | 138260 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | |||
| 35785 | 35785 | 138256 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5999357.6908 | 2113236.4692 | 37.7825066175753 | -122.44589843946899 | (37.7825066175753, -122.445898439469) | |||
| 53561 | 53561 | 138259 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999063.9407 | 2113176.2302 | 37.782324439437204 | -122.44691034713499 | (37.7823244394372, -122.446910347135) | |||
| 67056 | 67056 | 138263 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5999038.5591 | 2113167.7696 | 37.7822997587534 | -122.44699754685101 | (37.7822997587534, -122.446997546851) | |||
| 74158 | 74158 | 138257 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2600 GEARY BLVD | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5999359.7213 | 2113228.3471 | 37.7824844323354 | -122.445890830511 | (37.7824844323354, -122.445890830511) | |||
| 164558 | 164558 | 138264 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.44699593627199 | (37.7823276740968, -122.446995936272) | |||
| 131395 | 131395 | 183037 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2523 43rd Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5983009.062000001 | 2097931.9719 | 37.7395377337872 | -122.50132425344299 | (37.7395377337872, -122.501324253443) | |||
| 28544 | 28544 | 185496 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2400 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985141.6583 | 2098649.8553 | 37.7416338578085 | -122.49400366283501 | (37.7416338578085, -122.494003662835) | |||
| 29764 | 29764 | 185497 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 51 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985111.7766 | 2098651.8474 | 37.7416375791026 | -122.494107128969 | (37.7416375791026, -122.494107128969) | |||
| 30516 | 30516 | 185495 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985112.4406 | 2098617.3174 | 37.74154280788321 | -122.494102288748 | (37.7415428078832, -122.494102288748) | |||
| 34013 | 34013 | 185453 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985125.7214 | 2098256.744 | 37.740553547520705 | -122.494029800854 | (37.7405535475207, -122.494029800854) | |||
| 34066 | 34066 | 185473 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5985104.4721 | 2098432.7145 | 37.741035471775206 | -122.494116238038 | (37.7410354717752, -122.494116238038) | |||
| 34361 | 34361 | 185493 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5985113.7687 | 2098601.3804 | 37.741499126889295 | -122.49409652237499 | (37.7414991268893, -122.494096522375) | |||
| 35633 | 35633 | 185470 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985119.081 | 2098414.7854 | 37.7409870981235 | -122.49406440544399 | (37.7409870981235, -122.494064405444) | |||
| 37834 | 37834 | 185476 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985139.6662 | 2098449.3154 | 37.741083112699 | -122.49399577462098 | (37.741083112699, -122.493995774621) | |||
| 37856 | 37856 | 185490 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 43 | unknown : Yard 19 | Tree 1 | Private 1 | 18 | Width 0ft | 5985127.7135 | 2098570.8346 | 37.741416072315204 | -122.49404605602501 | (37.7414160723152, -122.494046056025) | |||
| 38441 | 38441 | 185474 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985113.1047 | 2098438.0268 | 37.7410505630538 | -122.494086781525 | (37.7410505630538, -122.494086781525) | |||
| 39945 | 39945 | 181359 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985110.4485 | 2098473.2209 | 37.741147041149 | -122.494098558838 | (37.741147041149, -122.494098558838) | |||
| 40115 | 40115 | 185505 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 59 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5985087.8712 | 2098781.9991 | 37.7419935417222 | -122.49419937536501 | (37.7419935417222, -122.494199375365) | |||
| 41710 | 41710 | 185491 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 44 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985120.4091 | 2098579.4672 | 37.7414393477039 | -122.494071947824 | (37.7414393477039, -122.494071947824) | |||
| 44552 | 44552 | 185455 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2400 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985131.0337 | 2098285.2977 | 37.7406322591341 | -122.494013537118 | (37.7406322591341, -122.494013537118) | |||
| 45810 | 45810 | 185494 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985136.346 | 2098616.6534 | 37.74154238350489 | -122.494019584309 | (37.7415423835049, -122.494019584309) | |||
| 45919 | 45919 | 185477 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985132.3618 | 2098455.9558 | 37.741100918055295 | -122.494021519499 | (37.7411009180553, -122.494021519499) | |||
| 48606 | 48606 | 185487 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985139.0022 | 2098533.6484 | 37.7413146295557 | -122.49400428423901 | (37.7413146295557, -122.494004284239) | |||
| 51500 | 51500 | 185486 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985131.6978 | 2098522.3598 | 37.7412832067047 | -122.494028708144 | (37.7412832067047, -122.494028708144) | |||
| 52764 | 52764 | 185481 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5985135.017999999 | 2098495.7982 | 37.741210469977105 | -122.49401527111799 | (37.7412104699771, -122.494015271118) | |||
| 55166 | 55166 | 185499 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 53 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985130.3697 | 2098685.0494 | 37.741729830798995 | -122.494045287668 | (37.741729830799, -122.494045287668) | |||
| 55634 | 55634 | 185460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.49404822844801 | (37.7408122581003, -122.494048228448) | |||
| 57323 | 57323 | 185506 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 60 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985096.5037 | 2098790.6317 | 37.7420177496615 | -122.494170163503 | (37.7420177496615, -122.494170163503) | |||
| 57892 | 57892 | 185452 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2400 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985111.1125 | 2098241.4711 | 37.7405107574318 | -122.49407918667299 | (37.7405107574318, -122.494079186673) | |||
| 59085 | 59085 | 185502 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 56 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | |||
| 61772 | 61772 | 185468 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985131.0337 | 2098396.1923 | 37.7409367458634 | -122.494021708019 | (37.7409367458634, -122.494021708019) | |||
| 64302 | 64302 | 181358 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985132.3618 | 2098384.2396 | 37.7409040046765 | -122.49401623531 | (37.7409040046765, -122.49401623531) | |||
| 64449 | 64449 | 185478 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2400 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985137.6741 | 2098467.2445 | 37.7411322246193 | -122.494003983523 | (37.7411322246193, -122.494003983523) | |||
| 65093 | 65093 | 185504 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 58 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.49410558184499 | (37.7420078978362, -122.494105581845) | |||
| 66692 | 66692 | 185457 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 13 | Width 0ft | 5985129.0416 | 2098307.8751 | 37.740694134038 | -122.494022088477 | (37.740694134038, -122.494022088477) | |||
| 67708 | 67708 | 185471 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.682 | 2098419.4337 | 37.7410008324731 | -122.494007348608 | (37.7410008324731, -122.494007348608) | |||
| 68374 | 68374 | 185458 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985125.7214 | 2098330.4524 | 37.7407559309555 | -122.49403523184401 | (37.7407559309555, -122.494035231844) | |||
| 70982 | 70982 | 185472 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985147.6347 | 2098429.3943 | 37.741028880966894 | -122.493966755049 | (37.7410288809669, -122.493966755049) | |||
| 76180 | 76180 | 185454 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985131.0337 | 2098272.681 | 37.7405976170701 | -122.494012607503 | (37.7405976170701, -122.494012607503) | |||
| 77313 | 77313 | 185489 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 42 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985101.1519 | 2098546.2652 | 37.7413470571288 | -122.494136085042 | (37.7413470571288, -122.494136085042) | |||
| 131653 | 131653 | 185498 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985102.48 | 2098665.7923 | 37.74167532404589 | -122.494140300571 | (37.7416753240459, -122.494140300571) | |||
| 132494 | 132494 | 185500 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2400 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985111.7766 | 2098706.9627 | 37.7417889108579 | -122.49411119019399 | (37.7417889108579, -122.494111190194) | |||
| 133868 | 133868 | 185475 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5985123.7293 | 2098442.675 | 37.7410639474436 | -122.494050388555 | (37.7410639474436, -122.494050388555) | |||
| 134120 | 134120 | 185507 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 61 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985116.4249 | 2098801.2563 | 37.7420480876484 | -122.494102066238 | (37.7420480876484, -122.494102066238) | |||
| 135953 | 135953 | 185480 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985125.7214 | 2098482.5174 | 37.7411734605092 | -122.49404643640601 | (37.7411734605092, -122.494046436406) | |||
| 137771 | 137771 | 181360 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985113.1047 | 2098629.2701 | 37.7415756656355 | -122.494100873291 | (37.7415756656355, -122.494100873291) | |||
| 157058 | 157058 | 185451 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985130.3697 | 2098228.1903 | 37.740475418723506 | -122.49401162519399 | (37.7404754187235, -122.494011625194) | |||
| 159555 | 159555 | 185466 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985111.7766 | 2098394.8642 | 37.740931972462796 | -122.494088193127 | (37.7409319724628, -122.494088193127) | |||
| 161360 | 161360 | 185461 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985111.1125 | 2098351.0376 | 37.7408115975576 | -122.494087259969 | (37.7408115975576, -122.494087259969) | |||
| 162935 | 162935 | 185479 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5985115.7608 | 2098477.2051 | 37.741158291534504 | -122.494080484656 | (37.7411582915345, -122.494080484656) | |||
| 163100 | 163100 | 185482 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 2400 Sunset Blvd | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985148.9628 | 2098503.7667 | 37.741233165261896 | -122.49396764279498 | (37.7412331652619, -122.493967642795) | |||
| 164141 | 164141 | 185483 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985132.3618 | 2098506.4228 | 37.741239486847206 | -122.494025238023 | (37.7412394868472, -122.494025238023) | |||
| 164196 | 164196 | 185484 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985117.0889 | 2098499.1184 | 37.741218537266796 | -122.494077507295 | (37.7412185372668, -122.494077507295) | |||
| 166847 | 166847 | 185467 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.740953890671896 | -122.49408648444799 | (37.7409538906719, -122.494086484448) | |||
| 171864 | 171864 | 185485 | Undocumented 2 | Tree(s) :: 17 | 2400 Sunset Blvd | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985115.7608 | 2098504.4307 | 37.741233045699296 | -122.49408249075898 | (37.7412330456993, -122.494082490759) | |||
| 172640 | 172640 | 185503 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 57 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985131.0337 | 2098785.3193 | 37.7420051837622 | -122.49405038008001 | (37.7420051837622, -122.49405038008) | |||
| 175132 | 175132 | 185488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 27 | Width 0ft | 5985122.4012 | 2098536.3046 | 37.741320951397704 | -122.494061879541 | (37.7413209513977, -122.494061879541) | |||
| 176577 | 176577 | 185492 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 45 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985138.3382 | 2098590.7558 | 37.7414713922408 | -122.494010787869 | (37.7414713922408, -122.494010787869) | |||
| 180431 | 180431 | 185459 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985114.4327 | 2098335.7647 | 37.7407698565631 | -122.494074654765 | (37.7407698565631, -122.494074654765) | |||
| 182172 | 182172 | 185464 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5985103.8081 | 2098378.9273 | 37.740887747752105 | -122.494114570537 | (37.7408877477521, -122.494114570537) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");