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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177880 | 177880 | 248404 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1713 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997468.9999 | 2108115.1317 | 37.768336729240296 | -122.452062838629 | (37.7683367292403, -122.452062838629) | |||
| 18803 | 18803 | 17128 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2003 12:00:00 AM | 12 | 3X3 | 5997486.4463 | 2109152.9695 | 37.7711873646815 | -122.452077382727 | (37.7711873646815, -122.452077382727) | ||
| 169803 | 169803 | 141307 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 61 COOK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997486.7259 | 2113348.6561 | 37.7827076436193 | -122.452379230189 | (37.7827076436193, -122.452379230189) | |||
| 67720 | 67720 | 94860 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2161 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6x4 | 5997487.0021 | 2110201.3474 | 37.7740659715368 | -122.452151115771 | (37.7740659715368, -122.452151115771) | |||
| 18301 | 18301 | 17129 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1999 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997503.109 | 2109154.2513 | 37.7711918386222 | -122.452019838592 | (37.7711918386222, -122.452019838592) | |||
| 172810 | 172810 | 246165 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1700 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997526.8402 | 2108168.581 | 37.7684868003121 | -122.45186663191299 | (37.7684868003121, -122.451866631913) | |||
| 20349 | 20349 | 10509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1792 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5997587.0634 | 2108527.2635 | 37.7694750996845 | -122.45168420313499 | (37.7694750996845, -122.451684203135) | |||
| 17644 | 17644 | 17126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1971 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997587.7043 | 2109167.9232 | 37.7712342233691 | -122.45172820804599 | (37.7712342233691, -122.451728208046) | |||
| 175500 | 175500 | 140682 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21366 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997596.5061 | 2110261.2804 | 37.7742368042101 | -122.451776648803 | (37.7742368042101, -122.451776648803) | |||
| 29189 | 29189 | 140683 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21288 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997608.0859 | 2110262.8359 | 37.774241738407795 | -122.451736704617 | (37.7742417384078, -122.451736704617) | |||
| 21861 | 21861 | 17124 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1959 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997650.0826 | 2109175.1865 | 37.7712577387998 | -122.451512964016 | (37.7712577387998, -122.451512964016) | |||
| 17174 | 17174 | 17123 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1949 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997679.9901 | 2109179.4590000003 | 37.7712711825876 | -122.451409821439 | (37.7712711825876, -122.451409821439) | |||
| 60986 | 60986 | 248611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 862 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997689.6108 | 2107534.9111 | 37.7667562259025 | -122.45125791953001 | (37.7667562259025, -122.45125791953) | |||
| 48254 | 48254 | 248610 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 872 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997691.4278 | 2107516.4386 | 37.7667056091614 | -122.4512503025 | (37.7667056091614, -122.4512503025) | |||
| 53929 | 53929 | 140264 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2100X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997701.9343 | 2110276.144 | 37.7742836533846 | -122.451413027686 | (37.7742836533846, -122.451413027686) | |||
| 182156 | 182156 | 246388 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997718.8338 | 2108194.9271 | 37.768570134567206 | -122.45120444629801 | (37.7685701345672, -122.451204446298) | |||
| 19773 | 19773 | 17120 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1931 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997753.4769 | 2109191.4219 | 37.7713082373467 | -122.45115649157499 | (37.7713082373467, -122.451156491575) | |||
| 47229 | 47229 | 246151 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1622 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997783.0336 | 2108202.195 | 37.7685937659628 | -122.450982909765 | (37.7685937659628, -122.450982909765) | |||
| 77095 | 77095 | 248383 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997789.5444 | 2108160.7074 | 37.7684802243505 | -122.450957397559 | (37.7684802243505, -122.450957397559) | |||
| 72703 | 72703 | 244544 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1921 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997795.9759 | 2109196.9758 | 37.7713259200895 | -122.451009886929 | (37.7713259200895, -122.451009886929) | |||
| 74916 | 74916 | 248371 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997803.1717 | 2108162.5244 | 37.7684859935016 | -122.45091039318199 | (37.7684859935016, -122.450910393182) | |||
| 147110 | 147110 | 248373 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997837.6943 | 2108167.0669 | 37.768500442306106 | -122.45079131066002 | (37.7685004423061, -122.45079131066) | |||
| 18594 | 18594 | 17117 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1907 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5997844.0536 | 2109200.8214 | 37.771339231452 | -122.45084386213101 | (37.771339231452, -122.450843862131) | |||
| 171426 | 171426 | 140142 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 208 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997849.5605 | 2109871.4122 | 37.773180816519606 | -122.450873174815 | (37.7731808165196, -122.450873174815) | |||
| 57125 | 57125 | 140141 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 210 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997851.4768 | 2109847.2667 | 37.7731146288991 | -122.450864804769 | (37.7731146288991, -122.450864804769) | |||
| 35453 | 35453 | 246043 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997853.8956 | 2108495.9392 | 37.7694043689932 | -122.450758987128 | (37.7694043689932, -122.450758987128) | |||
| 166904 | 166904 | 244543 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1901 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997870.5431 | 2109205.9484 | 37.7713548252376 | -122.45075260390301 | (37.7713548252376, -122.450752603903) | |||
| 2923 | 2923 | 140143 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1981 12:00:00 AM | 9 | Width 0ft | Permit Number 19125 | 5997871.2148 | 2109901.8816 | 37.7732657172386 | -122.45080046745001 | (37.7732657172386, -122.45080046745) | |
| 183117 | 183117 | 246173 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 675 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997888.1153 | 2108243.3798 | 37.768712864196 | -122.45062241217899 | (37.768712864196, -122.450622412179) | |||
| 2909 | 2909 | 140144 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997892.6775 | 2109904.5645 | 37.7732743123753 | -122.450726418895 | (37.7732743123753, -122.450726418895) | |||
| 131399 | 131399 | 248376 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997900.3799 | 2108160.4046 | 37.7684857374838 | -122.45057400725 | (37.7684857374838, -122.45057400725) | |||
| 52969 | 52969 | 248377 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997902.4997 | 2108143.1434 | 37.7684384639657 | -122.45056543049401 | (37.7684384639657, -122.450565430494) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 2908 | 2908 | 140145 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.45065770078699 | (37.7732838718856, -122.450657700787) | |||
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 42222 | 42222 | 244167 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 443 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997917.5884 | 2109065.1071 | 37.7709708040394 | -122.450579717232 | (37.7709708040394, -122.450579717232) | |||
| 2910 | 2910 | 140146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997931.7703 | 2109910.6967 | 37.773293387477395 | -122.450591634422 | (37.7732933874774, -122.450591634422) | |||
| 183850 | 183850 | 248348 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997944.2901 | 2108144.5061 | 37.7684445974615 | -122.45042098016701 | (37.7684445974615, -122.450420980167) | |||
| 185767 | 185767 | 248349 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1589 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997958.0688 | 2108183.1168 | 37.7685514011761 | -122.450376104779 | (37.7685514011761, -122.450376104779) | |||
| 19853 | 19853 | 17115 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997963.2561 | 2109219.1931 | 37.7713964984716 | -122.450432861809 | (37.7713964984716, -122.450432861809) | |||
| 38886 | 38886 | 248350 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997973.5131 | 2108185.8423 | 37.7685597685915 | -122.45032288098899 | (37.7685597685915, -122.450322880989) | |||
| 21997 | 21997 | 17116 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1899 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997981.6278 | 2109222.6111 | 37.771406934874896 | -122.450369559944 | (37.7714069348749, -122.450369559944) | |||
| 35119 | 35119 | 248351 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1587 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997991.38 | 2108188.2649 | 37.7685674429378 | -122.450261255818 | (37.7685674429378, -122.450261255818) | |||
| 52833 | 52833 | 244023 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997999.7197 | 2108815.8239 | 37.7702910368595 | -122.45027765199801 | (37.7702910368595, -122.450277651998) | |||
| 59210 | 59210 | 244027 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 510 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998001.7833 | 2108800.966 | 37.7702503589654 | -122.45026944288 | (37.7702503589654, -122.45026944288) | |||
| 17479 | 17479 | 17114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1889X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998005.981000001 | 2109225.1746 | 37.7714153673222 | -122.45028550625 | (37.7714153673222, -122.45028550625) | |||
| 161008 | 161008 | 248352 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1585 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998007.43 | 2108190.3847 | 37.7685741818657 | -122.450205893283 | (37.7685741818657, -122.450205893283) | |||
| 69466 | 69466 | 66825 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2047 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | 9 | Permit Number 30121 | 5998040.6169 | 2109928.3267 | 37.77334802445179 | -122.450216391954 | (37.7733480244518, -122.450216391954) | |
| 18214 | 18214 | 17113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1875 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5998056.3964 | 2109231.5833 | 37.7714358490518 | -122.45011157971099 | (37.7714358490518, -122.450111579711) | |||
| 165925 | 165925 | 248346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1575 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998065.2703 | 2108198.2582 | 37.7685991103156 | -122.45000639696 | (37.7685991103156, -122.45000639696) | |||
| 162322 | 162322 | 66562 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 144 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1991 12:00:00 AM | 5 | Permit Number 29750 | 5998095.4621 | 2113585.8052 | 37.783393648613796 | -122.45029037155099 | (37.7833936486138, -122.450290371551) | |
| 17820 | 17820 | 17112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1855 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998114.9295 | 2109242.2645 | 37.7714685261947 | -122.449909881636 | (37.7714685261947, -122.449909881636) | |||
| 167539 | 167539 | 248335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1559 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998127.3503 | 2108207.3431 | 37.768627607196 | -122.449792323102 | (37.768627607196, -122.449792323102) | |||
| 177206 | 177206 | 246136 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1556 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998150.3653 | 2108253.3731 | 37.768755310607 | -122.449716033907 | (37.768755310607, -122.449716033907) | |||
| 5763 | 5763 | 107346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | |||
| 129813 | 129813 | 248337 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1539 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998178.2256 | 2108213.3997 | 37.7686471477417 | -122.449616786829 | (37.7686471477417, -122.449616786829) | |||
| 173968 | 173968 | 246089 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 29 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998181.8595 | 2108411.1471 | 37.7691903195921 | -122.449618468841 | (37.7691903195921, -122.449618468841) | |||
| 21538 | 21538 | 10477 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1649 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998216.9877 | 2108565.5899 | 37.7696163897252 | -122.449508092743 | (37.7696163897252, -122.449508092743) | |||
| 24010 | 24010 | 248469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 145 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998248.1791 | 2107933.2828 | 37.7678820197346 | -122.449354639507 | (37.7678820197346, -122.449354639507) | |||
| 175857 | 175857 | 140293 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 135 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998254.8738 | 2110151.3644 | 37.773972687525 | -122.449491324786 | (37.773972687525, -122.449491324786) | |||
| 165188 | 165188 | 62369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.773911796453596 | -122.44947832162799 | (37.7739117964536, -122.449478321628) | |
| 152460 | 152460 | 62957 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 159 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1986 12:00:00 AM | 12 | Permit Number 23343 | 5998260.9157 | 2110109.071 | 37.7738569063547 | -122.449467376934 | (37.7738569063547, -122.449467376934) | ||
| 55285 | 55285 | 140295 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 155 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998263.3874 | 2110087.9243 | 37.773798984347295 | -122.449457302972 | (37.7737989843473, -122.449457302972) | |||
| 4243 | 4243 | 246126 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998264.228999999 | 2108270.3316 | 37.768808388052605 | -122.449323411621 | (37.7688083880526, -122.449323411621) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 135048 | 135048 | 55105 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 219 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11004 | 5998291.6539 | 2109868.1545 | 37.7731971698727 | -122.44934368775 | (37.7731971698727, -122.44934368775) | |
| 154058 | 154058 | 248533 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 174 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998320.7066 | 2107735.9897 | 37.7673444513971 | -122.449089561777 | (37.7673444513971, -122.449089561777) | |||
| 17018 | 17018 | 4509 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1807X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998320.8634 | 2109271.3175 | 37.7715600792218 | -122.44919964223699 | (37.7715600792218, -122.449199642237) | |||
| 18044 | 18044 | 4510 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1805X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5998343.9349 | 2109273.4537 | 37.7715672642721 | -122.449119990901 | (37.7715672642721, -122.449119990901) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 131916 | 131916 | 248363 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1503 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998433.2076 | 2108248.225 | 37.7687573531744 | -122.44873733691401 | (37.7687573531744, -122.448737336914) | |||
| 4223 | 4223 | 246149 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998439.5671 | 2108294.2551 | 37.7688841037799 | -122.44871865576 | (37.7688841037799, -122.44871865576) | |||
| 50460 | 50460 | 244192 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 529 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998441.2408 | 2108808.2865 | 37.7702955988047 | -122.448749895574 | (37.7702955988047, -122.448749895574) | |||
| 135352 | 135352 | 244193 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 531 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998442.5226 | 2108797.1780000003 | 37.7702651709945 | -122.44874466162099 | (37.7702651709945, -122.448744661621) | |||
| 171623 | 171623 | 141660 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 16 LOYOLA TER | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998448.6735 | 2110841.7689 | 37.775879445116104 | -122.448870682731 | (37.7758794451161, -122.448870682731) | |||
| 49751 | 49751 | 141659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 16 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998449.6222 | 2110830.3835 | 37.7758482379963 | -122.44886658065799 | (37.7758482379963, -122.448866580658) | |||
| 35309 | 35309 | 64038 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 16 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1988 12:00:00 AM | 10 | Permit Number 25745 | 5998453.4174 | 2110814.7286 | 37.7758054707119 | -122.44885232426 | (37.7758054707119, -122.44885232426) | ||
| 147652 | 147652 | 64012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 10 Loyola Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1987 12:00:00 AM | 10 | Permit Number 24766 | 5998456.7381 | 2110792.4322 | 37.7757444404433 | -122.44883923078999 | (37.7757444404433, -122.44883923079) | ||
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 17595 | 17595 | 17108 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1789 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998462.7101 | 2109289.6892 | 37.7716186353865 | -122.448710312151 | (37.7716186353865, -122.448710312151) | |||
| 27278 | 27278 | 248364 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1501 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998466.8217 | 2108253.3731 | 37.768773410658895 | -122.44862143957701 | (37.7687734106589, -122.448621439577) | |||
| 130527 | 130527 | 141689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998480.6511 | 2111795.7451 | 37.778500645914995 | -122.44882879479601 | (37.778500645915, -122.448828794796) | |||
| 21546 | 21546 | 17107 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1781 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5998487.0633 | 2109292.2527 | 37.7716270666505 | -122.44862625802799 | (37.7716270666505, -122.448626258028) | |||
| 4247 | 4247 | 246146 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 16 | Width 0ft | Permit Number 18128 | 5998494.9848 | 2108301.523 | 37.76890722837079 | -122.44852749406 | (37.7689072283708, -122.44852749406) | |
| 32305 | 32305 | 141109 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 WOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998503.1758 | 2112860.4826 | 37.7814254265925 | -122.44882758656601 | (37.7814254265925, -122.448827586566) | |||
| 62338 | 62338 | 246145 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998507.7036 | 2108329.6861 | 37.768985284301706 | -122.448485529275 | (37.7689852843017, -122.448485529275) | |||
| 33304 | 33304 | 248365 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 701 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998521.6337 | 2108231.8723 | 37.7687175089215 | -122.44843030114201 | (37.7687175089215, -122.448430301142) | |||
| 165101 | 165101 | 247361 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1775 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998529.7882 | 2109299.0887 | 37.771648279481 | -122.44847896310101 | (37.771648279481, -122.448478963101) | |||
| 148089 | 148089 | 141688 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998531.7594 | 2111801.3756 | 37.7785190283548 | -122.44865239820801 | (37.7785190283548, -122.448652398208) | |||
| 23341 | 23341 | 10463 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1584 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998533.6334 | 2108659.497 | 37.7698923436585 | -122.44841959455401 | (37.7698923436585, -122.448419594554) | |||
| 150342 | 150342 | 246133 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998546.7685 | 2108359.3633 | 37.7690690038469 | -122.44835254426701 | (37.7690690038469, -122.448352544267) | |||
| 136566 | 136566 | 246132 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 662 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998549.1912 | 2108336.0455 | 37.7690051176051 | -122.448342484944 | (37.7690051176051, -122.448342484944) | |||
| 155943 | 155943 | 141687 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998550.3836 | 2111804.4075 | 37.778528418096 | -122.448588188719 | (37.778528418096, -122.448588188719) | |||
| 48266 | 48266 | 244538 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1765 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998568.2406 | 2109302.9339 | 37.7716610358886 | -122.448346231455 | (37.7716610358886, -122.448346231455) | |||
| 68809 | 68809 | 248358 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998577.0515 | 2108268.5146 | 37.76882128769329 | -122.44824125490601 | (37.7688212876933, -122.448241254906) | |||
| 136666 | 136666 | 141686 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998577.2371 | 2111809.6049 | 37.7785442242281 | -122.448495667047 | (37.7785442242281, -122.448495667047) | |||
| 2207 | 2207 | 244533 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1588 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 5998589.1758 | 2108666.333 | 37.7699142890018 | -122.448227967728 | (37.7699142890018, -122.448227967728) | |||
| 22359 | 22359 | 246131 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998602.7919 | 2108317.2701 | 37.768956629428395 | -122.448155732181 | (37.7689566294284, -122.448155732181) | |||
| 59694 | 59694 | 141685 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998607.1225 | 2111811.7705 | 37.7785518790932 | -122.448392438493 | (37.7785518790932, -122.448392438493) | |||
| 41329 | 41329 | 248473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 758 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5998609.6056 | 2107900.123 | 37.7678116388378 | -122.448102124294 | (37.7678116388378, -122.448102124294) |
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");