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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8257 | 8257 | 13205 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2150 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6002007.2704 | 2119484.4094 | 37.799812783065704 | -122.43717955071301 | (37.7998127830657, -122.437179550713) | |||
| 8267 | 8267 | 13269 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2495 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3X3 | 6000559.8762 | 2119201.7827 | 37.798954383190896 | -122.442167759467 | (37.7989543831909, -122.442167759467) | ||
| 8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
| 8449 | 8449 | 7686 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008772.4139 | 2121077.9257 | 37.8045704150203 | -122.413882343906 | (37.8045704150203, -122.413882343906) | |||
| 8458 | 8458 | 7176 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 821 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003466.4983 | 2111179.8077 | 37.777093293678206 | -122.43153688437401 | (37.7770932936782, -122.431536884374) | |||
| 8613 | 8613 | 7257 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1714 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003087.8498 | 2114225.1589 | 37.785433595884 | -122.43306438198799 | (37.785433595884, -122.433064381988) | |||
| 8620 | 8620 | 13203 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2143 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002126.2145 | 2119425.2487 | 37.7996571038373 | -122.436763723295 | (37.7996571038373, -122.436763723295) | |||
| 8759 | 8759 | 22673 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1330 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003656.8115 | 2112490.6031 | 37.780703197144 | -122.430972105719 | (37.780703197144, -122.430972105719) | |||
| 8774 | 8774 | 9636 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1460 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002640.9745 | 2112004.0216 | 37.7793095547354 | -122.434451571103 | (37.7793095547354, -122.434451571103) | |||
| 8963 | 8963 | 12998 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 348 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6010660.6396 | 2120687.9769 | 37.803605574331705 | -122.407320424126 | (37.8036055743317, -122.407320424126) | |||
| 9238 | 9238 | 4685 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 716 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2012 12:00:00 AM | 3 | 3x3 | 6009342.0114 | 2119967.9552 | 37.801554684737894 | -122.411832709398 | (37.8015546847379, -122.411832709398) | ||
| 9434 | 9434 | 18037 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/1993 12:00:00 AM | 6 | 3X3 | 6000386.5591 | 2114760.4621 | 37.7867498032378 | -122.442448460651 | (37.7867498032378, -122.442448460651) | ||
| 9575 | 9575 | 23736 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/2005 12:00:00 AM | 8 | 4X4 | 6003952.5765 | 2110750.7086 | 37.775942631605204 | -122.429824773698 | (37.7759426316052, -122.429824773698) | ||
| 12618 | 12618 | 15750 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 4625 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6002067.6674 | 2091962.7327 | 37.7242483928285 | -122.43500115616301 | (37.7242483928285, -122.435001156163) | |||
| 13740 | 13740 | 97243 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016226.9194 | 2094855.7145 | 37.7329857540551 | -122.38625582218701 | (37.7329857540551, -122.386255822187) | |||
| 15892 | 15892 | 97244 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016216.2447 | 2094842.5281 | 37.7329489559822 | -122.38629180873501 | (37.7329489559822, -122.386291808735) | |||
| 16688 | 16688 | 97242 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016235.0824 | 2094868.9009 | 37.7330224130953 | -122.386228519291 | (37.7330224130953, -122.386228519291) | |||
| 17134 | 17134 | 16973 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 779 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003283.5334 | 2109961.2453 | 37.773737050882396 | -122.432082777045 | (37.7737370508824, -122.432082777045) | |||
| 17142 | 17142 | 545 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2878 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009558.0762 | 2102211.8871 | 37.7528128183786 | -122.40983092966101 | (37.7528128183786, -122.409830929661) | |||
| 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) | |||
| 17214 | 17214 | 17082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1565 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999524.2661 | 2109435.6263 | 37.7720799869694 | -122.445048833846 | (37.7720799869694, -122.445048833846) | |||
| 17403 | 17403 | 17098 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1705 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998777.5925 | 2109332.4141 | 37.7717539478166 | -122.447624196011 | (37.7717539478166, -122.447624196011) | |||
| 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) | |||
| 17505 | 17505 | 20093 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2079X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997064.7516 | 2109095.7182 | 37.7710060031357 | -122.453531898634 | (37.7710060031357, -122.453531898634) | |||
| 17565 | 17565 | 542 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2870 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009603.0598 | 2102213.6628 | 37.7528202149244 | -122.40967549279199 | (37.7528202149244, -122.409675492792) | |||
| 17632 | 17632 | 16985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 867 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002849.3678 | 2109899.7049 | 37.7735434517189 | -122.433580223732 | (37.7735434517189, -122.433580223732) | |||
| 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) | |||
| 17671 | 17671 | 16978 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 823 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003035.6347 | 2109919.8489 | 37.7736093289353 | -122.432937338869 | (37.7736093289353, -122.432937338869) | |||
| 17814 | 17814 | 16989 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 880 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002806.5013 | 2109946.7063 | 37.77367007365171 | -122.433731865097 | (37.7736700736517, -122.433731865097) | |||
| 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) | |||
| 17964 | 17964 | 16976 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 811 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003075.3996 | 2109932.9295 | 37.7736475004085 | -122.432800720802 | (37.7736475004085, -122.432800720802) | |||
| 18114 | 18114 | 27413 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002017.7522 | 2110131.5591 | 37.774132845741704 | -122.436473498525 | (37.7741328457417, -122.436473498525) | |||
| 18161 | 18161 | 107661 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1312 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999086.9 | 2105066.2 | 37.7600576690463 | -122.446247345124 | (37.7600576690463, -122.446247345124) | |||
| 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) | |||
| 18241 | 18241 | 10403 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1369 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999594.2543 | 2108755.1609 | 37.77021559548189 | -122.44475781986999 | (37.7702155954819, -122.44475781987) | |||
| 18281 | 18281 | 17048 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001170.7121 | 2109662.4759 | 37.7727966927365 | -122.43936992159401 | (37.7727966927365, -122.439369921594) | |||
| 18389 | 18389 | 16963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 741 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003456.556 | 2109979.0777 | 37.7737958222062 | -122.43148553825701 | (37.7737958222062, -122.431485538257) | |||
| 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) | |||
| 18829 | 18829 | 14559 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1595X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999419.8987 | 2109421.3340000003 | 37.772034786606 | -122.44540881989799 | (37.772034786606, -122.445408819898) | |||
| 19393 | 19393 | 527 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009841.2951 | 2102226.6843 | 37.7528693162895 | -122.408852546362 | (37.7528693162895, -122.408852546362) | |||
| 19595 | 19595 | 7021 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1105 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002080.4157 | 2110140.9294 | 37.7741621348105 | -122.43625740553301 | (37.7741621348105, -122.436257405533) | |||
| 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) | |||
| 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) | |||
| 20080 | 20080 | 38646 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 209 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1998 12:00:00 AM | Permit Number 40570 | 6005214.92856016 | 2099001.03793316 | 37.7437522091261 | -122.42462195934401 | (37.7437522091261, -122.424621959344) | |||
| 20398 | 20398 | 16986 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 870 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002847.8984 | 2109953.1746 | 37.7736901829149 | -122.433589128645 | (37.7736901829149, -122.433589128645) | |||
| 20998 | 20998 | 16964 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 747 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6003424.2649 | 2109979.0777 | 37.7737939919852 | -122.431597238278 | (37.7737939919852, -122.431597238278) | |||
| 21063 | 21063 | 16972 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003244.9501 | 2110008.9107 | 37.7738657407699 | -122.43221964740499 | (37.7738657407699, -122.432219647405) | |||
| 21140 | 21140 | 28785 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002281.4779 | 2109178.7673 | 37.7715316982304 | -122.435493052551 | (37.7715316982304, -122.435493052551) | |||
| 21249 | 21249 | 15334 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 4 | 3x3 | 6006687.4636 | 2108380.8364 | 37.7695900216736 | -122.420195837478 | (37.7695900216736, -122.420195837478) | ||
| 21454 | 21454 | 16971 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 780 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003271.9397 | 2110011.5439 | 37.7738745011261 | -122.43212647411501 | (37.7738745011261, -122.432126474115) | |||
| 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) | |||
| 21742 | 21742 | 20094 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2075X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997081.4143 | 2109098.2817 | 37.7710139970036 | -122.453474447283 | (37.7710139970036, -122.453474447283) | |||
| 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) | |||
| 21900 | 21900 | 14558 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999395.6349 | 2109419.0073 | 37.772027012932895 | -122.445492582637 | (37.7720270129329, -122.445492582637) | |||
| 21990 | 21990 | 528 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2836 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6009819.9871 | 2102225.5005 | 37.7528648722833 | -122.408926150195 | (37.7528648722833, -122.408926150195) | |||
| 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) | |||
| 22051 | 22051 | 28786 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 800 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002265.8749 | 2109178.7673 | 37.7715308120493 | -122.43554702410299 | (37.7715308120493, -122.435547024103) | |||
| 22132 | 22132 | 28299 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 100 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5995861.9776 | 2088092.909 | 37.713268452474104 | -122.45617353106701 | (37.7132684524741, -122.456173531067) | |||
| 22172 | 22172 | 489 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2730 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6010359.8791 | 2102254.6242 | 37.7529750670361 | -122.40706114707301 | (37.7529750670361, -122.407061147073) | |||
| 22235 | 22235 | 17057 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1285 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6000879.2146 | 2109627.576 | 37.772684273376 | -122.440375738629 | (37.772684273376, -122.440375738629) | |||
| 22298 | 22298 | 143213 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010427.9747 | 2121297.8273 | 37.8052670481181 | -122.40816861291 | (37.8052670481181, -122.40816861291) | |||
| 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) | |||
| 22888 | 22888 | 245220 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 351 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6005075.2787 | 2110089.7787 | 37.774191391909596 | -122.425893994936 | (37.7741913919096, -122.425893994936) | |||
| 23414 | 23414 | 64062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1205 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 7 | Permit Number 29268 | 6011082.0743 | 2119072.3147 | 37.799192938755 | -122.405748149412 | (37.799192938755, -122.405748149412) | |
| 23633 | 23633 | 137529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.43586064910801 | (37.7825202770743, -122.435860649108) | |||
| 23704 | 23704 | 138749 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1528 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000156.6321 | 2114235.0077 | 37.785293933510104 | -122.443206197892 | (37.7852939335101, -122.443206197892) | |||
| 23797 | 23797 | 143335 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1820 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004232.6567 | 2118749.9753 | 37.7979224644928 | -122.42942648353399 | (37.7979224644928, -122.429426483534) | |||
| 23838 | 23838 | 140159 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998783.859 | 2109828.5826 | 37.77311665794689 | -122.44763824308501 | (37.7731166579469, -122.447638243085) | |||
| 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) | |||
| 24233 | 24233 | 140776 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 77 TERRA VISTA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000147.5673 | 2112813.1036 | 37.7813892348129 | -122.443135402805 | (37.7813892348129, -122.443135402805) | |||
| 24268 | 24268 | 139286 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 847 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003452.0971 | 2111280.6163 | 37.777369272847295 | -122.431593901382 | (37.7773692728473, -122.431593901382) | |||
| 24338 | 24338 | 142592 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008300.8769 | 2120835.2204 | 37.803877514381 | -122.415496953155 | (37.803877514381, -122.415496953155) | |||
| 24575 | 24575 | 138501 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1799 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002528.8099 | 2114345.6813 | 37.7857327932764 | -122.435007113669 | (37.7857327932764, -122.435007113669) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 24837 | 24837 | 217620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994327.7005 | 2092483.4396 | 37.7252356086447 | -122.461794638623 | (37.7252356086447, -122.461794638623) | |||
| 24888 | 24888 | 45611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1100 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2001 12:00:00 AM | 16 | Permit Number 44335 | 6003449.1823 | 2112117.4289 | 37.7796667869975 | -122.43166374401001 | (37.7796667869975, -122.43166374401) | ||
| 25086 | 25086 | 59963 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 523 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 15 | Permit Number 19442 | 6005413.5665 | 2111133.9591 | 37.777077569392 | -122.424798095948 | (37.777077569392, -122.424798095948) | |
| 25206 | 25206 | 98347 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1331 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011023.1341 | 2119487.8255 | 37.800330533908294 | -122.40598139081999 | (37.8003305339083, -122.40598139082) | |||
| 25536 | 25536 | 59622 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 448 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25385 | 6001193.7685 | 2110273.1905 | 37.7744748738878 | -122.439333950555 | (37.7744748738878, -122.439333950555) | |
| 25581 | 25581 | 64501 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 545 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | Permit Number 25381 | 6001107.084 | 2110608.9242 | 37.7753917807448 | -122.439657882213 | (37.7753917807448, -122.439657882213) | |
| 26086 | 26086 | 59151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 112 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1980 12:00:00 AM | 13 | Permit Number 18460 | 6010290.1497 | 2121142.971 | 37.8048341329685 | -122.408634644798 | (37.8048341329685, -122.408634644798) | ||
| 26124 | 26124 | 143189 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | |||
| 26187 | 26187 | 244530 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 557 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5998936.3155 | 2108740.8879 | 37.7701388371467 | -122.44703258946998 | (37.7701388371467, -122.44703258947) | |||
| 26219 | 26219 | 201182 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 620 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6013434.6654 | 2113939.6272 | 37.785231064684204 | -122.39724720317801 | (37.7852310646842, -122.397247203178) | |||
| 26247 | 26247 | 140689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003360.489 | 2112281.5531 | 37.780112403361294 | -122.431982295298 | (37.7801124033613, -122.431982295298) | |||
| 26256 | 26256 | 142499 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 521 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009964.3012 | 2119317.683 | 37.7998040885057 | -122.40963337214 | (37.7998040885057, -122.40963337214) | |||
| 26431 | 26431 | 143534 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2095 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003009.3374 | 2118534.798 | 37.797262307390795 | -122.433644124881 | (37.7972623073908, -122.433644124881) | |||
| 26479 | 26479 | 138715 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2900 BUSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999573.0166 | 2114358.1558 | 37.785598770554294 | -122.445234179741 | (37.7855987705543, -122.445234179741) | |||
| 26522 | 26522 | 140712 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002642.8382 | 2110450.4669999997 | 37.7750439873946 | -122.434334023387 | (37.7750439873946, -122.434334023387) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 26569 | 26569 | 32778 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 2 | Permit Number 37147 | 6001101.7087 | 2110645.4763 | 37.775491837653796 | -122.43967909765101 | (37.7754918376538, -122.439679097651) | |
| 26624 | 26624 | 141693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 392 EWING TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998717.1894 | 2112334.7102 | 37.7799940283513 | -122.448049338774 | (37.7799940283513, -122.448049338774) | |||
| 26993 | 26993 | 101263 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2000 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 20727 | 5989478.8752 | 2106534.6445 | 37.76353621964879 | -122.479583963683 | (37.7635362196488, -122.479583963683) | |||
| 27146 | 27146 | 140419 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002875.6498 | 2112268.3783 | 37.780048730384 | -122.43365863076201 | (37.780048730384, -122.433658630762) | |||
| 27277 | 27277 | 138678 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2811 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000338.1385 | 2114753.4825 | 37.786727879036704 | -122.442615482645 | (37.7867278790367, -122.442615482645) | |||
| 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) | |||
| 27423 | 27423 | 251079 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 5616 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5989547.9545 | 2112698.1385 | 37.7804634926969 | -122.479796079248 | (37.7804634926969, -122.479796079248) | |||
| 27469 | 27469 | 143247 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 153 PFEIFFER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010131.5523 | 2121103.7243 | 37.8047174875245 | -122.40918071917 | (37.8047174875245, -122.40918071917) | |||
| 27737 | 27737 | 248360 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1485 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998667.1431 | 2108281.3848 | 37.768861776014795 | -122.447930562543 | (37.7688617760148, -122.447930562543) | |||
| 27933 | 27933 | 143258 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.41167715318599 | (37.8029290843214, -122.411677153186) |
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");