Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 189120 | 189120 | 98169 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 19 | 3x3 | Permit Number 775039 | 6000613.54695 | 2116154.22533 | 37.7905896504327 | -122.44176320452299 | (37.7905896504327, -122.441763204523) | |
| 189115 | 189115 | 53052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.258169999 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | |
| 189103 | 189103 | 96941 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | ||||
| 189095 | 189095 | 83407 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 745 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52540 | 6007021.2303 | 2113557.8449 | 37.783823644044794 | -122.419408670548 | (37.7838236440448, -122.419408670548) | |
| 189091 | 189091 | 111384 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 340 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x5 | 6014593.215419999 | 2112428.75748 | 37.7811469919725 | -122.393133189548 | (37.7811469919725, -122.393133189548) | |||
| 189088 | 189088 | 92444 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2643 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52835 | 5982411.0946 | 2097116.4843 | 37.737263493476 | -122.503331364341 | (37.737263493476, -122.503331364341) |
| 189063 | 189063 | 62705 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 1279 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 16 | Permit Number 23045 | 6006870.41308 | 2119076.22609 | 37.7989672544017 | -122.420322248197 | (37.7989672544017, -122.420322248197) | |
| 189048 | 189048 | 95921 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 275 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767619 | 5988991.254980001 | 2113497.8107 | 37.782626811071296 | -122.48178053312701 | (37.7826268110713, -122.481780533127) |
| 189039 | 189039 | 117389 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1650 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6006295.544430001 | 2117317.5523599996 | 37.7941059690696 | -122.42218647533998 | (37.7941059690696, -122.42218647534) | |||
| 189032 | 189032 | 30841 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2586 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1995 12:00:00 AM | 22 | Permit Number 34689 | 6002395.11591 | 2116122.86039 | 37.790604880464294 | -122.43559684281799 | (37.7906048804643, -122.435596842818) | ||
| 189028 | 189028 | 79350 | Permitted Site 1 | Dodonaea viscosa :: Hop Bush 132 | 1946 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767118 | 5983237.8759 | 2101878.6369 | 37.750387624519796 | -122.500824911735 | (37.7503876245198, -122.500824911735) |
| 189022 | 189022 | 43336 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 423 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 6 | Permit Number 43093 | 6003416.5357 | 2091104.1943299999 | 37.7219675345615 | -122.430277093028 | (37.7219675345615, -122.430277093028) | |
| 188985 | 188985 | 34804 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 122 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 4 | Permit Number 38440 | 5999160.28006 | 2089153.53909 | 37.716369479631204 | -122.444849697578 | (37.7163694796312, -122.444849697578) | |
| 188971 | 188971 | 55570 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 81 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/1973 12:00:00 AM | 5 | Permit Number 49713 | 5996815.9739 | 2114044.1129 | 37.7845787332894 | -122.45474999571998 | (37.7845787332894, -122.45474999572) | ||
| 188956 | 188956 | 45565 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3561 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 6 | Permit Number 44309 | 5997197.65372 | 2116007.3067900003 | 37.789991026609705 | -122.45357132096001 | (37.7899910266097, -122.45357132096) | |
| 188948 | 188948 | 84503 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50134 | 6011610.65584 | 2112713.99225 | 37.7817640420151 | -122.403471492712 | (37.7817640420151, -122.403471492712) | |
| 188945 | 188945 | 69003 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2063 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 5 | Permit Number 33004 | 5982592.2747 | 2101083.7423 | 37.7481671399171 | -122.502998568536 | (37.7481671399171, -122.502998568536) | |
| 188927 | 188927 | 114320 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007916.32551 | 2113778.66148 | 37.7844803264499 | -122.41632761162901 | (37.7844803264499, -122.416327611629) | |||
| 188913 | 188913 | 34598 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3200 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38292 | 5999298.828509999 | 2116018.40828 | 37.7901417341159 | -122.446302262734 | (37.7901417341159, -122.446302262734) | |
| 188888 | 188888 | 97767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 375 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | 2x2 | Permit Number 768293 | 5997562.8708 | 2113817.3703 | 37.783998971375 | -122.452149632238 | (37.783998971375, -122.452149632238) | |
| 188880 | 188880 | 38814 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 286 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51147 | 5995268.26088 | 2113665.38834 | 37.7834499595789 | -122.460077076847 | (37.7834499595789, -122.460077076847) | |
| 188875 | 188875 | 30367 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 674 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 23 | Permit Number 55 | 6012983.3674 | 2103955.4994099997 | 37.7577917638944 | -122.398107878472 | (37.7577917638944, -122.398107878472) | ||
| 188872 | 188872 | 113547 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | ||
| 188856 | 188856 | 67711 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 522 02nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 5 | Permit Number 31322 | 6014581.76234 | 2112965.60005 | 37.7826204034479 | -122.393210388247 | (37.7826204034479, -122.393210388247) | |
| 188854 | 188854 | 65488 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 839 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | 9 | Permit Number 28372 | 6008695.768130001 | 2115475.78771 | 37.7891840235769 | -122.413751082752 | (37.7891840235769, -122.413751082752) | |
| 188841 | 188841 | 68350 | Permitted Site 1 | Taxus baccata :: Irish Yew 241 | 535 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32169 | 5989368.29935 | 2111675.70215 | 37.7776457288828 | -122.48034272561002 | (37.7776457288828, -122.48034272561) | |
| 188838 | 188838 | 41630 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.77425303017571 | -122.400029064208 | (37.7742530301757, -122.400029064208) | ||
| 188834 | 188834 | 42140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 646 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 4 | Permit Number 45847 | 5991316.63664 | 2111003.25845 | 37.7759124087321 | -122.47355376984699 | (37.7759124087321, -122.473553769847) | |
| 188831 | 188831 | 43099 | Permitted Site 1 | Grevillea robusta :: Silk Oak Tree 145 | 525 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 14 | Permit Number 42930 | 6008375.85912 | 2114299.60032 | 37.785936528505296 | -122.414774657831 | (37.7859365285053, -122.414774657831) | |
| 188811 | 188811 | 91463 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1001 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52106 | 6008009.62404 | 2119930.75783 | 37.8013777126716 | -122.416440749956 | (37.8013777126716, -122.416440749956) | |
| 188810 | 188810 | 48419 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45797 | 6002578.00127 | 2118175.76067 | 37.796252000589796 | -122.435110962497 | (37.7962520005898, -122.435110962497) | ||
| 188783 | 188783 | 32099 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 145 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | 5 | Permit Number 35472 | 6002693.24586 | 2105078.2929700003 | 37.7602961734608 | -122.433775601482 | (37.7602961734608, -122.433775601482) | |
| 188768 | 188768 | 52696 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1825@ BAKER McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2006 12:00:00 AM | 1 | Permit Number 48763 | 6000364.5723 | 2111291.0627 | 37.777222470367 | -122.44227537661502 | (37.777222470367, -122.442275376615) | |
| 188762 | 188762 | 65630 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2510 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 8 | Permit Number 28538 | 6001388.347 | 2114610.3564 | 37.7863947012265 | -122.43897175770701 | (37.7863947012265, -122.438971757707) | |
| 188756 | 188756 | 51034 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.77258561335729 | -122.409837753032 | (37.7725856133573, -122.409837753032) | |
| 188750 | 188750 | 31037 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 722 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34796 | 6002553.27762 | 2087290.2882 | 37.7114464558494 | -122.43298880977899 | (37.7114464558494, -122.432988809779) | |
| 188745 | 188745 | 49797 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1145 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 13 | 3x3 | Permit Number 46589 | 6008423.5727699995 | 2115887.46945 | 37.7902991118549 | -122.41472199441999 | (37.7902991118549, -122.41472199442) |
| 188732 | 188732 | 57631 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.6183599997 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | |
| 188729 | 188729 | 88433 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 484 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51378 | 5993148.8705 | 2112173.6098700003 | 37.7792318146847 | -122.46730077142901 | (37.7792318146847, -122.467300771429) | |
| 188719 | 188719 | 53084 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | ||
| 188712 | 188712 | 69011 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2154 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 10 | Permit Number 33014 | 5982348.1034 | 2100442.2638 | 37.7463914641075 | -122.50379538901001 | (37.7463914641075, -122.50379538901) | |
| 188706 | 188706 | 98034 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1817 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768344 | 5999961.07212 | 2115342.88884 | 37.788324733938396 | -122.44396240304899 | (37.7883247339384, -122.443962403049) | |
| 188703 | 188703 | 65525 | Permitted Site 1 | Melaleuca styphelliodes :: Paperbark Tree 239 | 731 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 19 | Permit Number 28412 | 6001332.96165 | 2089313.5422200002 | 37.7169325676664 | -122.43735131400801 | (37.7169325676664, -122.437351314008) | |
| 188696 | 188696 | 47494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 219 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 13 | Permit Number 45387 | 6001679.50677 | 2093822.21478 | 37.729332060307996 | -122.43647599576799 | (37.729332060308, -122.436475995768) | |
| 188691 | 188691 | 60492 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1215 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1982 12:00:00 AM | 16 | Permit Number 20090 | 6005025.8027 | 2113323.9775 | 37.783068912088 | -122.42629545390699 | (37.783068912088, -122.426295453907) | ||
| 188689 | 188689 | 41258 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | 4 | Permit Number 41947 | 6012985.5179 | 2116864.57793 | 37.793237278822204 | -122.399006496356 | (37.7932372788222, -122.399006496356) | ||
| 188687 | 188687 | 68019 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 2927 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 7 | Permit Number 31750 | 6000097.9398 | 2116409.89837 | 37.7912622695816 | -122.443565543936 | (37.7912622695816, -122.443565543936) | ||
| 188671 | 188671 | 47787 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | ||
| 188652 | 188652 | 32989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.3325900002 | 37.784324082736795 | -122.398422883105 | (37.7843240827368, -122.398422883105) | |
| 188641 | 188641 | 62171 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 58 Rudden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/1985 12:00:00 AM | 12 | Permit Number 22287 | 6000147.44249 | 2092048.11299 | 37.7243736086455 | -122.441645199974 | (37.7243736086455, -122.441645199974) | |
| 188626 | 188626 | 38656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2525 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1998 12:00:00 AM | 7 | Permit Number 40577 | 6002175.87869 | 2116963.69117 | 37.7929011302226 | -122.436415594627 | (37.7929011302226, -122.436415594627) | ||
| 188625 | 188625 | 96283 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3229 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58766 | 6011911.44714 | 2090686.2999099998 | 37.721297592691 | -122.40088279510599 | (37.721297592691, -122.400882795106) | |
| 188617 | 188617 | 58966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 205 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1980 12:00:00 AM | 15 | Permit Number 18248 | 5994892.071719999 | 2114155.06341 | 37.78477283129121 | -122.46141404577801 | (37.7847728312912, -122.461414045778) | ||
| 188615 | 188615 | 61889 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.75805900104321 | -122.48219149098301 | (37.7580590010432, -122.482191490983) | |
| 188601 | 188601 | 37092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | |
| 188597 | 188597 | 63627 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 67 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1987 12:00:00 AM | 4 | Permit Number 24270 | 6007827.91665 | 2093727.62728 | 37.7294198035797 | -122.415213626819 | (37.7294198035797, -122.415213626819) | ||
| 188588 | 188588 | 31462 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 682 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35028 | 6001206.44142 | 2102402.15102 | 37.7528636562457 | -122.438725984431 | (37.7528636562457, -122.438725984431) | |
| 188562 | 188562 | 53797 | Permitted Site 1 | Tree(s) :: 17 | 1718 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 0 | Permit Number 9489 | 5983493.18755195 | 2103436.99678987 | 37.7546814335819 | -122.500057225325 | (37.7546814335819, -122.500057225325) | ||
| 188546 | 188546 | 52085 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2672 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2005 12:00:00 AM | 6 | Permit Number 48282 | 6000189.160080001 | 2118535.00366 | 37.7971024507605 | -122.443402636239 | (37.7971024507605, -122.443402636239) | ||
| 188543 | 188543 | 99627 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2389 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2012 12:00:00 AM | 4 | 6x10 | Permit Number 768863 | 6003328.26592 | 2116532.46568 | 37.7917825084999 | -122.432397466871 | (37.7917825084999, -122.432397466871) | |
| 188533 | 188533 | 45059 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 0 | Permit Number 43944 | 5988289.16857731 | 2099339.5667467 | 37.743711287686295 | -122.483171307647 | (37.7437112876863, -122.483171307647) | |
| 188531 | 188531 | 67581 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.3695799997 | 37.7622066365616 | -122.39736679306999 | (37.7622066365616, -122.39736679307) | |
| 188525 | 188525 | 31337 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 745 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 16 | 6x18 | Permit Number 34951 | 6004453.62375 | 2111092.9915400003 | 37.7769108173179 | -122.42811591873699 | (37.7769108173179, -122.428115918737) | |
| 188508 | 188508 | 65025 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2826 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1989 12:00:00 AM | 16 | Permit Number 26076 | 6004809.703480001 | 2119306.48905 | 37.7994831621734 | -122.427469404204 | (37.7994831621734, -122.427469404204) | |
| 188506 | 188506 | 84809 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 648 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | 3 | Permit No. 49264 | 5987557.75332 | 2111531.90689 | 37.7771455293989 | -122.486595377302 | (37.7771455293989, -122.486595377302) | ||
| 188503 | 188503 | 106738 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1645 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773198 | 6006290.51922 | 2117597.30119 | 37.7948738057383 | -122.42222374772301 | (37.7948738057383, -122.422223747723) | |
| 188480 | 188480 | 65600 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 18 | 9x4.5 | Permit Number 28502 | 6003805.36917 | 2093762.79554 | 37.7292894792277 | -122.429122461528 | (37.7292894792277, -122.429122461528) |
| 188463 | 188463 | 31442 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4052 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 5 | Permit Number 35017 | 6002805.98391 | 2102425.30208 | 37.7530180914283 | -122.433196128705 | (37.7530180914283, -122.433196128705) | |
| 188444 | 188444 | 65032 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2083 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1989 12:00:00 AM | 6 | Permit Number 26084 | 6003066.871 | 2118544.6048 | 37.7972924986266 | -122.43344574542 | (37.7972924986266, -122.43344574542) | ||
| 188439 | 188439 | 48708 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 6 | Permit Number 45976 | 6014000.73763 | 2115276.8947099997 | 37.7889343906698 | -122.39538246774599 | (37.7889343906698, -122.395382467746) | ||
| 188428 | 188428 | 38099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1261 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46959 | 5987676.3129 | 2106697.6607 | 37.7638789444346 | -122.485830340707 | (37.7638789444346, -122.485830340707) | |
| 188427 | 188427 | 58957 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 573 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1993 12:00:00 AM | 7 | Permit Number 32270 | 5994672.72826 | 2111619.94034 | 37.777799437364294 | -122.461988995399 | (37.7777994373643, -122.461988995399) | ||
| 188421 | 188421 | 61257 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 9 | Permit Number 30068 | 6007758.72791 | 2118741.72508 | 37.798098814159104 | -122.417224659311 | (37.7980988141591, -122.417224659311) | |
| 188413 | 188413 | 30789 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 16 | Permit Number 34660 | 6013423.92968 | 2112089.08407 | 37.7801493011857 | -122.39715453954399 | (37.7801493011857, -122.397154539544) | |
| 188402 | 188402 | 62595 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 747 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 10 | Permit Number 22901 | 5984435.27123 | 2110757.77903 | 37.77483748027421 | -122.497339702401 | (37.7748374802742, -122.497339702401) | |
| 188390 | 188390 | 103890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999343.5617 | 2110855.9257 | 37.7759694515949 | -122.445776064165 | (37.7759694515949, -122.445776064165) | |||
| 188384 | 188384 | 62412 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 649 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1986 12:00:00 AM | 11 | Permit Number 22724 | 5991603.29302 | 2111002.0024200003 | 37.7759255565205 | -122.472562069305 | (37.7759255565205, -122.472562069305) | ||
| 188373 | 188373 | 32498 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 676 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 9 | Permit Number 37003 | 6007391.76195 | 2095838.15833 | 37.73519034034379 | -122.41687092807301 | (37.7351903403438, -122.416870928073) | |
| 188343 | 188343 | 113059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2015 12:00:00 AM | 5 | 3x3 | Permit Number 776016 | 6000289.21565 | 2117461.28412 | 37.7941600057183 | -122.44297927319599 | (37.7941600057183, -122.442979273196) | |
| 188325 | 188325 | 53288 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2665 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1969 12:00:00 AM | 14 | Permit Number 6178 | 6005269.09098 | 2119170.43565 | 37.799135566117 | -122.425870068752 | (37.799135566117, -122.425870068752) | ||
| 188317 | 188317 | 81230 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1615 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2005 12:00:00 AM | 2 | 3x3 | Permit Number 49855 | 5989003.1653 | 2104324.8882 | 37.757441181357 | -122.48106746320101 | (37.757441181357, -122.481067463201) | |
| 188314 | 188314 | 56091 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 764 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1973 12:00:00 AM | 14 | Permit Number 12189 | 5981386.79293 | 2110532.60366 | 37.77404007412879 | -122.50786812371099 | (37.7740400741288, -122.507868123711) | ||
| 188313 | 188313 | 49817 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1226 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46608 | 6012208.775640001 | 2102677.6526599997 | 37.7542399031726 | -122.400696986204 | (37.7542399031726, -122.400696986204) |
| 188310 | 188310 | 35816 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 448 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43043 | 6010644.99759 | 2092590.80492 | 37.7264562451386 | -122.405394631775 | (37.7264562451386, -122.405394631775) | |
| 188305 | 188305 | 45567 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 5 | Permit Number 772596 | 5998102.08454 | 2115576.16187 | 37.788859022076295 | -122.45041098909401 | (37.7888590220763, -122.450410989094) | ||
| 188284 | 188284 | 38434 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | 5 | Permit Number 40461 | 6004032.02879 | 2117927.41778 | 37.7956525718497 | -122.43006200398199 | (37.7956525718497, -122.430062003982) | ||
| 188282 | 188282 | 44019 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007852.239130001 | 2112732.3547 | 37.7816038169983 | -122.416475189498 | (37.7816038169983, -122.416475189498) | ||
| 188271 | 188271 | 84647 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 634 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50081 | 5987554.32773 | 2111613.48412 | 37.777369317795205 | -122.48661321871 | (37.7773693177952, -122.48661321871) | |
| 188262 | 188262 | 32743 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.198890001 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) |
| 188242 | 188242 | 45071 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1028 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | 18 | Permit Number 43951 | 6010361.137619999 | 2111881.87885 | 37.7794093830802 | -122.407735568851 | (37.7794093830802, -122.407735568851) | ||
| 188234 | 188234 | 54841 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50287 | 5998779.2598 | 2109863.0763 | 37.7732111059754 | -122.447656635795 | (37.7732111059754, -122.447656635795) | |
| 188192 | 188192 | 114813 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315-- 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | |||
| 188183 | 188183 | 45080 | Permitted Site 1 | Cupaniopsis anacardioides :: Carrotwood 118 | 2131 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43963 | 5987257.3685 | 2100779.0687 | 37.747603677476796 | -122.486844665894 | (37.7476036774768, -122.486844665894) | |
| 188177 | 188177 | 45068 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 2227 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 4 | Permit Number 43949 | 5987902.9352 | 2100130.6194 | 37.7458608246267 | -122.48456480540001 | (37.7458608246267, -122.4845648054) | |
| 188154 | 188154 | 50352 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.8145 | 2111260.62712 | 37.7760557428917 | -122.506939675333 | (37.7760557428917, -122.506939675333) | ||
| 188151 | 188151 | 61354 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 149 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 9 | Permit Number 21261 | 5989891.03907 | 2114361.27141 | 37.7850499161242 | -122.47873086950399 | (37.7850499161242, -122.478730869504) | |
| 188149 | 188149 | 69118 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2165 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1994 12:00:00 AM | 15 | Permit Number 33135 | 5990058.1358 | 2100634.1785 | 37.7473687383221 | -122.477149295728 | (37.7473687383221, -122.477149295728) | ||
| 188137 | 188137 | 46822 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 571 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | 7 | Permit Number 44900 | 6003370.246180001 | 2090017.12379 | 37.7189800568605 | -122.430359583339 | (37.7189800568605, -122.430359583339) | |
| 188131 | 188131 | 39237 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 6 | Permit Number 40872 | 6007370.26248 | 2112668.82776 | 37.781402270828295 | -122.418138097991 | (37.7814022708283, -122.418138097991) |
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");