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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95135 | 95135 | 50288 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 95217 | 95217 | 50293 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 96489 | 96489 | 50428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399168998 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | ||
| 96706 | 96706 | 52103 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | ||
| 97029 | 97029 | 33402 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 377 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37520 | 5992522.58969687 | 2094276.01733921 | 37.730053504422 | -122.468165013068 | (37.730053504422, -122.468165013068) | ||
| 98101 | 98101 | 47351 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | ||
| 98528 | 98528 | 47604 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | ||
| 98542 | 98542 | 12918 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 98932 | 98932 | 52980 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.720303313737105 | -122.467252978798 | (37.7203033137371, -122.467252978798) | ||
| 99225 | 99225 | 46761 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.725156404551896 | -122.421056498489 | (37.7251564045519, -122.421056498489) | |||
| 99862 | 99862 | 67131 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.761576666998295 | -122.463010486718 | (37.7615766669983, -122.463010486718) | ||
| 99949 | 99949 | 82598 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3503 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006166.2666895995 | 2102562.46439955 | 37.7535847553547 | -122.42158534476499 | (37.7535847553547, -122.421585344765) | ||
| 100529 | 100529 | 9277 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2161X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000049.092019999 | 2089751.6792400002 | 37.7180625213905 | -122.44182044273701 | (37.7180625213905, -122.441820442737) | |||
| 100951 | 100951 | 50290 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
| 101609 | 101609 | 43632 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | ||
| 102346 | 102346 | 50292 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
| 103188 | 103188 | 32605 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) | ||
| 103787 | 103787 | 50490 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | ||
| 104926 | 104926 | 45431 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 105136 | 105136 | 18878 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6003659.521319999 | 2115878.15996 | 37.7900047293604 | -122.43120460047501 | (37.7900047293604, -122.431204600475) | |||
| 105148 | 105148 | 52497 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 371 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48606 | 6007135.79724675 | 2096038.97616324 | 37.7357273409345 | -122.417770123047 | (37.7357273409345, -122.417770123047) | ||
| 105417 | 105417 | 45429 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 105491 | 105491 | 31546 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.44919042402901 | (37.7809035197163, -122.449190424029) | |
| 107598 | 107598 | 82810 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.735965062583205 | -122.500898621502 | (37.7359650625832, -122.500898621502) | ||
| 107841 | 107841 | 50489 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47126 | 5995378.87438655 | 2091597.86421043 | 37.722864487352 | -122.458096796728 | (37.722864487352, -122.458096796728) | ||
| 107992 | 107992 | 45360 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 458 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46747 | 5993277.37926203 | 2090218.01876098 | 37.718954793548605 | -122.46526098645 | (37.7189547935486, -122.46526098645) | ||
| 108311 | 108311 | 47453 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | ||
| 108468 | 108468 | 1383 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2550X Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X2 | 6002248.65699 | 2096984.18535 | 37.7380464314256 | -122.434734413124 | (37.7380464314256, -122.434734413124) | |||
| 109767 | 109767 | 47881 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419004 | -122.50255124802099 | (37.759547805419, -122.502551248021) | ||
| 110211 | 110211 | 31168 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 570 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34869 | 5993027.58275469 | 2090995.29108117 | 37.7210745862886 | -122.466180882741 | (37.7210745862886, -122.466180882741) | ||
| 110567 | 110567 | 51442 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 775 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47761 | 6007380.25742092 | 2095203.71769531 | 37.7334476580973 | -122.41686576869301 | (37.7334476580973, -122.416865768693) | ||
| 110762 | 110762 | 68097 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31842 | 6008240.85722104 | 2100065.07433688 | 37.746844244689605 | -122.414234251858 | (37.7468442446896, -122.414234251858) | ||
| 112441 | 112441 | 24808 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.49562310699899 | (37.7794670623637, -122.495623106999) | ||
| 113611 | 113611 | 84886 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290.0 | 2099514.0 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | |||
| 113922 | 113922 | 50423 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 75 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47076 | 5995600.08487961 | 2090390.5729411999 | 37.7195622602365 | -122.45724482931699 | (37.7195622602365, -122.457244829317) | ||
| 114397 | 114397 | 35418 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 115064 | 115064 | 105256 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 162 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771043 | 6004383.3 | 2090213.9 | 37.7195776934466 | -122.42687185683998 | (37.7195776934466, -122.42687185684) | ||
| 115167 | 115167 | 47225 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1643 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45170 | 6006193.94874397 | 2092417.83045771 | 37.7257314225765 | -122.42076946999399 | (37.7257314225765, -122.420769469994) | ||
| 115428 | 115428 | 36089 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44997 | 5981032.08177403 | 2103436.82774177 | 37.754536221771204 | -122.508568229446 | (37.7545362217712, -122.508568229446) | ||
| 115918 | 115918 | 34621 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 370 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2016 12:00:00 AM | 3 | Permit Number 778228 | 6003497.10528776 | 2099542.95496323 | 37.7451430220882 | -122.430600441889 | (37.7451430220882, -122.430600441889) | |
| 117463 | 117463 | 46381 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2495 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.740172110361705 | -122.501371213543 | (37.7401721103617, -122.501371213543) | ||
| 117712 | 117712 | 26830 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3590X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 8 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | ||
| 119851 | 119851 | 34725 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | ||
| 120269 | 120269 | 85386 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | ||||
| 121074 | 121074 | 117519 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 121341 | 121341 | 46382 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.740172110361705 | -122.501371213543 | (37.7401721103617, -122.501371213543) | ||
| 122120 | 122120 | 36328 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 40 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1998 12:00:00 AM | Permit Number 39300 | 5995640.5044713 | 2092769.77027097 | 37.7260972907371 | -122.457277138944 | (37.7260972907371, -122.457277138944) | ||
| 122500 | 122500 | 115975 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006168.0 | 2102576.0 | 37.7536220187283 | -122.421580311855 | (37.7536220187283, -122.421580311855) | |||
| 122863 | 122863 | 50817 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2004 12:00:00 AM | Permit Number 47340 | 5995605.94135709 | 2094497.43585496 | 37.7308390591092 | -122.457521563876 | (37.7308390591092, -122.457521563876) | ||||
| 122974 | 122974 | 79279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | ||
| 123140 | 123140 | 40483 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 165 Margaret Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41562 | 5996732.70371963 | 2089259.1130924 | 37.716520521088796 | -122.45324815845699 | (37.7165205210888, -122.453248158457) | ||
| 123353 | 123353 | 44124 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | |||
| 123652 | 123652 | 45430 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 851 Head St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44219 | 5993920.58856776 | 2091576.5612161 | 37.72272209583179 | -122.463136201451 | (37.7227220958318, -122.463136201451) | ||
| 123731 | 123731 | 227678 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6003889.89165 | 2099268.52237 | 37.744411737711296 | -122.42922269007799 | (37.7444117377113, -122.429222690078) | |||
| 126023 | 126023 | 40449 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 255 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47061 | 6008102.60669454 | 2097399.44811028 | 37.7395172589666 | -122.414523716357 | (37.7395172589666, -122.414523716357) | ||
| 126240 | 126240 | 31667 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2571 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1995 12:00:00 AM | Permit Number 35175 | 5981777.56166178 | 2097600.02639588 | 37.7385539042174 | -122.505557573977 | (37.7385539042174, -122.505557573977) | ||
| 126667 | 126667 | 50289 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 127237 | 127237 | 50114 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1252 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46839 | 5992244.12505327 | 2098460.15223335 | 37.7415260004029 | -122.469432140867 | (37.7415260004029, -122.469432140867) | ||
| 127621 | 127621 | 54526 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.9232400004 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | ||
| 127692 | 127692 | 63441 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 299 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 24028 | 6008993.82853707 | 2096920.83270323 | 37.738253113659 | -122.411408443517 | (37.738253113659, -122.411408443517) | ||
| 128740 | 128740 | 69291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 830 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1994 12:00:00 AM | Permit Number 33363 | 5991479.92264349 | 2102518.55863113 | 37.752625141975706 | -122.472370253301 | (37.7526251419757, -122.472370253301) | ||
| 128843 | 128843 | 47111 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45095 | 6007076.38254046 | 2097931.15674799 | 37.740919506174706 | -122.41810964654499 | (37.7409195061747, -122.418109646545) |
| 129606 | 129606 | 80358 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 3 | 6011201.39619 | 2088230.4496900002 | 37.714514695375705 | -122.403164591892 | (37.7145146953757, -122.403164591892) | ||
| 130073 | 130073 | 227688 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 269 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007769.10714 | 2097866.49845 | 37.740780934479794 | -122.41570987722 | (37.7407809344798, -122.41570987722) | |||
| 130081 | 130081 | 207105 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995373.148580001 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | |||
| 130724 | 130724 | 227681 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997959.25406 | 2106183.4369900003 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | |||
| 133879 | 133879 | 227670 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005513.924819999 | 2101330.09926 | 37.7501641603604 | -122.423753669923 | (37.7501641603604, -122.423753669923) | |||
| 133901 | 133901 | 51414 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1531 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | 0 | Permit Number 47738 | 5988357.88494646 | 2104888.81015522 | 37.7589520258954 | -122.48334041038 | (37.7589520258954, -122.48334041038) | |
| 135684 | 135684 | 183373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.736548599668104 | -122.492356136884 | (37.7365485996681, -122.492356136884) | |||
| 136036 | 136036 | 129466 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.791858285382105 | -122.425769315008 | (37.7918582853821, -122.425769315008) | |||
| 136946 | 136946 | 244098 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.770831393246496 | -122.44746952816901 | (37.7708313932465, -122.447469528169) | |||
| 137935 | 137935 | 176980 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2315 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 5999548.7624699995 | 2089280.82364 | 37.716741137071295 | -122.443516055124 | (37.7167411370713, -122.443516055124) | |||
| 138680 | 138680 | 36317 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 208 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 3x3 | Permit Number 51552 | 5996115.78800404 | 2094224.07875239 | 37.730117759471895 | -122.455739200241 | (37.7301177594719, -122.455739200241) | ||
| 139074 | 139074 | 63714 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1997 12:00:00 AM | Permit Number 24378 | 6007857.54148412 | 2100263.37846132 | 37.7473672046192 | -122.41557376317499 | (37.7473672046192, -122.415573763175) | ||
| 139249 | 139249 | 16565 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5999593.35864 | 2089327.05238 | 37.716870613942795 | -122.443365227339 | (37.7168706139428, -122.443365227339) | |||
| 140587 | 140587 | 31580 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1841 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35119 | 5989049.89925793 | 2102807.07383274 | 37.75327638601021 | -122.48079472188999 | (37.7532763860102, -122.48079472189) | ||
| 140815 | 140815 | 16566 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5999574.07501 | 2089304.05837 | 37.716806377922104 | -122.44343023048201 | (37.7168063779221, -122.443430230482) | |||
| 141290 | 141290 | 48774 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 629 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47773 | 6007825.24973386 | 2095718.75627166 | 37.7348868619711 | -122.415363748684 | (37.7348868619711, -122.415363748684) | ||
| 142094 | 142094 | 109138 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.401319999 | 2110729.9835 | 37.7748156320332 | -122.49412018624099 | (37.7748156320332, -122.494120186241) |
| 142319 | 142319 | 24738 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5983089.132019999 | 2112566.68135 | 37.7797252106941 | -122.502130088809 | (37.7797252106941, -122.502130088809) | ||
| 143225 | 143225 | 47963 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 558 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45693 | 5996827.75466141 | 2095403.22069376 | 37.73339623393571 | -122.453362951949 | (37.7333962339357, -122.453362951949) | ||
| 143336 | 143336 | 58925 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3925 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | Permit Number 18201 | 5982715.08927534 | 2104886.86517056 | 37.7586166666309 | -122.502855377053 | (37.7586166666309, -122.502855377053) | ||
| 143583 | 143583 | 34718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | ||
| 143931 | 143931 | 82814 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | ||
| 144076 | 144076 | 889 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1136X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6003353.033430001 | 2094335.58352 | 37.7308366096666 | -122.43072708407401 | (37.7308366096666, -122.430727084074) | |||
| 144258 | 144258 | 35419 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.45969708953301 | (37.7562443131302, -122.459697089533) | |||
| 145098 | 145098 | 68368 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 194 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | Permit Number 32189 | 6002712.41508002 | 2094283.54436078 | 37.730657406687 | -122.432938086411 | (37.730657406687, -122.432938086411) | ||
| 145101 | 145101 | 50291 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | ||
| 145200 | 145200 | 109133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773526 | 5985442.4 | 2110611.6 | 37.7744950899459 | -122.493845109753 | (37.7744950899459, -122.493845109753) |
| 145765 | 145765 | 68315 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3820 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32128 | 5981623.22584135 | 2100818.01716678 | 37.7473805290726 | -122.506329747472 | (37.7473805290726, -122.506329747472) | ||
| 146129 | 146129 | 49012 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | Permit Number 46198 | 6003561.60300767 | 2099494.42119752 | 37.7450134133041 | -122.430373957908 | (37.7450134133041, -122.430373957908) | |||
| 150971 | 150971 | 52086 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 550 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2005 12:00:00 AM | 7 | Permit Number 48283 | 5982264.87127 | 2112012.82882 | 37.7781560348973 | -122.50494046388201 | (37.7781560348973, -122.504940463882) | |
| 151013 | 151013 | 118250 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985366.8002 | 2110712.8219999997 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | |||
| 154916 | 154916 | 37082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.762934408685396 | -122.504939947841 | (37.7629344086854, -122.504939947841) | |
| 155355 | 155355 | 32594 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1379 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37062 | 5985531.05347187 | 2105840.85496484 | 37.76140115330671 | -122.49318691517 | (37.7614011533067, -122.49318691517) | |
| 158119 | 158119 | 46395 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.74756255280229 | -122.505118527994 | (37.7475625528023, -122.505118527994) | |
| 159182 | 159182 | 78557 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | |
| 159286 | 159286 | 191372 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011446.77315 | 2104664.6622599997 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | |||
| 160532 | 160532 | 38367 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 5 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
| 161309 | 161309 | 207102 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990480.890819999 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) |
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");