Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127330 | 127330 | 109501 | Private 5 | Ulmus americana :: American Elm 119 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.802105381717894 | -122.404424889694 | (37.8021053817179, -122.404424889694) | ||||
84402 | 84402 | 109353 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
104832 | 104832 | 109350 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
113379 | 113379 | 109349 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
122284 | 122284 | 109352 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
125736 | 125736 | 109351 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
139898 | 139898 | 109348 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
93974 | 93974 | 121246 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
94513 | 94513 | 121248 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
100736 | 100736 | 121249 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
113673 | 113673 | 121247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
140147 | 140147 | 121245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
125580 | 125580 | 109829 | Private 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | |||
98596 | 98596 | 115128 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
104521 | 104521 | 115129 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
116115 | 116115 | 104650 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 346 LAKE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.46322230514099 | (37.7868637456835, -122.463222305141) | ||||
101604 | 101604 | 108440 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | ||||
142217 | 142217 | 108441 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 105 Lake St | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.45913 | 2114890.0759 | 37.786807513731105 | -122.46047306430201 | (37.7868075137311, -122.460473064302) | |||
103533 | 103533 | 12529 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.78679797610221 | -122.460619935074 | (37.7867979761022, -122.460619935074) |
142320 | 142320 | 82180 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773769 | 5995179.68463591 | 2114884.08050195 | 37.78679106496129 | -122.46047184952101 | (37.7867910649613, -122.460471849521) | ||
102017 | 102017 | 85741 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
117366 | 117366 | 85739 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
142254 | 142254 | 85740 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
15625 | 15625 | 109064 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014787.30736 | 2114269.34055 | 37.7862115942283 | -122.39259051256799 | (37.7862115942283, -122.392590512568) | ||
14482 | 14482 | 109063 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014773.1420599995 | 2114255.79417 | 37.7861736122787 | -122.39263857322901 | (37.7861736122787, -122.392638573229) | ||
981 | 981 | 191653 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 149 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012146.38303 | 2114300.35662 | 37.786149737060796 | -122.40172965521799 | (37.7861497370608, -122.401729655218) | |||
16245 | 16245 | 109062 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014756.57852 | 2114238.14616 | 37.7861242349771 | -122.392694644144 | (37.7861242349771, -122.392694644144) | ||
9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
7821 | 7821 | 99713 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001685.4406 | 2113539.6106 | 37.7834716060779 | -122.43786717092199 | (37.7834716060779, -122.437867170922) | |||
7784 | 7784 | 99714 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001688.147999999 | 2113522.0126 | 37.7834234404081 | -122.43785654353 | (37.7834234404081, -122.43785654353) | |||
7284 | 7284 | 99715 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001690.8553 | 2113503.3994 | 37.7833724872506 | -122.43784584376199 | (37.7833724872506, -122.437845843762) | |||
1517 | 1517 | 99716 | Private 5 | Platanus racemosa :: California Sycamore 81 | 1415 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001693.2243 | 2113487.1552 | 37.7833280195253 | -122.43783648412202 | (37.7833280195253, -122.437836484122) | |||
2892 | 2892 | 99717 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1415 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001694.9164 | 2113468.8804 | 37.7832779377979 | -122.437829320807 | (37.7832779377979, -122.437829320807) | |||
130745 | 130745 | 82138 | Private 5 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 12 | 5993114.289030001 | 2113170.0137400003 | 37.781965672785795 | -122.467492879752 | (37.7819656727858, -122.467492879752) | ||
122211 | 122211 | 36938 | Private 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.8234389997 | 37.781712581861 | -122.46978695177602 | (37.781712581861, -122.469786951776) | |
103226 | 103226 | 104358 | Private 5 | Maytenus boaria :: Mayten 22 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3 | 6005986.0 | 2112447.0 | 37.7807151749226 | -122.42291120983299 | (37.7807151749226, -122.422911209833) | ||||
139890 | 139890 | 9241 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6442 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1993 12:00:00 AM | 6 | 3x3 | 5986987.758640001 | 2112604.7127900003 | 37.7800579063209 | -122.488646014596 | (37.7800579063209, -122.488646014596) | ||
966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
22941 | 22941 | 110324 | Private 5 | Tree(s) :: 17 | 580 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | Permit Number 773594 | 6005065.6 | 2110970.4 | 37.7766088164574 | -122.42599017584601 | (37.7766088164574, -122.425990175846) | ||
50 | 50 | 138938 | Private 5 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) | |
105247 | 105247 | 25212 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 215X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006420.227630001 | 2110742.05634 | 37.7760583047566 | -122.421287897592 | (37.7760583047566, -122.421287897592) | |||
127560 | 127560 | 108446 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 672 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.5397799998 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | |||
102 | 102 | 98037 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1384X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2017 12:00:00 AM | 3 | Permit Number 767782 | 6001197.2582 | 2110764.9293 | 37.775825263482105 | -122.439357134105 | (37.7758252634821, -122.439357134105) | ||
78271 | 78271 | 16888 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
83519 | 83519 | 16883 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
85166 | 85166 | 16887 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
85178 | 85178 | 16884 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
102333 | 102333 | 122643 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
113580 | 113580 | 16882 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
115127 | 115127 | 122644 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
116204 | 116204 | 16886 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
140005 | 140005 | 122641 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
140429 | 140429 | 122642 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
142156 | 142156 | 16885 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
1491 | 1491 | 110535 | Private 5 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
1496 | 1496 | 110536 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X ASHBURY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 05/29/2015 02:12:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
79432 | 79432 | 106576 | Private 5 | Private shrub :: Private Shrub 64 | 507 STEINER ST | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | |||||
90136 | 90136 | 108459 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 771 11th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | |||
144924 | 144924 | 114895 | Private 5 | Lagunaria patersonii :: Primrose Tree 48 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | |||
57485 | 57485 | 73751 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 10 | 3x3 | 5990095.37972 | 2109981.17843 | 37.7730352575459 | -122.477703639701 | (37.7730352575459, -122.477703639701) | |
145512 | 145512 | 72375 | Private 5 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.47768879633699 | (37.773031079694, -122.477688796337) | |
27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
185734 | 185734 | 73761 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 3x3 | 5990097.66816 | 2109968.1044799997 | 37.772999492868706 | -122.47769476794599 | (37.7729994928687, -122.477694767946) | |
109976 | 109976 | 117353 | Private 5 | Pittosporum crassifolium :: Karo Tree 108 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.771057483634294 | -122.39039747437401 | (37.7710574836343, -122.390397474374) | |||
126236 | 126236 | 104626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6X5 | 6001285.0 | 2108936.0 | 37.7708084746611 | -122.438922516011 | (37.7708084746611, -122.438922516011) | |||
123092 | 123092 | 104627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5X5 | 6001306.0 | 2108720.0 | 37.7702165872443 | -122.438834395611 | (37.7702165872443, -122.438834395611) | |||
83017 | 83017 | 104401 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 727 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999017.0 | 2108166.0 | 37.768564950056 | -122.44671213341002 | (37.768564950056, -122.44671213341) | ||||
139788 | 139788 | 104400 | Private 5 | Maytenus boaria :: Mayten 22 | 755 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5999044.0 | 2107976.0 | 37.768044800389 | -122.44660507122101 | (37.768044800389, -122.446605071221) | ||||
13268 | 13268 | 187627 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 88 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
102645 | 102645 | 110587 | Private 5 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 151 EDGEWOOD AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996558.0 | 2106132.0 | 37.7628393335165 | -122.45507056334999 | (37.7628393335165, -122.45507056335) | |||||
100517 | 100517 | 104502 | Private 5 | Pinus radiata :: Monterey Pine 3 | 30X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
92292 | 92292 | 39627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
103609 | 103609 | 39626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1550 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | ||
104147 | 104147 | 39629 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
123904 | 123904 | 106641 | Private 5 | Private shrub :: Private Shrub 64 | 1323X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
103907 | 103907 | 106639 | Private 5 | Private shrub :: Private Shrub 64 | 1321X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2105100.0 | 37.7601403710114 | -122.44686158716699 | (37.7601403710114, -122.446861587167) | |||||
2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
88121 | 88121 | 71505 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 328 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774557 | 6006691.32680411 | 2104197.11487977 | 37.758102721165706 | -122.41988555479601 | (37.7581027211657, -122.419885554796) | |
76816 | 76816 | 104448 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
100922 | 100922 | 104446 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
5091 | 5091 | 253769 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
145175 | 145175 | 108885 | Private 5 | Cupaniopsis anacardioides :: Carrotwood 118 | 707 NOE ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003152.4 | 2104071.5 | 37.757557804850705 | -122.43211570496099 | (37.7575578048507, -122.432115704961) | ||||
110956 | 110956 | 118356 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 RACCOON DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 48 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | ||||
101429 | 101429 | 121090 | Private 5 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
141824 | 141824 | 121089 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
97548 | 97548 | 113801 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 806 SHOTWELL ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||||
124928 | 124928 | 104968 | Private 5 | Pinus halepensis :: Allepo Pine 164 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770776 | 6002186.6 | 2103026.0 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | |||
93853 | 93853 | 109126 | Private 5 | Schinus molle :: California Pepper 138 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6002411.0 | 2103002.0 | 37.754579151967796 | -122.434603290485 | (37.7545791519678, -122.434603290485) | |||
141344 | 141344 | 109125 | Private 5 | Schinus molle :: California Pepper 138 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002411.0 | 2103002.0 | 37.754579151967796 | -122.434603290485 | (37.7545791519678, -122.434603290485) | |||
102518 | 102518 | 104768 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.43452461352699 | (37.7542282864134, -122.434524613527) | |||
123259 | 123259 | 73314 | Private 5 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2014 12:00:00 AM | 3 | 3x3 | 6009184.98526399 | 2102501.75487234 | 37.7535878144828 | -122.411141625253 | (37.7535878144828, -122.411141625253) |
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");