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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13898 | 13898 | 30637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008025.7883 | 2108500.0528 | 37.7699926802506 | -122.415575048334 | (37.7699926802506, -122.415575048334) | |
| 13999 | 13999 | 10614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2001 12:00:00 AM | 3 | 3X3 | 6016916.49156 | 2095577.9947400002 | 37.7350071358711 | -122.383922043589 | (37.7350071358711, -122.383922043589) | ||
| 14063 | 14063 | 30634 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008069.1402 | 2108631.1108 | 37.770354971481794 | -122.415434374116 | (37.7703549714818, -122.415434374116) | |
| 14099 | 14099 | 11466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.967569999 | 2095560.66167 | 37.73495227093311 | -122.384375566285 | (37.7349522709331, -122.384375566285) | ||
| 14147 | 14147 | 11467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 8 | 3X3 | 6016799.4589 | 2095596.1573400002 | 37.7350505362442 | -122.384327935502 | (37.7350505362442, -122.384327935502) | ||
| 14210 | 14210 | 11472 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6016881.34744 | 2095602.56066 | 37.7350726460825 | -122.384045260583 | (37.7350726460825, -122.384045260583) | |||
| 14222 | 14222 | 16526 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | ||
| 14424 | 14424 | 6845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6015936.9719 | 2097716.00593 | 37.7408234823092 | -122.38745772460899 | (37.7408234823092, -122.387457724609) | ||
| 14570 | 14570 | 16549 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015994.10911 | 2097882.11034 | 37.7412827355083 | -122.38727174751001 | (37.7412827355083, -122.38727174751) | |||
| 14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
| 14845 | 14845 | 30632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008058.1142 | 2108604.0472 | 37.770280041456104 | -122.415470596847 | (37.7702800414561, -122.415470596847) | |
| 14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
| 14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
| 15012 | 15012 | 85551 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 288 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 3 | 6008109.65239 | 2108844.36385 | 37.7709427912139 | -122.41530934075199 | (37.7709427912139, -122.415309340752) | |||
| 15047 | 15047 | 30638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008054.606000001 | 2108589.5131 | 37.7702399370436 | -122.415481702601 | (37.7702399370436, -122.415481702601) | |
| 15074 | 15074 | 11468 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 6 | 3X3 | 6016817.53474 | 2095601.45988 | 37.735066095427705 | -122.384265809434 | (37.7350660954277, -122.384265809434) | ||
| 15083 | 15083 | 30628 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008014.7624 | 2108466.4739 | 37.769899860698295 | -122.415610809035 | (37.7698998606983, -122.415610809035) | |
| 15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
| 15334 | 15334 | 30635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008075.6555 | 2108643.1391 | 37.770388364567104 | -122.41541268929899 | (37.7703883645671, -122.415412689299) | |
| 15354 | 15354 | 30627 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008040.0718 | 2108546.913 | 37.770122150229 | -122.41552895995899 | (37.770122150229, -122.415528959959) | |
| 15489 | 15489 | 30626 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 769481 | 6008034.8095 | 2108530.1235 | 37.7700757544141 | -122.415545973379 | (37.7700757544141, -122.415545973379) | |
| 15644 | 15644 | 16542 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016097.47551 | 2098025.0219 | 37.741680865376 | -122.386924304309 | (37.741680865376, -122.386924304309) | |||
| 15847 | 15847 | 11469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 39X Hawkins Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/1992 12:00:00 AM | 9 | 3X3 | 6016835.012019999 | 2095606.77415 | 37.735081653692 | -122.38420575361401 | (37.735081653692, -122.384205753614) | ||
| 15981 | 15981 | 16561 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6015590.528940001 | 2097333.28077 | 37.739753403296206 | -122.388628895503 | (37.7397534032962, -122.388628895503) | ||
| 16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
| 16023 | 16023 | 30631 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008010.753 | 2108447.9304 | 37.769848719225294 | -122.415623364383 | (37.7698487192253, -122.415623364383) | |
| 16359 | 16359 | 30629 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008019.272999999 | 2108482.0104 | 37.7699427738264 | -122.415596307092 | (37.7699427738264, -122.415596307092) | |
| 16412 | 16412 | 30636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47466 | 6008078.6625 | 2108652.1603 | 37.770413303673394 | -122.4154029268 | (37.7704133036734, -122.4154029268) |
| 16542 | 16542 | 6847 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3x3 | 6015962.97666 | 2097752.7883599997 | 37.7409259196071 | -122.38737037433701 | (37.7409259196071, -122.387370374337) | ||
| 16955 | 16955 | 15610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006029.1794 | 2098644.8095 | 37.742820038399 | -122.421781171739 | (37.742820038399, -122.421781171739) | ||
| 17097 | 17097 | 15580 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006815.4591 | 2099977.9757 | 37.746524922000205 | -122.41915697739401 | (37.7465249220002, -122.419156977394) | ||
| 17233 | 17233 | 16673 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002873.2969 | 2106860.8212200003 | 37.7652007800214 | -122.43328026297701 | (37.7652007800214, -122.433280262977) | |||
| 17348 | 17348 | 4322 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 752 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002136.242880001 | 2095781.1252 | 37.7347367232032 | -122.435037065224 | (37.7347367232032, -122.435037065224) | |||
| 17704 | 17704 | 15609 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006037.9197 | 2098666.6602 | 37.742880528375395 | -122.42175250189501 | (37.7428805283754, -122.421752501895) | ||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 18016 | 18016 | 49368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.40492785111799 | (37.7149060701976, -122.404927851118) | |||
| 18483 | 18483 | 66408 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | ||
| 18752 | 18752 | 10423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1401 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999371.8264 | 2108722.9096 | 37.7701143458549 | -122.44552487423 | (37.7701143458549, -122.44552487423) | |||
| 18926 | 18926 | 15619 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | ||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 19275 | 19275 | 34240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 19622 | 19622 | 63665 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.747527435901496 | -122.428684519984 | (37.7475274359015, -122.428684519984) | ||
| 19876 | 19876 | 10381 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.770439708466604 | -122.44410719203998 | (37.7704397084666, -122.44410719204) | |||
| 20207 | 20207 | 4337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.188490001 | 2095960.05903 | 37.735191840439896 | -122.437252384095 | (37.7351918404399, -122.437252384095) | ||
| 20299 | 20299 | 63295 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.746825514117205 | -122.41453511521401 | (37.7468255141172, -122.414535115214) | ||
| 20482 | 20482 | 15620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3529 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005636.1083 | 2097793.1908 | 37.740459511674 | -122.423079784271 | (37.740459511674, -122.423079784271) | ||
| 20547 | 20547 | 15616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3461 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6005827.515 | 2098142.9917 | 37.741430785549205 | -122.422442822684 | (37.7414307855492, -122.422442822684) | ||
| 20573 | 20573 | 15605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3349 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2000 12:00:00 AM | 6 | 3X3 | 6006192.9166 | 2098824.6926 | 37.743323189063 | -122.42122778433998 | (37.743323189063, -122.42122778434) | ||
| 21028 | 21028 | 15622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3535 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005607.2671 | 2097740.6765 | 37.7403136916677 | -122.423175774097 | (37.7403136916677, -122.423175774097) | ||
| 21266 | 21266 | 15611 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3361 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2001 12:00:00 AM | 7 | 3X3 | 6006103.7046 | 2098658.8645 | 37.7428628326579 | -122.421524482148 | (37.7428628326579, -122.421524482148) | ||
| 21620 | 21620 | 16672 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002863.164369999 | 2106910.32472 | 37.765336129770105 | -122.43331884658001 | (37.7653361297701, -122.43331884658) | |||
| 21828 | 21828 | 15579 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3159 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/1998 12:00:00 AM | 6 | 3X3 | 6006811.7424 | 2099968.3124 | 37.7464981794513 | -122.419169144026 | (37.7464981794513, -122.419169144026) | ||
| 21886 | 21886 | 15583 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3177 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1999 12:00:00 AM | 3 | 3X3 | 6006726.259 | 2099810.7255 | 37.7460606669612 | -122.419453558792 | (37.7460606669612, -122.419453558792) | ||
| 21940 | 21940 | 10478 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5998139.6149 | 2108553.6282 | 37.7695791194599 | -122.44977485921801 | (37.7695791194599, -122.449774859218) | |||
| 21988 | 21988 | 15585 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3181 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2000 12:00:00 AM | 6 | 3X3 | 6006711.3923 | 2099783.2222 | 37.7459843117401 | -122.419503015091 | (37.7459843117401, -122.419503015091) | ||
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 24092 | 24092 | 40635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2577 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | 1 | Permit Number 41635 | 5999855.0848 | 2113645.9018 | 37.7836592022764 | -122.44420710871401 | (37.7836592022764, -122.444207108714) | ||
| 24671 | 24671 | 58732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2385 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | ||
| 25779 | 25779 | 32030 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3321 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 13 | Permit Number 35417 | 6004551.31558 | 2106568.33958 | 37.764492746462395 | -122.42745555912701 | (37.7644927464624, -122.427455559127) | ||
| 27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
| 27408 | 27408 | 85487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010399.4592 | 2092794.41628 | 37.727001587734605 | -122.40625779115801 | (37.7270015877346, -122.406257791158) | ||
| 27678 | 27678 | 68339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 410 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32156 | 5991257.09324 | 2112608.74204 | 37.7803171779643 | -122.47387689925101 | (37.7803171779643, -122.473876899251) | |
| 28455 | 28455 | 21731 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.511404401 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | ||
| 28850 | 28850 | 110361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335318996 | -122.41486676369699 | (37.790269335319, -122.414866763697) | ||||
| 30146 | 30146 | 44337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.020719999 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | ||
| 30941 | 30941 | 88552 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 649 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.5415199995 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | ||
| 31313 | 31313 | 56220 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 483 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 10 | Permit Number 12342 | 5990901.62894 | 2112114.24855 | 37.7789388399986 | -122.475070494342 | (37.7789388399986, -122.475070494342) | ||
| 31500 | 31500 | 69354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | |
| 31714 | 31714 | 46872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | |
| 32007 | 32007 | 83299 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 25 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52357 | 6014332.78372 | 2094054.3132099998 | 37.7306802456855 | -122.39274835074801 | (37.7306802456855, -122.392748350748) | |
| 32762 | 32762 | 96718 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2011 12:00:00 AM | 8 | Permit Number 767223 | 6008240.6871 | 2116926.6734700003 | 37.79314223396489 | -122.415428369639 | (37.7931422339649, -122.415428369639) | ||
| 34565 | 34565 | 58091 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1750 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 2 | Permit Number 53771 | 6006613.15875288 | 2116850.06123449 | 37.7928402647887 | -122.42105428501101 | (37.7928402647887, -122.421054285011) | ||
| 36622 | 36622 | 102487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2001 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999337.8085 | 2111150.0142 | 37.7767766147896 | -122.445817121147 | (37.7767766147896, -122.445817121147) | |||
| 36878 | 36878 | 81916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.1897900002 | 37.731380822071706 | -122.396990173153 | (37.7313808220717, -122.396990173153) | |
| 37696 | 37696 | 32199 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1516 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35524 | 6009302.4465 | 2100450.1305 | 37.7479610974423 | -122.410590548539 | (37.7479610974423, -122.410590548539) | ||
| 38406 | 38406 | 46422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 708 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2002 12:00:00 AM | 1 | Permit Number 44644 | 5992896.66955 | 2110586.4046099996 | 37.7748592156207 | -122.468057745767 | (37.7748592156207, -122.468057745767) | ||
| 39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
| 39723 | 39723 | 73566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51073 | 6015551.1974 | 2096459.91912 | 37.737353150531504 | -122.388703936761 | (37.7373531505315, -122.388703936761) | |
| 40517 | 40517 | 31313 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/2004 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.776615227251604 | -122.428078115713 | (37.7766152272516, -122.428078115713) | |
| 41173 | 41173 | 49397 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451@ PACIFIC Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2003 12:00:00 AM | 4 | Permit Number 46412 | 6008850.17473 | 2117891.03277 | 37.7958243657476 | -122.413387728783 | (37.7958243657476, -122.413387728783) | ||
| 41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
| 41805 | 41805 | 81939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
| 42748 | 42748 | 89044 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51783 | 6002618.0 | 2096049.0 | 37.735499589249294 | -122.433390603486 | (37.7354995892493, -122.433390603486) | ||||
| 43027 | 43027 | 94791 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.79098101110971 | -122.450877583428 | (37.7909810111097, -122.450877583428) | ||
| 43050 | 43050 | 83178 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.0684599997 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | |
| 44512 | 44512 | 38662 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 834 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40585 | 6001015.5346 | 2111586.9168 | 37.778071890037 | -122.440044714881 | (37.778071890037, -122.440044714881) |
| 44571 | 44571 | 7356 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.79079460631979 | -122.434307574482 | (37.7907946063198, -122.434307574482) | ||
| 45559 | 45559 | 48873 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.2879800005 | 2120850.1065700003 | 37.8041127290715 | -122.40349528428001 | (37.8041127290715, -122.40349528428) | |
| 45610 | 45610 | 42453 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | ||
| 45655 | 45655 | 50668 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 4 | Permit Number 47247 | 6002421.15482 | 2119020.4799599997 | 37.7985624722307 | -122.43571414861401 | (37.7985624722307, -122.435714148614) | ||
| 45995 | 45995 | 61372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3240 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32977 | 5999005.452409999 | 2119937.7850900004 | 37.800886538035996 | -122.447599568972 | (37.800886538036, -122.447599568972) | |
| 46447 | 46447 | 69353 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1337 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33444 | 6004896.60555 | 2120531.0120900003 | 37.8028503021536 | -122.42725596539302 | (37.8028503021536, -122.427255965393) | |
| 46752 | 46752 | 121094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x3 | 6001082.7006 | 2111393.2018 | 37.777543821113206 | -122.43979847194099 | (37.7775438211132, -122.439798471941) | ||
| 46895 | 46895 | 88581 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 515 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.701169999 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | ||
| 47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
| 48288 | 48288 | 49992 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 300@ GOUGH Linden St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2003 12:00:00 AM | 6 | Permit Number 46733 | 6005873.634 | 2110881.2484 | 37.7764096614269 | -122.42318860884 | (37.7764096614269, -122.42318860884) | ||
| 48550 | 48550 | 80106 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2522 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50838 | 5999743.6705599995 | 2119517.2337 | 37.7997739777354 | -122.44501478161501 | (37.7997739777354, -122.445014781615) | |
| 48558 | 48558 | 31312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 49629 | 49629 | 88476 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51429 | 6015551.7 | 2096433.9 | 37.7372817351758 | -122.38870038321801 | (37.7372817351758, -122.388700383218) |
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");