Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671 | 671 | 225029 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.44035351451099 | (37.7605181908718, -122.440353514511) | |
| 2095 | 2095 | 58908 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 353 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.41188171506501 | (37.7721958858688, -122.411881715065) | |
| 2588 | 2588 | 56931 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.6979799997 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | ||
| 2631 | 2631 | 105340 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 12 | Permit Number 770950 | 6000144.5 | 2113810.0 | 37.784126280525605 | -122.44321763524201 | (37.7841262805256, -122.443217635242) | ||
| 2875 | 2875 | 53666 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) |
| 3591 | 3591 | 21679 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1809 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003858.3353 | 2114554.3239 | 37.7863810745889 | -122.430422226637 | (37.7863810745889, -122.430422226637) | |||
| 4449 | 4449 | 59787 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | ||
| 5973 | 5973 | 12978 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 300 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6010840.9455 | 2120711.3367 | 37.803679804278104 | -122.40669811093099 | (37.8036798042781, -122.406698110931) | |||
| 7170 | 7170 | 4704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.803115382163206 | -122.414077244448 | (37.8031153821632, -122.414077244448) | |||
| 8669 | 8669 | 21630 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150584996 | -122.427514608894 | (37.786749150585, -122.427514608894) | ||
| 9032 | 9032 | 173593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9033 | 9033 | 173592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9040 | 9040 | 173594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9043 | 9043 | 173595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9044 | 9044 | 55522 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | Permit Number 11483 | 6003594.27279224 | 2105459.16759406 | 37.7613930510814 | -122.430686551957 | (37.7613930510814, -122.430686551957) | |||
| 9046 | 9046 | 44757 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | ||||
| 9804 | 9804 | 59226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | ||
| 9915 | 9915 | 59271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | ||
| 10207 | 10207 | 58902 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 15 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1980 12:00:00 AM | Permit Number 18176 | 6005036.25199829 | 2101622.63318287 | 37.7509404143338 | -122.425426308198 | (37.7509404143338, -122.425426308198) | |||
| 10252 | 10252 | 173934 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||||
| 10260 | 10260 | 45427 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||
| 10266 | 10266 | 45428 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |||
| 10267 | 10267 | 45426 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||
| 17517 | 17517 | 653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.752208423697205 | -122.41776437753201 | (37.7522084236972, -122.417764377532) | |||
| 18363 | 18363 | 94569 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 19099 | 19099 | 34262 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3618 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 14 | 3x3 | Permit Number 38067 | 6002793.22003166 | 2106527.80070587 | 37.7642818435653 | -122.433533428216 | (37.7642818435653, -122.433533428216) | |
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 19751 | 19751 | 96542 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 22869 | 22869 | 13081 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | ||
| 49227 | 49227 | 15149 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 50078 | 50078 | 7238 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.43198684768801 | (37.7794031644909, -122.431986847688) | |||
| 51257 | 51257 | 15154 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 54782 | 54782 | 17106 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.771608801349394 | -122.448553894841 | (37.7716088013494, -122.448553894841) | |||
| 55718 | 55718 | 95037 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Dept of Real Estate 5 | 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 58674 | 58674 | 102786 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | ||
| 58723 | 58723 | 116509 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 66642 | 66642 | 4609 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | |
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 72212 | 72212 | 40354 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | ||
| 76014 | 76014 | 9687 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 16 | 3x3 | 6006025.521509999 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | ||
| 77331 | 77331 | 106090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 615 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012797.6 | 2118350.4 | 37.7973065196251 | -122.399761086072 | (37.7973065196251, -122.399761086072) | |||||
| 77456 | 77456 | 18007 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6001006.540695201 | 2114902.0443839002 | 37.7871738702805 | -122.44031363373699 | (37.7871738702805, -122.440313633737) | |||
| 77463 | 77463 | 21815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2653 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6008264.14138 | 2121978.44796 | 37.8070144637358 | -122.415705074993 | (37.8070144637358, -122.415705074993) | |||
| 77503 | 77503 | 23131 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.643569999 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | ||
| 77611 | 77611 | 102625 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1865X Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 17346 | 6010349.4 | 2120908.5 | 37.804193651889 | -122.408413053021 | (37.804193651889, -122.408413053021) | ||
| 77710 | 77710 | 6828 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 77761 | 77761 | 22671 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003752.72615 | 2112639.8215900003 | 37.7811183481869 | -122.43065094190099 | (37.7811183481869, -122.430650941901) | |||
| 77880 | 77880 | 93215 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 499 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715.0 | 2118034.0 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | |||
| 78160 | 78160 | 44063 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 78377 | 78377 | 48697 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 78404 | 78404 | 108604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.41502565223101 | (37.7869240847944, -122.415025652231) | |||
| 78415 | 78415 | 116510 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||||
| 78448 | 78448 | 102504 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 290X Hermann St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | ||||
| 78462 | 78462 | 108945 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
| 78686 | 78686 | 22716 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 78720 | 78720 | 102621 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 190X Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 18461 | 6009953.9 | 2121114.8 | 37.8047379445266 | -122.409796287705 | (37.8047379445266, -122.409796287705) | ||
| 78845 | 78845 | 49235 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 78930 | 78930 | 57108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.752087986316106 | -122.42645196024401 | (37.7520879863161, -122.426451960244) | |
| 79022 | 79022 | 61158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) |
| 79069 | 79069 | 44125 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.40233912369301 | (37.796490448112, -122.402339123693) | ||||
| 79174 | 79174 | 108979 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3298 PIERCE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6001385.1 | 2119659.6 | 37.800258423921 | -122.43934505130699 | (37.800258423921, -122.439345051307) | |||
| 79284 | 79284 | 97611 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 349 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009106.7 | 2109348.6 | 37.7723832922197 | -122.41189615048799 | (37.7723832922197, -122.411896150488) | ||||
| 79378 | 79378 | 20244 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | |||
| 79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
| 79385 | 79385 | 110987 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 79478 | 79478 | 22719 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 18 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | |||
| 79481 | 79481 | 49286 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 79589 | 79589 | 11091 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.41884176477899 | (37.7984523847496, -122.418841764779) | |||
| 79646 | 79646 | 117205 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | |||||
| 79776 | 79776 | 94218 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 3 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | ||
| 80196 | 80196 | 120531 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999052.33988667 | 2108383.59508746 | 37.7691644298026 | -122.446605553634 | (37.7691644298026, -122.446605553634) | ||||
| 80364 | 80364 | 573 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 776380 | 6009007.8652800005 | 2102243.7741799997 | 37.752869522851704 | -122.411735919997 | (37.7528695228517, -122.411735919997) | ||
| 80462 | 80462 | 13254 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | ||
| 80490 | 80490 | 11446 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005072.64937 | 2117089.8596099997 | 37.7934117301419 | -122.42640160486499 | (37.7934117301419, -122.426401604865) | |||
| 80579 | 80579 | 20167 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | |||
| 80976 | 80976 | 41195 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 81170 | 81170 | 60715 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | |
| 81572 | 81572 | 110995 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 81585 | 81585 | 52592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | ||||
| 81656 | 81656 | 15164 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 81682 | 81682 | 44064 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.43831930796699 | (37.7948463022786, -122.438319307967) | |||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 82173 | 82173 | 94931 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004522.0 | 2118744.0 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | |||||
| 82278 | 82278 | 11175 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | ||
| 82477 | 82477 | 20090 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.45345917871401 | (37.7709958615587, -122.453459178714) | |||
| 82490 | 82490 | 21634 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462004 | -122.42715183963301 | (37.786793502462, -122.427151839633) | |||
| 82491 | 82491 | 49240 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 Howard St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 82713 | 82713 | 61493 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3149 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1984 12:00:00 AM | Permit Number 777095 | 5999649.96958977 | 2116015.59113069 | 37.790154046975395 | -122.445087143888 | (37.7901540469754, -122.445087143888) | |||
| 82860 | 82860 | 106525 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 82872 | 82872 | 18497 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 501 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6010150.58942 | 2115513.37022 | 37.789368806644895 | -122.40872021032699 | (37.7893688066449, -122.408720210327) | |||
| 82998 | 82998 | 21584 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1499 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005574.52113 | 2114792.70084 | 37.787132663765995 | -122.424501615425 | (37.787132663766, -122.424501615425) | |||
| 83348 | 83348 | 15147 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 83408 | 83408 | 48709 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 405 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | Permit Number 45976 | 6014070.00775547 | 2115349.03612356 | 37.7891363266664 | -122.395147855931 | (37.7891363266664, -122.395147855931) | |||
| 83454 | 83454 | 112162 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1324 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | ||||
| 83524 | 83524 | 24454 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1384 Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6006362.58284 | 2101545.07315 | 37.750802300176396 | -122.42083421458901 | (37.7508023001764, -122.420834214589) | |||
| 83569 | 83569 | 11177 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2740 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | Permit Number 769071 | 6006912.197631501 | 2121679.9811893995 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) |
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");