Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46325 | 46325 | 82058 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5988935.079 | 2097218.8486 | 37.737925915904896 | -122.480782703185 | (37.7379259159049, -122.480782703185) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 86060 | 86060 | 102208 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 95438 | 95438 | 120638 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 538 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6000640.47849283 | 2110797.5063283 | 37.7758830107493 | -122.441285509617 | (37.7758830107493, -122.441285509617) | |||
| 104136 | 104136 | 102207 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 105260 | 105260 | 112392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4331 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001612.33019827 | 2105235.34197744 | 37.760665996510895 | -122.437525222221 | (37.7606659965109, -122.437525222221) | |||
| 107961 | 107961 | 113411 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1642 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5991208.59288317 | 2104157.90962907 | 37.757110661532 | -122.47342811182301 | (37.757110661532, -122.473428111823) | ||||
| 118136 | 118136 | 111452 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1399x EUGENIA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008618.0 | 2097694.0 | 37.740354975205896 | -122.412762522808 | (37.7403549752059, -122.412762522808) | |||
| 119343 | 119343 | 116699 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1X CARRIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002805.0 | 2095529.0 | 37.734082395521895 | -122.43270694044399 | (37.7340823955219, -122.432706940444) | ||||
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 125650 | 125650 | 102209 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89X Elgin Park | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 30082 | 6005852.4 | 2108559.9 | 37.7700345996314 | -122.42309702584299 | (37.7700345996314, -122.423097025843) | |
| 140278 | 140278 | 116700 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1X CARRIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002805.0 | 2095529.0 | 37.734082395521895 | -122.43270694044399 | (37.7340823955219, -122.432706940444) | ||||
| 180063 | 180063 | 83723 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986042.1421 | 2100161.1312 | 37.7458360633129 | -122.491001322638 | (37.7458360633129, -122.491001322638) | |||
| 180505 | 180505 | 79189 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5988574.1949 | 2099905.7282 | 37.745282400553 | -122.482227237552 | (37.745282400553, -122.482227237552) | |||
| 94868 | 94868 | 67853 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31523 | 6004481.54507681 | 2099889.33165024 | 37.746149813516105 | -122.427221086938 | (37.7461498135161, -122.427221086938) | ||
| 120615 | 120615 | 67852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31522 | 6004496.90560411 | 2099838.13293501 | 37.7460101023043 | -122.42716432594901 | (37.7460101023043, -122.427164325949) | ||
| 36002 | 36002 | 38898 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.78331765575871 | -122.45461255567301 | (37.7833176557587, -122.454612555673) | |
| 79831 | 79831 | 64805 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1425 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25804 | 6003950.13397491 | 2099979.34039052 | 37.7463668898084 | -122.429065055592 | (37.7463668898084, -122.429065055592) | ||
| 95373 | 95373 | 64797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 481 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25796 | 6003405.20909868 | 2100070.2281285 | 37.746585585058206 | -122.43095582691299 | (37.7465855850582, -122.430955826913) | ||
| 98866 | 98866 | 39747 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 327 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41113 | 6003495.51730574 | 2104461.26600513 | 37.758647456738295 | -122.430956883962 | (37.7586474567383, -122.430956883962) | ||
| 109855 | 109855 | 39696 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1799 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41081 | 5993099.16254286 | 2103247.37766715 | 37.754719874470204 | -122.466823662995 | (37.7547198744702, -122.466823662995) | ||
| 128893 | 128893 | 32852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41115 | 6001471.9166257 | 2102062.60736984 | 37.751946450075394 | -122.437783607007 | (37.7519464500754, -122.437783607007) | ||
| 72111 | 72111 | 69039 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1465 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 3 | Permit Number 33045 | 5984314.5522 | 2105205.1639 | 37.759584498582896 | -122.497347291362 | (37.7595844985829, -122.497347291362) | |
| 162516 | 162516 | 69047 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3627 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 1 | Permit Number 33054 | 5984427.5354 | 2106304.0281 | 37.762608292752105 | -122.497037654386 | (37.7626082927521, -122.497037654386) | |
| 138003 | 138003 | 70633 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 1 | 3x3 | 6003062.45597 | 2090620.0521099998 | 37.720618125211 | -122.43146651207898 | (37.720618125211, -122.431466512079) | |
| 156668 | 156668 | 70126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.9090200001 | 37.720567588703105 | -122.43150910488701 | (37.7205675887031, -122.431509104887) |
| 78748 | 78748 | 39753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 98400 | 98400 | 39755 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 121128 | 121128 | 39754 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 183 Hancock St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41121 | 6003118.27900273 | 2105026.07032459 | 37.7601768917443 | -122.432301882241 | (37.7601768917443, -122.432301882241) | ||
| 126386 | 126386 | 39765 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 668 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41131 | 6003653.48498832 | 2104383.93868728 | 37.758444083814794 | -122.430405042836 | (37.7584440838148, -122.430405042836) | ||
| 127367 | 127367 | 39751 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 168 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41119 | 6003201.65884895 | 2105082.75168604 | 37.7603372525468 | -122.432017558659 | (37.7603372525468, -122.432017558659) | ||
| 94866 | 94866 | 65546 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Miraloma Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1990 12:00:00 AM | Permit Number 28444 | 5994944.36362996 | 2097551.3890881 | 37.7391864412629 | -122.460029884731 | (37.7391864412629, -122.460029884731) | ||
| 92836 | 92836 | 66410 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 215 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29537 | 6006834.65063243 | 2097892.2183021 | 37.7407989810342 | -122.41894270680599 | (37.7407989810342, -122.418942706806) | ||
| 139980 | 139980 | 66422 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 318 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29562 | 6008608.07683168 | 2097239.74786096 | 37.7391071412781 | -122.412764727092 | (37.7391071412781, -122.412764727092) | ||
| 144966 | 144966 | 66440 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 260 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1991 12:00:00 AM | Permit Number 29585 | 6006101.64636516 | 2096073.98831183 | 37.735765225297705 | -122.421348075821 | (37.7357652252977, -122.421348075821) | ||
| 142184 | 142184 | 52542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2006 12:00:00 AM | Permit Number 48640 | 6000058.65812884 | 2094126.3356256 | 37.7300748692234 | -122.44210122198 | (37.7300748692234, -122.44210122198) | ||
| 10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
| 20492 | 20492 | 65549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28448 | 5995107.08134396 | 2097533.05659271 | 37.739145462122394 | -122.45946595668998 | (37.7391454621224, -122.45946595669) | ||
| 48382 | 48382 | 65548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 335 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28447 | 5995087.51239517 | 2097484.61184976 | 37.7390113196181 | -122.459530109112 | (37.7390113196181, -122.459530109112) | ||
| 78862 | 78862 | 65551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 289 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28450 | 5995479.90221927 | 2097471.34821385 | 37.7389974556715 | -122.458172454258 | (37.7389974556715, -122.458172454258) | ||
| 103809 | 103809 | 69049 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1254 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33056 | 5992714.6904429 | 2106926.63267056 | 37.764799947869896 | -122.468420924888 | (37.7647999478699, -122.468420924888) | ||
| 108544 | 108544 | 69081 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1314 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33089 | 5992108.89176667 | 2106483.01002587 | 37.7635468677256 | -122.470483894827 | (37.7635468677256, -122.470483894827) | ||
| 108633 | 108633 | 69103 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1690 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33118 | 5992506.05958966 | 2103959.64747893 | 37.756641333600705 | -122.468926586807 | (37.7566413336007, -122.468926586807) | ||
| 116281 | 116281 | 69051 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1299 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33059 | 5992672.70701142 | 2106634.58171783 | 37.7639956280648 | -122.468544882617 | (37.7639956280648, -122.468544882617) | ||
| 127555 | 127555 | 69108 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1608 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33123 | 5992177.27339597 | 2104495.32958128 | 37.7580931749511 | -122.470102642882 | (37.7580931749511, -122.470102642882) | ||
| 100409 | 100409 | 64824 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25833 | 5999918.04659081 | 2109002.2102987 | 37.7709124032726 | -122.443655578467 | (37.7709124032726, -122.443655578467) | ||
| 138670 | 138670 | 64829 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 210 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/1989 12:00:00 AM | Permit Number 25838 | 6005199.34091186 | 2099052.25002657 | 37.7438919455215 | -122.42467950011299 | (37.7438919455215, -122.424679500113) | ||
| 9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
| 9949 | 9949 | 63390 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.734132412410396 | -122.416802921773 | (37.7341324124104, -122.416802921773) | |
| 78957 | 78957 | 49137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 79817 | 79817 | 49121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1560 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46253 | 5995746.37464462 | 2094397.74678667 | 37.730573402709396 | -122.457028858359 | (37.7305734027094, -122.457028858359) | ||
| 110676 | 110676 | 49130 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 145 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46259 | 5995112.54626124 | 2092443.49915855 | 37.725171091693 | -122.459078632454 | (37.725171091693, -122.459078632454) | ||
| 118253 | 118253 | 49138 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 122559 | 122559 | 49139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46263 | 5995223.85849165 | 2092714.15560614 | 37.7259206476516 | -122.458713425318 | (37.7259206476516, -122.458713425318) | ||
| 84167 | 84167 | 65569 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1990 12:00:00 AM | Permit Number 28468 | 5994962.63326065 | 2097359.26532523 | 37.7386599676525 | -122.459952803113 | (37.7386599676525, -122.459952803113) | ||
| 118683 | 118683 | 65568 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Robinhood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1990 12:00:00 AM | Permit Number 28467 | 5996102.29047936 | 2096655.31871922 | 37.7367925810786 | -122.455961556891 | (37.7367925810786, -122.455961556891) | ||
| 138873 | 138873 | 65571 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 345 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1990 12:00:00 AM | Permit Number 28470 | 5995064.98518651 | 2097496.37820835 | 37.7390423317852 | -122.459608849319 | (37.7390423317852, -122.459608849319) | ||
| 82888 | 82888 | 69140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2639 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33173 | 5984275.37028508 | 2097213.25013079 | 37.737638602389396 | -122.496892944046 | (37.7376386023894, -122.496892944046) | ||
| 113916 | 113916 | 66969 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 53 Annapolis Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | Permit Number 30309 | 5998721.09196837 | 2111602.82199974 | 37.777984675846604 | -122.447983128321 | (37.7779846758466, -122.447983128321) | ||
| 103630 | 103630 | 63258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1591 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1987 12:00:00 AM | Permit Number 23811 | 6008775.48008244 | 2099672.80731064 | 37.74579718233829 | -122.412357848078 | (37.7457971823383, -122.412357848078) | ||
| 18082 | 18082 | 62490 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 52 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22661 | 6000842.2540014 | 2092843.5185791 | 37.7265971735996 | -122.439300325407 | (37.7265971735996, -122.439300325407) | ||
| 80035 | 80035 | 62481 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22652 | 6000572.53796355 | 2092891.28194987 | 37.726712968457605 | -122.44023614535601 | (37.7267129684576, -122.440236145356) | ||
| 81269 | 81269 | 62483 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 80 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22654 | 6000518.46428182 | 2092901.19185659 | 37.7267370999864 | -122.44042378634899 | (37.7267370999864, -122.440423786349) | ||
| 96121 | 96121 | 62491 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22662 | 6000832.53429315 | 2092825.94950247 | 37.7265483798144 | -122.43933266722601 | (37.7265483798144, -122.439332667226) | ||
| 101891 | 101891 | 62493 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22665 | 6000779.07591999 | 2092729.31962121 | 37.7262800139415 | -122.439510546397 | (37.7262800139415, -122.439510546397) | ||
| 106265 | 106265 | 62485 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 294 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22656 | 5999878.28397028 | 2092047.35169708 | 37.724356179134205 | -122.442575585932 | (37.7243561791342, -122.442575585932) | ||
| 116365 | 116365 | 62497 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 130 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22669 | 6000642.74847109 | 2092487.44183284 | 37.7256081131818 | -122.439964486743 | (37.7256081131818, -122.439964486743) | ||
| 127860 | 127860 | 62480 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 71 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22651 | 6000586.99465063 | 2092917.02407193 | 37.7267844734873 | -122.44018801433799 | (37.7267844734873, -122.440188014338) | ||
| 138748 | 138748 | 62482 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 78 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22653 | 6000523.38358106 | 2092909.95134628 | 37.726761431636206 | -122.44040740846701 | (37.7267614316362, -122.440407408467) | ||
| 140611 | 140611 | 62494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 84 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | Permit Number 22666 | 6000764.49636206 | 2092702.9660143002 | 37.7262068231921 | -122.439559058681 | (37.7262068231921, -122.439559058681) | ||
| 125234 | 125234 | 35069 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1616 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38623 | 5992799.70916091 | 2104452.91029535 | 37.758012666225795 | -122.46794692621799 | (37.7580126662258, -122.467946926218) | ||
| 128225 | 128225 | 35087 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1594 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38628 | 5992484.06042474 | 2104613.58351728 | 37.758435599993796 | -122.469050257237 | (37.7584355999938, -122.469050257237) | ||
| 84772 | 84772 | 47013 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 445 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/2004 12:00:00 AM | Permit Number 47268 | 6004844.28922352 | 2110353.57072253 | 37.7749026438811 | -122.426711818296 | (37.7749026438811, -122.426711818296) | ||
| 108252 | 108252 | 63308 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3288 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1987 12:00:00 AM | Permit Number 23874 | 6009003.12193192 | 2099538.14743591 | 37.7454402078374 | -122.411561179774 | (37.7454402078374, -122.411561179774) | ||
| 95104 | 95104 | 69198 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1332 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33246 | 6009506.45493301 | 2101407.14916638 | 37.7506002941539 | -122.40995264198799 | (37.7506002941539, -122.409952641988) | ||
| 119387 | 119387 | 69207 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2880 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33256 | 6008958.68090087 | 2101691.96012023 | 37.7513516058174 | -122.41186701927201 | (37.7513516058174, -122.411867019272) | ||
| 99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
| 126999 | 126999 | 30734 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34629 | 6005251.19976575 | 2109714.98569866 | 37.7731722414546 | -122.42525877680299 | (37.7731722414546, -122.425258776803) | ||
| 169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
| 59112 | 59112 | 40021 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1530 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41266 | 6015759.6141 | 2095683.1757 | 37.73523191912879 | -122.387929152323 | (37.7352319191288, -122.387929152323) | |
| 159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
| 35596 | 35596 | 79919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 4 | 5988008.149 | 2106155.0675 | 37.762408463106496 | -122.484642830378 | (37.7624084631065, -122.484642830378) | ||
| 53614 | 53614 | 65608 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 235 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28512 | 6004926.15006729 | 2093819.12850558 | 37.729507538818105 | -122.42525182613899 | (37.7295075388181, -122.425251826139) | ||
| 96892 | 96892 | 30797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.43736957803301 | (37.7319310278176, -122.437369578033) | ||
| 85461 | 85461 | 63360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 439 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/1987 12:00:00 AM | Permit Number 23936 | 6006621.98352864 | 2096227.12425079 | 37.7362150256385 | -122.41955992485701 | (37.7362150256385, -122.419559924857) | ||
| 102465 | 102465 | 63359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 501 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/1987 12:00:00 AM | Permit Number 23935 | 6006439.99775536 | 2096179.59381712 | 37.7360742650957 | -122.42018575343 | (37.7360742650957, -122.42018575343) | ||
| 115820 | 115820 | 63365 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/1987 12:00:00 AM | Permit Number 23941 | 6006593.62756603 | 2096993.58280785 | 37.738317953502495 | -122.419712329736 | (37.7383179535025, -122.419712329736) | ||
| 106362 | 106362 | 63391 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23973 | 6007362.25372718 | 2095569.53690165 | 37.7344511049224 | -122.416953922764 | (37.7344511049224, -122.416953922764) | ||
| 122801 | 122801 | 63389 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 726 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1987 12:00:00 AM | Permit Number 23971 | 6007359.69446987 | 2095542.20416987 | 37.734375911263896 | -122.41696083504 | (37.7343759112639, -122.41696083504) | ||
| 85561 | 85561 | 46331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.42418576450599 | (37.7740799306106, -122.424185764506) | ||
| 86983 | 86983 | 46332 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.42418576450599 | (37.7740799306106, -122.424185764506) | ||
| 122585 | 122585 | 46333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/2002 12:00:00 AM | Permit Number 44582 | 6005568.06039934 | 2110039.04677053 | 37.7740799306106 | -122.42418576450599 | (37.7740799306106, -122.424185764506) | ||
| 20288 | 20288 | 34981 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 336 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41309 | 6003431.10233151 | 2104509.78972726 | 37.758777041212895 | -122.43118312363 | (37.7587770412129, -122.43118312363) | ||
| 79778 | 79778 | 63421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 216 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 24005 | 6008985.00081085 | 2097389.20642275 | 37.7395386707954 | -122.411472046568 | (37.7395386707954, -122.411472046568) | ||
| 111053 | 111053 | 63417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 706 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 24000 | 6007372.49075294 | 2095678.86779124 | 37.7347518794395 | -122.416926273529 | (37.7347518794395, -122.416926273529) | ||
| 123041 | 123041 | 63416 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 717 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 23999 | 6007411.7239366 | 2095540.0897166 | 37.734373032030796 | -122.416780802008 | (37.7343730320308, -122.416780802008) | ||
| 139449 | 139449 | 63423 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 211 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1987 12:00:00 AM | Permit Number 24007 | 6009039.92177185 | 2097418.32937883 | 37.7396217164675 | -122.411284209778 | (37.7396217164675, -122.411284209778) | ||
| 97763 | 97763 | 35322 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 49 Linda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38789 | 6005852.21106696 | 2105212.1045171 | 37.7608423361385 | -122.422859715874 | (37.7608423361385, -122.422859715874) | ||
| 121383 | 121383 | 35316 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 35 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1998 12:00:00 AM | Permit Number 38783 | 6005325.48380511 | 2105726.64654552 | 37.762225412761204 | -122.42471803865699 | (37.7622254127612, -122.424718038657) |
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");