Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187726 | 187726 | 98767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003313.437419999 | 2121061.12622 | 37.8042161969888 | -122.432772427524 | (37.8042161969888, -122.432772427524) | |||
| 187708 | 187708 | 96682 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985880.71623 | 2113435.4542400003 | 37.7822742209113 | -122.492536917229 | (37.7822742209113, -122.492536917229) | ||
| 187249 | 187249 | 98829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 21 | 3x3 | 6008023.617869999 | 2119295.81426 | 37.7996351035429 | -122.41634732658702 | (37.7996351035429, -122.416347326587) | |||
| 186807 | 186807 | 96685 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 375@32nd Ave 32nd Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 20 | Permit Number 768040 | 5985883.85851 | 2113362.06041 | 37.782072886304704 | -122.492520639753 | (37.7820728863047, -122.492520639753) | ||
| 186098 | 186098 | 96686 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985884.08947 | 2113350.81045 | 37.7820420106561 | -122.49251901199499 | (37.7820420106561, -122.492519011995) | ||
| 183228 | 183228 | 104173 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 1266 Washington St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008666.764169999 | 2117323.84982 | 37.7942567215292 | -122.41398222199899 | (37.7942567215292, -122.413982221999) | ||
| 183154 | 183154 | 113770 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 6001403.30227 | 2117311.89486 | 37.7938132775122 | -122.43911370912501 | (37.7938132775122, -122.439113709125) | ||||
| 182999 | 182999 | 103192 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 0 | 3x4 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | |||
| 182258 | 182258 | 95105 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2008 12:00:00 AM | 2 | 5999611.3063900005 | 2120892.8119799998 | 37.803543390775296 | -122.445571780333 | (37.8035433907753, -122.445571780333) | |||
| 181092 | 181092 | 98760 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 19 | 3x3 | 6003175.67956 | 2121043.58403 | 37.8041602168919 | -122.433247894574 | (37.8041602168919, -122.433247894574) | |||
| 180960 | 180960 | 92658 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | Permit Number 52915 | 5999791.1848 | 2116474.20228 | 37.7914213317691 | -122.44463152831699 | (37.7914213317691, -122.444631528317) | ||
| 175961 | 175961 | 98516 | Permitted Site 1 | Fraxinus ornus :: Flowering Ash 380 | 2X 13th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768342 | 6009153.62635 | 2108341.99654 | 37.7696220261636 | -122.41166269150601 | (37.7696220261636, -122.411662691506) | |
| 174422 | 174422 | 98523 | Permitted Site 1 | Fraxinus ornus :: Flowering Ash 380 | 2X 13th St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768342 | 6009019.69789 | 2108349.3944200003 | 37.76963482531271 | -122.41212647008699 | (37.7696348253127, -122.412126470087) | |
| 173812 | 173812 | 98769 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3x3 | 6003355.72677 | 2121066.39367 | 37.8042330583593 | -122.43262645856701 | (37.8042330583593, -122.432626458567) | |||
| 173675 | 173675 | 117056 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5997140.09186 | 2115499.411 | 37.788593180684096 | -122.453733787982 | (37.7885931806841, -122.453733787982) | |||
| 173674 | 173674 | 109355 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 5x45 | 6007469.51339 | 2120600.5219 | 37.8031863275346 | -122.41835729337299 | (37.8031863275346, -122.418357293373) | |||
| 173453 | 173453 | 106777 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/03/2014 12:00:00 AM | 5 | Permit Number 773142 | 6012265.00001 | 2102937.69671 | 37.7549570630325 | -122.400520812589 | (37.7549570630325, -122.400520812589) | ||
| 173136 | 173136 | 98776 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003515.54038 | 2121088.88501 | 37.804303875477096 | -122.43207501857 | (37.8043038754771, -122.43207501857) | |||
| 171997 | 171997 | 109358 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 7 | 5x45 | 6007454.77295 | 2120598.70497 | 37.8031805089291 | -122.41840817430901 | (37.8031805089291, -122.418408174309) | |||
| 169267 | 169267 | 71822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1300 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/1982 12:00:00 AM | 3 | 5988042.7796 | 2106389.3653 | 37.763053797513706 | -122.48454024385201 | (37.7630537975137, -122.484540243852) | |||
| 168446 | 168446 | 115307 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1309 Hyde St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 2x2 | 6007522.861409999 | 2116889.0118 | 37.792998452176796 | -122.41790942558501 | (37.7929984521768, -122.417909425585) | |||
| 166051 | 166051 | 64856 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Almaden Ct | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 2 | Permit Number 25872 | 5995898.09877 | 2112568.97781 | 37.7804757138181 | -122.45781873289499 | (37.7804757138181, -122.457818732895) | |
| 165797 | 165797 | 121508 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 300 Folsom St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 3x3 | 6012258.9126 | 2112729.3972 | 37.78184252759429 | -122.401229897449 | (37.7818425275943, -122.401229897449) | |||
| 165655 | 165655 | 103189 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1601X 28th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 12 | 3x4 | 5987449.3548 | 2104293.8827 | 37.7572656000244 | -122.48643881405899 | (37.7572656000244, -122.486438814059) | |||
| 163077 | 163077 | 87247 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 236323 Larkin St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/19/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50274 | 6006692.88945 | 2119331.74907 | 37.7996588510331 | -122.42095469191601 | (37.7996588510331, -122.420954691916) | |
| 162813 | 162813 | 99285 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 6000571.30245 | 2116798.91345 | 37.7923573884461 | -122.441955660321 | (37.7923573884461, -122.441955660321) | ||||
| 161933 | 161933 | 116644 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 20 Hawthorne St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 19 | 3x3 | 6012905.262159999 | 2114080.06239 | 37.7855871796405 | -122.39908864853099 | (37.7855871796405, -122.399088648531) | |||
| 161413 | 161413 | 98761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.43316765437599 | (37.8041696588781, -122.433167654376) | |||
| 161406 | 161406 | 92599 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52915 | 5999799.49653 | 2116432.67643 | 37.7913077869862 | -122.444599784076 | (37.7913077869862, -122.444599784076) | |
| 159658 | 159658 | 98517 | Permitted Site 1 | Fraxinus ornus :: Flowering Ash 380 | 2X 13th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768342 | 6009134.24812 | 2108342.72554 | 37.7696229407755 | -122.411729771911 | (37.7696229407755, -122.411729771911) | |
| 159418 | 159418 | 112611 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6002596.08972 | 2118131.51512 | 37.7961315408952 | -122.435045206767 | (37.7961315408952, -122.435045206767) | ||||
| 155176 | 155176 | 109361 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 5x45 | 6007445.84949 | 2120597.53947 | 37.803176806427004 | -122.418438971581 | (37.803176806427, -122.418438971581) | |||
| 154297 | 154297 | 98768 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003334.441219999 | 2121062.9029099997 | 37.8042222665138 | -122.432699869304 | (37.8042222665138, -122.432699869304) | |||
| 154176 | 154176 | 117059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 17 | 3x3 | 5997147.32541 | 2115449.33488 | 37.788456099723895 | -122.453705143689 | (37.7884560997239, -122.453705143689) | |||
| 153085 | 153085 | 98522 | Permitted Site 1 | Fraxinus ornus :: Flowering Ash 380 | 2X 13th St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768342 | 6009037.09649 | 2108348.63898 | 37.769633727256604 | -122.412066235296 | (37.7696337272566, -122.412066235296) | |
| 152984 | 152984 | 92598 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2201 Baker St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/25/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52915 | 5999796.94168 | 2116437.53805 | 37.7913209899324 | -122.44460897334 | (37.7913209899324, -122.44460897334) | |
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 151027 | 151027 | 104174 | Permitted Site 1 | Carpinus betulus :: European Hornbeam 296 | 1266 Washington St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/27/2013 12:00:00 AM | 2 | Permit Number 769966 | 6008660.71895 | 2117323.02559 | 37.7942541188741 | -122.414003080877 | (37.7942541188741, -122.414003080877) | ||
| 150375 | 150375 | 98519 | Permitted Site 1 | Fraxinus ornus :: Flowering Ash 380 | 2X 13th St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768342 | 6009095.958219999 | 2108344.44492 | 37.769625513748295 | -122.41186233737899 | (37.7696255137483, -122.411862337379) | |
| 147679 | 147679 | 109360 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 900x Chestnut St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6 | 5x45 | 6007448.76613 | 2120598.25036 | 37.803178922540205 | -122.418428928878 | (37.8031789225402, -122.418428928878) | |||
| 147563 | 147563 | 96683 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 375@32nd Ave 32nd Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 28 | Permit Number 768040 | 5985881.4573800005 | 2113426.06761 | 37.782248491261605 | -122.49253366172199 | (37.7822484912616, -122.492533661722) | ||
| 147467 | 147467 | 82811 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2362 44th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50731 | 5982709.1994 | 2099047.2891 | 37.742582474230396 | -122.502443555218 | (37.7425824742304, -122.502443555218) | |
| 146393 | 146393 | 81679 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) |
| 146288 | 146288 | 2099 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 146286 | 146286 | 103200 | DPW Maintained 3 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1601X 28th Ave | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489.0 | 2103696.0 | 37.7556262873159 | -122.48625781590201 | (37.7556262873159, -122.486257815902) | ||
| 146273 | 146273 | 107913 | Permitted Site 1 | Tree(s) :: 17 | 65X Newburg St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | Permit Number 770183 | 6002412.156690001 | 2099793.63341 | 37.7457698026645 | -122.434369920352 | (37.7457698026645, -122.434369920352) | ||
| 146150 | 146150 | 102665 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3399X Wawona St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | ||||
| 146084 | 146084 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | |||||
| 146074 | 146074 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | ||
| 146003 | 146003 | 97126 | Permitted Site 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2690 Broadway | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/01/2007 12:00:00 AM | Permit Number 49710 | 6000755.5 | 2117242.9 | 37.7935869539564 | -122.441350205853 | (37.7935869539564, -122.441350205853) | |||
| 145994 | 145994 | 97860 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 145969 | 145969 | 113486 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 30 PRESIDIO AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5998975.0 | 2116473.0 | 37.7913714231174 | -122.44745541416201 | (37.7913714231174, -122.447455414162) | ||||
| 145921 | 145921 | 108288 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 145895 | 145895 | 111072 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1450 IRVING ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Fire Dept 11 | 3x3 | 5991277.0 | 2106586.0 | 37.7637815143869 | -122.473368628437 | (37.7637815143869, -122.473368628437) | ||||
| 145801 | 145801 | 107416 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 145770 | 145770 | 106524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 145604 | 145604 | 10747 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 145584 | 145584 | 102008 | Undocumented 2 | Tree(s) :: 17 | 1703 Castro St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | ||||
| 145522 | 145522 | 97036 | Property Tree 7 | Griselinia lucida :: Griselinia 477 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145467 | 145467 | 104336 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1X Beaver St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 145395 | 145395 | 51619 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 396(REVISED) Diamond St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52286 | 6001775.40578603 | 2103546.80768569 | 37.756038960358296 | -122.436840338915 | (37.7560389603583, -122.436840338915) | ||
| 145331 | 145331 | 101702 | Undocumented 2 | Tree(s) :: 17 | 2700 18th St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/13/2012 12:00:00 AM | 2x3 | Permit Number 769052 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | ||
| 145290 | 145290 | 106337 | Undocumented 2 | Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 493 | 497 VALLEY ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 04/17/2014 12:00:00 AM | 2 | Permit Number 770848 | 6002779.0 | 2099138.0 | 37.7439904023543 | -122.433054595711 | (37.7439904023543, -122.433054595711) | ||
| 145280 | 145280 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768767 | 5998994.0 | 2106195.0 | 37.7631517661679 | -122.44664985791401 | (37.7631517661679, -122.446649857914) | ||||
| 145258 | 145258 | 96222 | Significant Tree 6 | Tree(s) :: 17 | 176 Holladay Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/18/2011 12:00:00 AM | 18 | 3x3 | Permit Number 767739 | 6010842.9 | 2100101.6 | 37.7470903528282 | -122.405239158587 | (37.7470903528282, -122.405239158587) | |
| 145213 | 145213 | 97026 | Property Tree 7 | Tilia cordata :: Littleleaf Linden 208 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 145137 | 145137 | 77213 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 499X Hearst Ave | 20 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 145111 | 145111 | 112191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X 05TH ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6012019.0 | 2111820.0 | 37.7793321462044 | -122.401995938922 | (37.7793321462044, -122.401995938922) | ||||
| 144925 | 144925 | 93163 | Permitted Site 1 | Shrub :: Shrub 98 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 144883 | 144883 | 94942 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 144816 | 144816 | 99524 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1501@Everglade Sloat Blvd | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | |||
| 144676 | 144676 | 122851 | Undocumented 2 | Tree(s) :: 17 | 742 Francisco St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007760.0 | 2120975.0 | 37.8042308974981 | -122.417378607523 | (37.8042308974981, -122.417378607523) | ||||
| 144675 | 144675 | 94622 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 1769 Armstrong Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 3 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 144628 | 144628 | 9747 | DPW Maintained 3 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 710X McAllister St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/24/2011 12:00:00 AM | 3 | 4x4 | 6005653.6676 | 2112008.06895 | 37.779491220069296 | -122.424029686189 | (37.7794912200693, -122.424029686189) | ||
| 144514 | 144514 | 96603 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 144510 | 144510 | 10758 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 43 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144479 | 144479 | 10750 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1120X Hudson Ave | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 144417 | 144417 | 102660 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3399X Wawona St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5982463.4 | 2096719.2 | 37.7361757338901 | -122.503121118731 | (37.7361757338901, -122.503121118731) | ||||
| 144359 | 144359 | 115437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 144210 | 144210 | 106521 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 144173 | 144173 | 96099 | Undocumented 2 | Tree(s) :: 17 | 2780X Bryant St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6009802.0 | 2101146.0 | 37.749899795942504 | -122.408912195701 | (37.7498997959425, -122.408912195701) | ||||
| 144156 | 144156 | 94620 | Permitted Site 1 | Pyrus spp :: Pear Tree 291 | 1799X Armstrong Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6014054.0 | 2092727.0 | 37.7270202245482 | -122.393619293726 | (37.7270202245482, -122.393619293726) | ||
| 144144 | 144144 | 94944 | Significant Tree 6 | Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 143955 | 143955 | 103545 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
| 143915 | 143915 | 93160 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 143907 | 143907 | 114714 | Permitted Site 1 | Palm (unknown Genus) :: Palm Spp 161 | 601X Somerset St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010329.348040001 | 2091657.3697400002 | 37.7238755730654 | -122.40642008068501 | (37.7238755730654, -122.406420080685) | |||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 143508 | 143508 | 95265 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 143480 | 143480 | 117482 | Planning Code 138.1 required 4 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 601 PACHECO ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x9 | 5993107.0 | 2101833.0 | 37.7508368102529 | -122.46669375398199 | (37.7508368102529, -122.466693753982) | ||||
| 143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
| 143329 | 143329 | 93161 | Permitted Site 1 | Tree(s) :: 17 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x1 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 143311 | 143311 | 10754 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 143246 | 143246 | 102383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 471-473 Noe St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769850 | 6002995.0 | 2105507.0 | 37.7614904180073 | -122.432762601795 | (37.7614904180073, -122.432762601795) | |
| 143102 | 143102 | 37235 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 142964 | 142964 | 107417 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 300 Seacliff Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/04/2014 12:00:00 AM | 3 | Permit Number 773970 | 5986804.62098 | 2115681.98254 | 37.788496517491104 | -122.489505906992 | (37.7884965174911, -122.489505906992) | ||
| 142748 | 142748 | 37835 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003752.0 | 2090699.0 | 37.720873955994 | -122.42908860130501 | (37.720873955994, -122.429088601305) |
| 142705 | 142705 | 96486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1202 Stanyan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5997433.0 | 2105848.0 | 37.762109700699895 | -122.452023768999 | (37.7621097006999, -122.452023768999) | |||||
| 142684 | 142684 | 103276 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | ||||
| 142661 | 142661 | 115088 | Undocumented 2 | Thuja plicata :: Western Red Cedar 317 | 2784X JACKSON ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000894.0 | 2116629.0 | 37.791909233816206 | -122.44082692769199 | (37.7919092338162, -122.440826927692) | ||||
| 142641 | 142641 | 18431 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) |
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");