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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102467 | 102467 | 105032 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 102904 | 102904 | 34272 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 105384 | 105384 | 55357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | |||
| 105518 | 105518 | 39927 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | |||
| 105593 | 105593 | 31773 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) | ||
| 106270 | 106270 | 34269 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.48837297696699 | (37.7872778329962, -122.488372976967) | ||
| 108977 | 108977 | 99385 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 109705 | 109705 | 102257 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 2 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 110341 | 110341 | 99386 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 110478 | 110478 | 30583 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 111098 | 111098 | 50485 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.720405949717104 | -122.45400837564699 | (37.7204059497171, -122.454008375647) | ||
| 111793 | 111793 | 93854 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875.0 | 2103807.0 | 37.7561278331456 | -122.47455618324601 | (37.7561278331456, -122.474556183246) | ||
| 111844 | 111844 | 37577 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | ||
| 111896 | 111896 | 63101 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.759851779436495 | -122.439687471955 | (37.7598517794365, -122.439687471955) | ||
| 111944 | 111944 | 16905 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258573996 | -122.426579447402 | (37.774305258574, -122.426579447402) | ||
| 112798 | 112798 | 99381 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113044 | 113044 | 99398 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113645 | 113645 | 97286 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768450 | 5993053.0 | 2098535.0 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | |||
| 114236 | 114236 | 30585 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | |||
| 114337 | 114337 | 99387 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 115563 | 115563 | 101359 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.41329507143601 | (37.803771736238, -122.413295071436) | ||
| 115661 | 115661 | 99395 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 115996 | 115996 | 45704 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2923 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 44378 | 6009338.32453862 | 2102737.8165792 | 37.7542445851646 | -122.41062801127701 | (37.7542445851646, -122.410628011277) | ||
| 116693 | 116693 | 37466 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | ||
| 117450 | 117450 | 108296 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 117577 | 117577 | 31772 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 118595 | 118595 | 104724 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | |||
| 119172 | 119172 | 4547 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 119383 | 119383 | 108297 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 119869 | 119869 | 30569 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | ||
| 120187 | 120187 | 36895 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39548 | 6001738.91463484 | 2103541.42716619 | 37.7560221127265 | -122.436966152078 | (37.7560221127265, -122.436966152078) | ||
| 120267 | 120267 | 27626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2310X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008495.093859999 | 2120769.31703 | 37.8037074748624 | -122.41482018433399 | (37.8037074748624, -122.414820184334) | |||
| 120563 | 120563 | 34888 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 252 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774542 | 5990895.02345 | 2113704.92636 | 37.7833060185493 | -122.475209503253 | (37.7833060185493, -122.475209503253) | |
| 122986 | 122986 | 38679 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.776624556634495 | -122.439428187036 | (37.7766245566345, -122.439428187036) | ||
| 123726 | 123726 | 35235 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | |
| 125055 | 125055 | 48453 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 5 | Permit Number 45822 | 5996008.37556 | 2113838.92432 | 37.7839689836389 | -122.45752914479601 | (37.7839689836389, -122.457529144796) | ||
| 125957 | 125957 | 108295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 126804 | 126804 | 44213 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | ||
| 127076 | 127076 | 45705 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.41055749570499 | (37.754248802934, -122.410557495705) | ||
| 128972 | 128972 | 108294 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | |||
| 130376 | 130376 | 84614 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | |
| 131178 | 131178 | 66298 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | |
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 132763 | 132763 | 48667 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.788997318923705 | -122.44815975037599 | (37.7889973189237, -122.448159750376) | ||
| 134345 | 134345 | 32357 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452058998 | (37.7959569797808, -122.40333452059) | ||
| 135774 | 135774 | 39858 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | |
| 136981 | 136981 | 37644 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.460530001 | 2111993.16181 | 37.7785610650821 | -122.47776398494499 | (37.7785610650821, -122.477763984945) | |
| 137045 | 137045 | 57079 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 2 | Permit Number 14346 | 5990318.78395 | 2111097.03664 | 37.7761120602541 | -122.477012417523 | (37.7761120602541, -122.477012417523) | ||
| 137702 | 137702 | 105030 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015079.85403 | 2108063.37025 | 37.769187632923604 | -122.391144425184 | (37.7691876329236, -122.391144425184) | |||
| 138266 | 138266 | 109806 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.47047998805401 | (37.764483341532, -122.470479988054) |
| 142142 | 142142 | 99394 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 143244 | 143244 | 34271 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.48837581666099 | (37.7872024288867, -122.488375816661) | ||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 145061 | 145061 | 31775 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | ||
| 145313 | 145313 | 64085 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | |||
| 146723 | 146723 | 48452 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | ||
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 148905 | 148905 | 99379 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 154293 | 154293 | 46268 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2436 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2002 12:00:00 AM | 3 | Permit Number 44552 | 5986405.9288 | 2102348.8049 | 37.7518640711658 | -122.489904286753 | (37.7518640711658, -122.489904286753) | ||
| 155800 | 155800 | 53889 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1009 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1972 12:00:00 AM | 6 | Permit Number 9600 | 6011157.21659 | 2090045.52637 | 37.7194960599821 | -122.403444914172 | (37.7194960599821, -122.403444914172) | ||
| 156039 | 156039 | 31965 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.41572900131099 | (37.7987324288073, -122.415729001311) | |||
| 156592 | 156592 | 82944 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.0816099998 | 37.775679873857605 | -122.4111129656 | (37.7756798738576, -122.4111129656) | |
| 157758 | 157758 | 34595 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 224 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 3 | Permit Number 38290 | 5999049.11331 | 2115811.8927599997 | 37.7895604321171 | -122.447151385541 | (37.7895604321171, -122.447151385541) | |
| 162169 | 162169 | 101345 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.803736447762795 | -122.413855954453 | (37.8037364477628, -122.413855954453) | ||
| 162829 | 162829 | 51087 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.42029985774799 | (37.7966452201661, -122.420299857748) | ||
| 164170 | 164170 | 62984 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | |
| 164372 | 164372 | 111668 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2200 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3PL | 6004109.02078 | 2116034.23701 | 37.790458739741 | -122.429660507029 | (37.790458739741, -122.429660507029) | |||
| 164481 | 164481 | 31363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.007780001 | 2099881.4668 | 37.7453573397732 | -122.47379254479799 | (37.7453573397732, -122.473792544798) | ||
| 164682 | 164682 | 37224 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1340 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39788 | 5985571.0917 | 2106094.9849 | 37.7621012650414 | -122.49306716261101 | (37.7621012650414, -122.493067162611) | |
| 167301 | 167301 | 35008 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50542 | 5999619.6658 | 2114602.5127 | 37.7862723736076 | -122.445090361129 | (37.7862723736076, -122.445090361129) | |
| 170367 | 170367 | 105028 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.92484 | 2108113.3475599997 | 37.7693247525719 | -122.391154592016 | (37.7693247525719, -122.391154592016) | |||
| 170548 | 170548 | 103458 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 212 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769919 | 5999039.39992 | 2115859.35215 | 37.789690188098504 | -122.447188409728 | (37.7896901880985, -122.447188409728) | |
| 172150 | 172150 | 94214 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.016969999 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | |
| 173107 | 173107 | 54086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.791677270739896 | -122.433147915142 | (37.7916772707399, -122.433147915142) | ||
| 174307 | 174307 | 31774 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.74116041508079 | -122.477740406961 | (37.7411604150808, -122.477740406961) | |
| 175556 | 175556 | 30703 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 2 | Permit Number 34614 | 6005258.9715 | 2110239.8029 | 37.7746137012839 | -122.425269246 | (37.7746137012839, -122.425269246) | |
| 175622 | 175622 | 37630 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.694519999 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | |
| 178509 | 178509 | 106106 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 708 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011765.54028 | 2117816.6633 | 37.7957834196109 | -122.403294730072 | (37.7957834196109, -122.403294730072) | ||||
| 179336 | 179336 | 82943 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.5860099997 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | |
| 180047 | 180047 | 35838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 524 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 6 | Permit Number 39065 | 6001524.77874 | 2090714.46307 | 37.7207900854698 | -122.436788524592 | (37.7207900854698, -122.436788524592) | |
| 182969 | 182969 | 48451 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.783965291128204 | -122.457709472605 | (37.7839652911282, -122.457709472605) | ||
| 183393 | 183393 | 50456 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171001 | (37.7596818177679, -122.38931576171) | ||
| 184585 | 184585 | 56604 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1914 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5999483.43623 | 2115589.8774599996 | 37.788975642546 | -122.445632707581 | (37.788975642546, -122.445632707581) | ||||
| 184877 | 184877 | 31769 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | ||
| 184974 | 184974 | 42710 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) |
| 185179 | 185179 | 61519 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1161 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1984 12:00:00 AM | 7 | Permit Number 21475 | 6007368.68612 | 2119491.86468 | 37.8001365583177 | -122.418627544125 | (37.8001365583177, -122.418627544125) | ||
| 188601 | 188601 | 37092 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | |
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 5667 | 5667 | 102263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2037 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001878.76288 | 2115606.3786400002 | 37.78915741351871 | -122.437346392945 | (37.7891574135187, -122.437346392945) | |||
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 23366 | 23366 | 227653 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.43128265198901 | (37.7563447763019, -122.431282651989) | |||
| 23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
| 23772 | 23772 | 191299 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.767180280481895 | -122.390754301979 | (37.7671802804819, -122.390754301979) | |||
| 23969 | 23969 | 176943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 19 Lois Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6012322.95001 | 2087866.52725 | 37.713578008300296 | -122.39926249466801 | (37.7135780083003, -122.399262494668) | |||
| 24380 | 24380 | 129424 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6003346.86179 | 2117886.37825 | 37.7955010594853 | -122.43242986946699 | (37.7955010594853, -122.432429869467) | |||
| 25932 | 25932 | 207066 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993124.54928 | 2098622.04482 | 37.7420213577054 | -122.46639972369101 | (37.7420213577054, -122.466399723691) | |||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) |
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");