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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 94096 | 94096 | 100243 | Private 5 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard 19 | Tree 1 | Private 1 | 6008043.0 | 2100485.0 | 37.7479861507453 | -122.41494814206699 | (37.7479861507453, -122.414948142067) | ||||||
| 126465 | 126465 | 101951 | Property Tree 7 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard 19 | Tree 1 | Private 1 | 6003106.0 | 2094969.0 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | ||||||
| 49960 | 49960 | 105135 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 175X ESMERALDA AVE | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 26 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 128729 | 128729 | 105136 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175X ESMERALDA AVE | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | |||||
| 109114 | 109114 | 105137 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 3 | unknown : Yard 19 | Tree 1 | DPW 2 | 18 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 143716 | 143716 | 105138 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 139638 | 139638 | 105139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 98700 | 98700 | 105140 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 125X ESMERALDA AVE | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 12 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 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) | ||||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||||
| 111345 | 111345 | 114949 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 30 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | |||
| 85853 | 85853 | 114950 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | ||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 24212 | 24212 | 181351 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 32 | Width 0ft | 5985090.6387 | 2098949.4558 | 37.7424534945744 | -122.49420214621 | (37.7424534945744, -122.49420214621) | |||
| 149629 | 149629 | 181352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985091.6384 | 2099018.9366 | 37.7426443285892 | -122.494203809651 | (37.7426443285892, -122.494203809651) | |||
| 60510 | 60510 | 181353 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 34 | Width 0ft | 5985103.1353 | 2099041.4304 | 37.7427067632535 | -122.49416571483 | (37.7427067632535, -122.49416571483) | |||
| 178149 | 178149 | 181354 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985076.1427 | 2099074.9211 | 37.742797140118796 | -122.494261514147 | (37.7427971401188, -122.494261514147) | |||
| 182857 | 182857 | 181357 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985137.6741 | 2098360.3342 | 37.740838677714294 | -122.49399610623999 | (37.7408386777143, -122.49399610624) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 160873 | 160873 | 185390 | Undocumented 2 | Araucaria araucana :: Monkey puzzle 154 | 2300 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985092.6382 | 2098924.4627 | 37.742384987274704 | -122.49419339090001 | (37.7423849872747, -122.4941933909) | |||
| 152791 | 152791 | 185391 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985125.1292 | 2098935.9595 | 37.7424184556167 | -122.49408189561899 | (37.7424184556167, -122.494081895619) | |||
| 185674 | 185674 | 185392 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985108.1339 | 2098944.4572 | 37.7424407935289 | -122.494141285581 | (37.7424407935289, -122.494141285581) | |||
| 183931 | 183931 | 185393 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5985089.6389999995 | 2098965.9512 | 37.742498727988895 | -122.49420681837499 | (37.7424987279889, -122.494206818375) | |||
| 35616 | 35616 | 185394 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2300 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985078.642000001 | 2098945.9568 | 37.7424431852403 | -122.494243368761 | (37.7424431852403, -122.494243368761) | |||
| 53924 | 53924 | 185395 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2300 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985077.1425 | 2098975.4486 | 37.7425240740104 | -122.494250726815 | (37.7425240740104, -122.494250726815) | |||
| 181170 | 181170 | 185396 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985088.1394 | 2098992.4439 | 37.742571382036 | -122.49421395573499 | (37.742571382036, -122.494213955735) | |||
| 53840 | 53840 | 185397 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985126.1289 | 2099011.9385 | 37.742627131937 | -122.49408403757799 | (37.742627131937, -122.494084037578) | |||
| 26814 | 26814 | 185398 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985116.1317 | 2099019.9363 | 37.7426485067542 | -122.49411919382099 | (37.7426485067542, -122.494119193821) | |||
| 159653 | 159653 | 185399 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985110.1333 | 2099026.9344 | 37.7426673706481 | -122.49414044992399 | (37.7426673706481, -122.494140449924) | |||
| 76866 | 76866 | 185401 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | |||
| 152435 | 152435 | 185402 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.742712196982495 | -122.494088049359 | (37.7427121969825, -122.494088049359) | |||
| 131257 | 131257 | 185403 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985110.6332 | 2099073.9214 | 37.742796413512 | -122.49414218382499 | (37.742796413512, -122.494142183825) | |||
| 167557 | 167557 | 185404 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985080.6415 | 2099060.4251 | 37.7427576012847 | -122.494244890555 | (37.7427576012847, -122.494244890555) | |||
| 38464 | 38464 | 185405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5985107.634 | 2099090.4168 | 37.7428415299236 | -122.494153769583 | (37.7428415299236, -122.494153769583) | |||
| 137933 | 137933 | 185406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.742876046964604 | -122.494142591708 | (37.7428760469646, -122.494142591708) | |||
| 46337 | 46337 | 185407 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985075.6429 | 2099093.4159999997 | 37.742847892869 | -122.49426460522899 | (37.742847892869, -122.494264605229) | |||
| 73057 | 73057 | 185408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985102.6354 | 2099127.4066 | 37.742942801420796 | -122.49417377884599 | (37.7429428014208, -122.494173778846) | |||
| 149365 | 149365 | 185409 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985081.6412 | 2099150.9001 | 37.7430060796886 | -122.494248101225 | (37.7430060796886, -122.494248101225) | |||
| 170252 | 170252 | 185410 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2300 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985099.6362 | 2099155.3989 | 37.7430194852088 | -122.494186211855 | (37.7430194852088, -122.494186211855) | |||
| 162943 | 162943 | 185411 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5985100.1361 | 2099184.3909 | 37.7430991186582 | -122.49418661978599 | (37.7430991186582, -122.494186619786) | |||
| 162312 | 162312 | 185412 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985078.1422 | 2099185.3906 | 37.7431005765205 | -122.494262741341 | (37.7431005765205, -122.494262741341) | |||
| 33040 | 33040 | 185413 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2300 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985092.6382 | 2099208.8841 | 37.7431659316065 | -122.49421435006501 | (37.7431659316065, -122.494214350065) | |||
| 62482 | 62482 | 185414 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985079.1419 | 2099209.8838 | 37.743167886728 | -122.494261089675 | (37.743167886728, -122.494261089675) | |||
| 57913 | 57913 | 185415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985091.6384 | 2099216.8819 | 37.743187832897 | -122.494218396427 | (37.743187832897, -122.494218396427) | |||
| 38172 | 38172 | 185416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5985081.6412 | 2099232.3776 | 37.743229794878296 | -122.49425410551599 | (37.7432297948783, -122.494254105516) | |||
| 53374 | 53374 | 185417 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | Width 0ft | 5985081.6412 | 2099246.8736 | 37.7432695969748 | -122.49425517376801 | (37.7432695969748, -122.494255173768) | |||
| 60508 | 60508 | 185418 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985092.1383 | 2099264.8686 | 37.7433196206545 | -122.494220204145 | (37.7433196206545, -122.494220204145) | |||
| 179741 | 179741 | 185419 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985098.1367 | 2099271.3668 | 37.7433378139676 | -122.49419994238899 | (37.7433378139676, -122.494199942389) | |||
| 174524 | 174524 | 185420 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985096.6371 | 2099279.3646 | 37.7433596860109 | -122.494205716911 | (37.7433596860109, -122.494205716911) | |||
| 177017 | 177017 | 185421 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985094.1378 | 2099288.8619999997 | 37.7433856170495 | -122.494215058601 | (37.7433856170495, -122.494215058601) | |||
| 187450 | 187450 | 185422 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985084.6404 | 2099285.363 | 37.7433754539691 | -122.494247639854 | (37.7433754539691, -122.494247639854) | |||
| 60439 | 60439 | 185423 | Undocumented 2 | Araucaria heterophylla :: Norfolk Island Pine 24 | 2300 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985071.643999999 | 2099284.3632 | 37.7433719482454 | -122.494292503743 | (37.7433719482454, -122.494292503743) | |||
| 147893 | 147893 | 185424 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2300 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985084.6404 | 2099301.8584 | 37.7434207458763 | -122.49424885544599 | (37.7434207458763, -122.494248855446) | |||
| 132393 | 132393 | 185426 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 42 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985086.6398 | 2099317.3541 | 37.7434634098799 | -122.49424308404801 | (37.7434634098799, -122.494243084048) | |||
| 179607 | 179607 | 185430 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985106.6343 | 2099374.8382 | 37.7436224157034 | -122.49417818512899 | (37.7436224157034, -122.494178185129) | |||
| 25247 | 25247 | 185431 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 40 | Width 0ft | 5985098.6365 | 2099386.335 | 37.743653514796705 | -122.49420668637899 | (37.7436535147967, -122.494206686379) | |||
| 181515 | 181515 | 185432 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985081.6412 | 2099386.335 | 37.7436525202566 | -122.49426545113899 | (37.7436525202566, -122.494265451139) | |||
| 134264 | 134264 | 185433 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 49 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985073.6434 | 2099396.3323 | 37.7436795021074 | -122.49429384193199 | (37.7436795021074, -122.494293841932) | |||
| 57083 | 57083 | 185434 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2300 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 20 | Width 0ft | 5985080.6415 | 2099410.3284 | 37.7437183411386 | -122.494270675975 | (37.7437183411386, -122.494270675975) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");