Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108029 | 108029 | 86830 | Permitted Site 1 | Araucaria heterophylla :: Norfolk Island Pine 24 | 144 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | unpermitted private planting on DPW-maintained street | 6002845.0 | 2107418.0 | 37.7667290519071 | -122.43341795453999 | (37.7667290519071, -122.43341795454) | ||
109303 | 109303 | 93030 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 45 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
128235 | 128235 | 93029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5x6 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
90012 | 90012 | 94626 | Permitted Site 1 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 9 | permit 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
8577 | 8577 | 11027 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1441 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | owner Victor Seeto signed agreement 3/10/10 to maintain bricks in tree basin in a safe/accessible manner that does not damage tree or restrict growth. | 6007472.87331 | 2117336.51186 | 37.7942243630038 | -122.418114127466 | (37.7942243630038, -122.418114127466) | ||
97339 | 97339 | 85212 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 229 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2007 12:00:00 AM | 3 | 3x3 | maintenance agreement through 7/2/2010 | 5994738.0 | 2088050.0 | 37.7130860517587 | -122.46005525076299 | (37.7130860517587, -122.460055250763) | |
104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
144608 | 144608 | 94467 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
105077 | 105077 | 85251 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1151 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | 3x3 | Under 3yr maintenance agreement. Expires 6/15/2010. | 6001497.16836 | 2088486.70556 | 37.714671592027294 | -122.43672457862 | (37.7146715920273, -122.43672457862) | |
19901 | 19901 | 21524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.5628900002 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) | |||
120551 | 120551 | 13294 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2680X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2001 12:00:00 AM | 8 | 3X3 | Tree located adjacent to 3000 Baker | 5999556.3855 | 2119169.40502 | 37.798808242360295 | -122.445637828136 | (37.7988082423603, -122.445637828136) | |
99553 | 99553 | 93063 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 5 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
128840 | 128840 | 94065 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 5 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
96625 | 96625 | 93062 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2.5x2.5 | Tree 4 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | ||
126310 | 126310 | 92977 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Tree 4 on Seymour St. | 6001670.119 | 2112142.3771 | 37.779634286353996 | -122.437820070618 | (37.779634286354, -122.437820070618) | |||
97926 | 97926 | 93120 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 4 on Lyon St | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | ||
116724 | 116724 | 93001 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Tree 4 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
105829 | 105829 | 94064 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 4 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
95827 | 95827 | 93061 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x2.5 | Tree 3 on Willard. | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
180376 | 180376 | 92976 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Tree 3 on Seymour St. | 6001673.9808 | 2112126.93 | 37.779592092116395 | -122.437805604344 | (37.7795920921164, -122.437805604344) | |||
139372 | 139372 | 93000 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | Tree 3 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
116551 | 116551 | 93975 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 3 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
145528 | 145528 | 94063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
121533 | 121533 | 93024 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
103513 | 103513 | 93863 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree 3 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | |||
139234 | 139234 | 93020 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | Tree 3 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
85124 | 85124 | 85121 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/27/2007 12:00:00 AM | 7 | 2x2 | Tree 2. Permit Number 49495. | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | |
83213 | 83213 | 93060 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 2 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
179113 | 179113 | 92975 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1741 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Tree 2 on Seymour St. | 6001675.9117 | 2112115.8273 | 37.7795617167054 | -122.437798129123 | (37.7795617167054, -122.437798129123) | |||
100435 | 100435 | 92999 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Tree 2 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
138791 | 138791 | 93974 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden Gate Ave Roselyn Ter | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 2 on Golden Gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
142740 | 142740 | 94062 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on Craut | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
120498 | 120498 | 93977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Tree 2 on Anza. | 5996139.989030001 | 2112289.25125 | 37.7797215523196 | -122.45696168713002 | (37.7797215523196, -122.45696168713) | ||
144992 | 144992 | 93023 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
103081 | 103081 | 93862 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Tree 2 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | |||
89654 | 89654 | 93059 | Permitted Site 1 | Tree(s) :: 17 | 145 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x5 | Tree 1 on Willard | 5996969.6 | 2105856.9 | 37.7621075834522 | -122.453627125583 | (37.7621075834522, -122.453627125583) | |||
141818 | 141818 | 92965 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3650X Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Tree 1 on Rivera St | 5981790.1 | 2100170.3 | 37.7456119015234 | -122.505704709348 | (37.7456119015234, -122.505704709348) | ||
119539 | 119539 | 92973 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Market St. | 6001664.0 | 2105786.0 | 37.7621809066996 | -122.437385951828 | (37.7621809066996, -122.437385951828) | ||||
145724 | 145724 | 93021 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1403 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x4 | Tree 1 on Judah | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
100287 | 100287 | 92998 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 395 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Tree 1 on Harrison St | 6013360.4 | 2113007.0 | 37.7826661507953 | -122.397438711561 | (37.7826661507953, -122.397438711561) | ||
87296 | 87296 | 93973 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 59@ Golden gate Ave Roselyn Ter | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Tree 1 on Golden gate Ave | 5998204.2 | 2111419.4 | 37.777451486883294 | -122.449758011487 | (37.7774514868833, -122.449758011487) | ||||
121161 | 121161 | 94061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 1 on Craut. | 6004036.0 | 2094004.0 | 37.7299648256421 | -122.42834233456199 | (37.7299648256421, -122.428342334562) | ||||
90151 | 90151 | 94067 | Permitted Site 1 | Tree(s) :: 17 | 729 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2010 12:00:00 AM | 3x3 | Tree 1 on 18th St. | 6015474.0 | 2105663.0 | 37.76261860269621 | -122.38961341567699 | (37.7626186026962, -122.389613415677) | ||
92708 | 92708 | 85104 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1403 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 9 | 2x2 | Tree 1 | 5992673.9 | 2105865.8 | 37.7618848250494 | -122.46848481907499 | (37.7618848250494, -122.468484819075) | ||
104353 | 104353 | 98250 | Permitted Site 1 | Tree(s) :: 17 | 650 Eddy St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | Sidewalk landscaping permit adjacent to building. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | |||||
122319 | 122319 | 103020 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 40X Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave property permits | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
140145 | 140145 | 103021 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 40X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | See 61 Fair Ave for old permit records | 6006901.0 | 2099544.2 | 37.745338688611206 | -122.41883042692801 | (37.7453386886112, -122.418830426928) | |
138577 | 138577 | 103085 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
141309 | 141309 | 103086 | Permitted Site 1 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.42033558182301 | (37.7728452155106, -122.420335581823) | ||
2157 | 2157 | 127892 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 20 | Width 4ft | Resulted descion 9/7/16 -DE | 6010045.66816 | 2119169.32215 | 37.7994012851886 | -122.40934133534999 | (37.7994012851886, -122.40934133535) | |
92282 | 92282 | 9941 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 5x6 | Resulted descion 9/7/16 -DE | 6010050.959969999 | 2119172.47111 | 37.7994102279433 | -122.40932324608299 | (37.7994102279433, -122.409323246083) | |
102885 | 102885 | 56538 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1601 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49327 | 5990034.81385638 | 2101735.08104673 | 37.750390174718795 | -122.477310384437 | (37.7503901747188, -122.477310384437) | ||||
94299 | 94299 | 84820 | Permitted Site 1 | Tree(s) :: 17 | 772 HARRISON St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49314 | 6012829.0 | 2112467.0 | 37.781153833736205 | -122.39923922217301 | (37.7811538337362, -122.399239222173) | ||||
113971 | 113971 | 84738 | Permitted Site 1 | Tree(s) :: 17 | 97 Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.41246638758899 | (37.7416302361339, -122.412466387589) | ||||
118924 | 118924 | 84818 | Permitted Site 1 | Tree(s) :: 17 | 760 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49223 | 6012704.0 | 2103964.0 | 37.757799540478395 | -122.399074649862 | (37.7577995404784, -122.399074649862) | ||||
84181 | 84181 | 100793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Recently planted by FUF. | 6008363.0 | 2103862.0 | 37.757276607365604 | -122.414080464335 | (37.7572766073656, -122.414080464335) | ||||
943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
79869 | 79869 | 96477 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 777 Florida St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3x3 | Permit number 52657 | 6009359.6 | 2104624.3 | 37.759425635990404 | -122.41068765056299 | (37.7594256359904, -122.410687650563) | ||
45032 | 45032 | 54249 | Permitted Site 1 | Tree(s) :: 17 | 1274 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1972 12:00:00 AM | 20 | Permit Number 9991 | 5988659.40013717 | 2106655.34316867 | 37.763819989179204 | -122.482427078169 | (37.7638199891792, -122.482427078169) | ||
110213 | 110213 | 54248 | Permitted Site 1 | Tree(s) :: 17 | 1270 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1972 12:00:00 AM | Permit Number 9990 | 5988658.49378017 | 2106681.68861971 | 37.7638922738793 | -122.48243214344299 | (37.7638922738793, -122.482432143443) | |||
163608 | 163608 | 54246 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1234 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1972 12:00:00 AM | 12 | Permit Number 9988 | 5988645.1955 | 2106901.8925 | 37.764496120049 | -122.48249427390199 | (37.764496120049, -122.482494273902) | ||
1891 | 1891 | 240582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.765733469154796 | -122.429968344076 | (37.7657334691548, -122.429968344076) | |
125698 | 125698 | 54244 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.42999895682699 | (37.7658818771202, -122.429998956827) | ||
181815 | 181815 | 54243 | Permitted Site 1 | Tristania conferta :: 79 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.777602735942295 | -122.45061099973499 | (37.7776027359423, -122.450610999735) | ||
93532 | 93532 | 54242 | Permitted Site 1 | Tree(s) :: 17 | 1201 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1972 12:00:00 AM | Permit Number 9982 | 5998165.20998344 | 2106218.14593623 | 37.7631679419226 | -122.449518019404 | (37.7631679419226, -122.449518019404) | |||
97208 | 97208 | 54241 | Permitted Site 1 | Tree(s) :: 17 | 1289 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9981 | 5995148.59563824 | 2106773.34474969 | 37.764519343024794 | -122.459991629084 | (37.7645193430248, -122.459991629084) | |||
89804 | 89804 | 54239 | Permitted Site 1 | Tree(s) :: 17 | 1283 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9979 | 5995147.26905248 | 2106811.90515359 | 37.764625143603794 | -122.459999010975 | (37.7646251436038, -122.459999010975) | |||
118456 | 118456 | 54236 | Permitted Site 1 | Tree(s) :: 17 | 1278 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9976 | 5995197.96939939 | 2106850.57690326 | 37.7647342420492 | -122.459826454653 | (37.7647342420492, -122.459826454653) | |||
80129 | 80129 | 54235 | Permitted Site 1 | Tree(s) :: 17 | 1275 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9975 | 5995145.50027148 | 2106863.31902546 | 37.764766211038705 | -122.46000885352899 | (37.7647662110387, -122.460008853529) | |||
112467 | 112467 | 54234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1270 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2010 12:00:00 AM | Permit Number 9974 | 5995196.04681137 | 2106906.46154553 | 37.7648875762272 | -122.45983715274201 | (37.7648875762272, -122.459837152742) | ||
139107 | 139107 | 54233 | Permitted Site 1 | Tree(s) :: 17 | 1269 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9973 | 5995144.17368572 | 2106901.87942936 | 37.7648720116121 | -122.460016235469 | (37.7648720116121, -122.460016235469) | |||
125795 | 125795 | 54232 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.76494254532629 | -122.460021156774 | (37.7649425453263, -122.460021156774) | ||
93090 | 93090 | 54230 | Permitted Site 1 | Tree(s) :: 17 | 1263 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9970 | 5995142.84709997 | 2106940.43983326 | 37.764977812183 | -122.46002361743 | (37.764977812183, -122.46002361743) | |||
112768 | 112768 | 54228 | Permitted Site 1 | Tree(s) :: 17 | 1236 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9967 | 5995188.02638703 | 2107139.59434987 | 37.7655272371859 | -122.45988178223 | (37.7655272371859, -122.45988178223) | |||
79508 | 79508 | 54227 | Permitted Site 1 | Tree(s) :: 17 | 1218 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9966 | 5995184.16942835 | 2107251.70599926 | 37.7658348448517 | -122.45990324446501 | (37.7658348448517, -122.459903244465) | |||
125691 | 125691 | 54226 | Permitted Site 1 | Tree(s) :: 17 | 1214 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9964 | 5995183.31232643 | 2107276.61969912 | 37.765903202108 | -122.45990801387501 | (37.765903202108, -122.459908013875) | |||
89791 | 89791 | 54225 | Permitted Site 1 | Tree(s) :: 17 | 1200 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9963 | 5995180.31246968 | 2107363.81764864 | 37.7661424524971 | -122.45992470687901 | (37.7661424524971, -122.459924706879) | |||
94496 | 94496 | 54224 | Permitted Site 1 | Tree(s) :: 17 | 1275 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9962 | 5995455.80388001 | 2106874.03814043 | 37.76481348491 | -122.45893637741399 | (37.76481348491, -122.458936377414) | |||
116173 | 116173 | 54223 | Permitted Site 1 | Tree(s) :: 17 | 1272 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9961 | 5995507.09104626 | 2106895.652617 | 37.76487578066371 | -122.458760554457 | (37.7648757806637, -122.458760554457) | |||
102929 | 102929 | 54222 | Permitted Site 1 | Tree(s) :: 17 | 1265 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9960 | 5995453.59170055 | 2106938.34058964 | 37.7649899156402 | -122.458948684825 | (37.7649899156402, -122.458948684825) | |||
129258 | 129258 | 54221 | Permitted Site 1 | Tree(s) :: 17 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9959 | 5995452.70682877 | 2106964.06156933 | 37.7650604879304 | -122.458953607806 | (37.7650604879304, -122.458953607806) | |||
103345 | 103345 | 54220 | Permitted Site 1 | Tree(s) :: 17 | 1257 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1972 12:00:00 AM | Permit Number 9958 | 5995451.82195698 | 2106989.78254901 | 37.765131060219495 | -122.458958530796 | (37.7651310602195, -122.458958530796) | |||
110170 | 110170 | 54218 | Permitted Site 1 | Tree(s) :: 17 | 1219 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | Permit Number 9956 | 5995442.51666838 | 2107260.2641065 | 37.7658731976209 | -122.459010301428 | (37.7658731976209, -122.459010301428) | |||
124756 | 124756 | 54216 | Permitted Site 1 | Tree(s) :: 17 | 650 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/1972 12:00:00 AM | Permit Number 9954 | 5995030.20332455 | 2106164.63187071 | 37.762841165213295 | -122.460357005 | (37.7628411652133, -122.460357005) | |||
139263 | 139263 | 54213 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.764000294064495 | -122.465517235123 | (37.7640002940645, -122.465517235123) | |||
142819 | 142819 | 101247 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 9951 | 5993550.0 | 2106615.0 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | ||||
83656 | 83656 | 101246 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301X 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
112391 | 112391 | 54212 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993618.71802201 | 2106620.31797794 | 37.7640110640874 | -122.465271900961 | (37.7640110640874, -122.465271900961) | |||
129054 | 129054 | 101245 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.763865841987204 | -122.465411719392 | (37.7638658419872, -122.465411719392) | |||
122043 | 122043 | 54211 | Permitted Site 1 | Tree(s) :: 17 | 700 Lincoln St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9949 | 5993605.60395035 | 2107361.64964194 | 37.7660458098349 | -122.46537111308399 | (37.7660458098349, -122.465371113084) | |||
124809 | 124809 | 54207 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 525 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1972 12:00:00 AM | Permit Number 9945 | 5994167.427381 | 2106639.11364061 | 37.7640943000648 | -122.463375455955 | (37.7640943000648, -122.463375455955) | |||
118983 | 118983 | 54206 | Permitted Site 1 | Tree(s) :: 17 | 526 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9944 | 5994147.95293559 | 2107032.11537111 | 37.7651722581206 | -122.46347133431499 | (37.7651722581206, -122.463471334315) | |||
112322 | 112322 | 54205 | Permitted Site 1 | Tree(s) :: 17 | 139 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9943 | 5995354.17926051 | 2107022.12845835 | 37.76521426040021 | -122.45929859343 | (37.7652142604002, -122.45929859343) | |||
82541 | 82541 | 54204 | Permitted Site 1 | Tree(s) :: 17 | 131 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | Permit Number 9942 | 5995377.99005235 | 2107022.95842059 | 37.7652179081932 | -122.459216298261 | (37.7652179081932, -122.459216298261) | |||
75747 | 75747 | 54203 | Permitted Site 1 | Tree(s) :: 17 | 129 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9941 | 5995383.94275448 | 2107023.1659113 | 37.76521882013321 | -122.459195724453 | (37.7652188201332, -122.459195724453) | |||
108112 | 108112 | 54200 | Permitted Site 1 | Tree(s) :: 17 | 45 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | Permit Number 9938 | 5995654.85488521 | 2107032.60892369 | 37.7652603192898 | -122.458259393816 | (37.7652603192898, -122.458259393816) | |||
118402 | 118402 | 54199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 44 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1972 12:00:00 AM | 4x4 | Permit Number 9937 | 5995656.55399656 | 2107084.69972772 | 37.765403444810204 | -122.45825728758899 | (37.7654034448102, -122.458257287589) |
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");