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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189126 | 189126 | 84279 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6016131.0603 | 2093656.105 | 37.7296865592841 | -122.386503619825 | (37.7296865592841, -122.386503619825) | ||
| 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) | |
| 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) |
| 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) | |
| 189011 | 189011 | 80586 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985971.2412 | 2102145.8827 | 37.7512815105045 | -122.49139254176599 | (37.7512815105045, -122.491392541766) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 188897 | 188897 | 84120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2006 12:00:00 AM | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 188620 | 188620 | 83763 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 361 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2006 12:00:00 AM | 4 | Permit Number 776681 | 5993691.54318 | 2113064.28499 | 37.781708680288205 | -122.465488178701 | (37.7817086802882, -122.465488178701) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 188440 | 188440 | 72308 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3496 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 15 | 5997591.22599 | 2116109.01981 | 37.7902928570799 | -122.452216943753 | (37.7902928570799, -122.452216943753) | ||
| 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) | |
| 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) | |
| 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) | |
| 188361 | 188361 | 72888 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2506 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | 5989566.1304 | 2098258.2718 | 37.7408165618747 | -122.47867686749201 | (37.7408165618747, -122.478676867492) | ||
| 188342 | 188342 | 70057 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014037.2583099995 | 2095146.8497099997 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | ||
| 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) | |
| 188273 | 188273 | 72327 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2776 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 16 | 5996291.43938 | 2111269.30989 | 37.776929758019904 | -122.456363986751 | (37.7769297580199, -122.456363986751) | ||
| 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) |
| 188198 | 188198 | 79435 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 1 | 6004044.7014 | 2110862.9754 | 37.776256105061606 | -122.429514097991 | (37.7762561050616, -122.429514097991) | ||
| 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) | |
| 188182 | 188182 | 79032 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1475 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/2001 12:00:00 AM | 6 | 6015238.0441 | 2092152.5097 | 37.725508510693295 | -122.38948593447901 | (37.7255085106933, -122.389485934479) | ||
| 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) | |
| 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) | |
| 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) | |
| 188115 | 188115 | 31154 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 259 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34857 | 5998376.74156 | 2093783.98497 | 37.7290388606445 | -122.447891156156 | (37.7290388606445, -122.447891156156) | |
| 188103 | 188103 | 62253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 415 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | 3 | Permit Number 22379 | 6000969.7318400005 | 2092330.5175599998 | 37.7251958434923 | -122.43882289446998 | (37.7251958434923, -122.43882289447) | |
| 188098 | 188098 | 60322 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 390 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1982 12:00:00 AM | 15 | Permit Number 19892 | 5986562.51313 | 2113318.43854 | 37.7819927692214 | -122.490169625577 | (37.7819927692214, -122.490169625577) | |
| 188094 | 188094 | 72435 | Undocumented 2 | Prunus spp :: Cherry 84 | 339 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 5999048.262080001 | 2115432.1499099997 | 37.7885177095774 | -122.447126990534 | (37.7885177095774, -122.447126990534) | ||
| 188086 | 188086 | 65745 | Permitted Site 1 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 242 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1990 12:00:00 AM | 10 | Permit Number 28704 | 6000840.51659 | 2087219.5194400002 | 37.7111548407988 | -122.43890347461 | (37.7111548407988, -122.43890347461) | |
| 188085 | 188085 | 71703 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 530 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1982 12:00:00 AM | 14 | 6005189.8095 | 2111320.4314 | 37.7775769362179 | -122.425585416633 | (37.7775769362179, -122.425585416633) | ||
| 188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
| 188077 | 188077 | 69403 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1220 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33507 | 6001071.30066 | 2087381.77877 | 37.7116134968267 | -122.438117445581 | (37.7116134968267, -122.438117445581) | |
| 188076 | 188076 | 40714 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 634 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2006 12:00:00 AM | 8 | Permit Number 48841 | 5994113.99611 | 2111184.89224 | 37.7765727285077 | -122.463890241988 | (37.7765727285077, -122.463890241988) | |
| 188032 | 188032 | 72515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1996 12:00:00 AM | 6 | 5995895.10246 | 2112445.80394 | 37.7801373389306 | -122.457820182784 | (37.7801373389306, -122.457820182784) | ||
| 188017 | 188017 | 94885 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2010 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53951 | 6013050.0613 | 2096298.0841299999 | 37.736769849332 | -122.39734023878599 | (37.736769849332, -122.397340238786) |
| 188003 | 188003 | 34259 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.46453448944901 | (37.7855927810379, -122.464534489449) | |
| 187987 | 187987 | 67399 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 578 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 10 | Permit Number 30896 | 5990663.42796 | 2111452.2295 | 37.7771073100211 | -122.475846159065 | (37.7771073100211, -122.475846159065) | |
| 187984 | 187984 | 33233 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2616 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 4 | Permit Number 49352 | 5988969.8261 | 2097510.338 | 37.7387282896824 | -122.480683899813 | (37.7387282896824, -122.480683899813) | |
| 187974 | 187974 | 78598 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 535 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | 6008370.91308 | 2114317.1343900003 | 37.785984394913 | -122.41479301119699 | (37.785984394913, -122.414793011197) | ||
| 187950 | 187950 | 45592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1767 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 2 | Permit Number 44328 | 5985625.0375 | 2103206.7223 | 37.754174049116294 | -122.492667858454 | (37.7541740491163, -122.492667858454) | |
| 187936 | 187936 | 38624 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1351 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 8 | Permit Number 40562 | 6016224.1538 | 2093165.8493 | 37.728345567294795 | -122.386147618696 | (37.7283455672948, -122.386147618696) | |
| 187930 | 187930 | 63653 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3400 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | 5 | Permit Number 24300 | 5983704.2368 | 2104292.0530000003 | 37.7570415630367 | -122.49939055504 | (37.7570415630367, -122.49939055504) | |
| 187915 | 187915 | 71780 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 3 | Permit Number 768726 | 6007445.70481 | 2115106.99549 | 37.7881011319113 | -122.41805000311199 | (37.7881011319113, -122.418050003112) | |
| 187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
| 187901 | 187901 | 81053 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.43315238479401 | (37.7167283109449, -122.433152384794) | ||
| 187886 | 187886 | 62312 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 530 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | 16 | Permit Number 22450 | 5994400.4203 | 2111897.3678599996 | 37.778545498008796 | -122.462951128825 | (37.7785454980088, -122.462951128825) | |
| 187880 | 187880 | 83324 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 354 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 4x3 | 5987173.082 | 2113552.1603 | 37.782670140120295 | -122.48807454413901 | (37.7826701401203, -122.488074544139) | ||
| 187844 | 187844 | 64559 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1562 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 12 | Permit Number 25450 | 6000352.3546 | 2110302.164 | 37.774506509156204 | -122.442246634385 | (37.7745065091562, -122.442246634385) | |
| 187827 | 187827 | 60085 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1262 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 13 | Permit Number 19586 | 5988964.5748 | 2106737.2244 | 37.7640625606181 | -122.48137758100401 | (37.7640625606181, -122.481377581004) | |
| 187818 | 187818 | 81723 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 998 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/27/2004 12:00:00 AM | 4 | 6014945.424980001 | 2104137.64024 | 37.7584009709475 | -122.39133494566201 | (37.7584009709475, -122.391334945662) | ||
| 187804 | 187804 | 52942 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 71 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 3 | Permit Number 48929 | 6002252.43026 | 2093269.9255099997 | 37.727848138461 | -122.434455877432 | (37.727848138461, -122.434455877432) | |
| 187774 | 187774 | 47461 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1818 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 6 | Permit Number 45366 | 6000024.694680001 | 2115221.2908900003 | 37.787994486693 | -122.443733540863 | (37.787994486693, -122.443733540863) | |
| 187770 | 187770 | 33945 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2858 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2002 12:00:00 AM | 8 | Permit Number 45901 | 6004794.02705 | 2119422.7642900003 | 37.799801537482296 | -122.42753193854601 | (37.7998015374823, -122.427531938546) | |
| 187715 | 187715 | 83139 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 4 | 6016637.95414 | 2095483.71733 | 37.7347328669128 | -122.38487848967699 | (37.7347328669128, -122.384878489677) | ||
| 187699 | 187699 | 62284 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 11 | Permit Number 22422 | 5996159.215890001 | 2112395.0855799997 | 37.780013249453795 | -122.456902830387 | (37.7800132494538, -122.456902830387) | |
| 187696 | 187696 | 64369 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 522 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | 5 | Permit Number 25208 | 6010359.9072 | 2120301.2434 | 37.8025268636696 | -122.408333834018 | (37.8025268636696, -122.408333834018) | |
| 187677 | 187677 | 83442 | Undocumented 2 | Morus alba :: White Mulberry 112 | 1234 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | 6015021.96112 | 2102736.5745099997 | 37.7545581912273 | -122.39097232551201 | (37.7545581912273, -122.390972325512) | ||
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 187632 | 187632 | 68261 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 331 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 4 | Permit Number 32067 | 6009662.93548 | 2092873.24927 | 37.72717681975 | -122.40880951134301 | (37.72717681975, -122.408809511343) | |
| 187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) | |
| 187601 | 187601 | 32793 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1654 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 4 | Permit Number 37156 | 5999891.09612214 | 2110582.97970989 | 37.775251258450204 | -122.443862391105 | (37.7752512584502, -122.443862391105) | |
| 187582 | 187582 | 92421 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1746 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52814 | 5984424.3211 | 2103274.5158 | 37.7542899093449 | -122.496825171857 | (37.7542899093449, -122.496825171857) |
| 187576 | 187576 | 31742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2683 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35232 | 5990177.71472403 | 2097127.35673415 | 37.7377468512318 | -122.47647966560899 | (37.7377468512318, -122.476479665609) | |
| 187568 | 187568 | 40690 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 190 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 12 | 5x10 | Permit Number 41673 | 6004620.52288 | 2094031.3393400002 | 37.730072951499 | -122.42632351321998 | (37.730072951499, -122.42632351322) |
| 187556 | 187556 | 38132 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 124 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 11 | Permit Number 40294 | 6010207.56655 | 2094013.9745900002 | 37.7303395024441 | -122.407007086532 | (37.7303395024441, -122.407007086532) | |
| 187546 | 187546 | 32262 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 10 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 3 | Permit Number 35561 | 6005748.8799 | 2099664.71545 | 37.7456046578383 | -122.422822837406 | (37.7456046578383, -122.422822837406) | |
| 187543 | 187543 | 80805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 3 | 6015535.39126 | 2104617.2014200003 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) |
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");