Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, PlotSize
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
160807 | 160807 | 119174 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 738 La Playa | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5980754.24139 | 2110680.27075 | 37.7744082353086 | -122.51006716089898 | (37.7744082353086, -122.510067160899) | |||
56572 | 56572 | 119176 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 742 La Playa | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.51005897992701 | (37.7743417237871, -122.510058979927) | |||
137577 | 137577 | 119173 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 738 La Playa | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5980756.1033 | 2110688.30545 | 37.774430406044296 | -122.510061317362 | (37.7744304060443, -122.510061317362) | |||
154259 | 154259 | 119175 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 742 La Playa | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | |||
153493 | 153493 | 118477 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 562 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5981021.8691 | 2111857.25612 | 37.7776556713315 | -122.509228826135 | (37.7776556713315, -122.509228826135) | |||
67642 | 67642 | 118478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981024.51617 | 2111800.84509 | 37.7775009394111 | -122.509215478972 | (37.7775009394111, -122.509215478972) | |||
171429 | 171429 | 118684 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 684 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5981039.03921 | 2111092.68807 | 37.775557405741296 | -122.50911264072799 | (37.7755574057413, -122.509112640728) | |||
130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
75998 | 75998 | 118388 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981070.6492099995 | 2111666.32883 | 37.7771343173465 | -122.50904590130502 | (37.7771343173465, -122.509045901305) | |||
43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
38238 | 38238 | 118387 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 5640 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981104.69221 | 2111668.01683 | 37.7771409589636 | -122.508928263307 | (37.7771409589636, -122.508928263307) | |||
55803 | 55803 | 184166 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4236 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981109.472999999 | 2104203.4487 | 37.7566457055131 | -122.508357497572 | (37.7566457055131, -122.508357497572) | |||
167206 | 167206 | 184171 | Undocumented 2 | :: 54 | 4230 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981117.7231 | 2104203.7543 | 37.7566470308009 | -122.50832898893499 | (37.7566470308009, -122.508328988935) | |||
26507 | 26507 | 184509 | Undocumented 2 | :: 54 | 1886 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.5546 | 2102268.3878 | 37.751333525850896 | -122.50815826243401 | (37.7513335258509, -122.508158262434) | |||
49859 | 49859 | 184504 | Undocumented 2 | :: 54 | 1878 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981125.892999999 | 2102290.0468 | 37.751393015279 | -122.50815869964501 | (37.751393015279, -122.508158699645) | |||
179798 | 179798 | 184537 | Undocumented 2 | :: 54 | 1920 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981149.921 | 2101972.2688 | 37.750521902570604 | -122.50805202692601 | (37.7505219025706, -122.508052026926) | |||
158911 | 158911 | 184170 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4218 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981166.9182 | 2104206.8099 | 37.7566583196438 | -122.508159084297 | (37.7566583196438, -122.508159084297) | |||
185376 | 185376 | 184529 | Undocumented 2 | :: 54 | 1996 Lower Great Hwy | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981188.5011 | 2101512.3535 | 37.7492613780766 | -122.50788448891899 | (37.7492613780766, -122.507884488919) | |||
149914 | 149914 | 118489 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 8301 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 5981241.64042 | 2112313.06401 | 37.778920139734 | -122.508502421445 | (37.778920139734, -122.508502421445) | ||||
171774 | 171774 | 184177 | Undocumented 2 | :: 54 | 1605 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981248.1823 | 2104131.4737 | 37.7564562562261 | -122.507872457928 | (37.7564562562261, -122.507872457928) | |||
156187 | 156187 | 119139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 549 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981289.11687 | 2111973.6044900003 | 37.777990882347495 | -122.508312980233 | (37.7779908823475, -122.508312980233) | |||
65517 | 65517 | 118496 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5981338.85751 | 2112308.63433 | 37.778913706323294 | -122.508165785879 | (37.7789137063233, -122.508165785879) | ||||
41260 | 41260 | 118860 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 576 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5981340.34297 | 2111809.65905 | 37.7775437552953 | -122.508123602786 | (37.7775437552953, -122.508123602786) | |||
56451 | 56451 | 184388 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2029 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5981345.698 | 2101255.1529 | 37.7485644381752 | -122.507321829204 | (37.7485644381752, -122.507321829204) | |||
43770 | 43770 | 184492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1834 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981345.8672 | 2102562.8148 | 37.7521549190758 | -122.50741825242399 | (37.7521549190758, -122.507418252424) | |||
66359 | 66359 | 184389 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2029 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5981347.0517 | 2101245.0003 | 37.7485366417249 | -122.507316395084 | (37.7485366417249, -122.507316395084) | |||
164877 | 164877 | 184508 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1882 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5981355.6814 | 2102272.4489 | 37.7513582344641 | -122.507362772913 | (37.7513582344641, -122.507362772913) | |||
61119 | 61119 | 118495 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5981356.12189 | 2112314.02701 | 37.7789295303469 | -122.50810646292601 | (37.7789295303469, -122.508106462926) | ||||
135577 | 135577 | 118871 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 698 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5981367.8022 | 2111011.73635 | 37.7753545127722 | -122.507969380926 | (37.7753545127722, -122.507969380926) | |||
161637 | 161637 | 118494 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981369.73448 | 2112312.23583 | 37.778925414411 | -122.508059239406 | (37.778925414411, -122.508059239406) | ||||
3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
185011 | 185011 | 184464 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2149 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981372.6025 | 2100411.6366 | 37.746249963664496 | -122.50716622744899 | (37.7462499636645, -122.507166227449) | |||
24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
66054 | 66054 | 184481 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2010 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5981385.9702 | 2101354.3105 | 37.748839069126895 | -122.507189926089 | (37.7488390691269, -122.507189926089) | |||
131294 | 131294 | 118493 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981395.17159 | 2112311.03986 | 37.7789236294482 | -122.507971155072 | (37.7789236294482, -122.507971155072) | ||||
122548 | 122548 | 184411 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2086 48th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5981402.2144 | 2100888.6421 | 37.747561431181005 | -122.507099214622 | (37.747561431181, -122.507099214622) | |||
162773 | 162773 | 184410 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2086 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5981403.9065 | 2100879.8432 | 37.747537371526704 | -122.507092710919 | (37.7475373715267, -122.507092710919) | |||
159866 | 159866 | 118492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981407.0833 | 2112311.43925 | 37.7789254278995 | -122.50792997809401 | (37.7789254278995, -122.507929978094) | ||||
136210 | 136210 | 118491 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981413.1487300005 | 2112317.48344 | 37.7789423808296 | -122.507909444403 | (37.7789423808296, -122.507909444403) | ||||
173511 | 173511 | 184452 | Undocumented 2 | :: 54 | 2142 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981413.7208 | 2100483.5512 | 37.746449842726896 | -122.507029381635 | (37.7464498427269, -122.507029381635) | |||
131217 | 131217 | 184172 | Undocumented 2 | :: 54 | 4145 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981416.401000001 | 2104160.656 | 37.7565462922692 | -122.507292873512 | (37.7565462922692, -122.507292873512) | |||
164146 | 164146 | 184474 | Undocumented 2 | :: 54 | 2186 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981423.3658 | 2100215.0135 | 37.745713081334 | -122.506976114504 | (37.745713081334, -122.506976114504) | |||
55807 | 55807 | 184469 | Undocumented 2 | :: 54 | 2182 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981423.7042 | 2100234.3036 | 37.74576606648579 | -122.506976375045 | (37.7457660664858, -122.506976375045) | |||
137303 | 137303 | 184371 | Undocumented 2 | :: 54 | 2282 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981448.1763 | 2099546.5215 | 37.7438790499345 | -122.506840749339 | (37.7438790499345, -122.506840749339) | |||
116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
135799 | 135799 | 183114 | Undocumented 2 | :: 54 | 3650 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981483.4357 | 2099456.1026 | 37.7436328611158 | -122.506712127755 | (37.7436328611158, -122.506712127755) | |||
166159 | 166159 | 184283 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4305 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5981502.2697 | 2104846.193 | 37.7584336388865 | -122.50704676639799 | (37.7584336388865, -122.507046766398) | |||
69046 | 69046 | 184284 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4303 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 5981511.742000001 | 2104845.8874 | 37.758433357655605 | -122.507013984876 | (37.7584333576556, -122.507013984876) | |||
52825 | 52825 | 183106 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3634 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981552.8121 | 2099457.4563 | 37.7436406629553 | -122.50647234563 | (37.7436406629553, -122.50647234563) | |||
95413 | 95413 | 118419 | Undocumented 2 | :: 54 | 5507 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5981562.4785 | 2111629.449 | 37.7770620385939 | -122.507341801673 | (37.7770620385939, -122.507341801673) | ||||
41918 | 41918 | 184186 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1651 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5981569.4938 | 2103830.3301 | 37.7556483274352 | -122.50673893378 | (37.7556483274352, -122.50673893378) | |||
721 | 721 | 183636 | Planning Code 138.1 required 4 | Pittosporum crassifolium :: Karo Tree 108 | 1478 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 3x9 | 5981570.9282 | 2105017.3718 | 37.7589076903569 | -122.506822015648 | (37.7589076903569, -122.506822015648) | |||
73677 | 73677 | 184188 | Undocumented 2 | :: 54 | 1659 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981571.3272 | 2103786.0218 | 37.7555267773851 | -122.506729307239 | (37.7555267773851, -122.506729307239) | |||
162586 | 162586 | 183640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | |||
45706 | 45706 | 183641 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1484 47th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981572.5337 | 2105003.3239 | 37.7588692133791 | -122.50681542120701 | (37.7588692133791, -122.506815421207) | |||
54992 | 54992 | 184123 | Undocumented 2 | :: 54 | 1566 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981590.4236 | 2104415.5069999998 | 37.7572562892484 | -122.50670995310101 | (37.7572562892484, -122.506709953101) | |||
154522 | 154522 | 118420 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5501 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5981593.2087199995 | 2111630.13422 | 37.7770657300516 | -122.507235548964 | (37.7770657300516, -122.507235548964) | |||
72291 | 72291 | 118632 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 349 Point Lobos Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5981625.79815 | 2112645.61268 | 37.779855853566104 | -122.507198167376 | (37.7798558535661, -122.507198167376) | |||
75715 | 75715 | 118633 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 349 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5981626.779 | 2112628.37676 | 37.7798085866006 | -122.507193495207 | (37.7798085866006, -122.507193495207) | |||
185931 | 185931 | 118627 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981628.0956 | 2112437.91019 | 37.7792856992778 | -122.50717480668301 | (37.7792856992778, -122.507174806683) | |||
152283 | 152283 | 183227 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2195 Rivera St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5981630.51 | 2100140.1073 | 37.745519606830705 | -122.50625429931699 | (37.7455196068307, -122.506254299317) | |||
24438 | 24438 | 118836 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 600 46th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5981651.25866 | 2111619.12831 | 37.77703893001029 | -122.50703392298401 | (37.7770389300103, -122.507033922984) | |||
138086 | 138086 | 183226 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2195 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5981653.3594 | 2100141.3946 | 37.7455244865409 | -122.50617538646401 | (37.7455244865409, -122.506175386464) | |||
187944 | 187944 | 118504 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981658.42687 | 2112320.40323 | 37.778964846285 | -122.507061160796 | (37.778964846285, -122.507061160796) | ||||
150011 | 150011 | 118509 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5981667.13897 | 2112328.15893 | 37.778986654236796 | -122.50703159815599 | (37.7789866542368, -122.507031598156) | ||||
186889 | 186889 | 183225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2195 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5981668.485 | 2100141.7164 | 37.7455262605285 | -122.506123109259 | (37.7455262605285, -122.506123109259) | |||
42085 | 42085 | 118832 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981668.99425 | 2111312.2373200003 | 37.7761973421342 | -122.506949801153 | (37.7761973421342, -122.506949801153) | |||
62769 | 62769 | 118833 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981669.33859 | 2111307.2969 | 37.776183797471795 | -122.50694824345501 | (37.7761837974718, -122.506948243455) | |||
26210 | 26210 | 118831 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 662 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981671.941000001 | 2111218.67307 | 37.775940615740105 | -122.50693266579799 | (37.7759406157401, -122.506932665798) | |||
157178 | 157178 | 118505 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5981673.9598 | 2112320.77936 | 37.7789667938181 | -122.50700745501499 | (37.7789667938181, -122.507007455015) | ||||
63831 | 63831 | 118508 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5981683.08089 | 2112327.67528 | 37.778986265140794 | -122.506976413729 | (37.7789862651408, -122.506976413729) | ||||
131000 | 131000 | 118506 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5981691.49804 | 2112321.6795900003 | 37.7789702984457 | -122.50694685106899 | (37.7789702984457, -122.506946851069) | ||||
169865 | 169865 | 251005 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 342 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5981698.04635 | 2112709.85802 | 37.7800365073085 | -122.506953000187 | (37.7800365073085, -122.506953000187) | |||
27677 | 27677 | 118507 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981701.912719999 | 2112329.1151099997 | 37.7789913275143 | -122.506911374832 | (37.7789913275143, -122.506911374832) | ||||
177760 | 177760 | 184363 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2251 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981706.71 | 2099767.9271 | 37.7445021893581 | -122.50596322728998 | (37.7445021893581, -122.50596322729) | |||
27686 | 27686 | 118503 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5981708.0026 | 2112322.43934 | 37.7789733564528 | -122.506889812546 | (37.7789733564528, -122.506889812546) | ||||
36998 | 36998 | 184372 | Undocumented 2 | :: 54 | 2263 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981709.435 | 2099687.8805 | 37.7442825640676 | -122.50594787141 | (37.7442825640676, -122.50594787141) | |||
168574 | 168574 | 184154 | Undocumented 2 | :: 54 | 4036 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981710.2029 | 2104227.1296 | 37.756746110874296 | -122.506281748334 | (37.7567461108743, -122.506281748334) | |||
22945 | 22945 | 104992 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 2423 47TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 10 | 2x6 | Permit Number 775156 | 5981729.7 | 2098576.9 | 37.74123331264771 | -122.505795454359 | (37.7412333126477, -122.505795454359) | |
36154 | 36154 | 184467 | Undocumented 2 | :: 54 | 2182 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981733.5294 | 2100249.3634 | 37.7458256579494 | -122.50590617914699 | (37.7458256579494, -122.505906179147) | |||
149169 | 149169 | 184505 | Undocumented 2 | :: 54 | 3940 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981746.2202 | 2102187.1666 | 37.751147069673706 | -122.506005945548 | (37.7511470696737, -122.506005945548) | |||
188366 | 188366 | 184365 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2246 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5981748.9474 | 2099793.4739 | 37.7445748198756 | -122.505819075039 | (37.7445748198756, -122.505819075039) | |||
158169 | 158169 | 183195 | Undocumented 2 | :: 54 | 2467 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981757.2189 | 2098306.9914 | 37.740493837912396 | -122.505680301686 | (37.7404938379124, -122.505680301686) | |||
178952 | 178952 | 183207 | Undocumented 2 | :: 54 | 2487 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981762.9721 | 2098176.699 | 37.7401364295663 | -122.505650753582 | (37.7401364295663, -122.505650753582) | |||
28995 | 28995 | 183156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2354 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 5981775.1553 | 2099067.0868 | 37.7425819051481 | -122.50567461791901 | (37.7425819051481, -122.505674617919) | |||
129927 | 129927 | 118433 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 5428 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5981776.05342 | 2111693.4588 | 37.7772503684982 | -122.506607740669 | (37.7772503684982, -122.506607740669) | |||
166331 | 166331 | 183265 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1249 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5981784.0294 | 2106586.8909 | 37.7632296873576 | -122.50620140465901 | (37.7632296873576, -122.506201404659) | |||
177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
130272 | 130272 | 182923 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2615 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981792.4148 | 2097276.497 | 37.7376664555995 | -122.50548224533199 | (37.7376664555995, -122.505482245332) | |||
147904 | 147904 | 183186 | Undocumented 2 | :: 54 | 2446 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.1527 | 2098421.378 | 37.740810262110294 | -122.505550705456 | (37.7408102621103, -122.505550705456) | |||
181678 | 181678 | 182929 | Undocumented 2 | :: 54 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.737295543609996 | -122.50545409100799 | (37.73729554361, -122.505454091008) | |||
189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
137654 | 137654 | 182938 | Undocumented 2 | :: 54 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | |||
56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
163381 | 163381 | 118557 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8100 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981820.409519999 | 2112394.33685 | 37.7791773847362 | -122.506506292125 | (37.7791773847362, -122.506506292125) | |||
71678 | 71678 | 118556 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 8100 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5981834.606430001 | 2112394.66752 | 37.7791791285364 | -122.506457204565 | (37.7791791285364, -122.506457204565) | |||
35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
180164 | 180164 | 183139 | Undocumented 2 | :: 54 | 3539 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981846.5394 | 2099413.7013 | 37.7435378134359 | -122.505453483048 | (37.7435378134359, -122.505453483048) | |||
147162 | 147162 | 182943 | Undocumented 2 | :: 54 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) |
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");