Street_Tree_List

Data source: data.sfgov.org

575 rows where qSiteInfo = 13 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
27714 27714 237848 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 21 Addison St 7 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003593.08721 2096850.61715 37.7377559191042 -122.430076526206 (37.7377559191042, -122.430076526206)
43212 43212 245782 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 8 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003599.488059999 2096849.28505 37.7377526239794 -122.43005430038299 (37.7377526239794, -122.430054300383)
54919 54919 237847 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 21 Addison St 3 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003573.70242 2096850.7481 37.7377551807635 -122.430143558104 (37.7377551807635, -122.430143558104)
160995 160995 245783 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 10 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003607.92987 2096849.5108400001 37.73775372205 -122.430025129081 (37.73775372205, -122.430025129081)
177983 177983 245778 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 1 Back Yard : Yard 13 Tree 1 Private 1     11 Width 8ft   6003567.005919999 2096851.6434799999 37.7377572599929 -122.43016677498899 (37.7377572599929, -122.430166774989)
178882 178882 245780 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 5 Back Yard : Yard 13 Tree 1 Private 1     2 Width 8ft   6003583.611880001 2096848.84807 37.7377505249636 -122.430109160821 (37.7377505249636, -122.430109160821)
183987 183987 245781 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 6 Back Yard : Yard 13 Tree 1 Private 1     17 Width 8ft   6003587.5616 2096850.22083 37.7377545179491 -122.43009560263799 (37.7377545179491, -122.430095602638)
184872 184872 245779 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 4 Back Yard : Yard 13 Tree 1 Private 1     4 Width 8ft   6003578.068469999 2096849.2280400002 37.73775125431 -122.430128354157 (37.73775125431, -122.430128354157)
25385 25385 228907 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 902 Duboce Ave 4 Back Yard : Yard 13 Tree 1 Private 1     11 Width 7ft   6002320.43591 2108252.4902 37.7689905824786 -122.435292027503 (37.7689905824786, -122.435292027503)
44939 44939 223816 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 1 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     45 Width 5ft   6002135.08017 2096585.1811900001 37.7369444095655 -122.435098574335 (37.7369444095655, -122.435098574335)
72621 72621 220551 Undocumented 2 Aesculus californica :: California Buckeye 338 11 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     21 Width 5ft   6002176.285680001 2096385.2225400002 37.736397708979794 -122.434941812622 (37.7363977089798, -122.434941812622)
75944 75944 242822 Undocumented 2 Tree(s) :: 17 18 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     46 Width 5ft   6002178.85689 2096424.55585 37.7365058551638 -122.434935735002 (37.7365058551638, -122.434935735002)
174189 174189 242821 Undocumented 2 Tree(s) :: 17 18 Ohlone Way 2 Back Yard : Yard 13 Tree 1 Private 1     37 Width 5ft   6002176.86514 2096431.6975599998 37.7365253515621 -122.43494313191499 (37.7365253515621, -122.434943131915)
23421 23421 195972 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 18 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
42525 42525 195977 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 23 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015256.877230001 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)
43026 43026 245785 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 12 Back Yard : Yard 13 Tree 1 Private 1     2 Width 4ft   6003634.59217 2096849.8681700001 37.7377562131711 -122.42993297014401 (37.7377562131711, -122.429932970144)
49446 49446 195978 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 24 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015236.23042 2100312.22008 37.747913311958605 -122.390061968785 (37.7479133119586, -122.390061968785)
61234 61234 195975 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 21 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)
147625 147625 195976 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 22 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015275.57642 2100315.1093900003 37.7479234275315 -122.38992611271401 (37.7479234275315, -122.389926112714)
171288 171288 195971 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 17 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015377.86647 2100320.4119700002 37.7479436595871 -122.389572765484 (37.7479436595871, -122.389572765484)
171805 171805 195974 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 20 Back Yard : Yard 13 Tree 1 Private 1     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)
173877 173877 195973 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 19 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015335.01264 2100318.2949099997 37.747935470342895 -122.38972080559601 (37.7479354703429, -122.389720805596)
176501 176501 245784 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 11 Back Yard : Yard 13 Tree 1 Private 1     4 Width 4ft   6003626.79774 2096849.74169 37.7377554244689 -122.429959910226 (37.7377554244689, -122.429959910226)
2864 2864 209183 Undocumented 2 Tree(s) :: 17 140 Kensington Way 3 Back Yard : Yard 13 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142)
2887 2887 209188 Undocumented 2 Tree(s) :: 17 156 Kensington Way 2 Back Yard : Yard 13 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994823.818630001 2098534.27999 37.7418782818471 -122.46051787510599 (37.7418782818471, -122.460517875106)
27119 27119 209185 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 5 Back Yard : Yard 13 Tree 1 Private 1     7 Width 3ft   5994853.690119999 2098493.2474700003 37.741767335194105 -122.460411617495 (37.7417673351941, -122.460411617495)
27647 27647 223848 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 4 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000598.61266 2104296.68505 37.758030988052 -122.44096386459299 (37.758030988052, -122.440963864593)
28538 28538 212784 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 739 Foerster St 1 Back Yard : Yard 13 Tree 1 Private 1     17 Width 3ft   5998105.0801800005 2095806.61255 37.734576984727795 -122.448975948078 (37.7345769847278, -122.448975948078)
29662 29662 223849 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 5 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000601.16124 2104292.97169 37.7580209372281 -122.440954784152 (37.7580209372281, -122.440954784152)
36699 36699 218742 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 6 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998867.6092 2095887.4020200002 37.734842393562104 -122.44634545 (37.7348423935621, -122.44634545)
38814 38814 221775 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 21 Addison St 14 Back Yard : Yard 13 Tree 1 Private 1     10 Width 3ft   6003667.46569 2096848.61536 37.737754634878 -122.429819221204 (37.737754634878, -122.429819221204)
42552 42552 241129 Undocumented 2 Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 163 Corwin St 7 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000604.9463 2104285.57219 37.758000835587396 -122.440941163018 (37.7580008355874, -122.440941163018)
43628 43628 218738 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 2 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998805.22806 2095928.00663 37.734950321189 -122.446564042812 (37.734950321189, -122.446564042812)
48070 48070 209184 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 4 Back Yard : Yard 13 Tree 1 Private 1     16 Width 3ft   5994856.4919300005 2098484.57238 37.7417436767315 -122.460401301401 (37.7417436767315, -122.460401301401)
48281 48281 209182 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 2 Back Yard : Yard 13 Tree 1 Private 1     17 Width 3ft   5994867.86795 2098472.15279 37.7417102300345 -122.46036106750799 (37.7417102300345, -122.460361067508)
52362 52362 237943 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 22 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     6 Width 3ft   6002178.91966 2096366.0304900003 37.7363451615923 -122.43493133373501 (37.7363451615923, -122.434931333735)
61847 61847 218740 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 4 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998836.63311 2095909.61295 37.734901610308704 -122.446454142063 (37.7349016103087, -122.446454142063)
68047 68047 218985 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 735 Foerster St 1 Back Yard : Yard 13 Tree 1 Private 1     15 Width 3ft   5998106.15759 2095768.84675 37.7344733504624 -122.448969503563 (37.7344733504624, -122.448969503563)
68601 68601 212785 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 743 Foerster St 1 Back Yard : Yard 13 Tree 1 Private 1     12 Width 3ft   5998104.46417 2095821.7845 37.734618608054795 -122.448979170379 (37.7346186080548, -122.448979170379)
132023 132023 223850 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 6 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000602.6654 2104289.54137 37.758011604077296 -122.440949336057 (37.7580116040773, -122.440949336057)
132146 132146 218741 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 5 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998851.10975 2095900.2680400002 37.73487677824821 -122.44640341939 (37.7348767782482, -122.44640341939)
147254 147254 211258 Undocumented 2 Pinus radiata :: Monterey Pine 3 426 Los Palmos Dr 1 Back Yard : Yard 13 Tree 1 Private 1     15 Width 3ft   5997445.84853 2095752.3652400002 37.734390310651605 -122.451251210378 (37.7343903106516, -122.451251210378)
149374 149374 218737 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998790.02414 2095935.97535 37.7349713329455 -122.446617181062 (37.7349713329455, -122.446617181062)
153368 153368 218739 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 32 Los Palmos Dr 3 Back Yard : Yard 13 Tree 1 Private 1     3 Width 3ft   5998821.443390001 2095918.27736 37.7349245331257 -122.446507281187 (37.7349245331257, -122.446507281187)
158375 158375 241152 Undocumented 2 Tibochina urvilleana :: Princess Flower 260 3 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 3ft   6002150.14382 2096511.4000799998 37.736742679035004 -122.435041217385 (37.736742679035, -122.435041217385)
160996 160996 223847 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 3 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000596.08551 2104301.4441 37.758043911304895 -122.44097294593901 (37.7580439113049, -122.440972945939)
162015 162015 245786 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 13 Back Yard : Yard 13 Tree 1 Private 1     2 Width 3ft   6003641.8158599995 2096850.294 37.73775779149221 -122.429908024732 (37.7377577914922, -122.429908024732)
163239 163239 220552 Undocumented 2 Aesculus californica :: California Buckeye 338 13 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6002169.64489 2096371.31931 37.736359156858704 -122.434963778568 (37.7363591568587, -122.434963778568)
166702 166702 223846 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 2 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000593.0444 2104306.7365599996 37.7580582698975 -122.440983843043 (37.7580582698975, -122.440983843043)
169264 169264 223845 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 163 Corwin St 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 3ft   6000588.980819999 2104313.3574 37.7580762176596 -122.440998371578 (37.7580762176596, -122.440998371578)
174819 174819 209181 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 1 Back Yard : Yard 13 Tree 1 Private 1     15 Width 3ft   5994876.85162 2098459.48593 37.7416759667651 -122.46032908762699 (37.7416759667651, -122.460329087627)
177691 177691 209186 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 6 Back Yard : Yard 13 Tree 1 Private 1     12 Width 3ft   5994849.5459 2098494.81966 37.741771413634794 -122.46042606063 (37.7417714136348, -122.46042606063)
182862 182862 209187 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 156 Kensington Way 1 Back Yard : Yard 13 Tree 1 Private 1     9 Width 3ft   5994832.7400400005 2098518.64338 37.7418358608449 -122.460485895213 (37.7418358608449, -122.460485895213)
189024 189024 209189 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 156 Kensington Way 3 Back Yard : Yard 13 Tree 1 Private 1     9 Width 3ft   5994812.38667 2098544.02713 37.7419043873887 -122.460558108972 (37.7419043873887, -122.460558108972)
23859 23859 223337 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 21 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002002.72042 2096679.5859400001 37.737196106421706 -122.435562951888 (37.7371961064217, -122.435562951888)
27063 27063 233956 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 3 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     1 Width 2ft   6002403.3233199995 2096434.7165299999 37.7365464964208 -122.434160386288 (37.7365464964208, -122.434160386288)
27928 27928 231945 Undocumented 2 Maytenus boaria :: Mayten 22 33 Penny Ln 4 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002666.1416 2096136.6991599998 37.7357431221521 -122.433230424364 (37.7357431221521, -122.433230424364)
29920 29920 240423 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 5 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002449.92079 2096381.9214299999 37.7364041778047 -122.433995506402 (37.7364041778047, -122.433995506402)
30330 30330 233958 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 19 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002544.64531 2096274.1188599998 37.73611355200129 -122.433660302082 (37.7361135520013, -122.433660302082)
35387 35387 240421 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002440.8921300005 2096392.57557 37.736432919229706 -122.43402748359101 (37.7364329192297, -122.434027483591)
43309 43309 231938 Undocumented 2 Maytenus boaria :: Mayten 22 1 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002328.37989 2096518.1207400002 37.7367712513805 -122.43442545876499 (37.7367712513805, -122.434425458765)
45661 45661 233955 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 3 Penny Ln 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002401.2653 2096437.12023 37.736552979622104 -122.434167673516 (37.7365529796221, -122.434167673516)
46775 46775 224477 Undocumented 2 Ficus carica :: Edible Fig 201 23 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     7 Width 2ft   6002584.32363 2096230.7970099999 37.735996851473296 -122.43352002314501 (37.7359968514733, -122.433520023145)
50449 50449 242820 Undocumented 2 Tree(s) :: 17 37 Poppy Ln 2 Back Yard : Yard 13 Tree 1 Private 1     17 Width 2ft   6002456.61791 2096763.3951400002 37.7374519967974 -122.4339996118 (37.7374519967974, -122.4339996118)
50796 50796 225251 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 20 Ohlone Way 3 Back Yard : Yard 13 Tree 1 Private 1     1 Width 2ft   6002182.75585 2096407.15248 37.736458290902796 -122.43492101042 (37.7364582909028, -122.43492101042)
51612 51612 234910 Undocumented 2 Populus tremuloides :: Quaking aspen 166 1 Penny Ln 5 Back Yard : Yard 13 Tree 1 Private 1     8 Width 2ft   6002382.22186 2096459.02703 37.73661204979621 -122.43423508039301 (37.7366120497962, -122.434235080393)
54645 54645 245788 Undocumented 2 Cordyline australis :: Dracena Palm 141 59 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     8 Width 2ft   6002650.36065 2096519.5995200002 37.736793583358605 -122.433312337306 (37.7367935833586, -122.433312337306)
62808 62808 231942 Undocumented 2 Maytenus boaria :: Mayten 22 31 Penny Ln 5 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002659.32372 2096145.42523 37.735766695166504 -122.433254619725 (37.7357666951665, -122.433254619725)
68761 68761 220550 Undocumented 2 Aesculus californica :: California Buckeye 338 37 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002449.94428 2096771.92833 37.737475048229705 -122.43402329543801 (37.7374750482297, -122.434023295438)
71023 71023 240631 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 57 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002629.35658 2096548.6301400003 37.7368721031581 -122.433387031387 (37.7368721031581, -122.433387031387)
71286 71286 240425 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 7 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002456.8751300005 2096374.3168900001 37.736383692152295 -122.433970918943 (37.7363836921523, -122.433970918943)
71556 71556 227504 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 16 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 2ft   6002174.41423 2096447.2518799999 37.7365679209746 -122.434952717804 (37.7365679209746, -122.434952717804)
73730 73730 240424 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 6 Back Yard : Yard 13 Tree 1 Private 1     3 Width 2ft   6002452.23233 2096379.1355 37.7363966594644 -122.43398731536502 (37.7363966594644, -122.433987315365)
131366 131366 237944 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 26 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     15 Width 2ft   6002164.0262 2096336.8178599998 37.736264104808 -122.43498073797701 (37.736264104808, -122.434980737977)
132003 132003 231941 Undocumented 2 Maytenus boaria :: Mayten 22 31 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002655.75902 2096147.9144099997 37.7357733276597 -122.43326712208 (37.7357733276597, -122.43326712208)
134638 134638 233923 Undocumented 2 Persea americana :: Avocado 113 20 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002185.25785 2096400.06868 37.736438982481395 -122.43491185351299 (37.7364389824814, -122.434911853513)
136411 136411 234911 Undocumented 2 Populus tremuloides :: Quaking aspen 166 3 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     8 Width 2ft   6002388.89555 2096450.4938299998 37.736588998379105 -122.434211396756 (37.7365889983791, -122.434211396756)
136660 136660 238536 Undocumented 2 Prunus spp :: Cherry 84 1 Penny Ln 4 Back Yard : Yard 13 Tree 1 Private 1     3 Width 2ft   6002355.478619999 2096490.80035 37.736697774076 -122.434329814067 (37.736697774076, -122.434329814067)
149582 149582 231939 Undocumented 2 Maytenus boaria :: Mayten 22 1 Penny Ln 2 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002331.25514 2096517.0119 37.7367683699712 -122.434415438526 (37.7367683699712, -122.434415438526)
155248 155248 231944 Undocumented 2 Maytenus boaria :: Mayten 22 33 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     9 Width 2ft   6002664.28784 2096138.10096 37.7357468660117 -122.43323693366001 (37.7357468660117, -122.43323693366)
155846 155846 231943 Undocumented 2 Maytenus boaria :: Mayten 22 33 Penny Ln 2 Back Yard : Yard 13 Tree 1 Private 1     1 Width 2ft   6002661.77062 2096140.53935 37.7357534184718 -122.43324581083901 (37.7357534184718, -122.433245810839)
159982 159982 220096 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 5 Penny Ln 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002436.28409 2096397.8300700001 37.736447085360105 -122.43404379100402 (37.7364470853601, -122.434043791004)
160401 160401 227015 Undocumented 2 Juniperus chinensis :: Juniper 19 29 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     1 Width 2ft   6002114.09151 2096793.82616 37.7375161085743 -122.43518606040399 (37.7375161085743, -122.435186060404)
161192 161192 233957 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 15 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002524.54294 2096295.7854099998 37.7361719027113 -122.43373135214199 (37.7361719027113, -122.433731352142)
164865 164865 239558 Undocumented 2 Salix lasiolepis :: Arroyo willow 213 26 Ohlone Way 2 Back Yard : Yard 13 Tree 1 Private 1     9 Width 2ft   6002169.792830001 2096347.5297 37.7362938444778 -122.434961566227 (37.7362938444778, -122.434961566227)
165645 165645 227016 Undocumented 2 Juniperus chinensis :: Juniper 19 29 Poppy Ln 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002117.32476 2096797.30121 37.7375258338607 -122.43517513003201 (37.7375258338607, -122.435175130032)
166281 166281 220095 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 5 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     7 Width 2ft   6002427.25103 2096406.93673 37.7364715774983 -122.43407567285601 (37.7364715774983, -122.434075672856)
171592 171592 223338 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 17 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     2 Width 2ft   6002542.32415 2096276.52832 37.736120036118706 -122.433668499417 (37.7361200361187, -122.433668499417)
174735 174735 236183 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1 Penny Ln 3 Back Yard : Yard 13 Tree 1 Private 1     7 Width 2ft   6002335.35488 2096511.4177599999 37.7367532424671 -122.434400864109 (37.7367532424671, -122.434400864109)
177217 177217 245789 Undocumented 2 Cordyline australis :: Dracena Palm 141 13 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     23 Width 2ft   6002510.68516 2096313.6496700002 37.736220167514404 -122.433780540537 (37.7362201675144, -122.433780540537)
180684 180684 226835 Undocumented 2 Juglans regia :: Walnut: English 348 27 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002073.33297 2096755.10087 37.7374074632877 -122.43532421245199 (37.7374074632877, -122.435324212452)
183893 183893 240363 Undocumented 2 Quercus suber :: Cork Oak 76 19 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 2ft   6002113.49716 2096265.44164 37.7360652530044 -122.435150333941 (37.7360652530044, -122.435150333941)
184761 184761 231940 Undocumented 2 Maytenus boaria :: Mayten 22 31 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002651.97591 2096151.4784799998 37.735782899162395 -122.433280456348 (37.7357828991624, -122.433280456348)
187310 187310 227505 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 11 Ohlone Way 2 Back Yard : Yard 13 Tree 1 Private 1     4 Width 2ft   6002170.3179 2096422.89629 37.7365008135581 -122.434965139225 (37.7365008135581, -122.434965139225)
188488 188488 240422 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 5 Penny Ln 4 Back Yard : Yard 13 Tree 1 Private 1     3 Width 2ft   6002442.71855 2096389.33655 37.7364241292793 -122.43402093743201 (37.7364241292793, -122.434020937432)
35110 35110 176590 Undocumented 2 Juglans nigra :: Eastern black walnut 288 4103 Alemany Blvd 1 Back Yard : Yard 13 Tree 1 Private 1     23 Width 10ft   5991596.71486 2086796.0596 37.7094618598487 -122.470821200944 (37.7094618598487, -122.470821200944)
43436 43436 132413 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 8 Codman Pl 6 Back Yard : Yard 13 Tree 1 Private 1     11 Width 10ft   6009827.38182 2117300.98565 37.7942590579634 -122.409964721995 (37.7942590579634, -122.409964721995)
47731 47731 227663 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 6 Unnamed 011 1 Back Yard : Yard 13 Tree 1 Private 1     13 Width 10ft   6002739.4908 2096074.90228 37.735577602816896 -122.432972414242 (37.7355776028169, -122.432972414242)
161916 161916 132415 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 8 Codman Pl 4 Back Yard : Yard 13 Tree 1 Private 1     8 Width 10ft   6009831.3064 2117286.6196 37.7942198322406 -122.409950127822 (37.7942198322406, -122.409950127822)
163838 163838 239218 Undocumented 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 100 Hwy 101 Southbound 1 Back Yard : Yard 13 Tree 1 Private 1     3 Width 10ft   6005833.18575 2109028.0269 37.771318879598105 -122.423196768328 (37.7713188795981, -122.423196768328)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 214.389ms · Data source: data.sfgov.org