Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
1875 | 1875 | 251783 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 610 Clipper St | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | Width 2ft | 6001275.75039 | 2100902.7174 | 37.7487505133321 | -122.438378885672 | (37.7487505133321, -122.438378885672) | ||||
2768 | 2768 | 219151 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 4ft | 5991179.47447 | 2105124.8493 | 37.759763935780704 | -122.47359934526101 | (37.7597639357807, -122.473599345261) | |||
3279 | 3279 | 253383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
30996 | 30996 | 247856 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6009566.847130001 | 2098148.32022 | 37.7416556510973 | -122.409513828008 | (37.7416556510973, -122.409513828008) | ||||
31259 | 31259 | 201730 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951001 | (37.7357879596321, -122.39485111951) | ||||
33445 | 33445 | 197872 | Undocumented 2 | Syzygium australe :: Eugenia 178 | 1999 Revere Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013000.33309 | 2095912.9511400003 | 37.735709585525896 | -122.397485169905 | (37.7357095855259, -122.397485169905) | ||||
34593 | 34593 | 234491 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 24 Saturn St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6000385.28479 | 2106021.7264900003 | 37.762755374980394 | -122.44182544748999 | (37.7627553749804, -122.44182544749) | |||
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) | ||||
37530 | 37530 | 249638 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | ||||
37570 | 37570 | 246644 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009046.23893 | 2099176.02556 | 37.744448319452204 | -122.41138650967899 | (37.7444483194522, -122.411386509679) | ||||
39702 | 39702 | 195996 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6012499.275719999 | 2097703.95349 | 37.7405993901482 | -122.39934322143101 | (37.7405993901482, -122.399343221431) | |||
41147 | 41147 | 247005 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 401 Valley St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 8ft | 6003245.1291 | 2099189.5781900003 | 37.7441584535423 | -122.431446509373 | (37.7441584535423, -122.431446509373) | |||
43430 | 43430 | 246655 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009062.9897 | 2099201.46712 | 37.7445191158731 | -122.411330385684 | (37.7445191158731, -122.411330385684) | ||||
45814 | 45814 | 248245 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 296 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006801.134769999 | 2098995.22543 | 37.7438257043874 | -122.41913681222401 | (37.7438257043874, -122.419136812224) | ||||
46469 | 46469 | 250199 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 0ft | 6011821.07725 | 2119768.34547 | 37.8011453692141 | -122.403239919993 | (37.8011453692141, -122.403239919993) | |||
46954 | 46954 | 237909 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6002350.80679 | 2103530.36749 | 37.7560265053261 | -122.43484923730499 | (37.7560265053261, -122.434849237305) | ||||
47116 | 47116 | 206467 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999430.1593 | 2095426.08584 | 37.7336078411342 | -122.44436738395099 | (37.7336078411342, -122.444367383951) | ||||
49584 | 49584 | 178353 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 648 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6005050.25442 | 2092601.27902 | 37.7261706033722 | -122.42473618194599 | (37.7261706033722, -122.424736181946) | ||||
50723 | 50723 | 199619 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013984.3244 | 2092869.9258 | 37.727408798052295 | -122.393870163286 | (37.7274087980523, -122.393870163286) | ||||
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) | ||||
58449 | 58449 | 130533 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Spruce St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 4ft | 5997122.58531 | 2115614.86787 | 37.7889091907409 | -122.453802698553 | (37.7889091907409, -122.453802698553) | |||
58506 | 58506 | 205602 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000764.56926 | 2095288.2895 | 37.733305529524294 | -122.43974407725099 | (37.7333055295243, -122.439744077251) | ||||
59005 | 59005 | 246627 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009025.0688 | 2099378.58818 | 37.7450033243595 | -122.411474020021 | (37.7450033243595, -122.411474020021) | ||||
62669 | 62669 | 195221 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6014598.7472 | 2097125.5339900001 | 37.739127958984106 | -122.392043559277 | (37.7391279589841, -122.392043559277) | |||
63232 | 63232 | 132435 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6008622.60306 | 2118990.33445 | 37.7988299962621 | -122.414252988079 | (37.7988299962621, -122.414252988079) | ||||
63837 | 63837 | 234919 | Undocumented 2 | Prunus spp :: Cherry 84 | 200 Saint Marys Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6003932.02563 | 2095971.19882 | 37.735360426449105 | -122.428841975603 | (37.7353604264491, -122.428841975603) | |||
65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
66579 | 66579 | 237936 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 272 Corbett Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999637.58135 | 2105322.06296 | 37.7607916396321 | -122.444361196632 | (37.7607916396321, -122.444361196632) | |||
67351 | 67351 | 247884 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009916.04567 | 2098399.5551400003 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | ||||
69445 | 69445 | 201615 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6020732.10647 | 2093000.2197599998 | 37.728139252612 | -122.370551779534 | (37.728139252612, -122.370551779534) | |||
69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
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) | |||
72627 | 72627 | 136608 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 4ft | 6002554.72948 | 2121670.19367 | 37.8058454762555 | -122.435441587454 | (37.8058454762555, -122.435441587454) | |||
86677 | 86677 | 121161 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
123296 | 123296 | 177517 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 654 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6005174.05368 | 2092521.73439 | 37.7259591826438 | -122.424302559431 | (37.7259591826438, -122.424302559431) | ||||
123812 | 123812 | 248186 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 216 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6007424.17564 | 2098716.567 | 37.7430956374584 | -122.416962738041 | (37.7430956374584, -122.416962738041) | ||||
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) | ||||
130704 | 130704 | 132394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6006476.08021 | 2120921.35396 | 37.804011278359205 | -122.42181790617599 | (37.8040112783592, -122.421817906176) | ||||
132929 | 132929 | 248176 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 218 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6007352.57269 | 2098728.04066 | 37.7431231135451 | -122.41721113529499 | (37.7431231135451, -122.417211135295) | ||||
133366 | 133366 | 247524 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 1101 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6000021.13855 | 2108488.5030900002 | 37.769507771781704 | -122.44326207937901 | (37.7695077717817, -122.443262079379) | ||||
146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
150025 | 150025 | 227020 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 31 Poppy Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6002175.423769999 | 2096803.9702599999 | 37.7375474445557 | -122.43497473141501 | (37.7375474445557, -122.434974731415) | |||
150355 | 150355 | 190919 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 999 Kansas St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011651.17755 | 2103795.8209 | 37.7572790316179 | -122.40270394113001 | (37.7572790316179, -122.40270394113) | ||||
152037 | 152037 | 211278 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 40 | 5998798.56109 | 2095521.95863 | 37.733835028746796 | -122.44655788876301 | (37.7338350287468, -122.446557888763) | ||||
154273 | 154273 | 190078 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6013893.72787 | 2092886.08627 | 37.7274481362093 | -122.394184488917 | (37.7274481362093, -122.394184488917) | ||||
154745 | 154745 | 247893 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 360 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010010.97874 | 2098373.6186 | 37.74229914749979 | -122.407994047508 | (37.7422991474998, -122.407994047508) | ||||
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) | ||||
164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
164552 | 164552 | 197065 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1750 22nd St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012833.7263400005 | 2103797.94864 | 37.7573508280876 | -122.398614346997 | (37.7573508280876, -122.398614346997) | ||||
165042 | 165042 | 218785 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5998782.76063 | 2095352.74135 | 37.733369495591795 | -122.446600344857 | (37.7333694955918, -122.446600344857) | ||||
165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
166457 | 166457 | 247914 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 399 Franconia St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010000.52553 | 2098831.51714 | 37.7435558520369 | -122.40806247691499 | (37.7435558520369, -122.408062476915) | ||||
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) | |||
169612 | 169612 | 247876 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6009908.43883 | 2098395.0561 | 37.742352268652 | -122.40835011248001 | (37.742352268652, -122.40835011248) | ||||
170275 | 170275 | 196369 | Undocumented 2 | Prunus persica :: Peach 330 | 1499 Rankin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | Width 3ft | 6012673.95486 | 2096676.86192 | 37.7377889466986 | -122.39866718483499 | (37.7377889466986, -122.398667184835) | |||
171284 | 171284 | 249897 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1497 Montgomery St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011384.61876 | 2120458.08201 | 37.8030148322229 | -122.40479885070101 | (37.8030148322229, -122.404798850701) | |||
173419 | 173419 | 203452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 5991186.2272 | 2105007.12865 | 37.7594410971589 | -122.473567404026 | (37.7594410971589, -122.473567404026) | |||
174270 | 174270 | 247907 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 582 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009851.66024 | 2098739.23116 | 37.7432941187313 | -122.40857070986401 | (37.7432941187313, -122.408570709864) | ||||
177265 | 177265 | 132399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | ||||
178599 | 178599 | 250158 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999254.28786 | 2117464.37854 | 37.794109442247404 | -122.446560444632 | (37.7941094422474, -122.446560444632) | ||||
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) | ||||
179275 | 179275 | 225250 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 200 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6000060.0999300005 | 2105713.56645 | 37.761890709215 | -122.442928012745 | (37.761890709215, -122.442928012745) | |||
180895 | 180895 | 176096 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998966.43073 | 2089373.6298 | 37.7169627336137 | -122.445535550248 | (37.7169627336137, -122.445535550248) | ||||
181045 | 181045 | 223003 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 198 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000086.83847 | 2105686.0969700003 | 37.761816809226 | -122.442833562346 | (37.761816809226, -122.442833562346) | |||
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) | ||||
181788 | 181788 | 248063 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 Rutledge St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010655.07626 | 2099382.64168 | 37.7451057472447 | -122.40583800472 | (37.7451057472447, -122.40583800472) | ||||
182687 | 182687 | 247952 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010434.68219 | 2098863.51365 | 37.7436680064839 | -122.40656351750799 | (37.7436680064839, -122.406563517508) | ||||
184006 | 184006 | 248223 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 70 Fair Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | ||||
187457 | 187457 | 248048 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 38 Rutledge St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010518.28913 | 2099442.3918 | 37.7452621573156 | -122.406315202106 | (37.7452621573156, -122.406315202106) | ||||
188376 | 188376 | 248091 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010638.35138 | 2100271.0907099997 | 37.747544299426295 | -122.405958412248 | (37.7475442994263, -122.405958412248) |
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");