Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5613 | 5613 | 31854 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1263 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35300 | ||||||||
| 6308 | 6308 | 35982 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 83 Prospect Stairs Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39135 | ||||||||
| 7665 | 7665 | 35798 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39046 | |||||||||
| 8249 | 8249 | 35981 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 83 Prospect Stairs Street | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1998 12:00:00 AM | Permit Number 39135 | ||||||||
| 9581 | 9581 | 35799 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39046 | |||||||||
| 9858 | 9858 | 120511 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | |
| 9869 | 9869 | 120514 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | |
| 9870 | 9870 | 120510 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | |
| 9871 | 9871 | 120513 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | |
| 9876 | 9876 | 120512 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778696 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | |
| 10579 | 10579 | 35800 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39046 | |||||||||
| 12266 | 12266 | 35801 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1998 12:00:00 AM | Permit Number 39046 | |||||||||
| 13340 | 13340 | 42050 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13342 | 13342 | 42051 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13346 | 13346 | 42052 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 13351 | 13351 | 42049 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 405 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 779344 | 6003892.7703069 | 2099803.34109747 | 37.7458803892155 | -122.42925086473 | (37.7458803892155, -122.42925086473) | ||
| 15642 | 15642 | 31853 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1263 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35300 | ||||||||
| 17035 | 17035 | 110333 | DPW Maintained 3 | Arecastrum romanzoffianum :: Queen Palm 238 | 53x DEARBORN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005854.0 | 2105793.0 | 37.7624374394694 | -122.422894814814 | (37.7624374394694, -122.422894814814) | ||||
| 17862 | 17862 | 36678 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 16 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 18072 | 18072 | 42004 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 49599 | 49599 | 49854 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 50150 | 50150 | 72838 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3166 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/20/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768580 | 6008564.90127915 | 2101578.02320048 | 37.7510166609997 | -122.413220703223 | (37.7510166609997, -122.413220703223) |
| 50496 | 50496 | 37975 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1199 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 77719 | 77719 | 37688 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 337 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2004 12:00:00 AM | Permit Number 40076 | 6007827.58787691 | 2105971.77560699 | 37.7630394784034 | -122.41608154408999 | (37.7630394784034, -122.41608154409) | ||
| 78066 | 78066 | 33811 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 316 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37826 | 6006425.25516212 | 2098022.87661931 | 37.741134678158396 | -122.42036751679501 | (37.7411346781584, -122.420367516795) | |||
| 80348 | 80348 | 35771 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3692 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1998 12:00:00 AM | Permit Number 39030 | 6004971.89537308 | 2105472.67366607 | 37.7615080868858 | -122.42592288859501 | (37.7615080868858, -122.425922888595) | ||
| 80897 | 80897 | 52321 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4308 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | ||
| 80917 | 80917 | 33810 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 316 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/1996 12:00:00 AM | Permit Number 37826 | 6006425.25516212 | 2098022.87661931 | 37.741134678158396 | -122.42036751679501 | (37.7411346781584, -122.420367516795) | ||
| 81248 | 81248 | 42813 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3870 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2000 12:00:00 AM | Permit Number 42758 | 6003129.90589882 | 2105954.71488178 | 37.762727385365 | -122.432327995192 | (37.762727385365, -122.432327995192) | ||
| 81404 | 81404 | 42003 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 81774 | 81774 | 34500 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 25 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38222 | 6009645.01690865 | 2098580.66047923 | 37.74284714300121 | -122.409274044281 | (37.7428471430012, -122.409274044281) | ||
| 82048 | 82048 | 42927 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 500 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42831 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | |||
| 82252 | 82252 | 40321 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3498x 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41461 | 6006512.30004445 | 2100871.01023057 | 37.7489599147889 | -122.420268642175 | (37.7489599147889, -122.420268642175) | ||
| 82828 | 82828 | 40322 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3498x 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41461 | 6006512.30004445 | 2100871.01023057 | 37.7489599147889 | -122.420268642175 | (37.7489599147889, -122.420268642175) | ||
| 82892 | 82892 | 42008 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 83030 | 83030 | 40709 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41688 | 6004184.11835809 | 2094337.00833883 | 37.730887572261096 | -122.427853990581 | (37.7308875722611, -122.427853990581) | ||
| 85217 | 85217 | 52319 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4308 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | ||
| 85491 | 85491 | 41810 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 100 Anzavista Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.77965465913321 | -122.443491289074 | (37.7796546591332, -122.443491289074) | ||
| 85579 | 85579 | 36046 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3057 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39181 | 6008358.98035191 | 2106192.95330852 | 37.763676644711396 | -122.414259282291 | (37.7636766447114, -122.414259282291) | ||
| 86644 | 86644 | 110335 | DPW Maintained 3 | Arecastrum romanzoffianum :: Queen Palm 238 | 53x DEARBORN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6005854.0 | 2105793.0 | 37.7624374394694 | -122.422894814814 | (37.7624374394694, -122.422894814814) | ||||
| 87053 | 87053 | 49849 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 87373 | 87373 | 39750 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 87 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41118 | 6003060.76773686 | 2105607.00413324 | 37.7617687350382 | -122.43254228184601 | (37.7617687350382, -122.432542281846) | ||
| 87620 | 87620 | 42082 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 301 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42392 | 6008452.52473671 | 2100207.10363126 | 37.747246112868794 | -122.413512366427 | (37.7472461128688, -122.413512366427) | ||
| 87730 | 87730 | 42005 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 89293 | 89293 | 31428 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4220 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.755587799648794 | -122.43802315041201 | (37.7555877996488, -122.438023150412) | ||
| 89718 | 89718 | 67787 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3869 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1996 12:00:00 AM | Permit Number 31427 | 6003995.24886848 | 2102441.58633155 | 37.753130196506795 | -122.429084582188 | (37.7531301965068, -122.429084582188) | ||
| 91172 | 91172 | 67854 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 338 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31524 | 6004320.878750499 | 2099880.04207248 | 37.746115219116994 | -122.42777598909099 | (37.746115219117, -122.427775989091) | ||
| 91316 | 91316 | 31426 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4220 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.755587799648794 | -122.43802315041201 | (37.7555877996488, -122.438023150412) | ||
| 91727 | 91727 | 36679 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 91906 | 91906 | 108142 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 3390x 18TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.41906470461399 | (37.7620037686995, -122.419064704614) | ||||
| 93115 | 93115 | 49848 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 93141 | 93141 | 43906 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43506 | 6010229.84125337 | 2102875.27259753 | 37.7546719517198 | -122.407554599825 | (37.7546719517198, -122.407554599825) | ||
| 93418 | 93418 | 41806 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 100 Anzavista Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.77965465913321 | -122.443491289074 | (37.7796546591332, -122.443491289074) | ||
| 93606 | 93606 | 42930 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 500 Florida St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42831 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | |||
| 93743 | 93743 | 31425 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4220 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.755587799648794 | -122.43802315041201 | (37.7555877996488, -122.438023150412) | ||
| 94859 | 94859 | 67606 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1996 12:00:00 AM | Permit Number 31179 | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.40520872358499 | (37.7715678900614, -122.405208723585) | ||
| 94949 | 94949 | 41813 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 100 Anzavista Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.77965465913321 | -122.443491289074 | (37.7796546591332, -122.443491289074) | ||
| 95355 | 95355 | 97104 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 882 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x2 | 6009914.0 | 2104066.0 | 37.7579237379711 | -122.40873086744301 | (37.7579237379711, -122.408730867443) | |||
| 96707 | 96707 | 46642 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 38 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2002 12:00:00 AM | Permit Number 44771 | 5995904.25233088 | 2114246.62473666 | 37.7850824383786 | -122.457918884189 | (37.7850824383786, -122.457918884189) | |||
| 97781 | 97781 | 18450 | DPW Maintained 3 | Arecastrum romanzoffianum :: Queen Palm 238 | 1076 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1991 12:00:00 AM | 16 | 3X3 | 6010491.0176247 | 2102966.2831111 | 37.754936462314205 | -122.406657790304 | (37.7549364623142, -122.406657790304) | ||
| 97822 | 97822 | 42006 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 98211 | 98211 | 96696 | DPW Maintained 3 | Arecastrum romanzoffianum :: Queen Palm 238 | 1599X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015060.5348 | 2095438.8049400002 | 37.7345221731935 | -122.390329076986 | (37.7345221731935, -122.390329076986) | |||
| 98569 | 98569 | 36030 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 94 Bernal Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39177 | 6009602.87922047 | 2098220.81280992 | 37.741856718877294 | -122.409394355394 | (37.7418567188773, -122.409394355394) | ||
| 98792 | 98792 | 108275 | Significant Tree 6 | Arecastrum romanzoffianum :: Queen Palm 238 | 1800x ALAMEDA ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 15 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 98897 | 98897 | 49632 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 63@ HOWARD Kissling St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2003 12:00:00 AM | Permit Number 46485 | 6008295.13782655 | 2109508.07731358 | 37.7727756153304 | -122.41471471751001 | (37.7727756153304, -122.41471471751) | ||
| 99496 | 99496 | 37513 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 835 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39970 | 6007729.27336023 | 2114396.12651658 | 37.786165215164 | -122.41701851476601 | (37.786165215164, -122.417018514766) | ||
| 99562 | 99562 | 52322 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4308 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48475 | 6001136.61726657 | 2103347.24100136 | 37.7554546726713 | -122.43903517577 | (37.7554546726713, -122.43903517577) | ||
| 99940 | 99940 | 36676 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 99X ALBION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39481 | 6005790.0 | 2106965.0 | 37.7656518628938 | -122.42319948021999 | (37.7656518628938, -122.42319948022) | |
| 100235 | 100235 | 31039 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 743 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34798 | 6002570.79818377 | 2087220.23414259 | 37.7112550964884 | -122.43292325262101 | (37.7112550964884, -122.432923252621) | ||
| 100497 | 100497 | 42469 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 48 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42611 | 5999793.72085734 | 2095526.96261347 | 37.733905561585395 | -122.443117692605 | (37.7339055615854, -122.443117692605) | ||
| 100511 | 100511 | 110332 | DPW Maintained 3 | Arecastrum romanzoffianum :: Queen Palm 238 | 53x DEARBORN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005854.0 | 2105793.0 | 37.7624374394694 | -122.422894814814 | (37.7624374394694, -122.422894814814) | |||
| 100637 | 100637 | 49850 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 100909 | 100909 | 41811 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 100 Anzavista Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.77965465913321 | -122.443491289074 | (37.7796546591332, -122.443491289074) | ||
| 101054 | 101054 | 42002 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 240 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42337 | 5993892.40263021 | 2094032.39552185 | 37.7294635953142 | -122.463411763134 | (37.7294635953142, -122.463411763134) | ||
| 102085 | 102085 | 42929 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 500 Florida St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42831 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | |||
| 102149 | 102149 | 49855 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 102590 | 102590 | 37273 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3835 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2005 12:00:00 AM | Permit Number 48093 | 6002885.4241061 | 2102966.59502763 | 37.7545088594203 | -122.4329600781 | (37.7545088594203, -122.4329600781) | ||
| 103417 | 103417 | 35774 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3692 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | Permit Number 39030 | 6004971.89537308 | 2105472.67366607 | 37.7615080868858 | -122.42592288859501 | (37.7615080868858, -122.425922888595) | ||
| 103633 | 103633 | 91382 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3255 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2009 12:00:00 AM | 3x3 | Permit Number 52080 | 6006568.9 | 2103493.4 | 37.7561635850725 | -122.420259015234 | (37.7561635850725, -122.420259015234) | ||
| 105352 | 105352 | 97103 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 882 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2007 12:00:00 AM | 14 | 2x2 | 6009914.0 | 2104066.0 | 37.7579237379711 | -122.40873086744301 | (37.7579237379711, -122.408730867443) | ||
| 105756 | 105756 | 120507 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 888 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6011033.13178113 | 2109012.34051696 | 37.7715678900614 | -122.40520872358499 | (37.7715678900614, -122.405208723585) | ||||
| 106259 | 106259 | 42928 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 500 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42831 | 6009210.68116468 | 2105903.38929548 | 37.7629293730529 | -122.411293045793 | (37.7629293730529, -122.411293045793) | |||
| 106756 | 106756 | 26151 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1500 Oakdale Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
| 106924 | 106924 | 108287 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 1 HENRY ADAMS ST | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 107230 | 107230 | 35725 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 190 Dartmouth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 108168 | 108168 | 41985 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 143 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42325 | 5994934.83631929 | 2091867.32624102 | 37.7235788417252 | -122.459651240236 | (37.7235788417252, -122.459651240236) | ||
| 108821 | 108821 | 47120 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 81 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45103 | 6006109.36945154 | 2097632.81728263 | 37.740045857146896 | -122.42143204332599 | (37.7400458571469, -122.421432043326) | ||
| 109520 | 109520 | 58288 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 338 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51750 | 6002903.89546307 | 2106265.3823574 | 37.763567585215 | -122.433131882506 | (37.763567585215, -122.433131882506) | ||
| 110978 | 110978 | 43907 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2000 12:00:00 AM | Permit Number 43506 | 6010229.84125337 | 2102875.27259753 | 37.7546719517198 | -122.407554599825 | (37.7546719517198, -122.407554599825) | |||
| 112011 | 112011 | 40320 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3498x 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41461 | 6006512.30004445 | 2100871.01023057 | 37.7489599147889 | -122.420268642175 | (37.7489599147889, -122.420268642175) | ||
| 112411 | 112411 | 108139 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 3390x 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006957.7 | 2105612.4 | 37.7620037686995 | -122.41906470461399 | (37.7620037686995, -122.419064704614) | ||||
| 112968 | 112968 | 42083 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 301 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42392 | 6008452.52473671 | 2100207.10363126 | 37.747246112868794 | -122.413512366427 | (37.7472461128688, -122.413512366427) | ||
| 113510 | 113510 | 49851 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 600@ WOODSIDE Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | Permit Number 46628 | 5997402.05166497 | 2099836.0241137003 | 37.7456005399249 | -122.451697110084 | (37.7456005399249, -122.451697110084) | |||
| 113625 | 113625 | 31424 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 4220 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35007 | 6001430.13223279 | 2103389.64483278 | 37.755587799648794 | -122.43802315041201 | (37.7555877996488, -122.438023150412) | ||
| 114216 | 114216 | 41805 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 100 Anzavista Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42201 | 6000031.62407676 | 2112183.77888854 | 37.77965465913321 | -122.443491289074 | (37.7796546591332, -122.443491289074) | ||
| 114484 | 114484 | 39791 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 50 San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/1999 12:00:00 AM | Permit Number 41142 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.42156762045201 | (37.7544443606741, -122.421567620452) | ||
| 115309 | 115309 | 42940 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 90 14TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42835 | 6008035.0 | 2107992.0 | 37.768598204141995 | -122.415507210488 | (37.768598204142, -122.415507210488) | |||
| 115509 | 115509 | 37974 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1199 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1998 12:00:00 AM | Permit Number 40204 | 6015599.59779117 | 2103398.4652457 | 37.756407638243296 | -122.38902089785499 | (37.7564076382433, -122.389020897855) | ||
| 115668 | 115668 | 43908 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 1090 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2000 12:00:00 AM | Permit Number 43506 | 6010229.84125337 | 2102875.27259753 | 37.7546719517198 | -122.407554599825 | (37.7546719517198, -122.407554599825) | |||
| 116209 | 116209 | 35772 | Permitted Site 1 | Arecastrum romanzoffianum :: Queen Palm 238 | 3692 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | Permit Number 39030 | 6004971.89537308 | 2105472.67366607 | 37.7615080868858 | -122.42592288859501 | (37.7615080868858, -122.425922888595) |
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");