Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
| 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) | |
| 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) |
| 177495 | 177495 | 73449 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 238 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6004263.46084 | 2092033.9823200002 | 37.724568462935295 | -122.427415688595 | (37.7245684629353, -122.427415688595) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 108729 | 108729 | 67498 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 69 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/1992 12:00:00 AM | Permit Number 31026 | 5999574.85237964 | 2093753.94204942 | 37.729024779719296 | -122.443747050581 | (37.7290247797193, -122.443747050581) | ||
| 112974 | 112974 | 35946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 41 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 14 | 3x3 | Permit Number 39108 | 6005372.49697946 | 2095946.00487356 | 37.735372674911794 | -122.423859934844 | (37.7353726749118, -122.423859934844) |
| 104054 | 104054 | 66443 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 264 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29588 | 6006134.75187193 | 2096071.1969529998 | 37.735759427282794 | -122.421233418823 | (37.7357594272828, -122.421233418823) | ||
| 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) | ||
| 107360 | 107360 | 59569 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 515 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1981 12:00:00 AM | Permit Number 18959 | 6007497.22787602 | 2096469.08485294 | 37.736928657886 | -122.416550971645 | (37.736928657886, -122.416550971645) | ||
| 100641 | 100641 | 35962 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 719 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39119 | 6006179.07751464 | 2096674.29231523 | 37.7374178918343 | -122.421122977478 | (37.7374178918343, -122.421122977478) | ||
| 145847 | 145847 | 35963 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 725 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39120 | 6006183.36687276 | 2096689.94056482 | 37.737461100246 | -122.421109257926 | (37.737461100246, -122.421109257926) | ||
| 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) | ||
| 126041 | 126041 | 66248 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 420 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29348 | 5998199.25960991 | 2097894.34900813 | 37.7403147945895 | -122.448800667322 | (37.7403147945895, -122.448800667322) | ||
| 139661 | 139661 | 65672 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 410 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28592 | 5998124.07489546 | 2097968.25589153 | 37.7405134253056 | -122.44906594777201 | (37.7405134253056, -122.449065947772) | ||
| 144615 | 144615 | 66262 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 406 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29365 | 5998101.39168775 | 2098008.15814258 | 37.7406216899064 | -122.449147251035 | (37.7406216899064, -122.449147251035) | ||
| 100124 | 100124 | 33521 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 158 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45091 | 6007330.47035939 | 2098150.25569742 | 37.7415354012679 | -122.417246624804 | (37.7415354012679, -122.417246624804) | ||
| 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) | ||
| 114398 | 114398 | 46946 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 127994 | 127994 | 46947 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 153 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44985 | 5994958.35938136 | 2099473.23283552 | 37.7444641515166 | -122.46012068892401 | (37.7444641515166, -122.460120688924) | ||
| 110199 | 110199 | 64813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4180 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25816 | 6002719.62946943 | 2100377.06444205 | 37.7473892155106 | -122.43334840813999 | (37.7473892155106, -122.43334840814) | ||
| 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) | ||
| 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) | ||
| 104213 | 104213 | 31533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 3 | 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) | ||
| 109882 | 109882 | 31532 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 2 | 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) | ||
| 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) | |
| 141025 | 141025 | 62111 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3356 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1985 12:00:00 AM | Permit Number 22211 | 6006696.74836366 | 2102059.40313392 | 37.752233362336504 | -122.419715127552 | (37.7522333623365, -122.419715127552) | ||
| 94470 | 94470 | 36935 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39575 | 6000638.31499457 | 2102274.13435128 | 37.7524798164389 | -122.44068148430401 | (37.7524798164389, -122.440681484304) | ||
| 160953 | 160953 | 31488 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1014 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35052 | 6003120.510980001 | 2102286.73127 | 37.7526554461029 | -122.43209853943 | (37.7526554461029, -122.43209853943) | |
| 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) | ||
| 119189 | 119189 | 61852 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1111 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32348 | 6010289.45166146 | 2102742.39978594 | 37.7543104490633 | -122.407339083447 | (37.7543104490633, -122.407339083447) | ||
| 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) |
| 99983 | 99983 | 53922 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 895 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18975 | 6003136.7326551 | 2103038.00960948 | 37.7547191980802 | -122.43209608734101 | (37.7547191980802, -122.432096087341) | ||
| 124497 | 124497 | 61101 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3075 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20942 | 6007791.37418994 | 2103237.58364273 | 37.7555299798671 | -122.41601315723999 | (37.7555299798671, -122.41601315724) | ||
| 99219 | 99219 | 61100 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3068 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20941 | 6007825.69478663 | 2103291.55994407 | 37.7556801160389 | -122.41589828768 | (37.7556801160389, -122.41589828768) | ||
| 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) | |
| 116752 | 116752 | 68518 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1722 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32398 | 5993753.19333564 | 2103765.68848708 | 37.756180747574 | -122.46459949821501 | (37.756180747574, -122.464599498215) | ||
| 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) | |
| 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) | |
| 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) | ||
| 126895 | 126895 | 52240 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 637 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/2005 12:00:00 AM | 14 | Permit Number 48411 | 6014148.51957 | 2104183.0375599996 | 37.758481362245 | -122.394094197011 | (37.758481362245, -122.394094197011) | |
| 167517 | 167517 | 81822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 953 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 2 | 6014995.08745 | 2104204.61069 | 37.7585876135316 | -122.391167870527 | (37.7585876135316, -122.391167870527) | ||
| 135465 | 135465 | 32767 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 921 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 10 | Permit Number 37273 | 6015272.11857 | 2104284.39215 | 37.758822046111 | -122.390215337371 | (37.758822046111, -122.390215337371) | |
| 120768 | 120768 | 41659 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Caselli Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42128 | 5999720.90250233 | 2104674.14058563 | 37.759017358484 | -122.44402647097999 | (37.759017358484, -122.44402647098) | ||
| 142966 | 142966 | 41660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 328 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42128 | 5999720.90250233 | 2104674.14058563 | 37.759017358484 | -122.44402647097999 | (37.759017358484, -122.44402647098) | ||
| 186673 | 186673 | 78599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1721 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 6 | 6012838.148159999 | 2104697.96448 | 37.7598223206635 | -122.39866221248501 | (37.7598223206635, -122.398662212485) | ||
| 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) | ||
| 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) | ||||
| 97721 | 97721 | 121306 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 98600 | 98600 | 121303 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 120943 | 120943 | 121302 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 122264 | 122264 | 39273 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40884 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||
| 124539 | 124539 | 121304 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3001 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009003.87535313 | 2104948.94428491 | 37.7602970843939 | -122.411940867318 | (37.7602970843939, -122.411940867318) | ||||
| 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) | |
| 103609 | 103609 | 39626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 1550 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | ||
| 104147 | 104147 | 39629 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 3 | 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) | |
| 122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
| 169920 | 169920 | 37960 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015229.736819999 | 2105103.5126900002 | 37.7610688241989 | -122.39041914714501 | (37.7610688241989, -122.390419147145) | |
| 130760 | 130760 | 37958 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40528 | 6015227.3668599995 | 2105129.80279 | 37.7611408796801 | -122.39042918086399 | (37.7611408796801, -122.390429180864) | |
| 174592 | 174592 | 37957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015227.61132 | 2105153.8731400003 | 37.7612069852338 | -122.390430017258 | (37.7612069852338, -122.390430017258) | |
| 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) | |
| 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) | |
| 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) | |
| 137073 | 137073 | 37959 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40192 | 6015221.8904099995 | 2105253.72993 | 37.7614808530901 | -122.390456781078 | (37.7614808530901, -122.390456781078) | |
| 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) | |
| 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) | ||
| 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) | |
| 100738 | 100738 | 36733 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 25 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39512 | 6006708.40451425 | 2105838.69711633 | 37.7626110859988 | -122.419942981677 | (37.7626110859988, -122.419942981677) | ||
| 132866 | 132866 | 32609 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3200 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37075 | 5985785.2482 | 2106404.8747 | 37.762964658627 | -122.492349308745 | (37.762964658627, -122.492349308745) | |
| 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) | |
| 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) | |||
| 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) |
| 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) |
| 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) |
| 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) |
| 103088 | 103088 | 39281 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 4 | 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) |
| 103260 | 103260 | 39309 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 16 | 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) |
| 103269 | 103269 | 39283 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 6 | 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) |
| 104913 | 104913 | 39282 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 5 | 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) |
| 111712 | 111712 | 39291 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 12 | 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) |
| 120184 | 120184 | 39310 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 399X Treat Ave | 17 | 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) |
| 122352 | 122352 | 39280 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 3 | 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) |
| 127563 | 127563 | 39288 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 9 | 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) |
| 140371 | 140371 | 39307 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 13 | 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) |
| 142155 | 142155 | 39289 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 10 | 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) |
| 143495 | 143495 | 39290 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2030 Harrison St | 11 | 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) |
| 99100 | 99100 | 65903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1252 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1990 12:00:00 AM | Permit Number 28911 | 5993641.91878652 | 2106971.45186237 | 37.7649765235495 | -122.46521716349702 | (37.7649765235495, -122.465217163497) | ||
| 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) | |
| 125807 | 125807 | 39528 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 17th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40969 | 6012854.83375701 | 2106613.68395322 | 37.765083392480605 | -122.398738948997 | (37.7650833924806, -122.398738948997) | ||
| 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) | ||
| 175251 | 175251 | 116387 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 3x3 | 6012828.85686 | 2106647.76969 | 37.765175536957 | -122.398831189703 | (37.765175536957, -122.398831189703) | ||
| 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) | ||
| 156551 | 156551 | 116385 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 13 | 3x3 | 6012828.15068 | 2106679.17539 | 37.76526173067471 | -122.398835836532 | (37.7652617306747, -122.398835836532) | ||
| 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) |
| 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) | |
| 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) |
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");