Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1834 | 1834 | 13113 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1611 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6004587.0591 | 2119767.9005 | 37.8007374842012 | -122.428272736084 | (37.8007374842012, -122.428272736084) | |||
| 1873 | 1873 | 20151 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1043 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778996 | 6002888.3687 | 2111863.5194 | 37.7789378108444 | -122.433585688352 | (37.7789378108444, -122.433585688352) | |
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 2878 | 2878 | 57526 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.42502261513701 | (37.7775297860553, -122.425022615137) | |
| 4021 | 4021 | 4643 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 515 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6010000.9813 | 2119283.7816 | 37.7997130589262 | -122.409504050861 | (37.7997130589262, -122.409504050861) | |||
| 5484 | 5484 | 13181 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002704.7439 | 2119503.7145 | 37.7999054122901 | -122.434767417241 | (37.7999054122901, -122.434767417241) | |||
| 5926 | 5926 | 13119 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.42856707818899 | (37.8007111944994, -122.428567078189) | |||
| 6068 | 6068 | 13109 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 24 | 3x3 | 6004827.8666 | 2119796.0468 | 37.8008283892799 | -122.427441448129 | (37.8008283892799, -122.427441448129) | ||
| 6459 | 6459 | 13183 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2001 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 12 | 3x3 | 6002759.5454 | 2119509.3192 | 37.7999239124366 | -122.43457818463301 | (37.7999239124366, -122.434578184633) | ||
| 7585 | 7585 | 9638 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1470 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002570.9212 | 2111995.2227 | 37.7792814183991 | -122.434693285009 | (37.7792814183991, -122.434693285009) | |||
| 7620 | 7620 | 13281 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2524 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6000224.9781 | 2119238.0771 | 37.7990349463185 | -122.44332922273199 | (37.7990349463185, -122.443329222732) | ||
| 8138 | 8138 | 13110 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1599 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 16 | 3x3 | 6004846.6308 | 2119801.5197 | 37.800844477708004 | -122.427376906198 | (37.800844477708, -122.427376906198) | ||
| 8140 | 8140 | 21680 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1811 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003837.4434 | 2114549.281 | 37.7863660445938 | -122.430494147332 | (37.7863660445938, -122.430494147332) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |
| 66616 | 66616 | 110470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.777648533038395 | -122.42401197054701 | (37.7776485330384, -122.424011970547) | ||
| 68176 | 68176 | 110468 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005616.1343 | 2111331.3718 | 37.7776310557335 | -122.42411139247 | (37.7776310557335, -122.42411139247) | ||
| 73309 | 73309 | 110467 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | ||
| 74070 | 74070 | 110466 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6005573.1085 | 2111325.0754 | 37.777611337989605 | -122.42425978551701 | (37.7776113379896, -122.424259785517) | ||
| 74885 | 74885 | 97311 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.47618790715099 | (37.7431214880079, -122.476187907151) | ||
| 81079 | 81079 | 54103 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2317 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1972 12:00:00 AM | 3x3 | Permit Number 9832 | 6003101.11509235 | 2116824.39264322 | 37.792571182193605 | -122.43320427561301 | (37.7925711821936, -122.433204275613) | ||
| 92442 | 92442 | 37059 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 111616 | 111616 | 37061 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | |
| 130563 | 130563 | 31656 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1708 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 9 | 3x3 | Permit Number 35163 | 6004478.3831 | 2114720.074 | 37.7868712864461 | -122.428288835726 | (37.7868712864461, -122.428288835726) | |
| 135048 | 135048 | 55105 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 219 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11004 | 5998291.6539 | 2109868.1545 | 37.7731971698727 | -122.44934368775 | (37.7731971698727, -122.44934368775) | |
| 139908 | 139908 | 37062 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3x3 | Permit Number 39663 | 6003906.83973736 | 2099821.31146391 | 37.745930528166596 | -122.429203495744 | (37.7459305281666, -122.429203495744) | ||
| 148730 | 148730 | 67753 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1992 12:00:00 AM | 11 | 3x3 | Permit Number 31377 | 6011258.7412 | 2118020.5233 | 37.79631485229 | -122.405062718866 | (37.79631485229, -122.405062718866) | |
| 150827 | 150827 | 59162 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1981 12:00:00 AM | 16 | 3x3 | Permit Number 19443 | 6005553.1697 | 2111320.8777 | 37.7775986862615 | -122.424328461999 | (37.7775986862615, -122.424328461999) |
| 152607 | 152607 | 117030 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2100 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002496.7975 | 2114414.081 | 37.7859187837291 | -122.435122761266 | (37.7859187837291, -122.435122761266) | |||
| 155188 | 155188 | 87083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1711 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53300 | 6000537.4917 | 2114630.4681 | 37.7864014751637 | -122.44191693732799 | (37.7864014751637, -122.441916937328) | |
| 162030 | 162030 | 115983 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6011256.8768 | 2118034.0404 | 37.796351862758996 | -122.40507012236701 | (37.796351862759, -122.405070122367) | |||
| 164557 | 164557 | 59351 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 503 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52085 | 6000121.1922 | 2110676.4601 | 37.7755210539143 | -122.44307315376899 | (37.7755210539143, -122.443073153769) | |
| 164701 | 164701 | 58783 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 500 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1979 12:00:00 AM | 15 | 3x3 | Permit Number 18026 | 6005406.4028 | 2111007.6387 | 37.7767303197423 | -122.424813888538 | (37.7767303197423, -122.424813888538) | |
| 164818 | 164818 | 87369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | |
| 165188 | 165188 | 62369 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 137 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1985 12:00:00 AM | 9 | 3x3 | Permit Number 22515 | 5998258.1694 | 2110129.1192 | 37.773911796453596 | -122.44947832162799 | (37.7739117964536, -122.449478321628) | |
| 170111 | 170111 | 115985 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 900 Kearny St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6011253.147999999 | 2118063.4049 | 37.7964322821358 | -122.405085093558 | (37.7964322821358, -122.405085093558) | |||
| 171969 | 171969 | 56934 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1923 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 16 | 3x3 | Permit Number 14180 | 6001934.7565 | 2115177.2253 | 37.7879822517226 | -122.437121923696 | (37.7879822517226, -122.437121923696) | |
| 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) | ||
| 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) | |||
| 3051 | 3051 | 99233 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008063.2168 | 2121048.832 | 37.8044506767497 | -122.416334531861 | (37.8044506767497, -122.416334531861) | |||
| 3362 | 3362 | 114879 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1454 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2110394.0 | 37.7747880422892 | -122.440469509771 | (37.7747880422892, -122.440469509771) | ||||
| 5526 | 5526 | 99210 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007993.4855 | 2121112.3432 | 37.8046211410646 | -122.416580345595 | (37.8046211410646, -122.416580345595) | |||
| 5763 | 5763 | 107346 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 247 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5998163.7387 | 2112864.5437 | 37.7814171604492 | -122.450002161775 | (37.7814171604492, -122.450002161775) | |||
| 6691 | 6691 | 121389 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2646 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999473.1272 | 2113649.2828 | 37.7836466874196 | -122.445528775036 | (37.7836466874196, -122.445528775036) | |||
| 7025 | 7025 | 113774 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1716 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6000066.4859 | 2114892.9793 | 37.787095412064296 | -122.443565357608 | (37.7870954120643, -122.443565357608) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 28056 | 28056 | 110580 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 403 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001169.4361 | 2110112.2986 | 37.7740317204292 | -122.43940658540899 | (37.7740317204292, -122.439406585409) | |||
| 28900 | 28900 | 98468 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011948.2516 | 2107041.0959 | 37.7662064164751 | -122.40190466033701 | (37.7662064164751, -122.401904660337) | |||
| 29578 | 29578 | 108616 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 289 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6010459.7673 | 2120958.2392 | 37.8043364033733 | -122.408034626667 | (37.8043364033733, -122.408034626667) | |||
| 31784 | 31784 | 98024 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988098.058999999 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | |||
| 38098 | 38098 | 98472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887005 | -122.402121236301 | (37.766182021887, -122.402121236301) | |||
| 39408 | 39408 | 97935 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009806.2516 | 2121504.2981 | 37.8057991338594 | -122.41033476040501 | (37.8057991338594, -122.410334760405) | |||
| 46381 | 46381 | 98473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | |||
| 47183 | 47183 | 98470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011914.0134 | 2107036.3406 | 37.7661914486194 | -122.402022750022 | (37.7661914486194, -122.402022750022) | |||
| 51356 | 51356 | 120658 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778623 | 6015062.3817 | 2115495.3661 | 37.789593251915704 | -122.391724574055 | (37.7895932519157, -122.391724574055) | ||
| 55070 | 55070 | 120657 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 778623 | 6015078.8336 | 2115510.7898 | 37.7896365150846 | -122.39166873056001 | (37.7896365150846, -122.39166873056) | ||
| 59573 | 59573 | 111431 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999170.7617 | 2114883.4508 | 37.7870181241285 | -122.446663667925 | (37.7870181241285, -122.446663667925) | |||
| 62784 | 62784 | 112635 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1715 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6000531.3846 | 2114698.9549 | 37.786589174188705 | -122.441942983766 | (37.7865891741887, -122.441942983766) | |||
| 68465 | 68465 | 108005 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005304.2003 | 2110990.4457 | 37.7766773388863 | -122.425166213949 | (37.7766773388863, -122.425166213949) | |||
| 73003 | 73003 | 117049 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6002213.4716 | 2114319.9367 | 37.7856441950939 | -122.436096250016 | (37.7856441950939, -122.436096250016) | |||
| 74568 | 74568 | 97937 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768327 | 6009817.5879999995 | 2121415.668 | 37.8055564131765 | -122.410289267199 | (37.8055564131765, -122.410289267199) | |
| 76198 | 76198 | 113276 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2129 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002796.8552 | 2118506.6849 | 37.7971730575287 | -122.434377355222 | (37.7971730575287, -122.434377355222) | |||
| 77147 | 77147 | 104353 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2594 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5999783.3073 | 2113692.3242 | 37.7837825709749 | -122.444458768108 | (37.7837825709749, -122.444458768108) | |||
| 78346 | 78346 | 113409 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 108810 | 108810 | 113054 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 25 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003823.0 | 2108493.0 | 37.7697361782825 | -122.430111915017 | (37.7697361782825, -122.430111915017) | ||||
| 110431 | 110431 | 113408 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003890.0 | 2099760.0 | 37.74576122776671 | -122.429257354108 | (37.7457612277667, -122.429257354108) | ||||
| 116559 | 116559 | 113410 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401x DUNCAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003916.0 | 2099815.0 | 37.745913716911 | -122.429171370863 | (37.745913716911, -122.429171370863) | ||||
| 129651 | 129651 | 111432 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999166.6215 | 2114917.2623 | 37.7871107251509 | -122.446680425702 | (37.7871107251509, -122.446680425702) | |||
| 132458 | 132458 | 97936 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6009809.8586 | 2121486.2629 | 37.8057498158932 | -122.41032100357701 | (37.8057498158932, -122.410321003577) | |||
| 134413 | 134413 | 120659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 778623 | 6015041.8167 | 2115476.8576 | 37.7895412902416 | -122.391794432707 | (37.7895412902416, -122.391794432707) | ||
| 145969 | 145969 | 113486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998975.0 | 2116473.0 | 37.7913714231174 | -122.44745541416201 | (37.7913714231174, -122.447455414162) | ||||
| 150219 | 150219 | 97934 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2133 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009804.1904 | 2121525.9403 | 37.8058584423979 | -122.410343422594 | (37.8058584423979, -122.410343422594) | |||
| 152489 | 152489 | 111433 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500X Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999168.0016 | 2114897.9415 | 37.7870577541309 | -122.446674260217 | (37.7870577541309, -122.446674260217) | |||
| 153429 | 153429 | 113988 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002243.1253 | 2114325.3833 | 37.7856608347208 | -122.43599404678801 | (37.7856608347208, -122.435994046788) | |||
| 155805 | 155805 | 108006 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 520 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6005290.3504 | 2110988.0578 | 37.7766699998805 | -122.425213954913 | (37.7766699998805, -122.425213954913) | |||
| 163651 | 163651 | 117047 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2183 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002170.5041 | 2114314.4901 | 37.7856267989414 | -122.43624451502701 | (37.7856267989414, -122.436244515027) | |||
| 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) | |||
| 1336 | 1336 | 7171 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003475.9145 | 2111120.5411 | 37.7769310959731 | -122.431500078765 | (37.7769310959731, -122.431500078765) | ||
| 1340 | 1340 | 7172 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003478.683999999 | 2111101.7087 | 37.7768795438362 | -122.43148915347099 | (37.7768795438362, -122.431489153471) | ||
| 1343 | 1343 | 7169 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 801 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | Permit Number 780067 | 6003470.3756 | 2111160.9753 | 37.777041804334296 | -122.43152212680799 | (37.7770418043343, -122.431522126808) |
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");