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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161917 | 161917 | 70270 | Undocumented 2 | Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree 310 | 2415 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 5 | 6010559.28537 | 2105499.02041 | 37.7618946113552 | -122.40660017027399 | (37.7618946113552, -122.406600170274) | ||
| 177938 | 177938 | 70277 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 481 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2012 12:00:00 AM | 2 | Permit Number 768624 | 5985297.751569999 | 2112660.9809 | 37.78011363845471 | -122.49449657583901 | (37.7801136384547, -122.494496575839) | |
| 72057 | 72057 | 70279 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Arago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1994 12:00:00 AM | 4 | 5999591.10411 | 2092976.06015 | 37.726889823596295 | -122.443635008456 | (37.7268898235963, -122.443635008456) | ||
| 179332 | 179332 | 70285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2635 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1994 12:00:00 AM | 7 | 6009920.8777 | 2105467.2004400003 | 37.7617715031625 | -122.40880593563801 | (37.7617715031625, -122.408805935638) | ||
| 12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
| 149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
| 147336 | 147336 | 70301 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2240 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5987950.7299 | 2100020.9476 | 37.7455624781653 | -122.48439149772699 | (37.7455624781653, -122.484391497727) | ||
| 72654 | 72654 | 70313 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 215-217 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 11 | 5997813.3422 | 2109805.1078 | 37.7729966883074 | -122.450993675957 | (37.7729966883074, -122.450993675957) | ||
| 39830 | 39830 | 70315 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 226 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 5 | 5997860.8667 | 2109778.6627 | 37.7729267975155 | -122.450827376517 | (37.7729267975155, -122.450827376517) | ||
| 25755 | 25755 | 70316 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1574 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5984074.4364 | 2104459.8766 | 37.7575240722826 | -122.49812267764 | (37.7575240722826, -122.49812267764) | ||
| 25531 | 25531 | 70321 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 148 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 11 | 7x6 | 5997828.6446 | 2110019.5409 | 37.7735863423596 | -122.45095620867501 | (37.7735863423596, -122.450956208675) | |
| 184521 | 184521 | 70322 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 212 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 4 | 5997855.1178 | 2109822.7379 | 37.7730474875653 | -122.45085044116999 | (37.7730474875653, -122.45085044117) | ||
| 167768 | 167768 | 70329 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 791 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 2 | 5988807.230690001 | 2109962.8525900003 | 37.7729101002624 | -122.482158112101 | (37.7729101002624, -122.482158112101) | ||
| 134165 | 134165 | 70332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 765 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 7 | 5982891.42605 | 2110581.736 | 37.7742635126433 | -122.502667063271 | (37.7742635126433, -122.502667063271) | ||
| 177436 | 177436 | 70333 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 143 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 7 | 6009984.51803 | 2093871.67123 | 37.7299362833339 | -122.407768169286 | (37.7299362833339, -122.407768169286) | ||
| 174655 | 174655 | 70334 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 241 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 5 | 6010007.802080001 | 2094072.89599 | 37.7304901074191 | -122.40770185597601 | (37.7304901074191, -122.407701855976) | ||
| 37494 | 37494 | 70335 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 6 | 6009780.67381 | 2094049.10859 | 37.7304120750579 | -122.408485397509 | (37.7304120750579, -122.408485397509) | ||
| 38853 | 38853 | 70336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | ||
| 61707 | 61707 | 70340 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 31 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 9 | 6009840.88523 | 2094336.4201900002 | 37.731204343587606 | -122.408297494042 | (37.7312043435876, -122.408297494042) | ||
| 163596 | 163596 | 70351 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 427 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | 6003975.14457 | 2089961.04418 | 37.7188603202322 | -122.42826469088499 | (37.7188603202322, -122.428264690885) | ||
| 624 | 624 | 70356 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1912 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 5 | 6006535.5562 | 2117410.9094 | 37.7943758388735 | -122.42136264060801 | (37.7943758388735, -122.421362640608) | ||
| 31704 | 31704 | 70357 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3827 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982346.2639999995 | 2104189.8384 | 37.7566811453358 | -122.50407929098 | (37.7566811453358, -122.50407929098) | ||
| 60075 | 60075 | 70358 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3833 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982319.9846 | 2104190.4495 | 37.7566812777905 | -122.504170218425 | (37.7566812777905, -122.504170218425) | ||
| 152944 | 152944 | 70360 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3826 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982955.4526 | 2104949.3397 | 37.7588023275687 | -122.502028728145 | (37.7588023275687, -122.502028728145) | ||
| 37548 | 37548 | 70361 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3933 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982619.7769 | 2104883.3949 | 37.75860153616 | -122.503184748041 | (37.75860153616, -122.503184748041) | ||
| 42861 | 42861 | 70362 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | ||
| 46713 | 46713 | 70364 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5982287.6338 | 2104871.478 | 37.758549286455604 | -122.504332547004 | (37.7585492864556, -122.504332547004) | ||
| 56897 | 56897 | 70367 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1406 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983105.9662 | 2105534.9379 | 37.7604190558161 | -122.50155151240601 | (37.7604190558161, -122.501551512406) | ||
| 159867 | 159867 | 70368 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.50150735953899 | (37.7598111971708, -122.501507359539) | ||
| 157423 | 157423 | 70369 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1454 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5983117.2046 | 2105238.7271 | 37.759606404775504 | -122.50149073173 | (37.7596064047755, -122.50149073173) | ||
| 26122 | 26122 | 70370 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.50148010954901 | (37.7594698688276, -122.501480109549) | ||
| 30576 | 30576 | 70371 | Undocumented 2 | Tree(s) :: 17 | 1470 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2015 12:00:00 AM | 7 | Permit Number 776609 | 5983120.8169 | 2105139.9902 | 37.759335513294396 | -122.50147093465598 | (37.7593355132944, -122.501470934656) | |
| 48932 | 48932 | 70374 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | ||
| 35629 | 35629 | 70375 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | ||
| 25852 | 25852 | 70376 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) | ||
| 168113 | 168113 | 70380 | Undocumented 2 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | ||
| 62316 | 62316 | 70381 | Undocumented 2 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.50471186838499 | (37.7594237635385, -122.504711868385) | ||
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 186785 | 186785 | 70386 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | ||
| 142202 | 142202 | 70387 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 4 | 6003118.96111 | 2094567.6101799998 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | ||
| 45678 | 45678 | 70389 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.47967027105899 | (37.7747342353889, -122.479670271059) | ||
| 75893 | 75893 | 70393 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 6 | 6005472.78201 | 2093254.0606099998 | 37.7279868534853 | -122.42332190988998 | (37.7279868534853, -122.42332190989) | ||
| 39708 | 39708 | 70395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 16 | 6005551.028469999 | 2092833.80452 | 37.72683733826221 | -122.423021551618 | (37.7268373382622, -122.423021551618) | ||
| 59437 | 59437 | 70396 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 7 | 6005777.21829 | 2092245.9631400001 | 37.72523601532679 | -122.422197872442 | (37.7252360153268, -122.422197872442) | ||
| 75371 | 75371 | 70397 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 21 | 6006350.25387 | 2093285.0007900002 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | ||
| 12974 | 12974 | 70398 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 153 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 15 | 3x3 | Permit Number 775403 | 6006428.67416 | 2093189.7216599998 | 37.7278640951339 | -122.420012793267 | (37.7278640951339, -122.420012793267) |
| 156206 | 156206 | 70399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 177 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 9 | 6006457.49491 | 2093097.9918799999 | 37.7276138488775 | -122.419906652577 | (37.7276138488775, -122.419906652577) | ||
| 26966 | 26966 | 70402 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 212 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006462.64225 | 2092921.27798 | 37.727128920939606 | -122.419876323835 | (37.7271289209396, -122.419876323835) | ||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 162109 | 162109 | 70404 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 218 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 6006477.26442 | 2092881.04144 | 37.7270192639056 | -122.41982292118601 | (37.7270192639056, -122.419822921186) | ||
| 181702 | 181702 | 70405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006525.54367 | 2092869.6574799998 | 37.726990725739 | -122.41965521291999 | (37.726990725739, -122.41965521292) | ||
| 128113 | 128113 | 70406 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 230 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 6006490.110780001 | 2092833.88988 | 37.726890519664394 | -122.419775167193 | (37.7268905196644, -122.419775167193) | ||
| 45366 | 45366 | 70407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | ||
| 155267 | 155267 | 70408 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 3 | 6006531.16259 | 2092699.03842 | 37.7265225593592 | -122.419623688079 | (37.7265225593592, -122.419623688079) | ||
| 73065 | 73065 | 70411 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1809 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 7 | 6005512.8628 | 2092696.08683 | 37.7264570419356 | -122.423143704729 | (37.7264570419356, -122.423143704729) | ||
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 154108 | 154108 | 70417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Yale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6007053.10759 | 2093048.1738200001 | 37.7275105968359 | -122.417844078137 | (37.7275105968359, -122.417844078137) | ||
| 163015 | 163015 | 70423 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 147 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 7 | 6009992.12769 | 2093847.85875 | 37.7298713252965 | -122.407740183271 | (37.7298713252965, -122.407740183271) | ||
| 26003 | 26003 | 70424 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 8 | 5982456.3495 | 2105108.4827 | 37.759209955641104 | -122.50376661440501 | (37.7592099556411, -122.503766614405) | ||
| 167536 | 167536 | 70426 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1590 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 12 | 3x3 | 6006596.62742 | 2117360.41575 | 37.79424063894329 | -122.42114773946999 | (37.7942406389433, -122.42114773947) | |
| 85446 | 85446 | 70434 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.50361073719101 | (37.772435937677, -122.503610737191) | |
| 58302 | 58302 | 70437 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 8 | 5983020.7059 | 2098971.1879 | 37.742391820222295 | -122.50136084638201 | (37.7423918202223, -122.501360846382) | ||
| 12715 | 12715 | 70439 | Undocumented 2 | Tree(s) :: 17 | 2426 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773392 | 5983041.4986 | 2098597.8907 | 37.7413680695353 | -122.501261346997 | (37.7413680695353, -122.501261346997) |
| 60980 | 60980 | 70441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2443 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 2 | 5982992.9824 | 2098498.3633 | 37.741091945342795 | -122.501421735716 | (37.7410919453428, -122.501421735716) | ||
| 4832 | 4832 | 70442 | Undocumented 2 | Tree(s) :: 17 | 2470 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | |
| 173093 | 173093 | 70444 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3933 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 3 | 5982611.2212 | 2104882.7837 | 37.758599355061996 | -122.503214291779 | (37.758599355062, -122.503214291779) | ||
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 45057 | 45057 | 70451 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | ||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 156977 | 156977 | 70456 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 608 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 4 | 5988812.35938 | 2111170.03259 | 37.7762249796176 | -122.482228831071 | (37.7762249796176, -122.482228831071) | ||
| 30206 | 30206 | 70458 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | ||
| 163564 | 163564 | 70459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 73 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 12 | 6004663.961569999 | 2093087.11793 | 37.727482784398 | -122.426106147103 | (37.727482784398, -122.426106147103) | ||
| 179972 | 179972 | 70461 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1130 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 17 | 6007328.122269999 | 2115219.69478 | 37.7884039579183 | -122.418464813605 | (37.7884039579183, -122.418464813605) | ||
| 86816 | 86816 | 70466 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 600x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1994 12:00:00 AM | 12 | 3x10 | 6008626.0 | 2096922.0 | 37.738235681004795 | -122.412680299873 | (37.7382356810048, -122.412680299873) | ||
| 126306 | 126306 | 70470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 126186 | 126186 | 70471 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450X Banks St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 32 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 98194 | 98194 | 70472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 134434 | 134434 | 70478 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 64 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 10 | 6005133.6380900005 | 2092919.2307799999 | 37.7270483380922 | -122.42447053479799 | (37.7270483380922, -122.424470534798) | ||
| 26540 | 26540 | 70481 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 934 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6005107.91916 | 2092023.60961 | 37.7245877066523 | -122.424495766183 | (37.7245877066523, -122.424495766183) | ||
| 117662 | 117662 | 70482 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 935 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6005101.627719999 | 2092066.92628 | 37.724706289440796 | -122.424520594648 | (37.7247062894408, -122.424520594648) | ||
| 174937 | 174937 | 70483 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 939 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 6 | 6005126.746780001 | 2092081.9849599998 | 37.7247490558006 | -122.42443483169701 | (37.7247490558006, -122.424434831697) | ||
| 35355 | 35355 | 70484 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 947 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6005167.83048 | 2092104.0549400002 | 37.724811975074104 | -122.424294379186 | (37.7248119750741, -122.424294379186) | ||
| 72972 | 72972 | 70491 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 18 | 6005035.0472800005 | 2091735.87999 | 37.723793548611496 | -122.424727215697 | (37.7237935486115, -122.424727215697) | ||
| 183181 | 183181 | 70492 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 46 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 3 | 6004963.53914 | 2091629.1243599998 | 37.7234963820321 | -122.42496681578501 | (37.7234963820321, -122.424966815785) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 187464 | 187464 | 70495 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 8 | 6004160.9944400005 | 2093317.3094099998 | 37.728086398555206 | -122.427861302663 | (37.7280863985552, -122.427861302663) | ||
| 172644 | 172644 | 70497 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 182 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 13 | 6003784.020880001 | 2092788.04528 | 37.726611824260104 | -122.42912679089301 | (37.7266118242601, -122.429126790893) | ||
| 185087 | 185087 | 70501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 75 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 9 | 6004654.404130001 | 2093072.1677599999 | 37.72744119435129 | -122.42613812337 | (37.7274411943513, -122.42613812337) | ||
| 69142 | 69142 | 70502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 78 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 11 | 6x7 | 6004601.41978 | 2093074.4867 | 37.727444566791 | -122.42632145556401 | (37.727444566791, -122.426321455564) | |
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 177146 | 177146 | 70504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 437 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 18 | 6004727.68791 | 2092850.7822900002 | 37.7268374605684 | -122.42586902913901 | (37.7268374605684, -122.425869029139) | ||
| 66972 | 66972 | 70511 | Undocumented 2 | Syringa :: Lilac Tree 422 | 86 Valmar Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 2 | 6005252.68709 | 2092603.41387 | 37.7261878964399 | -122.424036534566 | (37.7261878964399, -122.424036534566) | ||
| 54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
| 183924 | 183924 | 70514 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3466 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 11 | 5997689.04386 | 2116122.25538 | 37.7903348014597 | -122.451879457883 | (37.7903348014597, -122.451879457883) | ||
| 131851 | 131851 | 70515 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1740 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | 13 | 6006352.4159699995 | 2116998.84277 | 37.7932340799326 | -122.421967042561 | (37.7932340799326, -122.421967042561) | ||
| 149645 | 149645 | 70521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 345 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 13 | 6004728.0596199995 | 2093562.7826599998 | 37.728792476979606 | -122.425918404632 | (37.7287924769796, -122.425918404632) | ||
| 168841 | 168841 | 70524 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 81 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 6 | 6004889.289580001 | 2092935.46604 | 37.7270791147056 | -122.425316399345 | (37.7270791147056, -122.425316399345) | ||
| 38546 | 38546 | 70527 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004201.75826 | 2093380.3315400002 | 37.728261749270395 | -122.427724869209 | (37.7282617492704, -122.427724869209) | ||
| 148954 | 148954 | 70529 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1930 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 7 | 5999916.9745 | 2111278.4432 | 37.7771623000193 | -122.44382284855499 | (37.7771623000193, -122.443822848555) | ||
| 34049 | 34049 | 70535 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1364 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 10 | 6001296.3816 | 2110780.432 | 37.7758734704185 | -122.43901535306999 | (37.7758734704185, -122.43901535307) |
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");