Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189110 | 189110 | 137859 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 20 Orben Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003149.2963 | 2115462.6131 | 37.7888348165279 | -122.43294023402599 | (37.7888348165279, -122.432940234026) | |||
| 189100 | 189100 | 246130 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1486 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998621.8702 | 2108319.087 | 37.768962708792 | -122.448089872703 | (37.768962708792, -122.448089872703) | |||
| 189092 | 189092 | 143539 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002781.8179 | 2118502.7622 | 37.7971614332575 | -122.434429107355 | (37.7971614332575, -122.434429107355) | |||
| 188994 | 188994 | 245076 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000344.2484 | 2109550.1314 | 37.7724411555945 | -122.442220678844 | (37.7724411555945, -122.442220678844) | |||
| 188842 | 188842 | 140546 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1060 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002924.6148 | 2111925.6484 | 37.779110458039604 | -122.43346473978701 | (37.7791104580396, -122.433464739787) | |||
| 188446 | 188446 | 138009 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1803 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003935.4192 | 2114568.0116 | 37.7864230237501 | -122.430156512807 | (37.7864230237501, -122.430156512807) | |||
| 188438 | 188438 | 245412 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2802 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009963.8161 | 2102233.787 | 37.7528956807716 | -122.408429345015 | (37.7528956807716, -122.408429345015) | |||
| 188248 | 188248 | 142992 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 455 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6009662.0127 | 2120854.6155 | 37.804007180841204 | -122.41078801080799 | (37.8040071808412, -122.410788010808) | |||
| 188189 | 188189 | 138864 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003093.4509 | 2110708.1672 | 37.7757771350892 | -122.43279367037901 | (37.7757771350892, -122.432793670379) | |||
| 188134 | 188134 | 181943 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1635 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988119.3796 | 2098941.1939 | 37.7426075787892 | -122.483729187458 | (37.7426075787892, -122.483729187458) | |||
| 188113 | 188113 | 142604 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6008306.3204 | 2120712.3516 | 37.8035404535195 | -122.415469411535 | (37.8035404535195, -122.415469411535) | |||
| 188091 | 188091 | 245850 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 381 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005186.7592 | 2110228.7704 | 37.7745793288374 | -122.42551825751998 | (37.7745793288374, -122.42551825752) | |||
| 188085 | 188085 | 71703 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1982 12:00:00 AM | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | ||
| 187956 | 187956 | 246092 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997091.8262 | 2108330.4431 | 37.7689063069149 | -122.45338298694901 | (37.7689063069149, -122.453382986949) | |||
| 187140 | 187140 | 183273 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.49976317535801 | (37.7634443416971, -122.499763175358) | |||
| 187092 | 187092 | 142508 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 358 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010579.9175 | 2118839.2508 | 37.798524907896 | -122.407469352253 | (37.798524907896, -122.407469352253) | |||
| 186817 | 186817 | 55476 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | Permit Number 11428 | 6002664.0079 | 2110296.3247 | 37.7746219525119 | -122.434249770689 | (37.7746219525119, -122.434249770689) | ||
| 186757 | 186757 | 140403 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1119 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003754.0514 | 2112594.2194 | 37.7809932110185 | -122.43064310216101 | (37.7809932110185, -122.430643102161) | |||
| 186639 | 186639 | 138707 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2874 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999741.1485 | 2114383.1871 | 37.7856770956012 | -122.44465429395099 | (37.7856770956012, -122.444654293951) | |||
| 186591 | 186591 | 247390 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 217 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002281.8171 | 2109227.9509 | 37.7716667634841 | -122.43549539828501 | (37.7716667634841, -122.435495398285) | |||
| 186307 | 186307 | 137638 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 807 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999975.5644 | 2111759.3427 | 37.778486068888796 | -122.443654723767 | (37.7784860688888, -122.443654723767) | |||
| 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) | |||
| 185651 | 185651 | 201181 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 608 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6013452.1456 | 2113958.1356 | 37.7852828576216 | -122.39718802493 | (37.7852828576216, -122.39718802493) | |||
| 185650 | 185650 | 139443 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 640 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004962.1321 | 2111203.2952 | 37.777242441577 | -122.426364687622 | (37.777242441577, -122.426364687622) | |||
| 185478 | 185478 | 245077 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1387 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000372.5007 | 2109554.1199 | 37.7724537171291 | -122.442123238035 | (37.7724537171291, -122.442123238035) | |||
| 185441 | 185441 | 38610 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015263.8639 | 2094301.7253 | 37.7314112587254 | -122.38954670833701 | (37.7314112587254, -122.389546708337) | |
| 185298 | 185298 | 143369 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1763 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004565.1185 | 2118753.222 | 37.797950196314794 | -122.428276302626 | (37.7979501963148, -122.428276302626) | |||
| 185285 | 185285 | 105341 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1407 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6000167.325 | 2113807.8025 | 37.7841215482425 | -122.44313851129999 | (37.7841215482425, -122.4431385113) | ||||
| 185077 | 185077 | 244147 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 405 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004529.1957 | 2109628.6007 | 37.772894233589795 | -122.42775012801701 | (37.7728942335898, -122.427750128017) | |||
| 185073 | 185073 | 140702 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 710 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003550.9915 | 2110923.9408 | 37.776395535095 | -122.43122632799 | (37.776395535095, -122.43122632799) | |||
| 184932 | 184932 | 142820 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1754 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006598.3556 | 2116937.7026 | 37.793080071640894 | -122.42111173056101 | (37.7930800716409, -122.421111730561) | |||
| 184839 | 184839 | 139439 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 495 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005453.4757 | 2111308.2848 | 37.77755847929021 | -122.42467244144501 | (37.7775584792902, -122.424672441445) | |||
| 184834 | 184834 | 217619 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994357.3344 | 2092471.2741 | 37.7252039110132 | -122.461691316268 | (37.7252039110132, -122.461691316268) | |||
| 184755 | 184755 | 140540 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003378.1969 | 2111847.7586 | 37.7789223156672 | -122.43189005228001 | (37.7789223156672, -122.43189005228) | |||
| 184456 | 184456 | 244529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 564 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998978.8238 | 2108751.0336 | 37.7701691232136 | -122.446886284448 | (37.7701691232136, -122.446886284448) | |||
| 184098 | 184098 | 30887 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 412 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | 21 | 4x5 | Permit Number 34719 | 6005841.0474 | 2111067.7548 | 37.7769199237056 | -122.42331459648399 | (37.7769199237056, -122.423314596484) | |
| 184088 | 184088 | 247447 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 899 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002801.7546 | 2109893.9494 | 37.7735249469174 | -122.43374451324301 | (37.7735249469174, -122.433744513243) | |||
| 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) | |||
| 183831 | 183831 | 246038 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1378 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999156.0607 | 2108395.7028 | 37.7692035985916 | -122.446247661551 | (37.7692035985916, -122.446247661551) | |||
| 183645 | 183645 | 140505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003444.6141 | 2111801.8852 | 37.7788001236235 | -122.43165701281 | (37.7788001236235, -122.43165701281) | |||
| 183608 | 183608 | 140061 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 448 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005605.1155 | 2111378.5953 | 37.777760097820895 | -122.42415286955 | (37.7777600978209, -122.42415286955) | |||
| 183602 | 183602 | 140513 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1060 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003397.5169 | 2112023.6980000003 | 37.779406496655604 | -122.431835782497 | (37.7794064966556, -122.431835782497) | |||
| 183556 | 183556 | 140208 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 706 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003562.1361 | 2110838.1764 | 37.7761606788099 | -122.43118165261002 | (37.7761606788099, -122.43118165261) | |||
| 183526 | 183526 | 143069 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1709 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010441.5711 | 2120399.4535 | 37.802801097041204 | -122.40805816505501 | (37.8028010970412, -122.408058165055) | |||
| 183473 | 183473 | 184489 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.49880363397499 | (37.7519941007524, -122.498803633975) | |||
| 183195 | 183195 | 138472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003013.5126 | 2114389.5238 | 37.785880683353 | -122.433333315539 | (37.785880683353, -122.433333315539) | |||
| 183176 | 183176 | 142938 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1160 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6010744.0272 | 2118552.2837 | 37.797746150342604 | -122.406881242638 | (37.7977461503426, -122.406881242638) | |||
| 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) | |||
| 183087 | 183087 | 248411 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1737 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997411.4623 | 2108107.5609 | 37.76831264578671 | -122.45226130839701 | (37.7683126457867, -122.452261308397) | |||
| 182858 | 182858 | 247387 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1053 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001955.5092 | 2109778.1291 | 37.7731588780046 | -122.43666350389 | (37.7731588780046, -122.43666350389) | |||
| 182825 | 182825 | 142620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1 Scotland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009140.6951 | 2120065.1504 | 37.8018102626301 | -122.412536232083 | (37.8018102626301, -122.412536232083) | |||
| 182606 | 182606 | 115984 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011255.4785 | 2118051.2862 | 37.796399137392896 | -122.405076175742 | (37.7963991373929, -122.405076175742) | |||
| 182604 | 182604 | 244381 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 221 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005910.0454 | 2110329.5608 | 37.7748969155572 | -122.423023430361 | (37.7748969155572, -122.423023430361) | |||
| 182520 | 182520 | 141684 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998631.8104 | 2111816.1017 | 37.7785651829019 | -122.448307345965 | (37.7785651829019, -122.448307345965) | |||
| 182280 | 182280 | 141531 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996721.1149 | 2111488.1108 | 37.777555184997894 | -122.45489342919399 | (37.7775551849979, -122.454893429194) | |||
| 182228 | 182228 | 142947 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 21 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010050.2611 | 2121139.8618 | 37.8048121576562 | -122.40946458873002 | (37.8048121576562, -122.40946458873) | |||
| 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) | |||
| 181919 | 181919 | 53486 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1969 12:00:00 AM | 14 | Permit Number 6395 | 5996703.1102 | 2112969.116 | 37.7816206023811 | -122.455062757544 | (37.7816206023811, -122.455062757544) | ||
| 181868 | 181868 | 65538 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.43620724273501 | (37.7857869442252, -122.436207242735) |
| 181839 | 181839 | 143491 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 270 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010925.3503 | 2118525.7809 | 37.797683524364096 | -122.40625194331999 | (37.7976835243641, -122.40625194332) | |||
| 181835 | 181835 | 244499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 605 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004067.3081 | 2110070.8068 | 37.7740822846104 | -122.429379391728 | (37.7740822846104, -122.429379391728) | |||
| 181834 | 181834 | 94582 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 710 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4.5x5 | 6003079.6036 | 2110819.4999 | 37.7760820416979 | -122.432849526968 | (37.7760820416979, -122.432849526968) | |||
| 181828 | 181828 | 245472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2700 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010432.7166 | 2102259.7859 | 37.7529933156944 | -122.406809623625 | (37.7529933156944, -122.406809623625) | |||
| 181771 | 181771 | 73629 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 530 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1982 12:00:00 AM | 20 | 5x7 | 6005222.8265 | 2111323.2215 | 37.7775864626885 | -122.42547139825301 | (37.7775864626885, -122.425471398253) | |
| 181633 | 181633 | 140404 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1113 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003757.2396 | 2112557.5551 | 37.7808927206056 | -122.430629455565 | (37.7808927206056, -122.430629455565) | |||
| 181399 | 181399 | 138471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003013.5126 | 2114407.0987 | 37.785928939577104 | -122.433334571847 | (37.7859289395771, -122.433334571847) | |||
| 181301 | 181301 | 140064 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 903 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002956.7221 | 2111383.6945 | 37.777624209443395 | -122.433314931056 | (37.7776242094434, -122.433314931056) | |||
| 181203 | 181203 | 98471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011899.7475 | 2107035.3895 | 37.7661880408824 | -122.40207202642401 | (37.7661880408824, -122.402072026424) | |||
| 181180 | 181180 | 142104 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 902 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002990.6954 | 2110322.4378 | 37.774712189416704 | -122.43312156093398 | (37.7747121894167, -122.433121560934) | |||
| 181119 | 181119 | 142605 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.41555003439501 | (37.8035348717489, -122.415550034395) | |||
| 180852 | 180852 | 246097 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997110.2988 | 2108193.2616 | 37.7685307006045 | -122.45330918662901 | (37.7685307006045, -122.453309186629) | |||
| 180623 | 180623 | 142630 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 707 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6009347.3214 | 2119879.3022 | 37.8013115634868 | -122.411808066362 | (37.8013115634868, -122.411808066362) | |||
| 180558 | 180558 | 66720 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 819 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1991 12:00:00 AM | 14 | Permit Number 29962 | 5999956.9512 | 2111893.0193 | 37.778852049002 | -122.44372871968399 | (37.778852049002, -122.443728719684) | ||
| 180500 | 180500 | 138641 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2760 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000298.8786 | 2114459.0330000003 | 37.7859171589985 | -122.44273016149201 | (37.7859171589985, -122.442730161492) | |||
| 180418 | 180418 | 143162 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | |||
| 180138 | 180138 | 143341 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1836 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004187.8522 | 2118745.4299 | 37.797907447216396 | -122.429581195466 | (37.7979074472164, -122.429581195466) | |||
| 180137 | 180137 | 138742 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999291.2776 | 2114261.7649 | 37.7853180204784 | -122.446201975075 | (37.7853180204784, -122.446201975075) | |||
| 180054 | 180054 | 138979 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 714 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003072.403 | 2110865.473 | 37.7762078640198 | -122.432877720829 | (37.7762078640198, -122.432877720829) | |||
| 180017 | 180017 | 217621 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5994307.7366 | 2092494.0455 | 37.725263580598 | -122.461864420033 | (37.725263580598, -122.461864420033) | |||
| 179842 | 179842 | 143496 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 877 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6011215.3935 | 2117948.7433 | 37.7961153384403 | -122.405207654625 | (37.7961153384403, -122.405207654625) | |||
| 179751 | 179751 | 244967 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 290 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005160.4976 | 2110090.7807 | 37.7741989587748 | -122.425599278654 | (37.7741989587748, -122.425599278654) | |||
| 179539 | 179539 | 137688 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1836 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000295.9538 | 2111331.2873 | 37.777329005815794 | -122.44251563792801 | (37.7773290058158, -122.442515637928) | |||
| 179477 | 179477 | 138505 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2199 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002149.3229 | 2114310.859 | 37.7856156253984 | -122.43631753578 | (37.7856156253984, -122.43631753578) | |||
| 179301 | 179301 | 110471 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.77766542832121 | -122.42385987213899 | (37.7776654283212, -122.423859872139) | ||
| 178657 | 178657 | 142600 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008394.1949 | 2120748.9012 | 37.803645748305 | -122.415167905628 | (37.803645748305, -122.415167905628) | |||
| 178614 | 178614 | 143512 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2030 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003288.5063 | 2118622.406 | 37.797518692459505 | -122.432684391924 | (37.7975186924595, -122.432684391924) | |||
| 178610 | 178610 | 142946 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 154 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010096.4211 | 2121116.6622 | 37.8047510435874 | -122.409303208326 | (37.8047510435874, -122.409303208326) | |||
| 178515 | 178515 | 142934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1201 KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6011088.1877 | 2119032.3 | 37.7990834099948 | -122.40572417480699 | (37.7990834099948, -122.405724174807) | |||
| 178470 | 178470 | 143518 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2162 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002654.3286 | 2118533.4904 | 37.797238567372 | -122.434872450071 | (37.797238567372, -122.434872450071) | |||
| 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) | |||
| 177756 | 177756 | 138690 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2838 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999904.6577 | 2114405.5136 | 37.7857477274076 | -122.44409020569599 | (37.7857477274076, -122.444090205696) | |||
| 177709 | 177709 | 142959 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 178 Pfeiffer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009960.8111 | 2121097.7677 | 37.8046915653635 | -122.409771168052 | (37.8046915653635, -122.409771168052) | |||
| 177701 | 177701 | 143511 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2026 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003307.4663 | 2118627.6363 | 37.7975341287535 | -122.432619159147 | (37.7975341287535, -122.432619159147) | |||
| 177627 | 177627 | 143371 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1801 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004332.6549 | 2118719.4563 | 37.79784432819471 | -122.429078284228 | (37.7978443281947, -122.429078284228) | |||
| 177611 | 177611 | 110909 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013356.5185 | 2113781.277 | 37.7847919207208 | -122.397506459776 | (37.7847919207208, -122.397506459776) | ||||
| 177466 | 177466 | 32291 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1400 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | 7 | Permit Number 36872 | 6014236.59 | 2091225.7906 | 37.722908348540294 | -122.39288309530001 | (37.7229083485403, -122.3928830953) | ||
| 177440 | 177440 | 61824 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 568 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 19 | Permit Number 21857 | 6005139.9121 | 2110969.4321 | 37.7766103583758 | -122.425733039566 | (37.7766103583758, -122.425733039566) | ||
| 177399 | 177399 | 108003 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x4 | 6005338.5862 | 2110997.1319 | 37.7766976400209 | -122.425047738741 | (37.7766976400209, -122.425047738741) | |||
| 177244 | 177244 | 247347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999077.9485 | 2109033.7671 | 37.7709511000472 | -122.44656375893899 | (37.7709511000472, -122.446563758939) | |||
| 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) |
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");