Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 3743 | 3743 | 175363 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 5993226.79298 | 2087801.79474 | 37.71231750501779 | -122.465260429219 | (37.7123175050178, -122.465260429219) | |||
| 44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
| 51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
| 55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
| 58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
| 65706 | 65706 | 201723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6017160.60225 | 2095378.34378 | 37.734472425960895 | -122.383064166774 | (37.7344724259609, -122.383064166774) | ||||
| 146514 | 146514 | 201719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6017095.79964 | 2095357.4210400002 | 37.7344113952763 | -122.38328675710501 | (37.7344113952763, -122.383286757105) | ||||
| 167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
| 122220 | 122220 | 188563 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1 Waterville St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011470.31075 | 2096143.8224099998 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | ||||
| 30768 | 30768 | 223720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | |||
| 39131 | 39131 | 234106 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 10 Crescent Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6005252.57338 | 2095904.2217 | 37.735251176793604 | -122.424271584978 | (37.7352511767936, -122.424271584978) | |||
| 39582 | 39582 | 229804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Crescent Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6005354.49537 | 2095898.81655 | 37.7352420900484 | -122.423918818711 | (37.7352420900484, -122.423918818711) | |||
| 67552 | 67552 | 223719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6005300.64092 | 2095902.62438 | 37.735249504969104 | -122.424105284154 | (37.7352495049691, -122.424105284154) | |||
| 188033 | 188033 | 226640 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Crescent Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6005282.96903 | 2095902.7994400002 | 37.7352489878562 | -122.42416639485799 | (37.7352489878562, -122.424166394858) | |||
| 34176 | 34176 | 120265 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 100 24th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5988361.4812900005 | 2115164.4742099997 | 37.7871663527314 | -122.484081512932 | (37.7871663527314, -122.484081512932) | ||||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 43664 | 43664 | 120267 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 100 24th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988369.5187800005 | 2115107.91648 | 37.7870115292654 | -122.48404955627501 | (37.7870115292654, -122.484049556275) | ||||
| 160229 | 160229 | 120264 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 100 24th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5988352.12015 | 2115168.07199 | 37.787175686198 | -122.48411416398301 | (37.787175686198, -122.484114163983) | ||||
| 163684 | 163684 | 120263 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 24th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | ||||
| 166247 | 166247 | 120262 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 100 24th Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 5988353.58713 | 2115180.43805 | 37.7872097252822 | -122.484109995805 | (37.7872097252822, -122.484109995805) | ||||
| 25897 | 25897 | 134510 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6008017.687530001 | 2112101.62184 | 37.7798812789472 | -122.415858138542 | (37.7798812789472, -122.415858138542) | |||
| 26079 | 26079 | 134508 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 4ft | 6008055.00417 | 2112104.50717 | 37.7798912991906 | -122.41572924771499 | (37.7798912991906, -122.415729247715) | |||
| 40126 | 40126 | 134511 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 4ft | 6008018.559330001 | 2112114.37672 | 37.7799163498009 | -122.41585602603399 | (37.7799163498009, -122.415856026034) | |||
| 43990 | 43990 | 134521 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6007806.05941 | 2112087.1007 | 37.7798295076742 | -122.416589227122 | (37.7798295076742, -122.416589227122) | |||
| 44987 | 44987 | 134512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 4ft | 6007952.73516 | 2112091.3955099997 | 37.7798495481525 | -122.416082113806 | (37.7798495481525, -122.416082113806) | |||
| 57595 | 57595 | 134520 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6007809.423690001 | 2112072.4347 | 37.779789427567 | -122.41657654936199 | (37.779789427567, -122.416576549362) | |||
| 60593 | 60593 | 134509 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | Width 4ft | 6008051.61488 | 2112117.95752 | 37.7799280400987 | -122.415741925456 | (37.7799280400987, -122.415741925456) | |||
| 66598 | 66598 | 134503 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 4ft | 6008163.02923 | 2112130.27379 | 37.7799681201757 | -122.41535736455799 | (37.7799681201757, -122.415357364558) | |||
| 70214 | 70214 | 134516 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6007879.23543 | 2112081.34439 | 37.7798178173801 | -122.416335670458 | (37.7798178173801, -122.416335670458) | |||
| 70475 | 70475 | 134506 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | Width 4ft | 6008094.26451 | 2112112.8267900003 | 37.779916349808396 | -122.41559401757699 | (37.7799163498084, -122.415594017577) | |||
| 73716 | 73716 | 134514 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 13 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 6007916.55212 | 2112084.22953 | 37.779827837626705 | -122.41620677962 | (37.7798278376267, -122.41620677962) | |||
| 137288 | 137288 | 134517 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6007880.14491 | 2112095.92317 | 37.7798578983531 | -122.41633355704599 | (37.7798578983531, -122.416333557046) | |||
| 137329 | 137329 | 134502 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | Width 4ft | 6008165.1975300005 | 2112116.84845 | 37.779931379274004 | -122.415348912733 | (37.779931379274, -122.415348912733) | |||
| 138148 | 138148 | 134518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 17 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6007848.65925 | 2112079.5377 | 37.7798111372171 | -122.41644131921801 | (37.7798111372171, -122.416441319218) | |||
| 153139 | 153139 | 134513 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 4ft | 6007949.93141 | 2112103.61743 | 37.779882948971206 | -122.416092679044 | (37.7798829489712, -122.416092679044) | |||
| 164267 | 164267 | 134504 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 4ft | 6008127.86822 | 2112113.3553299997 | 37.7799196898886 | -122.41547780446999 | (37.7799196898886, -122.41547780447) | |||
| 172984 | 172984 | 134507 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008088.37088 | 2112123.28694 | 37.779944739586 | -122.415615147138 | (37.779944739586, -122.415615147138) | |||
| 177126 | 177126 | 134515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6007920.47696 | 2112096.9218900003 | 37.7798629084902 | -122.416194101002 | (37.7798629084902, -122.416194101002) | |||
| 177530 | 177530 | 134505 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008123.85605 | 2112126.20986 | 37.7799547598338 | -122.41549259472299 | (37.7799547598338, -122.415492594723) | |||
| 177540 | 177540 | 134519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6007845.81845 | 2112089.93571 | 37.779839527901295 | -122.416451883555 | (37.7798395279013, -122.416451883555) | |||
| 32078 | 32078 | 195081 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 23 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014990.50186 | 2103171.25593 | 37.7557499880963 | -122.391111501888 | (37.7557499880963, -122.391111501888) | |||
| 41420 | 41420 | 195079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 21 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014986.69812 | 2103234.99475 | 37.755924790211395 | -122.391129111534 | (37.7559247902114, -122.391129111534) | |||
| 48783 | 48783 | 195082 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 24 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014993.20082 | 2103136.83485 | 37.755655624926895 | -122.39109976213899 | (37.7556556249269, -122.391099762139) | |||
| 77273 | 77273 | 195083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 25 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 4ft | 6014995.62835 | 2103102.9826 | 37.755562808578404 | -122.391089000875 | (37.7555628085784, -122.391089000875) | |||
| 176180 | 176180 | 195080 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 22 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 4ft | 6014988.8599 | 2103201.99322 | 37.755834295018204 | -122.39111932871201 | (37.7558342950182, -122.391119328712) | |||
| 182626 | 182626 | 195078 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 4ft | 6014987.06432 | 2103267.10016 | 37.7560129651346 | -122.391130089079 | (37.7560129651346, -122.391130089079) | |||
| 53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
| 179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
| 43890 | 43890 | 249771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6010450.87532 | 2121165.29 | 37.8049044157696 | -122.408080009188 | (37.8049044157696, -122.408080009188) | |||
| 53370 | 53370 | 249773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010432.56007 | 2121153.50484 | 37.80487103114871 | -122.40814255972602 | (37.8048710311487, -122.408142559726) | |||
| 64938 | 64938 | 249772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 102 Pfeiffer St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6010438.89548 | 2121163.96639 | 37.8049001107042 | -122.40812137351801 | (37.8049001107042, -122.408121373518) | |||
| 136621 | 136621 | 249776 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 102 Pfeiffer St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | Width 0ft | 6010370.54568 | 2121149.36884 | 37.804856202214204 | -122.408356876268 | (37.8048562022142, -122.408356876268) | |||
| 162418 | 162418 | 249770 | Undocumented 2 | Schinus molle :: California Pepper 138 | 102 Pfeiffer St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 0ft | 6010494.56062 | 2121168.81632 | 37.8049165440205 | -122.407929079557 | (37.8049165440205, -122.407929079557) | |||
| 168933 | 168933 | 249774 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6010412.38512 | 2121159.3166 | 37.804885859146104 | -122.408212787783 | (37.8048858591461, -122.408212787783) | |||
| 183252 | 183252 | 249775 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 0ft | 6010401.04426 | 2121152.2311400003 | 37.8048657692012 | -122.40825153418999 | (37.8048657692012, -122.40825153419) | |||
| 31566 | 31566 | 179618 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011168.50385 | 2093508.14959 | 37.729004339277395 | -122.403649399324 | (37.7290043392774, -122.403649399324) | ||||
| 64756 | 64756 | 177286 | Undocumented 2 | Magnolia champaca :: Champa 170 | 104 Burrows St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6011163.93479 | 2093493.4831700001 | 37.7289638131138 | -122.403664163474 | (37.7289638131138, -122.403664163474) | ||||
| 155892 | 155892 | 177287 | Undocumented 2 | Magnolia champaca :: Champa 170 | 104 Burrows St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6011161.857999999 | 2093502.5311200002 | 37.728988540885204 | -122.40367197949499 | (37.7289885408852, -122.403671979495) | ||||
| 165025 | 165025 | 179619 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | ||||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) | ||||
| 61422 | 61422 | 175560 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 105 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6011176.06814 | 2093472.4733799999 | 37.728906802388394 | -122.403620739722 | (37.7289068023884, -122.403620739722) | ||||
| 73567 | 73567 | 177285 | Undocumented 2 | Magnolia champaca :: Champa 170 | 105 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6011169.81083 | 2093473.6012799998 | 37.728909549831 | -122.403642451135 | (37.728909549831, -122.403642451135) | ||||
| 132985 | 132985 | 179617 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 105 Burrows St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011176.00009 | 2093481.4804599998 | 37.7289315301509 | -122.403621608451 | (37.7289315301509, -122.403621608451) | ||||
| 173301 | 173301 | 194438 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1051 18th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6014405.25344 | 2105708.40792 | 37.762683964324495 | -122.39331303148 | (37.7626839643245, -122.39331303148) | ||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 24297 | 24297 | 248119 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010375.35501 | 2099399.67941 | 37.7451368817742 | -122.40680643699301 | (37.7451368817742, -122.406806436993) | ||||
| 32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
| 36690 | 36690 | 248115 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010382.6698900005 | 2099427.30215 | 37.7452131370921 | -122.406783089664 | (37.7452131370921, -122.406783089664) | ||||
| 38800 | 38800 | 248116 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464327995 | -122.406793240314 | (37.745191464328, -122.406793240314) | ||||
| 46620 | 46620 | 248114 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | ||||
| 54920 | 54920 | 248118 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010376.970919999 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | ||||
| 70123 | 70123 | 248111 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010383.711069999 | 2099443.8594400003 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | ||||
| 130896 | 130896 | 248113 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010385.30327 | 2099441.28079 | 37.745251666737296 | -122.40677496881099 | (37.7452516667373, -122.406774968811) | ||||
| 148699 | 148699 | 248117 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010378.29952 | 2099414.5285 | 37.7451778188963 | -122.40679730165701 | (37.7451778188963, -122.406797301657) | ||||
| 154282 | 154282 | 248120 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.40681354343701 | (37.745124840742, -122.406813543437) | ||||
| 25982 | 25982 | 247919 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010242.48982 | 2098715.3752200003 | 37.743250496220895 | -122.40721763491001 | (37.7432504962209, -122.40721763491) | ||||
| 30032 | 30032 | 247924 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6010297.695230001 | 2098727.78354 | 37.7432876562154 | -122.40702762254499 | (37.7432876562154, -122.407027622545) | ||||
| 42172 | 42172 | 247916 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1098 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010216.5253800005 | 2098717.08126 | 37.743253727490504 | -122.407307533818 | (37.7432537274905, -122.407307533818) | ||||
| 46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
| 59867 | 59867 | 247926 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010312.05046 | 2098736.31721 | 37.743311891127604 | -122.406978587005 | (37.7433118911276, -122.406978587005) | ||||
| 62115 | 62115 | 247923 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6010288.87158 | 2098729.72842 | 37.7432925026595 | -122.40705826963699 | (37.7432925026595, -122.407058269637) | ||||
| 70884 | 70884 | 247927 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6010318.55961 | 2098736.7728 | 37.7433135063186 | -122.40695611204501 | (37.7433135063186, -122.406956112045) | ||||
| 126166 | 126166 | 247920 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1098 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010252.902419999 | 2098733.4037 | 37.743300581252605 | -122.40718290126301 | (37.7433005812526, -122.407182901263) | ||||
| 147007 | 147007 | 247922 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010270.948580001 | 2098720.09099 | 37.7432650373678 | -122.40711956383001 | (37.7432650373678, -122.40711956383) | ||||
| 150294 | 150294 | 247917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6010231.88216 | 2098716.76824 | 37.7432537274832 | -122.407254411775 | (37.7432537274832, -122.407254411775) | ||||
| 159931 | 159931 | 247918 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1098 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010239.20977 | 2098728.38698 | 37.7432860401182 | -122.407229893555 | (37.7432860401182, -122.407229893555) | ||||
| 169544 | 169544 | 247921 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6010260.8237 | 2098716.17835 | 37.7432537274883 | -122.407154297447 | (37.7432537274883, -122.407154297447) | ||||
| 24579 | 24579 | 247929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6010384.7561099995 | 2098766.60945 | 37.743399135274295 | -122.40672932282301 | (37.7433991352743, -122.406729322823) | ||||
| 31541 | 31541 | 247930 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6010384.98383 | 2098777.78466 | 37.7434298327179 | -122.406729322818 | (37.7434298327179, -122.406729322818) | ||||
| 56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
| 74012 | 74012 | 247935 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6010295.56922 | 2098768.42696 | 37.743399135252204 | -122.407037837932 | (37.7433991352522, -122.407037837932) | ||||
| 166763 | 166763 | 247928 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010393.74755 | 2098772.89885 | 37.7434169076795 | -122.406698675702 | (37.7434169076795, -122.406698675702) | ||||
| 181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
| 181489 | 181489 | 247933 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010316.772530001 | 2098765.05298 | 37.7433910575536 | -122.40696428417601 | (37.7433910575536, -122.406964284176) | ||||
| 185208 | 185208 | 247934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010311.02519 | 2098743.98721 | 37.7433328939103 | -122.406982672633 | (37.7433328939103, -122.406982672633) | ||||
| 27927 | 27927 | 247528 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Waller St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | ||||
| 33188 | 33188 | 247526 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1101 Waller St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6000042.11565 | 2108480.23517 | 37.76948626629979 | -122.44318892675 | (37.7694862662998, -122.44318892675) |
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");