Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69728 | 69728 | 125437 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.44406922002199 | (37.8045448847905, -122.444069220022) | |||
| 56342 | 56342 | 125442 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3719 Scott St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6000612.64349 | 2121133.3219999997 | 37.8042608824853 | -122.442123892024 | (37.8042608824853, -122.442123892024) | |||
| 170392 | 170392 | 125444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6002146.17897 | 2121077.47724 | 37.8041948227854 | -122.436812979831 | (37.8041948227854, -122.436812979831) | |||
| 49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) | |
| 35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
| 160138 | 160138 | 125525 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | |||
| 75383 | 75383 | 125524 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011207.6846199995 | 2120726.9389400003 | 37.8037431562814 | -122.40543008395201 | (37.8037431562814, -122.405430083952) | |||
| 137536 | 137536 | 249818 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284601996 | -122.40653352599399 | (37.803542284602, -122.406533525994) | |||
| 154615 | 154615 | 249823 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | |||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 167284 | 167284 | 125445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | |||
| 39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | |||
| 46865 | 46865 | 249820 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.40647720057301 | (37.8034168633488, -122.406477200573) | |||
| 136884 | 136884 | 125446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003103.6015800005 | 2120772.6345599997 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | |||
| 70954 | 70954 | 125443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2298 Beach St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999265.80635 | 2120844.85189 | 37.8033919746241 | -122.446763941418 | (37.8033919746241, -122.446763941418) | |||
| 177222 | 177222 | 125447 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005068.7625400005 | 2120514.19483 | 37.8028138607435 | -122.426659015206 | (37.8028138607435, -122.426659015206) | |||
| 162716 | 162716 | 125448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | |||
| 165596 | 165596 | 125497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6006282.866880001 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | |||
| 67240 | 67240 | 125498 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | |||
| 100438 | 100438 | 97940 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 114838 | 114838 | 97942 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 141972 | 141972 | 97941 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 143236 | 143236 | 97939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 491 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010516.0 | 2120277.0 | 37.802469036850205 | -122.407791962119 | (37.8024690368502, -122.407791962119) | |||||
| 71919 | 71919 | 125496 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6006063.84143 | 2120339.6871599997 | 37.802390914060204 | -122.42320311664899 | (37.8023909140602, -122.423203116649) | |||
| 45984 | 45984 | 125495 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006051.2199 | 2120336.9264 | 37.802382621428706 | -122.423246597049 | (37.8023826214287, -122.423246597049) | |||
| 35121 | 35121 | 125494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | |||
| 149835 | 149835 | 125493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006021.473809999 | 2120333.6545700002 | 37.8023719590496 | -122.42334930055401 | (37.8023719590496, -122.423349300554) | |||
| 172117 | 172117 | 125492 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006010.16913 | 2120331.72981 | 37.8023660361287 | -122.42338828343901 | (37.8023660361287, -122.423388283439) | |||
| 76694 | 76694 | 125491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6005994.09185 | 2120329.4714599997 | 37.8023589278732 | -122.42344375814599 | (37.8023589278732, -122.423443758146) | |||
| 184444 | 184444 | 66783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.755609999 | 2120327.60903 | 37.80235300495529 | -122.42349323614799 | (37.8023530049553, -122.423493236148) | |
| 153001 | 153001 | 92753 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.7877700003 | 37.802166375831106 | -122.446615526285 | (37.8021663758311, -122.446615526285) | |
| 131923 | 131923 | 125440 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.44342510578801 | (37.8021484793247, -122.443425105788) | |||
| 148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
| 24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
| 133037 | 133037 | 249983 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.40401748554301 | (37.8020985894405, -122.404017485543) | |||
| 48362 | 48362 | 125504 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6007489.69173 | 2120199.0729400003 | 37.8020851859507 | -122.418258985774 | (37.8020851859507, -122.418258985774) | |||
| 161839 | 161839 | 125503 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6007472.5485 | 2120196.7006200003 | 37.802077707171605 | -122.418318141382 | (37.8020777071716, -122.418318141382) | |||
| 70754 | 70754 | 249984 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | |||
| 150526 | 150526 | 125502 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6007468.42884 | 2120195.8771599997 | 37.8020752142594 | -122.41833233898701 | (37.8020752142594, -122.418332338987) | |||
| 183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) | |||
| 45739 | 45739 | 249986 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | |||
| 159610 | 159610 | 249987 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | |||
| 61458 | 61458 | 249988 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.802054326596206 | -122.404084315938 | (37.8020543265962, -122.404084315938) | |||
| 35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
| 184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
| 61770 | 61770 | 249991 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.802049668108396 | -122.404102989475 | (37.8020496681084, -122.404102989475) | |||
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 74131 | 74131 | 249946 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011346.83837 | 2120055.6582400003 | 37.801907763181205 | -122.404901241218 | (37.8019077631812, -122.404901241218) | |||
| 41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
| 148756 | 148756 | 249948 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820376998 | (37.8018992421182, -122.40492820377) | |||
| 63040 | 63040 | 249939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 331 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.801856051265204 | -122.40512593233 | (37.8018560512652, -122.40512593233) | |||
| 49008 | 49008 | 125522 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1087 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6007750.4574 | 2119887.81691 | 37.8012452299295 | -122.417334539369 | (37.8012452299295, -122.417334539369) | |||
| 55076 | 55076 | 125501 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1115 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6007553.747280001 | 2119514.62481 | 37.8002094690578 | -122.417988773678 | (37.8002094690578, -122.417988773678) | |||
| 22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
| 159071 | 159071 | 125499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007355.47144 | 2119286.0885099997 | 37.799570804701396 | -122.418658671469 | (37.7995708047014, -122.418658671469) | ||||
| 149721 | 149721 | 125500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.41895432719299 | (37.7995302219096, -122.418954327193) | ||||
| 7088 | 7088 | 107943 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | |||
| 34959 | 34959 | 104356 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | ||
| 45092 | 45092 | 64967 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.799065794014396 | -122.42697920982201 | (37.7990657940144, -122.426979209822) | |
| 49868 | 49868 | 125509 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6008633.29576 | 2119030.27082 | 37.7989402522368 | -122.41421881477301 | (37.7989402522368, -122.414218814773) | |||
| 102425 | 102425 | 125510 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008630.57528 | 2119029.65242 | 37.79893840145329 | -122.41422818478901 | (37.7989384014533, -122.414228184789) | |||
| 47885 | 47885 | 125511 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008625.76186 | 2119029.2242099997 | 37.7989369553212 | -122.41424481055799 | (37.7989369553212, -122.414244810558) | |||
| 178396 | 178396 | 125512 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008620.72695 | 2119028.05639 | 37.7989334659598 | -122.414262150401 | (37.7989334659598, -122.414262150401) | |||
| 74953 | 74953 | 125514 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008590.31929 | 2119027.3925900003 | 37.7989299352366 | -122.414367324317 | (37.7989299352366, -122.414367324317) | |||
| 35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
| 182144 | 182144 | 125516 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008584.50737 | 2119027.0667 | 37.798928713939205 | -122.414387412476 | (37.7989287139392, -122.414387412476) | |||
| 35686 | 35686 | 125515 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | |||
| 67817 | 67817 | 125519 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008571.89831 | 2119026.74658 | 37.798927126643896 | -122.414431021472 | (37.7989271266439, -122.414431021472) | |||
| 172712 | 172712 | 125518 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008573.08581 | 2119026.43144 | 37.7989263280573 | -122.414426890005 | (37.7989263280573, -122.414426890005) | |||
| 134395 | 134395 | 125517 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008575.41519 | 2119026.3782099998 | 37.7989263127569 | -122.414418825785 | (37.7989263127569, -122.414418825785) | |||
| 30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
| 184003 | 184003 | 125521 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6008568.41134 | 2119026.0619799998 | 37.7989250510158 | -122.414443039112 | (37.7989250510158, -122.414443039112) | |||
| 48809 | 48809 | 125436 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3157 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001892.570830001 | 2119015.7946 | 37.798519569189 | -122.437542875929 | (37.798519569189, -122.437542875929) | |||
| 183063 | 183063 | 34667 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.0104900002 | 37.798287972172396 | -122.43244168475799 | (37.7982879721724, -122.432441684758) | ||
| 40273 | 40273 | 125508 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6008930.4214699995 | 2118571.4914 | 37.797697242591504 | -122.41315819931299 | (37.7976972425915, -122.413158199313) | |||
| 41654 | 41654 | 125506 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6008920.97468 | 2118571.47788 | 37.7976966751291 | -122.413190886946 | (37.7976966751291, -122.413190886946) | |||
| 151252 | 151252 | 125507 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.41317615966801 | (37.7976958234636, -122.413176159668) | |||
| 175422 | 175422 | 113957 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | ||
| 156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
| 73300 | 73300 | 125461 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1845 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6004195.45414 | 2118342.0241799997 | 37.7968002290978 | -122.42952610606399 | (37.7968002290978, -122.429526106064) | |||
| 44709 | 44709 | 125485 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6007640.9414 | 2118138.07584 | 37.796434716745 | -122.417589429708 | (37.796434716745, -122.417589429708) | ||||
| 174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
| 164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
| 80090 | 80090 | 32128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | ||
| 8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
| 34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
| 92731 | 92731 | 32134 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 138919 | 138919 | 32133 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
| 79612 | 79612 | 32135 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
| 104718 | 104718 | 32136 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
| 134317 | 134317 | 125539 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 31 Spofford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6010570.5264 | 2117382.56278 | 37.794524670939204 | -122.407399099212 | (37.7945246709392, -122.407399099212) | |||
| 155868 | 155868 | 125451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001095.19419 | 2117566.7818299998 | 37.7944955940578 | -122.44019807567499 | (37.7944955940578, -122.440198075675) | |||
| 143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
| 51714 | 51714 | 125450 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.79409854965171 | -122.44069290604999 | (37.7940985496517, -122.44069290605) | |||
| 173529 | 173529 | 125459 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002302.24315 | 2117372.6414900003 | 37.7940311814406 | -122.436007644151 | (37.7940311814406, -122.436007644151) | |||
| 150229 | 150229 | 125458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.794018309436396 | -122.436069543591 | (37.7940183094364, -122.436069543591) | |||
| 153719 | 153719 | 125456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.79395665014079 | -122.436691221543 | (37.7939566501408, -122.436691221543) | |||
| 131618 | 131618 | 125455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002099.50591 | 2117347.8348 | 37.7939515491883 | -122.436707358076 | (37.7939515491883, -122.436707358076) | |||
| 157035 | 157035 | 125454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002093.86703 | 2117345.7842200003 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) |
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");