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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45852 | 45852 | 34829 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2326 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38459 | 6002953.09007 | 2117180.29996 | 37.7935400139991 | -122.43374189577801 | (37.7935400139991, -122.433741895778) | ||
46112 | 46112 | 134975 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6009928.574659999 | 2122361.54548 | 37.808159777214705 | -122.409971995727 | (37.8081597772147, -122.409971995727) | ||||
46489 | 46489 | 135163 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | ||||
46967 | 46967 | 97443 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900@Gough Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 19 | 6004934.79504 | 2117459.18923 | 37.7944180221298 | -122.426904906932 | (37.7944180221298, -122.426904906932) | ||||
46991 | 46991 | 32192 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 249 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1995 12:00:00 AM | 11 | Permit Number 35520 | 6005460.63275 | 2102252.90827 | 37.752694972216396 | -122.424003572633 | (37.7526949722164, -122.424003572633) | ||
47201 | 47201 | 48758 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 7 | Permit Number 46024 | 6015430.351969999 | 2113146.13578 | 37.7831632198459 | -122.390287224693 | (37.7831632198459, -122.390287224693) | ||
47709 | 47709 | 100127 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6005919.013280001 | 2116937.33835 | 37.793040751777895 | -122.423462271584 | (37.7930407517779, -122.423462271584) | ||||
47774 | 47774 | 50645 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 6 | Permit Number 47231 | 6012021.65613 | 2108596.8442 | 37.7704822465918 | -122.40176013144101 | (37.7704822465918, -122.401760131441) | ||
47973 | 47973 | 60229 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6242 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1982 12:00:00 AM | 13 | Permit Number 19780 | 5988145.31285 | 2114007.56926 | 37.783977233395 | -122.484744500147 | (37.783977233395, -122.484744500147) | ||
48350 | 48350 | 135606 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014317.5714300005 | 2117686.49478 | 37.795568207348104 | -122.394455046367 | (37.7955682073481, -122.394455046367) | ||||
48582 | 48582 | 124186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5995895.66436 | 2112512.94419 | 37.7803217205181 | -122.45782309872601 | (37.7803217205181, -122.457823098726) | ||||
48815 | 48815 | 98193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 21173 | 6007993.35448 | 2118936.88805 | 37.7986478799625 | -122.416426611713 | (37.7986478799625, -122.416426611713) | |||
49039 | 49039 | 58771 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1167 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/1979 12:00:00 AM | 19 | Permit Number 18014 | 6011972.53295 | 2102984.11812 | 37.7550682111553 | -122.40153551496599 | (37.7550682111553, -122.401535514966) | ||
49230 | 49230 | 46118 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44476 | 6015543.8 | 2115940.8 | 37.7908430231508 | -122.390090033136 | (37.7908430231508, -122.390090033136) | |||
49827 | 49827 | 30339 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2560 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 11 | Permit Number 25 | 6000743.8652099995 | 2117098.2873400003 | 37.793189222668204 | -122.441380081625 | (37.7931892226682, -122.441380081625) | ||
49875 | 49875 | 98195 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 21173 | 6007973.60384 | 2118935.141 | 37.7986419723002 | -122.416494831573 | (37.7986419723002, -122.416494831573) | |||
50341 | 50341 | 114298 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6013989.74261 | 2111760.81126 | 37.7792794211457 | -122.395174119091 | (37.7792794211457, -122.395174119091) | ||||
50666 | 50666 | 48764 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 8 | Permit Number 46024 | 6015390.72434 | 2113107.33442 | 37.7830544819291 | -122.390421609467 | (37.7830544819291, -122.390421609467) | ||
50855 | 50855 | 48765 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 8 | Permit Number 46024 | 6015410.0664800005 | 2113126.28428 | 37.7831075868932 | -122.390356017438 | (37.7831075868932, -122.390356017438) | ||
51289 | 51289 | 113523 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6008978.63721 | 2113180.33608 | 37.782897147317 | -122.412610052614 | (37.782897147317, -122.412610052614) | ||||
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) | |
51809 | 51809 | 37233 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 10 | Permit Number 39797 | 5987275.2123 | 2103735.3235 | 37.755721796170796 | -122.487000039163 | (37.7557217961708, -122.487000039163) | ||
51916 | 51916 | 66776 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3281 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1991 12:00:00 AM | 8 | Permit Number 30036 | 5998594.79518 | 2116202.97175 | 37.7906082628077 | -122.44875145122101 | (37.7906082628077, -122.448751451221) | ||
51958 | 51958 | 112915 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3584-3586 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6001197.654490001 | 2120932.92858 | 37.8037439773658 | -122.44008504169202 | (37.8037439773658, -122.440085041692) | ||||
52260 | 52260 | 107033 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3935 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5995914.71466 | 2115499.6505400003 | 37.7885235115917 | -122.45797339852899 | (37.7885235115917, -122.457973398529) | ||||
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) | |
52441 | 52441 | 34976 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3630 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 11 | Permit Number 38558 | 5996908.84591 | 2116013.74253 | 37.7899921372872 | -122.45457103072901 | (37.7899921372872, -122.454571030729) | ||
52979 | 52979 | 106420 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6006085.26513 | 2121444.8037900003 | 37.8054264901903 | -122.423207580863 | (37.8054264901903, -122.423207580863) | ||||
53095 | 53095 | 135139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009651.5635 | 2122485.8577099997 | 37.808485578225294 | -122.410939454894 | (37.8084855782253, -122.410939454894) | ||||
53184 | 53184 | 27902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.38849525296699 | (37.782239240724, -122.388495252967) | |||
53188 | 53188 | 49505 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 702@ INNES Phelps St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2003 12:00:00 AM | Permit Number 46416 | 6015133.81699265 | 2097838.73838627 | 37.7411159643244 | -122.39024332946 | (37.7411159643244, -122.39024332946) | |||
53299 | 53299 | 135061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010544.11345 | 2122214.47173 | 37.807790428346294 | -122.407831375437 | (37.8077904283463, -122.407831375437) | ||||
53442 | 53442 | 100041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005173.38835 | 2116375.3440799997 | 37.791455544677206 | -122.426002153097 | (37.7914555446772, -122.426002153097) | ||||
53530 | 53530 | 51095 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2222 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 10 | Permit Number 47552 | 6003035.98928 | 2117546.19682 | 37.7945493761991 | -122.43348121828998 | (37.7945493761991, -122.43348121829) | ||
54490 | 54490 | 50644 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2003 12:00:00 AM | 5 | Permit Number 47231 | 6012006.0214 | 2108580.87654 | 37.770437530508794 | -122.40181308980699 | (37.7704375305088, -122.401813089807) | ||
54721 | 54721 | 67290 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 951 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1993 12:00:00 AM | 17 | Permit Number 30766 | 6010838.87588 | 2112241.8184599997 | 37.780424425392795 | -122.40610822762599 | (37.7804244253928, -122.406108227626) | ||
54910 | 54910 | 62621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 57 Gilbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1986 12:00:00 AM | 2 | Permit Number 22933 | 6011606.60166 | 2109890.38648 | 37.77401084726829 | -122.40328682593201 | (37.7740108472683, -122.403286825932) | ||
55326 | 55326 | 114301 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6014021.33185 | 2111791.45089 | 37.779365307294704 | -122.395066984653 | (37.7793653072947, -122.395066984653) | ||||
55632 | 55632 | 106491 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1750 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6000889.8589 | 2111415.6802 | 37.7775945624662 | -122.440467186798 | (37.7775945624662, -122.440467186798) | ||||
55689 | 55689 | 195228 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 411 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.22721 | 2097932.95922 | 37.7411576029413 | -122.40373340589 | (37.7411576029413, -122.40373340589) | ||||
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) | |
56437 | 56437 | 114300 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 776923 | 6014014.05979 | 2111781.9059099997 | 37.7793386945555 | -122.39509147319401 | (37.7793386945555, -122.395091473194) | |||
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) | ||
56543 | 56543 | 135603 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014389.6268 | 2117668.08045 | 37.795521651247704 | -122.39420443049299 | (37.7955216512477, -122.394204430493) | ||||
57067 | 57067 | 97517 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2507 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6002046.23621 | 2117005.1615299997 | 37.7930076297441 | -122.436867133437 | (37.7930076297441, -122.436867133437) | ||||
57241 | 57241 | 59076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1108 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18375 | 5992152.58046 | 2111385.2012 | 37.7770094950493 | -122.470689876928 | (37.7770094950493, -122.470689876928) | ||
57503 | 57503 | 36750 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1625 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | 2 | Permit Number 39519 | 6006342.96894 | 2117604.3194 | 37.7948960342799 | -122.422042762784 | (37.7948960342799, -122.422042762784) | ||
57732 | 57732 | 51094 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2222 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2004 12:00:00 AM | 12 | Permit Number 47552 | 6003011.6002400005 | 2117543.81522 | 37.7945414531845 | -122.433565437092 | (37.7945414531845, -122.433565437092) | ||
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) | |
58203 | 58203 | 30450 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 9 | Permit Number 99 | 5999622.18885 | 2116719.4943 | 37.792085194227795 | -122.44523389245 | (37.7920851942278, -122.44523389245) | ||
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) | |
58585 | 58585 | 48696 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 8 | Permit Number 45976 | 6013986.850219999 | 2115260.07271 | 37.7888874289644 | -122.39542933770201 | (37.7888874289644, -122.395429337702) | ||
58626 | 58626 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.795905370388205 | -122.422808406898 | (37.7959053703882, -122.422808406898) | ||
58691 | 58691 | 55489 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 639 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 12 | Permit Number 11442 | 6003075.0038 | 2110517.2725 | 37.7752519393068 | -122.432843843081 | (37.7752519393068, -122.432843843081) | ||
59103 | 59103 | 113518 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6008870.90016 | 2113164.62052 | 37.782847949007895 | -122.41298166776899 | (37.7828479490079, -122.412981667769) | ||||
59152 | 59152 | 63342 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2016 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 13 | Permit Number 23916 | 6004374.9231 | 2117380.49328 | 37.794170270592495 | -122.42883651849701 | (37.7941702705925, -122.428836518497) | ||
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) | |
59260 | 59260 | 49222 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 6 | Permit Number 46300 | 6013637.56343 | 2115016.12085 | 37.788198160665004 | -122.39662072268801 | (37.788198160665, -122.396620722688) | ||
59396 | 59396 | 34893 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3750 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1997 12:00:00 AM | 11 | Permit Number 38499 | 5996896.06226 | 2115356.78929 | 37.7881875864303 | -122.454567781474 | (37.7881875864303, -122.454567781474) | ||
59633 | 59633 | 101739 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 21052 | 6006037.69001 | 2117962.7411 | 37.7958629475719 | -122.423124561776 | (37.7958629475719, -122.423124561776) | |||
59638 | 59638 | 135156 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009480.72759 | 2122523.69804 | 37.808579897317706 | -122.411533357278 | (37.8085798973177, -122.411533357278) | ||||
59669 | 59669 | 116819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.40819321595501 | (37.8062269882557, -122.408193215955) | ||||
59722 | 59722 | 34231 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 465 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Permit Number 38044 | 6011729.147580001 | 2110792.61182 | 37.7764949941843 | -122.40292638577101 | (37.7764949941843, -122.402926385771) | |||
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) | |
61001 | 61001 | 135157 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009451.25096 | 2122529.40055 | 37.808593901544796 | -122.411635772999 | (37.8085939015448, -122.411635772999) | ||||
61335 | 61335 | 69238 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3065 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1994 12:00:00 AM | 8 | Permit Number 33300 | 5999500.04973 | 2116654.01863 | 37.7918984428097 | -122.445651783104 | (37.7918984428097, -122.445651783104) | ||
61642 | 61642 | 53618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2522 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/26/1969 12:00:00 AM | 26 | Permit Number 6549 | 6004952.2721 | 2118323.36124 | 37.796791806958296 | -122.426906009529 | (37.7967918069583, -122.426906009529) | ||
62019 | 62019 | 60313 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 552 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 13 | Permit Number 19883 | 5999711.9897 | 2110460.8461 | 37.774905692759 | -122.444473179396 | (37.774905692759, -122.444473179396) | ||
62376 | 62376 | 195220 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 Phelps St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6015550.3471800005 | 2098396.8135900004 | 37.7426714191664 | -122.388842057332 | (37.7426714191664, -122.388842057332) | ||||
62451 | 62451 | 98194 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1050 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Permit Number 21173 | 6007982.534440001 | 2118936.0337099996 | 37.798644925686105 | -122.416463992045 | (37.7986449256861, -122.416463992045) | |||
62484 | 62484 | 48755 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 7 | Permit Number 776234 | 6015449.916019999 | 2113164.62035 | 37.783215059461604 | -122.390220832228 | (37.7832150594616, -122.390220832228) | ||
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) | |
63730 | 63730 | 178606 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989765.07873 | 2089203.5232 | 37.715966065363205 | -122.47732740025499 | (37.7159660653632, -122.477327400255) | ||||
63933 | 63933 | 61189 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1983 12:00:00 AM | 3 | Permit Number 21048 | 6006319.68281 | 2111476.60348 | 37.7780695245148 | -122.421687893883 | (37.7780695245148, -122.421687893883) | ||
63974 | 63974 | 40186 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2120 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 41372 | 6003368.97508 | 2117591.66308 | 37.794693101353204 | -122.432332294806 | (37.7946931013532, -122.432332294806) | |||
63994 | 63994 | 44016 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007905.045059999 | 2112739.90858 | 37.7816275276225 | -122.416293040805 | (37.7816275276225, -122.416293040805) | ||
64778 | 64778 | 55463 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 815 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 15 | Permit Number 11414 | 6003794.2329 | 2111079.9642 | 37.7768377182 | -122.43039602251001 | (37.7768377182, -122.43039602251) | ||
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) | ||
64993 | 64993 | 53281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 435 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/1969 12:00:00 AM | 7 | Permit Number 776923 | 6013979.24841 | 2111752.10583 | 37.7792549344058 | -122.39520981318998 | (37.7792549344058, -122.39520981319) | ||
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) | |
65347 | 65347 | 134973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009889.50127 | 2122368.35067 | 37.808176272591794 | -122.41010770071001 | (37.8081762725918, -122.41010770071) | ||||
65424 | 65424 | 55488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 635 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 12 | Permit Number 11441 | 6003079.6305 | 2110492.5969 | 37.7751844486333 | -122.43282607511401 | (37.7751844486333, -122.432826075114) | ||
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) | |
65743 | 65743 | 60040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 737 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1982 12:00:00 AM | 13 | Permit Number 19537 | 6010378.40566 | 2116154.02468 | 37.791140647073604 | -122.40797718609699 | (37.7911406470736, -122.407977186097) | ||
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) | |
66028 | 66028 | 30535 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1020 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.776812772940005 | -122.404779881684 | (37.77681277294, -122.404779881684) | |||
66159 | 66159 | 49227 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 10 | Permit Number 46300 | 6013617.05195 | 2114995.07224 | 37.7881392245044 | -122.396690213291 | (37.7881392245044, -122.396690213291) | ||
66351 | 66351 | 39225 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1651 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 9 | Permit Number 40868 | 5999865.937000001 | 2110874.4292 | 37.776050069404 | -122.443970367253 | (37.776050069404, -122.443970367253) | ||
66648 | 66648 | 31947 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2002 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | Permit Number 35358 | 6003915.74450462 | 2115298.16977388 | 37.7884267396179 | -122.43027669406 | (37.7884267396179, -122.43027669406) | |||
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) | |
67415 | 67415 | 135155 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009496.8532 | 2122519.11823 | 37.808568226806706 | -122.41147722608801 | (37.8085682268067, -122.411477226088) | ||||
67646 | 67646 | 60309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1751 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 11 | Permit Number 19879 | 5999434.8965 | 2110473.2275 | 37.7749238745851 | -122.44543259044501 | (37.7749238745851, -122.445432590445) | ||
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) | ||
68228 | 68228 | 135316 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 33x Battery St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012845.19135 | 2116083.76895 | 37.7910855411081 | -122.399437196994 | (37.7910855411081, -122.399437196994) | ||||
68996 | 68996 | 135143 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009614.4871 | 2122492.8917400003 | 37.8085028128125 | -122.41106826569799 | (37.8085028128125, -122.411068265698) | ||||
69182 | 69182 | 134802 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070 Lombard St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6007216.80949 | 2120218.74094 | 37.802123825306396 | -122.419204686742 | (37.8021238253064, -122.419204686742) |
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");