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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45084 | 45084 | 69872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 3x3 | 5985114.18885 | 2110476.07325 | 37.774103764151896 | -122.49497044343599 | (37.7741037641519, -122.494970443436) | |
| 135911 | 135911 | 70116 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 14 | 6006256.51205 | 2117265.43085 | 37.793960654804295 | -122.422317826729 | (37.7939606548043, -122.422317826729) | ||
| 166283 | 166283 | 70678 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1237 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009493.1189 | 2110090.7425 | 37.7744427137413 | -122.410611903339 | (37.7744427137413, -122.410611903339) | ||
| 28986 | 28986 | 70938 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 12 | 6004494.5748 | 2111134.0934 | 37.777025989784 | -122.42797718611901 | (37.777025989784, -122.427977186119) | ||
| 178404 | 178404 | 71238 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 4 | 6001314.2765 | 2112604.1281 | 37.7808818966461 | -122.439084183551 | (37.7808818966461, -122.439084183551) | ||
| 33749 | 33749 | 71323 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 542 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 14 | 3x3 | 6003533.1657 | 2089339.03151 | 37.7171273913949 | -122.429748095618 | (37.7171273913949, -122.429748095618) | |
| 137465 | 137465 | 71445 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 60 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 14 | 6013056.352080001 | 2118942.99059 | 37.798948052957 | -122.398907344312 | (37.798948052957, -122.398907344312) | ||
| 30166 | 30166 | 71545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 3x3 | 6009927.7218 | 2119891.1918 | 37.8013767524977 | -122.40980045578002 | (37.8013767524977, -122.40980045578) | |
| 56486 | 56486 | 71546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 632 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6009897.0165 | 2119885.8819 | 37.8013604520305 | -122.409906335177 | (37.8013604520305, -122.409906335177) | ||
| 98879 | 98879 | 73079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/1999 12:00:00 AM | 5x5 | 6001526.55605734 | 2111478.46223961 | 37.77780317948721 | -122.438269140063 | (37.7778031794872, -122.438269140063) | |||
| 77936 | 77936 | 73302 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900x Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/1999 12:00:00 AM | 5x5 | 6001563.0 | 2111524.0 | 37.7779302874148 | -122.438146331007 | (37.7779302874148, -122.438146331007) | |||
| 177495 | 177495 | 73449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6004263.46084 | 2092033.9823200002 | 37.724568462935295 | -122.427415688595 | (37.7245684629353, -122.427415688595) | ||
| 177890 | 177890 | 73918 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 7 | 6004497.3871 | 2111109.5855 | 37.776958856214 | -122.42796571067 | (37.776958856214, -122.42796571067) | ||
| 123624 | 123624 | 74830 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 493 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 122305 | 122305 | 74968 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 493 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 6x6 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 32852 | 32852 | 76301 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015739.497330001 | 2112628.79912 | 37.781759872771104 | -122.389181562198 | (37.7817598727711, -122.389181562198) | ||
| 185221 | 185221 | 78048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 783 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985063.43296 | 2110545.25732 | 37.7742907524801 | -122.495151117096 | (37.7742907524801, -122.495151117096) | ||
| 104125 | 104125 | 78350 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 764 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 5 | 5985108.450019999 | 2110660.3816400003 | 37.7746094864044 | -122.49500388771901 | (37.7746094864044, -122.495003887719) | ||
| 186673 | 186673 | 78599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1721 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6012838.148159999 | 2104697.96448 | 37.7598223206635 | -122.39866221248501 | (37.7598223206635, -122.398662212485) | ||
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 129043 | 129043 | 79686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2002 12:00:00 AM | 17 | 3x3 | 6010880.07744846 | 2087416.54149132 | 37.7122619180075 | -122.404217955056 | (37.7122619180075, -122.404217955056) | ||
| 167517 | 167517 | 81822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 2 | 6014995.08745 | 2104204.61069 | 37.7585876135316 | -122.391167870527 | (37.7585876135316, -122.391167870527) | ||
| 67746 | 67746 | 83720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 10 | 6015466.99985 | 2104808.44883 | 37.7602718009179 | -122.389577941994 | (37.7602718009179, -122.389577941994) | ||
| 167677 | 167677 | 84556 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 5 | 5986323.51581 | 2110116.60697 | 37.7731874908554 | -122.49076077364201 | (37.7731874908554, -122.490760773642) | ||
| 79068 | 79068 | 92921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | tree 1 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 122422 | 122422 | 92922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 2 on 14th st. | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 84452 | 84452 | 92923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | tree 3 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 95838 | 95838 | 92924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725X 14th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | tree 4 on 14th st | 5992210.0 | 2097192.0 | 37.7380420035645 | -122.46945784276001 | (37.7380420035645, -122.46945784276) | ||
| 84463 | 84463 | 92925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 1 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 89271 | 89271 | 92926 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 398 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | tree 2 on 15th st | 5991862.0 | 2096794.0 | 37.7369290786614 | -122.470632059845 | (37.7369290786614, -122.470632059845) | |||
| 122362 | 122362 | 92927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 1 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 81647 | 81647 | 92928 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 301 West Portal Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | tree 2 on 14th st | 5992361.0 | 2097058.0 | 37.7376827987343 | -122.46892601674101 | (37.7376827987343, -122.468926016741) | |||
| 127493 | 127493 | 92943 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800X 15TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | tree 1 on 15th st | 5991935.0 | 2096694.0 | 37.7366587249535 | -122.470372388311 | (37.7366587249535, -122.470372388311) | |||
| 105001 | 105001 | 93172 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 208 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | Permit Number 775123 | 6005390.7 | 2102395.4 | 37.753082272967895 | -122.424255546161 | (37.7530822729679, -122.424255546161) | ||
| 141086 | 141086 | 93173 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 208 FAIR OAKS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x5 | 6005390.7 | 2102395.4 | 37.753082272967895 | -122.424255546161 | (37.7530822729679, -122.424255546161) | |||
| 95466 | 95466 | 93225 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 746 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4.5 | 5998618.6 | 2107971.8 | 37.768008959871395 | -122.44807617536001 | (37.7680089598714, -122.44807617536) | ||||
| 144945 | 144945 | 93226 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 746 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4.5 | 5998618.6 | 2107971.8 | 37.768008959871395 | -122.44807617536001 | (37.7680089598714, -122.44807617536) | ||||
| 87527 | 87527 | 93705 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 110 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007068.0 | 2098812.9 | 37.7433401045221 | -122.418201128904 | (37.7433401045221, -122.418201128904) | |||||
| 98821 | 98821 | 95208 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | |||
| 124527 | 124527 | 95209 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | ||||
| 79997 | 79997 | 95210 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | |||
| 101163 | 101163 | 95211 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | |||
| 112351 | 112351 | 95212 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | ||||
| 123212 | 123212 | 95213 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | |||
| 99214 | 99214 | 95214 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2203@Clay Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000868.0 | 2115894.0 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | |||
| 101997 | 101997 | 95243 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 10 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 125091 | 125091 | 95244 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2626 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 10 | 3x3 | Permit Number 767140 | 6006627.0 | 2120193.0 | 37.802019913523004 | -122.421243885087 | (37.802019913523, -122.421243885087) | |
| 8876 | 8876 | 95278 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 638 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Created record for tree on 2/4/2011. Matches others in row planted around same time in 1979. | 6004779.960630001 | 2110916.39736 | 37.7764443911196 | -122.426974438925 | (37.7764443911196, -122.426974438925) | ||
| 93279 | 93279 | 95357 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 539 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011224.0 | 2118588.2 | 37.7978716130027 | -122.405222926232 | (37.7978716130027, -122.405222926232) | ||||
| 178763 | 178763 | 96404 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2007 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5998078.8835 | 2110624.4028 | 37.7752614597767 | -122.45013420456199 | (37.7752614597767, -122.450134204562) | |||
| 71180 | 71180 | 96405 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2007 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5998103.0801 | 2110627.8595 | 37.775272335586 | -122.45005075258301 | (37.775272335586, -122.450050752583) | |||
| 125947 | 125947 | 96406 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2003 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998190.0 | 2110653.0 | 37.7753463382451 | -122.44975189025699 | (37.7753463382451, -122.449751890257) | ||||
| 14616 | 14616 | 97148 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.41317118461399 | (37.7654035712889, -122.413171184614) | |||
| 15511 | 15511 | 97152 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2601X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6008686.3 | 2106815.2 | 37.7654035712889 | -122.41317118461399 | (37.7654035712889, -122.413171184614) | |||
| 91960 | 91960 | 97153 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6008651.4 | 2106441.1 | 37.764374419739 | -122.413265439119 | (37.764374419739, -122.413265439119) | |||
| 50301 | 50301 | 98228 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003348.57163 | 2117591.48669 | 37.79469146009821 | -122.43240288080901 | (37.7946914600982, -122.432402880809) | |||
| 46905 | 46905 | 98229 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003313.38814 | 2117587.4336099997 | 37.79467833628 | -122.43252433064501 | (37.79467833628, -122.432524330645) | |||
| 64539 | 64539 | 98230 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003291.72327 | 2117584.29621 | 37.7946684932036 | -122.432599069701 | (37.7946684932036, -122.432599069701) | |||
| 26355 | 26355 | 98231 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003266.423169999 | 2117579.44132 | 37.794653728133 | -122.43268626435699 | (37.794653728133, -122.432686264357) | |||
| 171632 | 171632 | 98232 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | Permit Number 778130 | 6003238.99921 | 2117573.43548 | 37.7946356823309 | -122.432780725547 | (37.7946356823309, -122.432780725547) | ||
| 99085 | 99085 | 98315 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3051X 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007907.5 | 2103834.6 | 37.7571757787878 | -122.415653826094 | (37.7571757787878, -122.415653826094) | ||||
| 5398 | 5398 | 98494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999556.928169999 | 2118555.98315 | 37.79712398054429 | -122.44559181541099 | (37.7971239805443, -122.445591815411) | |||
| 55406 | 55406 | 98495 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999554.47811 | 2118573.67214 | 37.797172409922794 | -122.44560156586999 | (37.7971724099228, -122.44560156587) | |||
| 146317 | 146317 | 98496 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X Miley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000842.0 | 2108958.0 | 37.7708436665375 | -122.44045643653999 | (37.7708436665375, -122.44045643654) | ||||
| 127955 | 127955 | 98497 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X Miley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000842.0 | 2108958.0 | 37.7708436665375 | -122.44045643653999 | (37.7708436665375, -122.44045643654) | ||||
| 106858 | 106858 | 98498 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X Miley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000842.0 | 2108958.0 | 37.7708436665375 | -122.44045643653999 | (37.7708436665375, -122.44045643654) | ||||
| 98009 | 98009 | 98499 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1X Miley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000842.0 | 2108958.0 | 37.7708436665375 | -122.44045643653999 | (37.7708436665375, -122.44045643654) | ||||
| 2108 | 2108 | 98580 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 370 Drumm St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2017 12:00:00 AM | 3 | 3x3 | 6013585.68076 | 2118314.1263900003 | 37.7972508218322 | -122.397031561762 | (37.7972508218322, -122.397031561762) | ||
| 124840 | 124840 | 98661 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 168- 170 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x6 | 6005208.0 | 2104014.0 | 37.7575162528801 | -122.42500251215401 | (37.7575162528801, -122.425002512154) | |||
| 110798 | 110798 | 98904 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 210 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x8 | 6006080.0 | 2101897.0 | 37.7517526786901 | -122.421836408351 | (37.7517526786901, -122.421836408351) | ||||
| 5857 | 5857 | 99700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1412 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6007375.87378 | 2117463.43004 | 37.794567388720296 | -122.41845876116301 | (37.7945673887203, -122.418458761163) | |||
| 152507 | 152507 | 100038 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005164.06417 | 2116434.37592 | 37.791617104282395 | -122.42603861878901 | (37.7916171042824, -122.426038618789) | ||||
| 31501 | 31501 | 100039 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005166.77799 | 2116408.4512099996 | 37.7915460749308 | -122.426027382675 | (37.7915460749308, -122.426027382675) | ||||
| 136595 | 136595 | 100040 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005169.80466 | 2116390.62846 | 37.7914973092018 | -122.426015641131 | (37.7914973092018, -122.426015641131) | ||||
| 53442 | 53442 | 100041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005173.38835 | 2116375.3440799997 | 37.791455544677206 | -122.426002153097 | (37.7914555446772, -122.426002153097) | ||||
| 44591 | 44591 | 100042 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005174.91003 | 2116356.5458 | 37.79140401532911 | -122.42599554934799 | (37.7914040153291, -122.425995549348) | ||||
| 37666 | 37666 | 100125 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6005967.88782 | 2116944.18436 | 37.793062307639204 | -122.423293649581 | (37.7930623076392, -122.423293649581) | ||||
| 35544 | 35544 | 100126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | ||||
| 47709 | 47709 | 100127 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6005919.013280001 | 2116937.33835 | 37.793040751777895 | -122.423462271584 | (37.7930407517779, -122.423462271584) | ||||
| 33270 | 33270 | 100128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.42353712664499 | (37.7930298924771, -122.423537126645) | ||||
| 127969 | 127969 | 100199 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095813.0 | 37.7345948616995 | -122.44895594133499 | (37.7345948616995, -122.448955941335) | |||||
| 90564 | 90564 | 100200 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5998111.0 | 2095844.0 | 37.734679980307604 | -122.448958173673 | (37.7346799803076, -122.448958173673) | |||||
| 94961 | 94961 | 100226 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1192 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000853.0 | 2109323.0 | 37.7718464914602 | -122.440444569342 | (37.7718464914602, -122.440444569342) | ||||
| 114674 | 114674 | 100484 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1817X Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008768.3 | 2108132.4 | 37.7690249002263 | -122.41298070519899 | (37.7690249002263, -122.412980705199) | |||
| 119671 | 119671 | 100485 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1817X Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008768.3 | 2108132.4 | 37.7690249002263 | -122.41298070519899 | (37.7690249002263, -122.412980705199) | |||
| 121614 | 121614 | 100486 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1717X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008671.0 | 2108256.0 | 37.76935881467679 | -122.413326002916 | (37.7693588146768, -122.413326002916) | |||
| 105559 | 105559 | 100487 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1717X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008671.0 | 2108256.0 | 37.76935881467679 | -122.413326002916 | (37.7693588146768, -122.413326002916) | |||
| 115675 | 115675 | 100489 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3855 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5995841.0 | 2114493.0 | 37.7857552845664 | -122.45815555350201 | (37.7857552845664, -122.458155553502) | |||
| 101369 | 101369 | 100719 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 124260 | 124260 | 100722 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 102554 | 102554 | 100723 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 94024 | 94024 | 100724 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 105362 | 105362 | 100725 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 102707 | 102707 | 100726 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 111243 | 111243 | 100727 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 96554 | 96554 | 100728 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 142552 | 142552 | 100729 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 88709 | 88709 | 100730 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 93995 | 93995 | 100731 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) | |||
| 90468 | 90468 | 100732 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1445X Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009133.0 | 2108884.6 | 37.7711107319532 | -122.41177238365101 | (37.7711107319532, -122.411772383651) |
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");