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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 130 | 130 | 66855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2041 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 8 | Permit Number 30161 | 5998071.2779 | 2109932.9259 | 37.7733624072524 | -122.450110663343 | (37.7733624072524, -122.450110663343) | |
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 134 | 134 | 47510 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 54X Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2017 12:00:00 AM | 3 | 3x3 | Permit Number 45390 | 6003705.560409999 | 2094600.28554 | 37.731583388063 | -122.42952721221901 | (37.731583388063, -122.429527212219) | |
| 144 | 144 | 11598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.760483446414796 | -122.506543543521 | (37.7604834464148, -122.506543543521) | ||
| 146 | 146 | 97319 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:52:00 PM | 3 | 3x3 | 5989945.5882 | 2099070.048 | 37.7430675136338 | -122.477424174253 | (37.7430675136338, -122.477424174253) | ||
| 147 | 147 | 58021 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4026 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:07:00 PM | 3 | Permit Number 16988 | 5983218.6194 | 2106316.5419 | 37.7625717348083 | -122.50121971656999 | (37.7625717348083, -122.50121971657) | ||
| 151 | 151 | 36617 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 156 | 156 | 54712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4508 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 11:58:00 AM | 3 | 3x3 | Permit Number 10547 | 5981730.2931 | 2106265.9364 | 37.762345274891 | -122.506363455406 | (37.762345274891, -122.506363455406) | |
| 157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 164 | 164 | 97323 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1011 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:25:00 PM | 3 | 3x3 | 5990005.0659 | 2099005.494 | 37.7428937161431 | -122.477213802134 | (37.7428937161431, -122.477213802134) | ||
| 169 | 169 | 251221 | Permitted Site 1 | Tree(s) :: 17 | 2401X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778039 | ||||||
| 170 | 170 | 48827 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | 3x3 | Permit Number 46051 | 6011929.23024 | 2118387.60951 | 37.79736024144329 | -122.402768502565 | (37.7973602414433, -122.402768502565) | |
| 172 | 172 | 48332 | Permitted Site 1 | Tree(s) :: 17 | 142 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 177 | 177 | 97317 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:59:00 PM | 3 | 3x3 | 5990071.4812 | 2099073.5168 | 37.7430843422325 | -122.476989128346 | (37.7430843422325, -122.476989128346) | ||
| 180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
| 184 | 184 | 138801 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2375 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1997 12:00:00 AM | 2 | Width 0ft | 6002525.8905 | 2115062.7753 | 37.787701584977704 | -122.43506851988899 | (37.7877015849777, -122.435068519889) | ||
| 190 | 190 | 57209 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | Permit Number 773671 | 6000999.92024 | 2115926.87738 | 37.7899874194288 | -122.440410066565 | (37.7899874194288, -122.440410066565) | ||
| 193 | 193 | 6069 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 3X3 | 6001175.3543 | 2112495.6639 | 37.7805761758993 | -122.439557004629 | (37.7805761758993, -122.439557004629) | ||
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 204 | 204 | 61453 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1984 12:00:00 AM | Permit Number 21392 | |||||||||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
| 226 | 226 | 220498 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 8 | Width 3ft | Permit Number 11470 | 6001117.07632 | 2105053.576 | 37.760138741716794 | -122.43922504972001 | (37.7601387417168, -122.43922504972) | |
| 229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
| 232 | 232 | 2726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.43403775447099 | (37.7868773504916, -122.434037754471) | |||
| 235 | 235 | 45975 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 236 | 236 | 8118 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 841 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6003718.373 | 2111409.0283 | 37.777736949412606 | -122.430681932079 | (37.7777369494126, -122.430681932079) | ||
| 268 | 268 | 46773 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 35 San Juan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2017 12:00:00 AM | 3 | Permit Number 779460 | 6001741.72526 | 2092006.08473 | 37.7243489150655 | -122.43613098976101 | (37.7243489150655, -122.436130989761) | |
| 270 | 270 | 28098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 639 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 3X3 | 6001577.9698 | 2110674.4978 | 37.7755986195101 | -122.438033679217 | (37.7755986195101, -122.438033679217) | ||
| 279 | 279 | 48153 | Permitted Site 1 | Tree(s) :: 17 | 263 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 284 | 284 | 137592 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1125 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1990 12:00:00 AM | 18 | Width 0ft | 6002857.6038 | 2112094.871 | 37.7795712988398 | -122.433708655697 | (37.7795712988398, -122.433708655697) | ||
| 297 | 297 | 32804 | Permitted Site 1 | Tree(s) :: 17 | 1683 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779644 | 5999817.40523345 | 2110171.54968226 | 37.774117372599896 | -122.44408773423099 | (37.7741173725999, -122.444087734231) | |
| 308 | 308 | 46059 | Permitted Site 1 | Tree(s) :: 17 | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 316 | 316 | 67789 | Permitted Site 1 | Tree(s) :: 17 | 7 4384 St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1992 12:00:00 AM | Permit Number 31429 | ||||||||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 320 | 320 | 48259 | Permitted Site 1 | Tree(s) :: 17 | 123 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 321 | 321 | 65143 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | Permit Number 27118 | |||||||||
| 322 | 322 | 7968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3 | 3X3 | 6005627.24821 | 2116610.0246200003 | 37.7921255585096 | -122.42444850412 | (37.7921255585096, -122.42444850412) | ||
| 326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
| 330 | 330 | 114206 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1030 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2016 01:19:00 PM | 3 | 3x3 | 5989968.0933 | 2099069.2019 | 37.7430664963024 | -122.477346296714 | (37.7430664963024, -122.477346296714) | ||
| 349 | 349 | 251274 | Permitted Site 1 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 1756 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | 6014327.39232 | 2094988.66412 | 37.7332454837777 | -122.39283233246701 | (37.7332454837777, -122.392832332467) | ||
| 356 | 356 | 5230 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1051 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2004 12:00:00 AM | 3 | 4x4 | 6001389.4157 | 2112056.3671 | 37.7793821590717 | -122.43878497743201 | (37.7793821590717, -122.438784977432) | ||
| 371 | 371 | 8188 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | ||
| 374 | 374 | 117614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 3 | 5x5 | 6010658.32467 | 2115339.45675 | 37.788919706525704 | -122.406951233227 | (37.7889197065257, -122.406951233227) | ||
| 380 | 380 | 54250 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1278 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769471 | 5988656.6839 | 2106624.6375 | 37.7637355217759 | -122.48243422269199 | (37.7637355217759, -122.482434222692) | |
| 381 | 381 | 122664 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 386 | 386 | 2602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005112.3923 | 2115130.7833 | 37.7880348455319 | -122.42612455857201 | (37.7880348455319, -122.426124558572) | |||
| 401 | 401 | 235987 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1118 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 10 | Width 3ft | Permit Number 42064 | 6004405.04081 | 2102370.6961 | 37.7529587370629 | -122.42766238971399 | (37.7529587370629, -122.427662389714) | |
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 408 | 408 | 23369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 6006387.07969 | 2115184.64805 | 37.788254707334 | -122.421718185767 | (37.788254707334, -122.421718185767) | |||
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 420 | 420 | 54426 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 770 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 15 | 3x3 | Permit Number 12242 | 6012397.0815 | 2104349.75534 | 37.758841631549394 | -122.400163199892 | (37.7588416315494, -122.400163199892) | |
| 422 | 422 | 23174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 3x3 | 6006908.21847 | 2111432.04348 | 37.777980343250796 | -122.419648771078 | (37.7779803432508, -122.419648771078) | |||
| 424 | 424 | 122666 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 401x Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 426 | 426 | 21683 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1840 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/1999 12:00:00 AM | 6 | 2x2 | 6003770.0848 | 2114594.6383 | 37.786486768354294 | -122.430730428794 | (37.7864867683543, -122.430730428794) | ||
| 430 | 430 | 103824 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1000 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.91038 | 2114418.6460599997 | 37.786183288961205 | -122.419709589538 | (37.7861832889612, -122.419709589538) | ||
| 435 | 435 | 95185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001223.4102 | 2113260.1588 | 37.78267801898829 | -122.43944557401699 | (37.7826780189883, -122.439445574017) | |||
| 438 | 438 | 157409 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 3x5 | 6005572.56549 | 2096690.1102099998 | 37.7374271143738 | -122.423221099494 | (37.7374271143738, -122.423221099494) | ||
| 440 | 440 | 157410 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 125 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2017 12:00:00 AM | 3 | 2x5 | 6005546.67522 | 2096690.9332 | 37.7374279129674 | -122.423310672857 | (37.7374279129674, -122.423310672857) | ||
| 441 | 441 | 251295 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 3x3 | Permit Number 27117 | 5982087.0 | 2112698.0 | 37.7800268469822 | -122.50560657808902 | (37.7800268469822, -122.505606578089) | ||
| 442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
| 444 | 444 | 44838 | Permitted Site 1 | Tree(s) :: 17 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 459 | 459 | 35612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768882 | 6000549.03074 | 2116799.12347 | 37.792356695946005 | -122.442032735847 | (37.792356695946, -122.442032735847) | |
| 467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 469 | 469 | 85530 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 101X 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007333.48731 | 2109350.5044400003 | 37.772288880253704 | -122.418030010287 | (37.7722888802537, -122.418030010287) | |||
| 488 | 488 | 2821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008831.67633 | 2116355.92064 | 37.7916082855564 | -122.41334312239701 | (37.7916082855564, -122.413343122397) | |||
| 504 | 504 | 81687 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 210 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 12:00:00 AM | 3 | Permit Number 777040 | 5999000.68344445 | 2107685.40393875 | 37.7672444226119 | -122.446733986311 | (37.7672444226119, -122.446733986311) | ||
| 506 | 506 | 4706 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 950 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:29:00 PM | 3 | 4x4 | 6008667.8262 | 2120581.3066 | 37.8032009492885 | -122.414209123056 | (37.8032009492885, -122.414209123056) | ||
| 509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 510 | 510 | 7848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006120.7355 | 2113033.04101 | 37.7823319018231 | -122.422486748168 | (37.7823319018231, -122.422486748168) | |||
| 515 | 515 | 48129 | Permitted Site 1 | Tree(s) :: 17 | 297 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 524 | 524 | 4705 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 940 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:01:00 PM | 3 | 3X3 | 6008689.9314 | 2120561.6575 | 37.8031482394038 | -122.414131236147 | (37.8031482394038, -122.414131236147) | ||
| 529 | 529 | 232316 | Permitted Site 1 | Magnolia x soulangiana :: Saucer Magnolia 92 | 79 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 22 | Width 3ft | Permit Number 778647 | 6007387.04905 | 2098921.1752299997 | 37.743655357512104 | -122.417105607056 | (37.7436553575121, -122.417105607056) | |
| 530 | 530 | 8262 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1555 Galvez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 01:22:00 PM | 3 | 3x3 | 6016000.34735 | 2097516.43828 | 37.7402790201492 | -122.38722467697501 | (37.7402790201492, -122.387224676975) | ||
| 531 | 531 | 27691 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1765 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 7 | 3X3 | 6001581.2067 | 2112155.8038 | 37.779666096456 | -122.438128618136 | (37.779666096456, -122.438128618136) | ||
| 534 | 534 | 2998 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2314 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003265.59996 | 2115577.92692 | 37.7891580349704 | -122.43254607984501 | (37.7891580349704, -122.432546079845) | |||
| 536 | 536 | 45913 | Permitted Site 1 | Tree(s) :: 17 | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 538 | 538 | 224356 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3122 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 20 | Width 4ft | Permit Number 16121 | 6005963.44888 | 2106707.74991 | 37.7649553019601 | -122.422581275918 | (37.7649553019601, -122.422581275918) | |
| 540 | 540 | 224369 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3159 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 16 | Width 3ft | Permit Number 18874 | 6005753.01157 | 2106639.16646 | 37.7647551137777 | -122.423304250809 | (37.7647551137777, -122.423304250809) | |
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 543 | 543 | 224593 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 13 | Width 3ft | Permit Number 18870 | 6005970.19181 | 2106649.76485 | 37.7647964691065 | -122.42255383310801 | (37.7647964691065, -122.422553833108) | |
| 544 | 544 | 224355 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 23 | Width 6ft | Permit Number 16120 | 6005992.7506800005 | 2106707.14788 | 37.7649553019752 | -122.42247988543501 | (37.7649553019752, -122.422479885435) | |
| 547 | 547 | 224594 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.2222599997 | 37.7647909508601 | -122.42263236011001 | (37.7647909508601, -122.42263236011) | |
| 548 | 548 | 18094 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999514.29 | 2114642.3727 | 37.786375803755895 | -122.445457799993 | (37.7863758037559, -122.445457799993) | |||
| 550 | 550 | 3006 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002989.49365 | 2115542.57517 | 37.7890453067372 | -122.433498845012 | (37.7890453067372, -122.433498845012) | |||
| 554 | 554 | 31894 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 333 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35323 | 6008421.36423 | 2108725.6861900003 | 37.7706344442547 | -122.41422271959999 | (37.7706344442547, -122.4142227196) | |
| 559 | 559 | 224354 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3030 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 21 | Width 4ft | Permit Number 16115 | 6006614.25148 | 2106740.2812200002 | 37.7650813194782 | -122.420332618267 | (37.7650813194782, -122.420332618267) | |
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 568 | 568 | 222894 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.42142962480301 | (37.765028210007, -122.421429624803) | |
| 570 | 570 | 22578 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006396.3025 | 2112828.5224900004 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) |
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");