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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
171157 | 171157 | 176146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 7 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987590.810219999 | 2090334.9259400002 | 37.7189462144818 | -122.48492555458999 | (37.7189462144818, -122.48492555459) | |||
174101 | 174101 | 176141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5987562.65817 | 2089512.7313599999 | 37.7166870365437 | -122.484962576069 | (37.7166870365437, -122.484962576069) | |||
184095 | 184095 | 176151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 12 | : 4 | Tree 1 | Private 1 | 28 | Width 0ft | 5987601.77319 | 2090779.60025 | 37.7201678157831 | -122.484920265686 | (37.7201678157831, -122.484920265686) | |||
25865 | 25865 | 196050 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 10 McLea Ct | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010085.91639 | 2109269.38137 | 37.7722206639802 | -122.408503344349 | (37.7722206639802, -122.408503344349) | |||
38598 | 38598 | 196051 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 10 McLea Ct | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6010059.73194 | 2109243.5905299997 | 37.7721483818683 | -122.408592099356 | (37.7721483818683, -122.408592099356) | |||
64690 | 64690 | 192441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010051.802130001 | 2109236.00979 | 37.7721271227961 | -122.408618994484 | (37.7721271227961, -122.408618994484) | |||
154899 | 154899 | 192442 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010037.847630001 | 2109199.90386 | 37.7720272027263 | -122.408664716903 | (37.7720272027263, -122.408664716903) | |||
155923 | 155923 | 192440 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 McLea Ct | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6010071.610859999 | 2109254.18785 | 37.772178144932205 | -122.40855175667801 | (37.7721781449322, -122.408551756678) | |||
119121 | 119121 | 176115 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Skyline Blvd | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5982387.31367 | 2092831.90061 | 37.7254977881756 | -122.503096467121 | (37.7254977881756, -122.503096467121) | |||
178699 | 178699 | 176116 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Skyline Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5982365.02042 | 2092827.7229400002 | 37.725485007020296 | -122.503173222486 | (37.7254850070203, -122.503173222486) | |||
40108 | 40108 | 232434 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004077.27006 | 2108309.3730900004 | 37.7692463811546 | -122.429219306844 | (37.7692463811546, -122.429219306844) | |||
75787 | 75787 | 232433 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004078.2597199995 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | |||
137261 | 137261 | 222859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004077.69446 | 2108250.00646 | 37.76908339881629 | -122.429213605151 | (37.7690833988163, -122.429213605151) | |||
185707 | 185707 | 232432 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 100 Church St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6004078.65513 | 2108269.95494 | 37.7691382268875 | -122.429211704867 | (37.7691382268875, -122.429211704867) | |||
160244 | 160244 | 201659 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009071.000519999 | 2109601.78003 | 37.7730764624533 | -122.41203753431299 | (37.7730764624533, -122.412037534313) | |||
176463 | 176463 | 201658 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009046.738390001 | 2109625.79413 | 37.773141038252604 | -122.412123157881 | (37.7731410382526, -122.412123157881) | |||
2381 | 2381 | 201818 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021088.08179 | 2093322.4173400002 | 37.7290434795636 | -122.369343396492 | (37.7290434795636, -122.369343396492) | ||
2409 | 2409 | 201824 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 8 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021004.603680001 | 2093212.5880900002 | 37.728737329640495 | -122.369624404053 | (37.7287373296405, -122.369624404053) | ||
2410 | 2410 | 201817 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.36929644199101 | (37.7290887577236, -122.369296441991) | ||
2438 | 2438 | 201823 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Friedell St | 7 | : 4 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021023.85438 | 2093233.10906 | 37.728794732485206 | -122.369559269737 | (37.7287947324852, -122.369559269737) | ||
42599 | 42599 | 190131 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6011654.92131 | 2097288.97497 | 37.7394128516087 | -122.402233521954 | (37.7394128516087, -122.402233521954) | |||
51824 | 51824 | 190130 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6011690.7758 | 2097300.73442 | 37.7394471418669 | -122.40211037869301 | (37.7394471418669, -122.402110378693) | |||
57690 | 57690 | 195191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Industrial St | 8 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6011603.00952 | 2097270.79889 | 37.7393600461416 | -122.402411733411 | (37.7393600461416, -122.402411733411) | |||
58659 | 58659 | 190129 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011744.4272 | 2097318.12593 | 37.739497889703 | -122.401926096826 | (37.739497889703, -122.401926096826) | |||
61191 | 61191 | 190128 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6011796.42353 | 2097334.30265 | 37.7395452093339 | -122.40174745189199 | (37.7395452093339, -122.401747451892) | |||
154576 | 154576 | 190132 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Industrial St | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011496.4373 | 2097233.7856099997 | 37.7392524656321 | -122.402777612703 | (37.7392524656321, -122.402777612703) | |||
29324 | 29324 | 246575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005230.8128 | 2109313.1532400004 | 37.7720677549581 | -122.425300698072 | (37.7720677549581, -122.425300698072) | |||
44765 | 44765 | 246572 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6005238.2187 | 2109262.1859999998 | 37.7719282296287 | -122.42527145302601 | (37.7719282296287, -122.425271453026) | |||
157957 | 157957 | 246573 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005236.998 | 2109273.038 | 37.771957957636 | -122.42527644787701 | (37.771957957636, -122.425276447877) | |||
160036 | 160036 | 246576 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216001 | (37.7721221684335, -122.42531053216) | |||
167170 | 167170 | 246574 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Laguna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005235.59585 | 2109292.2935900004 | 37.7720107496197 | -122.425282668482 | (37.7720107496197, -122.425282668482) | |||
27867 | 27867 | 241239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005928.367769999 | 2109150.09439 | 37.7716594186857 | -122.42287620587601 | (37.7716594186857, -122.422876205876) | |||
150338 | 150338 | 241238 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005908.08699 | 2109147.66491 | 37.771651603561104 | -122.422946185717 | (37.7716516035611, -122.422946185717) | |||
33099 | 33099 | 189852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586948999 | (37.7420414890213, -122.38254586949) | |||
131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
665 | 665 | 239151 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Octavia St | 2 | : 4 | Tree 1 | DPW 2 | 04/15/2017 01:58:00 PM | 3 | Width 4ft | 6005731.03459 | 2109700.90805 | 37.7731606839629 | -122.423597962203 | (37.7731606839629, -122.423597962203) | ||
35585 | 35585 | 239152 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Octavia St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6005729.11778 | 2109714.63204 | 37.773198258533895 | -122.42360556863599 | (37.7731982585339, -122.423605568636) | |||
168224 | 168224 | 237032 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005721.49565 | 2109758.3052 | 37.7733177442556 | -122.423635040324 | (37.7733177442556, -122.423635040324) | |||
171710 | 171710 | 237031 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6005723.44032 | 2109745.94906 | 37.773283927046 | -122.423627434762 | (37.773283927046, -122.423627434762) | |||
51729 | 51729 | 176543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.709616952417704 | -122.468449043003 | (37.7096169524177, -122.468449043003) | |||
60465 | 60465 | 176542 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | |||
161043 | 161043 | 176544 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.46853179230499 | (37.7096104062721, -122.468531792305) | |||
153871 | 153871 | 248805 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 Portola Dr | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5999637.979040001 | 2100901.5310400003 | 37.748653963923104 | -122.444042185502 | (37.7486539639231, -122.444042185502) | |||
31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
130989 | 130989 | 246735 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008576.96579 | 2099053.87477 | 37.744086588741396 | -122.413000530175 | (37.7440865887414, -122.413000530175) | |||
157455 | 157455 | 246734 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008557.46884 | 2099053.26982 | 37.7440838331996 | -122.41306790375299 | (37.7440838331996, -122.413067903753) | |||
183641 | 183641 | 231982 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 100 Rose St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005944.33041 | 2109848.96827 | 37.773579259009296 | -122.422870667843 | (37.7735792590093, -122.422870667843) | |||
24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
152610 | 152610 | 211713 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 100 Tara St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5998129.35341 | 2090944.33961 | 37.7212277153738 | -122.448541965862 | (37.7212277153738, -122.448541965862) | |||
182113 | 182113 | 211714 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 100 Tara St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5998092.2362 | 2090928.9060400003 | 37.7211832160136 | -122.44866915786001 | (37.7211832160136, -122.44866915786) | |||
67045 | 67045 | 193107 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Thornton Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014292.7910400005 | 2094097.73703 | 37.7307972573678 | -122.392889649557 | (37.7307972573678, -122.392889649557) | |||
73075 | 73075 | 194028 | Undocumented 2 | Morus alba :: White Mulberry 112 | 100 Thornton Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014251.11098 | 2094105.2837099999 | 37.7308156638043 | -122.39303427310699 | (37.7308156638043, -122.393034273107) | |||
155233 | 155233 | 193108 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Thornton Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014279.85245 | 2094099.9138200001 | 37.7308025157065 | -122.392934532911 | (37.7308025157065, -122.392934532911) | |||
164439 | 164439 | 234404 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 100 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6006014.35416 | 2108978.5943299998 | 37.771193371997796 | -122.422566584574 | (37.7711933719978, -122.422566584574) | |||
135364 | 135364 | 198121 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Venus St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012854.74593 | 2094309.4604599997 | 37.731298624935 | -122.397876080041 | (37.731298624935, -122.397876080041) | |||
31574 | 31574 | 189607 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1000 06th St | 2 | : 4 | Tree 1 | Private 1 | 25 | Width 3ft | 6011287.74653 | 2111158.98765 | 37.777476320014 | -122.404479121929 | (37.777476320014, -122.404479121929) | |||
164825 | 164825 | 249591 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Ofarrell St | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6006303.7767199995 | 2113904.77053 | 37.7847357815627 | -122.42191544845899 | (37.7847357815627, -122.421915448459) | |||
165556 | 165556 | 249592 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Ofarrell St | 6 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6006270.409519999 | 2113900.7211 | 37.784722780981205 | -122.42203060035601 | (37.7847227809812, -122.422030600356) | |||
183424 | 183424 | 249587 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Ofarrell St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6006408.398130001 | 2113920.93025 | 37.784786051887295 | -122.42155464044399 | (37.7847860518873, -122.421554640444) | |||
133460 | 133460 | 196469 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | |||
150918 | 150918 | 201141 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1001 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015856.48925 | 2101075.72276 | 37.7500441125631 | -122.387970392142 | (37.7500441125631, -122.387970392142) | |||
171020 | 171020 | 201140 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1001 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6015828.93508 | 2101073.29069 | 37.75003590804889 | -122.388065507112 | (37.7500359080489, -122.388065507112) | |||
179011 | 179011 | 201142 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1001 Cesar Chavez St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015889.52196 | 2101077.04798 | 37.7500495813194 | -122.387856254667 | (37.7500495813194, -122.387856254667) | |||
54906 | 54906 | 249573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006042.707780001 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | |||
138690 | 138690 | 249574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Franklin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6006046.96797 | 2113547.6658099997 | 37.78374077347271 | -122.42277853591801 | (37.7837407734727, -122.422778535918) | |||
151674 | 151674 | 249572 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1001 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6006034.21434 | 2113636.62941 | 37.783984326052206 | -122.42282898338999 | (37.7839843260522, -122.42282898339) | |||
60947 | 60947 | 249585 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 Ofarrell St | 7 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6006400.946280001 | 2113866.78963 | 37.7846369748603 | -122.421576574896 | (37.7846369748603, -122.421576574896) | |||
30416 | 30416 | 200396 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1002 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 8ft | 6011347.2117 | 2110977.9345299997 | 37.776982513081606 | -122.404260664891 | (37.7769825130816, -122.404260664891) | |||
42040 | 42040 | 189611 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1002 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 26 | Width 8ft | 6011365.32335 | 2110994.5569 | 37.7770291662965 | -122.40419918094 | (37.7770291662965, -122.40419918094) | |||
61325 | 61325 | 200397 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1002 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 8ft | 6011329.81075 | 2110961.2977 | 37.7769358598445 | -122.404319689205 | (37.7769358598445, -122.404319689205) | |||
169752 | 169752 | 200398 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1002 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011294.34101 | 2110930.16137 | 37.7768483845726 | -122.404440198365 | (37.7768483845726, -122.404440198365) | |||
59533 | 59533 | 196133 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1007 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6011938.93616 | 2103592.2223099996 | 37.7567360569294 | -122.401694443163 | (37.7567360569294, -122.401694443163) | |||
67279 | 67279 | 193841 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 9 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011580.56119 | 2099671.3344 | 37.745950149498206 | -122.40265811977801 | (37.7459501494982, -122.402658119778) | |||
69011 | 69011 | 193837 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011567.15169 | 2099585.96693 | 37.7457150001509 | -122.40269848585599 | (37.7457150001509, -122.402698485856) | |||
71970 | 71970 | 193833 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011558.06967 | 2099515.9514900004 | 37.7455222457662 | -122.40272496729999 | (37.7455222457662, -122.4027249673) | |||
71990 | 71990 | 193839 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011572.75268 | 2099621.60996 | 37.745813180944296 | -122.402681624471 | (37.7458131809443, -122.402681624471) | |||
72270 | 72270 | 193838 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011570.05157 | 2099605.03725 | 37.7457675250463 | -122.402689799314 | (37.7457675250463, -122.402689799314) | |||
147468 | 147468 | 193835 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011562.1176 | 2099553.35249 | 37.7456251668608 | -122.402713599879 | (37.7456251668608, -122.402713599879) | |||
161088 | 161088 | 193834 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6011560.322819999 | 2099537.83926 | 37.7455824706665 | -122.402718715209 | (37.7455824706665, -122.402718715209) | |||
166309 | 166309 | 193840 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 8 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011575.20658 | 2099640.5422900002 | 37.7458653020467 | -122.40267447034901 | (37.7458653020467, -122.402674470349) | |||
171256 | 171256 | 193836 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011563.86564 | 2099569.70024 | 37.745670151857 | -122.402708704842 | (37.745670151857, -122.402708704842) | |||
64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
65062 | 65062 | 201810 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021035.70856 | 2093179.8039900002 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | |||
178920 | 178920 | 201812 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.728774126326705 | -122.369414113788 | (37.7287741263267, -122.369414113788) | |||
62085 | 62085 | 228898 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 101 Haight St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005584.45074 | 2109588.27771 | 37.7728431531072 | -122.424097004096 | (37.7728431531072, -122.424097004096) | |||
55228 | 55228 | 241080 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 101 Liberty St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005619.68617 | 2103990.3409599997 | 37.7574745370504 | -122.423577052054 | (37.7574745370504, -122.423577052054) | |||
135053 | 135053 | 241081 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 101 Liberty St | 7 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005622.17025 | 2103990.2230700003 | 37.7574743535663 | -122.42356845271999 | (37.7574743535663, -122.42356845272) | |||
156521 | 156521 | 241079 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 101 Liberty St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005617.25057 | 2103990.21088 | 37.7574740424027 | -122.423585466096 | (37.7574740424027, -122.423585466096) | |||
25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
32657 | 32657 | 189845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017192.34248 | 2098175.05438 | 37.7421533862633 | -122.383149023221 | (37.7421533862633, -122.383149023221) | |||
33190 | 33190 | 189849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.742023306530704 | -122.38283152746 | (37.7420233065307, -122.38283152746) | |||
38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
60830 | 60830 | 189847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017231.39271 | 2098158.2223400003 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | |||
131320 | 131320 | 189846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | |||
131495 | 131495 | 189850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017345.725190001 | 2098082.05897 | 37.7419065142755 | -122.382612199015 | (37.7419065142755, -122.382612199015) | |||
132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
137584 | 137584 | 189851 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.741879938402704 | -122.38256267332198 | (37.7418799384027, -122.382562673322) | |||
147716 | 147716 | 189842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017136.0861599995 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | |||
157361 | 157361 | 189848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6017264.73109 | 2098137.17538 | 37.7420533780644 | -122.38289608801 | (37.7420533780644, -122.38289608801) |
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");