Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 881 | 881 | 251399 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008927.4869099995 | 2120274.72498 | 37.802373734427796 | -122.413288863041 | (37.8023737344278, -122.413288863041) | ||||
| 1705 | 1705 | 251397 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 311 Townsend St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 5520 | 5520 | 37970 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40200 | ||||||||
| 9698 | 9698 | 173643 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 657 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
| 9737 | 9737 | 173681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 125 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010317.0 | 2099454.0 | 37.7452827689443 | -122.40701204748301 | (37.7452827689443, -122.407012047483) | ||||
| 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) | ||||
| 9891 | 9891 | 173730 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 387 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999535.0 | 2094919.0 | 37.7322214835803 | -122.443968498715 | (37.7322214835803, -122.443968498715) | ||||
| 17857 | 17857 | 66830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.43895374638201 | (37.7575293253254, -122.438953746382) | ||
| 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) | ||
| 17978 | 17978 | 59647 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.770549162658895 | -122.43004409806002 | (37.7705491626589, -122.43004409806) | |
| 19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 19840 | 19840 | 60045 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.43092567098101 | (37.7714947633279, -122.430925670981) | ||
| 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) | ||
| 20649 | 20649 | 33653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | |||
| 30530 | 30530 | 101433 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 49595 | 49595 | 33663 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.878255201 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | |||
| 50097 | 50097 | 62304 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2504 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | Permit Number 22442 | 5997225.79467532 | 2110840.29768365 | 37.7758053966105 | -122.45310080621901 | (37.7758053966105, -122.453100806219) | ||
| 51250 | 51250 | 99287 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6000564.2 | 2116779.0 | 37.7923023065947 | -122.44197880493999 | (37.7923023065947, -122.44197880494) | |||||
| 53251 | 53251 | 94021 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432.0 | 2099002.0 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | ||
| 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) | ||
| 54632 | 54632 | 61750 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) | ||
| 56265 | 56265 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 94 | 953 Indiana St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6015057.1 | 2104275.7 | 37.758786250670205 | -122.39095836980302 | (37.7587862506702, -122.390958369803) | |||||
| 64064 | 64064 | 60829 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 82 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20508 | 6004586.81845905 | 2101649.91280729 | 37.7509899147675 | -122.42698243599199 | (37.7509899147675, -122.426982435992) | ||
| 71516 | 71516 | 60144 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.47448257143101 | (37.7577595366377, -122.474482571431) | ||
| 76129 | 76129 | 48040 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 77427 | 77427 | 32868 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601704996 | -122.430300092251 | (37.736503601705, -122.430300092251) | |||
| 77451 | 77451 | 31969 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.725219944905895 | -122.40926189775499 | (37.7252199449059, -122.409261897755) | |||
| 77562 | 77562 | 62653 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 250 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1986 12:00:00 AM | Permit Number 22975 | 6003520.74083492 | 2109179.36788903 | 37.771603653022794 | -122.431206419247 | (37.7716036530228, -122.431206419247) | ||
| 78071 | 78071 | 54520 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | |||
| 78100 | 78100 | 104437 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005464.0 | 2111103.0 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | |||||
| 78322 | 78322 | 33615 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.42604905489999 | (37.7741722139784, -122.4260490549) | |||
| 78837 | 78837 | 61705 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 57 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21704 | 6005150.34156307 | 2107947.67774505 | 37.768313941532604 | -122.42548186081999 | (37.7683139415326, -122.42548186082) | ||
| 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) | ||
| 79146 | 79146 | 110117 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 160x PFEIFFER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010076.0 | 2121146.0 | 37.8048304537654 | -122.409375949631 | (37.8048304537654, -122.409375949631) | ||||
| 79197 | 79197 | 34147 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 79346 | 79346 | 63166 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | ||
| 79447 | 79447 | 66438 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.43101802993601 | (37.7753887478808, -122.431018029936) | ||
| 79724 | 79724 | 48785 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 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) | |||
| 79998 | 79998 | 115675 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | |||||
| 79999 | 79999 | 34142 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 400 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1997 12:00:00 AM | Permit Number 37990 | 6008524.65557539 | 2106230.12436926 | 37.7637880127631 | -122.41368889061701 | (37.7637880127631, -122.413688890617) | ||
| 80250 | 80250 | 67152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | ||
| 80356 | 80356 | 67032 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141362997 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | |||
| 80426 | 80426 | 34158 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 80439 | 80439 | 99116 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 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) | ||
| 80543 | 80543 | 48790 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1405 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | ||
| 80600 | 80600 | 65894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 649 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.799327449486704 | -122.40980081755501 | (37.7993274494867, -122.409800817555) | ||
| 80869 | 80869 | 30892 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
| 81288 | 81288 | 30534 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 81299 | 81299 | 62352 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 102 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.745500157100295 | -122.424658053081 | (37.7455001571003, -122.424658053081) | ||
| 81391 | 81391 | 59350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 97 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23892 | 6007961.12301785 | 2099994.21526918 | 37.7466339645312 | -122.41519653416599 | (37.7466339645312, -122.415196534166) | ||
| 81439 | 81439 | 39879 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 301 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | |||
| 81461 | 81461 | 30532 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 81512 | 81512 | 33580 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | |||
| 81536 | 81536 | 63412 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 832 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23995 | 6007544.46590294 | 2095494.67209225 | 37.7342557904854 | -122.41631865277901 | (37.7342557904854, -122.416318652779) | ||
| 82018 | 82018 | 67095 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.40821208958799 | (37.7428561528472, -122.408212089588) | ||
| 82331 | 82331 | 65673 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | ||
| 83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 83249 | 83249 | 60838 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | ||
| 83369 | 83369 | 66220 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | ||
| 83414 | 83414 | 61716 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21716 | 6004986.55656035 | 2108182.89626107 | 37.7689505396343 | -122.426065124893 | (37.7689505396343, -122.426065124893) | ||
| 83657 | 83657 | 107775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | |||||
| 83747 | 83747 | 111387 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014036.0 | 2112699.0 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | ||||
| 83797 | 83797 | 60434 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 461 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | Permit Number 24099 | 6003594.47944671 | 2098910.74347696 | 37.7434126315981 | -122.43021864419201 | (37.7434126315981, -122.430218644192) | ||
| 83967 | 83967 | 61715 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 281 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1984 12:00:00 AM | Permit Number 21715 | 6004926.94134289 | 2108179.4823523 | 37.7689377963385 | -122.42627108706002 | (37.7689377963385, -122.42627108706) | ||
| 83973 | 83973 | 35231 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | |||
| 84474 | 84474 | 33816 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1201 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.791339665663294 | -122.414142270961 | (37.7913396656633, -122.414142270961) | |||
| 84518 | 84518 | 101285 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1236 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11316 | 5993350.8 | 2107040.7 | 37.7651498684815 | -122.466229094974 | (37.7651498684815, -122.466229094974) | |||
| 84615 | 84615 | 64894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1450 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1989 12:00:00 AM | Permit Number 25920 | 6005836.52150612 | 2100535.66309095 | 37.7480010261231 | -122.42258166386499 | (37.7480010261231, -122.422581663865) | ||
| 84789 | 84789 | 57103 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3743 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20509 | 6004792.79553424 | 2102485.90723803 | 37.7532970057744 | -122.426329661558 | (37.7532970057744, -122.426329661558) | ||
| 85104 | 85104 | 98237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 85375 | 85375 | 98530 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 701X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991613.7 | 2110635.6 | 37.77492011755329 | -122.472499350726 | (37.7749201175533, -122.472499350726) | ||||
| 85453 | 85453 | 117227 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1009 HARRISON ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x10 | 6011058.0 | 2110680.0 | 37.776148288994705 | -122.405240157274 | (37.7761482889947, -122.405240157274) | ||||
| 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) | ||
| 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) | ||
| 85639 | 85639 | 66379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 625 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29504 | 6003563.84234841 | 2110464.21135378 | 37.7751339598215 | -122.431149051781 | (37.7751339598215, -122.431149051781) | ||
| 86230 | 86230 | 114016 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009320.0 | 2104474.0 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | ||||
| 86321 | 86321 | 62088 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 474 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | Permit Number 22174 | 6013214.9408475 | 2104861.98073646 | 37.7602936588903 | -122.397370564655 | (37.7602936588903, -122.397370564655) | ||
| 86369 | 86369 | 48037 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | |||
| 86479 | 86479 | 61708 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 580 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1984 12:00:00 AM | Permit Number 21707 | 6004928.75046121 | 2107826.22237424 | 37.767967931643 | -122.426239675726 | (37.767967931643, -122.426239675726) | ||
| 86617 | 86617 | 61763 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 390 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21777 | 6005479.130443 | 2106713.50276565 | 37.764943762720705 | -122.424256822517 | (37.7649437627207, -122.424256822517) | ||
| 87072 | 87072 | 60836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 253 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20609 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | ||
| 87079 | 87079 | 63899 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 719 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1987 12:00:00 AM | Permit Number 24609 | 6002042.34774334 | 2110925.77664223 | 37.776314966213896 | -122.43644527379699 | (37.7763149662139, -122.436445273797) | ||
| 87183 | 87183 | 34152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.794049371853106 | -122.394334961669 | (37.7940493718531, -122.394334961669) | |||
| 87279 | 87279 | 99175 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 300x BEACH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008712.0 | 2122248.0 | 37.8077797512209 | -122.414174245084 | (37.8077797512209, -122.414174245084) | ||||
| 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) | ||
| 87335 | 87335 | 63397 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.759226666669505 | -122.437077536949 | (37.7592266666695, -122.437077536949) | ||
| 87598 | 87598 | 101431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | ||||
| 87662 | 87662 | 60839 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.42628647311301 | (37.7522506515925, -122.426286473113) | ||
| 87713 | 87713 | 107997 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2X Clover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6000451.13785 | 2105044.8413 | 37.760076841062 | -122.441527580895 | (37.760076841062, -122.441527580895) | ||||
| 87790 | 87790 | 32047 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 88123 | 88123 | 97191 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 255 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | |||
| 88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 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) | ||
| 88976 | 88976 | 99115 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1200x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011163.0 | 2119066.0 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | ||||
| 89083 | 89083 | 60549 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) |
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");