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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 10 | 122670 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 301x Hickory St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | |||||||
| 76 | 76 | 241180 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 300 Duboce Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | |
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 159 | 159 | 97322 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1055 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/2017 12:42:00 PM | 3 | 3x3 | 5989910.3078 | 2099001.0945 | 37.7428761380219 | -122.477541124233 | (37.7428761380219, -122.477541124233) | ||
| 193 | 193 | 6069 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 3X3 | 6001175.3543 | 2112495.6639 | 37.7805761758993 | -122.439557004629 | (37.7805761758993, -122.439557004629) | ||
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 322 | 322 | 7968 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1901 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3 | 3X3 | 6005627.24821 | 2116610.0246200003 | 37.7921255585096 | -122.42444850412 | (37.7921255585096, -122.42444850412) | ||
| 554 | 554 | 31894 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 333 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35323 | 6008421.36423 | 2108725.6861900003 | 37.7706344442547 | -122.41422271959999 | (37.7706344442547, -122.4142227196) | |
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 578 | 578 | 239543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.362369999 | 2097372.9446900003 | 37.7393929694044 | -122.41768982014798 | (37.7393929694044, -122.417689820148) | |
| 591 | 591 | 139532 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 2103 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779818 | 6001200.3588 | 2113145.5057 | 37.7823618989571 | -122.439517100245 | (37.7823618989571, -122.439517100245) | |
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 741 | 741 | 9506 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 935 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 3 | 3X3 | 6005056.2117 | 2112292.3227 | 37.7802379614696 | -122.426116783326 | (37.7802379614696, -122.426116783326) | ||
| 743 | 743 | 224663 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008964.71968 | 2105285.1997599998 | 37.761218168313704 | -122.412100053373 | (37.7612181683137, -122.412100053373) | |
| 775 | 775 | 231005 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 8 | Width 3ft | Permit Number 46247 | 6008971.29667 | 2105087.04019 | 37.7606744364044 | -122.41206330170401 | (37.7606744364044, -122.412063301704) | |
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
| 1125 | 1125 | 38267 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 1300 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6014066.98761 | 2103880.20359 | 37.757645313792295 | -122.39435496983299 | (37.7576453137923, -122.394354969833) | ||
| 1128 | 1128 | 38275 | Permitted Site 1 | Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 | 651 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2017 12:00:00 AM | 3 | Permit Number 40367 | 6013943.54254 | 2103938.72902 | 37.7577991491248 | -122.394785995079 | (37.7577991491248, -122.394785995079) | ||
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 1216 | 1216 | 244031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1999 12:00:00 AM | 6 | Width 0ft | Permit Number 41876 | 5997510.0 | 2108663.0 | 37.7698433835647 | -122.45196055507601 | (37.7698433835647, -122.451960555076) | |
| 1229 | 1229 | 235065 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2400 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 6 | Width 2ft | Permit Number 38465 | 6001951.69941 | 2097144.86437 | 37.7384707551305 | -122.43577263420299 | (37.7384707551305, -122.435772634203) | |
| 1237 | 1237 | 103805 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342786999 | (37.7873499398897, -122.41973342787) | ||
| 1269 | 1269 | 251332 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 920X Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779528 | 6007731.0 | 2102403.0 | 37.753235008598104 | -122.416162845847 | (37.7532350085981, -122.416162845847) | |
| 1275 | 1275 | 4132 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 3550 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x3 | 6006390.9849 | 2100603.33536 | 37.7482181038931 | -122.420669151754 | (37.7482181038931, -122.420669151754) | ||
| 1374 | 1374 | 97285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2321 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773461 | 6003155.0 | 2116788.0 | 37.7924743139296 | -122.433015230869 | (37.7924743139296, -122.433015230869) | |
| 1446 | 1446 | 139885 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1575 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 6 | Width 0ft | 6002581.4123 | 2112293.0339 | 37.7800997287845 | -122.434678293337 | (37.7800997287845, -122.434678293337) | ||
| 1476 | 1476 | 139882 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1990 12:00:00 AM | 14 | Width 0ft | 6002483.27 | 2112280.1738 | 37.780058846079605 | -122.435016891621 | (37.7800588460796, -122.435016891621) | ||
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) | ||||
| 1485 | 1485 | 115988 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777967 | 6011781.45666 | 2118040.71778 | 37.7963995082912 | -122.40325542520901 | (37.7963995082912, -122.403255425209) | |
| 1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
| 1617 | 1617 | 88497 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1701 Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51438 | 6015090.0 | 2094306.0 | 37.7314133544089 | -122.390148092066 | (37.7314133544089, -122.390148092066) | |
| 1622 | 1622 | 15770 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.721703820816394 | -122.43716874658399 | (37.7217038208164, -122.437168746584) | ||
| 1721 | 1721 | 23308 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/1998 12:00:00 AM | 5 | 3X3 | 6006538.20918 | 2114040.94612 | 37.785122904641796 | -122.42111406077 | (37.7851229046418, -122.42111406077) | ||
| 1864 | 1864 | 44087 | Permitted Site 1 | Tree(s) :: 17 | 500 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780030 | 6013716.56338 | 2112456.73733 | 37.7811750796017 | -122.396167952707 | (37.7811750796017, -122.396167952707) | |
| 1989 | 1989 | 133618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 150 Richardson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999272.2292 | 2119684.41545 | 37.8002060956892 | -122.446658172159 | (37.8002060956892, -122.446658172159) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 2018 | 2018 | 238617 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2012 12:00:00 AM | 5 | Width 4ft | Permit Number 769743 | 6001157.09349 | 2101748.35409 | 37.751065679453504 | -122.438849790481 | (37.7510656794535, -122.438849790481) | |
| 2020 | 2020 | 40822 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 695 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | 3 | 3x3 | Permit Number 41762 | 6013323.14167 | 2110435.9074 | 37.775604443222704 | -122.39738724541901 | (37.7756044432227, -122.397387245419) | |
| 2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
| 2065 | 2065 | 141406 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 500 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 6 | Width 0ft | Permit Number 34950 | 6004860.5862 | 2111087.89 | 37.77691982656621 | -122.42670774733699 | (37.7769198265662, -122.426707747337) | |
| 2078 | 2078 | 12419 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.786423711867705 | -122.42836245915599 | (37.7864237118677, -122.428362459156) | ||
| 2080 | 2080 | 34119 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37980 | |||||||||
| 2098 | 2098 | 97613 | Permitted Site 1 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 353 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780019 | 6009097.30811 | 2109294.5871599996 | 37.7722344586718 | -122.411924820485 | (37.7722344586718, -122.411924820485) | |
| 2172 | 2172 | 43089 | Permitted Site 1 | Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 | 240 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 15 | Permit Number 42924 | 6009028.16004 | 2113458.59755 | 37.783663965959995 | -122.41245839903999 | (37.78366396596, -122.41245839904) | |
| 2221 | 2221 | 143495 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 800 KEARNY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011293.9321 | 2117775.1194 | 37.795642999547894 | -122.40492366345501 | (37.7956429995479, -122.404923663455) | |
| 2227 | 2227 | 129057 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 662 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011354.55314 | 2117688.13829 | 37.7954075587569 | -122.404707776336 | (37.7954075587569, -122.404707776336) | |
| 2244 | 2244 | 34670 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2001X Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 38339 | 6003296.78192 | 2118922.23396 | 37.798342411735604 | -122.432677184799 | (37.7983424117356, -122.432677184799) | |
| 2276 | 2276 | 252994 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2310 | 2310 | 102805 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 600 Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011492.26434 | 2105507.65774 | 37.7619704808857 | -122.403373953167 | (37.7619704808857, -122.403373953167) | |
| 2380 | 2380 | 253068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 420 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.0075199995 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | ||
| 2389 | 2389 | 201587 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6021008.9496 | 2093419.1731599998 | 37.729304811746104 | -122.36962364951799 | (37.7293048117461, -122.369623649518) | |
| 2421 | 2421 | 253064 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 451 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770412 | 6021215.947000001 | 2093217.369 | 37.728762049698204 | -122.36889409743 | (37.7287620496982, -122.36889409743) | ||
| 2430 | 2430 | 201600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 98 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020594.26008 | 2092766.53995 | 37.7274900446232 | -122.371012172182 | (37.7274900446232, -122.371012172182) | |
| 2437 | 2437 | 201591 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020744.06411 | 2093067.1780599998 | 37.7283237638216 | -122.37051506831001 | (37.7283237638216, -122.37051506831) | |
| 2448 | 2448 | 253050 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2454 | 2454 | 201833 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.8779900002 | 37.727721034575296 | -122.370535976659 | (37.7277210345753, -122.370535976659) | |
| 2462 | 2462 | 253060 | Permitted Site 1 | Zelkova serrata :: Sawleaf Zelkova 174 | 421 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770411 | 6021349.4 | 2093117.8080000002 | 37.728495991679296 | -122.368425863032 | (37.7284959916793, -122.368425863032) | ||
| 2473 | 2473 | 253095 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1201 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779996 | 5987047.82966 | 2107087.0186099997 | 37.7649113707945 | -122.488032657316 | (37.7649113707945, -122.488032657316) | |
| 2507 | 2507 | 137731 | Permitted Site 1 | Tree(s) :: 17 | 610 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780365 | 6000144.0 | 2111022.0 | 37.7764711190239 | -122.44301907684799 | (37.7764711190239, -122.443019076848) | |
| 2615 | 2615 | 253153 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2030 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | Permit Number 779475 | 6015677.29531 | 2106131.10604 | 37.763915191309295 | -122.38894296750799 | (37.7639151913093, -122.388942967508) | |||
| 2633 | 2633 | 108358 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/17/2014 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.0245900005 | 2118966.98612 | 37.798398653541796 | -122.43674193970399 | (37.7983986535418, -122.436741939704) | |
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 2674 | 2674 | 223658 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336 Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 18811 | 6003665.26948 | 2095270.38526 | 37.7334210492488 | -122.429714281988 | (37.7334210492488, -122.429714281988) | ||
| 2719 | 2719 | 141993 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 818 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 2 | Width 0ft | 6003993.152000001 | 2111582.4748 | 37.778228754000004 | -122.429743751351 | (37.778228754, -122.429743751351) | ||
| 2797 | 2797 | 142505 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 620 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 22 | Width 0ft | Permit Number 774306 | 6010566.6807 | 2118940.2612 | 37.7988015168915 | -122.407522281284 | (37.7988015168915, -122.407522281284) | |
| 2826 | 2826 | 28035 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011869.41049 | 2121075.03017 | 37.804735906188796 | -122.403164632367 | (37.8047359061888, -122.403164632367) | ||
| 2842 | 2842 | 36843 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 2898 | 2898 | 114413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 6008903.22514 | 2117506.21986 | 37.7947707425189 | -122.413176939363 | (37.7947707425189, -122.413176939363) | ||||
| 2908 | 2908 | 140145 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2077 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997912.6072 | 2109907.6306 | 37.7732838718856 | -122.45065770078699 | (37.7732838718856, -122.450657700787) | |||
| 2931 | 2931 | 93638 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1603 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6000053.4052 | 2110559.6245 | 37.7751963877973 | -122.44329925092501 | (37.7751963877973, -122.443299250925) | |||
| 2940 | 2940 | 250421 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987880.27353 | 2115792.69032 | 37.788863226412296 | -122.485792492053 | (37.7888632264123, -122.485792492053) | |||
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 3011 | 3011 | 142167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000740.7568 | 2110654.3455 | 37.775495639126795 | -122.440928349683 | (37.7754956391268, -122.440928349683) | |||
| 3012 | 3012 | 222459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 12 | Width 3ft | Permit Number 37768 | 6003745.35961 | 2108826.05534 | 37.7706462694291 | -122.430404237367 | (37.7706462694291, -122.430404237367) | |
| 3013 | 3013 | 39333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 0 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40897 | ||||||||
| 3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
| 3062 | 3062 | 34116 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37979 | |||||||||
| 3098 | 3098 | 227979 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 6 | Width 3ft | Permit Number 49086 | 6005126.89466 | 2099045.69197 | 37.7438698467248 | -122.424929536192 | (37.7438698467248, -122.424929536192) | |
| 3101 | 3101 | 102774 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 31200 | 6005947.91695 | 2119337.23456 | 37.7996318920616 | -122.42353296190201 | (37.7996318920616, -122.423532961902) | ||
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 3160 | 3160 | 109437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 940 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x6 | 6003136.3777 | 2111029.1486 | 37.7766609049 | -122.432668109569 | (37.7766609049, -122.432668109569) | |||
| 3201 | 3201 | 150469 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 100 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012042.59416 | 2104165.28662 | 37.758315349182794 | -122.40137622523899 | (37.7583153491828, -122.401376225239) | |
| 3207 | 3207 | 253355 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1705 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3212 | 3212 | 34102 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37975 | |||||||||
| 3225 | 3225 | 253351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1756 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3233 | 3233 | 253345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1700 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||
| 3281 | 3281 | 245417 | Permitted Site 1 | Acer rubrum 'Autumn Glory' :: Red Maple Tree 'Autumn Glory' 202 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | |
| 3287 | 3287 | 253411 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 3340 | 3340 | 140461 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1410 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1991 12:00:00 AM | 7 | Width 0ft | 6003069.601 | 2112407.5024 | 37.780441733392 | -122.432997609121 | (37.780441733392, -122.432997609121) | ||
| 3352 | 3352 | 140464 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 4 | Width 0ft | 6002964.8193 | 2112393.1435 | 37.780396363522 | -122.433359071525 | (37.780396363522, -122.433359071525) | ||
| 3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) |
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");