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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 19281 | 19281 | 114961 | Private 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.45011626136801 | (37.7429206264442, -122.450116261368) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 82462 | 82462 | 114642 | Private 5 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163196995 | -122.407019863158 | (37.745978163197, -122.407019863158) | |||
| 93096 | 93096 | 114666 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.41742663990699 | (37.7355258779344, -122.417426639907) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 4630 | 4630 | 25362 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 974 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780532 | 6000558.35356 | 2088917.09573 | 37.7157999479938 | -122.440000340863 | (37.7157999479938, -122.440000340863) | |
| 4061 | 4061 | 252970 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/05/2017 12:21:00 PM | 3 | ||||||||
| 4066 | 4066 | 252966 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:19:00 PM | 3 | 5998135.7809 | 2087327.97675 | 37.7112983819328 | -122.448259470506 | (37.7112983819328, -122.448259470506) | |||
| 4012 | 4012 | 252965 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:04:00 PM | 3 | ||||||||
| 4074 | 4074 | 252967 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:55:00 PM | 3 | 5998144.81293 | 2087318.48212 | 37.7112728281964 | -122.448227570418 | (37.7112728281964, -122.448227570418) | |||
| 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) | ||
| 15764 | 15764 | 80467 | Private 5 | Alnus cordata :: Italian Alder 294 | 1780 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 10 | 6013451.73876 | 2092852.71308 | 37.727331923129896 | -122.395710120444 | (37.7273319231299, -122.395710120444) | |||
| 88690 | 88690 | 80520 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 2 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 90903 | 90903 | 80593 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 7 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 2640 | 2640 | 183247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2890 Rivera St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984262.8939 | 2100232.1038 | 37.7459268239815 | -122.49715885534201 | (37.7459268239815, -122.497158855342) | |
| 2648 | 2648 | 183237 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984780.1717 | 2100543.2827 | 37.7468115375468 | -122.495393151852 | (37.7468115375468, -122.495393151852) | |
| 2656 | 2656 | 183240 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984790.3243 | 2100348.3517 | 37.7462769046122 | -122.495343672098 | (37.7462769046122, -122.495343672098) | |
| 2668 | 2668 | 183245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2706 Rivera St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984600.1313 | 2100244.4562 | 37.745980498085295 | -122.495993663284 | (37.7459804980853, -122.495993663284) | |
| 2672 | 2672 | 183250 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2107 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984200.2859 | 2100804.8827 | 37.7474958486327 | -122.497417620086 | (37.7474958486327, -122.497417620086) | |
| 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) |
| 5058 | 5058 | 3648 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | ||
| 5065 | 5065 | 3592 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018357.04475 | 2097955.64275 | 37.741615217581796 | -122.379106567936 | (37.7416152175818, -122.379106567936) | ||
| 22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
| 22347 | 22347 | 3647 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.38237892474599 | (37.7435463281955, -122.382378924746) | ||
| 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) | |
| 16217 | 16217 | 22383 | Private 5 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1799X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 2 | 4x15 | 6013476.602999999 | 2093118.78047 | 37.7280638732384 | -122.39564279807301 | (37.7280638732384, -122.395642798073) | ||
| 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) | ||
| 4973 | 4973 | 3631 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:27:00 PM | 3 | 3X3 | 6017682.09522 | 2098458.88711 | 37.7429597849556 | -122.381475327351 | (37.7429597849556, -122.381475327351) | ||
| 4994 | 4994 | 3624 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:25:00 PM | 3 | 3X3 | 6017797.96297 | 2098371.7943700003 | 37.742727042232396 | -122.38106863050601 | (37.7427270422324, -122.381068630506) | ||
| 1079 | 1079 | 3621 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:22:00 PM | 3 | 3X3 | 6017849.66978 | 2098333.64293 | 37.7426251400454 | -122.380887189608 | (37.7426251400454, -122.380887189608) | ||
| 1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
| 4945 | 4945 | 3600 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:14:00 PM | 3 | 3X3 | 6018222.967130001 | 2098056.59418 | 37.7418850159701 | -122.379577179554 | (37.7418850159701, -122.379577179554) | ||
| 5063 | 5063 | 3598 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:10:00 PM | 3 | 3X3 | 6018255.028469999 | 2098031.9569200003 | 37.7418191352571 | -122.37946460960501 | (37.7418191352571, -122.379464609605) | ||
| 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) | |
| 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) | |
| 4950 | 4950 | 3646 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:16:00 AM | 3 | 3X3 | 6017441.11571 | 2098662.50366 | 37.7435055673357 | -122.38232273959999 | (37.7435055673357, -122.3823227396) | ||
| 5023 | 5023 | 3601 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:11:00 AM | 3 | 3X3 | 6018206.00756 | 2098069.0742900004 | 37.7419183484432 | -122.379636687689 | (37.7419183484432, -122.379636687689) | ||
| 5014 | 5014 | 3588 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:07:00 AM | 3 | 3X3 | 6018423.14615 | 2097904.9005 | 37.7414795341434 | -122.37887448618 | (37.7414795341434, -122.37887448618) | ||
| 5038 | 5038 | 83035 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:50:00 AM | 3 | 6018541.89406 | 2097818.9676900003 | 37.741250126083706 | -122.37845792741501 | (37.7412501260837, -122.378457927415) | |||
| 4985 | 4985 | 83041 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.74089078129229 | -122.377824564564 | (37.7408907812923, -122.377824564564) | |||
| 4989 | 4989 | 83048 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.37739803950001 | (37.7406452501696, -122.3773980395) | |||
| 23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 4980 | 4980 | 83034 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:59:00 PM | 3 | 6018525.50747 | 2097831.43609 | 37.7412834585567 | -122.37851545254298 | (37.7412834585567, -122.378515452543) | |||
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 4998 | 4998 | 83042 | Private 5 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | |||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 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) | |
| 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) | |
| 22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
| 22338 | 22338 | 3608 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | ||
| 22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
| 22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
| 22350 | 22350 | 3645 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.38226603915399 | (37.7434680683118, -122.382266039154) | ||
| 13709 | 13709 | 115878 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1125X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6014969.9373 | 2096433.719 | 37.737248978447 | -122.390711808999 | (37.737248978447, -122.390711808999) | ||
| 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) | |
| 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) | ||
| 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) | |
| 4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
| 5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) |
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");