Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186805 | 186805 | 34852 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.6555699995 | 2104887.53933 | 37.760413499914996 | -122.394284848775 | (37.760413499915, -122.394284848775) | ||
175422 | 175422 | 113957 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1644 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 1 | 3x3 | 6008801.14182 | 2118530.39041 | 37.7975771309301 | -122.413602635263 | (37.7975771309301, -122.413602635263) | ||
11199 | 11199 | 79973 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.8612400002 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | |
98723 | 98723 | 71559 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 919 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772718 | 6007599.61852401 | 2104303.467284 | 37.758445868977 | -122.416751817847 | (37.758445868977, -122.416751817847) |
101512 | 101512 | 66924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.41641579438298 | (37.7413986874365, -122.416415794383) | ||
100127 | 100127 | 66898 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | ||
100296 | 100296 | 66897 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | ||
49472 | 49472 | 41212 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3676 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 6 | Permit Number 41921 | 6002149.73701 | 2121055.69726 | 37.804135222937 | -122.43679910691002 | (37.804135222937, -122.43679910691) | |
116956 | 116956 | 45807 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1993 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2001 12:00:00 AM | Permit Number 44435 | 5991886.15341897 | 2101900.86240585 | 37.7509526116716 | -122.47092045652599 | (37.7509526116716, -122.470920456526) | |||
86465 | 86465 | 65417 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 887 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1989 12:00:00 AM | Permit Number 28274 | 6009256.60978604 | 2115652.27846796 | 37.7897001035195 | -122.41182310868601 | (37.7897001035195, -122.411823108686) | ||
174841 | 174841 | 114540 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 804 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774890 | 6012104.4450199995 | 2104594.7801900003 | 37.7594980943773 | -122.40119249645299 | (37.7594980943773, -122.401192496453) | |
24159 | 24159 | 33290 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37451 | 6009219.4283 | 2116994.47406 | 37.7933833601996 | -122.41204664625499 | (37.7933833601996, -122.412046646255) | |
25528 | 25528 | 33293 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | |
89745 | 89745 | 33370 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
91561 | 91561 | 33364 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
107258 | 107258 | 33366 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
108145 | 108145 | 33367 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37498 | 5993623.03189123 | 2093524.69495183 | 37.728054050760896 | -122.464306151281 | (37.7280540507609, -122.464306151281) | ||
108997 | 108997 | 33369 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
112518 | 112518 | 33292 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 160 Sproule Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | ||
114430 | 114430 | 33294 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 158 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37451 | 6009246.88754349 | 2116916.88448981 | 37.7931718587847 | -122.411946149383 | (37.7931718587847, -122.411946149383) | ||
118540 | 118540 | 33368 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37499 | 5993674.94282707 | 2093510.9416498002 | 37.7280192795988 | -122.464125696941 | (37.7280192795988, -122.464125696941) | ||
145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
175782 | 175782 | 33291 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37451 | 6009219.70147 | 2117007.84258 | 37.7934200822178 | -122.412046646261 | (37.7934200822178, -122.412046646261) | |
124918 | 124918 | 50533 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | |||
156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
99946 | 99946 | 38942 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 157 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1998 12:00:00 AM | Permit Number 40741 | 5991578.31713669 | 2092588.28918632 | 37.72536484280229 | -122.471306529261 | (37.7253648428023, -122.471306529261) | ||
82717 | 82717 | 65437 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.782988272364705 | -122.41196892508499 | (37.7829882723647, -122.411968925085) | ||
104293 | 104293 | 38940 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 153 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40740 | 5991575.72353287 | 2092547.36275219 | 37.7252523189339 | -122.47131251444401 | (37.7252523189339, -122.471312514444) | ||
111438 | 111438 | 38936 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
113313 | 113313 | 38937 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 144 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40738 | 5991631.60246352 | 2092606.92529954 | 37.725419095146606 | -122.471123685701 | (37.7254190951466, -122.471123685701) | ||
185094 | 185094 | 52182 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.3864700003 | 37.777907863296704 | -122.410641078729 | (37.7779078632967, -122.410641078729) | |
90795 | 90795 | 32709 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
92432 | 92432 | 32708 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
143853 | 143853 | 32707 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
159116 | 159116 | 32706 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | |
106188 | 106188 | 91501 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 52121 | 6009912.0 | 2113772.0 | 37.784574054907104 | -122.40942276104201 | (37.7845740549071, -122.409422761042) | ||
176841 | 176841 | 91499 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009892.98607 | 2113874.19242 | 37.7848535855735 | -122.409495757934 | (37.7848535855735, -122.409495757934) | |
119063 | 119063 | 86884 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2534 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.73922299278121 | -122.504282496051 | (37.7392229927812, -122.504282496051) | |||
87495 | 87495 | 51467 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) | ||
90780 | 90780 | 51468 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) |
128812 | 128812 | 51459 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
138603 | 138603 | 51460 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
121657 | 121657 | 92783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 527 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52999 | 6013573.0 | 2112256.0 | 37.780615911778604 | -122.396650538079 | (37.7806159117786, -122.396650538079) | ||
72861 | 72861 | 32513 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.6295900003 | 37.735251041008794 | -122.416089643829 | (37.7352510410088, -122.416089643829) | |
43148 | 43148 | 32487 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 257 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36994 | 6000562.081590001 | 2106647.6707099997 | 37.7644841354656 | -122.441258885382 | (37.7644841354656, -122.441258885382) | |
24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
153001 | 153001 | 92753 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.7877700003 | 37.802166375831106 | -122.446615526285 | (37.8021663758311, -122.446615526285) | |
76690 | 76690 | 35734 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 202 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 6 | Permit Number 47062 | 6010246.45985 | 2093710.9780400002 | 37.7295097141809 | -122.40685127987899 | (37.7295097141809, -122.406851279879) | |
97412 | 97412 | 50391 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.732830315621705 | -122.455320609685 | (37.7328303156217, -122.455320609685) | ||
149030 | 149030 | 79776 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.0863799998 | 37.75191893911521 | -122.401951552136 | (37.7519189391152, -122.401951552136) | |
34959 | 34959 | 104356 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | ||
45092 | 45092 | 64967 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.799065794014396 | -122.42697920982201 | (37.7990657940144, -122.426979209822) | |
184444 | 184444 | 66783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30054 | 6005979.755609999 | 2120327.60903 | 37.80235300495529 | -122.42349323614799 | (37.8023530049553, -122.423493236148) | |
105698 | 105698 | 59475 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30019 | 6005649.89083993 | 2108784.60921416 | 37.7706401673343 | -122.42381348318399 | (37.7706401673343, -122.423813483184) | ||
104453 | 104453 | 64654 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1315 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1988 12:00:00 AM | Permit Number 25578 | 6006760.497484599 | 2115419.54547338 | 37.788920727800395 | -122.42044289969499 | (37.7889207278004, -122.420442899695) | ||
89015 | 89015 | 66177 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.739604892580296 | -122.41021864302 | (37.7396048925803, -122.41021864302) | ||
91999 | 91999 | 66176 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.739507066017794 | -122.41022760736601 | (37.7395070660178, -122.410227607366) | ||
7189 | 7189 | 111999 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.791259999 | 2117077.11494 | 37.793269498846705 | -122.432953577047 | (37.7932694988467, -122.432953577047) | |
102011 | 102011 | 38318 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1810 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767577 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.41346579017299 | (37.7684292621485, -122.413465790173) | |
107024 | 107024 | 95783 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767527 | 6009054.0 | 2104485.0 | 37.7590260110101 | -122.411734726588 | (37.7590260110101, -122.411734726588) | |
82144 | 82144 | 40782 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | ||
79612 | 79612 | 32135 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
80090 | 80090 | 32128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Ross Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35490 | 6010568.1937078 | 2117713.19841403 | 37.7954323857446 | -122.407430491589 | (37.7954323857446, -122.407430491589) | ||
92319 | 92319 | 32141 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
92731 | 92731 | 32134 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
96760 | 96760 | 32142 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 163X Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35497 | 6006158.88889094 | 2110709.34290145 | 37.775953744351895 | -122.422189614353 | (37.7759537443519, -122.422189614353) | ||
104718 | 104718 | 32136 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 858 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35495 | 6010580.68586277 | 2117592.53204935 | 37.7951017643418 | -122.40737875552 | (37.7951017643418, -122.40737875552) | ||
138919 | 138919 | 32133 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35494 | 6010631.11006318 | 2117599.53652258 | 37.795123819025704 | -122.407204773258 | (37.7951238190257, -122.407204773258) | ||
143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
78317 | 78317 | 96059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
101834 | 101834 | 96061 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
143899 | 143899 | 96060 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
28260 | 28260 | 92446 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) |
65850 | 65850 | 92445 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
65098 | 65098 | 92415 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 0 | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) |
84013 | 84013 | 92416 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.49627557459499 | (37.758761083263, -122.496275574595) | |
111926 | 111926 | 92417 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1579 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52809 | 5984633.3 | 2104450.5 | 37.757531078434205 | -122.496189239645 | (37.7575310784342, -122.496189239645) | |
20258 | 20258 | 50073 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.739019597898505 | -122.472099259809 | (37.7390195978985, -122.472099259809) | ||
82919 | 82919 | 50074 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | ||
88563 | 88563 | 50078 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.47222815003599 | (37.7382952135341, -122.472228150036) | ||
105572 | 105572 | 50076 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.738366851245104 | -122.472233215714 | (37.7383668512451, -122.472233215714) | ||
183063 | 183063 | 34667 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3065 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38339 | 6003364.40129 | 2118901.0104900002 | 37.798287972172396 | -122.43244168475799 | (37.7982879721724, -122.432441684758) | ||
128844 | 128844 | 34278 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.784622151593794 | -122.48837227738501 | (37.7846221515938, -122.488372277385) | ||
77169 | 77169 | 34187 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
91942 | 91942 | 34190 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
112894 | 112894 | 34186 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
122433 | 122433 | 34188 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
127638 | 127638 | 34191 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.785129669395104 | -122.488322923297 | (37.7851296693951, -122.488322923297) | ||
140459 | 140459 | 95587 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 821 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767377 | 6012153.0 | 2112651.0 | 37.781621357712396 | -122.401590796207 | (37.7816213577124, -122.401590796207) | |
144315 | 144315 | 88208 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 607 Central Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619.0 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | |||
94647 | 94647 | 88118 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 956 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51122 | 5999752.6 | 2102008.2 | 37.7516991466356 | -122.44372532203501 | (37.7516991466356, -122.443725322035) | ||
186976 | 186976 | 62043 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 453 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 3 | Permit Number 31992 | 6014123.240119999 | 2112760.57959 | 37.782031980627295 | -122.394782327659 | (37.7820319806273, -122.394782327659) | ||
86242 | 86242 | 42581 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.732242319303104 | -122.47039977177499 | (37.7322423193031, -122.470399771775) | ||
95859 | 95859 | 42786 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 269 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.774128482391205 | -122.425255647592 | (37.7741284823912, -122.425255647592) | ||
117999 | 117999 | 42785 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 269 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42753 | 6005259.26650222 | 2110063.08095744 | 37.774128482391205 | -122.425255647592 | (37.7741284823912, -122.425255647592) | ||
142286 | 142286 | 38961 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.743262151009496 | -122.406749540855 | (37.7432621510095, -122.406749540855) | ||
145266 | 145266 | 39223 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.537280001 | 2109997.98133 | 37.77262806827861 | -122.50454323337 | (37.7726280682786, -122.50454323337) | |
46755 | 46755 | 37601 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 781 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | 6x9 | Permit Number 40028 | 5992556.63358 | 2110168.87379 | 37.7736931455181 | -122.469203595419 | (37.7736931455181, -122.469203595419) |
121499 | 121499 | 37576 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 124 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40009 | 5999906.30838792 | 2105075.4680497 | 37.7601298795068 | -122.44341407918002 | (37.7601298795068, -122.44341407918) | ||
152994 | 152994 | 37651 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.8860400002 | 37.776550828957504 | -122.477359640658 | (37.7765508289575, -122.477359640658) |
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");