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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6011 | 6011 | 66459 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | |
| 6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
| 6309 | 6309 | 63514 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1937 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769639 | 6000284.9286 | 2111624.1423 | 37.778132482558 | -122.44257480934799 | (37.778132482558, -122.442574809348) |
| 6582 | 6582 | 58810 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3199 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772746 | 6002363.40081 | 2119107.0408799998 | 37.7987968652491 | -122.435920192279 | (37.7987968652491, -122.435920192279) | |
| 6596 | 6596 | 84828 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999419.5799 | 2113641.8213 | 37.783623142966 | -122.445713490833 | (37.783623142966, -122.445713490833) |
| 6616 | 6616 | 43072 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 6 | 3x3 | 6008014.74915 | 2114436.68155 | 37.7862926240458 | -122.41603371409799 | (37.7862926240458, -122.416033714098) | |
| 6684 | 6684 | 38517 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2150 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1998 12:00:00 AM | 25 | 6x6 | Permit Number 40504 | 5997521.1508 | 2110251.9474 | 37.77420686213429 | -122.45203664156999 | (37.7742068621343, -122.45203664157) |
| 6714 | 6714 | 97108 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.8589699995 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) |
| 6773 | 6773 | 45307 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 561 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 20 | 5x5 | Permit Number 44145 | 6000554.5197 | 2110946.4965 | 37.7762872030081 | -122.44159355669599 | (37.7762872030081, -122.441593556696) |
| 6899 | 6899 | 52360 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007841.58942 | 2114643.58565 | 37.78685099511571 | -122.416647466318 | (37.7868509951157, -122.416647466318) |
| 6961 | 6961 | 68131 | Permitted Site 1 | Tree(s) :: 17 | 1512 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2014 12:00:00 AM | 3 | Permit Number 773861 | 6000696.77 | 2113847.7478 | 37.7842614019342 | -122.441309693767 | (37.7842614019342, -122.441309693767) | |
| 6966 | 6966 | 120642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2016 12:00:00 AM | 3 | 3x3 | 6008851.25075 | 2115247.06869 | 37.788564746801896 | -122.413196950189 | (37.7885647468019, -122.413196950189) | |
| 7001 | 7001 | 108984 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001097.74629 | 2119009.51185 | 37.7984570968878 | -122.440292758998 | (37.7984570968878, -122.440292758998) | |
| 7007 | 7007 | 66829 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 142 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2016 12:00:00 AM | 3 | Permit Number 30126 | 5996834.5871 | 2112040.6558 | 37.7790788371058 | -122.45454081935101 | (37.7790788371058, -122.454540819351) | |
| 7065 | 7065 | 34676 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2000 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/2015 12:00:00 AM | 3 | Permit Number 775668 | 6003314.31901 | 2118972.51824 | 37.7984814738846 | -122.432620094941 | (37.7984814738846, -122.432620094941) | |
| 7076 | 7076 | 66494 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2454 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2014 12:00:00 AM | 3 | Permit Number 29655 | 6001767.8317 | 2114666.7908 | 37.7865712397422 | -122.437662882365 | (37.7865712397422, -122.437662882365) | |
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 7158 | 7158 | 30976 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34765 | 6004885.74764 | 2117123.17132 | 37.7934926287434 | -122.427050672647 | (37.7934926287434, -122.427050672647) |
| 7190 | 7190 | 59699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3188 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773904 | 5999466.917230001 | 2116043.86882 | 37.7902212404654 | -122.44572252287901 | (37.7902212404654, -122.445722522879) | |
| 7196 | 7196 | 53176 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 3 | 3x3 | Permit Number 49094 | 5998327.8723 | 2109933.5008 | 37.7733786657012 | -122.449223112808 | (37.7733786657012, -122.449223112808) |
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7309 | 7309 | 64383 | Permitted Site 1 | Tree(s) :: 17 | 1727 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773289 | 6010433.5649 | 2120449.6261 | 37.802938410361 | -122.40808941120001 | (37.802938410361, -122.4080894112) |
| 7391 | 7391 | 58164 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 8 | Permit Number 31200 | 6005960.50321 | 2119339.77329 | 37.7996395731743 | -122.423489589398 | (37.7996395731743, -122.423489589398) | |
| 7427 | 7427 | 83207 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 772967 | 6005062.56265 | 2119560.0197 | 37.8001935906169 | -122.426612484272 | (37.8001935906169, -122.426612484272) | |
| 7434 | 7434 | 59955 | Permitted Site 1 | Tree(s) :: 17 | 580 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2015 12:00:00 AM | 3 | Permit Number 773594 | 6005099.7952 | 2110963.7011 | 37.776592355427205 | -122.425871407663 | (37.7765923554272, -122.425871407663) | |
| 7441 | 7441 | 66970 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 109 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2016 12:00:00 AM | 3 | Permit Number 30310 | 5996758.1037 | 2112315.4543 | 37.77982897457179 | -122.454825264921 | (37.7798289745718, -122.454825264921) | |
| 7455 | 7455 | 66458 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 11 Wood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | 12 | Permit Number 29608 | 5998357.739 | 2113627.431 | 37.783522948461396 | -122.449386000758 | (37.7835229484614, -122.449386000758) | |
| 7520 | 7520 | 108983 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2468 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | Permit Number 772908 | 6001114.291780001 | 2119011.40091 | 37.798463225757104 | -122.44023564217501 | (37.7984632257571, -122.440235642175) | |
| 7558 | 7558 | 30975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1950 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 24 | 6x9 | Permit Number 34765 | 6004860.3383 | 2117120.17233 | 37.7934829574257 | -122.42713837725799 | (37.7934829574257, -122.427138377258) |
| 7584 | 7584 | 38094 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | |
| 7637 | 7637 | 36881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | |
| 7638 | 7638 | 52428 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1809X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48544 | 6004799.3483 | 2115577.2997 | 37.7892431693813 | -122.427239454587 | (37.7892431693813, -122.427239454587) |
| 7682 | 7682 | 84827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2680 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 53660 | 5999436.2585 | 2113644.4547 | 37.7836313258411 | -122.445655978901 | (37.7836313258411, -122.445655978901) |
| 7905 | 7905 | 30963 | Permitted Site 1 | Tree(s) :: 17 | 1900 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2016 12:00:00 AM | 3 | Permit Number 778453 | 6001995.095 | 2115110.3689 | 37.787802110792704 | -122.43690837559099 | (37.7878021107927, -122.436908375591) | |
| 7906 | 7906 | 42669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1374 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | 3x5 | Permit Number 46576 | 6007041.18345 | 2118110.17737 | 37.7963243483505 | -122.419662744764 | (37.7963243483505, -122.419662744764) |
| 7916 | 7916 | 63582 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1370 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1987 12:00:00 AM | 7 | 3x3 | Permit Number 24205 | 6006460.0817 | 2118715.02595 | 37.797952359573 | -122.42171646446998 | (37.797952359573, -122.42171646447) |
| 7928 | 7928 | 62385 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 642 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/1987 12:00:00 AM | 12 | Permit Number 22535 | 6001098.1348 | 2110956.5992 | 37.776345899243495 | -122.439713770865 | (37.7763458992435, -122.439713770865) | |
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 8180 | 8180 | 21666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.42931724201799 | (37.7865109691436, -122.429317242018) |
| 8274 | 8274 | 41820 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 848 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/2016 12:00:00 AM | 3 | Permit Number 42207 | 6000005.683999999 | 2111868.9913 | 37.7787888536845 | -122.44355840768 | (37.7787888536845, -122.44355840768) | |
| 8280 | 8280 | 109193 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | |||||
| 8472 | 8472 | 46875 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) |
| 8499 | 8499 | 41209 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.44286834991101 | (37.7996299225355, -122.442868349911) | |
| 8561 | 8561 | 52868 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3295 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48877 | 5999101.91152 | 2115616.94773 | 37.789028180956 | -122.446954675917 | (37.789028180956, -122.446954675917) |
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 8770 | 8770 | 48424 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/03/2014 12:00:00 AM | 3 | Permit Number 772479 | 6001994.11068 | 2118598.66634 | 37.7973800166165 | -122.437161635315 | (37.7973800166165, -122.437161635315) | |
| 8916 | 8916 | 44823 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2440 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778318 | 6001806.8581 | 2114669.8819999998 | 37.7865819462822 | -122.43752808228201 | (37.7865819462822, -122.437528082282) | |
| 8919 | 8919 | 49958 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1635 REVISED Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 46712 | 6005318.44165545 | 2115314.81375181 | 37.788551790903604 | -122.425424765275 | (37.7885517909036, -122.425424765275) | ||
| 8949 | 8949 | 38494 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1345 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774878 | 6006577.84973 | 2118679.48452 | 37.797861412034294 | -122.42130642757401 | (37.7978614120343, -122.421306427574) |
| 9003 | 9003 | 33126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2527 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774205 | 6000811.7731800005 | 2118925.97012 | 37.7982114272598 | -122.44127631424601 | (37.7982114272598, -122.441276314246) | |
| 9041 | 9041 | 42494 | Permitted Site 1 | Tree(s) :: 17 | 698X Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779155 | 5996831.0 | 2094462.0 | 37.7308120537964 | -122.453283804485 | (37.7308120537964, -122.453283804485) | |
| 9547 | 9547 | 68821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.44420161479799 | (37.7299216843992, -122.444201614798) | ||
| 9551 | 9551 | 59160 | Permitted Site 1 | Betula spp :: Birch 95 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 770967 | 6004101.77882738 | 2101279.18641822 | 37.7499445479885 | -122.42863332711599 | (37.7499445479885, -122.428633327116) | ||
| 9563 | 9563 | 108596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 36 Bronte St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 770949 | 6009339.44395 | 2097251.26276 | 37.7391797819084 | -122.410236794344 | (37.7391797819084, -122.410236794344) | ||
| 9566 | 9566 | 95785 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767529 | ||||||
| 9602 | 9602 | 40720 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748834998 | (37.7391809774349, -122.41025748835) | ||
| 9674 | 9674 | 61426 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3501X 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1984 12:00:00 AM | Permit Number 21355 | 6006351.47468928 | 2100870.60661273 | 37.7489497429973 | -122.420824749243 | (37.7489497429973, -122.420824749243) | ||
| 9688 | 9688 | 35795 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 230 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 779148 | 6006467.16362039 | 2104758.98191383 | 37.75963284616879 | -122.42070069541 | (37.7596328461688, -122.42070069541) | ||
| 9693 | 9693 | 50208 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 763 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46916 | 5987522.0 | 2110774.0 | 37.7750624459683 | -122.48666339258301 | (37.7750624459683, -122.486663392583) |
| 9745 | 9745 | 47282 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2810 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | 3x3 | Permit Number 45227 | 6010345.86300325 | 2101091.40389861 | 37.7497803366023 | -122.407027634693 | (37.7497803366023, -122.407027634693) | |
| 9780 | 9780 | 65693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779357 | 6005288.42845233 | 2101344.00549356 | 37.7501896116955 | -122.424534439725 | (37.7501896116955, -122.424534439725) |
| 9793 | 9793 | 43684 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 583 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779365 | 5993748.11926 | 2111537.7275799997 | 37.777520428161296 | -122.46518153966998 | (37.7775204281613, -122.46518153967) | |
| 9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
| 9815 | 9815 | 40304 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 276 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | 10 | Permit Number 46688 | 6006675.32022229 | 2104512.13520977 | 37.7589667921547 | -122.419963267076 | (37.7589667921547, -122.419963267076) | |
| 9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9820 | 9820 | 46927 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9821 | 9821 | 46929 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9830 | 9830 | 60472 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | 3x3 | Permit Number 20066 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |
| 9831 | 9831 | 36377 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) |
| 9832 | 9832 | 36376 | Permitted Site 1 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | |
| 9838 | 9838 | 68204 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 16 | 3x3 | Permit Number 32363 | 6009978.53990017 | 2102725.22931804 | 37.754245896491604 | -122.408413088762 | (37.7542458964916, -122.408413088762) |
| 9872 | 9872 | 63763 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 326 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | 4x4 | Permit Number 24441 | 6003279.4994369 | 2109390.21547957 | 37.7721689148553 | -122.432055945851 | (37.7721689148553, -122.432055945851) | |
| 9917 | 9917 | 63522 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 812 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24132 | 6009881.10701644 | 2104476.66274978 | 37.759049483001 | -122.40887359889999 | (37.759049483001, -122.4088735989) | ||
| 9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
| 9949 | 9949 | 63390 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.734132412410396 | -122.416802921773 | (37.7341324124104, -122.416802921773) | |
| 9950 | 9950 | 68298 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2100 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 3x3 | Permit Number 32107 | 5981719.63070527 | 2100774.89065863 | 37.747267790944 | -122.50599319492201 | (37.747267790944, -122.505993194922) | |
| 9951 | 9951 | 55414 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 28931 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) |
| 9952 | 9952 | 39131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 2.5x3 | Permit Number 40811 | 6007313.40469967 | 2102804.1822591 | 37.7543130741871 | -122.417635411147 | (37.7543130741871, -122.417635411147) | |
| 9954 | 9954 | 173752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) | |||
| 9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
| 9991 | 9991 | 34375 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 157 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38127 | 6003918.97921609 | 2097483.80532691 | 37.7395129612854 | -122.428994891637 | (37.7395129612854, -122.428994891637) | ||
| 10026 | 10026 | 66781 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 63 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2017 12:00:00 AM | 3 | Permit Number 30050 | 6005821.27951384 | 2106893.65445384 | 37.7654577301272 | -122.423086219508 | (37.7654577301272, -122.423086219508) | |
| 10035 | 10035 | 173805 | Permitted Site 1 | Private shrub :: Private Shrub 64 | 221 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999380.73268965 | 2095746.24622826 | 37.7344841059817 | -122.444561268208 | (37.7344841059817, -122.444561268208) | ||||
| 10036 | 10036 | 64803 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 110X VALLEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2017 12:00:00 AM | 3 | Permit Number 779438 | 6005124.0 | 2099350.0 | 37.7447052436017 | -122.424961191686 | (37.7447052436017, -122.424961191686) | |
| 10074 | 10074 | 60000 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1227 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2017 12:00:00 AM | 3 | Permit Number 19486 | 5991400.84514705 | 2107067.03072332 | 37.76510946688521 | -122.472975370228 | (37.7651094668852, -122.472975370228) | |
| 10141 | 10141 | 35805 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 633 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39049 | 6007507.54352575 | 2105966.04756896 | 37.763005750747205 | -122.41718806542102 | (37.7630057507472, -122.417188065421) | ||
| 10156 | 10156 | 42387 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 598x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42553 | 5997475.75161149 | 2094410.34509601 | 37.7307071559588 | -122.451051082577 | (37.7307071559588, -122.451051082577) | ||
| 10158 | 10158 | 44811 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360.0 | 2105036.0 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | ||
| 10159 | 10159 | 42390 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 598x Hearst Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42553 | 5997475.75161149 | 2094410.34509601 | 37.7307071559588 | -122.451051082577 | (37.7307071559588, -122.451051082577) | ||
| 10160 | 10160 | 37874 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10166 | 10166 | 42389 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 598x Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42553 | 5997475.75161149 | 2094410.34509601 | 37.7307071559588 | -122.451051082577 | (37.7307071559588, -122.451051082577) | ||
| 10179 | 10179 | 42388 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 598x Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42553 | 5997475.75161149 | 2094410.34509601 | 37.7307071559588 | -122.451051082577 | (37.7307071559588, -122.451051082577) | ||
| 10181 | 10181 | 37872 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10182 | 10182 | 37873 | Permitted Site 1 | Tree(s) :: 17 | 175 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2017 12:00:00 AM | 3 | Permit Number 779358 | 5996105.27424077 | 2094054.94489501 | 37.7296527551899 | -122.455763326175 | (37.7296527551899, -122.455763326175) | |
| 10197 | 10197 | 42393 | Permitted Site 1 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 598x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42553 | 5997475.75161149 | 2094410.34509601 | 37.7307071559588 | -122.451051082577 | (37.7307071559588, -122.451051082577) | ||
| 10205 | 10205 | 34128 | Permitted Site 1 | Tree(s) :: 17 | 1401 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2017 12:00:00 AM | 3 | Permit Number 779521 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | |
| 10270 | 10270 | 41911 | Permitted Site 1 | Tree(s) :: 17 | 595 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2017 12:00:00 AM | 3 | Permit Number 778901 | 5992201.12975 | 2111434.05815 | 37.7771464503181 | -122.47052549063999 | (37.7771464503181, -122.47052549064) | |
| 10275 | 10275 | 32464 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99x Deming St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36974 | 5999085.33670349 | 2105174.9537063 | 37.7603561904001 | -122.446260575093 | (37.7603561904001, -122.446260575093) | ||
| 10286 | 10286 | 109713 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 643 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774155 | 6002421.08479 | 2090027.9033099997 | 37.7189558444233 | -122.43364123018 | (37.7189558444233, -122.43364123018) |
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");