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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94065 | 94065 | 41897 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | ||
| 94918 | 94918 | 42310 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | |||
| 94982 | 94982 | 39859 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 95230 | 95230 | 67807 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | ||
| 95324 | 95324 | 49073 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 97141 | 97141 | 88373 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306.0 | 2109414.0 | 37.77257404455771 | -122.411211370961 | (37.7725740445577, -122.411211370961) | ||
| 97652 | 97652 | 4167 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.9859700003 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | ||
| 98175 | 98175 | 44261 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 98234 | 98234 | 37726 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2858 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/1998 12:00:00 AM | Permit Number 40090 | 6010246.00158069 | 2101670.73784629 | 37.7513654710612 | -122.407413798897 | (37.7513654710612, -122.407413798897) | ||
| 98438 | 98438 | 117606 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 98468 | 98468 | 34082 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 98537 | 98537 | 34079 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 98559 | 98559 | 40735 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 84 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41714 | 6009129.35799057 | 2096983.96477733 | 37.7384340613324 | -122.410944305546 | (37.7384340613324, -122.410944305546) | ||
| 99383 | 99383 | 49074 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 100434 | 100434 | 108225 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 101513 | 101513 | 83941 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 60 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3X3 | Permit Number 50121 | 6008302.41836553 | 2108360.42350377 | 37.7696248364946 | -122.41460830425899 | (37.7696248364946, -122.414608304259) | ||
| 101582 | 101582 | 42735 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 101783 | 101783 | 47561 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 580 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418002 | (37.7574192165742, -122.41793254418) | ||
| 101992 | 101992 | 66205 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1990 12:00:00 AM | Permit Number 29289 | 6010420.85602386 | 2100006.0506029 | 37.746804390663 | -122.406691826217 | (37.746804390663, -122.406691826217) | |||
| 102992 | 102992 | 34050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 103766 | 103766 | 85491 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400 24th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641.0 | 2101716.0 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | |||
| 105088 | 105088 | 67713 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 557 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31325 | 6014732.24235944 | 2112894.33120186 | 37.782433074017504 | -122.392684800601 | (37.7824330740175, -122.392684800601) | ||
| 105310 | 105310 | 42309 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | |||
| 105965 | 105965 | 108221 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 106308 | 106308 | 34076 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 106791 | 106791 | 44009 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 1 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 107827 | 107827 | 115617 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 107863 | 107863 | 39860 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 108893 | 108893 | 44008 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 2 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 109165 | 109165 | 44264 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 109559 | 109559 | 98644 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2391 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008222.0 | 2104509.0 | 37.7590452010005 | -122.414613883143 | (37.7590452010005, -122.414613883143) | |||
| 109593 | 109593 | 42738 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 110007 | 110007 | 115616 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1400 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||||
| 110112 | 110112 | 115632 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012114.0 | 2107494.0 | 37.7674592382642 | -122.40136319642001 | (37.7674592382642, -122.40136319642) | ||||
| 110283 | 110283 | 34049 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 111471 | 111471 | 52313 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 111680 | 111680 | 34054 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 111888 | 111888 | 49075 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 112114 | 112114 | 42733 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 112598 | 112598 | 47560 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 580 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45422 | 6007250.69827751 | 2103936.71356757 | 37.7574192165742 | -122.41793254418002 | (37.7574192165742, -122.41793254418) | ||
| 112993 | 112993 | 99104 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3644 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006000.9 | 2104423.0 | 37.7586840282695 | -122.422289399469 | (37.7586840282695, -122.422289399469) | ||||
| 113895 | 113895 | 52312 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 114146 | 114146 | 34047 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 114868 | 114868 | 83791 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50933 | 6008828.16902132 | 2097088.78446754 | 37.7387049796432 | -122.411993079981 | (37.7387049796432, -122.411993079981) | ||
| 115414 | 115414 | 52311 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | ||
| 116223 | 116223 | 44262 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 116426 | 116426 | 65602 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.9135900002 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | |
| 116911 | 116911 | 109315 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 117278 | 117278 | 50801 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | ||
| 117733 | 117733 | 62050 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008120.0 | 2108416.0 | 37.769767186200795 | -122.41524321981701 | (37.7697671862008, -122.415243219817) | ||
| 117817 | 117817 | 42739 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 118122 | 118122 | 108224 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118194 | 118194 | 108227 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 118249 | 118249 | 39861 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 70 13th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50122 | 6008235.62773227 | 2108364.64558499 | 37.7696326766808 | -122.41483963035499 | (37.7696326766808, -122.414839630355) | ||
| 119574 | 119574 | 47386 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 400 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45302 | 5998534.7421818 | 2087640.83447452 | 37.712180218724896 | -122.446903063491 | (37.7121802187249, -122.446903063491) | |||
| 119778 | 119778 | 51920 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009316.82358159 | 2109402.74774996 | 37.772543755510895 | -122.41117313594499 | (37.7725437555109, -122.411173135945) | ||
| 120475 | 120475 | 108220 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 120632 | 120632 | 42737 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2155 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.712590845234296 | -122.400920338197 | (37.7125908452343, -122.400920338197) | ||
| 120751 | 120751 | 34077 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 120865 | 120865 | 49076 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1970 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | ||
| 121741 | 121741 | 99249 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 435 Paul Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2012 12:00:00 AM | 3x3 | Permit Number 769233 | 6012286.9 | 2091380.6 | 37.7232249352354 | -122.399633675727 | (37.7232249352354, -122.399633675727) | ||
| 122229 | 122229 | 123216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 654 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993193.61084 | 2111027.91211 | 37.7760886204879 | -122.46706267834298 | (37.7760886204879, -122.467062678343) | |||
| 122492 | 122492 | 44263 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.769656772496795 | -122.426413224583 | (37.7696567724968, -122.426413224583) | |||
| 123243 | 123243 | 34051 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 123498 | 123498 | 49162 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 804 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2003 12:00:00 AM | Permit Number 46282 | 5994926.32764665 | 2093370.69967083 | 37.7277062535492 | -122.45978949774499 | (37.7277062535492, -122.459789497745) | ||
| 123673 | 123673 | 65048 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 27001 | 6008641.92550277 | 2097033.56507471 | 37.7385429081789 | -122.41263312174401 | (37.7385429081789, -122.412633121744) | ||
| 124789 | 124789 | 88372 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 45 Sheridan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2005 12:00:00 AM | 2x3 | Permit Number 48123 | 6009306.0 | 2109414.0 | 37.77257404455771 | -122.411211370961 | (37.7725740445577, -122.411211370961) | ||
| 125170 | 125170 | 63543 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.43881084154499 | (37.7786186676026, -122.438810841545) | ||
| 126801 | 126801 | 34084 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 127065 | 127065 | 84127 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 88 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50980 | 6010360.09243836 | 2089687.02520781 | 37.7184671339256 | -122.406175049692 | (37.7184671339256, -122.406175049692) | ||
| 127307 | 127307 | 110182 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 339 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 776744 | 6006513.8 | 2097161.9 | 37.7387756178582 | -122.420000276005 | (37.7387756178582, -122.420000276005) | ||
| 127349 | 127349 | 42308 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 249 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | ||
| 128240 | 128240 | 215433 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993594.89235 | 2092910.6701200001 | 37.726366466724 | -122.464358867875 | (37.726366466724, -122.464358867875) | |||
| 128411 | 128411 | 52305 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 715 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | ||
| 128524 | 128524 | 117607 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.43521453981701 | (37.7622721434766, -122.435214539817) | |||
| 128783 | 128783 | 44007 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2701X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 3 on 17th St | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 129363 | 129363 | 108222 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 130161 | 130161 | 215412 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1407 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991770.8881 | 2105805.69837 | 37.7616676000029 | -122.471603571552 | (37.7616676000029, -122.471603571552) | |||
| 130541 | 130541 | 199802 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1350 Donner Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015069.8022 | 2090954.144 | 37.7222087062567 | -122.389983862743 | (37.7222087062567, -122.389983862743) | |||
| 131633 | 131633 | 241213 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.76415323799171 | -122.411942216073 | (37.7641532379917, -122.411942216073) | |||
| 132120 | 132120 | 241214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009008.65245 | 2106350.93983 | 37.764146911276704 | -122.41202342575899 | (37.7641469112767, -122.412023425759) | |||
| 135321 | 135321 | 215425 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993828.92178 | 2092931.25645 | 37.7264364789445 | -122.463551338741 | (37.7264364789445, -122.463551338741) | |||
| 136653 | 136653 | 215429 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993645.021930001 | 2093008.9273599999 | 37.726639146565 | -122.46419270373801 | (37.726639146565, -122.464192703738) | |||
| 136987 | 136987 | 51838 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 135 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | 8 | Permit Number 48065 | 6000803.77084 | 2087905.29553 | 37.713035738688504 | -122.43907959427 | (37.7130357386885, -122.43907959427) | ||
| 137872 | 137872 | 82840 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1379 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52465 | 6016423.5899 | 2093711.7525 | 37.729855545757 | -122.38549618052299 | (37.729855545757, -122.385496180523) | |
| 140788 | 140788 | 34085 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2851X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768574 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551068999 | (37.7627561815899, -122.41623551069) |
| 141062 | 141062 | 48927 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1362 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46117 | 6009515.72884218 | 2101239.2044667 | 37.7501396750607 | -122.40990871780501 | (37.7501396750607, -122.409908717805) | ||
| 141713 | 141713 | 82360 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 142033 | 142033 | 34048 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 375 Alabama St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571697999 | (37.7645360636147, -122.41223571698) | ||
| 142472 | 142472 | 108226 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 142933 | 142933 | 63531 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 645 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24143 | 6007924.14567941 | 2104175.72058203 | 37.7581133535123 | -122.41562041035299 | (37.7581133535123, -122.415620410353) | ||
| 143287 | 143287 | 44011 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 405X Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | Permit Number 43559. Tree 2 on Florida | 6009464.30573862 | 2106385.10315991 | 37.7642662704227 | -122.41044985886299 | (37.7642662704227, -122.410449858863) | ||
| 145082 | 145082 | 88286 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51287 | 6007754.0 | 2106536.0 | 37.7645845697556 | -122.416376026653 | (37.7645845697556, -122.416376026653) | ||
| 145218 | 145218 | 71944 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1342 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/1995 12:00:00 AM | 3x3 | Permit Number 50253 | 6008035.06455956 | 2100432.68279191 | 37.7478420534954 | -122.414971880187 | (37.7478420534954, -122.414971880187) | ||
| 145642 | 145642 | 108223 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 240 Shotwell St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007737.2 | 2106597.0 | 37.764751116814296 | -122.41643845462299 | (37.7647511168143, -122.416438454623) | ||||
| 145835 | 145835 | 80165 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 415-421 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2011 12:00:00 AM | 10 | 3x3 | Permit Number 768604 | 6007434.83105048 | 2107262.94030089 | 37.766562624561 | -122.417531473498 | (37.766562624561, -122.417531473498) |
| 145861 | 145861 | 38219 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 118 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2000 12:00:00 AM | Permit Number 40340 | 6000363.19569215 | 2109305.86913973 | 37.7717715527779 | -122.44213760158001 | (37.7717715527779, -122.44213760158) | ||
| 146236 | 146236 | 63542 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 2389 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | Permit Number 24157 | 6008220.818199201 | 2104530.13411616 | 37.7591031640479 | -122.414619465951 | (37.7591031640479, -122.414619465951) | ||
| 147184 | 147184 | 215439 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5998709.4181699995 | 2093777.72882 | 37.729040692553 | -122.44674062198 | (37.729040692553, -122.44674062198) | |||
| 149959 | 149959 | 197978 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1100 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6013947.00765 | 2106209.45605 | 37.764034263084504 | -122.394933045925 | (37.7640342630845, -122.394933045925) |
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");