trees
167 rows where qLegalStatus_id = 9 and qSiteInfo = "Sidewalk: Curb side : Cutout" sorted by Supervisor Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6273 | 173900 | Private 9 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 12542 | 262149 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4600 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | |||||||||||||
| 9465 | 260400 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
| 10283 | 264747 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
| 11239 | 260905 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2211 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007589.07412 | 2119959.01259 | 37.8014316343257 | -122.417898047397 | (37.8014316343257, -122.417898047397) | 5 | 1 | 1 | 28858 | 32 | ||
| 12190 | 260906 | Private 9 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2215 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2019 12:00:00 AM | 3 | 2X3 | 6007586.25473 | 2119982.21322 | 37.8014951787433 | -122.417909449339 | (37.8014951787433, -122.417909449339) | 5 | 1 | 1 | 28858 | 32 | ||
| 13028 | 264748 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
| 15771 | 259520 | Private 9 | :: 45 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
| 18444 | 259521 | Private 9 | :: 45 | 190 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
| 18526 | 250107 | Private 9 | Tree(s) :: 17 | 1688 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005911.45005 | 2115583.38163 | 37.7893226981327 | -122.423392144226 | (37.7893226981327, -122.423392144226) | 13 | 9 | 1 | 28858 | 41 | |||
| 18936 | 260399 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 190 Parker Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2019 12:00:00 AM | 3 | 5996965.93026 | 2113053.17261 | 37.7818664738231 | -122.454159603161 | (37.7818664738231, -122.454159603161) | 11 | 6 | 1 | 54 | 31 | |||
| 99316 | 108440 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 105 Lake St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5995179.45913 | 2114890.0759 | 37.7868075137311 | -122.460473064302 | (37.7868075137311, -122.460473064302) | 11 | 6 | 1 | 54 | 11 | ||||
| 149976 | 104650 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 346 LAKE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.463222305141 | (37.7868637456835, -122.463222305141) | 11 | 6 | 1 | 54 | 11 | ||||
| 33729 | 109829 | Private 9 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||
| 5914 | 254656 | Private 9 | :: 45 | 640 Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004524 | 2112776 | 37.781535924842 | -122.427992425483 | (37.781535924842, -122.427992425483) | 7 | 9 | 11 | 29490 | 41 | ||||
| 10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
| 10609 | 262014 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
| 10772 | 264676 | Private 9 | Cassia leptophylla :: Gold Medallion Tree 152 | 668 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | 3x3 | 6003797.75621 | 2110080.31484 | 37.7740931268852 | -122.430312496695 | (37.7740931268852, -122.430312496695) | 7 | 9 | 11 | 29492 | 10 | ||
| 12794 | 262012 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
| 12902 | 262013 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
| 17012 | 262011 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
| 35396 | 104626 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6X5 | 6001285 | 2108936 | 37.7708084746611 | -122.438922516011 | (37.7708084746611, -122.438922516011) | 15 | 5 | 11 | 29492 | 9 | |||
| 41193 | 16883 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 47945 | 16888 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 57138 | 104401 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 727 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999017 | 2108166 | 37.768564950056 | -122.44671213341 | (37.768564950056, -122.44671213341) | 15 | 5 | 11 | 29492 | 9 | ||||
| 68363 | 16887 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 69117 | 16884 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 88394 | 39627 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
| 96093 | 39626 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 1550 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | ||
| 106383 | 122643 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 108163 | 104358 | Private 9 | Maytenus boaria :: Mayten 58 | 745X GOLDEN GATE AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3 | 6005986 | 2112447 | 37.7807151749226 | -122.422911209833 | (37.7807151749226, -122.422911209833) | 7 | 9 | 11 | 28852 | 41 | ||||
| 126097 | 39629 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
| 132854 | 25212 | Private 9 | Lophostemon confertus :: Brisbane Box 11 | 215X Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6006420.22763 | 2110742.05634 | 37.7760583047566 | -122.421287897592 | (37.7760583047566, -122.421287897592) | 7 | 9 | 11 | 28852 | 10 | |||
| 133992 | 16886 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 136268 | 122644 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 144187 | 16882 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 165107 | 104627 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 49 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5X5 | 6001306 | 2108720 | 37.7702165872443 | -122.438834395611 | (37.7702165872443, -122.438834395611) | 15 | 5 | 11 | 29492 | 9 | |||
| 166399 | 39628 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 | |
| 172318 | 122641 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 176217 | 122642 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 176299 | 104400 | Private 9 | Maytenus boaria :: Mayten 58 | 755 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5999044 | 2107976 | 37.768044800389 | -122.446605071221 | (37.768044800389, -122.446605071221) | 15 | 5 | 11 | 29492 | 9 | ||||
| 184134 | 16885 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
| 192405 | 238576 | Private 9 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 782890 | 6004764 | 2108902 | 37.7709124438039 | -122.42688615445 | (37.7709124438039, -122.42688615445) | 7 | 9 | 11 | 28852 | 10 | |
| 194402 | 265049 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 5x5 | 5999367.57953 | 2109424.62482 | 37.7720408355473 | -122.445590032014 | (37.7720408355473, -122.445590032014) | 15 | 5 | 11 | 29492 | 9 | ||
| 194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
| 194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
| 60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
| 8224 | 254835 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 250 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2019 12:00:00 AM | 3 | 4x3 | Permit Number 784635 | 5989365 | 2113673 | 37.7831295589045 | -122.480500378386 | (37.7831295589045, -122.480500378386) | 11 | 6 | 2 | 55 | 26 |
| 8242 | 264706 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 17698 | 264705 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 17787 | 264681 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 840 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Permit Number 785486 | 5982954.56765 | 2110060.16253 | 37.7728351334222 | -122.502410039067 | (37.7728351334222, -122.502410039067) | 11 | 6 | 2 | 55 | 26 | ||
| 23696 | 108446 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 672 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773773 | 5994431.81479 | 2110948.53978 | 37.7759420777365 | -122.462773673163 | (37.7759420777365, -122.462773673163) | 11 | 6 | 2 | 54 | 11 | |||
| 65512 | 108459 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 771 11th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773786 | 5992558.08669 | 2110211.94426 | 37.7738114893979 | -122.469201704334 | (37.7738114893979, -122.469201704334) | 11 | 6 | 2 | 54 | 11 | |||
| 85052 | 258602 | Private 9 | :: 45 | 682 12th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/29/2019 12:00:00 AM | 3 | 8X4 | 5992266.47414 | 2110804.58144 | 37.7754218561197 | -122.470253595146 | (37.7754218561197, -122.470253595146) | 11 | 6 | 2 | 54 | 11 | ||
| 141599 | 251417 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5990003 | 2112517 | 37.7799925618685 | -122.478208632121 | (37.7799925618685, -122.478208632121) | 11 | 6 | 2 | 55 | 26 | ||||
| 170397 | 36938 | Private 9 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.823439 | 37.781712581861 | -122.469786951776 | (37.781712581861, -122.469786951776) | 11 | 6 | 2 | 54 | 11 | |
| 190320 | 72375 | Private 9 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.477688796337 | (37.773031079694, -122.477688796337) | 11 | 6 | 2 | 55 | 26 | |
| 4850 | 262150 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 6683 | 262152 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 18909 | 262153 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
| 16285 | 114961 | Private 9 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
| 193685 | 104552 | Private 9 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 5997447 | 2102183 | 37.7520473310587 | -122.451710958005 | (37.7520473310587, -122.451710958005) | 1 | 5 | 4 | 63 | 38 | |||
| 893 | 226590 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784594 | 6001099.54842 | 2099653.23365 | 37.7453097044788 | -122.438898660558 | (37.7453097044788, -122.438898660558) | 2 | 4 | 5 | 63 | 22 |
| 3984 | 243570 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 837 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 3 | 3x3 | Permit Number 784594 | 6001117.2647 | 2099653.19311 | 37.7453106011164 | -122.438837397829 | (37.7453106011164, -122.438837397829) | 2 | 4 | 5 | 63 | 22 | |
| 8510 | 259163 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 9208 | 259164 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 16349 | 259165 | Private 9 | Shrub :: Shrub 66 | 1 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001019 | 2105729 | 37.7619877090771 | -122.439612669611 | (37.7619877090771, -122.439612669611) | 15 | 5 | 5 | 28862 | 3 | ||||
| 83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
| 97720 | 104310 | Private 9 | Brachychiton populneus :: Bottle Tree 348 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | |||
| 107120 | 121090 | Private 9 | Pinus radiata :: Monterey Pine 15 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 112431 | 104768 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 912 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002431.1 | 2102873.8 | 37.7542282864134 | -122.434524613527 | (37.7542282864134, -122.434524613527) | 2 | 4 | 5 | 28862 | 22 | |||
| 122325 | 104309 | Private 9 | Myoporum laetum :: Myoporum 62 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6004798 | 2102451 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | 2 | 4 | 5 | 28862 | 22 | ||||
| 156160 | 108314 | Private 9 | Corymbia ficifolia :: Red Flowering Gum 28 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002141 | 2097265 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | 2 | 7 | 5 | 63 | 7 | ||||
| 168048 | 122898 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6006160 | 2102149 | 37.7524491239798 | -122.421577653162 | (37.7524491239798, -122.421577653162) | 2 | 4 | 5 | 28859 | 19 | |||
| 181524 | 121089 | Private 9 | Eucalyptus globulus :: Blue Gum 56 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000227 | 2103854 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | 2 | 4 | 5 | 28862 | 38 | ||||
| 186484 | 109125 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
| 3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
| 11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 11394 | 260246 | Private 9 | Magnolia spp :: Magnolia 224 | 568 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784595 | 5998297.39121 | 2088148.96817 | 37.7135618752392 | -122.447759972312 | (37.7135618752392, -122.447759972312) | 9 | 7 | 6 | 28861 | 25 | |
| 12761 | 261857 | Private 9 | Pistacia chinensis :: Chinese Pistache 32 | 176 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2020 12:00:00 AM | 3 | 5992988.80812 | 2088380.73889 | 37.7138934199028 | -122.466125014283 | (37.7138934199028, -122.466125014283) | 9 | 8 | 6 | 64 | 24 | |||
| 14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
| 15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 119423 | 114977 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | 9 | 8 | 6 | 28861 | 24 | |||
| 14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
| 34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 44862 | 114642 | Private 9 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163197 | -122.407019863158 | (37.745978163197, -122.407019863158) | 2 | 7 | 7 | 28859 | 2 | |||
| 64208 | 71505 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 328 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774557 | 6006691.32680411 | 2104197.11487977 | 37.7581027211657 | -122.419885554796 | (37.7581027211657, -122.419885554796) | 2 | 4 | 7 | 28859 | 19 | |
| 68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 80106 | 114666 | Private 9 | Podocarpus gracilor :: Fern Pine 51 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.417426639907 | (37.7355258779344, -122.417426639907) | 2 | 7 | 7 | 28859 | 2 | |||
| 91676 | 104449 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 108854 | 104446 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );