Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3087 | 3087 | 19650 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 4862 | 4862 | 19656 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 55 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 5896 | 5896 | 19680 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 5976 | 5976 | 19649 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 6914 | 6914 | 19672 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7103 | 7103 | 19675 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7153 | 7153 | 19677 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 7446 | 7446 | 19683 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9546 | 9546 | 19678 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 77 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 9875 | 9875 | 19651 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 10475 | 10475 | 19661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12748 | 12748 | 19671 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14057 | 14057 | 19674 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 73 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 14729 | 14729 | 19657 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 15686 | 15686 | 19660 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 16120 | 16120 | 19653 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 STAIRWAY5 | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 36323 | 36323 | 182757 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1768 31st Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5986603.8813 | 2103201.6608 | 37.7542173383784 | -122.489282448699 | (37.7542173383784, -122.489282448699) | |||
| 152916 | 152916 | 182758 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1762 31st Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986605.2662 | 2103225.2032 | 37.7542820602368 | -122.48927939027 | (37.7542820602368, -122.48927939027) | |||
| 75991 | 75991 | 182754 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5986605.2662 | 2103133.3419 | 37.7540298341253 | -122.489272636653 | (37.7540298341253, -122.489272636653) | |||
| 25006 | 25006 | 182753 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1788 31st Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5986606.1894 | 2103114.4157 | 37.753977921823 | -122.489268052608 | (37.753977921823, -122.489268052608) | |||
| 178619 | 178619 | 182752 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1790 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5986608.9591 | 2103091.7966 | 37.7539159776066 | -122.48925681152599 | (37.7539159776066, -122.489256811526) | |||
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 52315 | 52315 | 120312 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 160 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5988698.92527 | 2114284.33233 | 37.784769373123005 | -122.482849516634 | (37.784769373123, -122.482849516634) | |||
| 84641 | 84641 | 118343 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 162 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988772.0 | 2114277.0 | 37.784753492132104 | -122.48259616764 | (37.7847534921321, -122.48259616764) | ||||
| 98034 | 98034 | 106401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x6 | 5988976.53234 | 2115004.21174 | 37.786762106623705 | -122.481941850779 | (37.7867621066237, -122.481941850779) | |||
| 31839 | 31839 | 108738 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5x6 | 5988982.34798 | 2115051.76356 | 37.786893008658296 | -122.481925214884 | (37.7868930086583, -122.481925214884) | |||
| 53672 | 53672 | 108737 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x6 | 5988982.16462 | 2115033.23873 | 37.786842134064706 | -122.481924491754 | (37.7868421340647, -122.481924491754) | |||
| 139042 | 139042 | 108739 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 22 22ND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x6 | 5989006.7 | 2115022.6 | 37.786814349999105 | -122.48183882646299 | (37.7868143499991, -122.481838826463) | ||||
| 97915 | 97915 | 121201 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 423 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990242.0 | 2112483.0 | 37.7799130778564 | -122.477379347216 | (37.7799130778564, -122.477379347216) | ||||
| 51360 | 51360 | 110401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.779877404965504 | -122.4772748837 | (37.7798774049655, -122.4772748837) | ||
| 176523 | 176523 | 121988 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 528 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5991288.02079 | 2111782.83574 | 37.778051257453704 | -122.473709641027 | (37.7780512574537, -122.473709641027) | |||
| 20112 | 20112 | 29963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991394.8537099995 | 2093447.95886 | 37.7277146673841 | -122.47200336878099 | (37.7277146673841, -122.472003368781) | ||
| 181793 | 181793 | 206291 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500x Junipero Serra Blvd | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991445.95006 | 2094262.4550299998 | 37.7299540269465 | -122.471886066612 | (37.7299540269465, -122.471886066612) | |||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 160018 | 160018 | 206274 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 130 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 10ft | 5992348.03804 | 2095988.5894400002 | 37.7347457173231 | -122.468893032011 | (37.7347457173231, -122.468893032011) | |||
| 128360 | 128360 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 155 BORICA ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992696.0 | 2092292.5 | 37.724617268406604 | -122.467421338179 | (37.7246172684066, -122.467421338179) | |||||
| 60209 | 60209 | 124039 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 737 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 5993203.99509 | 2114811.08925 | 37.7864767964616 | -122.467301904185 | (37.7864767964616, -122.467301904185) | |||
| 44606 | 44606 | 206273 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 335 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5992818.8463 | 2096062.89914 | 37.734976942936 | -122.46727070178301 | (37.734976942936, -122.467270701783) | |||
| 41921 | 41921 | 206270 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 10ft | 5993141.97199 | 2095936.7158400002 | 37.7346491229581 | -122.46614438456801 | (37.7346491229581, -122.466144384568) | |||
| 42087 | 42087 | 206272 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 70 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 10ft | 5993269.28362 | 2097133.14802 | 37.7379415715549 | -122.46579112907 | (37.7379415715549, -122.46579112907) | |||
| 162695 | 162695 | 206275 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 531 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 8ft | 5993329.29471 | 2096110.62255 | 37.735137433227294 | -122.465509381364 | (37.7351374332273, -122.465509381364) | |||
| 94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 102914 | 102914 | 112377 | Property Tree 7 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 48470 | 48470 | 206295 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1289 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5993598.25468 | 2106726.01097 | 37.76430008921321 | -122.465350355136 | (37.7643000892132, -122.465350355136) | |||
| 142623 | 142623 | 101243 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1299X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993606.4 | 2106666.6 | 37.7641374320151 | -122.465317867129 | (37.7641374320151, -122.465317867129) | ||||
| 104962 | 104962 | 97215 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 20 | 4x12 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||
| 118995 | 118995 | 97217 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 4 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 18 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | ||||
| 143072 | 143072 | 97216 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300X Claremont Blvd | 3 | Back Yard : Cutout 16 | Tree 1 | DPW for City Agency 10 | 5993486.0 | 2098110.3 | 37.7406370848463 | -122.465112792055 | (37.7406370848463, -122.465112792055) | |||||
| 137222 | 137222 | 206278 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 121 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 2ft | 5993596.441240001 | 2102535.31336 | 37.7527934164816 | -122.46505223798701 | (37.7527934164816, -122.465052237987) | |||
| 33604 | 33604 | 206271 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1510 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5993525.3861 | 2095199.14432 | 37.7326460476786 | -122.46476525891899 | (37.7326460476786, -122.464765258919) | |||
| 158289 | 158289 | 206296 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1495 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993533.84781 | 2095106.3143799999 | 37.7323916474557 | -122.464729266269 | (37.7323916474557, -122.464729266269) | |||
| 96285 | 96285 | 96780 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1502X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x50 | 5993551.4 | 2095180.8 | 37.732597178480894 | -122.4646739916 | (37.7325971784809, -122.4646739916) | |||
| 123678 | 123678 | 97297 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 450 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994062.8 | 2112448.2 | 37.7800384821655 | -122.46415907596202 | (37.7800384821655, -122.464159075962) | |||||
| 136459 | 136459 | 123281 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 06th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5994069.81611 | 2112666.40035 | 37.7806380059293 | -122.464150649226 | (37.7806380059293, -122.464150649226) | |||
| 33400 | 33400 | 123284 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 06th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5994067.51233 | 2112489.4392 | 37.780151985503004 | -122.46414576865699 | (37.780151985503, -122.464145768657) | |||
| 28943 | 28943 | 206276 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1575 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 5993975.596059999 | 2104757.26291 | 37.758916173673605 | -122.463902332454 | (37.7589161736736, -122.463902332454) | |||
| 166171 | 166171 | 123313 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5994324.87447 | 2112727.37957 | 37.7808201355721 | -122.46327271312599 | (37.7808201355721, -122.463272713126) | |||
| 156619 | 156619 | 123312 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994326.95545 | 2112691.62436 | 37.7807220812689 | -122.46326291878201 | (37.7807220812689, -122.463262918782) | |||
| 166280 | 166280 | 123309 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994326.71646 | 2112582.77127 | 37.7804231861892 | -122.463255844547 | (37.7804231861892, -122.463255844547) | |||
| 35053 | 35053 | 123308 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994328.16527 | 2112546.87269 | 37.7803247018036 | -122.46324822682399 | (37.7803247018036, -122.463248226824) | |||
| 157434 | 157434 | 206269 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 576 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5994053.8446 | 2099403.66341 | 37.744221064358705 | -122.463243244477 | (37.7442210643587, -122.463243244477) | |||
| 43433 | 43433 | 123307 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5994333.67454 | 2112494.59894 | 37.7801814895167 | -122.46322537368 | (37.7801814895167, -122.46322537368) | |||
| 69722 | 69722 | 123306 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401 05th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5994336.05737 | 2112465.72885 | 37.7801023572772 | -122.463215034991 | (37.7801023572772, -122.463215034991) | |||
| 66055 | 66055 | 206268 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 576 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 6ft | 5994062.286309999 | 2099409.86302 | 37.74423857324471 | -122.463214504856 | (37.7442385732447, -122.463214504856) | |||
| 127278 | 127278 | 206267 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 576 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 5994070.0708800005 | 2099419.58791 | 37.7442657237995 | -122.46318829319901 | (37.7442657237995, -122.463188293199) | |||
| 129571 | 129571 | 206277 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 6ft | 5994075.53376 | 2096720.2997299999 | 37.73685446745821 | -122.46297360255801 | (37.7368544674582, -122.462973602558) | |||
| 78803 | 78803 | 105667 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | |||||
| 85276 | 85276 | 105668 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | 5994306.4 | 2092922.0 | 37.726438562961896 | -122.461900058607 | (37.7264385629619, -122.461900058607) | ||||
| 70753 | 70753 | 206290 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 519 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/1989 12:00:00 AM | 13 | Width 3ft | Permit Number 28366 | 5994747.213769999 | 2092021.25084 | 37.7239906908132 | -122.460310960879 | (37.7239906908132, -122.460310960879) | |
| 134942 | 134942 | 123506 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2630 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 8ft | 5995210.5755199995 | 2110304.28467 | 37.774217945514 | -122.460033072871 | (37.774217945514, -122.460033072871) | |||
| 51352 | 51352 | 206266 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1217 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5995764.33389 | 2107222.76394 | 37.76578872620429 | -122.457894496039 | (37.7657887262043, -122.457894496039) | |||
| 152750 | 152750 | 206265 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5995764.11125 | 2107172.86823 | 37.765651712687394 | -122.45789165508002 | (37.7656517126874, -122.45789165508) | |||
| 10033 | 10033 | 54506 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 5x5 | Permit Number 10300 | 5995769.71808299 | 2107217.0895637 | 37.7657734551651 | -122.457875462722 | (37.7657734551651, -122.457875462722) | ||
| 129818 | 129818 | 206264 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1235 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5995769.52537 | 2107097.9044 | 37.7654461924254 | -122.45786750379101 | (37.7654461924254, -122.457867503791) | |||
| 55567 | 55567 | 206292 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1275 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5995766.39546 | 2106910.95096 | 37.764932686723 | -122.457864799544 | (37.764932686723, -122.457864799544) | |||
| 65730 | 65730 | 206293 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1283 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5995766.93118 | 2106868.2316900003 | 37.7648154214066 | -122.457859855072 | (37.7648154214066, -122.457859855072) | |||
| 53297 | 53297 | 206294 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1291 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5995770.00748 | 2106810.2745 | 37.7646564626472 | -122.457845020728 | (37.7646564626472, -122.457845020728) | |||
| 86521 | 86521 | 54509 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1291 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 6x5 | Permit Number 10303 | 5995784.13645716 | 2106797.98257299 | 37.7646235238936 | -122.457795263133 | (37.7646235238936, -122.457795263133) | ||
| 38508 | 38508 | 206297 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 565 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5996520.85452 | 2095770.92684 | 37.7343882701062 | -122.454450538684 | (37.7343882701062, -122.454450538684) | |||
| 157373 | 157373 | 246154 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1730 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997434.1745 | 2108152.8339 | 37.768438254928704 | -122.45218601649401 | (37.7684382549287, -122.452186016494) | |||
| 146060 | 146060 | 106499 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 420X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997462.73555 | 2109001.92463 | 37.770771276139705 | -122.452148498658 | (37.7707712761397, -122.452148498658) | |||||
| 67715 | 67715 | 248403 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1713 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997457.4924 | 2108113.6175 | 37.7683319124677 | -122.452102532521 | (37.7683319124677, -122.452102532521) | |||
| 149232 | 149232 | 244110 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997524.2657 | 2108863.6995 | 37.7703952699374 | -122.451925692038 | (37.7703952699374, -122.451925692038) | |||
| 41887 | 41887 | 248497 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 114 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997504.128 | 2107818.662 | 37.7675247113964 | -122.45191994324699 | (37.7675247113964, -122.451919943247) | |||
| 84347 | 84347 | 106497 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772114 | 5997541.6 | 2108881.8 | 37.770445962098705 | -122.451867038975 | (37.7704459620987, -122.451867038975) | ||||
| 180713 | 180713 | 244109 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997547.3781 | 2108866.1758 | 37.770403393000606 | -122.45184592528099 | (37.7704033930006, -122.451845925281) | |||
| 177148 | 177148 | 248496 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 0ft | 5997529.2628 | 2107821.3875 | 37.7675336345309 | -122.451833202371 | (37.7675336345309, -122.451833202371) | |||
| 149297 | 149297 | 248615 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 446 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997626.0167 | 2107489.4868 | 37.7666278609206 | -122.451474603078 | (37.7666278609206, -122.451474603078) | |||
| 41393 | 41393 | 248493 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 748 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997645.2464 | 2107858.3326 | 37.7676417185294 | -122.451434697353 | (37.7676417185294, -122.451434697353) | |||
| 155601 | 155601 | 248526 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 75 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997669.6241 | 2107795.1927 | 37.7674697483814 | -122.451345824031 | (37.7674697483814, -122.451345824031) | |||
| 131150 | 131150 | 248583 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 832 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997671.8953 | 2107653.4687 | 37.7670807404856 | -122.45132774569099 | (37.7670807404856, -122.451327745691) | |||
| 150366 | 150366 | 246155 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1644 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997687.6425 | 2108190.0819 | 37.768555044956 | -122.45131198438801 | (37.768555044956, -122.451311984388) | |||
| 144172 | 144172 | 117163 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 832 SHRADER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997697.0 | 2107652.0 | 37.767078145258004 | -122.45124080685899 | (37.767078145258, -122.451240806859) | ||||
| 187024 | 187024 | 248372 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1609 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997820.1302 | 2108164.6442 | 37.768492784741895 | -122.450851888359 | (37.7684927847419, -122.450851888359) | |||
| 164518 | 164518 | 248513 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 23 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997819.2217 | 2107818.3592 | 37.767541922496 | -122.450830059129 | (37.767541922496, -122.450830059129) | |||
| 55714 | 55714 | 107425 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | |||||
| 40266 | 40266 | 246174 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1602 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5997866.0088 | 2108213.3997 | 37.768629281127296 | -122.45069671469 | (37.7686292811273, -122.45069671469) |
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");