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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107629 | 107629 | 33588 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | |||
| 104502 | 104502 | 33585 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.740543028887295 | -122.418608458082 | (37.7405430288873, -122.418608458082) | |||
| 108242 | 108242 | 33581 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | |||
| 81512 | 81512 | 33580 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | |||
| 116527 | 116527 | 33576 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 170 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | 18 | 2.5x4 | Permit Number 37684 | 6007080.60152815 | 2098048.2941617 | 37.7412413768938 | -122.41810336116998 | (37.7412413768938, -122.41810336117) | |
| 96551 | 96551 | 33508 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | |||
| 77427 | 77427 | 32868 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601704996 | -122.430300092251 | (37.736503601705, -122.430300092251) | |||
| 87790 | 87790 | 32047 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 140871 | 140871 | 32046 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610.0 | 2086139.0 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | ||
| 116256 | 116256 | 32039 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.803561986725505 | -122.43352085652398 | (37.8035619867255, -122.433520856524) | |||
| 77451 | 77451 | 31969 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.725219944905895 | -122.40926189775499 | (37.7252199449059, -122.409261897755) | |||
| 96095 | 96095 | 31350 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 843 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34960 | 6003828.78534548 | 2110731.50789971 | 37.7758829003399 | -122.43025162922702 | (37.7758829003399, -122.430251629227) | ||
| 115455 | 115455 | 31210 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.43838455687201 | (37.7951689006516, -122.438384556872) | |||
| 134768 | 134768 | 30927 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 236 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34740 | 5996038.7385 | 2091232.9544799998 | 37.7219004244455 | -122.455789433158 | (37.7219004244455, -122.455789433158) | |
| 150299 | 150299 | 30926 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.3003900002 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | |
| 80869 | 80869 | 30892 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
| 102110 | 102110 | 30891 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
| 141323 | 141323 | 30890 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | |||
| 91059 | 91059 | 30886 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.40601460797501 | (37.8012494094877, -122.406014607975) | ||||
| 109018 | 109018 | 30843 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | ||
| 146184 | 146184 | 30538 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.775067091373295 | -122.43095343382099 | (37.7750670913733, -122.430953433821) | ||||
| 81288 | 81288 | 30534 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 81461 | 81461 | 30532 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 85365 | 85365 | 30533 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
| 91480 | 91480 | 30505 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 34518 | 6007587.04685478 | 2110100.36731732 | 37.7743620934089 | -122.417206068405 | (37.7743620934089, -122.417206068405) | |||
| 124581 | 124581 | 69485 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 560 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33606 | 6008946.01217425 | 2105621.19939594 | 37.7621396967865 | -122.412188502645 | (37.7621396967865, -122.412188502645) | ||
| 9838 | 9838 | 68204 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.754245896491604 | -122.408413088762 | (37.7542458964916, -122.408413088762) |
| 143752 | 143752 | 68371 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1233 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32193 | 5998967.61980979 | 2105592.97843293 | 37.7614972584923 | -122.44669777928699 | (37.7614972584923, -122.446697779287) | ||
| 85104 | 85104 | 98237 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 97387 | 97387 | 98238 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1299X 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 32025 | 5993314.0 | 2106663.0 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | ||||
| 122183 | 122183 | 60432 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 447 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | ||
| 103274 | 103274 | 67815 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.42976652391701 | (37.7536681560563, -122.429766523917) | ||
| 107440 | 107440 | 67594 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | ||
| 106879 | 106879 | 67263 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.778002010661105 | -122.508136768544 | (37.7780020106611, -122.508136768544) | ||
| 80250 | 80250 | 67152 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30584 | 6009956.04429273 | 2098629.91177988 | 37.7429997970033 | -122.408202066775 | (37.7429997970033, -122.408202066775) | ||
| 146115 | 146115 | 67150 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | ||
| 120253 | 120253 | 67096 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.40803152307899 | (37.7428626163512, -122.408031523079) | ||
| 82018 | 82018 | 67095 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.40821208958799 | (37.7428561528472, -122.408212089588) | ||
| 145344 | 145344 | 66937 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.44754212322201 | (37.7786310079222, -122.447542123222) | ||
| 115854 | 115854 | 66878 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 281 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30189 | 6001145.91509222 | 2104727.87963003 | 37.7592460999874 | -122.439101967223 | (37.7592460999874, -122.439101967223) | ||
| 142775 | 142775 | 53343 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 620 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1995 12:00:00 AM | Permit Number 30179 | 6009598.94591555 | 2115405.06508937 | 37.7890405143898 | -122.410621189952 | (37.7890405143898, -122.410621189952) | ||
| 97958 | 97958 | 66869 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 640 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30178 | 6009507.57601331 | 2115392.34348399 | 37.789000460867 | -122.410936420318 | (37.789000460867, -122.410936420318) | ||
| 106510 | 106510 | 66867 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 15 | 3x3 | Permit Number 30174 | 6008155.266254799 | 2115151.32890411 | 37.788262771233 | -122.41559817658899 | (37.788262771233, -122.415598176589) | |
| 87335 | 87335 | 63397 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.759226666669505 | -122.437077536949 | (37.7592266666695, -122.437077536949) | ||
| 94548 | 94548 | 66852 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 805 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30158 | 6008246.52380896 | 2115214.16051417 | 37.788440420773796 | -122.415286889274 | (37.7884404207738, -122.415286889274) | ||
| 125498 | 125498 | 66848 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 919 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30152 | 6008182.6560056 | 2115155.17049763 | 37.7882748588768 | -122.41550368440399 | (37.7882748588768, -122.415503684404) | ||
| 101414 | 101414 | 66836 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | ||
| 110011 | 110011 | 58069 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4525 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30131 | 6000914.77254872 | 2105195.89592401 | 37.7605180033322 | -122.439934925187 | (37.7605180033322, -122.439934925187) | ||
| 17857 | 17857 | 66830 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1991 12:00:00 AM | Permit Number 30127 | 6001175.80343985 | 2104102.01378806 | 37.7575293253254 | -122.43895374638201 | (37.7575293253254, -122.438953746382) | ||
| 96990 | 96990 | 99016 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | ||||
| 121145 | 121145 | 61711 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 232 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1991 12:00:00 AM | Permit Number 29947 | 6005210.12151982 | 2108247.78406465 | 37.7691413389079 | -122.42529644575501 | (37.7691413389079, -122.425296445755) | ||
| 182926 | 182926 | 66628 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 412 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 16 | Permit Number 29832 | 6002951.536859999 | 2091458.2652 | 37.7229133848294 | -122.43190974564399 | (37.7229133848294, -122.431909745644) | ||
| 124078 | 124078 | 66488 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1043 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | Permit Number 29647 | 6007587.84875499 | 2109703.11754078 | 37.7732713850209 | -122.417175139527 | (37.7732713850209, -122.417175139527) | ||
| 116808 | 116808 | 66469 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1991 12:00:00 AM | Permit Number 29620 | 6002231.09425836 | 2109952.33731326 | 37.7736528678468 | -122.435722686817 | (37.7736528678468, -122.435722686817) | ||
| 79447 | 79447 | 66438 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 650X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1991 12:00:00 AM | Permit Number 29582 | 6003603.61647971 | 2110556.18401653 | 37.7753887478808 | -122.43101802993601 | (37.7753887478808, -122.431018029936) | ||
| 85639 | 85639 | 66379 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 625 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29504 | 6003563.84234841 | 2110464.21135378 | 37.7751339598215 | -122.431149051781 | (37.7751339598215, -122.431149051781) | ||
| 96682 | 96682 | 66375 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 612 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29499 | 6003620.76837837 | 2110432.17499844 | 37.775049221566206 | -122.430949845165 | (37.7750492215662, -122.430949845165) | ||
| 97049 | 97049 | 66374 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 600 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29498 | 6003626.18476729 | 2110393.01425684 | 37.7749420027203 | -122.430928313262 | (37.7749420027203, -122.430928313262) | ||
| 104494 | 104494 | 66311 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1990 12:00:00 AM | Permit Number 29426 | 6001329.17242898 | 2095394.93152934 | 37.7336304648573 | -122.43779972754601 | (37.7336304648573, -122.437799727546) | ||
| 141729 | 141729 | 66225 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 36 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29319 | 6005318.51312392 | 2105778.36560715 | 37.76236702737 | -122.42474582707099 | (37.76236702737, -122.424745827071) | ||
| 89802 | 89802 | 66224 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 32 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29318 | 6005343.90687 | 2105779.62004334 | 37.762371905949294 | -122.424658088706 | (37.7623719059493, -122.424658088706) | ||
| 107787 | 107787 | 66222 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 48 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29314 | 6005242.33190892 | 2105774.60229973 | 37.7623523912444 | -122.42500904201599 | (37.7623523912444, -122.425009042016) | ||
| 83369 | 83369 | 66220 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1 Dolores Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29312 | 6005304.82019082 | 2105877.54249684 | 37.7626385702507 | -122.424800241819 | (37.7626385702507, -122.424800241819) | ||
| 108545 | 108545 | 66218 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 81 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29310 | 6005039.41557773 | 2105712.51494257 | 37.7621704498093 | -122.425706435205 | (37.7621704498093, -122.425706435205) | ||
| 97562 | 97562 | 66216 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 438 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1990 12:00:00 AM | Permit Number 29307 | 6008473.34152559 | 2106010.06053059 | 37.763180886532396 | -122.41385080311501 | (37.7631808865324, -122.413850803115) | ||
| 93573 | 93573 | 66119 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 223 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29179 | 6005470.38749546 | 2110092.46405208 | 37.7742210861409 | -122.424527432779 | (37.7742210861409, -122.424527432779) | ||
| 141268 | 141268 | 66115 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 817 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29170 | 6003947.68857827 | 2110748.1234611 | 37.7759352566539 | -122.429841497852 | (37.7759352566539, -122.429841497852) | ||
| 126631 | 126631 | 66042 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 303 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1990 12:00:00 AM | Permit Number 29081 | 6002303.92307718 | 2106443.08966771 | 37.7640214741501 | -122.43521970611201 | (37.7640214741501, -122.435219706112) | ||
| 104397 | 104397 | 65917 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1322 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28932 | 5994588.71634117 | 2106515.79856518 | 37.7637799716089 | -122.461909408356 | (37.7637799716089, -122.461909408356) | ||
| 80600 | 80600 | 65894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 649 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.799327449486704 | -122.40980081755501 | (37.7993274494867, -122.409800817555) | ||
| 87287 | 87287 | 65844 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | Permit Number 28834 | 5999811.44226859 | 2119196.23574668 | 37.798896470812004 | -122.44475718144301 | (37.798896470812, -122.444757181443) | ||
| 82331 | 82331 | 65673 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | ||
| 52254 | 52254 | 65586 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1990 12:00:00 AM | 10 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.39373752768499 | (37.7364462435881, -122.393737527685) | ||
| 20372 | 20372 | 65541 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2146 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | Permit Number 28438 | 6002328.18536025 | 2114391.9672646 | 37.78584848917 | -122.43570452929701 | (37.78584848917, -122.435704529297) | ||
| 91089 | 91089 | 65540 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.78583249572021 | -122.43583034619199 | (37.7858324957202, -122.435830346192) | |
| 94531 | 94531 | 65486 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | Permit Number 28370 | 6009649.36997858 | 2115707.80146662 | 37.7898745823318 | -122.410468114048 | (37.7898745823318, -122.410468114048) | ||
| 96192 | 96192 | 65478 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 601 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1989 12:00:00 AM | Permit Number 28359 | 6010541.36110634 | 2116214.27782437 | 37.7913152098094 | -122.407417612453 | (37.7913152098094, -122.407417612453) | ||
| 118567 | 118567 | 65474 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1185 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28355 | 5995034.99249971 | 2091783.3730714 | 37.72335408532629 | -122.459298943633 | (37.7233540853263, -122.459298943633) | ||
| 124159 | 124159 | 65465 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 618 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28343 | 5994991.49008264 | 2091257.73775868 | 37.721908315427704 | -122.459411273619 | (37.7219083154277, -122.459411273619) | ||
| 110473 | 110473 | 101515 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 610 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 28301 | 6008387.0 | 2114552.0 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | ||
| 128800 | 128800 | 101516 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 28301 | 6008387.0 | 2114552.0 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | ||
| 120721 | 120721 | 65423 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 801 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 28281 | 6010517.63649674 | 2116529.16048818 | 37.7921784739149 | -122.40752190934299 | (37.7921784739149, -122.407521909343) | ||
| 94180 | 94180 | 61525 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1341 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1989 12:00:00 AM | Permit Number 28272 | 5991348.55791434 | 2114747.92419088 | 37.7861960776153 | -122.47371658077299 | (37.7861960776153, -122.473716580773) | ||
| 90716 | 90716 | 65402 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077.0 | 2114493.0 | 37.7864507606031 | -122.41582233096099 | (37.7864507606031, -122.415822330961) |
| 143571 | 143571 | 65401 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | ||
| 114331 | 114331 | 65399 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 471 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1989 12:00:00 AM | Permit Number 28247 | 6008612.45505665 | 2113822.69504434 | 37.7846403524021 | -122.41392234969 | (37.7846403524021, -122.41392234969) | ||
| 90199 | 90199 | 65243 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1086 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28037 | 6009165.76758609 | 2102839.33295033 | 37.754513650320504 | -122.411231929366 | (37.7545136503205, -122.411231929366) | ||
| 109294 | 109294 | 65199 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 393 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27185 | 6003086.32595187 | 2091584.19795725 | 37.723266808431795 | -122.431452793676 | (37.7232668084318, -122.431452793676) | ||
| 53602 | 53602 | 64963 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1701 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | Permit Number 25998 | 6004752.02742796 | 2119466.94279483 | 37.7999204646826 | -122.42768042225599 | (37.7999204646826, -122.427680422256) | ||
| 5741 | 5741 | 64939 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.598230001 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | |
| 84615 | 84615 | 64894 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1450 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/1989 12:00:00 AM | Permit Number 25920 | 6005836.52150612 | 2100535.66309095 | 37.7480010261231 | -122.42258166386499 | (37.7480010261231, -122.422581663865) | ||
| 145722 | 145722 | 64807 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25809 | 6002370.48571479 | 2099839.6903707 | 37.7458938988463 | -122.434517304917 | (37.7458938988463, -122.434517304917) | ||
| 120319 | 120319 | 64776 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 816 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 25768 | 6010808.79838009 | 2116967.92817235 | 37.7933995175775 | -122.40654541205299 | (37.7933995175775, -122.406545412053) | ||
| 112038 | 112038 | 64775 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 517 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1989 12:00:00 AM | Permit Number 25767 | 6010461.649147 | 2119569.81510368 | 37.8005242381712 | -122.407930145171 | (37.8005242381712, -122.407930145171) | ||
| 90546 | 90546 | 64702 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.40842605163701 | (37.7845809377612, -122.408426051637) | ||
| 110545 | 110545 | 64727 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.78428168151439 | -122.410412412425 | (37.7842816815144, -122.410412412425) | ||
| 140269 | 140269 | 64726 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 127 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25681 | 6010217.12887008 | 2114048.91615067 | 37.7853514923776 | -122.40838665256001 | (37.7853514923776, -122.40838665256) | ||
| 102130 | 102130 | 64725 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.785406080036296 | -122.409096504402 | (37.7854060800363, -122.409096504402) | ||
| 98642 | 98642 | 64717 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 35 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1988 12:00:00 AM | Permit Number 25671 | 6010371.58706878 | 2113906.86566108 | 37.7849701038252 | -122.407842251054 | (37.7849701038252, -122.407842251054) | ||
| 111917 | 111917 | 64693 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 110 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | Permit Number 25636 | 6005573.37725141 | 2104043.9306623 | 37.757619067817394 | -122.423741017308 | (37.7576190678174, -122.423741017308) |
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");