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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 146018 | 146018 | 104109 | Private 5 | Maytenus boaria :: Mayten 22 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | 6007700.0 | 2097518.0 | 37.739820149686295 | -122.415924151926 | (37.7398201496863, -122.415924151926) | |||
| 145570 | 145570 | 104552 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5997447.0 | 2102183.0 | 37.752047331058705 | -122.45171095800501 | (37.7520473310587, -122.451710958005) | |||
| 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) | |
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 139792 | 139792 | 104962 | Private 5 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 74 Aztec St. | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
| 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) | ||||
| 139627 | 139627 | 112262 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Holly Park Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x15 | 6006308.21143459 | 2096885.36921844 | 37.7380047408881 | -122.420691480393 | (37.7380047408881, -122.420691480393) | |||
| 138621 | 138621 | 104565 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 127060 | 127060 | 22386 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | ||
| 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) | |||
| 122672 | 122672 | 102060 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 115 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994908.3 | 2098325.8 | 37.741310707397396 | -122.460210667073 | (37.7413107073974, -122.460210667073) | |||||
| 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) | ||
| 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) | |
| 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) | |
| 120946 | 120946 | 122898 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6006160.0 | 2102149.0 | 37.752449123979794 | -122.421577653162 | (37.7524491239798, -122.421577653162) | |||
| 120714 | 120714 | 104436 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5992040.0 | 2096369.0 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | ||||
| 120169 | 120169 | 104564 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 119892 | 119892 | 22381 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
| 119638 | 119638 | 109607 | Private 5 | Shrub :: Shrub 98 | 775 Congo St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.44111470541901 | (37.7350943222142, -122.441114705419) | |||||
| 119627 | 119627 | 80516 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 119359 | 119359 | 108314 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002141.0 | 2097265.0 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | ||||
| 118626 | 118626 | 114647 | Private 5 | Eriobotrya deflexa :: Bronze Loquat 49 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | |||
| 118440 | 118440 | 80512 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 9 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 118354 | 118354 | 104317 | Private 5 | Pyrus calleryana :: Ornamental Pear 9 | 13011305 SANCHEZ ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003956.0 | 2100665.0 | 37.748249883960796 | -122.429093651106 | (37.7482498839608, -122.429093651106) | |||
| 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) | |
| 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) | ||
| 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) | ||||
| 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) | ||
| 114700 | 114700 | 80515 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 114609 | 114609 | 80518 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 5 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 113265 | 113265 | 80510 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2007 12:00:00 AM | 9 | Permit Number 49651 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | ||
| 111683 | 111683 | 114761 | Private 5 | Pinus radiata :: Monterey Pine 3 | 2155 10TH AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993160.0 | 2101036.0 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | ||||
| 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) | ||||
| 110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
| 110181 | 110181 | 104309 | Private 5 | Myoporum laetum :: Myoporum 1 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6004798.0 | 2102451.0 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | ||||
| 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) | |||
| 109961 | 109961 | 22155 | Private 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3X3 | 6015579.0 | 2098247.0 | 37.74226164995721 | -122.388732527256 | (37.7422616499572, -122.388732527256) | |||
| 109920 | 109920 | 114977 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | |||
| 109183 | 109183 | 105072 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x6 | 6007074.0 | 2099135.0 | 37.7442248567037 | -122.41820321383699 | (37.7442248567037, -122.418203213837) | |||
| 106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) | ||||||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |
| 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) | |||||
| 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) | ||
| 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) |
| 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) | ||||
| 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) | |||||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | ||||
| 101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 99668 | 99668 | 104881 | Private 5 | Privet :: 262 | 101 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 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) | ||||||
| 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) | |||
| 98944 | 98944 | 108170 | Private 5 | Ginkgo biloba :: Maidenhair Tree 44 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | |
| 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) | ||||
| 97889 | 97889 | 104310 | Private 5 | Brachychiton populneus :: Bottle Tree 329 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x5 | 6004798.0 | 2102451.0 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | |||
| 97877 | 97877 | 121418 | Private 5 | Juniperus californica :: California juniper 226 | 521 Lakeview Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 5996348.0 | 2089857.0 | 37.718140121256106 | -122.45462104638399 | (37.7181401212561, -122.454621046384) | ||||
| 97551 | 97551 | 80517 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 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) | |||||
| 97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
| 97007 | 97007 | 117070 | Private 5 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010444.0 | 2098901.0 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | |||||
| 95325 | 95325 | 111308 | Private 5 | Pinus radiata :: Monterey Pine 3 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x90 | 6015099.0 | 2088640.0 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | ||||
| 94668 | 94668 | 80514 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 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) | ||||
| 94178 | 94178 | 22382 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) |
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");