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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39185 | 39185 | 191296 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014597.305819999 | 2110326.98215 | 37.7753762177666 | -122.392971942918 | (37.7753762177666, -122.392971942918) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 40498 | 40498 | 129411 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2111 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003275.408009999 | 2116033.9816799997 | 37.790410801365105 | -122.43254473354901 | (37.7904108013651, -122.432544733549) | |||
| 41237 | 41237 | 207083 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1959 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992235.15443 | 2102157.44312 | 37.7516772939722 | -122.469732265856 | (37.7516772939722, -122.469732265856) | |||
| 41440 | 41440 | 191311 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.76846592338129 | -122.39087719613501 | (37.7684659233813, -122.390877196135) | |||
| 41678 | 41678 | 227637 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6006174.20556 | 2101172.48753 | 37.7497686457084 | -122.421459183712 | (37.7497686457084, -122.421459183712) | |||
| 41714 | 41714 | 115987 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 499 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011766.1004 | 2118039.4815599998 | 37.7963952562896 | -122.40330847443 | (37.7963952562896, -122.40330847443) | |||
| 42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
| 42271 | 42271 | 207076 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | |||
| 42869 | 42869 | 129448 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008230.449580001 | 2115909.44994 | 37.79034861235171 | -122.415391745646 | (37.7903486123517, -122.415391745646) | |||
| 43089 | 43089 | 46211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.43261542476299 | (37.7915512424562, -122.432615424763) | ||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 43673 | 43673 | 247493 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 806 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002649.6994 | 2109575.8819 | 37.7726429829887 | -122.434247750607 | (37.7726429829887, -122.434247750607) | |||
| 43823 | 43823 | 191356 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.39098263356199 | (37.7674880383618, -122.390982633562) | |||
| 43921 | 43921 | 227634 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3238 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008149.92124 | 2100968.79152 | 37.7493205414166 | -122.414612642259 | (37.7493205414166, -122.414612642259) | |||
| 44145 | 44145 | 191295 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6014582.55786 | 2110345.63689 | 37.7754266202868 | -122.393024265473 | (37.7754266202868, -122.393024265473) | |||
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 44196 | 44196 | 129400 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) | |||
| 44547 | 44547 | 191291 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6014507.50601 | 2110409.04953 | 37.7755965678638 | -122.39328832798701 | (37.7755965678638, -122.393288327987) | |||
| 44629 | 44629 | 129403 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | |||
| 44632 | 44632 | 176950 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012544.33708 | 2087727.46225 | 37.7132084993531 | -122.398487544387 | (37.7132084993531, -122.398487544387) | |||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 45223 | 45223 | 129442 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6010104.97756 | 2114284.6760299997 | 37.785992551769795 | -122.408791302782 | (37.7859925517698, -122.408791302782) | |||
| 45275 | 45275 | 227654 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004930.05045 | 2104005.07306 | 37.7574760371124 | -122.42596313868201 | (37.7574760371124, -122.425963138682) | |||
| 45357 | 45357 | 120682 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2917 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5989597.69972 | 2111917.78775 | 37.7783237566214 | -122.479566877639 | (37.7783237566214, -122.479566877639) | |||
| 45384 | 45384 | 119342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.78070095968079 | -122.492222971302 | (37.7807009596808, -122.492222971302) | |||
| 45505 | 45505 | 176953 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012671.13481 | 2087736.7840599997 | 37.713241158228705 | -122.39804993876999 | (37.7132411582287, -122.39804993877) | |||
| 45787 | 45787 | 207074 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994502.2451599995 | 2100385.66213 | 37.7469432078786 | -122.46176397213301 | (37.7469432078786, -122.461763972133) | |||
| 45843 | 45843 | 31770 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990241.9611 | 2098396.6732 | 37.7412357933409 | -122.47635023030199 | (37.7412357933409, -122.476350230302) | ||
| 46075 | 46075 | 191248 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010994.55519 | 2105384.5641 | 37.7616046825239 | -122.405086676019 | (37.7616046825239, -122.405086676019) | |||
| 46195 | 46195 | 207077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | |||
| 46359 | 46359 | 129457 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | |||
| 46474 | 46474 | 129453 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007720.64474 | 2120576.4205400003 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | |||
| 46688 | 46688 | 207094 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 115 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994559.61163 | 2093655.1393099998 | 37.728466159762505 | -122.46107783977101 | (37.7284661597625, -122.461077839771) | |||
| 46965 | 46965 | 176936 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012351.49393 | 2087873.7751200001 | 37.713599500286 | -122.399164344459 | (37.713599500286, -122.399164344459) | |||
| 47568 | 47568 | 54838 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.773438741186204 | -122.44770637361201 | (37.7734387411862, -122.447706373612) | ||
| 47584 | 47584 | 97338 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.763424185107496 | -122.478477988866 | (37.7634241851075, -122.478477988866) | |||
| 47633 | 47633 | 129418 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003255.2303 | 2117874.11084 | 37.795462179980895 | -122.432746053085 | (37.7954621799809, -122.432746053085) | |||
| 47675 | 47675 | 176920 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 671 London St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6001061.12784 | 2089906.70665 | 37.718545806627205 | -122.43833338090299 | (37.7185458066272, -122.438333380903) | ||||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 47927 | 47927 | 227620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005907.97007 | 2102264.4901400004 | 37.752752018913796 | -122.422457421298 | (37.7527520189138, -122.422457421298) | |||
| 48721 | 48721 | 33958 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 15 | Permit Number 37913 | 6008590.6293 | 2120749.6774 | 37.8036589168384 | -122.414488187223 | (37.8036589168384, -122.414488187223) | ||
| 49002 | 49002 | 97113 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | |||
| 49285 | 49285 | 129456 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.41748965894199 | (37.803134284681, -122.417489658942) | |||
| 49423 | 49423 | 37645 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | |
| 49437 | 49437 | 227622 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 521 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 62 | Width 3ft | 6001670.93131 | 2100857.28025 | 37.748648223551 | -122.43700910221001 | (37.748648223551, -122.43700910221) | |||
| 49816 | 49816 | 207050 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1287 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990781.88485 | 2106644.27108 | 37.7639128285243 | -122.475085316637 | (37.7639128285243, -122.475085316637) | |||
| 49942 | 49942 | 105026 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015072.88546 | 2108163.93601 | 37.7694633776739 | -122.39117555971599 | (37.7694633776739, -122.391175559716) | |||
| 49968 | 49968 | 89660 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2849X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989791.50971 | 2111922.56539 | 37.7783481307856 | -122.47889677398099 | (37.7783481307856, -122.478896773981) | ||
| 51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
| 51167 | 51167 | 32295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.40312032520201 | (37.7661293203346, -122.403120325202) | ||
| 51298 | 51298 | 200113 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | |||
| 51341 | 51341 | 117943 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983766.08421 | 2109717.4045599997 | 37.7719416683068 | -122.499577617773 | (37.7719416683068, -122.499577617773) | |||
| 51582 | 51582 | 191305 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015162.58842 | 2107628.3532 | 37.767997762404 | -122.390827843133 | (37.767997762404, -122.390827843133) | |||
| 51890 | 51890 | 207058 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2480 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992066.66369 | 2098534.27865 | 37.7417192754352 | -122.470051132153 | (37.7417192754352, -122.470051132153) | |||
| 52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
| 52098 | 52098 | 207062 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.46675176060499 | (37.7435731145127, -122.466751760605) | |||
| 52561 | 52561 | 114222 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 2x2 | 6012512.59554 | 2087744.0784200002 | 37.713252355697605 | -122.398598420002 | (37.7132523556976, -122.398598420002) | |||
| 52608 | 52608 | 207096 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 447 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996040.3151 | 2096410.52388 | 37.7361168767915 | -122.456158138087 | (37.7361168767915, -122.456158138087) | |||
| 52761 | 52761 | 129417 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2129 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003236.15275 | 2117871.33798 | 37.795453484440706 | -122.432811866398 | (37.7954534844407, -122.432811866398) | |||
| 52869 | 52869 | 176964 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 329 Craut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 7ft | 6004071.94661 | 2093622.05007 | 37.728918110483 | -122.42819085295099 | (37.728918110483, -122.428190852951) | |||
| 53050 | 53050 | 245954 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 189 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998286.3355 | 2107663.1593 | 37.7671425117336 | -122.44920319850401 | (37.7671425117336, -122.449203198504) | |||
| 53363 | 53363 | 227639 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 326 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6006173.90943 | 2101141.69074 | 37.7496840680694 | -122.42145802088001 | (37.7496840680694, -122.42145802088) | |||
| 53384 | 53384 | 227624 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4283 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002006.21213 | 2101168.55205 | 37.749521953590396 | -122.43587197511499 | (37.7495219535904, -122.435871975115) | |||
| 53688 | 53688 | 191342 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015064.99922 | 2108338.84414 | 37.769943199256794 | -122.391215066031 | (37.7699431992568, -122.391215066031) | |||
| 53758 | 53758 | 191344 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015083.2703599995 | 2108014.27768 | 37.769053025099105 | -122.39112917626998 | (37.7690530250991, -122.39112917627) | |||
| 53819 | 53819 | 191340 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015061.94317 | 2108389.30473 | 37.7700815833249 | -122.39122916471001 | (37.7700815833249, -122.39122916471) | |||
| 54047 | 54047 | 176922 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003957.47292 | 2089506.6993599997 | 37.7176117887305 | -122.42829341070801 | (37.7176117887305, -122.428293410708) | |||
| 54202 | 54202 | 117939 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5983833.6821099995 | 2109720.9042700003 | 37.7719552435785 | -122.49934405400101 | (37.7719552435785, -122.499344054001) | |||
| 54300 | 54300 | 227606 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | ||||
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 54469 | 54469 | 57397 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.41518604372601 | (37.7903739066804, -122.415186043726) | ||
| 54686 | 54686 | 142249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.42668430629101 | (37.7763472473304, -122.426684306291) | |||
| 54938 | 54938 | 182961 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1901 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5990015.6611 | 2098388.4154 | 37.7411999929644 | -122.47713208357 | (37.7411999929644, -122.47713208357) | |||
| 55006 | 55006 | 35364 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.3243400003 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | |
| 55145 | 55145 | 129409 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.43258510502399 | (37.7906117953446, -122.432585105024) | |||
| 55147 | 55147 | 246315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | |||
| 55302 | 55302 | 191326 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015116.04644 | 2108440.3990700003 | 37.7702248795025 | -122.39104559238501 | (37.7702248795025, -122.391045592385) | |||
| 55487 | 55487 | 129414 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 Jackson St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001550.43955 | 2116611.49961 | 37.791898545338896 | -122.438554394686 | (37.7918985453389, -122.438554394686) | |||
| 55800 | 55800 | 227661 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003680.16981 | 2096890.8857099998 | 37.7378714190205 | -122.42977831104099 | (37.7378714190205, -122.429778311041) | |||
| 55812 | 55812 | 50231 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | |
| 56027 | 56027 | 191316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015137.82836 | 2108066.41916 | 37.7691992215952 | -122.39094410658899 | (37.7691992215952, -122.390944106589) | |||
| 56239 | 56239 | 191252 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.761806808764796 | -122.390723435452 | (37.7618068087648, -122.390723435452) | |||
| 56261 | 56261 | 227645 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 3801 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003027.84051 | 2103561.52563 | 37.7561504741859 | -122.432510056589 | (37.7561504741859, -122.432510056589) | |||
| 56287 | 56287 | 227611 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008811.16325 | 2101739.4503099998 | 37.751473726132005 | -122.412380510571 | (37.751473726132, -122.412380510571) | |||
| 56357 | 56357 | 43807 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.677999999 | 2112363.29745 | 37.7794807721264 | -122.48353979825899 | (37.7794807721264, -122.483539798259) | |
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 56470 | 56470 | 129438 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.790027121797294 | -122.409114812309 | (37.7900271217973, -122.409114812309) | |||
| 56561 | 56561 | 191262 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | |||
| 56909 | 56909 | 200009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.72596096442079 | -122.381063162948 | (37.7259609644208, -122.381063162948) | |||
| 56989 | 56989 | 191308 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015156.6298 | 2107712.6724 | 37.768228953839895 | -122.390854347073 | (37.7682289538399, -122.390854347073) | |||
| 57239 | 57239 | 31767 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1850 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | 2 | Permit Number 35249 | 5990299.8313 | 2098399.3806 | 37.741246583105294 | -122.47615033552201 | (37.7412465831053, -122.476150335522) | ||
| 57481 | 57481 | 35363 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1000 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 5 | Permit Number 38825 | 6011873.19867 | 2103659.8662799997 | 37.7569181237816 | -122.401926543791 | (37.7569181237816, -122.401926543791) | |
| 57506 | 57506 | 227659 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003786.3248 | 2109251.28052 | 37.771816154325 | -122.430292880621 | (37.771816154325, -122.430292880621) | |||
| 57630 | 57630 | 191251 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.39071814833599 | (37.7618193498029, -122.390718148336) | |||
| 57672 | 57672 | 119485 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5526 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5986205.51331 | 2109807.2757599996 | 37.772331260735605 | -122.49114618500799 | (37.7723312607356, -122.491146185008) | |||
| 58087 | 58087 | 191328 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015112.5325 | 2108491.8646 | 37.770365997518894 | -122.391061344907 | (37.7703659975189, -122.391061344907) | |||
| 58140 | 58140 | 141665 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.44778604353901 | (37.7801644097761, -122.447786043539) | |||
| 58227 | 58227 | 227613 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 210 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010812.412330001 | 2099853.77151 | 37.746408165199796 | -122.405327133143 | (37.7464081651998, -122.405327133143) |
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");