Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150774 | 150774 | 118706 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 4201 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5982550.59501 | 2110970.7524 | 37.7753116033094 | -122.50387485804899 | (37.7753116033094, -122.503874858049) | |||
| 177812 | 177812 | 185230 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2509 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5982693.8052 | 2098008.2989 | 37.7397287878455 | -122.50241990404 | (37.7397287878455, -122.50241990404) | |||
| 136151 | 136151 | 185239 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2519 44th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5982695.2777 | 2097952.3458 | 37.739575242477606 | -122.50241067283599 | (37.7395752424776, -122.502410672836) | |||
| 53007 | 53007 | 117685 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 30 Point Lobos Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5982696.190719999 | 2112611.6036900003 | 37.7798254612036 | -122.50349274887199 | (37.7798254612036, -122.503492748872) | |||
| 146687 | 146687 | 185238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2519 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982696.2593 | 2097960.1988 | 37.7395968623425 | -122.502407859991 | (37.7395968623425, -122.502407859991) | |||
| 133680 | 133680 | 117684 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 30 Point Lobos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5982696.691240001 | 2112606.92808 | 37.779812652776606 | -122.503490671057 | (37.7798126527766, -122.503490671057) | |||
| 51821 | 51821 | 185254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5982701.1675 | 2097764.3628 | 37.7390594386794 | -122.502376400061 | (37.7390594386794, -122.502376400061) | |||
| 52317 | 52317 | 185256 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5982701.6583 | 2097746.6934 | 37.7390109521784 | -122.502373395791 | (37.7390109521784, -122.502373395791) | |||
| 91705 | 91705 | 185255 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982702.6399 | 2097754.5465 | 37.739032572319104 | -122.502370582964 | (37.7390325723191, -122.502370582964) | |||
| 60990 | 60990 | 182927 | Undocumented 2 | Tree(s) :: 17 | 2639 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5982723.7516 | 2097156.0189 | 37.737390419431705 | -122.502253307981 | (37.7373904194317, -122.502253307981) | |||
| 175006 | 175006 | 117660 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 5110 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5982774.78235 | 2111734.38287 | 37.7774214897517 | -122.503155904898 | (37.7774214897517, -122.503155904898) | |||
| 161396 | 161396 | 117651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5101 Anza St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5982808.62425 | 2111663.8514799997 | 37.77722982032 | -122.503033613638 | (37.77722982032, -122.503033613638) | |||
| 47556 | 47556 | 117652 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5101 Anza St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5982828.88915 | 2111662.8174900003 | 37.7772281723606 | -122.502963435462 | (37.7772281723606, -122.502963435462) | |||
| 46312 | 46312 | 117931 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 593 42nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5982837.98596 | 2111790.04502 | 37.777578036655996 | -122.502941388113 | (37.777578036656, -122.502941388113) | |||
| 29129 | 29129 | 117930 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 593 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5982838.9134599995 | 2111805.09577 | 37.7776194161311 | -122.502939294109 | (37.7776194161311, -122.502939294109) | |||
| 37574 | 37574 | 117932 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 599 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5982840.28847 | 2111742.07201 | 37.77744645210971 | -122.502929870802 | (37.7774464521097, -122.502929870802) | |||
| 50559 | 50559 | 117694 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 400 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5982857.55848 | 2113059.74766 | 37.7810654184436 | -122.502967701532 | (37.7810654184436, -122.502967701532) | |||
| 31654 | 31654 | 117698 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4049 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | |||
| 57195 | 57195 | 117697 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 4049 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5982884.20475 | 2113074.25287 | 37.781106811569295 | -122.50287659442301 | (37.7811068115693, -122.502876594423) | |||
| 181654 | 181654 | 117696 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4049 Clement St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982902.7944 | 2113073.3838299997 | 37.781105517967895 | -122.50281222023399 | (37.7811055179679, -122.502812220234) | |||
| 34039 | 34039 | 117695 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4049 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 5982932.793930001 | 2113075.09741 | 37.7811119859752 | -122.50270856543999 | (37.7811119859752, -122.50270856544) | |||
| 76179 | 76179 | 117700 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982971.473069999 | 2113077.09614 | 37.7811197468717 | -122.502574905114 | (37.7811197468717, -122.502574905114) | |||
| 135274 | 135274 | 117699 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 4027 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5982983.94909 | 2113077.92837 | 37.781122765049 | -122.50253180663601 | (37.781122765049, -122.502531806636) | |||
| 57727 | 57727 | 117702 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5983001.87469 | 2113075.50324 | 37.781117159673705 | -122.50246961447901 | (37.7811171596737, -122.502469614479) | |||
| 182738 | 182738 | 117701 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983015.82317 | 2113078.8166099996 | 37.7811270768141 | -122.502421605789 | (37.7811270768141, -122.502421605789) | |||
| 184953 | 184953 | 117709 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 4001 Clement St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983023.36584 | 2113077.55597 | 37.78112405865829 | -122.502395419014 | (37.7811240586583, -122.502395419014) | |||
| 24481 | 24481 | 117708 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983029.04687 | 2113077.7485700003 | 37.7811249212832 | -122.50237578006501 | (37.7811249212832, -122.502375780065) | |||
| 148283 | 148283 | 117707 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 4001 Clement St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 7ft | 5983042.01259 | 2113079.3554 | 37.781130094984604 | -122.502331044828 | (37.7811300949846, -122.502331044828) | |||
| 50300 | 50300 | 117706 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 4001 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983046.11762 | 2113079.5817299997 | 37.7811309576133 | -122.502316860458 | (37.7811309576133, -122.502316860458) | |||
| 172233 | 172233 | 117705 | Undocumented 2 | Dicksonia antarctica :: Soft Tree Fern 397 | 4001 Clement St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983063.64448 | 2113080.6200900003 | 37.7811348384244 | -122.502256304119 | (37.7811348384244, -122.502256304119) | |||
| 164340 | 164340 | 117703 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4001 Clement St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5983084.790030001 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) | |||
| 18682 | 18682 | 87286 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1272 42nd Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | ||||
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 182940 | 182940 | 117926 | Undocumented 2 | Chamaecyparis lawsoniana :: Port Orford Cedar 378 | 563 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5983145.44446 | 2111971.9955700003 | 37.778095685456 | -122.501891269197 | (37.778095685456, -122.501891269197) | |||
| 188684 | 188684 | 117925 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 611 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5983159.2558 | 2111596.2777400003 | 37.7770648850992 | -122.501815685849 | (37.7770648850992, -122.501815685849) | |||
| 151281 | 151281 | 117924 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 611 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983159.66185 | 2111615.2579900003 | 37.7771170231905 | -122.501815685868 | (37.7771170231905, -122.501815685868) | |||
| 43688 | 43688 | 117718 | Undocumented 2 | Banksia integrifolia :: Coast Banksia 349 | 3945 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5983166.80961 | 2113082.0246 | 37.7811447555658 | -122.501899513947 | (37.7811447555658, -122.501899513947) | |||
| 35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
| 137603 | 137603 | 117918 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 731 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5983185.43658 | 2110793.02592 | 37.774860926834606 | -122.501665678898 | (37.7748609268346, -122.501665678898) | |||
| 44355 | 44355 | 184513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5983187.3894 | 2101698.6547 | 37.7498904791156 | -122.50098618533801 | (37.7498904791156, -122.500986185338) | |||
| 48295 | 48295 | 184511 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983188.0663 | 2101701.7005 | 37.749898881781895 | -122.50098406985501 | (37.7498988817819, -122.500984069855) | |||
| 62247 | 62247 | 184510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.749920253660605 | -122.500984645445 | (37.7499202536606, -122.500984645445) | |||
| 174232 | 174232 | 184514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5983188.0663 | 2101693.9168 | 37.749877509903 | -122.500983494265 | (37.749877509903, -122.500983494265) | |||
| 49203 | 49203 | 184512 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983188.7431 | 2101700.3468 | 37.7498952046369 | -122.50098162938299 | (37.7498952046369, -122.500981629383) | |||
| 45516 | 45516 | 117917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5983194.46177 | 2110567.54263 | 37.7742423451733 | -122.501617774429 | (37.7742423451733, -122.501617774429) | |||
| 36969 | 36969 | 117716 | Undocumented 2 | Ilex spp :: Holly Species 163 | 3945 Clement St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5983209.45945 | 2113085.35212 | 37.7811563972474 | -122.50175221539601 | (37.7811563972474, -122.501752215396) | |||
| 72790 | 72790 | 117715 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 3945 Clement St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5983236.22223 | 2113083.20923 | 37.7811520854734 | -122.50165947240801 | (37.7811520854734, -122.501659472408) | |||
| 53554 | 53554 | 185769 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2162 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983287.4484 | 2100417.9653 | 37.7463799348929 | -122.500545498316 | (37.7463799348929, -122.500545498316) | |||
| 27504 | 27504 | 117817 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 5983396.39556 | 2111078.07387 | 37.7756559745836 | -122.50095702488899 | (37.7756559745836, -122.500957024889) | |||
| 149616 | 149616 | 117816 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 6ft | 5983419.54459 | 2111079.81342 | 37.775662110061 | -122.50087707664801 | (37.775662110061, -122.500877076648) | |||
| 179349 | 179349 | 117815 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 5983440.2073 | 2111080.71217 | 37.7756657909172 | -122.50080566686 | (37.7756657909172, -122.50080566686) | |||
| 166581 | 166581 | 117814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983453.00574 | 2111081.1088 | 37.7756676313487 | -122.500761423942 | (37.7756676313487, -122.500761423942) | |||
| 44550 | 44550 | 117813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3900 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5983481.12715 | 2111084.52953 | 37.775678674640396 | -122.500664399599 | (37.7756786746404, -122.500664399599) | |||
| 51280 | 51280 | 117779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 7550 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 5983517.54679 | 2112515.2039799998 | 37.779609028810896 | -122.500644231512 | (37.7796090288109, -122.500644231512) | |||
| 62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
| 51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
| 52972 | 52972 | 185375 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5983693.5835 | 2097421.9022 | 37.7381773965939 | -122.498919838037 | (37.7381773965939, -122.498919838037) | |||
| 169063 | 169063 | 117791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3835 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5983712.00909 | 2111006.51054 | 37.775478008697704 | -122.499859966334 | (37.7754780086977, -122.499859966334) | |||
| 157603 | 157603 | 185374 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983713.0847 | 2096820.2838 | 37.7365266590785 | -122.498807980476 | (37.7365266590785, -122.498807980476) | |||
| 161923 | 161923 | 185376 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5983716.4012 | 2097424.0248 | 37.7381845630473 | -122.498841103792 | (37.7381845630473, -122.498841103792) | |||
| 31478 | 31478 | 185373 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983730.9017 | 2096817.0859 | 37.7365189235088 | -122.498746144318 | (37.7365189235088, -122.498746144318) | |||
| 30410 | 30410 | 185377 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5983769.731000001 | 2097427.474 | 37.7381971614622 | -122.49865697347401 | (37.7381971614622, -122.498656973474) | |||
| 188565 | 188565 | 185372 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983789.4975 | 2096821.8757 | 37.7365355115304 | -122.498543910586 | (37.7365355115304, -122.498543910586) | |||
| 56627 | 56627 | 185378 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5983792.5487 | 2097426.4127 | 37.7381955856127 | -122.49857800406001 | (37.7381955856127, -122.49857800406) | |||
| 36733 | 36733 | 117761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 39th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 5983797.475319999 | 2112772.58996 | 37.7803321653034 | -122.499694882039 | (37.7803321653034, -122.499694882039) | |||
| 39042 | 39042 | 117760 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 446 39th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5983798.11714 | 2112817.23967 | 37.780454798053704 | -122.49969596271002 | (37.7804547980537, -122.49969596271) | |||
| 148366 | 148366 | 185371 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983802.232999999 | 2096820.8145 | 37.7365333446269 | -122.498499800863 | (37.7365333446269, -122.498499800863) | |||
| 52514 | 52514 | 185379 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5983809.5293 | 2097427.474 | 37.7381994954845 | -122.498519372869 | (37.7381994954845, -122.498519372869) | |||
| 151786 | 151786 | 185370 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983816.5604 | 2096821.3451 | 37.73653564171261 | -122.498450304892 | (37.7365356417126, -122.498450304892) | |||
| 178820 | 178820 | 185380 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5983832.8777 | 2097428.0047 | 37.738202321865 | -122.49843868614401 | (37.738202321865, -122.498438686144) | |||
| 184999 | 184999 | 185369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983833.9732 | 2096823.9573 | 37.7365438352192 | -122.498390295245 | (37.7365438352192, -122.498390295245) | |||
| 71894 | 71894 | 185381 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5983854.6341 | 2097429.5966 | 37.7382079686041 | -122.498363582031 | (37.7382079686041, -122.498363582031) | |||
| 56792 | 56792 | 185368 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5983870.2937 | 2096823.9573 | 37.736545965004204 | -122.498264721743 | (37.7365459650042, -122.498264721743) | |||
| 43936 | 43936 | 185367 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5983890.4172 | 2096823.9573 | 37.7365471449614 | -122.49819514730301 | (37.7365471449614, -122.498195147303) | |||
| 130931 | 130931 | 185366 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5983910.0499 | 2096826.4114 | 37.7365550343972 | -122.49812745092301 | (37.7365550343972, -122.498127450923) | |||
| 137825 | 137825 | 185365 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5983933.1183 | 2096826.4114 | 37.7365563869346 | -122.498047694853 | (37.7365563869346, -122.498047694853) | |||
| 52610 | 52610 | 185364 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5983950.2969 | 2096826.9022 | 37.736558741713 | -122.497988338251 | (37.736558741713, -122.497988338251) | |||
| 158759 | 158759 | 117778 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 7414 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983986.79106 | 2112513.3697200003 | 37.7796315288324 | -122.49902080334499 | (37.7796315288324, -122.499020803345) | |||
| 41169 | 41169 | 117777 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 7414 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 3ft | 5983996.528940001 | 2112514.84276 | 37.7796361445772 | -122.498987225205 | (37.7796361445772, -122.498987225205) | |||
| 53938 | 53938 | 118083 | Undocumented 2 | Ilex spp :: Holly Species 163 | 7309 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5984328.8836199995 | 2112397.00903 | 37.7793320968225 | -122.49782878116999 | (37.7793320968225, -122.49782878117) | |||
| 62372 | 62372 | 118020 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 475 37th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5984364.96276 | 2112612.80222 | 37.7799267173953 | -122.49771990805799 | (37.7799267173953, -122.497719908058) | |||
| 131623 | 131623 | 184833 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1201 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984627.0370000005 | 2106879.4946 | 37.7642000508442 | -122.496390124998 | (37.7642000508442, -122.496390124998) | |||
| 174588 | 174588 | 184857 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984627.4167 | 2106843.4213 | 37.7641010259615 | -122.496386149808 | (37.7641010259615, -122.496386149808) | |||
| 165071 | 165071 | 184834 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1201 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984628.5558 | 2106879.1149 | 37.7641990972685 | -122.49638484396499 | (37.7641990972685, -122.496384843965) | |||
| 165920 | 165920 | 184816 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 57 | Width 0ft | 5984628.5558 | 2106956.7675 | 37.7644123094409 | -122.49639057415199 | (37.7644123094409, -122.496390574152) | |||
| 53890 | 53890 | 184855 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984629.3153 | 2106852.5345 | 37.764126159465796 | -122.49638025568501 | (37.7641261594658, -122.496380255685) | |||
| 58282 | 58282 | 184820 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1201 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984629.3153 | 2106942.3382 | 37.7643727351397 | -122.496386882515 | (37.7643727351397, -122.496386882515) | |||
| 26185 | 26185 | 184822 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1201 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984630.0747 | 2106925.6305 | 37.7643269049874 | -122.496383023099 | (37.7643269049874, -122.496383023099) | |||
| 58476 | 58476 | 184827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984631.5936 | 2106907.2141 | 37.764276427718 | -122.49637641074301 | (37.764276427718, -122.496376410743) | |||
| 132952 | 132952 | 184826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 0ft | 5984631.5936 | 2106918.0361 | 37.7643061418827 | -122.49637720932199 | (37.7643061418827, -122.496377209322) | |||
| 136142 | 136142 | 184832 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1201 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984631.9733 | 2106882.1526 | 37.76420763813871 | -122.496373248148 | (37.7642076381387, -122.496373248148) | |||
| 72243 | 72243 | 184831 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984632.352999999 | 2106892.4051 | 37.76423581086029 | -122.496372691447 | (37.7642358108603, -122.496372691447) | |||
| 41402 | 41402 | 184854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984632.7328 | 2106851.7751 | 37.764124274568 | -122.496368379685 | (37.764124274568, -122.496368379685) | |||
| 150735 | 150735 | 184840 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.1125 | 2106860.5086 | 37.7641482765436 | -122.49636771089199 | (37.7641482765436, -122.496367710892) | |||
| 179837 | 179837 | 184835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984633.1125 | 2106875.3177 | 37.764188938163 | -122.496368803682 | (37.764188938163, -122.496368803682) | |||
| 131473 | 131473 | 184856 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.4922 | 2106845.3199 | 37.764106594892205 | -122.49636527684099 | (37.7641065948922, -122.496365276841) | |||
| 138084 | 138084 | 184839 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984633.4922 | 2106865.0653 | 37.7641608102021 | -122.49636673388599 | (37.7641608102021, -122.496366733886) | |||
| 73850 | 73850 | 184867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.0111 | 2106821.7773 | 37.7640420425175 | -122.496358286248 | (37.7640420425175, -122.496358286248) | |||
| 35947 | 35947 | 184865 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984635.3908 | 2106835.0674 | 37.7640785556344 | -122.49635795369 | (37.7640785556344, -122.49635795369) | |||
| 72988 | 72988 | 184885 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5984635.3908 | 2106778.1095 | 37.763922165271104 | -122.496353750703 | (37.7639221652711, -122.496353750703) |
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");