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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4460 | 4460 | 55487 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | 20 | 6x9 | Permit Number 24565 | 6003098.1372 | 2110364.0779 | 37.774832616894706 | -122.43275287348601 | (37.7748326168947, -122.432752873486) |
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 9951 | 9951 | 55414 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 28931 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) |
| 9954 | 9954 | 173752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) | |||
| 10666 | 10666 | 108381 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 204 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773815 | 6001936.176109999 | 2090655.40431 | 37.7206512958141 | -122.435362229505 | (37.7206512958141, -122.435362229505) |
| 11773 | 11773 | 109059 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1126 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772776 | 6001371.73977 | 2087888.1678900002 | 37.7130210113759 | -122.437115282467 | (37.7130210113759, -122.437115282467) |
| 13596 | 13596 | 39526 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012822.50354 | 2106773.24892 | 37.7655197209944 | -122.39886197172 | (37.7655197209944, -122.39886197172) |
| 14517 | 14517 | 39534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012823.46447 | 2106790.35067 | 37.765566732135504 | -122.39885984841801 | (37.7655667321355, -122.398859848418) |
| 15861 | 15861 | 39529 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88x Arkansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | 3x3 | Permit Number 40969 | 6012828.01164 | 2106692.90102 | 37.7652994104535 | -122.398837280819 | (37.7652994104535, -122.398837280819) |
| 16448 | 16448 | 39533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 12 | 3x3 | Permit Number 40969 | 6012825.73713 | 2106722.14345 | 37.7653795769245 | -122.398847200352 | (37.7653795769245, -122.398847200352) |
| 16729 | 16729 | 39527 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 6 | Permit Number 40969 | 6012771.09866 | 2106608.38258 | 37.765064170309 | -122.399028197904 | (37.765064170309, -122.399028197904) | |
| 17116 | 17116 | 30590 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 12 | 6x9 | Permit Number 34559 | 6003172.5389 | 2110146.1627 | 37.77423849498221 | -122.43247993465401 | (37.7742384949822, -122.432479934654) |
| 20152 | 20152 | 30589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34559 | 6003171.8807 | 2110158.6701 | 37.7742727998886 | -122.43248310501801 | (37.7742727998886, -122.432483105018) |
| 20639 | 20639 | 22907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 20 | 3x3 | Permit Number 767420 | 6006042.54291 | 2108252.09004 | 37.7692001550981 | -122.422417449121 | (37.7692001550981, -122.422417449121) |
| 20654 | 20654 | 49903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1686 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46673 | 6006217.29915575 | 2107312.14837083 | 37.7666291551697 | -122.42174620348499 | (37.7666291551697, -122.421746203485) | ||
| 22259 | 22259 | 32095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 8 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/2016 12:00:00 AM | 3 | Permit Number 779125 | 6003421.63406 | 2105677.3546700003 | 37.761982358207796 | -122.431299212108 | (37.7619823582078, -122.431299212108) | |
| 22289 | 22289 | 68675 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 225 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 10 | Permit Number 32584 | 5992727.99284 | 2113946.56215 | 37.784075552459605 | -122.468885802919 | (37.7840755524596, -122.468885802919) | |
| 25406 | 25406 | 39287 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 26106 | 26106 | 50517 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 675 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 13 | Permit Number 47155 | 5994696.74474 | 2110951.43377 | 37.775965278975896 | -122.461857428152 | (37.7759652789759, -122.461857428152) | |
| 27570 | 27570 | 41961 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42317 | 6012040.27004 | 2118796.36454 | 37.7984887835795 | -122.402413030242 | (37.7984887835795, -122.402413030242) | |
| 27621 | 27621 | 37955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015222.376130001 | 2105229.81644 | 37.761415218749 | -122.390453430208 | (37.761415218749, -122.390453430208) | |
| 28855 | 28855 | 31531 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35086 | 6011135.19156 | 2101876.96342 | 37.751981450105205 | -122.40435337421499 | (37.7519814501052, -122.404353374215) | |
| 28986 | 28986 | 70938 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 12 | 6004494.5748 | 2111134.0934 | 37.777025989784 | -122.42797718611901 | (37.777025989784, -122.427977186119) | ||
| 30166 | 30166 | 71545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 624 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 3x3 | 6009927.7218 | 2119891.1918 | 37.8013767524977 | -122.40980045578002 | (37.8013767524977, -122.40980045578) | |
| 31598 | 31598 | 32719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 15 | Permit Number 37112 | 6008120.91675 | 2116143.25856 | 37.7909844366445 | -122.415787285469 | (37.7909844366445, -122.415787285469) | |
| 31829 | 31829 | 41777 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42190 | 6006741.3221 | 2115908.4236 | 37.7902619855897 | -122.42054396081001 | (37.7902619855897, -122.42054396081) | |
| 32729 | 32729 | 32786 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37153 | 5999840.0614 | 2110872.9364 | 37.7760444944885 | -122.444059770227 | (37.7760444944885, -122.444059770227) | |
| 32852 | 32852 | 76301 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015739.497330001 | 2112628.79912 | 37.781759872771104 | -122.389181562198 | (37.7817598727711, -122.389181562198) | ||
| 33749 | 33749 | 71323 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 542 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 14 | 3x3 | 6003533.1657 | 2089339.03151 | 37.7171273913949 | -122.429748095618 | (37.7171273913949, -122.429748095618) | |
| 36957 | 36957 | 37780 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 666 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 11 | Permit Number 40115 | 6008939.41218 | 2093311.61708 | 37.72833993181921 | -122.411341689271 | (37.7283399318192, -122.411341689271) | |
| 38284 | 38284 | 67224 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30683 | 5983507.38436 | 2109708.43135 | 37.771901847852895 | -122.500471801712 | (37.7719018478529, -122.500471801712) | |
| 38556 | 38556 | 39530 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88x Arkansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | Permit Number 40969 | 6012826.83044 | 2106709.20057 | 37.7653440995751 | -122.39884251038 | (37.7653440995751, -122.39884251038) | |
| 38767 | 38767 | 52440 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2601 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 10 | Permit Number 48551 | 6001622.27003 | 2116946.74485 | 37.792823127533296 | -122.43832988971201 | (37.7928231275333, -122.438329889712) | |
| 42607 | 42607 | 61071 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2611 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 10 | Permit Number 20905 | 5999981.3394 | 2114011.0881 | 37.7846691114124 | -122.44379656236 | (37.7846691114124, -122.44379656236) | |
| 43662 | 43662 | 42533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 616 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 10 | Permit Number 42640 | 6009446.62137 | 2111558.04307 | 37.7784689692185 | -122.410876400723 | (37.7784689692185, -122.410876400723) | |
| 43913 | 43913 | 33138 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3018 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 10 | Permit Number 37365 | 6002001.0895 | 2118547.49342 | 37.797239905847505 | -122.437133821084 | (37.7972399058475, -122.437133821084) | |
| 45084 | 45084 | 69872 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 6 | 3x3 | 5985114.18885 | 2110476.07325 | 37.774103764151896 | -122.49497044343599 | (37.7741037641519, -122.494970443436) | |
| 45359 | 45359 | 68576 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 32 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32469 | 5981483.59375 | 2111332.3319599996 | 37.776241595894106 | -122.50759263196899 | (37.7762415958941, -122.507592631969) | |
| 50497 | 50497 | 64682 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 877 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25621 | 6007998.69745064 | 2102830.80019254 | 37.7544246992692 | -122.415267372365 | (37.7544246992692, -122.415267372365) |
| 51321 | 51321 | 115599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 51780 | 51780 | 35344 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 822 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 12 | Permit Number 39079 | 6013033.1221 | 2103220.47445 | 37.7557763166346 | -122.39788424585899 | (37.7557763166346, -122.397884245859) | |
| 52387 | 52387 | 30685 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 432 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 18 | Permit Number 34606 | 6004637.95796 | 2110084.33234 | 37.774151713473294 | -122.42740637791701 | (37.7741517134733, -122.427406377917) | |
| 55851 | 55851 | 41124 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 4 | Permit Number 41867 | 5998124.9728 | 2110290.0537 | 37.7743460607123 | -122.449950669655 | (37.7743460607123, -122.449950669655) | |
| 56486 | 56486 | 71546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 632 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6009897.0165 | 2119885.8819 | 37.8013604520305 | -122.409906335177 | (37.8013604520305, -122.409906335177) | ||
| 57944 | 57944 | 37954 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 9 | Permit Number 40192 | 6015220.22157 | 2105272.8031900004 | 37.761533131571 | -122.39046388570299 | (37.761533131571, -122.390463885703) | |
| 58232 | 58232 | 32454 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 906X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 17 | Permit Number 38694 | 6002140.3718 | 2109505.7536 | 37.772421506399205 | -122.436004547249 | (37.7724215063992, -122.436004547249) | |
| 59199 | 59199 | 42278 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1646 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 5 | Permit Number 46652 | 5986569.425 | 2104035.4361 | 37.756504646339394 | -122.489462910282 | (37.7565046463394, -122.489462910282) | |
| 60621 | 60621 | 37953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40192 | 6015225.34484 | 2105197.25452 | 37.7613259754225 | -122.390440887348 | (37.7613259754225, -122.390440887348) | |
| 62618 | 62618 | 41126 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2001 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | 8 | Permit Number 41867 | 5998172.4841 | 2110296.3702 | 37.7743661226249 | -122.449786775294 | (37.7743661226249, -122.449786775294) | |
| 63160 | 63160 | 52121 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 746 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | 4 | Permit Number 48307 | 6004243.2598 | 2110841.9162 | 37.776209521911895 | -122.428825728246 | (37.7762095219119, -122.428825728246) | |
| 63267 | 63267 | 30983 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2351 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 6 | Permit Number 34770 | 6004127.32192 | 2116907.85743 | 37.792858515854704 | -122.42965952047199 | (37.7928585158547, -122.429659520472) | |
| 64869 | 64869 | 33267 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 65090 | 65090 | 30681 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 19 | 6x4 | Permit Number 34603 | 6004611.85495 | 2109916.0887 | 37.7736882811098 | -122.427484684578 | (37.7736882811098, -122.427484684578) |
| 65223 | 65223 | 61281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/1983 12:00:00 AM | 11 | Permit Number 21173 | 6008008.8902 | 2118937.24196 | 37.7986497253514 | -122.416372878117 | (37.7986497253514, -122.416372878117) | |
| 65453 | 65453 | 37956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 7 | Permit Number 40192 | 6015227.23438 | 2105174.07156 | 37.761262424831 | -122.390432732284 | (37.761262424831, -122.390432732284) | |
| 65602 | 65602 | 45583 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 12 | Permit Number 44319 | 5997017.33036 | 2115699.18266 | 37.789134661580896 | -122.45417295661699 | (37.7891346615809, -122.454172956617) | |
| 65621 | 65621 | 45582 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/25/2004 12:00:00 AM | 12 | Permit Number 44319 | 5997036.45627 | 2115703.83611 | 37.7891485354213 | -122.454107119968 | (37.7891485354213, -122.454107119968) | |
| 65973 | 65973 | 32610 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37075 | 5985761.6347 | 2106405.465 | 37.762964898882295 | -122.49243102202699 | (37.7629648988823, -122.492431022027) | |
| 66925 | 66925 | 42593 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 18 | Permit Number 42666 | 6004942.09948 | 2117812.91349 | 37.7953896721531 | -122.42690483678601 | (37.7953896721531, -122.426904836786) | |
| 67746 | 67746 | 83720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | 10 | 6015466.99985 | 2104808.44883 | 37.7602718009179 | -122.389577941994 | (37.7602718009179, -122.389577941994) | ||
| 69363 | 69363 | 43798 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 212 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43428 | 5988712.94158 | 2113878.39359 | 37.783655595659106 | -122.482771266201 | (37.7836555956591, -122.482771266201) | |
| 69866 | 69866 | 66493 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/21/1991 12:00:00 AM | 18 | Permit Number 29654 | 6010144.597630001 | 2111670.83243 | 37.7788177748451 | -122.40846978437901 | (37.7788177748451, -122.408469784379) | |
| 69982 | 69982 | 59705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3135 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1981 12:00:00 AM | 12 | Permit Number 19135 | 5999682.98481 | 2116022.4865200003 | 37.7901748642281 | -122.44497341010201 | (37.7901748642281, -122.444973410102) | |
| 71577 | 71577 | 30686 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 436 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 13 | Permit Number 34607 | 6004636.65186 | 2110109.9185 | 37.7742218929574 | -122.427412719037 | (37.7742218929574, -122.427412719037) | |
| 72719 | 72719 | 116386 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | 6012827.44648 | 2106665.0509 | 37.765222908729996 | -122.398837280835 | (37.76522290873, -122.398837280835) | ||
| 77350 | 77350 | 67790 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4032 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31432 | 6003633.68639817 | 2101305.49997493 | 37.749990296647894 | -122.43025389067199 | (37.7499902966479, -122.430253890672) | ||
| 77473 | 77473 | 60330 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4166 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19902 | 6002608.00205956 | 2104170.96535693 | 37.7578000327261 | -122.434005560815 | (37.7578000327261, -122.434005560815) | ||
| 78228 | 78228 | 40596 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 78393 | 78393 | 55169 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 955 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 11075 | 6003156.510606 | 2102681.79205166 | 37.7537422304515 | -122.432002254548 | (37.7537422304515, -122.432002254548) | ||
| 79207 | 79207 | 33520 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 156 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45090 | 6007339.22789751 | 2098166.57654537 | 37.741580707379796 | -122.417217500399 | (37.7415807073798, -122.417217500399) | ||
| 79953 | 79953 | 32787 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1661 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37153 | 5999823.76126907 | 2110867.52212558 | 37.7760286983996 | -122.444115767373 | (37.7760286983996, -122.444115767373) | ||
| 80185 | 80185 | 30706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 21 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34616 | 6005672.1323567005 | 2109287.22209736 | 37.772021477067 | -122.423772292692 | (37.772021477067, -122.423772292692) | ||
| 80421 | 80421 | 31535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 80483 | 80483 | 31534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35086 | 6011138.71993424 | 2101856.99163788 | 37.751926809144294 | -122.404339766926 | (37.7519268091443, -122.404339766926) | ||
| 80592 | 80592 | 39276 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 80791 | 80791 | 45205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 600-698X Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46769 | 6008896.51323802 | 2093167.07646195 | 37.7279406478975 | -122.411479785884 | (37.7279406478975, -122.411479785884) | ||
| 81050 | 81050 | 40589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1745 Alameda St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 82376 | 82376 | 33268 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 82577 | 82577 | 57712 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 655 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24567 | 6003077.52499171 | 2110495.81975272 | 37.775193178371296 | -122.43283358882 | (37.7751931783713, -122.43283358882) | ||
| 82880 | 82880 | 112265 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 82953 | 82953 | 60331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4175 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | 3x3 | Permit Number 19903 | 6002568.73005013 | 2104116.70638175 | 37.7576488217943 | -122.434137500842 | (37.7576488217943, -122.434137500842) | |
| 83077 | 83077 | 115602 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | ||||
| 83259 | 83259 | 66979 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 690 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | Permit Number 30325 | 6009570.86140277 | 2120194.98461849 | 37.8021908871345 | -122.411056826716 | (37.8021908871345, -122.411056826716) | ||
| 83634 | 83634 | 64766 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 259 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29584 | 6006089.46258031 | 2096127.20012882 | 37.735910646189396 | -122.421393977694 | (37.7359106461894, -122.421393977694) | ||
| 83695 | 83695 | 121305 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 83896 | 83896 | 68356 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 630 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32176 | 5990370.46643426 | 2111075.29935955 | 37.776055373776394 | -122.476832047274 | (37.7760553737764, -122.476832047274) | ||
| 84151 | 84151 | 65357 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2390 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | Permit Number 28192 | 6001831.05010454 | 2097061.25090734 | 37.738234317974 | -122.436183798503 | (37.738234317974, -122.436183798503) | ||
| 84597 | 84597 | 112264 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201X WALNUT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5998535.0 | 2115724.0 | 37.7892897137264 | -122.448923821633 | (37.7892897137264, -122.448923821633) | |||
| 86890 | 86890 | 32789 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1704 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
| 88282 | 88282 | 45685 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2001 12:00:00 AM | Permit Number 44372 | 6000482.11013165 | 2115133.23910005 | 37.787778798038104 | -122.442144646612 | (37.7877787980381, -122.442144646612) | ||
| 88650 | 88650 | 36681 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3440 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39482 | 6006586.56079834 | 2105563.12319804 | 37.7618475592216 | -122.42034483554701 | (37.7618475592216, -122.420344835547) | ||
| 88790 | 88790 | 45204 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 600-698X Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46769 | 6008896.51323802 | 2093167.07646195 | 37.7279406478975 | -122.411479785884 | (37.7279406478975, -122.411479785884) | ||
| 90043 | 90043 | 33272 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | Permit Number 37441 | 6009551.65503934 | 2116448.08509162 | 37.7919017434497 | -122.41085850563101 | (37.7919017434497, -122.410858505631) | ||
| 90944 | 90944 | 39285 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 91027 | 91027 | 115600 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 91162 | 91162 | 39535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 76x ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40969 | 6012767.0 | 2106714.0 | 37.7653539438367 | -122.399049788163 | (37.7653539438367, -122.399049788163) |
| 91207 | 91207 | 32908 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 331 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37246 | 5994758.03281506 | 2107001.34896183 | 37.765122912865706 | -122.46135899992599 | (37.7651229128657, -122.461358999926) | ||
| 91966 | 91966 | 115603 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | ||||
| 92292 | 92292 | 39627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 93235 | 93235 | 39279 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
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");