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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31147 | 31147 | 207112 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992171.746719999 | 2088295.8735200001 | 37.7136132266511 | -122.46894288591899 | (37.7136132266511, -122.468942885919) | ||||
31427 | 31427 | 223996 | Undocumented 2 | Eucalyptus rudis :: Swamp Gum: Flooded Gum 287 | 100 Hwy 101 Southbound | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6005945.0032 | 2108837.4935 | 37.770802030213105 | -122.42279644320699 | (37.7708020302131, -122.422796443207) | ||||
31601 | 31601 | 195958 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015649.240619999 | 2100340.8983400003 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | ||||
31969 | 31969 | 239194 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005943.751730001 | 2109019.81978 | 37.7713025838749 | -122.422813731768 | (37.7713025838749, -122.422813731768) | ||||
32290 | 32290 | 239198 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005918.91365 | 2109064.99496 | 37.771425222619705 | -122.42290285910299 | (37.7714252226197, -122.422902859103) | ||||
32977 | 32977 | 219173 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 47 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 5992177.27741 | 2088252.3205900001 | 37.71349396036 | -122.46892060252199 | (37.71349396036, -122.468920602522) | ||||
33201 | 33201 | 195967 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6015456.783980001 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | ||||
33236 | 33236 | 195970 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015399.1088 | 2100325.42161 | 37.747958592828205 | -122.389499659601 | (37.7479585928282, -122.389499659601) | ||||
33977 | 33977 | 249894 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 30 | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | Width 0ft | 6011403.76038 | 2120447.63681 | 37.802987222140395 | -122.40473187458599 | (37.8029872221404, -122.404731874586) | |||
34117 | 34117 | 237115 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.42314917169399 | (37.7712010306339, -122.423149171694) | ||||
34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
34830 | 34830 | 239214 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005859.14445 | 2108978.35649 | 37.771183961488106 | -122.423103444792 | (37.7711839614881, -122.423103444792) | ||||
34978 | 34978 | 249883 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 230 Greenwich St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6011507.08304 | 2120427.1107900003 | 37.802936637067496 | -122.40437287690901 | (37.8029366370675, -122.404372876909) | |||
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) | |||
35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
35375 | 35375 | 239209 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005896.875990001 | 2108918.25042 | 37.7710210537973 | -122.42296865708299 | (37.7710210537973, -122.422968657083) | ||||
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) | |||
36138 | 36138 | 249778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6010409.80858 | 2121137.7854400002 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | |||
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) | |||
37767 | 37767 | 211724 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992178.335940001 | 2088233.1934099998 | 37.71344150289679 | -122.468915552827 | (37.7134415028968, -122.468915552827) | ||||
37934 | 37934 | 249882 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | Width 0ft | 6011509.072430001 | 2120419.3733099997 | 37.8029155030083 | -122.40436544761499 | (37.8029155030083, -122.404365447615) | |||
38334 | 38334 | 195966 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | ||||
38350 | 38350 | 239199 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6005974.4493 | 2108807.19348 | 37.770720494984495 | -122.422692434815 | (37.7707204949845, -122.422692434815) | ||||
38396 | 38396 | 195968 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6015437.03514 | 2100327.8138099997 | 37.747967264084295 | -122.389368677829 | (37.7479672640843, -122.389368677829) | ||||
38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
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) | |||
40928 | 40928 | 250002 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011523.15034 | 2120119.58855 | 37.8020931539352 | -122.40429561796499 | (37.8020931539352, -122.404295617965) | |||
41112 | 41112 | 249802 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.804544802067795 | -122.40686029106399 | (37.8045448020678, -122.406860291064) | |||
41322 | 41322 | 211727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992176.51123 | 2088212.22362 | 37.7133838194885 | -122.468920334526 | (37.7133838194885, -122.468920334526) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
43839 | 43839 | 250000 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 39 Darrell Pl | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011508.04195 | 2120196.77393 | 37.802304241897204 | -122.404353336441 | (37.8023042418972, -122.404353336441) | |||
44635 | 44635 | 239192 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005960.3562900005 | 2108991.91912 | 37.771226912211795 | -122.422754312663 | (37.7712269122118, -122.422754312663) | ||||
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) | |||
45069 | 45069 | 126561 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 8 Codman Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6009832.93804 | 2117260.0663900003 | 37.7941470150322 | -122.40994260678998 | (37.7941470150322, -122.40994260679) | ||||
45307 | 45307 | 239204 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 6005940.87649 | 2108850.7859900002 | 37.7708382953675 | -122.422811662426 | (37.7708382953675, -122.422811662426) | ||||
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) | |||
46092 | 46092 | 195960 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015597.7328 | 2100337.72732 | 37.748003392560896 | -122.38881367921302 | (37.7480033925609, -122.388813679213) | ||||
46680 | 46680 | 249916 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011201.85513 | 2120410.11068 | 37.8028728976405 | -122.40542793096901 | (37.8028728976405, -122.405427930969) | |||
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) | |||
46915 | 46915 | 249805 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.40689661648099 | (37.8045763727666, -122.406896616481) | |||
47138 | 47138 | 118572 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 7940 Geary Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5982338.13373 | 2112440.49418 | 37.7793345882457 | -122.50471872286 | (37.7793345882457, -122.50471872286) | ||||
47640 | 47640 | 249876 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 29 | Width 0ft | 6011590.626680001 | 2120460.04582 | 37.8030317367952 | -122.40408609031 | (37.8030317367952, -122.40408609031) | |||
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) | |||
47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
47848 | 47848 | 209611 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 77 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.85342 | 2088365.8404 | 37.7138051716457 | -122.468957974754 | (37.7138051716457, -122.468957974754) | ||||
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) | |||
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) | |||
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) | |||
50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
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) | |||
51446 | 51446 | 249918 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 358 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | Width 0ft | 6011195.29362 | 2120394.33345 | 37.8028292103611 | -122.405449525493 | (37.8028292103611, -122.405449525493) | |||
51583 | 51583 | 249891 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 Greenwich St | 27 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 0ft | 6011455.072819999 | 2120426.06234 | 37.8029308517393 | -122.404552786308 | (37.8029308517393, -122.404552786308) | |||
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) | |||
51644 | 51644 | 249877 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 230 Greenwich St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 39 | Width 0ft | 6011569.83125 | 2120441.49442 | 37.802979637259 | -122.404156747344 | (37.802979637259, -122.404156747344) | |||
52205 | 52205 | 249810 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010696.08755 | 2121019.21593 | 37.804517058874396 | -122.407221117962 | (37.8045170588744, -122.407221117962) | |||
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) | |||
52917 | 52917 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
53610 | 53610 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 2 Allston Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | |||||
53839 | 53839 | 249807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 258 Chestnut St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010752.11734 | 2121021.55825 | 37.8045266258517 | -122.407027386026 | (37.8045266258517, -122.407027386026) | |||
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) | |||
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) | |||
54971 | 54971 | 249878 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 230 Greenwich St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 0ft | 6011550.21069 | 2120457.44752 | 37.803022344253705 | -122.40422576851299 | (37.8030223442537, -122.404225768513) | |||
56133 | 56133 | 249888 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 230 Greenwich St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6011477.22379 | 2120439.43792 | 37.80296881573079 | -122.404477074154 | (37.8029688157308, -122.404477074154) | |||
57451 | 57451 | 249779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6010421.07006 | 2121139.1053400002 | 37.804830850333204 | -122.408181306135 | (37.8048308503332, -122.408181306135) | |||
59239 | 59239 | 249804 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | |||
59360 | 59360 | 207117 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 41 Ralston St | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 19 | 5992170.67066 | 2088214.0686700002 | 37.7133885481037 | -122.46894065558399 | (37.7133885481037, -122.468940655584) | ||||
59769 | 59769 | 239203 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005946.44181 | 2108844.1649 | 37.7708204294492 | -122.42279194121402 | (37.7708204294492, -122.422791941214) | ||||
60490 | 60490 | 239208 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005920.35776 | 2108877.05935 | 37.7709092779754 | -122.42288450484 | (37.7709092779754, -122.42288450484) | ||||
60639 | 60639 | 191813 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 300 Vermont St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 6011137.70759 | 2106686.95849 | 37.7651887659782 | -122.40468325722901 | (37.7651887659782, -122.404683257229) | ||||
60662 | 60662 | 207115 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 47 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992168.43399 | 2088239.2563900002 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | ||||
60765 | 60765 | 195957 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.38857303683399 | (37.7480149542209, -122.388573036834) | ||||
60806 | 60806 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6004001.3006 | 2094332.0064299998 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | ||||
60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
61226 | 61226 | 239216 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005843.543219999 | 2109006.7344400003 | 37.771261000120504 | -122.42315942758499 | (37.7712610001205, -122.423159427585) | ||||
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) | |||
61253 | 61253 | 218150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 35 Ashton Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5994126.47455 | 2090031.2465099997 | 37.7184908913149 | -122.46231247944999 | (37.7184908913149, -122.46231247945) | ||||
61728 | 61728 | 249895 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 230 Greenwich St | 31 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | Width 0ft | 6011395.76102 | 2120447.38073 | 37.8029860719045 | -122.404759538639 | (37.8029860719045, -122.404759538639) | |||
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) | |||
62177 | 62177 | 195962 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | 6015556.6084199995 | 2100333.99599 | 37.7479908676843 | -122.388955626422 | (37.7479908676843, -122.388955626422) | ||||
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) | |||
63607 | 63607 | 191841 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6015067.74656 | 2099262.4877299997 | 37.7450216201491 | -122.39057124226801 | (37.7450216201491, -122.390571242268) | ||||
63852 | 63852 | 239189 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 101 Hwy 101 Northbound | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005983.85034 | 2108958.2836700003 | 37.7711358828561 | -122.422670655046 | (37.7711358828561, -122.422670655046) | ||||
65300 | 65300 | 111749 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 4124 23rd St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | |||||
65985 | 65985 | 195964 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015516.57214 | 2100331.8217700003 | 37.7479826784534 | -122.38909391965001 | (37.7479826784534, -122.38909391965) | ||||
67699 | 67699 | 249892 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 230 Greenwich St | 28 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Width 0ft | 6011427.28959 | 2120425.37078 | 37.80292740013321 | -122.404648882458 | (37.8029274001332, -122.404648882458) | |||
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) | |||
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) | |||
68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
70496 | 70496 | 249782 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 115 Pfeiffer St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6010481.39254 | 2121146.06325 | 37.804853332490296 | -122.40797304381701 | (37.8048533324903, -122.407973043817) | |||
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) |
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");