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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111681 | 111681 | 81908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484453999 | (37.7580580577361, -122.47378484454) | ||
| 113070 | 113070 | 51536 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 4138 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/2005 12:00:00 AM | Permit Number 47837 | 6002788.00139397 | 2104180.95255656 | 37.7578376687282 | -122.43338376260901 | (37.7578376687282, -122.433383762609) | ||
| 113954 | 113954 | 65803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | ||
| 114488 | 114488 | 62940 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 355 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23321 | 6006807.32064873 | 2097065.68374167 | 37.7385279621224 | -122.41897859484399 | (37.7385279621224, -122.418978594844) | ||
| 114576 | 114576 | 61288 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 402 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23284 | 6007176.62571904 | 2097268.48245659 | 37.739105591348704 | -122.417716082945 | (37.7391055913487, -122.417716082945) | ||
| 114879 | 114879 | 31913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | ||
| 114985 | 114985 | 69148 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | ||
| 115026 | 115026 | 34301 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1257 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38089 | 6010337.06875453 | 2101902.38195398 | 37.7520066112995 | -122.407115203053 | (37.7520066112995, -122.407115203053) | ||
| 115230 | 115230 | 52741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.750059574115895 | -122.46349050523399 | (37.7500595741159, -122.463490505234) | |||
| 115800 | 115800 | 68553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | ||
| 116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
| 117825 | 117825 | 41697 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 118047 | 118047 | 87776 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 333 Sussex St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129.0 | 2096659.0 | 37.737089918679 | -122.43858232139401 | (37.737089918679, -122.438582321394) | |||
| 118821 | 118821 | 47955 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 59 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2002 12:00:00 AM | Permit Number 45685 | 6001000.20919275 | 2101375.03881203 | 37.7500317183297 | -122.439365554728 | (37.7500317183297, -122.439365554728) | |||
| 118978 | 118978 | 60133 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2012 12:00:00 AM | Permit Number 768747 | 6003532.52706643 | 2096003.65082334 | 37.7354269125656 | -122.43022550454201 | (37.7354269125656, -122.430225504542) | ||
| 119254 | 119254 | 65260 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1153 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 28059 | 6009500.12226017 | 2102463.02471256 | 37.7534991381214 | -122.410049073844 | (37.7534991381214, -122.410049073844) | ||
| 119395 | 119395 | 51449 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 326 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | |||
| 119631 | 119631 | 46178 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 36 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44505 | 5998475.49358611 | 2106915.81544951 | 37.7651013119743 | -122.448495104116 | (37.7651013119743, -122.448495104116) | ||
| 120499 | 120499 | 41696 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42148 | 6001073.51924875 | 2096662.39464483 | 37.7370960833617 | -122.43877438618 | (37.7370960833617, -122.43877438618) | ||
| 120898 | 120898 | 62937 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 324 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23318 | 6006824.33458428 | 2097207.20889429 | 37.7389175168089 | -122.418929803603 | (37.7389175168089, -122.418929803603) | ||
| 121238 | 121238 | 62920 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23300 | 6007655.13385737 | 2096670.74814693 | 37.7374912602593 | -122.41601929597999 | (37.7374912602593, -122.41601929598) | ||
| 121441 | 121441 | 65810 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28778 | 5991729.56779327 | 2099841.10556299 | 37.7452879943861 | -122.471311880679 | (37.7452879943861, -122.471311880679) | ||
| 121572 | 121572 | 42999 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | |||
| 121588 | 121588 | 34344 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1325 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38101 | 6010099.44079349 | 2101484.52277039 | 37.7508459613928 | -122.40790749535499 | (37.7508459613928, -122.407907495355) | ||
| 121936 | 121936 | 94070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098.0 | 2095984.0 | 37.734949056945204 | -122.455927874303 | (37.7349490569452, -122.455927874303) | ||
| 121951 | 121951 | 41707 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42156 | 6002096.90165519 | 2096076.31860804 | 37.7355450223799 | -122.43519418820401 | (37.7355450223799, -122.435194188204) | ||
| 121976 | 121976 | 62909 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 414 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23286 | 6007271.29358338 | 2097254.92250183 | 37.739073685552896 | -122.41738780295601 | (37.7390736855529, -122.417387802956) | ||
| 123110 | 123110 | 62941 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 357 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23322 | 6006800.83841041 | 2097053.62300346 | 37.738494480992706 | -122.419000152151 | (37.7384944809927, -122.419000152151) | ||
| 123867 | 123867 | 32734 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 808 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37117 | 5995081.95862964 | 2089664.82981262 | 37.71753977051271 | -122.45898327191601 | (37.7175397705127, -122.458983271916) | ||
| 124193 | 124193 | 43803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.48200974609699 | (37.7733720498685, -122.482009746097) | ||
| 124557 | 124557 | 45120 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 125044 | 125044 | 46345 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 382 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44591 | 6005460.79581087 | 2101487.62598308 | 37.7505936931274 | -122.423948593876 | (37.7505936931274, -122.423948593876) | ||
| 125632 | 125632 | 65811 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | ||
| 126800 | 126800 | 65799 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.746750736934295 | -122.473717291816 | (37.7467507369343, -122.473717291816) | ||
| 127030 | 127030 | 69506 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 401 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33632 | 6008948.22977241 | 2096437.66011224 | 37.7369238689745 | -122.41153197478901 | (37.7369238689745, -122.411531974789) | ||
| 127085 | 127085 | 58683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 26 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23324 | 6006866.27520727 | 2097031.18211361 | 37.7384365478954 | -122.418772311755 | (37.7384365478954, -122.418772311755) | ||
| 127990 | 127990 | 62939 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 338 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23320 | 6006780.36050357 | 2097125.37030396 | 37.7386903299864 | -122.41907604266899 | (37.7386903299864, -122.419076042669) | ||
| 128328 | 128328 | 67340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2520 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1992 12:00:00 AM | Permit Number 30824 | 6011380.01787368 | 2101864.42331106 | 37.75196069589111 | -122.403505842523 | (37.7519606958911, -122.403505842523) | ||
| 128961 | 128961 | 54717 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 3609 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 24726 | 6004298.03079874 | 2103629.31683929 | 37.756408560199 | -122.428122138519 | (37.756408560199, -122.428122138519) | ||
| 129441 | 129441 | 94071 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 616 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53462 | 5996098.0 | 2095984.0 | 37.734949056945204 | -122.455927874303 | (37.7349490569452, -122.455927874303) | ||
| 131108 | 131108 | 63003 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1239 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23411 | 5983024.3565 | 2106665.5091 | 37.763518489811 | -122.501917412441 | (37.763518489811, -122.501917412441) | ||
| 138305 | 138305 | 39661 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41052 | 5995871.10695115 | 2090582.25350935 | 37.7201041317861 | -122.456321862645 | (37.7201041317861, -122.456321862645) | ||
| 138325 | 138325 | 72340 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 230 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51610 | 6000779.3756349 | 2094751.92568258 | 37.7318336416051 | -122.43965444861999 | (37.7318336416051, -122.43965444862) | ||
| 139248 | 139248 | 35403 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38858 | 6003059.40190018 | 2098358.03858994 | 37.7418647106265 | -122.432029345324 | (37.7418647106265, -122.432029345324) | ||
| 139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
| 139837 | 139837 | 65683 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 234 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28607 | 5994926.44798675 | 2095898.35261594 | 37.7346465797712 | -122.459972111851 | (37.7346465797712, -122.459972111851) | ||
| 140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
| 141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
| 141700 | 141700 | 37459 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 30 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39931 | 6010620.6907028 | 2100238.51379536 | 37.7474538625831 | -122.40601718747 | (37.7474538625831, -122.40601718747) | ||
| 142674 | 142674 | 94074 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 628 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2x4 | Permit Number 53464 | 5996021.0 | 2096021.0 | 37.7350462302618 | -122.456196763121 | (37.7350462302618, -122.456196763121) | ||
| 143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
| 143621 | 143621 | 45117 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 201 Buena Vista Ave East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43980 | 6001449.9 | 2108254.9 | 37.7689477239633 | -122.438303322299 | (37.7689477239633, -122.438303322299) | |||
| 145220 | 145220 | 64244 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 554 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33284 | 6005149.627474099 | 2111313.35504132 | 37.7775552357395 | -122.425723916077 | (37.7775552357395, -122.425723916077) | ||
| 145633 | 145633 | 47755 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 364St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2002 12:00:00 AM | Permit Number 45535 | 5994004.07072151 | 2099729.00956261 | 37.7451115153754 | -122.463438956035 | (37.7451115153754, -122.463438956035) | |||
| 146007 | 146007 | 87775 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 333 Sussex St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50481 | 6001129.0 | 2096659.0 | 37.737089918679 | -122.43858232139401 | (37.737089918679, -122.438582321394) | |||
| 146174 | 146174 | 40167 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 216 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | Permit Number 41360 | 5994849.72626239 | 2095987.73496493 | 37.7348875889443 | -122.46024383672199 | (37.7348875889443, -122.460243836722) | ||
| 151022 | 151022 | 95110 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 649 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 54039 | 6001693.52474 | 2093271.82828 | 37.7278216210543 | -122.436388158988 | (37.7278216210543, -122.436388158988) |
| 160564 | 160564 | 31753 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | |
| 163888 | 163888 | 38590 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1614 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40545 | 6015168.4288 | 2094722.1342 | 37.732560324707705 | -122.38990600380698 | (37.7325603247077, -122.389906003807) | |
| 165172 | 165172 | 50986 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1120REVISED Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2004 12:00:00 AM | 6 | Permit Number 47576 | 6007503.31376 | 2119893.93908 | 37.801248132044 | -122.418190201138 | (37.801248132044, -122.418190201138) | ||
| 168083 | 168083 | 32398 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 244 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36939 | 6005971.23324 | 2096091.5920900002 | 37.7358062077876 | -122.42180021560199 | (37.7358062077876, -122.421800215602) | |
| 173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
| 174016 | 174016 | 65967 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | |
| 176558 | 176558 | 38592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1618 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 2 | Permit Number 40547 | 6015152.7308 | 2094735.8699 | 37.7325971695789 | -122.389961235194 | (37.7325971695789, -122.389961235194) | |
| 179097 | 179097 | 30759 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1563 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 5 | Permit Number 48354 | 6014932.9973 | 2093776.0212 | 37.7299494300904 | -122.39065386327499 | (37.7299494300904, -122.390653863275) | |
| 180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
| 184245 | 184245 | 50918 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | |
| 185933 | 185933 | 47492 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 657 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45386 | 6001676.19021 | 2093232.03842 | 37.7277113821718 | -122.43644523806499 | (37.7277113821718, -122.436445238065) | |
| 186544 | 186544 | 63000 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.763284575331795 | -122.50189769196899 | (37.7632845753318, -122.501897691969) | ||
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | ||
| 553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
| 1013 | 1013 | 223102 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 247 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779888 | 6004283.79281 | 2099537.35517 | 37.74517218196571 | -122.42787981341101 | (37.7451721819657, -122.427879813411) | |
| 2031 | 2031 | 251786 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2017 12:00:00 AM | 3 | 3x3 | 6006195.0 | 2098242.0 | 37.7417233638646 | -122.42117921336501 | (37.7417233638646, -122.421179213365) | ||
| 3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
| 7079 | 7079 | 108929 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 12x MacOndray Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008556.45633 | 2119171.5746400002 | 37.79932392101129 | -122.41449470968399 | (37.7993239210113, -122.414494709684) | |||
| 9865 | 9865 | 122387 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779324 | 5994732.0 | 2099337.0 | 37.7440770679838 | -122.460893516037 | (37.7440770679838, -122.460893516037) | |||
| 22356 | 22356 | 223022 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6006257.519669999 | 2099541.04409 | 37.745293770294104 | -122.42105525588998 | (37.7452937702941, -122.42105525589) | |||
| 23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
| 24031 | 24031 | 206557 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995503.23656 | 2100160.4413400004 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | |||
| 24597 | 24597 | 206648 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994513.85188 | 2100887.12446 | 37.748320765087 | -122.46176019139799 | (37.748320765087, -122.461760191398) | |||
| 25120 | 25120 | 206614 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 432 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995034.15561 | 2100336.79731 | 37.7468396428317 | -122.45992114704399 | (37.7468396428317, -122.459921147044) | |||
| 25122 | 25122 | 206533 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5995361.50595 | 2093791.16395 | 37.7288857636427 | -122.45831551006201 | (37.7288857636427, -122.458315510062) | |||
| 25180 | 25180 | 126376 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 122 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001336.2876 | 2121154.5777 | 37.8043604581295 | -122.43962119477399 | (37.8043604581295, -122.439621194774) | |||
| 25265 | 25265 | 223034 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 578 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007664.494030001 | 2096661.03983 | 37.7374651296141 | -122.41598624606199 | (37.7374651296141, -122.415986246062) | |||
| 25343 | 25343 | 183040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | |||
| 26518 | 26518 | 206504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.46661639913602 | (37.7517116786758, -122.466616399136) | |||
| 26843 | 26843 | 206525 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | |||
| 27341 | 27341 | 206556 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | |||
| 27743 | 27743 | 206657 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | |||
| 27805 | 27805 | 206612 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 49 Sola Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994889.66342 | 2100721.49656 | 37.7478876192364 | -122.460448654307 | (37.7478876192364, -122.460448654307) | |||
| 28309 | 28309 | 206505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993138.76599 | 2102124.2403700002 | 37.7516383146611 | -122.46660507218701 | (37.7516383146611, -122.466605072187) | |||
| 29329 | 29329 | 206551 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994320.14066 | 2100781.15308 | 37.74801864146029 | -122.462422349606 | (37.7480186414603, -122.462422349606) | |||
| 29530 | 29530 | 218122 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | |||
| 29674 | 29674 | 206651 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.63767 | 2100971.03236 | 37.7485509699531 | -122.461777389118 | (37.7485509699531, -122.461777389118) | |||
| 29986 | 29986 | 206673 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 370 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995261.57654 | 2095226.1050200001 | 37.7328200206111 | -122.45876481406201 | (37.7328200206111, -122.458764814062) | |||
| 30002 | 30002 | 206592 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993721.8716 | 2099672.6551599996 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | |||
| 30299 | 30299 | 206560 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995304.48103 | 2095229.25095 | 37.7328311245367 | -122.458616711016 | (37.7328311245367, -122.458616711016) |
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");