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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |
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) | |
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) | ||
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) | |
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) | |||
27948 | 27948 | 58051 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1609 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1977 12:00:00 AM | 5 | Permit Number 17020 | 6006619.5836 | 2116449.4594 | 37.791740674082796 | -122.421003598405 | (37.7917406740828, -122.421003598405) | ||
29034 | 29034 | 64425 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 259 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1988 12:00:00 AM | 9 | Permit Number 25277 | 6010096.4211 | 2121261.5999 | 37.8051490065079 | -122.409313442808 | (37.8051490065079, -122.409313442808) | ||
29179 | 29179 | 63908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2125 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1987 12:00:00 AM | 14 | Permit Number 24623 | 6009389.9763 | 2121003.9446 | 37.8044019445665 | -122.411739972568 | (37.8044019445665, -122.411739972568) | ||
29471 | 29471 | 56977 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 177 Pfeiffer St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 14 | Permit Number 14230 | 6009999.8042 | 2121084.2658 | 37.8046566775876 | -122.40963527441002 | (37.8046566775876, -122.40963527441) | ||
30976 | 30976 | 31653 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 8 | Permit Number 35163 | 6004466.8826 | 2114789.0769 | 37.787060100362794 | -122.428333544653 | (37.7870601003628, -122.428333544653) | ||
31733 | 31733 | 33694 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 401 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | 12 | Permit Number 37765 | 6005381.091 | 2111139.6901 | 37.777091471020704 | -122.424910846803 | (37.7770914710207, -122.424910846803) | ||
32530 | 32530 | 97312 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 10 | 3x3 | 5990212.18 | 2099077.2394 | 37.7431027248159 | -122.476502906842 | (37.7431027248159, -122.476502906842) | ||
34183 | 34183 | 32298 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | 12 | Permit Number 36875 | 6011655.3244 | 2107023.9767 | 37.766143058580205 | -122.40291664053001 | (37.7661430585802, -122.40291664053) | |
34190 | 34190 | 60217 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1982 12:00:00 AM | 15 | 3x3 | Permit Number 19767 | 6002507.5803 | 2114417.8549 | 37.7859297581806 | -122.43508572581001 | (37.7859297581806, -122.43508572581) | |
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) | ||
35357 | 35357 | 59593 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1528 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1981 12:00:00 AM | 15 | Permit Number 18990 | 6000159.8025 | 2114219.1556 | 37.785250588527205 | -122.44319409038201 | (37.7852505885272, -122.443194090382) | ||
35499 | 35499 | 66182 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1819 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1990 12:00:00 AM | 12 | Permit Number 29259 | 6004371.7533 | 2115130.5363 | 37.7879922787707 | -122.42868702120701 | (37.7879922787707, -122.428687021207) | ||
36366 | 36366 | 33642 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 462 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 10 | Permit Number 37736 | 6005186.1558 | 2110786.6502 | 37.776111096903 | -122.42556005736999 | (37.776111096903, -122.42556005737) | |
36487 | 36487 | 49516 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1910@ BUSH ST Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 46422 | 6002507.7627 | 2114881.9371 | 37.7872040200664 | -122.43511829939699 | (37.7872040200664, -122.435118299397) | |||
37094 | 37094 | 38611 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40556 | 6015254.5205 | 2094308.8703 | 37.7314303593885 | -122.389579509324 | (37.7314303593885, -122.389579509324) | |
39524 | 39524 | 47470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2902 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 14 | Permit Number 45371 | 5999554.6801 | 2114357.1647 | 37.7855950025795 | -122.445297547197 | (37.7855950025795, -122.445297547197) | ||
41039 | 41039 | 110469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.777640618295706 | -122.42405534708901 | (37.7776406182957, -122.424055347089) | ||
41330 | 41330 | 57327 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2904 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1976 12:00:00 AM | 17 | Permit Number 16155 | 5999526.9274 | 2114356.6691 | 37.785592057564294 | -122.44539352748501 | (37.7855920575643, -122.445393527485) | ||
41574 | 41574 | 57511 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 636 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 17 | Permit Number 16364 | 6005408.351 | 2111510.821 | 37.7781120456222 | -122.424842955768 | (37.7781120456222, -122.424842955768) | ||
42034 | 42034 | 55481 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 530 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 13 | Permit Number 11434 | 6002173.9724 | 2110343.1732 | 37.7747227610629 | -122.435948251092 | (37.7747227610629, -122.435948251092) | ||
43497 | 43497 | 106406 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 650 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x6 | 5999248.4097 | 2114351.2177 | 37.785561186294295 | -122.446356721815 | (37.7855611862943, -122.446356721815) | |||
44704 | 44704 | 110911 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6013393.5354 | 2113814.1809 | 37.784884328260105 | -122.397380700853 | (37.7848843282601, -122.397380700853) | ||||
44806 | 44806 | 59664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 947 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 15 | 5x5 | Permit Number 19086 | 6002929.3099 | 2111572.5338 | 37.7781411599151 | -122.433423256969 | (37.7781411599151, -122.433423256969) | |
46391 | 46391 | 35162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 521 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 9 | Permit Number 38693 | 6002611.6162 | 2110373.5603 | 37.7748310484791 | -122.434436527113 | (37.7748310484791, -122.434436527113) | |
47060 | 47060 | 65627 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2116 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | 6x6 | Permit Number 28535 | 6002451.5098 | 2114409.7678 | 37.7859043690694 | -122.435279135393 | (37.7859043690694, -122.435279135393) |
49029 | 49029 | 56933 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1915 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 14 | 3x3 | Permit Number 14177 | 6001940.9389 | 2115134.3349 | 37.787864837109 | -122.437097461747 | (37.787864837109, -122.437097461747) | |
49361 | 49361 | 38058 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2844 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 15 | Permit Number 40253 | 5999884.3012 | 2114402.2303 | 37.7857375510232 | -122.44416039717 | (37.7857375510232, -122.44416039717) | |
49979 | 49979 | 53483 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 647 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1969 12:00:00 AM | 16 | Permit Number 6392 | 6008737.1169 | 2120721.7235 | 37.80359039074771 | -122.413979278997 | (37.8035903907477, -122.413979278997) | ||
50229 | 50229 | 110907 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6013321.5581 | 2113739.1188 | 37.7846742173914 | -122.397624454233 | (37.7846742173914, -122.397624454233) | ||||
51113 | 51113 | 53752 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 251 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | 13 | Permit Number 9432 | 6010125.6 | 2121266.3833 | 37.805163775279205 | -122.40921280301701 | (37.8051637752792, -122.409212803017) | ||
52729 | 52729 | 117032 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6002478.4668 | 2114411.3853 | 37.7859103411195 | -122.435185987474 | (37.7859103411195, -122.435185987474) | |||
53528 | 53528 | 65955 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1234 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28976 | 6001892.8907 | 2110857.546 | 37.7761191282962 | -122.436957400422 | (37.7761191282962, -122.436957400422) | ||
53659 | 53659 | 59958 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 515 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 17 | Permit Number 19435 | 6005418.82 | 2111104.349 | 37.7769965639956 | -122.42477781542601 | (37.7769965639956, -122.424777815426) | |
54193 | 54193 | 59956 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 426 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1981 12:00:00 AM | 16 | Permit Number 19433 | 6005279.4106 | 2111149.1414 | 37.7771116781194 | -122.42526326419 | (37.7771116781194, -122.42526326419) | ||
54324 | 54324 | 58879 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2900 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 13 | Permit Number 25516 | 5999589.5873 | 2114362.4153 | 37.785611411881106 | -122.44517715647801 | (37.7856114118811, -122.445177156478) | ||
54431 | 54431 | 58709 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1952 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1979 12:00:00 AM | 14 | Permit Number 17941 | 6003655.3938 | 2118679.8466 | 37.797697209655496 | -122.431418967171 | (37.7976972096555, -122.431418967171) | ||
57074 | 57074 | 66506 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2458 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 15 | Permit Number 29669 | 6001738.4652 | 2114659.4492 | 37.7865494118178 | -122.43776395706001 | (37.7865494118178, -122.43776395706) | |
59550 | 59550 | 110908 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6013338.0101 | 2113761.7403 | 37.784737246892796 | -122.39756912252199 | (37.7847372468928, -122.397569122522) | ||||
59660 | 59660 | 117031 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002487.092999999 | 2114413.0027 | 37.78591527192879 | -122.435156258966 | (37.7859152719288, -122.435156258966) | |||
60145 | 60145 | 61078 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2590 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1983 12:00:00 AM | 13 | Permit Number 20915 | 5999806.8161 | 2113697.9026 | 37.7837992291467 | -122.44437783777398 | (37.7837992291467, -122.444377837774) | ||
60560 | 60560 | 60603 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 630 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 9 | Permit Number 29505 | 6003603.285 | 2110552.7276 | 37.775379238631004 | -122.431018929857 | (37.775379238631, -122.431018929857) | |
61042 | 61042 | 38609 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1570 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/2002 12:00:00 AM | 6 | Permit Number 45423 | 6015273.2073 | 2094293.4811 | 37.7313891398709 | -122.38951383063 | (37.7313891398709, -122.38951383063) | |
61133 | 61133 | 56932 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1911 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 18 | 3x3 | Permit Number 14176 | 6001946.3485 | 2115087.5805 | 37.787736769008 | -122.43707539686001 | (37.787736769008, -122.43707539686) |
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");