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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
110545 | 110545 | 64727 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.78428168151439 | -122.410412412425 | (37.7842816815144, -122.410412412425) | ||
116527 | 116527 | 33576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336116998 | (37.7412413768938, -122.41810336117) | |
155873 | 155873 | 218816 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996666.019619999 | 2089250.8609200001 | 37.716494040240796 | -122.45347805498899 | (37.7164940402408, -122.453478054989) | |||
53602 | 53602 | 64963 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.42768042225599 | (37.7999204646826, -122.427680422256) | ||
47489 | 47489 | 224527 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | |||
13913 | 13913 | 26001 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014400.39468 | 2095925.2599900002 | 37.735821239067796 | -122.392645436853 | (37.7358212390678, -122.392645436853) | |||
14200 | 14200 | 26002 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014429.78226 | 2095903.68978 | 37.7357636437757 | -122.392542323281 | (37.7357636437757, -122.392542323281) | |||
16498 | 16498 | 26003 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692501999 | (37.7357217425631, -122.39246692502) | |||
40410 | 40410 | 199435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | |||
137655 | 137655 | 199434 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014431.27107 | 2095902.0652700001 | 37.7357592658851 | -122.39253706224501 | (37.7357592658851, -122.392537062245) | |||
126738 | 126738 | 62357 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 172 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22501 | 6004773.71147679 | 2099613.16071739 | 37.745408029937 | -122.42619115384701 | (37.745408029937, -122.426191153847) | ||
156833 | 156833 | 224526 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | |||
102130 | 102130 | 64725 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.785406080036296 | -122.409096504402 | (37.7854060800363, -122.409096504402) | ||
107287 | 107287 | 61741 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 175 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21746 | 6004036.62237664 | 2100981.15253515 | 37.7491225287463 | -122.428837396831 | (37.7491225287463, -122.428837396831) | ||
17131 | 17131 | 5742 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | |||
21076 | 21076 | 5748 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1770 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 6005291.423690001 | 2098088.82872 | 37.7412518096224 | -122.424292591354 | (37.7412518096224, -122.424292591354) | |||
52254 | 52254 | 65586 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1990 12:00:00 AM | 10 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.39373752768499 | (37.7364462435881, -122.393737527685) | ||
78841 | 78841 | 60152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.47425857753299 | (37.7545373426794, -122.474258577533) | ||
181310 | 181310 | 218840 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 18 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992943.37066 | 2098991.78527 | 37.7430261153754 | -122.467053051482 | (37.7430261153754, -122.467053051482) | |||
85612 | 85612 | 64334 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 18 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25162 | 6004243.25196821 | 2098226.95980835 | 37.7415718437352 | -122.427926638771 | (37.7415718437352, -122.427926638771) | ||
121898 | 121898 | 33589 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 180 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | |||
124532 | 124532 | 53744 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | |||
139021 | 139021 | 61751 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1839 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21762 | 6005280.05550322 | 2107208.06692616 | 37.7662904752312 | -122.424980563467 | (37.7662904752312, -122.424980563467) | ||
107629 | 107629 | 33588 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | |||
138743 | 138743 | 61732 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | ||
76463 | 76463 | 226496 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008684.6321 | 2107591.00428 | 37.767533656488 | -122.413231818694 | (37.767533656488, -122.413231818694) | |||
130967 | 130967 | 226498 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008688.72129 | 2107547.38011 | 37.767414104217295 | -122.41321458949601 | (37.7674141042173, -122.413214589496) | |||
146825 | 146825 | 226495 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008685.7148400005 | 2107616.88585 | 37.767604782056296 | -122.41322990403098 | (37.7676047820563, -122.413229904031) | |||
161713 | 161713 | 226497 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1850 Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008687.35447 | 2107561.73783 | 37.767453450448706 | -122.41322033256 | (37.7674534504487, -122.41322033256) | |||
140873 | 140873 | 93707 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53296 | 6004115.0 | 2118383.0 | 37.7969081825869 | -122.42980742014299 | (37.7969081825869, -122.429807420143) | |||
5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
117709 | 117709 | 61473 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | 24 | Permit Number 21416 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |
128320 | 128320 | 121150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789844996 | -122.42703019928601 | (37.766309789845, -122.427030199286) | |||
175191 | 175191 | 224633 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 196 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6007335.08307 | 2097320.51793 | 37.739257384923704 | -122.41717189426599 | (37.7392573849237, -122.417171894266) | |||
124268 | 124268 | 61474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.766248997560204 | -122.428035576337 | (37.7662489975602, -122.428035576337) | ||
80440 | 80440 | 61710 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1975 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21709 | 6004910.69371619 | 2108330.79575039 | 37.7693523480889 | -122.426338061309 | (37.7693523480889, -122.426338061309) | ||
88721 | 88721 | 62360 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 198 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22505 | 6004608.84494602 | 2099604.09085689 | 37.7453738062021 | -122.426760590215 | (37.7453738062021, -122.426760590215) | ||
38462 | 38462 | 176412 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6000489.461069999 | 2089401.4731400001 | 37.71712601723571 | -122.440273180786 | (37.7171260172357, -122.440273180786) | |||
87287 | 87287 | 65844 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812004 | -122.44475718144301 | (37.798896470812, -122.444757181443) | ||
93578 | 93578 | 63203 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.78070467946971 | -122.496631747831 | (37.7807046794697, -122.496631747831) | ||
9802 | 9802 | 173694 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 201X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011772.0 | 2114653.0 | 37.7870971135768 | -122.40304974212799 | (37.7870971135768, -122.403049742128) | ||||
66232 | 66232 | 224502 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 203 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006664.46693 | 2098372.3341200002 | 37.7421076872335 | -122.41956519440399 | (37.7421076872335, -122.419565194404) | |||
48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
159184 | 159184 | 218819 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.71982234389839 | -122.47173845727801 | (37.7198223438984, -122.471738457278) | |||
85577 | 85577 | 60831 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20604 | 6004778.44666437 | 2102471.31049199 | 37.753256115419504 | -122.426378243722 | (37.7532561154195, -122.426378243722) | ||
44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
115226 | 115226 | 98913 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2088 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | Permit No. 49312 | 6000424.0 | 2115788.0 | 37.7895732892814 | -122.442392720884 | (37.7895732892814, -122.442392720884) | |||
122713 | 122713 | 60714 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 20367 | 6005264.975818 | 2105333.47768938 | 37.761142446432096 | -122.424899339668 | (37.7611424464321, -122.424899339668) | ||
112086 | 112086 | 64333 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 21 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25161 | 6004296.86075631 | 2098199.7784306 | 37.741500242556 | -122.42773934151501 | (37.741500242556, -122.427739341515) | ||
95847 | 95847 | 60832 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 210 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20605 | 6004728.24272246 | 2102435.29497545 | 37.7531543871846 | -122.42654929494499 | (37.7531543871846, -122.426549294945) | ||
26790 | 26790 | 218822 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 210 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | |||
108706 | 108706 | 61139 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.774257127748605 | -122.45166991589599 | (37.7742571277486, -122.451669915896) | ||
125427 | 125427 | 61140 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2132 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | Permit Number 20992 | 5997609.15376905 | 2110265.51143343 | 37.7742491458885 | -122.451733203729 | (37.7742491458885, -122.451733203729) | ||
20372 | 20372 | 65541 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2146 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | Permit Number 28438 | 6002328.18536025 | 2114391.9672646 | 37.78584848917 | -122.43570452929701 | (37.78584848917, -122.435704529297) | ||
91089 | 91089 | 65540 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.78583249572021 | -122.43583034619199 | (37.7858324957202, -122.435830346192) | |
153476 | 153476 | 176418 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 216 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 1ft | 6004075.47639 | 2089186.2671 | 37.7167386279577 | -122.427862706522 | (37.7167386279577, -122.427862706522) | |||
124466 | 124466 | 53067 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | |||
174569 | 174569 | 218806 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 217 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5999893.776380001 | 2094346.53737 | 37.730670094141296 | -122.44268704209 | (37.7306700941413, -122.44268704209) | |||
17973 | 17973 | 61740 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21745 | 6003738.99947337 | 2100964.64707663 | 37.7490603587459 | -122.42986540291099 | (37.7490603587459, -122.429865402911) | ||
101844 | 101844 | 56884 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 219 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14122 | 6003674.18790761 | 2109148.24088129 | 37.771526880372 | -122.430673415548 | (37.771526880372, -122.430673415548) | ||
92014 | 92014 | 103152 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
100915 | 100915 | 103153 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
143912 | 143912 | 103151 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002428.2 | 2119190.0 | 37.799028330156204 | -122.43570190483601 | (37.7990283301562, -122.435701904836) | ||||
95201 | 95201 | 59876 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504483999 | (37.7976647031079, -122.43551504484) | ||
95118 | 95118 | 40081 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | ||||
104502 | 104502 | 33585 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.740543028887295 | -122.418608458082 | (37.7405430288873, -122.418608458082) | |||
70379 | 70379 | 224505 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | |||
46078 | 46078 | 224507 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008190.11914 | 2105143.7552799997 | 37.760786302161996 | -122.414769064951 | (37.760786302162, -122.414769064951) | |||
131453 | 131453 | 224509 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008178.36373 | 2105370.35117 | 37.76140782184 | -122.414825759103 | (37.76140782184, -122.414825759103) | |||
160486 | 160486 | 224508 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008177.844880001 | 2105327.1946400004 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | |||
93681 | 93681 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 768245 | 6003236.0 | 2116309.0 | 37.7911636966224 | -122.43270073645701 | (37.7911636966224, -122.432700736457) | |||
123926 | 123926 | 62428 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 223 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22976 | 6003655.90381046 | 2109145.69391809 | 37.7715188511616 | -122.430736479427 | (37.7715188511616, -122.430736479427) | ||
93573 | 93573 | 66119 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29179 | 6005470.38749546 | 2110092.46405208 | 37.7742210861409 | -122.424527432779 | (37.7742210861409, -122.424527432779) | ||
79935 | 79935 | 52859 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
111594 | 111594 | 52857 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
118250 | 118250 | 52858 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
120604 | 120604 | 52860 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2260on VALLEJO Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.796344678332794 | -122.42333957744499 | (37.7963446783328, -122.423339577445) | |||
108632 | 108632 | 62436 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.226671799 | 2105562.60505464 | 37.7614698277306 | -122.44330409370501 | (37.7614698277306, -122.443304093705) |
111323 | 111323 | 56882 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 228 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22996 | 6003621.30337351 | 2109193.37618724 | 37.7716478146462 | -122.43085956761401 | (37.7716478146462, -122.430859567614) | ||
99208 | 99208 | 56883 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 229 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 14121 | 6003628.47766901 | 2109141.87347388 | 37.7715068072846 | -122.430831075204 | (37.7715068072846, -122.430831075204) | ||
116906 | 116906 | 35391 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1998 12:00:00 AM | Permit Number 38846 | 6003139.07897357 | 2115258.4763002 | 37.7882737292741 | -122.432960994436 | (37.7882737292741, -122.432960994436) | |||
20645 | 20645 | 5358 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004797.6722800005 | 2107012.30465 | 37.765725699015604 | -122.426635095043 | (37.7657256990156, -122.426635095043) | |||
150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
45410 | 45410 | 218818 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 230 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5996994.979669999 | 2089536.5843200001 | 37.7172974217136 | -122.452361618599 | (37.7172974217136, -122.452361618599) | |||
38008 | 38008 | 226494 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008770.52865 | 2104997.0899900002 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | |||
66263 | 66263 | 226492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | |||
175285 | 175285 | 226493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008772.32666 | 2104949.6501700003 | 37.7602860290962 | -122.41274173856002 | (37.7602860290962, -122.41274173856) | |||
137467 | 137467 | 58912 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.650830001 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | ||
92404 | 92404 | 55576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24775 | 6002194.69587728 | 2107036.79090461 | 37.76564542937879 | -122.43563996790199 | (37.7656454293788, -122.435639967902) | ||
171666 | 171666 | 250762 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 231 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985862.1127 | 2114339.7343200003 | 37.7847560253059 | -122.492667897222 | (37.7847560253059, -122.492667897222) | |||
121145 | 121145 | 61711 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 232 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1991 12:00:00 AM | Permit Number 29947 | 6005210.12151982 | 2108247.78406465 | 37.7691413389079 | -122.42529644575501 | (37.7691413389079, -122.425296445755) | ||
109220 | 109220 | 61739 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 232 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21744 | 6003650.07025761 | 2101012.01224764 | 37.749185375985604 | -122.43017629943199 | (37.7491853759856, -122.430176299432) | ||
165442 | 165442 | 224493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | |||
114220 | 114220 | 64019 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2321 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 24776 | 6002140.06473103 | 2107033.66278157 | 37.7656337371655 | -122.435828700932 | (37.7656337371655, -122.435828700932) | ||
118038 | 118038 | 61309 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485558998 | (37.7519317939639, -122.40160485559) | ||
134419 | 134419 | 250765 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 233 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985862.4280199995 | 2114310.4019 | 37.784675505401204 | -122.49266464526 | (37.7846755054012, -122.49266464526) | |||
103549 | 103549 | 60834 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 233 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20607 | 6004786.50329151 | 2102315.79263057 | 37.752829555056 | -122.426339310434 | (37.752829555056, -122.426339310434) | ||
116589 | 116589 | 61310 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2337 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | Permit Number 21209 | 6011897.61971652 | 2101840.97458612 | 37.7519252086186 | -122.4017142423 | (37.7519252086186, -122.4017142423) | ||
72482 | 72482 | 116841 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) |
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");