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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46076 | 46076 | 88557 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51502 | 5990963.88297 | 2110397.4755 | 37.7742286595499 | -122.474729799279 | (37.7742286595499, -122.474729799279) | ||
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 47317 | 47317 | 89328 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 376 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52512 | 5990923.61484 | 2112893.52496 | 37.7810797921954 | -122.475051338659 | (37.7810797921954, -122.475051338659) | ||
| 47993 | 47993 | 105254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 130 GONZALEZ DR | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | |||||
| 48042 | 48042 | 88589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 874 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.48308379276699 | (37.7731428326728, -122.483083792767) | ||
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 50102 | 50102 | 94943 | Significant Tree 6 | Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 | 2525 Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6016314.6 | 2089984.7 | 37.719615759266205 | -122.38561332473999 | (37.7196157592662, -122.38561332474) | ||||
| 50166 | 50166 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177.0 | 2107098.0 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | |||
| 50948 | 50948 | 85291 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | ||
| 51543 | 51543 | 95372 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 180 Yukon St | Back Yard : Cutout 16 | Tree 1 | Private 1 | 15 | Permit Number 767755 | 6000174.3 | 2103956.9 | 37.7570738455347 | -122.44240692055901 | (37.7570738455347, -122.442406920559) | ||||
| 54060 | 54060 | 91105 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5100 Fulton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987471.43657 | 2109862.78332 | 37.7725575525108 | -122.48677137341002 | (37.7725575525108, -122.48677137341) | |||
| 54143 | 54143 | 88190 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1118 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51195 | 6010631.0 | 2110372.0 | 37.7752787109316 | -122.406695562022 | (37.7752787109316, -122.406695562022) | |||
| 54776 | 54776 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 58422 | 58422 | 88590 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 879 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51534 | 5988496.55616 | 2110024.26731 | 37.7730606531011 | -122.483237261836 | (37.7730606531011, -122.483237261836) | ||
| 58727 | 58727 | 110212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | ||||
| 58949 | 58949 | 108642 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 167 Judson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | |
| 58951 | 58951 | 107381 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 MOSS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | ||||||
| 58967 | 58967 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 59589 | 59589 | 88375 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 365 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51353 | 5991523.32351 | 2112975.7244700002 | 37.7813402274639 | -122.472982663209 | (37.7813402274639, -122.472982663209) | ||
| 60427 | 60427 | 88580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.778829528805794 | -122.480271570948 | (37.7788295288058, -122.480271570948) | ||
| 61152 | 61152 | 90191 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1860X Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.4454200002 | 37.776633638000604 | -122.478900695137 | (37.7766336380006, -122.478900695137) | |||
| 61686 | 61686 | 105315 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2101 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | |||||
| 61699 | 61699 | 86883 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 550 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49808 | 6001589.0 | 2101474.0 | 37.750336931820996 | -122.43733657341998 | (37.750336931821, -122.43733657342) | ||||
| 62735 | 62735 | 92823 | Permitted Site 1 | Tree(s) :: 17 | 50 Kirkham St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 3x3 | Permit Number 53037 | 5994776.3 | 2105346.5 | 37.760580177714296 | -122.461175855238 | (37.7605801777143, -122.461175855238) | |||
| 63651 | 63651 | 109426 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Locust St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | ||||
| 65292 | 65292 | 87805 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 21 Mallorca Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | |||
| 66036 | 66036 | 88055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Robblee Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498.0 | 2095923.9 | 37.735711666118604 | -122.39922270968201 | (37.7357116661186, -122.399222709682) | |||
| 66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
| 66686 | 66686 | 88558 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 422 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51503 | 5990315.69001 | 2112483.17966 | 37.7799178466375 | -122.47712443654801 | (37.7799178466375, -122.477124436548) | ||
| 66740 | 66740 | 91087 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207.0 | 2088764.0 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | |||
| 67866 | 67866 | 92826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2009 12:00:00 AM | 5 | 3x3 | Permit Number 53040 | 5991610.35704 | 2110282.0512900003 | 37.7739491753353 | -122.47248513397899 | (37.7739491753353, -122.472485133979) | ||
| 69763 | 69763 | 88585 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 811 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51528 | 5988482.920390001 | 2110432.2524099997 | 37.7741800732451 | -122.483314341794 | (37.7741800732451, -122.483314341794) | ||
| 69774 | 69774 | 91104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5100 Fulton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987486.90451 | 2109863.03961 | 37.772559157968395 | -122.48671788773399 | (37.7725591579684, -122.486717887734) | |||
| 69881 | 69881 | 91641 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216001 | 2101489.31094 | 37.750727267460604 | -122.416034053567 | (37.7507272674606, -122.416034053567) | |||
| 69888 | 69888 | 87784 | Permitted Site 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 48 Santa Ysabel Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50524 | 6000929.5 | 2093152.6 | 37.727450804928395 | -122.439020861215 | (37.7274508049284, -122.439020861215) | |||
| 72151 | 72151 | 91659 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | |||
| 72523 | 72523 | 108691 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 1638 41st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774623 | 5983468.36272 | 2103987.5899 | 37.756191751246796 | -122.500183776602 | (37.7561917512468, -122.500183776602) | |
| 74398 | 74398 | 97290 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 55 Hiliritas Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | |||||
| 75295 | 75295 | 88331 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 635 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51319 | 6002224.0 | 2090226.0 | 37.7194885890815 | -122.434336629443 | (37.7194885890815, -122.434336629443) | |||
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 77051 | 77051 | 88389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51367 | 5989030.6035 | 2113722.2392700003 | 37.7832453168995 | -122.481660848787 | (37.7832453168995, -122.481660848787) | ||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 77431 | 77431 | 91612 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1108 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007615.164408 | 2103191.40433 | 37.755393273338 | -122.41661927573799 | (37.755393273338, -122.416619275738) | |||
| 77551 | 77551 | 116996 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 606x FULTON ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/29/2016 12:00:00 AM | 3 | 6004628.0 | 2111737.0 | 37.7786889706302 | -122.42755859051901 | (37.7786889706302, -122.427558590519) | ||||
| 77575 | 77575 | 107856 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2938 SLOAT BLVD | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981725.3 | 2096580.0 | 37.7357501162313 | -122.50566267275299 | (37.7357501162313, -122.505662672753) | |||||
| 77577 | 77577 | 107520 | Undocumented 2 | Tree(s) :: 17 | 2 CHURCH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004041.5 | 2108639.2 | 37.7701499806884 | -122.42936655700701 | (37.7701499806884, -122.429366557007) | ||||||
| 77650 | 77650 | 108872 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1317 Grove St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773401 | 6001507.20104 | 2110761.06824 | 37.775832295364104 | -122.438284688432 | (37.7758322953641, -122.438284688432) | |
| 77818 | 77818 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 862 Kansas St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774734 | 6011570.0 | 2104296.0 | 37.758647879927395 | -122.403019866682 | (37.7586478799274, -122.403019866682) | |||||
| 77844 | 77844 | 94858 | Permitted Site 1 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2595 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52715 | 5991705.5 | 2097813.3 | 37.739718766740395 | -122.47124738715901 | (37.7397187667404, -122.471247387159) | ||
| 77880 | 77880 | 93215 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 499 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715.0 | 2118034.0 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | |||
| 77894 | 77894 | 107651 | Undocumented 2 | Tree(s) :: 17 | 2908 23RD ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009361.7 | 2102802.2 | 37.7544226781239 | -122.41055171892201 | (37.7544226781239, -122.410551718922) | ||||||
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
| 77943 | 77943 | 115998 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 143 ASHBURY ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998718.0 | 2110172.0 | 37.7740558300516 | -122.447890785953 | (37.7740558300516, -122.447890785953) | |||||
| 78041 | 78041 | 86802 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359.0 | 2106197.0 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | |||
| 78043 | 78043 | 88136 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690.0 | 2096237.0 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | |||
| 78075 | 78075 | 104299 | Permitted Site 1 | Tree(s) :: 17 | 4021 20TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x4 | 6003557.0 | 2104154.0 | 37.75780726103579 | -122.430722322319 | (37.7578072610358, -122.430722322319) | |||||
| 78101 | 78101 | 96597 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 325 Sanchez St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||||
| 78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
| 78144 | 78144 | 87131 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 De Montfort Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50083 | 5995245.2 | 2091924.0 | 37.7237522965749 | -122.45858247555599 | (37.7237522965749, -122.458582475556) | |||
| 78299 | 78299 | 93555 | Permitted Site 1 | Tree(s) :: 17 | 290 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2010 12:00:00 AM | 3x3 | Permit Number 53175 | 6011548.0 | 2119416.0 | 37.80016265957239 | -122.40416007916401 | (37.8001626595724, -122.404160079164) | |||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78421 | 78421 | 88365 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411001 | (37.7707473776731, -122.44194989411) | |||
| 78453 | 78453 | 102458 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3267 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6008409.0 | 2104449.0 | 37.7588909590293 | -122.413962902008 | (37.7588909590293, -122.413962902008) | ||||
| 78494 | 78494 | 94522 | Permitted Site 1 | Tree(s) :: 17 | 524 Howard St | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 08/30/2010 12:00:00 AM | Permit Number 53710 | 6013519.0 | 2114878.0 | 37.7878123136723 | -122.397021246793 | (37.7878123136723, -122.397021246793) | ||||
| 78522 | 78522 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 78574 | 78574 | 109626 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 117 JUDSON AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999286.5 | 2093444.4 | 37.728158398345705 | -122.44472166307101 | (37.7281583983457, -122.444721663071) | |||||
| 78600 | 78600 | 97647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1844 Noriega St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988207.7 | 2103154.5 | 37.754181336878204 | -122.483732655057 | (37.7541813368782, -122.483732655057) | |||||
| 78616 | 78616 | 106550 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 81 MINERVA ST | Median : Cutout 11 | Tree 1 | DPW 2 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | ||||||
| 78648 | 78648 | 112011 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 78785 | 78785 | 88385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 139 19th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778767 | 5989887.12414 | 2114429.03218 | 37.7852357408604 | -122.478749371232 | (37.7852357408604, -122.478749371232) | ||
| 78805 | 78805 | 97021 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 78890 | 78890 | 91625 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.41612211811501 | (37.7501975073399, -122.416122118115) | |||
| 78970 | 78970 | 106970 | Undocumented 2 | Tree(s) :: 17 | 30 Piedmont St | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2014 12:00:00 AM | Permit Number 772781 | 5999571.08265 | 2107127.2788400003 | 37.76574451836729 | -122.444720943629 | (37.7657445183673, -122.444720943629) | ||||
| 79007 | 79007 | 107987 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 233 Laidley St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | |||
| 79011 | 79011 | 108637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 15 TUCKER AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 6011049.2 | 2088423.2 | 37.715035447895396 | -122.403704200211 | (37.7150354478954, -122.403704200211) | ||||||
| 79023 | 79023 | 86703 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 306 Mullen Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/2007 12:00:00 AM | Permit Number 49696 | 6010582.9 | 2099803.7 | 37.7462578450491 | -122.40611723741002 | (37.7462578450491, -122.40611723741) | ||||
| 79028 | 79028 | 91619 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | |||
| 79063 | 79063 | 89042 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231.0 | 2115470.0 | 37.789198174235295 | -122.411898830301 | (37.7891981742353, -122.411898830301) | |||
| 79204 | 79204 | 95400 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 227 Valley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767274 | 6004277.7 | 2099178.3 | 37.744185954454295 | -122.42787530142701 | (37.7441859544543, -122.427875301427) | ||
| 79220 | 79220 | 86712 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3806 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49698 | 6003066.0 | 2103019.0 | 37.7546629917484 | -122.43233934232599 | (37.7546629917484, -122.432339342326) | ||||
| 79312 | 79312 | 105448 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 453 WALLER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003543.7 | 2108942.4 | 37.770954298248206 | -122.431110085749 | (37.7709542982482, -122.431110085749) | ||||
| 79328 | 79328 | 88522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 79354 | 79354 | 106559 | Permitted Site 1 | Tree(s) :: 17 | 2630 Bay Shore Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2014 12:00:00 AM | 3x3 | Permit Number 772167 | 6010472.4 | 2086044.7 | 37.7084723291496 | -122.405530459051 | (37.7084723291496, -122.405530459051) | |||
| 79358 | 79358 | 108613 | Permitted Site 1 | Podocarpus gracilor :: Fern Pine 13 | 859 Moultrie St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774597 | 6007577.26936 | 2095354.40031 | 37.7338724793659 | -122.416195309142 | (37.7338724793659, -122.416195309142) | |
| 79404 | 79404 | 97051 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 795 Wisconsin St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.39877559017401 | (37.7574425906128, -122.398775590174) | |||
| 79434 | 79434 | 105048 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 205 Carl St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 771190 | 5997152.5 | 2107007.0 | 37.765275948780605 | -122.453077573625 | (37.7652759487806, -122.453077573625) | ||||
| 79469 | 79469 | 88223 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2442 Fulton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51219 | 5996404.0 | 2110432.0 | 37.7746371856421 | -122.455914062335 | (37.7746371856421, -122.455914062335) | |||
| 79533 | 79533 | 87262 | Permitted Site 1 | Brahea aramata :: Mexican Blue Palm 313 | 2360 Pacific Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2009 12:00:00 AM | 3x3 | Permit Number 52082 | 6002863.7 | 2117183.6 | 37.79354400237779 | -122.434051428216 | (37.7935440023778, -122.434051428216) | |||
| 79535 | 79535 | 96590 | Property Tree 7 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Church St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.42905208409401 | (37.7643437320395, -122.429052084094) | |||||
| 79618 | 79618 | 86844 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 79735 | 79735 | 88396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.3051849995 | 2111648.444046 | 37.777498983924204 | -122.484616395841 | (37.7774989839242, -122.484616395841) | |||
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 79846 | 79846 | 117347 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1149 Diamond St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002009.6 | 2100656.7 | 37.7481167216076 | -122.435823641852 | (37.7481167216076, -122.435823641852) | ||||||
| 79919 | 79919 | 94871 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 Innes Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53941 | 6015653.4 | 2097175.2 | 37.7393228299093 | -122.38840048148701 | (37.7393228299093, -122.388400481487) | ||
| 79961 | 79961 | 105904 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) | |||||
| 80037 | 80037 | 86731 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 2 Pico Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.724367252780496 | -122.462549157922 | (37.7243672527805, -122.462549157922) | |||||
| 80121 | 80121 | 91624 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) |
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");